+- The CB1100 Community Forum (https://cb1100forum.net/forum)
+-- Forum: Honda CB1100 Discussions (https://cb1100forum.net/forum/forumdisplay.php?fid=5)
+--- Forum: Seat Time (https://cb1100forum.net/forum/forumdisplay.php?fid=9)
+--- Thread: CB1100 forum miles (/showthread.php?tid=11035)
RE: CB1100 forum miles - Cormanus - 10-02-2020
Fixed now, Ferret. I hope.
RE: CB1100 forum miles - the Ferret - 10-03-2020
yep seems to be working now...thanks
RE: CB1100 forum miles - peterbaron - 10-03-2020
What, someone is fixing miles number...
Lot's of competition, especially in 8K range...
RE: CB1100 forum miles - emptysea - 10-03-2020
I fixed the formulas in each “Sum” cell so that it adds Jan thru Dec. PB typed a number in the Sum cell which removed the formula for him. He will have to update his monthly numbers if he wants to get an accurate total.
RE: CB1100 forum miles - Cormanus - 10-03-2020
Thanks, MTC.
RE: CB1100 forum miles - peterbaron - 10-06-2020
How would I loose about 7000 miles...unless someone slapped me with huge demerit points??
RE: CB1100 forum miles - Cormanus - 10-06-2020
Peter, from what MTC said, you typed a total in the ‘sum’ column which should not be touched by user of the spreadsheet. He corrected the column to reinstate the forumula. See the instruction at the top which says “Don’t touch coloured fields.” Enter any data for each month in the relevant column and the spreadsheet will add it up. Or would if you hadn’t again entered a number in the sum column.
Please enter data in one or more of the month columns. It probably doesn’t matter which one, really.
I’ve reinstated the formula and added 83 miles in October to bring you back to the total of 2080 you’d entered.
RE: CB1100 forum miles - peterbaron - 10-06-2020
aaaah....
Didn't take the spreadsheet course when in kindergarten....will fix my total later on, after checking odo.
I just read MTC post #371. Unknowingly, I screwed up the entire spreadsheet/formula, my bad, sorry!!
TY
RE: CB1100 forum miles - Cormanus - 10-06-2020
Peter, no problem. You only changed it for your row and it didn’t affect anyone else. I’ve tried to fix it so that the ‘sum’ column can no longer be changed except by Django and me and a couple of others.
RE: CB1100 forum miles - peterbaron - 10-06-2020
That's a good safety measure
