Database Creation for Reporting

Looking to create a database for sales information, customer data, client mailing list or an inventory schedule?

We can provide solutions to efficiently store and track your most crucial business information.  

Get a Free Quote. No Credit Card Required.

Submit a Task
Fields marked with an * are required

By clicking submit you are agreeing to the Terms and Conditions.

Recent Tasks

Complete & Edit CRM Import File

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.

Ancestry Data

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.

Monthly & Weekly Stats

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.

Casualty Spreadsheet Automation

Took an Insurance and Risk Management Brokerage’s existing spreadsheet and enhanced it by generating graphs, reports and creating the ability to easily extend the data set. By including this additional functionality, the workbook morphed from being simply data to a useful reporting tool full of metrics that can be shared company wide and to clients.

Automated Processed Reports

Automated and enhanced a manual report process for an insurance company. We created a solution into which they could load their monthly source data and create a full repository. Having created a database of their information they can now automatically run their reports in for any span of time. This solution took a time consuming manual process and replaced it with a flexible fast solution.

Rewrote a Construction Company’s Invoicing workbook by replacing formulas and linked worksheets with macros

The company had an existing series of linked workbooks for Invoicing and an Invoicing Summary. It was very large, slow and unstable. We replaced the same functionality with one workbook that was faster, smaller and stable. Because of the new structure the client was able to enhance their reporting and pass the task of managing the workbook to another Employee.

Payroll Processing

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.

Survey Data Consolidation

Survey data consolidation with dynamic graphs.

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.

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.

Annual Consolidation & Reporting Tool

Developed estimating and tracking tool that consolidates and reports on data from a third party

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.

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.

Data Conversion and Mapping Project for Clothing Store and Website

This fashion client had 24 product files that were from 2 different systems and needed help combining them together so that they could analyze all of their data at once. They contacted us and explained their problem and frustration, and we offered to help. We were able to combine all of the client’s data together into organized sheets in one file, giving them exactly what they needed to move forward with their business.

FAQ
How can I pay?

We accept payments via check and all major credit cards.

‎How much is due upfront?

We require full payment for the deliverable prior to getting started on the work.

Who does the actual 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.

Can you handle Financial Models?

We love Financial Models and we audit them to.

How do you handle data and confidentiality?

We know how crazy important and valuable your data is! That is why we have a host of ways of dealing with this:

  1. We handle your data with the utmost care and do NOT share it with anyone
  2. We can sign an NDA if desired
  3. You can send us your files without all of the data. We may just ask you to include a couple of dummy rows of sample data. We can then create a solution for you using your dummy data. When we deliver the solution, we can provide instructions for pasting in your actual data or we can do this virtually for you over a GoToMeeting or we can come to your office and take care of this.
Do you teach classes or give webinars?

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.

Can I have a 1-on-1 session for you to show me how to do my work better?

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.

How do I know we are on the same page?

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.

Is troubleshooting included?

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.

Will the cost of my project change mid-way through if it takes more time to complete ‎the work than anticipated?

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.

How is pricing determined?

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.

Can you do my homework?

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.

Is rush delivery available?

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.

Privacy & Security

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.

Contact Us

Send us an email and we'll get back to you, asap.

0
SUBMIT A TASK