← All cases

° Animal nutrition

An animal-nutrition consultancy had one spreadsheet per consultant, and the month only closed when each of them remembered to send the file. Today diets are built in one system that refuses what the spreadsheet accepted, and management exports everything once a month.

The starting point

Consultants built diets for dairy farms in a large spreadsheet full of formulas and macros, and each one kept their own copy on their own computer. Every month each consultant e-mailed the data or left it in a shared folder, and one person pieced it all together by hand; some forgot, and files arrived wrong or out of date. A feed added by one consultant didn't show up for the others. And the spreadsheet accepted what it shouldn't: when the price of an ingredient changed, the mix already saved kept the old price, so the only way out was to retype the ingredients into the diet; a date with day and month swapped went through; a name repeated on the same day went through with an extra dot. The copy left with the consultant, with no control over who saw what.

What we changed

We moved diet formulation into Odoo, with two parts built to measure: a feed list with all the nutritional information, the same for everyone, where a feed a consultant creates stays theirs until the administrator publishes it; and a diet screen that warns when a value goes over the limit, compares with the previous diet, pulls in the batch's weighing and produces the report for the farmer. The system refuses values over the limit, diets without a customer and a name repeated on the same day, and the mix of ingredients is stored inside each diet, with its price adjustable per ingredient. Access follows the responsible consultant: each one sees their own customers, coordinators see their team and management sees everything; when someone else edits, who and when is recorded. We brought every consultant's spreadsheets into the system, and whatever came with an impossible date or a value over the limit was stopped and corrected before it went in. The monthly export stays in the old format, done once, by one person, and still feeds the management reports.

See the before and after as a diagram

Before

  • One spreadsheet copy per consultant
  • Monthly file by e-mail or folder, when they remembered
  • Old costs in the diet when a price changed

After

Odoo
  • Feed library
  • Diet formulation
  • Weighings and farmer reports
  • Access by consultant, coordinator and management

Have a similar problem? Tell us in the conversation.

You send a message and we reply within one business day to set up the conversation. If it makes sense for both sides, you see a first version of your process working before you sign.

In the first conversation you talk directly to Rafael, Renan or Victor, not a sales script. Meet the team