I need a conversion for lumber from Net Tally (actual, after kiln drying) to Green Tally as though the widths were measured when the lumber green (fresh sawn) before shrinking during drying. The average shrinkage is about 7%.
I can supply the example tally sheet with formulas if you need it but here is what is should look like:
Let me know if you get it. Thanks.
Please note that the green tally results need to adjust the net tally widths to the green tally. I'm guessing it needs a formula in each cell in the width colums.
Maybe I can explain it a little better. IF you look at the formuals in the BOARD Feet column, that calculates the volume based on the number of boards (pieces) under each width. Number of pieces in each width on the net tally are shown as
The green tally needs to take the widths from the net tally and adjust them such as (I did this by hand but need formulas which would move widths from the net tally width column to the green tally column so the end result of the board feed calculation on the green tally sheet equals the net tally board feet calculation +7%
we can do a remote session if you need it, or your can call me at XXX-XXX-XXXX.
Close, but no cigar, yet. The piece count total must remain constant. This much match the actual number of boards in the pack of lumber.
The green tally needs to pull pieces from the net tally and spread the pieces across the green tally width columns so that the end result is net footage+7%
Hi, I never received your rating?Are you having problems with what I showed you?or Are you just not sure how to rate?
Thanks. I'm attaching the full workbook so maybe you can see better what we use (Well, I can't get it to attach, do you have an email address I can send it to?). We enter the actual widths on the net tally page (different pages for different thicknesses). If you look at any of the green tally pages, you can see a formula that I can up with to convert widths from the net tally page to the green tally. Unfortunately, my formulas don't work out exactly. Maybe you have a better idea. Also, I couldn't ger your workbook using the "sumproduct" formula to round the totals correctly.
Here it is.
http://wikisend.com/download/408058/Net 2 Grn Tly.xlsx
As I said, what I came up with doesn't work so another thought, could a formula in each cell of the "Piece Count" column force it. I'm not the pro, just bumbling my way through.
The total piece count and the pieces per width must always be whole integers, not decimals, so in this case, solver doesn't work.
If it is impossible for Excel to do what I need, let me know. I certainly appreciate your efforts and of course will approve your payment for the work you've done.
Thanks, XXXXX XXXXX 377443 are the ones that don't work. Let's just leave it as is and close the case. Thanks anyway for trying to help. I just don't want to put any more of my personal money into it since I was trying to come up with something to provide a "service" to one of my customers.
Thanks for you efforts.
The problem is that in actuality, any board between 4.5" and 5.49" is counted as 5", 5.5" and 6.49" as 6" and so on. Each board shrinks 7% but in shrinking 7% doesn't always loose a full inch in measure. We have to work in averages to cover our loss in measure between net and green. We buy the lumber in green and dry it. Most customers buy on net tally measure and then it's no problem as we calculate the loss into the price. Some customers buy on green tally and still no problem, except in the case where a customer wants it on a green tally as though the boards were measured before kiln drying and shrinking.
Not really. The numbers shown and calculated results always have to be whole numbers.
I was trying to explain that a 5" board (for example) could stay a 5" (4.75/0.93=5.11 which is a 5" board) or it could be a 6" (5.25/0.93=5.65" which is a 6" board), etc.
Since widths entered on the net tally sheet are whole numbers and the numbers on the green tally sheet (piece count in widths: columns) must be whole numbers, it's a matter of spreading out the widths on the green tally sheet so that the end result in the board feet calculation equals the net/0.93.
LOL! I understand. I've been working in the lumber business for 41 years and still it's hard to explain to a novice. But then sometimes I have a hard time understanding computer speak.
I really appreciate your trying.
Thanks for all your efforts
I've rated it. I agree to pay the $38. "That's all folks"