Feed formulation excel file linear programming?

More Kylian Manon Eggink's questions See All

How to accurately quantify chitin?

Hi all, I have been working on the quantification of chitin in insect samples and feed for a while but I can notice that the quantification methods (e.g. exposure to HCl, NaOH, and weighing sample...

01 March 2021 1,843 2 View

Which statistical model to use for samples taken over time?

Hello everyone, I am currently analyzing my dataset, I have obtained body weight data in insects for 7 days consecutively exposed to six different treatments in triplicates. I would like to...

13 October 2020 5,668 12 View

What model is best to use to get/assess the current energy performance?

Hi, I am writing my thesis for a big organisation and am focussing on one location where they manufacture supplies. My assignment is ''How can X create a better energy performance of their...

01 January 1970 8,865 1 View

Binary Logistic Generalized Linear Mixed model in SPSS. Is it doable?

I want to analyses the proportion of swimming sperm of three species of fish in two salinities. To analyse the proportion of swimming sperm in a Generalized Linear Model, I would use a Binary...

03 March 2021 2,297 3 View

Do I need to do linear regression before running mediation analysis using PROCESS MACRO by Hayes ?

I just wanted to check if I need to run a linear regression separately if I am using PROCESS MACRO to run mediation analysis. Thank you.

02 March 2021 4,359 3 View

What analysis to choose with a large neste dataset and clearly skewed or kurtotic distributions?

Hello! I have a dataset of n=3000 nested within 8 countries with approximately 200 or 400 responses in each country. I originally planned to perform multilevel modelling with 4 dependent variables...

02 March 2021 6,865 1 View

Which is suitable for use with Python? MySQL or SQL Server?

Which is suitable for use with Python? MySQL or SQL Server? What is your suggestion?

01 March 2021 3,422 3 View

How to address this issue in the analysis of Real-Time PCR results?

To dear Researchers, I was analyzing a series of concentration for estimation of Real-Time PCR efficiency. The concentration was 1:10. I used MS-excel to evaluate Slope. The result of slope was -8...

01 March 2021 8,683 4 View

Can I download BibExcel for MacOs?

Hi everyone, I would like to ask how I can download BibExcel software for MacOs? There are some links which are supported by Windows but I could not find it for Mac. or is there any other software...

01 March 2021 652 1 View

How to plot the probability paper of Gumbel distribution using R programing?

In R-studio, there are many commands of Gumbel package. Arguments are also different. I`m asking about the alpha parameter of the Copula which must be greater than 1. If this is the one used to...

25 February 2021 5,229 3 View

Treating Intermediate Variable in Linear Regression Analysis in SPSS?

While performing the Linear regression analysis in SPSS version 26.0.0. my intermediate/mediation variable goes to the excluded section. Please share your valuable suggestion "How to restrain the...

25 February 2021 4,591 5 View

What software programs can directly simulate Additive Manufacturing Directed Energy Deposition (DED)?

I understand there are a lot of software programs that can simulate DED by going through specific modeling, simulation, and commands. For me, that was time consuming and results were not accurate....

24 February 2021 4,428 3 View

How to run raise regression in R?

if anybody know how to run raise regression in r, and raise parameter selection, please help me

24 February 2021 8,199 1 View

Przemysław Kowalik

Do you mean something known as the optimal diet problem i.e. the problem in which the total cost of some food products is minimized subject to the constraints describing real consumption of nutrients included in the food products being at least/at most at some predefined levels?

Mohamed-Mourad Lafifi

Dear Manon Eggink,

I suggest you to see links and attached file on subject.

https://www.youtube.com/watch?v=6xa1x_Iqjzg

https://www.youtube.com/watch?v=4gImSq1-4Kg

https://ideas.repec.org/a/pkp/apscen/2016p9vol9.html

Article Formulation of Low Cost Balanced Ration for Livestock using ...

Article USING MICROSOFT EXCEL IN FORMULATING POULTRY RATIONS BY LINE...

Best regards

Rolando Gonzales Martinez

Kylian Manon Eggink , this step-by-step Excel implementation may help:

http://faculty.sfasu.edu/fisherwarre/lp_solver.html

Rolando Gonzales Martinez, the example you linked is very general. It shows how to solve an LP problem without specified practical application with the Excel Solver. But will it be useful for feeding optimization?

Moreover, the recommendation for entering the data for neighbouring constraints with the same relationship separately is not good. D11

Przemysław Kowalik , I believe there is a specific spreadsheet implementation linked to first link:

http://faculty.sfasu.edu/fisherwarre/solver_with_drive.html

The links I sent are only guidance, as I do not know the exact nature of the problem, I cannot offer an exact solution.

Rolando Gonzales Martinez , I agree that nobody can help with an exact solution (or rather just an Excel implementation) of the problem when in fact no information about the problem-specific details is provided.

The text you linked is good just to begin working with the problem.

And one more link about animal feeding optimization in Excel:

http://slunik.slu.se/kursfiler/HV0050/30037.1213/UNEform-optimization.pdf

Juan Manuel Izar

, your file contains many more examples than feeding optimization. As I noticed, Ej2.2 and 2.4 sheets only are about feeding optimization. Anymore else?

Rogelio Beltran

Some options:

Windows User-Friendly Feed Formulation for Poultry and Swine

https://extension.uga.edu/publications/detail.html?number=RB438

Practical Program for Formulation of Rations

https://sites.google.com/site/ppfrparaexcel2007ousuperior/home

Texas Tech University Department of Animal and Food Sciences

https://www.depts.ttu.edu/afs/home/mgalyean/