tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30143__9911_OA
Sheet: EAST-LRC-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  | 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
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -6571 | -20271.54
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | 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: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6571 | 20271.54
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
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
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  | 0
 |  | TOTAL
Spreadsheet: benjamin_rogers__928__PJM Operational Summaries
Sheet: 02-22-02

2002-02-22 08:49:21
 | Operations Summary for Today's Forecast Peak
A | Internal Scheduled Capacity | 40642
B | Scheduled Tie Flows | 2637
C | Capacity Adjustments | 0
D | Total Scheduled Capability | 43279
E | PJM Load Forecast | 34200
F | Operating Reserve | 9079
G | Unscheduled Capacity | 8552
 | Scheduled Tie Flow Breakdown
H | APS | 1878
I | FE | 422
J | NYPP | 101
K | VP | 236
L | Total | 2637
M | Forecast Eastern Transfer Limit | 5900
N | Forecast Central Transfer Limit | 3900
O | Forecast Western Transfer Limit | 5600
 | Previous Periods Operation Summary
 |  | Day | Evening | Midnight
P | Hour | 1100 | 1900 | 400
Q | PJM  [NAME] | 31500 | 32500 | 22300
R | Actual  Load | 31193 | 33151 | 22333
S | West Dispatch Rate ($/MWhr) | 20.13 | 38.91 | 13.43
T | East Dispatch Rate ($/MWhr) | 20.13 | 38.91 | 13.43
Spreadsheet: 847094d1698175666-help-please-unsure-of-function-to-use-and-formula-book1
Sheet: Sheet1

Name | Activity 1 | Activity 1 Date | Activity 2 | Activity 2 Date | Activity 3 | Activity 3 Date | Activity 4 | Activity 4 Date | Earliest Date  Attended | Earliest Activity Attended
Mr A | 15/08/2004 - Electrical - Venus |  | 11/05/1999 -WoodWork - Saturn |  | 16/01/2009 - Plumbing - Pluto
Mr B | 16/01/2009 - Plumbing - Pluto
Miss D | 17/12/2008 - Basket Weaving - Mars |  | 18/04/2018 - Electrical - Earth
Mrs E | 18/04/2018 - Electrical - Earth |  | 17/12/2008 - Basket Weaving - Mars |  | 24/09/2021 - Plumbing - Venus |  | 16/01/2009 - Plumbing - Pluto
[NAME] | 11/05/1999 -WoodWork - Saturn |  | 15/08/2004 - Electrical - Venus
Spreadsheet: 768157d1644856306-which-lookup-function-to-use-and-keeping-formula-column-constant-when-inserting-columns-excel-target-price-test-firedept
Sheet: Sheet1

ID | SUM |  | ID | SUM | Check
AAPL | 129.53 |  | AAPL | 146.32
ABBV | 114.38 |  | ABBV | 115.5
ABUS | 7 |  | ABUS | 7
ACB | 9.7 |  | ACB | 10.37
AMZN | 3737.88 |  | ALEC | 34.83
[NAME] | 10.17 |  | AMZN | 4016.71
ARE | 184.33 |  | [NAME] | 10.17
BA | 235.47 |  | ARE | 184.33
BGS | 30.25 |  | AVGO | 454.5
BIP | 53.75 |  | BA | 230.5
BIPC | 76 |  | BFT | -
BMY | 72.82 |  | BIP | 54.75
BP | 26 |  | BMY | 73.09
C | 75.93 |  | BP | 26.13
CAG | 38 |  | C | 75.83
CCI | 181.67 |  | CAG | 38
CDTAF | - |  | CCI | 180.58
CGC | 23.46 |  | CDTAF | -
Spreadsheet: 104255d1301916336-need-with-nested-if-statement-sumif
Sheet: Sheet4

 | Price | code | Code | Sales
 | 34 | #12 | #8
 | 56 | #20 | #12
 | 77 | #12 | #16
 | 898 | #16 | #20
 | 79 | #12 | Total
 | 24 | #8
 | 23 | #20
 | 34 | #12
 | 4354 | #16
 | 4656 | #12
 | 7678 | #8
 | 6786 | #20
 | 87 | #12
Total
Spreadsheet: 155770d1337029900-help-with-my-fantasy-result-prediction-spreadsheet-it-cant-work-out-0-0-scorelines-srs-draft-1
Sheet: 15

 | Game 1 |  |  |  |  |  | Game 2 |  |  |  |  |  | Game 3 |  |  |  |  |  | Game 4 |  |  |  |  |  | Game 5 |  |  |  |  |  | Game 6 |  |  |  |  |  | Game 7 |  |  |  |  |  | Game 8 |  |  |  |  |  | Game 9 |  |  |  |  |  | Game 10 |  |  |  |  |  | WEEK
Name | Predict |  | Actual |  |  | pts | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | Predict |  | Actual |  |  | PTS | TOTAL
Spreadsheet: 782638d1654167422-counting-cells-up-to-a-value-excluding-some-sample-worksheet-attached-copy-vc-aligw
Sheet: Hot & Cold Spot (90.5°C for 10)

 |  | 15
 | [NAME]
 | First
 | Second
 | Third
 | Time Stamp | Probe 1 | Probe 2 | Probe 3 | Probe 4 | Probe 5 | Probe 6 | Probe 7 | Probe 8
 |  | 3 |  | 3
 |  | 4 |  | 3
 |  | 5 | 3 | 3
 |  | 6 | 4 | 3
 |  | 8 | 5 | 3
 |  | 12 | 6 | 4
 |  | 30 | 8 | 5
 |  | 50 | 12 | 6
 |  | 70 | 30 | 8
 |  | 90 | 50 | 12
 |  | 95 | 70 | 30
 |  | 90.5 | 90 | 50
 |  | 60 | 95 | 70
 |  | 50 | 90.5 | 90
 |  | 4 | 60 | 95
 |  | 3 | 3 | 90.5
 |  | 1 | 30 | 60
 |  | 6 | 20 | 3
 |  | 3 | 10 | 30
 |  | 4.5 | 6 | 20
 |  |  | 3 | 10
 |  |  | 4.5 | 6
 |  |  |  | 3
 |  |  |  | 4.5
Spreadsheet: 846883d1698038065-in-my-head-i-know-exactly-what-i-want-but-i-cant-get-excel-to-give-me-the-right-data-book23-sample
Sheet: 1029 what it should look like

 |  |  |  |  |  |  |  | 2023-10-29 00:00:00
 | Employee Name | Shift | Break 1 | Meal | Break 2 | Total Hrs
 | [NAME] | 10:30 AM - 4:00 PM | 1:15 PM - 1:30 PM | N/A | N/A | 5.5
 | [NAME] | 10:30 AM - 5:30 PM | 12:30 PM - 12:45 PM | 2:45 PM - 3:30 PM | N/A | 6.25
 | [NAME] | 11:30 AM - 5:30 PM | 1:15 PM - 1:30 PM | 3:00 PM - 3:30 PM | N/A | 5.5
 | [NAME] | 11:00 AM - 5:30 PM | 1:00 PM - 1:15 PM | 3:00 PM - 3:30 PM | N/A | 6
Spreadsheet: 804582d1668169219-calculate-needed-numbers-to-meet-target-goal-samplewb
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | I manually enter  number here until  both NPS and EXC are green or met goal
 |  |  |  |  |  |  |  |  |  |  |  |  | Total NPS + manually  entered | Total EXC + manually  entered
 | GOAL | NPS | 0.71
 |  | EXC | 0.87
 | NPS |  |  |  |  | EXCELLENCE |  |  |  | PROMOTERS Needed
Name | Promoter | Neural | Detractor | Total  NPS Survey | NPS% | Excellent | Non Excellent | Total  EXC  Survey | EXC% |  | NPS | EXC | NPS TOTAL | EXC Total
Agent 1 | 5 | 1 | 2 |  |  | 7 | 1 |  |  | 10
Agent 2 | 8 | 1 | 0 |  |  | 7 | 2 |  |  | 7
Agent 3 | 1 | 1 | 0 |  |  | 1 | 1 |  |  | 6
Agent 4 | 5 | 0 | 0 |  |  | 5 | 0 |  |  | 21
Agent 5 | 8 | 4 | 3 |  |  | 10 | 5 |  |  | 24
Agent 6 | 7 | 1 | 1 |  |  | 8 | 1 |  |  | 2
Agent 7 | 5 | 1 | 0 |  |  | 6 | 0
Agent 8 | 7 | 0 | 1 |  |  | 7 | 1
Agent 9 | 10 | 1 | 0 |  |  | 9 | 2 |  |  | 5
Agent 10 | 6 | 2 | 1 |  |  | 8 | 1 |  |  | 5
Grand Total
 |  |  |  |  |  |  |  |  |  | Both   [NAME] and M 13 should be green
 |  |  |  |  |  |  |  |  |  | Agent 10 needs 5 more promoters to hit the goal assuming, the card member who answered the survey gave  NPS and EXC both a good score.
Spreadsheet: 824782d1680819055-separate-out-accrue-rate-into-excel-column-accrual-rate-3-
Sheet: Sheet1

Accrual Rate
[After 10 Years, accrue 9.334 hours  twice a month] |  | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 0 Days, accrue 6 hours  twice a month] |  | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 2 Years, accrue 7.667 hours  twice a month] |  | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[After 0 Days, accrue 9.334 hours  twice a month] |  | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
[Not currently assigned to plan] |  | IF(A2="9.334", value_to_return, "9.334"),IF(A2="6", value_to_return, "6")IF(A2="7.667", value_to_return, "7.667"),"")
X
Y
Z
expected results
Accrual Rate
[After 10 Years, accrue 9.334 hours  twice a month] |  | 9.334
[After 0 Days, accrue 6 hours  twice a month] |  | 6
[After 2 Years, accrue 7.667 hours  twice a month] |  | 7.667
[After 0 Days, accrue 9.334 hours  twice a month] |  | 9.334
[Not currently assigned to plan] |  | "blank"
Spreadsheet: 36b4807f-b2cc-4aa6-81ed-15b4bd915fb7
Sheet: 1996-97

Table F
Student Numbers by [NAME] and Method of Study
1996-97
 | Full Time |  |  | Part Time |  |  | Total
 | Male | Female | Total | Male | Female | Total | Male | Female | Total
Undergraduate | 4602 | 4665 |  | 90 | 75 |  | 4692 | 4740
%
Graduate | 1888 | 1630 |  | 657 | 670 |  | 2545 | 2300
%
Total
Spreadsheet: 137749d1327343562-merging-two-time-series-in-columns-into-one-column-example
Sheet: Sheet1

BEFORE |  |  | AFTER
1605 | 1613.5 |  | 1605
1637.5 | 1608 |  | 1613.5
1609 | 1606.5 |  | 1637.5
1607.5 | 1607.5 |  | 1608
1584 | 1571 |  | 1609
1537.5 | 1531 |  | 1606.5
1574.5 | 1574.5 |  | 1607.5
1590 | 1598 |  | 1607.5
1603 | 1613 |  | 1584
1614.5 | 1599 |  | 1571
 |  |  | 1537.5
 |  |  | 1531
 |  |  | 1574.5
 |  |  | 1574.5
 |  |  | 1590
 |  |  | 1598
 |  |  | 1603
 |  |  | 1613
 |  |  | 1614.5
 |  |  | 1599
Spreadsheet: 854412d1704297080-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W14

IDs (Week 8 data (Week 19 since letter))
Group 1 | Group 2 |  |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 4566776058 | 2023-12-19 00:00:00
Spreadsheet: 473248d1470135508-dates-according-year-in-cell-with-data-validation-my-book
Sheet: Φύλλο1

 |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  | Current year | 2021 |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Can I have only the first dates of every month
according the selected year in  cell current year?
The cell with grey color has data validation
If I select another year 2022, I want dates in yellow area like this
Spreadsheet: 843288d1695184699-a-doosy-complex-logic-for-filtering-can-you-figure-it-out-test-formulas-smaller
Sheet: Libraries

Vendor | [NAME] | Group Name | Patch Name | Instrument Type A | Instrument Type B | Instrument Type C | Instrument Type D | Primary Application | Application B | Application C | Library Type
344 Audio | 344 Audio - Electric Organ |  | Electric Organ_DSN_CREEPY TREMOLATOR.nki | Organ |  |  |  |  |  |  | Kontakt
344 Audio | 344 Audio - Electric Organ |  | Electric Organ_DSN_GRITTY [NAME] | Organ |  |  |  |  |  |  | Kontakt
344 Audio | 344 Audio - Electric Organ |  | Electric Organ_DSN_LARGE CATHEDRAL CHURCH ORGAN.nki | Organ |  |  |  |  |  |  | Kontakt
344 Audio | 344 Audio - Electric Organ |  | Electric Organ_DSN_METALLIC TECHNO SEQUENCE.nki | Organ |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Down to Earth.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Exprecussive Staccato MW.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Glass.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Leds.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1928 New Legacy [NAME] | Presets | 8Dio The New 1928 Piano - Organ-Like.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME] - Delayed Bass CC1.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate Piano - Driven Spots.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME] | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME] CC1.nki | [NAME] |  |  |  |  |  |  | Kontakt
8Dio | 8Dio 1985 Passionate [NAME] v1 | Presets | 8Dio 1985 Passionate [NAME] - Late Night Scoring Piano.nki | [NAME] |  |  |  |  |  |  | Kontakt
Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Spoiled Juwels.nki |  |  |  |  |  |  |  | Kontakt
Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Spooky Castle.nki |  |  |  |  |  |  |  | Kontakt
Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Submarine.nki |  |  |  |  |  |  |  | Kontakt
Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Sucked In.nki |  |  |  |  |  |  |  | Kontakt
Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | Sweezy.nki |  |  |  |  |  |  |  | Kontakt
Cinesamples | Kontakt Designer Vol 1 Metallurgy | Odd Events | The Dentist.nki |  |  |  |  |  |  |  | Kontakt
Spreadsheet: 75869d1276499350-auto-copy-record-to-different-spreadsheets-example
Sheet: programe 2

Surname | Name | code | Sallary | Shift | Company | Τype | [NAME]
surname1 | name 1 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 2
surname3 | name 3 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 2
surname6 | name 6 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 2
surname9 | name 9 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 2
surname14 | name 14 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 2
surname22 | name 22 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 2
surname26 | name 26 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 2
surname32 | name 32 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 2
[NAME] | name 37 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 2
surname40 | name 40 | 60400999 | 1014.71 | 8 | mark | Advisor | programe 2
Spreadsheet: 859689d1707989519-multiple-dropdown-selections-and-showing-data-testbook
Sheet: Data

Site | Red |  |  |  |  | Upon selection of B1 only, when B2 and B3 are empty it should show top 5 bylines of the site selected in B1, for all the years and quarters
Year | 2022 |  |  |  |  | If B1 and B2 are selected, and B3 is empty, then it should show top 5 bylines of the site and year selected only
Quarter | Q3 |  |  |  |  | If B1, B2, B3 all are selected, then it should show top 5 bylines of the site, year and quarter selected
 |  |  |  |  |  | B1, B2, B3 have dropdowns
Top 5 Bylines
Spreadsheet: 266828d1379771932-copy-or-remove-particular-count-of-records-and-pasting-in-another-excel-workbook-count-sample-result
Sheet: required records 

Webaddress | email address
Spreadsheet: 107977d1305102745-count-number-of-occurances-in-descending-order-sequance
Sheet: Sheet1

 | Item | Count | Desired Count
 | Area A |  | 4
 | Area A |  | 3
 | Area A |  | 2
 | Area A |  | 1
 | Area B |  | 5
 | Area B |  | 4
 | Area B |  | 3
 | Area B |  | 2
 | Area B |  | 1
Spreadsheet: 456325d1460748213-percentage-distribution-from-a-dataset-zones
Sheet: Sheet1

Zone: |  | Zone | [NAME] | Distribution
4.3 |  | 1
5 |  | 2
3.2 |  | 3
1.2 |  | 4
1.3 |  | 5
3.7 |  | Total
4.4
1.1
2.2
4.9
3.7
Spreadsheet: 100003d1298494352-how-do-i-import-data-from-another-sheet-to-match-certain-criteria-test-page-excel-assistance
Sheet: Sheet Z

Region | Emp. Number | Name | Date | Code | Hours | Audit Code
LC | 451321 | Rita | 2010-04-01 00:00:00 | A | 8 | 912323696
LC | 451321 | Rita | 2010-04-02 00:00:00 | A | 8 | 912323696
LC | 451321 | Rita | 2010-04-03 00:00:00 | A | 8 | 912323696
LC | 486512 | [NAME] | 2010-04-01 00:00:00 | A | 4 | 945984212
LC | 486512 | [NAME] | 2010-04-02 00:00:00 | A | 4 | 945984212
LC | 498498 | [NAME] | 2010-04-01 00:00:00 | U | 0.8 | 932132133
LC | 498498 | [NAME] | 2010-04-02 00:00:00 | A | 8 | 932132133
LC | 498498 | [NAME] | 2010-04-03 00:00:00 | A | 8 | 932132133
UC | 484948 | Alonzo | 2010-04-01 00:00:00 | A | 4 | 936998888
UC | 484948 | Alonzo | 2010-04-02 00:00:00 | R | 6 | 936998888
UC | 484948 | Alonzo | 2010-04-03 00:00:00 | A | 8 | 936998888
UC | 498516 | [NAME] | 2010-04-01 00:00:00 | A | 8 | 913232116
UC | 498516 | [NAME] | 2010-04-02 00:00:00 | A | 8 | 913232116
UC | 498516 | [NAME] | 2010-04-03 00:00:00 | A | 8 | 913232116
UC | 433212 | [NAME] | 2010-04-01 00:00:00 | A | 4 | 936996365
UC | 433212 | [NAME] | 2010-04-02 00:00:00 | A | 4 | 936996365
UC | 468988 | [NAME] | 2010-04-01 00:00:00 | A | 8 | 993216516
UC | 468988 | [NAME] | 2010-04-02 00:00:00 | A | 4 | 993216516
UC | 468988 | [NAME] | 2010-04-03 00:00:00 | A | 8 | 993216516
DC | 489321 | Christina | 2010-04-01 00:00:00 | A | 6 | 913219988
DC | 489321 | Christina | 2010-04-02 00:00:00 | A | 6 | 913219988
DC | 489321 | Christina | 2010-04-03 00:00:00 | T | 6 | 913219988
DC | 489321 | Christina | 2010-04-04 00:00:00 | A | 8 | 913219988
DC | 489302 | [NAME] | 2010-04-01 00:00:00 | A | 8 | 985369699
DC | 489302 | [NAME] | 2010-04-02 00:00:00 | A | 8 | 985369699
DC | 489302 | [NAME] | 2010-04-03 00:00:00 | A | 8 | 985369699
DC | 456898 | [NAME] | 2010-04-01 00:00:00 | A | 8 | 912365456
DC | 456898 | [NAME] | 2010-04-02 00:00:00 | A | 4 | 912365456
DC | 456898 | [NAME] | 2010-04-03 00:00:00 | A | 6 | 912365456
DC | 456898 | [NAME] | 2010-04-04 00:00:00 | A | 8 | 912365456
DC | 489877 | [NAME] | 2010-04-01 00:00:00 | A | 8 | 926136516
DC | 489877 | [NAME] | 2010-04-02 00:00:00 | T | 0.75 | 926136516
DC | 489877 | [NAME] | 2010-04-03 00:00:00 | A | 6 | 926136516
DC | 489877 | [NAME] | 2010-04-04 00:00:00 | A | 6 | 926136516
Spreadsheet: 208591d1358875540-sorting-is-throwing-my-formulas-out-of-place-looking-for-solution-test-file
Sheet: Weekly Schedule

Week starting --> |  |  | 2013-01-07 00:00:00 |  |  |  |  |  |  |  | 2013-01-14 00:00:00 |  |  |  |  |  |  |  | 2013-01-21 00:00:00 |  |  |  |  |  |  |  |  | 2013-01-28 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-04 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-18 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-25 00:00:00
Team Member --> |  |  | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug
Total Hours This Week ↓
Maria | Client A |  |  |  |  |  |  |  | 10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Maria | Client B |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 12
Maria | Client C
[NAME] | Client D
Doug | Client E |  |  |  |  |  | 10 |  |  |  |  |  | 2 |  | 10 |  | 10 |  |  |  | 2 |  | 10 |  | 8
Kris | Client A
Karen/Kris/Carly | Client F |  | 29 |  | 2 |  | 4 | 4 | 12 |  |  |  | 10 |  |  | 15 | ? |  | 22 | 1 | 4 |  |  | 8
Kris | Client G
Kris | Client H |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Kris | Client I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Kris/Sue | Client J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
[NAME] | Client K |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 12
Sue | Client L |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 3
Doug | Client M
Sue | Client N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] | Client O |  | 1
[NAME] | Client P
Karen/Sue | Client Q |  |  | 20 |  |  |  | 4 |  |  |  |  | 15 |  | 4 | 2 | ? |  |  | 7 |  |  |  | 5 | 7 | 7
Google | Client R
Google | Client S
Google | Client T |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
Google | Client U
[NAME] | Client V |  |  |  |  | 15
Ruby | Client W
Sue | Client X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 15
Sue | Client Y
Sue | Client Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Sue | Client 1 |  |  |  | 10 |  |  |  | 5 |  |  | 5 |  |  |  |  |  |  |  |  | 5 |  | 10
Sue | Client 2 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
England | Client 3
Spreadsheet: jonathan_mckay__16907__Telus Convention Centre
Sheet: Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Telus Convention Centre |  |  |  | Deal Date: | 2001-07-17 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-09-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: |  |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: |  |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 76 | 11173
 | February | 51 | 6089
 | March | 51 | 8587
 | April | 33 | 4691
 | May | 26 | 3704
 | June | 16 | 2569
 | July | 13 | 3220
 | August | 18 | 2029
 | September | 42 | 3525
 | October | 53 | 4699
 | November | 65 | 6058
 | December | 69 | 7071
 | TOTAL: