In loving memory of Kenis D. Keathley 6/4/81 - 3/27/22 Loving father, husband, brother, friend and firewood hoarder Rest in peace, Dexterday

Firewood Storage Calculator / Log spreadsheet!

Discussion in 'The Wood Pile' started by Machria, Jan 27, 2014.

  1. Machria

    Machria

    Joined:
    Oct 4, 2013
    Messages:
    2,426
    Likes Received:
    4,982
    Location:
    Long Island, NY
    Well, I just brought my Firewood Hoarding to a whole new level! I wanted to create a "log" of my stacks so a few years down the road I know what was cut and stacked when, and where it came from, type of wood... I have so many stacks I started getting confused (no, it doesn't take much at all!) as to which was older...

    So anyway, while creating the log I thought why not put the dimensions of the stacks and racks into it, and let it calculate the cordage. Thought you guys might appreciate it, and/or want to use it.

    I put some sample data in it so you can see how to fill it out. Just type in the stack name, notes, dates and the dimensions in inches, and then the % of the stack filled (column L). It will then calculate the storage space you have, and the storage space your using in cord.

    Note: you can convert the calcs to feet instead if you wish, just take out the divide by 12's in the cubic feet column (column I).

    Enjoy!

    ScreenCap_0001.jpg
     

    Attached Files:

  2. stuckinthemuck

    stuckinthemuck

    Joined:
    Oct 4, 2013
    Messages:
    3,186
    Likes Received:
    14,882
    Location:
    Wandering around in the NH woods.
    I just had a V8 moment.... Here I've been scrounging in the backyard. Taking trees down for free. Picking up stuff on the side of the road... I NEVER would have even thought about burning my neighbors house!!!!:rofl: :lol:
    Screen Shot 2014-01-27 at 6.34.40 PM.png
     
    milleo, billb3, swags and 1 other person like this.
  3. Machria

    Machria

    Joined:
    Oct 4, 2013
    Messages:
    2,426
    Likes Received:
    4,982
    Location:
    Long Island, NY
    Oh yeah baby!! The cedar siding is among some of the best stuff out there!! There has been a cedar siding theif around my neighborhood for years, no idea who that might be!!!

    :D
     
    Backwoods Savage likes this.
  4. stuckinthemuck

    stuckinthemuck

    Joined:
    Oct 4, 2013
    Messages:
    3,186
    Likes Received:
    14,882
    Location:
    Wandering around in the NH woods.
    As long as some of your cedar siding is also disappearing, it couldn't possibly be you!!!:emb:
     
  5. bogydave

    bogydave

    Joined:
    Oct 8, 2013
    Messages:
    10,313
    Likes Received:
    37,217
    Location:
    Alaska, North of Anchorage & South of Fairbanks
    Goat any Pictures?
    of the wood
    not the spreadsheet . LOL :)
     
    BrianK, papadave and raybonz like this.
  6. Pallet Pete

    Pallet Pete Moderator

    Joined:
    Oct 2, 2013
    Messages:
    13,474
    Likes Received:
    54,057
    Location:
    Ovid
    Wow that would literally make me lose my mind! And what are these pictures of Goats Dave is talking about. :p
     
    swags and papadave like this.
  7. Machria

    Machria

    Joined:
    Oct 4, 2013
    Messages:
    2,426
    Likes Received:
    4,982
    Location:
    Long Island, NY
    Mitch Newton and Pallet Pete like this.
  8. Pallet Pete

    Pallet Pete Moderator

    Joined:
    Oct 2, 2013
    Messages:
    13,474
    Likes Received:
    54,057
    Location:
    Ovid
  9. bogydave

    bogydave

    Joined:
    Oct 8, 2013
    Messages:
    10,313
    Likes Received:
    37,217
    Location:
    Alaska, North of Anchorage & South of Fairbanks
    :)
    No Pictures , eh?
    :popcorn:
     
    Pallet Pete likes this.
  10. Blue Vomit

    Blue Vomit

    Joined:
    Oct 14, 2013
    Messages:
    287
    Likes Received:
    849
    Location:
    MD via PA
    The people on this website..... "That's a great idea"!

    Everyone else in this world..... "You've lost your mind".
     
  11. bogydave

    bogydave

    Joined:
    Oct 8, 2013
    Messages:
    10,313
    Likes Received:
    37,217
    Location:
    Alaska, North of Anchorage & South of Fairbanks
    Nice spreadsheet
    Can you add / get the total BTU to certain wood types per stack.
    Not sure how to lnk a word like red oak to a btu/ cord number

    Like rack 1 = 23,500,000 (oak) btu x M8 = btu in rack 1
     
    Last edited: Jan 28, 2014
  12. billb3

    billb3

    Joined:
    Oct 7, 2013
    Messages:
    10,195
    Likes Received:
    52,516
    Location:
    SE Mass
    Jeezo, data entry or CSS- I pick CSS
    I just take pics with the date turned on on the camera.
     
  13. Machria

    Machria

    Joined:
    Oct 4, 2013
    Messages:
    2,426
    Likes Received:
    4,982
    Location:
    Long Island, NY
    Easy, and pretty cool idea. I have no interest in BTU's, but you could do it very easily. Simply add another tab/sheet to the spreadsheet with 2 columns, column A = wood ID, and column B = BTU's per cord of that wood I'd. It would look like:

    Oak 20,000
    Pine. 12,000
    Black Locust. 24,000
    ......

    Then, change the wood I'd column in the main sheet to be a Drop down list (where you choose either Oak, Pine or Black Locust...), and add another column to the main sheet with the BTU calculation in it: wood I'd from sheet2 column B x cords in use (column M). Done.

    The one issue with this is, you could not mix wood types in a stack.
     
  14. Machria

    Machria

    Joined:
    Oct 4, 2013
    Messages:
    2,426
    Likes Received:
    4,982
    Location:
    Long Island, NY
    So I filled in my real data, I have 8.5 cord, 6.5 CSS, 2 cord rounds.
     
  15. bogydave

    bogydave

    Joined:
    Oct 8, 2013
    Messages:
    10,313
    Likes Received:
    37,217
    Location:
    Alaska, North of Anchorage & South of Fairbanks
    That wood work :)
    But all I have is birch 23.6 mil/cord. Be easy for me.
     
  16. Well Seasoned

    Well Seasoned Administrator

    Joined:
    Oct 3, 2013
    Messages:
    18,035
    Likes Received:
    83,752
    Location:
    N.H. WMNF
    Awesome spreadsheet! Can you custom make one for my under britches drawer? Lol :eek:
     
    Blue Vomit likes this.
  17. Machria

    Machria

    Joined:
    Oct 4, 2013
    Messages:
    2,426
    Likes Received:
    4,982
    Location:
    Long Island, NY
    The "data entry" is about 10 seconds. For a new stack, you would simply type:

    "New Stack Oak Downed tree in front yard Date 96 48 18 100%"

    Really not much to type/enter.....
     
    billb3 likes this.
  18. Jack Straw

    Jack Straw

    Joined:
    Oct 3, 2013
    Messages:
    8,392
    Likes Received:
    52,341
    Location:
    30 miles west of Albany Ny
    I just draw pictures of my firewood on the walls of my mancave.
     
    Last edited: Jan 29, 2014
    billb3 likes this.
  19. billb3

    billb3

    Joined:
    Oct 7, 2013
    Messages:
    10,195
    Likes Received:
    52,516
    Location:
    SE Mass
    Sorry, I just don't see a kodak moment in those fields :axe:
    I don't have Excel or Numbers to justify owning, just a handful of cameras.
    But if it floats your boat, fair winds and all that ......
     
  20. billb3

    billb3

    Joined:
    Oct 7, 2013
    Messages:
    10,195
    Likes Received:
    52,516
    Location:
    SE Mass
    That must impress the ladies