Custom Spreadsheets

Do you need a custom solution?

Look no further! We’d love to hook you up with a custom spreadsheet made just for your needs. Below you’ll see a list of features available to add to your custom spreadsheet. Also, PCS offers consulting and individualized Excel training. Please let us know what you are looking for by filling out the form below:

Auto Revision Highlighting

Sometimes Excel’s revision tracking feature just doesn’t cut it.  I prefer all of my changes to be marked by filling the changed cells with the same color, but sometimes I forget to note all my changes.  So I developed this automatic revision highlighting feature to automatically mark my changes.  This feature can be added to any spreadsheet.  Please contact us for pricing.

o

Auto Tab Export

Sometimes you want to export a tab, but it has formulas linked to other tabs in your workbook.  This feature allows you to click a button to create a copy of that tab in a new workbook AND convert any or all of the formulas and links to just information, so that it’s easily ready to email as a stand alone Excel file.  This feature can be added to any spreadsheet.  Please contact us for pricing.

b

Dropdown with Autocomplete

Sometimes a standard Excel dropdown menu just doesn’t cut it, and you could really use a dropdown menu that autocompletes the item you want to select.  This feature does just that, making it faster and easier to find the information you are looking for.  This feature can be added to any spreadsheet.  Please contact us for pricing.

?

Import From Takeoff Software

Many estimators use one piece of software for their takeoffs but use Excel to build their estimates.  Most takeoff software will export information to Excel, but not in a form that is easy to use.  We can create a feature that takes the raw takeoff data and adds it to your Excel estimate right where you want it.  This feature can be added to any spreadsheet – please contact us for pricing.

d

Auto-Hide Empty Rows

You may want to create a report or a bid by linking other tabs to a report tab.  But when doing so, you may find that you end up with a number of unwanted empty rows that are time consuming to hide.  This auto-hide feature can take the time and effort out of making a professional-looking bid or report.  This feature can be added to any spreadsheet – please contact us for pricing.

t

What are you waiting for?

Contact us today for a free quote on your project needs.

7 + 9 =