CalcuQuote Blog - Made for EMS.


Excel Tricks for Messy BOMs

For November's episode of  "Scratching the Surface Mount" webinar series, CalcuQuote President, Chintan Sutaria, goes through how Excel formulas and other functions (i.e., substitution formula, vlookup, copy/paste, sorts/filters, etc.)  can be used to clean up the formatting of a messy BOM.

Formulas, Excel, EMS, BOM, quotes, PCB Assembly, Messy BOM, BOM Scrubbing, VLOOKUP, Text to Columns


5 Reasons for Why EMS Companies Need to Stop Using Excel for Quoting

We meet EMS companies every day who tell us about the creative ways they've used Excel to organize their business processes. One of the most common ways that EMS companies currently do labor calculations is "through a spreadsheet that has evolved over many, many years."

Labor, Excel, xls, Model, EMS, PCBA, RFQ, Quote, BOM