The Excel implementations listed below are only representative to professional work I have done using Excel. I have used Microsoft Excel through my entire 25+ years of experience. I consider myself expert with Excel, Pivots, Advance functions, Charting, VBA, Microsoft Object Models, Excel integrations with the other applications in the Microsoft Office Suite and external database connectivity. via OBDC or native data access drivers.
Semiconductor Yield Tracking
Manufacturing
Tracked semiconductor factory yields by silicon supplier.
Regression Analysis Template
Metrology Lab
Implemented best fit line regression analysis of 2 variables. Included t-test for signficance and confidence intervals for the slope and constant. Template supported copy or link to external data.
Statitical Process Control Template
Metrology Lab
Implemented control charts for continuous measures. Supported by Xbar and S Charts and X-R Charts. Supported notes on explained special cause variation and corresponding removal from calculations. Template supported copy or link to external data.
Quality Report Templates
Quality Control
Various templates used to generate Quality Lab Reports using raw measurement data files. Include specification lookups to generate compliance and pass\fail.
Clinical Quality Scorecard Dashboard
Healthcare
Leadership dashboard providing system wide clinical quality performance for 8 hospitals. Included rolling twelve month performance and color coded trend arrows indicatng improving, flat or declining performance. Thre trend arrows were established based on confidence comparison between a rolling 12 month and a rolling 3 month estimations.
Defect Parato Template
Quality Control
Spreadsheet tracking of manufacturing defects by customer and by assembly. Implemented Pareto Chart Reports.
Test Development Project Status
Project Management
Spreadsheet to track test development projects, milestones and statuses. Included a quoting tool for future projects. Also implementing VBA to interface with Microsoft Project used, in this case, as a reporting client.
Best Fit Line Predictive Time Trend Models
Healthcare
End of year prediction and confidence interval analysis of executive level clinical quality measures. The analysis was used for meaningful 3 tier goal setting relative to bonus payouts corresponding to strategic and tactical improvement process. The confidence interval analysis helped ensure the distance between goal tiers could be resolved beyond the measurement error.
Variance of Component Models
Healthcare
Yield, Defect and RMA tracking for circuit board manufacturing assembly process.
Kapa Statistics Models
Quality Control
Spreadsheet utility to correlate quality control inspector performance on circuit board assemblies. Implemented Kapa Statistics to quantify inspector agreement beyond chance and chance alone. Tracked by missed defects and non-defects which were identified as defects.
Data Merging & XML Generator
Healthcare
Application to track the quoting process and all project milesones for complex test developments integrating both software and hardware designs. TestDev tracked the project against quoted cost and schedule. The database was also used to inform and dial in the accuracy of subsequent project quotes.
Excel Template Architecture
Misc
I am a big fan of Excel template architectures. The implement a standard output, analysis, charts, pivots, etc and allow you to switchout or update backend linked data sets. This is a goto architecture when appropriate. is a very effient way to implement a standard output, analysis, pivot report, chart etc
Misc Workbook Developments
Misc
To be honest, I do not remember all the applications and uses I’ve done with MS Access. I was an early adopter of Microsoft Access before it was released to the public in 1992 and have used it ever since (all versions). The above list represents some of the more substantial developments I have done with MS Access.
General Notes on MS Excel Techniques
Misc
I have extensive experience and a big fan of Pivot tables, reusable templates, function based analytics (versus the Data Analysis Addon), advanced charting techniques, the statistical modelling functions, data connections to external data, embedding SQL into the data connection properties and advanced functions. I am also very skilled at writing macros using the embedded VBA compiler. Function favorites because of their power are =Indirect(), =Offset(), advance uses of =SumProduct() for criterion lookups, all other Lookup formulas, all Normality related functions, =Slope(), =Constant(), all inferential statistics functions (ex. T Test, F Test, etc). I do try to avoid using VBA if I can accomplish the task based on advanced use of functions. This is because recalculating functions can be more reliable than VBA processing and they do not require the generation of a xlm version of the workbook.
