C
Chris Rae
Howdy -
I've written an addin which will work out where calculation time was spent
on a spreadsheet. It's not the most complex beast, and basically just
replaces all the calculation cells with a sort of
=timer(start(),originalcalc(),stop()) function.
However, this said it does seem to work fairly nicely and I'm wondering how
best to represent the actual timing results. My intention is to replace all
the formulas with the timing ones, then leave the user to fiddle with the
spreadsheet as much as they fancy. They could then at some point see on the
screen where all the calculation time went. My current options are either to
have this on some sort of dialog or to actually change the sheet in some way
to represent them. My best idea so far has been to change the cell font
sizes (bigger text means longer spent calculating). It's a pity the current
version of XL doesn't let me have the full colour palette, otherwise I could
make some sort of heat map. The font size changes actually look okay.
What I'm after from you lot is:
1. Would anyone want this sort of a calculation-time profiling tool? I'm
half thinking it might make me some money 2. Any more ideas about how to
represent the output?
Any help appreciated - I'm not particularly protective of the code for this
so if anyone wants a demo I can knock one up pretty easily. At the moment
it's rather sitting at the "proof of concept" stage while I wonder whether
it's worth taking further.
Chris
I've written an addin which will work out where calculation time was spent
on a spreadsheet. It's not the most complex beast, and basically just
replaces all the calculation cells with a sort of
=timer(start(),originalcalc(),stop()) function.
However, this said it does seem to work fairly nicely and I'm wondering how
best to represent the actual timing results. My intention is to replace all
the formulas with the timing ones, then leave the user to fiddle with the
spreadsheet as much as they fancy. They could then at some point see on the
screen where all the calculation time went. My current options are either to
have this on some sort of dialog or to actually change the sheet in some way
to represent them. My best idea so far has been to change the cell font
sizes (bigger text means longer spent calculating). It's a pity the current
version of XL doesn't let me have the full colour palette, otherwise I could
make some sort of heat map. The font size changes actually look okay.
What I'm after from you lot is:
1. Would anyone want this sort of a calculation-time profiling tool? I'm
half thinking it might make me some money 2. Any more ideas about how to
represent the output?
Any help appreciated - I'm not particularly protective of the code for this
so if anyone wants a demo I can knock one up pretty easily. At the moment
it's rather sitting at the "proof of concept" stage while I wonder whether
it's worth taking further.
Chris