{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Simple","Complex","Einfach","Komplex"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Simple","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,5,1,6]]}
[null,null,"Sales Limit for no vacation:",null,"Higher Sales Limit for no vacation:","Overwritten with higher value to allow for vacation in month\n<- with max sales"]
[null,null,{"$f":"MAX(B5:B16)","v":24000},null,28000]
[null,"Sales","Vacation (strict)","Vacation (strict)","Vacation (moderate)","Vacation (moderate)"]
["Total",{"$f":"SUM(B5:B16)","v":230000},83,null,83]
["January",20000,{"$f":"(C$2-$B5:$B16)/(C$2*12-$B$4)*C$4","v":5.7241379310344831},{"$f":"TRANSPOSE(RoundToSum(C5:C16,0))","v":6},{"$f":"(E$2-$B5:$B16)/(E$2*12-$B$4)*E$4","v":6.2641509433962259},{"$f":"TRANSPOSE(RoundToSum(E5:E16,0))","v":6}]
["February",24000,0,0,3.132075471698113,3]
["March",23000,1.4310344827586208,1,3.9150943396226419,4]
["April",20000,5.7241379310344831,6,6.2641509433962259,6]
["May",19000,7.1551724137931041,7,7.0471698113207539,7]
["June",15000,12.879310344827587,13,10.179245283018869,10]
["July",14000,14.310344827586208,14,10.962264150943396,11]
["August",17000,10.017241379310345,10,8.6132075471698109,9]
["September",21000,4.2931034482758621,4,5.4811320754716979,6]
["October",20000,5.7241379310344831,6,6.2641509433962259,6]
["November",19000,7.1551724137931041,7,7.0471698113207539,7]
["December",18000,8.5862068965517242,9,7.8301886792452837,8]
[null,"Checksum Vacation",{"$f":"SUM(C5:C16)","v":83.000000000000014},{"$f":"SUM(D5:D16)","v":83},{"$f":"SUM(E5:E16)","v":83},{"$f":"SUM(F5:F16)","v":83}]

{"sheet":"Complex","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,"Sales Limit for no vacation:"]
[null,null,{"$f":"MAX(B5:B16)","v":24000},"<- Overwrite with higher value to allow for vacation in month with max sales"]
[null,"Sales","Vacation days (fractional)","Vacation days (integer)","Vacation Claim"]
["Total",{"$f":"SUM(B5:B16)","v":230000},null,null,"Andrew","Benjamin","Charlie","David"]
["January",20000,{"$f":"($C$2-B5:B16)/($C$2*12-$B$4)*$C$17","v":5.7241379310344831},{"$f":"TRANSPOSE(RoundToSum(C5:C16,0))","v":6},"x","x",null,"x"]
["February",24000,0,0,"x","x",null,"x"]
["March",23000,1.4310344827586208,1,"x","x","x","x"]
["April",20000,5.7241379310344831,6,"x","x","x","x"]
["May",19000,7.1551724137931041,7,"x","x","x"]
["June",15000,12.879310344827587,13,"x","x","x"]
["July",14000,14.310344827586208,14,"x","x","x"]
["August",17000,10.017241379310345,10,"x","x","x"]
["September",21000,4.2931034482758621,4,"x","x","x","x"]
["October",20000,5.7241379310344831,6,"x","x","x","x"]
["November",19000,7.1551724137931041,7,"x",null,"x","x"]
["December",18000,8.5862068965517242,9,"x",null,"x","x"]
[null,"Total",{"$f":"SUM(E17:H17)","v":83},{"$f":"SUM(D5:D16)","v":83},25,21,21,16]
[]
[null,null,null,"Vacation days (fractional)"]
[null,null,null,"Total",{"$f":"E4","v":"Andrew"},{"$f":"F4","v":"Benjamin"},{"$f":"G4","v":"Charlie"},{"$f":"H4","v":"David"}]
[null,null,{"$f":"A5:A16","v":"January"},{"$f":"SUM(E21:H21)","v":6.1493643921264853},{"$f":"IFERROR((E$5:E$16=\"x\")*E$17*$D$5:$D$16/SUM((E$5:E$16=\"x\")*$D$5:$D$16),0)","v":1.8072289156626506},{"$f":"IFERROR((F$5:F$16=\"x\")*F$17*$D$5:$D$16/SUM((F$5:F$16=\"x\")*$D$5:$D$16),0)","v":1.8805970149253732},{"$f":"IFERROR((G$5:G$16=\"x\")*G$17*$D$5:$D$16/SUM((G$5:G$16=\"x\")*$D$5:$D$16),0)","v":0},{"$f":"IFERROR((H$5:H$16=\"x\")*H$17*$D$5:$D$16/SUM((H$5:H$16=\"x\")*$D$5:$D$16),0)","v":2.4615384615384617}]
[null,null,"February",0,0,0,0,0]
[null,null,"March",1.297621338081687,0.30120481927710846,0.31343283582089554,0.27272727272727271,0.41025641025641024]
[null,null,"April",7.785728028490122,1.8072289156626506,1.8805970149253732,1.6363636363636365,2.4615384615384617]
[null,null,"May",6.2115544947769363,2.1084337349397591,2.1940298507462686,1.9090909090909092,0]
[null,null,"June",11.535744061728597,3.9156626506024095,4.0746268656716422,3.5454545454545454,0]
[null,null,"July",12.423108989553873,4.2168674698795181,4.3880597014925371,3.8181818181818183,0]
[null,null,"August",8.8736492782527669,3.0120481927710845,3.1343283582089554,2.7272727272727271,0]
[null,null,"September",5.190485352326748,1.2048192771084338,1.2537313432835822,1.0909090909090908,1.641025641025641]
[null,null,"October",7.785728028490122,1.8072289156626506,1.8805970149253732,1.6363636363636365,2.4615384615384617]
[null,null,"November",6.8893195158255409,2.1084337349397591,0,1.9090909090909092,2.8717948717948718]
[null,null,"December",8.8576965203471225,2.7108433734939759,0,2.4545454545454546,3.6923076923076925]
[null,null,"Total",{"$f":"SUM(D21:D32)","v":83.000000000000014},25,21,21,16]
[]
[null,null,null,"Vacation days (integer)"]
[null,null,null,"Total",{"$f":"E4","v":"Andrew"},{"$f":"F4","v":"Benjamin"},{"$f":"G4","v":"Charlie"},{"$f":"H4","v":"David"}]
[null,null,{"$f":"A5:A16","v":"January"},{"$f":"SUM(E37:H37)","v":7},{"$f":"TRANSPOSE(IFERROR(RoundToSum(E21:E32,0),0))","v":2},{"$f":"TRANSPOSE(IFERROR(RoundToSum(F21:F32,0),0))","v":2},{"$f":"TRANSPOSE(IFERROR(RoundToSum(G21:G32,0),0))","v":0},{"$f":"TRANSPOSE(IFERROR(RoundToSum(H21:H32,0),0))","v":3}]
[null,null,"February",0,0,0,0,0]
[null,null,"March",0,0,0,0,0]
[null,null,"April",8,2,2,2,2]
[null,null,"May",6,2,2,2,0]
[null,null,"June",11,4,4,3,0]
[null,null,"July",13,4,5,4,0]
[null,null,"August",9,3,3,3,0]
[null,null,"September",5,1,1,1,2]
[null,null,"October",8,2,2,2,2]
[null,null,"November",7,2,0,2,3]
[null,null,"December",9,3,0,2,4]
[null,null,"Total",{"$f":"SUM(D37:D48)","v":83},25,21,21,16]

{"sheet":"Einfach","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,5,1,6]]}
[null,null,"Umsatzgrenze (kein Urlaub):",null,"Höhere Umsatzgrenze (kein Urlaub):","Überschrieben um auch Urlaub bei Umsatzmaximum\n<- zuzulassen"]
[null,null,{"$f":"MAX(B5:B16)","v":24000},null,28000]
[null,"Umsatz","Urlaub (streng)","Urlaub (streng)","Urlaub (moderat)","Urlaub (moderat)"]
["Total",{"$f":"SUM(B5:B16)","v":230000},83,null,83]
["Januar",20000,{"$f":"(C$2-$B5:$B16)/(C$2*12-$B$4)*C$4","v":5.7241379310344831},{"$f":"TRANSPOSE(RoundToSum(C5:C16,0))","v":6},{"$f":"(E$2-$B5:$B16)/(E$2*12-$B$4)*E$4","v":6.2641509433962259},{"$f":"TRANSPOSE(RoundToSum(E5:E16,0))","v":6}]
["Februar",24000,0,0,3.132075471698113,3]
["März",23000,1.4310344827586208,1,3.9150943396226419,4]
["April",20000,5.7241379310344831,6,6.2641509433962259,6]
["Mai",19000,7.1551724137931041,7,7.0471698113207539,7]
["Juni",15000,12.879310344827587,13,10.179245283018869,10]
["Juli",14000,14.310344827586208,14,10.962264150943396,11]
["August",17000,10.017241379310345,10,8.6132075471698109,9]
["September",21000,4.2931034482758621,4,5.4811320754716979,6]
["Oktober",20000,5.7241379310344831,6,6.2641509433962259,6]
["November",19000,7.1551724137931041,7,7.0471698113207539,7]
["Dezember",18000,8.5862068965517242,9,7.8301886792452837,8]
[null,"Prüfsumme",{"$f":"SUM(C5:C16)","v":83.000000000000014},{"$f":"SUM(D5:D16)","v":83},{"$f":"SUM(E5:E16)","v":83},{"$f":"SUM(F5:F16)","v":83}]

{"sheet":"Komplex","index":3,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,null,"Umsatzgrenze (kein Urlaub):"]
[null,null,{"$f":"MAX(B5:B16)","v":24000},"<- Höhere Werte erlauben auch Urlaub bei Maximalumsatz"]
[null,"Umsatz","Urlaub","Urlaub (ganze Tage)","Urlaubsanspruch"]
["Total",{"$f":"SUM(B5:B16)","v":230000},null,null,"Andrew","Benjamin","Charlie","David"]
["Januar",20000,{"$f":"($C$2-B5:B16)/($C$2*12-$B$4)*$C$17","v":5.7241379310344831},{"$f":"TRANSPOSE(RoundToSum(C5:C16,0))","v":6},"x","x",null,"x"]
["Februar",24000,0,0,"x","x",null,"x"]
["März",23000,1.4310344827586208,1,"x","x","x","x"]
["April",20000,5.7241379310344831,6,"x","x","x","x"]
["Mai",19000,7.1551724137931041,7,"x","x","x"]
["Juni",15000,12.879310344827587,13,"x","x","x"]
["Juli",14000,14.310344827586208,14,"x","x","x"]
["August",17000,10.017241379310345,10,"x","x","x"]
["September",21000,4.2931034482758621,4,"x","x","x","x"]
["Oktober",20000,5.7241379310344831,6,"x","x","x","x"]
["November",19000,7.1551724137931041,7,"x",null,"x","x"]
["Dezember",18000,8.5862068965517242,9,"x",null,"x","x"]
[null,"Total",{"$f":"SUM(E17:H17)","v":83},{"$f":"SUM(D5:D16)","v":83},25,21,21,16]
[]
[null,null,null,"Urlaub"]
[null,null,null,"Total",{"$f":"E4","v":"Andrew"},{"$f":"F4","v":"Benjamin"},{"$f":"G4","v":"Charlie"},{"$f":"H4","v":"David"}]
[null,null,{"$f":"A5:A16","v":"Januar"},{"$f":"SUM(E21:H21)","v":6.1493643921264853},{"$f":"IFERROR((E$5:E$16=\"x\")*E$17*$D$5:$D$16/SUM((E$5:E$16=\"x\")*$D$5:$D$16),0)","v":1.8072289156626506},{"$f":"IFERROR((F$5:F$16=\"x\")*F$17*$D$5:$D$16/SUM((F$5:F$16=\"x\")*$D$5:$D$16),0)","v":1.8805970149253732},{"$f":"IFERROR((G$5:G$16=\"x\")*G$17*$D$5:$D$16/SUM((G$5:G$16=\"x\")*$D$5:$D$16),0)","v":0},{"$f":"IFERROR((H$5:H$16=\"x\")*H$17*$D$5:$D$16/SUM((H$5:H$16=\"x\")*$D$5:$D$16),0)","v":2.4615384615384617}]
[null,null,"Februar",0,0,0,0,0]
[null,null,"März",1.297621338081687,0.30120481927710846,0.31343283582089554,0.27272727272727271,0.41025641025641024]
[null,null,"April",7.785728028490122,1.8072289156626506,1.8805970149253732,1.6363636363636365,2.4615384615384617]
[null,null,"Mai",6.2115544947769363,2.1084337349397591,2.1940298507462686,1.9090909090909092,0]
[null,null,"Juni",11.535744061728597,3.9156626506024095,4.0746268656716422,3.5454545454545454,0]
[null,null,"Juli",12.423108989553873,4.2168674698795181,4.3880597014925371,3.8181818181818183,0]
[null,null,"August",8.8736492782527669,3.0120481927710845,3.1343283582089554,2.7272727272727271,0]
[null,null,"September",5.190485352326748,1.2048192771084338,1.2537313432835822,1.0909090909090908,1.641025641025641]
[null,null,"Oktober",7.785728028490122,1.8072289156626506,1.8805970149253732,1.6363636363636365,2.4615384615384617]
[null,null,"November",6.8893195158255409,2.1084337349397591,0,1.9090909090909092,2.8717948717948718]
[null,null,"Dezember",8.8576965203471225,2.7108433734939759,0,2.4545454545454546,3.6923076923076925]
[null,null,"Total",{"$f":"SUM(D21:D32)","v":83.000000000000014},25,21,21,16]
[]
[null,null,null,"Urlaub (ganze Tage)"]
[null,null,null,"Total",{"$f":"E4","v":"Andrew"},{"$f":"F4","v":"Benjamin"},{"$f":"G4","v":"Charlie"},{"$f":"H4","v":"David"}]
[null,null,{"$f":"A5:A16","v":"Januar"},{"$f":"SUM(E37:H37)","v":7},{"$f":"TRANSPOSE(IFERROR(RoundToSum(E21:E32,0),0))","v":2},{"$f":"TRANSPOSE(IFERROR(RoundToSum(F21:F32,0),0))","v":2},{"$f":"TRANSPOSE(IFERROR(RoundToSum(G21:G32,0),0))","v":0},{"$f":"TRANSPOSE(IFERROR(RoundToSum(H21:H32,0),0))","v":3}]
[null,null,"Februar",0,0,0,0,0]
[null,null,"März",0,0,0,0,0]
[null,null,"April",8,2,2,2,2]
[null,null,"Mai",6,2,2,2,0]
[null,null,"Juni",11,4,4,3,0]
[null,null,"Juli",13,4,5,4,0]
[null,null,"August",9,3,3,3,0]
[null,null,"September",5,1,1,1,2]
[null,null,"Oktober",8,2,2,2,2]
[null,null,"November",7,2,0,2,3]
[null,null,"Dezember",9,3,0,2,4]
[null,null,"Total",{"$f":"SUM(D37:D48)","v":83},25,21,21,16]