tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 70469d1271205062-percentage-of-pass-fails-725104-percentage-of-pass-fails
Sheet: Sheet3

 |  |  |  |  | Pass | 46
 |  |  |  |  | Total | 47
 | test case | expected result | tester | build | result | bugs
Initial Association |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
Information update after sync |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
Accessing Screen |  |  | Dusty | 1.379 | Pass
 |  |  | Dusty | 1.379 | Pass
 |  |  | Scott | 1.379 | Pass
 |  |  | Scott | 1.379 | Pass
No transfer of assets |  |  | Dusty | 1.2.0.13431 | Pass
 |  |  | Scott | 1.2.0.13431 | Pass
 |  |  | Dusty | 1.2.0.13431 | Pass
Firmware Update
 |  |  | Dusty | 1.2.0.13402 | Pass
Missing files on the device |  |  | Scott | 1.379 | Pass
 |  |  | Dusty | 1.379 | Pass
Premature disconnects |  |  | Dusty | 1.379 | Pass
 |  |  | Scott |  | Pass
 |  |  | Scott |  | Pass
Uploads |  |  | Scott |  | Fail | 6345
 |  |  | Scott |  | Pass
 |  |  | Scott |  | Pass
 |  |  | Scott |  | Pass
 |  |  | Scott |  | Pass
 |  |  | Dusty |  | Pass
 |  |  | Scott |  | Pass
Transfer |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
 |  |  | Dusty | 1.2.0.13427 | Pass
Spreadsheet: 776599d1649817238-power-query-list-sheet-names-of-original-data-pq-from-sheets-keeping-names
Sheet: PQ Conditional Column SheetName

Sheet | Code | Description
1 | 001 | Bone
1 | 002 | dumb dumb
1 | 003 | butterfly
1 | 004 | leaf
1 | 005 | trash
2 | 006 | Apple
2 | 007 | Orange
2 | 008 | Lemon
2 | 009 | Lime
2 | 010 | [NAME]
2 | 011 | Chive
3 | 012 | Honey
3 | 013 | Onion
3 | 014 | Glucose
3 | 015 | Fructose
3 | 016 | lactose
3 | 017 | galactose
4 | 018 | Test
Spreadsheet: 144791d1331138249-can-you-find-certain-text-in-a-cell-find-whole-word-only
Sheet: Sheet1

Find > | Club | or | SEARCH() | or | SEARCH() | Compare with > | FIND()
Arsenal Football Club | Match Found |  | Match Found |  | Match Found
Leeds united
[NAME] | Match Found |  | Match Found |  | Match Found
[NAME]
Arsenal Football club | Match Found |  | Match Found |  | Match Found |  | club
Golf clubhouse |  |  |  |  |  |  | club
Spreadsheet: 99524d1298137482-counting-with-several-condition-list
Sheet: Sheet1

name | color | course | Date |  |  |  | learner | intermediate | advanced
a | red | learner | 2008-03-11 00:00:00 |  |  | red | 1
b | white | learner | 2008-03-07 00:00:00 |  |  | white
c | blue | intermediate | 2009-11-19 00:00:00 |  |  | blue
d | green | learner | 2009-11-20 00:00:00 |  |  | green
e | red | intermediate | 2011-03-12 00:00:00
f | red | learner
g | white | intermediate | 2009-02-11 00:00:00
h | blue | advanced
Spreadsheet: 762067d1641384351-need-help-with-attendance-formula-in-an-excel-template-e11-attdendance-2022-2-
Sheet: List of Employees

 | List of Employees
 | Employee Names
 | [NAME]
 | Bryana Buchheit
 | [NAME]
 | [NAME]
 | Kayla Vondera
 | [NAME]
 | [NAME]
 | [NAME]
 | Madison Meyer
 | Mechelle Enloe
 | Moriah Dickerhoof
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 128693d1321218067-display-named-range-show-contents-of-range
Sheet: Sheet1

martin3 |  | a |  |  |  |  |  |  |  | q | a | a |  | martin1
 |  | b |  |  |  |  |  |  |  | w | s | b |  | [NAME]
 |  | c |  |  |  |  |  |  |  | e | d | c |  | martin3
 |  | d |  |  |  |  |  |  |  | r | f | d
 |  | e |  | named ranges |  |  |  |  |  | t | g | e
 |  | f |  | martin1 |  |  |  |  |  | y | h | f
 |  | g |  | [NAME] |  |  |  |  |  |  |  | g
 |  | h |  | martin3 |  |  |  |  |  |  |  | h
 |  | i |  |  |  |  |  |  |  |  |  | i
 |  | j |  |  |  |  |  |  |  |  |  | j
 |  | k |  |  |  |  |  |  |  |  |  | k
 |  | l |  |  |  |  |  |  |  |  |  | l
 |  | m |  |  |  |  |  |  |  |  |  | m
Spreadsheet: 766216d1643806172-unsure-that-the-formulas-being-used-are-accurate-book1
Sheet: Sheet1

Team Members | Assignment | Total Work Days | Days Out | Audit Days | MTD Audits | Audits Per Day | MTD Average Sec Per Call | MTD Average Min Per Call | Hours | Difference  ([NAME].) | Hrs | CPH | OT | On Prod Adjust | Capacity | Training | PTO DATES | Team Members |  | % of Audit Capacity |  | Barrier Time Unknown |  | Off Production |  | On Production
Employee 1 | Internal QPC | 20 | 0 | 13 | 152 |  | 501 |  |  |  |  | 3.5 | 0 | 0.85 |  |  |  | Employee 1
Spreadsheet: 53095d1253022466-look-up-numbers-in-spreadsheet-from-60-days-ago-699536-look-up-numbers-in-spreadsheet-from-60-days-ago
Sheet: Sheet1

Enter Days "Ago" | 60
Date to Find
Lookup result
Date | Header1
2009-05-01 00:00:00 | Val_1
2009-05-02 00:00:00 | Val_2
2009-05-03 00:00:00 | Val_3
2009-05-04 00:00:00 | Val_4
2009-05-05 00:00:00 | Val_5
2009-05-06 00:00:00 | Val_6
2009-05-07 00:00:00 | Val_7
2009-05-08 00:00:00 | Val_8
2009-05-09 00:00:00 | Val_9
2009-05-10 00:00:00 | Val_10
2009-05-11 00:00:00 | Val_11
2009-05-12 00:00:00 | Val_12
2009-05-13 00:00:00 | Val_13
2009-05-14 00:00:00 | Val_14
2009-05-15 00:00:00 | Val_15
2009-05-16 00:00:00 | Val_16
2009-05-17 00:00:00 | Val_17
2009-05-18 00:00:00 | Val_18
2009-05-19 00:00:00 | Val_19
2009-05-20 00:00:00 | Val_20
2009-05-21 00:00:00 | Val_21
2009-05-22 00:00:00 | Val_22
2009-05-23 00:00:00 | Val_23
2009-05-24 00:00:00 | Val_24
2009-05-25 00:00:00 | Val_25
2009-05-26 00:00:00 | Val_26
2009-05-27 00:00:00 | Val_27
2009-05-28 00:00:00 | Val_28
2009-05-29 00:00:00 | Val_29
2009-05-30 00:00:00 | Val_30
2009-05-31 00:00:00 | Val_31
2009-06-01 00:00:00 | Val_32
2009-06-02 00:00:00 | Val_33
2009-06-03 00:00:00 | [NAME]
2009-06-04 00:00:00 | Val_35
2009-06-05 00:00:00 | Val_36
2009-06-06 00:00:00 | Val_37
2009-06-07 00:00:00 | Val_38
2009-06-08 00:00:00 | Val_39
2009-06-09 00:00:00 | Val_40
2009-06-10 00:00:00 | Val_41
2009-06-11 00:00:00 | Val_42
2009-06-12 00:00:00 | Val_43
2009-06-13 00:00:00 | Val_44
2009-06-14 00:00:00 | Val_45
2009-06-15 00:00:00 | Val_46
2009-06-16 00:00:00 | Val_47
2009-06-17 00:00:00 | Val_48
2009-06-18 00:00:00 | Val_49
2009-06-19 00:00:00 | Val_50
2009-06-20 00:00:00 | Val_51
2009-06-21 00:00:00 | Val_52
2009-06-22 00:00:00 | Val_53
2009-06-23 00:00:00 | Val_54
2009-06-24 00:00:00 | Val_55
2009-06-25 00:00:00 | Val_56
2009-06-26 00:00:00 | Val_57
2009-06-27 00:00:00 | Val_58
2009-06-28 00:00:00 | Val_59
2009-06-29 00:00:00 | Val_60
2009-06-30 00:00:00 | Val_61
2009-07-01 00:00:00 | Val_62
2009-07-02 00:00:00 | Val_63
2009-07-03 00:00:00 | Val_64
2009-07-04 00:00:00 | Val_65
2009-07-05 00:00:00 | Val_66
2009-07-06 00:00:00 | Val_67
2009-07-07 00:00:00 | Val_68
2009-07-08 00:00:00 | Val_69
2009-07-09 00:00:00 | Val_70
2009-07-10 00:00:00 | Val_71
2009-07-11 00:00:00 | Val_72
2009-07-12 00:00:00 | Val_73
2009-07-13 00:00:00 | Val_74
2009-07-14 00:00:00 | Val_75
2009-07-15 00:00:00 | Val_76
2009-07-16 00:00:00 | Val_77
2009-07-17 00:00:00 | Val_78
2009-07-18 00:00:00 | Val_79
2009-07-19 00:00:00 | Val_80
2009-07-20 00:00:00 | Val_81
2009-07-21 00:00:00 | Val_82
2009-07-22 00:00:00 | Val_83
2009-07-23 00:00:00 | Val_84
2009-07-24 00:00:00 | Val_85
2009-07-25 00:00:00 | Val_86
2009-07-26 00:00:00 | Val_87
2009-07-27 00:00:00 | Val_88
2009-07-28 00:00:00 | Val_89
2009-07-29 00:00:00 | Val_90
2009-07-30 00:00:00 | Val_91
2009-07-31 00:00:00 | Val_92
2009-08-01 00:00:00 | Val_93
2009-08-02 00:00:00 | Val_94
2009-08-03 00:00:00 | Val_95
2009-08-04 00:00:00 | Val_96
2009-08-05 00:00:00 | Val_97
2009-08-06 00:00:00 | Val_98
2009-08-07 00:00:00 | Val_99
Spreadsheet: 810174d1671586218-simple-count-of-coloured-cells-in-a-column-test-example-to-count-cell-colour
Sheet: Sheet1

95 |  | 88
Spreadsheet: 0f6eb301-8b87-48fe-a5be-7c5a67cbbfe4
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
FHV6D | Test | FHV6D | Herpes Virus-6 DNA, Quantitative Real-Time PCR | Herpes Virus 6 DNA, [NAME] | Real Time PCR |  |  |  |  |  | Submit only one of the following:   Whole Blood: Collect 1 mL (lavender-top) EDTA or (yellow-top) ACD whole blood. Ship refrigerate.    Serum: Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Separate immediately and submit 1 mL serum refrigerate in a plastic vial.    Plasma: Draw blood in a (lavender-top) EDTA or (yellow-top) ACD tube(s). ([NAME] tube is acceptable.) Separate immediately and submit 1 mL plasma refrigerate in a plastic vial.    CSF: Collect 1 mL of spinal fluid (CSF) is sterile leak proof container. Ship refrigerate in a plastic vial.    Bronchoalveolar Lavage: Collect 1 mL in sterile leak proof container. Ship refrigerate in a plastic vial.    Bone Marrow: Collect 1 mL bone marrow in a (lavender-top) EDTA or (yellow-top) ACD tube. Ship refrigerate. | 0.3 mL | Hemolysis:	NA Thawing:	Warm reject; Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <500 copies/mL | Monday through Sunday | 1 - 3 days | 3 - 5 days | 1 | 87533 |  |  |  |  | Focus Diagnositics, Inc.
FHV6D | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FHV6D | Order Question | Z2995 | Source |  | Plain Text
FHV6D | Result | Z2995 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHV6D | Result | Z2996 | Herpes Virus 6 DNA, QN PCR | Herpes Virus 6 DNA, QN PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Harris, David

[NAME], [NAME]
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 795510d1662730149-identifying-a-red-flag-based-on-2-criteria-flag
Sheet: Sheet1

ID | Date Time | Search Type | Expected
1234567891 | 2022-07-11 14:50:49 | Advanced
1234567891 | 2022-07-11 14:50:49 | Medium
1234567891 | 2022-07-11 14:50:49 | Simple
1234567891 | 2022-07-11 14:50:49 | Advanced
9876543212 | 2022-07-11 15:06:00 | Advanced | Red Flag
8765432123 | 2022-07-11 15:06:00 | Advanced | Red Flag
7654321234 | 2022-07-11 15:06:00 | Advanced | Red Flag
6543212345 | 2022-07-11 15:06:00 | Advanced | Red Flag
5432123456 | 2022-07-11 15:06:00 | Advanced | Red Flag
4321234567 | 2022-07-11 15:06:00 | Advanced | Red Flag
3212345678 | 2022-07-11 15:06:00 | Advanced | Red Flag
2123456789 | 2022-07-11 15:06:00 | Advanced | Red Flag
1562345864 | 2022-07-11 15:06:00 | Advanced | Red Flag
9123642851 | 2022-07-11 15:06:00 | Advanced | Red Flag
1199884572 | 2022-07-11 15:06:00 | Advanced | Red Flag
5566892494 | 2022-07-11 15:06:00 | Advanced | Red Flag
9999999743 | 2022-07-11 15:11:09 | Advanced
9999999743 | 2022-07-11 15:11:38 | Simple
9999999743 | 2022-07-11 15:11:55 | Advanced
6677889911 | 2022-07-11 15:11:55 | Advanced
Spreadsheet: 38511d1236686098-multi-conditional-average-example8
Sheet: 10 Mar09

Type | Item # | Lead Time | Result
Bag | D7530 | 19 | On Time
Sack | AUV0002VW | 6 | On Time
Sack | AUV0002VW | 9 | On Time
Sack | TRW0001VP-T | 0 | On Time
Sack | TRW0001VP | 0 | On Time
Sack | AUV0003VW | 37 | On Time
Bag | ADB0016VF | 0 | On Time
Sack | RIV0008VF | -4 | Late
Sack | WST0014VF | -32 | Late
Sack | ADB0017VF | -33 | Late
Bag | FUR0002VS | 59 | On Time
Sack | FUR0003VS | 4 | On Time
Sack | FUR0003VS-U | 13 | On Time
Sack | REA0001OM | 0 | On Time
Bag | [NAME] | 8 | On Time
Bag | LAU0008OM | -3 | Late
Bag | MIN0003VF | -10 | Late
Bag | MIN0005VF | -7 | Late
Bag | RIV0002VF | 0 | On Time
Sack | MUD0022VF | -23 | Late
Sack | RIV0045VF | -1 | Late
Sack | WST0015VF | -14 | Late
Sack | RIV0046VF | 0 | On Time
Bag | RIV0009VF | 19 | On Time
Spreadsheet: 799546d1665138179-countifs-with-multiple-criteria-using-cell-reference-test
Sheet: Sheet1

id | unit 502
1 | Pass |  |  |  | Pass |  | Pass
2 | submitted |  |  |  | Submitted |  | Submitted
3 | pass |  |  |  | Refer
4 | pass |  |  |  | Re-Refer |  | Re-Refer
5 | resit pass |  |  |  | Resit Pass
6 | resit pass
7 | pass
8 | pass
9 | pass |  |  |  |  |  | Resit Pass
10 | not submitted
11 | not submitted |  |  |  |  |  | Refer
should return 7, cell reference are in a cont. [NAME]
should return7, Cell references are scattered
I just want to know how to write a formula when criteria is cell referance.
Spreadsheet: 713594d1610819243-translating-multiple-column-index-to-other-work-sheets-film-tester-1-
Sheet: Info

Total Number of Films
Total Film Time
Average Film Length
Longest Film
Shortest Film
Average Year
Oldest Film
Newest Film
Total Oscars
Total Oscar Nominations
Passed Bechdel Test
Based On A True Story
Most Seen Director
Most Seen Actor
Most [NAME]
Best Director by Ave Score
Dest Actor by Ave Score
[NAME] by Ave Score
Best Director (10 Film Min)
Best Actor (10 Film Min)
[NAME] (10 Film Min)
Best Film
Worst Film
Spreadsheet: 811072d1672256644-lookup-multiple-criteria-to-return-value-without-sumif-or-sumproduct-lookup-formula
Sheet: Sheet1

Item | Month | Region | Value |  |  |  |  |  | Data | Item | Month | Region | Value
Apple | December | Chicago |  | I need formula here to show value is $2.5 |  |  |  |  |  | Grapes | December |  | 4
 |  |  |  | Sumif & Sumproduct will give me $5 |  |  |  |  |  | Oranges | October |  | 3
 |  |  |  |  |  |  |  |  |  | Apple | November | Miami | 2
 |  |  |  |  |  |  |  |  |  | Apple | December | Chicago | 2.5
 |  |  |  |  |  |  |  |  |  | Mangoes | September |  | 4
 |  |  |  |  |  |  |  |  |  | Apple | December | Chicago | 2.5
 |  |  |  |  |  |  |  |  |  | Oranges | October |  | 2.5
 |  |  |  |  |  |  |  |  |  | Mangoes | November |  | 4
Spreadsheet: 9095a2ee-a187-4de8-b390-063e49cdfbc0
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
FA1GP | Test | FA1GP | Alpha-1-Acid Glycoprotein | Alpha-1-Acid Glycoprotein | Fixed Rate Time Nephelometry | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain red-top tube(s). Spin down and send 1 mL of serum refrigerated in a plastic vial.  Note:  Overnight fasting is preferred. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Received room temperature | Adults:    39-115    mg/dL   Test Performed by: Quest Diagnostic Nichols Institute                              33608 [NAME]San Juan Capistrano, CA 92690-6130 | Monday, Thursday | 2 - 6 days | 4 - 10 days | 1 | 82985 |  |  |  |  | Quest Diagnostics/Nichols Institute
FA1GP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
FA1GP | Result | FA1GP | Alpha-1-Acid Glycoprotein | Alpha-1-Acid Glycoprotein | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2685-6 | Alpha-1-Acid glycoprotein:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 272650d1382453538-create-one-large-formula-by-combining-text-from-several-cells-concatenation-formulas-building-formulas-for-mamero
Sheet: Sheet1

Part 1 | Part2 | Part3 | Pull it Together
Spreadsheet: 882188d1730449370-score-card-for-tipster-prediction-score-card-for-tipsters-predictions-october-2024-race-track
Sheet: Sheet2

Race 1 | A | F | P | T | D | S | J | T | R | S | O |  | TIP1 | TIP2 | TIP3 | TIP4 | TIP5 | TIP6 | TIP7 | TIP8 | TIP9 | TIP10 | TIP11 | Predition Scoring Table | PTS |  | Horse No | Top Score | ODDS
1st | 10 | 10 | 10 | 6 | 6 | 6 | 10 | 11 | 11 | 2 | 10 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 |  | 1 |  | 4
2nd | 5 | 6 | 5 | 10 | 5 | 10 | 3 | 10 | 10 | 7 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 |  | 2 |  | 16
3rd | 6 | 5 | 3 | 2 | 4 | 7 | 9 | 5 | 5 | 3 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 |  | 3 |  | 12.5
4th | 2 | 2 | 7 | 7 | 3 | 2 | 11 | 6 | 6 | 4 | 11 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2 |  | 4 |  | 5
5th | 1 | 7 | 6 | 3 | 2 | 3 | 2 | 1 | 1 | 9 | 9 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1 |  | 5 |  | 0.8
6th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0 |  | 6 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
Race 2 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 3 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 4 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 5 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 6 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 7 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 8 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 9 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Race 10 | A | F | P | T | D | S | J | T | R | S | O
1st
2nd
3rd
4th
5th
6th
Spreadsheet: 763565d1642247119-search-multiple-criteria-and-return-multiple-values-within-the-same-cell-schedule-test-copy-gk
Sheet: test

 |  |  |  | E | E |  |  | E | E | E |  |  |  | E | E | E |  |  |  |  | E |  |  | EE |  |  |  |  |  | E |  |  |  |  |  | E
DAY | MONTH  / YR | D A T E |  | BASE -  CONCRETE SLAB / STEEL CHASSIS | ROOF FRAME / WALL FRAMES/ PANELS | WINDOWS | BI-FOLD / SPECIAL DOORS | COMPRESSED SHEETING/ NON STOCK -FLOOR BOARDS | ROOFING  & FLASHING | STRUCTUAL STEEL- PURLINS , COLUMNS , PITCHING PLATE ETC. | EXT. DOOR FRAMES & CAVITY SLIDERS - KIT | MIXER TAPS | Fire systems | MECHANICAL /AIRCON( std aircon is on separate line) | Std- aircon -Excl. Mechanical works | CLADDING / WALL SHEETING | NON-STOCK PLASTERBOARD & INSULATION | EXT. [NAME] | INTERNAL DOORS | CABINETS & LAMINATE BENCHTOP | STONE BENCHTOPS | GLASS / SS / SPECIAL SPLASHBACK | [NAME] | PLUMBING - 2ND FIX | WHITEGOODS   (OVEN, CKT & RNGHD) | CATERING EQUIPMENT & BENCHES | FURNITURE/WHITE BOARDS / PIN BOARDS/ SIGNAGE | LIGHTING | ROBES/Shelving | SHOWER / MIRRORS | FLOOR COVERING | WINDOW TREATMENT | FLY DOOR/ SECURITY DOORS / SCREENS | COOLROOM | ELECTRICAL LABOUR | PLUMBING LABOUR | Carpentry labour | Gyprock labour | reveals & DP | 2nd fix labour | Painting labour | Tiling labour
 |  |  |  | 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
 | 2021-01-25 00:00:00
 | 2021-01-26 00:00:00
 | 2021-01-27 00:00:00
 | 2021-01-28 00:00:00
 | 2021-01-29 00:00:00
 | 2021-01-30 00:00:00
 | 2021-01-31 00:00:00
 | 2021-02-01 00:00:00
 | 2021-02-02 00:00:00
 | 2021-02-03 00:00:00
 | 2021-02-04 00:00:00
 | 2021-02-05 00:00:00
 | 2021-02-06 00:00:00
 | 2021-02-07 00:00:00
 | 2021-02-08 00:00:00
 | 2021-02-09 00:00:00
 | 2021-02-10 00:00:00
Spreadsheet: 184231d1349191228-self-expanding-refreshing-ranges-book2
Sheet: Sheet1

Names | TV Shows
[NAME] | Breaking Bad |  |  |  | Breaking Bad | [NAME] | American Idol | Mad Men | The Office | [NAME] and Recreation | Law and Order | [NAME] | X Factor
[NAME] | [NAME] |  |  | [NAME]
Sophie | American Idol |  |  | [NAME]
[NAME] | Mad Men |  |  | Sophie
[NAME] | The Office |  |  | [NAME]
[NAME] | [NAME] and Recreation |  |  | [NAME]
[NAME] | Law and Order |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | X Factor
Spreadsheet: 695407d1600193072-if-false-ignore-and-skip-to-next-row-sample_anon_data
Sheet: Sheet2

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9
9T | [NAME] | Faith | F | 9AB | Monitored | 116 | A | 5/6
9T | Cox | [NAME] | F | 9CD | Active | 101.898 | B | 4
9T | [NAME] | [NAME] | M | 9DE | Active | 110.1756 | A | 5
Spreadsheet: 852f19ca-f36f-4246-8220-97876ed0f9e6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-05-21 09:46:30.850000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.811 | 102.686 | 102.561 | 102.186
4.5 | 102.674 | 102.549 | 102.424 | 102.049 |  | Note: | Refer To Price [NAME]
4.375 | 102.043 | 101.918 | 101.793 | 101.418 |  |  | For all Price Adjs
4.25 | 101.45 | 101.325 | 101.2 | 100.575
4.125 | 100.613 | 100.488 | 100.363 | 99.738
4 | 99.612 | 99.487 | 99.362 | 98.737
3.875 | 98.568 | 98.443 | 98.318 | 97.693
3.75 | 97.693 | 97.568 | 97.443 | 96.818
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.875 | 102.75 | 102.625 | 102.25
3.75 | 102.809 | 102.684 | 102.559 | 102.184
3.625 | 102.424 | 102.299 | 102.174 | 101.799
3.5 | 101.88 | 101.755 | 101.63 | 101.255
3.375 | 101.16 | 101.035 | 100.91 | 100.285
3.25 | 100.415 | 100.29 | 100.165 | 99.54
3.125 | 99.93 | 99.805 | 99.68 | 99.055 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-04 09:46:30.850000
30 DAY | 2014-06-19 09:46:30.850000
45 DAY | 2014-07-04 09:46:30.850000
60 DAY | 2014-07-19 09:46:30.850000
90 DAY | 2014-08-18 09:46:30.850000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.