tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842528d1694585188-dynamic-stock-overview-with-quantity-per-expiry-data-range-book1
Sheet: TO BE

Customer code 1
Customer code 2
Customer code 3
 |  | expires | expires | expires | expires | expires | expires | expires | expires | expires | expires | expires | expires | expires | expires | expires | expires
unique SKU list | Has no expiry date | Today | Tomorrow | in 3 days | in 4 days | in 5 days | in 6 days | in 7 days | between 1 and 2 weeks | Between 2 and 3 weeks | between 3 and 4 weeks | Between 1 and 2 months | Between 2 and 3 months | Between 3 and 4 months | Between 4 and 6 months | Between 6 and 12 months | Next year or later
based on customer code 1, 2 & 3 | quantity of stock
Sku status needs to be blank
Example 1
Customer code 1 | AZD
Customer code 2
Customer code 3
unique SKU list | Has no expiry date | Today | Tomorrow | in 3 days | in 4 days | in 5 days | in 6 days | in 7 days | between 1 and 2 weeks | Between 2 and 3 weeks | between 3 and 4 weeks | Between 1 and 2 months | Between 2 and 3 months | Between 3 and 4 months | Between 4 and 6 months | Between 6 and 12 months | Next year or later | Total on stock
40449 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
Example 2
Customer code 1 | AZD
Customer code 2 | BA2
Customer code 3
unique SKU list | Has no expiry date | Today | Tomorrow | in 3 days | in 4 days | in 5 days | in 6 days | in 7 days | between 1 and 2 weeks | Between 2 and 3 weeks | between 3 and 4 weeks | Between 1 and 2 months | Between 2 and 3 months | Between 3 and 4 months | Between 4 and 6 months | Between 6 and 12 months | Next year or later | Total on stock
40449 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
125194 |  |  |  |  |  |  |  |  |  |  |  |  | 1752 |  |  | 552 | 39
Spreadsheet: 66360d1267025823-solved-rotate-tranpose-data-719400
Sheet: Sheet3

City | Age | Persons |  | 6 |  | 0 | 1 | 2 | 3 | 4 | 5
X | 0 | 308 |  | 1
 | 1 | 327 |  | 2
 | 2 | 319 |  | 3
 | 3 | 313
 | 4 | 310
 | 5 | 358
Y | 0 | 361
 | 1 | 341
 | 2 | 366
 | 3 | 375
 | 4 | 344
 | 5 | 354
Z | 0 | 661
 | 1 | 631
 | 2 | 628
 | 3 | 608
 | 4 | 616
 | 5 | 564
Spreadsheet: gerald_nemec__11329__Kern Pmt 2 Calcs
Sheet: FMI Weld

FMI Weld |  |  |  |  |  |  | Appendix A
 | July |  |  | August |  |  | FMI Weld
Package 2 | 3700 |  |  | 3700 |  |  | July and August Payment Calculations
Total July
Actual Volume |  |  |  |  |  |  |  |  |  | JULY |  | AUGUST |  | TOTAL
 |  |  |  |  |  |  |  | ACTUAL VOLUME (1)
 |  |  | SoCal Basis
 |  |  | SoCal Index |  |  |  |  | MARKET PRICE (2)
Market Price |  |  | Total
 |  |  |  |  |  |  |  | SUPPLY PRICE (3)
 |  |  | Rockies Basis
 |  |  | Rockies Index |  |  |  |  | TARIFF RATE (4)
Supply Price |  |  | Total
 |  |  |  |  |  |  |  | PAYMENT RATIO
Spread |  |  | Spread
 |  |  |  |  |  |  |  | TOTAL PAYMENT
Total Spread Value
Tariff Rate |  |  | Tariff Rate |  |  |  |  | Payment as Calculated in Precedent Agreement:
Demand |  |  | Demand |  |  |  |  | Actual Volume * [(Market Price - Supply Price) - Tariff Rate] * Payment Ratio
Commodity |  |  | Commodity
Fuel Volume |  |  | Fuel | 0.097
Total Fuel Price |  |  | Total |  |  |  |  | (1) Actual volumes for July based on an 81.8% flow rate on 3,700 a day volume.
Total Tariff |  |  |  |  |  |  |  | August assumes 100% flows.
 |  |  |  |  |  |  |  | (2) August market price based on SoCal basis of $1.92 and index of ($1.42)
 |  |  | Net Income |  |  |  |  | (3) August supply price based on Rockies basis of ($[NAME]) and index of $.08
Net Income |  |  | Total Net Income |  |  |  |  | (4) Total estimated July tariffs of $104,114 versus total estimated August tariffs of $107,481.
 |  |  |  |  |  |  |  | Per unit total tariff is lower for July due to lower volume.
Payment Ratio | 0.25 |  | Payment
Total Payment |  |  | Total Payment
Spreadsheet: 886873d1736970970-compare-and-highlight-data-from-two-reports-test1
Sheet: Sheet1

Employee Identifier | First Name | Last Name | Position | Location | Job | Manager | Legal Entity
200 | Test1 | Test | Project Delivery - Project Manager | Remote - Project Delivery | Project Manager | Test 20 | Test Co
201 | Test2 | Test | Project Delivery - Senior Platform Engineer | Remote - Project Delivery | Senior Platform Engineer | Test 21 | Test Co
203 | Test3 | Test | Facility Operations - Director, Operations North America | Remote - Facility Operations | Director, Operations North America | Test 22 | Test Co
204.333333333333 | Test4 | Test | Facility Operations - Physical Security Program Manager | Remote - Facility Operations | Physical Security Program Manager | Test 23 | Test Co
205.833333333333 | Test5 | Test | Project Delivery - Project Manager | Remote - Project Delivery | Project Manager | Test 24 | Test Co
207.333333333333 | Test6 | Test | Investment and Capital Mkts - Director of Investments | Remote - Investment and Capital Mkts | Director of Investments | Test 25 | Test Co
208.833333333333 | [NAME] | Test | Executive - Chief Investment Officer | Remote - Executive | Chief Investment Officer | Test 26 | Test Co
210.333333333333 | Test8 | Test | Project Delivery - Regional Project Manager (West) | Remote - Project Delivery | Regional Project Manager (West) | Test 27 | Test Co
211.833333333333 | Test9 | Test | Investment and Capital Mkts - Associate of Investments | Remote - Investment and Capital Mkts | Associate of Investments | Test 28 | Test Co
Spreadsheet: 129730d1321852265-diagonal-updation-required-diagonal-v3
Sheet: Generated-2

 |  |  |  | 2011-10-01 00:00:00 | 0 | 1 | 2 | 3 | 4
 |  |  |  | 2011-10-02 00:00:00 | 1 | 5 | 8 | 10 | 15
 |  |  |  | 2011-10-03 00:00:00 | 2 | 6 | 9 | 14 | 20
 |  |  |  | 2011-10-04 00:00:00 | 3 | 7 | 13 | 19
 |  |  |  | 2011-10-05 00:00:00 | 4 | 12 | 18
 |  |  |  | 2011-10-06 00:00:00 | 11 | 17
 |  |  |  | 2011-10-07 00:00:00 | 16
 |  |  |  | 2011-10-08 00:00:00
Spreadsheet: 216072d1361570932-merging-similar-data-and-amounts-book11
Sheet: Sheet1

Doc No. | Amount | Vendor ID | Account | Description
111 | 5 | A123 | 555 | XXXXX
222 | 10 | B123 | 444 | XXXXX
111 | 5 | A123 | 555 | XXXXX
222 | 15 | B123 | 444 | XXXXX
Look like this:
111 | 10 | A123 | 555 | XXXXX
222 | 25 | B123 | 444 | XXXXX
Spreadsheet: 133440d1324398466-dynamic-addition-of-column-dependent-on-names-liteexample
Sheet: Sheet2

Employee |  | Department
[NAME], [NAME] |  | 100
Boche, Jared |  | 450
Despain, [NAME] |  | 110
[NAME], George |  | 210
Goodman, Lindsey |  | 335
Hall, [NAME] |  | 300
Hewitt, [NAME] |  | 200
Kingsley, Skip |  | 100
Moffit, Brett |  | 100
Payne, Glynn |  | 450
[NAME], Lola |  | 210
[NAME], [NAME] |  | 335
Spreadsheet: 157402d1337715914-sumifs-and-or-statement-05222012-sumifs-help-with-and-statement
Sheet: INSYTE

 |  |  |  |  | Acquistion Date: | 2010-05-14 00:00:00
NOTE NUM | LAST NAME | FIRST NAME | NAME | CLASS | OPENED DATE | CURRENT CHARGED OFF DATE | CNT | FDIC reimbursement %
40006625 | [NAME] | [NAME] | [NAME] | 90 | 2005-08-23 00:00:00 | 2009-07-30 00:00:00 | 1
40006805 | jones | [NAME] | [NAME] | 90 | 2005-10-14 00:00:00 | 2009-09-11 00:00:00 | 1
40006860 | mitchell | [NAME] | [NAME] | 9 | 2005-10-31 00:00:00 |  | 1
40007425 | hanson | [NAME] | [NAME] | 90 | 2006-04-13 00:00:00 | 2009-04-27 00:00:00 | 1
Spreadsheet: 761569d1641053618-erroneous-date-entries-from-csv-file-test
Sheet: test

ID_INDIVIDU | ID_FATHER | ID_MOTHER | Sex | PATRONYME | Given name | Birth | Birth_Date | Birth_Place | Occupation | Generation | Marriage | Marriage_Date | Marriage_Place | Death | Death_Date | Death_Place | Date | family child | Note | Place | Type
I10 | I12 | I13 | 0 | [NAME] | Livinus | Landbouwer (Smisstraat C4) | 31/10/1873 | Steenhuffel |  |  | Huwelijkscontract notaris [NAME] op 23/4 | 1901-04-26 00:00:00 | Steenhuffel |  | 1918-10-05 00:00:00 | Steenhuffel | 31 OCT 1873 |  |  | Steenhuffel
Spreadsheet: c49860ab-46fe-4573-9693-5faf817f051e
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 646657043023 | [NAME] | It'S All About You | 2006-02-07 | Compact Disc | Praise | 10.99 | Y | Available
Taseis | 646657043122 | [NAME] | Then & Now | 2008-01-29 | Compact Disc | Gospel | 10.99 | Y | Available
Spreadsheet: 751817d1634338199-help-needed-calculating-date-column-based-on-multiple-criteria-covid-0
Sheet: Sheet1

Exposure Date | Tier | Expected RTW Date | Cleared ISO?
2021-10-01 00:00:00 | 1 | 2021-10-16 00:00:00 | No
2021-10-02 00:00:00 | 1c | 2021-10-17 00:00:00 | No
2021-10-03 00:00:00 | 2 | 2021-10-06 00:00:00 | YES
2021-10-04 00:00:00 | 3 | 2021-10-04 00:00:00 | YES
Spreadsheet: 185518d1349743512-want-to-find-common-keywords-in-a-larger-column-using-another-column-example-3
Sheet: Main Keyword List

chewable prenatal
chewables prenatal
[NAME]
dha prenatal
[NAME]
dha supplements
diet prenatal
elite prenatal
maternity vitamins
multivitamin pregnancy
multivitamin prenatal
multivitamins pregnancy
multivitamins prenatal
pill prenatal
pills prenatal
plus prenatal
preconception vitamins
[NAME]
pregnancy multivitamin
pregnancy multivitamins
pregnancy supplements
pregnancy vitamin
pregnancy vitamins
pregnant vitamin
pregnant vitamins
prenatal chewable
prenatal chewables
prenatal dha
prenatal diet
prenatal elite
prenatal multivitamin
prenatal multivitamins
prenatal pill
prenatal pills
prenatal plus
prenatal supplement
prenatal supplements
prenatal vitamens
prenatal vitamin
prenatal vitamina
prenatal vitamines
prenatal vitamins
prenatal vitamis
prenatal vitiams
prenatal vitimans
prenatal vitimins
prenatal vitmains
prenatals vitamins
supplement dha
supplement prenatal
supplements dha
supplements pregnancy
supplements prenatal
prenatal vitamins
Spreadsheet: 57b0d414-934d-46c8-997b-144c4436fa6e
Sheet: River Analysis

 |  |  |  | 2012-13 Corn Exports |  |  | Weekly Pace Needed |  | Cumulative Weekly Inspections
 |  | Weeks |  | Export Sales |  |  |  |  | Inspections ([NAME]) |  |  |  |  |  | Inspections ([NAME])
Sales % of Projected exports | [NAME] of projected | Remaining | Date | Sales Needed to Meet WASDE | Shipments Needed to Meet WASDE | Actual Export Sales | [NAME] | Unshipped | Miss Gulf | 3-yr Ave | PNW | 3-Yr Ave | Total | 3-Yr Ave | Miss Gulf | 3-yr Ave | PNW | 3-Yr Ave | Cumulative Weekly Inspections | 3-Yr Ave
 |  | 52
 |  | 51
 |  | 50
 |  | 49
 |  | 48
 |  | 47
 |  | 46
 |  | 45
 |  | 44
 |  | 43
 |  | 42
 |  | 41
 |  | 40
 |  | 39
 |  | 38
 |  | 37
 |  | 36
 |  | 35
 |  | 34
 |  | 33
 |  | 32
 |  | 31
 |  | 30
 |  | 29
 |  | 28
 |  | 27
 |  | 26
 |  | 25
 |  | 24
 |  | 23
 |  | 22
 |  | 21
 |  | 20
 |  | 19
 |  | 18
 |  | 17
 |  | 16
 |  | 15
 |  | 14
 |  | 13
 |  | 12
 |  | 11
 |  | 10
 |  | 9
 |  | 8
 |  | 7
 |  | 6
 |  | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
 |  |  | 2012-13
 |  |  | Weekly pace
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | avg annual pace
Spreadsheet: 790273d1659619819-the-2nd-lowest-positive-value-4-formulae-2nd-lowest-hd
Sheet: Sheet1

 |  |  |  |  | P59001
-30 | P59001 | 1
-25 | P59001 | 51 |  |  | 2nd lowest rank | <-----
-3 | P59001 | 110 |  | [NAME]
0 | P59001 | 30
15 | P59001 | 2880 |  |  | 2nd lowest rank | <----
15 | P59001 | 33 |  | HansD
91 | P59001 | 20
45 | P59002 | 30 |  |  | 2nd lowest number
75 | P59003 | 1680 |  | HansD |  |  | I don't have now
 |  |  |  |  | 2nd lowest ?
 |  |  |  | Nick
Spreadsheet: 56667d1256813678-conditional-sums-help-project-date-example
Sheet: Summary

 |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Supplier 7
Supplier 8
Supplier 9
Supplier 10
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: PG&E

56698
Day | Scheduled | Measured
1 | 275537 | 278613
2 | 262499 | 267365
3 | 278050 | 280155
4 | 284260 | 287502
5 | 281989 | 283106
6 | 279075 | 281215
7 | 278417 | 280191
8 | 281054 | 284340
9 | 278159 | 281600
10
11
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 |  |  | 160058
2000-12-09 00:00:00
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 5 Science

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 5
Grade 5 Science MTAS-III
Raw Score | Scale Score*** | Level
0 | 110 | D
1 | 126 | D
2 | 136 | D
3 | 143 | D
4 | 148 | D
5 | 153 | D
6 | 158 | D
7 | 164 | D
8 | 169 | D
9 | 174 | D
10 | 178 | D
11 | 181 | D
12 | 184 | D
13 | 187 | D
14 | 190 | P
15 | 191 | P
16 | 194 | P
17 | 196 | P
18 | 198 | P
19 | 200 | M
20 | 202 | M
21 | 205 | M
22 | 208 | M
23 | 211 | M
24 | 215 | M
25 | 221 | M
26 | 225 | E
27 | 243 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2012 and 2008/2009/2010/2011 Science MTAS metrics are not comparable
****2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 792807d1661176101-averageif-based-on-partial-text-match-in-another-cell-example-spreadsheet-22-aug-2022
Sheet: Sheet1

Team | Score
CH/GG | 24
LT/CH | 52 |  |  | Individual | Average Score
GG/LT | 4 |  |  | CH
LT/CH | 54 |  |  | LT
GG/LT | 6 |  |  | GG
CH | 74
GG/LT | 6
Spreadsheet: 749103d1632503444-need-of-days-within-range-sorted-into-fiscal-periods-days-missed-per-fiscal-period-geobeck-
Sheet: Sheet1

 |  |  |  |  | Fiscal 1 | Fiscal 2 | Fiscal 3 | Fiscal 4 | Fiscal 5 | Fiscal 6 | Fiscal 7 | Fiscal 8 | Fiscal 9 | Fiscal 10 | Fiscal 11 | Fiscal 12 | Fiscal 13
 |  |  |  |  | 2021-08-01 00:00:00
Name | Injured | 1st Day | Last Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
[NAME] | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-09-05 00:00:00
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Kayak - Ian Findlater

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-06-10 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-06-10 00:00:00
Spreadsheet: 275482d1383542842-if-statement-woes-darkreign2409
Sheet: Test

2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00
Spreadsheet: 178767d1346914142-find-any-duplicates-and-eliminate-the-data-with-lower-level-of-priority-remove-duplicate
Sheet: Sheet2

No | Progressive MRB | Description | Customer | DN Number | prepare by | Start_Compile | MRB_Submission | End_Review | Incomplete | Inaccurate | No. of Doc per MRB | ReviewStatus | MRB_Result
0 | Historical Average  (Jul-Sep '09) | Historical Average  (Jul-Sep '09) |  |  |  |  |  | 2000-01-01 00:00:00 |  |  |  | Closed | Pass
1 | 111575489 | ASSEMBLY 36" ELEVATOR | BP ANGOLA |  |  | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-18 00:00:00 | 0 | 0 | 28 | Closed | Pass
2 | 111594747 | SEAL ASSY, METAL SEAL W/ ELASTOMER | BP ANGOLA |  |  | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-18 00:00:00 | 0 | 0 | 3 | Closed | Pass
3 | 111500065-01 | METAL END CAP SEAL | BP ANGOLA |  |  | 2009-12-08 00:00:00 | 2009-12-15 00:00:00 | 2009-12-18 00:00:00 | 0 | 0 | 3 | Closed | Pass
4 | 111575490 | ASSEMBLY 36" ELEVATOR | BP ANGOLA |  |  | 2009-12-15 00:00:00 | 2009-12-16 00:00:00 | 2009-12-18 00:00:00 | 0 | 0 | 28 | Closed | Pass
5 | 111598097 | ASSEMBLY, WELLHEAD HOUSING, 18-3/4, | METIS - USAN |  |  | 2009-12-28 00:00:00 | 2009-12-31 00:00:00 | 2010-01-03 00:00:00 | 1 | 1 | 44 | Closed | Fail
6 | 111568122 | CASING HANGER, BODY, 18-3/4 x 10-3/4 IN | METIS - USAN | 82969128 |  | 2009-12-28 00:00:00 | 2009-12-30 00:00:00 | 2010-01-04 00:00:00 | 0 | 0 | 18 | Closed | Pass
7 | 111632532-01 | ASSY, SPACER REPLACEMENT | METIS - USAN |  |  | 2009-12-30 00:00:00 | 2010-01-04 00:00:00 | 2010-01-06 00:00:00 | 0 | 0 | 12 | Closed | Pass
8 | 111632532-02 | ASSY, SPACER REPLACEMENT | METIS - USAN |  |  | 2009-12-30 00:00:00 | 2010-01-04 00:00:00 | 2010-01-06 00:00:00 | 0 | 0 | 12 | Closed | Pass
Spreadsheet: 100937d1299154814-matching-off-figures-in-different-cells-uncleslinky_test-1-
Sheet: Sheet4

Store Name | Loaned To Store/Borrowed From Store | Borrowed | Loaned
Store 1 | Store 6 | 4
Store 2 | Store 8 |  | 27
Store 2 | Store 9 |  | 10
Store 3 | Store 7 | 37
Store 3 | Store 5 | 10
Store 4 | Store 12 | 5
Store 5 | Store 8 | 14
Store 5 | Store 3 |  | 10
Store 6 | Store 1 |  | 4
Store 6 | Store 11 | 15 |  |  | Does Not Match Row20
Store 6 | Store 10 | 16
Store 7 | Store 3 |  | 37
Store 8 | Store 5 |  | 14
Store 8 | Store 2 | 27
Store 9 | Store 2 | 10
Store 10 | Store 6 |  | 16
Store 10 | Store 13 | 10
Store 11 | Store 13 | 5 |  |  | No Match
Store 11 | Store 6 |  | 14 |  | Does Not Match Row11
Store 12 | Store 4 |  | 5
Store 13 | Store 10 |  | 10
Spreadsheet: 58048d1258368003-time-values-time-minute-splits
Sheet: Sheet1

Position | Player | Split 1 | Rank | [NAME] | Rank | Split 3 | Rank | [NAME] | Rank | Time/Mins | Finish Rank
1 | [NAME] | 00:03:10 | 3 |  | #N/A |  | #N/A |  | #N/A | 00:01:00 | 1
2 | Martin | 00:02:10 | 2 |  | #N/A |  | #N/A |  | #N/A | 00:03:00 | 2
3 | Dominic | 00:02:00 | 1 |  | #N/A |  | #N/A |  | #N/A | 00:05:00 | 3
4 | [NAME] | 00:09:00 | 4 |  | #N/A |  | #N/A |  | #N/A | 00:09:00 | 4
5 | Billy | 01:09:00 | 5 |  | #N/A |  | #N/A |  | #N/A | 01:09:00 | 5
5 | [NAME] | 01:09:00 | 5 |  | #N/A |  | #N/A |  | #N/A | 01:09:00 | 5
5 | [NAME] | 01:09:00 | 5 |  | #N/A |  | #N/A |  | #N/A | 01:09:00 | 5
8 | Scott | 01:10:00 | 8 |  | #N/A |  | #N/A |  | #N/A | 01:10:00 | 8
Spreadsheet: kate_symes__18193__Deal Correction 3-1
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | 2001-02-28 00:00:00 | STSW | MF | Houston | Prebon | Time Zone: from PST to PDT | Incorrect Deal Blotter setting | 534056/066/ 473/077/078/064/058/053/ 074/072/071 | Palo Verde | J01 | On [NAME] | 25 | Varied | Varied
 |  |  |  | Grand Count
Spreadsheet: 762259d1641476159-how-to-filter-all-blank-lines-in-a-range-automatically-excel-question-filter-out-the-blank-spaces-automatically
Sheet: Sheet1

Main Table |  |  |  | Desired Output
Col1 | Col2 | Col3 |  | Col1 | Col2 | Col3
tw54y | 54yw45y | wy45y |  | tw54y | 54yw45y | wy45y | << these cells should filter the blank lines from the main table automatically (without reloading)
 |  |  |  | 34qt | 4w5y45 | tq34q
 |  |  |  | 45yw45 | 54t254t | 52tt5456
 |  |  |  | 5y245y | 54y245y54 | y424y542
34qt | 4w5y45 | tq34q
45yw45 | 54t254t | 52tt5456
5y245y | 54y245y54 | y424y542
Spreadsheet: 880973d1728876345-extract-a-string-starts-with-amb-from-a-cell-rawdataexcel01-1-
Sheet: Sheet1

Raw Data | Expected Results to extract Asset name/tag AMB99999999xx or AMB99999999 | Formula from JohnToply
all macro disable Application Name:  Asset Name: AMB00299999BR  [NAME]'s LAN ID: 10099999A | AMB00299999BR
APEX TABLET TURN TO OLD VERSION. Dashvision eSignature : V1.2.0 Kindly assist. Last week already updatedto the latest version, but this week don't know why, go back to the old version. IP Address : 12.384.3.43 Application Name: AmBanCS Asset Name:  [NAME]'s LAN ID: 10018557A | NIL |  | NIL
no internet/urgent Application Name:  Asset Name: AMB00122323HR  Requester's LAN ID: Abbdfdfd | AMB00122323HR |  | AMB00122323HR
PC cannot on. Application Name: Desktop - Applications-parent Asset Name: AMB00232323HW  Requester's LAN ID: 10040594B | AMB00232323HW |  | AMB00232323HW
Unable to login Citrix Application Name:  Asset Name: AMB00434234HS  [NAME]'s LAN ID: dfdsfdfsdf | AMB00434234HS |  | AMB00434234HS
1. [NAME]2. Please use MST chat to arrange time Thanks. Application Name:  Asset Name: AMB08329230HW  [NAME]'s LAN ID: 1dsffsfsf | AMB08329230HW |  | AMB08329230HW
AmBancs unable to log in msg : YOU MAY LOGIN TO AMBANCS FROM MICROSOFT INTERNET EXPLORER OR FIREFOX Application Name: AmBanCS Asset Name: AMB00384930HS  Requester's LAN ID: sdfsfsfd | [NAME] |  | [NAME]
system inaccessible ambancs  Application Name: AmBanCS Asset Name: Others [NAME]'s LAN ID: ddfdfsdfA | NIL |  | NIL
Hardware faulty AMB00275837 [NAME] 10041567 Application Name:  Asset Name: AMB00382039HS  [NAME]'s LAN ID: dfsdfdsY | AMB00275837 AMB00275837HS |  | AMB00275837 AMB00382039HS
UNABLE TO ACCESS USING VPN VIA LAPTOP. LAPTOP IP ADDRESS:  USER NAME: GRPUSR\ 93939403A LAPTOP TAG: AMB00820238  request for [NAME].  Application Name:  Asset Name: AMB00268778BR  Requester's LAN ID: 93939403A | AMB00820238 AMB00268778BR |  | AMB00820238 AMB00268778BR
Submitting this request for my colleague as she is unable to connect to the internet and she is currently at Menara AmBank Application Name:  Asset Name: AMB00239943HS  Requester's LAN ID: 393949394 | AMB00239943HS |  | AMB00239943HS
Unable to connect to LAN network after back from annual leave. LAN ID:10033366A ([NAME]). Asset no: AmB00394304. SN:ldeorpeo. IP:11.788.55.43 Application Name:  Asset Name:  [NAME]'s LAN ID: 109393039 | AmB00394304 |  | AmB00394304
Spreadsheet: 740494d1626357601-excel-formula-to-fill-column-b-with-unique-values-from-column-a-question-v1
Sheet: Sheet1

TITLE A | TITLE B | TITLE C | TITLE D
a |  |  | y
d
led
d |  | x
f |  |  | y
gh |  |  | x
led
f
p |  |  | y
k |  | x
Spreadsheet: 675747d1588455425-inter-demand-interval-adi-help
Sheet: Feuil1

Product | janvier | fevrier | mars | avril | mai | [NAME] | juillet | aout | septembre | octobre | novembre | decembre | janvier | fevrier | mars | avril | ADI | sum of intervals between two consecutive demands | No. Of periods with non-zero demand
A | 348 | 342 | 670 | 48 | 318 | 1164 | 882 | 516 | 508 | 654 | 738 | 228 | 324 | 930 | 294 | 666 | 1 | 16 | 16
B | 0 | 240 | 162 | 120 | 12 | 432 | 852 | 444 | 240 | 264 | 0 | 108 | 78 | 414 | 168 | 132 | 1.071428571428571 | 15 | 14
C | 348 | 570 | 886 | 72 | 0 | 600 | 228 | 18 | 252 | 36 | 606 | 408 | 312 | 744 | 792 | 1506 | 1.066666666666667 | 16 | 15
D | 18 | 12 | 474 | 0 | 102 | 444 | 18 | 168 | 0 | 12 | 30 | 0 | 0 | 84 | 294 | 0 | 1.363636363636364 | 15 | 11
E | 60 | 36 | 162 | 18 | 114 | 42 | 6 | 60 | 174 | 24 | 558 | 210 | 624 | 30 | 996 | 84 | 1 | 16 | 16
F | 36 | 42 | 0 | 6 | 6 | 18 | 180 | 18 | 12 | 0 | 6 | 0 | 0 | 24 | 36 | 6 | 1.333333333333333 | 16 | 12
G | 54 | 24 | 6 | 12 | 36 | 12 | 6 | 24 | 18 | 6 | 114 | 72 | 0 | 48 | 18 | 12 | 1.066666666666667 | 16 | 15
S | 800 | 2400 | 4500 | 4400 | 900 | 1000 | 2700 | 1200 | 500 | 1200 | 2100 | 400 | 0 | 100 | 0 | 0 | 1.076923076923077 | 14 | 13
Z | 0 | 0 | 0 | 0 | 1 | 0 | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 3.666666666666667 | 11 | 3