|
I'm looking into using my numbers app to track party xp for my home campaign. I want to have a cell for each character that will take the resulting sum at the bottom and compare it to the xp table and spit out a result of what level the character is based on how much xp they have.
Hopefully that's clear.
Can anyone tell me how to do that? I'm new to mac's in general and iWork.
Thanks for any help.
Do you have any experience with Excel or other spreadsheet programs? Numbers uses the same basic formulas... mostly.
The hard way would be to create number of nested IF statements. You'll have to give me a bit to figure out a simpler way to do that matching
Something to that may help you stay organized is that you can have several tables per sheet. I often split info across several tables for logical reasons. For example:
Create one table and change it's label to Characters. Make sure it it has one Header Row. Fill each column header with the name (nickname single word) of each character. This will be your record table, just a running list of XP entires.
Create a second table and label it Totals. Again with on header Row including Player names. This time also include a Header column and two rows, one called XP one called Level.
Then there will be a 3rd table that holds the XP values (say XP By Level).
(Frack it! I want iOS 5 now and that AirPlay Video mirror for screen recording.)
Tabel Characters and XP By Level do no calculation. Cells in Totals :: XP should have =SUM(Characters :: Character1) which you can do by tapping the header spot on the headers table. Don't worry if you mess up. You can tap the cell reference once and then tap the column part again.
Totals :: Level will use 20 IF statements. Basically all copy paste then tap replacements of
Goes like this: I'll use {} for cell references
= IF ( {Totals :: Char1 XP} < {XP By Level :: XP 2}, 1,0)
+ IF ( {Totals :: Char1 XP} >= {XP By Level :: XP 2}, 2, 0)
+ IF ( {Totals :: Char1 XP} >= {XP By Level :: XP 3}, 1, 0)
+ IF ( {Totals :: Char1 XP} >= {XP By Level :: XP 4}, 1, 0)
+ IF ( {Totals :: Char1 XP} >= {XP By Level :: XP 5}, 1, 0)
etc
Note that the first IF gets cleared to 0 once you hit 2nd level XP. Each IF after 2nd level adds 1 because it's cumulative.
======
I did do a Sheet to try it out and it works. If you want I can see about uploading it. While it's not the best for heavy data entry iOS numbers is IMO darn fun for fiddling with stuff on the fly. I especially love the Forum entry and how you drag values around. What's hard to get used to is the single Tap. Lots of stuff like Fill is based on a single tap, not a double tap.
I especially like how it encapsulates Cell references to be easy to change by Tap.
Keep in mind that Numbers for iOS is not a completely full feature spreadsheet program. There abilities it is missing even in comparison to Numbers '09. I take it that you only have the iOS version not the Mac iWorks '09?
One of those is merging rows or columns together. Instead what you'll want to do tap cell on with the TEXT you want > tap the (i) icon in the upper right > tap cell tab > turn off Warp Text in Cell.
This will cause the text spill out over multiple cells as long as they are empty. Personally in a way I find this better then doing a cell merge which can mess up columns widths in the long run. It will also overspill to the left and right if you use a different justification.
For example make a 3 column wide table, put a long sentence in the middle row then use left, right, and center justification.
One of the other things iOS Numbers is missing are the Slider, Stepper, and Pop-up menu format options for cells.
iWork does not come pre-installed unless you specifically ordered it as an extra when you ordered the Mini. It would have been one of the selection options when customizing the purchase.
Currently they are being sold through the Mac App store at 20 dollars each. Personally myself I'm waiting until the next version of iWorks is released... hopefully not long after Lion which will be sometime in July. They've been on iWork '09 for quite some time now. If I remember right prior to the Mac App store offer they cost 79.99 for suite.