tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40442__OM EST - OSS - 2001 - 2002 REVISED FORMAT
Sheet: Orig '02 Plan Gross

ORIGINAL '02 PLAN GROSS  O & M COSTS
(including Benefits & Payroll Taxes)
OPERATIONS SUPPORT SERVICES (Included in Finance & Accounting)
( $ In Thousands)
 |  |  |  |  |  |  |  |  |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross O&M |  | Gross |  | Gross
 |  |  |  |  |  |  |  |  |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | % O(U) |  | 2002 |  | 2002
Department |  |  |  |  |  |  |  |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | 2000 Plan |  | Dec |  | Sum
NNG
TW
Citrus
Northern Border Partners
EOTT (Co 1195) **
[NAME]
GCO/HPL
EAMR |  |  |  |  |  |  |  |  |  | 312.71 |  | 307.863 |  | 314.823 |  | 315.848 |  | 313.273 |  | 314.018 |  | 307.573 |  | 307.718 |  | 316.353 |  | 322.623 |  | 308.363 |  |  |  | 312.383
ETS
Other *
Total
* For companies outside of ETS
**  Exclude Co. 1195
Spreadsheet: 36892d1234866109-advanced-conditional-formatting-and-pivot-tables-pivot_table
Sheet: PIVOT_TABLE

Sum of STOCK
PRODUCT FAMILY | PRODUCT | Total
FRUIT | APPLE | 100
 | BANANA | 200
 | ORANGE | 50
FRUIT Total |  | 350
MISC | MILK | 10
 | VODKA | 500
MISC Total |  | 510
VEGETABLE | CARROT | 30
 | ONION | 30
 | PATATO | 30
VEGETABLE Total |  | 90
Grand Total |  | 950
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 7

 | Nov 9 | Nov 16 | Nov 23 | Nov 30 | Dec 7
Total Interest Rates* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 832842d1686637172-find-the-longest-word-example-21-1-1-
Sheet: Sheet1

ARWEN | OLORIN |  |  |  |  |  |  | Available letters |  | A | L | D | F | V | A | N | G
GALADRIEL | SARUMAN
CELEBORN | GLAMDRING |  |  |  |  |  |  | RESULT
GANDALFI | SHINE
PIPPIN | BAGGINS
TREEBEARD | GOLLUM
BARAHIR | SAURON
BILBO | ELROND
ARAGORN | LAVA |  |  |  | LAVA
SHELOB
ANDUIN
MITHRANDIR
Spreadsheet: 219175d1362677781-mulitple-currency-calculation-quotelog-mereelec-oeldere-
Sheet: Diptronic

Exchange rate | USD | 1.47
Exchange rate | EUR | 1.13
Exchange rate | GBP | 1
Customer | Contact | Rep | Date | Month | Part | Manufacturer | Quantity | Currency sale | Sale price | Currency Cost | Cost | Sales value | Profit £ |  | Sale price
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | USD | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | USD | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | EUR | 2 | GBP | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | USD | 2 | GBP | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
Spreadsheet: 803581d1667558495-explain-a-formula-to-me-40-radial-spread-formulaexplanation
Sheet: Sheet1

 | Minimum | Q1 | Target | Q3 | Maximum | Spread
Hourly |  |  | 56.83 |  |  | 0.4
Annual
Spreadsheet: 86379d1286375834-counting-blocks-of-data-in-a-row-record-absexample
Sheet: Sheet1

3451 - Smith , AE
January | 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 | Total Days | Occurences
ABSENCE CODE |  | UL | WW | U | U |  |  | B | B | B |  |  |  |  | W | W | W | W |  |  | L | L | L | L | L | L |  |  |  |  |  | 17 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need to be able to count the total number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | of absences. In the above example, 6 absences
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | should be recorded/
Spreadsheet: 41787d1240316620-validation-drop-down-dependent-upon-another-cell-value-example
Sheet: Index

D
14 |  |  |  |  | A | B | C | D
 |  |  | A |  | 1 | 5 | 9 | 13
 |  |  | B |  | 2 | 6 | 10 | 14
 |  |  | C |  | 3 | 7 | 11 | 15
 |  |  | D |  | 4 | 8 | 12 | 16
Spreadsheet: david_delainey__8082__epgofferanalysis (9-25-00)
Sheet: Sheet1

El Paso Offer Analysis
Current Proposal
Payment Dates |  |  |  | 2000-12-31 00:00:00 | 2001-11-15 00:00:00 | 2002-11-15 00:00:00 | 2003-11-15 00:00:00 | 2004-11-15 00:00:00 | 2005-11-15 00:00:00 | 2006-11-15 00:00:00 | 2007-11-15 00:00:00 | 2008-11-15 00:00:00 | 2009-11-15 00:00:00 | 2010-11-15 00:00:00 | 2011-11-15 00:00:00 | 2012-11-15 00:00:00
Deferred Payments |  |  |  | 0 | 17049.6
 | Payment Escalator |  |  | 0.05
 | PV |  | 0.0825 |  |  | 150087.4858308182
Scheduled Payments |  |  |  | 0 | 5666.667 | 5666.667 | 5666.667
 | PV |  |  |  |  | 14745.88234257822
New Contingent Payment Dates |  |  |  |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 |  | 2013-12-31 00:00:00
Available Restructuring MW's
 | Linden |  |  |  | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678 | 678
 | Bayonne |  |  |  | 176 | 176 | 176 | 176 | 176 | 176 | 176 | 176 | 0 | 0 | 0 | 0
 | Camden |  |  |  | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146
 |  | Total
Restructuring Payment $/kw |  |  |  |  | 35
 | Payment Escalator |  |  |  |  | 0.12 | 0.12 | 0.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New Contingent Payments |  |  |  | 0
 | PV |  | 0.116 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Offer Value
Probability |  |  |  |  | 0.1 | 0.4 | 0.2 | 0.15 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05
Probablilty Adjusted
Exercie Price Computation |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Implied Exercise Price Immediately
 | Following Payment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: michelle_lokay__26774__CREL_MARKET_2001
Sheet: Inventory of Shippers for Deals

Inventory of Possibilities
 |  | Offer
Shipper | MDQ | Demand(cents/d) | Commodity
Dynegy | 295000 | 1.5/1.75 | min
Duke | 60,000-80,000 | 2 | min | year round
 | up to 140,000 | 1 | min | summer
ENA | 295000 | 4/.5 | [NAME]
Cross Timbers | 3500
Oneok | ?
Multiple |  | spread
Anadarko
[NAME]
CMS
E Prime
Engage
Producers | 25000-30000
Transcanada
WGR
[NAME]
Spreadsheet: 763551d1642238235-search-multiple-criteria-and-return-multiple-values-within-the-same-cell-schedule-test-copy
Sheet: Sheet1

Job no | Task | date
J001829 | CABINETS & LAMINATE BENCHTOP | 2022-01-04 00:00:00
J001766 | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2022-01-18 00:00:00
J001921 | CABINETS & LAMINATE BENCHTOP | 2022-01-20 00:00:00
[NAME] | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2022-01-21 00:00:00
J001852 | CLADDING / WALL SHEETING | 2022-01-22 00:00:00
[NAME] | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2022-01-25 00:00:00
[NAME] | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2022-01-27 00:00:00
J001766 | CABINETS & LAMINATE BENCHTOP | 2022-01-28 00:00:00
[NAME] | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2021-02-01 00:00:00
J001854 | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2021-02-01 00:00:00
J001854 | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2021-02-01 00:00:00
[NAME] | CABINETS & LAMINATE BENCHTOP | 2022-02-02 00:00:00
J001852 | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2022-02-03 00:00:00
J001854 | BASE -  CONCRETE SLAB / STEEL CHASSIS | 2022-02-04 00:00:00
[NAME] | CABINETS & LAMINATE BENCHTOP | 2022-02-04 00:00:00
J001921 | CLADDING / WALL SHEETING | 2022-02-05 00:00:00
[NAME] | CABINETS & LAMINATE BENCHTOP | 2022-02-08 00:00:00
J001854 | CLADDING / WALL SHEETING | 2022-02-09 00:00:00
[NAME] | CLADDING / WALL SHEETING | 2022-02-11 00:00:00
J001854 | CABINETS & LAMINATE BENCHTOP | 2022-02-14 00:00:00
J001854 | CABINETS & LAMINATE BENCHTOP | 2022-02-16 00:00:00
J001854 | CABINETS & LAMINATE BENCHTOP | 2022-02-21 00:00:00
[NAME] | CABINETS & LAMINATE BENCHTOP | 2021-02-28 00:00:00
J001852 | CABINETS & LAMINATE BENCHTOP | 2021-02-28 00:00:00
J001766 | CLADDING / WALL SHEETING | 2021-02-10 00:00:00
[NAME] | CLADDING / WALL SHEETING | 2021-02-11 00:00:00
[NAME] | CLADDING / WALL SHEETING | 2021-02-12 00:00:00
[NAME] | CLADDING / WALL SHEETING | 2021-02-13 00:00:00
J001854 | CLADDING / WALL SHEETING | 2021-02-14 00:00:00
J001852 | CLADDING / WALL SHEETING | 2021-02-15 00:00:00
J001854 | CLADDING / WALL SHEETING | 2021-02-16 00:00:00
Spreadsheet: 795753d1662907821-list-all-instances-where-a-specific-digit-is-contained-in-text-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | First data | Second | Third | …
 |  | Data |  | Word | Grouped data | Highest Number | Data Associated |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | ABSOLUT  AE2 B S AH0 L UW1 T
 | ABSOLUT'S  AE2 B S AH0 L UW1 T S
 | ABSOLUTE  AE1 B S AH0 L UW2 T
 | ABSOLUTELY  AE2 B S AH0 L UW1 T L IY0
 | ABSOLUTENESS  AE1 B S AH0 L UW2 T N AH0 S
 | ABSOLUTES  AE1 B S AH0 L UW2 T S
 | ABSOLUTION  AE2 B S AH0 L UW1 SH AH0 N
 | ABSOLUTISM  AE1 B S AH0 L UW2 T IH2 Z AH0 M
 | ABSOLUTIST  AE0 B S AH0 L UW1 T IH0 S T
Spreadsheet: 149502d1333994101-remove-duplicate-entries-based-on-unique-number-excel-2000-002
Sheet: Φύλλο1

Numbers | [NAME]
12 | 1
3 | 2
4 | 3
1 | 4
2 | 5
3 | 6
4 | 7
5 | 8
67 | 9
8 | 11
9 | 12
13 | 13
4 | 14
5 | 15
6 | 67
7
9
2
4
6
8
0
9
5
1
8
11
13
14
15
15
14
13
2
4
6
8
9
8
Spreadsheet: 847002d1698113130-help-with-projections-money-projections-help-v2
Sheet: Variables

 | Update the VARIABLES here if/when required
 |  |  |  |  | Leave Type | Hrs / year | Accrual % | Leave Provision
 | 0.11 | Super Contribution ( % ) |  |  | Annual Leave: 4 wks
 | 7.5 | Shift Care (per worker) |  |  | Personal Leave: 2 wks
 | 0.0283 | SAFE Work SA ( % ) |  |  | LSL: 1.3 wks (13 wks of 10 yrs)
 | 65.47 | Service Cost Weekday
 | 92.12 | Service Cost Saturday
 | 118.78 | Service Cost Sunday
 | 0.4 | Saturday Loading ( % )
 | 0.8 | Sunday Loading ( % )
Spreadsheet: 525531d1498761870-vacation-day-formulas-time-off-calendar-help-forum
Sheet: 2017

VACATION - 2017 |  |  |  |  |  |  |  |  |  |  | Name:
Start Date |  |  |  |  |  | 2016-07-05 00:00:00 |  |  |  | Today's Date
Balance 2016 Vacation Days |  |  |  |  |  |  | 6 |  |  | Balance 2016 Sick Hours: |  |  |  |  |  | 59.75
Total Vacation Days (since start date): |  |  |  |  |  |  |  |  |  | Total Sick Hours (since start date):
Total Vacation Days Taken 2016: |  |  |  |  |  |  | 0 |  |  | Paid Sick Hours Taken (2016): |  |  |  |  |  | 2.25
Vacation Days Taken 2017: |  |  |  |  |  |  |  |  |  | Paid Sick Hours Taken (2017): |  |  |  |  |  |  |  | STOP Hours Taken:
Total Vacation Days Taken: |  |  |  |  |  |  |  |  |  | Total Sick Hours Taken: |  |  |  |  |  |  |  | Total STOP Hours: |  |  |  |  | 8
Remaining Vacation Days |  |  |  |  |  |  |  |  |  | Total Remaining Sick Hours: |  |  |  |  |  |  |  | Remaining Stop Hours:
2017 | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1
1
2 | HOLIDAY
3 |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY
4 |  |  |  |  |  |  |  |  | V | 1 |  |  | HOLIDAY
5 |  |  |  |  |  |  |  |  | V | 1
6
7
8 |  |  |  |  | V | 1
9
10
11
12
13 | ST | 1.5 | V | 1 | S | 7.75
14 |  |  | V | 1 | S | 7.75 |  |  |  |  | S | 1.5
15 |  |  | V | 1 | S | 7.75
16 |  |  | V | 1 | S | 5.75
17 |  |  | V | 1 | S | 5
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY |  | HOLIDAY
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY |  | HOLIDAY
26
27
28
29
30
31 | S | 1
TOTALS
Vacation
Sick (hrs)
STOP (hrs)
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Yvan Denie

Maand
 | 2020-01-06 00:00:00 | 2020-01-20 00:00:00 | 2020-02-05 00:00:00 | 2020-02-24 00:00:00 | 2020-03-11 00:00:00 | 2020-03-23 00:00:00
 | om 11u | 11u | 14u | 11u | Let it be | 11u
 | Let it be oefenen! | LET IT BE | let it be | let it be | Toonladders
 |  |  | toonladder links . + rechts | toonladder links . + rechts | And i love her
 |  |  | arpeggio rechts duim wijsvinger middelvinger | arpeggio rechts duim wijsvinger middelvinger
 | cash | cash | cash | CASH | cash
 | Totaal aantal lessen
 | let it be
 | ritme oef
 | The sound of silence
 | 30 |  | maand
 |  | Januari
 |  | Februari
 |  | [NAME]
 |  | april
 |  | mei
 |  | juni
 |  | [NAME]
 |  | augustus
 |  | september
 |  | oktober
 |  | november
 |  | december
 | cash
Spreadsheet: 88728d1288596693-charting-date-book1
Sheet: Sheet2

 |  |  |  |  | 2010-01-01 00:00:00 | 3 | 1
 |  |  |  |  | 2010-01-10 00:00:00 | 4 | 1
 |  |  |  |  | 2010-01-19 00:00:00 | 8 | 1
 |  |  |  |  | 2010-01-28 00:00:00 | 8 | 1
 |  |  |  |  | 2010-02-06 00:00:00 | 10 | 2
 |  |  |  |  | 2010-02-15 00:00:00 | 2 | 2
 |  |  |  |  | 2010-02-24 00:00:00 | 5 | 2
 |  |  |  |  | 2010-03-05 00:00:00 | 2 | 3
 |  |  |  |  | 2010-03-14 00:00:00 | 8 | 3
 |  |  |  |  | 2010-03-23 00:00:00 | 5 | 3
 |  |  |  |  | 2010-04-01 00:00:00 | 9 | 4
 |  |  |  |  | 2010-04-10 00:00:00 | 10 | 4
 |  |  |  |  | 2010-04-19 00:00:00 | 9 | 4
 |  |  |  |  | 2010-04-28 00:00:00 | 4 | 4
 |  |  |  |  | 2010-05-07 00:00:00 | 7 | 5
 |  |  |  |  | 2010-05-16 00:00:00 | 9 | 5
 |  |  |  |  | 2010-05-25 00:00:00 | 10 | 5
 |  |  |  |  | 2010-06-03 00:00:00 | 4 | 6
 |  |  |  |  | 2010-06-12 00:00:00 | 6 | 6
 |  |  |  |  | 2010-06-21 00:00:00 | 1 | 6
 |  |  |  |  | 2010-06-30 00:00:00 | 7 | 6
 |  |  |  |  | 2010-07-09 00:00:00 | 3 | 7
 |  |  |  |  | 2010-07-18 00:00:00 | 8 | 7
 |  |  |  |  | 2010-07-27 00:00:00 | 8 | 7
 |  |  |  |  | 2010-08-05 00:00:00 | 4 | 8
 |  |  |  |  | 2010-08-14 00:00:00 | 3 | 8
 |  |  |  |  | 2010-08-23 00:00:00 | 9 | 8
 |  |  |  |  | 2010-09-01 00:00:00 | 1 | 9
 |  |  |  |  | 2010-09-10 00:00:00 | 9 | 9
 |  |  |  |  | 2010-09-19 00:00:00 | 8 | 9
 |  |  |  |  | 2010-09-28 00:00:00 | 6 | 9
 |  |  |  |  | 2010-10-07 00:00:00 | 6 | 10
 |  |  |  |  | 2010-10-16 00:00:00 | 3 | 10
Spreadsheet: 3c8be800-59dc-4f4c-94d9-8cf7bc861c07
Sheet: Fig2B (inset)

Ave_PropTimeOut | catch#1
0.406743297 | 1
0.156281064 | 2
0.35081426 | 3
0.062357123 | 4
0.656536618 | 5
0.137704178 | 6
0.12205108 | 7
0.419644508 | 8
0.0234975 | 9
0.449247377 | 10
0.675644731 | 11
0.320586391 | 12
0.427913884 | 13
0.168624974 | 14
0.248931649 | 15
0.079064351 | 16
0.275542832 | 17
0.064747007 | 18
0.11719979 | 19
0.071305228 | 20
0.135090614 | 21
0.167295279 | 22
0.1055767 | 23
0.197210628 | 24
0.429572854 | 25
0.146376453 | 26
0.125743134 | 27
0.074816471 | 28
0.048134 | 29
0.003418 | 30
0.19802301 | 31
0.228376157 | 32
0.111422001 | 33
0.041260558 | 34
0.060712349 | 35
0.065596457 | 36
0.089555234 | 37
0.099572137 | 38
0.041427335 | 39
0.224078526 | 40
0.075574536 | 41
0.09672397 | 42
0.176831833 | 43
0.140210111 | 44
0.141564389 | 45
0.101431722 | 46
0.09453575 | 47
0.050657911 | 48
Spreadsheet: 108962d1305889623-vlookup-multiple-queries-visit
Sheet: Visits

Client ID | Dates Visited | Place Visited | Rep
1 | 2010-12-12 00:00:00 | Cardiff
2 | 2010-12-13 00:00:00 | Swansea
3 | 2010-12-14 00:00:00 | London
4 | 2010-12-15 00:00:00 | Cardiff
5 | 2010-12-16 00:00:00 | Cardiff
1 | 2010-12-17 00:00:00 | London
1 | 2010-12-18 00:00:00 | Swansea
2 | 2010-12-19 00:00:00 | Cardiff
5 | 2010-12-20 00:00:00 | Liverpool
 |  | Count of Dates Visited
 |  | Client ID | Rep | Place Visited | Total
 |  | 1 | Ford | Cardiff | 1
 |  |  |  | London | 1
 |  |  |  | Swansea | 1
 |  |  | Ford Total |  | 3
 |  | 2 | Jones | Cardiff | 1
 |  |  |  | Swansea | 1
 |  |  | Jones Total |  | 2
 |  | 3 | Evans | London | 1
 |  |  | Evans Total |  | 1
 |  | 4 | Smith | Cardiff | 1
 |  |  | Smith Total |  | 1
 |  | 5 | Robbs | Cardiff | 1
 |  |  |  | Liverpool | 1
 |  |  | Robbs Total |  | 2
 |  | Grand Total |  |  | 9
Spreadsheet: 700907d1603396586-help-creating-referenced-list-example-values
Sheet: Occurance By Year

 |  | Year
 | YR 1st Release | YR1 | YR2 | [NAME] | YR4 | YR5 | YR6 | YR7 | YR8 | YR9 | YR10 | YR11 | Total
Variable A | YR1
Variable B | YR1
Total
Spreadsheet: 137229d1327006400-fix-formulas-so-there-are-no-duplicates-copy_dummy-file-formulas-made-duplicates
Sheet: How It Should Look

Name |  | Company | Purpose | Start Date | End Date
Date | Payee | Type of Expense | Purpose | Individuals/Companies | Amount
2011-12-19 00:00:00 | Chipotle | Business Reimbursables:Dining | Lunch with Associate | [NAME] | -8.59
2011-12-29 00:00:00 | Wal-Mart | Business Reimbursables:Entertainment | Video Game Controller | [NAME] | -60.66
2011-12-30 00:00:00 | [NAME]'s Linens | Business Reimbursables | Home Repair | [NAME] | -17.26
2011-12-30 00:00:00 | [NAME] | Business Reimbursables:Dining | Dinner for team | [NAME] | -43.2
2012-01-03 00:00:00 | Verizon Wirless | Business Reimbursables | Cell Phone Payment |  | -100
2012-01-03 00:00:00 | Enterprise Rent-a-Car | Business Reimbursables:Transportation | [NAME] | [NAME] | -150
I CERTIFY THAT THE ABOVE EXPENSES HAVE BEEN INCURRED BY ME ONLY ON BEHALF OF THE COMPANY AND HAVE NOT BEEN PREVIOUSLY PAID OR REIMBURSED BY THE COMPANY.
 |  |  |  | Balance Due Employee:
Signature of Employee |  |  |  | Date
Approval by Immediate Supervisor |  |  |  | Date
Spreadsheet: john_griffith__15618__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.55 | 0.455 | 0.475 | 0.5002999999999987 | 0.02549999999999725
 | N | 4.65 | 0.71 | 0.73 | 0.5003000000000006 | 0.006599999999999273
 | Q | 4.7 | 0.9 | 0.93 | 0.5095000000000007 | 0.01109999999999878
 | U | 4.75 | 1.085 | 1.1 | 0.5152000000000009 | 0.006599999999999273
 | V | 4.8 | 1.215 | 1.245 | 0.519000000000001 | 0.00299999999999967
 | X | 4.95 | 1.39 | 1.43 | 0.5265000000000015 | -0.0005999999999999339
 | Z | 5.15 | 1.58 | 1.62 | 0.5336000000000009 | -0.0005999999999999339
 | F | 5.2 | 1.73 | 1.77 | 0.542000000000001 | 0.001499999999999835
 | G | 5.05 | 1.78 | 1.82 | 0.5435000000000012 | 0.006599999999999273
 | H | 4.85 | 1.6 | 1.7 | 0.4931000000000004 | 0.002699999999999703
 | J | 4.5 | 1.18 | 1.28 | 0.3785000000000008 | -0.005099999999999438
 | K | 4.4 | 1.1 | 1.2 | 0.3518000000000017 | 0.004199999999999537
 |  |  | 2001-05-02 12:11:52.050000
Spreadsheet: 681645d1591684789-how-to-use-match-function-and-get-result-as-ture-if-condition-is-true-then-match-function-auto-parts-1-
Sheet: Sheet1

item number. | searchbox | parts no. |  | In stock/out of stock | item no. refrence > | table no.
1 | 7 | 12 | 26 |  | 1 | 2 | 3 | 4 | 10 | 9 | 8
2 | 5 | 25 | 11 |  | 2 | 3 | 4 | 5 | 1 | 8 | 7
3 | 2 | 99 | 9 |  | 3 | 4 | 5 | 6 | 2 | 7 | 6
4 | 2 | AB | CD |  | 4 | 5 | 6 | 7 | 3 | 6 | 5
5 | 2 | 12 | 36 |  | 5 | 6 | 7 | 8 | 4 | 5 | 4
6 | 3 | 11 | 24 |  | 6 | 7 | 8 | 9 | 5 | 4 | 3
7 | 10 | 2 | 6 |  | 7 | 8 | 9 | 10 | 6 | 3 | 2
8 | 9 | 44 | 77 |  | 8 | 9 | 10 | 11 | 7 | 2 | 1
9 |  |  |  |  | 9 | 10 | 1 | 2 | 8 | 1 | 0
10 |  |  |  |  | 10 | 1 | 2 | 3 | 9 | 10 | -1