tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 180072d1347470669-convert-multiple-rows-to-one-single-column-book1
Sheet: Sheet1

 | ServGrp | Serv1 | Serv2 | Serv3 | Serv4 | Serv8 |  | Row Labels
 | Sg1 | S1 | S2 | S3 | [NAME] | S8 |  | Sg1 |  | Sg1
 | Sg2 | S1 | S2 | S3 | [NAME] | S8 |  | S1 |  |  | S1
 | Sg3 | S1 | S2 | S3 | [NAME] | S8 |  | S2 |  |  | S2
 |  |  |  |  |  |  |  | S3 |  |  | S3
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  | S8 |  |  | S8
 |  |  |  |  |  |  |  | Sg2 |  | Sg2
 |  |  |  |  |  |  |  | S1 |  |  | S1
 |  |  |  |  |  |  |  | S2 |  |  | S2
 |  |  |  |  |  |  |  | S3 |  |  | S3
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  | S8 |  |  | S8
 |  |  |  |  |  |  |  | Sg3 |  | Sg3
 |  |  |  |  |  |  |  | S1 |  |  | S1
 |  |  |  |  |  |  |  | S2 |  |  | S2
 |  |  |  |  |  |  |  | S3 |  |  | S3
 |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  |  |  |  |  | S8 |  |  | S8
 |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 810402d1671735194-find-and-return-a-value-based-each-date-date-by-rev-etaf-using-glenn-based-on-date-
Sheet: POData

PONUM | Order Date | PartNum | RevisionNum
55564 | 2022-07-25 00:00:00 | 100-101-039 | PJ01SB
55650 | 2022-09-15 00:00:00 | 100-101-041 | ZF01JA
55653 | 2022-09-16 00:00:00 | 100-101-058 | EU02SE
55671 | 2022-09-26 00:00:00 | 100-101-039 | PJ02SB
55715 | 2022-10-07 00:00:00 | 100-101-058 | EU03SE
55726 | 2022-10-12 00:00:00 | 100-101-058 | EU04SE
55779 | 2022-11-11 00:00:00 | 100-101-058 | EU05SE
55801 | 2014-11-15 00:00:00 | 100-101-058 | EU06SE
55845 | 2022-12-21 00:00:00 | 100-101-041 | ZF0JA
Spreadsheet: 183231d1348755706-chart-axis-label-not-showing-sample
Sheet: Total Surveys Q3 2012 Summary

Totals
Week Ending: | # of Surveys
 |  | running total
2012-07-04 00:00:00 | 296
2012-07-11 00:00:00 | 73
2012-07-18 00:00:00 | 127
2012-07-25 00:00:00 | 288
2012-08-01 00:00:00 | 265
2012-08-08 00:00:00 | 292
2012-08-15 00:00:00 | 266
2012-08-22 00:00:00 | 303
2012-08-29 00:00:00 | 331
2012-09-05 00:00:00 | 418
2012-09-12 00:00:00 | 322
2012-09-19 00:00:00 | 328
2012-09-26 00:00:00 | 342
2012-09-30 00:00:00 | 398
Spreadsheet: 840099d1692427355-copy-all-data-to-a-summary-sheet-on-a-per-date-basis-copy-of-new-microsoft-excel-worksheet
Sheet: Sheet3

CODE | [NAME] | UOM | PROD CODE
615 | [NAME] 3X5KG | [NAME] | FG-000036
616 | [NAME] 20X500g | CTN20 | FG-000037
617 | [NAME] 15X700g | CTN15 | FG-000038
693 | [NAME] 20KG | CTN20 | FG-000114
673 | STARLAND SAVELOY 4X5KG | CTN4 | FG-000094
674 | STARLAND SAVELOY 20X500G | CTN20 | FG-000095
675 | STARLAND SAVELOY 15X700G | CTN15 | FG-000096
692 | STARLAND SAVELOY 20KG | CTN20 | FG-000113
730 | LAMB FLAP SLICED 4X5KG | CTN4 | FG-000155
591 | LAMB FLAP SLICED 20X500G | CTN20 | FG-000012
592 | LAMB FLAP SLICED 15X700G | CTN15 | FG-000013
Spreadsheet: geir_solberg__11243__4_13act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 686968d1594893974-multiple-averages-with-vlookup-sample-book
Sheet: Tabelle1

2020-06-06 00:00:00 | 16 | 18 | 21 | 25 | 40 | 49
2020-06-03 00:00:00 | 20 | 25 | 31 | 33 | 38 | 43
2020-05-30 00:00:00 | 5 | 18 | 33 | 35 | 42 | 43
2020-05-27 00:00:00 | 4 | 25 | 36 | 39 | 43 | 47 | Number | Appeared
2020-05-23 00:00:00 | 1 | 4 | 11 | 17 | 27 | 35
2020-05-20 00:00:00 | 9 | 31 | 33 | 42 | 45 | 49
2020-05-16 00:00:00 | 3 | 6 | 8 | 11 | 47 | 48
2020-05-13 00:00:00 | 12 | 17 | 20 | 21 | 43 | 46
2020-05-09 00:00:00 | 2 | 9 | 17 | 22 | 23 | 36
2020-05-06 00:00:00 | 5 | 19 | 31 | 34 | 43 | 47
2020-05-02 00:00:00 | 4 | 10 | 11 | 16 | 27 | 49
2020-04-29 00:00:00 | 1 | 5 | 7 | 32 | 36 | 41
2020-04-25 00:00:00 | 4 | 11 | 17 | 19 | 25 | 30
2020-04-22 00:00:00 | 9 | 13 | 29 | 36 | 39 | 49
2020-04-18 00:00:00 | 11 | 15 | 28 | 35 | 39 | 42
2020-04-15 00:00:00 | 11 | 22 | 24 | 27 | 30 | 46
2020-04-11 00:00:00 | 13 | 18 | 26 | 29 | 42 | 47
2020-04-08 00:00:00 | 5 | 18 | 22 | 25 | 31 | 44
2020-04-04 00:00:00 | 9 | 12 | 17 | 24 | 41 | 43
2020-04-01 00:00:00 | 4 | 15 | 22 | 39 | 46 | 48
2020-03-28 00:00:00 | 2 | 4 | 28 | 36 | 39 | 46
2020-03-25 00:00:00 | 6 | 11 | 18 | 21 | 35 | 49
2020-03-21 00:00:00 | 1 | 4 | 22 | 26 | 34 | 36
2020-03-18 00:00:00 | 13 | 19 | 22 | 28 | 31 | 34
2020-03-14 00:00:00 | 2 | 11 | 19 | 30 | 38 | 49
2020-03-11 00:00:00 | 7 | 23 | 24 | 41 | 47 | 49
2020-03-07 00:00:00 | 9 | 11 | 16 | 26 | 36 | 44
2020-03-04 00:00:00 | 14 | 19 | 22 | 29 | 46 | 47
2020-02-29 00:00:00 | 3 | 8 | 9 | 10 | 29 | 42
2020-02-26 00:00:00 | 2 | 5 | 18 | 33 | 45 | 47
2020-02-22 00:00:00 | 6 | 11 | 21 | 24 | 31 | 32
2020-02-19 00:00:00 | 3 | 7 | 11 | 22 | 27 | 42
2020-02-15 00:00:00 | 2 | 5 | 11 | 20 | 22 | 40
2020-02-12 00:00:00 | 2 | 10 | 24 | 31 | 41 | 49
2020-02-08 00:00:00 | 1 | 10 | 30 | 36 | 38 | 42
2020-02-05 00:00:00 | 13 | 16 | 31 | 37 | 39 | 49
2020-02-01 00:00:00 | 7 | 8 | 12 | 32 | 42 | 47
2020-01-29 00:00:00 | 17 | 22 | 24 | 39 | 48 | 49
2020-01-25 00:00:00 | 9 | 12 | 28 | 30 | 34 | 43
Spreadsheet: 08b7d657-f529-4170-9d54-da6ee8770bac
Sheet: Table 8.3

8.3 Unemployment rates
 |  |  |  |  |  | Months (a)
 | Annual average (a) (b) |  |  |  |  | 2013
Country | 2010 | 2011 | 2012 | 2013 |  | Oct | Nov | Dec | Jan
Australia | 5.21 | 5.08 | 5.22 | 5.65 |  | 5.78 | 5.77 | 5.850000000000001 | 5.98
Canada | 8 | 7.45 | 7.24 | 7.05 |  | 7 | 6.9 | 7.2 | 7
France | 9.72 | 9.61 | 10.24 | 10.81 |  | 10.8 | 10.8 | 10.8
Germany | 7.08 | 5.95 | 5.48 | 5.32 |  | 5.2 | 5.100000000000001 | 5.100000000000001
Italy | 8.43 | 8.38 | 10.7 | 12.24 |  | 12.5 | 12.8 | 12.7
Japan | 5.05 | 4.58 | 4.350000000000001 | 4.03 |  | 4 | 4 | 3.7
New Zealand (c) | 6.53 | 6.53 | 6.9 | 6.2 |  |  |  | 6
United Kingdom | 7.78 | 8.03 | 7.890000000000001 |  |  | 7.2
United States | 9.620000000000001 | 8.950000000000001 | 8.07 | 7.38 |  | 7.2 | 7 | 6.7 | 6.600000000000001
OECD average | 8.33 | 7.95 | 7.96 | 7.91 |  | 7.83 | 7.72 | 7.63
G7 average | 8.19 | 7.68 | 7.41 | 7.15 |  | 7.05 | 6.94 | 6.78
Euro-zone average | 10.15 | 10.13 | 11.35 | 12.06 |  | 12 | 12 | 12
(a) Unemployment as a percentage of labour force.
(b) Years shown are calendar years.
(c) Data only available quarterly. Relevant data not yet available.
(d) Monthly data seasonally adjusted
Note: Unemployment rates shown above have been adjusted as necessary by the OECD
to conform to international definitions and to ensure consistency over time. |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | Early April 2014
Source: Datastream
Spreadsheet: 172687d1344292083-how-to-reference-to-the-cell-adjacent-to-the-cell-of-selection-excel-forum-question
Sheet: Sheet1

2012-08-01 00:00:00 |  | 2012-08-02 00:00:00 |  | 2012-08-03 00:00:00
A | B | A | B | A | B
22 | 33 | 21 | 35 | 25 | 11
Date of Max A |  | [NAME] value |  | B value correspond to max A day
? |  |  |  | ?
Spreadsheet: 4df1ee3d-5f50-4587-96ee-41f95e3c6c05
Sheet: SS3

 |  | ESTABLECIMIENTO DE ATENCIÓN  MÉDICA DONDE SE PRACTICAN ACTOS QUIRÚRGICOS U OBSTÉTRICOS, PARA ESTABLECIMIENTOS CON DISPOSICIÓN Y/O BANCOS DE ORGANOS, TEJIDOS Y CELULAS:
SEÑALE SI CUENTA CON LOS SERVICIOS SIGUIENTES Y ANOTE EN EL RECUADRO CON NÚMEROS ARÁBIGOS LA CANTIDAD :
 |  |  |  | QUIRÓFANOS |  |  |  |  |  |  |  |  |  |  |  |  |  | SALA DE EXPULSIÓN
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | TERAPIA INTENSIVA
 |  |  |  | CONSULTA EXTERNA |  |  |  |  |  |  |  |  |  |  |  |  |  | TERAPIA INTERMEDIA
 |  |  |  | LABORATORIO CLÍNICO |  |  |  |  |  |  |  |  |  |  |  |  |  | TERAPIA NEONATAL
 |  |  |  | ULTRASONIDO |  |  |  |  |  |  |  |  |  |  |  |  |  | LABORATORIO DE HISTOCOMPATIBILIDAD
 |  |  |  | RAYOS X |  |  |  |  |  |  |  |  |  |  |  |  |  | BANCO DE ÓRG. Y TEJIDOS, SUS COMPONENTES Y CÉLULAS
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | BANCO DE SANGRE Y/O SERVICIO DE TRANSFUSIÓN
 |  |  |  | HEMODIÁLISIS |  |  |  |  |  |  |  |  |  |  |  |  |  | CENTRAL DE EQUIPOS Y [NAME] (CEYE)
 |  |  |  | MÁQUINAS Y SILLONES PARA HEMODIÁLISIS |  |  |  |  |  |  |  |  |  |  |  |  |  | COCINA COMEDOR
 |  |  |  | ELECTROCARDIOGRAFÍA |  |  |  |  |  |  |  |  |  |  |  |  |  | LAVANDERÍA
 |  |  |  | ELECTROENCEFALOGRAFÍA |  |  |  |  |  |  |  |  |  |  |  |  |  | CUARTO DE MÁQUINAS
 |  |  |  | TOMOGRAFÍA AXIAL COMPUTARIZADA |  |  |  |  |  |  |  |  |  |  |  |  |  | PLANTA DE EMERGENCIA
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | AMBULANCIA (S)
 |  |  |  | CITOLOGÍA EXFOLIATIVA |  |  |  |  |  |  |  |  |  |  |  |  |  | URGENCIAS
 |  |  |  | HOSPITALIZACIÓN
 |  | PARA DISPOSICIÓN DE ORGANOS Y/O BANCOS DE TEJIDOS Y CÉLULAS:
MARQUE CON UNA "X" LAS CASILLAS QUE CORRESPONDAN:
TIPO |  |  |  | CÓRNEAS |  |  |  | HUESO |  |  |  | RIÑÓN |  |  |  | HÍGADO |  |  |  | CORAZÓN |  |  |  | CÉLULAS PROGENITORAS HEMATOPOYETICAS
EXTRACCIÓN
TRASPLANTE
TIPO |  |  |  | CÓRNEAS |  |  |  | HUESO |  |  |  | CÉLULAS GERMINALES |  |  |  | PIEL |  |  |  | ADMIOS |  |  |  | CÉLULAS PROGENITORAS HEMATOPOYETICAS
BANCO
OTROS  (INDIQUE TIPO DE ACTO A REALIZAR Y EL ÓRGANO, TEJIDO O CÉLULA RELACIONADO):
 |  | PARA BANCO DE SANGRE Y SERVICIO DE TRANSFUSIÓN SANGUÍNEA:
SEÑALE SI CUENTA CON LOS SERVICIOS SIGUIENTES :
 |  |  |  | SALA DE ESPERA |  |  |  |  |  |  |  |  |  |  |  |  |  | OBTENCIÓN DE LA SANGRE
 |  |  |  | EXÁMENES MÉDICOS |  |  |  |  |  |  |  |  |  |  |  |  |  | FRACCIONAMIENTO Y CONSERVACIÓN
 |  |  |  | LABORATORIO CLÍNICO |  |  |  |  |  |  |  |  |  |  |  |  |  | APLICACIONES DE SANGRE Y SUS COMPONENTES
 |  |  |  | CONTROL ADMINISTRATIVO Y SUMINISTRO |  |  |  |  |  |  |  |  |  |  |  |  |  | INSTALACIONES SANITARIAS
Spreadsheet: 139916d1328544629-sort-with-combobox-sample-excel-inventory-using-indirect-data-validation
Sheet: WeldYoke

PartID | Description | Cost | Series
SP 1-4-111 | Weld Yoke | 11.11 | 1010
SP 2-4-222 | Weld Yoke | 22.22 | 1020
SP 3-4-333 | Weld Yoke | 33.33 | 1030
SP 4-4-444 | Weld Yoke | 44.44 | 1040
Spreadsheet: 847523d1698406356-last-record-in-adjacent-column-returned-to-cell-test1-1-
Sheet: SalesOrdersbyItemDetail

Item | Document Number | Check1 |  |  |  |  | 1004.023 | PartA
Inventory Item |  |  |  |  |  |  | 1004.023 | PartB
1004.023 |  |  |  |  |  |  | 1005.062 | PartC
 | 123 |  |  |  |  |  | 1010.017 | PartD
 | 456 |  |  |  |  |  | 1010.0.31 | PartE
Total - 1004.023
1005.062
 | 789
Total - 1005.062
1010.0.31
 | 741
Total - 1010.0.31
1010.017
 | 852
Total - 1010.017
1010.018
 | 963
Total - 1010.018
Spreadsheet: 159511d1338719264-get-the-nearest-value-nearest-available-value-oeldere-
Sheet: Sheet1

 | Item | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-29 00:00:00
 | Rca007 | 61.5 | 64.58 | 66.25 | 66.33 | 66.33 | 66.35 | 0 | 66.35 | 66.35 | 66.35 | 0 | 0 | 0
 | Rca008 | 77.36 | 77.39 | 79.39 | 79.39 | 79.39 | 79.39 | 87.09 | 90.3 | 92.26 | 91.99 | 91.7 | 91.27 | 97.16
 | Rca009 | 0 | 0 | 0 | 104.72 | 104.72 | 105.91 | 107.38 | 107.95 | 108.42 | 108.87 | 109.02 | 107.3 | 107.09
 | Rca010 | 344.95 | 344.95 | 344.95 | 442.35 | 0 | 0 | 0 | 0 | 440 | 0 | 460 | 0 | 0
 | Rca011 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rca012 | 0 | 560 | 0 | 0 | 560 | 0 | 0 | 0 | 0 | 0 | 560 | 560 | 0
 | Rca013 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | I need to continue this data sheet for coming months also
 |  | Then I need to find the avrage price for a given month.
 |  | I f it is zero I need to give the next nearest available month average price for this
 |  | eg. | For Rca007 january average price is zero,so I need to get the next nearest available month'price that is 66.35 for the given cell
 |  | How can I do this.
 |  | pls help
Rca007 | 2011-07-31 00:00:00 | 0
Spreadsheet: 852101d1702200149-use-lookup-to-get-2-values-from-2-cells-in-the-same-row-excelforum-14-aligw
Sheet: Results

 |  | Man City |  |  |  | 0 | [NAME] |  |  | Home points | Away points
 | Date | Home Team |  |  | Result |  | Away Team
2023-08-11 20:00:00 |  | Burnley |  |  | 0 | 3 | Man City
2023-08-12 13:00:00 |  | Arsenal |  |  | 2 | 1 | [NAME]
2023-08-12 15:00:00 |  | Bournemouth |  |  | 1 | 1 | West Ham
2023-08-26 12:30:00 |  | Bournemouth |  |  | 0 | 2 | Spurs
2023-09-03 14:00:00 |  | Crystal Palace |  |  | 3 | 2 | Wolves
2023-09-03 14:00:00 |  | Liverpool |  |  | 3 | 0 | [NAME]
2023-09-03 16:30:00 |  | Arsenal |  |  | 3 | 1 | Man Utd
2023-09-16 12:30:00 |  | Wolves |  |  | 1 | 3 | Liverpool
2023-09-16 15:00:00 |  | [NAME] |  |  | 3 | 1 | Crystal Palace
2023-09-16 15:00:00 |  | Fulham |  |  | 1 | 0 | Luton
2023-09-16 15:00:00 |  | Man Utd |  |  | 1 | 3 | Brighton
2023-09-16 15:00:00 |  | Spurs |  |  |  |  | Sheffield Utd
2023-09-16 15:00:00 |  | West Ham |  |  | 1 | 3 | Man City
2023-09-16 17:30:00 |  | Newcastle |  |  | 1 | 0 | Brentford
2023-09-17 14:00:00 |  | Bournemouth |  |  | 0 | 0 | Chelsea
2023-09-17 16:30:00 |  | Everton |  |  | 0 | 1 | Arsenal
2023-09-18 19:45:00 |  | [NAME] |  |  |  |  | Burnley
2023-09-23 15:00:00 |  | Crystal Palace |  |  | 0 | 0 | Fulham
2023-09-23 15:00:00 |  | Luton |  |  | 1 | 1 | Wolves
2023-09-23 15:00:00 |  | Man City |  |  | 2 | 0 | [NAME]
Spreadsheet: 71575d1272356628-populating-a-column-based-on-previous-data-in-2-other-columns-after
Sheet: Sheet1

AEG | 79901G-M | [PHONE], [PHONE]
ARTHUR MARTIN | [NAME] | 94962052900
ARTHUR MARTIN | AHT6083X | 94962053000
ARTHUR MARTIN | [NAME] | 94976005900
ARTHUR MARTIN | [NAME] | 94974058600
ARTHUR MARTIN | AHT6421P | 94962045000
ARTHUR MARTIN | AHT6431K | 94962043900
ARTHUR MARTIN | [NAME] | 94962043800
ARTHUR MARTIN | [NAME] | 94963022000
ARTHUR MARTIN | AHT7531W | 94963021900
FAURE | CZC6046X | 94774075700
ARTHUR MARTIN | EHG70830X | 94963032600
ELECTROLUX | EHM60335X | [PHONE], [PHONE]
ELECTROLUX | EHT60235K | [PHONE], [PHONE]
Spreadsheet: 808950d1670790545-summary-pivot-table-from-more-extensive-data-data-query
Sheet: Pivot 1

Count of Name1 | Column Labels
Row Labels | [NAME] | [NAME] | [NAME] | Grand Total
2023-01-02 00:00:00 | 1 |  |  | 1
2023-01-03 00:00:00 | 1 | 1 | 1 | 3
2023-01-04 00:00:00 | 1 |  | 1 | 2
2023-01-05 00:00:00 | 1 | 1 | 1 | 3
2023-01-06 00:00:00 | 1 | 1 | 1 | 3
Grand Total | 5 | 3 | 4 | 12
Spreadsheet: 6be47786-b1c1-4b08-a3a3-ce0269b14352
Sheet: Page 1

 | Permit No.: | WQ0002005 |  | Facility Name: |  | House of Raeford Farms, Inc. |  |  |  |  |  | County: |  | Duplin |  | Month: |  |  |  | Year:
 |  | Field Name: |  | 5-A |  | Field Name: |  | 5-AA |  | Field Name: |  | 5-B |  | Field Name: |  | 6-A |  | Field Name: |  | 6-B
 |  | Area (acres): |  | 6.9 |  | Area (acres): |  | 5.5 |  | Area (acres): |  | 6.9 |  | Area (acres): |  | 16.2 |  | Area (acres): |  | 6.7
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type:
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
 |  |  |  | 300 |  |  |  | 300 |  |  |  | 300 |  |  |  | 300 |  |  |  | 300
Spreadsheet: 824383d1680534232-search-a-text-for-a-array-of-values-data
Sheet: Sheet1

Text | Found
1. [NAME] (R42520)
2. Supply and Demand Inquiry (P4021)
3. [NAME] (R42520) from Customer Service Inquiry
4. [NAME] (R42750)
5. Online Invoice Inquiry (P42230)
1. Ship(R45100A) |  | This is incorrect. it should come as R45100A, but its showing R45100(as this also exist in list)
1. Ship and Debit (R45101)
3. text (R41567)
1.XYZ(R420101)
1.Debit (R45101)
some rpeort(R42356)
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: X112 AHY

 |  |  |  |  | X112 AHY
Registration number : | X112 AHY |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2006-05-31 00:00:00 | 12 Months | 2007-06-01 00:00:00 | 165
Specification : | 4 x 2 RC |  | 2007-05-31 00:00:00 | 12 Months | 2008-06-01 00:00:00 | 165
Type : | FA75 [NAME] (D/Bar) |  | 2008-05-30 00:00:00 | 12 Months | 2009-06-01 00:00:00 | 165
1st Registered : | 25.09.00 |  | 2009-05-29 00:00:00 | 12 Months | 2010-06-01 00:00:00 | 165
Engine : | DAF PF 212M |  | 2010-05-28 00:00:00 | 12 Months | 2011-06-01 00:00:00 | 165
[NAME] : | 17000kg |  | 2011-05-31 00:00:00 | 12 Months | 2012-06-01 00:00:00 | 165
Back To Index
Spreadsheet: 675160d1588179267-percentage-discount-increase-automated-percentage-discount-increase
Sheet: Sheet1

No. Days Hire | Price | Discount | Actual Cost |  |  |  |  |  |  |  | [NAME] | C.P.Day | Discount P.D
1 | 100 |  |  |  |  |  |  |  |  |  | FORD | 100 | 1 | 0
2 | 190 |  |  |  |  |  |  |  |  |  | TOYOTA | 105 | 2 | 0.02
3 | 190 |  |  |  |  |  |  |  |  |  | VAUXHALL | 5 | 3 | 0.03
4 | 100 |  |  |  |  |  |  |  |  |  | HONDA | 106 | 4 | 0.04
5 | 125 |  |  | < Keep adding IF statements to match your requirements. |  |  |  |  |  |  | B.M.W | 125 | 5 | 0.05
 |  |  |  |  |  |  |  |  |  |  | Hide or move this list |  | 6 | 0.06
Car | Cost Per Day | No. Days for Hire | Discount Rate | Discount Per Day | Actual Cost | Cost Per Day | Actual Cost Per Day | Discount Applied |  |  | anywhere on the |  | 7 | 0.07
HONDA |  | 3 |  |  |  |  |  |  |  |  | worksheet |  | 8 | 0.07
TOYOTA |  | 4 |  |  |  |  |  |  |  |  | Create a |  | 9 | 0.07
B.M.W |  | 5 |  |  |  |  |  |  |  |  | dropdown list in |  | 10 | 0.07
VAUXHALL |  | 6 |  |  |  |  |  |  |  |  | Column A |  | 11 | 0.07
FORD |  | 7 |  |  |  |  |  |  |  |  | Go to 'Data Ribbon |  | 12 | 0.07
FORD |  | 11 |  |  |  |  |  |  |  |  | Data Validation tab |  | 13 | 0.07
FORD |  | 16 |  |  |  |  |  |  |  |  | Data Validation |  | 14 | 0.07
B.M.W |  | 22 |  |  |  |  |  |  |  |  | Select 'Allow' List |  | 15 | 0.15
 |  |  |  |  |  |  |  |  |  |  | Source' is the range |  | 16 | 0.15
 | The =IFERROR(INDEX($M$2:$M$6,MATCH(A11,$L$2:$L$6,0)),"No Car") formula will |  |  |  |  |  |  |  |  |  | of cells to choose |  | 17 | 0.15
 | look up the car name and return the Cost per day automatically. It will return 'No Car' if a car type is not in the database. |  |  |  |  |  |  |  |  |  | from. In this case |  | 18 | 0.15
 | Note where the $ signs and range areas are. Adjust the ranges if more data is added or removed. |  |  |  |  |  |  |  |  |  | $L$1 to $L$6 |  | 19 | 0.15
 | The =IFERROR(INDEX($O$2:$O$23,MATCH(C9,$N$2:$N$23,0)),"No Discount") formula will |  |  |  |  |  |  |  |  |  | Change the data to |  | 20 | 0.15
 | look at the number of days for hire and return the discount applicable or 'No Discount' if on is not in the database |  |  |  |  |  |  |  |  |  | match the requirements |  | 21 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 0.2
 | The =[NAME]")))))))) formula
 | checks the number of days for hire and multiplies that by the applicable amount.
Spreadsheet: 4cf68bd2-4ca7-445d-ae17-73bb19c2c2a3
Sheet: APAIT Health Center

APAIT Health Center (APAIT)
12900 Garden Grove Blvd., Suite 220A
Garden Grove, CA 92843
Main Phone Line: (714) 636-1349
Main Fax: (714) 636-8828
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
[NAME], Associate Director | Oversees all agency programs | [EMAIL] | (213) 553-1871 | (213) 553-1833
Minh Tran, Interim Program Coordinator | Oversees [NAME] and Prevention Programs for HIV positive clients | [EMAIL] | (714) 636-1669 | (714) 636-8828
[NAME], HIV Testing Coordinator | Oversees HIV Prevention Program for high risk individuals and EFA for Housing                                          Oversees HIV Testing Program | [EMAIL] | 7146369115 | (714) 636-8828
[NAME], MSW Behavioral Health Counselor | Oversees Mental Health Program | [EMAIL] | 7144670010 | (714) 636-8828
[NAME], Health Educator | Oversees Personlized Cognitive Counseling Program Counseling | [EMAIL] | 7146361349 | (714) 636-8828
[NAME], MPH Health Educator | Oversees Substance Abuse and HIV Prevention Counseling | [EMAIL] | 7146361349 | (714) 636-8828
Spreadsheet: 78322d1278690260-displaying-data-in-an-alternative-format-sales-performance
Sheet: Displayed

 |  | DM M
 |  | Q1 | Q2 | Q3 | Q4
Seller1 | 2006-07 | 0 | 0 | 0 | 0
Seller1 | 2007-08 | 332.9299999999999 | 0 | 0 | 0
Seller1 | 2008-09 | 151.8 | 0 | 0 | 0
Seller1 | 2009-10 | 0 | 151.8 | 0 | 0
Seller1 | 2010-11 | 151.8 | 0 | 0 | 0
Seller2 | 2006-07 | 0 | 0 | 0 | 2035.92
Seller2 | 2007-08 | 847.44 | 278 | 7035.6 | 7381.440000000001
Seller2 | 2008-09 | 3295.68 | 66.24 | 9839.4 | 7167.72
Seller2 | 2009-10 | 9232.409999999998 | 3607.32 | 8213.76 | 5029.779999999999
Seller2 | 2010-11 | 21011.27 | 0 | 0 | 0
Seller3 | 2006-07 | 0 | 0 | 0 | 0
Seller3 | 2007-08 | 0 | 0 | 0 | 143.52
Seller3 | 2008-09 | 0 | 130.16 | 198.72 | 143.43
Seller3 | 2009-10 | 0 | 483 | 198.72 | 251.16
Seller3 | 2010-11 | 354.5700000000001 | 0 | 0 | 0
Seller4 | 2006-07 | 0 | 0 | 0 | 0
Seller4 | 2007-08 | 0 | 0 | 0 | 0
Seller4 | 2008-09 | 0 | 0 | 0 | 0
Seller4 | 2009-10 | 0 | 0 | 0 | 165.6
Seller4 | 2010-11 | 0 | 0 | 0 | 0
Seller5 | 2006-07 | 0 | 0 | 0 | 0
Seller5 | 2007-08 | 0 | 0 | 0 | 0
Seller5 | 2008-09 | 0 | 0 | 0 | 0
Seller5 | 2009-10 | 0 | 0 | 489.44 | 1932
Seller5 | 2010-11 | 3271.52 | 0 | 0 | 0
Seller6 | 2006-07
Seller6 | 2007-08
Seller6 | 2008-09
Seller6 | 2009-10
Seller6 | 2010-11
Seller7 | 2006-07
Seller7 | 2007-08
Seller7 | 2008-09
Seller7 | 2009-10
Seller7 | 2010-11
Seller8 | 2006-07
Seller8 | 2007-08
Seller8 | 2008-09
Seller8 | 2009-10
Seller8 | 2010-11
Seller9 | 2006-07
Seller9 | 2007-08
Seller9 | 2008-09
Seller9 | 2009-10
Seller9 | 2010-11
Seller10 | 2006-07
Seller10 | 2007-08
Seller10 | 2008-09
Seller10 | 2009-10
Seller10 | 2010-11
Seller11 | 2006-07
Seller11 | 2007-08
Seller11 | 2008-09
Seller11 | 2009-10
Seller11 | 2010-11
Seller12 | 2006-07
Seller12 | 2007-08
Seller12 | 2008-09
Seller12 | 2009-10
Seller12 | 2010-11
Seller13 | 2006-07
Seller13 | 2007-08
Seller13 | 2008-09
Seller13 | 2009-10
Seller13 | 2010-11
Seller14 | 2006-07
Seller14 | 2007-08
Seller14 | 2008-09
Seller14 | 2009-10
Seller14 | 2010-11
Seller15 | 2006-07
Seller15 | 2007-08
Seller15 | 2008-09
Seller15 | 2009-10
Seller15 | 2010-11
Seller16 | 2006-07
Seller16 | 2007-08
Seller16 | 2008-09
Seller16 | 2009-10
Seller16 | 2010-11
Seller17 | 2006-07
#N/A | 2007-08
#N/A | 2008-09
#N/A | 2009-10
#N/A | 2010-11
Seller18 | 2006-07
Seller18 | 2007-08
Seller18 | 2008-09
Seller18 | 2009-10
Seller18 | 2010-11
Seller19 | 2006-07
Seller19 | 2007-08
Seller19 | 2008-09
Seller19 | 2009-10
Seller19 | 2010-11
Seller20 | 2006-07
Seller20 | 2007-08
Seller20 | 2008-09
Seller20 | 2009-10
Seller20 | 2010-11
Seller21 | 2006-07
Seller21 | 2007-08
Seller21 | 2008-09
Seller21 | 2009-10
Seller21 | 2010-11
Seller22 | 2006-07
Seller22 | 2007-08
Seller22 | 2008-09
Seller22 | 2009-10
Seller22 | 2010-11
Seller23 | 2006-07
Seller23 | 2007-08
Seller23 | 2008-09
Seller23 | 2009-10
Seller23 | 2010-11
Seller24 | 2006-07
Seller24 | 2007-08
Seller24 | 2008-09
Seller24 | 2009-10
Seller24 | 2010-11