Linking Python with Excel form and Macro for data manipulation
Budget: £20 – £40 GBP
I need to calculate fatigue and risk for employees using the given excel sheet. There are two files, fatigue risk calc (decrypted) and the template file. All the cells are already linked to the formulae and you just need to enter data in the cells and press calculate to view the result. You can check the decrypted file to understand the VBA macro (you need to enable developer mode in excel and click visual basic to look at the forms and macros - the macros are under module and forms are under forms) and the template file is the one I need to link the Python code with to fetch data from cells and forms.
There are two modes, risk index calculator and fatigue index calculator, and you can switch between them using the mode button
What I want to do:
1. I need a way to interact with the Commuting time, Type of Job: Workload, Type of Job: Attention, and breaks under the 'Defaults' form (see default_values screenshot- you can get this screen when you press the defaults button on the sheet) in Python. That is, I'm looking for a way to manipulate the data in this form directly with Python.
2. I want to be able to automate the form to calculate the fatigue and risk index after every new row in the excel form (that is after data for every new employee is added). To do this, you'll need to fetch data from all the relevant cells and calculate it link it to the calculate index button to run the built in formula and fetch the result from the result cells in Python again.
Feel free to ask any questions if you need more information. Looking forward to working with you!
There are two modes, risk index calculator and fatigue index calculator, and you can switch between them using the mode button
What I want to do:
1. I need a way to interact with the Commuting time, Type of Job: Workload, Type of Job: Attention, and breaks under the 'Defaults' form (see default_values screenshot- you can get this screen when you press the defaults button on the sheet) in Python. That is, I'm looking for a way to manipulate the data in this form directly with Python.
2. I want to be able to automate the form to calculate the fatigue and risk index after every new row in the excel form (that is after data for every new employee is added). To do this, you'll need to fetch data from all the relevant cells and calculate it link it to the calculate index button to run the built in formula and fetch the result from the result cells in Python again.
Feel free to ask any questions if you need more information. Looking forward to working with you!