Clients and References
Greater Louisville Inc (GLI), Louisville, KY
http://www.greaterlouisville.com/GLI/
Products Delivered:
An organization that promotes the growth of businesses in Louisville, Kentucky. It began as the Louisville Area Development Association (LADA), established in 1943 by mayor Wilson Wyatt and was one of the first such groups accredited by the United States Chamber of Commerce.
- 2009 – Assisted and repaired the budget process utilizing Excel that used many linked spreadsheets, creating checks and balances that gave Sr. Management total confidence that Annual Budgets were up to date and correct.
- 2010 – Created new process in 2010 that eliminated need for Excel spreadsheets being linked together and moved towards interactive Access database that would give all Budget Managers ability to enter budget information, provide Sr. Management with reporting needs at multiple levels of the organization, as well as give accounting the export functionality to get information into Great Plains software, making this database a one stop shop for all departments.
- 2011 – Version 2.0 of the 2010 database that also shows reporting compared to prior year. As a Budget Manager is reviewing their new budget, they can visually compare against the prior year budget. This provides Senior Management with easy tools to identify opportunities when finalizing budgets.
- Contact: Christy C.
Try It Local, Louisville, KY
http://www.tryitlocal.com/
- Created Pro-Forma five year Revenue prediction financial model focusing on relevant factors and variables that produced low risk, high risk, and expected results.
- This was an automated Excel tool that allowed the user to plug in the assumptions across multiple scenarios and see the overall results and all implications from those assumptions.
- Contact: Todd Earwood
A private, coeducational, liberal arts university located in Nashville, Tennessee, United States. It is the largest Christian university in Tennessee and the second largest private university in the state, behind nearby Vanderbilt University.
- Built a Database for Belmont’s Student Services to track patient information, reports built to provide statistics for their student’s activities
- Built a second database for Belmont to track usage of Student Rec Center. Students use this database to track how many students are in areas such as the Climbing Wall, Racquetball Courts, Weight Lifting Gym as well as Lobby’s to track how students behaviors while in the Rec Center.
- Created Excel tool for Budget and Forecasting purposes that created flexibility on ability to move dollars around between departments and ability to track actual spending vs. forecasted spending.
- Contact: Angie Bryant
Screenshots:
City of Indianapolis, IN
http://www.indy.gov/Pages/Home.aspx
Products Delivered:
http://www.indy.gov is a hub of information about local government and happenings in neighborhoods throughout the City.
- Created an Excel tool that was used as a time sheet for all non-exempt employees. They were having issues with employees entering time correctly, so we created a VBA coded tool that wouldn’t allow manipulation. The employee was to log all time through the tool but did allow for changes, only by their manager, which was also tracked. This also allowed for Workforce planning as the tool was used to track vacations and other time off. It was also used to submit to HR on a bi-weekly basis with a compiled time that was similar to their prior process. The security implications were very valuable and it saved material hours every two weeks on the supervisors compiling all of their employees time sheets.
- Daily time entry that was set up for an entire year. It used the user id of their login on the computer to ensure it was the right person getting into the file. The amount of security on this file was as much as an Excel file can be. It also used the internal clock of the Server, so that an employee couldn’t alter the time of the computer.
Sheet1 Consulting's Blog 