Source information from Excel flat file - Split out into 1900 sets; To be viewed on IPad

Each of our Regional Managers (RMs) is holding their own review with their own panel of Sales Representatives (Sales Reps). The RMs would like to view each of their Sales Reps performance data on their IPads via Dropbox.

I have an excel spreadsheet that contains our Sales Reps sales performance information such as number of clients, total sales revenue etc. Each Sales Rep sales information will need to be populated into a specific format (which I have mocked up in excel as well).

We have about 50 RMs and 1900 Sales Reps altogether so we need 1900 versions of this populated split out by each RM – each RM has 20-60 Sales Reps.

It is necessary that this is designed so that each RMs can only pick up the information belonging to their own panel of Sales Reps only.

Since the RMs are going to use Dropbox via their Ipads to view these during the review – the entire design of this must be IPad friendly. At present, I have developed a prototype using Excel – this will continue to be the source of the information but it is not a requirement that it needs to be displayed on the ipad using Excel (there are some issues with loss of formatting when Excel is viewed on the Ipad)

I have attached the spreadsheet with only 50 records and the mock up.

The final design must:

1) Be automated to import a flat file of Excel data and generate the Sales Rep data by each RM

2) Be quick for the RM to navigate and find one of their Sales Reps data (by the Sales Rep name)

3) Allow the RM to switch to another Sales Rep’s information with ease

4) Be automated so that new data can be loaded and refreshed periodically

5) Be flexible (the number of RMs and Sales Reps will change on a periodic basis)

6) Be flexible to allow for new data to be added to the Excel flat file and for it to be displayed for each Sales Rep (this will require me to be able to change the code that generates the Sales Rep information)

Kemahiran: Excel, iPad, Visual Basic untuk Aplikasi

Lihat lagi: will be holding, source formatting, source format, prototype review, prototype 3 review, it sales rep, find reps, excel out source, source information, find a sales rep, view source, split, sales excel, i need sales reps, i need a sales rep, find sales rep, Excel Formatting, excel 50/60, quick excel, excel contains, split file, data performance excel, excel spreadsheet source code, excel regional, excel split

Tentang Majikan:
( 0 ulasan ) Australia

ID Projek: #4039748

14 pekerja bebas membida secara purata $635 untuk pekerjaan ini


I have 20+ years of experience programming ms-access (vba), .net & sql server. At your disposal for any doubt or question, Regards Fabio

$750 AUD dalam 25 hari
(125 Ulasan)

Hello there! I created a similar app for Medical Sales Representatives. We want to help you with this one.

$1000 AUD dalam 10 hari
(7 Ulasan)

See your PMB

$350 AUD dalam 5 hari
(18 Ulasan)

Hi Brendan - please see PM

$1800 AUD dalam 20 hari
(11 Ulasan)

Hi, Please check private message for more details. Thanks

$750 AUD dalam 15 hari
(4 Ulasan)

It is very interesting project. I am computer science student last year. If you choose me, in 2 days yo'll have a model that we will improve . Just asking: it wouldn't be better with an access database? The solution Lagi

$400 AUD dalam 5 hari
(7 Ulasan)

Might I recommend an alternate way of viewing such data, especially considering you require some dashboard capability? Tableau is a tool with an iPad app that ca nwork very well for you. I can develop your dashboard Lagi

$700 AUD dalam 15 hari
(3 Ulasan)

Dedicated programming professional ready to take care of this project. Please note private message I've just sent you.

$299 AUD dalam sehari
(3 Ulasan)

Hi, We have made quiet a lot of different corporate ipad apps. we can demonstrate our expertise in this area once given the chance.

$700 AUD dalam 45 hari
(0 Ulasan)

we are a team of 4 programmers, will deliver best quality for a reasonable cost, all i need is a good review on freelancer and long term business relationship...

$350 AUD dalam 15 hari
(0 Ulasan)

Hi I am proficient in MS Excel, being well-versed with Macros, look-ups and pivot tables. Please see PM.

$250 AUD dalam sehari
(0 Ulasan)

we are ready to start

$600 AUD dalam 9 hari
(0 Ulasan)

I have experience in 10 different projects creating similar application. My application will be simple to use and won´t need any change if the SR or Sale Team change.

$700 AUD dalam 7 hari
(0 Ulasan)

Hello, We are a UK based company with over 20 years experience in provide reporting solutions. We would be delighted to help you with your project. There are a couple of ways of doing this which would be more Lagi

$700 AUD dalam 15 hari
(0 Ulasan)

Dear, I am interested by your offer. I am ready to program the macro as soon as possible.

$290 AUD dalam 4 hari
(0 Ulasan)