{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Zadatak 1","Zadatak 1 - rješenje","Zadatak 2","Zadatak 2 - rješenje","Zadatak 3","Zadatak 3 - rješenje"],"read":"whole","date_system":"1900"}

{"sheet":"Zadatak 1","index":0,"n_rows":10,"n_cols":11,"rows_kept":10}
[]
[]
[null,"Ime","Prezime","Adresa","Poštanski broj","Mjesto","Poduzeće","Url1","Url2","Url3","Url4"]
[null,"Pero","Perić","Unska 16",10000,"Zagreb","Algebra d.o.o.","www.algebra.hr","www.racunarstvo.hr","databases.about.com","www.datamodel.org"]
[null,"Ana","Milić","Zagrebačka 28",10000,"Zagreb","Algebra d.o.o.","www.sqlite.org","www.firebirdsql.org","www.racunarstvo.hr","www.mysql.com"]
[null,"Sanja","Tarak","Anićeva 42",21000,"Split","LošFilm","www.racunarstvo.hr","www.datamodel.org","www.sqlite.org","www.readwriteweb.com/archives/is_the_relational_database_doomed.php"]
[null,"Nikola","Jurčević","Zagorska 194",10000,"Zagreb","Algebra d.o.o.","www.sqlite.org","www.zagreb.hr","www.algebra.hr","www.joelonsoftware.com"]
[null,"Katarina","Gjalski","Kneza Mislava 11a",43000,"Sisak","LošFilm","www.mysql.com","www.joelonsoftware.com","databases.about.com","www.firebirdsql.org"]
[null,"Stjepan","Kotoromanić","Ilica 224",21000,"Split","LošFilm","www.racunarstvo.hr","www.datamodel.org","www.joelonsoftware.com","www.sqlite.org"]
[null,"Ivan","Mažuranić","Mažuranićeva 11",43000,"Sisak","Algebra d.o.o.","www.firebirdsql.org","www.algebra.hr","www.datamodel.org","www.mysql.com"]

{"sheet":"Zadatak 1 - rješenje","index":1,"n_rows":20,"n_cols":11,"rows_kept":20}
[]
[]
[null,"Ime","Prezime","Adresa","Poštanski broj","Mjesto","Poduzeće","Url1","Url2","Url3","Url4"]
[null,"Pero","Perić","Unska 16",10000,"Zagreb","Algebra d.o.o.","www.algebra.hr","www.racunarstvo.hr","databases.about.com","www.datamodel.org"]
[null,"Ana","Milić","Zagrebačka 28",10000,"Zagreb","Algebra d.o.o.","www.sqlite.org","www.firebirdsql.org","www.racunarstvo.hr","www.mysql.com"]
[null,"Sanja","Tarak","Anićeva 42",21000,"Split","LošFilm","www.racunarstvo.hr","www.datamodel.org","www.sqlite.org","www.readwriteweb.com/archives/is_the_relational_database_doomed.php"]
[null,"Nikola","Jurčević","Zagorska 194",10000,"Zagreb","Algebra d.o.o.","www.sqlite.org","www.zagreb.hr","www.algebra.hr","www.joelonsoftware.com"]
[null,"Katarina","Gjalski","Kneza Mislava 11a",43000,"Sisak","LošFilm","www.mysql.com","www.joelonsoftware.com","databases.about.com","www.firebirdsql.org"]
[null,"Stjepan","Kotoromanić","Ilica 224",21000,"Split","LošFilm","www.racunarstvo.hr","www.datamodel.org","www.joelonsoftware.com","www.sqlite.org"]
[null,"Ivan","Mažuranić","Mažuranićeva 11",43000,"Sisak","Algebra d.o.o.","www.firebirdsql.org","www.algebra.hr","www.datamodel.org","www.mysql.com"]
[]
[]
[]
[null,null,"OSOBA",null,"MJESTO",null,null,"PODUZECE",null,"URL"]
[null,null,"IDOsoba",null,"PBR",null,null,"IDPoduzece",null,"IDURL"]
[null,null,"Ime",null,"Naziv",null,null,"Naziv",null,"URL"]
[null,null,"Prezime",null,"PostanskiBroj",{"$nulls":4},"PoduzeceID"]
[null,null,"Adresa"]
[null,null,"PBR"]
[null,null,"PoduzeceID"]

{"sheet":"Zadatak 2","index":2,"n_rows":6,"n_cols":13,"rows_kept":6}
[]
[null,"Datum","Kupac","Dućan","Prodavač","Artikl 1","Količina","Artikl 1","Količina","Artikl 3","Količina","Artikl 4","Količina"]
[null,"2009-01-15","Katarina Gjalski","Kneza Mislava 11a","Pero","Bijeli kruh",1,"Hren 250 g",2,"Mineralna voda 1 l",1,"Obična voda 0.5 l",2]
[null,"2009-01-18","Nikola Jurčević","Zagorska 194","Petar","Mlijeko 1 l",3,"Hren 250 g",1,"Obična voda 0.5 l",3]
[null,"2009-01-19","Nikola Jurčević","Zagorska 194","Pero","10 jaja",2,"Mlijeko 1 l",1]
[null,"2009-01-19","Katarina Gjalski","Kneza Mislava 211b","Krešo","Hren 250 g",1,"Mljeko 1 l",5,"Pivo 0.5 l",1]

{"sheet":"Zadatak 2 - rješenje","index":3,"n_rows":15,"n_cols":13,"rows_kept":15}
[]
[null,"Datum","Kupac","Dućan","Prodavač","Artikl 1","Količina","Artikl 1","Količina","Artikl 3","Količina","Artikl 4","Količina"]
[null,"2009-01-15","Katarina Gjalski","Kneza Mislava 11a","Pero","Bijeli kruh",1,"Hren 250 g",2,"Mineralna voda 1 l",1,"Obična voda 0.5 l",2]
[null,"2009-01-18","Nikola Jurčević","Zagorska 194","Petar","Mlijeko 1 l",3,"Hren 250 g",1,"Obična voda 0.5 l",3]
[null,"2009-01-19","Nikola Jurčević","Zagorska 194","Pero","10 jaja",2,"Mlijeko 1 l",1]
[null,"2009-01-19","Katarina Gjalski","Kneza Mislava 211b","Krešo","Hren 250 g",1,"Mljeko 1 l",5,"Pivo 0.5 l",1]
[]
[]
[]
[null,null,"Kupac",null,"Prodavac",null,"Ducan",null,"Artikl",null,"Racun",null,"Stavka"]
[null,null,"IDKupac",null,"IDProdavac",null,"IDDucan",null,"IDArtikl",null,"IDRacun",null,"IDStavka"]
[null,null,"Ime",null,"Ime",null,"Adresa",null,"Naziv",null,"Datum",null,"RacunID"]
[null,null,"Prezime",{"$nulls":7},"KupacID",null,"ArtiklID"]
[{"$nulls":10},"ProdavacID",null,"Kolicina"]
[{"$nulls":10},"DucanID"]

{"sheet":"Zadatak 3","index":4,"n_rows":6,"n_cols":14,"rows_kept":6}
[]
[null,"Datum","Vlasnik auta","Adresa servisa","Mehaničar","Dio 1","Količina","Dio 2","Količina","Dio 3","Količina","Dio 4","Količina","Ukupna cijena"]
[null,"2009-01-15","Katarina Gjalski","Kneza Mislava 11a","Pero","Filtar ulja",1,"Ulje 1 l",5,"Svjećice",4,"Filtar zraka",1,{"v":2500,"d":"2,500.00 kn"}]
[null,"2009-01-18","Nikola Jurčević","Zagorska 194","Petar","Filtar klime",1,"Ulje 1 l",4,{"$nulls":4},{"v":1050,"d":"1,050.00 kn"}]
[null,"2009-01-19","Nikola Jurčević","Zagorska 19 4","Pero","Metlice brisača",3,{"$nulls":6},{"v":200,"d":"200.00 kn"}]
[null,"2009-01-19","Katarina Gjalski","Kneza Mislava 211b","Krešo","Prednji defni far",1,"Prednji desni blatobran",1,"Prednja desna poluosovina",1,"Felga",1,{"v":7800,"d":"7,800.00 kn"}]

{"sheet":"Zadatak 3 - rješenje","index":5,"n_rows":16,"n_cols":15,"rows_kept":16}
[]
[null,"Registracija auta","Datum","Vlasnik auta","Adresa servisa","Mehaničar","Dio 1","Količina","Dio 2","Količina","Dio 3","Količina","Dio 4","Količina","Ukupna cijena"]
[null,"ZG 0001 AA","2009-01-15","Katarina Gjalski","Kneza Mislava 11a","Pero","Filtar ulja",1,"Ulje 1 l",5,"Svjećice",4,"Filtar zraka",1,{"v":2500,"d":"2,500.00 kn"}]
[null,"ZG 0007 NJ","2009-01-18","Nikola Jurčević","Zagorska 194","Petar","Filtar klime",1,"Ulje 1 l",4,{"$nulls":4},{"v":1050,"d":"1,050.00 kn"}]
[null,"ZG 0007 NJ","2009-01-19","Nikola Jurčević","Zagorska 19 4","Pero","Metlice brisača",3,{"$nulls":6},{"v":200,"d":"200.00 kn"}]
[null,"ZG 0001 AA","2009-01-19","Katarina Gjalski","Kneza Mislava 211b","Krešo","Prednji defni far",1,"Prednji desni blatobran",1,"Prednja desna poluosovina",1,"Felga",1,{"v":7800,"d":"7,800.00 kn"}]
[]
[]
[]
[null,"Auto",null,"VlasniciAuta",null,"Servis",null,"Mehaničar",null,"Dijelovi",null,"OdradjeniServisi",null,"UgradjeniDijeloviNaServisu"]
[null,"IDAuto",null,"IDVlasnikAuta",null,"IDServis",null,"IDMehaničar",null,"IDDio",null,"IDOdradjeniServis",null,"IDUgradjeniDio"]
[null,"RegistarskaOznaka",null,"Ime",null,"Adresa",null,"Ime",null,"Naziv",null,"Datum",null,"OdradjeniServisID"]
[null,"VlasnikID",null,"Prezime",{"$nulls":7},"AutoID",null,"DioID"]
[{"$nulls":11},"ServisID",null,"Kolicina"]
[{"$nulls":11},"MehanicarID"]
[{"$nulls":11},"UkupnaCijena"]