- Thread starter
- #21
This is absolutely fantastic. I can't wait to play with this!
Thank you gentsNice work, Kal! You’re a credit to the brotherhood.
Yup, that was effectively what I was going for with the first of the two scenarios I was asking the poster about above. If someone want to go with the second they'd add a date column for the day(s) they used multiple razors.I also use dual razors and blades on occasion - sometimes using one razor for the first pass (usually my feather a/c), then two passes with another razor. I just copied the I-M columns, and renamed Razor and Blade to Razor1, Blade1,Razor2, Blade2 - and when I use only one razor, just leave Razor2 and Blade2 blank.. seems to work okay.. Also need to add the new columns #s to the weighted average score for each day that I use two razors and blades.
I'm playing around with it this afternoon and the one thing Sheets is giving me grief with is ignoring blank cells (e.g. as would be the case how you've set up the sheet with additional columns) when calculating the weighted daily score. 'average' works as described provided there's no weighting. But if you apply that weighting it then views blank cells as having a value of zero and skews the average. And for the life of me I can't get the syntax of 'averageif' to work
Curious, what sort of metrics would you want to be able to quickly see?Very interested in the reporting that you’re playing around with!