Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Bigron]

Whilst I understand that Excel is far too heavy a weapon for my limited purpose, TB, it's all we were given to use when I worked at college and it's all that I (just about) know how to use!
I am also - very clumsily - trying to use it for a daily weight record where the scales read in stones and pounds, which I had Excel convert to total pounds then kg. I have to put the relevant formulae into every cell.....is there a better way?

Ron.

[Doctor Gollum]

Calculate the data manually and add it to a Word based table

[Nick W]

Whilst I understand that Excel is far too heavy a weapon for my limited purpose, TB, it's all we were given to use when I worked at college and it's all that I (just about) know how to use!
I am also - very clumsily - trying to use it for a daily weight record where the scales read in stones and pounds, which I had Excel convert to total pounds then kg. I have to put the relevant formulae into every cell.....is there a better way?

Ron.

Move into the twentieth century and buy some scales that read in KG. No conversions required. Or any of the potential cockups that can happen.

[Bigron]

Nick, my posh Salter scales are switchable to kg but I am more comfortable with stones and pounds. My GP speaks metric, however, so I need the conversion.,
D.G., I want to enter the data daily and have the sums done automatically for me - not too much to ask, is it?

Ron.

[Nick W]

Nick, my posh Salter scales are switchable to kg but I am more comfortable with stones and pounds. My GP speaks metric, however, so I need the conversion.

Ron you don't need the data, your GP does. So push the button, and give him the numbers in a format he's expecting so he doesn't accidentally prescribe you 20kg of Diary Milk and a cucumber every day.


Cucumbers: 

[Rods2]

Assume you have got the column headings along the lines of: Date, Stone, Lbs, Kg in row one, put the lbs to kg conversion value of 0.453592 in cell D2 then set your dates up 1 to 31 in A3-A33 put into cell D3: =((B3 * 14) + C3) * D$2. The $ fixes that that cell to row 2. Copy cell D3. highlight cells D4 to D33 and paste the formula into these.

Save it as your "Rons_monthly_weight_chart_master.xls" spreadsheet so you can load it into excel, and save a copy by replacing master with the current month's date each month. Using a file name along the lines of "Rons_monthly_weight_chart_YYYY-mm.xls" it will then automatically sort in the directory by month. I always use the format "YYYY-mm-dd_HH:mm:ss" or part of it depending on the resolution I need with a common filenames like 'Backup_' as they automatically date & time sort. HH is a 24 hour clock.

Sorry to hear about you prognosis & hope you prove them wrong by living for another 20+ years.

[Bigron]

Firstly Rods2, thank you for your good wishes - I aim to go on for as long as possible!
I am doing much as you suggest, but with the addition of a "Total Pounds" column as partway conversion to kg. I use the formula thing to multiply the "Stones" figure by 14, then add that figure to the "Pounds" figure. The result gts converted to kg, but I have to do this for every cell in my primitive way....which is why I asked if there were a posher way to do it!

Ron.