01
Who it’s for
An engineer in a SAR test lab who needs to know which unit ran a test.
A test lab · live
Which unit ran that test? Ask the table instead of scrolling it.
For an engineer in a SAR test lab who needs to know which unit ran a test. Until now they scrolled through the band sheets of the master test table to find the sample number.
Windows, offlineLive · privateVersion 3
Master SAR Test Table (sample).xlsx
Select, copy, paste into box 4. Or drag the selection.
No file loaded
1. Band(s)
2. Test Position(s) — type to filter:
3. Dist. (mm)
(none selected = any)
4. Hot Unit(s) — paste to check
one per line (or comma-separated);
leave empty to skip the check
leave empty to skip the check
| Band | Test Position(s) | Dist. (mm) | RB Allocation / Channel | Freq. (MHz) | Sample no. | Hot Unit Match |
|---|
Open the SAR test table workbook to begin.
Master SAR Test Table (sample).xlsxExcel workbook
File name:
i
Copied to clipboard
A simulation with a made-up workbook: invented bands, positions and sample numbers. It is not the lab’s tool or data. Lists work like Windows ones: click, Ctrl or ⌘-click, Shift-click, arrow keys, Ctrl+A.
What it’s for
Four parts, plainly.
02
By hand, until now
They scrolled through band sheets in the master test table to find the sample number.
03
What I built
An offline Windows app: open the master workbook, choose bands, positions and distances, and it lists the matching sample numbers. You can paste unit numbers to see which are matched or not found, and copy the results into Excel.
04
Where it is
Live and private: a standalone Windows app, version 3.
Rough edges
What it doesn’t do yet.
- Lookup onlyShowing which units are currently tied up in testing is planned, not built.
- Main table onlyIt searches only the main test table, not the repeated or spot-check sections.
Honest line: a small tool for one question. It is private, so there is no download or code link.