Em Andamento

Datacrunching: extracting data from Excel file into SQL / compare data with other SQL / export results into Excel

1. DATA CRUNCHING

1. Export a EXcel file with about 15.000 entries, each with 15 columns, into MySQl or whatever database you like.?

2. Make an output in Excel so reporters can work with your results

3. Compare the SQL with an older SQL and merge them where possible

4. Extract questions and answer out of the source file according my instructions and create new data fields for some questions

5. In the end, you will have resorted the Excel-file into different columns and added fieldnames. Then you have to export the results to 6 XLS-files (sorry, but the reporters need to work with them)

2. SOME MACRO STUFF OR PHP STUFF

The answers you filed away according to my instructions will get a rating. So Q1.1. gets f.e. 1 point, Q2.2 gets 3 points etc. You will have to add all points and make a ranking according to the one with the highest number of points.

3. MAKE A MYSQL DUMP

Then you have to make a dump that's compatible with step 1.3

The project is phased: I need step 1 a.s.a.p, step 2 and 3 in max 2 weeks.

There is a 25% bonus if you manage to have the job done in time.

See for outline of the complete project: [url removed, login to view]

See for specific instructions of Phase 1:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

## Deliverables

**PART 1**

**? **

Watchinstructions here: [url removed, login to view]

**? **

**PITCH :** Make 3 data sets out of 1 by sorting and comparing with [url removed, login to view]: need output in 3 Excel Files, even when you hate XLS :)

**1 EXCEL FILE-****? ** **TWO TYPES OF HOMES

**? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? **ZT**

**VV** --? compare with MySQL dump ? V V ??"verpleeghuizen

? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? VV-verzorgingstehuizen

Resulting in 3files

[url removed, login to view]

2.VV-verpleeghuizen

3.Vv-verzorgingshuizen

?

?

**PART 2**

Watchinstructions here: [url removed, login to view]

**Sort the columns like this in the output file:**

**OE_CODE- OE_NAAM - OE_PLAATS- CONCERN_PLAATS? - CONCERN_NAAM CONCERN_KVK-COMMENT**

**PART 3**

Watchinstructions here: [url removed, login to view]

**PITCH:** ? Need to extract the answersof? a series of questions, whichwill result in 6 data sets. Output needs to be 6 Excel files, all starting with**OE_CODE- OE_NAAM - OE_PLAATS-CONCERN_PLAATS? - CONCERN_NAAM CONCERN_KVK-COMMENT??" (**

How to find thequestions and extract the answers?

The questions canbe found under three tabs, **CQ**, **ZI** and **ORG**

**CQ-questions**

**Check tab CQ field D, “Indicator??.**

Each question canhave three categories with each time unique answers.? The three categories are decided by SOORT : iview/pg and [url removed, login to view] answer can be found in column G, **gecorrigeerdescore**Extract the unique answer for eachcategory like this

[url removed, login to view] [url removed, login to view] [url removed, login to view]

Also include thethree columns **digimv2008_id** ? **sterren**and **pilot**. You have alreadyalready **concern_kvk** and **oecode** from part 2, include them (andany other fields if I forgot some)

**ZI-questions**

**Check tab ZI field C, “Indicator??**

The values youuse for the answers are column E (prestatie_index). Also include the fivecolumns **digimv2008_id** ? **sterren****pilot** **aantal** **onbekend**. Youhave already **concern_kvk** and **oecode** from part 2

This time youdon’t have? a field like **SOORT** as in the CQ-TAB, so you need tomake something up yourself. Look at OECODE 153

This one has 2answers for question 7.2 (C, indicator) and 4 answers for question 4.1. Extractthem like this

1 answer: Q4.1.1.

2 answers [url removed, login to view] Q4.1.2

3 answers Q4.1.1, Q4.1.2 and [url removed, login to view]

4 answers Q4.1.1, Q4.1.2. , [url removed, login to view] and [url removed, login to view]

**ORG-questions**

**Check tab ZI field C, “Indicator??**

Straightforwardstuff, answers are in **waarde**. Pleaseinclude fiels **pilot. If you get 2 ormore values, like OECODE? 4092,file it like this:**

**? **

1 answer: Q8.3.1.?

2 answers [url removed, login to view] Q8.3.2

?

etc.

Done? Now we need6 files for the reporters:

?

Resulting in 3files

1.ZT-CQQuestions

2.ZT-ZIquestions

3.VV-verpleeghuizen-CQ questions

4.VV-verpleeghuizen-ZI questions

5.Vv-verzorgingshuizen-CQ questions

6.VV-verzorginshuizen-ZI questions

?

?

**PART 4**

**We will give each data field some points and needto calculate the total number of points.**

**PART 5**

**Export it back to the MySQL database and adapt it.**

Habilidades: PHP

Ver mais: Work from homes, sorting sets, sorting of data, php to excel export, php pg, pg&e, job homes, how to find a part time job, how to find a file in linux, highest rating, highest ranking, get answers now, export job, excel out source, excel macro how to, answer tab, answers from, 3 d max, t-sql with, p sql, max p, homes job, zi, vv, sort excel

Acerca do Empregador:
( 15 comentários ) Amsterdam, Netherlands

ID do Projeto: #2971609

Premiar a:

vertixsystems

See private message.

$595 USD em 33 dias
(11 Avaliações)
4.8

10 freelancers estão ofertando em média $709 para este trabalho

eztechsystems

See private message.

$2040 USD in 33 dias
(14 Comentários)
6.1
edreamzinc

See private message.

$1020 USD in 33 dias
(24 Comentários)
5.1
vw7258315vw

See private message.

$510 USD in 33 dias
(48 Comentários)
4.7
DaSatti

See private message.

$425 USD in 33 dias
(29 Comentários)
4.8
engmalaa

See private message.

$425 USD in 33 dias
(22 Comentários)
4.4
longlostviking

See private message.

$760.75 USD in 33 dias
(9 Comentários)
2.5
waseemarid

See private message.

$467.5 USD in 33 dias
(1 Comentário)
0.0
joshnirmal

See private message.

$425 USD in 33 dias
(2 Comentários)
0.0
Hadia788

See private message.

$425 USD in 33 dias
(2 Comentários)
0.0