tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142038d1329594641-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: Travelers

 |  | WEEK 12 Travelers Championship
 |  | Total Earnings |  |  |  | Rankings Through Week 12 | Total
 | [NAME] | 0 |  | 2 |  | [NAME]
 | [NAME] | 5000 |  | 1 |  | [NAME]
 | [NAME] | 0 |  | 3 |  | [NAME]
 |  | 0 |  | 4 |  | 0
 |  | 0 |  | 5 |  | 0
 |  | 0 |  | 6 |  | 0
 |  | 0 |  | 7 |  | 0
 |  | 0 |  | 8 |  | 0
 |  | 0 |  | 9 |  | 0
 |  | 0 |  | 10 |  | 0
 |  | 0 |  | 11 |  | 0
 |  | 0 |  | 12 |  | 0
 |  | 0 |  | 13 |  | 0
 |  | Travelers |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: 148036d1333112219-excel-2007-if-function-for-revenue-bc-drafting
Sheet: Apprenticeship Pipeline 

 |  |  |  |  |  |  | TARGET
Apprenticeship Pipeline |  |  |  |  |  |  | Sign Ups Pipeline
 |  |  |  |  |  |  | Sign Ups Booked
 |  |  |  |  |  |  | Job Spec
 |  |  |  |  |  |  | Booked on Induction
 |  |  |  |  |  |  | Revenue Pipeline
 |  |  |  |  |  |  | Revenue Generated
Sign up Date | Company Name | Centre | Telesales Rep | Sign ups Pipeline | Sign Ups  Booked | Job Spec | Booked on Induction | Course | Revenue Pipeline | Revenue Generated
2012-02-25 00:00:00 | A2B Transport | Middlesbrough |  | 22 |  |  |  | Warehousing and Storage (19+)
Spreadsheet: 143998d1330661068-need-to-eliminate-blank-lines-in-vlookup-results-card
Sheet: Summary

Sold Cards |  |  |  |  |  |  |  | Reallocated Cards
Control # | Sold to | $$ Sold | Paid | $$ Profit | % Profit |  |  | Control # | Date | Reallocated to | Balance | Paid
Spreadsheet: 107356d1304539285-searching-multiple-columns-and-returning-data-from-single-smaller-column-april-spec-test
Sheet: Sheet1

Year | Date | Day | HE | OR | Delta | company | Net Profit long | Net Profit Short | daily return |  |  |  |  |  |  |  | HE | Node | Position
2007 | 2011-04-01 00:00:00 | Sunday | 1 | 1.2 | 0.5 | AECO |  |  |  |  |  |  |  |  |  |  | 1 | AECO | -1
2007 | 2011-04-01 00:00:00 | Sunday | 1 | 1.2 | 0.4 | AEP |  |  |  |  |  |  |  |  |  |  | 1 | AEP | 1.5
2007 | 2011-04-01 00:00:00 | Sunday | 2 | 1.2 | -0.4 | AECO |  |  |  |  |  |  |  |  |  |  | 2 | AECO | 0
2007 | 2011-04-01 00:00:00 | Sunday | 2 | 1.2 | -4 | AEP |  |  |  |  |  |  |  |  |  |  | 2 | AEP | 0
2007 | 2011-04-01 00:00:00 | Sunday | 3 | 1.2 | -0.98 | AECO |  |  |  |  |  |  |  |  |  |  | 3 | AECO | -2
2007 | 2011-04-01 00:00:00 | Sunday | 3 | 1.2 | 2 | AEP |  |  |  |  |  |  |  |  |  |  | 3 | AEP | 2
2007 | 2011-04-02 00:00:00 | Monday | 1 | 1.2 | 1 | AECO
2007 | 2011-04-02 00:00:00 | M onday | 1 | 1.2 | 1.5 | AEP
2007 | 2011-04-02 00:00:00 | Monday | 2 | 1.2 | -1 | AECO
2007 | 2011-04-02 00:00:00 | M onday | 2 | 1.2 | -2 | AEP
2007 | 2011-04-02 00:00:00 | Monday | 3 | 1.2 | -0.5 | AECO
2007 | 2011-04-02 00:00:00 | Monday | 3 | 1.2 | 2 | AEP
Spreadsheet: 153325d1335874909-excel-2007-counting-individual-cells-in-a-row-skips_ladies-11-12
Sheet: My Report

NAME | CLUB |  | TOTAL | TOTAL |  | Games
 |  |  | POINTS | SHOTS |  | Played | Won | Lost | [NAME] | %
Spreadsheet: 7480ef6a-c76d-4e12-86c6-b83154898adc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Financial and Administrative Services
PETTY CASH/FLOAT CONFIRMATION
April 2013
Please complete this form and return to [NAME], Financial Services, by April 26, 2013
 | Petty Cash/Cash Float Custodian:
 | Department:
 | Total Value of Petty Cash/Float: |  |  | $
 | + total cash on hand |  |  | $
 | + total unremitted original receipts |  |  | $
 | CERTIFICATION
 | I acknowledge that I am the custodian of the Petty Cash/Cash Float for the above department.
 | PETTY CASH/CASH FLOAT CUSTODIAN
 | Print Name: |  |  | Title:
 | Signature: |  |  | Date:
 |  |  |  |  |  | [NAME]/dd/yyyy
 | AUTHORIZED [NAME]
 | Print Name: |  |  | Title:
 | Signature: |  |  | Date:
 |  |  |  |  |  | [NAME]/dd/yyyy
Spreadsheet: 695650d1600329571-pivottable-formula-that-uses-values-from-pivot-table-book1
Sheet: Pivot

Row Labels | Sum of % | Count of X | Sum of Field1 | This calculation I want to include in the pivot…
A | 0.168 | 7 | 3.058438012015292e-05
B | 0.1217 | 7 | 0.0001316672076165747
C | 0.4233 | 11 | 8.55549042989672e-05
D | 0.05770000000000002 | 4 | 0.0001383361304243587
Grand Total | 0.7706999999999998 | 29 | 6.541278719413346e-05
Spreadsheet: 121426d1316045123-excel-2007-references-to-ranges-sending-coopy
Sheet: Joy1

Check Date | INVOICE |  | DRIVER | INV AMT | RAA 15% DISCT | RAA 15% DISCT | SUBTOT | [NAME] | PACWEST 15% /18% FEE | DRIVER PAY AMT
2011-08-11 00:00:00 |  |  |  | hide | hide | hide | hide |  | hide
2011-07-28 00:00:00 | 120915 |  | Joy | 95
2001-08-02 00:00:00 | 120923 |  | Joy | 120
2011-08-02 00:00:00 | 120923 | a | Joy
2011-08-02 00:00:00 | 120924 |  | Joy | 85
2011-08-02 00:00:00 | 120924 | a | Joy
2011-07-20 00:00:00 | 123045 |  | Joy | 165
2011-07-13 00:00:00 | 123046 |  | Joy | 75
2011-07-20 00:00:00 | 123047 |  | Joy | 105
2011-07-20 00:00:00 | 123048 |  | Joy | 55
2011-07-13 00:00:00 | 123049 |  | Joy | 55
2011-07-14 00:00:00 | 123055 |  | Joy | 135
2011-07-14 00:00:00 | 123056 |  | Joy | 85
2011-07-14 00:00:00 | 123057 |  | Joy | 65
2011-07-14 00:00:00 | 123058 |  | Joy | 55
2011-07-13 00:00:00 | 123060 |  | Joy | 85
2011-07-15 00:00:00 | 123061 |  | Joy | 85
2011-07-15 00:00:00 | 123062 |  | Joy | 85
2011-07-20 00:00:00 | 123079 |  | Joy | 55
2011-07-20 00:00:00 | 123080 |  | Joy | 75
2011-07-21 00:00:00 | 123081 |  | Joy | 135
2011-07-21 00:00:00 | 123082 |  | Joy | 135
2011-07-21 00:00:00 | 123083 |  | Joy | 135
2011-07-21 00:00:00 | 123084 |  | Joy | 100
2011-07-21 00:00:00 | 123085 |  | Joy | 150
2011-07-22 00:00:00 | 123086 |  | Joy | 135
2011-07-22 00:00:00 | 123087 |  | Joy | 135
2011-07-22 00:00:00 | 123088 |  | Joy | 120
2011-07-22 00:00:00 | 123089 |  | Joy | 120
2011-07-22 00:00:00 | 123090 |  | Joy | 85
2011-07-22 00:00:00 | 123091 |  | Joy | 135
 |  |  | Joy
 |  |  |  |  |  |  |  |  |  |  | Check to driver
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 26410 | 25458 | 24462 | 29000
2 | 25541 | 22355 | 22978 | 27000 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 28508 | 22355 | 24466 | 27000 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 |  |  |  |  |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 |  |  |  |  |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 |  |  |  |  |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
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
2002-01-31 00:00:00 |  |  |  |  | 494169.59
2002-03-03 00:00:00
CBS Volume
 |  |  | 33898
Spreadsheet: 02874357-3ad3-4655-8a4d-9f55f0f530ef
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-09-28 11:22:35.290000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 101.658 | 101.533 | 101.408 | 101.033 |  | and are added to price quote
4.25 | 100.856 | 100.731 | 100.606 | 100.231
4.125 | 100.2 | 100.075 | 99.95 | 99.575 |  | Note: | Refer To Price [NAME]
4 | 99.796 | 99.671 | 99.546 | 99.171 |  |  | For all Price Adjs
3.875 | 99.219 | 99.094 | 98.969 | 98.344
3.75 | 98.267 | 98.142 | 98.017 | 97.392
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 100.894 | 100.769 | 100.644 | 100.269
3.5 | 100.556 | 100.431 | 100.306 | 99.931
3.375 | 100.183 | 100.058 | 99.933 | 99.558
3.25 | 99.647 | 99.522 | 99.397 | 99.022
3.125 | 98.18 | 98.055 | 97.93 | 97.305
3 | 97.842 | 97.717 | 97.592 | 96.967
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-12 11:22:35.290000
30 DAY | 2011-10-27 11:22:35.290000
45 DAY | 2011-11-11 11:22:35.290000
60 DAY | 2011-11-26 11:22:35.290000
90 DAY | 2011-12-26 11:22:35.290000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: geir_solberg__11287__12-21act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: Perry County

 |  |  |  |  |  | 2013 Perry County
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Pre-determined Wednesdays or Thursdays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 105552d1302870094-counting-with-zero-between-it-and-start-over-if-question15-04
Sheet: Sheet1

BUY? | Sell | Counting
1 | 0 | 1
0 | 0
0 | 0
0 | 0 |  |  |  |  |  | Count how many times you buy something, without selling it
0 | 0 |  |  |  |  |  | The difficult part is that there are zero between it
1 | 0 | 2 |  |  |  |  | So you buy at A2, A7 and A11. And there  you sell something so you have to count in the right cell
0 | 0 |  |  |  |  |  | Now you going to start over with counting at A12, this one you sell so is only 1
0 | 0
0 | 0 |  |  |  |  |  | At A14 you are hoing to start with counting  till A24
1 | 1 | 3 |  |  |  |  | The right asnwers are in column C but I have to automate it for a really large sheet
1 | 0 | 1 |  |  |  |  | Can someone please help me!
0 | 1
1 | 0 | 1
0 | 1
0 | 0
1 | 0 | 1
0 | 0
0 | 0
1 | 0 | 2
0 | 0
1 | 0 | 3
0 | 0
1 | 0 | 4
0 | 1
0 | 0
0 | 0
1 | 0 | 1
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
Spreadsheet: 166faf35-6d2e-426b-b984-7e982fa6e4cc
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/06/2012 | Rowing | at Head of the Ohio (Pittsburgh, Pa.) | 12:00 AM | Results
10/27/2012 | Rowing | at Head of the [NAME] (Philadelphia, Pa.) | 12:00 AM | Results
11/03/2012 | Rowing | at Head of the Occoquan (Fairfax Station, Va.) | 12:00 AM | Results
11/10/2012 | Rowing | at Philadelphia Frostbite (Cherry Hill, N.J.) | 12:00 AM | Results
03/16/2013 | Rowing | at Oak Ridge Cardinal Invitational (Melton Hill Lake - Oak Ridge, [NAME]) | 12:00 AM | Results
03/17/2013 | Rowing | at Oak Ridge Cardinal Invitational (Melton Hill Lake - Oak Ridge, [NAME]) | 12:00 AM | Results
[NAME] | Rowing | at Alabama with UCF (Black Warrior River - Tuscaloosa, Ala.) | 12:00 AM | Results
04/13/2013 | Rowing | at Knecht Cup Regatta (Cooper River - Cherry Hill, N.J.) | 12:00 AM | Results
04/14/2013 | Rowing | at Knecht Cup Regatta (Cooper River - Cherry Hill, N.J.) | 12:00 AM | Results
04/27/2013 | Rowing | at Bucknell, Connecticut and Delaware (Pinchot Lake - Lewisberry, Pa.) | 12:00 AM | Results
05/04/2013 | Rowing | at Big 12 Championship (Wyandotte County Lake - Kansas City, Kan.) | 12:00 AM | 4th, 75 pts
[NAME] | Rowing | at Conference USA Championship (Melton Hill Lake - Oak Ridge, Tenn.) | 12:00 AM | 6th, 36 pts
Spreadsheet: 798617d1664587298-using-conditional-formatting-to-show-status-of-shipments-friday-shipment-status-bb4523-
Sheet: Sheet1

 |  | Shipping  Status Report
 |  |  |  |  |  |  |  | SCHEDULE STATUS |  |  |  |  |  | current - shipments
 |  |  |  |  |  |  |  | LATE |  |  |  |  |  | Shipment's  overdue
 |  | A3 PHA |  |  |  |  |  | could be LATE
 |  | Product |  | Manager |  | Scheduled |  | Required by |  |  |  |  |  | Comment
 | 1 | Oranges |  | [NAME] |  | 2022-10-10 00:00:00 |  | 2022-10-30 00:00:00
 | 2 | Bananas |  | [NAME] |  | 2022-09-13 00:00:00 |  | 2022-09-30 00:00:00
 | 3 | Apples |  | JL Avery / S. Zacher |  | 2022-11-18 00:00:00 |  | 2022-12-07 00:00:00
 | 4 | Grapes |  | [NAME]  /  [NAME] |  | 2022-09-30 00:00:00 |  | 2022-10-30 00:00:00
 | 5 | Pears |  | C. Barnhill / V. Agarwal |  | 2022-12-31 00:00:00 |  | 2023-01-30 00:00:00
Spreadsheet: jeff_dasovich__14128__FIN group project2
Sheet: Exhibit Z

 | ASSUMES [NAME] DESPITE INCREASED PRICES
 | Year | Attendance | price 1 | Sales | PV @ 7/97 | PV @ 7/97 | PV @ 7/97 | PV @ 7/97 | PV @ 7/97 | PV @ 7/97
1 | 1999 | 2703704 | 15.64
2 | 2000 | 2478395 | 16.23
3 | 2001 | 2253086 | 16.87
4 | 2002 | 2253086 | 17.54
5 | 2003 | 2253086 | 18.26
6 | 2004 | 2253086 | 19.01
7 | 2005 | 2253086 | 19.79
8 | 2006 | 2253086 | 20.6
9 | 2007 | 2253086 | 21.45
10 | 2008 | 2253086 | 22.32
11 | 2009 | 2253086 | 23.24
12 | 2010 | 2253086 | 24.19
13 | 2011 | 2253086 | 25.18
14 | 2012 | 2253086 | 26.22
15 | 2013 | 2253086 | 27.29
16 | 2014 | 2253086 | 28.42
17 | 2015 | 2253086 | 29.58
18 | 2016 | 2253086 | 29.58
19 | 2017 | 2253086 | 29.58
20 | 2018 | 2253086 | 29.58
 | ASSUMES DISCOUNT RATE VARIES AND ELASTICITY = 0.80
 | Year | Attendance | price 1 | Sales | PV @ 7/97 | Attendance | price 1 | Sales | PV @ 7/97 | Attendance | price 1 | Sales | PV @ 7/97
1 | 1999
2 | 2000
3 | 2001
4 | 2002
5 | 2003
6 | 2004
7 | 2005
8 | 2006
9 | 2007
10 | 2008
11 | 2009
12 | 2010
13 | 2011
14 | 2012
15 | 2013
16 | 2014
17 | 2015
18 | 2016
19 | 2017
20 | 2018
 | ASSUMES ELASTICITY VARIES AND DISCOUNT RATE = 5.70%
 |  | ELASTICITY = .80 |  |  |  | ELASTICITY = .70 |  |  |  | ELASTICITY = .90
 | Year | Attendance | price 1 | Sales | PV @ 7/97 | Attendance | price 1 | Sales | PV @ 7/97 | Attendance | price 1 | Sales | PV @ 7/97
1 | 1999
2 | 2000
3 | 2001
4 | 2002
5 | 2003
6 | 2004
7 | 2005
8 | 2006
9 | 2007
10 | 2008
11 | 2009
12 | 2010
13 | 2011
14 | 2012
15 | 2013
16 | 2014
17 | 2015
18 | 2016
19 | 2017
20 | 2018
Spreadsheet: 89290d1289052283-excel-2008-can-i-nest-an-if-function-in-a-sumproduct-function-book2
Sheet: Sheet1

 | DETAILS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEDGEND
 | Trade | Date | Day | Time | Congested | MACD | Momentum | 15M Confirmation | Retrace in Pips | Blank | Blank | Notes | Direction | Entry
 | 1 | 2010-11-08 00:00:00 | Mon | 11:30:00 | n | w | w | y | b | a | a |  | SELL | 1.41 |  |  |  |  |  |  | y = yes | w = weak | w = weak | y = yes | a = 20 - 30 | a | a
 | 2 | 2010-11-08 00:00:00 | Tue | 21:00:00 | n | w | w | y | b | a | a |  | BUY | 1.41 |  |  |  |  |  |  | n = no | m [NAME] | m [NAME] | n = no | b = 30 - 40
 | 3 | 2010-11-09 00:00:00 | Mon | 01:30:00 | y | w | w | y | b | a | a |  | SELL | 1.41 |  |  |  |  |  |  |  | s = strong | s = strong |  | c = 40+
 | 4 | 2010-11-09 00:00:00 | Tue | 04:00:00 | y | w | w | y | b | a | a |  | BUY | 1.41
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIME RANGE | 00:00:00 |  | TRADES
 | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:59:00
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y
 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w
 | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w
 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y
 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
 | 101
 | 102
 | 103
 | 104
 | 105
 | 106
 | 107
 | 108
 | 109
 | 110
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
 | 119
 | 120
 | 121
 | 122
 | 123
 | 124
 | 125
 | 126
 | 127
 | 128
 | 129
 | 130
 | 131
 | 132
 | 133
 | 134
 | 135
 | 136
 | 137
 | 138
 | 139
 | 140
 | 141
 | 142
 | 143
 | 144
 | 145
 | 146
 | 147
 | 148
 | 149
 | 150
 | 151
 | 152
 | 153
 | 154
 | 155
 | 156
 | 157
 | 158
 | 159
 | 160
 | 161
 | 162
 | 163
 | 164
 | 165
 | 166
 | 167
 | 168
 | 169
 | 170
 | 171
 | 172
 | 173
 | 174
 | 175
 | 176
 | 177
 | 178
 | 179
 | 180
 | 181
 | 182
 | 183
 | 184
 | 185
 | 186
 | 187
 | 188
 | 189
 | 190
 | 191
 | 192
 | 193
 | 194
 | 195
 | 196
 | 197
 | 198
Spreadsheet: 886627d1736708182-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-tms-jeffcmusic-
Sheet: Sheet1

Number of Stops | Road Name | Stops effected | Closure Type
 | data from 'stops list'  tab column E | data to 'text join' from 'stops list' column C | data from 'stop list' column H
 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only |  |  | Road Name | Stops effected | Closure Type
2 | GLOUCESTER PLACE | 29797 | Publicity & Hood |  | 1 | STATION ROAD | 25118 | Publicity Only
1 | Road Name |  |  |  | 1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only
2 | STATION ROAD | 25118 | Publicity Only |  | 1 | GLOUCESTER PLACE | 29797 | Publicity & Hood
 |  |  |  |  | 2 | EDGWARE WAY | 15758, 14702 | Publicity Only
 |  |  |  |  | 1 | EDGWARE WAY | 16105 | Publicity & Hood
EXAMPLE OF OUTCOME
Number of Stops | Road Name | Stops effected | Closure Type |  | Number of Stops | ON STREET / ROAD | Stops Effected | Closure Type
1 | station road | 25118 | Publicity only |  | 1 | STATION ROAD | 25118 | Publicity Only
1 | edgwarebury lane | 15760 | Publicity only |  | 1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only
1 | gloucester place | 29797 | publicity & hood |  | 1 | GLOUCESTER PLACE | 29797 | Publicity & Hood
2 | [NAME] | 15758, 14702 | Publicity only |  | 2 | EDGWARE WAY | 15758, 14702 | Publicity Only
1 | [NAME] | 16105 | publicity & hood |  | 1 | EDGWARE WAY | 16105 | Publicity & Hood
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: Constructors

Pos | Team | Wins | [NAME] | Total | AUS | MAL | CHN | TUR | ESP | MON | CAN | EUR | GBR | GER | HUN | BEL | ITA | SIN | JPN | KOR | IND | ABU | BRA
1 | Red Bull
2 | [NAME]
3 | Ferrari
4 | Mercedes
5 | Renault
6 | Force India
7 | [NAME]
8 | Toro Rosso
9 | [NAME]
10 | Team Lotus
11 | Hispania
12 | Virgin