Suoritettu

69362 excel repot needed urgent

I have data that i derived from sql database and put in an excel spread sheet. it has 3column 1-name 2- membership Number 3-status the status can be one of the folowing 1-checked in 2-checkedin_ late 3-cancel/patient 4-no show 5-discharged from service 6-dic cancel each individual have multiple enties for different dates i need a report that calculate the percentage of attendance for each individual where the (total appointments) should be the sum of all checked in plus checkedin_late plus canceled/patient plus no show only then calculate the attendace percentage where where checked in plus checkedin late less than 70% of the (total aoopintment) then generate a list of names the meet this criteria plus thier total appointments plus total checked in plus total checkedin_late plus total canceled/patient plus total no show I have a sample excel sheet for you to work with or to look at for further clerafication. i need this report as soon as possible it shouldnt take a long time if you are good at excel reporting

Taidot: .NET, kaikki käy, C-ohjelmointi, Perl, Visual Basic

Näytä lisää: programming in excel, programming for excel, excel data programming, excel c# programming, appointments plus, sql less than, programming with excel, less than excel, excel less than, urgent need for excel, urgent excel, Time Attendance, sql work needed, report from excel, excel to sql, excel spread sheet, excel service, Excel report, dic, multiple excel

Tietoa työnantajasta:
( 12 arvostelua ) Troy, United States

Projektin tunnus: #1817378

Myönnetty käyttäjälle:

webprosl

Hello, I can give this to you back as an excel report in less than one day (maybe just a few hours if I am online when you choose me). I will create separate worksheets for the reports so you can simply paste new data Lisää

$30 USD 0 päivässä
(0 Arvostelua)
0.0