tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40507__2002 EGF Allocations Citrus
Sheet: Citrus

Enron Global Finance
2001 Allocations
 |  |  |  | Citrus Corp
 |  |  |  | 2001 |  | 2002
106188 | Schnapper | Corp Finance |  | 0 | 0 | 0 | 0
106189 | Perkins | Treasury |  | 20036 | 0.006899895723276851 | 26226 | 0.008500039757170121
106190 | Kopper | Structured Finance |  | 0 | 0 | 0 | 0
106191 | [NAME] | Commercial Support |  | 0 | 0 | 7436 | 0.00500007732771553
106192 | Glisan | Treasury VP |  | 0 | 0 | 0 | 0
106193 | Boots | Investor/Debt Relations |  | 0 | 0 | 0 | 0
106194 | [NAME] | Legal |  | 0 | 0 | 0 | 0
106195 | [NAME] | Capital Market Equity |  | 0 | 0 | 26640 | 0.02000035536166934
106196 | EGF | G&A |  | 0 | 0 | 78766 | 0.004600011680196228
106285 | Fastow | Executive |  | 0 | 0 | 0 | 0
107038 | EGF | Projects |  | 0 | 0 | 0 | 0
140411 | Glisan | Intl Asset Structures |  | 0 | 0 | 0 | 0
 |  | S/T |  |  | 0.0009288044243651602 |  | 0.003849095250327504
Spreadsheet: 544711d1509008128-target-increase-spreadsheet-example-13-
Sheet: Sheet1

Week No | Sales 2017 | Actual sales 2018 | Running Target | Up / Down
1 | 1000 | 1200
2 | 1200 | 1800
3 | 1300 | 1900
4 | 1100 | 1600
5 | 1200
6 | 1000
7 | 1300
8 | 1500
9 | 2000
10 | 2100
11 | 750
12 | 1000
13 | 200
14 | 1700
15 | 1600
16 | 1300
17 | 1000
18 | 1200
19 | 1300
20 | 1100
21 | 1200
22 | 1000
23 | 1300
24 | 1500
25 | 2000
26 | 2100
27 | 750
28 | 1000
29 | 200
30 | 1700
31 | 1600
32 | 1300
33 | 1000
34 | 1200
35 | 1300
36 | 1100
37 | 1200
38 | 1000
39 | 1300
40 | 1500
41 | 2000
42 | 2100
43 | 750
44 | 1000
45 | 200
46 | 1700
47 | 1600
48 | 1300
49 | 200
50 | 1700
51 | 1600
52 | 1300
Spreadsheet: 769119d1645311067-wenn-datum-l-nger-her-als-x-oder-l-nger-her-als-y-dann-test
Sheet: Tabelle1

 |  | 1. Impfung | 2. Impfung | 3.Impfung | Genesen | Arbeitserlaubnis
 | [NAME] | 2021-01-01 00:00:00 | 2021-05-25 00:00:00 | 2022-01-27 00:00:00 |  |  |  |  | =IF(OR(AND(E7<>"",DATEDIF(E7,TODAY(),"m")>5),AND(F7<>"",DATEDIF(F7,TODAY(),"m")>3)),TRUE,FALSE)
 | [NAME] | 2021-01-01 00:00:00 | 2021-05-25 00:00:00 |  | 2022-02-02 00:00:00 |  |  |  | =OR(AND(E7<>"",DATEDIF(E7,TODAY(),"m")>5),AND(F7<>"",DATEDIF(F7,TODAY(),"m")>3))
 | [NAME] | 2021-06-01 00:00:00 |  |  | 2021-09-01 00:00:00 |  |  |  | =AND(E7<>"",DATEDIF(E7,TODAY(),"m")>5) & " " & AND(F7<>"",DATEDIF(F7,TODAY(),"m")>3)
 | Maria | 2021-08-01 00:00:00
 | Ralf |  |  |  | 2021-11-03 00:00:00
 | Nadine | 2021-07-01 00:00:00 |  |  | 2021-01-03 00:00:00
 | Test |  |  | 2021-08-01 00:00:00 |  |  |  |  | Hi there,
 |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  | 2022-02-01 00:00:00 |  |  |  | I made a small table to show visually what I want.
 |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  | 2021-12-01 00:00:00 |  |  |  | In column C,D,E,F is data.
 |  |  |  |  | 2021-11-01 00:00:00 |  |  |  | In column G it should now be checked whether the date in column F is more than 3 months ago from today or the date in column E is more than 5 months ago.
 |  |  |  |  | 2021-10-01 00:00:00 |  |  |  | If one of the two conditions is met, "True" should be returned.
 |  |  |  |  | 2021-09-01 00:00:00 |  |  |  | If none of the conditions are met, "False" should be returned.
 |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  | 2021-07-01 00:00:00 |  |  |  | I hope that's understandable.
 |  |  |  | 2021-08-01 00:00:00 | 2021-08-01 00:00:00
 |  |  |  | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 |  |  |  | Kind regards [NAME]
Spreadsheet: b79e62be-b7ca-44e2-8698-f2c66d8996c5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4322 | 23558 | [NAME] | [NAME] | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Men
4321 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:00:00 | Elite Women
Spreadsheet: 674548d1587906690-unique-value-count-based-of-multiple-criteria-2020-04-26-oeldere-1-674540d1587903414-unique-value-count-based-of-multiple-criteria-kv
Sheet: BONOUS

CUSTOMER CODE --->> |  | 0026628X
 |  |  |  |  |  | 04 | 03
 |  |  | TOTAL COUNT | SUM | UNIQUE COUNT | UNIQUE SUM |  |  | unique count(unique DOB in NB sheet) in Col.F6 if C2 satisfies below mentioned contidions:-
20190401 | 20200331 |  |  |  | 5 |  |  |  | IF(NB!A:A,"NB"and NB!M:M,C2 and NB!F:F>=A6 and NB!F:F<=&B6, nb!L:L (UNIQUE DOB)
20180401 | 20190331
20170401 | 20180331 |  |  |  |  |  |  |  | EXPECTED ANSWER IN WRITTEN IN COL F6 AND F14
20160401 | 20170331
20150401 | 20160331
20140401 | 20150331 |  |  |  |  |  |  |  | Sir,
20130401 | 20140331 |  |  |  |  |  |  |  | In want to count unique values based on DOB(date of birth) through excel formula.
20120401 | 20130331 |  |  |  |  |  |  |  | I have tried many excel formulas. but unable to get desired result.
20110401 | 20120331 |  |  |  | 6 |  |  |  | unique count(unique DOB in NB sheet) in Col.F6 if C2 satisfies below mentioned contidions:-
20100401 | 20110331 |  |  |  |  |  |  |  | IF(NB!A:A,"NB"and NB!M:M,C2 and NB!F:F>=A6 and NB!F:F<=&B6, nb!L:L (UNIQUE DOB)
20090401 | 20100331 |  |  |  |  |  |  |  | EXPECTED ANSWER IN WRITTEN IN COL F6 AND F14
20080401 | 20090331
20070401 | 20080331
20060401 | 20070331
SUM(--(FREQUENCY(IF(NB!A:A,"NB")*(NB!M:M,C2)*(NB!F:F,">="&A6)*(NB!F:F,"<="&B6),NB!L:L),NB!L:[NAME]))))
Spreadsheet: 35979d1233710756-how-can-i-auto-sort-book1
Sheet: Sheet2

 |  | [NAME]
 |  | Hours to Date
Date |  | Hours |  | Total
 |  |  |  | 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
Spreadsheet: 485291d1476807233-formula-making-problem-ef-zoharsb
Sheet: Sheet1

 |  | 7.54 |  | 7.54
 |  | calculated field |  | calculated field
 |  | data feed (manually feed) |  | data feed
2016-08-01 00:00:00 | mon | 9.543 |  | 9.543
2016-08-02 00:00:00 | tue | 8.97 |  | 8.97
2016-08-03 00:00:00 | wed | 10.47 |  | 10.47
2016-08-04 00:00:00 | thu | 9.87 |  | 9.87
2016-08-05 00:00:00 | fri | 8.79 |  | 8.79
2016-08-06 00:00:00 | sat
2016-08-07 00:00:00 | [NAME]
2016-08-08 00:00:00 | mon | 7.32 |  | 7.32
2016-08-09 00:00:00 | tue | 7.85 |  | 7.85
2016-08-10 00:00:00 | wed | 8.945 |  | 8.945
2016-08-11 00:00:00 | thu | 7.89 |  | 7.89
2016-08-12 00:00:00 | fri | 7.65 |  | 7.65
2016-08-13 00:00:00 | sat
2016-08-14 00:00:00 | [NAME]
2016-08-15 00:00:00 | mon | 7.33 |  | 7.33
2016-08-16 00:00:00 | tue | 6.99 |  | 6.99
2016-08-17 00:00:00 | wed | 7.834 |  | 7.834
2016-08-18 00:00:00 | thu | 6.87 |  | 6.87
2016-08-19 00:00:00 | fri | 17.98 |  | 6.02
2016-08-20 00:00:00 | sat
2016-08-21 00:00:00 | [NAME]
2016-08-22 00:00:00 | mon | 6.02 |  | 17.98
2016-08-23 00:00:00 | tue | 8.02 |  | 8.02
2016-08-24 00:00:00 | wed | 8.04 |  | #8.02
 |  |  |  | here as due to special character added, the formula is not working AND this has further effects
2016-08-25 00:00:00 | thu | 26.89 |  | 6.89
2016-08-26 00:00:00 | fri | 6.34 |  | 6.34
Spreadsheet: 63396d1264324159-sumproduct-multiple-criteria-testtaxproblems
Sheet: JAN 2010

 |  |  | 1.45% | 6.20% | 0.113 | 0.17 |  | 1.45% | 6.20% | 0.113 | 0.17 | 1.45% | 6.20% | 0.113 | 0.17 | 1.45% | 6.20% | 0.113 | 0.17
 |  | Net |  |  | Net | Net | Total | Remaining to [NAME] |  |  |  |  |  |  |  | Calculation
Pay # | Name | Comp | MCR Tax | FICA Tax | Pension | Pension | W-2 | MCR | FICA | 11.3 Pens | 17 Pens | MCR | FICA | 11.3 Pens | 17 Pens | MCR | FICA | 11.3 Pens | 17 Pens
8 | SMITH | 2122.813026925881 | 22.64125699920947 | 96.8108919966198 | 176.4456579938393 | 265.4492199907318 | 1561.47 | 1000000000 | 6621.6 | 1017 | 41137 | 22.64125699920947 | 96.8108919966198 | 176.4456579938393 | 265.4492199907318 | 22.64125699920947 | 93.54257830092725 | 164.5252894668207 | 238.2034419652804
13 | JONES | 21167.46128 | 225.7654936079441 | 965.3421105994852 | 1759.413846737771 | 2646.905787127621 | 15570.03 | 1000000000 | 6621.6 | 1017 | 41137 | 225.7654936079441 | 965.3421105994852 | 1759.413846737771 | 2646.905787127621 | 234.4016755395107 | 965.4780520556416 | 1692.93838263197 | 2443.351225106991
Spreadsheet: 594427d1539765441-keep-record-of-all-changes-within-a-table-sample-data-sheet
Sheet: Master Data

Action from Business Plan  (taken from the Business Plan) | Does this action require a risk assessment? | Risk (Description) | Mitigations/ Controls/ Management Actions in place | Risk Category | Likelihood | Consequence | Suggestion on additional actions/controls/mitigation | Risk Score (L x C) | Ownershiop | Division
ensure everything is working for 2019 | Yes | if tracking is not accurate records will not be accurate | get help from excel community | Reputational | 4 | 4 | n/a | 16 | [NAME] | Risk Management
Test 2 | Yes | accurate records for audit | ensure records are up to date | Operational | 2 | 5 | n/a | 10 | [NAME] | Risk Management
Ensue IT systems are in palce | Yes | Failure of IT systems could lead to unsecure data | seek advice from IT wiz ltd | Legal / Regulatory | 3 | 4 | n/a | 12 | [NAME] | IT
Spreadsheet: 2a5ffaa3-3530-4087-95c7-7c563c448d35
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/30/2008 | Football | VILLANOVA | 12:00 AM | W, 48-21
09/06/2008 | Football | at East Carolina | 12:00 AM | L, 3-24
09/18/2008 | Football | at Colorado | 12:00 AM | L, 14-17 (OT)
09/27/2008 | Football | [NAME] | 12:00 AM | W, 27-3
10/04/2008 | Football | RUTGERS | 12:00 AM | W, 24-17
10/11/2008 | Football | SYRACUSE | 12:00 AM | W, 17-6
10/23/2008 | Football | AUBURN | 12:00 AM | W, 34-17
11/01/2008 | Football | at Connecticut | 12:00 AM | W, 35-13
11/08/2008 | Football | CINCINNATI | 12:00 AM | L, 23-26 (OT)
11/22/2008 | Football | at Louisville | 12:00 AM | W, 35-21
11/28/2008 | Football | at Pitt | 12:00 AM | L, 15-19
12/06/2008 | Football | USF | 12:00 AM | W, 13-7
12/27/2008 | Football | North Carolina (Meineke Car Care Bowl) | 12:00 AM | W, 31-30
Spreadsheet: 04ccdaaf-8b06-41c3-a52b-189040dff6f6
Sheet: 7.Costs for Replacement feeding

 | Cost for replacement feeding
 |  | Feeding | [NAME] needed (g) | Cumulative amount of formula (g) |  |  | Total cost of formula ($)
 | 1st week | 50mL x 7 times per day x 7 days
 | 2nd week | 100 mL x 6 times per day x 7 days
 | 3rd & 4th week | 100 mL x 6 times per day x 14 days
 | up to 2 months | 150 mL x 5 times per day x 30 days
 | up to 4 months | 200 mL x 5 times per day x 60 days
 | up to 6 months | 200 mL x 5 times per day x 60 days
 | up to 12 months | 200 mL x 3 times per day x 180 days
 | up to 18 months | 200 mL x 3 times per day x 180 days
Spreadsheet: 473089d1470045196-vlookup-partial-text-example
Sheet: New club1

Student Ref (five digit) | Student Name | Residence | Age (1/9/15) | Nationality | Gender | Week beginning | 2015-09-07 00:00:00 | 2015-09-14 00:00:00 | 2015-09-21 00:00:00 | 2015-09-28 00:00:00 | 2015-10-05 00:00:00 | 2015-10-12 00:00:00 | 2015-10-19 00:00:00 | 2015-10-26 00:00:00 | 2015-11-02 00:00:00 | 2015-11-09 00:00:00 | 2015-11-16 00:00:00 | 2015-11-23 00:00:00 | 2015-11-30 00:00:00 | 2015-12-07 00:00:00 | 2015-12-14 00:00:00 | 2015-12-21 00:00:00 | 2015-12-28 00:00:00 | 2016-01-04 00:00:00 | 2016-01-11 00:00:00 | 2016-01-18 00:00:00 | 2016-01-25 00:00:00 | 2016-02-01 00:00:00 | 2016-02-08 00:00:00 | 2016-02-15 00:00:00 | 2016-02-22 00:00:00 | 2016-02-29 00:00:00 | 2016-03-07 00:00:00 | 2016-03-14 00:00:00 | 2016-03-21 00:00:00 | 2016-03-28 00:00:00 | 2016-04-04 00:00:00 | 2016-04-11 00:00:00 | 2016-04-18 00:00:00 | 2016-04-25 00:00:00 | 2016-05-02 00:00:00 | 2016-05-09 00:00:00 | 2016-05-16 00:00:00 | 2016-05-23 00:00:00 | 2016-05-30 00:00:00 | 2016-06-06 00:00:00 | 2016-06-13 00:00:00 | 2016-06-20 00:00:00 | 2016-06-27 00:00:00
Spreadsheet: 840434d1692725568-generate-a-random-number-help2
Sheet: Sheet1

Customer | Counter | Reference
TEST1 |  | 1
TEST1 |  | 1
TEST1 |  | 1
TEST2 |  | 2
TEST3 |  | 3
TEST3 |  | 3
TEST4 |  | 4
TEST5 |  | 5
TEST5 |  | 5
TEST5 |  | 5
TEST6 |  | 6
TEST6 |  | 6
TEST6 |  | 6
TEST7 |  | 7
TEST7 |  | 7
TEST7 |  | 7
TEST8 |  | 8
TEST8 |  | 8
Spreadsheet: 679411d1590407828-index-and-match-formula-using-an-array-criteria-list-excel-help-example
Sheet: Family Tree

 |  | Criteria List A
 |  |  | 1 | 2 | 3 | 4 | 5
 |  | Global Owner | Samsung | Hitachi
 | Criteria List B
aaaaaaaaaaaaaaaaaaaaaaaa | Client | Global Owner |  | Domestic Owner | Exists in Family Tree
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa | Samsung A | Samsung |  | Samsung B | Exists (as exists in Criteria List A and B)
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa | Samsung B | Samsung |  | Samsung B | Exists (as exists in Criteria List A and B)
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa | Panasonic A | Panasonic |  | Panasonic A | Not Exists (as Panasonic not in Criteria List A as Global Owner )
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa | Hitachi A | Hitachi |  | Hitachi A | Exists (as exists in Criteria List A and B)
 | Hitachi B | Hitachi |  | Hitachi C | Doesn't Exist (as doesn't exist in Criteria List B as Client)
Spreadsheet: rick_buy__32933__TAB7_EES_ISDA
Sheet: Replacement Costs

POWER
Sum of Nominal Volume
Region_NM | LoadDefinition NM | 2001-12-01 00:00:00 | Grand Total
NE | East Peak | -16000
Average of Bid/Offer |  | Forward Date
Region_NM | LoadDefinition NM | 2001-12-01 00:00:00 | Grand Total
NE | East Peak | 34.2 | 34.2
Margin Calculation Detail:
NE | East Peak
Grand Total
Margin Requirement Per Month | 0.5
Cumulative Margin Required
Monthly Cost of Capital - NPW | 0.25
PV of Monthly Cost of Credit at T-Bill Rate | 0.03
Total Cost of Credit to NPW
GAS:
Sum of Nominal Vol |  | Forward Date
Deal Type | Delivery Index | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | Grand Total
Fixed | NYMEX | 0 | 200000 | 50000 | 300000 | 200000 | 100000 | 350000 | 50000 | 50000 | 50000 | 1400000
Fixed Total |  | 0 | 200000 | 50000 | 300000 | 200000 | 100000 | 350000 | 50000 | 50000 | 50000 | 1400000
Grand Total |  | 0 | 200000 | 50000 | 300000 | 200000 | 100000 | 350000 | 50000 | 50000 | 50000 | 1400000
 |  | Forward Date
Delivery Index | Buy | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 37500
NYMEX | 0 |  | 2.66 | 2.76 | 2.76 | 2.72 | 2.77 | 2.88 | 2.85 | 2.94 | 2.88
 | 1 |  | 2.680000000000005 | 2.78 | 2.78 | 2.74 | 2.79 | 2.9 | 2.87 | 2.96 | 2.9
Deal Type | Delivery Index
Fixed | NYMEX |  | 536000.000000001 | 139000 | 834000 | 548000 | 279000 | 1015000 | 143500 | 148000 | 145000 | 3787500
Fixed Total
Margin Requirement - Fixed NYMEX |  | 0.5 | 268000.0000000005 | 69500 | 417000 | 274000 | 139500 | 507500 | 71750 | 74000 | 72500
Cumulative Margin Required |  |  | 1893750 | 1625750 | 1556250 | 1139250 | 865250 | 725750 | 218250 | 146500 | 72500
Monthly Cost of Capital - NPW |  | 0.25 | 39453.12500000001 | 33869.79166666666 | 32421.875 | 23734.375 | 18026.04166666667 | 15119.79166666667 | 4546.875 | 3052.083333333333 | 1510.416666666667
PV of Monthly Cost of Credit at T-Bill Rate |  | 0.03 | 39453.12500000001 | 33785.32834580216 | 32260.37151510252 | 23557.25353192476 | 17846.90226901292 | 14932.20352382393 | 4479.264696095892 | 2999.202008623565 | 1480.545364406107
Total Cost of Credit to NPW |  | 170794.1962547919
 |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | TOTAL
Spreadsheet: 35080d1232583923-hiding-repetitive-numbers-sales-department
Sheet: Sheet1

 |  |  |  | Cumulative
Month |  | Bonus |  | Shortage |  | Payable
January |  | -367.42006 |  | -367.42006 |  | 0
February |  | 263.375 |  | -104.04506 |  | 159.32994
March |  | 200 |  | 95.95494000000002 |  | 295.95494
April |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
May |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
June |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
July |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
August |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
September |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
October |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
November |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
December |  | 0 |  | 95.95494000000002 |  | 95.95494000000002
 |  |  |  |  |  | 1318.879340000001 | Total YTD
Spreadsheet: sally_beck__35761__MgmtSum-Q1-0320
Sheet: GM-WklyChnge

ENRON NORTH AMERICA
1ST QUARTER 2000 DETAIL OF GROSS MARGIN
WEEKLY CHANGE
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR* | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
Weather
Emissions
Insurance Group
Executive Trading
Total Trading & Risk Management
East Midstream
West Midstream
Industrial Downstream - Paper
Industrial Downstream - Chemicals
Midstream IPP
Mexico
Executive Origination
Total Origination
Genco
Generation Investments
Gas Assets
Gas Assets - Trading
Total Assets
Principal Investing
Energy Investments
Investment Management
Restructuring
Canada - Investing
Total Investing
Commercial Transactions Group
Office of the Chairman
Other Interest Related Charges
Overview
Total
* Excludes Cap. Charge & Operating Costs
 |  |  |  | Deals Added:
 |  |  |  | Deals Changed: | Rollovers |  | Gas Assets | -200
 |  |  |  | Deals Removed:
 |  |  |  | Deals Completed: | Coral/TCPL |  | Canada | -400
Gas
Power
Genco
Drift
Financial
Emerging Businesses
Spreadsheet: 264633d1378924315-top-10-list-of-students-from-separate-worksheets-grade-6-marks-reyn_10-pt-oeldere2-
Sheet: Top 10

 |  | Top 10 Students
 |  | First | Last | Mark | Grade
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 776588d1649811315-seeking-help-with-validations-sample-workbook
Sheet: Pay Tab

Employee ID | Agent Name | Sick Hours Used | Vacation Days Used | Program | Dates | Notes
00010A | Freckleton, Nakeita
00028A | Strachan, [NAME]
00081A | Barnes, Jelissa
00094A | Brown, Kimone
00101A | Anguin, Latoya
00110A | Smikle, [NAME]
00148A | [NAME], [NAME]
01882A | [NAME],[NAME]
00165A | Parkinson,Tenesiah
00224A | Russell, [NAME]
00252A | Fuller, [NAME]
00256A | [NAME], [NAME]
01001A | [NAME], [NAME]
01149A | Hendriks, Celina
05384A | Clarke, [NAME]
01182A | [NAME], Aleisha
Spreadsheet: 136137d1326427571-readign-from-other-worksheets-multi-year-testing-data-sheets2
Sheet: student record

year | 2012 | previous year
ID/Name | 103
 |  | spelling | maths | reading
 | Current Year
 | Previous Year
 | Improvement
Spreadsheet: 138185d1327550016-calculating-probability-with-unknown-sample-mean-randomminoritycounter2
Sheet: Sheet1

7 |  | 7 | << Count of less than 8 |  |  | 0
21 |  |  |  |  | Number of Minorities>> | 1 | 1
19 |  |  |  |  |  | 2 | 13
17 |  | 1000 | <<Number of random tries |  |  | 3 | 42
15 |  |  |  |  |  | 4 | 79
26 |  |  | Fill in the number of random tries |  |  | 5 | 117
8 |  |  | and then run the |  |  | 6 | 168
5 |  |  | RunRandCount Macro |  |  | 7 | 156
3 |  |  |  |  |  | 8 | 174
4 |  |  |  |  |  | 9 | 102
19 |  |  |  |  |  | 10 | 80
6 |  |  |  |  |  | 11 | 41
8 |  |  |  |  |  | 12 | 14
18 |  |  |  |  |  | 13 | 8
20 |  |  |  |  |  | 14 | 4
14 |  |  |  |  |  | 15
28 |  |  |  |  |  | 16
24 |  |  |  |  |  | 17
23 |  |  |  |  |  | 18 | 1
16 |  |  |  |  |  | 19
22 |  |  |  |  |  | 20
1 |  |  |  |  |  | 21
11 |  |  |  |  |  | 22
24 |  |  |  |  |  | 23
14 |  |  |  |  |  | 24
8 |  |  |  |  |  | 25
16 |  |  |  |  |  | 26
7 |  |  |  |  |  | 27
 |  |  |  |  |  | 28
 |  |  | This method has no repeats |  |  |  | 1000
 |  |  | 1 | <<Count
 |  |  | It is done by sorting the list of |  |  | 0 | 98
20 | 0.5462386418699426 |  | numbers from 1 to 28 using |  |  | 1 | 318
23 | 0.6988199163335008 |  | the Rand() function in Col B |  |  | 2 | 355
27 | 0.457066398117022 |  | Then we count how many |  |  | 3 | 194
12 | 0.2169935702101068 |  | numbers in the first 7 are <8 |  |  | 4 | 33
5 | 0.04372071304267289 |  | The tally is to the right |  |  | 5 | 2
21 | 0.7887546327654141 |  |  |  |  | 6
22 | 0.4309521986616315 |  |  |  |  | 7
3 | 0.9459511707829771 |  |  |  |  | 8
18 | 0.7717493844593443 |  |  |  |  | 9
14 | 0.9434101273202957 |  |  |  |  | 10
13 | 0.6532638674757797 |  |  |  |  | 11
4 | 0.7270131427508719 |  |  |  |  | 12
16 | 0.6122075925566358 |  |  |  |  | 13
10 | 0.9121065627932984 |  |  |  |  | 14
15 | 0.4649738890539189 |  |  |  |  | 15
1 | 0.6927760282125998 |  |  |  |  | 16
11 | 0.1949130591448539 |  |  |  |  | 17
19 | 0.09395401104250334 |  |  |  |  | 18
28 | 0.1475586311317556 |  |  |  |  | 19
8 | 0.2824443587339684 |  |  |  |  | 20
7 | 0.8186200241706498 |  |  |  |  | 21
17 | 0.7487926929532654 |  |  |  |  | 22
6 | 0.8485668845601326 |  |  |  |  | 23
24 | 0.7467768559199883 |  |  |  |  | 24
26 | 0.9973018766276003 |  |  |  |  | 25
2 | 0.9951570518470163 |  |  |  |  | 26
9 | 0.348207939988711 |  |  |  |  | 27
25 | 0.9737929735569205 |  |  |  |  | 28
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: Lisas Dad

Lisas Dad
Month | Year | Paymet
2008-01-01 00:00:00 | 2008
2008-02-01 00:00:00 | 2008
2008-03-01 00:00:00 | 2008
2008-04-01 00:00:00 | 2008
2008-05-01 00:00:00 | 2008
2008-06-01 00:00:00 | 2008
2008-07-01 00:00:00 | 2008
2008-08-01 00:00:00 | 2008
2008-09-01 00:00:00 | 2008
2008-10-01 00:00:00 | 2008
2008-11-01 00:00:00 | 2008
2008-12-01 00:00:00 | 2008
2009-01-01 00:00:00 | 2009
2009-02-01 00:00:00 | 2009
2009-03-01 00:00:00 | 2009
2009-04-01 00:00:00 | 2009
2009-05-01 00:00:00 | 2009
2009-06-01 00:00:00 | 2009
2009-07-01 00:00:00 | 2009
2009-08-01 00:00:00 | 2009
2009-09-01 00:00:00 | 2009 | 370
2009-10-01 00:00:00 | 2009 | 100
2009-11-01 00:00:00 | 2009
2009-12-01 00:00:00 | 2009
2010-01-01 00:00:00 | 2010
2010-02-01 00:00:00 | 2010
2010-03-01 00:00:00 | 2010
2010-04-01 00:00:00 | 2010
2010-05-01 00:00:00 | 2010
2010-06-01 00:00:00 | 2010
2010-07-01 00:00:00 | 2010
2010-08-01 00:00:00 | 2010
2010-09-01 00:00:00 | 2010
2010-10-01 00:00:00 | 2010
2010-11-01 00:00:00 | 2010
2010-12-01 00:00:00 | 2010
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-01 00:00:00
2012-08-01 00:00:00
2012-09-01 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-01 00:00:00
Spreadsheet: 87771d1287621386-populating-data-from-one-table-to-another-excel-web
Sheet: Sheet1

Table 1: data
Dog | 1
 | 3
 | b
 | c
Cat | 1
 | 4
 | 5
 | 6
 | a
 | b
Man | 1
 | 2
 | 3
 | 4
 | 5
 | 6
Girl | a
 | c
 | b
Potato | 1
 | 5
 | 6
 | a
 | b
Table 2: requiring populating
 | 1 | 2 | 3 | 4 | 5 | 6 | a | b | c
Dog
Cat
Man
Girl
Potata
[NAME]
required outcome
 | 1 | 2 | 3 | 4 | 5 | 6 | a | b | c
Dog | yes |  | yes |  |  |  |  | yes | yes
Cat | yes |  |  | yes | yes | yes | yes | yes
Man | yes | yes | yes | yes | yes | yes
Girl | yes | yes | yes
Potata | yes |  |  |  | yes | yes | yes | yes
[NAME]