tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25620__77M
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  077M
COMPANY NAME    MEP Services, Inc.
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  | 1064360 |  |  |  |  |  |  |  |  |  |  |  | -215624
Gross PP & E
Accumulated DD & A |  | -446221 |  |  |  |  |  | -6818 |  |  |  |  |  | 95724
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
Amortization of Franchise Fee |  | 1417 |  | 6000 |  |  | (1) Reclassification between property
Depreciation Expense in Cost of Sales |  | 1150 |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  |  |  |  |  |  |  | [NAME], Inc - 077N |  |  |  | -107321 |  | 44745 |  | -62576
 |  |  |  |  |  |  |  | PBM Mechanical Inc - 077L |  |  |  | -108303 |  | 50979 |  | -57324
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: a540bc3a-13f4-4174-8d34-82c931c2144f
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688621322 | [NAME] | Christmas In Black & White | 2002-09-03 | Compact Disc | Seasonal | 9.99 | Y | Available
Word Records | 80688627720 | [NAME] | Live From Cincinnati...Bringing It Home | 2003-10-28 | Compact Disc | Ac | 13.99 | N | To Be Retired
Word Records | 80688631727 | [NAME] | Everyday People | 2004-09-14 | Compact Disc | Ac | 13.99 | N | To Be Retired
Word Records | 80688714420 | [NAME] | Sharecropper'S Seed Volume 1 | 2007-04-03 | Compact Disc | Ac | 13.99 | N | To Be Retired
Word Records | 80688793227 | [NAME] | Ultimate Collection, The | 2009-06-02 | Compact Disc | Ac | 13.99 | Y | Available
Word Records | 80688809829 | [NAME] | Top Ten | 2010-08-24 | Compact Disc | Ac | 7.99 | Y | Available
Word Records | 80688612726 | [NAME] | Talk About It | 2001-08-14 | Compact Disc | Ac Pop | 7.99 | N | To Be Retired
Word Records | 80688656928 | [NAME] | Redeemer: The Best Of [NAME] | 2006-05-09 | Compact Disc | Ac | 13.99 | Y | Available
Word Records | 80688678920 | [NAME] | Call On [NAME] | 2006-07-11 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688720728 | [NAME] | Convinced | 2007-06-26 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688720827 | [NAME] | I Wish | 2007-05-01 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688720926 | [NAME] | One Touch (Press) | 2007-05-22 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80689470622 | [NAME] | I Am | 2005-02-18 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Word Records | 80688681326 | [NAME] | Heaven | 2006-07-11 | Studio Series 3-Key CD Trax | Na | 9.99 | N | To Be Retired
Word Records | 80688680121 | [NAME] | On My Knees | 2006-07-11 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688678722 | [NAME] | Redeemer | 2006-07-11 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688655099 | [NAME] | Live From Cincinnati...Bringing It Home Amaray | 2006-04-11 | Music DVD | Pop | 11.97 | N | To Be Retired
Print Music, Word Owned * | 80689466281 | [NAME] | Live From Cincinnati...Bringing It Home | 2003-12-19 | Vocal Folio | Na | 16.95 | N | To Be Retired
Spreadsheet: 829194d1684019618-merging-index-and-sumproduct-formula-schedulecheck_lln01
Sheet: Sheet2

Item | Dept. | Person | Start Date | Hrs | Finish date
Item A | Dept 1 | [NAME] | 2023-05-15 00:00:00 | 15
Item B | Dept 1 | Mark | 2023-05-15 00:00:00 | 15
Item C | Dept 1 | [NAME] | 2023-05-17 00:00:00 | 15
Item D | Dept 1 | Mark | 2023-05-17 00:00:00 | 23
Item A | Dept 2 | [NAME] | 2023-05-15 00:00:00 | 23
Item B | Dept 2 | [NAME] | 2023-05-15 00:00:00 | 7
Item C | Dept 2 | [NAME] | 2023-05-18 00:00:00 | 23
Item D | Dept 2 | [NAME] | 2023-05-16 00:00:00 | 7
Item A | Dept 3 | [NAME] | 2023-05-15 00:00:00 | 31
Item B | Dept 3 | [NAME] | 2023-05-15 00:00:00 | 15
Item C | Dept 3 | [NAME] | 2023-05-19 00:00:00 | 31
Item D | Dept 3 | [NAME] | 2023-05-17 00:00:00 | 15
Item A | Dept 4 | [NAME] | 2023-05-12 00:00:00 | 39
Item B | Dept 4 | [NAME] | 2023-05-15 00:00:00 | 23
Item C | Dept 4 | [NAME] | 2023-05-12 00:00:00 | 39
Item D | Dept 4 | [NAME] | 2023-05-18 00:00:00 | 23
ps: Life is simpler if you avoid merged cells and blank rows.
Spreadsheet: 673308d1587309261-extracting-data-from-a-table-with-multiple-rows-and-columns-spice-recipe-analyses-ba-ef
Sheet: BC Spice range recipes

 | [NAME] | [NAME]
Absinthe
Achiote
Allspice | 2 |  |  |  | Desired end result:
Angelica
Anise |  | 2 |  |  | [NAME]
Annatto |  |  |  |  | Allspice | 2
Anti Caking Agent | 3 |  |  |  | [NAME] | 2
Asafoetida |  |  |  |  | [NAME] | 2.5
Balm |  | 1 |  |  | [NAME] | 2.5
Basil |  |  |  |  | Anti Caking Agent | 3
[NAME] | 2 | 1 |  |  | Black Pepper Ground | 4
Bay Leaves |  |  |  |  | Mustard Seeds Ground | 4
Bergamot |  |  |  |  | Garam Masala | 8
Black Cumin |  |  |  |  | Coriander [NAME] | 17
Black mustard |  |  |  |  | [NAME] | 17
Black Pepper Cracked/ coarse |  | 1 |  |  | [NAME] | 17
Black Pepper Ground | 4 |  |  |  | Kashmiri Mirch (Chilli) | 125
Black Pepper Whole
Borage
[NAME]
Brown mustard
Buchu
Burnet
California Bay Leaf
Capers
Caraway Seeds
Cardamom Ground
Cardamom Whole
Carom (Ajwain)
[NAME]
Catnip
Cayenne Pepper
Cayenne Pepper Extra Hot
Cayenne Pepper Whole
Celery Seeds
Chamomile
Chervil
[NAME]
Chicory
Chili pepper
[NAME]
[NAME]
Chinese Five Spice
Chives
Cicely
Cilantro
[NAME]
[NAME]
[NAME]
Cloves Whole
Coriander [NAME] |  | 1
Coriander [NAME] | 17
Coriander [NAME]
Costmary
[NAME] | 17
Cumin Seeds Whole
Curry leaf
Dextrose (Sugar)
Dill Seed
[NAME]
Fennel Seeds Whole
Fenugreek
Field mint
Filé
Galangal Root Ground
Garam Masala | 8
Garden nasturtium
[NAME] |  | 1
[NAME] | 2.5
[NAME] | 2.5
[NAME]
Gochugaru
Grains of Paradise
Horehound
Horseradish
[NAME]
Italian Herbs
Juniper berries
[NAME]
Kashmiri Mirch (Chilli) | 125
Lavender
Lemon
lemon balm
lemon grass
Lemon verbena
Licorice
Loomi
Lovage
[NAME]
Mahleb
Makrut lime
[NAME]
Marjoram Leaves
Mexican [NAME]
Mint
[NAME]
MSG
Mustard Seeds Coarsley Ground Yellow |  | 0.5
Mustard Seeds Ground | 4
Mustard Seeds Wholes
[NAME]
Myrtle
[NAME]
[NAME]
Nutritional Yeast
Onion Flakes |  | 1
Onion Powder
Oregano
[NAME] |  | 1
[NAME]
[NAME]
Parsley Flakes
Pepper White Gound
Peppercorns Pink
Peppermint
Pimento
Poppy Seeds
Pumpkin Spice
Red Pepper
Rosemary
Rue
Saffron
Sage Leaves Ground
Salt coarse
Salt fine |  | 1
Savory
Sesame Seeds
Sichuan pepper
Sorrel
Spearmint
Star Anise
Sumac
Szechuan Peppercorns
Tamarind
Tarragon
Thyme
[NAME] | 17
Vanilla
Wasabi
Wormwood
[NAME]
Zedoary
Spreadsheet: 428839d1446811253-max-function-sample
Sheet: Sheet1

 | A | B | C
apple | 3 | 2 | 3
peach | 2 | 2 | 2
grapes | 4 | 4 | 2
orange | 2 | 2 | 1
The most expensive place
apple
peach
grapes
orange
Spreadsheet: 105470d1302807397-can-excel-find-the-missing-numbers-for-_-_-2-book1
Sheet: Sheet2

Desired value | 10
49
71
3 | 7 | A137
80
39
13
97
60
38
90
10 | 0 | A58
35
50
43
12
17
51
98
98
42
23
27
93
5 | 5 | A24
6 | 4 | A106
85
82
53
78
70
44
94
89
99
78
27
44
42
27
15
22
18
95
60
6 | 4 | A106
95
64
48
39
38
1 | 9 | A93
84
51
35
86
31
15
0 | 10 | A11
57
44
33
19
91
42
1 | 9 | A93
40
2 | 8 | A174
2 | 8 | A174
94
57
66
6 | 4 | A106
57
75
27
45
81
65
66
39
3 | 7 | A137
37
77
96
24
82
91
37
93
55
48
90
9 | 1 | A51
70
43
37
41
82
27
68
43
18
36
15
74
4 | 6 | A25
15
68
54
53
56
38
17
40
40
50
29
99
40
83
36
35
90
9 | 1 | A51
15
76
51
73
0 | 10 | A11
92
60
28
29
31
83
2 | 8 | A174
7 | 3 | A3
72
53
83
78
61
65
40
68
36
53
95
28
22
1 | 9 | A93
91
23
76
96
93
22
86
98
64
3 | 7 | A137
61
63
35
86
34
58
25
23
1 | 9 | A93
11
83
89
8 | 2 | A67
15
52
22
96
61
65
23
10 | 0 | A58
85
25
10 | 0 | A58
94
70
52
26
81
4 | 6 | A25
60
1 | 9 | A93
8 | 2 | A67
58
100
54
80
80
20
0 | 10 | A11
59
39
48
65
80
14
40
72
40
41
1 | 9 | A93
61
57
18
32
62
61
6 | 4 | A106
87
51
27
17
97
65
58
59
56
24
47
39
47
15
58
100
32
54
92
51
97
88
61
40
7 | 3 | A3
34
87
38
64
49
0 | 10 | A11
61
2 | 8 | A174
47
42
11
93
18
13
1 | 9 | A93
46
13
54
18
12
69
85
82
72
91
90
51
54
66
73
1 | 9 | A93
4 | 6 | A25
33
59
59
26
56
80
55
88
65
26
8 | 2 | A67
72
91
40
53
27
96
12
66
63
69
61
84
12
10 | 0 | A58
69
56
65
34
49
91
60
40
60
83
72
15
59
9 | 1 | A51
56
65
39
2 | 8 | A174
71
43
31
74
99
15
45
34
71
20
93
80
4 | 6 | A25
57
40
11
20
17
37
32
94
100
43
36
27
69
96
63
28
0 | 10 | A11
74
14
49
56
41
19
48
79
81
43
30
26
50
53
52
84
19
98
8 | 2 | A67
74
66
71
31
23
93
47
100
53
22
96
0 | 10 | A11
93
55
74
41
6 | 4 | A106
95
19
84
11
1 | 9 | A93
69
81
41
1 | 9 | A93
16
64
91
37
50
45
72
30
45
23
52
51
63
36
95
7 | 3 | A3
93
37
62
22
39
34
24
7 | 3 | A3
57
28
64
48
87
71
32
55
70
8 | 2 | A67
44
59
91
95
37
86
44
8 | 2 | A67
38
9 | 1 | A51
4 | 6 | A25
64
89
69
52
83
86
36
85
50
84
65
71
100
Spreadsheet: 488984d1478957302-excel-help-vlook-up-index-small-formula-help-reporting-sheet-help-excel-help
Sheet: Item Details 2016

TYPE | ITEM | Supplier | Cost Each | Brand | Code
Glassware | Glass 1 | Suppler 1 | 0.99 | Brand 1 | AR41163
Glassware | [NAME] 2 | Suppler 2 | 0.89 | Brand 2 | AR41162
Glassware | Glass 3 | Suppler 3 |  | Brand 3 | AR41161
Glassware | [NAME] 4 | Suppler 4 | 1.01 | Brand 4 | 01.136.8394
Glassware | Glass 5 | Suppler 5 | 1.39 | Brand 5 | 01.002.9007
Glassware | [NAME] 6 | Suppler 6 | 1.52 | Brand 6 | 01.002.9006
Glassware | Glass 7 | Suppler 7 | 1.003 | Brand 7 | 01.002.9012
Glassware | [NAME] 8 | Suppler 8 | 0.8875 | Brand 8 | 01.002.9011
Glassware | [NAME] 9 | Suppler 9 | 1.45 | Brand 9 | GSCC0100
Silver | Knife 1 | Suppler 10 | 2.685 | Brand 10 | 07.002.0307
Silver | Knife 2 | Suppler 11 | 3.03 | Brand 11 | 07.002.0303
Silver | Knife 3 | Suppler 12 | 2.25 | Brand 12 | 07.002.0305
Silver | Knife 4 | Suppler 13 | 2.85 | Brand 13 | 07.002.0301
Silver | Knife 5 | Suppler 14 | 2.5875 | Brand 14
Silver | Knife 6 | Suppler 15 | 2.5875 | Brand 15
Silver | Knife 7 | Suppler 16 | 4.725 | Brand 16 | SIENA STKH
Silver | Knife 8 | Suppler 17 | 2.25 | Brand 17 | 07.002.0309
Silver | Knife 9 | Suppler 18 | 2.25 | Brand 18 | 07.002.0306
Silver | Knife 10 | Suppler 19 | 0.4 | Brand 19
Crockery | Cup 1 | Suppler 20 | 14.41 | Brand 20
Crockery | Cup 2 | Suppler 21 | 1.792 | Brand 21
Crockery | Cup 3 | Suppler 22 | 1.2 | Brand 22
Crockery | Cup 4 | Suppler 23 | 1.216 | Brand 23
Crockery | Cup 5 | Suppler 24 | 1.04 | Brand 24
Crockery | Cup 6 | Suppler 25 | 3.432 | Brand 25
Crockery | Cup 7 | Suppler 26 | 2.736 | Brand 26
Crockery | Cup 8 | Suppler 27 | 1.632 | Brand 27
Crockery | Cup 9 | Suppler 28 | 2.488 | Brand 28
[NAME]. | Misc 1 | Suppler 29 | 252.8 | Brand 29 | 28.023.0904
[NAME]. | [NAME] | Suppler 30 | 4.875 | Brand 30 | 09.376.2521
[NAME]. | Misc 3 | Suppler 31 | 13.5 | Brand 31
[NAME]. | [NAME] | Suppler 32 | 24.4575 | Brand 32
[NAME]. | Misc 5 | Suppler 33 | 44.25 | Brand 33 | 18.376.3922
[NAME]. | Misc 6 | Suppler 34 | 8.24 | Brand 34 | 09.036.0187
[NAME]. | Misc 7 | Suppler 35 | 8.24 | Brand 35 | 09.036.0186
[NAME]. | Misc 8 | Suppler 36 | 6.11 | Brand 36 | 09.036.0129
[NAME]. | Misc 9 | Suppler 37 | 6.11 | Brand 37 | 09.036.0128
[NAME]. | Misc 19 | Suppler 38 | 3.33 | Brand 38 | 09.288.1152
[NAME]. | Misc 101 | Suppler 39 | 55.37 | Brand 39 | BO_BBORL
Spreadsheet: 77718d1278150883-collate-and-index-info-example2-adeassessor2
Sheet: Unit 1

Entry | Unit 1 Criteria 1 | Unit 1 Criteria 2 | Unit 1 Criteria 3 | Unit 1 Criteria 4 | Unit 1 Criteria 5
Spreadsheet: 854707d1704476407-simplifying-complex-formula-test-gk3-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1,2 | 4,9,19,25 | 4,10,14,22 | 4,13,19,23 | 4,17,19,24 | 1,14,23,24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 8 | 25 | 0 | 15 | 35
y/n | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z |  |  |  |  |  |  |  |  | windknife | windknife [NAME] | Original Formula
y | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  | 9 | 4 | 0 | 14 | 0
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0
y | 10 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2 |  |  |  |  |  |  |  |  |  | 0
n | 12 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 0
y | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 1
y | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 1
y | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 0
n | 18 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  |  |  |  |  |  | 0
n | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2 |  |  |  |  |  |  |  |  |  | 0
y | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2 |  |  |  |  |  |  |  |  |  | 1
y | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22 |  |  |  |  |  |  |  |  |  | 1
y | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2 |  |  |  |  |  |  |  |  |  | 0
y | 20 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22 |  |  |  |  |  |  |  |  |  | 0
y | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22 |  |  |  |  |  |  |  |  |  | 0
n | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2 |  |  |  |  |  |  |  |  |  | 1
y | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0
y | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1
y | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1
y | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: gstorey__12106__April01
Sheet: Table 3a

Natural gas Exports by Export Point |  |  |  |  |  |  |  |  |  |  |  |  | Table 3a
Exportations de gaz naturel par point d'exportation
1000 m3
 | 2000/11 | 2000/12 | 2001/01 | 2001/02 | 2001/03 | 2001/04 | 2001/05 | 2001/06 | 2001/07 | 2001/08 | 2001/09 | 2001/10 | TOTAL
ADEN | 28034.1 | 26800.7 | 27783.4 | 24365.5 | 27093.1 | 27166.9 | 0 | 0 | 0 | 0 | 0 | 0 | 161243.7
CHIPPAWA | 92209.4 | 100368.97 | 96303.21 | 90476.09 | 99063.24 | 70342.6 | 0 | 0 | 0 | 0 | 0 | 0 | 548763.51
CORNWALL | 22700.08 | 30250 | 34185.67 | 38598 | 37572.6 | 19055.36 | 0 | 0 | 0 | 0 | 0 | 0 | 182361.71
EAST HEREFORD | 103344.6 | 102348.8 | 85899.5 | 72389.4 | 80705.6 | 88590.3 | 0 | 0 | 0 | 0 | 0 | 0 | 533278.2
ELMORE | 522825.5 | 1049034.4 | 1072637.6 | 1070524.8 | 1202940.1 | 1206585.3 | 0 | 0 | 0 | 0 | 0 | 0 | 6124547.7
EMERSON | 1070188.3 | 1104638.1 | 1221201.6 | 883327.6 | 832128.2 | 622751.3 | 0 | 0 | 0 | 0 | 0 | 0 | 5734235.1
HIGHWATER | 105914.8 | 112537.9 | 137785 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 356237.7
HUNTINGDON | 808702.99 | 923478.12 | 819747.84 | 781411.45 | 906367.1 | 693313.7 | 0 | 0 | 0 | 0 | 0 | 0 | 4933021.2
IROQUOIS | 997646.8 | 833892.2 | 975074.19 | 796371.9 | 776310.3773400001 | 665686.37 | 0 | 0 | 0 | 0 | 0 | 0 | 5044981.83734
KINGSGATE | 1998761.92 | 2131604.59 | 2121432.66 | 1939859.47 | 2099448.91 | 1775679.68 | 0 | 0 | 0 | 0 | 0 | 0 | 12066787.23
MONCHY | 1793119.86 | 1895983.68 | 1898460.31 | 1683550.89 | 1831320.018 | 1857225.668 | 0 | 0 | 0 | 0 | 0 | 0 | 10959660.426
NAPIERVILLE | 47938.2 | 50804 | 49475.5 | 83446.8 | 87656.2 | 84057.2 | 0 | 0 | 0 | 0 | 0 | 0 | 403377.9
[NAME] | 1313385.308633 | 1413173.45 | 1491897.96 | 973826.91 | 743948.97 | 647955.8040000001 | 0 | 0 | 0 | 0 | 0 | 0 | 6584188.402633
NORTH PORTAL | 839.99 | 868.01 | 868.01 | 784.01 | 1078.4 | 847.4 | 0 | 0 | 0 | 0 | 0 | 0 | 5285.82
PHILIPSBURG | 20992.5 | 18373.2 | 19104.9 | 17694.4 | 20100.1 | 16699.2 | 0 | 0 | 0 | 0 | 0 | 0 | 112964.3
[NAME] FIELD | 305.4 | 296.2 | 282.3 | 274.2 | 148.1 | 292.9 | 0 | 0 | 0 | 0 | 0 | 0 | 1599.1
SPRAGUE | 15643.1 | 20352.5 | 15884.5 | 16379.3 | 4989.1 | 1496.8 | 0 | 0 | 0 | 0 | 0 | 0 | 74745.3
ST CLAIR | 22976.9 | 46204.9 | 41520.1 | 23094.6 | 33786.7 | 19224.3 | 0 | 0 | 0 | 0 | 0 | 0 | 186807.5
ST STEPHEN | 330884.9 | 311449.9 | 290321.5 | 348337.6 | 361447 | 313346.58 | 0 | 0 | 0 | 0 | 0 | 0 | 1955787.48
 | 9296414.648633001 | 10172459.62 | 10399865.75 | 8844712.919999998 | 9146103.81534 | 8110317.362000001 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 754803d1636512270-separate-a-mixed-column-formula-upload-2021-f
Sheet: Sheet1

 |  |  | Japan | Germany | USA | Italy |  |  | Japan | Germany | USA | Italy
Germany | BMW |  |  |  |  |  |  |  | Toyota | Porsche | Ford | Pagani
Germany | Porsche |  |  |  |  |  |  |  | Honda | Mercedes-Benz | Chevrolet | Mazzanti
USA | Jeep |  |  |  |  |  |  |  | Subaru | BMW | Jeep | Ferrari
Japan | Nissan |  |  |  |  |  |  |  | Nissan | Audi | GMC | Lamborghini
Italy | Ferrari |  |  |  |  |  |  |  | Mazda | Volkswagen | Buick | Maserati
Italy | Pagani
USA | Ford
USA | Buick
Japan | Honda
USA | Chevrolet
Italy | Mazzanti
Japan | Toyota
Japan | Mazda
Germany | Mercedes-Benz
Germany | Audi
USA | GMC
Japan | Subaru
Germany | Volkswagen
Italy | Lamborghini
Italy | Maserati
Spreadsheet: 795773d1662920141-text-join-with-condition-book1-1-
Sheet: Sheet1

 | Result
81-2111-2205-2033B
81-2111-2205-2033C | 82-2112-2204-R2318AZ
81-2111-2205-2033DZ | 82-2111-2204-2293X, AZ
82-2112-2204-R2318 | 81-2111-2204-2069A, B
82-2112-2204-R2318AZ | 81-2111-2204-2068A, B
82-2111-2204-2293X | 81-2111-2204-2144A, B, C, DZ, EZ, FZ
82-2111-2204-2293
82-2111-2204-2293AZ
81-2111-2204-2069
81-2111-2204-2069A
81-2111-2204-2069B
81-2111-2204-2068
81-2111-2204-2068A
81-2111-2204-2068B
81-2111-2204-2144
81-2111-2204-2144A
81-2111-2204-2144B
81-2111-2204-2144C
81-2111-2204-2144DZ
81-2111-2204-2144EZ
81-2111-2204-2144FZ
Spreadsheet: 178577d1346847474-add-totals-in-a-table-with-multipul-values-order-example
Sheet: Sheet1

 |  | Year |  |  |  |  |  | TOTAL | Figure that should be shown (Long Hand EQ)
Name | T/ N | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | AMOUNT
Price Per Item | N | 8.6 | 6 | 9 | 6.4 | 5.9 | 5.85
BI | N | 6 | X | 6 | X | X | X | ? | 105.6
AP | N | X | 4 | X | 2 | X | 12 | ? | 107
Spreadsheet: 218783d1362579933-search-in-each-column-in-sheet1-and-return-value-from-column-a-sheet1-to-sheet2-sample1
Sheet: Blad1

2013-03-04 00:00:00 | 4/3- | 11/3- | 18/3- | 25/3-
Week | 10 | 11 | 12 | 13
Text A | SKM | SKM | SKM | SKM
Text 1 | EA | EA | EA,PAS
Text 2 |  | SAN,LO |  | PAS
Text 3 | SAN |  | SAN
Text 4 | MM | [NAME] | AB
Text 5 | [NAME] | MM | MLA21-22 | [NAME]
Text 6 | AB,LO | CF |  | AB,EA
Text 7 | CF7 e m |  | CF
Text 8 | WA | AB,HBA | WA
Text 9 | HBA | MP13-15 | MP18-20
Text 10 |  |  |  | HBA
Text 11 | EGU | RAS | RAS | JOS
Text 12 | AMY7-8 | JOS | AMY | SAN
Spreadsheet: 723840d1615913705-formula-for-if-its-x-date-cell-y-example
Sheet: Sheet1

Employee [NAME]
Year: | 2021
V = Vacation,  S = Sick, P = Personal, D = Disability, O = Other Paid, U = Unpaid
Employee |  |  | Year Totals
ID | Name | [NAME] | Taken | Balance
1 | [NAME] (10) | 9
2 | [NAME] (15)
3 | Cole L - 12/26 (5) | 5
Spreadsheet: acefe1de-177e-4840-8efe-d3485422e71b
Sheet: Sheet1

Name | Add1 | CSZ | phone | fax | e-mail | [NAME]
Advanced Prep-Coat, Inc | 41C [NAME] | Worcester, MA 01603 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Capital Carpet & Flooring Specialists Inc. | 12 Walnut Hill Park | Woburn, MA 01801 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Caprioli Painting Inc. | 20 Beech Street | Newmarket, NH 03857 | [PHONE] |  | [EMAIL] | [NAME]
CBC Liberty Enterprises, LLC | PO Box 588 | [NAME], Ma 02052 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Contracting Specialists Inc. | 453 South Main St. | Attleboro, MA 02703 | [PHONE] | [PHONE] | [EMAIL] | Sophie Arenburg
Control Hardwood Floor Inc. | PO Box 6344 | [NAME], RI 02863 | [PHONE] | [PHONE] | [EMAIL] | Claudia
East Coast Developments, Inc. | 126 Main St. #2 | North Reading, MA 01864 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Federal Floor Inc. | 39 Jeremy Hill Road | Pelham, NH 03076 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Projectdog | 18 Graf Road, Ste 8 | Newburyport, MA 01950 | [PHONE] | [PHONE] | [EMAIL]
Wells Restoration, LLC |  |  | [PHONE] |  | [EMAIL] | [NAME]
Spreadsheet: 09829d16-e6fc-49f5-8351-48745304e5c9
Sheet: Sheet1

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
138.28
167.4
171
242.4
299
388
403.2
480
480
489.23
502
575.56
590.72
600
763.38
773.56
805
807.23
881.76
900
924.02
970
972
1368.02
1691.4