#### timber

##### Senior Member

- Joined
- Dec 13, 2011

- Messages
- 198

- Reaction score
- 6

Hi All,

Quite some time ago I found a nice template on this forum, I believe it was made by Tom (Thanks Tom). I like it a lot, so decided to modified it so it takes Starting S.G., Starting Temp and Adjusts the Actual Starting S.G. from that.

Then I do the same with Finish S.G. and Finish Temp to adjust the Actual Finish S.G.

From these I can more accurately calculate the ABV.

I also formated cells so that dates (no matter how you enter them) are uniform, S.G. values show 3 decimal places (e.g. 1.085), T.A values show 2 decimal places (e.g. 0.65%) etc.

Should make data entry easier and hopefully end calculations more accurate.

Enjoy,

Dave (aka timber)

p.s. There's a Pdf attached for you to view and the spreadsheet is in .ods (OpenOffice Spreadsheet) format. I think you should be able to open in Excel also but when I tried some formatting was lost (i.e. hidden calculations etc).

If you use OpenOffice or LibreOffice (perhaps also Excel) you can unlock the protected cells using the password "Wine" (without quotes).

View attachment Wine_Making_Log.ods.zip

View attachment Wine_Making_Log.pdf

Quite some time ago I found a nice template on this forum, I believe it was made by Tom (Thanks Tom). I like it a lot, so decided to modified it so it takes Starting S.G., Starting Temp and Adjusts the Actual Starting S.G. from that.

Then I do the same with Finish S.G. and Finish Temp to adjust the Actual Finish S.G.

From these I can more accurately calculate the ABV.

I also formated cells so that dates (no matter how you enter them) are uniform, S.G. values show 3 decimal places (e.g. 1.085), T.A values show 2 decimal places (e.g. 0.65%) etc.

Should make data entry easier and hopefully end calculations more accurate.

Enjoy,

Dave (aka timber)

p.s. There's a Pdf attached for you to view and the spreadsheet is in .ods (OpenOffice Spreadsheet) format. I think you should be able to open in Excel also but when I tried some formatting was lost (i.e. hidden calculations etc).

If you use OpenOffice or LibreOffice (perhaps also Excel) you can unlock the protected cells using the password "Wine" (without quotes).

View attachment Wine_Making_Log.ods.zip

View attachment Wine_Making_Log.pdf

Last edited: