Updated Excel Sheet for SubframeSelector expression generation

[bvalente]

Hello all,

I hope this is the right place to put this

i am posting an updated excel sheet that helps automate a lot of the tedious data calculations for determining things like fwhm min/max, eccentricity min/max, etc.

Now you can just load your images into SubframeSelector, Measure, export the data table, and with one button push you can get an expression complete with all your min/max values set properly

the excel sheet is definitely beta, but works great. please make sure to understand and follow the directions on the first sheet

https://www.dropbox.com/s/ytzlt5rwg7usnij/SubframeSelector%20Weighting%20Expressions%20datacopy.zip?dl=0

let me know what you think, i hope you find it useful

it IS an excel macro, so you have to enable macros to get it working

It's based on the work of David Ault regarding using an expression for weighting subframes, and using a spreadsheet to more easily create the expression itself. I've just taken it one click further to automate a lot of the data viewing and entry

If you aren't familiar with this, you can read up on David's blog post here: http://trappedphotons.com/blog/?p=693

Cheers

Brian

[bvalente]

Updated version with check and compatibility for Mac platform

https://www.dropbox.com/s/v0z1fkfo5bujbgl/SubframeSelector%20Weighting%20Expressions%20datacopy%20v1.1.zip?dl=0

[bvalente]

Updated 2.0 version now optimizes the range to use only the approved subframes (make sure to finalize your approved frames prior to outputting the table data)

download here:
https://www.dropbox.com/s/fh5umhkok2u4kxb/SubframeSelector%20Weighting%20Expressions%20datacopy%202.0.zip?dl=0

requires Excel and macro enabled

feedback welcome thanks

Brian

[tdgm]

Using Mac  where is the copy data button???

[bvalente]

Top of  the page.  You need to be using MS Excel


Brian

[FlyingBeagles]

Great Macro / Spreadsheet and many thanks for taking the time to produce and share.

[CharlesW]

As you may have seen, there is a new SFS module that can be installed that is world’s faster than using the script method. But, as far as I can tell, it doesn’t output a CVS file in the same format that your brilliant Excel function requires. Would you mind taking a look at that and see if you could modify your spreadsheet to read this new format? That would be the best of both. Thanks

[RickS]

The new SubframesSelector process has some of these calculations built in which simplifies things a lot.  Here's an example of a weighting formula that I've used (line breaks added to aid the reader):

      80*(1/(FWHM*FWHM)-1/(FWHMMax*FWHMMax))/(1/(FWHMMin*FWHMMin)-1/(FWHMMax*FWHMMax))
      +15*((SNRWeight-SNRWeightMin)/(SNRWeightMax-SNRWeightMin))
      +5*(1-(Eccentricity-EccentricityMin)/(EccentricityMax-EccentricityMin))

Cheers,
Rick.

[guyroch]

Any ideas when a new spreadsheet will be available with a working COPY button with the new SubframeSelector file format? 

[bvalente]

With PixInsight 1.8.2 there is basically no need for the spreadsheet anymore - it's now a process available in general release and does all this for you


Brian

[guyroch]

Thank you Brian... ummm.... but you still have to provide an expression... or I'm I missing something with the new process where you don't need to edit the expression.

[bvalente]

Expressions are all now built into the process - you need to be familiar with expressions within PixInsight, but it's far more flexible and capable now.


Brian

[guyroch]

I guess I must be missing the obvious then.  The measure process measures everything but without an expression the weight value is set to 0 for all images. 

What do you mean by Expressions are all now built into the process?  Where are they and most importantly how does one apply a specific expression, built-in or not?  I'm not seeing much difference in the process where the measurement process produces a table with all measurements but with the default expression being blank the weight column is set to 0 for all images.

Thanks again.

[bvalente]

weighting is also expression based, but to get you rolling here's what I use:

for the filter:

FWHMSigma <1.2 (i'll vary this depending on my data)


for the expression:

35*(1-(FWHM - FWHMMin) / (FWHMMax - FWHMMin)) + 18*(1-(Eccentricity - EccentricityMin) / (EccentricityMax - EccentricityMin)) + 70*((SNRWeight - SNRWeightMin) / (SNRWeightMax - SNRWeightMin)) + 40

essentially this gives a weight that's mostly SNR, some FWHM and a little eccentricity


you can vary the values to weight these differently, but this is what I use (my FWHM is pretty consistent, my SNR varies a lot)


hth


Brian

[bvalente]

here's an example session using those settings (i just grabbed some random images)

https://www.dropbox.com/s/ysimcvzsueweqjc/example_sfs_session.JPG?dl=0


Brian