Walsin Export Missing Values: Four Spellings of No Value, and a Blank Test Misses 292 Unknown Cells in Three Families

Walsin export missing values are written four ways: a blank cell, N/A, a hyphen and NA. We counted every cell in the eight families: 131,968 of 3,674,610 carry no value. A blank-cell test finds 131,676 of them and misses 292, including all 154 unknown cells in the antenna file.

Venatech Limited, an authorised Walsin distributor in Hong Kong, holds all 203 parametric export files published by Walsin Technology (Walsin). This post is written from one copy of each family’s data: the 64 chip resistor files, the 11 thin film files, 00_ALL_MLCC_parts_combined.xlsx, Walsin_Inductor_ALL.xlsx, Walsin_MOV_ALL.xlsx, Walsin_DiscCap_ALL.xlsx, Walsin_Antenna_ALL.xlsx and the seven Walsin_ RF files, whose FRESH_ twins are identical. A declared cell is a row times a header. We counted each one as blank, N/A, hyphen, NA or filled, and excluded the Test123999 QA row. Every part number below is real.

How many ways do the eight Walsin families write no value?

Four, and no family uses more than three. We parsed every declared cell in the eight families, 3,674,610 in all, and recorded how each one says that nothing is known. Five families leave the cell blank, the antenna family writes N/A in 154 cells, the chip resistor family writes a hyphen in 125, and RF writes a blank in 997 cells, a hyphen in 12 and NA in one. Thin film writes nothing: 845,226 cells, none unknown.

We have not seen this counted anywhere. The blank test is right in five of eight families, wrong in all three of the others, and wrong by exactly the cells that matter in each: 154 antenna cells that are 35.0% of the antenna file, 125 hyphens in the one chip resistor column that carries a null, and 13 RF cells in two of the seven RF files. We checked for whitespace-only cells in every family and found none, so a trimmed comparison changes nothing.

The two figures that look alike are not the same. Disc capacitor at 45.45% is 5 of its 11 columns blank on every row, and varistor at 30.00% is 3 of 10. Those are whole columns missing, not scattered holes. MLCC and RF mix both.

What does N/A hide in the antenna export?

A third of the file, in six of its ten columns. We read Walsin_Antenna_ALL.xlsx cell by cell. It holds no blank cell at all, and 154 of its 440 cells say N/A: 42 of 44 rows in Inductance Value, 42 in Resistance Value, 38 in Connector 2, 16 in Connector 1, and 8 each in Peak Gain and Voltage Standing Wave Ratio. The other four columns are filled on all 44 rows.

The eight Peak Gain and VSWR cells are not random. They belong to the NFC antenna, the WPC antenna, three cable assemblies and three connectors, rows for which a gain figure does not apply. A filter that treats N/A as a value will tell you eight parts have a gain of “N/A”, and a numeric filter on gain will either drop them or fail on them. For antenna selection by band, see sub-GHz antenna selection; we hold no datasheet for any antenna part, so everything here describes the export and nothing more.

Why does one hyphen column in 2.3 million chip resistor cells matter?

Because it is the only unknown value in the largest family. We read all 2,348,150 declared cells in the 64 chip resistor files. None is blank. 125 hold a hyphen, every one in the TCR column, in 7 files, and 125 of the 126 zero-ohm and 0 dB rows carry it. The one exception is WF10P000 PTL, a high-power jumper that states ≦±100.

The hyphen is therefore a zero-ohm marker, not a missing measurement. 74 of the 125 are in Thick_Film_General_Purpose_Jumper.xlsx, 32 in Thick_Film_High_Power_Chip_Resistor_Jumper.xlsx, 12 in Thick_Film_Chip_Resistor_Array__1of1.xlsx, 4 in the anti-sulfuration array file and one each in the attenuator, network and one-fifth-watt jumper files. The attenuator row is WA04P000XPTL: 0 dB, 0402, 1/10 W, a tolerance cell reading Jumper and a TCR cell reading -.

124 of the 125 hyphen rows also sit on a part number with an embedded space, such as WF04A000 PTL. A jumper therefore fails twice: the code will not paste, and the TCR will not parse. For what a zero-ohm part is rated for, and why the space is there, see zero-ohm jumper chip resistors: what the high-power line is rated for.

Which columns are declared and blank on every row?

Eleven, in three families. We counted the cells in each column, family by family, and listed the ones with no filled cell at all. Eleven columns are blank on every row of their file. They hold 77,860 of the 131,968 no-value cells, 59.0% of all of them.

The RF line is worth a second look. In Walsin_BAW_Filter.xlsx the missing second-band impedance is blank, and in Walsin_SAW_Filter.xlsx it is a hyphen, so one gap carries two spellings by filter technology. We covered that split in SAW against BAW filter selection. SL0AH150J060, a 15 pF disc capacitor, and SR180K05D, an 18 V varistor, show the opposite case: their Packing, SPQ and MOQ cells are blank, and no spelling is needed because nothing was ever there.

What should a missing-value filter test for?

A list of spellings tested column by column, not a blank test. We counted 131,968 unknown cells in 3,674,610, and a blank test misses 292 of them in three families. Four rules follow from the counts.

1. Treat N/A, - and NA as no value, per family. The antenna family needs N/A; chip resistor and RF need the hyphen; one RF cell needs NA.
2. Test the whole column before offering it as a filter. Eleven columns are blank on every row, and a filter on any of them returns nothing.
3. Do not read a filled cell as a known value. 154 antenna cells and 125 chip resistor cells are filled and unknown.
4. Read thin film as complete. Across 845,226 cells it writes no unknown. That is a fact about the file, not a promise about the part.

We hold 28 Walsin datasheets, 451 pages, covering 26 MLCC and 2 chip resistor series, and none for thin film, inductor, varistor, disc capacitor, RF or antenna. Where a cell here is blank or N/A, the datasheet may state the value, and we will not guess it for you. Our free cross-reference tool shows a missing field as missing. What is in Hong Kong is on ready stock: 1,125 part numbers as at 23 September 2026, a dated snapshot and not a live feed. The antenna range is on the antenna page.

The short version

Walsin writes no value four ways: blank, N/A, a hyphen and NA. Of 3,674,610 declared cells, 131,968 are unknown, 3.59%. A blank test finds 131,676 and misses 292: 154 N/A cells that are 35.0% of the antenna file, 125 hyphens in the chip resistor TCR column and 13 RF cells. Eleven columns in three families are blank on every row and hold 59.0% of all the unknown cells. Thin film writes none. We will not tell you a field is filled because the cell is not blank. We will show you what the cell holds. Qualification stays with you.

Send us the filter you run over a Walsin export and one row with a gap in it, and we will tell you whether it counts that gap. And a question back: when your antenna selection returned a gain for a connector, what did it think the cell meant?

Frequently asked questions