Excel based performance report - VBA update / Redesign

$250-750 CAD

Teljesítve

Kiadva ekkor:

több mint 6 évvel ezelőtt

$250-750 CAD

Teljesítéskor fizetve

PLEASE REVIEW THIS DOCUMENT BEFORE CONTACTING ME. We have a performance report developed in VBA that was assembled at the beginning of 2017. We need to make some updates to the report and I'd like a design refresh. The report lists doctors that have ordered a particular service from our company. The report separates the orders by province and highlights doctors that are ordering the test for the first time. (new doctors). For 2018 we need to: - Make changes to the abbreviations that represent the Provinces in the Raw data (MA --> MB, NF --> NL, SA --> SK, AL --> AB, YK --> YT) - For Ontario, separate the province into 2 sales territories (based on Forward Sorting Addresses) - In addition to the list of doctors that are ordering the service for the first time, we also need a list of doctors that haven't ordered the test in 3 months in a separate tab along with the month that they last ordered. - Redesign the report output so that its nicer looking - The heat map should be removed. I have included a copy of our current report along with an example of how the raw data is submitted, with new province abbreviations. Happy to discuss further via Skype

Visual Basic for Apps

Projektazonosító: 15851642

A projektről

13 ajánlat

Távolról teljesíthető projekt

Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Proposed Milestones $500 CAD - Please pay me once job is 100% done.

$300 CAD 3 napon belül

5,0

(640 értékelés)

8,3

13 szabadúszó adott átlagosan $364 CAD összegű árajánlatot erre a munkára

@cgullapalli

HI, I am good at Excel and vba. I have looked at the partially. Happy to discuss further to get the complete requirements. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Excel, vba. Proposed Milestones $300 CAD - Milestone

$300 CAD 3 napon belül

5,0

(792 értékelés)

7,8

@P0L

Hello, I’m an Excel/VBA expert and I would like to help you with the changes you need in the reports. Please check my profile and contact me to discuss further details. Regards.

$300 CAD 5 napon belül

4,9

(280 értékelés)

7,2

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Models Htos propuestos $300 CAD - final delivery SO: Win or Mac?

$300 CAD 5 napon belül

5,0

(217 értékelés)

6,8

@zu02

Better way via ms Access software with Excel automation.. Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones $750 CAD - default

$750 CAD 6 napon belül

4,7

(32 értékelés)

5,8

@liangjongai

I can help you. I've an experience of works like yours. Ping me any time. Stay tuned, I'm still working on this proposal.

$555 CAD 10 napon belül

5,0

(9 értékelés)

5,1

@vmadhavan15

I am not a random bidder. Could you please provide more details via skype. Please ping me if you are interested with my proposal and thank you

$300 CAD 5 napon belül

4,9

(23 értékelés)

4,8

@insidenetsoft

SKYPE Bonjour, We could discuss the changes that you want to implement for starting fresh with this file in 2018 and I could come with some ideas following the other projects I was involved in. PRICE will be established together based on the detailed specifications in order to implement the best possible solutions for each functionality. My last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that send emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation Don’t hesitate to contact me on chat to discuss the solutions for your project. Regards, Marius

$280 CAD 5 napon belül

5,0

(28 értékelés)

4,3

@nurnga1218

Hi, I've downloaded your documents and I think I can do what you want. But we can't discuss via skype. We only allowed to discuss with this platform only, don't worry I'll assist you Relevant Skills and Experience I am an excel and VBA expert anyway. Proposed Milestones $250 CAD - Excel Report

$250 CAD 4 napon belül

5,0

(41 értékelés)

4,5

@reedsystems

Hi, how are you today? I read your request, from your description, I understand that you need to make some changes to some abbreviations, split sales territories, redesign reports......... Relevant Skills and Experience I have up to 5 years of experience working with Microsoft Suite, building apps based on them (especially MS Access and MS Excel) with macros, vbas, reports.... so be rest assured that I can provide you with the required changes. You can contact me here or via sk ype "olarid29" to discuss the details.

$250 CAD 7 napon belül

3,6

(2 értékelés)

1,6

@adrianbrough

I would make the changes requested and tidy up the reports to have a cleaner fresher look and to more clearly separate out the different data areas. I would consult with you for guidance here. Relevant Skills and Experience I'm a database developer with extensive commercial analysis experience in MS Excel Access and SQL using vba and pivot tables. I'm used to working with business critical systems. Proposed Milestones $350 CAD - Deliver project without design changes $150 CAD - Make design changes Additional Services Offered $300 CAD - Put data in MS Access and Normalize $200 CAD - Provide additional reports to aid with understanding buying / non buying doctor groups Details around the spitting of Ontario please. Also ideas for design improvements.

$500 CAD 10 napon belül

0,0

(0 értékelés)

0,0

@allenmattson

Hello, I have read and reviewed your project in its entirety and I am very interested in helping you. I am 100% confident that this project is well within my skill set. Could we set up a Skype 1 on 1 this week? Message me and I’ll look forward to working with you.

$388 CAD 30 napon belül