In Makersite Costing, parts in a BOM are linked to production chains with existing cost-models. As a resuThe plugin enables you to enrich your product data directly within Excel. Simply start with a bill of materials (BOM) or a recipe and enrich it with Makersite Product Intelligence with a few simple clicks. We have designed the plugin to stay out of your way, giving you complete flexibility provided by spreadsheets, with all the power of an integrated cloud repository of networked product data. lt, cost estimates are taken down to minutes vs. offline calculations, that typically take weeks to complete.
Close all Excel files. Unzip the Makersite package into a temporary folder e.g. your desktop, and click on setup.exe. Follow instructions to complete the installation.
Once the installation is completed, start Excel. A new menu option will appear as shown below.
Figure 1: Makersite ribbon
The ribbon is separated into 4 main sections:
Figure 2: Setup window.
Any one or more of the following:
And all of the following:
Figure 3: BOM structure
Referring to Figure 3, in a non-normalized BOM, the Coffee Grinder subassembly (rows 3 and below) is defined for 1 unit of a coffee grinder, even if the entire product requires 2 grinders. If that was in fact the case, then we would need to scale the amounts for each of the subassemblies to know how many Springs are required for the entire product. This option calculates that for you. It will create a new column called “Net Weights” and use that in subsequent calculations.
The bulk of the work is in mapping a line item in your spreadsheet to a dataset on Makersite. You can do this easily by right clicking on the part name or material cell and selecting the “Map material” option as shown below.
Figure 4: Material mapping
Search for the appropriate dataset and select it. A reference will be placed in the Mapping column of your spreadsheet.
When you perform a mapping, you link a process, material or component to a makersite product. For simplicity we call this a dataset, but it is much more than that. All kinds of information about the industrial process network can ultimately be traced back to these objects – environmental impacts, processing options, companies that make them, etc. For instance, an object could have multiple environmental profiles depending on the process technology, country of origin etc. These can be filtered during the discovery process and enable a higher resolution analysis.
Modelling process steps:
Add rows to your spreadsheet to easily model process steps like transportation, finishing etc. You can include these within your BOM, or create a new section at the bottom. These can be treated just like materials or parts. The amount column defines how much of the activity is required. Then simply map that row to a dataset as described in Section 3.
Once all or part of your BOM or recipe is mapped, you can use this option to discover information about your product.
Figure 5: Layers
Simply choose a layer and the Makersite will deliver results right into your spreadsheet.
Figure 6: Results
The plugin allows you to map to all datasets that exist on makersite. However, results will only be displayed based on your subscription. Users of the free service have access to all open data. We actively invest in and develop this repository together with the community. However, to access all our proprietary or licensed datasets, you need a premium subscription.
If multiple supply chain options are found for a given row, this is indicated with a comment. A hyperlink is provided which will take you to the documentation of the dataset on the Makersite platform.
To view alternative supply/production routes, right click on the corresponding cell and select the “Alternatives” option. A window will pop-up showing you alternative datasets representing different supply chains. Upon selecting an alternative, results will be updated.
The flexibility of Excel allows for the most intuitive scenario analysis. E.g. if you would like to see the impact of switching a material, simply perform a mapping again, and click discover. The plugin will display results in a new column alongside the old results allowing for easy, iterative comparisons.
The plugin can be uninstalled just like any other application. Use the “add/remove software” application and search for “Makersite”.