tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1326bc65-ba8a-4d98-a4c0-79c13860d37d
Sheet: Sheet1

Technology Workforce Development Grant Program – 2006 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Expenditure Report - Federal Funds - TETC-TYT
 | Project Number
 | Project Leader(s)
 | Institution:
 | Project Leader’s Mailing Address (include department)
 | [NAME] (maximum of 100 characters)
 | Time Period for Expenditure Report |  | from - to
 |  |  | TETC-TYT
 |  |  | Budget |  | Cumulative Expenditures |  | Current Expenditures
A. | Personnel [show number of people in brackets]
1 | Project Leader/Co-Project Leader [  ] |  | 0 |  | 0 |  | 0
2 | Other tenure-track faculty [  ] |  | 0 |  | 0 |  | 0
3 | Other Professionals (technician, programmer, etc.) [  ] |  | 0 |  | 0 |  | 0
4 | Non-tenure – track faculty [  ] |  | 0 |  | 0 |  | 0
5 | Graduate Students/Post-Doctoral [  ] |  | 0 |  | 0 |  | 0
6 | Undergraduate Students [  ] |  | 0 |  | 0 |  | 0
7 | Secretarial – Clerical [  ] |  | 0 |  | 0 |  | 0
8 | Other |  | 0 |  | 0 |  | 0
 | Fringe Benefits |  | 0 |  | 0 |  | 0
 | Total – Salaries, Wages and Fringe Benefits |  | 0 |  | 0 |  | 0
B. | Capital Equipment:  All capital equipment included as expenditures must be specifically listed.
1 |  |  | 0 |  | 0 |  | 0
2 |  |  | 0 |  | 0 |  | 0
3 |  |  | 0 |  | 0 |  | 0
 | Total – Capital Equipment |  | 0 |  | 0 |  | 0
C. | Travel
1 | Domestic (including Canada, Mexico and U.S. possessions) |  | 0 |  | 0 |  | 0
2 | Foreign (see grant conditions) |  | 0 |  | 0 |  | 0
 | Total – Travel |  | 0 |  | 0 |  | 0
D. | Other Direct Cost
1 | Materials and Supplies |  | 0 |  | 0 |  | 0
2 | Scholarships |  | 0 |  | 0 |  | 0
3 | Conference Registration Fees/Publication Costs |  | 0 |  | 0 |  | 0
4 | Computer (ADPE) Services |  | 0 |  | 0 |  | 0
5 | Subcontracts/Consultant Services |  | 0 |  | 0 |  | 0
6 | Subcontracts: Community Colleges (list separately) |  | 0 |  | 0 |  | 0
7 | Other (specify): |  | 0 |  | 0 |  | 0
 | Total – Other Direct Costs |  | 0 |  | 0 |  | 0
 | Total |  | 0 |  | 0 |  | 0
 | Institutional Representative:  I certify to the best of my knowledge and belief that this report is true in all respects and that all expenditures have been made for the purpose and conditions of the grant or agreement.
 | Date: |  | Name:
 | Phone: |  | Title:
Spreadsheet: 150719d1334669359-index-match-or-sumproduct-with-concatenate-problem
Sheet: Summary for Slides

 |  |  | Product 1 | Spacer | Product Group | Total Sales Inc ES
 |  |  | Product 1 | Aluminium | Product 1Aluminium
 |  |  | Product 2 | Aluminium | Product 2Aluminium
 |  |  | Product 3 | Aluminium | Product 3Aluminium
 |  |  | Product 4 | Aluminium | Product 4Aluminium
 |  |  | Product 5 | Aluminium | Product 5Aluminium
 |  |  | Product 6 | Aluminium | Product 6Aluminium
 |  |  | Product 7 | Aluminium | Product 7Aluminium
 |  |  | Product 1 | [NAME] | Product 1Warm Edge
 |  |  | Product 2 | [NAME] | Product 2Warm Edge
 |  |  | Product 3 | [NAME] | Product 3Warm Edge
 |  |  | Product 4 | [NAME] | Product 4Warm Edge
 |  |  | Product 5 | [NAME] | Product 5Warm Edge
 |  |  | Product 6 | [NAME] | Product 6Warm Edge
 |  |  | Product 7 | [NAME] | Product 7Warm Edge
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1-18

Jornada | 19
Everton | 2 | 1 | Wigan Athletic
Fulham | 1 | 1 | Southampton
[NAME] | 4 | 3 | Newcastle United
Norwich City | 0 | 1 | Chelsea
Reading | 0 | 0 | Swansea City
Sunderland | 1 | 0 | Manchester City
Queen Parks Rangers | 1 | 2 | West Bromwich Albion
[NAME] | 0 | 4 | [NAME]
Stoke City | 3 | 1 | Liverpool
Arsenal | 5 | 1 | West Ham United
Spreadsheet: 38105d1236215042-excel-2007-averaging-s-only-when-data-is-placed-not-counting-blank-cells-monthly-gas-report
Sheet: Monthly Avg

 |  | YTD:
 |  | [NAME]. Monthly:
Technician |  | Yearly Technician Total | Average/Week | January |  |  |  | Totals | February |  |  |  | Totals | March |  |  |  | Totals | April |  |  |  | Totals | May |  |  |  |  | Totals | June |  |  |  | Totals | July |  |  |  | Totals | August |  |  |  |  | Totals | September |  |  |  | Totals | October |  |  |  | Totals | November |  |  |  |  | Totals | December |  |  |  |  | Totals
 |  |  |  | WE 1/11 | WE 1/18 | WE 1/25 | WE 2/1 |  | WE 2/8 | WE 2/15 | WE 2/22 | WE 3/1 |  | WE 3/8 | WE 3/15 | WE 3/22 | WE 3/29 |  | WE 4/5 | WE 4/12 | WE 4/19 | WE 4/26 |  | WE 5/3 | WE 5/10 | WE 5/17 | WE 5/24 | WE 5/31 |  | WE 6/7 | WE 6/14 | WE 6/21 | WE 6/28 |  | WE 7/5 | WE 7/12 | WE 7/19 | WE 7/26 |  | WE 8/2 | WE 8/9 | WE 8/16 | WE 8/23 | WE 8/30 |  | WE 9/6 | WE 9/13 | WE 9/20 | WE 9/27 |  | WE 10/4 | WE 10/11 | WE 10/18 | WE 10/25 |  | WE 11/1 | WE 11/8 | WE 11/15 | WE 11/22 | WE 11/29 |  | WE 12/6 | WE 12/13 | WE 12/20 | WE 12/27 | WE 1/3
1 | Technician A
2 | Technician B
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  |  | Total:
 |  |  |  |  | Highest total Jan. |  |  |  |  | Highest total Feb. |  |  |  |  | Highest total Mar. |  |  |  |  | Highest total Mar. |  |  |  |  |  | Highest total May |  |  |  |  | Highest total Jun. |  |  |  |  | Highest total Jul. |  |  |  |  |  | Highest total Aug. |  |  |  |  | Highest total Sep. |  |  |  |  | Highest total Oct. |  |  |  |  |  | Highest total Nov. |  |  |  |  |  | Highest total Dec.
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF GOODWILL
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 884524d1733757927-2-cols-match-2-or-more-cols-match_v2
Sheet: Main Data

Main Data Sheet
 |  | Match 1 | Match 2
 |  | Cardio Case No | 989 |  | X Ray | 523.7
 |  |  |  |  |  | 523.7
 |  | Cardio Case No | 990 |  | CBC | 210.9
 |  |  |  |  |  | 210.9
 |  | Cardio Case No | 991 |  | Urnine Test | 1024.42
 |  |  |  |  |  | 1024.42
 |  | Cardio Case No | 992 |  | X Ray | 1442.4
 |  |  |  |  |  | 1442.4
 |  | Cardio Case No | 993 |  | USG | 215.1
 |  |  |  |  |  | 215.1
 |  | Cardio Case No | 1023 |  | Vitamin D/Calcium test | 2008.2
 |  |  |  |  |  | 1008.2
 |  |  |  |  |  | 1000
Spreadsheet: 111228d1307646236-yearly-average-in-data-table-ptcalcfieldavg
Sheet: Sample data

Month-year | Events | Observations | Event % | Average % event | Average for year
2008-01-01 00:00:00 | 2 | 449
2008-02-01 00:00:00 | 1 | 413 |  |  |  |  |  | See the Pivot below where Field1 is a calculated field and shown as Average
2008-03-01 00:00:00 | 1 | 461 |  |  |  |  |  | I've also grouped by year and collapsed a few of the years.
2008-04-01 00:00:00 | 2 | 450
2008-05-01 00:00:00 | 0 | 498 |  |  |  |  |  | Row Labels | Sum of Events | Sum of Observations | Average of Field1
2008-06-01 00:00:00 | 2 | 386 |  |  |  |  |  | 2008
2008-07-01 00:00:00 | 0 | 408 |  |  |  |  |  | Jan | 2 | 449 | 0.004454342984409799
2008-08-01 00:00:00 | 1 | 402 |  |  |  |  |  | Feb | 1 | 413 | 0.002421307506053269
2008-09-01 00:00:00 | 3 | 375 |  |  |  |  |  | Mar | 1 | 461 | 0.002169197396963124
2008-10-01 00:00:00 | 1 | 346 |  |  |  |  |  | Apr | 2 | 450 | 0.004444444444444444
2008-11-01 00:00:00 | 0 | 325 |  |  |  |  |  | May | 0 | 498 | 0
2008-12-01 00:00:00 | 1 | 386 |  |  |  |  |  | Jun | 2 | 386 | 0.005181347150259068
2009-01-01 00:00:00 | 1 | 480 |  |  |  |  |  | Jul | 0 | 408 | 0
2009-02-01 00:00:00 | 0 | 374 |  |  |  |  |  | Aug | 1 | 402 | 0.002487562189054726
2009-03-01 00:00:00 | 1 | 467 |  |  |  |  |  | Sep | 3 | 375 | 0.008
2009-04-01 00:00:00 | 0 | 399 |  |  |  |  |  | Oct | 1 | 346 | 0.002890173410404624
2009-05-01 00:00:00 | 2 | 420 |  |  |  |  |  | Nov | 0 | 325 | 0
2009-06-01 00:00:00 | 0 | 455 |  |  |  |  |  | Dec | 1 | 386 | 0.002590673575129534
2009-07-01 00:00:00 | 1 | 434 |  |  |  |  |  | 2008 Total | 14 | 4899 | 0.002857726066544193
2009-08-01 00:00:00 | 2 | 409 |  |  |  |  |  | 2009 | 13 | 5351 | 0.002429452438796486
2009-09-01 00:00:00 | 2 | 436 |  |  |  |  |  | 2010
2009-10-01 00:00:00 | 1 | 500 |  |  |  |  |  | Jan | 2 | 502 | 0.00398406374501992
2009-11-01 00:00:00 | 1 | 510 |  |  |  |  |  | Feb | 3 | 423 | 0.007092198581560284
2009-12-01 00:00:00 | 2 | 467 |  |  |  |  |  | Mar | 1 | 443 | 0.002257336343115124
2010-01-01 00:00:00 | 2 | 502 |  |  |  |  |  | Apr | 0 | 360 | 0
2010-02-01 00:00:00 | 3 | 423 |  |  |  |  |  | May | 0 | 386 | 0
2010-03-01 00:00:00 | 1 | 443 |  |  |  |  |  | Jun | 1 | 378 | 0.002645502645502645
2010-04-01 00:00:00 | 0 | 360 |  |  |  |  |  | Jul | 1 | 461 | 0.002169197396963124
2010-05-01 00:00:00 | 0 | 386 |  |  |  |  |  | Aug | 2 | 350 | 0.005714285714285714
2010-06-01 00:00:00 | 1 | 378 |  |  |  |  |  | Sep | 4 | 343 | 0.01166180758017493
2010-07-01 00:00:00 | 1 | 461 |  |  |  |  |  | Oct | 1 | 359 | 0.002785515320334262
2010-08-01 00:00:00 | 2 | 350 |  |  |  |  |  | Nov | 0 | 288 | 0
2010-09-01 00:00:00 | 4 | 343 |  |  |  |  |  | Dec | 0 | 394 | 0
2010-10-01 00:00:00 | 1 | 359 |  |  |  |  |  | 2010 Total | 15 | 4687 | 0.003200341369746106
2010-11-01 00:00:00 | 0 | 288 |  |  |  |  |  | 2011 | 5 | 1175 | 0.00425531914893617
2010-12-01 00:00:00 | 0 | 394 |  |  |  |  |  | Grand Total | 47 | 16112 | 0.00291708043694141
2011-01-01 00:00:00 | 1 | 385
2011-02-01 00:00:00 | 1 | 400
2011-03-01 00:00:00 | 3 | 390
Spreadsheet: 742074d1627503241-formulas-not-remaining-with-correct-rows-after-sort-sample
Sheet: All Deployments

 | CLICKING THE BUTTON ABOVE RUNS A MACRO TO REFRESH THE DATA |  |  |  |  |  |  |  |  | Hover over column headers to see additional information about the data in the cells in the each column
 | DEPARTMENT TOTALS YTD (ALL DEPLOYMENTS) |  |  |  |  | TOTAL |  |  |  | TOTAL | TOTAL | TOTAL | TOTAL |  | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL |  | TOTAL | TOTAL | TOTAL | TOTAL
 |  |  |  |  | YTD Total # of Deployments
 | Primary County | Primary State | Primary Cat Code Being Handled | Primary Loss Type Being Handled | Claim Rep | Supervisor | 1st Day Claims Rec'd | (Arrive) 1st Work Day | ([NAME]) 1st Travel Day | Meeting, Training, Travel, PTO, Off Days During Tour | Count of Days                   Able to Inspect | Days Onsite to Date | Days Remaining Onsite | Target Claims Per Day | Target Capacity | Remaining                      Capacity at Target | Number of reinspects Assigned | Number of claims                    turned back in                              from associate | Total Assigned | Claims Assigned Over or Under Target | CA at Capacity?                   "Yes" = At Capacity | Average Severity based on estimates with a dollar value | Count of Returned Estimates to Date | Avg Claims Per Day to Date Based on Returned Estimates to Date | Avg Claims Per Day for Entire Deployment at Current Assignment Count if no Add'l Assigned | NOTES
1
2
3
4
5
6
Spreadsheet: 824361d1680525904-summary-of-timsesheets-tabs-john-timesheet-test
Sheet: W03

 | Name |  |  | Company |  | Week Nr. | From |  |  | Period Nr. | Till
 | [NAME] |  |  | HUB |  | 3
 | Project No. |  |  | Description | Mon | Tue | Wed | Thu | Fri | Sat | Total | Travel I | Travel II
 | 202301 |  |  | Job CCC | 4 | 5 | 1 | 6
 | General
 | Holiday
 | National Holiday
 | Leave on own account
 | Illness
 | Signature Client Representative: |  |  |  |  |  |  |  | Total
 | Date:
 | Day | Month | Year
 |  |  | 2023
Spreadsheet: 216b5582-e0fa-4d61-a484-83297a184095
Sheet: SF-424A (23)

Applicant Name: |  |  |  | Award Number:
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds |  | New or Revised Budget
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1. | Previous Projects | 10.17
2.
3.
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | Previous Projects | (68) | (69) | (70)
 | [NAME]
 | [NAME]
 | c.  Travel
 | d.  Equipment
 | e.  Supplies
 | f.  Contractual
 | g.  Construction
 | h.  Other
 | i.  Total Direct Charges (sum of 6a-6h)
 | j.  Indirect Charges
 | k.  Totals (sum of 6i-6j)
7. | Program Income
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
 | (a) Grant Program |  |  | (b) Applicant | (c ) State | (d) Other Sources | (e) Totals
8.
9.
10.
11.
12. | Total (sum of lines 8 - 11)
Section D - Forecasted Cash Needs
 |  |  | Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter
13. | Federal
14. | Non-Federal
15. | Total (sum of lines 13 and 14)
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant Program |  |  |  | Future Funding Periods (Years)
 |  |  |  | (b) First | (c ) Second | (d) Third | (e) Fourth
16.
17.
18.
19.
20. | Total (sum of lines 16-19)
Section F - Other Budget Information
21. Direct Charges |  |  |  | 22. Indirect Charges
23.  [NAME]
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  |  | Prescribed by OMB Circular A-102
 |  | Authorized for Local Reproduction
Spreadsheet: 695825d1600419239-multiple-if-functions-rj-projections
Sheet: Test

 |  |  |  |  |  |  | Payment Dates
Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
2021-01-01 00:00:00 | Product A | 2000 | 1 | -3 |  | 30000
Spreadsheet: 731481d1620361765-bulk-hyperlink-permit-register-example-2-emma-7-5-21
Sheet: OP

ABC Job Number | Address | Description | Client | Permit  Number | [NAME] | Job Notes | Oustanding Documents
 | Address 4 | Description 4 | Client 4 | 789/789/789 | OP | 0 | Waiting on Plumbing cert
=INDEX(List_Of_Names,ROW(A1)) | Address 5 | Description 5 | Client 5 | 001/123/001 | AMDT OP | 0 | 0
Spreadsheet: 857507d1706521720-slicer-filter-on-pivot-table-sample
Sheet: Sheet3

Row Labels | Sum of FTE | Count of Funding | Count of Product
Staff 1 | 1 | 1 | 1
Staff 2 | 2 | 1 | 1
Staff 3 | 1 | 1 | 1
Staff 4 | 3 | 1 | 1
Staff 5 | 1 | 1 | 1
Grand Total | 8 | 5 | 5
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: June

 |  |  |  | Date | 2010-08-10 12:26:51 |  | June Total Hours
 |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | Percentage
 | Year | Month | Date | Hours | Total Hours |  |  | Total Hours |  |  | 240 | 100
 | 2011 | June | 2011-06-01 00:00:00 | 0 | 0 |  |  | Total Hours Requested |  |  | 0 | 0
 |  |  | 2011-06-02 00:00:00 | 0 |  |  |  | Hours Not Requested |  |  | 240 | 100
 |  |  | 2011-06-03 00:00:00 | 0
 |  |  | 2011-06-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  | Key
 |  |  | 2011-06-05 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Hours Requested
 |  |  | 2011-06-06 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Left Over Hours
 |  |  | 2011-06-07 00:00:00 | 0
 |  |  | 2011-06-08 00:00:00 | 0
 |  |  | 2011-06-09 00:00:00 | 0
 |  |  | 2011-06-10 00:00:00 | 0
 |  |  | 2011-06-11 00:00:00 | 0
 |  |  | 2011-06-12 00:00:00 | 0
 |  |  | 2011-06-13 00:00:00 | 0
 |  |  | 2011-06-14 00:00:00 | 0
 |  |  | 2011-06-15 00:00:00 | 0
 |  |  | 2011-06-16 00:00:00 | 0
 |  |  | 2011-06-17 00:00:00 | 0
 |  |  | 2011-06-18 00:00:00 | 0
 |  |  | 2011-06-19 00:00:00 | 0
 |  |  | 2011-06-20 00:00:00 | 0
 |  |  | 2011-06-21 00:00:00 | 0
 |  |  | 2011-06-22 00:00:00 | 0
 |  |  | 2011-06-23 00:00:00 | 0
 |  |  | 2011-06-24 00:00:00 | 0
 |  |  | 2011-06-25 00:00:00 | 0
 |  |  | 2011-06-26 00:00:00 | 0
 |  |  | 2011-06-27 00:00:00 | 0
 |  |  | 2011-06-28 00:00:00 | 0
 |  |  | 2011-06-29 00:00:00 | 0
 |  |  | 2011-06-30 00:00:00 | 0
Spreadsheet: 15bbf489-2793-43ac-a7e7-5678a5ea2a60
Sheet: Increase

CALCULATION OF IHC RENT INCREASE
 | (Increased Housing Costs, p.2)
 | Calculation of Increase as a Percentage |  |  |  |  | CPI [NAME] beginning:
 | RBR, Apdx A, §10.1.1 |  |  |  |  | 2003-06-01 00:00:00 | 0.036
1 | (Income and Expenses, line 29) | Annual expenses increased by |  |  |  | 2004-06-01 00:00:00 | 0.007
 |  |  |  |  |  | 2005-06-01 00:00:00 | 0.019
2 | (line 1 divided by 12) | Average monthly increased expenses |  |  |  | 2006-06-01 00:00:00 | 0.033
 |  |  |  |  |  | 2007-07-01 00:00:00 | 0.033
3 | (total of old rents below) | Monthly gross operating income |  |  |  | 2008-07-01 00:00:00 | 0.032
3a |  | Gross rent verification: |  |  |  | 2009-07-01 00:00:00 | 0.007
4 | (line 2 divided by line 3) | Percent increase |  |  |  | 2010-07-01 00:00:00 | 0.027
 |  | Is Percent increase greater than CPI? |  |  |  | 2011-07-01 00:00:00 | 0.02
 |  |  |  |  |  | 2012-07-01 00:00:00 | 0.03
 |  | Allocation of Increase: CPI or IHC? |  |  |  | 2013-07-01 00:00:00 | 0.021
Unit | Rent from year 2 (monthly) | $ Increase | New Rent |  |  | 2014-07-01 00:00:00 | 0.019
1 |  |  |  |  |  | 2015-07-01 00:00:00
2 |  |  |  |  |  | 2016-07-01 00:00:00
3
4
Monthly
Annual
Spreadsheet: 691281d1597605036-name-value-in-comma-seperated-list-sample
Sheet: Sheet1

Name | Value
[NAME] | 11
[NAME] | 2
[NAME] | 1
[NAME] | 12
Timothy | 51
[NAME] | 24
Campbell | 3
[NAME] | 3
Carol | 5
[NAME] | 6
Destin | 7
Kayden | 17
[NAME] | 4
Betty | 1
[NAME] | 10
[NAME] | 1
Davy | 3
[NAME] | 31
[NAME] | 149
Will | 5
[NAME] | 5
[NAME] | 9
[NAME] | 13
Fay | 5
Spreadsheet: 92a3ad2b-c1b4-438f-861d-f369b24b9582
Sheet: POUHD

Gene | Name | ISH Results
CG9151 | acj6 | pan-mesodermal early; PNS; VM
CG34395 | nub | ectoderm; gut
CG12287 | pdm2 | hindgut; foregut; head; CNS; PNS; tracheal pits
CG10037 | vvl | PNS; tracheal pits; hindgut
CG11641 | pdm3 | [NAME]
CNS=central nervous system
PNS=peripheral nervous system
VM=visceral mesoderm
Spreadsheet: 21886d1210051223-exclude-rows-from-autofilter-excluding-rows-from-autofilter
Sheet: Sheet1

Data set before:
Part No. | Qty.
Assembly 1
A | 1
B | 2
C | 3
D | 4
Assembly 2
A | 5
C | 6
Assembly 3
B | 7
D | 8
Apply Filter of Part No. = B on column A
Data set after:
Part No. | Qty.
Assembly 1
B | 2
Assembly 2
Assembly 3
B | 7
I would also like to be able to keep the autofilter arrows so when others use this sheet they can select the appropriate part no.
Thanks for your help!
Spreadsheet: 682111d1591904918-if-formula-using-getting-hung-up-by-negative-number-book1
Sheet: Sheet1

 | Account: | Global | Account Type: | Global
 |  | Target | Current Allocation | Tolerance | Difference | Rebalancing [NAME]?
 | US Equity
 | Intl Equity
 | Total Equity
 | Fixed Income
 | Account: |  | Account Type: | IRA
 |  | Target | Current Allocation | Tolerance | Difference | Rebalancing [NAME]?
 | US Equity
 | Intl Equity
 | Total Equity
 | Fixed Income
Spreadsheet: john_hodge__16372__Total Gas & Electric
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-11-05 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Total Gas & Electric, Inc. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ENRON ENTITY
COLLATERAL
THRESHOLD  in $ | 500000 | 20000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | X (please see comments) | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | Star Gas Partners LP | Enron Corp. (BBB+)
LIMIT in $[NAME] | 1000000 | 25000000
Incorporation State: |  | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change |  | X
-Below = |  | BBB- (Standard & Poor's)
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-EBITDA/Interest | <3:1
-Current Ratio | <1:1
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by: | Please see other comments
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 5000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:  X
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS
Total Gas & Electric is currently 72.7% owned by Star Gas Parnters, LP.  A MAC should be triggered if Star Gas owns
less than 51% of TG&E.
collateral for trades must be posted if existing and/or potential 60 day receivable + MTM is already over $500,000.
The collateral amount must continually cover 60 day receivable.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 58261
Spreadsheet: 879674d1727249919-capture-data-from-multiple-sheets-sample-data-wk9128-
Sheet: Master

 |  | BU2424 | BU2424 | BU2424 | BU2525 | BU2525 | BU2525
PN | Supplier | Total | JJ | MM+CC | Total | JJ | MM+CC
151 | 102 LLL
171 | 103 MMM
192 | 104 NNN
312 | 105 OOO
312 | 120 PPP
312 | 122 QQQ
*Numbers in RED are the places that I wanted to insert formula.
Spreadsheet: 9ea774f0-2c18-4a20-8412-a77c19bb9cb1
Sheet: MathG

 | Statistics
 | GrowthpercentileMG12
 | 0 | N | Valid | 325359
 |  |  | Missing | 0
 |  | Median |  | 50
 | 1 | N | Valid | 70218
 |  |  | Missing | 0
 |  | Median |  | 50
 | Statistics
 | GrowthpercentileMG12
 | 0 | N | Valid | 325359
 |  |  | Missing | 0
 |  | Median |  | 50
 | 1 | N | Valid | 4640
 |  |  | Missing | 0
 |  | Median |  | 40
 | 2 | N | Valid | 34921
 |  |  | Missing | 0
 |  | Median |  | 50
 | 3 | N | Valid | 30657
 |  |  | Missing | 0
 |  | Median |  | 52
 | ELLMG12 * MetAGP Crosstabulation
 | Count
 |  |  | MetAGP |  | Total
 |  |  | 0 | 1
 | ELLMG12 | 0 | 180308 | 145051 | 325359
 |  | 1 | 51299 | 18919 | 70218
 | Total |  | 231607 | 163970 | 395577
 | LangProfMG12 * MetAGP Crosstabulation
 | Count
 |  |  | MetAGP |  | Total
 |  |  | 0 | 1
 | LangProfMG12 | 0 | 180308 | 145051 | 325359
 |  | 1 | 4226 | 414 | 4640
 |  | 2 | 28138 | 6783 | 34921
 |  | 3 | 18935 | 11722 | 30657
 | Total |  | 231607 | 163970 | 395577