Files iTurns an RA Workshop client quote PDF into Jada's quote forms.The three forms
- No pricing (file ends "n-o"): every item with its drawing and options, no item prices. The summary keeps the quote totals.
- With pricing (ends "$"): adds each item's price box and the totals on the first page.
- Record set (ends "$-record set"): the priced form with each item's BOM rows from the BOM export after it.
LayoutThe cover and the terms pages are copied from the quote. The quote's tax is used.BOM checkFor the record set, each item's BOM total is compared with its quote price (including its added lines). Differences of $1.00 or more are highlighted in amber in the PDF and listed under Notes.
Client quote PDF iThe RA Workshop "Client Quote" PDF. Choose it or drop it on this box.
No PDF chosen
BOM export (.xlsx) iThe Priced BOM Export for the same quote (sheet "Priced BOM"). Needed for the record set only. Choose it or drop it on this box.
No spreadsheet chosen
No pricingends "n-o"
With pricingends "$"
Record setends "$-record set"
All 3 formsone click
Forms iThe forms made from these files. Download each one, or all of them at once.
| Form | File name | Pages |
|---|
Notes iThe record set's BOM check: each item's BOM total (Final Selling Price) against its quote price. Rows in amber are highlighted the same way in the record set PDF.
| Item | Unit | Quote price | BOM total | Difference | BOM rows |
|---|
Files iTurns a Glass Panel PDF into a filled GB Template quote: one line per glass panel, with lites and spacers from Glass TYPES and SDL bars counted from each drawing.What it fills
- Header: Project Name (client), Project Number, Project Address.
- Each glass panel from row 17: Production Order No., Mark, Glass Description, Symbol (the text before the dash, e.g. D17), Product Type (the text after it), Argon/Air, Width and Height to the nearest 1/16", SqFt, Qty, O.A.
- Lite 1 to Lite 5 and spacers, looked up in Glass TYPES by the code in the first parentheses.
- SDL horizontals and verticals, counted from each drawing. You can check and correct every count before downloading.
- Shapes, read from each drawing: angled straight edges make a Rake, Double Rake or Triple Rake; any curved edge makes a Single Radius, or Multi Radius for two or more; a full circle is a Circle. Rectangles stay blank.
- Screen mesh pages are skipped. Edge Notches stays blank for now.
Glass Panel PDF iThe PDF from the quoting program, one glass panel per page. Choose it or drop it on this box.
No PDF chosen
GB Template iA copy of the GB Template is built in. Replace it when the template changes; the app writes into the Inputs sheet and keeps everything else.
Built-in
Glass TYPES iA copy of Glass TYPES is built in. Replace it when the workbook changes; lites and spacers are looked up by the code in the first parentheses.
Built-in
Ask Claude iAsk about this job, the quote, or how the app works. Claude can also change SDL counts and shapes for you, e.g. "Set 057-B to Double Rake".
Review iCorrect an SDL count or a shape in its box before downloading. Click a drawing to enlarge it. Use the slider to scroll the columns.
◀
▶
| Drawing | Mark | Symbol | Product type | Glass code | Width × Height | Qty | O.A. | SDL H | SDL V | Shape | Notes |
|---|
Files iFills the NFRC Worksheet (Core Data tab) from a Glass Order PDF and a Glass Panel PDF: one row per lite.What it fills
- B1 Project Name and B3 Quote, from the Glass Order.
- Item# (the number part of the Mark, e.g. 001), Symbol (the text before the dash, e.g. D17) and Lite# (the full Mark, e.g. 001-D).
- Glass Description, without the $ sign and the code in ( ) at the end.
- Lite Wdt, Lite Hgt and Lite sqft, 2 decimals.
- Grid Bars as #H#V, counted on each Glass Panel drawing (e.g. 4H1V, or 0H0V for none), and SDL/TDL: SDL when there are bars, n/a when there are none.
- Screen pages are skipped. K-Type, Product Type and Sash sizes are left blank for now.
How it readsThe Glass Order PDF is a picture of each page, so the app reads it with text recognition, by row name. Sizes, symbols and descriptions are checked against the Glass Panel PDF, and any difference is listed for review.DownloadA copy of the NFRC Worksheet named with the quote code and project name. If that name was downloaded before in this browser, the next one gets V2, V3 and so on.
Glass Order PDF iThe Glass Order PDF: summary pages, then two pages per lite. Choose it or drop it on this box.
No PDF chosen
Glass Panel PDF iThe Glass Panel PDF for the same job, one glass panel per page. Used to count the horizontal and vertical bars and to check each lite. Choose it or drop it on this box.
No PDF chosen
NFRC Worksheet iThe blank NFRC Worksheet stays here for every job. Replace it when the worksheet changes; the app writes into the Core Data tab and keeps every other tab as it is.
Built-in
Review iLines marked in amber have something to check. Correct a Grid Bars count in its box (format 4H1V) before downloading; SDL/TDL follows it. Click a drawing to enlarge it.
| Drawing | Item# | Symbol | Lite# | Glass Description | Lite Wdt | Lite Hgt | Lite sqft | SDL/TDL | Grid Bars | To check |
|---|
Quotes iCompares an old quote with a new one: items added, removed and changed, and the dollar impact.FilesEach side takes a quote PDF (RA record set, RA proposal or V6 proposal), a Priced BOM Export, or both. With both on a side, the BOM export gives exact line prices and the PDF gives unit names, sizes and quoted prices.How it comparesWith BOM lines on both sides it shows every line that moved. Otherwise it compares item by item: price, quantity, size and symbol. Item numbers match with leading zeros ignored (V6 "1" = RA "001").
Old quote
Quote PDF: record set, RA proposal or V6 proposalNone chosen
Priced BOM Export (.xlsx)None chosen
New quote
Quote PDF: record set, RA proposal or V6 proposalNone chosen
Priced BOM Export (.xlsx)None chosen
Changes
| Item | Status | Unit | Changes | Original Price | Revised Price | Difference | Notes |
|---|
Quote Totals
| Line | Original | Revised | Difference |
|---|
BOM Detail
| Component | Code | Status | Description | Unit | Original Qty | Revised Qty | Original Unit Price | Revised Unit Price | Original Amount | Revised Amount | Difference | Details |
|---|
To Check
| Item | Issue | Detail |
|---|
Record set iChecks the pricing in a Record Set Quote PDF.What it checks
- Every BOM line has a Value and a Total Cost above $0. Lines at $0, negative, or blank are listed.
- Every item's BOM lines add up to its Item Total.
- Every shaped unit has a priced Shape charge. A unit counts as shaped when its Shapes line names a shape, or when its drawing shows a non-rectangular lite. Each shaped section needs its own priced Shape base charge (quantity counts, so a K11 Shape base of 2 covers two fixed arches).
- Units whose drawing shows a shape but whose Shapes line says No Arch or Rake are listed too.
Record Set Quote PDF iThe record set quote exported from the quoting program, with an item page and BOM for every unit. Choose it or drop it on this box.
No PDF chosen
Results
Needs review
| Item | Unit | Check | Issue | BOM line | Value | Total Cost | Page |
|---|
Shaped units checked
| Drawing | Item | Unit | Shapes line | Shape lines in the BOM | Result |
|---|
Workbook iLists what changed between the OLD and NEW sheets of one workbook.How it compares
- Rows are matched by the first column whose values are filled and unique on both sheets, like BOM Version Code.
- Every value that differs on a matched row is listed, with the change in dollars for the price column.
- Rows only in NEW are Added, rows only in OLD are Removed, and rows that NEW marks "Deleted" are listed as Deleted.
- A column that changes on every row (like Quote Version) is noted once at the top instead of row by row.
- Total rows, filter notes and blank rows are skipped.
DownloadThe same workbook comes back with a new Differences sheet after OLD and NEW. Your OLD and NEW sheets are not changed.
Excel workbook (.xlsx) iOne workbook with a sheet named OLD and a sheet named NEW. If the names differ but there are only two sheets, the first is treated as OLD. Choose it or drop it on this box.
No workbook chosen
Differences
Files iPicks out the items that use standard mullions, for structural engineering review.How it works
- Quote items are matched to the BOM by item number (Component Code).
- Each BOM line is matched loosely to the Standard Mullions list: COMBO, Extended Fin 4/7, Extended Tube 4/6, Concealed Tube and the MULL-28xx / 29xx profiles with their FIN variants. "PZ2952-m" counts as MULL-2952 and "Xtend" as Extended.
- Each mullion is listed once per item with its total Ln Ft (Base lines give the mull count). When a mullion shows on a $ line and a part line, the $ line is used.
- When it isn't clear whether two lines are the same mullion, the item asks you to choose. Open questions print as CLARIFY.
- Only items with mullions are included.
DownloadsA PDF for engineering (summary, each drawing with its dimensions and item number, the mullion list, and the Standard Mullions list at the end) and a spreadsheet with the same rows and drawings.
Quote PDF iThe quote PDF with an item page and drawing for every unit. Choose it or drop it on this box.
No PDF chosen
BOM spreadsheet (.xlsx) iThe Full BOM Export for the same quote, with Component Code, BOM Code, BOM Description and Quantity With Loss columns. Choose it or drop it on this box.
No spreadsheet chosen
Review iAnswer any questions in amber before downloading; open ones print as CLARIFY. Click a drawing to enlarge it.
| Drawing | Item | Unit | Size | Mullion type | Mulls | Total Ln Ft | To clarify |
|---|