Author Topic: Multimeter spreadsheet (80 manufacturers and over 400 meters listed)  (Read 575294 times)

0 Members and 2 Guests are viewing this topic.

Offline MrCreosote

  • Contributor
  • Posts: 23
  • Country: us
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #400 on: March 07, 2017, 01:05:41 am »
Suggest OWON B35T+ and B41T+ which are crazy cheap onboard data loggers w/BlueTooth that seems to work.

Any chance of adding a "Make" or "Manufacturer" column to facilitate spreadsheet sorts?   (If these tables were not being continuously updated, I'd do it myself.  But I guess I'm too lazy to do it every time you update.  My bad.)

I threw together a crude Excel formula to populate a Make column inserted at the beginning:  formula for row2, column1:

=IF(B2="","",IF(A1="",B2,A1))
« Last Edit: March 08, 2017, 03:05:16 am by MrCreosote »
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #401 on: March 08, 2017, 10:13:02 am »
Owon B35 is in already.

Here is the same file, modified for easy filtering:
 
The following users thanked this post: kostasb

Offline MrCreosote

  • Contributor
  • Posts: 23
  • Country: us
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #402 on: March 09, 2017, 04:41:10 am »
Thanks for the sortable version.

FYI,

The OWON B35T and B35T+ are substantially different. 

The "+" indicates onboard data logging - other wise a PC or BlueTooth device is needed to log.

The "T" means True RMS.

The 35 is a 3.5 digit display and the B41T+ is a 4 digit.
 

Offline jorgcr

  • Newbie
  • Posts: 2
  • Country: cr
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #403 on: March 23, 2017, 02:43:34 am »
Hi, I'm new here. I've seen Dave's videos on yt. I'm en electronic engineering student, and I need a digital multimeter, I've tried to look for several options but I don't know which to buy, my budget is around $200 and I was even saving for a Agilent (keysight) U1273A, a friends has one and it looks and works really well but the price is on >$400 and I need the multimeter more than I'm quick enough to save money, you know how it is beng student.

I've heard Ketsight and Fluke are the top of the line on dmm, a professor even told me he have had a Fluke for more than 20 years before he lost it but with a high reputations comes a high price. As I was saying I study electronic engineering, I also work with arduino and (I would like to) raspberry pi.

I guess besides the basic functions like measuring voltage, current, resistance, continuity, I would like to measure capacitace, and some sort of other values, again, I'm not very 'into' multimeter's world so I don't know what I would need in the future. With that budget what can you guys (and girls out there) recommend me?
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #404 on: March 23, 2017, 03:23:36 pm »
At about 200$, the UNI-T UT171B is full featured and pretty good value for the price, if you can't find a decent second hand Fluke 87V in the US for that price.

http://www.ebay.com/itm/UNI-T-UT171B-Industrial-True-RMS-Digital-Multimeters-EBTN-Display-UT-171B-/332001203179?hash=item4d4cd053eb:g:qfQAAOSwPCVYAZAJ

Sorry, just found out that this seller doesn't ship to Central America!



« Last Edit: April 24, 2017, 06:27:11 am by Wytnucls »
 

Offline jorgcr

  • Newbie
  • Posts: 2
  • Country: cr
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #405 on: March 25, 2017, 10:23:15 pm »
Don't worry, if it is available on the USA I could sent the order to Florida and my foward dealer can ship it to my country.
 

Offline electricMN

  • Regular Contributor
  • *
  • Posts: 73
  • Country: us
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #406 on: March 30, 2017, 05:27:45 pm »
Thanks for all the work you do to maintain the spreadsheet. It was invaluable for me in making my decision to get a Brymen BM869S DMM.  :-+
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #407 on: March 30, 2017, 08:27:12 pm »
Glad you found it useful. Enjoy your new toy.
 

Offline evava

  • Regular Contributor
  • *
  • Posts: 160
  • Country: cz
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #408 on: April 17, 2017, 11:58:36 am »
UNI-T UT 181a:
has actual resolution 1uV (AC and DC), not 10uV as in spreadsheet.

Thank you for your work!
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #409 on: April 17, 2017, 02:59:22 pm »
Yes, it has a 60mV range. Thanks for the correction.  :-+
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #410 on: May 08, 2017, 11:58:18 pm »
The last file was downloaded a thousand times.
That's as good a benchmark as any to release the latest one, or rather latest ones, as I had to split the file to circumvent the 1000KB limit for attachments.

As always, some new meters and some corrections.

The bench meter file has a new column to cater for DC current accuracy.
Often, meters with high DC volt accuracy, disappoint when switched to their DC current range.
The published accuracy figures are entered in the column, with a cell color coding based on their low current nA accuracy.
« Last Edit: May 12, 2017, 09:38:36 am by Wytnucls »
 

Online rsjsouza

  • Super Contributor
  • ***
  • Posts: 4868
  • Country: us
  • Eternally curious
    • Vbe - vídeo blog eletrônico
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #411 on: May 09, 2017, 03:42:46 pm »
Wytnucls, I am one of the spreadsheet fans and it is a welcome news to split it between the Bench/HH.

I believe in contributing to lighten the load, therefore I am working to add the specs for the Racal dana 5001 (and maybe 5002) and will send you details later today or tomorrow.
Vbe - vídeo blog eletrônico http://videos.vbeletronico.com

Oh, the "whys" of the datasheets... The information is there not to be an axiomatic truth, but instead each speck of data must be slowly inhaled while carefully performing a deep search inside oneself to find the true metaphysical sense...
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #412 on: May 09, 2017, 05:20:28 pm »
Thanks. Any contribution is welcomed. Especially for older equipment, as the relevant manual or datasheet is often difficult to locate.
« Last Edit: May 09, 2017, 05:22:09 pm by Wytnucls »
 

Offline nugglix

  • Regular Contributor
  • *
  • Posts: 209
  • Country: de
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #413 on: May 09, 2017, 07:19:02 pm »
Any hints on why the new sheets are locked?
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #414 on: May 09, 2017, 07:59:04 pm »
Mostly for legal reasons.
For the user, it shouldn't matter, as all the information is still there.
 

Offline nugglix

  • Regular Contributor
  • *
  • Posts: 209
  • Country: de
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #415 on: May 09, 2017, 08:56:09 pm »
Legal reasons?
An explanation would have been nice.

And btw, one can't even mark rows or columns anymore.
Given the dimensions of the tables this make the use much harder.
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #416 on: May 09, 2017, 09:52:29 pm »
Download the files again and you will be able to select cells, rows and columns.
Change of plan: Cells, rows and columns are locked again. Sorry for any inconvenience.
« Last Edit: May 12, 2017, 09:43:11 am by Wytnucls »
 

Offline lypse

  • Contributor
  • Posts: 30
  • Country: dk
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #417 on: May 27, 2017, 09:53:46 am »
Wytnucls, would it be a lot of work to replace/add the fuse section with information if the meter has independent tests to verify the CAT rating?
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #418 on: May 27, 2017, 10:00:40 am »
There is a column (UL) already for UL, GS, CSA listings (3rd from last).
I will move it closer to the CAT rating for better readability.
The claimed CAT rating is greyed out for meters with no independent listing.
« Last Edit: May 27, 2017, 02:05:54 pm by Wytnucls »
 

Offline lypse

  • Contributor
  • Posts: 30
  • Country: dk
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #419 on: May 27, 2017, 02:31:25 pm »
There is a column (UL) already for UL, GS, CSA listings (3rd from last).
I will move it closer to the CAT rating for better readability.
The claimed CAT rating is greyed out for meters with no independent listing.
Ah I missed that. thanks :)  :-+

I will post pictures of the UT195DS if I receive it before Tuesday :)
 

Offline justyn

  • Newbie
  • Posts: 4
  • Country: gb
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #420 on: June 08, 2017, 05:01:06 pm »
I'm in the market for a DMM and these spreadsheets are incredibly useful, thank you.

I think there may be a slight mistake in the U1241C/U1242C specs - the uA is listed as "10nA" but in the datasheet the resolution is listed as 0.1µA, unless I am reading something incorrectly, which is possible.

EDIT

It looks like the specs changed between some datasheet revisions.

The above figure is 0.01µA in a datasheet that states that it was "Published in USA, October 20, 2015" whereas in the datasheet currently on keysight.com, which states that it was "Published in USA, February 17, 2017" the figure is 0.1µA.

Presumably the latest, reduced resolution figure is the correct one.

EDIT2 meant resolution, not accuracy
« Last Edit: June 09, 2017, 02:03:17 pm by justyn »
 

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #421 on: June 09, 2017, 08:37:12 pm »
Thanks. The correction will appear in the next edition.
 
The following users thanked this post: PowerNet

Offline dtmr_e

  • Newbie
  • Posts: 1
  • Country: de
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #422 on: June 13, 2017, 08:31:09 am »
> Change of plan: Cells, rows and columns are locked again. Sorry for any inconvenience.

Locking tables is utterly pointless. They can be unlocked with a text editor: Load spreadsheet into OpenOffice, save with ods extension, replace extension with zip, unpack zip, load content.xml into text editor, locate protection="true" (there might by more than one), replace with protection="false". Great protection, isn't it? Then save content.xml, repack as zip, restore .ods extension.
 
The following users thanked this post: gwideman, nugglix, sylvandb

Offline Wytnucls

  • Super Contributor
  • ***
  • Posts: 3035
  • Country: be
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #423 on: June 13, 2017, 10:33:39 am »
You registered to post a crack for a Microsoft product protection. Way to go.
If you had any respect for my work, which is available for free, you would have had the decency to warn me through a private mail.
Any protection can be defeated eventually, if someone puts enough effort into it. So be it.
 

Offline cjs

  • Contributor
  • Posts: 41
  • Country: jp
  • Software geek
Re: Multimeter spreadsheet (38 brands and 210 meters listed)
« Reply #424 on: July 01, 2017, 12:50:03 am »
Actually, to be honest I hadn't even noticed the protection at all because I just uploaded the spreadsheet to Google Drive and opened it with Google Sheets which lets me edit it freely.

I don't know for sure why you want it protected, but my guess is that you're worried about modified copies with the same filename floating around? (Clearly that could be a bad thing for everyone.) To defend against that you might consider distributing your master reference document as a Google sheet that's world readable. Anybody looking at it via the URL knows that they're looking at the original copy, and and anybody who wants an offline or editable copy for whatever reason can download a copy in Excel or CSV format.
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf