tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1d6894db-08d6-47f8-8095-0738daceed0e
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 37. LEASE FINANCE COMMITMENTS, By Purpose: State (NT), Original (Number, $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
1 . . . [NAME] ; |  |  | Original | A2413879X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413880J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413881K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413882L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413883R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413884T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413885V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413886W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413887X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413888A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413889C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413890L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413891R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413892T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413893V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413894W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 032c6eb7-bb0b-426a-975b-7dbe6c2a26b6
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2012-04-19 00:00:00 | Build Construction | York Major project | Honeywell Controls Ltd | 154522 | 43790
DCMS | SMG | 2012-04-03 00:00:00 | Build Construction | Wroughton Major projects | Hemcrete Projects Limited | 154551 | 218358
DCMS | SMG | 2012-04-19 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 154558 | 40865.49
DCMS | SMG | 2012-04-19 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 154702 | 27839.59
DCMS | SMG | 2012-04-19 00:00:00 | Professional Fees | Science Museum Estates | KAD Environmental Consultancy Limited | 154867 | 25300
DCMS | SMG | 2012-04-03 00:00:00 | Build Construction | National MPG | Hemcrete Projects Limited | 154898 | 54143.4
DCMS | SMG | 2012-04-19 00:00:00 | Rent | Science Museum Estates | The British Museum | 154967 | 93278.27
DCMS | SMG | 2012-04-19 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 154978 | 28744.89
DCMS | SMG | 2012-04-19 00:00:00 | Build Construction | Science Museum Swindon Estates | [NAME] (Swindon) Limited | 155004 | 37236.3
DCMS | SMG | 2012-04-19 00:00:00 | Build Construction | National Estates | Cofely Limited | 155072 | 27490.15
DCMS | SMG | 2012-04-12 00:00:00 | Electricity | NMEM Estates | Southern Electric Power Distribution Ltd | 155133 | 28765.67
DCMS | SMG | 2012-04-19 00:00:00 | Rates (CILOR) | NMEM Estates | Bradford Council | 155157 | 54960
DCMS | SMG | 2012-04-19 00:00:00 | Build Construction | Exhibitions | TMP | 155257 | 28380
DCMS | SMG | 2012-04-19 00:00:00 | Build Construction | Science Museum Estates | Fairhurst Ward Abbotts Ltd | 155475 | 34789
Spreadsheet: 855154d1704824116-rolling-12-month-absence-caculator-attendance-tracker-template
Sheet: Dec

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December 2024
 |  | 1 | 2 | 3 | 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 | Leave this month | Working days this month | Absence this month
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | S | V
 |  |  | V | V | V
 |  | Legend: W- Working day, P- Part-time, A- [NAME], V- Vacation, H-Holiday, S-Sickness
 | The attendance tracker is provided to you by LeaveBoard.
 | https://leaveboard.com/attendance-tracker/
Spreadsheet: 841008d1693250897-changing-source-sheet-based-on-a-cell-select-sheet
Sheet: Compare

 | Game: | 1
TNUT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opponet |  |  |  |  |  |  |  |  |  |  |  |  |  | Ball First |  | PFF vs CFD drive chart and how the drive starts and ends
Drive | [NAME] | CFD adds | CFD SOD+ | # of Plays | # of Plays CFD | Time SOD | Time EOD | Time OP | Time SOD | Time EOD | Time OD | PC Ave | PC Min | PC [NAME] | [NAME] | CFD adds | CFD SOD+ | # of Plays | # of Plays CFD | Time SOD | Time EOD | Time OP | Time SOD | Time EOD | Time OD | PC Ave | PC Min | PC [NAME] |  |  | Drive |  | SOD | EOD | Drive Length | Offensive Team | Tennessee Drives | Opponet Drives
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 75521d1276093914-formula-to-sum-values-of-the-same-type-fruit-store-sheet-excel-help
Sheet: Weekly

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Item | CTN Weight | Managers
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mushrooms | 695 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capsicum - Red | 0 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capsicum - Green | 200 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Onion - Brown | 50 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Onion - Red | 50 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Tomatoes | 480 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Parsley | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  | - | -
Spreadsheet: 0552a08a-6681-486b-9296-db96b2e4d7e3
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
 | 8731.0 Building Approvals, Australia
 | TABLE 20. Number of Dwelling Units Approved in New Residential Buildings, Original - Australia
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
Number of Dwelling Units ;  New ;  Total houses ; |  |  | Original | A418403T | 1956-01-01 00:00:00 | 2010-10-01 00:00:00 | 658 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415785F | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422926F | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416421K | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423529V | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424174L | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424726X | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417063R | 1991-07-01 00:00:00 | 2010-10-01 00:00:00 | 232 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total other residential building ; |  |  | Original | A419138J | 1970-07-01 00:00:00 | 2010-10-01 00:00:00 | 484 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total residential building ; |  |  | Original | A419824J | 1956-01-01 00:00:00 | 2010-10-01 00:00:00 | 658 | Number | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 83712d1283758054-averages-and-vlookup-solution-book1
Sheet: Sheet1

 | TALBE OF "C" VALUES
 | Intensity | [NAME] (fi) |  |  |  |  |  |  |  | [NAME] (fi)
 | (mm/hr) | 0 | 0.2 | 0.4 | 0.6 | 0.8 | 0.9 | 1
 | 39-44 | REFER ADDITIONAL TABLE. | 0.44 | 0.55 | 0.67 | 0.78 | 0.84 | 0.9 |  | INTENSITY (mm/hr)
 | 45-49 |  | 0.49 | 0.6 | 0.7 | 0.8 | 0.85 | 0.9
 | 50-4 |  | 0.55 | 0.64 | 0.72 | 0.81 | 0.86 | 0.9 |  | "C" Value
 | 55-59 |  | 0.6 | 0.68 | 0.75 | 0.83 | 0.86 | 0.9
 | 60-64 |  | 0.65 | 0.72 | 0.78 | 0.84 | 0.87 | 0.9
 | 65-69 |  | 0.71 | 0.76 | 0.8 | 0.85 | 0.88 | 0.9
 | 70-90 |  | 0.74 | 0.78 | 0.82 | 0.86 | 0.88 | 0.9
 |  |  |  | Cells "M3" AND "M5" are to be user input.
 |  |  |  | Cell "M7" is to find the average "C" value in the table based on the user input.
Spreadsheet: 705022d1605860841-vlookup-wont-work-on-multiple-rows-so-i-need-an-alternative-fhlp
Sheet: Table 1

Items | Number 1 | Number 2 | Number 3 | Number 4
AAA | 10 | 10 | 5
BBB | 10 | 5 | 5 | 5
AAA | 10
CCC
EEE
AAA | 10
EEE | 40 | 20
DDD
Spreadsheet: f27de222-8fa9-4f68-a0c8-818fe918e989
Sheet: Sheet1

Secondary Principals' Salary Calculator [NAME]) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Today's date |  |  |  |  | 2011-07-01 00:00:00
 |  |  |  |  |  | enter your
 | Component |  |  |  |  | details here |  | U grade |  | 2011-07-01 00:00:00
 | Roll size |  | School roll size |  |  | 1000 |  | 8 |  | 115353
 | Staffing |  | FTTE MoE funded staffing |  |  | 62 |  |  |  | 18695
 | Decile |  | School decile |  |  | 7 |  |  |  | 0
 | Youth potential leadership |  | Year 11-15 roll |  |  | 500 |  | Service Years |  | 5000
 | Career strucuture |  | Date first appointed as principal |  |  | 2009-02-01 00:00:00 |  | 2.410958904109589 |  | 0
 | [NAME] |  | Are you eligible for the [NAME]? |  |  | yes |  |  |  | 3000
 |  |  |  |  |  |  |  |  | Yes | 142048
 |  |  |  |  |  |  |  |  | No
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Abakus

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-02-27 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-02-27 00:00:00
Spreadsheet: 32470d1228665895-filter-data-surveytest
Sheet: RP

RP
 |  | CUSTOMER SCORE CRITERIA |  |  |  | AVERAGE PERFORMANCE BY REP
 |  | 1 - 4 | Worse Than our competitor |  |  | 1 - 4.99 | Worse Than our competitor
 |  | 5 -6 | Equal to level of service |  |  | 5 -6.99 | Equal to level of service
 |  | 7 - 8 | Exceeding our competitors service |  |  | 7 - 8.99 | Exceeding our competitors service
 |  | 9 - 10 | Excellent |  |  | 9 - 10 | Excellent
 | Company | SI REP | Price | Stock Availability | Delivery Performance | Quality of Product | Packing | Handling of rejects | Staff Response & reliabilty | Website Opinion Score | Indvidual Account Manager/Rep Score | Overall Perception of SI asa Business | SI Performance Average
 | Company 1 | RP | 4 | 5 | 9 | 7 | 8 | 9 | 7 | 9 | 7 | 8 | 7.3
 | Company 2 | RP | 7 | 10 | 9 | 7 | 9 | 9 | 7 | 8 | 7 | 9 | 8.2
 | Company 3 | RP | 5 | 6 | 8 | 6 | 6 | 10 | 7 | 9 | 7 | 7 | 7.1
 | Company 4 | RP | 4 | 7 | 8 | 6 | 6 | 10 | 6 | 8 | 6 | 7 | 6.8
 | Company 5 | RP | 6 | 6 | 10 | 10 | 10 | 10 | 7 | 8 | 7 | 8 | 8.2
 | Company 6 | RP | 7 | 9 | 8 | 6 | 6 | 10 | 10 | 9 | 9 | 7 | 8.1
 | Company 7 | RP | 8 | 8 | 8 | 8 | 8 | 5 | 8 | 8 | 9 | 9 | 7.9
 | Company 8 | RP | 7 | 8 | 4 | 6 | 6 | 10 | 4 | 9 | 7 | 5 | 6.6
 | Company 9 | RP | 8 | 8 | 6 | 6 | 7 | 10 | 10 | 9 | 10 | 9 | 8.3
 | Company 10 | RP | 9 | 9 | 8 | 9 | 10 | 10 | 9 | 8 | 10 | 7 | 8.9
 | Company 11 | RP | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 9 | 10 | 8 | 9.7
 | Company 12 | RP | 10 | 10 | 10 | 7 | 6 | 5 | 5 | 7 | 3 | 7 | 7
 | Company 13 | RP | 9 | 10 | 10 | 7 | 6 | 10 | 9 | 8 | 8 | 9 | 8.6
 | Company 14 | RP | 5 | 4 | 8 | 6 | 6 | 7 | 9 | 9 | 8 | 7 | 6.9
 | Company 15 | RP | 4 | 4 | 10 | 6 | 6 | 6 | 9 | 7 | 6 | 6 | 6.4
 | Company 16 | RP | 6 | 4 | 7 | 6 | 7 | 6 | 3 | 8 | 7 | 4 | 5.8
 | Company 17 | RP | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 9 | 6 | 6 | 6.3
 | Company 18 | RP | 7 | 7 | 8 | 6 | 6 | 10 | 7 | 9 | 8 | 7 | 7.5
 | Company 19 | RP | 6 | 5 | 7 | 6 | 6 | 10 | 5 | 7 | 7 | 9 | 6.8
 | Company 20 | RP | 8 | 8 | 8 | 8 | 8 | 10 | 8 | 9 | 9 | 9 | 8.5
 | Company 21 | RP | 9 | 10 | 10 | 9 | 8 | 10 | 10 | 8 | 10 | 9 | 9.3
 | Company 22 | RP | 6 | 6 | 10 | 10 | 10 | 10 | 8 | 8 | 8 | 8 | 8.4
 | Company 23 | RP | 5 | 4 | 9 | 6 | 6 | 7 | 6 | 8 | 7 | 6 | 6.4
 | Company 24 | RP | 6 | 6 | 7 | 7 | 7 | 10 | 8 | 8 | 8 | 8 | 8
 | Company 25 | RP | 7 | 7 | 8 | 7 | 6 | 6 | 9 | 8 | 7 | 8 | 7.3
 | Company 26 | RP | 7 | 7 | 8 | 8 | 8 | N/A | 8 | 8 | 8 | 8
 | Company 27 | RP | 6 | 6 | 8 | 6 | 6 | 10 | 7 | 7 | 7 | 7 | 7
 | Company 28 | RP | 7 | 7 | 8 | 8 | 8 | 9 | 9 | 8 | 9 | 8
 | Company 29 | RP | 6 | 6 | 6 | 6 | 6 | 10 | 8 | 8 | 8 | 6 | 7
 | Company 30 | RP | 7 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8
 | Company 31 | RP | 10 | 10 | 6 | 10 | 10 | 10 | 7 | 8 | 8 | 7 | 8.6
 | Customer Count: 31 |  | 6.838709677419355 | 7.064516129032258 | 8.03225806451613 | 7.193548387096774 | 7.258064516129032 | 8.733333333333333 | 7.548387096774194 | 8.193548387096774 | 7.709677419354839 | 7.451612903225806 | 7.60357142857143
Spreadsheet: 218681d1362535960-how-can-i-get-rid-of-the-num-error-if-the-loan-is-only-for-20-yrs-and-i-have-a-30-yr-table-mortgage-calculator
Sheet: Depreciation

Depreciation Values
Asset Value | 190000
Salvage Value | 8000
Asset Life | 17
Yearly Depreciation
Depreciation based on DDB (double-declining balance)
Year | DDB
1
Spreadsheet: 40262d1238573411-multiple-table-lookups-and-validation-indirect-namedranges-mutliple_table_test
Sheet: Sheet1

x | 100 | ul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standards
y | 200 | ul | current validation for GB iBeams only - where changing beam type populates A2-A6 with required values |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | leave blank
[NAME] | 7 | ul | INPUTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GB iBeams
ft | 22.8 | ul | Beam Type | 20a |  |  |  |  |  |  |  |  |  |  |  |  |  | PN iBeams
ifilletrad | 9 | ul
[NAME] | 4.5 | ul
 |  |  | need a lookup like this -
 |  |  | INPUTS
 |  | 13 | Standard Type | GB iBeams | Named range "Standards" created in yellow section of column S. Used for data validation here
 |  | $H$14:$T$14 | Beam Type | 20a | This cell will use an INDIRECT(E9) formula to select a named range based on the choice in E9
 |  |  |  |  |  | GB iBeams
 |  |  | These yellow headers are matching |  |  |  | 16 | 18 | 20a | 20b | 22a | 22b | 25a
 |  |  | NAME ranges to the standards listed |  |  | x | 88 | 94 | 100 | 102 | 110 | 112 | 116
 |  |  | except the spaces have been removed |  |  | y | 160 | 180 | 200 | 200 | 220 | 220 | 250
 |  |  | Highlight the yellow area and look |  |  | [NAME] | 6 | 6.5 | 7 | 9 | 7.5 | 9.5 | 8
 |  |  | above column A in the Name Box to |  |  | ft | 9.9 | 21.4 | 22.8 | 22.8 | 12.3 | 24.6 | 26
 |  |  | see the named range listed |  |  | ifilletrad | 8 | 8.5 | 9 | 9 | 9.5 | 9.5 | 10
 |  |  |  |  |  | [NAME] | 4 | 4.3 | 4.5 | 4.5 | 4.8 | 4.8 | 5
 |  |  | highlight the green sections and note
 |  |  | the named range format. This allows |  |  | PN iBeams
 |  |  | the named range used in the formulas |  |  |  | 10x4x6 | 12x4x6 | 12x6x6 | 14x6x6 | 14x6x8 | 16x6x6 | 16x6x8 | 17x6x8
 |  |  | in column B to look at cell E9 and |  |  | x | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | create the named range reference |  |  | y | 11 | 12 | 13 | 14 | 15 | 16 | 16 | 18
 |  |  | needed. |  |  | [NAME] | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118
 |  |  |  |  |  | ft | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 39
 |  |  | Then a complicated match occurs to |  |  | ifilletrad | 2.2 | 2.3 | 2.4 | 2.5 | 2.6 | 2.7 | 2.8 | 2.9
 |  |  | find the value in E10 in the G column |  |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | and use that to create a match range
 |  |  | for the yellow ibeam sizes.
 |  |  | I made the chart go out to column T, but each of the tables presumes to
 |  |  | only have the same 6 sections from "x" to "ofilletrad"   If that is not the case
 |  |  | You will need to adjust the formulas in column B for the first "match" section to use
 |  |  | the left column from the table with the most options.
 |  |  | If that is unclear, put in your various standards and repost the sheet.
Spreadsheet: 747c7ce3-8bb0-44c2-b926-925e3faae7f0
Sheet: Summary

FY 2012
Telecommunications Equity Aid
PAYMENTS TO TELECOM ACCESS CLUSTERS |  |  |  |  | DIRECT PAYMENTS TO SCHOOLS
Cluster | NUMBER | Aid Eligible | Prorated Aid |  | None
CMETS | 01-206
ECMECC | 50-6003
FRESHWATER ED. DIST. | 61-6004
REGION 10 - SOUTHEAST SERVICE COOP | 83-0921
IASC | 50-6070
LITTLE CROW TELE-MEDIA NETWORK | 50-6040
MSET | 61-6979
MNRVED | 61-6018
NW LINKS (REGION I) | 82-0869
REDWOOD AREA TELECOM COOPERATIVE | 01-2890
REGION 2 - ARCC | 82-0868
CENTRAL | 82-0867
NESC | 83-0927
Ties (Region 7) | 82-0925
SOUTHWEST (Region 6 & 8) | 83-0991
SOCRATES | 50-6036
WETC | 50-6048
SCSN | 01-720
TOTAL
Proration Rate > | 0.462669465
Spreadsheet: 716729d1612345285-beginner-help-formula-across-2-sheets-help
Sheet: Sheet2

ID | Comments
4A
5A
Spreadsheet: 143649d1330509284-unlock-first-row-for-editing-tt-index-copy-v1
Sheet: Records

Participant Name | Department | Group | Role | Course | Provider | Trainer | Start Date | [NAME] | Hours | Cost | Type | Results | Outcome | Status | Audit | Notes | Month | Year
Employee 1 |  | Depot 1 |  | Course 1 | In House | Trainer 1 | 2007-05-17 00:00:00 | 2012-05-15 00:00:00 | 1 | 40 | Initial | Passed | Valid | Active | c |  | May | 2007
Employee 1 |  | Depot 1 |  | Course 9 | In House | Trainer 1 | 2007-05-17 00:00:00 | 2009-05-16 00:00:00 | 1 | 60 | Initial | Passed |  | Active | c |  | May | 2007
Employee 2 |  | Depot 1 |  | Course 1 | In House | Trainer 1 | 2007-05-18 00:00:00 | 2012-05-16 00:00:00 | 1 | 40 | Initial | Passed | Valid | Active | c |  | May | 2007
Employee 2 |  | Depot 1 |  | Course 9 | In House | Trainer 1 | 2007-05-18 00:00:00 | 2009-05-17 00:00:00 | 1 | 60 | Initial | Passed |  | Active | c |  | May | 2007
Employee 2 |  | Depot 1 |  | Course 4 | In House | Trainer 1 | 2007-06-05 00:00:00 | 2010-06-04 00:00:00 | 8 | 120 | Initial | Passed | Expired | Active | c |  | Jun | 2007
Employee 1 |  | Depot 1 |  | Course 9 | In House | Trainer 1 | 2009-05-16 00:00:00 | 2011-05-16 00:00:00 | 1 | 60 | [NAME] | Passed | Valid | Active | c |  | May | 2009
Employee 2 |  | Depot 1 |  | course 9 | In House | Trainer 1 | 2008-12-05 00:00:00 | 2010-12-05 00:00:00 | 1 | 60 | [NAME] | Passed | valid | Active | c | Required due to injury | Dec | 2008
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: SE-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | May |  |  |  |  |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | 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 | 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
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:
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
 |  | TOTAL
Spreadsheet: 679160d1590235279-number-items-in-a-list-that-are-not-chosen-example-list
Sheet: Development

1 |  | Adam | 1
2 |  | [NAME] | 2
3 | X | [NAME]
4 |  | [NAME] | 3
5 |  | [NAME] | 4
6 |  | [NAME] | 5
7 |  | George | 6
8 | X | [NAME]
9 | X | [NAME]
10 |  | [NAME] | 7
11 |  | [NAME] | 8
12 |  | [NAME] | 9
13 | X | Mark
14 |  | Nathan | 10
15 |  | Ozzie | 11
16 |  | [NAME] | 12
17 |  | Quinn | 13
18 |  | Rodger | 14
19 | X | [NAME]
20 |  | [NAME] | 15
21 |  | Umberto | 16
22 | X | Victor
23 |  | Walter | 17
24 |  | Xander | 18