Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Connect to Excel for fares #52

Open
Mineshafter61 opened this issue Oct 3, 2023 · 1 comment
Open

Connect to Excel for fares #52

Mineshafter61 opened this issue Oct 3, 2023 · 1 comment
Assignees
@Mineshafter61
Labels
enhancement New feature or request

Comments

@Mineshafter61
Copy link
Member

No description provided.

@Mineshafter61 Mineshafter61 added enhancement New feature or request future Enhancement but less urgent, expect this to be done after 2 releases labels Oct 3, 2023
@Mineshafter61 Mineshafter61 self-assigned this Oct 3, 2023
@Mineshafter61 Mineshafter61 added workingonit and removed future Enhancement but less urgent, expect this to be done after 2 releases labels Feb 3, 2024
@Mineshafter61 Mineshafter61 changed the title Connect to Google Sheets for fares Connect to Excel for fares Feb 3, 2024
@Mineshafter61
Copy link
Member Author

Mineshafter61 commented Feb 3, 2024 •
edited
Loading

The Google Sheets API may not be accessible to every server owner, therefore I've changed the goal to Microsoft Excel instead.

If you don't have Microsoft Excel, simply create your fare table on Google Sheets and download the workbook as an Excel file.

Milestones/Methods:

  • Read Excel file
  • Split each spreadsheet into individual tables
  • Read those tables
  • Write the data to fares.yml

Tests:

  • Single large table at A1
  • Tables at A1 and Ax
  • Tables at B1 and X1
  • Tables at A2 and Ax
  • Tables at Xx and Yy
  • More than 2 tables
  • Multiple sheets
  • Do everything within 0.05s

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Mineshafter61 Mineshafter61

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Mineshafter61