It is necessary to create an Excel template with formulas for the automatic calculation of cutting aluminum boxes and canvases (system EA3478 + EA3619). The template should include drawings, input parameters, and automatic calculations.
The created templates will be used by the company's managers for:
• issuing orders for production,
• agreeing with the client on the dimensions of the structure.
1. Such templates need to be developed for 10 door frames Effectprof and two types of canvases:
- glass canvas
- canvas in aluminum framing
These two options have different calculation algorithms
2. Provide different options for the corresponding parts
The template must have the ability to select the correspondence (drop-down list) and the formulas must automatically adapt
3. Insertion of technical images into the templates
- image of the box
- image of the canvas framing (if available)
Deadline 1-3 days
📦 What we provide to the contractor
We provide ALL necessary output materials:
• technical drawings of profiles,
• drawings of boxes in various configurations,
• example of template design,
• logic of calculations and formulas,
• examples of finished production schemes,
• explanations regarding the principles of calculation.
The contractor does NOT need to invent technical data — just correctly implement the logic in Excel.
⸻
🧑🔧 Requirements for the contractor
Mandatory:
✔ High level of proficiency in Excel:
• complex formulas
• structuring tables
• hiding/protecting formulas
• working with drawings, designing templates
5000
✔ Ability to work with technical information:
• understanding of design logic principles or experience working with technical drawings
• ability to correctly interpret data to accurately implement formulas
