|
|
|
|
HYPERASHEL
Member
|
|
|
Joined: 18 Nov 2003
Posts: 15397
Location: The South's Sauna, Atlanta
|
| Back to top
|
|
 Posted: 01/14/04 - 16:31 Post subject: SPREADSHEETERS!!!!!
ok, here's my problem.
what i WANT to do is.
to be able to use the GPS data on a spread sheet AND the HRM info to match up. as in see my effort on particular parts.
my first idea is a simple two horizontal line entry
line 1 being GPS
line 2 being HRM
obviuosly i'll have to synch the laps up for this to make comprehensive view of effort/perception/terrain. so i just wanted some input on what i might be overlooking/oversimplifying/or just not even thinking of.
gawd lab techs can be so freaking anal. 
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 01/14/04 - 17:47 Post subject: Re: SPREADSHEETERS!!!!!
| HYPERASHEL wrote: | | obviuosly i'll have to synch the laps up for this to make comprehensive view of effort/perception/terrain. |
You will have to synch them up. Use VLOOKUP or HLOOKUP - both allow you to use multiple criteria to obtain a result. Think tax tables - if you're married (one criteria) and make $50K (the second criteria), you are in the 25% tax bracket (result)*.
* Criteria and results used not actual, but purely theoretical to illustrate the concept.
|
|
|
|
|
HYPERASHEL
Member
|
|
|
Joined: 18 Nov 2003
Posts: 15397
Location: The South's Sauna, Atlanta
|
| Back to top
|
|
Posted: 01/14/04 - 18:20 Post subject: Re: SPREADSHEETERS!!!!!
| elkid wrote: | | HYPERASHEL wrote: | | obviuosly i'll have to synch the laps up for this to make comprehensive view of effort/perception/terrain. |
You will have to synch them up. Use VLOOKUP or HLOOKUP - both allow you to use multiple criteria to obtain a result. Think tax tables - if you're married (one criteria) and make $50K (the second criteria), you are in the 25% tax bracket (result)*.
* Criteria and results used not actual, but purely theoretical to illustrate the concept. |
ARRRRGH taxes make me think of math. you just took all the fun out of it
not familair with the programs. i'll be basing this off the software i have not yet seen for Garmin.
|
|
|
|
|
elkid
Member
|
|
|
Joined: 18 Nov 2002
Posts: 8353
Location: hiding out in Philly
|
| Back to top
|
|
Posted: 01/14/04 - 23:19 Post subject: Re: SPREADSHEETERS!!!!!
| HYPERASHEL wrote: | ARRRRGH taxes make me think of math. you just took all the fun out of it
not familair with the programs. i'll be basing this off the software i have not yet seen for Garmin. |
Workout math is FUN! VLOOKUP and HLOOKUP are Excel functions, not programs. Plenty o' info on it in the Help.
|
|
|
|
