tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 01dc3d1d-4fca-45a7-a1fa-19ebdb6cb3a0
Sheet: Sheet1

The Top 25 Current Executives | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | NAME | ORGANIZATION | SECTOR | TOTAL COMPENSATION (1)
1. | [NAME] | National Football League | Sports | 11554000
2. | [NAME] | American Petroleum Institute | Energy | 6428872
3. | [NAME] | U.S. Chamber of Commerce | General Business | 4761900
4. | [NAME] | Blue Cross and Blue Shield Assn. | Insurance | 4308746
5. | [NAME] | Institute of Intl. Finance | Banking, Finance | 4148996
6. | [NAME] | Edison Electric Institute | Energy | 4006893
7. | [NAME] | Securities Industry and Financial Markets Assn. | Banking, Finance | 3002672
8. | [NAME] | Grocery Manufacturers Assn. | Food/Beverage | 2850438
9. | [NAME] | Investment Company Institute | Banking, Finance | 2792985
10. | [NAME] | Financial Industry Regulatory Authority | Banking, Finance | 2609354
11. | [NAME] | National Restaurant Assn. | Sales, Service | 2606784
12. | [NAME] | Intl. Council of Shopping Centers | Sales, Service | 2490740
13. | [NAME] | American Cancer Society | Health | 2401112
14. | [NAME] | American Chemistry Council | Manufacturing | 2311499
15. | [NAME] | Nuclear Energy Institute | Energy | 2057734
16. | [NAME] | National Assn. of Chain Drug Stores | Health | 2049497
17. | [NAME] (2) | National Football League Players Assn. | Labor Unions | 1962408
18. | [NAME] | National Assn. of Realtors | Real Estate | 1938726
19. | [NAME] | Financial Services Roundtable | Banking, Finance | 1807094
20. | [NAME] | Managed Funds Assn. | Banking, Finance | 1788296
21. | [NAME] | American Hospital Assn. | Health | 1755932
22. | [NAME] | Wildlife Conservation Society | Public Interest Groups | 1675327
23. | [NAME] | American Coalition for Clean Coal Electricity | Energy | 1655942
24. | [NAME] | National Rural Electric Cooperative Assn. | Energy | 1637897
25. | [NAME] | Federation of American Hospitals | Health | 1636695
Footnotes
1.Total compensation includes deferred compensation, benefits, and bonuses.
2. [NAME] is for 10 months.
Spreadsheet: 805f5234-aae8-440a-b9cc-7accaf22d13c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MOLD1 | Test | MOLD1 | Mold Panel | Mold Panel | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
MOLD1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MOLD1 | Result | MOLD1 | Mold Panel | Mold Panel | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 30183-8
Spreadsheet: 88927d1288730893-stock-valuation-help-example
Sheet: Sheet1

Part | Qty In Stock @ 31/12/2010 | Qty RCVD | Date | Purchase Price
product 1 | 6000 | 2000 | 2010-01-22 00:00:00 | 1
product 1 | 6000 | 123 | 2010-02-22 00:00:00 | 1.6
product 1 | 6000 | 150 | 2010-06-26 00:00:00 | 1.58
product 1 | 6000 | 10000 | 2010-08-30 00:00:00 | 0.9 | 5990 | 5391
product 1 | 6000 | 10 | 2010-10-31 00:00:00 | 2.2 |  | 22
 |  |  |  |  |  | 0.9021666666666667
product 2 | 36000 | 2000 | 2010-01-01 00:00:00 | 5.1
product 2 | 36000 | 100 | 2010-01-30 00:00:00 | 7.2
product 2 | 36000 | 6000 | 2010-03-30 00:00:00 | 4.8
product 2 | 36000 | 8000 | 2010-04-05 00:00:00 | 4.5 | 7960 | 35820
product 2 | 36000 | 3000 | 2010-06-16 00:00:00 | 5.05 |  | 15150
product 2 | 36000 | 1520 | 2010-06-30 00:00:00 | 6 |  | 9120
product 2 | 36000 | 12000 | 2010-07-15 00:00:00 | 4.4 |  | 52800.00000000001
product 2 | 36000 | 6520 | 2010-08-25 00:00:00 | 6 |  | 39120
product 2 | 36000 | 2000 | 2010-09-10 00:00:00 | 7.05 |  | 14100
product 2 | 36000 | 3000 | 2010-09-15 00:00:00 | 6.9 |  | 20700
 |  |  |  |  |  | 5.189166666666667
Spreadsheet: a2644d44-bf69-4531-9c6a-58f6fe391caa
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/11/2011 | Men's Basketball | Oral Roberts | 12:00 AM | W, 78-71
11/15/2011 | Men's Basketball | [NAME] | 12:00 AM | L, 60-70
11/17/2011 | Men's Basketball | Alcorn State | 12:00 AM | W, 97-62
11/22/2011 | Men's Basketball | Morehead State (Charleston, W.Va.) | 12:00 AM | W, 83-48
11/28/2011 | Men's Basketball | Akron | 12:00 AM | W, 77-56
12/03/2011 | Men's Basketball | at Mississippi State | 12:00 AM | L, 62-75
12/08/2011 | Men's Basketball | vs. Kansas State (Wichita, Kan.) | 12:00 AM | W, 85-80 (2OT)
12/10/2011 | Men's Basketball | Miami | 12:00 AM | W, 77-66
12/17/2011 | Men's Basketball | Texas [NAME] | 12:00 AM | W, 84-64
12/19/2011 | Men's Basketball | Tennessee Tech | 12:00 AM | W, 72-53
12/22/2011 | Men's Basketball | vs. Missouri State (Las Vegas, Nev.) | 12:00 AM | W, 70-68 (OT)
12/23/2011 | Men's Basketball | vs. [NAME] (Las Vegas, Nev.) | 12:00 AM | L, 81-83 (OT)
12/28/2011 | Men's Basketball | Villanova | 12:00 AM | W, 83-69
12/30/2011 | Men's Basketball | at Seton Hall | 12:00 AM | L, 48-67
01/04/2012 | Men's Basketball | at Rutgers | 12:00 AM | W, 85-64
01/07/2012 | Men's Basketball | Georgetown | 12:00 AM | W, 74-62
01/09/2012 | Men's Basketball | vs. Connecticut (Hartford, Conn.) | 12:00 AM | L, 57-64
01/14/2012 | Men's Basketball | Rutgers | 12:00 AM | W, 84-64
01/18/2012 | Men's Basketball | vs. [NAME] (Charleston, W.Va.) | 12:00 AM | W, 78-62
01/21/2012 | Men's Basketball | Cincinnati | 12:00 AM | W, 77-74 (OT)
01/25/2012 | Men's Basketball | at St. John's (Madison Square Garden) | 12:00 AM | L, 62-78
01/28/2012 | Men's Basketball | at Syracuse | 12:00 AM | L, 61-63
01/30/2012 | Men's Basketball | Pitt | 12:00 AM | L, 66-72
[NAME] | Men's Basketball | at Providence | 12:00 AM | W, 87-84 (OT)
02/08/2012 | Men's Basketball | Notre Dame | 12:00 AM | L, 51-55
02/11/2012 | Men's Basketball | Louisville | 12:00 AM | L, 74-77
02/16/2012 | Men's Basketball | at Pitt | 12:00 AM | W, 66-48
02/22/2012 | Men's Basketball | at Notre Dame | 12:00 AM | L, 44-71
02/24/2012 | Men's Basketball | Marquette | 12:00 AM | L, 60-61
02/28/2012 | Men's Basketball | [NAME] | 12:00 AM | W, 92-75
03/03/2012 | Men's Basketball | at USF | 12:00 AM | W, 50-44
03/07/2012 | Men's Basketball | vs. Connecticut (New York, N.Y.) | 12:00 AM | L, 67-71 (OT)
03/15/2012 | Men's Basketball | Gonazaga (Pittsburgh) | 12:00 AM | L, 54-77
Spreadsheet: 31309d1227116642-move-date-from-grid-format-to-list-format-mccexample2
Sheet: Sheet1

What I have
 | Week
[NAME] | 1 | 2 | 3
A | 10 | 20 | 30
B | 40 | 50 | 60
C | 70 | 80 | 90
What I would like
[NAME] | WK | VALUE
A | 1 | 10
B | 1 | 40
C | 1 | 70
A | 2 | 20
B | 2 | 50
C | 2 | 80
A | 3 | 30
B | 3 | 60
C | 3 | 90
Spreadsheet: 94379d1294223732-formula-for-interest-rates-cashflow-trial
Sheet: Sheet1

Cashflow
 |  | Interest Rate |  | 0.625 |  |  | [NAME] |  | Sep
 |  | Starting Balance |  | 1000 |  |  | Loan Amount |  | 1500
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Bank Balance | 1000 | 1052.083333333333 | 1106.879340277778 | 1164.529305917245 | 1225.181873933768 | 1288.993429867819 | 1356.128504340101 | 1426.760197274481 | 1.070624215860562 | 1.126385893769966 | 1.185051825737152 | 1.246773274994295
 | I want to try and work out what the lowest interest rate is in order for the bank balance to remain positive after it pays the loan
 | I have just used trial and error until the line is above zero
 | Is there anyway in which the interest rate is calculated in order to prevent negative bank balance
 | Without causing a circular reference
 | i.e. If I change any of the other cells that have a border it will calculate the interest rate needed to make the bank balance as close to negative as possible without going negative after the loan is paid off
 | Beyond me! I cant work it out. Thanks for looking at this, it is much appreciated.
 | Please bear in mind that the spreadsheet I am doing this on contains many more rows which adds to the complication!!!!!
 | Thanks!!!!!!!!
Spreadsheet: 48970d1248262474-hide-legends-for-blank-series-example
Sheet: Chart By Check Box

Select Any Combination of Series With Checkboxes
 |  |  |  |  |  | Checkbox Cell Links
 | 1 | 0 | 1 |  |  | Chart Source Data
 | A | B | C | A |  | C
1 | 3 | 9 | 5 | 3 | #N/A | 5
2 | 3 | 4 | 7 | 3 | #N/A | 7
3 | 4 | 5 | 9 | 4 | #N/A | 9
4 | 5 | 5 | 6 | 5 | #N/A | 6
Spreadsheet: 765722d1643548181-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Locate Tracking

SALES REP | YEAR | VEHICLE | CLIENT | LOCATED? |  | COMMENTS
Spreadsheet: 56355d1256555930-excel-2007-consolidating-monthly-sheets-via-pivot-table-eksempel-mnd-rapport
Sheet: Front page

Pivot table where i can choose month here:
 |  |  | Onsite |  | Workshop |  | Total
Description |  |  | Period | Total | Period | Total | Period | Total
Personell injuries with absence |  |  |  |  |  |  |  |  |  | Table presenting data on the month chosen in pivot table.
Personell injuries without absence |  |  |  |  |  |  |  |  |  | Data gathered from sheets January!, February! etc…
Injuries causing alternative work
Work conditioned illness with absence
Work conditioned illness without absence
First aid injuries
RUH
Sykefravær i prosent
Total working hours
Working hours overtime
Overtime in %
Frequence (hours pr RUH)
H1-Value
H2-Value
H3-Value
M1-Value
M2-Value
Comments on HSE-data:
Comments on economy:
Comments on on-going projects:
Comments on finished projects:
Commercial matters:
Procurement:
Planning:
Spreadsheet: 882609d1730991760-multiple-lookup-and-return-date-time-value-lewis94-sample-sheet-25-365-aligw
Sheet: Sheet2

 |  | Sub Supplier/Shipped Date
 | [NAME] | Atr001 | Atr002 | Atr003 | Atr004 | Atr005 | Atr006 | Atr007 | Atr008 | Atr009 | Atr010 | Atr011 | Atr012 | Atr013 | Atr014 | Atr015
 | Atr001 |  | 2024-10-25 11:50:00
 | Atr002
 | Atr003
 | Atr004
 | Atr005
 | Atr006
 | Atr007
 | Atr008
 | Atr009
 | Atr010
 | Atr011
 | Atr012
 | Atr013
 | Atr014
 | Atr015
 |  |  | I need to search down Column B and across Row 4 and where the data matches, return the corresponding date and time information
Spreadsheet: 465443d1465656499-conditional-format-based-on-cell-color-book3
Sheet: Sheet2

Row Labels | Count of Schedule KPI | Count of Budget KPI | Count of Quality KPI
Akron | 1
Cincinnati | 1 |  | 1
Cleveland |  | 1
Columbus | 1
Lexington |  | 1
Louisville |  |  | 1
Nashville |  |  | 1
Project
Toledo |  | 1
(blank) | 1 | 1 | 1
Grand Total | 4 | 4 | 4
Spreadsheet: 4217465f-bb71-4a69-8632-ad69644e24e5
Sheet: Sheet1

As of
 | Price | # Tix/Pack | GAMES AVAILABLE TO ORDER
1085 | 1 | 300 | ROAD 2 RICHE$
1080 | 1 | 300 | WILD 1
1076 | 1 | 300 | HOT SHOT
1084 | 2 | 150 | FABULOUS FORTUNE
1079 | 2 | 150 | SPICY HOT CASH
1075 | 2 | 150 | THREE TO WIN
1030 | 2 | 150 | $1,000 A WEEK FOR LIFE
1083 | 3 | 100 | ON A ROLL
1074 | 3 | 100 | GOLD MINE
1065 | 3 | 60 | BINGO PLUS
1049 | 3 | 100 | [NAME]
1029 | 3 | 100 | CROSSWORD TIME
1082 | 5 | 60 | LUCKY X20
1073 | 5 | 60 | [NAME]
1054 | 5 | 60 | MATCH FOR CASH
1048 | 5 | 60 | BINGO STAR
1047 | 5 | 60 | ACES AND 8S
1043 | 5 | 60 | CROSSWORD 5X
1042 | 5 | 60 | HOT NUMBERS
1077 | 10 | 60 | WINNING 777
1069 | 10 | 60 | CRAZY WILD CA$H
1052 | 10 | 60 | WIN WIN WIN
1041 | 10 | 60 | GOLD RUSH
1081 | 20 | 30 | MONEY MONEY MILLIONAIRE
1072 | 20 | 30 | MILLION DOLLAR MULTIPLIER
1063 | 20 | 30 | MAX-A-MILLION
1046 | 20 | 30 | $1 MILLION SPECTACULAR
1036 | 20 | 30 | $1,000,000 DIAMOND DAZZLER
1027 | 20 | 30 | MILLION $$ MATCH
1068 | 30 | 30 | THREE MILLION
Spreadsheet: ddca56cc-1613-499a-9f55-9c02b335cd05
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3026 | 17971 | Sara Sig | Møller | DEN | 101 | 00:48:09 | 00:02:01 | 2:07:20 | 00:00:59 | 1:21:46 | 1 | 4:20:19
3026 | 11367 | Liis | Toomingas | EST | 100 | [NAME] | 00:01:35 | 2:22:24 | 00:01:03 | 1:40:00 | 2 | 4:50:21
Spreadsheet: 122112d1316617774-planner-roo-booking-example-1-
Sheet: Sheet1

 |  | 2011-10-01 00:00:00
 | 00:00:00
 | 00:30:00
 | 01:00:00
 | 01:30:00
 | 02:00:00
 | 02:30:00
 | 03:00:00
 | 03:30:00
 | 04:00:00
 | 04:30:00
 | 05:00:00
 | 05:30:00
 | 06:00:00
 | 06:30:00
 | 07:00:00
 | 07:30:00
 | 08:00:00
 | 08:30:00
 | 09:00:00
 | 09:30:00
 | 10:00:00
 | 10:30:00
 | 11:00:00
 | 11:30:00
 | 12:00:00
 | 12:30:00
 | 13:00:00
 | 13:30:00
 | 14:00:00
 | 14:30:00
 | 15:00:00
 | 15:30:00
 | 16:00:00
 | 16:30:00
 | 17:00:00
 | 17:30:00
 | 18:00:00
 | 18:30:00
 | 19:00:00
 | 19:30:00
 | 20:00:00
 | 20:30:00
 | 21:00:00
 | 21:30:00
 | 22:00:00
 | 22:30:00
 | 23:00:00
 | 23:30:00
Spreadsheet: 02de5b7c-fb79-4784-b63c-b3409b1aa0e1
Sheet: EPR CF 

Consolidated Statements of Cash Flows (Unaudited and Condensed)
 | Nine Months Ended
 | June 30,
 | 2013 |  | 2012
(In millions)
Operating
Net income | 209.2000000000003 |  | 157.7999999999998
Adjustments:
Depreciation and amortization | 175.6 |  | 179.3
Acquisition-related contingent earn-out costs | 28 |  | 11.1
Other non-cash items | 74.6 |  | 64.39999999999999
Changes in operating assets and liabilities, excluding acquisitions:
Receivables | -20.7 |  | -24.6
Inventories | 3.7 |  | -14.4
Accounts payable and accrued liabilities | -58.7 |  | 14.5
Jackpot liabilities | -58.2 |  | -38.5
Income taxes, net of employee stock plans | -25.5 |  | -6.5
Other assets and deferred costs | 7.2 |  | -16.1
Net operating cash flows | 335.2 |  | 326.9999999999998
Investing
Capital expenditures | -97.1 |  | -170.8
Jackpot annuity investments, net | 39.3 |  | 36.7
Changes in restricted cash | 8.8 |  | 6.7
Loans receivable, net | 22.6 |  | 21.5
Business acquisitions, net of cash acquired | 0 |  | -233.9
Other | 15.3 |  | 29.6
Net investing cash flows | -11.09999999999998 |  | -310.2
Financing
Debt-related proceeds (payments), net | -143.2 |  | 280
Employee stock plan proceeds | 13.7 |  | 15.1
Share repurchases | -81 |  | -475.1
Noncontrolling interest acquired | 0 |  | -2.5
Dividends paid | -55.5 |  | -53.5
Acquisition-related contingent consideration | -27.9 |  | 0
Net financing cash flows | -293.9 |  | -236
Foreign exchange rates effect on cash | -7.2 |  | 0.5
Net change in cash and equivalents | 23.00000000000022 |  | -218.7000000000002
Beginning cash and equivalents | 206.3 |  | 460
Ending cash and equivalents | 229.3000000000002 |  | 241.2999999999998
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: PG&E

56698
Day | Scheduled | Measured
1 | 275537 | 278613
2 | 262499 | 267365
3 | 278050 | 280155
4 | 284260 | 287502
5 | 281989 | 283106
6 | 279075 | 281215
7 | 278417 | 280191
8 | 281054 | 284340
9 | 278159 | 281600
10 | 281851 | 283836
11 | 281910 | 283570
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | 160058
2000-12-11 00:00:00
Spreadsheet: darrell_schoolcraft__7242__saledoc01_14TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-01-16 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 01/17/02 |  |  | FAX Number:
Total Quantity |  |  | 5000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  | 5000 | 2.23
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
01/17/02 | 2002-01-17 00:00:00 | 5000 |  | 5000 |  | 5000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 5000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 228894d1366237794-how-do-i-take-a-two-digit-number-separate-the-two-digits-add-them-together-show-result-check
Sheet: Sheet2

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | daddy check | [NAME]
 | sample 1 | 0 | 4 | 6 | 2 | 2 | 5 | 3 | 3 | 1 |  | 1 | 1
 | sample 2 | 0 | 3 | 4 | 5 | 7 | 9 | 3 | 1 | 5 |  | 2 | 2
 | sample 3 | 8 | 9 | 0 | 4 | 6 | 3 | 4 | 8 | 0 |  | 8 | 8
 | sample 4 | 9 | 0 | 8 | 8 | 1 | 6 | 0 | 1 | 3 |  | 1 | 1
 | sample 5 | 4 | 3 | 0 | 8 | 9 | 0 | 4 | 6 | 4 |  | 0 | 0
 | sample 6 | 5 | 1 | 1 | 4 | 0 | 6 | 0 | 6 | 6 |  | 7 | 7
 | sample 7 | 9 | 2 | 0 | 3 | 0 | 3 | 1 | 6 | 3 |  | 9 | 9
 | sample 8 | 6 | 9 | 2 | 0 | 5 | 8 | 5 | 2 | 3 |  | 6 | 6
 | sample 9 | 0 | 2 | 5 | 1 | 1 | 8 | 4 | 0 | 9 |  | 9 | 9
 | sample 10 | 9 | 9 | 6 | 5 | 3 | 6 | 4 | 4 | 9 |  | 1 | 1
Spreadsheet: 05d835b9-94e7-4bd6-9b42-6b2bc97c12c4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | State of Ohio Department of Education ____________________________________________________________________ Pupil Transportation Office, Center for School Finance,  25 South Front Street, 7th Floor, Columbus  43215 (614) 466-4230,  FAX: (614) 466-8700    www.ode.state.oh.us/school_finance/transportation/ | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
T-2 C Report
 | Date Submitted ___________________________________ |  |  |  | Fiscal Year | ________
 | District ____________________________________ |  |  | IRN __________________________
 | Contractor ___________________________________________________________________
 | Pupil Transportation License Number _____________________________________________
 | Terminal Manager Name  _______________________________________________________
 | Telephone Number ____________________________________________________________
Type II Costs |  | [NAME] |  | Special Ed |  | Total
 |  | Staff | Costs | Staff | Costs | Staff | Costs
 | Staffing costs
1 | Supervisor
2 | Secretary/[NAME]
3 | Regular Drivers
4 | Substitute Drivers
5 | Bus Attendant
6 | Mechanic
7 | [NAME]
 | Benefits
8 | Retirement
9 | Worker's Comp
10 | Employee Insurance
 | Compliance
11 | Physicals/Drug&Alcohol
12 | Certification / Licensing
13 | Training
 | Operations
14 | Maintenance and Repairs
15 | Tires and Tubes
16 | Fuel
17 | Bus Insurance
18 | Maintenance supplies
 | Overhead
19 | Facility Rent
20 | Utilities
21 | Bus Lease Cost
22 | Other
 | Total
 | Submitted by | ___________________________________________ |  |  |  | Date ____________________
Spreadsheet: 0110a301-8c31-44c8-9bdf-957dc89ce8f6
Sheet: Component 2

Req # | Function | Requirement Description | Priority | Requirement Source | Notes
1 |  |  | 1
Spreadsheet: 860270d1708433343-flow-data-through-tabs-based-on-what-is-entered-in-a-cell-pricing-example-ef
Sheet: Products

Budget Waney Lap
2' Budget Waney lap |  |  |  |  | 3' Budget Waney lap |  |  |  |  | 4' Budget Waney lap |  |  |  |  | 5' Budget Waney lap |  |  |  |  | 6' Budget Waney lap
Components | Quantity | Price | cost |  | Components | Quantity | Price | cost |  | Components | Quantity | Price | cost |  | Components | Quantity | Price | cost |  | Components | Quantity | Price | cost
 | 5 |  |  |  | 3' [NAME] | 5 |  |  |  | 4' [NAME] | 5 |  |  |  | 5' [NAME] | 5 |  |  |  | 6' [NAME] | 7
 | 5 |  |  |  | 3' Thin Batten | 5 |  |  |  | 4' Thin Batten | 5 |  |  |  | 5' Thin Batten | 5 |  |  |  | 6' Thin Batten | 5
 | 6 |  |  |  | 5mm Waney Boards | 9 |  |  |  | 5mm Waney Boards | 11 |  |  |  | 5mm Waney Boards | 13 |  |  |  | 5mm Waney Boards | 15
 | 2 |  |  |  | 6' [NAME] | 2 |  |  |  | 6' [NAME] | 2 |  |  |  | 6' [NAME] | 2 |  |  |  | 6' Top Rail | 1
 | 1 |  |  |  | 6' Top Rail | 1 |  |  |  | 6' Top Rail | 1 |  |  |  | 6' Top Rail | 1 |  |  |  | Badge | 1
 | 1 |  |  |  | Badge | 1 |  |  |  | Badge | 1 |  |  |  | Badge | 1 |  |  |  | 38[NAME] nails | 1
 | 1 |  |  |  | 38[NAME] nails | 1 |  |  |  | 38[NAME] nails | 1 |  |  |  | 38[NAME] nails | 1 |  |  |  | Individual Dip Price | 1
 | 1 |  |  |  | Individual Dip Price | 1 |  |  |  | Individual Dip Price | 1 |  |  |  | Individual Dip Price | 1 |  |  |  | Piecework | 1
 | 1 |  |  |  | Piecework | 1 |  |  |  | Piecework | 1 |  |  |  | Piecework | 1
 |  | Total cost |  |  |  |  | Total cost |  |  |  |  | Total cost |  |  |  |  | Total cost |  |  |  |  | Total cost
In columns A, F, K etc with components in, I will have them linked
to the components in the Components tab, as per A5 to A13
What I need is the pricing from the Components tab to link through
and into columns C, H, M etc, the price columns, based on the component
in columns A, F, K etc.
Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: ActualResourceCostSumm

 |  |  | 2009 |  |  |  |  |  |  |  |  |  |  |  | 2010
 |  |  | J | F | M | A | M | J | J | A | S | O | N | D | J | F | M | A |  | [NAME]
ACTIVITIES & TIMELINE: |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | Cost
Totals
Total Implementation Cost
Spreadsheet: 0f976898-0cfe-42ee-8f54-02f3cddc58a3
Sheet: SRP Schedule & Other

Correspondent Banks - Effective April 1, 2008
Tier 1 (TX, OK, AR, KS,SC, TN, GA, ND, KY, AL, NC, AK, DE, IA,CO,MS)
 |  |  |  |  | Fixed Rate Fully Amortizing |  |  |  |  | ARM's
Conventional Loan Amount |  |  |  |  | 30/20 |  | 15/10
Less than $55,000 |  |  |  |  | 0 |  | 0 |  |  | 0
$55,000 to $79,999 |  |  |  |  | 1.3 |  | 1.3 |  |  | 0.9
$80,000 to $99,999 |  |  |  |  | 1.5 |  | 1.4 |  |  | 0.9
$100,000 to $149,999 |  |  |  |  | 1.6 |  | 1.5 |  |  | 0.9
$150,000 to $199,999 |  |  |  |  | 1.8 |  | 1.55 |  |  | 0.9
$200,000 to $417,000 |  |  |  |  | 1.9 |  | 1.65 |  |  | 0.9
[NAME] (LA, MO, NM, AZ, PA, MN, IN, FL, OH, VT, NY, WI, NE, WY, WV, CT, SD,IL,UT)
Less than $55,000 |  |  |  |  | 0 |  | 0 |  |  | 0
$55,000 to $79,999
$80,000 to $99,999
$100,000 to $149,999
$150,000 to $199,999
$200,000 to $417,000
Tier 3 (CA, OR, VA, MT, ID, MI, HI, ME, NH, NJ, DC, MD, WA, MA, RI, NV)
Less than $55,000 |  |  |  |  | 0 |  | 0 |  |  | 0
$55,000 to $79,999
$80,000 to $99,999
$100,000 to $149,999
$150,000 to $199,999
$200,000 to $417,000
Note:  SRP only paid on 1st lien Notes and Unpaid Principal Balances equal or greater than $55,000
Wholesale Banks get 1/2 of the Above Levels
The following Fees will be Collected at Purchase:
 |  |  | $150  Administrative Fee
 |  |  | $105 Tax Certification Fee all States
 |  |  | $40 Fraud Prevention Fee - Correspondent Banks
 |  |  | FHA Loans - Correspondent with no DE
 |  |  | $450 Underwriting Fee
 |  |  | $100 Insuring Fee
 |  |  | FHA Loans - Correspondent with DE
 |  |  | $150  Administrative Fee
 |  |  | Correspondent Credit /Appraisal Credit Review
 |  |  | $450 - must be paid prior to reviewing the package