tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884667d1733908107-struggling-with-indirect-formula-project-stat-template-202412110900
Sheet: 2024

2024
Number | Request Date | Project ref | Section | Contact | Request Description | Request Type: Research Development Explore Response Consultation Learning | Urgent Y/N | Customer Name | CEO | Dept. | Business Area | Secondary Areas: | Action | STATUS: Approved - Start Approved - wait Rejected Differed Scoping Referred Completed | Date of last Status Action
1 | 2024-05-14 00:00:00 | 202405-1 | TeamA | JH | Project Red | Research | Y | [NAME] |  | Facilities | Section1 |  | Scope | Scoping |  |  | Urgent |  |  | 2024 Overall tasks |  |  | Tasks for dept |  |  | Tasks status |  |  | Tasks per team
2 | 2024-08-03 00:00:00 | 202408-2 | TeamB | AS | Project Blue | Consultation | N | [NAME] |  | HR | Section2 |  | Rejected | Completed |  |  | Yes |  |  | Jan |  |  | Section1 |  |  | Scoping |  |  | TeamA
3 | 2024-11-09 00:00:00 | 202411-3 | TeamC | TB | Project Green | Learning | N | [NAME] |  | Communications | Section3 |  | New | Approved |  |  | No |  |  | Feb |  |  | Section2 |  |  | Approved |  |  | TeamB
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar |  |  | Section3 |  |  | Rejected |  |  | TeamC
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr |  |  | Section4 |  |  | Differed |  |  | TeamD
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Urgent & Completed |  |  | May |  |  | Section5 |  |  | Completed
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes |  |  | Jun |  |  | Section6
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  | Jul |  |  | Section7
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug |  |  | Section8
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep |  |  | Section9
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct |  |  | Section10
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov |  |  | Section11
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec |  |  | Section12
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
Spreadsheet: 328311d1403868138-seperate-simple-hours-holiday-hours-and-night-hours-test-hours-1
Sheet: Φύλλο1

DAY | DATE | DOCTOR | DUTY | BEGINNING TIME | ENDING TIME | SIMPLE HOURS | NIGHT HOURS 22:00-6:00 | HOLIDAY HOURS | HOLIDAY HOURS NIGHT 22:00-6:00 | TOTAL HOURS | REWARD OF SIMPLE HOURS | REWARD OF NIGHT HOURS | REWARD OF HOLIDAY HOURS | REWARD OF HOLIDAY NIGHT HOURS | TOTAL REWARD | TOTAL REWARD FROM 1/1/13
 | 2014-06-01 00:00:00 | ΛΙΑΚΟΠΟΥΛΟΥ | ΠΡΩΙΝΗ | 07:00:00 | 15:00:00
 | 2014-06-01 00:00:00 | ΛΑΜΠΡΑΚΟΣ | ΑΠΟΓΕΥΜΑΤΙΝΗ | 15:00:00 | 23:00:00 |  |  | 7 | 1
 | 2014-06-01 00:00:00 | ΕΚΜΕΚΤΖΟΓΛΟΥ | ΝΥΧΤΕΡΙΝΗ | 23:00:00 | 07:00:00 | 1 | 6 |  | 1
 | 2014-06-02 00:00:00 | ΛΑΜΠΡΑΚΟΣ | ΠΡΩΙΝΗ | 07:00:00 | 15:00:00 | 8
 | 2014-06-02 00:00:00 | ΖΗΡΟΥ | FOLLOW UP | 09:30:00 | 15:00:00 | 5.5
 | 2014-06-02 00:00:00 | ΑΓΑΠΙΟΥ | ΑΠΟΓΕΥΜΑΤΙΝΗ | 15:00:00 | 23:00:00 | 7 | 1
 | 2014-06-02 00:00:00 | ΤΑΣΣΟΠΟΥΛΟΣ | FOLLOW UP | 17:30:00 | 21:30:00 | 4
 | 2014-06-02 00:00:00 | ΚΑΡΤΙΚΚΗΣ | ΝΥΧΤΕΡΙΝΗ | 23:00:00 | 07:00:00 | 1 | 7
Spreadsheet: 107744d1304901456-excel-2007-should-i-use-a-if-statement-prices-customers-
Sheet: Sheet1

Service # | Fee | Parts | Parts Charge | Parts Gain | Total | Received | Due | Profit | Overall Parts Profits | Money Spent | Total Money
A100 | 20 | 0 | 0 | 0 | 20 | 0 | 20 | 0 | 0 | 0 | 20
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
A102 | 40 | 100 | 125 | 25 | 165 | 0 | 165 | 0 | 0 | 100 | 185
A103 | 30 | 20 | 25 | 5 | 55 | 1 | 54 | 34 | 34 | 120 | 240
A104 | 25 | 100 | 125 | 25 | 150 | 0 | 150 | 0 | 34 | 220 | 390
 |  |  |  |  |  |  |  |  |  |  | 390
Spreadsheet: 0939a54d-5a5a-4541-8e9a-69c305ec7fff
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | ФОРМА B
МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ГРАЖДАНСКОЙАВИАЦИИ
ФОРМА ОТЧЕТНОСТИ ПО ВОЗДУШНОМУ ТРАСПОРТУ
[NAME]
КОММЕРЧЕСКИЕ АВИАПЕРЕВОЗЧИКИ
Регулярные и нерегулярные перевозки (коммерческие). Международные полеты
 | [NAME] для связи: |  |  |  | Государство:
 | Организация: |  |  |  | Год:
 | [NAME].: |  |  |  | Авиаперевозчики:
 | Факс:
 | E-mail:
Период отчетности (отметить  "X") |  |  |  |  | Тип перевозок (отметить  "X")
1-й квартал (янв.-февр.-март) |  |  |  |  | Регулярные
2-й квартал (апр.-май-июнь) |  |  |  |  | Нерегулярные
3-й квартал (июль-авг.-сент.)
4-й квартал (окт.-ноябрь-дек.)
ПАРА ГОРОДОВ |  | КОММЕРЧЕСКИЕ ПЕРЕВОЗКИ
 |  |  |  |  |  | Участвующие
От | До | Пассажиры |  | [NAME] | Почта | авиаперевозчики*
 |  | (число) |  | (тонны) | (тонны) | (по коду)
a | b | c |  | d | e | f
Примечания (включая упоминания любого неизбежного отклонения от инструкции по заполнению):
*Данная графа используется только теми государствами, которые представляют сводные отчеты в отношении нескольких авиакомпаний (см.инструкцию по заполнению.
По мере [NAME] листы.
Spreadsheet: 0a9e9f70-c7a1-40e9-914e-65b3bed0e93f
Sheet: Sheet1

Engineering Technology* | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Associate of Applied Science Degree
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Remedial Courses As Needed |  |  |  | Grade | Semester Taken
010 RDG + 12 DRE - Intro. to [NAME]
020 RDG + 101 GE - Improved College Reading
030 RDG + 101 GE (if not already completed)
090 ENC - Foundations of College Writing I
091 ENC - Foundations of College Writing II
055 MT - Pre-Algebra
065 MT - Elemtary Algebra
120 MT - Intermediate Algebra
General Education Courses (Core Curiculum) |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ENG101 - Writing I |  |  |  |  | 3
Communications Course |  |  |  |  | 3
Mathematics Course (MT 150 or MT 125) |  |  |  |  | 3
Heritage/Humanities Course |  |  |  |  | 3
Social Science Course |  |  |  |  | 3
Physics Course (PHY 171 or higher level) |  |  |  |  | 3-4
Total Gen. [NAME]. Semester Hours |  |  |  |  | 18-19
Technical Core Courses |  |  |  |  | Credit  Hours | Grade | Semester Taken | Note
ENGT 110 | Circuits I |  |  |  | 5
ENGT 114 | Circuits II |  |  |  | 5
ENGT 210 | Devices I |  |  |  | 5
ENGT 120 | Digital Logic Circuits |  |  |  | 3
CAD 100 | Introduction to Computer Aided Design OR |  |  |  | 3
BRX 120 | Basic Blueprint Reading OR |  |  |  | 3
EET  148 | Electronic Drafting |  |  |  | 3
 | Computer Literacy Course |  |  |  | 3
ET 234 | Computer Hardware Maintenance OR |  |  |  | 3
ET 250 | Programmable Logic Controllers OR |  |  |  | 4
ET 256 | Microprocessors Fundamentals |  |  |  | 4
Total Technical Core Hours |  |  |  |  | 27-29
Computer Aided Design Specialization Courses |  |  |  |  | Credit Hours | Grade | Semester Taken | Note
CAD 150 | Intro to Programming: CAD OR |  |  |  | 4 |  |  | Technical Electives:
ADFT 130 | Introduction to Architecture AND |  |  |  | 3 |  |  | ET 185
ADFT 131 | Introduction to Architecture Lab |  |  |  | 1 |  |  | ET 122
CAD 200 | Intermediate CAD |  |  |  | 4 |  |  | ET 290
CAD 201 | Advanced CAD |  |  |  | 4 |  |  | ET 295
Technical Electives - see program coordinator |  |  |  |  | 14 |  |  | Courses under other
Total Specialization Hours |  |  |  |  | 26 |  |  | specializations
*This curriculum is to be followed by students entering this program beginning Fall 2005 or after.
Spreadsheet: louise_kitchen__22845__June 2001 Bridgeline Investment Analysis
Sheet: Gain Loss

Bridgeline |  |  |  |  |  |  | Bridgeline
Analysis of Investment |  |  |  |  |  |  | Analysis of EBITDA Multiple
As of June 30, 2001 |  |  |  |  |  |  | As of June 30, 2001
Investment: |  |  |  |  |  | Earnings |  | Expected | ENA's | Gains or Loss
 | Lease buyout |  | 167092353 |  |  | Multiple |  | Sale (MM) | Share | After Investment
 | Initial Working Capital |  | 21000000 |  |  | 8
 | Purchase of interest in BGM |  | 3568000
 | Storage Assets |  | 18722869
 | Line pack |  | 318975
 | Legal expenses |  | 615690
 | Bridgeline index value |  | 2194082
 | Capital expenditures |  | 3000000
 | Additional investment - materials |  | 12849
 | Distributions from Bridgeline - Taxes
 | Distributions from Bridgeline |  | -12000000 |  | 2001 EBITDA Target |  |  | 56 | MM
 | Deferred taxes of assets contributed |  | 9832061
 | I/C eliminations (1)
 | Equity earnings March, 2000 - June 2001 |  | 10108078
PP&E to be contributed (NBV as of May, 2001) |  |  | 268607.3
Enron No. 1
Pad Gas Hedge |  |  | 19830416
Leeching / Well Development - Completed |  |  | 4638789
Leeching / Well Development - CWIP |  |  | 3636982
Total Investment in Bridgeline
(1) | Unrealized values included in equity earnings from transactions with Enron.
Spreadsheet: 202806d1356731830-combining-multiple-rows-into-one-row-sample-document
Sheet: What I want

last 4 of SSN | Full Name | school_code | term_begin | term_end | School Rep Name | [NAME] | last 4 of SSN | Full Name | school_code | term_begin | term_end | School Rep Name | [NAME] | last 4 of SSN | Full Name | school_code | term_begin | term_end | School Rep Name | [NAME] | last 4 of SSN | Full Name | school_code | term_begin | term_end | School Rep Name | [NAME] | last 4 of SSN | Full Name | school_code | term_begin | term_end | School Rep Name | [NAME]
1111 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL] | 2222 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL] | 3333 | justin justin | 00104600 | 082012 | 082014 | school rep | [EMAIL] | 4444 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL] | 5555 | [NAME] | 00104600 | 082012 | 082016 | school rep | [EMAIL]
Spreadsheet: 749323d1632731361-simple-formula-giving-incorrect-result-midshires-master-2022
Sheet: playlist

 | Our First Event of the 2022 season is……. |  |  |  |  |  | PLAYER INDEX
 | Memorial at Wensum Valley (Valley Course) |  |  |  | [NAME] | 09:30:00 |  |  |  | 00:08:00
 | Friday 15th April |  |  |  |  |  | 1 |  | 32
 | Nearest the pins:    in 1 = 14th      in 2 = 16th      in 3 = 8th                    Glory Hole = 1st |  |  | Captains Bottle = 4th            Longest drive = 17th |  |  | 2 |  | 33
 | GROUP | Tee-Time | Player | Exact Handicap | Playing Handicap | To Pay | 3 |  | 34
22 | 1 |  |  |  |  | 23 | 4 |  | 35 |  |  |  | H'Cap | To Pay
10 |  | 11:00:00 |  |  |  | Paid | 5 |  | 36
35 |  |  |  |  |  | Paid | 6 |  | 37
24 |  |  |  |  |  | Paid | 7 |  | 38
29 | 2 |  |  |  |  | Paid | 8 |  | 39
48 |  |  |  |  |  | 23 | 9 |  | 40
1 |  |  |  |  |  | 23 | 10 |  | 41
7 |  |  |  |  |  | Paid | 11 |  | 42
41 | 3 |  |  |  |  | Paid | 12 |  | 43
13 |  |  |  |  |  | Paid | 13 |  | 44
27 |  |  |  |  |  | 23 | 14 |  | 45
40 |  |  |  |  |  | Paid | 15 |  | 46
38 | 4 |  |  |  |  | 23 | 16 |  | 47
21 |  |  |  |  |  | Paid | 17 |  | 48
12 |  |  |  |  |  | Paid | 18 |  | 49
46 |  |  |  |  |  | Paid | 19 |  | 50
28 | 5 |  |  |  |  | 23 | 20 |  | 51
51 |  |  |  |  |  | Paid | 21 |  | 52
49 |  |  |  |  |  | Paid | 22 |  | 53
4 |  |  |  |  |  | 23 | 23 |  | 54
31 | 6 |  |  |  |  | 18 | 24 |  | 55
5 |  |  |  |  |  | 18 | 25 |  | 56
26 |  |  |  |  |  | Paid | 26 |  | 57
30 |  |  |  |  |  | 23 | 27 |  | 58
17 | 7 |  |  |  |  | 23 | 28 |  | 59
42 |  |  |  |  |  | Paid | 29 |  | 60
34 |  |  |  |  |  | Paid | 30 |  | 61
39 |  |  |  |  |  | 23 | 31 |  | 62
 | 8 |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  | 66
 | 9 |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  | 68
 | 10
 | 11
 | 12
 | 13
Spreadsheet: 15eeee22-a2d2-49c5-a6e3-95cf22d74731
Sheet: Summary Santander

PRESUPUESTO ENTIDADES EJECUTORAS
SANTANDER
Nombre Entidad Ejecutora:
Detalle | Presupuesto  Total | Tope Presupuestal
[NAME]
Monitoreo y Evaluación
[NAME] y [NAME]
Total Rubros de Funcionamiento
[NAME]
Total Destinación Específica
PRESUPUESTO TOTAL
XXXXXX
REPRESENTANTE LEGAL
Spreadsheet: 105461d1302801793-excel-2007-pivot-table-percentage-increase-help-example-layout
Sheet: Sheet1

types of appreciation | 2011-04-01 00:15:23 | 2011-04-02 00:15:23 | 2011-04-03 00:15:23 | 2011-04-04 00:15:23 | 2011-04-05 00:15:23 | 2011-04-06 00:15:23
Sample | 1 | 1 | 3 | 5 | 5 | 5
Good quality | 1 | 1 | 1 | 0.6 | 0.6 | 0.6
Bad quality | 0 | 0 | 0 | 0.2 | 0.2 | 0.2
don´t have opinion | 0 | 0 | 0 | 0.2 | 0.2 | 0.2
Spreadsheet: 186076d1349918636-sorting-non-empty-cells-to-bottom-schedule-example2
Sheet: 4

2200-0000 |  |  | 0000-0200 |  |  | 0200-0400 |  |  | 0400-0600 |  |  | TUESDAY
CHAD |  |  | CHAD |  |  | JESSIE |  |  | JESSIE
JESSIE |  |  | JESSIE |  |  | [NAME] |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  | STEPHANIE |  |  | STEPHANIE
CHARITY E |  |  | CHARITY E |  |  | CHARITY L |  |  | CHARITY L
STEPHANIE |  |  | STEPHANIE |  |  | TERI |  |  | TERI
BRANDY |  |  | BRANDY
CHARITY L |  |  | CHARITY L
TERI |  |  | TERI
0600-0800 |  |  | 0800-1000 |  |  | 1000-1200 |  |  | 1200-1400
VAL |  |  | VAL |  |  | VAL |  |  | VAL
[NAME] |  |  | [NAME] |  |  | JESSICA |  |  | JESSICA
CHERYL |  |  | CHERYL |  |  | ALANA |  |  | ALANA
JULIE |  |  | JULIE |  |  | [NAME] |  |  | [NAME]
TERI |  |  | CINDY |  |  | CHERYL |  |  | CHERYL
CINDY |  |  | [NAME] |  |  | JULIE |  |  | JULIE
[NAME] |  |  |  |  |  | CINDY |  |  | CINDY
 |  |  |  |  |  | [NAME] |  |  | MARK
 |  |  |  |  |  |  |  |  | KAY
 |  |  |  |  |  |  |  |  | [NAME]
1400-1600 |  |  | 1600-1800 |  |  | 1800-2000 |  |  | 2000-2200
VAL |  |  | CHAD |  |  | CHAD
ALANA |  |  | JESSICA |  |  | JESSICA |  |  | CHAD
[NAME] |  |  | ALANA |  |  | ALANA |  |  | [NAME]
CHERYL |  |  | CHARITY E |  |  | CHARITY E |  |  | CHARITY E
JULIE |  |  | BRANDY |  |  | BRANDY |  |  | STEPHANIE
CINDY |  |  | MARK |  |  | MARK |  |  | BRANDY
KAY |  |  | KAY |  |  | KAY |  |  | MARK
[NAME] |  |  |  |  |  |  |  |  | KAY
Spreadsheet: 75545d1276104220-combining-10-000-data-rows-from-two-sheets-lod-combi
Sheet: combined

SNP ID | LOD | Chromosome | Physical Position | A787-16_Call | A787-17_Call | A787-18_Call | A787-19_Call | A787-20_Call | A787-21_Call | A787-22_Call | A787-23_Call
SNP_A-1515289 | 0.101549 | 22 | 14972721 | NoCall | NoCall | NoCall | AA | NoCall | AA | NoCall | AA
SNP_A-1512430 | 0 | 22 | 15691027 | BB | BB | BB | BB | BB | BB | BB | BB
SNP_A-1514772 | not in lod sheet | 22 | 16609774 | AB | AA | AA | AA | AB | AA | AA | AA
Spreadsheet: 267357d1380052350-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: COLORADO-5

 | COUNTY | CODE
 | Adams | 1
 | [NAME] | 3
 | Arapahoe | 5
 | Archuleta | 7
 | [NAME] | 9
 | Bent | 11
 | Boulder | 13
 | Chaffee | 15
 | [NAME] | 17
 | Clear Creek | 19
 | Conejos | 21
 | Costilla | 23
 | Crowley | 25
 | Custer | 27
 | Delta | 29
 | Denver | 31
 | Dolores | 33
 | [NAME] | 35
 | Eagle | 37
 | Elbert | 39
 | El Paso | 41
 | Fremont | 43
 | [NAME] | 45
 | [NAME] | 47
 | Grand | 49
 | Gunnison | 51
 | Hinsdale | 53
 | Huerfano | 55
 | [NAME] | 57
 | [NAME] | 59
 | [NAME] | 61
 | [NAME] | 63
 | Lake | 65
 | [NAME] | 67
 | Larimer | 69
 | [NAME] | 71
 | Lincoln | 73
 | Logan | 75
 | Mesa | 77
 | Mineral | 79
 | Moffat | 81
 | Montezuma | 83
 | Montrose | 85
 | Morgan | 87
 | Otero | 89
 | Ouray | 91
 | Park | 93
 | Phillips | 95
 | Pitkin | 97
 | Prowers | 99
 | Pueblo | 101
 | Rio Blanco | 103
 | Rio Grande | 105
 | Routt | 107
 | Saguache | 109
 | San Juan | 111
 | [NAME] | 113
 | Sedgwick | 115
 | Summit | 117
 | Teller | 119
 | Washington | 121
 | Weld | 123
 | Yuma | 125
Spreadsheet: 757713d1638427646-formula-to-override-one-dropdown-over-another-sample1
Sheet: Sheet1

Select Weather One or Two Weeks: | Two Weeks |  |  |  |  |  |  |  |  | Number of Weeks
 |  |  |  |  |  |  |  |  |  | MONDAY - Week One | 18
Override Weeks | One Week |  |  |  |  |  |  |  |  | MONDAY - Week Two | 20
 |  |  |  |  |  |  |  |  |  | TUESDAY - Week One | 19
 |  |  |  |  |  |  |  |  |  | TUESDAY - Week Two | 20
 |  |  |  |  |  |  |  |  |  | WEDNESDAY - Week One | 20
 |  |  |  |  |  |  |  |  |  | WEDNESDAY - Week Two | 20
 |  |  |  |  |  |  |  |  |  | THURSDAY - Week One | 21
 |  |  |  |  |  |  |  |  |  | THURSDAY - Week Two | 20
Number of Weeks |  |  |  |  |  |  |  |  |  | FRIDAY - Week One | 21
 |  |  |  |  |  |  |  |  |  | FRIDAY - Week Two | 19
 |  |  |  |  |  |  |  |  |  | SATURDAY - Week One | 20
 |  |  |  |  |  |  |  |  |  | SATURDAY - Week Two | 17
 |  |  |  |  |  |  |  |  |  | SUNDAY - Week One | 19
 |  |  |  |  |  |  |  |  |  | SUNDAY - Week Two | 17
Spreadsheet: 269719d1381255135-how-to-lookup-value-based-on-date-time-closest-to-criteria-lookup-test
Sheet: Sheet1

Device Name | Formatted Date | Location (Array) | Matching Date/Time (Array) |  | Device Name | Formatted Date | Location
VP12345 | 2013-09-25 14:07:00 |  |  |  | VP12345 | 2013-09-25 14:04:00 | Location 1
VP2500 | 2013-09-25 14:06:00 |  |  |  | VP2500 ([PHONE]) | 2013-09-25 14:06:00 | Location 2
VP2500 | 2013-09-20 14:45:00 |  |  |  | VP2500 ([PHONE]) | 2013-09-25 14:08:00 | Location 3
VP2500 | 2013-09-09 17:22:00 |  |  |  | VP2500 ([PHONE]) | 2013-09-25 14:08:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-26 15:09:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-20 14:07:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-20 14:08:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-20 14:10:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-20 15:41:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-20 15:46:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-20 15:48:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-09 17:16:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-09 17:19:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-09 17:21:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-09 17:23:00 | Location 3
 |  |  |  |  | VP2500 ([PHONE]) | 2013-09-09 17:25:00 | Location 3
Spreadsheet: 11e2e9fa-9794-4d13-acbe-a964bfe50d32
Sheet: data for graph

Hazardous waste transfers from industrial installations to other countries, 1000 tonnes
 | 2007 | 2008 | 2009 | 2010
Installations for hazardous waste recovery or disposal | 879.3068600000005 | 1211.9494 | 1404.9784 | 1328.449997
Iron or steel production | 379.6783349999999 | 407.718674 | 271.47305 | 286.688438
Non-hazardous waste incineration plants | 297.950414 | 294.045892 | 343.436892 | 356.980486
Non-ferrous metals production | 247.1400929999999 | 279.631724 | 207.159913 | 184.985341
Basic organic chemicals production | 231.54293 | 184.642235 | 147.689321 | 188.655922
Basic inorganic chemicals production | 39.733996 | 43.68389999999999 | 53.531924 | 356.732336
Installations for disposal of non-hazardous waste | 93.66028 | 79.62499000000001 | 95.28016000000001 | 144.916762
Basic pharmaceutical products production | 89.70965699999998 | 73.57855299999999 | 72.18236800000001 | 66.862573
Manufacture of glass, including glass fibre | 9.258143 | 231.714301 | 3.378490000000001 | 3.740326
Energy - power stations | 33.04614700000001 | 95.823496 | 29.84869200000001 | 36.39984800000001
Energy - Mineral oil and gas refineries | 37.07117199999999 | 41.64452000000001 | 43.30450700000002 | 45.875056
Metals -  surface treatment including plastic materials | 28.06344099999999 | 30.12576000000001 | 27.29138100000001 | 41.63455600000002
Ferrous metals production | 17.55256 | 34.536288 | 24.143161 | 26.64553
Industrial waste-water treatment plants | 24.413507 | 24.73438 | 19.25669 | 27.1889
Other industrial activities | 53.62299400000001 | 46.89427209999999 | 60.697184 | 80.07494059000001
Spreadsheet: 21e8ba71-79c4-4749-8e3c-dab497880d1a
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 8/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 | Area: Planted | Million acres | 57.3 | 60.5 | 63.2 | 59.2 | 53.6 | 54.4 | 56.0
 | Harvested | Million acres | 46.8 | 51.0 | 55.7 | 49.9 | 47.6 | 45.7 | 48.8
 | Yield | Bushels per acre | 38.6 | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.5
 | Supply: Beginning stocks | Million bushels | 571.2 | 456.2 | 305.8 | 656.5 | 975.6 | 862.2 | 742.7
 | Production | Million bushels | 1,808.4 | 2,051.1 | 2,499.2 | 2,218.1 | 2,206.9 | 1,999.3 | 2,268.2
 | Imports 1/ | Million bushels | 121.9 | 112.6 | 127.0 | 118.6 | 96.9 | 112.1 | 130.0
 | Total supply | Million bushels | 2,501.5 | 2,619.9 | 2,932.0 | 2,993.2 | 3,279.5 | 2,973.7 | 3,141.0
 | Disappearance: Food use | Million bushels | 937.9 | 947.9 | 926.8 | 918.9 | 925.6 | 941.4 | 950.0
 | Seed use | Million bushels | 81.9 | 87.6 | 78.0 | 69.5 | 70.9 | 76.8 | 73.0
 | Feed and residual use | Million bushels | 117.1 | 16.0 | 255.2 | 149.9 | 131.9 | 163.2 | 220.0
 | Total domestic use | Million bushels | 1,136.8 | 1,051.4 | 1,260.0 | 1,138.2 | 1,128.4 | 1,181.4 | 1,243.0
 | Exports 1/ | Million bushels | 908.5 | 1,262.6 | 1,015.4 | 879.3 | 1,288.8 | 1,049.5 | 1,200.0
 | Total disapperance | Million bushels | 2,045.3 | 2,314.1 | 2,275.4 | 2,017.5 | 2,417.2 | 2,230.9 | 2,443.0
 | Ending stocks | Million bushels | 456.2 | 305.8 | 656.5 | 975.6 | 862.2 | 742.7 | 698.0
 | CCC inventory 2/ | Million bushels | 41.0
 | Stocks-to-use ratio |  | 22.3 | 13.2 | 28.9 | 48.4 | 35.7 | 33.3 | 28.6
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 4.26 | 6.48 | 6.78 | 4.87 | 5.70 | 7.24 | 7.60-9.00
 | Government payments | Million dollars | 1,120 | 1,118
 | Market value of production | Million dollars | 7,695 | 13,289 | 16,626 | 10,654 | 12,827 | 14,475 | 18,826
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 8/13/2012
Spreadsheet: 478774d1473063086-how-vlookup-all-the-matches-in-the-reference-matrix-vlookupsumvalues
Sheet: -

name | sumvalues |  |  | name | values
simone | 9 |  |  | simone | 2
maria | 8 |  |  | francisco | 1
francisco | 1 |  |  | candela | 3
candela | 5 |  |  | candela | 0
jorge | 0 |  |  | candela | 2
 |  |  |  | simone | 6
 |  |  |  | maria | 2
 |  |  |  | simone | 1
 |  |  |  | maria | 0
 |  |  |  | maria | 4
 |  |  |  | maria | 2
Spreadsheet: 794694d1662221064-formula-doesnt-work-in-excel-2013-book1-1-
Sheet: Sheet1

 | Apple
 | [NAME]
 | [NAME]
 | Red Apple
 | Coconut
 | Orange
 | Green pears