Profile image of rmjudkins
Member since December 15, 2010
0 Recommendations


Online Offline
For the past decade my focus has been spreadsheet development within Excel utilizing VBA programming. During this time I have developed spreadsheet applications by unleashing the power hidden behind the more obvious features of Excel. ***Formulas***Lookups*** ***Templates***Custom Menus*** ***Excel Add-Ins***User-Defined Functions*** ***Excel Utilities***Extensive Code Library*** ***Special Projects***Customized Applications*** The applications referenced below can be executed by opening a file, selecting a menu item, or clicking a command button. The processing time ranges from seconds to approximately five minutes. This represents a significant time savings per application. The Ranking application utilizes Visual Basic code residing in NetRevProdUnbExe, an executable workbook template which displays a customized menu upon opening. Clicking the Execute… menu item displays an input box prompting for the reporting period. The program opens source files to populate Area and Unit tabs created to rank net revenue, operating contribution, productivity, and unbilled categories. The CreateSortFile routine opens a sort file template. The routine then copies the tabs to the sort file template and saves the file as NetRevOpConProdUnbmmyyyy (mm=month, yyyy=year). The EndRoutine closes the source files and NetRevProdUnbExe file, effectively passing programmatic control to the open sort file. This file contains a SortData menu listing twelve (12) category sort options in addition to an option that sorts and prints the active tab by each category with a single click. The Personnel Analysis application consists of five (5) visual basic modules designed to track personnel expense as a percentage of net sales and rentals; trended by unit, area, and division. The modProdAnalTrnd module defines the target as an arbitrary percent. The source file is generated in Oracle and consists of seven tabs of raw data. The main routine generates a unit and area tab for each of the six (6) months in the source file. Units and areas are ranked by percent. An area file is created for each area. The Performance Review application opens Key Indicators and Variance Report files with the click of a command button. Data is written from Excel to a Word template, and a unique document is created for each unit, area, and division. The Net Revenue Analysis application is executed with the click of a command button. Visual Basic modules are executed, processing net revenue and operating contribution raw data generated by consolidating four Oracle reports into an Excel workbook. Area by Unit and Area by Location worksheets are created, sorted, and subtotaled. Additional tabs calculate and sort units and locations respectively by percentage increase / decrease in net revenue.
0 reviews
  • N/AJobs Completed
  • N/AOn Budget
  • N/AOn Time
  • 100%Repeat Hire Rate


Recent Reviews

No reviews.


  • Facebook Connected
  • Preferred Freelancer
  • Payment Verified
  • Phone Verified
  • Identity Verified
  • Email Verified

Browse Similar Freelancers