Software

Ask Software Development Questions and Get Answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Trying to solve an equation in OpenOffice Calc.Specifically…

Customer Question
Trying to solve an equation...
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 without showing the spreadsheet).
Submitted: 3 years ago.Category: Software
Show More
Show Less
Ask Your Own Software Question
Answered in 2 minutes by:
6/11/2015
Software technician: Jess M., Computer Support Specialist replied 3 years ago
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 803
Experience: Computer Software Support specialist for more that 10 years
Verified
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
Can you please send me a dummy of your Calc file so that I can directly check your data and give a solution? You can attach the Calc file here when you reply using the paper clip icon, or you can upload the file to http://filesXpress.com and then give me the short download link so that I can get your sample file.
Please let me know so that I can help you further.
Best regards,
Jess
Ask Your Own Software Question
Customer reply replied 3 years ago
http://filesxpress.com/d-d9c15f3bI'm need to calculate the orange row.
I need a formula to calculate what the optimal ingredient weight is so that E6, E7 and E8 all approximate 100% as closely as possible.Thanks
Software technician: Jess M., Computer Support Specialist replied 3 years ago
Hi,
Thank you for the sample file. I got the file, please give me a moment to understand your requirements. I will get back to you shortly.
Best regards,
Jess
Ask Your Own Software Question
Software technician: Jess M., Computer Support Specialist replied 3 years ago
Hi,
Thank you for your patience. Please give me some time to figure out the formulas as this is a very complex computation. However, let me opt out so that my fellow experts can assist you further as I continue to build a formula for you. You will be notified when my fellow experts join you here. If no one picks this up, I will continue to assist you with this problem.
Regards,
Jess
Ask Your Own Software Question
Software technician: Jason Jones, Computer Technician replied 3 years ago
Jason Jones
Jason Jones, Computer Technician
Category: Software
Satisfied Customers: 19,487
Experience: 10+ years of work experience.
Verified





If anyone wishes to ask Jason a question directly,
they can do so at the following page: www.JasonFixedit.com

Hello,
My name is Jason. I look forward to helping you today.
I look forward to resolving this coding issue for you.
May I ask for you to elaborate on what exactly the tables in the spreadsheet mean and where do the number values come from?
Thank you,
Jason
Ask Your Own Software Question
Customer reply replied 3 years ago
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.
Software technician: Jason Jones, Computer Technician replied 3 years ago
Thank you for the clarification.
I will not be able to complete this for you.
For this reason, I am opting out of the question and allowing another expert the chance to help.
The next expert will see all that is on this page, so there will be no need to repeat anything.
When another expert picks this up, you will be notified by email.
Thank you for your patience.
- Jason
Ask Your Own Software Question
Software technician: xiaqin, Computer Enthusiast replied 3 years ago
xiaqin
xiaqin, Computer Enthusiast
Category: Software
Satisfied Customers: 950
Experience: More than 10 years of software programming and troubleshooting
Verified
Hello,
This is Qin. Are you still looking for the solution? please let me know and I can help you on that.
Thank you
Ask Your Own Software Question
Customer reply replied 3 years ago
Yes I am. I'll mark it solved when I don't need an answer anymore.
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a software technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Software
Satisfied Customers: 803
803 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

How JustAnswer works:

  • 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.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

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.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...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.

Jess M.

Computer Support Specialist

803 satisfied customers

Computer Software Support specialist for more that 10 years

Kamil Anwar

Kamil Anwar

Software Specialist

543 satisfied customers

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

Chris L.

Chris L.

Support Specialist

526 satisfied customers

Certified Software expert with over 10 years experience.

Jins M. N.

Jins M. N.

Computer Hardware Engineer

523 satisfied customers

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

IT Miro

IT Miro

Computer Scientist

513 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Steve Herrod

Steve Herrod

Computer Support Specialist

220 satisfied customers

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

Byron

Byron

Computer Support Specialist

205 satisfied customers

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

< Previous | Next >

Related Software Questions
I am trying to use the concat function in SPSS to merge 3
I am trying to use the concat function in SPSS to merge 3 variables and I have not been able to get it to work … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
803 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
George Sibiya
PhD
313 satisfied customers
I'm using "OpenOffice Calc" in place of Excel, but always
I'm using "OpenOffice Calc" in place of Excel, but always save my files as "Microsoft Excel 97/2000/XP (.xls)" format so others can open it. I would like to know how to reset the default fond and fond… read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
792 satisfied customers
In excel, I have a LOT of cells that are only showing me a
In excel, I have a LOT of cells that are only showing me a portion of contents of the cell. If I hit F2 on the cell, it then displays all of the contents.However, I can't do this for the thousands of … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I need a simple formula to convert a number from another
I need a simple formula to convert a number from another cell to text in another cell … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
803 satisfied customers
I am a teacher I want to set up a very simple and easy grade
I am a teacher I want to set up a very simple and easy grade entry and attendance entry chart . Again -- ultra simple and useable on my IPAD. Can you suggest?… read more
Bhavik Joshi
Bhavik Joshi
Computer Science and Engineering
941 satisfied customers
I'm currently using Office Pro 2013 and considering
I'm currently using Office Pro 2013 and considering switching to Apache OpenOffice (open source). I don't have robust application needs, don't coordinate files with others, or interact in corporate en… read more
Jason Fenoglio
Jason Fenoglio
45 satisfied customers
I have a an app on my phone called Icon that does a digital
i have a an app on my phone called Icon that does a digital card for me.. I also have my phone contacts data base. Now,the question is How if I go to a networking event, I get a lot of business cards.… read more
Expert
Expert
Computer Science
8 satisfied customers
I am just starting out with model rockets and I have
I am just starting out with model rockets and I have questions related to trajectory analysis. Specifically with trying to determine "How high/how fast/how far can it go?" under ideal conditions with … read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
Jolinzh Need to add some other variables to the formula you
For Suryanto/jolinzhNeed to add some other variables to the formula you createdWhere as we dispatched the drivers as soon as the order was ready, now we want to add some variables:1. Look in Column F.… read more
Suryanto
Suryanto
Computer Engineer
Bachelor's Degree
535 satisfied customers
How do i properly download the latest version of Apache Open
How do i properly download the latest version of Apache Open Office to my apple laptop so that I can access and update a critical spreadsheet that must be completed this week? This is time sensitive a… read more
Robert Preston
Robert Preston
Technician, Developer
Associate Degree
3,525 satisfied customers
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… read more
Expert
Expert
How does one edit the chrome app start page. A company called
How does one edit the chrome app start page. A company called ASK.com did the same thing a while ago. There was alot of discussion but now single resolution… read more
IT Miro
IT Miro
Computer Scientist
Bachelor's Degree
513 satisfied customers
In OpenOffice Spreadsheet (Apache Software), how does one
In OpenOffice Spreadsheet (Apache Software), how does one enter a time stamp into a cell of the spreadsheet that will not update automatically when the page is refreshed or the spreadsheet closed and … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
In Google Sheets how to add a trendline to a line chart?
I'm using Google Sheets. I want to add a trendline to a line chart. Google says I can do this at https://support.google.com/docs/answer/6075154?hl=en. However, my chart shows no trendline section in A… read more
Michael Hannigan
Michael Hannigan
Bachelor\u0027s Program
239 satisfied customers
good morning. I use a 64 bit computer with windows 64 -
good morning. I use a 64 bit computer with windows 64 - I also use Microvellum. we upgraded from 2007 to 2010 64 bit. we run windows 7 64 bit. Our computers are 64 bit. When I go to load "appload" the… read more
Bryan
Bryan
735 satisfied customers
I have tried with 3 different experts but cant seem to get
I have tried with 3 different experts but can't seem to get the right answer for this question. I need someone who can log on to my computer and see what's wrong. What I'm trying to do is to establish… read more
Richard
Richard
Retired
Associate Degree
1,593 satisfied customers
I have used Lotus 123 (Version 5) for many years and all of
I have used Lotus 123 (Version 5) for many years and all of my files (both company and personal) are on this software (registration 1R00151-32281470). I was forced to upgrade to Windows 7 on my main c… read more
DrKlahn
DrKlahn
Principal Systems Engineer
Bachelor's Degree
615 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

Ask Your Question

x