{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Tiitel","Sisukord","Ülesande_püstitus","Anal_1","Anal_2","Det_tüübid","Tellimused","Lisamine","Päringud_1","Päringud_2","Koond","Materjalid","Värvid","Tellijad","Det_makro_2"],"not_rendered":{"charts":0,"images":29,"macros":1,"external_links":1,"defined_names":47,"comments":6,"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":"Tiitel","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sisukord","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Ülesande püstitus"]
[null,"Detaili skeem ja mõõdud, andmed ja valemid "]
[null,"Andmemudel"]
[null,"Detailide tüübid"]
[null,"Detailide tellimused"]
[null,"Tellimuste lisamine"]
[null,"Päringud 1"]
[null,"Päringud 2"]
[null,"Koond materjalide lõikes"]
[null,"Materjalid"]
[null,"Värvid"]
[null,"Tellijad"]
[null,"Detaili karakteristikud"]

{"sheet":"Ülesande_püstitus","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Anal_1","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rakendus \"Detail\". Analüüs. Geomeetria"]

{"sheet":"Anal_2","index":4,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"tabel"]
[]
[]
[]
[]
[]
[]
[null,null,"tabel"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"tabel"]
[]
[]
[]
[]
[null,null,null,null,"tabel"]
[null,null,null,null,null,null,"tabel"]

{"sheet":"Det_tüübid","index":5,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Andmemudel"]
[null,"Detailide tüübid"]
[]
[null,"Kood","L cm","h cm","b cm","d cm","Ruumala, m3","Pindala, m2"]
[null,"D060600",600,80,40,13,1.88,15.47]
[null,"D060601",600,60,40,20,1.35,13.13]
[null,"D060802",600,80,50,30,2.19,17.36]
[null,"D090800",900,80,40,0,2.88,22.24]
[null,"D090801",900,80,50,30,3.28,25.67]
[null,"D090802",900,100,60,50,4.5199999999999996,32.369999999999997]
[null,"D121000",1200,100,60,0,7.2,39.6]
[null,"D121901",1200,100,60,30,6.78,41.58]
[null,"D121202",1200,120,80,40,10.77,52.53]
[null,"D181200",1800,120,60,0,12.96,66.239999999999995]
[null,"D181201",1800,120,60,40,11.83,70.22]
[null,"D181501",1800,150,75,50,18.48,88.19]
[null,"D121311",840,72,36,18,2.0699999999999998,19.5]
[null,"D131313",1300,100,80,0,10.4,48.4]

{"sheet":"Tellimused","index":6,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Andmemudel"]
[null,"Detailide tellimused",null,"märts",2008,null,null,null,null,null,"Muud kulud",0.5]
[]
[null,null,null,null,null,"Kokku",59,328.17,160126.39999999999,459.1825,21926.105599999999,273078.75840000005]
[]
[null,"Kuupäev","Tellija","Detail","Materjal","Värv","Arv","Materjali\nkogus","Materjali\nmaksumus","Värvi\nkogus","Värvi\nmaksumus","Partii\nmaksumus"]
[null,"2008-03-13","Juku & sõbrad","D060601","Ma_03","Sv06",7,9.4499999999999993,3024,32.168500000000002,897.50115000000005,5882.2517250000001]
[null,"2008-03-13","Karu & pojad","D090801","Ma_09","Sv09",7,22.96,10102.4,62.891500000000008,3075.3943500000005,19766.691525000002]
[null,"2008-03-13","Juku & sõbrad","D181201","Ma_13","Sv03",6,70.98,46137,147.46199999999999,7107.6683999999996,79867.002600000007]
[null,"2008-03-13","K-komando","D090801","Ma_11","Sv09",10,32.799999999999997,17712,89.844999999999999,4393.4205000000002,33158.130749999997]
[null,"2008-03-13","Juku & sõbrad","D181200","Ma_07",null,12,155.52000000000001,69984,0,0,104976]
[null,"2008-03-14","Figaro AS","D060601","Ma_01","Sv03",10,13.5,2835,45.954999999999998,2215.0309999999999,7575.0465000000004]
[null,"2008-03-15","Kask & tütred","D090801","Ma_07","Sv07",7,22.96,10332,80.860500000000002,4237.0901999999996,21853.635299999998]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"D131313"]

{"sheet":"Lisamine","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Tellimus"]
[]
[null,"Tellija","Juku & sõbrad"]
[null,"Kuupäev","2008-03-17"]
[]
[null,"Detail","Materjal","Värv","Arv"]
[null,"D090800","Ma_03","Sv02",7]
[null,"D121311","Ma_08","Sv08",1]
[null,"D181200","Ma_08","Sv03",6]

{"sheet":"Päringud_1","index":8,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Andmemudel"]
[null,"Päringud"]
[null,null,"Tellija"]
[null,null,"Juku & sõbrad",null,null,null,25,235.95,119145,179.63049999999998,8005.1695499999996,190725.25432499999]
[]
[null,"Kuupäev","Tellija","Detail","Materjal","Värv","Arv","Materjali\nkogus","Materjali\nmaksumus","Värvi\nkogus","Värvi\nmaksumus","Partii\nmaksumus"]
[null,"2008-03-13","Juku & sõbrad","D060601","Ma_03","Sv04",7,9.4499999999999993,3024,32.168500000000002,897.50115000000005,5882.2517250000001]
[null,"2008-03-13","Juku & sõbrad","D181201","Ma_13","Sv03",6,70.98,46137,147.46199999999999,7107.6683999999996,79867.002600000007]
[null,"2008-03-13","Juku & sõbrad","D181200","Ma_07",null,12,155.52000000000001,69984,0,0,104976]

{"sheet":"Päringud_2","index":9,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Andmemudel"]
[null,"Päringud. Arendatud filtri lindistamine ja seadistamine"]
[]
[]
[null,"Kuupäev","Tellija","Detail","Materjal","Värv","Arv","Materjali\nkogus","Materjali\nmaksumus","Värvi\nkogus","Värvi\nmaksumus","Partii\nmaksumus"]
[null,null,"Juku & sõbrad"]
[]
[]
[]
[null,"Kuupäev","Tellija","Detail","Materjal","Värv","Arv","Materjali\nkogus","Materjali\nmaksumus","Värvi\nkogus","Värvi\nmaksumus","Partii\nmaksumus"]
[null,"2008-03-13","Juku & sõbrad","D060601","Ma_03","Sv04",7,9.4499999999999993,3024,32.168500000000002,897.50115000000005,5882.2517250000001]
[null,"2008-03-13","Juku & sõbrad","D181201","Ma_13","Sv03",6,70.98,46137,147.46199999999999,7107.6683999999996,79867.002600000007]
[null,"2008-03-13","Juku & sõbrad","D181200","Ma_07",null,12,155.52000000000001,69984,0,0,104976]

{"sheet":"Koond","index":10,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"Andmemudel"]
[]
[null,"Koond materjalide lõikes"]
[]
[null,"M_mark","kogus","Maks"]
[null,"Ma_01",13.5,2835]
[null,"Ma_02",0,0]
[null,"Ma_03",9.4499999999999993,3024]
[null,"Ma_04",0,0]
[null,"Ma_05",0,0]
[null,"Ma_06",0,0]
[null,"Ma_07",178.48,80316]
[null,"Ma_08",0,0]
[null,"Ma_09",22.96,10102.4]
[null,"Ma_10",0,0]
[null,"Ma_11",32.799999999999997,17712]
[null,"Ma_12",0,0]
[null,"Ma_13",70.98,46137]
[]
[null,null,328.17,160126.39999999999]

{"sheet":"Materjalid","index":11,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Andmemudel"]
[null,"Materjalid"]
[]
[null,"M_mark","M_hind"]
[null,"Ma_01",210]
[null,"Ma_02",250]
[null,"Ma_03",320]
[null,"Ma_04",350]
[null,"Ma_05",520]
[null,"Ma_06",400]
[null,"Ma_07",450]
[null,"Ma_08",480]
[null,"Ma_09",440]
[null,"Ma_10",430]
[null,"Ma_11",540]
[null,"Ma_12",490]
[null,"Ma_13",650]
[null,"M_21",713]

{"sheet":"Värvid","index":12,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Andmemudel"]
[null,"Värvid"]
[]
[null,"mark","kulu","hind"]
[]
[null,"Sv01",0.43,62.8]
[null,"Sv02",0.3,47.2]
[null,"Sv03",0.35,48.2]
[null,"Sv04",0.35,27.9]
[null,"Sv05",0.4,52.8]
[null,"Sv06",0.3,43]
[null,"Sv07",0.45,52.4]
[null,"Sv08",0.3,61.4]
[null,"Sv09",0.35,48.9]
[null,"Sv10",0.4,39.5]
[null,"Sv11",0.3,62]
[null,"Sv12",0.25,32]
[null,"Sv13",0.5,32.700000000000003]
[null,"SV17",0.6,46.8]
[null,"SV21",0.45,51.7]

{"sheet":"Tellijad","index":13,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Andmemudel"]
[null,"Tellijad"]
[]
[null,"Firma","Aadress","Linn","Indeks"]
[null,"A-grupp","Spordi 13","Tallinn",12003]
[null,"Argo OÜ","Kalda 34","Tallinn",12045]
[null,"Figaro AS","Seebi 22","Tartu",20432]
[null,"Interehitus","Kase 34","Pärnu",30432]
[null,"Juku & sõbrad","Toompea 1","Tallinn",10365]
[null,"Karlson AB","Kooli 45","Tartu",20234]
[null,"Karu & pojad","Metsalaane 23","Pärnu",30423]
[null,"Kask & tütred","Raja 13","Tartu",20154]
[null,"K-komando","Sõjamäe 5","Nuustaku",99999]
[null,"Merlotek","Pärnu mnt 134","Tallinn",13033]
[null,"Mirka","Kaja 17","Tartu",20432]
[null,"N-ehitus","Kuuse 13","Nuustaku",99999]
[null,"Restor OÜ","Kirsi 17","Tallinn",12453]
[null,"Saar & pojad","Põllu 32","Pärnu",30423]
[null,"Sigma","Liivalaia 26","Tallinn",12045]
[null,"Tamm & Lepp","Leesiku 7","Viljandi",40321]
[null,"Tarmen","Kalda 5","Pärnu",30211]
[null,"Tarvis","Mahtra 45","Viljandi",40321]
[null,"Terekor ","Tartu mnt","Tallinn",12034]
[null,"Tervis","Ravi 3","Pärnu",30211]
[null,"Tigon OÜ","Sõpruse 13","Tartu",20367]
[null,"Virex AS","Raudtee 17","Viljandi",40326]
[null,"Servton","Kase 13","Nuustaku",34789]

{"sheet":"Det_makro_2","index":14,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Detail. Makro. Variant 2"]
[]
[null,"L, cm",1200,null,"ruumala","pindala","Üldmaksumus"]
[null,"h, cm",100,null,7.5144000000000002,47.188400000000001,6093.4842080000008]
[null,"b, cm",80]
[null,"d, cm",40,null,"mark","hind","kogus","maksumus"]
[null,"h_1, cm",37,"materjal","Ma_08",480,7.5144000000000002,3606.9120000000003]
[null,"b_1, cm",30,"värv","Sv10",39.5,18.875360000000001,745.57672000000002]
[null,"y_1, cm",35,"muu prots",0.4]
[null,"   mastaap 1:",10]