Recent content by irishtrash

an example from the spread sheet I have attached would be adding all of the code 3's together which gives me 1828. then we take the weight 515 and divide it by the total which gives me 0.2817287 then multiply that by the fat % which in this case is 32.2% which gives me the result...

Would it be possible to do if the format of the excel file was like this?

Hi all, just looking for some advice on what the best way to go about doing what I'm about to "try" and explain. I have attached a sample of an excel report that is automatically generated every morning. The first column "batch number" currently stands for a supplier and product type. because...