tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7359__saledoc01_17TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-01-24 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/25/02 |  |  | FAX Number:
Total Quantity |  |  | 10000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/25/02 | 2002-01-25 00:00:00 | 10000 |  | 10000 |  | 10000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 10000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 789705d1659300900-dynamic-charts-based-on-date-range-samplesheet
Sheet: Charts

Date from |  |  | Date to
Month: | 5 |  | Month: | 3
Year: | 2019 |  | Year: | 2020
#1 chart - revenue per months
Simple visualization of revenue throughout time. X = time, Y = revenue
Y
 |  |  | X
#2 chart - expenses per months
Visualization of expenses that are ticked (included) below. X= time, Y= costs per category
Include:
 |  |  | Y
 |  |  |  |  |  | X
#3 pie chart - expenses vs revenue
Visualization of the shares of expenses
 | USD | Percent
Total revenue: | [NAME]
Revenue after expenses: | YYY
Expenses: | Expenses cost (USD) | Share (percent)
Software
--- Backend
--- Frontend
Servers
- Support
- Account
- Sales
--- Outbound
Tools
--- Support
--- CRM
--- Voice
Analytics
--- Workflow
--- Google Cloud
other
accounting
office
- Marketing
--- Offline
--- Online
--- PR
--- Content
- HR
Spreadsheet: 771841d1646869975-sumproduct-with-multiple-match-multiple-or-criteria-challenge
Sheet: Sheet1

 | Item | Color | City |  |  | Item | Color | City
 | Tshirt | Red | Seattle | 4 |  | Tshirt | Red | Denver
 | Sandals | Gray | Portland | 5 |  | Hoodie | Blue | Seattle
 | Hat | Blue | Denver | 6 |  |  | Green | Bend
 | Hoodie | Blue | Bend | 2
 | Tshirt | Blue | Bend | 5
 | Sandals | Black | Portland | 6
 | Tshirt | Blue | Denver | 3
 | Hoodie | Gray | Portland | 2 |  | Row count |  | Row Sum
 | Sandals | Gray | Seattle | 35 |  |  |  | 14 | <- need formula for this help here
 | Tshirt | Gray | Seattle | 7
 | Sandals | Black | Portland | 5
 | Hoodie | Green | Portland | 7
 | Hat | Black | Portland | 6
 | Sandals | Gray | Seattle | 3
Spreadsheet: 487630d1478175817-formula-that-will-choose-between-two-worksheets-databook-after
Sheet: Summary

 |  | [NAME] | Apples | Carrots | Beans
 |  | New York |  |  | 7
 |  | Boston |  | 4.1 |  |  | Numbers update with [NAME]'s changes
 |  | Miami
 |  | Dallas |  | 1.5
Spreadsheet: 854072d1704037487-how-to-calculate-amount-for-each-working-day-excel-forum
Sheet: Sheet1

2023-12-28 00:00:00 |  | 20 banking days |  | Forecast | Monthly Actual | Daily Actual ÷ 19
Total | 2111588.44 | ÷ 20 |  | 103K | 106K | 111K
TP | 436834.74 | ÷ 20 |  | 23K | 22K | 23K
SITE | 1066710.22 | ÷ 20 |  | 50K | 53K | 56K
DOD | 608043.48 | ÷ 20 |  | 30K | 30K | 32K
Spreadsheet: monika_causholli__28284__DT 2002
Sheet: Quarterly Breakdown

 | 2002 DOWNTIMES - QUARTERLY BREAKDOWN
 |  | Start-Up Date |  | Company |  | [NAME] |  | mtons (000s) |  | % of NA Capacity |  | Comments
 | TEMPORARY
 | 1st Quarter
 |  | 1Q |  | Abitibi-Consolidated |  | Sheldon, TX |  | 39 |  |  |  | will restart when the market improves
 |  | 1Q |  | [NAME] |  | Port Alberni, Elk Falls & Crofton |  | 46 |  | 0.002463520939927989 |  | will restart when the market improves
 | 2nd Quarter
 |  | 2Q |  | Abitibi-Consolidated |  | Sheldon, TX |  | 39 |  | 0.002463520939927989 |  | will restart when the mrket improves
 | 3rd Quarter
 | 4th Quarter
 | TOTAL
 | PERMANENT
 | 1H02
 | TOTAL
 | 2H02
 |  | mid-2002 |  | Bowater |  | N/A |  | 125 |  |  |  | Related to Nu-Way project
 |  | 2002-2004 |  | Bowater |  | Catawba, SC |  | 235 |  |  |  | Conversion to LWC
 | TOTAL
Spreadsheet: 696621d1600923662-how-to-efficiently-manage-trapping-value-and-n-a-errors-example-level-1-10-country-carnival-and-level-6-10-state-challenge-7th-and-8th-november-202
Sheet: Floor

Level 1 - 10 - Country Carnival & Level 6-10 State Challenge - 7th & 8th November 2020 Session 1 Gymnastics Club ABC & Gymnastics Club [NAME] |  |  |  |  |  |  |  |  |  |  | Please select one gymnast for the Superhero Artistic Floor Novelty Award | Please select one gymnast considered for the Sportmanship Novelty Award | Please select one gymnast considered for the Superhero Costume Novelty Award | Award Bagged
Club | Comp Number | First Name | Last Name | Level | Judge 1 | Judge 2 | Scratch | Average | Score | [NAME] | Superhero Artistic Floor | Sportmanship | Superhero Costume
ABC | 1111 | Gymnast | One | 3 | 0.2 | 0 |  |  |  |  |  |  |  | Yes
ABC | 2222 | Gymnast | Two | 4 |  |  | Scratch
ABC | 3333 | Gymnast | Three | 5
XYZ | 9999 | Gymnast | One | 3 | 1 | 0.5
XYZ | 8888 | Gymnast | Two | 3
XYZ | 7777 | Gymnast | Three | 4
XYZ | 6666 | Gymnast | Four | 4
XYZ | 5555 | Gymnast | Five | 5
XYZ | 4444 | Gymnast | Six | 5
Spreadsheet: 636604d1565375671-help-calendar-correction-employee-absence-schedule-current-6-5-19
Sheet: February

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | February | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee 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 |  |  |  | Vacation Days Taken/Year | Vacation  Days Taken/Month | Days Picked Up/Month | Sick Days/Month
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s |  |  |  |  |  |  | v |  |  |  |  | s | s
 | Lynda
 | [NAME]
 | Heather |  |  |  |  |  |  | v | v
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | p | p
 | Emili |  |  |  |  |  | v | p | p |  |  |  | s | s | s |  |  |  |  |  |  |  | p
 | Amber |  |  |  |  |  | p |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v
 | Meredith
 | Julie |  |  |  |  | s | s | v
Spreadsheet: 870577d1717070872-arrange-values-associated-with-xy-coordinates-in-a-serpentine-fashion-desiredarrangement
Sheet: Sheet1

Order | Value | Y coordinate | X coordinate
1001 | 1 | 1 | 31
1002 | 2 | 1 | 33
1003 | 3 | 1 | 35
1004 | 4 | 1 | 37
1005 | 5 | 1 | 39
1006 | 6 | 2 | 39
1007 | 7 | 2 | 37
1008 | 8 | 2 | 35
1009 | 9 | 2 | 33
1010 | 10 | 2 | 31
1011 | 11 | 3 | 31
1012 | 12 | 3 | 33
1013 | 13 | 3 | 35
1014 | 14 | 3 | 37
1015 | 15 | 3 | 39
1016 | 16 | 4 | 39
1017 | 17 | 4 | 37
1018 | 18 | 4 | 35
1019 | 19 | 4 | 33
1020 | 20 | 4 | 31
1021 | 21 | 5 | 31
1022 | 22 | 5 | 33
1023 | 23 | 5 | 35
1024 | 24 | 5 | 37
1025 | 25 | 5 | 39
1026 | 26 | 6 | 39
1027 | 27 | 6 | 37
1028 | 28 | 6 | 35
1029 | 29 | 6 | 33
1030 | 30 | 6 | 31
1031 | 31 | 7 | 31
1032 | 32 | 7 | 33
1033 | 33 | 7 | 35
1034 | 34 | 7 | 37
1035 | 35 | 7 | 39
1036 | 36 | 8 | 39
1037 | 37 | 8 | 37
1038 | 38 | 8 | 35
1039 | 39 | 8 | 33
1040 | 40 | 8 | 31
1041 | 41 | 9 | 31
1042 | 42 | 9 | 33
1043 | 43 | 9 | 35
1044 | 44 | 9 | 37
1045 | 45 | 9 | 39
1046 | 46 | 10 | 39
1047 | 47 | 10 | 37
1048 | 48 | 10 | 35
1049 | 49 | 10 | 33
1050 | 31 | 10 | 32
1051 | 30 | 10 | 31
Spreadsheet: 858313d1707045954-combined-two-operations-result-in-one-summary-sheet-shipment_receipt_report-aligw
Sheet: Dec 2024

 | Sr. No | Offloading Date | BL# / AWB# | Container # | Type | Inv# | Supplier | WH | Unloaded by | Cost
Spreadsheet: 031f27e3-6774-4f78-ad42-98ed648071ac
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In U.S. Dollars and Futures Equivalent Contracts
 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00 | 2011-02-28 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 2.1 | -0.8 | 1.3 | 57 | -21 | 36
Coffee | 7.2 | -2.5 | 4.7 | 71 | -25 | 46
Copper | 11.3 | -3.1 | 8.2 | 100 | -28 | 73
Corn | 23.4 | -7.9 | 15.6 | 661 | -219 | 443
Cotton | 8.9 | -3.4 | 5.6 | 98 | -36 | 62
[NAME] | 0.9 | -0.3 | 0.6 | 14 | -4 | 10
Gold | 21.3 | -4.7 | 16.7 | 151 | -33 | 118
Heating Oil | 11.6 | -2.2 | 9.4 | 93 | -18 | 76
[NAME] | 5 | -1.3 | 3.7 | 138 | -37 | 100
Live Cattle | 8.7 | -2.4 | 6.3 | 191 | -53 | 137
Natural Gas | 20.7 | -4.2 | 16.5 | 499 | -103 | 396
Platinum | 0.7 | -0.1 | 0.5 | 7 | -2 | 6
RBOB Unleaded Gas | 11.6 | -2.1 | 9.5 | 96 | -17 | 79
Silver | 7.4 | -1.6 | 5.8 | 44 | -10 | 34
Soybean Meal | 0.9 | -0.2 | 0.7 | 24 | -5 | 19
Soybean Oil | 5 | -1.5 | 3.5 | 145 | -45 | 101
Soybeans | 19 | -6.1 | 12.9 | 279 | -90 | 189
Sugar | 11.3 | -3.6 | 7.6 | 351 | -110 | 241
Wheat (CBOT) | 15.2 | -6.6 | 8.6 | 366 | -161 | 206
Wheat (KCBT) | 2.2 | -0.9 | 1.4 | 49 | -19 | 30
WTI Crude Oil | 66.2 | -18.9 | 47.3 | 673 | -193 | 479
Subtotal (>0.5 billion US$) | 260.7 | -74.4 | 186.3
Subtotal (<0.5 billion US$) | 1.1 | -0.3 | 0.8
Total Notional US Mkts | 261.8 | -74.6 | 187.1
Total Not'l Non-US Mkts | 61 | -15.4 | 45.6
Total All Markets | 322.7 | -90 | 232.7
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with greater than 0.5 billion US dollars in reported net index investment notional value at the end of at least one of the past four quarters.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: 39734d1238013591-dates-in-excel-book1
Sheet: Sheet1

Birth Date | Location
1969-04-24 00:00:00 | [NAME]
1967-04-14 00:00:00 | Administration
1963-04-21 00:00:00 | Administration
1967-04-12 00:00:00 | Washington
1967-04-24 00:00:00 | Washington
1968-04-29 00:00:00 | North County
1976-04-22 00:00:00 | Chesterfield
1971-04-19 00:00:00 | South County
1973-04-15 00:00:00 | Fairview Heights
1971-04-05 00:00:00 | Fenton
1973-04-20 00:00:00 | [NAME]
1979-04-24 00:00:00 | Chesterfield
1971-04-18 00:00:00 | Festus
1979-04-09 00:00:00 | North County
1979-04-02 00:00:00 | Chesterfield
1983-04-04 00:00:00 | OFallon
1983-04-08 00:00:00 | Administration
1965-04-12 00:00:00 | Administration
1978-04-15 00:00:00 | North County
1983-04-04 00:00:00 | [NAME]
1987-04-21 00:00:00 | [NAME]
1978-04-06 00:00:00 | BIC
1938-04-22 00:00:00 | Administration
1976-04-24 00:00:00 | Administration
1986-04-22 00:00:00 | [NAME]
1985-04-10 00:00:00 | BIC
Spreadsheet: 842775d1694766674-idle-time-call-log-calls-by-agents
Sheet: calls

agent | start | end | idle
C | 03/09/2023 09:50:40 | 2023-09-03 09:53:08
D | 03/09/2023 10:18:08 | 2023-09-03 10:28:15
A | 03/09/2023 10:39:26 | 2023-09-03 10:43:40
D | 03/09/2023 10:44:04 | 2023-09-03 10:44:04
A | 03/09/2023 11:31:21 | 2023-09-03 11:40:36
A | 03/09/2023 11:43:56 | 2023-09-03 11:45:55
D | 03/09/2023 11:46:16 | 2023-09-03 11:50:40
A | 03/09/2023 11:46:55 | 2023-09-03 11:47:53
A | 03/09/2023 11:48:18 | 2023-09-03 12:11:56
C | 03/09/2023 11:49:01 | 2023-09-03 11:51:09
B | 03/09/2023 11:50:44 | 2023-09-03 11:50:44
B | 03/09/2023 11:51:35 | 2023-09-03 11:51:35
B | 03/09/2023 11:52:39 | 2023-09-03 11:52:39
C | 03/09/2023 11:53:09 | 2023-09-03 11:57:16
D | 03/09/2023 12:20:30 | 2023-09-03 12:33:36
B | 03/09/2023 12:24:51 | 2023-09-03 12:25:12
B | 03/09/2023 12:27:00 | 2023-09-03 12:27:44
B | 03/09/2023 12:28:26 | 2023-09-03 12:35:17
Spreadsheet: 863884d1711289768-count-no-of-persons-with-multiple-conditions-count-with-multiple-conditions-ans
Sheet: Summary

 | Date: | 1
S. No. | Department | A | B | C | G | (blank)
1 | SHEAR
2 | BEAMWELDING
3 | DETAILS
4 | FABRICATION
5 | STRUCTURAL
6 | WELDING
7 | CLEARING
8 | BLASTING
9 | PAINTING
10 | COLDFORM
11 | PACKING
13 | SHEETING
14 | RACKING
15 | MAINTENANCE
16 | ELECTRICAL
17 | Q.C
18 | STORES
19 | WAREHOUSE
20 | SHIPPING
21 | CIVIL
23 | IR
24 | PLANT OFFICE
28 | KSS MACHINE OPERATOR
 |  | 422 | 344 | 236 | 17 | 199
Need formula in C3 to F25, to count No. of persons based on Date, Shift and Dept. from Sheet1.
Spreadsheet: 63971d1264808391-data-validation-issue-personal-lines-quote-sheet1
Sheet: Why Cycle

Motorcycle Quote for
 |  |  |  |  |  | Why Have Us as Handle Your Cycle Insurance ?
 |  |  |  |  |  | We Ride and Understand Motorcycle Insurance
 |  |  |  |  |  | We [NAME] and Let You Choose the Coverage
 |  |  |  |  |  | Quotes from up to 4 National Companies
 |  |  |  |  |  | We'll Help You with Claims
 |  |  |  |  |  | Your Privacy Is Important to Us
 |  |  |  |  |  | We'll Call You Back
 |  |  |  |  |  | Made in the U.S.A. !
 |  |  |  |  |  | Our Clients Say It Best:
 |  |  |  |  |  | "I usually do not take time to write a letter, it is your job to satisfy the customer,
 |  |  |  |  |  | however your company honestly has gone above and beyond."
 |  |  |  |  |  | [NAME], Warminster PA
 |  |  |  |  |  | "Working with [NAME] (who is friendly, personable and very responsive) has always
 |  |  |  |  |  | been a breeze.'
 |  |  |  |  |  | Leigh & Tim F., Hellertown PA
 | Phone | [PHONE]
 | FAX | [PHONE]
Spreadsheet: 114602d1310371439-counting-unique-names-with-three-column-condition-example2
Sheet: Alla Projekt med Case

Project ID | Title | Case Date | Case Nbr | Status | Archive ID
613 | Q | 2011-06-30 16:26:11 | 2011-613-I | Idésökning | 3
612 | P | 2011-06-30 09:47:01 | 2011-612-I | Idésökning | 0
562 | O | 2011-06-30 09:38:04 | 2011-562-A | Arkiv | 1
549 | N | 2011-06-30 09:08:52 | 2011-549-P | Projekt | 0
593 | M | 2011-06-30 09:08:24 | 2011-593-P | Projekt | 0
587 | L | 2011-06-29 09:10:44 | 2011-587-A | Arkiv | 1
496 | K | 2011-06-27 09:09:45 | 2010-496-P | Projekt | 0
496 | J | 2011-06-27 09:09:42 | 2011-496-A | Arkiv | 0
611 | I | 2011-06-13 10:56:31 | 2011-611-I | Idésökning | 3
598 | H | 2011-06-13 10:25:21 | 2011-598-A | Arkiv | 0
610 | G | 2011-06-13 09:56:59 | 2011-610-I | Idésökning | 0
463 | F | 2011-06-08 08:12:46 | 2010-463-P | Projekt | 0
432 | E | 2011-06-08 08:11:54 | 2011-432-A | Arkiv | 1
609 | D | 2011-06-07 16:01:18 | 2011-609-P | Projekt | 3
608 | C | 2011-06-07 15:57:57 | 2011-608-P | Projekt | 3
607 | B | 2011-06-07 15:56:25 | 2011-607-P | Projekt | 3
606 | A | 2011-06-07 15:53:14 | 2011-606-P | Projekt | 0
587 | T | 2011-06-07 15:48:59 | 2011-587-L | LUAB | 1
602 | S | 2011-05-26 14:35:20 | 2011-602-I | Idésökning | 0
601 | R | 2011-05-26 14:28:38 | 2011-601-I | Idésökning | 0
599 | Q | 2011-05-25 13:20:21 | 2011-599-I | Idésökning | 0
600 | P | 2011-05-23 16:41:04 | 2011-600-I | Idésökning | 3
133 | O | 2011-05-20 10:12:44 | 2008-133-P | Projekt | 0
559 | N | 2011-05-16 14:48:16 | 2011-559-P | Projekt | 0
466 | M | 2011-05-16 14:47:56 | 2011-466-L | LUAB | 0
581 | L | 2011-05-16 14:47:34 | 2011-581-P | Projekt | 0
432 | K | 2011-05-16 14:46:43 | 2011-432-L | LUAB | 1
463 | J | 2011-05-16 14:46:14 | 2011-463-L | LUAB | 0
283 | I | 2011-05-16 14:45:40 | 2011-283-A | Arkiv | 0
394 | H | 2011-05-16 14:45:18 | 2011-394-L | LUAB | 0
135 | G | 2011-05-13 10:22:04 | 2007-135-P | Projekt | 0
318 | F | 2011-05-13 10:16:06 | 2011-318-P | Projekt | 0
577 | E | 2011-05-04 08:13:07 | 2011-577-A | Arkiv | 2
599 | D | 2011-05-04 08:10:47 | 2011-599-A | Arkiv | 0
567 | C | 2011-05-02 15:18:18 | 2011-567-A | Arkiv | 0
576 | B | 2011-05-02 14:26:43 | 2011-576-A | Arkiv | 0
598 | A | 2011-04-29 08:42:04 | 2011-598-I | Idésökning | 0
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: williams

 | La Maquina |  | Milagro |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 41033 | 47479 | 386304 | 382606 | 38081 | 48634 | 153724 | 143155
2 | 59989 | 71232 | 403458 | 384185 | 36007 | 36585 | 151696 | 152989
3 | 64884 | 73689 | 391197 | 397054 | 43616 | 48634 | 171875 | 151856
4 | 72845 | 72969 | 370233 | 375070 | 41520 | 48634 | 162638 | 146490
5 | 86850 | 87100 | 349554 | 354190 | 45007 | 48634 | 129789 | 115758
6 | 73245 | 63737 | 393698 | 399032 | 45036 | 47052 | 160393 | 159872
7 | 75161 | 67069 | 354762 | 357960 | 47482 | 49634 | 86575 | 170091
8 | 74164 | 64177 | 360958 | 364836 | 43337 | 49634 | 165147 | 160172
9 | 79821 | 70948 | 376404 | 367006 | 36696 | 49445 | 155105 | 159892
10 | 79661 | 78888 | 370941 | 370727 | 46256 | 49634 | 140105 | 141029
11 | 74009 | 63470 | 379203 | 384429 | 47147 | 49634 | 157262 | 167982
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | -34361
2000-12-11 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 713866d1610986910-how-to-limit-the-number-of-rows-returned-by-filter-formula-limit-rows-returned-by-filter
Sheet: Sheet1

Planned Events |  |  |  |  |  | Currently Active Events
Title | Start | End |  |  |  | Title | Start | End
Event1 | 2020-12-01 00:00:00 | 2021-04-01 00:00:00
Event2 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00
Event3 | 2021-01-17 00:00:00 | 2021-04-01 00:00:00
Event4 | 2021-01-11 00:00:00 | 2021-04-01 00:00:00 |  |  |  |  |  |  |  | Would like to make it so only 3 rows are given by the formula, preferebly the 3 with the most recent start dates
Event5 | 2021-01-16 00:00:00 | 2021-04-01 00:00:00
Event6 | 2021-06-01 00:00:00 | 2021-04-01 00:00:00
Event7 | 2021-07-01 00:00:00 | 2021-04-01 00:00:00
Event8 | 2021-08-01 00:00:00 | 2021-04-01 00:00:00
Event9 | 2021-09-01 00:00:00 | 2021-04-01 00:00:00
Event10 | 2021-10-01 00:00:00 | 2021-04-01 00:00:00
Spreadsheet: 772427d1647268190-self-marking-quiz-score-form-1-
Sheet: Sheet1

A | B | C | D | E | F | G | H |  |  |  |  |  | M |  |  |  | M |  |  |  | M |  |  | M
AMANDLA | DLN | AAA | M |  | s | 25213 | AAADLMN | 1 |  | 1 | AAADLMN | MANDALA |  | 2 | AAADLMN | MANLADA |  | 3 | AACDELN |  |  | 4 | AACDELN
MANDALA | DLN | AAA | M |  | s | 25214 | AAADLMN | 2 |  | 5 | AACDELN |  |  | 6 | AADELMN |  |  | 7 | AADELNR |  |  | 8 | AADELNT
CANALED | DLN | AAE | C |  |  | 8049 | AACDELN | 3 |  | 9 | AADELNW |  |  | 10 | AADELNX
CANDELA | DLN | AAE | C |  | s | 8050 | AACDELN | 4
DECANAL | DLN | AAE | C |  |  | 8051 | AACDELN | 5
LEADMAN | DLN | AAE | M |  |  | 8066 | AADELMN | 6
ADRENAL | DLN | AAE | R |  | s | 1666 | AADELNR | 7
LANATED | DLN | AAE | T |  |  | 1667 | AADELNT | 8
DANELAW | DLN | AAE | W |  | s | 8068 | AADELNW | 9
ADNEXAL | DLN | AAE | X |  |  | 12776 | AADELNX | 10
Spreadsheet: 91205d1290961503-how-to-access-web-data-using-url-url
Sheet: Sheet1

A1 |  |  | http://in.finance.yahoo.com/q?s=A1.NS
A2 |  |  | http://in.finance.yahoo.com/q?s=A2.NS
A3 |  |  | http://in.finance.yahoo.com/q?s=A3.NS
A4 |  |  | http://in.finance.yahoo.com/q?s=A4.NS
A5 |  |  | http://in.finance.yahoo.com/q?s=A5.NS
A6 |  |  | http://in.finance.yahoo.com/q?s=A6.NS |  |  | Copy and paste then choose values and number, click the formula bar and hit enter to activate the URL
A7 |  |  | http://in.finance.yahoo.com/q?s=A7.NS
A8 |  |  | http://in.finance.yahoo.com/q?s=A8.NS
A9 |  |  | http://in.finance.yahoo.com/q?s=A9.NS
A10 |  |  | http://in.finance.yahoo.com/q?s=A10.NS
Spreadsheet: 0c53187f-d51c-49e7-9a6a-c8a4fa305953
Sheet: NH4N data median

 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
High (26) | 0.00865000020712614 | 0.008300000336021185 | 0.008250000420957804 | 0.008100000210106373 | 0.007199999876320362 | 0.006300000008195639 | 0.00814999989233911 | 0.00814999989233911 | 0.006899999920278788 | 0.005899999989196658 | 0.007149999728426337 | 0.007250000024214387 | 0.009000000078231096 | 0.006650000112131238 | 0.007600000128149986 | 0.008450000081211329 | 0.0071000000461936 | 0.006499999901279807 | 0.00645000021904707
Good (136) | 0.05999999865889549 | 0.06079999916255474 | 0.04499999992549419 | 0.04189999960362911 | 0.04667357038706541 | 0.03676665015518665 | 0.03710000030696392 | 0.04325000010430813 | 0.03679165057837963 | 0.0366541501134634 | 0.04274999909102917 | 0.03603275120258331 | 0.03429999947547913 | 0.03302779980003834 | 0.0397916492074728 | 0.03029164951294661 | 0.02686109952628613 | 0.03262034989893436 | 0.03320370055735111
Moderate (323) | 0.1806000024080276 | 0.1739999949932098 | 0.1589999943971634 | 0.1211000010371208 | 0.150299996137619 | 0.1388999968767166 | 0.1093330010771751 | 0.1023000031709671 | 0.09000000357627869 | 0.0869000032544136 | 0.08799999952316284 | 0.1044000014662743 | 0.07670000195503235 | 0.08900000154972076 | 0.09399999678134918 | 0.07366669923067093 | 0.07033330202102661 | 0.07199999690055847 | 0.07900000363588333
Poor (130) | 0.2901500016450882 | 0.2868500053882599 | 0.2149499952793121 | 0.2080999985337257 | 0.282150000333786 | 0.210499994456768 | 0.1644000038504601 | 0.1560000032186508 | 0.1415000036358833 | 0.1400000005960464 | 0.1192499995231628 | 0.1501500010490417 | 0.1173999980092049 | 0.1069779992103577 | 0.1314999982714653 | 0.1196771245449781 | 0.1125649996101856 | 0.1105094999074936 | 0.1173335015773773
Bad (81) | 0.3677000105381012 | 0.4172999858856201 | 0.2615000009536743 | 0.2211000025272369 | 0.318699985742569 | 0.2840000092983246 | 0.2356999963521957 | 0.1979999989271164 | 0.161300003528595 | 0.1446000039577484 | 0.135900005698204 | 0.1809629946947098 | 0.1669439971446991 | 0.1328700035810471 | 0.1469999998807907 | 0.119999997317791 | 0.116067998111248 | 0.1118679977953434 | 0.1161540001630783
Trend moderate
Trend poor
Trend bad
 | 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