Anbuselvam
Board Regular
- Joined
- May 10, 2017
- Messages
- 97
https://www.dropbox.com/s/gfp9tfe6k2kc61r/Model sheet.xlsm.xlsx?dl=0
Dear Excel Ninjas
The above link excel sheet with the formulation which I'm using to maintain our company details since 2015 to till date. (Pivot table and Pivot charts not included as it is a model sheet created with dummy entries)
In the attached file I have entered only 13 rows of data with all the formulations. Actually, it is having more than 8000 rows thus it is hanging while calculating.
Each column in details:
Column A to I is production details
Column J to R is Sales details
Column U to BH is the formulation of each product (Data has to pick from two different sheets such Temporary and permanent as attached)
Column S, T and BI to BQ is the calculation of the cost of Raw materials, transportation, margin etc..
Column BR to DB is production quantity * Each product raw materials used as per formulation Column U to BH (To calculate the raw materials consumption)
Column DC to DE is the helper column for the slicer in Pivot table
Column DH to DF is the helper column the sheet COA as attached here.
Column DI and DJ is the helper column to pick the formulations from Temporary and permanent sheet to Master data.
And the last column DK is to cross-check the production quantity and the consumption of raw materials by formulation.
I hope the details are enough to understand the output.
Here I request you to suggest alternate formulas or formats to get the same output in each column as well as reduce file size and reduce the hanging issue while calculating.
Thanks in Advance
Sincerely Yours
Anbuselvam K
Dear Excel Ninjas
The above link excel sheet with the formulation which I'm using to maintain our company details since 2015 to till date. (Pivot table and Pivot charts not included as it is a model sheet created with dummy entries)
In the attached file I have entered only 13 rows of data with all the formulations. Actually, it is having more than 8000 rows thus it is hanging while calculating.
Each column in details:
Column A to I is production details
Column J to R is Sales details
Column U to BH is the formulation of each product (Data has to pick from two different sheets such Temporary and permanent as attached)
Column S, T and BI to BQ is the calculation of the cost of Raw materials, transportation, margin etc..
Column BR to DB is production quantity * Each product raw materials used as per formulation Column U to BH (To calculate the raw materials consumption)
Column DC to DE is the helper column for the slicer in Pivot table
Column DH to DF is the helper column the sheet COA as attached here.
Column DI and DJ is the helper column to pick the formulations from Temporary and permanent sheet to Master data.
And the last column DK is to cross-check the production quantity and the consumption of raw materials by formulation.
I hope the details are enough to understand the output.
Here I request you to suggest alternate formulas or formats to get the same output in each column as well as reduce file size and reduce the hanging issue while calculating.
Thanks in Advance
Sincerely Yours
Anbuselvam K