Wine Making Log - OpenOffice Spreadsheet

Discussion in 'Tutorials, Calculators, Wine Logs & Yeast Charts' started by timber, Sep 15, 2014.

Wine Making Forum

Help Support Winemaking Talk by donating:

  1. Sep 15, 2014 #1

    timber

    timber

    timber

    Senior Member

    Joined:
    Dec 13, 2011
    Messages:
    198
    Likes Received:
    5
    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
     
    Last edited: Sep 15, 2014
  2. Sep 15, 2014 #2

    dralarms

    dralarms

    dralarms

    Overboard as usual Staff Member Super Moderator

    Joined:
    Jul 15, 2012
    Messages:
    3,558
    Likes Received:
    1,258
    Can't open the file.
     
  3. Sep 15, 2014 #3

    timber

    timber

    timber

    Senior Member

    Joined:
    Dec 13, 2011
    Messages:
    198
    Likes Received:
    5
    What program are you trying to open it with? You'll need a program that will open a spreadsheet like Excel, OpenOffice Calc or LibreOffice Calc.
    OpenOffice or LibreOffice is a free download.

    The spreadsheet is compressed to a Zip file you'll need to UnZip that before you can open it. In Excel, you may need to import it, I will save it in Excel format (and attach that) if that's what you have.
    You'll still need to UnZip (uncompress) the file to use it.

    Dave (aka timber)
    Attachments are restricted to only the following formats ... that's why I used a zip file.
    (Valid file extensions: bmp bsm bsmx gif jpe jpeg jpg pdf png zdl zip)

    View attachment WineMakingLog.xls.zip
     
    Last edited: Sep 15, 2014
    Elmer likes this.
  4. Sep 15, 2014 #4

    dralarms

    dralarms

    dralarms

    Overboard as usual Staff Member Super Moderator

    Joined:
    Jul 15, 2012
    Messages:
    3,558
    Likes Received:
    1,258
    It was the frist one marked pdf I couldn't open, got the second one just fine. Thanks.
     
  5. Sep 15, 2014 #5

    dralarms

    dralarms

    dralarms

    Overboard as usual Staff Member Super Moderator

    Joined:
    Jul 15, 2012
    Messages:
    3,558
    Likes Received:
    1,258
    Well, I spoke too soon. I can open it on my tablet but not on my computer. Can you save it as an excel worksheet?
     
    Elmer likes this.
  6. Sep 15, 2014 #6

    Elmer

    Elmer

    Elmer

    Senior Member

    Joined:
    Feb 28, 2013
    Messages:
    1,838
    Likes Received:
    437
    Here is one I have been using, I added a formula at the bottom.
    I also trimmed alot that I did not use.
    I made sure it was all on 1 page,
    if things bleed onto a 2nd page, I tend to forget them.
    I could not post it as a Excel file, so I posted as a PDF.

    If anyone want it as a Exel (with ABV formula) send me a PM

    View attachment winemakerslog(1).pdf
     
  7. Sep 15, 2014 #7

    timber

    timber

    timber

    Senior Member

    Joined:
    Dec 13, 2011
    Messages:
    198
    Likes Received:
    5
    http://www.winemakingtalk.com/forum/f65/wine-making-log-openoffice-spreadsheet-46671/#post528763

    Excel spreadsheet is at the link above.

    As for the PDF file, you probably need to download Adobe Reader to view it. (It's free)

    Elmer has a good point about keeping it all on one page, I think I'll modify mine to just what I use for making country wines.
    I think I'll also try to make it so it will contain a link to a recipe or perhaps just put a recipe as second page.

    Enjoy,
    Dave (aka timber)
     
    Last edited: Sep 15, 2014
    Elmer likes this.
  8. Sep 15, 2014 #8

    timber

    timber

    timber

    Senior Member

    Joined:
    Dec 13, 2011
    Messages:
    198
    Likes Received:
    5
    Hi All,

    I revised the wine log for making Country Wines (got original from Tom [moderator here]). I made it fit on a single page ... then added second page for adding a Recipe. (Recipe can be Cut & Paste from a web page)
    Other modifications noted in posts above (e.g. calculating correct ABV from Start/Finish S.G and corrected for temp.)

    Enclosed (See Attachments below):
    1) Zip file with PDF and an Excel Spreadsheet Template.
    (Note: The Excel template loses some formatting when exported i.e. hidden calculations)

    2) Zip file with PDF and an LibreOffice Spreadsheet.
    (This one works better if your spreadsheet program will open it)

    Hope it makes your data entry easier ... so you can get on to more important things like tasting that wine.

    Enjoy,
    Dave (aka timber)

    View attachment Country_Wine_Log.xlt.zip

    View attachment Country_Wine_Log.ods.zip
     
    Last edited: Sep 20, 2014
  9. Oct 1, 2018 #9

    gvhorwitz

    gvhorwitz

    gvhorwitz

    Junior

    Joined:
    Sep 19, 2016
    Messages:
    3
    Likes Received:
    0
    Timber,

    This came in very handy. Thank you for your kindness

    Greg
     
  10. Mar 6, 2019 #10

    wildhair

    wildhair

    wildhair

    Member

    Joined:
    Oct 29, 2016
    Messages:
    520
    Likes Received:
    292
    Gender:
    Male
    Very nice - beats my little notebook!
     

Draft saved Draft deleted

Share This Page

Group Builder