[ { "key": "63X2EVG4", "version": 336, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/63X2EVG4", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/63X2EVG4", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/CNNWU7P8", "type": "application/json" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } } }, "data": { "key": "63X2EVG4", "version": 336, "parentItem": "CNNWU7P8", "itemType": "attachment", "linkMode": "imported_url", "title": "Snapshot", "accessDate": "2025-05-27T15:17:50Z", "url": "https://support.getgrist.com/self-managed/#the-essentials", "note": "", "contentType": "text/html", "charset": "utf-8", "filename": "self-managed.html", "md5": "3d370e33ad777a9bf0ddc3d41739f158", "mtime": 1748359070913, "tags": [], "relations": {}, "dateAdded": "2025-05-27T15:17:50Z", "dateModified": "2025-05-27T15:17:50Z" } }, { "key": "CNNWU7P8", "version": 334, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/CNNWU7P8", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/CNNWU7P8", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 1 }, "data": { "key": "CNNWU7P8", "version": 334, "itemType": "webpage", "title": "Self-hosted Grist - Grist Help Center", "creators": [], "abstractNote": "The essentials of creating and maintaining a self-hosted Grist installation.", "websiteTitle": "", "websiteType": "", "date": "", "publisher": "", "place": "", "DOI": "", "citationKey": "", "url": "https://support.getgrist.com/self-managed/", "accessDate": "2025-05-27T15:17:44Z", "shortTitle": "", "language": "en", "rights": "", "extra": "", "tags": [], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:17:44Z", "dateModified": "2025-05-27T15:17:44Z" } }, { "key": "G3CIXCK3", "version": 337, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/G3CIXCK3", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/G3CIXCK3", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/R96B8DYL", "type": "application/json" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } } }, "data": { "key": "G3CIXCK3", "version": 337, "parentItem": "R96B8DYL", "itemType": "attachment", "linkMode": "imported_url", "title": "Snapshot", "accessDate": "2025-05-27T15:16:37Z", "url": "https://docs.nocodb.com/0.109.7/", "note": "", "contentType": "text/html", "charset": "utf-8", "filename": "0.109.7.html", "md5": "a658194cd38b15e9d46ac1d3e424ba47", "mtime": 1748358997855, "tags": [], "relations": {}, "dateAdded": "2025-05-27T15:16:37Z", "dateModified": "2025-05-27T15:16:37Z" } }, { "key": "R96B8DYL", "version": 333, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/R96B8DYL", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/R96B8DYL", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 1 }, "data": { "key": "R96B8DYL", "version": 333, "itemType": "webpage", "title": "Welcome | NocoDB", "creators": [], "abstractNote": "NocoDB Documentation", "websiteTitle": "", "websiteType": "", "date": "", "publisher": "", "place": "", "DOI": "", "citationKey": "", "url": "https://docs.nocodb.com/0.109.7/", "accessDate": "2025-05-27T15:16:34Z", "shortTitle": "", "language": "en", "rights": "", "extra": "", "tags": [], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:16:34Z", "dateModified": "2025-05-27T15:16:34Z" } }, { "key": "ZN5EYCLT", "version": 333, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/ZN5EYCLT", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/ZN5EYCLT", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "parsedDate": "2025-05-27", "numChildren": 0 }, "data": { "key": "ZN5EYCLT", "version": 333, "itemType": "computerProgram", "title": "nocodb/nocodb", "creators": [], "abstractNote": "🔥 🔥 🔥 Open Source Airtable Alternative", "seriesTitle": "", "versionNumber": "", "date": "2025-05-27T14:17:38Z", "system": "", "company": "nocodb", "place": "", "programmingLanguage": "TypeScript", "rights": "AGPL-3.0", "citationKey": "", "url": "https://github.com/nocodb/nocodb", "accessDate": "2025-05-27T15:16:07Z", "DOI": "", "ISBN": "", "archive": "", "archiveLocation": "", "libraryCatalog": "GitHub", "callNumber": "", "shortTitle": "", "extra": "original-date: 2017-10-29T18:51:48Z", "tags": [ { "tag": "admin-dashboard", "type": 1 }, { "tag": "admin-ui", "type": 1 }, { "tag": "airtable", "type": 1 }, { "tag": "airtable-alternative", "type": 1 }, { "tag": "automatic-api", "type": 1 }, { "tag": "hacktoberfest", "type": 1 }, { "tag": "low-code", "type": 1 }, { "tag": "mariadb", "type": 1 }, { "tag": "mysql", "type": 1 }, { "tag": "no-code", "type": 1 }, { "tag": "no-code-database", "type": 1 }, { "tag": "no-code-platform", "type": 1 }, { "tag": "postgresql", "type": 1 }, { "tag": "rest-api", "type": 1 }, { "tag": "restful-api", "type": 1 }, { "tag": "spreadsheet", "type": 1 }, { "tag": "sqlite", "type": 1 }, { "tag": "sqlserver", "type": 1 }, { "tag": "swagger", "type": 1 } ], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:16:07Z", "dateModified": "2025-05-27T15:16:07Z" } }, { "key": "IV3MF8ML", "version": 338, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/IV3MF8ML", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/IV3MF8ML", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/KRLNFLA4", "type": "application/json" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } } }, "data": { "key": "IV3MF8ML", "version": 338, "parentItem": "KRLNFLA4", "itemType": "attachment", "linkMode": "imported_url", "title": "JavaScript Data Grid With Spreadsheet Controls", "accessDate": "2025-05-27T15:10:23Z", "url": "https://jspreadsheet.com/", "note": "", "contentType": "text/html", "charset": "utf-8", "filename": "jspreadsheet.com.html", "md5": "1d61bf2692fce8751ccaf7d6e53dbd43", "mtime": 1748358623734, "tags": [], "relations": {}, "dateAdded": "2025-05-27T15:10:23Z", "dateModified": "2025-05-27T15:10:23Z" } }, { "key": "KRLNFLA4", "version": 333, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/KRLNFLA4", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/KRLNFLA4", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 1 }, "data": { "key": "KRLNFLA4", "version": 333, "itemType": "webpage", "title": "JavaScript Data Grid With Spreadsheet Controls", "creators": [], "abstractNote": "", "websiteTitle": "", "websiteType": "", "date": "", "publisher": "", "place": "", "DOI": "", "citationKey": "", "url": "https://jspreadsheet.com/", "accessDate": "2025-05-27T15:10:01Z", "shortTitle": "", "language": "", "rights": "", "extra": "", "tags": [], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:10:01Z", "dateModified": "2025-05-27T15:10:01Z" } }, { "key": "5QBCSTQB", "version": 333, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/5QBCSTQB", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/5QBCSTQB", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "parsedDate": "2025-05-27", "numChildren": 0 }, "data": { "key": "5QBCSTQB", "version": 333, "itemType": "computerProgram", "title": "dream-num/Luckysheet", "creators": [], "abstractNote": "Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.", "seriesTitle": "", "versionNumber": "", "date": "2025-05-27T08:25:26Z", "system": "", "company": "DreamNum", "place": "", "programmingLanguage": "JavaScript", "rights": "MIT", "citationKey": "", "url": "https://github.com/dream-num/Luckysheet", "accessDate": "2025-05-27T15:09:30Z", "DOI": "", "ISBN": "", "archive": "", "archiveLocation": "", "libraryCatalog": "GitHub", "callNumber": "", "shortTitle": "", "extra": "original-date: 2020-05-15T07:24:59Z", "tags": [ { "tag": "canvas", "type": 1 }, { "tag": "chart", "type": 1 }, { "tag": "conditional-formatting", "type": 1 }, { "tag": "data-table", "type": 1 }, { "tag": "excel", "type": 1 }, { "tag": "formula", "type": 1 }, { "tag": "google-sheets", "type": 1 }, { "tag": "google-spreadsheet", "type": 1 }, { "tag": "javascript", "type": 1 }, { "tag": "office", "type": 1 }, { "tag": "pivot-tables", "type": 1 }, { "tag": "sparkline", "type": 1 }, { "tag": "spreadsheet", "type": 1 }, { "tag": "web-based", "type": 1 }, { "tag": "xlsx", "type": 1 } ], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:09:30Z", "dateModified": "2025-05-27T15:09:30Z" } }, { "key": "SSW62NLK", "version": 339, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/SSW62NLK", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/SSW62NLK", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/UYXJPBD7", "type": "application/json" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } } }, "data": { "key": "SSW62NLK", "version": 339, "parentItem": "UYXJPBD7", "itemType": "attachment", "linkMode": "imported_url", "title": "Snapshot", "accessDate": "2025-05-27T15:09:12Z", "url": "https://git.sheetjs.com/sheetjs/sheetjs", "note": "", "contentType": "text/html", "charset": "utf-8", "filename": "sheetjs.html", "md5": "459f68aec6a1b52b950266a20ba36c47", "mtime": 1748358552263, "tags": [], "relations": {}, "dateAdded": "2025-05-27T15:09:12Z", "dateModified": "2025-05-27T15:09:12Z" } }, { "key": "UYXJPBD7", "version": 333, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/UYXJPBD7", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/UYXJPBD7", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "creatorSummary": "sheetjs", "numChildren": 1 }, "data": { "key": "UYXJPBD7", "version": 333, "itemType": "webpage", "title": "sheetjs", "creators": [ { "creatorType": "author", "firstName": "", "lastName": "sheetjs" } ], "abstractNote": "📗 SheetJS Community Edition -- Spreadsheet Data Toolkit", "websiteTitle": "SheetJS", "websiteType": "", "date": "", "publisher": "", "place": "", "DOI": "", "citationKey": "", "url": "https://git.sheetjs.com/sheetjs/sheetjs", "accessDate": "2025-05-27T15:09:06Z", "shortTitle": "", "language": "en-US", "rights": "", "extra": "", "tags": [], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:09:06Z", "dateModified": "2025-05-27T15:09:06Z" } }, { "key": "34DJQ4AK", "version": 333, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/34DJQ4AK", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/34DJQ4AK", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "parsedDate": "2025-05-27", "numChildren": 0 }, "data": { "key": "34DJQ4AK", "version": 333, "itemType": "computerProgram", "title": "jspreadsheet/ce", "creators": [], "abstractNote": "Jspreadsheet is a lightweight JavaScript data grid component for creating interactive data grids with advanced spreadsheet controls.", "seriesTitle": "", "versionNumber": "", "date": "2025-05-27T13:08:34Z", "system": "", "company": "jspreadsheet", "place": "", "programmingLanguage": "JavaScript", "rights": "MIT", "citationKey": "", "url": "https://github.com/jspreadsheet/ce", "accessDate": "2025-05-27T15:08:26Z", "DOI": "", "ISBN": "", "archive": "", "archiveLocation": "", "libraryCatalog": "GitHub", "callNumber": "", "shortTitle": "", "extra": "original-date: 2017-02-20T11:48:15Z", "tags": [ { "tag": "data-grid", "type": 1 }, { "tag": "datagrid", "type": 1 }, { "tag": "datatables", "type": 1 }, { "tag": "excel", "type": 1 }, { "tag": "grid", "type": 1 }, { "tag": "javascript", "type": 1 }, { "tag": "javascript-data-grid", "type": 1 }, { "tag": "jexcel", "type": 1 }, { "tag": "js", "type": 1 }, { "tag": "jspreadsheet", "type": 1 }, { "tag": "online-spreadsheet", "type": 1 }, { "tag": "spreadsheet", "type": 1 }, { "tag": "spreadsheets", "type": 1 }, { "tag": "table", "type": 1 } ], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:08:26Z", "dateModified": "2025-05-27T15:08:26Z" } }, { "key": "9W4TUF9H", "version": 335, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/9W4TUF9H", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/9W4TUF9H", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/J9GM3Z48", "type": "application/json" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } } }, "data": { "key": "9W4TUF9H", "version": 335, "parentItem": "J9GM3Z48", "itemType": "attachment", "linkMode": "imported_url", "title": "Snapshot", "accessDate": "2025-05-27T15:07:43Z", "url": "https://docs.sheetjs.com/docs/demos/frontend/react/#html", "note": "", "contentType": "text/html", "charset": "utf-8", "filename": "react.html", "md5": "e09d735ac9368591014fb1fe3cc5e880", "mtime": 1748358463619, "tags": [], "relations": {}, "dateAdded": "2025-05-27T15:07:43Z", "dateModified": "2025-05-27T15:07:43Z" } }, { "key": "J9GM3Z48", "version": 333, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/J9GM3Z48", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/J9GM3Z48", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "parsedDate": "2025-05-12", "numChildren": 1 }, "data": { "key": "J9GM3Z48", "version": 333, "itemType": "webpage", "title": "Sheets in ReactJS Sites | SheetJS Community Edition", "creators": [], "abstractNote": "Build interactive websites with ReactJS. Seamlessly integrate spreadsheets into your app using SheetJS. Bring Excel-powered workflows and data to the modern web.", "websiteTitle": "", "websiteType": "", "date": "2025-05-12", "publisher": "", "place": "", "DOI": "", "citationKey": "", "url": "https://docs.sheetjs.com/docs/demos/frontend/react/", "accessDate": "2025-05-27T15:07:33Z", "shortTitle": "", "language": "en", "rights": "", "extra": "", "tags": [], "collections": [ "ZDRP4U28" ], "relations": {}, "dateAdded": "2025-05-27T15:07:33Z", "dateModified": "2025-05-27T15:07:33Z" } }, { "key": "TD44BK23", "version": 308, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/TD44BK23", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/TD44BK23", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "creatorSummary": "Bergh et al.", "parsedDate": "2019", "numChildren": 1 }, "data": { "key": "TD44BK23", "version": 308, "itemType": "book", "title": "The DataOps Cookbook: Methodologies and Tools That Reduce Analytics Cycle Time While Improving Quality", "creators": [ { "creatorType": "author", "firstName": "Christopher", "lastName": "Bergh" }, { "creatorType": "author", "firstName": "Gil", "lastName": "Benghiat" }, { "creatorType": "author", "firstName": "Eran", "lastName": "Strod" } ], "abstractNote": "", "series": "", "seriesNumber": "", "volume": "", "numberOfVolumes": "", "edition": "2nd Edition", "date": "2019", "publisher": "", "place": "", "originalDate": "", "originalPublisher": "", "originalPlace": "", "format": "", "numPages": "", "ISBN": "", "DOI": "", "citationKey": "", "url": "https://datakitchen.io/content/DK_dataops_book_2nd_edition.pdf", "accessDate": "2020-08-02T21:36:17Z", "ISSN": "", "archive": "", "archiveLocation": "", "shortTitle": "", "language": "", "libraryCatalog": "", "callNumber": "", "rights": "", "extra": "", "tags": [], "collections": [ "W6UZDZ7B" ], "relations": {}, "dateAdded": "2020-08-02T21:36:36Z", "dateModified": "2020-08-02T21:38:14Z" } }, { "key": "5FEFU4TC", "version": 306, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/5FEFU4TC", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/5FEFU4TC", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/TD44BK23", "type": "application/json" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 0 }, "data": { "key": "5FEFU4TC", "version": 306, "parentItem": "TD44BK23", "itemType": "attachment", "linkMode": "imported_url", "title": "DK_dataops_book_2nd_edition.pdf", "accessDate": "2020-08-02T21:36:17Z", "url": "https://datakitchen.io/content/DK_dataops_book_2nd_edition.pdf", "note": "", "contentType": "application/pdf", "charset": "", "filename": "DK_dataops_book_2nd_edition.pdf", "md5": "6a330f50594f0716031b2614366677e3", "mtime": 1596404177560, "tags": [], "relations": {}, "dateAdded": "2020-08-02T21:36:17Z", "dateModified": "2020-08-02T21:36:36Z" } }, { "key": "YCKTXXEI", "version": 309, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/YCKTXXEI", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/YCKTXXEI", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/CPPSVECN", "type": "application/json" } }, "meta": { "createdByUser": { "id": 1750278, "username": "Jacob-Walker-SCUSD", "name": "Jacob Walker, Coordinator II", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker-scusd", "type": "text/html" } } }, "lastModifiedByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } } }, "data": { "key": "YCKTXXEI", "version": 309, "parentItem": "CPPSVECN", "itemType": "attachment", "linkMode": "imported_file", "title": "The Gourmet Data Cookbook.docx", "accessDate": "", "url": "", "note": "", "contentType": "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "charset": "", "filename": "The Gourmet Data Cookbook.docx", "md5": "d50b859e826a59c7a266ff52100a5c21", "mtime": 1596752938640, "tags": [], "relations": { "owl:sameAs": "http://zotero.org/groups/19188/items/PZFR9YD6" }, "dateAdded": "2020-07-22T02:52:50Z", "dateModified": "2020-07-24T20:51:31Z" } }, { "key": "CPPSVECN", "version": 300, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/CPPSVECN", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/CPPSVECN", "type": "text/html" } }, "meta": { "createdByUser": { "id": 1750278, "username": "Jacob-Walker-SCUSD", "name": "Jacob Walker, Coordinator II", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker-scusd", "type": "text/html" } } }, "creatorSummary": "Walker", "numChildren": 1 }, "data": { "key": "CPPSVECN", "version": 300, "itemType": "book", "title": "The Gourmet Data Cookbook: Programming Recipes and Techniques for the Discerning Data Analyst, Data Engineer, Data Scientist, and any other Keywords I can fit in this Title", "creators": [ { "creatorType": "author", "firstName": "Jacob J.", "lastName": "Walker" } ], "abstractNote": "", "series": "", "seriesNumber": "", "volume": "", "numberOfVolumes": "", "edition": "", "date": "", "publisher": "", "place": "", "originalDate": "", "originalPublisher": "", "originalPlace": "", "format": "", "numPages": "", "ISBN": "", "DOI": "", "citationKey": "", "url": "", "accessDate": "", "ISSN": "", "archive": "", "archiveLocation": "", "shortTitle": "", "language": "", "libraryCatalog": "", "callNumber": "", "rights": "", "extra": "", "tags": [], "collections": [ "W6UZDZ7B" ], "relations": { "owl:sameAs": "http://zotero.org/groups/19188/items/49EK8CTU" }, "dateAdded": "2020-07-22T02:52:50Z", "dateModified": "2020-07-24T20:40:44Z" } }, { "key": "5DJZMVMD", "version": 282, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/5DJZMVMD", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/5DJZMVMD", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 0 }, "data": { "key": "5DJZMVMD", "version": 282, "itemType": "note", "note": "

Sub Write_Delim()

\n

'This macro writes the current range, table/list, pivot table, or sheet as a CSV or other delimited file
'This macro can write with or without headers (+header or -header) and with or without preview (+preview or -preview)
'Ultimately this macro will allow overwriting or appending

\n

'Based on Code from
'https://stackoverflow.com/questions/37037934/excel-macro-to-export-worksheet-as-csv-file-without-leaving-my-current-excel-sh

\n

Dim CSVFileName As Variant
Dim OriginalWB As Workbook, TempWB As Workbook
Dim OriginalWS As Worksheet
Dim ToExport As String
Dim SelectedRng As Range
Dim SelectedTbl As ListObject
Dim SelectedPT As PivotTable
Dim HeaderRow As Range
Dim HeaderRowX1, HeaderRowX2, HeaderRowY1, HeaderRowY2 As Integer
Dim CSVDataX1, CSVDataX2, CSVDataY1, CSVDataY2 As Integer
Dim Temp As Variant

\n

' Sets Variable to Remember Current Info, to return here later
Set OriginalWB = ActiveWorkbook
Set OriginalWS = ActiveSheet
Set SelectedRng = Selection

'Turn off screen updating so user doesn't see the \"magic\" behind the scenes of the temp workbook
'Application.ScreenUpdating = False


' Determine whether a Table, PivotTable, or Sheet will be exported as a CSV, based on current selection
' Pivot Table Detection Code based on
' https://www.mrexcel.com/forum/excel-questions/390938-vba-check-activecell-being-within-pivottable.html

If SelectedRng.Columns.Count > 1 Or SelectedRng.Rows.Count > 1 Then
ToExport = \"Range\"
Else
On Error Resume Next
Set SelectedTbl = ActiveCell.ListObject
On Error GoTo 0
If Not (SelectedTbl Is Nothing) Then
ToExport = \"ListObject\"
Else
On Error Resume Next
Set SelectedPT = ActiveCell.PivotTable
On Error GoTo 0
If Not (SelectedPT Is Nothing) Then
ToExport = \"PivotTable\"
Else
ToExport = \"Sheet\"
End If
End If
End If


' Gets the filename of CSV
CSVFileName = Application.GetSaveAsFilename(ActiveWorkbook.ActiveSheet.name, \"CSV File (*.csv), *.csv\", , \"Export Current Worksheet to CSV\")
If CSVFileName = False Then Exit Sub
On Error Resume Next


'Take Appropriate Action Based Upon What Should Be Exported
Select Case ToExport
Case \"Range\"


Case \"ListObject\"
'First copies the table header as CSV header

\n

Case \"PivotTable\"
'First copies the PivotTable lower header as CSV header

HeaderRowX1 = SelectedPT.RowRange.Column
HeaderRowY1 = SelectedPT.RowRange.Row
HeaderRowX2 = SelectedPT.DataBodyRange.Column + SelectedPT.DataBodyRange.Columns.Count - 1
HeaderRowY2 = SelectedPT.RowRange.Row

'Debugging Test to See Range to be Copied
'Temp = MsgBox(HeaderRowX1 & \" , \" & HeaderRowY1 & \" - \" & HeaderRowX2 & \" , \" & HeaderRowY2, 0, \"Heading Range\")

\n


Range(Cells(HeaderRowY1, HeaderRowX1), Cells(HeaderRowY2, HeaderRowX2)).Copy
Set TempWB = Application.Workbooks.add(1)
With TempWB.Sheets(1).Range(\"A1\")
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteFormats
End With

'Go Back to Original Location
OriginalWB.Activate
OriginalWS.Select
SelectedRng.Select


'Copy the Pivot Table Body as CSV Data
CSVDataX1 = SelectedPT.RowRange.Column
CSVDataY1 = SelectedPT.RowRange.Row + 1
CSVDataX2 = SelectedPT.TableRange1.Column + SelectedPT.TableRange1.Columns.Count - 1
CSVDataY2 = SelectedPT.TableRange1.Row + SelectedPT.TableRange1.Rows.Count - 1

'Debugging Test to See Range to be Copied
'Temp = MsgBox(CSVDataX1 & \" , \" & CSVDataY1 & \" - \" & CSVDataX2 & \" , \" & CSVDataY2, 0, \"Data Range\")

\n

Range(Cells(CSVDataY1, CSVDataX1), Cells(CSVDataY2, CSVDataX2)).Copy
With TempWB.Sheets(1).Range(\"A2\")
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteFormats
End With

\n


Case \"Sheet\"
ActiveWorkbook.ActiveSheet.UsedRange.Copy
Set TempWB = Application.Workbooks.add(1)
With TempWB.Sheets(1).Range(\"A1\")
.PasteSpecial xlPasteValues
.PasteSpecial xlPasteFormats
End With

End Select

'Save Temporary Workbook as CSV, and Close it, returning to original
Application.DisplayAlerts = False
TempWB.SaveAs fileName:=CSVFileName, FileFormat:=xlCSV, CreateBackup:=False, Local:=True
TempWB.Close SaveChanges:=False
Application.DisplayAlerts = True
Application.ScreenUpdating = True

End Sub

", "tags": [], "collections": [], "relations": {}, "dateAdded": "2018-11-30T19:01:13Z", "dateModified": "2018-11-30T19:01:55Z" } }, { "key": "FVX8BCWH", "version": 281, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/FVX8BCWH", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/FVX8BCWH", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "lastModifiedByUser": { "id": 1750278, "username": "Jacob-Walker-SCUSD", "name": "Jacob Walker, Coordinator II", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker-scusd", "type": "text/html" } } }, "numChildren": 0 }, "data": { "key": "FVX8BCWH", "version": 281, "itemType": "note", "note": "

Use Write_Delim in SCUSD Project

\n

Chunk: Test Write_Delim as currently written to convert spreadsheets to CSVs for easier and more accurate importing into MS SQL Server.

\n", "tags": [], "collections": [ "CNSU64GK" ], "relations": {}, "dateAdded": "2018-05-27T15:20:32Z", "dateModified": "2018-11-30T18:54:52Z" } }, { "key": "JCZJTCAE", "version": 272, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/JCZJTCAE", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/JCZJTCAE", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 0 }, "data": { "key": "JCZJTCAE", "version": 272, "itemType": "note", "note": "

Document GitHub Structure

\n

Document the refactored GitHub Structure in the README.md

", "tags": [], "collections": [ "ACZ5NNL9" ], "relations": {}, "dateAdded": "2018-05-27T15:07:56Z", "dateModified": "2018-05-27T15:09:04Z" } }, { "key": "V2FABDGX", "version": 268, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/V2FABDGX", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/V2FABDGX", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 0 }, "data": { "key": "V2FABDGX", "version": 268, "itemType": "note", "note": "

Refactor Zotero Group Library Structure

\n

Chunk: Refactor the organization of the Zotero Group Library to better fit the project workflow.

\n", "tags": [], "collections": [ "H9IEIZ63" ], "relations": {}, "dateAdded": "2018-05-27T14:56:25Z", "dateModified": "2018-05-27T14:58:22Z" } }, { "key": "LCWYK6ZV", "version": 262, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/LCWYK6ZV", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/LCWYK6ZV", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 0 }, "data": { "key": "LCWYK6ZV", "version": 262, "itemType": "note", "note": "

Refactor GitHub Repository Structure

\n

Chunk: Refactor the GitHub Repository Structure to Prepare for using VbaGit in the future, and its directory structure.

\n", "tags": [], "collections": [ "H9IEIZ63" ], "relations": {}, "dateAdded": "2018-05-27T14:31:15Z", "dateModified": "2018-05-27T14:50:16Z" } }, { "key": "VQRKLGWN", "version": 258, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/VQRKLGWN", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/VQRKLGWN", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "numChildren": 0 }, "data": { "key": "VQRKLGWN", "version": 258, "itemType": "note", "note": "

Implementing VbaGit

\n

Waiting to see if questions are answered by VbaGit author.  If no response, then the VbaGit source code will need to be dived into, and GitHub settings will need to be read further about.

", "tags": [], "collections": [ "ACZ5NNL9" ], "relations": {}, "dateAdded": "2018-05-27T14:27:23Z", "dateModified": "2018-05-27T14:29:16Z" } }, { "key": "K5A9ZXFZ", "version": 247, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/K5A9ZXFZ", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/K5A9ZXFZ", "type": "text/html" }, "up": { "href": "https://api.zotero.org/groups/303143/items/JFC7U7F4", "type": "application/json" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } } }, "data": { "key": "K5A9ZXFZ", "version": 247, "parentItem": "JFC7U7F4", "itemType": "attachment", "linkMode": "imported_url", "title": "Snapshot", "accessDate": "2018-05-27T13:22:48Z", "url": "https://magistrateinc.com/how-scrum-trello-doubled-our-marketing-agencys-productivity/", "note": "", "contentType": "text/html", "charset": "utf-8", "filename": "how-scrum-trello-doubled-our-marketing-agencys-productivity.html", "md5": "66e885e75f87c06256d7d3908899e55d", "mtime": 1527427368164, "tags": [], "relations": {}, "dateAdded": "2018-05-27T13:22:48Z", "dateModified": "2018-05-27T13:22:48Z" } }, { "key": "JFC7U7F4", "version": 246, "library": { "type": "group", "id": 303143, "name": "z. EdSysONE Praxis - Project - Libre Excel Tools", "links": { "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools", "type": "text/html" } } }, "links": { "self": { "href": "https://api.zotero.org/groups/303143/items/JFC7U7F4", "type": "application/json" }, "alternate": { "href": "https://www.zotero.org/groups/z._edsysone_praxis_-_project_-_libre_excel_tools/items/JFC7U7F4", "type": "text/html" } }, "meta": { "createdByUser": { "id": 37652, "username": "jacob-walker", "name": "Jacob J. Walker", "links": { "alternate": { "href": "https://www.zotero.org/jacob-walker", "type": "text/html" } } }, "parsedDate": "2015-06-02", "numChildren": 1 }, "data": { "key": "JFC7U7F4", "version": 246, "itemType": "webpage", "title": "Our Agency's Epic 200% Productivity Secret: [Trello & Scrum]", "creators": [], "abstractNote": "Using the Scrum framework, and Trello will double (or more) your teams productivity. Learn how our marketing agency implemented it, and stayed in business.", "websiteTitle": "The Magistrate", "websiteType": "", "date": "2015-06-02T07:30:42-07:00", "publisher": "", "place": "", "DOI": "", "citationKey": "", "url": "https://magistrateinc.com/how-scrum-trello-doubled-our-marketing-agencys-productivity/", "accessDate": "2018-05-27T13:22:40Z", "shortTitle": "Our Agency's Epic 200% Productivity Secret", "language": "en-US", "rights": "", "extra": "", "tags": [], "collections": [ "8KM224A7" ], "relations": {}, "dateAdded": "2018-05-27T13:22:40Z", "dateModified": "2018-05-27T13:22:40Z" } } ]