I-751 Spreadsheets Compiled by Service Center

[midwinterrose 275]

Hello folks,

 

I have been closely following the I-751 spreadsheets to monitor activity at our service center, and in order to make it simpler to do so, I made a spreadsheet that compiles all the information from the existing spreadsheets for each month and organizes it by Service Center.  I thought others may appreciate having this information, so here's the link to the spreadsheet:

 

https://docs.google.com/spreadsheets/d/10bbIF3PDa36R8-yrFhHNDV1k32le-SPi1UzhewBFgiw/edit?usp=sharing

 

The entries are sorted by NOA1 received date, and the different service centers can be located by clicking on the tabs at the bottom of the sheet.

 

The sheets are not editable because the data is all imported from the other spreadsheets, so if you have data to add, it should be added to the original spreadsheets.  (March 2021 sheet found here: https://docs.google.com/spreadsheets/d/1liNArfs3TXRtN7EW9iQXDHeV2z6-ROZ-CQPjLC9HQl4/edit#gid=0)  Many thanks to the creators/moderators of those sheets, and all those who have contributed–they have been very helpful!  

[17Miller 30]

You're so amazing!!!

[Crazy Cat 41,610]

Where did you get the information for MSC?  

[midwinterrose 275]

19 hours ago, Lucky Cat said:

Where did you get the information for MSC?  

All the data is pulled from the spreadsheets that have been established for each month, like the March 2021 spreadsheet that I linked in the original post.  Spreadsheets for other months are linked at the bottom of the March 2021 spreadsheet.

[tab0712 141]

On 5/10/2021 at 5:10 PM, radharose said:

Hello folks,

 

I have been closely following the I-751 spreadsheets to monitor activity at our service center, and in order to make it simpler to do so, I made a spreadsheet that compiles all the information from the existing spreadsheets for each month and organizes it by Service Center.  I thought others may appreciate having this information, so here's the link to the spreadsheet:

 

https://docs.google.com/spreadsheets/d/10bbIF3PDa36R8-yrFhHNDV1k32le-SPi1UzhewBFgiw/edit?usp=sharing

 

The entries are sorted by NOA1 received date, and the different service centers can be located by clicking on the tabs at the bottom of the sheet.

 

The sheets are not editable because the data is all imported from the other spreadsheets, so if you have data to add, it should be added to the original spreadsheets.  (March 2021 sheet found here: https://docs.google.com/spreadsheets/d/1liNArfs3TXRtN7EW9iQXDHeV2z6-ROZ-CQPjLC9HQl4/edit#gid=0)  Many thanks to the creators/moderators of those sheets, and all those who have contributed–they have been very helpful!  

I don't see my entry on your spreadsheet. I am LIN, date filed 12/14 and line 74 on the December spreadsheet. Just wondering if I am looking at the wrong thing

[Crazy Cat 41,610]

I had a list of more than 100 MSC I-751 cases documented since early 2019......but I recently deleted the spreadsheet because users were continually corrupting the data by modifying the format and jumbling the data.  Good luck.

[elmers 293]

4 minutes ago, tab0712 said:

I don't see my entry on your spreadsheet. I am LIN, date filed 12/14 and line 74 on the December spreadsheet. Just wondering if I am looking at the wrong thing

That's likely because your entry in the December spreadsheet doesn't have a service center assigned. Mark it LIN and it will show up.

[tab0712 141]

On 5/12/2021 at 9:49 AM, elmers said:

That's likely because your entry in the December spreadsheet doesn't have a service center assigned. Mark it LIN and it will show up.

It has always been marked with LIN since I entered my data in December 🤷‍♀️

[midwinterrose 275]

8 hours ago, tab0712 said:

It has always been marked with LIN since I entered my data in December 🤷‍♀️

It wasn’t marked as LIN for whatever reason, but I marked it as LIN in the December 2020 sheet so now it appears in the LIN filers sheet. 👍

[elmers 293]

12 hours ago, radharose said:

It wasn’t marked as LIN for whatever reason, but I marked it as LIN in the December 2020 sheet so now it appears in the LIN filers sheet. 👍

Called it!

 

Though to be fair, some random users just go ham on these publicly editable spreadsheets and end up deleting some stuff or messing up with the formulas and formatting. PITA sometimes but to be expected I suppose.

[tab0712 141]

Thanks. You can call whatever you want, but it was there. I check that spreadsheet weekly. So someone very recently must have been in there "playing around" and removed it.

[Crazy Cat 41,610]

On 5/14/2021 at 12:07 PM, tab0712 said:

Thanks. You can call whatever you want, but it was there. I check that spreadsheet weekly. So someone very recently must have been in there "playing around" and removed it.

I have found that there are a lot of people here who know only enough about spreadsheets to be dangerous.  I abandoned my compilation of MSC I-751 filers due to continued and continual corruption of the data.  Unfortunately, Google Docs did not allow adding information only.  I wish I could have prevented other members from changing the format of the form.

 

Anyone wanting to see MSC data as of a few months ago can go here:

https://docs.google.com/spreadsheets/d/1Id1duRRByZHJmhEzl9N25GqwzcnUyLCR4e4N9W6zGLg/edit#gid=249434972

Edited May 17, 2021 by Lucky Cat