Browse categories
Explore
Fiverr Pro
English
$
USD
I will send you excel cable tray fill and cable length calculation templates
Electrical engineer for Excel calc templates and Claude Code office automation
Electrical construction engineer at a Korean contractor: EPC design documents and site paperwork (daily reports, inspection photo sheets, cable schedules, lighting and load calculations). I automate m...
About this Gig
Three Excel calculation aids for electrical construction, made by a working electrical construction engineer.
WHAT YOU GET
- Basic: Cable Tray Fill-Ratio Calculator. Sums cable ODs per tray section, applies your spacing factor, shows fill %, remaining width and an OK / Hold / NG flag. Stays on Hold until you confirm the applicable standard.
- Standard: Basic + Cable Length Take-Off Sheet. Floor levels, tray height and panel top set once; per-circuit length with vertical drops, totals by size, allowance column.
- Premium: Standard + Room Illuminance Judgement Table (lux / uniformity / UGR criteria, paste lighting results, per-room judgement) + PDF user guide + 107-case verification table.
Each template: blank file + filled example (fictional demo site) + A4 PDF printouts. No macros. Excel 2016+ on Windows.
PLEASE NOTE
- Calculation aids only: your responsible engineer reviews and signs. No standard values embedded.
- Built with AI-assisted tooling (Claude Code); formulas checked against hand-calculated cases.
- Licence: internal use in the buying company, unlimited projects. No resale.
- Zip delivered within 1 day. Questions answered within 24 h on working days.
Platform:
Excel
Development technology:
Excel
Expertise:
Formulas
•
Data validation
•
Modeling
Other Data Processing Services I Offer
FAQ
Do these templates use my country's electrical code?
No code values are embedded. You enter your own criteria and clause references (any national standard) and confirm the standard text; only then does the sheet give a final OK / NG. The IEC 60228 nominal conductor series is included for reference.
Does the file work on Mac or Google Sheets?
It is built and tested on Excel 2016 or later for Windows, with no macros. It may open on Mac Excel or Google Sheets, but print layout and data validation are not tested there.
Can you adapt the templates to my company's format?
The files are unprotected (no password) so you can edit them yourself. Custom layouts, extra sheets or automation of your own templates are offered as a separate setup service; message me with a sample and I will quote.
