tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 771971d1646935640-rerurns-number-instead-of-date-with-index-function-issue-with-date
Sheet: All

Facility | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00
Spreadsheet: 92167d1291823110-lookup-for-specific-values-in-multiple-cells-ops-cards
Sheet: Coremaking Equipment

 |  |  |  |  | Master Information Record
 | Part No. | H4628 |  |  |  | Tooling Ref. |  |  | Casting Weight |  | Kgs
 | Customer |  |  |  |  | Drg/lss.No. |  |  | Gross Wt./Mld |  | Kgs
 | Material |  |  |  |  |  |  |  | Yield |  | %
q | Cust. Spec |  |  |  |  | Core Weight |  |  | Castings/Mould
COREMAKING EQUIPMENT
Plant |  | Tooling Ref. |  |  |  | AM Number |  | Description
TOOLING NOTES
COREMAKING DIRECTIVES |  |  |  |  |  | NOTES
 | Core Centre
p | Cores Dipped
p | Calibration of Hansberg Mixing Plant |  |  |  | WI 9.2
p | Hansberg line sand mixer:- Cleaning |  |  |  | WI 9.49
 | Machine Settings |  |  |  | TD 14
p | "First Off" Inspection - Core Shop |  |  |  | WI 10.10
p | "In Process" Inspection - Core Shop |  |  |  | WI 10.11
p | Core Dipping:- Material Control |  |  |  | WI 9.29
p | Core Trolley Identification |  |  |  | WI 12.3
p | Corebox vent & blow tube cleaning |  |  |  | WI 9.35
p | Hansberg Production Equipment Check List |  |  |  | WI 9.15
(WHEN PRINTED) THIS IS AN UNCONTROLLED DOCUMENT
Spreadsheet: 155168d1336693626-search-value-and-return-a-set-of-values-in-the-row-weatherdata_sample_geodist2
Sheet: InsertIntoTable

Average Solar Radiation based on NREL Data
(kWh/m^2/day) | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Mount0
Mount1
Mount2
Mount3
Mount5
Mount6
Mount7
Mount8
Mount9
 | Input data
 | Latitude
 | Longitude
New Method | Nearest weather station information retreived
 | City | State | Latitude | Longitude | Elevation | Pressure | StationType |  | Needed to convert lat/long into radians
Spreadsheet: 116648d1311965624-multi-line-cell-spliting-slightly-shorter-formulas
Sheet: Sheet1

Title | Name | Address | Postcode | [NAME] | [NAME] | [NAME] | [NAME]
Mr | [NAME] | Madeup House Imaginary Street Crazy Town Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234 |  | Madeup House | Imaginary Street | Crazy Town | Weird Area | Silly County
Mr | [NAME] | Madeup House Imaginary Street Crazy Town Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234 |  | Madeup House | Imaginary Street | Crazy Town | Weird Area | Silly County
Mr | [NAME] | Madeup House Imaginary Street Crazy Town Weird Area Silly County | BL4 8LA | [EMAIL] | 123456789 | 9876543210 | 5678901234 |  | Madeup House | Imaginary Street | Crazy Town | Weird Area | Silly County
Spreadsheet: 75dbfa93-30ee-419b-b671-15fe4f83130a
Sheet: Sheet1

HASIL PENILAIAN PLPG TAHAP 5-8 TAHUN 2011
NO | NOMOR PESERTA | NAMA PESERTA | ASAL SEKOLAH | KAB/KOTA | STATUS
1 | 11030906310946 | SRI MUJIYATI | SMP N 1 JUWANGI | kab. Boyolali | Lulus
2 | 11030922710822 | YUNIYANTI | SMP N 2 SIMO | kab. Boyolali | [NAME]
3 | 11030121710871 | SULASTRI RAHAYU | SMP N 1 BINANGUN | Kab. Cilacap | Lulus
4 | 11030206311670 | NASIRIN GUNAWAN | SMK YPPPK MARDIKENYA PURWOKERTO | Kab. Banyumas | Lulus
5 | 11030206311722 | ROSLINA SAPTANINGRUM | SMK Purnama 2 Banyumas | Kab. Banyumas | Lulus
6 | 11030222711400 | BAMBANG JOKO SUGIYANTO | SMP Maarif NU 1 Ajibarang | Kab. Banyumas | Lulus
7 | 11030222711583 | SITI ROLIYAH | SMP Maarif NU 2 Ajibarang | Kab. Banyumas | Lulus
8 | 11030222711606 | SUPRIYATIN | SMP PGRI KEBASEN | Kab. Banyumas | Lulus
9 | [PHONE] | INDRI MURTI W | SMK N 3 PURWOKERTO | Kab. Banyumas | Lulus
10 | 11030281011345 | NURI WIDHIA DWI RETNOWATI | SMPN 1 Patikraja | Kab. Banyumas | Lulus
11 | 11030906310900 | PADMI HANDARI | SMP N 3 SAWIT | Kab. Boyolali | [NAME]
12 | 11030906311010 | Yuwaningsih | SMP 1 Klego | Kab. Boyolali | [NAME]
13 | 11030922710840 | SRI SIHNO | SMP N 1 SAWIT | Kab. Boyolali | [NAME]
14 | 11032006310525 | MASFUAD | SMP N 2 WELAHAN | Kab. Jepara | Lulus
15 | 11032006310528 | MURTANDHO | SMP N 1 MAYONG | Kab. Jepara | Lulus
16 | 11032806310651 | NURJANAH | SMP N 1 TARUB | Kab. Tegal | [NAME]
17 | 11032806310790 | RENAWATI | SMP MUHAMMADIYAH  LEBAKSIU | Kab. Tegal | [NAME]
18 | 11032806310792 | SITI SODIYAH | SMP MA''ARIF NU MARGASARI | Kab. Tegal | Lulus
19 | 11032906311159 | NINING SUWARTI | SMP N 3 LOSARI | Kab. Brebes | Lulus
20 | 11032906311160 | MULYATI | SMP N 2 TANJUNG | Kab. Brebes | Lulus
21 | 11032906311177 | ARTANTI PROBORINI | SMP N 1 BREBES | Kab. Brebes | Lulus
22 | 11032906311376 | KAMALI | SMK KI HAJAR DEWANTORO KLAMPOK WANASARI | Kab. Brebes | Lulus
23 | 11032906311377 | AGUS SUPRAPTO | SMK N 1 TONJONG | Kab. Brebes | Lulus
24 | 11032906311378 | A   ALVIN | SMK (SMEA) KARYA BHAKTI BREBES | Kab. Brebes | Lulus
25 | 11032906311383 | FAISAL HARIS M.R | SMK N 1 TONJONG | Kab. Brebes | Lulus
26 | 11036206310178 | PITOYO NGATIMIN | SMP DHARMA LESTARI | [NAME] | Lulus
27 | 11032402710096 | MUH ARIFIN | SD N 1 NGABEAN | Kab. Kendal | Lulus
28 | 11032402710112 | SULISTYANINGSIH | SD N KARANGMANGGIS | Kab. Kendal | [NAME]
Spreadsheet: 12cfe1b1-9f37-42e6-b54f-67439952e3fa
Sheet: Sheet1

Unnamed: 0 | 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 | Unnamed: 14
Oklahoma Department of Career and Technology Education
Temporary Assistance for Needy Families (TANF)
Work Prep
Claims are due October 19, January 18, April 19, July 21, August 19
1. | District or Consortium Name |  |  |  |  | 6. | E-Mail Address LEA Contact |  |  |  |  |  |  | Submit reports to:
 |  |  |  |  |  |  | E-Mail Address Finance Contact
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ODCTE
2. | Mailing Address & Zip Code |  |  |  |  | 7. | Allocation |  | Total                          $ | Federal                         $ | State                            $ |  | Inkind                            $ | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500 West 7th Avenue
3. | [NAME] |  |  | () |  | 8. | Period Covered - FY2013 |  | From: |  | To: |  |  | Stillwater, OK 74074-4364
4. | Finance Contact Person / Phone |  |  | ()
5. | School FAX Number | ()
 | FUNCTION | OCCUPATIONAL TRAINING SERVICES | SOCIAL WORK SERVICES | ADMINISTRATIVE COST & SUPERVISION | GUIDANCE & COUNSELING | TESTING & ASSESSMENT | JOB DEVELOPMENT & PLACEMENT/ EMPLOYMENT SPECIALIST & JOB READINESS | EEC/LEARNING LABS /ACADEMIC CENTERS | OFFICE OF COORDINATOR |  | INKIND FUNCTION CODE | INKIND OBJECT CODE | INKIND LINE ITEM AMOUNT
 | OBJECT | 1500 | 2113 | 2490 | 2122/2120 | 2123/2240 | 2126 | 2192 | 2430 | TOTAL | Code # | Code # | $
 | 100 Salaries |  |  |  |  |  |  |  |  | 0
 | 200 Benefits |  |  |  |  |  |  |  |  | 0
 | 320 ProfessionalServices |  |  |  |  |  |  |  |  | 0
 | 336 Medical/Dental Services |  |  |  |  |  |  |  |  | 0
 | 430 Repair & Maintenance Services |  |  |  |  |  |  |  |  | 0
 | 440 Rentals or Lease Services |  |  |  |  |  |  |  |  | 0
 | 510 Student Transportation |  |  |  |  |  |  |  |  | 0
 | 530 Communications Services |  |  |  |  |  |  |  |  | 0
 | 540 Advertising/Printing |  |  |  |  |  |  |  |  | 0
 | 561 Tuition |  |  |  |  |  |  |  |  | 0
 | 569 Assessment Fees |  |  |  |  |  |  |  |  | 0
 | 580 Travel |  |  |  |  |  |  |  |  | 0
 | 610 Supplies & Books |  |  |  |  |  |  |  |  | 0
 | 650 Technology-related Items and Supplies |  |  |  |  |  |  |  |  | 0
 | 730 Equipment and Capital Expenditures |  |  |  |  |  |  |  |  | 0
 | 810 Dues/ Fees (Students Only) |  |  |  |  |  |  |  |  | 0
 | 860 Staff Registration/Tuition |  |  |  |  |  |  |  |  | 0
 | 880 Student Assistance |  |  |  |  |  |  |  |  | 0
 | TOTAL DIRECT COST | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Total | 0
 | 900                                                Indirect Cost |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Total Inkind
 |  |  |  |  |  |  |  |  | Total | 0 |  | & Federal | 0
 | Name of Superintendent or Designee
 | Signature of Superintendent or Designee |  |  |  |  |  | Date |  |  | 0
Spreadsheet: 838303d1690904041-multiple-condition-based-on-the-multiple-status-reference-11
Sheet: Sheet1

Low | Medium | High | Very High | Catastrophic |  | Status
1 | 1 | 1 | 2 | 1 |  | Catastrophic |  |  |  | Low | Combination of medium/low severity (should not be > 3 medium severity, otherwise rating should be upgraded into Medium)
 |  |  |  |  |  |  |  |  |  | Medium | Combination of at least 1 high finding and medium/low findings
Low | Medium | High | Very High | Catastrophic |  |  |  |  |  | High | Combination of 2-3 high findings and medium/low findings
1 | 1 | 2 | 3 | 0 |  | Catastrophic |  |  |  | Very High | <2 very high or >4 high findings and high/medium/low findings
 |  |  |  |  |  |  |  |  |  | Catastrophic | >1 Catastrophic or >3 very high findings and high/medium/low findings
Low | Medium | High | Very High | Catastrophic
1 | 1 | 3 | 1 | 0 |  | Very High
Low | Medium | High | Very High | Catastrophic
1 | 1 | 4 | 0 | 0 |  | Very High
Low | Medium | High | Very High | Catastrophic
1 | 3 | 3 | 0 | 0 |  | High
Low | Medium | High | Very High | Catastrophic |  | High
3 | 3 | 2 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Medium
3 | 2 | 1 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Medium
4 | 3 | 0 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Low
5 | 2 | 0 | 0 | 0
Low | Medium | High | Very High | Catastrophic |  | Low
5 | 1 | 0 | 0 | 0
Spreadsheet: 266230d1379534012-consecutive-intervals-rawa
Sheet: Sheet1

Data
0.6870748299319728
0.8014705882352942
0.9159663865546218
0.9452054794520548
1
1
0.8611111111111112
0.9142857142857143
0.6612903225806451
0.4193548387096774
0.9024390243902439
1
1
0.978021978021978
0.821917808219178
0.8079470198675497
0.7436974789915967
0.9102990033222591
0.8670694864048338
0.7558139534883721
0.573170731707317
0.2472222222222222
0.1861471861471861
0.1932938856015779
0.1765913757700205
0.132034632034632
0.4015444015444015
0.8395061728395061
0.9373970345963756
0.9548494983277592
0.954248366013072
0.9648562300319489
0.9820261437908496
1
0.9899598393574297
0.8298755186721992
0.8604166666666667
0.9803921568627451
0.9386363636363636
0.5382932166301969
0.1826280623608018
0.1129032258064516
0.6070528967254408
0.9484848484848485
0.9903225806451613
0.983402489626556
0.9764150943396226
0.9651162790697675
Spreadsheet: 39636d1237918923-lookup-across-3-columns-to-get-total-value-sumproduct-datesandcategorysummary
Sheet: Sheet1

PropNo | CustCode | zone | [NAME] | cat | networkname | PropName | Address1 | Address2 | Address3 | City | State | PinCode | TelNo | [NAME] | Prop DOB | married | spousename | dobspouse | AnniversaryDate
[PHONE]-1 | 221000000133 | NZ011 | SILVER
[PHONE]-2 | 221000000232 | NZ002 | SILVER
[PHONE]-3 | 221000000232 | NZ002 | SILVER
[PHONE]-1 | 221000000406 | NZ012 | BLUE
[PHONE]-2 | 221000000497 | NZ003 | GOLD
[PHONE]-1 | 221000000513 | NZ013 | GOLD
[PHONE]-1 | 221000000620 | NZ003 | BLUE
[PHONE]-1 | 221000000638 | NZ003 | BLUE
[PHONE]-1 | 221000000661 | NZ001 | BLUE
[PHONE]-1 | 221000000679 | [NAME] | BLUE
[PHONE]-1 | 221000000836 | NZ002 | BLUE
[PHONE]-2 | 221000000976 | NZ001 | BLUE
[PHONE]-1 | #N/A | #N/A | #N/A
[PHONE]-1 | 221000001206 | [NAME] | SILVER
[PHONE]-1 | 221000001388 | NZ013 | SILVER
[PHONE]-1 | 221000001495 | NZ015 | BLUE
[PHONE]-2 | 221000001495 | NZ015 | BLUE
[PHONE]-1 | 221000001511 | NZ013 | SILVER
[PHONE]-2 | #N/A | #N/A | #N/A
Spreadsheet: 41152d1239662703-countif-question-test-info-2
Sheet: Sheet1

 | Jan
 | 1 | 2 | 3 | 4
 | H | H | H | h
 | h | h | h | h
 | T | T | T | t
 | t | T | t | t
 | HT | HT | HT | ht
 | ht | ht | ht | ht
 | B | B | B | b
 | b | b | b | b
H's | 2 | 2 | 2 |  | Need to count the letters Separately.
T's | 2 | 2 | 2
HT's | 2 | 2 | 2
B's | 2 | 2 | 2
Spreadsheet: 263161d1378391004-how-to-use-vlookup-with-2-values-date-of-birth-vlookup
Sheet: Original Data

Origainal |  |  |  |  | Desired outcome
Surname | Forename | DOB |  |  | Surname | Forename | DOB
[NAME] | Builder |  |  |  | [NAME] | Builder | 1997-04-13 00:00:00
[NAME] | Builder |  |  |  | [NAME] | Builder | 1997-04-13 00:00:00
[NAME] | Builder |  |  |  | [NAME] | Builder | 1997-04-13 00:00:00
[NAME] | Builder |  |  |  | [NAME] | Builder | 1997-04-13 00:00:00
[NAME] | Builder |  |  |  | [NAME] | Builder | 1997-04-13 00:00:00
[NAME] | Builder |  |  |  | [NAME] | Builder | 1997-04-13 00:00:00
[NAME] | Builder |  |  |  | [NAME] | Builder | 1997-04-13 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | Mills |  |  |  | [NAME] | Mills | 1995-03-12 00:00:00
[NAME] | [NAME] |  |  |  | [NAME] | [NAME] | 1998-04-30 00:00:00
[NAME] | [NAME] |  |  |  | [NAME] | [NAME] | 1998-04-30 00:00:00
[NAME] | [NAME] |  |  |  | [NAME] | [NAME] | 1998-04-30 00:00:00
[NAME] | [NAME] |  |  |  | [NAME] | [NAME] | 1998-04-30 00:00:00
[NAME] | [NAME] |  |  |  | [NAME] | [NAME] | 1998-04-30 00:00:00
[NAME] | [NAME] |  |  |  | [NAME] | [NAME] | 1998-04-30 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Micky | Doodle |  |  |  | Micky | Doodle | 1999-05-04 00:00:00
Spreadsheet: 837005d1689781892-insert-calculate-item-in-pivot-calculate-item-in-pivot2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | IF(AND(ISBLANK('Prev 6m'),'Current 6m'<>0),"New",IF(AND('Prev 6m'=0,'Current 6m'<>0),"New",IF(AND('Prev 6m'<>0,'Current 6m'<>0),"Existing",IF(AND('Prev 6m'<>0,'Current 6m'=0),"Existing",IF(AND('Prev 6m'<>0,ISBLANK('Current 6m')),"Existing","-")))))
Month-Year | Customer | Org | Dest | GP | Direction | Cust | Period |  | Sum of GP | Period
2022 - 07 | Cust1 | TH | DE | -50 |  |  | Prev 6m |  | Customer combined | Prev 6m | Current 6m | Criteria | Formula1 | Formula2
2022 - 08 | Cust2 | TH | DE | 0 |  |  | Prev 6m |  | Cust1 / MM-DE | -50 | -50 | #[NAME]! | #[NAME]! | 0
2022 - 09 | Cust3 | TH | DE | 200 |  |  | Prev 6m |  | Cust2 / MM-DE | 0 | 0 | #[NAME]! | #[NAME]! | 0
2022 - 10 | Cust4 | TH | DE | 300 |  |  | Prev 6m |  | Cust3 / MM-DE | 200 | 100 | #[NAME]! | #[NAME]! | 0
2022 - 11 | Cust5 | TH | DE | 0 |  |  | Prev 6m |  | Cust4 / MM-DE | 300 | 100 | #[NAME]! | #[NAME]! | 0
2022 - 12 | Cust6 | TH | DE | 200 |  |  | Prev 6m |  | Cust5 / MM-DE | 0 | -50 | #[NAME]! | #[NAME]! | 0
2023 - 01 | Cust1 | TH | DE | -50 |  |  | Current 6m |  | Cust6 / MM-DE | 200 | 300 | #[NAME]! | #[NAME]! | 0
2023 - 02 | Cust2 | TH | DE | 0 |  |  | Current 6m
2023 - 03 | Cust3 | TH | DE | 100 |  |  | Current 6m
2023 - 04 | Cust4 | TH | DE | 100 |  |  | Current 6m
2023 - 05 | Cust5 | TH | DE | -50 |  |  | Current 6m
2023 - 06 | Cust6 | TH | DE | 300 |  |  | Current 6m
Spreadsheet: 776459d1649749347-pulling-multiple-zip-codes-from-a-report-zip-code-test
Sheet: Sheet1

Platform | Issuer Subscriber ID | Member [NAME] | Relationship Code | Effective Date | Termination Date | Mailing Address 1 | Mailing Address 2 | Mailing Address City | Mailing Address State | Mailing Address Zip Code | Mailing Address Country | [NAME]
On Exchange | 1 | Member [NAME] | Subscriber | 01/01/2022 | 12/31/2022 | Number and Street | Apt # | City | State | 53189 | US | email address
On Exchange | 2 | Member [NAME] | Subscriber | 01/01/2022 | 12/31/2022 | #N/A |  | #N/A | #N/A | 53092 | US | email address
On Exchange | 3 | Member [NAME] | Subscriber | 01/01/2022 | 12/31/2022 | #N/A |  | #N/A | #N/A | 54220 | US | email address
On Exchange | 4 | Member [NAME] | Subscriber | 01/01/2023 | 12/31/2023 | #N/A |  | #N/A | #N/A | 54221 | US | email address
On Exchange | 5 | Member [NAME] | Subscriber | 01/01/2024 | 12/31/2024 | #N/A |  | #N/A | #N/A | 54222 | US | email address
On Exchange | 6 | Member [NAME] | Subscriber | 01/01/2025 | 12/31/2025 | #N/A |  | #N/A | #N/A | 54223 | US | email address
On Exchange | 7 | Member [NAME] | Subscriber | 01/01/2026 | 12/31/2026 | #N/A |  | #N/A | #N/A | 53189 | US | email address
On Exchange | 8 | Member [NAME] | Subscriber | 01/01/2027 | 12/31/2027 | #N/A |  | #N/A | #N/A | 53092 | US | email address
On Exchange | 9 | Member [NAME] | Subscriber | 01/01/2028 | 12/31/2028 | #N/A |  | #N/A | #N/A | 54226 | US | email address
On Exchange | 10 | Member [NAME] | Subscriber | 01/01/2029 | 12/31/2029 | #N/A |  | #N/A | #N/A | 54220 | US | email address
On Exchange | 11 | Member [NAME] | Subscriber | 01/01/2030 | 12/31/2030 | #N/A |  | #N/A | #N/A | 53189 | US | email address
On Exchange | 12 | Member [NAME] | Subscriber | 01/01/2031 | 12/31/2031 | #N/A |  | #N/A | #N/A | 53092 | US | email address
On Exchange | 13 | Member [NAME] | Subscriber | 01/01/2032 | 12/31/2032 | #N/A |  | #N/A | #N/A | 54220 | US | email address
On Exchange | 14 | Member [NAME] | Subscriber | 01/01/2033 | 12/31/2033 | #N/A |  | #N/A | #N/A | 54231 | US | email address
Spreadsheet: 690489d1597143404-min-function-is-including-blank-cells-and-failing-or-bonuscalcsent2
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
1 | t |  |  |  |  | 2 |  | 3 |  | 3 |  |  |  |  | 2 |  | 2
2 | 2 |  |  |  |  | 3 |  | 1 |  | 2 |  |  |  |  | 3 |  | 3
3 |  | 4 |  | F |  |  |  |  | 3 |  | 4 |  | 2 |  |  |  |  | - |  | AH2 should be 1, not zero
4 |  | - |  | 2 |  |  |  |  | 1 |  | - |  | 3 |  |  |  |  | 1 |  | but min(b$2:b$11) evaluates to 0, why?
5 |  |  | 2 |  | - |  | 2 |  |  |  |  | - |  | 2 |  | - |  |  |  | I thought min() ignored blanks!
6 |  |  |  |  | 2 |  | - |  |  |  |  | 2 |  | - |  | -
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
10 |  |  | 3 |  |  |  |  |  |  |  | 3
Spreadsheet: 390459d1429639443-returning-data-from-a-table-based-on-a-drop-down-selection-table-returns-from-drop-down-s-2
Sheet: Data

NAME
No. | Table 1 | Table 2 | Table 2 | Table 2 | Information | Table 3 | Information
 | Good | Good | Average | Poor |  | Poor
1
Spreadsheet: 875581d1722188877-how-to-make-index-work-after-drag-solved-test
Sheet: юли

№ | Name | 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
 |  | GREEN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PURPLE
Spreadsheet: 329845d1404419382-highlight-cell-if-match-649pool
Sheet: DRAWS

#1 | 2014-08-06 00:00:00 | 1 | 3 | 7 | 34 | 49 | 34
#2 | 2014-08-09 00:00:00 | 8 | 11 | 2 | 5 | 6 | 23
#3 | 2014-08-13 00:00:00 |  | `
#4 | 2014-08-16 00:00:00
#5 | 2014-08-20 00:00:00
#6 | 2014-08-23 00:00:00
#7 | 2014-08-27 00:00:00
#8 | 2014-08-30 00:00:00
#9 | 2014-09-03 00:00:00
#10 | 2014-09-06 00:00:00
#11 | 2014-09-10 00:00:00
#12 | 2014-09-13 00:00:00
#13 | 2014-09-17 00:00:00
#14 | 2014-09-20 00:00:00
Spreadsheet: 887252d1737495417-streamlining-data-collection-for-making-tables-and-charts-example
Sheet: Tables

PIVOT TABLE:
Sum of Distance | Column Labels
Row Labels | Location 1 | Location 10 | Location 11 | Location 12 | Location 13 | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Location 8 | Location 9 | Grand Total
Big Bus 1 |  |  |  |  |  |  |  |  |  | 112 |  |  | 12 | 124
Bus 1 |  |  |  |  |  |  | 36 |  | 23 |  |  |  |  | 59
Car 1 |  |  |  |  |  |  | 15 |  |  |  | 65 |  |  | 80
Car 2 | 20 |  | 60 |  |  | 21 | 36 |  |  |  |  |  |  | 137
Truck 2 |  | 23 | 24 |  |  |  |  | 14 |  |  |  |  |  | 61
Truck 3 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 15
Truck1 | 25 |  | 32 |  |  |  | 25 |  |  |  |  |  |  | 82
Van 1 |  |  |  |  |  |  |  |  | 93 |  | 10 |  |  | 103
Van 2 |  |  |  |  | 52 | 13 | 14 |  |  |  | 50 | 3 |  | 132
Grand Total | 45 | 23 | 116 | 15 | 52 | 34 | 126 | 14 | 116 | 112 | 125 | 3 | 12 | 793
Copy of Pivot table, I did this so I could use grand total in a chart
Row Labels | Location 1 | Location 10 | Location 11 | Location 12 | Location 13 | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Location 8 | Location 9 | Grand Total
Big Bus 1 |  |  |  |  |  |  |  |  |  | 112 |  |  | 12 | 124
Bus 1 |  |  |  |  |  |  | 36 |  | 23 |  |  |  |  | 59
Car 1 |  |  |  |  |  |  | 15 |  |  |  | 65 |  |  | 80
Car 2 | 20 |  | 60 |  |  | 21 | 36 |  |  |  |  |  |  | 137
Truck 2 |  | 23 | 24 |  |  |  |  | 14 |  |  |  |  |  | 61
Truck 3 |  |  |  | 15 |  |  |  |  |  |  |  |  |  | 15
Truck1 | 25 |  | 32 |  |  |  | 25 |  |  |  |  |  |  | 82
Van 1 |  |  |  |  |  |  |  |  | 93 |  | 10 |  |  | 103
Van 2 |  |  |  |  | 52 | 13 | 14 |  |  |  | 50 | 3 |  | 132
Grand Total | 45 | 23 | 116 | 15 | 52 | 34 | 126 | 14 | 116 | 112 | 125 | 3 | 12 | 793
Spreadsheet: 09fe767a-99ae-412f-8961-59f7d90095c2
Sheet: +70 XD Qualification

BWF World Senior Championships 2013
XD 70-Qualification
Badminton Tournament Planner - bwf.tournamentsoftware.com
XD 70 - Group A
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3
1 | 52415  52570 |  | ENG  ENG |  | [NAME] [1]  [NAME] |  | R2 | R3
2 | 71452  55672 |  | GER  GER |  | Georg Schonfeld  [NAME] | R2 |  | R1
3 | 76364  52557 |  | RUS  RUS |  | [NAME]  Galina Valeeva | R3 | R1
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | [NAME] [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | Georg Schonfeld [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] Galina Valeeva | 0 | 0 | 0 | - | 0 | 0 | - | 0
XD 70 - Group B
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3
1 | 52443  52545 |  | GER  GER |  | [NAME] [2]  Renate Gabriel |  | R2 | R3
2 | 92672  60399 |  | RUS  RUS |  | [NAME]  [NAME] | R2 |  | R1
3 | 75905  88603 |  | ENG  ENG |  | [NAME]  [NAME] | R3 | R1
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | [NAME] [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
XD 70 - Group C
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3
1 | 97940  77966 |  | DEN  NOR |  | [NAME][NAME] |  | R2 | R3
2 | 52422  52537 |  | ENG  ENG |  | [NAME][NAME] | R2 |  | R1
3 | 96573  69069 |  | GER  GER |  | [NAME] | R3 | R1
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | [NAME][NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME][NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
XD 70 - Group D
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3
1 | 52397  52562 |  | DEN  DEN |  | [NAME]  [NAME] |  | R2 | R3
2 | 75682  83356 |  | CAN  CAN |  | [NAME][NAME] | R2 |  | R1
3 | 94365  66553 |  | GER  GER |  | [NAME]  [NAME] | R3 | R1
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | [NAME] [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME][NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0