Least cost feed formulation using Excel spreadsheet
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2020
- In this video I have explained how to use #Excel to formulate #animal (specifically #poultry #chicken) diet based on least cost feed formulation method. In fact this would be used as a #feed #formulation #software. Also, it is an example of using #solver function in Excel for #optimization process.
If you watch the video completely, I believe you will be able to create your own Least Cost Feed Formulation software. However, if you feel that you need to use the file that I have created, you can use the following link to download it!
www.canadaanimalnutritionist....
Dr. I'm very grateful for the impact full lecture. May God bless you and increase you in wisdom and understanding.
Glad to hear that the lecture was useful. It's my pleasure. I'll continue making this kind of videos more. Have a blessed day.
Great Lesson. Thank you, Professor!
Thanks for your interest. I'm glad that my videos are helpful
This is am amazing channel. I have not seen any other video like this. Even you take the time to explain some excel basic features. Thanks a lot. I appreciate.
My pleasure. I'm making more videos about these topics. Please feel free to share it with whoever that might be interested in.
@@animalnutritionist of course. I am in aquaculture, but It works!
Many, many Thanks :-)
Hello dr, I watch your video during dawn so that I can really understand in it , and great it really helps me a lot in formulating my feeds now
Glad to hear that. Good luck.
It is real kindness. You show me the DNA of feed formulation. Thanks
Glad to hear that it was useful for you. Good luck.
Thank you sir ! God bless you!
My pleasure! Thanks for your comment.
Dear Sir,
In the end when you copy cells one by one, you may use the copy - Paste special - check box with transpose commands; things will be easier. You explained each and every step extremely well - well done. I learned a lot from you.
You're welcome. Thank you very much for your constructive feedback. I really appreciate it. Good luck.
Thank you sir. You have done a great job for us
Thanks for your nice comments.
So precious. Thank you
You are welcome.
Awesome! Thank you.
My pleasure!
Wonderful video thank you very much
You're welcome. Thanks for your interest
Very informative, thank you
My pleasure!
If you had the sheet , would you please share it to me
thank you very much for interesting topic
You are welcome
Hello Dr you have really changed my career with these kind of knowledge my humble request is to make a video on formulating feed Using digestible lysine to protein ratio
You're welcome. For sure, I'll make a video about that too.
Endorsed
💯
Thank you very much, Shazad.
I look your all videos l like your videos ❤
Thanks
Thanks 👍👍👍 very much ❣️
My pleasure.
very useful thanks
My pleasure. Stay tuned for the upcoming video about a complete feed formulation Excel soon.
Love from Nepal.
Thank you very much😃 Love from Canada
Nice❤
Thanks
very nice
Thanks
Doctor, what a great contribution to human development. I don't know if you do this for rabbit reed. Good bless you.
Thank you for your comment. I did not understand "rabbit reed" concept? What's that? Thanks again.
Hi Doc, quite an educative presentation, it just came at the right time when I was trying to get a software to formulate layer and broilers feed rations this side. Can you please explain how did you get inclusion rates? I went through this video twice but all I could see was when you gave an example of an inclusion rate for corn as 60%, and the rest only pops -ups at the end when you applied the "solver".
Hi Frenada. The software calculates inclusion rates of ingredients. However, we are controling the inclusion rate range by giving the minimum and maximum amount of each ingredients in the rows above the inclusion rate.
@@animalnutritionist Thank you so much Doc, I got it now....highly appreciated
Hello Sir. In your formulation are you specifying the Amino Acids as digestible ileal standardised for poultry or are you specifying for just the standard profile? Also are you doing the specification as fed or on dry matter?
Hello Vukile. I balanced the amino acids based on the standard profile (Total amino acids profile). If we want to balance based on the digestible amino acids, we need to specify the ingredients' amino acids based on the digestible amino acids as well (it means that we need to multiply feed ingredients' amino acids content by its digestibility coefficient to get the digeatible amino acids levels for that ingredient).
For poultry we usually balance based on as fed. But for ruminants we usually balance based on dry matter.
Please let me know if you have any questions and thank you so much for your comment. Good luck
Hi dear doctor thank you so much for your presentation. Could you explain how I can consider the CV of ingredients, I mean stochastic programming in feed formulation. Is it possible by the linear model.
Hi Hamid. I have explained this in detail in the following link th-cam.com/video/xG-kyjd4wCQ/w-d-xo.html
First of all, I would like to thank you very much for this inexhaustible donation.
I will start working soon in pellet feed mill, do you advise me to use this??
Knowing that we only use soybean meal, corn and soybean oil in the formula of broiler mixtures.
This method is a great method to formulate the diets. If you can use your local feed ingredients' composition in the software, that will give you the best results.
I am expecting to see your next video regarding maximising profit on formulation of diet.
I'll do that in the next couple of days😊
Thanks so much for this tutorial video.
Excuse me, doctor, do you mean that in the 35th minute of the video, you point to the dollar sign by pressing the F4 button around the cell?
for example $B21$:$21$
By pressing F4 key we are fixing that cell. Therefore, if we drag the formula to other cells in the vicinity of the formulated cell, the cell which has recieved $ sign (by pressing F4) will remain same.
I'll try to make a tutorial video on some fundamental principles of Excel which are used in diet formulation.
nice
Thank you so much
Thank you very much for these great videos, but I have a question regarding poultry breader?? how is the ration calculated??!.
You are welcome. The ration is calculated based on different mathematical programmings such as linear programming (least cost ration), nonlinear programming (maximum profit ration), stochastic (accounting for variation in nutrient composition of feed ingredients) etc. I have explained different mathematical programming approaches in my videos. You can watch my other videos about them. Please let me know if you have any questions. Good luck
Thank u so much Sir.
The formulation what for , it's for layers or ?
My pleasure. In this video, I balanced a ration for broilers. However, this method works for other types as well (layers, breeders, etc)
Thank you so much for the great lecture. My question is where do I get the content of the ingredients? For example, If I have cotton cake, barley, sunflower cake, sugarcane cake, rice bran, wheat bran, etc...and is there constraints on fiber intake for layers?
Ingredients' composition is available on NRC (this link: nap.nationalacademies.org/catalog/2114/nutrient-requirements-of-poultry-ninth-revised-edition-1994). You can also get the ingredients' composition from feed library of feed formulation software. If you have access to your local feed ingredients' composition, that would be more acurate.
For layers, fiber level should be around 6% when the flock reach the developer phase (BW=950-970grams). There are nutritional benefits of fiber in layers, however, the feed should not be bulky (high fiber).
@@animalnutritionist Thank you so much!!
Thank you sir, you're doing a great job, wanted to let you know you inspire so much of us, stay blessed and please keep up sharing so much knowledge.
Thanks a lot Dr. for sharing this knowledge and make it available for anyone. I'd like to ask how can I get the Methionine + cysteine data? Do I only have to add both percentages or is there any other procedure?
To obtain the Met+Cys data of feed ingredients we usually add their Met and Cys percentages.
Thanks a lot good sir! Have a nice day!@@animalnutritionist
Great and I have learnt alot. unfortunately my computer software has failed to use corn in my formulations
Hi. You can put a number in the minimum cell for the corn and then software will use it
Dr. Can you make similar video for vanammei shrimp too please.
Sir this formulate is it for Broiler or layers
prof, thank you very much for helping million of us around the world, sir i use simultaneous linear equation in formulating feed for birds but since i watch this video iam now tying to use the opensolver to formulate my feed following your footstep in the video,but iam having some problem.after clicking on solve this what i see opensolver could not find and optimal solution and reported no feasible solution.SIR WHAT IAM DOING WRONG
Thanks for your interest. You need to double check constraints in the solver windows. Also try to double check feed ingredients' limitations and nutrients' limitations in the spreadsheet. If these things did not work please let me know. You can send your file to me and I'll double check it for you.
SIR HOW CAN I SEND YOU MY FILE , AGAIN THANK YOU FOR MAKING A DIFFERENCE@@animalnutritionist
@@gabrielogunsesan5545 I am available at LinkedIn at www.linkedin.com/in/mohammad-afrouziyeh-b614b9b9/ You may want to send the file
Dear Dr,
Thank you so much for that informative video.
And I was trying to do this model for ruminant animal by using specific parameters like TDN, RUP,NEm,NEl,NEmeat production,amino acid profile by the aid of (feedtables website) of INRA ,but the parameters of the different feedstuff was expressed in unusual manar as my be in different feeding levels or in X1,X3 or X4 which I couldn't know what that mean and how can I use these for formulating a ration in least cost method for ruminant animals?
That's a great question. I'll create a video about that topic and I'll explain those coefficients in detail. Please stay tuned
@@animalnutritionist Thanks for your concern, Dr.
@@ismaeelkhaled1768 I answered your question in the following video. The link for the video is th-cam.com/video/njLs1d4dunI/w-d-xo.html
I have created 4 episodes for dairy cattle ration formulation. Here is the link for the first episode. th-cam.com/video/PP_1Nbbw_y4/w-d-xo.htmlsi=zjayNnNRxkk6OPqX
I'll publish the next episodes in the next subsequent weeks.
Dear doctor it would be so useful if you can teach also stochastic programming in feed formulation and the procedure of it in excel sheet. Thank you so much for your consideration.
With Best Wishes
Sure. I'll make a tutorial video about that too. Have a great day.
Thank you for your consideration.
Have a nice day
I have made a video about stochastic feed formulation and will upload it tomorrow on my TH-cam channel. Have a nice day.
in my country, we don't add bicarbonate Na in diet and you recommanded to add it for avoid negative effects but I want to know why you don't enter the Amino Acid as an enrgy source in the calculate, for example, 1 Kg of Lys could be given about 5 meg Calori to diet!!
another thing, why we don't calculate what AAs could be given when we add it in water although it may give about 2 to 3 % protein and etc..
If you don't have access to sodium bicarbonate, then you can use other sources of sodium such as sodium sulphate.
About your question on AAs energy, I should say it is not necessary to include energy level of AAs in diet formulation. Because if your diet is a balanced diet in terms of the ratio of energy to nutrients, then AAs should be utilized for protein synthesis in the body and also some AAs will do some metabolic tasks as well. But in a standard situation, AAs should not be utilized as an energy source in the body. Therefore, we should not expect energy coming from AAs in the diet.
In my opinion if you are using AAs in drinking water you will need to calculate its inclusion and deduct the provided nutrients from the requirements while formulating the diet.
Dr thanks,
But am a beginner what should I start with to set up ingredients..
And how can I formulate trial and error method
Hello. Trial and error method is a bit old and might not be a good method to use. To set up the ingredients, just know that we have 3 types of ingredients: energy source (grains and fat), protein source (animal protein source like fish meal, plant-based protein like soybean meal and other oil seeds meal, single cell protein like yeast), and feed additives. If you still have questions about those, let me know and I'll try to make additional videos about that. Also, I have explained the basics of feed formulation methods in the following link:
th-cam.com/video/oXQaMWv6OiY/w-d-xo.html
Dr how can i protect my software that I have created
@@hilalothman5664 just try not to manipulate the solver window content. If you consider Excel operational instructions, your software will work perfectly
Thank you for sharing sir. But why those formula sumproduct doesn't work on my laptop, it appears "the formula you typed contains an error". Do you have any solution for this.. thank you...
Hi. Did you consider the rules of formula in Excel? I think you must have put an extra sign or element in your formula or something is missing from the formula. If you can share your formula I can have a look and let you know what would be the issue. Cheers.
Can you tell me the extra sign?
hello sir, I'm from Nairobi Kenya and I'm working as a production supervisor in a feed mill...i want to take this opportunity to give deep thanks from my heart. I have learnt how to formulate using excel through this channel, may God bless you and give you long life......i would with great humility request you to help me how i can use a formulation software and how i can have one on my computer. Thanks
Thanks, Francis. It's my pleasure to share my knowledge with people. The feed formulation files that I presented through my TH-cam videos are available to download through my website at www.canadaanimalnutritionist.com/
Please notice that the feed library of the feed formulation files are not complete and if you choose to use different feed ingredients, you will need to add those ingredients to the files.
@@animalnutritionist i appreciate you, thanks so much...…i understand
I noticed from the application of the equations that the proportion of methionine is high, can I intervene and reduce the proportion of its addition ؟؟؟
Do you mean the dietary level of methionine or the DL-methionine inclusion level? Which one do you mean?
Meth in diet become 0.6 % while we need to 0.52 %
@@zelalalsaftli4011 we should pay attention to the Met+Cys level not the Met level. Because part of the methionine will be converted to Cys in the body. If your Met+Cys level is balanced, then do not worry about the extra Met level. It is totally Ok in diet formulation. I think I have explained this topic in one of my videos but if I missed it, I will make another video about those small tricks in the diet formulation.
Can we make broiler concentrate (premix) with solver ?
Yes. That's easy. You can put the required analysis of concentrate (premix) in the nutrient requirements/specification section and formulate the concentrate.
@@animalnutritionist for you it is easy because you are gifted but I am not but will it be possible to make a video on that?
@@vinerguigreffou351 For sure I will make a video about that too.
@@animalnutritionist ah great so I'm looking forward to this video because I really need to know how to do it
thank you so much for exellent presentation. why did you put amount of corn 100% before performing solver?
It was just a test to see how the diet specification column works. In fact you do not need to do that during feed formulation.
Doctor,, am sorry, am asking if I can have this software of yours
All Excel files are available to download at www.canadaanimalnutritionist.com/
Doctor .. am begging help on how to create trial and error method software
Doctor thanks for your tutorials concerning feeding, i was asking if I can have this excel software of your's
Dear Sir,
do you see any chance to use AI in feed formulation? If so, what are the approach?
Thank you in advance
I would look at AI as a tool to provide the whole big picture of feed formulation or nutrition. I would not use it for detailed feed formula. As you know nutrient requirements of an animal is influenced by many factors such as environmental factors and feed antinutrients. In this situation an expert should determine nutrient requirements and then formulate feed accordingly.
Doctor i have a question regarding Broiler mash feed
Energy level should be
3000, 3125 ,3250, this level is good for product sir
Hello. An appropriate ratio between dietary energy and nutrients is way more important than the dietary energy level per se. I'd say all the energy levels you mentioned can do the job IF you keep energy per nutrient level in an appropriate ratio.
Dear Dr, why the solver does not give me an amount of 100 %?! It gives me something like 97.66. what is wrong with me? i selected all variables as you said.
If you want you can email me your excel file at canadaanimalnutrition@gmail.com and I can take a look to trouble shoot the problem
Thank you.
@@khaledmohamed4031 I have explained some troubleshooting method for the feed formulation file here in this link th-cam.com/video/8Xj1EWw6nNA/w-d-xo.html
Thank you dear
Hello sir, I cannot see the Ingredient details of Tryptophan here. can we skip it?
Hello sir. Tryptophan information is on row 16 in the Excel sheet.
Doctor am asking for this excel software if you can share with me..
All files are ready to download from www.canadaanimalnutritionist.com/
Sir thank you for the informative video I am a student of Animal nutrition I want to pursue my studies and want to do M.phill from Canada sir is there any scholarships for that please guide me
Thanks for your comment. Yes, there is always scholarship. The scholarships are usually competitive. It means that you need to apply for them and if your CV and publications are strong you will win those scholarships. You can search the scholarships by looking at the Canadian universities website. Good luck.
Hai doctor amino aci contain energy also. Why u didn't include energy valu in the aminoacid nutrition profile
Hello. That contribution in dietary energy is negligible
Can you please explain about the inclusion levels of different types of ingredients in a poultry dietm thanks from a fellow vet from india
I will make a video about that. Thanks for your great comment. Good luck
Thanks, after graduating i have been consuming all the poultry knowledge from you and i have learnt alot from u
@@sumukh-3826 my pleasure. Thanks for your interest.
excel is invisible make it bigger sir. Good work
Thanks for your constructive feedback. I'll make sure to show excel bigger in my future videos. Have a great day.
may I call you by any app to discuss any topic Dr???
We can set up zoom meetings in the near future. I have been busy recently, but I will try to make it as soon as possible.
Can you share the excel sheet please.
Thanks
I'll make a link to download the file. Meanwhile if you try creating a spreadsheet based on the video, I'm pretty sure that you will have the least-cost feed formulation file. If you have any questions about creating the spreadsheet after following the tips I mentioned in the video, just let me know and I'll answer them. Good luck😊
The feed formulation file is available at www.canadaanimalnutritionist.com/
would you please share us this spread sheet file
I'll make a link to download the file. Meanwhile if you try creating a spreadsheet based on the video, I'm pretty sure that you will have the least-cost feed formulation file. If you have any questions about creating the spreadsheet after following the tips I mentioned in the video, just let me know and I'll answer them. Good luck😊
The feed formulation files are available to download at www.canadaanimalnutritionist.com/
How is 1x100=1? It is puzzle to me please clarify it sir.
In which section of the video? Could you let me know the minutes of the video which it happened?
@@animalnutritionist In the least cost feed formulation video @ 29th minute. When the inclusion rate and the weight correspond by sumproduct
@@fitsumbishu3367 it's a good question. In that part of video I calculated 1*100%=1 it means that (1*100)/100=1 so it is correct. Because we are calculating based on %
This is really a nice presentation. More grease to your elbow
Thanks
Can you pls share of Excel file
I'll make a link to download the file. Meanwhile if you try creating a spreadsheet based on the video, I'm pretty sure that you will have the least-cost feed formulation file. If you have any questions about creating the spreadsheet after following the tips I mentioned in the video, just let me know and I'll answer them. Good luck😊
The feed formulation file is ready to download from www.canadaanimalnutritionist.com/
I am a small farmer 😢 .
If you have good diet formula you will make good profit. Keep up the good work and do not be discourage by being a small farmer
Nice video Dr. I am not
Unable to download the excel file.Can you send it to my email I'd please.
I'll make a link to download the file. Meanwhile if you try creating a spreadsheet based on the video, I'm pretty sure that you will have the least-cost feed formulation file. If you have any questions about creating the spreadsheet after following the tips I mentioned in the video, just let me know and I'll answer them. Good luck😊
The feed formulation file is ready to download from www.canadaanimalnutritionist.com/
Hello dr, Thanks for the nice tutorial, can i get your mail contact i have personal request to ask
my contact information are available at www.youtube.com/@animalnutritionist/community and also my website address is www.canadaanimalnutritionist.com/
Very insightful and well detailed. I really enjoyed it. Many thanks Dr. However, I'm struggling to duplicate your example on my laptop. I'm using word 365. I don't if u can avail me your email and/or contact Dr? I really need your guide to make progress on a research work.
Thanks for your interest. You can reach me via my LinkedIn at www.linkedin.com/in/mohammad-afrouziyeh-b614b9b9/
my contact information are available at www.youtube.com/@animalnutritionist/community
I am facing issue in downloading from your link provided
Thanks
I'll make a link to download the file. Meanwhile if you try creating a spreadsheet based on the video, I'm pretty sure that you will have the least-cost feed formulation file. If you have any questions about creating the spreadsheet after following the tips I mentioned in the video, just let me know and I'll answer them. Good luck😊