tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7a54c3e2-b20e-41ed-8642-292213907060
Sheet: Sheet1

Table S1. Constructs used. | Unnamed: 1 | Unnamed: 2
[NAME] | Nucleotide sequence | Reference
 | Amino acid sequence
ftz constructs
MHC | AUGGUACCGUGCACGCUGCUCCUGCUGUUGGCGGCCGCCCUGGCUCCGACUCAGACCCGCGCGACCAUG | Palazzo et. al., 2007
 | M  V  P  C  T  L  L  L  L  L  A  A  A  L  A  P  T  Q  T  R  A  T  M
2Ile-MHC | AUGGUACCGUGCACGCUGAUCCUGCUGAUUGCGGCCGCCCUGGCUCCGACUCAGACCCGCGCGACCAUG | This study
 | M  V  P  C  T  L  I  L  L  I  A  A  A  L  A  P  T  Q  T  R  A  T  M
INS | AUGGCCCUGUGGAUGCGCCUCCUGCCCCUGCUGGCGCUGCUGGCCCUCUGGGGACCUGACCCAGCCGCAGCCAUG | Palazzo et. al., 2007
 | M  A  L  W  M  R  L  L  P  L  L  A  L  L  A  L  W  G  P  D  P  A  A  A  M
2Ile-INS | AUGGCCCUGUGGAUGCGCAUCCUGCCCCUGCUGGCGCUGCUGGCCAUCUGGGGACCUGACCCAGCCGCAGCCAUG | This study
 | M  A  L  W  M  R  I  L  P  L  L  A  L  L  A  I  W  G  P  D  P  A  A  A  M
7A-INS | AUGGCACUGUGGAUGCGACUCCUACCCCUACUGGCACUGCUAGCCCUAUGGGGACCUGACCCAGCCGCAGCCAUG | This study
 | M  A  L  W  M  R  L  L  P  L  L  A  L  L  A  L  W  G  P  D  P  A  A  A  M
PTH | AUGAUACCUGCAAAAGACAUGGCUAAAGUUAUGAUUGUCAUGUUGGCAAUUUGUUUUCUUACAAAAUCGGAUGGCAUG | Cenik et. al., 2011
 | M  I  P  A  K  D  M  A  K  V  M  I  V  M  L  A  I  C  F  L  T  K  S  D  G  M
PRP | AUGGCGAACCUUAGCUACUGGCUGCUGGCACUCUUUGUGGCUAUGUGGACUGAUGUUGGCCUCUGCAUG | Cenik et. al., 2011
 | M  A  N  L  S  Y  W  L  L  A  L  F  V  A  M  W  T  D  V  G  L  R  M
FS-MHC | AUGGGUACCGUGCACGCUGCUCCUGCUGUUGGCGGCCGCCCUGGCUCCGACUCAGACCCGGCGACCAUG | Palazzo et. al., 2007
 | M  G  T  V  H  A  A  P  A  V  G  G  R  P  G  S  D  S  D  P  A  T  M
CALR constructs
CALR | AUGCUGCUAUCCGUGCCGCUGCUGCUCGGCCUCCUCGGCCUGGCCGUCGCCGAG | -
 | M  L  L  S  V  P  L  L  L  G  L  L  G  L  A  V  A  E
4Ile-CALR | AUGCUGAUAUCCGUGCCGCUGCUGAUCGGCAUCAUCGGCCUGGCCGUCGCCGAG | This study
 | M  L  I  S  V  P  L  L  I  G  I  I  G  L  A  V  A  E
BiP
BiP | ATGAAGCTCTCCCTGGTGGCCGCGATGCTGCTGCTGCTCAGCGCGGCGCGGGCCGAG | -
 | M  K  L  S  L  V  A  A  M  L  L  L  L  S  A  A  R  A  E
Nucleotides and encoded amino acid sequences for all for all ftz and CALR constructs.
Note that all nucleotide and amino acid substitutions in 2Ile-MHC, 2Ile-INS, 7A-INS and 4Ile-CALR are in bold.
Spreadsheet: 25271d1216408522-last-date-used-example-excel-issue
Sheet: Item List

Last Date Purchased | Last Date Sold | Last Date Adjusted | Item No. | Description
2008-06-25 00:00:00 | 2008-06-27 00:00:00 | 2008-06-04 00:00:00 | 51660 | WIF WIX FILTERS
 |  | 2008-06-04 00:00:00 | 51664 | WIX FILTER
2008-04-15 00:00:00 | 2008-07-16 00:00:00 | 2007-11-05 00:00:00 | 51669 | WIX OIL FILTER
 |  | 2007-11-05 00:00:00 | 51673 | WIF WIX FILTER
 |  | 2007-11-05 00:00:00 | 51674 | WIX FUEL FILTER
 |  | 2007-11-05 00:00:00 | 51675 | WIF WIX FILTERS
 |  | 2007-11-05 00:00:00 | 51678 | WIX FILTER
 |  | 2007-11-05 00:00:00 | 51683 | WIF WIX FILTERS
 |  | 2007-11-05 00:00:00 | 51694 | FILTER
 |  | 2007-11-05 00:00:00 | 51720 | WIX HYDRAULIC FILTER
Spreadsheet: 153077d1335757814-excel-2007-new-drop-down-menu-based-on-dropdown-menu-in-previous-cell-weld-distance
Sheet: Modifiers

 | ASME B36.10M | P26-2TS | P4-1TS
 | NPS | Trunnion pad width | Branch pad width
 |  | [NAME] | [NAME]
 | 0 | 0 | 0
 | 1/8 | 0 | 0
 | 1/4 | 0 | 0
 | 3/8 | 0 | 0
 | 1/2 | 0 | 0
 | 3/4 | 0 | 0
 | 1 | 0 | 0
 | 1.25 | 0 | 0
 | 1.5 | 50 | 50
 | 2 | 50 | 50
 | 2.5 | #N/A | #N/A
 | 3 | 50 | 50
 | 3.5 | #N/A | #N/A
 | 4 | 50 | 50
 | 5 | #N/A | #N/A
 | 6 | 50 | 75
 | 8 | 75 | 100
 | 10 | 75 | 125
 | 12 | 75 | 150
 | 14 | 75 | 175
 | 16 | 75 | 200
 | 18 | 100 | 225
 | 20 | 100 | 250
 | 22 | #N/A | #N/A
 | 24 | 100 | 300
 | 26 |  | 330
 | 28 |  | 355
 | 30 | 150 | 380
 | 32 |  | 405
 | 34 |  | 430
 | 36 | 225 | 455
 | 38 |  | 480
 | 40 |  | 505
 | 42 | 300 | 535
 | 44 |  | 560
 | 46 |  | 585
 | 48 | 380 | 610
 | 52 |  | 660
 | 56 | #N/A | #N/A
 | 60 |  | 760
 | 64 | #N/A | #N/A
 | 68 | #N/A | #N/A
 | 72 |  | 915
 | 76 | #N/A | #N/A
 | 80 |  | 1015
Spreadsheet: 151218d1334833116-pivot-table-how-to-sort-drop-down-lists-da6126-ctreconciler-redacted_reply
Sheet: CT Journal

Version | 2012-04-16-01 | CT Journal
MWH Ref | 0
Taxpayer name | 0
CT ref | 0
Control account | CT (734, 735, 831, 832, 833)
Run date/time | 2012-04-19 16:25:30
 |  | APE | 2012-04-30 00:00:00
 |  | Sum of Movement total £ Dr/(Cr) | Processed?
 |  | Account | FALSE | Grand Total
 |  | 771 BS Bank | -3866.68 | -3866.68
 |  | 485 PL Int | 66.68 | 66.68
 |  | Grand Total | -3800 | -3800
Spreadsheet: 258bacea-b451-4709-84af-560fe58ec3ea
Sheet: Sheet1

Pump - Logbook | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25
Date |  | MN | 1 AM | 2 AM | 3 AM | 4 AM | 5 AM | 6 AM | 7 AM | 8 AM | 9 AM | 10 AM | 11 AM | NOON | 1 PM | 2 PM | 3 PM | 4 PM | 5 PM | 6 PM | 7 PM | 8 PM | 9 PM | 10 PM | 11 PM
 | BG
 | [NAME]
 | Bolus
 | Correction
1900-01-01 00:00:00 | BG
 | [NAME]
 | Bolus
 | Correction
1900-01-02 00:00:00 | BG
 | [NAME]
 | Bolus
 | Correction
1900-01-03 00:00:00 | BG
 | [NAME]
 | Bolus
 | Correction
1900-01-04 00:00:00 | BG
 | [NAME]
 | Bolus
 | Correction
1900-01-05 00:00:00 | BG
 | [NAME]
 | Bolus
 | Correction
1900-01-06 00:00:00 | BG
 | [NAME]
 | Bolus
 | Correction
7 DAY AVERAGE
Spreadsheet: 690638d1597217261-formula-for-producing-customers-statement-customers-statement-2
Sheet: Customer Statement

Date | Invoice | Debit | Credit | Cumulative Balance |  | 100 |  |  | [NAME] | Customer  Name
 |  |  |  |  |  |  |  |  | 100 | Ok Mart
2020-08-01 00:00:00 | 1 |  |  |  |  |  |  |  | 101 | [NAME]
2020-08-10 00:00:00 | 1
2020-08-11 00:00:00 | 3 |  |  |  |  |  |  |  | 103 | ZIMNAT
2020-08-12 00:00:00 | 3
PLEASE NOTE:
1. It is capturing for OK Mart only ( but omits receipts G6 & G7) and other customers there is nothing
2. I wanted to automatically generated Date, Invoice number and Reference Number
Desired outcome
Date | Reference | Invoice | Debit | Credit | Cumulative Balance |  | 100 |  |  | [NAME] | Customer  Name
 |  |  |  |  | 2000 |  |  |  |  | 100 | Ok Mart
2020-08-01 00:00:00 | AA | 200 |  | 2000 |  |  |  |  |  | 101 | [NAME]
2020-08-01 00:00:00 |  | 1 | 11385 |  |  |  |  |  |  | 103 | ZIMNAT
2020-08-10 00:00:00 | AA1 | 1 |  | 10000
2020-08-11 00:00:00 |  | 3 | 9108
2020-08-12 00:00:00 | AA3 | 3 |  | 7500
2020-08-13 00:00:00 | AA5 | 1 |  | 1385
2020-09-14 00:00:00 | AA6 | 3 |  | 1608
Spreadsheet: 757706d1638418474-reverse-two-way-lookup-book1
Sheet: Sheet1

Shift | Operator | Date
 |  | 2021-12-01 00:00:00 | 2021-12-02 00:00:00 | 2021-12-03 00:00:00 | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 2021-12-10 00:00:00 | 2021-12-11 00:00:00 | 2021-12-12 00:00:00 | 2021-12-13 00:00:00 | 2021-12-14 00:00:00
Shift A | [NAME] | Day | Day | OT_Day |  |  | Day | Day |  |  | Day | Day | Day
Shift A | Lewis | Day | Day |  |  |  | Day | Day |  |  | Day | Day | Day
Shift A | [NAME] | Day | Day | OT_Day |  |  | Day | Day |  | OT_Day | Day | Day | Day
Shift A | [NAME] | Day | Day |  |  |  | Day | Day |  |  | Day | Day | Day | OT_Day
Shift B | [NAME] | Night | Night |  |  |  | Night | Night |  |  | Night | Night | Night | OT_Day
Shift B | Lucie | Night | Night |  |  |  | Night | Night |  |  | Night | Night | Night |  | OT_Night
Shift B | [NAME] | Night | Night | OT_Night |  | OT_Night | Night | Night |  |  | Night | Night | Night
Shift B | [NAME] | Night | Night |  |  |  | Night | Night |  |  | Night | Night | Night
Shift C | [NAME] |  |  | Day | Day | Day | OT_Night |  | Day | Day |  |  |  | Day | Day
Shift C | [NAME] |  |  | Day | Day | Day |  |  | Day | Day |  |  |  | Day | Day
Shift C | Vindy | OT_Night |  | Day | Day | Day | OT_Night |  | Day | Day |  |  |  | Day | Day
Shift C | Gillian | OT_Night |  | Day | Day | Day |  |  | Day | Day |  |  |  | Day | Day
Shift D | Gert |  | OT_Day | Night | Night | Night |  |  | Night | Night |  |  | OT_Night | Night | Night
Shift D | [NAME] |  |  | Night | Night | Night |  | OT_Day | Night | Night |  |  | OT_Day | Night | Night
Shift D | [NAME] |  |  | Night | Night | Night |  |  | Night | Night |  |  |  | Night | Night
Shift D | [NAME] |  |  | Night | Night | Night |  |  | Night | Night |  |  | OT_Night | Night | Night
Select Shift |  | Shift B |  | (OT) Overtime List |  |  |  | 1. Overtime recorded as OT_Day or OT_Night
Change Date |  | 2021-12-01 00:00:00 |  |  | Operator Name |  |  | 2. List all operators that come for overtime for specific shift(C20) and specific date(C21)
Select Shift Pattern |  | Night |  | 1
 |  |  |  | 2 |  |  | Gillian
 |  |  |  | 3
 |  |  |  | 4
Spreadsheet: 22b14d06-b58e-4972-9d98-cc5d74995da7
Sheet: Sheet1

University of Wisconsin-River Falls | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
Classified Exempt Leave Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Print on Salmon
Name:
Department: |  |  |  |  |  |  |  |  |  |  |  |  |  | *Because of FLSA standards and furlough requirements, you must report hours worked during the week when furlough time is taken.
Person ID
(as found on your earnings statement)
Pay Period: |  | thru
 | Change this
 | date only
Week 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Week 2
Day | Date | V | PH | LH | SL | SU |  | Day | SL | SU | XH* | *Hrs Worked |  | Day | Date | V | PH | LH | SL | SU | XH* | *Hrs Worked
Sunday |  |  |  |  |  |  |  | Sunday |  |  |  |  |  | Sunday
Monday |  |  |  |  |  |  |  | Monday |  |  |  |  |  | Monday
Tuesday |  |  |  |  |  |  |  | Tuesday |  |  |  |  |  | Tuesday
Wednesday |  |  |  |  |  |  |  | Wednesday |  |  |  |  |  | Wednesday
Thursday |  |  |  |  |  |  |  | Thursday |  |  |  |  |  | Thursday
Friday |  |  |  |  |  |  |  | Friday |  |  |  |  |  | Friday
Saturday |  |  |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday
Week 1 Total: |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  | Week 2 Total: |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | V | PH | LH | SL | SU |  |  | SL | SU | XH | *Hours worked
Biweekly Total: |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I verify the reported hours are correct.
 | Codes
V | Vacation |  |  |  |  |  |  |  |  |  |  |  |  | Employee signature
H | Holiday
PH | Personal Holiday |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
LH | Legal Holiday (include Saturday Holiday)
WC | Worker's Comp |  |  |  |  |  |  |  |  |  |  |  |  | Supervisor signature
SL | [NAME]
SU | Sabbatical Leave |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
XH | Furlough
Please forward completed forms to 218 North Hall
Spreadsheet: c4463201-ce21-4294-8eec-afa23661b67d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Wines offered in GBP per case of 12 bottles, 24 half-bottles or 6 magnums, unless otherwise indicated. 21 October 2014.  Wines lying in bond at London City Bond. E&O.E.  Prices exclude duty and VAT.  For all enquiries, please contact us at [EMAIL]
Region | Producer | Vintage | Wine | Condition | Cs | Bt | GBP Sell | Per | Size | Units | GBP/bt
[NAME] | - | 2001 | Cantegril | - | 14 | 8 | 130 | CS | 75cl | 176 | 10.83
[NAME] | - | 2009 | Carmes de Rieussec  (2nd wine of Rieussec) | - | 2 | - | 150 | CS | 75cl | 24 | 12.5
[NAME] | - | 2010 | Climens | - | 2 | - | 640 | CS | 75cl | 24 | 53.33
[NAME] | - | 2009 | Climens | - | 1 | - | 580 | CS | 37.5cl | 24 | 24.17
[NAME] | - | 2006 | Climens | - | - | 6 | 330 | CS | 75cl | 6 | 27.5
[NAME] | - | 2005 | Climens | - | 4 | - | 550 | CS | 37.5cl | 96 | 22.92
[NAME] | - | 1990 | Climens | - | 1 | 10 | 1100 | CS | 75cl | 22 | 91.67
[NAME] | - | 1989 | Climens | - | 1 | - | 820 | CS | 75cl | 12 | 68.33
[NAME] | - | 1988 | Climens | - | 1 | - | 880 | CS | 75cl | 12 | 73.33
[NAME] | - | 2007 | [NAME] | - | 2 | - | 280 | CS | 75cl | 24 | 23.33
[NAME] | - | 2002 | [NAME] | - | - | 6 | 200 | CS | 75cl | 6 | 16.67
[NAME] | - | 2010 | [NAME] | - | - | 6 | 275 | CS | 75cl | 6 | 22.92
[NAME] | - | 2009 | [NAME] | - | 3 | - | 300 | CS | 37.5cl | 72 | 12.5
[NAME] | - | 2009 | [NAME] | - | 2 | - | 290 | CS | 75cl | 24 | 24.17
[NAME] | - | 2005 | [NAME] | - | 2 | - | 230 | CS | 75cl | 24 | 19.17
[NAME] | - | 2010 | [NAME] | - | 6 | - | 220 | CS | 75cl | 72 | 18.33
[NAME] | - | 2009 | [NAME] | - | 3 | - | 220 | CS | 37.5cl | 72 | 9.17
[NAME] | - | 2007 | Malle | - | 4 | - | 230 | CS | 75cl | 48 | 19.17
[NAME] | - | 2009 | [NAME] | - | 2 | - | 220 | CS | 75cl | 24 | 18.33
[NAME] | - | 2007 | Rieussec | - | 4 | - | 320 | CS | 75cl | 48 | 26.67
[NAME] | - | 2006 | Rieussec | - | 27 | 1 | 310 | CS | 75cl | 325 | 25.83
[NAME] | - | 2007 | Suduiraut | - | 4 | - | 340 | CS | 75cl | 48 | 28.33
[NAME] | - | 2005 | Tour Blanche | - | 4 | - | 320 | CS | 37.5cl | 96 | 13.33
[NAME] | - | 2011 | Yquem | - | - | 6 | 2600 | CS | 75cl | 6 | 216.67
[NAME] | - | 2011 | Yquem | - | - | 12 | 2600 | CS | 37.5cl | 12 | 108.33
[NAME] | - | 2006 | Yquem | - | 4 | - | 1940 | CS | 75cl | 48 | 161.67
[NAME] | - | 2003 | Yquem | - | 1 | - | 1500 | CS | 37.5cl | 24 | 62.5
[NAME] | - | 2001 | Yquem | - | - | 12 | 4600 | CS | 37.5cl | 12 | 191.67
[NAME] | - | 1995 | Yquem | - | 5 | - | 1480 | CS | 75cl | 60 | 123.33
[NAME] | - | 1988 | Yquem | - | 1 | - | 2970 | CS | 75cl | 12 | 247.5
Spreadsheet: 53592d1253547070-transferring-data-from-many-sheets-to-a-single-sheet-bank-sample
Sheet: Sheet1

Kotak Mahindra Bank
Clearing Dt | Issue Dt | Dr/Cr | Particulars | Chq No | Deposits | Withdrawal | Balance | Remarks
 |  |  | Opening |  |  |  | 94462.69
2009-06-30 00:00:00 | 2009-06-27 00:00:00 | Cr | Royal Securities | 000821 |  | 8000 | 86462.69
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | G.G. Service Station | 000825 |  | 19636 | 66826.69
2009-06-30 00:00:00 | 2009-06-27 00:00:00 | Cr | Star enterprises | 000816 |  | 3321 | 63505.69
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | C.Cantt | 000823 |  | 25000 | 38505.69
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Dr | Cash Manpada |  | 80000 |  | 118505.69
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | Arihant Tyres | 000822 |  | 74500 | 44005.69
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Dr | FTD From 831.210.20 To 656.200.811 |  | 50528 |  | 94533.69
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Dr | RTGS RAVI ROAD LINES INDIA PVT LTD SHO |  | 375000 |  | 469533.69
2009-06-30 00:00:00 | 2009-06-30 00:00:00 | Cr | Contra |  |  | 500000 | -30466.31 |  | 46000
 | 2009-07-01 00:00:00 | Cr | Arihant Tyres |  |  | 21000 | -51466.31
 | 2009-07-01 00:00:00 | Cr | ABC Ltd. |  |  | 25000 | -76466.31
 | 2009-07-02 00:00:00 | Cr | [NAME] |  |  |  | -76466.31
 | 2009-07-03 00:00:00 | Dr |  |  | 250000 |  | 173533.69
 |  |  |  |  |  |  | 173533.69
 |  |  |  |  |  |  | 173533.69
 |  |  |  |  |  |  | 173533.69
Spreadsheet: 299887d1393320123-displaying-date-format-file-name-in-a-cell-24-02-14
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | (Full Filename)
 |  |  |  |  |  |  |  |  | Filename with extension
 |  |  |  |  |  |  |  |  | Filename without extension
 |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Spreadsheet: 329762d1404399694-populate-a-column-based-on-a-value-from-another-range-help-1-
Sheet: List

Date | Site | 2014-06-30 00:00:00 | 2014-07-01 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-05 00:00:00 | 2014-07-06 00:00:00 | 2014-07-07 00:00:00
Name |  |  | 2 | 1 | 1 |  |  | 2
[NAME] | E |  | 1 |  |  |  |  | 1
[NAME] | E |  | 1 | 1
[NAME] | E |  | 1 |  | 1
[NAME] R | E |  | 1 | 1 |  |  |  | 1
Spreadsheet: 105810d1303108979-how-to-remove-s-0-9-and-spaces-regexp-sept-1-2004
Sheet: Ex 4 Test String Pattern

Menu Page
 | String | Test
 | 12Fred212 | 0
 | 221 Gray 122 | 1
 | 167Paul5167 | 0
 | abc33def768cba | 1
 | yesasey | 1
 | notme | 0
 | ghighi | 0
 | ACDC | 0
 | Glenelg | 1
 | 1010001 | 0
 | Macro | RegExp_Early_Test_4
 | Global | 0
 | Current Direction Pattern | ^(.)(.)(.).+(\3\2\1)$
 | Dave's Direction Pattern | ^(.)(.)(.).+(\3\2\1)$
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -2001 | -2139
2 | -79 | -2139
3 | -553 | -2453
4 | -1052 | -2453
5 | -1743 | -2453
6 | -1725 | -2453
7 | -1957 | -2139
8 | -1968 | -2139 |  |  |  |  |  |  |  |  | Avg
9 | -76 | -711 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10 | -800 | -2139
11 | -1249 | -2139 |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 | -1989 | -2139 |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 | -1956 | -2139 |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 | -1952 | -2139 |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 | -1924 | -2139 |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 | -530 | -2250 |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 | -528 | -2139 |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18 | -1187 | -2139
19 | -1956 | -1979
20 | -2023 | -625
21 | -1961 | -2139
22 | -1992 | -2139
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -394244.14
2001-08-22 00:00:00
CBS Volume
 |  |  | -68282
Spreadsheet: 477999d1472592516-put-name-and-number-in-different-cells-help-5
Sheet: Sheet1

What I got |  |  |  | What I want!
Smith Sr. 104 |  |  |  | Smith Sr. | 104
Smith Sr. 106 |  |  |  | Smith Sr. | 106
Smith Sr. 86 |  |  |  | Smith Sr. | 86
LaFell 103 |  |  |  | LaFell | 103
Smith Sr. 82 |  |  |  | Smith Sr. | 82
Smith Sr. 125 |  |  |  | Smith Sr. | 125
LaFell 64 |  |  |  | LaFell | 64
Smith Sr. 68 |  |  |  | Smith Sr. | 68
[NAME] 87 |  |  |  | [NAME] | 87
Naanee 75 |  |  |  | Naanee | 75
Smith Sr. 100 |  |  |  | Smith Sr. | 100
Spreadsheet: 63365d1264275120-vlookup-using-skip-column-temp_avk
Sheet: DATABANK

NAME | ADDRESS1 | ADDRESS2 | CITY | DISTRICT
A TO Z ENGINEERING | AAA | DDDF | ABCD | DCBA
A.A.ENARGY | BBB | FDF | BCDE | EDCB
A.D.C.C.PVT LTD. | CCC | DFD | CDEF | FEDC
A.D.STONE CRUSHER | DDD | EGG | DEFG | GFED
Spreadsheet: andy_zipper__754__10_23_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 63 | 200 | 300 | 43.9 | 65.8 | 2.17 | 2001-10-23 10:22:00
 | HO Z1 | 64 | 750 | 850 | 47.6 | 54 | 2.04 | 2001-10-23 10:22:00
 | HO F2 | 64 | 1030 | 1130 | 48.6 | 53.3 | 2.05 | 2001-10-23 10:22:00
 | HO G2 | 64 | 1290 | 1390 | 49.6 | 53.5 | 2.07 | 2001-10-23 10:22:00
 | [NAME] | 63 | 1300 | 1400 | 44.9 | 48.4 | 1.85 | 2001-10-23 10:22:00
 | HO J2 | 62 | 1270 | 1370 | 40.4 | 43.6 | 1.64 | 2001-10-23 10:22:00
 | HO K2 | 61 | 1250 | 1350 | 37.1 | 40 | 1.48 | 2001-10-23 10:22:00
 | HO M2 | 61 | 1290 | 1390 | 35.3 | 38.1 | 1.41 | 2001-10-23 10:22:00
 | HO N2 | 61 | 1200 | 1400 | 31 | 36.2 | 1.29 | 2001-10-23 10:22:00
 | HO Q2 | 61 | 1300 | 1500 | 31.8 | 36.8 | 1.32 | 2001-10-23 10:22:00
 | HO U2 |  | \ |  | 28.8 | 34.4 | 1.25 | 2001-10-12 14:53:00
 | [NAME] |  |  |  | 24.3 | 26.8 | 1.08 | 2001-08-20 15:41:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 704872d1605790315-based-on-condition-track-id-values-to-be-return-in-column-c-book1-2-
Sheet: Sheet1

Track ID | Total | Allowable value | Actual value |  |  | Track ID | Rate
 | Qty |  |  |  |  | 321563
321563 | 28 |  | 1256 |  |  | 215632
215632 | 50 |  | 213 |  |  | 236521 | 12
236521 | 200 |  | 154 |  |  | 695856 | 65
215632 | 142.5 |  | 5642 |  |  | 321564
695856 | 7.5 |  | 215 |  |  | 456527
215632 | 25 |  | 2365
321563 | 32 |  | 15263
321564 | 15 |  | 5265
321563 | 20.484 |  | 25416
456527 | 95 |  | 65896
 | expected Answer
Track ID | Total | Allowable value | Actual value
 | Qty
321563 | 28 |  | 1256
215632 | 50 |  | 213
236521 | 200 |  | 154
215632 | 142.5 |  | 5642
695856 | 7.5 |  | 215
215632 | 25 |  | 2365
321563 | 32 |  | 15263
321564 | 15 |  | 5265
321563 | 20.484 |  | 25416
456527 | 95 |  | 65896
Spreadsheet: 583479d1532453024-how-to-find-appropriate-prices-for-items-including-discount-price-example
Sheet: Sheet1

NAME | Q-TY | PRICE | SUM |  |  | NAME | Q-TY | PRICE | SUM |  |  |  | Sum
Item1 | 2300 | 1.68 |  |  |  | Item1 | 2300 |  |  |  |  |  |  |  | 2300 | 1.56
Item2 | 4500 | 1.72 |  |  |  | Item2 | 4500
Item3 | 1234 | 1.86 |  |  |  | Item3 | 1234
Item4 | 787 | 0.78 |  |  |  | Item4 | 787
 |  |  | 1000 | Discount |  |  |  |  |  | Total
 |  |  |  | Total
NAME | Q-TY | Discount | SUM | Price | Sum
Item1 | 2300
Item2 | 4500
Item3 | 1234
Item4 | 787
Spreadsheet: 674906d1588075250-sort-employees-in-roster-test-shops
Sheet: Sheet 2

 |  | 2020-06-01 00:00:00
 |  | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
Name | Locality of employee | 1 | 2
[NAME] | A | SP1
[NAME] | A
[NAME] | A
[NAME] | A | SP1
[NAME] | A
[NAME] | B | SP2
[NAME] | B
Terrell Barnes | B | SP2
[NAME] | B
[NAME]. | B
[NAME] | C
[NAME] | C
[NAME] | C | SP3
Jim Haynes | C | SP3
Kierra Gentry. | C
[NAME] | D | SP4
[NAME] | D | SP4
[NAME] | D
[NAME]. | D
[NAME] | E | SP5
Terence Edwards | E | SP5
Crystal Ryan | E | SP5
[NAME]. | E
[NAME] | F | SP6
[NAME] | F
[NAME] | F
[NAME] | F | SP6
Elias George | G
[NAME]. | G | SP7
[NAME] | G
[NAME] | G | SP7
[NAME]. | G
[NAME] | G
[NAME] | H
[NAME]. | H | SP8
[NAME] | H
[NAME] | H
[NAME]. | H | SP8
[NAME] | I
[NAME] | I | SP9
[NAME] | I
[NAME] | I | SP9
Spreadsheet: 3fbd0013-379c-4213-9b00-7e4ffcd62550
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
SGU | Test | SGU | Specific Gravity, [NAME] | Specific Gravity | Refractometer | [NAME]: Urine |  |  | 5 | mL | Container/Tube: 16x100 mm polypropylene tube [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. Keep specimen frozen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | 1.002-1.030 | Monday through Sunday; Continuously | Same day/1 day | Same day/1 day | 1 | 81005 |  |  |  |  | Rochester
SGU | [NAME] | URINE | [NAME] |  |  |  | Frozen | 7 days
SGU | Result | SGU | Specific Gravity | Specific Gravity | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5811-5 | Specific gravity:Rden:Pt:[NAME]:Qn:Test strip