tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 210815d1359568307-save-custom-auto-sort-for-multiple-table-basketball
Sheet: Girls Playoffs

 | 2012-10-23 00:00:00 |  |  | 2012-10-24 00:00:00 |  |  | 2012-10-25 00:00:00
 |  |  |  | 1. (North Central) Young
 |  |  |  |  | 7:15 @ Hillsborough |  | 4. (East) [NAME]
 | 4. (East) [NAME]
 |  | 6:00 @ Liberty |  | 4. (East) [NAME]
 | 5. (West) Farnell |  |  |  |  |  |  |  |  | Roland Park
 |  |  |  |  |  |  |  | 6:00 @ Memorial
 | 3. (North) Liberty
 |  | 7:15 @ Liberty |  | 6. (South East) Randall
 | 6. (South East) Randall
 |  |  |  |  | 6:00 @ Hillsborough |  | 7. (South) Roland Park
 | 2. (Central) [NAME]
 |  | 6:00 @ [NAME] |  | 7. (South) Roland Park
 | 7. (South) Roland Park
 | ** Higher seed is the home team throughout the tournament.
Spreadsheet: john_griffith__16050__2_6_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 53 | 350 | 450 | 36.3 | 46.7 | 1.38 | 2002-02-06 14:55:00
 | HO J2 | 54 | 600 | 700 | 39 | 45.5 | 1.43 | 2002-02-06 14:55:00
 | HO K2 | 54 | 770 | 850 | 39 | 43.1 | 1.39 | 2002-02-06 14:55:00
 | HO M2 | 54 | 900 | 1000 | 37.7 | 41.9 | 1.38 | 2002-02-06 14:55:00
 | HO N2 | 55 | 1020 | 1120 | 38.3 | 42.1 | 1.39 | 2002-02-06 14:55:00
 | HO Q2 | 56 | 1070 | 1170 | 35.8 | 39.2 | 1.32 | 2002-02-06 14:55:00
 | HO U2 | 57 | 1140 | 1200 | 34.6 | 36.4 | 1.27 | 2002-02-06 14:55:00
 | [NAME] | 58 | 1250 | 1350 | 35 | 37.8 | 1.33 | 2002-02-06 14:55:00
 | HO X2 | 58 | 1300 | 1400 | 34.1 | 36.8 | 1.29 | 2002-02-06 14:55:00
 | [NAME] | 59 | 1325 | 1450 | 32.7 | 35.8 | 1.27 | 2002-02-06 14:55:00
 | HO F3 | 60 | 1375 | 1500 | 31.9 | 34.9 | 1.26 | 2002-02-06 14:55: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: 165749d1341331745-looking-for-a-fuction-to-group-same-data-sample-ports
Sheet: Sheet1

 | B | D1 | D2 | E1 | E2 | FOUND IN | CATEGORY GROUP
 | CHARLESTON |  |  |  |  |  | 1
 | SAVANNAH |  |  |  |  |  | 1
 | PORT SAID |  |  |  |  |  | 1
 | PARANAGUA |  |  |  |  |  | 1
 | NORFOLK, VA | NORFOLK, VA |  |  |  |  | 2
 | [NAME] | [NAME] |  | [NAME] |  |  | 3
 | AMSTERDAM | AMSTERDAM |  | AMSTERDAM |  |  | 3
 | PIRAEUS | PIRAEUS |  | PIRAEUS |  |  | 3
 | SINGAPORE | SINGAPORE |  | SINGAPORE |  |  | 3
 | GENOA | GENOA |  | GENOA |  |  | 3
 | DUBAI | DUBAI |  | DUBAI |  |  | 3
 | FUJAIRAH | FUJAIRAH |  | FUJAIRAH |  |  | 3
 | ALGECIRAS | ALGECIRAS |  | ALGECIRAS |  |  | 3
 | NEW ORLEANS | NEW ORLEANS |  | NEW ORLEANS |  |  | 3
 | HOUSTON | HOUSTON |  | HOUSTON |  |  | 3
 | GIBRALTAR | GIBRALTAR |  | GIBRALTAR |  |  | 3
 | NEW YORK | NEW YORK |  | NEW YORK |  |  | 3
 | NEW HAVEN, CT | NEW HAVEN, CT |  | NEW HAVEN, CT |  |  | 3
 | DURBAN |  | DURBAN |  |  |  | 4
 | CAPE TOWN |  | CAPE TOWN |  |  |  | 4
 | BALTIMORE |  | BALTIMORE |  |  |  | 4
 | BEAUMONT |  | BEAUMONT |  |  |  | 4
 | TAMPA, FL |  | TAMPA, FL |  |  |  | 4
 | PORTLAND, OR |  | PORTLAND, OR |  |  |  | 4
 | CORPUS CHRISTI |  | CORPUS CHRISTI | CORPUS CHRISTI |  |  | 5
 | MIAMI |  | MIAMI | MIAMI |  |  | 5
 | BOSTON, MA |  | BOSTON, MA | BOSTON, MA |  |  | 5
 | SUEZ |  | SUEZ | SUEZ |  |  | 5
 | PUSAN |  | PUSAN | PUSAN |  |  | 5
 | BUENOS AIRES |  | BUENOS AIRES |  | BUENOS AIRES |  | 6
 | RIO DE JANEIRO |  | RIO DE JANEIRO |  | RIO DE JANEIRO |  | 6
 | SANTOS |  | SANTOS |  | SANTOS |  | 6
 | RECIFE |  | RECIFE |  | RECIFE |  | 6
 | VITORIA |  | VITORIA |  | VITORIA |  | 6
 | ROSARIO |  | ROSARIO |  | ROSARIO |  | 6
 |  |  | PORT SAID |  |  |  | 7
 |  |  | WILMINGTON, NC |  |  |  | 7
 |  |  | FORTALEZA |  | FORTALEZA |  | 7
 |  |  | SALVADOR |  | SALVADOR |  | 7
Spreadsheet: 174567d1345116334-combining-2-workbooks-workbook-1
Sheet: Staff Members

Total Contracted Hours |  |  | 230
To add a new staff member
Right click on the empty row in the area where you need and click insert. Then fill out the cells
 | Name | Grade | Term |  |  | Contracted Hours
FULL TIME
FULL TIME
PART TIME
FULL TIME
 | name 1 |  |  |  |  | 37.5
 | name 2 |  |  |  |  | 37.5
 | name 3 |  |  |  |  | 37.5
 | name 4 |  |  |  |  | 37.5
 | name 5 |  |  |  |  | 24
 | name 6 |  |  |  |  | 20
 | name 7 |  |  |  |  | 20
 | name 8 |  |  |  |  | 16
PART TIME
FULL TIME
PART TIME
FULL TIME
PART TIME
Spreadsheet: 32458d1228637720-place-a-checkmark-with-a-single-mouse-click-celltick-horizontal
Sheet: Sheet1

Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | Total
[NAME] | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | 100
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a |  |  |  |  | 5
Sandy
Betty |  |  |  |  |  |  |  | a |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | a |  |  |  |  |  |  |  |  |  |  |  |  | No Name
 |  |  |  |  |  |  |  |  |  |  |  | a |  |  |  |  |  |  |  |  | No Name
Spreadsheet: 37997d1236107687-function-to-find-the-winners-in-a-competition-find_winners
Sheet: Teams

2009 - Competitors
Division 1
School | Coach | Student Name | Site #1 | Site #2 | Site #3 | Site #4 | Individual Totals (Sites) | Dress Score | Individual Totals (Sites + Dress) | Team Total (Sites) | Team Total (Sites + Dress)
Northeast | Julie | Brittany | 18 | 12 | 24 | 42 | 96 | 50 | 146
 |  | [NAME] | 12 | 6 | 9 | 20 | 47 | 50 | 97
 |  | [NAME] | 18 | 12 | 36 | 46 | 112 | 50 | 162
 |  | Amber | 15 | 18 | 12 | 46 | 91 | 50 | 141
 |  |  |  |  |  |  | 0 |  |  | 299 | 449
Southeast | [NAME] | Gena | 18 | 48 | 24 | 56 | 146 | 50 | 196
 |  | [NAME] | 54 | 48 | 48 | 60 | 210 | 50 | 260 |  |  | Southeast
 |  | Kendall | 45 | 51 | 39 | 70 | 205 | 50 | 255
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 | 561 | 711
Southwest | [NAME] | [NAME] | 15 | 21 | 48 | 52 | 136 | 50 | 186
 |  | Trent | 42 | 42 | 54 | 70 | 208 | 50 | 258
 |  | [NAME] | 54 | 51 | 33 | 68 | 206 | 50 | 256
 |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  | 0 |  | 0 | 550 | 700
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Blank

 | # | Date | Name | Distance in        Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 |  |  | 2018
 |  |  | 2019
 |  |  | 2020
 |  |  | 2021
Spreadsheet: 104845d1302281224-excel-2007-getting-data-from-another-sheet-page-excelforum
Sheet: Disco

Kalkyl för '[NAME]'
--- | Inkomst | Utgift | Kommentar | Summa | Totalt
 | 0 |  | Grossistinköp
Summa
Disco inköp
Pris/kg | Kvant/Kg | Antal | Godis-namn | Summa | Totalt
0.55 | 56 | 1 | Klubbor, 56/fp
5.35 | 24 | 1 | Snickers, 80g, 24/fp
5.35 | 30 | 1 | [NAME], 85g, 30/fp
24.9 | 1.55 | 1 | [NAME], 1,55kg/fp
24.9 | 2.09 | 1 | Godis Lösvikt - Stora Cola Flaskor, 2,09kg/fp
3.75 | 24 | 5 | Läsk Cola/Fanta/Sprite, 33cl, 24/fp
Summa
Spreadsheet: 733920d1621888941-help-with-an-if-statement-sample-worksheet-for-excel-forum
Sheet: Income Sources in Retirement

Income Sources in Retirement*
*all income numbers below are estimates based on the most current data at the time of form completion
 | Benefit Base Value | Annual Income Rate | Estimated Monthly Rate
Source 1 | N/A | 0 | 2800
Source 2 | N/A | 0 | 0
Source 3 | N/A | 0 | 1545.96
401K | 469011 | 0.035 |  | Select hypothetical return scenario from drop-down
Fidelity Account | 481476.81 | 0.035 |  | Select hypothetical return scenario from drop-down
Long-term NQ Investments | 472830 | 0.035 |  | Select hypothetical return scenario from drop-down
Cash Reserves |  | 0.035 |  | Select hypothetical return scenario from drop-down
Part-time Employment | N/A | 0 | 0
Spreadsheet: 75df373f-d4a1-45b3-9fe5-a39208055838
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
AGXT | Test | AGXT | Alanine:Glyoxylate [NAME] (AGXT) Mutation Analysis (G170R), Blood | AGXT Mutation Analysis (G170R) | Direct Mutation Analysis by Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.  	 Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 2 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:	 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday; 2 p.m. | 5 days | 10 days | 1 | 81479 |  |  |  |  | Rochester
AGXT | [NAME] | VARIES | Varies |  |  |  | Ambient
AGXT | Result | 22646 | [NAME] | [NAME] | Alphanumeric
AGXT | Result | 22647 | [NAME] | [NAME] | Alphanumeric
AGXT | Result | 22648 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
AGXT | Result | 22649 | Order Date | Order Date | Alphanumeric
AGXT | Result | 22650 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
AGXT | Result | 22651 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
AGXT | Result | 22652 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AGXT | Result | 22653 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
AGXT | Result | 22654 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AGXT | Result | 22655 | Reviewed By: | Reviewed By: | Alphanumeric
AGXT | Result | 22656 | Release Date | Release Date | Alphanumeric
Spreadsheet: 155230d1336735018-excel-2007-line-referenced-drop-downs-example3
Sheet: 1775

 | Rec break 1 |  |  | Rec break 2 |  |  | Rec break 3 |  |  | Rec break 4 |  |  | Rec break 5 |  |  | Rec break 6 |  |  | Rec break 7 |  |  | Rec break 8
 | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date
AUD
CAD
CHF
EUR
GBP
USD
Spreadsheet: 475355d1471279171-how-to-highlight-a-row-beneath-last-data-entered-and-to-also-insert-a-row-beneath-that-template
Sheet: BBVA USD

Descripción operación | RUC number | Monto | Currency | PROJECT_I | OPEN_INVC_A | INVC_I | AxeCustNum | CUSTOMER NAME 1 | CURR | BT NUMER | COMPROBANTE OFISIS
A#IA MINERA ANTAPACCAY SA | P.PROV/COMP | 84.32 |  | F70217129 | 84.32 | 51NJX0195 | 247836 | COMPANIA MINERA ANTAPACCAY SA
A AUTOMATIC | JORVEX BANC | 117.02
SERV. Y FAB. DE GABINETES S | [PHONE] | 459.02 |  | F70216100 | 459.02 | 52NJX0145 | 243408 | SERFAGAB SAC | USP
KGM DELIVVERY FERRETERO SAC | [PHONE] | 1081.24 |  |  |  |  | 245239 | KGM DELIVERY FERRETERO SAC | USP
FAROC INVERSIONES SERVICIOS | [PHONE] | 1127.14 |  |  |  |  | 246314 | FAROC INVERSIONES SERVICIOS GE | USP
01-JORVEX-NICE | PAGO FT 190 | 1921.04
O.FUTURA SOLUCIONES INMOBIL | *A/ PROVEED | 2126.36
VEX SAC BANCA AUTOMATIC | ANIXTER JOR | 3295.2
DOMEVA SAC | [PHONE] | 4123.51 | SIN FCT EN OFISIS |  | 4123.51 | 50N001414 | 252753 | DOMEVA SAC
LOGISTICA & SERVICE SRL | [PHONE] | 4755.4 | SIN FCT EN OFISIS |  | 4755.4 | 50N001446 | 245127 | LOGISTICA & SERVICE  S.R.L. | USP
MCSIL SAC | [PHONE] | 5132.17 |  |  |  |  | 248349 | MCSIL S.A.C. | USP
PROYECTO OLARTE EIRL | [PHONE] | 9062.4 |  |  |  |  | 252926 | PROYECTO OLARTE EIRL
WALTER OLARTE CUCHO | [PHONE] | 9062.4 |  |  |  |  | 244427 | OLARTE CUCHO WALTER | USP
Spreadsheet: 885759d1735593586-get-a-new-list-from-one-column-to-a-new-column-treasurer-report-redacted
Sheet: Check Register

[NAME] |  |  |  |  | Current Balance |  |  |  |  | Column1 | Total | Column2
Date | Check # | Description | Split Amounts | Withdrawal | Deposit | Balance | Reconciled | Category |  | NonReconcilled Checks | Outstanding | Balance Balance
2024-09-04 00:00:00 |  | Beginning Balance Deposit |  |  |  | 0 |  |  |  | "=IFERROR(INDEX(Table1[Withdrawal],AGGREGATE(15,6,ROW(Table1[Reconciled])/((Table1[Reconciled]<>"R")*(Table1[Withdrawal]<>"")),ROW(Table1[@Reconciled])-1)-1),"")"
9/4/20224 |  | Deposit - Dues and Lifeflight |  |  | 630 |  | R | Dues & Lifeflight
2024-09-06 00:00:00 |  | Deposit - Dues,Lifeflight, Philanthropic, 50/50 Drawing |  |  | 1800.5 |  | R | Dues & Lifeflight
2024-09-24 00:00:00 |  | Deposit - Bonnie Alumnae Log |  |  | 10 |  | R | [NAME] (2x10) Income
2024-09-25 00:00:00 | 101 | Lifeflight |  | 1275 |  |  | R | Lifeflight
2024-09-25 00:00:00 | 102 | [NAME] |  | 27.82 |  |  | R | Miscellaneous Expense
2024-10-02 00:00:00 |  | Deposit - Dues and Lifeflight |  |  | 300 |  | R | Dues & Lifeflight
2024-10-08 00:00:00 |  | Deposit - Sales of Badges |  |  | 6 |  | R | Miscellaneous Income
2024-10-08 00:00:00 |  | Transfer original savings deposit back to checking |  |  | 35 |  | R | Transfer From Savings
2024-10-16 00:00:00 | 103 | District 6 Counselor - Travel Fund |  | 95 |  |  |  | DC Travel Fund
2024-10-16 00:00:00 | 104 | [NAME] Voided Used to [NAME]'s [NAME] |  |  |  |  | R | Dues
2024-10-16 00:00:00 | 105 | Meals on Wheels |  | 346 |  |  | R | [NAME]
 |  | 50/50 Drawing | 155
 |  | Meals on Wheels | 3
2024-10-17 00:00:00 |  | Deposit - 50/50 Drawing and Meals on Wheels |  |  |  |  | R | [NAME]
2024-10-18 00:00:00 | 106 | Alpha Sorority |  |  |  |  |  | Dues - International
 |  | International Dues | 770
 |  | Convention Assessment | 15
2024-11-20 00:00:00 | 107 | District 6 Counselor - Travel Fund |  | 10 |  |  |  | DC Travel Fund
2024-11-20 00:00:00 | 108 | Patsy - Efficiency Award |  | 20 |  |  |  | Awards
 |  | Philanthropic - Honor Flight | 201
 |  | 50/50 Drawing | 4.3
2024-11-25 00:00:00 |  | Deposit - Honor Flight and 50/50 Drawing |  |  |  |  | R | [NAME]
2024-12-11 00:00:00 | 109 | Church |  | 35 |  |  |  | Room Rent
2024-12-10 00:00:00 | 110 | Honor Flight |  | 422 |  |  |  | [NAME]
 |  | Honor Flight | 221
 |  | 50/50 Drawing | 4.5
2024-12-10 00:00:00 |  | Deposit - Honor Flight and 50/50 Drawing |  |  |  |  |  | [NAME]
Spreadsheet: 808492d1670497507-combine-2-sheets-grade-6
Sheet: 5 BEST AND WEK STUDENTS

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA MUHULA WA PILI  DARASA LA V  NOVEMBA,2022
E. WANAFUNZI 5 BORA
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
[NAME] DUNI
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: benjamin_rogers__1109__contact numbers
Sheet: Doyle

 | Doyle Generating Plant
 | 1318 Gratis Road, Monroe, GA 30656
 | General Phone Numbers |  |  | Plant Personnel
 | Control Room 1 | [PHONE] |  | Name | Title | Office | Cellular | Home | [NAME]
 | Control Room 2 | [PHONE] |  | [NAME] | Plant Manager | [PHONE] | [PHONE] | [PHONE]
 | Control Room Fax | [PHONE] |  |  | Maintenance Manager | [PHONE]
 | On Call Pager 1 |  |  | [NAME] | Plant Supervisor | [PHONE] | [PHONE] | [PHONE]
 | On Call Pager 2 |  |  |  | Tech |  |  |  |  |  | Georgia Transmission | [PHONE]
 | Local Police Dept. | [PHONE] |  |  | Tech
 | Local Fire Dept. | [PHONE] |  |  | Tech
 |  |  |  |  | Tech
 | Neighboring Control Areas
 | [NAME] | [PHONE]
 | [NAME] | [PHONE] |  | [NAME] | Start Up Mgr | [PHONE] | [PHONE]
 | SOCO Control Room | [PHONE] |  |  | Start Up Other | [PHONE]
 | Georgia Transmission | [PHONE]
 | [NAME]
 | Gas Control
Spreadsheet: 154953d1336624874-conditional-formatting-for-dates-and-highlighting-cells-cf-on-dates
Sheet: Sheet1

Date
Days Overdue |  |  |  |  |  |  |  | Date of decision | Decision |  |  | Date final report delivered
 |  |  |  |  |  |  |  | 2012-05-08 00:00:00 | Approved
 |  |  |  |  |  |  |  |  | (none)
 |  |  |  |  |  |  |  | 2012-03-14 00:00:00 | Approved |  |  | 2012-04-24 00:00:00
 |  |  |  |  |  |  |  | 2011-12-01 00:00:00 | Approved
 |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | Approved
 |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | Not Approved
I need column A to calculate the number of days between todays date (cell B 1) and the date of decision (eg 20 days).  Obviously todays date will keep changing.
I also need the cells in column A to change colour: turn green when the days overdue are 120 or less, yellow when they are between 121 and 150 days overdue and red when they are 150 or more days overdue.
Also I need the cell in column A to stay blank if there is either no date in the Date Final Report Delivered column (M) or the text in Decision column (J) is other than Approved.
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: TX-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 | 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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
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
FT-South Texas
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 250136d1373816037-converting-columns-into-rows-expected_result
Sheet: Sheet1

dept | emp | sal | Tot sal
[NAME] | Ripple | 5000
 | kichy | 2000
 | Dazlr | 3000
 | [NAME] | 4000
 | [NAME] | 1000 | 15000
IT | [NAME] | 9800
 | [NAME] | 2004
 | [NAME] | 8976
 | [NAME] | 2345
 | Daylne | 8974 | 32099
Spreadsheet: 0870074d-0727-4928-a17e-5495d9ad4023
Sheet: Form 6 Proprietary-Enterprise

Form 6 |  |  | PROPRIETARY OR ENTERPRISE FUND
 |  |  | -1 | -2 | -3 | -4
 | Fund: |  |  | ESTIMATED
 |  |  | ACTUAL PRIOR | CURRENT
 |  | REVENUE | YEAR ENDING | YEAR ENDING | TENTATIVE | FINAL
 |  |  |  |  | APPROVED | APPROVED
1000 |  | LOCAL SOURCES
1300 |  | Tuition
1400 |  | Transportation Fees
1500 |  | Investment Income
1600 |  | Food Services
1700 |  | Direct Activities
1800 |  | Community Service Activities
1900 |  | Other Revenues
TOTAL LOCAL SOURCES
3000 |  | REVENUE FROM STATE SOURCES
3100 |  | Unrestricted Grants-in-Aid
3200 |  | State Govt Restricted Funding
TOTAL STATE SOURCES
4000 |  | FEDERAL SOURCES
4100 |  | Unrestricted Grants-in-Aid DIRECT from Fed Govt
4200 |  | Unrestricted Grants-in-Aid from Fed Govt pass thru the State
4300 |  | Restricted Grants-in-Aid Direct - Fed
4500 |  | Restricted Grants-in-Aid Fed Govnt pass-thru the State
4700 |  | Grants-in-Aid from Fed Govt Thru Other Intermediate Agencies
TOTAL FEDERAL SOURCES
5000 |  | OTHER FINANCING SOURCES
5200 |  | Fund Transfers In
5300 |  | Proceeds from the Disposal of Real or Personal Property
5400 |  | Loan Proceeds
5500 |  | Capital Lease Proceeds
5600 |  | Other Long-Term Debt Proceeds
6000 |  | Other Items
TOTAL OTHER SOURCES
8000 OPENING FUND BALANCE
 | Reserved Opening Balance
 | Unreserved Opening Balance
TOTAL OPENING FUND BALANCE
TOTAL ALL RESOURCES
Form 6 Proprietary/Enterprise |  |  | Page 1 of 2
Form 6 Proprietary/Enterprise |  |  | -1 | -2 | -3 | -4
 |  |  |  | ESTIMATED | BUDGET YEAR ENDING 06/30/10
 |  |  | ACTUAL PRIOR | CURRENT
 |  |  | YEAR ENDING | YEAR ENDING | TENTATIVE | FINAL
 | FUNCTION / OBJECT |  | 2008-06-30 00:00:00 | 2009-06-30 00:00:00 | APPROVED | APPROVED
EXPENSES
 | 1000 | Instruction
 |  | 100  Salaries
 |  | 200  Benefits
 |  | 300/400/500  Purchased Services
 |  | 600  Supplies
 |  | 700  Property
 |  | 800  Other
 | SUBTOTAL INSTRUCTION EXPENSES:
 | 2000 Support Services
 |  | 100  Salaries
 |  | 200  Benefits
 |  | 300/400/500  Purchased Services
 |  | 600  Supplies
 |  | 700  Property
 |  | 800  Other
 | SUBTOTAL SUPPORT EXPENSES:
 | 3100 | Food Service
 |  | 100  Salaries
 |  | 200  Benefits
 |  | 300/400/500  Purchased Services
 |  | 600  Supplies
 |  | 700  Property
 |  | 800  Other
 | SUBTOTAL FOOD SERVICE EXPENSES:
 | 4000 | Facilities Acquisition & Construction
 |  | 100  Salaries
 |  | 200  Benefits
 |  | 300/400/500  Purchased Services
 |  | 600  Supplies
 |  | 700  Property
 |  | 800  Other
 | SUBTOTAL FOOD SERVICE EXPENSES:
 | 5000 | Debt Service
 | 6000 | Miscellaneous
 | SUBTOTAL OTHER SERVICES
TOTAL EXPENSES
 | 8000 | ENDING FUND BALANCE
 |  | Reserved Ending Balance
 |  | Unreserved Ending Balance
 | TOTAL ENDING FUND BALANCE
TOTAL APPLICATIONS
Form 6 Proprietary/Enterprise |  |  | Page 2 of 2
 |  | CHECK -Ending fund balance should be:
Spreadsheet: mary_fischer__25434__SS May Monthly Logs
Sheet: WTG Downtime

GE Wind Maintenance Corp.
Site:     Sommerset
DATE:  6/01/02
WTG DOWNTIME LOG MAY  2002
Pad |  | Date | Date | Time | Time | Elapsed
Location | Description - Fault Indication/Activity | Off | On | Off | On | Hours
 | NONE
Note - if the event is considered a force majeure event, include the wording force majeure in the description.