{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Přehled","Kalkulace","Výpočty"],"not_rendered":{"charts":0,"images":1,"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":"Přehled","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"CONCATENATE(\"Kalkulace pro společnost: \",Kalkulace!C5)","v":"Kalkulace pro společnost: Projekce Projektant s.r.o."}]
[]
[null,null,null,"Stávající dodavatel",null,"Benefit Print s.r.o.",null,"Úspora"]
[]
[]
[]
[]
[null,"Černobílý tisk",null,{"$f":"Kalkulace!F31","v":1610},null,0,null,{"$f":"Kalkulace!F41","v":0.38005390835579511}]
[]
[]
[]
[null,"Barevný tisk",null,{"$f":"Kalkulace!C31","v":2100},null,{"$f":"Kalkulace!C38","v":2300},null,{"$f":"Kalkulace!F40","v":1410}]

{"sheet":"Kalkulace","index":1,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,2,4,6],[31,2,31,5],[37,2,37,5]]}
[]
[]
[]
[]
[null,"Společnost:","Projekce Projektant s.r.o."]
[]
[]
[null,"Údaje o Vašich současných cenách:"]
[]
[null,"Barevné tisky účtujete v:",1,null,"Černobílé tisky účtujete v:",1]
[]
[null,{"$f":"VLOOKUP(C10,Výpočty!A4:E6,5)","v":"Cena za barevný výtisk A4"},7,null,{"$f":"VLOOKUP(F10,Výpočty!A4:H7,6)","v":"Cena za černobílý výtisk A4"},2.2999999999999998]
[null,null,null,null,{"$f":"IF($F$10=4,Výpočty!F8,\"\")","v":""},0.61]
[null,null,null,null,{"$f":"IF($F$10=4,Výpočty!F9,\"\")","v":""},0.5]
[null,null,null,null,{"$f":"IF($F$10=4,Výpočty!F10,\"\")","v":""},0.4]
[null,null,null,null,{"$f":"IF($F$10=4,Výpočty!F11,\"\")","v":""},0.31]
[]
[]
[null,"Údaje o Vašem projektu:"]
[]
[null,"Počet paré:",10]
[null,"Počet barevných jednotek:",30,{"$f":"VLOOKUP(C10,Výpočty!A4:D6,4)","v":"A4"},"Počet černobílých jednotek:",70,{"$f":"VLOOKUP(F10,Výpočty!A4:I7,8)","v":"A4"}]
[null,null,null,null,null,200,{"$f":"IF($F$10=4,Výpočty!H8,\"\")","v":""}]
[null,null,null,null,null,300,{"$f":"IF($F$10=4,Výpočty!H9,\"\")","v":""}]
[null,null,null,null,null,400,{"$f":"IF($F$10=4,Výpočty!H10,\"\")","v":""}]
[null,null,null,null,null,500,{"$f":"IF($F$10=4,Výpočty!H11,\"\")","v":""}]
[]
[]
[null,"Cena u současného dodavatele:"]
[]
[null,"Barevné tisky",{"$f":"Výpočty!B20","v":2100},null,"Černobílé tisky:",{"$f":"Výpočty!E20","v":1610}]
[null,"Cena celkem:",{"$f":"F31+C31","v":3710}]
[]
[]
[null,"Cena u Benefit Print:"]
[]
[null,"Barevné tisky",{"$f":"VLOOKUP(C10,Výpočty!A24:F26,2+F10)*C22*C21","v":690},null,"Černobílé tisky:",{"$f":"F31","v":1610}]
[null,"Cena celkem:",{"$f":"F37+C37","v":2300}]
[]
[null,null,null,null,"Ušetříte celkem:",{"$f":"C32-C38","v":1410}]
[null,null,null,null,"to je:",{"$f":"1-(C38/C32)","v":0.38005390835579511}]
[null,null,null,null,null,"Všechny černobílé tisky přitom mohou být v barvě!!"]

{"sheet":"Výpočty","index":2,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Údaje o současných cenách:",null,null,null,null,null,null,null,null,null,null,null,"Koeficient",null,2.9]
[null,null,null,null,null,null,null,null,null,null,null,1,"A4 - > A4",1,null,null,null,null,1000,"A4",{"$f":"S3*Kalkulace!C12","v":7000}]
[1,"Cena za barevný výtisk",7,"A4",{"$f":"CONCATENATE($B$4,\" \",D4)","v":"Cena za barevný výtisk A4"},"Cena za černobílý výtisk A4",2.96875,"A4",2.96875,null,null,2,"A4 - > DM",0.16,null,null,null,{"$f":"N4*P2","v":0.46399999999999997},{"$f":"2.1*2.97*S3","v":6237.0000000000009},"dm"]
[2,null,11.2,"dm2",{"$f":"CONCATENATE($B$4,\" \",D5)","v":"Cena za barevný výtisk dm2"},"Cena za černobílý výtisk dm2",0.47499999999999998,"dm2",0.47499999999999998,null,null,3,"A4 - > M",16,null,null,null,{"$f":"P2*N5","v":46.4},{"$f":"S4/100","v":62.370000000000012},"m"]
[3,null,112,"m2","Cena za barevný výtisk m2","Cena za černobílý výtisk m2",47.5,"m2",47.5,null,null,4,"A4 -> CM"]
[4,null,null,null,null,"Cena za černobílý výtisk šířka 914",{"$f":"Kalkulace!F12","v":2.2999999999999998},"běžné cm 914",0.75,{"$f":"(100/0.914)*G7","v":251.64113785557984},null,5,"DM -> A4"]
[null,null,null,null,null,"Cena za černobílý výtisk šířka 841",{"$f":"Kalkulace!F13","v":0.61},"běžné cm 841",0.6055508830950378,{"$f":"(100/0.841)*G8","v":72.532699167657555},null,6,"M -> A4"]
[null,null,null,null,null,"Cena za černobílý výtisk šířka 594",{"$f":"Kalkulace!F14","v":0.5},"běžné cm 594",0.49940546967895366,{"$f":"(100/0.594)*G9","v":84.17508417508418},null,7,"CM -> A4"]
[null,null,null,null,null,"Cena za černobílý výtisk šířka 420",{"$f":"Kalkulace!F15","v":0.4},"běžné cm 420",0.40404040404040403,{"$f":"(100/0.42)*G10","v":95.238095238095241},null,8,"M -> DM"]
[null,null,null,null,null,"Cena za černobílý výtisk šířka 297",{"$f":"Kalkulace!F16","v":0.31},"běžné cm 297",0.30952380952380953,{"$f":"(100/0.297)*G11","v":104.37710437710439}]
[]
[null,"Barva:",null,null,"ČB:",null,"Formátů A4",null,null,null,null,null,null,null,"A4","DM","M","BCM"]
[null,null,null,914,{"$f":"Kalkulace!F12*Kalkulace!F22","v":161},{"$f":"Kalkulace!F12*Kalkulace!F22","v":161},{"$f":"(Kalkulace!F22*Kalkulace!$C$21*(D14/10))/623.7","v":102.58136924803591},null,null,null,null,null,null,"A4","x",6.2370000000000001,{"$f":"1/16","v":6.25E-2}]
[null,null,null,841,{"$f":"IF(Kalkulace!$F$10=4,F15,0)","v":0},{"$f":"Kalkulace!F13*Kalkulace!F23","v":122},{"$f":"(Kalkulace!F23*Kalkulace!$C$21*(D15/10))/623.7","v":269.68093634760299},null,null,null,null,null,null,"DM",{"$f":"1/P14","v":0.160333493666827},"x",0.01]
[null,null,null,594,{"$f":"IF(Kalkulace!$F$10=4,F16,0)","v":0},{"$f":"Kalkulace!F14*Kalkulace!F24","v":150},{"$f":"(Kalkulace!F24*Kalkulace!$C$21*(D16/10))/623.7","v":285.71428571428567},null,null,null,null,null,null,"M",16,100,"x"]
[null,null,null,420,{"$f":"IF(Kalkulace!$F$10=4,F17,0)","v":0},{"$f":"Kalkulace!F15*Kalkulace!F25","v":160},{"$f":"(Kalkulace!F25*Kalkulace!$C$21*(D17/10))/623.7","v":269.36026936026934},null,null,null,null,null,null,"CM",null,null,null,"x"]
[null,null,null,297,{"$f":"IF(Kalkulace!$F$10=4,F18,0)","v":0},{"$f":"Kalkulace!F16*Kalkulace!F26","v":155},{"$f":"(Kalkulace!F26*Kalkulace!$C$21*(D18/10))/623.7","v":238.09523809523807}]
[1,{"$f":"Kalkulace!C12*Kalkulace!C22","v":210},null,null,{"$f":"SUM(E14:E18)","v":161},null,{"$f":"SUM(G14:G18)","v":1165.4320987654319}]
[{"$f":"Kalkulace!C21","v":10},{"$f":"A20*B19","v":2100},null,null,{"$f":"A20*E19","v":1610},null,{"$f":"E20/G19","v":1.38146186440678}]
[]
[]
["Přepočtená cena:",null,"Z A4","Z DM2","Z M2","Z bcm"]
[1,"A4",{"$f":"Kalkulace!F12","v":2.2999999999999998},{"$f":"Kalkulace!F12*6.237","v":14.345099999999999},{"$f":"Kalkulace!F12/16","v":0.14374999999999999},{"$f":"G20","v":1.38146186440678}]
[2,"dm2",{"$f":"C24/6.237","v":0.36876703543370204},{"$f":"D24/6.237","v":2.2999999999999998},{"$f":"Kalkulace!F12/100","v":2.3E-2},{"$f":"G20/6.237","v":0.22149460708782748}]
[3,"m2",{"$f":"C24*16","v":36.799999999999997},{"$f":"D25*100","v":229.99999999999997},{"$f":"Kalkulace!F12","v":2.2999999999999998},{"$f":"G20*16","v":22.10338983050848}]