{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Coloranti","PLI","PLI 0-1","PLI2","Pubblicità","Whisky","Turista","CD","Turnazione","Ladro","Trenini","2 fasi","2 fasi libro"],"not_rendered":{"defined_names":475},"read":"whole","date_system":"1900"}

{"sheet":"Coloranti","index":0,"n_rows":13,"n_cols":6,"rows_kept":13}
[null,"Colorante 1","Colorante 2"]
["Variabili di decisione",500.0000000118233,250.00000000030326]
[{"$nulls":5},"Vincoli"]
[null,"Colorante 1","Colorante 2",null,null,"Quantità massima"]
["Preparato 1",1,1,{"$f":"SUMPRODUCT(B5:C5,B2:C2)","v":750.0000000121265},null,750]
["Preparato 2",1,2,{"$f":"SUMPRODUCT(B6:C6,B2:C2)","v":1000.0000000124298},null,1000]
["Preparato 3",0,1,{"$f":"SUMPRODUCT(B7:C7,B2:C2)","v":250.00000000030326},null,400]
[]
["Prezzo di vendita",7,10]
[]
[]
["Obiettivo","Max"]
["Profitto",{"$f":"SUMPRODUCT(B9:C9,B2:C2)","v":6000.000000085796}]

{"sheet":"PLI","index":1,"n_rows":11,"n_cols":6,"rows_kept":11}
[null,"X1","X2"]
["Variabili di decisione",12,5]
[]
[null,"X1","X2",null,null,"Termine noto"]
["Vincolo 1",5,4,null,{"$f":"SUMPRODUCT(B5:C5,B2:C2)","v":80},80]
["Vincolo 2",4,5,null,{"$f":"SUMPRODUCT(B6:C6,B2:C2)","v":73},80]
[]
["Costi",7,6.2]
[]
["Obiettivo","Max"]
["Profitto",{"$f":"SUMPRODUCT(B8:C8,B2:C2)","v":115}]

{"sheet":"PLI 0-1","index":2,"n_rows":10,"n_cols":11,"rows_kept":10}
[null,"X1","X2","X3","X4","X5","X6","X7"]
["Variabili di decisione",1,1,1,0,1,0,0]
[]
[null,"X1","X2","X3","X4","X5","X6","X7",null,null,"Capacità massima"]
["Pesi",10,10,6,12,24,18,10,null,{"$f":"SUMPRODUCT(B5:H5,B2:H2)","v":50},51]
[]
["Profitti",24,21,12,21,33,18,9]
[]
["Obiettivo","Max"]
["Profitto",{"$f":"SUMPRODUCT(B7:H7,B2:H2)","v":90}]

{"sheet":"PLI2","index":3,"n_rows":11,"n_cols":6,"rows_kept":11}
[null,"X1","X2"]
["Variabili di decisione",4,4]
[]
[null,"X1","X2",null,null,"Termini noti"]
["Vincoli",-1.3,3,null,{"$f":"SUMPRODUCT(B5:C5,B2:C2)","v":6.8},9]
[null,3,0.9,null,{"$f":"SUMPRODUCT(B6:C6,B2:C2)","v":15.6},18]
[]
["Coefficienti F.O.",2,3]
[]
["Obiettivo","Max"]
[null,{"$f":"SUMPRODUCT(B8:C8,B2:C2)","v":20}]

{"sheet":"Pubblicità","index":4,"n_rows":18,"n_cols":7,"rows_kept":18}
[null,"TV Giorno","TV Prima Serata","Radio","Giornali"]
["Variabili di decisione",2.9999999999999996,3.0666666666666664,10,10]
[]
[{"$nulls":6},"Termini noti"]
["Vincolo 1",40000,75000,30000,15000,{"$f":"SUMPRODUCT(B5:E5,B2:E2)","v":800000},800000]
["Vincolo 2",300000,400000,200000,100000,{"$f":"SUMPRODUCT(B6:E6,B2:E2)","v":5126666.666666666},2000000]
["Vincolo 3",40000,75000,0,0,{"$f":"SUMPRODUCT(B7:E7,B2:E2)","v":349999.99999999994},500000]
["Vincolo 4",1,0,0,0,{"$f":"SUMPRODUCT(B8:E8,B2:E2)","v":2.9999999999999996},3]
["Vincolo 5",0,1,0,0,{"$f":"SUMPRODUCT(B9:E9,B2:E2)","v":3.0666666666666664},2]
["Vincolo 6",0,0,1,0,{"$f":"SUMPRODUCT(B10:E10,B2:E2)","v":10},5]
["Vincolo 6 bis",0,0,1,0,{"$f":"SUMPRODUCT(B11:E11,B2:E2)","v":10},10]
["Vincolo 7",0,0,0,1,{"$f":"SUMPRODUCT(B12:E12,B2:E2)","v":10},5]
["Vincolo 7 bis",0,0,0,1,{"$f":"SUMPRODUCT(B13:E13,B2:E2)","v":10},10]
[]
["Clienti raggiunti",400000,900000,500000,200000]
[]
["Obiettivo","Max"]
["Clienti raggiunti",{"$f":"SUMPRODUCT(B15:E15,B2:E2)","v":10960000}]

{"sheet":"Whisky","index":5,"n_rows":15,"n_cols":9,"rows_kept":15}
[null,"A in Freccia Azzurra","B in Freccia Azzurra","C in Freccia Azzurra","A in Montagna Rocciosa","B in Montagna Rocciosa","C in Montagna Rociosa"]
["Variabili di decisione",1526.6666666666667,508.888888888889,508.88888888888874,473.3333333333333,1991.1111111111109,691.1111111111115]
[{"$nulls":8},"Termini noti"]
["Vincolo Disponibilità di A",1,0,0,1,0,0,{"$f":"SUMPRODUCT(B4:G4,B2:G2)","v":2000},2000]
["Vincolo disponibilità di B",0,1,0,0,1,0,{"$f":"SUMPRODUCT(B5:G5,B2:G2)","v":2500},2500]
["Vincolo disponibilità di C",0,0,1,0,0,1,{"$f":"SUMPRODUCT(B6:G6,B2:G2)","v":1200.0000000000002},1200]
["Vincolo composizione FA",-0.4,0.6,0.6,0,0,0,{"$f":"SUMPRODUCT(B7:G7,B2:G2)","v":-5.684341886080802e-14},0]
["Vincolo composizione FA",-0.2,-0.2,0.8,0,0,0,{"$f":"SUMPRODUCT(B8:G8,B2:G2)","v":-1.7053025658242404E-13},0]
["Vincolo composizione MR",0,0,0,-0.6,-0.6,0.4,{"$f":"SUMPRODUCT(B9:G9,B2:G2)","v":-1202.222222222222},0]
["Vincolo composizione MR",0,0,0,-0.85,0.15,0.15,{"$f":"SUMPRODUCT(B10:G10,B2:G2)","v":4.263256414560601e-14},0]
[]
["Coefficienti Profitto",0,2,3,-1,1,2]
[]
["Obiettivo","Max"]
["Profitto",{"$f":"SUMPRODUCT(B12:G12,B2:G2)","v":5444.444444444445}]

{"sheet":"Turista","index":6,"n_rows":7,"n_cols":12,"rows_kept":7}
[null,"Mappa x1","Panino x2","Occhiali da sole x3","Banana x4","Telefonino x5","Acqua x6","Mela x7","Maglietta x8","Ombrello x9"]
[null,0,1,0,1,1,1,1,0,0]
[]
["Valore",150,160,20,60,65,200,40,15,40,null,"Capacità massima"]
["Peso",9,50,7,27,30,153,39,24,73,{"$f":"SUMPRODUCT(B5:J5,B2+B2:J2)","v":299},300]
[]
["Obiettivo: Max profitto",{"$f":"SUMPRODUCT(B4:J4,B2+B2:J2)","v":525}]

{"sheet":"CD","index":7,"n_rows":7,"n_cols":9,"rows_kept":7}
[null,"Light my fire x1 ","Let it be x2 ","Fame x3  ","I feel good x4 ","I will survive x5 ","Imagine x6 "]
[null,0,0,0,1,1,1]
[]
["Gradimento",8,7.5,7,8,8.5,9]
["Ingombro",210,200,190,220,235,250,{"$f":"SUMPRODUCT(B2:G2,B5:G5)","v":705},800]
[]
["Massimo Gradimento",{"$f":"SUMPRODUCT(B2:G2,B4:G4)","v":25.5}]

{"sheet":"Turnazione","index":8,"n_rows":14,"n_cols":10,"rows_kept":14}
[null,"x1","x2","x3","x4","x5","x6","x7"]
[null,6,2,3.9999999999999996,0,7,3,0.9999999999999993]
[]
["Lunedì",1,0,0,1,1,1,1,{"$f":"SUMPRODUCT(B4:H4,B2:H2)","v":17},17]
["Martedì",1,1,0,0,1,1,1,{"$f":"SUMPRODUCT(B5:H5,B2:H2)","v":19},13]
["Mercoledì",1,1,1,0,0,1,1,{"$f":"SUMPRODUCT(B6:H6,B2:H2)","v":16},15]
["Giovedì",1,1,1,1,0,0,1,{"$f":"SUMPRODUCT(B8:H8,B2:H2)","v":19},19]
["Venerdì",1,1,1,1,1,0,0,{"$f":"SUMPRODUCT(B8:H8,B2:H2)","v":19},14]
["Sabato",0,1,1,1,1,1,0,{"$f":"SUMPRODUCT(B9:H9,B2:H2)","v":16},16]
["Domenica",0,0,1,1,1,1,1,{"$f":"SUMPRODUCT(B2:H2,B10:H10)","v":15},11]
[]
["Coefficienti",1,1,1,1,1,1,1]
[]
["Minimo numero di operatori",{"$f":"SUMPRODUCT(B2:H2,B12:H12)","v":23}]

{"sheet":"Ladro","index":9,"n_rows":9,"n_cols":10,"rows_kept":9}
["Oggetti","Collana d'oro","Teiera d'argento","Statua d'avorio","Portacandele di cristallo","Borsa di pelle","Quadro","Parure di perle"]
[null,"x1","x2","x3","x4","x5","x6","x7"]
[null,1,1,1,1,0,0,1]
[]
["Peso",6,12,15,18,10,12,9,{"$f":"SUMPRODUCT(B3:H3,B5:H5)","v":60},60]
[]
["Valore",200,300,325,320,160,180,125]
[]
["Massimo profitto",{"$f":"SUMPRODUCT(B7:H7,B3:H3)","v":1270}]

{"sheet":"Trenini","index":10,"n_rows":12,"n_cols":5,"rows_kept":12}
["Modellini","Lancia x1","Fulmine x2"]
[null,5.999999999999998,2.0000000000000004]
["Guadagno",30,80]
[]
["Vagone I classe",1,2,{"$f":"SUMPRODUCT(B5:C5,B2:C2)","v":10},10]
["Vagone II classe",2,3,{"$f":"SUMPRODUCT(B6:C6,B2:C2)","v":18},21]
["Vagone merci",1,3,{"$f":"SUMPRODUCT(B7:C7,B2:C2)","v":12},12]
["Vagone ristorante",1,0,{"$f":"SUMPRODUCT(B8:C8,B2:C2)","v":5.999999999999998},10]
["Vagone letto",1,0,{"$f":"SUMPRODUCT(B9:C9,B2:C2)","v":5.999999999999998},9]
["Motrice",1,1,{"$f":"SUMPRODUCT(B10:C10,B2:C2)","v":7.999999999999998},9]
[]
["Guadagno totale",{"$f":"SUMPRODUCT(B2:C2,B3:C3)","v":340}]

{"sheet":"2 fasi","index":11,"n_rows":10,"n_cols":7,"rows_kept":10}
["Variabili","x1","x2","x3","x4"]
[null,1.9999999999999998,4,0,0]
[]
["Coefficienti f.o. ",3,1,-1,1]
[]
["Vincolo 1",1,2,1,0,{"$f":"SUMPRODUCT(B6:E6,B2:E2)","v":10},10]
["Vincolo 2",5,5,2,1,{"$f":"SUMPRODUCT(B7:E7,B2:E2)","v":30},30]
["Vincolo 3",3,1,0,1,{"$f":"SUMPRODUCT(B8:E8,B2:E2)","v":10},10]
[]
["Max",{"$f":"SUMPRODUCT(B2:E2,B4:E4)","v":10}]

{"sheet":"2 fasi libro","index":12,"n_rows":11,"n_cols":10,"rows_kept":11}
[null,null,"Variabili","x1","x2","x3","x4","x5"]
[{"$nulls":3},5.555555555555555,0,0,0,1.1111111111111112]
[]
[null," ","vincolo 1",1,3,-1,2,4,{"$f":"SUMPRODUCT(D4:H4,D2:H2)","v":10},10]
[null,null,"vincolo 2",2,-1,0,1,-1,{"$f":"SUMPRODUCT(D5:H5,D2:H2)","v":10},10]
[null,null,"vincolo 3",3,2,-1,3,3,{"$f":"SUMPRODUCT(D6:H6,D2:H2)","v":19.999999999999996},20]
[null,null,"vincolo 4",4,5,-3,5,7,{"$f":"SUMPRODUCT(D7:H7,D2:H2)","v":30},30]
[]
[null,null,"coefficienti",-20,30,100,-20,40]
[]
[null,null,"max",{"$f":"SUMPRODUCT(D9:H9,D2:H2)","v":-66.66666666666667}]