Download and format CSV data into LibreOffice Calc
Budget: €30 – €250 EUR
I need 133 CSV tables downloaded and formatted into an existing LibreOffice sheet. Please check the attached sheet "Validator Daily Statistics 2021.ods" that contains tables "Validator IDs", "Validator 167172", "Validator 168595" and "ETH_EUR Kraken Historical Data".
- Table "Validator IDs" contains all validators IDs. For each validator ID a CSV file must be downloaded from the link CONCAT("https://beaconcha.in/validator/";validator ID;"/stats"). A new table in the sheet must be created for each downloaded CSV with the data of the CSV. The data must be formatted, summed up and the sums linked back to the table "Validator IDs".
- The tables "Validator 167172" and "Validator 168595" contain two examples for the first and the last row of the table "Validator IDs". For each row of table "Validator IDs" such a table "Validator xxx" must be created in the sheet. These table are created by downloading through these links: https://beaconcha.in/validator/167172/stats, ..., https://beaconcha.in/validator/168595/stats. The last rows of tables "Validator 167172" and "Validator 168595" contain the results that are referenced in table "Validator IDs" columns B and C.
- The table "ETH_EUR Kraken Historical Data" contains data that are needed for the ETH EUR conversion that is used.
To apply for this job please perform the task for the second validator ID and send me the result for review, so that I can see that you understood what to do.
- Table "Validator IDs" contains all validators IDs. For each validator ID a CSV file must be downloaded from the link CONCAT("https://beaconcha.in/validator/";validator ID;"/stats"). A new table in the sheet must be created for each downloaded CSV with the data of the CSV. The data must be formatted, summed up and the sums linked back to the table "Validator IDs".
- The tables "Validator 167172" and "Validator 168595" contain two examples for the first and the last row of the table "Validator IDs". For each row of table "Validator IDs" such a table "Validator xxx" must be created in the sheet. These table are created by downloading through these links: https://beaconcha.in/validator/167172/stats, ..., https://beaconcha.in/validator/168595/stats. The last rows of tables "Validator 167172" and "Validator 168595" contain the results that are referenced in table "Validator IDs" columns B and C.
- The table "ETH_EUR Kraken Historical Data" contains data that are needed for the ETH EUR conversion that is used.
To apply for this job please perform the task for the second validator ID and send me the result for review, so that I can see that you understood what to do.