tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 266297d1379576121-copying-a-specific-row-from-another-sheet-depending-on-a-cell-value-book2
Sheet: September

 |  | Daily Takings |  |  | September
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | 36
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Week No:
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Week No:
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
 |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Week No:
 |  |  |  |  |  |  | TOTALS
 | BALANCE
 | CARDS
 | CASH
 | CHEQUES
 | DIRECT BANK
 | OTHER
 | OTHER SALES
 | TOTAL SALES
 | PAID OUT (-)
 | BANKING (-)
 | OTHER EXPENSES
 | CASH BALANCE
Spreadsheet: 97464d1296637886-data-model-in-excel-data-model
Sheet: Employee

 | Description |  |  |  |  | Employee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version
 | Table Name |  |  |  |  | Employee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | U | 1.00
 | [NAME] |  |  |  |  | eno
 | Foreign Key |  |  |  |  | [NAME])
 | Index |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ; | N; N
 |  | Label |  |  |  |  |  |  |  | FieldName |  |  |  |  |  |  |  |  |  |  | Type |  |  |  |  |  | Null |  |  | Default |  |  | Memo
 | 1 | eno |  |  |  |  |  |  |  | eno |  |  |  |  |  |  |  |  |  |  | int IDENTITY (1,1) |  |  |  |  |  | No
 |  | ename |  |  |  |  |  |  |  | ename |  |  |  |  |  |  |  |  |  |  | nvarchar(20) |  |  |  |  |  | No
 |  | eaddress |  |  |  |  |  |  |  | eaddress |  |  |  |  |  |  |  |  |  |  | nvarchar(10) |  |  |  |  |  | No
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: Scope

UAE - Lowell, MA LM6000 PC Power Project, Rev 2
Project Scope Description
Scope of Work: |  |  | Provide estimate for Operations and Maintenance services during the Pre-Operating and
 |  |  | Operating Period for one gas-fired LM6000 simple cycle facility
 |  |  | to be located at an existing, staffed cogeneration facility
Location: |  |  | Lowell, MA (outside of Boston)
Ownership: |  |  | UAE to own and operate for term.
 |  |  | Enron to get option for the offtake for initial 3 to 5 years
Capacity: |  |  |  | MW (GTs @ ISO)
Equipment: |  |  | 5 | ea. LM6000 PC Sprint gas turbines in simple cycle with water injection
 |  |  | Installed water treatment plant (3 x 50% trains)
 |  |  | Water source: Municipal
 |  |  | Water injection for NOX control at a rate of 46 gpm/GT
 |  |  | Water injection for Spray Intercooling (SPRINT) at a rate of 7 gpm/GT
 |  |  | induced draft [NAME] with circ. water pumps with chemical treatment
 |  |  | Chillers with condenser and chilled water pumps
 |  |  | 5 | CO + SCR units
 |  |  | Gas Compression required: |  |  | yes
 |  |  | Distributed Control System tied into existing control room system
 |  |  | No gas and electric distribution systems
Fuel: |  |  | Primary Fuel to be Pipeline Quality Natural Gas
 |  |  | No backup fuel
Operations Mode: |  |  | Annual run hours: |  |  | 1400
 |  |  | Annual # of starts:
 |  |  | Annual plant load factor:
 |  |  | dispatch on Monday-Friday 6am to 10pm, June-September
Shared Facilities (Existing): |  |  | Administrative office space, storage
 |  |  | Warehouse with some climate control space
 |  |  | Maintenance shop with bay
 |  |  | Central control room and small lab area
 |  |  | Sanitary facilities, to include lockers & showers
PPA: |  |  | Term in years: |  | 20
Tentative schedule: |  |  | COD is May 2001
Commercial Office: |  |  | In owner's scope.
Owners Engineer: |  |  | In owner's scope.
Spreadsheet: benjamin_rogers__1201__3rd Party Retail Shorts version 2
Sheet: Options

Spread Option Model
70% Correlation
Revenue
Capacity Prices ($/kW-mo.) |  | 4.31 | 4.22 | 4.13 | 4.13 | 4.12 | 4.12 | 4.15 | 4.16 | 4.25 | 4.28
Energy Prices (Drop in from Structuring) |  | 15544.94 | 15996.22 | 16200.055 | 16546.175 | 16734.54 | 16892.733 | 17049.164 | 17195.86 | 17267.466 | 17393.797
Expenses
Fuel |  | 14580.003 | 14997.487 | 15203.159 | 15546.749 | 15741.839 | 15910.637 | 16076.874 | 16234.955 | 16321.38 | 16456.793
VOM |  | 964.937 | 998.733 | 996.896 | 999.426 | 992.701 | 982.097 | 972.29 | 960.905 | 946.085 | 937.004
[NAME]
MWh |  | 444454.18 | 780058.98 | 853098.52 | 895576.95 | 890978.86 | 884420.04 | 829190.78 | 839458.88 | 829528.9 | 563847.9
Annual Cost (000) |  | 15094.311 | 24529.596 | 26860.987 | 28207.44 | 28131.985 | 28053.979 | 26286.585 | 26802.971 | 26892.872 | 19682.798
Spreadsheet: phillip_m_love__30147__9910_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  | -820724.91
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5000 | -12200
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2 | -4.78
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -73390 | -202888.48
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5002 | 11954.78
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7755.11
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73390 | 175402.1
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4.78
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -710972 | 0 |  |  |  | -64.49
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 734571d1622235592-countif-0-are-separated-but-not-if-together-stock-short-term-comparison-2
Sheet: Sheet1

-2 | 0 | 0 | 0 | 0 | -1 | -1 | -2 | -1 | -1 | -1 | -1 | -1 |  |  |  |  |  | 1
-2 | 0 | 1 | 1 | 2 | 3 | 3 | 3 | 3 | 5 | 5 | 5 | 5 |  |  |  |  |  | 1
-1 | 0 | -1 | 1 | 2 | 2 | 2 | 5 | 5 | 6 | 6 | 6 | 6
-1 | -1 | 1 | 0 | 1 | 2 | 0 | 0 | 5 | 6 | 7 | 7 | 7 |  |  |  |  |  | 2
-1 | -1 | -1 | 1 | 1 | 1 | 1 | 2 | 2 | 5 | 5 | 6 | 6 |  |  |  |  |  | 0
-1 | 0 | 0 | 1 | 1 | 0 | 0 | -1 | -1 | -1 | -1 | -1 | -1 |  |  |  |  |  | 2
Spreadsheet: 150590d1334609445-copying-data-to-another-worksheet-test
Sheet: TEST #1

TEST #1
 | DATE |  | 2012-04-16 00:00:00 |  |  |  | INIT
 | FIRST NAME
 | LAST NAME
 | DEPARTMENT
 | 1. Fill in your particulars in the highlighted boxes above.
 | 2. This is a 25 question multiple choice test. Pass is 15 out of 25 for 60%.
 | 3. Type in your answer in the form of either A, B, C, or D in the yellow highlighted box to the right of each of the questions. For example, if Question 1 was "A", then fill in box as:
 |  |  |  |  |  |  |  |  |  | A
 | 4. Once you have completed the test, e-mail the test back to me. You will receive an answer as soon as possible.
 | 5. If you should happen to "fail' the test, you will be given a new test within 24hrs.
1 | What is 25 x 25?
A | 355
B | 625
C | 435
D | 425
2 | When did Columbus discover America?
A | 1592
B | 1364
C | 1492
D | 1508
3 | How many continents of the world are there?
A | 5
B | 9
C | 6
D | 7
4 | How many hours in a day?
A | 24
B | 23
C | 25
D | 26
5 | How many days in a normal year?
A | 367
B | 365
C | 366
D | 364
6 | How many colours in a rainbow?
A | 5
B | 6
C | 8
D | 7
7 | How many letters in the English alphabet?
A | 24
B | 26
C | 27
D | 28
8 | How many bones in the adult human body?
A | 201
B | 210
C | 206
D | 180
9 | How long is a millenium?
A | 100 years
B | 10 years
C | 500 years
D | 1000 years
10 | Four score and seven years is how long?
A | 47
B | 63
C | 87
D | 107
11 | What is 25 x 25?
A | 355
B | 625
C | 435
D | 425
12 | When did Columbus discover America?
A | 1592
B | 1364
C | 1492
D | 1508
13 | How many continents of the world are there?
A | 5
B | 9
C | 6
D | 7
14 | How many hours in a day?
A | 24
B | 23
C | 25
D | 26
15 | How many days in a normal year?
A | 367
B | 365
C | 366
D | 364
16 | How many colours in a rainbow?
A | 5
B | 6
C | 8
D | 7
17 | How many letters in the English alphabet?
A | 24
B | 26
C | 27
D | 28
18 | How many bones in the adult human body?
A | 201
B | 210
C | 206
D | 180
19 | How long is a millenium?
A | 100 years
B | 10 years
C | 500 years
D | 1000 years
20 | Four score and seven years is how long?
A | 47
B | 63
C | 87
D | 107
21 | What is 25 x 25?
A | 355
B | 625
C | 435
D | 425
22 | When did Columbus discover America?
A | 1592
B | 1364
C | 1492
D | 1508
23 | How many continents of the world are there?
A | 5
B | 9
C | 6
D | 7
24 | How many hours in a day?
A | 24
B | 23
C | 25
D | 26
25 | How many days in a normal year?
A | 367
B | 365
C | 366
D | 364
Spreadsheet: 1dab41f3-4ee3-4cea-a4e5-665b5b791aab
Sheet: Salaries

Service Center Calculations
Salaries & Benefits Expenditures
Purpose:  To list personnel paid on the service center and allocate personnel costs to each service.
Sheet Instructions
1) Only fill in the areas shaded in yellow
2) Fill in the name of the person(s) that is providing the service (board apptd only)
3) For TH employee costs you may put in a lump sum total for the estimated expenditures.
4) Fill in that person's PCN
5) Enter in the employee type |  | *<<Type is EX for exempt, CL for classified, TH for temporary help, or GA for graduate assistant>>
6) Enter in the employee's annual salary
7) Enter in the employee's annual FTE (0.5, 1, 0.75, etc.)
8) Enter in the FTE % of this employee's time associated with the service and this budget
 |  |  |  |  |  |  | SERVICE 1 |  | SERVICE 2
NAME | PCN | TYPE* | ANNUAL SALARY | FTE | FRINGES | TOTAL COST | FTE % | Amount | FTE % | Amount
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
 |  |  | 0 | 0 |  |  | 0 |  | 0
TOTAL SALARIES
Fringe Benefits* | Rate
Variable | 0.245
Fixed (Health) | 9100
TH | 0.0821
GA | 0.0038
*The FB rates can be modified if needed in this rate box
Spreadsheet: 117383d1312752055-filtering-lookup-array-question-filtered
Sheet: 44015

CONTROL CABLE
CORE CARD
Location
Cable Number |  | 44015
Number of cores |  | 4
Spare cores |  | 2
Core size |  | 2.5mm2
Cable Type |  | Cu, PVC
Drawing References
Cable Service |  | GCB4 CBF
Panel Number | T44 PP |  | Panel Number |  | G4 PP
Cable Insulation resistance >100MΩ
Core Number | Ferrule Number |  | T44 PP | INITIAL | G4 PP | INITIAL
1 | 20/ADY441130 |  | TBX5:22 |  | TP2:35
2 | 20/ADY441147 |  | TBX5:23 |  | TP2:36
3 | Spare
4 | Spare
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Termination Notes
Edition Notes | 2011-08-02 00:00:00 | Cable has been added by business |  |  |  | DJC
Spreadsheet: benjamin_rogers__936__PJM Model
Sheet: Summary

PJM
Date | Day | Total Avg | Total Peak | Peak HE | Peak RM %
 | Next Week
 | Import | Import | Import | Import | Import | Import | Import | Flat | Export | Export | Export | Export | Export | Export | Export
Date | 4000 | 3000 | 2500 | 2000 | 1500 | 1000 | 500 |  | 500 | 1000 | 1500 | 2000 | 2500 | 3000 | 4000
FOR |  |  |  |  |  | PJM Outage Forecast
Reserves |  |  |  |  |  | Date | Outages
PJM Forecasted Reserves |  |  |  |  |  |  |  |  | Date | Day | West Avg | West Peak |  | East Average | East Peak
 | 7300
 |  | previous day spot | delta
FO2
FO6 1%
FO6 0.7%
FO6 0.3%
NG Transco Z6 NNY
NG TCO
This is a very simple unit dispatch model:
 | no emissions consideration
 | no efficiency curves
 | no variable O&M
 | no congestion or line outages
 | no risk premium |  |  |  |  | Updated:
Spreadsheet: 132570d1323818436-copying-web-queried-data-and-making-it-a-list-but-how-test_list
Sheet: Sheet1

Date | Inventory
2011-10-26 00:00:00 | 447800
2011-10-27 00:00:00 | 447800 |  |  | LME Copper Daily Summary  12 Dec 2011
2011-10-28 00:00:00 | 432375 |  |  | USD/MT |  | Cash | 3 Mth | 15 Mth | 27 Mth | Inventory | Volume
2011-10-31 00:00:00 | 432375 |  |  | Official | $ | 7611.5 | 7644.5 | 7685 | 7650 | 385575 | 3597900
2011-11-01 00:00:00 | 435000 |  |  |  | +/- | -189 | -181.5 | -180 | -190 | -500 | -357025
2011-11-02 00:00:00 | 442000 |  |  | Unofficial | $ | 7566 | 7590
2011-11-03 00:00:00 | 432375 |  |  |  | +/- | -45.5 | -54.5
2011-11-04 00:00:00 | 417850
2011-11-07 00:00:00 | 417850
2011-11-08 00:00:00 | 417850
2011-11-09 00:00:00 | 417850
2011-11-10 00:00:00 | 417850
2011-11-11 00:00:00 | 407700
2011-11-14 00:00:00 | 407700
2011-11-15 00:00:00 | 407700
2011-11-16 00:00:00 | 399635
2011-11-17 00:00:00 | 399635
2011-11-18 00:00:00 | 399635
Spreadsheet: 683850d1592986856-find-avergae-price-per-box-rather-than-kilo-tally-23
Sheet: sheet1

Vessel : |  |  | KEILA K121 |  |  |  | Total
Date: |  |  | 2020-06-08 00:00:00 |  | Boxes |  | [NAME]
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
 |  |  |  |  |  |  |  |  |  |  |  | HD | COD | WF | 1
 |  |  |  |  |  |  |  |  |  |  |  | WC | HAD | GH | 2
WC | COD | GH | 1 | 1 | 35 | 115 |  |  |  |  |  | WT | WHG |  | 3
BL | COD | GH | 1 | 2 | 35 | 115 |  |  |  |  |  | BL | POK |  | 4
HD | COD | GH | 1 | 2 | 35 | 110 |  |  |  |  |  | JPL | ANF |  | 5
HD | COD | GH | 2 | 1 | 40 | 125 |  |  |  |  |  | OT | LEZ |  | 6
WC | COD | GH | 2 | 1.25 | 40 | 115 |  |  |  |  |  | CS | LIN |  | U
HD | COD | GH | 3 | 3 | 40 | 116 |  |  |  |  |  | PWELL | SQU
WC | COD | GH | 4 | 5 | 40 | 107 |  |  |  |  |  | KB | RJM
HD | COD | GH | 5 | 7 | 40 | 90 |  |  |  |  |  | WL | RJC
WT | COD | GH | 5 | 20 | 40 | 84 |  |  |  |  |  | ICEW | [NAME]
WC | HAD | GH | 1 | 1 | 40 | 80 |  |  |  |  |  | NS | USK
WC | HAD | GH | 2 | 7 | 40 | 81 |  |  |  |  |  | [NAME] | HKE
BL | HAD | GH | 3 | 4 | 40 | 85 |  |  |  |  |  | CPM | JOD
CS | HAD | GH | 3 | 1 | 40 | 85 |  |  |  |  |  |  | LEM
WC | HAD | GH | 3 | 3 | 40 | 80 |  |  |  |  |  |  | PLE
WC | HAD | GH | 4 | 2 | 40 | 71 |  |  |  |  |  |  | TBT
BL | HAD | GH | 4 | 4 | 40 | 71 |  |  |  |  |  |  | HBT
WC | HAD | GH | 4 | 5 | 40 | 60 |  |  |  |  |  |  | MAC
HD | HAD | GH | 4 | 10 | 40 | 58 |  |  |  |  |  |  | POL
HD | HAD | GH | 4 | 6 | 40 | 42 |  |  |  |  |  |  | WIT
HD | HAD | GH | 4 | 6 | 40 | 54 |  |  |  |  |  |  | CAT
WT | HAD | GH | 4 | 7 | 40 | 52 |  |  |  |  |  |  | TUSK
WC | WHG | WF | 4 | 3 | 40 | 37 |  |  |  |  |  |  | NEP
WL | LEZ | GH | 1 | 2 | 35 | 108 |  |  |  |  |  |  | SYC
WL | LEZ | GH | 2 | 3 | 35 | 77
WL | LEZ | GH | 3 | 2 | 35 | 50
WL | LEZ | GH | 4 | 6 | 35 | 35
WL | LEZ | GH | U | 1 | 8 | 10
HD | ANF | GH | 2 | 1 | 40 | 124
WT | ANF | GH | 3 | 1 | 45 | 158
WT | ANF | GH | 3 | 1 | 11 | 39.5
WT | ANF | GH | 4 | 2 | 45 | 158
WT | ANF | GH | 5 | 3 | 45 | 124
WT | ANF | GH | 5 | 3 | 45 | 116
HD | LEM | GH | 1 | 2 | 40 | 130
BL | LEM | GH | 1 | 1 | 30 | 97.5
HD | LEM | GH | 2 | 11 | 40 | 105
 | LEM | GH | 3 | 12.5 | 40 | 68
HD | [NAME] | GH | 4 | 2 | 45 | 20
HD | RJM | GH | 4 | 1 | 45 | 30
JPL | PLE | GH | 2 | 1 | 11 | 20
Merchant | Species | Presentation | Grade | Units |  |  | Total (£) | [NAME] | Total (Kg)
 |  |  |  | Boxes | Weight | Cost
BL | PLE | GH | 3 | 1 | 11 | 20
WC | PLE | GH | 4 | 2 | 45 | 20
WC | PLE | GH | 4 | 1 | 11 | 5
WL | LIN | GH | 2 | 1 | 20 | 20
BL | HKE | GH | 4 | 2 | 30 | 38
BL | TBT | GH | U | 1 | 11 | 80
OT | JOD | GH | U | 1 | 12 | 95
WL | LEZ | GH | 1 | 1 | 8 | 27
WL | LEZ | GH | 3 | 1 | 8 | 12.5
Merchant |  |  |  |  |  |  | Total (£) | [NAME] | Total (Kg)
Spreadsheet: 1e698ab6-a9ed-491b-983b-3d24f6c5d6af
Sheet: Sheet1

Unnamed: 0 | EMT FY13  Detailed Fall Flowchart | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | FALL 2012
 | Medium/Vehicle | AUG | SEP | OCT
 | Radio
 | KCMP::The Current
 | Print
 | Midwest Living
 | Online
 | IN STATE EMAILS
 | Star Tribune Travel e-mail
 | 20,000 Impressions/Month
 | Star Tribune FYI Anchor E-mail
 | 250,000 Impressions/Email
 | Pioneer Press e-mail
 | 15,000 Impressions/Month
 | OUT OF STATE EMAILS
 | Future Flow Out of State e-mail
 | 250,000  Geo and Behaviorally Targeted Impressions/Email
 | Chicago Sun-Times
 | 360,000 Demo/Behaviorally Targeted Chicagoans that opted into Travel
 | Chicago Sun-Times (Wisconsin Targeted)
 | 360,000 Demo/Behaviorally Targeted Wisconsonians that opted into Travel
 | Des Moines Register
 | 160,000 Iowans that opted into Travel
 | Forum Communications
 | 50,000 North Dakotans
 | LEAD GENERATION VEHICLES
 | Travelinformation.com
 | 866 Leads/Month
 | TravelGuidesFree.com
 | 1500 Leads/Month
 | ONLINE BANNERS
 | MPR Content Boxes
 | 65,000 Impressions/Month
 | MPR Pre-pend Digital
 | XX Impressions/Month
 | Kare 11.com Olympics Banners
 | XX Impressions/Month
 | Adtegrity CPC Display Banners
 | 16,666 Clicks ~ 5,000,000 Impressions
 | Evolve Media Interactive Lead Gen Banners
 | 3,000,000 Impressions/Month
 | Evolve High-Impact Fall Color Brochure Initiative
 | 750,000 Impressions
 | BringMeTheNews
 | 3,000 Clicks / Month
 | SOCIAL / MOBILE
 | Facebook
 | CPC Based Like/Lead Based Initiative
 | GreyStripe Mobile Network
 | 7,791,026 Standard Ad Impressions Geo/Demo/Content Targeted
 | Search Engine Marketing
 | Google / Yahoo / Bing
 | Google / Yahoo / Bing MN Monthly Incremental Buy
 | ThinkSEM
 | ThinkSEM MN Monthly Incremental Fee
 | Radio: Minnesota Broadcasters Association
 | Fall Radio Campaign
 | MN Monthly Partnership
 | MN Monthly Content (2 Quarters)
 | 3rd Party Ad Serving
 | DoubleClick/Adswerve
Spreadsheet: 86689d1286644807-return-range-based-on-drop-down-return_range-index-match-
Sheet: Sheet1

 | YEAR | JUL | AUG | SEP |  |  | Select Case # | Case2
 | 2006-07 | 267.584836 | 276.172693 | 244.330196
 | 2007-08 | 267.584836 | 276.172693 | 262.287014
 | 2008-09 | 250.51359803 | 260.1821603 | 262.25229059
 | 2009-10 | 253.44335136 | 263.19116837 | 265.288608
 | 2010-11 | 255.10502013 | 264.82851143 | 266.926869
 | 2011-12 | 257.70649919 | 267.56464863 | 269.71567773
 | 2012-13 | 260.18360881 | 270.06792541 | 272.2176349
 | YEAR | JUL | AUG | SEP
Case1 | 2006-07 | 698.946608 | 841.182482 | 675.450198
Case1 | 2007-08 | 598.032287 | 680.279773 | 682.922126
Case1 | 2008-09 | 606.646322 | 689.568261 | 692.1667835
Case1 | 2009-10 | 612.8586245 | 696.287745 | 698.831703
Case1 | 2010-11 | 618.9430135 | 702.941036 | 705.452792
Case1 | 2011-12 | 624.931691 | 709.76786 | 712.5291815
Case1 | 2012-13 | 632.021498 | 717.367532 | 719.9803665
 | YEAR | JUL | AUG | SEP
Case2 | 2006-07 | 267.584836 | 276.172693 | 244.330196
Case2 | 2007-08 | 267.584836 | 276.172693 | 262.287014
Case2 | 2008-09 | 250.51359803 | 260.1821603 | 262.25229059
Case2 | 2009-10 | 253.44335136 | 263.19116837 | 265.288608
Case2 | 2010-11 | 255.10502013 | 264.82851143 | 266.926869
Case2 | 2011-12 | 257.70649919 | 267.56464863 | 269.71567773
Case2 | 2012-13 | 260.18360881 | 270.06792541 | 272.2176349
 | YEAR | JUL | AUG | SEP
Case3 | 2006-07 | 356.837273 | 374.666709 | 349.485024
Case3 | 2007-08 | 325.6735875 | 332.76623542 | 335.78062837
Case3 | 2008-09 | 329.31730554 | 336.46398299 | 339.52013178
Case3 | 2009-10 | 331.1730702 | 338.23537601 | 341.29624124
Case3 | 2010-11 | 334.45298329 | 341.66816263 | 344.81346168
Case3 | 2011-12 | 337.56652075 | 344.74462058 | 347.86513204
Case3 | 2012-13 | 340.23160619 | 347.37665971 | 350.47969858
 | YEAR | JUL | AUG | SEP
Case4 | 2006-07 | 776.175012 | 770.250887 | 780.460532
Case4 | 2007-08 | 766.140116034927 | 779.324853401392 | 787.946071592875
Case4 | 2008-09 | 776.264510567191 | 789.486455377738 | 798.158611526011
Case4 | 2009-10 | 792.876374856824 | 805.847030465222 | 814.508097696385
Case4 | 2010-11 | 800.037979751778 | 813.377532123638 | 822.276600879748
Case4 | 2011-12 | 805.86349032108 | 819.070712062384 | 827.896931681955
Case4 | 2012-13 | 808.562252354703 | 821.6692269179 | 830.468036301579
Spreadsheet: 48646d1247851710-graphs-how-to-display-negative-as-positive-chart
Sheet: Sheet1

 | data | -VE | +VE
martin | -1 | 1 | #N/A
fred | 2 | #N/A | 2
[NAME] | -15 | 15 | #N/A
[NAME] | 8 | #N/A | 8
[NAME] | -4 | 4 | #N/A
[NAME] | 12 | #N/A | 12
Spreadsheet: 89514d1289302556-how-to-get-div-0-to-show-as-zero-averagesforum
Sheet: Agent 7

Agent Name: | 0
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC | 23 | 23 | 45 | 0 | 0 | 30.33333333333333 | 91
CONFLICTS | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ID'S | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ISA | 60 | 75 | 25 | 134 | 257 | 110.2 | 551
Spreadsheet: benjamin_rogers__944__PJMPosMgr
Sheet: Prices

 |  |  |  | CALENDAR 2002
 |  |  | ZONE A |  | ZONE G |  | ZONE J |  | G/A | J/A | J/G | "02/01" | DAYS
1 | JAN | 22 |  |  | 46.25 |  | 57 | 57 |  |  |  |  | 22
2 | FEB | 20 |  |  | 46.25 |  | 57 | 57 |  |  |  |  | 20
 | JAN-FEB
3 | MAR | 21 |  |  | 39.75 | 43 | 49 | 49 |  |  |  |  | 21
 | Q-1
4 | APR | 22 |  |  | 39.75 | 44 | 49 | 49 |  |  |  |  | 22
5 | MAY | 22 |  |  | 41.75 | 45 | 50 | 50 |  |  |  |  | 22
6 | [NAME] | 20 |  |  | 52.25 | 53 | 59 | 59 |  |  |  |  | 20
 | Q-2
7 | JUL | 22 |  |  | 73.5 |  | 92 | 92 |  |  |  |  | 22
8 | AUG | 22 |  |  | 73.5 |  | 92 | 92 |  |  |  |  | 22
 | JUL-AUG
9 | SEPT | 20 |  |  | 40 | 43 | 48 | 48 |  |  |  |  | 20
 | Q3
10 | Oct | 23 |  |  | 40.75 |  | 28.5 | 48 |  |  |  |  | 23
11 | Nov | 20 |  |  | 40.75 |  | 28.5 | 48 |  |  |  |  | 20
12 | Dec | 21 |  |  | 40.75 |  | 31.5 | 48 |  |  |  |  | 21
 | Q4
 | CAL 02
 |  |  |  | CALENDER 2003
 |  |  | ZONE A |  | ZONE G |  | ZONE J |  | G/A | J/A | J/G | "03/02"
1 | JAN | 22 | 39 | 39 | 47.25 | 47.25 | 56 | 56
2 | FEB | 20 | 39 | 39 | 47.25 | 47.25 | 56 | 56
 | JAN-FEB
3 | MAR | 21 | 33.25 | 33.25 | 42.25 | 42.25 | 48 | 48
 | Q-1
4 | APR | 22 | 33.25 | 33.25 | 43.25 | 43.25 | 48 | 48
5 | MAY | 22 | 35 | 35 | 44.25 | 44.25 | 49 | 49
6 | [NAME] | 20 | 42 | 42 | 50.25 | 50.25 | 57 | 57
 | Q-2
7 | JUL | 22 | 58 | 58 | 70 | 70 | 87 | 87
8 | AUG | 23 | 58 | 58 | 70 | 70 | 87 | 87
 | JUL-AUG
9 | SEPT | 20 | 34 | 34 | 47 | 47 | 52 | 52
 | Q3
10 | Oct | 23 | 33.5 | 33.5 | 42 | 42 | 50 | 50
11 | Nov | 20 | 33.5 | 33.5 | 42 | 42 | 50 | 50
12 | Dec | 21 | 33.5 | 33.5 | 42 | 42 | 50 | 50
 | Q4
 | CAL 03