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

{"sheet":"Control Panel","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[5,1,6,2]]}
[]
[]
[]
[]
[]
[null,"Control Panel"]
[]
[]
[null," Name of evidence-based program: Select from list below:","A Matter of Balance"]
[null,"Annual number of program workshops conducted",13]
[null,"Number of sessions per workshop",6]
[null,"Hours per workshop session",2.5]
[null,"Enrollees per workshop",13]
[null,"Session attendance percentage",0.89999997615814198]
[null,"Reimbursement per attendee per session",45]
[null,"Payment by attendee per session",10]
[null,"Grant and other funding",0]
[]
[]
[null,"Program List: (Select one)"]
[null,"Tai Chi for Arthritis"]
[null,"A Matter of Balance"]
[null,"EnhanceFitness"]
[null,"Bingocize"]
[null,"SMRC Chronic Disease Self-Management Program- In- Person"]
[null,"SMRC Chronic Disease Self-Management Program-Virtual"]
[null,"SMRC Chronic Disease Self-Management Program- Toolkit"]
[null,"Walk With Ease"]
[null,"Other"]

{"sheet":"Fixed Costs","index":1,"n_rows":98,"n_cols":24,"rows_kept":98,"cut":false,"hidden":false,"merged":[[44,1,45,4],[77,2,77,3],[48,7,50,7],[48,8,50,8],[48,9,50,9],[61,7,65,7],[61,17,65,17],[61,8,65,8],[61,9,65,9],[61,10,65,10],[61,11,65,11],[61,12,65,12],[48,10,50,10],[61,13,65,13],[61,14,65,14],[61,15,65,15],[61,16,65,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fixed Costs"]
[]
[]
[null,"Salaries:","Staff ",null,83400]
[null,null,null,null,null,null,null,"Title","Annual Salary","Benefits \n(%)","Annual Salary With Benefits"]
[null,"Contractor Fees:","IT Platform",null,0]
[null,null,"Web Development",null,8000]
[null,null,"Legal",null,0,null,null,"Executive Director - CEO",225000,0.2,270000]
[null,null,"Other Consulting Fees",null,0,null,null,"Chief Finance Officer",120000,0.2,144000]
[null,null,"Total Contractor Fees",null,8000,null,null,"Director of Operations",110000,0.2,132000]
[null,null,null,null,null,null,null,"Accounting Manager",75000,0.2,90000]
[null,"Staff Development:","Licenses & Certifications",null,8000,null,null,"Information Systems Manager",111000,0.2,133200]
[null,null,"Workshop Leader Training",null,16050,null,null,"Administrative Support",78000,0.2,93600]
[null,null,"Total Staff Development",null,24050,null,null,"Other 1",60000,0.2,72000]
[null,null,null,null,null,null,null,"Other 2",0,0.2,0]
[null,"Travel and Meeting:","Travel - Lodging",null,6000,null,null,"Other 3",0,0.2,0]
[null,null,"Travel - Transportation",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Master Training:","Number of Master Trainers Trained Annually",2]
[null,null,"Travel - Meals",null,0,null,null,"Hours Per Week","Executive Director - CEO","Chief Finance Officer","Director of Operations","Accounting Manager","Information Systems Manager","Administrative Support","Other 1","Other 2","Other 3","Total Annual Costs \n(based on 48 weeks at 40 hours per week)",null,null,null,null,"Fee per trainee to attend Master's training",2000]
[null,null,"Meetings Expense",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stipend (imputed Cost) per Trainee for participating in Master training",250]
[null,null,"Total Travel & Meeting",null,6000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Master Training Costs",4500]
[]
[null,"Office Expense:","Office Supplies",null,1200]
[null,null,"Postage & Shipping",null,700,null,null,"1. Establishing relationships with partner organizations",1,0,0,0,0,1,0,0,0,9090,null,null,null,"Leader Training:","Number of Workshop Leaders trained externally",3]
[null,null,"Utilities",null,0,null,null,"2. On-going marketing and program promotion",0,0,2,0,0,1,0,0,0,8940,null,null,null,null,"Leadership training fee/tuition per externally trained trainee",1250]
[null,null,"Printing & Copying",null,0,null,null,"3. Recruiting participants & supporting retention",0,0,3,0,0,1,0,0,0,12240,null,null,null,null,"Number of Workshop Leaders trained internally",9]
[null,null,"Furniture Expense",null,0,null,null,"4. Assisting in setting up workshops & providing support to leaders",0,0,1,0,0,1,0,0,0,5640,null,null,null,null,"Training cost per internally trained trainee",200]
[null,null,"Total Office Expense",null,1900,null,null,"5. Tracking participation",0,0,1,1,2,1,0,0,0,14550,null,null,null,null,"Stipend to trainee - internal and external",500]
[null,null,null,null,null,null,null,"6. Monitoring quality and program fidelity ",0,0,1,0,1,1,0,0,0,8970,null,null,null,null,"Total Leader Training Cost",11550]
[null,"Other Fixed Expense:",null,null,0,null,null,"7. Documenting outcomes",0,0,1,1,0,1,0,0,0,7890,null,null,null,null,"Total Training Costs - Master and Leader",16050]
[null,null,null,null,null,null,null,"8. Financial accounting for costs and revenues",0,1,1,2,0,1,0,0,0,13740]
[null,"Software/Equip/Maint","Software Costs",null,1500,null,null,"9. Grant acquisition",0,0,0,0,0,1,0,0,0,2340]
[null,null,"Equipment Maintenance",null,0,null,null,null,1,1,10,4,3,9,0,0,0,83400]
[null,null,"Equipment Expense",null,0]
[null,null,"Total Software / Equip / Maint.",null,1500]
[null,"Total Fixed Cost",null,null,124850]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Self Estimation"]
[null,"Staff Development:","Master Training",null,0]
[null,null,"Leader Training",null,0]
[null,"Staff Development:","Master Training",null,{"$error":"#REF!"}]
[null,null,"Leader Training",null,{"$error":"#REF!"}]

{"sheet":"All Workshop Costs","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"All Workshop Costs"]
[null,"CDSMP Workshop Leader Costs"]
[null,"Assumed Hourly Workshop Compensation Leader Type 1",0]
[null,"Assumed Hourly Workshop Compensation Leader Type 2",0]
[null,"Total Workshop All Leader Payments",0]
[null,"Gifts and honoraria to Volunteer Leaders (All)",0]
[null,"Leader Transportation (All)",0]
[null,"Other Leader Costs (All)",0]
[null,"Total Workshop Leader Costs",0]
[]
[null,"Miscellaneous Workshop Costs"]
[null,"Room rental",0]
[null,"Charts and stands for charts",0]
[null,"Office supplies",0]
[null,"Books, tapes, videos, or CDs",1200]
[null,"Other costs",10636]
[null,"In Kind Cost"]
[null,"Total Miscellaneous Workshop Costs",11836]
[]
[null,"Per Participant (Variable) expense"]
[null,"Individual assessments",0]
[null,"Home visits",0]
[null,"Materials",0]
[null,"Total Variable expense per participant",0]
[]
[null,"All  Participant variable expense",0]
[null,"Total All Workshop Expenses",11836]

{"sheet":"Analysis","index":3,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Analysis"]
[null,"Summary Results"]
[null,"Annual Program Costs",136686]
[]
[]
[null,"Cost per Workshop",10514.307692307701]
[null,"Cost per Attendee",808.79289940828403]
[null,"Annual Revenues",50192.998670339599]
[null,"Grant and Other Funding",0]
[null,"Net Program Revenues",-86493.001329660401]
[]
[null,"Breakeven Magnitudes"]
[null,"Workshop Volume",35.401710339534503]
[null,"Enrollment per Workshop",35.401710339534503]
[null,"Reimbursement",84.987899999999996]
[null,"Grant Funding",86493.001300000004]
[]
[]
[]
[]
[]
[null,"Monte Carlo Results"]
[null,"Select Number of Runs","Net Program Revenues"]
[null,null,"Minimum",-90520.874100000001]
[null,null,"Maximum",-56439.5164]
[null,null,"Average",-76713.569105999995]
[null,null,"Std Deviation",7730.9720416355403]
[null,null,"Span",34081.3577]