tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36475d1234361077-return-information-on-same-row-if-starting-value-is-correct-array-with-partial-match-using-find
Sheet: DATA

I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER INFO FOR NO6 INSTANCE 1 | INFO FOR NO6 INSTANCE 1 | N063456
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER INFO FOR NO6 INSTANCE 2 | INFO FOR NO6 INSTANCE 2 | N063456
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER NOT NO6 | NOT NO6 | N1687654
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER NOT NO6 BUT N26 | NOT NO6 BUT N26 | N2612345
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER INFO FOR NO6 INSTANCE 3 | INFO FOR NO6 INSTANCE 3 | N068765
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER NOT NO6 | NOT NO6 | N1687644
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER NOT NO6 BUT N26 | NOT NO6 BUT N26 | N2612445
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER INFO FOR NO6 INSTANCE 4 | INFO FOR NO6 INSTANCE 4 | N068768
Spreadsheet: 784522d1655807520-data-extracting-sorting-and-organizing-drgkt-v3
Sheet: Sheet3

LastName | FirstName | MiddleName | Prefix | EMAIL;WORK: | NICKNAME: | ORG: | TEL;AnotherCustom: | [NAME]: | TEL;CELL-2: | TEL;Custom: | TEL;HOME: | TEL;HOME;FAX: | TEL;PAGER: | TEL;PREF: | TEL;VOICE: | TEL;WORK: | TEL;WORK;FAX: | TITLE:
Smoe | [NAME] | [NAME] | Mr. |  |  |  |  | +[PHONE] |  |  |  | 555 3333 | 2015554444 |  |  |  | (201) 555-2222
Doe | [NAME] | [NAME] |  | [EMAIL] | MayJo | Microsoft | 2106663333 | 2116664444 |  | 666 1111 | (201) 555 6666 | 2015550000 | +[PHONE] | 6662222 | 5558888 | [PHONE] | 555-9999 | CEO
Spreadsheet: cara_semperger__1445__ENA_PGE_DEC01_2001
Sheet: JD-MAL TRANS

From: | EPMI
To: | PGE System Transactions
Date:
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  | Total In To PGE Trans
0100
0200
0300
0400
0500
0600
0700
0800
0900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
2200
2300
2400
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | CISO(T)MAL5/NP15 | CISO(T)MAL5/NP15
 | EPMI(L,R)NP15 | EPMI(L,R)NP15
Spreadsheet: kate_symes__18238__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
 | 2001-03-04 00:00:00 |  | 230 | 0 | 170 | 400 | 171.88 | 2765 | 131.78 | 1320
 | 2001-03-03 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 170.84 | 1909 | 147.7 | 685
 | 2001-03-02 00:00:00 |  | 230.28 | 464 | 153.46 | 1040 | 204.08 | 1930 | 128.66 | 1229
 | 2001-03-01 00:00:00 |  | 267.19 | 512 | 141.82 | 880 | 233.33 | 777 | 144.63 | 726
 | 2001-02-28 00:00:00 |  | 170 | 320 | 112.22 | 1800 | 230.04 | 274 | 158.91 | 659
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600 | 176.51 | 603 | 108.24 | 1877
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
Spreadsheet: 123889d1317917223-need-to-populate-summary-tab-based-on-other-tabs-data
Sheet: Q4

Name |  | 2011-10-01 00:00:00 | 2011-10-02 00:00:00 | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 2011-10-07 00:00:00 | 2011-10-08 00:00:00 | 2011-10-09 00:00:00 | 2011-10-10 00:00:00 | 2011-10-11 00:00:00 | 2011-10-12 00:00:00 | 2011-10-13 00:00:00 | 2011-10-14 00:00:00 | 2011-10-15 00:00:00 | 2011-10-16 00:00:00 | 2011-10-17 00:00:00 | 2011-10-18 00:00:00 | 2011-10-19 00:00:00 | 2011-10-20 00:00:00 | 2011-10-21 00:00:00 | 2011-10-22 00:00:00 | 2011-10-23 00:00:00 | 2011-10-24 00:00:00 | 2011-10-25 00:00:00 | 2011-10-26 00:00:00 | 2011-10-27 00:00:00 | 2011-10-28 00:00:00 | 2011-10-29 00:00:00 | 2011-10-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00 | 2011-11-08 00:00:00 | 2011-11-09 00:00:00 | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 | 2011-11-13 00:00:00 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 | 2011-11-16 00:00:00 | 2011-11-17 00:00:00 | 2011-11-18 00:00:00 | 2011-11-19 00:00:00 | 2011-11-20 00:00:00 | 2011-11-21 00:00:00 | 2011-11-22 00:00:00 | 2011-11-23 00:00:00 | 2011-11-24 00:00:00 | 2011-11-25 00:00:00 | 2011-11-26 00:00:00 | 2011-11-27 00:00:00 | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00 | 2011-12-01 00:00:00 | 2011-12-02 00:00:00 | 2011-12-03 00:00:00 | 2011-12-04 00:00:00 | 2011-12-05 00:00:00 | 2011-12-06 00:00:00 | 2011-12-07 00:00:00 | 2011-12-08 00:00:00 | 2011-12-09 00:00:00 | 2011-12-10 00:00:00 | 2011-12-11 00:00:00 | 2011-12-12 00:00:00 | 2011-12-13 00:00:00 | 2011-12-14 00:00:00 | 2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 2011-12-17 00:00:00 | 2011-12-18 00:00:00 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2011-12-22 00:00:00 | 2011-12-23 00:00:00 | 2011-12-24 00:00:00 | 2011-12-25 00:00:00 | 2011-12-26 00:00:00 | 2011-12-27 00:00:00 | 2011-12-28 00:00:00 | 2011-12-29 00:00:00 | 2011-12-30 00:00:00 | 2011-12-31 00:00:00
ABC
XYZ
DEF
Spreadsheet: 167432d1341997921-content-of-multiple-lines-into-one-line-testfile-incl-solution
Sheet: Sheet1

ORIGINAL
Model | Code | Omschrijving | Extra | Family | Category | Wijziging | Model 1 | Model 2 | Model 3 | Model 4 | Model 5 | Model 6 | Model 7 | Model 8 | Model 9 | Model 10 | Model 11
Model 1 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  |  |  |  |  |  |  |  | o
Model 2 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  |  | o
Model 3 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  |  |  | o
Model 4 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  |  |  |  | o
Model 5 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  | o
Model 6 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  |  |  |  |  |  | o
Model 7 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  |  |  |  |  | o
SOLUTION, first step
Model | Code | Omschrijving | Extra | Family | Category | Wijziging | Model 1 | Model 2 | Model 3 | Model 4 | Model 5 | Model 6 | Model 7 | Model 8 | Model 9 | Model 10 | Model 11
Model 1 | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  | o | o | o | o | o | o |  | o
SOLUTION, second step
Model | Code | Omschrijving | Extra | Family | Category | Wijziging | Model 1 | Model 2 | Model 3 | Model 4 | Model 5 | Model 6 | Model 7 | Model 8 | Model 9 | Model 10 | Model 11
Model x | 01A | Description type 02384 |  | TRM | T1 |  |  |  |  | o | o | o | o | o | o |  | o
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Plan Review

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Caseload Management
Activity Name | Plan Review
Activity Description / Purpose | The process of managing and monitoring the achievement of agreed service levels
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Caseload Stats/criteria reviewed
Case(s) reconfigured/assigned
Information entered into WMS
Case folders distributed/redistributed
Case folders reviewed
Ask [NAME] about case rejection?
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 149711d1334090110-excel-2010-incorrect-axis-on-graph-it-runbook-march-2012-in-progress
Sheet: Work Orders

Work Orders | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00
Total Starting Open Work
Work Orders Completed | 318 | 243 | 302 | 290 | 240 | 266 | 247 | 227 | 201 | 211 | 250 | 230 | 225 | 155 | 309 | 223 | 218 | 249 | 202 | 345 | 312 | 227 | 172 | 151 | 136 | 149 | 151
New work order requests | 321 | 280 | 321 | 290 | 262 | 266 | 249 | 234 | 201 | 237 | 251 | 247 | 243 | 186 | 304 | 200 | 201 | 248 | 222 | 358 | 297 | 224 | 203 | 151 | 139 | 217 | 113
Avg FTEs available | 10.75 | 10.75 | 10.75 | 10.75 | 10.75 | 10.75 | 10.75 | 10 | 9.75 | 9.75 | 11.75 | 11.75 | 11.75 | 14.65 | 14.65 | 14.65 | 14.65 | 15.65 | 15.65 | 15.65 | 15.65 | 15.65 | 15.65 | 15.65 | 15.65 | 15.65 | 15.65
Average Age Closed | 11.3 | 8.1 | 5.7 | 10.2 | 9.7 | 15.8 | 14.4 | 19.2 | 23.6 | 35.7 | 40 | 7.8 | 25.3 | 18.5 | 30 | 15 | 13.3 | 16.3 | 8.2 | 10.8 | 7 | 6.4 | 18.7 | 20.5 | 23.5 | 24.1 | 15.2
Average Age Open Orders |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60.2 | 32.1 | 34.1 | 25.3 | 44.8 | 51 | 53.8 | 75.3 | 79.8 | 75 | 61
% of Work Orders that Met SLA | 90.6 | 90.1 | 88.1 | 80.7 | 87.9 | 83.1 | 82.2 | 81.1 | 70.6 | 79.6 | 65.4 | 80.9 | 84.9 | 85.8 | 78 | 73.5 | 73.9 | 68.7 | 80 | 75 | 75 | 75 | 73.8 | 75 | 73 | 72.6
Total Open Work Orders |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 136 | 156 | 189 | 199 | 160 | 168 | 193 | 189 | 221 |  | 179
%  Missed SLA | 9.4 | 9.9 | 11.9 | 19.3 | 12.1 | 16.9 | 17.8 | 18.9 | 29.4 | 20.4 | 34.6 | 19.1 | 15.1 | 14.2 | 22 | 26.5 | 26.1 | 31.3 | 20 | 25 | 25 | 25 | 26.1 | 25 | 27
Spreadsheet: 104742d1302207389-formula-for-commission-report-sales-commission-template-revenue
Sheet: Pivot Table

 | Pivot on [NAME] |  | Note: [NAME] within [NAME] table to Refresh
 | Sum of Commission Payable | Customer
 | [NAME] | Acme Widgets | [NAME] | [NAME] | Delta Doors | Grand Total
 | [NAME] | 2815 | 3675 | 12500 | 1950 | 20940
 | [NAME] | 18 | 1350 | 5040.000000000001 |  | 6408.000000000001
 | [NAME] | 750 | 725 | 10 | 2115 | 3600
 | [NAME] | 12500 | 4807.25 | 35700 | 125 | 53132.25
 | Grand Total | 16083 | 10557.25 | 53250 | 4190 | 84080.25
Spreadsheet: 747468d1631529394-multi-rule-based-selection-sports-schedule
Sheet: Sheet1

 |  |  | GAME 1 |  | NATIONAL REFEREE
TEAMS | REFEREES
SLO | ITA 1
AUT | ITA 2 |  | GAME 2
GER | GER 1
FRA | GER 2
SWE | SLO 1 |  | GAME 3
ITA | SLO 2
GBR | SLO 3
 | GBR 1 |  | GAME 4
 | GBR 2
 |  |  | GAME 5
Spreadsheet: 158312d1338166288-need-help-with-find-macro-excel-forum-example
Sheet: Category

Administrative Jobs | Education
Accounting [NAME] or Assistant | [NAME]
Accounts Payable - Other | Admissions
Accounts Payable Administrator | Alumni Services
Accounts Payable Clerk | Art Teacher
Accounts Receivable - Other | Assistant professor
Accounts Receivable [NAME] | Co-op Programs
Accounts Receivable Processing | Co-ordinator Positions
Bilingual Collections | Consultant
Billing Administrator | Continuing Education
Bookkeeper | Corporate trainer
Collections | Counsellor
Payroll - Supervisory | Curriculum Development
Payroll Administrator | [NAME]
Payroll [NAME] | Director Positions
Payroll Professional | Distance Education
Accounts Receivable and Collections | [NAME]
Administrative Assistant - Accounting | ESL Teacher
Administrative Assistant - Customer Service | Early Childhood Educator
Administrative Assistant - Financial | Education Policy
Administrative Assistant - Insurance | English Teacher
Administrative Assistant - Junior\Intermediate | French Teacher
Administrative Assistant - Other | Fundraising
Administrative Assistant - Real Estate | Geography Teacher
Administrative Assistant - Recruitment\Staffing | History Teacher
Administrative Assistant - Senior | Human Resources
Junior Administrative Assistant - Legal | Instructional Design
Secretary - Legal | Instructor
Administrative Assistant - Legal | Intermediate Teacher
[NAME] | Learning Consultant
Clerk - Temporary | Managerial positions
Inventory\Warehouse [NAME] | Math Teacher
[NAME] | Montessori Teacher
Office [NAME] | Music Teacher
Shipping Clerk | Nursery School Teacher
Bilingual Executive Assistant | Occasional Teacher
Bilingual Receptionist | Ontario School Board Teacher
Bilingual Senior Administrative Assistant | Primary Teacher
[NAME] | Principals - Vice Principals
Bilingual - Other | Provost
Bilingual Administrative Assistant | Registrar
Bilingual Collections | School Librarian
Receptionist - Accounting | Spanish Teacher
Receptionist - Administrative Assistant | Special Education
Receptionist - Part Time | Speech Pathologist
Receptionist - Switchboard | Superintendent
Receptionist - Temporary\Contract | Supply Teacher
Receptionist - Office Assistant | Teacher (all)
Accounting Clerk \ Assistant | Tutoring
Accounts Payable | Vice-President
Accounts Payable - West | Academic Advisor
Accounts Receivable
Administrative Assistant
Administrative Assistant (legal)
Administrative Assistant - Temporary\Contract
Administrative Support
Bilingual Positions
Bilingual Receptionist
Bookkeeper
Clerical
Collections
Data Entry
Junior Administrative Assistant
[NAME]
Office Assistant
Office [NAME]
Office Manager
Office Services Assistant
Proofreader
Public Sector
Receptionist
Secretary (general)
Secretary (legal)
Secretary (medical)
Secretary (real estate)
Senior Administrative Assistant
Executive Assistant
Bilingual Executive Assistant
Office Manager
Senior Administrative Assistant
Executive Assistant
Spreadsheet: 92678d1292256013-search-multiple-worksheets-for-multiple-arrays-question
Sheet: House B

E |  | F |  | G |  | H
2010-01-11 00:00:00 | 1 | 2010-01-11 00:00:00 | 7 | 2010-01-11 00:00:00 | 13 | 2010-01-11 00:00:00 | 19
2010-02-11 00:00:00 | 2 | 2010-02-11 00:00:00 | 8 | 2010-02-11 00:00:00 | 14 | 2010-02-11 00:00:00 | 20
2010-03-11 00:00:00 | 3 | 2010-03-11 00:00:00 | 9 | 2010-03-11 00:00:00 | 15 | 2010-03-11 00:00:00 | 21
2010-04-11 00:00:00 | 4 | 2010-04-11 00:00:00 | 10 | 2010-04-11 00:00:00 | 1 | 2010-04-11 00:00:00 | 22
2010-05-11 00:00:00 | 5 | 2010-05-11 00:00:00 | 11 | 2010-05-11 00:00:00 | 17 | 2010-05-11 00:00:00 | 23
2010-06-11 00:00:00 | 6 | 2010-06-11 00:00:00 | 12 | 2010-06-11 00:00:00 | 18 | 2010-06-11 00:00:00 | 24
Spreadsheet: matt_motley__26415__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-16 00:00:00 | 20 | 21.5 | 16.25 | 17.5
Mid-Columbia | 2002-01-16 00:00:00 | 20 | 21.5 | 16.25 | 17.5
COB | 2002-01-16 00:00:00 | 23 | 23.5 | 17.25 | 17.5
N. California | 2002-01-16 00:00:00 | 25 | 28 | 17.25 | 20
Midway/Sylmar | 2002-01-16 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-16 00:00:00 | 25 | 27.25 | 16.75 | 19.5
Mead | 2002-01-16 00:00:00 | 25 | 27 | 18 | 19
Palo Verde | 2002-01-16 00:00:00 | 23.95 | 27.5 | 16 | 18.25
Inland SW | 2002-01-16 00:00:00 | 23.95 | 27.75 | 16 | 19
4-Corners | 2002-01-16 00:00:00 | 24 | 26 | 16 | 17
Central Rockies | 2002-01-16 00:00:00 | 19.75 | 24 | 14.5 | 16
Spreadsheet: 58634d1258898150-formula-for-if-column-a-x-then-column-b-y-book2
Sheet: Book2

catid | groupid | vendor | title | code | url | course_location
255 | 1 | Microsoft | Designing and Planning an Exchange Server 2003 Organization | 2008 | index.php?option=com_content&view=article&id=161&Itemid=306 | Melbourne
257 | 2 | Microsoft | Troubleshooting Microsoft Exchange Server 2003 | 2011 | index.php?option=com_content&view=article&id=162&Itemid=307 | Sydney
260 | 3 | Novell | Novell Networking and Services | 2000 | index.php?option=com_content&view=article&id=265&Itemid=502 | Brisbane
254 | 4 | Microsoft | Supporting Users Running the Microsoft Windows XP Operating System | 2261 | index.php?option=com_content&view=article&id=146&Itemid=423 | Perth
261 | 5 | Novell | Novell Networking and Services | 2000 | index.php?option=com_content&view=article&id=265&Itemid=502 | Canberra
250 | 6 | Microsoft | Supporting Users Running Applications on a Microsoft Windows XP Operating System | 2262 | index.php?option=com_content&view=article&id=147&Itemid=424 | Adelaide
256 | 7 | Microsoft | Designing and Planning an Exchange Server 2003 Organization | 2008 | index.php?option=com_content&view=article&id=161&Itemid=306 | Singapore
Spreadsheet: 01a312c4-e979-4c86-879b-f1ada5e97c03
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 27. LEASE FINANCE COMMITMENTS, Summary:Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total lease finance commitments ; |  |  | Original | A2414208C | 1975-10-01 00:00:00 | 2011-02-01 00:00:00 | 425 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Seasonally Adjusted | A2414207A | 1975-10-01 00:00:00 | 2011-02-01 00:00:00 | 425 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Trend | A2414206X | 1975-10-01 00:00:00 | 2011-02-01 00:00:00 | 425 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 151373d1334874669-copying-data-to-another-worksheet-ist-answer-sheet
Sheet: TEST #2

TEST 02 ANSWERS
POSITION |  | 0 |  |  | INIT | 0
LAST NAME |  | 0
1 | B |  | 0
2 | C |  | 0
3 | C |  | 0
4 | A |  | 0
5 | B |  | 0
6 | D |  | 0
7 | B |  | 0
8 | B |  | 0
9 | D |  | 0
10 | C |  | 0
11 | B |  | 0
12 | C |  | 0
13 | C |  | 0
14 | A |  | 0
15 | B |  | 0
16 | D |  | 0
17 | A |  | 0
18 | D |  | 0
19 | B |  | 0
20 | C |  | 0
21 | D |  | 0
22 | B |  | 0
23 | C |  | 0
24 | D |  | 0
25 | A |  | 0
 |  |  | 0 | Points
 |  |  | 0 | %
Spreadsheet: louise_kitchen__22796__West Position0315-01
Sheet: West Power Position

Username:
Password:
Database: | pwrprodn_ded
Daily Position Folder | C:\
Price Folder
WEST POSITION
All positions are PV'd | All Years | 2000 |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2015
2001-03-15 00:00:00 | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
Peak
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Total
 | All Years | 2000 |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2015
 | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
Off-peak
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Total
 | All Years | 2000 |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2015
Grand Total | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Grand Total
ALBERTA POSITION
All positions are PV'd | All Years | 2000 |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2015
 | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
Peak
ALBERTA
Total
 | All Years | 2000 |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2015
 | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
Off-peak
ALBERTA
Total
 | All Years | 2000 |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2015
Grand Total | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
ALBERTA
Grand Total
 | All Years | 2000 |  |  | 2001 |  |  |  |  |  |  |  | 2002-2015
Gas position contracts | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
Sumas (Daily) |  | 0 |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0
Gas position [NAME]'s | total | 2000-12-01 00:00:00 | Total-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Total-01 | Total-02 | Total-03 | Q1 | Q2 | Q3 | Q4 | Total
Sumas (Daily)