Q: What is the purpose of this chart?
A: To identify whether your CM measurements are going up or down over one month’s time.
Q: Where is further explanation of the chart?
A: At the bottom of the thread in a Johnn post
Let’s confirm the *.ods upload works:
centimeter_chart_libre_calc_2019_04.ods (62.0 KB)
That seems OK.
Now…calling any and all LibreOffice users!
Please download and try opening the above one-page LibreOffice Calc (.ods) file.
When you open the ods file you should see what the pdf shows:
Spreadsheet, chart, legend.
Updating the spreadsheet values should automatically update the graph.
Please post your success or failure and your LibreOffice version.
Mine is Version: 22.214.171.124
If failure, also please post the description (file just didn’t open, truncated part of the display, didn’t update graphs etc.).
Key to the fields and abbreviations:
R = right
L = left
B = both
am = A.M
pm = P.M
leftmost column = days of the month: 1…30
The rest of the spreadsheet (6 columns) contains the indicated CMs
The legend at the bottom of the chart shows the color keys
There are two types: inputs and outputs and they read horizontally L to R in the legend
Inputs: Ram Rpm Lam Lpm Bam Bpm
Outputs: the (generated) line that passes most closely by the set of associated CM points for the month
Outputs example: the upper left of the legend begins “Ram Linear(Ram)” both in blue
Ram is daily right eye am msmts
Linear(Ram) is the derived “average” every day for the month.
To revise the Chart headings, grid, legend, graphic features etc. you generally have to be in “chart mode”. You get there by clicking either once or twice on the chart background. If you made the *.ods file read-only to prevent clobbering it then this will not work. You will have to close the file and make yourself a writeable version.
I hope the file works first time for you – let me know.