tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 25

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-25 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1773 |  | 1730 |  | 67694 |  |  |  |  |  | 18 | 1 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 2 | 22
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 6416 |  | 5773 |  | 67694 |  |  |  |  |  | 19 | 3 | 22
 |  |  |  |  |  |  |  |  | 6999 |  | 6999 |  | 68918 | 0 |  |  |  |  | 18 | 4 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 5 | 23
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 3029 |  | 2775 |  | 67694 |  |  |  |  |  | 20 | 6 | 24
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 19 | 7 | 21
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 20 | 8 | 22
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 | 0 |  |  |  |  | 19 | 9 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 15 | 23
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 19407 |  | 17461 |  | 67694 |  |  |  |  |  | 19 | 35 | 19
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 18 | 39 | 20
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2630 |  | 2332 |  | 67694 |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1811 |  | 1657 |  | 67694 |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 18148 |  | 16292 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 4702 |  | 4275 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 5116 |  | 4887 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 6240 |  | 6097 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 2334 |  | 2334 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 48 |  | 46 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 129084d1321441887-excel-2007-identify-duplicate-forum-1-
Sheet: Arkusz1

1
1
2
3
4,5
4
6
6
5
4,6
7
7
8
fgd
dfg
fdg
dfg
dfg
Spreadsheet: 77123d1277594719-calculating-commissions-commission_sample-1-
Sheet: JOE GOLDMAN

 | MONTH: |  |  | 2010-06-01 00:00:00
 | ACCOUNT EXECUTIVE: |  |  | ACCOUNT EXECUTIVE
 |  |  |  |  |  |  |  | GOAL ISSUE #1 |  | 2586.19 | 2000
 | 2009 ISSUE #1 SALES: |  |  | 2417 |  |  |  | GOAL ISSUE #2 |  | 2140 | 2000
 | 2009 ISSUE #2 SALES: |  |  | 2000 |  |  |  | TOTAL GOAL: |  |  | 4000
 |  |  |  |  |  |  |  | SALES ISSUE #1 |  |  | 2000 | 1
 |  |  |  |  |  |  |  | SALES ISSUE #2 |  |  | 1900 | 0.95
 | Sales For the Month: |  |  |  |  |  |  | TOTAL SALES: |  |  | 3900 | 0.975
 |  | Below sales goal: | 0.06
 |  | At goal to 109.9% | 0.08 |  |  |  |  | PERCENT CHG: |  |  | 0.475
 |  | 110% of goal or higher | 0.1
 |  |  |  |  |  |  |  | PAYMENTS RECEIVED: |  |  | 1000
 |  |  |  |  |  |  |  | INCENTIVE PAYMENT PERCENTAGE: |  | #N/A |  | 0.06
 |  |  |  |  |  |  |  | TOTAL INCENTIVE: |  | 0 |  | 60
 |  |  |  |  |  |  |  | SIGNED BY:
 |  |  |  |  |  |  |  | MANAGER:
 |  |  |  |  |  |  |  | DEPARTMENT HEAD:
Spreadsheet: 764177d1642621819-using-subtotal-to-calculate-avergeif-maxifs-and-minifs-on-filtered-dataset-sample-for-forum-210119
Sheet: Match Scores

Group A Users | Group B users | Match Score |  | All Users | # Matches |  | average of AGroup User Match score | average of BGroup User Match score | AGroup User MAX Match Score | BGroup User MAX Match Score | [NAME] MIN Match Score | BGroup User MIN Match Score
AUser 1 | BUser 3 | 122 |  | AUser 1
AUser 1 | BUser 9 | 193 |  | AUser 2
AUser 10 | BUser 2 | 247 |  | AUser 3
AUser 10 | BUser 3 | 174 |  | AUser 4
AUser 2 | BUser 4 | 222 |  | AUser 5
AUser 3 | BUser 5 | 224 |  | AUser 6
AUser 4 | BUser 1 | 143 |  | AUser 7
AUser 4 | BUser 6 | 169 |  | AUser 8
AUser 5 | BUser 6 | 166 |  | AUser 9
AUser 5 | BUser 8 | 316 |  | AUser 10
AUser 6 | BUser 10 | 228 |  | BUser 1
AUser 7 | BUser 7 | 274 |  | BUser 2
AUser 7 | BUser 5 | 322 |  | BUser 3
AUser 8 | BUser 10 | 265 |  | BUser 4
AUser 8 | BUser 2 | 282 |  | BUser 5
AUser 8 | BUser 9 | 153 |  | BUser 6
AUser 9 | BUser 9 | 132 |  | BUser 7
AUser 9 | BUser 9 | 189 |  | BUser 8
AUser 9 | BUser 7 | 291 |  | BUser 9
AUser 9 | BUser 8 | 217 |  | BUser 10
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44018

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44018
Number of cores |  | 4
Spare cores |  | 3
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | GCB6 Status
Panel Number | T44 PP |  | Panel Number |  | GCB4
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | GCB4 | INITIAL
1 | 20/ADY441163 |  | TBY5:6 |  | X12:4
2 | Spare
3 | Spare
4 | Spare
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes | 2011-08-02 00:00:00 | Create a new row called -X13 (left of -X03).  For more info see cable core card 46115 and drawings. |  |  |  | DJC
 |  | This needs to be checked out with drawings. Core card for G6 is very different
Edition Notes | 2011-08-02 00:00:00 | Was cable 4518 |  |  |  | DJC
Spreadsheet: 167824d1342110932-excel-2007-vlookup-help-2012-bud-help_v2
Sheet: Budget 2012

2012 | VZW | TRUCK | INS | CRUZ | RGE | TW | SALLIE | ACS | AES | [NAME] | FED LOAN | WELLS | RZMC | CC
Jan |  |  |  | 242.3
Feb |  |  |  | 242.3
Mar |  |  |  | 242.3
Apr |  |  |  | 242.3
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
AVG
 |  |  | BILLS | BI WKLY
 | pay after tax |  | biweekly pay | Bi-Wkly Net | Wkly Net
 | 1789 |  |  | 1789
Spreadsheet: 539002d1505920698-sort-by-month-into-two-separate-columns-s666-1201700-sort-by-month-into-two-separate-columns
Sheet: Sheet1

Item Code | PO Date | Unit Cost | Qty Received |  |  | PO Date | Sum of Unit Cost | Sum of Qty Received
APT171750 | 2017-08-02 00:00:00 | 93.5 | 20 |  |  | Jul | 745.1 | 472
APT84 | 2017-08-10 00:00:00 | 100.03 | 2 |  |  | Aug | 1913.724 | 823
APT84BD | 2017-07-18 00:00:00 | 112.53 | 20 |  |  | Grand Total | 2658.824 | 1295
APT84BD | 2017-08-02 00:00:00 | 112.53 | 20
APT84BD | 2017-08-23 00:00:00 | 112.53 | 10
APT8626S | 2017-07-18 00:00:00 | 100.02 | 20
APT8626S | 2017-08-02 00:00:00 | 100.02 | 20
APT8626S | 2017-08-23 00:00:00 | 100.02 | 20
APT88RENEW | 2017-08-23 00:00:00 | 126.19 | 10
APTBIONOVUSE | 2017-07-13 00:00:00 | 85 | 48
APTEZBIO14 | 2017-07-13 00:00:00 | 110 | 36
APTEZBIO14 | 2017-07-18 00:00:00 | 110 | 144
APTEZBIO14 | 2017-08-09 00:00:00 | 110 | 72
APTEZBIO14 | 2017-08-24 00:00:00 | 110 | 72
APTFP17A | 2017-07-13 00:00:00 | 83 | 80
APTFP17A | 2017-08-15 00:00:00 | 83 | 10
APTFP17A | 2017-08-15 00:00:00 | 83 | 80
APTMPDCB | 2017-08-08 00:00:00 | 90 | 60
APTMPDCB | 2017-08-15 00:00:00 | 90 | 10
APTMPDCB | 2017-08-29 00:00:00 | 90 | 60
B1150CT-A | 2017-07-14 00:00:00 | 38 | 50
B1150CT-A | 2017-08-15 00:00:00 | 38 | 10
BB12231 | 2017-07-24 00:00:00 | 34.45 | 4
BB1517I | 2017-08-16 00:00:00 | 129 | 0
BB1517I | 2017-08-16 00:00:00 | 129 | 1
BB45 | 2017-08-02 00:00:00 | 32 | 1
BB685I | 2017-08-07 00:00:00 | 16.4 | 35
BB685I | 2017-07-05 00:00:00 | 18 | 50
BB685I | 2017-08-16 00:00:00 | 18 | 16
BB685I | 2017-08-16 00:00:00 | 18 | 34
BB685I | 2017-08-29 00:00:00 | 18 | 60
BB685P | 2017-07-19 00:00:00 | 39.1 | 10
BB685P | 2017-08-23 00:00:00 | 41.054 | 20
BB912I | 2017-08-07 00:00:00 | 13.9 | 100
BB912I | 2017-07-24 00:00:00 | 15 | 10
BB912I | 2017-08-02 00:00:00 | 15 | 20
BB912I | 2017-08-11 00:00:00 | 15 | 20
BB912I | 2017-08-16 00:00:00 | 15 | 30
BB912I | 2017-08-29 00:00:00 | 14.55 | 10
Spreadsheet: 843673d1695467874-non-array-formula-to-change-vertical-data-to-horizontal-data-book1
Sheet: Sheet1

 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  |  |  | a
 |  |  |  | b
 |  |  |  | c
 |  |  |  | d
 |  |  |  | e
Spreadsheet: dan_hyvl__4873__Reliant-Etx-HLP
Sheet: Sheet1

Buyer | [NAME] | Deal No. | Originator | Broker | Type | Deal Date | Contact | Status | Reason | Beg Date | End Date
[NAME] | ENA | NP8850.1 | Wallis Jan |  | Swap | 2000-07-06 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
[NAME] | ENA | [NAME] | [NAME] |  | Swap | 2000-07-07 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
ENA | [NAME] | NQ4256.1 |  |  | Swap | 2000-07-11 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
ENA | ENTEX | NJ0095.2 | Wallis Jan |  | Swap | 2000-06-27 00:00:00 |  | Pending | Sent to legal | 2000-07-01 00:00:00 | 2000-10-31 00:00:00
ENA | ENTEX | NJ7675.4 | Wallis Jan |  | Swap | 2000-06-27 00:00:00 |  | Pending | Sent to legal | 2000-07-01 00:00:00 | 2000-10-31 00:00:00
ENA | ENTEX | NJ9458.5 |  |  | Forward | 2000-06-27 00:00:00 |  | Pending | Sent to legal | 2000-07-01 00:00:00 | 2000-07-31 00:00:00
ENA | ENTEX | NJ9458.6 |  |  | Forward | 2000-07-17 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2000-08-30 00:00:00
ENTEX | ENA | NK6915.5 | Wallis Jan |  | Flex Price | 2000-06-08 00:00:00 |  | Pending | Sent to legal | 2000-07-01 00:00:00 | 2000-07-31 00:00:00
ENTEX | ENA | NO1052.1 | Wallis Jan |  | Forward | 2000-06-22 00:00:00 |  | Pending | Sent to legal | 2000-11-01 00:00:00 | 2001-03-31 00:00:00
[NAME] | ENA | NO0793.2 | Wallis Jan |  | Swap | 2000-06-27 00:00:00 |  | Pending | Sent to legal | 2000-07-01 00:00:00 | 2000-10-31 00:00:00
ENA | [NAME] | NQ6021 | Wallis Jan |  | Swap | 2000-07-17 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
[NAME] | ENA | NR3351 | Wallis Jan |  | Swap | 2000-07-18 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
[NAME] | ENA | NR3501 | Wallis Jan |  | Swap | 2000-07-18 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-03-31 00:00:00
ENA | [NAME] | NR7345.1 | Wallis Jan |  | Swap | 2000-07-20 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
[NAME] | ENA | NR7329.1 | Wallis Jan |  | Swap | 2000-07-20 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
ENA | [NAME] | NR8733.1 | Wallis Jan |  | Swap | 2000-07-20 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2001-07-31 00:00:00
ENA | ENTEX | NJ9458 | Wallis Jan |  | Forward | 2000-07-28 00:00:00 |  | Pending | Sent to legal | 2000-08-01 00:00:00 | 2000-08-30 00:00:00
Spreadsheet: 752461d1634766228-unique-for-multiple-columns-consolidator
Sheet: Tool-CWOP LE

Input Data in the Green areas, results populate in Blue, consolidated in Yellow
NOTE:  [NAME] are protected.  Unprotect sheet to change them.  No password.
 |  |  | 4116 Amount | 552398.8
Invoice | Date | Location | Region | Amount |  |  | MM/YY | DEPTID | PROGRAM | PROJECT_ID | APPROP | PCA | AY | ACCOUNT | ACCOUNT_DESCR | Amount | Description
 |  |  |  |  | Total
10658 | 2021-10-03 00:00:00 | San Antonio | 8A or 08 | 80640 |  |  |  |  | 11000 |  | 13040 | 03040 |  | 7299CW | Security for CWOP
10662 | 2021-10-03 00:00:00 | El Paso | 10 | 3835
10668 | 2021-09-26 00:00:00 | Corpus Christi | 11
10670 | 2021-10-03 00:00:00 | Midland | 09 | 4543
10671 | 2021-10-03 00:00:00 | mckinney | 3E | 23205
10674 | 2021-10-03 00:00:00 | [NAME] | 04 | 26812.5
10675 | 2021-10-03 00:00:00 | Lufkin | 05 | 29377
10676 | 2021-10-03 00:00:00 | Round Rock | 07 | 18720
10691 | 2021-10-03 00:00:00 | [NAME] | 6B (Invalid for FC; use 6A) | 28050
10692 | 2021-10-03 00:00:00 | Houston | 6A | 11040
10706 | 2021-10-10 00:00:00 | Seguin | 8B or 08 | 83038.8
10720 | 2021-10-10 00:00:00 | El Paso | 10 | 3055
10721 | 2021-10-10 00:00:00 | [NAME] | 04 | 25740
10722 | 2021-10-10 00:00:00 | Lufkin | 05 | 27057
10723 | 2021-10-10 00:00:00 | Round Rock | 07 | 19240
10724 | 2021-10-10 00:00:00 | Midland | 09 | 4543
10725 | 2021-10-07 00:00:00 | Richardson | 3E | 14982.5
10730 | 2021-10-08 00:00:00 | [NAME] | 6B (Invalid for FC; use 6A) | 22620
10731 | 2021-10-10 00:00:00 | Houston | 6A | 14880
10732 | 2021-10-10 00:00:00 | Corpus Christi | 11 | 50342.5
10668 | 2021-10-03 00:00:00 | Corpus Christi | 11
 |  |  |  |  |  |  | Consolidator |  |  |  |  |  |  |  |  | Amount | Description
 |  |  |  |  |  |  | MM/YY | DEPTID | PROGRAM | PROJECT_ID | APPROP | PCA | AY | ACCOUNT | ACCOUNT_DESCR
 |  |  |  |  |  |  |  | 10CDDOTH
 |  |  |  |  |  |  |  | 11CDDOTH
 |  |  |  |  | In |  |  | 09CDDOTH
 |  |  |  |  |  |  |  | 3ECDDOTH
 |  |  |  |  |  |  |  | 04CDDOTH
 |  |  |  |  |  |  |  | 05CDDOTH
 |  |  |  |  |  |  |  | 07CDDOTH
 |  |  |  |  |  |  |  | 6ACDDOTH
Spreadsheet: 136232d1326485194-creating-a-new-unique-unique-list
Sheet: Dashboard Control Tab

 | [NAME]
1 | 2011 Actuals | True
2 | 2011 Budget | False
3 | 2011 Forecast | True
4 | 2011 MTP | False
5 | 2011 Quota | True
6 | 2011 West Region Recommendation | True
7 | 2012 Actuals | True
8 | 2012 Budget | True
9 | 2012 Forecast | True
10 | 2012 MTP | True
11 | 2012 Quota | True
12 | 2012 West Region Recommendation | True
 | Actuals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MoM%
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 454455d1459850545-converting-google-sheets-formula-to-excel-kopia-example-1
Sheet: Sheet1

Date | Buy/Sell | Stock | Units | Previous Units | Cumulative Units
2016-01-01 00:00:00 | Buy | AAPL | 1000 |  | 1000
2016-01-02 00:00:00 | Buy | GOOG | 300 |  | 300
2016-01-03 00:00:00 | Sell | AAPL | 200 |  | 800
2016-01-04 00:00:00 | Buy | GOOG | 200 |  | 500
2016-01-05 00:00:00 | Sell | GOOG | 100 |  | 400
Spreadsheet: 292087d1390489736-conditional-formatting-if-a-number-starts-with-specific-digits-0a1_a42
Sheet: Sheet1

 | ith 91099 or 91004.
 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
 | 85204 | 5556879
 | 45286 | 5556879
 | 91099 | 5556879
 | 91004 | 5556879
Spreadsheet: 815859d1675239085-unique-filter-sort-and-sumproduct-or-counta-all-together-unique_filter_sort_dynamic_array
Sheet: Sheet1

 |  |  |  | CUSTOMER | Status |  | CUSTOMER | Paid | Pending
 |  |  |  | Customer A | Paid |  | Customer A | 4 | 6
 |  |  |  | Customer B | Paid |  | Customer B | 1 | 4
 |  |  |  | Customer C | Pending |  | Customer C | 3 | 2
 |  |  |  | Customer B | Pending
 |  |  |  | Customer C | Paid
 |  |  |  | Customer A | Paid
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Paid
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Pending
 |  |  |  | Customer A | Pending
 |  |  |  | Customer C | Pending
 |  |  |  | Customer B | Pending
 |  |  |  | Customer B | Pending
 |  |  |  | Customer B | Pending
 |  |  |  | Customer A | Paid
 |  |  |  | Customer A | Pending
 |  |  |  | Customer C | Paid
 |  |  |  | Customer C | Paid
Spreadsheet: joe_parks__15027__BridgeDPR0604
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 833.7412723999984 | 5988.741272399999 | 11279.7412724
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 833.7412723999984 | 5988.741272399999 | 11279.7412724
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 494648d1482546070-calculating-r-squared-for-selective-data-24-dec-2016
Sheet: Sheet1

64.38720084826149 | 31.33
62.54044678702972 | 29.66
60.69369272579794 | 27.44
60.22068799178906 | 29.86
59.74768325778022 | 31.09
59.27467852377137 | 28.01
58.80167378976252 | 26.91
58.32866905575367 | 29.15
57.85566432174483 | 27.3
57.38265958773598 | 29.51
56.90965485372713 | 27.45
56.43665011971828 | 27.62
55.96364538570943 | 33.3
55.49064065170059 | 37.18
55.01763591769173 | 35.97
54.69769564190093 | 34.24
54.37775536611009 | 36.97
54.05781509031926 | 38.92
53.73787481452842 | 38.19
53.41793453873758 | 36.17
53.09799426294675 | 35.54
52.77805398715591 | 39.34
52.45811371136508 | 38.31
52.13817343557425 | 34.62
51.81823315978341 | 34.27
51.49829288399258 | 34.99
51.17835260820174 | 31.95
49.15810846882872 | 31.16
47.1378643294557 | 35.59
45.11762019008267 | 32.69
43.09737605070965 | 36.9
41.07713191133662 | 36.22
39.05688777196359 | 34.24
37.03664363259058 | 35.9
35.01639949321755 | 39.01
32.99615535384452 | 36.75
30.9759112144715 | 37
28.95566707509847 | 34.1
26.93542293572545 | 32.88
31.17443448193558 | 32.43
35.41344602814571 | 30.61
39.65245757435583 | 32.87
43.89146912056596 | 32.63
48.13048066677609 | 34.17
52.36949221298622 | 34.31
56.60850375919635 | 34.24
60.84751530540647 | 34.12
65.08652685161661 | 37.45
69.32553839782675 | 32.33
73.56454994403688 | 31.84
77.803561490247 | 33.01
71.85023247806679 | 33.23
65.89690346588655 | 32.72
59.94357445370632 | 29.17
53.99024544152608 | 29.73
48.03691642934586 | 27.28
42.08358741716563 | 25.4
36.1302584049854 | 23.99
30.17692939280517 | 23.46
24.22360038062494 | 21.81
18.27027136844471 | 20.42
12.31694235626448 | 20.31
6.363613344084252 | 17.44
5.787950866683278 | 14.43
5.212288389282303 | 17.19
4.636625911881329 | 19.96
4.060963434480354 | 20.74
3.48530095707938 | 21.75
2.909638479678406 | 21.01
2.333976002277431 | 19.77
1.758313524876457 | 21.26
1.182651047475482 | 20.24
0.6069885700745079 | 19
0.03132609267353353 | 17.95
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
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
1.444804038353703 | 20.67
6.134873318820844 | 22.91
Spreadsheet: 98fd94bb-dbed-4b43-97c5-f7ac27cc5d53
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260971 | 50580 | [NAME] | [NAME] | GBR | 2 | 00:13:33 | 00:00:55 | 00:31:01 | [NAME] | 00:21:31 | 1 | 01:07:37
260971 | 41159 | Charlotte | Ellis | GBR | 4 | 00:14:20 | 00:01:07 | 00:31:25 | 00:00:48 | 00:20:59 | 2 | [NAME]
260971 | 40701 | [NAME] | Rodriguez | ESP | 1 | 00:13:48 | 00:01:12 | 00:30:04 | 00:00:49 | 00:24:23 | 3 | 01:10:14
260971 | 72678 | Zsófia | Lengyel | HUN | 3 | 00:20:47 | 00:02:01 | 00:39:39 | [NAME] | 00:29:08 | 4 | [NAME]
Spreadsheet: 137362d1327075969-please-help-with-traffic-light-problem-exercise-traffic-signal-management-2-
Sheet: Exercise 1

 | Going To East | Going to West | Going to South | Going to North
Red | 45 | 45 | 45 | 45
Yellow | 2 | 2 | 2 | 2
Green | 11 | 17 | 4 | 12
Yellow | 2 | 2 | 2 | 2
 | Time
 | Second
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | â
Red |  |  |  |  |  |  |  |  |  |  |  |  | à |  |  |  | ß
Yellow
Green |  |  |  |  |  |  |  |  |  |  |  |  |  |  | á
Yellow
Light Color
Spreadsheet: 678916d1590119040-how-to-copy-data-headings-in-2-columns-and-paste-in-other-columns-multiple-times-bill-of-materials-sample
Sheet: Sheet1

SKU Title | Product Title | Product SKU | Product Name
CV-BLACK-AND-YELLOW-BASE | Black and [NAME] | CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
CV-BLACK-AND-YELLOW-BASE | Black and [NAME]
 |  | [NAME] | Brewtus - Base
 |  | [NAME] | [NAME]
 |  | CV-CREAMED-COCONUT-BASE | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | Drupaceous - Base
 |  | [NAME] | Fo'Cereal - Base
 |  | [NAME] | Frosted [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | Juicy Red - Base
 |  | CV-LIMED-BASE | Limed - Base
 |  | [NAME] | Melondramatic - Base
 |  | CV-NAPOLEON-BASE | [NAME]
 |  | CV-PEACHEENA-BASE | Peacheena - Base
 |  | [NAME] | Refresh - Base
 |  | [NAME] | Stay [NAME]
 |  | CV-THE-BLUE-HEIFER-BASE | The Blue Heifer - Base
 |  | CV-THE-CLASSIC-HEIFER-BASE | The Classic Heifer - Base
 |  | CV-THE-CONNOISSEUR-BASE | The Connoisseur - Base
 |  | CV-THE-FAT-STACK-BASE | The Fat Stack - Base
 |  | CV-THE-MANGO-HEIFER-BASE | The Mango Heifer - Base
 |  | CV-THE-PINK-HEIFER-BASE | The Pink Heifer - Base
 |  | CV-THE-PURPLE-HEIFER-BASE | The Purple Heifer - Base
 |  | CV-THE-RED-HEIFER-BASE | The Red Heifer - Base
 |  | CV-THE-SPEARMINT-HEIFER-BASE | The Spearmint Heifer - Base
 |  | CV-THE-TURNDOWNER-BASE | The Turndowner - Base
 |  | CV-THE-YELLOW-HEIFER-BASE | The Yellow Heifer - Base
 |  | [NAME] | Worms - Base
 |  | [NAME] | Pink Bits - Base
Spreadsheet: 50913d1250513893-adding-monthly-refresh-of-data-sample
Sheet: Sheet1

Database
Company | Date Contacted | PI Total | PO Total |  | Today's Date:
a | 2009-05-25 00:00:00 | 0 | 0 |  | 2009-08-17 00:00:00
b | 2009-06-14 00:00:00 | 54000 | 0
c | 2009-06-15 00:00:00 | 160000 | 0
d | 2009-07-14 00:00:00 | 14800 | 14800
e | 2009-08-04 00:00:00 | 500 | 500
f | 2009-08-16 00:00:00 | 0 | 0
Database Tracking
Date | Companies in Database | PI Total to Date
2009-05-01 00:00:00 | 0 | 0
2009-06-01 00:00:00 | 0 | 0
2009-07-01 00:00:00 | 1 | 214000
2009-08-01 00:00:00 | 1 | 228800
Spreadsheet: 88111d1288031585-detecting-all-the-incidences-of-a-value-example
Sheet: Sheet1

[NAME] | Apple | Pear | [NAME]
[NAME] | [NAME] | Nick | [NAME]
Anne | [NAME] | [NAME] | Nick |  |  |  | BEFORE
[NAME] | [NAME] | Anne | [NAME]
[NAME] | Nick |  | [NAME]
Nick | [NAME] |  | [NAME]
[NAME] | [NAME]
Anne | [NAME] | Pear
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | Apple | [NAME]
Nick | [NAME] | Apple | Pear | [NAME] |  |  | AFTER
[NAME] | Apple
[NAME] | Apple | Pear | [NAME]
[NAME] | Apple | [NAME]