numbers shortcut to add 1 to a value

Discussion in 'Mac Apps and Mac App Store' started by tedesco24, Apr 23, 2011.

  1. tedesco24 macrumors member

    Joined:
    Jul 4, 2010
    #1
    I am using a numbers spreadsheet to keep track of my baseball card inventory. I have two columns, one that list the card number and the other that list the quantity. What I'd like to do is set up a shortcut so that when I get a card I can hit the shortcut key and it will add one (+1) to the existing quantity value. How can I do this?
     
  2. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #2
    I'm not sure that this is exactly what you want.... but..... I use the function "Countif" to count how many rows have an name in it (vs blank - iirc it's countif > a . ) That isn't the correct syntax - it needs a comma or something, but basically if there is anything in the cell that adds up to more than an ' a ' it get's counted. So, it tells me how many cells in a range have a name entered. I don't need to remember to hit a shortcut key, or try to remember if I've already hit the shortcut key.... it just updates itself.

    Hope that helps.

    Happy spring spiritual holiday, or not.
     
  3. tedesco24 thread starter macrumors member

    Joined:
    Jul 4, 2010
    #3
    Thanks for the reply. No, that's not what I'm looking to do, but your suggestion helped solve another problem.
     
  4. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #4
    I've never seen a spreadsheet do this and I think it's a great idea. You should send it to Apple as an idea for the next version.

    http://www.apple.com/feedback/numbers.html

    mt
     
  5. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #5
    Ok, then I don't think I understand the problem. What is it you are trying to count? Or do you just want something that adds up how many times you hit a key (or key combo?)

    The problem with counting how many times you hit a key is that you yourself need to keep track as whether you've already counted the "thing" or not.

    There may be a way to count how many times a digit appears in a cell. So for example, every time you get a card you add (for example) a '1' to the string. So for the first card there would be a '1'. For the 2nd card a '11', 3rd card '111', 8th card '11111111', etc etc Even if the string is getting really long, you are only adding single digit at a time.

    Is that what you are looking for?
     
  6. tedesco24 thread starter macrumors member

    Joined:
    Jul 4, 2010
    #6
    I appreciate you following up and trying to help. Thank you.

    What I'm looking to do is keep track of the quantity of an individual card I have.
    1. Lets say each weekend I buy several packs of cards.
    2. I open the cards and put them in order.
    3. I then open my spreadsheet.
    4. I want to update the spreadsheet to reflect the new quantities. Currently I move the cursor over the quantity, hit the delete button, and type in the updated quantity (+1).
    5. So I am deleting the current value and re-typing the new value

    What I'd like to do is create a shortcut (say command-q), so that when I move the cursor over the existing quantity, I hit the shortcut and it updates the quantity by 1. So the quantity goes from 3 to 4, 4 to 5, 5 to 6, etc.

    I've looked at the function tools, and can't seem to find one that reads the current value and is willing to increase that value by one when I hit a key.
     

    Attached Files:

  7. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #7
    Are you using Numbers to record anything besides how many cards you have? I saw the sample you attached. It looks like you are recording how many cards you've added per "period", and that you generally add 1-3 cards at a time. I'm not sure how the negative #s fit in - I assume you are also disposing of cards occasionally, but you aren't tracking 'when they left the collection, just that they did.

    If all you want is an adding tape, then set up a long column, and in the Inspector set it so that "Return Moves to Next Cell". Put a Sum function in the bottom cell. To use it enter a '1' in the first empty cell and hit "return". The cursor will move to the next cell, and the total is incremented by one.

    It's not really a "shortcut key" but there really isn't any difference hitting something like "Option+&" and "1+Return".

    Start a 2nd table on that sheet near the top, with just enough cells for the title and a cell that displays that total from the Sum on the other table. That way at least you don't have to scroll to the bottom just to see your total.

    I'm surprised you aren't using Numbers to actually track each card, and it's details. Once the info is added in you can do all sorts of interesting things. Sort by name, count how many names start with each letter of the alphabet, sort by acquisition date, birth date, etc etc Plus count how many players played for each team, how many were born in what month, etc etc

    Hope this helps.
     
  8. tedesco24 thread starter macrumors member

    Joined:
    Jul 4, 2010
    #8
    Thanks, I think we'll get this eventually.
     
  9. tedesco24 thread starter macrumors member

    Joined:
    Jul 4, 2010
    #9
    I posted a reply above in the main section, i thought my reply would be highlighted. My bad.
     
  10. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #10
    OK, let me see if I get this. You have, for example, 2 cards for player #9 (I'm not looking at your sample, so this is just an example) already... You open a new package, and find 1 more card for #9. You want to be able to put the cursor into that cell and hit a key combo so that it adds 2 + 1 to make 3. You're done.

    Rather than you thinking to yourself "I have 2, plus the new one makes 3, therefore I must enter the number 3 in the cell instead of the existing 2."

    Is that correct?
     
  11. tedesco24 thread starter macrumors member

    Joined:
    Jul 4, 2010
    #11

    YES!!!!! That is exactly what I am trying to accomplish. How can it be done?
     
  12. Mal macrumors 603

    Mal

    Joined:
    Jan 6, 2002
    Location:
    Orlando
    #12
    I think you're making it harder on yourself than necessary. Why are you deleting the old entry first? If the cell says 3, then just hit 4. Unless you've double-clicked and positioned the cursor inside the cell, it will replace the contents of the cell.

    I could understand if you were working with larger numbers, but it sounds like mostly single digits. Seems to be to be easier just to type the new number and move on.

    jW
     
  13. tedesco24 thread starter macrumors member

    Joined:
    Jul 4, 2010
    #13
    Are you kidding me? That is the easiest thing I have ever seen! Thanks a ton.
     
  14. snberk103 macrumors 603

    Joined:
    Oct 22, 2007
    Location:
    An Island in the Salish Sea
    #14
    Beats the h*ll out of me! :)

    I'd have built a database to record everything. It would have not only told me how many cards I was still missing, but it would have spit out a list telling me exactly which ones. How many players had both a 'J' in their name, and in their birth month - but not in the month in which they got drafted. etc etc

    OK - use Numbers help to look up "Stepper". I haven't used this control, but it may be what you are looking for. Good Luck
     

Share This Page