{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sledování oprav automobilů"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Sledování oprav automobilů","index":0,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"SLEDOVÁNÍ OPRAV AUTOMOBILŮ"]
[null,"CELKOVÝ SOUČET",{"$f":"IFERROR(SUM(Opravy[ČÁSTKA]), \"\")","v":{"v":95030.20000000001,"d":"95,030.20 Kč"}}]
[null,"VOZIDLO 1 CELKEM",{"$f":"IFERROR(SUMIFS(Opravy[ČÁSTKA],Opravy[VOZIDLO],Název_vozidla_1), \"\")","v":{"v":80642.2,"d":"80,642.20 Kč"}},{"$f":"Název_vozidla_1& \" – HODNOTA\"","v":"VOZIDLO 1 – HODNOTA"},{"v":280000,"d":"280,000.00 Kč"},{"$f":"Název_vozidla_1","v":"VOZIDLO 1"}]
[null,"VOZIDLO 2 CELKEM",{"$f":"IFERROR(SUMIFS(Opravy[ČÁSTKA],Opravy[VOZIDLO],Název_vozidla_2), \"\")","v":{"v":14388,"d":"14,388.00 Kč"}},{"$f":"Název_vozidla_2& \" – HODNOTA\"","v":"VOZIDLO 2 – HODNOTA"},{"v":140000,"d":"140,000.00 Kč"},{"$f":"Název_vozidla_2","v":"VOZIDLO 2"}]
[null,"DATUM","ČÁSTKA","VOZIDLO","KDE","POPIS"]
[null,{"$f":"TODAY()-800","v":"2016-04-20"},{"v":12642.2,"d":"12,642.20 Kč"},"VOZIDLO 1","Dealer","Výměna chladiče"]
[null,{"$f":"TODAY()-270","v":"2017-10-02"},{"v":7797.4,"d":"7,797.40 Kč"},"VOZIDLO 2","Pneuservis","4 nové pneumatiky"]
[null,{"$f":"TODAY()-400","v":"2017-05-25"},{"v":68000,"d":"68,000.00 Kč"},"VOZIDLO 1","Opravna karosérií","Oprava po kolizi"]
[null,{"$f":"TODAY()-90","v":"2018-03-31"},{"v":1799.8,"d":"1,799.80 Kč"},"VOZIDLO 2","Pneuservis","Vyvážení pneumatik"]
[null,{"$f":"TODAY()","v":"2018-06-29"},{"v":4790.8,"d":"4,790.80 Kč"},"VOZIDLO 2","Dealer","Servisní prohlídka po 100 000 km"]