Jump to content

Recommended Posts

I've looked at this spreadsheet (https://docs.google.com/spreadsheets/d/1deqhXpx9Bjp9BrlZEGBxpU6OGbReKr_cNmKGjIa_agQ/edit#gid=169259501) and the calculations used in columns H and J are using the Unprocessed values in column D. I'm not sure why the calculation is using the unprocessed value and then dividing that by 2? This calculation is used in all products.

If we talk about coral as the example, there is no "processed unprocessed" and since the value of coral in weight is 5, this spreadsheet divides the unprocessed value which has been set to 1 for some reason. Still using coral for the example, the calculation should be ((800 / 5) * 4550) = 728,000 * 1.5 (for he additional 50%) = 1,092,000 which from what I hear and from personal experience, is correct.

Think the only error in this sheet is just that is calculates the unprocessed as the sold value, but also doesn't add in the extra 50%.

If i'm wrong then let me know ^^

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now