Annulleret

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)

Færdigheder: 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 freelancere byder i gennemsnit $635 for dette job

fastudiovw

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)
6.1
allblue

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)
5.1
pkcyber

See your PMB

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

Hi Brendan - please see PM

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

Hi, Please check private message for more details. Thanks

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

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 Mere

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

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 Mere

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

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)
2.6
ashugarora

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)
0.0
neel1311991

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)
0.0
SavithaRavikiran

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)
0.0
nehaarora11

we are ready to start

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

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)
0.0
officeheroes

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 Mere

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

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)
0.0