Witam Kiedyś coś podobnego robiłem z wykorzystaniem dodatku do Excela Solver. Załączam plik, może przyda Ci się.
" Kobieta 21 lat praca lekka 60 kg " ,,,,, " cel " , " 50.9320854234189 "
" tygdniowe zapotrzebowanie " , " minimum " , " maksimum " , " bilans "
" kcl 14700-16100 " , " 14700 " , " 16100 " , " 14699.9999999994 "
" bia?ko 490 g " , " 470 " , " 490 " , " 469.999999999988 "
" w?glowodany 2100-2345 g " , " 2100 " , " 2345 " , " 2123.1392041081 "
" t?uszcze 490-518 g " , " 490 " , " 518 " , " 518.000000000001 " ,,,,
" b?onnik 105-140 g " , " 105 " , " 140 " , " 140 "
" woda 10 l "
" produkty " , " energia [kcl/100] " , " bia?ko [g/100] " , " t?uszcz [g/100] " , " w?glowodany [g/100] " , " b?onnik [g/100] " , " cena [z?/100g] " , " ilo?? " , " minimum " , " maksimum "
" jogurt naturalny " , " 65 " , " 4.70000244140625 " , " 3 " , " 4.70000244140625 " , " 0 " , " 0.760000610351563 " , " 1 " , " 1 " , " 10 "
" chleb " , " 217 " , " 5.8000048828125 " , " 1.1 " , " 45.9000390625 " , " 4.5 " , " 0.400000305175781 " , " 1 " , " 1 " , " 10 "
" banany " , " 74 " , " 0.900000610351563 " , " 0.300000152587891 " , " 17 " , " 1.1 " , " 0.450000305175781 " , " 1 " , " 1 " , " 10 "
" ser Edamski " , " 315 " , " 24.90001953125 " , " 22 " , " 4.30000244140625 " , " 0 " , " 1.5 " , " 1 " , " 1 " , " 4 "
" p?atki kukurydziane " , " 386 " , " 8.6000048828125 " , " 1.60000122070313 " , " 78.9 " , " 6.5 " , " 0.400000305175781 " , " 7.96700892233484 " , " 1 " , " 10 "
" ry? " , " 349 " , " 6.7000048828125 " , " 0.700000610351562 " , " 78.9 " , " 1 " , " 0.400000305175781 " , " 10 " , " 1 " , " 10 "
" jajo kurze " , " 150.560078125 " , " 12.470009765625 " , " 10.670009765625 " , " 1.01000061035156 " , " 0 " , " 1.20000061035156 " , " 1 " , " 1 " , " 3 "
" mas?o roslinne " , " 747 " , " 0 " , " 83 " , " 0 " , " 0 " , " 0.990000610351563 " , " 3.30599660761936 " , " 1 " , " 5 "
" oliwa " , " 897 " , " 0 " , " 99.600078125 " , " 0.200000152587891 " , " 0 " , " 2.70000244140625 " , " 1 " , " 1 " , " 4 "
" ?led? w oleju konserwa " , " 343 " , " 19.700009765625 " , " 29.40001953125 " , " 0.800000610351563 " , " 0 " , " 2.60000244140625 " , " 1 " , " 1 " , " 2 "
" ?led? w pomidorach konserwa " , " 177 " , " 13.700009765625 " , " 12.800009765625 " , " 1.80000122070313 " , " 0.100000076293945 " , " 2.60000244140625 " , " 1 " , " 1 " , " 2 "
" w?troba wieprzowa " , " 127.350078125 " , " 19.67 " , " 4.78000244140625 " , " 1.74000122070313 " , " 0 " , " 0.700000610351562 " , " 2.21419744591129 " , " 1 " , " 5 "
" jab?ka " , " 57.5300390625 " , " 0.55 " , " 0.680000610351563 " , " 12.180009765625 " , " 1.70000122070312 " , " 0.340000305175781 " , " 1 " , " 1 " , " 10 "
" kapusta bia?a " , " 38.10001953125 " , " 1.67000122070312 " , " 0.240000152587891 " , " 7.3800048828125 " , " 2.10000122070312 " , " 0.160000152587891 " , " 1 " , " 1 " , " 10 "
" ogórek " , " 15.280009765625 " , " 0.690000610351562 " , " 0.14 " , " 2.78000244140625 " , " 0.56 " , " 0.450000305175781 " , " 1 " , " 1 " , " 10 "
" papryka " , " 35.06001953125 " , " 1.17000061035156 " , " 0.260000152587891 " , " 6.8800048828125 " , " 1.18000061035156 " , " 0.700000610351562 " , " 1 " , " 1 " , " 10 "
" pomidor " , " 29 " , " 0.900000610351563 " , " 0.5 " , " 5.2000048828125 " , " 1.20000061035156 " , " 0.5 " , " 1 " , " 1 " , " 10 "
" baleron gotowany " , " 246 " , " 15.100009765625 " , " 1.70000122070312 " , " 59.2000390625 " , " 0 " , " 1.20000061035156 " , " 5 " , " 1 " , " 5 "
" bigos " , " 126 " , " 5.6000048828125 " , " 9.8 " , " 3.80000244140625 " , " 2.5 " , " 1.5 " , " 1 " , " 1 " , " 5 "
" fasola szparagowa konserowowa " , " 26 " , " 1.5 " , " 0.200000152587891 " , " 4.5 " , " 2.40000122070313 " , " 0.800000610351563 " , " 1 " , " 1 " , " 3 "
" groszek zielony konserwowy " , " 83 " , " 4.5 " , " 0.200000152587891 " , " 15.800009765625 " , " 5.7000048828125 " , " 0.600000305175781 " , " 1 " , " 1 " , " 3 "
" marchew " , " 41 " , " 1 " , " 0.200000152587891 " , " 8.7 " , " 2.70000244140625 " , " 0.260000152587891 " , " 1 " , " 1 " , " 5 "
" mleko 3,2% " , " 58 " , " 3 " , " 3.20000244140625 " , " 4.30000244140625 " , " 0 " , " 0.29 " , " 1 " , " 1 " , " 10 "
" otr?by pszenne " , " 183 " , " 16 " , " 4.6 " , " 61.9000390625 " , " 42.3000390625 " , " 1.80000122070313 " , " 1 " , " 1 " , " 5 "
" powid?a ?liwkowe " , " 218 " , " 1 " , " 0.200000152587891 " , " 53 " , " 1.80000122070313 " , " 1.55000122070313 " , " 1 " , " 1 " , " 3 "
" ser twarogowy t?usty " , " 104 " , " 21.20001953125 " , " 1.20000061035156 " , " 2.2 " , " 0 " , " 0.450000305175781 " , " 4 " , " 1 " , " 4 "
" woda " , " 0 " , " 0 " , " 0 " , " 0 " , " 0 " , " 0.0800000762939453 " , " 100 " , " 100 " , " 150 "
" sok marchwiowy " , " 48 " , " 0.400000305175781 " , " 0.100000076293945 " , " 11.300009765625 " , " 1.30000122070313 " , " 0.400000305175781 " , " 1 " , " 1 " , " 10 "
" sok grejpfutowy " , " 35 " , " 0.600000305175781 " , " 0.200000152587891 " , " 7.8000048828125 " , " 0.100000076293945 " , " 0.400000305175781 " , " 1 " , " 1 " , " 10 "
" ziemniak " , " 87 " , " 1.70000122070312 " , " 0.100000076293945 " , " 19.9 " , " 1.20000061035156 " , " 0.200000152587891 " , " 5.81203500401964 " , " 1 " , " 10 "
,,,,,,,