Excel Help - Page 2 - Antsmarching.org Forums

Go Back   Antsmarching.org Forums > General Discussion > alternativefactsC


Want to hide all ads on Ants? Click here
Reply
 
Thread Tools Display Modes
Old 03-03-2006, 02:38 PM   #31
rconverse
 
rconverse's Avatar
 
Join Date: May 2003
Location: It's how, not where. I live to dance!
Posts: 63,209

Shows Seen: 25

Re: Excel Help

I think it is just a photo. No underlying value or meaning.
__________________
Quote:
Originally Posted by opshannon View Post
You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
rconverse is offline   Reply With Quote

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

    Shows Seen: 10
    Send a message via AIM to thebigv Send a message via Yahoo to thebigv

    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, 09:21 PM   #33
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,958

    Shows Seen: 38

    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?
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 02-23-2016, 09:32 PM   #34
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,209

    Shows Seen: 25

    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?
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 02-23-2016, 09:35 PM   #35
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,958

    Shows Seen: 38

    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).
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 02-23-2016, 10:19 PM   #36
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,209

    Shows Seen: 25

    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?
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 02-23-2016, 10:22 PM   #37
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,958

    Shows Seen: 38

    Re: Excel Help

    Quote:
    Originally Posted by rconverse View Post
    Have you saved it on your mac since?
    yup. i have.
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 02-23-2016, 10:31 PM   #38
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,209

    Shows Seen: 25

    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.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 02-23-2016, 10:34 PM   #39
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,958

    Shows Seen: 38

    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.
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 02-23-2016, 10:45 PM   #40
    DIDriveOut2SPAC
    American Aquarium Drnkr
     
    DIDriveOut2SPAC's Avatar
     
    Join Date: Aug 2006
    Location: New York City
    Posts: 25,343

    Shows Seen: 35

    Re: Excel Help

    Open it in google whatever then save as it.
    __________________
    RateYourMusic 2011
    DIDriveOut2SPAC is offline   Reply With Quote
    Old 02-24-2016, 02:42 PM   #41
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,209

    Shows Seen: 25

    Re: Excel Help

    Did this get resolved?
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 02-24-2016, 02:44 PM   #42
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,275

    Shows Seen: 100

    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
    ExistenceNow is offline   Reply With Quote
    Old 02-24-2016, 06:13 PM   #43
    DIDriveOut2SPAC
    American Aquarium Drnkr
     
    DIDriveOut2SPAC's Avatar
     
    Join Date: Aug 2006
    Location: New York City
    Posts: 25,343

    Shows Seen: 35

    Re: Excel Help

    Also, try deleting the x, in .xslx. Make a copy first just to be safe.
    __________________
    RateYourMusic 2011
    DIDriveOut2SPAC is offline   Reply With Quote
    Old 02-24-2016, 09:36 PM   #44
    unccrombie
    HairSlkdBakWayfarersOn
     
    unccrombie's Avatar
     
    Join Date: Jan 2003
    Location: DC
    Posts: 41,087

    Shows Seen: 42

    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 09:39 PM.
    unccrombie is offline   Reply With Quote
    Old 02-25-2016, 02:07 AM   #45
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,958

    Shows Seen: 38

    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?
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 02-25-2016, 02:07 AM   #46
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,958

    Shows Seen: 38

    Re: Excel Help

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

    So, no. Not yet.
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 02-25-2016, 09:19 AM   #47
    unccrombie
    HairSlkdBakWayfarersOn
     
    unccrombie's Avatar
     
    Join Date: Jan 2003
    Location: DC
    Posts: 41,087

    Shows Seen: 42

    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, 06:39 PM   #48
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,275

    Shows Seen: 100

    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

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

    Shows Seen: 0

    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 06:52 PM.
    DavefaninNZ is offline   Reply With Quote
    Old 06-10-2016, 06:52 PM   #50
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,275

    Shows Seen: 100

    Re: Excel Help

    Well, fucking shit, that was easy.


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

    Shows Seen: 0

    Re: Excel Help

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

    Shows Seen: 29

    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, 06:54 PM   #53
    BTBaboon
     
    BTBaboon's Avatar
     
    Join Date: Jul 2015
    Posts: 4,551

    Shows Seen: 21

    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 offline   Reply With Quote
    Old 06-10-2016, 06:57 PM   #54
    FromTheMorning
     
    FromTheMorning's Avatar
     
    Join Date: Dec 2011
    Posts: 9,596

    Shows Seen: 29

    Re: Excel Help

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

    Shows Seen: 100

    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
    ExistenceNow is offline   Reply With Quote
    Old 06-10-2016, 08:44 PM   #56
    daveshookme
    Bing Bong, Bing Bong!
     
    daveshookme's Avatar
     
    Join Date: Jun 2009
    Location: Mind - Godric's Hollow; Body - Albany, NY
    Posts: 41,958

    Shows Seen: 38

    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
    __________________
    #BeltMelt2k14 never forget

    Tyler made me change my sig and I did because you just don't fuck with poop-apples.
    daveshookme is online now   Reply With Quote
    Old 06-11-2016, 10:27 PM   #57
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,209

    Shows Seen: 25

    Re: Excel Help

    You don't need an if statement. It's just going to slow down the calculation time.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 10:30 PM   #58
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,275

    Shows Seen: 100

    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
    ExistenceNow is offline   Reply With Quote
    Old 06-11-2016, 10:35 PM   #59
    rconverse
     
    rconverse's Avatar
     
    Join Date: May 2003
    Location: It's how, not where. I live to dance!
    Posts: 63,209

    Shows Seen: 25

    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.
    __________________
    Quote:
    Originally Posted by opshannon View Post
    You're right about the shift to the right that the board took after it reopened. And it's not even thoughtful righties, it's talk radio righties. Got no patience for them whatsoever. We'll see. Maybe I'll see what I can tolerate.
    rconverse is offline   Reply With Quote
    Old 06-11-2016, 10:38 PM   #60
    ExistenceNow
    AM.org Moderator
     
    ExistenceNow's Avatar
     
    Join Date: Aug 2004
    Location: Austin, Tx
    Posts: 65,275

    Shows Seen: 100

    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
    ExistenceNow is offline   Reply With Quote
    Reply

    Bookmarks

    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 -4. The time now is 01:28 PM.


    Powered by vBulletin® Version 3.8.6
    Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.


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