{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Fr. Moore","2nd Iteration","Cover sheet","Parish Vitality Index","Mass Attendance","Ordinary Income","Parish Metrics","Sacramental trends","Misc. Notes"],"not_rendered":{"charts":11,"macros":1,"external_links":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Fr. Moore","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"hidden":true,"merged":[[0,0,0,8]]}
["PARISH ASSESSMENT"]
[]
[{"$nulls":4},"Below Benchmark","Meets Benchmark","Above Benchmark"]
["FOCUS","DOMAIN","Claim","INDICATOR",0,1,2,"SCORE","Notes / Comments / Evidence"]
["Viability","Financial Standards","The parish is financially stable.","The percent of ordinary expenses paid from ordinary income","<70%","70 - 95%",">95%"]
["Viability","Financial Standards","The parish is financially stable.","Rate of increase of ordinary income vs. rate of increase of inflation rate","<75%","75 - 100%",">100%"]
["Viability","Financial Standards","The parish is financially stable.","Ability to pay priest","No","Yes"]
["Viability","Financial Standards","The parish is financially stable.","Ability to pay for PAA","No","Yes"]
["Viability","Financial Standards","The parish is financially stable.","Ability to provide staff raises/stick to Archdiocesan pay windows","No","Yes"]
["Viability","Financial Standards","The parish is financially stable.","Percent of income from top 5 donors",">40% from top five","40-20% from top five","<20% from top five"]
["Viability","Financial Standards","The parish is financially stable.","Ability to carry out preventative maintenance","No","Yes"]
["Viability","Financial Standards","The parish is financially stable.","Is current on Archdiocesan assessments, debt service, etc.","Not servicing","Servicing on schedule","Paying more"]
["Vitality","Sacramental participation","The parish is growing.","Median overall Mass attendance","<225/100,000","225/100,000 to 375/100,000",">375/100,000"]
["Vitality","Sacramental participation","The parish is growing.","Rate of increase/decrease in overall Sunday Mass attendance","Below population growth rate","Equals population growth rate","Exceeds population growth rate"]
[{"$nulls":3},"Mass attendance:Church capacity"]
["Vitality","Giving","Stewardship is growing.","Number of financially contributing parish members as a percentage of overall Mass attendance","<50%","50-75%",">75%"]
["Vitality","Giving","Stewardship is growing.","Increase/decrease in financially contributing parish members","Below population growth rate","Equals population growth rate","Exceeds population growth rate"]
["Vitality","Sacramental outcomes","Sacramental participation is growing.","Conversion rate (RCIA:registered households)"]
["Vitality","Sacramental outcomes","Sacramental participation is growing.","First-time weddings"]
["Vitality","Sacramental outcomes","Sacramental participation is growing.","Convalidations"]
["Vitality","Sacramental outcomes","Sacramental participation is growing.","First Communions as a percentage of infant Baptisms"]
["Vitality","Sacramental outcomes","Sacramental participation is growing.","Confirmations as a percentage of First Communions"]
["Vitality","Sacramental outcomes","Sacramental participation is growing.","New entries into the Church as a percentage of funerals"]
["Vitality","Sacramental outcomes","Sacramental participation is growing.","Weddings as a percentage of funerals"]
["Vitality","Prayer","Prayer is growing.","Number of person-hours spend in Adoration each week"]
["Vitality","Prayer","Prayer is growing.","Number of person-hours spent in small group/Bible study each week"]
["Vitality","Prayer","Prayer is growing.","Number of person-hours spent in direct-impact service each week"]

{"sheet":"2nd Iteration","index":1,"n_rows":57,"n_cols":6,"rows_kept":57,"hidden":true,"merged":[[0,0,0,5]]}
["PARISH ASSESSMENT"]
[]
[null,"Below Benchmark","Meets Benchmark","Above Benchmark"]
[null,0,1,2,"SCORE","Notes / Comments / Evidence"]
[]
["Financial Standard: The parish is a stable or improving financial operation."]
["Ordinary income (5-year trend)","Up 1-2 years","Up 3 years","Up 4 years"]
["Ordinary income relative to salaries and benefits","down last 5 years","0-2% up last 5 years","2% avg. last 5 years"]
["Collection revenues: percent of change each year"]
["Percent of ordinary expenses paid from ordinary income","<70%","70 - 95%",">95%"]
["Change in ordinary income relative to change in inflation","<75% of inflation rate","75 - 100% of inflation rate",">100% of inflation rate"]
["Reliant on major donors","Yes","No"]
["Personnel: Number of full-time staff","TBD","TBD"]
["Personnel: Number of part-time personnel","TBD","TBD"]
["Personnel: Ability to pay priest","No","Yes"]
["Personnel: Ability to pay PAA","No","Yes"]
["Personnel: Ability to provide staff raises/adhere to Archdiocesan pay windows","No","Yes"]
["Facilities: Carrying out preventative maintenance","No","Yes"]
["Facilities: Deferred maintenance as a percent of ordinary income",">20%","20-10%","<10%"]
["Ability to cover obligations in the next 12 months","No","Yes"]
["Activity toward Archdiocesan assessments, debt service, insurance, etc.","Not servicing","Servicing on time","Paying over"]
["Parish averages a net surplus (as a percent of ordinary income) over the past three years","Negative","Breaken to 10%",">10%"]
["Rental income as a percent of overall income",">25%","10%-24%","<10%"]
["Investments from overall income in capital improvement projects, proactive maintenance or savings","<3%","3-5%",">5%"]
["Parish debt as a percent of annual income",">40%","30-40%","<30%"]
["Months of expenditures on hand in liquid savings (Cash / PRF)","<3 months","3-6 months",">6 months"]
[]
["Leadership Standard: The parish has some structure of lay leadership."]
["Established Pastoral Council","Does not exist","Exists"]
["Established Finance Council","Does not exist","Exists"]
[]
["Growth Standard: The parish is a stable or growing local faith community."]
["Three-year trend"]
["   Mass attendance (Avg. weekly October) per capita*","Decreasing","Stable","Increasing"]
["   Registered households per capita*","Decreasing","Stable","Increasing"]
["   Financially contributing parish members per capita*","Decreasing","Stable","Increasing"]
["   Mass attendance relative to church capacity","Decreasing","Stable","Increasing"]
["   Financially contributing parish members relative to overall Mass attendance","Decreasing","Stable","Increasing"]
[]
["Discipleship Formation Standard: The parish attracts and forms disciples."]
["Established discipleship ministries","Do not exist","Exist","Exist"]
["Established works of charity and outreach ministries","Do not exist","Exist","Exist"]
["Established religious education / formation programs","Do not exist","Exist","Exist"]
["Hours of Eucharistic Adoration in absolute numbers",0,">0"]
["Change in hours of Eucharistic Adoration","Decreasing","Stable","Increasing"]
["Three year trend"]
["   Baptisms per capita","Decreasing","Stable","Increasing"]
["   Professions of Faith per capita","Decreasing","Stable","Increasing"]
["   Confirmations per capita","Decreasing","Stable","Increasing"]
["   First Communions per capita","Decreasing","Stable","Increasing"]
["   Anointing of the Sick per capita","Decreasing","Stable","Increasing"]
["   Reconciliations per capita","Decreasing","Stable","Increasing"]
["   Weddings per capita","Decreasing","Stable","Increasing"]
["   Funerals per capita","Decreasing","Stable","Increasing"]
["   Total Sacraments per capita","Decreasing","Stable","Increasing"]
[]
["* Per capita = (N / total population within parish boundary) * 100"]

{"sheet":"Cover sheet","index":2,"n_rows":11,"n_cols":6,"rows_kept":11}
["Deanery ID",null,null,6]
["Deanery Name",null,null,"South Seattle"]
["Parish ID:",null,null,"St Patrick"]
["Parish Name, City:",null,null,"Seattle"]
[]
["Tool version #:",1]
[]
["Revision tracking log"]
[]
["Revision #","Date","Completed by","Notes and changes","Data missing/ needed to complete PVI","Filename suffix"]
[null,"2021-03-08","Elijah","Integrated 2020 info + updated notes"]

{"sheet":"Parish Vitality Index","index":3,"n_rows":86,"n_cols":19,"rows_kept":86,"merged":[[0,1,0,11],[4,5,4,8],[52,12,53,12],[72,2,72,4],[76,2,76,4],[77,2,77,4],[80,2,80,4],[80,5,80,9],[81,5,81,9],[82,2,82,4],[82,5,82,9],[84,2,84,4],[85,2,85,4]]}
["Section of PAR","PARISH VITALITY INDEX - Parish Name, City (ID #)"]
[]
[null,"School is affiliated with this parish (Y/N)","No"]
[]
[null,null,"Below Benchmark","Meets Benchmark","Above Benchmark"]
[null,null,0,1,2,"FY 15-16","FY 16-17","FY 17-18","FY 18-19","FY 19-20","Stats"]
[]
[null,"Growth Standard: The parish is a stable or growing local faith community.",{"$nulls":10},"Benchmark","Score"]
["(heading)","Five year trend",{"$nulls":10},{"$f":"N9/M11","v":{"v":0,"d":"0%"}},{"$f":"SUM(N10:N15)","v":0}]
["Mass Spreadsheet","   Mass attendance (Avg. weekly October)","Limited/Decreasing","Stable","Increasing",{"$f":"'[1]Parish Vitality Index'!G10","v":239},{"$f":"'[1]Parish Vitality Index'!H10","v":224},{"$f":"'[1]Parish Vitality Index'!I10","v":225},{"$f":"'[1]Parish Vitality Index'!J10","v":203},44,null,null,"w/o school",{"$f":"((GetColorCount(C10:E10,D5)*1)+(GetColorCount(C10:E10,E5)*2))","v":0}]
["(above line divided by # weekend Masses)","   Ave Attendance per Mass","Limited/Decreasing","Stable","Increasing",{"$f":"'[1]Parish Vitality Index'!G11","v":{"v":119.5,"d":"120"}},{"$f":"'[1]Parish Vitality Index'!H11","v":112},{"$f":"'[1]Parish Vitality Index'!I11","v":{"v":112.5,"d":"113"}},{"$f":"'[1]Parish Vitality Index'!J11","v":{"v":101.5,"d":"102"}},{"$f":"J10/$K$11","v":22},2,"# weekly Masses",{"$f":"5","v":5},{"$f":"((GetColorCount(C11:E11,D6)*1)+(GetColorCount(C11:E11,E6)*2))","v":0}]
["Demo - B-1","   Registered households","Limited/Decreasing","Stable","Increasing",{"$f":"'[1]Parish Vitality Index'!G12","v":296},{"$f":"'[1]Parish Vitality Index'!H12","v":293},{"$f":"'[1]Parish Vitality Index'!I12","v":247},{"$f":"'[1]Parish Vitality Index'!J12","v":254},217,null,null,"w/school",{"$f":"((GetColorCount(C12:E12,D5)*1)+(GetColorCount(C12:E12,E5)*2))","v":0}]
["Demo - B-4 (divided by B-1)","   % of households who contribute financially","Limited/Decreasing","Stable","Increasing",{"$f":"'[1]Parish Vitality Index'!G13","v":{"v":0.8344594594594594,"d":"83%"}},{"$f":"'[1]Parish Vitality Index'!H13","v":{"v":0.6757679180887372,"d":"68%"}},{"$f":"'[1]Parish Vitality Index'!I13","v":{"v":0.7651821862348178,"d":"77%"}},{"$f":"'[1]Parish Vitality Index'!J13","v":{"v":0.5433070866141733,"d":"54%"}},{"$f":"168/J12","v":{"v":0.7741935483870968,"d":"77%"}},null,null,6,{"$f":"((GetColorCount(C13:E13,D5)*1)+(GetColorCount(C13:E13,E5)*2))","v":0}]
["Demo - D1 / Mass Attendance","   % church occupancy during average weekend Mass","Limited/Decreasing","Stable","Increasing",{"$f":"F11/$K$14","v":{"v":0.33194444444444443,"d":"33%"}},{"v":0.3111111111111111,"d":"31%"},{"$f":"H11/$K$14","v":{"v":0.3125,"d":"31%"}},{"$f":"I11/$K$14","v":{"v":0.28194444444444444,"d":"28%"}},{"v":0.06111111111111111,"d":"6%"},360,"Capacity of Church",null,{"$f":"((GetColorCount(C14:E14,D5)*1)+(GetColorCount(C14:E14,E5)*2))","v":0}]
["Office of Catholic Schools","School Enrollment","Limited/Decreasing","Stable","Increasing",{"$nulls":5},"n/a"]
[]
[null,"Discipleship Formation Standard: The parish attracts and forms disciples.",{"$nulls":10},"Benchmark","Score"]
[{"$nulls":12},{"$f":"N18/M20","v":{"v":0.6538461538461539,"d":"65%"}},{"$f":"SUM(N19:N45)","v":17}]
["Demo - E & G","Established evangelization effort for adults - Variety of formation/pastoral/outreach programs (Y/N)","Do not exist","Exist","Exist","yes","yes","yes","yes","yes",null,null,"w/o school",{"$f":"((GetColorCount(C19:E19,D5)*1)+(GetColorCount(C19:E19,E5)*2))","v":1}]
["Demo - E & G (youth ministry under Pastoral Ministries","Established evangelization effort for youth - Youth Ministry (Y/N)","Do not exist","Exist","Exist","no","yes","no","no","yes",null,null,26,{"$f":"((GetColorCount(C20:E20,D5)*1)+(GetColorCount(C20:E20,E5)*2))","v":1}]
["Demo - G-2 (faith formation)","   # Active Faith Formation programs (# checked out of 6)","Limited/Decreasing","Stable","Increasing",4,3,3,3,3,null,null,"w/school",{"$f":"((GetColorCount(C21:E21,D5)*1)+(GetColorCount(C21:E21,E5)*2))","v":1}]
["Demo - G-2 (sacramental prep)","   # Active Sacramental Prep Programs  (# Checked out of 7)","Limited/Decreasing","Stable","Increasing",5,4,4,3,6,null,null,28,{"$f":"((GetColorCount(C22:E22,D5)*1)+(GetColorCount(C22:E22,E5)*2))","v":2},null,null,"2020 score","Benchmark","% of Benchmark"]
["Demo - G-1","   Stewardshop Commission? (Y/N)","Limited/Decreasing","Exist","Exist","no","no","no","no","no",{"$nulls":3},{"$f":"((GetColorCount(C23:E23,D5)*1)+(GetColorCount(C23:E23,E5)*2))","v":0},null,"Growth",{"$f":"N9","v":0},{"$f":"M11","v":5},{"$f":"M9","v":{"v":0,"d":"0%"}}]
["Demo - G-2 (pastoral ministries)","   # Active Pastoral Ministries  (# Checked out of 13)","Limited/Decreasing","Stable","Increasing",4,4,5,4,4,{"$nulls":3},{"$f":"((GetColorCount(C24:E24,D5)*1)+(GetColorCount(C24:E24,E5)*2))","v":1},null,"Disciple Formation",{"$f":"N18","v":17},{"$f":"M20","v":26},{"$f":"M18","v":{"v":0.6538461538461539,"d":"65%"}}]
["Demo - G-2 (outreach/social justice)","   # Active Outreach/Social Justice Ministries  (# Checked out of 15)","Limited/Decreasing","Stable","Increasing",9,9,12,14,12,{"$nulls":3},{"$f":"((GetColorCount(C25:E25,D5)*1)+(GetColorCount(C25:E25,E5)*2))","v":2},null,"Liturgy",{"$f":"N50","v":2},{"$f":"M52","v":3},{"$f":"M50","v":{"v":0.6666666666666666,"d":"67%"}}]
["Demo - G-2","   Regular activities encouraging parishioners to Pray, Give and Serve (Y/N)","Limited/Decreasing","Exist","Exist","yes","yes","yes","yes","yes",{"$nulls":3},{"$f":"((GetColorCount(C26:E26,D5)*1)+(GetColorCount(C26:E26,E5)*2))","v":1},null,"Leadership",{"$f":"N57","v":4},{"$f":"M59","v":3},{"$f":"M57","v":{"v":1.3333333333333333,"d":"133%"}}]
["Demo - E (participants)","Established religious education / formation programs (Y/N)","Limited/Decreasing","Exist","Exist","yes","yes","yes","yes","yes",{"$nulls":3},{"$f":"((GetColorCount(C27:E27,D5)*1)+(GetColorCount(C27:E27,E5)*2))","v":1},null,"Finance",{"$f":"N65","v":10},{"$f":"M67","v":16},{"$f":"M65","v":{"v":0.625,"d":"63%"}}]
["Demo - E (participants)","   # Children (preschool - 6th grade) in religious ed program","Limited/Decreasing","Stable","Increasing",{"$f":"4+7+6","v":17},{"$f":"6+5+6","v":17},{"$f":"5+7+8","v":20},{"$f":"5+7+8","v":20},{"$f":"2+5+5","v":12},{"$nulls":3},{"$f":"((GetColorCount(C28:E28,D5)*1)+(GetColorCount(C28:E28,E5)*2))","v":0}]
["Demo - E (participants)","   # Teens (7th - 12th) grade in religious ed program","Limited/Decreasing","Stable","Increasing",{"$f":"8","v":8},{"$f":"6","v":6},{"$f":"5","v":5},4,{"$f":"7","v":7},{"$nulls":3},{"$f":"((GetColorCount(C29:E29,D5)*1)+(GetColorCount(C29:E29,E5)*2))","v":0}]
["Demo - E (participants)","   # participating in  Young Adult education opportunities","Limited/Decreasing","Stable","Increasing",0,0,0,0,0,{"$nulls":3},{"$f":"((GetColorCount(C30:E30,D5)*1)+(GetColorCount(C30:E30,E5)*2))","v":0}]
["Demo - E (participants)","   # participating in Adult education/formation opportunities","Limited/Decreasing","Stable","Increasing",150,200,100,100,60,{"$nulls":3},{"$f":"((GetColorCount(C31:E31,D5)*1)+(GetColorCount(C31:E31,E5)*2))","v":0}]
["Demo - E (catechists)","  # Paid Staff Compared to # Volunteers teaching Religious Ed programs","Decreasing vol. engagement","Stable  volunteer engagement","Increasing vol. engagement","01:09:00","01:10:00","02:07:00","01:06:00","02:08:00",{"$nulls":3},{"$f":"((GetColorCount(C32:E32,D5)*1)+(GetColorCount(C32:E32,E5)*2))","v":0}]
["Demo - C-EUCHARISTIC ADORATION","Established hours of Eucharistic Adoration","Do not exist","Exist","Exist",0,0,0,0,0,{"$nulls":3},{"$f":"((GetColorCount(C33:E33,D5)*1)+(GetColorCount(C33:E33,E5)*2))","v":0}]
["(heading)","Sacraments (Five year trend)"]
["Demo - A-1","   Baptisms (total)","Limited/Decreasing","Stable","Increasing",7,6,4,1,3,{"$nulls":3},{"$f":"((GetColorCount(C35:E35,D5)*1)+(GetColorCount(C35:E35,E5)*2))","v":0}]
["Demo - A-2","   RCIA/ Professions of Faith","Limited/Decreasing","Stable","Increasing",0,1,1,0,0,null,{"$f":"J51/F51","v":{"v":0.5779816513761468,"d":"58%"}},null,{"$f":"((GetColorCount(C36:E36,D5)*1)+(GetColorCount(C36:E36,E5)*2))","v":0}]
["Demo - A-3","   First Communions (incl adult)","Limited/Decreasing","Stable","Increasing",1,9,10,0,0,{"$nulls":3},{"$f":"((GetColorCount(C37:E37,D5)*1)+(GetColorCount(C37:E37,E5)*2))","v":0}]
["Demo - A-4","   Confirmations (incl Adults)","Limited/Decreasing","Stable","Increasing",0,4,0,0,16,{"$nulls":3},{"$f":"((GetColorCount(C38:E38,D5)*1)+(GetColorCount(C38:E38,E5)*2))","v":2}]
["Demo - A-8","   Anointing of the Sick","Limited/Decreasing","Stable","Increasing",15,50,55,35,485,{"$nulls":3},{"$f":"((GetColorCount(C39:E39,D5)*1)+(GetColorCount(C39:E39,E5)*2))","v":2}]
["Demo - A-9","   Reconciliations (Month X 12) plus Penance services","Limited/Decreasing","Stable","Increasing",{"$f":"24+65","v":89},{"$f":"12+35","v":47},64,64,70,{"$nulls":3},{"$f":"((GetColorCount(C40:E40,D5)*1)+(GetColorCount(C40:E40,E5)*2))","v":0}]
["Demo - A-10","   Weddings","Limited/Decreasing","Stable","Increasing",5,2,3,2,1,{"$nulls":3},{"$f":"((GetColorCount(C41:E41,D5)*1)+(GetColorCount(C41:E41,E5)*2))","v":0}]
["Demo - A-6","   Funerals","Limited/Decreasing","Stable","Increasing",4,6,1,5,4,{"$nulls":3},{"$f":"((GetColorCount(C42:E42,D5)*1)+(GetColorCount(C42:E42,E5)*2))","v":1}]
["Demo - E (participants)","Established ministries for ethnicities (Y/N)","Do not exist","Exist","Exist","no","no","no","?","no",{"$nulls":3},{"$f":"((GetColorCount(C43:E43,D5)*1)+(GetColorCount(C43:E43,E5)*2))","v":0}]
["Demo - C-MASSES CELEBRATED","   Non-English Masses (Y/N) List Languages","Do not exist","Exist","Exist","Y - ASL","Y - ASL","no","no","Y - ASL",{"$nulls":3},{"$f":"((GetColorCount(C44:E44,D5)*1)+(GetColorCount(C44:E44,E5)*2))","v":1}]
["Demo - E (participants)","   Non-English Religious Education (Y/N) List Languages","Do not exist","Exist","Exist","Y - ASL","Y - ASL","Y - ASL","?","Y - ASL",{"$nulls":3},{"$f":"((GetColorCount(C45:E45,D5)*1)+(GetColorCount(C45:E45,E5)*2))","v":1}]
["Office of Catholic Schools","School principal has received Level 1 \"Christ in the Classroom\" Certification (Y/N)","no","yes",{"$nulls":6},"n/a"]
["Office of Catholic Schools","# of teachers with Level 2 \"Christ in the Classroom\" Certification ","Limited/Decreasing","Stable","Increasing",{"$nulls":5},"n/a"]
[]
[null,"Liturgy Standard: The parish engages the faithful in the Liturgy",{"$nulls":10},"Benchmark","Score"]
[null,"Liturgical forms (GIRM or Many Gifts, One Spirit)",{"$nulls":10},{"$f":"N50/M52","v":{"v":0.6666666666666666,"d":"67%"}},{"$f":"((GetColorCount(C51:E54,D5)*1)+(GetColorCount(C51:E54,E5)*2))","v":2}]
["Demo - C-LITURGICAL MINISTRIES","   # Serving as Eucharistic Ministers, Lectors, Ushers and Sacristans","Limited/Decreasing","Stable","Increasing",{"$f":"47+18+15+7+5+17","v":109},{"$f":"38+20+10+5+5+20","v":98},{"$f":"44+25+12+9+13","v":103},{"$f":"44+25+12+9+13+3","v":106},{"$f":"33+18+8+4","v":63},null,null,"w/o school",{"$f":"((GetColorCount(C51:E51,D5)*1)+(GetColorCount(C51:E51,E5)*2))","v":0}]
["Demo - C-LITURGICAL MINISTRIES","   # Serving as Altar Servers ","Limited/Decreasing","Stable","Increasing",0,0,0,0,0,null,null,3,{"$f":"((GetColorCount(C52:E52,D6)*1)+(GetColorCount(C52:E52,E6)*2))","v":0}]
["Demo - C-LITURGICAL MINISTRIES","   # Serving in choir or as cantors (musicians participating in music ministry)","Limited/Decreasing","Stable","Increasing",{"$f":"26+12","v":38},{"$f":"12+27","v":39},{"$f":"31+14","v":45},{"$f":"14+31","v":45},{"$f":"30+14","v":44},null,null,"w/school",{"$f":"((GetColorCount(C53:E53,D5)*1)+(GetColorCount(C53:E53,E5)*2))","v":2}]
["Office of Catholic Schools","# of school Masses per month","Limited/Decreasing","Stable","Increasing",{"$nulls":5},"n/a"]
[{"$nulls":12},4]
[null,"Leadership Standard: The parish has some structure of lay leadership.",{"$nulls":10},"Benchmark","Score"]
[{"$nulls":12},{"$f":"N57/M59","v":{"v":1.3333333333333333,"d":"133%"}},{"$f":"SUM(N58:N62)","v":4}]
["Demo - G-1 ","Pastoral Council (# members)","Limited/Decreasing","Stable","Increasing",9,8,8,8,9,null,null,"w/o school",{"$f":"((GetColorCount(C58:E58,D5)*1)+(GetColorCount(C58:E58,E5)*2))","v":1}]
["Demo - G-1 ","Finance Council (# members)","Limited/Decreasing","Stable","Increasing",5,5,5,5,5,null,null,3,{"$f":"((GetColorCount(C59:E59,D5)*1)+(GetColorCount(C59:E59,E5)*2))","v":1}]
["Demo - G-1 ","# total Councils and Commissions (# checked out of 9)","Limited/Decreasing","Stable","Increasing",5,3,5,5,6,null,null,"w/school",{"$f":"((GetColorCount(C60:E60,D5)*1)+(GetColorCount(C60:E60,E5)*2))","v":2}]
["Office of Catholic Schools","School Commission (# members)","Limited/Decreasing","Stable","Increasing",{"$nulls":5},"n/a",null,5]
["Office of Catholic Schools","School Finance Commission (# members)","Limited/Decreasing","Stable","Increasing",{"$nulls":5},"n/a"]
[]
[null,"Financial Standard: The parish is a stable or improving financial operation.",{"$nulls":10},"Benchmark","Score"]
[null,"Five-year trend",{"$nulls":10},{"$f":"N65/M67","v":{"v":0.625,"d":"63%"}},{"$f":"SUM(N66:N86)","v":10}]
["II-A: FIN - Summary of Operations","   Total Revenue  (Summary of Operations Table)","Negative","Break even to 10%",">10% increase",{"v":435895,"d":"435,895"},{"v":437455,"d":"437,455"},{"v":451582,"d":"451,582"},{"v":464464,"d":"464,464"},{"v":517286,"d":"$517,286"},null,null,"w/o school",{"$f":"((GetColorCount(C66:E66,D5)*1)+(GetColorCount(C66:E66,E5)*2))","v":2}]
["II-A: FIN - Summary of Operations","   Salaries + benefits / Total Revenue (Summary of Operations Table)","down last 5 years","0-2% up last 5 years","2% avg. last 5 years",{"$f":"(169717+86907)/F66","v":{"v":0.588728937014648,"d":"59%"}},{"$f":"(178828+38091)/G66","v":{"v":0.4958658604885074,"d":"50%"}},{"$f":"(191663+37596)/H66","v":{"v":0.5076796683658782,"d":"51%"}},{"$f":"(190860+41316)/I66","v":{"v":0.4998794309139137,"d":"50%"}},{"$f":"(117910+23636)/J66","v":{"v":0.2736319946799256,"d":"27%"}},null,{"$f":"J66-J76","v":{"v":424159,"d":"$424,159"}},16,{"$f":"((GetColorCount(C67:E67,D5)*1)+(GetColorCount(C67:E67,E5)*2))","v":0}]
["II-A: FIN - Summary of Operations","   Total expenses / Total  Revenue (Summary of Operations Table)",">95%","70 - 95%","<70%",{"$f":"470811/F66","v":{"v":1.0801018593927436,"d":"108%"}},{"$f":"388917/G66","v":{"v":0.8890445874432799,"d":"89%"}},{"$f":"413791/H66","v":{"v":0.9163142020718275,"d":"92%"}},{"$f":"432675/I66","v":{"v":0.9315576664714595,"d":"93%"}},{"$f":"434508/J66","v":{"v":0.8399763380412383,"d":"84%"}},null,null,"w/school",{"$f":"((GetColorCount(C68:E68,D5)*1)+(GetColorCount(C68:E68,E5)*2))","v":1}]
["(look at trend)","  Five Year Trend Expenses/Income ","Expenses outpace income","Growth of expense and income matches","Income outpaces expenses",{"$nulls":7},18,{"$f":"((GetColorCount(C69:E69,D5)*1)+(GetColorCount(C69:E69,E5)*2))","v":0}]
["II-A: FIN - Summary of Operations","   Net Revenue (or Loss)","Negative","Break even to 10%",">10%",{"$f":"F66-470811","v":{"v":-34916,"d":"-34,916"}},{"$f":"G66-388917","v":{"v":48538,"d":"48,538"}},{"$f":"H66-413791","v":{"v":37791,"d":"37,791"}},{"$f":"I66-432675","v":{"v":31789,"d":"31,789"}},{"v":82778,"d":"$82,778"},{"$nulls":3},{"$f":"((GetColorCount(C70:E70,D5)*1)+(GetColorCount(C70:E70,E5)*2))","v":1}]
["II-A: FIN - Summary of Operations","  Operations & maintenance Expense / Total Revenue",">20%","20-10%","<10%",{"$f":"38199/F66","v":{"v":0.08763348971656018,"d":"9%"}},{"$f":"13094/G66","v":{"v":0.02993222159993599,"d":"3%"}},{"$f":"14788/H66","v":{"v":0.03274709797999034,"d":"3%"}},{"$f":"13757/I66","v":{"v":0.02961908780874298,"d":"3%"}},{"$f":"25844/J66","v":{"v":0.0499607567187204,"d":"5%"}},{"$nulls":3},{"$f":"((GetColorCount(C71:E71,D5)*1)+(GetColorCount(C71:E71,E5)*2))","v":2}]
["II-A: FIN - Summary of Operations","   Rental & Lease income / Total Revenue",">25%","10%-24%","<10%",{"$f":"(11230+14400)/F66","v":{"v":0.05879856387432753,"d":"6%"}},{"$f":"(7851+20884)/G66","v":{"v":0.06568675635208193,"d":"7%"}},{"$f":"27881/H66","v":{"v":0.06174072482959905,"d":"6%"}},{"$f":"22621/I66","v":{"v":0.0487034517206931,"d":"5%"}},{"$f":"22386/J66","v":{"v":0.043275866735229644,"d":"4%"}},{"$nulls":3},{"$f":"((GetColorCount(C72:E72,D5)*1)+(GetColorCount(C72:E72,E5)*2))","v":2}]
["II-A: FIN - Summary of Operations","   Collection Revenue / Total Revenue","Benchmarks missing",null,null,{"$f":"F74/F66","v":{"v":0.7463517590245358,"d":"75%"}},{"$f":"G74/G66","v":{"v":0.7548707867094901,"d":"75%"}},{"$f":"H74/H66","v":{"v":0.7766496450257097,"d":"78%"}},{"$f":"I74/I66","v":{"v":0.7284762651141962,"d":"73%"}},{"$f":"324252/J66","v":{"v":0.6268331251957331,"d":"63%"}}]
["(look at trend)","Collection revenues: percent of change each year","0 or down","1-2% increase",null,{"v":325331,"d":"325,331"},{"v":330222,"d":"330,222"},{"v":350721,"d":"350,721"},{"v":338351,"d":"338,351"},324252,{"$nulls":3},{"$f":"((GetColorCount(C74:E74,D5)*1)+(GetColorCount(C74:E74,E5)*2))","v":0}]
[{"$nulls":5},"n/a",{"$f":"(G74/F74)-1","v":{"v":0.015033919300650789,"d":"2%"}},{"$f":"(H74/G74)-1","v":{"v":0.062076421316568764,"d":"6%"}},{"$f":"(I74/H74)-1","v":{"v":-0.035270200529765816,"d":"-4%"}},{"$f":"(J74/I74)-1","v":{"v":-0.041669745323643204,"d":"-4.17%"}}]
["III FIN: Planned Giving","Amount in Planned Giving Agreements","None/Decreasing","Stable","Increasing","none","none","none","none",{"v":93127,"d":"$93,127"},{"$nulls":3},{"$f":"((GetColorCount(C76:E76,D5)*1)+(GetColorCount(C76:E76,E5)*2))","v":2}]
["Profit & Loss Statement:add up all Lay","Personnel: Lay Salaries","Benchmarks missing",null,null,{"$f":"33476+11388+41054+14365+29685","v":{"v":129968,"d":"129,968"}},"not avail","not avail","not avail",{"v":117910,"d":"$117,910"}]
["Profit & Loss Statement:add up Clergy + extra clergy","Personnel - Clergy - Total clergy compensation","Benchmarks missing",null,null,{"$f":"28705+818","v":{"v":29523,"d":"29,523"}},"not avail","not avail","not avail","not avail"]
["(look at trend)","Personnel: Ability to provide staff raises/adhere to Archdiocesan pay windows (Y/N)","No","Yes",null,"yes","yes","yes","no ","no",{"$nulls":3},{"$f":"((GetColorCount(C79:E79,D5)*1)+(GetColorCount(C79:E79,E5)*2))","v":0}]
[]
["Scott Bader","Facilities: Parish Reported deferred maintenance ","Benchmarks missing",null,null,"Parish has reported numerous facilities maintenance repairs"]
["Scott Bader","Facilities: Parish has engaged a consultant to confirm /determine deferred maintenance amt (Y/N)","No","Yes",null,"No",{"$nulls":7},{"$f":"((GetColorCount(C82:E82,D5)*1)+(GetColorCount(C82:E82,E5)*2))","v":0}]
["PAR: P & L for parish","Facilities: Deferred maintenance / Ordinary Income","Benchmarks missing"]
[]
["PAR: P & L for parish","School: School Ordinary Income/Total Expenses","Benchmarks missing",{"$nulls":7},"n/a"]
["PAR: P & L for parish","Schools: Tuition Revenue/Teacher Salaries and Benefits","Benchmarks missing",{"$nulls":7},"n/a"]

{"sheet":"Mass Attendance","index":4,"n_rows":31,"n_cols":4,"rows_kept":31}
["DID","Deanery","PID","Parish Name"]
[6,"South Seattle",29,"St. Patrick, Seattle"]
[]
[]
["Year","Mass count"]
[1995,390]
[1996,358]
[1997,376]
[1998,370]
[1999,293]
[2000,269]
[2001,270]
[2002,277]
[2003,268]
[2004,248]
[2005,240]
[2006,262]
[2007,228]
[2008,264]
[2009,243]
[2010,260]
[2011,251]
[2012,264]
[2013,262]
[2014,241]
[2015,239]
[2016,224]
[2017,225]
[2018,203]
[2019,189]
[2020,44]

{"sheet":"Ordinary Income","index":5,"n_rows":16,"n_cols":19,"rows_kept":16}
["DID","Deanery","PID","Parish Name"]
[6,"South Seattle",29,"St. Patrick, Seattle"]
[]
[]
["FY","Ordinary Income"]
["15-16",{"v":316700,"d":"$316,700"}]
["16-17",{"v":321312,"d":"$321,312"}]
["17-18",{"v":336979,"d":"$336,979"}]
["18-19",{"v":330041,"d":"$330,041"}]
["19-20",{"v":321507,"d":"$321,507"}]
[]
[]
[]
[]
[]
[{"$nulls":18},"   "]

{"sheet":"Parish Metrics","index":6,"n_rows":49,"n_cols":2,"rows_kept":49}
["PID","029"]
["Parish","ST PATRICK, SEATTLE"]
["OI (3 year avg)",{"v":330041,"d":"330,041"}]
["NON OI Revenue",{"v":0.25552394292269226,"d":"26%"}]
["HH (avg)",254]
["givers",180]
["OI/hh",{"$f":"B3/B5","v":{"v":1299.3740157480315,"d":"1,299.37"}}]
["OI/giver",{"$f":"B3/B6","v":{"v":1833.5611111111111,"d":"1,833.56"}}]
["PRF Savings",{"v":270638.69,"d":"270,639"}]
["PRF Loans"]
["could borrow"]
["Deferred Maint","$250K+"]
["Baptisms (10 year avg)",{"v":1.8,"d":"2"}]
["Mass attendance",{"v":224.75,"d":"225"}]
["Masses",1]
["#/Mass",{"$f":"B14/B15","v":{"v":224.75,"d":"225"}}]
["Priests",0.5]
["PAA"]
["PAFF"]
["PAYM"]
[]
["3 year average","ST PATRICK"]
["Ord Inc",{"v":329444,"d":"329,444"}]
["OI % all",{"$f":"B23/B46","v":{"v":0.7302041151059364,"d":"73%"}}]
["Building/Captial",0]
["Appeal reb",{"v":10320.666666666666,"d":"10,321"}]
["Debt Red",0]
["Educ Rev",{"v":5316.333333333333,"d":"5,316"}]
["Fundrasising Rev",{"v":25810.666666666668,"d":"25,811"}]
["Fund % all",{"$f":"B29/B46","v":{"v":0.05720867587094505,"d":"6%"}}]
["BEQUESTS",{"v":4487.333333333333,"d":"4,487"}]
["RESTRICTED",{"v":5118.333333333333,"d":"5,118"}]
["OTHER GIFT",{"v":10162,"d":"10,162"}]
["GIFT REV",{"v":19767.666666666668,"d":"19,768"}]
["Gift % of all",{"$f":"B34/B46","v":{"v":0.04381452248649983,"d":"4%"}}]
["INTEREST ",{"v":7068.333333333333,"d":"7,068"}]
["RENTAL ",{"v":26412.333333333332,"d":"26,412"}]
["OTHER BUS",{"v":2378,"d":"2,378"}]
["Bus Rev",{"v":35858.666666666664,"d":"35,859"}]
["Bus Rev % all",{"$f":"B39/B46","v":{"v":0.07947980828976114,"d":"8%"}}]
["Program Rev",{"v":3609.3333333333335,"d":"3,609"}]
["Prog % all",{"$f":"B41/B46","v":{"v":0.007999994089402225,"d":"1%"}}]
["Pastrl Svcs",{"v":14424.333333333334,"d":"14,424"}]
["ALL OTHER",{"v":11523.666666666666,"d":"11,524"}]
["Other % all",{"$f":"B44/B46","v":{"v":0.02554190946294092,"d":"3%"}}]
["TOTAL INCOME",{"v":451167,"d":"451,167"}]
[]
["PRF Savings;PRF Loan","$377K;  "]
["Deferred Maintenance","deferred maintenance $250K+"]

{"sheet":"Sacramental trends","index":7,"n_rows":61,"n_cols":27,"rows_kept":61}
[null,"DID","DID","Deanery","PID","Parish Name"]
[null,0,{"$f":"'Cover sheet'!D1","v":6},{"$f":"'Cover sheet'!D2","v":"South Seattle"},{"$f":"'Cover sheet'!D3","v":"St Patrick"},{"$f":"'Cover sheet'!D4","v":"Seattle"}]
[{"$nulls":5},"2000-01","2001-02","2002-03","2003-04","2004-05","2005-06","2006-07","2007-08","2008-09","2009-10","2010-11","2011-12","2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20"]
[{"$nulls":4},"Infant baptisms",10,6,13,13,13,5,6,4,5,5,4,2,6,6,3,7,5,4,1,3,null,{"$f":"(Y4-F4)/F4","v":{"v":-0.7,"d":"-70%"}}]
[{"$nulls":4},"First Eucharist",9,1,6,11,5,13,6,5,0,5,5,5,3,7,6,1,7,10,0,0,null,{"$f":"(Y5-F5)/F5","v":{"v":-1,"d":"-100%"}}]
[{"$nulls":4},"Youth confirmed by Bishop",2,0,1,0,3,4,0,0,4,0,0,8,0,3,0,0,4,0,0,16,null,{"v":7,"d":"700%"}]
[{"$nulls":4},"Adult converts",5,1,4,0,6,4,2,0,2,2,2,0,0,1,4,0,2,1,0,0,null,{"v":-1,"d":"-100%"}]
[{"$nulls":4},"Marriages",8,14,14,6,7,5,2,4,10,4,2,2,1,2,0,5,2,3,0,1,null,{"v":-0.875,"d":"-88%"}]
[{"$nulls":4},"Funerals",9,5,4,3,5,4,3,0,3,3,10,2,1,1,4,4,6,1,5,4,null,{"v":-0.5555555555555556,"d":"-56%"}]
{"$rows_empty":46}
[{"$nulls":5},"Marriage"]
[]
[{"$nulls":5},"2015-16"]
[{"$nulls":5},"2016-17"]
[{"$nulls":5},"2017-18"]
[{"$nulls":5},"2018-19"]

{"sheet":"Misc. Notes","index":8,"n_rows":0,"n_cols":0,"rows_kept":0}