{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["1. Report.MAFFS.by.Incident","2. Report.Summary.All","3. MAFFS Military Costs","4. Total Cost","5. Federal Personnel","6. Misc Support Costs","7. DATA","8. AEG Costs","Mailing.list","Changes","Instructions","lookup"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":5,"pivot_tables":2},"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":"1. Report.MAFFS.by.Incident","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,3,9,6],[7,3,7,6],[6,3,6,6],[5,3,5,6],[8,3,8,6]]}
[]
[]
["Set to current date and refresh before transmitting."]
["If you want to see a display for a specific dates select those dates"]
[null,null,null," "]
[null,null,null," "]
[null,null,null," "]
["Year","(blank)"]
["Month","(blank)",null,"Click to select a Month"]
["Day","(blank)",null,"Click to select a Day"]
[]
["MAFFS Unit","P-Code","Fire Name","State ","Unit ","Sorties","Gallons of Retardant","Flight Hours"]
["(blank)","(blank)","(blank)","(blank)","(blank)",0,0,0]
[]
["(blank) Total",null,null,null,null,0,0,0]
["Grand Total",null,null,null,null,0,0,0]

{"sheet":"2. Report.Summary.All","index":1,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,3,4,5]]}
[]
[]
[]
[null,null,null," "]
[null,null,null,"Resource Order "]
["Fire Name","Base Location","P-Code","MAFFS #","State","Unit Identifier","Order No.","Month","Day","Sorties","Retardant\nGallons","Retardant Cost","Flight\nHours"]
["Grand Total"]

{"sheet":"3. MAFFS Military Costs","index":2,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"MAFFS Military Costs at",null,null,{"$f":"Mailing.list!C19","v":"Greeneville, SC"}]
[]
["Date","USAFR Personnel Present","ANG Personnel Present","USAFR Military Personnel Cost","ANG  Military Personnel Cost ","A/C RON","USAFR Support A.C. Hours","ANG  Support A.C. Hours"," USAFR Mission A.C. Hours"," ANG Mission A.C. Hours","USAFR Support AC Cost","ANG Support AC Cost","USAFR Misson AC Cost","ANG Misson AC Cost","Total Aircraft Cost","Total Daily Military Cost"]
[null,null,null,{"$f":"SUM((B4)*500)","v":0},{"$f":"SUM(C4*500)","v":0},null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A4)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A4)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A4)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A4)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"G4*6964","v":0},{"$f":"H4*6964","v":0},{"$f":"I4*6964","v":0},{"$f":"J4*6964","v":0},{"$f":"SUM(K4:N4)","v":0},{"$f":"+D4+E4+O4","v":0}]
[{"$f":"+A4+1","v":"1900-01-01"},null,null,{"$f":"SUM((B5)*500)","v":0},{"$f":"SUM(C5*500)","v":0},null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A5)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A5)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A5)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A5)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"G5*6964","v":0},{"$f":"H5*6964","v":0},{"$f":"I5*6964","v":0},{"$f":"J5*6964","v":0},0,0]
[{"$f":"+A5+1","v":"1900-01-02"},null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A6)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A6)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A6)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A6)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-03",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A7)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A7)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A7)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A7)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-04",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A8)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A8)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A8)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A8)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-05",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A9)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A9)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A9)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A9)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-06",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A10)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A10)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A10)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A10)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-07",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A11)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A11)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A11)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A11)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-08",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A12)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A12)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A12)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A12)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-09",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A13)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A13)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A13)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A13)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-10",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A14)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A14)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A14)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A14)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-11",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A15)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A15)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A15)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A15)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-12",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A16)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A16)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A16)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A16)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-13",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A17)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A17)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A17)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A17)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-14",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A18)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A18)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A18)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A18)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-15",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A19)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A19)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A19)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A19)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-16",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A20)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A20)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A20)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A20)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-17",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A21)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A21)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A21)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A21)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-18",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A22)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A22)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A22)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A22)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["1900-01-19",null,null,0,0,null,{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A23)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A23)*('7. DATA'!$D$2:$D$24=\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A23)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"A\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},{"$f":"SUM(IF(('7. DATA'!$I$2:$I$24='3. MAFFS Military Costs'!$A23)*('7. DATA'!$D$2:$D$24<>\"Support\")*('7. DATA'!$E$2:$E$24=\"N\"),'7. DATA'!$Q$2:$Q$24,0))","v":0},0,0,0,0,0,0]
["TOTALS",null,null,{"$f":"SUM(D4:D23)","v":0},{"$f":"SUM(E4:E23)","v":0},null,{"$f":"SUM(G4:G23)","v":0},{"$f":"SUM(H4:H23)","v":0},{"$f":"SUM(I4:I23)","v":0},{"$f":"SUM(J4:J23)","v":0},0,0,0,0,{"$f":"SUM(O4:O23)","v":0},{"$f":"SUM(P4:P23)","v":0}]
[]
[]
[null,null,null,null,null,"SUPPORT HOURS",null,null,{"$f":"H24+G24","v":0},"MISSON HOURS",null,{"$f":"I24+J24","v":0}]
[]
[null,null,null,null,null,null,"TOTAL HOURS",null,{"$f":"I27+L27","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"8614+5080","v":13694}]
[null,null,null,null,null,null,null,{"$f":"H54/2","v":6847}]

{"sheet":"4. Total Cost","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Summary of Costs "]
[" "]
["Retardant Costs",null,null,null,{"$f":"SUM('7. DATA'!P27)","v":0}]
["Misc. Support Costs",null,null,null,{"$f":"'6. Misc Support Costs'!I23","v":4775}]
["Military Costs",null,null,null,{"$f":"SUM('3. MAFFS Military Costs'!P24)+SUM('8. AEG Costs'!C18)","v":40400}]
["Federal Personnel",null,null,null,{"$f":"SUM('5. Federal Personnel'!AH24)","v":65510}]
["Grand Total",null,null,null,{"$f":"SUM(E4:E7)","v":110685}]
[]
[]
[]
["Note:  AEG costs have been included in this Summary"]

{"sheet":"5. Federal Personnel","index":4,"n_rows":24,"n_cols":35,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,29,5,30],[5,31,5,32],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,11,5,12],[5,27,5,28],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,25,5,26]]}
["Agency Personnel Costs per Day at ",null,null,null,null,null,{"$f":"Mailing.list!C19","v":"Greeneville, SC"}]
["Personnel, Includes estimated OT, Travel & per diem"]
["Only include personnel assigned to the activation….have a resource order number (\"O number\")"]
[]
[]
[null,"MLO",null,"AMLO",null,"AMLO-T",null,"MABM",null,"MABS",null,"MABS-T",null,"Procurement",null,"MAFFS Clerk",null,"Ground Support",null,"MAFFS Mechanic",null,"Avionics Tech",null,"Safety Officer",null,"Information Officer",null,"Base Camp Mgr",null,"Security",null,"Camp Crew",null,"Cost Total","Personnel"]
["Date","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","# Assigned","Cost","TOTAL"]
["2012-05-03",1,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B8","v":600},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D8","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F8","v":0},1,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H8","v":440},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J8","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L8","v":0},1,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N8","v":440},3,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P8","v":1200},4,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R8","v":1400},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T8","v":0},1,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V8","v":500},1,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X8","v":400},1,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z8","v":400},1,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB8","v":400},3,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD8","v":1500},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF8","v":0},{"$f":"SUM(C8+E8+G8+I8+K8+M8+O8+Q8+S8+U8+W8+Y8+AA8+AC8+AE8+AG8)","v":7280},{"$f":"SUM(B8,D8,F8,H8,J8,L8,N8,P8,R8,T8,V8,X8,Z8,AB8,AD8,AF8)","v":17}]
[{"$f":"A8+1","v":"2012-05-04"},1,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B9","v":600},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D9","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F9","v":0},1,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H9","v":440},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J9","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L9","v":0},1,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N9","v":440},3,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P9","v":1200},4,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R9","v":1400},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T9","v":0},2,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V9","v":1000},1,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X9","v":400},1,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z9","v":400},1,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB9","v":400},3,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD9","v":1500},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF9","v":0},{"$f":"SUM(C9+E9+G9+I9+K9+M9+O9+Q9+S9+U9+W9+Y9+AA9+AC9+AE9+AG9)","v":7780},{"$f":"SUM(B9,D9,F9,H9,J9,L9,N9,P9,R9,T9,V9,X9,Z9,AB9,AD9,AF9)","v":18}]
[{"$f":"A9+1","v":"2012-05-05"},1,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B10","v":600},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D10","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F10","v":0},2,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H10","v":880},1,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J10","v":440},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L10","v":0},2,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N10","v":880},3,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P10","v":1200},4,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R10","v":1400},3,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T10","v":2700},2,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V10","v":1000},1,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X10","v":400},1,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z10","v":400},1,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB10","v":400},3,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD10","v":1500},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF10","v":0},{"$f":"SUM(C10+E10+G10+I10+K10+M10+O10+Q10+S10+U10+W10+Y10+AA10+AC10+AE10+AG10)","v":11800},{"$f":"SUM(B10,D10,F10,H10,J10,L10,N10,P10,R10,T10,V10,X10,Z10,AB10,AD10,AF10)","v":24}]
[{"$f":"A10+1","v":"2012-05-06"},1,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B11","v":600},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D11","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F11","v":0},2,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H11","v":880},1,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J11","v":440},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L11","v":0},2,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N11","v":880},3,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P11","v":1200},7,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R11","v":2450},3,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T11","v":2700},2,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V11","v":1000},1,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X11","v":400},1,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z11","v":400},1,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB11","v":400},4,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD11","v":2000},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF11","v":0},{"$f":"SUM(C11+E11+G11+I11+K11+M11+O11+Q11+S11+U11+W11+Y11+AA11+AC11+AE11+AG11)","v":13350},{"$f":"SUM(B11,D11,F11,H11,J11,L11,N11,P11,R11,T11,V11,X11,Z11,AB11,AD11,AF11)","v":28}]
[{"$f":"A11+1","v":"2012-05-07"},1,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B12","v":600},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D12","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F12","v":0},2,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H12","v":880},1,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J12","v":440},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L12","v":0},2,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N12","v":880},3,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P12","v":1200},7,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R12","v":2450},2,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T12","v":1800},2,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V12","v":1000},1,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X12","v":400},1,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z12","v":400},1,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB12","v":400},4,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD12","v":2000},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF12","v":0},{"$f":"SUM(C12+E12+G12+I12+K12+M12+O12+Q12+S12+U12+W12+Y12+AA12+AC12+AE12+AG12)","v":12450},{"$f":"SUM(B12,D12,F12,H12,J12,L12,N12,P12,R12,T12,V12,X12,Z12,AB12,AD12,AF12)","v":27}]
["2012-05-08",1,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B13","v":600},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D13","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F13","v":0},2,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H13","v":880},1,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J13","v":440},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L13","v":0},2,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N13","v":880},3,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P13","v":1200},7,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R13","v":2450},2,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T13","v":1800},2,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V13","v":1000},1,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X13","v":400},1,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z13","v":400},2,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB13","v":800},4,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD13","v":2000},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF13","v":0},12850,28]
["2012-05-09",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B14","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D14","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F14","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H14","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J14","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L14","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N14","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P14","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R14","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T14","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V14","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X14","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z14","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB14","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD14","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF14","v":0},0,0]
["2012-05-10",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B15","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D15","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F15","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H15","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J15","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L15","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N15","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P15","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R15","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T15","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V15","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X15","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z15","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB15","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD15","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF15","v":0},0,0]
["2012-05-11",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B16","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D16","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F16","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H16","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J16","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L16","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N16","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P16","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R16","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T16","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V16","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X16","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z16","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB16","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD16","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF16","v":0},0,0]
["2012-05-12",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B17","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D17","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F17","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H17","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J17","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L17","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N17","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P17","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R17","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T17","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V17","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X17","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z17","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB17","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD17","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF17","v":0},0,0]
["2012-05-13",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B18","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D18","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F18","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H18","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J18","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L18","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N18","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P18","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R18","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T18","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V18","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X18","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z18","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB18","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD18","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF18","v":0},0,0]
["2012-05-14",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B19","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D19","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F19","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H19","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J19","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L19","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N19","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P19","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R19","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T19","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V19","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X19","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z19","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB19","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD19","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF19","v":0},0,0]
["2012-05-15",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B20","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D20","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F20","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H20","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J20","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L20","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N20","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P20","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R20","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T20","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V20","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X20","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z20","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB20","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD20","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF20","v":0},0,0]
["2012-05-16",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B21","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D21","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F21","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H21","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J21","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L21","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N21","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P21","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R21","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T21","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V21","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X21","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z21","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB21","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD21","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF21","v":0},0,0]
["2012-05-17",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B22","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D22","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F22","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H22","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J22","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L22","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N22","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P22","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R22","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T22","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V22","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X22","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z22","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB22","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD22","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF22","v":0},0,0]
["2012-05-18",null,{"$f":"SUM(lookup!$B$3)*'5. Federal Personnel'!B23","v":0},null,{"$f":"SUM(lookup!$B$4)*'5. Federal Personnel'!D23","v":0},null,{"$f":"SUM(lookup!$B$5)*'5. Federal Personnel'!F23","v":0},null,{"$f":"SUM(lookup!$B$6)*'5. Federal Personnel'!H23","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!J23","v":0},null,{"$f":"SUM(lookup!$B$7)*'5. Federal Personnel'!L23","v":0},null,{"$f":"SUM(lookup!$B$8)*'5. Federal Personnel'!N23","v":0},null,{"$f":"SUM(lookup!$B$9)*'5. Federal Personnel'!P23","v":0},null,{"$f":"SUM(lookup!$B$10)*'5. Federal Personnel'!R23","v":0},null,{"$f":"SUM(lookup!$B$11)*'5. Federal Personnel'!T23","v":0},null,{"$f":"SUM(lookup!$B$12)*'5. Federal Personnel'!V23","v":0},null,{"$f":"SUM(lookup!$B$13)*'5. Federal Personnel'!X23","v":0},null,{"$f":"SUM(lookup!$B$14)*'5. Federal Personnel'!Z23","v":0},null,{"$f":"SUM(lookup!$B$15)*'5. Federal Personnel'!AB23","v":0},null,{"$f":"SUM(lookup!$B$16)*'5. Federal Personnel'!AD23","v":0},null,{"$f":"SUM(lookup!$B$17)*'5. Federal Personnel'!AF23","v":0},0,0]
[null,{"$f":"SUM(B8:B23)","v":6},3600,0,0,0,0,10,4400,4,1760,0,0,10,4400,18,7200,33,11550,10,9000,11,5500,6,2400,6,2400,7,2800,21,{"$f":"SUM(AG8+AG23)","v":0},{"$f":"SUM(AF8:AF23)","v":0},{"$f":"SUM(AG8:AG23)","v":0},{"$f":"SUM(AH8:AH23)","v":65510},{"$f":"SUM(AI8:AI23)","v":142}]

{"sheet":"6. Misc Support Costs","index":5,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"      MAFFS Equipment & Supply Expenses at ",null,null,null,null,{"$f":"Mailing.list!C19","v":"Greeneville, SC"}]
[]
[null,null,"Date","Transportation","Lodging","Supplies","Services/ Equipment","Airport Fees","Cost"]
[null,null,"2012-05-03",null,null,4775,null,null,{"$f":"SUM(D4:H4)","v":4775}]
[null,null,{"$f":"C4+1","v":"2012-05-04"},null,null,null,null,null,0]
[null,null,{"$f":"C5+1","v":"2012-05-05"},null,null,null,null,null,0]
[null,null,"2012-05-06",null,null,null,null,null,0]
[null,null,"2012-05-07",null,null,null,null,null,0]
[null,null,"2012-05-08",null,null,null,null,null,0]
[null,null,"2012-05-09",null,null,null,null,null,0]
[null,null,"2012-05-10",null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,null,"2012-05-11",null,null,null,null,null,0]
[null,null,"2012-05-12",null,null,null,null,null,0]
[null,null,"2012-05-13",null,null,null,null,null,0]
[null,null,"2012-05-14",null,null,null,null,null,0]
[null,null,"2012-05-15",null,null,null,null,null,0]
[null,null,"2012-05-16",null,null,null,null,null,0]
[null,null,"2012-05-17",null,null,null,null,null,0]
[null,null,"2012-05-18",null,null,null,null,null,0]
[null,null,"2012-05-19",null,null,null,null,null,0]
[null,null,"2012-05-20",null,null,null,null,null,0]
[null,null,"2012-05-21",null,null,null,null,null,{"$f":"SUM(D22:H22)","v":0}]
[null,null,"Grand Total",null,null,null,null,null,{"$f":"SUM(I4:I22)","v":4775}]
[null,null,"Subtotal",{"$f":"SUM(D4:D23)","v":0},{"$f":"SUM(E4:E23)","v":0},{"$f":"SUM(F4:F23)","v":4775},{"$f":"SUM(G4:G23)","v":0},{"$f":"SUM(H4:H23)","v":0}]
[]
[null,null,"     "]
[]
[null,null,"Note: Costs shown here are direct charges at this location only"]
[]
[null,null,"Transportation:  Cost associated with rental vehicle fleet that is to be billed to the activation at this location.  Include also any transportation of equipment such as compressors, risk kits, portable pit equipment and transportation of MAFFS II trailer (as examples)"]
[]
[null,null,"Lodging:  Costs of lodging that will be direct billed to the activation at this location (do not include cost of hotels being paid from employee per diem rates)"]
[]
[null,null,"Supplies:  Costs associated with disposable supply items or lost accountable property"]
[]
[null,null,"Services/ Equipment:  Cost associated with providing scheduled maintenance and upkeep of activation facilities.   For example…toilet servicing, pit pumping, telephone/data connections, refer trailer, tents, trailers, rental of port a potties, fax machines, copy machines, etc"]
[]
[null,null,"Airport Fees:   Daily total for landing fees or other airport fees (if any) at the activation location"]

{"sheet":"7. DATA","index":6,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Base Location","Fire Name","P-Code","MAFFS\nUNIT #\nor\nSupport","A=AF\nN=NG\n\n","Month","Day","Year","Date (NO ENTRY REQ'D)","State Name","Unit Identifier","Order Number","Flights","Retardant\nGallons","Retardant/Gallon Cost","Retardant Cost","Flight\nHours","Comments (not visible on any other tabs)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M2:M24)","v":0},{"$f":"SUM(N2:N24)","v":0},null,{"$f":"SUM(P2:P24)","v":0},{"$f":"SUM(Q2:Q26)","v":0}]

{"sheet":"8. AEG Costs","index":7,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Note:  Standard AEG Costs are one officer and one enlisted (Title 32). Large activations will require additional military personnel assigned. Costs embedded include all travel and per diem"]
["Date","#","Standard                      AEG Commander","#","Standard                       AEG Support (Enlisted)","#","Additional","#","Additional","#","Additional","#","Additional","#","Additional","#","Additional"]
[null,4,{"$f":"SUM(lookup!$B$21)*B5","v":2400},3,{"$f":"SUM(lookup!$B$22)*D5","v":1200},null,{"$f":"SUM(lookup!$B$23)*F5","v":0},null,{"$f":"SUM(lookup!$B$24)*H5","v":0},null,{"$f":"SUM(lookup!$B$25)*J5","v":0},null,{"$f":"SUM(lookup!$B$26)*L5","v":0},null,{"$f":"SUM(lookup!$B$27)*N5","v":0},null,{"$f":"SUM(lookup!$B$28)*P5","v":0}]
[{"$f":"+A5+1","v":"1900-01-01"},4,{"$f":"SUM(lookup!$B$21)*B6","v":2400},3,{"$f":"SUM(lookup!$B$22)*D6","v":1200},null,{"$f":"SUM(lookup!$B$23)*F6","v":0},null,{"$f":"SUM(lookup!$B$24)*H6","v":0},null,{"$f":"SUM(lookup!$B$25)*J6","v":0},null,{"$f":"SUM(lookup!$B$26)*L6","v":0},null,{"$f":"SUM(lookup!$B$27)*N6","v":0},null,{"$f":"SUM(lookup!$B$28)*P6","v":0}]
[{"$f":"+A6+1","v":"1900-01-02"},4,{"$f":"SUM(lookup!$B$21)*B7","v":2400},3,{"$f":"SUM(lookup!$B$22)*D7","v":1200},null,{"$f":"SUM(lookup!$B$23)*F7","v":0},null,{"$f":"SUM(lookup!$B$24)*H7","v":0},null,{"$f":"SUM(lookup!$B$25)*J7","v":0},null,{"$f":"SUM(lookup!$B$26)*L7","v":0},null,{"$f":"SUM(lookup!$B$27)*N7","v":0},null,{"$f":"SUM(lookup!$B$28)*P7","v":0}]
[{"$f":"+A7+1","v":"1900-01-03"},4,{"$f":"SUM(lookup!$B$21)*B8","v":2400},3,{"$f":"SUM(lookup!$B$22)*D8","v":1200},null,{"$f":"SUM(lookup!$B$23)*F8","v":0},null,{"$f":"SUM(lookup!$B$24)*H8","v":0},null,{"$f":"SUM(lookup!$B$25)*J8","v":0},null,{"$f":"SUM(lookup!$B$26)*L8","v":0},null,{"$f":"SUM(lookup!$B$27)*N8","v":0},null,{"$f":"SUM(lookup!$B$28)*P8","v":0}]
[{"$f":"+A8+1","v":"1900-01-04"},4,{"$f":"SUM(lookup!$B$21)*B9","v":2400},4,{"$f":"SUM(lookup!$B$22)*D9","v":1600},null,{"$f":"SUM(lookup!$B$23)*F9","v":0},null,{"$f":"SUM(lookup!$B$24)*H9","v":0},null,{"$f":"SUM(lookup!$B$25)*J9","v":0},null,{"$f":"SUM(lookup!$B$26)*L9","v":0},null,{"$f":"SUM(lookup!$B$27)*N9","v":0},null,{"$f":"SUM(lookup!$B$28)*P9","v":0}]
["1900-01-05",4,{"$f":"SUM(lookup!$B$21)*B10","v":2400},4,{"$f":"SUM(lookup!$B$22)*D10","v":1600},null,{"$f":"SUM(lookup!$B$23)*F10","v":0},null,{"$f":"SUM(lookup!$B$24)*H10","v":0},null,{"$f":"SUM(lookup!$B$25)*J10","v":0},null,{"$f":"SUM(lookup!$B$26)*L10","v":0},null,{"$f":"SUM(lookup!$B$27)*N10","v":0},null,{"$f":"SUM(lookup!$B$28)*P10","v":0}]
["1900-01-06",4,{"$f":"SUM(lookup!$B$21)*B11","v":2400},3,{"$f":"SUM(lookup!$B$22)*D11","v":1200},null,{"$f":"SUM(lookup!$B$23)*F11","v":0},null,{"$f":"SUM(lookup!$B$24)*H11","v":0},null,{"$f":"SUM(lookup!$B$25)*J11","v":0},null,{"$f":"SUM(lookup!$B$26)*L11","v":0},null,{"$f":"SUM(lookup!$B$27)*N11","v":0},null,{"$f":"SUM(lookup!$B$28)*P11","v":0}]
["1900-01-07",4,{"$f":"SUM(lookup!$B$21)*B12","v":2400},3,{"$f":"SUM(lookup!$B$22)*D12","v":1200},null,{"$f":"SUM(lookup!$B$23)*F12","v":0},null,{"$f":"SUM(lookup!$B$24)*H12","v":0},null,{"$f":"SUM(lookup!$B$25)*J12","v":0},null,{"$f":"SUM(lookup!$B$26)*L12","v":0},null,{"$f":"SUM(lookup!$B$27)*N12","v":0},null,{"$f":"SUM(lookup!$B$28)*P12","v":0}]
["1900-01-08",4,{"$f":"SUM(lookup!$B$21)*B13","v":2400},3,{"$f":"SUM(lookup!$B$22)*D13","v":1200},null,{"$f":"SUM(lookup!$B$23)*F13","v":0},null,{"$f":"SUM(lookup!$B$24)*H13","v":0},null,{"$f":"SUM(lookup!$B$25)*J13","v":0},null,{"$f":"SUM(lookup!$B$26)*L13","v":0},null,{"$f":"SUM(lookup!$B$27)*N13","v":0},null,{"$f":"SUM(lookup!$B$28)*P13","v":0}]
["1900-01-09",4,{"$f":"SUM(lookup!$B$21)*B14","v":2400},3,{"$f":"SUM(lookup!$B$22)*D14","v":1200},null,{"$f":"SUM(lookup!$B$23)*F14","v":0},null,{"$f":"SUM(lookup!$B$24)*H14","v":0},null,{"$f":"SUM(lookup!$B$25)*J14","v":0},null,{"$f":"SUM(lookup!$B$26)*L14","v":0},null,{"$f":"SUM(lookup!$B$27)*N14","v":0},null,{"$f":"SUM(lookup!$B$28)*P14","v":0}]
["1900-01-10",4,{"$f":"SUM(lookup!$B$21)*B15","v":2400},3,{"$f":"SUM(lookup!$B$22)*D15","v":1200},null,{"$f":"SUM(lookup!$B$23)*F15","v":0},null,{"$f":"SUM(lookup!$B$24)*H15","v":0},null,{"$f":"SUM(lookup!$B$25)*J15","v":0},null,{"$f":"SUM(lookup!$B$26)*L15","v":0},null,{"$f":"SUM(lookup!$B$27)*N15","v":0},null,{"$f":"SUM(lookup!$B$28)*P15","v":0}]
["1900-01-11",null,{"$f":"SUM(lookup!$B$21)*B16","v":0},null,{"$f":"SUM(lookup!$B$22)*D16","v":0},null,{"$f":"SUM(lookup!$B$23)*F16","v":0},null,{"$f":"SUM(lookup!$B$24)*H16","v":0},null,{"$f":"SUM(lookup!$B$25)*J16","v":0},null,{"$f":"SUM(lookup!$B$26)*L16","v":0},null,{"$f":"SUM(lookup!$B$27)*N16","v":0},null,{"$f":"SUM(lookup!$B$28)*P16","v":0}]
["SubTotals",null,{"$f":"SUM(C5:C16)","v":26400},null,{"$f":"SUM(E5:E16)","v":14000},null,{"$f":"SUM(G5:G16)","v":0},null,{"$f":"SUM(I5:I16)","v":0},null,{"$f":"SUM(K5:K16)","v":0},null,{"$f":"SUM(M5:M16)","v":0},null,{"$f":"SUM(O5:O16)","v":0},null,{"$f":"SUM(Q5:Q16)","v":0}]
["TOTAL COST",null,{"$f":"SUM(C17+E17+G17+I17+K17+M17+O17+Q17)","v":40400}]

{"sheet":"Mailing.list","index":8,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["Below is the standard list to begin your activation mailing list. You may want to add/subract from this list."]
["Some possible additions are contacts at the region/forest, yourself (to verify it's working), others on your cadre."]
[" "]
["Address",null,null,null,null,"Explanation"]
["warren2750@gmail.com",null,null,null,null,"Mike Warren (helping with spreadsheet problems and reporting)"]
[null,null,null,null,null,"Ass't Center Manager-NICC"]
["sfisher01@fs.fed.us",null,null,null,null,"Acting MAFFS Training Coordinator"]
["bbilyeu@fs.fed.us",null,null,null,null,"Financial Manager-NIFC"]
["intell@nifc.blm.gov",null,null,null,null,"NICC Intell Desk"]
["kachristensen@fs.fed.us",null,null,null,null,"Center Manager-NICC"]
["cod@nifc.blm.gov",null,null,null,null,"Coordinator at NICC"]
["jmullins@bresnan.net",null,null,null,null,"Darlene Mullins (Monitors problem areas and assists with monthly/yearly reporting)"]
[null," "," ",null,null,"Military representative @ NIFC"]
["aeg-wff@idbois.ang.af.mil",null,null,null,null,"Alternate for military rep. @ NIFC"]
["asc_icp@fs.fed.us",null,null,null,null,"ASC Incident Payment Center, Albuquerque NM"]
["fdomingu@blm.gov",null," ",null,null,"Frank Domingues MLO"]
[]
["Insert location name:",null,"Greeneville, SC"]

{"sheet":"Changes","index":9,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Changes made by Darlene:"]
[]
["TAB","COLUMN","ROW","CHANGE MADE"]
[]
["Tab Mailing.list",null,"2,3,4","Entered explanations on possible changes people should make to the stardardized mailing list"]
["Tab Mailing.list","C",18,"Have people fill in their operating \"location\" here, and it will auto fill on sheets 3,5,6,7"]
["7. DATA","i",null,"Added formula so no entry is needed (this is filled in by formula from columns f,g,h)"]
["7. DATA","i",null,"Changed header to indicate there is no entry required in this column"]
["3. MAFFS Military Costs","k,l,m,n","all","Changed flight hour costs to $5186 + $1600 (extraordinary mtnc)"]
["Tab Mailing.list",null,"all","Added ASC to standard mailing list for all costs (11/16/07) dm"]
["v 2.1.4","misc",null,"Saved some formula changes - 2/10/2009"]
[null,null,null," "]
[null,null,null,"NOTE:  flight cost for J-model C130 = $4894 per flight hour (no adjustment for extrodinary mtnc) (2010 season)"]
[null,null,null,"AFRes CO-Springs cost is  $6472 per flight hour"]
[null,null,null,"ANG H models = $5530 per flight hour"]
["v 2.1.2011 (new on 10.25.2010)",null,null,"Added Tab 8.AEG Costs to capture standard AEG costs for daily reporting"]
["v 2.1.2011","TAB3",null,"Changed flight hour costs to $6472 per flight hour for AFRES and $5530 for all ANG (even though J model is $4874)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["v.2.1.2011","TAB8",null,"Added AEG Costs - standard for 1 officer; 1 enlisted"]
["v.2.1.2011","ALL",null,"FIXED COSTS FOR DICK - dm"]
[null,null,null,"Used $5080/hr for J model on dates thru 17th. On 18th, used average of J @$5080 and H@$8614 for $6847"]

{"sheet":"Instructions","index":10,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,23,14],[12,2,12,14],[21,1,21,14],[20,1,20,14],[10,1,10,14],[13,1,13,14],[19,1,19,14],[15,1,15,14],[14,1,14,14],[16,1,16,14],[18,1,18,14],[11,2,11,14],[17,2,17,14]]}
[]
[]
[]
[]
[null,null,null,null,"Instructions for Completion of Workbook"]
[null,null,null,null,"Version 2.1.2011 (updated for 2011 operating season)"]
[]
[]
["1.","Enter your operating location in cell C19 of the Mailing.List tab.  That entry will then automatically populate all other \"Location\" occurrences."]
["2.","On the Mailing.List tab, verify your mailing list for report distribution and make appropriate changes."]
["3.","Begin by entering data on gray tab \"7. DATA\".  Enter info CAREFULLY as 2 additional tabs use this data in a pivot report. It is best to use the copy/paste functions whenever possible in order to avoid typos. Needed info will be available in MAFFS Ops. Sorties and flight hours will be from military records and gallons of retardant and costs will be available from your MABM. If incremental drops are made count entire mission as one sortie."]
[null,null,"For Column C \"P-codes\": The second digit of the P-Code indicates the jurisdictional agency.  For example:  D=(BLM); A=(BIA); P=(NPS); R=(FWS)"]
[null,null,"Standardize your entries whenever possible.  It makes the report on tab 2 less confusing. Also make sure you type in \"Support\"  when appropriate in Column D of Tab 7 because it feeds the totals at the bottom of Tab 3."]
["2.","Salmon tab \"6. Misc support Costs\" will be from procurement records. Make sure to insert lines in the middle of the page, in order to facilitate the \"Total Cost\" calculation (on the green tab). If you insert lines at the bottom, the fomula may not include all necessary lines."]
["3.","Lavender tab \"5. Federal Personnel\" is an estimate of all agency personnel assigned to the incident. The costs are developed as an average, including associated per diem. Although an estimate, these figures are recommended due to offsetting of highs and lows throughout the incident duration. Enter number of personnel assigned in each column -- if unsure of what number to enter, review the resource orders for your incident."]
["4.","Green tab \"4. Total Cost\" will update automatically because the numbers are linked to other tabs within this workbook. To check that the links are working correctly, you can manually check that row #5 is picking up the total from the salmon tab \"Mics. support Costs\" Grand Total. Row #6 should be picking up the grand total from the turquoise tab \"MAFFS Military Costs\" in column P, as well as any costs for AEG Staff recorded in tab 8. Row #7 should be picking up the total from column AD (cumulative Agency costs) on the lavender tab \"Federal Personnel\"."]
["5.","Turquoise tab \"3. MAFFS Military Costs\" will be collected from the military in MAFFS Ops. Fill in yellow cells. You will need to look at the military SitRep to determine the number of Guard versus Reserve personnel. "]
[null,null,"All other columns are locked in this report; however, imbedded in the costs are appropriate costs for flight hours (as determined by Bobbe BIlyea).  You will not be able to change this during the year, as costs will only be changed prior to each activation year, with DoD and FS agreement (during pre-season conference)."]
["6.","Blue tab \"2. Report.Summary.All\" is a pivot report that draws data from the gray tab \"DATA\". To update the information in the pivot report, click the blue tab and place your cursor anywhere within the report. On the toolbar, select Data, Refresh Data."]
["7.","Pink tab \"1. Report.MAFFS.by Incident\" is a pivot report that draws data from the gray tab \"DATA\". To update the information in the pivot report, click the pink tab and place your cursor anywhere within the report. On the toobar, select Data, Refresh Data (or hit the Refresh Button). Select the date you want to display by clicking the yellow pick list (you will usually select the most current date so your report will display that date when your recipient opens the workbook. "]
["8.","Blue tab \"8. AEG Costs\" is new for this version of the workbook. It is based on information from Lt Col Bryan Allen of the 146th AW. The tab uses a lookup for costs -- so all you need to do is enter your primary AEG staff and any additional staff."]
[null,"PLEASE DO NOT CHANGE ANY OF THE SPREAD SHEETS without checking with the MAFFS Training Coordinator.  This includes hiding data fields or rows.  These sheets are viewed by a number of folks and when they change all of a sudden it gets very confusing for some of them who have a valid right to know."]
["9.","Before sending to your mailing list, you may want to \"Hide\" the Instruction Sheet, the Mailing.List tab, and the changes tab. To do this select Format on the tool bar, click sheet, clide Hide.  You can easily Unhide at a later date. I would also hide tabs  5, 6, and 7......the only ones of importance are 1,2,3,4 "]

{"sheet":"lookup","index":11,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[]
["MLO",600]
["AMLO",550]
["AMLO-T",500]
["MABM",440]
["MABS or MABS-T",440]
["Procurement",440]
["MAFFS Clerk",400]
["Ground Support",350]
["MAFFS Mech.",900]
["Avionics Tech.",500]
["Safety Officer",400]
["Information Officer",400,null,null," "]
["BCMG",400]
["Security",500]
["Camp Crew",350]
[]
[]
[]
["AEG Commander",600]
["AEG Support",400]
["Additional 1",500]
["Additional 2",500]
["Additional 3",500]
["Additional 4",500]
["Additional 5",500]
["Additional 6",500]