There are only formulas in columns ‘B’ and ‘J’.Īnyway, thank all of you who participated. The spreadsheet will delete the points in column ‘D’, move all the other points one column to the left, add those 5 columns (‘D’-‘H’), divide that total by 5 and place the result in column ‘B’. How the spreadsheet works:ġ)Ğnter the current golfing date at ‘J1’Ģ) If a person played that day, enter their points in column ‘I’ģ) “Click” any of the ‘Update’ buttons on the spreadsheet pdf file.Īttached is the spreadsheet I created. Naturally, if I was sending the file to people who are not expected to edit anything, I would save and send the file it as a. ods file as an email attachment to other people who are running win10 and have AOO installed there is also no issue. ods file via Dropbox Transfer there is no issue.Ģ) When I send the. I do not know if this situation only started since I used my new laptop, but I have no issues.Īfter further testing and reviewing, it appears the problem is with my friend’s system… not AOO… but it’s still a mystery.ġ) When I send the. Any suggestions? BTW: In Jan I purchased a new laptop with Win11.
ods, and I’ve never used the freeze option. I then emailed him another copy of my file. I’ve visited his home and witnessed this oddity in person… so I deleted AOO on his system (win10), downloaded and installed a fresh copy. However, if he ‘clicks’ on a blank cell, the correct data is reflected at the top of the spreadsheet in the formula area.
Recently, after he’s corrupted the file and receives my updated file, some rows do not show up on his monitor. I then send him a clean and corrected updated file and the process continues. He calls me with the latest scores and I update the file. However, he is a bit technically challenged and sometimes enters data (scores) in an incorrect field and overrides my formulas and macros within the file. He generally updates the handicaps each week and sends me a copy via email for backup. We are both using the same version (4.1.13). I installed AOO on his system years ago and kept it updated. He uses it to update the handicaps of 20 golfers. For several years I have been using an AOO Calc spreadsheet I created for updating a unique golf handicap system for a friend.
0 kommentar(er)
