Summary and Ring Views of Segment PRO

Discussion in 'Segment PRO' started by Lloyd Johnson, Feb 14, 2017.

  1. bigfoot53

    bigfoot53 PRO Member

    Good Evening Everyone,
    Just wanted to follow up on my previous post about pricing.
    I have been working on a spreadsheet to help calculate total BF and cost for my projects and have finally reached the point where I believe it works very well. I've used it on several projects and its proven to be pretty accurate but not perfect LOL.. Anyway I thought I would post it here to so hopefully it might be useful to others wanting to have a fairly quick way to know that BF and cost they would have in a particular project.
    Attached are the instruction sheet and the Excel spreadsheet.
    Ill be glad to answer questions.


    Thanks
    Bruce
     

    Attached Files:

    Bob Beaupre likes this.
  2. mfisher

    mfisher Super Moderator Staff Member

    Thanks for posting the spreadsheet.
     
  3. Bob Beaupre

    Bob Beaupre Super Moderator Staff Member

    Bruce Thanks for sharing
     
  4. Bob Beaupre

    Bob Beaupre Super Moderator Staff Member

    Bruce nice spreadsheet works well, Thank You
     
  5. Bob Beaupre

    Bob Beaupre Super Moderator Staff Member

    Bruce question on spreadsheet
    Formulas in cells C51, C52, E51, E52, B61 & B62 are only adding up the first four species.
    Looks like you need to extend those ranges.

    Let me know if I am reading it wrong
    Thanks
    Bob
     
  6. bigfoot53

    bigfoot53 PRO Member

    Good Evening Bob,
    Good Catch LOL, not sure why it didn't save those extra 2 columns but it is fixed now :)
    You should be able to copy and past your woods and prices from your current sheet into the corrected version.
    Thanks for the feedback and glad its working for you.
     
  7. Bob Beaupre

    Bob Beaupre Super Moderator Staff Member

    Thanks Bruce, I've already fixed my copy, also ran it out to 10 species and down to 100 rows
     

Share This Page