{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["List1","Seznam","Kontingent","Makro","List4","List5","List6","List7","List8","List9","List10","List11","List12","List13","List14","List15","List16"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":2},"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":"List1","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Součet z Tržba (Kč)","Měsíc"]
["Program",1,2,3,4,5,"Celkový součet"]
["BON",18080,4520,9040,13560,9040,54240]
["FIN",15908,15908,23862,23862,15908,95448]
["INV",7780,15560,11670,19450,3890,58350]
["POD",18720,9360,6240,12480,6240,53040]
["Celkový součet",60488,45348,50812,69352,35078,261078]
[]
[]
[]
[]
[]
[null,null,null,null," j kj kflh "]
[null,null,null,null,"lf' kl"]
[null,null,null,null," dfh "]

{"sheet":"Seznam","index":1,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["S E Z N A M    P R O D E J Ú"]
[]
["Datum","Program","Počet (Ks)","Typ","Měsíc","Cena (Kč)","Tržba (Kč)","Den",null,"Program","Zkratka","Cena",null,"Den","Název"]
["1998-05-11","FIN",1,"O",{"$f":"MONTH(A4)","v":5},{"$f":"VLOOKUP(B4,$K$4:$L$7,2)","v":7954},{"$f":"F4*C4","v":7954},{"$f":"VLOOKUP(WEEKDAY(A4,2),$N$4:$O$10,2)","v":"pondělí"},null,"Bonita","BON",4520,null,1,"pondělí"]
["1998-01-05","BON",1,"P",{"$f":"MONTH(A5)","v":1},{"$f":"VLOOKUP(B5,$K$4:$L$7,2)","v":4520},{"$f":"F5*C5","v":4520},{"$f":"VLOOKUP(WEEKDAY(A5,2),$N$4:$O$10,2)","v":"pondělí"},null,"Finanční analýza","FIN",7954,null,2,"úterý"]
["1998-01-12","BON",1,"J",{"$f":"MONTH(A6)","v":1},{"$f":"VLOOKUP(B6,$K$4:$L$7,2)","v":4520},{"$f":"F6*C6","v":4520},{"$f":"VLOOKUP(WEEKDAY(A6,2),$N$4:$O$10,2)","v":"pondělí"},null,"Investice","INV",3890,null,3,"středa"]
["1998-04-20","INV",1,"P",{"$f":"MONTH(A7)","v":4},{"$f":"VLOOKUP(B7,$K$4:$L$7,2)","v":3890},{"$f":"F7*C7","v":3890},{"$f":"VLOOKUP(WEEKDAY(A7,2),$N$4:$O$10,2)","v":"pondělí"},null,"Podnikatel","POD",3120,null,4,"čtvrtek"]
["1998-01-26","POD",1,"O",{"$f":"MONTH(A8)","v":1},{"$f":"VLOOKUP(B8,$K$4:$L$7,2)","v":3120},{"$f":"F8*C8","v":3120},{"$f":"VLOOKUP(WEEKDAY(A8,2),$N$4:$O$10,2)","v":"pondělí"},null,null,null,null,null,5,"pátek"]
["1998-02-09","POD",1,"P",{"$f":"MONTH(A9)","v":2},{"$f":"VLOOKUP(B9,$K$4:$L$7,2)","v":3120},{"$f":"F9*C9","v":3120},{"$f":"VLOOKUP(WEEKDAY(A9,2),$N$4:$O$10,2)","v":"pondělí"},null,null,null,null,null,6,"sobota"]
["1998-02-16","POD",1,"B",{"$f":"MONTH(A10)","v":2},{"$f":"VLOOKUP(B10,$K$4:$L$7,2)","v":3120},{"$f":"F10*C10","v":3120},{"$f":"VLOOKUP(WEEKDAY(A10,2),$N$4:$O$10,2)","v":"pondělí"},null,null,null,null,null,7,"neděle"]
["1998-03-09","POD",1,"P",{"$f":"MONTH(A11)","v":3},{"$f":"VLOOKUP(B11,$K$4:$L$7,2)","v":3120},{"$f":"F11*C11","v":3120},{"$f":"VLOOKUP(WEEKDAY(A11,2),$N$4:$O$10,2)","v":"pondělí"}]
["1998-03-16","POD",1,"P",{"$f":"MONTH(A12)","v":3},{"$f":"VLOOKUP(B12,$K$4:$L$7,2)","v":3120},{"$f":"F12*C12","v":3120},{"$f":"VLOOKUP(WEEKDAY(A12,2),$N$4:$O$10,2)","v":"pondělí"},null,"Typ zákazníka"]
["1998-04-20","POD",1,"B",{"$f":"MONTH(A13)","v":4},{"$f":"VLOOKUP(B13,$K$4:$L$7,2)","v":3120},{"$f":"F13*C13","v":3120},{"$f":"VLOOKUP(WEEKDAY(A13,2),$N$4:$O$10,2)","v":"pondělí"},null,"Banka","B"]
["1998-05-04","POD",1,"J",{"$f":"MONTH(A14)","v":5},{"$f":"VLOOKUP(B14,$K$4:$L$7,2)","v":3120},{"$f":"F14*C14","v":3120},{"$f":"VLOOKUP(WEEKDAY(A14,2),$N$4:$O$10,2)","v":"pondělí"},null,"Jednotlivci (poradci, odhadci,..)","J"]
["1998-04-21","FIN",2,"B",{"$f":"MONTH(A15)","v":4},{"$f":"VLOOKUP(B15,$K$4:$L$7,2)","v":7954},{"$f":"F15*C15","v":15908},{"$f":"VLOOKUP(WEEKDAY(A15,2),$N$4:$O$10,2)","v":"úterý"},null,"Výrobní podnik","P"]
["1998-01-20","FIN",1,"B",{"$f":"MONTH(A16)","v":1},{"$f":"VLOOKUP(B16,$K$4:$L$7,2)","v":7954},{"$f":"F16*C16","v":7954},{"$f":"VLOOKUP(WEEKDAY(A16,2),$N$4:$O$10,2)","v":"úterý"},null,"Ostatní","O"]
["1998-03-24","FIN",1,"J",{"$f":"MONTH(A17)","v":3},{"$f":"VLOOKUP(B17,$K$4:$L$7,2)","v":7954},{"$f":"F17*C17","v":7954},{"$f":"VLOOKUP(WEEKDAY(A17,2),$N$4:$O$10,2)","v":"úterý"}]
["1998-05-05","FIN",1,"B",{"$f":"MONTH(A18)","v":5},{"$f":"VLOOKUP(B18,$K$4:$L$7,2)","v":7954},{"$f":"F18*C18","v":7954},{"$f":"VLOOKUP(WEEKDAY(A18,2),$N$4:$O$10,2)","v":"úterý"}]
["1998-02-10","BON",1,"B",{"$f":"MONTH(A19)","v":2},{"$f":"VLOOKUP(B19,$K$4:$L$7,2)","v":4520},{"$f":"F19*C19","v":4520},{"$f":"VLOOKUP(WEEKDAY(A19,2),$N$4:$O$10,2)","v":"úterý"},null,"Typ","Měsíc","Cena (Kč)","Typ"]
["1998-03-03","BON",1,"J",{"$f":"MONTH(A20)","v":3},{"$f":"VLOOKUP(B20,$K$4:$L$7,2)","v":4520},{"$f":"F20*C20","v":4520},{"$f":"VLOOKUP(WEEKDAY(A20,2),$N$4:$O$10,2)","v":"úterý"},null,"b"]
["1998-05-12","BON",1,"P",{"$f":"MONTH(A21)","v":5},{"$f":"VLOOKUP(B21,$K$4:$L$7,2)","v":4520},{"$f":"F21*C21","v":4520},{"$f":"VLOOKUP(WEEKDAY(A21,2),$N$4:$O$10,2)","v":"úterý"},null,null,">3",3120,"o"]
["1998-02-03","INV",1,"P",{"$f":"MONTH(A22)","v":2},{"$f":"VLOOKUP(B22,$K$4:$L$7,2)","v":3890},{"$f":"F22*C22","v":3890},{"$f":"VLOOKUP(WEEKDAY(A22,2),$N$4:$O$10,2)","v":"úterý"}]
["1998-05-05","INV",1,"P",{"$f":"MONTH(A23)","v":5},{"$f":"VLOOKUP(B23,$K$4:$L$7,2)","v":3890},{"$f":"F23*C23","v":3890},{"$f":"VLOOKUP(WEEKDAY(A23,2),$N$4:$O$10,2)","v":"úterý"}]
["1998-01-20","POD",1,"P",{"$f":"MONTH(A24)","v":1},{"$f":"VLOOKUP(B24,$K$4:$L$7,2)","v":3120},{"$f":"F24*C24","v":3120},{"$f":"VLOOKUP(WEEKDAY(A24,2),$N$4:$O$10,2)","v":"úterý"}]
["1998-05-19","POD",1,"P",{"$f":"MONTH(A25)","v":5},{"$f":"VLOOKUP(B25,$K$4:$L$7,2)","v":3120},{"$f":"F25*C25","v":3120},{"$f":"VLOOKUP(WEEKDAY(A25,2),$N$4:$O$10,2)","v":"úterý"}]
["1998-03-11","FIN",2,"B",{"$f":"MONTH(A26)","v":3},{"$f":"VLOOKUP(B26,$K$4:$L$7,2)","v":7954},{"$f":"F26*C26","v":15908},{"$f":"VLOOKUP(WEEKDAY(A26,2),$N$4:$O$10,2)","v":"středa"}]
["1998-04-01","POD",2,"P",{"$f":"MONTH(A27)","v":4},{"$f":"VLOOKUP(B27,$K$4:$L$7,2)","v":3120},{"$f":"F27*C27","v":6240},{"$f":"VLOOKUP(WEEKDAY(A27,2),$N$4:$O$10,2)","v":"středa"}]
["1998-03-25","BON",1,"O",{"$f":"MONTH(A28)","v":3},{"$f":"VLOOKUP(B28,$K$4:$L$7,2)","v":4520},{"$f":"F28*C28","v":4520},{"$f":"VLOOKUP(WEEKDAY(A28,2),$N$4:$O$10,2)","v":"středa"}]
["1998-04-15","BON",1,"P",{"$f":"MONTH(A29)","v":4},{"$f":"VLOOKUP(B29,$K$4:$L$7,2)","v":4520},{"$f":"F29*C29","v":4520},{"$f":"VLOOKUP(WEEKDAY(A29,2),$N$4:$O$10,2)","v":"středa"}]
["1998-04-15","INV",1,"O",{"$f":"MONTH(A30)","v":4},{"$f":"VLOOKUP(B30,$K$4:$L$7,2)","v":3890},{"$f":"F30*C30","v":3890},{"$f":"VLOOKUP(WEEKDAY(A30,2),$N$4:$O$10,2)","v":"středa"}]
["1998-01-07","POD",1,"P",{"$f":"MONTH(A31)","v":1},{"$f":"VLOOKUP(B31,$K$4:$L$7,2)","v":3120},{"$f":"F31*C31","v":3120},{"$f":"VLOOKUP(WEEKDAY(A31,2),$N$4:$O$10,2)","v":"středa"}]
["1998-02-25","POD",1,"P",{"$f":"MONTH(A32)","v":2},{"$f":"VLOOKUP(B32,$K$4:$L$7,2)","v":3120},{"$f":"F32*C32","v":3120},{"$f":"VLOOKUP(WEEKDAY(A32,2),$N$4:$O$10,2)","v":"středa"}]
["1998-02-05","FIN",1,"P",{"$f":"MONTH(A33)","v":2},{"$f":"VLOOKUP(B33,$K$4:$L$7,2)","v":7954},{"$f":"F33*C33","v":7954},{"$f":"VLOOKUP(WEEKDAY(A33,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-01-08","POD",2,"B",{"$f":"MONTH(A34)","v":1},{"$f":"VLOOKUP(B34,$K$4:$L$7,2)","v":3120},{"$f":"F34*C34","v":6240},{"$f":"VLOOKUP(WEEKDAY(A34,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-04-02","BON",1,"P",{"$f":"MONTH(A35)","v":4},{"$f":"VLOOKUP(B35,$K$4:$L$7,2)","v":4520},{"$f":"F35*C35","v":4520},{"$f":"VLOOKUP(WEEKDAY(A35,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-04-30","BON",1,"O",{"$f":"MONTH(A36)","v":4},{"$f":"VLOOKUP(B36,$K$4:$L$7,2)","v":4520},{"$f":"F36*C36","v":4520},{"$f":"VLOOKUP(WEEKDAY(A36,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-01-15","INV",1,"P",{"$f":"MONTH(A37)","v":1},{"$f":"VLOOKUP(B37,$K$4:$L$7,2)","v":3890},{"$f":"F37*C37","v":3890},{"$f":"VLOOKUP(WEEKDAY(A37,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-03-05","INV",1,"B",{"$f":"MONTH(A38)","v":3},{"$f":"VLOOKUP(B38,$K$4:$L$7,2)","v":3890},{"$f":"F38*C38","v":3890},{"$f":"VLOOKUP(WEEKDAY(A38,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-03-19","INV",1,"B",{"$f":"MONTH(A39)","v":3},{"$f":"VLOOKUP(B39,$K$4:$L$7,2)","v":3890},{"$f":"F39*C39","v":3890},{"$f":"VLOOKUP(WEEKDAY(A39,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-04-02","INV",1,"P",{"$f":"MONTH(A40)","v":4},{"$f":"VLOOKUP(B40,$K$4:$L$7,2)","v":3890},{"$f":"F40*C40","v":3890},{"$f":"VLOOKUP(WEEKDAY(A40,2),$N$4:$O$10,2)","v":"čtvrtek"}]
["1998-01-23","BON",2,"O",{"$f":"MONTH(A41)","v":1},{"$f":"VLOOKUP(B41,$K$4:$L$7,2)","v":4520},{"$f":"F41*C41","v":9040},{"$f":"VLOOKUP(WEEKDAY(A41,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-01-02","FIN",1,"B",{"$f":"MONTH(A42)","v":1},{"$f":"VLOOKUP(B42,$K$4:$L$7,2)","v":7954},{"$f":"F42*C42","v":7954},{"$f":"VLOOKUP(WEEKDAY(A42,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-02-20","FIN",1,"J",{"$f":"MONTH(A43)","v":2},{"$f":"VLOOKUP(B43,$K$4:$L$7,2)","v":7954},{"$f":"F43*C43","v":7954},{"$f":"VLOOKUP(WEEKDAY(A43,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-04-10","FIN",1,"B",{"$f":"MONTH(A44)","v":4},{"$f":"VLOOKUP(B44,$K$4:$L$7,2)","v":7954},{"$f":"F44*C44","v":7954},{"$f":"VLOOKUP(WEEKDAY(A44,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-02-13","INV",2,"P",{"$f":"MONTH(A45)","v":2},{"$f":"VLOOKUP(B45,$K$4:$L$7,2)","v":3890},{"$f":"F45*C45","v":7780},{"$f":"VLOOKUP(WEEKDAY(A45,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-02-27","INV",1,"O",{"$f":"MONTH(A46)","v":2},{"$f":"VLOOKUP(B46,$K$4:$L$7,2)","v":3890},{"$f":"F46*C46","v":3890},{"$f":"VLOOKUP(WEEKDAY(A46,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-03-27","INV",1,"B",{"$f":"MONTH(A47)","v":3},{"$f":"VLOOKUP(B47,$K$4:$L$7,2)","v":3890},{"$f":"F47*C47","v":3890},{"$f":"VLOOKUP(WEEKDAY(A47,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-04-03","INV",1,"P",{"$f":"MONTH(A48)","v":4},{"$f":"VLOOKUP(B48,$K$4:$L$7,2)","v":3890},{"$f":"F48*C48","v":3890},{"$f":"VLOOKUP(WEEKDAY(A48,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-01-02","POD",1,"P",{"$f":"MONTH(A49)","v":1},{"$f":"VLOOKUP(B49,$K$4:$L$7,2)","v":3120},{"$f":"F49*C49","v":3120},{"$f":"VLOOKUP(WEEKDAY(A49,2),$N$4:$O$10,2)","v":"pátek"}]
["1998-05-09","BON",1,"P",{"$f":"MONTH(A50)","v":5},{"$f":"VLOOKUP(B50,$K$4:$L$7,2)","v":4520},{"$f":"F50*C50","v":4520},{"$f":"VLOOKUP(WEEKDAY(A50,2),$N$4:$O$10,2)","v":"sobota"}]
["1998-01-10","INV",1,"P",{"$f":"MONTH(A51)","v":1},{"$f":"VLOOKUP(B51,$K$4:$L$7,2)","v":3890},{"$f":"F51*C51","v":3890},{"$f":"VLOOKUP(WEEKDAY(A51,2),$N$4:$O$10,2)","v":"sobota"}]
["1998-04-18","INV",1,"P",{"$f":"MONTH(A52)","v":4},{"$f":"VLOOKUP(B52,$K$4:$L$7,2)","v":3890},{"$f":"F52*C52","v":3890},{"$f":"VLOOKUP(WEEKDAY(A52,2),$N$4:$O$10,2)","v":"sobota"}]
["1998-04-11","POD",1,"J",{"$f":"MONTH(A53)","v":4},{"$f":"VLOOKUP(B53,$K$4:$L$7,2)","v":3120},{"$f":"F53*C53","v":3120},{"$f":"VLOOKUP(WEEKDAY(A53,2),$N$4:$O$10,2)","v":"sobota"}]

{"sheet":"Kontingent","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["součet z Tržba (Kč)","Měsíc"]
["Program","1","2","3","4","5","celkový součet"]
["BON",18080,4520,9040,13560,9040,54240]
["FIN",15908,15908,23862,23862,15908,95448]
["INV",7780,15560,11670,19450,3890,58350]
["POD",18720,9360,6240,12480,6240,53040]
["celkový součet",60488,45348,50812,69352,35078,261078]

{"sheet":"Makro","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Převod formátu",null,null,null,null,null,null,{"$f":"H2","v":0}]
[null,"Kč","Dolar"]
[null,100,{"$f":"B4","v":100},null,null,null,null,null,null,{"$f":"I4","v":0}]
[null,200,200,null,null,null,null,null,null,0]
[null,300,300,null,null,null,null,null,null,0]
[null,400,400,null,null,null,null,null,null,0]
[null,500,500]
[null,600,600]
[null,700,700]
[null,800,800]
[null,900,900]
[null,1000,1000]
[null,1100,1100]
[null,1200,1200]
[null,1300,1300]
[null,1400,1400]
[null,1500,1500]

{"sheet":"List4","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List5","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List6","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List7","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List8","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List9","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List10","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List11","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List12","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List13","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List14","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List15","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"List16","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}