{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Salary Calculator","Salary Shortfall Calculator","Academic","A-DATA","Professional","P-DATA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Salary Calculator","index":0,"n_rows":66,"n_cols":22,"rows_kept":66,"cut":false,"hidden":false,"merged":[[32,1,33,5]]}
[]
[]
[]
[]
[]
[]
[]
["STEP 1 - ","Will the Researcher be Professional Staff (e.g. Research Assistant, ",null,null,null,null,null,"Academic"]
[null,"Project Officer) or Academic Staff (e.g. Postdoctoral Fellow) ?",null,null,null,null,null,"Professional"]
[]
["STEP 2 - ","Select the Level & Step at which the Researcher will",null,null,null,"Level:"]
[null,"commence:",null,null,null,"Step:"]
[null,null,null,null,null,null,{"$f":"IF(G8=\"Academic\",VLOOKUP(CONCATENATE('Salary Calculator'!$G$11,'Salary Calculator'!$G$12),'A-DATA'!A2:B20,2,FALSE),IF(G8=\"Professional\",VLOOKUP((G11*10)+G12,'P-DATA'!A2:B21,2,FALSE),\"\"))","v":""}]
[]
["STEP 3 - ","Enter the start year for the Researcher:"]
[]
[]
["STEP 4 - ","Enter how many calendar years will the Researcher be employed:"]
[]
[]
["STEP 5 - ","Select the FTE in each year in the table below:"]
[]
[null,"Year","Level / Step","Select FTE…\n¯ ¯ ¯","Salary + 30%\non-costs"]
[null,2022,{"$f":"IF(AND($G$15+$G$18-A39>0,A39>=$G$15,$G$8=\"Academic\"),VLOOKUP(V39,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A39>0,A39>=$G$15,$G$8=\"Professional\"),VLOOKUP(V39,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D24=0,\"\",HLOOKUP(D24,$B$38:$T$45,2,FALSE))","v":""}]
[null,2023,{"$f":"IF(AND($G$15+$G$18-A40>0,A40>=$G$15,$G$8=\"Academic\"),VLOOKUP(V40,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A40>0,A40>=$G$15,$G$8=\"Professional\"),VLOOKUP(V40,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D25=0,\"\",HLOOKUP(D25,$B$38:$T$45,3,FALSE))","v":""}]
[null,2024,{"$f":"IF(AND($G$15+$G$18-A41>0,A41>=$G$15,$G$8=\"Academic\"),VLOOKUP(V41,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A41>0,A41>=$G$15,$G$8=\"Professional\"),VLOOKUP(V41,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D26=0,\"\",HLOOKUP(D26,$B$38:$T$45,4,FALSE))","v":""}]
[null,2025,{"$f":"IF(AND($G$15+$G$18-A42>0,A42>=$G$15,$G$8=\"Academic\"),VLOOKUP(V42,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A42>0,A42>=$G$15,$G$8=\"Professional\"),VLOOKUP(V42,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D27=0,\"\",HLOOKUP(D27,$B$38:$T$45,5,FALSE))","v":""}]
[null,2026,{"$f":"IF(AND($G$15+$G$18-A43>0,A43>=$G$15,$G$8=\"Academic\"),VLOOKUP(V43,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A43>0,A43>=$G$15,$G$8=\"Professional\"),VLOOKUP(V43,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D28=0,\"\",HLOOKUP(D28,$B$38:$T$45,6,FALSE))","v":""}]
[null,2027,{"$f":"IF(AND($G$15+$G$18-A44>0,A44>=$G$15,$G$8=\"Academic\"),VLOOKUP(V44,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A44>0,A44>=$G$15,$G$8=\"Professional\"),VLOOKUP(V44,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D29=0,\"\",HLOOKUP(D29,$B$38:$T$45,7,FALSE))","v":""}]
[null,2028,{"$f":"IF(AND($G$15+$G$18-A45>0,A45>=$G$15,$G$8=\"Academic\"),VLOOKUP(V45,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A45>0,A45>=$G$15,$G$8=\"Professional\"),VLOOKUP(V45,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D30=0,\"\",HLOOKUP(D30,$B$38:$T$45,8,FALSE))","v":""}]
[null,null,null,"TOTAL",{"$f":"SUM(E24:E30)","v":0}]
[]
["PLEASE NOTE:","* The figures calculated by this tool are to assist you in prepaing Research Grant applications only.\n* This tool can be used to estimate in-kind contributions of UOW staff and estimate the cost of employing staff at UOW on research projects.\n* The figures include a nominal yearly % increase and are therefore projected estimates only.\n* They do not represent Union or UOW Management proposals for future EBAs."]
[]
[]
[]
["days per week",5,4.75,4.5,4.25,4,3.75,3.5,3.25,3,2.75,2.5,2.25,2,1.75,1.5,1.25,1,0.75,0.5]
["FTE",1,0.95,0.9,0.85,0.8,0.75,0.7,0.65,0.6,0.55000000000000004,0.5,0.45,0.4,0.35,0.3,0.25,0.2,0.15,0.1]
[2022,{"$f":"IF(ISBLANK(D24),\"\",IF(AND($G$15+$G$18-A39>0,A39>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V39,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A40,VLOOKUP(V40,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A41,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(2),TRUE))))))),IF(AND($G$15+$G$18-A39>0,A39>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V39,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A40,VLOOKUP(V40,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A41,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(2),TRUE),\"\")))))),\"\")))","v":""},{"$f":"IF(ISERROR($B39*$C$38),\"\",$B39*$C$38)","v":""},{"$f":"IF(ISERROR($B39*$D$38),\"\",$B39*$D$38)","v":""},{"$f":"IF(ISERROR($B39*$E$38),\"\",$B39*$E$38)","v":""},{"$f":"IF(ISERROR($B39*$F$38),\"\",$B39*$F$38)","v":""},{"$f":"IF(ISERROR($B39*$G$38),\"\",$B39*$G$38)","v":""},{"$f":"IF(ISERROR($B39*$H$38),\"\",$B39*$H$38)","v":""},{"$f":"IF(ISERROR($B39*$I$38),\"\",$B39*$I$38)","v":""},{"$f":"IF(ISERROR($B39*$J$38),\"\",$B39*$J$38)","v":""},{"$f":"IF(ISERROR($B39*$K$38),\"\",$B39*$K$38)","v":""},{"$f":"IF(ISERROR($B39*$L$38),\"\",$B39*$L$38)","v":""},{"$f":"IF(ISERROR($B39*$M$38),\"\",$B39*$M$38)","v":""},{"$f":"IF(ISERROR($B39*$N$38),\"\",$B39*$N$38)","v":""},{"$f":"IF(ISERROR($B39*$O$38),\"\",$B39*$O$38)","v":""},{"$f":"IF(ISERROR($B39*$P$38),\"\",$B39*$P$38)","v":""},{"$f":"IF(ISERROR($B39*$Q$38),\"\",$B39*$Q$38)","v":""},{"$f":"IF(ISERROR($B39*$R$38),\"\",$B39*$R$38)","v":""},{"$f":"IF(ISERROR($B39*$S$38),\"\",$B39*$S$38)","v":""},{"$f":"IF(ISERROR($B39*$T$38),\"\",$B39*$T$38)","v":""},null,{"$f":"IF(AND($G$15+$G$18-A39>0,A39>=$G$15),$G$13+A39-$G$15,0)","v":0}]
[2023,{"$f":"IF(ISBLANK(D25),\"\",IF(AND($G$15+$G$18-A40>0,A40>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V40,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A40,VLOOKUP(V40,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A41,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(3),TRUE))))))),IF(AND($G$15+$G$18-A40>0,A40>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V40,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A40,VLOOKUP(V40,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A41,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(3),TRUE),\"\")))))),\"\")))","v":""},{"$f":"IF(ISERROR($B40*$C$38),\"\",$B40*$C$38)","v":""},"",{"$f":"IF(ISERROR($B40*$E$38),\"\",$B40*$E$38)","v":""},"",{"$f":"IF(ISERROR($B40*$G$38),\"\",$B40*$G$38)","v":""},"",{"$f":"IF(ISERROR($B40*$I$38),\"\",$B40*$I$38)","v":""},"",{"$f":"IF(ISERROR($B40*$K$38),\"\",$B40*$K$38)","v":""},"",{"$f":"IF(ISERROR($B40*$M$38),\"\",$B40*$M$38)","v":""},"",{"$f":"IF(ISERROR($B40*$O$38),\"\",$B40*$O$38)","v":""},"",{"$f":"IF(ISERROR($B40*$Q$38),\"\",$B40*$Q$38)","v":""},"",{"$f":"IF(ISERROR($B40*$S$38),\"\",$B40*$S$38)","v":""},"",null,{"$f":"IF(AND($G$15+$G$18-A40>0,A40>=$G$15),IF($G$8=\"Academic\",IF(AND(OR(MOD(V39,5)=0,MOD(V39,18)=0,MOD(V39,19)=0),V39>0),V39,$G$13+A40-$G$15),IF($G$11=67,IF(AND(MOD(V39,20)=0,V39>0),V39,$G$13+A40-$G$15),IF($G$11=5,IF(AND(MOD(V39,12)=0,V39>0),V39,$G$13+A40-$G$15),IF($G$11=34,IF(AND(MOD(V39,7)=0,V39>0),V39,$G$13+A40-$G$15))))),0)","v":0}]
[2024,{"$f":"IF(ISBLANK(D26),\"\",IF(AND($G$15+$G$18-A41>0,A41>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A40,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A41,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(4),TRUE))))))),IF(AND($G$15+$G$18-A41>0,A41>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A40,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A41,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(4),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,{"$f":"IF(AND($G$15+$G$18-A41>0,A41>=$G$15),IF($G$8=\"Academic\",IF(AND(OR(MOD(V40,5)=0,MOD(V40,18)=0,MOD(V40,19)=0),V40>0),V40,$G$13+A41-$G$15),IF($G$11=67,IF(AND(MOD(V40,20)=0,V40>0),V40,$G$13+A41-$G$15),IF($G$11=5,IF(AND(MOD(V40,12)=0,V40>0),V40,$G$13+A41-$G$15),IF($G$11=34,IF(AND(MOD(V40,7)=0,V40>0),V40,$G$13+A41-$G$15))))),0)","v":0}]
[2025,{"$f":"IF(ISBLANK(D27),\"\",IF(AND($G$15+$G$18-A42>0,A42>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A40,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A41,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(5),TRUE))))))),IF(AND($G$15+$G$18-A42>0,A42>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A40,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A41,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(5),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[2026,{"$f":"IF(ISBLANK(D28),\"\",IF(AND($G$15+$G$18-A43>0,A43>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A40,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A41,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A42,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(6),TRUE))))))),IF(AND($G$15+$G$18-A43>0,A43>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A40,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A41,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A42,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(6),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[2027,{"$f":"IF(ISBLANK(D29),\"\",IF(AND($G$15+$G$18-A44>0,A44>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A40,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A41,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A42,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A43,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE))))))),IF(AND($G$15+$G$18-A44>0,A44>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A40,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A41,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A42,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A43,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[2028,{"$f":"IF(ISBLANK(D30),\"\",IF(AND($G$15+$G$18-A45>0,A45>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A40,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A41,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A42,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A43,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A44,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE))))))),IF(AND($G$15+$G$18-A45>0,A45>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A40,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A41,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A42,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A43,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A44,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[null,{"$f":"SUM(B39:B44)","v":0},{"$f":"SUM(C39:C44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"QUOTIENT(100*A64,5)*5/100","v":0}]
[]
[null,null,"IF (start year + No. of years - A11) > 0… AND A11 >= Start year"]

{"sheet":"Salary Shortfall Calculator","index":1,"n_rows":66,"n_cols":22,"rows_kept":66,"cut":false,"hidden":false,"merged":[[32,1,33,5]]}
[]
[]
[]
[]
[]
[]
[]
["STEP 1 - ","Will the Researcher be Professional Staff (e.g. Research Assistant, ",null,null,null,null,null,"Academic"]
[null,"Project Officer) or Academic Staff (e.g. Postdoctoral Fellow) ?",null,null,null,null,null,"Professional"]
[]
["STEP 2 - ","Select the Level & Step at which the Researcher will",null,null,null,"Level:"]
[null,"commence:",null,null,null,"Step:"]
[null,null,null,null,null,null,{"$f":"IF(G8=\"Academic\",VLOOKUP(CONCATENATE('Salary Shortfall Calculator'!$G$11,'Salary Shortfall Calculator'!$G$12),'A-DATA'!A2:B20,2,FALSE),IF(G8=\"Professional\",VLOOKUP((G11*10)+G12,'P-DATA'!A2:B21,2,FALSE),\"\"))","v":""}]
[]
["STEP 3 - ","Enter the start year for the Researcher:"]
[]
[]
["STEP 4 - ","Enter how many calendar years will the Researcher be employed:"]
[]
[]
["STEP 5 - ","Select the FTE in each year and enter the yearly Grant Salary Contribution in the table below:"]
[]
[null,"Year","Level / Step","Select FTE…\n¯ ¯ ¯","Salary + 30%\non-costs","Grant Salary Contribution","Salary Shortfall"]
[null,2022,{"$f":"IF(AND($G$15+$G$18-A39>0,A39>=$G$15,$G$8=\"Academic\"),VLOOKUP(V39,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A39>0,A39>=$G$15,$G$8=\"Professional\"),VLOOKUP(V39,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D24=0,\"\",HLOOKUP(D24,$B$38:$T$45,2,FALSE))","v":""},null,{"$f":"IF(E24 = \"\", \"\", E24-F24)","v":""}]
[null,2023,{"$f":"IF(AND($G$15+$G$18-A40>0,A40>=$G$15,$G$8=\"Academic\"),VLOOKUP(V40,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A40>0,A40>=$G$15,$G$8=\"Professional\"),VLOOKUP(V40,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D25=0,\"\",HLOOKUP(D25,$B$38:$T$45,3,FALSE))","v":""},null,{"$f":"IF(E25 = \"\", \"\", E25-F25)","v":""}]
[null,2024,{"$f":"IF(AND($G$15+$G$18-A41>0,A41>=$G$15,$G$8=\"Academic\"),VLOOKUP(V41,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A41>0,A41>=$G$15,$G$8=\"Professional\"),VLOOKUP(V41,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D26=0,\"\",HLOOKUP(D26,$B$38:$T$45,4,FALSE))","v":""},null,""]
[null,2025,{"$f":"IF(AND($G$15+$G$18-A42>0,A42>=$G$15,$G$8=\"Academic\"),VLOOKUP(V42,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A42>0,A42>=$G$15,$G$8=\"Professional\"),VLOOKUP(V42,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D27=0,\"\",HLOOKUP(D27,$B$38:$T$45,5,FALSE))","v":""},null,""]
[null,2026,{"$f":"IF(AND($G$15+$G$18-A43>0,A43>=$G$15,$G$8=\"Academic\"),VLOOKUP(V43,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A43>0,A43>=$G$15,$G$8=\"Professional\"),VLOOKUP(V43,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D28=0,\"\",HLOOKUP(D28,$B$38:$T$45,6,FALSE))","v":""},null,""]
[null,2027,{"$f":"IF(AND($G$15+$G$18-A44>0,A44>=$G$15,$G$8=\"Academic\"),VLOOKUP(V44,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A44>0,A44>=$G$15,$G$8=\"Professional\"),VLOOKUP(V44,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D29=0,\"\",HLOOKUP(D29,$B$38:$T$45,7,FALSE))","v":""},null,""]
[null,2028,{"$f":"IF(AND($G$15+$G$18-A45>0,A45>=$G$15,$G$8=\"Academic\"),VLOOKUP(V45,'A-DATA'!$B$2:$C$20,2,TRUE),IF(AND($G$15+$G$18-A45>0,A45>=$G$15,$G$8=\"Professional\"),VLOOKUP(V45,'P-DATA'!$B$2:$C$21,2,TRUE),\"\"))","v":""},null,{"$f":"IF(D30=0,\"\",HLOOKUP(D30,$B$38:$T$45,8,FALSE))","v":""},null,""]
[null,null,null,"TOTAL",{"$f":"SUM(E24:E30)","v":0},{"$f":"SUM(F24:F30)","v":0},{"$f":"SUM(G24:G30)","v":0}]
[]
["PLEASE NOTE:","* The figures calculated by this tool are to assist you in prepaing Research Grant applications only.\n* This tool can be used to estimate in-kind contributions of UOW staff and estimate the cost of employing staff at UOW on research projects.\n* The figures include a nominal yearly % increase and are therefore projected estimates only.\n* They do not represent Union or UOW Management proposals for future EBAs."]
[]
[]
[]
["days per week",5,4.75,4.5,4.25,4,3.75,3.5,3.25,3,2.75,2.5,2.25,2,1.75,1.5,1.25,1,0.75,0.5]
["FTE",1,0.95,0.9,0.85,0.8,0.75,0.7,0.65,0.6,0.55000000000000004,0.5,0.45,0.4,0.35,0.3,0.25,0.2,0.15,0.1]
[2022,{"$f":"IF(ISBLANK(D24),\"\",IF(AND($G$15+$G$18-A39>0,A39>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V39,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A40,VLOOKUP(V40,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A41,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(2),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(2),TRUE))))))),IF(AND($G$15+$G$18-A39>0,A39>=$G$15, G8=\"Professional\"),IF($G$15= A39,VLOOKUP(V39,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A40,VLOOKUP(V40,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A41,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(2),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(2),TRUE),\"\")))))),\"\")))","v":""},{"$f":"IF(ISERROR($B39*$C$38),\"\",$B39*$C$38)","v":""},{"$f":"IF(ISERROR($B39*$D$38),\"\",$B39*$D$38)","v":""},{"$f":"IF(ISERROR($B39*$E$38),\"\",$B39*$E$38)","v":""},{"$f":"IF(ISERROR($B39*$F$38),\"\",$B39*$F$38)","v":""},{"$f":"IF(ISERROR($B39*$G$38),\"\",$B39*$G$38)","v":""},{"$f":"IF(ISERROR($B39*$H$38),\"\",$B39*$H$38)","v":""},{"$f":"IF(ISERROR($B39*$I$38),\"\",$B39*$I$38)","v":""},{"$f":"IF(ISERROR($B39*$J$38),\"\",$B39*$J$38)","v":""},{"$f":"IF(ISERROR($B39*$K$38),\"\",$B39*$K$38)","v":""},{"$f":"IF(ISERROR($B39*$L$38),\"\",$B39*$L$38)","v":""},{"$f":"IF(ISERROR($B39*$M$38),\"\",$B39*$M$38)","v":""},{"$f":"IF(ISERROR($B39*$N$38),\"\",$B39*$N$38)","v":""},{"$f":"IF(ISERROR($B39*$O$38),\"\",$B39*$O$38)","v":""},{"$f":"IF(ISERROR($B39*$P$38),\"\",$B39*$P$38)","v":""},{"$f":"IF(ISERROR($B39*$Q$38),\"\",$B39*$Q$38)","v":""},{"$f":"IF(ISERROR($B39*$R$38),\"\",$B39*$R$38)","v":""},{"$f":"IF(ISERROR($B39*$S$38),\"\",$B39*$S$38)","v":""},{"$f":"IF(ISERROR($B39*$T$38),\"\",$B39*$T$38)","v":""},null,{"$f":"IF(AND($G$15+$G$18-A39>0,A39>=$G$15),$G$13+A39-$G$15,0)","v":0}]
[2023,{"$f":"IF(ISBLANK(D25),\"\",IF(AND($G$15+$G$18-A40>0,A40>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V40,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A40,VLOOKUP(V40,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A41,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(3),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(3),TRUE))))))),IF(AND($G$15+$G$18-A40>0,A40>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V40,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A40,VLOOKUP(V40,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A41,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(3),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(3),TRUE),\"\")))))),\"\")))","v":""},{"$f":"IF(ISERROR($B40*$C$38),\"\",$B40*$C$38)","v":""},"",{"$f":"IF(ISERROR($B40*$E$38),\"\",$B40*$E$38)","v":""},"",{"$f":"IF(ISERROR($B40*$G$38),\"\",$B40*$G$38)","v":""},"",{"$f":"IF(ISERROR($B40*$I$38),\"\",$B40*$I$38)","v":""},"",{"$f":"IF(ISERROR($B40*$K$38),\"\",$B40*$K$38)","v":""},"",{"$f":"IF(ISERROR($B40*$M$38),\"\",$B40*$M$38)","v":""},"",{"$f":"IF(ISERROR($B40*$O$38),\"\",$B40*$O$38)","v":""},"",{"$f":"IF(ISERROR($B40*$Q$38),\"\",$B40*$Q$38)","v":""},"",{"$f":"IF(ISERROR($B40*$S$38),\"\",$B40*$S$38)","v":""},"",null,{"$f":"IF(AND($G$15+$G$18-A40>0,A40>=$G$15),IF($G$8=\"Academic\",IF(AND(OR(MOD(V39,5)=0,MOD(V39,18)=0,MOD(V39,19)=0),V39>0),V39,$G$13+A40-$G$15),IF($G$11=67,IF(AND(MOD(V39,20)=0,V39>0),V39,$G$13+A40-$G$15),IF($G$11=5,IF(AND(MOD(V39,12)=0,V39>0),V39,$G$13+A40-$G$15),IF($G$11=34,IF(AND(MOD(V39,7)=0,V39>0),V39,$G$13+A40-$G$15))))),0)","v":0}]
[2024,{"$f":"IF(ISBLANK(D26),\"\",IF(AND($G$15+$G$18-A41>0,A41>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A40,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A41,VLOOKUP(V41,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(4),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(4),TRUE))))))),IF(AND($G$15+$G$18-A41>0,A41>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A40,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A41,VLOOKUP(V41,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(4),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(4),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,{"$f":"IF(AND($G$15+$G$18-A41>0,A41>=$G$15),IF($G$8=\"Academic\",IF(AND(OR(MOD(V40,5)=0,MOD(V40,18)=0,MOD(V40,19)=0),V40>0),V40,$G$13+A41-$G$15),IF($G$11=67,IF(AND(MOD(V40,20)=0,V40>0),V40,$G$13+A41-$G$15),IF($G$11=5,IF(AND(MOD(V40,12)=0,V40>0),V40,$G$13+A41-$G$15),IF($G$11=34,IF(AND(MOD(V40,7)=0,V40>0),V40,$G$13+A41-$G$15))))),0)","v":0}]
[2025,{"$f":"IF(ISBLANK(D27),\"\",IF(AND($G$15+$G$18-A42>0,A42>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A40,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A41,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A42,VLOOKUP(V42,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(5),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(5),TRUE))))))),IF(AND($G$15+$G$18-A42>0,A42>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A40,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A41,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A42,VLOOKUP(V42,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(5),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(5),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[2026,{"$f":"IF(ISBLANK(D28),\"\",IF(AND($G$15+$G$18-A43>0,A43>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A40,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A41,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A42,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A43,VLOOKUP(V43,Academic!$A$2:'Academic'!$H$20,(6),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(6),TRUE))))))),IF(AND($G$15+$G$18-A43>0,A43>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A40,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A41,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A42,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A43,VLOOKUP(V43,Professional!$A$2:'Professional'!$H$21,(6),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(6),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[2027,{"$f":"IF(ISBLANK(D29),\"\",IF(AND($G$15+$G$18-A44>0,A44>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A40,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A41,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A42,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A43,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE),IF($G$15=A44,VLOOKUP(V44,Academic!$A$2:'Academic'!$H$20,(7),TRUE))))))),IF(AND($G$15+$G$18-A44>0,A44>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A40,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A41,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A42,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A43,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),IF($G$15=A44,VLOOKUP(V44,Professional!$A$2:'Professional'!$H$21,(7),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[2028,{"$f":"IF(ISBLANK(D30),\"\",IF(AND($G$15+$G$18-A45>0,A45>=$G$15, G8=\"Academic\"),IF($G$15=A39,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A40,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A41,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A42,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A43,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE),IF($G$15=A44,VLOOKUP(V45,Academic!$A$2:'Academic'!$H$20,(8),TRUE))))))),IF(AND($G$15+$G$18-A45>0,A45>=$G$15, G8=\"Professional\"),IF($G$15=A39,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A40,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A41,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A42,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A43,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),IF($G$15=A44,VLOOKUP(V45,Professional!$A$2:'Professional'!$H$21,(8),TRUE),\"\")))))),\"\")))","v":""},"","","","","","","","","","","","","","","","","","",null,0]
[null,{"$f":"SUM(B39:B44)","v":0},{"$f":"SUM(C39:C44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"QUOTIENT(100*A64,5)*5/100","v":0}]
[]
[null,null,"IF (start year + No. of years - A11) > 0… AND A11 >= Start year"]

{"sheet":"Academic","index":2,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,8,5,8],[6,8,10,8],[11,8,15,8],[16,8,18,8]]}
["No.",2022,2023,2024,2025,2026,2027,2028,"Level"]
[1,110254,{"$f":"B2*1.02","v":112459.08},114708.2616,117002.426832,119342.47536863999,121729.32487601279,124163.91137353305,"Level A \nPostdoc"]
[2,114569,{"$f":"B3*1.02","v":116860.38},119197.58760000001,121581.53935200002,124013.17013904003,126493.43354182084,129023.30221265726]
[3,118881,121258.62,123683.79239999999,126157.46824799999,128680.61761295999,131254.22996521919,133879.31456452358]
[4,123196,125659.92,128173.11840000001,130736.58076800001,133351.31238336003,136018.33863102723,138738.70540364779]
[5,129173,131756.46,134391.58919999999,137079.420984,139821.00940367999,142617.42959175358,145469.77818358864]
[6,139126,141908.51999999999,144746.69039999999,147641.62420799999,150594.45669215999,153606.34582600321,156678.47274252327,"Level B\nLecturer"]
[7,144101,146983.01999999999,149922.68039999998,152921.13400799999,155979.55668816,159099.14782192319,162281.13077836166]
[8,149083,152064.66,155105.95320000002,158208.07226400002,161372.23370928003,164599.67838346562,167891.67195113495]
[9,154056,157137.12,160279.86239999998,163485.45964799999,166755.16884095999,170090.27221777919,173492.07766213478]
[10,160672,163885.44,167163.1488,170506.41177599999,173916.54001152,177394.87081175041,180942.76822798542]
[11,168993,172372.86000000002,175820.31720000002,179336.72354400004,182923.45801488005,186581.92717517764,190313.5657186812,"Level C\nSenior Lecturer"]
[12,173970,177449.4,180998.38800000001,184618.35576000001,188310.72287520001,192076.93733270402,195918.47607935811]
[13,178948,182526.96,186177.49919999999,189901.049184,193699.07016768001,197573.0515710336,201524.51260245428]
[14,183923,187601.46,191353.48919999998,195180.55898399997,199084.17016367998,203065.85356695359,207127.17063829268]
[15,190594,194405.88,198293.9976,202259.87755200002,206305.07510304003,210431.17660510083,214639.80013720284]
[16,203832,207908.64,212066.81280000001,216308.14905600002,220634.31203712002,225046.99827786241,229547.93824341966,"Level D\nA/Professor"]
[17,210469,214678.38,218971.94760000001,223351.38655200001,227818.41428304001,232374.78256870082,237022.27822007483]
[18,218749,223123.98,227586.4596,232138.188792,236780.95256784,241516.57161919679,246346.90305158074]
[19,253611,258683.22,263856.88439999998,269134.02208799997,274516.70252975996,280007.03658035514,285607.17731196224,"Level E1 - Professor"]
[20,{"$f":"B20*1.1","v":278972.10000000003},284551.54200000002,290242.57283999998,296047.42429679999,301968.37278273597,308007.74023839069,314167.8950431585,"Level E2 - S/Professor"]
[21,{"$f":"B20*1.25","v":317013.75},323354.02500000002,329821.10549999995,336417.52760999999,343145.87816219998,350008.79572544392,357008.9716399528,"Level E3 - D/Professor"]

{"sheet":"A-DATA","index":3,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,5,0,9],[7,5,7,11]]}
["Level / Step","No.","Level / Step",null,"Level","Steps"]
["A1",1,"A1",null,"A",1,2,3,4,5]
["A2",2,"A2",null,"B",1,2,3,4,5]
["A3",3,"A3",null,"C",1,2,3,4,5]
["A4",4,"A4",null,"D",1,2,3]
["A5",5,"A5",null,"E",1,"Senior","Distinguished"]
["B1",6,"B1"]
["B2",7,"B2",null,"Start Year","Total Years"]
["B3",8,"B3",null,2022,1,2,3,4,5,6,7]
["B4",9,"B4",null,2023,1,2,3,4,5,6]
["B5",10,"B5",null,2024,1,2,3,4,5]
["C1",11,"C1",null,2025,1,2,3,4]
["C2",12,"C2",null,2026,1,2,3]
["C3",13,"C3",null,2027,1,2]
["C4",14,"C4",null,2028,1]
["C5",15,"C5"]
["D1",16,"D1"]
["D2",17,"D2"]
["D3",18,"D3"]
["E1",19,"E1"]
["E-Sen",20,"E2"]
["E-Dis",21,"E3"]

{"sheet":"Professional","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,8,7,8],[8,8,12,8],[13,8,20,8]]}
["No.",2022,2023,2024,2025,2026,2027,2028,"Level"]
[1,74854,{"$f":"B2*1.02","v":76351.08},77878.101600000009,79435.663632000011,81024.376904640012,82644.864442732811,84297.761731587467,"Level 3/4"]
[2,78529,{"$f":"B3*1.02","v":80099.58},81701.57160000001,83335.603032000014,85002.315092640012,86702.361394492807,88436.40862238266]
[3,82201,83845.02,85521.920400000003,87232.358808000005,88977.005984160001,90756.546103843197,92571.677025920057]
[4,85873,87590.46,89342.26920000001,91129.11458400001,92951.696875680005,94810.730813193601,96706.945429457468]
[5,89548,91338.96,93165.739200000011,95029.053984000013,96929.63506368002,98868.227764953626,100845.5923202527]
[6,93222,95086.44,96988.168799999999,98927.932176000002,100906.49081952,102924.6206359104,104983.11304862861]
[7,95421,97329.42,99276.008400000006,101261.52856800001,103286.75913936002,105352.49432214722,107459.54420859016]
[8,95421,{"$f":"B9*1.02","v":97329.42},{"$f":"C9*1.02","v":99276.008400000006},{"$f":"D9*1.02","v":101261.52856800001},{"$f":"E9*1.02","v":103286.75913936002},{"$f":"F9*1.02","v":105352.49432214722},{"$f":"G9*1.02","v":107459.54420859016},"Level 5"]
[9,96891,98828.82,100805.39640000001,102821.50432800001,104877.93441456002,106975.49310285122,109115.00296490824]
[10,100563,102574.26,104625.74519999999,106718.26010399999,108852.62530607999,111029.6778122016,113250.27136844562]
[11,104236,106320.72,108447.13440000001,110616.07708800001,112828.39862976001,115084.96660235521,117386.66593440232]
[12,107911,110069.22,112270.6044,114516.01648799999,116806.33681775999,119142.46355411519,121525.3128251975]
[13,107911,110069.22,112270.6044,114516.01648799999,116806.33681775999,119142.46355411519,121525.3128251975,"Level 6/7"]
[14,111583,113814.66,116090.9532,118412.772264,120781.02770928,123196.6482634656,125660.58122873491]
[15,115256,117561.12,119912.34239999999,122310.58924799999,124756.80103295999,127251.9370536192,129796.97579469159]
[16,118932,121310.64,123736.85280000001,126211.58985600001,128735.82165312,131310.53808618241,133936.74884790607]
[17,122606,125058.12,127559.2824,130110.468048,132712.67740896001,135366.93095713921,138074.26957628201]
[18,126274,128799.48,131375.46960000001,134002.97899200002,136683.03857184004,139416.69934327685,142205.03333014238]
[19,129945,132543.9,135194.77799999999,137898.67356,140656.6470312,143469.779971824,146339.17557126048]
[20,133623,136295.46,139021.36919999999,141801.796584,144637.83251568,147530.58916599359,150481.20094931347]

{"sheet":"P-DATA","index":5,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[[7,5,7,11],[0,5,0,12]]}
["Level / Step","No.","Level / Step",null,"Level","Steps"]
[341,1,"3-4/1",null,34,1,2,3,4,5,6,7]
[342,2,"3-4/2",null,5,1,2,3,4,5]
[343,3,"3-4/3",null,67,1,2,3,4,5,6,7,8]
[344,4,"3-4/4",null,"-"]
[345,5,"3-4/5",null,"-"]
[346,6,"3-4/6"]
[347,7,"3-4/7",null,"Start Year","Total Years"]
[51,8,"5/1",null,2022,1,2,3,4,5,6,7]
[52,9,"5/2",null,2023,1,2,3,4,5,6]
[53,10,"5/3",null,2024,1,2,3,4,5]
[54,11,"5/4",null,2025,1,2,3,4]
[55,12,"5/5",null,2026,1,2,3]
[671,13,"6-7/1",null,2027,1,2]
[672,14,"6-7/2",null,2028,1]
[673,15,"6-7/3"]
[674,16,"6-7/4"]
[675,17,"6-7/5"]
[676,18,"6-7/6"]
[677,19,"6-7/7"]
[678,20,"6-7/8"]