Lengkap

I would like to hire an Excel Expert

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.

Kemahiran: Pemprosesan Data, Excel

Lihat lagi: excel spreadsheet consultant, excel expert jobs, excel experts forum, excel programmers for hire, excel experts for hire, excel experts online help, excel expert needed, excel expert certification, excel expert hire, excel expert on hire, excel expert services for hire, excel expert sg hire, hi webexpertssss i noticed your profile and would like to offer you my project i have few website correction and reset the pw fo, hire excel expert, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i need an excel expert, i want an excel expert who works on my excel sheet according to my requirements, i want to hire an excel expert in the leesburg va area, where can i hire excel expert

Tentang Majikan:
( 1 ulasan ) Coffs Harbour, Australia

ID Projek: #17919361

Dianugerahkan kepada:

citijayamala

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 Lagi

$100 AUD dalam 3 hari
(56 Ulasan)
5.4

10 pekerja bebas membida secara purata $128 untuk pekerjaan ini

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lagi

$200 AUD dalam 2 hari
(629 Ulasan)
8.3
schoudhary1553

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 Lagi

$200 AUD dalam 3 hari
(280 Ulasan)
7.6
younus15

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.

$90 AUD dalam 3 hari
(88 Ulasan)
5.5
zaahidali61

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 Lagi

$100 AUD dalam 3 hari
(5 Ulasan)
2.8
adiddaddy3067

Data Analyst with knowledge of Analytical and Business tools- R, SAS, TABLEAU, VISUAL BASIC APPLICATION (VBA), MICROSOFT EXCEL ADVANCE (PIVOTABLE, CHARTS AND FORMULAS).

$155 AUD dalam 3 hari
(2 Ulasan)
1.2
itsparx

Hi, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have got Rich experience in Jooml Lagi

$208 AUD dalam 7 hari
(0 Ulasan)
0.0
arshad54

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.

$88 AUD dalam 3 hari
(0 Ulasan)
0.0
elrajaouia1949

j'aurais l'honeur de travailler avec vous ! je ferais mon mieux pour vous donner le meilleur travail ! merci

$111 AUD dalam 4 hari
(0 Ulasan)
0.0
joshiarvind28

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.

$30 AUD dalam 3 hari
(0 Ulasan)
0.0