Advanced Excel Formula Wizard
Budget: $30 – $250 CAD
I need an Excel expert who can elevate my material management and estimating projects by creating calculations to provide the material usage and costs of all the material types from an input of the size of the patio cover. resulting in creating a cut list for the warehouse and a cost of goods for quoting purposes
**Key Tasks:**
- Using material dimensions, extension, and height dimensions to create a material take-off and material estimate using long stock and accounting for wastage.
Create an input page ( material lengths, costs)
Create and material cut list page (minimize wastage)
Create a cost page (Whole sale clients )( Estimate page) it would be nice if this could be provided to dealers for their pricing
Create an invoice page
Create an estimate page
attached are an example from another supplier
**Expectations:**
- Expertise in advanced mathematical modeling within Excel
- Proven track record of developing sophisticated calculation strategies
- Ability to suggest and implement ways to optimize data analysis
**Integration:**
- Flexibility to potentially sync with other systems is a plus
**Ideal Skills:**
- Proficiency in Excel at an advanced level, especially in formula creation
- Strong analytical and problem-solving skills
- Experience with data integration is advantageous, though not confirmed necessary
A freelancer with the aptitude to tackle manufacturing, costing, and wastage problems within Excel, and potentially prepare the spreadsheet for future integration with other software, will be the best fit. Your ability to think creatively and provide impactful solutions will be key to the success of this project.
**Key Tasks:**
- Using material dimensions, extension, and height dimensions to create a material take-off and material estimate using long stock and accounting for wastage.
Create an input page ( material lengths, costs)
Create and material cut list page (minimize wastage)
Create a cost page (Whole sale clients )( Estimate page) it would be nice if this could be provided to dealers for their pricing
Create an invoice page
Create an estimate page
attached are an example from another supplier
**Expectations:**
- Expertise in advanced mathematical modeling within Excel
- Proven track record of developing sophisticated calculation strategies
- Ability to suggest and implement ways to optimize data analysis
**Integration:**
- Flexibility to potentially sync with other systems is a plus
**Ideal Skills:**
- Proficiency in Excel at an advanced level, especially in formula creation
- Strong analytical and problem-solving skills
- Experience with data integration is advantageous, though not confirmed necessary
A freelancer with the aptitude to tackle manufacturing, costing, and wastage problems within Excel, and potentially prepare the spreadsheet for future integration with other software, will be the best fit. Your ability to think creatively and provide impactful solutions will be key to the success of this project.