tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 821092d1678441984-vba-code-compiles-data-in-new-sheet-except-if-there-is-only-one-line-of-data-road-speed-limit-violations-new-_2023-03-10_0728
Sheet: 215 CA215886

 |  |  |  | Road Speed Limit Violations
 |  |  |  | Time frame: Manual | Resource type: 90 Resources In 3 groups | Duration: All
 |  |  |  | Created: 10/03/2023 07:28:13 | Account: Hylton Ross Tours (Pty) Ltd
 | 215 CA215886 Report Totals for 03/03/2023 06:30:00 - 10/03/2023 06:15:00 (UTC+02:00) Harare, Pretoria
 | No. of Events |  |  |  |  |  |  | [NAME] |  |  |  |  | Total Duration
 | 9 |  |  |  |  |  |  | 83km/h |  |  |  |  | 00h00m33s
 | Start Time |  |  |  | Resource |  | Actual Speed |  | RSS Limit | Duration | Location
 | 2023-03-07 09:43:03.110000 |  |  |  | 215 CA215886 |  | 72 |  | 60 | 00:00:00 | [NAME] Stel, Pollsmoor, Cape Town, Western Cape
 | 2023-03-07 09:50:31.060000 |  |  |  | 215 CA215886 |  | 63 |  | 60 | 00:00:32 | [NAME], Lakeside, Cape Town, Western Cape
 | 2023-03-07 11:46:59.600000 |  |  |  | 215 CA215886 |  | 61 |  | 60 | 00:00:00 | Main, Bay View Village, [NAME]'s Town, Western Cape
 | 2023-03-07 11:53:55.580000 |  |  |  | 215 CA215886 |  | 62 |  | 60 | 00:00:00 | [NAME] (M6), Sunnydale, [NAME], Western Cape
 | 2023-03-07 11:58:43.150000 |  |  |  | 215 CA215886 |  | 71 |  | 70 | 00:00:00 | [NAME], [NAME], Noordhoek, Western Cape
 | 2023-03-07 14:50:00.560000 |  |  |  | 215 CA215886 |  | 61 |  | 60 | 00:00:00 | [NAME] Stel, Wynberg, Cape Town, Western Cape
 | 2023-03-07 19:21:46.500000 |  |  |  | 215 CA215886 |  | 61 |  | 60 | 00:00:00 | [NAME], Green Point, Cape Town, Western Cape
 | 2023-03-09 09:41:38.020000 |  |  |  | 215 CA215886 |  | 73 |  | 60 | 00:00:01 | [NAME] (N2), Foreshore, Cape Town, Western Cape
 | 2023-03-09 09:42:27.600000 |  |  |  | 215 CA215886 |  | 83 |  | 80 | 00:00:00 | [NAME], Zonnebloem, Cape Town, Western Cape
Spreadsheet: 791427d1660330274-find-number-of-streaks-in-a-row-and-length-of-each-streak-sample
Sheet: Sheet1

0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 1 | 0 | 0 | 0 |  | 3
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 1 | 0 |  | 1
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 1 | 1 | 0 | 1 | 0 |  | 4
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 1 | 0 | 0 | 1 | 0 |  | 2
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 1 |  | 1
0 | 1 | 1 | 0 | 0 | 0 |  | 3
0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: Memo TB

Service Delivery Areas | Impact Indicators | IndicatorTypes | Outcome Indicators | DataSources
please select… | please select… | please select… | please select… | please select…
Improving diagnosis | TB prevalence rate | impact | Case detection | National Health Accounts
Standardized treatment, patient support and patient charter | TB incidence rate | outcome | Treatment success rate | DHS/DHS+ (Demographic and Health Survey)
Procurement and supply management | TB mortality rate |  | Smear conversion rate | [NAME] (Multiple Indicator [NAME])
M&E |  |  |  | AIS (AIDS Indicator Survey)
TB/HIV |  |  |  | SAMS (Service Availibility Mapping Survey)
MDR-TB |  |  |  | BSS (Behavioral and Surveillance Survey)
High-risk groups |  |  |  | Sentinel surveillance
HSS (beyond TB) |  |  |  | Serological surveys
PAL (Practical Approach to Lung Health) |  |  |  | Prevalence surveys
PPM / ISTC (Public-Public, Public-Private Mix (PPM) approaches and International standards for TB care) |  |  |  | Facility-based survey
ACSM ([NAME], communication and social mobilization) |  |  |  | Key informant survey
Community TB care |  |  |  | Specific surveys (to be defined)
Programme-based operational research |  |  |  | Civil registration systems (vital/disease specific registration)
 |  |  |  | Census
 |  |  |  | Health service statistics
 |  |  |  | Patient register
 |  |  |  | Clinical cohort follow-up studies
 |  |  |  | Community services assessment
 |  |  |  | Records: laboratory, patient (e.g. treatment cards), training, certification, other (to be specified)
 |  |  |  | Operational research
 |  |  |  | R&R TB system, quarterly report
 |  |  |  | R&R TB system, yearly management report
 |  |  |  | Other Surveillance reports, specify
Spreadsheet: 164adde6-4cef-4d6c-902c-19b7355adaa3
Sheet: Sheet1

 |  |  | Authority to Raise a Requisition or Make a Credit Card Payment
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Version 2.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar 2012
 |  |  |  | Faculty/ Department:
 |  |  |  |  |  |  |  |  |  |  |  | Req entered into Psoft by:
([NAME]) |  |  | Purchase Order |  | MasterCard |  | Amex Travel
Vendor ID: |  |  |  |  |  |  |  |  |  |  |  | Date: | /      /20
Vendor Name:
Vendor Address: |  |  |  |  |  |  |  |  |  |  |  | Req No:
 |  |  |  |  |  |  |  |  |  |  | Requester:
 | Please arrange purchase of:
Line | Item Description |  |  |  |  | GST on purchase Y/N? | Unit$ (GST excl) | Qty | $[NAME] (GST exclusive) | Account | Fund | Dept | Prog | Project
1 |  |  |  |  |  |  |  |  |  |  | 2
2 |  |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  |  | 2
4 |  |  |  |  |  |  |  |  |  |  | 2
5 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | TOTAL $
Requested by: |  | Name: |  |  |  | Signature |  |  |  |  | Date: | /         / 20
Authorised by |  | Name: |  |  |  | Signature |  |  |  |  | Date: | /         / 20
Authorised by |  | Name: |  |  |  | Signature |  |  |  |  | Date: | /         / 20
Special instructions:  ([NAME]) |  |  |  | Amount Only PO |  | Prepayment |  |  | Portable & Attractive Item
For Vendor |  | Details
For Procurement |  | Details
Delivery |  | Details
Spreadsheet: 844923d1696523988-create-unique-list-when-column-locations-change-employee-ids-ans2
Sheet: Sheet1

 |  | EID |  |  |  | Relationship |  |  |  |  |  |  |  |  | Outcome |  | FORMULA
 |  | 123 |  |  |  | Employee |  |  |  |  |  |  |  |  | 123
 |  | 123 |  |  |  | Spouse |  |  |  |  |  |  |  |  | 456
 |  | 123 |  |  |  | Child |  |  |  |  |  |  |  |  | 789
 |  | 456 |  |  |  | Employee |  |  |  |  |  |  |  |  | RT
 |  | 789 |  |  |  | Employee
 |  | RT |  |  |  | Employee
 |  | GT |  |  |  | Spouse
 |  | GT |  |  |  | Child
 |  | GT |  |  |  | Child
Spreadsheet: 125146d1318906216-complicated-if-and-match-command-example
Sheet: Sheet1

 | POSSIBLE COMBINATION
 | Item | [NAME] | Packaging
 | apple | red delicious | pack1
 | apple | fuji | pack1
 | apple | pink lady | pack1
 | orange | mandarin | pack2
 | orange | navel | pack2
 | orange | [NAME] | pack2
 | squash | [NAME] | [NAME]
 | squash | butternut | [NAME]
 | squash | [NAME] | [NAME]
 | USER INPUT
 | Item | [NAME] | Packaging | Qty
1 | apple | fuji | pack 1 | 2
2 | apple | pink lady | pack 1 | 5
3 | orange | [NAME] | pack 2 | 7
4 | orange | mandarin | pack 2 | 19
5 | squash | butternut | pack 3 | 9
 | WANT
 | To show subtotal for each pack type
 | ie. as per above input
 | Pack 1 | 7
 | Pack 2 | 26
 | Pack 3 | 9
 | What formula is used to be able to calculate QTY for each Pack type?
Spreadsheet: 855929d1705371855-auotmate-test-results-with-formulas-forum-help-1-
Sheet: Sheet1

Application | RESULT | BACK 2 BACK | TEST # | BLOCK PASS
EASE | PASS |  | 1
EASE | PASS | Y | 2
EASE | FAIL |  | 3
EASE | FAIL |  | 4 | Y
GCAS | PASS |  | 1
GCAS | FAIL |  | 2
GCAS | PASS |  | 3
GCAS | FAIL | N | 4
SORD | PASS |  | 1
SORD | FAIL |  | 2
SORD | PASS |  | 3
SORD | PASS | Y | 4 | Y
AGILE | FAIL |  | 1
AGILE | PASS |  | 2
AGILE | FAIL | N | 3
SAMG | PASS |  | 1
SAMG | PASS |  | 2
SAMG | PASS | Y | 3 | Y
Spreadsheet: 492316d1481032517-conditional-formatting-formula-forum-file
Sheet: DASH V

 | P R A T A P   K U M A R   K
 | CASH
 | Opening | 3782
 | Credit
 | Debit
 | Closing
 | SBI
 | Opening | 6811.87
 | Credit
 | Debit
 | Closing
 | IB
 | Opening | 10300.71
 | Credit
 | Debit
 | Closing
 | TOTAL
Spreadsheet: 99ae44b0-8fbe-449c-8768-2eb6a7fa8e7d
Sheet: Summary

 | Replacement Summary Price Sheet
 | Design Development and Implementation (DDI)
 | [NAME] | Total | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 | Phase I
 | Phase II
 | Phase III
 | Subtotal
 | DDI - Facilities | Total | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 | Development Facility
 | Data Center (Vendor Facility)
 | Installation/Configuration Costs (State Facility)
 | Facility Build-Out
 | Subtotal
 | Hardware | Total | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 | Total Cost
 | [NAME]
 | Subtotal
 | Software | Total | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 | Total Cost
 | [NAME]
 | Subtotal
 | Total DDI Cost
 | Operations
 |  | TOTAL | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021
 | [NAME]
 | Operations beginning before Month 15
 | Facilities
 | Professional Services
 | Operations beginning in Month 15
 | Facilities
 | Professional Services
 | Subtotal
 | Total Operations Cost
 | Total Cost (DDI + Operations)
 | Total price for Proposal Evaluation*
 | Note - For evaluation purposes, the State will deduct all pricing related to operations beginning before Month 15 of the contract, build out costs for the DDI facility, and build out costs for the operations facility from the total price.  These will be added back into the contract of the winning bidder.
Spreadsheet: 838648d1691221146-formula-to-lookup-id-in-multiple-worksheets-then-return-a-value-sample-book2
Sheet: Sheet1

 |  |  | * [NAME] to find ID in column C in three tabs.
 |  |  |  |  |  |  | What it should be:
 |  | 025577 |  |  |  |  | 025577 | [NAME] A
 |  | 031067 | [NAME] A |  |  |  | 031067 | [NAME] A
 |  | [NAME] | [NAME] |  |  |  | [NAME] | [NAME]
 |  | 008066 | [NAME] A; [NAME] |  |  |  | 008066 | [NAME] A; [NAME]
 |  | 031096 | [NAME] |  |  |  | 031096 | [NAME]
 |  | 040454 | [NAME] |  |  |  | 040454 | [NAME]
 |  | 044494 | [NAME] |  |  |  | 044494 | [NAME]
 |  | P0000518682 | [NAME]; [NAME] A |  |  |  | P0000518682 | [NAME]; [NAME] A
 |  | 031808 | [NAME] |  |  |  | 031808 | [NAME]
 |  | 029614 | [NAME] A |  |  |  | 029614 | [NAME] A
Spreadsheet: 676827d1589008579-google-sheets-help-to-track-trucks-sample-uploaded-2020-05-09-oeldere-serrawces-pt-676786d1588968645-a-beginner-need-help-to-track-trucks-sample
Sheet: HOLLONGI GATE

TRUCKER LINE LISTING FROM POINT OF ENTRY
Kolom1 | Kolom2 | Kolom3 | Kolom4 | Kolom5 | Kolom6 | Kolom7 | Kolom8 | Kolom9 | Kolom10 | Kolom11
REGISTER ENTRY FROM 03-05-2020 (8AM) TILL :
 |  |  |  |  |  |  |  | ENTRY | EXIT
SL/NO. | NAME (AS PER ID) | AGE | SEX | CONTACT NO. | VEHICLE  REG. NUMBER (NO "SPACE" OR "/" OR "-") | COMING FROM | DROPPING LOCATION (FULL ADDRESS) | DATE (DAY/MONTH/YEAR) EG. 3/5/2020 | DATE (DAY/MONTH/YEAR) EG. 3/5/20202 | REMARKS
1 | MANOJ NATH | 30 | M | 60091045 | AS07AC9565 | HOLLONGI | CHIMPU, ITANAGAR | 2020-05-03 00:00:00 | 2020-03-05 12:37:00
2 | ABUL BASAR | 27 | M | 69096675156 | AS07AC6505 | B/CHARALI | NAHARLAGUN | 2020-05-03 00:00:00
3 | MD. ROSIDUL ISLAM | 31 | M | 940271824 | AR01M4523 | GHOPUR,ASSAM | NAHARLAGUN | 2020-05-03 00:00:00
 | MD. SHAZAHAN ALI | 26 | M | 700543492 | AR01M4523 | GHOPUR,ASSAM | NAHARLAGUN | 2020-05-03 00:00:00
 | MD ISLAM | 23 | M |  | AR01M4523 | GHOPUR,ASSAM | NAHARLAGUN | 2020-05-03 00:00:00
4 | SAJAHAN ALI | 20 | M | 764008211 | AR01K7842 | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
 | SADAM ALI | 16 | M |  | AR01K7842 | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
5 | MD. [NAME] | 30 | M | 98838224 | AR027559 | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
 | AJAY RAY | 36 | M | 56838224 | AR027559 | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
6 | MD. RAZZAK ALI | 28 | M | 4191398 | AR02L6233 | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
 | DINESH RAUT | 45 | M | 7224050 | AR02L6233 | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
7 | ANIL BARMAN | 33 | M | 74170087 | HAIDER ALI | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
 | HAIDER ALI | 30 | M | 7470087 | HAIDER ALI | HOLLONGI | NAHARLAGUN | 2020-05-03 00:00:00
8 | MANORANJAN NARZARY | 34 | M | 273847 | AS07AC9132 | HOLLONGI | ITANAGAR | 2020-05-03 00:00:00 | 2020-03-05 00:00:00
9 | SADIK ALI | 20 | M | 9089881 | AS07AC6508 | HOLLONGI | NAHARLAGAN | 2020-05-04 00:00:00 | 2020-05-04 00:00:00
 | MUJAMMEL ALI | 34 | M | 94277163 | AS07AC6508 | HOLLONGI | NAHARLAGUN | 2020-05-04 00:00:00 | 2020-05-04 00:00:00
10 | NARAYAN MAITI | 38 | M | 9210131 | AS12E1733 | HOLLONGI | GOHPUR | 2020-05-04 00:00:00 | 2020-03-05 00:00:00
Spreadsheet: 204453d1357538974-assistance-with-linking-data-in-excel-between-spreadsheet-and-template-test1
Sheet: Sheet1

QUOTATION NUMBER
TO: | (‘Hirer’) | FROM: | Choose your name
ATTN: |  | PHONE: | Choose your phone.
DATE: | Click here to enter a date. | FAX NO:
EMAIL: |  | MOBILE
PHONE: |  | EMAIL:
Description of Goods or Services: | We are pleased to submit our pricing for the hire of the following equipment
Included in our Price: | ·                Machinery
 | ·                Operating and Service manuals (where applicable)
 | ·                [NAME]PPE for Operators and Riggers
 | ·                Standard Lifting Equipment
Clients Responsibility: | ·                Any specialised rigging equipment and/or non standard lifting equipment
 | ·                Clear Access including safe access to any lifting points for rigging
 | ·                Clean Hard Standing
 | ·                Suitable Lifting Points & Special Lifting gear if required
 | ·                Confirmation of Weights
 | ·                Any site J.S.A.s & Permits if required
 | ·                Any delays beyond BOOM Logistics control
 | ·                Opportunity for Operator/ Riggers to have a ½ hour meal break before 1.30pm weekdays  if not overtime penalties will apply from 1.30pm
 | ·                Inductions
 | ·                Suitable ensuite accommodation and messing to be provided as per EBA – if accommodation is required Boom can provide at cost plus 10%
 | ·                Travel from accommodation to site and return. BOOM can provide a light vehicle at a quoted price.
 | ·                Flights if required.
Additional Charges: | ·                GST – All Rates are exclusive of and subject to GST
 | ·                Any specialized site entry requirements’ costs  and clearance certifications
 | ·                Any applicable site allowances, project allowances and conditions  to be charged back at cost  - subject to review of project specific EBA’s.
 | ·                Overtime for Operators & Riggers at $60p/hr charged outside the hours of 6am-4pm and on Public Holidays and Weekends and if no 10hr break is supplied.
 | ·                Living away from allowance (LAFHA) of $56.00 per person per day if required.
 | ·                Any medicals, inductions, D&A’s to be charged back at cost plus 5%
 | ·                Light vehicle charges if required at $200 per day
 | ·                Supervision if required on site $[NAME]
Spreadsheet: 195267d1353466239-excel-question-vlookup-need-help-with-reformatting-data-in-excel-pt-help-request-answer
Sheet: Sheet1

Sample | Well | Target | Ct |  | Sample | Well | Target | Ct |  | Here is a pivot table of your red data.
1 | A1 | GOI1 | 22.1 |  | 1 | A1 | REF1 | 23.1 |  | Where I've changes some Options and totals to make it look like the below.
1 | A1 | REF1 | 23.1 |  | 5 | A5 | REF1 | 22.1
2 | A2 | [NAME] | 21.2 |  | 7 | B1 | REF1 | 13.1
2 | A2 | REF2 | 24.2 |  | 11 | B5 | REF1 | 12.1
3 | A3 | GOI3 | 22.3
3 | A3 | [NAME] | 22.3 |  | Sample | Well | Target | Ct |  | Target | Sample | Well | Sum of Ct
4 | A4 | GOI4 | 21.4 |  | 2 | A2 | REF2 | 24.2 |  | GOI1 | 1 | A1 | 22.1
4 | A4 | REF4 | 25.4 |  | 6 | A6 | REF2 | 22.2 |  | GOI1 | 5 | A5 | 21.1
5 | A5 | GOI1 | 21.1 |  | 8 | B2 | REF2 | 14.2 |  | GOI1 | 7 | B1 | 12.1
5 | A5 | REF1 | 22.1 |  | 12 | B6 | REF2 | 12.2 |  | GOI1 | 11 | B5 | 11.1
6 | A6 | [NAME] | 21.2 |  |  |  |  |  |  | [NAME] | 2 | A2 | 21.2
6 | A6 | REF2 | 22.2 |  | Sample | Well | Target | Ct |  | [NAME] | 6 | A6 | 21.2
7 | B1 | GOI1 | 12.1 |  | 3 | A3 | [NAME] | 22.3 |  | [NAME] | 8 | B2 | 11.2
7 | B1 | REF1 | 13.1 |  | 9 | B3 | [NAME] | 12.3 |  | [NAME] | 12 | B6 | 11.2
8 | B2 | [NAME] | 11.2 |  |  |  |  |  |  | GOI3 | 3 | A3 | 22.3
8 | B2 | REF2 | 14.2 |  | Sample | Well | Target | Ct |  | GOI3 | 9 | B3 | 12.3
9 | B3 | GOI3 | 12.3 |  | 4 | A4 | REF4 | 25.4 |  | GOI4 | 4 | A4 | 21.4
9 | B3 | [NAME] | 12.3 |  | 10 | B4 | REF4 | 15.4 |  | GOI4 | 10 | B4 | 11.4
10 | B4 | GOI4 | 11.4 |  |  |  |  |  |  | REF1 | 1 | A1 | 23.1
10 | B4 | REF4 | 15.4 |  | Sample | Well | Target | Ct |  | REF1 | 5 | A5 | 22.1
11 | B5 | GOI1 | 11.1 |  | 1 | A1 | GOI1 | 22.1 |  | REF1 | 7 | B1 | 13.1
11 | B5 | REF1 | 12.1 |  | 5 | A5 | GOI1 | 21.1 |  | REF1 | 11 | B5 | 12.1
12 | B6 | [NAME] | 11.2 |  | 7 | B1 | GOI1 | 12.1 |  | REF2 | 2 | A2 | 24.2
12 | B6 | REF2 | 12.2 |  | 11 | B5 | GOI1 | 11.1 |  | REF2 | 6 | A6 | 22.2
 |  |  |  |  |  |  |  |  |  | REF2 | 8 | B2 | 14.2
 |  |  |  |  | Sample | Well | Target | Ct |  | REF2 | 12 | B6 | 12.2
 |  |  |  |  | 2 | A2 | [NAME] | 21.2 |  | [NAME] | 3 | A3 | 22.3
 |  |  |  |  | 6 | A6 | [NAME] | 21.2 |  | [NAME] | 9 | B3 | 12.3
 |  |  |  |  | 8 | B2 | [NAME] | 11.2 |  | REF4 | 4 | A4 | 25.4
 |  |  |  |  | 12 | B6 | [NAME] | 11.2 |  | REF4 | 10 | B4 | 15.4
 |  |  |  |  | Sample | Well | Target | Ct
 |  |  |  |  | 3 | A3 | GOI3 | 22.3
 |  |  |  |  | 9 | B3 | GOI3 | 12.3
 |  |  |  |  | Sample | Well | Target | Ct
 |  |  |  |  | 4 | A4 | GOI4 | 21.4
 |  |  |  |  | 10 | B4 | GOI4 | 11.4
Spreadsheet: mary_fischer__25612__32G
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF LONG-TERM DEBT
 |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER |  |  |  |  |  |  |  | 0
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 45712d1244541667-excel-2007-duplicates-in-different-colors-test
Sheet: Sheet1

1 | 10 | a |  |  | 4 | c
2 | 11 | b |  |  | 5 | 13
3 | 12 | c |  |  | e | 9
4 | 13 | d |  |  |  | 18
5 | 14 | e
6 | 15 | f
7 | 16 | g
8 | 17 | h
9 | 18 | i
Spreadsheet: john_griffith__16042__2_6_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 54 | 370 | 470 | 37.7 | 47.9 | 1.45 | 2002-02-06 11:20:00
 | HO J2 | 54 | 660 | 760 | 42.9 | 49.4 | 1.57 | 2002-02-06 11:20:00
 | HO K2 | 54 | 820 | 920 | 41.6 | 46.7 | 1.5 | 2002-02-06 11:20:00
 | HO M2 | 55 | 960 | 1060 | 40.2 | 44.4 | 1.46 | 2002-02-06 11:20:00
 | HO N2 | 55 | 1020 | 1120 | 38.3 | 42.1 | 1.39 | 2002-02-06 11:20:00
 | HO Q2 | 56 | 1100 | 1200 | 36.8 | 40.2 | 1.36 | 2002-02-06 11:20:00
 | HO U2 | 57 | 1200 | 1300 | 36.4 | 39.5 | 1.36 | 2002-02-06 11:20:00
 | [NAME] | 58 | 1250 | 1375 | 35 | 38.5 | 1.34 | 2002-02-06 11:20:00
 | HO X2 | 58 | 1300 | 1425 | 34.1 | 37.4 | 1.3 | 2002-02-06 11:20:00
 | [NAME] | 59 | 1325 | 1475 | 32.7 | 36.4 | 1.28 | 2002-02-06 11:20:00
 | HO F3 | 60 | 1375 | 1525 | 31.9 | 35.5 | 1.27 | 2002-02-06 11:20:00
 | [NAME] |  |  |  | 31 | 34.3 | 1.25 | 2002-02-04 14:55:00
 | HO H3 |  |  |  | 32.5 | 35.9 | 1.27 | 2002-01-31 15:07:00
 | HO J3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO M3
Spreadsheet: 130503d1322391587-forecast-function-book1
Sheet: Sheet1

x | y
0 | 1
-0.5 | 0.87
-1 | 0.75
-1.5 | 0.65
-2 | 0.55
-2.5 | 0.46
-3 | 0.38
-3.5 | 0.3
-4 | 0.23
-4.5 | 0.17
-5 | 0.13
-5.5 | 0.09
-6 | 0.07
-6.5 | 0.06
-7 | 0.05
-7.5 | 0.04
-8 | 0.03
-8.5 | 0.02
-9 | 0.02
-9.5 | 0.01
Spreadsheet: benjamin_rogers__1164__FPL
Sheet: Orion

 | PSEG RESOURCES, INC.
 | Activity/Strategy:
 | Comments:
 | Summary: | North America |  |  |  |  |  |  |  |  |  |  | North America (Net Equity) |  |  | International (Net Equity)
 |  | Net Equity (Op & Construction) | Operation |  |  | Construction |  |  | Pending Acquisition |  |  | Operation | Construction | Pending Acq | Operation | Construction | Development
 |  | (MW) | Plants | MW | Net Equity | Plants | MW | Net Equity | Plants | MW | Net Equity | MW | MW | MW | MW | MW | MW
 | Company Type :
 | Stock Exchange:
 | [NAME]:
 | Holding Company:
 | Power Marketing:
 | Subsidiary/ Affiliate:
 | Web Page:
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 0 | 0
2 | 0 | 0
3 | 0 | 0
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 326755
2001-07-10 00:00:00
Spreadsheet: 8c2907a4-4bc6-484a-8d46-6f0506cb3995
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6416 | 46796 | Polina | [NAME] | RUS | 161 | 00:19:10 | 00:00:00 | 00:45:02 | 00:00:00 | 00:25:01 | 1 | 01:29:15
6416 | 7616 | [NAME] | Springman | GBR | 160 | 00:17:19 | 00:00:00 | 00:43:10 | 00:00:00 | 00:28:44 | 2 | 01:29:15