tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 20b4d2c2-ed9a-474e-922b-4ebbca5ec896
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 7954 | 8093 | 7837 | 7334
20 - 65 | 35398 | 32914 | 29627 | 26861
65 und mehr | 14789 | 15406 | 16490 | 17262
Insgesamt | 58141 | 56413 | 53954 | 51457
%
unter 20 | 13.68053525051169 | 14.3459840816833 | 14.52533639767209 | 14.25267699244029
20 - 65 | 60.88302574775115 | 58.34470778012161 | 54.91159135559921 | 52.20086674310589
65 und mehr | 25.43643900173716 | 27.3093081381951 | 30.56307224672869 | 33.54645626445382
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 22.47019605627437 | 24.58832107917603 | 26.45222263475884 | 27.30352555749972
Altenquotient | 41.77919656477767 | 46.80682992039861 | 55.65868970871165 | 64.26417482595585
Gesamtquotient | 64.24939262105204 | 71.39515099957465 | 82.11091234347049 | 91.56770038345556
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 200027d1355394419-formula-to-calculate-value-after-doing-a-data-match-ef_vks_for_
Sheet: Sheet1

PRODUCT | CADBURY |  | JAN | FEB | MAR | APR |  |  |  | LOOK UP TABLE
Employee |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR
Ram | 52000 |  |  |  |  |  |  |  |  | CADBURY | 0.2 | 0.3 | 0.2 | 0.3
[NAME] | 35000 |  |  |  |  |  |  |  |  | MILKYBAR | 0.45 | 0.24 | 0.26 | 0.05
Senyka | 26000
PRODUCT | MILKYBAR |  | JAN | FEB | MAR | APR
Employee |  |  |  |  |  |  |  |  |  | A formula to divide the amounts in column B based on %s shown above
Ram | 24666
[NAME] | 12000
Senyka | 45000
VKS
PRODUCT | CADBURY |  | JAN | FEB | MAR | APR |  |  |  | LOOK UP TABLE
Employee |  |  |  |  |  |  |  |  |  |  | JAN | FEB | MAR | APR
Ram | 52000 | CADBURY |  |  |  |  |  |  |  | CADBURY | 0.2 | 0.3 | 0.2 | 0.3
[NAME] | 35000 | CADBURY |  |  |  |  |  |  |  | MILKYBAR | 0.45 | 0.24 | 0.26 | 0.05
Senyka | 26000 | CADBURY
PRODUCT | MILKYBAR |  | JAN | FEB | MAR | APR
Employee |  |  |  |  |  |  |  |  |  | A formula to divide the amounts in column B based on %s shown above
Ram | 24666 | MILKYBAR
[NAME] | 12000 | MILKYBAR
Senyka | 45000 | MILKYBAR
Spreadsheet: ccfc6947-4b21-460b-94a1-c2e224d49f83
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80689358623 | Sonicflood | Here I Am To Worship | 2003-04-26 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Print Music, Word Owned * | 80689458286 | Sonicflood | Cry Holy | 2003-04-26 | Vocal Folio | Na | 14.95 | N | To Be Retired
Print Music, Word Owned * | 80689420283 | Sonicflood | Resonate | 2002-03-19 | Vocal Folio | Na | 16.95 | N | To Be Retired
Resonate Csr | 896830002013 | Sonicflood | A Heart Like Yours | 2008-09-09 | Compact Disc | Ac | 13.99 | N | To Be Retired
Spreadsheet: 750724d1633607283-sum-criteria-from-rows-and-column-but-with-text-containing-criteria-test011021
Sheet: Sheet5

Company | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00
Company-A Ltd. | 100 | 200 | 300
Company-A Limited | 100 | 200 | 300
Company-A PLC | 100 | 200 | 300
Company-B Ltd. | 200 | 400 | 500
Company B LLC | 200 | 400 | 500
Company-B Ltd. | 200 | 400 | 500
Company-A Ltd.
2021-02-01 00:00:00
 | ALIGW
Spreadsheet: 0adfc65d-0b97-41d9-bf2a-87082d74f859
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Construction Spending
 |  | Total Construction: U.S. Total
 |  | Not Seasonally Adjusted Total Construction [Millions of Dollars]
 |  | Period: 2002 to 2012
 |  | Data Extracted on: October 20, 2014 (11:51 pm)
Period | Value
Jan-2002 | 59516
Feb-2002 | 58588
Mar-2002 | 63782
Apr-2002 | 69504
May-2002 | 73384
[NAME] | 77182
Jul-2002 | 78863
Aug-2002 | 79460
Sep-2002 | 76542
Oct-2002 | 75710
Nov-2002 | 71362
Dec-2002 | 63984
[NAME] | 59877
Feb-2003 | 58526
Mar-2003 | 64506
Apr-2003 | 69638
May-2003 | 74473
Jun-2003 | 80377
Jul-2003 | 82971
Aug-2003 | 85191
Sep-2003 | 83841
Oct-2003 | 83133
Nov-2003 | 77915
Dec-2003 | 71050
Jan-2004 | 64934
Feb-2004 | 64138
Mar-2004 | 73238
Apr-2004 | 78354
May-2004 | 83736
Jun-2004 | 89932
Jul-2004 | 93614
Aug-2004 | 96164
Sep-2004 | 92538
Oct-2004 | 90582
Nov-2004 | 86394
Dec-2004 | 77733
Jan-2005 | 71474
Feb-2005 | 72048
Mar-2005 | 81345
Apr-2005 | 85485
May-2005 | 92959
Jun-2005 | 99632
Jul-2005 | 103158
Aug-2005 | 106706
Sep-2005 | 103269
Oct-2005 | 102339
Nov-2005 | 97549
Dec-2005 | 88172
Jan-2006 | 81058
Feb-2006 | 81478
Mar-2006 | 92855
Apr-2006 | 95324
May-2006 | 102495
Jun-2006 | 107607
Jul-2006 | 108423
Aug-2006 | 110434
Sep-2006 | 104191
Oct-2006 | 101582
Nov-2006 | 95339
Dec-2006 | 86436
[NAME] | 79406
Feb-2007 | 79177
Mar-2007 | 88905
Apr-2007 | 93375
May-2007 | 100534
Jun-2007 | 105399
Jul-2007 | 107090
Aug-2007 | 110430
Sep-2007 | 105150
Oct-2007 | 103847
Nov-2007 | 94822
Dec-2007 | 84218
Jan-2008 | 77365
Feb-2008 | 77253
Mar-2008 | 82815
Apr-2008 | 87791
May-2008 | 92843
Jun-2008 | 96411
Jul-2008 | 98563
Aug-2008 | 99877
Sep-2008 | 96858
Oct-2008 | 95722
Nov-2008 | 86176
Dec-2008 | 76763
Jan-2009 | 67127
Feb-2009 | 66490
Mar-2009 | 71770
Apr-2009 | 75355
May-2009 | 76971
Jun-2009 | 81573
Jul-2009 | 83528
Aug-2009 | 84510
Sep-2009 | 81344
Oct-2009 | 80071
Nov-2009 | 72013
Dec-2009 | 64178
[NAME] | 55674
[NAME] | 54112
Mar-2010 | 60363
Apr-2010 | 66575
[NAME] | 69059
[NAME] | 74200
[NAME] | 73233
Aug-2010 | 75977
Sep-2010 | 74892
Oct-2010 | 73607
Nov-2010 | 68100
Dec-2010 | 60246
Jan-2011 | 51012
Feb-2011 | 50590
Mar-2011 | 56572
Apr-2011 | 61475
May-2011 | 65827
Jun-2011 | 72850
Jul-2011 | 72112
Aug-2011 | 77106
Sep-2011 | 75388
Oct-2011 | 74246
Nov-2011 | 68845
Dec-2011 | 62319
Jan-2012 | 56578
Feb-2012 | 56761
Mar-2012 | 61772
Apr-2012 | 67234
May-2012 | 73571
Jun-2012 | 79262
Jul-2012 | 78457
Aug-2012 | 82183
Sep-2012 | 80890
Oct-2012 | 82353
Nov-2012 | 74754
Dec-2012 | 67431
Spreadsheet: tracy_geaccone__40505__2002 EGF Allocations FGT
Sheet: Florida Gas Trasmission

Enron Global Finance
2001 Allocations |  |  |  | Florida Gas Transmission
 |  |  |  | 2001 |  | 2002
106188 | Schnapper | Corp Finance |  | 0 | 0 | 0 | 0
106189 | Perkins | Treasury |  | 23230 | 0.007999829190043984 | 30545 | 0.009899859467046492
106190 | Kopper | Structured Finance |  | 0 | 0 | 0 | 0
106191 | [NAME] | Commercial Support |  | 0 | 0 | 7436 | 0.00500007732771553
106192 | Glisan | Treasury VP |  | 0 | 0 | 0 | 0
106193 | Boots | Investor/Debt Relations |  | 0 | 0 | 0 | 0
106194 | [NAME] | Legal |  | 0 | 0 | 0 | 0
106195 | [NAME] | Capital Market Equity |  | 30562 | 0.02000023558945135 | 26640 | 0.02000035536166934
106196 | EGF | G&A |  | 0 | 0 | 82190 | 0.004799976639607546
106285 | Fastow | Executive |  | 0 | 0 | 0 | 0
107038 | EGF | Projects |  | 0 | 0 | 0 | 0
140411 | Glisan | Intl Asset Structures |  | 0 | 0 | 0 | 0
 |  | S/T |  |  | 0.00249362385683024 |  | 0.004063404397818557
Spreadsheet: 794344d1661993763-sumif-reference-cell-is-text-only-sample
Sheet: Sheet1

NAME | Base Unit |  |  |  |  |  |  | Notes
Doe, [NAME] | 2 |  |  |  |  |  |  | Note (blah blah blah)
Doe, [NAME] | 3 |  |  |  |  |  |  | 1 Note
Do, Adeer | 4
Re, [NAME] | 2 |  |  |  |  |  |  | Note
Mi, Aname | 3 |  |  |  |  |  |  | 2 Notes
Fa, Long | 4
TOTALS
Note
Partial Note
Spreadsheet: jeffrey_a_shankman__13824__STOR9812
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9812
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-12-29 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 473 | 410
(TX, LA, OK, KS, MS)
Market Area - East |  | 1175 | 1033
Market Area - West |  | 290 | 286
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 806041d1669070031-lookup-with-2-variables-lookup-with-2-variables
Sheet: Sheet1

Item | [NAME] | Market 1 | Market 2 | Market 3
Apple | [NAME] | 1 | 0 | 0 |  | What do I need to buy?
Apple | [NAME] | 0 | 0 | 0
Apple | [NAME] | 0 | 1 | 0
Apple | [NAME] | 0 | 0 | 0 |  | Where am I shopping?
[NAME] | [NAME] | 0 | 0 | 1
[NAME] | [NAME] | 1 | 0 | 0
[NAME] | Kurt | 0 | 1 | 0 |  | Who is the seller?
Tomato | [NAME] | 1 | 0 | 0
Tomato | [NAME] | 0 | 0 | 0
Tomato | Teddy | 0 | 0 | 1
Spreadsheet: 272129d1382217812-first-post-connecting-table-info-to-one-cell-using-if-statements-new-tracking
Sheet: Bi-Weekly Expense Form

Enterprise Fredericton
Expense Report for Planet Hatch
Employee Name: |  |  |  |  |  | Employee Title:
Date: |  |  |  |  |  | Date Paid:
Date | Destination and/or Description | Eligible Exp | Km | Travel | Transport | Lodging | Meals | Other | Totals |  | Eligible expenses
 |  |  |  | $- |  |  |  |  | $- |  | Office Supplies
 |  |  |  | $- |  |  |  |  | $- |  | Events
 |  |  |  | $- |  |  |  |  | $- |  | Travel, Meals & Accomdations
 |  |  |  | $- |  |  |  |  | $- |  | Marketing
 |  |  |  | $- |  |  |  |  | $- |  | IT Services/Technology
 |  |  |  | $- |  |  |  |  | $- |  | Profession Fees
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $- |  | Divide tax?
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 |  |  |  | $- |  |  |  |  | $-
 | Totals: |  | 0 | $- | $- | $- | $- | $- | $-
 | Explanation:
 |  |  |  |  |  |  |  | Total Due: | $-
 | Per [NAME]: |  |  | 47.5 cents
Employee Signature:_________________________________ |  |  |  |  |  | Approved By: ______________________
Marketing
Direct Client Engagement /Market Validation
Product Development
Education & Miscellaneous
Spreadsheet: 218932d1362611646-race-points-formula-revised_race_points
Sheet: Sheet1

PROCHARGER SUPER ST OUTLAW |  |  | RACE 1 |  |  | RACE 2 |  |  | RACE 3 |  |  | RACE 4 |  |  | RACE 5 |  |  | RACE 6 |  |  | RACE | TOTAL | DROP | SEASON
Rank | Name | PERM # | Q | E | S | Q | E | S | Q | E | S | Q | E | S | Q | E | S | Q | E | S | BONUS |  | RACES | TOTAL
1 | Racer 1 | 1 | 100 | 400 | 100 | 150 | 400 | 50 | 150 | 300 | 50 | 150 | 300 | 50 | 150 | 200 | 50 | 0 | 0 | 0
 | [NAME] | 3 | 40 | 100 | 50 | 75 | 200 | 50 | 75 | 100 | 50 | 100 | 100 | 50 | 100 | 300 | 50 | 150 | 200 | 50 | 175
 | Racer 3 | 2000 | 75 | 200 | 50 | 100 | 300 | 50 | 100 | 100 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 6 | 50 | 300 | 50 | 50 | 100 | 50 | 50 | 200 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Racer 5 | 2070 | 35 | 100 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 75 | 200 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 856093d1705480161-find-the-index-of-last-zero-after-which-the-entries-start-increasing-help-with-formula-aligw
Sheet: Sheet1

 | 150 | 140 | 130 | 120 | 110 | 105 | 100 | 95 | 90 | 85 | 80 | 78 | 76 | 74 | 72 | 70 | 68 | 66 | 64 | 62 | 60 | 59 | 58 | 57 | 56 | 55 | 54 | Determined Index
Series 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 10 | 14 | 0 | 15 | 19 | 20
series 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 9 | 10 | 15 | 18 | 18 | 18 | 20
 | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 125 | 130 | 135 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | Determined Index
Series 1 | 20 | 20 | 20 | 16 | 18 | 17 | 15 | 18 | 15 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
series 2 | 20 | 20 | 20 | 20 | 18 | 18 | 17 | 17 | 17 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 720583d1614197283-formula-to-alter-calculation-dependant-on-drop-down-list-value-copy-of-tim-recording-sheet-1-
Sheet: Example

 |  |  |  |  |  |  |  |  |  | WEEK 1 | <=== Selected Week
 |  |  |  |  |  |  |  |  |  | WORK AREA
 | Monday | Minute |  |  |  |  |  |  |  | WorkArea | Minute |  |  |  |  |  |  | Concatenated Hour
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6 |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  | 19
 | Tuesday | Minute |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Total
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7 |  |  |  |  |  |  |  |  |  | Day you're Interested in |  |  | Tuesday
 | 8
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | Description
 | 10 |  |  |  |  |  |  |  |  |  | Code you're interested in: |  |  | C2
 | 11 |  |  |  |  |  |  |  |  |  | Time you're interested in: |  |  | 19:00 - 19:59
 | 12
 | 13 |  |  |  |  |  |  |  |  |  | Number of Instances for the Hour
 | 14 |  |  |  |  |  |  |  |  |  | Number of Instances for the Day
 | 15 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :00
 | 16 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :10
 | 17 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :20
 | 18 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :30
 | 19 |  |  |  |  |  |  |  |  |  | Number of Instances during: |  | :40
 | Wednesday | Minute |  |  |  |  |  |  |  |  | Number of Instances during: |  | :50
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Thursday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | Friday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
Spreadsheet: 647750d1572612423-closest-match-with-multiple-criteria-3-criteria-boxes-breakdown-closest-match-sample-gk2-
Sheet: Sheet1

ID | length | width |  |  |  | [NAME] | length | width
1 | 600 | 400 |  |  |  | Cont1 | 450 | 305
2 | 400 | 300 |  |  |  | Cont2 | 800 | 500
3 | 200 | 150 |  |  |  | Cont3 | 600 | 402
 |  |  |  |  |  | Cont4 | 250 | 200
 |  | WORKING
ID | length | width | depth |  |  | [NAME] | length | width | depth
1 | 600 | 400 | 119 |  |  | Cont4 | 250 | 200 | 175
2 | 400 | 300 | 220 |  |  | Cont1 | 450 | 305 | 430
3 | 200 | 150 | 420 |  |  | Cont3 | 600 | 402 | 250
 |  |  |  |  |  | Cont2 | 800 | 500 | 135
 |  | DON'T KNOW HOW TO GET WORKING
 | MOCKUP: | For ID 1
 | Length 600 matches: |  | Cont2 |  | CLOSEST MATCH |  |  | ANSWER:
 |  |  | Cont3 |  | Cont3 |  |  | Cont3
 | [NAME] 400 matches: |  | Cont2 |  | CLOSEST MATCH
 |  |  | Cont3 |  | Cont3
 | Depth 119 matches: |  | Cont2 |  | CLOSEST MATCH
 |  |  | Cont3 |  | Cont2
Spreadsheet: 864182d1711462669-need-help-split-text-if-possible-with-specific-condition-fm-sof-30e-2
Sheet: Sheet1

Question : How to [NAME] all text separate by "/" or If possible [NAME] all text where the length is 11
MARKS&NUMBERSCONTAINERNO./SEALNO. | What I want is separate with this order if possible |  |  |  |  | RESULT I WANT
MRTU2044435/H827075/1*20GP/ MRTU2086301/H827076/1*20GP/ MRTU2169659/H827073/1*20GP/ MRTU2175965/H827074/1*20GP/ |  |  |  |  |  | MRTU2044435 | MRTU2086301 | MRTU2169659 | MRTU2175965
HPCU4319413/H658405/1*40HC/ HPCU4313776/H658406/1*40HC/ |  |  |  |  |  | HPCU4313776
HPCU2217372/H657912/1*20GP/
HPCU2216890/H657971/1*20GP/ HPCU2231560/H657972/1*20GP/ |  |  |  |  |  |  | HPCU2231560
HPCU2226610/H657902/1*20GP/ HPCU2224896/H657906/1*20GP/ HPCU2229650/H657905/1*20GP/ HPCU2228309/H657903/1*20GP/ HPCU2229178/H657904/1*20GP/ |  |  |  |  |  | HPCU2226610 | HPCU2224896 | HPCU2229650 | HPCU2228309 | HPCU2229178
MRLU5211368/H658676/1*40MH/ MRLU5211603/H658675/1*40MH/ TCNU4450995/H658677/1*40HC/ |  |  |  |  |  |  | [NAME] | TCNU4450995
TMS
Spreadsheet: 269367d1381144093-multiple-ifs-query-excel-fletchk-3-oeldere4-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v look up table
 |  |  | [NAME] | Other data | Term 2 | Other data | Term 3 | Other data | Term 4 |  | Progress |  |  |  |  | 40-60a | 3
 |  |  | 30-50a | 40-60b | 40-60a | 40-60b | 22-36a | 40-60b | 40-60a |  |  |  |  |  |  | 30-50a | 2
 |  |  | 22-36a | 40-60a | 30-50a | 40-60a | 30-50a | 40-60a | 40-60a |  |  |  |  |  |  | 22-36a | 1
 |  |  |  | 40-60c | 22-36a | 40-60c | 40-60a | 40-60c | 40-60a
 | new input |  |  |  |  |  |  |  | 40-60a
 |  |  | In I6 I want to look at the progress from the beginning to the end.
 |  |  | It is always calculated from Term 4 - so it would be term 4 take take 1, however if term 1 is blank, take it from [NAME], however if term 2 is blank take it from term 3, however if term 3 is blank return ""
 |  |  | The v look up table converts the numerical ranges to a number format.
Spreadsheet: 542392d1507832469-classroom-problem-sums-of-rows-with-overlapping-timeslots-excel-problem
Sheet: Time Intervals

Start Time | End Time |  | School A | School B | School C | School D |  | Totals: | How Many Time Slots Overlap? | How Many Classes Overlap? |  | Buffer Time
13:00:00 | 14:00:00 |  | 5 | 10 | 5 | 2
13:30:00 | 14:30:00 |  | 1 | 2 | 9 | 4
14:15:00 | 15:00:00 |  | 3 | 6 | 0 | 7
14:30:00 | 16:30:00 |  | 4 | 2 | 5 | 7
14:31:00 | 16:31:00 |  | 5 | 4 | 2 | 8
16:00:00 | 18:00:00 |  | 0 | 8 | 5 | 0
17:00:00 | 18:15:00 |  | 0 | 22 | 0 | 0
18:10:00 | 19:00:00 |  | 5 | 4 | 12 | 2
18:50:00 | 20:50:00 |  | 10 | 7 | 0 | 3
Spreadsheet: 684370d1593334588-huge-data-to-be-converted-from-a-single-column-to-related-rows-pq-test-rows-to-columns-aligw
Sheet: Sheet1

Column1
[User]
uid=U000569
last_name=LastName1
first_name=FIRST
email_address=[EMAIL]
[User]
uid=u000679
last_name=[NAME]
first_name=Second
email_address=[EMAIL]
[User]
uid=U000832
last_name=LastName3
first_name=third
email_address=[EMAIL]
uid=U000569 | last_name=LastName1 | first_name=FIRST | email_address=[EMAIL]
uid=u000679 | last_name=[NAME] | first_name=Second | email_address=[EMAIL]
uid=U000832 | last_name=LastName3 | first_name=third | email_address=[EMAIL]
0 | 1 | 2 | 3 | 4 | 5
[User] | uid=U000569 | last_name=LastName1 | first_name=FIRST | email_address=[EMAIL]
[User] | uid=u000679 | last_name=[NAME] | first_name=Second | email_address=[EMAIL]
[User] | uid=U000832 | last_name=LastName3 | first_name=third | email_address=[EMAIL]
Spreadsheet: larry_campbell__20959__over-short labor utilities
Sheet: Labor Breakdown

COMPANY | 1022
VCS | (All)
PROFIT_CENTER | (All)
COST_CENTER | (All)
Sum of IS_AMOUNT |  | YEAR | MONTH
 |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | Grand Total
MAIN_ROLLUP | DESC_NATURAL_ACCOUNT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
070 - Labor | Employee Hiring and Retention Fees |  |  |  |  |  |  | -42 |  |  |  | 0 |  | -42
 | Exempt and Non-Exempt Distributed Burden | -46477.01 | -46009.87 | -40866.01 | -36847.84 | -40117.9 | -48891.48 | -40108.09 | -35577.53 | -37236.33 | -40571.18 | -39231.82999999991 | -46643.97 | -498579.04
 | Exempt and SNE Salaries | -97663.76 | -99039.75 | -100705.15 | -95226.47 | -96384.03999999995 | -81901.43 | -91212.46 | -85522.43 | -89084.93 | -97367.62 | -104574.82 | -91251.78 | -1129934.64
 | Incentive Compensation |  |  |  |  |  |  |  |  |  |  |  | -41000 | -41000
 | Meals and Entertainment |  | -28.1 |  |  | -45 | -43.91 |  | -1900.88 |  |  | 3.641531520770513e-14 |  | -2017.89
 | Meals and Entertainment - 100 pct. Non-deductible |  | -7.47 |  |  |  |  |  |  |  |  | 0 |  | -7.47
 | Non-Exempt Wages | -39264.07 | -41577.77 | -37132.75 | -35323.84 | -42297.3 | -67019.12 | -51943.57 | -46176.14 | -47168.65 | -50524.38 | -51650.02999999994 | -79471.65 | -589549.27
 | Other Compensation | -2875 | -8625 | 11500 | -17796.25 | 17096.25 | -159390 | -4992 | -1025.93 | 509.3 |  | 0 |  | -165598.63
 | Overtime Compensation | -15474.8 | -14319.89 | -12523.71 | -13191.43 | -14000.79 | -17114.44 | -14657.48 | -15401.9 | -14420.23 | -16897.74 | -17110.7 | -20065.6 | -185178.71
 | Relocation - All Other |  |  | -6861.41 | -958.41 | -7520.28 | 2849.34 | -10173.64 |  | -5126.62 | -5041.78 | -2887.51 | -2422.65 | -38142.96
 | Relocation - Household Goods |  |  |  |  |  | 3988.74 | -7977.48 |  |  |  | 0 |  | -3988.74
 | Relocation - Housesale Program |  |  | -2000 |  |  | 24509.67 | -62768.91 |  |  |  | 5.456968210637569e-12 |  | -40259.24
 | Shawdow Stock Accrual |  |  |  |  |  |  |  | 0 | 0 |  | -3680 | 0 | -3680
 | Training |  |  | 373.81 |  |  | -1275 | -534.95 |  | -159.93 |  | -4171.88 |  | -5767.95
 | Travel |  | -316.52 | -470.59 | -1066.25 | -1878.65 | -242.86 | -1515.75 | -136.01 |  | -161.12 | -1.84741111297626e-13 |  | -5787.75
 | Travel - 100 pct. Non-Deductible |  |  |  | -216.51 |  | -3082.2 | -500 | -4644.43 | 10.68 |  | -2500 | -900 | -11832.46
 | Travel - P Card | -15018.83 | -27450.97 | -20854.18 | -23549.4 | -21024.2 | -30327.71 |  | -51135.1 | -24987.94 | -24160.96 | -26489.6 | -26039.83 | -291038.72
070 - Labor Total |  | -216773.47 | -237375.34 | -209539.99 | -224176.4 | -206171.91 | -377940.4 | -286426.33 | -241520.35 | -217664.65 | -234724.78 | -252296.37 | -307795.48 | -3012405.47
Grand Total |  | -216773.47 | -237375.34 | -209539.99 | -224176.4 | -206171.91 | -377940.4 | -286426.33 | -241520.35 | -217664.65 | -234724.78 | -252296.37 | -307795.48 | -3012405.47