{"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":36,"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],[0,1,0,3],[1,12,6,17],[1,0,1,3],[25,4,25,35]]}
[null,"Team Name:",null,null,"TTKD"]
["Individual reporting file names:",null,null,null,"weekly-Alex.xlsx",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,"weekly-Isioma.xlsx"]
[null,null,null,null,"weekly-nick.xlsx"]
[null,null,null,null,"weekly-Stefano.xlsx"]
[]
["Directory for individual files:"]
[]
[]
[]
["First Term",null,null,"Number of weeks:",10,"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":"Alex"},{"$f":"IF(OR($E$11=0,A15=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E15:Y15,0))/$E$11)","v":5.42},{"$f":"IF(A15=\"\",\"\",SUM(IF(ISNUMBER(E15:Y15),E15:Y15,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":54.2},{"$f":"IF(A15=\"\",\"\",SUM(IF(ISNUMBER(E15:Y15),E15:Y15,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":70.7},{"$f":"IF(A15 = \"\",\"\",GetValuesFromNamedRange(E2,\"T1Data\"))","v":4.5},5.75,5,6.25,6.25,6.25,5.75,13.5,0.5,15,14.75,5.75,3.5,5,4.5,5.2,4.7,5,4.75,3,0]
[{"$f":"IF(ISBLANK(E3),\"\",GetValuesFromNamedRange(E3,\"Name\"))","v":"Isioma Nnodum"},{"$f":"IF(OR($E$11=0,A16=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E16:Y16,0))/$E$11)","v":4.4266666666666667},{"$f":"IF(A16=\"\",\"\",SUM(IF(ISNUMBER(E16:Y16),E16:Y16,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":44.266666666666666},{"$f":"IF(A16=\"\",\"\",SUM(IF(ISNUMBER(E16:Y16),E16:Y16,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":0},{"$f":"IF(A16 = \"\",\"\",GetValuesFromNamedRange(E3,\"T1Data\"))","v":4.75},0,3.84,0,5.836666666666666,0,4.84,0,0,0,6,0,6,0,4,0,5.5,0,3.5,0,0]
[{"$f":"IF(ISBLANK(E4),\"\",GetValuesFromNamedRange(E4,\"Name\"))","v":"Nick"},{"$f":"IF(OR($E$11=0,A17=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E17:Y17,0))/$E$11)","v":4.7200000000000006},{"$f":"IF(A17=\"\",\"\",SUM(IF(ISNUMBER(E17:Y17),E17:Y17,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":47.2},{"$f":"IF(A17=\"\",\"\",SUM(IF(ISNUMBER(E17:Y17),E17:Y17,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":50.7},{"$f":"IF(A17 = \"\",\"\",GetValuesFromNamedRange(E4,\"T1Data\"))","v":4},5,4.75,6.25,7,6.75,6,5,0,7,7.75,4.5,4.5,4.75,4.5,4.95,4.2,6.5,4.5,0,0]
[{"$f":"IF(ISBLANK(E5),\"\",GetValuesFromNamedRange(E5,\"Name\"))","v":"Stefano Sansone"},{"$f":"IF(OR($E$11=0,A18=\"\"),\"\", SUM(IF(RIGHT($E$14:$Y$14,3)=\"Act\",E18:Y18,0))/$E$11)","v":4.5200000000000005},{"$f":"IF(A18=\"\",\"\",SUM(IF(ISNUMBER(E18:Y18),E18:Y18,0)*ISNUMBER(SEARCH(\"Act\",$E$14:$Y$14))))","v":45.2},{"$f":"IF(A18=\"\",\"\",SUM(IF(ISNUMBER(E18:Y18),E18:Y18,0)*ISNUMBER(SEARCH(\"Est\",$E$14:$Y$14))))","v":48.2},{"$f":"IF(A18 = \"\",\"\",GetValuesFromNamedRange(E5,\"T1Data\"))","v":3.25},4.75,3.5,6.5,6.75,5.25,5,5,0,6,7,5,5.5,3.75,4,4.95,4.2,7,6,0,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":4.7716666666666674},{"$f":"SUM(C15:C19)","v":190.86666666666667},{"$f":"SUM(D15:D19)","v":169.60000000000002},{"$f":"SUM(E15:E19)","v":16.5},{"$f":"SUM(F15:F19)","v":15.5},17.09,19,25.836666666666666,18.25,21.59,23.5,0.5,28,35.5,15.25,19.5,13.5,17,15.100000000000001,18.599999999999998,18.5,18.75,3,0]
[]
[]
[]
["Second Term",null,null,"Number of weeks:",11,"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","Wk11Est","Wk11Act","Wk12Est","Wk12Act","Wk13Est","Wk13Act","Wk14Est","Wk14Act","Wk15Est","Wk15Act","FinalsEst","FinalsAct"]
[{"$f":"IF(ISBLANK(E2),\"\",GetValuesFromNamedRange(E2,\"Name\"))","v":"Alex"},{"$f":"IF(OR($E$24=0,A28=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E28:Z28,0))/$E$24)","v":11.845454545454546},{"$f":"IF($A28=\"\",\"\",SUM(IF(ISNUMBER($E28:$AJ28),$E28:$AJ28,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$AJ$27))))","v":163.30000000000001},{"$f":"IF($A28=\"\",\"\",SUM(IF(ISNUMBER($E28:$AJ28),$E28:$AJ28,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$AJ$27))))","v":191.3},{"$f":"IF(A28 = \"\",\"\",GetValuesFromNamedRange(E2,\"T2Data\"))","v":5.3000000000000007},7.15,13,14.4,10.5,9,10,8,17.5,17,20,11.75,17.5,8.5,14.5,10,13.5,15.5,12.5,14.25,16.5,14.75,9.5,4.5,15.5,15,6,5.5,4,4.5,5.5,3.5]
[{"$f":"IF(ISBLANK(E3),\"\",GetValuesFromNamedRange(E3,\"Name\"))","v":"Isioma Nnodum"},{"$f":"IF(OR($E$24=0,A29=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E29:Z29,0))/$E$24)","v":7.4581818181818189},{"$f":"IF($A29=\"\",\"\",SUM(IF(ISNUMBER($E29:$AJ29),$E29:$AJ29,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$AJ$27))))","v":102.26},{"$f":"IF($A29=\"\",\"\",SUM(IF(ISNUMBER($E29:$AJ29),$E29:$AJ29,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$AJ$27))))","v":113.02},{"$f":"IF(A29 = \"\",\"\",GetValuesFromNamedRange(E3,\"T2Data\"))","v":4.5},4.5,7.8,7.8,6,6.57,11.5,11.5,7,7,8,8.17,6,8.5,8,10,6,6,4,4,6,8,13.22,20.22,10,0,4,0,5,0,6,0]
[{"$f":"IF(ISBLANK(E4),\"\",GetValuesFromNamedRange(E4,\"Name\"))","v":"Nick"},{"$f":"IF(OR($E$24=0,A30=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E30:Z30,0))/$E$24)","v":9.75},{"$f":"IF($A30=\"\",\"\",SUM(IF(ISNUMBER($E30:$AJ30),$E30:$AJ30,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$AJ$27))))","v":171},{"$f":"IF($A30=\"\",\"\",SUM(IF(ISNUMBER($E30:$AJ30),$E30:$AJ30,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$AJ$27))))","v":150.75},{"$f":"IF(A30 = \"\",\"\",GetValuesFromNamedRange(E4,\"T2Data\"))","v":8.5},9.25,4.5,5.5,7,8.75,5.25,5.5,8.5,12.5,11.5,0,6.5,8.25,9.5,17,9.5,12.75,10,16.5,11.5,11.25,10.5,11.25,11.5,9.75,11.5,15,8.5,7.75,16.5,20]
[{"$f":"IF(ISBLANK(E5),\"\",GetValuesFromNamedRange(E5,\"Name\"))","v":"Stefano Sansone"},{"$f":"IF(OR($E$24=0,A31=\"\"),\"\",SUM(IF(RIGHT($E$27:$Z$27,3)=\"Act\",E31:Z31,0))/$E$24)","v":7.1181818181818182},{"$f":"IF($A31=\"\",\"\",SUM(IF(ISNUMBER($E31:$AJ31),$E31:$AJ31,0)*ISNUMBER(SEARCH(\"Act\",$E$27:$AJ$27))))","v":109.3},{"$f":"IF($A31=\"\",\"\",SUM(IF(ISNUMBER($E31:$AJ31),$E31:$AJ31,0)*ISNUMBER(SEARCH(\"Est\",$E$27:$AJ$27))))","v":115.4},{"$f":"IF(A31 = \"\",\"\",GetValuesFromNamedRange(E5,\"T2Data\"))","v":4.6500000000000004},5.3,3.25,3.25,6.25,4.25,7.25,8.25,8.25,10.25,20.25,10.5,8.25,10.5,5.25,6,7.25,6.75,6.25,6.25,8.25,7,8.25,9,7,7,7,7,4,4,4,4]
[{"$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":9.0429545454545455},{"$f":"SUM(C28:C32)","v":545.86},570.47,22.950000000000003,26.2,28.55,30.95,29.75,28.57,34,33.25,41.25,46.75,59.75,30.42,38.25,35.75,37.25,43,36.25,41,32.75,41,42.25,{"$f":"SUM(Z28:Z32)","v":41},41.47,44.97,44,31.75,28.5,27.5,21.5,16.25,32,27.5]
[]
[]
[]
["Entire Project",null,null,"Number of weeks:",{"$f":"E11+E24","v":21}]
[]
[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":"Alex"},{"$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:$AJ$27,3)=\"Act\",E28:AJ28,0))/($E$11 + $E$24))","v":10.357142857142858},{"$f":"IF(A41=\"\",\"\",SUM(C15,C28))","v":217.5},{"$f":"IF(A41=\"\",\"\",SUM(D15,D28))","v":262}]
[{"$f":"IF(ISBLANK(E3),\"\",GetValuesFromNamedRange(E3,\"Name\"))","v":"Isioma Nnodum"},{"$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:$AJ$27,3)=\"Act\",E29:AJ29,0))/($E$11 + $E$24))","v":6.9774603174603165},{"$f":"IF(A42=\"\",\"\",SUM(C16,C29))","v":146.52666666666667},{"$f":"IF(A42=\"\",\"\",SUM(D16,D29))","v":113.02}]
[{"$f":"IF(ISBLANK(E4),\"\",GetValuesFromNamedRange(E4,\"Name\"))","v":"Nick"},{"$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:$AJ$27,3)=\"Act\",E30:AJ30,0))/($E$11 + $E$24))","v":10.390476190476189},{"$f":"IF(A43=\"\",\"\",SUM(C17,C30))","v":218.2},{"$f":"IF(A43=\"\",\"\",SUM(D17,D30))","v":201.45}]
[{"$f":"IF(ISBLANK(E5),\"\",GetValuesFromNamedRange(E5,\"Name\"))","v":"Stefano Sansone"},{"$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:$AJ$27,3)=\"Act\",E31:AJ31,0))/($E$11 + $E$24))","v":7.3571428571428568},{"$f":"IF(A44=\"\",\"\",SUM(C18,C31))","v":154.5},{"$f":"IF(A44=\"\",\"\",SUM(D18,D31))","v":163.60000000000002}]
[{"$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":8.7705555555555552},{"$f":"SUM(C41:C45)","v":736.72666666666669},{"$f":"SUM(D41:D45)","v":740.07}]