{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["White 1","White 2","White 3","White 4","White 5","White 6","White 7","White 8","Sheet1","CHANGES"],"not_rendered":{"images":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"White 1","index":0,"n_rows":11,"n_cols":36,"rows_kept":11,"merged":[[0,0,2,35],[3,0,3,35],[4,1,4,12],[4,13,4,15],[4,16,4,21],[4,22,4,24],[4,25,4,30],[4,31,4,32],[4,34,4,35]]}
["JPERSTAT"]
[]
[]
[]
["7 MASTER","2. CURRENT ASSIGNED",{"$nulls":11},"3. DETACHED",null,null,"4. CIVLIAN",{"$nulls":8},"8. LOCATION",{"$nulls":8},"12. STRENGTH"]
["1. UNITS","a. REQUIRED STRENGTH","b. Officers (REQ)","c. Officers (ASSG ARMY)","d. Officers (ASSG AIR)","e. Warrant Officers (REQ)","f. Warrant Officers (ASSG ARMY)","g. Warrant Officers(ASSG AIR)","h. Enlisted (REQ)","i. ENLISTED (ASSG ARMY)","j. ENLISTED (ASSG AIR)","k. Assigned ","l. Assigned %","a. DETACHED","b. FOB WARRIOR- REAR D","c. DETACHED TOTAL","a. DAC - DA CIVILIAN (DOD)","b. USC - US CIVILIANS","c. NUS - NON US CIVILIANS","d. CON - US CONTRACTORS","e. LN - LOCAL NATIONAL","f. TOTAL NON-MILITARY","5. FEMALE ASSG","6. US AIR FORCE TOTAL","7. US ARMY TOTAL","a. Level IV","b. C Med","c. EMERGENCY LEAVE","d. AWL - AWOL","e. DTH - DEATH","f. TOTAL  EXERCISE LOSS","9. NBL","10. TOTAL BATTLE LOSS","11. TOTAL LOSS","a. CURRENT TASK ORG STRENGTH","b. CURRENT STRENGTH %"]
["C2",{"$nulls":11},{"$f":"L7/B7","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N7:O7)","v":0},{"$nulls":5},{"$f":"SUM(Q7:U7)","v":0},null,{"$f":"SUM(E7+H7+K7)","v":0},{"$f":"SUM(D7+G7+J7)","v":0},{"$nulls":5},{"$f":"SUM(Z7:AD7)","v":0},null,{"$f":"SUM(AF7:AF7)","v":0},{"$f":"AG7+P7+AE7","v":0},{"$f":"L7-AH7","v":0},{"$f":"AI7/B7","v":{"$error":"#DIV/0!"}}]
["MED",{"$nulls":11},{"$f":"L8/B8","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N8:O8)","v":0},{"$nulls":5},{"$f":"SUM(Q8:U8)","v":0},null,{"$f":"SUM(E8+H8+K8)","v":0},{"$f":"SUM(D8+G8+J8)","v":0},{"$nulls":5},{"$f":"SUM(Z8:AD8)","v":0},null,{"$f":"SUM(AF8:AF8)","v":0},{"$f":"AG8+P8+AE8","v":0},{"$f":"L8-AH8","v":0},{"$f":"AI8/B8","v":{"$error":"#DIV/0!"}}]
["SURVEY",{"$nulls":11},{"$f":"L9/B9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(N9:O9)","v":0},{"$nulls":5},{"$f":"SUM(Q9:U9)","v":0},null,{"$f":"SUM(E9+H9+K9)","v":0},{"$f":"SUM(D9+J9)","v":0},{"$nulls":5},{"$f":"SUM(Z9:AD9)","v":0},null,{"$f":"SUM(AF9:AF9)","v":0},{"$f":"AG9+P9+AE9","v":0},{"$f":"L9-AH9","v":0},{"$f":"AI9/B9","v":{"$error":"#DIV/0!"}}]
[]
["TF TOTAL",{"$f":"SUM(B7:B9)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"L11/B11","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N7:N9)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(E11,H11,K11)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D11,G11,J11)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(Z7:Z9)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AA7:AA9)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(AC7:AC9)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AD7:AD9)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AE7:AE9)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AF7:AF9)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AG7:AG9)","v":{"v":0,"d":"0.00"}},{"$f":"AG11+V11+P11+AE11","v":{"v":0,"d":"0.00"}},{"$f":"SUM(AI7+AI8+AI9)","v":{"v":0,"d":"0.00"}},{"$f":"AI11/B11","v":{"$error":"#DIV/0!"}}]

{"sheet":"White 2","index":1,"n_rows":3,"n_cols":16,"rows_kept":3,"merged":[[0,0,0,3],[0,4,0,14],[1,0,1,14]]}
[{"$nulls":4},"Battle Roster"]
[]
["LAST FIRST MIDDLE","EDIPI","RANK","GENDER","DUTY POSITION","Location","Level IV","C Med","EMERGENCY LEAVE","AWOL","Deceased","BATTLE ROSTER #","O/W/E","Notes","INJURED/ILL LOD INITIATED?","UNIT"]

{"sheet":"White 3","index":2,"n_rows":48,"n_cols":10,"rows_kept":48,"merged":[[0,0,0,5],[3,6,13,6],[4,9,4,13],[5,9,5,13],[6,9,6,13],[7,9,7,13],[15,6,24,6],[26,6,35,6],[37,6,46,6],[42,0,43,0],[48,6,56,6]]}
["S1 RUNNING ESTIMATE",{"$nulls":5},"PHASE__  // AS OF DTG___________"]
[]
["UNIT","AUTHORIZED","ASSIGNED","%",null,null,"S1 ANALYSIS:"]
["HHC 27TH",179,150,{"$f":"C4/B4","v":{"v":0.8379888268156425,"d":"84%"}},{"$nulls":4},"LEGEND"]
[{"$nulls":8},"G","90% or greater on hand; fully mission capable"]
[{"$nulls":8},"A","70-89% on hand; mission capable, some dieficiencies"]
[{"$nulls":8},"R","50-69% on hand; marginally mission capable"]
[{"$nulls":8},"B","49% or less on hand; not mission capable"]
[]
[]
[]
[]
[]
[]
[{"$nulls":6},"FACTS/ASSUMPTIONS:"]
{"$rows_empty":10}
[{"$nulls":6},"SHORTFALLS/LIMITATIONS:"]
{"$rows_empty":10}
[{"$nulls":6},"RECOMMENDATIONS:"]
{"$rows_empty":10}
[{"$nulls":6},"RFI'S:"]

{"sheet":"White 4","index":3,"n_rows":47,"n_cols":29,"rows_kept":47,"merged":[[0,1,0,29],[1,1,1,29],[2,1,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,19],[2,20,2,23],[2,24,2,29],[3,1,3,9],[3,21,6,22],[3,26,3,29],[4,20,6,20],[4,26,4,29],[5,26,5,29],[6,26,6,28],[7,10,9,21],[7,22,9,29],[10,10,11,10],[10,12,11,12],[10,14,11,14],[10,16,11,16],[10,18,11,18],[10,20,11,20],[24,1,24,9],[26,10,27,10],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[26,22,27,29],[41,1,41,11],[41,13,41,23],[41,25,41,28],[42,9,42,11],[42,21,42,23],[68,3,68,5],[68,7,68,8],[68,9,68,10],[68,11,68,12],[68,13,68,14],[68,15,68,18]]}
[null,"S-1 Battle Tracking (ANALOG) "]
[null,"DTG:"]
[null,"ADMIN / ACCOUNTABLE DATA - ANALOG",{"$nulls":8},"DIV CP",null,"DIV ALOC",null,"BDE Main",null,"BDE BSA",null,"TAC",null," TOTAL PERSONNEL STRENGTH",{"$nulls":3},"PERSONNEL REPORTS"]
[null,"REAL WORLD PERSTAT ",{"$nulls":8},"CURRENT LOC:",null,"CURRENT LOC:",null,"CURRENT LOC:",null,"CURRENT LOC:",null,"CURRENT LOC:",null,"CAS",null,null,"%"]
[null,"UNIT","AUTHORIZED","ASSIGNED","BOG/                PRESENT","MEDICAL/                              HOSPITAL","AWOL","LEAVE/PASS","OTHER","TOTAL",{"$nulls":10},"(           )"]
[{"$nulls":10},"FREQ:","#:","FREQ:","#:","FREQ:","#:","FREQ:","#:","FREQ:","#:"]
[]
[{"$nulls":10},"TACTICAL OPERATIONS\n SLANT REPORT",{"$nulls":11},"ADMIN NOTES"]
[]
[]
[]
[]
[null,"ATTCH","AUTHORIZED","ASSIGNED","BOG/                PRESENT","MEDICAL/                              HOSPITAL","AWOL","LEAVE/PASS","OTHER","TOTAL"]
{"$rows_empty":11}
[null,"TRAINING PERSTAT (IF NEEDED)",{"$nulls":8},"COMBAT ",null,"COMBAT ",null,"COMBAT ",null,"COMBAT ",null,"COMBAT ",null,"COMBAT "]
[null,"UNIT","AUTHORIZED","ASSIGNED","BOG/                PRESENT","MEDICAL/                              HOSPITAL","AWOL","LEAVE/PASS","OTHER","TOTAL","PWR %",null,"PWR %",null,"PWR %",null,"PWR %",null,"PWR %",null,"PWR %"]
[{"$nulls":22},"CCIR"]
[]
[]
[]
[]
[]
[]
[null,"UNIT","AUTHORIZED","ASSIGNED","BOG/                PRESENT","MEDICAL/                              HOSPITAL","AWOL","LEAVE/PASS","OTHER","TOTAL"]
[]
[]
[]
[]
[{"$nulls":10},"COMBAT ",null,"COMBAT ",null,"COMBAT ",null,"COMBAT ",null,"COMBAT ",null,"COMBAT "]
[{"$nulls":10},"PWR %",null,"PWR %",null,"PWR %",null,"PWR %",null,"PWR %",null,"PWR %"]
[]
[null,"SIR / MEDICAL / LEAVE / AWOL TRACKER",{"$nulls":11},"SIR / MEDICAL / LEAVE / AWOL TRACKER",{"$nulls":11},"KEY LOCATOR ROSTER"]
[null,"NAME / UNIT",null,null,"MEDICAL/                      HOSPITAL","DATE OF ISSUE","SIR (Y/N)","LEAVE/           PASS (Y/N)","OTHER","DISPOSITION",{"$nulls":3},"NAME / UNIT",null,null,"MEDICAL/                      HOSPITAL","DATE OF ISSUE","SIR (Y/N)","LEAVE/           PASS (Y/N)","OTHER","DISPOSITION",{"$nulls":3},"ID","FREQ","Phone #","Loc."]
[]
[{"$nulls":25},"BDE CDR"]
[{"$nulls":25},"BDE XO"]
[{"$nulls":25},"BDE CSM"]

{"sheet":"White 5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"White 6","index":5,"n_rows":3,"n_cols":18,"rows_kept":3,"merged":[[0,0,0,17]]}
["EMD"]
["MTOE Auth Unit","Para/Lin","Grade","Mos/ASI","Para Title","Line Title","Name","Current Grade","PMOS","SMOS","ASI","Highest MILED","EDIPI","Unit Address","ATCH UIC","Notes","Emergency Contact NAME/Number","Battle Roster #"]
["YE1T0 HHC 2-108TH INFANTRY","101-01","O5","11A00 -","COMMAND GROUP","COMMANDER","SMITH JOSEPH JOHN","O5","11A","31A","5R","BAX","XXXXXX2106","NY 1700 PARKWAY EAST UTICA 135014297","N/A","N/A","JOSEPHINE ANN SMITH / 555-218-5555","CHS2106"]

{"sheet":"White 7","index":6,"n_rows":34,"n_cols":5,"rows_kept":34,"merged":[[0,0,0,4]]}
["Battle Roster # Worksheet"]
["UNIT","IDENTIFIER",null,"UNIT ","IDENTIFIER"]
["HQ 27th IBCT","A",null,"HHC/HHT/HHB","H"]
["1-69thIN","B",null,"A CO/TRP/BTRY","A"]
["2-108th IN","C",null,"B CO/TRP/BTRY","B"]
["1-182nd IN","D",null,"C CO/TRP/BTRY","C"]
["2-101st CAV","E",null,"D CO/TRP/BTRY","D"]
["1-258th FA","F",null,"E CO/TRP/BTRY","E"]
["427th BSB","G",null,"F CO/TRP/BTRY","F"]
["27th BSTB","H",null,"G CO/TRP/BTRY","G"]
["1-211th ARB","I",null,"204th ENG TM","I"]
["406th CSSB","J",null,"812th ENG Co","J"]
["Unassigned","K",null,"443 CA TM","K"]
[{"$nulls":3},"325 MISO TM","L"]
[{"$nulls":3},"ADA PLT (TBD)","M"]
[{"$nulls":3},"105th MP PLT","N"]
[{"$nulls":3},"519th MI PLT","O"]
[{"$nulls":3},"387 EOD Co","P"]
[{"$nulls":3},"272 (-) CHEM Co","Q"]
[{"$nulls":3},"A/1-112IN (STRYKER)","R"]
[{"$nulls":3},"B Co 3-126 AVN","S"]
[{"$nulls":3},"F Co 1-169 AVN","T"]
[{"$nulls":3},"638 ASB","U"]
[{"$nulls":3},"C Co 3-142 AVN","V"]
[{"$nulls":3},"883 Co (-)","W"]
[{"$nulls":3},"856 Co (-)","X"]
[{"$nulls":3},"237 MAINT Co (-)","Y"]
[{"$nulls":3},"1484 TC (-)","Z"]
[{"$nulls":3},"220 TC (-)","AB"]
[{"$nulls":3},"991 TC (-)","AC"]
[{"$nulls":3},"324PLT C Co 324 SIG","AD"]
[{"$nulls":3},"209th MED Co","AE"]
[{"$nulls":3},"C3 FLT PLT (TBD)","AF"]
[{"$nulls":3},"Unassigned","AG"]

{"sheet":"White 8","index":7,"n_rows":4,"n_cols":7,"rows_kept":4,"merged":[[0,0,0,10],[3,0,32,11]]}
["Personnel Replacement Tracking"]
["DTG","MOS","DMOS Assigned","Organic Unit","TF","DTG Out","DTG In"]
[]
["TBP"]

{"sheet":"Sheet1","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"CHANGES","index":9,"n_rows":93,"n_cols":7,"rows_kept":93,"hidden":true,"merged":[[0,0,0,6],[91,0,91,6]]}
["GAINS/LOSSES"]
[null,"NAME","RANK","UNIT","CURRENT LOCATION","PREVIOUS LOCATION","REASON FOR MOVEMENT"]
{"$rows_empty":89}
["LOSSES"]
[null,"NAME","RANK","UNIT","CURRENT LOCATION","PREVIOUS LOCATION","REASON FOR MOVEMENT"]