{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["WSSPC Cooperative Agreement"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WSSPC Cooperative Agreement","index":0,"n_rows":106,"n_cols":19,"rows_kept":106,"cut":false,"hidden":false,"merged":[[94,14,95,14],[94,16,95,16],[94,8,95,8],[94,9,95,9],[94,10,95,10],[94,12,95,12],[94,13,95,13],[94,1,95,1],[94,2,95,2],[94,4,95,4],[94,5,95,5],[94,6,95,6],[41,14,42,14],[41,16,42,16],[38,0,38,16],[57,10,58,10],[57,12,58,12],[57,13,58,13],[57,14,58,14],[57,16,58,16],[41,1,42,1],[41,2,42,2],[41,4,42,4],[41,5,42,5],[41,6,42,6],[41,8,42,8],[41,9,42,9],[41,10,42,10],[41,12,42,12],[41,13,42,13],[0,16,1,16],[85,0,85,16],[57,0,58,0],[57,1,58,1],[57,2,58,2],[57,4,58,4],[57,5,58,5],[57,6,58,6],[57,8,58,8],[57,9,58,9],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,12,1,12],[0,13,1,13],[0,14,1,14],[0,6,1,6],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,4,1,4],[0,5,1,5],[2,0,2,16],[7,0,7,16],[84,0,84,16]]}
["PLANNED TASKS / EXPENSES","Aug 2018","Sep 2018",null,"Oct 2018","Nov 2018","Dec 2018",null,"Jan 2019","Feb 2019","Mar 2019",null,"Apr 2019","May 2019","Jun 2019",null,"Jul 2019"]
[null,null,null,"4th Quarter",null,null,null,"1st Quarter",null,null,null,"2nd Quarter",null,null,null,"3rd Quarter"]
["SUMMARY PLANNED COSTS"]
["Total BASE PLAN Amount",227000]
["Amt Budgeted Per Month",{"$f":"B13","v":16249},16549,null,16379,19923,18309,null,19279,20713.150000000001,18123.02,null,17410,30829.85,16549,null,16686.98]
["Cumulative Amount Budgeted",{"$f":"B5","v":16249},{"$f":"B6+C5","v":32798},null,{"$f":"C6+E5","v":49177},69100,87409,null,{"$f":"G6+I5","v":106688},127401.15,145524.16999999998,null,{"$f":"K6+M5","v":162934.16999999998},193764.02,210313.02,null,{"$f":"O6+Q5","v":227000}]
["Cumulative Budget Remaining",{"$f":"B4-B6","v":210751},{"$f":"B4-C6","v":194202},null,{"$f":"B4-E6","v":177823},{"$f":"B4-F6","v":157900},{"$f":"B4-G6","v":139591},null,{"$f":"B4-I6","v":120312},{"$f":"B4-J6","v":99598.85},{"$f":"B4-K6","v":81475.830000000016},null,{"$f":"B4-M6","v":64065.830000000016},{"$f":"B4-N6","v":33235.98000000001},{"$f":"B4-O6","v":16686.98000000001},null,{"$f":"B4-Q6","v":0}]
["SUMMARY ACTUAL COSTS"]
["Amt Expended Per Month"]
["Amount Expended to Date"]
["Cumulative Funds Remaining",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtask"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","TOTAL"]
["PLANNED MONTHLY COSTS - BASE PLAN $227,000",16249,16549,null,16379,19923,18309,null,19279,20713.150000000001,18123.02,null,17410,30829.85,16549,null,16686.98,{"$f":"SUM(B13:Q13)","v":227000}]
[]
["TASK 1.0 DEVELOP SEISMIC POLICIES",{"$f":"B16+B17","v":1300},1037.26,{"$f":"B15+C15","v":2337.2600000000002},1949.21,6008.7,2018.94,{"$f":"SUM(E15:G15)","v":9976.85},1560.21,2672.55,2399.9499999999998,{"$f":"SUM(I15:K15)","v":6632.71},2474.1999999999998,{"$f":"N16+N17","v":7550.1},{"$f":"O16+O17","v":2597},{"$f":"SUM(M15:O15)","v":12621.3},{"$f":"Q16+Q17","v":1130.0999999999999},{"$f":"D15+H15+L15+P15+Q15","v":32698.219999999998}]
["1.1 Develop & Encourage Adoption of Policy Recommendations",600,500,null,749.21,998.5,400,null,800,910.55,900,null,974.2,1118,1097,null,800,null,{"$f":"SUM(B16:Q16)","v":9847.4599999999991}]
["1.2 Conduct Board Meetings",700,537.26,null,1200,5010.2,1618.94,null,760.21,1762,1499.95,null,1500,6432.1,1500,null,330.1,null,{"$f":"SUM(B17:Q17)","v":22850.760000000002}]
["TASK 2.0 PROVIDE FORUMS ",{"$f":"B19+B20","v":1500},1002.89,{"$f":"B18+C18","v":2502.89},896.44,697,637.15,{"$f":"SUM(E18:G18)","v":2230.59},1138.56,2615,2142.4700000000003,{"$f":"SUM(I18:K18)","v":5896.0300000000007},2630.45,11058.05,2100,{"$f":"SUM(M18:O18)","v":15788.5},0,{"$f":"D18+H18+L18+P18+Q18","v":26418.010000000002}]
["2.1 Hold WSSPC Annual Meeting (including Awards)",1200,762.89,null,697.25,200,400,null,938,1215,1199,null,1630.45,7058.05,1600,null,0,null,{"$f":"SUM(B19:Q19)","v":16900.64}]
["2.2  Earthquake Program Managers Meeting",300,240,null,199.19,497,237.15,null,200.56,1400,943.47,null,1000,4000,500,null,0,null,{"$f":"SUM(B20:Q20)","v":9517.369999999999}]
["TASK 3.0 PROVIDE OUTREACH AND EDUCATION",{"$f":"SUM(B22:B25)","v":5960.9800000000005},{"$f":"SUM(C22:C25)","v":6771.15},{"$f":"B21+C21","v":12732.130000000001},{"$f":"SUM(E22:E25)","v":5985},{"$f":"SUM(F22:F25)","v":3636.29},6130.46,{"$f":"SUM(E21:G21)","v":15751.75},4602.05,5821.54,7352.49,{"$f":"SUM(I21:K21)","v":17776.080000000002},5197.7300000000005,4942.43,5952.1,{"$f":"SUM(M21:O21)","v":16092.26},5847.38,{"$f":"D21+H21+L21+P21+Q21","v":68199.600000000006}]
["3.1 Website",1718.88,2041.41,null,2200,1417,1812,null,1200,1550,1355,null,1600,2042,2160,null,2100,null,{"$f":"SUM(B22:Q22)","v":21196.29}]
["3.2  Quarterly Electronic Newsletter & Monthly Bulletins",3154.64,3455.74,null,2885,2219.29,3318,null,2299.0500000000002,2296.54,4097.49,null,2600.0300000000002,2900.43,3792.1,null,3247.38,null,{"$f":"SUM(B23:Q23)","v":36265.689999999995}]
["3.3  Annual Report",0,0,null,0,0,1000.46,null,1103,1975,1600,null,997.7,0,0,null,0,null,{"$f":"SUM(B24:Q24)","v":6676.16}]
["3.4  Conduct Community Education and Outreach",1087.46,1274,null,900,0,0,null,0,0,300,null,0,0,0,null,500,null,{"$f":"SUM(B25:Q25)","v":4061.46}]
["TASK 4.0  MAINTAIN & ENCOURAGE PARTNERSHIPS",{"$f":"B27+B28","v":538},878.04,{"$f":"B26+C26","v":1416.04},780.96,930.62,930,{"$f":"SUM(E26:G26)","v":2641.58},510.2,761.06,313.75,{"$f":"SUM(I26:K26)","v":1585.01},242.19,201.29,399.9,{"$f":"SUM(M26:O26)","v":843.38},581.05999999999995,{"$f":"D26+H26+L26+P26+Q26","v":7067.07}]
["4.1 Maintain & Encourage Partnerships",152,300,null,278.36,430,130,null,100,381.06,213.75,null,242.19,201.29,399.9,null,581.05999999999995,null,{"$f":"SUM(B27:Q27)","v":3409.61}]
["4.2 Affiliate Member Program",386,578.04,null,502.6,500.62,800,null,410.2,380,100,null,0,0,0,null,0,null,{"$f":"SUM(B28:Q28)","v":3657.4599999999996}]
["TASK 5.0 FINANCIAL AND GRANTS MANAGEMENT",{"$f":"SUM(B30:B32)","v":6950.02},6859.66,{"$f":"B29+C29","v":13809.68},6067.39,8650.39,8592.4500000000007,{"$f":"SUM(E29:G29)","v":23310.23},10667.98,8843,5914.3600000000006,{"$f":"SUM(I29:K29)","v":25425.34},5965.43,7077.9800000000005,5500,{"$f":"SUM(M29:O29)","v":18543.41},7928.4400000000005,{"$f":"D29+H29+L29+P29+Q29","v":89017.1}]
["5.1 Manage Cooperative Agreement",1650,1800,null,1188,1350,972.45,null,1200,1975,950,null,1465,1377.7,700,null,1400,null,{"$f":"SUM(B30:Q30)","v":16028.150000000001}]
["5.2 Manage WSSPC Finances ",1700,1959.66,null,1879.39,1100.3900000000001,2120,null,4667.9799999999996,3268,2527,null,2300,2600.2800000000002,1900,null,1728.44,null,{"$f":"SUM(B31:Q31)","v":27751.139999999996}]
["5.3  Maintain Office and Support Personnel",3600.02,3100,null,3000,6200,5500,null,4800,3600,2437.36,null,2200.4299999999998,3100,2900,null,4800,null,{"$f":"SUM(B32:Q32)","v":45237.81}]
["TASK 6.0 OUTCOMES REPORT ",0,0,{"$f":"B33+C33","v":0},700,0,0,{"$f":"SUM(E33:G33)","v":700},800,0,0,{"$f":"SUM(I33:K33)","v":800},900,0,0,{"$f":"SUM(M33:O33)","v":900},1200,{"$f":"D33+H33+L33+P33+Q33","v":3600}]
["6.1 Quarterly Outcomes Report",0,0,null,700,0,0,null,800,0,0,null,900,0,0,null,400,null,{"$f":"SUM(B34:Q34)","v":2800}]
["6.2 Final Outcomes Report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,null,{"$f":"SUM(B35:Q35)","v":800}]
["PLANNED MONTHLY COSTS",{"$f":"B15+B18+B21+B26+B29+B33","v":16249},{"$f":"C15+C18+C21+C26+C29+C33","v":16549},null,{"$f":"E15+E18+E21+E26+E29+E33","v":16379},{"$f":"F15+F18+F21+F26+F29+F33","v":19923},{"$f":"G15+G18+G21+G26+G29+G33","v":18309},null,{"$f":"I15+I18+I21+I26+I29+I33","v":19279},20713.150000000001,18123.02,null,17410,30829.850000000002,16549,null,16686.98,{"$f":"SUM(R15:R33)","v":227000},{"$f":"SUM(S16:S35)","v":226999.99999999997}]
["QUARTER TOTALS",null,null,{"$f":"SUM(D15:D33)","v":32798},null,null,null,{"$f":"SUM(H15:H33)","v":54611},null,null,null,{"$f":"SUM(L15:L33)","v":58115.17},null,null,null,{"$f":"SUM(P15:P33)","v":64788.849999999991},{"$f":"Q36","v":16686.98}]
[]
[]
[]
[]
["PLANNED MONTHLY COSTS - STATE SUPPORT","Aug 2018","Sep 2018",null,"Oct 2018","Nov 2018","Dec 2018",null,"Jan 2019","Feb 2019","Mar 2019",null,"Apr 2019","May 2019","Jun 2019",null,"Jul 2019","TOTAL"]
[176547,null,null,"4th Quarter",null,null,null,"1st Quarter",null,null,null,"2nd Quarter",null,null,null,"3rd Quarter",null,"STATES"]
["7.1 GUAM                                                                   $30,000",null,null,null,8000,null,null,{"$f":"E44","v":8000},3000,7000,12000,{"$f":"SUM(I44:K44)","v":22000},null,null,null,null,null,{"$f":"B44+C44+E44+F44+G44+I44+J44+K44+M44+N44+O44+Q44","v":30000}]
["7.2.1   HAWAII-1                                                          $15,000",null,3750,{"$f":"C45","v":3750},null,null,3750,{"$f":"G45","v":3750},null,null,3750,{"$f":"K45","v":3750},null,null,3750,{"$f":"O45","v":3750},null,15000]
["7.2.2   HAWAII -2                                                         $15,000",8000,null,{"$f":"B46","v":8000},null,null,null,null,null,7000,null,{"$f":"J46","v":7000},null,null,null,null,null,15000]
["7.3 IDAHO                                                                   $30,424",null,null,null,null,null,null,null,null,null,3000,{"$f":"K47","v":3000},6060,null,null,{"$f":"M47","v":6060},21364,30424]
["7.4 NEVADA                                                               $35,123",null,18000,{"$f":"C48","v":18000},null,null,null,null,null,null,null,null,17123,null,null,{"$f":"M48","v":17123},null,35123]
["7.5 WYOMING                                                             $27,000",null,9000,{"$f":"C49","v":9000},9000,9000,null,{"$f":"E49+F49","v":18000},null,null,null,null,null,null,null,null,null,27000]
["7.6 EARTHQUAKE PROGRAM MANAGERS               $24,000",null,null,null,null,null,null,null,null,null,null,null,null,24000,null,{"$f":"N50","v":24000},null,24000]
["American Samoa, CNMI. Guam, Hawaii, Idaho, Nevada, New Mexico, Washington, Wyoming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R44:R50)","v":176547}]
["MONTHLY TOTALS",{"$f":"SUM(B44:B50)","v":8000},{"$f":"SUM(C44:C50)","v":30750},null,{"$f":"SUM(E44:E50)","v":17000},{"$f":"SUM(F44:F50)","v":9000},{"$f":"SUM(G44:G50)","v":3750},null,{"$f":"SUM(I44:I50)","v":3000},{"$f":"SUM(J44:J50)","v":14000},{"$f":"SUM(K44:K50)","v":18750},null,{"$f":"SUM(M44:M50)","v":23183},{"$f":"SUM(N44:N50)","v":24000},{"$f":"SUM(O44:O50)","v":3750},null,{"$f":"SUM(Q44:Q50)","v":21364}]
["QUARTER TOTALS",null,null,{"$f":"SUM(D44:D51)","v":38750},null,null,null,{"$f":"SUM(H44:H50)","v":29750},null,null,null,{"$f":"SUM(L44:L50)","v":35750},null,null,null,{"$f":"SUM(P44:P50)","v":50933},{"$f":"Q52","v":21364},{"$f":"SUM(D53+H53+L53+P53+Q53)","v":176547}]
[]
[]
[]
[]
["ACTUAL TASKS / EXPENSES","Aug 2018","Sep 2018","4th Quarter","Oct 2018","Nov 2018","Dec 2018","1st Quarter","Jan 2019","Feb 2019","Mar 2019","2nd Quarter","Apr 2019","May 2019","Jun 2019","3rd Quarter","Jul 2019"]
[]
[]
["ACTUAL MONTHLY COST - BASE PLAN"]
["TASK 1.0 DEVELOP SEISMIC POLICIES",{"$f":"B63+B64","v":0},{"$f":"C63+C64","v":0},null,{"$f":"E63+E64","v":0},{"$f":"F63+F64","v":0},{"$f":"G63+G64","v":0},null,0,0,0,null,0,0,0,null,0]
["1.1 Develop & Encourage Adoption of Policy Recommendations"]
["1.2 Conduct Board Meetings"]
["TASK 2.0 PROVIDE FORUMS",{"$f":"B66+B67","v":0},{"$f":"C66+C67","v":0},null,{"$f":"E66+E67","v":0},{"$f":"F66+F67","v":0},{"$f":"G66+G67","v":0},null,0,0,0,null,0,0,0,null,0]
["2.1 Hold WSSPC Annual Meeting (including Awards)"]
["2.2 Earthquake Program Managers Meeting"]
["TASK 3.0 PROVIDE OUTREACH/PUBLIC EDUCATION",{"$f":"B69+B70+B71+B72","v":0},{"$f":"C69+C70+C71+C72","v":0},null,{"$f":"E69+E70+E71+E72","v":0},{"$f":"F69+F70+F71+F72","v":0},{"$f":"G69+G70+G71+G72","v":0},null,0,0,0,null,0,0,0,null,0]
["3.1  Website"]
["3.2  Quarterly Electronic Newsletter & Monthly Bulletins"]
["3.3  Annual Report"]
["3.4  Conduct Community Education and Outreach"]
["TASK 4.0 MAINTAIN & ENCOURAGE PARTNERSHIPS",{"$f":"B74+B75","v":0},{"$f":"C74+C75","v":0},null,{"$f":"E74+E75","v":0},{"$f":"F74+F75","v":0},{"$f":"G74+G75","v":0},null,0,0,0,null,0,0,0,null,0]
["4.1 Maintain & Encourage Partnerships"]
["4.2 Affiliate Member Program"]
["TASK 5.0 FINANCIAL AND GRANTS MANAGEMENT",{"$f":"B77+B78+B79","v":0},{"$f":"C77+C78+C79","v":0},null,{"$f":"E77+E78+E79","v":0},{"$f":"F77+F78+F79","v":0},{"$f":"G77+G78+G79","v":0},null,0,0,0,null,0,0,0,null,0]
["5.1 Manage Cooperative Agreement"]
["5.2 Manage WSSPC Finances "]
["5.3  Maintain Office and Support Personnel"]
["TASK 6.0 OUTCOMES REPORT",{"$f":"B81+B82","v":0},{"$f":"C81+C82","v":0},null,{"$f":"E81+E82","v":0},{"$f":"F81+F82","v":0},{"$f":"G81+G82","v":0},null,0,0,0,null,0,0,0,null,0]
["6.1 Prepare quarterly Outcomes Reports"]
["6.2 Prepare final Outcomes Report"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ACTUAL MONTHLY COST - STATE SUPPORT","Aug 2018","Sep 2018",null,"Oct 2018","Nov 2018","Dec 2018",null,"Jan 2019","Feb 2019","Mar 2019",null,"Apr 2019","May 2019","Jun 2019",null,"Jul 2019","TOTAL"]
[176547,null,null,"4th Quarter",null,null,null,"1st Quarter",null,null,null,"2nd Quarter",null,null,null,"3rd Quarter",null,"STATES"]
["7.1 GUAM                                                                   $30,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B97+C97+E97+F97+G97+I97+J97+K97+M97+N97+O97+Q97","v":0}]
["7.2.1   HAWAII-1                                                          $15,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["7.2.2   HAWAII -2                                                         $15,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["7.3 IDAHO                                                                   $30,424",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["7.4 NEVADA                                                               $35,123",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["7.5 WYOMING                                                             $27,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["7.6 EARTHQUAKE PROGRAM MANAGERS               $24,000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["American Samoa, CNMI. Guam, Hawaii, Idaho, Nevada, New Mexico, Washington, Wyoming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R97:R103)","v":0}]
["MONTHLY TOTALS",{"$f":"SUM(B97:B103)","v":0},{"$f":"SUM(C97:C103)","v":0},null,{"$f":"SUM(E97:E103)","v":0},{"$f":"SUM(F97:F103)","v":0},{"$f":"SUM(G97:G103)","v":0},null,{"$f":"SUM(I97:I103)","v":0},{"$f":"SUM(J97:J103)","v":0},{"$f":"SUM(K97:K103)","v":0},null,{"$f":"SUM(M97:M103)","v":0},{"$f":"SUM(N97:N103)","v":0},{"$f":"SUM(O97:O103)","v":0},null,{"$f":"SUM(Q97:Q103)","v":0}]
["QUARTER TOTALS",null,null,{"$f":"SUM(D97:D104)","v":0},null,null,null,{"$f":"SUM(H97:H103)","v":0},null,null,null,{"$f":"SUM(L97:L103)","v":0},null,null,null,{"$f":"SUM(P97:P103)","v":0},{"$f":"Q105","v":0},{"$f":"SUM(D106+H106+L106+P106+Q106)","v":0}]