PING: FrogMan

[terpkristin]

Sorry to ask, but is there an easy way to modify the "spreadsheet of wonder" so it picks up the TSI instead of giving the #VALUE! error in that column?

I assume it's just a new key to look for in the index, but I really don't know how that one all works....

Thanks FM!
~tk

[Poli]

While you've got him pinged:

HI FROG!

[FrogMan]

hi AE :)

tk, it's trickier than that, it actually had me cursing them earlier tonight.

I had corrected my main spreadsheet earlier this week, when the line with the TSI looked like this:
TSI=5270 (1 054 000 C$)

with no spaces in between the "=" or in the middle of the TSI value, now tonight, it looked like this:
TSI = 5 270 (1 054 000 C$)

This made a world of difference to my parser, GRRRR!!!

I had completely forgotten about the HT-comp sheet, which is probably what you are referring to... I'll get to it probably tomorrow and will get back to you...

FM