tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 703174d1604812797-matching-categories-to-determine-scores-card-evaluator
Sheet: Card Evaluator

Name | Card Type | Color Identity | CMC | Keywords | Effect description | Effect Cost | Cards effect at act. | Special Points | Score |  | Ranking table - Set valules in this table to have card scores reflect your needs
Persecute | Sorcery | Black | 4 | None | [NAME] | None | Many | 0 |  |  | Card Type |  | Color Identity |  | Keywords |  | Effect desc. [NAME] |  | Effect cost
Stinkweed Imp | Creature | Black | 3 | Flying | Destroy | None | 1 | 0 |  |  | Creature | 1 | White | 0 | Indestructible | 1 | Destroy | 2 | Mana | -1
[NAME] | Sorcery | Black | 2 | None | Return | None | 2 | 0 |  |  | Planeswalker | 1 | Blue | 0 | Flying | 1 | Exile | 2 | Sacrifice | -1
Drain Life | Sorcery | Black | 2 | None | Damage | Mana | 1 | 3 |  |  | Sorcery | 2 | Red | 0 | Shroud | 1 | [NAME] | 2 | None | 1
Bounty Agent | Creature | White | 2 | Vigilance | Destroy | Tap Sacrifice | 1 | 0 |  |  | Instant | 2.5 | Green | 1 | Shadow | 1 | Removal | 3 | Tap | -0.25
Hero's Demise | Instant | Black | 2 | None | Destroy | None | 1 | -0.25 |  |  | Equipment | 0 | Black | 1 | Haste | 1 | Wipe | 3
[NAME] | Artifact Creature | Colorless | 6 | None | [NAME] | None | Many | 0 |  |  | Artifact | 1 | Colorless | 0.5 | Vigilance | 1 | Counters | 1
Tar Fiend | Creature | Black | 6 | Devour | [NAME] | Sacrifice | Many | 2 |  |  | Echantment | 0 |  |  | Deathtouch | 1 | Keyword | 1
Magus of the Mirror | Creature | Black | 6 | None | Swap | Tap Sacrifice | 1 | 2 |  |  | Land | 0 |  |  | Lifelink | 1 | Return | 1
[NAME] | Instant | Black | 2 | None | [NAME] | None | Many | 0 |  |  |  |  |  |  | First Strike | 1 | Draw | 1
Consuming Vapors | Sorcery | Black | 4 | Rebound | Sacrifice Gain | None | 1 | 0 |  |  |  |  |  |  | Double Strike | 1 | Damage | 1
Dash Hopes | Instant | Black | 2 | None | Counter | None | 1 | -2 |  |  |  |  |  |  | Hexproof | 1 | Gain | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intimidate | 1 | Token | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trample | 1 | Swap | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Devour | 1 | [NAME] | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rebound | 3 | Sacrifice | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Counter | 1.5
Spreadsheet: dutch_quigley__9435__KSC II Quote Sheet Unwind 06042001
Sheet: NYMEX

Trader |  | Originator |  | Structurer |  | Customer
See Below |  | [NAME] Eubank |  | [NAME] / [NAME] |  | KSC VPP II
 |  |  |  | x5-7754  / x5-3561
Field / Location |  |  |  | EB 3273F  / EB 3273E
NYMEX |  |  |  |  |  | [NAME]
Start | Stop |  | Daily |  |  | NYMEX |  |  | TOTAL VOLUME
Date | Date | Term | MMbtu | NOTES | Pricing Pt. | OFFER
2001-07-01 00:00:00 | 2003-05-01 00:00:00 | 1 Y - 11 M | See detail |  | NYMEX
[NAME] | MMBTU/d
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
2002-11-01 00:00:00
2002-12-01 00:00:00
2003-01-01 00:00:00
2003-02-01 00:00:00
2003-03-01 00:00:00
2003-04-01 00:00:00
2003-05-01 00:00:00
Spreadsheet: 296511d1392115912-if-match-times-by-columns-in-other-tabs-cdrs-test2
Sheet: CDRS Test

Call Type | Call Date | Call Time | Duration | Description | Time Band | ChargeCode |  | Cost Amount
Call 1 | 2014-01-01 00:00:00 | 22:29:43 | 00:00:08 | UK Mobile O2 (fm1) | OffPeak | 1193
Call 2 | 2014-01-02 00:00:00 | 11:05:13 | 00:02:34 | UK London | Peak | 1289
Call 3 | 2014-01-02 00:00:00 | 12:27:04 | 00:05:14 | UK Birmingham | Peak | 1289
Call 4 | 2014-01-02 00:00:00 | 12:47:29 | 00:00:56 | 0845 Lo-Call Non Geo (ll) | Peak | 1266
Call 5 | 2014-01-02 00:00:00 | 12:50:05 | 00:01:41 | 0845 Lo-Call Non Geo (ll) | Peak | 1266
Call 6 | 2014-01-02 00:00:00 | 14:26:04 | 00:01:33 | 03 Uk Wide Number Calls (g21) | Peak | 1184
Call 7 | 2014-01-02 00:00:00 | 14:27:55 | 00:10:44 | 0845 Lo-Call Non Geo (ll) | Peak | 1266
Call 8 | 2014-01-03 00:00:00 | 13:26:48 | 00:07:21 | 0845 Lo-Call Non Geo (ll) | Peak | 1266
Call 9 | 2014-01-03 00:00:00 | 16:35:27 | 00:00:01 | UK Wolverhampton | Peak | 1289
Call 10 | 2014-01-04 00:00:00 | 12:06:20 | 00:00:04 | UK Mobile O2 (fm1) | WeekendPeak | 1193
Call 11 | 2014-01-05 00:00:00 | 12:10:05 | 00:01:35 | UK Southampton | WeekendPeak | 1289
Call 12 | 2014-01-05 00:00:00 | 16:20:12 | 00:00:02 | UK Wolverhampton | WeekendPeak | 1289
Call 13 | 2014-01-06 00:00:00 | 08:51:15 | 00:00:07 | UK London | Peak | 1289
Call 14 | 2014-01-06 00:00:00 | 09:00:05 | 00:00:05 | UK Worcester | Peak | 1289
Call 15 | 2014-01-06 00:00:00 | 09:00:05 | 00:00:08 | UK London | Peak | 1289
Call 16 | 2014-01-06 00:00:00 | 09:00:05 | 00:00:26 | UK Oldmeldrum | Peak | 1289
Call 17 | 2014-01-06 00:00:00 | 09:04:21 | 00:04:29 | UK London | Peak | 1289
Call 18 | 2014-01-06 00:00:00 | 09:55:32 | 00:00:08 | UK Mobile O2 (fm1) | Peak | 1193
Call 19 | 2014-01-06 00:00:00 | 10:00:36 | 00:00:03 | UK London | Peak | 1289
Call 20 | 2014-01-06 00:00:00 | 10:00:36 | 00:00:03 | UK Neath | Peak | 1289
Call 21 | 2014-01-06 00:00:00 | 10:00:50 | 00:00:15 | UK Medway | Peak | 1289
Call 22 | 2014-01-06 00:00:00 | 10:05:18 | 00:00:02 | UK Shrewsbury | Peak | 1289
Call 23 | 2014-01-06 00:00:00 | 10:05:39 | 00:00:07 | UK Falkirk | Peak | 1289
Call 24 | 2014-01-06 00:00:00 | 10:05:40 | 00:00:36 | UK Walsall | Peak | 1289
Call 25 | 2014-01-06 00:00:00 | 10:05:59 | 00:00:05 | UK Holyhead | Peak | 1289
Call 26 | 2014-01-06 00:00:00 | 10:06:07 | 00:00:03 | UK Motherwell | Peak | 1289
Call 27 | 2014-01-06 00:00:00 | 10:06:07 | 00:00:02 | UK Leeds | Peak | 1289
Call 28 | 2014-01-06 00:00:00 | 10:06:07 | 00:00:03 | UK Colchester | Peak | 1289
Call 29 | 2014-01-06 00:00:00 | 10:06:21 | 00:00:05 | UK Reading | Peak | 1289
Call 30 | 2014-01-06 00:00:00 | 10:06:29 | 00:00:08 | UK Ellon | Peak | 1289
Call 31 | 2014-01-06 00:00:00 | 10:06:32 | 00:00:04 | UK Barrow-in-Furness | Peak | 1289
Spreadsheet: 799565d1665146004-sort-data-that-corresponds-to-a-specific-month-sample1
Sheet: Location1

 | Go to Summary
Floor | Room | DEPARTMENT | USE | MONDAY AM | MONDAY PM | TUESDAY AM | TUESDAY PM | WEDNESDAY AM | WEDNESDAY PM | THURSDAY AM | THURSDAY PM | FRIDAY AM | FRIDAY PM
1 | CONSULT #1 | PEDIATRICS | CONSULT
1 | CONSULT #2 | PEDIATRICS | CONSULT | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 |  | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 | PROVIDER 1
1 | CONSULT #3 | PEDIATRICS | CONSULT | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 |  | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 | PROVIDER 1
1 | EXAM ROOM #1 | PEDIATRICS | EXAM ROOM | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3
1 | EXAM ROOM #2 | PEDIATRICS | EXAM ROOM | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3 | PROVIDER 3
1 | EXAM ROOM #3 | PEDIATRICS | EXAM ROOM | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 |  | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 | PROVIDER 1
1 | EXAM ROOM #4 | PEDIATRICS | EXAM ROOM | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 |  | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 | PROVIDER 1
1 | EXAM ROOM #5 | PEDIATRICS | EXAM ROOM | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 |  | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 | PROVIDER 1
1 | EXAM ROOM #6 | PEDIATRICS | EXAM ROOM | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 |  | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | HOLD: PROVIDER 2 | PROVIDER 1 | PROVIDER 1
1 | LABORATORY | PEDIATRICS | OTHER | LABORATORY | LABORATORY | LABORATORY | LABORATORY | LABORATORY | LABORATORY | LABORATORY | LABORATORY | LABORATORY | LABORATORY
1 | EXAM ROOM #7 | PEDIATRICS | EXAM ROOM
1 | AVAILABLE CONSULT ROOMS
1 | AVAILABLE EXAM ROOMS
Spreadsheet: 697512d1601389692-last-5-occurrences-lastocc
Sheet: Sheet1

PRODUCT  NAME | DATE | QTY |  | INPUT
A | 2020-10-01 00:00:00 | 4 |  | B
B | 2020-10-02 00:00:00 | 5 |  |  | 2020-10-02 00:00:00
C | 2020-10-02 00:00:00 | 6
A | 2020-10-03 00:00:00 | 7
C | 2020-10-04 00:00:00 | 8
D | 2020-10-05 00:00:00 | 9
E | 2020-10-06 00:00:00 | 1
A | 2020-10-06 00:00:00 | 2
G | 2020-10-07 00:00:00 | 3
A | 2020-10-08 00:00:00 | 5
U | 2020-10-08 00:00:00 | 8
A | 2020-10-08 00:00:00 | 9
A | 2020-10-09 00:00:00 | 99
B | 2020-10-17 00:00:00 | -55
Spreadsheet: 05f4773a-a1b5-47eb-a9e7-9596fc4daab1
Sheet: Figure 4 data

Year | Spot price | 63 month forard price | Chile official forecast | 10 year moving average
2001 | 1501.5 |  | 2010.616 | 2104.5
2002 | 1512 |  | 1940.068 | 2023.1
2003 | 1786 | 1785 | 1940.068 | 1970.8
2004 | 2816 | 1942 | 2050.299 | 2053.4
2005 | 3517 | 2277 | 2182.576 | 2285.1
2006 | 7950 | 4430 | 2693.1 | 2285.1
2007 | 8010 | 4725 | 3020.333 | 2767.8
2008 | 8055 | 6457.5 | 4387.199 | 3357.4
2009 | 5719 | 5459 | 4695.846 | 3698.9
2010 | 7296.5 | 6393.5 |  | 4112.9
Spreadsheet: 192533d1352451807-lists-to-multiple-sheets-data-test
Sheet: Andy Manning

Job | Postcode | Tech 1 | Tech 2 | [NAME] | Departure
BLUE ANCHOR | KT20 5SL | [NAME] | [NAME] | 04/10/2012 10:00 | 04/10/2012 11:30
ROYAL OAK | BR6 6BJ | [NAME] |  | 01/10/2012 09:15 | 01/10/2012 11:15
Pheasant | TN25 4QH | [NAME] |  | 01/10/2012 13:45 | 01/10/2012 14:25
RED BARN | DA7 6HG | [NAME] |  | 01/10/2012 15:30 | 01/10/2012 16:00
Spreadsheet: 62437d1263389621-struggling-to-calculate-sum-by-attribute-sum-example
Sheet: Sheet1

Code | Sum of Code | Head 1 | Head 2 | Head 3 | Head 4 | Head 5 | Head 6 | Head 7 | Head 8 | Head 9 | Head 10 | Head 11 | Head 12
138 | 230 | 1 | 2 | 3 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
138 |  |  | 3
138 |  | 1 | 34 | 5 | 7 | 8 | 9 | 0 | 0 | 0 | 8 |  | 6
138 |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 4
138 |  |  |  |  |  |  |  |  |  | 33
138 |  |  |  |  | 3 | 3 | 3 | 3 | 3 |  |  |  | 3
138 |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3
138 |  |  |  | 3 |  |  |  |  | 7 | 1 |  | 3
138 |  |  | 3 | 3 |  |  |  |  | 5 |  |  | 3
138 |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 3
364 | 154 | 7 |  | 7 |  |  |  |  | 7 | 7 | 7 | 7
364 |  |  |  | 7 | 7 | 7 | 7 | 7 |  | 4 | 5
364 |  |  |  |  |  |  |  |  | 3
364 |  |  |  | 4 | 4 | 5 |  | 2 |  | 6 | 7 | 8
364 |  |  |  |  | 4 |  | 22
364 |  |  |  |  |  | 3
Spreadsheet: 804927d1668436916-vlookup-and-choose-together-pasta1
Sheet: Planilha1

 |  |  |  |  |  |  |  |  | Average |  | Quantity | nº
 | nº | 10 | 40 | 30 | 70 | 80 | 100 |  |  |  | 1 | 10
 | nº | 20 | 40 | 30 | 10 | 70 | 90 |  | #[NAME]? |  | 5
 | nº | 40 | 50 | 30 | 90 | 70 | 60 |  | #[NAME]? |  | 2
 |  |  |  |  |  |  |  |  |  |  | 5
 | I am trying to get the average based on quantity |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 1
 | Exemple |  |  |  |  |  |  |  | 5 |  | 0
 | 10 = 1 |  | 1 |  |  |  |  |  | 1 |  | 6
 | 40 = 5 |  | 5 |  |  |  |  |  | 4 |  | 8
 | 30 = 2 |  | 2 |  |  |  |  |  | 2 |  | 3
 | 70 = 0 |  | 0
 | 80 = 6 |  | 6
 | 100 = 3 |  | 3
 | Average
Spreadsheet: 138057d1327503205-many-if-statements-sample2
Sheet: Sheet1

System | Type | ABC |  | $ | XYZ |  | $ |  | System | Type
 |  |  |  |  |  |  |  |  | System <5 | A
System <5 | A | 10 |  | 10 | 10.2 |  | 11 |  | 5 <System <10 | B
 | B | 10.5 |  | 15 | 10.7 |  | 16 |  | System >10
5 <System <10 | A | 11 |  | 20 | 11.2 |  | 21
 | B | 11.5 |  | 25 | 11.7 |  | 26
System >10 | A | 12 |  | 30 | 12.2 |  | 31
 | B | 12.5 |  | 35 | 12.7 |  | 36
System |  | <-Inputs
Type
ABC/XYZ |  | <-Outputs
$
Spreadsheet: 691166d1597528146-formula-show-payments-date-on-5th-10th-15th-20th-25th-30th-from-inv-due-date-example-payment-date
Sheet: Sheet1

Invoice # | Invoice Due Date | Payment date (5th, 10th, 15th, 20th, 25th, 30th of each month)
1111111 | 08/14/2020 | 2020-08-15 00:00:00
2222222 | 08/15/2020 | 2020-08-15 00:00:00
333333 | 08/18/2020 | 2020-08-20 00:00:00
44444 | 08/18/2020 | 2020-08-20 00:00:00
55555 | 08/21/2020 | 2020-08-25 00:00:00
666666 | 08/21/2020 | 2020-08-25 00:00:00
77777 | 09/12/2020 | 2020-09-15 00:00:00
56565 | 09/12/2020 | 2020-09-15 00:00:00
22255 | 09/12/2020 | 2020-09-15 00:00:00
225553 | 09/13/2020 | 2020-09-15 00:00:00
225552 | 09/14/2020 | 2020-09-15 00:00:00
1111115 | 09/14/2020 | 2020-09-15 00:00:00
115225 | 09/14/2020 | 2020-09-15 00:00:00
1542154 | 09/14/2020 | 2020-09-15 00:00:00
4500112 | 09/22/2020 | 2020-09-25 00:00:00
11144 | 09/22/2020 | 2020-09-25 00:00:00
114444 | 09/22/2020 | 2020-09-25 00:00:00
Spreadsheet: 605880d1547350346-iferror-match-formula-123-form
Sheet: HELP

1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 2fc4b640-f221-4b50-bb0e-d46957a9a615
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-03-06 09:30:27.490000
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.214 | 102.089 | 101.964 | 101.589
4.5 | 101.274 | 101.149 | 101.024 | 100.649 |  | Note: | Refer To Price [NAME]
4.375 | 100.284 | 100.159 | 100.034 | 99.659 |  |  | For all Price Adjs
4.25 | 99.651 | 99.526 | 99.401 | 98.776
4.125 | 98.81 | 98.685 | 98.56 | 97.935
4 | 97.78 | 97.655 | 97.53 | 96.905
3.875 | 96.716 | 96.591 | 96.466 | 95.841
3.75 | 95.841 | 95.716 | 95.591 | 94.966
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.729 | 102.604 | 102.479 | 102.104
3.75 | 102.257 | 102.132 | 102.007 | 101.632
3.625 | 101.856 | 101.731 | 101.606 | 101.231
3.5 | 101.28 | 101.155 | 101.03 | 100.405
3.375 | 100.529 | 100.404 | 100.279 | 99.654
3.25 | 99.74 | 99.615 | 99.49 | 98.865 |  | 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-03-20 09:30:27.490000
30 DAY | 2014-04-04 09:30:27.490000
45 DAY | 2014-04-19 09:30:27.490000
60 DAY | 2014-05-04 09:30:27.490000
90 DAY | 2014-06-03 09:30:27.490000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 157002d1337593993-add-amount-everyday-book1
Sheet: Sheet1

Date | Today | Amount | Iteam | Price | Total | [NAME]
2012-05-21 00:00:00 | Monday |  |  |  |  | 600
Date | Today | Amount | Iteam | Price | Total | [NAME]
2012-05-22 00:00:00 | Tuesday
Date | Today | Amount | Iteam | Price | Total | [NAME]
2012-05-23 00:00:00 | Wednesday
Date | Today | Amount | Iteam | Price | Total | [NAME]
2012-05-24 00:00:00 | Thursday
Spreadsheet: 129094d1321448578-unique-concatenate-text-sort-unique-concatenate-text
Sheet: New Problem

Glass 1 | [NAME] 2 | CONCATENATE |  |  | Advanced Filter CONCATENATE | Total |  | Advanced Filter CONCATENATE | Total
Optilam Clear Ct | Optifloat Clear | Optilam Clear CtOptifloat Clear |  |  | Optilam Clear CtOptifloat Clear | 1 |  | Optifloat ClearOptilam Clear Ct | 1
Optifloat Clear | Optilam Clear Ct | Optifloat ClearOptilam Clear Ct |  |  | Optifloat ClearOptilam Clear Ct | 1 |  | Optilam ClearSuncool 70/40 T | 1
Optilam Clear | Suncool 70/40 T | Optilam ClearSuncool 70/40 T |  |  | Optilam ClearSuncool 70/40 T | 1 |  | Grand Total | 2
Suncool 70/40 T | Optilam Clear | Suncool 70/40 TOptilam Clear |  |  | Suncool 70/40 TOptilam Clear | 1
 |  |  |  |  | Grand Total | 4
 |  |  |  |  | However only two different Products!!!!!!!!!!!! |  |  | Two different Products
Spreadsheet: 66645d1267275793-extracting-a-specific-number-of-lines-out-of-a-spreadsheet-removeredundantrows
Sheet: Sheet1

ColumnA
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
BP123
Test
Test
Test
Spreadsheet: 78911d1279198235-filtering-status-look-up
Sheet: Sheet2

 | thing | status |  | just hide column a or put it over to the right in a column out of sight
0 | [NAME] | pending |  | or even on another sheet
1 | [NAME] | pending
1 | martin 15 | pending
1 | martin 20 | pending
1
1
1
2
2
2
2
2
2
2
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
4
Spreadsheet: a03044c1-0bf3-4830-9912-5d524914b54a
Sheet: Sheet1

Release: Job Openings and Labor Turnover | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=192
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-09 10:04 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Job Openings and Labor Turnover | 2010-08-11 00:00:00 | Current
Link:
http://www.bls.gov/jlt/ | 2010-08-11 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-08-11 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-08-11 00:00:00
2010-09-08 00:00:00
2010-10-07 00:00:00
2010-11-09 00:00:00
2010-12-07 00:00:00
2011-01-11 00:00:00
2011-02-08 00:00:00
2011-03-11 00:00:00
2011-04-13 00:00:00
2011-05-11 00:00:00
2011-06-07 00:00:00
2011-07-12 00:00:00
2011-08-10 00:00:00
2011-09-07 00:00:00
2011-10-12 00:00:00
2011-11-08 00:00:00
2011-12-13 00:00:00
2012-01-10 00:00:00
2012-02-07 00:00:00
2012-03-13 00:00:00
2012-04-10 00:00:00
2012-05-08 00:00:00
2012-06-19 00:00:00
2012-07-10 00:00:00
2012-08-07 00:00:00
2012-09-11 00:00:00
2012-10-10 00:00:00
2012-11-06 00:00:00
2012-12-11 00:00:00
2013-01-10 00:00:00
2013-02-12 00:00:00
2013-03-12 00:00:00
2013-04-09 00:00:00
2013-05-07 00:00:00
2013-06-11 00:00:00
2013-07-09 00:00:00
2013-08-06 00:00:00
2013-09-10 00:00:00
2013-10-24 00:00:00
2013-11-22 00:00:00
2013-12-10 00:00:00
2014-01-17 00:00:00
2014-02-11 00:00:00
Spreadsheet: 850483d1700825914-each-day-how-many-time-repeated-repeated-days-hd
Sheet: Sheet1

Time |  | Result
2022-01-06 02:00:00
2022-01-06 10:00:00
2022-01-06 12:00:00
2022-01-06 13:00:00
2022-01-06 14:00:00
2022-01-06 15:00:00
2022-01-14 00:00:00
2022-01-14 07:00:00
2022-01-14 08:00:00
2022-01-14 16:00:00
2022-01-18 05:00:00
2022-01-18 08:00:00
2022-01-18 12:00:00
2022-01-18 22:00:00
2022-01-21 02:00:00
2022-01-21 04:00:00
2022-01-21 10:00:00
2022-01-21 15:00:00
2022-01-24 07:00:00
2022-01-24 08:00:00
2022-01-24 10:00:00
2022-01-24 16:00:00
2022-01-11 03:00:00
2022-01-11 11:00:00
2022-01-11 17:00:00
2022-01-17 08:00:00
2022-01-17 08:00:00
2022-01-17 15:00:00
2022-01-20 02:00:00
2022-01-20 12:00:00
2022-01-20 17:00:00
2022-01-25 08:00:00
2022-01-25 13:00:00
2022-01-25 17:00:00
2022-01-27 04:00:00
2022-01-27 12:00:00
2022-01-27 13:00:00
2022-01-10 15:00:00
2022-01-10 15:00:00
2022-01-12 10:00:00
2022-01-12 10:00:00
2022-01-13 09:00:00
2022-01-13 20:00:00
2022-01-19 03:00:00
2022-01-19 18:00:00
2022-01-26 12:00:00
2022-01-26 18:00:00
2022-01-28 08:00:00
2022-01-28 15:00:00
2022-01-03 15:00:00
2022-01-04 18:00:00
2022-01-07 14:00:00
2022-01-31 15:00:00
Spreadsheet: 135836d1326268570-excel-2007-by-selecting-a-month-in-a-cell-want-to-list-out-full-dates-in-the-subsequent-cells-book1-20-
Sheet: Sheet1

Month |  |  | February
Period Start Date |  |  | 2012-02-01 00:00:00
Date | Day
Total
Spreadsheet: cooper_richey__4033__marks
Sheet: Sheet1

 |  |  |  |  |  |  | Jan 31, 2002
 |  | *2001 actual published PP
 |  |  | flat | on | off |  | 2002 | BID | OFFER | MID
 |  | JAN* | 131.23 | 145.5 | 113.1 |  | BOM | +/-28.6 | +/-28.6 | +/-28.6
 |  | FEB* | 116.75 | 134.4 | 93.16 |  | FEB | 23 | 25
 |  | MAR* | 97.23 | 114.6 | 73.12 |  | MAR | 24.5 | 24.75
 |  | APR* | 114.82 | 138.4 | 85.25 |  | APR | 25.5 | 26.5
 |  | MAY* | 88.34 | 107.4 | 61.85 |  | MAY | 25.5 | 27.5
 |  | JUN* | 63.59 | 79.85 | 41.34 |  | JUN | 27 | 29
 |  | JUL* | 53.47 | 64.64 | 40.48 |  | JUL | 29.5 | 31.5
 |  | AUG* | 52.37 | 63.54 | 36.91 |  | AUG | 29.5 | 31.5
 |  | SEP* | 29.84 | 35.9 | 23.11 |  | SEP | 29.5 | 31.5
 |  | OCT* | 43.92 | 54.2 | 29.73 |  | OCT | 34 | 34.75
 |  | NOV* | 33.31 | 42.28 | 22.09 |  | NOV | 34 | 34.75
 |  | DEC | 33.61 | 42.64 | 23.12 |  | DEC | 34 | 34.75
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 824244d1680419070-countifs-criteria-over-multiple-columns-value-error-excel-sample
Sheet: Summary

SUMMARY |  |  |  | Year | 2023-01-01 00:00:00
Item | YTD
Apples |  |  | << not working due to criteria 3 trying to match "Apples" across columns C,D,E,F,G on Data Sheet
Bananas |  |  | << works when matching "Apples" with column C only
Cherries
Grapefruit
Grapes
Melon
Orange
Pineapple
Strawberries