Results 1 to 4 of 4

Thread: Numbers Help

  1. #1


    Member Since
    May 05, 2011
    Posts
    2
    Numbers Help
    Hi, this is my first time actually dealing with numbers and functions even though I've had my mac for awhile (1 year). I'm trying to create a running log for the summer, and the template just isn't what I want. I'm trying to create one column header with the day, and want to take the value of the cell above each cell in that column and add 1 to it, in order to get a running list of numbers (which would be the day) that column (eg: 1,2,3...). However, I can't figure out how to drag a certain formula (=Sum(A2+1)) down a column so that it applies to a whole column and so that the fourth row (A4) has the formula (=Sum(A3+1)) and the fifth row (A5) has the formula (=Sum(A4+1)) and so on. I've worked with excel, and there you just drag the first cell down when it has that first formula in it and it will automatically update it for each individual row.

    Could anyone also help me with how to drag any formula to apply to all columns using the cells in their row of course, so that each row will have one cell with the time I ran, one with the distance, and one with the pace (it's basically the same question as above, but more general).

    I know this is a little technical, but please ask me if I need to clarify something.

    Thanks!

  2. #2

    RavingMac's Avatar
    Member Since
    Jan 07, 2008
    Location
    In Denial
    Posts
    7,874
    Specs:
    4GB Mac Mini 2012, 13" MBA, 15" MacBook Pro OSX 10.7, 32 GB iPhone 3GS, iPad2 64gb 3G
    Quote Originally Posted by CPM View Post
    Hi, this is my first time actually dealing with numbers and functions even though I've had my mac for awhile (1 year). I'm trying to create a running log for the summer, and the template just isn't what I want. I'm trying to create one column header with the day, and want to take the value of the cell above each cell in that column and add 1 to it, in order to get a running list of numbers (which would be the day) that column (eg: 1,2,3...). However, I can't figure out how to drag a certain formula (=Sum(A2+1)) down a column so that it applies to a whole column and so that the fourth row (A4) has the formula (=Sum(A3+1)) and the fifth row (A5) has the formula (=Sum(A4+1)) and so on. I've worked with excel, and there you just drag the first cell down when it has that first formula in it and it will automatically update it for each individual row.

    Could anyone also help me with how to drag any formula to apply to all columns using the cells in their row of course, so that each row will have one cell with the time I ran, one with the distance, and one with the pace (it's basically the same question as above, but more general).

    I know this is a little technical, but please ask me if I need to clarify something.

    Thanks!
    Honestly (and this may be heresy here) but if I was going to do that I would probably build the template in Excel or OpenOffice then use Numbers to maintain and populate it.

    My own solution though is to use

    Running ahead web site

    http://www.runningahead.com/

    I can download directly from my GPS watch and the site takes care of tracking my workouts for me.
    I've always wanted to be smart, handsome and modest. But, I guess I'll have to be satisfied with two out of three . . .

  3. #3

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,107
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Well, in Excel, you can use copy and paste. It will "translate" the relationship of the cells in the formula. It doesn't take long to paste that for a whole sheet. Will Numbers do that also?

  4. #4


    Member Since
    May 05, 2011
    Posts
    2
    Quote Originally Posted by toMACsh View Post
    Well, in Excel, you can use copy and paste. It will "translate" the relationship of the cells in the formula. It doesn't take long to paste that for a whole sheet. Will Numbers do that also?
    Not that I know of, and that's the problem I'm having.

    I have seen that running site, but I would rather plan my runs (General/Recovery/Speed/Tempo) ahead of time so I can plan ahead with meals and have something to stick to.

    What I ended up doing is using google docs to write the formulas and doing all of the organization stuff, and then downloading the file as an excel spreadsheet to then use in numbers. It seems to work fine and everything seems to display correctly.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need help with Numbers
    By lakerider in forum OS X - Apps and Games
    Replies: 1
    Last Post: 12-26-2014, 07:11 PM
  2. Numbers '09
    By pilgrim1936 in forum OS X - Apps and Games
    Replies: 1
    Last Post: 11-21-2014, 01:52 PM
  3. Numbers
    By wesley7777 in forum iOS and Apps
    Replies: 1
    Last Post: 11-05-2012, 03:50 PM
  4. Replies: 0
    Last Post: 08-23-2011, 04:14 AM
  5. Correlating Model Numbers and Apple Part Numbers
    By fziksman in forum Other Hardware and Peripherals
    Replies: 0
    Last Post: 01-30-2007, 04:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •