Best Of
Re: Excel Spreadsheet Integration
@Isaac.Harned and @Doug McLean have you off to a great start @Will Dellapenna on getting the information out of Revu.
For bringing it back into a PDF I have a couple of ideas that you could try, depending upon how you use the resulting data.
If you just need the information you can select a group of cells in you Excel sheet, copy them with Ctrl-C and then paste the copied cell as an image into your PDF. I uses this when reviewing material quotes where I use Excel as an "adding machine" and the pasted image as the "tape". Depending upon how fancy you want to get you could have your Excel sheet setup where the data maps into the right places in your PDF.
Another option you could try would be to print your Excel to a PDF, then run the OCR routine. This should give you selectable text that you could copy and paste into your form fields. It's still a bit of a manual process, but it turns a bunch of typing into mouse copy/paste work.
Keep us posted on what you come up with.๐
Re: How else do you use Bluebeam? ๐ก
I'm currently using Bluebeam to figure out the best way to stack pallets to make a fairly large bonfire for an event in the village where I live in here in the UK.
I'm going for about 240 pallets so I can work out the area they'll cover and the overall height of the 'tower' if I play around with different configurations, etc..
Originally I was told to use 622 pallets but after sketching that out I decided that might be just a little too big ๐
Re: ๐๏ธ August 2025 Challenge - One Tool, Many Uses!
Probably a few people doing something similar, and we are using Revu at a much smaller scale than most, but here is probably the biggest time saver I have put in practice so far:
- Export submitted & scheduled Terminal Unit Performance (normally hours of manual input to our forms) as excel chart
- Paste values onto a preset template that gathers submittal and schedule, runs preset comparisons, highlights mismatches, calculates FPM, etc
- Unfreeze xlookup formulas (frozen on the master form to facilitate dropping into other books, just a # in front of the formula) with a VBA macro
- Now typing in terminal unt tag will pull info such as setpoints, coil data, sizing into the relevant sheet
- Remove Xlookups from entire book with VBA Macro and replace with values. Now it is just values in named cells and usable for other macros that total or move data between sheets.
Re: Excel Spreadsheet Integration
Your very best bet, as @Isaac.Harned said is to export your markups as a .csv file then to let Excel do its magic.
My main issue with Quantity Link is that it only brings in measurements, not any additional data you may want that you have in custom columns. It can also be a pain to set up if you use Spaces because you can't simply create a template.
Once its in a csv file, my go to at that point is Power Query. Its already in Excel under the Data tab, so there's nothing new to buy. There is a learning curve though.
I would suggest starting with someone like (all on YouTube) Leila Gharani at XelPlus or Mike Girvin at ExeclIsFun or Mynda Tracey at MyOnlineTraing Hub. These three have excellent beginner level videos for Power Query.
If you're wanting to take an entire course, I would suggest Skillwave Training's Power Query Academy.
There are also several very good books on the subject. (M is for Data Monkey has been the starter book for most of the current MVP's if that tells you anything).
Power Query will change the way you look at and use Excel.
Re: Excel Spreadsheet Integration
I would also change your Text boxes to Count tools, after all that's what you're doing anyways. You can assign each one a specific Subject and a Label as well as various attributes.
You can also use Spaces to create an assembly. When you drop your tools inside the Space, Revu will automatically sort them within that Space. (I'll actually be demonstrating this in the next CANBug meeting, so sign up ๐)
Populating PDF form fields from Excel is something reserved for JavaScript. It's doable, you just have to know what you're doing. That one I'll leave with @Isaac.Harned as he's WAY better at JavaScript than I am.
Re: Have search results center on screen
I appreciate you posting about this issue. Definitely would streamline the search review process when there are multiple search results.
Re: Have search results center on screen
Good idea. Don't know why this wouldn't have been how it was designed to function to begin with โบ
RickO
Re: Have search results center on screen
Oh yes! I canโt stand having to squint just to find search results. We already have the option to โZoom Fit Markups when selected" there should absolutely be a similar option for search results.
Re: Excel Spreadsheet Integration
You will probably want to go one of two routes. Either export your markups list as CSV and use Excel Visual Basic coding (AI LLM's are you're best frined) to clean the data to simple quantities, then use a lookup table to match and place, OR @Doug McLean has some more advanced workflows involving power query which can have a preset cleaning process. Both are somewhat similar, but it probably more depends on if you are just catching simple totals, or if you are getting an extensive amount of data from them.
You may also see the quantity link process, but this would take manually setting up the link to each cell every time you go to a new file. Typically I do not recommend this route, but who knows what improvements will be added over time to this.








