Publication database
This spreadsheet uses the following tools to create a powerful and feature-packed database: >VBA SCRIPTS complete a variety of tasks, from server queries to file management. >EXCEL FORMULAS are used for in all sorts of applications, including generating links and doing numeric calculations. >USERFORM create a rich user interface >DATA VALIDATION across the file helps detect errors and duplicate items >PIVOT TABLES (not shown) summarize data and helps the user get specific data out
About Me
Trained engineer with years of professional experience in: •Software ○ Excel (incl VBA) ○ Python ○ MATLAB •Product development ○ Solidworks (solid and surface models, drawings for mfg and inspection) ○ AutoCAD ○ PhotoShop (for editing renders, see portfolio) •Academics (writing, tutoring in math, biology, chemistry, and physics) If you have any questions please feel free to contact me!
