Spreadsheet problems/lantus dose questions

Status
Not open for further replies.
phlika29

phlika29

Member Since 2014
Hi everyone

I am having issues with my spreadsheet and I don't know what to do. I set it up on my laptop but have taken to filling in with the google sheets app I downloaded to my iPad. The last few days he colours keep randomly dropping out of it and now I have just realised that the numbers aren't converting over the the US system.

Why would that be? And how do I correct it? I can see that the initial rows/cells are outlined in black but the ones I am filling in now aren't. What does this mean? I can't see how to do that on the iPad.

Please help a technically challenged individual :-D

Cheers

Sarah
 
Once you get down enough rows, the US sheet doesn't have the formulas and formatting in those rows.

You'll need to copy some rows that work to some rows that don't.

1) make sure you have a backup of the numbers - saved under a different name or printed. That's to make sure you don't lose the data you've entered.

2) on the spreadsheet you are editing, make sure you have all the world page entries in correctly. These don't have any formulas, just conditional formatting for color coding the entries. If the formatting on that page is not working, find a row that is, select that row, click on the paint roller icon, then click on the row(s) which need the formatting.

3) on the US sheet, got to the last row which worked properly. Select the entire row. Use Control-C to copy it.select the row that doesn't work and click control-V to paste the formulas in. Repeat as needed.

4) when you get a chance, read over the help file for spreadsheets to see what else it does and/or experiment on a new sheet.
 
Thanks bjm.

I think I have sorted it.

The only thing it isn't doing is inputting the date from one sheet to the other. I can't see that it has a code or anything. I am not worried about that though as can easily write them in.

I am probably being very stupid here but where is the technical advice stuff. From previous links I could see there was a technical forum yet couldn't find it again when I didn't have a direct link. :oops: :roll: doh found it now

Cheers

Sarah
 
The cells that work will have an entry something like this:
=Round(('World mmol_L'!D3*18),0)
Where the D3 is column D, row 3 from the world sheet
The cell formula, if copied, automatically adjusts to reflect the new location.

Mmol * 18 = mg/dL.
The formula is rounding the (mmol*18) to the nearest integer.
 
Status
Not open for further replies.
Back
Top