tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 840413d1692715329-available-recipes-from-ingredient-stock-list-recipe-stock
Sheet: Hoja1

RECETA | B_INGREDIENTE | CANTIDAD |  | E_INGREDIENTE | STOCK |  | H_RECETA | DISPONIBILIDAD
ALBONDIGAS | CARNE | 1 |  | CONEJO | 0 |  | ALBONDIGAS
ALBONDIGAS | TOMATE | 2 |  | TOMATE | 2 |  | POLLO FRITO
POLLO FRITO | POLLO | 1 |  | POLLO | 2 |  | CONEJO AL AJILLO
POLLO FRITO | PATATAS | 3 |  | PATATAS | 4
CONEJO AL AJILLO | CONEJO | 1 |  | CARNE | 2
CONEJO AL AJILLO | AJO | 2 |  | AJO | 3
Hello Friends,  I need to solve this problem  I have 3 tables.  Table 1 : Recipe (A) , B_Ingredient (B) , Ammount (C). Table 2 : E_Ingredient (E), Stock (F). Table 3 : H_Recipe (H), Available (I).  I need a formula in Column I to show if i can make any recipe with the stock available in column F.  [ATTACH]840411[/ATTACH]  Thanks.
Spreadsheet: 855494d1705037816-look-up-and-return-not-a-normal-criterira-aqu-1-12-ans2
Sheet: PICK SHEET

P/O | MFG Part | NICK NAME | Need | BOX 1 | BOX 2 | BOX 3 | BOX 4 | BOX 5 | BOX 6 | BOX 7 | BOX 8 | BOX 9 | BOX 10
7016100 | 72210522 | AQU036S
7016100 | 72210535 | AQU037S
7016100 | 72210587 | AQU138
7016100 | 74210123 | MC2107
7016100 | 74210100 | AQU068
7016100 | 74210110 | AQU069
7016100 | 74210133 | AQU105PR
7016100 | 74210143 | AQU112PR
7016100 | 74210143 | AQU112PR
7016100 | 74210143 | AQU112PR
7016245 | 74210185 | MC2058
7016245 | 74210185 | MC2058
7016047 | 74210125 | MC2108
7016047 | 74210125 | MC2108
7016270 | 74210181 | MC2104
7016213 | 74210182 | MC2115
7016005 | 74210182 | MC2115
7015887 | 74210182 | MC2115
Spreadsheet: 858688d1707289061-how-to-do-partial-match-between-two-columns-that-contains-names-to-check-in-excel-forum
Sheet: Sheet1

 |  |  | Eligible Plans
From SAP | From HR | Company | Hours | I have to match column A to Coumn B and pull the partial matching name
Lim, [NAME] | Backwood Jap | Sop | 3 | For eg; how to show [NAME], [NAME] (Jap) here
Ram, Yukku | [NAME] | Sop | 4
Pin, [NAME] | [NAME] | Sop | 6
[NAME], [NAME] (Jap) | [NAME] lim tan | Sop | 6
Spreadsheet: 156295d1337256599-how-to-copy-data-from-master-list-sheet-to-another-sheet-based-on-category-ifjsss-round-2-data
Sheet: LadiesOpen

THE LANGKAWI INTERNATIONAL
FORMULA JET SKI SUPER SERIES 2012
ROUND 2, PUTRAJAYA
 | Ladies Open
 | MOTO :
 | CATEGORY   :  4 Stroke Ladies Open
 | LAPS :  12
 | RACE TIME :
No | RIDER | TEAM | CRAFT | CRAFT TYPE | POINT FROM PREVIOUS ROUND | ROUND 2 |  |  |  | OVERALL POINTS | RANK
 |  |  |  |  |  | MOTO 1 | MOTO 2 | MOTO 3 | MOTO 4
Spreadsheet: 1dd37b56-ac6b-4d37-b336-eed04726acf5
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2013/14 |  |  | 2012/13 |  |  | 2011/12
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 12.08 | 12.43 |  | 11.91 | 12.13 |  | 14.08 | 14.4
September | 11.87 | 12.22 |  | 12.57 | 12.81 |  | 15.09 | 15.44
October | 11.95 | 12.3 |  | 12.72 | 12.97 |  | 15.63 | 15.99
November  2/ | 11.76 | 12.11 |  | 12.92 | 13.17 |  | 14.93 | 15.28
December |  |  |  | 12.62 | 12.86 |  | 13.9 | 14.21
January |  |  |  | 12.35 | 12.59 |  | 12.61 | 12.88
February |  |  |  | 11.77 | 12.43 |  | 11.81 | 12.2
March |  |  |  | 12.16 | 12.84 |  | 11.52 | 11.92
April |  |  |  | 12.18 | 12.86 |  | 11.15 | 11.54
May |  |  |  | 12.08 | 12.75 |  | 11.42 | 11.82
June |  |  |  | 12.17 | 12.85 |  | 11.93 | 12.35
July |  |  |  | 12.18 | 12.86 |  | 11.97 | 12.4
Market-year
average 1/ | 11.915 | 12.265 |  | 12.3025 | 12.76 |  | 13.00333333333334 | 13.36916666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated November 8, 2013.
Spreadsheet: 41376d1239831017-array-formula-test5
Sheet: Wellness Results

 | ABC Company
1 | #N/A
2 | #N/A
3 | #N/A
4 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: 292657d1390732330-how-do-i-get-a-drop-down-gender-list-to-affect-the-data-in-another-cell-macro-blueprint
Sheet: Sheet1

Gender | Male
 |  |  |  |  | Gender value male = 6 female = 5
Weight | 180 |  | Meal Qty
Training Days | 13.5 |  |  |  | [NAME]
Total Calories |  |  |  |  | Total Calories | 10.5
Protein | 0.4 |  |  |  | Protein | 0.4
Carbs | 0.35 |  |  |  | Carbs | 30
Fat | 0.25 |  |  |  | Fat | 30
Spreadsheet: 879108d1726567188-primary-code-and-secondary-code-selection-cpt-groups-ex-z1a
Sheet: Secondary group data

Secondary code group 1 | Secondary code group 1 description |  | Secondary code group 2 | Secondary code group 2 description |  | Secondary code group 3 | Secondary code group 3 description |  | Secondary code group 4 | Secondary code group 4 description
12345 | 12345 description |  | 23456 | 23456 description |  | 34567 | 34567 description |  | 44567 | 44567 description
12346 | 12346 description |  | 23457 | 23457 description |  | 34568 | 34568 description |  | 44567 | 44568 description
12347 | 12347 description |  | 23458 | 23458 description |  | 34569 | 34569 description |  | 44567 | 44569 description
12348 | 12348 description |  | 23459 | 23459 description |  | 34570 | 34570 description |  | 44567 | 44570 description
12349 | 12349 description |  | 23460 | 23460 description |  | 34571 | 34571 description |  | 44567 | 44571 description
12350 | 12350 description |  | 23461 | 23461 description |  | 34572 | 34572 description |  | 44567 | 44572 description
12351 | 12351 description |  | 23462 | 23462 description |  | 34573 | 34573 description |  | 44567 | 44573 description
12352 | 12352 description |  | 23463 | 23463 description |  | 34574 | 34574 description |  | 44567 | 44574 description
Spreadsheet: 122827d1317188684-need-help-in-developing-macros-20437-01-part3a
Sheet: Commission Rates

Amount | % Comm
2000 | 0
2650 | 0.015
3300 | 0.03
3950 | 0.045
4600 | 0.06
5250 | 0.075
5900 | 0.09
6550 | 0.105
7200 | 0.12
7850 | 0.135
8500 | 0.15
9150 | 0.165
9800 | 0.18
Spreadsheet: 164621d1340820969-combining-linked-cells-while-retaining-formatting-example
Sheet: Conversion

 | Total Euro Amount | Total in Origin Currency |  | Exp Date | Charges  (Enter each charge on a separate line, up to 20) | % of Total in Origin Currency | Total in Euro | Description
 | 27.96 |  |  | 2012-05-26 00:00:00 | 4.5 |  |  | Food
 |  |  |  | 2012-05-28 00:00:00 | 7.95 |  |  | Laundry
 |  |  |  | 2012-05-29 00:00:00 | 9.6 |  |  | Laundry
Spreadsheet: 137624d1327264787-excel-or-access-for-manufacturing-costing-810741-excel-or-access-dummy-file
Sheet: BBQ ALMONDS

BBQALMNDS - BBQ ALMONDS
KG | [NAME] CODE | INGREDIENT | PERCENT | [NAME] | $/KG | EXT
47.89 | DRAL4
5 | [NAME]
1.32 | CSOR
0.7 | SESAL
5.26 | WA
 |  | [NAME]
 |  | Percentage of loss: | 0.1 |  | SUB TOTAL:
 |  | GROSS kg per batch: | 105 |  | ADJUSTED:
 |  | NET kg per batch: |  |  | Total labour cost:
 |  | Min./batch : | 45 |  | TOTAL:
Spreadsheet: 109783d1306535759-dropdown-list-and-multiple-sheet-index-match-example-drop-down-list-problem
Sheet: Enchiladas

 | AK | AZ | CA | ID | WV
Enchilada Hut | Y | y | y | y | n
Fillipe's | Y | n | n | y | n
Three brothers | N | y | y | y | y
Spreadsheet: 644865d1570788844-freight-cost-calculation-based-on-weight-and-distance-sample-freight-analysis
Sheet: Input &required output

OID | Quote_Weight | Distance(In Miles) | Cost -output required without fuel surcharge | Cost Output -with fuel surcharge
3634 | 138 | 74.666448
3676 | 368 | 1052.471069
3718 | 270 | 732.056664
3760 | 213 | 279.1653
3802 | 100 | 1512
3886 | 348 | 2142.846402
3928 | 333 | 437.544117
Spreadsheet: 41337d1239810873-cells-cross-referancing-data-from-another-sheet-to-fill-themselves-in-quad1
Sheet: Placements

 | Place | Component | Circuit Ref
 | 1 |  | R4
 | 2 |  | R117
 | 3 |  | R12
 | 4 |  | C4
 | 5 |  | RN1
 | 6 |  | L2
 | 7 |  | R12
 | 8 |  | R13
 | 9 |  | R14
 | 10 | ?? | R15 |  |  | I would like component data to be added in colum "C" by cross referancing with the pickups work sheet.
 | 11 |  | R16 |  |  | In this case the data for cell (C, 12) would be "47R"
 | 12 |  | R165
 | 13 |  | R17
 | 14
 | 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
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
 | 199
 | 200
 | 201
 | 202
 | 203
 | 204
 | 205
 | 206
 | 207
 | 208
 | 209
 | 210
 | 211
 | 212
 | 213
 | 214
 | 215
 | 216
 | 217
 | 218
 | 219
 | 220
 | 221
 | 222
 | 223
 | 224
 | 225
 | 226
 | 227
 | 228
 | 229
 | 230
 | 231
 | 232
 | 233
 | 234
 | 235
 | 236
 | 237
 | 238
 | 239
 | 240
 | 241
 | 242
 | 243
 | 244
 | 245
 | 246
 | 247
 | 248
 | 249
 | 250
 | 251
 | 252
 | 253
 | 254
 | 255
Spreadsheet: 758012d1638566845-formula-to-get-next-number-in-the-same-position-based-on-history-histroy-number-based-on-positon
Sheet: Sheet1

Date | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 | 2021-11-14 00:00:00 | 2021-11-15 00:00:00 | 2021-11-16 00:00:00 | 2021-11-17 00:00:00 | 2021-11-18 00:00:00 | 2021-11-19 00:00:00 | 2021-11-20 00:00:00 | 2021-11-21 00:00:00 | 2021-11-22 00:00:00
RAW DATA | 5140 | 7715 | 3483 | 1484 | 1498 | 9210 | 5031 | 3601 | 2233 | 6593 | 2561 | 0330 | 5846 | 4267 | 5813 | 7054 | 6725 | 5163
History 1st digit - Next number | None | None | None | None | 1 | None | 7 | 1 | None | None | 6 | None | 7.3 | None | 7,3,4 | 3 | 2 | 7,3,4,7
History 2nd digit - Next number | None | None | None | None | 4 | None | None | None | None | None | 5 | None | None | 0.5 | 2 | 6 | 4 | 7
History 3rd digit - Next number | None | None | None | None | None | 8 | None | None | 0 | 1 | None | 0.9 | None | 3 | 8.3 | None | None | 3.1
History 4th digit - Next number | None | None | None | None | None | 5 | None | 1 | 4 | 4.3 | 1.3 | 5.1 | None | None | 4,3,1,3,1 | 8 | 3 | 4,3,1,4
Spreadsheet: 50173d1249561805-creating-a-template-printing-page-or-a-clever-way-of-copying-linked-cells-print-book
Sheet: Worker

Name | Address 1 | Address 2 | Town | County | Post Code | Country | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost | Quantity | Title | Cost
E.g. [NAME] | E.G. Address 1 | E.G. Address 2 | E.G. Town | E.G. County | E.G. POSTCODE | E.G. COUNTRY | 1 | E.G. title | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELETE | 0 | 0 | 0 | 0 |  |  | 0 | Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELETE | 0 | 0 | 0 | 0 |  |  | 0 | Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELETE | 0 | 0 | 0 | 0 |  |  | 0 | Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELETE | 0 | 0 | 0 | 0 |  |  | 0 | Total | 0 | 0 | 0 | 0
DELETE | 0 | 0 | 0 | 0 |  |  | 0 | Total | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 481643d1474566461-can-excel-differentiate-between-no-data-and-a-0-value-pcdata-september-2016
Sheet: Sheet2

 | VINT HILL PUMPSTATIONS |  |  |  |  | [NAME] WWTP INFLUENT |  |  |  |  |  |  | [NAME] EFFLUENT
 | BOD
 | East End | Brookside | Riley Rd | [NAME] Rn |  | BOD5 | TSS | Ammonia as N | Nitrates | TKN | Total PO4 |  | BOD5 | TSS | Ammonia as N | Nitrates | TKN | Total PO4
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | 411 | 149 | 54.6 | 0.05
 | 467 | 370 | 1070 | 465
Spreadsheet: 734653d1622356934-formula-vlookup-does-not-find-values-cerca_vertelenco-etaf
Sheet: dati

[NAME] | dati
a1 | aaaa 1
a2 | aaaa 2
A3 | aaaa 3
a4
A5 | aaaa 5
A6 | aaaa 6
A7
A8
A9 | aaaa 9
A10 | aaaa 10
A11 | aaaa 11
A12
A13 | aaaa 13
A14 | aaaa 14
A15
A16
A17 | aaaa 17
A18 | aaaa 18
A19 | aaaa 19
A20 | aaaa 20
Spreadsheet: da921fa1-a48c-4e2a-ab6d-b8323e2bd4df
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
F5DNA | Test | F5DNA | Factor [NAME] (R506Q) Mutation, Blood | Factor [NAME] (R506Q) Mutation, B | Direct Mutation Analysis | Yellow-Top (ACD) Tube: ACD |  |  | 6 | mL | Container/Tube:  Preferred: Yellow top (ACD) Acceptable: EDTA or sodium citrate [NAME]: Full tube Collection Instructions:  1. Invert several times to mix blood.  2. Send specimen in original tube. Additional Information: Can be combined with other molecular coagulation tests; -MTHAC 5,10-Methylenetetrahydrofolate Reductase A1298C, Mutation, Blood -PTNT Prothrombin G20210A Mutation, Blood -MTHFR 5,10-Methylenetetrahydrofolate Reductase C677T, Mutation, Blood -MTHP 5,10-Methylenetetrahydrofolate Reductase C677T and A1298C Mutations, Blood Forms: 1. Coagulation Patient Information Sheet (Supply T675) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL blood in a 3-mL ACD tube | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK-phone lab Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Green top (heparin) tube or Extracted DNA | Negative | Monday through Friday; 12 p.m. | 3 days | 5 days | 1 | 81241 |  |  |  |  | Rochester
F5DNA | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 7 days
F5DNA | Result | 21838 | Factor [NAME] (R506Q) Mutation, B | Factor [NAME] (R506Q) Mutation, B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21667-1 | F5 gene mutation analysis:Prid:Pt:Bld/Tiss:Nom:Molgen
F5DNA | Result | 21839 | F5DNA Interpretation | F5DNA Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69049-5
F5DNA | Result | 21841 | F5DNA Reviewed By | F5DNA Reviewed By | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 70992d1271755983-sorting-columns-by-rows-reg-survey-example
Sheet: Sheet1

Location … |  | Date…
07:00 | 07:30 | 08:00 | 08:30 | 09:00 | 09:30
WER908 | QWE098 | HG456 | TYJR234 | UIL789 | WEG345
SDG089 | [NAME] | TYJR234 | ERG8907 | WER234 | DF34T5
SDFG0789 | SDFG345 | QWER15 | [NAME] | DHB345 | HEHJ234
ASD089 | WER908 | NY345 | WER908 | ASDF0789 | VBN6
ERG8907 | HBTR34 | SDZV456 | ASDF0789 | ERH234 | ASDF0789
DFN234 | SDG089 | VBN6 | QWE123 | AWR234 | FRMJ7689
AEG9876 | QWE123 | [NAME] | HG456 | ERH345 | WE345
ASDF0789 | [NAME] | WER908 | UIL789 | ERG8907 | DB34
RTN09 | DFBH76 | QWE123 | VBN6 | VBN6 | ERH345
CVB897 | WERT345 | UIL789 | WER234 |  | WER234
ZSXC76 | HG456 | SDG089
QWE098
FN723
BT879
Spreadsheet: 714374d1611200613-matching-value-in-a-column-array-with-result-in-another-column-array-matching-value-in-a-range
Sheet: Sheet1

 |  | Months | 7
 |  |  | Month | Occupancy
 |  |  | 1 | 0
 |  |  | 2 | 0
 |  |  | 3 | 0
 |  |  | 4 | 0
 |  |  | 5 | 0
 |  |  | 6 | 0
 |  |  | 7 | 0.1
 |  |  | 8 | 0.05 |  |  | Result | return a result
 |  |  | 9 | 0.2 |  |  | argument
 |  |  | 10 | 0.5 |  |  | array | range of value in a column or row
 |  |  | 11 | 0.65
 |  |  | 12 | 0.8
 |  |  | IF ( % value in array  E6:E17 is >0, then return the smallest matching value in D6:D17)
 |  |  | In the proposed example, matching values are 7, 8, 9, 10, 11, 12; the smallest matching value is 7
 |  |  | So result is 7
Spreadsheet: 831898d1685979176-indicate-overlapping-dates-against-ids-date-entries-3
Sheet: Sheet1

Name | Check In Time | Check Out Time | Exclude? | EXPECTED RESULTS | kvsrinivasamurthy's old FORMULA
[NAME] | 2013-01-03 08:45:00 | 2013-01-03 16:45:00 | YES
[NAME] | 2013-01-03 09:30:00 | 2013-01-03 18:10:00 | NO | Delete
[NAME] | 2013-01-03 17:30:00 | 2013-01-03 18:20:00 | NO | Delete
[NAME] | 2013-01-03 09:30:00 | 2013-01-03 18:10:00 | NO
[NAME] | 2013-01-03 10:30:00 | 2013-01-03 16:30:00 | NO
[NAME] | 2013-01-03 10:30:00 | 2013-01-03 16:30:00 | NO | Delete
[NAME] | 2013-01-03 18:11:00 | 2013-01-03 20:30:00 | NO | Delete
Spreadsheet: chris_stokley__3903__Cash Flow information ECR1122 Specs v5
Sheet: Original

1 | Source System Name
2 | Source System ID Number
3 | Customer Name
4 | System Customer ID Number
5 | GCP ID (Customer) Number
6 | CMS Customer ID Number
7 | DUNS ID Number
8 | Customer Account (Site) ID Number
9 | Customer Account (Site) Name
10 | Customer Account (Site) Street Address
11 | Customer Account (Site) Street Address2
12 | Customer Account (Site) City
13 | Customer Account (Site) County
14 | Customer Account (Site) State
15 | Customer Account (Site) zip
16 | Customer Account (Site) zip + 4
17 | Customer Contact Name for collections (site?)
18 | Customer Contact Telephone number for collections (site?)
19 | Commodity
20 | SAP Company Number if known
21 | Company Number used by Oracle
22 | Company Name
23 | Type of customer
24 | Strategic customers flag / indicator
25 | Top 25, top 50, etc. customer indicators
26 | Mid-Market indicator ("Sales Rep." Field at CSC)
27 | GNO indicator
28 | Fast-track customer indicator
29 | Account Status
30 | Hold Code
31 | Invoice Number
32 | Invoice Date
33 | Total customer owes all A/R ages, plus current, plus unbilled.
34 | Invoice Amount (customer balance all ages, incl. current)
35 | Customer current amount
36 | Customer past due amount (previously billed)
37 | Invoice Due Date
38 | Invoice Discount Due Date
39 | Invoice Discount Percentage or amount
40 | Invoice Payment Terms
41 | Transaction Type
42 | Adjustment Type
43 | Adjustment Name
44 | Adjustment Amount
45 | Adjustment Date
46 | Credit Memo Number
47 | Credit Memo Date
48 | Credit Memo Amount
49 | Remittance (deposit) Date
50 | [NAME]
51 | Remittance Type
52 | Invoice Number Remittance was Applied to
53 | Cash Applied Date
54 | Customer check/wire/credit card or direct deposit confirmation number
55 | Balance Due
56 | Bank Name deposited to - Actual bank
57 | Account deposited to - Actual account
58 | Lockbox Number
59 | Type of payment/receipt
60 | Payment Pattern
61 | Unapplied Cash Remittance Amount
62 | Unapplied Cash Remittance Date
63 | Unapplied Cash Customer ID Number
64 | Unapplied Cash Customer Site Account ID Number
65 | Dispute Date
66 | Number of Days Dispute outstanding
67 | Customers on Payment Plan Flag
68 | Customer Final Notice Flag
69 | Customer Terminated Flag
70 | Attorney [NAME]
71 | Customer Bankruptcy Flag
72 | Comments/Notes/Other from the source systems
73 | Status of Account (current / past due)
74 | Utility Name
75 | Utility Number (if any)
76 | Extract Date
77 | Create Data
78 | Error Flag
79 | G/L coding for source A/R systems, [NAME] and SAP
80 | Record modification flag code
Spreadsheet: 00cee287-d4ff-4580-9605-8a31276d9c5d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
1 |  |  |  | EXPERT MEN 19+
16 |  |  |  | SEA OTTER CLASSIC - DUAL SLALOM   APRIL 7, 2006
9
8
5
12
13
4
3
 |  |  |  | 2nd Place | Champion
14
11
6
7
10
15 |  |  |  | Consolation Round
2
 |  |  |  |  | 3rd Place
 |  |  |  |  | 4th Place
Spreadsheet: 402c240a-5068-42d5-9bd9-c0a44a91fe38
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TFE3 | Test | TFE3 | Alveolar Soft Part Sarcoma (ASPS)/Renal Cell Carcinoma (RCC), Xp11.23 ([NAME]), FISH, Tissue | TFE3, Xp11.23, FISH, Ts | Fluorescence In Situ Hybridization (FISH) |  |  |  |  |  | Provide a pathology report with each tissue specimen. The laboratory will not reject a specimen that arrives without this information but will hold the specimen until a pathology report is received.     Container/Tube: Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: 5 unstained, 5-micron thick sections Collection Instructions: Include 1 hematoxylin and eosin-stained slide. Forms: If not ordering electronically, submit a Cytogenetics Hematologic Disorders Request Form (Supply T607) with the specimen. | Paraffin-embedded whole tissue o | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 7 days | 10 days |  | Profile |  |  |  |  | Rochester
TFE3 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
TFE3 | Order Question | CG600 | Reason For Referral |  | Plain Text
TFE3 | Result | 34287 | [NAME] | [NAME] | Alphanumeric
TFE3 | Result | 34288 | [NAME] | [NAME] | Alphanumeric
TFE3 | Result | 34289 | Source | Source | Alphanumeric
TFE3 | Result | 34290 | Order Date | Order Date | Alphanumeric
TFE3 | Result | CG600 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
TFE3 | Result | 34292 | Method | Method | Alphanumeric
TFE3 | Result | 34293 | Result | Result | Alphanumeric
TFE3 | Result | 34294 | Interpretations | Interpretations | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2
TFE3 | Result | 34295 | Amendment | Amendment | Alphanumeric
TFE3 | Result | 34296 | Consultant | Consultant | Alphanumeric
TFE3 | Result | 34297 | Released Date | Released Date | Alphanumeric
TFE3 | Billing Component | TFE3 |  | CYTO/MOLECULAR REPORT |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88291
TFE3 | Billing Component | TFE3 |  | CYTOGENETICS 100-300 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88275
TFE3 | Billing Component | TFE3 |  | CYTOGENETICS DNA PROBE |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 88271