Analytics 2
Budget: $30 – $250 USD
We are looking to transform a CSV into something more useful for the project owners. Our ask is that a script/workflow will be created to automatically create 9 data tabs in an XLSX workbook and 9 stats tabs from the input CSV. The data tabs will be sorting/filtering the main CSV dataset into 9 smaller sets. The stats tabs will be identical in nature, just one stats tab for each of the 9 XLS workbook tabs. A small handful of charts and infographs will be required as well. This entire process should be automated and not require any administrative effort other than running the script.
End result is that the project owners should then be able to open a Word DOC/template, point to one of the transformed XLS files, and MSFT Word would then output 9 reports - one from each of the stats tabs in the XLS workbook. This should be a Word Ribbon-Bar style of add-in, python script, or MSFT Power Automate workflow that would allow the project owner to select the XLS then the script/app/workflow would output 9 word documents to a directory. Again, this entire process should be automated and require no administrative action other than selecting the proper XLS file and the directory to write the reports to.
Ideally, the transformation script/application/workflow will run on Windows 10/11.
End result is that the project owners should then be able to open a Word DOC/template, point to one of the transformed XLS files, and MSFT Word would then output 9 reports - one from each of the stats tabs in the XLS workbook. This should be a Word Ribbon-Bar style of add-in, python script, or MSFT Power Automate workflow that would allow the project owner to select the XLS then the script/app/workflow would output 9 word documents to a directory. Again, this entire process should be automated and require no administrative action other than selecting the proper XLS file and the directory to write the reports to.
Ideally, the transformation script/application/workflow will run on Windows 10/11.