{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Přehled","Kalkulace","Výpočty"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Přehled","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[]
[null,null,{"$f":"CONCATENATE(\"Kalkulace pro společnost: \",Kalkulace!C5)","v":"Kalkulace pro společnost: Projekce Projektant s.r.o."}]
[]
[{"$nulls":3},"Stávající dodavatel",null,"Benefit Print s.r.o.",null,"Úspora"]
[]
[]
[]
[]
[null,"Černobílý tisk",null,{"$f":"Kalkulace!F31","v":{"v":1875,"d":"1,875.00 Kč"}},null,0,null,{"$f":"Kalkulace!F41","v":{"v":0.31034482758620685,"d":"31.03%"}}]
[]
[]
[]
[null,"Barevný tisk",null,{"$f":"Kalkulace!C31","v":{"v":1750,"d":"1,750.00 Kč"}},null,{"$f":"Kalkulace!C38","v":{"v":2500,"d":"2,500.00 Kč"}},null,{"$f":"Kalkulace!F40","v":{"v":1125,"d":"1,125.00 Kč"}}]

{"sheet":"Kalkulace","index":1,"n_rows":42,"n_cols":7,"rows_kept":42,"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"},{"v":7,"d":"7.00 Kč"},null,{"$f":"VLOOKUP(F10,Výpočty!A4:H7,6)","v":"Cena za černobílý výtisk A4"},{"v":2.5,"d":"2.50 Kč"}]
[{"$nulls":4},{"$f":"IF($F$10=4,Výpočty!F8,\"\")","v":""},{"v":0.61,"d":"0.61 Kč"}]
[{"$nulls":4},{"$f":"IF($F$10=4,Výpočty!F9,\"\")","v":""},{"v":0.5,"d":"0.50 Kč"}]
[{"$nulls":4},{"$f":"IF($F$10=4,Výpočty!F10,\"\")","v":""},{"v":0.4,"d":"0.40 Kč"}]
[{"$nulls":4},{"$f":"IF($F$10=4,Výpočty!F11,\"\")","v":""},{"v":0.31,"d":"0.31 Kč"}]
[]
[]
[null,"Údaje o Vašem projektu:"]
[]
[null,"Počet paré:",10]
[null,"Počet barevných jednotek:",25,{"$f":"VLOOKUP(C10,Výpočty!A4:D6,4)","v":"A4"},"Počet černobílých jednotek:",{"$f":"100-C22","v":75},{"$f":"VLOOKUP(F10,Výpočty!A4:I7,8)","v":"A4"}]
[{"$nulls":5},200,{"$f":"IF($F$10=4,Výpočty!H8,\"\")","v":""}]
[{"$nulls":5},300,{"$f":"IF($F$10=4,Výpočty!H9,\"\")","v":""}]
[{"$nulls":5},400,{"$f":"IF($F$10=4,Výpočty!H10,\"\")","v":""}]
[{"$nulls":5},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":{"v":1750,"d":"1,750.00 Kč"}},null,"Černobílé tisky:",{"$f":"Výpočty!E20","v":{"v":1875,"d":"1,875.00 Kč"}}]
[null,"Cena celkem:",{"$f":"F31+C31","v":{"v":3625,"d":"3,625.00 Kč"}}]
[]
[]
[null,"Cena u Benefit Print:"]
[]
[null,"Barevné tisky",{"$f":"VLOOKUP(C10,Výpočty!A24:F26,2+F10)*C22*C21","v":{"v":625,"d":"625.00 Kč"}},null,"Černobílé tisky:",{"$f":"F31","v":{"v":1875,"d":"1,875.00 Kč"}}]
[null,"Cena celkem:",{"$f":"F37+C37","v":{"v":2500,"d":"2,500.00 Kč"}}]
[]
[{"$nulls":4},"Ušetříte celkem:",{"$f":"C32-C38","v":{"v":1125,"d":"1,125.00 Kč"}}]
[{"$nulls":4},"to je:",{"$f":"1-(C38/C32)","v":{"v":0.31034482758620685,"d":"31.03%"}}]
[{"$nulls":5},"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}
[]
[null,"Údaje o současných cenách:",{"$nulls":11},"Koeficient",null,2.9]
[{"$nulls":11},1,"A4 - > A4",1,{"$nulls":4},1000,"A4",{"$f":"S3*Kalkulace!C12","v":7000}]
[1,"Cena za barevný výtisk",{"v":7,"d":"7.00 Kč"},"A4",{"$f":"CONCATENATE($B$4,\" \",D4)","v":"Cena za barevný výtisk A4"},"Cena za černobílý výtisk A4",{"v":2.96875,"d":"2.97 Kč"},"A4",{"v":2.96875,"d":"2.97 Kč"},null,null,2,"A4 - > DM",0.16,{"$nulls":3},{"$f":"N4*P2","v":0.46399999999999997},{"$f":"2.1*2.97*S3","v":6237.000000000001},"dm"]
[2,null,{"v":11.2,"d":"11.20 Kč"},"dm2",{"$f":"CONCATENATE($B$4,\" \",D5)","v":"Cena za barevný výtisk dm2"},"Cena za černobílý výtisk dm2",{"v":0.475,"d":"0.48 Kč"},"dm2",{"v":0.475,"d":"0.48 Kč"},null,null,3,"A4 - > M",16,{"$nulls":3},{"$f":"P2*N5","v":46.4},{"$f":"S4/100","v":62.37000000000001},"m"]
[3,null,{"v":112,"d":"112.00 Kč"},"m2","Cena za barevný výtisk m2","Cena za černobílý výtisk m2",{"v":47.5,"d":"47.50 Kč"},"m2",{"v":47.5,"d":"47.50 Kč"},null,null,4,"A4 -> CM"]
[4,{"$nulls":4},"Cena za černobílý výtisk šířka 914",{"$f":"Kalkulace!F12","v":{"v":2.5,"d":"2.50 Kč"}},"běžné cm 914",{"v":0.75,"d":"0.75 Kč"},{"$f":"(100/0.914)*G7","v":{"v":273.5229759299781,"d":"273.52 Kč"}},null,5,"DM -> A4"]
[{"$nulls":5},"Cena za černobílý výtisk šířka 841",{"$f":"Kalkulace!F13","v":{"v":0.61,"d":"0.61 Kč"}},"běžné cm 841",{"v":0.6055508830950378,"d":"0.61 Kč"},{"$f":"(100/0.841)*G8","v":{"v":72.53269916765755,"d":"72.53 Kč"}},null,6,"M -> A4"]
[{"$nulls":5},"Cena za černobílý výtisk šířka 594",{"$f":"Kalkulace!F14","v":{"v":0.5,"d":"0.50 Kč"}},"běžné cm 594",{"v":0.49940546967895366,"d":"0.50 Kč"},{"$f":"(100/0.594)*G9","v":{"v":84.17508417508418,"d":"84.18 Kč"}},null,7,"CM -> A4"]
[{"$nulls":5},"Cena za černobílý výtisk šířka 420",{"$f":"Kalkulace!F15","v":{"v":0.4,"d":"0.40 Kč"}},"běžné cm 420",{"v":0.40404040404040403,"d":"0.40 Kč"},{"$f":"(100/0.42)*G10","v":{"v":95.23809523809524,"d":"95.24 Kč"}},null,8,"M -> DM"]
[{"$nulls":5},"Cena za černobílý výtisk šířka 297",{"$f":"Kalkulace!F16","v":{"v":0.31,"d":"0.31 Kč"}},"běžné cm 297",{"v":0.30952380952380953,"d":"0.31 Kč"},{"$f":"(100/0.297)*G11","v":{"v":104.37710437710439,"d":"104.38 Kč"}}]
[]
[null,"Barva:",null,null,"ČB:",null,"Formátů A4",{"$nulls":7},"A4","DM","M","BCM"]
[{"$nulls":3},914,{"$f":"Kalkulace!F12*Kalkulace!F22","v":187.5},{"$f":"Kalkulace!F12*Kalkulace!F22","v":{"v":187.5,"d":"187.50 Kč"}},{"$f":"(Kalkulace!F22*Kalkulace!$C$21*(D14/10))/623.7","v":{"v":109.9086099086099,"d":"109.91"}},{"$nulls":6},"A4","x",6.237,{"$f":"1/16","v":0.0625}]
[{"$nulls":3},841,{"$f":"IF(Kalkulace!$F$10=4,F15,0)","v":0},{"$f":"Kalkulace!F13*Kalkulace!F23","v":{"v":122,"d":"122.00 Kč"}},{"$f":"(Kalkulace!F23*Kalkulace!$C$21*(D15/10))/623.7","v":{"v":269.680936347603,"d":"269.68"}},{"$nulls":6},"DM",{"$f":"1/P14","v":0.160333493666827},"x",0.01]
[{"$nulls":3},594,{"$f":"IF(Kalkulace!$F$10=4,F16,0)","v":0},{"$f":"Kalkulace!F14*Kalkulace!F24","v":{"v":150,"d":"150.00 Kč"}},{"$f":"(Kalkulace!F24*Kalkulace!$C$21*(D16/10))/623.7","v":{"v":285.71428571428567,"d":"285.71"}},{"$nulls":6},"M",16,100,"x"]
[{"$nulls":3},420,{"$f":"IF(Kalkulace!$F$10=4,F17,0)","v":0},{"$f":"Kalkulace!F15*Kalkulace!F25","v":{"v":160,"d":"160.00 Kč"}},{"$f":"(Kalkulace!F25*Kalkulace!$C$21*(D17/10))/623.7","v":{"v":269.36026936026934,"d":"269.36"}},{"$nulls":6},"CM",{"$nulls":3},"x"]
[{"$nulls":3},297,{"$f":"IF(Kalkulace!$F$10=4,F18,0)","v":0},{"$f":"Kalkulace!F16*Kalkulace!F26","v":{"v":155,"d":"155.00 Kč"}},{"$f":"(Kalkulace!F26*Kalkulace!$C$21*(D18/10))/623.7","v":{"v":238.09523809523807,"d":"238.10"}}]
[1,{"$f":"Kalkulace!C12*Kalkulace!C22","v":{"v":175,"d":"175.00 Kč"}},null,null,{"$f":"SUM(E14:E18)","v":{"v":187.5,"d":"187.50 Kč"}},null,{"$f":"SUM(G14:G18)","v":{"v":1172.759339426006,"d":"1172.76"}}]
[{"$f":"Kalkulace!C21","v":10},{"$f":"A20*B19","v":{"v":1750,"d":"1,750.00 Kč"}},null,null,{"$f":"A20*E19","v":{"v":1875,"d":"1,875.00 Kč"}},null,{"$f":"E20/G19","v":{"v":1.5987934923781533,"d":"1.60 Kč"}}]
[]
[]
["Přepočtená cena:",null,"Z A4","Z DM2","Z M2","Z bcm"]
[1,"A4",{"$f":"Kalkulace!F12","v":{"v":2.5,"d":"2.50 Kč"}},{"$f":"Kalkulace!F12*6.237","v":{"v":15.592500000000001,"d":"15.59 Kč"}},{"$f":"Kalkulace!F12/16","v":{"v":0.15625,"d":"0.16 Kč"}},{"$f":"G20","v":{"v":1.5987934923781533,"d":"1.60 Kč"}}]
[2,"dm2",{"$f":"C24/6.237","v":{"v":0.40083373416706747,"d":"0.40 Kč"}},{"$f":"D24/6.237","v":{"v":2.5,"d":"2.50 Kč"}},{"$f":"Kalkulace!F12/100","v":{"v":0.025,"d":"0.03 Kč"}},{"$f":"G20/6.237","v":{"v":0.25634014628477686,"d":"0.26 Kč"}}]
[3,"m2",{"$f":"C24*16","v":{"v":40,"d":"40.00 Kč"}},{"$f":"D25*100","v":{"v":250,"d":"250.00 Kč"}},{"$f":"Kalkulace!F12","v":{"v":2.5,"d":"2.50 Kč"}},{"$f":"G20*16","v":{"v":25.580695878050452,"d":"25.58 Kč"}}]