Using Excel Web Query and Power Query Analysis of the Publishing Process of Preprint Server
Fuente:
Zenodo
Salvato in:
| Autore principale: | |
|---|---|
| Natura: | Recurso digital |
| Lingua: | inglese |
| Pubblicazione: |
Zenodo
2026
|
| Soggetti: | |
| Accesso online: | |
| Tags: |
Aggiungi Tag
Nessun Tag, puoi essere il primo ad aggiungerne!!
|
| _version_ | 1866902134497214464 |
|---|---|
| author | Sato, Yoshihiro |
| author_facet | Sato, Yoshihiro |
| contents | <p><em><span>This paper reports a practical example of a personal OSINT (Open Source Intelligence) method that uses only Excel web queries and Power Query functions to retrieve and analyze structured data from publicly available websites. As the target, we selected Jxiv, a domestic preprint server, and measured and analyzed the time required from submission to publication for all published papers (770 papers). It shows that hypothesis-driven research can be realized using only Excel without the need for special programming skills or paid tools. As a byproduct of the analysis, it was found that the achievement rate of Jxiv's publication policy of publishing within 48 hours has dropped from 35% in the first year of publication to less than 6% in 2026.</span></em></p> |
| format | Recurso digital |
| id | zenodo_https___doi_org_10_5281_zenodo_19494189 |
| institution | Zenodo |
| language | eng |
| publishDate | 2026 |
| publisher | Zenodo |
| record_format | zenodo |
| spellingShingle | Using Excel Web Query and Power Query Analysis of the Publishing Process of Preprint Server Sato, Yoshihiro OSINT Excel Power Query Web Scraping Jxiv Preprint Data Analytics <p><em><span>This paper reports a practical example of a personal OSINT (Open Source Intelligence) method that uses only Excel web queries and Power Query functions to retrieve and analyze structured data from publicly available websites. As the target, we selected Jxiv, a domestic preprint server, and measured and analyzed the time required from submission to publication for all published papers (770 papers). It shows that hypothesis-driven research can be realized using only Excel without the need for special programming skills or paid tools. As a byproduct of the analysis, it was found that the achievement rate of Jxiv's publication policy of publishing within 48 hours has dropped from 35% in the first year of publication to less than 6% in 2026.</span></em></p> |
| title | Using Excel Web Query and Power Query Analysis of the Publishing Process of Preprint Server |
| topic | OSINT Excel Power Query Web Scraping Jxiv Preprint Data Analytics |
| url | https://doi.org/10.5281/zenodo.19494189 |