I would like to hire an Excel Expert
$30-250 AUD
Paid on delivery
I work as a public hospital radiologist and report on both private and public patients. Im paid hourly for public work, and need to make a deduction from hours billed each day, depending on time spent on private patients.
Every month i get a spreadsheet with the private patients which ive reported on for each day, and i need to total them up, allocating an amount of time based on the complexity of the case (which is in turn based on the amount billed for, using this excel formula: - column K represents the billing value for the specific case:
=IF(K64>550,0.5,IF(K64>200,1/6,IF(K64>69,1/12,IF(K64>100,5,1/60))))
Entries for days which i wasnt in the hospital are ignored.
I then to produce a spreadsheet, which hopefully i can continually add to, of the hours for each day worked that should be deducted. I will then manually enter this in the hospital billing application.
Can you help me create a workflow that will facilitate this? The data arrives in an email with an attached spreadsheet, entitiled [login to view URL] or [login to view URL] . Ive attached an example spreadsheet, with confidential information removed.
Steps:
Sort by service date
Hide dates that i didnt work
Apply "multiplier" using that formula
Total up the time for each day
export the data to a different spreadsheet which will be continally updated.
Ive attached the usual spreadsheet that i get given for this month.
Project ID: #17919361
About the project
Awarded to:
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar More
9 freelancers are bidding on average $125 for this job
This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel Expert. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd lik More
I'm interested in your project. Please send me a message so that we can discuss more.I would also complete your project with the highest precision and quality.
I hold master degree in Business Administration (Finance). I am experience data entry operator accountant and auditors having more than 9 years’ experience with national and multinational clients. I hope will be hear p More
I have completed many projects in Microsoft Office, Excel sheets, Spread sheets. I am very dedicated towards my work, and have the ability of delivering every project on time.
j'aurais l'honeur de travailler avec vous ! je ferais mon mieux pour vous donner le meilleur travail ! merci
Dear Sir/Madam, I have interest in your project work. I have idea about work and formula. Your will be done on time with accuracy. you can trust on me about your work.