Ask Software Development Questions and Get Answers ASAp
Not a Software Question?
How JustAnswer Works:
Ask an Expert
Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
Get a Professional Answer
Via email, text message, or notification as you wait on our site.
Ask follow up questions if you need to.
100% Satisfaction Guarantee
Rate the answer you receive.
Ask Jess M. Your Own Question
Computer Support Specialist
Computer Software Support specialist for more that 10 years
Type Your Software Question Here...
Jess M. is online now
Looking to solve a problem in OpenOffice Cacl. (Need
Looking to solve a problem in OpenOffice Cacl. (Need differential equation).
File can be found at: http://filesxpress.com/d-d9c15f3b
I'm looking to calculate what the optimal balance of ingredients is to get the ratio of carbs/fat/protein to be balanced the way I want it, without going over in calories.
Column G,H,I row 13-15 lists how much carb/protein/fat each respective ingredient has per 100grams of weight.
Column C row 12-15 list that the desired amount of total calories is 1700, and the the desired distribution rate of those calories should be 10% on carbs, 30% on protein, 60% on fat.
Column C row 6-8 reflects that, given this desired calorie amount, and given the desired percentage distribution, the optimal amount of calories for each item should be 170 carbs, 510 protein, 1020 fat respectively.
Row 4 lists a weight in each ingredient, and is completely random and not necessary. I added it to see if the calulations in column G, H, I worked. With row 4 and the below listed values per 100 grams, it calculates that if you use that weight of ingredient, then the total amount of carbs/fat/protein would be the number displayed in G, H, I 6-8.
Column F adds up the numbers in row 6-8 respectively.
Column E calculates that given the totals listed in F, the achieved percentage of the desired amount of calories (listed in C) is x% of total.
Row 4 can be deleted, and I want instead to have G, H, I 6-8 to calculate of row 5 (recommended weight).
I want the spreadsheet to calculate what the optimal weight in each ingredient should be, to get the values in E 6, 7, 8 as close to 100% as possible.
Basically, I want it to output: use x grams of ingredient A, y grams of ingredient B, z grams of ingredient C, and than the total calories will be a%, b%, c% of the desired level for each respective ingredient , with a, b and c each approximating 100% as closely as possible.
Read more: http://www.justanswer.com/software/950z2-trying-solve-equation-openoffice-calc-specifically.html#ixzz3dWXRtJI1
1 year ago.
Share this conversation
Related Software Questions
Forgot password. Link in email is not activated by clicking
I keep getting a code B2957E akert, which freezes up my
I received pop up time to renew my McAfee notification and
I recently purchase Elements 4.0 from amazon. I used to have
My old computer harddrive which was running Windows 10 pro
I have McAfee full protection, yet I have a virus on
Viet - Computer Tech
I am using PageMaker 7, and have used PageMaker for years
Jins M. N.
How do I delate my account from zoosk, no, no, cant afford
Can I use Dragon 13 with OneNote 2016 other than using that
Capture program. I'm looking for a program (PC, Windows 10)
Ask a Software technician
Get a Professional Answer. 100% Satisfaction Guaranteed.
44 Software technicians are Online Now
Type Your Software Question Here...
Terms of Service
Privacy & Security
© 2003-2016 JustAnswer LLC