tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lisa_gang__22261__EPE_APRIL_2002
Sheet: APRIL (14)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-04-14 00:00:00
HR ENDING | . | FOUR CORNERS | FOUR CORNERS |  | EDDY | EDDY | EDDY
Pacific | Mountain | SALE | SALE |  | SALE | SALE | SALE OPTION
Daylight | Standard | SPS | EPMI |  | SPS | SPS | SPS
Time | Time |  | 22.25
 |  | ON GOING DAILY | ON GOING DAILY |  | FOR THE DAY | FOR THE DAY | FOR THE DAY
 |  | 4/1/02-4/30/02 | 4/1/02-4/30/02 |  | 4/1/02-4/30/02 | 4/1/02-4/30/02 | 4/1/02-4/30/02
 |  | PSCO TAG#55849 | EPMI TAG#124;125 |  | SPS TAG#55814 | SPS TAG#55812 | SPS TAG#55813 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PDT | MST | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL | DIRECT BILL
0100 | 0100 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
0200 | 0200 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
0300 | 0300 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
0400 | 0400 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
0500 | 0500 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
0600 | 0600 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
0700 | 0700 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
0800 | 0800 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
0900 | 0900 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1000 | 1000 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1100 | 1100 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1200 | 1200 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1300 | 1300 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1400 | 1400 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1500 | 1500 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1600 | 1600 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1700 | 1700 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1800 | 1800 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
1900 | 1900 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
2000 | 2000 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
2100 | 2100 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
2200 | 2200 | 30 | 25 |  | -50 | -30 | -53 |  |  | 0
2300 | 2300 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
2400 | 2400 | 0 | 25 |  | 0 | 0 | 0 |  |  | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  | TOTAL SALES |  |  |  | TOTAL PURCHASES
 | PDT TOTAL
 |  | EPE(G)4C | EPE(G)4C
 |  | EPMI | EPMI |  | SPS (G) @ EDDY TIE | SPS (G) @ EDDY TIE | SPS (G) @ EDDY TIE
 |  | SPS | AZPS(T)FC3/PPD2 |  | PSCO | PSCO | PSCO
 |  | PSCO | PSCO |  | AEP | EPMI | EPMI
 |  | CRSP | CRSP(L)COOLIDGE |  | EPE (L) @ EDDY TIE | EPE (L) @ EDDY TIE | EPE (L) @ EDDY TIE
 |  | PSCO
 |  | PNM
 |  | PNM(T)4C345/4C345
 |  | PNM(L)4C345
Spreadsheet: 805689d1668837762-use-formula-in-cell-if-any-of-three-criteria-are-matched-s666-pq-if-any-of-three-criteria-are-matched-ans
Sheet: Mockup

 |  | The goal is to find information from F column to choose a fomula for G column. There are enough redundancies in column F to find distinct similarities, but in addition to the commonalities, there are also variable numbers and text in the fields. The green column is the best example of this. ie, F17 would be an example of a worst case scenario. Numbers or words may or may not be present, may change, or may even be in a different order, but "Samsung" and "TV" would always be there. |  |  |  |  |  | VLOOKUP? INDEX(MATCH)?
 |  | Car | TV | Year | Actual Description/Data | Results |  | Partial Text V1 | Partial Text V2 | Partial Text V3 | [NAME] to [NAME] to "Results"
 |  | Corvette |  | 1975 | 23 Corvette 92 |  |  | Corvette 92 | Corvette 91 | Corvette 64 | =CONCATENATE([@Car],[@Year])
 |  | Porsche 911 | [NAME] |  | Porsche TV |  |  | Samsung TV | Television | Fighter | =CONCATENATE([@TV],[@Year])
 |  | Corvette |  | 1962 | 963 Corvette 64 |  |  | Porsche TV | Porsche Set | [NAME] | =CONCATENATE([@TV],[@Car])
 |  |  | Samsung | 1993 | Samsung TV 632 1993 |  |  | Known text included in the original data. |  |  | [NAME] that need to be transferred to appropriate "Results" column.
 |  | Porsche [NAME] GT | TV Hybrid |  | The Porsche Set 935
 |  |  | Samsung | 1996 | 964 TV Samsung 243
 |  | Corvette |  | 2030 | 342 Corvette 91
 |  | Magic | [NAME] | Infinity | [NAME] 2030 Car
 |  |  | Sony | 1492 | Television 356
 |  | [NAME] | Hisense | 40K | [NAME] 63
 |  | Information from original sheet. |  |  |  | Final purpose of formula.
Spreadsheet: 01e03f53-5a1d-4da0-ae49-8ac144a5ff62
Sheet: Expenses

FUNDRAISING EVENT - RELATED EXPENSES/COSTS
*Please enter expense information in peach cells for all event costs incurred in the current fiscal year. For donated items/prizes, list item followed by "DONATED" in description column, donor name in vendor name and $0 in amount paid.
 | Non-cash prizes |  |  |  | Rent/facility costs
 | Description | Vendor | Amount Paid |  | Description | Vendor | Amount Paid
1 |  |  |  | 1
2 |  |  |  | 2
3 |  |  |  | 3
4 |  |  |  | 4
5 |  |  |  | 5
6 |  |  |  | 6
7 |  |  |  | 7
8 |  |  |  | 8
9 |  |  |  | 9
10 |  |  |  | 10
11 |  |  |  | 11
12 |  |  |  | 12
13 |  |  |  | 13
14 |  |  |  | 14
15 |  |  |  | 15
 | Other direct expenses
 | Description | Vendor | Amount Paid
1
2
3
4
5
 |  |  |  |  |  | Total Cash Prizes | 0
 |  |  |  |  |  | Total Exp Before Sales Tax
 |  |  |  |  |  | Total Sales Tax
 |  |  |  |  |  | Total Expenses
Spreadsheet: 102683d1300663347-excel-2007-solver-function-timedistance
Sheet: Sheet1

Denotes input data |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time Chart |  |  |  |  |  | Area Under Curve
Denotes data will be automatically calculated |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time | Distance |  |  |  |  | Distance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2200
Time drop ratio |  |  | Time Drop % |  | Solver Functions |  |  |  |  |  |  |  |  |  | 2400
1st | 3.636 |  | N/A |  |  |  |  |  |  |  |  |  |  |  | 2600 | 80
2nd | 2.235 |  |  |  | Time = |  | Delta Time = |  | New Time = |  |  |  |  |  | 2800 | 110
 |  |  |  |  | Sum = |  |  |  |  |  |  |  |  |  | 3000 | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3200 | 170
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3400 | 210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3600 | 230
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3800 | 240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4000 | 245
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4200 | 255
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4400 | 270
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4600 | 275
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4800 | 285
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 295
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5200 | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5400 | 305
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5600 | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5800 | 295
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6000 | 290
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6200 | 285
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6400 | 275
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6600 | 265
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6800 | 260
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10200
Spreadsheet: 34141d1231269648-how-do-i-organize-my-data-in-this-way-w
Sheet: Port, Trawler, Seiners

Port | Trawlers 10-14m | Trawlers 14-23m | Trawlers >23m | Seiners 10-14m | Seiners 14-23m | Seiners >23m
[NAME]
AGUILAS
ALCUDIA
ALGECIRAS
ALMERIA
ALTEA
AMETLLA DE MAR
[NAME]
ANDRAITX
ARENYS DE MAR
[NAME]
ARGUINEGUIN
ARRECIFE DE LANZAROTE
AVILES
AYAMONTE
BADALONA
BARBATE DE FRANCO
BARCELONA
BENICARLO
BERMEO
BLANES
BUEU
BURELA
BURRIANA
CADIZ
CALAFELL
[NAME]
CALPE
CAMARIÑAS
CAMBADOS
CAMBRILS
CAMPELLO
CANGAS
[NAME]
CARIÑO
CARREIRA-AGUIÑO
CARTAGENA
CASAS DE ALCANAR
CASTELLON
CASTRO URDIALES
CAYON
CEUTA
CIERVANA
CILLERO
CIUDADELA
COLINDRES
CORME
CULLERA
DENIA
EL GROVE
ELANCHOVE
ESTEPONA
FORMENTERA
FOZ
FUENGIROLA
FUENTERRABIA
GANDIA
GARRUCHA
GIJON
GUETARIA
GUIA ISORA
HUELVA
IBIZA
ICOD
ISLA CRISTINA
JAVEA
LA CORUNA
LA ESCALA
LA GUARDIA
LAGE
LAREDO
LAS PALMAS
LASTRES
LEPE
LEQUEITIO
LLANSA
LORBE
LOS CRISTIANOS
LUARCA
MALAGA
MALPICA DE BERGANTINOS
MARBELLA
MARIN
MAZARRON
MELILLA
MOAÑA
MOTRIL
[NAME]
MUROS
ONDARROA
ORIO
PALAMOS
PALMA DE MALLORCA
PALOS DE LA FRONTERA
PASAJES
PENISCOLA
PORTONOVO
PORTOSIN
PUENTEDEUME
PUERTO DE LA SELVA
PUERTO DE SANTA MARIA
PUERTO DE VEGA
PUNTA UMBRIA
REDONDELA
ROQUETAS DE MAR
ROSAS
ROTA
[NAME] LA RAPITA
[NAME]
SADA
SAN ANTONIO ABAB
SAN FELIU DE GUIXOLS
SAN PEDRO DEL PINATAR
SAN SEBASTIAN
SANLUCAR DE BARRAMEDA
SANTA POLA
SANTANDER
SANTANY
SANTOÑA
SANTURCE
SOLLER
STA CRUZ TENERIFE
STA. EUGENIA RIVEIRA
TALIARTE
TARIFA
TARRAGONA
TAZACORTE
TORREDEMBARRA
TORREVIEJA
VALENCIA
VALLE DE GRAN REY
VELEZ-MALAGA
VIGO
VILLAJOYOSA
VILLANUEVA Y GELTRU
VINAROZ
Spreadsheet: 150542d1334592804-excel-2007-excel-sorting-data-book1
Sheet: Sheet1

ColA | ColB | ColC | ColD |  | Helper 1 | Helper 2 | ColA | ColB | ColC | ColD
A | 6 | 5 | 11 |  | 11.002 | 17.001 | D | 8 | 9 | 17
B | 3 | 9 | 12 |  | 12.001 | 12.001 | B | 3 | 9 | 12
C | 4 | 2 | 6 |  | 6.001 | 11.002 | A | 6 | 5 | 11
D | 8 | 9 | 17 |  | 17.001 | 11.001 | E | 6 | 5 | 11
 |  |  |  |  |  | 6.001 | C | 4 | 2 | 6
E | 6 | 5 | 11 |  | 11.001
Spreadsheet: 731472d1620358712-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league
Sheet: EMC2

S.N. | Particulars | Bought Units | Unit or  EMC2 Price | Bought/ Sold Price ($US) | Bought/ Sold Price (ETH) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated Price ($US) | Status | Notes
1 | EMC2 @ Bittrex - Purchase 1 | 1521.83540399 | 0.00017153 |  | -0.26170827 | 13725.5 | 2017-12-06 00:00:00 | 2017-12-06 00:00:00 |  |  |  |  | SOLD
3 | EMC2 @ Bittrex - Sale 1 | -1521.83540399 | 0.00019119 |  | 0.29024749 | 13725.5 | 2017-12-06 00:00:00
4 | EMC2 @ Bittrex - Purchase 2 | 53.43940855 | 0.00018665 |  | -0.00999992 | 13725.5 | 2017-12-06 00:00:00 | 2017-12-06 00:00:00 |  |  |  |  | SOLD
5 | EMC2 @ Bittrex - Sale | -53.43940855 | 6.289e-05 |  | 0.00335293 | 14176.4 | 2018-01-13 00:00:00
6
7
8
9
10
11
 | Next Buy
 | EMC2 in [NAME] | 0
 | EMC2 in Bittrex | 0
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: dd5d2456-4672-452b-88b8-4dba63a0a2a0
Sheet: Sheet1

SHOW JUMPING SHOW | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | .... July 2012... | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Class 1 - Adult Equitation |  |  |  | Class 5 - Open |  |  |  | Class 8 - Beginners
1st | [NAME] | DD |  | 1st | [NAME] | [NAME] |  | 1st | Amber [NAME] | Stanley
 |  |  |  | 2nd | [NAME] | [NAME] |  | 2nd | [NAME] | [NAME]
 |  |  |  | 3rd | [NAME] | DD |  | 3rd | [NAME] | [NAME]
 |  |  |  |  |  |  |  | 4th | [NAME] | Sparky
 |  |  |  |  |  |  |  | 5th | [NAME] | [NAME]
 |  |  |  |  |  |  |  | 6th | Leah Bright | [NAME]
 |  |  |  |  |  |  |  | 6th | [NAME] | [NAME]
 |  |  |  |  |  |  |  | 6th | [NAME] | Splash
Class 2 - Beginners |  |  |  | Class 6 - Accumulator |  |  |  | Class 9 - Novice
1st | Paije Waters | Tilly |  | 1st | [NAME] | DD |  | 1st | [NAME] | Ginger
2nd | Nicola Colman | Jasmine |  | 2nd | [NAME] | [NAME] |  | 2nd | [NAME] | Jester
3rd | [NAME] | Rio |  | 3rd | [NAME] | [NAME] |  | 2nd | Amber [NAME] | Stanley
4th | Amber [NAME] | [NAME] |  |  |  |  |  | 4th | [NAME] | Tex
 |  |  |  |  |  |  |  | 4th | [NAME] | Misty
 |  |  |  |  |  |  |  | 5th | [NAME] | Mr [NAME]
 |  |  |  |  |  |  |  | 5th | [NAME] | Buffy
Class 3 - Novice |  |  |  | Class 7 - Junior Equitation |  |  |  | Class 10 - Intermediate
1st | Paije Waters | Tilly |  | 1st | [NAME] | [NAME] |  | 1st | [NAME] | Tex |  | Welcome to the Fox & Hounds Showjumping Results  Another day of showers   Thank you to all who braved the weather  we hope that you enjoyed your day  Congratulations to all our competitors and we hope to see you at the September Show.  Also remember this year we will be running an extra show in October to make up for the bad weather
2nd | [NAME] | Rio |  | 2nd | [NAME] | Mossie |  | 2nd | [NAME] | Jester
3rd | [NAME] | Riverman |  | 3rd | Holly Stear | [NAME] |  | 2nd | Amber [NAME] | Stanley
4th | [NAME] | Jasmine |  | 3rd | [NAME] | Splash |  | 4th | [NAME] | Mr [NAME]
5th | Amber [NAME] | [NAME] |  | 5th | [NAME] | Rolly |  | 4th | [NAME] | [NAME]
 |  |  |  | 6th | [NAME] | Tex
Class 4 - Intermediate |  |  |  | Class 7a - Lead Rein Equitation |  |  |  | Class 12 - Accumulator
1st | [NAME] | DD |  | 1st | Emily McClure | Demi |  | 1st | Amber [NAME] | Stanley
2nd | [NAME] | [NAME] |  |  |  |  |  | 2nd | [NAME] | [NAME]
3rd | [NAME] | Jasmine
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: C Well 9

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % Dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
C9 | 2017-08-08 00:00:00 |  | 1.14 |  |  |  |  |  |  |  |  | 740 |  |  |  | 3.62
C9 | 2018-08-15 00:00:00 |  |  | 83.3 | 19.9 | 81 |  | 169 | <1 | 42.7 | 129 | 610 |  |  |  | 3.6
Spreadsheet: 36020d1233765656-how-to-calculate-monthly-and-quarterly-reports-monthly-reporting-example-1-
Sheet: monthly-report

Project Type | Started | Finished | Employee | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00
International | 2008-11-11 00:00:00 | 2008-11-25 00:00:00 | Mr White | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-12 00:00:00 | 2008-11-26 00:00:00 | Mr Orange | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
International | 2008-11-18 00:00:00 | 2008-11-25 00:00:00 | Mr Blonde | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-24 00:00:00 | 2008-12-01 00:00:00 | Mr Pink | 5 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-25 00:00:00 | 2008-12-02 00:00:00 | Mr Blue | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-11-26 00:00:00 | 2009-01-15 00:00:00 | Mr [NAME] | 3 | 23 | 11 | 0 | 0 | 0 | 0 | 0
International | 2008-11-28 00:00:00 | 2008-12-19 00:00:00 | Mr Orange | 1 | 15 | 0 | 0 | 0 | 0 | 0 | 0
International | 2008-12-01 00:00:00 | 2009-01-16 00:00:00 | Mr Pink | 0 | 23 | 12 | 0 | 0 | 0 | 0 | 0
International | 2008-12-05 00:00:00 | 2008-12-19 00:00:00 | Mr Blonde | 0 | 11 | 0 | 0 | 0 | 0 | 0 | 0
Local | 2008-12-17 00:00:00 | 2009-01-19 00:00:00 | Mr White | 0 | 11 | 13 | 0 | 0 | 0 | 0 | 0
International | 2008-12-18 00:00:00 | 2009-01-15 00:00:00 | Mr [NAME] | 0 | 10 | 11 | 0 | 0 | 0 | 0 | 0
International | 2009-01-07 00:00:00 | 2009-01-21 00:00:00 | Mr Orange | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0
Local | 2009-01-12 00:00:00 | 2009-02-09 00:00:00 | Mr Orange | 0 | 0 | 15 | 6 | 0 | 0 | 0 | 0
Local | 2009-01-14 00:00:00 | 2009-01-28 00:00:00 | Mr [NAME] | 0 | 0 | 11 | 0 | 0 | 0 | 0 | 0
International | 2009-01-19 00:00:00 | 2009-02-02 00:00:00 | Mr White | 0 | 0 | 10 | 1 | 0 | 0 | 0 | 0
International | 2009-01-23 00:00:00 | 2009-02-06 00:00:00 | Mr Pink | 0 | 0 | 6 | 5 | 0 | 0 | 0 | 0
Local | 2009-01-26 00:00:00 | 2009-01-29 00:00:00 | Mr Blonde | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0
International | 2009-01-27 00:00:00 | 2009-02-10 00:00:00 | Mr [NAME] | 0 | 0 | 4 | 7 | 0 | 0 | 0 | 0
International | 2009-01-29 00:00:00 | 2009-02-06 00:00:00 | Mr Blue | 0 | 0 | 2 | 5 | 0 | 0 | 0 | 0
International | 2009-02-02 00:00:00 | 2009-03-13 00:00:00 | Mr Blonde | 0 | 0 | 0 | 20 | 10 | 0 | 0 | 0
Local | 2009-02-03 00:00:00 | 2009-02-10 00:00:00 | Mr Blue | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0
 |  |  |  |  | Report: January
 |  |  |  |  | Employee | Nbr of Projects | Nbr of Days worked | Nbr of International Projects | Nbr of Local Projects
 |  |  |  |  | Mr White | 2 | 23 | 1 | 1
 |  |  |  |  | Mr Orange | 2 | 26 | 1 | 1
 |  |  |  |  | Mr Blonde | 1 | 4 | 0 | 1
 |  |  |  |  | Mr Pink | 2 | 18 | 2 | 0
 |  |  |  |  | Mr Blue | 1 | 2 | 1 | 0
 |  |  |  |  | Mr [NAME] | 4 | 37 | 2 | 2
 |  |  |  |  | Report: Q1 (January-March)
 |  |  |  |  | Employee | Nbr of Projects | Nbr of Days worked | Nbr of International Projects | Nbr of Local Projects
 |  |  |  |  | Mr White
 |  |  |  |  | Mr Orange
 |  |  |  |  | Mr Blonde
 |  |  |  |  | Mr Pink
 |  |  |  |  | Mr Blue
 |  |  |  |  | Mr [NAME]
Spreadsheet: 707157d1607075068-using-index-match-function-to-create-multi-dependent-drop-down-lists-returning-error-quoting-tool-v10-1
Sheet: Master Pricing

Product Pricing
Product Services | Product Pricing
Annual Company Report for Workplace Health Testing | 130
Asbestos Air Sampling | 150
Asbestos Medical | 440
Breath Alcohol Testing | 10
Cardiovascular Disease Risk Check | 80
Chemical and Dust Exposure | 85
Comprehensive Workstation Assessment | 170
Drug Testing | 70
EAP Service Assessment | 185
Executive Health Screening Service | 555
Four Corners of Health Workshops | 180
[NAME] and [NAME] | 150
Hearing Test | 50
Heat and Cold Stress | 150
Indoor Air Quality Monitoring | 150
Industrial Lighting Monitoring | 150
Industrial Noise Monitoring | 150
Injury Triage (ACC Claim, Co-Payment Paid) | 140
Injury Triage (No ACC claim) | 140
Manual Handling Training Workshop | 300
Mask Fit Test | 85
Office Workstation Injury Prevention Group Presentation | 100
[NAME] | POA
Pre-employment Driver Test | 180
Pre-employment Functional Test | 180
Pre-employment Health Test | 60
Pre-employment Medical Test | 300
Recovery Package | 54
Rehabilitation Assessment at Workplace | 180
Resilience Package | 93
Spriometry/Lung Function Test | 60
Strategic Review of Health and Wellbeing at Work | 180
Vaccinations | 32.5
Vision Screening | 30
Workstation Screen - Group Education | 60
Workstation Screen – Individual Education | 80
Unsociable Hours Fee | 40
Stand-down Fee | 115
Travel time | 0.95
Travel Km | 60
Report Writing | 120
Spreadsheet: 3960f07a-4909-4565-8ff3-8df5347007c8
Sheet: Sheet1

UK POST AREA DECODER | Unnamed: 1
Last update: November 17, 2005
Post Area Code | Post Area Name
AB | Aberdeen
AL | St Albans
B | Birmingham
BA | Bath
BB | [NAME]
BD | Bradford
BH | Bournemouth
BL | [NAME]
BN | Brighton
BR | Bromley
BS | Bristol
BT | Northern Ireland
CA | Carlisle
CB | Cambridge
CF | Cardiff
CH | Chester
CM | [NAME]
CO | Colchester
CR | Croydon
CT | Canterbury
[NAME] | Coventry
CW | Crewe
DA | [NAME]
DD | Dundee
DE | Derby
DG | Dumfries
DH | [NAME]
DL | Darlington
DN | Doncaster
DT | Dorchester
DY | [NAME]
E | London (East)
EC | London (East Central)
EH | Edinburgh
EN | Enfield
EX | Exeter
FK | Falkirk
FY | Blackpool
G | [NAME]
GL | Gloucester
GU | [NAME]
GY | Guernsey
HA | [NAME]
HD | Huddersfield
HG | Harrogate
HP | [NAME]
HR | [NAME]
HS | [NAME]
[NAME] | Hull
HX | Halifax
IG | Ilford
IM | Isle of Man
IP | Ipswich
IV | Inverness
JE | Jersey
KA | Kilmarnock
KT | Kingston upon Thames
KW | Kirkwall
KY | Kirkcaldy
L | Liverpool
LA | Lancaster
LD | Llandrindod Wells
LE | Leicester
LL | Llandudno
LN | Lincoln
LS | Leeds
LU | Luton
M | [NAME]
ME | Medway
MK | [NAME]
ML | Motherwell
N | London (North)
NE | Newcastle upon Tyne
NG | [NAME]
NN | Northampton
NP | Newport
NR | [NAME]
NW | London (North West)
OL | Oldham
OX | Oxford
PA | Paisley
PE | Peterborough
PH | Perth
PL | Plymouth
PO | Portsmouth
PR | Preston
RG | Reading
RH | Redhill
RM | Romford
S | Sheffield
SA | Swansea
SE | London (South East)
SG | Stevenage
SK | Stockport
SL | Slough
SM | Sutton
SN | Swindon
SO | Southampton
SP | Salisbury
SR | Sunderland
SS | Southend-on-Sea
ST | Stoke-on-Trent
SW | London (South West)
SY | Shrewsbury
TA | Taunton
TD | Galashiels
TF | Teleford
TN | Tonbridge
TQ | Torquay
TR | Truro
TS | Cleveland
TW | [NAME]
UB | Southall
W | London (West)
WA | Warrington
WC | London (West Central)
WD | Watford
WF | Wakefield
WN | [NAME]
WR | Worcester
WS | Walsall
WV | Wolverhampton
YO | York
ZE | [NAME]
Spreadsheet: 865056d1712147672-display-rounding-help-please-sample
Sheet: Sheet1

Sample Table
Looking for DISPLAY ROUNDING DOWN to nearest 0.5 without affecting the cumulative results.
For example for days and half days holiday a person has based on an accrual.
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12
Accrued | 0.41 | 0.31 | 0.27 | 0.43 | 0.22 | 0.34 | 0.4 | 0.49 | 0.41 | 0.39 | 0.38 | 0.42
Available |  |  |  |  |  |  |  |  |  |  |  |  | This is the real data- if I use rounddown function it rounds down every figure to 0
 | 0 | 0.5 | 0.5 | 1 | 1.5 | 1.5 | 2 | 2.5 | 3 | 3.5 | 4 | 4 | Expected results value (if rounded down on display only)