tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854576d1704398444-dynamically-autopopulate-a-table-populate
Sheet: ACCOUNT STATEMENT

Period
2001/ | 04
2001/ | 05
2001/ | 06
2001/ | 07
2001/ | 08
2001/ | 09
2001/ | 10
2001/ | 11
2001/ | 12
2002/ | 01
2002/ | 02
2002/ | 03
2002/ | 04
2002/ | 05
2002/ | 06
2002/ | 07
2002/ | 08
2002/ | 09
2002/ | 10
2002/ | 11
2002/ | 12
2003/ | 01
2003/ | 02
2003/ | 03
2003/ | 04
2003/ | 05
2003/ | 06
2003/ | 07
2003/ | 08
2003/ | 09
2003/ | 10
2003/ | 11
2003/ | 12
2004/ | 01
2004/ | 02
2004/ | 03
2004/ | 04
2004/ | 05
2004/ | 06
2004/ | 07
2004/ | 08
2004/ | 09
2004/ | 10
2004/ | 11
2004/ | 12
2005/ | 01
2005/ | 02
2005/ | 03
2005/ | 04
2005/ | 05
2005/ | 06
2005/ | 07
2005/ | 08
2005/ | 09
2005/ | 10
2005/ | 11
2005/ | 12
2006/ | 01
2006/ | 02
2006/ | 03
2006/ | 04
2006/ | 05
2006/ | 06
2006/ | 07
2006/ | 08
2006/ | 09
2006/ | 10
2006/ | 11
2006/ | 12
2007/ | 01
2007/ | 02
2007/ | 03
2007/ | 04
2007/ | 05
2007/ | 06
2007/ | 07
2007/ | 08
2007/ | 09
2007/ | 10
2007/ | 11
2007/ | 12
2008/ | 01
2008/ | 02
2008/ | 03
2008/ | 04
2008/ | 05
2008/ | 06
2008/ | 07
2008/ | 08
2008/ | 09
2008/ | 10
2008/ | 11
2008/ | 12
2009/ | 01
2009/ | 02
2009/ | 03
2009/ | 04
2009/ | 05
2009/ | 06
2009/ | 07
2009/ | 08
2009/ | 09
2009/ | 10
2009/ | 11
2009/ | 12
2010/ | 01
2010/ | 02
2010/ | 03
2010/ | 04
2010/ | 05
2010/ | 06
2010/ | 07
2010/ | 08
2010/ | 09
2010/ | 10
2010/ | 11
2010/ | 12
2011/ | 01
2011/ | 02
2011/ | 03
2011/ | 04
2011/ | 05
2011/ | 06
2011/ | 07
2011/ | 08
2011/ | 09
2011/ | 10
2011/ | 11
2011/ | 12
2012/ | 01
2012/ | 02
2012/ | 03
2012/ | 04
2012/ | 05
2012/ | 06
2012/ | 07
2012/ | 08
2012/ | 09
2012/ | 10
2012/ | 11
2012/ | 12
2013/ | 01
2013/ | 02
2013/ | 03
2013/ | 04
2013/ | 05
2013/ | 06
2013/ | 07
2013/ | 08
2013/ | 09
2013/ | 10
2013/ | 11
2013/ | 12
2014/ | 01
2014/ | 02
2014/ | 03
2014/ | 04
2014/ | 05
2014/ | 06
2014/ | 07
2014/ | 08
2014/ | 09
2014/ | 10
2014/ | 11
2014/ | 12
2015/ | 01
2015/ | 02
2015/ | 03
2015/ | 04
2015/ | 05
2015/ | 06
2015/ | 07
2015/ | 08
2015/ | 09
2015/ | 10
2015/ | 11
2015/ | 12
2016/ | 01
2016/ | 02
2016/ | 03
2016/ | 04
2016/ | 05
2016/ | 06
2016/ | 07
2016/ | 08
2016/ | 09
2016/ | 10
2016/ | 11
2016/ | 12
2017/ | 01
2017/ | 02
2017/ | 03
2017/ | 04
2017/ | 05
2017/ | 06
2017/ | 07
2017/ | 08
2017/ | 09
2017/ | 10
2017/ | 11
2017/ | 12
2018/ | 01
2018/ | 02
2018/ | 03
2018/ | 04
2018/ | 05
2018/ | 06
2018/ | 07
2018/ | 08
2018/ | 09
2018/ | 10
2018/ | 11
2018/ | 12
2019/ | 01
2019/ | 02
2019/ | 03
2019/ | 04
2019/ | 05
2019/ | 06
2019/ | 07
2019/ | 08
2019/ | 09
2019/ | 10
2019/ | 11
2019/ | 12
2020/ | 01
2020/ | 02
2020/ | 03
2020/ | 04
2020/ | 05
2020/ | 06
2020/ | 07
2020/ | 08
2020/ | 09
2020/ | 10
2020/ | 11
2020/ | 12
2021/ | 01
2021/ | 02
2021/ | 03
2021/ | 04
2021/ | 05
2021/ | 06
2021/ | 07
2021/ | 08
2021/ | 09
2021/ | 10
2021/ | 11
2021/ | 12
2022/ | 01
2022/ | 02
2022/ | 03
2022/ | 04
2022/ | 05
2022/ | 06
2022/ | 07
2022/ | 08
2022/ | 09
2022/ | 10
2022/ | 11
2022/ | 12
2023/ | 01
2023/ | 02
2023/ | 03
2023/ | 04
2023/ | 05
2023/ | 06
2023/ | 07
2023/ | 08
2023/ | 09
2023/ | 10
2023/ | 11
2023/ | 12
Spreadsheet: 153697d1336016028-is-this-a-complicated-countifs-formula-or-something-else-counting-yes
Sheet: Sheet1

Yes | No | No
No | Yes | No
Yes | Yes | No
No | No | Yes
No | No | No
Spreadsheet: 868591d1715278579-generate-spill-array-to-determine-the-performance-of-a-department-grades
Sheet: Sheet1

 | Excellent | Good | Better | Fair | Poor | % |  |  |  | Criteria
Department-1 |  |  | ü |  |  | 0.67 |  |  |  | Min | [NAME]
Department-2 |  |  |  | ü |  | 0.54 |  |  | Poor | 0 | 0.4
Department-3 |  |  |  |  |  | 0.89 |  |  | Fair | 0.4 | 0.6
[NAME] |  |  |  |  |  | 0.9 |  |  | Better | 0.6 | 0.7
Department-5 |  |  |  | ü |  | 0.49 |  |  | Good | 0.7 | 0.85
Department-6 |  | ü |  |  |  | 0.7 |  |  | Excellent | 0.85 | 1
Department-7 |  |  |  |  |  | 0.85
Department-8 |  |  |  |  | ü | 0.36
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Aluminum 80

233-A Jefferson Street • Newnan, GA 30263
 | Quantity
Size | 18 | 24 | 36 | 48 | 60 | 72 | 96
12 | 25 | 40 | 45 | 60 | 130 | 130 | 120
18 | 25 | 40 | 45 | 60 | 130 | 130 | 120
24 | 25 | 40 | 45 | 60 | 130 | 130 | 120
36 | 25 | 40 | 60 | 60 | 130 | 130 | 120
48 | 25 | 40 | 60 | 65 | 110 | 110 | 110
Spreadsheet: 889774d1740686183-need-excel-formula-to-show-location-wise-number-of-hires-in-specific-month-to-upload-sabahi2-
Sheet: Task 5

 |  | What is the total number of staff hired per month in each location?
 |  | Location | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-12-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00
 |  | Bucharest
 |  | [NAME]
 |  | Kyiv
 |  | Lodz
 |  | London
 |  | New York
 |  | Wroclaw
 |  | Total
Spreadsheet: 290909d1390016001-disable-table-formulas-eg-column4-but-dont-convert-table-to-range-tables
Sheet: Sheet1

 |  | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11
 |  | 16 | 13
 |  | 10 | 4
 |  | 18 | 15
 |  | 13 | 17
 |  | 14 | 9
 |  | 20 | 17
 |  | 14 | 6
 |  | 18 | 20
 |  | 10 | 15
 |  | 9 | 8
 |  | 6 | 12
 |  | 10 | 13
 |  | 19 | 12
 |  | 8 | 11
 |  | 9 | 14
 |  | 6 | 20
 |  | 18 | 14
 |  | 16 | 13
 |  | 13 | 11
Spreadsheet: 696749d1600960141-nested-if-function-orderboek-en-salesplanning-question-excel-forum
Sheet: RVC vs Sales

RVC | RVC | RVC |  | 2014-07-02 00:00:00 | 2014-07-02 00:00:00 | % | omzet impact
good | BCI | 30000 |  | BCI | 30000 | 0.4
good | Bionext | 75000 |  | Bionext | 62500 | 0.4
good | Cashew | 70000 |  |  |  | 0.4
good | [NAME] | 75000 |  |  |  | 0.4
good | [NAME] | 125000 |  |  |  | 0.4
good | Givaudan | 57500 |  |  |  | 0.4
good | IDH | 75000 |  |  |  | 0.4
good | Mars | 20000 |  | Mars | 20000 | 0.4
good | MSD France | 45000 |  |  |  | 0.4
good | Sofiprotéol | 75000 |  |  |  | 0.4
good | Uneal | 75000 |  |  |  | 0.4
 |  |  |  | [NAME] | 4500 | 0.4
 |  |  |  | [NAME] | 20000 | 0.4
 |  |  |  | The Greenery | 25000 | 0.4
reasonable | 4 C Association | 60000 |  | 4 C Association | 60000 | 0.2
reasonable | Axereal | 17500 |  | Axereal | 17500 | 0.2
reasonable | Barilla | 22500 |  | Barilla | 22500 | 0.2
reasonable | Bell | 20000 |  | Bell | 20000 | 0.2
reasonable | Comore | 35000 |  | Comore | 35000 | 0.2
reasonable | DVT | 87500 |  | DVT | 87500 | 0.2
reasonable | Fleury-Michon | 20000 |  | Fleury-Michon | 20000 | 0.2
reasonable | [NAME] | 75000 |  | [NAME] | 75000 | 0.2
reasonable | [NAME] | 35000 |  | [NAME] | 35000 | 0.2
reasonable | IBMA | 17500 |  | IBMA | 17500 | 0.2
reasonable | ITC | 20000 |  | ITC | 20000 | 0.2
reasonable | [NAME] | 17500 |  | [NAME] | 17500 | 0.2
reasonable | Landgard | 50000 |  | Landgard | 50000 | 0.2
reasonable | Marks & Spencer | 115000 |  | Marks & Spencer | 115000 | 0.2
reasonable | Nutrea | 20000 |  | Nutrea | 20000 | 0.2
reasonable | Techna | 17500 |  | Techna | 17500 | 0.2
reasonable | Textile Exchange | 90000 |  | Textile Exchange | 90000 | 0.2
reasonable | VION | 100000 |  | VION | 100000 | 0.2
reasonable | [NAME] | 45000 |  | [NAME] | 45000 | 0.2
reasonable | RSPO | 125000 |  |  |  | 0.2
 |  |  |  | IDH | 75000 | 0.2
 |  |  |  | Questionmark | 110000 | 0.2
 |  |  |  | SCOPEinsight | 62500 | 0.2
 |  |  |  | The Greenery | 10000 | 0.2
Spreadsheet: phillip_m_love__30154__9903_OA
Sheet: TX-HPL-VAR 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  HPL
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 821553d1678793474-find-column-headers-question-1-
Sheet: Sheet1

M001 | M002 | M003 | M004 | M005 | M006 | M007 | M008 | M009 | M010 | M011 | M012 | M013 | M014 |  |  | Value | 11.05.00005
05.06.00006 | 05.12.00003 | 05.11.00001 | 05.12.00004 | 05.16.00001 | 05.16.00001 | 09.01.00001 | 09.01.00001 | 09.01.00001 | 09.01.00001 | 09.01.00001 | 09.01.00001 | 09.01.00001 | 09.01.00001
05.06.00007 |  | 28.01.00052 |  | 35.12.00001 |  | 11.05.00005 | 11.05.00005 | 11.05.00005 | 11.05.00005 | 11.05.00005 | 11.05.00005 | 11.05.00005 | 11.05.00005 |  |  | Result
05.06.00008 |  | 28.01.00054 |  | 35.12.00001 |  | 11.05.00007 | 11.05.00007 | 11.05.00007 | 11.05.00007 | 11.05.00007 | 11.05.00007 | 11.05.00007 | 11.05.00007 |  |  | M007
11.05.00007 |  | 28.01.00055 |  | 35.12.00004 |  | 11.05.00008 | 11.05.00008 | 11.05.00008 | 11.05.00008 | 11.05.00008 | 11.01.00002 | 11.05.00008 | 11.05.00008 |  |  | M008 | M008
 |  | 28.01.00061 |  | 11.01.00002 |  | 11.25.00074 | 11.25.00074 | 11.25.00074 | 11.25.00074 | 11.25.00074 | 11.02.00003 | 11.25.00074 | 11.25.00074 |  |  | M009 | M009
 |  | 28.01.00057 |  | 11.02.00003 |  | 11.02.0B011 | 11.02.00003 | 11.02.00003 | 11.01.00001 |  | 11.02.0B011 | 11.02.00008 | 11.34.00076 |  |  | M010 | M010
 |  | 28.02.00070 |  |  |  | 11.02.0B012 | 11.02.00006 | 11.02.00006 | 11.01.00002 |  | 11.02.0B012 | 11.02.00009 | 11.34.00079 |  |  | M011 | M011
 |  | 28.06.E0001 |  |  |  | 11.02.RS001 | 11.02.00008 | 11.02.00008 | 11.02.00003 |  | 11.02.RS001 | 11.02.00010 | 11.34.00081 |  |  | M012 | M012
 |  | 11.34.00083 |  |  |  | 11.02.RS002 | 11.02.00009 | 11.02.00009 | 11.02.00006 |  | 11.02.RS002 | 11.34.00078 | 11.34.00082 |  |  | M013 | M013
 |  | 11.34.00078 |  |  |  | 11.02.RS003 | 11.02.00010 | 11.02.00010 | 11.02.00008 |  | 11.02.RS003 | 11.34.00086 | 11.34.00083 |  |  | M014 | M014
 |  |  |  |  |  | 11.03.00015 | 11.02.0B011 | 11.02.0B011 | 11.02.00009 |  | 11.03.00015 | 11.34.00088 | 11.34.00078
 |  |  |  |  |  | 11.03.00016 | 11.02.0B012 | 11.02.0B012 | 11.02.00010 |  | 11.03.00016 | 11.34.00089 | 11.34.00086
 |  |  |  |  |  | 11.04.00017 | 11.02.RS001 | 11.02.RS001 | 11.02.0B011 |  | 11.04.00017 | 11.34.00090 | 11.34.00088
 |  |  |  |  |  | 11.05.00013 | 11.02.RS002 | 11.02.RS002 | 11.02.0B012 |  | 11.05.00013 |  | 11.34.00089
 |  |  |  |  |  | 15.05.00004 | 11.02.RS003 | 11.02.RS003 | 11.02.RS001 |  |  |  | 11.34.00090
 |  |  |  |  |  |  | 11.03.00015 | 11.03.00015 | 11.02.RS002
 |  |  |  |  |  |  | 11.03.00016 | 11.03.00016 | 11.02.RS003
 |  |  |  |  |  |  | 11.04.00017 | 11.04.00017 | 11.03.00015
 |  |  |  |  |  |  | 11.05.00013 | 11.05.00013 | 11.03.00016
 |  |  |  |  |  |  | 15.10.00001 | 15.05.00005 | 11.04.00017
 |  |  |  |  |  |  |  | 21.01.FX070 | 11.05.00013
 |  |  |  |  |  |  |  |  | 35.12.00001
 |  |  |  |  |  |  |  |  | 35.12.00001
 |  |  |  |  |  |  |  |  | 35.12.00004
Spreadsheet: 106226d1303399527-yy-axis-completely-off-lambdavsn
Sheet: Sheet2

AZ 4562 |  |  | AZ 5214 E |  |  | AZ 9260 |  |  |  |  | AZ 4562 |  |  | AZ 5214 E |  |  | AZ 9260
LAMBDA (nm) | n |  | n |  |  | n |  |  |  |  | N1 |  |  | N1 |  |  | N1
 |  |  |  |  |  |  |  |  |  |  | N2 |  |  | N2 |  |  | N2 | 0.0099583
 |  |  |  |  |  |  |  |  |  |  | N3 |  |  | N3 | 0.00234 |  | N3 | 0.000716
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: Styrene

Raw Material |  | Styrene
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00
2023-10-02 00:00:00 |  | 15 | 190
2023-10-02 00:00:00 |  |  |  |  | 950
2023-10-03 00:00:00 |  |  |  |  | 950
2023-10-04 00:00:00 |  |  |  |  | 950
2023-10-05 00:00:00 |  | 15 | 190
Total
Spreadsheet: 65407d1266105269-formula-to-distinguish-month-year-from-prior-month-years-excel-spreadsheet-with-formulas
Sheet: Tab 3

 | Date | Company | Invoice # | Description
1 | 2009-02-18 00:00:00 |  |  |  |  |  |  |  | 110000
2 | 2009-02-18 00:00:00 |  |  |  |  |  |  |  |  | 177184
3 | 2009-02-28 00:00:00 |  |  |  |  |  |  | 2768.5
4 | 2009-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2350
5 | 2009-03-20 00:00:00 |  |  |  |  |  |  |  |  | 44296
6 | 2009-03-20 00:00:00 |  |  |  |  |  |  | 2768.5
7 | 2009-03-20 00:00:00 |  |  |  |  |  |  |  |  |  | 83055
8 | 2009-04-17 00:00:00 |  |  |  |  |  |  |  |  |  | 193795
9 | 2009-04-17 00:00:00 |  |  |  |  |  |  | 2768.5
10 | 2009-04-17 00:00:00 |  |  |  |  | 11779.58
11 | 2009-05-13 00:00:00 |  |  |  | 276850
12 | 2009-05-13 00:00:00 |  |  |  |  |  |  | 2768.5
13 | 2009-06-19 00:00:00 |  |  |  | 221480
14 | 2009-06-19 00:00:00 |  |  |  |  |  |  | 5537
15 | 2009-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2350
16 | 2009-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 17100
17 | 2009-07-13 00:00:00 |  |  |  |  |  |  | 5537
18 | 2009-07-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | 14100
19 | 2009-08-19 00:00:00 |  |  |  | 55370
20 | 2009-08-19 00:00:00 |  |  |  |  |  |  | 22148
21 | 2009-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 5700
22 | 2009-08-19 00:00:00 |  |  |  |  | 1677
23 | 2009-09-15 00:00:00 |  |  |  |  |  |  | 5537
24 | 2009-09-15 00:00:00 |  |  |  |  | 686.79
25 | 2009-09-15 00:00:00 |  |  |  |  |  |  |  |  |  |  | 9400
26 | 2009-10-13 00:00:00 |  |  |  |  |  |  | 2768.5
27 | 2009-11-17 00:00:00 |  |  |  |  |  |  | 2768
28 | 2009-11-17 00:00:00 |  |  |  |  | 4296.89
29 | 2009-12-09 00:00:00 |  |  |  |  |  | 33222
30 | 2009-12-09 00:00:00 |  |  |  |  | 2059.78
31 | 2010-01-28 00:00:00 |  |  |  |  |  | 37968
 |  |  |  |  | 553700 | 20500.04 | 71190 | 55369.5 | 110000 | 221480 | 276850 | 28200 | 22800 | 1360089.54
Spreadsheet: 864013d1711376343-sort-unique-from-multiple-columns-if-criteria-met-filter-mutiple-columns-based-on-criteria-6-aligw
Sheet: Sheet1

 |  | State | Color 1 | Color 2 | Color 3 | Color 4 |  | Colors if State selected |  | Colors (ALL) |  | Desired Outcome
 |  | GEORGIA | Red | Green |  |  |  |  |  | beige |  | Black
CALIFORNIA |  | GEORGIA | Yellow | Green |  | Gray |  | Blue |  | Black |  | Gray
 |  | MARYLAND |  | [NAME] |  |  |  | [NAME] |  | blue |  | Green
 |  | GEORGIA | Gray | Yellow |  | Black |  | Gray |  | blue violet |  | Orange
 |  | FLORIDA |  | Maroon |  | Green |  | Green |  | [NAME] |  | Red
 |  | GEORGIA | Orange | Red | White |  |  | Maroon |  | crimson |  | White
 |  | OHIO | Blue | Gray | Yellow | Gray |  | Orange |  | [NAME] |  | Yellow
 |  |  |  |  |  |  |  | Red |  | gold
 |  |  |  |  |  |  |  | White |  | gray
 |  |  |  |  |  |  |  | Yellow |  | green
 |  |  |  |  |  |  |  |  |  | indigo
 |  |  |  |  |  |  |  |  |  | khaki
 |  |  |  |  |  |  |  |  |  | lavender
 |  |  |  |  |  |  |  |  |  | lime green
 |  |  |  |  |  |  |  |  |  | magenta
 |  |  |  |  |  |  |  |  |  | maroon
 |  |  |  |  |  |  |  |  |  | navy blue
 |  |  |  |  |  |  |  |  |  | olive
 |  |  |  |  |  |  |  |  |  | orange
 |  |  |  |  |  |  |  |  |  | pink
 |  |  |  |  |  |  |  |  |  | plum
 |  |  |  |  |  |  |  |  |  | purple
 |  |  |  |  |  |  |  |  |  | red
 |  |  |  |  |  |  |  |  |  | salmon
 |  |  |  |  |  |  |  |  |  | silver
 |  |  |  |  |  |  |  |  |  | sky blue
 |  |  |  |  |  |  |  |  |  | teal
 |  |  |  |  |  |  |  |  |  | violet
 |  |  |  |  |  |  |  |  |  | white
 |  |  |  |  |  |  |  |  |  | yellow
Spreadsheet: 219187d1362679444-automatically-updating-multiple-sheets-to-a-master-sheet-master-test
Sheet: 5.

Test |  |  |  |  |  |  | Target |  | Actual |  |  |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
Activity | Core | Stream | Task | Milestone | Accountable | External | Start | End | Actual | Actual End Date | Status | Funding | Notes/Location | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
5 | Main Title
5.1 | Title
5.1
5.1
5.2 | Title
5.2
5.2
5.2
Spreadsheet: 806973d1669703338-transfer-of-data-from-a-master-sheet-to-other-sheets-quest
Sheet: g journal

Inv | Date | Decription | Debit | Credit | Amount
1 | 2022-02-01 00:00:00 | rent | Cash In Bank | Cash In Hand | 100
2 | 2022-02-02 00:00:00 | rent | Saleem | Cash In Hand | 300
3 | 2023-06-04 00:00:00 | rent | Cash In Hand | Saleem | 700
4 | 2023-02-05 00:00:00 | rebt | Cash In Bank | Co-Operative Bank | 1000
5 | 2024-06-06 00:00:00 | rett | Cash In Hand | Co-Operative Bank | 500
6 | 2023-06-07 00:00:00 | rent | Shafeeq | Cash In Hand | 10000
Spreadsheet: 65680d1266362380-excel-2007-sorting-how-to-get-a2-come-before-a10-book1
Sheet: Sheet1

SetCode | bympg | fzrtz
A1 | 0 | 0
A10 | 47426 | 25894577.16
A11 | 900283 | 12907055.97
A12 | 0 | 0
A13 | 761 | 78397.61
A14 | 1214590 | 255453182.53
A15 | 0 | 0
A16 | 0 | 0
A17 | 57841 | 57841
A18 | 0 | 0
A19 | 4096 | 117128.46
A2 | 142 | 13789.57
A20 | 4092 | 22616.15
A3 | 129 | 285189.47
A4 | 5955 | 6427
A5 | 614 | 767.5
A6 | 4907 | 24520
A7 | 37400 | 1009557
A8 | 1173 | 15249
A9 | 4904 | 24520
aa1 | 0 | 0
aa2 | 0 | 0
aa3 | 583785 | 5721191.5
aa4 | 0 | 0
aaa1 | 0 | 0
b1 | 179302 | 545519.25
B2 | 5299867 | 10694189.6
b3 | 47619 | 47626
b4 | 312 | 624
ba1 | 312 | 1170
ba3 | 0 | 0
c1 | 0 | 0
c2 | 2257911 | 4511762.25
c3 | 0 | 0
cc4 | 0 | 0
d1 | 21235 | 849373
e1 | 4721051 | 100130958.95
e3 | 5309961 | 5358133
e5 | 0 | 0
vx2 | 5312310 | 22800910.2
Spreadsheet: 55969d1256127299-how-to-show-users-in-groups-from-report-example2-1-
Sheet: Sheet4

Count of User | User
Group | user1 | user10 | user2 | user3 | user4 | user5 | [NAME] | user7 | user8 | [NAME] | Grand Total
Group1 | 1 |  |  |  | 1 |  | 1 |  |  |  | 3
Group2 |  |  | 1 |  |  |  | 1 | 1 |  |  | 3
Group3 |  |  |  | 1 |  |  |  |  | 1 | 1 | 3
Group4 |  | 1 |  |  | 1 |  |  |  |  | 1 | 3
Group5 |  | 1 |  | 1 |  | 1 |  |  |  |  | 3
Grand Total | 1 | 2 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 2 | 15
Spreadsheet: 819547d1677576250-finding-the-percentage-of-different-categories-data
Sheet: Sheet1

year | code | A6 | 5 | 4 | 3 | 2 | 1 |  | year | code | band (1-A6)
2022 | 152246 | (0/6)*100 | (1/6)*100 | (0/6)*100 | (1/6)*100 | (2/6)*100 | (2/6)*100 |  | 2022 | 152246 | 1
2022 | 24683 | (2/2)*100 | (0/2)*100 | (0/2)*100 | (0/2)*100 | (0/2)*100 | (0/2)*100 |  | 2022 | 152246 | 1
2022 | 356498 |  |  |  |  |  |  |  | 2022 | 152246 | 2
2023 | 152246 |  |  |  |  |  |  |  | 2022 | 24683 | A6
2023 | 24683 |  |  |  |  |  |  |  | 2022 | 24683 | A6
2023 | 356498 |  |  |  |  |  |  |  | 2022 | 152246 | 2
 |  |  |  |  |  |  |  |  | 2022 | 356498 | 2
 |  | Desired Results |  |  |  |  |  |  | 2022 | 152246 | 3
year | code | 1 | 2 | 3 | A6 | 4 | 5 |  | 2022 | 356498 | 4
2022 | 24683 |  |  |  | 1 |  |  |  | 2022 | 356498 | 3
2022 | 152246 | 0.333333333333333 | 0.333333333333333 | 0.166666666666667 |  |  | 0.166666666666667 |  | 2022 | 152246 | 5
2022 | 356498 | 0.25 | 0.25 | 0.25 |  | 0.25 |  |  | 2022 | 356498 | 1
2023 | 24683 |  |  |  |  | 0.5 | 0.5 |  | 2023 | 152246 | 1
2023 | 152246 | 0.333333333333333 | 0.166666666666667 | 0.166666666666667 | 0.166666666666667 |  | 0.166666666666667 |  | 2023 | 152246 | 1
2023 | 356498 |  | 0.333333333333333 | 0.333333333333333 |  | 0.333333333333333 |  |  | 2023 | 152246 | 2
 |  |  |  |  |  |  |  |  | 2023 | 24683 | 4
 |  |  |  |  |  |  |  |  | 2023 | 24683 | 5
 |  |  |  |  |  |  |  |  | 2023 | 152246 | A6
 |  |  |  |  |  |  |  |  | 2023 | 356498 | 2
 |  |  |  |  |  |  |  |  | 2023 | 152246 | 3
 |  |  |  |  |  |  |  |  | 2023 | 356498 | 4
 |  |  |  |  |  |  |  |  | 2023 | 356498 | 3
 |  |  |  |  |  |  |  |  | 2023 | 152246 | 5
Spreadsheet: 850539d1700908227-textjoin-formula-with-2-expetions-excel-test
Sheet: test

 | Ingredients | Allergens |  |  |  |  |  | K/cal | K/j | Fats gr | sat. fats | Carbs | sugars | [NAME] | salt
 | Sushi rice | 0 | 0 | 0 | 0 | 0 | 0 | 359.2948347457627 | 1506.918028771187 | 3.867161016949153 | 0.5366949152542373 | 74.4399936440678 | 8.704796610169488 | 5.865466101694915 | 1.238080508474576
 | salmon | FISH | 0 | 0 | 0 | 0 | 0 | 56.59500000000001 | 237.1330500000001 | 1.155 | 1.1 | 0 | 0 | 11.55 | 0
 | Edamame beans | SOY | 0 | 0 | 0 | 0 | 0 | 48.8 | 204.316 | 2 | 0.24 | 4 | 0.8800000000000001 | 4.4 | 0.004
 | Marinated Wakame seaweed | SESAM | 0 | 0 | 0 | 0 | 0 | 5.264797507788161 | 22.04267912772585 | 0.06230529595015576 | 0.02180685358255451 | 0.09345794392523364 | 0 | 0.5295950155763239 | 0.3862928348909657
 | Avocado | 0 | 0 | 0 | 0 | 0 | 0 | 4.255 | 17.82845 | 0.025 | 0.00925 | 0.7825000000000001 | 0.4175 | 0.1625 | 0.00125
 | Red cabbage | 0 | 0 | 0 | 0 | 0 | 0 | 7.75 | 32.4475 | 0.04 | 0.005 | 1.275 | 0.9250000000000002 | 0.3575 | 0.0125
 | [NAME] dressing | SOY | GLUTEN | 0 | 0 | 0 | 0 | 132.99693 | 557.4057313000001 | 13.956382 | 1.570228 | 1.559184 | 1.15874 | 0.3849559999999999 | 1.1033638
 | White sesam | SESAM | 0 | 0 | 0 | 0 | 0 | 6.22 | 25.82 | 0.496 | 0.078 | 0.246 | 0.011 | 0.193 | 6e-05
 | Black sesam | SESAM | 0 | 0 | 0 | 0 | 0 | 6.22 | 25.82 | 0.496 | 0.078 | 0.246 | 0.011 | 0.193 | 6e-05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nutritional values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nutritional velues /100g
 |  | In the C17 I'd like to have written FISH, SOY, SESAM, GLUTEN.
 |  | This formula doesn't pick 0s, but doesn't allow me to get each text value only once
Spreadsheet: 832221d1686190118-search-cell-text-for-specific-values-specific-1-
Sheet: Sheet1

item num | type
serv123
wksta123 |  |  | serv123 | SERVER
tblt123 |  |  | wksta123 | WORKSTATION
serv123-456 |  |  | lptp123 | LAPTOP
serv123-457 |  |  | tblt123 | TABLET
serv123-458 |  |  | iph123 | PHONE
serv123-459
serv123-460
serv123-461
serv123-462
serv123-463
wksta123-AS23
wksta123-AS24
wksta123-AS25
wksta123-AS26
wksta123-AS27
wksta123-AS28
[NAME]
wksta123-AS30
wksta123-AS31
wksta123-AS32
lptp123-AD32
lptp123-AD33
lptp123-AD34
lptp123-AD35
lptp123-AD36
lptp123-AD37
lptp123-AD38
lptp123-AD39
lptp123-AD40
lptp123-AD41
tblt123-AD67
tblt123-AD68
tblt123-AD69
tblt123-AD70
tblt123-AD71
tblt123-AD72
tblt123-AD73
tblt123-AD74
tblt123-AD75
tblt123-AD76
iph123-325
iph123-326
iph123-327
iph123-328
iph123-329
iph123-330
iph123-331
iph123-332
iph123-333
iph123-334
Sox-020694
Sox-02069H
Spreadsheet: 777686d1650551972-count-blank-cells-in-binary-data-s-table-blank-cells
Sheet: Feuil1

datas
 |  | Numbers of consecutives blanks cells | frequency
 |  |  | 1 | -1
-1 |  | 0 | 10 | 17
 |  | 1 | 9 | 5
1 |  | 2 | 3 | 3
 |  | 3 | 0 | 1
 |  | 4 | 2 | 0
 |  | 5 | 1 | 0
-1 |  | 6 | 0 | 0
1 |  | 7 | 0 | 0
-1 |  | 8 | 0 | 0
 |  | 9 | 0 | 0
 |  | 10 | 0 | 0
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1
1
-1