{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Calculator"],"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":14,"n_cols":3,"rows_kept":14}
[null,"RETURN CALCULATOR"]
[null,"Instructions:"]
[]
[null,1,"Log in to the Trail's End Leader Portal at http://scouting.trails-end.com"]
[null,2,"Scroll down to the Product section"]
[null,3,"Click on the CALCULATOR tab at the bottom to enter in the total containers (CALCULATE CASES INTO CONTAINERS) "]
[null,4,"Use the \"QTY ORDERED\" numbers for each product in the PURPLE boxes"]
[null,5,"Use the \"SOLD QTY\" numbers for each product in the BLUE boxes"]
[null,null,"The sheet will self populate after that. "]
[]
[null,"Use the results to determine if you are over or under the 15% return limit, and what products you would like to keep. "]
[null,"If you need to unprotect the sheet, the password is popcorn"]
[]
[null,"If you have a discrepancy, please report it to Becki at bwhitaker@northernstar.org or 612-261-2403 before Nov 17 at noon."]

{"sheet":"Calculator","index":1,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[0,2,1,2],[0,4,1,4],[0,6,1,6],[0,8,1,8],[2,1,3,1],[2,3,3,3],[2,5,3,5],[2,7,3,7],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,12,3,12],[4,1,5,1],[4,3,5,3],[4,5,5,5],[4,7,5,7],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[6,1,7,1],[6,3,7,3],[6,5,7,5],[6,7,7,7],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[8,1,9,1],[8,3,9,3],[8,5,9,5],[8,7,9,7],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[10,1,11,1],[10,3,11,3],[10,5,11,5],[10,7,11,7],[10,9,11,9],[10,10,11,10],[10,11,11,11],[10,12,11,12],[12,1,13,1],[12,3,13,3],[12,5,13,5],[12,7,13,7],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[14,1,15,1],[14,3,15,3],[14,5,15,5],[14,7,15,7],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12]]}
["Product","Total Containers","-","Total Containers","=","Total Containers","x","Product","=","Total $$","Total $$","Total $$","Percentage"]
["Description","Checked out",null,"Sold",null,"to return",null,"Price",null,"Value of Checked out product","Value of SOLD","Value of Returns","Value of Returns"]
["White Cheddar",{"$nulls":4},{"$f":"B3-D3","v":0},null,{"v":20,"d":"$20.00"},null,{"$f":"B3*H3","v":{"v":0,"d":"$0.00"}},{"$f":"D3*H3","v":{"v":0,"d":"$0.00"}},{"$f":"F3*H3","v":{"v":0,"d":"$0.00"}},{"$f":"L3/J3","v":{"$error":"#DIV/0!"}}]
["6 containers = 1case"]
["Salted Caramel",{"$nulls":4},{"$f":"B5-D5","v":0},null,{"v":20,"d":"$20.00"},null,{"$f":"B5*H5","v":{"v":0,"d":"$0.00"}},{"$f":"D5*H5","v":{"v":0,"d":"$0.00"}},{"$f":"F5*H5","v":{"v":0,"d":"$0.00"}},{"$f":"L5/J5","v":{"$error":"#DIV/0!"}}]
["12 containers = 1 case"]
["Kettle Corn",{"$nulls":4},{"$f":"B7-D7","v":0},null,{"v":20,"d":"$20.00"},null,{"$f":"B7*H7","v":{"v":0,"d":"$0.00"}},{"$f":"D7*H7","v":{"v":0,"d":"$0.00"}},{"$f":"F7*H7","v":{"v":0,"d":"$0.00"}},{"$f":"L7/J7","v":{"$error":"#DIV/0!"}}]
["  12 containers = 1case"]
["Popping Corn",{"$nulls":4},{"$f":"B9-D9","v":0},null,{"v":20,"d":"$20.00"},null,{"$f":"B9*H9","v":{"v":0,"d":"$0.00"}},{"$f":"D9*H9","v":{"v":0,"d":"$0.00"}},{"$f":"F9*H9","v":{"v":0,"d":"$0.00"}},{"$f":"L9/J9","v":{"$error":"#DIV/0!"}}]
["9 containers = 1case"]
["Unbelievable Butter",{"$nulls":4},{"$f":"B11-D11","v":0},null,{"v":25,"d":"$25.00"},null,{"$f":"B11*H11","v":{"v":0,"d":"$0.00"}},{"$f":"D11*H11","v":{"v":0,"d":"$0.00"}},{"$f":"F11*H11","v":{"v":0,"d":"$0.00"}},{"$f":"L11/J11","v":{"$error":"#DIV/0!"}}]
["8 containers = 1case"]
["Choco Pretzels",{"$nulls":4},{"$f":"B13-D13","v":0},null,{"v":30,"d":"$30.00"},null,{"$f":"B13*H13","v":{"v":0,"d":"$0.00"}},{"$f":"D13*H13","v":{"v":0,"d":"$0.00"}},{"$f":"F13*H13","v":{"v":0,"d":"$0.00"}},{"$f":"L13/J13","v":{"$error":"#DIV/0!"}}]
["12 containers = 1 case"]
[null,{"$f":"SUM(B13:B14)","v":0},null,{"$f":"SUM(D13:D14)","v":0},null,{"$f":"SUM(F13:F14)","v":0},{"$nulls":3},{"$f":"SUM(J3:J14)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(K3:K14)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(L3:L14)","v":{"v":0,"d":"$0.00"}},{"$f":"L15/J15","v":{"$error":"#DIV/0!"}}]
["TOTAL "]
[{"$nulls":9},"15% of Checked out Value",null,"Over or (-Under) of the 15%"]
[{"$nulls":9},{"$f":"0.15*J15","v":{"v":0,"d":"$0.00"}},null,{"$f":"L15-J18","v":{"v":0,"d":"$0.00"}}]