To read a MET table for another activity, you will need to place the existing INDEX part of that formula into another IF statement, then add a new INDEX part to pick the MET off the new MET table. Note that row 1, a header row, is not included in the range specified. INDEX returns the value that is in the 8th row and second column (8,2) of the range specified ($A$B = columns A and B ) of the MET table (11.0). (INDEX(Walking and Running MET :: $A:$B,8,2) That value is returned to the formula, where 1 is subtracted from it to make INDEX retrieve a value from the row above the matched row in the table: MATCH returns the position of that value in the list.įor the values on row 6, F5/G5 is 12 minutes/1.35(miles), or 8 minutes 53 seconds, which matches 8 minutes 30 seconds and returns its position (9) on the list. The third argument, "-1" means MATCH is to find the 'smallest value in the range that is greater than or equal to' F5/G5. MATCH(F5/G5,Walking and Running MET :: $A,-1)į6/G6 is 'minutes per mile', the value that MATCH is to search for in Column A of the MET data table. Working from the inside brackets outward (and moving to row 5, where this part of the formula is first called in the sample template): If none of these conditions are met (with the provided template, that would occur when the Activity was walking or Running, and a distance had been entered in column G (Distance Travelled) ), then the last line comes into play. The first three lines assign specific MET values if the activity is Weight Training (6), Running with no distance specified (10) or Walking with no distance specified (2.5). (INDEX(Walking and Running MET :: $A:$B,MATCH(F2/G2,Walking and Running MET :: $A,-1)-1,2))))) The existing formula is this one (rearranged to break the lines at logical points): If I understand correctly, you want to add more choices to the Activity column of Step 3, and have them included in the calculations in the MET column of the same table. (puts on swami cap and pulls out crystal ball) Welcome to Apple Discussions and the Numbers '09 forum. I've created my second table and populated it with all the correct information but I'm at a loose end as how to link this in with the main document so I can select it from the activity menu. I ideally want to know how to add additional tables for use. In the MET data there is a table for Walking and Running. (I)n Numbers '09 there is a weight loss template,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |