Task Description
The task involves updating and tracking the total hours of raw audio available, the amount of audio that has been uploaded, and the remaining audio that is yet to be uploaded for each department. This information is critical for ensuring that all audio resources are properly managed and that no department falls behind in the uploading process and to ensure data availability at all times.
Accurate calculation of the total hours of raw audio for each department.
Precise update of the total hours of audio uploaded for each department.
Correct calculation of the remaining hours of audio to be uploaded for each department.
All data should be compiled and presented in the table format provided.
Implementation
Create a script to calculate audio duration if uploaded status in pecha tools is True.
Retrieve the raw audio duration, uploaded audio duration, and calculate the remaining duration for each department from catalog.
Ensure the time is calculated in hours and formatted as hh:mm:ss.
Update the table with the calculated values.
Subtask
[x] Calculate and update the total raw audio duration for each department.
[x] Calculate and update the total audio uploaded time for each department.
[x] Calculate and update the remaining audio time left to upload for each department.
[x] Review the updated data to ensure accuracy and consistency.
Description
Task Description The task involves updating and tracking the total hours of raw audio available, the amount of audio that has been uploaded, and the remaining audio that is yet to be uploaded for each department. This information is critical for ensuring that all audio resources are properly managed and that no department falls behind in the uploading process and to ensure data availability at all times.
update in google sheet:
Completion Criteria
Accurate calculation of the total hours of raw audio for each department. Precise update of the total hours of audio uploaded for each department. Correct calculation of the remaining hours of audio to be uploaded for each department. All data should be compiled and presented in the table format provided.
Implementation
Subtask