{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":668915770,"defaultBranch":"main","name":"BulkCall2XLS","ownerLogin":"Dewpg","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-07-20T22:52:22.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/34615139?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1690494892.0","currentOid":""},"activityList":{"items":[{"before":"a82d7be09be7a57047bd5a2cb3bb1055790836d6","after":"0b425d928f521a584831d127bae6b3ded4ec7512","ref":"refs/heads/OneStateOneSheet","pushedAt":"2023-07-27T21:55:42.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"e2759820a4955aa603b7b80cc6f5469673c0f296","after":"a82d7be09be7a57047bd5a2cb3bb1055790836d6","ref":"refs/heads/OneStateOneSheet","pushedAt":"2023-07-27T21:54:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"For Field Replacement Names\n\nNecessary for final step of renaming headers.","shortMessageHtmlLink":"For Field Replacement Names"}},{"before":"5f8061468df825ff57d8bfd416303d4bfd300182","after":"e2759820a4955aa603b7b80cc6f5469673c0f296","ref":"refs/heads/OneStateOneSheet","pushedAt":"2023-07-27T21:53:34.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Change Cert\n\nThis is for one state for 6 years worth of data for whatever fields you put in.","shortMessageHtmlLink":"Change Cert"}},{"before":null,"after":"5f8061468df825ff57d8bfd416303d4bfd300182","ref":"refs/heads/OneStateOneSheet","pushedAt":"2023-07-27T21:52:32.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Typo","shortMessageHtmlLink":"Typo"}},{"before":"3874f73050e0c4c579dbe7bc006de64ffd584777","after":"5f8061468df825ff57d8bfd416303d4bfd300182","ref":"refs/heads/FDIC.gov","pushedAt":"2023-07-25T18:32:19.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Typo","shortMessageHtmlLink":"Typo"}},{"before":"d24c370fc1fc6fb3ca36d1399c76721b86490c02","after":"3874f73050e0c4c579dbe7bc006de64ffd584777","ref":"refs/heads/FDIC.gov","pushedAt":"2023-07-25T18:32:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"New Version","shortMessageHtmlLink":"New Version"}},{"before":"9f04408968f84bac5acdf4bd9892d07654a5d7a0","after":"d24c370fc1fc6fb3ca36d1399c76721b86490c02","ref":"refs/heads/FDIC.gov","pushedAt":"2023-07-25T18:30:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Complete Rewrite\n\nUser will need to adjust the parameters to meet their data needs.\r\nUses a different data source (FDIC API) and doesnt require documents/zip files on the computer.  Documentation regarding available fields is available here : https://banks.data.fdic.gov/docs/","shortMessageHtmlLink":"Complete Rewrite"}},{"before":null,"after":"9f04408968f84bac5acdf4bd9892d07654a5d7a0","ref":"refs/heads/FDIC.gov","pushedAt":"2023-07-25T18:28:22.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Deletes extracted files.","shortMessageHtmlLink":"Deletes extracted files."}},{"before":"b6e5a4335181c6c147e8f014881e6bf647bbd823","after":"9f04408968f84bac5acdf4bd9892d07654a5d7a0","ref":"refs/heads/main","pushedAt":"2023-07-24T03:28:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Deletes extracted files.","shortMessageHtmlLink":"Deletes extracted files."}},{"before":"5d121aca091b70dc8ead04cb255f462e74c6a872","after":"b6e5a4335181c6c147e8f014881e6bf647bbd823","ref":"refs/heads/main","pushedAt":"2023-07-24T03:23:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Better error handling","shortMessageHtmlLink":"Better error handling"}},{"before":"8f32e71c439e56af344afa5ed90b7deb71bcbab4","after":"5d121aca091b70dc8ead04cb255f462e74c6a872","ref":"refs/heads/main","pushedAt":"2023-07-24T03:11:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Ok, its amazing now\n\nHandles multiple zips and names the sheet appropriately.  Further, it removes columns that are empty for all selected IDRSSDs speeding up Pivot and other functions within the sheet.","shortMessageHtmlLink":"Ok, its amazing now"}},{"before":"e3b2e5bc691ce51b8dd9aaa07f66e40c2aeffd47","after":"8f32e71c439e56af344afa5ed90b7deb71bcbab4","ref":"refs/heads/main","pushedAt":"2023-07-24T03:10:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"31208f36aa92f6829b5de21cfc46dd10c011f69d","after":"e3b2e5bc691ce51b8dd9aaa07f66e40c2aeffd47","ref":"refs/heads/main","pushedAt":"2023-07-24T02:47:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Hardcoded some stuff\n\nAlso moved where the script should be.","shortMessageHtmlLink":"Hardcoded some stuff"}},{"before":"542100aa4760f7a20a370b46189f5dde4ba84a17","after":"31208f36aa92f6829b5de21cfc46dd10c011f69d","ref":"refs/heads/main","pushedAt":"2023-07-24T02:45:02.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Huge Update\n\nHas hardcoded state, but can be updated to adjust user input.  FIgured that this would be a good start.  Just change line 32 to whatever abbreviation is listed in the Bulk file.","shortMessageHtmlLink":"Huge Update"}},{"before":"a4de57f052c05dcf946f150ff192c707ebf01167","after":"542100aa4760f7a20a370b46189f5dde4ba84a17","ref":"refs/heads/main","pushedAt":"2023-07-21T16:22:35.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update main.py\n\nget rid of uneccesary save in the middle of the main function.","shortMessageHtmlLink":"Update main.py"}},{"before":"ef7a4e06e062536a46a2626815dc03466ce8191f","after":"a4de57f052c05dcf946f150ff192c707ebf01167","ref":"refs/heads/main","pushedAt":"2023-07-21T16:14:54.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update Deletion code\n\nNow about 10000 times faster at deleting the necessary columns.","shortMessageHtmlLink":"Update Deletion code"}},{"before":"b4b3dbed130f389cde7398eebd80cb8fad072731","after":"ef7a4e06e062536a46a2626815dc03466ce8191f","ref":"refs/heads/main","pushedAt":"2023-07-21T15:26:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Deletes empty columns now\n\nWorks as intended.  After inserting blank row beneath first several columns from first sheet. PIVOT works for whole sheet.","shortMessageHtmlLink":"Deletes empty columns now"}},{"before":"3968169462d9385da4c5fab645c5c289fd180e9f","after":"b4b3dbed130f389cde7398eebd80cb8fad072731","ref":"refs/heads/main","pushedAt":"2023-07-21T13:13:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"95a5f3faac0113024c3717c7bef15e51c218e42f","after":"3968169462d9385da4c5fab645c5c289fd180e9f","ref":"refs/heads/main","pushedAt":"2023-07-21T04:27:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"c540534d371d2faf8d279f742c3f6bc0caaab336","after":"95a5f3faac0113024c3717c7bef15e51c218e42f","ref":"refs/heads/main","pushedAt":"2023-07-21T04:26:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Datatype correction\n\nAdded datatype checks to ensure that calculations can be ran on cells.","shortMessageHtmlLink":"Datatype correction"}},{"before":"0591196b933502a4ad44b6b5cc9efd4b06c36e9a","after":"c540534d371d2faf8d279f742c3f6bc0caaab336","ref":"refs/heads/main","pushedAt":"2023-07-21T03:57:21.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Complete refactor\n\nWorks well, takes under 5 minutes to populate.  Rows are aligned. Need to eliminate empty columns that throw errors for pivot table purposes.","shortMessageHtmlLink":"Complete refactor"}},{"before":"cb50d1cc1569921b7a3f8626eae7060b28a38991","after":"0591196b933502a4ad44b6b5cc9efd4b06c36e9a","ref":"refs/heads/main","pushedAt":"2023-07-20T23:34:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Bulk as first sheet\n\nUpdated to make sure Bulk file is the first items on the sheet.  Need to insert a row beneath the first row on the first sheet to align all the data.","shortMessageHtmlLink":"Bulk as first sheet"}},{"before":"9b9f0533dcdb8afa6b55545849263196e69e5b0d","after":"cb50d1cc1569921b7a3f8626eae7060b28a38991","ref":"refs/heads/main","pushedAt":"2023-07-20T23:25:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"66eac709f4f070375e6ac1d2a8599ce2a9ce538c","after":"9b9f0533dcdb8afa6b55545849263196e69e5b0d","ref":"refs/heads/main","pushedAt":"2023-07-20T23:14:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update main.py\n\nActually works now.  Fixed a couple of errors.  Still figuring out why it cuts off the first row of the first import.","shortMessageHtmlLink":"Update main.py"}},{"before":"ccd6ef39d42a8bb0878216f0aced9a50a7d1fc65","after":"66eac709f4f070375e6ac1d2a8599ce2a9ce538c","ref":"refs/heads/main","pushedAt":"2023-07-20T22:56:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Create main.py\n\nFirst draft","shortMessageHtmlLink":"Create main.py"}},{"before":"a0f5411241636715edd3302739f6d5e580572d46","after":"ccd6ef39d42a8bb0878216f0aced9a50a7d1fc65","ref":"refs/heads/main","pushedAt":"2023-07-20T22:56:15.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Update README.md\n\nFirst pass","shortMessageHtmlLink":"Update README.md"}},{"before":null,"after":"a0f5411241636715edd3302739f6d5e580572d46","ref":"refs/heads/main","pushedAt":"2023-07-20T22:52:23.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Dewpg","name":"_Dew","path":"/Dewpg","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/34615139?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyMy0wNy0yN1QyMTo1NTo0Mi4wMDAwMDBazwAAAANexi6y","startCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wNy0yN1QyMTo1NTo0Mi4wMDAwMDBazwAAAANexi6y","endCursor":"Y3Vyc29yOnYyOpK7MjAyMy0wNy0yMFQyMjo1MjoyMy4wMDAwMDBazwAAAANZ_GS-"}},"title":"Activity · Dewpg/BulkCall2XLS"}