PHOENIX, ARIZONA, USA — Abe Arroyo’s MicroStation shop at David Evans and Associates imports many Excel spreadsheets into MicroStation every month. The following is his account on how they used to do this without the help of Axiom’s Microsoft Office Importer — a popular component of MicroStation Productivity Toolkit — and how much time and money they saved by using it:
Abe: “Without Microsoft Office Importer, importing spreadsheets was a two-step process that took two people (a designer and a CAD drafter) a minimum of two hours on a simple Excel spreadsheet to a maximum of five hours on a complex spreadsheet.
Step 1 (done by the designer): The designer saved the Excel spreadsheet as a text file. Then, using a specialized text editor, he manipulated the columns in the text file so they would import properly. Average time spent on this step: 45 minutes
Step 2 (done by the CAD drafter): The CAD drafter imported the text file using the MicroStation command “File | Import | Text”. Then, he did some set-up so the data followed our client’s CAD standards and manipulated the text information to fit the columns and rows in the plan sheet. Average time spent on this step: 2 hours”
$40 (average designer and CAD drafter hourly rates combined) x 15 days (number of monthly work days that at least one spreadsheet is imported) x 2.75 (average number of hours it took to import a spreadsheet) x 12 months = $19,800 per year spent importing spreadsheets into MicroStation, without Microsoft Office Importer.
Cost of importing Excel spreadsheets into MicroStation files using Microsoft Office Importer:
$17 (average CAD drafter hourly rate — only one operator is needed when importing spreadsheets using Microsoft Office Importer) x 15 (number of monthly work days that at least one spreadsheet is imported) x 4 (average number of minutes it takes to import a spreadsheet using Microsoft Office Importer) x 12 months = $214.20 per year spent importing spreadsheets using Microsoft Office Importer.
Total yearly savings due to Microsoft Office Importer: $19,585.80