tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 823271d1679869172-assessing-values-by-looking-up-table-for-range-sample
Sheet: Data

Stn | Measure | Value | Status | Result
1 | Gage | 1435 |  |  | =INDEX(Table2[@Measure],MATCH(c2,IF(Data!=G6,data[Weight]),1))
2 | Twist | 11
3 | Warp | 8
4 | Gage | 1436
5 | Twist | 12
6 | Warp | 3
7 | Gage | 1454
8 | Twist | 21
9 | Warp | 3
10 | Gage | 1440
11 | Twist | 12
12 | Warp | 8
13 | Gage | 1448
14 | Twist | 9
15 | Warp | 3
16 | Gage | 1432
17 | Twist | 4
Spreadsheet: rick_buy__32698__DOUG
Sheet: 0600

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF JUNE 30, 2000
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 8139276.22 |  | 3455362.88 |  | 1859430.72 |  | 974385.64 |  | 1712084.13 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 0
PUERTO QUETZAL | A/R |  | 0 |  | 0 |  | 2005 |  | 0 |  | 444405.91 |  |  | THIS MONTH TOTAL PAYMENTS
463 | PER CENT
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
416 | PER CENT
DABHOL POWER CO | A/R |  | 222492.95 |  | 435365.24 |  | 0 |  | 0 |  | -193455.91 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPRESA ENERGETICA | A/R |  | 2555.2 |  | 3075315.03 |  | 1484576.05 |  | 0 |  | 3121.04 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
EGEMINSA | A/R |  | 2967641.79 |  | 4552270.22 |  | 1046489.72 |  | 52659.22 |  | 833470.97 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 3059914.9
TOTALS | A/R
 | PER CENT
Spreadsheet: louise_kitchen__23037__AAearn by month
Sheet: Summary

E N R O N   N O R T H  A M E R I C A
2Q2000 - 2Q2001
in Millions of $
 |  | 2Q 2000 |  | 3Q 2000 |  | 4Q 2000 |  | 1Q 2001 |  | 2Q 2001 |  | Total
Margin
Gas Trading |  | 0 |  | 0
Power Trading |  | 0 |  | 0
Other Trading |  | 0 |  | 0
Peakers |  | 0 |  | 0 |  | 0
Originations/Office of the Chair/Other |  | 0 |  | 0
MPR |  | 0 |  | 0
Total Margin
Schedule C*
Gas
Power
Schedule C
Total Daily Margin
*Schedule D items not included:
Alberta PPA |  |  |  |  |  | 197.7
Other(COF Rediscounting) |  |  |  |  |  | 83.6
Spreadsheet: 58484d1258724101-how-to-record-the-amount-a-cell-consecutively-rises-or-falls-macrorisefall
Sheet: Sheet1

105 |  |  |  |  |  |  |  |  |  |  |  | helper(for validation)
 |  |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  | 91
 |  |  | 105 | 109 | 0.03669724770642202 |  |  |  |  |  |  | 92
 |  |  | Falling |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  | 101
 |  |  |  |  |  |  |  |  |  |  |  | 102
 |  |  |  |  |  |  |  |  |  |  |  | 103
 |  |  |  |  |  |  |  |  |  |  |  | 104
 |  |  |  |  |  |  |  |  |  |  |  | 105
 |  |  |  |  |  |  |  |  |  |  |  | 106
 |  |  |  |  |  |  |  |  |  |  |  | 107
 |  |  |  |  |  |  |  |  |  |  |  | 108
 |  |  |  |  |  |  |  |  |  |  |  | 109
 |  |  |  |  |  |  |  |  |  |  |  | 110
Spreadsheet: 217391d1362060084-values-in-between-mappe1
Sheet: Inddata

 | Kategori | Bælægning
 | 1 | 2
 | 2 | 3
 | 3 | 4
 | 4 | 2
 | Indtægter for bandereklamer
 | Mere end 35,000.00 tilskuere |  |  |  |  | 1000000
 | Mindre end 34,999.00 og mere end 25,000.00 tilskuere |  |  |  |  | 750000
 | Mindre end 24,999.00 og mere end 15,000.00 tilskuere |  |  |  |  | 500000
 | Mindre end 14,999.00 tilskuere |  |  |  |  | 250000
 | Vare | Estimeret salg pr. tilskuer |  |  | Pris pr. [NAME].
 | Øl | 1.5 |  |  | 50
 | Sodavand | 0.5 |  |  | 20
 | Pølse-salg | 0.2 |  |  | 40
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending May 24, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 86577d1286525343-inventory-stock1
Sheet: PROJECTORS

S.No | DESCRIPTION | SERIAL NO | SERIAL NO | QTY | FINISH
 | HOME THEATRE PROJECTORS
 | Infocus  DLP projector | X10 | BBIJ83900297 | 1
 | Infocus Projector( No Lamp) |  | AULC73500426 | 1
 | Infocus  Projector( Lamp Dull) | W240 | AULC73500441 | 1
 | Panasonic | PT AX200E | SB0250094, SB0230167 | 1
 | Hitachi  LCD Projector (Repair) | CP-RS55 | H7C033353, H7C031345 | 2
 | Epson  projector | EMP 7900 | GD9G690030F | 1
 | SIM2 Multimedia Domino  DLP Projector | D60 | 547837912043065 | 1
 | Sanyo Projectors | Z800 | [NAME] | 1
 | DATA PROJECTORS
 | Panasonic  LCD Projector | PT-LB60EA | SB8130327 | 1
 | Sony LCD projector | VPL-ES7 | 7059085-K; 7045444-E; 7059092-I; 7059089-O | 4
 | Sony LCD projector | VPL-EX70 | 7022484/481/486/502/482 ; 854/483/ | 7
 | Sony LCD projector | VPL-EX70 | 7018079
 | Sony LCD projector | VPL-EX7 | 7058410-B; 7066151-C; 7058083-H | 3
 | Sony Data projector | FX41/10 | 1001396-6 | 1
 | OHP
 | Braun  Paxilux Overhead Projectors |  | 189274 | 1
 | Plycom ASY , TOP,SS2,EXP,[NAME],ROW/IN |  | H8094802C147, H8094802BFA8 | 2
 | Polycom Sound station Ex-mics(EAR phone) |  | 2200-16155-015 | 2
 | BACK
Spreadsheet: 773651d1647975486-pulling-multiple-cells-from-multiple-rows-and-columns-that-can-repeat-every-9-rows-excelhelp_extractingcells
Sheet: Data Needed

Image # | SB | LAEA | RAEA | LPEA | RPEA | LAEP | RAEP | LPEP | RPEP | LAEF | RAEF | LPEF | RPEF | AL | PL | LL | RL
Spreadsheet: 109127d1306062839-if-contains-mx-basic-20example-1-
Sheet: DATA

Section Type | [NAME] | MarketPair | Market Pair Name | Total Flights | % of Flights | X Flights | X MS | Total Rev | X Rev | X Rev %
Carrier | [NAME] | DTW-RDU | Detroit, MI-Raleigh/Durham, NC | 300 |  | 250 |  | 100000 | 50000
Carrier | [NAME] | BJX-RDU | Guanajuato, MX-Raleigh/Durham, NC | 299 |  | 249 |  | 99999 | 49999
Carrier | [NAME] | DFW-STL | Dallas-DFW, TX-St. Louis, MO | 298 |  | 248 |  | 99998 | 49998
Carrier | [NAME] | DTW-FRA | Detroit, MI-Frankfurt Main, DE | 297 |  | 247 |  | 99997 | 49997
Carrier | [NAME] | DTW-LHR | Detroit, MI-London Heathrow, UK | 296 |  | 246 |  | 99996 | 49996
Carrier | [NAME] | DTW-PHL | Detroit, MI-Philadelphia, PA | 295 |  | 245 |  | 99995 | 49995
Carrier | [NAME] | BJX-DTW | Guanajuato, MX-Detroit, MI | 294 |  | 244 |  | 99994 | 49994
Carrier | [NAME] | DTW-ORD | Detroit, MI-Chicago-O'Hare, IL | 293 |  | 243 |  | 99993 | 49993
Carrier | [NAME] | DTW-SDF | Detroit, MI-Louisville, KY | 292 |  | 242 |  | 99992 | 49992
Carrier | [NAME] | LHR-SAN | [NAME], UK-San Diego, CA | 291 |  | 241 |  | 99991 | 49991
Carrier | [NAME] | BDL-MGM | Hartford, CT-Montgomery, AL | 290 |  | 240 |  | 99990 | 49990
Carrier | [NAME] | BNA-DTW | Nashville, TN-Detroit, MI | 289 |  | 239 |  | 99989 | 49989
Carrier | [NAME] | CLT-DTW | Charlotte, NC-Detroit, MI | 288 |  | 238 |  | 99988 | 49988
Carrier | [NAME] | DFW-MGM | Dallas-DFW, TX-Montgomery, AL | 287 |  | 237 |  | 99987 | 49987
Carrier | [NAME] | BDL-CVG | Hartford, CT-Cincinnati, OH | 286 |  | 236 |  | 99986 | 49986
Carrier | [NAME] | POA-RDU | [NAME], BR-Raleigh/Durham, NC | 285 |  | 235 |  | 99985 | 49985
Carrier | [NAME] | FNT-RDU | Flint, MI-Raleigh/Durham, NC | 284 |  | 234 |  | 99984 | 49984
 |  |  | Totals
have a spreadsheet with
several travel markets around
the world and on
the same line it
contains revenue for the
market. I need to
SUM the value of
all travel to Mexico | How can I search out just , MX and have the revenue from cells E2:E9000 sum on another page?
but the only way
it's displayed in the
report is by Guanajuato,
MX-Raleigh/Durham, NC or Detroit,
MI-Guanajuato, MX the only
common item is ,
MX and it's always |  | SUMPRODUCT(('new Raw Data'!$O$2:$O$33792)*('new Raw Data'!$U$2:$U$33792=2002)*(ISNUMBER(SEARCH("consol",'new Raw Data'!$E$2:$E$33792))))
in colum D with
a cell range of
D2:D900
Spreadsheet: 124902d1318702914-how-to-turn-a-column-of-numbers-into-interval-range-ptgroupcount
Sheet: Sheet1

Age
0
0
0
1 |  | Row Labels | Count of Age
2 |  | 0-4 | 7
3 |  | 5-9 | 8
4 |  | 10-14 | 5
5 |  | 15-19 | 2
6 |  | 20-25 | 6
6 |  | Grand Total | 28
6
7
8
8
9
10
10
11
11
12
15
17
22
22
22
22
25
25
Spreadsheet: kevin_ruscitti__20274__market briefs
Sheet: Sheet1

Market Brief | Wednesday, May 30
Stocks | Close | Change | % Change
DJIA | 10872.64 | -166.5 | -0.01508269665934122
DJ 15 Util. | 388.47 | 0.6400000000000432 | 0.001650207565170418
NASDAQ | 2084.5 | -91.04 | -0.04184708164409754
S&P 500 | 1248.08 | -19.85000000000014 | -0.01565543839170943
Market Vols | Close | Change | % Change
AMEX (000) | 136860 | 23050 | 0.2025305333450488
NASDAQ (000) | 1990784 | 380503 | 0.2362960253520969
NYSE (000) | 1154599 | 144446 | 0.1429941800895508
Commodities | Close | Change | % Change
Crude Oil (Jul) | 28.55 | -0.1099999999999994 | -0.003838101884159087
Heating Oil (Jun) | 0.776 | 0.001299999999999968 | 0.00167806892990831
Nat. Gas (Henry) | 3.981 | 0.2429999999999999 | 0.06500802568218296
Palo Verde (Jul) | 325 | 0 | 0
COB (Jul) | 300 | 0 | 0
PJM (Jul) | 84 | -3 | -0.03448275862068965
Dollar US $ | Close | Change | % Change
Australia $ | 1.95 | 0.0169999999999999 | 0.008794619762027885
Canada $ | 1.546 | 0.008000000000000007 | 0.005201560468140447
Germany Dmark | 2.283 | 0 | 0
Euro | 0.8564 | 0.00230000000000008 | 0.002692893103852101
Japan ¥en | 120.4 | 0.3000000000000114 | 0.002497918401332318
Mexico NP | 9.18 | 0.08000000000000007 | 0.0087912087912088
[NAME] | 0.7007 | -0.00219999999999998 | -0.003129890453834087
Foreign Indices | Close | Change | % Change
Arg MerVal | 427.92 | -2.289999999999964 | -0.005322981799586164
[NAME]. | 3339.9 | -8.5 | -0.002538525863098793
[NAME] | 14489.36 | 35.45000000000073 | 0.002452623546154689
Can TSE 300 | 8101.41 | -150.59 | -0.01824890935530782
Germany DAX | 6041.22 | -79.10999999999967 | -0.01292577361024645
[NAME] | 13420.13 | -209.4800000000014 | -0.01536947865712969
Japan Nikkei 225 | 13493.35 | -280.5399999999991 | -0.02036752144818922
[NAME] | 6586.93 | -78.60999999999967 | -0.01179349310033391
UK FTSE 100 | 5796.9 | -67 | -0.01142584286908031
Source:  Yahoo! & TradingDay.com
Spreadsheet: 97867d1296984621-random-numbers-fre
Sheet: Sheet2

1 | 556572 |  |  |  |  | 7 |  | 1 | 20 | 20
1 | 222431 |  |  |  |  | 1 |  | 2 | 10 | 10
1 | 136229 |  |  |  |  | 5 |  | 3 | 5 | 5
1 | 630912 |  |  |  |  | 1 |  | 4 | 12 | 12
1 | 392488 |  |  |  |  | 6 |  | 5 | 11 | 11
1 | 531263 |  |  |  |  | 1 |  | 6 | 8 | 8
1 | 527436 |  |  |  |  | 6 |  | 7 | 22 | 22
1 | 632620 |  |  |  |  | 2 |  | 8 | 8 | 8
1 | 181020 |  |  |  |  | 3 |  | 9 | 4 | 4
1 | 911776 |  |  |  |  | 1
1 | 244942 |  |  |  |  | 8
1 | 659783 |  |  |  |  | 6
1 | 725700 |  |  |  |  | 7
1 | 967766 |  |  |  |  | 8
1 | 925617 |  |  |  |  | 1
1 | 810989 |  |  |  |  | 3
1 | 519780 |  |  |  |  | 7
1 | 974427 |  |  |  |  | 5
1 | 859809 |  |  |  |  | 1
1 | 90132 |  |  |  |  | 8
2 | 744692 |  |  |  |  | 4
2 | 237358 |  |  |  |  | 7
2 | 921429 |  |  |  |  | 2
2 | 571075 |  |  |  |  | 7
2 | 660314 |  |  |  |  | 4
2 | 566012 |  |  |  |  | 1
2 | 666347 |  |  |  |  | 8
2 | 77729 |  |  |  |  | 7
2 | 7502 |  |  |  |  | 4
2 | 350454 |  |  |  |  | 2
3 | 840990 |  |  |  |  | 2
3 | 383015 |  |  |  |  | 1
3 | 8151 |  |  |  |  | 4
3 | 126622 |  |  |  |  | 6
3 | 914197 |  |  |  |  | 1
4 | 730966 |  |  |  |  | 1
4 | 685680 |  |  |  |  | 5
4 | 296017 |  |  |  |  | 7
4 | 356379 |  |  |  |  | 7
4 | 361491 |  |  |  |  | 2
4 | 421234 |  |  |  |  | 2
4 | 769891 |  |  |  |  | 7
4 | 150485 |  |  |  |  | 1
4 | 89362 |  |  |  |  | 9
4 | 207362 |  |  |  |  | 8
4 | 650147 |  |  |  |  | 1
4 | 461618 |  |  |  |  | 1
5 | 341143 |  |  |  |  | 9
5 | 616284 |  |  |  |  | 1
5 | 973671 |  |  |  |  | 7
5 | 484567 |  |  |  |  | 8
5 | 95051 |  |  |  |  | 7
5 | 414055 |  |  |  |  | 5
5 | 189216 |  |  |  |  | 4
5 | 27603 |  |  |  |  | 5
5 | 301332 |  |  |  |  | 6
5 | 457862 |  |  |  |  | 7
5 | 830209 |  |  |  |  | 4
6 | 289969 |  |  |  |  | 5
6 | 906845 |  |  |  |  | 1
6 | 634990 |  |  |  |  | 3
6 | 430148 |  |  |  |  | 4
6 | 923493 |  |  |  |  | 4
6 | 98358 |  |  |  |  | 2
6 | 248582 |  |  |  |  | 9
6 | 943842 |  |  |  |  | 7
7 | 558388 |  |  |  |  | 5
7 | 503562 |  |  |  |  | 7
7 | 768541 |  |  |  |  | 5
7 | 164921 |  |  |  |  | 4
7 | 34637 |  |  |  |  | 6
7 | 840042 |  |  |  |  | 7
7 | 81836 |  |  |  |  | 6
7 | 76403 |  |  |  |  | 1
7 | 424631 |  |  |  |  | 2
7 | 81063 |  |  |  |  | 1
7 | 254610 |  |  |  |  | 4
7 | 741691 |  |  |  |  | 5
7 | 329712 |  |  |  |  | 1
7 | 890456 |  |  |  |  | 7
7 | 586627 |  |  |  |  | 4
7 | 718706 |  |  |  |  | 7
7 | 979535 |  |  |  |  | 1
7 | 601939 |  |  |  |  | 3
7 | 486884 |  |  |  |  | 7
7 | 112372 |  |  |  |  | 6
7 | 145694 |  |  |  |  | 5
7 | 342123 |  |  |  |  | 8
8 | 6139 |  |  |  |  | 1
8 | 718945 |  |  |  |  | 4
8 | 91048 |  |  |  |  | 7
8 | 543197 |  |  |  |  | 7
8 | 868790 |  |  |  |  | 2
8 | 788159 |  |  |  |  | 7
8 | 909336 |  |  |  |  | 7
8 | 496810 |  |  |  |  | 5
9 | 549333 |  |  |  |  | 9
9 | 527217 |  |  |  |  | 3
9 | 343836 |  |  |  |  | 2
9 | 12760 |  |  |  |  | 8
Spreadsheet: 745675d1630094008-filtered-lookup-with-multi-column-data-return-draftexcelforumhelpnewweeklyphecreadings
Sheet: Hi_Low_OnTarget

Week | (All)
Row Labels | Average of Measured pH | Average of Adjusted EC (mS)
[NAME] sp. | 5.721 | 0.8400318181818182
Blueberry (Vaccinium sp.) | 4.444705882352942 | 1.827329411764706
Holiday Cactus (Schlumbergera sp.) | 6.106111111111112 | 0.4365388888888889
Sunflower (Helianthus sp.) | 5.373333333333334 | 0.3727333333333333
Spathiphyllum sp. | 5.713437499999999 | 1.8734625
Asper sp. (Bamboo) | 5.683333333333334 | 1.413353333333333
Celosia sp. | 6.095000000000001 | 0.10825
[NAME] sp. | 6.035625 | 0.322825
Calathea sp. | 6.169999999999999 | 0.2457365853658537
Peperomia sp. | 5.022307692307692 | 4.004153846153847
Alocasia sp. | 5.69230769230769 | 0.6713102564102564
Poinsettia (Euphorbia pulcherima) | 6.283846153846155 | 0.4903538461538461
Calla Lily (Zantedeschia spp.) | 5.561686746987955 | 0.7254392857142858
Fern Asplenium sp. | 5.51125 | 0.8329000000000002
Fern East Indian Holly (Arachnoides sp.) | 5.186000000000001 | 1.82758
Syngonium sp. | 5.69 | 0.6377666666666666
Fern Korean Rock (Polystichum sp.) | 5.16875 | 2.3299125
Fern Maidenhair (Adiantum sp.) | 5.525 | 1.14965
Hypoestes sp. | 5.982380952380953 | 0.375347619047619
Chlorophytum sp. ([NAME]) | 5.883 | 0.2779
Aphelandra sp. | 5.561000000000001 | 0.8245699999999999
African Violet (Saintpaulia sp.) | 5.609 | 0.8433700000000002
Narcissus sp. | 6.005000000000001 | 0.0809
Aglaonema sp. | 6.064285714285715 | 0.3697285714285714
Dracaena sp. | 5.857222222222221 | 0.7698888888888887
Aralia sp. | 5.863333333333333 | 0.525388888888889
[NAME] sp. | 5.499999999999999 | 0.7926428571428572
Pothos sp. | 5.688 | 0.96234
Aloe sp. | 5.5 | 0.5205333333333334
[NAME] ([NAME]) | 5.859999999999999 | 0.8110999999999999
Fern Blue Star (Phlebodium sp.) | 5.95 | 0.8462
Euphorbia spp. | 5.798 | 0.62798
Hemerocallis sp. (Daylily) | 5.87 | 0.1855
Grand Total | 5.644518518518515 | 0.9123177504393675
Spreadsheet: 136266d1326495542-grupe-and-sum-in-tabel-example-1
Sheet: Ark1

Kolonne1 | Kolonne2 | [NAME] | Kolonne4
TEST 1 | on | 01:00:00
TEST 1 | on | 01:00:00
TEST 1 | off | 01:00:00
TEST 1 | off | 01:00:00
TEST 1 | off | 01:00:00
TEST 1 | off | 01:00:00
TEST 1 | off | 01:00:00
TEST 1 | off | 01:00:00
TEST 1 | off | 01:00:00
TEST 1 | off | 01:00:00
TEST 2 | on | 01:00:00
TEST 2 | on | 01:00:00
TEST 2 | on | 01:00:00
TEST 2 | off | 01:00:00
TEST 2 | off | 01:00:00
TEST 2 | off | 01:00:00
TEST 2 | off | 01:00:00
TEST 2 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | on | 01:00:00
TEST 3 | off | 01:00:00
TEST 3 | off | 01:00:00
TEST 3 | off | 01:00:00
TEST 3 | off | 01:00:00
TEST 3 | off | 01:00:00
TEST 3 | off | 01:00:00
TEST 4 | on | 01:00:00
TEST 5 | off | 01:00:00
TEST 5 | off | 01:00:00
TEST 5 | on | 01:00:00
TEST 5 | off | 01:00:00
TEST 5 | on | 01:00:00
TEST 5 | on | 01:00:00
THAT IS RESULT HOW THAT NEED TO BE, I CAN MAKE IT MANUALLY, BUT IN ORIGINAL FILE; THERE IS 9494 ROWS!!, AND MORE THAN 200 different text in colum A
I NEED FORMEL THAR CAN SELF FINDE OUT WHERE IS THAT SAME TEXT AND WHERE IN B IS ON, THEN THAT CALCULATE SUM
I CANT USE GROUP BICAUSE FILE IS TO BIG.
Spreadsheet: e2f86b8d-ce20-478e-8682-46095e224018
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
BAKDM | Test | BAKDM | BCR/ABL, Tyrosine Kinase Inhibitor Resistance, Kinase Domain Mutation Screen | BCR/ABL Mutation, ASPE | Reverse Transcription-Polymerase Chain Reaction (RT-PCR) with Fluorescent-Bead Array Analysis Allele-Specific Primer Extension (ASPE) and Detection by [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  |  |  | The following information is required: 1. Patient's fusion type (p210, p190, p185 or p230) 2. Pertinent clinical history 3. Clinical or morphologic suspicion 4. Date of collection 5. Specimen source (blood or bone marrow)   Forms:  1. Hematopathology Patient Information Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen.   [NAME] must arrive within 72 hours of collection.   Note: If BCR/ABL fusion type (p210, p190, p185 or p230) are not provided, BADX / BCR/ABL, mRNA Detection, [NAME] (RT-PCR), Qualitative, Diagnostic Assay will be performed at an additional charge.   Submit only 1 of the following specimens:   Preferred: [NAME] blood Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. 3. Label specimen as blood.   Acceptable: [NAME] marrow Container/Tube: Lavender top (EDTA) [NAME]: 2 mL Collection Instructions: 1. Invert several times to mix bone marrow. 2. Send specimen in original tube. 3. Label specimen as bone marrow. | 1 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday | 5 days |  | 1 | 81403 |  |  |  |  | Rochester
BAKDM | [NAME] | VARIES | Varies |  |  |  | Ambient | 72 hours
BAKDM | Order Question | MP004 | [NAME] |  | Plain Text
BAKDM | Order Question | MOFF | BCRABL Fusion Form |  | Plain Text
BAKDM | Result | MP004 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
BAKDM | Result | MOFF | BCRABL Fusion Form | BCRABL Fusion Form | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55135-8 | BCR-ABL1 kinase domain mutation analysis:Prid:Pt:Bld/Tiss:Nom:Molgen
BAKDM | Result | 19824 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4 | Path report.final diagnosis:Imp:Pt:[NAME]:Nom:
Spreadsheet: 156240d1337239562-manage-data-using-macro-send-out
Sheet: final output

Zone | Code | name | dealer | workshop | retail
E | 11 | a | 2 | 2 | 23
S | 13 | b | 3 | 0 | 34
S | 12 | c | 1 | 1 | 21
N | 34 | d | 1 | 0 | 21
W | 45 | e | 1 | 0 | 11
W | 32 | f | 0 | 1 | 0
N | 56 | g | 0 | 0 | 32
Spreadsheet: 706543d1606762178-formula-sum-and-multiplying-dynamic-array-spilled-behavior-dynamic-array-3-
Sheet: Calculation

 | Price | Volume | Revenue
a | 1 | 10 | 10
b | 2 | 20 | 40
new peoduct | 5 | 50 | 250
c | 3 | 30 | 90
d | 4 | 40 | 160
Total |  | 150 | 550
Spreadsheet: 46759d1245702392-copying-values-from-matched-rows-test
Sheet: Sheet1

Surname | Postcode | Level | Mode | Match
Smith | BT12 5HT |  |  | Yes
[NAME] | BT83 2DG |  |  | No
[NAME] | BT1 4IS |  |  | Yes
Jones | BT73 3KD |  |  | Yes
Ahmed | BT87 4HD |  |  | No
Chung | BT7 8SD |  |  | No
Spreadsheet: 811982d1672905632-sum-if-if-multiple-rows-book1
Sheet: Sheet1

ID | name | a | b | c | d | e | total | 1 | 2 |  | expected result
abc | abcde | 27 | 0 | 3 | 3 | 3 | 33 |  |  |  | PASS
abc | abcde | 27 | 0 | 3 | 3 | 3 | 33 |  |  |  | PASS
hellan | [NAME] dew | 1 | 0 | 0 | 0 | 0 | 1 |  |  |  | False
Spreadsheet: 110501d1307128684-finding-first-instance-of-a-value-goldenclick
Sheet: Sheet1

A | Do something
A | Do something else
A | Do something else
B | Do something
C | Do something
C | Do something else
D | Do something
B | Do something else
E | Do something
E | Do something else
Spreadsheet: 775038d1648786506-return-value-if-company-name-doesnt-exactly-match-book11
Sheet: Matix Production

 | Online Travel Agent
RAW REPORT | Revenue |  |  |  | Channel | Returned value
Booking.com (OTA) | 194067717.85 |  |  |  | Agoda
Ctrip (BAR) |  |  |  |  | Booking.com
Ctrip (WHO) |  |  |  |  | Cleartrip
Direct Reservation |  |  |  |  | Ctrip
Expedia Lodging Partner Service (OTA) | 33491831.96 |  |  |  | Expedia
[NAME] (LEI) |  |  |  |  | Goibibo
[NAME] (BAR) |  |  |  |  | Hotelscombined
Hotelbeds (WHO) |  |  |  |  | Makemytrip
[NAME] (GMG) |  |  |  |  | MyTour
Long Stay (PKG) |  |  |  |  | PegiPegi
[NAME] Hotel Reservation (WHO) |  |  |  |  | Tiket.com
PT. [NAME] (BAR) |  |  |  |  | Travelguru
PT. [NAME] (WHO) |  |  |  |  | Traveloka
Tiket.Com (OTA) | 76423939.64 |  |  |  | VnTrip
Travel Tripper (OTD)
Traveloka (OTA) | 25368504.22
Grand Total | 329351993.67
From
01/03/2022 00:00:00
To
31/03/2022 [NAME]
Row by
Company-Agent
Column by
Booking Source
Included Dummy Room
False
Included Comp / House Used
False
Spreadsheet: 144007d1330665628-credit-action-credit-action
Sheet: Sheet1

Amount charged | Discount allowed | Total due | Payment | difference | Cr ?
10 |  |  | 9 |  | cr
20 | 2 |  | 18
Spreadsheet: jim_schwieger__14331__NYMEX Calendar
Sheet: Sheet1

Bid Month | Bid Week | Natural Gas Close | Natural Gas Options | Crude Oil Close | Crude Oil Options | Enron Holidays | NYMEX Holidays
2000-12-01 00:00:00 | 12/22 - 12/29 | 12/27 Jan K | 12/26 Jan K | 12/19 Jan K | 12/14 Jan K | 12/25, 12/26 | 12/25
2001-01-01 00:00:00 | 1/24 - 1/26 | 1/29 Feb K | 1/26 Feb K | 1/22 Feb K | 1/17 Feb K | 1/1, 1/15 | 1/1, 1/15
2001-02-01 00:00:00 | 2/21 - 2/23 | 2/26 Mar K | 2/23 Mar K | 2/20 Mar K | 2/14 Mar K | 2/19 | 2/19
2001-03-01 00:00:00 | 3/23 - 3/27 | 3/28 Apr K | 3/27 Apr K | 3/20 Apr K | 3/15 Apr K
2001-04-01 00:00:00 | 4/23 - 4/26 | 4/26 May K | 4/25 May K | 4/20 May K | 4/17 May K |  | 4/13
2001-05-01 00:00:00 | 5/24 - 5/28 | 5/29 [NAME] | 5/25 Jun K | 5/22 Jun K | 5/17 [NAME] | 5/28 | 5/28
2001-06-01 00:00:00 | 6/22 - 6/26 | [NAME] | 6/26 Jul K | 6/20 Jul K | 6/15 Jul K
2001-07-01 00:00:00 | 7/24 - 7/26 | [NAME] | 7/26 Aug K | 7/20 Aug K | 7/17 Aug K | 7/4 | 7/4
2001-08-01 00:00:00 | 8/24 - 8/28 | 8/29 Sep K | 8/28 Sep K | 8/21 Sep K | 8/16 Sep K
2001-09-01 00:00:00 | 9/21 - 9/25 | 9/26 Oct K | 9/25 Oct K | 9/20 Oct K | 9/17 Oct K | 9/3 | 9/3
2001-10-01 00:00:00 | 10/24 - 10/26 | 10/29 Nov K | 10/26 Nov K | 10/22 Nov K | 10/17 Nov K
2001-11-01 00:00:00 | 11/23 - 11/27 | 11/28 Dec K | [NAME] | 11/19 Dec K | 11/14 Dec K | 11/22, 11/23 | 11/22, 11/23 (early closing)
2001-12-01 00:00:00 | 12/20 - 12/26 | 12/27 Jan K | 12/26 Jan K | 12/19 Jan K | 12/14 Jan K | 12/24, 12/25 | 12/24, 12/25