tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815048d1674721328-range-criteria-problem-in-the-function-countifs-sample-with-filter
Sheet: see_this_page

 | Who | Tümü
 | January |  |  | April |  |  |  |  |  |  |  | December
2022 | OCAK | ŞUBAT | MART | NİSAN | MAYIS | HAZİRAN | [NAME] | AĞUSTOS | EYLÜL | EKİM | KASIM | ARALIK | TOTAL |  | https://www.excelforum.com/excel-formulas-and-functions/1398420-range-criteria-problem-in-the-function-countifs.html
 |  | 122 | 0 | 73 | 78 | 158 | 205 | 0 | 0 | 0 | 0 | 167
Araba | 6075 | 550 | 550 | 5473 | 6650 | 1825 | 1835 | 1150 | 760 | 1150 | 1150 | 1350 | 28518
Cep Telefonu Faturası | 102.15 | 104.75 | 104.75 | 104.75 | 106 | 142 | 64 | 50.3 | 140.7 | 160.7 | 160.8 | 160.7 | 1401.6
Diğer | 2950 | 65 | 575 | 445 | 737 | 115 | 60 | 211 | 285 | 292 | 518.25 | 1001 | 7254.25
Doğalgaz Faturası | 150 | 520 | 135 | 240 | 75 | 40 | 35 | 40 | 40 | 75 | 80 | 490 | 1920
[NAME] | 318 | 247 | 179.5 | 162 | 156 | 199.46 | 136 | 372.3 | 310 | 222 | 207 | 223 | 2732.26
Emir | 0 | 1297 | 645 | 1530 | 660 | 70 | 670 | 230 | 4952 | 1010 | 2052 | 320 | 13436
[NAME] | 0 | 0 | 15 | 0 | 521 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 536
İnternet Faturası | 80 | 80 | 80 | 80 | 80 | 124 | 101 | 101 | 101 | 101 | 101 | 101 | 1130
[NAME] | 265 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 220 | 485
[NAME] | 50 | 367 | 367 | 0 | 170 | 557 | 517 | 85 | 225 | 671 | 1155 | 410 | 4574
Okul -Yemek | 20 | 60 | 99 | 139.5 | 45 | 68 | 0 | 0 | 116 | 40 | 74 | 313 | 974.5
Savrandere | 100 | 116 | 1484 | 160 | 85 | 135 | 50 | 0 | 0 | 0 | 100 | 550 | 2780
Su Faturası | 0 | 62.38 | 52.55 | 108.73 | 77.69 | 148 | 86.55999999999999 | 173.46 | 85.83999999999999 | 83.23 | 157.93 | 133.78 | 1170.15
Yazlık | 0 | 0 | 0 | 690 | 1146 | 464 | 0 | 750 | 750 | 750 | 750 | 0 | 5300
Spreadsheet: 792493d1660922621-need-help-to-find-matches-between-two-tables-match-peers
Sheet: old peers

UNITID | Agency
217518 | A
233374 | A
186371 | A
229267 | A
236328 | A
186201 | A
123572 | A
216010 | A
234207 | A
195526 | A
137847 | A
211644 | A
209825 | A
196237 | A
129215 | A
139144 | A
163851 | A
136950 | A
214157 | A
152600 | A
236230 | A
196167 | A
178615 | A
210571 | A
140960 | A
138983 | B
213783 | B
211644 | B
130776 | B
168430 | B
217420 | B
185572 | B
162007 | B
198543 | B
126580 | B
171456 | B
199157 | B
173045 | B
201548 | B
130934 | B
162283 | B
227526 | B
222831 | B
196121 | B
160621 | B
128106 | B
139366 | B
159009 | B
138716 | B
207041 | B
189097 | C
216287 | C
213385 | C
164155 | C
167835 | C
196866 | C
211291 | C
112260 | C
173902 | C
130590 | C
166939 | C
195216 | C
128902 | C
168281 | C
128328 | C
191630 | C
169080 | C
141060 | C
233295 | C
232256 | C
206589 | C
164216 | C
163912 | C
230995 | C
236896 | C
217518 | D
216010 | D
235316 | D
211158 | D
228149 | D
236595 | D
198516 | D
209825 | D
185572 | D
184782 | D
236577 | D
228802 | D
130934 | D
222178 | D
152600 | D
159416 | D
236230 | D
200004 | D
218964 | D
196121 | D
155681 | D
221768 | D
218733 | D
128106 | D
106467 | D
110705 | E
110653 | E
182670 | E
131496 | E
164924 | E
179867 | E
217156 | E
152080 | E
221999 | E
164988 | E
139658 | E
165015 | E
130943 | E
199120 | E
168148 | E
129020 | E
186380 | E
197708 | E
196413 | E
199847 | E
139959 | E
183044 | E
217882 | E
239105 | E
196079 | E
Spreadsheet: joe_parks__14767__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-04-02 00:00:00
From the Waha Area | 75000
East of Waha to | 100000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25000
 | * Carthage Plant OK for 10,000
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: BUG_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
REGION: BUG
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 12853457 | 36518397
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 28397164 | 76589544
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 16 | 10435321
 | Total Sales: |  | 41250637 | 123543262
 | Purchases:
6 |  | 3rd Party / Inter Enron | -6931794 | -19336794
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -33209597 | -88728638
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 547431 | 1279975
 | Total Purchases: |  | -39593960 | -106785457
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 2784 | 15796
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -29369 | -29
 | Total Imbalances: |  | -26585 | 15767
 | Storage:
17 |  | Injection (Sales to Stg) | 989473 | 3349168
18 |  | W/D (Purchase from Stg) | -2889962 | -6064413
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -2889962 | -6064413
 | Total Storage: |  | -1900489 | -2715245
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 270413 | 834224.105
23 | Fuel: |  | -547431 | -1279975
 | Transport Expense:
24 |  | Commodity | 0 | -736929
25 |  | Demand | 0 | -10256821
 | Total Transport Expense: |  | 0 | -10993750
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 6830063.135800794
31 |  | Prior Month Book Balance | 0 | -8066079
 |  | Total MTM Income | 0 | -1236015.864199206
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -1488894.936719254
34 |  | Originations | 0 | 2928
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 179915
 |  | TOTAL INTRA-MTH
Spreadsheet: 583944d1532782173-conditional-formatting-based-on-time-copy-of-testttable-yoepy-
Sheet: Sheet1

 | Minutes per Competitor | 6 | Intervals | 15
 | Change over time | 5
Event No. | Event Name | Competitors | Gender | Time Required (MM) |  | Start | Finish | Venue 1 | Venue 2 | Venue 3 | Venue 4 | Venue 5 | Venue 1
1 | Event 1 | 5 | Male |  |  | 08:00:00
2 | Event 2 | 4 | Female |  |  |  |  | Event 1
3 | Event 3 | 3 | Female
4 | Event 4 | 8 | Male
5 | Event 5 | 9 | Female |  |  |  |  | Event 2
6 | Event 6 | 4 | Male
7 | Event 7 | 5 | Female
8 | Event 8 | 6 | Female |  |  |  |  | Event 4
9 | Event 9 | 2 | Male
10 | Event 10 | 7 | Female
11 | Event 11 | 8 | Male
12 | Event 12 | 9 | Female
13 | Event 13 | 2 | Female |  |  |  |  | Event 3
14 | Event 14 | 3 | Male
15 | Event 15 | 5 | Female
16 | Event 16 | 5 | Male |  |  |  |  | Event 5
17 | Event 17 | 5 | Female
18 | Event 18 | 6 | Female
19 | Event 19 | 7 | Male
20 | Event 20 | 5 | Female
21 | Event 21 | 4 | Male |  |  |  |  | End
22 | Event 22 | 6 | Female
23 | Event 23 | 7 | Female
24 | Event 24 | 8 | Male
25 | Event 25 | 5 | Female
26 | Event 26 | 4 | Male
27 | Event 27 | 3 | Female
28 | Event 28 | 15 | Female
29 | Event 29 | 12 | Male
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
Spreadsheet: 539269d1506020698-formula-help-summing-a-crosstable-with-multiple-criteria-sumproduct-formula-example
Sheet: Sheet1

 | Data Set |  |  |  |  |  | Summary
 |  | Month 1 | Month 1 | Month 2 | Month 2 |  |  | Month 1 | Month 1 | Month 2 | Month 2
 |  | Revenue | Units | Revenue | Units |  |  | Revenue | Units | Revenue | Units
 | Customer 1 |  | 34 | 62297 | 95 |  | Customer 1
 | Customer 1 |  | 26 | 52024 | 40 |  | Customer 2
 | Customer 2 |  | 14 | 34405 | 70
 | Customer 2 |  | 66 | 38577 | 24
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: UK

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 41339d1239811751-identify-list-and-sum-2-columns-test-time-sheet
Sheet: NOV 10-15 08

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2008-11-10 00:00:00 | 05:00:00 | 07:00:00 | 2 | 28102 |  | CNC GAUGE
 | 07:00:00 | 09:00:00 | 2 | 28103 |  | CNC GAUGE
 | 09:00:00 | 03:00:00 | 5.5 | SHOP
 | 03:00:00 | 05:00:00 | 2 | 28094 | 11.5 | CNC CASTING
2008-11-11 00:00:00 | 05:00:00 | 10:00:00 | 5 | SHOP
 | 10:00:00 | 11:00:00 | 1 | 28029B |  | CNC CASTINGS
 | 11:00:00 | 03:00:00 | 3.5 | SHOP
 | 03:00:00 | 04:00:00 | 1 | 28102 | 10.5 | CNC GAUGE
2008-11-12 00:00:00 | 05:00:00 | 07:00:00 | 2 | 28103 |  | CNC GAUGE
 | 07:00:00 | 12:00:00 | 5 | SHOP
 | 12:30:00 | 04:00:00 | 3.5 | 28029B | 10.5 | CNC CASTINGS
2008-11-13 00:00:00 | 05:00:00 | 12:00:00 | 7 | 28029B |  | CNC CASTINGS
 | 12:30:00 | 04:00:00 | 3.5 | SHOP | 10.5
2008-11-14 00:00:00 | 04:00:00 | 08:00:00 | 4 | 28103 |  | CNC GAUGE |  | VACATION 72.5 HRS
 | 08:00:00 | 12:00:00 | 4 | SHOP
 | 12:30:00 | 03:00:00 | 2.5 | 28029B | 10.5
 |  | SHOP | 26.5
 |  | 28029B | 14
 |  | 28094 | 2
 |  | 28102 | 3
 |  | 28103 | 8
 |  |  | 53.5 | TOTAL | 53.5
Spreadsheet: kevin_hyatt__19649__San Juan supply 2-19
Sheet: Pipeline

Pipeline: | Capacity | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
EPNG |  | 2664 | 2623 | 2608 | 2231 | 2067 | 1976 | 1901 | 1807 | 1729 | 1676 | 1603
Transwestern |  | 820 | 840 | 840 | 770 | 680 | 680 | 680 | 680 | 680 | 680 | 680
[NAME] |  | 0 | 0 | 18 | 70 | 80 | 80 | 80 | 80 | 80 | 80 | 80
Other |  | 0 | 0 | 0 | 400 | 600 | 600 | 600 | 600 | 600 | 600 | 600
Total San Juan Take-away
Capacity Utilization
Spreadsheet: 50956d1250543345-vlookup-putting-all-names-in-order-slash-summer-series-points
Sheet: Standings

Expert Standings | Points | Name
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Novice Standings | Points | Name
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Junior Standings | Points | Name
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 3ca65102-0631-48d0-aa9b-42264e584956
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Fervent Records | [PHONE] | [NAME] August | No Far Away | 2010-08-24 | Compact Disc | Ac | 13.99 | Y | To Be Retired
Word Records | [PHONE] | [NAME] | Anatomy Of Broken, The | 2010-09-14 | Compact Disc | Ac | 13.99 | N | To Be Retired
Taseis | [PHONE] | Chris Jones & Word Of Praise | Dance | 2006-02-28 | Compact Disc | Black Gospel | 13.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] | Only You Can Save | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] | One | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] August | [NAME] | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | [PHONE] | [NAME] August | 7X70 | 2010-11-23 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Taseis | [PHONE] | Chris & Kyle With True Spirit | Heal Me | 2010-09-21 | Compact Disc | Gospel | 8.99 | Y | Available
Fervent Records | 080688806521AG | [NAME] August | No Far Away (Autographed) | 2010-08-24 | Compact Disc | Ac | 11.99 | Y | Available
Word Records | 080688808327AG | [NAME] | Anatomy Of Broken, The (Autographed) | 2010-09-14 | Compact Disc | Ac | 13.99 | N | To Be Retired
Print Music, Word Owned * | [PHONE] | [NAME] | Living Room Sessions: Hymns | 2001-06-05 | Piano Folio | Na | 16.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | Run The Earth, Watch The Sky | 2003-03-22 | Vocal Folio | Na | 14.95 | N | To Be Retired
Print Music, Word Owned * | [PHONE] | [NAME] | What A Heart Is Beating For | 2007-10-09 | Vocal Folio | Na | 22.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | Amusing | 2005-09-23 | Vocal Folio | Na | 14.95 | N | To Be Retired
Print Music, Word Owned * | [PHONE] | [NAME] | Short Term Memories | 2004-10-22 | Vocal Folio | Na | 24.95 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] | [NAME] | 1998-11-18 | Vocal Folio | Na | 16.95 | Y | Available
Fervent Records | [PHONE] | [NAME] August | No Far Away (Deluxe Edition) | 2011-12-20 | Compact Disc | Ac | 15.99 | Y | Available
Fervent Records | [PHONE] | [NAME] August | The Upside Of Down | 2012-08-21 | Compact Disc | Ac | 13.99 | Y | Available
Word Records | [PHONE] | [NAME] August | Restore | 2013-05-07 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Print Music, Word Owned * | [PHONE] | [NAME] August | Songs From [NAME] August The Upside Of Down | 2012-11-13 | Vocal Folio | Na | 19.95 | Y | Available
Metro One | [PHONE] | [NAME] | Power In Weakness | 2012-08-14 | Compact Disc | Rock | 13.99 | N | To Be Retired
Fervent Records | [PHONE] | [NAME] August | Unashamed Of You | 2013-12-03 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | [PHONE] | Group 1 Crew Ft. [NAME] August | He Said | 2012-07-24 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Fervent Records | [PHONE] | [NAME] August | Christmas Ep, The | 2014-10-28 | Compact Disc | Ac | 4.99 | N | NYP
Spreadsheet: 195662d1353594238-vlookup-help-needed-please-xc-results
Sheet: JB Results

Position | Number | Forname | Surname | County | Age Group
1
 |  |  |  |  |  |  | Over All Results
 |  |  |  |  |  |  | County | Score
 |  |  |  |  |  |  | Cleveland
 |  |  |  |  |  |  | Cumbria
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Northumberland
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 823676d1680086599-group-4-data-sets-into-one-boooook-4-
Sheet: Sheet2

ID | Surname | First Name | CODE | Value 1 | ID | Surname | First Name | CODE | Value 2 | ID | Surname | First Name | CODE | Value 3 | ID | Surname | First Name | CODE | Value 4 |  |  | Surname | First Name | CODE |  | Value 2 | Value 3 | Value 4
111 | aaa | aaa | xxx | 70 | 111 | aaa | aaa | xxx | 1 | 555 | eee | eee | xxx | 5 | 555 | eee | eee | yyy | 5 |  | 111 | aaa | aaa | xxx | 70 | 1 | 0 | 70
222 | bbb | bbb | ooo | 48 | 222 | bbb | bbb | xxx | 2 |  |  |  |  |  | 111 | aaa | aaa | xxx | 70 |  | 222 | bbb | bbb | ooo | 48 | 0 | 0 | 0
333 | [NAME] | [NAME] | yyy | 59 | 333 | [NAME] | [NAME] | yyy | 3 |  |  |  |  |  |  |  |  |  |  |  | 222 | bbb | bbb | xxx | 0 | 2 | 0 | 0
444 | ddd | eee | ggg | 84 | 444 | ddd | ddd | yyy | 4 |  |  |  |  |  |  |  |  |  |  |  | 333 | [NAME] | [NAME] | yyy | 59 | 3 | 0 | 0
555 | eee | eee | hhh | 86 | 555 | eee | eee | abc | 5 |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | eee | ggg | 84 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 444 | ddd | ddd | yyy | 0 | 4 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | hhh | 86 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | abc | 0 | 5 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | xxx | 0 | 0 | 5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 555 | eee | eee | yyy | 0 | 0 | 0 | 5
Spreadsheet: 140282d1328681491-filling-individual-answers-in-their-groups-fillingindanswerstogroup
Sheet: Sheet1

Group | Answer
1
1
1 | yes
2
2 | no
2
3
3
3 | yes
3
4
4
5
5 | yes
5
5
5
6
6
7
7
7
7
8
8 | no
Spreadsheet: 07a8b5a7-ac9e-4191-8b22-d5db489e3414
Sheet: Clean Tech & Corporate VC

Total Venture Capital and Corporate Venture Capital in Clean Tech Deals - Most Recent 6 Quarters
01/01/2011- 06/30/2012
Chart #1
MoneyTree Sector | Total # Deals | % of Total Deals | % of Clean Tech deals | $M Invested | % of Total Investment | % of Clean Tech $
All sectors - US Venture Capital
Clean Technology Deals Only | 875 |  |  | 7053.45
Corporate VC Investment Deals  in Clean Technology companies | 120 |  |  | 767.55
Chart #2
 | # Deals |  |  | $M Invested
Total Corporate VC Investment
% of Total CVC Investment Going to Clean Tech
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: 3828f2da-1ce3-4f7c-a1ae-025720e55cda
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | [NAME] | Mellet | Philadelphia | United States
2 | Cecilia | Weber | Boise | United States
3 | Monika | Wille | [NAME] | Germany
 | 3 | 3 | 3 | 3
Spreadsheet: 679305d1590325888-help-needed-with-vlookup-it-never-works-and-only-returns-n-a-vlookup-example-for-ef
Sheet: Sheet1

CA | DATATAG | PKCustomerRecord | SAP_BPID
[PHONE] | xUNISMAB20200511 | 857949 | [PHONE]
[PHONE] | xUNISMAB20200511 | 857952 | [PHONE]
[PHONE] | xUNISMAB20200511 | 857950 | [PHONE]
[PHONE] | xUNISMAB20200511 | 857953 | [PHONE]
[PHONE] | xUNISMAB20200511 | 857951 | [PHONE]
Spreadsheet: 44313d1242920187-vlookup-to-return-multiple-values-test
Sheet: RESULTS

Analyst | Stock | Market [NAME] | RIC | Date | Event | Event 2 | Event 3 | Status |  | KEY
 |  |  |  |  | VLOOKUP
 |  |  | AGA.L | 2009-05-08 00:00:00 | AGM | #N/A |  |  |  |  | Initiating
 |  |  | AGA.L | 2009-05-09 00:00:00 | AGM | #N/A
 |  |  |  |  | INDEX
 |  |  | INF.L | 2009-05-08 00:00:00 | #N/A | #N/A |  |  |  |  | Small cap
 |  |  | INF.L | 2009-05-09 00:00:00 | #N/A | #N/A |  |  |  |  | Mid Cap
 |  |  | INF.L | 2009-05-10 00:00:00 | #N/A | #N/A |  |  |  |  | Large Cap
Spreadsheet: 721414d1614697396-sum-a-row-of-cell-and-use-mod-to-bring-to-a-single-number-kua-number
Sheet: Sheet1

 |  |  |  |  | date of [NAME] |  |  |  |  | Kua
 |  |  |  | M | 1 | 9 | 4 | 3 |  |  |  |  |  |  |  | 1+9+4+3-=17 (8) |  | 11-8= 3 (3) |  | male
 |  |  |  | F |  |  |  |  |  | 3 |  |  |  |  |  | 1+9+4+3-=17 (8) |  | 4+8=12 (3) |  | female
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the formula in K5 must be able to accommodate when  selection is "M" or "F"
 |  |  |  |  | need with a little to ad ooin the formula to cater if the selection is female
 |  |  |  |  | in the formula when we select  E5 to be "M" the formula gives the correct answer
 |  |  |  |  | we need to maybe amend the formula to accommodate if the selection  E5  = "F" , here the mod value of f5:i5 , we need to add 4
 |  |  |  |  | in the E5 when we entered "M" we subtracted the mod value of F5:I5
Spreadsheet: 725098d1616528306-text-string-formula-wpwalsh-textstring
Sheet: Final

First | Last | Street | City | _City | _State | _[NAME]
COLON | ABRAHAM | PO BOX 1048 | HARTSVILLE , SC 29551
 |  |  | HARTSVILLE , SC 29551
 |  |  | THIS IS WHAT I'M AFTER >>>>>>>>>> | Hartsville | SC | 29551
 |  | Other test cases: | NEW ROCHELLE NY 10801
 |  |  | FAIRFIELD, CT 06824
Spreadsheet: 835898d1688967963-how-to-transform-easily-text
Sheet: Sheet1

Sample Data |  |  |  |  | How to sort this way
User Name | Date | Time |  |  | User Name | 2023-07-01 00:00:00 | 2023-07-02 00:00:00 | 2023-07-03 00:00:00 | 2023-07-04 00:00:00 | 2023-07-05 00:00:00
HH | 2023-07-01 00:00:00 | 09:39:25 |  |  | HH | 09:39:25 | 09:38:40 | 09:36:51 | 09:28:26
ES | 2023-07-01 00:00:00 | 09:39:48 |  |  | ES | 09:39:48 |  | 09:42:23 | 09:29:03 | 09:46:01
HH | 2023-07-02 00:00:00 | 09:38:40 |  |  | SY |  | 10:15:45 | 10:04:41 | 09:32:35 | 09:41:01
SY | 2023-07-02 00:00:00 | 10:15:45 |  |  | TM |  |  |  | 11:42:33 | 09:33:41
HH | 2023-07-03 00:00:00 | 09:36:51 |  |  | AHH |  |  |  | 11:49:31 | 10:15:54
SY | 2023-07-03 00:00:00 | 10:04:41
ES | 2023-07-03 00:00:00 | 09:42:23
TM | 2023-07-04 00:00:00 | 11:42:33
HH | 2023-07-04 00:00:00 | 09:28:26
SY | 2023-07-04 00:00:00 | 09:32:35
AHH | 2023-07-04 00:00:00 | 11:49:31
ES | 2023-07-04 00:00:00 | 09:29:03
TM | 2023-07-04 00:00:00 | 09:36:45
AHH | 2023-07-05 00:00:00 | 10:15:54
SY | 2023-07-05 00:00:00 | 09:41:01
ES | 2023-07-05 00:00:00 | 09:46:01
TM | 2023-07-05 00:00:00 | 09:33:41