Roger’s Excel Thread - Page 2 - Antsmarching.org Forums - Dave Matthews Band Discussion
Old 03-03-2006, 11:38 AM   #31
rconverse
 
rconverse's Avatar
 
Join Date: May 2003
Location: Pretty Boy Blue State
Posts: 77,945

Shows Seen: 25

DMB Hub Stubs: 14

My Tour Central Stats

Re: Excel Help

I think it is just a photo. No underlying value or meaning.
rconverse is offline   Reply With Quote

  • Want to hide all ads on Ants? Click here
  • Old 03-03-2006, 11:39 AM   #32
    thebigv
    Carpe Poon
     
    thebigv's Avatar
     
    Join Date: Nov 2002
    Location: Chicago/Southport Corridor
    Posts: 3,767

    Shows Seen: 10

    DMB Hub Stubs: 9

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by rconverse
    I think it is just a photo. No underlying value or meaning.
    Just like Troy Smith 'accidently' taking $500 from a booster...no underlying value or meaning towards the university, right?
    thebigv is offline   Reply With Quote
    Old 02-23-2016, 06:21 PM   #33
    daveshookme
    Altuve wore a wire
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Supreme Courtyard by Marriott
    Posts: 62,665

    Shows Seen: 54

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    I have a .xlsx on a USB drive. When I open it, it says it's read-only. But I never saved it as such. If I open it and save as, in the same location adding a 1 to the filename, it's fine. If I delete the original file and rename the new without the 1, it's now read-only again. If I move it from the USB drive to my desktop, I can open it just fine (not read-only).

    What's going on?
    __________________
    Tape Cover Artwork
    daveshookme is offline   Reply With Quote
    Old 02-23-2016, 06:32 PM   #34
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: Pretty Boy Blue State
    Posts: 77,945

    Shows Seen: 25

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by daveshookme View Post
    I have a .xlsx on a USB drive. When I open it, it says it's read-only. But I never saved it as such. If I open it and save as, in the same location adding a 1 to the filename, it's fine. If I delete the original file and rename the new without the 1, it's now read-only again. If I move it from the USB drive to my desktop, I can open it just fine (not read-only).

    What's going on?
    What version of Office are you on? What version of Excel is the USB file?
    rconverse is offline   Reply With Quote
    Old 02-23-2016, 06:35 PM   #35
    daveshookme
    Altuve wore a wire
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Supreme Courtyard by Marriott
    Posts: 62,665

    Shows Seen: 54

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    What version of Office are you on? What version of Excel is the USB file?
    office '11 for mac for both. it may have been opened in office '13 on windows at one point a month ago or so? But I've never had an issue with it before (I've opened it on my mac many times since).
    __________________
    Tape Cover Artwork
    daveshookme is offline   Reply With Quote
    Old 02-23-2016, 07:19 PM   #36
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: Pretty Boy Blue State
    Posts: 77,945

    Shows Seen: 25

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by daveshookme View Post
    office '11 for mac for both. it may have been opened in office '13 on windows at one point a month ago or so? But I've never had an issue with it before (I've opened it on my mac many times since).
    Have you saved it on your mac since?
    rconverse is offline   Reply With Quote
    Old 02-23-2016, 07:22 PM   #37
    daveshookme
    Altuve wore a wire
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Supreme Courtyard by Marriott
    Posts: 62,665

    Shows Seen: 54

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Have you saved it on your mac since?
    yup. i have.
    __________________
    Tape Cover Artwork
    daveshookme is offline   Reply With Quote
    Old 02-23-2016, 07:31 PM   #38
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: Pretty Boy Blue State
    Posts: 77,945

    Shows Seen: 25

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by daveshookme View Post
    yup. i have.
    Unfortunately, I don't know. So, spoiler alert, anything you read passed here probably won't help you. As I mentioned, I'm not a mac guy. That said, I've had weird version issues with Excel (I think 2014 is what I have) but most of my coworkers have 2007. Anyway, what I've had to do with some file is open them in "read only" and then open a new blank workbook, paste, save, blah, blah...It's a hassle, so I just wrote a macro to do it. Because my issue is a version issue and not OS issue, it's a lot easier. Anyway, I don't know why but this last version of Office is a bit "Weird" compared to others. Anyway, I know that doesn't help you but good luck and reply back with what you find out. I'm a huge MS Office nerd.
    rconverse is offline   Reply With Quote
    Old 02-23-2016, 07:34 PM   #39
    daveshookme
    Altuve wore a wire
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Supreme Courtyard by Marriott
    Posts: 62,665

    Shows Seen: 54

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Unfortunately, I don't know. So, spoiler alert, anything you read passed here probably won't help you. As I mentioned, I'm not a mac guy. That said, I've had weird version issues with Excel (I think 2014 is what I have) but most of my coworkers have 2007. Anyway, what I've had to do with some file is open them in "read only" and then open a new blank workbook, paste, save, blah, blah...It's a hassle, so I just wrote a macro to do it. Because my issue is a version issue and not OS issue, it's a lot easier. Anyway, I don't know why but this last version of Office is a bit "Weird" compared to others. Anyway, I know that doesn't help you but good luck and reply back with what you find out. I'm a huge MS Office nerd.
    Yeah this one is truly boggling me. I can usually figure out any problems a computer or software can throw at me. This one I've got nothing.

    And it's a a 191kb workbook, copy/pasting would create at least a few problems.
    __________________
    Tape Cover Artwork
    daveshookme is offline   Reply With Quote
    Old 02-23-2016, 07:45 PM   #40
    DIDriveOut2SPAC
    American Aquarium Drnkr
     
    DIDriveOut2SPAC's Avatar
     
    Join Date: Aug 2006
    Location: Boston, MA
    Posts: 26,291

    Shows Seen: 35

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    Open it in google whatever then save as it.
    __________________
    Dan|
    DIDriveOut2SPAC is offline   Reply With Quote
    Old 02-24-2016, 11:42 AM   #41
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: Pretty Boy Blue State
    Posts: 77,945

    Shows Seen: 25

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    Did this get resolved?
    rconverse is offline   Reply With Quote
    Old 02-24-2016, 11:44 AM   #42
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 89,676

    Shows Seen: 117

    DMB Hub Stubs: 30

    My Tour Central Stats

    Re: Excel Help

    I don't know shit about Macs, but in Windows, you can check the properties of a file and de-select the "read only" option. Is this not a thing in the Mac OS?
    __________________
    -Matthew
    Dallas Tailgate Map
    ExistenceNow is offline   Reply With Quote
    Old 02-24-2016, 03:13 PM   #43
    DIDriveOut2SPAC
    American Aquarium Drnkr
     
    DIDriveOut2SPAC's Avatar
     
    Join Date: Aug 2006
    Location: Boston, MA
    Posts: 26,291

    Shows Seen: 35

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    Also, try deleting the x, in .xslx. Make a copy first just to be safe.
    __________________
    Dan|
    DIDriveOut2SPAC is offline   Reply With Quote
    Old 02-24-2016, 06:36 PM   #44
    unccrombie
    HairSlkdBakWayfarersOn
     
    unccrombie's Avatar
     
    Join Date: Jan 2003
    Posts: 46,633

    Shows Seen: 46

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    office 11 for mac is pure garbage.
    highly recommend office 2016/365 for mac.

    sounds like it could be a mac>windows>mac problem with the USB stick formatting.
    hint: OS X hates Windows file systems.
    so, read only on USB stick = windows file system, when you copy to desktop (os x) it's fine. makes sense to me...

    onward....

    Last edited by unccrombie; 02-24-2016 at 06:39 PM.
    unccrombie is offline   Reply With Quote
    Old 02-24-2016, 11:07 PM   #45
    daveshookme
    Altuve wore a wire
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Supreme Courtyard by Marriott
    Posts: 62,665

    Shows Seen: 54

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by unccrombie View Post
    office 11 for mac is pure garbage.
    highly recommend office 2016/365 for mac.

    sounds like it could be a mac>windows>mac problem with the USB stick formatting.
    hint: OS X hates Windows file systems.
    so, read only on USB stick = windows file system, when you copy to desktop (os x) it's fine. makes sense to me...

    onward....

    Fuck. Would it get fucked up if I've plugged it into my cars USB port?
    __________________
    Tape Cover Artwork
    daveshookme is offline   Reply With Quote
    Old 02-24-2016, 11:07 PM   #46
    daveshookme
    Altuve wore a wire
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Supreme Courtyard by Marriott
    Posts: 62,665

    Shows Seen: 54

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Did this get resolved?

    So, no. Not yet.
    __________________
    Tape Cover Artwork
    daveshookme is offline   Reply With Quote
    Old 02-25-2016, 06:19 AM   #47
    unccrombie
    HairSlkdBakWayfarersOn
     
    unccrombie's Avatar
     
    Join Date: Jan 2003
    Posts: 46,633

    Shows Seen: 46

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by daveshookme View Post
    Fuck. Would it get fucked up if I've plugged it into my cars USB port?
    I have no clue how vehicles handle mac/windows file systems. maybe?
    unccrombie is offline   Reply With Quote
    Old 06-10-2016, 03:39 PM   #48
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 89,676

    Shows Seen: 117

    DMB Hub Stubs: 30

    My Tour Central Stats

    Re: Excel Help

    I am virtually illiterate when it comes to Excel, so if someone could help me with some basic shit, I would really appreciate it.

    I'm working for two companies right now. Each day I make money from each. So I have a column for each one where I enter my earnings for that day. I want to have a Daily Total column where it adds up the two numbers each day. Is there a way to put a formula over the whole DT column so that it automatically generates those numbers every day as I enter the two separate company totals?

    So Date in Column A. Column B for Company B. Column C for Company C. Column D for Daily total. Column D fills in automatically as the numbers get entered into B and C.

    Does that make sense?
    __________________
    -Matthew
    Dallas Tailgate Map

    Last edited by ExistenceNow; 06-10-2016 at 03:40 PM.
    ExistenceNow is offline   Reply With Quote
    Old 06-10-2016, 03:49 PM   #49
    DavefaninNZ
     
    DavefaninNZ's Avatar
     
    Join Date: Apr 2006
    Location: Colorado
    Posts: 4,777

    Shows Seen: 0

    DMB Hub Stubs: 1

    My Tour Central Stats

    Re: Excel Help

    Type the formula =sum(A1:C1) in D1 cell. Then with D1 cell highlighted, there should be a little square in the bottom right corner of the highlight box. Click and hold, and drag down however far you want it to go to. Should get a bunch of zeros when you do that. As you type in your earnings each day, D will calculate your daily total.

    edit: Whoops, formula should be B1:C1
    __________________
    Andrew

    Last edited by DavefaninNZ; 06-10-2016 at 03:52 PM.
    DavefaninNZ is offline   Reply With Quote
    Old 06-10-2016, 03:52 PM   #50
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 89,676

    Shows Seen: 117

    DMB Hub Stubs: 30

    My Tour Central Stats

    Re: Excel Help

    Well, fucking shit, that was easy.


    Thanks so much, man.
    __________________
    -Matthew
    Dallas Tailgate Map
    ExistenceNow is offline   Reply With Quote
    Old 06-10-2016, 03:53 PM   #51
    DavefaninNZ
     
    DavefaninNZ's Avatar
     
    Join Date: Apr 2006
    Location: Colorado
    Posts: 4,777

    Shows Seen: 0

    DMB Hub Stubs: 1

    My Tour Central Stats

    Re: Excel Help

    No prob.
    __________________
    Andrew
    DavefaninNZ is offline   Reply With Quote
    Old 06-10-2016, 03:53 PM   #52
    FromTheMorning
     
    FromTheMorning's Avatar
     
    Join Date: Dec 2011
    Posts: 12,752

    Shows Seen: 29

    DMB Hub Stubs: 13

    My Tour Central Stats

    Re: Excel Help

    Simple way would be to put =SUM(B2+C2) in cell D2 and then put your cursor in the bottom corner of the cell til you see a cross type thing. Then just drag that all the way down to whatever row the dates stop. That way every time you enter an amount in column B or C, it will automatically populate Column D. Given that it's excel, there are probably multiple ways to do it, but I'd say that's the easiest.

    edit: well I guess I'm not needed anymore
    FromTheMorning is offline   Reply With Quote
    Old 06-10-2016, 03:54 PM   #53
    BTBaboon
     
    BTBaboon's Avatar
     
    Join Date: Jul 2015
    Posts: 51,331

    Shows Seen: 31

    DMB Hub Stubs: 10

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    I am virtually illiterate when it comes to Excel, so if someone could help me with some basic shit, I would really appreciate it.

    I'm working for two companies right now. Each day I make money from each. So I have a column for each one where I enter my earnings for that day. I want to have a Daily Total column where it adds up the two numbers each day. Is there a way to put a formula over the whole DT column so that it automatically generates those numbers every day as I enter the two separate company totals?

    So Date in Column A. Column B for Company B. Column C for Company C. Column D for Daily total. Column D fills in automatically as the numbers get entered into B and C.

    Does that make sense?
    So there's a few ways to do this, and depends on how complex you want it. Am I understanding correct that you want it to be a blank cell until you enter the daily amounts, and not show zero when you haven't entered the data?

    Assuming you are only entering a date when you have worked, I'd go with an If statement.

    If you have column headers in row 1, start in cell D2 and type: =if(isblank(A2),"",sum(B2:C2))


    then just drag that formula down as far as you want. It will show as a blank cell until you enter the date and then will sum the amounts when enter them into columns B and C
    BTBaboon is online now   Reply With Quote
    Old 06-10-2016, 03:57 PM   #54
    FromTheMorning
     
    FromTheMorning's Avatar
     
    Join Date: Dec 2011
    Posts: 12,752

    Shows Seen: 29

    DMB Hub Stubs: 13

    My Tour Central Stats

    Re: Excel Help

    The Kiwi is the fastest typer
    FromTheMorning is offline   Reply With Quote
    Old 06-10-2016, 04:00 PM   #55
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 89,676

    Shows Seen: 117

    DMB Hub Stubs: 30

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by BTBaboon View Post
    So there's a few ways to do this, and depends on how complex you want it. Am I understanding correct that you want it to be a blank cell until you enter the daily amounts, and not show zero when you haven't entered the data?

    Assuming you are only entering a date when you have worked, I'd go with an If statement.
    Yea, that's the plan.

    Quote:
    If you have column headers in row 1, start in cell D2 and type: =if(isblank(A2),"",sum(B2:C2))


    then just drag that formula down as far as you want. It will show as a blank cell until you enter the date and then will sum the amounts when enter them into columns B and C
    That looks cleaner. I like that. Thanks!
    __________________
    -Matthew
    Dallas Tailgate Map
    ExistenceNow is offline   Reply With Quote
    Old 06-10-2016, 05:44 PM   #56
    daveshookme
    Altuve wore a wire
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Supreme Courtyard by Marriott
    Posts: 62,665

    Shows Seen: 54

    DMB Hub Stubs: 20

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by BTBaboon View Post
    So there's a few ways to do this, and depends on how complex you want it. Am I understanding correct that you want it to be a blank cell until you enter the daily amounts, and not show zero when you haven't entered the data?



    Assuming you are only entering a date when you have worked, I'd go with an If statement.



    If you have column headers in row 1, start in cell D2 and type: =if(isblank(A2),"",sum(B2:C2))





    then just drag that formula down as far as you want. It will show as a blank cell until you enter the date and then will sum the amounts when enter them into columns B and C


    If isblank statements in excel are the best
    __________________
    Tape Cover Artwork
    daveshookme is offline   Reply With Quote
    Old 06-11-2016, 07:27 PM   #57
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: Pretty Boy Blue State
    Posts: 77,945

    Shows Seen: 25

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    You don't need an if statement. It's just going to slow down the calculation time.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 07:30 PM   #58
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 89,676

    Shows Seen: 117

    DMB Hub Stubs: 30

    My Tour Central Stats

    Re: Excel Help

    Interesting, though not really an issue for my purposes. I'm just trying to be lazy and not have to add two numbers together every day.
    __________________
    -Matthew
    Dallas Tailgate Map
    ExistenceNow is offline   Reply With Quote
    Old 06-11-2016, 07:35 PM   #59
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: Pretty Boy Blue State
    Posts: 77,945

    Shows Seen: 25

    DMB Hub Stubs: 14

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by ExistenceNow View Post
    Interesting, though not really an issue for my purposes. I'm just trying to be lazy and not have to add two numbers together every day.
    Yeah, I hear you. Based on your initial post, it sounds like you have a very simple worksheet setup. The thing with an IF statement is that it contains a logical operator, which takes up more calculation time. Using a strict SUM statement, eliminates the logical operation (IF this, then "do that", else "do something else"). You can have the zeroes not show using conditional formatting, which doesn't drain the processors when calculating a worksheet or workbook.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 07:38 PM   #60
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 89,676

    Shows Seen: 117

    DMB Hub Stubs: 30

    My Tour Central Stats

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Yeah, I hear you. Based on your initial post, it sounds like you have a very simple worksheet setup. The thing with an IF statement is that it contains a logical operator, which takes up more calculation time. Using a strict SUM statement, eliminates the logical operation (IF this, then "do that", else "do something else"). You can have the zeroes not show using conditional formatting, which doesn't drain the processors when calculating a worksheet or workbook.
    What would that formula look like?
    __________________
    -Matthew
    Dallas Tailgate Map
    ExistenceNow is offline   Reply With Quote
    Reply

    Tags
    excel

    Thread Tools
    Display Modes

    Posting Rules
    You may not post new threads
    You may not post replies
    You may not post attachments
    You may not edit your posts

    BB code is On
    Smilies are On
    [IMG] code is Off
    HTML code is Off

    Forum Jump


    Want to hide all ads on Ants? Click here

    All times are GMT -7. The time now is 11:19 AM.


    Powered by vBulletin® Version 3.8.14
    Copyright ©2000 - 2024, vBulletin Solutions Inc.


       
    Site LinksAbout AntsAnts MobileTweet Tweet
    Home
    Ants+
    Tour Central
    Search bar
    RSS Feeds
    About Us
    Contact Us
    The Ants Blog
    Advertise on Ants
    Privacy Policy
    Ants on your cell phone
    iAnts
    mobile news
    mobile setlists
    antslive!
    Ants' Twitter
    DMBLive Twitter
    Ants Facebook
    Ants Instagram