{"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":121,"n_cols":15,"rows_kept":121,"cut":false,"hidden":false,"merged":[[55,0,55,12],[56,8,57,8],[56,9,57,9],[56,10,57,10],[56,11,57,11],[56,12,57,12],[0,12,1,12],[101,0,101,12],[56,0,57,0],[56,1,57,1],[56,2,57,2],[56,3,57,3],[56,4,57,4],[56,5,57,5],[56,6,57,6],[56,7,57,7],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11],[0,5,1,5],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[2,0,2,12],[7,0,7,12],[113,1,114,1],[113,2,114,2],[113,3,114,3],[113,4,114,4],[113,5,114,5],[113,6,114,6],[113,7,114,7],[113,8,114,8],[113,9,114,9],[113,10,114,10],[113,11,114,11],[113,12,114,12],[113,0,114,0],[100,0,100,12]]}
["PLANNED TASKS / EXPENSES","Aug 2017","Sep 2017","Oct 2017","Nov 2017","Dec 2017","Jan 2018","Feb 2018","Mar 2018","Apr 2018","May 2018","Jun 2018","Jul 2018"]
[]
["SUMMARY PLANNED COSTS"]
["Total Cooperative Agreement Amount",279833]
["Amt Budgeted Per Month",{"$f":"B12","v":16145.41},17145.45,16200.45,18145.45,23118.25,22255.45,49865.45,18123,16190.45,49552.75,16145.45,16945.439999999999]
["Cumulative Amount Budgeted",{"$f":"B5","v":16145.41},{"$f":"B6+C5","v":33290.86},49491.31,67636.759999999995,90755.01,113010.45999999999,162875.90999999997,180998.90999999997,197189.36,246742.11,262887.56,279833]
["Cumulative Budget Remaining",{"$f":"B4-B6","v":263687.59000000003},{"$f":"B4-C6","v":246542.14},{"$f":"B4-D6","v":230341.69},{"$f":"B4-E6","v":212196.24},{"$f":"B4-F6","v":189077.99},{"$f":"B4-G6","v":166822.54},{"$f":"B4-H6","v":116957.09000000003},{"$f":"B4-I6","v":98834.090000000026},{"$f":"B4-J6","v":82643.640000000014},{"$f":"B4-K6","v":33090.890000000014},{"$f":"B4-L6","v":16945.440000000002},{"$f":"B4-M6","v":0}]
["SUMMARY ACTUAL COSTS"]
["Amt Expended Per Month"]
["Amount Expended to Date"]
["Cumulative Funds Remaining"]
["PLANNED MONTHLY COSTS - BASE PLAN $225,000",16145.41,17145.45,16200.45,18145.45,23118.25,22255.45,49865.45,18123,16190.45,49552.75,16145.45,16945.439999999999,{"$f":"SUM(B12:M12)","v":279833}]
[]
["TASK 1.0 DEVELOP SEISMIC POLICIES",1100,1237.26,2249.21,2798.5,6572.8,2560.21,2800,2800,2304.1999999999998,9386.65,2497,2821,{"$f":"SUM(B14:M14)","v":39126.83}]
["1.1 Develop & Encourage Adoption of Policy Recommendations",600,800,749.21,1198.5,480,800,900,900,1004.2,900,1297,1100,null,{"$f":"SUM(B15:M15)","v":10728.91}]
["1.2 Conduct Board Meetings",500,437.26,1500,1600,6092.8,1760.21,1900,1900,1300,8486.65,1200,1721,null,{"$f":"SUM(B16:M16)","v":28397.919999999998}]
["TASK 2.0 PROVIDE FORUMS ",1500,1002.89,2446.25,2097,1300,3350.06,4215,3696.85,3630.93,11802.5,2300,1996,{"$f":"SUM(B17:M17)","v":39337.479999999996}]
["2.1 Hold WSSPC Annual Meeting (including Awards)",1355,762.89,2096.25,1747,800,1550.06,1815,1848.42,1630.93,6302.5,1700,1196,null,{"$f":"SUM(B18:M18)","v":22804.05}]
["2.2  Earthquake Program Managers Meeting",145,240,350,350,500,1800,2400,1848.43,2000,5500,600,800,null,{"$f":"SUM(B19:M19)","v":16533.43}]
["TASK 3.0 PROVIDE OUTREACH AND EDUCATION",5357.39,5642.5,4285,4219.5600000000004,5518,4499.9799999999996,4096.3900000000003,5397.49,4597.7,4342.43,4792.3900000000003,4647.38,{"$f":"SUM(B20:M20)","v":57396.209999999992}]
["3.1 Website",1362,1600,1200,1500,1500,1200,1000,1000,1400,1442.43,1400,1800,null,{"$f":"SUM(B21:M21)","v":16404.43}]
["3.2  Quarterly Electronic Newsletter & Monthly Bulletins",2960.39,3142.5,2185,2719.56,3018,2199.98,2296.39,3097.49,2700,2900,3392.39,2847.38,null,{"$f":"SUM(B22:M22)","v":33459.079999999994}]
["3.3  Annual Report *",0,0,0,0,1000,1100,800,1000,497.7,0,0,0,null,{"$f":"SUM(B23:M23)","v":4397.7}]
["3.4  Conduct Community Education and Outreach",1035,900,900,0,0,0,0,300,0,0,0,0,null,{"$f":"SUM(B24:M24)","v":3135}]
["TASK 4.0  MAINTAIN & ENCOURAGE PARTNERSHIPS",1038,1478.04,502.6,830,1230,510.2,761.06,313.75,342.19,301.29000000000002,499.9,1081.06,{"$f":"SUM(B25:M25)","v":8888.0899999999983}]
["4.1 Maintain & Encourage Partnerships",52,986,300,330,230,100,381.06,213.75,242.19,201.29,399.9,581.05999999999995,null,{"$f":"SUM(B26:M26)","v":4017.25}]
["4.2 Affiliate Member Program",986,492.04,202.6,500,1000,410.2,380,100,100,100,100,500,null,{"$f":"SUM(B27:M27)","v":4870.84}]
["TASK 5.0 FINANCIAL AND GRANTS MANAGEMENT",7150.02,6159.76,5467.39,6200.39,7872.45,7985,7468,5914.91,4065.43,3886.88,5431.16,5150,{"$f":"SUM(B28:M28)","v":72751.39}]
["5.1 Manage Cooperative Agreement",1850,1200,1138,810.39,1372.45,1000,800,800,950,800,1200,1200,null,{"$f":"SUM(B29:M29)","v":13120.84}]
["5.2 Manage WSSPC Finances ",1700,1959.76,1329.39,890,1500,2085,2650,2277.5500000000002,1000,1200,1800,1650,null,{"$f":"SUM(B30:M30)","v":20041.7}]
["5.3  Maintain Office and Support Personnel",3600.02,3000,3000,4500,5000,4900,4018,2837.36,2115.4299999999998,1886.88,2431.16,2300,null,{"$f":"SUM(B31:M31)","v":39588.849999999991}]
["TASK 6.0  OUTCOMES REPORT",0,625,1250,0,625,1250,625,0,1250,0,625,1250,{"$f":"SUM(B32:M32)","v":7500}]
["6.1 Prepare quarterly Outcomes Reports",0,625,1250,0,625,1250,625,0,1250,0,125,0,null,{"$f":"SUM(B33:M33)","v":5750}]
["6.2 Prepare final Outcomes Report",0,0,0,0,0,0,0,0,0,0,500,1250,null,{"$f":"SUM(B34:M34)","v":1750}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O15:O34)","v":225000}]
[]
["TASK 7.0 SUPPORT STATES          $54,833.00",{"$f":"SUM(B39:B51)","v":0},1000,0,2000,0,2100,29900,0,0,19833,0,0,{"$f":"SUM(B38:M38)","v":54833}]
["7.1 Support Travel to NEPM                    $19,833.00",null,null,null,null,null,null,null,null,null,19833]
["a. R VI New Mexico"]
["b. R VIII  Montana"]
["c. R VIII Wyoming"]
["d. R IX Nevada"]
["e. R IX Hawaii"]
["f. R IX Guam"]
["g. R IX American Samoa"]
["h. R IX Northern Mariana Islands"]
["i. R X Alaska"]
["j. R X Idaho"]
["k. R X Washington"]
["7.2 Hawaii Workshop*                            $35,000.00",null,1000,null,2000,null,2100,29900]
["a. Secure meeting space",null,1000,null,null,null,null,13000]
["b. Support travel",null,null,null,2000,null,null,16900]
["c. Support registration",null,null,null,null,null,2100]
[]
["* Indicates Contracts are included in these tasks"]
["ACTUAL TASKS / EXPENSES","Aug 2017","Sep 2017","Oct 2017","Nov 2017","Dec 2017","Jan 2018","Feb 2018","Mar 2018","Apr 2018","May 2018","Jun 2018","Jul 2018"]
[]
[]
["ACTUAL MONTHLY COST - BASE PLAN",{"$f":"B61+B64+B67+B72+B75+B84","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(M61+M64+M67+M72+M75)","v":0}]
["TASK 1.0 DEVELOP SEISMIC POLICIES"]
["1.1 Develop & Encourage Adoption of Policy Recommendations"]
["1.2 Conduct Board Meetings"]
["TASK 2.0 PROVIDE FORUMS"]
["2.1 Hold WSSPC Annual Meeting (including Awards)"]
["2.2 Earthquake Program Managers Meeting"]
["TASK 3.0 PROVIDE OUTREACH/PUBLIC EDUCATION"]
["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"]
["4.1 Maintain & Encourage Partnerships"]
["4.2 Affiliate Member Program"]
["TASK 5.0 FINANCIAL AND GRANTS MANAGEMENT"]
["5.1 Manage Cooperative Agreement"]
["5.2 Manage WSSPC Finances "]
["5.3  Maintain Office and Support Personnel"]
["TASK 6.0 OUTCOMES REPORT"]
["6.1 Prepare quarterly Outcomes Reports"]
["6.2 Prepare final Outcomes Report"]
[]
[]
["TASK 7.0 SUPPORT STATES          $54,833.00"]
["7.1 Support Travel to NEPM                  $19,833.00"]
["a. R VI New Mexico"]
["b. R VIII  Montana"]
["c. R VIII Wyoming"]
["d. R IX Nevada"]
["e. R IX Hawaii"]
["f. R IX Guam"]
["g. R IX American Samoa"]
["h. R IX Northern Mariana Islands"]
["i. R X Alaska"]
["j. R X Idaho"]
["k. R X Washington"]
["7.2 Hawaii Workshop                           $35,000.00"]
["a. Secure meeting space"]
["b. Support travel"]
["c. Support registration"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CONTRACTS /                                     TOTAL","Aug 2017","Sep 2017","Oct 2017","Nov 2017","Dec 2017","Jan 2018","Feb 2018","Mar 2018","Apr 2018","May 2018","Jun 2018","Jul 2018"]
[]
["Task 1.0"]
["Task 2.0"]
["Task 3.3 Copy, assemble, print tabs, \nbind Annual Report\n                                                                                   $600",null,null,null,null,null,null,null,600]
["Task 4.0"]
["Task 5.0"]
["Task 7.2 Contract  for Hawaii\n workshop meeting space\n                                                                              $14,000",null,1000,null,null,null,null,13000]