I worked at a research institute for seven years and created many excel documents which helped analyze data. I color coded the user entry cells, calculation cells, and output cells to different colors so they were clearly identifiable. I primarily use cell formulas but have used VBA in the past.
My latest creation is a price quoting document for custom built pallets. There is a sheet for all the lookup tables, and new sheets for each pallet quote. The Pallet Quote pages take in lumber, cutting, nails, assembly, overhead, shipping, desired profit, and outputs your advertised price.... Read more