Fetching data from an external database and linking it to an excel macro using Python
£40-50 GBP
Paid on delivery
First I need a employee database containing data about employee shifts. The data attributes for each employee shift will be the columns in excel form. Each employee will have their own excel sheet of different number of rows of data (shifts).
I need to calculate fatigue and risk for each employee after each shift (which corresponds to a new row in the database-Each shift has specific column values entered as a new row with data corresponding to column names of the excel sheet). To calculate this, the excel sheet already has built in macro which can be executed to calculate the fatigue and risk index for all the rows of data. To test this, you just need to enter a new row of 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 sheet is the excel file that will be specific to each employee detailing their shifts as rows.
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:
[login to view URL] a database of employee shifts based on 3 sample rows (3 sample shifts) and the 'defaults' form (see default_values screenshot-you can get this screen when you press the defaults button on the sheet). That is, I also want to store and fetch the data from the buttons in this form. These values affect the final formula to calculate the fatigue and risk index depending on what the current values are. These should be changeable in the database and I must be able to add information about more shifts to the database. I should also be able to create a new employee with information about his shifts.
[login to view URL] the data from the database regarding an employee and all his shifts, fetch the current values in the defaults form and calculate the fatigue and risk index WITHOUT HAVING TO OPEN the excel form using Python.
3. Save the fatigue and risk index for the specific employee back to the database with Python
That is I want to find a way to avoid opening the form and directly using Python to manipulate data inside the database and excel macro to calculate fatigue and risk index. 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.
The password to view the excel form and macros is 1234.
Feel free to ask any questions if you need more information. Looking forward to working with you!
Project ID: #31270570
About the project
Awarded to:
Hi there I have lots of experience processing data in python. I can access the built in formulae and convert them into python code no problem, will not need to open excel to run that function. I have been scraping and More
13 freelancers are bidding on average £53 for this job
Hi there,I'm biddin on your project "Fetching data from an external database and linking it to an excel macro using Python" I have read your project description and i'm an expert in Python and machine learning therefor More
Greetings! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can c More
Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA, Python I promise I will finish this project with high More
Hi, I've read your description carefully. I have full experience with Python I've also worked on several similar projects. So I can complete your project with high quality on time. Looking forward to hear more about th More
Hi I read your requirements and that meet with my skill set. I can this using python libraries like pandas. please come inbox to start work regards Irfan
Hi there , I have read your detailed instruction and I think I am capable to do the work. your description is very clear thus I am expecting positive reply asap. I have certifications on MS Word, Excel and PowerPoint More
Hi sir/madam I can fetch the employees shift details with database based on your criteria and provide you with clear cut details. I have a 5 years of working experience in Ms Excel and I'm a working professional in th More
Hey! As a experience professional in this field, I have gone through your project details and am confident that I can complete it. Please leave me a message to discuss more. Thank you, Vani
