{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Radio Inventory","Equipment Location","Comm Personnel","Radio Log","Phone List","Activity Log","16 CH ICS205","20 CH ICS205","Multi Group ICS205","Waybill","Waybill Cont.","Changelog","Sheet1","Dashboard","List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":4},"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":"Radio Inventory","index":0,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1048575,0],[0,1,0,18],[1,1,1,18],[6,12,6,18],[6,1,6,11],[5,1,5,18],[2,9,2,10],[4,9,4,10],[3,9,3,10],[2,12,4,18],[4,2,4,4],[2,2,2,4],[3,2,3,4],[2,8,4,8],[2,5,4,5]]}
[null,"Incident Radio Inventory"]
[]
[null,"Incident:","My Test",null,null,null,"Issued:",{"$f":"COUNTIFS(F9:F4984,\"Issued\")","v":1},null,"Total VHF Radios:",null,{"$f":"COUNTIFS(B9:B4982,\"4381\")","v":1}]
[null,"ICP :","Fair Grounds Boise, Idaho",null,null,null,"Available:",{"$f":"COUNTIFS(F9:F4985,\"Available\")","v":0},null,"Total UHF Radios:",null,{"$f":"COUNTIFS(B9:B4982,\"4244\")","v":1}]
[null,"Date/Time:",{"$f":"TODAY()","v":"2024-01-29"},null,null,null,"Out of Service:",{"$f":"COUNTIFS(F9:F4984,\"Out Of Service\")","v":1},null,"Total Records:",null,{"$f":"COUNTA(B9:B4982)","v":2}]
[]
[null,"Equipment Information",null,null,null,null,null,null,null,null,null,null,"Personnel Information"]
[null,"NFES #","Kit #","ID","Serial #","Status","Remarks","Leather \nCase","Mag Mount","SPKR\nMic","Cloning Cable","Issued","Name","O-#","Assignment","Home Unit or Agency","Contact #","Email","Returned"]
[null,4381,"KD001","01","JNV789DJN","Issued",null,"N","N","N","N","2023-09-01","Frank Senatra",456,"Div Sup","Six Rivers National Forest",1234567891,"frank.senatra@firenet.gov"]
[null,4244,"MD001","01","987987HHG","Out Of Service","Broken Display",null,null,null,null,null,null,null,null,null,null,null,"2023-09-01"]

{"sheet":"Equipment Location","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,1048575,0],[8,1,8,15],[4,2,4,4],[2,10,4,15],[0,1,0,15],[3,2,3,4],[2,2,2,4],[7,1,7,15],[1,1,1,15],[2,7,4,7],[5,1,6,4]]}
[null,"Incident Equipment/Frequencies Inventory"]
[]
[null,"Incident:",{"$f":"'Radio Inventory'!C3","v":"My Test"},null,null," 4312 - VHF Repeaters:",{"$f":"COUNTIFS(B11:B5008,\"4312 - VHF Repeater\")","v":1},null,"A/G -  Air -to-Ground :",{"$f":"COUNTIFS(B11:B5008,\"*A/G*\")","v":0}]
[null,"ICP:",{"$f":"'Radio Inventory'!C4","v":"Fair Grounds Boise, Idaho"},null,null,"4248 - UHF Repeaters:",{"$f":"COUNTIFS(B11:B5008,\"4248 - UHF Repeater\")","v":0},null,"A/A - Air-to Air AM:",{"$f":"COUNTIFS(B11:B5008,\"A/A - Air-to-Air AM\")","v":0}]
[null,"Date/Time:",{"$f":"TODAY()","v":"2024-01-29"},null,null,"4330/4330EX - Remotes:",{"$f":"COUNTIFS(B11:B5008,\"*4330*\")","v":1},null,"A/A - Air-to-Air FM:",{"$f":"COUNTIFS(B11:B5008,\"A/A - Air-to-Air FM\")","v":0}]
[null,null,null,null,null,"4370 - Aircraft Link:",{"$f":"COUNTIFS(B11:B5008,\"*4370*\")","v":0},null,"Tactical:",{"$f":"COUNTIFS(B11:B5008,\"*Tac*\")","v":1}]
[null,null,null,null,null,"Total Equipment:",{"$f":"COUNTIFS(B11:B5008,\"*4*\")","v":5},null,"Total Non-Equip Frequencies:",{"$f":"COUNTIF(B11:B5008,\"<>*4*\")-COUNTBLANK(B11:B5008)","v":1}]
[]
[null,"Equipment Location/Frequencies and Status"]
[null,"Equipment ","Kit #","ID","S-#","RX Frequency","TX Frequency","RX/TX Tone","Location/Remarks","Lat","Long","Installed","Next Maint ","Solar","DBL Battery","Released"]
[null,"4080 - Solar Panel Kit","001",null,40,null,null,null,"Bald Knob with C1 (C121)"]
[null,"4150- SLA Battery Kit","001",null,13.2,null,null,null,"Bald Knob",450000,1164541,"2022-04-24"]
[null,"4312 - VHF Repeater","C121","C1",12.1,"168.7000","170.97500","Tone 1:  110.9","Bald Knob",454710,1162585,"2022-04-24",null,"YES","NO"]
[null,"4330 - Remote Kit","MD001",null,13.6,null,null,null,"ICP",453030,1162020,"2022-05-11",null,null,null,"2022-05-13"]
[null,"Tactical",null,null,"A-2","168.2500","168.2500","Tone 1:  110.9","Channel 1/Div A/C"]
[null,"4390 - Starter System","RS001","C1/L1",12]

{"sheet":"Comm Personnel","index":2,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,1,0,16],[2,5,2,6],[5,1,5,16],[2,4,4,4],[2,7,4,16],[1,1,1,16],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[null,"Incidedent Communications Personnel"]
[]
[null,"Incident:",{"$f":"'Radio Inventory'!C3","v":"My Test"},null,null,"Re-Assignment Availability"]
[null,"ICP Location:",{"$f":"'Radio Inventory'!C4","v":"Fair Grounds Boise, Idaho"},null,null,"Avaialble: ",{"$f":"COUNTIFS(O8:O5042,\"YES\")","v":1}]
[null,"Date Time:",{"$f":"NOW()","v":"2024-01-29T08:48:39.430"},null,null,"Not Available:",{"$f":"COUNTIFS(O8:O5042,\"NO\")","v":0}]
[]
[null,"Name","Agency","Contact #","Email","Assignment","O - #","Home Unit","City, State","Fire Quals","Start Date","End Date","Current Date","Days Left","Re-Assignment","Transportation","Vehicle ID"]
[null,"Kill Bill","USDA ",1111111111,"email@email.com","COML",3.5,"Boise National ","Boise, ID","COML, INCM","2023-09-18",{"$f":"IF(K8<>\"\",K8+14,\"\")","v":"2023-10-02"},null,{"$f":"IFERROR(DATEDIF($C$5,L8,\"D\"),\"0\")","v":"0"},"YES","POV","ID A1XXXX"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,"0"]

{"sheet":"Radio Log","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1048575,0],[7,1,7,6],[0,1,0,6],[2,2,2,4],[3,2,3,4],[4,2,4,4],[2,5,4,6],[1,1,1,6],[5,1,6,6]]}
[null,"Incident Communications Unit Radio Log"]
[]
[null,"Incident:",{"$f":"'Radio Inventory'!C3","v":"My Test"}]
[null,"ICP:",{"$f":"'Radio Inventory'!C4","v":"Fair Grounds Boise, Idaho"}]
[null,"Date/Time:",{"$f":"NOW()","v":"2024-01-29T08:48:39.430"}]
[]
[]
[null,"LOG Code:  RD= Radio Message,  VB= Verbal Message,  LL= Landline (Phone) Message,  MS= Messenger Service"]
[null,"Date","Code","Station Calling","Station Called","Information/Message","Initials"]
[null,"2023-09-19","RD","Division A","Communications","Line order A-11232","jml"]
[null,{"$f":"MyTimestamp(F11)","v":"01-29-24 08:45:35"},"RD","Division B","Communications","Radio Check","jml"]
[null,{"$f":"MyTimestamp(F12)","v":"01-29-24 08:45:35"},"RD","Div A","Communications","Weather Ops","jml"]
[null,{"$f":"MyTimestamp(F13)","v":""}]

{"sheet":"Phone List","index":4,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,1048575,0],[0,1,0,9],[1,1,1,9],[5,1,5,9],[2,7,4,9],[2,2,2,3],[3,2,3,3],[4,2,4,3],[2,4,4,6]]}
[null,"Incident Phone List "]
[]
[null,"Incident:",{"$f":"'Radio Inventory'!C3","v":"My Test"}]
[null,"Date:",{"$f":"NOW()","v":"2024-01-29T08:48:39.430"}]
[null,"ICP:",{"$f":"'Radio Inventory'!C4","v":"Fair Grounds Boise, Idaho"}]
[]
[null,"Function","Name","Number","Type","Email","Installed","Supply #","Published","Remarks"]
[null,"Test","Testing",1234567890,"Landline","test@yahoo.com","2020-11-02",123,"YES"]

{"sheet":"Activity Log","index":5,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[26,2,26,7],[27,2,27,7],[28,2,28,7],[29,2,29,7],[15,3,15,4],[15,5,15,7],[15,1,15,2],[24,2,24,7],[25,2,25,7],[23,2,23,7],[21,2,21,7],[22,2,22,7],[17,1,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[10,5,10,7],[11,5,11,7],[13,5,13,7],[14,1,14,2],[14,3,14,4],[14,5,14,7],[35,2,35,7],[4,5,4,7],[4,3,4,4],[5,3,5,4],[5,5,5,7],[9,5,9,7],[7,3,7,4],[7,5,7,7],[12,5,12,7],[8,1,8,2],[8,3,8,4],[8,5,8,7],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[31,2,31,7],[32,2,32,7],[30,2,30,7],[33,2,33,7],[34,2,34,7],[49,5,49,7],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7],[46,2,46,7],[47,2,47,7],[44,2,44,7],[45,2,45,7],[42,2,42,7],[43,2,43,7],[48,2,48,3],[48,5,48,7],[40,2,40,7],[41,2,41,7],[1,1,1,7],[2,1,2,2],[3,1,3,2],[4,1,4,2],[16,1,16,2],[16,3,16,4],[16,5,16,7],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[13,1,13,2],[13,3,13,4],[5,1,5,2],[6,1,6,7],[7,1,7,2]]}
[]
[null,"ACTIVITY LOG (ICS 214)"]
[null,"1.  Incident Name:",null,"2. Operational Period:","Date From:","2023-09-01","Date To:","2023-09-14"]
[null,{"$f":"'Radio Inventory'!C3","v":"My Test"},null,null,"Time From:",600,"Time To:",2300]
[null,"3. Name:",null,"4. ICS Position",null,"5. Home Agency (and Unit):\n"]
[null,"James Smith",null,"COML",null,"Boise National Forest"]
[null,"6. Resoureces Assigned:"]
[null,"Name",null,"ICS Position",null,"Home Agency (and Unit)"]
[null,"Jose Lopez",null,"COMT",null,"Boise National Forest"]
[null,"John Smith",null,"INCM",null,"Boise BLM"]
[null,"Test Testing",null,"RADO",null,"Sawtooth National Forest"]
[]
[]
[]
[]
[]
[]
[null,"7. Activity Log:"]
[null,"Date","Notable Activities"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"8. Prepared By:",null,null,"Position/Title:"]
[null,"ICS 214, PAGE X","Date:",null,"Signature:"]

{"sheet":"16 CH ICS205","index":6,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,1048575,0],[28,8,29,8],[30,8,31,8],[32,8,33,8],[34,8,35,8],[38,1,38,10],[34,10,35,10],[36,1,37,2],[30,10,31,10],[34,9,35,9],[36,3,37,10],[34,1,35,1],[34,2,35,2],[32,1,33,1],[32,2,33,2],[30,1,31,1],[30,2,31,2],[18,8,19,8],[20,8,21,8],[22,8,23,8],[24,8,25,8],[26,8,27,8],[8,8,9,8],[10,8,11,8],[12,8,13,8],[14,8,15,8],[16,8,17,8],[32,10,33,10],[8,10,9,10],[10,10,11,10],[12,10,13,10],[14,10,15,10],[16,10,17,10],[20,10,21,10],[22,10,23,10],[24,10,25,10],[26,10,27,10],[28,10,29,10],[28,9,29,9],[30,9,31,9],[32,9,33,9],[18,9,19,9],[20,9,21,9],[22,9,23,9],[24,9,25,9],[12,9,13,9],[14,9,15,9],[16,9,17,9],[18,10,19,10],[26,9,27,9],[28,1,29,1],[28,2,29,2],[26,1,27,1],[26,2,27,2],[24,1,25,1],[24,2,25,2],[22,1,23,1],[22,2,23,2],[20,1,21,1],[20,2,21,2],[18,1,19,1],[18,2,19,2],[16,1,17,1],[16,2,17,2],[14,1,15,1],[14,2,15,2],[12,1,13,1],[12,2,13,2],[10,1,11,1],[10,2,11,2],[8,1,9,1],[8,2,9,2],[4,10,5,10],[6,1,7,1],[6,2,7,2],[6,9,7,9],[6,10,7,10],[4,1,5,1],[4,2,5,2],[4,9,5,9],[4,8,5,8],[6,8,7,8],[8,9,9,9],[10,9,11,9],[0,1,1,3],[0,4,0,8],[1,4,1,8],[2,1,2,10],[3,3,3,4]]}
[null,"INCIDENT RADIO COMMUNICATIONS PLAN ",null,null,"1.  Incident Name",null,null,null,null,"2.  Date Time Prepared","3.  Operational Period Date/Time"]
[]
[null,"4. Basic Radio Channel Utilization\nMode:  Wide= Analog Wideband,  Narrow= Analog Narrowband,  Digital= Digital Narrowband,  Mixed= Analog/Digital"]
[null,"CH #","Function"," Frequency",null,"Tone","NAC","TGID","MODE","Assignment ","Remarks"]
[null,1,null,"RX:"]
[null,null,null,"TX:"]
[null,2,null,"RX:"]
[null,null,null,"TX:"]
[null,3,null,"RX:"]
[null,null,null,"TX:"]
[null,4,null,"RX:"]
[null,null,null,"TX:"]
[null,5,null,"RX:"]
[null,null,null,"TX:"]
[null,6,null,"RX:"]
[null,null,null,"TX:"]
[null,7,null,"RX:"]
[null,null,null,"TX:"]
[null,8,null,"RX:"]
[null,null,null,"TX:"]
[null,9,null,"RX:"]
[null,null,null,"TX:"]
[null,10,null,"RX:"]
[null,null,null,"TX:"]
[null,11,null,"RX:"]
[null,null,null,"TX:"]
[null,12,null,"RX:"]
[null,null,null,"TX:"]
[null,13,null,"RX:"]
[null,null,null,"TX:"]
[null,14,null,"RX:"]
[null,null,null,"TX:"]
[null,15,null,"RX:"]
[null,null,null,"TX:"]
[null,16,null,"RX:"]
[null,null,null,"TX:"]
[null,"5.  Prepared By (Communications Unit):"]
[]
[null,"Note:  This is not a standard NWCG ICS205 Form"]

{"sheet":"20 CH ICS205","index":7,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,1048575,0],[42,8,43,8],[30,9,31,9],[30,10,31,10],[46,1,46,10],[42,1,43,1],[32,2,33,2],[34,2,35,2],[36,2,37,2],[38,2,39,2],[40,2,41,2],[42,2,43,2],[44,1,45,2],[44,3,45,10],[32,10,33,10],[34,10,35,10],[36,10,37,10],[42,10,43,10],[32,9,33,9],[34,9,35,9],[36,9,37,9],[38,9,39,9],[40,9,41,9],[42,9,43,9],[40,1,41,1],[26,1,27,1],[26,2,27,2],[26,9,27,9],[26,10,27,10],[28,1,29,1],[28,2,29,2],[28,9,29,9],[28,10,29,10],[26,8,27,8],[28,8,29,8],[38,10,39,10],[40,10,41,10],[30,1,31,1],[30,2,31,2],[30,8,31,8],[32,8,33,8],[34,8,35,8],[36,8,37,8],[38,8,39,8],[40,8,41,8],[34,1,35,1],[36,1,37,1],[38,1,39,1],[32,1,33,1],[18,1,19,1],[18,2,19,2],[18,9,19,9],[18,10,19,10],[20,1,21,1],[20,2,21,2],[20,9,21,9],[20,10,21,10],[18,8,19,8],[20,8,21,8],[22,1,23,1],[22,2,23,2],[22,9,23,9],[22,10,23,10],[24,1,25,1],[24,2,25,2],[24,9,25,9],[24,10,25,10],[22,8,23,8],[24,8,25,8],[14,1,15,1],[14,2,15,2],[14,9,15,9],[14,10,15,10],[16,1,17,1],[16,2,17,2],[16,9,17,9],[16,10,17,10],[14,8,15,8],[16,8,17,8],[10,1,11,1],[10,2,11,2],[10,9,11,9],[10,10,11,10],[12,1,13,1],[12,2,13,2],[12,9,13,9],[12,10,13,10],[10,8,11,8],[12,8,13,8],[6,1,7,1],[6,2,7,2],[6,9,7,9],[6,10,7,10],[8,1,9,1],[8,2,9,2],[8,9,9,9],[8,10,9,10],[6,8,7,8],[8,8,9,8],[0,1,1,3],[0,4,0,8],[1,4,1,8],[2,1,2,10],[3,3,3,4],[4,1,5,1],[4,2,5,2],[4,9,5,9],[4,10,5,10],[4,8,5,8]]}
[null,"INCIDENT RADIO COMMUNICATIONS PLAN ",null,null,"1.  Incident Name",null,null,null,null,"2.  Date Time Prepared","3.  Operational Period Date/Time"]
[]
[null,"4. Basic Radio Channel Utilization\nMode:  Wide= Analog Wideband,  Narrow= Analog Narrowband,  Digital= Digital Narrowband,  Mixed= Analog/Digital"]
[null,"CH #","Function"," Frequency",null,"Tone","NAC","TGID","MODE","Assignment ","Remarks"]
[null,1,null,"RX:"]
[null,null,null,"TX:"]
[null,2,null,"RX:"]
[null,null,null,"TX:"]
[null,3,null,"RX:"]
[null,null,null,"TX:"]
[null,4,null,"RX:"]
[null,null,null,"TX:"]
[null,5,null,"RX:"]
[null,null,null,"TX:"]
[null,6,null,"RX:"]
[null,null,null,"TX:"]
[null,7,null,"RX:"]
[null,null,null,"TX:"]
[null,8,null,"RX:"]
[null,null,null,"TX:"]
[null,9,null,"RX:"]
[null,null,null,"TX:"]
[null,10,null,"RX:"]
[null,null,null,"TX:"]
[null,11,null,"RX:"]
[null,null,null,"TX:"]
[null,12,null,"RX:"]
[null,null,null,"TX:"]
[null,13,null,"RX:"]
[null,null,null,"TX:"]
[null,14,null,"RX:"]
[null,null,null,"TX:"]
[null,15,null,"RX:"]
[null,null,null,"TX:"]
[null,16,null,"RX:"]
[null,null,null,"TX:"]
[null,17,null,"RX:"]
[null,null,null,"TX:"]
[null,18,null,"RX:"]
[null,null,null,"TX:"]
[null,19,null,"RX:"]
[null,null,null,"TX:"]
[null,20,null,"RX:"]
[null,null,null,"TX:"]
[null,"5.  Prepared By (Communications Unit):"]
[]
[null,"Note:  This is not a standard NWCG ICS205 Form"]

{"sheet":"Multi Group ICS205","index":8,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,1048575,0],[46,1,46,11],[40,9,41,9],[40,10,41,10],[40,11,41,11],[32,1,33,1],[32,2,33,2],[32,3,33,3],[32,9,33,9],[32,10,33,10],[32,11,33,11],[36,1,37,1],[36,2,37,2],[36,3,37,3],[36,9,37,9],[36,10,37,10],[36,11,37,11],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,9,39,9],[38,10,39,10],[38,11,39,11],[24,9,25,9],[26,9,27,9],[28,9,29,9],[30,9,31,9],[34,9,35,9],[42,9,43,9],[12,1,13,1],[10,2,11,2],[10,3,11,3],[10,1,11,1],[28,1,29,1],[26,2,27,2],[26,3,27,3],[26,1,27,1],[24,1,25,1],[22,2,23,2],[22,3,23,3],[22,1,23,1],[42,2,43,2],[42,3,43,3],[42,1,43,1],[34,1,35,1],[30,2,31,2],[10,9,11,9],[20,1,21,1],[18,2,19,2],[18,3,19,3],[18,1,19,1],[16,1,17,1],[14,2,15,2],[14,3,15,3],[14,1,15,1],[22,9,23,9],[14,9,15,9],[16,9,17,9],[18,9,19,9],[20,9,21,9],[30,3,31,3],[30,1,31,1],[40,1,41,1],[40,2,41,2],[40,3,41,3],[6,10,7,10],[6,11,7,11],[8,2,9,2],[8,3,9,3],[8,10,9,10],[8,11,9,11],[16,2,17,2],[16,3,17,3],[16,10,17,10],[16,11,17,11],[22,11,23,11],[24,2,25,2],[24,3,25,3],[24,10,25,10],[24,11,25,11],[18,10,19,10],[18,11,19,11],[20,2,21,2],[20,3,21,3],[0,5,0,9],[1,5,1,9],[3,4,3,5],[4,2,5,2],[4,3,5,3],[4,10,5,10],[4,11,5,11],[14,10,15,10],[14,11,15,11],[10,10,11,10],[10,11,11,11],[12,2,13,2],[12,3,13,3],[12,10,13,10],[12,11,13,11],[6,2,7,2],[6,3,7,3],[4,9,5,9],[6,9,7,9],[8,9,9,9],[12,9,13,9],[20,10,21,10],[20,11,21,11],[44,1,45,3],[42,10,43,10],[42,11,43,11],[44,4,45,11],[0,1,1,4],[2,1,2,11],[4,1,5,1],[6,1,7,1],[8,1,9,1],[30,10,31,10],[30,11,31,11],[34,2,35,2],[34,3,35,3],[34,10,35,10],[34,11,35,11],[26,10,27,10],[26,11,27,11],[28,2,29,2],[28,3,29,3],[28,10,29,10],[28,11,29,11],[22,10,23,10]]}
[null,"INCIDENT RADIO COMMUNICATIONS PLAN ",null,null,null,"1.  Incident Name",null,null,null,null,"2.  Date Time Prepared","3.  Operational Period Date/Time"]
[]
[null,"4. Basic Radio Channel Utilization\nMode:  Wide= Analog Wideband,  Narrow= Analog Narrowband,  Digital= Digital Narrowband,  Mixed= Analog/Digital"]
[null,"Radio/Group","CH #","Function"," Frequency",null,"Tone","NAC","TGID","MODE","Assignment ","Remarks"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:",null,null," "]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,null,null,null,"RX:"]
[null,null,null,null,"TX:"]
[null,"5.  Prepared By (Communications Unit):"]
[]
[null,"Note:  This is not a standard NWCG ICS205 Form"]

{"sheet":"Waybill","index":9,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[23,7,23,9],[4,6,8,9],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[9,3,9,5],[12,3,12,5],[15,1,15,3],[4,1,8,5],[22,1,22,3],[1,1,1,9],[15,7,15,9],[3,2,3,5],[2,2,2,3],[3,7,3,9],[10,3,10,5],[11,3,11,5],[9,7,9,9],[10,7,10,9],[22,6,22,7],[22,4,22,5],[22,8,22,9],[13,3,13,5],[14,1,14,9],[21,1,21,9],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,1,16,3],[32,7,32,9],[33,7,33,9],[34,7,34,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[28,7,28,9],[24,7,24,9],[54,1,54,3],[54,4,54,6],[54,7,54,9],[45,7,45,9],[46,7,46,9],[52,7,52,9],[29,7,29,9],[30,7,30,9],[31,7,31,9],[53,1,53,2],[47,7,47,9],[48,7,48,9],[49,7,49,9],[50,7,50,9],[51,7,51,9],[55,1,55,3],[55,4,55,6],[55,7,55,9],[35,7,35,9],[36,7,36,9],[37,7,37,9],[53,7,53,9],[43,7,43,9],[44,7,44,9],[42,7,42,9],[38,7,38,9],[39,7,39,9],[40,7,40,9],[41,7,41,9]]}
[]
[null,"INTERAGENCY INCIDENT WAYBILL"]
[null,"Date:",{"$f":"TODAY()","v":"2024-01-29"},null,"Time:",1500,null,null,"Page 1 of ","X"]
[null,"Ship To:",null,null,null,null,"Shipped From:"]
[null,"National Interagency Fire Center\nNational Interagency Incident Communications Division\n3833 South Development Ave\nBoise, Idaho 83705",null,null,null,null,"\n"]
[]
[]
[]
[]
[null,"Incident Name:",null,{"$f":"'Radio Inventory'!C3","v":"My Test"},null,null,"Driver's Signature:"]
[null,"Incident Number:",null,"ID-FCF-000002",null,null,"Carrier/Driver Name:"]
[null,"Accounting Code:",null,"PRWF12/1345",null,null,"Vehicle Number:",null,"Trlr Number:"]
[null,"Contact Name:",null,"Kill Bill COML",null,null,"Pieces:",null,"Weight:"]
[null,"Contact Phone:",null,"208-387-0000",null,null,"ETD:",null,"ETA:"]
[null,"HAZARDOUS MATERIALS DECLARATION"]
[null,"Proper Shipping Name",null,null,"Hazard\n Class","Identification\n Number","Packing Group","Total Quantity\nUnits/Gross Weight"]
[]
[]
[]
[]
[]
[null,"This is to certify that the above-named materials are properly classified, described, packaged, marked and labeld and in the proper condition for transportation according to the applicable regulations of the Department of Transportation."]
[null,"Signature of Shipper:",null,null,null,null,"Emergency Response Number:",null,"1-800-424-9300"]
[null,"Item #","S-#","QTY","U/I","Weight (lbs)","NFES #/Item Description","Property Number/Serial Number"]
[null,1,45.12,1,"Kit",45,"4150 - SLA Battery Kit","4150-FCK-001"]
[null,2,10,1,"Kit",80,"4312 - VHF Repeater/Link Kit","4312-FCK-C001"]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,"Totals:",null,{"$f":"SUM(D25:D53)","v":2},null,{"$f":"SUM(F25:F53)","v":125}]
[null,"Received By (signature)",null,null,"Position Title",null,null,"Date/Time"]

{"sheet":"Waybill Cont.","index":10,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,1,50,2],[51,1,51,2],[46,7,46,9],[47,7,47,9],[48,7,48,9],[49,7,49,9],[50,7,50,9],[1,1,1,9],[3,7,3,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[18,7,18,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[15,7,15,9],[16,7,16,9],[17,7,17,9],[42,7,42,9],[28,7,28,9],[29,7,29,9],[30,7,30,9],[31,7,31,9],[19,7,19,9],[20,7,20,9],[21,7,21,9],[22,7,22,9],[41,7,41,9],[38,7,38,9],[39,7,39,9],[40,7,40,9],[32,7,32,9],[33,7,33,9],[34,7,34,9],[35,7,35,9],[36,7,36,9],[37,7,37,9],[53,1,53,3],[53,4,53,6],[53,7,53,9],[2,1,2,5],[23,7,23,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[43,7,43,9],[44,7,44,9],[45,7,45,9],[51,7,51,9],[52,1,52,3],[52,4,52,6],[52,7,52,9]]}
[]
[null,"CONTINUATION INTERAGENCY INCIDENT WAYBILL"]
[null,"Void if page 1 is not attached",null,null,null,null,"Continuation Page","X","of","X"]
[null,"Item #","S -  #","QTY","U/I","Weight (lbs)","NFES Item Description","Property Number/Serial Number"]
[null,30,67,1,"Kit",100,"4240 - Airbase Accessories Kit","4240-FCK-001"]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,"Page Totals:",null,{"$f":"SUM(D5:D50)","v":1},null,{"$f":"SUM(F5:F50)","v":100}]
[null,"Grand Totals:",null,{"$f":"SUM(Waybill!D54,'Waybill Cont.'!D51)","v":3},null,{"$f":"SUM(Waybill!F54,'Waybill Cont.'!F51)","v":225}]
[null,"Received By (signature)",null,null,"Position Title",null,null,"Date/Time"]

{"sheet":"Changelog","index":11,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[[5,1,6,5],[7,1,7,5],[0,1,0,5],[1,1,1,5],[2,2,2,3],[2,4,4,5],[3,2,3,3],[4,2,4,3]]}
[null,"Incident Communications Unit Radio Log"]
[]
[]
[]
[]
[]
[]
[null,"LOG Code:  RD= Radio Message,  VB= Verbal Message,  LL= Landline (Phone) Message,  MS= Messenger Service"]
[null,"Date","Worksheet","Type","Information/Message","Initials"]
[null,{"$f":"MyTimestamp(E10)","v":"01-29-24 08:45:35"},"Radio Inventory","Added Macro","Added macro to insert 4381 and 4244 kits independently, automatically lists radios in series and as available","KS"]
[null,{"$f":"MyTimestamp(E11)","v":"01-29-24 08:45:35"},"Radio Inventory","Changed macro","adjusted individual radio additions to automatically list as available","KS"]
[null,{"$f":"MyTimestamp(E12)","v":"01-29-24 08:45:35"},"Radio Inventory","added columns and rules","Columns added for items frequently issued with radios, added rules to highlight yes responses","KS"]
[null,{"$f":"MyTimestamp(E13)","v":"01-29-24 08:45:35"},"Radio Inventory","aesthetic changes","Added buttons to run add kit macros, moved other macro buttons below inventory totals","KS"]
[null,{"$f":"MyTimestamp(E14)","v":"01-29-24 08:45:35"},"Radio Log","Automatic Timestamp","Added automatic timestamp and macro (in module 14) tied to entry in information box","KS"]
[null,{"$f":"MyTimestamp(E15)","v":"01-29-24 08:45:35"},"New Sheet","Changelog","Added Changelog","KS"]

{"sheet":"Sheet1","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Dashboard","index":13,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,4,4,5],[4,7,4,8],[0,0,1,16383],[2,0,2,16383]]}
["NIRSC EQUIPMENT/RADIO DATABASE DASH BOARD"]
[]
[{"$f":"NOW()","v":"2024-01-29T08:48:39.430"}]
[]
[null,"Radio Equipment Totals",null,null,"Radio Equipment Status",null,null,"Equipment/Frequency Totals",null,null,"Equipment/Frequency Demob Status"]
[null,"Radio Equipment","Totals",null,"NFES Equipment","Totals",null,"Equipment and Frequencies","Totals",null,"Equipment and Frequencies"]
[null,4244,1,null,"Issued",1,null,"4312 - VHF Repeater",1,null,"4312 - VHF Repeater"]
[null,4381,1,null,"Out Of Service",1,null,"4390 - Starter System",1,null,"4390 - Starter System"]
[null,"Grand Total",2,null,"Grand Total",2,null,"Tactical",1,null,"Tactical"]
[null,null,null,null,null,null,null,"4330 - Remote Kit",1,null,"4330 - Remote Kit"]
[null,null,null,null,null,null,null,"4150- SLA Battery Kit",1,null,"4150- SLA Battery Kit"]
[null,null,null,null,null,null,null,"4080 - Solar Panel Kit",1,null,"4080 - Solar Panel Kit"]
[null,null,null,null,null,null,null,"Grand Total",6,null,"Grand Total"]

{"sheet":"List","index":14,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,17]]}
["NIRSC Radio Inventory Database List"]
["Radio Equipment",null,"NFES Equipment",null,"Tone",null,"ICS 205 Tone",null,"VHF Frequencies",null,"UHF Frequencies",null,"Link Frequencies",null,"Waybill NFES#","Weight list Table(LBS)","Units","Waybill Descriptions"]
[4092,null,"4080 - Solar Panel Kit",null,"Tone 1:  110.9",null,110.9,null,168.2,null,415.4,null,414.65,null,4080,47,"Each","4080 - Solar Panel Kit"]
[4244,null,"4092 - ISR Kit",null,"Tone 2:  123.0",null,123,null,null,null,null,null,null,null,4120,0,"Kit","4120 - JPS ACU-1000 Kit"]
[4370,null,"4150- SLA Battery Kit",null,"Tone 3:  131.8",null,131.80000000000001,null,null,null,null,null,null,null,4150,55,"Pack","4150 - SLA Battery Kit"]
[4381,null,"4244 - UHF Radio Kit",null,"Tone 4:  136.5",null,136.5,null,null,null,null,null,null,null,4240,32,"Kit","4240 - Airbase Accessories Kit Box 1"]
[4670,null,"4248 - UHF Repeater",null,"Tone 5:  146.2",null,146.19999999999999,null,null,null,null,null,null,null,4244,65,"Box","4240 - Airbase Accessories Kit Box 2"]
[4240,null,"4281 - Crossband Link",null,"Tone 6:  156.7",null,156.69999999999999,null,null,null,null,null,null,null,4245,3,"Set","4244 - UHF Radio Kit"]
[4660,null,"4381 - VHF Radio Kit",null,"Tone 7:  167.9",null,167.9,null,null,null,null,null,null,null,4248,84,null,"4245 - Flatland Kit"]
["Cell Phone",null,"4312 - VHF Repeater",null,"Tone 8:  103.5",null,103.5,null,null,null,null,null,null,null,4281,80,null,"4248 - UHF Repeater Kit"]
["Sat Phone",null,"4320 - COML Kit",null,"Tone 9:  100.0",null,100,null,null,null,null,null,null,null,4300,61,null,"4281 - Crossbank Link Kit"]
["Mag Mount",null,"4330 - Remote Kit",null,"Tone 10:  107.2",null,107.2,null,null,null,null,null,null,null,4305,17,null,"4300 - VHF AM Base Station Kit"]
["Speaker Mic",null,"4330EX - Remote Expansion Kit",null,"Tone 11:  114.8",null,114.8,null,null,null,null,null,null,null,4312,90,null,"4305 - Antenna Mast"]
["Hot Spot",null,"4370 - A/C Link Kit",null,"Tone 12:  127.3",null,127.3,null,null,null,null,null,null,null,4320,18,null,"4312 - VHF Repeater/Link Kit"]
[null,null,"4390 - Starter System",null,"Tone 13:  141.3",null,141.30000000000001,null,null,null,null,null,null,null,4330,35,null,"4320 - COML Kit"]
[null,null,"4410 - PA Kit",null,"Tone 14:  151.4",null,151.4,null,null,null,null,null,null,null,"4330EX",35,null,"4330 - Remote Kit"]
[null,null,"4670 - Satellite Phone Kit",null,"Tone 15:  162.2",null,162.19999999999999,null,null,null,null,null,null,null,4370,0,null,"4330EX - Remote Expansion Kit"]
[null,null,"A/G - Air-to-Ground",null,"No Tone",null,"No Tone",null,null,null,null,null,null,null,4381,0,null,"4370 - Ground Aircraft Link Kit"]
[null,null,"A/A - Air-to-Air AM",null,null,null,null,null,null,null,null,null,null,null,4390,0,null,"4381 - VHF Radio Kit"]
[null,null,"A/A - Air-to-Air FM",null,null,null,null,null,null,null,null,null,null,null,4420,0,null,"4390 - Starter System"]
[null,null,"Tactical",null,null,null,null,null,null,null,null,null,null,null,4499,0,null,"4420 - Aviation  Network Printer Kit"]
[null,null,"Deck",null,null,null,null,null,null,null,null,null,null,null,4545,0,null,"4499 - Air Attack Kit"]
[null,null,"TOLC",null,null,null,null,null,null,null,null,null,null,null,4604,0,null,"4545 - Aviation Radio"]
[null,null,"Command Link",null,null,null,null,null,null,null,null,null,null,null,4605,0,null,"4604 - Air Attack Training Kit"]
[null,null,"A/C Link",null,null,null,null,null,null,null,null,null,null,null,4606,0,null,"4605 - Technisonic TDFM-136 Test Jig (Single)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4607,0,null,"4606 - Technisonic TDFM-136 Test Jig (Dual)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4608,0,null,"4607 - Technisonic TDFM-9000 Test Jig"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4660,0,null,"4608 - Cobhan NPX136D Test Jig"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4670,4.8,null,"4660 - Airbase Kit Box 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4660 - Airbase Kit Box 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4670 - Satellite Phone Kit"]