Moderators, any input on this?

[Timona 4,207]

1. Moderators.....is there any way this can be pinned on top of various processing threads so that we have a standardized spreadsheet? Those who wanna start a thread e.g June 2019 ROC files, Dec 2020 AOS can then borrow, edit accordingly and supply the link at the start of their threads OR
2. Moderators can start a new trend where we have an INDEPENDENT tab called "PROGRESS REPORTS SPREADSHEETS.'  We can add this under the General Discussion Area or wherever you think is appropriate.

• Under PROGRESS REPORTS SPREADSHEETS  tab, we can have the various process e.g ROC, AOS, K-1 blaa blaa.
• Under each process e.g ROC we have 12 spreadsheets correlating to all the months of the year i.e January , February spreadsheets etc.
• Now for each months spreadsheet .eg ROC for January, we open a leaf for January 2020 ROC and all those who ROCed in January 2020 will add data there. When January 2021 comes by, anyone can go and open another leaf for it. Basically, this remains for January alone. Other months will follow the same trend. So basically, we can compare each years month filings easily. See attached. I talk too much.

 

I believe if we have an independent spreadsheet tab, we can easily pick data. This tab will only be to fill spreadsheet data, nothing else. Comment and asking questions are reserved to their respective forums.

Ideally, I think Option 2 is the best.

 

P.S The spreadsheet can be hosted somewhere. I do not know where. Anyway, see leafs for different years at the bottom left of the spreadsheet.

 

https://docs.google.com/spreadsheets/d/1x8cIYZRoWQ9bgOMoe4rn1slYnQRPmpUir5TV5yzjbFs/edit?usp=sharing

 

 

Off topic :You can close or merge the previous thread that I had created

 

[millefleur 5,047]

The spreadsheets have always been something VJ just barely tolerates as there's preference to use the timeline feature that is on the website here. I can't make a decision about it alone as we'd probably need the site's admin @Captain Ewok to weigh in and give the final decision about it.

[Timona 4,207]

5 hours ago, millefleur said:

The spreadsheets have always been something VJ just barely tolerates as there's preference to use the timeline feature that is on the website here. I can't make a decision about it alone as we'd probably need the site's admin @Captain Ewok to weigh in and give the final decision about it.

 

Understood. My idea with the spreadsheet was to just collect data for future analysis. This should be separate from individual timelines i.e individuals should still fill their timelines eg. In the future, if we wanna look at the rough estimate for processing times for ROCs for January, we can easily look at the spreadsheet. 

 

Just an idea as I see a lot of individual spreadsheets. We can do better by standardizing. As mentioned earlier, this would just be a place to locate your process eg ROC then input local office, when it was filed and when it was adjudicated, nothing else. Monthly discussion and huddles will still be reserved to their respective discussion forums. The data remains VJ property as opposed to currently where it is individual property.

 

My two cents. Ideas against or for are welcomed.

[TBoneTX 45,498]

Regardless of the decision, thank you for offering constructive input.

[Timona 4,207]

11 hours ago, TBoneTX said:

Regardless of the decision, thank you for offering constructive input.

 

Always happy to suggest...😁😁

[Captain Ewok 1,895]

Curious as much where the gaps are in the current timelines.  I'd love to improve their functionality.  Suggestions?

 

Thanks!!

[Timona 4,207]

15 hours ago, Captain Ewok said:

Curious as much where the gaps are in the current timelines.  I'd love to improve their functionality.  Suggestions?

 

Thanks!!

 

I'm lost here 

[millefleur 5,047]

2 hours ago, Timona said:

 

I'm lost here 

I think what Ewok is asking is, what is lacking from VJ's timeline system and what does the Google sheet offer that is better?

[Timona 4,207]

5 minutes ago, millefleur said:

I think what Ewok is asking is, what is lacking from VJ's timeline system and what does the Google sheet offer that is better?

 

Understood. I just see so many spreadsheets.

 

I see everyone has their own spreadsheet each month, some which are duplicate. Therefore, by VJ controlling this data, we all eat from one pot.

 

Additionally,  as i said earlier,  should we need to look at monthly trends, we know where the data is. 

[Captain Ewok 1,895]

9 hours ago, Timona said:

 

Understood. I just see so many spreadsheets.

 

I see everyone has their own spreadsheet each month, some which are duplicate. Therefore, by VJ controlling this data, we all eat from one pot.

 

Additionally,  as i said earlier,  should we need to look at monthly trends, we know where the data is. 

 

What monthly trends do you want to see?  We plot many items but could add more...

 

 

 

[Timona 4,207]

Mmmm wasn't prepared for this. Lemme think and I'll get back.

 

Maybe other members can also add on this.