Okay, I understand. Since I'm an AI, I don't personally have electrical assemblies for sale. However, I can provide you with a framework for how to find them and where to look, along with some tips for when you do get an Excel file to review.
Where to Look for Electrical Assemblies (and Potential Sellers)
Online Marketplaces and Forums
Etsy or similar platforms
While not the typical place, you might find smaller-scale electrical consultants or freelancers who have created and are selling specific assembly documents. Search for terms like "electrical design templates," "electrical schematic Excel," "electrical assembly details."
Specialized Engineering Forums & Online Communities
Look for forums related to electrical engineering, design, construction, or project management. Post your request there. Be very specific about your needs (voltage, type of installation, code requirements, etc.). Examples: Eng-Tips Forums (Electrical Engineering section) Reddit (Subreddits like r/ElectricalEngineering, r/AskEngineers) LinkedIn Groups (Electrical Engineering, Construction Management)
Freelance Platforms
Upwork, Fiverr, Guru
Search for electrical engineers or drafters who specialize in assembly design. You can post a project stating your requirements.
Electrical Design Companies/Consultants
Many smaller electrical design firms may have standard assemblies they're willing to sell or license. Reach out to them directly, explaining your needs. Look for firms that specialize in the type of project you're interested in (residential, commercial, industrial).
Industry Associations
Organizations like the IEEE (Institute of Electrical and Electronics Engineers) or local electrical contractor associations might have resources or directories where you can find potential sellers.
Electrical Software Vendors
Some vendors offer libraries of pre-built assemblies as part of their software packages or as add-ons.
Consider Existing Code Compliance and Regulation. For example NEC, or CEC. Ensure any documents you buy comply with any applicable codes.Tips for Evaluating Excel-Based Electrical Assemblies
When you receive an Excel file, consider these points:
Clarity and Organization
Well-Structured Tables
Are the tables clearly labeled and easy to understand?
Consistent Formatting
Is the formatting (fonts, colors, borders) consistent throughout the document?
Data Validation
Does the spreadsheet use data validation (e.g., drop-down lists, number ranges) to prevent errors?
Named Ranges
Are named ranges used to make formulas more readable and maintainable?
Completeness
Bill of Materials (BOM)
Is there a detailed BOM with part numbers, descriptions, quantities, and manufacturers?
Specifications
Are relevant specifications for each component included (e.g., voltage, current rating, wire gauge, conduit size)?
Wiring Diagrams/Schematics
While you might not expect a full schematic within Excel, there should be clear references or links to external wiring diagrams or schematics. A basic table summarizing connections might be included.
Calculations
Are the electrical calculations (e.g., voltage drop, load calculations, conduit fill) clearly documented and traceable? Are formulas visible and understandable?
Safety Considerations
Are there notes about safety precautions or code compliance?
Accuracy and Up-to-Date Information
Verification
How was the assembly verified? Is there any documentation of testing or validation?
Revision Control
Is there a revision history or version number to track changes?
Code Compliance
Is the assembly designed to meet relevant electrical codes (e.g., NEC, IEC)? You are ultimately responsible for ensuring code compliance in your applications.
Component Obsolescence
Are the components still readily available and not obsolete?
Usability and Customization
Flexibility
Can the assembly be easily adapted to different project requirements?
Parameters
Are there parameters you can easily change (e.g., load size, voltage) that will automatically update the BOM and calculations?
Macros/VBA
Does the spreadsheet contain macros or VBA code? If so, review the code carefully for security and functionality.
Licensing and Usage Rights
Clarify the Usage Rights
What are you allowed to do with the assembly? Can you modify it? Can you redistribute it?
Copyright
Who owns the copyright to the assembly?
Example of an Excel Assembly Format (as a starting point)
Here's a basic example of what a very simplified electrical assembly in Excel might look like. Keep in mind that real-world assemblies would be much more detailed.
Sheet 1: Bill of Materials (BOM)| Item # | Part Number | Description | Manufacturer | Quantity | Unit Price | Extended Price | --------|-------------|---------------------------------|--------------|----------|------------|---------------- |
1 | XYZ-123 | Circuit Breaker, 20A, 120V | ABC Corp | 1 | $15.00 | $15.00 | 2 | ABC-456 | Outlet, Standard, 15A, 120V | DEF Co. | 2 | $2.50 | $5.00 |
3 | GHI-789 | Wire, 12 AWG, THHN | JKL Inc. | 50 ft | $0.10/ft | $5.00 | 4 | MNO-012 | Junction Box, 4x4x2 | PQR Ltd. | 1 | $4.00 | $4.00 |
Total| | | | | | $29.00 |
Sheet 2: Load Calculation| Load Description | Voltage (V) | Current (A) | Power (W) | Notes | ------------------|-------------|-------------|-----------|--------------------------- |
Lighting | 120 | 2 | 240 | (2) 60W Lamps | Receptacles | 120 | 5 | 600 | Assumed Load/Receptacle |
Total | | 7 | 840 | |
Sheet 3: Voltage Drop Calculation| Parameter | Value | Unit | Notes | -------------------------|-------|------|------------------------------------------- |
Circuit Length | 50 | ft | Distance from panel to furthest load Load Current | 7 | A | | Voltage Drop | 3.5 | V | Calculated Voltage Drop (formula in cell) |
Percentage Voltage Drop | 2.92 | % | (Voltage Drop / Source Voltage) 100 ||
Pass/Fail | Pass | | Based on NEC recommendation for max 3% Drop |Use Excel Formulas to perform calculationsCrucially, in a real-world scenario, you would include MUCH more detail on each sheet. This is just a basic starting point to illustrate what you might find.
Key Takeaways: Be specific in your searches and requests. The more detail you provide, the better the results. Thoroughly evaluate any assemblies you receive, paying close attention to accuracy, completeness, and code compliance.* Understand the licensing terms before using any purchased assemblies.Good luck with your search! Let me know if you have any more specific questions. Flag for review
Mike Dolt Enterprises
