tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 348432f1-b323-4434-b7c5-cc3686cccbb2
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42784911 | 2014-08-19 03:31:00 | AXIS | 0 | 4 | 6 | 1621725 | magicrooney | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
42912834 | 2014-08-28 04:55:11 | ALLIES | 1 | 6 | 4 | 1007284 | Temple58 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
42913013 | 2014-08-28 05:13:48 | AXIS | 0 | 4 | 6 | 1007284 | Temple58 | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
Spreadsheet: 587454d1535035038-index-match-issues-copy-of-excelforum-coachk88-
Sheet: Calculations

Session Information |  |  |  |  |  | Load |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Physical [NAME] |  |  |  |  |  |  |  |  | Practice Load |  |  |  |  |  |  |  |  | Individual Load
Week | Date | Athlete | cDataPoint | Class | Position | [NAME] | Physical [NAME] | Practice Load | Individual Load | Game Load | 28 Day RA | 7 Day RA | RA A:C | 28 Day EWMA | 7 Day EWMA | EWMA A:C | Monotony | Strain | TSB | 28 Day RA2 | 7 Day RA3 | RA A:C4 | 28 Day EWMA5 | 7 Day EWMA6 | EWMA A:C7 | Monotony8 | Strain9 | TSB10 | 28 Day RA11 | 7 Day RA12 | RA A:C13 | 28 Day EWMA14 | 7 Day EWMA15 | EWMA A:C16 | Monotony17 | Strain18 | TSB19 | 28 Day RA20 | 7 Day RA21 | RA A:C22 | 28 Day EWMA23 | 7 Day EWMA24 | EWMA A:C25 | Monotony26 | Strain27 | TSB28
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 480 | 480 |  |  |  |  |  |  |  | 480 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 480 | 480 |  |  |  |  |  |  |  | 480 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 480 | 480 |  |  |  |  |  |  |  | 480 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 480 | 480 |  |  |  |  |  |  |  | 480 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 360 | 360 |  |  |  |  |  |  |  | 360 | 360
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 600 | 600 |  |  |  |  |  |  |  | 600 | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 960 | 960 |  |  |  |  |  |  |  | 960 | 960
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 360 | 360 |  |  |  |  |  |  |  | 360 | 360
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 720 | 720 |  |  |  |  |  |  |  | 720 | 720
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 480 | 480 |  |  |  |  |  |  |  | 480 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 720 | 720 |  |  |  |  |  |  |  | 720 | 720
Spreadsheet: 455371d1460294167-calculating-games-back-sample
Sheet: Sheet1

New Orleans Hornets | 1 | 0 | 1 | — | 1 | 0 | 85 | 84
San Antonio Spurs* | 1 | 0 | 1 | — | 1 | 0 | 95 | 82
Sacramento Kings | 1 | 0 | 1 | -1.5 | 1 | 0 | 100 | 91
Los Angeles Clippers* | 1 | 0 | 1 | -1.5 | 1 | 0 | 105 | 86
Portland Trail Blazers | 1 | 0 | 1 | 0.5 | 1 | 0 | 107 | 103
Denver Nuggets* | 1 | 0 | 1 | 0.5 | 1 | 0 | 115 | 93
Oklahoma City Thunder* | 2 | 0 | 1 | — | 1 | 1 | 100.5 | 94.5
Golden State Warriors | 1 | 1 | 0.5 | -1 | 1 | 1 | 92.5 | 98
Houston Rockets | 0 | 1 | 0 | 1 | 0 | 1 | 95 | 104
Dallas Mavericks* | 0 | 2 | 0 | 1.5 | 0 | 2 | 93.5 | 110
Memphis Grizzlies* | 0 | 1 | 0 | 1 | 0 | 1 | 82 | 95
Phoenix Suns | 0 | 1 | 0 | -0.5 | 0 | 1 | 84 | 85
Los Angeles Lakers* | 0 | 2 | 0 | — | 1 | 1 | 89 | 94
Minnesota Timberwolves | 0 | 1 | 0 | 1.5 | 0 | 1 | 100 | 104
Spreadsheet: e24db52b-3a00-4241-8656-32223d22ce1f
Sheet: Option 4

VENDOR NAME:
Description  Option 4: Provider's Choice for Optimal Connectivity (Complete Red-Shaded Areas) | 3-Year Contract
 | Non-Recurring Charges | Monthly Recurring Charges July 1, 2013-June 30, 2014 | Monthly Recurring Charges July 1, 2014-June 30, 2015 | Monthly Recurring Charges July 1, 2015-June 30, 2016 | TOTAL  3 YEAR COSTS
CADM-Library System Administrative Office, 1601 Ritner Highway, Suite 100, Carlisle, PA 17013
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
CADM-Library System Administrative Office, 1601 Ritner Highway, Suite 100, Carlisle, PA 17013
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
Cumberland County Court House, 1 Court House Square, Carlisle, PA 17013
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
AME-Amelia [NAME], 114 North Baltimore Ave., Mt. Holly Springs, PA 17065
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
BOS-Bosler Memorial Library, 158 [NAME], Carlisle, PA 17013
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
FRE-Cleve J. Fredricksen Library, 100 N. 19th St., Camp Hill, PA 17011
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
EPB-East Pennsboro Branch Library, 98 S. Enola Drive, Enola PA 17025
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
JGR-[NAME], 9 Parsonage St., Newville, PA 17241
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
SIM-[NAME], 16 North Walnut St., Mechanicsburg, PA 17055
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
NCU-New Cumberland Public Library, 1 [NAME], New Cumberland, PA 17070
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
SHP-Shippensburg Public Library, 73 [NAME], Shippensburg, PA 17257
Specify Service:
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
*TOTAL (without asterisked circuit)
TOTAL (including asterisked circuit)
Spreadsheet: 784982d1656058322-lookup-partial-string-match-in-excel-test
Sheet: Sheet5

Column1 | Column2 |  | String | Expected |  |  | String | Value
Ayanande |  |  | Ayanande |  |  |  | Aya | 1
Ayonande |  |  | Ayonande |  |  |  | Tes | 2
Aviles |  |  | Aviles |  |  |  | Bad | 3
Bade |  |  | Bade
Bailer |  |  | Bailer
Test |  |  | Test
Spreadsheet: 00f083f2-5707-4780-b36a-4246be8bab4e
Sheet: Sheet1

PRACTICAL LEARNING SUGGESTIONS | Unnamed: 1 | Unnamed: 2
FOR THE LEARNING STYLES
Learning Styles | Best Ways to Learn | Practical Suggestions
Verbal/Linguistic | Reading                    Saying                    Hearing                       Seeing words | Taking notes, Read notes or text out loud, [NAME] through reading first,  Study out loud with partner,  Use a tape recorder
Mathematical/Logical | Making categories  Classifying          Working with Patterns  Figuring with Numbers | Use lists to study from, Arrange notes in patterns, Assign numbers to information, Take notes in outline form, Use math formulas to problem solve (ratio, geometry, etc.)
Visual/Spatial | Visualizing                     Using colors & pictures | Study or make charts, graphs, pictures,  Use highlighters, Use webbing to take notes,  Close eyes and visualize mental images in mind
Bodly/Kinesthetic | Touching  Moving       Hands on learning  Interacting with objects  Doing something physical while learning | Choose projects that let you build, create, shape with hands,  Use objects to help you remember people, places, things  [NAME]/participate in class
Music/Rhythmic | Rhythmically         Musically                       Making up melodies | Create musical jungles to aid memorization,  Study for test etc. with quiet music in background,  Rhythmically read notes out loud
Interpersonal | [NAME] with others  Interviewing | Study with a focused partner,  Ask frequent questions of others to gain information,  Participate in class discussions,  Discuss ideas with others
Intrapersonal | Working alone in own space                              Self-Pacing instruction  Reflecting | Organize your study place and time,  Take time to think about the things you are learning,  Research ideas in depth
Spreadsheet: 819910d1677761960-earliest-time-on-a-date-date-example
Sheet: Sheet1

Date & Time
2023-02-18 12:05:00
2023-02-18 13:23:00
2023-02-18 14:59:00
2023-02-18 16:24:00 |  | Earliest time on |  | 2023-02-20 00:00:00
2023-02-18 21:34:00 |  | Expected return |  | 00:46:00
2023-02-18 23:02:00 |  |  | next time | 08:12:00 | 08:12:00
2023-02-19 00:35:00 |  |  | next time | 10:40:00 | 10:40:00
2023-02-19 02:35:00 |  |  | next time | 14:40:00 | 14:36:00
2023-02-19 02:52:00 |  |  | next time | 14:36:00 | 00:00:00
2023-02-19 04:09:00 |  |  | next time | 00:00:00
2023-02-19 07:18:00
2023-02-19 08:42:00
2023-02-19 11:06:00
2023-02-19 09:56:00
2023-02-19 21:03:00
2023-02-19 22:33:00
2023-02-20 00:46:00
2023-02-20 08:12:00
2023-02-20 10:40:00
2023-02-20 14:36:00
2023-02-21 00:00:00
2023-02-21 00:00:00
2023-02-21 08:10:00
2023-02-21 09:48:00
2023-02-21 12:18:00
2023-02-21 12:18:00
2023-02-21 15:47:00
Spreadsheet: 59320d1259801100-making-a-time-sheet-any-one-could-help-studio-session-record-with-time-page
Sheet: Time Sheet

 |  |  | Studio Session Record
 |  |  |  |  | Time Sheet
 |  |  |  | Session Record No:
 |  | Client: | Date:
 |  |  | P.O. No:
 |  |  | Personnel:
 |  | Item | Date | Start | Date | End | Total Hours
 |  | Studio | 2009-10-19 14:01:05 | 14:01:05 | 2009-10-19 14:01:06 | 14:50:06 | 00:49:01
 |  | Studio Resume | 2009-10-19 14:09:11 | 14:09:11 | 2009-10-19 14:09:12 | 18:00:00 | 03:50:49
 |  | [NAME]. | 2009-10-19 14:09:13 | 14:09:13 | 2009-10-20 14:09:14 | 02:09:14 | 12:00:01
 |  |  | 2009-12-01 21:34:30 | 21:34:30 | 2009-12-01 21:34:31 | 21:34:31 | 00:00:01
 |  |  |  |  |  | Total: | 16:39:52
 |  | All properties left on our premises are stored at owner's risk.
Spreadsheet: 707809d1607474356-powerquery-extracted-data-from-website-not-populating-in-designated-cells-excelforum1334778tennispq17
Sheet: Tennis Data

Carpet |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
Timea babos |  | Timea babos | 27 | 357 | 628 | 271 | 0.9 | Carpet | 0.9 | 7243755
[NAME] |  | [NAME] | 27 | 313 | 499 | 186 | 0.6543 | Clay | 0.6719 | 479742
Spreadsheet: 768059d1644821230-tables-referencing-main-table-cant-use-sort-tabels
Sheet: SESTAVA

 | SESTAVA
 | Stari: / |  |  | STRANKA: | Schorch |  |  |  |  |  | (-)
 | Sprememba: 00 |  |  | Risba št.: | 8221950 |  |  |  |  | KOSOV: | 4
 | DN22020078 |  |  | Ime : | Anschlusskasten |  |  |  |  |  | Rok: 6KW
IME | POZ. | DEB. | ŠIRINA | DOLŽINA | KOS. | Material | OPOMBA | NETO IZ SOLID EDGE | Column1 | [NAME] | N.TEŽA | LIST
8118620_01.par | 1 | 25 | 638 | 678 | 1 | S235JR |  | 82.105
8118621_02.par | 2 | 5 | 457 | 680 | 1 | S235JR |  | 3.538
8118623_03.psm | 3 | 5 | 210 | 3000.89 | 1 | S235J2 | upogibanje | 23.285
6304001.par | 5 | 8 | 55 | 80 | 3 | S235J2 |  | 0.144
8221949_07_08_09.par | 7 | 25 | 770 | 1137 | 1 | S235JR |  | 25.703
8118622_10_26.par | 10 | 45 | 158 | 280 | 1 | S235JR |  | 9.355
4137002_12.par | 12 | 40 | 40 | 92 | 3 | S235JR |  | 0.166
4113120_13.par | 13 | 20 | 60 | 660 | 1 | S235JR |  | 6.204
6030414_14.par | 14 | 30 | 25 | 60 | 1 | S235JR | [NAME] [NAME] | 0.327
8118656_20.psm | 20 | 5 | 680 | 1218.14 | 1 | S235J2 | upogibanje | 27.875
8118629_21.psm | 21 | 5 | 145 | 1165 | 1 | S235J2 | upogibanje | 6.603
8221948_22.par | 22 | 8 | 20 | 860 | 2 | S235JR | žaga | 1.078
8221948_22_23_24_25.par | 24 | 25 | 770 | 1137 | 1 | S235JR |  | 26.619
8118622_10_26.par | 26 | 45 | 158 | 280 | 1 | S235JR |  | 9.355
6304001_00.par | 27 | 8 | 55 | 80 | 3 | S235JR |  | 0.141
8218772_28.par | 28 | 10 | 50 | 50 | 1 | S235JR |  | 0.148
8218816_29.psm | 29 | 5 | 145 | 1165 | 1 | S235J2 | upogibanje | 6.542
8218773_30.par | 30 | 8 | 44 | 64 | 1 | S235JR | [NAME] | 0.135
 | MAX |  |  |  |  | [NAME] | SKUPAJ:
Spreadsheet: 267536d1380105625-help-with-lookup-formulae-please-test-2-
Sheet: Riders List

No. | Name | Last Name | Club | Class
1 | [NAME] | Bloggs | witley | Champ
2 | A | Bloggs | Normandy | Champ
3 | B | Bloggs | carshalton | Expert
4 | c | Bloggs | croydon | Expert
5 | d | Bloggs | LFB | Expert
6 | e | Bloggs | [NAME] | Club A
7 | f | Bloggs | witley | Club A
8 | g | Bloggs | Normandy | Club B
9 | h | Bloggs | carshalton | Expert
10 | i | Bloggs | croydon | Champ
11 | jk | Bloggs | LFB | Expert
12 | l | Bloggs | [NAME] | Club B
13 | m | Bloggs | witley | Expert
14 | n | Bloggs | Normandy | Champ
15 | o | Bloggs | carshalton | Vet B
16 | p | Bloggs | croydon | Vet B
17 | q | Bloggs | LFB | Vet A
18 | r | Bloggs | [NAME] | Vet A 50
19 | s | Bloggs | witley | Evo
20 | t | Bloggs | Normandy | Sportsman
21 | u | Bloggs | carshalton | Expert
22 | v | Bloggs | croydon | Expert
23 | w | Bloggs | LFB | Champ
24 | x | Bloggs | [NAME] | Expert
25 | y | Bloggs | witley | Champ
26 | z | Bloggs | Normandy | Sportsman
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 78820d1279125104-date-calculations-example
Sheet: Example

Model | 1 | 2 | 3 | 4 | 5 | 6 | 7
27RLSS | 126 | 196
29RKSA | 21
34QSRL | 109 | 119
34RLSA | 206
35DSRL | 203
Spreadsheet: 158050d1337962102-macro-to-last-row-last-line
Sheet: ورقة1

 | Date | list | amount | Agent
 | 5/1/2012 | 1 | 1500 | Kamal
 | 5/1/2012 | 2 | 2100 | Kamal
 | 6/1/2012 | 3 | 1250 | Kamal
 | 7/1/2012 | 4 | 2105 | Kamal
 | 7/1/2012 | 5 | 1250 | Kamal
 | 15/1/2012 | 18 | 2000 | Ahmed
 | 25/2/2012 | 55 | 4500 | Hamed
Spreadsheet: louise_kitchen__22743__Turbine Position Report 042001
Sheet: Summary by Status

Turbine Position Report |  |  |  |  |  |  | CONFIDENTIAL
Summary by Status
($ MMs) |  |  |  |  |  |  | DRAFT
 |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION COST TO DATE | STATUS
COMMITTED - turbines committed to deals which have been DASHed and financing is in process.
4 | LM6000 |  |  |  |  |  |  | Committed
 |  |  | Total Committed
TENTATIVE - turbines tentatively committed to ONE deal which has not yet been DASHed, but is likely to be.
3 | 9FA STAG power islands |  |  |  |  |  |  | Tentative
1 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
1 | 501D5A simple cycle |  |  |  |  |  |  | Tentative
1 | 7FA |  |  |  |  |  |  | Tentative
2 | 11N1 |  |  |  |  |  |  | Tentative
2 | 7EA |  |  |  |  |  |  | Tentative
2 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
 |  |  | Total Tentative
AVAILABLE - turbines which may be potential matches with SEVERAL deals, none of which have been approved to date.
1 | MHI 501F simple cycle |  |  |  |  |  |  | Available
2 | Fr 6B 60hz power barges (BV=0) |  |  |  |  |  |  | Available
1 | Steam Turbine (BV = 0) |  |  |  |  |  |  | Available
 |  |  | Total Available
NEGOTIATING - turbines for which the purchase is currently being negotiated, but Enron does not yet have control of these turbines.
 |  |  | Total Negotiating
 | UNITS - TOTAL |  | GRAND TOTALS
SCHEDULED VS CANCELLATION PAYMENTS
($ MMs)
*  Total Cancellation Payments = Total Enron Exposure
Spreadsheet: 8c4e7e0d-6434-4e04-a184-b6f50d33bc89
Sheet: Sheet1

Table 6--Wheat: National average prices received by farmers by class (dollars per bushel), 4/11/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | Hard red winter |  | Soft red winter |  | Hard red spring |  | White
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.53 | 7.35 | 6.59 | 6.92 | 7.81 | 7.73 | 6.61 | 7.29
July | 7.74 | 7.04 | 7.84 | 6.55 | 8.41 | 7.29 | 7.76 | 7.19
August | 7.97 | 6.94 | 8.3 | 6.34 | 8.32 | 6.98 | 7.66 | 6.9
September | 8.36 | 6.92 | 8.38 | 6.19 | 8.42 | 6.72 | 7.99 | 6.71
October | 8.43 | 7.24 | 8.35 | 6.66 | 8.6 | 6.85 | 8.1 | 6.76
November | 8.49 | 7.1 | 8.34 | 6.63 | 8.69 | 6.7 | 8.14 | 6.76
December | 8.2 | 6.85 | 8.19 | 6.13 | 8.5 | 6.53 | 7.99 | 7
January | 8.02 | 6.73 | 7.9 | 6.25 | 8.38 | 6.46 | 8.03 | 6.88
February | 7.75 | 6.63 | 7.78 | 5.9 | 8.11 | 6.38 | 8.05 | 6.6
March | 7.5 |  | 7.46 |  | 7.94 |  | 8.05
April | 7.49 |  | 7.42 |  | 7.91 |  | 7.71
May | 7.56 |  | 7.31 |  | 7.86 |  | 7.42
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 4/11/2014
Spreadsheet: 4c902642-7f66-4193-b6ab-73e27f0a4e7c
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40200441 | 2014-02-23 18:05:02 | ALLIES | 1 | 10 | 7 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40201155 | 2014-02-23 18:54:22 | AXIS | 0 | 9 | 10 | 185665 | bteistun | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40307454 | 2014-03-02 01:23:54 | ALLIES | 1 | 10 | 6 | 780030 | keithdone | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40307897 | 2014-03-02 01:58:54 | AXIS | 1 | 10 | 5 | 780030 | keithdone | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 117074d1312428018-summing-specific-non-zero-rows-in-a-table-sample2
Sheet: Case Scenarios

 |  |  |  |  |  |  | Cumm. |  | Cumm | Qtrly
 |  | Randomness |  | No |  |  | Qtr | Qtr | 0
 |  | End of first operating quarter |  |  |  |  | 1 | 4Q11
 |  |  |  |  |  |  |  | 1Q12
 |  | Model Variable #1 |  |  |  |  |  | 2Q12
 |  | Success Rate (out of 10) |  | Return Low | Return High |  |  | 3Q12
 |  | Strong | 3 | 2 | 3 |  |  | 4Q12
 |  | Moderate | 3 | 1.1 | 2 |  |  | 1Q13
 |  | Poor | 1 | 0.8 | 1.1 |  |  | 2Q13
 |  | Fail | 3 | 0 |  |  |  | 3Q13
 |  |  |  |  |  |  |  | 4Q13
 |  |  |  |  |  |  |  | 1Q14
 |  | Model Variable #2 |  |  |  |  |  | 2Q14
 |  | Target Investment Commitment (US$, 000s) |  |  |  |  |  | 3Q14
 |  |  | Annual | Per Qtr |  |  |  | 4Q14
 |  | 2011 | 25000 |  |  |  |  | 1Q15
 |  |  | 30000 |  |  |  |  | 2Q15
 |  |  | 35000 |  |  |  |  | 3Q15
 |  |  | 40000 |  |  |  |  | 4Q15
 |  |  | 45000 |  |  |  |  | 1Q16
 |  | 2016 | 50000 |  |  |  |  | 2Q16
 |  |  |  |  |  |  |  | 3Q16
 |  | Model Variable #3 |  |  |  |  |  | 4Q16
 |  | Per Investment Commitment Limitations (US$, 000s) |  |  |  |  |  | 1Q17
 |  | Min | [NAME] |  |  |  |  | 2Q17
 |  | 1000 | 6000 |  |  |  |  | 3Q17
 |  |  |  |  |  |  |  | 4Q17
 |  | Model Variable #4 |  |  |  |  |  | 1Q18
 |  | Length of Case (Quarters) |  |  |  |  |  | 2Q18
 |  | Min | [NAME] |  |  |  |  | 3Q18
 |  | 6 | 12 |  |  |  |  | 4Q18
 |  |  |  |  |  |  | Potential | Actual | 1
 |  | Case | Commencement | Investment | Length ([NAME]) | Success | Payout | Payout | IRR | 4Q11 | 1Q12 | 2Q12 | 3Q12 | 4Q12 | 1Q13 | 2Q13 | 3Q13 | 4Q13 | 1Q14 | 2Q14 | 3Q14 | 4Q14 | 1Q15 | 2Q15 | 3Q15 | 4Q15 | 1Q16 | 2Q16 | 3Q16 | 4Q16 | 1Q17 | 2Q17 | 3Q17 | 4Q17 | 1Q18 | 2Q18 | 3Q18 | 4Q18
 |  | 1
 |  |  | 0.3 |  | Strong |  | Total Investments in Qtr
 |  |  | 0.4 |  | Moderate |  | Total Receipts
 |  |  | 1.4 |  | Poor |  | Net Qtrly Cash Flows
 |  |  | 0.3 |  | Fail |  | Cummulative Cash Flows
 |  |  |  |  |  |  | Committed Capital
 |  |  |  |  |  |  | Disbursed Capital
 |  |  | Investment Allocation
 |  |  | Quarters | 1
 |  |  | 4 | 0.2 | 0.2 | 0.2 | 0.4
 |  |  |  | 0.08 | 0.12 | 0.18 | 0.23 | 0.39
 |  |  |  | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.35
 |  |  |  | 0.03 | 0.05 | 0.1 | 0.15 | 0.15 | 0.2 | 0.32
 |  |  |  | 0.025 | 0.055 | 0.08 | 0.09 | 0.14 | 0.14 | 0.19 | 0.28
 |  |  |  | 0.021 | 0.039 | 0.06 | 0.09 | 0.1 | 0.12 | 0.15 | 0.17 | 0.25
 |  |  |  | 0.02 | 0.04 | 0.05 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.16 | 0.23
 |  |  |  | 0.015 | 0.02 | 0.03 | 0.045 | 0.06 | 0.08 | 0.1 | 0.12 | 0.14 | 0.18 | 0.21
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.05 | 0.065 | 0.08 | 0.105 | 0.12 | 0.15 | 0.16 | 0.19
 |  |  |  | 0.005 | 0.015 | 0.025 | 0.035 | 0.045 | 0.055 | 0.07 | 0.08 | 0.1 | 0.12 | 0.13 | 0.15 | 0.17
 |  |  |  | 0.005 | 0.015 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.085 | 0.105 | 0.11 | 0.13 | 0.13 | 0.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is the total of the yellow highlighted cells | 23994
Spreadsheet: michael_maggi__26471__NYMEXWEEKLYSTATS
Sheet: ng

 |  |  |  |  |  |  |  | 0..
Week Ending: | 2001-01-14 00:00:00
 | Futures Settlement Prices (in  $/MMBtu)
 | HENRY HUB NATURAL GAS |  |  |  |  | Contract Symbol:  NG
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-14 00:00:00 | 2001-01-15 00:00:00 | 2001-01-16 00:00:00 | 2001-01-17 00:00:00 | 2001-01-18 00:00:00 | Interest
 | 2002-02-01 00:00:00 | 2.25 | 2.291 | 2.394 | 2.254 | 2.236 | 63668
 | 2002-03-01 00:00:00 | 2.24 | 2.273 | 2.363 | 2.254 | 2.236 | 60850
 | 2002-04-01 00:00:00 | 2.277 | 2.303 | 2.383 | 2.291 | 2.279 | 39347
 | 2002-05-01 00:00:00 | 2.348 | 2.368 | 2.446 | 2.359 | 2.352 | 30562
 | 2002-06-01 00:00:00 | 2.413 | 2.428 | 2.506 | 2.419 | 2.412 | 27759
 | 2002-07-01 00:00:00 | 2.483 | 2.493 | 2.566 | 2.489 | 2.48 | 20182
 | 2002-08-01 00:00:00 | 2.528 | 2.538 | 2.606 | 2.535 | 2.526 | 19397
 | 2002-09-01 00:00:00 | 2.532 | 2.536 | 2.599 | 2.536 | 2.529 | 16203
 | 2002-10-01 00:00:00 | 2.557 | 2.558 | 2.621 | 2.557 | 2.552 | 32044
 | 2002-11-01 00:00:00 | 2.762 | 2.763 | 2.816 | 2.767 | 2.772 | 21885
 | 2002-12-01 00:00:00 | 2.967 | 2.96 | 3.011 | 2.962 | 2.972 | 14603
 | 2003-01-01 00:00:00 | 3.057 | 3.042 | 3.093 | 3.044 | 3.057 | 18318
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 484518
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | [NAME]
 | 5 Day Hist. Vol. |  |  | 0.7178
 | 20 Day Hist. Vol. |  |  | 0.8562
 | Implied Volatility-Options |  |  | [NAME]
 | At the Money Call & Put |  |  | 0.7524
 | MON | TUE | WED | THUR | FRI | Total
Trading Volume | 104555 | 78218 | 86451 | 124022 | 58865
EFS Volume | 5688 | 1560 | 3695 | 1200 | 426
Spreadsheet: 36677d1234542855-pivoting-text-test
Sheet: Result

 | XRef1 | XRef2 | XRef3 | XRef4 | XRef5 | XRef6 | XRef7 | XRef8 | XRef9 | XRef10 | XRef11 | XRef12 | XRef13 | [NAME] | XRef15 | XRef16 | XRef17 | XRef18 | XRef19
Part1 | CompPart1
Part2 |  | [NAME]
Part3 |  |  | CompPart3
Part4 |  |  |  | [NAME]
Part5 |  |  |  |  | CompPart5
Part6 |  |  |  |  |  | [NAME]
Part7 |  |  |  |  |  |  | CompPart7
Part8 |  |  |  |  |  |  |  | CompPart8
Part9 |  |  |  |  |  |  |  |  | CompPart9
Part10 |  |  |  |  |  |  |  |  |  | CompPart10
Part11 |  |  |  |  |  |  |  |  |  |  | CompPart11
Part12 |  |  |  |  |  |  |  |  |  |  |  | CompPart12
Part13 |  |  |  |  |  |  |  |  |  |  |  |  | CompPart13
Part14 |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart14
Part15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart15
Part16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart16
Part17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart17
Part18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart18
Part19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CompPart19
Spreadsheet: 841978d1694087648-change-the-second-transaction-entry-ticket-no-wise-same-ticket-id-with-followup-ticket
Sheet: Sheet1

Ticket no | Query | Output
60001 | Abcs
60002 | [NAME]
60001 | ddd
60002 | ddd
60001 | dd
60003 | kkk
Spreadsheet: 216111d1361590541-help-with-match-and-offset-funcitions-together-example
Sheet: All list

 | City 1 | a
 | City 3 | b
 | City 2 | c
 | City 6 | d
 | City 4 | e
 | City 1 | f
 | City 3 | g
 | City 2 | h
 | City 6 | i
 | City 4 | j
 | City 1 | k