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:
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.
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.
10 pekerja bebas membida secara purata $128 untuk pekerjaan ini
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.
Data Analyst with knowledge of Analytical and Business tools- R, SAS, TABLEAU, VISUAL BASIC APPLICATION (VBA), MICROSOFT EXCEL ADVANCE (PIVOTABLE, CHARTS AND FORMULAS).
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.
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.