Updated tracking spreadsheet

[ppfkl 0]

Hi,

Earlier I posted a spreadsheet I've been using to track my fiancee's visa with. I've done some more work and thought I'd share it as well.

Enhancements are:

- Single button operation after you've run your VJ query and copied the table.

- Statistical analysis of how long it will take to complete the step based on your sample set.

- 50% of the time you'll be faster than the median

- 84% faster than 1 standard deviation

- 98% of the time faster than 2 standard deviations).

- Hyperlink to your case number on the Countdown page. You will need to edit the hyperlink for your case number.

- This way your SO can use it to check status and time as well.

- Histogram with where you are relative to the overall distribution for that step, the average, median, 1 std-dev, & 2 std-dev times.

- Right now this is set up for the NOA1->NOA2 step. You will have to modify it for other steps.

To do the analysis you just need 2 steps:

Step 1 - Do your detailed query on the Timeline Search and Copy the table.

Step 2 - Go to the Analysis page and push the button. You'll have to hit return a few times for it to finish as it goes through the steps.

The tool still handles 1000 records.

The original post and upload is at: Original Forecast Tool Post

The file is compressed using WinZIP.

Enjoy & Best regards,

PPFKL

Countdown___scrubbed.zip