U.S. flag

An official website of the United States government

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Https

Secure .gov websites use HTTPS
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Breadcrumb

  1. Home
  2. Tools
  3. ProPricer Automation Tool (PPAT)

ProPricer Automation Tool (PPAT)


Last Updated : 05/09/2024

** PLEASE NOTE: You must download this compressed/zipped Excel file, EXTRACT it, and Open the file in order for it to run properly  **

PLEASE CLICK HERE TO DOWNLOAD THE USER'S GUIDE

Purpose

The purpose of the "ProPricer Automation Tool (PPAT)" – Excel Add-In is to enable faster analysis of ProPricer Excel outputs provided in proposal packages and/or generated by ProPricer users.

The Add-In automates some of the transformation and formatting of ProPricer based Excel files. The Add-In is intended to increase quality, consistency, and efficiency when developing custom Excel cost models originating from ProPricer. The automation tools provide an enhanced starting point for position development and further manual editing.

Link to Instructional Video Playlist on YouTube: 

https://www.youtube.com/playlist?list=PLP1GmNx4SVaxA4a9eeAlVSXsCK8soAXsT

What Does it Do?

The Excel Add-In provides Custom Right Click Menus which provide "Editing Tools" and "ProPricer Automation" features as shown in the screenshots below.

Editing Tools Available


 

  ProPricer Automation Tools Available

   
 

 

 

 

 

 

 

    Instructions for ProPricer Automation

  1. Open an un-edited ProPricer Excel proposal file (i.e., Detail Cost Breakdown Report). Save this copy with a new file name to preserve the original before making changes.
  2.  Download and save to a location on your PC and open the "ProPricer Automation Tool (PPAT)" add-in file and select "Enable Macros" and "OK"
  3. Select the "P" or "Pricing" Worksheet as the ActiveSheet.
  4. Right-Click in any Cell, then mouse over "ProPricer Automation". Within this sub-menu click through each and follow the instructions generated by the tool before making any changes to inputs.
  5. You can now edit or share the file as needed, as you would any other Excel file.    
     

Tags: Cost modeling, Pricing, Cost Analysis, Proposal Modeling, Pricing Model

RATINGS

5 out of 5 | 6 Reviews
Rate this tool:

You Might Also Consider

Related Tools

Related Events