I'm working on a workflow in Bluebeam Revu where I need to tally items in multiples of 3, even though all materials are ultimately ordered in single units. The challenge is that many items I mark up are typically grouped in threes — for example, a single instance on the drawing represents three units of material. I want to avoid clicking three times for each instance, but still ensure the correct quantity is reflected for ordering.
What I'm Trying to Accomplish
- Count items once per instance, even if they represent three units.
- Apply a multiplier of 3 to most items to reflect actual quantity needed.
- Handle exceptions where some items should be counted as-is, without a multiplier.
- Keep all logic within Bluebeam, avoiding manual adjustments in Excel.
Here’s what I’ve implemented so far:
- Stamp Setup
- Each stamp includes a Subject and Label to identify the item.
- Custom Columns
- I created a Formula-type column with the expression
[Count * 3] to apply the standard multiplier. - I added a second Text-type column with a default value formula like:
=IF(OR(E3="<1st Subject exception>", E3="<2nd Subject exception>"), B3, D3)
This lets me override the multiplier for specific items that should be counted by 1.
- Post-Processing in Excel
- After completing all markups, I export a CSV Summary.
- In Excel, I manually fill the formula down from row 3, updating references for each row to apply the correct logic.
I’d love advice on how to:
- Consolidate this logic into a single column or more efficient setup.
- Automate the exception handling directly in Bluebeam.
- Eliminate the need for manual formula filling in Excel.
- If I can implement the multiples within the stamp, I think that would be ideal.
Has anyone developed a clean way to handle this kind of “tally vs. order” discrepancy within Bluebeam? I’d appreciate any tips or examples of how you’ve structured your custom columns or formulas.
