Retrieve Sensor Analysis Table

Somewhere to ask questions about the best way to use SharpCap
Forum rules


If you have a problem or question, please check the FAQ to see if it already has an answer : https://www.sharpcap.co.uk/sharpcap-faqs
Post Reply
wcblack7
Posts: 26
Joined: Fri Nov 02, 2018 6:05 am

Retrieve Sensor Analysis Table

#1

Post by wcblack7 »

Hi All,
I've lost my spreadsheet where I had saved the sensor analysis data table for my cameras.
I'm referring to the data table that you can copy and paste once a sensor analysis is completed.

Is there anyway to retrieve the data table again after you close the sensor analysis window?
I'm sure all of that data was stored in the sensor characteristic files, which I still have.

Thanks!
Bill
User avatar
turfpit
Posts: 1779
Joined: Mon Feb 13, 2017 8:13 pm
Location: UK
Contact:

Re: Retrieve Sensor Analysis Table

#2

Post by turfpit »

Bill

Have a look at this viewtopic.php?t=532


Dave
wcblack7
Posts: 26
Joined: Fri Nov 02, 2018 6:05 am

Re: Retrieve Sensor Analysis Table

#3

Post by wcblack7 »

Thanks Dave.
Yes, I still have those sensor characteristic files. What I'm wondering is how to extract the data from those files in human readable form, like the results table you get at the end of the sensor analysis... see below:

Gain Value e/ADU Read Noise (e) Full Well (e) Relative Gain Rel. Gain (db) Dynamic Range (Stops)
0 5.186115404 3.270309471 21242.3287 1 0 12
59 2.673852714 2.438189198 10952.10071 1.939566595 5.754093916 12
61 2.736228021 1.803342943 11207.58997 1.895352056 5.553797813 12
100 1.860745036 1.579277173 7621.611669 2.787117688 8.903106151 12
119 1.503897272 1.487110329 6159.963225 3.44845057 10.7524801 12
121 1.473403393 1.472140455 6035.060297 3.519820457 10.93041022 12
200 0.544962665 1.097998796 2232.167077 9.516459998 19.56950853 10.98935283
300 0.17334152 0.916160425 710.0068653 29.91848352 29.51879153 9.598017015
400 0.055351665 0.82230818 226.7204202 93.69393669 39.43422974 8.107019441
500 0.017635393 0.703769096 72.23457011 294.0742731 49.36914064 6.681443476
User avatar
turfpit
Posts: 1779
Joined: Mon Feb 13, 2017 8:13 pm
Location: UK
Contact:

Re: Retrieve Sensor Analysis Table

#4

Post by turfpit »

Bill

The sensor files are .json format. Sites like https://json-csv.com/ allow conversion to .csv which can be handled by spreadsheets.

I think that is what you are after?

Dave
wcblack7
Posts: 26
Joined: Fri Nov 02, 2018 6:05 am

Re: Retrieve Sensor Analysis Table

#5

Post by wcblack7 »

Cool... thanks Dave!
I think that will work.
Bill
Post Reply