tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 720972d1614409762-extracting-specific-text-from-1-column-to-another-where-they-can-be-more-than-1-occurence-testextractn_simplified-ans
Sheet: TestExtrctn

Hashtag 0/1 | Hashtag count | Text Smplfied Formatting | Extrctn First# | Extraction Second # | Extraction Third #
1 | 3 | We are part of a wider club made up of three teams and we are #EachForEqual #WeAreGIANTS #IWD2020 https://t co/RAyYnxkyLm
1 | 2 | Just a small representation of some of the amazing women involved in our wider club #WeAreGIANTS #IWD2020 https://t co/zALAIQRuGH
1 | 1 | For those who sacrifice so much to protect us and for the victims of all conflicts we pause to reflect 🧡 #RemembranceDay https://t co/iFQLkdbwQx
0 | 0 | xx today attended an Investiture Ceremony at Government House to officially be appointed a Member of the Order of Australia (AM) We are so very proud of xx and thank her for all that she has done and continues to do for not only our sport but all sportswomen https://t co/oq6tMnPrFw
0 | 0 | Don't let distance be the thing stopping you from being part of the GIANTS family in 2021 Our newly created Regional Membership is the perfect package for those of you that live more than 100km away from [NAME] LEARN MORE | https://t co/NI2HinPCXw https://t co/4NcKvMKcHX
0 | 0 | Something GIANT has landed our 2021 Membership Range!! With four new packages alongside all your go to favourites there is a package for every member of the household and every type of fan For more information and to sign up 👉 https://t co/NI2HinPCXw https://t co/5Jo9Wj6vPo
Spreadsheet: sara_shackleton__36585__ALL EXP COB 11 30 011_fmtm
Sheet: Sheet3

cp_id | counterparty | erating | last_credit_review_dt | industry_classification | country_name | parent_counterparty | enron_entity | fmtm | pmtm | sales | purchase | net_del | net_physical | net_exp | max_exp | in_collateral_amt | exp | net_obligation | max_obligation | out_collateral_amt
79404 | 1950 Stemmons Asset Acquisition I, LP | 11 |  | Industrials | USA | 1950 Stemmons Asset Acquisition I, LP | Enron Energy Services Operations, Inc. | 0 | 0 | 506425 | 0 | 506425 | 506425 | 506425 | 506425 |  | 506425 | 0 | 0
79404 | 1950 Stemmons Asset Acquisition I, LP | 11 |  | Industrials | USA | 1950 Stemmons Asset Acquisition I, LP | Enron Energy Services, Inc. | 4283694 | 0 | 0 | 0 | 0 | 0 | 4283694 | 4283694 |  | 4283694 | 0 | 0
Spreadsheet: 0313efb6-5af0-4506-8bbd-ec38b30bb308
Sheet: DATA

DIGITAL/ANALOG | TELECOM | IT |  | ENHANCEMENTS | Checked? | SUGGESTED RANGES | ALTERNATIVE WORK
1 | 2 | 1 |  | 0 |  | Suggested range: $600-$850 per year* | #REF! | 2
Picklist Results: Do not Edit |  |  |  | 0 |  | Suggested range: $600-$800 per year
 |  |  |  | 0 |  | Examples: Blackberry, home internet access*
User Estimated Fully serviced rental rate | 31.5
User Estimated Daily telework center cost | 0
CPP GRAPHS | TOTALS | PER PERSON
Real Estate
Telecom
Individual IT |  |  |  | Intoduction
Moblity Devices |  |  |  | Intorduction
SCENARIO TOOL GRAPHS | BASELINE | ADJUSTED | SAVINGS | Introductions
Real Estate
Telecom
Individual IT
Real Estate Comparison | BASELINE | ADJUSTED | SAVINGS |  | costs | savings
Teleworkers
Total Workspaces
Shared Workspaces
Assigned Workspaces
Rentable Square Feet (*1,000)
Baseline IT | 5000
Cloud IT | 3200 |  | 1 | Teleworkers (%)
IP Phone | 497 |  | 2 | Teleworkers (#)
Digital Phone | 1000 |  | 3 | Square Feet (%)
 |  |  | 4 | Square Feet (#)
SUBTRACTION OF SCENARIO TOOL GRAPHS FROM CPP GRAPHS
Real Estate | #[NAME]! | #[NAME]!
Telecom | #[NAME]! | #[NAME]!
Workstation IT | #[NAME]! | #[NAME]!
Mobility Devices | #[NAME]! | #[NAME]!
Alternative Work Environments | #[NAME]! | #[NAME]!
NET SAVINGS
Telecommunications |  |  |  |  | Results |  |  |  | Telecommunications
Estimated annual cost per profile |  |  |  |  | Change in Cost |  |  |  | Estimated annual cost per profile
Number of profiles |  |  |  |  |  |  |  |  | Number of profiles
 |  |  |  |  | Change in Cost Per Person
[NAME]) |  |  |  |  |  |  |  |  | [NAME])
Personal Information Technology (IT) |  |  |  |  | Change in Teleworkers |  |  |  | Personal Information Technology (IT)
Estimated annual IT cost per profile |  | 5000 |  |  | Change in Sq. Ft. |  |  |  | Estimated annual IT cost per profile
Personal IT Subtotal |  |  |  |  |  |  |  |  | Personal IT Subtotal
ADDITIONAL DEVICES |  |  |  |  |  |  |  |  | ADDITIONAL DEVICES
Laptop (second computer) |  |  |  |  |  |  |  |  | Laptop (second computer)
Smartphone |  |  |  |  |  |  |  |  | Smartphone
Other (optional description) |  |  |  |  |  |  |  |  | Other (optional description)
Additional Devices Subtotal |  |  |  |  |  |  |  |  | Additional Devices Subtotal
Personal  IT SUBTOTAL  (C) |  |  |  |  |  |  |  |  | Personal  IT SUBTOTAL  (C)
Spreadsheet: 125002d1318795684-setting-sales-targets-challenge
Sheet: Sheet1

OBSERVATION | POTENTIAL | SALES | PERF | perc_rank_method | band |  | BAND | POTENTIAL Weighting | SALES Weighting
Person19 | 838.3130488957747 | 18.30084358434724 |  |  |  |  | 0 | 100 | 0
Person4 | 708.5062198009927 | 26.7958195013557 |  |  |  |  | 1 | 80 |  | Poor
Person8 | 484.3987439012101 | 23.989142652194 |  |  |  |  | 2 | 70
Person23 | 800.3197183225749 | 49.49287012235675 |  |  |  |  | 3 | 60
Person21 | 890.8744762200752 | 59.24193704990031 |  |  |  |  | 4 | 55
Person24 | 555.733801304467 | 37.95744253902296 |  |  |  |  | 5 | 50 |  | Avg
Person2 | 763.8824204418477 | 58.49291391003278 |  |  |  |  | 6 | 50 |  | Avg
Person25 | 902.1465223351605 | 84.37065275745117 |  |  |  |  | 7 | 47
Person15 | 626.2862177119437 | 59.84308639935184 |  |  |  |  | 8 | 44
[NAME] | 300 | 31.61038891299496 |  |  |  |  | 9 | 40
Person18 | 481.4324401692917 | 53.23566890686561 |  |  |  |  | 10 | 38
Person3 | 681.2727745073854 | 93.65458864139585 |  |  |  |  | 11 | 34
Person16 | 105.5695695207209 | 15.16713586684093 |  |  |  |  | 12 | 30 |  | Good
Person6 | 405.1127551060446 | 83.0706338759168
Person7 | 407.8932025941527 | 84.66385949506792
Person5 | 146.3670296266781 | 37.71715288477991
Person17 | 331.6855596685493 | 98.3759283609478
Person10 | 76.11688033620156 | 26.85950990548053
Person9 | 215.6822149530527 | 82.59095402092763
Person1 | 99.99189103238248 | 69.27547376216026
Person11 | 123.5727981783049 | 87.52755520394406
Person12 | 100.1532151724674 | 86.73926139642266
[NAME] | 51.37336943438287 | 49.59958354619231
Person14 | 42.12786260528745 | 50
Person22 | 56.92805143357494 | 68
25
Spreadsheet: ee699a38-0eb7-4267-ab48-66e039b754fe
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6846 | 41159 | Charlotte | Ellis | GBR | 2 | [NAME] | 00:01:14 | 00:42:54 | 00:00:48 | [NAME] | 1 | [NAME]
6846 | 30795 | Sara | Butler | GBR | 1 | 00:13:06 | 00:01:06 | 00:44:09 | 00:00:58 | 00:24:01 | 2 | 01:23:18
6846 | 51375 | [NAME] | Walsh B1 | USA | 4 | 00:18:54 | 00:01:45 | 00:43:10 | 00:01:41 | 00:19:36 | 3 | 01:25:05
6846 | 51337 | Keiko | Kashiwagi | JPN | 3 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 677412d1589349910-insert-value-in-cell-from-table-if-the-search-cell-value-matches-a-value-found-in-table-rfp-formula-test
Sheet: RFPs 

 |  |  | 2020-04-30 00:00:00 | 2020-05-07 00:00:00 | 2020-05-14 00:00:00 | 2020-05-21 00:00:00 | 2020-05-28 00:00:00 | 2020-06-04 00:00:00 | 2020-06-11 00:00:00 | 2020-06-18 00:00:00 | 2020-06-25 00:00:00 | 2020-07-02 00:00:00 | 2020-07-09 00:00:00 | 2020-07-16 00:00:00 | 2020-07-23 00:00:00 | 2020-07-30 00:00:00 | 2020-08-06 00:00:00 | 2020-08-13 00:00:00 | 2020-08-20 00:00:00 | 2020-08-27 00:00:00 | 2020-09-03 00:00:00
 | [NAME] | [NAME] | 1 | 2 | 1 | 0.5 |  |  |  |  | 0.5 | 2 | 3 | 2 | 1
 |  | Sue | 0.5 | 0.5 | 1 | 1 |  |  |  |  | 1 | 2 | 1 | 0.5
 |  | Cliff | 1 | 1 | 1 |  |  |  |  |  |  | 2 | 1 | 1 | 1
 |  | Anna | 0.4 | 0.5 | 0.75 | 1 |  |  |  |  | 1 | 2 | 3 | 3
 |  | [NAME] |  |  | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 0.5
 | [NAME] | [NAME] |  |  |  |  | 1 | 2 | 1 | 0.5 |  |  |  |  | 0.5 | 2 | 3 | 2 | 1
 |  | Sue |  |  |  |  | 0.5 | 0.5 | 1 | 1 |  |  |  |  | 1 | 2 | 1 | 0.5
 |  | Cliff |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 2 | 1 | 1 | 1
 |  | Anna |  |  |  |  | 0.4 | 0.5 | 0.75 | 1 |  |  |  |  | 1 | 2 | 3 | 3
 |  | [NAME] |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 | 0.5
Spreadsheet: 26266d1218244653-formula-for-adding-a-count-of-similar-entries-example-count
Sheet: Sheet1

Count | Entry | Total # entries
1 | a | 10 |  | Part one
2 | a | 10 |  | The desired result would be just as column a is now
3 | a | 10 |  | without having to enter the numbers by hand as there are too many entries for that
4 | a | 10
5 | a | 10
6 | a | 10 |  | Part two
7 | a | 10 |  | C column is for part two
1 | b | 12 |  | if the total number of entries does not match the count
2 | b | 12 |  | how can I add rows to make them even.
3 | b | 12 |  | Ex: Entry "a" has 7 counted however I need to add 3 more rows of entry "a" to make it equal the total # entries 10
4 | b | 12
5 | b | 12
6 | b | 12
7 | b | 12
8 | b | 12
9 | b | 12
10 | b | 12
11 | b | 12
1 | c | 38
2 | c | 38
3 | c | 38
4 | c | 38
5 | c | 38
6 | c | 38
7 | c | 38
8 | c | 38
9 | c | 38
10 | c | 38
11 | c | 38
1 | d | 10
2 | d | 10
3 | d | 10
4 | d | 10
5 | d | 10
6 | d | 10
7 | d | 10
8 | d | 10
9 | d | 10
10 | d | 10
1 | e | 21
2 | e | 21
3 | e | 21
4 | e | 21
5 | e | 21
6 | e | 21
1 | f | 23
2 | f | 23
3 | f | 23
4 | f | 23
5 | f | 23
6 | f | 23
7 | f | 23
8 | f | 23
9 | f | 23
10 | f | 23
11 | f | 23
1 | g | 34
2 | g | 34
3 | g | 34
4 | g | 34
5 | g | 34
6 | g | 34
7 | g | 34
8 | g | 34
9 | g | 34
10 | h | 34
11 | h | 34
12 | h | 34
13 | h | 34
14 | h | 34
15 | h | 34
16 | h | 34
17 | h | 34
Spreadsheet: 485140d1476727132-basic-index-match-question-basic-index-match-question
Sheet: Sheet1

 |  |  |  | LOGIC IN COLUMNS B & C
 | [NAME] | michelle |  | <<<< | MIKE IS RELATED TO MICHELLE
 | [NAME] | angelina |  | <<<< | MIKE IS RELATED TO ANGELINA
 | [NAME] | bradley |  | ETC
 | tom | Aiesha |  | <<<< | [NAME] IS RELATED TO AIESHA
 | michelle | [NAME] |  | ETC
 | [NAME] | tom
 | michelle | [NAME]
 | tom | laurance
 | tom | [NAME]
 |  |  |  |  |  |  |  | None duplicate names | relationships (Show all named related to values in column i18:i27)
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | tom
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | angelina
 |  |  |  |  |  |  |  | bradley
 |  |  |  |  |  |  |  | Aiesha
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 717828d1612871093-how-to-count-just-numbers-in-the-second-column-which-are-not-the-same-mysheet
Sheet: Hárok1

 | Val
 | Dátum | nákladové | Prod. | [NAME] |  | 2020-12-04 00:00:00
 | 2020-12-01 00:00:00 | 5034 | 2.5 | x
 | 2020-12-02 00:00:00 | 5019 | 2 | x
 | 2020-12-04 00:00:00 | 5021 | 2 | x
 | 2020-12-04 00:00:00 | 5034 | 2 | x
 | 2020-12-08 00:00:00 | 4338 | 4 | x
 | 2020-12-11 00:00:00 | 5028 | 1 | x
 | 2020-12-04 00:00:00 | 5021 | 1 | x
 | 2020-12-04 00:00:00 | 5029 | 3 | x
 | 2020-12-04 00:00:00 | 5090 | 1 | x
 | 2020-12-14 00:00:00 | 4339 | 2 | x
 | 2020-12-14 00:00:00 | 5034 | 1.5 | x
 | 2020-12-16 00:00:00 | 4329 | 3 | x
 | 2020-12-21 00:00:00 | 4332 | 2.5 | x
 | 2020-12-21 00:00:00 | 5101 | 1 | x
 | 2020-12-22 00:00:00 | 4346 | 1.5 | x
 | 2020-12-22 00:00:00 | 5090 | 1 | x
 | 2020-12-22 00:00:00 | 4319 | 1 | x
 | 2020-12-23 00:00:00 | 5020 | 4 | x
 | 2020-12-28 00:00:00 | 4326 | 7.5 | x
 | 2020-12-29 00:00:00 | 5301 | 1.5 | x
 | 2020-12-29 00:00:00 | 5102 | 2 | x
 | 2020-12-29 00:00:00 | 4326 | 3 | x
 | 2020-12-30 00:00:00 | 5019 | 1 | x
 | 2020-12-01 00:00:00 | 5034 | 2 | x
 | 2020-12-01 00:00:00 | 4011 | 3.5 | x
 | 2020-12-03 00:00:00 | 4340 | 0.5 | x
 | 2020-12-04 00:00:00 | 5021 | 2 | x
 | 2020-12-04 00:00:00 | 4314 | 1 | x
 | 2020-12-30 00:00:00 | 4106 | 1 | x
 | 2020-12-30 00:00:00 | 4346 | 1.5 | x
 | 2020-12-01 00:00:00 | 5029 | 1.5 | x
 | 2020-12-02 00:00:00 | 5090 | 1 | x
 | 2020-12-02 00:00:00 | 4103 | 0.5 | x
 | 2020-12-04 00:00:00 | 40 | 1 | x
 | 2020-12-07 00:00:00 | 4338 | 2 | x
 | 2020-12-09 00:00:00 | 5009 | 1 | x
 | 2020-12-10 00:00:00 | 4345 | 1 | x
 | 2020-12-10 00:00:00 | 4339 | 4 | x
 | 2020-12-10 00:00:00 | 5009 | 2 | x
 | 2020-12-11 00:00:00 | 4339 | 1 | x
 | 2020-12-16 00:00:00 | 4315 | 2 | x
 | 2020-12-16 00:00:00 | 4314 | 0.5 | x
 | 2020-12-16 00:00:00 | 4329 | 1 | x
 | 2020-12-18 00:00:00 | 4315 | 1 | x
 | 2020-12-18 00:00:00 | 40 | 0.5 | x
 | 2020-12-21 00:00:00 | 4339 | 5 | x
 | 2020-12-22 00:00:00 | 4339 | 4 | x
 | 2020-12-22 00:00:00 | 5020 | 1 | x
Spreadsheet: d7fbfed9-4c47-426f-bec2-fc23901bb42c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  | Milk Breakeven Cost Analysis
 |  | Name:
 | 0 | Production Costs |  |  |  |  |  |  | A1
 | 0 | Administrative Costs |  |  |  |  |  |  | A1
 | 0 | Interest Expense |  |  |  |  |  |  | A1
 | 0 | Total Analysis Costs |  |  |  |  | 0 |  | Sum
 | less: Depreciation Expense |  |  |  |  |  |  |  | A1
 | plus: Current Portion of Non Current Debt |  |  |  |  |  |  |  | F2
 | less: Non Milk Income
 |  | Livestock Income |  |  |  |  |  |  | A1
 |  | Ag Payments |  |  |  |  |  |  | A1
 |  | Patronage Refunds |  |  |  |  |  |  | A1
 |  | Crop Sales |  |  |  |  |  |  | A1
 |  | Machine Hired |  |  |  |  |  |  | A1
 |  | Other Income |  |  |  |  |  |  | A1
 |  | Total  Non-Milk Income |  |  |  |  | 0 |  | Sum
 | 0 | Income Needed From Milk |  |  |  |  | 0 |  | Net
 | 0 | Pounds of Milk Sold |  |  |  |  |  |  | A1
 | 0 | [NAME] |  |  |  |  |  |  | calc
 |  | Assumes Draws Equal Management Labor
 |  | Assumes No Capital Expenditures
 |  |  |  |  |  | Copyright MSC Business Services 2010
 | What is missing?
 | 0 | Capital Replacement Budget |  |  |  |  |  |  | A1
 | 0 | Other Needs |  |  |  |  |  |  | A1
 | 0 | Needed for Capital & Other Needs |  |  |  |  | 0 |  | Sum
 | 0 | Adjusted Breakeven |  |  |  |  |  |  | calc
 | 0 | Actual Milk Price |  |  |  |  |  |  | A1
 | 0 | Calculated Profit/Loss on Milk |  |  |  |  |  |  | Net
Spreadsheet: 648791d1573206786-lookup-or-match-over-several-columns-lookup-demo
Sheet: Master list 

Staff ID | Name | DOB | NI | Unq ID
1234 | [NAME] | 2010-10-01 00:00:00 | AB123456 | 1
4567 | Homer | 2011-11-02 00:00:00 | AC123456 | 2
8989 | [NAME] | 2012-12-03 00:00:00 | AD123456 | 3
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 9 | 69 | 78
Cap/Floor | - | 105 | 105
Debt Option | - | - | -
Exotic | - | - | -
Fixed-Fixed | - | - | -
Fixed-Float | 4051 | 989 | 5040
FRA | 3 | 3 | 6
Inflation | - | 53 | 53
OIS | 14 | 24 | 38
Swaption | - | 275 | 275
TOTAL | 4077 | 1518 | 5595
Spreadsheet: 193239d1352763423-formula-to-pull-numbers-from-data-in-a-cell-highergrounds
Sheet: BillOfMaterials (multi-level)

 | American Hydroponics
 | [NAME] of Materials
 | (Multi-Level) 93048 - Collector Covered 5ft module
 | Item - Description | Qty |  | Unit Cost | Total Cost
 | 24049 - Stage - Collector HDPE Processed | 5 | ft | 1.86 | 9.23 | 0.4
 | 02062 - Hose Clamp 3.5in to 5.5in | 2 | ea | 1.22 | 2.44 | 0.25
 | 23032 - Stage - Bulkhead Fitting 1in prepped | 1 | ea | 4.93 | 4.93
 | 40002 - Labor for Production | 0.0333 | hr | 60 | 2
 | 30261 - Screw SS 8-32 x 1.75in Pan head | 4 | ea | 0.08 | 0.34
 | 30262 - Washer SS Flat #10 | 8 | ea | 0.02 | 0.19
 | 30038 - Washer SS #10 Lock | 4 | ea | 0.02 | 0.07
 | 30265 - Nut 8-32 SS | 4 | ea | 0.03 | 0.11
 | 30260 - Brace Zinc 4in x 4in x .875in | 1 | ea | 2.09 | 2.09
 | 02088 - End Cap Covered Collector with Logo | 2 | ea | 0.69 | 1.37
 | 02000 - Hose Clamp 1in to 2in | 1 | ea | 0.7 | 0.7
 | 50018 - Tape Gasket .125in x .5in | 2.4166 | ft | 0.84 | 2.04
 | [NAME] of Materials
 | Manifold 3ft Finishing 1in
 | Item - Description | Qty |  | Unit Cost | Total Cost
 | 22030 - Tubing White LDPE 1in x 5ft | 1 | ea | 4.55 | 4.55
 | 23002 - Grommet Microtube | 6 | ea | 0.23 | 1.38
 | 22018 - Micro Tubing .25in x 16in | 6 | ea | 0.06 | 0.36
 | 30006 - Nyties 11in | 3 | ea | 0.06 | 0.18
 | 40002 - Labor for Production | 0.06667 | hr | 60 | 4.0002
 | 25083 - Tee Nylon 1in BRB | 1 | ea | 0.75 | 0.75
 | 25048 - Male Adapter Nylon 1in BRB x .75in GHT | 2 | ea | 0.83 | 1.66
 | 25113 - Cap .75in [NAME] | 2 | ea | 0.38 | 0.76
 | 25114 - Ball Valve PVC with Union 1in | 1 | ea | 13.65 | 13.65
 | 25043 - Female Adapter PVC 1in | 1 | ea | 0.34 | 0.34
 | 25046 - Male Adapter Nylon 1in MPT x 1in BRB | 1 | ea | 0.95 | 0.95
Spreadsheet: 465833d1465912502-trouble-with-combining-mid-and-vlookup-centre-technologies
Sheet: Email

Description |  | Quantity | Unit Price | Subtotal Price
[NAME] N3000 Series Switches |  | 1 | 3660 | 3660
210-ABOH | [NAME], L3, POE+, 48x 1GbE, 2xCombo, 2x 10GbE SFP+ fixed ports, Stacking, IO to PSU air, 1x 1100w AC PSU | 1 | - | -
450-ADYH | [NAME], 125V, 13A, 6 Feet, C15 to NEMA 5-15P | 2 | - | -
450-ABKF | Power Supply, 1100w, Hot Swap, Required for more than 900 watts of POE+, or for redundancy | 1 | - | -
343-BBBQ | [NAME] Series User Guide | 1 | - | -
332-1286 | US Order | 1 | - | -
966-3310 | Dell Hardware Limited Warranty Initial Year | 1 | - | -
966-3312 | Dell Hardware Limited Warranty Extended Year(s) | 1 | - | -
966-3320 | Lifetime Limited Hardware Warranty with Basic Hardware Service Next Business Day Parts Only on Your Network Switch | 1 | - | -
966-3326 | ProSupport: Next Business Day Onsite Service After Problem Diagnosis, Initial Year | 1 | - | -
966-3331 | ProSupport: Next Business Day Onsite Service After Problem Diagnosis, 2 Year Extended | 1 | - | -
966-3379 | ProSupport: 7x24 HW / SW Tech Support and Assistance, 3 Year | 1 | - | -
989-3439 | Thank you choosing Dell ProSupport. For tech support, visit http://www.dell.com/support or call 1-800- 945-3355 | 1 | - | -
900-9997 | On-Site Installation Declined | 1 | - | -
Spreadsheet: 870026d1716540386-how-to-return-existing-data-draft1-aligw
Sheet: Sheet1

Scenario 1
 | Existing Data System | New Data system |  |  | 2024-05-31 00:00:00 | 2024-06-01 00:00:00 | 2024-06-15 00:00:00 | 2024-06-30 00:00:00
 |  |  |  |  | 50 | 308 |  | 70
 | - |  |  |  | 50 |  | -
 | 25 |  |  |  | 50 |  | 25 | 30
 | 45 |  |  |  | - |  | 45
 | - |  |  |  | 50 |  | - | 60
 | 30 |  |  |  | 50 |  | 30 | 50
 | 30 |  |  |  | 50 |  | 30
 | 45 |  |  |  |  | 45 |  | -
 | 50 |  |  |  | 50 |  |  | 70
Scenario 2
 | Existing Data System | New Data system |  |  | 2024-05-31 00:00:00 | 2024-06-01 00:00:00 | 2024-06-15 00:00:00 | 2024-06-30 00:00:00 | 2024-07-07 00:00:00
 |  |  |  |  | 50 | 308 |  | 70 | 20
 | - |  |  |  | 50 |  | -
 | 30 |  |  |  | 50 |  | 25 | 30
 | 45 |  |  |  | - |  | 45
 | 60 |  |  |  | 50 |  | - | 60
 | 50 |  |  |  | 50 |  | 30 | 50
 | 30 |  |  |  | 50 |  | 30
 | - |  |  |  |  | 45 |  | -
 | 70 |  |  |  | 50 |  |  | 70
New Level
New Level |  |  |  |  |  |  |  |  | 30
Spreadsheet: 732930d1621324603-formula-to-sum-concatenated-trucks-sum-concatenated-trucks-ans-1-
Sheet: Report

 |  |  | [NAME] Here
Date | Supplier | Truck | Quantity | Quantity
2021-04-01 00:00:00 | Company 1 | 6578, 7496 |  | 37.46 |  |  |  | Could you help me in my question ,please?
2021-04-01 00:00:00 | Company 2 | 2951 |  | 48.02 |  |  |  | I need a formula to sum trucks quantities from "Data"Sheet but the problem is that the Trucks here are concatenated and in Data" Sheet Trucks are not concatenated
2021-04-01 00:00:00 | Company 3 | 2971 |  | 26.78 |  |  |  | Please help me
2021-04-01 00:00:00 | Company 4 | 2473, 7416 |  | 106.54
2021-04-01 00:00:00 | Company 5 | 9241, 8162 |  | 92.5
2021-04-01 00:00:00 | Company 5 | 2493, 3697 |  | 129.94
2021-04-02 00:00:00 | Company 4 | 3724, 1564, 4571, 8947 |  | 192.32
2021-04-02 00:00:00 | Company 2 | 7415 |  | 42
 |  | Extra spaces are there in the beginning in column C.
 |  | I have used TRIM function o avoid problem.
Spreadsheet: 156133d1337186020-analyzing-cell-data-in-first-three-columns-of-sheet-1-to-accurately-update-sheet-3-sampleinventory
Sheet: UPDATE

LINE | ITEM NUMBER | [NAME] | [NAME] | ON HAND | QTY AVAIL | AISLE | BIN
TRE | 6100-1 | 6.100" .080 | WALL 180 TIP | 0 | 0 | 12 | 39
TRE | 6200-2 | 6.200" PUSH | ROD | 9 | 9 | 12 | 39
TRE | 6250-4 | 3/8" 6.250" | .080 WALL 180 TIP | 0 | 0 | 12 | 39
TRE | 6300-2 | 6.300" .080 | WALL 210 TIP | 2 | 2 | 12 | 39
TRE | 6300-3 | 3/8" 6.300" | .080 WALL 210 TIP | 8 | 8 | 12 | 41
TRE | 6350-2 | 6.350" .080 | WALL 210 TIP | 13 | 12 | 12 | 39
TRE | 6350-3 | 3/8" 6.350" | .080 WALL 210 TIP | 0 | 0 | 12 | 41
TRE | 6400-2 | 6.400" .080 | WALL 210 TIP | 25 | 25 | 12 | 39
TRE | 6400-3 | 3/8" 6.400" | .080 WALL 210 TIP | 12 | 12 | 12 | 41
TRE | 6450-2 | 6.450" .080 | WALL 210 TIP | 9 | 9 | 12 | 39
TRE | 6450-3 | 3/8" 6.450" | .080 WALL 210 TIP | 7 | 7 | 12 | 41
TRE | 6500-2 | 6.500" .080 | WALL 210 TIP | 1 | 1 | 12 | 39
TRE | 6500-3 | 3/8" 6.500" | .080 WALL 210 TIP | 12 | 12 | 12 | 41
TRE | 6550-2 | 6.550" .080 | WALL 210 TIP | 8 | 8 | 12 | 39
TRE | 6550-3 | 3/8" 6.550" | .080 WALL 210 TIP | 2 | 2 | 12 | 39
TRE | 6600-2 | 6.600" .080 | WALL 210 TIP | 9 | 9 | 12 | 39
TRE | 6600-3 | 3/8" 6.600" | .080 WALL 210 TIP | 4 | 4 | 12 | 41
TRE | 6650-2 | 6.650" .080 | WALL 210 TIP | 32 | 32 | 12 | 39
This is where the imported data from *.prt will be stored and updated ONCE daily.
Spreadsheet: 021cc7af-ba43-4ab4-97dc-44835ad3a278
Sheet: Sheet1

Table 8--U.S. cotton textile imports, by origin | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Jan. | Feb. | Mar. | Mar.
Region/country | 2012 | 2012 | 2012 | 2011
 | 1,000 pounds 1/
North America | 107986.062 | 135234.706 | 146201 | 172654.852
Canada | 2977.971 | 2958.872 | 3013.699 | 3698.643
Costa Rica | 523.923 | 798.743 | 933.337 | 906.318
Dominican Republic | 2704.338 | 5559.827 | 5656.268 | 6756.398
El Salvador | 15785.862 | 20636.558 | 24492.759 | 25619.279
Guatemala | 6293.855 | 6846.417 | 8462.537 | 11175.837
Haiti | 6277.852 | 10935.061 | 10777 | 15516.5
Honduras | 19992 | 29024.805 | 30571.623 | 37810.216
Mexico | 36615.653 | 41925.688 | 46393.078 | 52699.421
Nicaragua | 16809.535 | 16543.857 | 15883.632 | 18419.873
South America | 3987.16 | 3593.075 | 4268.91 | 5661.739
Brazil | 147.232 | 221.161 | 253.243 | 259.675
Colombia | 1162.694 | 1041.966 | 1300 | 1775
Peru | 2582.101 | 2217.657 | 2626.16 | 3450.109
Europe | 10112.596 | 9355.796 | 10347.688 | 11406.296
Germany | 914.394 | 681.597 | 887.703 | 1154.026
Italy | 1537.222 | 1490.982 | 1827.87 | 1745.637
Portugal | 1299.145 | 872.043 | 902.136 | 1225.847
Turkey | 3941.329 | 3939.35 | 3974.438 | 4324.137
Asia | 520199.774 | 436542.434 | 421609.709 | 456731.635
Bahrain | 1386.684 | 1514.367 | 2258.377 | 2147.177
Bangladesh | 48080.596 | 45803.296 | 47769.866 | 55027.29
Cambodia | 21432.164 | 18240.814 | 17767 | 21930.163
China | 226759.15 | 166266.178 | 134309 | 125062.791
Hong Kong | 1039.141 | 904.54 | 441.449 | 1010.562
India | 59223.033 | 57998.006 | 63429.223 | 69250.151
Indonesia | 28652.684 | 25997.349 | 27795.877 | 32597.829
Israel | 804.282 | 967.693 | 1010.812 | 1345.222
Japan | 998.163 | 1147.706 | 1080.361 | 1151.108
Jordan | 4641.034 | 4052.509 | 3655.329 | 3652.662
Malaysia | 2581.351 | 2489.386 | 1977 | 2915.167
Pakistan | 54002.273 | 49778.48 | 58093.126 | 73741.313
Philippines | 4902.49 | 4775.144 | 4550.212 | 6604.352
South Korea | 6169.055 | 5332.133 | 5388.654 | 5047.621
Sri Lanka | 7670.926 | 7058.379 | 7107.409 | 7098.918
Taiwan | 3171.15 | 2720.612 | 2733.773 | 2947.114
Thailand | 5454.54 | 6520.883 | 6009.728 | 9905.888
Vietnam | 42240.712 | 33975.626 | 35179.391 | 33393.592
Oceania | 40.438 | 14.708 | 69.931 | 43.558
Africa | 16202.989 | 13143.356 | 14155.153 | 19486.706
Egypt | 9199 | 7160.672 | 7746.188 | 11036.52
Kenya | 1750.953 | 1812.913 | 2188.02 | 1907.095
[NAME] | 3235.109 | 2159.158 | 2301.346 | 4002.675
[NAME] | 850.953 | 651.388 | 729.665 | 1044.028
World 2/ | 658529.019 | 597884.075 | 596652.049 | 665986.791
 |  |  |  |  |  |  | 95
1/ Raw-fiber equivalent.  2/ Totals may not add due to rounding.
Last update:  06/13/12.
Sources: USDA, Economic Research Service; and USDC,
U.S. Census Bureau.