{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["How to Use This Tool","Overview & Evaluation","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","Medical HP Budget Submission","Free Resources","Formulas","Stakeholder Data Call","Data Validation","Database Link"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":28,"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":"How to Use This Tool","index":0,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["How to Use This Tool"]
[]
["Overview & Evaluation tab"]
["Overview"]
["The Overview tab provides a snapshot of your command's Health Promotion (HP) annual planning process, assessment process, and command demographics."]
["--Complete all cells highlighted in white."]
["--The Command Mission and Command Vision fields should reflect your command's mission and vision statements. You do not need to create statements specific to your HP program."]
["--To help you develop goals for your command, we suggest you utilize the SMART model. S = Specific; M = Measurable; A = Attainable; R = Relevant; T = Timely."]
["Evaluation"]
["The Evaluation portion allows you to track your command's physical assessments and track goal progress over the year."]
["--Prior to the end of year submission, complete all applicable cells highlighted in white."]
["--The table tracking goal progress is prepopulated with data from the Monthly tabs. Activities rated 4 or 5 (Column O) are considered successful."]
[]
["Monthly tabs"]
["Monthly tabs are where you can plan, execute, and measure monthly HP activities."]
["--Complete all applicable cells highlighted in white."]
["--Column I contains hyperlinks to resources for you to use throughout the month."]
["--At the end of every month don't forget to evaluate each activity (row 24 ) and prepare materials for the following month (row 26 )."]
[]
["Medical HP Budget Submission tab"]
["The Medical HP Budget Submission tab is used to submit annual HP budgets to NMCPHC, the Regions, and BUMED for review."]
["--Please complete all applicable cells/rows highlighted in yellow."]
["--Please disregard the hidden values in rows 1 and 2, as well as HQ Instructions, these will be used to compile all MTF submissions."]
[]
["Free Resources tab"]
["The Free Resources tab provides links to free HP resources that can be downloaded, ordered, etc. for use by HP staff ."]
["--Review the available resources and download/order as desired."]
[]
["Stakeholder Data Call tab"]
["The Stakeholder Data Call tab is used to collect up to date information on local HP personnel."]
["--Please complete all applicable fields for all personnel with an HP role."]
["--Please enter each person's information in a separate row."]

{"sheet":"Overview & Evaluation","index":1,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,11],[60,0,60,2],[42,0,42,2],[59,0,59,2],[58,0,58,2],[37,0,37,2],[22,0,22,2],[23,2,34,2],[29,0,29,1],[30,0,30,1],[28,0,28,1],[2,3,2,11],[1,3,1,11],[69,0,69,2],[70,0,70,2],[67,0,67,2],[64,3,66,11],[64,0,66,2],[67,3,67,11]]}
["HPW Annual Plan"]
[null,null,"Overview","Information and Evaluation"]
["Command Name",null,null,"To be completed at the end of the FY"]
[]
["Command  Mission Statement"]
[]
["Command Vision Statement"]
[]
["Command Demographics"]
["Command Type"]
[]
["Branch"]
[]
["Command Size"]
[]
[]
["PRT",null,"End of Prior FY Pass Rate %",null,"End of Current FY Pass Rate%"]
["Body Composition Assessment (BCA):"]
[]
["Physical Fitness Assessment (PFA):"]
[]
["Assessment Process"]
["Identify resources used for assessment (examples below) and key take-aways here:"]
[]
["Recommended Command Assessment Resources"]
["Health Risk Assessment (HRA)"]
["Health Interest Questionnaire (HIQ)"]
["Command Incident Reports"]
[]
[]
["Recommended Community Assessment Resources"]
["CDC 500 Cities Map"]
["National Prevention Strategy"]
[]
[]
[]
["Priority Areas"]
["As a result of the community assessment process, the Priority Areas selected for the command HP program are (select all that apply): "]
[]
[]
[]
[]
["Per the HIQ, the best times to conduct Health Promotion/Wellness programs and activities are:"]
[]
[]
[]
[null,null,null,null,"Actual Blue-H Level"]
["Projected Blue-H Level"]
["Blue-H Award "]
[null,null,null,null,"Has this goal been met?",null,"Total Number of Events Aligned to Goal",null,"% Success of Events\n(rated 3 or greater)",null,"Average Effectiveness of Events Aligned to Goal"]
["Goal(s)","#1",null,null,null,null,{"$f":"JAN!C111+FEB!C111+MAR!C111+APR!C111+MAY!C111+JUN!C111+JUL!C111+AUG!C111+SEP!C111+OCT!C111+NOV!C111+DEC!C111","v":0},null,{"$f":"IFERROR((JAN!E111+FEB!E111+MAR!E111+APR!E111+MAY!E111+JUN!E111+JUL!E111+AUG!E111+SEP!E111+OCT!E111+NOV!E111+DEC!E111)/(JAN!C111+FEB!C111+MAR!C111+APR!C111+MAY!C111+JUN!C111+JUL!C111+AUG!C111+SEP!C111+OCT!C111+NOV!C111+DEC!C111),0)","v":0},null,{"$f":"(SUM(OCT!I111,NOV!I111,DEC!I111,JAN!I111,FEB!I111,MAR!I111,APR!I111,MAY!I111,JUN!I111,JUL!I111,AUG!I111,SEP!I111))/(SUM(OCT!C111,NOV!C111,DEC!C111,JAN!C111,FEB!C111,MAR!C111,APR!C111,MAY!C111,JUN!C111,JUL!C111,AUG!C111,SEP!C111))","v":{"$error":"#DIV/0!"}}]
[]
[null,"#2",null,null,null,null,{"$f":"JAN!C112+FEB!C112+MAR!C112+APR!C112+MAY!C112+JUN!C112+JUL!C112+AUG!C112+SEP!C112+OCT!C112+NOV!C112+DEC!C112","v":0},null,{"$f":"IFERROR((JAN!E112+FEB!E112+MAR!E112+APR!E112+MAY!E112+JUN!E112+JUL!E112+AUG!E112+SEP!E112+OCT!E112+NOV!E112+DEC!E112)/(JAN!C112+FEB!C112+MAR!C112+APR!C112+MAY!C112+JUN!C112+JUL!C112+AUG!C112+SEP!C112+OCT!C112+NOV!C112+DEC!C112),0)","v":0},null,{"$f":"(SUM(OCT!I112,NOV!I112,DEC!I112,JAN!I112,FEB!I112,MAR!I112,APR!I112,MAY!I112,JUN!I112,JUL!I112,AUG!I112,SEP!I112))/(SUM(OCT!C112,NOV!C112,DEC!C112,JAN!C112,FEB!C112,MAR!C112,APR!C112,MAY!C112,JUN!C112,JUL!C112,AUG!C112,SEP!C112))","v":{"$error":"#DIV/0!"}}]
[]
[null,"#3",null,null,null,null,{"$f":"JAN!C113+FEB!C113+MAR!C113+APR!C113+MAY!C113+JUN!C113+JUL!C113+AUG!C113+SEP!C113+OCT!C113+NOV!C113+DEC!C113","v":0},null,{"$f":"IFERROR((JAN!E113+FEB!E113+MAR!E113+APR!E113+MAY!E113+JUN!E113+JUL!E113+AUG!E113+SEP!E113+OCT!E113+NOV!E113+DEC!E113)/(JAN!C113+FEB!C113+MAR!C113+APR!C113+MAY!C113+JUN!C113+JUL!C113+AUG!C113+SEP!C113+OCT!C113+NOV!C113+DEC!C113),0)","v":0},null,{"$f":"(SUM(OCT!I113,NOV!I113,DEC!I113,JAN!I113,FEB!I113,MAR!I113,APR!I113,MAY!I113,JUN!I113,JUL!I113,AUG!I113,SEP!I113))/(SUM(OCT!C113,NOV!C113,DEC!C113,JAN!C113,FEB!C113,MAR!C113,APR!C113,MAY!C113,JUN!C113,JUL!C113,AUG!C113,SEP!C113))","v":{"$error":"#DIV/0!"}}]
[]
[null,"#4",null,null,null,null,{"$f":"JAN!C114+FEB!C114+MAR!C114+APR!C114+MAY!C114+JUN!C114+JUL!C114+AUG!C114+SEP!C114+OCT!C114+NOV!C114+DEC!C114","v":0},null,{"$f":"IFERROR((JAN!E114+FEB!E114+MAR!E114+APR!E114+MAY!E114+JUN!E114+JUL!E114+AUG!E114+SEP!E114+OCT!E114+NOV!E114+DEC!E114)/(JAN!C114+FEB!C114+MAR!C114+APR!C114+MAY!C114+JUN!C114+JUL!C114+AUG!C114+SEP!C114+OCT!C114+NOV!C114+DEC!C114),0)","v":0},null,{"$f":"(SUM(OCT!I114,NOV!I114,DEC!I114,JAN!I114,FEB!I114,MAR!I114,APR!I114,MAY!I114,JUN!I114,JUL!I114,AUG!I114,SEP!I114))/(SUM(OCT!C114,NOV!C114,DEC!C114,JAN!C114,FEB!C114,MAR!C114,APR!C114,MAY!C114,JUN!C114,JUL!C114,AUG!C114,SEP!C114))","v":{"$error":"#DIV/0!"}}]
[]
["Leadership Acknowledgement and Signature",null,null,null,"Total Cost"]
["I acknowledge that I have reviewed and approved the Health Promotion Annual Plan.",null,null,null,{"$f":"SUM(JAN!K29,FEB!K29,MAR!K29,APR!K29,MAY!K29,JUN!K29,JUL!K29,AUG!K29,SEP!K29,OCT!K29,NOV!K29,DEC!K29)","v":0}]
[]
["Name, Title, Date"]
[]
[]
["Click below to save and then submit annual plan for the UPCOMING FY. Please ensure all PLANNING information is entered into all tabs, and leadership has signed above, before saving and submitting.",null,null,"Click below to save and submit annual plan for the CURRENT FY. Please ensure all EVALUATION information is entered before saving and submitting."]
[]
[]
["  **Please save document as \"CommandName_HPplan_FYxx\""]

{"sheet":"JAN","index":2,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[20,10,21,10],[23,10,24,10],[26,10,27,10],[30,0,30,2],[102,0,102,2],[108,0,108,4],[91,0,91,2],[23,14,24,14],[23,12,24,12],[23,16,24,16],[23,18,24,18],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[5,2,6,2],[5,16,6,16],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,6,6,6],[5,10,6,10],[5,18,6,18],[5,20,6,20],[8,6,9,6],[8,12,9,12],[8,14,9,14],[8,16,9,16],[8,18,9,18],[8,20,9,20],[5,8,6,8],[5,12,6,12],[5,14,6,14],[8,10,9,10],[8,0,9,0],[11,6,12,6],[8,8,9,8],[11,12,12,12],[11,14,12,14],[8,2,9,2],[11,10,12,10],[11,16,12,16],[11,18,12,18],[11,20,12,20],[11,8,12,8],[11,0,12,0],[11,2,12,2],[17,20,18,20],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[17,8,18,8],[17,12,18,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[14,10,15,10],[17,10,18,10],[20,18,21,18],[20,20,21,20],[14,0,15,0],[14,2,15,2],[17,0,18,0],[17,2,18,2],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[20,14,21,14],[20,16,21,16],[14,18,15,18],[14,20,15,20],[17,6,18,6]]}
["January"]
["NMCPHC Monthly Health Observance: Healthy Weight"]
["Program Area(s): Weight Management"]
["HP Toolbox - Healthy Weight "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
["Blue-H Submissions due February 1, 2017",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"FEB","index":3,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10]]}
["February"]
["NMCPHC Monthly Health Observance: Heart Health"]
["Program Area(s): Nutrition, Physical Activity, Tobacco Use"]
["HP Toolbox - Heart Health "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"MAR","index":4,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10]]}
["March"]
["NMCPHC Monthly Health Observance: Healthy Eating"]
["Program Area(s): Nutrition"]
["HP Toolbox - Healthy Eating "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"APR","index":5,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["April"]
["NMCPHC Monthly Health Observance: Sexual Health"]
["Program Area(s): Sexual Health"]
["HP Toolbox - Sexual Health "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"MAY","index":6,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["May"]
["NMCPHC Monthly Health Observance: Physical Fitness"]
["Program Area(s): Physical Activity"]
["HP Toolbox - Physical Fitness "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"JUN","index":7,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["June"]
["NMCPHC Monthly Health Observance: Men's Health"]
["Program Area(s): Multiple Areas"]
["HP Toolbox - Men's Health "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
["Prepare and submit annual plan for next FY",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"JUL","index":8,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["July"]
["NMCPHC Monthly Health Observance: Safety"]
["Program Area(s): Injury Prevention/Safety"]
["HP Toolbox - Safety "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"AUG","index":9,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["August"]
["NMCPHC Monthly Health Observance: Preventive Health"]
["Program Area(s): Multiple Areas"]
["HP Toolbox - Preventive Health "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"SEP","index":10,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["September"]
["NMCPHC Monthly Health Observance: Mental Health and Suicide Prevention"]
["Program Area(s): Stress Management"]
["HP Toolbox - Mental Health and Suicide Prevention "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K17,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C105:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"OCT","index":11,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["October"]
["NMCPHC Monthly Health Observance: Women's Health"]
["Program Area(s): Multiple Areas"]
["HP Toolbox - Women's Health "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
["Complete and submit Annual Plan Evaluation for current FY",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E45=1, Q6, \"\")","v":""}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E51=1, Q9, \"\")","v":""}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"NOV","index":12,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["November"]
["NMCPHC Monthly Health Observance: Tobacco Free Living"]
["Program Area(s): Tobacco Use"]
["HP Toolbox - Tobacco Free Living"]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"DEC","index":13,"n_rows":114,"n_cols":21,"rows_kept":114,"cut":false,"hidden":false,"merged":[[8,10,9,10],[11,10,12,10],[14,10,15,10],[17,10,18,10],[20,10,21,10],[30,0,30,2],[91,0,91,2],[102,0,102,2],[108,0,108,4],[23,18,24,18],[23,12,24,12],[23,10,24,10],[26,10,27,10],[23,20,24,20],[26,0,27,0],[26,2,27,2],[26,6,27,6],[26,8,27,8],[26,12,27,12],[26,14,27,14],[26,16,27,16],[26,18,27,18],[26,20,27,20],[23,14,24,14],[23,16,24,16],[23,0,24,0],[23,2,24,2],[23,6,24,6],[23,8,24,8],[20,0,21,0],[20,2,21,2],[20,6,21,6],[20,8,21,8],[20,12,21,12],[17,14,18,14],[17,16,18,16],[17,18,18,18],[17,20,18,20],[20,16,21,16],[20,18,21,18],[20,20,21,20],[20,14,21,14],[17,0,18,0],[17,2,18,2],[17,6,18,6],[17,8,18,8],[17,12,18,12],[11,18,12,18],[11,20,12,20],[14,0,15,0],[14,2,15,2],[14,6,15,6],[14,8,15,8],[14,12,15,12],[14,14,15,14],[14,16,15,16],[14,18,15,18],[14,20,15,20],[8,16,9,16],[8,18,9,18],[8,20,9,20],[11,0,12,0],[11,2,12,2],[11,6,12,6],[11,8,12,8],[11,12,12,12],[11,14,12,14],[11,16,12,16],[8,0,9,0],[8,2,9,2],[8,6,9,6],[8,8,9,8],[8,12,9,12],[8,14,9,14],[5,20,6,20],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,0,6,0],[5,2,6,2],[5,6,6,6],[5,8,6,8],[5,12,6,12],[5,14,6,14],[5,16,6,16],[5,18,6,18],[5,10,6,10]]}
["December"]
["NMCPHC Monthly Health Observance: Impaired Driving Prevention"]
["Program Area(s): Alcohol Use"]
["HP Toolbox - Impaired Driving Prevention "]
["Activities",null,"Date to be Completed",null,"Which Goal(s) are fulfilled by this activity? \n(select all that apply)",null,"Programming Level",null,"What Resources are Required?\n(use hyperlinks to access resources)",null,"Cost",null,"Activity Lead",null,"Collaboration Partners ",null,"How effective was this activity?\n5-Very Effective \n1-Not Effective At All",null,"Did this activity \nmeet your expectations?\n5-Met  All Expectations\n1-Met No Expectations",null,"How likely are you to \ncomplete this activity again?\n5-Very Likely\n1-Not Likely At All"]
["Message for the Commanding Officer",null,"Week 1 of the month",null,null,null,null,null,"Commanding Officer Message"]
[]
[]
["Plan of the Week Activity - Week 1",null,"Week 1 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 2",null,"Week 2 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 3",null,"Week 3 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Plan of the Week Activity - Week 4",null,"Week 4 of the month",null,null,null,null,null,"Plan of the Week Notes"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[]
["Optional: enter additional local activities",null,"Optional: completion date",null,null,null,null,null,"Optional: enter required resources"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,K9,K12,K15,K18,K21,K24,K27)","v":0}]
[]
["End of Month Tasks"]
["Activities",null,"Date to be Completed"]
["Evaluate activities \n(columns O, Q, S)",null,"Week 4 of the month"]
["Download/print materials for next month",null,"Week 4 of the month"]
[]
[]
[]
[]
[]
[]
["CO Message",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C42, TRUE)","v":0},null,{"$f":"COUNTIFS(C42,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E42=1, Q6, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C43, TRUE)","v":0},null,{"$f":"COUNTIFS(C43,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E43=1, Q6, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C44, TRUE)","v":0},null,{"$f":"COUNTIFS(C44,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"IF(E44=1, Q6, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C45, TRUE)","v":0},null,{"$f":"COUNTIFS(C45,\"=TRUE\",C94,\"1\")","v":0},null,{"$f":"SUM(I42:I44)","v":0}]
[]
["POW Week1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C48, TRUE)","v":0},null,{"$f":"COUNTIFS(C48,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E48=1, Q9, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C49, TRUE)","v":0},null,{"$f":"COUNTIFS(C49,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E49=1, Q9, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C50, TRUE)","v":0},null,{"$f":"COUNTIFS(C50,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"IF(E50=1, Q9, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C51, TRUE)","v":0},null,{"$f":"COUNTIFS(C51,\"=TRUE\",C95,\"1\")","v":0},null,{"$f":"SUM(I48:I50)","v":0}]
[]
["POW Week2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C54, TRUE)","v":0},null,{"$f":"COUNTIFS(C54,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E54=1, Q12, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C55, TRUE)","v":0},null,{"$f":"COUNTIFS(C55,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E55=1, Q12, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C56, TRUE)","v":0},null,{"$f":"COUNTIFS(C56,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E56=1, Q12, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C57, TRUE)","v":0},null,{"$f":"COUNTIFS(C57,\"=TRUE\",C96,\"1\")","v":0},null,{"$f":"IF(E57=1, Q12, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0}]
[]
["POW Week3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C61, TRUE)","v":0},null,{"$f":"COUNTIFS(C61,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E61=1, Q15, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C62, TRUE)","v":0},null,{"$f":"COUNTIFS(C62,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E62=1, Q15, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C63, TRUE)","v":0},null,{"$f":"COUNTIFS(C63,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E63=1, Q15, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C64, TRUE)","v":0},null,{"$f":"COUNTIFS(C64,\"=TRUE\",C97,\"1\")","v":0},null,{"$f":"IF(E64=1, Q15, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I61:I64)","v":0}]
[]
["POW Week4",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C68, TRUE)","v":0},null,{"$f":"COUNTIFS(C68,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E68=1, Q18, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C69, TRUE)","v":0},null,{"$f":"COUNTIFS(C69,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E69=1, Q18, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C70, TRUE)","v":0},null,{"$f":"COUNTIFS(C70,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E70=1, Q18, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C71, TRUE)","v":0},null,{"$f":"COUNTIFS(C71,\"=TRUE\",C98,\"1\")","v":0},null,{"$f":"IF(E71=1, Q18, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I68:J71)","v":0}]
[]
["Extra Activity #1",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C75, TRUE)","v":0},null,{"$f":"COUNTIFS(C75,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E75=1, Q21, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C76, TRUE)","v":0},null,{"$f":"COUNTIFS(C76,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E76=1, Q21, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C77, TRUE)","v":0},null,{"$f":"COUNTIFS(C77,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E77=1, Q21, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C78, TRUE)","v":0},null,{"$f":"COUNTIFS(C78,\"=TRUE\",C99,\"1\")","v":0},null,{"$f":"IF(E78=1, Q21, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:I78)","v":0}]
["Extra Activity #2",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C81, TRUE)","v":0},null,{"$f":"COUNTIFS(C81,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E81=1, Q24, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C82, TRUE)","v":0},null,{"$f":"COUNTIFS(C82,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E82=1, Q24, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C83, TRUE)","v":0},null,{"$f":"COUNTIFS(C83,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E83=1, Q24, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C84, TRUE)","v":0},null,{"$f":"COUNTIFS(C84,\"=TRUE\",C100,\"1\")","v":0},null,{"$f":"IF(E84=1, Q24, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I81:I84)","v":0}]
["Extra Activity #3",null,"TRUE=Goal is selected\nFALSE=Goal is not selected",null,"1=Goal is selected\n0=Goal is not selected",null,"1=Goal is selected AND the Activity is Effective\n0=Meets none or only one of the above criteria",null,"Effectiveness"]
["Goal #1",null,false,null,{"$f":"COUNTIF(C87, TRUE)","v":0},null,{"$f":"COUNTIFS(C87,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E87=1, Q27, \"\")","v":""}]
["Goal #2",null,false,null,{"$f":"COUNTIF(C88, TRUE)","v":0},null,{"$f":"COUNTIFS(C88,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E88=1, Q27, \"\")","v":""}]
["Goal #3",null,false,null,{"$f":"COUNTIF(C89, TRUE)","v":0},null,{"$f":"COUNTIFS(C89,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E89=1, Q27, \"\")","v":""}]
["Goal #4",null,false,null,{"$f":"COUNTIF(C90, TRUE)","v":0},null,{"$f":"COUNTIFS(C90,\"=TRUE\",C101,\"1\")","v":0},null,{"$f":"IF(E90=1, Q27, \"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
["Activity Effectiveness"]
["Activity",null,"1=Activity was successful (rated 4 or 5)\n0=Activity was not completed or rated less than 3 or below"]
["CO Message",null,{"$f":"SUM(COUNTIFS(Q6,{\"3\",\"4\",\"5\"}))","v":0}]
["POW 1",null,{"$f":"SUM(COUNTIFS(Q9,{\"3\",\"4\",\"5\"}))","v":0}]
["POW2",null,{"$f":"SUM(COUNTIFS(Q12,{\"3\",\"4\",\"5\"}))","v":0}]
["POW3",null,{"$f":"SUM(COUNTIFS(Q15,{\"3\",\"4\",\"5\"}))","v":0}]
["POW4",null,{"$f":"SUM(COUNTIFS(Q18,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #1",null,{"$f":"SUM(COUNTIFS(Q21,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #2",null,{"$f":"SUM(COUNTIFS(Q24,{\"3\",\"4\",\"5\"}))","v":0}]
["Extra Activity #3",null,{"$f":"SUM(COUNTIFS(Q27,{\"3\",\"4\",\"5\"}))","v":0}]
[]
["Effectiveness"]
["# of activities rated 3",null,{"$f":"COUNTIF(Q6:Q28,3 )","v":0}]
["# of activities rated 4",null,{"$f":"COUNTIF(Q6:Q28,4 )","v":0}]
["# of activities rated 5",null,{"$f":"COUNTIF(Q6:Q28,\"5\")","v":0}]
["Total",null,{"$f":"SUM(C104:C106)","v":0}]
[]
["Goal Totals"]
["Goal Name:",null,"The # of activities fulfilling each goal",null,"The # of successful activities for each Goal",null,"Average Montly Activity Effectiveness for each goal",null,"Sum of Monthly Activity Effectiveness for each goal"]
["Goal #1",null,{"$f":"E42+E48+E54+E61+E68+E75+E81+E87","v":0},null,{"$f":"G42+G48+G54+G61+G68+G75+G81+G87","v":0},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))/C111","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E42, \"1\", I42))+(SUMIF(E48, \"1\", I48))+(SUMIF(E54, \"1\", I54))+(SUMIF(E61, \"1\", I61))+(SUMIF(E68, \"1\", I68))+(SUMIF(E75, \"1\", I75))+(SUMIF(E81, \"1\", I81))+(SUMIF(E87, \"1\", I87)))","v":0}]
["Goal #2",null,{"$f":"E43+E49+E55+E62+E69+E76+E82+E88","v":0},null,{"$f":"G43+G49+G55+G62+G69+G76+G82+G88","v":0},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))/C112","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E43, \"1\", I43))+(SUMIF(E49, \"1\", I49))+(SUMIF(E55, \"1\", I55))+(SUMIF(E62, \"1\", I62))+(SUMIF(E69, \"1\", I69))+(SUMIF(E76, \"1\", I76))+(SUMIF(E82, \"1\", I82))+(SUMIF(E88, \"1\", I88)))","v":0}]
["Goal #3",null,{"$f":"E44+E50+E56+E63+E70+E77+E83+E89","v":0},null,{"$f":"G44+G50+G56+G63+G70+G77+G83+G89","v":0},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))/C113","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E44, \"1\", I44))+(SUMIF(E50, \"1\", I50))+(SUMIF(E56, \"1\", I56))+(SUMIF(E63, \"1\", I63))+(SUMIF(E70, \"1\", I70))+(SUMIF(E77, \"1\", I77))+(SUMIF(E83, \"1\", I83))+(SUMIF(E89, \"1\", I89)))","v":0}]
["Goal #4",null,{"$f":"E45+E51+E57+E64+E71+E78+E84+E90","v":0},null,{"$f":"G45+G51+G57+G64+G71+G78+G84+G90","v":0},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))/C114","v":{"$error":"#DIV/0!"}},null,{"$f":"((SUMIF(E45, \"1\", I45))+(SUMIF(E51, \"1\", I51))+(SUMIF(E57, \"1\", I57))+(SUMIF(E64, \"1\", I64))+(SUMIF(E71, \"1\", I71))+(SUMIF(E78, \"1\", I78))+(SUMIF(E84, \"1\", I84))+(SUMIF(E90, \"1\", I90)))","v":0}]

{"sheet":"Medical HP Budget Submission","index":14,"n_rows":19,"n_cols":44,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,4,3,7],[3,9,3,11],[4,4,6,7],[8,4,8,7],[9,4,12,7]]}
["Location Name","Location Type","Region",null,"Q1 \nCivilian Personnel Budget","Q1 \nTravel Budget","Q1 \nComms and Marketing Budget","Q1 \nSupplies Budget","Q1 \nPrinting Budget","Q1 \nOther Transportation Budget","Q1 \nPharmaceutical Budget","Q1 \nEquipment Budget","Q1 \nEquipment Maintenance Budget","Q1 \nOther Contracts Budget","Q2 \nCivilian Personnel Budget","Q2 \nTravel Budget","Q2 \nComms and Marketing Budget","Q2 \nSupplies Budget","Q2 \nPrinting Budget","Q2 \nOther Transportation Budget","Q2 \nPharmaceutical Budget","Q2 \nEquipment Budget","Q2 \nEquipment Maintenance Budget","Q2 \nOther Contracts Budget","Q3 \nCivilian Personnel Budget","Q3 \nTravel Budget","Q3 \nComms and Marketing Budget","Q3 \nSupplies Budget","Q3 \nPrinting Budget","Q3 \nOther Transportation Budget","Q3 \nPharmaceutical Budget","Q3 \nEquipment Budget","Q3 \nEquipment Maintenance Budget","Q3 \nOther Contracts Budget","Q4 \nCivilian Personnel Budget","Q4 \nTravel Budget","Q4 \nComms and Marketing Budget","Q4 \nSupplies Budget","Q4 \nPrinting Budget","Q4 \nOther Transportation Budget","Q4 \nPharmaceutical Budget","Q4 \nEquipment Budget","Q4 \nEquipment Maintenance Budget","Q4 \nOther Contracts Budget"]
[{"$f":"A5","v":0},{"$f":"B5","v":0},{"$f":"C5","v":0},null,{"$f":"B10","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Travel\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Comms and Marketing\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Supplies\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Printing\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Transportation Costs\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Pharmaceutical\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment Maintenance\", Table3[Quarter], \"Q1\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Contracts\", Table3[Quarter], \"Q1\")","v":0},{"$f":"B11","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Travel\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Comms and Marketing\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Supplies\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Printing\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Transportation Costs\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Pharmaceutical\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment Maintenance\", Table3[Quarter], \"Q2\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Contracts\", Table3[Quarter], \"Q2\")","v":0},{"$f":"B12","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Travel\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Comms and Marketing\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Supplies\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Printing\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Transportation Costs\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Pharmaceutical\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment Maintenance\", Table3[Quarter], \"Q3\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Contracts\", Table3[Quarter], \"Q3\")","v":0},{"$f":"B13","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Travel\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Comms and Marketing\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Supplies\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Printing\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Transportation Costs\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Pharmaceutical\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Equipment Maintenance\", Table3[Quarter], \"Q4\")","v":0},{"$f":"SUMIFS(Table3[Cost], Table3[Category], \"Other Contracts\", Table3[Quarter], \"Q4\")","v":0}]
[]
["Location Name","Location Type","Region",null," HQ Instructions"]
[null,null,null,null,"1.  Unhide rows 1 and 2 (if hidden)\n2. Highlight and Copy data from row 2\n3. Paste the data into the appropriate cells in the MTF HPW Budget Tracking Tool"]
[]
[]
[]
["Total Civilian Personnel Budget ",{"$f":"SUM(B10:B13)","v":0},null,null,"MTF Instructions"]
["Q1",null,null,null,"1. Please complete all applicable cells/rows highlighted in yellow\n2. Please disregard the hidden values in rows 1 and 2 - these a preformatted and will be used to compile all MTF submissions"]
["Q2"]
["Q3"]
["Q4"]
[]
["Activity / Resource / Budget Line Item","Category","Cost","Quarter","Description",null,"Q1 Total",{"$f":"SUMIFS(Table3[Cost], Table3[Quarter], \"Q1\")+B10","v":0}]
["Example - Imaginary Supplies","Supplies",0,"Q1","Include a description of the item here, if necessary",null,"Q2 Total",{"$f":"SUMIFS(Table3[Cost], Table3[Quarter], \"Q2\")+B11","v":0}]
[null,null,null,null,null,null,"Q3 Total",{"$f":"SUMIFS(Table3[Cost], Table3[Quarter], \"Q3\")+B12","v":0}]
[null,null,null,null,null,null,"Q4 Total",{"$f":"SUMIFS(Table3[Cost], Table3[Quarter], \"Q4\")+B13","v":0}]
[null,null,null,null,null,null,"FY Total",{"$f":"SUM(Table3[Cost])+B9","v":0}]

{"sheet":"Free Resources","index":15,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Free HP Resources"]
["Agency","Topic","Available Resources","How to Order","Notes"]
["Human Performance Resource Center","Dietary Supplements","Operation Supplement Safety (OPSS) promotional  items (table tents, brochures, info sheets, posters, , 5 X 7 post cards, stickers and pens","http://hprc-online.org/dietary-supplements/opss/operation-supplement-safety-OPSS/copy2_of_apps-videos"]
["Human Performance Resource Center","Healthy food choices in galleys using the stop light system","Go for Green® promotional items (posters and table tents  for general G4G topics as well as specific ones for each branch of service,  sheets of stickers formatted for Avery sheets","http://hprc-online.org/nutrition/go-for-green/copy_of_about-go-for-green"]
["Navy Logistics Library","Alcohol and Drug Abuse Prevention","Pamphlets, posters, banners, table tents and fact sheets","https://nll2.ahf.nmci.navy.mil/default.cfm","Materials and items that support NADAP Campaigns:  Prescription for Discharge, Keep What You’ve Earned, The Domino Strategy on How to Drink Responsibly, and Who Will Stand Your Watch?\n\nCommand must have an account and SAAR-N to get into this website to order materials for each campaign. To find out more, go to: \nhttps://nll2.ahf.nmci.navy.mil/web/includes/public/SAAR.cfm"]
["DoD’s That Guy Campaign","Alcohol Abuse Prevention","Posters, coasters, playing cards, static window clings, magnets, air fresheners, key chains, temporary tattoos, stickers, table tents and cartoon booklets","http://resources.thatguy.com/promo-items","\nCommand must have an account and SAAR-N to get into this website to order materials for each campaign. To find out more, go to: \nhttps://nll2.ahf.nmci.navy.mil/web/includes/public/SAAR.cfm"]
["National Institute on Alcohol Abuse and Alcoholism","Alcohol Abuse Prevention","Pamphlets, brochures and fact sheets, such as “Rethinking Drinking”","http://www.niaaa.nih.gov/publications/brochures-and-fact-sheets"]
["Military OneSource","Military OneSource","Items that promote Military OneSource: Banners, belt clips, key chains, magnets, mouse pads, pens, pocket folders, scratch pads, books, booklets, CDs and DVDs","https://www.militaryonesource.mil/products"]
["Naval Safety Center","Safety","Magazines and posters on various safety topics","http://www.public.navy.mil/navsafecen/Pages/index.aspx "]
["After Deployment","PTSD","Promotional Kits for either National PTSD Awareness Day (June 27th), which includes magnets, wallet cards, posters, gym towels and more and PTSD Promotional Kit, which includes gym towels, wallet cards, magnets, posters and brochures.","http://afterdeployment.dcoe.mil/military_pathways","*Each kit contains enough materials for 250-300 people"]
["Quit Tobacco-uCanQuit2.org","Tobacco Cessation","Posters for each branch of service, pedometers, playing cards, pens, stress balls (black and red), dental floss, folding water bottles, key chains, note pads, post-it notes, scratch and sniff postcards, sugar free gum and mints, table tents, plastic bags, Tricky Triangle (peg-style checkers), window clings","https://www.ucanquit2.org/Partners/OrderMaterials.aspx"]
["Smokefree.gov","Tobacco Cessation","Brochures, fact sheets and guides to help tobacco users become tobacco-free","http://smokefree.gov/free-resources"]
["Centers for Disease Control & Prevention (CDC)","Tobacco Cessation","1-800-QUIT-NOW 20-sheet notepads for Health Care Providers and Counselors to write notes and instructions for smoking patients","http://nccd.cdc.gov/OSH_Pub_Catalog/SearchResults.aspx","Limit of 30 notepads per order"]

{"sheet":"Formulas","index":16,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Command Type","Branch","Blue-H Level","Smart Goals","Program Areas","Check box selection,  LINKED cell","Toolbox","Command Priority Areas (multiple areas)","Programming Levels","How effective was this activity?","Did the activity meet your expectations?","How likely are you to complete this activity again?"]
[]
["Medical Active","Air Force","Bronze Anchor","Yes","Alcohol Use",false,"Conduct HP Toolbox activities","Yes","Awareness",1,1,1]
["Medical Reserve","Army","Silver Eagle","No","Injury Prevention/Safety",false,"Conduct HP Toolbox activities, plus other activities","No","Education/Motivation",2,2,2]
["Non-Medical Active & Non-Medical Reserve","Coast Guard","Gold Star",null,"Nutrition",false,"Will not conduct HP Toolbox activities",null,"Intervention",3,3,3]
[null,"Marines",null,null,"Physical Activity",false,null,null,null,4,4,4]
[null,"Navy",null,null,"Sexual Health",false,null,null,null,5,5,5]
[null,null,null,null,"Stress Management",false]
[null,null,null,null,"Tobacco Use",false]
[null,null,null,null,"Weight Management",false]
[null,null,null,null,"Sleep ",false]

{"sheet":"Stakeholder Data Call","index":17,"n_rows":5,"n_cols":22,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,1,21],[2,0,3,4],[2,6,3,13],[2,14,3,18],[2,19,2,21],[3,19,3,21]]}
["HPW Stakeholder Data Call "]
[]
["Personal Information ",null,null,null,null,null,"Workplace Information",null,null,null,null,null,null,null,"Job Information ",null,null,null,null,"Training Information  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicate training completion dates:  mm/dd/yyyy"]
["First Name:","  Last Name:","Affiliation / Status: \n(Drop-down)    ","Rate/Rank:\n(Drop-down)","Service:\n(Drop-down)     ","Region ","Command: ","Homeport / Work Address:","City:","State:\n(Drop-down)     ","Country/Territory:","  Zip Code:","Primary Email Address:","Phone Number:","I am aligned to:\n(Drop-down)","Health Promotion is my:\n(Drop-down)","HPW Role:\n(Drop-down)","Tobacco Cessation Role:\n(Drop-down)","ShipShape Role:\n(Drop-down)","HP Advanced:","Tobacco Cessation:","ShipShape:"]

{"sheet":"Data Validation","index":18,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
["Location Type","Region","FY","Budget Category","Quarter"]
["Medical Center","East","FY15","Travel","Q1"]
["Hospital","West","FY16","Comms and Marketing","Q2"]
["Clinic","BUMED","FY17","Supplies","Q3"]
[null,null,"FY18","Printing","Q4"]
[null,null,"FY19","Other Transportation Costs"]
[null,null,"FY20","Pharmaceutical"]
[null,null,null,"Equipment"]
[null,null,null,"Equipment Maintenance"]
[null,null,null,"Other Contracts"]
[]
[]
["Affiliation/Status ","Service ","Alignment ","Health Promotion ","Funding Question ","HPW Role","Tob Role","SS Role"]
["Active Duty ","Navy ","Navy Medicine ","Primary Duty ","Yes ","Coordinator","Champion","Facilitator"]
["Reserve ","Marine Corps ","SemperFit ","Collateral Duty ","No ","Director","Facilitator","Program Manager"]
["Civilian ","Air Force ","Other DON Command ",null,null,"N/A","N/A","N/A"]
["Contractor ","Army "]
[null,"Coast Guard ",null,"States "]
["Rate/Rank ","Other ",null,"Alabama"]
["E-1",null,null,"Alaska"]
["E-2",null,null,"Arizona"]
["E-3","Region",null,"Arkansas"]
["E-4","East",null,"California"]
["E-5","West",null,"Colorado"]
["E-6","NMETLC",null,"Connecticut"]
["E-7",null,null,"Delaware"]
["E-8",null,null,"Florida"]
["E-9",null,null,"Georgia"]
["O-1",null,null,"Hawaii"]
["O-2",null,null,"Idaho"]
["O-3",null,null,"Illinois"]
["O-4",null,null,"Indiana"]
["O-5",null,null,"Iowa"]
["O-6",null,null,"Kansas"]
["O-7",null,null,"Kentucky"]
["O-8",null,null,"Louisiana"]
["O-9",null,null,"Maine"]
["GS-5",null,null,"Maryland"]
["GS-6",null,null,"Massachusetts"]
["GS-7",null,null,"Michigan"]
["GS-8",null,null,"Minnesota"]
["GS-9",null,null,"Mississippi"]
["GS-10",null,null,"Missouri"]
["GS-11",null,null,"Montana"]
["GS-12",null,null,"Nebraska"]
["GS-13",null,null,"Nevada"]
["GS-14",null,null,"New Hampshire"]
["GS-15",null,null,"New Jersey"]
["Other ",null,null,"New Mexico"]
[null,null,null,"New York"]
[null,null,null,"North Carolina"]
[null,null,null,"North Dakota"]
[null,null,null,"Ohio"]
[null,null,null,"Oklahoma"]
[null,null,null,"Oregon"]
[null,null,null,"Pennsylvania"]
[null,null,null,"Rhode Island"]
[null,null,null,"South Carolina"]
[null,null,null,"South Dakota"]
[null,null,null,"Tennessee"]
[null,null,null,"Texas"]
[null,null,null,"Utah"]
[null,null,null,"Vermont"]
[null,null,null,"Virginia"]
[null,null,null,"Washington"]
[null,null,null,"West Virginia"]
[null,null,null,"Wisconsin"]
[null,null,null,"Wyoming"]

{"sheet":"Database Link","index":19,"n_rows":16,"n_cols":32,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Primary Email Address","First Name","Last Name","Affiliation/Status","Rate/Rank","Service","Region","Command","Homeport/Work Address","City","State","Country","Zip Code","Phone Number","Alignment ","Health Promotion is my ","HPW Role ","Tobacco Cessation Role ","ShipShape Role ","Funding","NMCPHC Funded?","HP Advanced Training ","HP Pre Req (Y/N)","HP Pre Req (Date)","Tobacco Cessation Training ","Tob Pre Req (Y/N)","Tob Pre Req (Date)","ShipShape Training ","SS Pre Req (Y/N)","SS Pre Req (Date)","Welcome Comms ","Funding Comms "]
[{"$f":"'Stakeholder Data Call'!M6","v":0},{"$f":"'Stakeholder Data Call'!A6","v":0},{"$f":"'Stakeholder Data Call'!B6","v":0},{"$f":"'Stakeholder Data Call'!C6","v":0},{"$f":"'Stakeholder Data Call'!D6","v":0},{"$f":"'Stakeholder Data Call'!E6","v":0},{"$f":"'Stakeholder Data Call'!F6","v":0},{"$f":"'Stakeholder Data Call'!G6","v":0},{"$f":"'Stakeholder Data Call'!H6","v":0},{"$f":"'Stakeholder Data Call'!I6","v":0},{"$f":"'Stakeholder Data Call'!J6","v":0},{"$f":"'Stakeholder Data Call'!K6","v":0},{"$f":"'Stakeholder Data Call'!L6","v":0},{"$f":"'Stakeholder Data Call'!N6","v":0},{"$f":"'Stakeholder Data Call'!O6","v":0},{"$f":"'Stakeholder Data Call'!P6","v":0},{"$f":"'Stakeholder Data Call'!Q6","v":0},{"$f":"'Stakeholder Data Call'!R6","v":0},{"$f":"'Stakeholder Data Call'!S6","v":0},null,null,{"$f":"'Stakeholder Data Call'!T6","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U6","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V6","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M7","v":0},{"$f":"'Stakeholder Data Call'!A7","v":0},{"$f":"'Stakeholder Data Call'!B7","v":0},{"$f":"'Stakeholder Data Call'!C7","v":0},{"$f":"'Stakeholder Data Call'!D7","v":0},{"$f":"'Stakeholder Data Call'!E7","v":0},{"$f":"'Stakeholder Data Call'!F7","v":0},{"$f":"'Stakeholder Data Call'!G7","v":0},{"$f":"'Stakeholder Data Call'!H7","v":0},{"$f":"'Stakeholder Data Call'!I7","v":0},{"$f":"'Stakeholder Data Call'!J7","v":0},{"$f":"'Stakeholder Data Call'!K7","v":0},{"$f":"'Stakeholder Data Call'!L7","v":0},{"$f":"'Stakeholder Data Call'!N7","v":0},{"$f":"'Stakeholder Data Call'!O7","v":0},{"$f":"'Stakeholder Data Call'!P7","v":0},{"$f":"'Stakeholder Data Call'!Q7","v":0},{"$f":"'Stakeholder Data Call'!R7","v":0},{"$f":"'Stakeholder Data Call'!S7","v":0},null,null,{"$f":"'Stakeholder Data Call'!T7","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U7","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V7","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M8","v":0},{"$f":"'Stakeholder Data Call'!A8","v":0},{"$f":"'Stakeholder Data Call'!B8","v":0},{"$f":"'Stakeholder Data Call'!C8","v":0},{"$f":"'Stakeholder Data Call'!D8","v":0},{"$f":"'Stakeholder Data Call'!E8","v":0},{"$f":"'Stakeholder Data Call'!F8","v":0},{"$f":"'Stakeholder Data Call'!G8","v":0},{"$f":"'Stakeholder Data Call'!H8","v":0},{"$f":"'Stakeholder Data Call'!I8","v":0},{"$f":"'Stakeholder Data Call'!J8","v":0},{"$f":"'Stakeholder Data Call'!K8","v":0},{"$f":"'Stakeholder Data Call'!L8","v":0},{"$f":"'Stakeholder Data Call'!N8","v":0},{"$f":"'Stakeholder Data Call'!O8","v":0},{"$f":"'Stakeholder Data Call'!P8","v":0},{"$f":"'Stakeholder Data Call'!Q8","v":0},{"$f":"'Stakeholder Data Call'!R8","v":0},{"$f":"'Stakeholder Data Call'!S8","v":0},null,null,{"$f":"'Stakeholder Data Call'!T8","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U8","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V8","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M9","v":0},{"$f":"'Stakeholder Data Call'!A9","v":0},{"$f":"'Stakeholder Data Call'!B9","v":0},{"$f":"'Stakeholder Data Call'!C9","v":0},{"$f":"'Stakeholder Data Call'!D9","v":0},{"$f":"'Stakeholder Data Call'!E9","v":0},{"$f":"'Stakeholder Data Call'!F9","v":0},{"$f":"'Stakeholder Data Call'!G9","v":0},{"$f":"'Stakeholder Data Call'!H9","v":0},{"$f":"'Stakeholder Data Call'!I9","v":0},{"$f":"'Stakeholder Data Call'!J9","v":0},{"$f":"'Stakeholder Data Call'!K9","v":0},{"$f":"'Stakeholder Data Call'!L9","v":0},{"$f":"'Stakeholder Data Call'!N9","v":0},{"$f":"'Stakeholder Data Call'!O9","v":0},{"$f":"'Stakeholder Data Call'!P9","v":0},{"$f":"'Stakeholder Data Call'!Q9","v":0},{"$f":"'Stakeholder Data Call'!R9","v":0},{"$f":"'Stakeholder Data Call'!S9","v":0},null,null,{"$f":"'Stakeholder Data Call'!T9","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U9","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V9","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M10","v":0},{"$f":"'Stakeholder Data Call'!A10","v":0},{"$f":"'Stakeholder Data Call'!B10","v":0},{"$f":"'Stakeholder Data Call'!C10","v":0},{"$f":"'Stakeholder Data Call'!D10","v":0},{"$f":"'Stakeholder Data Call'!E10","v":0},{"$f":"'Stakeholder Data Call'!F10","v":0},{"$f":"'Stakeholder Data Call'!G10","v":0},{"$f":"'Stakeholder Data Call'!H10","v":0},{"$f":"'Stakeholder Data Call'!I10","v":0},{"$f":"'Stakeholder Data Call'!J10","v":0},{"$f":"'Stakeholder Data Call'!K10","v":0},{"$f":"'Stakeholder Data Call'!L10","v":0},{"$f":"'Stakeholder Data Call'!N10","v":0},{"$f":"'Stakeholder Data Call'!O10","v":0},{"$f":"'Stakeholder Data Call'!P10","v":0},{"$f":"'Stakeholder Data Call'!Q10","v":0},{"$f":"'Stakeholder Data Call'!R10","v":0},{"$f":"'Stakeholder Data Call'!S10","v":0},null,null,{"$f":"'Stakeholder Data Call'!T10","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U10","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V10","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M11","v":0},{"$f":"'Stakeholder Data Call'!A11","v":0},{"$f":"'Stakeholder Data Call'!B11","v":0},{"$f":"'Stakeholder Data Call'!C11","v":0},{"$f":"'Stakeholder Data Call'!D11","v":0},{"$f":"'Stakeholder Data Call'!E11","v":0},{"$f":"'Stakeholder Data Call'!F11","v":0},{"$f":"'Stakeholder Data Call'!G11","v":0},{"$f":"'Stakeholder Data Call'!H11","v":0},{"$f":"'Stakeholder Data Call'!I11","v":0},{"$f":"'Stakeholder Data Call'!J11","v":0},{"$f":"'Stakeholder Data Call'!K11","v":0},{"$f":"'Stakeholder Data Call'!L11","v":0},{"$f":"'Stakeholder Data Call'!N11","v":0},{"$f":"'Stakeholder Data Call'!O11","v":0},{"$f":"'Stakeholder Data Call'!P11","v":0},{"$f":"'Stakeholder Data Call'!Q11","v":0},{"$f":"'Stakeholder Data Call'!R11","v":0},{"$f":"'Stakeholder Data Call'!S11","v":0},null,null,{"$f":"'Stakeholder Data Call'!T11","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U11","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V11","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M12","v":0},{"$f":"'Stakeholder Data Call'!A12","v":0},{"$f":"'Stakeholder Data Call'!B12","v":0},{"$f":"'Stakeholder Data Call'!C12","v":0},{"$f":"'Stakeholder Data Call'!D12","v":0},{"$f":"'Stakeholder Data Call'!E12","v":0},{"$f":"'Stakeholder Data Call'!F12","v":0},{"$f":"'Stakeholder Data Call'!G12","v":0},{"$f":"'Stakeholder Data Call'!H12","v":0},{"$f":"'Stakeholder Data Call'!I12","v":0},{"$f":"'Stakeholder Data Call'!J12","v":0},{"$f":"'Stakeholder Data Call'!K12","v":0},{"$f":"'Stakeholder Data Call'!L12","v":0},{"$f":"'Stakeholder Data Call'!N12","v":0},{"$f":"'Stakeholder Data Call'!O12","v":0},{"$f":"'Stakeholder Data Call'!P12","v":0},{"$f":"'Stakeholder Data Call'!Q12","v":0},{"$f":"'Stakeholder Data Call'!R12","v":0},{"$f":"'Stakeholder Data Call'!S12","v":0},null,null,{"$f":"'Stakeholder Data Call'!T12","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U12","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V12","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M13","v":0},{"$f":"'Stakeholder Data Call'!A13","v":0},{"$f":"'Stakeholder Data Call'!B13","v":0},{"$f":"'Stakeholder Data Call'!C13","v":0},{"$f":"'Stakeholder Data Call'!D13","v":0},{"$f":"'Stakeholder Data Call'!E13","v":0},{"$f":"'Stakeholder Data Call'!F13","v":0},{"$f":"'Stakeholder Data Call'!G13","v":0},{"$f":"'Stakeholder Data Call'!H13","v":0},{"$f":"'Stakeholder Data Call'!I13","v":0},{"$f":"'Stakeholder Data Call'!J13","v":0},{"$f":"'Stakeholder Data Call'!K13","v":0},{"$f":"'Stakeholder Data Call'!L13","v":0},{"$f":"'Stakeholder Data Call'!N13","v":0},{"$f":"'Stakeholder Data Call'!O13","v":0},{"$f":"'Stakeholder Data Call'!P13","v":0},{"$f":"'Stakeholder Data Call'!Q13","v":0},{"$f":"'Stakeholder Data Call'!R13","v":0},{"$f":"'Stakeholder Data Call'!S13","v":0},null,null,{"$f":"'Stakeholder Data Call'!T13","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U13","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V13","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M14","v":0},{"$f":"'Stakeholder Data Call'!A14","v":0},{"$f":"'Stakeholder Data Call'!B14","v":0},{"$f":"'Stakeholder Data Call'!C14","v":0},{"$f":"'Stakeholder Data Call'!D14","v":0},{"$f":"'Stakeholder Data Call'!E14","v":0},{"$f":"'Stakeholder Data Call'!F14","v":0},{"$f":"'Stakeholder Data Call'!G14","v":0},{"$f":"'Stakeholder Data Call'!H14","v":0},{"$f":"'Stakeholder Data Call'!I14","v":0},{"$f":"'Stakeholder Data Call'!J14","v":0},{"$f":"'Stakeholder Data Call'!K14","v":0},{"$f":"'Stakeholder Data Call'!L14","v":0},{"$f":"'Stakeholder Data Call'!N14","v":0},{"$f":"'Stakeholder Data Call'!O14","v":0},{"$f":"'Stakeholder Data Call'!P14","v":0},{"$f":"'Stakeholder Data Call'!Q14","v":0},{"$f":"'Stakeholder Data Call'!R14","v":0},{"$f":"'Stakeholder Data Call'!S14","v":0},null,null,{"$f":"'Stakeholder Data Call'!T14","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U14","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V14","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M15","v":0},{"$f":"'Stakeholder Data Call'!A15","v":0},{"$f":"'Stakeholder Data Call'!B15","v":0},{"$f":"'Stakeholder Data Call'!C15","v":0},{"$f":"'Stakeholder Data Call'!D15","v":0},{"$f":"'Stakeholder Data Call'!E15","v":0},{"$f":"'Stakeholder Data Call'!F15","v":0},{"$f":"'Stakeholder Data Call'!G15","v":0},{"$f":"'Stakeholder Data Call'!H15","v":0},{"$f":"'Stakeholder Data Call'!I15","v":0},{"$f":"'Stakeholder Data Call'!J15","v":0},{"$f":"'Stakeholder Data Call'!K15","v":0},{"$f":"'Stakeholder Data Call'!L15","v":0},{"$f":"'Stakeholder Data Call'!N15","v":0},{"$f":"'Stakeholder Data Call'!O15","v":0},{"$f":"'Stakeholder Data Call'!P15","v":0},{"$f":"'Stakeholder Data Call'!Q15","v":0},{"$f":"'Stakeholder Data Call'!R15","v":0},{"$f":"'Stakeholder Data Call'!S15","v":0},null,null,{"$f":"'Stakeholder Data Call'!T15","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U15","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V15","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M16","v":0},{"$f":"'Stakeholder Data Call'!A16","v":0},{"$f":"'Stakeholder Data Call'!B16","v":0},{"$f":"'Stakeholder Data Call'!C16","v":0},{"$f":"'Stakeholder Data Call'!D16","v":0},{"$f":"'Stakeholder Data Call'!E16","v":0},{"$f":"'Stakeholder Data Call'!F16","v":0},{"$f":"'Stakeholder Data Call'!G16","v":0},{"$f":"'Stakeholder Data Call'!H16","v":0},{"$f":"'Stakeholder Data Call'!I16","v":0},{"$f":"'Stakeholder Data Call'!J16","v":0},{"$f":"'Stakeholder Data Call'!K16","v":0},{"$f":"'Stakeholder Data Call'!L16","v":0},{"$f":"'Stakeholder Data Call'!N16","v":0},{"$f":"'Stakeholder Data Call'!O16","v":0},{"$f":"'Stakeholder Data Call'!P16","v":0},{"$f":"'Stakeholder Data Call'!Q16","v":0},{"$f":"'Stakeholder Data Call'!R16","v":0},{"$f":"'Stakeholder Data Call'!S16","v":0},null,null,{"$f":"'Stakeholder Data Call'!T16","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U16","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V16","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M17","v":0},{"$f":"'Stakeholder Data Call'!A17","v":0},{"$f":"'Stakeholder Data Call'!B17","v":0},{"$f":"'Stakeholder Data Call'!C17","v":0},{"$f":"'Stakeholder Data Call'!D17","v":0},{"$f":"'Stakeholder Data Call'!E17","v":0},{"$f":"'Stakeholder Data Call'!F17","v":0},{"$f":"'Stakeholder Data Call'!G17","v":0},{"$f":"'Stakeholder Data Call'!H17","v":0},{"$f":"'Stakeholder Data Call'!I17","v":0},{"$f":"'Stakeholder Data Call'!J17","v":0},{"$f":"'Stakeholder Data Call'!K17","v":0},{"$f":"'Stakeholder Data Call'!L17","v":0},{"$f":"'Stakeholder Data Call'!N17","v":0},{"$f":"'Stakeholder Data Call'!O17","v":0},{"$f":"'Stakeholder Data Call'!P17","v":0},{"$f":"'Stakeholder Data Call'!Q17","v":0},{"$f":"'Stakeholder Data Call'!R17","v":0},{"$f":"'Stakeholder Data Call'!S17","v":0},null,null,{"$f":"'Stakeholder Data Call'!T17","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U17","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V17","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M18","v":0},{"$f":"'Stakeholder Data Call'!A18","v":0},{"$f":"'Stakeholder Data Call'!B18","v":0},{"$f":"'Stakeholder Data Call'!C18","v":0},{"$f":"'Stakeholder Data Call'!D18","v":0},{"$f":"'Stakeholder Data Call'!E18","v":0},{"$f":"'Stakeholder Data Call'!F18","v":0},{"$f":"'Stakeholder Data Call'!G18","v":0},{"$f":"'Stakeholder Data Call'!H18","v":0},{"$f":"'Stakeholder Data Call'!I18","v":0},{"$f":"'Stakeholder Data Call'!J18","v":0},{"$f":"'Stakeholder Data Call'!K18","v":0},{"$f":"'Stakeholder Data Call'!L18","v":0},{"$f":"'Stakeholder Data Call'!N18","v":0},{"$f":"'Stakeholder Data Call'!O18","v":0},{"$f":"'Stakeholder Data Call'!P18","v":0},{"$f":"'Stakeholder Data Call'!Q18","v":0},{"$f":"'Stakeholder Data Call'!R18","v":0},{"$f":"'Stakeholder Data Call'!S18","v":0},null,null,{"$f":"'Stakeholder Data Call'!T18","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U18","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V18","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M19","v":0},{"$f":"'Stakeholder Data Call'!A19","v":0},{"$f":"'Stakeholder Data Call'!B19","v":0},{"$f":"'Stakeholder Data Call'!C19","v":0},{"$f":"'Stakeholder Data Call'!D19","v":0},{"$f":"'Stakeholder Data Call'!E19","v":0},{"$f":"'Stakeholder Data Call'!F19","v":0},{"$f":"'Stakeholder Data Call'!G19","v":0},{"$f":"'Stakeholder Data Call'!H19","v":0},{"$f":"'Stakeholder Data Call'!I19","v":0},{"$f":"'Stakeholder Data Call'!J19","v":0},{"$f":"'Stakeholder Data Call'!K19","v":0},{"$f":"'Stakeholder Data Call'!L19","v":0},{"$f":"'Stakeholder Data Call'!N19","v":0},{"$f":"'Stakeholder Data Call'!O19","v":0},{"$f":"'Stakeholder Data Call'!P19","v":0},{"$f":"'Stakeholder Data Call'!Q19","v":0},{"$f":"'Stakeholder Data Call'!R19","v":0},{"$f":"'Stakeholder Data Call'!S19","v":0},null,null,{"$f":"'Stakeholder Data Call'!T19","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U19","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V19","v":"00:00:00"}]
[{"$f":"'Stakeholder Data Call'!M20","v":0},{"$f":"'Stakeholder Data Call'!A20","v":0},{"$f":"'Stakeholder Data Call'!B20","v":0},{"$f":"'Stakeholder Data Call'!C20","v":0},{"$f":"'Stakeholder Data Call'!D20","v":0},{"$f":"'Stakeholder Data Call'!E20","v":0},{"$f":"'Stakeholder Data Call'!F20","v":0},{"$f":"'Stakeholder Data Call'!G20","v":0},{"$f":"'Stakeholder Data Call'!H20","v":0},{"$f":"'Stakeholder Data Call'!I20","v":0},{"$f":"'Stakeholder Data Call'!J20","v":0},{"$f":"'Stakeholder Data Call'!K20","v":0},{"$f":"'Stakeholder Data Call'!L20","v":0},{"$f":"'Stakeholder Data Call'!N20","v":0},{"$f":"'Stakeholder Data Call'!O20","v":0},{"$f":"'Stakeholder Data Call'!P20","v":0},{"$f":"'Stakeholder Data Call'!Q20","v":0},{"$f":"'Stakeholder Data Call'!R20","v":0},{"$f":"'Stakeholder Data Call'!S20","v":0},null,null,{"$f":"'Stakeholder Data Call'!T20","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!U20","v":"00:00:00"},null,null,{"$f":"'Stakeholder Data Call'!V20","v":"00:00:00"}]