Has anyone used Open Office's spreadsheet?
I don't have excel - and it's a chore to get Benchview
on this old computer, only to find that it won't work.
@IanJ
Hi I got excited when I saw your post as I have wanted to get some data logging on my HP3456A for some time. I have an Agilent 82357B.
However, Win 10 refuses to recognise the 82357B at all. My other PC, a laptop with Win XP recognises the 82357B but crashes on running the spreadsheet (Excel 2007). I tried both the original and final versions of your spreadsheet. Help.
enut11
Have you installed the driver for 82357B? The driver is available in Keysight IO Libraries Suite:
http://www.keysight.com/en/pd-1985909/io-libraries-suite?nid=-33330.977662.00&cc=DE&lc=ger&cmpid=zzfindiosuite
@IanJ
Hi I got excited when I saw your post as I have wanted to get some data logging on my HP3456A for some time. I have an Agilent 82357B.
However, Win 10 refuses to recognise the 82357B at all. My other PC, a laptop with Win XP recognises the 82357B but crashes on running the spreadsheet (Excel 2007). I tried both the original and final versions of your spreadsheet. Help.
enut11
Yes, it doesn't look like you have the drivers loaded/available to the 82357B. It's a 900mb download of which the drivers are just a few mb.
Before you open the spreadsheet wait until the 82357B has just one green LED lit.
Worth also checking the address of your 3458a matches the spreadsheet.
If I can get my 3458a back up and running tonight then I'll have a new version of the spreadsheet to upload.
Ian.
Can you add to log the internal temperature with each reading
OK, I just tried your version 10 for the first time
The Keysight I/O library was installed, so the USB adapter was found without problems
As soon as I opened up your Excel file and enabled editing and hit start, all worked well and the collection of data started.
No changes made to the settings
A few observations so far:
- Once in a while I get "Syntax Error" listed in the Last Error Message but then it continues with the next reading
- Every time I hit the start button, the first reading is copied to the Error Registry (decimal): spot and just stays there.
- If I set the NPLC: to 100 the software hangs and does nothing and does not recover and requires a restart of the Excel Macro
- In your Value column I see a value with lots of additional zeros and a wrong decimal place
- Current Value is not showing any value, just ####
Improvements request
- Can you add to log the internal temperature with each reading
- Can you leave a field to add a string during initialization, may be just below the NPLC entry?
In general it seems to be a great way of storing the data from the 3458A
Try my crude adaptation spreadsheet for 3456A.
(Parameters sheet is not used).
Worked with my Agilent clone adapter.