Cod client 108

Cod

Client

Nume

ClientAdresa Localitate Jude Cod Fiscal

100 Client1 Str. Florilor nr.36 bl.8 Pitesti Arges 34655645

101 Client2 Str. Sincai nr.45, sc. B Bucuresti Bucureti 13246873

102 Client7 Str. Averescu Brasov Braov 96325814

104 Client4 Str. 1 Mai nr.36, bl A8 Ploiesti Prahova 75315946

105 Client3 Str. 9 Mai Bucuresti Bucureti 23187946

107 Client7 Str. Plopilor nr.1 Brlad Vaslui 64821973

108 Client8 Str. Luteran nr. 3 Deva Hunedoara 57351984

S se formateze condiional codul fiscal (G4:G10) ce corespunde unui cod client preluat din celula E2.

Data cotaiei BNR Curs EuroData cotaiei

BNR

Mon, 10/01/2011 4.142 Mon, 17/01/2011

Tue, 11/01/2011 4.143 Sun, 23/01/2011Wed, 12/01/2011 4.148

Thu, 13/01/2011 4.132

Fri, 14/01/2011 4.134

Mon, 17/01/2011 4.139

Tue, 18/01/2011 4.150

Wed, 19/01/2011 4.175

Thu, 20/01/2011 4.180Fri, 21/01/2011 4.201

Mon, 24/01/2011 4.203

Tue, 25/01/2011 4.198

Wed, 26/01/2011 4.178

Thu, 27/01/2011 4.160

Fri, 28/01/2011 4.231

Mon, 31/01/2011 4.217

Tue, 01/02/2011 4.224

Wed, 02/02/2011 4.231

Thu, 03/02/2011 4.238

Fri, 04/02/2011 4.245

Mon, 07/02/2011 4.251

Tue, 08/02/2011 4.258

Wed, 09/02/2011 4.265

Thu, 10/02/2011 4.272

Fri, 11/02/2011 4.279

Mon, 14/02/2011 4.285

Tue, 15/02/2011 4.292

Wed, 16/02/2011 4.299

Thu, 17/02/2011 4.306

Fri, 18/02/2011 4.313

Mon, 21/02/2011 4.319

Tue, 22/02/2011 4.326

Wed, 23/02/2011 4.333

Thu, 24/02/2011 4.340

Fri, 25/02/2011 4.346

Mon, 28/02/2011 4.300

Curs Euro

recuperat

4.139 lei/Euro

4.201 lei/Euro

Cod

produs

Denumire

produs

Pre

unitar ()

Data Factura 06 February 2014 1001 Produs1 36.25

1002 Produs2 19.00

Curs Euro 4.522 lei 1003 Produs3 37.50

1004 Produs4 75.00

1005 Produs5 17.50

Cod produs Cantitate livratValoare

factur (lei) 1006 Produs6 22.50

1002 1.7 t 141.851 1007 Produs7 55.00

1018 1.2 t 104.187 1008 Produs8 15.00

1007 2.5 t 618.044 1009 Produs9 41.00

1020 1.9 t 148.896 1010 Produs10 33.75

1011 Produs11 12.50

1012 Produs12 16.00

1013 Produs13 29.25

1014 Produs14 30.00

1015 Produs15 55.00

1016 Produs16 19.50

1017 Produs17 32.50

1018 Produs18 18.00

1019 Produs19 20.25

1020 Produs20 17.33

Cantitate

discount

Discount

(%)Data debut promoie

- -

1.0 t 7% Monday, November 07, 2011

- -

- -

- -

1.3 t 15% Sunday, May 01, 2011

2.0 t 3% Tuesday, October 25, 2011

1.7 t 10% Friday, July 01, 2011

- -

- -

- -

2.5 t 15% Wednesday, June 01, 2011

- -

- -

- -

- -

1.3 t 18% Monday, August 15, 2011

2.0 t 10% Sunday, March 20, 2011

1.0 t 6% Thursday, November 10, 2011

- -

Data sfrit promoie

Wednesday, November 30, 2011

Saturday, May 21, 2011

Sunday, November 06, 2011

Monday, August 01, 2011

Thursday, June 30, 2011

Wednesday, August 31, 2011

Sunday, March 27, 2011

Thursday, November 17, 2011

Nume PrenumeDepartament

funconal

Funcia de

ncadrare

Data

angajrii

Vechimea

(ani)

Salariu

ncadrare

POPESCU Viorel Dan Resurse umane jurist Apr-2007 6 ani 1,180

MIHAI Carmen IT designer Web Sep-1980 33 ani 2,800

POPA Florin Marketing agent publicitate Jun-1999 14 ani 1,980

ALBU Constanta Marketing analist date Feb-1991 22 ani 2,670

MANESCU Andreea IT programator Apr-2003 10 ani 2,450

VISAN Alexandra Asigurri agent asigurri Nov-1993 20 ani 2,500

< 5 ani 5-10 ani 10-15 ani 15-20 ani 20-25 ani

Vechime

Funcii0 ani 5 ani 10 ani 15 ani 20 ani

analist date 1,000 1,200 1,900 2,350 2,670

designer Web 1,050 1,180 2,300 2,550 2,710

programator 1,120 1,400 2,450 2,600 2,790

jurist 1,100 1,180 2,500 2,670 3,030

agent asigurri 1,000 1,070 2,080 2,200 2,500

agent publicitate 1,034 1,100 1,980 2,250 2,610

1180

2800

1980

2670

2450

2500

>=25 ani

25 ani

2,900

2,800

3,200

3,350

2,900

3,000

Curs Euro 4.522 lei

Destinaia Braov

Denumire

produs

Cantitate

livrat

Cheltuieli

transp.VLOOKUP HLOOKUP

Produs1 1.2 t 113.05 PRODUS 1 113.05 113.05

Produs2 1.4 t 135.66 PRODUS 2 135.66 135.66

Produs3 2.9 t 305.24 PRODUS 3 305.235 305.235

Cantitate

transportBraov Bucureti Ploieti Predeal Sinaia

1.0 t 20.00 13.75 13.50 15.00 12.50

1.1 t 22.50 17.50 15.00 30.00 25.00

1.2 t 25.00 12.50 22.50 38.75 37.50

1.3 t 27.50 15.00 30.00 52.50 50.00

1.4 t 30.00 18.75 37.50 65.00 62.50

1.5 t 32.50 22.50 45.00 77.50 75.00

1.6 t 35.00 26.25 52.50 90.00 87.50

1.7 t 37.50 30.00 60.00 102.50 100.00

1.8 t 40.00 33.75 67.50 115.00 112.50

1.9 t 42.50 37.50 75.00 127.50 125.00

2.0 t 45.00 41.25 82.50 140.00 137.50

2.1 t 47.50 45.00 90.00 152.50 150.00

2.2 t 50.00 48.75 97.50 165.00 162.50

2.3 t 52.50 52.50 105.00 177.50 175.00

2.4 t 55.00 56.25 112.50 190.00 187.50

2.5 t 57.50 60.00 120.00 202.50 200.00

2.6 t 60.00 63.75 127.50 215.00 212.50

2.7 t 62.50 67.50 135.00 227.50 225.00

2.8 t 65.00 71.25 142.50 240.00 237.50

2.9 t 67.50 75.00 150.00 252.50 250.00

3.0 t 70.00 78.75 157.50 265.00 262.50

INDEX

113.05

135.66

305.235