{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Obrazac","Upute"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Obrazac","index":0,"n_rows":87,"n_cols":30,"rows_kept":87,"cut":false,"hidden":false,"merged":[[13,12,13,13],[80,2,80,6],[81,2,81,6],[82,2,82,6],[84,3,84,4],[84,8,84,9],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[85,8,85,9],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[72,2,72,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[56,2,56,6],[57,2,57,6],[58,2,58,6],[59,2,59,6],[60,2,60,6],[61,2,61,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[55,2,55,6],[44,2,44,6],[45,2,45,6],[46,2,46,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[32,2,32,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[20,2,21,6],[20,7,20,9],[22,2,22,6],[23,2,23,6],[24,2,24,6],[25,2,25,6],[14,6,14,7],[14,8,14,9],[15,6,15,7],[16,3,16,5],[16,6,16,7],[18,3,18,10],[8,3,8,10],[9,3,9,10],[11,6,11,7],[12,3,12,4],[12,6,12,7],[13,3,13,5],[13,6,13,7],[13,8,13,9],[1,3,1,10],[2,3,2,10],[3,3,3,10],[4,3,4,10],[5,3,5,10],[7,3,7,10]],"flags":["formulas_cached_only"]}
[23]
[null,null,null,"MINISTARSTVO POLJOPRIVREDE"]
[null,null,null,"Odjel za informacijske sustave u poljoprivredi - TISUP"]
[null,null,null,"Ulica grada Vukovara 78, 10 000 Zagreb"]
[null,null,null,"web: www.tisup.mps.hr; e-mail: tisup@mps.hr;"]
[null,null,null,"tel: 01 6106 682; 01 6106 563;"]
[]
[null,null,null,"OBRAZAC ZA UNOS PODATAKA O CIJENAMA I KOLIČINAMA PROIZVODA"]
[null,null,null,"ZA GRUPU PROIZVODA: Voće i povrće"]
[null,null,null,"VRSTA CIJENE: Tržnice"]
[]
[null,null,null,"Obveznik:",{"$nulls":6},"UPUTE"]
[null,null,null,"Adresa:"]
[null,null,null,"Izvještajno razdoblje od-do:",null,null,"2024-05-03",null,"2024-05-03","2024-05-09",18]
[{"$nulls":6},"2024-05-03"]
[null,null,null,"Šifra odgovorne osobe:"]
[null,null,null,"Mjesto:"]
[]
[null,null,null,"Ispunjeni obrazac dostaviti do petka do 12:00 sati za aktualni tjedan"]
[]
[null,null,"Proizvod",{"$nulls":4},"Cijena (Euro/kg)",null,null,"Prodana\nkoličina"]
["robakod","robaid",{"$nulls":5},"min","max","prosječna","(kg)",null,null,"Unos1","Unos2","Unos3","Unos4","Unos5","Unos6","Unos7","Unos8","Unos9","Unos10"]
["210002",525,"jabuka Idared-apple Idared",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["210003",833,"jabuka Jonagold-apple Jonagold",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["210004",1745,"jabuka Golden delicious -apple Golden delicious",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["210005",1746,"jabuka Elstar- apple Elstar",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["210006",1747,"jabuka Granny Smith - apple Granny Smith",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["210008",2349,"jabuka Gala -apple Gala",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["210009",2350,"jabuka Cox orange - apple Cox orange",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["210010",2351,"jabuka Boskoop - apple Boskoop",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["210013",2354,"jabuka  Braeburn - apple Braeburn",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["210014",2355,"jabuka Fuji - apple Fuji",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["210015",2356,"jabuka  Shampion - apple Shampion",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21009",531,"kruške-pear",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21015",1751,"grožđe stolno bijelo-table grapes white",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21016",1764,"grožđe stolno crno -table grapes black",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21017",1847,"grožđe ostalo",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21018",528,"kiwi-kiwi",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21019",518,"breskva-peach",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21020",539,"marelica-apricot",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21022",555,"trešnja-cherry",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21025",556,"višnja-wild cherry",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21026",544,"nektarina-nektarin",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21028",521,"dinja-muskmelon",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21033",534,"lubenica-watermelon",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21039",538,"mandarina-tangerine",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21042",543,"naranča-orange",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21045",533,"limun-lemon",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21048",523,"grejp-grapefruit",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21050",526,"jagoda-strawberry",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21051",516,"banana-banana",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["21053",553,"šljiva-plum",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["220001",547,"rajčica-tomato",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["220004",2359,"rajčica  Cherry - tomatoes Cherry",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["220007",1752,"paprika rog-pepper long shaped",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["220011",2361,"paprika babura obojana (crvena, žuta i sl.) - sweet peppers ",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["220012",2362,"paprika bijela - sweet peppers white ",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["220013",2363,"paprika rog zelena - sweet peppers elongated green",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22010",546,"patlidžan-eggplant",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22013",1755,"krastavci salatni-cucumber large for salad",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22014",1756,"krastavci kornišon-cucumber small for souring",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22015",536,"luk (crveni)-onion",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22020",535,"češnjak-garlic",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22021",541,"mladi luk-chalotte",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22028",532,"kupus zeleni-cabbage white",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22029",1758,"kupus crveni - cabbage red",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22031",527,"kelj-savoy cabbage",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22034",542,"mrkva-carrot",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22037",1759,"zelena salata kristalka -lettuce",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22038",1760,"zelena salata puterica -lettuce",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22041",1733,"endivija - endive",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22044",520,"cvjetača-cauliflower",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22046",537,"mahune-french beans",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22049",1761,"grah bijeli - bean white",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22050",1762,"grah šareni - bean cream ",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22054",530,"krumpir-potato",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22058",540,"mladi krumpir-baby potato",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22059",552,"šampinjoni-champignon",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22060",519,"crveni radić-chicory",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22061",1765,"rotkvica",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22065",517,"blitva-swiss chard",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22066",554,"špinat-spinach",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
["22068",835,"peršin-parsley",{"$nulls":4},0,0,0,0,{"$nulls":13},{"$error":"#DIV/0!"},0,{"$error":"#NUM!"}]
[]
[null,null,"U",null,null,", dana",null,null,"Odgovorna osoba:"]
[null,null,null,"00:00:00"]
[null,null,null,52]

{"sheet":"Upute","index":1,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Upute za popunjavanje obrasca i metodološka objašnjenja"]
["Izvještajno razdoblje od-do: automatski - datum na koji se podaci dostavljaju"]
["Proizvod - u lijevoj tablici upisani su nazivi proizvoda za koje je potrebno dostaviti podatke (koje upisujete isključivo "]
["                   u desnu tablicu). Za sve proizvode za koje postoji cijena obavezno treba dostaviti podatke"]
[]
["Prodajna cijena - upisujete jedino u desnu plavu tablicu pod: Unos1, Unos2… - Unos10. Što više unosa to bolje, "]
["ali potrebno je upisati najmanje dva unosa  kako bi sustav mogao povući min i max te izračunati prosjek"]
[]
["Cijene Min, Max i Prosječna su maloprodajne sa PDV-om koje se u obrascu popunjavaju automatski na osnovu unosa."]
[]
["Prosječna cijena - obrazac računa sam kao medijan na osnovu unosa"]
[]
[]
[]
["Napomena: brojčani podaci upisuju se korištenjem decimalnog zareza na numeričkom dijelu tipkovnice"]
["Molimo obratiti pozornost i unositi isključivo zarez kao razdjelnik centa, ukoliko se unese točka umjesto zareza  "]
["lijeva tablica ne prepoznaje unos i sustav javlja pogrešku"]