{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Male","Female","Procedure"],"not_rendered":{"defined_names":78,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"Male","index":0,"n_rows":64,"n_cols":49,"rows_kept":64}
["Food Group","Cost","Solution","Cur.Consumption","TFP",{"$nulls":4},"Calcium","Cholesterol","Copper","Energy","Fiber","Folate","Iron","Magnesium","Niacin","Phosphorus","Potassium","Riboflavin","Sodium","Thiamin","Vitamin B12","Vitamin B6","Vitamin C","Vitamin E","Vitamin A","Zinc","Calories from linoleic acid","Calories from linolenic acid","Calories from protein","Calories from carbohydrates","calories from fat","Calories from saturated fat","Servings of grains","Servings of vegetables","Servings of fruit","Servings of dairy","Servings of meat/protein","Servings of fats and oils","SOFASUG_tot_kcal","Servings of whole grains","Servings of dark green vegetables","Servings of orange vegetables","Servings of legumes (vegetables)","V_STARCY_py","V_OTHER_py","Servings of whole fruit"]
["Milk",0.1162,0,0.8955,0.0068,{"$nulls":4},112.2304,11.6225,0.0112,70.1136,0.0032,5.0504,0.0429,9.9512,0.1098,93.1717,148.1604,0.1781,45.8517,0.0396,0.4288,0.0393,0.0532,0.0859,33.4926,0.4024,1.1927,0.6953,12.9883,20.5465,37.0888,22.0016,0.0003,0.0003,0.0002,0.3876,0,0.0032,33.1552,0,0,0,0,0,0.0003,0.0002]
["Low fat milk",0.0716,0,1.2654,7.4388,{"$nulls":4},120.6931,6.1955,0.0123,47.7256,0.0017,5.1965,0.0327,11.1977,0.0912,96.825,153.6514,0.1801,42.9963,0.0368,0.469,0.04,0.1888,0.0233,53.6463,0.4417,0.3874,0.0773,13.5277,21.359,12.7238,8.2258,0,0,1.5E-3,0.4096,0,0,12.0719,0,0,0,0,0,0,1.5E-3]
["Cheese",0.7203,0.4428025187577811,0.0969,0.0005,{"$nulls":4},572.3382,70.9176,0.052,307.1513,0.0273,12.1394,0.502,26.0082,0.1631,468.7814,172.9857,0.3899,916.1922,0.0507,1.0942,0.0774,0.0892,0.2328,182.9759,2.7631,5.0096,1.9392,83.6314,19.9061,203.3664,125.3811,0.0234,2.3E-3,0.0002,1.8263,0.0048,1.4E-3,169.3818,0,0,0,0,0,2.3E-3,0.0002]
["Milk-based desserts",0.2592,0,0.2672,0.0013,null,"Cost",null,null,115.7822,20.8786,0.0614,131.4621,0.5792,8.9646,0.3279,15.716,0.322,98.881,174.2701,0.1904,64.5188,0.0503,0.3656,0.0631,1.4684,0.2454,72.1126,0.59,2.1829,0.7913,13.4574,68.4917,52.6878,31.3595,0.073,1E-4,0.0017,0.2988,0.0172,0.1578,82.9507,0.0017,0,0,0,1E-4,0,0.0017]
["Low fat milk-based desserts",0.1743,0,0.1809,0.0017,null,{"$f":"SUMPRODUCT(B2:B59,C2:C59)","v":5.299267584410959},null,null,107.327,5.0786,0.1186,92.5672,0.6289,15.8981,0.8132,23.1862,0.7716,101.274,184.1635,0.1761,51.5694,0.0896,0.4009,0.0948,2.6533,0.5649,69.1878,0.8136,1.7106,0.2405,14.7206,63.3205,15.7893,8.1903,0.0545,0,0.0125,0.3366,0.0207,0.3059,40.5543,0,0,0,0,0,0,0.0125]
["Low cost red meat",0.5069,0,0.0958,2.3E-3,{"$nulls":4},24.0837,89.1727,0.0795,277.6817,0.0064,9.7468,2.3793,19.5847,4.6971,187.1774,288.1673,0.1796,101.6397,0.0642,2.6354,0.3408,0.0244,0.4284,0.0328,5.9645,4.1191,0.7255,100.4131,0.4328,170.0344,66.0955,0.0067,0,0,0,3.1412,1E-3,81.1779,0,0,0,0,0,0,0]
["Regular cost red meat",0.8353,0,0.0692,0.0005,{"$nulls":4},17.3745,88.071,0.1159,322.9094,0.1306,12.2424,2.1785,26.3678,5.0938,258.6983,383.8068,0.251,518.8183,0.2909,1.8194,0.3419,0.1798,0.2587,3.257,4.3559,14.0795,1.5814,117.2095,7.2168,190.3331,69.4073,0.0805,0.0002,0,0.0016,2.9136,0.299,105.8551,1.5E-3,0,0,0,0,0.0002,0]
["Low cost lean red meat",0.3993,0,0.0138,0.2945,{"$nulls":4},18.0753,74.6431,0.3359,177.4522,0.14,11.0227,1.7841,21.3961,5.5925,232.4955,339.3808,0.3591,890.9991,0.5854,2.0208,0.3799,0.1731,0.3997,110.394,2.839,9.4354,1.3158,94.4393,9.1342,67.562,21.4389,0.1482,0.0003,0,0.0002,3.3167,0.7632,6.073,0,0,0,0,0,0.0003,0]
["Regular cost lean red meat",1.2257,0,0.1985,0.0027,{"$nulls":4},13.2267,84.3457,0.1138,212.9754,0.0436,9.2999,2.43,28.1463,5.15,237.8619,407.535,0.2883,76.709,0.3389,2.1103,0.4505,0.1747,0.2178,1.1219,4.9137,6.3086,0.5453,118.0961,2.9773,83.6758,30.1982,0.0547,0,0,0.0005,3.4221,0.2807,12.3772,0,0,0,0,0,0,0]
["Low cost fish",0.571,4.6254074793532191E-8,0.0195,0.0022,{"$nulls":4},53.4446,81.5141,0.2671,215.3945,0.4911,26.1411,1.0253,31.3632,2.4961,203.0637,284.7383,0.1684,209.9722,0.2121,2.307,0.152,0.6834,1.0698,32.3709,1.9245,24.4115,2.3029,63.8021,38.5775,109.0903,24.5519,0.6325,0.0026,0.0005,0.0408,2.3592,0.3567,60.9452,0,1E-4,0,0,0,0.0024,0.0005]
["Regular cost fish",1.264,0,0.1123,1.5E-3,{"$nulls":4},49.4897,93.3441,0.1257,211.9115,0.3161,21.4527,1.5057,35.6351,3.7737,258.808,339.0319,0.1287,135.5937,0.178,1.9917,0.2202,1.6195,1.2239,45.5877,1.0215,25.1313,2.7868,81.9514,26.2712,99.0356,19.8823,0.4767,0,5.3E-3,6.6E-3,2.7932,0.1958,54.5076,0,0,0,0,0,0,5.3E-3]
["Low cost lean fish",0.4583,0.17346900071331023,0.0502,0.2959,{"$nulls":4},37.7452,19.3773,0.0642,81.6539,0.3163,8.1019,0.9318,17.5009,4.7686,106.7091,187.9012,0.0767,313.3051,0.0346,2.7059,0.1544,1.5832,0.3701,20.4546,0.4818,2.8652,0.2708,47.3239,13.2731,18.6661,5.7383,0.1087,0.1057,0,0.0295,1.5525,0.3553,7.1723,0,0.0075,0,0,0.0512,0.0472,0]
["Regular cost lean fish",1.468,0,0.031,0.0004,{"$nulls":4},72.2908,119.6683,0.3232,130.6316,0.0037,16.7908,1.702,42.469,4.4968,248.5298,306.155,0.0996,422.9651,0.0734,2.7232,0.1764,1.3424,1.4276,35.6848,1.8099,2.5628,0.4321,92.4148,1.8309,30.3453,6.0189,0.0042,0,1.9E-3,0,3.4655,0.211,2.584,0,0,0,0,0,0,1.9E-3]
["Low cost poultry",0.3934,7.79424220487014e-08,0.0861,0.0013,{"$nulls":4},17.3969,99.0715,0.0904,261.7297,0.2362,32.8638,1.6879,21.1238,5.6296,160.1089,205.6844,0.2494,78.1879,0.1131,0.5101,0.2809,0.2639,0.5319,77.5954,2.255,33.8417,2.4896,91.6275,27.6155,136.4729,32.2643,0.5527,0,0,0.006,2.6658,0,63.6891,0,0,0,0,0,0,0]
["Regular cost poultry",0.6512,0,0.165,0.0017,{"$nulls":4},17.169,85.0203,0.0732,265.8504,0.1953,18.2635,1.4034,21.9856,7.647,167.202,207.8478,0.1731,88.4931,0.0996,0.2818,0.3904,0.0092,0.4925,33.673,1.6643,31.9977,2.3403,99.0222,22.5105,138.1526,33.8245,0.4499,0,1E-4,0.0048,2.7356,0.0092,70.6024,0,0,0,0,0,0,1E-4]
["Low cost lean poultry",0.4145,0,0.0294,0.9266,{"$nulls":4},15.6286,135.6944,0.1155,161.0636,0.2054,32.3382,2.0058,18.9787,4.8115,171.1657,243.0852,0.2695,117.8785,0.0684,1.0799,0.304,2.47,0.2923,188.1466,2.7944,10.8328,0.5293,92.6293,6.4751,57.0522,16.0251,0.0002,0.1041,0,0,2.9124,0,0.8109,0,0,0.0131,0,0.0779,0.0131,0]
["Regular cost lean poultry",0.8974,0,0.1505,0.0025,{"$nulls":4},14.6358,75.6103,0.0631,227.7658,0,19.3711,1.0955,24.2924,8.2116,222.906,256.6082,0.1519,231.9552,0.0806,0.3024,0.3877,0,0.6583,10.8212,1.627,16.2394,1.0699,97.6919,21.9911,102.9849,25.0005,0.4212,0,0,0,2.978,6.0911,5.6097,0,0,0,0,0,0,0]
["Lunch meat",0.4796,5.4539263543450619E-8,0.2205,0.0009,{"$nulls":4},24.5786,66.2366,0.1168,325.6126,0.3196,4.3757,1.4886,14.6202,3.5071,144.8117,217.7679,0.1899,1016.0999,0.2107,1.5936,0.2032,0.6754,0.2945,41.0744,2.4235,18.9721,1.7639,58.7055,11.0183,252.2971,92.8475,1E-4,0,0,1.4E-3,2.7979,0.1745,167.7553,0,0,0,0,0,0,0]
["Low fat lunch meat",0.8253,0,0.0909,0.0007,{"$nulls":4},21.2759,53.8556,0.0808,166.5285,0.0441,4.7461,1.2619,17.6215,4.5975,195.9795,278.4997,0.2114,1059.4191,0.4635,0.6684,0.3077,0.2951,0.2356,5.2069,2.0045,10.1961,0.9072,72.6507,12.0374,78.0892,24.9336,0,0,0,0,3.4751,1E-3,14.8746,0,0,0,0,0,0,0]
["Eggs",0.1898,0,0.2661,0.006,{"$nulls":4},72.7591,337.958,0.0795,177.9579,0.0646,32.1475,1.5227,12.6724,0.3793,185.1287,153.2592,0.4145,240.0405,0.0836,0.9718,0.1301,0.359,1.1156,137.844,1.1161,20.0706,1.3143,47.6151,10.4129,116.9229,36.1512,0.0632,0.012,0.0002,0.0968,1.7279,0.589,60.3887,0,0,0,0,0.003,0.009,0.0002]
["Meat mixtures",0.4685,0,0.4627,0.0041,{"$nulls":4},72.6623,41.0489,0.1049,226.012,0.9037,46.2964,1.7411,18.8141,3.3524,129.955,206.1031,0.1862,391.5984,0.1379,0.8161,0.1824,2.4829,0.562,27.8161,2.0249,17.0683,1.8839,51.7459,62.687,109.5765,37.1658,1.0288,0.1478,0.0013,0.0839,1.1879,2.1041,59.2402,2.3E-3,0.0034,0.0041,0.0002,0.0151,0.1252,0.0013]
["Low fat meat mixtures",2.0417,0,0.5273,4.3E-3,{"$nulls":4},20.9429,25.8492,0.1042,111.1427,1.1405,19.2453,1.1718,17.2409,2.6375,87.6274,225.9219,0.1006,260.0567,0.0837,0.5576,0.1679,5.3845,0.6345,31.7522,1.3147,8.7774,0.9385,37.1708,33.2556,40.1852,10.8482,0.1671,0.2394,0.0034,0.0022,1.0618,1.4024,8.3428,0.0002,0.0054,0.0158,0.0165,0.0639,0.1545,0.0034]
["Legumes",0.3314,1.0058662184849465,0.1949,1.2505,{"$nulls":4},36.9402,2.8093,0.2075,136.4589,4.9139,69.846,1.7561,38.1414,0.7349,111.2914,308.8805,0.075,210.3162,0.1369,0.1082,0.1326,1.5711,0.6893,7.382,1.2372,13.6855,1.9758,27.4938,69.8117,42.9749,9.3853,0.0152,0.4681,1E-4,0.0006,0.1565,0.6301,30.1668,1.8E-3,0.0024,3.3E-3,0.4263,1.4E-3,0.0347,1E-4]
["Nuts and seeds",0.5244,0.9060781894613129,0.0854,0.2241,{"$nulls":4},65.6867,0,0.8286,537.2384,6.3593,78.3262,3.0911,190.1516,8.9044,414.2636,599.0935,0.1644,389.3302,0.2362,0,0.3638,0.6798,7.5892,1.3978,3.3967,122.7602,1.4117,85.4808,81.3933,409.2045,66.8827,0.0311,0,0.0158,0,6.5337,28.8906,10.5085,0,0,0,0,0,0,0.0158]
["Whole grain breads",0.2582,0.37395817391231423,0.0081,0.4983,{"$nulls":4},66.5763,4.5258,0.2497,270.7375,6.2234,90.7663,3.1012,75.6644,3.8114,199.2337,288.4822,0.2461,445.9476,0.2916,0.0534,0.2328,0.0919,0.6255,4.2555,1.5091,17.9992,1.9366,36.1081,197.4896,47.9046,8.744,3.2593,0,1.8E-3,0,0,2.4517,32.9728,2.4779,0,0,0,0,0,1.8E-3]
["Non-whole grain breads",0.2342,0.7155331109142731,0.8328,0.0088,{"$nulls":4},120.6393,6.6187,0.1807,276.6318,2.9968,147.7179,3.0527,29.2098,3.6307,154.4993,130.3339,0.295,517.0706,0.3823,0.1089,0.0953,0.0647,0.3535,12.5602,0.7695,14.6419,1.2921,32.0607,195.3891,48.5264,10.241,3.5358,0.0003,0.0048,0.0021,0.0141,1.3866,33.9962,0.104,0,0,0.0004,1E-4,1E-4,0.0048]
["Non-whole grain cereals",0.1562,0,0.2521,0.0013,{"$nulls":4},88.2898,1.9885,0.0757,240.0223,2.1046,454.431,11.4324,21.151,9.728,80.7115,93.2896,0.842,379.5783,0.7442,2.6877,0.9924,12.9426,0.4522,260.7912,2.9322,4.7543,0.308,15.4049,210.2688,21.2396,6.6578,1.6636,0,0.0017,0.0117,0.0081,0.1952,67.2451,0.0887,0,0,0,0,0,0.0017]
["Whole grain low calorie cereals",0.2085,0.9865020785105405,0.561,0.1464,{"$nulls":4},97.1194,1.5693,0.1053,152.3942,3.5897,222.5019,6.3043,54.3051,3.8033,158.6131,160.4739,0.3453,182.0401,0.3398,1.0457,0.4388,4.3392,0.2176,110.9235,2.9935,6.4337,0.3381,21.7421,117.155,21.6554,5.753,1.5265,0,0.0004,0,0,0.0114,3.2844,0.928,0,0,0,0,0,0.0004]
["Whole grain cereals",0.354,0,0.1744,0.0024,{"$nulls":4},110.2426,1.4547,0.157,217.8779,4.4575,348.281,9.7954,57.0972,7.9248,180,197.5481,0.6954,247.0271,0.6207,2.1664,0.8509,6.1968,1.3479,231.1449,4.5059,9.3807,0.6033,21.7218,175.9338,32.6255,8.1514,1.4941,0,0.021,0,0.0298,0.341,60.8466,1.1386,0,0,0,0,0,0.021]
["Whole grain rice and pasta",0.0784,1.5154179381778308,0.0145,2.1809,{"$nulls":4},9.8101,0,0.0997,112.5155,1.7865,5.0447,0.4274,41.964,1.4999,81.9946,45.5256,0.033,6.5876,0.0962,0,0.1385,0,0.0847,0.4403,0.66,4.1884,0.2627,10.4926,90.4625,11.0496,1.9825,1.0431,0,0,0,0,0,1.5808,1.0431,0,0,0,0,0,0]
["Non-whole grain rice and pasta",0.0559,0,0.2961,0.692,{"$nulls":4},10.626,2.5245,0.0746,135.5989,0.6727,96.5371,1.1787,12.6515,1.3891,43.6596,32.2668,0.0354,15.3964,0.1574,0.0072,0.0654,0.0254,0.1785,3.5345,0.4618,4.6805,0.4934,12.0544,105.9125,14.61,3.0666,1.2638,0.0009,0,0.0025,0,0.3905,4.8982,0.0032,0,0,0,0,0.0009,0]
["Whole grain cakes and pies",0.4702,0,0.0078,0,{"$nulls":4},43.2674,32.6404,0.1794,371.9551,1.8559,61.3725,2.645,30.1255,2.5387,134.5639,143.3762,0.2689,415.1323,0.2216,0.1454,0.1888,0.4663,0.8338,105.7582,0.8453,27.2123,2.5071,32.1372,211.2492,131.4725,48.7384,1.6602,0,0.0319,0.0382,0.0282,0.2412,201.1159,0.9492,0,0,0,0,0,0.0319]
["Non-whole grain cakes and pies",0.2735,0,0.4858,1.5E-3,{"$nulls":4},55.7975,26.1997,0.1537,373.0752,1.6417,76.371,2.1302,22.9603,2.0744,103.3189,121.439,0.2215,290.3495,0.2099,0.2066,0.0939,1.72,0.8476,67.0996,0.6364,33.0436,2.685,19.0435,218.9977,142.5803,35.425,1.754,0.0051,0.0486,7.6E-3,0.0881,1.3132,210.1939,0.0319,0,0.0048,1E-4,0.0003,0,0.0486]
["Whole grain snacks",0.4952,0,0.0238,0.0012,{"$nulls":4},24.6731,7.0463,0.2477,477.6473,8.7031,33.8026,2.5921,92.4988,2.2465,218.1698,208.4315,0.1487,683.8156,0.1813,0.0085,0.1587,0.1458,2.9802,25.8863,2.196,70.5648,4.235,34.0126,250.8534,206.2019,49.0679,2.8989,0.0249,0,0.006,0.0661,12.809,95.8146,2.6839,0,0,0,0.0249,0,0]
["Non-whole grain snacks",0.5356,0,0.0503,0.4578,{"$nulls":4},107.341,1.4417,0.1549,486.8107,3.7861,117.4289,2.9911,50.2077,3.1834,167.7209,174.4437,0.3209,877.8997,0.2787,0.0747,0.1906,0.2048,2.301,7.2891,1.0634,42.8637,3.0321,31.9164,253.8584,207.0143,39.1363,4.5353,0.0011,0,0.0434,0.0575,15.6353,45.3863,0.0229,0,0,0,0.0006,0.0005,0]
["Grain mixtures",0.3267,2.5506246721389168E-8,0.2869,0.003,{"$nulls":4},130.6901,25.5995,0.1167,236.8619,1.5965,70.471,1.8172,22.1886,2.2074,151.1351,176.2098,0.203,316.7928,0.2044,0.3844,0.1094,3.7223,0.6149,39.6549,1.3402,12.9526,1.3094,39.8989,97.3665,98.8923,38.0941,1.4909,0.1694,0.0012,0.337,0.3915,0.9051,68.7232,1E-4,0.0002,0.0006,0.014,0.0024,0.166,0.0012]
["Low fat grain mixtures",0.13,0,0.3747,3.8E-3,{"$nulls":4},18.2615,7.3579,0.0751,90.483,0.8739,41.137,0.9153,11.4196,1.1511,41.9906,101.7856,0.0651,224.172,0.0914,0.0938,0.0571,2.1164,0.4543,13.9931,0.4227,5.2745,0.4131,13.3683,52.8631,23.9712,7.291,0.5962,0.1154,1E-4,0.017,0.1906,0.3435,15.2648,2.8E-3,1.4E-3,1.4E-3,0.0124,0.0012,0.1115,1E-4]
["Citrus, melon and berry juice",0.2256,0,0.6712,0.0204,{"$nulls":4},8.8003,0.0011,0.0575,42.421,0.2005,21.9364,0.3642,10.9617,0.2914,14.147,175.2525,0.0269,2.0995,0.0614,0.0002,0.0765,34.4845,0.2024,8.365,0.0736,0.2682,0.0994,2.3815,39.9358,1.2106,0.1571,0,0,0.4011,1E-4,0,0,0.4535,0,0,0,0,0,0,0]
["Citrus, melon and berries",0.2373,0.18854229603756453,0.4807,0.011,{"$nulls":4},15.5932,0,0.0399,36.477,1.1701,14.4698,0.2098,10.2219,0.3241,12.7604,162.5212,0.0243,4.4463,0.0464,0,0.0538,28.1418,0.1098,45.7783,0.109,0.3697,0.1613,2.9211,36.601,1.4453,0.2146,1E-4,0,0.6049,1E-4,0,0.0002,1.0006,0,0,0,0,0,0,0.6049]
["Other fruit juice",0.1545,2.0826429325904527,0.3835,0.2796,{"$nulls":4},9.2126,0,0.0328,50.9694,0.1861,4.4171,0.3207,6.0481,0.1836,8.8964,125.0669,0.0251,2.8013,0.0277,0,0.0487,12.6865,0.0682,1.4311,0.0484,0.2432,0.0904,1.0508,50.4639,0.9334,0.1918,0,1E-4,0.3992,0,0,1E-4,1.9771,0,0,1E-4,0,0,0,0]
["Other fruits",0.2161,1.4214069120207302,0.9664,2.7122,{"$nulls":4},8.1269,0.0197,0.0782,75.9397,2.3401,10.6579,0.2719,13.8385,0.45,18.9775,222.8567,0.0511,2.4841,0.0325,1E-4,0.1508,8.3242,0.3146,6.8351,0.1214,1.0222,0.1807,3.0107,73.8735,7.0799,1.3162,0.0003,0.0002,0.72,0.0006,0.0008,0.0259,4.8032,0,0,0,0,0,1E-4,0.72]
["Potatoes",0.1669,0,0.2976,0.971,{"$nulls":4},17.0227,3.1914,0.1921,305.1389,3.154,14.9447,0.9108,36.9128,2.5079,107.2531,663.0523,0.0638,209.3449,0.1118,0.0103,0.3812,14.2959,2.1735,2.6235,0.5174,36.9539,2.1324,16.0547,142.3289,151.0136,36.1776,0.0084,0.7914,0,0.0047,0.0147,7.0681,75.1095,2E-3,0,0,0,0.7725,0.0188,0]
["Low fat potatoes",0.1033,2.461419478322215,0.5457,0.0059,{"$nulls":4},23.7472,2.9983,0.1295,98.6292,1.5543,10.5161,0.4037,19.3646,1.1302,52.288,323.464,0.0438,73.7422,0.0942,0.0469,0.2319,8.7679,0.1604,24.0174,0.306,4.4614,0.5315,8.6759,69.0133,22.8692,8.09,0.0073,0.592,0,0.0525,0.0136,0.0584,17.9655,0,0,0,0,0.5891,0.0029,0]
["Dark green vegetables",0.4515,3.9678517195652776,0.0885,1.4E-3,{"$nulls":4},108.8516,1.8555,0.1188,46.3764,2.8831,86.884,1.0564,24.2949,0.5292,43.2283,214.8093,0.0958,54.2708,0.0514,0.0121,0.1461,29.4995,1.5881,330.7707,0.3034,3.794,1.0894,9.4744,20.1086,22.3058,6.4472,0.0127,0.6172,0,0.0132,0,0,18.0769,0,0.6161,0,0,0,0.0011,0]
["Orange vegetables",0.1688,0,0.0551,0.0011,{"$nulls":4},28.6178,2.2229,0.0681,94.1599,2.6519,10.619,0.5733,12.6219,0.5861,31.2168,236.9035,0.049,75.0558,0.0519,0.0113,0.125,6.6501,1.1235,656.2516,0.2081,9.2196,1.0384,3.8574,62.2358,30.9017,8.1675,0,0.5619,0.0153,0.006,1.5E-3,0.7022,38.0595,0,0,0.5619,0,0,0,0.0153]
["Dark green vegetables, no fat",0.3155,0.04899870589489717,0.0413,0.5647,{"$nulls":4},64.1576,0,0.0721,28.5702,2.9173,86.2391,1.0175,27.3981,0.5166,53.2593,262.5123,0.1125,32.4734,0.0634,0,0.1519,44.9615,1.3133,169.3681,0.3956,0.2958,0.6312,10.5137,21.9638,2.5309,0.4159,0,0.7745,0,0,0,0,0,0,0.7745,0,0,0,0,0]
["Orange vegetables, no fat",0.1969,2.0191741848846245,0.0593,0.3595,{"$nulls":4},31.4285,1.4E-3,0.0606,46.5219,2.8497,15.846,0.4097,13.7228,0.904,35.8335,324.9471,0.0628,57.8701,0.0686,0.0002,0.1599,7.8608,0.7164,653.4229,0.2409,0.8653,0.13,4.1375,43.2367,2.1092,0.3659,0,0.6823,0,1E-4,0,0,0.1607,0,0,0.6823,0,0,0,0]
["Other vegetables",0.2466,0,0.2438,0.0039,{"$nulls":4},38.6516,1.6097,0.0784,75.8819,2.3307,35.5303,0.7148,20.6424,0.7609,47.9788,195.6622,0.0905,97.8595,0.0782,0.0235,0.093,12.3373,0.4123,38.1429,0.3838,8.0907,1.1471,9.2849,42.9631,29.6108,7.4354,0.0204,0.5675,0.0145,0.0301,1E-4,0.3475,18.8532,0,0.011,0,0,0.1799,0.3765,0.0145]
["Tomatoes",0.1609,0,0.0324,0.3397,{"$nulls":4},34.7197,1.9111,0.1084,57.8858,1.057,10.2826,0.7501,13.3087,0.8762,41.0288,250.1085,0.0671,376.7509,0.0495,0.0627,0.0927,13.9916,1.5441,41.3692,0.2325,5.2747,0.5253,7.0811,34.5482,17.9552,4.3951,0.0726,0.573,0,0.0668,0.0094,0.0738,13.9515,0,0,0.0047,0.0005,4.3E-3,0.5645,0]
["Other vegetables, no fat",0.1753,1.0669171932629085,0.5696,0.2035,{"$nulls":4},20.6201,1.6208,0.0578,41.741,1.5476,36.4832,0.5888,14.6587,0.5734,38.8392,189.0055,0.0536,114.8776,0.057,0.0352,0.0894,11.3729,0.1485,30.5997,0.4065,1.3863,0.3019,7.878,30.5866,7.464,2.1408,0.0044,0.6477,0.0113,0,0.0435,0.0222,3.1671,0.0008,0.0114,0.0065,0.0007,0.1383,0.4916,0.0113]
["Tomatoes, no fat",0.2217,0.830879628269466,0.1886,0.8357,{"$nulls":4},10.6058,0.4564,0.0688,21.8295,1.0497,14.8765,0.3434,10.3741,0.6177,23.4407,218.8248,0.0229,73.7465,0.0407,0.0075,0.0796,13.3719,0.5542,39.5385,0.178,1.3433,0.1232,3.8829,17.6198,3.0632,0.6868,0.0221,0.5083,1E-4,0.0017,0.0074,0.0025,0.9775,1E-4,1E-4,0.0016,0.0002,0.0016,0.5051,1E-4]
["Mixed vegetables",0.3779,0,0.1803,0.3368,{"$nulls":4},48.3443,12.4,0.0604,113.8409,1.8584,25.2053,0.6971,14.3688,0.6711,54.2827,205.4157,0.0794,109.5667,0.0651,0.0559,0.1249,16.9187,0.9372,134.9056,0.3605,26.6431,3.1358,9.7884,39.8273,68.831,14.2853,0.0927,0.6535,0.0047,0.0683,0.0651,5.9045,24.6008,0.016,0.0151,0.099,0.0012,0.0741,0.4652,0.0047]
["Mixed vegetables, no fat",0.3521,0,0.0249,0.0003,{"$nulls":4},18.6958,0.4975,0.081,53.3892,2.3394,22.883,0.7605,14.5809,0.8538,42.8003,195.1259,0.0608,142.7405,0.0857,0.0119,0.1082,12.2089,0.3928,134.2785,0.4521,1.1833,0.2209,9.5527,39.4192,7.8385,2.3933,0.0924,0.5832,0,0,0.0185,0.3994,1.9178,0,0.031,0.1113,0,0.2707,0.1701,0]
["Fats and oils",0.2055,0,0.3414,0.3401,{"$nulls":4},27.0141,11.8849,0.0912,224.4083,0.8274,8.2173,0.5714,11.0177,0.6248,34.0069,160.0783,0.1125,742.7267,0.0424,0.0763,0.0965,6.8435,2.0971,93.1411,0.2688,67.125,8.7362,6.8527,39.8079,184.6661,40.4767,0.0883,0.2555,0.0012,0.0325,0.0413,15.2235,52.4779,0,0.0004,0,0,0,0.2551,0.0012]
["Coffee",0.0204,0,6.0336,0.6335,{"$nulls":4},1.3482,0.0256,5.3E-3,6.9033,1.8E-3,2.5679,0.0188,2.5716,0.033,2.4357,40.2211,0.0295,2.0724,0.0005,1E-3,0.0008,1E-3,0.0102,0.0881,0.0147,0.0078,0.0017,0.3663,4.915,3.4807,0.0606,0.0005,0,0,0.0011,0,0.0002,4.0852,0.0002,0,0,0,0,0,0]
["Soft drinks",0.0668,0,2.2245,0.0069,{"$nulls":4},4.9007,0.0097,0.0119,41.7277,0.0119,0.424,0.0528,1.2733,0.017,6.6893,5.7352,0.0032,8.2576,0.0044,0.0016,0.0034,3.4793,0.0054,0.8218,0.0243,0.0103,0.0045,0.1428,42.807,0.0734,0.0293,0.0004,0,0.0137,1E-4,1E-3,0.0006,39.3343,0,0,0,0,0,0,0.0137]
["Low calorie soft drinks",0.1341,0,0.5221,0.0036,{"$nulls":4},3.6399,0,0.0131,5.8772,0.0064,0.2697,0.0353,1.2693,0.0233,8.6792,7.8581,0.015,10.4531,0.0085,0.0004,1.9E-3,2.0799,0.0164,0.037,0.0197,0.0087,1.8E-3,0.342,5.3886,0.0211,0.0035,0.0006,0,0.0111,0,0,0,2.6603,0,0,0,0,0,0,0.0111]
["Sugars",0.4108,0,0.199,0.0007,{"$nulls":4},30.7712,2.3339,0.1133,318.5985,0.9453,6.2918,0.501,17.0975,0.4142,45.6826,116.075,0.0596,69.7042,0.026,0.0741,0.0267,3.8191,0.4195,6.6689,0.4651,4.693,0.1816,7.5823,266.6488,55.7747,25.4751,0.1422,1E-4,0.036,0.0539,0.1592,3.1825,225.3176,0.0058,0,0,0,0,0,0.036]
["Lower Limit",{"$nulls":8},1200,0,0.9,2200,30.8,400,8,420,16,700,4700,1.3,0,1.2,2.4,1.7,90,15,900,11,{"$f":"0.05*M60","v":110},{"$f":"0.006*M60","v":13.200000000000001},{"$f":"0.1*M60","v":220},{"$f":"0.45*M60","v":990},{"$f":"0.2*M60","v":440},0,7,3,2,0,6,29,0,3.5,0.43,0.29,0.43,0.86,1,1]
["Upper Limit",{"$nulls":8},2500,299.99,10,2200,10000000000,1000,45,10000000000,35,3000,10000000000,10000000000,2460,10000000000,10000000000,100,2000,1000,3000,40,{"$f":"0.1*M61","v":220},{"$f":"0.012*M61","v":26.400000000000002},{"$f":"0.35*M61","v":770},{"$f":"0.65*M61","v":1430},{"$f":"0.35*M61","v":770},{"$f":"0.1*M61","v":220},10000000000,10000000000,10000000000,1,10000000000,10000000000,290,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
["Sum of Constraints",{"$nulls":8},{"$f":"SUMPRODUCT($C$2:$C$59,J2:J59)","v":1200.0000016800298},{"$f":"SUMPRODUCT($C$2:$C$59,K2:K59)","v":62.44784941026555},2.693145371705831,2199.999998744569,49.11209256478109,1000.0000074857489,23.231917896535375,623.1375595999211,28.695296049121723,1663.1836482806445,4699.999996046233,1.930064946665122,2460.0000009770624,2.0284615654402294,2.4000000361269933,3.2903279752060466,230.382022036578,18.002775036699376,2999.9999904062447,14.035783488721455,190.03460546027983,13.37678434831823,310.60907681525276,1223.7232185046998,770.000002848035,197.25221696844508,6.999999922628163,6.926036143761873,1.9999999895145133,1.0000000022927107,6.4461585393111696,29.000000013638207,290.00000109122027,3.4999999637567454,2.49850398254523,1.3894745383377827,0.4300000005025238,1.609267648827815,0.9999999845811882,1.1686089308244045]
[{"$nulls":29},{"$f":"0.05*M60","v":110},{"$f":"0.006*M60","v":13.200000000000001},{"$f":"0.1*M60","v":220},{"$f":"0.45*M60","v":990},{"$f":"0.2*M60","v":440},0]
[{"$nulls":29},{"$f":"0.1*M61","v":220},{"$f":"0.012*M61","v":26.400000000000002},{"$f":"0.35*M61","v":770},{"$f":"0.65*M61","v":1430},{"$f":"0.35*M61","v":770},{"$f":"0.1*M61","v":220}]

{"sheet":"Female","index":1,"n_rows":64,"n_cols":49,"rows_kept":64}
["Food Group","Cost","Solution","Cur.Consumption","TFP",{"$nulls":4},"Calcium","Cholesterol","Copper","Energy","Fiber","Folate","Iron","Magnesium","Niacin","Phosphorus","Potassium","Riboflavin","Sodium","Thiamin","Vitamin B12","Vitamin B6","Vitamin C","Vitamin E","Vitamin A","Zinc","Calories from linoleic acid","Calories from linolenic acid","Calories from protein","Calories from carbohydrates","calories from fat","Calories from saturated fat","Servings of grains","Servings of vegetables","Servings of fruit","Servings of dairy","Servings of meat/protein","Servings of fats and oils","SOFASUG_tot_kcal","Servings of whole grains","Servings of dark green vegetables","Servings of orange vegetables","Servings of legumes (vegetables)","V_STARCY_py","V_OTHER_py","Servings of whole fruit"]
["Milk",0.1034,0,0.6435,0.0044,{"$nulls":4},112.2304,11.6225,0.0112,70.1136,0.0032,5.0504,0.0429,9.9512,0.1098,93.1717,148.1604,0.1781,45.8517,0.0396,0.4288,0.0393,0.0532,0.0859,33.4926,0.4024,1.1927,0.6953,12.9883,20.5465,37.0888,22.0016,0.0003,0.0003,0.0002,0.3876,0,0.0032,33.1552,0,0,0,0,0,0.0003,0.0002]
["Low fat milk",0.0744,0,1.5957,7.344,{"$nulls":4},120.6931,6.1955,0.0123,47.7256,0.0017,5.1965,0.0327,11.1977,0.0912,96.825,153.6514,0.1801,42.9963,0.0368,0.469,0.04,0.1888,0.0233,53.6463,0.4417,0.3874,0.0773,13.5277,21.359,12.7238,8.2258,0,0,1.5E-3,0.4096,0,0,12.0719,0,0,0,0,0,0,1.5E-3]
["Cheese",0.5262,0.47058594926831393,0.1208,0.0008,{"$nulls":4},572.3382,70.9176,0.052,307.1513,0.0273,12.1394,0.502,26.0082,0.1631,468.7814,172.9857,0.3899,916.1922,0.0507,1.0942,0.0774,0.0892,0.2328,182.9759,2.7631,5.0096,1.9392,83.6314,19.9061,203.3664,125.3811,0.0234,2.3E-3,0.0002,1.8263,0.0048,1.4E-3,169.3818,0,0,0,0,0,2.3E-3,0.0002]
["Milk-based desserts",0.2336,0,0.4735,0.0021,null,"Cost",null,null,115.7822,20.8786,0.0614,131.4621,0.5792,8.9646,0.3279,15.716,0.322,98.881,174.2701,0.1904,64.5188,0.0503,0.3656,0.0631,1.4684,0.2454,72.1126,0.59,2.1829,0.7913,13.4574,68.4917,52.6878,31.3595,0.073,1E-4,0.0017,0.2988,0.0172,0.1578,82.9507,0.0017,0,0,0,1E-4,0,0.0017]
["Low fat milk-based desserts",0.1416,0,0.3701,0.0034,null,{"$f":"SUMPRODUCT(B2:B59,C2:C59)","v":5.523214894458499},null,null,107.327,5.0786,0.1186,92.5672,0.6289,15.8981,0.8132,23.1862,0.7716,101.274,184.1635,0.1761,51.5694,0.0896,0.4009,0.0948,2.6533,0.5649,69.1878,0.8136,1.7106,0.2405,14.7206,63.3205,15.7893,8.1903,0.0545,0,0.0125,0.3366,0.0207,0.3059,40.5543,0,0,0,0,0,0,0.0125]
["Low cost red meat",0.5593,0,0.056,0.0005,{"$nulls":4},24.0837,89.1727,0.0795,277.6817,0.0064,9.7468,2.3793,19.5847,4.6971,187.1774,288.1673,0.1796,101.6397,0.0642,2.6354,0.3408,0.0244,0.4284,0.0328,5.9645,4.1191,0.7255,100.4131,0.4328,170.0344,66.0955,0.0067,0,0,0,3.1412,1E-3,81.1779,0,0,0,0,0,0,0]
["Regular cost red meat",0.8297,0,0.0561,0.0004,{"$nulls":4},17.3745,88.071,0.1159,322.9094,0.1306,12.2424,2.1785,26.3678,5.0938,258.6983,383.8068,0.251,518.8183,0.2909,1.8194,0.3419,0.1798,0.2587,3.257,4.3559,14.0795,1.5814,117.2095,7.2168,190.3331,69.4073,0.0805,0.0002,0,0.0016,2.9136,0.299,105.8551,1.5E-3,0,0,0,0,0.0002,0]
["Low cost lean red meat",0.4809,0,0.0635,0.2974,{"$nulls":4},18.0753,74.6431,0.3359,177.4522,0.14,11.0227,1.7841,21.3961,5.5925,232.4955,339.3808,0.3591,890.9991,0.5854,2.0208,0.3799,0.1731,0.3997,110.394,2.839,9.4354,1.3158,94.4393,9.1342,67.562,21.4389,0.1482,0.0003,0,0.0002,3.3167,0.7632,6.073,0,0,0,0,0,0.0003,0]
["Regular cost lean red meat",1.1361,0,0.1,0.0016,{"$nulls":4},13.2267,84.3457,0.1138,212.9754,0.0436,9.2999,2.43,28.1463,5.15,237.8619,407.535,0.2883,76.709,0.3389,2.1103,0.4505,0.1747,0.2178,1.1219,4.9137,6.3086,0.5453,118.0961,2.9773,83.6758,30.1982,0.0547,0,0,0.0005,3.4221,0.2807,12.3772,0,0,0,0,0,0,0]
["Low cost fish",0.5266,0,0.0093,1E-4,{"$nulls":4},53.4446,81.5141,0.2671,215.3945,0.4911,26.1411,1.0253,31.3632,2.4961,203.0637,284.7383,0.1684,209.9722,0.2121,2.307,0.152,0.6834,1.0698,32.3709,1.9245,24.4115,2.3029,63.8021,38.5775,109.0903,24.5519,0.6325,0.0026,0.0005,0.0408,2.3592,0.3567,60.9452,0,1E-4,0,0,0,0.0024,0.0005]
["Regular cost fish",1.0932,0,0.1104,0.0017,{"$nulls":4},49.4897,93.3441,0.1257,211.9115,0.3161,21.4527,1.5057,35.6351,3.7737,258.808,339.0319,0.1287,135.5937,0.178,1.9917,0.2202,1.6195,1.2239,45.5877,1.0215,25.1313,2.7868,81.9514,26.2712,99.0356,19.8823,0.4767,0,5.3E-3,6.6E-3,2.7932,0.1958,54.5076,0,0,0,0,0,0,5.3E-3]
["Low cost lean fish",0.3175,0.5511389227835958,0.0169,0.2979,{"$nulls":4},37.7452,19.3773,0.0642,81.6539,0.3163,8.1019,0.9318,17.5009,4.7686,106.7091,187.9012,0.0767,313.3051,0.0346,2.7059,0.1544,1.5832,0.3701,20.4546,0.4818,2.8652,0.2708,47.3239,13.2731,18.6661,5.7383,0.1087,0.1057,0,0.0295,1.5525,0.3553,7.1723,0,0.0075,0,0,0.0512,0.0472,0]
["Regular cost lean fish",1.1615,0,0.007,0.0002,{"$nulls":4},72.2908,119.6683,0.3232,130.6316,0.0037,16.7908,1.702,42.469,4.4968,248.5298,306.155,0.0996,422.9651,0.0734,2.7232,0.1764,1.3424,1.4276,35.6848,1.8099,2.5628,0.4321,92.4148,1.8309,30.3453,6.0189,0.0042,0,1.9E-3,0,3.4655,0.211,2.584,0,0,0,0,0,0,1.9E-3]
["Low cost poultry",0.3734,0,0.0394,0.0004,{"$nulls":4},17.3969,99.0715,0.0904,261.7297,0.2362,32.8638,1.6879,21.1238,5.6296,160.1089,205.6844,0.2494,78.1879,0.1131,0.5101,0.2809,0.2639,0.5319,77.5954,2.255,33.8417,2.4896,91.6275,27.6155,136.4729,32.2643,0.5527,0,0,0.006,2.6658,0,63.6891,0,0,0,0,0,0,0]
["Regular cost poultry",0.5553,0,0.0449,0.0004,{"$nulls":4},17.169,85.0203,0.0732,265.8504,0.1953,18.2635,1.4034,21.9856,7.647,167.202,207.8478,0.1731,88.4931,0.0996,0.2818,0.3904,0.0092,0.4925,33.673,1.6643,31.9977,2.3403,99.0222,22.5105,138.1526,33.8245,0.4499,0,1E-4,0.0048,2.7356,0.0092,70.6024,0,0,0,0,0,0,1E-4]
["Low cost lean poultry",0.3806,0,0.0143,0.5348,{"$nulls":4},15.6286,135.6944,0.1155,161.0636,0.2054,32.3382,2.0058,18.9787,4.8115,171.1657,243.0852,0.2695,117.8785,0.0684,1.0799,0.304,2.47,0.2923,188.1466,2.7944,10.8328,0.5293,92.6293,6.4751,57.0522,16.0251,0.0002,0.1041,0,0,2.9124,0,0.8109,0,0,0.0131,0,0.0779,0.0131,0]
["Regular cost lean poultry",0.6456,0,0.1216,0.0035,{"$nulls":4},14.6358,75.6103,0.0631,227.7658,0,19.3711,1.0955,24.2924,8.2116,222.906,256.6082,0.1519,231.9552,0.0806,0.3024,0.3877,0,0.6583,10.8212,1.627,16.2394,1.0699,97.6919,21.9911,102.9849,25.0005,0.4212,0,0,0,2.978,6.0911,5.6097,0,0,0,0,0,0,0]
["Lunch meat",0.4201,0,0.0799,0.0003,{"$nulls":4},24.5786,66.2366,0.1168,325.6126,0.3196,4.3757,1.4886,14.6202,3.5071,144.8117,217.7679,0.1899,1016.0999,0.2107,1.5936,0.2032,0.6754,0.2945,41.0744,2.4235,18.9721,1.7639,58.7055,11.0183,252.2971,92.8475,1E-4,0,0,1.4E-3,2.7979,0.1745,167.7553,0,0,0,0,0,0,0]
["Low fat lunch meat",0.8032,0,0.0952,0.0017,{"$nulls":4},21.2759,53.8556,0.0808,166.5285,0.0441,4.7461,1.2619,17.6215,4.5975,195.9795,278.4997,0.2114,1059.4191,0.4635,0.6684,0.3077,0.2951,0.2356,5.2069,2.0045,10.1961,0.9072,72.6507,12.0374,78.0892,24.9336,0,0,0,0,3.4751,1E-3,14.8746,0,0,0,0,0,0,0]
["Eggs",0.1906,0,0.2561,0.0031,{"$nulls":4},72.7591,337.958,0.0795,177.9579,0.0646,32.1475,1.5227,12.6724,0.3793,185.1287,153.2592,0.4145,240.0405,0.0836,0.9718,0.1301,0.359,1.1156,137.844,1.1161,20.0706,1.3143,47.6151,10.4129,116.9229,36.1512,0.0632,0.012,0.0002,0.0968,1.7279,0.589,60.3887,0,0,0,0,0.003,0.009,0.0002]
["Meat mixtures",0.3607,0,0.4014,3.8E-3,{"$nulls":4},72.6623,41.0489,0.1049,226.012,0.9037,46.2964,1.7411,18.8141,3.3524,129.955,206.1031,0.1862,391.5984,0.1379,0.8161,0.1824,2.4829,0.562,27.8161,2.0249,17.0683,1.8839,51.7459,62.687,109.5765,37.1658,1.0288,0.1478,0.0013,0.0839,1.1879,2.1041,59.2402,2.3E-3,0.0034,0.0041,0.0002,0.0151,0.1252,0.0013]
["Low fat meat mixtures",1.3504,0,0.5428,0.008,{"$nulls":4},20.9429,25.8492,0.1042,111.1427,1.1405,19.2453,1.1718,17.2409,2.6375,87.6274,225.9219,0.1006,260.0567,0.0837,0.5576,0.1679,5.3845,0.6345,31.7522,1.3147,8.7774,0.9385,37.1708,33.2556,40.1852,10.8482,0.1671,0.2394,0.0034,0.0022,1.0618,1.4024,8.3428,0.0002,0.0054,0.0158,0.0165,0.0639,0.1545,0.0034]
["Legumes",0.1192,1.0071234876477742,0.2198,1.1002,{"$nulls":4},36.9402,2.8093,0.2075,136.4589,4.9139,69.846,1.7561,38.1414,0.7349,111.2914,308.8805,0.075,210.3162,0.1369,0.1082,0.1326,1.5711,0.6893,7.382,1.2372,13.6855,1.9758,27.4938,69.8117,42.9749,9.3853,0.0152,0.4681,1E-4,0.0006,0.1565,0.6301,30.1668,1.8E-3,0.0024,3.3E-3,0.4263,1.4E-3,0.0347,1E-4]
["Nuts and seeds",0.4353,0.7845987542449202,0.024,0.2768,{"$nulls":4},65.6867,0,0.8286,537.2384,6.3593,78.3262,3.0911,190.1516,8.9044,414.2636,599.0935,0.1644,389.3302,0.2362,0,0.3638,0.6798,7.5892,1.3978,3.3967,122.7602,1.4117,85.4808,81.3933,409.2045,66.8827,0.0311,0,0.0158,0,6.5337,28.8906,10.5085,0,0,0,0,0,0,0.0158]
["Whole grain breads",0.2286,0,0.01,0.2856,{"$nulls":4},66.5763,4.5258,0.2497,270.7375,6.2234,90.7663,3.1012,75.6644,3.8114,199.2337,288.4822,0.2461,445.9476,0.2916,0.0534,0.2328,0.0919,0.6255,4.2555,1.5091,17.9992,1.9366,36.1081,197.4896,47.9046,8.744,3.2593,0,1.8E-3,0,0,2.4517,32.9728,2.4779,0,0,0,0,0,1.8E-3]
["Non-whole grain breads",0.241,0.10018213626240167,0.898,0.0144,{"$nulls":4},120.6393,6.6187,0.1807,276.6318,2.9968,147.7179,3.0527,29.2098,3.6307,154.4993,130.3339,0.295,517.0706,0.3823,0.1089,0.0953,0.0647,0.3535,12.5602,0.7695,14.6419,1.2921,32.0607,195.3891,48.5264,10.241,3.5358,0.0003,0.0048,0.0021,0.0141,1.3866,33.9962,0.104,0,0,0.0004,1E-4,1E-4,0.0048]
["Non-whole grain cereals",0.2109,0,0.3089,0.0016,{"$nulls":4},88.2898,1.9885,0.0757,240.0223,2.1046,454.431,11.4324,21.151,9.728,80.7115,93.2896,0.842,379.5783,0.7442,2.6877,0.9924,12.9426,0.4522,260.7912,2.9322,4.7543,0.308,15.4049,210.2688,21.2396,6.6578,1.6636,0,0.0017,0.0117,0.0081,0.1952,67.2451,0.0887,0,0,0,0,0,0.0017]
["Whole grain low calorie cereals",0.1584,0.14426041457582595,0.2106,0.147,{"$nulls":4},97.1194,1.5693,0.1053,152.3942,3.5897,222.5019,6.3043,54.3051,3.8033,158.6131,160.4739,0.3453,182.0401,0.3398,1.0457,0.4388,4.3392,0.2176,110.9235,2.9935,6.4337,0.3381,21.7421,117.155,21.6554,5.753,1.5265,0,0.0004,0,0,0.0114,3.2844,0.928,0,0,0,0,0,0.0004]
["Whole grain cereals",0.3625,0,0.1107,0.0013,{"$nulls":4},110.2426,1.4547,0.157,217.8779,4.4575,348.281,9.7954,57.0972,7.9248,180,197.5481,0.6954,247.0271,0.6207,2.1664,0.8509,6.1968,1.3479,231.1449,4.5059,9.3807,0.6033,21.7218,175.9338,32.6255,8.1514,1.4941,0,0.021,0,0.0298,0.341,60.8466,1.1386,0,0,0,0,0,0.021]
["Whole grain rice and pasta",0.0781,4.928457072716918,0.0136,2.1743,{"$nulls":4},9.8101,0,0.0997,112.5155,1.7865,5.0447,0.4274,41.964,1.4999,81.9946,45.5256,0.033,6.5876,0.0962,0,0.1385,0,0.0847,0.4403,0.66,4.1884,0.2627,10.4926,90.4625,11.0496,1.9825,1.0431,0,0,0,0,0,1.5808,1.0431,0,0,0,0,0,0]
["Non-whole grain rice and pasta",0.0423,0,0.287,0.166,{"$nulls":4},10.626,2.5245,0.0746,135.5989,0.6727,96.5371,1.1787,12.6515,1.3891,43.6596,32.2668,0.0354,15.3964,0.1574,0.0072,0.0654,0.0254,0.1785,3.5345,0.4618,4.6805,0.4934,12.0544,105.9125,14.61,3.0666,1.2638,0.0009,0,0.0025,0,0.3905,4.8982,0.0032,0,0,0,0,0.0009,0]
["Whole grain cakes and pies",0.6455,0,0.0276,1E-4,{"$nulls":4},43.2674,32.6404,0.1794,371.9551,1.8559,61.3725,2.645,30.1255,2.5387,134.5639,143.3762,0.2689,415.1323,0.2216,0.1454,0.1888,0.4663,0.8338,105.7582,0.8453,27.2123,2.5071,32.1372,211.2492,131.4725,48.7384,1.6602,0,0.0319,0.0382,0.0282,0.2412,201.1159,0.9492,0,0,0,0,0,0.0319]
["Non-whole grain cakes and pies",0.2914,0,0.4142,0.0011,{"$nulls":4},55.7975,26.1997,0.1537,373.0752,1.6417,76.371,2.1302,22.9603,2.0744,103.3189,121.439,0.2215,290.3495,0.2099,0.2066,0.0939,1.72,0.8476,67.0996,0.6364,33.0436,2.685,19.0435,218.9977,142.5803,35.425,1.754,0.0051,0.0486,7.6E-3,0.0881,1.3132,210.1939,0.0319,0,0.0048,1E-4,0.0003,0,0.0486]
["Whole grain snacks",0.4697,0,0.0193,0.0004,{"$nulls":4},24.6731,7.0463,0.2477,477.6473,8.7031,33.8026,2.5921,92.4988,2.2465,218.1698,208.4315,0.1487,683.8156,0.1813,0.0085,0.1587,0.1458,2.9802,25.8863,2.196,70.5648,4.235,34.0126,250.8534,206.2019,49.0679,2.8989,0.0249,0,0.006,0.0661,12.809,95.8146,2.6839,0,0,0,0.0249,0,0]
["Non-whole grain snacks",0.4927,0,0.0674,0.5141,{"$nulls":4},107.341,1.4417,0.1549,486.8107,3.7861,117.4289,2.9911,50.2077,3.1834,167.7209,174.4437,0.3209,877.8997,0.2787,0.0747,0.1906,0.2048,2.301,7.2891,1.0634,42.8637,3.0321,31.9164,253.8584,207.0143,39.1363,4.5353,0.0011,0,0.0434,0.0575,15.6353,45.3863,0.0229,0,0,0,0.0006,0.0005,0]
["Grain mixtures",0.2103,0,0.3055,0.0026,{"$nulls":4},130.6901,25.5995,0.1167,236.8619,1.5965,70.471,1.8172,22.1886,2.2074,151.1351,176.2098,0.203,316.7928,0.2044,0.3844,0.1094,3.7223,0.6149,39.6549,1.3402,12.9526,1.3094,39.8989,97.3665,98.8923,38.0941,1.4909,0.1694,0.0012,0.337,0.3915,0.9051,68.7232,1E-4,0.0002,0.0006,0.014,0.0024,0.166,0.0012]
["Low fat grain mixtures",1.1507,0,0.5071,6.6E-3,{"$nulls":4},18.2615,7.3579,0.0751,90.483,0.8739,41.137,0.9153,11.4196,1.1511,41.9906,101.7856,0.0651,224.172,0.0914,0.0938,0.0571,2.1164,0.4543,13.9931,0.4227,5.2745,0.4131,13.3683,52.8631,23.9712,7.291,0.5962,0.1154,1E-4,0.017,0.1906,0.3435,15.2648,2.8E-3,1.4E-3,1.4E-3,0.0124,0.0012,0.1115,1E-4]
["Citrus, melon and berry juice",0.1986,0,0.8807,0.2708,{"$nulls":4},8.8003,0.0011,0.0575,42.421,0.2005,21.9364,0.3642,10.9617,0.2914,14.147,175.2525,0.0269,2.0995,0.0614,0.0002,0.0765,34.4845,0.2024,8.365,0.0736,0.2682,0.0994,2.3815,39.9358,1.2106,0.1571,0,0,0.4011,1E-4,0,0,0.4535,0,0,0,0,0,0,0]
["Citrus, melon and berries",0.2459,2.45801054498658,0.4859,0.0191,{"$nulls":4},15.5932,0,0.0399,36.477,1.1701,14.4698,0.2098,10.2219,0.3241,12.7604,162.5212,0.0243,4.4463,0.0464,0,0.0538,28.1418,0.1098,45.7783,0.109,0.3697,0.1613,2.9211,36.601,1.4453,0.2146,1E-4,0,0.6049,1E-4,0,0.0002,1.0006,0,0,0,0,0,0,0.6049]
["Other fruit juice",0.1435,0,0.2923,0.0292,{"$nulls":4},9.2126,0,0.0328,50.9694,0.1861,4.4171,0.3207,6.0481,0.1836,8.8964,125.0669,0.0251,2.8013,0.0277,0,0.0487,12.6865,0.0682,1.4311,0.0484,0.2432,0.0904,1.0508,50.4639,0.9334,0.1918,0,1E-4,0.3992,0,0,1E-4,1.9771,0,0,1E-4,0,0,0,0]
["Other fruits",0.2172,0,0.8826,1.9729,{"$nulls":4},8.1269,0.0197,0.0782,75.9397,2.3401,10.6579,0.2719,13.8385,0.45,18.9775,222.8567,0.0511,2.4841,0.0325,1E-4,0.1508,8.3242,0.3146,6.8351,0.1214,1.0222,0.1807,3.0107,73.8735,7.0799,1.3162,0.0003,0.0002,0.72,0.0006,0.0008,0.0259,4.8032,0,0,0,0,0,1E-4,0.72]
["Potatoes",0.2293,0,0.1438,0.0032,{"$nulls":4},17.0227,3.1914,0.1921,305.1389,3.154,14.9447,0.9108,36.9128,2.5079,107.2531,663.0523,0.0638,209.3449,0.1118,0.0103,0.3812,14.2959,2.1735,2.6235,0.5174,36.9539,2.1324,16.0547,142.3289,151.0136,36.1776,0.0084,0.7914,0,0.0047,0.0147,7.0681,75.1095,2E-3,0,0,0,0.7725,0.0188,0]
["Low fat potatoes",0.1047,0.38138732895499683,0.3688,0.3461,{"$nulls":4},23.7472,2.9983,0.1295,98.6292,1.5543,10.5161,0.4037,19.3646,1.1302,52.288,323.464,0.0438,73.7422,0.0942,0.0469,0.2319,8.7679,0.1604,24.0174,0.306,4.4614,0.5315,8.6759,69.0133,22.8692,8.09,0.0073,0.592,0,0.0525,0.0136,0.0584,17.9655,0,0,0,0,0.5891,0.0029,0]
["Dark green vegetables",0.3686,1.8694312961392066,0.0892,0.0039,{"$nulls":4},108.8516,1.8555,0.1188,46.3764,2.8831,86.884,1.0564,24.2949,0.5292,43.2283,214.8093,0.0958,54.2708,0.0514,0.0121,0.1461,29.4995,1.5881,330.7707,0.3034,3.794,1.0894,9.4744,20.1086,22.3058,6.4472,0.0127,0.6172,0,0.0132,0,0,18.0769,0,0.6161,0,0,0,0.0011,0]
["Orange vegetables",0.1678,0,0.036,0.0004,{"$nulls":4},28.6178,2.2229,0.0681,94.1599,2.6519,10.619,0.5733,12.6219,0.5861,31.2168,236.9035,0.049,75.0558,0.0519,0.0113,0.125,6.6501,1.1235,656.2516,0.2081,9.2196,1.0384,3.8574,62.2358,30.9017,8.1675,0,0.5619,0.0153,0.006,1.5E-3,0.7022,38.0595,0,0,0.5619,0,0,0,0.0153]
["Dark green vegetables, no fat",0.3621,6.168148913375713,0.0733,2.6543,{"$nulls":4},64.1576,0,0.0721,28.5702,2.9173,86.2391,1.0175,27.3981,0.5166,53.2593,262.5123,0.1125,32.4734,0.0634,0,0.1519,44.9615,1.3133,169.3681,0.3956,0.2958,0.6312,10.5137,21.9638,2.5309,0.4159,0,0.7745,0,0,0,0,0,0,0.7745,0,0,0,0,0]
["Orange vegetables, no fat",0.1868,1.452985844690067,0.0967,0.196,{"$nulls":4},31.4285,1.4E-3,0.0606,46.5219,2.8497,15.846,0.4097,13.7228,0.904,35.8335,324.9471,0.0628,57.8701,0.0686,0.0002,0.1599,7.8608,0.7164,653.4229,0.2409,0.8653,0.13,4.1375,43.2367,2.1092,0.3659,0,0.6823,0,1E-4,0,0,0.1607,0,0,0.6823,0,0,0,0]
["Other vegetables",0.2228,2.9905743365475762E-8,0.3532,0.0072,{"$nulls":4},38.6516,1.6097,0.0784,75.8819,2.3307,35.5303,0.7148,20.6424,0.7609,47.9788,195.6622,0.0905,97.8595,0.0782,0.0235,0.093,12.3373,0.4123,38.1429,0.3838,8.0907,1.1471,9.2849,42.9631,29.6108,7.4354,0.0204,0.5675,0.0145,0.0301,1E-4,0.3475,18.8532,0,0.011,0,0,0.1799,0.3765,0.0145]
["Tomatoes",0.1671,1.168795103375361,1.5E-3,0.016,{"$nulls":4},34.7197,1.9111,0.1084,57.8858,1.057,10.2826,0.7501,13.3087,0.8762,41.0288,250.1085,0.0671,376.7509,0.0495,0.0627,0.0927,13.9916,1.5441,41.3692,0.2325,5.2747,0.5253,7.0811,34.5482,17.9552,4.3951,0.0726,0.573,0,0.0668,0.0094,0.0738,13.9515,0,0,0.0047,0.0005,4.3E-3,0.5645,0]
["Other vegetables, no fat",0.2424,0,0.8222,0.0311,{"$nulls":4},20.6201,1.6208,0.0578,41.741,1.5476,36.4832,0.5888,14.6587,0.5734,38.8392,189.0055,0.0536,114.8776,0.057,0.0352,0.0894,11.3729,0.1485,30.5997,0.4065,1.3863,0.3019,7.878,30.5866,7.464,2.1408,0.0044,0.6477,0.0113,0,0.0435,0.0222,3.1671,0.0008,0.0114,0.0065,0.0007,0.1383,0.4916,0.0113]
["Tomatoes, no fat",0.2783,0.1939344949026828,0.2664,0.5471,{"$nulls":4},10.6058,0.4564,0.0688,21.8295,1.0497,14.8765,0.3434,10.3741,0.6177,23.4407,218.8248,0.0229,73.7465,0.0407,0.0075,0.0796,13.3719,0.5542,39.5385,0.178,1.3433,0.1232,3.8829,17.6198,3.0632,0.6868,0.0221,0.5083,1E-4,0.0017,0.0074,0.0025,0.9775,1E-4,1E-4,0.0016,0.0002,0.0016,0.5051,1E-4]
["Mixed vegetables",0.2046,0,0.1692,1.1814,{"$nulls":4},48.3443,12.4,0.0604,113.8409,1.8584,25.2053,0.6971,14.3688,0.6711,54.2827,205.4157,0.0794,109.5667,0.0651,0.0559,0.1249,16.9187,0.9372,134.9056,0.3605,26.6431,3.1358,9.7884,39.8273,68.831,14.2853,0.0927,0.6535,0.0047,0.0683,0.0651,5.9045,24.6008,0.016,0.0151,0.099,0.0012,0.0741,0.4652,0.0047]
["Mixed vegetables, no fat",0.1899,0.6292955388702551,0.0317,0.333,{"$nulls":4},18.6958,0.4975,0.081,53.3892,2.3394,22.883,0.7605,14.5809,0.8538,42.8003,195.1259,0.0608,142.7405,0.0857,0.0119,0.1082,12.2089,0.3928,134.2785,0.4521,1.1833,0.2209,9.5527,39.4192,7.8385,2.3933,0.0924,0.5832,0,0,0.0185,0.3994,1.9178,0,0.031,0.1113,0,0.2707,0.1701,0]
["Fats and oils",0.2745,0,0.3031,0.0057,{"$nulls":4},27.0141,11.8849,0.0912,224.4083,0.8274,8.2173,0.5714,11.0177,0.6248,34.0069,160.0783,0.1125,742.7267,0.0424,0.0763,0.0965,6.8435,2.0971,93.1411,0.2688,67.125,8.7362,6.8527,39.8079,184.6661,40.4767,0.0883,0.2555,0.0012,0.0325,0.0413,15.2235,52.4779,0,0.0004,0,0,0,0.2551,0.0012]
["Coffee",0.0193,0,6.8496,0.7192,{"$nulls":4},1.3482,0.0256,5.3E-3,6.9033,1.8E-3,2.5679,0.0188,2.5716,0.033,2.4357,40.2211,0.0295,2.0724,0.0005,1E-3,0.0008,1E-3,0.0102,0.0881,0.0147,0.0078,0.0017,0.3663,4.915,3.4807,0.0606,0.0005,0,0,0.0011,0,0.0002,4.0852,0.0002,0,0,0,0,0,0]
["Soft drinks",0.0644,0,1.1734,0.0031,{"$nulls":4},4.9007,0.0097,0.0119,41.7277,0.0119,0.424,0.0528,1.2733,0.017,6.6893,5.7352,0.0032,8.2576,0.0044,0.0016,0.0034,3.4793,0.0054,0.8218,0.0243,0.0103,0.0045,0.1428,42.807,0.0734,0.0293,0.0004,0,0.0137,1E-4,1E-3,0.0006,39.3343,0,0,0,0,0,0,0.0137]
["Low calorie soft drinks",0.0547,0,0.6564,6.3E-3,{"$nulls":4},3.6399,0,0.0131,5.8772,0.0064,0.2697,0.0353,1.2693,0.0233,8.6792,7.8581,0.015,10.4531,0.0085,0.0004,1.9E-3,2.0799,0.0164,0.037,0.0197,0.0087,1.8E-3,0.342,5.3886,0.0211,0.0035,0.0006,0,0.0111,0,0,0,2.6603,0,0,0,0,0,0,0.0111]
["Sugars",0.4364,0,0.1878,0.0006,{"$nulls":4},30.7712,2.3339,0.1133,318.5985,0.9453,6.2918,0.501,17.0975,0.4142,45.6826,116.075,0.0596,69.7042,0.026,0.0741,0.0267,3.8191,0.4195,6.6689,0.4651,4.693,0.1816,7.5823,266.6488,55.7747,25.4751,0.1422,1E-4,0.036,0.0539,0.1592,3.1825,225.3176,0.0058,0,0,0,0,0,0.036]
["Lower Limit",{"$nulls":8},1200,0,0.9,1800,25.2,400,8,320,14,700,4700,1.1,0,1.1,2.4,1.5,75,15,700,8,{"$f":"0.05*M60","v":90},{"$f":"0.006*M60","v":10.8},{"$f":"0.1*M60","v":180},{"$f":"0.45*M60","v":810},{"$f":"0.2*M60","v":360},0,6,2.5,1.5,0,5,24,0,3,0.43,0.29,0.43,0.43,0.93,0.75]
["Upper Limit",{"$nulls":8},2500,299.99,10,1916,10000000000,1000,45,10000000000,35,3000,10000000000,10000000000,2201,10000000000,10000000000,100,2000,1000,3000,40,{"$f":"0.1*M61","v":191.60000000000002},{"$f":"0.012*M61","v":22.992},{"$f":"0.35*M61","v":670.5999999999999},{"$f":"0.65*M61","v":1245.4},{"$f":"0.35*M61","v":670.5999999999999},{"$f":"0.1*M61","v":191.60000000000002},10000000000,10000000000,10000000000,1,10000000000,10000000000,195,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000,10000000000]
["Sum of Constraints",{"$nulls":8},{"$f":"SUMPRODUCT($C$2:$C$59,J2:J59)","v":1200.0000002301745},{"$f":"SUMPRODUCT($C$2:$C$59,K2:K59)","v":55.020733934843946},2.536951163603116,1916.0000000603618,53.6530851355646,999.999999672876,19.20317096203198,720.6744054574486,27.13415682603783,1751.1255308691284,4699.999998643176,1.834100674581147,2200.999995792357,1.784044171458877,2.4000000292628854,3.150898065223262,446.70720497678167,22.04732104557282,3000.0000093802596,13.571316763419967,157.0292725049402,13.12706568941724,332.35971241306515,1053.948384254983,631.9364275399926,161.2587346485485,5.9999999944472595,8.814301834224102,1.5000000408210838,1.0000000039146915,6.172512889106118,24.0000000630201,194.99999969464784,5.286998395175929,5.955066148735518,1.0705399749952382,0.43000000008941924,0.4300000013188215,0.9300000374055085,1.5000000408210838]
[{"$nulls":28},"Upper","Bound","under",1800,"Cal. =",630," "]
[{"$nulls":12},1950]

{"sheet":"Procedure","index":2,"n_rows":20,"n_cols":2,"rows_kept":20}
["Steps"]
[]
["All information provided in the Box account"]
[]
["Model built using formulas from example models"]
[]
["Limits provided in account failed to bind dairy servings to only 1 per day, so I had to change lower limit to zero and upper to one"]
[]
["After changing bounds and some sensitivity testing (.5 intervals, 1-10) Males 71+ ran smoothly"]
[]
["Females did not."]
[]
["I changed the female energy upper limit to 2200. "]
[]
["Additionally, macronutrients (columns AD-AI) for Females had lower limits set at zero, and both upper and lower had to be recalculated to ensure solutions were within them. It should be noted the increased calories described above also raised the upper limits on macronutrients, but only fats (2.5 above) exceeded the upper limits allowed under 1800 calorie upper limits."]
[null,"used multiplier table provided by dan"]
[]
["After recalculations, female model ran smoothly"]
[]
["Multisolver run to find optimal solution"]