|
| Here's an example of the spreadsheet I use. I take zero credit for it, someone was kind enough to send it to me. There is a box for 5 locations and each can have it's own shrink, etc. When inputting scale tickets I just have to designate location 1, etc.
It works well, except for beans. Any FM dock on beans has to be manually entered.
That's a really 'busy' formula. Someone spent quite a bit of time on it. If there's not multiple locations with different shrink percentages I think it could be streamlined.
Edited by kwk 1/19/2022 12:33
 (1642616812833849539085720316517 (full).jpg)
 (16426168498422180770326045281438 (full).jpg)
Attachments
----------------
 1642616812833849539085720316517 (full).jpg (130KB - 277 downloads)
16426168498422180770326045281438 (full).jpg (135KB - 271 downloads)
| |
|
Equation in excel
