tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863093d1710659701-what-formula-that-work-with-wildcard-using-indexmatch-wildcard-aligw
Sheet: Sheet1

 | NAME | AREA | DATE | TIME |  | TABLE 1
 | Ria noverita | Padang payakumbuh | 2024-02-22 00:00:00 | 08:23:00 |  | NAME | Ria noverita
 | Ria noverita | Padang | 2024-02-23 00:00:00 | 08:03:00 |  | AREA | Padang payakumbuh
 | Ria noverita | Padang payakumbuh | 2024-02-24 00:00:00 | 07:51:00 |  | DATE | 2024-02-22 00:00:00
 | Ria noverita | Padang payumbuh | 2024-02-26 00:00:00 | 08:10:00 |  | TIME
 | Ria Noveerita | Padang payakumbuh | 2024-02-27 00:00:00 | 07:58:00
 | Ria noverita | Padang payakumbuh | 2024-02-28 00:00:00 | 08:02:00 |  | TABLE 2
 | Ria noverita | Padang payakumbuh | 2024-02-29 00:00:00 | 07:45:00 |  | NAME | Ria
 | Ria noverita | Padang payakumbuh | 2024-02-29 00:00:00 | 07:33:00 |  | AREA | Pada
 | Ria noverita | Padang payakumbuh | 2024-02-06 00:00:00 | 07:42:00 |  | DATE | 2024-02-28 00:00:00
 | [NAME] | Jakarta Utara | 2024-02-07 00:00:00 | 08:08:00 |  | TIME
 |  |  |  |  |  | I want return value in coloum time based on table 2, but it doesn’t work with same formula in table 1, what formula that could work with cell that have wildcard
Spreadsheet: 108127d1305214895-search-the-text-of-cell-in-a-range-and-return-the-whole-cell-where-content-is-found-example
Sheet: Question 2

2062EDEBIT | EDEBIT | ACTIVAT 2070 EDEBITCARD.ORG
2069dfgdsgdfs | dfgdsgdfs
2070dfgdsf | dfgdsf
2073dfsdgsdf | dfsdgsdf
2124Account.comTAKE | Account.com | BABYBANKACCOUNT.COM |  |  |  | 2NDCHANCEBANKING.NET
2125dfsdf | dfsdf |  |  |  |  | 2062 NDCHANCEBANKING.ORG
222dfdfgdsgdf | dfdfgdsgdf |  |  |  |  | ACTIVATEDEBITCARD.NET
2233dfsdgfdf | dfsdgfdf |  |  |  |  | ACTIVAT 2070 EDEBITCARD.ORG
2234dfgdfg | dfgdfg |  |  |  |  | ALLACCESSMASTERCARD.NET
 |  |  |  |  |  | ALLACCESSMASTERCARD.ORG
 |  |  |  |  |  | AMERICANEXPRESSPREPAID.NET
 |  |  |  |  |  | AMERICAN 2124 EXPRESSPREPAID.ORG
 |  |  |  |  |  | APPLYBANKACCOUNT.NET
 |  |  |  |  |  | APPLYBANKACCOUNT.ORG
 |  |  | So if the keywords in column B |  |  | BABYBANKACCOUNT.COM
 |  |  | Found in the middle (5-15) of column A |  |  | BABYBANKACCOUNT.NET
 |  |  | Has a domain available in Column F |  |  | BABYBANKACCOUNT.ORG
 |  |  | Then return the cell which has the domain avaible
 |  |  | And display them in column C
 |  |  | Above is a example of what would happen
Spreadsheet: kimberly_watson__20554__imbalsumm0108
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 7793 | 6031 |  |  | 1235 | 1150 | 1454 | 1283
2 | 7791 | 6031 |  |  | 1177 | 1150 | 1476 | 1283
3 | 5994 | 6031 |  |  | 1174 | 1150 | 1523 | 1283
4 | 7564 | 6031 |  |  | 1155 | 1150 | 1485 | 1283
5 | 7266 | 6031 |  |  | 1111 | 1150 | 1460 | 1283
6 | 7106 | 6031 |  |  | 1102 | 1150 | 1390 | 1283
7 | 6926 | 6031 |  |  | 1149 | 1150 | 1444 | 1283
8 | 6932 | 6031 |  |  | 1096 | 1150 | 1417 | 1283
9 | 6825 | 6031 |  |  | 1073 | 1150 | 1479 | 1283
10 | 7236 | 6031 |  |  | 1025 | 1150 | 1307 | 1283
11 | 7145 | 6031 |  |  | 1044 | 1150 | 1444 | 1283
12 | 7121 | 6031 |  |  | 1011 | 1150 | 1426 | 1283
13 | 7497 | 6031 |  |  | 1008 | 1150 | 1419 | 1283
14 | 5169 | 6031 |  |  | 956 | 1150 | 1409 | 1283
15 | 7298 | 6531 |  |  | 1098 | 1150 | 1394 | 1283
16 | 4507 | 6531 |  |  | 1042 | 1150 | 1404 | 1283
17 | 5627 | 6513 |  |  | 1034 | 1150 | 1409 | 1283
18 | 6389 | 6531 |  |  | 1004 | 1150 | 1399 | 1283
19 | 6016 | 6531 |  |  | 877 | 1150 | 1388 | 1283
20 | 7602 | 6531 |  |  | 1064 | 1150 | 1365 | 1283
21 | 7180 | 6531 |  |  | 965 | 1150 | 1220 | 1283
22 | 6993 | 6531 |  |  | 1003 | 1150 | 1451 | 1283
23 | 7013 | 6531 |  |  | 810 | 1150 | 1390 | 1283
24 | 7149 | 6531 |  |  | 912 | 1150 | 1365 | 1283 |  |  | 377
25 | 6994 | 6531 |  |  | 930 | 1150 | 1337 | 1283 |  |  | 725
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 372841.88
2001-08-25 00:00:00
CBS Volume
 |  |  | 146405
Spreadsheet: 3dce7030-3b3b-48c8-b551-0bc700ba4b81
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
CBSRP | Test | CBSRP | Coxiella burnetii (Q Fever), Molecular Detection, PCR, Serum | Coxiella burnetii (Q fever) PCR, S | Real-Time Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Serum, [NAME] |  |  |  |  | Collection Container/Tube:  Preferred: 5-mL, red top Submission Container/Tube: Sterile vial [NAME]: 1 mL Additional Information: The high sensitivity of amplification by PCR requires the specimen to be processed in an environment in which contamination of the specimen by Coxiella burnetii DNA is not likely. | 0.5 mL | Hemolysis	NA Thawing	Warm reject; Cold OK  Lipemia	NA Icterus	NA Other	NA | Not applicable | Monday, Wednesday, Friday; 8 a.m. | 2 days | 7 days | 1 | 87798 |  |  |  |  | Rochester
CBSRP | [NAME] | SERUM | Serum |  |  |  | Frozen | 7 days
CBSRP | Result | 35189 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
CBSRP | Result | 35190 | Coxiella burnetii PCR | Coxiella burnetii PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60261-5 | Coxiella burnetii DNA:ACnc:Pt:Ser/Plas:[NAME]:Probe.amp.tar
Spreadsheet: 79117d1279352528-from-range-2-calendar-calendar
Sheet: Sheet1

 | 2010 | 2010-07-06 00:00:00 | 2010-07-07 00:00:00 | 2010-07-08 00:00:00 | 2010-07-09 00:00:00 | 2010-07-10 00:00:00 | 2010-07-11 00:00:00 | 2010-07-12 00:00:00 | 2010-07-13 00:00:00 | 2010-07-14 00:00:00 | 2010-07-15 00:00:00 | 2010-07-16 00:00:00 | 2010-07-17 00:00:00 | 2010-07-18 00:00:00 | 2010-07-19 00:00:00 | 2010-07-20 00:00:00 | 2010-07-21 00:00:00 | 2010-07-22 00:00:00 | 2010-07-23 00:00:00 | 2010-07-24 00:00:00 | 2010-07-25 00:00:00 | 2010-07-26 00:00:00 | 2010-07-27 00:00:00 | 2010-07-28 00:00:00 | 2010-07-29 00:00:00 | 2010-07-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-01 00:00:00 | 2010-08-02 00:00:00 | 2010-08-03 00:00:00 | 2010-08-04 00:00:00 | 2010-08-05 00:00:00
 | [NAME]
 | [NAME] | 17.5 |  |  |  |  | 22
 | [NAME] | 10 |  | 20 |  |  |  |  |  |  | 65 |  |  |  |  |  |  |  | 17
 | [NAME] |  |  |  |  |  | 10
 | [NAME] |  |  |  | 25
 | [NAME] |  |  |  |  |  |  | 120
 | 2010-07-06 00:00:00 | [NAME] |  | 10
 | 2010-07-06 00:00:00 | [NAME] |  | 17.5
 | 2010-07-08 00:00:00 | [NAME] |  | 20
 | 2010-07-09 00:00:00 | [NAME] |  | 25
 | 2010-07-11 00:00:00 | [NAME] |  | 10
 | 2010-07-11 00:00:00 | [NAME] |  | 13
 | 2010-07-11 00:00:00 | [NAME] |  | 9
 | 2010-07-12 00:00:00 | [NAME] |  | 120
 | 2010-07-15 00:00:00 | [NAME] |  | 65
 | 2010-07-23 00:00:00 | [NAME] |  | 17
Spreadsheet: 693471d1598977750-link-between-two-list-box-book1
Sheet: Sheet1

partner | Project
A | 6001 |  |  |  |  | Partner list |  |  |  | Project list
A | 6004
B | 6002
A | 6007
B | 6008
A | 6005
B | 6003
C | 6012
A | 6154
C | 6009
C | 6017
B | 6011
A | 6010
Spreadsheet: 114231d1310032981-add-cells-that-match-certain-conditions-sample-2
Sheet: Sheet1

PARTICULARS | qty
[NAME] | sum of all corn
WHITE CORN | sum of all white corn
COOKED  CORN | sum of all cooked corn
US SOYA | sum of all us soya
ARGENTINA SOYA | sum of all argentina soya
FULL FAT SOYA | etc
POLLARD | etc
SOFT WHEAT
GOLD LEAF MILK
SEROLAT-GOLD LEAF
SEROLAT
SUSTAGEN
TAPIOCA GELING
FISHMEAL
PEPTIVA SEW
PEPTIVA SWINE
DIAMOND V
COCO OIL
WHEY POWDER  [NAME]
WHEY POWDER DEPRO
MOLLASES
D1
COPRA
[NAME]
SKIM MILK
[NAME]
[NAME]
LIMESTONE
SUNBIO 888
PROTI YEAST
YEAST/PRO
SALT
L THREONINE
L THREONINE
DL METHIONINE
LYSINE
L TRYPTOPHAN
VITAMIN CONCENTRATE
VITAMIN CONC. Premix
VITAMIN C
VITAMIN E
WHEAT ENZYME
CHOLINE 50
ZINC OXIDE
LUCTACID HC
CITRINAL
APSACID  F
T5X
TX 5
ORGANIC MINERALS ORDINARY
LACTATING MINERAL
PIGLET MINERAL
PROTEXIN
PHYTASE POWDER
YUCCA DEODORIZER
IRION MIN. AMINO ACID
ANTI OXIDANT
[NAME]
SELPLEX
COLISTINE 12%
LINCOMYCIN PREMIX
[NAME]
BROMEXIN PREMIX
BROMEXIN PUREFORM
SPECTINOMYCIN PUREFORM
DOXY PUREFORM
CSP 500 PREMIX
CIPRO PUREFORM
FLORPENICOL PUREFORM
CAPSOZYME
OXY
BIOTIN
TMP PUREFORM
TOXIDEST
SULFADIAZINE
LEAN MEATER
CHELATED ZINC
AMOX PUREFORM
TYLOSIN PUREFORM
BETAIN
CALCIUM LACTATE
TIAMULIN PUREFORM
TILMICOSIN
MINERAL PREMIX
VITAMIN C ( HUAWEI )
BIOSEB PRO 8
WHEAT ENZYME
EGG POWDER
CSP 500 PREMIX
SUSTAGEN
CROMIUM
D-3
L-TRYPTOPHAN
PR0TEXIN CONCENTRATE
CTC 15%GRANULAR
COOKED  CORN
APSACID  F
BETAIN
ARBOCEL
TAPIOCA
CITRINAL
A-MAX
AMOX PUREFORM
SULFAMETHOXAZOLE
MINERAL PREMIX
EGG POWDER
D-3
SKIM MILK
ARBOCEL
SUFAMETHAZINE
NEOMYCIN
VITAMEN PREMIX
NEVRO VIT CONC.
HERBO-C COLIGREEN
MILK FIT POWDER
SUSTAGEN
SKIM MILK
FIBERCEL
TILLAMOK WHEY
CRINO WHEY POWDER
LEVERGREEN
HEATGROW
MILKFIT
D-3
D-3
CHOLINE CORN COB
CHOLINE SELICA
DEPRO WHEY POWDER
TYLOSIN PUREFORM
COPPER AMINO ACID 20%
IRON AMINO ACID 20%
ZINC AMINO ACID 20%
COBALT AMINO ACID 20%
SELENIUM AMINO ACID 20%
POTASSIUM IODIDE
BALAKOBAK
LySOFORTE
LYSOFORTE
MANGANES
DOXY PUREFORM
LINCOSPICTIN PREMIX
ANTI-MOLD
GLOBIN POWDER
SULFAMETHAZENE
TIAGRAM
DOXY PUREFORM
[NAME]
[NAME] WHEY
L-VALINE
L-ARGENINE
ATOX
Spreadsheet: 882840d1731324187-extract-multipple-informations-from-columns-work
Sheet: Feuil1

Date | 20241111 | 20241112 | 20241113 | 20241114 | 20241115
Job1 | 1 |  | 1 | 2
Job2 |  | 2 |  | 1
Job3 | 2
Job4 |  |  | 3
Visa1 | AAA |  | [NAME]
Visa2 | GGG | HHH |  | GZG
Visa3 |  |  | NNN
Spreadsheet: 6b0298ad-1bdc-4cf4-9058-57030365fd7e
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-02-19 14:02:12.160000
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.409 | 102.284 | 102.159 | 101.784
4.5 | 101.496 | 101.371 | 101.246 | 100.871 |  | Note: | Refer To Price [NAME]
4.375 | 100.531 | 100.406 | 100.281 | 99.906 |  |  | For all Price Adjs
4.25 | 99.921 | 99.796 | 99.671 | 99.046
4.125 | 99.101 | 98.976 | 98.851 | 98.226
4 | 98.086 | 97.961 | 97.836 | 97.211
3.875 | 97.038 | 96.913 | 96.788 | 96.163
3.75 | 96.163 | 96.038 | 95.913 | 95.288
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.473 | 102.348 | 102.223 | 101.848
3.75 | 102.375 | 102.25 | 102.125 | 101.75
3.625 | 101.974 | 101.849 | 101.724 | 101.349
3.5 | 101.398 | 101.273 | 101.148 | 100.523
3.375 | 100.648 | 100.523 | 100.398 | 99.773
3.25 | 99.859 | 99.734 | 99.609 | 98.984 |  | 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-05 14:02:12.160000
30 DAY | 2014-03-20 14:02:12.160000
45 DAY | 2014-04-04 14:02:12.160000
60 DAY | 2014-04-19 14:02:12.160000
90 DAY | 2014-05-19 14:02:12.160000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 799970d1665420068-cell-value-dependent-on-2-other-cells-metadata-example
Sheet: Table Values

G35 Workpack Descriptions |  |  |  |  |  |  | G35 WP DISC
Workpack Ref | Description | CIVIL | ELECTRICAL | INSTRUMENT AND SOFTWARE | MECHANICAL |  | CIVIL
WP01 | Decommissioning Unit C AND D | WOO-GTX0013-CV-G35PB-0001 | WOO-GTX0013-EL-G35PB-0001 | WOO-GTX0013-IN-G35PB-0001 | WOO-GTX0013-ME-G35PB-0001 |  | ELECTRICAL
WP02 | UPS | WOO-GTX0013-CV-G35PB-0002 | WOO-GTX0013-EL-G35PB-0002 | WOO-GTX0013-IN-G35PB-0002 | WOO-GTX0013-ME-G35PB-0002 |  | INSTRUMENT AND SOFTWARE
WP03 | Demolition of SCADA and Console Furniture | WOO-GTX0013-CV-G35PB-0003 | WOO-GTX0013-EL-G35PB-0003 | WOO-GTX0013-IN-G35PB-0003 | WOO-GTX0013-ME-G35PB-0003 |  | MECHANICAL
WP04 | Installation of SCADA Systems | WOO-GTX0013-CV-G35PB-0004 | WOO-GTX0013-EL-G35PB-0004 | WOO-GTX0013-IN-G35PB-0004 | WOO-GTX0013-ME-G35PB-0004
WP05 | Station Control | WOO-GTX0013-CV-G35PB-0005 | WOO-GTX0013-EL-G35PB-0005 | WOO-GTX0013-IN-G35PB-0005 | WOO-GTX0013-ME-G35PB-0005
WP06 | Station Protection | WOO-GTX0013-CV-G35PB-0006 | WOO-GTX0013-EL-G35PB-0006 | WOO-GTX0013-IN-G35PB-0006 | WOO-GTX0013-ME-G35PB-0006
WP07 | Fire and Gas Installation and Testing Inc SCADA | WOO-GTX0013-CV-G35PB-0007 | WOO-GTX0013-EL-G35PB-0007 | WOO-GTX0013-IN-G35PB-0007 | WOO-GTX0013-ME-G35PB-0007
WP08 | Cyber Security | WOO-GTX0013-CV-G35PB-0008 | WOO-GTX0013-EL-G35PB-0008 | WOO-GTX0013-IN-G35PB-0008 | WOO-GTX0013-ME-G35PB-0008
WP09 | Telemetry | WOO-GTX0013-CV-G35PB-0009 | WOO-GTX0013-EL-G35PB-0009 | WOO-GTX0013-IN-G35PB-0009 | WOO-GTX0013-ME-G35PB-0009
WP10 | Fuel Gas Install Unit A and B | WOO-GTX0013-CV-G35PB-0010 | WOO-GTX0013-EL-G35PB-0010 | WOO-GTX0013-IN-G35PB-0010 | WOO-GTX0013-ME-G35PB-0010
WP11 | Instrumentation Install (All Instruments) | WOO-GTX0013-CV-G35PB-0011 | WOO-GTX0013-EL-G35PB-0011 | WOO-GTX0013-IN-G35PB-0011 | WOO-GTX0013-ME-G35PB-0011
WP12 | Meters and [NAME] | WOO-GTX0013-CV-G35PB-0012 | WOO-GTX0013-EL-G35PB-0012 | WOO-GTX0013-IN-G35PB-0012 | WOO-GTX0013-ME-G35PB-0012
WP13 | [NAME] | WOO-GTX0013-CV-G35PB-0013 | WOO-GTX0013-EL-G35PB-0013 | WOO-GTX0013-IN-G35PB-0013 | WOO-GTX0013-ME-G35PB-0013
WP14 | Unit A and B Protection | WOO-GTX0013-CV-G35PB-0014 | WOO-GTX0013-EL-G35PB-0014 | WOO-GTX0013-IN-G35PB-0014 | WOO-GTX0013-ME-G35PB-0014
WP15 | Flooring and Sub Frames | WOO-GTX0013-CV-G35PB-0015 | WOO-GTX0013-EL-G35PB-0015 | WOO-GTX0013-IN-G35PB-0015 | WOO-GTX0013-ME-G35PB-0015
WP16 | Unit A and B Control | WOO-GTX0013-CV-G35PB-0016 | WOO-GTX0013-EL-G35PB-0016 | WOO-GTX0013-IN-G35PB-0016 | WOO-GTX0013-ME-G35PB-0016
WP17 | Unit E Protection | WOO-GTX0013-CV-G35PB-0017 | WOO-GTX0013-EL-G35PB-0017 | WOO-GTX0013-IN-G35PB-0017 | WOO-GTX0013-ME-G35PB-0017
WP18 | Unit E Control | WOO-GTX0013-CV-G35PB-0018 | WOO-GTX0013-EL-G35PB-0018 | WOO-GTX0013-IN-G35PB-0018 | WOO-GTX0013-ME-G35PB-0018
Spreadsheet: 61870d1262787178-ordering-question-excel-order-help
Sheet: Sheet1

Is it possible to give sets of numbers an order?
Example below:
(The order is based on the Date - But as long as everything is sorted acording to date in the first place, 'Date' may not even be needed in the final formula).
Date | Sets of Numbers | Order (This is what I need a formula for)
2009-12-03 00:00:00 | 2567852 | 1
2009-12-04 00:00:00 | 2567852 | 2
2009-12-05 00:00:00 | 2567852 | 3
2009-12-06 00:00:00 | 2567852 | 4
2009-12-07 00:00:00 | 2567852 | 5
2009-12-04 00:00:00 | 1846758 | 1
2009-12-05 00:00:00 | 1846758 | 2
2009-12-06 00:00:00 | 1846758 | 3
2009-12-06 00:00:00 | 2457895 | 1
2009-12-07 00:00:00 | 2457895 | 2
2009-12-08 00:00:00 | 2457895 | 3
2009-12-09 00:00:00 | 2457895 | 4
2009-12-10 00:00:00 | 2457895 | 5
2009-12-22 00:00:00 | 3568974 | 1
2009-12-12 00:00:00 | 1245678 | 1
2009-12-13 00:00:00 | 1245678 | 2
2009-12-14 00:00:00 | 1245678 | 3
2009-12-15 00:00:00 | 1245678 | 4
2009-12-09 00:00:00 | 2352564 | 1
2009-12-10 00:00:00 | 2352564 | 2
Spreadsheet: 34204d1231349832-margin-calcs-help-667634
Sheet: Sheet1

Margin | Invoice Amt | 1
0.4 | 75 | 6.75
0.406 | 75 | 6.75
0.196952 | 52.5 | 1.575
0.196952 | 52.5 | 1.575
0.401537 | 136.6 | 12.294
0.352127 | 30.33 | 2.1231
0.352127 | 30.33 | 2.1231
0.350791 | 20.12 | 1.4084
0.350791 | 20.12 | 1.4084
0.234561 | 511.96 | 20.4784
0.234561 | 511.96 | 20.4784
0.450081 | 61.5 | 6.15
0.450081 | 61.5 | 6.15
0.368102 | 1198.8 | 95.904
0.368102 | 1198.8 | 95.904
0.351173 | 139.76 | 9.7832
0.351173 | 139.76 | 9.7832
0.350843 | 96.14 | 6.729800000000001
0.350843 | 96.14 | 6.729800000000001
0.401038 | 25.06 | 2.2554
0.401038 | 25.06 | 2.2554
0.4 | 605.55 | 54.49949999999999
0.4 | 605.55 | 54.49949999999999
0.4 | 27.7 | 2.493
0.4 | 27.7 | 2.493
0.4 | 585 | 52.65
0.4 | 585 | 52.65
0.4 | 65 | 5.85
0.4 | 65 | 5.85
0.378431 | 329.53 | 26.3624
Margin | OPT 1 | OPT 2 | OPT 3 | OPT 4 | OPT 5
0.15 | 0.03 | 0.03 | 0.01 | 0 | 0.01
0.2 | 0.04 | 0.04 | 0.03 | 0.05 | 0.02
0.24 | 0.05 | 0.05 | 0.05 | 0.06 | 0.04
0.28 | 0.06 | 0.06 | 0.06 | 0.07 | 0.05
0.32 | 0.07 | 0.08 | 0.07 | 0.08 | 0.06
0.36 | 0.08 | 0.1 | 0.1 | 0.09 | 0.08
0.4 | 0.09 | 0.11 | 0.11 | 0.1 | 0.1
0.44 | 0.1 | 0.13 | 0.12 | 0.11 | 0.12
0.48 | 0.11 | 0.14 | 0.13 | 0.12 | 0.14
0.52 | 0.12 | 0.15 | 0.14 | 0.13 | 0.15
0.56 | 0.13 | 0.17 | 0.15 | 0.14 | 0.17
0.6 | 0.14 | 0.18 | 0.16 | 0.15 | 0.18
0.64 | 0.15 | 0.2 | 0.17 | 0.16 | 0.19
0.72 | 0.16 | 0.21 | 0.19 | 0.17 | 0.2
0.76 | 0.17 | 0.22 | 0.2 | 0.18 | 0.2
0.8 | 0.18 | 0.23 | 0.21 | 0.19 | 0.2
0.84 | 0.19 | 0.24 | 0.22 | 0.2 | 0.2
0.88 | 0.2 | 0.25 | 0.23 | 0.21 | 0.2
0.92 | 0.2 | 0.25 | 0.24 | 0.22 | 0.2
0.96 | 0.2 | 0.25 | 0.25 | 0.23 | 0.2
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk6

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 711575d1609784449-reversing-formula-breaks-if-input-too-long-reverse-sequence-output-error-1-
Sheet: Sheet1

Input Sequences | Sequence Output | Reversed sequence output | Reverse Delimited Sequence
A*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrA*A*rA*A*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrA*A*rA*A*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrA*A*rA*A*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrA*A*rA*A*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrA*A*rA*A*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrAA*rA*rCAGCTrA*A*rA
Spreadsheet: 732434d1620948080-matching-ids-with-rank-in-a-specific-order-sample
Sheet: Sheet1

ID | RANK | Expected Output
2019-05-04GCO1 | 1 | Yes | <--- Rank 2 does not exist with these two ID's, so I need Rank 1
2019-05-04GCO1 | 3
2019-05-04FLE1 | 1
2019-05-04FLE1 | 2 | Yes | <--- Rank 2 does exist here, so flag it as a Yes
2019-05-04KEN2 | 1 | Yes | <-- There is only one Rank for this ID, so flag it as a Yes
2019-05-04FLE2 | 2 | Yes | <--- Rank 2 does exist here, so flag it as a Yes
2019-05-04FLE2 | 3
2019-05-04MOP1 | 3 | Yes | <--- Rank 2 does not exist with these three ID's, so I need Rank 3 as it is the lowest number
2019-05-04MOP1 | 4
2019-05-04MOP1 | 5
2019-05-04KEN3 | 1 | Yes | <--- Rank 2 does not exist with these two ID's, so I need Rank 1 as it is the lowest number
2019-05-04KEN3 | 5
Spreadsheet: 802966d1667183837-weighted-raffle-weighted-raffle
Sheet: Member

Name | did thing | did other thing | Raffle Eligibility | Tickets | % Weight | Helper
1 | True | True |  | 1
2 | False | False |  | 1
3 | True | True |  | 0
4 | True | True |  | 2
5 | False | False |  | 0
6 | True | True |  | 2
7 | True | True |  | 2 |  |  | Total Tickets:
8 | True | True |  | 0 |  |  | Random Number:
9 | True | True |  | 0 |  |  | Winner:
10 | True | True |  | 1
11 | False | False |  | 0
12 | True | True |  | 2
13 | True | True |  | 2
14 | True | True |  | 0
15 | True | True |  | 0
16 | False | False |  | 1000000
17 | True | True |  | 2
18 | True | True |  | 1
19 | True | True |  | 0
20 | False | False |  | 0
21 | False | False |  | 0
22 | True | True |  | 2
23 | False | False |  | 2
Spreadsheet: 486817d1477673525-increase-number-in-cell-based-on-value-in-adjacent-cell-book2
Sheet: Sheet1

value 1 | value 2 | value 3
a | 1
Disti | 2
c | 3
Disti | 4
s | 5
e | 6
f | 7
Disti | 8
h | 9
Spreadsheet: 848615d1699316826-real-beginner-question-how-to-avoid-repetitive-autofill-actions-book1
Sheet: Sheet1

0
1
2
3
99
100
101
102
199
200
201
202
349
350