VVE Copy by Zone Tool

[frzburn]

So I've been reading a lot in the last week while waiting for my MPVI2 in the mail.
I've read multiple posts about issues with erratic values when clicking "Calculate Coefficients" button in the VVE table editor.

So here's my first contribution to the community. Bear with me, it's my first attempt at MS Excel VBA programming and English isn't my first language. It works fine on my laptop, but let me know if you have any issue.

Here's how to use it:

1. Setup the "Zone Info" sheet to be exactly like your VVE table when you check the "Show Zone Numbers" checkbox.
   
   • Using a different color for each zone makes it easier to visualize.
   • Make sure the data actually starts in cell B5 (and that it's the same in every sheet).
   
   
2. Copy the output of your graph in the VCM Scanner to the "Scanner Data" sheet. Again, make sure that your data starts in B5.
   
3. Now here's the most cumbersome part. In the "Zone Data" sheet, you need to define each zone range so the spreadsheet knows were to pull them.
   
   1. Use the "Show zone numbers" button at the top to copy the table you entered in step 1.
   2. Copy the axis labels manually
   3. Under the "settings" columns, to the right of the table, you must define each cell range for each zone. The format is [top-left cell:bottom right cell].
   4. "Table range" is were the data is located, and it must be the same in the three sheets, otherwise you'll get wrong zone data in your table. Triple-check that.
   
   
   
4. With the top dropbox, select the zone you want the data for. The rest of the table is erased and only the specified zone is populated. The whole data range will be selected, so you're ready to CTRL-C it and copy it over your whole VVE table, without having to double check that you're copying it in the correct cells.
   
   
5. Use the "Calculate Coefficients" button in the VVE table editor, and repeat step four for every zones that have data from your graph.

Note: Rename the file to .xlsm extension. It uses macros. I could not upload it with this extension.
VVE_zones.xls



Let me know what you think!

[TriPinTaZ]

Can you help clarify how this is an advantage over just using VVE editor and changing each zone individually and then calculating coefficients? Multiple times on here I had suggested this as a work around if you get bogus calculations. It seems like an extra step and having to set up excel when you can do the same thing natively. Am I missing what you are trying to share with the community? Def not being a wise ass here. I am interested in your contribution.

[frzburn]

It's really just meant to identify and select data zone-by-zone from a graph. Unless there's a better way to do it that I don't know...

Only way I know how to do it otherwise is:

1. Click show zone numbers in VVE
2. Remember axis values where a zone start and ends
3. Go in your graph, and select the same zone, trying not to mess up
4. Go back to VVE and paste % or whatever.

With the spreadsheet, once the initial setup is done, each time you want to tune VVE you only have to copy the whole data from your graph, and it select each zone to copy in the VVE table without having to do try to identify each zone manually. Unless, as I said, there's a better way to do it... I'm open to suggestion, still trying to learn as much as possible!