tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676374d1588777594-excel-road-construction-control-by-colored-stages-real-world-problem-roadconstructioncontroltablebystages
Sheet: Sheet1

 |  |  |  | Stations or Chainage
 | Date | Road # | Stage | From | To | Stage Completion |  | Stage | Description |  | Road # | Length
 | 2020-04-12 00:00:00 | 57 | 1 | 0 | 300 |  |  | 1 | Excavation |  | 50 | 500
 | 2020-04-12 00:00:00 | 57 | 2 | 0 | 200 |  |  | 2 | Soil Mixing |  | 51 | 41
 | 2020-04-13 00:00:00 | 57 | 3 | 100 | 200 |  |  | 3 | Soil Compaction |  | 52 | 43
 | 2020-04-14 00:00:00 | 57 | 4 | 100 | 170 |  |  | 4 | Ready to be Approved |  | 53 | 44
 | 2020-04-14 00:00:00 | 54 | 1 | 0 | 220 |  |  | 5 | Approved |  | 54 | 220
 | 2020-04-14 00:00:00 | 54 | 2 | 220 | 200 |  |  |  |  |  | 56 | 600
 | 2020-04-15 00:00:00 | 54 | 2 | 200 | 50 |  |  |  |  |  | 57 | 400
 |  |  |  |  |  |  |  |  |  |  | 58 | 200
 |  |  |  |  |  |  |  |  |  |  | 59 | 70
 |  |  |  |  |  |  |  |  |  |  | 60 | 100
 |  |  |  |  |  |  |  |  |  |  | 62 | 130
 |  |  |  |  |  |  |  |  |  |  | 63 | 100
 |  |  |  |  |  |  |  |  |  |  | 64 | 105
 |  |  |  |  |  |  |  |  |  |  | 68 | 220
 |  |  |  |  |  |  |  |  |  |  | 69 | 70
Spreadsheet: eb5c4975-2d08-4c41-97e5-f87b20376745
Sheet: Sheet1

State Representative (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 5/25/2013 9:12:16 AM
Precincts Reporting: 567/567 - Total Ballots Cast: 220479
2006 General Election - OFFICIAL RESULTS
Results provided by the Office of North Dakota Secretary of State | Darrell Nottestad | [NAME] | [NAME] | [NAME] | TOTALS
District 43 | 1592 | 1560 | 1558 | 2027 | 6737
TOTAL | 1592 | 1560 | 1558 | 2027 | 6737
Spreadsheet: 798256d1664382702-find-last-occurrence-of-value-across-two-columns-and-return-adjacent-value-sample-hd
Sheet: Sheet1

Year | Home Team | Away Team | Home Team Score Pre | Away Team Score Pre | Winning Team | Home Team | Home Team Score Post | Away Team | Away Team Score Post | HD | HD
2021 | SS | BH | 1st | 1st | SS |  | 105 |  | 110 |  |  | <-- no previous values of team so input value of '1st'
2021 | MS | ST | 1st | 1st | ST |  | 112 |  | 101 |  |  | <-- no previous values of team so input value of '1st'
2021 | AS | MR | 1st | 1st | AS |  | 95 |  | 112 |  |  | <-- no previous values of team so input value of '1st'
2021 | PS | HH | 1st | 1st | HH |  | 131 |  | 117 |  |  | <-- no previous values of team so input value of '1st'
2021 | BH | MS |  |  | MS |  | 117 |  | 121 |  |  | <--- team BH last occurrence in cell C2 so return value from J2 in D6 | <--- team MS last occurrence in cell B3 so return value from H3 in E6
2021 | HH | SS |  |  | HH |  | 145 |  | 101
2021 | MR | PS |  |  | MT | MR | 110 | PS | 45
2021 | ST | AS |  |  | ST | ST | 142 | AS | 69
2021 | SS | MS |  |  | MS | SS | 132 | MS | 108
2021 | AS | HH |  |  | AS | AS | 147 | HH | 117
2021 | PS | BH |  |  | PS | PS | 101 | BH | 154
2021 | ST | MR |  |  | MR | ST | 96 | MR | 164
2022 | SS | ST | 1st | 1st | SS | SS | 105 | ST | 110 |  |  | <--- year changes in this row
2022 | PS | AS | 1st | 1st | AS | PS | 99 | AS | 108
2022 | HH | MS | 1st | 1st | HH | HH | 114 | MS | 121
2022 | AS | SS |  |  | SS | AS | 110 | SS | 120
Spreadsheet: 167540d1342020867-excel-2003-tranposing-and-summing-cells-by-month-name-and-changing-name-formatting-excel-cell-transpose-and-name-change
Sheet: What it looks like

Name | Time Type | JAN 2011 | FEB 2011 | MAR 2011 | APR 2011 | MAY 2011 | JUN 2011 | JUL 2011 | AUG 2011 | SEP 2011 | OCT 2011 | NOV 2011 | DEC 2011 | YTD
[NAME] | Regular Hrs | 60 | 93.9 | 137.9 | 104 | 111.8 | 123 | 100.9 | 119 | 88 | 108 | 118 | 105.9 | 1270.4
[NAME] | [NAME] | 0.6 | 0.5 | 12 | 9.3 | 1.1 | 0.9 | 0.6 | 10.8 | 4.3 | 4.5 | 10.5 | 0.3 | 55.4
[NAME] | 2xOT Hrs | 18 | 32 | 44 | 36 | 36 | 35 | 31 | 38 | 26 | 36 | 34 | 32 | 398
[NAME] | Regular Hrs | 51 | 64 | 58 | 71.6 | 75.2 | 64.1 | 43 | 72.7 | 57 | 65.4 | 61.3 | 54 | 737.3
[NAME] | Regular Hrs | 133.7 | 123 | 137.7 | 140 | 152 | 124 | 85 | 177 | 120 | 104 |  |  | 1296.4
[NAME] | [NAME] | 1.8 | 1.5 | 7.5 | 0.1 | 0.3 | 0.3 | 0.3 | 14.3 | 9.9 | 4.2 |  |  | 40.2
[NAME] | 1.5xOT Hrs |  |  |  |  |  |  |  | 9.6 |  |  |  |  | 9.6
[NAME] | Regular Hrs | 149.5 | 134 | 170 | 144 | 130 | 157 | 101 | 164 | 21 |  | 125 | 160.7 | 1456.2
[NAME] | [NAME] | 17 | 26.5 | 36.9 | 24.4 | 10.2 | 0.5 | 4 | 22.2 | 0.2 |  | 24.4 | 30.2 | 196.5
[NAME] | 1.5xOT Hrs | 8 |  |  |  |  |  | 8 | 8 |  |  | 7.9 | 15.4 | 47.3
[NAME] | 2xOT Hrs | 2 |  |  |  |  |  | 6 |  |  |  |  |  | 8
Jamal C Crawford JR | Regular Hrs | 63.7 | 44.9 | 52 | 15 | 32 | 36.5 | 34 | 41.5 | 37 | 49 | 52 | 66 | 523.6
Jamal C Crawford JR | [NAME] |  |  |  |  |  |  | 1 | 2 |  | 1 |  |  | 4
Jamal C Crawford JR | 1.5xOT Hrs |  |  |  |  |  |  | 8 |  |  |  |  |  | 8
Jamal C Crawford JR | 2xOT Hrs | 96 | 70 | 75 | 15 | 41 | 56 | 45 | 66 | 51 | 70 | 94 | 85 | 764
[NAME] | Regular Hrs | 132 | 108 | 104 | 106 | 100.5 | 133.8 | 119.9 | 138 | 102 | 123 | 114 |  | 1281.2
[NAME] | [NAME] |  | 0.2 | 7.2 | 35 | 6 | 5.7 | 8 | 37 | 26.5 | 7.5 | 15.2 |  | 148.3
[NAME] | 1.5xOT Hrs |  |  |  |  |  |  |  | 16 |  |  |  |  | 16
[NAME] | 2xOT Hrs | 28 | 28 | 32 | 34 | 30 | 42 | 40 | 46 | 26 | 35 | 38 |  | 379
[NAME] | Regular Hrs | 103.5 | 113.9 | 132.9 | 120 | 126 | 115 | 114 | 138 | 126 | 118 | 122 | 106 | 1435.3
[NAME] | [NAME] | 0.3 | 0.2 | 0.5 | 25.4 | 21.6 | 28.6 | 38.4 | 67.6 | 50.7 | 42 | 42.7 | 19.3 | 337.3
[NAME] | 1.5xOT Hrs |  |  |  |  |  |  | 6 | 9 |  | 8 |  |  | 23
[NAME] | 2xOT Hrs | 79 | 38 | 43 | 40 | 42 | 37 | 38 | 44 | 38 | 36 | 34 | 30 | 499
Spreadsheet: 41725d1240259898-finding-the-last-value-in-a-week-from-daily-data-test2-1-
Sheet: CLE

Trade Month | 2009-04-20 00:00:00
 | Current Trade | Next Trade | ATR Trade
Long Profit 3
Long Profit 2
Long Profit 1
A Up
A Down
Short Profit 1
Short Profit 2
Short Profit 3
Current Position | Long 1 K09 5140
Working Order | B 1 K09 91510 | Fill?
 | Current Month | Rollover Month
Rollover Trade | S 1 K09 MKT | B 1 M09 MKT
Stop |  | S 1 M09 5190
Spreadsheet: 3c1d761e-a575-42b2-afdc-7d295b8839a7
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0021934 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Hasentree Golf Community | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Wake | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Back 9 Fairways |  | Field Name: |  | Back 9 Greens |  | Field Name: |  | DR Fairways |  | Field Name: |  | [NAME]
 |  |  |  |  |  | Area (acres): |  | 59.6 |  | Area (acres): |  | 1.9 |  | Area (acres): |  | 6.8 |  | Area (acres): |  | 4.2
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 20.28 |  | Annual Rate (in): |  | 20.28 |  | Annual Rate (in): |  | 20.28 |  | Annual Rate (in): |  | 20.28
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 207735d1358535054-comparing-two-rows-and-highlighting-different-cells-sample
Sheet: Sample

ID | Code | Date | Association | Start Date | End Date | First Code | Amount | Recurring  Amount
B 101201 | 47 | 2013-02-07 00:00:00 | Y | 2013-02-07 00:00:00 | 2050-12-31 00:00:00 | 625 | 30 | 30
B 101201 | 10 | 2013-03-07 00:00:00 | Y | 2013-02-07 00:00:00 | 1999-01-01 00:00:00 | 1981 | 31 | 31
Spreadsheet: 117407d1312794834-trying-to-create-a-drop-down-from-vlookup-return-or-group-values-in-drop-down-workbook
Sheet: Schools

ARTS | BUSINESS | EDUCATION | SCIENCE
Australian Graduate School of Policing | School of Accounting | Murray School of Education | School of Agriculture & Wine Sciences
School of Humanities & Social Sciences | School of Business | School of Human Movement | School of Animal & Vet Sciences
School of Communication & Creative Industries | School of Computing & Maths | School of Education | School of Biomedical Sciences
School of Policing Studies | International School of Business | School of Information Studies | School of Dentistry &  Health Sciences
School of Psychology |  | School of Teacher Education | School of Nursing & Midwifery & Indigenous Health
School of Theology |  |  | School of Community Health
 |  |  | School of Environmental Science
Spreadsheet: 862860d1710432794-returning-a-column-header-name-if-a-cell-has-a-value-in-it-example-194-aligw
Sheet: Sheet1

Heworth | Manors | [NAME] | Pelaw | S Gosforth | Sunderland | [NAME] | Cullercoats | Output | 2016 | 365
 | Image 2 |  |  |  |  |  |  | Manors
 |  |  |  |  | Image 2 |  |  | Sunderland |  | Sunderland
 |  |  |  |  |  |  | Image 1 | Cullercoats |  | Cullercoats
 |  |  |  | Image 2 |  |  |  | S Gosforth |  | S Gosforth
 | Image 2 |  |  |  |  |  |  | Manors |  | Manors
 |  |  |  |  | Image 2 |  |  | Sunderland |  | Sunderland
Both equally |  |  |  |  |  |  |  | Heworth |  | Heworth
Both equally |  |  |  |  |  |  |  | Heworth |  | Heworth
Spreadsheet: 104207d1301861023-trend-graph-from-values-on-a-single-raw-kpi
Sheet: Sheet1

People | Food | Jan | feb | March |  | People | Food | Jan | feb | March
[NAME] | Bread Units | 10 | 20 | 40 |  | [NAME] | [NAME] | 0.2 | 0.5 | 0.1
[NAME] | Egg Units | 50 | 100 | 20 |  | [NAME] | Eggs % Sold | 0.5 | 0.1 | 0.04
[NAME] | Bread Units | 70 | 30 | 10 |  | [NAME] | [NAME] | 0.07 | 0.01 | 0.02
[NAME] | Egg Units | 40 | 20 | 100 |  | [NAME] | Eggs % Sold | 0.1 | 1 | 0.2
Spreadsheet: 102214d1300209585-excel-2007-nested-sumif-or-using-sumifs-test-1
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5
Yes | 50 | 45 | 30 | 20 | 5
No | 45 | 40 | 25 | 15 | 4
Maybe | 40 | 35 | 20 | 10 | 3
NA | 35 | 30 | 15 | 5 | 2
Needs to Read like this:
Agency | Yes | No | Maybe | NA
1 | 50 | 45 | 40 | 35
5 | 5 | 4 | 3 | 2
3 | 30 | 25 | 20 | 15
2 | 45 | 40 | 35 | 30
4 | 20 | 15 | 10 | 5
I need to search indeffinate Columns for a specific ID then search Indeffinate Rows for a Specific Data Type and give the corresponding data.
 | A | B | C | D
Days | 365 | 250 | 159 | 73
Min | 1538 | 468 | 5497 | 25
Hours | 548 | 45 | 548 | 3
Visits | 154987 | 2155 | 5484 | 99
Units | 35484 | 321854 | 54984 | 875
Agency |  |  | * I want to be able to drop A-D in and the correct Units, Hrs, Days, etc drop in by searching for that data type.
Units
Hours
Visits
Days
Results should be
Agency | A
Units | 35484
Hours | 548
Visits | 154987
Days | 365
I have a home office with 5 stores.  I need to enter all data form 5 stores on one worksheet and have it automatically fill in a form based on whatever store ID I chose.
Store: | A
How many days open? | 365
How many hrs sick pay? | 548
How many clients visited? | 154987
How many units sold? | 35484
 |  |  |  | 123456 | 222333 | 444555
 | 444555 |  | Data
days |  |  | days | 365 | 400 | 100
units |  |  | units | 400 | 401 | 110
dollars |  |  | dollars | 500 | 402 | 120
weeks |  |  | weeks | 600 | 403 | 130
months |  |  | months | 700 | 404 | 140
employees |  |  | employees | 80 | 405 | 150
cost |  |  | cost | 900 | 406 | 160
NOW I need something that will search for the corresponding ID AND search Data for "days", "units" etc…
 |  |  |  | 123456 | 222333 | 444555
 | 444555 |  | Data
days |  |  | days | 365 | 400 | 100
units |  |  | units | 400 | 401 | 110
dollars |  |  | dollars | 500 | 402 | 120
employees |  |  | weeks | 600 | 403 | 130
cost |  |  | months | 700 | 404 | 140
 |  |  | employees | 80 | 405 | 150
 |  |  | cost | 900 | 406 | 160
Spreadsheet: 847366d1698327474-array-formula-or-solution-to-make-data-power-bi-compatible-ce-trial
Sheet: Backhoe Loader

Rank | Backhoe Loader Type | Description | Category | Standard Weight Class | Common Applications | Index |  | Type | Brand | Headquarters | Brazil | Canada | China | Czech | France | Germany | Hungary | India | Italy | Japan | Turkey | UK | USA |  |  |  | Type | Brand | Manufacturing Facility
1 | Standard Backhoe Loader | Equipped with a digging bucket on the back and a loader bucket in the front, suitable for general-purpose tasks. | Standard Backhoe Loaders | 6-8 tons | Excavation, Digging, Loading, Material Handling, Light Construction |  |  | Backhoe Loaders | Caterpillar | Peoria, Illinois, USA | True |  | True | True |  |  | True | True | True |  |  | True | True |  |  |  | Crawler Excavator | Caterpillar | Brazil
2 | Extendable Backhoe Loader | Similar to standard backhoes but with a telescopic arm, providing increased reach and versatility. | Standard Backhoe Loaders | 7-9 tons | Deep Excavation, Digging in Confined Spaces, Material Loading |  |  | Backhoe Loaders | Komatsu | Minato, Tokyo, Japan |  |  |  |  |  | True |  |  | True | True |  |  |  |  |  |  | Crawler Excavator | Caterpillar | China
3 | Center Mount Backhoe Loader | Backhoe assembly mounted at the center of the machine, offering improved balance and maneuverability. | Specialized Backhoe Loaders | 7-9 tons | Urban Construction, Utility Work, Tight Construction Sites |  |  | Backhoe Loaders | [NAME] | Moline, Illinois, USA | True |  |  |  |  |  |  |  |  |  |  |  | True |  |  |  | Crawler Excavator | Caterpillar | France
4 | Mini Backhoe Loader | Compact and lightweight, designed for small-scale construction projects and landscaping tasks. | Mini Backhoe Loaders | 4-5 tons | Residential Construction, Landscaping, Small-scale Excavation |  |  | Backhoe Loaders | Hitachi | Chiyoda, Tokyo, Japan |  |  |  |  |  |  |  | True |  | True |  |  |  |  |  |  | Crawler Excavator | Caterpillar | Hungary
 |  |  |  |  |  |  |  | Backhoe Loaders | Case CE | Turin, Italy | True |  |  |  |  |  |  | True | True |  |  |  | True |  |  |  | Crawler Excavator | Caterpillar | India
 |  |  |  |  |  |  |  | Backhoe Loaders | Manitou | France | True |  |  |  |  |  |  | True |  |  |  |  | True
 |  |  |  |  |  |  |  | Backhoe Loaders | JCB | United Kingdom | True |  | True |  |  |  |  | True |  |  |  | True | True
 |  |  |  |  |  |  |  | Backhoe Loaders | Ace Construction Equipment | India |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  | Backhoe Loaders | Hidromek | Turkey |  |  |  |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  | Backhoe Loaders | New Holland Equipment | Turin, Italy | True |  | True |  |  |  |  | True | True |  |  |  | True
 |  |  |  |  |  |  |  | Backhoe Loaders | XCMG | China |  |  | True
 |  |  |  |  |  |  |  | Backhoe Loaders | SANY Heavy Equipment | China |  |  | True
 |  |  |  |  |  |  |  | Backhoe Loaders | Mahindra Construction Equipment | India |  |  |  |  |  |  |  | True
 |  |  |  |  |  |  |  | Backhoe Loaders | Sinomach-HI | China |  |  | True
 |  |  |  |  |  |  |  | OEMs
 |  |  |  |  |  | OEM Count
Spreadsheet: 26419d1218569086-pie-chart-data-labeling-test
Sheet: Sheet1

JURIS | Retail
Dinuba | 12.34333042797227
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 335.9171908989168
Dinuba | 0
Dinuba | 117.3760907101221
Dinuba | 0
Dinuba | 331.2571440794609
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 64.8032654642002
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 71.28359201062023
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 57.69880360837725
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Dinuba | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 0
Woodlake | 76.83166249247388
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 86.55621252957485
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Farmersville | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 1.039694202514077
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 141.5002026597199
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0.6512719182746798
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 60.65657565195307
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
Exeter | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 188.4908206222144
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 9.111180266271036
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 11.3889753328388
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
[NAME] | 0
Spreadsheet: errol_mclaughlin_jr__10909__aaaCredit Report2
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 11/21/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Kaiser Aluminum Corporation | Yl2352.1/yl2547.1 | p | NG | pending [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Aqulia Energy Marketing Corporation | yl2516.1 | F | NG | Aquila Risk Management Corporation
Bp Amoco Oil Company | yl2430.1 | F | NG | BP Corporation North America, Inc
General Mills, Inc | YL0192.1 | F | WTI | General Mills Operating, Inc
Spreadsheet: 133845d1324685662-printing-only-rows-with-values-scrap-quotes
Sheet: Purchase

 |  |  |  |  |  |  |  |  |  | Date:
 |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Purchase Ticket Number: |  | 454
 |  |  | Copper
 |  |  | Copper Spot Price |  | 100
 |  |  | Scrap Type | Weight | Price Per Lb | Amount
 |  |  | # 1 Copper
 |  |  | # 2 Copper
 |  |  | Bright & Shiny Copper | 27.5
 |  |  | # 1 Insulated Wire | 70.9
 |  |  | # 2 Insulated Wire
 |  |  | Total Weight: |  | Copper Total
 |  |  | Aluminum
 |  |  | Aluminum Spot Price |  | 100
 |  |  | Scrap Type | Weight | Price Per DWT | Amount
 |  |  | Extrusion Scrap
 |  |  | Aluminum Turnings | 15
 |  |  | Cast Aluminum
 |  |  | Used Beverage Cans
 |  |  | Coated Aluminum Scrap
 |  |  | Total Weight: |  | Aluminum Total:
 |  |  | Steel Spot Price: |  | 100
 |  |  | Scrap Type | Weight | Price Per DWT | Amount |  | Total
 |  |  | [NAME] | 235
 |  |  | Sheet Iron Scrap |  |  |  |  |  |  |  |  |  | 1500
 |  |  | No. 1 HMS Steel Scrap | 489.5
 |  |  | No. 1 HMS Steel Scrap (2')
 |  |  | No. 2 HMS Steel Scrap
 |  |  | No. 2 HMS Steel Scrap (2')
 |  |  | Mixed Steel Can Scrap
 |  |  | Total Weight: |  | Steel Total:
 |  |  | Total Purchase:
 |  |  | Notes:
Spreadsheet: 05818fd6-15ef-47f5-ab91-bdb2eaf80bd3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Emerging Defensive Fund
 | Monthly Performance History
 | Inception Date | 2012-07-09 00:00:00
 |  | Class I | Class N | MSCI Emerging Markets
 | Date | AZEIX | AZENX | Index
* | 2012-07-31 00:00:00 | 0.007000000000000117 | 0.007000000000000117 | 0.01975827895914706
 | 2012-08-31 00:00:00 | 0.01588877855014892 | 0.0148957298907646 | -0.003330280135328989
 | 2012-09-30 00:00:00 | 0.02443792766373409 | 0.02544031311154593 | 0.06034189668727818
 | 2012-10-31 00:00:00 | -0.007633587786259555 | -0.007633587786259555 | -0.006072053025255264
 | 2012-11-30 00:00:00 | 0.004807692307692291 | 0.003846153846153832 | 0.01269714856016657
 | 2012-12-31 00:00:00 | 0.0563846298031867 | 0.05669482292249661 | 0.04889502762430942
 | 2013-01-31 00:00:00 | -0.01282051282051277 | -0.01279707495429605 | 0.0137875563211356
 | 2013-02-28 00:00:00 | -0.007421150278293154 | -0.008333333333333304 | -0.01256324921947771
 | 2013-03-31 00:00:00 | -0.002803738317756932 | -0.002801120448179373 | -0.01939750183688471
 | 2013-04-30 00:00:00 | 0.02530459231490156 | 0.02528089887640439 | 0.00976975099461952
 | 2013-05-31 00:00:00 | -0.0356 | -0.0356 | -0.0257
 | 2013-06-30 00:00:00 | -0.03981042654028422 | -0.03977272727272729 | -0.0636580272693773
 | 2013-07-31 00:00:00 | -0.009871668311944859 | -0.01084812623274178 | 0.0104476593779681
 | 2013-08-31 00:00:00 | -0.03988035892323027 | -0.03988035892323016 | -0.0171764644786041
 | 2013-09-30 00:00:00 | 0.0664589823 | 0.0654205607 | 0.065
 | 2013-10-31 00:00:00 | 0.0360272639 | 0.037037037 | 0.0485836688
 | 2013-11-30 00:00:00 | -0.02819548872180466 | -0.02913533834586468 | -0.01462252545516485
 | 2013-12-31 00:00:00 | -0.012342557 | -0.012175622 | -0.01445779
 | 2014-01-31 00:00:00 | -0.07905138339920947 | -0.07996051332675236 | -0.06493528639394286
 | 2014-02-28 00:00:00 | 0.03326180257511 | 0.0343347639485 | 0.0331253500762
 | 2014-03-31 00:00:00 | 0.053997923157 | 0.052904564315 | 0.0306964898
 | * partial month return, inception date 7/9/2012
 | Emerging Defensive Fund
 | [NAME]
 | Month-end Returns as of | Class I | Class N | MSCI Emerging Markets
 | March 31, 2014 | AZEIX | AZENX | Index
 | 1 Year | -0.04005137741523357 | -0.04266176271212763 | -0.01206837874318023
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.03544762180243577 | 0.0310255187501578 | 0.1034103826920958
 | Since Inception Annualized Return | 0.02038652109183792 | 0.0178595024052155 | 0.0586694083478676
 | Since Inception Annualized Monthly Volatility | 0.1258420861130988 | 0.1262676886243567 | 0.1230719623646656
 | Quarter-end Returns as of | Class I | Class N | MSCI Emerging Markets
 | March 31, 2014 | AZEIX | AZENX | Index
 | 1 Year | -0.04005137741523357 | -0.04266176271212763 | -0.01206837874318023
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.03544762180243577 | 0.0310255187501578 | 0.1034103826920958
 | Since Inception Annualized Return | 0.02038652109183792 | 0.0178595024052155 | 0.0586694083478676