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 Auto Editing Tools - Excel Add-in

ProPricer Auto Editing Tools - Excel Add-in


Last Modified : 10-16-2023
File Size : 257922

Purpose

The purpose of the "ProPricer Auto Editing Tools" – 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.

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.

** 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 PROPRICER ADD IN USER'S GUIDE

Editing Tools Available

 ProPricer Automation Tool

  ProPricer Automation Tools Available

ProPricer Automation Excel dropdown ribbon   
 

 

   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 Auto Editing Tools" 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.    
     

Rates & Factors

 

ProPricer Auto Editing Tools

 

 Including Resources on the 'Inputs Table'

 

RATINGS

5 out of 5 | 1 Reviews
Rate this tool:
0

You Might Also Consider

Related Tools

Related Events