tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 306af6fd-d85c-4029-8baf-60525dba54b9
Sheet: Sheet1

Table 6--U.S. rice imports  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Country | 2013/14 | 2012/13 | 2012/13 | 2011/12 | 2010/11 | 2009/10 | 2008/09
or | through | through | market | market | market | market | market
region | August 2013 | August 2012 | year | year | year | year | year
 |  |  |  | 1,000 metric tons
ASIA | 48.225 | 46.495 | 624.791 | 541.502 | 529.833 | 563.944 | 536.401
China | 0.231 | 0.113 | 2.709 | 3.584 | 3.1 | 3.786815 | 3.951477
India | 13.976 | 11.779 | 129.252 | 110.541 | 96.454 | 94.81 | 74.05
Pakistan | 2.762 | 1.309 | 17.648 | 15.224 | 17.297 | 19.387 | 16.852
Thailand | 27.946 | 30.937 | 393.738 | 387.642 | 393.464 | 400.977 | 422.132
Vietnam | 3.012 | 1.912 | 77.895 | 21.664 | 15.901 | 41.554 | 17.478
Other | 0.2979999999999987 | 0.4449999999999958 | 3.549000000000078 | 2.84699999999998 | 3.616999999999962 | 3.429461 | 1.938601
EUROPE & FSU | 0.919 | 0.976 | 11.137 | 14.256 | 12.51 | 9.411 | 7.566
Italy | 0.677 | 0.787 | 6.925 | 5.215 | 7.53 | 6.22 | 5.732
Spain | 0.078 | 0.028 | 2.217 | 4.669 | 3.753 | 1.55218 | 0.419
Russia | 0 | 0 | 0.039 | 0.024 | 0.034 | 0.032442 | 0.064456
United Kingdom | 0 | 0 | 0.112 | 0.039 | 0.009 | 0.126 | 0.43
Other | 0.164 | 0.1609999999999999 | 1.844000000000001 | 4.309000000000001 | 1.183999999999999 | 1.480378 | 0.9205439999999996
WESTERN HEMISPHERE | 3.114 | 2.564 | 35.871 | 64.526 | 42.735 | 30.357 | 31.065
Argentina | 0.416 | 0.37 | 5.453 | 3.366 | 2.677 | 2.466583 | 1.121503
Brazil | 0.713 | 0.49 | 4.979 | 30.499 | 6.331 | 3.51007 | 3.902248
Canada | 1.034 | 0.878 | 12.051 | 16.323 | 17.067 | 15.358 | 18.036
Mexico | 0.039 | 0.057 | 0.996 | 1.085 | 1.264 | 6.120591 | 6.094151
Uruguay | 0.909 | 0.768 | 12.322 | 13.211 | 15.35 | 2.871551 | 1.710958
Other | 0.002999999999999781 | 0.0009999999999998899 | 0.07000000000000384 | 0.04199999999998738 | 0.045744 | 0.030665 | 0.20047
OTHER | 0.6109999999999984 | 0.07400000000000428 | 2.807999999999915 | 0.9570000000000363 | 3.532636 | 5.470538 | 39.298261
Egypt | 0 | 0 | 0.639 | 0.001 | 0 | 0.645 | 36.591
United Arab Emirates | 0 | 0 | 0.269 | 0.522 | 3.03 | 4.441 | 2.225
Other | 0.6109999999999984 | 0.07400000000000428 | 1.899999999999914 | 4.2 | 0.5 | 0.384703 | 0.482498
TOTAL | 52.869 | 50.109 | 674.607 | 621.241 | 588.611 | 609.182 | 614.331
1/ Columns labeled "market year" are total August-July imports reported by the U.S. Census Bureau.
All data is reported on a product-weight basis.  Categories may not sum to total due to rounding.
Source: U.S. Census Bureau, Department of Commerce.
Last updated November 8, 2013.
Spreadsheet: 710324d1608839736-if-statement-formula-help-excelhelpexample
Sheet: Sheet1

 |  |  |  |  | avg | 1 | 2 | 3 | 4
Jrue Holiday | 21.5 |  |  | Jrue Holiday | 19.1311475409836
[NAME] | 18.5 |  |  | [NAME] | 23.82258064516129
Derrick Favors | 16.5 |  |  | Derrick Favors | 9
JJ Redick | 9.5 |  |  | JJ Redick | 15.28333333333333
[NAME] | 12.1 |  |  | [NAME] | 11.82539682539683
[NAME] | 13.2 |  |  | [NAME] | 10.09230769230769
Jahlil Okafor | 14.1 |  |  | Jahlil Okafor | 8.1
[NAME] | 15.9
Nickeil Alexander-Walker | 9.8
[NAME] | 13.5
[NAME] | 9.5
[NAME] | 7
OG Anunoby | 8.3
Pascal Siakam | 4.9
[NAME] | 6.5
[NAME] | 21.5
[NAME] | 19.5
Jrue Holiday | 19.1
OG Anunoby | 8.9
JJ Redick | 7.9
Nickeil Alexander-Walker | 8.6
Jahlil Okafor | 5.6
[NAME] | 9.8
Jahlil Okafor | 12.6
[NAME] | 13.1
Jrue Holiday | 16.1
[NAME] | 14.5
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | 500168 | Westar Ward
 | Scheduled | Measured
1 | 41027 | 41272
2 | 45258 | 44915
3 | 46312 | 46575
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2000-11-30 00:00:00 |  |  | 191116.48
2000-12-03 00:00:00
Spreadsheet: 872484d1718860872-get-data-based-on-match-on-data-in-another-sheet-bpiet-integration-id-uitval-bvj-phuocam-aligw
Sheet: Uitval

Gescande uitval: | Reden Uitval: | Integration Id
01011PRDA0IIYJY0000000069 | Layout                                        B
01010PRDA0IIXWB0000001088 | Blanco document                         A
01010PRDA0IIXWB0000004364 | Onvolledig/Geen adres                 C
01020PRDA0IIXWB0000003731 | [NAME] volgorde                     E
01020PRDA0IIXWB0000004195 | Layout                                        B
01020PRDA0IIXWB0000002450 | Layout                                        B
01030PRDA0IIXWB0000004692 | [NAME] volgorde                     E
01020PRDA0IIXWB0000005364 | Onvolledig/Geen adres                 C
01020PRDA0IIXWB0000005177 | Layout                                        B
01010PRDA0ILYV20000003009 | Onvolledig/Geen adres                 C
01020PRDA0IIXWB0000000747 | Onvolledig/Geen adres                 C
01040PRDA0IIXWB0000000011 | Onvolledig/Geen adres                 C
 | 1-2ASZVKOQ
 | 1-2ASNC8KT
 | 1-2ASV0AMO
 | 1-2ASWLAF9
 | 1-2ASVF17B
 | 1-2AT05671
De codes: | 1-2ASUDYW2
A Blanco document | 1-2ASS1L99
B Layout | 1-2ASS64UT
C Onvolledig/Geen adres | 1-2AT6MC45
D Adres onbekend op site PostNL | 1-2ASOET30
E [NAME] volgorde | 1-2A1XNUAZ
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-13-P-0004

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-13-P-0004 | 4504420512 | 0U3G5 | 1F | 1 | 1 | 4453608 | 2012-11-07 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 8915 | PAID | 5100174793 | 5000461763 | 2012-11-08 00:00:00 | 5000470002 | 2012-11-16 00:00:00 | 2500028331 | 2012-11-20 00:00:00 | 0 | 41036009100411
W912LP-13-P-0004 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 526181d1499177782-dynamic-ranges-which-adds-column-test
Sheet: l

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 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
Inbound ZIG | 1263 | 887 | 827 | 609 | 1121 | 697 | 705 | 673 | 820 | 821 | 1368 | 773 | 533 | 716 | 786 | 608 | 852 | 844 | 933 | 630 | 509 | 411 | 612 | 403 | 753 | 1200 | 100
Spreadsheet: 734380d1622130400-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: Hours

Project | Datum | Firma | Nummer | Vertrek | Tijd | Aankomst | Naam | Telefoon | Tropco's | Aantal | [NAME] | Wie D | Inkoop NL | Inkoop D | [NAME] | Verkoop D
5235 |  |  |  |  |  |  |  |  | 2 | 1 |  | nl |  |  |  |  |  | Uren inkoop |  |  | Km inkoop
5258 |  |  |  |  |  |  |  |  | 1 | 2 | [NAME] | nl |  |  |  |  |  | Uren verkoop |  |  | Km verkoop
5259 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | Verschil uren |  |  | [NAME] km
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL | 42.5 |  | Inkoop D | 1.15
5259 |  |  |  |  |  |  |  |  | 2 | 2 |  | nl |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5259 |  |  |  |  |  |  |  |  | 1 | 2 |  | nl |  |  |  |  |  | [NAME] |  |  | Verkoop D
5260 |  |  |  |  |  |  |  |  | 2 | 2 | [NAME] | nl |  |  |  |  |  | [NAME] |  |  | Verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 |  | Verkoop D | 1.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj NL ink |  |  | Totaal inkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver |  |  | Totaal verkoop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proj KM ink |  |  | Totaal verschil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project verschil NL |  |  |  | Project verschil D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal uren NL |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal Verkoop NL |  |  | Totaal verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zoek project | Aantal beg | Inkoop NL | Inkoop D | [NAME] | Verkoop D
 |  |  |  | =OF(EN($d2="";AANTALARG($g2:$h2)<>1);EN($d2=<>"";L2=""))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Klant | aantal beg
Spreadsheet: 151080d1334773681-excel-2007-expanding-years-in-spreadsheet-wac-spreadsheet-years-1-
Sheet: Sheet1

1995 |  |  |  |  |  | 1998 | A6 | AU1320102 | AU1320102 | AUDI | Audi | A6
1996 |  |  |  |  |  | 1998 | A6 | AU1320102 | AU1320102 | AUDI | Audi | A6
1997 |  |  |  |  |  | 1998 | A6 | AU1320102 | AU1320102 | AUDI | Audi | A6
1998 |  |  |  |  |  | 1998 | A6 | AU1320102 | AU1320102 | AUDI | Audi | A6
1994 |  |  |  |  |  | 1994 | [NAME] | AU1320102 | AU1320102 | AUDI | Audi | [NAME]
1995 |  |  |  |  |  | 1997 | S6 | AU1320102 | AU1320102 | AUDI | Audi | S6
2002 |  |  |  |  |  | 2008 | A4 | AU1320106 | AU1320106 | AUDI | Audi | A4
2003 |  |  |  |  |  | 2008 | A4_CABRIO_(CONVERTIBLE) | AU1320106 | AU1320106 | AUDI | Audi | A4 Cabrio
2007 |  |  |  |  |  | 2008 | RS4 | AU1320106 | AU1320106 | AUDI | Audi | RS4
2002 |  |  |  |  |  | 2008 | [NAME] | AU1320106 | AU1320106 | AUDI | Audi | [NAME]
2003 |  |  |  |  |  | 2008 | S4_CABRIO_(CONVERTIBLE) | AU1320106 | AU1320106 | AUDI | Audi | [NAME]
1996 |  |  |  |  |  | 1999 | A4 | AU1321104 | AU1321104 | AUDI | Audi | A4
2002 |  |  |  |  |  | 2008 | A4 | AU1321106 | AU1321106 | AUDI | Audi | A4
2003 |  |  |  |  |  | 2008 | A4_CABRIO_(CONVERTIBLE) | AU1321106 | AU1321106 | AUDI | Audi | A4 Cabrio
2007 |  |  |  |  |  | 2009 | RS4 | AU1321106 | AU1321106 | AUDI | Audi | RS4
2002 |  |  |  |  |  | 2008 | [NAME] | AU1321106 | AU1321106 | AUDI | Audi | [NAME]
2003 |  |  |  |  |  | 2008 | S4_CABRIO_(CONVERTIBLE) | AU1321106 | AU1321106 | AUDI | Audi | [NAME]
1996 |  |  |  |  |  | 1997 | A6 | AU2502105 | AU2502105 | AUDI | Audi | A6
1999 |  |  |  |  |  | 2001 | A4 | AU2502106 | AU2502106 | AUDI | Audi | A4
Spreadsheet: john_griffith__16218__2_1_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19.5 | 140 | 150 | 47.7 | 51.1 | 0.61 | 2002-02-01 10:07:00
 | CL J2 | 19.5 | 240 | 255 | 45.7 | 48.6 | 0.58 | 2002-02-01 10:07:00
 | CL K2 | 20 | 320 | 330 | 44.6 | 46.1 | 0.57 | 2002-02-01 10:07:00
 | CL M2 | 20 | 370 | 385 | 44 | 45.8 | 0.56 | 2002-02-01 10:07:00
 | CL N2 | 20 | 410 | 425 | 42.8 | 44.4 | 0.55 | 2002-02-01 10:07:00
 | CL Q2 | 20 | 440 | 460 | 41.8 | 43.7 | 0.54 | 2002-02-01 10:07:00
 | CL U2 | 20.5 | 450 | 470 | 38.6 | 40.4 | 0.51 | 2002-02-01 10:07:00
 | [NAME] | 20.5 | 470 | 490 | 37.4 | 39.1 | 0.49 | 2002-02-01 10:07:00
 | CL X2 | 20.5 | 480 | 500 | 36.1 | 37.6 | 0.47 | 2002-02-01 10:07:00
 | [NAME] | 20.5 | 485 | 505 | 34.7 | 36.2 | 0.46 | 2002-02-01 10:07:00
 | CL F3 | 20.5 | 490 | 515 | 33.5 | 35.2 | 0.44 | 2002-02-01 10:07:00
 | CL G3 | 20.5 | 495 | 520 | 32.4 | 34.1 | 0.43 | 2002-02-01 10:07:00
 | CL M3 | 20.5 | 535 | 555 | 30.8 | 32 | 0.4 | 2002-02-01 10:07:00
 | CL Z3 | 21 | 535 | 565 | 26.2 | 27.7 | 0.36 | 2002-02-01 10:07:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 546014d1509803402-final-salary-to-show-in-a-different-cell-final-payout-to-be-placed-in-a-different-sheet-2-
Sheet: Salary (2)

 | Sales_Person | [NAME]
 | Employee | Sales | Quality | Average # of Successful Sales |  | PAY COMPUTATION |  |  |  | ADJUSTMENTS Made |  |  |  | day 10-28-2017 ????
 | Week 1 |  |  |  |  | Number of hours lost |  |  |  | Amount | Comment(s)
 | Week 2 |  |  |  |  | Attendance deduction
 | Week 3 |  |  |  |  | Basic Pay
 | Week 4 |  |  |  |  | Internet Subsidy |  | 0
 | EOM |  |  |  |  | HMO Subsidy |  | 0
 | Target attainment |  |  |  |  | Performance Bonus
 | OCTOBER ATTAINMENT |  |  |  |  | Sales Commission |  | 0
 |  |  |  |  |  | RDOT (150%) |  | 0
 |  |  |  |  |  | OT |  | 0
 | Date | Hours Worked | [NAME] | Comment(s) |  | Holiday Pay (100%) |  | 0
 | 2017-10-16 00:00:00 |  |  |  |  | Referral Bonus |  | 0
 | 2017-10-17 00:00:00 |  |  |  |  | [NAME] |  | 0
 | 2017-10-18 00:00:00 |  |  |  |  | Reimbursement |  | 0
 | 2017-10-19 00:00:00 |  |  |  |  | Final Payout
 | 2017-10-20 00:00:00
 | 2017-10-23 00:00:00 |  |  |  |  | Attainment | Tier | $ [NAME] |  |  |  |  |  |  |  |  | Bonus Money
 | 2017-10-24 00:00:00 |  |  |  |  | 300-399% | Tier 10 | 500 |  |  |  |  |  | 3 | 3.99 |  | 500
 | 2017-10-25 00:00:00 |  |  |  |  | 201-299% | Tier 9 | 400 |  |  |  |  |  | 2.01 | 2.99 |  | 400
 | 2017-10-26 00:00:00 |  |  |  |  | 181-200% | Tier 8 | 350 |  |  |  |  |  | 1.81 | 2 |  | 350
 | 2017-10-27 00:00:00 |  |  |  |  | 166-180% | Tier 7 | 300 |  |  |  |  |  | 1.66 | 1.8 |  | 300
 | 2017-10-30 00:00:00 |  |  |  |  | 150-165% | Tier 6 | 275 |  |  |  |  |  | 1.5 | 1.65 |  | 275
 | 2017-10-31 00:00:00 |  |  |  |  | 140-149% | Tier 5 | 225 |  |  |  |  |  | 1.4 | 1.49 |  | 225
 | 2017-10-28 00:00:00 |  |  |  |  | 130-139% | [NAME] | 175 |  | The Tier Column will highlight the correct tier for |  |  |  | 1.3 | 1.39 |  | 175
 | 2017-11-02 00:00:00 |  |  |  |  | 120-129% | Tier 3 | 150 |  | the sales person. |  |  |  | 1.2 | 1.29 |  | 150
 | 2017-11-03 00:00:00 |  |  |  |  | 110-119% | [NAME] | 125 |  |  |  |  |  | 1.1 | 1.19 |  | 125
 | 2017-11-06 00:00:00 |  |  |  |  | 101-109% | Tier 1 | 100 |  |  |  |  |  | 1.01 | 1.09 |  | 100
 | 2017-11-07 00:00:00 |  |  |  |  | 0-100% | Tier 0 | 0 |  |  |  |  |  | 0 | 1 |  | 0
 | 2017-11-08 00:00:00
 | 2017-11-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | If the employee's Attainment Bonus (D11) for example is 250%, which falls
 | 2017-11-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | between the range of cell N21 and O21, the employee will get a bonus salary of $400.
 | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | This should highlight the correct cell in Column H21:H31
Spreadsheet: 743586d1628606680-dynamically-fill-1-sheet-from-another-working-schedule-master-sample
Sheet: Pub-Page2

CRICKET - 100 | 2021-08-11 00:00:00 | 00:30:00 | ORIGINALS | SPIRIT
CARABAO CUP | 2021-08-11 00:00:00 | 01:45:00 | DERBY COUNTY | SALFORD CITY |  |  | 20 | 13 | 6 | 18 | 18
FOOTBALL - CH. LGE | 2021-08-11 00:00:00 | 02:00:00 | RANGERS | MALMÖ
CRICKET - 100 | 2021-08-12 00:00:00 | 00:30:00 | BRAVE | FIRE
CARABAO CUP | 2021-08-12 00:00:00 | 01:45:00 | LEYTON ORIENT | QPR
FOOTBALL - UEFA S'CUP | 2021-08-12 00:00:00 | 02:00:00 | CHELSEA | VILLAREAL
NRL | 2021-08-12 00:00:00 | 16:50:00 | STORM | RAIDERS
CRICKET - TEST | 2021-08-12 00:00:00 | 17:00:00 | ENGLAND V INDIA | SECOND TEST
GOLF | 2021-08-12 00:00:00 | 17:00:00 | WYNDHAM CH'SHIP | GREENSBORO, NC
CRICKET - 100 | 2021-08-13 00:00:00 | 01:00:00 | SUPERCHARGERS | ORIGINALS
FOOTBALL - EUR. LGE | 2021-08-13 00:00:00 | 01:45:00 | CELTIC | JABLONEC
NRL | 2021-08-13 15:00:00 | 15:00:00 | DRAGONS | PANTHERS
NRL | 2021-08-13 16:55:00 | 16:55:00 | BRONCOS | ROOSTERS
CRICKET - 100 | 2021-08-14 00:00:00 | 01:00:00 | ROCKETS | PHOENIX
FOOTBALL - LGE CUP | 2021-08-14 00:00:00 | 01:30:00 | RANGERS | DUNFERMLINE ATH
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 02:00:00 | BRENTFORD | ARSENAL
AFL | 2021-08-14 00:00:00 | 09:00:00 | BRISBANE | COLLINGWOOD
AFL | 2021-08-14 00:00:00 | 09:00:00 | FREMANTLE | W C EAGLES
AFL | 2021-08-14 00:00:00 | 09:00:00 | G C SUNS | ESSENDON
AFL | 2021-08-14 00:00:00 | 09:00:00 | GEELONG CATS | ST KILDA
AFL | 2021-08-14 00:00:00 | 09:00:00 | GWS GIANTS | RICHMOND
AFL | 2021-08-14 00:00:00 | 09:00:00 | HAWTHORN | W BULLDOGS
AFL | 2021-08-14 00:00:00 | 09:00:00 | MELBOURNE | ADELAIDE
AFL | 2021-08-14 00:00:00 | 09:00:00 | N MELBOURNE | SYDNEY SWANS
AFL | 2021-08-14 00:00:00 | 09:00:00 | PORT ADELAIDE | CARLTON
NRL | 2021-08-14 00:00:00 | 12:00:00 | RABBITOHS | TITANS
RUGBY - INTERNATIONAL | 2021-08-14 00:00:00 | 14:00:00 | NEW ZEALAND | AUSTRALIA
NRL | 2021-08-14 00:00:00 | 14:30:00 | COWBOYS | WESTS TIGERS
NRL | 2021-08-14 00:00:00 | 16:35:00 | SEA EAGLES | EELS
FOOTBALL - C'SHIP | 2021-08-14 00:00:00 | 18:30:00 | PETERBOROUGH | DERBY COUNTY
Spreadsheet: 77036d1277475287-data-from-workbook-to-another-based-on-conditions-sample
Sheet: All accounts

2010-2011 contract | 2010-2011 notes | Last Name | First Name | Audiologist | mainstream Contact name | School Contact | School Contact Title | School District | School Attended | School Street | School town | Distance to school round trip from CHC (miles) | Estmated time round trip (in minutes) | Hearing Aid/CI Left Make Model SN | Hearing Aid/CI Right Make Model SN | Transmitter Model & SN | Trans War Exp | Rec #1 Model and SN | Rec #1 Warr | Rec # 2 Model & SN | Rec # 2 Warr | Default Channel Set | Default Channel Set
Y | New Purchase | Smith | [NAME] | Dr. [NAME] | Fred | [NAME] |  | Hawaii internation
Y |  | Panic | [NAME] | Dr. [NAME] | None | [NAME] | Asst Director of Pupil Services | Hawaii internation
N |  | Stapes | Olivia | Dr. [NAME] | Deb | [NAME] |  | Northampton Public Schools | JFK Middle School
Waiting |  | [NAME] | Sofia | Dr. [NAME] | NA | [NAME] | Student Services Coordinator | [NAME] District 33 Main St; Hatfield, MA 01038 | Hartsbrook School | 193 Bay Road | Hadley, MA 01035-9793 | 12 | 35 | Phonak Nios V: 0935X0FG1 | Phonak Nios V: 0935X0FG2 | Easylink 0824N104W CH: 01 | 2009-04-08 00:00:00 | Micro MLxS 0842C10VX | 2009-04-08 00:00:00 | Micro MLxS 0842C10VW | 2009-04-08 00:00:00 | N01, N02 | N01, N02
Y |  | Malleus | Logan | Dr. [NAME] | [NAME] | Mr. [NAME] | Director of Special Education | Hampshire Regional School District | [NAME] | 34 Pomeroy Meadow Road | Southampton, MA  01073 | 18.78 | 38 | NA | NA | Campus S 056C14330 | 2009-08-20 00:00:00 | MicroEar 056C26782 | 2009-06-30 00:00:00
Spreadsheet: 866374d1713302244-formula-to-retun-multiple-values-rate
Sheet: cuurent rate

Main table 1
name | id | effective date | rate
[NAME] | 134406 | 2021-09-30 00:00:00 | 26.5
[NAME] | 134406 | 2021-10-11 00:00:00 | 29.32
[NAME] | 463904 | 2021-09-30 00:00:00 | 39.04
[NAME] | 131205 | 2021-10-05 00:00:00 | 39.88
drake | 127029 | 2021-09-30 00:00:00 | 39.97
drake | 132599 | 2021-10-30 00:00:00 | 39.04
drake | 130861 | 2021-11-13 00:00:00 | 37.22
table 2
name | id | start date | rate
[NAME] | 134406 | 2021-09-30 00:00:00
[NAME] | 134406 | 2021-10-22 00:00:00
[NAME] | 463904 | 2021-01-03 00:00:00
[NAME] | 131205 | 2021-10-05 00:00:00
drake | 127029 | 2021-09-30 00:00:00
drake | 132599 | 2021-10-31 00:00:00
drake | 130861 | 2021-11-30 00:00:00
I would like to fill in the rate vaule  in D18-D24
the formula should look at the effective date in main table 1.  if the start date in table 2 is equal or after the start date in main table one then that rate should be applied.
for example
in table 2, the row with [NAME] with a start date of 9/31, based on the main table,  26.50 should be applied in cell D18
in the following row [NAME] has a start date of 10/22.  based on the main table.  Cell D19 Should have 29.32
Spreadsheet: 132755d1323903813-automatic-leaderboard-2011-12-bowl-pool-summary-dfd0001
Sheet: summary_chart_data

 | OFFSET FOR GRAPH
 | Name | 8
 | Offset | 9
 | Points | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Participants
 | Maximum
 | Points So Far
 | Total Still Possible
 | Still Possible
 | [NAME] RANKINGS
 | [NAME] | AVG POINTS | RANK
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 351769d1413299301-explain-lookup-2-1-a2-a10-d2-b2-b10-lastvalue
Sheet: Sheet2

Header1 | Header2 |  | Lookup | 1st value | Last value | 1st-Last
L1 | sad |  | [NAME]
L1 | ran
L1 | pri
[NAME] | dep
[NAME] | ras
L2 | siy
L2 | fas
L3 | asf
L3 | aji
Spreadsheet: 874152d1720715075-vlookup-or-index-and-match-function-for-getting-values-example
Sheet: Sheet2

ID | Item | Unit Price | Quoted Price
P-3 |  | 150 | 120
P-1 |  | 120 | 100
P-8 |  | 205 | 190
P-2 |  | 200 | 180
P-4 |  | 180 | 160
P-6 |  | 400 | 350
P-9 |  | 80 | 90
P-5 |  | 90 | 100
P-10 |  | 60 | 50
P-7 |  | 100 | 95
Spreadsheet: 2a19ade2-1440-4550-9ffc-034a0d5ae409
Sheet: Część IV

Załącznik nr 5 do SIWZ | część IV
Lp. | Opis [NAME] | Parametry techniczne | Nazwa producenta/nazwa produktu/[NAME] ([NAME]) | Rozmiar opakowania | Ilość opakowań | Cena [NAME] [PLN] | Wartość całkowita brutto [PLN]
1. | [NAME] do syntezy pierwszej nici cDNA | [NAME] do syntezy pierwszej nici cDNA zawierający m.in. [NAME] transkryptazę M-MLV i startery oligo(dT)15 |  | 100 reakcji | 1
2. | Agaroza | Do elektroforezy RNA i rozdziału produktów PCR, brak obecności DNaz /RNaz niski punkt topnienia bardzo wysoka wytrzymałość żelu (1400 g/cm2), wysoka rozdzielczość produktów PCR oraz fragmentów DNA w zakresie 100 -10 000 pz, zwiększona transparentność żelu [NAME] widoczność rozdzielanych fragmentów [NAME], [NAME] tło fluorescencji przy barwieniu bromkiem etydyny. |  | 1 kg | 1
 | SUMA:
 | podpis Wykonawcy…………………………………
Spreadsheet: jeffrey_a_shankman__13918__Pick Sheet - Week 17
Sheet: Week 12

NFL PICKS OF THE WEEK - 2001
Name:
Phone Number where we can reach you on Sunday morning:
Last Person Standing Team Pick:
SEND TO:   E-mail - [EMAIL] |  |  |  | Phone - (707) 255-4813 |  |  | Fax - (707) 255-4832
WEEK 12  - First Game is Thursday @ 9:30 a.m.
 |  | Visitor |  |  |  | Home
Thursday, November 22
 |  | Green Bay Packers |  |  |  | Detroit Lions
 |  | Denver Broncos |  |  |  | Dallas Cowboys
Sunday, November 25
 |  | Pittsburgh Steelers |  |  |  | Tennessee Titans
 |  | [NAME] |  |  |  | Buffalo Bills
 |  | Cincinnati Bengals |  |  |  | [NAME]
 |  | San Francisco 49er's |  |  |  | Indianapolis Colts
 |  | [NAME] |  |  |  | Kansas City Chiefs
 |  | Washington Redskins |  |  |  | Philadelphia Eagles
 |  | Atlanta Falcons |  |  |  | Carolina Panthers
 |  | Baltimore Ravens |  |  |  | [NAME]
 |  | New Orleans Saints |  |  |  | New England Patriots
 |  | Arizona Cardinals |  |  |  | San Diego Chargers
 |  | Oakland Raiders |  |  |  | New York Giants
 |  | Chicago Bears |  |  |  | Minnesota Vikings
Monday, November 26
 |  | Tampa Bay Buccaneers |  |  |  | St. Louis Rams
Tiebreaker |  |  |  | Total |  |  | Total should = 120
Entries must be received by the beginning of the first game of the week (earlier is perfectly ok!)
Always start by giving the team that you think is most likely to win 15 points and go down from there.
If there are only 14 games in a week, your lowest pick will be "2" instead of "1"
Bye Week: | New York Jets
Spreadsheet: 79211d1279509360-validation-list-spreadsheet-2-exp-
Sheet: Page 2

 | Hair
Name | Hairstyle | Color
 | Flat Medium | 0
 | #N/A | [NAME]
 | #N/A | 0
 | Conrows Long | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
 | #N/A | 0
Spreadsheet: 139716d1328402672-vlookup-from-multiple-pages-test-lookup-different-page-values
Sheet: Feb

TABLE
[NAME] | CODE | BUILDING | $
LABOR | 45 | 1 | 45650
SUPPLIES | 46 | 2 | 7500
RENTAL | 47 | 3 | 500
EQUIPMENT | 48 | 4 | 750
MISC | 49 | 5 | 1000
IT | 50 | 6 | 27500
Spreadsheet: 708156d1607630297-lookup-with-3-criteria-oil-mix-1-
Sheet: LT

Store | Product | Qty | Part Price | Cost
4001 | LTLOFP1
4002 | LTLOFP1
4003 | LTLOFP1
4004 | LTLOFP1
4005 | LTLOFP1
4006 | LTLOFP1
4007 | LTLOFP1
4008 | LTLOFP1
4009 | LTLOFP1
4010 | LTLOFP1
4011 | LTLOFP1
4012 | LTLOFP1
4013 | LTLOFP1
4014 | LTLOFP1
4015 | LTLOFP1
4016 | LTLOFP1
4017 | LTLOFP1
4018 | LTLOFP1
4020 | LTLOFP1
4021 | LTLOFP1
4022 | LTLOFP1
4151 | LTLOFP1
4152 | LTLOFP1
4155 | LTLOFP1
4157 | LTLOFP1
Totals