{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["2000002083","Budget Detail","Payroll Expenses & Projections","Account Analysis Report","GA Fees","Travel Enc Summary","Travel Detail","F&A","Notes","BARs & Mods","PQ for Graph"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"2000002083","index":0,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,2,0,4],[2,5,2,7],[4,9,4,10],[5,9,5,10],[2,8,2,10],[0,9,0,10],[1,9,1,10]]}
[null,"Title:","Multiphysics Characterization of Printed Smart Materials and Systems",null,null,"Start Date:","2021-07-01",null,"Projection as of:","2022-08-15"]
[null,"Award #",3742013,null,null,"End Date:","2022-06-30",null,"Updated by: ","Jason Papka"]
[null,"Fund",1850]
[null,"Dept",13000]
[null,"Cost Center",1001004,null,null,"OSP #",9937,null,"PI:","Dan Deng"]
[null,"Project",2000002083,null,null,{"$f":"IF(ISERROR(G5),\"◄ Manually Enter OSP #\",HYPERLINK(\"file:////\\\\fircreek1\\departments\\Vice President Research\\Sponsored Project Files\\\"&G5,\"Award Files\"))","v":"Award Files"},null,null,"Sponsor:","Idaho State Board of Education "]
[]
[]
[null,null,"Original","PPM","Life To Date",null,"Remaining","%",null,"Est Remaining","%"]
[null,null,"Budget","Budget","Expense","Encumbered","Budget","Remaining","Projected","Budget","Remaining"]
[null,"Reg Sal",null,{"$f":"'BARs & Mods'!N4","v":0},0,0,{"$f":"D11-(SUM(E11:F11))","v":0},{"$f":"IF(G11=0,\"-\",G11/D11)","v":"-"},{"$f":"SUMIF('Payroll Expenses & Projections'!G:G,\"Regular\",'Payroll Expenses & Projections'!J:J)","v":0},{"$f":"G11-(SUM(I11))","v":0},{"$f":"IF(J11=0,\"-\",J11/D11)","v":"-"}]
[null,"Irr Sal",null,{"$f":"'BARs & Mods'!N5","v":0},0,0,{"$f":"D12-(SUM(E12:F12))","v":0},{"$f":"IF(G12=0,\"-\",G12/D12)","v":"-"},{"$f":"SUMIF('Payroll Expenses & Projections'!G:G,\"Irregular\",'Payroll Expenses & Projections'!J:J)","v":0},{"$f":"G12-(SUM(I12))","v":0},{"$f":"IF(J12=0,\"-\",J12/D12)","v":"-"}]
[null,"Sum Sal",null,{"$f":"'BARs & Mods'!N6","v":0},0,0,{"$f":"D13-(SUM(E13:F13))","v":0},{"$f":"IF(G13=0,\"-\",G13/D13)","v":"-"},{"$f":"SUMIF('Payroll Expenses & Projections'!G:G,\"Summer\",'Payroll Expenses & Projections'!J:J)","v":0},{"$f":"G13-(SUM(I13))","v":0},{"$f":"IF(J13=0,\"-\",J13/D13)","v":"-"}]
[null,"Stu Sal",12206,{"$f":"'BARs & Mods'!N7","v":0},0,0,{"$f":"D14-(SUM(E14:F14))","v":0},{"$f":"IF(G14=0,\"-\",G14/D14)","v":"-"},{"$f":"SUMIF('Payroll Expenses & Projections'!G:G,\"Students\",'Payroll Expenses & Projections'!J:J)","v":0},{"$f":"G14-(SUM(I14))","v":0},{"$f":"IF(J14=0,\"-\",J14/D14)","v":"-"},null,"Rec'd approval to use budget allocated for payroll on capital"]
[null,"Fringe",2260,{"$f":"'BARs & Mods'!N8","v":0},0,0,{"$f":"D15-E15-F15","v":0},{"$f":"IF(G15=0,\"-\",G15/D15)","v":"-"},{"$f":"(SUMIF('Payroll Expenses & Projections'!G:G,\"Z-Fringe\",'Payroll Expenses & Projections'!J:J))+(SUMIF('Payroll Expenses & Projections'!G:G,\"HealthIns\",'Payroll Expenses & Projections'!J:J))","v":0},{"$f":"G15-I15","v":0},{"$f":"IF(J15=0,\"-\",J15/D15)","v":"-"},null,"4/23/22- Sent Sam copy of BAR and HERC budget adjustment approval. Smartsheet would not accept attachments. "]
[null,"OE",null,{"$f":"'BARs & Mods'!N9","v":0},11514.9,0,-11514.9,{"$f":"IF(G16=0,\"-\",G16/D16)","v":{"$error":"#DIV/0!"}},0,-11514.9,{"$error":"#DIV/0!"},null,"resubmitted BAR (# 3202) on 7/8/22 and sent copies of documents to Sam because form would not accept attachments"]
[null,"Travel",null,{"$f":"'BARs & Mods'!N10","v":0},0,0,0,"-",{"$f":"'Travel Enc Summary'!B20","v":0},0,"-"]
[null,"Capital",85534,{"$f":"'BARs & Mods'!N11","v":100000},0,85358.82,14641.179999999993,0.14641179999999993,null,14641.179999999993,0.14641179999999993]
[null,"Subcontracts",null,{"$f":"'BARs & Mods'!N12","v":0},0,0,0,"-",0,0,"-"]
[null,"Student Costs",null,{"$f":"'BARs & Mods'!N13","v":0},0,0,0,"-",{"$f":"'GA Fees'!E10","v":0},0,"-"]
[null,"Total Direct",{"$f":"SUM(C11:C20)","v":100000},{"$f":"SUM(D11:D20)","v":100000},{"$f":"SUM(E11:E20)","v":11514.9},{"$f":"SUM(F11:F20)","v":85358.82},{"$f":"SUM(G11:G20)","v":3126.2799999999934},null,{"$f":"SUM(I11:I20)","v":0},{"$f":"SUM(J11:J20)","v":3126.2799999999934},null,"F&A Type: ","N/A"]
[null,"F&A ",null,{"$f":"'BARs & Mods'!N15","v":0},0,{"$f":"IF(M21=\"MTDC\",SUM(E11:F17)*M22,IF(M21=\"TDC\",SUM(E11:F20)*M22,0))-E22","v":0},{"$f":"D22-E22-F22","v":0},{"$f":"IF(G22=0,\"-\",G22/D22)","v":"-"},{"$f":"IF(M21=\"MTDC\",SUM(I11:I17)*M22,IF(M21=\"TDC\",SUM(I11:I20)*M22,0))","v":0},{"$f":"G22-I22","v":0},{"$f":"IF(J22=0,\"-\",J22/D22)","v":"-"},"F&A Rate: ",0]
[]
[null,"Totals",{"$f":"SUM(C21:C22)","v":100000},{"$f":"SUM(D21:D22)","v":100000},{"$f":"SUM(E21:E22)","v":11514.9},{"$f":"SUM(F21:F22)","v":85358.82},{"$f":"SUM(G21:G22)","v":3126.2799999999934},{"$f":"IF(G24=0,\"-\",G24/D24)","v":3.1262799999999931E-2},{"$f":"SUM(I21:I22)","v":0},{"$f":"SUM(J21:J22)","v":3126.2799999999934},{"$f":"IF(J24=0,\"-\",J24/D24)","v":3.1262799999999931E-2}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Payroll Summary "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Employee Name","Total Salary Spent","Total Fringe Spent","Projected Salary","Projected Fringe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M29,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M30,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M31,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Total Budget",null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M32,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Monthly Expenses",null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M33,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M34,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M35,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M36,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M37,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M38,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M39,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M40,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M41,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M42,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M43,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M44,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M45,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M46,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M47,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M48,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!I:I,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Regular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Irregular\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Summer\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Students\")","v":0},{"$f":"SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"Z-Fringe\")+SUMIFS('Payroll Expenses & Projections'!J:J,'Payroll Expenses & Projections'!F:F,M49,'Payroll Expenses & Projections'!G:G,\"HealthIns\")","v":0}]

{"sheet":"Budget Detail","index":1,"n_rows":93,"n_cols":14,"rows_kept":93,"cut":false,"hidden":false,"merged":[[9,9,9,10],[23,0,23,2],[92,0,92,3],[93,0,103,3],[1,0,1,5],[2,0,2,5],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,3]]}
[]
["Boise State University "]
["DRAFT -- Internal Budget Estimate -- DRAFT"]
["Sponsor (originating and primary):","IGEM"]
["PI:  ","Dan Deng"]
["Department and College:  ","COEN"]
["OSP #:  ",9937,null,null,null,null,"Total Project"]
[null,null,null,"Date:  07/1/2021- 6/30/2022",null,null,"Costs"]
["Budget Categories","%","Mths","Year 1","Total","Cost Share","(Total + Cost Share)",null,null,null,null,null,"1% PI Salary","Fringe Benefits"]
[null,null,null,null,null,null,null,"Salary","Monthly","Contract",null,"Employee ID (PI, Co-PI)"]
["Salaries (with 3% increase per year for PI, Co-PI, Undergraduate Research Assistants, & Research Technician)"]
["PI Academic Year",1,0,0,0,0,0,0,0,9,"months",null,0,0]
["PI Summer ",1,0.1,0,0,null,0,0,0,9,"months"]
["PI Supplemental Pay:  generally not allowable; see note below * ",1,0,0,0,null,0,0,0,9,"months"]
["Co-PI Academic Year",1,0,0,0,null,0,0,0,9,"months"]
["Co-PI Summer ",1,0,0,0,null,0,0,0,9,"months"]
["Co-PI Supplemental Pay:  generally not allowable; see note below * ",1,0,0,0,null,0,0,0,9,"months"]
["Graduate Research Assistant Academic Year",1,6,12206,12206,null,12000,24000,2000,12]
["Graduate Research Assistant Summer",1,null,null,0,null,0,24000,2000,12]
[]
[null,1,null,null,0,null,0,0,0,9]
["Research Technician",1,12,0,0,null,0,0,0,12]
["Total Salaries",null,null,12206,12206,0,12206,null,null,null,null,6000]
["* Before budgeting Supplemental Pay, review BSU Policy 7195 regarding the rules and restrictions on including Supplemental Pay in a sponsored project.  Contact your Research Administrator with questions.  Click the following link to review policy:"]
["https://policy.boisestate.edu/human-resources/supplemental-pay/"]
[]
["Fringe Benefits",null,"%"]
["PI Academic Year",null,0,0,0,0,0]
["PI Summer ",null,0,0,0,null,0]
["PI Supplemental Pay",null,0,0,0,null,0]
["Co-PI Academic Year",null,0,0,0,null,0]
["Co-PI Summer ",null,0,0,0,null,0]
["Co-PI Supplemental Pay",null,0,0,0,null,0]
["Graduate Research Assistant Academic Year (estimate based on an average rate)",null,0.04,489,489,null,489]
["Graduate Research Assistant Summer (estimate based on an average rate)",null,0.1,null,0,null,0]
["Graduate Research Assistant: health insurance (estimated 5% increase per year)",null,"NA",1770.5,1770.5,null,1770.5,"Effective August 1, 2019: $3372"]
["Undergraduate Assistant (estimate based on an average rate)",null,0.1,null,0,null,0]
["Research Technician",null,0,0,0,null,0]
["Total Fringe Benefits",null,null,2259.5,2259.5,0,2259.5]
["* Click on the following link and search under \"General Information\" for current fringe benefit rates:  "]
["https://research.boisestate.edu/osp/proposal-preparation/"]
[]
["Other Expenses"]
["Materials and Supplies",null,null,0,0,null,0]
["Publication/Dissemination",null,null,0,0,null,0]
["Consultant Services",null,null,0,0,null,0]
["Recharge Center Services",null,null,0,0,null,0]
["Total Other Expenses",null,null,0,0,0,0]
[]
["Travel"]
["Domestic Travel",null,null,0,0,null,0]
["Foreign Travel ",null,null,0,0,null,0]
["Total Travel",null,null,0,0,0,0]
[]
["Student Costs ",null,null,null,null,null,null,"Effective August 2019: $4823/Semester, $9646/Academic Yr., $470/Credit"]
["Graduate Student Fee Remission, PhD student (typically includes academic year and six summer credits)",null,null,0,0,null,0]
["Graduate Student Fee Remission, Masters student, Academic Year",null,null,0,0,null,0]
["Total Student Costs",null,null,0,0,0,0]
["* Click on the following link and search under \"General Information\" for current tuition and fee rates:  "]
["https://research.boisestate.edu/osp/proposal-preparation/"]
[]
["Subawards (F&A on first $25K)"]
["Subaward portion up to $25K"]
["University X",null,null,0,0,null,0]
["University Y",null,null,0,0,null,0]
[null,null,null,null,null,null,0]
["Subtotal under $25K",null,null,0,0,0,0]
[]
["Subaward portion over $25K"]
["University X",null,null,0,0,null,0]
["University Y",null,null,0,0,null,0]
[null,null,null,null,null,null,0]
["Subtotal over $25K",null,null,0,0,0,0]
["Total Subawards",null,null,0,0,0,0]
[]
["Equipment over 5K"]
["MTS Test System",null,null,85534,85534,null,85534]
[null,null,null,0,0,null,0]
["Total Capital",null,null,85534,85534,0,85534]
[]
[]
["Total Direct Costs",null,null,99999.5,99999.5,0,99999.5]
[]
["Base for Indirect Calculation",null,null,14465.5,14465.5,0,14465.5]
[]
["Facilities and Administrative Costs (F&A, Indirect Costs) MTDC *",null,0,0,0,0,0]
[]
["Total Costs",null,null,99999.5,99999.5,0,99999.5]
[]
["* Click the following link for more information on F&A: "]
["https://research.boisestate.edu/osp/proposal-preparation/facilities-and-administrative-costs/"]
[]
["Proposal Budget Notes:  "]

{"sheet":"Payroll Expenses & Projections","index":2,"n_rows":25,"n_cols":299,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,2,24,3]]}
["Project End Date: ",{"$f":"'2000002083'!G2","v":"2022-06-30"}]
["Notes","EAF/GFDF #","EAF/GFDF Start","EAF/GFDF End","Employee ID","Employee Name","GROUP","Total","Actual to Date","Projection","2021-06-26",{"$f":"K2+14","v":"2021-07-10"},{"$f":"L2+14","v":"2021-07-24"},"2021-08-07","2021-08-21","2021-09-04","2021-09-18","2021-10-02","2021-10-16","2021-10-30","2021-11-13","2021-11-27","2021-12-11","2021-12-25","2022-01-08","2022-01-22","2022-02-05","2022-02-19","2022-03-05","2022-03-19","2022-04-02","2022-04-16","2022-04-30","2022-05-14","2022-05-28","2022-06-11","2022-06-25","2022-07-09","2022-07-23","2022-08-06","2022-08-20","2022-09-03","2022-09-17","2022-10-01","2022-10-15","2022-10-29","2022-11-12","2022-11-26","2022-12-10","2022-12-24","2023-01-07","2023-01-21","2023-02-04","2023-02-18","2023-03-04","2023-03-18","2023-04-01","2023-04-15","2023-04-29","2023-05-13","2023-05-27","2023-06-10","2023-06-24","2023-07-08","2023-07-22","2023-08-05","2023-08-19","2023-09-02","2023-09-16","2023-09-30","2023-10-14","2023-10-28","2023-11-11","2023-11-25","2023-12-09","2023-12-23",{"$f":"BX2+14","v":"2024-01-06"},"2024-01-20","2024-02-03","2024-02-17","2024-03-02","2024-03-16","2024-03-30","2024-04-13","2024-04-27","2024-05-11","2024-05-25","2024-06-08","2024-06-22","2024-07-06","2024-07-20","2024-08-03","2024-08-17","2024-08-31","2024-09-14","2024-09-28","2024-10-12","2024-10-26","2024-11-09","2024-11-23","2024-12-07","2024-12-21","2025-01-04","2025-01-18","2025-02-01","2025-02-15","2025-03-01","2025-03-15","2025-03-29","2025-04-12","2025-04-26","2025-05-10","2025-05-24","2025-06-07","2025-06-21","2025-07-05","2025-07-19","2025-08-02","2025-08-16","2025-08-30","2025-09-13","2025-09-27","2025-10-11","2025-10-25","2025-11-08","2025-11-22","2025-12-06","2025-12-20","2026-01-03","2026-01-17","2026-01-31","2026-02-14","2026-02-28","2026-03-14","2026-03-28","2026-04-11","2026-04-25","2026-05-09","2026-05-23","2026-06-06",{"$f":"EJ2+14","v":"2026-06-20"},"2026-07-04","2026-07-18","2026-08-01","2026-08-15","2026-08-29","2026-09-12","2026-09-26","2026-10-10","2026-10-24","2026-11-07","2026-11-21","2026-12-05","2026-12-19","2027-01-02","2027-01-16","2027-01-30","2027-02-13","2027-02-27","2027-03-13","2027-03-27","2027-04-10","2027-04-24","2027-05-08","2027-05-22","2027-06-05","2027-06-19","2027-07-03","2027-07-17","2027-07-31","2027-08-14","2027-08-28","2027-09-11","2027-09-25","2027-10-09","2027-10-23","2027-11-06","2027-11-20","2027-12-04","2027-12-18","2028-01-01","2028-01-15","2028-01-29","2028-02-12","2028-02-26","2028-03-11","2028-03-25","2028-04-08","2028-04-22","2028-05-06","2028-05-20","2028-06-03","2028-06-17","2028-07-01","2028-07-15","2028-07-29","2028-08-12","2028-08-26","2028-09-09","2028-09-23","2028-10-07","2028-10-21","2028-11-04","2028-11-18",{"$f":"GV2+14","v":"2028-12-02"},"2028-12-16","2028-12-30","2029-01-13","2029-01-27","2029-02-10","2029-02-24","2029-03-10","2029-03-24","2029-04-07","2029-04-21","2029-05-05","2029-05-19","2029-06-02","2029-06-16","2029-06-30","2029-07-14","2029-07-28","2029-08-11","2029-08-25","2029-09-08","2029-09-22","2029-10-06","2029-10-20","2029-11-03","2029-11-17","2029-12-01","2029-12-15","2029-12-29","2030-01-12","2030-01-26","2030-02-09","2030-02-23","2030-03-09","2030-03-23","2030-04-06","2030-04-20","2030-05-04","2030-05-18","2030-06-01","2030-06-15","2030-06-29","2030-07-13","2030-07-27","2030-08-10","2030-08-24","2030-09-07","2030-09-21","2030-10-05","2030-10-19","2030-11-02","2030-11-16","2030-11-30","2030-12-14","2030-12-28","2031-01-11","2031-01-25","2031-02-08","2031-02-22","2031-03-08","2031-03-22","2031-04-05","2031-04-19","2031-05-03",{"$f":"JH2+14","v":"2031-05-17"},"2031-05-31","2031-06-14","2031-06-28","2031-07-12","2031-07-26","2031-08-09","2031-08-23","2031-09-06","2031-09-20","2031-10-04","2031-10-18","2031-11-01","2031-11-15","2031-11-29","2031-12-13","2031-12-27","2032-01-10","2032-01-24","2032-02-07","2032-02-21","2032-03-06","2032-03-20","2032-04-03","2032-04-17","2032-05-01","2032-05-15","2032-05-29","2032-06-12","2032-06-26","2032-07-10"]
["20hrs/wk @ $12/hr at 80%","NSH","2022-01-01","2022-06-30",114084084,"Draper, Alejandro","Students",{"$f":"SUM(K3:XFD3)","v":0},{"$f":"H3-J3","v":0},{"$f":"SUM(L3:XFD3)","v":0},null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,114084084,"Draper, Alejandro","Z-Fringe",0,{"$f":"H4-J4","v":0},{"$f":"SUM(L4:XFD4)","v":0},null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(K11:XFD11)","v":0},{"$f":"H11-J11","v":0},0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,"Totals",{"$f":"SUM(H3:H12)","v":0},{"$f":"ROUND(SUM(I3:I12),2)","v":0},{"$f":"SUM(J3:J12)","v":0}]
[]
[]
[]
[]
["Committed Effort "]
[null,"AY/Summer"]
["Name - Months of Commited Effort","Year",null,null,"Total Taken"]
["1 month salary "]
["Taken "]
[null,{"$f":"IF(B22=0,\"-\",B22/B21)","v":"-"},{"$f":"IF(C22=0,\"-\",C22/C21)","v":"-"},"-",{"$f":"SUM(B23:D23)","v":0}]
[null,null,null,null,"months committed "]
[null,null,"% committed effort taken ",null,{"$f":"IF(E23=0,\"-\",E23/E24)","v":"-"}]

{"sheet":"Account Analysis Report","index":3,"n_rows":14,"n_cols":34,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,0,2,32],[3,0,3,32],[4,0,4,32],[5,0,5,32]]}
[]
[]
["BSU Account Analysis Report"]
["From Period: 1-10"]
["To Period: 12-23"]
["Report Date:  8/15/22 2:43 PM"]
["FISCAL_YEAR","PERIOD","PERIOD_NAME","BALANCE_TYPE","ENCUMBRANCE_TYPE","FUND","FUND_DESC","DEPARTMENT","COST_CENTER","COST_CENTER_DESC","NATURAL_ACCOUNT","NATURAL_ACCOUNT_DESC","SUPPLEMENTAL","INTERFUND","PROJECT","FUTURE1","NET_AMOUNT","ACCTNG_DATE","TRANSACTION_NUMBER","APPLICATION_NAME","JE_SOURCE_NAME","JE_CATEGORY_NAME","GL_BATCH_NAME","GL_BATCH_DESC","GL_JE_NAME","SUBLEDGER_JE_DESC","GL_JE_DESC","GL_LINE_DESC","GL_LINE_NUMBER","SUBLEDGER_JE_LINE_DESC","PARTY_NAME","ADDITIONAL_INFO","ACCOUNTING_CODE_COMBINATION","CODE_COMBINATION_DESC"]
[" 2022","11","‭11-22‬","Actual",null,1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",574100,"Medical & Laboratory Supp",0,0,2000002083,0,7462.25,"2022-05-23","‭Pcard 05-2022~COEN MECH AND BIOMED~3630‬","Payables","Payables","Purchase Invoices","Payables A 4278164000001 4278178 Y",null,"23-05-2022 Purchase Invoices","Invoice Description : ASHLEY HOLDEN~0772 , Supplier : Bank of America NA , Supplier Site : 1_Purchasing , Invoice Type : Standard",null,null,"3269","MECHANICAL TECHNOLOGY IN~Sensor for material characterization - Deng Multiphysics~~TXN00672800 MECHANICAL TECHNOLOGY IN~Sensor for material characterization - Deng Multiphysics~~TXN00672800","Bank of America NA",null,"‭1850.13000.1001004.574100.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Supp.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[" 2022","11","‭11-22‬","Actual",null,1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",574100,"Medical & Laboratory Supp",0,0,2000002083,0,4052.65,"2022-05-23","‭Pcard 05-2022~COEN MECH AND BIOMED~3629‬","Payables","Payables","Purchase Invoices","Payables A 4278164000001 4278178 Y",null,"23-05-2022 Purchase Invoices","Invoice Description : ASHLEY HOLDEN~0772 , Supplier : Bank of America NA , Supplier Site : 1_Purchasing , Invoice Type : Standard",null,null,"3268","MECHANICAL TECHNOLOGY IN~Sensor for material characterization - Deng Multiphysics~~TXN00672737 MECHANICAL TECHNOLOGY IN~Sensor for material characterization - Deng Multiphysics~~TXN00672737","Bank of America NA",null,"‭1850.13000.1001004.574100.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Supp.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[" 2022","1","‭1-22‬","Encumbrance","Commitment",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,85534,"2021-07-01","‭REQ162439‬","Purchasing","Purchasing","Requisition","Purchasing E 2799074000001 2799081 Y",null,"01-07-2021 Requisition300000000114940",null,null,null,"11",null,null,null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[" 2022","1","‭1-22‬","Encumbrance","Commitment",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,-85534,"2021-07-01","‭PO138767‬","Purchasing","Purchasing","Purchase Order","Purchasing E 2799074000001 2799081 Y",null,"01-07-2021 Purchase Order300000000114940",null,null,null,"9",null,"MTS Systems Corporation",null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[" 2022","1","‭1-22‬","Encumbrance","Obligation",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,85358.82,"2021-07-01","‭PO138767‬","Purchasing","Purchasing","Purchase Order","Purchasing E 2799074000001 2799081 Y",null,"01-07-2021 Purchase Order300000000114941",null,null,null,"10",null,"MTS Systems Corporation",null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[" 2022","12","‭12-22‬","Encumbrance","Obligation",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,-85358.82,"2022-06-30","‭‬",null,"Spreadsheet","Encumbrance CFWD","Spreadsheet E 300000007661282 4451599 N",null,"PO138767 -FY22 Encumbrance - Close Out Encumbrance CFWD300000000114941","Journal Import 4451599:",null,null,"1","Journal Import Created",null,null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[" 2023","1","‭1-23‬","Encumbrance","Obligation",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,85358.82,"2022-07-01","‭‬",null,"Spreadsheet","Encumbrance CFWD","Spreadsheet E 300000007661282 4451655 N",null,"PO138767 -FY23 Encumbrance - Carry Forward Encumbrance CFWD300000000114941","Journal Import 4451655:",null,null,"1","Journal Import Created",null,null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]

{"sheet":"GA Fees","index":4,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Fall ","Spring ","Fall ","Spring ","Fall ","Spring ","Fall","Spring ","Fall ","Spring "]
[null,"Student Name","Notes"]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Projected",{"$f":"SUM(D3:D9)+SUM(E3:E9)+SUM(F3:F9)+SUM(G3:G9)+SUM(H3:H9)+SUM(I3:I9)+SUM(J3:J9)+SUM(K3:K9)+SUM(L3:L9)+SUM(M3:M9)","v":0}]
[null,null,null,"Actual ",{"$f":"SUM(D3:XFD9)-E10","v":0}]

{"sheet":"Travel Enc Summary","index":5,"n_rows":20,"n_cols":39,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,1,0,3],[0,6,0,8],[0,11,0,13],[0,16,0,18],[1,1,1,3],[1,6,1,8],[1,11,1,13],[1,16,1,18],[2,1,2,3],[2,6,2,8],[2,11,2,13],[2,16,2,18],[3,1,3,3],[3,6,3,8],[3,11,3,13],[3,16,3,18],[4,1,4,3],[4,6,4,8],[4,11,4,13],[4,16,4,18],[14,1,14,3],[14,6,14,8],[14,11,14,13],[14,16,14,18],[0,21,0,23],[0,26,0,28],[0,31,0,33],[0,36,0,38],[1,21,1,23],[1,26,1,28],[1,31,1,33],[1,36,1,38],[2,21,2,23],[2,26,2,28],[2,31,2,33],[2,36,2,38],[3,21,3,23],[3,26,3,28],[3,31,3,33],[3,36,3,38],[4,21,4,23],[4,26,4,28],[4,31,4,33],[4,36,4,38],[14,21,14,23],[14,26,14,28],[14,31,14,33],[14,36,14,38]]}
["Traveler",null,null,null,null,"Traveler",null,null,null,null,"Traveler",null,null,null,null,"Traveler",null,null,null,null,"Traveler",null,null,null,null,"Traveler",null,null,null,null,"Traveler",null,null,null,null,"Traveler"]
["TA #",null,null,null,null,"TA #",null,null,null,null,"TA #",null,null,null,null,"TA #",null,null,null,null,"TA #",null,null,null,null,"TA #",null,null,null,null,"TA #",null,null,null,null,"TA #"]
["Location: ",null,null,null,null,"Location: ",null,null,null,null,"Location: ",null,null,null,null,"Location: ",null,null,null,null,"Location: ",null,null,null,null,"Location: ",null,null,null,null,"Location: ",null,null,null,null,"Location: "]
["Purpose:",null,null,null,null,"Purpose:",null,null,null,null,"Purpose:",null,null,null,null,"Purpose:",null,null,null,null,"Purpose:",null,null,null,null,"Purpose:",null,null,null,null,"Purpose:",null,null,null,null,"Purpose:"]
["Travel Dates:",null,null,null,null,"Travel Dates:",null,null,null,null,"Travel Dates:",null,null,null,null,"Travel Dates:",null,null,null,null,"Travel Dates:",null,null,null,null,"Travel Dates:",null,null,null,null,"Travel Dates:",null,null,null,null,"Travel Dates:"]
[null,"Prepaid","Reimbursment ","Posted",null,null,"Prepaid","Reimbursment ","Posted",null,null,"Prepaid","Reimbursment ","Posted",null,null,"Prepaid","Reimbursment ","Posted",null,null,"Prepaid","Reimbursment ","Posted",null,null,"Prepaid","Reimbursment ","Posted",null,null,"Prepaid","Reimbursment ","Posted",null,null,"Prepaid","Reimbursment ","Posted"]
["Registration",0,0,0,null,"Registration",0,0,0,null,"Registration",0,0,0,null,"Registration",0,0,0,null,"Registration",0,0,0,null,"Registration",0,0,0,null,"Registration",0,0,0,null,"Registration",0,0,0]
["Lodging",0,0,0,null,"Lodging",0,0,0,null,"Lodging",0,0,0,null,"Lodging",0,0,0,null,"Lodging",0,0,0,null,"Lodging",0,0,0,null,"Lodging",0,0,0,null,"Lodging",0,0,0]
["Airfare",0,0,0,null,"Airfare",0,0,0,null,"Airfare",0,0,0,null,"Airfare",0,0,0,null,"Airfare",0,0,0,null,"Airfare",0,0,0,null,"Airfare",0,0,0,null,"Airfare",0,0,0]
["Per Diem ",0,0,0,null,"Per Diem ",0,0,0,null,"Per Diem ",0,0,0,null,"Per Diem ",0,0,0,null,"Per Diem ",0,0,0,null,"Per Diem ",0,0,0,null,"Per Diem ",0,0,0,null,"Per Diem ",0,0,0]
["Transportation",0,0,0,null,"Transportation",0,0,0,null,"Transportation",0,0,0,null,"Transportation",0,0,0,null,"Transportation",0,0,0,null,"Transportation",0,0,0,null,"Transportation",0,0,0,null,"Transportation",0,0,0]
["Misc. ",0,0,0,null,"Misc. ",0,0,0,null,"Misc. ",0,0,0,null,"Misc. ",0,0,0,null,"Misc. ",0,0,0,null,"Misc. ",0,0,0,null,"Misc. ",0,0,0,null,"Misc. ",0,0,0]
[null,{"$f":"SUM(B7:B12)","v":0},{"$f":"SUM(C7:C12)","v":0},{"$f":"SUM(D7:D12)","v":0},null,null,{"$f":"SUM(G7:G12)","v":0},{"$f":"SUM(H7:H12)","v":0},{"$f":"SUM(I7:I12)","v":0},null,null,{"$f":"SUM(L7:L12)","v":0},{"$f":"SUM(M7:M12)","v":0},{"$f":"SUM(N7:N12)","v":0},null,null,{"$f":"SUM(Q7:Q12)","v":0},{"$f":"SUM(R7:R12)","v":0},{"$f":"SUM(S7:S12)","v":0},null,null,{"$f":"SUM(V7:V12)","v":0},{"$f":"SUM(W7:W12)","v":0},{"$f":"SUM(X7:X12)","v":0},null,null,{"$f":"SUM(AA7:AA12)","v":0},{"$f":"SUM(AB7:AB12)","v":0},{"$f":"SUM(AC7:AC12)","v":0},null,null,{"$f":"SUM(AF7:AF12)","v":0},{"$f":"SUM(AG7:AG12)","v":0},{"$f":"SUM(AH7:AH12)","v":0},null,null,{"$f":"SUM(AK7:AK12)","v":0},{"$f":"SUM(AL7:AL12)","v":0},{"$f":"SUM(AM7:AM12)","v":0}]
[]
["ER Submitted:",null,null,null,null,"ER Submitted:",null,null,null,null,"ER Submitted:",null,null,null,null,"ER Submitted:",null,null,null,null,"ER Submitted:",null,null,null,null,"ER Submitted:",null,null,null,null,"ER Submitted:",null,null,null,null,"ER Submitted:"]
[]
[]
[]
[]
["Projected: ",{"$f":"B13-D13+G13-I13+L13-N13+Q13-S13+V13-X13+AA13-AC13+AF13-AH13+AK13-AM13","v":0}]

{"sheet":"Travel Detail","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"F&A","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Notes","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"BARs & Mods","index":9,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Original","Pending"]
[null,"Budget","BAR 4/23/22",null,null,null,null,null,null,null,null,null,null,"Total "]
["Reg Sal",{"$f":"'2000002083'!C11","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:M4)","v":0}]
["Irr Sal",{"$f":"'2000002083'!C12","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B5:M5)","v":0}]
["Sum Sal",{"$f":"'2000002083'!C13","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
["Stu Sal",{"$f":"'2000002083'!C14","v":12206},-12206,null,null,null,null,null,null,null,null,null,null,0]
["Fringe",{"$f":"'2000002083'!C15","v":2260},-2260,null,null,null,null,null,null,null,null,null,null,0]
["OE",{"$f":"'2000002083'!C16","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
["Travel",{"$f":"'2000002083'!C17","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
["Capital",{"$f":"'2000002083'!C18","v":85534},14466,null,null,null,null,null,null,null,null,null,null,100000]
["Subcontracts",{"$f":"'2000002083'!C19","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
["Student Costs",{"$f":"'2000002083'!C20","v":0},null,null,null,null,null,null,null,null,null,null,null,0]
["Total Direct",{"$f":"SUM(B4:B13)","v":100000},{"$f":"SUM(C4:C13)","v":0},0,0,{"$f":"SUM(F4:F13)","v":0},0,0,0,0,0,0,0,100000]
["F&A ",{"$f":"'2000002083'!C22","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15:M15)","v":0}]
[]
["Totals",{"$f":"SUM(B14:B15)","v":100000},{"$f":"SUM(C14:C15)","v":0},{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},{"$f":"SUM(F14:F15)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(N14:N15)","v":100000}]
[]
[null,"If the budget or end date of the project has changed, the PQ for Graph budget will need to be updated"]

{"sheet":"PQ for Graph","index":10,"n_rows":829,"n_cols":38,"rows_kept":829,"cut":false,"hidden":false,"merged":[]}
["PERIOD_NAME","Total Spent","Budget","12","FISCAL_YEAR","PERIOD","PERIOD_NAME","BALANCE_TYPE","ENCUMBRANCE_TYPE","FUND","FUND_DESC","DEPARTMENT","COST_CENTER","COST_CENTER_DESC","NATURAL_ACCOUNT","NATURAL_ACCOUNT_DESC","SUPPLEMENTAL","INTERFUND","PROJECT","FUTURE1","NET_AMOUNT","ACCTNG_DATE","TRANSACTION_NUMBER","APPLICATION_NAME","JE_SOURCE_NAME","JE_CATEGORY_NAME","GL_BATCH_NAME","GL_BATCH_DESC","GL_JE_NAME","SUBLEDGER_JE_DESC","GL_JE_DESC","GL_LINE_DESC","GL_LINE_NUMBER","SUBLEDGER_JE_LINE_DESC","PARTY_NAME","ADDITIONAL_INFO","ACCOUNTING_CODE_COMBINATION","CODE_COMBINATION_DESC"]
[null,{"$f":"SUMIF(G:G,A2,U:U)","v":0},{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)","v":8333.3333333333339},"1-22",2022,1,"‭1-22‬","Encumbrance","Obligation",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,85358.82,"2021-07-01","‭PO138767‬","Purchasing","Purchasing","Purchase Order","Purchasing E 2799074000001 2799081 Y",null,"01-07-2021 Purchase Order300000000114941",null,null,null,10,null,"MTS Systems Corporation",null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C2","v":16666.666666666668},"2-22",2022,1,"‭1-22‬","Encumbrance","Commitment",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,-85534,44378,"‭PO138767‬","Purchasing","Purchasing","Purchase Order","Purchasing E 2799074000001 2799081 Y",null,"01-07-2021 Purchase Order300000000114940",null,null,null,9,null,"MTS Systems Corporation",null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C3","v":25000},"3-22",2022,1,"‭1-22‬","Encumbrance","Commitment",1850,"HERC Appropriated",13000,1001004,"Projects-04-Research",685000,"Medical & Laboratory Equi",0,0,2000002083,0,85534,44378,"‭REQ162439‬","Purchasing","Purchasing","Requisition","Purchasing E 2799074000001 2799081 Y",null,"01-07-2021 Requisition300000000114940",null,null,null,11,null,null,null,"‭1850.13000.1001004.685000.0000000000.0000.2000002083.0000000000‬","HERC Appropriated.Mechanical & Biomedical E.Projects-04-Research.Medical & Laboratory Equi.Supplemental Default.Default Fund.Multiphysics Characteriza.Default Future 1 Finance "]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C4","v":33333.333333333336},"4-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C5","v":41666.666666666672},"5-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C6","v":50000.000000000007},"6-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C7","v":58333.333333333343},"7-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C8","v":66666.666666666672},"8-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C9","v":75000},"9-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C10","v":83333.333333333328},"10-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C11","v":91666.666666666657},"11-22"]
[null,null,{"$f":"('2000002083'!$D$21/'PQ for Graph'!$D$1)+C12","v":99999.999999999985},"12-22"]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[null,null,null,32]
[null,null,null,33]
[null,null,null,34]
[null,null,null,35]
[null,null,null,36]
[null,null,null,37]
[null,null,null,38]
[null,null,null,39]
[null,null,null,40]
[null,null,null,41]
[null,null,null,42]
[null,null,null,43]
[null,null,null,44]
[null,null,null,45]
[null,null,null,46]
[null,null,null,47]
[null,null,null,48]
[null,null,null,49]
[null,null,null,50]
[null,null,null,51]
[null,null,null,52]
[null,null,null,53]
[null,null,null,54]
[null,null,null,55]
[null,null,null,56]
[null,null,null,57]
[null,null,null,58]
[null,null,null,59]
[null,null,null,60]
[null,null,null,61]
[null,null,null,62]
[null,null,null,63]
[null,null,null,64]
[null,null,null,65]
[null,null,null,66]
[null,null,null,67]
[null,null,null,68]
[null,null,null,69]
[null,null,null,70]
[null,null,null,71]
[null,null,null,72]
[null,null,null,73]
[null,null,null,74]
[null,null,null,75]
[null,null,null,76]
[null,null,null,77]
[null,null,null,78]
[null,null,null,79]
[null,null,null,80]
[null,null,null,81]
[null,null,null,82]
[null,null,null,83]
[null,null,null,84]
[null,null,null,85]
[null,null,null,86]
[null,null,null,87]
[null,null,null,88]
[null,null,null,89]
[null,null,null,90]
[null,null,null,91]
[null,null,null,92]
[null,null,null,93]
[null,null,null,94]
[null,null,null,95]
[null,null,null,96]
[null,null,null,97]
[null,null,null,98]
[null,null,null,99]
[null,null,null,100]
[null,null,null,101]
[null,null,null,102]
[null,null,null,103]
[null,null,null,104]
[null,null,null,105]
[null,null,null,106]
[null,null,null,107]
[null,null,null,108]
[null,null,null,109]
[null,null,null,110]
[null,null,null,111]
[null,null,null,112]
[null,null,null,113]
[null,null,null,114]
[null,null,null,115]
[null,null,null,116]
[null,null,null,117]
[null,null,null,118]
[null,null,null,119]
[null,null,null,120]
[null,null,null,121]
[null,null,null,122]
[null,null,null,123]
[null,null,null,124]
[null,null,null,125]
[null,null,null,126]
[null,null,null,127]
[null,null,null,128]
[null,null,null,129]
[null,null,null,130]
[null,null,null,131]
[null,null,null,132]
[null,null,null,133]
[null,null,null,134]
[null,null,null,135]
[null,null,null,136]
[null,null,null,137]
[null,null,null,138]
[null,null,null,139]
[null,null,null,140]
[null,null,null,141]
[null,null,null,142]
[null,null,null,143]
[null,null,null,144]
[null,null,null,145]
[null,null,null,146]
[null,null,null,147]
[null,null,null,148]
[null,null,null,149]
[null,null,null,150]
[null,null,null,151]
[null,null,null,152]
[null,null,null,153]
[null,null,null,154]
[null,null,null,155]
[null,null,null,156]
[null,null,null,157]
[null,null,null,158]
[null,null,null,159]
[null,null,null,160]
[null,null,null,161]
[null,null,null,162]
[null,null,null,163]
[null,null,null,164]
[null,null,null,165]
[null,null,null,166]
[null,null,null,167]
[null,null,null,168]
[null,null,null,169]
[null,null,null,170]
[null,null,null,171]
[null,null,null,172]
[null,null,null,173]
[null,null,null,174]
[null,null,null,175]
[null,null,null,176]
[null,null,null,177]
[null,null,null,178]
[null,null,null,179]
[null,null,null,180]
[null,null,null,181]
[null,null,null,182]
[null,null,null,183]
[null,null,null,184]
[null,null,null,185]
[null,null,null,186]
[null,null,null,187]
[null,null,null,188]
[null,null,null,189]
[null,null,null,190]
[null,null,null,191]
[null,null,null,192]
[null,null,null,193]
[null,null,null,194]
[null,null,null,195]
[null,null,null,196]
[null,null,null,197]
[null,null,null,198]
[null,null,null,199]
[null,null,null,200]
[null,null,null,201]
[null,null,null,202]
[null,null,null,203]
[null,null,null,204]
[null,null,null,205]
[null,null,null,206]
[null,null,null,207]
[null,null,null,208]
[null,null,null,209]
[null,null,null,210]
[null,null,null,211]
[null,null,null,212]
[null,null,null,213]
[null,null,null,214]
[null,null,null,215]
[null,null,null,216]
[null,null,null,217]
[null,null,null,218]
[null,null,null,219]
[null,null,null,220]
[null,null,null,221]
[null,null,null,222]
[null,null,null,223]
[null,null,null,224]
[null,null,null,225]
[null,null,null,226]
[null,null,null,227]
[null,null,null,228]
[null,null,null,229]
[null,null,null,230]
[null,null,null,231]
[null,null,null,232]
[null,null,null,233]
[null,null,null,234]
[null,null,null,235]
[null,null,null,236]
[null,null,null,237]
[null,null,null,238]
[null,null,null,239]
[null,null,null,240]
[null,null,null,241]
[null,null,null,242]
[null,null,null,243]
[null,null,null,244]
[null,null,null,245]
[null,null,null,246]
[null,null,null,247]
[null,null,null,248]
[null,null,null,249]
[null,null,null,250]
[null,null,null,251]
[null,null,null,252]
[null,null,null,253]
[null,null,null,254]
[null,null,null,255]
[null,null,null,256]
[null,null,null,257]
[null,null,null,258]
[null,null,null,259]
[null,null,null,260]
[null,null,null,261]
[null,null,null,262]
[null,null,null,263]
[null,null,null,264]
[null,null,null,265]
[null,null,null,266]
[null,null,null,267]
[null,null,null,268]
[null,null,null,269]
[null,null,null,270]
[null,null,null,271]
[null,null,null,272]
[null,null,null,273]
[null,null,null,274]
[null,null,null,275]
[null,null,null,276]
[null,null,null,277]
[null,null,null,278]
[null,null,null,279]
[null,null,null,280]
[null,null,null,281]
[null,null,null,282]
[null,null,null,283]
[null,null,null,284]
[null,null,null,285]
[null,null,null,286]
[null,null,null,287]
[null,null,null,288]
[null,null,null,289]
[null,null,null,290]
[null,null,null,291]
[null,null,null,292]
[null,null,null,293]
[null,null,null,294]
[null,null,null,295]
[null,null,null,296]
[null,null,null,297]
[null,null,null,298]
[null,null,null,299]
[null,null,null,300]
[null,null,null,301]
[null,null,null,302]
[null,null,null,303]
[null,null,null,304]
[null,null,null,305]
[null,null,null,306]
[null,null,null,307]
[null,null,null,308]
[null,null,null,309]
[null,null,null,310]
[null,null,null,311]
[null,null,null,312]
[null,null,null,313]
[null,null,null,314]
[null,null,null,315]
[null,null,null,316]
[null,null,null,317]
[null,null,null,318]
[null,null,null,319]
[null,null,null,320]
[null,null,null,321]
[null,null,null,322]
[null,null,null,323]
[null,null,null,324]
[null,null,null,325]
[null,null,null,326]
[null,null,null,327]
[null,null,null,328]
[null,null,null,329]
[null,null,null,330]
[null,null,null,331]
[null,null,null,332]
[null,null,null,333]
[null,null,null,334]
[null,null,null,335]
[null,null,null,336]
[null,null,null,337]
[null,null,null,338]
[null,null,null,339]
[null,null,null,340]
[null,null,null,341]
[null,null,null,342]
[null,null,null,343]
[null,null,null,344]
[null,null,null,345]
[null,null,null,346]
[null,null,null,347]
[null,null,null,348]
[null,null,null,349]
[null,null,null,350]
[null,null,null,351]
[null,null,null,352]
[null,null,null,353]
[null,null,null,354]
[null,null,null,355]
[null,null,null,356]
[null,null,null,357]
[null,null,null,358]
[null,null,null,359]
[null,null,null,360]
[null,null,null,361]
[null,null,null,362]
[null,null,null,363]
[null,null,null,364]
[null,null,null,365]
[null,null,null,366]
[null,null,null,367]
[null,null,null,368]
[null,null,null,369]
[null,null,null,370]
[null,null,null,371]
[null,null,null,372]
[null,null,null,373]
[null,null,null,374]
[null,null,null,375]
[null,null,null,376]
[null,null,null,377]
[null,null,null,378]
[null,null,null,379]
[null,null,null,380]
[null,null,null,381]
[null,null,null,382]
[null,null,null,383]
[null,null,null,384]
[null,null,null,385]
[null,null,null,386]
[null,null,null,387]
[null,null,null,388]
[null,null,null,389]
[null,null,null,390]
[null,null,null,391]
[null,null,null,392]
[null,null,null,393]
[null,null,null,394]
[null,null,null,395]
[null,null,null,396]
[null,null,null,397]
[null,null,null,398]
[null,null,null,399]
[null,null,null,400]
[null,null,null,401]
[null,null,null,402]
[null,null,null,403]
[null,null,null,404]
[null,null,null,405]
[null,null,null,406]
[null,null,null,407]
[null,null,null,408]
[null,null,null,409]
[null,null,null,410]
[null,null,null,411]
[null,null,null,412]
[null,null,null,413]
[null,null,null,414]
[null,null,null,415]
[null,null,null,416]
[null,null,null,417]
[null,null,null,418]
[null,null,null,419]
[null,null,null,420]
[null,null,null,421]
[null,null,null,422]
[null,null,null,423]
[null,null,null,424]
[null,null,null,425]
[null,null,null,426]
[null,null,null,427]
[null,null,null,428]
[null,null,null,429]
[null,null,null,430]
[null,null,null,431]
[null,null,null,432]
[null,null,null,433]
[null,null,null,434]
[null,null,null,435]
[null,null,null,436]
[null,null,null,437]
[null,null,null,438]
[null,null,null,439]
[null,null,null,440]
[null,null,null,441]
[null,null,null,442]
[null,null,null,443]
[null,null,null,444]
[null,null,null,445]
[null,null,null,446]
[null,null,null,447]
[null,null,null,448]
[null,null,null,449]
[null,null,null,450]
[null,null,null,451]
[null,null,null,452]
[null,null,null,453]
[null,null,null,454]
[null,null,null,455]
[null,null,null,456]
[null,null,null,457]
[null,null,null,458]
[null,null,null,459]
[null,null,null,460]
[null,null,null,461]
[null,null,null,462]
[null,null,null,463]
[null,null,null,464]
[null,null,null,465]
[null,null,null,466]
[null,null,null,467]
[null,null,null,468]
[null,null,null,469]
[null,null,null,470]
[null,null,null,471]
[null,null,null,472]
[null,null,null,473]
[null,null,null,474]
[null,null,null,475]
[null,null,null,476]
[null,null,null,477]
[null,null,null,478]
[null,null,null,479]
[null,null,null,480]
[null,null,null,481]
[null,null,null,482]
[null,null,null,483]
[null,null,null,484]
[null,null,null,485]
[null,null,null,486]
[null,null,null,487]
[null,null,null,488]
[null,null,null,489]
[null,null,null,490]
[null,null,null,491]
[null,null,null,492]
[null,null,null,493]
[null,null,null,494]
[null,null,null,495]
[null,null,null,496]
[null,null,null,497]
[null,null,null,498]
[null,null,null,499]
[null,null,null,500]
[null,null,null,501]
[null,null,null,502]
[null,null,null,503]
[null,null,null,504]
[null,null,null,505]
[null,null,null,506]
[null,null,null,507]
[null,null,null,508]
[null,null,null,509]
[null,null,null,510]
[null,null,null,511]
[null,null,null,512]
[null,null,null,513]
[null,null,null,514]
[null,null,null,515]
[null,null,null,516]
[null,null,null,517]
[null,null,null,518]
[null,null,null,519]
[null,null,null,520]
[null,null,null,521]
[null,null,null,522]
[null,null,null,523]
[null,null,null,524]
[null,null,null,525]
[null,null,null,526]
[null,null,null,527]
[null,null,null,528]
[null,null,null,529]
[null,null,null,530]
[null,null,null,531]
[null,null,null,532]
[null,null,null,533]
[null,null,null,534]
[null,null,null,535]
[null,null,null,536]
[null,null,null,537]
[null,null,null,538]
[null,null,null,539]
[null,null,null,540]
[null,null,null,541]
[null,null,null,542]
[null,null,null,543]
[null,null,null,544]
[null,null,null,545]
[null,null,null,546]
[null,null,null,547]
[null,null,null,548]
[null,null,null,549]
[null,null,null,550]
[null,null,null,551]
[null,null,null,552]
[null,null,null,553]
[null,null,null,554]
[null,null,null,555]
[null,null,null,556]
[null,null,null,557]
[null,null,null,558]
[null,null,null,559]
[null,null,null,560]
[null,null,null,561]
[null,null,null,562]
[null,null,null,563]
[null,null,null,564]
[null,null,null,565]
[null,null,null,566]
[null,null,null,567]
[null,null,null,568]
[null,null,null,569]
[null,null,null,570]
[null,null,null,571]
[null,null,null,572]
[null,null,null,573]
[null,null,null,574]
[null,null,null,575]
[null,null,null,576]
[null,null,null,577]
[null,null,null,578]
[null,null,null,579]
[null,null,null,580]
[null,null,null,581]
[null,null,null,582]
[null,null,null,583]
[null,null,null,584]
[null,null,null,585]
[null,null,null,586]
[null,null,null,587]
[null,null,null,588]
[null,null,null,589]
[null,null,null,590]
[null,null,null,591]
[null,null,null,592]
[null,null,null,593]
[null,null,null,594]
[null,null,null,595]
[null,null,null,596]
[null,null,null,597]
[null,null,null,598]
[null,null,null,599]
[null,null,null,600]
[null,null,null,601]
[null,null,null,602]
[null,null,null,603]
[null,null,null,604]
[null,null,null,605]
[null,null,null,606]
[null,null,null,607]
[null,null,null,608]
[null,null,null,609]
[null,null,null,610]
[null,null,null,611]
[null,null,null,612]
[null,null,null,613]
[null,null,null,614]
[null,null,null,615]
[null,null,null,616]
[null,null,null,617]
[null,null,null,618]
[null,null,null,619]
[null,null,null,620]
[null,null,null,621]
[null,null,null,622]
[null,null,null,623]
[null,null,null,624]
[null,null,null,625]
[null,null,null,626]
[null,null,null,627]
[null,null,null,628]
[null,null,null,629]
[null,null,null,630]
[null,null,null,631]
[null,null,null,632]
[null,null,null,633]
[null,null,null,634]
[null,null,null,635]
[null,null,null,636]
[null,null,null,637]
[null,null,null,638]
[null,null,null,639]
[null,null,null,640]
[null,null,null,641]
[null,null,null,642]
[null,null,null,643]
[null,null,null,644]
[null,null,null,645]
[null,null,null,646]
[null,null,null,647]
[null,null,null,648]
[null,null,null,649]
[null,null,null,650]
[null,null,null,651]
[null,null,null,652]
[null,null,null,653]
[null,null,null,654]
[null,null,null,655]
[null,null,null,656]
[null,null,null,657]
[null,null,null,658]
[null,null,null,659]
[null,null,null,660]
[null,null,null,661]
[null,null,null,662]
[null,null,null,663]
[null,null,null,664]
[null,null,null,665]
[null,null,null,666]
[null,null,null,667]
[null,null,null,668]
[null,null,null,669]
[null,null,null,670]
[null,null,null,671]
[null,null,null,672]
[null,null,null,673]
[null,null,null,674]
[null,null,null,675]
[null,null,null,676]
[null,null,null,677]
[null,null,null,678]
[null,null,null,679]
[null,null,null,680]
[null,null,null,681]
[null,null,null,682]
[null,null,null,683]
[null,null,null,684]
[null,null,null,685]
[null,null,null,686]
[null,null,null,687]
[null,null,null,688]
[null,null,null,689]
[null,null,null,690]
[null,null,null,691]
[null,null,null,692]
[null,null,null,693]
[null,null,null,694]
[null,null,null,695]
[null,null,null,696]
[null,null,null,697]
[null,null,null,698]
[null,null,null,699]
[null,null,null,700]
[null,null,null,701]
[null,null,null,702]
[null,null,null,703]
[null,null,null,704]
[null,null,null,705]
[null,null,null,706]
[null,null,null,707]
[null,null,null,708]
[null,null,null,709]
[null,null,null,710]
[null,null,null,711]
[null,null,null,712]
[null,null,null,713]
[null,null,null,714]
[null,null,null,715]
[null,null,null,716]
[null,null,null,717]
[null,null,null,718]
[null,null,null,719]
[null,null,null,720]
[null,null,null,721]
[null,null,null,722]
[null,null,null,723]
[null,null,null,724]
[null,null,null,725]
[null,null,null,726]
[null,null,null,727]
[null,null,null,728]
[null,null,null,729]
[null,null,null,730]
[null,null,null,731]
[null,null,null,732]
[null,null,null,733]
[null,null,null,734]
[null,null,null,735]
[null,null,null,736]
[null,null,null,737]
[null,null,null,738]
[null,null,null,739]
[null,null,null,740]
[null,null,null,741]
[null,null,null,742]
[null,null,null,743]
[null,null,null,744]
[null,null,null,745]
[null,null,null,746]
[null,null,null,747]
[null,null,null,748]
[null,null,null,749]
[null,null,null,750]
[null,null,null,751]
[null,null,null,752]
[null,null,null,753]
[null,null,null,754]
[null,null,null,755]
[null,null,null,756]
[null,null,null,757]
[null,null,null,758]
[null,null,null,759]
[null,null,null,760]
[null,null,null,761]
[null,null,null,762]
[null,null,null,763]
[null,null,null,764]
[null,null,null,765]
[null,null,null,766]
[null,null,null,767]
[null,null,null,768]
[null,null,null,769]
[null,null,null,770]
[null,null,null,771]
[null,null,null,772]
[null,null,null,773]
[null,null,null,774]
[null,null,null,775]
[null,null,null,776]
[null,null,null,777]
[null,null,null,778]
[null,null,null,779]
[null,null,null,780]
[null,null,null,781]
[null,null,null,782]
[null,null,null,783]
[null,null,null,784]
[null,null,null,785]
[null,null,null,786]
[null,null,null,787]
[null,null,null,788]
[null,null,null,789]
[null,null,null,790]
[null,null,null,791]
[null,null,null,792]
[null,null,null,793]
[null,null,null,794]
[null,null,null,795]
[null,null,null,796]
[null,null,null,797]
[null,null,null,798]
[null,null,null,799]
[null,null,null,800]
[null,null,null,801]
[null,null,null,802]
[null,null,null,803]
[null,null,null,804]
[null,null,null,805]
[null,null,null,806]
[null,null,null,807]
[null,null,null,808]
[null,null,null,809]
[null,null,null,810]
[null,null,null,811]
[null,null,null,812]
[null,null,null,813]
[null,null,null,814]
[null,null,null,815]
[null,null,null,816]
[null,null,null,817]
[null,null,null,818]
[null,null,null,819]
[null,null,null,820]
[null,null,null,821]
[null,null,null,822]
[null,null,null,823]
[null,null,null,824]
[null,null,null,825]
[null,null,null,826]
[null,null,null,827]
[null,null,null,828]