New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Numbers Help


Post Reply New Thread Subscribe

 
Thread Tools
CPM

 
Member Since: May 05, 2011
Posts: 2
CPM is on a distinguished road

CPM is offline
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!
QUOTE Thanks
RavingMac

 
RavingMac's Avatar
 
Member Since: Jan 07, 2008
Location: In Denial
Posts: 7,615
RavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond reputeRavingMac has a reputation beyond repute
Mac Specs: 4GB Mac Mini 2012, 13" MBA, 15" MacBook Pro OSX 10.7, 32 GB iPhone 3GS, iPad2 64gb 3G

RavingMac is offline
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 . . .
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,504
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
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?
QUOTE Thanks
CPM

 
Member Since: May 05, 2011
Posts: 2
CPM is on a distinguished road

CPM is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« MobileMe/Mail app help please! | How to shrink Pages doc. to fit 4 on a page. »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Wireless symbol as numbers? MacFanDan iPhone Hardware and Accessories 17 01-06-2011 06:40 PM
Phone numbers disappear in Address Book Juba22 OS X - Apps and Games 0 12-14-2009 08:48 AM
iTunes Track numbers with audible files charliexedd OS X - Apps and Games 1 11-07-2009 02:28 PM
Copying data from email into numbers on iMac Andy and Shell Apple Desktops 0 03-08-2009 05:22 PM
Cutting and Pasting from emails into Numbers Andy and Shell Switcher Hangout 0 03-08-2009 05:20 PM

All times are GMT -4. The time now is 08:01 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?