You might also be interested in
Replies (9)
Please login or register to join the discussion.
Heat maps ? .....
Useful way of showing large amounts of data (generally 3rd party)
But - http://how.best-free-information.com/2009/04/how-to-create-a-heat-map-in-excel/
Broken links
I wanted to check out the "Other ExcelZone management reporting tutorials" only to discover that only KPI tutorial 1, KPI tutorial 2 and KPI tutorial 3 links work.
3 out of 7 ain't bad, I suppose.
3 out of 7 ain't bad...
That was by Meat Loaf wasn't it? Thanks for pointing that out - I'm sure John will be on the case shortly.
You're almost right ...
It was "Two out of three ain't bad".
Meat obviously felt that a 66.666% success rate was better than nothing. On that basis, I'm not sure that he'd have made a good auditor.
On the other hand 2 out of 7, or 42.86% is definitely nowhere near as good.
However, I am extremely pleased to report that it is now 7 out of 7 as the links have been fixed. Merci.
That was by Meat Loaf wasn't it? Thanks for pointing that out - I'm sure John will be on the case shortly.
You're not almost right ... way off
Not sure that equating 2 out of 7 to 43% (forget the spurious accuracy) would make a good auditor either!
Fat fingers wins again
Thanks for picking up on the msiytpe. Of course it was 3 out of 7 = 43% (rounded) as previously stated.
Links fixed - sorry
Our apologies again for misfunctioning links. There's an automated mechanism that doesn't like the way I paste in old links to new items and it keeps catching me out. I'll make sure to double-check next time to stop this happening again.
I have read "Tap Utmost Value of Excel" just now
I had met some complex analysis, and found that Excel can only process simple KPI computation, so someone suggested me a free power tool, named esproc.
It's a good helper to Excel I think.
Some information about it:
Excel® is the most widely-used spreadsheet tool. The nontechnical persons love to use it for computation and analysis though, they usually find the formulas and functions available in Excel® are rather poor and the VBA® is just double Dutch to them for further analysis. Thus, a huge volume of data with valuable information has been wasted in vain.
esProc is introduced to better the situation. Empowered esProc users can tap the utmost value of Excel® by taking the esProc advantages of powerful computation ability, agile and easy-to-use analysis style, and programmed running mode.
---------------------------------------------------
Check http://www.esproc.com/library/product/tap-utmost-value-of-excel.html for more details.
Sounds like an advertisement ....
So why not come clean and declare an interest instead of some covert '.. so someone suggested me a free power tool..'
Just make a disclosure