{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Imprint","TBP","TBP%","Roadmap","Tabelle1","ProjectList","TeamList","CapacityData","PRJ_Test #1","PRJ_Test #2","PRJ_Test #3","PRJ_Test #4","PRJ_Test #5","PRJ_Test #6","PRJ_Template","Raw","Import","AnonymousLookup","CapacityModel","Backlog","Colorindex"],"not_rendered":{"charts":5,"images":3,"macros":1,"external_links":2,"defined_names":14,"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":"Imprint","index":0,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SmartPipeliner",null,null,"Version 3.0.0"]
[]
[null,"Simple and fast Tool to Control the Work-In-Progress of a Multi-Project-Organization"]
[]
[null,"Tutorials: ","Basic Introduction in how to use the SmartPipeliner and how to do the first Staggering",null,null,null,null,null,null,"<<<<< klick here to watch on youtube"]
[null,null,"Advanced feature \"the capacity model\"",null,null,null,null,null,null,"<<<<< klick here to watch on youtube"]
[null,null,"Advanced feature \"mass import of projects\"",null,null,null,null,null,null,"<<<<< klick here to watch on youtube"]
[null,null,"SuperAdvanced Feature \"anonymous export\"",null,null,null,null,null,null,"<<<<< klick here to watch on youtube"]
[]
[null,null,"Introduction in how to use the SmartPipliner with a real case data - stagger a big portfolio in 40'",null,null,null,null,null,null,"<<<<< HowTo fix/stagger a full portfolio - do Lean Portfolio Management"]
[]
[null,null,"Introduction into the basic \"EssentialFlow\"-Features",null,null,null,null,null,null,"< new < HowTo manage a protfolio without detailed projects plans - yes it works!"]
[null,null,"More details about Essential Flow - The Website",null,null,null,null,null,null,"< Home of Essential Flow"]
[null,null,"Request the full EssentialFlow Documentation",null,null,null,null,null,null,"< Specification - all CC-BY-SA so free to use and enhance"]
[]
[null,null,"How to prepare \"Trade of Descisions\" with the SmartPipeliner",null,null,null,null,null,null,"(prior Version and German only - sorry - if enyone want's to translate - very welcome)"]
[null,null,"How to do \"Business Value Optization\" with the SmartPipliner based on Throughput Accounting",null,null,null,null,null,null,"(prior Version and German only - sorry - if enyone want's to translate - very welcome)"]
[]
[null,"license:"]
[]
[]
[null,"Creative Commons BY-SA 4.0"]
[]
[null,"V3.0.0","2023-01-04",null,"Essential Flow Release"]
[null,"* teams can be marked as virtual drum (get a \"*\" as first character)"]
[null,"* there is a roadmap few - here you can see the projects start, end like a gantt chart with the month market in organce when the project is in a virtual drum active"]
[null,"* in the project list you see after generation the TBP all project delimiting dates - start/end & entry/exit of the constraint (if it touches a virtual constraint team)"]
[null,"* in the project list you find also a basic execution management - out of the status and date there are quite some messages generated that show what to do"]
[null,"* as last new section you'll find some very basic columns for doing buffer regain management that can also be used for continous improvement"]
[]
[null,"v2.2.1","2022-09-17"," ","Ken-sent-me-Release"]
[null,"* anonymous export of all data to a workbook called \"anonymous_...\" to possibility to get external feedback and help"]
[]
[null,"v2.1.3","2022-09-11"]
[null,"* new tutorial video that shows how to use the SmartPipeliner to fix/stagger a whole portfolio in a few minutes - based on a real case with real (anonymous) data"]
[null,"* smaller text changes for better understanding"]
[null,"* Lets MoveItMoveIt is now a button on the TBP"]
[null,"* simple switch between \"simple\" and \"detailed\" capacity model - simple is just \"PersonDays per Year / 12 months\", detailed \"concerning typ. vacation, illness and bank holidays\" - just a switch in CapacityModel"]
[]
[null,"v2.1.2","2022-09-05"]
[null,"* import script added - generates PRJ_sheets out of data in sheet \"import\""]
[]
[null,"v2.0.7","2021-01-21"]
[null,"* small fix for drawing load diagrams in international excel versions"]
[]
[null,"v2.0.6","2020-09-09"]
[null,"* small fix of the automatic timeline in TeamList and the appropriate CapacityData"]
[]
[null,"v2.0.5","2018-08-21"]
[null,"* downwards compatible to Excel 2010"]
[]
[null,"v2.0.4","2018-08-17"]
[null,"* relative Load shown in extra sheet \"TBP%\" including diagram of load over time and project"]
[null,"* capacity for relative load is reduced by all \"Projects\" not starting with \"PRJ_\" … so you can use une \"Projects\" to manage vacation or such things"]
[]
[null,"v1.22","2016-08-29"]
[null,"* bug in INIDIRECT funktion bei Excel 2010 fixed … INDEX ist wohl besser"]
[]
[null,"v1.21","2014-08-03"]
[null,"* backlink from project sheets to project list - small but useful"]
[]
[null,"v1.20","2014-07-11"]
[null,"* year overspanning CapacityModel, CapacityData and FTE-Table in Teamlist"]
[]
[null,"v1.19","2013-11-17"]
[null,"* colours for projects"]
[null,"* some spaces for better readable TBP"]
[]
[null,"v1.18","2013-05-15"]
[null,"* with functionality to move projects quickly out of TBP - just enter the number of month to be shifted directly after the last month of a project - and excute the marcoe ILikeToMoveItMoveIt ;-)"]
[]
[null,"v1.17","2013-01-21"]
[null,"* including complete capacity model "]

{"sheet":"TBP","index":1,"n_rows":2009,"n_cols":27,"rows_kept":2009,"cut":false,"hidden":false,"merged":[]}
["Team Balancing Plan"]
[{"$f":"\"Version: \"&TEXT(TODAY(),\"JJJJ-MM-TT\")","v":"Version: 2023-03-12"}]
[]
["T_QA","Quality Assurance (Michael Meier)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",null,8,10,9,2]
[null,"Testprojekt #2 (PRJ_Test #2)",null,null,5,5,10,10,20,5]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,5,10,5]
[null,"Testprojekt #4 (PRJ_Test #4)",null,null,null,null,null,null,null,null,null,8,10,9,2]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,null,5,5,10,10,15,5]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,10,5]
[null,"> load per month",{"$f":"SUM(C5:C10)","v":0},8,15,14,12,10,20,10,10,13,10,14,7,10,10,20,15,5]
[null,"> capacity per month",14.989698795180722,14.695783132530117,15.934427710843373,13.100240963855422,14.415863453815261,14.548825301204818,15.136656626506021,15.290612449799193,13.960993975903612,14.989698795180722,15.283614457831323,11.833604417670681,15.578366533864541,15.307619521912352,13.745617529880475,15.161832669322711,13.58594621513944,13.745617529880475]
[null,"> aggregated overload",{"$f":"IF(C11>C12,C11-C12,0)","v":0},{"$f":"IF((D11+C13)>D12,D11+C13-D12,0)","v":0},0,0.89975903614457842,0,0,4.8633433734939793,0,0,0,0,2.1663955823293186,0,0,0,4.8381673306772885,6.2522211155378464,0]
[null,"> load factor",{"$f":"C11/C12","v":0},0.54437384709981562,0.94135793717853478,1.0686826325276828,0.83241631959437812,0.6873407160351207,1.3212957453879022,0.65399604056614014,0.71628137776291534,0.86726225640901988,0.65429548930266301,1.1830714891140286,0.44934107724216599,0.65326943785644331,0.72750460124922123,1.3191017495178181,1.1040820979612604,0.36375230062461061,{"$f":"AVERAGE(C14:T14)","v":0.78263472863498462}]
[]
["T_DEV","Development (Hans Huber)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",10,25,20,10,2]
[null,"Testprojekt #2 (PRJ_Test #2)",null,10,10,25,30,30,20,5]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,10,10,10]
[null,"Testprojekt #4 (PRJ_Test #4)",null,null,null,null,null,null,null,null,10,25,20,10,2]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,10,10,25,30,30,20,5]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10]
[null,"> load per month",{"$f":"SUM(C17:C22)","v":10},35,30,35,32,30,20,15,20,35,30,20,27,30,30,30,15,10]
[null,"> capacity per month",46.291716867469873,45.384036144578303,49.20926204819277,40.456626506024101,44.519578313253014,44.930195783132525,46.745557228915651,47.221009036144565,43.114834337349393,46.291716867469873,47.199397590361443,36.544954819277109,48.109661354581668,47.273530876494029,42.449701195219113,46.823306772908374,41.956598605577682,42.449701195219113]
[null,"> aggregated overload",{"$f":"IF(C23>C24,C23-C24,0)","v":0},{"$f":"IF((D23+C25)>D24,D23+C25-D24,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"> load factor",{"$f":"C23/C24","v":0.21602136789675222},0.77119628339140556,0.60964133074419391,0.86512403585574305,0.71878488549101849,0.66770240986268869,0.4278481461256064,0.31765521970355376,0.46387746369407845,0.75607478763863278,0.63560133246544404,0.54727116503233963,0.56121783524939917,0.63460459677483061,0.70671875549924346,0.64070656405151172,0.3575122983874558,0.23557291849974782,{"$f":"AVERAGE(C26:T26)","v":0.56295174424242467}]
[]
["T_PM","Product Management (Franz Weber)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",12,2]
[null,"Testprojekt #2 (PRJ_Test #2)",null,15,10,5,null,2,2]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,5,2,2]
[null,"Testprojekt #4 (PRJ_Test #4)",null,null,null,null,null,null,null,null,12,2]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,15,10,5,null,2,2]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,2,2]
[null,"> load per month",{"$f":"SUM(C29:C34)","v":12},17,10,5,0,2,2,5,14,4,15,10,5,0,2,7,2,2]
[null,"> capacity per month",17.634939759036143,17.289156626506021,18.746385542168674,15.412048192771085,16.959839357429718,17.116265060240963,17.807831325301201,17.988955823293168,16.424698795180721,17.634939759036143,17.980722891566263,13.921887550200802,18.327490039840637,18.008964143426297,16.171314741035854,17.83745019920319,15.983466135458166,16.171314741035854]
[null,"> aggregated overload",{"$f":"IF(C35>C36,C35-C36,0)","v":0},{"$f":"IF((D35+C37)>D36,D35+C37-D36,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"> load factor",{"$f":"C35/C36","v":0.68046730887476947},0.98327526132404197,0.5334361644011697,0.3244215134459037,0,0.11684792172597051,0.11231013835797167,0.27794831724060953,0.85237483953786919,0.22682243629158982,0.83422674886089532,0.71829340410494591,0.2728142254684579,0,0.12367578221236759,0.3924327704815509,0.12512930443560952,0.12367578221236759,{"$f":"AVERAGE(C38:T38)","v":0.37211955105422717}]
[]
["* VirtualDrum","Virtual Team for Concept & Integration (Super Man)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",null,1]
[null,"Testprojekt #2 (PRJ_Test #2)",null,null,null,2,1]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,null,1]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,null,null,2,1]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"> load per month",{"$f":"SUM(C41:C45)","v":0},1,0,2,1,0,0,0,1,0,0,0,2,1,0,0,1,0]
[null,"> capacity per month",1,2,2,2,2,2,2,1,1,2,2,1,1,2,2,2,2,2]
[null,"> aggregated overload",{"$f":"IF(C46>C47,C46-C47,0)","v":0},{"$f":"IF((D46+C48)>D47,D46+C48-D47,0)","v":0},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0]
[null,"> load factor",{"$f":"C46/C47","v":0},0.5,0,1,0.5,0,0,0,1,0,0,0,2,0.5,0,0,0.5,0,{"$f":"AVERAGE(C49:T49)","v":0.33333333333333331}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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":"AVERAGE(C1973:Z1973)","v":{"$error":"#DIV/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,{"$f":"AVERAGE(C1985:Z1985)","v":{"$error":"#DIV/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,{"$f":"AVERAGE(C1997:Z1997)","v":{"$error":"#DIV/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,{"$f":"AVERAGE(C2009:Z2009)","v":{"$error":"#DIV/0!"}}]

{"sheet":"TBP%","index":2,"n_rows":2014,"n_cols":27,"rows_kept":2014,"cut":false,"hidden":false,"merged":[]}
["Team Balancing Plan"]
[{"$f":"\"Version: \"&TEXT(TODAY(),\"JJJJ-MM-TT\")","v":"Version: 2023-03-12"}]
[]
["T_QA","Quality Assurance (Michael Meier)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",null,0.54437384709981562,0.62757195811902322,0.68701026376779606,0.13873605326572969]
[null,"Testprojekt #2 (PRJ_Test #2)",null,null,0.31378597905951161,0.38167236875988669,0.69368026632864843,0.6873407160351207,1.3212957453879022,0.32699802028307007]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,0.32699802028307007,0.71628137776291534,0.33356240631116152]
[null,"Testprojekt #4 (PRJ_Test #4)",null,null,null,null,null,null,null,null,null,0.53369985009785836,0.65429548930266301,0.76054595728758978,0.12838316492633314]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,null,0.42252553182643876,0.32095791231583282,0.65326943785644331,0.72750460124922123,0.98932631213836364,0.36802736598708685]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32977543737945453,0.7360547319741737,0.36375230062461061]
[]
[]
[]
[]
[]
[]
[]
[]
["T_DEV","Development (Hans Huber)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",0.21602136789675222,0.55085448813671822,0.40642755382946266,0.24717829595878374,4.4924055343188656E-2]
[null,"Testprojekt #2 (PRJ_Test #2)",null,0.22034179525468728,0.20321377691473133,0.61794573989695933,0.67386083014782994,0.66770240986268869,0.4278481461256064,0.10588507323451793]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,0.21177014646903586,0.23193873184703923,0.21602136789675222]
[null,"Testprojekt #4 (PRJ_Test #4)",null,null,null,null,null,null,null,null,0.23193873184703923,0.54005341974188059,0.42373422164362934,0.27363558251616982,4.1571691499955495E-2]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,0.21186711082181467,0.27363558251616982,0.51964614374944362,0.63460459677483061,0.70671875549924346,0.42713770936767448,0.11917076612915194]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21356885468383724,0.23834153225830387,0.23557291849974782]
[]
[]
[]
[]
[]
[]
[]
[]
["T_PM","Product Management (Franz Weber)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",0.68046730887476947,0.11567944250871083]
[null,"Testprojekt #2 (PRJ_Test #2)",null,0.86759581881533121,0.5334361644011697,0.3244215134459037,null,0.11684792172597051,0.11231013835797167]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,0.27794831724060953,0.1217678342196956,0.11341121814579491]
[null,"Testprojekt #4 (PRJ_Test #4)",null,null,null,null,null,null,null,null,0.73060700531817357,0.11341121814579491]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,0.83422674886089532,0.71829340410494591,0.2728142254684579,null,0.12367578221236759,0.11212364870901455]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28030912177253636,0.12512930443560952,0.12367578221236759]
[]
[]
[]
[]
[]
[]
[]
[]
["* VirtualDrum","Virtual Team for Concept & Integration (Super Man)",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
[null,"Testprojekt #1 (PRJ_Test #1)",null,0.5]
[null,"Testprojekt #2 (PRJ_Test #2)",null,null,null,1,0.5]
[null,"Testprojekt #3 (PRJ_Test #3)",null,null,null,null,null,null,null,null,1]
[null,"Testprojekt #5 (PRJ_Test #5)",null,null,null,null,null,null,null,null,null,null,null,null,2,0.5]
[null,"Testprojekt #6 (PRJ_Test #6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,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":"AVERAGE(C1978:Z1978)","v":{"$error":"#DIV/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,{"$f":"AVERAGE(C1990:Z1990)","v":{"$error":"#DIV/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,{"$f":"AVERAGE(C2002:Z2002)","v":{"$error":"#DIV/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,{"$f":"AVERAGE(C2014:Z2014)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Roadmap","index":3,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Roadmap"]
[{"$f":"\"Version: \"&TEXT(TODAY(),\"JJJJ-MM-TT\")","v":"Version: 2023-03-12"}]
[null,null,"Constraint Entry/Exit Month"]
["PrjID","Project","EntryOffset","ExitOffset",{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2023-01"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2023-02"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2023-03"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2023-04"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2023-05"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2023-06"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(7,\"00\")","v":"2023-07"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(8,\"00\")","v":"2023-08"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(9,\"00\")","v":"2023-09"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(10,\"00\")","v":"2023-10"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(11,\"00\")","v":"2023-11"},{"$f":"TEXT(2023,\"0000\")&\"-\"&TEXT(12,\"00\")","v":"2023-12"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(1,\"00\")","v":"2024-01"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(2,\"00\")","v":"2024-02"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(3,\"00\")","v":"2024-03"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(4,\"00\")","v":"2024-04"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(5,\"00\")","v":"2024-05"},{"$f":"TEXT(2024,\"0000\")&\"-\"&TEXT(6,\"00\")","v":"2024-06"}]
["PRJ_Test #1","Testprojekt #1",1,1,22,36,30,19,4]
["PRJ_Test #2","Testprojekt #2",3,4,null,25,25,37,41,42,42,10]
["PRJ_Test #3","Testprojekt #3",8,8,null,null,null,null,null,null,null,20,23,17]
["PRJ_Test #4","Testprojekt #4",null,null,null,null,null,null,null,null,null,null,22,35,30,19,4]
["PRJ_Test #5","Testprojekt #5",12,13,null,null,null,null,null,null,null,null,null,null,25,25,37,41,42,37,10]
["PRJ_Test #6","Testprojekt #6",16,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,23,17]

{"sheet":"Tabelle1","index":4,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Project: Description","Project: Priority","Project: Project end date (End)","Task: Task type","Task: Description","Task: Predecessor(s)","Task: Fill color","Task: Duration (d)","Skill: Description","Resource assignment: Units","Resource assignment: Duration (d)"]
["PRJ_Andro Lion HS SL930 Projekt_025",50,null,"Stage","Lead",null,"RGB(9F,C6,E1)",61]
["PRJ_Andro Lion HS SL930 Projekt_025",null,null,"VirtualDrum","Critical","Lead","Yellow",81,"ST_WRO",2,81]
["PRJ_Andro Lion HS SL930 Projekt_025",null,null,"Stage","Lag","Critical","RGB(92,D0,50)",8]
["PRJ_BoSuLiTu&Co BS Projekt_022",50,null,"Stage","Lead",null,"RGB(9F,C6,E1)",43]
["PRJ_BoSuLiTu&Co BS Projekt_022",null,null,"VirtualDrum","Critical","Lead","Yellow",57,"ST_WRO",2,57]
["PRJ_BoSuLiTu&Co BS Projekt_022",null,null,"Stage","Lag","Critical","RGB(92,D0,50)",6]
["PRJ_Calypso Projekt_034",50,null,"Stage","Lead",null,"RGB(9F,C6,E1)",31]
["PRJ_Calypso Projekt_034",null,null,"VirtualDrum","Critical","Lead","Yellow",41,"ST_WRO",2,41]
["PRJ_Calypso Projekt_034",null,null,"Stage","Lag","Critical","RGB(92,D0,50)",4]
["PRJ_Comp Trans BCH to WRO Projekt_013",50,null,"Stage","Lead",null,"RGB(9F,C6,E1)",34]
["PRJ_Comp Trans BCH to WRO Projekt_013",null,null,"VirtualDrum","Critical","Lead","Yellow",45,"ST_WRO",2,45]
["PRJ_Comp Trans BCH to WRO Projekt_013",null,null,"Stage","Lag","Critical","RGB(92,D0,50)",5]
["PRJ_Coral HS Projekt_023",50,null,"Stage","Lead",null,"RGB(9F,C6,E1)",76]
["PRJ_Coral HS Projekt_023",null,null,"VirtualDrum","Critical","Lead","Yellow",101,"ST_WRO",2,101]
["PRJ_Coral HS Projekt_023",null,null,"Stage","Lag","Critical","RGB(92,D0,50)",10]
["PRJ_Einstein Rel. 2.1 Projekt_027",50,null,"Stage","Lead",null,"RGB(9F,C6,E1)",4]
["PRJ_Einstein Rel. 2.1 Projekt_027",null,null,"VirtualDrum","Critical","Lead","Yellow",5,"ST_WRO",1,5]
["PRJ_Einstein Rel. 2.1 Projekt_027",null,null,"Stage","Lag","Critical","RGB(92,D0,50)",1]
["PRJ_Einstein Rel. 2.2 Projekt_031",50,null,"Stage","Lead",null,"RGB(9F,C6,E1)",55]
["PRJ_Einstein Rel. 2.2 Projekt_031",null,null,"VirtualDrum","Critical","Lead","Yellow",73,"ST_WRO",2,73]
["PRJ_Einstein Rel. 2.2 Projekt_031",null,null,"Stage","Lag","Critical","RGB(92,D0,50)",7]

{"sheet":"ProjectList","index":5,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Project List",null,null,null,null,null,null,null,null,null,null,null,null,"Version/Today"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-21",{"$f":"IF(today<TODAY(),\"maybe this report is outdated - if you want to generate a up-to-date report change date to the current date\",\"\")","v":"maybe this report is outdated - if you want to generate a up-to-date report change date to the current date"}]
["TBP-Start-Year",2023]
["TBP-Start-Month",1]
["TBP-Duration",18]
["TBP-Active-Level",1,"Active-Level of project has to be higher or equal",null,null,null,null,null,null,null,null,null,null,"execution management"]
[null,null,null,null,null,null,null,null,"resulting project delimiter",null,null,null,null,"status",null,null,"hint",null,"action"]
["Project-ID (Sheet)","Project","Start-Year","Start-Month","Active-Level","Col","GoTo",null,"Start","Enter-Constr.","Exit-Constr.","End",null,"Date of Status","Project Phase","Remaining Working \nDays in Phase","Pay Attention",null,"Phase Overrun in \nCalendar Days","Meassures to regain overspent time …"]
["PRJ_Test #1","Testprojekt #1",2023,1,2,null,{"$f":"HYPERLINK(\"#'\"&A9&\"'!A1\",\"sheet\")","v":"sheet"},null,{"$f":"DATE(C9+INT(D9/12),MOD(D9,12),1)","v":"2023-01-01"},"2023-02-01","2023-02-28","2023-05-31",null,"2023-02-21","IC (in constraint)",10,{"$f":"GenerateMessageOutOfStatus(today,I9,J9,K9,L9,N9,O9,P9)","v":"Current Phase End exceeds planning by [7] days"},null,{"$f":"IF(ISNUMBER(FIND(\"]\",Q9)),VALUE(MID(Q9,FIND(\"[\",Q9)+1,FIND(\"]\",Q9)-FIND(\"[\",Q9)-1)),\"---\")","v":7},"Mr. Meier - we are looking for a technical new solution - i will show result in two days … root cause: one of our server crashed and we need a new one"]
["PRJ_Test #2","Testprojekt #2",2023,2,2,null,"sheet",null,"2023-02-01","2023-04-01","2023-05-31","2023-08-31",null,"2023-02-20","IC (in constraint)",0,"---",null,"---"]
["PRJ_Test #3","Testprojekt #3",2023,8,2,null,"sheet",null,"2023-08-01","2023-09-01","2023-09-30","2023-10-31",null,null,null,0,"---",null,"---"]
["PRJ_Test #4","Testprojekt #4",2023,9,1,null,"sheet",null,"2023-09-01",null,null,"2024-01-31",null,null,null,0,"---",null,"---"]
["PRJ_Test #5","Testprojekt #5",2023,11,1,null,"sheet",null,"2023-11-01","2024-01-01","2024-02-29","2024-05-31",null,null,null,0,"---",null,"---"]
["PRJ_Test #6","Testprojekt #6",2023,16,1,null,"sheet",null,"2024-04-01","2024-05-01","2024-05-31","2024-06-30",null,null,null,0,"---",null,"---"]

{"sheet":"TeamList","index":6,"n_rows":5,"n_cols":29,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Team-ID","Team","Team-Lead","SkillClass","average load","aggregated load",null,"Line","Notes","Project  Quota","2023-01",{"$f":"IF(RIGHT(K1,2)=\"12\",TEXT(VALUE(LEFT(K1,4))+1,\"0\")&\"-01\",LEFT(K1,4)&\"-\"&TEXT(VALUE(RIGHT(K1,2))+1,\"00\"))","v":"2023-02"},{"$f":"IF(RIGHT(L1,2)=\"12\",TEXT(VALUE(LEFT(L1,4))+1,\"0\")&\"-01\",LEFT(L1,4)&\"-\"&TEXT(VALUE(RIGHT(L1,2))+1,\"00\"))","v":"2023-03"},"2023-04","2023-05","2023-06","2023-07","2023-08","2023-09","2023-10","2023-11","2023-12","2024-01","2024-02","2024-03","2024-04","2024-05","2024-06","2024-07"]
["T_QA","Quality Assurance","Michael Meier","Quality",0.78263472863498462,0,null,{"$f":"ROW(A2)","v":2},null,0.85,1,{"$f":"K2","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["T_DEV","Development","Hans Huber","Development",0.56295174424242467,0,null,{"$f":"ROW(A3)","v":3},null,0.75,3.5,{"$f":"K3","v":3.5},{"$f":"L3","v":3.5},{"$f":"M3","v":3.5},{"$f":"N3","v":3.5},{"$f":"O3","v":3.5},{"$f":"P3","v":3.5},{"$f":"Q3","v":3.5},{"$f":"R3","v":3.5},{"$f":"S3","v":3.5},{"$f":"T3","v":3.5},{"$f":"U3","v":3.5},{"$f":"V3","v":3.5},{"$f":"W3","v":3.5},{"$f":"X3","v":3.5},{"$f":"Y3","v":3.5},{"$f":"Z3","v":3.5},{"$f":"AA3","v":3.5},{"$f":"AB3","v":3.5}]
["T_PM","Product Management","Franz Weber","ProductManagement",0.37211955105422717,0,null,{"$f":"ROW(A4)","v":4},null,1,1,{"$f":"K4","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["* VirtualDrum","Virtual Team for Concept & Integration","Super Man","VirtualDrum",0.33333333333333331,0,null,5,null,1,2,{"$f":"K5","v":2},{"$f":"L5","v":2},2,2,2,2,2,2,{"$f":"S5","v":2},2,2,2,2,2,2,2,2,2]

{"sheet":"CapacityData","index":7,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Team-ID","Year","Month","Capacity",null,"Sort Order (Line)","Working Days per Month","Project Quota for Team","Offset in FTE-Table in Teamlist","FTE for Team for Month",null,"ListOfAll SkillClasses"]
["T_PM",{"$f":"VALUE(LEFT(TeamList!K1,4))","v":2023},{"$f":"VALUE(RIGHT(TeamList!K1,2))","v":1},{"$f":"G2*H2*J2","v":17.634939759036143},null,{"$f":"VLOOKUP(A2,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B2&\"-\"&TEXT(C2,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.634939759036143},{"$f":"VLOOKUP(A2,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B2*12+C2-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":0},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A2,TeamList!A:K,8,FALSE),11+I2)","v":1},null,"C-Level/CxO"]
["T_PM",{"$f":"IF(C2=12,B2+1,B2)","v":2023},{"$f":"IF(C2=12,1,C2+1)","v":2},{"$f":"G3*H3*J3","v":17.289156626506021},null,{"$f":"VLOOKUP(A3,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B3&\"-\"&TEXT(C3,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.289156626506021},{"$f":"VLOOKUP(A3,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B3*12+C3-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":1},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A3,TeamList!A:K,8,FALSE),11+I3)","v":1},null,"Marketing"]
["T_PM",{"$f":"IF(C3=12,B3+1,B3)","v":2023},{"$f":"IF(C3=12,1,C3+1)","v":3},18.746385542168674,null,{"$f":"VLOOKUP(A4,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B4&\"-\"&TEXT(C4,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.746385542168674},{"$f":"VLOOKUP(A4,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B4*12+C4-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":2},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A4,TeamList!A:K,8,FALSE),11+I4)","v":1},null,"Sales"]
["T_PM",2023,4,15.412048192771085,null,{"$f":"VLOOKUP(A5,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B5&\"-\"&TEXT(C5,\"00\"),CapacityModel!A:G,7,FALSE)","v":15.412048192771085},{"$f":"VLOOKUP(A5,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B5*12+C5-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":3},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A5,TeamList!A:K,8,FALSE),11+I5)","v":1},null,"FunctionalDepartment"]
["T_PM",2023,5,16.959839357429718,null,{"$f":"VLOOKUP(A6,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B6&\"-\"&TEXT(C6,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.959839357429718},{"$f":"VLOOKUP(A6,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B6*12+C6-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":4},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A6,TeamList!A:K,8,FALSE),11+I6)","v":1},null,"ProductManagement"]
["T_PM",2023,6,17.116265060240963,null,{"$f":"VLOOKUP(A7,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B7&\"-\"&TEXT(C7,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.116265060240963},{"$f":"VLOOKUP(A7,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B7*12+C7-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":5},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A7,TeamList!A:K,8,FALSE),11+I7)","v":1},null,"ProjectManagement"]
["T_PM",2023,7,17.807831325301201,null,{"$f":"VLOOKUP(A8,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B8&\"-\"&TEXT(C8,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.807831325301201},{"$f":"VLOOKUP(A8,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B8*12+C8-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":6},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A8,TeamList!A:K,8,FALSE),11+I8)","v":1},null,"Development"]
["T_PM",2023,8,17.988955823293168,null,{"$f":"VLOOKUP(A9,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B9&\"-\"&TEXT(C9,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.988955823293168},{"$f":"VLOOKUP(A9,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B9*12+C9-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":7},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A9,TeamList!A:K,8,FALSE),11+I9)","v":1},null,"ElectronikDevelopment"]
["T_PM",2023,9,16.424698795180721,null,{"$f":"VLOOKUP(A10,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B10&\"-\"&TEXT(C10,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.424698795180721},{"$f":"VLOOKUP(A10,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B10*12+C10-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":8},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A10,TeamList!A:K,8,FALSE),11+I10)","v":1},null,"MechanicDevelopment"]
["T_PM",2023,10,17.634939759036143,null,{"$f":"VLOOKUP(A11,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B11&\"-\"&TEXT(C11,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.634939759036143},{"$f":"VLOOKUP(A11,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B11*12+C11-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":9},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A11,TeamList!A:K,8,FALSE),11+I11)","v":1},null,"SoftwareDevelopment"]
["T_PM",2023,11,17.980722891566263,null,{"$f":"VLOOKUP(A12,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B12&\"-\"&TEXT(C12,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.980722891566263},{"$f":"VLOOKUP(A12,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B12*12+C12-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":10},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A12,TeamList!A:K,8,FALSE),11+I12)","v":1},null,"Quality"]
["T_PM",2023,12,13.921887550200802,null,{"$f":"VLOOKUP(A13,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B13&\"-\"&TEXT(C13,\"00\"),CapacityModel!A:G,7,FALSE)","v":13.921887550200802},{"$f":"VLOOKUP(A13,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B13*12+C13-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":11},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A13,TeamList!A:K,8,FALSE),11+I13)","v":1},null,"Industrialization"]
["T_PM",2024,1,18.327490039840637,null,{"$f":"VLOOKUP(A14,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B14&\"-\"&TEXT(C14,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.327490039840637},{"$f":"VLOOKUP(A14,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B14*12+C14-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":12},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A14,TeamList!A:K,8,FALSE),11+I14)","v":1},null,"Production"]
["T_PM",2024,2,18.008964143426297,null,{"$f":"VLOOKUP(A15,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B15&\"-\"&TEXT(C15,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.008964143426297},{"$f":"VLOOKUP(A15,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B15*12+C15-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":13},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A15,TeamList!A:K,8,FALSE),11+I15)","v":1},null,"Support/CustomerCare"]
["T_PM",2024,3,16.171314741035854,null,{"$f":"VLOOKUP(A16,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B16&\"-\"&TEXT(C16,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.171314741035854},{"$f":"VLOOKUP(A16,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B16*12+C16-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":14},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A16,TeamList!A:K,8,FALSE),11+I16)","v":1},null,"Purchase"]
["T_PM",2024,4,17.83745019920319,null,{"$f":"VLOOKUP(A17,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B17&\"-\"&TEXT(C17,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.83745019920319},{"$f":"VLOOKUP(A17,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B17*12+C17-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":15},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A17,TeamList!A:K,8,FALSE),11+I17)","v":1},null,"SupplyChain/Logistics"]
["T_PM",2024,5,15.983466135458166,null,{"$f":"VLOOKUP(A18,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B18&\"-\"&TEXT(C18,\"00\"),CapacityModel!A:G,7,FALSE)","v":15.983466135458166},{"$f":"VLOOKUP(A18,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B18*12+C18-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":16},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A18,TeamList!A:K,8,FALSE),11+I18)","v":1},null,"HumanRessources"]
["T_PM",2024,6,16.171314741035854,null,{"$f":"VLOOKUP(A19,TeamList!A:I,8,FALSE)","v":4},{"$f":"VLOOKUP(B19&\"-\"&TEXT(C19,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.171314741035854},{"$f":"VLOOKUP(A19,TeamList!A:K,10,FALSE)","v":1},{"$f":"(B19*12+C19-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":17},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A19,TeamList!A:K,8,FALSE),11+I19)","v":1},null,"Controlling"]
["T_DEV",{"$f":"B2","v":2023},{"$f":"C2","v":1},46.291716867469873,null,{"$f":"VLOOKUP(A20,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B20&\"-\"&TEXT(C20,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.634939759036143},{"$f":"VLOOKUP(A20,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B20*12+C20-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":0},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A20,TeamList!A:K,8,FALSE),11+I20)","v":3.5},null,"Compliance"]
["T_DEV",{"$f":"B3","v":2023},2,45.384036144578303,null,{"$f":"VLOOKUP(A21,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B21&\"-\"&TEXT(C21,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.289156626506021},{"$f":"VLOOKUP(A21,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B21*12+C21-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":1},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A21,TeamList!A:K,8,FALSE),11+I21)","v":3.5},null,"Legal"]
["T_DEV",{"$f":"B4","v":2023},3,49.20926204819277,null,{"$f":"VLOOKUP(A22,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B22&\"-\"&TEXT(C22,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.746385542168674},{"$f":"VLOOKUP(A22,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B22*12+C22-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":2},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A22,TeamList!A:K,8,FALSE),11+I22)","v":3.5},null,"VirtualDrum"]
["T_DEV",{"$f":"B5","v":2023},4,40.456626506024101,null,{"$f":"VLOOKUP(A23,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B23&\"-\"&TEXT(C23,\"00\"),CapacityModel!A:G,7,FALSE)","v":15.412048192771085},{"$f":"VLOOKUP(A23,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B23*12+C23-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":3},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A23,TeamList!A:K,8,FALSE),11+I23)","v":3.5}]
["T_DEV",{"$f":"B6","v":2023},5,44.519578313253014,null,{"$f":"VLOOKUP(A24,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B24&\"-\"&TEXT(C24,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.959839357429718},{"$f":"VLOOKUP(A24,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B24*12+C24-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":4},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A24,TeamList!A:K,8,FALSE),11+I24)","v":3.5}]
["T_DEV",{"$f":"B7","v":2023},6,44.930195783132525,null,{"$f":"VLOOKUP(A25,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B25&\"-\"&TEXT(C25,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.116265060240963},{"$f":"VLOOKUP(A25,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B25*12+C25-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":5},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A25,TeamList!A:K,8,FALSE),11+I25)","v":3.5}]
["T_DEV",{"$f":"B8","v":2023},7,46.745557228915651,null,{"$f":"VLOOKUP(A26,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B26&\"-\"&TEXT(C26,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.807831325301201},{"$f":"VLOOKUP(A26,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B26*12+C26-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":6},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A26,TeamList!A:K,8,FALSE),11+I26)","v":3.5}]
["T_DEV",{"$f":"B9","v":2023},8,47.221009036144565,null,{"$f":"VLOOKUP(A27,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B27&\"-\"&TEXT(C27,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.988955823293168},{"$f":"VLOOKUP(A27,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B27*12+C27-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":7},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A27,TeamList!A:K,8,FALSE),11+I27)","v":3.5}]
["T_DEV",{"$f":"B10","v":2023},9,43.114834337349393,null,{"$f":"VLOOKUP(A28,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B28&\"-\"&TEXT(C28,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.424698795180721},{"$f":"VLOOKUP(A28,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B28*12+C28-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":8},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A28,TeamList!A:K,8,FALSE),11+I28)","v":3.5}]
["T_DEV",{"$f":"B11","v":2023},10,46.291716867469873,null,{"$f":"VLOOKUP(A29,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B29&\"-\"&TEXT(C29,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.634939759036143},{"$f":"VLOOKUP(A29,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B29*12+C29-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":9},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A29,TeamList!A:K,8,FALSE),11+I29)","v":3.5}]
["T_DEV",{"$f":"B12","v":2023},11,47.199397590361443,null,{"$f":"VLOOKUP(A30,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B30&\"-\"&TEXT(C30,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.980722891566263},{"$f":"VLOOKUP(A30,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B30*12+C30-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":10},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A30,TeamList!A:K,8,FALSE),11+I30)","v":3.5}]
["T_DEV",{"$f":"B13","v":2023},12,36.544954819277109,null,{"$f":"VLOOKUP(A31,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B31&\"-\"&TEXT(C31,\"00\"),CapacityModel!A:G,7,FALSE)","v":13.921887550200802},{"$f":"VLOOKUP(A31,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B31*12+C31-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":11},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A31,TeamList!A:K,8,FALSE),11+I31)","v":3.5}]
["T_DEV",{"$f":"B14","v":2024},1,48.109661354581668,null,{"$f":"VLOOKUP(A32,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B32&\"-\"&TEXT(C32,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.327490039840637},{"$f":"VLOOKUP(A32,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B32*12+C32-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":12},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A32,TeamList!A:K,8,FALSE),11+I32)","v":3.5}]
["T_DEV",{"$f":"B15","v":2024},2,47.273530876494029,null,{"$f":"VLOOKUP(A33,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B33&\"-\"&TEXT(C33,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.008964143426297},{"$f":"VLOOKUP(A33,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B33*12+C33-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":13},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A33,TeamList!A:K,8,FALSE),11+I33)","v":3.5}]
["T_DEV",{"$f":"B16","v":2024},3,42.449701195219113,null,{"$f":"VLOOKUP(A34,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B34&\"-\"&TEXT(C34,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.171314741035854},{"$f":"VLOOKUP(A34,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B34*12+C34-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":14},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A34,TeamList!A:K,8,FALSE),11+I34)","v":3.5}]
["T_DEV",{"$f":"B17","v":2024},4,46.823306772908374,null,{"$f":"VLOOKUP(A35,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B35&\"-\"&TEXT(C35,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.83745019920319},{"$f":"VLOOKUP(A35,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B35*12+C35-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":15},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A35,TeamList!A:K,8,FALSE),11+I35)","v":3.5}]
["T_DEV",{"$f":"B18","v":2024},5,41.956598605577682,null,{"$f":"VLOOKUP(A36,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B36&\"-\"&TEXT(C36,\"00\"),CapacityModel!A:G,7,FALSE)","v":15.983466135458166},{"$f":"VLOOKUP(A36,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B36*12+C36-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":16},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A36,TeamList!A:K,8,FALSE),11+I36)","v":3.5}]
["T_DEV",{"$f":"B19","v":2024},6,42.449701195219113,null,{"$f":"VLOOKUP(A37,TeamList!A:I,8,FALSE)","v":3},{"$f":"VLOOKUP(B37&\"-\"&TEXT(C37,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.171314741035854},{"$f":"VLOOKUP(A37,TeamList!A:K,10,FALSE)","v":0.75},{"$f":"(B37*12+C37-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":17},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A37,TeamList!A:K,8,FALSE),11+I37)","v":3.5}]
["T_QA",{"$f":"B2","v":2023},{"$f":"C2","v":1},14.989698795180722,null,{"$f":"VLOOKUP(A38,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B38&\"-\"&TEXT(C38,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.634939759036143},{"$f":"VLOOKUP(A38,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B38*12+C38-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":0},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A38,TeamList!A:K,8,FALSE),11+I38)","v":1}]
["T_QA",{"$f":"B3","v":2023},2,14.695783132530117,null,{"$f":"VLOOKUP(A39,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B39&\"-\"&TEXT(C39,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.289156626506021},{"$f":"VLOOKUP(A39,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B39*12+C39-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":1},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A39,TeamList!A:K,8,FALSE),11+I39)","v":1}]
["T_QA",{"$f":"B4","v":2023},3,15.934427710843373,null,{"$f":"VLOOKUP(A40,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B40&\"-\"&TEXT(C40,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.746385542168674},{"$f":"VLOOKUP(A40,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B40*12+C40-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":2},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A40,TeamList!A:K,8,FALSE),11+I40)","v":1}]
["T_QA",{"$f":"B5","v":2023},4,13.100240963855422,null,{"$f":"VLOOKUP(A41,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B41&\"-\"&TEXT(C41,\"00\"),CapacityModel!A:G,7,FALSE)","v":15.412048192771085},{"$f":"VLOOKUP(A41,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B41*12+C41-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":3},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A41,TeamList!A:K,8,FALSE),11+I41)","v":1}]
["T_QA",{"$f":"B6","v":2023},5,14.415863453815261,null,{"$f":"VLOOKUP(A42,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B42&\"-\"&TEXT(C42,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.959839357429718},{"$f":"VLOOKUP(A42,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B42*12+C42-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":4},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A42,TeamList!A:K,8,FALSE),11+I42)","v":1}]
["T_QA",{"$f":"B7","v":2023},6,14.548825301204818,null,{"$f":"VLOOKUP(A43,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B43&\"-\"&TEXT(C43,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.116265060240963},{"$f":"VLOOKUP(A43,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B43*12+C43-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":5},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A43,TeamList!A:K,8,FALSE),11+I43)","v":1}]
["T_QA",{"$f":"B8","v":2023},7,15.136656626506021,null,{"$f":"VLOOKUP(A44,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B44&\"-\"&TEXT(C44,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.807831325301201},{"$f":"VLOOKUP(A44,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B44*12+C44-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":6},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A44,TeamList!A:K,8,FALSE),11+I44)","v":1}]
["T_QA",{"$f":"B9","v":2023},8,15.290612449799193,null,{"$f":"VLOOKUP(A45,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B45&\"-\"&TEXT(C45,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.988955823293168},{"$f":"VLOOKUP(A45,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B45*12+C45-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":7},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A45,TeamList!A:K,8,FALSE),11+I45)","v":1}]
["T_QA",{"$f":"B10","v":2023},9,13.960993975903612,null,{"$f":"VLOOKUP(A46,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B46&\"-\"&TEXT(C46,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.424698795180721},{"$f":"VLOOKUP(A46,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B46*12+C46-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":8},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A46,TeamList!A:K,8,FALSE),11+I46)","v":1}]
["T_QA",{"$f":"B11","v":2023},10,14.989698795180722,null,{"$f":"VLOOKUP(A47,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B47&\"-\"&TEXT(C47,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.634939759036143},{"$f":"VLOOKUP(A47,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B47*12+C47-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":9},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A47,TeamList!A:K,8,FALSE),11+I47)","v":1}]
["T_QA",{"$f":"B12","v":2023},11,15.283614457831323,null,{"$f":"VLOOKUP(A48,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B48&\"-\"&TEXT(C48,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.980722891566263},{"$f":"VLOOKUP(A48,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B48*12+C48-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":10},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A48,TeamList!A:K,8,FALSE),11+I48)","v":1}]
["T_QA",{"$f":"B13","v":2023},12,11.833604417670681,null,{"$f":"VLOOKUP(A49,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B49&\"-\"&TEXT(C49,\"00\"),CapacityModel!A:G,7,FALSE)","v":13.921887550200802},{"$f":"VLOOKUP(A49,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B49*12+C49-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":11},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A49,TeamList!A:K,8,FALSE),11+I49)","v":1}]
["T_QA",{"$f":"B14","v":2024},1,15.578366533864541,null,{"$f":"VLOOKUP(A50,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B50&\"-\"&TEXT(C50,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.327490039840637},{"$f":"VLOOKUP(A50,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B50*12+C50-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":12},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A50,TeamList!A:K,8,FALSE),11+I50)","v":1}]
["T_QA",{"$f":"B15","v":2024},2,15.307619521912352,null,{"$f":"VLOOKUP(A51,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B51&\"-\"&TEXT(C51,\"00\"),CapacityModel!A:G,7,FALSE)","v":18.008964143426297},{"$f":"VLOOKUP(A51,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B51*12+C51-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":13},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A51,TeamList!A:K,8,FALSE),11+I51)","v":1}]
["T_QA",{"$f":"B16","v":2024},3,13.745617529880475,null,{"$f":"VLOOKUP(A52,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B52&\"-\"&TEXT(C52,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.171314741035854},{"$f":"VLOOKUP(A52,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B52*12+C52-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":14},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A52,TeamList!A:K,8,FALSE),11+I52)","v":1}]
["T_QA",{"$f":"B17","v":2024},4,15.161832669322711,null,{"$f":"VLOOKUP(A53,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B53&\"-\"&TEXT(C53,\"00\"),CapacityModel!A:G,7,FALSE)","v":17.83745019920319},{"$f":"VLOOKUP(A53,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B53*12+C53-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":15},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A53,TeamList!A:K,8,FALSE),11+I53)","v":1}]
["T_QA",{"$f":"B18","v":2024},5,13.58594621513944,null,{"$f":"VLOOKUP(A54,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B54&\"-\"&TEXT(C54,\"00\"),CapacityModel!A:G,7,FALSE)","v":15.983466135458166},{"$f":"VLOOKUP(A54,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B54*12+C54-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":16},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A54,TeamList!A:K,8,FALSE),11+I54)","v":1}]
["T_QA",{"$f":"B19","v":2024},6,13.745617529880475,null,{"$f":"VLOOKUP(A55,TeamList!A:I,8,FALSE)","v":2},{"$f":"VLOOKUP(B55&\"-\"&TEXT(C55,\"00\"),CapacityModel!A:G,7,FALSE)","v":16.171314741035854},{"$f":"VLOOKUP(A55,TeamList!A:K,10,FALSE)","v":0.85},{"$f":"(B55*12+C55-1)-(VALUE(LEFT(TeamList!$K$1,4))*12+VALUE(RIGHT(TeamList!$K$1,2))-1)","v":17},{"$f":"INDEX(TeamList!A:BY,VLOOKUP(A55,TeamList!A:K,8,FALSE),11+I55)","v":1}]
["* VirtualDrum",{"$f":"B2","v":2023},{"$f":"C2","v":1},1]
["* VirtualDrum",{"$f":"B3","v":2023},2,2]
["* VirtualDrum",{"$f":"B4","v":2023},3,2]
["* VirtualDrum",{"$f":"B5","v":2023},4,2]
["* VirtualDrum",{"$f":"B6","v":2023},5,2]
["* VirtualDrum",{"$f":"B7","v":2023},6,2]
["* VirtualDrum",{"$f":"B8","v":2023},7,2]
["* VirtualDrum",{"$f":"B9","v":2023},8,1]
["* VirtualDrum",{"$f":"B10","v":2023},9,1]
["* VirtualDrum",{"$f":"B11","v":2023},10,2]
["* VirtualDrum",{"$f":"B12","v":2023},11,2]
["* VirtualDrum",{"$f":"B13","v":2023},12,1]
["* VirtualDrum",{"$f":"B14","v":2024},1,1]
["* VirtualDrum",{"$f":"B15","v":2024},2,2]
["* VirtualDrum",{"$f":"B16","v":2024},3,2]
["* VirtualDrum",{"$f":"B17","v":2024},4,2]
["* VirtualDrum",{"$f":"B18","v":2024},5,2]
["* VirtualDrum",{"$f":"B19","v":2024},6,2]

{"sheet":"PRJ_Test #1","index":8,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project-ID","PRJ_Test #1"]
["Project ",{"$f":"VLOOKUP(B1,ProjectList!A:E,2,FALSE)","v":"Testprojekt #1"}]
["Start-Year",{"$f":"VLOOKUP(B1,ProjectList!A:E,3,FALSE)","v":2023}]
["Start-Month",{"$f":"VLOOKUP(B1,ProjectList!A:E,4,FALSE)","v":1}]
["Active",{"$f":"VLOOKUP(B1,ProjectList!A:E,5,FALSE)","v":2}]
[]
["Load per Month"]
["Offset to Start",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Team-ID","Team",{"$f":"TEXT($B$3+INT(($B$4-1+C8)/12),\"00\")&\"-\"&TEXT(MOD(($B$4-1+C8),12)+1,\"00\")","v":"2023-01"},"2023-02","2023-03","2023-04","2023-05","2023-06","2023-07","2023-08","2023-09","2023-10","2023-11","2023-12","2024-01","2024-02"]
["T_PM",{"$f":"VLOOKUP(A10,TeamList!A:B,2,FALSE)","v":"Product Management"},12,2]
["T_DEV",{"$f":"VLOOKUP(A11,TeamList!A:B,2,FALSE)","v":"Development"},10,25,20,10,2]
["T_QA",{"$f":"VLOOKUP(A12,TeamList!A:B,2,FALSE)","v":"Quality Assurance"},null,8,10,9,2]
["* VirtualDrum",{"$f":"VLOOKUP(A13,TeamList!A:B,2,FALSE)","v":"Virtual Team for Concept & Integration"},null,1]
[null,{"$f":"VLOOKUP(A14,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A15,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A16,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A17,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A18,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A19,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A20,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A21,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A22,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A23,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A24,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A25,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A26,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A27,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A28,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"PRJ_Test #2","index":9,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project-ID","PRJ_Test #2"]
["Project ",{"$f":"VLOOKUP(B1,ProjectList!A:E,2,FALSE)","v":"Testprojekt #2"}]
["Start-Year",{"$f":"VLOOKUP(B1,ProjectList!A:E,3,FALSE)","v":2023}]
["Start-Month",{"$f":"VLOOKUP(B1,ProjectList!A:E,4,FALSE)","v":2}]
["Active",{"$f":"VLOOKUP(B1,ProjectList!A:E,5,FALSE)","v":2}]
[]
["Load per Month"]
["Offset to Start",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Team-ID","Team",{"$f":"TEXT($B$3+INT(($B$4-1+C8)/12),\"00\")&\"-\"&TEXT(MOD(($B$4-1+C8),12)+1,\"00\")","v":"2023-02"},"2023-03","2023-04","2023-05","2023-06","2023-07","2023-08","2023-09","2023-10","2023-11","2023-12","2024-01","2024-02","2024-03"]
["T_PM",{"$f":"VLOOKUP(A10,TeamList!A:B,2,FALSE)","v":"Product Management"},15,10,5,null,2,2]
["T_DEV",{"$f":"VLOOKUP(A11,TeamList!A:B,2,FALSE)","v":"Development"},10,10,25,30,30,20,5]
["T_QA",{"$f":"VLOOKUP(A12,TeamList!A:B,2,FALSE)","v":"Quality Assurance"},null,5,5,10,10,20,5]
["* VirtualDrum",{"$f":"VLOOKUP(A13,TeamList!A:B,2,FALSE)","v":"Virtual Team for Concept & Integration"},null,null,2,1]
[null,{"$f":"VLOOKUP(A14,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A15,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A16,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A17,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A18,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A19,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A20,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A21,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A22,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A23,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A24,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A25,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A26,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A27,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A28,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"PRJ_Test #3","index":10,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project-ID","PRJ_Test #3"]
["Project ",{"$f":"VLOOKUP(B1,ProjectList!A:E,2,FALSE)","v":"Testprojekt #3"}]
["Start-Year",{"$f":"VLOOKUP(B1,ProjectList!A:E,3,FALSE)","v":2023}]
["Start-Month",{"$f":"VLOOKUP(B1,ProjectList!A:E,4,FALSE)","v":8}]
["Active",{"$f":"VLOOKUP(B1,ProjectList!A:E,5,FALSE)","v":2}]
[]
["Load per Month"]
["Offset to Start",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Team-ID","Team",{"$f":"TEXT($B$3+INT(($B$4-1+C8)/12),\"00\")&\"-\"&TEXT(MOD(($B$4-1+C8),12)+1,\"00\")","v":"2023-08"},"2023-09","2023-10","2023-11","2023-12","2024-01","2024-02","2024-03","2024-04","2024-05","2024-06","2024-07","2024-08","2024-09"]
["T_PM",{"$f":"VLOOKUP(A10,TeamList!A:B,2,FALSE)","v":"Product Management"},5,2,2]
["T_DEV",{"$f":"VLOOKUP(A11,TeamList!A:B,2,FALSE)","v":"Development"},10,10,10]
["T_QA",{"$f":"VLOOKUP(A12,TeamList!A:B,2,FALSE)","v":"Quality Assurance"},5,10,5]
["* VirtualDrum",{"$f":"VLOOKUP(A13,TeamList!A:B,2,FALSE)","v":"Virtual Team for Concept & Integration"},null,1]
[null,{"$f":"VLOOKUP(A14,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A15,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A16,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A17,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A18,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A19,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A20,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A21,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A22,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A23,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A24,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A25,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A26,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A27,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A28,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"PRJ_Test #4","index":11,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project-ID","PRJ_Test #4"]
["Project ",{"$f":"VLOOKUP(B1,ProjectList!A:E,2,FALSE)","v":"Testprojekt #4"}]
["Start-Year",{"$f":"VLOOKUP(B1,ProjectList!A:E,3,FALSE)","v":2023}]
["Start-Month",{"$f":"VLOOKUP(B1,ProjectList!A:E,4,FALSE)","v":9}]
["Active",{"$f":"VLOOKUP(B1,ProjectList!A:E,5,FALSE)","v":1}]
[]
["Load per Month"]
["Offset to Start",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Team-ID","Team",{"$f":"TEXT($B$3+INT(($B$4-1+C8)/12),\"00\")&\"-\"&TEXT(MOD(($B$4-1+C8),12)+1,\"00\")","v":"2023-09"},"2023-10","2023-11","2023-12","2024-01","2024-02","2024-03","2024-04","2024-05","2024-06","2024-07","2024-08","2024-09","2024-10"]
["T_PM",{"$f":"VLOOKUP(A10,TeamList!A:B,2,FALSE)","v":"Product Management"},12,2]
["T_DEV",{"$f":"VLOOKUP(A11,TeamList!A:B,2,FALSE)","v":"Development"},10,25,20,10,2]
["T_QA",{"$f":"VLOOKUP(A12,TeamList!A:B,2,FALSE)","v":"Quality Assurance"},null,8,10,9,2]
["* VirtualDrum",{"$f":"VLOOKUP(A13,TeamList!A:B,2,FALSE)","v":"Virtual Team for Concept & Integration"}]
[null,{"$f":"VLOOKUP(A14,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A15,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A16,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A17,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A18,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A19,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A20,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A21,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A22,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A23,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A24,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A25,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A26,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A27,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A28,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"PRJ_Test #5","index":12,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project-ID","PRJ_Test #5"]
["Project ",{"$f":"VLOOKUP(B1,ProjectList!A:E,2,FALSE)","v":"Testprojekt #5"}]
["Start-Year",{"$f":"VLOOKUP(B1,ProjectList!A:E,3,FALSE)","v":2023}]
["Start-Month",{"$f":"VLOOKUP(B1,ProjectList!A:E,4,FALSE)","v":11}]
["Active",{"$f":"VLOOKUP(B1,ProjectList!A:E,5,FALSE)","v":1}]
[]
["Load per Month"]
["Offset to Start",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Team-ID","Team",{"$f":"TEXT($B$3+INT(($B$4-1+C8)/12),\"00\")&\"-\"&TEXT(MOD(($B$4-1+C8),12)+1,\"00\")","v":"2023-11"},"2023-12","2024-01","2024-02","2024-03","2024-04","2024-05","2024-06","2024-07","2024-08","2024-09","2024-10","2024-11","2024-12"]
["T_PM",{"$f":"VLOOKUP(A10,TeamList!A:B,2,FALSE)","v":"Product Management"},15,10,5,null,2,2]
["T_DEV",{"$f":"VLOOKUP(A11,TeamList!A:B,2,FALSE)","v":"Development"},10,10,25,30,30,20,5]
["T_QA",{"$f":"VLOOKUP(A12,TeamList!A:B,2,FALSE)","v":"Quality Assurance"},null,5,5,10,10,15,5]
["* VirtualDrum",{"$f":"VLOOKUP(A13,TeamList!A:B,2,FALSE)","v":"Virtual Team for Concept & Integration"},null,null,2,1]
[null,{"$f":"VLOOKUP(A14,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A15,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A16,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A17,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A18,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A19,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A20,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A21,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A22,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A23,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A24,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A25,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A26,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A27,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A28,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"PRJ_Test #6","index":13,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project-ID","PRJ_Test #6"]
["Project ",{"$f":"VLOOKUP(B1,ProjectList!A:E,2,FALSE)","v":"Testprojekt #6"}]
["Start-Year",{"$f":"VLOOKUP(B1,ProjectList!A:E,3,FALSE)","v":2023}]
["Start-Month",{"$f":"VLOOKUP(B1,ProjectList!A:E,4,FALSE)","v":16}]
["Active",{"$f":"VLOOKUP(B1,ProjectList!A:E,5,FALSE)","v":1}]
[]
["Load per Month"]
["Offset to Start",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Team-ID","Team",{"$f":"TEXT($B$3+INT(($B$4-1+C8)/12),\"00\")&\"-\"&TEXT(MOD(($B$4-1+C8),12)+1,\"00\")","v":"2024-04"},"2024-05","2024-06","2024-07","2024-08","2024-09","2024-10","2024-11","2024-12","2025-01","2025-02","2025-03","2025-04","2025-05"]
["T_PM",{"$f":"VLOOKUP(A10,TeamList!A:B,2,FALSE)","v":"Product Management"},5,2,2]
["T_DEV",{"$f":"VLOOKUP(A11,TeamList!A:B,2,FALSE)","v":"Development"},10,10,10]
["T_QA",{"$f":"VLOOKUP(A12,TeamList!A:B,2,FALSE)","v":"Quality Assurance"},5,10,5]
["* VirtualDrum",{"$f":"VLOOKUP(A13,TeamList!A:B,2,FALSE)","v":"Virtual Team for Concept & Integration"},null,1]
[null,{"$f":"VLOOKUP(A14,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A15,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A16,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A17,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A18,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A19,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A20,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A21,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A22,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A23,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A24,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A25,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A26,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A27,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A28,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"PRJ_Template","index":14,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project-ID","PRJ_Template"]
["Project ",{"$f":"VLOOKUP(B1,ProjectList!A:E,2,FALSE)","v":{"$error":"#N/A"}}]
["Start-Year",{"$f":"VLOOKUP(B1,ProjectList!A:E,3,FALSE)","v":{"$error":"#N/A"}}]
["Start-Month",{"$f":"VLOOKUP(B1,ProjectList!A:E,4,FALSE)","v":{"$error":"#N/A"}}]
["Active",{"$f":"VLOOKUP(B1,ProjectList!A:E,5,FALSE)","v":{"$error":"#N/A"}}]
[]
["Load per Month"]
["Offset to Start",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13]
["Team-ID","Team",{"$f":"TEXT($B$3+INT(($B$4-1+C8)/12),\"00\")&\"-\"&TEXT(MOD(($B$4-1+C8),12)+1,\"00\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["T_PM",{"$f":"VLOOKUP(A10,TeamList!A:B,2,FALSE)","v":"Product Management"}]
["T_DEV",{"$f":"VLOOKUP(A11,TeamList!A:B,2,FALSE)","v":"Development"}]
["T_QA",{"$f":"VLOOKUP(A12,TeamList!A:B,2,FALSE)","v":"Quality Assurance"}]
["* VirtualDrum",{"$f":"VLOOKUP(A13,TeamList!A:B,2,FALSE)","v":"Virtual Team for Concept & Integration"}]
[null,{"$f":"VLOOKUP(A14,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A15,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A16,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A17,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A18,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A19,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A20,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A21,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A22,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A23,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A24,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A25,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A26,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A27,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(A28,TeamList!A:B,2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Raw","index":15,"n_rows":84,"n_cols":5,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Project-Id","Team-id","year","month","effort"]
["PRJ_Test #1","T_PM",2023,1,12]
["PRJ_Test #1","T_PM",2023,2,2]
["PRJ_Test #1","T_DEV",2023,1,10]
["PRJ_Test #1","T_DEV",2023,2,25]
["PRJ_Test #1","T_DEV",2023,3,20]
["PRJ_Test #1","T_DEV",2023,4,10]
["PRJ_Test #1","T_DEV",2023,5,2]
["PRJ_Test #1","T_QA",2023,2,8]
["PRJ_Test #1","T_QA",2023,3,10]
["PRJ_Test #1","T_QA",2023,4,9]
["PRJ_Test #1","T_QA",2023,5,2]
["PRJ_Test #1","* VirtualDrum",2023,2,1]
["PRJ_Test #2","T_PM",2023,2,15]
["PRJ_Test #2","T_PM",2023,3,10]
["PRJ_Test #2","T_PM",2023,4,5]
["PRJ_Test #2","T_PM",2023,6,2]
["PRJ_Test #2","T_PM",2023,7,2]
["PRJ_Test #2","T_DEV",2023,2,10]
["PRJ_Test #2","T_DEV",2023,3,10]
["PRJ_Test #2","T_DEV",2023,4,25]
["PRJ_Test #2","T_DEV",2023,5,30]
["PRJ_Test #2","T_DEV",2023,6,30]
["PRJ_Test #2","T_DEV",2023,7,20]
["PRJ_Test #2","T_DEV",2023,8,5]
["PRJ_Test #2","T_QA",2023,3,5]
["PRJ_Test #2","T_QA",2023,4,5]
["PRJ_Test #2","T_QA",2023,5,10]
["PRJ_Test #2","T_QA",2023,6,10]
["PRJ_Test #2","T_QA",2023,7,20]
["PRJ_Test #2","T_QA",2023,8,5]
["PRJ_Test #2","* VirtualDrum",2023,4,2]
["PRJ_Test #2","* VirtualDrum",2023,5,1]
["PRJ_Test #3","T_PM",2023,8,5]
["PRJ_Test #3","T_PM",2023,9,2]
["PRJ_Test #3","T_PM",2023,10,2]
["PRJ_Test #3","T_DEV",2023,8,10]
["PRJ_Test #3","T_DEV",2023,9,10]
["PRJ_Test #3","T_DEV",2023,10,10]
["PRJ_Test #3","T_QA",2023,8,5]
["PRJ_Test #3","T_QA",2023,9,10]
["PRJ_Test #3","T_QA",2023,10,5]
["PRJ_Test #3","* VirtualDrum",2023,9,1]
["PRJ_Test #4","T_PM",2023,9,12]
["PRJ_Test #4","T_PM",2023,10,2]
["PRJ_Test #4","T_DEV",2023,9,10]
["PRJ_Test #4","T_DEV",2023,10,25]
["PRJ_Test #4","T_DEV",2023,11,20]
["PRJ_Test #4","T_DEV",2023,12,10]
["PRJ_Test #4","T_DEV",2024,1,2]
["PRJ_Test #4","T_QA",2023,10,8]
["PRJ_Test #4","T_QA",2023,11,10]
["PRJ_Test #4","T_QA",2023,12,9]
["PRJ_Test #4","T_QA",2024,1,2]
["PRJ_Test #5","T_PM",2023,11,15]
["PRJ_Test #5","T_PM",2023,12,10]
["PRJ_Test #5","T_PM",2024,1,5]
["PRJ_Test #5","T_PM",2024,3,2]
["PRJ_Test #5","T_PM",2024,4,2]
["PRJ_Test #5","T_DEV",2023,11,10]
["PRJ_Test #5","T_DEV",2023,12,10]
["PRJ_Test #5","T_DEV",2024,1,25]
["PRJ_Test #5","T_DEV",2024,2,30]
["PRJ_Test #5","T_DEV",2024,3,30]
["PRJ_Test #5","T_DEV",2024,4,20]
["PRJ_Test #5","T_DEV",2024,5,5]
["PRJ_Test #5","T_QA",2023,12,5]
["PRJ_Test #5","T_QA",2024,1,5]
["PRJ_Test #5","T_QA",2024,2,10]
["PRJ_Test #5","T_QA",2024,3,10]
["PRJ_Test #5","T_QA",2024,4,15]
["PRJ_Test #5","T_QA",2024,5,5]
["PRJ_Test #5","* VirtualDrum",2024,1,2]
["PRJ_Test #5","* VirtualDrum",2024,2,1]
["PRJ_Test #6","T_PM",2024,4,5]
["PRJ_Test #6","T_PM",2024,5,2]
["PRJ_Test #6","T_PM",2024,6,2]
["PRJ_Test #6","T_DEV",2024,4,10]
["PRJ_Test #6","T_DEV",2024,5,10]
["PRJ_Test #6","T_DEV",2024,6,10]
["PRJ_Test #6","T_QA",2024,4,5]
["PRJ_Test #6","T_QA",2024,5,10]
["PRJ_Test #6","T_QA",2024,6,5]
["PRJ_Test #6","* VirtualDrum",2024,5,1]

{"sheet":"Import","index":16,"n_rows":87,"n_cols":14,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Message","Project-Id (without leading PRJ_)","Team-id (s. TeamList)","Month (relative to start 0 = first month)","Effort (in PersonDays)",null,"Effort on timeline …"]
["imported","Test #1","T_PM",0,12,null,"Typ1",0,1,2,3,4,5,6]
["imported","Test #1","T_PM",1,2,null,"T_ProductManagement_001",12,2]
["imported","Test #1","T_DEV",0,10,null,"T_Development_001",10,25,20,10,3]
["imported","Test #1","T_DEV",1,25,null,"T_Quality_001",null,8,12,8,5]
["imported","Test #1","T_DEV",2,20,null,"* VirtualDrum",null,1]
["imported","Test #1","T_DEV",3,10]
["imported","Test #1","T_DEV",4,2,null,"Typ2",0,1,2,3,4,5,6]
["imported","Test #1","T_QA",1,8,null,"T_ProductManagement_001",15,10,5,null,2,2]
["imported","Test #1","T_QA",2,10,null,"T_Development_001",10,10,25,30,30,20,5]
["imported","Test #1","T_QA",3,9,null,"T_Quality_001",null,5,5,10,10,20,5]
["imported","Test #1","T_QA",4,2,null,"* VirtualDrum",null,null,2,1]
["imported","Test #1","* VirtualDrum",1,1]
["imported","Test #2","T_PM",0,15,null,"Typ3",0,1,2,3,4,5,6]
["imported","Test #2","T_PM",1,10,null,"T_ProductManagement_001",5,2,2]
["imported","Test #2","T_PM",2,5,null,"T_Development_001",10,10,10]
["imported","Test #2","T_PM",4,2,null,"T_Quality_001",5,10,5]
["imported","Test #2","T_PM",5,2,null,"* VirtualDrum",null,1]
["imported","Test #2","T_DEV",0,10]
["imported","Test #2","T_DEV",1,10]
["imported","Test #2","T_DEV",2,25]
["imported","Test #2","T_DEV",3,30]
["imported","Test #2","T_DEV",4,30]
["imported","Test #2","T_DEV",5,20]
["imported","Test #2","T_DEV",6,5]
["imported","Test #2","T_QA",1,5]
["imported","Test #2","T_QA",2,5]
["imported","Test #2","T_QA",3,10]
["imported","Test #2","T_QA",4,10]
["imported","Test #2","T_QA",5,20]
["imported","Test #2","T_QA",6,5]
["imported","Test #2","* VirtualDrum",2,2]
["imported","Test #2","* VirtualDrum",3,1]
["imported","Test #3","T_PM",0,5]
["imported","Test #3","T_PM",1,2]
["imported","Test #3","T_PM",2,2]
["imported","Test #3","T_DEV",0,10]
["imported","Test #3","T_DEV",1,10]
["imported","Test #3","T_DEV",2,10]
["imported","Test #3","T_QA",0,5]
["imported","Test #3","T_QA",1,10]
["imported","Test #3","T_QA",2,5]
["imported","Test #3","* VirtualDrum",1,1]
["imported","Test #4","T_PM",0,12]
["imported","Test #4","T_PM",1,2]
["imported","Test #4","T_DEV",0,10]
["imported","Test #4","T_DEV",1,25]
["imported","Test #4","T_DEV",2,20]
["imported","Test #4","T_DEV",3,10]
["imported","Test #4","T_DEV",4,2]
["imported","Test #4","T_QA",1,8]
["imported","Test #4","T_QA",2,10]
["imported","Test #4","T_QA",3,9]
["imported","Test #4","T_QA",4,2]
["imported","Test #4","* VirtualDrum",1,1]
["imported","Test #5","T_PM",0,15]
["imported","Test #5","T_PM",1,10]
["imported","Test #5","T_PM",2,5]
["imported","Test #5","T_PM",4,2]
["imported","Test #5","T_PM",5,2]
["imported","Test #5","T_DEV",0,10]
["imported","Test #5","T_DEV",1,10]
["imported","Test #5","T_DEV",2,25]
["imported","Test #5","T_DEV",3,30]
["imported","Test #5","T_DEV",4,30]
["imported","Test #5","T_DEV",5,20]
["imported","Test #5","T_DEV",6,5]
["imported","Test #5","T_QA",1,5]
["imported","Test #5","T_QA",2,5]
["imported","Test #5","T_QA",3,10]
["imported","Test #5","T_QA",4,10]
["imported","Test #5","T_QA",5,20]
["imported","Test #5","T_QA",6,5]
["imported","Test #5","* VirtualDrum",2,2]
["imported","Test #5","* VirtualDrum",3,1]
["imported","Test #6","T_PM",0,5]
["imported","Test #6","T_PM",1,2]
["imported","Test #6","T_PM",2,2]
["imported","Test #6","T_DEV",0,10]
["imported","Test #6","T_DEV",1,10]
["imported","Test #6","T_DEV",2,10]
["imported","Test #6","T_QA",0,5]
["imported","Test #6","T_QA",1,10]
["imported","Test #6","T_QA",2,5]
["imported","Test #6","* VirtualDrum",1,1]
["project [PRJ_Test #NotInList] not in ProjectList - not imported!","Test #NotInList","T_PM",0,99]
["Team [XX] is missing in Project-Sheet [PJR_Test #1]","Test #1","XX",0,99]

{"sheet":"AnonymousLookup","index":17,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Class","AnonymousID","OriginalID"]
["Project","PRJ_001","PRJ_Test #1"]
["Project","PRJ_002","PRJ_Test #2"]
["Project","PRJ_003","PRJ_Test #3"]
["Project","PRJ_004","PRJ_Test #4"]
["Project","PRJ_005","PRJ_Test #5"]
["Project","PRJ_006","PRJ_Test #6"]
["Team","T_Quality_001","T_QA"]
["Team","T_Development_001","T_DEV"]
["Team","T_ProductManagement_001","T_PM"]
["Team","T_VirtualDrum_001","* VirtualDrum"]

{"sheet":"CapacityModel","index":18,"n_rows":148,"n_cols":13,"rows_kept":148,"cut":false,"hidden":false,"merged":[]}
["Generic capacity model for next years (Germany)"]
[]
["working days per year after bank holidays, illness and vacation",null,null,null,null,205]
["*type of capacity model you want to use",null,null,null,null,"detailed","simple = PPY/12, detailed s. this sheet"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K6","v":"calculation of brutto working days per month in 2023"},null,null,null,null,null,null,null,"bank holidays for year",null,2023,null,{"$f":"\"overview about envelope curves for year \"&K6","v":"overview about envelope curves for year 2023"}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation correction factor","mean brutto working days*",null,{"$f":"DATE(K6,1,1)","v":"2023-01-01"},"Neujahr"]
[{"$f":"K6&\"-\"&TEXT(B8,\"00\")","v":"2023-01"},1,{"$f":"NETWORKDAYS(DATE(K6,B8,1),DATE(K6,B9,1)-1,I7:I20)","v":21},{"$f":"E8*F8","v":1.032289156626506},{"$f":"C8/(SUM(C8:C19)/12)","v":1.0120481927710843},1.02,{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D8)","v":17.634939759036143},null,{"$f":"DATE(K6,1,6)","v":"2023-01-06"},"Dreikönigstag"]
[{"$f":"K6&\"-\"&TEXT(B9,\"00\")","v":"2023-02"},2,{"$f":"NETWORKDAYS(DATE(K6,B9,1),DATE(K6,B10,1)-1,I7:I20)","v":20},1.0120481927710843,{"$f":"C9/(SUM(C8:C19)/12)","v":0.96385542168674698},1.05,17.289156626506021,null,{"$f":"I10-2","v":"2023-04-07"},"Karfreitag"]
[{"$f":"K6&\"-\"&TEXT(B10,\"00\")","v":"2023-03"},3,{"$f":"NETWORKDAYS(DATE(K6,B10,1),DATE(K6,B11,1)-1,I7:I20)","v":23},1.0973493975903614,{"$f":"C10/(SUM(C8:C19)/12)","v":1.1084337349397591},0.99,18.746385542168674,null,{"$f":"DOLLAR((DAY(MINUTE(K6/38)/2+55)&\".4.\"&K6)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2023-04-09"},"Ostersonntag"]
[{"$f":"K6&\"-\"&TEXT(B11,\"00\")","v":"2023-04"},4,{"$f":"NETWORKDAYS(DATE(K6,B11,1),DATE(K6,B12,1)-1,I7:I20)","v":18},0.90216867469879525,{"$f":"C11/(SUM(C8:C19)/12)","v":0.86746987951807231},1.04,15.412048192771085,null,{"$f":"I10+1","v":"2023-04-10"},"Ostermontag"]
[{"$f":"K6&\"-\"&TEXT(B12,\"00\")","v":"2023-05"},5,{"$f":"NETWORKDAYS(DATE(K6,B12,1),DATE(K6,B13,1)-1,I7:I20)","v":20},0.9927710843373494,{"$f":"C12/(SUM(C8:C19)/12)","v":0.96385542168674698},1.03,16.959839357429718,null,{"$f":"DATE(K6,5,1)","v":"2023-05-01"},"Tag der Arbeit"]
[{"$f":"K6&\"-\"&TEXT(B13,\"00\")","v":"2023-06"},6,{"$f":"NETWORKDAYS(DATE(K6,B13,1),DATE(K6,B14,1)-1,I7:I20)","v":21},1.0019277108433735,{"$f":"C13/(SUM(C8:C19)/12)","v":1.0120481927710843},0.99,17.116265060240963,null,{"$f":"I10+39","v":"2023-05-18"},"Christi Himmelfahrt"]
[{"$f":"K6&\"-\"&TEXT(B14,\"00\")","v":"2023-07"},7,{"$f":"NETWORKDAYS(DATE(K6,B14,1),DATE(K6,B15,1)-1,I7:I20)","v":21},1.0424096385542168,{"$f":"C14/(SUM(C8:C19)/12)","v":1.0120481927710843},1.03,17.807831325301201,null,{"$f":"I10+49","v":"2023-05-28"},"Pfingstsonntag"]
[{"$f":"K6&\"-\"&TEXT(B15,\"00\")","v":"2023-08"},8,{"$f":"NETWORKDAYS(DATE(K6,B15,1),DATE(K6,B16,1)-1,I7:I20)","v":23},1.0530120481927709,{"$f":"C15/(SUM(C8:C19)/12)","v":1.1084337349397591},0.95,17.988955823293168,null,{"$f":"I10+50","v":"2023-05-29"},"Pfingstmontag"]
[{"$f":"K6&\"-\"&TEXT(B16,\"00\")","v":"2023-09"},9,{"$f":"NETWORKDAYS(DATE(K6,B16,1),DATE(K6,B17,1)-1,I7:I20)","v":21},0.96144578313253004,{"$f":"C16/(SUM(C8:C19)/12)","v":1.0120481927710843},0.95,16.424698795180721,null,{"$f":"I10+60","v":"2023-06-08"},"Fronleichnam"]
[{"$f":"K6&\"-\"&TEXT(B17,\"00\")","v":"2023-10"},10,{"$f":"NETWORKDAYS(DATE(K6,B17,1),DATE(K6,B18,1)-1,I7:I20)","v":21},1.032289156626506,{"$f":"C17/(SUM(C8:C19)/12)","v":1.0120481927710843},1.02,17.634939759036143,null,{"$f":"DATE(K6,10,3)","v":"2023-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K6&\"-\"&TEXT(B18,\"00\")","v":"2023-11"},11,{"$f":"NETWORKDAYS(DATE(K6,B18,1),DATE(K6,B19,1)-1,I7:I20)","v":21},1.0525301204819277,{"$f":"C18/(SUM(C8:C19)/12)","v":1.0120481927710843},1.04,17.980722891566263,null,{"$f":"DATE(K6,11,1)","v":"2023-11-01"},"Allerheiligen"]
[{"$f":"K6&\"-\"&TEXT(B19,\"00\")","v":"2023-12"},12,{"$f":"NETWORKDAYS(DATE(K6,B19,1),DATE(K6+1,1,1)-1,I7:I20)","v":19},0.81493975903614457,{"$f":"C19/(SUM(C8:C19)/12)","v":0.91566265060240959},0.89,13.921887550200802,null,{"$f":"DATE(K6,12,25)","v":"2023-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K6,12,26)","v":"2023-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K22","v":"calculation of brutto working days per month in 2024"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K6+1","v":2024}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K22,1,1)","v":"2024-01-01"},"Neujahr"]
[{"$f":"K22&\"-\"&TEXT(B24,\"00\")","v":"2024-01"},1,{"$f":"NETWORKDAYS(DATE(K22,B24,1),DATE(K22,B25,1)-1,I23:I36)","v":22},{"$f":"E24*F24","v":1.0728286852589641},{"$f":"C24/(SUM(C24:C35)/12)","v":1.0517928286852589},{"$f":"F8","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D24)","v":18.327490039840637},null,{"$f":"DATE(K22,1,6)","v":"2024-01-06"},"Dreikönigstag"]
[{"$f":"K22&\"-\"&TEXT(B25,\"00\")","v":"2024-02"},2,{"$f":"NETWORKDAYS(DATE(K22,B25,1),DATE(K22,B26,1)-1,I23:I36)","v":21},1.054183266932271,{"$f":"C25/(SUM(C24:C35)/12)","v":1.0039840637450199},{"$f":"F9","v":1.05},18.008964143426297,null,{"$f":"I26-2","v":"2024-03-29"},"Karfreitag"]
[{"$f":"K22&\"-\"&TEXT(B26,\"00\")","v":"2024-03"},3,{"$f":"NETWORKDAYS(DATE(K22,B26,1),DATE(K22,B27,1)-1,I23:I36)","v":20},0.94661354581673296,{"$f":"C26/(SUM(C24:C35)/12)","v":0.9561752988047808},0.99,16.171314741035854,null,{"$f":"DOLLAR((DAY(MINUTE(K22/38)/2+55)&\".4.\"&K22)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2024-03-31"},"Ostersonntag"]
[{"$f":"K22&\"-\"&TEXT(B27,\"00\")","v":"2024-04"},4,{"$f":"NETWORKDAYS(DATE(K22,B27,1),DATE(K22,B28,1)-1,I23:I36)","v":21},1.0441434262948208,{"$f":"C27/(SUM(C24:C35)/12)","v":1.0039840637450199},1.04,17.83745019920319,null,{"$f":"I26+1","v":"2024-04-01"},"Ostermontag"]
[{"$f":"K22&\"-\"&TEXT(B28,\"00\")","v":"2024-05"},5,{"$f":"NETWORKDAYS(DATE(K22,B28,1),DATE(K22,B29,1)-1,I23:I36)","v":19},0.93561752988047808,{"$f":"C28/(SUM(C24:C35)/12)","v":0.9083665338645418},1.03,15.983466135458166,null,{"$f":"DATE(K22,5,1)","v":"2024-05-01"},"Tag der Arbeit"]
[{"$f":"K22&\"-\"&TEXT(B29,\"00\")","v":"2024-06"},6,{"$f":"NETWORKDAYS(DATE(K22,B29,1),DATE(K22,B30,1)-1,I23:I36)","v":20},0.94661354581673296,{"$f":"C29/(SUM(C24:C35)/12)","v":0.9561752988047808},0.99,16.171314741035854,null,{"$f":"I26+39","v":"2024-05-09"},"Christi Himmelfahrt"]
[{"$f":"K22&\"-\"&TEXT(B30,\"00\")","v":"2024-07"},7,{"$f":"NETWORKDAYS(DATE(K22,B30,1),DATE(K22,B31,1)-1,I23:I36)","v":23},1.1325896414342629,{"$f":"C30/(SUM(C24:C35)/12)","v":1.0996015936254979},1.03,19.348406374501991,null,{"$f":"I26+49","v":"2024-05-19"},"Pfingstsonntag"]
[{"$f":"K22&\"-\"&TEXT(B31,\"00\")","v":"2024-08"},8,{"$f":"NETWORKDAYS(DATE(K22,B31,1),DATE(K22,B32,1)-1,I23:I36)","v":22},0.99920318725099588,{"$f":"C31/(SUM(C24:C35)/12)","v":1.0517928286852589},0.95,17.069721115537845,null,{"$f":"I26+50","v":"2024-05-20"},"Pfingstmontag"]
[{"$f":"K22&\"-\"&TEXT(B32,\"00\")","v":"2024-09"},9,{"$f":"NETWORKDAYS(DATE(K22,B32,1),DATE(K22,B33,1)-1,I23:I36)","v":21},0.9537848605577689,{"$f":"C32/(SUM(C24:C35)/12)","v":1.0039840637450199},0.95,16.293824701195216,null,{"$f":"I26+60","v":"2024-05-30"},"Fronleichnam"]
[{"$f":"K22&\"-\"&TEXT(B33,\"00\")","v":"2024-10"},10,{"$f":"NETWORKDAYS(DATE(K22,B33,1),DATE(K22,B34,1)-1,I23:I36)","v":22},1.0728286852589641,{"$f":"C33/(SUM(C24:C35)/12)","v":1.0517928286852589},1.02,18.327490039840637,null,{"$f":"DATE(K22,10,3)","v":"2024-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K22&\"-\"&TEXT(B34,\"00\")","v":"2024-11"},11,{"$f":"NETWORKDAYS(DATE(K22,B34,1),DATE(K22,B35,1)-1,I23:I36)","v":20},0.99442231075697207,{"$f":"C34/(SUM(C24:C35)/12)","v":0.9561752988047808},1.04,16.988047808764939,null,{"$f":"DATE(K22,11,1)","v":"2024-11-01"},"Allerheiligen"]
[{"$f":"K22&\"-\"&TEXT(B35,\"00\")","v":"2024-12"},12,{"$f":"NETWORKDAYS(DATE(K22,B35,1),DATE(K22+1,1,1)-1,I23:I36)","v":20},0.85099601593625496,{"$f":"C35/(SUM(C24:C35)/12)","v":0.9561752988047808},0.89,14.537848605577688,null,{"$f":"DATE(K22,12,25)","v":"2024-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K22,12,26)","v":"2024-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K38","v":"calculation of brutto working days per month in 2025"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K22+1","v":2025}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K38,1,1)","v":"2025-01-01"},"Neujahr"]
[{"$f":"K38&\"-\"&TEXT(B40,\"00\")","v":"2025-01"},1,{"$f":"NETWORKDAYS(DATE(K38,B40,1),DATE(K38,B41,1)-1,I39:I52)","v":21},{"$f":"E40*F40","v":1.02816},{"$f":"C40/(SUM(C40:C51)/12)","v":1.008},{"$f":"F24","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D40)","v":17.564399999999999},null,{"$f":"DATE(K38,1,6)","v":"2025-01-06"},"Dreikönigstag"]
[{"$f":"K38&\"-\"&TEXT(B41,\"00\")","v":"2025-02"},2,{"$f":"NETWORKDAYS(DATE(K38,B41,1),DATE(K38,B42,1)-1,I39:I52)","v":20},1.0080000000000002,{"$f":"C41/(SUM(C40:C51)/12)","v":0.96000000000000008},{"$f":"F25","v":1.05},17.220000000000002,null,{"$f":"I42-2","v":"2025-04-18"},"Karfreitag"]
[{"$f":"K38&\"-\"&TEXT(B42,\"00\")","v":"2025-03"},3,{"$f":"NETWORKDAYS(DATE(K38,B42,1),DATE(K38,B43,1)-1,I39:I52)","v":21},0.99792000000000003,{"$f":"C42/(SUM(C40:C51)/12)","v":1.008},0.99,17.047799999999999,null,{"$f":"DOLLAR((DAY(MINUTE(K38/38)/2+55)&\".4.\"&K38)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2025-04-20"},"Ostersonntag"]
[{"$f":"K38&\"-\"&TEXT(B43,\"00\")","v":"2025-04"},4,{"$f":"NETWORKDAYS(DATE(K38,B43,1),DATE(K38,B44,1)-1,I39:I52)","v":20},0.99840000000000007,{"$f":"C43/(SUM(C40:C51)/12)","v":0.96000000000000008},1.04,17.056000000000001,null,{"$f":"I42+1","v":"2025-04-21"},"Ostermontag"]
[{"$f":"K38&\"-\"&TEXT(B44,\"00\")","v":"2025-05"},5,{"$f":"NETWORKDAYS(DATE(K38,B44,1),DATE(K38,B45,1)-1,I39:I52)","v":20},0.98880000000000012,{"$f":"C44/(SUM(C40:C51)/12)","v":0.96000000000000008},1.03,16.891999999999999,null,{"$f":"DATE(K38,5,1)","v":"2025-05-01"},"Tag der Arbeit"]
[{"$f":"K38&\"-\"&TEXT(B45,\"00\")","v":"2025-06"},6,{"$f":"NETWORKDAYS(DATE(K38,B45,1),DATE(K38,B46,1)-1,I39:I52)","v":19},0.90288000000000002,{"$f":"C45/(SUM(C40:C51)/12)","v":0.91200000000000003},0.99,15.424199999999999,null,{"$f":"I42+39","v":"2025-05-29"},"Christi Himmelfahrt"]
[{"$f":"K38&\"-\"&TEXT(B46,\"00\")","v":"2025-07"},7,{"$f":"NETWORKDAYS(DATE(K38,B46,1),DATE(K38,B47,1)-1,I39:I52)","v":23},1.1371200000000001,{"$f":"C46/(SUM(C40:C51)/12)","v":1.1040000000000001},1.03,19.425800000000002,null,{"$f":"I42+49","v":"2025-06-08"},"Pfingstsonntag"]
[{"$f":"K38&\"-\"&TEXT(B47,\"00\")","v":"2025-08"},8,{"$f":"NETWORKDAYS(DATE(K38,B47,1),DATE(K38,B48,1)-1,I39:I52)","v":21},0.95760000000000001,{"$f":"C47/(SUM(C40:C51)/12)","v":1.008},0.95,16.358999999999998,null,{"$f":"I42+50","v":"2025-06-09"},"Pfingstmontag"]
[{"$f":"K38&\"-\"&TEXT(B48,\"00\")","v":"2025-09"},9,{"$f":"NETWORKDAYS(DATE(K38,B48,1),DATE(K38,B49,1)-1,I39:I52)","v":22},1.0032000000000001,{"$f":"C48/(SUM(C40:C51)/12)","v":1.056},0.95,17.138000000000002,null,{"$f":"I42+60","v":"2025-06-19"},"Fronleichnam"]
[{"$f":"K38&\"-\"&TEXT(B49,\"00\")","v":"2025-10"},10,{"$f":"NETWORKDAYS(DATE(K38,B49,1),DATE(K38,B50,1)-1,I39:I52)","v":22},1.0771200000000001,{"$f":"C49/(SUM(C40:C51)/12)","v":1.056},1.02,18.4008,null,{"$f":"DATE(K38,10,3)","v":"2025-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K38&\"-\"&TEXT(B50,\"00\")","v":"2025-11"},11,{"$f":"NETWORKDAYS(DATE(K38,B50,1),DATE(K38,B51,1)-1,I39:I52)","v":20},0.99840000000000007,{"$f":"C50/(SUM(C40:C51)/12)","v":0.96000000000000008},1.04,17.056000000000001,null,{"$f":"DATE(K38,11,1)","v":"2025-11-01"},"Allerheiligen"]
[{"$f":"K38&\"-\"&TEXT(B51,\"00\")","v":"2025-12"},12,{"$f":"NETWORKDAYS(DATE(K38,B51,1),DATE(K38+1,1,1)-1,I39:I52)","v":21},0.89712000000000003,{"$f":"C51/(SUM(C40:C51)/12)","v":1.008},0.89,15.325799999999999,null,{"$f":"DATE(K38,12,25)","v":"2025-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K38,12,26)","v":"2025-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K54","v":"calculation of brutto working days per month in 2026"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K38+1","v":2026}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K54,1,1)","v":"2026-01-01"},"Neujahr"]
[{"$f":"K54&\"-\"&TEXT(B56,\"00\")","v":"2026-01"},1,{"$f":"NETWORKDAYS(DATE(K54,B56,1),DATE(K54,B57,1)-1,I55:I68)","v":20},{"$f":"E56*F56","v":0.97142857142857142},{"$f":"C56/(SUM(C56:C67)/12)","v":0.95238095238095233},{"$f":"F40","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D56)","v":16.595238095238095},null,{"$f":"DATE(K54,1,6)","v":"2026-01-06"},"Dreikönigstag"]
[{"$f":"K54&\"-\"&TEXT(B57,\"00\")","v":"2026-02"},2,{"$f":"NETWORKDAYS(DATE(K54,B57,1),DATE(K54,B58,1)-1,I55:I68)","v":20},1,{"$f":"C57/(SUM(C56:C67)/12)","v":0.95238095238095233},{"$f":"F41","v":1.05},17.083333333333332,null,{"$f":"I58-2","v":"2026-04-03"},"Karfreitag"]
[{"$f":"K54&\"-\"&TEXT(B58,\"00\")","v":"2026-03"},3,{"$f":"NETWORKDAYS(DATE(K54,B58,1),DATE(K54,B59,1)-1,I55:I68)","v":22},1.0371428571428571,{"$f":"C58/(SUM(C56:C67)/12)","v":1.0476190476190477},0.99,17.717857142857142,null,{"$f":"DOLLAR((DAY(MINUTE(K54/38)/2+55)&\".4.\"&K54)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2026-04-05"},"Ostersonntag"]
[{"$f":"K54&\"-\"&TEXT(B59,\"00\")","v":"2026-04"},4,{"$f":"NETWORKDAYS(DATE(K54,B59,1),DATE(K54,B60,1)-1,I55:I68)","v":20},0.99047619047619051,{"$f":"C59/(SUM(C56:C67)/12)","v":0.95238095238095233},1.04,16.920634920634921,null,{"$f":"I58+1","v":"2026-04-06"},"Ostermontag"]
[{"$f":"K54&\"-\"&TEXT(B60,\"00\")","v":"2026-05"},5,{"$f":"NETWORKDAYS(DATE(K54,B60,1),DATE(K54,B61,1)-1,I55:I68)","v":18},0.88285714285714278,{"$f":"C60/(SUM(C56:C67)/12)","v":0.8571428571428571},1.03,15.082142857142856,null,{"$f":"DATE(K54,5,1)","v":"2026-05-01"},"Tag der Arbeit"]
[{"$f":"K54&\"-\"&TEXT(B61,\"00\")","v":"2026-06"},6,{"$f":"NETWORKDAYS(DATE(K54,B61,1),DATE(K54,B62,1)-1,I55:I68)","v":21},0.99,{"$f":"C61/(SUM(C56:C67)/12)","v":1},0.99,16.912499999999998,null,{"$f":"I58+39","v":"2026-05-14"},"Christi Himmelfahrt"]
[{"$f":"K54&\"-\"&TEXT(B62,\"00\")","v":"2026-07"},7,{"$f":"NETWORKDAYS(DATE(K54,B62,1),DATE(K54,B63,1)-1,I55:I68)","v":23},1.1280952380952383,{"$f":"C62/(SUM(C56:C67)/12)","v":1.0952380952380953},1.03,19.271626984126986,null,{"$f":"I58+49","v":"2026-05-24"},"Pfingstsonntag"]
[{"$f":"K54&\"-\"&TEXT(B63,\"00\")","v":"2026-08"},8,{"$f":"NETWORKDAYS(DATE(K54,B63,1),DATE(K54,B64,1)-1,I55:I68)","v":21},0.95,{"$f":"C63/(SUM(C56:C67)/12)","v":1},0.95,16.229166666666664,null,{"$f":"I58+50","v":"2026-05-25"},"Pfingstmontag"]
[{"$f":"K54&\"-\"&TEXT(B64,\"00\")","v":"2026-09"},9,{"$f":"NETWORKDAYS(DATE(K54,B64,1),DATE(K54,B65,1)-1,I55:I68)","v":22},0.99523809523809526,{"$f":"C64/(SUM(C56:C67)/12)","v":1.0476190476190477},0.95,17.001984126984127,null,{"$f":"I58+60","v":"2026-06-04"},"Fronleichnam"]
[{"$f":"K54&\"-\"&TEXT(B65,\"00\")","v":"2026-10"},10,{"$f":"NETWORKDAYS(DATE(K54,B65,1),DATE(K54,B66,1)-1,I55:I68)","v":22},1.0685714285714287,{"$f":"C65/(SUM(C56:C67)/12)","v":1.0476190476190477},1.02,18.254761904761907,null,{"$f":"DATE(K54,10,3)","v":"2026-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K54&\"-\"&TEXT(B66,\"00\")","v":"2026-11"},11,{"$f":"NETWORKDAYS(DATE(K54,B66,1),DATE(K54,B67,1)-1,I55:I68)","v":21},1.04,{"$f":"C66/(SUM(C56:C67)/12)","v":1},1.04,17.766666666666666,null,{"$f":"DATE(K54,11,1)","v":"2026-11-01"},"Allerheiligen"]
[{"$f":"K54&\"-\"&TEXT(B67,\"00\")","v":"2026-12"},12,{"$f":"NETWORKDAYS(DATE(K54,B67,1),DATE(K54+1,1,1)-1,I55:I68)","v":22},0.93238095238095242,{"$f":"C67/(SUM(C56:C67)/12)","v":1.0476190476190477},0.89,15.928174603174602,null,{"$f":"DATE(K54,12,25)","v":"2026-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K54,12,26)","v":"2026-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K70","v":"calculation of brutto working days per month in 2027"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K54+1","v":2027}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K70,1,1)","v":"2027-01-01"},"Neujahr"]
[{"$f":"K70&\"-\"&TEXT(B72,\"00\")","v":"2027-01"},1,{"$f":"NETWORKDAYS(DATE(K70,B72,1),DATE(K70,B73,1)-1,I71:I84)","v":19},{"$f":"E72*F72","v":0.91920948616600795},{"$f":"C72/(SUM(C72:C83)/12)","v":0.90118577075098816},{"$f":"F56","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D72)","v":15.703162055335968},null,{"$f":"DATE(K70,1,6)","v":"2027-01-06"},"Dreikönigstag"]
[{"$f":"K70&\"-\"&TEXT(B73,\"00\")","v":"2027-02"},2,{"$f":"NETWORKDAYS(DATE(K70,B73,1),DATE(K70,B74,1)-1,I71:I84)","v":20},0.99604743083003966,{"$f":"C73/(SUM(C72:C83)/12)","v":0.94861660079051391},{"$f":"F57","v":1.05},17.015810276679844,null,{"$f":"I74-2","v":"2027-03-26"},"Karfreitag"]
[{"$f":"K70&\"-\"&TEXT(B74,\"00\")","v":"2027-03"},3,{"$f":"NETWORKDAYS(DATE(K70,B74,1),DATE(K70,B75,1)-1,I71:I84)","v":21},0.98608695652173917,{"$f":"C74/(SUM(C72:C83)/12)","v":0.99604743083003955},0.99,16.845652173913042,null,{"$f":"DOLLAR((DAY(MINUTE(K70/38)/2+55)&\".4.\"&K70)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2027-03-28"},"Ostersonntag"]
[{"$f":"K70&\"-\"&TEXT(B75,\"00\")","v":"2027-04"},4,{"$f":"NETWORKDAYS(DATE(K70,B75,1),DATE(K70,B76,1)-1,I71:I84)","v":22},1.0852173913043479,{"$f":"C75/(SUM(C72:C83)/12)","v":1.0434782608695652},1.04,18.53913043478261,null,{"$f":"I74+1","v":"2027-03-29"},"Ostermontag"]
[{"$f":"K70&\"-\"&TEXT(B76,\"00\")","v":"2027-05"},5,{"$f":"NETWORKDAYS(DATE(K70,B76,1),DATE(K70,B77,1)-1,I71:I84)","v":18},0.87936758893280642,{"$f":"C76/(SUM(C72:C83)/12)","v":0.85375494071146252},1.03,15.022529644268776,null,{"$f":"DATE(K70,5,1)","v":"2027-05-01"},"Tag der Arbeit"]
[{"$f":"K70&\"-\"&TEXT(B77,\"00\")","v":"2027-06"},6,{"$f":"NETWORKDAYS(DATE(K70,B77,1),DATE(K70,B78,1)-1,I71:I84)","v":22},1.0330434782608695,{"$f":"C77/(SUM(C72:C83)/12)","v":1.0434782608695652},0.99,17.64782608695652,null,{"$f":"I74+39","v":"2027-05-06"},"Christi Himmelfahrt"]
[{"$f":"K70&\"-\"&TEXT(B78,\"00\")","v":"2027-07"},7,{"$f":"NETWORKDAYS(DATE(K70,B78,1),DATE(K70,B79,1)-1,I71:I84)","v":22},1.0747826086956522,{"$f":"C78/(SUM(C72:C83)/12)","v":1.0434782608695652},1.03,18.360869565217392,null,{"$f":"I74+49","v":"2027-05-16"},"Pfingstsonntag"]
[{"$f":"K70&\"-\"&TEXT(B79,\"00\")","v":"2027-08"},8,{"$f":"NETWORKDAYS(DATE(K70,B79,1),DATE(K70,B80,1)-1,I71:I84)","v":22},0.9913043478260869,{"$f":"C79/(SUM(C72:C83)/12)","v":1.0434782608695652},0.95,16.934782608695649,null,{"$f":"I74+50","v":"2027-05-17"},"Pfingstmontag"]
[{"$f":"K70&\"-\"&TEXT(B80,\"00\")","v":"2027-09"},9,{"$f":"NETWORKDAYS(DATE(K70,B80,1),DATE(K70,B81,1)-1,I71:I84)","v":22},0.9913043478260869,{"$f":"C80/(SUM(C72:C83)/12)","v":1.0434782608695652},0.95,16.934782608695649,null,{"$f":"I74+60","v":"2027-05-27"},"Fronleichnam"]
[{"$f":"K70&\"-\"&TEXT(B81,\"00\")","v":"2027-10"},10,{"$f":"NETWORKDAYS(DATE(K70,B81,1),DATE(K70,B82,1)-1,I71:I84)","v":21},1.0159683794466403,{"$f":"C81/(SUM(C72:C83)/12)","v":0.99604743083003955},1.02,17.356126482213437,null,{"$f":"DATE(K70,10,3)","v":"2027-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K70&\"-\"&TEXT(B82,\"00\")","v":"2027-11"},11,{"$f":"NETWORKDAYS(DATE(K70,B82,1),DATE(K70,B83,1)-1,I71:I84)","v":21},1.0358893280632411,{"$f":"C82/(SUM(C72:C83)/12)","v":0.99604743083003955},1.04,17.696442687747034,null,{"$f":"DATE(K70,11,1)","v":"2027-11-01"},"Allerheiligen"]
[{"$f":"K70&\"-\"&TEXT(B83,\"00\")","v":"2027-12"},12,{"$f":"NETWORKDAYS(DATE(K70,B83,1),DATE(K70+1,1,1)-1,I71:I84)","v":23},0.97090909090909105,{"$f":"C83/(SUM(C72:C83)/12)","v":1.0909090909090911},0.89,16.586363636363636,null,{"$f":"DATE(K70,12,25)","v":"2027-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K70,12,26)","v":"2027-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K86","v":"calculation of brutto working days per month in 2028"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K70+1","v":2028}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K86,1,1)","v":"2028-01-01"},"Neujahr"]
[{"$f":"K86&\"-\"&TEXT(B88,\"00\")","v":"2028-01"},1,{"$f":"NETWORKDAYS(DATE(K86,B88,1),DATE(K86,B89,1)-1,I87:I100)","v":20},{"$f":"E88*F88","v":0.98313253012048196},{"$f":"C88/(SUM(C88:C99)/12)","v":0.96385542168674698},{"$f":"F72","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D88)","v":16.795180722891565},null,{"$f":"DATE(K86,1,6)","v":"2028-01-06"},"Dreikönigstag"]
[{"$f":"K86&\"-\"&TEXT(B89,\"00\")","v":"2028-02"},2,{"$f":"NETWORKDAYS(DATE(K86,B89,1),DATE(K86,B90,1)-1,I87:I100)","v":21},1.0626506024096385,{"$f":"C89/(SUM(C88:C99)/12)","v":1.0120481927710843},{"$f":"F73","v":1.05},18.153614457831324,null,{"$f":"I90-2","v":"2028-04-14"},"Karfreitag"]
[{"$f":"K86&\"-\"&TEXT(B90,\"00\")","v":"2028-03"},3,{"$f":"NETWORKDAYS(DATE(K86,B90,1),DATE(K86,B91,1)-1,I87:I100)","v":23},1.0973493975903614,{"$f":"C90/(SUM(C88:C99)/12)","v":1.1084337349397591},0.99,18.746385542168674,null,{"$f":"DOLLAR((DAY(MINUTE(K86/38)/2+55)&\".4.\"&K86)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2028-04-16"},"Ostersonntag"]
[{"$f":"K86&\"-\"&TEXT(B91,\"00\")","v":"2028-04"},4,{"$f":"NETWORKDAYS(DATE(K86,B91,1),DATE(K86,B92,1)-1,I87:I100)","v":18},0.90216867469879525,{"$f":"C91/(SUM(C88:C99)/12)","v":0.86746987951807231},1.04,15.412048192771085,null,{"$f":"I90+1","v":"2028-04-17"},"Ostermontag"]
[{"$f":"K86&\"-\"&TEXT(B92,\"00\")","v":"2028-05"},5,{"$f":"NETWORKDAYS(DATE(K86,B92,1),DATE(K86,B93,1)-1,I87:I100)","v":21},1.0424096385542168,{"$f":"C92/(SUM(C88:C99)/12)","v":1.0120481927710843},1.03,17.807831325301201,null,{"$f":"DATE(K86,5,1)","v":"2028-05-01"},"Tag der Arbeit"]
[{"$f":"K86&\"-\"&TEXT(B93,\"00\")","v":"2028-06"},6,{"$f":"NETWORKDAYS(DATE(K86,B93,1),DATE(K86,B94,1)-1,I87:I100)","v":20},0.95421686746987955,{"$f":"C93/(SUM(C88:C99)/12)","v":0.96385542168674698},0.99,16.301204819277107,null,{"$f":"I90+39","v":"2028-05-25"},"Christi Himmelfahrt"]
[{"$f":"K86&\"-\"&TEXT(B94,\"00\")","v":"2028-07"},7,{"$f":"NETWORKDAYS(DATE(K86,B94,1),DATE(K86,B95,1)-1,I87:I100)","v":21},1.0424096385542168,{"$f":"C94/(SUM(C88:C99)/12)","v":1.0120481927710843},1.03,17.807831325301201,null,{"$f":"I90+49","v":"2028-06-04"},"Pfingstsonntag"]
[{"$f":"K86&\"-\"&TEXT(B95,\"00\")","v":"2028-08"},8,{"$f":"NETWORKDAYS(DATE(K86,B95,1),DATE(K86,B96,1)-1,I87:I100)","v":23},1.0530120481927709,{"$f":"C95/(SUM(C88:C99)/12)","v":1.1084337349397591},0.95,17.988955823293168,null,{"$f":"I90+50","v":"2028-06-05"},"Pfingstmontag"]
[{"$f":"K86&\"-\"&TEXT(B96,\"00\")","v":"2028-09"},9,{"$f":"NETWORKDAYS(DATE(K86,B96,1),DATE(K86,B97,1)-1,I87:I100)","v":21},0.96144578313253004,{"$f":"C96/(SUM(C88:C99)/12)","v":1.0120481927710843},0.95,16.424698795180721,null,{"$f":"I90+60","v":"2028-06-15"},"Fronleichnam"]
[{"$f":"K86&\"-\"&TEXT(B97,\"00\")","v":"2028-10"},10,{"$f":"NETWORKDAYS(DATE(K86,B97,1),DATE(K86,B98,1)-1,I87:I100)","v":21},1.032289156626506,{"$f":"C97/(SUM(C88:C99)/12)","v":1.0120481927710843},1.02,17.634939759036143,null,{"$f":"DATE(K86,10,3)","v":"2028-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K86&\"-\"&TEXT(B98,\"00\")","v":"2028-11"},11,{"$f":"NETWORKDAYS(DATE(K86,B98,1),DATE(K86,B99,1)-1,I87:I100)","v":21},1.0525301204819277,{"$f":"C98/(SUM(C88:C99)/12)","v":1.0120481927710843},1.04,17.980722891566263,null,{"$f":"DATE(K86,11,1)","v":"2028-11-01"},"Allerheiligen"]
[{"$f":"K86&\"-\"&TEXT(B99,\"00\")","v":"2028-12"},12,{"$f":"NETWORKDAYS(DATE(K86,B99,1),DATE(K86+1,1,1)-1,I87:I100)","v":19},0.81493975903614457,{"$f":"C99/(SUM(C88:C99)/12)","v":0.91566265060240959},0.89,13.921887550200802,null,{"$f":"DATE(K86,12,25)","v":"2028-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K86,12,26)","v":"2028-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K102","v":"calculation of brutto working days per month in 2029"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K86+1","v":2029}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K102,1,1)","v":"2029-01-01"},"Neujahr"]
[{"$f":"K102&\"-\"&TEXT(B104,\"00\")","v":"2029-01"},1,{"$f":"NETWORKDAYS(DATE(K102,B104,1),DATE(K102,B105,1)-1,I103:I116)","v":22},{"$f":"E104*F104","v":1.0771200000000001},{"$f":"C104/(SUM(C104:C115)/12)","v":1.056},{"$f":"F88","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D104)","v":18.4008},null,{"$f":"DATE(K102,1,6)","v":"2029-01-06"},"Dreikönigstag"]
[{"$f":"K102&\"-\"&TEXT(B105,\"00\")","v":"2029-02"},2,{"$f":"NETWORKDAYS(DATE(K102,B105,1),DATE(K102,B106,1)-1,I103:I116)","v":20},1.0080000000000002,{"$f":"C105/(SUM(C104:C115)/12)","v":0.96000000000000008},{"$f":"F89","v":1.05},17.220000000000002,null,{"$f":"I106-2","v":"2029-03-30"},"Karfreitag"]
[{"$f":"K102&\"-\"&TEXT(B106,\"00\")","v":"2029-03"},3,{"$f":"NETWORKDAYS(DATE(K102,B106,1),DATE(K102,B107,1)-1,I103:I116)","v":21},0.99792000000000003,{"$f":"C106/(SUM(C104:C115)/12)","v":1.008},0.99,17.047799999999999,null,{"$f":"DOLLAR((DAY(MINUTE(K102/38)/2+55)&\".4.\"&K102)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2029-04-01"},"Ostersonntag"]
[{"$f":"K102&\"-\"&TEXT(B107,\"00\")","v":"2029-04"},4,{"$f":"NETWORKDAYS(DATE(K102,B107,1),DATE(K102,B108,1)-1,I103:I116)","v":20},0.99840000000000007,{"$f":"C107/(SUM(C104:C115)/12)","v":0.96000000000000008},1.04,17.056000000000001,null,{"$f":"I106+1","v":"2029-04-02"},"Ostermontag"]
[{"$f":"K102&\"-\"&TEXT(B108,\"00\")","v":"2029-05"},5,{"$f":"NETWORKDAYS(DATE(K102,B108,1),DATE(K102,B109,1)-1,I103:I116)","v":19},0.93936000000000008,{"$f":"C108/(SUM(C104:C115)/12)","v":0.91200000000000003},1.03,16.0474,null,{"$f":"DATE(K102,5,1)","v":"2029-05-01"},"Tag der Arbeit"]
[{"$f":"K102&\"-\"&TEXT(B109,\"00\")","v":"2029-06"},6,{"$f":"NETWORKDAYS(DATE(K102,B109,1),DATE(K102,B110,1)-1,I103:I116)","v":21},0.99792000000000003,{"$f":"C109/(SUM(C104:C115)/12)","v":1.008},0.99,17.047799999999999,null,{"$f":"I106+39","v":"2029-05-10"},"Christi Himmelfahrt"]
[{"$f":"K102&\"-\"&TEXT(B110,\"00\")","v":"2029-07"},7,{"$f":"NETWORKDAYS(DATE(K102,B110,1),DATE(K102,B111,1)-1,I103:I116)","v":22},1.08768,{"$f":"C110/(SUM(C104:C115)/12)","v":1.056},1.03,18.581199999999999,null,{"$f":"I106+49","v":"2029-05-20"},"Pfingstsonntag"]
[{"$f":"K102&\"-\"&TEXT(B111,\"00\")","v":"2029-08"},8,{"$f":"NETWORKDAYS(DATE(K102,B111,1),DATE(K102,B112,1)-1,I103:I116)","v":23},1.0488,{"$f":"C111/(SUM(C104:C115)/12)","v":1.1040000000000001},0.95,17.916999999999998,null,{"$f":"I106+50","v":"2029-05-21"},"Pfingstmontag"]
[{"$f":"K102&\"-\"&TEXT(B112,\"00\")","v":"2029-09"},9,{"$f":"NETWORKDAYS(DATE(K102,B112,1),DATE(K102,B113,1)-1,I103:I116)","v":20},0.91200000000000003,{"$f":"C112/(SUM(C104:C115)/12)","v":0.96000000000000008},0.95,15.58,null,{"$f":"I106+60","v":"2029-05-31"},"Fronleichnam"]
[{"$f":"K102&\"-\"&TEXT(B113,\"00\")","v":"2029-10"},10,{"$f":"NETWORKDAYS(DATE(K102,B113,1),DATE(K102,B114,1)-1,I103:I116)","v":22},1.0771200000000001,{"$f":"C113/(SUM(C104:C115)/12)","v":1.056},1.02,18.4008,null,{"$f":"DATE(K102,10,3)","v":"2029-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K102&\"-\"&TEXT(B114,\"00\")","v":"2029-11"},11,{"$f":"NETWORKDAYS(DATE(K102,B114,1),DATE(K102,B115,1)-1,I103:I116)","v":21},1.0483200000000001,{"$f":"C114/(SUM(C104:C115)/12)","v":1.008},1.04,17.908799999999999,null,{"$f":"DATE(K102,11,1)","v":"2029-11-01"},"Allerheiligen"]
[{"$f":"K102&\"-\"&TEXT(B115,\"00\")","v":"2029-12"},12,{"$f":"NETWORKDAYS(DATE(K102,B115,1),DATE(K102+1,1,1)-1,I103:I116)","v":19},0.81168000000000007,{"$f":"C115/(SUM(C104:C115)/12)","v":0.91200000000000003},0.89,13.866200000000001,null,{"$f":"DATE(K102,12,25)","v":"2029-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K102,12,26)","v":"2029-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K118","v":"calculation of brutto working days per month in 2030"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K102+1","v":2030}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K118,1,1)","v":"2030-01-01"},"Neujahr"]
[{"$f":"K118&\"-\"&TEXT(B120,\"00\")","v":"2030-01"},1,{"$f":"NETWORKDAYS(DATE(K118,B120,1),DATE(K118,B121,1)-1,I119:I132)","v":22},{"$f":"E120*F120","v":1.0771200000000001},{"$f":"C120/(SUM(C120:C131)/12)","v":1.056},{"$f":"F104","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D120)","v":18.4008},null,{"$f":"DATE(K118,1,6)","v":"2030-01-06"},"Dreikönigstag"]
[{"$f":"K118&\"-\"&TEXT(B121,\"00\")","v":"2030-02"},2,{"$f":"NETWORKDAYS(DATE(K118,B121,1),DATE(K118,B122,1)-1,I119:I132)","v":20},1.0080000000000002,{"$f":"C121/(SUM(C120:C131)/12)","v":0.96000000000000008},{"$f":"F105","v":1.05},17.220000000000002,null,{"$f":"I122-2","v":"2030-04-19"},"Karfreitag"]
[{"$f":"K118&\"-\"&TEXT(B122,\"00\")","v":"2030-03"},3,{"$f":"NETWORKDAYS(DATE(K118,B122,1),DATE(K118,B123,1)-1,I119:I132)","v":21},0.99792000000000003,{"$f":"C122/(SUM(C120:C131)/12)","v":1.008},0.99,17.047799999999999,null,{"$f":"DOLLAR((DAY(MINUTE(K118/38)/2+55)&\".4.\"&K118)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2030-04-21"},"Ostersonntag"]
[{"$f":"K118&\"-\"&TEXT(B123,\"00\")","v":"2030-04"},4,{"$f":"NETWORKDAYS(DATE(K118,B123,1),DATE(K118,B124,1)-1,I119:I132)","v":20},0.99840000000000007,{"$f":"C123/(SUM(C120:C131)/12)","v":0.96000000000000008},1.04,17.056000000000001,null,{"$f":"I122+1","v":"2030-04-22"},"Ostermontag"]
[{"$f":"K118&\"-\"&TEXT(B124,\"00\")","v":"2030-05"},5,{"$f":"NETWORKDAYS(DATE(K118,B124,1),DATE(K118,B125,1)-1,I119:I132)","v":21},1.0382400000000001,{"$f":"C124/(SUM(C120:C131)/12)","v":1.008},1.03,17.736599999999999,null,{"$f":"DATE(K118,5,1)","v":"2030-05-01"},"Tag der Arbeit"]
[{"$f":"K118&\"-\"&TEXT(B125,\"00\")","v":"2030-06"},6,{"$f":"NETWORKDAYS(DATE(K118,B125,1),DATE(K118,B126,1)-1,I119:I132)","v":18},0.85536000000000012,{"$f":"C125/(SUM(C120:C131)/12)","v":0.8640000000000001},0.99,14.612400000000001,null,{"$f":"I122+39","v":"2030-05-30"},"Christi Himmelfahrt"]
[{"$f":"K118&\"-\"&TEXT(B126,\"00\")","v":"2030-07"},7,{"$f":"NETWORKDAYS(DATE(K118,B126,1),DATE(K118,B127,1)-1,I119:I132)","v":23},1.1371200000000001,{"$f":"C126/(SUM(C120:C131)/12)","v":1.1040000000000001},1.03,19.425800000000002,null,{"$f":"I122+49","v":"2030-06-09"},"Pfingstsonntag"]
[{"$f":"K118&\"-\"&TEXT(B127,\"00\")","v":"2030-08"},8,{"$f":"NETWORKDAYS(DATE(K118,B127,1),DATE(K118,B128,1)-1,I119:I132)","v":22},1.0032000000000001,{"$f":"C127/(SUM(C120:C131)/12)","v":1.056},0.95,17.138000000000002,null,{"$f":"I122+50","v":"2030-06-10"},"Pfingstmontag"]
[{"$f":"K118&\"-\"&TEXT(B128,\"00\")","v":"2030-09"},9,{"$f":"NETWORKDAYS(DATE(K118,B128,1),DATE(K118,B129,1)-1,I119:I132)","v":21},0.95760000000000001,{"$f":"C128/(SUM(C120:C131)/12)","v":1.008},0.95,16.358999999999998,null,{"$f":"I122+60","v":"2030-06-20"},"Fronleichnam"]
[{"$f":"K118&\"-\"&TEXT(B129,\"00\")","v":"2030-10"},10,{"$f":"NETWORKDAYS(DATE(K118,B129,1),DATE(K118,B130,1)-1,I119:I132)","v":22},1.0771200000000001,{"$f":"C129/(SUM(C120:C131)/12)","v":1.056},1.02,18.4008,null,{"$f":"DATE(K118,10,3)","v":"2030-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K118&\"-\"&TEXT(B130,\"00\")","v":"2030-11"},11,{"$f":"NETWORKDAYS(DATE(K118,B130,1),DATE(K118,B131,1)-1,I119:I132)","v":20},0.99840000000000007,{"$f":"C130/(SUM(C120:C131)/12)","v":0.96000000000000008},1.04,17.056000000000001,null,{"$f":"DATE(K118,11,1)","v":"2030-11-01"},"Allerheiligen"]
[{"$f":"K118&\"-\"&TEXT(B131,\"00\")","v":"2030-12"},12,{"$f":"NETWORKDAYS(DATE(K118,B131,1),DATE(K118+1,1,1)-1,I119:I132)","v":20},0.85440000000000005,{"$f":"C131/(SUM(C120:C131)/12)","v":0.96000000000000008},0.89,14.596,null,{"$f":"DATE(K118,12,25)","v":"2030-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K118,12,26)","v":"2030-12-26"},"2. Weihnachtsfeiertag"]
[]
[{"$f":"\"calculation of brutto working days per month in \"&K134","v":"calculation of brutto working days per month in 2031"},null,null,null,null,null,null,null,"bank holidays for year",null,{"$f":"K118+1","v":2031}]
["key","month","working days","resulting envelope","working days envelope","illness/vacation envelope","mean brutto working days",null,{"$f":"DATE(K134,1,1)","v":"2031-01-01"},"Neujahr"]
[{"$f":"K134&\"-\"&TEXT(B136,\"00\")","v":"2031-01"},1,{"$f":"NETWORKDAYS(DATE(K134,B136,1),DATE(K134,B137,1)-1,I135:I148)","v":21},{"$f":"E136*F136","v":1.02816},{"$f":"C136/(SUM(C136:C147)/12)","v":1.008},{"$f":"F120","v":1.02},{"$f":"PPDYear/12*IF(CapaModel=\"simple\",1,D136)","v":17.564399999999999},null,{"$f":"DATE(K134,1,6)","v":"2031-01-06"},"Dreikönigstag"]
[{"$f":"K134&\"-\"&TEXT(B137,\"00\")","v":"2031-02"},2,{"$f":"NETWORKDAYS(DATE(K134,B137,1),DATE(K134,B138,1)-1,I135:I148)","v":20},1.0080000000000002,{"$f":"C137/(SUM(C136:C147)/12)","v":0.96000000000000008},{"$f":"F121","v":1.05},17.220000000000002,null,{"$f":"I138-2","v":"2031-04-11"},"Karfreitag"]
[{"$f":"K134&\"-\"&TEXT(B138,\"00\")","v":"2031-03"},3,{"$f":"NETWORKDAYS(DATE(K134,B138,1),DATE(K134,B139,1)-1,I135:I148)","v":21},0.99792000000000003,{"$f":"C138/(SUM(C136:C147)/12)","v":1.008},0.99,17.047799999999999,null,{"$f":"DOLLAR((DAY(MINUTE(K134/38)/2+55)&\".4.\"&K134)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2031-04-13"},"Ostersonntag"]
[{"$f":"K134&\"-\"&TEXT(B139,\"00\")","v":"2031-04"},4,{"$f":"NETWORKDAYS(DATE(K134,B139,1),DATE(K134,B140,1)-1,I135:I148)","v":20},0.99840000000000007,{"$f":"C139/(SUM(C136:C147)/12)","v":0.96000000000000008},1.04,17.056000000000001,null,{"$f":"I138+1","v":"2031-04-14"},"Ostermontag"]
[{"$f":"K134&\"-\"&TEXT(B140,\"00\")","v":"2031-05"},5,{"$f":"NETWORKDAYS(DATE(K134,B140,1),DATE(K134,B141,1)-1,I135:I148)","v":20},0.98880000000000012,{"$f":"C140/(SUM(C136:C147)/12)","v":0.96000000000000008},1.03,16.891999999999999,null,{"$f":"DATE(K134,5,1)","v":"2031-05-01"},"Tag der Arbeit"]
[{"$f":"K134&\"-\"&TEXT(B141,\"00\")","v":"2031-06"},6,{"$f":"NETWORKDAYS(DATE(K134,B141,1),DATE(K134,B142,1)-1,I135:I148)","v":19},0.90288000000000002,{"$f":"C141/(SUM(C136:C147)/12)","v":0.91200000000000003},0.99,15.424199999999999,null,{"$f":"I138+39","v":"2031-05-22"},"Christi Himmelfahrt"]
[{"$f":"K134&\"-\"&TEXT(B142,\"00\")","v":"2031-07"},7,{"$f":"NETWORKDAYS(DATE(K134,B142,1),DATE(K134,B143,1)-1,I135:I148)","v":23},1.1371200000000001,{"$f":"C142/(SUM(C136:C147)/12)","v":1.1040000000000001},1.03,19.425800000000002,null,{"$f":"I138+49","v":"2031-06-01"},"Pfingstsonntag"]
[{"$f":"K134&\"-\"&TEXT(B143,\"00\")","v":"2031-08"},8,{"$f":"NETWORKDAYS(DATE(K134,B143,1),DATE(K134,B144,1)-1,I135:I148)","v":21},0.95760000000000001,{"$f":"C143/(SUM(C136:C147)/12)","v":1.008},0.95,16.358999999999998,null,{"$f":"I138+50","v":"2031-06-02"},"Pfingstmontag"]
[{"$f":"K134&\"-\"&TEXT(B144,\"00\")","v":"2031-09"},9,{"$f":"NETWORKDAYS(DATE(K134,B144,1),DATE(K134,B145,1)-1,I135:I148)","v":22},1.0032000000000001,{"$f":"C144/(SUM(C136:C147)/12)","v":1.056},0.95,17.138000000000002,null,{"$f":"I138+60","v":"2031-06-12"},"Fronleichnam"]
[{"$f":"K134&\"-\"&TEXT(B145,\"00\")","v":"2031-10"},10,{"$f":"NETWORKDAYS(DATE(K134,B145,1),DATE(K134,B146,1)-1,I135:I148)","v":22},1.0771200000000001,{"$f":"C145/(SUM(C136:C147)/12)","v":1.056},1.02,18.4008,null,{"$f":"DATE(K134,10,3)","v":"2031-10-03"},"Tag der deutschen Einheit"]
[{"$f":"K134&\"-\"&TEXT(B146,\"00\")","v":"2031-11"},11,{"$f":"NETWORKDAYS(DATE(K134,B146,1),DATE(K134,B147,1)-1,I135:I148)","v":20},0.99840000000000007,{"$f":"C146/(SUM(C136:C147)/12)","v":0.96000000000000008},1.04,17.056000000000001,null,{"$f":"DATE(K134,11,1)","v":"2031-11-01"},"Allerheiligen"]
[{"$f":"K134&\"-\"&TEXT(B147,\"00\")","v":"2031-12"},12,{"$f":"NETWORKDAYS(DATE(K134,B147,1),DATE(K134+1,1,1)-1,I135:I148)","v":21},0.89712000000000003,{"$f":"C147/(SUM(C136:C147)/12)","v":1.008},0.89,15.325799999999999,null,{"$f":"DATE(K134,12,25)","v":"2031-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,null,null,{"$f":"DATE(K134,12,26)","v":"2031-12-26"},"2. Weihnachtsfeiertag"]

{"sheet":"Backlog","index":19,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["prio","missing features","requested","finished","Version"]
["A","marker for Virtual Constraint/Drum as stagining phase for EssentialFlow","2022-12-24","2023-01-01","3.0"]
["A","staggering/roadmap view with 3 phase before,in,after (bia) contstaint","2022-12-24","2023-01-01","3.0"]
["A","generating the bia-dates","2022-12-24","2023-01-01","3.0"]
["A","execution management based on bia-phase status - messages based on status & reporting date versus bia-phase-dates","2022-12-24","2023-01-03","3.0"]
["A","reporting date of status report - messages based on reporting date - reporting status","2022-12-24","2023-01-03","3.0"]
["A","remaining duration in phase - messages if phase overrun","2022-12-24","2023-01-03","3.0"]
["A","buffer regain meassures with due-date (removed in anonymous export)","2022-12-24","2023-01-03","3.0"]
["A","export of 3phase staggering for A-Dato/Lynx","2022-12-24",null,"3.1"]
["A","export of project structure with ressources for A-Dato/Lynx","2022-12-24",null,"3.1"]
["B","extended buffer regain meassures, days to recover, cost, cost-of-delay if not done","2022-12-24"]
["B","externalize the translation table for anonymous export to have stable ID's","2022-09-17"]
["B","full blown xml-export of anonymous Data","2022-09-17"]
["B","bugfix - there is something wrong with TBP% and many projects","2022-09-11"]
["C","moving offset with end-of-year-overflow - there is not 13. month!","2022-09-11"]
["C","moving offset without green background","2022-09-07"]
["C","shifting projects without shifting old efforts into future","2013-01-05"]
["E","confirmed and open efforts","2013-01-07"]
["E","automated pipelininge (with explicit buffer quota)","2013-01-05"]
["E","automated business value optimization ","2013-01-05"]
["X","anonymous export to exchange data with others to get feedback","2022-09-06","2022-09-17","2.2.1"]
["X","Possibility to import data and genearte Sheets automatically","2022-09-01","2022-09-05","2.1.3"]
["X","relative load and graphical representation","2018-06-01","2018-08-17"]
["X","backlinks from projects sheets to project list","2014-02-21","2014-08-03"]
["X","year overspanning CapacityModel, CapacityData and FTE-Table in Teamlist","2014-06-01","2014-07-11"]
["X","colours for projects","2013-11-01","2013-11-17"]
["X","quick move of projects with macro","2013-05-15","2013-05-15"]
["X","including capacity model","2013-01-21","2013-01-21"]
["X","including capacity data according to model","2013-01-21","2013-01-21"]
["X","raw output","2013-01-05","2013-01-17"]
["X","additional speed up (no display, no calculation) and status bar","2013-01-16","2013-01-17"]
["X","team load factor diagram","2013-01-05","2013-01-16"]
["X","Zirkelbezug wenn ein Team keine Load hatte","2013-01-16","2013-01-16"]
["X","Capa ohne Nachkommastellen","2013-01-15","2013-01-16"]
["X","Porjekte ohne Kapa im Team weglassen","2013-01-15","2013-01-16"]
["X","integrated capacity data model","2013-01-05","2013-01-15"]
["X","acitve non active","2013-01-08","2013-01-05"]
["X","messages is something seems/is wrong","2013-01-06","2013-01-05"]
["X","nice colours in the tbp, e.g. for overload, load, headlines, and numberformats","2013-01-03","2013-01-04"]
["X","formatting of all other sheets","2013-01-03","2013-01-04"]
["X","average load","2013-01-04","2013-01-04"]
["X","start button in Project list","2013-01-04","2013-01-04"]
["X","project list with links to sheets - boekhoff style","2013-01-03","2013-01-04"]
["X","project end info in project list","2013-01-03","2013-01-04"]
["X","team name lookup","2013-01-04","2013-01-04"]
["X","bug: project in wrong order in tbph","2013-01-04","2013-01-04"]
["X","aggregated overload","2013-01-05","2013-01-05"]
["X","colored overload","2013-01-05","2013-01-05"]
["X","project end date wrong for project not finished in the tbp time frame","2013-01-05","2013-01-05"]
["X","variable project effort table position in project sheets","2031-01-04","2013-01-05"]
["X","clean code","2013-01-03","2013-01-05"]
["X","speed code","2013-01-04","2013-01-05"]

{"sheet":"Colorindex","index":20,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["ColorIndex"]
[0]
[1,null,43]
[2,null,45]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[]
[44]
[]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]