tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dbcbe9c2-5b09-4db8-9fc4-d11baee74382
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8521 | 63813 | Francisco | Lopez | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:03:19
8521 | 63816 | [NAME] | [NAME] | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:05:30
8521 | 63987 | [NAME] | Añez | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:05:43
8521 | 63817 | Livio | Gazzini | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 01:05:57
8521 | 63821 | [NAME] | Puertas Tovar | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 01:10:09
8521 | 63818 | [NAME] | Sotillo | VEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 01:10:35
Spreadsheet: 64638d1265421045-populating-multiple-cells-by-entering-in-criteria-graphtest-1-
Sheet: Sheet2

Location: | Location B
Activity: | Incident 1, Incident 2, Incident 3
 | Begin Time | End Time | Begin Time | End Time | Begin Time | End Time | Begin Time | End Time | Begin Time | End Time
Sunday | 08:00:00 | 16:00:00
Monday | 09:00:00 | 17:00:00
Tuesday | 10:00:00 | 18:00:00
Wednesday | 11:00:00 | 19:00:00
Thursday | 12:00:00 | 20:00:00
Friday | 13:00:00 | 21:00:00
Saturday | 14:00:00 | 22:00:00
Risk Ranking | Green | Yellow | Red
Criteria 1
[NAME]
Criteria 3
[NAME]
Criteria 5
Spreadsheet: a4ee33dc-5341-486c-8bd7-8c74bfa70c91
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
IGG | Test | IGG | [NAME] (IgG), Serum | [NAME] (IgG), S | Nephelometry | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 0-<5 months: 100-334 mg/dL 5-<9 months: 164-588 mg/dL 9-<15 months: 246-904 mg/dL 15-<24 months: 313-1,170 mg/dL 2-<4 years: 295-1,156 mg/dL 4-<7 years: 386-1,470 mg/dL 7-<10 years: 462-1,682 mg/dL 10-<13 years: 503-1,719 mg/dL 13-<16 years: 509-1,580 mg/dL 16-<18 years: 487-1,327 mg/dL > or =18 years: 767-1,590 mg/dL | Monday through Saturday; Continuously | 1 day | 3 days | 1 | 82784 |  |  |  |  | Rochester
IGG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
IGG | Result | IGG | [NAME] (IgG), S | [NAME] (IgG), S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2465-3
Spreadsheet: 686089d1594356688-more-efficient-counta-sumif-and-sum-formulas-needed-for-training-spreadsheet-training
Sheet: Training 6

 | Training 6
 |  |  | 7:30am | 7:30am | 7:30am | 7:30am | 7:30am | 8:30am | 8:30am | 9:00am | 9:30am | 9:30am | 9:30am | 10:00am | 10:00am | 10:00am | 10:30am | 11:00am | 11:00am | 11:00am | 11:00am | 11:00am | 11:30am | 12:00pm | 12:00pm | 1:30pm | 1:30pm | 1:30pm | 3:00pm | 3:00pm | 3:00pm | 3:00pm
 | # of Sessions |  | 1
 | # of Expected on Training Day |  | 1 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | # [NAME] |  | 1 | 2 |  | 3 | 3 | 2 | 2 | 2 | 0 | 2 |  | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 1 | 3 |  | 2 | 2 | 2 | 2 |  | 2 |  | 2 | 3
 | New Hire Show Rate
 | [NAME] | The same for training 1-6
 | C6: | Count Row 6 from column D and over, Only the cells with data entered in them
 | C7: | Sum of row 7 tfrom Column D and over "IF" Row 8 has data enetered
 | C8: | Sum of Row 8 from Column D and over
 | Column D and Over: | Manually entered.
Spreadsheet: 84786d1284829506-calulating-a-running-total-based-on-date-pt-test
Sheet: Sheet1

Date |  |  |  | 2010-09-17 22:10:27
 | Today |  |  | Tomorrow's Commitments |  |  | Today
 | Set | 1 |  | Set | 1 |  | [NAME] | 1
 | Show | 1 |  | Show | 1 |  | [NAME] | 1
 | Show % | 1
 | Close | 1 |  |  |  |  | Total % | 1
 | Close% | 1
 | Cash | 0 |  | Cash | 0
 | Gross | 0 |  | Gross | 0
 | EFT | 0
Spreadsheet: 75600d1276142056-excel-2007-autofill-not-recognizing-a-pattern-correctly-excelproble
Sheet: Sheet1

 | This sheet has the problem in it's simplest form. See sheet 2 and 3 for more complicated situations.
 | Some data |  |  | What I want to happen (this is all done manually) |  | What actually happens (the first four are done manually, the rest are done by dragging) |  | I've found a very ugly workaround… (it's even uglier when the data is in a different sheet, and when you want to take the sum of every cell in a row or column on that sheet) |  | An example of something more similar (and extremely ugly) to what happens in my real workbook.
 | 0
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
Spreadsheet: 772409d1647259803-need-spaces-btween-two-text-strings-excel-help-forum-3-1-
Sheet: Sheet1

 | text phrase | No.of text
 | 65-Hanjarwal | 9
 | C-21 60-Feet Road
 | [NAME]
 | G-14 Sunder Industrial Estate
 | Canal Bank-2
 | [NAME]
 | 222-LT Lts M 15 Fzr
 | C-41 Opp 240-B
 | C-28 4981 C-12
 | C-13 Opp 3402 C-2
Spreadsheet: 845975d1697270345-index-of-non-empty-cells-match-input-with-pool-of-texts-or-word-bank-excelforum3-updated
Sheet: Headcount

Company Names | No. |  |  |  | to be Dynamic List of Companies from Column A | Sum Of Head Count
MASSADR | 1
ACIC | 3 |  |  |  | ARABIAN CONSOLIDATED INDUSTRIAL CLEANING CO. (TANDHEEF)
ACT |  |  |  |  | Arabian Consolidated Trading Est.
ACT | 3 |  |  |  | Arabian Pipeline & Services Co. Ltd (ANABEEB)
AYTB | 7 |  |  |  | Binzagr (BFIM)
Anabeeb (V-7645 Chemical Cleaning) |  |  |  |  | Eram Contracting Est.
AYTB | 12 |  |  |  | HI TECH
AYTB | 40 |  |  |  | JADARRAH
Binzagr | 10 |  |  |  | JAL Human Resources Company (JHR)
ERAM Engr. |  |  |  |  | LIMOSINA
BFIM | 10 |  |  |  | Massadr Human Resource Services Company
ERAM |  |  |  |  | Plantech
HI TECH | 25
[NAME]
[NAME] | 2
[NAME]
JADDARAH | 1
[NAME]
JAL
JAL HR | 1
LIMOSINA - (Contractors) | 1
LIMOUSINA
PLANT-TECH (Cleaning)
PLANT-TECH (IP-X093) | 8
Spreadsheet: 703073d1604735171-inventory-tracking-formulas-and-formula-for-discounts-or-bulk-buying-example
Sheet: Add Inventory

Product No | Date | Product | Units Received | Unit Price | Value
 |  |  | 0
 |  | 00-BM-A-A1 | 3
Spreadsheet: 769905d1645722058-offset-with-count-not-working-horizontally-book1
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
Spreadsheet: 878513d1725621546-xlookup-to-extract-image-by-reference-number-not-working-jean1972-catalog-365-aligw
Sheet: PROCESS

Art code | Description | Catalog
109000300 | KO CAR CHARGER USB A WHT
109000310 | KO CAR CHARGER USB A C BLK
109000330 | KO CAR PHONE HOLD MAGNET BLK
CR1000150 | KO CAR PHONE HOLD NONSLIP BLK
CY5653721 | KO WINDOW CLEANER 13X40 GRN
8DA000320 | XQMAX BICYCLE BELL MINI BRBG
FC4700040 | XQMAX BICYCLE PHONE HOLD 12CM
029000440 | KO POTTY CHILD PP 35X28X19 BPW
029000450 | KO POTTY CHILD PP 25X24X16 BPW
10000650 | KO STORAGE JAR GLS RND 66CL BW
24000890 | KO COLANDER HANDLE PP 2.5L GGW
24001180 | KO MIXING BOWL PP HB 1.8L GCB
24001390 | [NAME] 4 MUG PP HD
Spreadsheet: 762591d1641649807-list-and-average-according-to-the-last-3-record-of-the-type-a-and-the-data-is-greater-than-forumhelp_01-08
Sheet: Sheet1

TYPE | DATA |  | TYPE |  |  |  |  | DATA AVERAGE
A | 10 |  | A |  |  | 7
B | 8 |  |  |  | A | 5 |  |  | Average according to the last 3 record of type A and the data is greater than 0
C | 6 |  |  |  | A | 20
A | 7
B | 3 |  |  |  | According to the list of last 3 record of type and data greater than 0
A | 5
A | 0 |  |  |  |  | 7
B | 15 |  |  |  | A | 5
D | 9 |  |  |  | A | 20
A | 20
 |  | The data source is in columns A and B
Spreadsheet: benjamin_rogers__1068__gencomodel
Sheet: Summary

 |  |  | 0 | 0 | 0 | 0
Deterministic Asset Valuation Model
Valuation Summary
 |  |  | Value | Value | Value |  | Total
 | Unit(s) | Capacity | (2000-2005) | (2006-2019) | (Terminal) |  | Value | $/Kw
 | BaseLoad Total
 | Peaker Total
 | Cinergy Total
 |  |  | PPA Value | Value | Value |  | Total
 | Unit(s) | Capacity | (2000-2005) | (2006-2019) | (Terminal) |  | Value | $/Kw
1 |  |  | 105556107.431947 | 161194638.9784508 | 34012149.47247671
2 |  |  | 146537042.6710709 | 245595177.8324876 | 53648656.11811094
3 |  |  | 73283453.34171867 | 114766980.5847296 | 24921230.06444737
4 |  |  | 70488023.08207946 | 112272552.8080052 | 24383787.89625388
5 |  |  | 72296727.39745568 | 110629702.365208 | 24012244.24693497
6 |  |  | 73387917.52542147 | 112572135.8043785 | 24475628.37902072
7 |  |  | 67953371.76720312 | 105291106.9022943 | 22776557.5550143
8 |  |  | 14619493.96285 | 12078018.08469795 | 2551699.79787225
9 |  |  | 49622807.92823412 | 70554517.32288653 | 15274149.40506675
10 |  |  | 90560308.52271296 | 162296450.1859649 | 35235276.47529523
11 |  |  | 98350020.17407365 | 165749349.3566658 | 36176328.34827617
12 |  |  | 22929900.79714055 | 29017669.32919301 | 6354044.299390467
13 |  |  | 22315447.13092688 | 28294264.69576156 | 6199525.12229469
14 |  |  | 35406658.04160758 | 46971694.56015442 | 10250272.52582652
15 |  |  | 42990123.0000824 | 58533977.41070072 | 12696973.38950718
16 |  |  | 73164477.43317738 | 93077157.61488868 | 20304340.21054491
17 |  |  | 44793131.05208053 | 59909730.84460314 | 13184600.68323542
18 |  |  | 269025806.4863414 | 346298580.6529324 | 74948422.75169842
19 |  |  | 6875251.824051486 | 3653858.275943404 | 704304.8404354035
20 |  |  | 1075374.68571933 | 360013.3696394137 | 66238.53927050524
21 |  |  | 2407091.92826121 | 845939.1587887064 | 156582.575410718
22 |  |  | 4395956.415506717 | 1899209.748096401 | 383844.6139891556
23 |  |  | 4644045.685802274 | 3601197.094115803 | 746732.8082915512
24 |  |  | 4644045.685802274 | 3601197.094115803 | 746732.8082915512
25 |  |  | 4644045.685802274 | 3601197.094115803 | 746732.8082915512
26 |  |  | 4644045.685802274 | 3601197.094115803 | 746732.8082915512
27 |  |  | 10898110.42949934 | 9188495.044336995 | 1757865.221747347
28 |  |  | 10898581.1336542 | 9188495.139443915 | 1757867.804841979
29 |  |  | 10882718.86384719 | 9192439.527010016 | 1758958.366350078
30 |  |  | 10882718.86384719 | 9192439.527010016 | 1758958.366350078
31 |  |  | 10868001.07231363 | 9199418.408432055 | 1760618.781332023
32 |  |  | 10870323.84408628 | 9202295.822730912 | 1761220.74899803
33 | VMC | 750 | 154452810.8267078 | 188114893.5673317 | 37410269.25470292
Spreadsheet: 850452d1700775020-help-with-bankroll-stats-from-different-sheets-to-be-calculated-copy-of-mtt-brm-template-staking1
Sheet: Tournaments

Current Bankroll: |  |  |  |  |  |  |  |  | [NAME]. Buy In:
Overall Stats |  |  |  | Summary Data |  |  | Finish Positions |  |  |  |  | Buy-ins
Total Profit |  |  |  | Bankroll |  |  | ITM % |  | Late % |  |  | Suggested BI
Total Time |  |  |  | Starting Bankroll |  |  | 1st |  | Mid Late % |  |  | Allowable BI
[NAME] |  |  |  | Profit |  |  | 2nd |  | Midde % |  |  | [NAME] (not recc'd)
ROI |  |  |  | ROI |  |  | 3rd |  | Early Mid % |  |  | Average BI
[NAME] ROI |  |  |  | Buy-in ROI |  |  | 4 - 10 |  | Early % |  |  | Sugg BIs Avail.
$/Hr |  |  |  | Total Time |  |  |  |  |  |  |  | Allow BIs Avail.
$/Tournament |  |  |  | $/hr |  |  |  |  |  |  |  | [NAME].
# | Date | Start Time | Finish Time | Size | Total Buy-in | Place Finished | Prize | Profit | Length | Placed % | ROI | $/Hr | Bankroll | BI % of BR | Profit % of BR | Tournament | Profit
0
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 32.1 | 1224 | 2106.71
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 21.6 | 1685 | 0
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 3.21 | 725 | 9.58
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 5.4 | 300 | 0.01
 | 2010-01-01 00:00:00 | 09:30:00 | 10:45:00 | 2000 | 54 | 10
 |  |  |  |  | 50 |  | 23
 |  |  |  |  | 12.9 |  | 10000
 |  |  |  |  | 32.1
 |  |  |  |  | 100
 |  |  |  |  | 200
 |  |  |  |  | 32.1
 |  |  |  |  | 3.21
 |  |  |  |  | 21.6
 |  |  |  |  | 32.1
 |  |  |  |  | 5.4 |  | 4.37
 |  |  |  |  | 54
 |  |  |  |  | 85.5
 |  |  |  |  | 54 |  | 37.5
 |  |  |  |  | 10.8 |  | 48.3
 |  |  |  |  | 12.9 |  | 9
 |  |  |  |  | 2.16 |  | 0.5
 |  |  |  |  | 32.1
 |  |  |  |  | 3.21 |  | 94.61
 |  |  |  |  | 32.1 |  | 7.5
 |  |  |  |  | 21.6
 |  |  |  |  | 11.67837209302328
 |  |  |  |  | 85.5
 |  |  |  |  | 21.6
 |  |  |  |  | 32.1
 |  |  |  |  | 12.9 |  | 6
 |  |  |  |  | 5.4 |  | 1.25
 |  |  |  |  | 25 |  | 43.61
 |  |  |  |  | 32.1
 |  |  |  |  | 25
 |  |  |  |  | 3.21
 |  |  |  |  | 21.6 |  | 25.83
 |  |  |  |  | 54
 |  |  |  |  | 108
 |  |  |  |  | 10.8
 |  |  |  |  | 5.4 |  | 1.25
 |  |  |  |  | 54
 |  |  |  |  | 25
 |  |  |  |  | 215
 |  |  |  |  | 10.8
 |  |  |  |  | 1.08 |  | 3.21
 |  |  |  |  | 5.4 |  | 8.12
 |  |  |  |  | 54
 |  |  |  |  | 2.16
 |  |  |  |  | 21.6
 |  |  |  |  | 32.1 |  | 7.5
 |  |  |  |  | 5.4 |  | 2.5
 |  |  |  |  | 5 |  | 25.83
 |  |  |  |  | 10
 |  |  |  |  | 25
 |  |  |  |  | 50
 |  |  |  |  | 100
 |  |  |  |  | 200 |  | 92
 |  |  |  |  | 320
 |  |  |  |  | 5.4 |  | 17.75
 |  |  |  |  | 54
 |  |  |  |  | 2.16
 |  |  |  |  | 12.9
Spreadsheet: 771775d1646840176-aggregate-statistics-across-multiple-sheets-if-multiple-critereon-met-tiers-sample-for-excel-forums
Sheet: Client00003

 | Simple |  | Medium |  | Complex
Title 1 |  |  |  | x |  |  | Tasks | Simple |  |  |  | Product Type
 |  |  |  | x |  |  |  | Medium
Title 2 |  |  |  | x |  |  |  | Complex
 |  |  |  |  |  |  |  | Total |  |  |  | [NAME]
 |  |  |  |  |  |  | >3 Complex = Complex > 10 Medium = Complex > 25 Medium + Simple = Complex
Title 3
Spreadsheet: 713537d1610771901-formula-to-get-one-result-if-a-cell-is-blank-another-result-if-cell-has-information-2021-planting_plan-help
Sheet: Flower Spacing

[NAME]
4-6" | 6" | 9" | 12" | 18"
lisianthus | sunflower | Bachelor Buttons | Columbine (Perennial?) | Cosmos 12-18" pinch
 | larkspur | Bells of Ireland | zinnias
 | [NAME] | Scabiosa | dahlia
 | [NAME] | Snapdragon | marigolds (12-18")
 |  | Yarrow | [NAME]
 |  | [NAME] (14 hrs daylight helps)
 |  | Phlox
 |  | Celosia-single stem
 |  | Cerinthe
 |  | Zinnias & pinch
Spreadsheet: 864935d1712067618-adding-pounds-and-ounces-book1-rev-2
Sheet: Sheet2

ANGLER | LB | OZ | LB | OZ | LB | OZ | LB | OZ | FINAL OZ | FINAL LB
10 | 4 | 10 | 4 | 10 | 4 | 10 | 4 | 10
6 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 6
5 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 5
1 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 4
2 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 3
3 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 2
4 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 1
9 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 9
8 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 8
7 | 4 | 1 | 4 | 1 | 4 | 1 | 4 | 7
Spreadsheet: 119430d1314382980-collate-data-problem
Sheet: Problem1

Input | Output
14849 | 14849;94138;71972;83506;53899;447;55883;75232;53287;6852;10964;51397;84865;267;35652;2416;3572;34838;52148;3815;13077;20178;82689;54977;31439;32696;72597;43962
94138
71972
83506 | I want B2 to show the ouput and it has to be dynamic in the sense that if column A has 5000 entries, the user don't have to make any changes to the formula. The moment user paste the data in column A, it automatically show the collated data in B2.
53899
447
55883
75232
53287
36852
10964
51397
84865
267
35652
2416
3572
34838
52148
3815
13077
20178
82689
54977
31439
32696
72597
43962
Spreadsheet: 82885d1282891179-search-button-using-macro-rammohan
Sheet: Mr.Sameer

←← |  | SAMEER
NATURE OF WORK |  | 7.1 Home Theatre System
APP VALUE
SALES INCHARGE
CLIENTS REPRESENTATE
ARCHITECT
PO DETAILS
SERVICE COORDINATES
SITE CONDITION
DELIVERY SCHEDULE
STATUS ON DAY TO DAY BASIS |  | Cabling for 7.1 HT completed.
ROUGH ESTIMATE OF THE MATERIAL
DAC HDMI cable 10.mt |  | 1 No
DAC Video cable ARR691C |  | 10 mts
Monster XPHP 100 EU Spkr cable |  | 10 mts
Monster XP 500 Spkr cable |  | 52 mts
Universal Ceiling mount |  | 1 No
←←
Spreadsheet: 816912d1675886922-nested-if-with-vlookup-based-on-a-yes-no-selection-test-for-vlookup-mr-excel-etaf-3
Sheet: Dining List

 | ser | Title | Surname | First Name | Payment Type
 |  |  | Black | [NAME] | BACS Confirmed
 |  | Mrs | [NAME] | [NAME] | BACS TBN
 |  | Mr | Jones | [NAME] | Card
 |  | Mr | Smith | [NAME] | BACS Confirmed
 |  | Ms | Ward | [NAME] | Card
 |  | Mrs | White | [NAME] | BACS Confirmed
Spreadsheet: 766910d1644161645-h-3-b3-formula-should-change-and-go-for-different-ranges-automatically-sample-2-ans2
Sheet: Sheet1

 |  |  |  | Expected result | Gap |  | Values
 | 4 |  |  |  | 2 |  | 1
 | 6 |  |  |  | 7 |  | 3
 | 1 |  |  |  | 10 |  | 4
 | 4 |  |  |  | 8 |  | 2
 | 2
 | 8
 | 1
 | 2
 | 5
 | 6
 | 7
 | 8
 | 5
 | 1
 | 5
 | 6
 | 4
 | 7
 | 8
 | 11
 | 1
 | 2
 | 3
 | 14
 | 1
 | 1
 | 4
 | 2
 | 8
 | 1
 | 2
 | 5
 | 1
 | 2
 | 3
 | 14
 | 1
 | 1
 | 4
 | 2
 | 8
 | 1
 | 2
 | 5
Spreadsheet: sally_beck__33697__Metrics 0609
Sheet: Chairman

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Office of the Chairman
Results based on Activity through June 9, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 10
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0
- Exits |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 0 |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 0 | 0 |  |  | 1 | 30 |  | 0 | 0 |  |  |  |  | 0 | 0
Identified Margin
Budget |  | 0 |  |  | 52.2 |  |  |  | 23.4 |  |  | 23.4 |  |  |  |  |  | 0.01
$ Coverage | 0
$ millions
Spreadsheet: 798068d1664289295-merged-cells-in-dynamic-array-jade-help-file
Sheet: Desired Output

Fiche | Last Name | First Name | 960501 |  |  | 960515
2808749 | 2808749First | 2808749Last | EC | EC | SU | EC | SU | -
1104470 | 1104470First | 1104470Last | SU | - | - | SU | - | -
2804169 | 2804169First | 2804169Last | EC | SU | - | EC | EC | SU
2808731 | 2808731First | 2808731Last | SU | - | - | SU | - | -
Spreadsheet: 79c72eb7-c324-4c20-bdf3-7d5c0bd1f6b0
Sheet: Sheet1

Unnamed: 0 | US Municipal Bond Issuance | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Table | Description | Time Period | Currency | Value | Last Value | Last Updated
 | 1.1. | US Municipal Issuance, Bond (Go/Revenue), Bid (Competitive/Negotiated), and Coupon Type | A, M | USD | Billions | Nov 2014 | 2014-12-01 00:00:00
 | 1.2. | US Municipal Issuance, New Capital & Refunding | A, M | USD | Billions | Nov 2014 | 2014-12-01 00:00:00
 | 1.3. | US Municipal Issuance, Callable and Noncallable | A, M | USD | Billions | Nov 2014 | 2014-12-01 00:00:00
 | 1.4. | US Municipal Issuance, Average Maturity | A, M |  | Years | Nov 2014 | 2014-12-01 00:00:00
 | 2.1. | FAQ |  |  |  |  | 2012-07-12 00:00:00
 | Contact
 | [NAME] | [EMAIL]
 | All data are subject to revision.
 | The Securities Industry and Financial Markets Association (SIFMA) prepared this material for informational purposes only. [NAME] obtained this information from multiple sources believed to be reliable as of the date of publication; SIFMA, however, makes no representations as to the accuracy or completeness of such third party information. SIFMA has no obligation to update, modify or amend this information or to otherwise notify a reader thereof in the event that any such information becomes outdated, inaccurate, or incomplete.
 | The Securities Industry and Financial Markets Association (SIFMA) brings together the shared interests of hundreds of securities firms, banks and asset managers. [NAME]'s mission is to support a strong financial industry, investor opportunity, capital formation, job creation and economic growth, while building trust and confidence in the financial markets. SIFMA, with offices in New York and Washington, D.C., is the U.S. regional member of the Global Financial Markets Association (GFMA). For more information, visit www.sifma.org.
 | FAQ
 | Issuance | All issuance figures are based on deals with maturity of 13 months or greater.
 | Average Maturity | Average maturity is based on issuance, rather than outstanding, volumes.
 | Source: | Thomson Reuters
Spreadsheet: 293930d1391130351-how-to-set-the-date-so-that-it-changes-red-after-that-date-passes-client-test-tracker-2014-1-ndm-v2
Sheet: Sheet1

 | TEST | CLIENT | DOB | TEST | DATE TEST | DATE RESULTS | Results | DATE REPORT | Report on
 | DATE |  |  |  | SUBMITTED | DUE BACK | Back | DUE | File
1 |  |  |  | Test 2 | 2014-01-01 00:00:00 |  |  |  |  |  |  | Test 1 |  |  |  | Test 2 | 1
 |  |  |  | Test 1 | 2014-01-01 00:00:00 |  | No |  |  |  |  | Test 3 | 2014-01-30 00:00:00 |  |  | Test 1 | 7
 |  |  |  |  |  |  |  |  |  |  |  | Test 2 | 2014-01-31 00:00:00 |  |  | Test 3 | 23
 |  |  |  |  |  |  |  |  |  |  |  | Test 4 | 2014-01-01 00:00:00 |  |  | Test 5 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Test 5 | 2014-01-01 00:00:00 |  |  | Test 4 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test 6 | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test 7 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test 8 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test11 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test12 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test13 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test14 | 5
Spreadsheet: 689898d1596730525-postcode-appears-in-two-areas-data-sample-1-
Sheet: Pivot

Row Labels | Count of Area
CH 1 4EF | 23
Garden Quarter | 18
Newton | 5
CH 1 4EG | 8
Newton | 8
CH 1 4EH | 16
Chester City | 16
CH 1 4EJ | 7
Chester City | 7
CH 1 4EL | 43
Garden Quarter | 43
CH 1 4EN | 31
Chester City | 3
Garden Quarter | 28
Grand Total | 128