{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Lodging sheet","Room Count","Lunch List","Rooming List","Roll Call"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Lodging sheet","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,9],[0,10,0,11],[2,0,4,0],[23,7,23,8],[16,0,16,1],[1,10,1,11],[23,4,23,6],[23,9,23,10],[20,4,20,6],[21,4,21,6],[22,4,22,6],[20,7,20,8],[21,7,21,8],[22,7,22,8],[17,0,17,1],[17,2,17,3],[28,11,28,12],[29,11,29,12],[17,5,17,6],[17,9,17,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[28,4,28,6],[30,11,30,12],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[29,9,29,10],[30,9,30,10],[27,9,27,10],[28,9,28,10],[27,11,27,12],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[25,2,25,3],[30,2,30,3],[19,2,19,3],[29,4,29,6],[30,4,30,6],[19,11,19,12],[19,9,19,10],[19,7,19,8],[19,4,19,6],[29,7,29,8],[30,7,30,8],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[24,7,24,8]]}
["NATIONAL DAILY APL ROSTER",null,null,null,null,null,null,null,null,null,"DAY",null,{"$f":"TODAY()","v":"2020-07-22"}]
[]
["BRANCH","ARMY","ARMY","ARMY","AIR FORCE","AIR FORCE","AIR FORCE","MARINE","MARINE","NAVY","NAVY","COAST\nGUARD","COAST\nGUARD"]
[null,"Nat'l Guard","Regular","Reserve","Nat'l Guard","Regular","Reserve","Regular","Reserve","Regular","Reserve","Regular","Reserve"]
[null,"DAG","DAR","DAV","DFG","DFR","DFV","DMR","DMV","DNR","DNV","GPR","GPV"]
[]
["727 APP",{"$f":"'Rooming List'!U2","v":0},{"$f":"'Rooming List'!U4","v":0},{"$f":"'Rooming List'!U6","v":0},{"$f":"'Rooming List'!U8","v":0},{"$f":"'Rooming List'!U10","v":0},{"$f":"'Rooming List'!U12","v":0},{"$f":"'Rooming List'!U14","v":0},{"$f":"'Rooming List'!U16","v":0},{"$f":"'Rooming List'!U18","v":0},{"$f":"'Rooming List'!U20","v":0},{"$f":"'Rooming List'!U22","v":0},{"$f":"'Rooming List'!U24","v":0}]
[]
["NO SHOW",{"$f":"'Room Count'!C3-'Rooming List'!U2","v":4},{"$f":"'Room Count'!C1+'Room Count'!C7-'Rooming List'!U4","v":6},{"$f":"'Room Count'!C5-'Rooming List'!U6","v":2},{"$f":"'Room Count'!C11-'Rooming List'!U8","v":2},{"$f":"'Room Count'!C9+'Room Count'!C15-'Rooming List'!U10","v":0},{"$f":"'Room Count'!C13-'Rooming List'!U12","v":0},{"$f":"'Room Count'!J1+'Room Count'!J5-'Rooming List'!U14","v":2},{"$f":"'Room Count'!J3-'Rooming List'!U16","v":0},{"$f":"'Room Count'!J7+'Room Count'!J11-'Rooming List'!U18","v":3},{"$f":"'Room Count'!J9-'Rooming List'!U20","v":0},{"$f":"'Room Count'!J13+'Room Count'!J17-'Rooming List'!U22","v":0},{"$f":"'Room Count'!J15-'Rooming List'!U24","v":0}]
[]
["727 ENL",{"$f":"'Rooming List'!U3","v":0},{"$f":"'Rooming List'!U5","v":0},{"$f":"'Rooming List'!U7","v":0},{"$f":"'Rooming List'!U9","v":0},{"$f":"'Rooming List'!U11","v":0},{"$f":"'Rooming List'!U13","v":0},{"$f":"'Rooming List'!U15","v":0},{"$f":"'Rooming List'!U17","v":0},{"$f":"'Rooming List'!U19","v":0},{"$f":"'Rooming List'!U21","v":0},{"$f":"'Rooming List'!U23","v":0},{"$f":"'Rooming List'!U25","v":0}]
[]
["NO SHOW",{"$f":"'Room Count'!C4-'Rooming List'!U3","v":0},{"$f":"'Room Count'!C2-'Rooming List'!U5","v":0},{"$f":"'Room Count'!C6-'Rooming List'!U7","v":1},{"$f":"'Room Count'!C12-'Rooming List'!U9","v":0},{"$f":"'Room Count'!C10-'Rooming List'!U11","v":0},{"$f":"'Room Count'!C14-'Rooming List'!U13","v":0},{"$f":"'Room Count'!J2-'Rooming List'!U15","v":0},{"$f":"'Room Count'!J4-'Rooming List'!U17","v":0},{"$f":"'Room Count'!J8-'Rooming List'!U19","v":1},{"$f":"'Room Count'!J10-'Rooming List'!U21","v":0},{"$f":"'Room Count'!J14-'Rooming List'!U23","v":0},{"$f":"'Room Count'!J16-'Rooming List'!U25","v":0}]
[null,null,null,null,null,null,null,null,null,4]
["TOTAL",{"$f":"SUM(B7, B11)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(M7, M11)","v":0}]
[]
["DAILY TOTAL",null,{"$f":"SUM(B15, C15, D15, E15, F15, G15, H15, I15, J15, K15, L15, M15)","v":0}]
["PROJECTION TOTAL",null,{"$f":"SUM(B19:M19)","v":21},null,null,"NO SHOW",null,{"$f":"SUM(B22:M22)","v":21},null,"WALK ON",null,{"$f":"SUM(B23:M23)","v":0}]
["Apl Projection",{"$f":"SUM('Room Count'!E3:E4)","v":4},{"$f":"SUM('Room Count'!E1,'Room Count'!E2,'Room Count'!E7,'Room Count'!E8)","v":6},{"$f":"SUM('Room Count'!E5,'Room Count'!E6)","v":3},{"$f":"SUM('Room Count'!E11,'Room Count'!E12)","v":2},{"$f":"SUM('Room Count'!E9,'Room Count'!E10,'Room Count'!E15,'Room Count'!E16)","v":0},{"$f":"SUM('Room Count'!E13,'Room Count'!E14)","v":0},{"$f":"SUM('Room Count'!L1:L2,'Room Count'!L5:L6)","v":2},{"$f":"SUM('Room Count'!L3:L4)","v":0},{"$f":"SUM('Room Count'!L7:L8,'Room Count'!L11:L12)","v":4},{"$f":"SUM('Room Count'!L9:L10)","v":0},{"$f":"SUM('Room Count'!L13:L14,'Room Count'!L17:L18)","v":0},{"$f":"SUM('Room Count'!L15:L16)","v":0}]
["APL in house",{"$f":"SUM(B24:B31)","v":{"$error":"#VALUE!"}},{"$f":"SUM(C24:D31)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(E24:G31)","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(H24:I31)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(J24:K31)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(L24:M31)","v":{"$error":"#VALUE!"}}]
["TOTAL",{"$f":"SUM(B7,B11)","v":0},{"$f":"SUM(C7,C11)","v":0},null,{"$f":"SUM(E7,E11,F11,F7,G7,G11)","v":0},null,null,{"$f":"SUM(H7,H11,I7,I11)","v":0},null,{"$f":"SUM(J7,J11,K11,K7)","v":0},null,{"$f":"SUM(L7,L11,M11,M7)","v":0}]
["N.S. TOTAL",{"$f":"SUM(B9,B13)","v":4},{"$f":"SUM(C9,D9,C13,D13)","v":9},null,{"$f":"SUM(E9,F9,G9,E13,F13,G13)","v":2},null,null,{"$f":"SUM(H9,I9,H13,I13)","v":2},null,{"$f":"SUM(J9,K9,J13,K13)","v":4},null,{"$f":"SUM(L9,M9,L13,M13)","v":0}]
["WALK ON",{"$f":"SUM(COUNTIFS(RoomingList[NOTES],\"Walk On\", RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":0},{"$f":"SUM(COUNTIFS(RoomingList[NOTES],\"Walk On\", RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\"}))","v":0},null,{"$f":"SUM(COUNTIFS(RoomingList[NOTES],\"Walk On\", RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\"}))","v":0},null,null,{"$f":"SUM(COUNTIFS(RoomingList[NOTES],\"Walk On\", RoomingList[BRANCH],{\"DMR/APP\",\"DMV/APP\",\"DMR/ENL\",\"DMV/ENL\"}))","v":0},null,{"$f":"SUM(COUNTIFS(RoomingList[NOTES],\"Walk On\", RoomingList[BRANCH],{\"DNR/APP\",\"DNV/APP\",\"DNR/ENL\",\"DNV/ENL\"}))","v":0},null,{"$f":"SUM(COUNTIFS(RoomingList[NOTES],\"Walk On\", RoomingList[BRANCH],{\"GPR/APP\",\"GPV/APP\",\"GPR/ENL\",\"GPV/ENL\"}))","v":0}]
["BEFORE",{"$f":"SUM(COUNTIFS($H$2:INDEX(H:H,ROWS(RoomingList[])+1),\"<=14\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":0},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"<=14\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"<=14\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"<=14\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"<=14\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"<=14\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]
["3PM/15:00",{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"15\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":{"$error":"#VALUE!"}},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"15\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"15\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"15\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"15\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"15\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]
["4PM/16:00",{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"16\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":{"$error":"#VALUE!"}},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"16\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"16\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"16\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"16\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"16\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]
["5PM/17:00",{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"17\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":{"$error":"#VALUE!"}},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"17\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"17\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"17\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"17\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"17\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]
["6PM/18:00",{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"18\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":{"$error":"#VALUE!"}},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"18\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"18\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"18\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"18\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"18\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]
["7PM/19:00",{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"19\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":{"$error":"#VALUE!"}},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"19\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"19\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"19\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"19\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"19\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]
["8PM/20:00",{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"20\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":{"$error":"#VALUE!"}},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"20\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"20\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"20\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"20\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\"20\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]
["AFTER",{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\">=21\",RoomingList[BRANCH],{\"DAG/APP\",\"DAG/ENL\"}))","v":{"$error":"#VALUE!"}},{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\">=21\",RoomingList[BRANCH],{\"DAR/APP\",\"DAR/ENL\",\"DAV/APP\",\"DAV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\">=21\",RoomingList[BRANCH],{\"DFR/APP\",\"DFR/ENL\",\"DFV/APP\",\"DFV/ENL\",\"DFG/APP\",\"DFG/ENL\"}))","v":{"$error":"#VALUE!"}},null,null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\">=21\",RoomingList[BRANCH],{\"DMR/APP\",\"DMR/ENL\",\"DMV/APP\",\"DMV/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\">=21\",RoomingList[BRANCH],{\"DNR/APP\",\"DNR/ENL\"}))","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(COUNTIFS('Rooming List'!H2:H252,\">=21\",RoomingList[BRANCH],{\"GPR/APP\",\"GPR/ENL\",\"GPV/APP\",\"GPV/ENL\"}))","v":{"$error":"#VALUE!"}}]

{"sheet":"Room Count","index":1,"n_rows":18,"n_cols":26,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,16,5,16],[0,22,0,23],[2,0,3,0],[2,5,3,5],[2,7,3,7],[2,12,3,12],[2,18,3,18],[2,22,2,23],[0,0,1,0],[0,5,1,5],[0,7,1,7],[0,12,1,12],[0,14,1,14],[0,16,1,16],[8,12,9,12],[8,14,9,14],[4,0,5,0],[4,5,5,5],[4,7,5,7],[4,12,5,12],[4,14,5,14],[6,0,7,0],[6,5,7,5],[6,7,7,7],[6,12,7,12],[6,18,7,18],[16,7,17,7],[16,12,17,12],[16,13,17,13],[8,16,9,16],[10,0,11,0],[10,5,11,5],[10,7,11,7],[10,12,11,12],[12,0,13,0],[12,5,13,5],[12,7,13,7],[12,12,13,12],[12,14,13,14],[8,0,9,0],[8,5,9,5],[8,7,9,7],[12,16,13,16],[14,0,15,0],[14,5,15,5],[14,7,15,7],[14,12,15,12]]}
["DAR","APP",6,"MALE",4,{"$f":"SUM(E1,E3,E5)","v":7},null,"DMR","APP",1,"MALE",1,{"$f":"SUM(L1,L3)","v":1},null,{"$f":"SUM(F1,F9,M1,M5,M9)","v":12},null,{"$f":"EVEN(O1)","v":12},null,null,null,null,null,"APP",null,{"$f":"SUM(C1,C3,C5,C7,C9,C11,C13,C15,J1,J3,J5,J7,J9,J11,J13,J15,J17)","v":19},{"$f":"Y1/$N$17","v":0.90476190476190477}]
[null,"ENL",null,"FEMALE",2,null,null,null,"ENL",null,"FEMALE"]
["DAG","APP",4,"MALE",2,{"$f":"SUM(E2,E4,E6)","v":6},null,"DMV","APP",null,"MALE",null,{"$f":"SUM(L2,L4)","v":0},null,null,null,null,null,{"$f":"SUM(O1,O9)","v":13},null,null,null,"ENL",null,{"$f":"SUM(C2,C4,C6,C8,C10,C12,C14,C16,J2,J4,J6,J8,J10,J12,J14,J16,J18)","v":2},{"$f":"Y3/$N$17","v":9.5238095238095233E-2}]
[null,"ENL",null,"FEMALE",2,null,null,null,"ENL",null,"FEMALE"]
["DAV","APP",2,"MALE",1,{"$f":"SUM(E7)","v":0},null,"DMZ","APP",1,"MALE",1,{"$f":"SUM(L7,L9)","v":2},null,{"$f":"SUM(F3,F11,M3,M7,M11)","v":8},null,{"$f":"EVEN(O5)","v":8}]
[null,"ENL",1,"FEMALE",2,null,null,null,"ENL",null,"FEMALE"]
["DAZ","APP",null,"MALE",null,{"$f":"SUM(E8)","v":0},null,"DNR","APP",3,"MALE",2,{"$f":"SUM(L8,L10)","v":2},null,null,null,null,null,{"$f":"SUM(O5,O13)","v":8}]
[null,"ENL",null,"FEMALE",null,null,null,null,"ENL",1,"FEMALE",2]
["DFR","APP",null,"MALE",null,{"$f":"SUM(E9,E11,E13)","v":2},null,"DNV","APP",null,"MALE",null,{"$f":"SUM(L13,L15)","v":0},null,{"$f":"SUM(F5,F13,M13)","v":1},null,{"$f":"EVEN(O9)","v":2}]
[null,"ENL",null,"FEMALE",null,null,null,null,"ENL",null,"FEMALE"]
["DFG","APP",2,"MALE",2,{"$f":"SUM(E10,E12,E14)","v":0},null,"DNZ","APP",null,"MALE",null,{"$f":"SUM(L14,L16)","v":0}]
[null,"ENL",null,"FEMALE",null,null,null,null,"ENL",null,"FEMALE"]
["DFV","APP",null,"MALE",null,{"$f":"SUM(E15)","v":0},null,"GPR","APP",null,"MALE",null,{"$f":"SUM(L5, L11,L17)","v":1},null,{"$f":"SUM(F7,F15,M15)","v":0},null,{"$f":"EVEN(O13)","v":0}]
[null,"ENL",null,"FEMALE",null,null,null,null,"ENL",null,"FEMALE"]
["DFZ","APP",null,"MALE",null,{"$f":"SUM(E16)","v":0},null,"GPV","APP",null,"MALE",null,{"$f":"SUM(L6, L12,L18)","v":0}]
[null,"ENL",null,"FEMALE",null,null,null,null,"ENL",null,"FEMALE"]
[null,null,null,null,null,null,null,"GPZ","APP",null,"MALE",null,"TOTAL",{"$f":"SUM(F1:F16,M1:M16)","v":21}]
[null,null,null,null,null,null,null,null,"ENL",null,"FEMALE"]

{"sheet":"Lunch List","index":2,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[9,2,9,4],[12,2,12,4],[11,2,11,4],[10,2,10,4],[26,11,26,14],[26,15,26,21],[3,5,5,19],[28,12,28,14],[22,11,22,20],[24,11,24,14],[28,15,28,21],[1,2,1,3],[3,2,5,4],[3,1,5,1],[21,2,21,4],[24,15,24,21],[17,2,17,4],[20,2,20,4],[19,2,19,4],[18,2,18,4],[13,2,13,4],[8,2,8,4],[7,2,7,4],[6,2,6,4],[16,2,16,4],[15,2,15,4],[14,2,14,4]]}
[]
[null,"Date:",{"$f":"TODAY()+1","v":"2020-07-23"}]
[]
[null,"MEAT","CHEESE",null,null,"RUNNING COUNT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,"HAM","AMERICAN",null,null,{"$f":"IF('Rooming List'!S2>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S2>=15,\"X\",\" \")","v":" "}]
[null,"HAM","CHEDDAR",null,null,{"$f":"IF('Rooming List'!S3>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S3>=15,\"X\",\" \")","v":" "}]
[null,"HAM","SWISS",null,null,{"$f":"IF('Rooming List'!S4>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S4>=15,\"X\",\" \")","v":" "}]
[null,"HAM","NONE",null,null,{"$f":"IF('Rooming List'!S5>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S5>=15,\"X\",\" \")","v":" "}]
[null,"ROAST BEEF","AMERICAN",null,null,{"$f":"IF('Rooming List'!S6>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S6>=15,\"X\",\" \")","v":" "}]
[null,"ROAST BEEF","CHEDDAR",null,null,{"$f":"IF('Rooming List'!S7>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S7>=15,\"X\",\" \")","v":" "}]
[null,"ROAST BEEF","SWISS",null,null,{"$f":"IF('Rooming List'!S8>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S8>=15,\"X\",\" \")","v":" "}]
[null,"ROAST BEEF","NONE",null,null,{"$f":"IF('Rooming List'!S9>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S9>=15,\"X\",\" \")","v":" "}]
[null,"TURKEY","AMERICAN",null,null,{"$f":"IF('Rooming List'!S10>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S10>=15,\"X\",\" \")","v":" "}]
[null,"TURKEY","CHEDDAR",null,null,{"$f":"IF('Rooming List'!S11>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S11>=15,\"X\",\" \")","v":" "}]
[null,"TURKEY","SWISS",null,null,{"$f":"IF('Rooming List'!S12>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S12>=15,\"X\",\" \")","v":" "}]
[null,"TURKEY","NONE",null,null,{"$f":"IF('Rooming List'!S13>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S13>=15,\"X\",\" \")","v":" "}]
[null,"VEGGIE","AMERICAN",null,null,{"$f":"IF('Rooming List'!S14>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S14>=15,\"X\",\" \")","v":" "}]
[null,"VEGGIE","CHEDDAR",null,null,{"$f":"IF('Rooming List'!S15>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S15>=15,\"X\",\" \")","v":" "}]
[null,"VEGGIE","SWISS",null,null,{"$f":"IF('Rooming List'!S16>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S16>=15,\"X\",\" \")","v":" "}]
[null,"VEGGIE","NONE",null,null,{"$f":"IF('Rooming List'!S17>=1,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=2,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=3,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=4,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=5,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=6,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=7,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=8,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=9,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=10,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=11,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=12,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=13,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=14,\"X\",\" \")","v":" "},{"$f":"IF('Rooming List'!S17>=15,\"X\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"SANDWICH  TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(U7:U22)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SIGN:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PRINT:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TELE:"]

{"sheet":"Rooming List","index":3,"n_rows":393,"n_cols":21,"rows_kept":393,"cut":false,"hidden":false,"merged":[[391,0,392,0],[381,0,382,0],[383,0,384,0],[385,0,386,0],[387,0,388,0],[389,0,390,0],[371,0,372,0],[373,0,374,0],[375,0,376,0],[377,0,378,0],[379,0,380,0],[361,0,362,0],[363,0,364,0],[365,0,366,0],[367,0,368,0],[369,0,370,0],[351,0,352,0],[353,0,354,0],[355,0,356,0],[357,0,358,0],[359,0,360,0],[341,0,342,0],[343,0,344,0],[345,0,346,0],[347,0,348,0],[349,0,350,0],[331,0,332,0],[333,0,334,0],[335,0,336,0],[337,0,338,0],[339,0,340,0],[321,0,322,0],[323,0,324,0],[325,0,326,0],[327,0,328,0],[329,0,330,0],[311,0,312,0],[313,0,314,0],[315,0,316,0],[317,0,318,0],[319,0,320,0],[301,0,302,0],[303,0,304,0],[305,0,306,0],[307,0,308,0],[309,0,310,0],[291,0,292,0],[293,0,294,0],[295,0,296,0],[297,0,298,0],[299,0,300,0],[281,0,282,0],[283,0,284,0],[285,0,286,0],[287,0,288,0],[289,0,290,0],[271,0,272,0],[273,0,274,0],[275,0,276,0],[277,0,278,0],[279,0,280,0],[263,0,264,0],[265,0,266,0],[267,0,268,0],[269,0,270,0],[129,2,129,4],[130,2,130,4],[18,12,18,14],[19,12,19,14],[9,12,10,14],[123,2,123,4],[196,2,197,4],[124,2,124,4],[125,2,125,4],[126,2,126,4],[116,2,117,4],[119,2,120,4],[119,5,120,5],[121,2,122,4],[121,5,122,5],[9,15,10,15],[11,12,12,14],[11,15,12,15],[14,12,14,14],[15,12,15,14]]}
["#","ROOM","NAME","SANDWICH","BRANCH","NOTES","TIME"]
[1,null,null,null,null,null,null,{"$f":"HOUR(G2)","v":0},null,null,null,null,null,null,null,null,null,"H/A",{"$f":"COUNTIF($D$2:$D$363,\"h/a\")","v":0},"DAG/APP",{"$f":"COUNTIF(E2:E340,\"DAG/APP\")","v":0}]
[2,null,null,null,null,null,null,{"$f":"HOUR(G3)","v":0},null,null,null,null,null,null,null,null,null,"H/CH",{"$f":"COUNTIF($D$2:$D$363,\"h/ch\")","v":0},"DAG/ENL",{"$f":"COUNTIF(E2:E340,\"DAG/ENL\")","v":0}]
[3,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"H/S",{"$f":"COUNTIF($D$2:$D$363,\"h/s\")","v":0},"DAR/APP",{"$f":"COUNTIF(E2:E340,\"DAR/APP\")","v":0}]
[4,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"H/N",{"$f":"COUNTIF($D$2:$D$363,\"h/n\")","v":0},"DAR/ENL",{"$f":"COUNTIF(E2:E340,\"DAR/ENL\")","v":0}]
[5,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"RB/A",{"$f":"COUNTIF($D$2:$D$363,\"rb/a\")","v":0},"DAV/APP",{"$f":"COUNTIF(E2:E340,\"DAV/APP\")","v":0}]
[6,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"RB/CH",{"$f":"COUNTIF($D$2:$D$363,\"rb/ch\")","v":0},"DAV/ENL",{"$f":"COUNTIF(E2:E340,\"DAV/ENL\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"RB/S",{"$f":"COUNTIF($D$2:$D$363,\"rb/s\")","v":0},"DFG/APP",{"$f":"COUNTIF(E2:E340,\"DFG/APP\")","v":0}]
[7,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"RB/N",{"$f":"COUNTIF($D$2:$D$363,\"rb/n\")","v":0},"DFG/ENL",{"$f":"COUNTIF(E2:E340,\"DFG/ENL\")","v":0}]
[8,null,null,null,null,null,null,0,null,null,null,null,"SANDWICHES",null,null,{"$f":"SUM(S2:S17)","v":0},null,"T/A",{"$f":"COUNTIF($D$2:$D$363,\"t/a\")","v":0},"DFR/APP",{"$f":"COUNTIF(E2:E340,\"DFR/APP\")","v":0}]
[9,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"T/CH",{"$f":"COUNTIF($D$2:$D$363,\"t/ch\")","v":0},"DFR/ENL",{"$f":"COUNTIF(E2:E340,\"DFR/ENL\")","v":0}]
[10,null,null,null,null,null,null,0,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(U2:U25)","v":0},null,"T/S",{"$f":"COUNTIF($D$2:$D$363,\"t/s\")","v":0},"DFV/APP",{"$f":"COUNTIF(E2:E340,\"DFV/APP\")","v":0}]
[11,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"T/N",{"$f":"COUNTIF($D$2:$D$363,\"t/n\")","v":0},"DFV/ENL",{"$f":"COUNTIF(E2:E340,\"DFV/ENL\")","v":0}]
[12,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"V/A",{"$f":"COUNTIF($D$2:$D$363,\"v/a\")","v":0},"DMR/APP",{"$f":"COUNTIF(E2:E340,\"DMR/APP\")","v":0}]
[13,null,null,null,null,null,null,0,null,null,null,null,"MALE ROOMS",null,null,{"$f":"COUNTIF(B2:B393,\"*m*\")","v":0},null,"V/CH",{"$f":"COUNTIF($D$2:$D$363,\"v/ch\")","v":0},"DMR/ENL",{"$f":"COUNTIF(E2:E340,\"DMR/ENL\")","v":0}]
[14,null,null,null,null,null,null,0,null,null,null,null,"FEMALE ROOMS",null,null,{"$f":"COUNTIF(B2:B393,\"*f*\")","v":0},null,"V/S",{"$f":"COUNTIF($D$2:$D$363,\"v/s\")","v":0},"DMV/APP",{"$f":"COUNTIF(E2:E340,\"DMV/APP\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"V/N",{"$f":"COUNTIF($D$2:$D$363,\"v/n\")","v":0},"DMV/ENL",{"$f":"COUNTIF(E2:E340,\"DMV/ENL\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"DNR/APP",{"$f":"COUNTIF(E2:E340,\"DNR/APP\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,"MALE IN-HOUSE",null,null,{"$f":"COUNTIFS(B2:B393,\"*m*\",C2:C393,\"=* *\")","v":0},null,null,null,"DNR/ENL",{"$f":"COUNTIF(E2:E340,\"DNR/ENL\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,"FEMALE IN-HOUSE",null,null,{"$f":"COUNTIFS(B2:B393,\"*f*\",C2:C393,\"=* *\")","v":0},null,null,null,"DNV/APP",{"$f":"COUNTIF(E2:E340,\"DNV/APP\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"DNV/ENL",{"$f":"COUNTIF(E2:E340,\"DNV/ENL\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"GPR/APP",{"$f":"COUNTIF(E2:E340,\"GPR/APP\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"GPR/ENL",{"$f":"COUNTIF(E2:E340,\"GPR/ENL\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"GPV/APP",{"$f":"COUNTIF(E2:E340,\"GPV/APP\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"GPV/ENL",{"$f":"COUNTIF(E2:E340,\"GPV/ENL\")","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"COUNTIF(J2:J252,\"GPR/APP\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"COUNTIF(J2:J252,\"GPR/ENL\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"COUNTIF(J2:J252,\"GPV/APP\")","v":0}]
[null,null,null,null,null,null,null,0,null,null,{"$f":"COUNTIF(E2:E393,\"GPV/ENL\")","v":0},null,null,null,null,{"$f":"COUNTIF(J2:J252,\"GPV/ENL\")","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"HOUR(G67)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"HOUR(G194)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"HOUR(G219)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"HOUR(G283)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B340","v":0},{"$f":"IF(F340=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F342=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,{"$f":"B344","v":0},{"$f":"IF(F344=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F346=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F348=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F350=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F352=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F354=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F356=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F358=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F360=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F362=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F364=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F366=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F368=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F370=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F372=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F374=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F376=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F378=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F380=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F382=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F384=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F386=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F388=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F390=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]
[]
[null,0,{"$f":"IF(F392=\"OC\",\"OFFICER CANDIDATE\",)","v":0}]

{"sheet":"Roll Call","index":4,"n_rows":81,"n_cols":4,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["#","Room","Name","Signature"]
[{"$f":"RoomingList[[#This Row],['#]]","v":1},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":2},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":3},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":4},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":5},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":6},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":7},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":8},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":9},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":10},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":11},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":12},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":13},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":14},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[{"$f":"RoomingList[[#This Row],['#]]","v":0},{"$f":"RoomingList[[#This Row],[ROOM]]","v":0},{"$f":"RoomingList[[#This Row],[NAME]]","v":0}]
[null,null,{"$f":"'Rooming List'!#REF!","v":{"$error":"#REF!"}}]