Software

# Looking to solve a problem in OpenOffice Cacl. (Need

Customer Question
differential equation). File can be found...
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.
Submitted: 2 years ago.Category: Software
Show More
Show Less
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 715
715 Satisfied Customers
Experience: Computer Software Support specialist for more that 10 years

Jess M. is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

## Meet the Experts:

Jess M.

Computer Support Specialist

715 satisfied customers

Computer Software Support specialist for more that 10 years

Chris L.

Support Specialist

505 satisfied customers

Certified Software expert with over 10 years experience.

IT Miro

Computer Scientist

497 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Jins M. N.

Computer Hardware Engineer

463 satisfied customers

12+ years experience. Expert in installing and problem fixing of softwares.

Kamil Anwar

Software Specialist

456 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

Steve Herrod

Computer Support Specialist

220 satisfied customers

Familiar with a wide variety of software and experienced in user training/support

Byron

Computer Support Specialist

164 satisfied customers

12 years in operations at a large law firm supporting both retail and specialty applications.

< Previous | Next >

Related Software Questions
I want to activate Microsft flight simulator X. I still have
I want to activate Microsft flight simulator X. I still have the original packaging and the product code. When I try to run it, it stops after 30 minutes with error925723 saying I need to activate the… read more
Russell H.
Computer Technology Consultant
788 satisfied customers
I need an excel formula that will combine data from
I need an excel formula that will combine data from different lines of a spreadsheet into a single line. I have a large excel spreadsheet about 200,000 lines of data. It contains delinquent real estat… read more
George Sibiya
PhD
282 satisfied customers
I have a bunch of Excel worksheets. Each worksheet has 3
I have a bunch of Excel worksheets. Each worksheet has 3 columns Part # (UPC code actually), Description and Qty. I need to reduce the lists, on each spreadsheet to the same colum names but totaled by… read more
Jess M.
Computer Support Specialist
715 satisfied customers
I have a business of infusing images into metal. I want to
I have a business of infusing images into metal. I want to create a calculator/software program to be able to calculate costs for custom sizes. I offer prints 2"X3" any size up to 48"X72", any of thes… read more
The-PC-Guy
Bachelor\u0027s Degree
630 satisfied customers
Trying to solve an equation in OpenOffice Calc.Specifically
Trying to solve an equation in OpenOffice Calc. Specifically I'm trying to get Calc to suggest a value closest to 100% based on a 3 different sets of variables (don't know how to describe it better wi… read more
Qin Xia
Master\u0027s Degree
922 satisfied customers
I have burned the disc that you recommended last night. It
I have burned the disc that you recommended last night. It is in the CPU and I turned on the co outer and nothing happens. What now?… read more
Specialist Sean S.
Computer Support Technician
919 satisfied customers
Hi, I installed ubuntu desktop 12.04,2 and chose to keep my
Hi, I installed ubuntu desktop 12.04,2 and chose to keep my win 8.1 os but can't seem to access the win os. Doest not ask me which os at boot up? What can I do? Thanks… read more
Expert
In Windows Explorer (7) my system apparently forgets the file
In Windows Explorer (7) my system apparently forgets the file indexing, and when I click on a file that's not open, it has to do a scan of apparently everything (about 4 minutes) before opening the fi… read more
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Hi, RichieMe, Thank you again for your help. My other question
Hi, RichieMe, Thank you again for your help. My other question has to do with table cells. I have several tables in the PDF document that set up just find with the "form field recognition." Here's the… read more
Richard
IT Manager
IT Manager, Consultant
3,412 satisfied customers
I have a HP Elitepad 900. It came pre-installed with Windows
I have a HP Elitepad 900. It came pre-installed with Windows 8 Pro. I recently performed the Windows update which it now has Windows 8.1 Pro installed in it. Ever since I updated it whenever I boot it… read more
Byron
Computer Support Specialist
Bachelor's Degree
164 satisfied customers
Hi, sorry but this will be a long question! Home built computer,
Hi, sorry but this will be a long question! Home built computer, more then 3 years ago. Full tower, Tyan server board, I think #2932-E, Dual Quad AMD's, memory slots full of 1 gig sticks, probably abo… read more
Mr. PC Wizard
Some college coursework
3 satisfied customers
I am using Crystal Reports 2008 to build a report that pulls
I am using Crystal Reports 2008 to build a report that pulls data from one table in our SQL server. We need parameters for querying by two year dates to compare both for meetings, phone calls and emai… read more
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
I am looking for a very experienced individual with
I am looking for a very experienced individual with references in user interface for our new software entitled XXXX XXXX XXXX™. My programmer has been hard are work doing his thing, but we need the UI… read more
D.Sandlin
Support Technician
6,708 satisfied customers
I have made forms in the past utilizing Acrobat 7 and had no
I have made forms in the past utilizing Acrobat 7 and had no problem. Now I have made a form with Acrobat X Pro and I'm attempting to go into the properties for a text box and setup a "calculate, whic… read more
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
I Need HELP I am trying to make a report on fire calls in my
I Need HELP I am trying to make a report on fire calls in my house. So far there has been 25 calls 7 people who have showen up for some of the calls other calls no one has. I am trying to make a repor… read more
robert
Bachelor's Degree
2,594 satisfied customers
I have OOo 3.4. I use Calc to set up a system of keeping track
I have OOo 3.4. I use Calc to set up a system of keeping track of stock. I have several columns, but my question concerns 4 columns eg. A (new stock), B (in), C (out), D (stock) with all entries in th… read more
Jess M.
Computer Support Specialist
715 satisfied customers
I need an online tool or downloadable program for a food nutrition
I need an online tool or downloadable program for a food nutrition facts list/calculator. I want to enter any food item, such as Keebler Town House Crackers, and get the nutritional contents of the it… read more
Jess M.
Computer Support Specialist
715 satisfied customers
I need help finding an easy to use program for my Windows 7
I need help finding an easy to use program for my Windows 7 machine. Here's what I need it to do: I have a list of tasks I want to manage. Each "task" consists of between a few words to several senten… read more
Bryan
735 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less