Microsoft Excel/Libre Office Drop Down Meal Plan Nutrient Database Formula's Repair/Fix
Budget: $30 – $250 AUD
Hi. I have 2 different spreadsheets. They were originally made on Microsoft excel. See attached pictures. One is a meal plan document and a nutrient database document. An extended formula was made for me. The formula enabled for each row, there was a drop-down menu that I could select which food and this would sync the food, protein, carbohydrate, dietary fibre and dietary fat for the specific food selected I would be able to adjust the numbers to calculate the calories and macronutrients for the food. I have now moved from Microsoft excel to libre office. The formula doesn’t work anymore. The drop-down is not working. The only dropdown comes on "JB Foods", but not linked to nutrient database.
The nutrient database doesnt have formulas. It is the meal plans that has the extended formulas. I need this fixed and I’m Not able to fix it since going to Libre office. I need the formula to be fixed so that the drop-down works from the nutrient database with being able to select the food from the nutrient database and the meal plan document to be adjusted numbers from the macronutrients in terms of g for calories, protein, carbohydrate, dietary fibre and dietary fat. This is currently on Libre office that needs to be fixed on Libre office. I am happy to give you my login details for Libre office for you to do this remotely. Need this remotely fixed or repaired with same template.
You can either make a new spreadsheet with the formula to do what is intended or fix the current one. It’s up to you which one you choose but need exact same format. This is used to calculate foods and adjust numbers for the macronutrients in grams. Essential that this is fixed or new one made with same template. Can either fixed the current spreadsheet of the Meal Plans or make new one with same template for calculations. Ask any questions you need from me.
Thanks so much.
Jake
The nutrient database doesnt have formulas. It is the meal plans that has the extended formulas. I need this fixed and I’m Not able to fix it since going to Libre office. I need the formula to be fixed so that the drop-down works from the nutrient database with being able to select the food from the nutrient database and the meal plan document to be adjusted numbers from the macronutrients in terms of g for calories, protein, carbohydrate, dietary fibre and dietary fat. This is currently on Libre office that needs to be fixed on Libre office. I am happy to give you my login details for Libre office for you to do this remotely. Need this remotely fixed or repaired with same template.
You can either make a new spreadsheet with the formula to do what is intended or fix the current one. It’s up to you which one you choose but need exact same format. This is used to calculate foods and adjust numbers for the macronutrients in grams. Essential that this is fixed or new one made with same template. Can either fixed the current spreadsheet of the Meal Plans or make new one with same template for calculations. Ask any questions you need from me.
Thanks so much.
Jake