{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QA Annual Budget","Do not use"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"QA Annual Budget","index":0,"n_rows":120,"n_cols":10,"rows_kept":120,"cut":false,"hidden":false,"merged":[[61,0,61,9],[62,0,62,9],[30,0,37,0],[39,9,45,9],[30,9,37,9],[33,4,33,7],[37,1,37,3],[37,4,37,7],[45,1,45,3],[45,4,45,7],[47,0,52,0],[47,1,47,3],[47,4,47,7],[38,1,38,3],[38,4,38,7],[32,4,32,7],[33,1,33,3],[35,1,35,3],[35,4,35,7],[36,1,36,3],[36,4,36,7],[42,1,42,3],[42,4,42,7],[43,1,43,3],[43,4,43,7],[9,0,9,9],[11,0,18,0],[10,1,10,3],[10,4,10,7],[11,1,11,3],[11,4,11,7],[18,1,18,3],[18,4,18,7],[11,9,18,9],[15,1,15,3],[15,4,15,7],[16,1,16,3],[16,4,16,7],[14,1,14,3],[14,4,14,7],[12,1,12,3],[12,4,12,7],[20,0,28,0],[20,1,20,3],[20,4,20,7],[13,1,13,3],[13,4,13,7],[25,1,25,3],[17,1,17,3],[17,4,17,7],[24,1,24,3],[24,4,24,7],[19,1,19,3],[19,4,19,7],[0,0,0,9],[1,0,1,9],[2,1,2,2],[2,4,8,4],[2,9,4,9],[3,1,3,2],[4,1,4,2],[7,1,7,2],[7,8,7,9],[8,1,8,2],[8,5,8,9],[2,5,2,6],[7,5,7,6],[5,1,5,2],[5,8,5,9],[6,1,6,2],[6,8,6,9],[20,9,28,9],[30,1,30,3],[30,4,30,7],[40,1,40,3],[40,4,40,7],[41,1,41,3],[41,4,41,7],[31,1,31,3],[31,4,31,7],[32,1,32,3],[21,1,21,3],[21,4,21,7],[22,1,22,3],[22,4,22,7],[23,1,23,3],[23,4,23,7],[28,1,28,3],[28,4,28,7],[27,1,27,3],[27,4,27,7],[25,4,25,7],[26,1,26,3],[26,4,26,7],[54,9,60,9],[54,1,54,3],[54,4,54,7],[55,1,55,3],[55,4,55,7],[53,1,53,3],[53,4,53,7],[47,9,52,9],[48,1,48,3],[48,4,48,7],[52,1,52,3],[52,4,52,7],[56,1,56,3],[56,4,56,7],[50,1,50,3],[50,4,50,7],[63,0,63,9],[119,0,127,0],[101,0,108,0],[110,0,117,0],[78,0,88,0],[90,0,99,0],[66,0,76,0],[119,1,127,9],[66,1,76,9],[65,1,65,9],[77,1,77,9],[89,1,89,9],[100,1,100,9],[109,1,109,9],[118,1,118,9],[78,1,88,9],[90,1,99,9],[101,1,108,9],[110,1,117,9],[64,0,64,9],[29,1,29,3],[54,0,60,0],[51,1,51,3],[51,4,51,7],[44,1,44,3],[44,4,44,7],[57,1,57,3],[57,4,57,7],[58,1,58,3],[58,4,58,7],[59,1,59,3],[59,4,59,7],[60,1,60,3],[60,4,60,7],[39,0,45,0],[39,1,39,3],[39,4,39,7],[49,1,49,3],[49,4,49,7],[46,1,46,3],[46,4,46,7],[34,1,34,3],[34,4,34,7],[29,4,29,7]]}
["Part 1. Quality Assurance Annual Budget Planning"]
[]
["A.","Personnel costs",null,{"$f":"$J$12","v":0},null,"FOR STATE USE ONLY",null,"County: "]
["B.","Operating expenses",null,{"$f":"$J$21","v":0},null,"Estimated Total QA Allocations",0,"Fiscal Year:"]
["C.","Travel / Training",null,{"$f":"$J$31","v":0},null,"% utilization planned",{"$f":"IF($G$4=0,\"\",$D$9/$G$4)","v":""},"Date completed:"]
["D. ","Subcontracts",null,{"$f":"$J$40","v":0},null,"Actual Total QA Allocations",0,"Name of person completing QA Annual Budget Plan:"]
["E.","Equipment expenses",null,{"$f":"$J$48","v":0},null,"% utilization actual",{"$f":"IF($G$6=0,\"\",$D$9/$G$6)","v":""},"Title of person completing QA Annual Budget Plan:"]
["F.","Other expenses",null,{"$f":"J55","v":0},null,null,null,"Telephone number:"]
[null,"Total  Expenses",null,{"$f":"SUM(D3:D8)","v":0}]
[]
[null,"Item(s)",null,null,"FTE / Description / Duties",null,null,null,"Annual cost per item ($)","Total annual cost ($) A."]
["A. Personnel costs",null,null,null,null,null,null,null,null,{"$f":"SUM(I12:I19)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"PersonnelCosts"]
[null,"Item(s)",null,null,"Description",null,null,null,"Annual cost per item ($)","Total annual cost ($) B."]
["B. Operating expenses",null,null,null,null,null,null,null,null,{"$f":"SUM(I21:I29)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"OperatingCosts"]
[null,"Item(s)",null,null,"Description",null,null,null,"Annual cost per item ($)","Total annual cost ($) C."]
["C. Travel / Training",null,null,null,null,null,null,null,null,{"$f":"SUM(I31:I38)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"TravelCosts"]
[null,"Item(s)",null,null,"Description",null,null,null,"Annual cost per item ($)","Total annual cost ($) D."]
["D. Subcontracts",null,null,null,null,null,null,null,null,{"$f":"SUM(I40:I46)","v":0}]
[]
[]
[]
[]
[]
[null,"SubCosts"]
[null,"Item(s)",null,null,"Description",null,null,null,"Annual cost per item ($)","Total annual cost ($) E."]
["E. Equipment expenses",null,null,null,null,null,null,null,null,{"$f":"SUM(I48:I53)","v":0}]
[]
[]
[]
[]
[null,"EquipCosts"]
[null,"Item(s)",null,null,"Description",null,null,null,"Annual cost per item ($)","Total annual cost ($) F."]
["F. Other expenses",null,null,null,null,null,null,null,null,{"$f":"SUM(I55:I61)","v":0}]
[]
[]
[]
[]
[]
[null,"OtherCosts"]
[]
[]
["Part 2. Quality Assurance Annual Budget Justification"]
[]
[null,"Justification"]
["A. Personnel costs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Justification"]
["B. Operating expenses"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Justification"]
["C. Travel / Training"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Justification"]
["D. Subcontracts"]
[]
[]
[]
[]
[]
[]
[]
[null,"Justification"]
["E. Equipment expenses"]
[]
[]
[]
[]
[]
[]
[]
[null,"Justification"]
["F. Other expenses"]

{"sheet":"Do not use","index":1,"n_rows":58,"n_cols":2,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Alameda","FY 12/13"]
["Alpine","FY 13/14"]
["Amador","FY 14/15"]
["Butte","FY 15/16"]
["Calaveras","FY 16/17"]
["Colusa","FY 17/18"]
["Contra Costa","FY 18/19"]
["Del Norte","FY 19/20"]
["El Dorado"]
["Fresno"]
["Glenn"]
["Humboldt"]
["Imperial"]
["Inyo"]
["Kern"]
["Kings"]
["Lake"]
["Lassen"]
["Los Angeles"]
["Madera"]
["Marin"]
["Mariposa"]
["Mendocino"]
["Merced"]
["Modoc"]
["Mono"]
["Monterey"]
["Napa"]
["Nevada"]
["Orange"]
["Placer"]
["Plumas"]
["Riverside"]
["Sacramento"]
["San Benito"]
["San Bernardino"]
["San Diego"]
["San Francisco"]
["San Joaquin"]
["San Luis Obispo"]
["San Mateo"]
["Santa Barbara"]
["Santa Clara"]
["Santa Cruz"]
["Shasta"]
["Sierra"]
["Siskiyou"]
["Solano"]
["Sonoma"]
["Stanislaus"]
["Sutter"]
["Tehama"]
["Trinity"]
["Tulare"]
["Tuolumne"]
["Ventura"]
["Yolo"]
["Yuba"]