Glad you figured it out.
I will be the first to admit there may be a better way to present the data in the spreadsheet. If anyone has a way to format it that they feel would make things more clear to the reader, feel free to post it. I am not at all apposed to changing it.
I had though about moving the original round I tests to it's own page so the main page just has the format that I plan to use moving forward.
Can I also say it seems obvious (at least to me) that the thread title has many overlook the excellent work you have done, but maybe not so with the addition of DMM in the title.
This has came up from time to time but no one has offered what they feel is a better suited title.
PS: They're not 'recommendations'. It only measures one tiny aspect of a multimeter (resistance to sparks).
One?
1) Continuity, short detection resistance
2) Continuity, open detection resistance
3) Continuity, short circuit current
4) Continuity, open circuit voltage
5) Continuity, max frequency using a 50% duty cycle before meter misses beats
6) Continuity, min pulse width the meter can detect
7) ESD, 5 +/- transients in each mode using a piezo grill ignitor
DC withstand voltage, meter is supplied its maximum specified DC voltage, sometimes higher
9) 220 VAC line, meter is supplied with a full wave rectified 220V signal with the mode switch being rotated
10) Low voltage low energy surge test, up to 5KV 100us FWHH 2 ohm source, limited to less than 20J
11) High voltage low energy surge test, up to 12KV 50us FWHH 2 ohm source, limited to less than 20J
If I stay with the current format, there are other tests going on as well like basic accuracy, comparing them with other meters in their class or price range. I showed the NCV feature of the UT139C for example. If I continue to test meters, I am sure the test methods will improve along with the tests performed.
And if that is not enough, now we get to see what can happen when some of these crappy meters breakdown with a higher energy source attached. It does not answer the question if a meter is safe or not but for the people who post that the meters were not shown to be unsafe during the tests at sub 20 joules, it does give viewers some indication of what a small amount of energy could do to a meter.
Just an FYI, testing one meter like the 115 where it survives takes about 10 hours not including the editing time.
The Greenlee still took about 8 hours from start to finish.
There are many tests others have done that really do not interest me. Two tests I would like to run are DC temperature drift and RF susceptibility. Both way outside of what I could do at home.
This may help you with your counting skills