{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["NPA Placements","CoDist List","Import Sheet - do not delete","Start Here","Worksheet C Summary","Medicaid Reimbursement Calc","Contract 1on1 Billing-Hourly","Contract 1on1Billing-Hourly (2)","Contract 1on1Billing-Daily","Contract 1on1Billing-Daily (2)","Current IEP-Staff Costs","Current IEP-Other Staff Costs","1st Prev. IEP-Staff Costs","1st Prev. IEP-Other Staff Costs","2nd Prev. IEP-Staff Costs","2nd Prev. IEP-Other Staff Costs","3rd Prev. IEP-Staff Costs","3rd Prev. IEP-Other Staff Costs","4th Prev. IEP-Staff Costs","4th Prev. IEP-Other Staff Costs","5th Prev. IEP-Staff Costs","5th Prev. IEP-Other Staff Costs","6th Prev. IEP-Staff Costs","6th Prev. IEP-Other Staff Costs","ESY-Staff Costs","ESY-Other Staff Costs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":1,"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":"NPA Placements","index":0,"n_rows":150,"n_cols":1,"rows_kept":150,"cut":false,"hidden":true,"merged":[]}
["Out of District Placement/Program"]
["49th Street Academy"]
["Academy for Precision Learning"]
["Academy Schools"]
["Acadia Montana"]
["Arata Creek School"]
["Arlington S D"]
["Ashcreek Ranch Academy"]
["Auburn S D"]
["Bancroft"]
["Bayes Achievement Center"]
["Bellevue S D"]
["Bellefair/Monarch (Ohio)"]
["Benchmark Behavioral Health"]
["Bethel S D"]
["Boys Town"]
["Bremerton S D"]
["Brightmont Academy"]
["Brock's Academy"]
["CALO Residential Center"]
["Carpe Diem Academy"]
["CCDHL"]
["Central Kitsap S D"]
["Centralia S D"]
["Chehalis S D"]
["Cherry Gulch Inc"]
["CHILD"]
["Cinnamon Hills"]
["Clover Park S D"]
["Dartmoor"]
["Daybreak Canyon LLC"]
["Devereux Colorado"]
["Devereux Texas"]
["Diamond Ranch Academy"]
["Discovery Behavior Solutions"]
["Discovery Ranch for Girls"]
["Dolan Learning Center"]
["Eastside Academics School"]
["Eaton Arrowsmith School"]
["Edmonds S D"]
["Elevations LLC"]
["Ellensburg S D"]
["Entrust Community Services"]
["ESD 112 Steps"]
["Excelsior Holistic Schools"]
["Family House Academy"]
["Federal Way S D"]
["Fir Grove"]
["Fulshear Treatment to Transition"]
["Gateway Academy"]
["Gersh Academy"]
["Grafton"]
["Heartspring"]
["Heritage"]
["High Frontier"]
["Highline S D"]
["iCan"]
["Imperial Healing Estate"]
["Intermountain Children's Home"]
["Kaizen Academy"]
["Kitsap Mental Health"]
["Lakemary Center"]
["Leadership Preparatory Academy"]
["Lehman Learning"]
["Liahona Academy"]
["Lilac City Behavioral Services"]
["Lindamood Bell"]
["Listen & Talk"]
["Littleton Academy Residential School"]
["Logan River Academy"]
["Lourdes Children's Day Program"]
["Madrona Day Treatment"]
["Maple Lake Academy"]
["Mason County Special Services"]
["Monarch Center for Autism"]
["Montesano S D"]
["Morningside Academy"]
["Mount Vernon S D"]
["Mountain Springs Preparatory Academy"]
["New England Center for Children"]
["New Focus Academy"]
["New Haven Residential Treatment Center"]
["New Horizon School"]
["Newbridge Learning Academy"]
["North Wasco County School District, Wahtonka Campus - Transition 21"]
["Northwest Childrens Home, Education Center"]
["NWESD 189"]
["NWRLC"]
["NWSDHH"]
["NWSHIC"]
["NWSOIL"]
["Oak Harbor S D"]
["OESD 114 DHH Program"]
["Olympic Academy"]
["Onalaska S D"]
["Overlake"]
["Pasco S D"]
["Pine Ridge Academy"]
["Piney Ridge"]
["PLC"]
["Pressley Ridge School for the Deaf"]
["Provo Canyon"]
["Puyallup S D"]
["Quest Academy"]
["Redcliff Ascent"]
["Relife"]
["Renton Academy"]
["Renton S D"]
["Ridgefield S D"]
["Ryther"]
["Salish Sea Deaf School"]
["Seattle S D"]
["Sedro Woolley S D"]
["Serendipity Center"]
["Shrub Oak International School"]
["Skagit Discovery"]
["Skagit INVEST Program"]
["Snohomish Discovery"]
["Snohomish S D"]
["Solacium Fulshear"]
["Solacium Sunrise"]
["Solstice RTC"]
["Spokane S D"]
["STEPS - ESD 112"]
["Sumner S D"]
["Sunnyside S D"]
["Tacoma S D"]
["Telos Academy"]
["The King's Daughter's School"]
["Three Points Center"]
["Toledo S D"]
["Triumph Academy"]
["University of Utah CAT Program"]
["Viewpoint"]
["Villa Santa Maria"]
["WA Center for Deaf and Hard of Hearing Youth"]
["WA State School for the Deaf"]
["WA Vocational Services"]
["Washougal S D"]
["Waterfall Canyon Academy"]
["Waypoint Academy"]
["Wediko School"]
["Whatcom Discovery"]
["Wheatley School"]
["White River S D"]
["Woodland S D"]
["Woods"]
["Yellow Wood Academy"]
["Yelm S D"]
["Youth Care Treatment Center"]

{"sheet":"CoDist List","index":1,"n_rows":316,"n_cols":3,"rows_kept":316,"cut":false,"hidden":false,"merged":[]}
["14005","113","Aberdeen"]
["21226","113","Adna"]
["22017","101","Almira"]
["29103","189","Anacortes"]
["31016","189","Arlington"]
["02420","123","Asotin-Anatone"]
["17408","121","Auburn"]
["18303","121","Bainbridge Island"]
["06119","112","Battle Ground"]
["17405","121","Bellevue"]
["37501","189","Bellingham"]
["01122","101","Benge"]
["27403","121","Bethel"]
["20203","105","Bickleton"]
["37503","189","Blaine"]
["21234","113","Boistfort"]
["18100","114","Bremerton"]
["24111","171","Brewster "]
["09075","171","Bridgeport"]
["16046","114","Brinnon"]
["29100","189","Burlington-Edison"]
["06117","112","Camas"]
["05401","114","Cape Flattery"]
["27019","121","Carbonado"]
["04228","171","Cascade"]
["04222","171","Cashmere"]
["08401","112","Castle Rock"]
["18901","114","Catalyst Charter"]
["20215","112","Centerville"]
["18401","114","Central Kitsap"]
["32356","101","Central Valley"]
["21401","113","Centralia"]
["21302","113","Chehalis"]
["32360","101","Cheney"]
["33036","101","Chewelah"]
["16049","114","Chimacum"]
["02250","123","Clarkston"]
["19404","105","Cle Elum - Roslyn"]
["27400","121","Clover Park "]
["38300","101","Colfax"]
["36250","123","College Place"]
["38306","101","Colton"]
["33206","101","Columbia No. 206 (Stevens)"]
["36400","123","Columbia No. 400 (Walla Walla)"]
["33115","101","Colville"]
["29011","189","Concrete"]
["29317","189","Conway"]
["14099","113","Cosmopolis"]
["13151","171","Coulee-Hartline"]
["15204","189","Coupeville"]
["05313","114","Crescent"]
["22073","101","Creston"]
["10050","101","Curlew"]
["26059","101","Cusick"]
["19007","105","Damman"]
["31330","189","Darrington"]
["22207","101","Davenport"]
["07002","123","Dayton"]
["32414","101","Deer Park"]
["27343","121","Dieringer"]
["36101","123","Dixie"]
["32361","101","East Valley No. 361 (Spokane)"]
["39090","105","East Valley No. 90 (Yakima)"]
["09206","171","Eastmont"]
["19028","105","Easton"]
["27404","121","Eatonville"]
["31015","189","Edmonds"]
["19401","105","Ellensburg"]
["14068","113","Elma"]
["38308","101","Endicott"]
["04127","171","Entiat"]
["17216","121","Enumclaw"]
["13165","171","Ephrata"]
["06701","112","ESA 112"]
["21036","113","Evaline"]
["31002","189","Everett"]
["06114","112","Evergreen No. 114 (Clark)"]
["33205","101","Evergreen No. 205 (Stevens)"]
["17210","121","Federal Way"]
["37502","189","Ferndale"]
["27417","121","Fife"]
["03053","123","Finley"]
["27402","121","Franklin Pierce"]
["32358","101","Freeman"]
["38302","101","Garfield"]
["20401","112","Glenwood"]
["20404","105","Goldendale"]
["13301","171","Grand Coulee Dam"]
["39200","105","Grandview"]
["39204","105","Granger"]
["31332","189","Granite Falls"]
["23054","113","Grapeview"]
["32312","101","Great Northern"]
["06103","112","Green Mountain"]
["34324","113","Griffin"]
["22204","101","Harrington"]
["39203","105","Highland"]
["17401","121","Highline"]
["06098","112","Hockinson"]
["23404","113","Hood Canal"]
["14028","113","Hoquiam"]
["27902","121","Impact Commencement Bay Charter"]
["17911","121","Impact Puget Sound Elem Charter"]
["17916","121","Impact Salish Sea Charter"]
["10070","101","Inchelium"]
["31063","189","Index"]
["36901","123","Innovation Charter School (Willow)"]
["17411","121","Issaquah"]
["11056","123","Kahlotus"]
["08402","112","Kalama"]
["10003","101","Keller"]
["08458","112","Kelso"]
["03017","123","Kennewick"]
["17415","121","Kent"]
["33212","101","Kettle Falls"]
["03052","123","Kiona-Benton"]
["19403","105","Kittitas"]
["20402","112","Klickitat"]
["06101","112","La Center"]
["29311","189","La Conner"]
["38126","101","LaCrosse"]
["04129","171","Lake Chelan"]
["14097","113","Lake Quinault"]
["31004","189","Lake Stevens"]
["17414","121","Lake Washington"]
["31306","189","Lakewood"]
["38264","101","Lamont"]
["32362","101","Liberty"]
["01158","101","Lind"]
["08122","112","Longview"]
["33183","101","Loon Lake"]
["28144","189","Lopez Island"]
["32903","101","Lumen Charter"]
["20406","112","Lyle"]
["37504","189","Lynden"]
["39120","105","Mabton"]
["09207","171","Mansfield"]
["04019","171","Manson"]
["23311","113","Mary M Knight"]
["33207","101","Mary Walker"]
["31025","189","Marysville"]
["14065","113","McCleary"]
["32354","101","Mead"]
["32326","101","Medical Lake"]
["17400","121","Mercer Island"]
["37505","189","Meridian"]
["24350","171","Methow Valley"]
["30031","112","Mill A"]
["31103","189","Monroe"]
["14066","113","Montesano"]
["21214","113","Morton"]
["13161","171","Moses Lake"]
["21206","113","Mossyrock"]
["39209","105","Mount Adams"]
["37507","189","Mount Baker "]
["30029","112","Mount Pleasant"]
["29320","189","Mount Vernon"]
["31006","189","Mukilteo"]
["39003","105","Naches Valley"]
["21014","113","Napavine"]
["25155","112","Naselle-Grays River"]
["24014","171","Nespelem"]
["26056","101","Newport"]
["32325","101","Nine Mile Falls"]
["37506","189","Nooksack Valley"]
["14064","113","North Beach"]
["11051","123","North Franklin"]
["18400","114","North Kitsap"]
["23403","114","North Mason"]
["25200","113","North River"]
["34003","113","North Thurston"]
["33211","101","Northport"]
["17417","121","Northshore"]
["15201","189","Oak Harbor"]
["38324","101","Oakesdale"]
["14400","113","Oakville"]
["25101","112","Ocean Beach"]
["14172","113","Ocosta"]
["22105","101","Odessa"]
["24105","171","Okanogan"]
["34111","113","Olympia"]
["24019","171","Omak"]
["21300","113","Onalaska"]
["33030","101","Onion Creek"]
["28137","189","Orcas Island"]
["32123","101","Orchard Prairie"]
["10065","101","Orient"]
["09013","171","Orondo"]
["24410","171","Oroville"]
["27344","121","Orting"]
["01147","123","Othello"]
["09102","171","Palisades"]
["38301","101","Palouse"]
["11001","123","Pasco"]
["24122","171","Pateros"]
["03050","123","Paterson"]
["21301","113","Pe Ell"]
["27401","121","Peninsula"]
["04901","171","Pinnacles Prep Charter"]
["23402","113","Pioneer"]
["12110","123","Pomeroy"]
["05121","114","Port Angeles"]
["16050","114","Port Townsend"]
["36402","123","Prescott"]
["32907","101","Pride Prep Charter"]
["03116","123","Prosser"]
["38267","101","Pullman"]
["38901","101","Pullman Community Montessori Charter"]
["27003","121","Puyallup"]
["16020","114","Queets-Clearwater"]
["16048","114","Quilcene"]
["05402","114","Quillayute Valley"]
["13144","171","Quincy"]
["34307","113","Rainier"]
["17908","121","Rainier Prep Charter"]
["17910","121","Rainier Valley Leadership Acad Charter"]
["25116","113","Raymond"]
["22009","101","Reardan-Edwall"]
["17403","121","Renton"]
["10309","101","Republic"]
["03400","123","Richland"]
["06122","112","Ridgefield"]
["01160","101","Ritzville"]
["32416","101","Riverside"]
["17407","121","Riverview"]
["34401","113","Rochester"]
["20403","112","Roosevelt"]
["38320","101","Rosalia"]
["13160","105","Royal"]
["38322","101","Saint John"]
["28149","189","San Juan Island"]
["14104","113","Satsop"]
["17001","121","Seattle"]
["29101","189","Sedro-Woolley"]
["39119","105","Selah"]
["26070","101","Selkirk"]
["05323","114","Sequim"]
["28010","189","Shaw Island"]
["23309","113","Shelton"]
["17412","121","Shoreline"]
["30002","112","Skamania"]
["17404","121","Skykomish"]
["31201","189","Snohomish"]
["17410","121","Snoqualmie Valley"]
["13156","171","Soap Lake"]
["25118","113","South Bend"]
["18402","114","South Kitsap"]
["15206","189","South Whidbey"]
["23042","113","Southside"]
["32081","101","Spokane"]
["32901","101","Spokane International Academy Charter"]
["22008","101","Sprague"]
["31401","189","Stanwood-Camano"]
["11054","123","Star"]
["07035","123","Starbuck"]
["04069","171","Stehekin"]
["27001","121","Steilacoom Historical"]
["38304","101","Steptoe"]
["30303","112","Stevenson-Carson"]
["31311","189","Sultan"]
["17905","121","Summit Atlas Charter"]
["27905","121","Summit Olympus Charter"]
["17902","121","Summit Sierra Charter"]
["33202","101","Summit Valley"]
["27320","121","Sumner-Bonney Lake"]
["39201","105","Sunnyside"]
[18902,"900","Suquamish Tribal Education Department"]
["27010","121","Tacoma"]
["14077","113","Taholah"]
["17409","121","Tahoma"]
["38265","101","Tekoa"]
["34402","113","Tenino"]
["19400","105","Thorp"]
["21237","113","Toledo"]
["24404","171","Tonasket"]
["39202","105","Toppenish"]
["36300","123","Touchet"]
["08130","112","Toutle Lake"]
["20400","112","Trout Lake"]
["17406","121","Tukwila"]
["34033","113","Tumwater"]
["39002","105","Union Gap"]
["27083","121","University Place"]
["33070","101","Valley"]
["06037","112","Vancouver"]
["17402","121","Vashon Island"]
[34974,"900","WA State School for the Blind"]
[34975,"900","WA State School for the Deaf (CDHY)"]
["35200","112","Wahkiakum"]
["13073","105","Wahluke"]
["36401","123","Waitsburg"]
["36140","123","Walla Walla"]
["39207","105","Wapato"]
["13146","171","Warden"]
["06112","112","Washougal"]
["01109","101","Washtucna"]
["09209","171","Waterville"]
["33049","101","Wellpinit"]
["04246","171","Wenatchee"]
["39208","105","West Valley No. 208 (Yakima)"]
["32363","101","West Valley No. 363 (Spokane)"]
["37902","189","Whatcom Intergenerational Charter"]
["21303","113","White Pass"]
["27416","121","White River"]
["20405","112","White Salmon"]
["17917","121","Why Not You Academy Charter"]
["22200","101","Wilbur"]
["25160","113","Willapa Valley"]
["13167","171","Wilson Creek"]
["21232","113","Winlock"]
["14117","113","Wishkah Valley"]
["20094","112","Wishram"]
["08404","112","Woodland"]
["39007","105","Yakima"]
["34002","113","Yelm"]
["39205","105","Zillah"]

{"sheet":"Import Sheet - do not delete","index":2,"n_rows":2,"n_cols":99,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["CoDist","ESD","District","SSID","DOB","Age","Grade","Disability","MedicaidEligibility","EvalDate","IEPDate","SchoolName","Complaint","TeacherName1","Teacher1Cost","TeacherName2","Teacher2Cost","TeacherName3","Teacher3Cost","Para1Name","Para1Position","Para1Cost","Para2Name","Para2Position","Para2Cost","Para3Name","Para3Position","Para3Cost","Para4Name","Para4Position","Para4Cost","Para5Name","Para5Position","Para5Cost","Para6Name","Para6Position","Para6Cost","Contracted1on1Name1Hrly","Contracted1on1Position1Hrly","Contracted1on1Cost1Hrly","Contracted1on1Name2Hrly","Contracted1on1Position2Hrly","Contracted1on1Cost2Hrly","Contracted1on1Name1Daily","Contracted1on1Position1Daily","Contracted1on1Cost1Daily","Contracted1on1Name2Daily","Contracted1on1Position2Daily","Contracted1on1Cost2Daily","RelatedSvc1","RelatedSvc1Name","RelatedSvc1Cost","RelatedSvc2","RelatedSvc2Name","RelatedSvc2Cost","RelatedSvc3","RelatedSvc3Name","RelatedSvc3Cost","RelatedSvc4","RelatedSvc4Name","RelatedSvc4Cost","RelatedSvc5","RelatedSvc5Name","RelatedSvc5Cost","ContRelatedSvc1","ContRelatedSvc1Name","ContRelatedSvc1Cost","ContRelatedSvc2","ContRelatedSvc2Name","ContRelatedSvc2Cost","ContRelatedSvc3","ContRelatedSvc3Name","ContRelatedSvc3Cost","ContRelatedSvc4","ContRelatedSvc4Name","ContRelatedSvc4Cost","ContRelatedSvc5","ContRelatedSvc5Name","ContRelatedSvc5Cost","OutofDistPlacementName1","OutofDistPlacement1Cost","OutofDistPlacementName2","OutofDistPlacement2Cost","OutofDistPlacementName3","OutofDistPlacement3Cost","ESYOutofDistPlacementName","ESYOutofDistPlacementCost","TransportationRYCost","TransportationESYCost","InDistrictESYCost","EquipSuppliesDescription","EquipSuppliesCost","AsstTechDescription","AsstTechCost","OtherDescription","OtherCost","Threshold","MedicaidRevenue","TotalRequest"]
[{"$f":"IFERROR(IF('Start Here'!K2=0,\"\",'Start Here'!K2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('Start Here'!K2,'CoDist List'!$A$1:$C$312,2,0),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C3=0,\"\",'Worksheet C Summary'!C3),\"\")","v":" "},{"$f":"IFERROR(IF('Start Here'!K3=0,\"\",'Start Here'!K3),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C5=0,\"\",'Worksheet C Summary'!C5),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C6=0,\"\",'Worksheet C Summary'!C6),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C8=0,\"\",'Worksheet C Summary'!C8),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C7=0,\"\",'Worksheet C Summary'!C7),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C9=0,\"\",'Worksheet C Summary'!C9),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C10=0,\"\",'Worksheet C Summary'!C10),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C11=0,\"\",'Worksheet C Summary'!C11),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C14=0,\"\",'Worksheet C Summary'!C14),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K13=0,\"\",'Worksheet C Summary'!K13),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B16=0,\"\",'Worksheet C Summary'!B16),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K16=0,\"\",'Worksheet C Summary'!K16),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B17=0,\"\",'Worksheet C Summary'!B17),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K17=0,\"\",'Worksheet C Summary'!K17),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B18=0,\"\",'Worksheet C Summary'!B18),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K18=0,\"\",'Worksheet C Summary'!K18),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B20=0,\"\",'Worksheet C Summary'!B20),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E20=0,\"\",'Worksheet C Summary'!E20),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K20=0,\"\",'Worksheet C Summary'!K20),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B21=0,\"\",'Worksheet C Summary'!B21),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E21=0,\"\",'Worksheet C Summary'!E21),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K21=0,\"\",'Worksheet C Summary'!K21),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B22=0,\"\",'Worksheet C Summary'!B22),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E22=0,\"\",'Worksheet C Summary'!E22),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K22=0,\"\",'Worksheet C Summary'!K22),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B23=0,\"\",'Worksheet C Summary'!B23),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E23=0,\"\",'Worksheet C Summary'!E23),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K23=0,\"\",'Worksheet C Summary'!K23),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B24=0,\"\",'Worksheet C Summary'!B24),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E24=0,\"\",'Worksheet C Summary'!E24),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K24=0,\"\",'Worksheet C Summary'!K24),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B25=0,\"\",'Worksheet C Summary'!B25),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E25=0,\"\",'Worksheet C Summary'!E25),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K25=0,\"\",'Worksheet C Summary'!K25),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B27=0,\"\",'Worksheet C Summary'!B27),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E27=0,\"\",'Worksheet C Summary'!E27),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K27=0,\"\",'Worksheet C Summary'!K27),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B28=0,\"\",'Worksheet C Summary'!B28),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E28=0,\"\",'Worksheet C Summary'!E28),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K28=0,\"\",'Worksheet C Summary'!K28),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B29=0,\"\",'Worksheet C Summary'!B29),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E29=0,\"\",'Worksheet C Summary'!E29),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K29=0,\"\",'Worksheet C Summary'!K29),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B30=0,\"\",'Worksheet C Summary'!B30),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!E30=0,\"\",'Worksheet C Summary'!E30),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K30=0,\"\",'Worksheet C Summary'!K30),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B32=0,\"\",'Worksheet C Summary'!B32),\"\")","v":"SLP"},{"$f":"IFERROR(IF('Worksheet C Summary'!D32=0,\"\",'Worksheet C Summary'!D32),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K32=0,\"\",'Worksheet C Summary'!K32),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B33=0,\"\",'Worksheet C Summary'!B33),\"\")","v":"OT"},{"$f":"IFERROR(IF('Worksheet C Summary'!D33=0,\"\",'Worksheet C Summary'!D33),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K33=0,\"\",'Worksheet C Summary'!K33),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B34=0,\"\",'Worksheet C Summary'!B34),\"\")","v":"PT"},{"$f":"IFERROR(IF('Worksheet C Summary'!D34=0,\"\",'Worksheet C Summary'!D34),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K34=0,\"\",'Worksheet C Summary'!K34),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B35=0,\"\",'Worksheet C Summary'!B35),\"\")","v":"VI"},{"$f":"IFERROR(IF('Worksheet C Summary'!D35=0,\"\",'Worksheet C Summary'!D35),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K35=0,\"\",'Worksheet C Summary'!K35),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B36=0,\"\",'Worksheet C Summary'!B36),\"\")","v":"Other, please select"},{"$f":"IFERROR(IF('Worksheet C Summary'!D36=0,\"\",'Worksheet C Summary'!D36),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K36=0,\"\",'Worksheet C Summary'!K36),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B38=0,\"\",'Worksheet C Summary'!B38),\"\")","v":"SLP"},{"$f":"IFERROR(IF('Worksheet C Summary'!D38=0,\"\",'Worksheet C Summary'!D38),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K38=0,\"\",'Worksheet C Summary'!K38),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B39=0,\"\",'Worksheet C Summary'!B39),\"\")","v":"OT"},{"$f":"IFERROR(IF('Worksheet C Summary'!D39=0,\"\",'Worksheet C Summary'!D39),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K39=0,\"\",'Worksheet C Summary'!K39),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B40=0,\"\",'Worksheet C Summary'!B40),\"\")","v":"PT"},{"$f":"IFERROR(IF('Worksheet C Summary'!D40=0,\"\",'Worksheet C Summary'!D40),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K40=0,\"\",'Worksheet C Summary'!K40),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B41=0,\"\",'Worksheet C Summary'!B41),\"\")","v":"VI"},{"$f":"IFERROR(IF('Worksheet C Summary'!D41=0,\"\",'Worksheet C Summary'!D41),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K41=0,\"\",'Worksheet C Summary'!K41),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!B42=0,\"\",'Worksheet C Summary'!B42),\"\")","v":"Other, please select"},{"$f":"IFERROR(IF('Worksheet C Summary'!D42=0,\"\",'Worksheet C Summary'!D42),\"\")","v":" "},{"$f":"IFERROR(IF('Worksheet C Summary'!K42=0,\"\",'Worksheet C Summary'!K42),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C44=0,\"\",'Worksheet C Summary'!C44),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K44=0,\"\",'Worksheet C Summary'!K44),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C45=0,\"\",'Worksheet C Summary'!C45),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K45=0,\"\",'Worksheet C Summary'!K45),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C46=0,\"\",'Worksheet C Summary'!C46),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K46=0,\"\",'Worksheet C Summary'!K46),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!C47=0,\"\",'Worksheet C Summary'!C47),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K47=0,\"\",'Worksheet C Summary'!K47),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K49=0,\"\",'Worksheet C Summary'!K49),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K50=0,\"\",'Worksheet C Summary'!K50),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K52=0,\"\",'Worksheet C Summary'!K52),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!D53=0,\"\",'Worksheet C Summary'!D53),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K53=0,\"\",'Worksheet C Summary'!K53),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!D54=0,\"\",'Worksheet C Summary'!D54),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K54=0,\"\",'Worksheet C Summary'!K54),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!D55=0,\"\",'Worksheet C Summary'!D55),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K55=0,\"\",'Worksheet C Summary'!K55),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K60=0,\"\",'Worksheet C Summary'!K60),\"\")","v":37599},{"$f":"IFERROR(IF('Worksheet C Summary'!K61=0,\"\",'Worksheet C Summary'!K61),\"\")","v":""},{"$f":"IFERROR(IF('Worksheet C Summary'!K63=0,\"\",'Worksheet C Summary'!K63),\"\")","v":""}]

{"sheet":"Start Here","index":3,"n_rows":111,"n_cols":27,"rows_kept":111,"cut":false,"hidden":false,"merged":[[95,0,95,12],[96,0,96,4],[97,0,98,12],[99,0,99,12],[90,0,90,10],[90,11,90,12],[91,0,91,12],[92,0,92,12],[94,0,94,3],[11,16,16,25],[1,10,1,12],[66,0,66,3],[67,0,67,12],[69,0,70,12],[7,16,7,24],[9,16,9,25],[36,0,36,12],[10,0,10,3],[27,0,28,12],[41,0,42,12],[55,0,56,12],[63,0,63,12],[64,0,64,12],[39,0,39,12],[49,0,49,12],[110,0,111,12],[108,0,108,12],[109,0,109,4],[104,0,104,10],[104,11,104,12],[105,0,105,12],[107,0,107,3],[71,0,71,12],[6,11,6,12],[8,0,8,12],[68,0,68,4],[38,0,38,3],[62,0,62,10],[62,11,62,12],[53,0,53,12],[54,0,54,4],[52,0,52,3],[35,0,35,12],[57,0,57,12],[26,0,26,4],[29,0,29,12],[34,0,34,10],[34,11,34,12],[50,0,50,12],[48,0,48,10],[48,11,48,12],[40,0,40,4],[43,0,43,12],[0,13,0,15],[24,0,24,3],[25,0,25,12],[1,1,1,5],[15,0,15,12],[20,0,20,10],[20,11,20,12],[21,0,21,12],[11,0,11,12],[12,0,12,4],[7,0,7,12],[13,0,14,12],[22,0,22,12],[0,0,0,12],[2,10,2,12],[6,0,6,10],[81,0,81,12],[82,0,82,4],[83,0,84,12],[85,0,85,12],[76,0,76,10],[76,11,76,12],[77,0,77,12],[78,0,78,12],[80,0,80,3]]}
["Worksheet C",null,null,null,null,null,null,null,null,null,null,null,null,"Number of days check",null,null,null,"Tip: Save this file as a macro enabled workbook."]
["Step 1:","Complete the Worksheet C Summary",null,null,null,null,null,null,null,"CoDist",null,null,null,null,"Number of days in school year",{"$f":"SUM(O9:O19)","v":0}]
["Enter IEP information for each student in cells shaded green. ",null,null,null,null,null,null,null,null,"SSID Number",null,null,null,null,"Number of days student enrolled",{"$f":"L7+L21+L35+L49+L63+L77+L91","v":0},{"$f":"IF(P3>180,\"The number of days the student was served cannot be greater than 180.\",IF(P3>P2,\"The number of days the student was served cannot be greater than the number of days in the school year.\",\"\"))","v":""}]
["NOTE:  Many of the fields on this worksheet have drop down or predefined lists."]
[]
["Step 2:","Current IEP"]
["Enter the number of days the resident student is served with the Current IEP in 2022–23 school year.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P9:P19)","v":0},null,"mm/dd/yyyy","to","mm/dd/yyyy","These grids (columns N-P) are optional. To use:"]
["Note: Sum of the Current IEP number of days and the four Previous IEPs number of days should equal the number of days in the school year, unless there is a lapse in service between IEPs.",null,null,null,null,null,null,null,null,null,null,null,null,"Month","# of Days (per calendar)","# of Days student enrolled","1. Fill in the number of days from the LEA's calendar in column O. Adding the number of days from the LEA's calendar here will autofill the tables below for the previous IEPs. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-19",null,null,"2. Then enter the number of days the student is served each month during the current IEP.",null,null,null,null,null,null,null,null,null,{"$f":"P9+P23+P37+P51+P65+P79+P93","v":0}]
["For the student's Current IEP, enter:",null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",null,null,"3. In the grid below, enter the number of days the student is served each month during the previous IEP.",null,null,null,null,null,null,null,null,null,0]
["Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",null,null,"4. The number of days in each grid should total the number of days in the school year.",null,null,null,null,null,null,null,null,null,0]
["Includes information regarding the Special Education teacher and the Classified staff serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",null,null,"Tips: \nIf you choose to use these grids, it would be a good idea to fill in the number of days per the LEA calendar and save the Worksheet C before you start creating Worksheet Cs for individual student applications. That way, you will only need to enter the calendar information once.\nIf the total number of days entered for each month is greater than the number of days in the month (per calendar), the cells will turn red.",null,null,null,null,null,null,null,null,null,0]
["Other Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Step 3:","1st Previous IEP"]
["Enter the number of days the resident student is served with the 1st Previous IEP in 2022–23 school year.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P23:P33)","v":0},null,"mm/dd/yyyy","to","mm/dd/yyyy"]
["Note: Sum of the Current IEP number of days and the four Previous IEPs number of days should equal the number of days in the school year, unless there is a lapse in service between IEPs.",null,null,null,null,null,null,null,null,null,null,null,null,"Month","# of Days (per calendar)","# of Days student enrolled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-19",{"$f":"$O$9","v":0}]
["For the student's 1st Previous IEP, enter:",null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",{"$f":"$O$10","v":0}]
["Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",{"$f":"$O$11","v":0}]
["Includes information regarding the Special Education teacher and the Classified staff serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",{"$f":"$O$12","v":0}]
["Other Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",{"$f":"$O$13","v":0}]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",{"$f":"$O$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",{"$f":"$O$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",{"$f":"$O$16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",{"$f":"$O$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",{"$f":"$O$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",{"$f":"$O$19","v":0}]
["Step 4: ","2nd Previous IEP"]
["Enter the number of days the resident student is served with the 2nd Previous IEP in 2022–23 school year.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P37:P47)","v":0},null,"mm/dd/yyyy","to","mm/dd/yyyy"]
["Note: Sum of the Current IEP number of days and the four Previous IEPs number of days should equal the number of days in the school year, unless there is a lapse in service between IEPs.",null,null,null,null,null,null,null,null,null,null,null,null,"Month","# of Days (per calendar)","# of Days student enrolled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-19",{"$f":"$O$9","v":0}]
["For the student's 2nd Previous IEP, enter:",null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",{"$f":"$O$10","v":0}]
["Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",{"$f":"$O$11","v":0}]
["Includes information regarding the Special Education teacher and the Classified staff serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",{"$f":"$O$12","v":0}]
["Other Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",{"$f":"$O$13","v":0}]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",{"$f":"$O$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",{"$f":"$O$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",{"$f":"$O$16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",{"$f":"$O$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",{"$f":"$O$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",{"$f":"$O$19","v":0}]
["Step 5: ","3rd Previous IEP"]
["Enter the number of days the resident student is served with the 3rd Previous IEP in 2022–23 school year.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P51:P61)","v":0},null,"mm/dd/yyyy","to","mm/dd/yyyy"]
["Note: Sum of the Current IEP number of days and the four Previous IEPs number of days should equal the number of days in the school year, unless there is a lapse in service between IEPs.",null,null,null,null,null,null,null,null,null,null,null,null,"Month","# of Days (per calendar)","# of Days student enrolled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-19",{"$f":"$O$9","v":0}]
["For the student's 3rd Previous IEP, enter:",null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",{"$f":"$O$10","v":0}]
["Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",{"$f":"$O$11","v":0}]
["Includes information regarding the Special Education teacher and the Classified staff serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",{"$f":"$O$12","v":0}]
["Other Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",{"$f":"$O$13","v":0}]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",{"$f":"$O$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",{"$f":"$O$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",{"$f":"$O$16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",{"$f":"$O$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",{"$f":"$O$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",{"$f":"$O$19","v":0}]
["Step 6:","4th Previous IEP"]
["Enter the number of days the resident student is served with the 4th previous IEP in 2022–23 school year.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P65:P75)","v":0},null,"mm/dd/yyyy","to","mm/dd/yyyy"]
["Note: Sum of the Current IEP number of days and the four Previous IEPs number of days should equal the number of days in the school year, unless there is a lapse in service between IEPs.",null,null,null,null,null,null,null,null,null,null,null,null,"Month","# of Days (per calendar)","# of Days student enrolled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-19",{"$f":"$O$9","v":0}]
["For the student's 4th Previous IEP, enter:",null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",{"$f":"$O$10","v":0}]
["Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",{"$f":"$O$11","v":0}]
["Includes information regarding the Special Education teacher and the Classified staff serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",{"$f":"$O$12","v":0}]
["Other Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",{"$f":"$O$13","v":0}]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",{"$f":"$O$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",{"$f":"$O$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",{"$f":"$O$16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",{"$f":"$O$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",{"$f":"$O$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",{"$f":"$O$19","v":0}]
["Step 7:","5th Previous IEP"]
["Enter the number of days the resident student is served with the 5th previous IEP in 2022–23 school year.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P79:P89)","v":0},null,"mm/dd/yyyy","to","mm/dd/yyyy"]
["Note: Sum of the Current IEP number of days and the four Previous IEPs number of days should equal the number of days in the school year, unless there is a lapse in service between IEPs.",null,null,null,null,null,null,null,null,null,null,null,null,"Month","# of Days (per calendar)","# of Days student enrolled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-19",{"$f":"$O$9","v":0}]
["For the student's 5th Previous IEP, enter:",null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",{"$f":"$O$10","v":0}]
["Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",{"$f":"$O$11","v":0}]
["Includes information regarding the Special Education teacher and the Classified staff serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",{"$f":"$O$12","v":0}]
["Other Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",{"$f":"$O$13","v":0}]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",{"$f":"$O$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",{"$f":"$O$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",{"$f":"$O$16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",{"$f":"$O$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",{"$f":"$O$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",{"$f":"$O$19","v":0}]
["Step 8:","6th Previous IEP"]
["Enter the number of days the resident student is served with the 6th previous IEP in 2022–23 school year.",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P93:P103)","v":0},null,"mm/dd/yyyy","to","mm/dd/yyyy"]
["Note: Sum of the Current IEP number of days and the four Previous IEPs number of days should equal the number of days in the school year, unless there is a lapse in service between IEPs.",null,null,null,null,null,null,null,null,null,null,null,null,"Month","# of Days (per calendar)","# of Days student enrolled"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-19",{"$f":"$O$9","v":0}]
["For the student's 6th Previous IEP, enter:",null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-01",{"$f":"$O$10","v":0}]
["Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-01",{"$f":"$O$11","v":0}]
["Includes information regarding the Special Education teacher and the Classified staff serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",{"$f":"$O$12","v":0}]
["Other Staff Cost information",null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-01",{"$f":"$O$13","v":0}]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student.",null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",{"$f":"$O$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",{"$f":"$O$15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-01",{"$f":"$O$16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-01",{"$f":"$O$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01",{"$f":"$O$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-01",{"$f":"$O$19","v":0}]
["Step 9:","ESY"]
["Enter the number of weeks the resident student is served in ESY in the  2022–23 school year."]
[]
["For the student's ESY costs, enter:"]
["Staff Cost information"]
["Includes information regarding the Special Education teacher and the Classified staff serving this student."]
["Other Staff Cost information"]
["Includes information regarding the in-district and contracted related service providers (SLP, OT, PT, VI etc.) serving this student."]

{"sheet":"Worksheet C Summary","index":4,"n_rows":63,"n_cols":19,"rows_kept":63,"cut":false,"hidden":false,"merged":[[12,0,12,9],[29,8,29,9],[15,1,15,7],[16,1,16,7],[17,1,17,7],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[28,1,28,3],[28,4,28,7],[26,4,26,7],[27,4,27,7],[24,1,24,3],[19,4,19,7],[20,4,20,7],[21,4,21,7],[22,4,22,7],[23,4,23,7],[24,4,24,7],[26,1,26,3],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[37,1,37,2],[59,1,59,8],[27,8,27,9],[31,3,31,7],[32,3,32,7],[33,3,33,7],[34,3,34,7],[35,3,35,7],[37,3,37,7],[39,1,39,2],[40,1,40,2],[41,1,41,2],[38,3,38,7],[39,3,39,7],[40,3,40,7],[41,3,41,7],[27,1,27,3],[28,8,28,9],[29,1,29,3],[29,4,29,7],[60,1,60,9],[61,1,61,9],[62,1,62,9],[52,1,52,2],[53,1,53,2],[54,1,54,2],[52,3,52,9],[53,3,53,9],[54,3,54,9],[56,0,56,10],[10,2,10,3],[19,8,19,9],[51,1,51,9],[16,8,16,9],[17,8,17,9],[55,1,55,9],[15,8,15,9],[22,8,22,9],[50,0,50,10],[30,0,30,10],[36,0,36,10],[18,0,18,10],[20,8,20,9],[21,8,21,9],[25,0,25,10],[41,8,41,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[38,1,38,2],[13,0,13,1],[13,2,13,7],[31,1,31,2],[3,14,4,14],[5,14,6,14],[9,0,9,1],[6,2,6,3],[7,2,7,3],[8,2,8,3],[47,0,47,10],[48,1,48,9],[49,1,49,9],[26,8,26,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[23,8,23,9],[24,8,24,9],[31,8,31,9],[10,0,10,1],[14,0,14,10],[2,4,10,10],[11,7,11,9],[11,0,11,5],[13,8,13,9],[9,2,9,3],[0,0,0,10],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[1,4,1,10],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,0,5,1],[5,2,5,3],[42,0,42,7],[42,8,42,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[43,2,43,7],[44,2,44,7],[45,2,45,7],[46,2,46,7],[46,8,46,9]]}
["2022–23 Worksheet C Summary",null,null,null,null,null,null,null,null,null,null,null,"Next Page: Current IEP - Staff Costs",null,null,null,null,"SNET due date","2023-03-10"]
["CoDist",null,{"$f":"IF('Start Here'!K2=0,\"\",'Start Here'!K2)","v":""},null,"Additional Comments",null,null,null,null,null,null,null,"Previous Page: Start Here",null,null,null,null,"Eval Date","2020-03-11"]
["District",null,{"$f":"IFERROR(VLOOKUP(C2,'CoDist List'!$A$1:$C$312,3,0),\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IEP Date","2022-03-11"]
["SSID",null,{"$f":"IF('Start Here'!K3=0,\"\",'Start Here'!K3)","v":""},null,null,null,null,null,null,null,null,null,null,"Notes:","Instructions for all application requirements can be found at https://www.k12.wa.us/policy-funding/special-education-funding-and-finance/how-apply-safety-net-funding.",null,null,"age (in days) as of IEP date",{"$f":"DATEDIF(C5,C11,\"d\")","v":0}]
["Date of Birth"]
["Age as of submission",null,{"$f":"IF(IF(C5=0,0,DATEDIF(C5,S1,\"y\"))=0,\"\",IF(C5=0,0,DATEDIF(C5,S1,\"y\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,"Submit applications through a Secure File Transfer Protocol (SFTP) site. All IEPs in effect for the 2022–23 school year must be included in the application submission.  ",null,null,null,"DD"]
["Disability Category",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBD"]
["Grade",null,null,null,null,null,null,null,null,null,null,null,null,null,"Costs claimed on the Worksheet C must be for the 2022–23 school year.",null,null,null,"OI"]
["Medicaid Eligibility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HI"]
["Last Evaluation Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLD"]
["Last IEP Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID"]
["Number of Days in Standard School year with Properly Formulated IEP",null,null,null,null,null,{"$f":"'Start Here'!L7+'Start Here'!L21+'Start Here'!L35+'Start Here'!L49+'Start Here'!L63+'Start Here'!L77+'Start Here'!L91","v":0},"Transition Plan Required?",null,null,{"$f":"IF((S4+364)>5840,\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,"MD"]
["Was student involved in a complaint or due process that included a corrective action plan?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deaf"]
["School Name\n(where student is served)",null,null,null,null,null,null,null,"Annual Hours for this Student",null,"Total Dollars Expended for this Student",null,null,null,null,null,null,null,"HH"]
["Special Education Certificated Staff (Special Education Teachers) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI"]
[1,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B8)=TRUE,'1st Prev. IEP-Staff Costs'!B8,'Current IEP-Staff Costs'!B8)","v":" "},null,null,null,null,null,null,{"$f":"(('Current IEP-Staff Costs'!B12*'Current IEP-Staff Costs'!B13/60)+('1st Prev. IEP-Staff Costs'!B12*'1st Prev. IEP-Staff Costs'!B13/60)+('2nd Prev. IEP-Staff Costs'!B12*'2nd Prev. IEP-Staff Costs'!B13/60)+('3rd Prev. IEP-Staff Costs'!B12*'3rd Prev. IEP-Staff Costs'!B13/60)+('4th Prev. IEP-Staff Costs'!B12*'4th Prev. IEP-Staff Costs'!B13/60)+('5th Prev. IEP-Staff Costs'!B12*'5th Prev. IEP-Staff Costs'!B13/60)+('6th Prev. IEP-Staff Costs'!B12*'6th Prev. IEP-Staff Costs'!B13/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!B15+'1st Prev. IEP-Staff Costs'!B15+'2nd Prev. IEP-Staff Costs'!B15+'3rd Prev. IEP-Staff Costs'!B15+'4th Prev. IEP-Staff Costs'!B15+'5th Prev. IEP-Staff Costs'!B15+'6th Prev. IEP-Staff Costs'!B15,0)","v":0},null,null,null,null,null,null,null,"Deaf-Blind"]
[2,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E8)=TRUE,'1st Prev. IEP-Staff Costs'!E8,'Current IEP-Staff Costs'!E8)","v":" "},null,null,null,null,null,null,{"$f":"(('Current IEP-Staff Costs'!E12*'Current IEP-Staff Costs'!E13/60)+('1st Prev. IEP-Staff Costs'!E12*'1st Prev. IEP-Staff Costs'!E13/60)+('2nd Prev. IEP-Staff Costs'!E12*'2nd Prev. IEP-Staff Costs'!E13/60)+('3rd Prev. IEP-Staff Costs'!E12*'3rd Prev. IEP-Staff Costs'!E13/60)+('4th Prev. IEP-Staff Costs'!E12*'4th Prev. IEP-Staff Costs'!E13/60)+('5th Prev. IEP-Staff Costs'!E12*'5th Prev. IEP-Staff Costs'!E13/60)+('6th Prev. IEP-Staff Costs'!E12*'6th Prev. IEP-Staff Costs'!E13/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!E15+'1st Prev. IEP-Staff Costs'!E15+'2nd Prev. IEP-Staff Costs'!E15+'3rd Prev. IEP-Staff Costs'!E15+'4th Prev. IEP-Staff Costs'!E15+'5th Prev. IEP-Staff Costs'!E15+'6th Prev. IEP-Staff Costs'!E15,0)","v":0},null,null,null,null,null,null,null,"CD"]
[3,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H8)=TRUE,'1st Prev. IEP-Staff Costs'!H8,'Current IEP-Staff Costs'!H8)","v":" "},null,null,null,null,null,null,{"$f":"(('Current IEP-Staff Costs'!H12*'Current IEP-Staff Costs'!H13/60)+('1st Prev. IEP-Staff Costs'!H12*'1st Prev. IEP-Staff Costs'!H13/60)+('2nd Prev. IEP-Staff Costs'!H12*'2nd Prev. IEP-Staff Costs'!H13/60)+('3rd Prev. IEP-Staff Costs'!H12*'3rd Prev. IEP-Staff Costs'!H13/60)+('4th Prev. IEP-Staff Costs'!H12*'4th Prev. IEP-Staff Costs'!H13/60)+('5th Prev. IEP-Staff Costs'!H12*'5th Prev. IEP-Staff Costs'!H13/60)+('6th Prev. IEP-Staff Costs'!H12*'6th Prev. IEP-Staff Costs'!H13/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!H15+'1st Prev. IEP-Staff Costs'!H15+'2nd Prev. IEP-Staff Costs'!H15+'3rd Prev. IEP-Staff Costs'!H15+'4th Prev. IEP-Staff Costs'!H15+'5th Prev. IEP-Staff Costs'!H15+'6th Prev. IEP-Staff Costs'!H15,0)","v":0},null,null,null,null,null,null,null,"Autism"]
["Special Education Classified Staff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TBI"]
[4,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B18)=TRUE,'1st Prev. IEP-Staff Costs'!B18,'Current IEP-Staff Costs'!B18)","v":" "},null,null,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B19)=TRUE,'1st Prev. IEP-Staff Costs'!B19,'Current IEP-Staff Costs'!B19)","v":" "},null,null,null,{"$f":"(('Current IEP-Staff Costs'!B21*'Current IEP-Staff Costs'!B22/60)+('1st Prev. IEP-Staff Costs'!B21*'1st Prev. IEP-Staff Costs'!B22/60)+('2nd Prev. IEP-Staff Costs'!B21*'2nd Prev. IEP-Staff Costs'!B22/60)+('3rd Prev. IEP-Staff Costs'!B21*'3rd Prev. IEP-Staff Costs'!B22/60)+('4th Prev. IEP-Staff Costs'!B21*'4th Prev. IEP-Staff Costs'!B22/60)+('5th Prev. IEP-Staff Costs'!B21*'5th Prev. IEP-Staff Costs'!B22/60)+('6th Prev. IEP-Staff Costs'!B21*'6th Prev. IEP-Staff Costs'!B22/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!B25+'1st Prev. IEP-Staff Costs'!B25+'2nd Prev. IEP-Staff Costs'!B25+'3rd Prev. IEP-Staff Costs'!B25+'4th Prev. IEP-Staff Costs'!B25+'5th Prev. IEP-Staff Costs'!B25+'6th Prev. IEP-Staff Costs'!B25,0)","v":0}]
[5,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E18)=TRUE,'1st Prev. IEP-Staff Costs'!E18,'Current IEP-Staff Costs'!E18)","v":" "},null,null,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E19)=TRUE,'1st Prev. IEP-Staff Costs'!E19,'Current IEP-Staff Costs'!E19)","v":" "},null,null,null,{"$f":"(('Current IEP-Staff Costs'!E21*'Current IEP-Staff Costs'!E22/60)+('1st Prev. IEP-Staff Costs'!E21*'1st Prev. IEP-Staff Costs'!E22/60)+('2nd Prev. IEP-Staff Costs'!E21*'2nd Prev. IEP-Staff Costs'!E22/60)+('3rd Prev. IEP-Staff Costs'!E21*'3rd Prev. IEP-Staff Costs'!E22/60)+('4th Prev. IEP-Staff Costs'!E21*'4th Prev. IEP-Staff Costs'!E22/60)+('5th Prev. IEP-Staff Costs'!E21*'5th Prev. IEP-Staff Costs'!E22/60)+('6th Prev. IEP-Staff Costs'!E21*'6th Prev. IEP-Staff Costs'!E22/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!E25+'1st Prev. IEP-Staff Costs'!E25+'2nd Prev. IEP-Staff Costs'!E25+'3rd Prev. IEP-Staff Costs'!E25+'4th Prev. IEP-Staff Costs'!E25+'5th Prev. IEP-Staff Costs'!E25+'6th Prev. IEP-Staff Costs'!E25,0)","v":0}]
[6,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H18)=TRUE,'1st Prev. IEP-Staff Costs'!H18,'Current IEP-Staff Costs'!H18)","v":" "},null,null,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H19)=TRUE,'1st Prev. IEP-Staff Costs'!H19,'Current IEP-Staff Costs'!H19)","v":" "},null,null,null,{"$f":"(('Current IEP-Staff Costs'!H21*'Current IEP-Staff Costs'!H22/60)+('1st Prev. IEP-Staff Costs'!H21*'1st Prev. IEP-Staff Costs'!H22/60)+('2nd Prev. IEP-Staff Costs'!H21*'2nd Prev. IEP-Staff Costs'!H22/60)+('3rd Prev. IEP-Staff Costs'!H21*'3rd Prev. IEP-Staff Costs'!H22/60)+('4th Prev. IEP-Staff Costs'!H21*'4th Prev. IEP-Staff Costs'!H22/60)+('5th Prev. IEP-Staff Costs'!H21*'5th Prev. IEP-Staff Costs'!H22/60)+('6th Prev. IEP-Staff Costs'!H21*'6th Prev. IEP-Staff Costs'!H22/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!H25+'1st Prev. IEP-Staff Costs'!H25+'2nd Prev. IEP-Staff Costs'!H25+'3rd Prev. IEP-Staff Costs'!H25+'4th Prev. IEP-Staff Costs'!H25+'5th Prev. IEP-Staff Costs'!H25+'6th Prev. IEP-Staff Costs'!H25,0)","v":0},null,null,null,null,null,null,null,"Y"]
[7,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B27)=TRUE,'1st Prev. IEP-Staff Costs'!B27,'Current IEP-Staff Costs'!B27)","v":" "},null,null,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B28)=TRUE,'1st Prev. IEP-Staff Costs'!B28,'Current IEP-Staff Costs'!B28)","v":" "},null,null,null,{"$f":"(('Current IEP-Staff Costs'!B30*'Current IEP-Staff Costs'!B31/60)+('1st Prev. IEP-Staff Costs'!B30*'1st Prev. IEP-Staff Costs'!B31/60)+('2nd Prev. IEP-Staff Costs'!B30*'2nd Prev. IEP-Staff Costs'!B31/60)+('3rd Prev. IEP-Staff Costs'!B30*'3rd Prev. IEP-Staff Costs'!B31/60)+('4th Prev. IEP-Staff Costs'!B30*'4th Prev. IEP-Staff Costs'!B31/60)+('5th Prev. IEP-Staff Costs'!B30*'5th Prev. IEP-Staff Costs'!B31/60)+('6th Prev. IEP-Staff Costs'!B30*'6th Prev. IEP-Staff Costs'!B31/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!B34+'1st Prev. IEP-Staff Costs'!B34+'2nd Prev. IEP-Staff Costs'!B34+'3rd Prev. IEP-Staff Costs'!B34+'4th Prev. IEP-Staff Costs'!B34+'5th Prev. IEP-Staff Costs'!B34+'6th Prev. IEP-Staff Costs'!B34,0)","v":0},null,null,null,null,null,null,null,"N"]
[8,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E27)=TRUE,'1st Prev. IEP-Staff Costs'!E27,'Current IEP-Staff Costs'!E27)","v":" "},null,null,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E28)=TRUE,'1st Prev. IEP-Staff Costs'!E28,'Current IEP-Staff Costs'!E28)","v":" "},null,null,null,{"$f":"(('Current IEP-Staff Costs'!E30*'Current IEP-Staff Costs'!E31/60)+('1st Prev. IEP-Staff Costs'!E30*'1st Prev. IEP-Staff Costs'!E31/60)+('2nd Prev. IEP-Staff Costs'!E30*'2nd Prev. IEP-Staff Costs'!E31/60)+('3rd Prev. IEP-Staff Costs'!E30*'3rd Prev. IEP-Staff Costs'!E31/60)+('4th Prev. IEP-Staff Costs'!E30*'4th Prev. IEP-Staff Costs'!E31/60)+('5th Prev. IEP-Staff Costs'!E30*'5th Prev. IEP-Staff Costs'!E31/60)+('6th Prev. IEP-Staff Costs'!E30*'6th Prev. IEP-Staff Costs'!E31/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!E34+'1st Prev. IEP-Staff Costs'!E34+'2nd Prev. IEP-Staff Costs'!E34+'3rd Prev. IEP-Staff Costs'!E34+'4th Prev. IEP-Staff Costs'!E34+'5th Prev. IEP-Staff Costs'!E34+'6th Prev. IEP-Staff Costs'!E34,0)","v":0}]
[9,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H27)=TRUE,'1st Prev. IEP-Staff Costs'!H27,'Current IEP-Staff Costs'!H27)","v":" "},null,null,{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H28)=TRUE,'1st Prev. IEP-Staff Costs'!H28,'Current IEP-Staff Costs'!H28)","v":" "},null,null,null,{"$f":"(('Current IEP-Staff Costs'!H30*'Current IEP-Staff Costs'!H31/60)+('1st Prev. IEP-Staff Costs'!H30*'1st Prev. IEP-Staff Costs'!H31/60)+('2nd Prev. IEP-Staff Costs'!H30*'2nd Prev. IEP-Staff Costs'!H31/60)+('3rd Prev. IEP-Staff Costs'!H30*'3rd Prev. IEP-Staff Costs'!H31/60)+('4th Prev. IEP-Staff Costs'!H30*'4th Prev. IEP-Staff Costs'!H31/60)+('5th Prev. IEP-Staff Costs'!H30*'5th Prev. IEP-Staff Costs'!H31/60)+('6th Prev. IEP-Staff Costs'!H30*'6th Prev. IEP-Staff Costs'!H31/60))","v":0},null,{"$f":"ROUND('Current IEP-Staff Costs'!H34+'1st Prev. IEP-Staff Costs'!H34+'2nd Prev. IEP-Staff Costs'!H34+'3rd Prev. IEP-Staff Costs'!H34+'4th Prev. IEP-Staff Costs'!H34+'5th Prev. IEP-Staff Costs'!H34+'6th Prev. IEP-Staff Costs'!H34,0)","v":0},null,null,null,null,null,null,null,"Yes"]
["Contracted 1:1 Provider (paraeducators, interpreters, nurses)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[10,{"$f":"IF(ISBLANK('Contract 1on1 Billing-Hourly'!D6)=TRUE,\" \",'Contract 1on1 Billing-Hourly'!D6)","v":" "},null,null,{"$f":"IF(ISBLANK('Contract 1on1 Billing-Hourly'!H6)=TRUE,\" \",'Contract 1on1 Billing-Hourly'!H6)","v":" "},null,null,null,{"$f":"(('Contract 1on1 Billing-Hourly'!C20*'Contract 1on1 Billing-Hourly'!E20/60)+('Contract 1on1 Billing-Hourly'!C21*'Contract 1on1 Billing-Hourly'!E21/60)+('Contract 1on1 Billing-Hourly'!C22*'Contract 1on1 Billing-Hourly'!E22/60)+('Contract 1on1 Billing-Hourly'!C23*'Contract 1on1 Billing-Hourly'!E23/60)+('Contract 1on1 Billing-Hourly'!C24*'Contract 1on1 Billing-Hourly'!E24/60)+('Contract 1on1 Billing-Hourly'!C25*'Contract 1on1 Billing-Hourly'!E25/60)+('Contract 1on1 Billing-Hourly'!C26*'Contract 1on1 Billing-Hourly'!E26/60))","v":0},null,{"$f":"ROUND('Contract 1on1 Billing-Hourly'!F29,0)","v":0}]
[11,{"$f":"IF(ISBLANK('Contract 1on1Billing-Hourly (2)'!D6)=TRUE,\" \",'Contract 1on1Billing-Hourly (2)'!D6)","v":" "},null,null,{"$f":"IF(ISBLANK('Contract 1on1Billing-Hourly (2)'!H6)=TRUE,\" \",'Contract 1on1Billing-Hourly (2)'!H6)","v":" "},null,null,null,{"$f":"(('Contract 1on1Billing-Hourly (2)'!C20*'Contract 1on1Billing-Hourly (2)'!E20/60)+('Contract 1on1Billing-Hourly (2)'!C21*'Contract 1on1Billing-Hourly (2)'!E21/60)+('Contract 1on1Billing-Hourly (2)'!C22*'Contract 1on1Billing-Hourly (2)'!E22/60)+('Contract 1on1Billing-Hourly (2)'!C23*'Contract 1on1Billing-Hourly (2)'!E23/60)+('Contract 1on1Billing-Hourly (2)'!C24*'Contract 1on1Billing-Hourly (2)'!E24/60)+('Contract 1on1Billing-Hourly (2)'!C25*'Contract 1on1Billing-Hourly (2)'!E25/60)+('Contract 1on1Billing-Hourly (2)'!C26*'Contract 1on1Billing-Hourly (2)'!E26/60))","v":0},null,{"$f":"ROUND('Contract 1on1Billing-Hourly (2)'!F29,0)","v":0}]
[12,{"$f":"IF(ISBLANK('Contract 1on1Billing-Daily'!B6)=TRUE,\" \",'Contract 1on1Billing-Daily'!B6)","v":" "},null,null,{"$f":"IF(ISBLANK('Contract 1on1Billing-Daily'!F6)=TRUE,\" \",'Contract 1on1Billing-Daily'!F6)","v":" "},null,null,null,{"$f":"(('Contract 1on1Billing-Daily'!C19*'Contract 1on1Billing-Daily'!I19/60)+('Contract 1on1Billing-Daily'!C20*'Contract 1on1Billing-Daily'!I20/60)+('Contract 1on1Billing-Daily'!C21*'Contract 1on1Billing-Daily'!I21/60)+('Contract 1on1Billing-Daily'!C22*'Contract 1on1Billing-Daily'!I22/60)+('Contract 1on1Billing-Daily'!C23*'Contract 1on1Billing-Daily'!I23/60)+('Contract 1on1Billing-Daily'!C24*'Contract 1on1Billing-Daily'!I24/60)+('Contract 1on1Billing-Daily'!C25*'Contract 1on1Billing-Daily'!I25/60))","v":0},null,{"$f":"ROUND('Contract 1on1Billing-Daily'!E28,0)","v":0}]
[13,{"$f":"IF(ISBLANK('Contract 1on1Billing-Daily (2)'!B6)=TRUE,\" \",'Contract 1on1Billing-Daily (2)'!B6)","v":" "},null,null,{"$f":"IF(ISBLANK('Contract 1on1Billing-Daily (2)'!F6)=TRUE,\" \",'Contract 1on1Billing-Daily (2)'!F6)","v":" "},null,null,null,{"$f":"(('Contract 1on1Billing-Daily (2)'!C19*'Contract 1on1Billing-Daily (2)'!I19/60)+('Contract 1on1Billing-Daily (2)'!C20*'Contract 1on1Billing-Daily (2)'!I20/60)+('Contract 1on1Billing-Daily (2)'!C21*'Contract 1on1Billing-Daily (2)'!I21/60)+('Contract 1on1Billing-Daily (2)'!C22*'Contract 1on1Billing-Daily (2)'!I22/60)+('Contract 1on1Billing-Daily (2)'!C23*'Contract 1on1Billing-Daily (2)'!I23/60)+('Contract 1on1Billing-Daily (2)'!C24*'Contract 1on1Billing-Daily (2)'!I24/60)+('Contract 1on1Billing-Daily (2)'!C25*'Contract 1on1Billing-Daily (2)'!I25/60))","v":0},null,{"$f":"ROUND('Contract 1on1Billing-Daily (2)'!E28,0)","v":0}]
["Related Services Required to implement the IEP (In-District Staff)"]
[14,{"$f":"'Current IEP-Other Staff Costs'!A9","v":"SLP"},null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B10)=TRUE,'1st Prev. IEP-Other Staff Costs'!B10,'Current IEP-Other Staff Costs'!B10)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!B14*'Current IEP-Other Staff Costs'!B15/60)+('1st Prev. IEP-Other Staff Costs'!B14*'1st Prev. IEP-Other Staff Costs'!B15/60)+('2nd Prev. IEP-Other Staff Costs'!B14*'2nd Prev. IEP-Other Staff Costs'!B15/60)+('3rd Prev. IEP-Other Staff Costs'!B14*'3rd Prev. IEP-Other Staff Costs'!B15/60)+('4th Prev. IEP-Other Staff Costs'!B14*'4th Prev. IEP-Other Staff Costs'!B15/60)+('5th Prev. IEP-Other Staff Costs'!B14*'5th Prev. IEP-Other Staff Costs'!B15/60)+('6th Prev. IEP-Other Staff Costs'!B14*'6th Prev. IEP-Other Staff Costs'!B15/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!B18+'1st Prev. IEP-Other Staff Costs'!B18+'2nd Prev. IEP-Other Staff Costs'!B18+'3rd Prev. IEP-Other Staff Costs'!B18+'4th Prev. IEP-Other Staff Costs'!B18+'5th Prev. IEP-Other Staff Costs'!B18+'6th Prev. IEP-Other Staff Costs'!B18,0)","v":0}]
[15,{"$f":"'Current IEP-Other Staff Costs'!D9","v":"OT"},null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E10)=TRUE,'1st Prev. IEP-Other Staff Costs'!E10,'Current IEP-Other Staff Costs'!E10)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!E14*'Current IEP-Other Staff Costs'!E15/60)+('1st Prev. IEP-Other Staff Costs'!E14*'1st Prev. IEP-Other Staff Costs'!E15/60)+('2nd Prev. IEP-Other Staff Costs'!E14*'2nd Prev. IEP-Other Staff Costs'!E15/60)+('3rd Prev. IEP-Other Staff Costs'!E14*'3rd Prev. IEP-Other Staff Costs'!E15/60)+('4th Prev. IEP-Other Staff Costs'!E14*'4th Prev. IEP-Other Staff Costs'!E15/60)+('5th Prev. IEP-Other Staff Costs'!E14*'5th Prev. IEP-Other Staff Costs'!E15/60)+('6th Prev. IEP-Other Staff Costs'!E14*'6th Prev. IEP-Other Staff Costs'!E15/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!E18+'1st Prev. IEP-Other Staff Costs'!E18+'2nd Prev. IEP-Other Staff Costs'!E18+'3rd Prev. IEP-Other Staff Costs'!E18+'4th Prev. IEP-Other Staff Costs'!E18+'5th Prev. IEP-Other Staff Costs'!E18+'6th Prev. IEP-Other Staff Costs'!E18,0)","v":0}]
[16,{"$f":"'Current IEP-Other Staff Costs'!G9","v":"PT"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,'1st Prev. IEP-Other Staff Costs'!H10,'Current IEP-Other Staff Costs'!H10)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,'1st Prev. IEP-Other Staff Costs'!H10,'Current IEP-Other Staff Costs'!H10)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!H14*'Current IEP-Other Staff Costs'!H15/60)+('1st Prev. IEP-Other Staff Costs'!H14*'1st Prev. IEP-Other Staff Costs'!H15/60)+('2nd Prev. IEP-Other Staff Costs'!H14*'2nd Prev. IEP-Other Staff Costs'!H15/60)+('3rd Prev. IEP-Other Staff Costs'!H14*'3rd Prev. IEP-Other Staff Costs'!H15/60)+('4th Prev. IEP-Other Staff Costs'!H14*'4th Prev. IEP-Other Staff Costs'!H15/60)+('5th Prev. IEP-Other Staff Costs'!H14*'5th Prev. IEP-Other Staff Costs'!H15/60)+('6th Prev. IEP-Other Staff Costs'!H14*'6th Prev. IEP-Other Staff Costs'!H15/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!H18+'1st Prev. IEP-Other Staff Costs'!H18+'2nd Prev. IEP-Other Staff Costs'!H18+'3rd Prev. IEP-Other Staff Costs'!H18+'4th Prev. IEP-Other Staff Costs'!H18+'5th Prev. IEP-Other Staff Costs'!H18+'6th Prev. IEP-Other Staff Costs'!H18,0)","v":0}]
[17,{"$f":"'Current IEP-Other Staff Costs'!J9","v":"VI"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,'1st Prev. IEP-Other Staff Costs'!K10,'Current IEP-Other Staff Costs'!K10)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,'1st Prev. IEP-Other Staff Costs'!K10,'Current IEP-Other Staff Costs'!K10)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!K14*'Current IEP-Other Staff Costs'!K15/60)+('1st Prev. IEP-Other Staff Costs'!K14*'1st Prev. IEP-Other Staff Costs'!K15/60)+('2nd Prev. IEP-Other Staff Costs'!K14*'2nd Prev. IEP-Other Staff Costs'!K15/60)+('3rd Prev. IEP-Other Staff Costs'!K14*'3rd Prev. IEP-Other Staff Costs'!K15/60)+('4th Prev. IEP-Other Staff Costs'!K14*'4th Prev. IEP-Other Staff Costs'!K15/60)+('5th Prev. IEP-Other Staff Costs'!K14*'5th Prev. IEP-Other Staff Costs'!K15/60)+('6th Prev. IEP-Other Staff Costs'!K14*'6th Prev. IEP-Other Staff Costs'!K15/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!K18+'1st Prev. IEP-Other Staff Costs'!K18+'2nd Prev. IEP-Other Staff Costs'!K18+'3rd Prev. IEP-Other Staff Costs'!K18+'4th Prev. IEP-Other Staff Costs'!K18+'5th Prev. IEP-Other Staff Costs'!K18+'6th Prev. IEP-Other Staff Costs'!K18,0)","v":0}]
[18,{"$f":"'Current IEP-Other Staff Costs'!M9","v":"Other, please select"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,'1st Prev. IEP-Other Staff Costs'!N10,'Current IEP-Other Staff Costs'!N10)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,'1st Prev. IEP-Other Staff Costs'!N10,'Current IEP-Other Staff Costs'!N10)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!N14*'Current IEP-Other Staff Costs'!N15/60)+('1st Prev. IEP-Other Staff Costs'!N15*'1st Prev. IEP-Other Staff Costs'!N16/60)+('2nd Prev. IEP-Other Staff Costs'!N15*'2nd Prev. IEP-Other Staff Costs'!N16/60)+('3rd Prev. IEP-Other Staff Costs'!N15*'3rd Prev. IEP-Other Staff Costs'!N16/60)+('4th Prev. IEP-Other Staff Costs'!N15*'4th Prev. IEP-Other Staff Costs'!N16/60)+('5th Prev. IEP-Other Staff Costs'!N15*'5th Prev. IEP-Other Staff Costs'!N16/60)+('6th Prev. IEP-Other Staff Costs'!N15*'6th Prev. IEP-Other Staff Costs'!N16/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!N18+'1st Prev. IEP-Other Staff Costs'!N18+'2nd Prev. IEP-Other Staff Costs'!N18+'3rd Prev. IEP-Other Staff Costs'!N18+'4th Prev. IEP-Other Staff Costs'!N18+'5th Prev. IEP-Other Staff Costs'!N18+'6th Prev. IEP-Other Staff Costs'!N18,0)","v":0}]
["Related Services Required to implement the IEP (Contracted Staff)"]
[19,{"$f":"'Current IEP-Other Staff Costs'!A21","v":"SLP"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,'1st Prev. IEP-Other Staff Costs'!B22,'Current IEP-Other Staff Costs'!B22)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,'1st Prev. IEP-Other Staff Costs'!B22,'Current IEP-Other Staff Costs'!B22)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!B24*'Current IEP-Other Staff Costs'!B25/60)+('1st Prev. IEP-Other Staff Costs'!B24*'1st Prev. IEP-Other Staff Costs'!B25/60)+('2nd Prev. IEP-Other Staff Costs'!B24*'2nd Prev. IEP-Other Staff Costs'!B25/60)+('3rd Prev. IEP-Other Staff Costs'!B24*'3rd Prev. IEP-Other Staff Costs'!B25/60)+('4th Prev. IEP-Other Staff Costs'!B24*'4th Prev. IEP-Other Staff Costs'!B25/60)+('5th Prev. IEP-Other Staff Costs'!B24*'5th Prev. IEP-Other Staff Costs'!B25/60)+('6th Prev. IEP-Other Staff Costs'!B24*'6th Prev. IEP-Other Staff Costs'!B25/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!B28+'1st Prev. IEP-Other Staff Costs'!B28+'2nd Prev. IEP-Other Staff Costs'!B28+'3rd Prev. IEP-Other Staff Costs'!B28+'4th Prev. IEP-Other Staff Costs'!B28+'5th Prev. IEP-Other Staff Costs'!B28+'6th Prev. IEP-Other Staff Costs'!B28,0)","v":0}]
[20,{"$f":"'Current IEP-Other Staff Costs'!D21","v":"OT"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,'1st Prev. IEP-Other Staff Costs'!E22,'Current IEP-Other Staff Costs'!E22)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,'1st Prev. IEP-Other Staff Costs'!E22,'Current IEP-Other Staff Costs'!E22)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!E24*'Current IEP-Other Staff Costs'!E25/60)+('1st Prev. IEP-Other Staff Costs'!E24*'1st Prev. IEP-Other Staff Costs'!E25/60)+('2nd Prev. IEP-Other Staff Costs'!E24*'2nd Prev. IEP-Other Staff Costs'!E25/60)+('3rd Prev. IEP-Other Staff Costs'!E24*'3rd Prev. IEP-Other Staff Costs'!E25/60)+('4th Prev. IEP-Other Staff Costs'!E24*'4th Prev. IEP-Other Staff Costs'!E25/60)+('5th Prev. IEP-Other Staff Costs'!E24*'5th Prev. IEP-Other Staff Costs'!E25/60)+('6th Prev. IEP-Other Staff Costs'!E24*'6th Prev. IEP-Other Staff Costs'!E25/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!E28+'1st Prev. IEP-Other Staff Costs'!E28+'2nd Prev. IEP-Other Staff Costs'!E28+'3rd Prev. IEP-Other Staff Costs'!E28+'4th Prev. IEP-Other Staff Costs'!E28+'5th Prev. IEP-Other Staff Costs'!E28+'6th Prev. IEP-Other Staff Costs'!E28,0)","v":0}]
[21,{"$f":"'Current IEP-Other Staff Costs'!G21","v":"PT"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,'1st Prev. IEP-Other Staff Costs'!H22,'Current IEP-Other Staff Costs'!H22)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,'1st Prev. IEP-Other Staff Costs'!H22,'Current IEP-Other Staff Costs'!H22)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!H24*'Current IEP-Other Staff Costs'!H25/60)+('1st Prev. IEP-Other Staff Costs'!H24*'1st Prev. IEP-Other Staff Costs'!H25/60)+('2nd Prev. IEP-Other Staff Costs'!H24*'2nd Prev. IEP-Other Staff Costs'!H25/60)+('3rd Prev. IEP-Other Staff Costs'!H24*'3rd Prev. IEP-Other Staff Costs'!H25/60)+('4th Prev. IEP-Other Staff Costs'!H24*'4th Prev. IEP-Other Staff Costs'!H25/60)+('5th Prev. IEP-Other Staff Costs'!H24*'5th Prev. IEP-Other Staff Costs'!H25/60)+('6th Prev. IEP-Other Staff Costs'!H24*'6th Prev. IEP-Other Staff Costs'!H25/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!H28+'1st Prev. IEP-Other Staff Costs'!H28+'2nd Prev. IEP-Other Staff Costs'!H28+'3rd Prev. IEP-Other Staff Costs'!H28+'4th Prev. IEP-Other Staff Costs'!H28+'5th Prev. IEP-Other Staff Costs'!H28+'6th Prev. IEP-Other Staff Costs'!H28,0)","v":0}]
[22,{"$f":"'Current IEP-Other Staff Costs'!J21","v":"VI"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,'1st Prev. IEP-Other Staff Costs'!K22,'Current IEP-Other Staff Costs'!K22)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,'1st Prev. IEP-Other Staff Costs'!K22,'Current IEP-Other Staff Costs'!K22)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!K24*'Current IEP-Other Staff Costs'!K25/60)+('1st Prev. IEP-Other Staff Costs'!K24*'1st Prev. IEP-Other Staff Costs'!K25/60)+('2nd Prev. IEP-Other Staff Costs'!K24*'2nd Prev. IEP-Other Staff Costs'!K25/60)+('3rd Prev. IEP-Other Staff Costs'!K24*'3rd Prev. IEP-Other Staff Costs'!K25/60)+('4th Prev. IEP-Other Staff Costs'!K24*'4th Prev. IEP-Other Staff Costs'!K25/60)+('5th Prev. IEP-Other Staff Costs'!K24*'5th Prev. IEP-Other Staff Costs'!K25/60)+('6th Prev. IEP-Other Staff Costs'!K24*'6th Prev. IEP-Other Staff Costs'!K25/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!K28+'1st Prev. IEP-Other Staff Costs'!K28+'2nd Prev. IEP-Other Staff Costs'!K28+'3rd Prev. IEP-Other Staff Costs'!K28+'4th Prev. IEP-Other Staff Costs'!K28+'5th Prev. IEP-Other Staff Costs'!K28+'6th Prev. IEP-Other Staff Costs'!K28,0)","v":0}]
[23,{"$f":"'Current IEP-Other Staff Costs'!M21","v":"Other, please select"},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,'1st Prev. IEP-Other Staff Costs'!N22,'Current IEP-Other Staff Costs'!N22)","v":" "},{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,'1st Prev. IEP-Other Staff Costs'!N22,'Current IEP-Other Staff Costs'!N22)","v":" "},null,null,null,null,{"$f":"(('Current IEP-Other Staff Costs'!N25*'Current IEP-Other Staff Costs'!N26/60)+('1st Prev. IEP-Other Staff Costs'!N25*'1st Prev. IEP-Other Staff Costs'!N26/60)+('2nd Prev. IEP-Other Staff Costs'!N25*'2nd Prev. IEP-Other Staff Costs'!N26/60)+('3rd Prev. IEP-Other Staff Costs'!N25*'3rd Prev. IEP-Other Staff Costs'!N26/60)+('4th Prev. IEP-Other Staff Costs'!N25*'4th Prev. IEP-Other Staff Costs'!N26/60)+('5th Prev. IEP-Other Staff Costs'!N25*'5th Prev. IEP-Other Staff Costs'!N26/60)+('6th Prev. IEP-Other Staff Costs'!N25*'6th Prev. IEP-Other Staff Costs'!N26/60))","v":0},null,{"$f":"ROUND('Current IEP-Other Staff Costs'!N28+'1st Prev. IEP-Other Staff Costs'!N28+'2nd Prev. IEP-Other Staff Costs'!N28+'3rd Prev. IEP-Other Staff Costs'!N28+'4th Prev. IEP-Other Staff Costs'!N28+'5th Prev. IEP-Other Staff Costs'!N28+'6th Prev. IEP-Other Staff Costs'!N28,0)","v":0}]
["Out of District Placement Information",null,null,null,null,null,null,null,"Dates of Service"]
[24,"Regular SY"]
[25,"Regular SY"]
[26,"Regular SY"]
[27,"Extended SY"]
["Transportation Information"]
[28,"Transportation - Out of District for Regular School Year only"]
[29,"Transportation - ESY"]
["Other Costs Associated with student for 2022–23 school year"]
[30,"In District ESY Costs (Out of District Placement ESY costs should be included above on line 27, not here)",null,null,null,null,null,null,null,null,{"$f":"ROUND('ESY-Staff Costs'!B14+'ESY-Staff Costs'!E14+'ESY-Staff Costs'!H14+'ESY-Staff Costs'!B24+'ESY-Staff Costs'!E24+'ESY-Staff Costs'!H24+'ESY-Other Staff Costs'!B16+'ESY-Other Staff Costs'!E16+'ESY-Other Staff Costs'!H16+'ESY-Other Staff Costs'!K16+'ESY-Other Staff Costs'!N16+'ESY-Other Staff Costs'!B26+'ESY-Other Staff Costs'!E26+'ESY-Other Staff Costs'!H26+'ESY-Other Staff Costs'!K26+'ESY-Other Staff Costs'!N26,0)","v":0}]
[31,"Equipment/Supplies"]
[32,"Assistive Technology"]
[33,"Other",null,null,null,null,null,null,null,null,null,"Note: Do not enter contracted providers in this cell. Contracted providers should be included in the appropriate area above."]
[34,"Total (Lines 1–33)",null,null,null,null,null,null,null,null,{"$f":"ROUND(K16+K17+K18+K20+K21+K22+K23+K24+K25+K27+K28+K29+K30+K32+K33+K34+K35+K36+K38+K39+K40+K41+K42+K44+K45+K46+K47+K49+K50+K52+K53+K54+K55,0)","v":0}]
["Threshold: Enter 1 for each month enrolled and served on count date"]
[null,"Oct","Nov","Dec","Jan","Feb","Mar","April","May","June","FTE Avg"]
[35,1,1,1,1,1,1,1,1,1,{"$f":"SUM(B59:J59)/9","v":1}]
[36,"State threshold multiplied by the average on Line 35.",null,null,null,null,null,null,null,37599,{"$f":"K59*J60","v":37599}]
[37,"Medicaid revenue attributable to this student. For Medicaid Reimbursement Calculator click here.",null,null,null,null,null,null,null,null,{"$f":"ROUND('Medicaid Reimbursement Calc'!J106,0)","v":0}]
[38,"Max. Capacity Demonstrated for this Individual (Line 34 - 36 -  37).",null,null,null,null,null,null,null,null,{"$f":"K56-K60-K61","v":-37599}]
[39,"Enter on Form SP 1381 - INDIVIDUALS SUMMARY",null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(K62<=0,0,K62),0)","v":0}]

{"sheet":"Medicaid Reimbursement Calc","index":5,"n_rows":106,"n_cols":30,"rows_kept":106,"cut":false,"hidden":false,"merged":[[105,4,105,8],[0,0,0,9],[1,0,1,9],[2,0,2,9],[10,0,10,1],[104,5,104,8]]}
["Medicaid Reimbursement Calculator"]
["Rates effective - 7/1/2022"]
["Districts are responsible for all data entry and calculation verification as well as updating billing rates."]
[]
["How to use this calculator:"]
["1. Locate the Code that corresponds to the service being provided. "]
["2. If the service billing unit is Flat Rate, insert Encounters per Week and # of Weeks Receiving Services."]
["3. If the service billing unit is in minutes, insert Duration of Encounter in Minutes, Encounters per Week and # of Weeks Receiving Services. "]
["4. The MEDICAID REIMBURSEMENT CALCULATOR will automatically compute all totals."]
[]
[{"$f":"'Start Here'!K3","v":0}]
["Service","Code","Brief Description","Maximum Allowable Fee","Duration of Encounter in Minutes","Encounters Per Week","# of Weeks Receiving Services","Billing Unit in Minutes","Total Encounters","Medicaid Reimbursement",null,null,null,null,null,null,null,null,null,null,null,"Min15",null,null,"Val15","Min60","Val60","Min30","Val30","Nurse"]
["Audiology",92507,"Speech/hearing therapy, individual",45.05,"NA",null,null,"Flat Rate",{"$f":"F13*G13","v":0},{"$f":"D13*I13","v":0},null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,0,0,0,1]
["Audiology",92508,"Speech/hearing therapy, group",13.98,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,7,null,null,0,52,0,22,0,1]
["Audiology",92521,"Evaluation of speech fluency",78.260000000000005,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,8,null,null,1,53,1,23,1,1]
["Audiology",92522,"Evaluate speech production",65.45,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,22,null,null,1,112,1,52,1,1]
["Audiology",92523,"Speech sound lang comprehen",133.61000000000001,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,23,null,null,2,113,2,53,2,2]
["Audiology",92524,"Behavral qualit analys voice",64.47,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,37,null,null,2,172,2,82,2,2]
["Audiology",92551,"Pure tone hearing test air",6.99,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,38,null,null,3,173,3,83,3,3]
["Audiology",92552,"Pure tone audiometry air",20.39,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,52,null,null,3,232,3,112,3,3]
["Audiology",92553,"Audiometry air & bone",24.86,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,53,null,null,4,233,4,113,4,4]
["Audiology",92555,"Speech threshold audiometry",15.54,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,67,null,null,4,292,4,142,4,4]
["Audiology",92556,"Speech audiometry complete",24.28,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,83,null,null,6,353,6,173,6,6]
["Audiology",92557,"Comprehensive hearing test",22.14,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,112,null,null,7,null,null,null,null,7]
["Audiology",92567,"Tympanometry",9.9,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,113,null,null,8,null,null,null,null,8]
["Audiology",92568,"Acoustic reflex testing, threshold",9.1300000000000008,"NA",null,null,"Flat Rate",0,0,null,null,null,null,null,null,null,null,null,null,null,127,null,null,8,null,null,null,null,8]
["Audiology",92570,"Acoustic immittance testing",19.23,"NA",null,null,"Flat Rate",0,0]
["Audiology",92579,"Visual audiometry (vra)",27.19,"NA",null,null,"Flat Rate",0,0]
["Audiology",92582,"Conditioning play audiometry",47,"NA",null,null,"Flat Rate",0,0]
["Audiology",92587,"Evoked auditory test limited",13.01,"NA",null,null,"Flat Rate",0,0]
["Audiology",92588,"Evoked auditory tst complete",20,"NA",null,null,"Flat Rate",0,0]
["Audiology",92620,"Auditory function 60 min",53.6,null,null,null,60,0,{"$f":"IF(I32=0,0,LOOKUP(E32,_Min60,_Val60)*D32)*I32","v":0}]
["Audiology",92621,"Auditory function + 15 min",13.01,null,null,null,15,0,{"$f":"IF(I33=0,0,LOOKUP(E33,_Min15,_Val15)*D33)*I33","v":0}]
["Audiology",97533,"Sensory integration",38.840000000000003,null,null,null,15,0,{"$f":"IF(I34=0,0,LOOKUP(E34,_Min15,_Val15)*D34)*I34","v":0}]
["Audiology","S9152","Speech therapy re-eval",49.6,"NA",null,null,"Flat Rate",0,{"$f":"D35*I35","v":0}]
["Counseling",90791,"Psych diagnostic evaluation",117.47,"NA",null,null,"Flat Rate",0,{"$f":"D36*I36","v":0}]
["Counseling","S9445","Pt education noc individ",17.72,null,null,null,15,0,{"$f":"IF(I37=0,0,LOOKUP(E37,_Min15,_Val15)*D37)*I37","v":0},null,null,null,null,null,null,null,null,null,null,null,128,null,null,9,null,null,null,null,9]
["Counseling","S9446","Pt education noc group",5.91,null,null,null,15,0,{"$f":"IF(I38=0,0,LOOKUP(E38,_Min15,_Val15)*D38)*I38","v":0},null,null,null,null,null,null,null,null,null,null,null,142,null,null,9,null,null,null,null,9]
["Nursing","T1001","Nursing assessment/evaluation",27.52,"NA",null,null,"Flat Rate",0,{"$f":"D39*I39","v":0},null,null,null,null,null,null,null,null,null,null,null,143,null,null,10,null,null,null,null,10]
["Nursing","T1002","RN services up to 15 minutes",6.88,null,null,null,15,0,{"$f":"IF(I40=0,0,LOOKUP(E40,_Min15,_Nurse)*D40)*I40","v":0},null,null,null,null,null,null,null,null,null,null,null,157,null,null,10,null,null,null,null,10]
["Nursing","T1003","LPN/LVN services up to 15 minutes",3.76,null,null,null,15,0,{"$f":"IF(I41=0,0,LOOKUP(E41,_Min15,_Nurse)*D41)*I41","v":0},null,null,null,null,null,null,null,null,null,null,null,158,null,null,11,null,null,null,null,11]
["OT",95851,"Range of motion measurements",12.43,"NA",null,null,"Flat Rate",0,{"$f":"D42*I42","v":0},null,null,null,null,null,null,null,null,null,null,null,172,null,null,11,null,null,null,null,11]
["OT",95852,"Range of motion measurements",10.29,"NA",null,null,"Flat Rate",0,{"$f":"D43*I43","v":0},null,null,null,null,null,null,null,null,null,null,null,173,null,null,12,null,null,null,null,12]
["OT",97110,"Therapeutic exercises",17.48,null,null,null,15,0,{"$f":"IF(I44=0,0,LOOKUP(E44,_Min15,_Val15)*D44)*I44","v":0},null,null,null,null,null,null,null,null,null,null,null,202,null,null,13,null,null,null,null,13]
["OT",97112,"Neuromuscular reeducation",20.2,null,null,null,15,0,{"$f":"IF(I45=0,0,LOOKUP(E45,_Min15,_Val15)*D45)*I45","v":0},null,null,null,null,null,null,null,null,null,null,null,203,null,null,14,null,null,null,null,14]
["OT",97150,"Group therapeutic procedures",10.29,"NA",null,null,"Flat Rate",0,{"$f":"D46*I46","v":0},null,null,null,null,null,null,null,null,null,null,null,217,null,null,14,null,null,null,null,14]
["OT",97165,"OT eval low complex, 30 min",59.62,"NA",null,null,"Flat Rate",0,{"$f":"D47*I47","v":0}]
["OT",97166,"OT eval mod complex, 45 min",59.62,"NA",null,null,"Flat Rate",0,{"$f":"D48*I48","v":0}]
["OT",97167,"OT eval high complex, 60 min",59.62,"NA",null,null,"Flat Rate",0,{"$f":"D49*I49","v":0}]
["OT",97168,"OT re-eval est plan care",41.17,"NA",null,null,"Flat Rate",0,{"$f":"D50*I50","v":0}]
["OT",97530,"Therapeutic activities",22.14,null,null,null,15,0,{"$f":"IF(I51=0,0,LOOKUP(E51,_Min15,_Val15)*D51)*I51","v":0}]
["OT",97533,"Sensory integration",38.840000000000003,null,null,null,15,0,0]
["OT",97535,"Self-care management training",19.420000000000002,null,null,null,15,0,0]
["OT",97537,"Community/work reintegration",18.84,null,null,null,15,0,0]
["OT",97542,"Wheelchair management training",18.940000000000001,null,null,null,15,0,0]
["OT",97750,"Physical performance test",19.809999999999999,null,null,null,15,0,0]
["OT",97755,"Assistive technology assess",22.33,null,null,null,15,0,0]
["OT",97760,"Orthotic management and training",29.13,null,null,null,15,0,0]
["OT",97761,"Prosthetic training",24.86,null,null,null,15,0,0]
["OT",97763,"Orthc/prostc mgmt sbsq enc",32.43,null,null,null,15,0,0]
["Psych",90791,"Psych diagnostic evaluation",117.47,"NA",null,null,"Flat Rate",0,{"$f":"D61*I61","v":0}]
["Psych",96130,"Psycl tst eval phys/qhp 1st",69.14,null,null,null,60,0,{"$f":"IF(I62=0,0,LOOKUP(E62,_Min60,_Val60)*D62)*I62","v":0}]
["Psych",96131,"Psycl tst eval phys/qhp ea",51.27,null,null,null,60,0,{"$f":"IF(I63=0,0,LOOKUP(E63,_Min60,_Val60)*D63)*I63","v":0}]
["Psych",96136,"Psycl/nrpsyc tst phy/qhp 1st",26.02,null,null,null,30,0,{"$f":"IF(I64=0,0,LOOKUP(E64,_Min30,_Val30)*D64)*I64","v":0}]
["Psych",96137,"Psycl/nrpsyc tst phy/qhp ea",23.69,null,null,null,30,0,{"$f":"IF(I65=0,0,LOOKUP(E65,_Min30,_Val30)*D65)*I65","v":0}]
["Psych","S9445","Pt education noc individual",17.72,null,null,null,15,0,{"$f":"IF(I66=0,0,LOOKUP(E66,_Min15,_Val15)*D66)*I66","v":0}]
["Psych","S9446","Pt education noc group",5.91,null,null,null,15,0,{"$f":"IF(I67=0,0,LOOKUP(E67,_Min15,_Val15)*D67)*I67","v":0}]
["PT",95851,"Range of motion measurements",12.43,"NA",null,null,"Flat Rate",0,{"$f":"D68*I68","v":0}]
["PT",95852,"Range of motion measurements",10.29,"NA",null,null,"Flat Rate",0,{"$f":"D69*I69","v":0}]
["PT",97110,"Therapeutic exercises",17.48,null,null,null,15,0,{"$f":"IF(I70=0,0,LOOKUP(E70,_Min15,_Val15)*D70)*I70","v":0}]
["PT",97112,"Neuromuscular reeducation",20.2,null,null,null,15,0,{"$f":"IF(I71=0,0,LOOKUP(E71,_Min15,_Val15)*D71)*I71","v":0}]
["PT",97116,"Gait training therapy",17.48,null,null,null,15,0,{"$f":"IF(I72=0,0,LOOKUP(E72,_Min15,_Val15)*D72)*I72","v":0}]
["PT",97124,"Massage therapy",17.87,null,null,null,15,0,{"$f":"IF(I73=0,0,LOOKUP(E73,_Min15,_Val15)*D73)*I73","v":0}]
["PT",97139,"Physical medicine procedure",8.5399999999999991,null,null,null,15,0,{"$f":"IF(I74=0,0,LOOKUP(E74,_Min15,_Val15)*D74)*I74","v":0}]
["PT",97150,"Group therapeutic procedures",10.29,"NA",null,null,"Flat Rate",0,{"$f":"D75*I75","v":0}]
["PT",97161,"PT eval low complex, 20 min",59.23,"NA",null,null,"Flat Rate",0,{"$f":"D76*I76","v":0}]
["PT",97162,"PT eval mod complex, 30 min",59.23,"NA",null,null,"Flat Rate",{"$f":"F77*G77","v":0},{"$f":"D77*I77","v":0}]
["PT",97163,"PT eval high complex, 45 min",59.23,"NA",null,null,"Flat Rate",0,{"$f":"D78*I78","v":0}]
["PT",97164,"PT re-eval est plan care",40.98,"NA",null,null,"Flat Rate",0,{"$f":"D79*I79","v":0}]
["PT",97530,"Therapeutic activities",22.14,null,null,null,15,0,{"$f":"IF(I80=0,0,LOOKUP(E80,_Min15,_Val15)*D80)*I80","v":0}]
["PT",97535,"Self care mngment training",19.420000000000002,null,null,null,15,0,0]
["PT",97537,"Community/work reintegration",18.84,null,null,null,15,0,0]
["PT",97542,"Wheelchair mgmt training",18.84,null,null,null,15,0,0]
["PT",97750,"Physical performance test",19.809999999999999,null,null,null,15,0,0]
["PT",97755,"Assistive technology assess",22.33,null,null,null,15,0,0]
["PT",97760,"Orthotic mgmt and training",29.13,null,null,null,15,0,0]
["PT",97761,"Prosthetic training",24.86,null,null,null,15,0,0]
["PT",97763,"Orthc/prostc mgmt sbsq enc",32.43,null,null,null,15,0,0]
["SL Therapy",92507,"Speech/hearing therapy, individual",45.05,"NA",null,null,"Flat Rate",0,{"$f":"D89*I89","v":0}]
["SL Therapy",92508,"Speech/hearing therapy, group",13.98,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92521,"Evaluation of speech fluency",78.260000000000005,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92522,"Evaluate speech production",65.45,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92523,"Speech sound lang comprehen",133.61000000000001,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92524,"Behavral qualit analys voice",64.47,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92551,"Pure tone hearing test air",6.99,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92568,"Acoustic reflex testing, threshold",9.1300000000000008,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92570,"Accoustic immittance testing",19.23,"NA",null,null,"Flat Rate",0,0]
["SL Therapy",92607,"Ex for speech device rx 1hr",73.209999999999994,null,null,null,60,0,{"$f":"IF(I98=0,0,LOOKUP(E98,_Min60,_Val60)*D98)*I98","v":0}]
["SL Therapy",92608,"EX for speech device rx addl",28.94,null,null,null,30,0,{"$f":"IF(I99=0,0,LOOKUP(E99,_Min30,_Val30)*D99)*I99","v":0}]
["SL Therapy",92609,"Use of speech device services",61.56,"NA",null,null,"Flat Rate",0,{"$f":"D100*I100","v":0}]
["SL Therapy",92610,"Evaluate swallowing function",50.3,"NA",null,null,"Flat Rate",0,{"$f":"D101*I101","v":0}]
["SL Therapy",97533,"Sensory integration",38.840000000000003,null,null,null,15,0,{"$f":"IF(I102=0,0,LOOKUP(E102,_Min15,_Val15)*D102)*I102","v":0}]
["SL Therapy","S9152","Speech therapy re-eval",49.6,"NA",null,null,"Flat Rate",0,{"$f":"D103*I103","v":0}]
["Telemedicine","Q3014","Telehealth facility fee",24.63,"NA",null,null,"Flat Rate",0,{"$f":"D104*I104","v":0}]
[null,null,null,null,null,"Total",null,null,null,{"$f":"(SUM(J13:J104))","v":0}]
[null,null,null,null,"70% of total (for use on Worksheet C Summary)",null,null,null,null,{"$f":"J105*0.7","v":0}]

{"sheet":"Contract 1on1 Billing-Hourly","index":6,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,0,0,9],[28,3,28,4],[3,0,3,7],[28,6,29,9],[2,0,2,9],[1,0,1,9],[5,3,5,5],[5,7,5,9],[15,7,17,9]]}
["Contracted 1:1 Cost and Billing Calculator - For providers who have an hourly rate",null,null,null,null,null,null,null,null,null,null,null,"1:1 Paraeducator"]
["Note: This worksheet is linked to the Worksheet C Summary. (Used to complete line 10 on Worksheet C Summary)",null,null,null,null,null,null,null,null,null,null,null,"1:1 Interpreter"]
["Use this form to calculate costs for contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians",null,null,null,null,null,null,null,null,null,null,null,"1:1 Nurse"]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"1:1 Behavior technician"]
[]
["SSID",{"$f":"'Start Here'!K3","v":0},"Provider Name",null,null,null,"Position"]
[null,"# of days per calendar","MPW in IEP for direct services","# of IEP hours\n(MPW/60/5)","Potential Hours for Month\n(# of days*# of hours)","Amount billed per month based on invoices for direct services","Hours billed per invoice\n(Amt billed per invoice/hourly rate)","Hourly Rate="]
["August",{"$f":"'Start Here'!O9","v":0},null,{"$f":"C8/60/5","v":0},{"$f":"B8*D8","v":0},null,{"$f":"F8/$I$7","v":{"$error":"#DIV/0!"}}]
["September",{"$f":"'Start Here'!O10","v":0},null,{"$f":"C9/60/5","v":0},{"$f":"B9*D9","v":0},null,{"$f":"F9/$I$7","v":{"$error":"#DIV/0!"}},{"$f":"IF(C9>0,IF(F9<=0,\"If MPW are included in column C for this month, fill in the amount billed from the contractor's invoicing. If there are no bills from the contractor for this month, remove the MPW from column C.\",\"\"),\"\")","v":""}]
["October",{"$f":"'Start Here'!O11","v":0},null,{"$f":"C10/60/5","v":0},{"$f":"B10*D10","v":0},null,{"$error":"#DIV/0!"},""]
["November",{"$f":"'Start Here'!O12","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
["December",{"$f":"'Start Here'!O13","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
["January",{"$f":"'Start Here'!O14","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
["February",{"$f":"'Start Here'!O15","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
[null,{"$f":"SUM(B8:B14)","v":0},null,null,{"$f":"SUM(E8:E14)","v":0},null,{"$f":"SUM(G8:G14)","v":{"$error":"#DIV/0!"}},""]
[]
[null,null,null,null,null,"Billing %",{"$f":"ROUND(G15/E15,4)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Hourly rate","MPW in IEP for direct services","Hours per week\n(MPW/60)","# of weeks\n(from Start Here tab)","Maximum Potential"]
["Potential - current IEP",{"$f":"$I$7","v":0},null,{"$f":"C20/60","v":0},{"$f":"'Start Here'!L7/5","v":0},{"$f":"(B20*D20)*E20","v":0}]
["Potential - 1st previous IEP",0,null,{"$f":"C21/60","v":0},{"$f":"'Start Here'!L21/5","v":0},{"$f":"(B21*D21)*E21","v":0}]
["Potential - 2nd previous IEP",0,null,{"$f":"C22/60","v":0},{"$f":"'Start Here'!L35/5","v":0},{"$f":"(B22*D22)*E22","v":0}]
["Potential - 3rd previous IEP",0,null,0,{"$f":"'Start Here'!L49/5","v":0},0]
["Potential - 4th previous IEP",0,null,0,{"$f":"'Start Here'!L63/5","v":0},0]
["Potential - 5th previous IEP",0,null,0,{"$f":"'Start Here'!L77/5","v":0},0]
["Potential - 6th previous IEP",0,null,0,{"$f":"'Start Here'!L91/5","v":0},0]
[null,null,null,null,"Potential cost for 22–23 school year",{"$f":"SUM(F20:F26)","v":0}]
[null,null,null,null,"Billing %",{"$f":"G17","v":{"$error":"#DIV/0!"}}]
[null,null,null," Adjusted amount",null,{"$f":"ROUND(IFERROR(IF(F28<0.94,F27*F28,F27),0),0)","v":0},"This will only adjust based on the billing percentage if the billing percentage is less than 94%."]

{"sheet":"Contract 1on1Billing-Hourly (2)","index":7,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,0,0,9],[28,3,28,4],[28,6,29,9],[1,0,1,9],[2,0,2,9],[3,0,3,7],[5,3,5,5],[5,7,5,9]]}
["Contracted 1:1 Cost and Billing Calculator - For providers who have an hourly rate",null,null,null,null,null,null,null,null,null,null,null,"1:1 Paraeducator"]
["Note: This worksheet is linked to the Worksheet C Summary. (Used to complete line 11 on Worksheet C Summary)",null,null,null,null,null,null,null,null,null,null,null,"1:1 Interpreter"]
["Use this form to calculate costs for contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians",null,null,null,null,null,null,null,null,null,null,null,"1:1 Nurse"]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"1:1 Behavior technician"]
[]
["SSID",{"$f":"'Start Here'!K3","v":0},"Provider Name",null,null,null,"Position"]
[null,"# of days per calendar","MPW in IEP for direct services","# of IEP hours\n(MPW/60/5)","Potential Hours for Month\n(# of days*# of hours)","Amount billed per month based on invoices for direct services","Hours billed per invoice\n(Amt billed per invoice/hourly rate)","Hourly Rate="]
["August",{"$f":"'Start Here'!O9","v":0},null,{"$f":"C8/60/5","v":0},{"$f":"B8*D8","v":0},null,{"$f":"F8/$I$7","v":{"$error":"#DIV/0!"}},{"$f":"IF(C8>0,IF(F8<=0,\"If MPW are included in column C for this month, fill in the amount billed from the contractor's invoicing. If there are no bills from the contractor for this month, remove the MPW from column C.\",\"\"),\"\")","v":""}]
["September",{"$f":"'Start Here'!O10","v":0},null,{"$f":"C9/60/5","v":0},{"$f":"B9*D9","v":0},null,{"$f":"F9/$I$7","v":{"$error":"#DIV/0!"}},""]
["October",{"$f":"'Start Here'!O11","v":0},null,{"$f":"C10/60/5","v":0},{"$f":"B10*D10","v":0},null,{"$error":"#DIV/0!"},""]
["November",{"$f":"'Start Here'!O12","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
["December",{"$f":"'Start Here'!O13","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
["January",{"$f":"'Start Here'!O14","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
["February",{"$f":"'Start Here'!O15","v":0},null,0,0,null,{"$error":"#DIV/0!"},""]
[null,{"$f":"SUM(B8:B13)","v":0},null,null,{"$f":"SUM(E8:E14)","v":0},null,{"$f":"SUM(G8:G14)","v":{"$error":"#DIV/0!"}},""]
[]
[null,null,null,null,null,"Billing %",{"$f":"ROUND(G15/E15,4)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Hourly rate","MPW in IEP for direct services","Hours per week\n(MPW/60)","# of weeks\n(from Start Here tab)","Maximum Potential"]
["Potential - current IEP",{"$f":"$I$7","v":0},null,{"$f":"C20/60","v":0},{"$f":"'Start Here'!L7/5","v":0},{"$f":"(B20*D20)*E20","v":0}]
["Potential - 1st previous IEP",0,null,{"$f":"C21/60","v":0},{"$f":"'Start Here'!L21/5","v":0},{"$f":"(B21*D21)*E21","v":0}]
["Potential - 2nd previous IEP",0,null,{"$f":"C22/60","v":0},{"$f":"'Start Here'!L35/5","v":0},{"$f":"(B22*D22)*E22","v":0}]
["Potential - 3rd previous IEP",0,null,0,{"$f":"'Start Here'!L49/5","v":0},0]
["Potential - 4th previous IEP",0,null,0,{"$f":"'Start Here'!L63/5","v":0},0]
["Potential - 5th previous IEP",0,null,0,{"$f":"'Start Here'!L77/5","v":0},0]
["Potential - 6th previous IEP",0,null,0,{"$f":"'Start Here'!L91/5","v":0},0]
[null,null,null,null,"Potential cost for 22–23 school year",{"$f":"SUM(F20:F26)","v":0}]
[null,null,null,null,"Billing %",{"$f":"G17","v":{"$error":"#DIV/0!"}}]
[null,null,null," Adjusted amount",null,{"$f":"ROUND(IFERROR(IF(F28<0.94,F27*F28,F27),0),0)","v":0},"This will only adjust based on the billing percentage if the billing percentage is less than 94%."]

{"sheet":"Contract 1on1Billing-Daily","index":8,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[[27,5,28,6],[5,5,5,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[5,1,5,3]]}
["Contracted 1:1 Cost and Billing Calculator - For providers who have a daily rate"]
["Note: This worksheet is linked to the Worksheet C Summary. (Used to complete line 12 on Worksheet C Summary)",null,null,null,null,null,null,null,null,null,null,"1:1 Interpreter"]
["Use this form to calculate costs for contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians.",null,null,null,null,null,null,null,null,null,null,"1:1 Nurse"]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,"1:1 Behavior technician"]
["SSID",{"$f":"'Start Here'!K3","v":0}]
["Provider Name",null,null,null,"Position"]
[null,"# of days per calendar","MPW in IEP","Amount billed per month based on invoices for direct services","Days billed per invoice\n(Amt billed per invoice/hourly rate)","Daily Rate="]
["August",{"$f":"'Start Here'!O9","v":0},null,null,{"$f":"D8/$G$7","v":{"$error":"#DIV/0!"}}]
["September",{"$f":"'Start Here'!O10","v":0},null,null,{"$error":"#DIV/0!"}]
["October",{"$f":"'Start Here'!O11","v":0},null,null,{"$error":"#DIV/0!"}]
["November",{"$f":"'Start Here'!O12","v":0},null,null,{"$error":"#DIV/0!"}]
["December",{"$f":"'Start Here'!O13","v":0},null,null,{"$error":"#DIV/0!"}]
["January",{"$f":"'Start Here'!O14","v":0},null,null,{"$error":"#DIV/0!"}]
["February",{"$f":"'Start Here'!O15","v":0},null,null,{"$error":"#DIV/0!"}]
[null,{"$f":"SUM(B8:B14)","v":0},null,null,{"$f":"SUM(E8:E14)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Billing %",{"$f":"ROUND(E15/B15,4)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Daily rate","MPW in IEP","# of days\n(from Start Here tab)","Maximum Potential"]
["Potential - current IEP",{"$f":"$G$7","v":0},null,{"$f":"'Start Here'!L7","v":0},{"$f":"B19*D19","v":0},null,null,null,{"$f":"D19/5","v":0}]
["Potential - 1st previous IEP",0,null,{"$f":"'Start Here'!L21","v":0},0,null,null,null,{"$f":"D20/5","v":0}]
["Potential - 2nd previous IEP",0,null,{"$f":"'Start Here'!L35","v":0},0,null,null,null,0]
["Potential - 3rd previous IEP",0,null,{"$f":"'Start Here'!L49","v":0},0,null,null,null,0]
["Potential - 4th previous IEP",0,null,{"$f":"'Start Here'!L63","v":0},0,null,null,null,0]
["Potential - 5th previous IEP",0,null,{"$f":"'Start Here'!L77","v":0},0,null,null,null,0]
["Potential - 6th previous IEP",0,null,{"$f":"'Start Here'!L91","v":0},0,null,null,null,0]
[null,null,null,"Potential cost for 22–23 school year",{"$f":"SUM(E19:E25)","v":0}]
[null,null,null,"Billing %",{"$f":"E16","v":{"$error":"#DIV/0!"}}]
[null,null,null," Adjusted amount",{"$f":"ROUND(IFERROR(IF(E27<0.94,E26*E27,E26),0),0)","v":0},"This will only adjust based on the billing percentage if the billing percentage is less than 94%."]

{"sheet":"Contract 1on1Billing-Daily (2)","index":9,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[[5,1,5,3],[27,5,28,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[5,5,5,6]]}
["Contracted 1:1 Cost and Billing Calculator - For providers who have a daily rate",null,null,null,null,null,null,null,null,null,null,"1:1 Paraeducator"]
["Note: This worksheet is linked to the Worksheet C Summary. (Used to complete line 13 on Worksheet C Summary)",null,null,null,null,null,null,null,null,null,null,"1:1 Interpreter"]
["Use this form to calculate costs for contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians.",null,null,null,null,null,null,null,null,null,null,"1:1 Nurse"]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,"1:1 Behavior technician"]
["SSID",{"$f":"'Start Here'!K3","v":0}]
["Provider Name",null,null,null,"Position"]
[null,"# of days per calendar","MPW in IEP","Amount billed per month based on invoices for direct services","Days billed per invoice\n(Amt billed per invoice/hourly rate)","Daily Rate="]
["August",{"$f":"'Start Here'!O9","v":0},null,null,{"$f":"D8/$G$7","v":{"$error":"#DIV/0!"}}]
["September",{"$f":"'Start Here'!O10","v":0},null,null,{"$error":"#DIV/0!"}]
["October",{"$f":"'Start Here'!O11","v":0},null,null,{"$error":"#DIV/0!"}]
["November",{"$f":"'Start Here'!O12","v":0},null,null,{"$error":"#DIV/0!"}]
["December",{"$f":"'Start Here'!O13","v":0},null,null,{"$error":"#DIV/0!"}]
["January",{"$f":"'Start Here'!O14","v":0},null,null,{"$error":"#DIV/0!"}]
["February",{"$f":"'Start Here'!O15","v":0},null,null,{"$error":"#DIV/0!"}]
[null,{"$f":"SUM(B8:B14)","v":0},null,null,{"$f":"SUM(E8:E14)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Billing %",{"$f":"ROUND(E15/B15,4)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Daily rate","MPW in IEP","# of days\n(from Start Here tab)","Maximum Potential"]
["Potential - current IEP",{"$f":"$G$7","v":0},null,{"$f":"'Start Here'!L7","v":0},{"$f":"B19*D19","v":0},null,null,null,{"$f":"D19/5","v":0}]
["Potential - 1st previous IEP",0,null,{"$f":"'Start Here'!L21","v":0},0,null,null,null,{"$f":"D20/5","v":0}]
["Potential - 2nd previous IEP",0,null,{"$f":"'Start Here'!L35","v":0},0,null,null,null,0]
["Potential - 3rd previous IEP",0,null,{"$f":"'Start Here'!L49","v":0},0,null,null,null,0]
["Potential - 4th previous IEP",0,null,{"$f":"'Start Here'!L63","v":0},0,null,null,null,0]
["Potential - 5th previous IEP",0,null,{"$f":"'Start Here'!L77","v":0},0,null,null,null,0]
["Potential - 6th previous IEP",0,null,{"$f":"'Start Here'!L91","v":0},0,null,null,null,0]
[null,null,null,"Potential cost for 22–23 school year",{"$f":"SUM(E19:E25)","v":0}]
[null,null,null,"Billing %",{"$f":"E16","v":{"$error":"#DIV/0!"}}]
[null,null,null," Adjusted amount",{"$f":"ROUND(IFERROR(IF(E27<0.94,E26*E27,E26),0),0)","v":0},"This will only adjust based on the billing percentage if the billing percentage is less than 94%."]

{"sheet":"Current IEP-Staff Costs","index":10,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":true,"merged":[[6,0,6,7],[16,0,16,7],[0,0,0,7],[1,0,1,7]]}
["Current IEP - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: Current IEP-Other Staff Costs",null,null,null,"1:1 Behavior Technician"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous Page: Worksheet C Summary",null,null,null,"1:1 Braillist"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0},null,null,null,null,null,"1:1 Bus Assistant"]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"('Start Here'!L7/180)*36","v":0},null,null,null,null,null,"1:1 Interpreter"]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from",{"$f":"'Start Here'!N7","v":"mm/dd/yyyy"},null,null,null,null,null,"1:1 Nurse"]
[null,null,null,null,null,null,"to",{"$f":"'Start Here'!P7","v":"mm/dd/yyyy"},null,null,null,null,null,"1:1 Paraeducator"]
["Special Education Certificated Staff (Special Education Teachers) (used to complete lines 1–3 on Worksheet C Summary)",null,null,null,null,null,null,null,null,null,null,null,null,"Shared Behavior Technician"]
["1. Name",null,null,"2. Name",null,null,"3. Name",null,null,null,null,null,null,"Shared Braillist"]
["Annual Special Education Base Salary",null,null,"Annual Special Education Base Salary",null,null,"Annual Special Education Base Salary",null,null,null,null,null,null,"Shared Bus Assistant"]
["Annual Caseload in Minutes for all students",null,null,"Annual Caseload in Minutes for all students",null,null,"Annual Caseload in Minutes for all students",null,null,null,null,null,null,"Shared Interpreter"]
["Cost per Minute",{"$f":"IFERROR(ROUND(B9/B10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(E9/E10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(H9/H10,4),0)","v":0},null,null,null,null,null,"Shared Nurse"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,null,null,null,null,"Shared Paraeducator"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,null,null,null,null,"SLPA"]
["Benefit Rate",1.3769,null,"Benefit Rate",1.3769,null,"Benefit Rate",1.3769,null,null,null,null,null,"COTA"]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(B11*B12*B13*B14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(E11*E12*E13*E14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(H11*H12*H13*H14)),0)","v":0},null,null,null,null,null,"PTA"]
[]
["Special Education Classified Staff (used to complete lines 4–9 on Worksheet C Summary)"]
["4. Name",null,null,"5. Name",null,null,"6. Name"]
["Position",null,null,"Position",null,null,"Position"]
["Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",1.5933999999999999,null,"Benefit Rate",1.5933999999999999,null,"Benefit Rate",1.5933999999999999]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B21=0,0,(((B20*B21*B22)/60)*B23)/B24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E21=0,0,(((E20*E21*E22)/60)*E23)/E24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H21=0,0,(((H20*H21*H22)/60)*H23)/H24),0)","v":0}]
[]
["7. Name",null,null,"8. Name",null,null,"9. Name"]
["Position",null,null,"Position",null,null,"Position"]
["Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",1.5933999999999999,null,"Benefit Rate",1.5933999999999999,null,"Benefit Rate",1.5933999999999999]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B30=0,0,(((B29*B30*B31)/60)*B32)/B33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E30=0,0,(((E29*E30*E31)/60)*E32)/E33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H30=0,0,(((H29*H30*H31)/60)*H32)/H33),0)","v":0}]

{"sheet":"Current IEP-Other Staff Costs","index":11,"n_rows":33,"n_cols":22,"rows_kept":33,"cut":false,"hidden":true,"merged":[[21,14,23,18],[0,0,0,13],[8,9,8,10],[8,12,8,13],[20,0,20,1],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,12,20,13],[19,0,19,13],[1,0,1,7],[8,0,8,1],[8,3,8,4],[8,6,8,7],[7,0,7,13]]}
["Current IEP - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Page: 1st Previous IEP-Staff Costs",null,null,null,null,null,"Other, please select"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Page: Current IEP-Staff Costs",null,null,null,null,null,"APE Teacher"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0},null,null,null,null,null,null,null,"Audiologist"]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Weeks per year",{"$f":"'Current IEP-Staff Costs'!H4","v":0},null,null,null,null,null,null,null,"BCBA"]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'Current IEP-Staff Costs'!H5","v":"mm/dd/yyyy"},null,null,null,null,null,null,null,"Contracted Teacher"]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'Current IEP-Staff Costs'!H6","v":"mm/dd/yyyy"},null,null,null,null,null,null,null,"Counselor"]
["Related Services Required to implement the IEP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O&M"]
["In-District Staff (used to complete lines 14–18 on Worksheet C Summary)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OT"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,"Other, please select",null,null,null,null,null,null,null,null,"PT"]
["14. Name",null,null,"15. Name",null,null,"16. Name",null,null,"17. Name",null,null,"18. Name",null,null,null,null,null,null,null,null,"SLP"]
["Annual Special Education Base Salary",null,null,"Annual Special Education Base Salary",null,null,"Annual Special Education Base Salary",null,null,"Annual Special Education Base Salary",null,null,"Annual Special Education Base Salary",null,null,null,null,null,null,null,null,"TOD"]
["Contract Hours ",null,null,"Contract Hours ",null,null,"Contract Hours ",null,null,"Contract Hours ",null,null,"Contract Hours ",null,null,null,null,null,null,null,null,"VI"]
["Cost per hour",{"$f":"IFERROR(ROUND(B11/B12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(E11/E12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(H11/H12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(K11/K12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(N11/N12,2),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",1.3769,null,"Benefit Rate",1.3769,null,"Benefit Rate",1.3769,null,"Benefit Rate",1.3769,null,"Benefit Rate",1.3769]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B14=0,0,((B13*(B14*B15/60))*B16/B17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E14=0,0,((E13*(E14*E15/60))*E16/E17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H14=0,0,((H13*(H14*H15/60))*H16/H17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K14=0,0,((K13*(K14*K15/60))*K16/K17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N14=0,0,((N13*(N14*N15/60))*N16/N17)),0)","v":0},null,null,null,null,null,null,null,"Other, please select"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APE Teacher"]
["Contracted Staff (used to complete lines 19–23 on Worksheet C Summary)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audiologist"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,"Other, please select",null,null,null,null,null,null,null,null,"BCBA"]
["19. Name",null,null,"20. Name",null,null,"21. Name",null,null,"22. Name",null,null,"23. Name",null,"Note: Do not include contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians here. Go to the Contracted 1 on 1 Billing tab to complete the costs for the student.",null,null,null,null,null,null,"Contracted Teacher"]
["Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate",null,null,null,null,null,null,null,null,"COTA"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,null,null,null,null,null,null,"Counselor"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,null,null,null,null,null,null,"Interpreter"]
["Annual Hours for this student",{"$f":"B24*B25/60","v":0},null,"Annual Hours for this student",{"$f":"E24*E25/60","v":0},null,"Annual Hours for this student",{"$f":"H24*H25/60","v":0},null,"Annual Hours for this student",{"$f":"K24*K25/60","v":0},null,"Annual Hours for this student",{"$f":"IF(N24=0,0,N24*N25/60)","v":0},null,null,null,null,null,null,null,"O&M"]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,null,null,null,null,null,null,"OT"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B27=0,0,(B23*B26)/B27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E27=0,0,(E23*E26)/E27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H27=0,0,(H23*H26)/H27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K27=0,0,(K23*K26)/K27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N27=0,0,(N23*N26)/N27),0)","v":0},null,null,null,null,null,null,null,"PT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SLPA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI"]

{"sheet":"1st Prev. IEP-Staff Costs","index":12,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[6,0,6,7],[16,0,16,7]]}
["1st Previous IEP - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: 1st Previous IEP-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous page: Current IEP-Other Staff Costs"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"('Start Here'!L21/180)*36","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from",{"$f":"'Start Here'!N21","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,"to",{"$f":"'Start Here'!P21","v":"mm/dd/yyyy"}]
["Special Education Certificated Staff (Special Education Teachers) (used to complete lines 1–3 on Worksheet C Summary)"]
["1. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B8)=TRUE,\" \",'Current IEP-Staff Costs'!B8)","v":" "},null,"2. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E8)=TRUE,\" \",'Current IEP-Staff Costs'!E8)","v":" "},null,"3. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H8)=TRUE,\" \",'Current IEP-Staff Costs'!H8)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B9)=TRUE,\" \",'Current IEP-Staff Costs'!B9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E9)=TRUE,\" \",'Current IEP-Staff Costs'!E9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H9)=TRUE,\" \",'Current IEP-Staff Costs'!H9)","v":" "}]
["Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B10)=TRUE,\" \",'Current IEP-Staff Costs'!B10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E10)=TRUE,\" \",'Current IEP-Staff Costs'!E10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H10)=TRUE,\" \",'Current IEP-Staff Costs'!H10)","v":" "}]
["Cost per Minute",{"$f":"IFERROR(ROUND(B9/B10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(E9/E10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(H9/H10,4),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H14","v":1.3769}]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(B11*B12*B13*B14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(E11*E12*E13*E14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(H11*H12*H13*H14)),0)","v":0}]
[]
["Special Education Classified Staff (used to complete lines 4–9 on Worksheet C Summary)"]
["4. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B18)=TRUE,\" \",'Current IEP-Staff Costs'!B18)","v":" "},null,"5. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E18)=TRUE,\" \",'Current IEP-Staff Costs'!E18)","v":" "},null,"6. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H18)=TRUE,\" \",'Current IEP-Staff Costs'!H18)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B19)=TRUE,\" \",'Current IEP-Staff Costs'!B19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E19)=TRUE,\" \",'Current IEP-Staff Costs'!E19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H19)=TRUE,\" \",'Current IEP-Staff Costs'!H19)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B20)=TRUE,\" \",'Current IEP-Staff Costs'!B20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E20)=TRUE,\" \",'Current IEP-Staff Costs'!E20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H20)=TRUE,\" \",'Current IEP-Staff Costs'!H20)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H23","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B21=0,0,(((B20*B21*B22)/60)*B23)/B24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E21=0,0,(((E20*E21*E22)/60)*E23)/E24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H21=0,0,(((H20*H21*H22)/60)*H23)/H24),0)","v":0}]
[]
["7. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B27)=TRUE,\" \",'Current IEP-Staff Costs'!B27)","v":" "},null,"8. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E27)=TRUE,\" \",'Current IEP-Staff Costs'!E27)","v":" "},null,"9. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H27)=TRUE,\" \",'Current IEP-Staff Costs'!H27)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B28)=TRUE,\" \",'Current IEP-Staff Costs'!B28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E28)=TRUE,\" \",'Current IEP-Staff Costs'!E28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H28)=TRUE,\" \",'Current IEP-Staff Costs'!H28)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B29)=TRUE,\" \",'Current IEP-Staff Costs'!B29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E29)=TRUE,\" \",'Current IEP-Staff Costs'!E29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H29)=TRUE,\" \",'Current IEP-Staff Costs'!H29)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H32","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B30=0,0,(((B29*B30*B31)/60)*B32)/B33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E30=0,0,(((E29*E30*E31)/60)*E32)/E33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H30=0,0,(((H29*H30*H31)/60)*H32)/H33),0)","v":0}]

{"sheet":"1st Prev. IEP-Other Staff Costs","index":13,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,7],[7,0,7,13],[8,0,8,1],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13],[21,14,23,18],[19,0,19,13],[20,0,20,1],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,12,20,13]]}
["1st Previous IEP - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Page: 2nd Previous IEP-Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Page: 1st Previous IEP-Staff Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Weeks per year",{"$f":"'1st Prev. IEP-Staff Costs'!H4","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'1st Prev. IEP-Staff Costs'!H5","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'1st Prev. IEP-Staff Costs'!H6","v":"mm/dd/yyyy"}]
["Related Services Required to implement the IEP"]
["In-District Staff (used to complete lines 14–18 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M9)=TRUE,\" \",'Current IEP-Other Staff Costs'!M9)","v":"Other, please select"}]
["14. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B10)=TRUE,\" \",'Current IEP-Other Staff Costs'!B10)","v":" "},null,"15. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E10)=TRUE,\" \",'Current IEP-Other Staff Costs'!E10)","v":" "},null,"16. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,\" \",'Current IEP-Other Staff Costs'!H10)","v":" "},null,"17. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,\" \",'Current IEP-Other Staff Costs'!K10)","v":" "},null,"18. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,\" \",'Current IEP-Other Staff Costs'!N10)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B11)=TRUE,\" \",'Current IEP-Other Staff Costs'!B11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E11)=TRUE,\" \",'Current IEP-Other Staff Costs'!E11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H11)=TRUE,\" \",'Current IEP-Other Staff Costs'!H11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K11)=TRUE,\" \",'Current IEP-Other Staff Costs'!K11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N11)=TRUE,\" \",'Current IEP-Other Staff Costs'!N11)","v":" "}]
["Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B12)=TRUE,\" \",'Current IEP-Other Staff Costs'!B12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E12)=TRUE,\" \",'Current IEP-Other Staff Costs'!E12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H12)=TRUE,\" \",'Current IEP-Other Staff Costs'!H12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K12)=TRUE,\" \",'Current IEP-Other Staff Costs'!K12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N12)=TRUE,\" \",'Current IEP-Other Staff Costs'!N12)","v":" "}]
["Cost per hour",{"$f":"IFERROR(ROUND(B11/B12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(E11/E12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(H11/H12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(K11/K12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(N11/N12,2),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!B16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!E16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!H16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!K16","v":1.3769},null,"Benefit Rate",1.3769]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B14=0,0,((B13*(B14*B15/60))*B16/B17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E14=0,0,((E13*(E14*E15/60))*E16/E17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H14=0,0,((H13*(H14*H15/60))*H16/H17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K14=0,0,((K13*(K14*K15/60))*K16/K17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N14=0,0,((N13*(N14*N15/60))*N16/N17)),0)","v":0}]
[]
["Contracted Staff (used to complete lines 19–23 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M21)=TRUE,\" \",'Current IEP-Other Staff Costs'!M21)","v":"Other, please select"}]
["19. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,\" \",'Current IEP-Other Staff Costs'!B22)","v":" "},null,"20. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,\" \",'Current IEP-Other Staff Costs'!E22)","v":" "},null,"21. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,\" \",'Current IEP-Other Staff Costs'!H22)","v":" "},null,"22. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,\" \",'Current IEP-Other Staff Costs'!K22)","v":" "},null,"23. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,\" \",'Current IEP-Other Staff Costs'!N22)","v":" "},"Note: Do not include contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians here. Go to the Contracted 1 on 1 Billing tab to complete the costs for the student."]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B23)=TRUE,\" \",'Current IEP-Other Staff Costs'!B23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E23)=TRUE,\" \",'Current IEP-Other Staff Costs'!E23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H23)=TRUE,\" \",'Current IEP-Other Staff Costs'!H23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K23)=TRUE,\" \",'Current IEP-Other Staff Costs'!K23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N23)=TRUE,\" \",'Current IEP-Other Staff Costs'!N23)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Annual Hours for this student",{"$f":"B24*B25/60","v":0},null,"Annual Hours for this student",{"$f":"E24*E25/60","v":0},null,"Annual Hours for this student",{"$f":"H24*H25/60","v":0},null,"Annual Hours for this student",{"$f":"K24*K25/60","v":0},null,"Annual Hours for this student",{"$f":"IF(N24=0,0,N24*N25/60)","v":0}]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B27=0,0,(B23*B26)/B27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E27=0,0,(E23*E26)/E27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H27=0,0,(H23*H26)/H27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K27=0,0,(K23*K26)/K27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N27=0,0,(N23*N26)/N27),0)","v":0}]

{"sheet":"2nd Prev. IEP-Staff Costs","index":14,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[6,0,6,7],[16,0,16,7]]}
["2nd Previous IEP - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: 2nd Previous IEP-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous page: 1st Previous IEP-Other Staff Costs"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"('Start Here'!L35/180)*36","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from",{"$f":"'Start Here'!N35","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,"to",{"$f":"'Start Here'!P35","v":"mm/dd/yyyy"}]
["Special Education Certificated Staff (Special Education Teachers) (used to complete lines 1–3 on Worksheet C Summary)"]
["1. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B8)=TRUE,\" \",'Current IEP-Staff Costs'!B8)","v":" "},null,"2. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E8)=TRUE,\" \",'Current IEP-Staff Costs'!E8)","v":" "},null,"3. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H8)=TRUE,\" \",'Current IEP-Staff Costs'!H8)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B9)=TRUE,\" \",'Current IEP-Staff Costs'!B9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E9)=TRUE,\" \",'Current IEP-Staff Costs'!E9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H9)=TRUE,\" \",'Current IEP-Staff Costs'!H9)","v":" "}]
["Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B10)=TRUE,\" \",'Current IEP-Staff Costs'!B10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E10)=TRUE,\" \",'Current IEP-Staff Costs'!E10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H10)=TRUE,\" \",'Current IEP-Staff Costs'!H10)","v":" "}]
["Cost per Minute",{"$f":"IFERROR(ROUND(B9/B10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(E9/E10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(H9/H10,4),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H14","v":1.3769}]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(B11*B12*B13*B14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(E11*E12*E13*E14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(H11*H12*H13*H14)),0)","v":0}]
[]
["Special Education Classified Staff (used to complete lines 4–9 on Worksheet C Summary)"]
["4. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B18)=TRUE,\" \",'Current IEP-Staff Costs'!B18)","v":" "},null,"5. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E18)=TRUE,\" \",'Current IEP-Staff Costs'!E18)","v":" "},null,"6. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H18)=TRUE,\" \",'Current IEP-Staff Costs'!H18)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B19)=TRUE,\" \",'Current IEP-Staff Costs'!B19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E19)=TRUE,\" \",'Current IEP-Staff Costs'!E19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H19)=TRUE,\" \",'Current IEP-Staff Costs'!H19)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B20)=TRUE,\" \",'Current IEP-Staff Costs'!B20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E20)=TRUE,\" \",'Current IEP-Staff Costs'!E20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H20)=TRUE,\" \",'Current IEP-Staff Costs'!H20)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H23","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B21=0,0,(((B20*B21*B22)/60)*B23)/B24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E21=0,0,(((E20*E21*E22)/60)*E23)/E24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H21=0,0,(((H20*H21*H22)/60)*H23)/H24),0)","v":0}]
[]
["7. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B27)=TRUE,\" \",'Current IEP-Staff Costs'!B27)","v":" "},null,"8. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E27)=TRUE,\" \",'Current IEP-Staff Costs'!E27)","v":" "},null,"9. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H27)=TRUE,\" \",'Current IEP-Staff Costs'!H27)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B28)=TRUE,\" \",'Current IEP-Staff Costs'!B28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E28)=TRUE,\" \",'Current IEP-Staff Costs'!E28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H28)=TRUE,\" \",'Current IEP-Staff Costs'!H28)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B29)=TRUE,\" \",'Current IEP-Staff Costs'!B29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E29)=TRUE,\" \",'Current IEP-Staff Costs'!E29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H29)=TRUE,\" \",'Current IEP-Staff Costs'!H29)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H32","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B30=0,0,(((B29*B30*B31)/60)*B32)/B33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E30=0,0,(((E29*E30*E31)/60)*E32)/E33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H30=0,0,(((H29*H30*H31)/60)*H32)/H33),0)","v":0}]

{"sheet":"2nd Prev. IEP-Other Staff Costs","index":15,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,7],[7,0,7,13],[8,0,8,1],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13],[21,14,23,18],[19,0,19,13],[20,0,20,1],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,12,20,13]]}
["2nd Previous IEP - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Page: 3rd Previous IEP-Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Page: 2nd Previous IEP-Staff Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Weeks per year",{"$f":"'2nd Prev. IEP-Staff Costs'!H4","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'2nd Prev. IEP-Staff Costs'!H5","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'2nd Prev. IEP-Staff Costs'!H6","v":"mm/dd/yyyy"}]
["Related Services Required to implement the IEP"]
["In-District Staff (used to complete lines 14–18 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M9)=TRUE,\" \",'Current IEP-Other Staff Costs'!M9)","v":"Other, please select"}]
["14. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B10)=TRUE,\" \",'Current IEP-Other Staff Costs'!B10)","v":" "},null,"15. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E10)=TRUE,\" \",'Current IEP-Other Staff Costs'!E10)","v":" "},null,"16. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,\" \",'Current IEP-Other Staff Costs'!H10)","v":" "},null,"17. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,\" \",'Current IEP-Other Staff Costs'!K10)","v":" "},null,"18. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,\" \",'Current IEP-Other Staff Costs'!N10)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B11)=TRUE,\" \",'Current IEP-Other Staff Costs'!B11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E11)=TRUE,\" \",'Current IEP-Other Staff Costs'!E11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H11)=TRUE,\" \",'Current IEP-Other Staff Costs'!H11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K11)=TRUE,\" \",'Current IEP-Other Staff Costs'!K11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N11)=TRUE,\" \",'Current IEP-Other Staff Costs'!N11)","v":" "}]
["Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B12)=TRUE,\" \",'Current IEP-Other Staff Costs'!B12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E12)=TRUE,\" \",'Current IEP-Other Staff Costs'!E12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H12)=TRUE,\" \",'Current IEP-Other Staff Costs'!H12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K12)=TRUE,\" \",'Current IEP-Other Staff Costs'!K12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N12)=TRUE,\" \",'Current IEP-Other Staff Costs'!N12)","v":" "}]
["Cost per hour",{"$f":"IFERROR(ROUND(B11/B12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(E11/E12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(H11/H12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(K11/K12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(N11/N12,2),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!B16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!E16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!H16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!K16","v":1.3769},null,"Benefit Rate",1.3769]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B14=0,0,((B13*(B14*B15/60))*B16/B17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E14=0,0,((E13*(E14*E15/60))*E16/E17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H14=0,0,((H13*(H14*H15/60))*H16/H17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K14=0,0,((K13*(K14*K15/60))*K16/K17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N14=0,0,((N13*(N14*N15/60))*N16/N17)),0)","v":0}]
[]
["Contracted Staff (used to complete lines 19–23 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M21)=TRUE,\" \",'Current IEP-Other Staff Costs'!M21)","v":"Other, please select"}]
["19. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,\" \",'Current IEP-Other Staff Costs'!B22)","v":" "},null,"20. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,\" \",'Current IEP-Other Staff Costs'!E22)","v":" "},null,"21. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,\" \",'Current IEP-Other Staff Costs'!H22)","v":" "},null,"22. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,\" \",'Current IEP-Other Staff Costs'!K22)","v":" "},null,"23. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,\" \",'Current IEP-Other Staff Costs'!N22)","v":" "},"Note: Do not include contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians here. Go to the Contracted 1 on 1 Billing tab to complete the costs for the student."]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B23)=TRUE,\" \",'Current IEP-Other Staff Costs'!B23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E23)=TRUE,\" \",'Current IEP-Other Staff Costs'!E23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H23)=TRUE,\" \",'Current IEP-Other Staff Costs'!H23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K23)=TRUE,\" \",'Current IEP-Other Staff Costs'!K23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N23)=TRUE,\" \",'Current IEP-Other Staff Costs'!N23)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Annual Hours for this student",{"$f":"B24*B25/60","v":0},null,"Annual Hours for this student",{"$f":"E24*E25/60","v":0},null,"Annual Hours for this student",{"$f":"H24*H25/60","v":0},null,"Annual Hours for this student",{"$f":"K24*K25/60","v":0},null,"Annual Hours for this student",{"$f":"IF(N24=0,0,N24*N25/60)","v":0}]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B27=0,0,(B23*B26)/B27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E27=0,0,(E23*E26)/E27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H27=0,0,(H23*H26)/H27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K27=0,0,(K23*K26)/K27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N27=0,0,(N23*N26)/N27),0)","v":0}]

{"sheet":"3rd Prev. IEP-Staff Costs","index":16,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[6,0,6,7],[16,0,16,7]]}
["3rd Previous IEP - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: 3rd Previous IEP-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous page: 2nd Previous IEP-Other Staff Costs"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"('Start Here'!L49/180)*36","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from",{"$f":"'Start Here'!N49","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,"to",{"$f":"'Start Here'!P49","v":"mm/dd/yyyy"}]
["Special Education Certificated Staff (Special Education Teachers) (used to complete lines 1–3 on Worksheet C Summary)"]
["1. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B8)=TRUE,\" \",'Current IEP-Staff Costs'!B8)","v":" "},null,"2. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E8)=TRUE,\" \",'Current IEP-Staff Costs'!E8)","v":" "},null,"3. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H8)=TRUE,\" \",'Current IEP-Staff Costs'!H8)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B9)=TRUE,\" \",'Current IEP-Staff Costs'!B9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E9)=TRUE,\" \",'Current IEP-Staff Costs'!E9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H9)=TRUE,\" \",'Current IEP-Staff Costs'!H9)","v":" "}]
["Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B10)=TRUE,\" \",'Current IEP-Staff Costs'!B10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E10)=TRUE,\" \",'Current IEP-Staff Costs'!E10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H10)=TRUE,\" \",'Current IEP-Staff Costs'!H10)","v":" "}]
["Cost per Minute",{"$f":"IFERROR(ROUND(B9/B10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(E9/E10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(H9/H10,4),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H14","v":1.3769}]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(B11*B12*B13*B14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(E11*E12*E13*E14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(H11*H12*H13*H14)),0)","v":0}]
[]
["Special Education Classified Staff (used to complete lines 4–9 on Worksheet C Summary)"]
["4. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B18)=TRUE,\" \",'Current IEP-Staff Costs'!B18)","v":" "},null,"5. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E18)=TRUE,\" \",'Current IEP-Staff Costs'!E18)","v":" "},null,"6. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H18)=TRUE,\" \",'Current IEP-Staff Costs'!H18)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B19)=TRUE,\" \",'Current IEP-Staff Costs'!B19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E19)=TRUE,\" \",'Current IEP-Staff Costs'!E19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H19)=TRUE,\" \",'Current IEP-Staff Costs'!H19)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B20)=TRUE,\" \",'Current IEP-Staff Costs'!B20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E20)=TRUE,\" \",'Current IEP-Staff Costs'!E20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H20)=TRUE,\" \",'Current IEP-Staff Costs'!H20)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H23","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B21=0,0,(((B20*B21*B22)/60)*B23)/B24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E21=0,0,(((E20*E21*E22)/60)*E23)/E24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H21=0,0,(((H20*H21*H22)/60)*H23)/H24),0)","v":0}]
[]
["7. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B27)=TRUE,\" \",'Current IEP-Staff Costs'!B27)","v":" "},null,"8. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E27)=TRUE,\" \",'Current IEP-Staff Costs'!E27)","v":" "},null,"9. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H27)=TRUE,\" \",'Current IEP-Staff Costs'!H27)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B28)=TRUE,\" \",'Current IEP-Staff Costs'!B28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E28)=TRUE,\" \",'Current IEP-Staff Costs'!E28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H28)=TRUE,\" \",'Current IEP-Staff Costs'!H28)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B29)=TRUE,\" \",'Current IEP-Staff Costs'!B29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E29)=TRUE,\" \",'Current IEP-Staff Costs'!E29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H29)=TRUE,\" \",'Current IEP-Staff Costs'!H29)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H32","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B30=0,0,(((B29*B30*B31)/60)*B32)/B33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E30=0,0,(((E29*E30*E31)/60)*E32)/E33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H30=0,0,(((H29*H30*H31)/60)*H32)/H33),0)","v":0}]

{"sheet":"3rd Prev. IEP-Other Staff Costs","index":17,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,7],[7,0,7,13],[8,0,8,1],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13],[21,14,23,18],[19,0,19,13],[20,0,20,1],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,12,20,13]]}
["3rd Previous IEP - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Page: 4th Previous IEP-Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Page: 3rd Previous IEP-Staff Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Weeks per year",{"$f":"'3rd Prev. IEP-Staff Costs'!H4","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'3rd Prev. IEP-Staff Costs'!H5","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'3rd Prev. IEP-Staff Costs'!H6","v":"mm/dd/yyyy"}]
["Related Services Required to implement the IEP"]
["In-District Staff (used to complete lines 14–18 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M9)=TRUE,\" \",'Current IEP-Other Staff Costs'!M9)","v":"Other, please select"}]
["14. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B10)=TRUE,\" \",'Current IEP-Other Staff Costs'!B10)","v":" "},null,"15. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E10)=TRUE,\" \",'Current IEP-Other Staff Costs'!E10)","v":" "},null,"16. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,\" \",'Current IEP-Other Staff Costs'!H10)","v":" "},null,"17. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,\" \",'Current IEP-Other Staff Costs'!K10)","v":" "},null,"18. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,\" \",'Current IEP-Other Staff Costs'!N10)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B11)=TRUE,\" \",'Current IEP-Other Staff Costs'!B11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E11)=TRUE,\" \",'Current IEP-Other Staff Costs'!E11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H11)=TRUE,\" \",'Current IEP-Other Staff Costs'!H11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K11)=TRUE,\" \",'Current IEP-Other Staff Costs'!K11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N11)=TRUE,\" \",'Current IEP-Other Staff Costs'!N11)","v":" "}]
["Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B12)=TRUE,\" \",'Current IEP-Other Staff Costs'!B12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E12)=TRUE,\" \",'Current IEP-Other Staff Costs'!E12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H12)=TRUE,\" \",'Current IEP-Other Staff Costs'!H12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K12)=TRUE,\" \",'Current IEP-Other Staff Costs'!K12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N12)=TRUE,\" \",'Current IEP-Other Staff Costs'!N12)","v":" "}]
["Cost per hour",{"$f":"IFERROR(ROUND(B11/B12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(E11/E12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(H11/H12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(K11/K12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(N11/N12,2),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!B16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!E16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!H16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!K16","v":1.3769},null,"Benefit Rate",1.3769]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B14=0,0,((B13*(B14*B15/60))*B16/B17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E14=0,0,((E13*(E14*E15/60))*E16/E17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H14=0,0,((H13*(H14*H15/60))*H16/H17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K14=0,0,((K13*(K14*K15/60))*K16/K17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N14=0,0,((N13*(N14*N15/60))*N16/N17)),0)","v":0}]
[]
["Contracted Staff (used to complete lines 19–23 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M21)=TRUE,\" \",'Current IEP-Other Staff Costs'!M21)","v":"Other, please select"}]
["19. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,\" \",'Current IEP-Other Staff Costs'!B22)","v":" "},null,"20. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,\" \",'Current IEP-Other Staff Costs'!E22)","v":" "},null,"21. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,\" \",'Current IEP-Other Staff Costs'!H22)","v":" "},null,"22. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,\" \",'Current IEP-Other Staff Costs'!K22)","v":" "},null,"23. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,\" \",'Current IEP-Other Staff Costs'!N22)","v":" "},"Note: Do not include contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians here. Go to the Contracted 1 on 1 Billing tab to complete the costs for the student."]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B23)=TRUE,\" \",'Current IEP-Other Staff Costs'!B23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E23)=TRUE,\" \",'Current IEP-Other Staff Costs'!E23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H23)=TRUE,\" \",'Current IEP-Other Staff Costs'!H23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K23)=TRUE,\" \",'Current IEP-Other Staff Costs'!K23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N23)=TRUE,\" \",'Current IEP-Other Staff Costs'!N23)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Annual Hours for this student",{"$f":"B24*B25/60","v":0},null,"Annual Hours for this student",{"$f":"E24*E25/60","v":0},null,"Annual Hours for this student",{"$f":"H24*H25/60","v":0},null,"Annual Hours for this student",{"$f":"K24*K25/60","v":0},null,"Annual Hours for this student",{"$f":"IF(N24=0,0,N24*N25/60)","v":0}]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B27=0,0,(B23*B26)/B27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E27=0,0,(E23*E26)/E27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H27=0,0,(H23*H26)/H27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K27=0,0,(K23*K26)/K27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N27=0,0,(N23*N26)/N27),0)","v":0}]

{"sheet":"4th Prev. IEP-Staff Costs","index":18,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[6,0,6,7],[16,0,16,7]]}
["4th Previous IEP - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: 4th Previous IEP-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous page: 3rd Previous IEP-Other Staff Costs"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"('Start Here'!L63/180)*36","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from",{"$f":"'Start Here'!N63","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,"to",{"$f":"'Start Here'!P63","v":"mm/dd/yyyy"}]
["Special Education Certificated Staff (Special Education Teachers) (used to complete lines 1–3 on Worksheet C Summary)"]
["1. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B8)=TRUE,\" \",'Current IEP-Staff Costs'!B8)","v":" "},null,"2. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E8)=TRUE,\" \",'Current IEP-Staff Costs'!E8)","v":" "},null,"3. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H8)=TRUE,\" \",'Current IEP-Staff Costs'!H8)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B9)=TRUE,\" \",'Current IEP-Staff Costs'!B9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E9)=TRUE,\" \",'Current IEP-Staff Costs'!E9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H9)=TRUE,\" \",'Current IEP-Staff Costs'!H9)","v":" "}]
["Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B10)=TRUE,\" \",'Current IEP-Staff Costs'!B10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E10)=TRUE,\" \",'Current IEP-Staff Costs'!E10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H10)=TRUE,\" \",'Current IEP-Staff Costs'!H10)","v":" "}]
["Cost per Minute",{"$f":"IFERROR(ROUND(B9/B10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(E9/E10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(H9/H10,4),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H14","v":1.3769}]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(B11*B12*B13*B14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(E11*E12*E13*E14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(H11*H12*H13*H14)),0)","v":0}]
[]
["Special Education Classified Staff (used to complete lines 4–9 on Worksheet C Summary)"]
["4. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B18)=TRUE,\" \",'Current IEP-Staff Costs'!B18)","v":" "},null,"5. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E18)=TRUE,\" \",'Current IEP-Staff Costs'!E18)","v":" "},null,"6. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H18)=TRUE,\" \",'Current IEP-Staff Costs'!H18)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B19)=TRUE,\" \",'Current IEP-Staff Costs'!B19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E19)=TRUE,\" \",'Current IEP-Staff Costs'!E19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H19)=TRUE,\" \",'Current IEP-Staff Costs'!H19)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B20)=TRUE,\" \",'Current IEP-Staff Costs'!B20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E20)=TRUE,\" \",'Current IEP-Staff Costs'!E20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H20)=TRUE,\" \",'Current IEP-Staff Costs'!H20)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H23","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B21=0,0,(((B20*B21*B22)/60)*B23)/B24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E21=0,0,(((E20*E21*E22)/60)*E23)/E24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H21=0,0,(((H20*H21*H22)/60)*H23)/H24),0)","v":0}]
[]
["7. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B27)=TRUE,\" \",'Current IEP-Staff Costs'!B27)","v":" "},null,"8. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E27)=TRUE,\" \",'Current IEP-Staff Costs'!E27)","v":" "},null,"9. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H27)=TRUE,\" \",'Current IEP-Staff Costs'!H27)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B28)=TRUE,\" \",'Current IEP-Staff Costs'!B28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E28)=TRUE,\" \",'Current IEP-Staff Costs'!E28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H28)=TRUE,\" \",'Current IEP-Staff Costs'!H28)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B29)=TRUE,\" \",'Current IEP-Staff Costs'!B29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E29)=TRUE,\" \",'Current IEP-Staff Costs'!E29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H29)=TRUE,\" \",'Current IEP-Staff Costs'!H29)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H32","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B30=0,0,(((B29*B30*B31)/60)*B32)/B33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E30=0,0,(((E29*E30*E31)/60)*E32)/E33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H30=0,0,(((H29*H30*H31)/60)*H32)/H33),0)","v":0}]

{"sheet":"4th Prev. IEP-Other Staff Costs","index":19,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,7],[7,0,7,13],[8,0,8,1],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13],[21,14,23,18],[19,0,19,13],[20,0,20,1],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,12,20,13]]}
["4th Previous IEP - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Page: 5th Previous IEP-Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Page: 4th Previous IEP-Staff Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Weeks per year",{"$f":"'4th Prev. IEP-Staff Costs'!H4","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'4th Prev. IEP-Staff Costs'!H5","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'4th Prev. IEP-Staff Costs'!H6","v":"mm/dd/yyyy"}]
["Related Services Required to implement the IEP"]
["In-District Staff (used to complete lines 14–18 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M9)=TRUE,\" \",'Current IEP-Other Staff Costs'!M9)","v":"Other, please select"}]
["14. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B10)=TRUE,\" \",'Current IEP-Other Staff Costs'!B10)","v":" "},null,"15. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E10)=TRUE,\" \",'Current IEP-Other Staff Costs'!E10)","v":" "},null,"16. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,\" \",'Current IEP-Other Staff Costs'!H10)","v":" "},null,"17. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,\" \",'Current IEP-Other Staff Costs'!K10)","v":" "},null,"18. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,\" \",'Current IEP-Other Staff Costs'!N10)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B11)=TRUE,\" \",'Current IEP-Other Staff Costs'!B11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E11)=TRUE,\" \",'Current IEP-Other Staff Costs'!E11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H11)=TRUE,\" \",'Current IEP-Other Staff Costs'!H11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K11)=TRUE,\" \",'Current IEP-Other Staff Costs'!K11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N11)=TRUE,\" \",'Current IEP-Other Staff Costs'!N11)","v":" "}]
["Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B12)=TRUE,\" \",'Current IEP-Other Staff Costs'!B12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E12)=TRUE,\" \",'Current IEP-Other Staff Costs'!E12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H12)=TRUE,\" \",'Current IEP-Other Staff Costs'!H12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K12)=TRUE,\" \",'Current IEP-Other Staff Costs'!K12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N12)=TRUE,\" \",'Current IEP-Other Staff Costs'!N12)","v":" "}]
["Cost per hour",{"$f":"IFERROR(ROUND(B11/B12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(E11/E12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(H11/H12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(K11/K12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(N11/N12,2),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!B16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!E16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!H16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!K16","v":1.3769},null,"Benefit Rate",1.3769]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B14=0,0,((B13*(B14*B15/60))*B16/B17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E14=0,0,((E13*(E14*E15/60))*E16/E17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H14=0,0,((H13*(H14*H15/60))*H16/H17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K14=0,0,((K13*(K14*K15/60))*K16/K17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N14=0,0,((N13*(N14*N15/60))*N16/N17)),0)","v":0}]
[]
["Contracted Staff (used to complete lines 19–23 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M21)=TRUE,\" \",'Current IEP-Other Staff Costs'!M21)","v":"Other, please select"}]
["19. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,\" \",'Current IEP-Other Staff Costs'!B22)","v":" "},null,"20. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,\" \",'Current IEP-Other Staff Costs'!E22)","v":" "},null,"21. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,\" \",'Current IEP-Other Staff Costs'!H22)","v":" "},null,"22. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,\" \",'Current IEP-Other Staff Costs'!K22)","v":" "},null,"23. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,\" \",'Current IEP-Other Staff Costs'!N22)","v":" "},"Note: Do not include contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians here. Go to the Contracted 1 on 1 Billing tab to complete the costs for the student."]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B23)=TRUE,\" \",'Current IEP-Other Staff Costs'!B23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E23)=TRUE,\" \",'Current IEP-Other Staff Costs'!E23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H23)=TRUE,\" \",'Current IEP-Other Staff Costs'!H23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K23)=TRUE,\" \",'Current IEP-Other Staff Costs'!K23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N23)=TRUE,\" \",'Current IEP-Other Staff Costs'!N23)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Annual Hours for this student",{"$f":"B24*B25/60","v":0},null,"Annual Hours for this student",{"$f":"E24*E25/60","v":0},null,"Annual Hours for this student",{"$f":"H24*H25/60","v":0},null,"Annual Hours for this student",{"$f":"K24*K25/60","v":0},null,"Annual Hours for this student",{"$f":"IF(N24=0,0,N24*N25/60)","v":0}]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B27=0,0,(B23*B26)/B27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E27=0,0,(E23*E26)/E27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H27=0,0,(H23*H26)/H27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K27=0,0,(K23*K26)/K27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N27=0,0,(N23*N26)/N27),0)","v":0}]

{"sheet":"5th Prev. IEP-Staff Costs","index":20,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[6,0,6,7],[16,0,16,7]]}
["5th Previous IEP - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: 5th Previous IEP-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous page: 4th Previous IEP-Other Staff Costs"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"('Start Here'!L77/180)*36","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from",{"$f":"'Start Here'!N77","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,"to",{"$f":"'Start Here'!P77","v":"mm/dd/yyyy"}]
["Special Education Certificated Staff (Special Education Teachers) (used to complete lines 1–3 on Worksheet C Summary)"]
["1. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B8)=TRUE,\" \",'Current IEP-Staff Costs'!B8)","v":" "},null,"2. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E8)=TRUE,\" \",'Current IEP-Staff Costs'!E8)","v":" "},null,"3. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H8)=TRUE,\" \",'Current IEP-Staff Costs'!H8)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B9)=TRUE,\" \",'Current IEP-Staff Costs'!B9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E9)=TRUE,\" \",'Current IEP-Staff Costs'!E9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H9)=TRUE,\" \",'Current IEP-Staff Costs'!H9)","v":" "}]
["Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B10)=TRUE,\" \",'Current IEP-Staff Costs'!B10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E10)=TRUE,\" \",'Current IEP-Staff Costs'!E10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H10)=TRUE,\" \",'Current IEP-Staff Costs'!H10)","v":" "}]
["Cost per Minute",{"$f":"IFERROR(ROUND(B9/B10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(E9/E10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(H9/H10,4),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H14","v":1.3769}]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(B11*B12*B13*B14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(E11*E12*E13*E14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(H11*H12*H13*H14)),0)","v":0}]
[]
["Special Education Classified Staff (used to complete lines 4–9 on Worksheet C Summary)"]
["4. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B18)=TRUE,\" \",'Current IEP-Staff Costs'!B18)","v":" "},null,"5. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E18)=TRUE,\" \",'Current IEP-Staff Costs'!E18)","v":" "},null,"6. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H18)=TRUE,\" \",'Current IEP-Staff Costs'!H18)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B19)=TRUE,\" \",'Current IEP-Staff Costs'!B19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E19)=TRUE,\" \",'Current IEP-Staff Costs'!E19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H19)=TRUE,\" \",'Current IEP-Staff Costs'!H19)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B20)=TRUE,\" \",'Current IEP-Staff Costs'!B20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E20)=TRUE,\" \",'Current IEP-Staff Costs'!E20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H20)=TRUE,\" \",'Current IEP-Staff Costs'!H20)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H23","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B21=0,0,(((B20*B21*B22)/60)*B23)/B24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E21=0,0,(((E20*E21*E22)/60)*E23)/E24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H21=0,0,(((H20*H21*H22)/60)*H23)/H24),0)","v":0}]
[]
["7. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B27)=TRUE,\" \",'Current IEP-Staff Costs'!B27)","v":" "},null,"8. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E27)=TRUE,\" \",'Current IEP-Staff Costs'!E27)","v":" "},null,"9. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H27)=TRUE,\" \",'Current IEP-Staff Costs'!H27)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B28)=TRUE,\" \",'Current IEP-Staff Costs'!B28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E28)=TRUE,\" \",'Current IEP-Staff Costs'!E28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H28)=TRUE,\" \",'Current IEP-Staff Costs'!H28)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B29)=TRUE,\" \",'Current IEP-Staff Costs'!B29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E29)=TRUE,\" \",'Current IEP-Staff Costs'!E29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H29)=TRUE,\" \",'Current IEP-Staff Costs'!H29)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H32","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B30=0,0,(((B29*B30*B31)/60)*B32)/B33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E30=0,0,(((E29*E30*E31)/60)*E32)/E33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H30=0,0,(((H29*H30*H31)/60)*H32)/H33),0)","v":0}]

{"sheet":"5th Prev. IEP-Other Staff Costs","index":21,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[21,14,23,18],[19,0,19,13],[20,0,20,1],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,12,20,13],[0,0,0,13],[1,0,1,7],[7,0,7,13],[8,0,8,1],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13]]}
["5th Previous IEP - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Page: 6th Previous-Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Page: 5th Previous IEP-Staff Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Weeks per year",{"$f":"'5th Prev. IEP-Staff Costs'!H4","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'5th Prev. IEP-Staff Costs'!H5","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'5th Prev. IEP-Staff Costs'!H6","v":"mm/dd/yyyy"}]
["Related Services Required to implement the IEP"]
["In-District Staff (used to complete lines 14–18 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M9)=TRUE,\" \",'Current IEP-Other Staff Costs'!M9)","v":"Other, please select"}]
["14. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B10)=TRUE,\" \",'Current IEP-Other Staff Costs'!B10)","v":" "},null,"15. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E10)=TRUE,\" \",'Current IEP-Other Staff Costs'!E10)","v":" "},null,"16. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,\" \",'Current IEP-Other Staff Costs'!H10)","v":" "},null,"17. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,\" \",'Current IEP-Other Staff Costs'!K10)","v":" "},null,"18. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,\" \",'Current IEP-Other Staff Costs'!N10)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B11)=TRUE,\" \",'Current IEP-Other Staff Costs'!B11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E11)=TRUE,\" \",'Current IEP-Other Staff Costs'!E11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H11)=TRUE,\" \",'Current IEP-Other Staff Costs'!H11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K11)=TRUE,\" \",'Current IEP-Other Staff Costs'!K11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N11)=TRUE,\" \",'Current IEP-Other Staff Costs'!N11)","v":" "}]
["Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B12)=TRUE,\" \",'Current IEP-Other Staff Costs'!B12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E12)=TRUE,\" \",'Current IEP-Other Staff Costs'!E12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H12)=TRUE,\" \",'Current IEP-Other Staff Costs'!H12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K12)=TRUE,\" \",'Current IEP-Other Staff Costs'!K12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N12)=TRUE,\" \",'Current IEP-Other Staff Costs'!N12)","v":" "}]
["Cost per hour",{"$f":"IFERROR(ROUND(B11/B12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(E11/E12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(H11/H12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(K11/K12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(N11/N12,2),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!B16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!E16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!H16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!K16","v":1.3769},null,"Benefit Rate",1.3769]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B14=0,0,((B13*(B14*B15/60))*B16/B17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E14=0,0,((E13*(E14*E15/60))*E16/E17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H14=0,0,((H13*(H14*H15/60))*H16/H17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K14=0,0,((K13*(K14*K15/60))*K16/K17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N14=0,0,((N13*(N14*N15/60))*N16/N17)),0)","v":0}]
[]
["Contracted Staff (used to complete lines 19–23 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M21)=TRUE,\" \",'Current IEP-Other Staff Costs'!M21)","v":"Other, please select"}]
["19. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,\" \",'Current IEP-Other Staff Costs'!B22)","v":" "},null,"20. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,\" \",'Current IEP-Other Staff Costs'!E22)","v":" "},null,"21. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,\" \",'Current IEP-Other Staff Costs'!H22)","v":" "},null,"22. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,\" \",'Current IEP-Other Staff Costs'!K22)","v":" "},null,"23. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,\" \",'Current IEP-Other Staff Costs'!N22)","v":" "},"Note: Do not include contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians here. Go to the Contracted 1 on 1 Billing tab to complete the costs for the student."]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B23)=TRUE,\" \",'Current IEP-Other Staff Costs'!B23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E23)=TRUE,\" \",'Current IEP-Other Staff Costs'!E23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H23)=TRUE,\" \",'Current IEP-Other Staff Costs'!H23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K23)=TRUE,\" \",'Current IEP-Other Staff Costs'!K23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N23)=TRUE,\" \",'Current IEP-Other Staff Costs'!N23)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Annual Hours for this student",{"$f":"B24*B25/60","v":0},null,"Annual Hours for this student",{"$f":"E24*E25/60","v":0},null,"Annual Hours for this student",{"$f":"H24*H25/60","v":0},null,"Annual Hours for this student",{"$f":"K24*K25/60","v":0},null,"Annual Hours for this student",{"$f":"IF(N24=0,0,N24*N25/60)","v":0}]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B27=0,0,(B23*B26)/B27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E27=0,0,(E23*E26)/E27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H27=0,0,(H23*H26)/H27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K27=0,0,(K23*K26)/K27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N27=0,0,(N23*N26)/N27),0)","v":0}]

{"sheet":"6th Prev. IEP-Staff Costs","index":22,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[6,0,6,7],[16,0,16,7]]}
["6th Previous IEP - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: 4th Previous IEP-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous page: 3rd Previous IEP-Other Staff Costs"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"('Start Here'!L91/180)*36","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from",{"$f":"'Start Here'!N91","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,"to",{"$f":"'Start Here'!P91","v":"mm/dd/yyyy"}]
["Special Education Certificated Staff (Special Education Teachers) (used to complete lines 1–3 on Worksheet C Summary)"]
["1. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B8)=TRUE,\" \",'Current IEP-Staff Costs'!B8)","v":" "},null,"2. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E8)=TRUE,\" \",'Current IEP-Staff Costs'!E8)","v":" "},null,"3. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H8)=TRUE,\" \",'Current IEP-Staff Costs'!H8)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B9)=TRUE,\" \",'Current IEP-Staff Costs'!B9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E9)=TRUE,\" \",'Current IEP-Staff Costs'!E9)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H9)=TRUE,\" \",'Current IEP-Staff Costs'!H9)","v":" "}]
["Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B10)=TRUE,\" \",'Current IEP-Staff Costs'!B10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E10)=TRUE,\" \",'Current IEP-Staff Costs'!E10)","v":" "},null,"Annual Caseload in Minutes for all students",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H10)=TRUE,\" \",'Current IEP-Staff Costs'!H10)","v":" "}]
["Cost per Minute",{"$f":"IFERROR(ROUND(B9/B10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(E9/E10,4),0)","v":0},null,"Cost per Minute",{"$f":"IFERROR(ROUND(H9/H10,4),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E14","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H14","v":1.3769}]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(B11*B12*B13*B14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(E11*E12*E13*E14)),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(H11*H12*H13*H14)),0)","v":0}]
[]
["Special Education Classified Staff (used to complete lines 4–9 on Worksheet C Summary)"]
["4. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B18)=TRUE,\" \",'Current IEP-Staff Costs'!B18)","v":" "},null,"5. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E18)=TRUE,\" \",'Current IEP-Staff Costs'!E18)","v":" "},null,"6. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H18)=TRUE,\" \",'Current IEP-Staff Costs'!H18)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B19)=TRUE,\" \",'Current IEP-Staff Costs'!B19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E19)=TRUE,\" \",'Current IEP-Staff Costs'!E19)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H19)=TRUE,\" \",'Current IEP-Staff Costs'!H19)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B20)=TRUE,\" \",'Current IEP-Staff Costs'!B20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E20)=TRUE,\" \",'Current IEP-Staff Costs'!E20)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H20)=TRUE,\" \",'Current IEP-Staff Costs'!H20)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E23","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H23","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B21=0,0,(((B20*B21*B22)/60)*B23)/B24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E21=0,0,(((E20*E21*E22)/60)*E23)/E24),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H21=0,0,(((H20*H21*H22)/60)*H23)/H24),0)","v":0}]
[]
["7. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B27)=TRUE,\" \",'Current IEP-Staff Costs'!B27)","v":" "},null,"8. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E27)=TRUE,\" \",'Current IEP-Staff Costs'!E27)","v":" "},null,"9. Name",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H27)=TRUE,\" \",'Current IEP-Staff Costs'!H27)","v":" "}]
["Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B28)=TRUE,\" \",'Current IEP-Staff Costs'!B28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E28)=TRUE,\" \",'Current IEP-Staff Costs'!E28)","v":" "},null,"Position",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H28)=TRUE,\" \",'Current IEP-Staff Costs'!H28)","v":" "}]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!B29)=TRUE,\" \",'Current IEP-Staff Costs'!B29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!E29)=TRUE,\" \",'Current IEP-Staff Costs'!E29)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Staff Costs'!H29)=TRUE,\" \",'Current IEP-Staff Costs'!H29)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Staff Costs'!B32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!E32","v":1.5933999999999999},null,"Benefit Rate",{"$f":"'Current IEP-Staff Costs'!H32","v":1.5933999999999999}]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B30=0,0,(((B29*B30*B31)/60)*B32)/B33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E30=0,0,(((E29*E30*E31)/60)*E32)/E33),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H30=0,0,(((H29*H30*H31)/60)*H32)/H33),0)","v":0}]

{"sheet":"6th Prev. IEP-Other Staff Costs","index":23,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[21,14,23,18],[19,0,19,13],[20,0,20,1],[20,3,20,4],[20,6,20,7],[20,9,20,10],[20,12,20,13],[0,0,0,13],[1,0,1,7],[7,0,7,13],[8,0,8,1],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13]]}
["6th Previous IEP - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Next Page: ESY-Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous Page: 6th Previous IEP-Staff Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Weeks per year",{"$f":"'6th Prev. IEP-Staff Costs'!H4","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'6th Prev. IEP-Staff Costs'!H5","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'6th Prev. IEP-Staff Costs'!H6","v":"mm/dd/yyyy"}]
["Related Services Required to implement the IEP"]
["In-District Staff (used to complete lines 14–18 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M9)=TRUE,\" \",'Current IEP-Other Staff Costs'!M9)","v":"Other, please select"}]
["14. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B10)=TRUE,\" \",'Current IEP-Other Staff Costs'!B10)","v":" "},null,"15. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E10)=TRUE,\" \",'Current IEP-Other Staff Costs'!E10)","v":" "},null,"16. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H10)=TRUE,\" \",'Current IEP-Other Staff Costs'!H10)","v":" "},null,"17. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K10)=TRUE,\" \",'Current IEP-Other Staff Costs'!K10)","v":" "},null,"18. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N10)=TRUE,\" \",'Current IEP-Other Staff Costs'!N10)","v":" "}]
["Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B11)=TRUE,\" \",'Current IEP-Other Staff Costs'!B11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E11)=TRUE,\" \",'Current IEP-Other Staff Costs'!E11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H11)=TRUE,\" \",'Current IEP-Other Staff Costs'!H11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K11)=TRUE,\" \",'Current IEP-Other Staff Costs'!K11)","v":" "},null,"Annual Special Education Base Salary",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N11)=TRUE,\" \",'Current IEP-Other Staff Costs'!N11)","v":" "}]
["Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B12)=TRUE,\" \",'Current IEP-Other Staff Costs'!B12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E12)=TRUE,\" \",'Current IEP-Other Staff Costs'!E12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H12)=TRUE,\" \",'Current IEP-Other Staff Costs'!H12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K12)=TRUE,\" \",'Current IEP-Other Staff Costs'!K12)","v":" "},null,"Contract Hours ",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N12)=TRUE,\" \",'Current IEP-Other Staff Costs'!N12)","v":" "}]
["Cost per hour",{"$f":"IFERROR(ROUND(B11/B12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(E11/E12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(H11/H12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(K11/K12,2),0)","v":0},null,"Cost per hour",{"$f":"IFERROR(ROUND(N11/N12,2),0)","v":0}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!B16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!E16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!H16","v":1.3769},null,"Benefit Rate",{"$f":"'Current IEP-Other Staff Costs'!K16","v":1.3769},null,"Benefit Rate",1.3769]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B14=0,0,((B13*(B14*B15/60))*B16/B17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E14=0,0,((E13*(E14*E15/60))*E16/E17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H14=0,0,((H13*(H14*H15/60))*H16/H17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K14=0,0,((K13*(K14*K15/60))*K16/K17)),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N14=0,0,((N13*(N14*N15/60))*N16/N17)),0)","v":0}]
[]
["Contracted Staff (used to complete lines 19–23 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!M21)=TRUE,\" \",'Current IEP-Other Staff Costs'!M21)","v":"Other, please select"}]
["19. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B22)=TRUE,\" \",'Current IEP-Other Staff Costs'!B22)","v":" "},null,"20. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E22)=TRUE,\" \",'Current IEP-Other Staff Costs'!E22)","v":" "},null,"21. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H22)=TRUE,\" \",'Current IEP-Other Staff Costs'!H22)","v":" "},null,"22. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K22)=TRUE,\" \",'Current IEP-Other Staff Costs'!K22)","v":" "},null,"23. Name",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N22)=TRUE,\" \",'Current IEP-Other Staff Costs'!N22)","v":" "},"Note: Do not include contracted 1:1 paraeducators, 1:1 interpreters, 1:1 nurses, or 1:1 behavior technicians here. Go to the Contracted 1 on 1 Billing tab to complete the costs for the student."]
["Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!B23)=TRUE,\" \",'Current IEP-Other Staff Costs'!B23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!E23)=TRUE,\" \",'Current IEP-Other Staff Costs'!E23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!H23)=TRUE,\" \",'Current IEP-Other Staff Costs'!H23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!K23)=TRUE,\" \",'Current IEP-Other Staff Costs'!K23)","v":" "},null,"Hourly Rate",{"$f":"IF(ISBLANK('Current IEP-Other Staff Costs'!N23)=TRUE,\" \",'Current IEP-Other Staff Costs'!N23)","v":" "}]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Annual Hours for this student",{"$f":"B24*B25/60","v":0},null,"Annual Hours for this student",{"$f":"E24*E25/60","v":0},null,"Annual Hours for this student",{"$f":"H24*H25/60","v":0},null,"Annual Hours for this student",{"$f":"K24*K25/60","v":0},null,"Annual Hours for this student",{"$f":"IF(N24=0,0,N24*N25/60)","v":0}]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B27=0,0,(B23*B26)/B27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E27=0,0,(E23*E26)/E27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H27=0,0,(H23*H26)/H27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K27=0,0,(K23*K26)/K27),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N27=0,0,(N23*N26)/N27),0)","v":0}]

{"sheet":"ESY-Staff Costs","index":24,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7],[6,0,6,7],[15,0,15,7]]}
["ESY - Staff Cost Worksheet",null,null,null,null,null,null,null,null,"Next page: ESY-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary.",null,null,null,null,null,null,null,null,"Previous page: 4th Previous IEP-Other Staff Costs"]
[null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,"Number of weeks",{"$f":"'Start Here'!L105","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,"Services from","mm/dd/yyyy"]
[null,null,null,null,null,null,"to","mm/dd/yyyy"]
["Special Education Certificated Staff (Special Education Teachers) (used to complete line 30 on Worksheet C Summary)"]
["Name",null,null,"Name",null,null,"Name"]
["Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",1.2287999999999999,null,"Benefit Rate",1.2287999999999999,null,"Benefit Rate",1.2287999999999999]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B10=0,0,(((B9*B10*B11)/60)*B12)/B13),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E10=0,0,(((E9*E10*E11)/60)*E12)/E13),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H10=0,0,(((H9*H10*H11)/60)*H12)/H13),0)","v":0}]
[]
["Special Education Classified Staff (used to complete line 26 on Worksheet C Summary)"]
["Name",null,null,"Name",null,null,"Name"]
["Position",null,null,"Position",null,null,"Position"]
["Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0},null,"Number of weeks staff member served student",{"$f":"$H$4","v":0}]
["Benefit Rate",1.2057,null,"Benefit Rate",1.2057,null,"Benefit Rate",1.2057]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B20=0,0,(((B19*B20*B21)/60)*B22)/B23),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E20=0,0,(((E19*E20*E21)/60)*E22)/E23),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H20=0,0,(((H19*H20*H21)/60)*H22)/H23),0)","v":0}]

{"sheet":"ESY-Other Staff Costs","index":25,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":true,"merged":[[0,0,0,13],[1,0,1,7],[7,0,7,13],[8,0,8,1],[8,3,8,4],[8,6,8,7],[8,9,8,10],[8,12,8,13],[17,0,17,13],[18,0,18,1],[18,3,18,4],[18,6,18,7],[18,9,18,10],[18,12,18,13]]}
["ESY - Other Staff Costs Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Previous page: ESY-Other Staff Costs"]
["Note: This worksheet is linked to the Worksheet C Summary."]
[null,null,null,null,null,null,null,null,null,null,null,null,"SSID Number",{"$f":"'Start Here'!$K$3","v":0}]
["Enter data in green cells.",null,null,null,null,null,null,null,null,null,null,null,"Number of weeks",{"$f":"'ESY-Staff Costs'!H4","v":0}]
["Cells in blue default to the number of weeks in cell H4, but may be overwritten if needed.",null,null,null,null,null,null,null,null,null,null,null,"Services from",{"$f":"'ESY-Staff Costs'!H5","v":"mm/dd/yyyy"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",{"$f":"'ESY-Staff Costs'!H6","v":"mm/dd/yyyy"}]
["Related Services Required to implement the IEP"]
["In-District Staff (used to complete line 30 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,"Other, please select"]
["Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name"]
["Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Benefit Rate",1.2287999999999999,null,"Benefit Rate",1.2287999999999999,null,"Benefit Rate",1.2287999999999999,null,"Benefit Rate",1.2287999999999999,null,"Benefit Rate",1.2287999999999999]
["Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time",null,null,"Number of Students served at the same time"]
["Total Cost for this student",{"$f":"ROUND(IF(B12=0,0,(((B11*B12*B13)/60)*B14)/B15),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(E12=0,0,(((E11*E12*E13)/60)*E14)/E15),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(H12=0,0,(((H11*H12*H13)/60)*H14)/H15),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(K12=0,0,(((K11*K12*K13)/60)*K14)/K15),0)","v":0},null,"Total Cost for this student",{"$f":"ROUND(IF(N12=0,0,(((N11*N12*N13)/60)*N14)/N15),0)","v":0}]
[]
["Contracted Staff (used to complete line 26 on Worksheet C Summary)"]
["SLP",null,null,"OT",null,null,"PT",null,null,"VI",null,null,"Other, please select"]
["Name",null,null,"Name",null,null,"Name",null,null,"Name",null,null,"Name"]
["Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate",null,null,"Hourly Rate"]
["MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP",null,null,"MPW of direct service provided to this student per IEP"]
["Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0},null,"Number of weeks staff member served student",{"$f":"$N$4","v":0}]
["Annual Hours for this student",{"$f":"B22*B23/60","v":0},null,"Annual Hours for this student",{"$f":"E22*E23/60","v":0},null,"Annual Hours for this student",{"$f":"H22*H23/60","v":0},null,"Annual Hours for this student",{"$f":"K22*K23/60","v":0},null,"Annual Hours for this student",{"$f":"N22*N23/60","v":0}]
["# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time",null,null,"# of students served at the same time"]
["Total IEP costs for this student",{"$f":"ROUND(IF(B25=0,0,(B21*B24)/B25),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(E25=0,0,(E21*E24)/E25),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(H25=0,0,(H21*H24)/H25),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(K25=0,0,(K21*K24)/K25),0)","v":0},null,"Total IEP costs for this student",{"$f":"ROUND(IF(N25=0,0,(N21*N24)/N25),0)","v":0}]