{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Team Reporting"],"not_rendered":{"charts":0,"images":0,"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":"Team Reporting","index":0,"n_rows":46,"n_cols":26,"rows_kept":46,"cut":false,"hidden":false,"merged":[[38,1,38,3],[38,9,43,15],[12,1,12,3],[2,4,2,7],[3,4,3,7],[4,4,4,7],[5,4,5,7],[12,4,12,24],[6,4,6,7],[6,0,6,3],[0,4,0,7],[25,1,25,3],[10,5,10,13],[23,5,23,13],[1,4,1,7],[25,4,25,25],[0,1,0,3],[1,12,6,17],[1,0,1,3]]}
[null,"Team Name:",null,null,"TERI"]
["Individual reporting file names:",null,null,null,"Phil-weekly-individual",null,null,null,null,null,null,null,"To update the data you will need to have all of the individual time reporting files opened.  Press this button to open all the individual files.\n\nIf the individual files are not in the same directory as the team file, indicate the subdirectory where they exist."]
[null,null,null,null,"Ryan-weekly-individual"]
[null,null,null,null,"Jordan-weekly-individual"]
[null,null,null,null,"Derek-weekly-individual"]
[]
["Directory for individual files:"]
[]
[]
[]
["First Term",null,null,"Number of weeks:",2,"Each week, increment the number of weeks reported for the term."]
[]
[null,"Totals",null,null,"First Term"]
[null,"Avg Act","Act","Est","Wk1Act","Wk2Est","Wk2Act","Wk3Est","Wk3Act","Wk4Est","Wk4Act","Wk5Est","Wk5Act","Wk6Est","Wk6Act","Wk7Est","Wk7Act","Wk8Est","Wk8Act","Wk9Est","Wk9Act","Wk10Est","Wk10Act","FinalsEst","FinalsAct"]
[{"$f":"IF(ISBLANK(E2),\"\",GetValuesFromNamedRange(E2,\"Name\"))","v":"Philip Rotoli"},{"$f":"IF(OR($E$11=0,A15=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E15:Y15,0))/$E$11)","v":37.5},{"$f":"IF(A15=\"\",\"\",SUM(IF(ISNUMBER(E15:Y15),E15:Y15,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":75},{"$f":"IF(A15=\"\",\"\",SUM(IF(ISNUMBER(E15:Y15),E15:Y15,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":80},{"$f":"IF(A15 = \"\",\"\",GetValuesFromNamedRange(E2,\"T1Data\"))","v":3},2,3,4,4,11,11,10,10,10,11,10,10,11,8,10,10,5,5,7,0]
[{"$f":"IF(ISBLANK(E3),\"\",GetValuesFromNamedRange(E3,\"Name\"))","v":"Ryan Wilson"},{"$f":"IF(OR($E$11=0,A16=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E16:Y16,0))/$E$11)","v":35.625},{"$f":"IF(A16=\"\",\"\",SUM(IF(ISNUMBER(E16:Y16),E16:Y16,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":71.25},{"$f":"IF(A16=\"\",\"\",SUM(IF(ISNUMBER(E16:Y16),E16:Y16,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":83.25},{"$f":"IF(A16 = \"\",\"\",GetValuesFromNamedRange(E3,\"T1Data\"))","v":2.75},11.25,11,9.5,9.75,7,9,7,6.5,7.5,4.75,8,4,9,6,8,10.5,6,7,10,0]
[{"$f":"IF(ISBLANK(E4),\"\",GetValuesFromNamedRange(E4,\"Name\"))","v":"Jordan Tice"},{"$f":"IF(OR($E$11=0,A17=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E17:Y17,0))/$E$11)","v":32.75},{"$f":"IF(A17=\"\",\"\",SUM(IF(ISNUMBER(E17:Y17),E17:Y17,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":65.5},{"$f":"IF(A17=\"\",\"\",SUM(IF(ISNUMBER(E17:Y17),E17:Y17,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":56.75},{"$f":"IF(A17 = \"\",\"\",GetValuesFromNamedRange(E4,\"T1Data\"))","v":3},5.5,4.5,5.5,7.25,8.5,9.25,9,9.5,5,6,3.5,3.5,5.25,5.25,4.5,6.5,10,10.75,0,0]
[{"$f":"IF(ISBLANK(E5),\"\",GetValuesFromNamedRange(E5,\"Name\"))","v":"Derek Leung"},{"$f":"IF(OR($E$11=0,A18=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E18:Y18,0))/$E$11)","v":35.924999999999997},{"$f":"IF(A18=\"\",\"\",SUM(IF(ISNUMBER(E18:Y18),E18:Y18,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":71.849999999999994},{"$f":"IF(A18=\"\",\"\",SUM(IF(ISNUMBER(E18:Y18),E18:Y18,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":75.75},{"$f":"IF(A18 = \"\",\"\",GetValuesFromNamedRange(E5,\"T1Data\"))","v":3.3},8.5,4.5500000000000007,2.5,7.5,4,3.25,10,9.25,7.5,11,10.5,2.5,9.25,9.25,10.5,10.75,10.5,10.5,2.5,0]
[{"$f":"IF(ISBLANK(E6),\"\",GetValuesFromNamedRange(E6,\"Name\"))","v":""},{"$f":"IF(OR($E$11=0,A19=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E19:Y19,0))/$E$11)","v":""},{"$f":"IF(A19=\"\",\"\",SUM(IF(ISNUMBER(E19:Y19),E19:Y19,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":""},{"$f":"IF(A19=\"\",\"\",SUM(IF(ISNUMBER(E19:Y19),E19:Y19,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":""},{"$f":"IF(A19 = \"\",\"\",GetValuesFromNamedRange(E6,\"T1Data\"))","v":""},"","","","","","","","","","","","","","","","","","","",""]
["Team totals",{"$f":"IF(OR(E11=0, SUM(B15:B19)=0),0,AVERAGE(B15:B19))","v":35.450000000000003},{"$f":"SUM(C15:C19)","v":283.60000000000002},{"$f":"SUM(D15:D19)","v":295.75},{"$f":"SUM(E15:E19)","v":12.05},{"$f":"SUM(F15:F19)","v":27.25},23.05,21.5,28.5,30.5,32.5,36,35.25,30,32.75,32,20,34.5,28.5,33,37.75,31.5,33.25,19.5,0]
[]
[]
[]
["Second Term",null,null,"Number of weeks:",0,"Each week, increment the number of weeks reported for the term."]
[]
[null,"Second Term",null,null,"Second Term"]
[null,"Avg Act","Act","Est","Wk1Est","Wk1Act","Wk2Est","Wk2Act","Wk3Est","Wk3Act","Wk4Est","Wk4Act","Wk5Est","Wk5Act","Wk6Est","Wk6Act","Wk7Est","Wk7Act","Wk8Est","Wk8Act","Wk9Est","Wk9Act","Wk10Est","Wk10Act","FinalsEst","FinalsAct"]
[{"$f":"IF(ISBLANK(E2),\"\",GetValuesFromNamedRange(E2,\"Name\"))","v":"Philip Rotoli"},{"$f":"IF(OR($E$24=0,A28=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E28:Z28,0))/$E$24)","v":""},{"$f":"IF($A28=\"\",\"\",SUM(IF(ISNUMBER($E28:$Z28),$E28:$Z28,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$Z$27))))","v":0},{"$f":"IF($A28=\"\",\"\",SUM(IF(ISNUMBER($E28:$Z28),$E28:$Z28,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$Z$27))))","v":0},{"$f":"IF(A28 = \"\",\"\",GetValuesFromNamedRange(E2,\"T2Data\"))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(ISBLANK(E3),\"\",GetValuesFromNamedRange(E3,\"Name\"))","v":"Ryan Wilson"},{"$f":"IF(OR($E$24=0,A29=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E29:Z29,0))/$E$24)","v":""},{"$f":"IF($A29=\"\",\"\",SUM(IF(ISNUMBER($E29:$Z29),$E29:$Z29,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$Z$27))))","v":0},{"$f":"IF($A29=\"\",\"\",SUM(IF(ISNUMBER($E29:$Z29),$E29:$Z29,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$Z$27))))","v":0},{"$f":"IF(A29 = \"\",\"\",GetValuesFromNamedRange(E3,\"T2Data\"))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(ISBLANK(E4),\"\",GetValuesFromNamedRange(E4,\"Name\"))","v":"Jordan Tice"},{"$f":"IF(OR($E$24=0,A30=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E30:Z30,0))/$E$24)","v":""},{"$f":"IF($A30=\"\",\"\",SUM(IF(ISNUMBER($E30:$Z30),$E30:$Z30,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$Z$27))))","v":0},{"$f":"IF($A30=\"\",\"\",SUM(IF(ISNUMBER($E30:$Z30),$E30:$Z30,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$Z$27))))","v":0},{"$f":"IF(A30 = \"\",\"\",GetValuesFromNamedRange(E4,\"T2Data\"))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(ISBLANK(E5),\"\",GetValuesFromNamedRange(E5,\"Name\"))","v":"Derek Leung"},{"$f":"IF(OR($E$24=0,A31=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E31:Z31,0))/$E$24)","v":""},{"$f":"IF($A31=\"\",\"\",SUM(IF(ISNUMBER($E31:$Z31),$E31:$Z31,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$Z$27))))","v":0},{"$f":"IF($A31=\"\",\"\",SUM(IF(ISNUMBER($E31:$Z31),$E31:$Z31,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$Z$27))))","v":0},{"$f":"IF(A31 = \"\",\"\",GetValuesFromNamedRange(E5,\"T2Data\"))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(ISBLANK(E6),\"\",GetValuesFromNamedRange(E6,\"Name\"))","v":""},{"$f":"IF(OR($E$24=0,A32=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E32:Z32,0))/$E$24)","v":""},{"$f":"IF($A32=\"\",\"\",SUM(IF(ISNUMBER($E32:$Z32),$E32:$Z32,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$Z$27))))","v":""},{"$f":"IF($A32=\"\",\"\",SUM(IF(ISNUMBER($E32:$Z32),$E32:$Z32,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$Z$27))))","v":""},{"$f":"IF(A32 = \"\",\"\",GetValuesFromNamedRange(E6,\"T2Data\"))","v":""},"","","","","","","","","","","","","","","","","","","","",""]
["Team totals",{"$f":"IF(OR(E24=0,SUM(B28:B32)=0),0,AVERAGE(B28:B32))","v":0},{"$f":"SUM(C28:C32)","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]
[]
[]
[]
["Entire Project",null,null,"Number of weeks:",{"$f":"E11+E24","v":2}]
[]
[null,"Entire Project",null,null,null,null,null,null,null,"Even when you have all of the indidividual time reporting files opened, a recalculation may not be triggered in this team reporting file.  Press this button to force a recalculation of the totals."]
[null,"Avg Act","Act","Est"]
[{"$f":"IF(ISBLANK(E2),\"\",GetValuesFromNamedRange(E2,\"Name\"))","v":"Philip Rotoli"},{"$f":"IF(OR(A41=\"\",($E$11+$E$24)=0),\"\",SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E15:Y15,0),IF(RIGHT($E$27:$Z$27,3)=\"Act\",E28:Z28,0))/($E$11 + $E$24))","v":37.5},{"$f":"IF(A41=\"\",\"\",SUM(C15,C28))","v":75},{"$f":"IF(A41=\"\",\"\",SUM(D15,D28))","v":80}]
[{"$f":"IF(ISBLANK(E3),\"\",GetValuesFromNamedRange(E3,\"Name\"))","v":"Ryan Wilson"},{"$f":"IF(OR(A42=\"\",($E$11+$E$24)=0),\"\",SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E16:Y16,0),IF(RIGHT($E$27:$Z$27,3)=\"Act\",E29:Z29,0))/($E$11 + $E$24))","v":35.625},{"$f":"IF(A42=\"\",\"\",SUM(C16,C29))","v":71.25},{"$f":"IF(A42=\"\",\"\",SUM(D16,D29))","v":83.25}]
[{"$f":"IF(ISBLANK(E4),\"\",GetValuesFromNamedRange(E4,\"Name\"))","v":"Jordan Tice"},{"$f":"IF(OR(A43=\"\",($E$11+$E$24)=0),\"\",SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E17:Y17,0),IF(RIGHT($E$27:$Z$27,3)=\"Act\",E30:Z30,0))/($E$11 + $E$24))","v":32.75},{"$f":"IF(A43=\"\",\"\",SUM(C17,C30))","v":65.5},{"$f":"IF(A43=\"\",\"\",SUM(D17,D30))","v":56.75}]
[{"$f":"IF(ISBLANK(E5),\"\",GetValuesFromNamedRange(E5,\"Name\"))","v":"Derek Leung"},{"$f":"IF(OR(A44=\"\",($E$11+$E$24)=0),\"\",SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E18:Y18,0),IF(RIGHT($E$27:$Z$27,3)=\"Act\",E31:Z31,0))/($E$11 + $E$24))","v":35.924999999999997},{"$f":"IF(A44=\"\",\"\",SUM(C18,C31))","v":71.849999999999994},{"$f":"IF(A44=\"\",\"\",SUM(D18,D31))","v":75.75}]
[{"$f":"IF(ISBLANK(E6),\"\",GetValuesFromNamedRange(E6,\"Name\"))","v":""},{"$f":"IF(OR(A45=\"\",($E$11+$E$24)=0),\"\",SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E19:Y19,0),IF(RIGHT($E$27:$Z$27,3)=\"Act\",E32:Z32,0))/($E$11 + $E$24))","v":""},{"$f":"IF(A45=\"\",\"\",SUM(C19,C32))","v":""},{"$f":"IF(A45=\"\",\"\",SUM(D19,D32))","v":""}]
["Team totals",{"$f":"IF(OR((E11+E24)=0,SUM(B41:B45)=0),0,AVERAGE(B41:B45))","v":35.450000000000003},{"$f":"SUM(C41:C45)","v":283.60000000000002},{"$f":"SUM(D41:D45)","v":295.75}]