DrDAQ resistance to 2decimals in excel example

chrissalon · Post by **chrissalon** » Wed Dec 23, 2015 12:54 pm

How can one get the reading of the resistance to 2 decimals.
I get rounding off. A value of 2.538 in Picolog give 2.00 in the excel example that comes with SDK.
Is it driver related or the way it is declared? When I covert the VBA to Xojo I also get 2.00.
In one of the forum post one explains the resistance problem but I assumed it is fixed as Picolog gives the right value.

Glovisol · Post by **Glovisol** » Tue Dec 29, 2015 7:40 pm

chrissalon wrote:How can one get the reading of the resistance to 2 decimals.
I get rounding off. A value of 2.538 in Picolog give 2.00 in the excel example that comes with SDK.
Is it driver related or the way it is declared? When I covert the VBA to Xojo I also get 2.00.
In one of the forum post one explains the resistance problem but I assumed it is fixed as Picolog gives the right value.

Dear Chrissalon. please go here

topic15421.html

and to related posts before and after and you will find several ways to read resistance with two or more decimals.

glovisol

chrissalon · Post by **chrissalon** » Sun Jan 03, 2016 12:13 pm

Thanks for your response Glovisol.
I looked at the posts but they don't answer my query. Maybe I did not phrase it right.
I want to read the resistance using VBA in excel.
Call UsbDrDaqGetSingle(handle, 6, value, overflow)
This returns in 1K readings not 1.250K or 1250 ohms.
I am using the current driver from the PicoSKD.
Am I using the right Call function?

Post by **Hitesh** » Mon Jan 04, 2016 10:47 am

Hi chrissalon,

Please use the UsbDrDAQGetSingleF function as defined in the usbDrDaqApi.h header file in the SDK:

Code: Select all

PREF0 PREF1 PICO_STATUS PREF2 PREF3 (UsbDrDaqGetValuesF) 
	(
	   int16_t handle,
	   float	 *values,
	   uint32_t *noOfValues, 
	   uint16_t *overflow,
	   uint32_t *triggerIndex
	);

You will need to add this function definition to your VBA code. The parameters are the same as the UsbDrDaqGetValues function but the values are returned as floating point numbers.

Edit: The dll should be available through SDK version 10.6.10 or later.

Regards,

chrissalon · Post by **chrissalon** » Mon Jan 04, 2016 12:21 pm

Thanks for your support Hitesh,
Function works well in VBA and in fact works well using Xojo Programming.
(see my previous post (DrDaq Access using VB).
Much appreciate your feedback.
Regards,

Test & Measurement Forum

DrDAQ resistance to 2decimals in excel example

DrDAQ resistance to 2decimals in excel example

Re: DrDAQ resistance to 2decimals in excel example

Re: DrDAQ resistance to 2decimals in excel example

Re: DrDAQ resistance to 2decimals in excel example

Re: DrDAQ resistance to 2decimals in excel example