{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Summary","Encumbrances","Addt'l Bdgt","Exp Forecasting","Other Expenses","Appt Info DataDump","Budget Detail DataDump","Expense Detail DataDump"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":63,"comments":3,"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":"Instructions","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Forecasting Tool Instructions"]
[]
[]
["Use the latest Forecasting Template and save to your computer or shared drive",null,"Link to Sponsored Programs site to obtain latest Forecasting Template  (under Forms)"]
["Run the Business Objects query ",null,"Follow directions listed within the \"Post-Award Procedures Manual\" for using the Business Objects Query"]
[]
["Paste the information into the \"Appt Info DataDump\", \"Budget Detail DataDump\", & Expense Detail DataDump\" tabs"]
[null,"This data will fill in various sections of the \"Summary\" & \"Exp Forecasting\" tabs"]
["Parent P/G & sub-accounts"]
[null,"If you have a project with sub-accounts, you can repeat the Business Objects Query for each sub-account and paste the information directly below the previous datadump per tab.  NOTE:  When you have data dumps from several p/g #s, you will need to manually override the Statement Balance (cell L6) on the \"Exp Forecasting\" tab to reflect the Statement Balance of the entire project (use the total # from M-Reports that includes parent p/g & subs)"]
[]
["Verify DataDump #'s"]
[null,"Using M-Reports as a reference, it is a good idea to verify the #'s in M-Reports (Parent summary if more than one p/g#) match the Forecasting information on the Summary tab (Columns labeled A & B)"]
[null,"If you are adding more than 1 p/g data to this forecasting tool, you will need to combine the statement balances in cell L6 on the \"Exp Forecasting\" tab"]
[]
["Cells you may change:   ONLY change cells that are colored yellow"]
[]
["Encumbrances tab"]
[null,"Using the RTF information in M-Reports, Input information from the blue columns labeled \"Expended since last month closed...\", \"Payroll/Fin Aid Commitments\" ,  \"Purchasing Commitments\" & \"Other Unit Commitments\" columns into the \"Encumbrances tab\"  (if you have sub-accounts, you will need to add their encumbrances as well)"]
["Additional Budget tab"]
[null,"If you have the information for expected budget for future years, you can enter that information on the \"Additional Budget\" tab"]
[]
["Exp Forecasting tab"]
[]
[null,"Your forecast may or may not be for additional years.  These 4 columns labeled Year 2-5 may not be necessary.  (ex.  Your current budget year maybe the last year of the project and you only want to forecast thru the project end date.   Or you may want to budget one additional year (NCTX) and may only need to use the first column.   Cells in yellow can be changed to what is forecasted for that time period.   You can change the title of the column accordingly."]
[]
[null,"Once you have determined the years you need to forecast, you can zero out the new dist % for the other years that are not needed."]
[]
[]
[]
["Other Expenses tab"]
[null,"Use this tab to list any future non-salary or fb expenditures.  These would be for those categories listed on this tab."]
[]
[]
["Adding New Employees"]
[]
[null,"The best way to add a new employee is to list them on the \"Appt Info DataDump\" tab after you have done your initial data dump of current appointment info.   To add a new employee, list information in the following columns (From the HR/Job Data Changes/Compensation section in Wolv Access for UM employees)  Employee, Monthly Comp Rate & FB Rate).  This info will carryforward to the \"Exp Forecasting tab\".  "]
[null,"Then go to the \"Exp Forecasting tab\" and enter the # of months in the current year (Column F) and the new distribution (Column I) for the new employees effort.  The tool will calculate out costs for this new employee for the current budget year.  To add for future years, you need to add effort distribution in the appropriate column(s) for the appropriate year(s). "]

{"sheet":"Summary","index":1,"n_rows":89,"n_cols":27,"rows_kept":89,"cut":false,"hidden":false,"merged":[[11,22,11,24],[12,22,12,24],[13,22,13,24],[10,14,11,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," ",null," ",null,null," "]
[null,null,null," Total charges to date as of ( if not the same as the budget end date)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," ",null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," ",null," ",null,null," "]
[null,"Forecasting Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"forecasting template prepared on :"," ",null," ",null,null," "]
[null,"PG:",{"$f":"'Exp Forecasting'!B3","v":"PASTE HERE"},null,null,null,null,null,null,{"$f":"'Exp Forecasting'!C3","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2017-01-26T14:23:52.620"}," ",null," ",null,null," "]
[null,"PI:",{"$f":"'Appt Info DataDump'!O2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null,null," "]
[null,"Start/End Date:",{"$f":"'Appt Info DataDump'!P2","v":"00:00:00"},"-",{"$f":"'Appt Info DataDump'!D2","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null,null," "]
[null,"Bdgt Pd Start/End Date:",{"$f":"'Appt Info DataDump'!Q2","v":"00:00:00"},"-",{"$f":"'Appt Info DataDump'!R2","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null,null," "]
[null,null,null,null,"(A)",null,"(B)",null,"PREVIOUSLY",null,"(C)",null,"(D-1)",null,"(D-2)",null,"(E)",null,"(E)",null,null," ",null," ",null,null," "]
[null,null,null,null,"CURRENT",null,"TOTAL CHARGES",null,"REPORTED",null,"ADDITIONAL",null,"CURRENT M-REPORTS",null,"PROPOSED ENCUMBRANCES",null,"TOTAL EXPENSES+",null,"TOTAL EXPENSES+",null,"BALANCE"," ",null," ",null,null," "]
[null,"BUDGET CATEGORY",null,null,"BUDGET",null,"TO DATE",null,"CHARGES",null,"BUDGET",null,"ENCUMBRANCES",null,null,null,"PROJECTIONS (B+D)",null,"PROJECTIONS (B+D1+D2)",null,"(A+C-E)"," ",null,null,null,null," "]
[null,"Salaries & Wages",null,null,{"$f":"'Budget Detail DataDump'!G$108","v":0},null,{"$f":"'Expense Detail DataDump'!G1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E5+'Addt''l Bdgt'!G5+'Addt''l Bdgt'!I5+'Addt''l Bdgt'!K5","v":0},null,{"$f":"+Encumbrances!F3","v":0},null,{"$f":"'Exp Forecasting'!L30+'Exp Forecasting'!Q30+'Exp Forecasting'!U30+'Exp Forecasting'!Y30+'Exp Forecasting'!AC30","v":0},null,{"$f":"ROUND(SUM(G13-I13+O13),2)","v":0},null,{"$f":"ROUND(G13+M13+O13,2)","v":0},null,{"$f":"ROUND(E13+K13-S13,2)","v":0}," ",null,null,null,null," "]
[null,"Admin Salaries (A-21 Monitored)",null,null,{"$f":"'Budget Detail DataDump'!H$108","v":0},null,{"$f":"'Expense Detail DataDump'!H1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E6+'Addt''l Bdgt'!G6+'Addt''l Bdgt'!I6+'Addt''l Bdgt'!K6","v":0},null,{"$f":"+Encumbrances!F4","v":0},null,{"$f":"[1]Encumb!K$118","v":0},null,{"$f":"ROUND(SUM(G14-I14+O14),2)","v":0},null,{"$f":"ROUND(G14+M14+O14,2)","v":0},null,{"$f":"ROUND(E14+K14-S14,2)","v":0}," ",null,null,null,null," "]
[null,"Clerical Salaries",null,null,{"$f":"'Budget Detail DataDump'!I108","v":0},null,{"$f":"'Expense Detail DataDump'!I1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E7+'Addt''l Bdgt'!G7+'Addt''l Bdgt'!I7+'Addt''l Bdgt'!K7","v":0},null,{"$f":"+Encumbrances!F5","v":0},null,{"$f":"[1]Encumb!L$118","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E16=0,G16=0,I16=0,K16=0,O16=0,Q16=0,U16=0),\"|\",\" \")","v":"|"},"SRO Salaries",null,null,{"$f":"'Budget Detail DataDump'!J108","v":0},null,{"$f":"'Expense Detail DataDump'!J1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E8+'Addt''l Bdgt'!G8+'Addt''l Bdgt'!I8+'Addt''l Bdgt'!K8","v":0},null,{"$f":"+Encumbrances!F6","v":0},null,{"$f":"[1]Encumb!M$118","v":0},null,0,null,0,null,0]
[null,"Fringe Benefits",null,null,{"$f":"'Budget Detail DataDump'!K108","v":0},null,{"$f":"'Expense Detail DataDump'!K1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E9+'Addt''l Bdgt'!G9+'Addt''l Bdgt'!I9+'Addt''l Bdgt'!K9","v":0},null,{"$f":"+Encumbrances!F7","v":0},null,{"$f":"SUM('Exp Forecasting'!L49+'Exp Forecasting'!Q49+'Exp Forecasting'!U49+'Exp Forecasting'!Y49+'Exp Forecasting'!AC49)","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[null,"Tuition Waiver",null,null,{"$f":"'Budget Detail DataDump'!L108","v":0},null,{"$f":"'Expense Detail DataDump'!L1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E10+'Addt''l Bdgt'!G10+'Addt''l Bdgt'!I10+'Addt''l Bdgt'!K10","v":0},null,{"$f":"+Encumbrances!F8","v":0},null,{"$f":"'Exp Forecasting'!L75+'Exp Forecasting'!L76+'Exp Forecasting'!L77+'Exp Forecasting'!Q75+'Exp Forecasting'!Q76+'Exp Forecasting'!Q77+'Exp Forecasting'!U75+'Exp Forecasting'!U76+'Exp Forecasting'!U77+'Exp Forecasting'!Y75+'Exp Forecasting'!Y76+'Exp Forecasting'!Y77+'Exp Forecasting'!AC75+'Exp Forecasting'!AC76+'Exp Forecasting'!AC77","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E19=0,G19=0,I19=0,K19=0,O19=0,Q19=0,U19=0),\"|\",\" \")","v":"|"},"Consultants",null,null,{"$f":"'Budget Detail DataDump'!M108","v":0},null,{"$f":"'Expense Detail DataDump'!M1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E11+'Addt''l Bdgt'!G11+'Addt''l Bdgt'!I11+'Addt''l Bdgt'!K11","v":0},null,{"$f":"+Encumbrances!F9","v":0},null,{"$f":"'Exp Forecasting'!L53+'Exp Forecasting'!Q53+'Exp Forecasting'!U53+'Exp Forecasting'!Y53+'Exp Forecasting'!AC53","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E20=0,G20=0,I20=0,K20=0,O20=0,Q20=0,U20=0),\"|\",\" \")","v":"|"},"Respondents/Subjects",null,null,{"$f":"'Budget Detail DataDump'!N108","v":0},null,{"$f":"'Expense Detail DataDump'!N1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E12+'Addt''l Bdgt'!G12+'Addt''l Bdgt'!I12+'Addt''l Bdgt'!K12","v":0},null,{"$f":"+Encumbrances!F10","v":0},null,{"$f":"'Exp Forecasting'!L54+'Exp Forecasting'!Q54+'Exp Forecasting'!U54+'Exp Forecasting'!Y54+'Exp Forecasting'!AC54","v":0},null,0,null,0,null,0]
[{"$f":"IF(AND(E21=0,G21=0,I21=0,K21=0,O21=0,Q21=0,U21=0),\"|\",\" \")","v":"|"},"Stipends",null,null,{"$f":"'Budget Detail DataDump'!O108","v":0},null,{"$f":"'Expense Detail DataDump'!O1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E13+'Addt''l Bdgt'!G13+'Addt''l Bdgt'!I13+'Addt''l Bdgt'!K13","v":0},null,{"$f":"+Encumbrances!F11","v":0},null,{"$f":"'Exp Forecasting'!L55+'Exp Forecasting'!Q55+'Exp Forecasting'!U55+'Exp Forecasting'!Y55+'Exp Forecasting'!AC55","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E22=0,G22=0,I22=0,K22=0,O22=0,Q22=0,U22=0),\"|\",\" \")","v":"|"},"Student Aid",null,null,{"$f":"'Budget Detail DataDump'!P108","v":0},null,{"$f":"'Expense Detail DataDump'!P1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E14+'Addt''l Bdgt'!G14+'Addt''l Bdgt'!I14+'Addt''l Bdgt'!K14","v":0},null,{"$f":"+Encumbrances!F12","v":0},null,{"$f":"'Exp Forecasting'!L56+'Exp Forecasting'!Q56+'Exp Forecasting'!U56+'Exp Forecasting'!Y56+'Exp Forecasting'!AC56","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E23=0,G23=0,I23=0,K23=0,O23=0,Q23=0,U23=0),\"|\",\" \")","v":"|"},"Patient Care",null,null,{"$f":"'Budget Detail DataDump'!Q108","v":0},null,{"$f":"'Expense Detail DataDump'!Q1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E15+'Addt''l Bdgt'!G15+'Addt''l Bdgt'!I15+'Addt''l Bdgt'!K15","v":0},null,{"$f":"+Encumbrances!F13","v":0},null,{"$f":"'Exp Forecasting'!L57+'Exp Forecasting'!Q57+'Exp Forecasting'!U57+'Exp Forecasting'!Y57+'Exp Forecasting'!AC57","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[null,"General Supplies (A21 Monitored)",null,null,{"$f":"'Budget Detail DataDump'!R108","v":0},null,{"$f":"'Expense Detail DataDump'!R1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E16+'Addt''l Bdgt'!G16+'Addt''l Bdgt'!I16+'Addt''l Bdgt'!K16","v":0},null,{"$f":"+Encumbrances!F14","v":0},null,{"$f":"'Exp Forecasting'!L58+'Exp Forecasting'!Q58+'Exp Forecasting'!U58+'Exp Forecasting'!Y58+'Exp Forecasting'!AC58","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[null,"Research Supplies & Services",null,null,{"$f":"'Budget Detail DataDump'!S108","v":0},null,{"$f":"'Expense Detail DataDump'!S1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E17+'Addt''l Bdgt'!G17+'Addt''l Bdgt'!I17+'Addt''l Bdgt'!K17","v":0},null,{"$f":"+Encumbrances!F15","v":0},null,{"$f":"'Exp Forecasting'!L59+'Exp Forecasting'!Q59+'Exp Forecasting'!U59+'Exp Forecasting'!Y59+'Exp Forecasting'!AC59","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E26=0,G26=0,I26=0,K26=0,O26=0,Q26=0,U26=0),\"|\",\" \")","v":"|"},"Data Processing",null,null,{"$f":"'Budget Detail DataDump'!T108","v":0},null,{"$f":"'Expense Detail DataDump'!T1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E18+'Addt''l Bdgt'!G18+'Addt''l Bdgt'!I18+'Addt''l Bdgt'!K18","v":0},null,{"$f":"+Encumbrances!F16","v":0},null,{"$f":"'Exp Forecasting'!L60+'Exp Forecasting'!Q60+'Exp Forecasting'!U60+'Exp Forecasting'!Y60+'Exp Forecasting'!AC60","v":0},null,0,null,0,null,0]
[null,"Postage and Shipping (A21 Monitored)",null,null,{"$f":"'Budget Detail DataDump'!U108","v":0},null,{"$f":"'Expense Detail DataDump'!U1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E19+'Addt''l Bdgt'!G19+'Addt''l Bdgt'!I19+'Addt''l Bdgt'!K19","v":0},null,{"$f":"+Encumbrances!F17","v":0},null,{"$f":"'Exp Forecasting'!L61+'Exp Forecasting'!Q61+'Exp Forecasting'!U61+'Exp Forecasting'!Y61+'Exp Forecasting'!AC61","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[null,"Telephone Services (A21 Monitored)",null,null,{"$f":"'Budget Detail DataDump'!V108","v":0},null,{"$f":"'Expense Detail DataDump'!V1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E20+'Addt''l Bdgt'!G20+'Addt''l Bdgt'!I20+'Addt''l Bdgt'!K20","v":0},null,{"$f":"+Encumbrances!F18","v":0},null,{"$f":"'Exp Forecasting'!L62+'Exp Forecasting'!Q62+'Exp Forecasting'!U62+'Exp Forecasting'!Y62+'Exp Forecasting'!AC62","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E29=0,G29=0,I29=0,K29=0,O29=0,Q29=0,U29=0),\"|\",\" \")","v":"|"},"Pass Through Under 25K",null,null,{"$f":"'Budget Detail DataDump'!W108","v":0},null,{"$f":"'Expense Detail DataDump'!W1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E21+'Addt''l Bdgt'!G21+'Addt''l Bdgt'!I21+'Addt''l Bdgt'!K21","v":0},null,{"$f":"+Encumbrances!F19","v":0},null,{"$f":"'Exp Forecasting'!L63+'Exp Forecasting'!Q63+'Exp Forecasting'!U63+'Exp Forecasting'!Y63+'Exp Forecasting'!AC63","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E30=0,G30=0,I30=0,K30=0,O30=0,Q30=0,U30=0),\"|\",\" \")","v":"|"},"Pass Through Over 25K",null,null,{"$f":"'Budget Detail DataDump'!X108","v":0},null,{"$f":"'Expense Detail DataDump'!X1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E22+'Addt''l Bdgt'!G22+'Addt''l Bdgt'!I22+'Addt''l Bdgt'!K22","v":0},null,{"$f":"+Encumbrances!F20","v":0},null,{"$f":"'Exp Forecasting'!L64+'Exp Forecasting'!Q64+'Exp Forecasting'!U64+'Exp Forecasting'!Y64+'Exp Forecasting'!AC64","v":0},null,0,null,{"$f":"ROUND(G30+M30+O30,2)","v":0},null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E31=0,G31=0,I31=0,K31=0,O31=0,Q31=0,U31=0),\"|\",\" \")","v":"|"},"Alt & Renovations",null,null,{"$f":"'Budget Detail DataDump'!Y108","v":0},null,{"$f":"'Expense Detail DataDump'!Y1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E23+'Addt''l Bdgt'!G23+'Addt''l Bdgt'!I23+'Addt''l Bdgt'!K23","v":0},null,{"$f":"+Encumbrances!F21","v":0},null,{"$f":"'Exp Forecasting'!L65+'Exp Forecasting'!Q65+'Exp Forecasting'!U65+'Exp Forecasting'!Y65+'Exp Forecasting'!AC65","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[null,"Travel-Domestic",null,null,{"$f":"'Budget Detail DataDump'!Z108","v":0},null,{"$f":"'Expense Detail DataDump'!Z1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E24+'Addt''l Bdgt'!G24+'Addt''l Bdgt'!I24+'Addt''l Bdgt'!K24","v":0},null,{"$f":"+Encumbrances!F22","v":0},null,{"$f":"'Exp Forecasting'!L66+'Exp Forecasting'!Q66+'Exp Forecasting'!U66+'Exp Forecasting'!Y66+'Exp Forecasting'!AC66","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[{"$f":"IF(AND(E33=0,G33=0,I33=0,K33=0,O33=0,Q33=0,U33=0),\"|\",\" \")","v":"|"},"Travel-Foreign",null,null,{"$f":"'Budget Detail DataDump'!AA108","v":0},null,{"$f":"'Expense Detail DataDump'!AA1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E25+'Addt''l Bdgt'!G25+'Addt''l Bdgt'!I25+'Addt''l Bdgt'!K25","v":0},null,{"$f":"+Encumbrances!F23","v":0},null,{"$f":"'Exp Forecasting'!L67+'Exp Forecasting'!Q67+'Exp Forecasting'!U67+'Exp Forecasting'!Y67+'Exp Forecasting'!AC67","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
["|","Hosting (A21 Monitored)",null,null,{"$f":"'Budget Detail DataDump'!AC108","v":0},null,{"$f":"'Expense Detail DataDump'!AB1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E26+'Addt''l Bdgt'!G26+'Addt''l Bdgt'!I26+'Addt''l Bdgt'!K26","v":0},null,{"$f":"+Encumbrances!F24","v":0},null,{"$f":"'Exp Forecasting'!L68+'Exp Forecasting'!Q68+'Exp Forecasting'!U68+'Exp Forecasting'!Y68+'Exp Forecasting'!AC68","v":0},null,0,null,0,null,0]
["|","Equipment",null,null,{"$f":"'Budget Detail DataDump'!AD108","v":0},null,{"$f":"'Expense Detail DataDump'!AC1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E27+'Addt''l Bdgt'!G27+'Addt''l Bdgt'!I27+'Addt''l Bdgt'!K27","v":0},null,{"$f":"+Encumbrances!F25","v":0},null,{"$f":"'Exp Forecasting'!L69+'Exp Forecasting'!Q69+'Exp Forecasting'!U69+'Exp Forecasting'!Y69+'Exp Forecasting'!AC69","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
["|","Computing Center",null,null,{"$f":"'Budget Detail DataDump'!AF108","v":0},null,{"$f":"'Expense Detail DataDump'!AE1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E28+'Addt''l Bdgt'!G28+'Addt''l Bdgt'!I28+'Addt''l Bdgt'!K28","v":0},null,{"$f":"+Encumbrances!F26","v":0},null,{"$f":"'Exp Forecasting'!L70+'Exp Forecasting'!Q70+'Exp Forecasting'!U70+'Exp Forecasting'!Y70+'Exp Forecasting'!AC70","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
["|","ULAM",null,null,{"$f":"'Budget Detail DataDump'!AG108","v":0},null,{"$f":"'Expense Detail DataDump'!AF1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E29+'Addt''l Bdgt'!G29+'Addt''l Bdgt'!I29+'Addt''l Bdgt'!K29","v":0},null,{"$f":"+Encumbrances!F27","v":0},null,{"$f":"'Exp Forecasting'!L71+'Exp Forecasting'!Q71+'Exp Forecasting'!U71+'Exp Forecasting'!Y71+'Exp Forecasting'!AC71","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
["|","Other Spec Svc Fac",null,null,{"$f":"'Budget Detail DataDump'!AH108","v":0},null,{"$f":"'Expense Detail DataDump'!AG1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E30+'Addt''l Bdgt'!G30+'Addt''l Bdgt'!I30+'Addt''l Bdgt'!K30","v":0},null,{"$f":"+Encumbrances!F28","v":0},null,{"$f":"'Exp Forecasting'!L72+'Exp Forecasting'!Q72+'Exp Forecasting'!U72+'Exp Forecasting'!Y72+'Exp Forecasting'!AC72","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
["|","Unallocated",null,null,{"$f":"'Budget Detail DataDump'!AM108","v":0},null,0,null,0,null,{"$f":"'Addt''l Bdgt'!E31+'Addt''l Bdgt'!G31+'Addt''l Bdgt'!I31+'Addt''l Bdgt'!K31","v":0},null,{"$f":"+Encumbrances!F29","v":0},null,0,null,0,null,0,null,0," ",null," ",null,null," "]
[null,"Carryforward Pending",null,null,{"$f":"'Budget Detail DataDump'!AJ108","v":0},null,0,null,null,null,{"$f":"+'Addt''l Bdgt'!E32+'Addt''l Bdgt'!G32+'Addt''l Bdgt'!I32+'Addt''l Bdgt'!K32","v":0},null,{"$f":"+Encumbrances!F30","v":0},null,0,null,null,null,0,null,0]
[null,"Authorization Pending",null,null,{"$f":"'Budget Detail DataDump'!AK108","v":0},null,0,null,null,null,{"$f":"+'Addt''l Bdgt'!E33+'Addt''l Bdgt'!G33+'Addt''l Bdgt'!I33+'Addt''l Bdgt'!K33","v":0},null,{"$f":"+Encumbrances!F31","v":0},null,0,null,null,null,0,null,0]
["|","Non Sponsor Revenue",null,null,{"$f":"+'Budget Detail DataDump'!AL108","v":0},null,0,null,0,null,{"$f":"'Addt''l Bdgt'!E34+'Addt''l Bdgt'!G34+'Addt''l Bdgt'!I34+'Addt''l Bdgt'!K34","v":0},null,{"$f":"+Encumbrances!F32","v":0},null,0,null,0,null,0,null,0," ",null," ",null,null," "]
["|","Transfers",null,null,{"$f":"'Budget Detail DataDump'!AE108","v":0},null,{"$f":"'Expense Detail DataDump'!AD1008","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E35+'Addt''l Bdgt'!G35+'Addt''l Bdgt'!I35+'Addt''l Bdgt'!K35","v":0},null,{"$f":"+Encumbrances!F33","v":0},null,{"$f":"'Exp Forecasting'!L73+'Exp Forecasting'!Q73+'Exp Forecasting'!U73+'Exp Forecasting'!Y73+'Exp Forecasting'!AC73","v":0},null,0,null,0,null,0," ",null," ",null,null," "]
[null,"TOTAL DIRECT COSTS",null,null,{"$f":"ROUND(SUM(E13:E43),2)","v":0},null,{"$f":"ROUND(SUM(G13:G43),2)","v":0},null,0,null,{"$f":"ROUND(SUM(K13:K43),2)","v":0},null,{"$f":"ROUND(SUM(M13:M43),2)","v":0},null,{"$f":"ROUND(SUM(O13:O43),2)","v":0},null,{"$f":"ROUND(SUM(Q13:Q43),2)","v":0},null,{"$f":"ROUND(SUM(S13:S43),2)","v":0},null,{"$f":"ROUND(SUM(U13:U43),2)","v":0}," ",null," ",null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,"TOTAL INDIRECT COSTS",null,null,{"$f":"'Budget Detail DataDump'!AI108","v":0},null,{"$f":"ROUND('Expense Detail DataDump'!AH1008,2)","v":0},null,0,null,{"$f":"'Addt''l Bdgt'!E38+'Addt''l Bdgt'!G38+'Addt''l Bdgt'!I38+'Addt''l Bdgt'!K38","v":0},null,{"$f":"+Encumbrances!F36","v":0},null,{"$f":"'Exp Forecasting'!L81+'Exp Forecasting'!Q81+'Exp Forecasting'!U81+'Exp Forecasting'!Y81+'Exp Forecasting'!AC81","v":0},"**",{"$f":"ROUND(SUM(G46-I46+K46+O46),2)","v":0},null,{"$f":"ROUND(G46+M46+O46,2)","v":0},null,{"$f":"ROUND(E46+K46-S46,2)","v":0}," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,"Sponsor Total Balance",null,null,{"$f":"ROUND(SUM(E44+E46),2)","v":0},null,{"$f":"ROUND(SUM(G44+G46),2)","v":0},null,0,null,{"$f":"ROUND(SUM(K44+K46),2)","v":0},null,{"$f":"ROUND(SUM(M44+M46),2)","v":0},null,{"$f":"ROUND(SUM(O44+O46),2)","v":0},null,{"$f":"ROUND(SUM(Q44+Q46),2)","v":0},null,{"$f":"ROUND(SUM(S44+S46),2)","v":0},null,{"$f":"ROUND(SUM(U44+U46),2)","v":0}," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[]
[null,"U/M Cost Sharing",null,null,0,null,{"$f":"E51","v":0},null,0,null,0,null,null,null,0,null,{"$f":"ROUND(SUM(G51-I51+K51+O51),2)","v":0},null,{"$f":"ROUND(G51+K51+O51,2)","v":0},null,{"$f":"ROUND(E51-S51,2)","v":0}," ",null,null,null,null," "]
[null,"Prior Period Expense",null,null,0,null,{"$f":"SUM(E52)","v":0},null,0,null,0,null,null,null,0,null,{"$f":"ROUND(SUM(G52-I52+K52+O52),2)","v":0},null,{"$f":"ROUND(G52+K52+O52,2)","v":0},null,{"$f":"ROUND(E52-S52,2)","v":0}," ",null,null,null,null," "]
[null,"Prior Period Cost Sharing",null,null,0,null,{"$f":"SUM(E53)","v":0},null,0,null,0,null,null,null,0,null,{"$f":"ROUND(SUM(G53-I53+K53+O53),2)","v":0},null,{"$f":"ROUND(G53+K53+O53,2)","v":0},null,{"$f":"ROUND(E53-S53,2)","v":0}," ",null,null,null,null," "]
[null,"PROJECT BALANCE",null,null,{"$f":"ROUND(SUM(E48:E53),2)","v":0},null,{"$f":"ROUND(SUM(G48:G53),2)","v":0},null,0,null,{"$f":"ROUND(SUM(K48:K53),2)","v":0},null,null,null,{"$f":"ROUND(SUM(O48:O53),2)","v":0},null,{"$f":"ROUND(SUM(Q48:Q53),2)","v":0},null,{"$f":"ROUND(SUM(S48:S53),2)","v":0},null,{"$f":"ROUND(SUM(U50:U53),2)","v":0}," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,{"$f":"IF('[1]DW-Exp'!AI258>0,CONCATENATE(\"Fabrication account 614060 is being utilized for the amount of \",TEXT('[1]DW-Exp'!AL258,\"$0.00\"),\". Activity should either be capitilized or reaccounted to an appropriate expense. \"), \" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,{"$f":"IF('[1]DW-Exp'!AJ258>0,\"Lump Sum Advance needs to be resolved\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,"INDIRECT COST CALCULATION:",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"I/C Code:  \",'[1]Data Sheet'!E94)","v":"I/C Code:  0"},null,null,null,"** I/C ADJUSTMENTS",null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,null,"D/C Base",null,"Rate",null,null,null,"Indirect Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"MTDC:",{"$f":"IF('[1]Data Sheet'!E130=\"N\",C7,CONCATENATE(\"07/01/06 - \",'[1]Data Sheet'!E71))","v":0},null,{"$f":"ROUND('[1]Excel Macros'!C42-SUM(E64:E68),2)","v":0},"X",{"$f":"'[1]Data Sheet'!E93","v":0},null,null,"=",{"$f":"ROUND(E63*G63,2)","v":0},null,null,null,0,"I/C Overrun",null,"Use Only on Finals",null,null,null," ",null,null,null,null," "]
[null,"MTDC:","07/01/03 - 06/30/06",null,0,"X",0.53,null,null,"=",{"$f":"ROUND(E64*G64,2)","v":0},null,null,null,0,"I/C Adjust MTDC: ",null,null,null,null,null," ",null,null,null,null," "]
[null,"MTDC:","07/01/01 - 06/30/03",null,0,"X",0.51,null,null,"=",0,null,null,null,0,"I/C Rounding",null,null,null,null,null," ",null,null,null,null," "]
[{"$f":"IF(E66=0,\"|\",\" \")","v":"|"},"MTDC:","07/01/00 - 06/30/01",null,0,"X",0.51500000000000001,null,null,"=",0,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[{"$f":"IF(E67=0,\"|\",\" \")","v":"|"},"MTDC:","07/01/99 - 06/30/00",null,0,"X",0.52,null,null,"=",0,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[{"$f":"IF(E68=0,\"|\",\" \")","v":"|"},"MTDC:","07/01/96 - 06/30/99",null,0,"X",0.52500000000000002,null,null,"=",0,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,"NON-MTDC:",null,null,{"$f":"ROUND('[1]Excel Macros'!D42,2)","v":0},"X",0,null,null,"=",0,null,null,null,{"$f":"ROUND('[1]Excel Macros'!C61*Summary!G63,2)","v":0},"I/C on Adjustments",null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,null,{"$f":"ROUND(SUM(E63:E69),2)","v":0},null,null,null,null,null,{"$f":"ROUND(SUM(K63:K69),2)","v":0},null,null,null,{"$f":"ROUND(O43*G63,2)","v":0},"I/C on Transfers",null,null,null,null,null," ",null,null,null,null," "]
[null,null,"Overrun",null,{"$f":"ROUND(Q43,2)","v":0},null,null,null,null,null,{"$f":"ROUND(O70+O63,2)","v":0},null,null,null,{"$f":"ROUND(SUM(O63:O70),2)","v":0},"     Total",null,null,null,null,null," ","I/C Difference",null,null,null," "]
[null,"         SPONSOR TOTAL",null,null,{"$f":"ROUND(E70+E71,2)","v":0},null,null,null,null,null,{"$f":"ROUND(K70+K71,2)","v":0},null,null,null,null,null,null,null,null,null,null," ",{"$f":"+K72-Q46","v":0},null,null,null," "]
[null,null,null,null,{"$f":"IF(ROUND(Q44,2)=ROUND(E72,2),\"\",\"  UNBALANCED \")","v":""},null,null,null,null,null,{"$f":"IF(ROUND(K72,2)=ROUND(Q46,2),\"\",\"   UNBALANCED\")","v":""},null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,"NOTES:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('[1]Excel Macros'!C184>0.5,\"ERROR -- CHECK A21\",\"\")","v":""},null,null,null,null,null,null," ",null,null,null,null," "]
[{"$f":"IF(B75<>\" \",\" \",\"|\")","v":" "},{"$f":"IF('[1]Data Sheet'!E148=\"\",\" \",CONCATENATE(\"General Fund Cost Share Account=\",'[1]Data Sheet'!E148))","v":"General Fund Cost Share Account= "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[{"$f":"IF(B76<>\"\",\" \",\"|\")","v":"|"},{"$f":"IF('[1]Data Sheet'!E145=\"y\",\"Total Cost Sharing to Report:\",IF('[1]Data Sheet'!E144=\"y\",\"Total Amount of Cost Sharing:\",\"\"))","v":""},null,null,{"$f":"IF(B76<>\"\",'[1]Data Sheet'!E158,\"\")","v":""}]
[{"$f":"IF(B77<>\" \",\" \",\"|\")","v":"|"},{"$f":"IF('[1]Data Sheet'!E146<>\"y\",\" \",CONCATENATE(\"The actual cost sharing reported varied due to the precision of the estimators used in the grant proposal\"))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,"Approved By:  ___________",null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"REPLACE(+'[1]Data Sheet'!C25,20,25,'[1]Data Sheet'!E25)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,{"$f":"CONCATENATE(\"Chartfield Combination: \",'[1]Data Sheet'!E36,\" / \",'[1]Data Sheet'!E37,\" / \",'[1]Data Sheet'!E38,\" / \",'[1]Data Sheet'!E39,\" / \",'[1]Data Sheet'!E31,\"     Short Code: \",'[1]Data Sheet'!E32)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,{"$f":"CELL(\"FILENAME\",T83)","v":"C:\\Users\\admall\\Downloads\\[Forecasting_Template_by_ProjectGrant_1.26.17_revised.xlsm]Summary"},null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[9999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[9999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Encumbrances","index":2,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Using the RTF information in M-Reports, Input information from the blue columns labeled \"Expended since last month closed...\", \"Payroll/Fin Aid Commitments\" &  \"Purchasing Commitment\"s columns into the \"Encumbrances tab\"  (if you have sub-accounts, you will need to add their encumbrances as well)"]
["BUDGET CATEGORY","Expended since last month closed (excluding Payroll/Fin Aid)","Payroll/Fin Aid Commitments","Purchasing Commitments","Other Unit Commitments"]
["Salaries & Wages",null,0,null,0,{"$f":"SUM(B3:E3)","v":0}]
["Admin Salaries (A-21 Monitored)",null,0,null,0,{"$f":"SUM(B4:E4)","v":0}]
["Clerical Salaries",null,0,null,0,0]
["SRO Salaries",null,0,null,0,0]
["Fringe Benefits",null,0,null,0,0]
["Tuition Waiver",0,null,0,0,0]
["Consultants",0,null,0,0,0]
["Respondents/Subjects",0,null,0,0,0]
["Stipends",0,null,0,0,0]
["Student Aid",0,null,0,0,0]
["Patient Care",0,null,0,0,0]
["General Supplies (A21 Monitored)",0,null,0,0,0]
["Research Supplies & Services",0,null,0,0,0]
["Data Processing",0,null,0,0,0]
["Postage and Shipping (A21 Monitored)",0,null,0,0,0]
["Telephone Services (A21 Monitored)",0,null,0,0,0]
["Pass Through Under 25K",0,null,0,0,0]
["Pass Through Over 25K",0,null,0,0,0]
["Alt & Renovations",0,null,0,0,0]
["Travel-Domestic",0,null,0,0,0]
["Travel-Foreign",0,null,0,0,0]
["Hosting (A21 Monitored)",0,null,0,0,0]
["Equipment",0,null,0,0,0]
["Computing Center",0,null,0,0,0]
["ULAM",0,null,0,0,0]
["Other Spec Svc Fac",0,null,0,0,0]
["Unallocated",0,null,0,0,0]
["Carryforward Pending",0,null,0,0,0]
["Authorization Pending",0,null,0,0,0]
["Non Sponsor Revenue",0,null,0,0,0]
["Transfers",0,null,0,0,0]
["TOTAL DIRECT COSTS",{"$f":"SUM(B8:B33)","v":0},{"$f":"SUM(C3:C33)","v":0},{"$f":"SUM(D3:D33)","v":0},{"$f":"SUM(E3:E33)","v":0},{"$f":"SUM(B34:E34)","v":0}]
[]
["TOTAL INDIRECT COSTS",0,0,0,0,{"$f":"SUM(B36:E36)","v":0}]
[]
["TOTAL DIRECT & INDIRECT COSTS",{"$f":"+B34+B36","v":0},{"$f":"+C34+C36","v":0},0,0,{"$f":"SUM(B38:E38)","v":0},{"$f":"+F34+F36","v":0}]

{"sheet":"Addt'l Bdgt","index":3,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Budget Start Date",{"$f":"+'Exp Forecasting'!E12","v":"00:00:00"}]
[null,"Budget End Date",{"$f":"+'Exp Forecasting'!G12","v":"00:00:00"}]
[null,null,{"$f":"Summary!E11","v":"CURRENT"},null,"Addt'l Bdgt",null,"Addt'l Bdgt",null,"Addt'l Bdgt",null,"Addt'l Bdgt",null,null,"All Years"]
[null,{"$f":"Summary!B12","v":"BUDGET CATEGORY"},{"$f":"Summary!E12","v":"BUDGET"},null,{"$f":"+'Exp Forecasting'!P6","v":"Year 2"},null,{"$f":"+'Exp Forecasting'!T6","v":"Year 3"},null,{"$f":"+'Exp Forecasting'!X6","v":"Year 4"},null,{"$f":"+'Exp Forecasting'!AB6","v":"Year 5"},null,null," Combined"]
[null,{"$f":"Summary!B13","v":"Salaries & Wages"},{"$f":"Summary!E13","v":0},null,0,null,0,null,0,null,0,null,null,{"$f":"SUM(C5:K5)","v":0}]
[null,{"$f":"Summary!B14","v":"Admin Salaries (A-21 Monitored)"},{"$f":"Summary!E14","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B15","v":"Clerical Salaries"},{"$f":"Summary!E15","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B16","v":"SRO Salaries"},{"$f":"Summary!E16","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B17","v":"Fringe Benefits"},{"$f":"Summary!E17","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B18","v":"Tuition Waiver"},{"$f":"Summary!E18","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B19","v":"Consultants"},{"$f":"Summary!E19","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B20","v":"Respondents/Subjects"},{"$f":"Summary!E20","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B21","v":"Stipends"},{"$f":"Summary!E21","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B22","v":"Student Aid"},{"$f":"Summary!E22","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B23","v":"Patient Care"},{"$f":"Summary!E23","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B24","v":"General Supplies (A21 Monitored)"},{"$f":"Summary!E24","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B25","v":"Research Supplies & Services"},{"$f":"Summary!E25","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B26","v":"Data Processing"},{"$f":"Summary!E26","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B27","v":"Postage and Shipping (A21 Monitored)"},{"$f":"Summary!E27","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B28","v":"Telephone Services (A21 Monitored)"},{"$f":"Summary!E28","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B29","v":"Pass Through Under 25K"},{"$f":"Summary!E29","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B30","v":"Pass Through Over 25K"},{"$f":"Summary!E30","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B31","v":"Alt & Renovations"},{"$f":"Summary!E31","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B32","v":"Travel-Domestic"},{"$f":"Summary!E32","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B33","v":"Travel-Foreign"},{"$f":"Summary!E33","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B34","v":"Hosting (A21 Monitored)"},{"$f":"Summary!E34","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B35","v":"Equipment"},{"$f":"Summary!E35","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B36","v":"Computing Center"},{"$f":"Summary!E36","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B37","v":"ULAM"},{"$f":"Summary!E37","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B38","v":"Other Spec Svc Fac"},{"$f":"Summary!E38","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B39","v":"Unallocated"},{"$f":"Summary!E39","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B40","v":"Carryforward Pending"},{"$f":"Summary!E40","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B41","v":"Authorization Pending"},{"$f":"Summary!E41","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B42","v":"Non Sponsor Revenue"},{"$f":"Summary!E42","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B43","v":"Transfers"},{"$f":"Summary!E43","v":0},null,0,null,0,null,0,null,0,null,null,0]
[null,{"$f":"Summary!B44","v":"TOTAL DIRECT COSTS"},{"$f":"Summary!E44","v":0},null,{"$f":"SUM(E5:E35)","v":0},null,{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0},null,{"$f":"SUM(K5:K35)","v":0},null,null,0]
[]
[null,{"$f":"Summary!B46","v":"TOTAL INDIRECT COSTS"},{"$f":"Summary!E46","v":0},null,0,null,0,null,0,null,0,null,null,{"$f":"SUM(C38:K38)","v":0}]
[]
[null,"TOTAL BUDGET",{"$f":"Summary!E48","v":0},null,{"$f":"E38+E36","v":0},null,{"$f":"G38+G36","v":0},null,{"$f":"I38+I36","v":0},null,{"$f":"K38+K36","v":0},null,null,{"$f":"SUM(C40:K40)","v":0}]

{"sheet":"Exp Forecasting","index":4,"n_rows":89,"n_cols":48,"rows_kept":89,"cut":false,"hidden":false,"merged":[[85,19,85,20],[85,23,85,24],[85,27,85,28],[85,15,85,16],[10,1,10,11],[63,6,64,8],[2,7,2,8],[2,2,4,5],[1,2,1,3],[2,1,4,1],[3,13,3,28],[4,13,4,16],[4,17,4,20],[4,21,4,24],[4,25,4,28]]}
[]
[null,"P/G:","P/G Title:",null,null,null,null,"P/G End Date:"]
[null,{"$f":"'Appt Info DataDump'!B2","v":"PASTE HERE"},{"$f":"'Appt Info DataDump'!C2","v":0},null,null,null,null,{"$f":"'Appt Info DataDump'!D2","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Future Budget years may not necessary be year 2, 3, 4, or 5 when you do your forecast.  These are available to forecast the next budget year of your project. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Statement Balance as of last month closed",null,null,null,null,null,null,null,null,null,{"$f":"'Appt Info DataDump'!E2","v":0},null,null,null,"Year 2",null,null,null,"Year 3",null,null,null,"Year 4",null,null,null,"Year 5"]
[null,"Forecasting template prepared on:",null,{"$f":"NOW()","v":"2017-01-26T14:23:52.620"}]
[null,"M-Reports Encumbrances (enter #'s on the \"Encumbrances\" tab)",null,null,null,null,null,null,null,null,null,{"$f":"+Encumbrances!B38+Encumbrances!C38+Encumbrances!D38+Encumbrances!E38","v":0}]
[]
[null,"M-Reports Projected Balance:",null,null,null,null,null,null,null,null,null,{"$f":"L6-L8","v":0}]
[null,"Current Budget Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Increase",null,null,null,"% Increase",null,null,null,"% Increase",null,null,null,"% Increase"]
[null,"Additional Encumbrances:",null,null,{"$f":"+Summary!C8","v":"00:00:00"},"-",{"$f":"+Summary!E8","v":"00:00:00"},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Salary",null,null,"Monthly ","# of","Current","Current","NEW","New Monthly","Amount","Adj",null,"# of","New Monthly","NEW",null,"# of","New Monthly","NEW",null,"# of","New Monthly","NEW",null,"# of","New Monthly","NEW"]
[null,null,null,null,"Amount","Months","%Effort","%Dist","%Dist","Amount","Diff.","Amount",null,"Months","Amount","%Dist",null,"Months","Amount","%Dist",null,"Months","Amount","%Dist",null,"Months","Amount","%Dist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"'Appt Info DataDump'!H2","v":0},null,null,{"$f":"'Appt Info DataDump'!M2*H15","v":0},0,{"$f":"'Appt Info DataDump'!J2","v":0},{"$f":"'Appt Info DataDump'!K2","v":0},{"$f":"H15","v":0},{"$f":"'Appt Info DataDump'!M2*I15","v":0},{"$f":"J15-E15","v":0},{"$f":"K15*F15","v":0},null,12,{"$f":"'Appt Info DataDump'!M2*P15","v":0},{"$f":"H15","v":0},{"$f":"(O15*N15)*(1+($Q$12))","v":0},12,{"$f":"'Appt Info DataDump'!M2*T15","v":0},{"$f":"P15","v":0},{"$f":"((S15*R15)*(1+($U$12)))*(1+$Q$12)","v":0},12,{"$f":"'Appt Info DataDump'!M2*X15","v":0},{"$f":"T15","v":0},{"$f":"(((V15*W15)*(1+($U$12)))*(1+$Y$12))*(1+$Q$12)","v":0},12,{"$f":"'Appt Info DataDump'!M2*AB15","v":0},{"$f":"X15","v":0},{"$f":"((((Z15*AA15)*(1+($U$12)))*(1+($Y$12))*(1+($AC$12))))*(1+$Q$12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,{"$f":"'Appt Info DataDump'!H3","v":0},null,null,{"$f":"'Appt Info DataDump'!M3*H16","v":0},0,{"$f":"'Appt Info DataDump'!J3","v":0},{"$f":"'Appt Info DataDump'!K3","v":0},{"$f":"H16","v":0},{"$f":"'Appt Info DataDump'!M3*I16","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M3*P16","v":0},0,{"$f":"(O16*N16)*(1+($Q$12))","v":0},12,{"$f":"'Appt Info DataDump'!M3*T16","v":0},{"$f":"P16","v":0},0,12,{"$f":"'Appt Info DataDump'!M3*X16","v":0},{"$f":"T16","v":0},0,12,{"$f":"'Appt Info DataDump'!M3*AB16","v":0},{"$f":"X16","v":0},0]
[null,{"$f":"'Appt Info DataDump'!H4","v":0},null,null,{"$f":"'Appt Info DataDump'!M4*H17","v":0},0,{"$f":"'Appt Info DataDump'!J4","v":0},{"$f":"'Appt Info DataDump'!K4","v":0},0,{"$f":"'Appt Info DataDump'!M4*I17","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M4*P17","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M4*T17","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M4*X17","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M4*AB17","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,{"$f":"'Appt Info DataDump'!H5","v":0},null,null,{"$f":"'Appt Info DataDump'!M5*H18","v":0},0,{"$f":"'Appt Info DataDump'!J5","v":0},{"$f":"'Appt Info DataDump'!K5","v":0},0,{"$f":"'Appt Info DataDump'!M5*I18","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M5*P18","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M5*T18","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M5*X18","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M5*AB18","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,{"$f":"'Appt Info DataDump'!H6","v":0},null,null,{"$f":"'Appt Info DataDump'!M6*H19","v":0},0,{"$f":"'Appt Info DataDump'!J6","v":0},{"$f":"'Appt Info DataDump'!K6","v":0},0,{"$f":"'Appt Info DataDump'!M6*I19","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M6*P19","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M6*T19","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M6*X19","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M6*AB19","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H7","v":0},null,null,{"$f":"'Appt Info DataDump'!M7*H20","v":0},0,{"$f":"'Appt Info DataDump'!J7","v":0},{"$f":"'Appt Info DataDump'!K7","v":0},0,{"$f":"'Appt Info DataDump'!M7*I20","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M7*P20","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M7*T20","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M7*X20","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M7*AB20","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H8","v":0},null,null,{"$f":"'Appt Info DataDump'!M8*H21","v":0},0,{"$f":"'Appt Info DataDump'!J8","v":0},{"$f":"'Appt Info DataDump'!K8","v":0},0,{"$f":"'Appt Info DataDump'!M8*I21","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M8*P21","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M8*T21","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M8*X21","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M8*AB21","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H9","v":0},null,null,{"$f":"'Appt Info DataDump'!M9*H22","v":0},0,{"$f":"'Appt Info DataDump'!J9","v":0},{"$f":"'Appt Info DataDump'!K9","v":0},0,{"$f":"'Appt Info DataDump'!M9*I22","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M9*P22","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M9*T22","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M9*X22","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M9*AB22","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H10","v":0},null,null,{"$f":"'Appt Info DataDump'!M10*H23","v":0},0,{"$f":"'Appt Info DataDump'!J10","v":0},{"$f":"'Appt Info DataDump'!K10","v":0},0,{"$f":"'Appt Info DataDump'!M10*I23","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M10*P23","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M10*T23","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M10*X23","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M10*AB23","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H11","v":0},null,null,{"$f":"'Appt Info DataDump'!M11*H24","v":0},0,{"$f":"'Appt Info DataDump'!J11","v":0},{"$f":"'Appt Info DataDump'!K11","v":0},0,{"$f":"'Appt Info DataDump'!M11*I24","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M11*P24","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M11*T24","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M11*X24","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M11*AB24","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H12","v":0},null,null,{"$f":"'Appt Info DataDump'!M12*H25","v":0},0,{"$f":"'Appt Info DataDump'!J12","v":0},{"$f":"'Appt Info DataDump'!K12","v":0},0,{"$f":"'Appt Info DataDump'!M12*I25","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M12*P25","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M12*T25","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M12*X25","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M12*AB25","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H13","v":0},null,null,{"$f":"'Appt Info DataDump'!M13*H26","v":0},0,{"$f":"'Appt Info DataDump'!J13","v":0},{"$f":"'Appt Info DataDump'!K13","v":0},0,{"$f":"'Appt Info DataDump'!M13*I26","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M13*P26","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M13*T26","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M13*X26","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M13*AB26","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H14","v":0},null,null,{"$f":"'Appt Info DataDump'!M14*H27","v":0},0,{"$f":"'Appt Info DataDump'!J14","v":0},{"$f":"'Appt Info DataDump'!K14","v":0},0,{"$f":"'Appt Info DataDump'!M14*I27","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M14*P27","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M14*T27","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M14*X27","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M14*AB27","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H15","v":0},null,null,{"$f":"'Appt Info DataDump'!M15*H28","v":0},0,{"$f":"'Appt Info DataDump'!J15","v":0},{"$f":"'Appt Info DataDump'!K15","v":0},0,{"$f":"'Appt Info DataDump'!M15*I28","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M15*P28","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M15*T28","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M15*X28","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M15*AB28","v":0},0,0]
[null,{"$f":"'Appt Info DataDump'!H16","v":0},null,null,{"$f":"'Appt Info DataDump'!M16*H29","v":0},0,{"$f":"'Appt Info DataDump'!J16","v":0},{"$f":"'Appt Info DataDump'!K16","v":0},0,{"$f":"'Appt Info DataDump'!M16*I29","v":0},0,0,null,12,{"$f":"'Appt Info DataDump'!M16*P29","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M16*T29","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M16*X29","v":0},0,0,12,{"$f":"'Appt Info DataDump'!M16*AB29","v":0},0,0]
[null,"     Total Salaries",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L15:L29)","v":0},null,null,null,null,{"$f":"SUM(Q15:Q29)","v":0},null,null,null,{"$f":"SUM(U15:U29)","v":0},null,null,null,{"$f":"SUM(Y15:Y29)","v":0},null,null,null,{"$f":"SUM(AC15:AC29)","v":0}]
[]
[null,"Fringe Benefits"]
[null,{"$f":"B15","v":0},null,{"$f":"'Appt Info DataDump'!N2","v":0},null,null,null,null,null,null,null,{"$f":"L15*D33","v":0},null,null,null,null,{"$f":"Q15*D33","v":0},null,null,null,{"$f":"U15*D33","v":0},null,null,null,{"$f":"Y15*D33","v":0},null,null,null,{"$f":"AC15*D33","v":0}]
[null,0,null,{"$f":"'Appt Info DataDump'!N3","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N4","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N5","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N6","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N7","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N8","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N9","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N10","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N11","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N12","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N13","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N14","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N15","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,0,null,{"$f":"'Appt Info DataDump'!N16","v":0},null,null,null,null,null,null,null,0,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"Benefits Recharge Distribution",null,1.95E-2,null,null,null,null,null,null,null,{"$f":"+L30*D48","v":0},null,null,null,null,{"$f":"+Q30*$D$48","v":0},null,null,null,{"$f":"+U30*$D$48","v":0},null,null,null,{"$f":"+Y30*$D$48","v":0},null,null,null,{"$f":"+AC30*$D$48","v":0}]
[null,"     Total Fringe Benefits",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L33:L48)","v":0},null,null,null,null,{"$f":"SUM(Q33:Q48)","v":0},null,null,null,{"$f":"SUM(U33:U48)","v":0},null,null,null,{"$f":"SUM(Y33:Y48)","v":0},null,null,null,{"$f":"SUM(AC33:AC48)","v":0}]
[null,"     Total Personnel Costs",null,null,null,null,null,null,null,null,null,{"$f":"L30+L49","v":0},null,null,null,null,{"$f":"Q30+Q49","v":0},null,null,null,{"$f":"U30+U49","v":0},null,null,null,{"$f":"Y30+Y49","v":0},null,null,null,{"$f":"AC30+AC49","v":0}]
[]
[null,"Other Expenses  (enter #'s on the \"Other Expenses\" tab)"]
[null,"Consultants",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C7","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D7","v":0},null,null,null,{"$f":"+'Other Expenses'!E7","v":0},null,null,null,{"$f":"+'Other Expenses'!F7","v":0},null,null,null,{"$f":"+'Other Expenses'!G7","v":0}]
[null,"Respondents/Subjects",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C14","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D14","v":0},null,null,null,{"$f":"+'Other Expenses'!E14","v":0},null,null,null,{"$f":"+'Other Expenses'!F14","v":0},null,null,null,{"$f":"+'Other Expenses'!G14","v":0}]
[null,"Stipends",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C19","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D19","v":0},null,null,null,{"$f":"+'Other Expenses'!E19","v":0},null,null,null,{"$f":"+'Other Expenses'!F19","v":0},null,null,null,{"$f":"+'Other Expenses'!G19","v":0}]
[null,"Student Aid",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C24","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D24","v":0},null,null,null,{"$f":"+'Other Expenses'!E24","v":0},null,null,null,{"$f":"+'Other Expenses'!F24","v":0},null,null,null,{"$f":"+'Other Expenses'!G24","v":0}]
[null,"Patient Care",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C29","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D29","v":0},null,null,null,{"$f":"+'Other Expenses'!E29","v":0},null,null,null,{"$f":"+'Other Expenses'!F29","v":0},null,null,null,{"$f":"+'Other Expenses'!G29","v":0}]
[null,"General Supplies",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C37","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D37","v":0},null,null,null,{"$f":"+'Other Expenses'!E37","v":0},null,null,null,{"$f":"+'Other Expenses'!F37","v":0},null,null,null,{"$f":"+'Other Expenses'!G37","v":0}]
[null,"Research Supplies",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C44","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D44","v":0},null,null,null,{"$f":"+'Other Expenses'!E44","v":0},null,null,null,{"$f":"+'Other Expenses'!F44","v":0},null,null,null,{"$f":"+'Other Expenses'!G44","v":0}]
[null,"Data Processing",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C49","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D49","v":0},null,null,null,{"$f":"+'Other Expenses'!E49","v":0},null,null,null,{"$f":"+'Other Expenses'!F49","v":0},null,null,null,{"$f":"+'Other Expenses'!G49","v":0}]
[null,"Postage and Shipping",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C54","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D54","v":0},null,null,null,{"$f":"+'Other Expenses'!E54","v":0},null,null,null,{"$f":"+'Other Expenses'!F54","v":0},null,null,null,{"$f":"+'Other Expenses'!G54","v":0}]
[null,"Telephone Services",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C60","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D60","v":0},null,null,null,{"$f":"+'Other Expenses'!E60","v":0},null,null,null,{"$f":"+'Other Expenses'!F60","v":0},null,null,null,{"$f":"+'Other Expenses'!G60","v":0}]
[null,"Pass Through Under 25K",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C64","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D64","v":0},null,null,null,{"$f":"+'Other Expenses'!E64","v":0},null,null,null,{"$f":"+'Other Expenses'!F64","v":0},null,null,null,{"$f":"+'Other Expenses'!G64","v":0}]
[null,"Pass Through Over 25K",null,null,null,null,"Enter these #'s on the \"Other Expenses\" tab",null,null,null,null,{"$f":"+'Other Expenses'!C69","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D69","v":0},null,null,null,{"$f":"+'Other Expenses'!E69","v":0},null,null,null,{"$f":"+'Other Expenses'!F69","v":0},null,null,null,{"$f":"+'Other Expenses'!G69","v":0}]
[null,"Alt & Renovations",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C73","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D73","v":0},null,null,null,{"$f":"+'Other Expenses'!E73","v":0},null,null,null,{"$f":"+'Other Expenses'!F73","v":0},null,null,null,{"$f":"+'Other Expenses'!G73","v":0}]
[null,"Travel-Domestic",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C79","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D79","v":0},null,null,null,{"$f":"+'Other Expenses'!E79","v":0},null,null,null,{"$f":"+'Other Expenses'!F79","v":0},null,null,null,{"$f":"+'Other Expenses'!G79","v":0}]
[null,"Travel-Foreign",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C85","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D85","v":0},null,null,null,{"$f":"+'Other Expenses'!E85","v":0},null,null,null,{"$f":"+'Other Expenses'!F85","v":0},null,null,null,{"$f":"+'Other Expenses'!G85","v":0}]
[null,"Hosting",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C90","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D90","v":0},null,null,null,{"$f":"+'Other Expenses'!E90","v":0},null,null,null,{"$f":"+'Other Expenses'!F90","v":0},null,null,null,{"$f":"+'Other Expenses'!G90","v":0}]
[null,"Equipment",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C95","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D95","v":0},null,null,null,{"$f":"+'Other Expenses'!E95","v":0},null,null,null,{"$f":"+'Other Expenses'!F95","v":0},null,null,null,{"$f":"+'Other Expenses'!G95","v":0}]
[null,"Computing Center",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C100","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D100","v":0},null,null,null,{"$f":"+'Other Expenses'!E100","v":0},null,null,null,{"$f":"+'Other Expenses'!F100","v":0},null,null,null,{"$f":"+'Other Expenses'!G100","v":0}]
[null,"ULAM",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C106","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D106","v":0},null,null,null,{"$f":"+'Other Expenses'!E106","v":0},null,null,null,{"$f":"+'Other Expenses'!F106","v":0},null,null,null,{"$f":"+'Other Expenses'!G106","v":0}]
[null,"Other Spec Svc Fac",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C112","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D112","v":0},null,null,null,{"$f":"+'Other Expenses'!E112","v":0},null,null,null,{"$f":"+'Other Expenses'!F112","v":0},null,null,null,{"$f":"+'Other Expenses'!G112","v":0}]
[null,"Transfers",null,null,null,null,null,null,null,null,null,{"$f":"+'Other Expenses'!C116","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D116","v":0},null,null,null,{"$f":"+'Other Expenses'!E116","v":0},null,null,null,{"$f":"+'Other Expenses'!F116","v":0},null,null,null,{"$f":"+'Other Expenses'!G116","v":0}]
[]
[null,"Tuition - differential (3 terms)",null,null,null,null,null,null,null,"Fall",null,{"$f":"+'Other Expenses'!C119","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D119","v":0},null,null,null,{"$f":"+'Other Expenses'!E119","v":0},null,null,null,{"$f":"+'Other Expenses'!F119","v":0},null,null,null,{"$f":"+'Other Expenses'!G119","v":0}]
[null,null,null,null,null,null,null,null,null,"Winter",null,{"$f":"+'Other Expenses'!C120","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D120","v":0},null,null,null,{"$f":"+'Other Expenses'!E120","v":0},null,null,null,{"$f":"+'Other Expenses'!F120","v":0},null,null,null,{"$f":"+'Other Expenses'!G120","v":0}]
[null,null,null,null,null,null,null,null,null,"Sp/Su",null,{"$f":"+'Other Expenses'!C121","v":0},null,null,null,null,{"$f":"+'Other Expenses'!D121","v":0},null,null,null,{"$f":"+'Other Expenses'!E121","v":0},null,null,null,{"$f":"+'Other Expenses'!F121","v":0},null,null,null,{"$f":"+'Other Expenses'!G121","v":0}]
[]
[null,"     Total Direct Costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L50:L77)","v":0},null,null,null,null,{"$f":"SUM(Q50:Q77)","v":0},null,null,null,{"$f":"SUM(U50:U77)","v":0},null,null,null,{"$f":"SUM(Y50:Y77)","v":0},null,null,null,{"$f":"SUM(AC50:AC77)","v":0}]
[]
[null,"Indirect Costs",null,{"$f":"'Appt Info DataDump'!F2","v":0},null,null,null,null,null,null,null,{"$f":"(L50+L53+L54+L55+L56+L58+L59+L60+L61+L62+L63+L66+L67+L68+L70+L71+L72+L73)*D81","v":0},null,null,null,null,{"$f":"(Q50+Q53+Q54+Q55+Q56+Q58+Q59+Q60+Q61+Q62+Q63+Q66+Q67+Q68+Q70+Q71+Q72+Q73)*$D$81","v":0},{"$f":"(R50+R53+R54+R55+R56+R58+R59+R60+R61+R62+R63+R66+R67+R68+R70+R71+R72+R73)*$D$81","v":0},0,null,0,0,0,null,0,0,0,null,0]
[]
[null,"Total Additional Encumbrances:",null,null,null,null,null,null,null,null,null,{"$f":"L79+L81","v":0},null,null,null,null,{"$f":"Q79+Q81","v":0},null,null,null,{"$f":"U79+U81","v":0},null,null,null,{"$f":"Y79+Y81","v":0},null,null,null,{"$f":"AC79+AC81","v":0}]
[]
[]
[null,"Projected Balance:",null,null,null,null,null,null,null,null,null,{"$f":"L10-L83","v":0},null,null,null,{"$f":"(L86+'Addt''l Bdgt'!E40)-Q83","v":0},null,null,null,{"$f":"(P86+'Addt''l Bdgt'!G40)-U83","v":0},null,null,null,{"$f":"(T86+'Addt''l Bdgt'!I40)-Y83","v":0},null,null,null,{"$f":"(X86+'Addt''l Bdgt'!K40)-AC83","v":0}]
[]
[]
[null,null,null,"Comments:"]

{"sheet":"Other Expenses","index":5,"n_rows":121,"n_cols":7,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+Instructions!B32","v":"Use this tab to list any future non-salary or fb expenditures.  These would be for those categories listed on this tab."}]
[]
[null,null,"Current Budget Year",{"$f":"+'Exp Forecasting'!P6","v":"Year 2"},{"$f":"+'Exp Forecasting'!T6","v":"Year 3"},{"$f":"+'Exp Forecasting'!X6","v":"Year 4"},{"$f":"+'Exp Forecasting'!AB6","v":"Year 5"}]
["Consultants",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Consultants",{"$f":"SUM(C4:C6)","v":0},{"$f":"SUM(D4:D6)","v":0},0,0,0]
[]
["Respondents/Subjects",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Respondents/Subjects",{"$f":"SUM(C9:C13)","v":0},{"$f":"SUM(D9:D13)","v":0},0,0,0]
[]
["Stipends",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Stipends",{"$f":"SUM(C16:C18)","v":0},{"$f":"SUM(D16:D18)","v":0},0,0,0]
[]
["Student Aid",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Student Aid",{"$f":"SUM(C21:C23)","v":0},{"$f":"SUM(D21:D23)","v":0},0,0,0]
[]
["Patient Care",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Patient Care",{"$f":"SUM(C26:C28)","v":0},{"$f":"SUM(D26:D28)","v":0},0,0,0]
[]
["General Supplies",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL General Supplies",{"$f":"SUM(C31:C36)","v":0},{"$f":"SUM(D31:D36)","v":0},0,0,0]
[]
["Research Supplies",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Research Supplies",{"$f":"SUM(C39:C43)","v":0},{"$f":"SUM(D39:D43)","v":0},{"$f":"SUM(E39:E43)","v":0},{"$f":"SUM(F39:F43)","v":0},{"$f":"SUM(G39:G43)","v":0}]
[]
["Data Processing",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Data Processing",{"$f":"SUM(C46:C48)","v":0},{"$f":"SUM(D46:D48)","v":0},0,0,0]
[]
["Postage and Shipping",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Postage and Shipping",{"$f":"SUM(C51:C53)","v":0},{"$f":"SUM(D51:D53)","v":0},0,0,0]
[]
["Telephone Services",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Telephone Services",{"$f":"SUM(C56:C59)","v":0},{"$f":"SUM(D56:D59)","v":0},0,0,0]
[]
["Pass Through Under 25K",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Pass Through Under 25K",{"$f":"SUM(C62:C63)","v":0},{"$f":"SUM(D62:D63)","v":0},0,0,0]
[]
["Pass Through Over 25K"," ",0,0,0,0,0]
[null," ",0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Pass Through over 25K",{"$f":"SUM(C66:C68)","v":0},{"$f":"SUM(D66:D68)","v":0},0,0,0]
[]
["Alt & Renovations",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Alt & Renovations",{"$f":"SUM(C71:C72)","v":0},{"$f":"SUM(D71:D72)","v":0},0,0,0]
[]
["Travel-Domestic"," ",0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL  Travel-Domestic",{"$f":"SUM(C75:C78)","v":0},{"$f":"SUM(D75:D78)","v":0},0,0,0]
[]
["Travel-Foreign",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Travel-Foreign",{"$f":"SUM(C81:C84)","v":0},{"$f":"SUM(D81:D84)","v":0},0,0,0]
[]
["Hosting",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Hosting",{"$f":"SUM(C87:C89)","v":0},{"$f":"SUM(D87:D89)","v":0},0,0,0]
[]
[]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Equipment",{"$f":"SUM(C93:C94)","v":0},{"$f":"SUM(D93:D94)","v":0},0,0,0]
[]
["Computing Center",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Computing Center",{"$f":"SUM(C97:C99)","v":0},{"$f":"SUM(D97:D99)","v":0},0,0,0]
[]
["ULAM",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL ULAM",{"$f":"SUM(C102:C105)","v":0},{"$f":"SUM(D102:D105)","v":0},0,0,0]
[]
["Other Spec Svc Fac",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Other Spec Svc Fac",{"$f":"SUM(C108:C111)","v":0},{"$f":"SUM(D108:D111)","v":0},0,0,0]
[]
["Transfers",null,0,0,0,0,0]
[null,null,0,0,0,0,0]
[null,"TTL Transfers",{"$f":"SUM(C114:C115)","v":0},{"$f":"SUM(D114:D115)","v":0},0,0,0]
[]
["Tuition - differential (3 terms)"]
[null,"Fall",0,0,0,0,0]
[null,"Winter",0,0,0,0,0]
[null,"SP/SU",0,0,0,0,0]

{"sheet":"Appt Info DataDump","index":6,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Emplid:","Employee:","Shortcode"," current effort","current distribution","Comp Rt Dist:","Monthly Comp Rate","FB Rate ( .xx )","PI"]
[null,"PASTE HERE"]

{"sheet":"Budget Detail DataDump","index":7,"n_rows":108,"n_cols":41,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["NOTE:  Paste Business Objects Query results in outlined area"]
["Use to paste budget amounts as of last DW refresh"]
["Query file location:    C:\\Public\\Reports\\FSR.rep (Use the FSR Budget Data Tab)",null,null,null,null,null,"RschSal","AdmnSal","ClrcSal","DSTSal","FB","TuitWvr","Consult","Rsp/Sbj","Stipend","StdtAid","PtCare","GenSup","RschSup","DataPrc","Postage","Telepho","PT<25K","PT>25K","Alt&Ren","TrvlDms","TrvlFrg","TrvlTrn","Hosting","Equip","Trsf","CompCtr","ULAM","OSSFac","I/C","CF  pending","Auth. Pending","Non-Spon Revenue","Unallocated","CNVPPD","Sub"]
[{"$f":"IF(AND($B108=\"\",$C108=\"\"),\" \",\"***TOO MANY ROWS DUMPED!  Please UNDO and add more rows.\")","v":" "},null,null,null,null,null,911000,911100,911200,911250,911300,911400,911500,911550,911600,911650,911700,911800,911900,911950,912000,912100,912200,912300,912400,912500,912550,912580,912590,912600,912700,912800,912900,913000,913400,999995,999996,999997,999999,"CNVPPD","Check"]
[null,"PASTE HERE",null,null,null,null,{"$f":"IF($B8=\"\",\"\",IF(G$7=$D8,$E8,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF($B8=\"\",\"\",IF(W$7=$D8,$E8,\"\"))","v":""},"","","","","","","","","","","","","","",null,{"$f":"IF($B8=\"\",\"\",IF(OR(AM$7=$D8,$D8=999998),$E8,\"\"))","v":""},"",{"$f":"IF(OR($B8=\"\",$B8='[1]Data Sheet'!$E$31),0,1)","v":1}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B9=\"\",$B9='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","",{"$f":"IF($B10=\"\",\"\",IF(Z$7=$D10,$E10,\"\"))","v":""},"","","","","","","","","","","",null,"","",{"$f":"IF(OR($B10=\"\",$B10='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B11=\"\",$B11='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B12=\"\",$B12='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B13=\"\",$B13='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B14=\"\",$B14='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B15=\"\",$B15='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B16=\"\",$B16='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B17=\"\",$B17='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B18=\"\",\"\",IF(G$7=$D18,$E18,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B18=\"\",$B18='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B19=\"\",$B19='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B20=\"\",$B20='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B21=\"\",$B21='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B22=\"\",$B22='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","",{"$f":"IF($B23=\"\",\"\",IF(V$7=$D23,$E23,\"\"))","v":""},"","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B23=\"\",$B23='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B24=\"\",\"\",IF(G$7=$D24,$E24,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF($B24=\"\",\"\",IF(W$7=$D24,$E24,\"\"))","v":""},"","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B24=\"\",$B24='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B25=\"\",$B25='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B26=\"\",$B26='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B27=\"\",$B27='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B28=\"\",$B28='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B29=\"\",$B29='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B30=\"\",$B30='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B31=\"\",$B31='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B32=\"\",$B32='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B33=\"\",$B33='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B34=\"\",$B34='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B35=\"\",$B35='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B36=\"\",$B36='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B37=\"\",$B37='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B38=\"\",$B38='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","",{"$f":"IF($B39=\"\",\"\",IF(V$7=$D39,$E39,\"\"))","v":""},"","","","","","","","","","","","","","",{"$f":"IF($B39=\"\",\"\",IF(AK$7=$D39,$E39,\"\"))","v":""},null,"","",{"$f":"IF(OR($B39=\"\",$B39='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B40=\"\",\"\",IF(G$7=$D40,$E40,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF($B40=\"\",\"\",IF(W$7=$D40,$E40,\"\"))","v":""},"","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B40=\"\",$B40='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B41=\"\",$B41='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B42=\"\",$B42='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B43=\"\",$B43='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B44=\"\",$B44='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B45=\"\",$B45='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B46=\"\",$B46='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B47=\"\",$B47='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B48=\"\",$B48='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B49=\"\",$B49='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B50=\"\",$B50='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B51=\"\",$B51='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B52=\"\",$B52='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B53=\"\",$B53='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B54=\"\",$B54='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","",{"$f":"IF($B55=\"\",\"\",IF(V$7=$D55,$E55,\"\"))","v":""},"","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B55=\"\",$B55='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B56=\"\",\"\",IF(G$7=$D56,$E56,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF($B56=\"\",\"\",IF(W$7=$D56,$E56,\"\"))","v":""},"","","","","","","","","","","","","","",null,"",{"$f":"IF($B56=\"\",\"\",IF(AN$7=$D56,$E56,\"\"))","v":""},{"$f":"IF(OR($B56=\"\",$B56='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B57=\"\",$B57='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B58=\"\",$B58='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B59=\"\",$B59='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B60=\"\",$B60='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B61=\"\",$B61='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B62=\"\",$B62='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B63=\"\",$B63='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B64=\"\",$B64='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B65=\"\",$B65='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B66=\"\",$B66='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B67=\"\",$B67='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B68=\"\",$B68='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B69=\"\",$B69='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B70=\"\",$B70='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","",{"$f":"IF($B71=\"\",\"\",IF(V$7=$D71,$E71,\"\"))","v":""},"","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B71=\"\",$B71='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B72=\"\",\"\",IF(G$7=$D72,$E72,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF($B72=\"\",\"\",IF(W$7=$D72,$E72,\"\"))","v":""},"","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B72=\"\",$B72='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B73=\"\",$B73='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B74=\"\",$B74='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B75=\"\",$B75='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B76=\"\",$B76='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B77=\"\",$B77='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B78=\"\",\"\",IF(G$7=$D78,$E78,\"\"))","v":""},{"$f":"IF($B78=\"\",\"\",IF(H$7=$D78,$E78,\"\"))","v":""},{"$f":"IF($B78=\"\",\"\",IF(I$7=$D78,$E78,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B78=\"\",$B78='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B79=\"\",$B79='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B80=\"\",$B80='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B81=\"\",$B81='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B82=\"\",$B82='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B83=\"\",$B83='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B84=\"\",$B84='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B85=\"\",$B85='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B86=\"\",$B86='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B87=\"\",$B87='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B88=\"\",\"\",IF(G$7=$D88,$E88,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF($B88=\"\",\"\",IF(W$7=$D88,$E88,\"\"))","v":""},"","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B88=\"\",$B88='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B89=\"\",$B89='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B90=\"\",$B90='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B91=\"\",$B91='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B92=\"\",$B92='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B93=\"\",$B93='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B94=\"\",$B94='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B95=\"\",$B95='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B96=\"\",$B96='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B97=\"\",$B97='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B98=\"\",$B98='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B99=\"\",$B99='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B100=\"\",$B100='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B101=\"\",$B101='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"","",{"$f":"IF(OR($B102=\"\",$B102='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","",{"$f":"IF($B103=\"\",\"\",IF(V$7=$D103,$E103,\"\"))","v":""},"","","","","","","","","","","","","","","",null,"",{"$f":"IF($B103=\"\",\"\",IF(AN$7=$D103,$E103,\"\"))","v":""},{"$f":"IF(OR($B103=\"\",$B103='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"IF($B104=\"\",\"\",IF(G$7=$D104,$E104,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",{"$f":"IF($B104=\"\",\"\",IF(AN$7=$D104,$E104,\"\"))","v":""},{"$f":"IF(OR($B104=\"\",$B104='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",{"$f":"IF($B105=\"\",\"\",IF(AN$7=$D105,$E105,\"\"))","v":""},{"$f":"IF(OR($B105=\"\",$B105='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,"",{"$f":"IF($B106=\"\",\"\",IF(AN$7=$D106,$E106,\"\"))","v":""},{"$f":"IF(OR($B106=\"\",$B106='[1]Data Sheet'!$E$31),0,1)","v":0}]
[null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($B107=\"\",\"\",IF(AG$7=$D107,$E107,\"\"))","v":""},"","","","",null,"",{"$f":"IF($B107=\"\",\"\",IF(AN$7=$D107,$E107,\"\"))","v":""},{"$f":"IF(OR($B107=\"\",$B107='[1]Data Sheet'!$E$31),0,1)","v":0}]
["zzzz",null,null,null,null,null,{"$f":"SUM(G8:G107)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]

{"sheet":"Expense Detail DataDump","index":8,"n_rows":1008,"n_cols":39,"rows_kept":1008,"cut":false,"hidden":false,"merged":[]}
[]
[]
["NOTE:  Paste Business Objects Query in outlined area"]
["Use to paste Expense Summary info from 07/01/98 through the last month of the report period"]
["Query file location:    C:\\Public\\Reports\\FSR.rep (Use the FSR Exp Sum Tab)"]
[{"$f":"IF($B1008=\"\",\" \",\"***TOO MANY ROWS DUMPED!  Please UNDO and add more rows.\")","v":" "},null,null,null,null,null,"RschSal","AdmnSal","ClrcSal","DSTSal","FB","TuitWvr","Consult","Rsp/Sbj","Stipend","StdtAid","PtCare","GenSup","RschSup","DataPrc","Postage","Telepho","SC<25K","SC>25K","Alt&Ren","TrvlDms","TrvlFrg","Hosting","Equip","Trsf","CompCtr","ULAM","OSSFac","I/C","Fabrication","Lump Sum","Sub","Fabrication","GSRA"]
[null,null,null,null,null,null,911000,911100,911200,911250,911300,911400,911500,911550,911600,911650,911700,911800,911900,911950,912000,912100,912200,912300,912400,912500,912550,912590,912600,912700,912800,912900,913000,913400,"Check","Check","Check","Amount","Check"]
[null,"PASTE HERE",null,null,null,{"$f":"IF(OR(B8=\"\",B8=\"paste here\"),\" \",VLOOKUP(C8,account,11))","v":" "},{"$f":"IF(F8=\"\",\"\",IF(F8=$G$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$H$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$I$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$J$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$K$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$L$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$M$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$N$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$O$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$P$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$Q$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$R$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$S$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$T$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$U$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$V$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$W$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$X$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$Y$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$Z$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AA$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AB$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AC$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AD$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AE$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AF$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AG$7,D8,\"\"))","v":""},{"$f":"IF(F8=\"\",\"\",IF(F8=$AH$7,D8,\"\"))","v":""},{"$f":"IF(C8=614060,1,0)","v":0},{"$f":"IF(AND(C8=615561,D8<>0),1,0)","v":0},{"$f":"IF(OR($B8=\"\",$B8=\"Paste Here\",$B8='[1]Data Sheet'!$E$31),0,1)","v":0},{"$f":"IF(AI8>0,D8,0)","v":0},{"$f":"IF(C8=508300,1,0)","v":0}]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,{"$f":"IF(AND(C9=615561,D9<>0),1,0)","v":0},{"$f":"IF(OR($B9=\"\",$B9='[1]Data Sheet'!$E$31),0,1)","v":0},{"$f":"IF(AI9>0,D9,0)","v":0},{"$f":"IF(C9=508300,1,0)","v":0}]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B10=\"\",$B10='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B11=\"\",$B11='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B12=\"\",$B12='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B13=\"\",$B13='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B14=\"\",$B14='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B15=\"\",$B15='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B16=\"\",$B16='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B17=\"\",$B17='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B18=\"\",$B18='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B19=\"\",$B19='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B20=\"\",$B20='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B21=\"\",$B21='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B22=\"\",$B22='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B23=\"\",$B23='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B24=\"\",$B24='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B25=\"\",$B25='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B26=\"\",$B26='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B27=\"\",$B27='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B28=\"\",$B28='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B29=\"\",$B29='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B30=\"\",$B30='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B31=\"\",$B31='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B32=\"\",$B32='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B33=\"\",$B33='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B34=\"\",$B34='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B35=\"\",$B35='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B36=\"\",$B36='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B37=\"\",$B37='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B38=\"\",$B38='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B39=\"\",$B39='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B40=\"\",$B40='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B41=\"\",$B41='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B42=\"\",$B42='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B43=\"\",$B43='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B44=\"\",$B44='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B45=\"\",$B45='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B46=\"\",$B46='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B47=\"\",$B47='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B48=\"\",$B48='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B49=\"\",$B49='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B50=\"\",$B50='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B51=\"\",$B51='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B52=\"\",$B52='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B53=\"\",$B53='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B54=\"\",$B54='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B55=\"\",$B55='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B56=\"\",$B56='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B57=\"\",$B57='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B58=\"\",$B58='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B59=\"\",$B59='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B60=\"\",$B60='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(OR(B61=\"\",B61=\"paste here\"),\" \",VLOOKUP(C61,account,11))","v":" "},{"$f":"IF(F61=\"\",\"\",IF(F61=$G$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$H$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$I$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$J$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$K$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$L$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$M$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$N$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$O$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$P$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$Q$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$R$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$S$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$T$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$U$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$V$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$W$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$X$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$Y$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$Z$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AA$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AB$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AC$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AD$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AE$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AF$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AG$7,D61,\"\"))","v":""},{"$f":"IF(F61=\"\",\"\",IF(F61=$AH$7,D61,\"\"))","v":""},0,0,{"$f":"IF(OR($B61=\"\",$B61='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(OR(B62=\"\",B62=\"paste here\"),\" \",VLOOKUP(C62,account,11))","v":" "},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B62=\"\",$B62='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B63=\"\",$B63='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B64=\"\",$B64='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B65=\"\",$B65='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B66=\"\",$B66='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B67=\"\",$B67='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B68=\"\",$B68='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B69=\"\",$B69='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B70=\"\",$B70='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B71=\"\",$B71='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(C72=614060,1,0)","v":0},0,{"$f":"IF(OR($B72=\"\",$B72='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ",{"$f":"IF(F73=\"\",\"\",IF(F73=$G$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$H$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$I$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$J$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$K$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$L$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$M$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$N$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$O$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$P$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$Q$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$R$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$S$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$T$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$U$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$V$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$W$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$X$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$Y$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$Z$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AA$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AB$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AC$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AD$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AE$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AF$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AG$7,D73,\"\"))","v":""},{"$f":"IF(F73=\"\",\"\",IF(F73=$AH$7,D73,\"\"))","v":""},0,{"$f":"IF(AND(C73=615561,D73<>0),1,0)","v":0},{"$f":"IF(OR($B73=\"\",$B73='[1]Data Sheet'!$E$31),0,1)","v":0},{"$f":"IF(AI73>0,D73,0)","v":0},{"$f":"IF(C73=508300,1,0)","v":0}]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B74=\"\",$B74='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B75=\"\",$B75='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B76=\"\",$B76='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B77=\"\",$B77='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B78=\"\",$B78='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B79=\"\",$B79='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B80=\"\",$B80='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B81=\"\",$B81='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B82=\"\",$B82='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B83=\"\",$B83='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B84=\"\",$B84='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B85=\"\",$B85='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B86=\"\",$B86='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B87=\"\",$B87='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B88=\"\",$B88='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B89=\"\",$B89='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B90=\"\",$B90='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B91=\"\",$B91='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B92=\"\",$B92='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B93=\"\",$B93='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B94=\"\",$B94='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B95=\"\",$B95='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B96=\"\",$B96='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B97=\"\",$B97='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B98=\"\",$B98='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B99=\"\",$B99='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B100=\"\",$B100='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B101=\"\",$B101='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(OR(B102=\"\",B102=\"paste here\"),\" \",VLOOKUP(C102,account,11))","v":" "},{"$f":"IF(F102=\"\",\"\",IF(F102=$G$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$H$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$I$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$J$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$K$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$L$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$M$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$N$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$O$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$P$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$Q$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$R$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$S$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$T$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$U$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$V$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$W$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$X$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$Y$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$Z$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AA$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AB$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AC$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AD$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AE$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AF$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AG$7,D102,\"\"))","v":""},{"$f":"IF(F102=\"\",\"\",IF(F102=$AH$7,D102,\"\"))","v":""},{"$f":"IF(C102=614060,1,0)","v":0},0,{"$f":"IF(OR($B102=\"\",$B102='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(OR(B103=\"\",B103=\"paste here\"),\" \",VLOOKUP(C103,account,11))","v":" "},{"$f":"IF(F103=\"\",\"\",IF(F103=$G$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$H$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$I$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$J$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$K$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$L$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$M$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$N$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$O$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$P$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$Q$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$R$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$S$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$T$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$U$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$V$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$W$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$X$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$Y$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$Z$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AA$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AB$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AC$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AD$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AE$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AF$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AG$7,D103,\"\"))","v":""},{"$f":"IF(F103=\"\",\"\",IF(F103=$AH$7,D103,\"\"))","v":""},{"$f":"IF(C103=614060,1,0)","v":0},0,{"$f":"IF(OR($B103=\"\",$B103='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B104=\"\",$B104='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B105=\"\",$B105='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B106=\"\",$B106='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B107=\"\",$B107='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B108=\"\",$B108='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B109=\"\",$B109='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B110=\"\",$B110='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B111=\"\",$B111='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B112=\"\",$B112='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B113=\"\",$B113='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B114=\"\",$B114='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B115=\"\",$B115='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B116=\"\",$B116='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B117=\"\",$B117='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B118=\"\",$B118='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B119=\"\",$B119='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B120=\"\",$B120='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B121=\"\",$B121='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B122=\"\",$B122='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B123=\"\",$B123='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B124=\"\",$B124='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B125=\"\",$B125='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B126=\"\",$B126='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B127=\"\",$B127='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B128=\"\",$B128='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B129=\"\",$B129='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B130=\"\",$B130='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B131=\"\",$B131='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B132=\"\",$B132='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B133=\"\",$B133='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B134=\"\",$B134='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B135=\"\",$B135='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B136=\"\",$B136='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,{"$f":"IF(AND(C137=615561,D137<>0),1,0)","v":0},{"$f":"IF(OR($B137=\"\",$B137='[1]Data Sheet'!$E$31),0,1)","v":0},{"$f":"IF(AI137>0,D137,0)","v":0},{"$f":"IF(C137=508300,1,0)","v":0}]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B138=\"\",$B138='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B139=\"\",$B139='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B140=\"\",$B140='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B141=\"\",$B141='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B142=\"\",$B142='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B143=\"\",$B143='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B144=\"\",$B144='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B145=\"\",$B145='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B146=\"\",$B146='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B147=\"\",$B147='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B148=\"\",$B148='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B149=\"\",$B149='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B150=\"\",$B150='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B151=\"\",$B151='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B152=\"\",$B152='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B153=\"\",$B153='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B154=\"\",$B154='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B155=\"\",$B155='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B156=\"\",$B156='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B157=\"\",$B157='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B158=\"\",$B158='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B159=\"\",$B159='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B160=\"\",$B160='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B161=\"\",$B161='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B162=\"\",$B162='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B163=\"\",$B163='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B164=\"\",$B164='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B165=\"\",$B165='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B166=\"\",$B166='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(OR(B167=\"\",B167=\"paste here\"),\" \",VLOOKUP(C167,account,11))","v":" "},{"$f":"IF(F167=\"\",\"\",IF(F167=$G$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$H$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$I$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$J$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$K$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$L$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$M$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$N$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$O$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$P$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$Q$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$R$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$S$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$T$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$U$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$V$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$W$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$X$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$Y$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$Z$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AA$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AB$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AC$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AD$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AE$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AF$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AG$7,D167,\"\"))","v":""},{"$f":"IF(F167=\"\",\"\",IF(F167=$AH$7,D167,\"\"))","v":""},{"$f":"IF(C167=614060,1,0)","v":0},0,{"$f":"IF(OR($B167=\"\",$B167='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B168=\"\",$B168='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B169=\"\",$B169='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B170=\"\",$B170='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B171=\"\",$B171='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B172=\"\",$B172='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B173=\"\",$B173='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B174=\"\",$B174='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B175=\"\",$B175='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B176=\"\",$B176='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B177=\"\",$B177='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B178=\"\",$B178='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B179=\"\",$B179='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B180=\"\",$B180='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B181=\"\",$B181='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B182=\"\",$B182='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B183=\"\",$B183='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B184=\"\",$B184='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B185=\"\",$B185='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B186=\"\",$B186='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B187=\"\",$B187='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B188=\"\",$B188='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B189=\"\",$B189='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B190=\"\",$B190='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B191=\"\",$B191='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B192=\"\",$B192='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B193=\"\",$B193='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B194=\"\",$B194='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B195=\"\",$B195='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B196=\"\",$B196='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B197=\"\",$B197='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B198=\"\",$B198='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(OR(B199=\"\",B199=\"paste here\"),\" \",VLOOKUP(C199,account,11))","v":" "},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B199=\"\",$B199='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B200=\"\",$B200='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,{"$f":"IF(AND(C201=615561,D201<>0),1,0)","v":0},{"$f":"IF(OR($B201=\"\",$B201='[1]Data Sheet'!$E$31),0,1)","v":0},{"$f":"IF(AI201>0,D201,0)","v":0},{"$f":"IF(C201=508300,1,0)","v":0}]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B202=\"\",$B202='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B203=\"\",$B203='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B204=\"\",$B204='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B205=\"\",$B205='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B206=\"\",$B206='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B207=\"\",$B207='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B208=\"\",$B208='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B209=\"\",$B209='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B210=\"\",$B210='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B211=\"\",$B211='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B212=\"\",$B212='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B937=\"\",$B937='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B938=\"\",$B938='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B939=\"\",$B939='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B940=\"\",$B940='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B941=\"\",$B941='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B942=\"\",$B942='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B943=\"\",$B943='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B944=\"\",$B944='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B959=\"\",$B959='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B960=\"\",$B960='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B969=\"\",$B969='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B970=\"\",$B970='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B971=\"\",$B971='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B972=\"\",$B972='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B973=\"\",$B973='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[]
[]
[]
[]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B978=\"\",$B978='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B979=\"\",$B979='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B980=\"\",$B980='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(OR(B981=\"\",B981=\"paste here\"),\" \",VLOOKUP(C981,account,11))","v":" "},{"$f":"IF(F981=\"\",\"\",IF(F981=$G$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$H$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$I$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$J$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$K$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$L$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$M$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$N$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$O$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$P$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$Q$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$R$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$S$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$T$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$U$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$V$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$W$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$X$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$Y$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$Z$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AA$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AB$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AC$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AD$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AE$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AF$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AG$7,D981,\"\"))","v":""},{"$f":"IF(F981=\"\",\"\",IF(F981=$AH$7,D981,\"\"))","v":""},{"$f":"IF(C981=614060,1,0)","v":0},0,{"$f":"IF(OR($B981=\"\",$B981='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B982=\"\",$B982='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B983=\"\",$B983='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B984=\"\",$B984='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B985=\"\",$B985='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B986=\"\",$B986='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B987=\"\",$B987='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B988=\"\",$B988='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B989=\"\",$B989='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B990=\"\",$B990='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B991=\"\",$B991='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B992=\"\",$B992='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B993=\"\",$B993='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B994=\"\",$B994='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B995=\"\",$B995='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B996=\"\",$B996='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B997=\"\",$B997='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B998=\"\",$B998='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B999=\"\",$B999='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B1000=\"\",$B1000='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B1001=\"\",$B1001='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0,0,{"$f":"IF(OR($B1002=\"\",$B1002='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ",{"$f":"IF(F1003=\"\",\"\",IF(F1003=$G$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$H$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$I$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$J$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$K$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$L$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$M$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$N$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$O$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$P$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$Q$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$R$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$S$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$T$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$U$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$V$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$W$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$X$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$Y$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$Z$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AA$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AB$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AC$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AD$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AE$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AF$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AG$7,D1003,\"\"))","v":""},{"$f":"IF(F1003=\"\",\"\",IF(F1003=$AH$7,D1003,\"\"))","v":""},{"$f":"IF(C1003=614060,1,0)","v":0},0,{"$f":"IF(OR($B1003=\"\",$B1003='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ",{"$f":"IF(F1004=\"\",\"\",IF(F1004=$G$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$H$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$I$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$J$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$K$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$L$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$M$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$N$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$O$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$P$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$Q$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$R$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$S$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$T$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$U$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$V$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$W$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$X$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$Y$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$Z$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AA$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AB$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AC$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AD$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AE$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AF$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AG$7,D1004,\"\"))","v":""},{"$f":"IF(F1004=\"\",\"\",IF(F1004=$AH$7,D1004,\"\"))","v":""},{"$f":"IF(C1004=614060,1,0)","v":0},0,{"$f":"IF(OR($B1004=\"\",$B1004='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ",{"$f":"IF(F1005=\"\",\"\",IF(F1005=$G$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$H$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$I$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$J$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$K$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$L$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$M$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$N$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$O$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$P$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$Q$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$R$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$S$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$T$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$U$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$V$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$W$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$X$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$Y$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$Z$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AA$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AB$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AC$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AD$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AE$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AF$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AG$7,D1005,\"\"))","v":""},{"$f":"IF(F1005=\"\",\"\",IF(F1005=$AH$7,D1005,\"\"))","v":""},{"$f":"IF(C1005=614060,1,0)","v":0},0,{"$f":"IF(OR($B1005=\"\",$B1005='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ",{"$f":"IF(F1006=\"\",\"\",IF(F1006=$G$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$H$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$I$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$J$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$K$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$L$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$M$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$N$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$O$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$P$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$Q$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$R$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$S$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$T$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$U$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$V$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$W$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$X$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$Y$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$Z$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AA$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AB$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AC$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AD$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AE$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AF$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AG$7,D1006,\"\"))","v":""},{"$f":"IF(F1006=\"\",\"\",IF(F1006=$AH$7,D1006,\"\"))","v":""},{"$f":"IF(C1006=614060,1,0)","v":0},0,{"$f":"IF(OR($B1006=\"\",$B1006='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
[null,null,null,null,null," ",{"$f":"IF(F1007=\"\",\"\",IF(F1007=$G$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$H$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$I$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$J$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$K$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$L$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$M$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$N$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$O$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$P$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$Q$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$R$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$S$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$T$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$U$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$V$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$W$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$X$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$Y$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$Z$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AA$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AB$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AC$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AD$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AE$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AF$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AG$7,D1007,\"\"))","v":""},{"$f":"IF(F1007=\"\",\"\",IF(F1007=$AH$7,D1007,\"\"))","v":""},{"$f":"IF(C1007=614060,1,0)","v":0},0,{"$f":"IF(OR($B1007=\"\",$B1007='[1]Data Sheet'!$E$31),0,1)","v":0},0,0]
["zzzz",null,"Lump Sum",{"$f":"SUMIF(C8:C1007,\"=615561\",D8:D1007)","v":0},null,"Totals",{"$f":"SUM(G8:G1007)","v":0},{"$f":"SUM(H8:H1007)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AL8:AL1007)","v":0},{"$f":"SUM(AM8:AM1007)","v":0}]