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)

Evner: Excel, iPad, Visual Basic for Apps

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Australia

Projekt ID: #4039748

14 freelancers are bidding on average $635 for this job


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 in 25 dage
(125 bedømmelser)

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

$1000 AUD in 10 dage
(7 bedømmelser)

See your PMB

$350 AUD in 5 dage
(18 bedømmelser)

Hi Brendan - please see PM

$1800 AUD in 20 dage
(11 bedømmelser)

Hi, Please check private message for more details. Thanks

$750 AUD in 15 dage
(4 bedømmelser)

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 Flere

$400 AUD in 5 dage
(7 bedømmelser)

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 Flere

$700 AUD in 15 dage
(3 bedømmelser)

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

$299 AUD på 1 dag
(3 bedømmelser)

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 in 45 dage
(0 bedømmelser)

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 in 15 dage
(0 bedømmelser)

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

$250 AUD på 1 dag
(0 bedømmelser)

we are ready to start

$600 AUD in 9 dage
(0 bedømmelser)

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 in 7 dage
(0 bedømmelser)

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 Flere

$700 AUD in 15 dage
(0 bedømmelser)

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

$290 AUD in 4 dage
(0 bedømmelser)