{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Popcorn inventory & money track"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":0,"comments":27,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Popcorn inventory & money track","index":0,"n_rows":30,"n_cols":70,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,61,0,62],[0,55,0,56],[0,57,0,58],[0,37,0,38],[0,59,0,60],[0,39,0,40],[0,41,0,42],[0,51,0,52],[0,53,0,54],[0,47,0,48],[0,7,0,8],[0,9,0,10],[0,31,0,32],[0,13,0,14],[0,15,0,16],[0,35,0,36],[0,25,0,26],[0,49,0,50],[0,11,0,12],[0,17,0,18],[0,33,0,34],[0,19,0,20],[0,29,0,30],[0,27,0,28],[0,43,0,44],[0,23,0,24],[0,21,0,22]],"flags":["formulas_cached_only"]}
["Unit popcorn tracking spreadsheet - see notes by hovering over cells",{"$nulls":5},"Standard allotment","Scout 1",null,"Scout 2",null,"You get the picture",{"$nulls":37},"Corrections",null,"Trade with troop 9999",null,"Trade with Troop 9999",null,"Troop 9998",null,null,null,"Pack promotional",null,"Blitz Sales",null,null,"Items checked out","Items Counted","remaining stock","full remaining cases","case remainder","Items Needed"]
[null,"Qty per ","cases","Total","Retail","Pack order"]
["Item","case","ordered","items","Price"]
["Military Donation",0,null,0,30,0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0]
["Helping Hands Donation",0,null,0,20,0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,0]
["Husker Tin",1,0,0,45,0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0,0]
["Cheese Lovers",1,0,0,30,0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0,0,0]
["Chocolatey Caramel Crunch",12,0,0,25,0,2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
["Salted Caramel Popcorn Bag",12,0,0,25,0,3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
["18-Pack Kettle corn",6,0,0,25,0,3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
["18-Pack Unbelievable Butter Micro",6,0,0,20,0,2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
["Premium Caramel Corn (Large)",12,0,0,20,0,2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
["White Cheddar Cheese Corn",12,0,0,15,0,3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
["Classic Caramel Corn",12,0,0,10,0,8,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
["Popping Corn",12,0,0,10,0,2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0,0,0]
[]
[]
["Total Out Per Scout",{"$nulls":7},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["Money In"]
["Money Due",{"$nulls":7},0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,"<- Money Owed"]
["donations"]
["Blitz credit",{"$nulls":62},"<- Blitz Credit"]
["Online Sales",null,null,null,"Money to Treasurer:",{"$nulls":58},"<- Online credit"]
["Total product sold",null,null,null,"2018-01-01",0,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,"<- Prize Total"]
["Prize"]
[]
["Total Pack Popcorn out",0]
["Remaining Pack Popcorn",0]
["Total Money In",0]
["Total Money Due",0,null,null,"Total",0]