Author Topic: Development and Updates for the Medeek Electrical Plugin  (Read 30964 times)

0 Members and 3 Guests are viewing this topic.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #150 on: October 18, 2020, 06:48:32 am »
Similar to the estimator found in the Wall plugin the user will be able to select "All" or a selection of assemblies to run the estimator on:



The non-Medeek wall and roof assemblies will also be selectable since the Electrical plugin also works with non-Medeek walls, roofs etc...

I don't feel like it is necessary to break the listings into the assemblies they are part of however I will include a column in each table which lists the main assembly the electrical component is found in, this should prove useful to some.

There are a lot of little details with regards to different electrical components (ie. outlets, switches, panels etc...)  Each type of electrical component has unique characteristics, all of this data needs to be output by the Electrical Estimator, it will probably take me a few days to assemble this new module.

Once it is complete it will make this plugin a much more useful tool.

P.S. I think it would be also quite useful at some point to incorporate a price database that works with the estimating module.  This separate database would be referenced to determine the price, vendor etc... for a given electrical component.  Additionally, the list of materials could then be conveniently broken into separate purchase orders for each vendor.  I'm probably getting a bit ahead of myself here but with the ability to program just about anything with the API and the Ruby back end its conceivable that one could generate PO's that could then easily be imported into Quickbooks or any other accounting software.  I've done a bit of Quickbooks API programming in the past where I integrated my own customer billing system and expense database with the software, its really not that hard to do.

When I ran my web hosting company back in the early 2000's I got really sick of having to manually enter in customer orders and business expenses into Quickbooks, the problem was my billing system and Quickbooks (my accounting system) were completely two different ecosystems.  I would usually have to devote one entire day out of the month for this tedious task.  I finally got smart one day and decided it would be really nice if I could somehow automate this process.  After about two days of programming I had fully automated the manual entry problem and set it up as Chron job that would run nightly, it would even shoot me out an automatic email every morning letting me know how the process went and if there were any issues.

"Laziness is the mother of invention"
Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #151 on: October 20, 2020, 05:43:21 am »
First look at the CSV output (imported into Excel) for the Electrical Estimator:



*Note, the additional formatting (column spacing, bold, underline) is done in Excel after the import.

Also note that I have the total lengths tallied for each wire type.
Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #152 on: October 20, 2020, 08:53:38 am »
Version 1.2.3 - 10.20.2020
- Created the initial framework of the Medeek Electrical Estimating Module.
- Added wiring to the Medeek Electrical Estimator.
- Added the ability to export data from the Medeek Electrical Estimator in CSV format.



I also need to figure out what sort of CSI numbering to assign electrical components.
Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #153 on: October 21, 2020, 01:04:59 am »
Note that the Wire Name can be customized by the user. The default is to assign a prefix and then a number that is auto incremented within the model, however one could easily use the name to define the location of the wire run (ie. Master Bath Light, Hall Chandelier etc…)

Besides regular power wires this could be useful for routing and planning network cable runs for a project. In this scenario all of the cables my be CAT6 or CAT7 but one could define a number of cable types and differentiate them by color. Then it would easy to categorize certain parts of the network by color of the network cables and also figure out how much cabling is required for specific parts of the network.
Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #154 on: October 21, 2020, 01:54:00 am »
In the example shown below I've color coded my network cables based on whether they service the first or second floor of the building.  The red cable is the designated switch-to-switch or router-switch cabling:







Note that the totals allows me to determine my cable amounts for each floor.  I'm also able to determine that each cable run does not exceed a max. length.

View model here:

https://3dwarehouse.sketchup.com/model/ba4a8a90-9eb1-41c8-8e8c-b6b72723dfce/Network-Cables-Example-1

Once I created all of my cable paths I dropped them onto a separate layer so I could easily hide them (and keep them around for future use if needed) once my wires were created.
Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #155 on: October 22, 2020, 06:28:11 am »
Version 1.2.4 - 10.22.2020
- Added outlets and switches to the Medeek Electrical Estimator.

Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #156 on: November 11, 2020, 06:34:53 pm »
First look at UK electrical outlets and switches in the electrical estimator:

Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #157 on: November 12, 2020, 03:17:06 pm »
Version 1.2.5 - 11.12.2020
- Added data (low voltage) outlets, lights, panels, UK outlets, and UK switches to the Medeek Electrical Estimator.



The following (six) electrical elements still need to be added into the Electrical Estimator:

Safety Devices, Heaters, Vents, Floor Outlets, Low Voltage Panels, Misc. Fixtures
Nathaniel P. Wilkerson, P.E.

Offline Medeek

  • Administrator
  • Master
  • *****
  • Posts: 1885
  • Karma: +1/-0
    • View Profile
    • Medeek Design Inc.
Re: Development and Updates for the Medeek Electrical Plugin
« Reply #158 on: November 13, 2020, 12:14:23 pm »
Version 1.2.6- 11.13.2020
- Added Safety Devices, Heaters, Vents, Floor Outlets, Low Voltage Panels and Misc. Fixtures to the Medeek Electrical Estimator.

The Electrical Estimator is now complete.  I still need to change up the CSI numbers for the various components but for now I've just used my own default numbering system.  I will need to get with some electrical contractors on what are the appropriate numbers to use.

I will now turn my attention to more pressing matters involving the Truss plugin.
Nathaniel P. Wilkerson, P.E.