{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["KursnaLista","Menjacnica","Menjacnica_resenja","Šifrarnik","Restoran","Restoran_resenja","Ocena","Ocene Scenario Summary","Planiranje","Izazov","CenaMaterijala","CenaMaterijala Scenario Summary","Prodaja","Statistika 1","Statistika 1 descriptive","Statistika 2"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"KursnaLista","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Valuta","Kurs"]
[null,"EUR",119.369]
[null,"USD",100.725]
[null,"CHF",102.586]
[null,"GBP",133.822]
[null,"RUB",1.7215]

{"sheet":"Menjacnica","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,10,5]]}
[]
[]
[null,"ID","Valuta","Kurs","Količina","Ukupno"]
[null,10.0,"EUR"]
[null,20.0]
[null,30.0]
[null,40.0]
[null,50.0]
[null,60.0]
[]
[null,"Koristiti DataValidation da u koloni Valuta mogu biti unete samo vrednosti iz radnog lista KursnaLista, a uz pomoć VLOOKUP-a omogućiti da se nakon izabrane valute u koloni Kurs pojavi koliko iznosi kurs za datu valutu (takođe koristiti rad. list KursnaLista) "]

{"sheet":"Menjacnica_resenja","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,7,3,9],[10,1,10,5]]}
[]
[]
[null,"ID","Valuta","Kurs","Količina","Ukupno"]
[null,10.0,"EUR",{"$f":"VLOOKUP(C4,KursnaLista,2,FALSE)","v":119.369},3.0,{"$f":"D4*E4","v":358.107},null,"IF(ISBLANK(C4);\" \";VLOOKUP(C4;KursnaLista;2;FALSE))"]
[null,20.0,"CHF",{"$f":"VLOOKUP(C5,KursnaLista,2,FALSE)","v":102.586},5.0,512.93]
[null,30.0,"EUR",{"$f":"VLOOKUP(C6,KursnaLista,2,FALSE)","v":119.369},3.0,358.107]
[null,40.0,"GBP",{"$f":"VLOOKUP(C7,KursnaLista,2,FALSE)","v":133.822},7.0,936.754]
[null,50.0,"GBP",{"$f":"VLOOKUP(C8,KursnaLista,2,FALSE)","v":133.822},9.0,1204.398]
[null,60.0,"RUB",{"$f":"VLOOKUP(C9,KursnaLista,2,FALSE)","v":1.7215},56.0,96.404]
[]
[null,"Koristiti DataValidation da u koloni Valuta mogu biti unete samo vrednosti iz radnog lista KursnaLista, a uz pomoć VLOOKUP-a omogućiti da se nakon izabrane valute u koloni Kurs pojavi koliko iznosi kurs za datu valutu (takođe koristiti rad. list KursnaLista) "]

{"sheet":"Šifrarnik","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Šifra","Naziv","Cena"]
[null,1001.0,"Ćevapi",300.0]
[null,1002.0,"Vešalica",225.0]
[null,1003.0,"Ražnjići",250.0]
[null,1004.0,"Sok 0.25",40.0]
[null,1005.0,"Pivo 0.33",55.0]
[null,1006.0,"Pivo 0.5",50.0]
[null,1007.0,"Vino 0.5",100.0]
[null,1008.0,"Vino 1l",300.0]
[null,1009.0,"Kolači",60.0]
[null,1010.0,"Palačinke",52.0]
[null,1011.0,"Sladoled",40.0]
[null,1012.0,"Hleb",15.0]
[null,1013.0,"Salata",25.0]

{"sheet":"Restoran","index":4,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,8,2,12]]}
[]
[]
[null,"Br.","Šifra","Količina","Naziv","Jed. cena","Cena",null,"Koristiti DataValidation da u koloni Šifra mogu biti unete samo vrednosti iz radnog lista Šifrarnik, a uz pomoć VLOOKUP-a omogućiti da se nakon izabrane šifre u koloni Naziv i Jed.cena pojavi naziv jela za datu šifru, kao i cena jela (takođe koristiti rad. list Šifrarnik)"]
[null,1.0]
[null,2.0]
[null,3.0]
[null,4.0]
[null,5.0]
[null,6.0]
[null,7.0]
[null,8.0]
[null,9.0]
[null,10.0]
[null,11.0]
[null,12.0]
[null,13.0]
[null,null,null,null,null,"Ukupno:"]

{"sheet":"Restoran_resenja","index":5,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,8,2,12],[3,8,3,12]]}
[]
[]
[null,"Br.","Šifra","Količina","Naziv","Jed. cena","Cena",null,"Koristiti DataValidation da u koloni Šifra mogu biti unete samo vrednosti iz radnog lista Šifrarnik, a uz pomoć VLOOKUP-a omogućiti da se nakon izabrane šifre u koloni Naziv i Jed.cena pojavi naziv jela za datu šifru, kao i cena jela (takođe koristiti rad. list Šifrarnik)"]
[null,1.0,1003.0,4.0,{"$f":"VLOOKUP(C4,Sifrarnik,2,FALSE)","v":"Ražnjići"},{"$f":"VLOOKUP(C4,Sifrarnik,3,FALSE)","v":250},{"$f":"F4*D4","v":1000},null,"IF(ISNUMBER(C4);VLOOKUP(C4;Sifrarnik;2;FALSE);\" \") za kolonu Naziv"]
[null,2.0,1007.0,7.0,{"$f":"VLOOKUP(C5,Sifrarnik,2,FALSE)","v":"Vino 0.5"},{"$f":"VLOOKUP(C5,Sifrarnik,3,FALSE)","v":100},700,null,"IF(ISNUMBER(C4);VLOOKUP(C4;Sifrarnik;3;FALSE);\" \") za kolonu Jed.cena"]
[null,3.0,1007.0,3.0,{"$f":"VLOOKUP(C6,Sifrarnik,2,FALSE)","v":"Vino 0.5"},{"$f":"VLOOKUP(C6,Sifrarnik,3,FALSE)","v":100},300]
[null,4.0,1001.0,6.0,{"$f":"VLOOKUP(C7,Sifrarnik,2,FALSE)","v":"Ćevapi"},{"$f":"VLOOKUP(C7,Sifrarnik,3,FALSE)","v":300},1800]
[null,5.0,1013.0,7.0,{"$f":"VLOOKUP(C8,Sifrarnik,2,FALSE)","v":"Salata"},{"$f":"VLOOKUP(C8,Sifrarnik,3,FALSE)","v":25},175]
[null,6.0,1011.0,8.0,{"$f":"VLOOKUP(C9,Sifrarnik,2,FALSE)","v":"Sladoled"},{"$f":"VLOOKUP(C9,Sifrarnik,3,FALSE)","v":40},320]
[null,7.0,1012.0,9.0,{"$f":"VLOOKUP(C10,Sifrarnik,2,FALSE)","v":"Hleb"},{"$f":"VLOOKUP(C10,Sifrarnik,3,FALSE)","v":15},135]
[null,8.0,1010.0,7.0,{"$f":"VLOOKUP(C11,Sifrarnik,2,FALSE)","v":"Palačinke"},{"$f":"VLOOKUP(C11,Sifrarnik,3,FALSE)","v":52},364]
[null,9.0,1004.0,5.0,{"$f":"VLOOKUP(C12,Sifrarnik,2,FALSE)","v":"Sok 0.25"},{"$f":"VLOOKUP(C12,Sifrarnik,3,FALSE)","v":40},200]
[null,10.0,1006.0,2.0,{"$f":"VLOOKUP(C13,Sifrarnik,2,FALSE)","v":"Pivo 0.5"},{"$f":"VLOOKUP(C13,Sifrarnik,3,FALSE)","v":50},100]
[null,11.0,1012.0,1.0,{"$f":"VLOOKUP(C14,Sifrarnik,2,FALSE)","v":"Hleb"},{"$f":"VLOOKUP(C14,Sifrarnik,3,FALSE)","v":15},15]
[null,12.0,1002.0,6.0,{"$f":"VLOOKUP(C15,Sifrarnik,2,FALSE)","v":"Vešalica"},{"$f":"VLOOKUP(C15,Sifrarnik,3,FALSE)","v":225},1350]
[null,13.0,1005.0,8.0,{"$f":"VLOOKUP(C16,Sifrarnik,2,FALSE)","v":"Pivo 0.33"},{"$f":"VLOOKUP(C16,Sifrarnik,3,FALSE)","v":55},440]
[null,null,null,null,null,"Ukupno:",{"$f":"SUM(G4:G16)","v":6899}]

{"sheet":"Ocena","index":6,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,4,1,6],[9,1,9,2]]}
[]
[null,"UIFI","Bodovi",null,"NAPOMENA: Da bi se koristila \"Šta-ako\" analiza potrebno je da postoji formula. "]
[null,"Zadatak 1",15.0]
[null,"Zadatak 2",15.0]
[null,"Zadatak 3",17.0]
[null,"Seminarski rad",15.0]
[null,"Usmeni ispit",17.0,null,null,{"$f":"C8","v":79},23.0,27.0,31.0]
[null,"Ukupno bodova",{"$f":"SUM(C3:C7)","v":79},null,null,15.0,85.0,89.0,93.0]
[null,null,null,null,null,17.0,87.0,91.0,95.0]
[null,"Koliko bi student trebalo da osvoji bodova na usmenom ispitu da bi imao 9 iz predmeta (potreban broj bodova za 9 je 85)?",null,null,null,19.0,89.0,93.0,97.0]

{"sheet":"Ocene Scenario Summary","index":7,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","o22","o17","o9"]
[null,null,null,null,"Created by Windows User on 11-10-2020","Created by Windows User on 11-10-2020","Created by Windows User on 11-10-2020"]
[null,"Changing Cells:"]
[null,null,"C$7",22.0,22.0,17.0,9.0]
[null,"Result Cells:"]
[null,null,"$C$8",84.0,84.0,79.0,71.0]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"Planiranje","index":8,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,5],[8,1,8,2],[8,4,8,5],[10,1,10,5]]}
[]
[]
[null,"Budžet za goste",null,null,"Budžet za goste"]
[null,"Troškovi rezervacije",23000.0,null,"Troškovi rezervacije",23000.0]
[null,"Iznos po osobi",1000.0,null,"Iznos po osobi",1000.0]
[null,"Broj gostiju",27.0,null,"Broj gostiju",150.0]
[null,"Budžet",{"$f":"C4+C5*C6","v":50000},null,"Budžet",{"$f":"F4+F5*F6","v":173000}]
[]
[null,"Koliko gostiju može da se opsluži sa budžetom od 50000RSD?",null,null,"Koliko treba da iznosi budžet za 150 gostiju?"]
[]
[null,"NAPOMENA: Da bi se koristila \"Šta-ako\" analiza potrebno je da postoji formula. Broj gostiju u drugoj prvoj tabeli treba preko formule izračunati, a budžet uneti ručno"]

{"sheet":"Izazov","index":9,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,2]]}
[]
[]
[null,"Mesec","Prodaja"]
[null,"Januar",157274.0]
[null,"Februar",187349.0]
[null,"Mart",179291.0]
[null,"April",202025.0]
[null,"Maj",212685.0]
[null,"Jun",261375.99999999988]
[null,"Polugodišnji prosek",{"$f":"AVERAGE(C4:C9)","v":200000}]
[]
[]
[null,"Koliko treba da iznosi prodaja u junu mesecu da bi polugodišnji prosek bio 200.000 RSD?"]

{"sheet":"CenaMaterijala","index":10,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
[]
[]
[null,"Ukupno para",1500.0]
[null,"Cena materijala po metru",30.0]
[null,"Metara",15.0]
[null,"Ostatak nakon kupovine",{"$f":"C3-C4*C5","v":1050}]
[]
[]
[null,"Upravljanje scenarijom - ukoliko cena materijala po metru poraste na 40, 50, 60, 70"]

{"sheet":"CenaMaterijala Scenario Summary","index":11,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Scenario Summary"]
[null,null,null,"Current Values:","s40","s50","s60","s70"]
[null,null,null,null,"Created by Windows User on 11-10-2020","Created by Windows User on 11-10-2020","Created by Windows User on 11-10-2020","Created by Windows User on 11-10-2020"]
[null,"Changing Cells:"]
[null,null,"$C$4",30.0,40.0,50.0,60.0,70.0]
[null,"Result Cells:"]
[null,null,"$C$6",1050.0,900.0,750.0,600.0,450.0]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"Prodaja","index":12,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,4,1],[5,1,8,1],[11,1,11,3],[12,1,12,3],[13,1,13,3]]}
[]
[]
[null,"Prodaja","Cena",250.0]
[null,null,"Prodato kom.",300.0]
[null,null,"Prihod",{"$f":"D3*D4","v":75000}]
[null,"Proizvodnja","Cena po kom.",150.0]
[null,null,"Proizvedeno kom.",400.0,null,{"$f":"D10","v":14000},300.0,350.0,400.0,450.0,500.0]
[null,null,"Trošak",{"$f":"D6*D7","v":60000},null,250.0,14000.0,26500.0,39000.0,51500.0,64000.0]
[null,null,"Fiksan trošak",1000.0,null,300.0,29000.0,44000.0,59000.0,74000.0,89000.0]
[null,null,"Profit",{"$f":"D5-D8-D9","v":14000},null,350.0,44000.0,61500.0,79000.0,96500.0,114000.0]
[null,null,null,null,null,400.0,59000.0,79000.0,99000.0,119000.0,139000.0]
[null,"Izračunati nedostajuće vrednosti"]
[null,"Korišćenjem What-if analize - Data Table videti uticaj povećanja broja prodatih kom. (350,400,450,500) na prihod, a zatim i na profit"]
[null,"Videti i uticaj povećanja cene po kom. tokom proizvodnje zajedno sa povećanjem broj prodatih kom. na prihod, a zatim i na profit"]

{"sheet":"Statistika 1","index":13,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,1,12,2]]}
[]
[]
[null,"X","Y"]
[null,74.001,36.45]
[null,74.003,67.9]
[null,74.015,38.77]
[null,74.0,42.18]
[null,74.005,26.72]
[null,74.002,50.77]
[null,74.005,39.3]
[null,74.004,49.71]
[]
[null,"Korelacija, grafik sa obe promenljive, kovarijansa, deskriptivna statistika za svaku promenljivu pojedinačno"]
[]
[]
[null,null,null,"X","Y",null,null,"X","Y"]
[null,null,"X",{"$f":"VARP('Statistika 1'!$B$4:$B$11)","v":0.000018984375},null,null,"X",1.0]
[null,null,"Y",-0.010868124999992505,{"$f":"VARP('Statistika 1'!$C$4:$C$11)","v":132.249775},null,"Y",-0.21689972527214296,1.0]

{"sheet":"Statistika 1 descriptive","index":14,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["X",null,"Y"]
[]
["Mean",74.004375,"Mean",43.975]
["Standard Error",0.0016468313731005772,"Standard Error",4.346587742125999]
["Median",74.0035,"Median",40.739999999999995]
["Mode",74.005,"Mode",{"$error":"#N/A"}]
["Standard Deviation",0.004657942525560686,"Standard Deviation",12.294006669918476]
["Sample Variance",2.169642857142666E-5,"Sample Variance",151.1426]
["Kurtosis",4.769585124234505,"Kurtosis",1.4626815785912317]
["Skewness",2.0010954628982027,"Skewness",0.8595009730702504]
["Range",0.015000000000000568,"Range",41.18000000000001]
["Minimum",74.0,"Minimum",26.72]
["Maximum",74.015,"Maximum",67.9]
["Sum",592.035,"Sum",351.8]
["Count",8.0,"Count",8.0]
["Confidence Level(95.0%)",0.0038941374031174706,"Confidence Level(95.0%)",10.278046786707064]

{"sheet":"Statistika 2","index":15,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,3,1,4],[2,3,2,4]]}
[41.0]
[null,"A",null,"Deskriptivna statistika"]
[null,41.0,null,"A"]
[null,26.0]
[null,26.0,null,"Mean",31.258064516129032]
[null,30.0,null,"Standard Error",1.4554072274489762]
[null,33.0,null,"Median",32.0]
[null,21.0,null,"Mode",30.0]
[null,30.0,null,"Standard Deviation",8.103364494395658]
[null,45.0,null,"Sample Variance",65.6645161290322]
[null,24.0,null,"Kurtosis",-0.6812952977202147]
[null,30.0,null,"Skewness",-0.18399532995232437]
[null,14.0,null,"Range",31.0]
[null,37.0,null,"Minimum",14.0]
[null,33.0,null,"Maximum",45.0]
[null,33.0,null,"Sum",969.0]
[null,40.0,null,"Count",31.0]
[null,21.0,null,"Confidence Level(95.0%)",2.972338093320795]
[null,36.0]
[null,27.0]
[null,21.0]
[null,37.0]
[null,27.0]
[null,28.0]
[null,32.0]
[null,41.0]
[null,17.0]
[null,32.0]
[null,40.0]
[null,24.0]
[null,37.0]
[null,44.0]
[null,42.0]