tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 864484d1711637394-merging-multiple-tables-based-on-unique-id-merging-multiple-tables-based-on-unique-id-jt
Sheet: Summary

Sr. No. | Description | X1 | X2 | X3 | X4 | X5 | X6 |  | Sr. No. | Description | X1 | X2 | X3 | X4 | X5 | X6 | Total
1 | AAA | 1 | 1 | 1 | 3 | 1 | 1 |  | 1 | AAA | 1 | 1 | 1 | 3 | 1 | 1 | 8
2 | BBB | 2 | 2 | 2 | 2 | 2 | 2 |  | 2 | BBB | 2 | 2 | 2 | 2 | 2 | 2 | 12
3 | CCC | 1 | 1 | 3 | 1 | 1 | 1 |  | 3 | CCC | 1 | 1 | 3 | 1 | 1 | 1 | 8
4 | DDD | 3 | 0 | 4 | 1 | 3 | 2 |  | 4 | DDD | 3 | 0 | 4 | 1 | 3 | 2 | 13
5 | EEE | 1 | 2 | 3 | 2 | 0 | 1 |  | 5 | EEE | 1 | 2 | 3 | 2 | 0 | 1 | 9
6 | FFF | 0 | 1 | 2 | 1 | 1 | 3 |  | 6 | FFF | 0 | 1 | 2 | 1 | 1 | 3 | 8
7 | GGG | 2 | 3 | 1 | 3 | 2 | 2 |  | 7 | GGG | 2 | 3 | 1 | 3 | 2 | 2 | 13
8 | HHH | 1 | 1 | 4 | 2 | 4 | 1 |  | 8 | HHH | 1 | 1 | 4 | 2 | 4 | 1 | 13
9 | III | 0 | 4 | 1 | 1 | 2 | 1 |  | 9 | III | 0 | 4 | 1 | 1 | 2 | 1 | 9
10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2 |  | 10 | JJJ | 1 | 2 | 2 | 0 | 1 | 2 | 8
11 | KKK | 2 | 1 | 2 | 4 | 0 | 1 |  | 11 | KKK | 2 | 1 | 2 | 4 | 0 | 1 | 10
12 | LLL | 1 | 0 | 0 | 2 | 1 | 0 |  | 12 | LLL | 1 | 0 | 0 | 2 | 1 | 0 | 4
Merge Tables
let
Source = Excel.CurrentWorkbook(),
#"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "t_")),
#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content"}),
Custom1 = Table.Combine(#"Removed Other Columns"[Content]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Custom1, {"Sr. No.", "Description"}, "Attribute", "Value"),
#"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Sr. No.", Int64.Type}, {"Description", type text}, {"Attribute", type text}, {"Value", type number}}),
#"Pivoted Column" = Table.Pivot(#"Changed Type", [NAME].Distinct(#"Changed Type"[Attribute]), "Attribute", "Value", List.Sum)
in
#"Pivoted Column"
Total Rows
let
Source = #"Merge Tables",
#"Removed Columns" = Table.RemoveColumns(Source,{"Sr. No.", "Description"}),
Custom1 = Table.AddColumn(#"Removed Columns", "Total", each List.Sum(Record.ToList(_)), type number),
#"Removed Other Columns" = Table.SelectColumns(Custom1,{"Total"}),
#"Added Index" = Table.AddIndexColumn(#"Removed Other Columns", "Index", 1, 1, Int64.Type),
#"Reordered Columns" = Table.ReorderColumns(#"Added Index",{"Index", "Total"})
in
#"Reordered Columns"
Merge Queries
let
Source = Table.NestedJoin(#"Merge Tables", {"Sr. No."}, #"Total Rows", {"Index"}, "Query2", JoinKind.LeftOuter),
#"Expanded Query2" = Table.ExpandTableColumn(Source, "Query2", {"Total"}, {"Total"})
in
#"Expanded Query2"
Spreadsheet: 133500d1324424418-excel-2007-menu-greyed-out-productdb
Sheet: 05 Spot Lights

EAD SKU # | [NAME], V AC | Power, Watts | [NAME] | Items/cs | Weight, kg/Case | Cost Price, $ | Sell Price, Case | Image | Source
EA0501 | 95 - 295 | 3 | 270 | 60 | 5 | 4.7 |  |  | 3
EA0502 | 95 - 295 | 5 | 380 | 60 | 6.4 | 9 |  |  | 3
EA0503 | 95 - 295 | 7 | 520 | 30 | 11.6 | 12 |  |  | 3
EA0504 | 95 - 295 | 9 | 835 | 24 | 20.6 | 17.5 |  |  | 3
EA0505 | 95 - 295 | 12 | 1050 | 24 | 21 | 21 |  |  | 3
EA0506 | 95 - 295 | 15 | 1390 | 24 | 26 | 24 |  |  | 3
EA0507 | 95 - 295 | 22 | 1800 | 12 | 38 | 42 |  |  | 3
 |  |  |  |  |  |  |  |  | 3
Spreadsheet: 158798d1338397162-countif-with-autofilter-0f
Sheet: Φύλλο1

 | t |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a | r | n | 3
 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g | 100 | Right
 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f | 200 | Left
 | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d | 300 | Right
 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e | 400 | Left
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e | 500 | Right
 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tty | 600 | Left
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | 700 | Right
 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ed | 800 | Left
 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yu | 900 | Right
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | 1000 | Left
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | 1100 | Right
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f
Spreadsheet: 1a0d3581-b92f-4dd5-91e2-33a655de267d
Sheet: Sheet1

Forcible Sex Offense Victims | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Offense Type
by Type of Injury, 20111
Type of Injury | Offense Type
 | Forcible Rape | Forcible Sodomy | Sexual Assault with an  Object | Forcible Fondling
Murder and Nonnegligent Manslaughter2 | 3 | 3 | 0 | 1
Apparent Broken Bones | 58 | 9 | 2 | 17
Possible Internal Injury | 1249 | 281 | 138 | 260
Severe Laceration | 98 | 12 | 17 | 12
Apparent Minor Injury | 5821 | 1020 | 514 | 2305
Other Major Injury | 458 | 100 | 55 | 175
Loss of Teeth | 14 | 3 | 1 | 3
Unconsciousness | 188 | 21 | 13 | 23
 | 19388 | 5819 | 2239 | 29385
1This table does not include totals because in the table a victim can be counted more than once since he/she can be connected to up to ten offense types per incident and up to five types of injury.
2Murder and Nonnegligent Manslaughter is not typically included as a type of injury; it is included in this table for informational purposes.
Note:  Type of Injury data are not collected for nonforcible sex offenses.
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T54

الجدول 54: مواليد االذكورالأحياء المسجلة، 2000-2012
Table 54: Registered male live births, 2000-2012
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | البلد
Bahrain | 7106 | 6930 | 6953 | 7304 | 7352 | 7767 | 7647 | 8185 | 8677 | 9090 | … | … | … | البحرين
Egypt | 904756 | 894950 | 905553 | 900098 | 902159 | 919137 | 951085 | 998409 | 1055046 | 1147592 | 1159528 | 1252319 | 1 343 402* | مصر
Iraq | 255538 | 365562 | 381411 | 355220 | 429354 | 460165 | 459938 | 443556 | 500163 | 541505 | 545775 | … | … | العراق
Jordan | 64645 | 73200 | 75146 | 75553 | 76478 | 77384 | 83099 | 94333 | 92536 | 91788 | 94141 | 91655 | 91124 | الأردن
Kuwait | 21332 | 21026 | 22134 | 22413 | 24235 | 25922 | 26923 | 27458 | 27913 | 28676 | 29386 | 29556 | … | الكويت
Lebanon | 44796 | 42690 | 38865 | 36533 | 37697 | 37498 | 36992 | 40991 | 42799 | 46100 | 48364 | 50680 | 48270 | لبنان
Libya | … | … | … | … | 61739 | 62072 | 65902 | 65975 | 68018 | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | … | … | … | … | … | … | … | … | [NAME]
Oman | ... | ... | ... | ... | ... | ... | 25013 | 26559 | 29937 | 32911 | 32905 | 34558 | … | عمان
Palestine** | 54418 | 53904 | 55652 | 56007 | 59431 | 58681 | 58745 | 61217 | 36030 | 34968 | 35971 | 33085 | ... | فلسطين**
Qatar | 5738 | 6186 | 6261 | 6564 | 6802 | 6839 | 7196 | 8056 | 8703 | 9401 | 9926 | 10487 | … | قطر
Saudi Arabia | 277564 | 281610 | 285716 | 289882 | 294108 | 298396 | 301797 | 304807 | 306357 | 308315 | 309578 | 310649 | 311275 | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | 144502 | 237773 | 221053 | … | … | … | السودان
Syrian Arab Republic | 222248 | 227779 | 229759 | 256468 | 249796 | 266989 | 276757 | 308192 | 347972 | 343264 | 369858 | … | … | الجمهورية العربية السورية
Tunis | … | … | … | … | … | … | … | … | 87477 | 88375 | 94138 | 96775 | … | تونس
United Arab Emirates | 27640 | 28618 | 29508 | 31241 | 32179 | 33145 | 32050 | 34470 | 35264 | 39155 | 40652 | 42743 | … | الإمارات العربية المتحدة
Yemen | 164268 | 164201 | 110706 | 72326 | 87471 | 87602 | 156492 | 144546 | 172028 | 150807 | 178997 | 132810 | … | اليمن
Total |  |  |  |  |  |  |  |  |  |  |  |  |  | المجموع
* preliminary data |  |  |  |  |  |  |  |  |  |  |  |  |  | * بيانات أولية
** data from 2008 and on represent The West Bank only |  |  |  |  |  |  |  |  |  |  |  |  |  | ** بيانات منذ 2008،  وما يلي تمثّل الضفة  الغربية فقط
Spreadsheet: 80648d1280862546-football-league-predictor-workbook-football-standing-predictions
Sheet: Actual

Team | Rank
Arsenal | 14
[NAME] | 17
Birmingham | 18
[NAME] | 20
Blackpool | 16
[NAME] | 3
Chelsea | 8
Everton | 11
Fulham | 1
Liverpool | 4
Man City | 7
Man Utd | 6
Newcastle | 13
Stoke | 19
Sunderland | 10
Tottenham | 5
West Brom | 9
West Ham | 12
[NAME] | 2
Wolverhampton | 15
Spreadsheet: 67458d1268083263-multiple-criteria-for-sumproduct-example
Sheet: Sheet1

Bucket Type | PM | Schedule Type |  |  |  | Type | Totals
Base | N/A | DETAIL |  |  |  | DETAIL | 1
Base | Blank | FUNCT |  |  |  | FUNCT | 1
Transco | [NAME] | DETAIL
Transco | [NAME] | DETAIL
Path | [NAME] | BASIC
Base | N/A | BASIC
Spreadsheet: darrell_schoolcraft__7762__imbalsumm0106
Sheet: SoCal

 | 10487 |  | 56697
Day | Scheduled | Measured | Scheduled | Measured
1 | 782950 | 779895 | 30000 | 29986
2 | 812800 | 819915 | 30000 | 30022
3 | 804876 | 803751 |  | 698
4 | 812800 | 808945
5 | 810400 | 807889
6 | 813600 | 791590 | 20000 | 21853
7 | 813594 | 805336 |  | 388
8 | 767678 | 779447 | 20000 | 20777
9 | 591120 | 619044 | 50000 | 48771
10 | 591120 | 599411 | 20000 | 20881
11 | 803925 | 778362 | 20000 | 19954
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  | -21565
2001-06-11 00:00:00
Spreadsheet: 1ea10eb1-afbc-4847-ab24-7724c5431f02
Sheet: Sheet1

NAME | 2005-01-27 00:00:00 | 2005-02-01 00:00:00
Aretxabaleta, Alfredo | x | x
Bollag, Sascha
[NAME], [NAME] | x | x
Chapman, [NAME] | x | x
[NAME], [NAME]
Deeb-Sossa, Natalia | x
[NAME], [NAME]
Dunbar, [NAME]
Ezzell, [NAME] | x | x
[NAME], [NAME] | x
Hutton, [NAME] | x
[NAME], [NAME] | x
Lassiter, Stephen | x
Laws, [NAME]
[NAME], Christina | x | x
Lewis, [NAME] | x | x
Martin, [NAME] | x
Murdock, [NAME]
[NAME], [NAME]
Prear, [NAME]
[NAME], Fatimah
Tajik, Mansoureh | x | x
[NAME], [NAME] | x | x
West, Julius | x | x
West, Lily | x | x
Wing, [NAME] | x
Spreadsheet: 876165d1722854978-live-date-highlights-when-past-due-date-concrete-cube-testing
Sheet: C3037

CONCRETE CUBE RESULTS
 |  |  |  |  |  |  |  |  |  | Acceptable mean result |  |  |  | = |  | N/sq.mm | [BS 5328 cl. 3.16.2 b] |  |  |  |  |  |  |  |  |  |  |  | grade strength |  |  | 37 |  | N/mm2
 |  |  |  | N/sq.mm |  |  |  |  |  | Acceptable mean of four |  |  |  | = |  | N/sq.mm | [BS 5328 cl. 3.16.2 a] |  |  |  | [except first three results] |  |  |  |  |  |  |  | compliance specification |  |  | 37 |  | N/mm2
 |  |  |  |  |  | 7 day test |  |  |  |  | 14 day test |  |  |  |  | 28 day test |  |  |  |  | Spare |  |  |  |  |  |  | 7-14 day strength gain |  | 14-28 day strength gain
Date of casting | Section | Bay No. | Location | RMC Ticket No. | Slump [NAME] | cube no. | density | Result due | Age at testing | strength | cube no. | density | Result due | Age at testing | strength | cube no. | density | Result due | Age at testing | strength | cube no. | density | Age at testing | strength | 28 day 'result' | 28 day strength | 28 day Rolling Mean | N/sq.mm | ratio | N/sq.mm | ratio | Rolling mean compliant?             Cl. 3.16.2 | Individual results compliant? Cl 3.16.2 | 28 day result valid?           Cl. 3.61.1 | NOTES
2024-07-02 00:00:00 |  |  | GIS RING BEAM FOUNDATION |  | 140 | GIS 1 | 2392 |  | 7 | 26 | GIS 2 | 2404 |  | 14 | 38.3 | GIS 3 |  |  |  |  | GIS 4 |  |  |  |  |  | not applicable |  |  |  |  | not applicable
2024-07-02 00:00:00 |  |  | GIS RING BEAM FOUNDATION |  | 120 | GIS 5 | 2416 |  | 7 | 32.2 | GIS 6 | 2412 |  | 14 | 37.3 | GIS 7 |  |  |  |  | GIS 8
2024-07-02 00:00:00 |  |  | GIS RING BEAM FOUNDATION |  | 130 | GIS 9 | 2392 |  | 7 | 28.4 | GIS 10 | 2394 |  | 14 | 36.7 | GIS 11 |  |  |  |  | GIS 12
2024-07-15 00:00:00 |  |  | GIS LOWER WALLS POUR 1 |  | 140 | GIS 13 | 2436 |  | 7 | 21.6 | GIS 14 |  |  |  |  | GIS 15 |  |  |  |  | GIS 16
2024-07-19 00:00:00 |  |  | SYNCON PEDESTAL POUR 1 |  | 170 | SCP17 |  |  |  |  | SCP18 |  |  |  |  | SCP19 |  |  |  |  | SCP20
2024-07-19 00:00:00 |  |  | SYNCON PEDESTAL POUR 1 |  | 151 | SCP21 |  |  |  |  | SCP22 |  |  |  |  | SCP23 |  |  |  |  | SCP24
2024-07-19 00:00:00 |  |  | SYNCON PEDESTAL POUR 1 |  | 157 | SCP25 |  |  |  |  | SCP26 |  |  |  |  | SCP27 |  |  |  |  | SCP28
2024-07-19 00:00:00 |  |  | SYNCON PEDESTAL POUR 1 |  | 170 | SCP29 |  |  |  |  | SCP30 |  |  |  |  | SCP31 |  |  |  |  | SCP32
2024-07-23 00:00:00 |  |  | GIS LOWER WALLS POUR 2 |  | 140 | GIS 33 |  |  |  |  | GIS 34 |  |  |  |  | GIS 35 |  |  |  |  | GIS 36
2024-07-29 00:00:00 |  |  | GIS UPPER WALLS POUR 1 |  | 135 | GIS 37 |  |  |  |  | GIS 38 |  |  |  |  | GIS 39 |  |  |  |  | GIS 40
2024-07-30 00:00:00 |  |  | GIS UPPER WALLS POUR 2 |  | 150 | GIS 41 |  |  |  |  | GIS 42 |  |  |  |  | GIS 43 |  |  |  |  | GIS 44
 |  |  | GIS UPPER WALLS POUR 3 |  |  | GIS 45 |  |  |  |  | GIS 46 |  |  |  |  | GIS 47 |  |  |  |  | GIS 48
Spreadsheet: 691524d1597743579-problem-with-excel-or-me-book1
Sheet: Transaction Inventory

 | DAILY STOCK REGISTER
 | Date | Item | Unit | Qty Brought Forward | In/Out | Quantity In/Out | Current Quantity | Team | Project | Driver | Comments
 | 2020-08-18 00:00:00 | [NAME] |  |  | In | 4 |  | [NAME] | [NAME] | Deon
 | 2020-08-19 00:00:00 | [NAME] |  |  | In | 1 |  | [NAME] | [NAME] | Deon
 | 2020-08-20 00:00:00 | [NAME] |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-21 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-22 00:00:00 |  |  |  |  | 10 |  | [NAME] | [NAME] | Deon
 | 2020-08-23 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-24 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-25 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-26 00:00:00 |  |  |  |  | 5 |  | [NAME] | [NAME] | Deon
 | 2020-08-27 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-28 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-29 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-30 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 | 2020-08-31 00:00:00 |  |  |  |  |  |  | [NAME] | [NAME] | Deon
 |  | [NAME]
Spreadsheet: monika_causholli__28142__EIM- Steel Pricing Update101601
Sheet: Glossary of Terms

 | ENRON INDUSTRIAL MARKETS - EUROPE
 | Steel Pricing Glossary of Terms
 | Physical Steel Products |  |  |  |  |  |  |  |  |  | Financial Steel Products
 |  |  |  |  |  |  |  |  |  | Cash Price
 |  |  |  |  |  |  |  |  |  | Price today for immediate delivery
 |  |  |  |  |  |  |  |  |  | 6 Month Term
 |  |  |  |  |  |  |  |  |  | Six months inclusive from prompt month
 |  |  |  |  |  |  |  |  |  | Forward Price
 |  |  |  |  |  |  |  |  |  | Price for a one time delivery at a future date
 |  |  |  |  |  |  |  |  |  | For example=  268
 |  |  |  |  |  |  |  |  |  | Enron will pay $268 per MT to buy
 |  |  |  |  |  |  |  |  |  | 2500 MT of HRC for delivery in 1Q 2002
 |  |  |  |  |  |  |  | Swap
 |  |  |  |  |  |  |  | A financial arrangement between two parties where they agree to exchange an index (floating) payment for a fixed payment over a pre-determined time period
 |  |  |  |  |  |  |  |  | Settlement is financial against the CRU index
 |  |  |  |  |  |  |  |  | When netted with your physical purchases/sales, these financial contracts have the effect of locking in a fixed price
 |  |  |  |  |  |  |  | There is NO exchange of physical steel
 |  |  |  |  |  |  |  | There is NO fee or premium for a swap
 |  |  |  |  |  |  |  | Can be tailored your requirements i.e.  product,price,volume,currency
 | Please call us with any questions on the Forest Products Line +44 (0) 20 77837747
 | Please visit www.EnronOnline.com or www.Clickpaper.com for transactable prices and volumes
Spreadsheet: chris_stokley__3837__DB Development
Sheet: Development

Settlement Analysis Database Development
Database purpose
To create an analysis and reporting tool that compares EPMI payments to Settlement Entities with EPMI collections from Customers
as well as comparing Estimates with Actualized payments and invoices.
[NAME]
Transaction | Settlement | Market | Settlement | Accounting | Payment/ | Dollar | Revenue/ | Transaction
Date | Entity | Counterparties | Type | Date | Invoice Date | Amount | Expense | Type
Definitions
Date of when | At time of | Internal and | A distinct indicator | For a | Depending on | The dollar | A distinct key | A distinct key
contract was | development | external | of where a contract | settlement | whether the | amount | that will allow | that will allow a
entered by EPMI | the SEs are | customers that | is in the settlement | type, the date | contract | reflective of | sorting on | sort on whether
and either SE or | ISO and [NAME], | enter into | process. | that this | dollars are | the | whether the | a transaction is
MC. | this is the | agreements | E=Monthly Estimate | occurred. | settled to the | Settlement | discrete | Accounting or
 | exchange | with EPMI for | A=Monthly Preliminary |  | SE or MC, | type for the | transaction is | Physical.
 | market for | various | M=Monthly Final |  | this is the | discrete | Revenue or | A=Accounting is
 | transactions. | capacity | O=Other Form of |  | date of either | record. | Expense to | adjustments or
 |  | requirements | Estimates |  | payment to |  | EPMI | changes that
 |  |  |  |  | the SE or |  |  | reflect EPMI's
 |  |  |  |  | Invoice to MC |  |  | transaction
 |  |  |  |  |  |  |  | records only.
 |  |  |  |  |  |  |  | P= Physical
 |  |  |  |  |  |  |  | represents and
 |  |  |  |  |  |  |  | interaction with
 |  |  |  |  |  |  |  | a party outside
 |  |  |  |  |  |  |  | of EPMI,
 |  |  |  |  |  |  |  | Payment from
 |  |  |  |  |  |  |  | EP
Data Source
Transaction tables | Transaction tables | Transaction tables | Transaction tables | Transaction tables | Transaction tables | Transaction tables | Logic | Logic
Spreadsheet: 187585d1350511706-weighting-annual-returns-when-denominator-changes-compound-returns
Sheet: Sheet1

Distributed Cash / Fund VI Equity
Annualized Distributed Cash / Fund VI Equity
Distributions by Year | 0 | 2500000 | 3000000 | 0 | 16597345 | 14403293.46376838 | 35069548.63390402 | 93481849.14333723 | 281079166.1673436
Cumulative | 0 | 2500000 | 5500000 | 5500000 | 22097345 | 36500638.46376838 | 71570187.0976724 | 165052036.2410097 | 446131202.4083532
Contributions by Year | 48000000 | 31916194.45 | 44647334.45 | 19240000 | 56598695.5083532 | 0 | 0 | 0 | 0
Contributions Outstanding @ Year-End | 48000000 | 79916194.45 | 124563528.9 | 143803528.9 | 200402224.4083532 | 188002224.4083532 | 188002224.4083532 | 188002224.4083532 | 126202224.3983532
You'll notice that cell J2 is a compounded average return of the Cumulative distributions divided by the equity outstanding in that year only.
 | Calculated | File | Difference
But that's not the weighted return for the equity outstanding over the various years.  How can I calculate that?  Sumproduct doesn't seem to work because of the outsized returns in the final year.
 |  | Sumproduct formula
Any suggestions?  TIA.
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 0002
Regions | Consolidated Flash | DPR vs. Consol. [NAME] | DPR | Adj. To NGPL | Revised NGPL | Actuals | [NAME]
Central
Sithe
Aruba
Northeast | 0 |  | 0 |  | 0 | 0
East- EGM
East-LRC
FT-East
Texas-EGM
Texas-HPLR
Texas-HPLC
FT-SouthTexas
West
Denver
FT - Denver
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
 |  |  |  |  |  |  | 0
Spreadsheet: 674589d1587931449-concatenate-cells-using-a-varying-identifier-in-a-different-field-forumsample
Sheet: Forum Post

Last Name | First Name | Address |  |  |  | City | Zip (RA) | State (RA)
SHIFFIS | RUSTY | 10262   FARM ROAD 2240 |  |  |  | WALTON | 78000 | IL
JILSON | VALERIE | 1035   WASHBURN PRAIRIE RD |  |  |  | WALTON | 78000 | IL
SHRUCK | MEGAN | 106   [NAME] |  |  |  | WALTON | 78000 | IL
BEANS | CONNIE | 107  W PINEVILLE RD |  |  |  | WALTON | 78000 | IL
LINDE | [NAME] | 1106     2ND ST |  |  |  | WALTON | 78000 | IL
LINDE | JANIS | 1106     2ND ST |  |  |  | WALTON | 78000 | IL
WENDRIX | [NAME] | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX | MELISSA | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX | DORTHY | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX | JOHNIE | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
SLACK-WENDRIX | LOUISE | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
BARNER | GREGORY | 128  N OLD WIRE RD |  |  |  | WALTON | 78000 | IL
STEPHENSON | CONNIE | 1305   FARM RD 2272 |  |  |  | WALTON | 78000 | IL
STEPHENSON | WILLIS | 1305   FARM RD 2272 |  |  |  | WALTON | 78000 | IL
RESULTS NEEDED
Last Name | First Name | Address |  |  |  | City | Zip (RA) | State (RA)
SHIFFIS | RUSTY | 10262   FARM ROAD 2240 |  |  |  | WALTON | 78000 | IL
JILSON | VALERIE | 1035   WASHBURN PRAIRIE RD |  |  |  | WALTON | 78000 | IL
SHRUCK | MEGAN | 106   [NAME] |  |  |  | WALTON | 78000 | IL
BEANS | CONNIE | 107  W PINEVILLE RD |  |  |  | WALTON | 78000 | IL
LINDE | GERALD & JANIS | 1106     2ND ST |  |  |  | WALTON | 78000 | IL
WENDRIX | JAMES, MELLISSA & DORTHY | 1215   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
WENDRIX | JOHNIE | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
SLACK-WENDRIX | LOUISE | 1244   STATE HWY 90 |  |  |  | WALTON | 78000 | IL
BARNER | GREGORY | 128  N OLD WIRE RD |  |  |  | WALTON | 78000 | IL
STEPHENSON | CONNIE & WILLIS | 1305   FARM RD 2272 |  |  |  | WALTON | 78000 | IL
Spreadsheet: d538f1aa-ec6d-478a-bb24-57110a52c97a
Sheet: Sheet1

Permit | Owner | Facility | County | Region | Assigned | Type | Class | Applied | Drafted | Noticed | Pre? | Comments
NC0089184 | Bay River MSD | River Dunes site | Pamlico | Washington | tom.belnick | Municipal, < 1 MGD | Minor | 2012-05-07 00:00:00
NC0089290 | Town of Mocksville | [NAME] | Davie | Winston-Salem | jim.mckay | Water Treatment Plant | Minor | 2012-11-21 00:00:00 | 2013-08-21 00:00:00 | 2013-09-11 00:00:00
NC0083984 | Town of Grover | Grover Industries WWTP | Cleveland | Mooresville | jackie.nowell | Municipal, < 1 MGD | Minor | 2013-03-05 00:00:00 |  |  |  | assigned to [NAME] on 6/6/2013
NC0089338 | Sunburst Trout Company | Sunburst Trout Company | Haywood | Asheville | [NAME] | Industrial Process & Commercial | Minor | 2013-03-06 00:00:00 |  |  |  | trout farm with fish processing on-site
NC0089389 | Town of Jonesville | Jonesville WTP | Yadkin | Winston-Salem | bob.sledge | Water Treatment Plant | Minor | 2013-03-18 00:00:00 |  |  |  | assigned to [NAME] on 6/13/2013
NC0089435 | Martin County Regional Water and Sewer Authority | Martin County WTP | Martin | Washington | [NAME] | Water Treatment Plant | Minor | 2013-06-18 00:00:00
NC0089451 | Addis Cates Company | former Cates Brinery | Robeson | Fayetteville | [NAME] | Groundwater Remediation | Minor | 2013-08-06 00:00:00
NC0089460 | Craven County | Craven County WTP | Craven | Washington | julie.grzyb | Water Treatment Plant | MAJOR | 2013-08-19 00:00:00
Spreadsheet: chris_germany__1679__Pipeline Capacity Timeline 
Sheet: Sheet2

Columbia Gulf | done
Columbia Gas | done
Texas Eastern | done
Tennessee | done
Texas Gas | done
Florida | [NAME]
Transco | done
Sonat | done
CNG | done
[NAME] | [NAME]
Spreadsheet: cc6cb0c0-2bd8-4786-a1a6-30a28ccdb5f7
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
[NAME] | Test | [NAME] | Id, Histoplasma/Blastomyces PCR | Id, Histoplasma/Blastomyces PCR |  |  |  |  |  |  | **For billing purposes only |  |  |  |  |  |  | 2 | 87150 |  |  |  |  | Rochester
60214 | Test | 60214 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 87150 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | See instructions