Compensation Model for a Wealth Management Firm
Compensation Model generated for a Wealth Management firm. This solution calculates bonus, salary and incentive pay based on proprietary calculations which take into account employee review results. The solution allows for quick comparison of the compensation levels of the Employees and Brokers all in one place. Built in alerts ensure that payment structure does not bring the compensation level above or below predefined percentages.
Automated Revenue file for Artisanal Food Manufacturer
Excel-based revenue tracker which allows for sales to be entered either manually or automated via distributor data export files. Supports sales exports from Shopify and Goldbely and can be customized for any CSV data file. The system differentiates between retail and wholesale orders and between different business channels, tracks customer data, and summarizes all revenue by product, by month, by payment type, by source, and by status, and compares current year performance to last year to date. VBA is used to ensure system speed, efficiency, and data validity, saving the end user hours per week in manual entry and countless headaches due to human error.
Reformat Internal Report
Automated the reformatting of a report for an Insurance Company. We transformed an internal unformatted excel document into a client facing, professional report saving the Client multiple manual hours as well as eliminating the risk of human error.
Sales Pipeline Tool
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.
PDF Scraping for an Insurance and Risk Management Company
We extracted specific data based on key fields from 2,500+ certificates of insurance in a large PDF. This data was placed into an easy to use format within Excel. The client saved 100s of hours by outsourcing this work to us. Using our approach we were able to complete the task in just a few hours
Project Tracking and Reporting
Audit and modify an existing Excel workbook to allow for material tracking and reporting
Amazon Inventory Update
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.
Webinar Training and Data Merge for an Asset Management Firm
We conducted a series of Webinars for training around a task that needed to be completed by the company. We assisted, demonstrated and trained the client on merging the data located in two separate files. The client was able to both accomplish a work task and learn useful on the job Excel skills at the same time.
Custom Financial Model
Analyze COGS and overhead costs, and generate product unit pricing and profit margins
Bike Share Data Analysis
Provide interesting metrics from a set of metadata along with supporting reports which included a training session to go over the methodology used
Create a reformatting and restructuring tool for monthly invoicing for a warehousing and transportation services business
Developed a reformatting and restructuring tool for a Storage & Transportation company’s Monthly Invoice. We took a report with all of the Storage & Transportation company’s invoicing data in one sheet and reformatted it to be separate sheets for each client with subtotals. The tool separates clients into their own tabs, provides subtotals by charge types and eliminates unnecessary rows. The stand alone Excel tool takes an Excel document as the input file and reformats it, saving as the same file name. Each tab of the new workbook can be printed or emailed as needed. This replaced a lengthy manual process saving the client hours of time on a monthly basis.
Enhanced an existing workbook’s capabilities and automated much of its functionality including the ability to import files, export csv function and macros replacing manual processes.
Cash Confirmation Package Reporting Tool
Tool created for a hedge fund that imports a series of client files. The tool gives the user the ability to indicate which client should have a corresponding document created. The output generates 5 word documents per each selected client.
Fix Runtime Error
Audited a customer’s workbook and fixed an identified runtime error
Weekly Tracking Report with Consolidation
Created a solution for Foreman to supply Weekly Tracking sheet that are uploaded to a master workbook where they are stored in a database. The master workbook has a Dashboard including various canned reports, ability to select timeframes for each report and also generates P&L.
Interactive Reservation Calendar for a Sport Rental Company
We created a custom reservation calendar that tracks rentals for multiple pieces of sporting equipment by multiple customers. The calendar allows the client to view the data in multiple ways. It tracks customer data, payment confirmations, waivers, etc. The calendar view shows rentals by day and by equipment piece. There are checks and balances to ensure that the client has been marked as paid before the equipment is lent out and also warns against double booking among many other checks and balances.
Large dataset reporting tool for company offering turn-key Healthcare Response Programs to organizations nationwide
Create an Access solution for importing and searching on large sets of data.
Replace an existing Inventory tracking set of workbooks with a custom solution in one workbook with reports. We then added functionality to auto run the existing reports and then save in a stand-alone reformatted workbook with no link, buttons or formulas.
Inspection Template and PDF report
Created an Excel workbook for collecting inspection data. The tool keeps track of required fields, performs data auditing and allows for photo upload.
Payroll Entry & Summary Tool
Created a custom Payroll Entry and Reporting Tool for an Oil & Gas and Refining & Construction Services business
Replace an old process built in lotus with an updated enhanced version in Excel.
QuickBooks Export file converted to a Paychex import file for a Train/Locomotive Repair Company
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.
Annual Consolidation & Reporting Tool
Developed estimating and tracking tool that consolidates and reports on data from a third party
Board List and Board Company Reformat of top Recruiting Firm
Audited a workbook, cleansed the data and reformatted the file accordingly
Reformat Transcript Data
Reformat an existing spreadsheet by adding a summary and reworking the entry sheets.
Target List added to Reformatting Add-In
Add a new reformatting routine to an the existing Reformatting Add-In for a Private Equity Firm
Oil and Gas Project Deal Tracker, Importing and Reporting Tool
This energy company was interested in improving their process for tracking their oil and gas deals. Their current method was cumbersome and depended upon Excel power-users within the company to update it accordingly. We completely redesigned their data and built a customized interface using dynamic forms to help them input their data (including images, maps and curves). We also developed an “import” function that allows them to quickly process information from an outside source. The tool is easy to update, can import deal info from other sources, and aggregates summary info. Updating and running any aspect of the tool can now be done by someone without any Excel knowledge.
Dynamic Employee Scheduler for Construction Company
This construction company was in need of a new way to schedule their workers. We developed a customized solution that incorporated their current business model into the logic of the scheduler to save them time and effort.
Sales Rep Tracker for Industrial Manufacturing Company
This industrial company was interested in creating a new and improved way for their sales staff to input their data into a spreadsheet that made it easier to maintain and analyze. The main problem was that they were using several different workbooks that each had to be individually maintained. We were able to develop a customized routine that took out their manual processes and connected the workbooks together.
Forecasting Model for Country Club
Enhanced the Country Club’s existing Financial Model to help the Club make educated decisions as to whether or not to deploy potential future projects to the club. They user now just needs to enter a few figures to see the impact of improvements to the Country Club and how those projects will impact their financials
Campaign Reporting Tool for a full-service Performance Marketing Firm
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.
Customer Management Tool for Premiere Small Business Educational Program Globally
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.
Automated Org Chart Updates from Excel Workbook to for Insurance Annual Statement
Created Excel template files that feed Org Plus to automatically generate Org Charts for an Insurance Parent Company and all of their affiliates for their Annual Statement (Yellow Book)
Data focused Webinar for Human Resources Group of a nationally recognized Hospital
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!
Time Zone Functions for Phone-Based Marketing Firm
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.
Automated Task Completion Workbook
Created a tool that allowed our client to track the progress of a large number of tasks from the phase of Engineering, Purchasing, Manufacturing and then Completed. This tool also included a Summary Dashboard of the status of key tasks and the degree of progress in between phases.
Estimating Tool for niche Elevator business
Created a fluid Estimating Tool for a Custom Elevator business for the purpose of responding to RFPs where the user can input necessary info for up to 4 Estimates. All calculations flow through the tool and are automatically displayed on summary Estimate pages and an overall Proposal Summary page. Finally, a PDF of the Proposal is generated for the customer.
Insurance Specific In-Person Excel Training Session
Custom In-Person Training Session held at an Insurance Company for PC 2007 users in various departments. Topics included: Keyboard Shortcuts, Auto Filters, VLOOKUPs, Charts and Graphs, PivotTables and More!
Intro to VBA Webinar
Custom Intro to VBA Webinar Training Session for Insurance Company which included users in various departments
Restaurant Financials Deck
In person review and brainstorming session followed by creation of Financial Models for Business Plan Deck for opening a restaurant in Manhattan
Reinsurance Specific Excel Training Session
Custom In-Person Training Session held at a Reinsurance Broker for PC 2013 users in various departments. Topics included: Keyboard Shortcuts, Auto Filters, VLOOKUPs, Charts and Graphs, PivotTables and More!
Settlement Allocation Tool created for Mass Tort Healthcare Litigation Settlement for a Law Firm
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
Custom In-Person Excel Training Session for Family Office
Custom In-Person Training Session for Family Office of PC 2010 and Mac 2011 users. Topics included: Auto Filters, VLOOKUPs, Charts and Graphs, PivotTables, and more!
Custom In-Person Excel Training Session focusing on Financial Services Data
Custom In-Person Training Session for premiere Data Collection and Analysis Company service Financial Institutions. Training covered PC 2007, PC 2010 and Mac 2011 users. Topics included: Auto Filters, Text Functions, VLOOKUPs, Charts and Graphs, PivotTables, an Intro to Macros/VBA, and more!
Contest Workbook for a full-service Performance Marketing Firm
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.
Master Planning Automation Tool to Streamline Processes for Specialized Fashion Company
Client’s Master Planning file was modified to automatically upload the latest data from multiple sources (spreadsheets and systems) and manipulating the data accordingly to help them manage their budget and Current Bookings by Season by Label for various Wholesale and Retail accounts.
Graduates Dashboard for a Non Profit Supporting Small Businesses
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.
Accounts Receivable Report Automation for top Real Estate Law Firm
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.
Reengineer Apartment Proforma
Created a Custom Apartment Complex Proforma for a Real-Estate Development and Investment Firm. The end result is a tool they can use when making decisions before and during construction projects including seamless formulas, sleek formatting, enhancements, charts, graphs and reports.
Text Movement Macro for a global IT services company
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.
QuickBooks Macro to further Customize Reports for Contracting Business
This custom home contractor needed help organizing QuickBooks financial data. The “canned” reports provided with QuickBooks were not enough for this client to manage their invoices, so they reached out to us to see if we could help. We built the client a simple macro workbook that transformed their QuickBooks export file into exactly what they needed.
Dynamic Concatenation Macro
This online bookstore client had their product data in a workbook that was not user friendly and required a lot of time to manipulate manually. We programmed a macro inside the client’s existing workbook to combine text for a dynamic number of values together using customized logic and triggered by a keyboard shortcut. After the project was completed, the client said that our solution would save her over 100 hours of work each year!
Create a custom standalone Healthcare Deductible Bill Invoice tool for an Insurance Company
We replaced a semi-manual process for creating Deductible Billing invoices with a standalone automated Deductible Billing PDF generating tool for a specialty Insurance Company. Now our client only needs to upload an input Excel file to generate a formatted Deductible Billing Invoice PDF file that is customer ready. The invoice produces a summary page along with billing details and includes the calculated amount due while still allowing for manual entry of the Previous Paid amount.
Healthcare Loss Run Tool generating various styles of PDF reports from a Loss Run
We created a Loss Run Generation Tool for a specialty Insurance Company that automated the process of generating a formatted Loss Report by Insured by Policy Number in a PDF file that is customer ready. Now our client only needs to upload a Loss Run (Excel file) to the Loss Run Generation Tool, select their desired style of PDF reports (Self Insured Retention, standalone Deductible, …), and where they want to save it and then can generate the report. Additionally, the client no longer needs to go through the manual process for creating For Reference Only claim reports as this has been included as an additional output of the Tool. The PDF Reports from the Tool include automated text replacement, conditional record inclusion along with both detail and summary sections.
Reinsurance Treaty Template for Large Financial Services Parent Group and their Global Subsidiaries
Created a template for inputting Reinsurance Treaty Details on a per contract basis. The template includes varying functionality for Quote Share, Excess of Loss and Aggregate Stop Loss Treaties along with a robust database of Reinsurer Names and their corresponding Groups, Domiciles, Syndicate #s, and FEIN #s. User does not need to have any Excel knowledge to enter information in this template. Other key features of this template include: ability for the client to update dropdowns and change any parent names post acquisition, pushing out updates to all users via a google spreadsheet, printer-ready summaries for Letter, A3 & A4 paper at the push of a button and automatically converting original currencies to US $ based on the conversion rate at the effective date of the treaty. This is done via web scraping the rates from oanda.com.
Importing and Reporting Tool for Reinsurance Treaty Templates for Large Financial Services Parent Group and their Global Subsidiaries
This tool allows insurers and reinsurers to upload all completed Reinsurance Treaty Templates. The tool then produces 2 large data sets and corresponding PivotTables for the user to aggregate and slice the information themselves along with a sophisticated dashboard including canned reports that can be easily altered by Broker, Reinsurer, Treaty Type, Line of Business, and so forth.
Sample client work included below. Feel free to contact us to check out some of our demo work and/or to discuss any task that is on your mind.
We accept payments via check and all major credit cards.
We require full payment for the deliverable prior to getting started on the work.
We have a fleet of spreadsheet ninjas that come from various backgrounds (Engineering, Computer Programming, Math, Finance, …) and know how to beat up a spreadsheet. Based on your task, we will pair you with the most suitable ninja for your request.
We love Financial Models and we audit them to.
We know how crazy important and valuable your data is! That is why we have a host of ways of dealing with this:
On-demand Video Tutorials are for sale in our Shop. Additionally, we offer custom group training which is held via Webinar (GoToMeeting). We do our best to accommodate in-person group training dependent upon your desired scheduling and location.
Yep! That’s what we are here for. This can be done via Webinar (GoToMeeting) or in-person dependent up your desired scheduling and location.
Before assembling a Proposal (Scope of Work and Quote) for you, we will flesh out any Q&A over emails, calls, GoToMeetings or a combination of them. We will then outline the Scope of Work for your review and approval before moving forward.
Absolutely! The payment for your deliverable includes post-completion troubleshooting and/or explanation within 20 business days upon receiving the final deliverable to ensure you are happy with the result.
No way! The cost of your project will NOT change regardless of how long it takes us to complete the work. The only time the cost will change is if you have some tweaks/enhancements to the original Scope of Work during the development process. Should this happen, we will send you a revised Proposal (Scope of Work and Quote) for your review and approval before moving forward.
We have been receiving and turning around Excel requests daily for the past 7 plus years. So, we have seen it all and know the skill needed, how long it is going to take us to turn around the work, the questions necessary and all the other nuts and bolts to get the work done. Thus, our pricing is generated based on these factors and will be included in your Proposal.
We are willing to give students a webinar to teach any pertinent skills to the subject matter, but we are NOT able to do the work for you. Should you decide to go the webinar route, we can work with you to assemble an appropriate list of topics to help you tackle the subject matter as best possible.
We apologize for the inconvenience and we feel for you as we have been there when it comes to daunting homework assignments! Please check out our Cheat Sheets and Getting Started Video Tutorials as a way to help ease some spreadsheet pain throughout those rigorous classes.
Of course it is! We can most certainly accommodate your tight timeframe. If desired, when we send over your Proposal we can include 2 Quotes, one for rush delivery and one for non-rush. This way you can weigh your options with price and completion date.
Portland Spreadworks, LLC is committed to protecting your privacy and developing technology that gives you the most powerful and safe online experience. This Privacy Statement applies to the Excel Rain Man Web Site and governs data collection and usage. By using the Excel Rain Man Web Site, you consent to the data practices described in this statement.