Excel Automatic Cable Sizing with Cable Schedule and Bill of Quantity Generator
This Excel will automatically calculate cable size (based on IEC) & parallel cable quantity based on load inputs from user. Also, can manually generate cable schedule and cable bill of quantity via Power Query.
Minimal Requirements
Microsoft Excel version: Office 2021, Microsoft 365
Excel Automatic Cable Sizing video demo
This Excel will automatically calculate cable size (based on IEC) & parallel cable quantity based on load inputs from user. Also, can manually generate cable schedule and cable bill of quantity via Power Query.
Minimal Requirements:
Microsoft Excel version: Office 2021, Microsoft 365, Excel Online*, Excel Mobile *.
* Excel Online and Excel Mobile cannot generate cable schedule and bill of quantities because Power Query feature is not available.
Limitation:
- Calculation is based on 2 parameters: Load Current and Voltage Drop.
- Calculation using IEC standards and metric units.
Features:
- This document has main objectives as follows:
- Automate cable size and cable parallel quantity requirements based on load inputs.
- Generate Cable Sizing and Cable Schedule preformatted table that can be used for submission to client.
- Calculate automatically bill of quantities of cable type & length, cable gland quantity, and cable lug quantity
- Real time calculations, as user complete the inputs required, output is instantly available.
- Every cell except for column for automatic cable sizing and cable parallel quantity, can be customized.
- Additional cable data from vendor catalogue can be added freely.
- v2025.0 changelog: Add Cable Tray Section to calculate cable weight that pass certain cable tray section. Demo: https://youtu.be/N74HeogARWs
- No VBA or Macro is used.
Hazardous Area Classification
Beberapa drawing Hazardous Area Classification yang diambil dari API RP 500 & 505. Unit milimeter dengan skala 1:1.
Gratis
Dibuat: 12 August 2025
2D CAD Dynamic Block Cable Tray - Ladder & Perforated
Ladder tray: 1. Straight, 2. Elbow 90°, 60°, 45°, and 30°, 3. Equal and Unequal tee, 4. Equal and Unequal cross, 5. Reducer (Straight, Right / Left), 6. Reducer and End plate, 7. Outside and Inside Riser. For ladders, the Flange-in or Flange-out type can also be changed. Perforated tray: 1. Straight, 2. Elbow 90°, 60°, 45°, and 30°, 3. Equal and Unequal tee, 4. Equal and Unequal cross, 5. Reducer (Straight, Right / Left), 6. Reducer plate, 7. Outside and Inside Riser.
Rp 45.000
Dibuat: 12 August 2025
2D & 3D CAD Dynamic Block Cable Tray - Ladder, 2D Perforated, 3D Channel
3D Ladder tray types: 1. Straight ladder, 2. Elbow 90° and 45° ladder, 3. Equal and Unequal tee ladder, 4. Equal and Unequal cross ladder, 5. Reducer ladder, 6. End plates, 7. Outside and Inside Riser ladder, 8. Adjustable vertical splice. 3D Channel tray types: 1. Straight channel, 2. Elbow 90° and 45° channel, 3. Equal and Unequal tee channel, 4. Equal and Unequal cross channel, 5. Reducer channel, 6. Outside and Inside Riser channel.
Rp 85.000
Dibuat: 12 August 2025
