Other Industries

Created a customized report for a software company that identifies what portions of the software are being utilized by their customers. The PDF-generated report, is created within Excel, and is meticulously formatted in order to meet the client’s strict branding requirements. The reports are quickly and easily updated for each specific customer. This has allowed the client to save many hours and has helped create a consistent professional face to their customers.

Revamped a workflow workbook for a Humanitarian Aid Agency. We took an existing workbook with linked worksheets and made the modifications requested while ensuring that the links and underlying code were not compromised

Created a custom tool for identifying job positions that are the same, but with different titles. The tool will search a list of job titles to identify titles containing key words and phrases. The end result is a subset of titles are equivalent.

Worked with an author who wanted to include data support in their book. We audited the client’s workbook to ensure the approach was correct and complete. In the end we suggested some modifications and found a few data discrepancies. The resulting charts & data tables will be published when their book has been completed.

Worked with an Internet Marketing firm to create a custom assessment tool for one of their clients. The survey we created for the Industrial Supply company is being used to assess workplace safety. By keeping the design and functionality trimmed down the tool is easy to use and the results are clear.

Helped a Political Consulting Firm to complete the transfer of data from one CRM system to another. The client needed help merging files as well as cleaning up some of the data. Some data was in all capital letters, some data was stored in one column and needed to be separated into three as well as other data conversions for date formats. We were able to perform the transformation task in a fraction of the time expected allowing our client to be up and running on their new CRM system ahead of schedule.

Created a custom workbook containing two Financial Calculators for a Startup Company. The client wanted to be able to offer potential partners and endorsers shares in the company. When sitting with the potential partner they wanted to be able to show them not only what their shares were worth today, but also what they would be worth in the future. Creating the quick but flexible calculators allowed the client to include real scenarios when recruiting people to participate in his new venture.

Worked with a Humanitarian Aid company to automate their budget rollup process. We took their manual process of multiple budget files that were manually aggregated at multiple levels and completely automated the process. The client was able to free up hundreds of hours per year for a key employee and also eliminate the possible human error component.

Rewrote an existing employee performance analysis scorecard for a background screening company. The revamped and enhance Scorecard allows the client to view metrics on their employees individually as well as at a team level. Progress on quotas, MTD, YTD and sales trends are easily viewed with a series of charts and graphs along with tables of summary and detailed numbers.

Created a Text analysis process for an Online Consulting Firm. The custom workbook allows the client to compare text strings and assign values to matches. The automated process saves time by allowing only subsections to be run at one time.

Created a custom workbook for a truck driver to collect personal Ancestry Data. With the new format he is able to easily view the data he has collected as well as identify what additional leads he’d like to explore further.

Created a custom process in Google Sheets for a Media Agency that reads the contents of an uploaded csv file and populates an existing Google Sheet document. This process runs whenever a new csv file is added to the Google drive, saving the client from having to detect new files and kick off the process.

Developed a Revenue Forecasting tool for a Charity based on previous contributions, history of donors and trends. This tool allows the foundation to repeat this process for future years with minimal effort.

This school system needed to save time generating their financial statements. They were stuck having to manually type out their income statement, which was causing their finance department to waste numerous hours. We stepped in and provided them with a slick income statement that automates this process for them. We even built the tool in a way that they will be able to maintain themselves for years to come.

Developed a custom system allowing for a Dental company to view client metrics across their many branches on a weekly, mid month and end of month basis. We created an import function along with a custom graph feature to allow the client ease of data collection and aggregation as well as the ability to view data metrics. This system saves the client many hours and vastly reduces the risk of human error.

Automated an existing manual process for a humanitarian aid company. The automated process separates one input file into multiple files used for reporting. This process saves the client many hours as well as eliminates potential human error.

This pharmaceutical company wanted to track attendee statistics for speaker programs based on speaker type (MD/non-MD). This custom made tool imports program data, correlates results and exports dashboard to PowerPoint slides by region.

The customer is a corporate event planner. This comprehensive tool collates responses from hotels and venues regarding availability and pricing of guest rooms, meeting rooms, food and beverage rooms and concession lists. It creates reports for comparison at the Executive level, Meeting Room info, Food and Beverage info and Concessions. It also can separate the hotel responses based on dates or locations.

The customer is a corporate event planner. This tool allows them to track upcoming meetings and calculate projected commission based on numerous factors and commission %s. Can automatically create reports for individual salespeople with only specific data showing.

Automated the population of an existing template for a Genetics company. We created a custom tool which reads all files within a given folder and uploads the data into the template. Now the user only needs to choose the template file and the folder containing the data files to complete their task. This tool saves the users hours per week and eliminates potential copy/paste errors.

Enhanced an existing Case List workbook for a boutique matrimonial law firm. With formatting, data validation and a bunch of slick real-time reports, we created the ability for the client to get a feel for what parts of their business to focus on and what aspects they should shift away from.

Enhanced a Google Sheet for a Newspaper Sales company by creating a series of reports and graphs. We were able to allow our client to continue to work with their google sheet while we made the modifications in the shared sheet on off hours.

Excel-based tool which allows the end user to answer a series of form-based questions to arrive at the fair market value for a particular service provider and service. The administrative side of the tool allows for easy updates to the source data and policies, and the output of the tool provides line item detail on the recommended rates.

Created a Custom client status communication report for a tech company. This report is used to communicate the Client’s onboarding status on a weekly basis. The template allows for easy entry of data, creating bullet points and charts to verbally and visual communicate progress. The report can then be produced as a professional looking PDF to email to the client.

This industrial company needed help moving their customer data from one system to another. Since they had over 20,000 customer profiles, it would have taken them weeks to get their data into an upload friendly format for the new system. They reached out to Excel Rain Man to help and we were able to get them everything they needed very quickly for minimal cost.

Research and ultimately rewrite an existing Normal.dotm macro for a Law Firm which is used to set margins and printer trays.

Excel-based service request form which allows the end user to request the services of a particular healthcare practitioner. We added flexibility to the form by using macros to allow for additional rows and sections to be added and removed instantly while maintaining all validation and functionality.

Developed a process to transpose data into a format more useable by the client. This involved the reformatting and recalculation of numerous cells, dynamic re-structuring, and the development of new logic to apply the same principle to various sheet formats.

Specialty drug speaker program dashboard which shows speaker and attendee analytics. Exports dashboard charts and data to PowerPoint.

Specialty drug speaker program analysis dashboards of speaker, attendee, spending and ROI statistics. Exports charts and data to PowerPoint.

Created a Custom Inventory tracking workbook for a Cannabis retailer. The workbook allows for barcodes to be scanned for incoming products. The quantities are tallied and descriptions of products are maintained.

Create a custom workbook for a Joint Replacement company for maintaining sales in their pipeline. The workbook is set up to allow for quick entry/update of data while on the phone with their sales team as well as allowing them to look at metrics across all clients.

Custom workbook created for a seller on Amazon to upload Amazon Inventory Updates to help them manage their inventory. This tool includes the mapping and merging of fields from the supplier and Amazon in one place.

Provide interesting metrics from a set of metadata along with supporting reports which included a training session to go over the methodology used

Starting with an existing workbook, enhance formatting, provide reports and rework some of the columns and data. We then conducted a Webinar to go over the solution and to give suggestions for various printing layouts.

Survey data consolidation with dynamic graphs.

We created a tool that allows the client to cut and paste in survey results received via email. By structuring the tool to allow for a simple copy/paste, the client no longer needs to reenter data or import each individual file. The workbook then automatically aggregates the data and performs metrics and displays the results in a easy to read report with graphs.

Create an Access solution for importing and searching on large sets of data.

Replace an old process built in lotus with an updated enhanced version in Excel.

We created a tool that takes the client’s custom QuickBooks extract and populates the Paychex import tool. The client only needs to click one button in the Paychex import tool to generate the correctly formatted Paychex import file.

Audited a workbook, cleansed the data and reformatted the file accordingly

Combine two reports to create a Budgeted vs Actual Report to show to Management which highlights projects are running over budget and ones that are operating at a gain.

Audited clients existing Marketing Campaign Tool to verify accuracy and correct any prior formulas or methodologies to help them manager the performance of their customer’s marketing campaigns more efficiently.

Data from multiple workbooks detailing financial results of small business participants on an annual and quarterly basis were consolidated into a database with a slick dashboard. User can pull up summary details on the desired small business participant and can view the corresponding metrics with ease via the Dashboard.

Custom Webinar Training Sessions for PC 2007 users in Human Resources. Topics included: Keyboard Shortcuts, Moving around a Workbook, Freeze Panes, Sorting, Auto Filters, Text Functions, Intro to Formulas, Advanced Formulas, VLOOKUPs, Charts and Graphs, PivotTables and More!

Wrote VBA code to split the cell contents logically from a notes column in a medical patient appointment listing based upon key items such as timestamps and dates to understand and join information from various appointment dates in a properly segmented and readable file.

Created 3 Functions remotely installed on our clients computer (via Webinar): Area Code function to pull the Area Code from a phone number; State function to determine the state based upon the Area Code; Time Zone function that determined the Time Zone based upon the state. This helped the Phone-Based company to easily determine optimal times to make sales calls to customers.

Audited and enhanced formulas, added structure, and formatted workbook to improve clients existing T&E Template for employees that travel to violence affected countries in effort to help their small business owners.

Created a Mass Tort Litigation Tool which classified incident types per claimant over time to depict various scenarios for settlement values based upon insurance coverages available

Contest Tool created to track leads in a contest combining information from Salesforce and an online Contest Provider into an Excel workbook that automatically generates a score based on the data input for the contest requirements.

Enhanced existing calendar workbook to segment recurring events from non-recurring events and to better track processes visually, by person responsible, for a calendar year for nonprofit network of business volunteers who work with entrepreneurs in violence-affected communities

Audited and enhanced formulas, added structure, and formatted workbook to improve clients existing Contractual Invoice Template for volunteers that travel to violence affected countries in effort to help their small business owners

Created a Summary Dashboard of graduates to an Entrepreneurial Program providing resources to business owners in violence affected countries. We audited and enhanced formulas in the underlying data, added structure, and formatted workbook to improve clients tracking of key metrics.

Fix formulas and reformat an existing Loan Rate Calculator Excel workbook. Adjust color scheme to match the logo. Modify layout of the data to be more easily read. Ensure that any client would be able to use the tool with ease by protecting cells and adding in drop-downs.

This law firm was spending several hours each month assembling an Accounts Receivable report by exporting data from their accounting system and manually manipulating it to fit their desired format. We built a workbook that connected directly into their database to automatically pull the information and programmed a macro to format the report, all with a click of a button.

Updated VBA-automated Excel tool which creates PowerPoint slide dashboard (Charts/Graphs) for a specialty pharmaceutical drug customer

This IT business had a system that exported survey data into Excel, but in a format that was not usable. Rather than spending hours manipulating the exported data, the client reached out to us to see if we could develop a solution to help. We programmed a customized routine, triggered by a keyboard shortcut, that took their data and automatically manipulated it into their desired format.