shohagbhuiyan
/ australian-postcodes.csv
Last active
September 6, 2019 19:47
— forked from randomecho/australian-postcodes.sql
Australian postcodes (with states and suburb names) geocoded with latitude and longitude. SQL, JSON, CSV format.
We can't make this file beautiful and searchable because it's too large.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Postcode, Suburb, State, Lat, Lan | |
| 200, Australian National University, ACT, -35.280, 149.120 | |
| 221, Barton, ACT, -35.200, 149.100 | |
| 800, Darwin, NT, -12.800, 130.960 | |
| 801, Darwin, NT, -12.800, 130.960 | |
| 804, Parap, NT, -12.430, 130.840 | |
| 810, Alawa, NT, -12.380, 130.880 | |
| 810, Brinkin, NT, -12.380, 130.880 | |
| 810, Casuarina, NT, -12.380, 130.880 | |
| 810, Coconut Grove, NT, -12.380, 130.880 |
vaderj
/ Alternative_Excel_Unlock
Last active
June 8, 2021 02:32
#VBA Two methods of unlocking a locked excel sheet:VBA macro for Excel that should unprotect a password protected sheet,Opening the spreadsheet as XML and removing the specific piece
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Step 1. Make a copy of the spreadsheet in an empty directory. Rename the extension to .zip | |
| Step 2. Extract the zip file. | |
| Step 3. In the extracted contents, goto the folder \xl\worksheets\ | |
| Step 4. There should be one xml file per sheet? I editing "sheet1.xml" with NotePad++. From nearly the very end of the file, remove the tag that starts with: | |
| <sheetProtection | |
| My entire tag was as follows: | |
| <sheetProtection algorithmName="SHA-512" hashValue="ALciNBSIqRcjDiFbCuyWoGk4iOcC/ZRKnEjwEVi1skb6G5JbHhp+QVZ9+rlPVbGILOS7lYiCvJmR4Q7IuSphXA==" saltValue="8OVKXrG0VacLOLVztUpEYw==" spinCount="100000" sheet="1" objects="1" scenarios="1" selectLockedCells="1"/> | |
| Step 5. Save the file. Open the ZIP file in 7zip, find the same file, drag and drop, save, exit, rename the file back to (xlsx) and open |
stasgm
/ gist:29b0dc83b2746929f87a3763751b4368
Created
May 4, 2016 17:02
Firebird SQL - First/last day of month
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| current_date - EXTRACT(DAY FROM current_date) + 1 FirstDay, | |
| current_date - EXTRACT(DAY FROM current_date) + 32 - EXTRACT(DAY FROM current_date - EXTRACT(DAY FROM current_date) + 32) LastDay | |
| from | |
| rdb$database |