{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["SQL","faktura","odbiorca","region","towar","pozycja","zaplata"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":1,"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":"SQL","index":0,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["SELECT * \nFROM odbiorca \nWHERE nazwa LIKE 'A%'",null,null,null,null,null,null,null,"http://afin.net/artykuly/controlling/SQL_KursPodstawowy.htm"]
[]
["NAZWA","ULICA","KOD","MIASTO","TEL","GR_ODB","UWAGI","PELNA_NAZ"]
["ANEX","Mazowiecka 17",null,"CIECHANOW",null,"HURT",null,"ANEX P.H.U. Sp. z o.o."]
["AREX","Strzegomska 62",null,"WROCLAW","71 8979879","HURT",null,"AREX S.C."]

{"sheet":"faktura","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["NR_FAKT","DATA","NAZWA","TERMIN","POZYCJI","WART_NET","VAT"]
["04/1","2010-01-03","AREX","2010-01-17",2,140,30.8]
["04/2","2010-02-03","BRONEX","2010-02-24",4,41,9.02]
["04/3","2010-03-03","JARIMPEX","2010-04-01",3,118.4,26.05]
["04/4","2010-04-03","JUREX","2010-04-24",5,153.9,33.86]
["04/5","2010-04-23","BRONEX","2010-04-30",4,42.6,9.3699999999999992]
["04/6","2010-06-03","EXIMP","2010-06-24",1,15,3.3]
["04/7","2010-07-03","HANIMPEX","2010-07-24",1,5,1.1000000000000001]
["04/8","2010-07-31","DAREX",null,2,3.9,0.86]
["04/9","2010-09-04","CELIMP","2010-09-25",1,13.6,2.99]
["04/10","2010-10-04","CELIMP","2010-10-25",1,5.8,1.28]
["04/11","2010-11-04","GRZESIEX","2010-11-25",1,4.5,0.99]
["04/12","2010-12-04","FRANEX",null,1,11,2.42]
["04/13","2011-01-05","EDEX","2011-01-26",1,5.2,1.1399999999999999]
["04/14","2011-02-05","EDEX","2011-02-26",3,25.5,5.61]
["04/15","2011-03-05","ANEX","2011-03-26",1,5.5,1.21]
["04/16","2011-04-05","SIANEX","2011-04-26",1,10.4,2.29]
["04/17","2011-06-05","KOWALSKI",null,1,4.8,1.06]
["04/18","2011-07-05","NOWAK",null,1,16.2,3.56]
["04/19","2011-08-05","IMPEX","2011-08-26",2,40.5,8.91]

{"sheet":"odbiorca","index":2,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["NAZWA","ULICA","KOD","MIASTO","TEL","GR_ODB","UWAGI","PELNA_NAZ"]
["ANEX","Mazowiecka 17",null,"CIECHANOW",null,"HURT",null,"ANEX P.H.U. Sp. z o.o."]
["AREX","Strzegomska 62",null,"WROCLAW","71 8979879","HURT",null,"AREX S.C."]
["BRONEX","1 Maja 8",null,"OPOLE","77 1234567","DETAL",null,"BRONEX S.C."]
["CELIMP","Orzeszkowej 47/1",null,"SZCZECIN",null,"DETAL",null,"CELIMP Sp. z o.o."]
["DAREX","Pabianicka 2",null,"OPOLE","77 3143243","DETAL",null,"DAREX S.A."]
["EDEX","Waszkiewicza 24",null,"LEGNICA","56 3874928","DETAL",null,"EDEX S.A."]
["EXIMP","Jordana 14/25","59-220","LEGNICA","56 8973928","HURT",null,"EXIMP Sp. z o.o."]
["FRANEX","Zielonego Debu 5/20","51-621","WROCLAW","71 9287349","HURT",null,"FRANEX S.A."]
["GRZESIEX","Pilotow 3","80-460","GDANSK","58 3847892","HURT",null,"GRZESIEX Sp. z o.o."]
["HANIMPEX","Marciniaka 1",null,"WROCLAW","71 9879878","DETAL",null,"HANIMPEX S.C."]
["IMPEX","Pasteura 1","50-367","WARSZAWA","22 2123211","DETAL",null,"IMPEX S.A."]
["JARIMPEX","Kozuchowska 7","51-631","WROCLAW","71 3453433","DETAL",null,"JARIMPEX P.P.H.U. S.A."]
["JUREX","Norwida 25","50-373","WARSZAWA",null,"DETAL",null,"JUREX Sp. z o.o."]
["KOWALSKI","Metalowcow 25","50-991","WARSZAWA","22 2222222","DETAL",null,"Kowalski Jan"]
["NOWAK","Komandorska 1","53-345","BIALYSTOK",null,"DETAL",null,"Nowak Stanislaw"]
["SIANEX","Al. Piastow 2",null,"WROCLAW","71 9999999","DETAL",null,"SIANEX S.A."]

{"sheet":"region","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["MIASTO","REGION"]
["WROCLAW","Poludnie"]
["WARSZAWA","Centrum"]
["OPOLE","Poludnie"]
["LEGNICA","Poludnie"]
["SZCZECIN","Polnoc"]
["GDANSK","Polnoc"]
["CIECHANOW","Centrum"]
["BIALYSTOK","Wschod"]

{"sheet":"towar","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["INDEKS_TOW","TOWAR","CENA_HURT","CENA_DET","CENA_ZAKUP","STAN_MAG","GRUPA","UWAGI"]
["T1","Monitor kolor 17'",12.25,13.5,10,10,"Monitory"]
["T2","Procesor Pentium 100",7,7.83,5,12,"Procesory"]
["T3","Procesor AMD K6",21.5,23.5,20,1,"Procesory"]
["T4","CD ROM",7.4,7.8,3,31,"CDROM"]
["T5","Procesor Pentium MMX 200",5,5.25,4,88,"Procesory"]
["T6","Monitor kolor 15'",6.26,6.95,6,100,"Monitory"]
["T7","Procesor Pentium MMX 200",23.3,25,20,20,"Procesory"]
["T8","Drukarka HP",39.700000000000003,42,35,1,"Drukarki"]
["T9","Drukarka Canon 1000",8.5,9.5,8,0,"Drukarki"]
["T10","Drukarka Canon 2000",9,10,8.5,2,"Drukarki"]

{"sheet":"pozycja","index":5,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["NR_FAKT","POZYCJA","INDEKS_TOW","ILOSC","CENA_JEDN","WART_ZL"]
["04/1",1,"T1",1,65,65]
["04/1",2,"T2",1,75,75]
["04/2",1,"T1",1,5.7,5.7]
["04/2",2,"T2",1,7.6,7.6]
["04/2",3,"T3",1,20.6,20.6]
["04/3",1,"T1",1,100,100]
["04/3",2,"T2",2,5.9,11.8]
["04/3",3,"T3",1,6.6,6.6]
["04/2",4,"T4",1,7.1,7.1]
["04/4",1,"T1",2,9.5,19]
["04/4",2,"T2",1,6.9,6.9]
["04/4",3,"T3",1,9.5,9.5]
["04/4",4,"T4",4,26.5,106]
["04/4",5,"T5",1,12.5,12.5]
["04/5",1,"T1",1,15,15]
["04/5",2,"T2",3,6.1,18.3]
["04/5",3,"T3",1,3.8,3.8]
["04/5",4,"T4",1,5.5,5.5]
["04/6",1,"T1",2,7.5,15]
["04/7",1,"T10",1,5,5]
["04/8",1,"T5",1,3.9,3.9]
["04/9",1,"T3",4,3.4,13.6]
["04/10",1,"T7",1,5.8,5.8]
["04/11",1,"T8",1,4.5,4.5]
["04/12",1,"T8",2,5.5,11]
["04/13",1,"T10",1,5.2,5.2]
["04/14",1,"T1",1,4.8,4.8]
["04/14",2,"T2",3,5.4,16.2]
["04/14",3,"T3",1,4.5,4.5]
["04/15",1,"T1",1,5.5,5.5]
["04/16",1,"T6",2,5.2,10.4]
["04/17",1,"T6",1,4.8,4.8]
["04/18",1,"T1",3,5.4,16.2]
["04/19",1,"T1",5,6.8,34]
["04/19",2,"T2",1,6.5,6.5]

{"sheet":"zaplata","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["NR_FAKT","DATA_ZAP","WART_BRT","ZAPLATA"]
["04/1","2010-01-17",170.8,100]
["04/2","2010-02-28",50.02,50.02]
["04/3","2010-04-20",144.44999999999999,70]
["04/4","2010-04-24",187.76,187.76]
["04/5","2010-06-10",51.97,51.97]
["04/6","2010-06-30",18.3,18.3]
["04/7","2010-07-24",6.1,6.1]
["04/9","2010-10-01",16.59,16.59]
["04/10","2010-10-25",7.08,3]
["04/10","2010-12-10",7.08,3]
["04/3","2010-12-14",144.44999999999999,74.45]
["04/11","2010-11-28",5.49,5.48]
["04/13","2011-01-26",6.34,6.34]
["04/14","2011-02-26",31.11,20]
["04/15","2011-03-27",6.71,6.71]
["04/14","2011-03-10",31.11,10]
["04/16","2011-04-10",12.69,12.69]
["04/14","2011-04-10",31.11,1.1100000000000001]