Samples of Our Work
Portfolio of Spreadsheet Projects
Every project has a unique set of requirements. Every solution is custom made to meet your needs.
LandWorx
Business Management Platform
LandWorx was designed to help landscapers and snow removal companies gain deeper insights into the profitability of their seasonal service offerings. The workbook includes: a high-level dashboard, period-over-period comparative analysis, project Gantt Chart, and heat maps to help identify opportunities and threats.
Gas-To-Electric Mower
Conversion Break-Even Analysis
When a one-hundred year old commercial lawnmower manufacturer rolled out a battery-powered option, the high ticket price could only be understood to be an investment through a detailed and customer-specific break-even comparative modeling tool.
ACTSYS
Technical Trading System
Using standard end-of-day data, this technical trading system uses VBA code to generate trading signals, trailing stops, and track system performance statistics. The equity curve gives traders a quick and easy view of the system performance.
ALARA
Analysis of Labor Rate
The Analysis of Labor Rate tool was designed to work with an SAP export to help an office furniture manufacturing plant better plan their labor capacity, standard payroll, overtime, and lay-ins to stay within defined labor-rate targets.
Material Efficiency
BIFMA e3 Level® Data Collection/Analysis Tool
Using SAP exports, this tool looks at the bill of materials for various product lines and breaks down the material efficiency for finished goods and their constituent sub-assembly components.
Market Systems Dashboard
Market Volatility & System Signals Dashboard
To facilitate the monitoring of various trading-system signals and market indicators, this workbook uses external data links to bring in live market data and combine it with external workbook references. The result is a dashboard that incorporates charting, analysis, signal notification, and a market volatility landscape visual.