tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7708__IPnet-addresses-3-1-02
Sheet: 2001 pilot

 | Name | Office Phn | Hm. Phn | Address | City | [NAME] | Pipe MBPS | INST $$ | Monthly $$ | CPE Lease | PVC | Sub Total | Adjusted @ 20% Discount | Monthly tax @ 12% | Actual Monthly Est | Adjusted Annual include est. tax
0 | Master Network Link | 713 | [PHONE] | 7210 Ardmore | Houston | 77054 | 1.5m/1.5m | o.o | 329 | 20 | 25
1 | [NAME] | [PHONE] | [PHONE] | 15714 Craighurst Dr. | Houston | 77059 | 128k/1,54m | o.o | 65 | 20 | 25
2 | [NAME] | [PHONE] | [PHONE] | 10218 [NAME]. | Houston | 77070 | 128k/1,54m | o.o | 65 | 20 | 25
3 | [NAME] | [PHONE] | [PHONE] | 6210 [NAME] | Houston | 77084 | 128k/1,54m | o.o | 65 | 20 | 25
4 | [NAME] | [PHONE] | [PHONE] | 10818 Seven Mile Ln. | Houston | 77093 | 1.54m/1.54m | o.o | 65 | 20 | 25
5 | Rahn Nick | [PHONE] | [PHONE] | 20251 Eden Pin Dr. | Spring | 77379 | 1.54m/1.54m | o.o | 109 | 20 | 25
6 | Thompson Charly | [PHONE] | [PHONE] | 905 Rigel | [NAME] | 77546 | 128k/1,54m | o.o | 65 | 20 | 25
7 | [NAME] | [PHONE] | [PHONE] | 15219 Windy Cove | Houston | 77065 | 1.54m/1.54m | o.o | 65 | 20 | 25
8 | [NAME] {Cypress Eng.} | [PHONE] | [PHONE] | 10235 West Little York | Houston | 77040 | 128k/1,54m | o.o | 65 | 20 | 25
9 | [NAME] | [PHONE] | [PHONE] | 12515 Anteanway | Houston | 77065 | 128k/1,54m | o.o | 65 | 20 | 25
10 | Vollmer Marry | [PHONE] | [PHONE] | 4406 lymbar Dr. | Houston | 77096 | 128k/1,54m | o.o | 65 | 20 | 25
 |  | List approved between [NAME] and [NAME] on 7/5/01
Spreadsheet: mary_fischer__25620__77M
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  077M
COMPANY NAME    MEP Services, Inc.
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 789462d1659105357-hlook-up-not-working-last-man-standing
Sheet: teams

 | Accrington Stanley
 | AFC Bournemouth
 | AFC Wimbledon
 | Arsenal
 | [NAME]
 | Barnsley
 | Barrow AFC
 | Birmingham City
 | [NAME]
 | Blackpool
 | [NAME]
 | Bradford City
 | Brentford
 | Brighton and Hove Albion
 | Bristol City
 | Bristol Rovers
 | Burnley
 | [NAME]
 | Cambridge United
 | Cardiff City
 | Carlisle United
 | [NAME]
 | Chelsea
 | [NAME]
 | Colchester United
 | Coventry City
 | Crawley Town
 | [NAME]
 | Crystal Palace
 | Derby County
 | Doncaster Rovers
 | Everton
 | Exeter City
 | Fleetwood Town
 | Forest Green Rovers
 | Fulham
 | Gillingham
 | [NAME]
 | Harrogate Town
 | Hartlepool United
 | Huddersfield Town
 | Hull City
 | Ipswich Town
 | [NAME]
 | Leicester City
 | Leyton Orient
 | Lincoln City
 | Liverpool
 | [NAME]
 | Manchester City
 | [NAME]
 | Mansfield Town
 | Middlesbrough
 | Millwall
 | [NAME]
 | Morecambe
 | Newcastle United
 | Newport County
 | Northampton Town
 | Norwich City
 | [NAME]
 | Oxford United
 | Peterborough United
 | Plymouth Argyle
 | Port Vale
 | Portsmouth
 | [NAME]
 | Queens Park Rangers
 | Reading
 | Rochdale
 | [NAME]
 | Salford City
 | Sheffield United
 | Sheffield Wednesday
 | Shrewsbury Town
 | Southampton
 | Stevenage
 | Stockport County
 | Stoke City
 | Sunderland
 | Sutton United
 | Swansea City
 | Swindon Town
 | [NAME]
 | Tranmere Rovers
 | Walsall
 | Watford
 | West Bromwich Albion
 | West Ham United
 | Wigan Athletic
 | [NAME]
 | Wycombe Wanderers
Spreadsheet: 670073d1585744709-excel-to-sql-script-exceltosqlscriptsampleupdated
Sheet: Sheet1

2229207 | 13824721 | 2020-03-27 00:00:00.000 | 2020-03-27 00:00:00.000 | [NAME] | [NAME] | [NAME] |  | NULL |  | 80007970 | [NAME] | 0520 | 3 | CA | 01 | 01 | H5 | 2018-02-23 00:00:00.000 | 2020-03-23 00:00:00.000 | 1000 | [PHONE] | [NAME] | 10000028 | A | NULL | 80007970 | DL | [NAME] | 17803781 | [NAME] |  |  |  |  |  | 135 | [NAME]
2148402 | 14149839 | 2020-03-27 00:00:00.000 | 2020-03-27 00:00:00.000 | Lewis | Ffion | Bailey |  | NULL |  | 80007970 | [NAME] | 0520 | 3 | CA | 01 | 01 | H5 | 2018-01-08 00:00:00.000 | 2020-03-24 00:00:00.000 | 1000 | 10000304 | [NAME] | 10000022 | A | NULL | 80007970 | DL | [NAME] | 24436695 | [NAME] |  |  |  |  |  | 135 | [NAME]
Result as of now:
[NAME]:
Expected Result :
(2229207,13824721,'2020-03-27 00:00:00.000','2020-03-27 00:00:00.000','Clark','Khadija','Peterson','',NULL,'','80007970','Peterson','0520','3','CA','01','01','H5','2018-02-23 00:00:00.000','2020-03-23 00:00:00.000','1000','[PHONE]','Peterson','10000028','A',NULL,'80007970','DL','Peterson','17803781','Peterson','','','','','','135','Peterson')
(2148402,14149839,'2020-03-27 00:00:00.000','2020-03-27 00:00:00.000','Lewis','Ffion','Bailey','',NULL,'','80007970','Peterson','0520','3','CA','01','01','H5','2018-01-08 00:00:00.000','2020-03-24 00:00:00.000','1000','10000304','Peterson','10000022','A',NULL,'80007970','DL','Peterson','24436695','Peterson','','','','','','135','Peterson')
Note: Only NULL values will not include single quote.
Note: NULL values are only found on columns I and Z
Spreadsheet: 721502d1614736222-comparing-values-in-two-columns-sample-worksheet
Sheet: Sheet1

Cell A | Cell B
10A | 2fh2h2f09h0999-000/10A
B10 | FI2OFIF92F7FBFUBF--2/00/B10
100 | FUBEIUFBFUBFFFF/1000
0100 | 43583F8H48FH0-100000/0100
10 | HD829HF8H82FH/10
100 | 123F/100
1000 | TEXTTEXTTEXT23123UIINF/10000
2000 | F2NB4UIFBUB/2000
10000 | F2HB2H/00/10000-REF
300 | G9990303/30-ORF
50 | R21IR9032HR9-2R22HF-0F29/50
Spreadsheet: vkaminski__40702__28NGprice_windowsize
Sheet: Sheet1

 |  | TIME BUCKET |  | 10 ON Each | 20 ON EITHER SIDE
NG-PRICE | 2000-06-28 00:00:00 | 2 | M | 15441.0956 | 17506.8638
NG-PRICE | 2000-06-28 00:00:00 | 3 | M | 15826305.8 | 15103103.6
NG-PRICE | 2000-06-28 00:00:00 | 4 | M | 4390086.33 | 4191678.41
NG-PRICE | 2000-06-28 00:00:00 | 5 | M | 275601.411 | 269635.573
NG-PRICE | 2000-06-28 00:00:00 | 6 | M | -18254657 | -17583092
NG-PRICE | 2000-06-28 00:00:00 | 7 | M | 1618656.52 | 1558721.51
NG-PRICE | 2000-06-28 00:00:00 | 8 | M | -14205023 | -13859891
NG-PRICE | 2000-06-28 00:00:00 | 9 | M | -1422098.5 | -1400065.6
NG-PRICE | 2000-06-28 00:00:00 | 10 | M | 2546804.46 | 2518008.14
NG-PRICE | 2000-06-28 00:00:00 | 11 | M | -5256162.5 | -5214311.2
NG-PRICE | 2000-06-28 00:00:00 | 12 | M | 2998365.29 | 2988874.48
NG-PRICE | 2000-06-28 00:00:00 | 13 | M | 29929.4839 | 29856.7029
NG-PRICE | 2000-06-28 00:00:00 | 14 | M | -1114509.1 | -1122852.3
NG-PRICE | 2000-06-28 00:00:00 | 15 | M | -149267.68 | -150663.04
NG-PRICE | 2000-06-28 00:00:00 | 16 | M | -617533.38 | -623740.65
NG-PRICE | 2000-06-28 00:00:00 | 17 | M | -620592.88 | -627074.39
NG-PRICE | 2000-06-28 00:00:00 | 18 | M | 585946.077 | 590917.412
NG-PRICE | 2000-06-28 00:00:00 | 1 | Y | -1073867.5 | -1090021.7
NG-PRICE | 2000-06-28 00:00:00 | 2 | Y | 377510.222 | 365920.209
NG-PRICE | 2000-06-28 00:00:00 | 3 | Y | -1199027.8 | -1231215.2
NG-PRICE | 2000-06-28 00:00:00 | 4 | Y | 425939.486 | 456196.515
NG-PRICE | 2000-06-28 00:00:00 | 5 | Y | 497770.874 | 526061.579
NG-PRICE | 2000-06-28 00:00:00 | 6 | Y | 497604.867 | 525884.911
NG-PRICE | 2000-06-28 00:00:00 | 7 | Y | 9146.20221 | 9660.92192
NG-PRICE | 2000-06-28 00:00:00 | 8 | Y | -214575.04 | -226777.12
NG-PRICE | 2000-06-28 00:00:00 | 9 | Y | -145573.21 | -153852.81
NG-PRICE | 2000-06-28 00:00:00 | 10 | Y | -165333.41 | -174736.08
NG-PRICE | 2000-06-28 00:00:00 | 11 | Y | -194096.52 | -205134.06
NG-PRICE | 2000-06-28 00:00:00 | 12 | Y | -228131.01 | -241103.07
NG-PRICE | 2000-06-28 00:00:00 | 13 | Y | -193860.25 | -204884.16
NG-PRICE | 2000-06-28 00:00:00 | 14 | Y | -17565.304 | -18567.963
NG-PRICE | 2000-06-28 00:00:00 | 15 | Y | -7618.8062 | -8056.0079
NG-PRICE | 2000-06-28 00:00:00 | 16 | Y | -6515.1566 | -6889.2372
Spreadsheet: 855244d1704889557-concerting-time-to-degrees-time-and-degrees-aligw
Sheet: Sheet1

TIME | DEGREE | [NAME] | Format
18:00:00 | 0"
20:00:10 | 30
21:00:00 | 45 |  |  | 24 | HOURs
22:00:00 | 60 |  |  | 360 | DEGREES
22:48:00 | 72
00:00:00 | 90 |  |  |  | DEGRESS/HOUR
02:00:00 | 120
03:00:00 | 135
03:36:00 | 144
04:00:00 | 150
06:00:00 | 180
08:00:00 | 210
08:24:00 | 216
09:00:00 | 225
10:00:00 | 240
12:00:00 | 270
13:12:00 | 288
14:00:00 | 300
15:00:00 | 315
16:00:00 | 330
18:00:00 | 360
Spreadsheet: 84059d1284055206-count-the-same-values-qr_cache-1-
Sheet: Puzzel

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 3 | 3 |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 7 |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  | 1 | 3 |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 2 | 1 | 1 | 1 |  | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 |  |  | 7 | 1 | 1 | 1 | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  | 7 | 1 | 2 | 1 | 1 | 1 | 1 |  | 2 | 4 | 3 | 2 | 3 | 1 | 2 | 2 | 1 | 2 | 1 | 1 | 3 | 1 | 2 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2 | 1 | 3 | 1 |  | 7 | 1 | 1 | 2 | 4 | 3 | 2 | 2 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 3 | 1 | 2 | 7 | 1 | 2 | 3 | 2 | 3 | 1 | 3 | 5 | 2 | 2 | 1 | 4 | 4 | 2 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 3 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 11 | 1 | 1 | 2 | 6 | 1 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  | 7 | 1 | 1 | 1 | 1 | 1 | 7 | 1 | 1 | 2 | 1 | 4 | 1 | 2 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 4 | 3
 |  |  |  |  | 7 | 2 | 1 | 1 | 7
 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
 | 1 | 3 | 1 | 2 | 1 | 2 | 1 | 3 | 1
 | 1 | 3 | 1 | 3 | 1 | 1 | 1 | 3 | 1
 |  |  | 1 | 3 | 1 | 4 | 1 | 3 | 1
 |  |  | 1 | 1 | 2 | 2 | 2 | 1 | 1
 |  |  | 7 | 1 | 1 | 1 | 1 | 1 | 7
 |  |  |  |  |  | 1 | 1 | 1 | 2
 |  | 1 | 1 | 4 | 1 | 1 | 4 | 2 | 1
 |  |  | 2 | 2 | 1 | 3 | 1 | 1 | 1
 |  |  | 2 | 2 | 2 | 1 | 3 | 2 | 1
 |  |  |  | 2 | 2 | 1 | 4 | 1 | 2
 | 2 | 3 | 1 | 1 | 3 | 1 | 1 | 1 | 1
 |  |  |  |  | 1 | 3 | 2 | 9 | 3
 |  |  |  | 1 | 2 | 1 | 4 | 1 | 2
 |  |  | 1 | 3 | 1 | 2 | 1 | 3 | 2
 |  |  |  | 2 | 4 | 1 | 1 | 7 | 1
 |  |  |  |  |  | 1 | 1 | 3 | 3
 |  |  |  | 7 | 3 | 2 | 1 | 2 | 2
 |  |  |  | 1 | 1 | 5 | 2 | 1 | 3
 |  |  |  | 1 | 3 | 1 | 1 | 5 | 2
1 | 3 | 1 | 1 | 1 | 1 | 2 | 2 | 1 | 1
 |  |  | 1 | 3 | 1 | 2 | 1 | 1 | 1
 |  | 1 | 1 | 4 | 1 | 2 | 1 | 1 | 1
 |  |  | 7 | 1 | 1 | 4 | 1 | 1 | 1
Spreadsheet: 56716d1256834020-cell-as-reference-anchor-to-another-sheet-705005
Sheet: Sheet1

Test 1
 | X: | -32 | -31 | -30
 | Y: | 0.22 | 0.52 | 0.64
Test 2
 | X: | -32 | -31 | -30
 | Y: | 0.0654 | 0.654 | 0.54
Test 3
 | X: | -32 | -31 | -30
 | Y: | 0.42 | 0.8 | 0.36
Test 4
 | X: | -32 | -31 | -30
 | Y: | 0.22 | 0.52 | 0.23
Test 5
 | X: | -32 | -31 | -30
 | Y: | 0.385 | 0.66 | 0.9
Spreadsheet: 56840d1256947695-how-to-copy-rows-automatically-example1
Sheet: Sheet1

From below original(3 unites for building1, 2 unites for  building2 and 4 unites for  building3)
Building1 | 3 | Units
Building2 | 2 | Units
Building3 | 4 | Units
Turn to below destination(Building1 shown in 3 rows, Building2 shown in 2 rows and building3 shown in 4 rows)
Building1 | 1 | Units
Building1 | 1 | Units
Building1 | 1 | Units
Building2 | 1 | Units
Building2 | 1 | Units
Building3 | 1 | Units
Building3 | 1 | Units
Building3 | 1 | Units
Building3 | 1 | Units
Spreadsheet: drew_fossum__8671__business plan
Sheet: Sheet1

NORTHERN NATURAL GAS COMPANY
2001 – 2003 OPERATING & STRATEGIC PLAN
BUSINESS PLAN
* Anticipate continuing changes in North American gas flows, pursue new market opportunities for natural gas, protect current markets,
and capture end-users in potential markets capable of by-pass.
* Re-evaluate NNG’s north-end and south-end asset operations to identify candidates for swap/sale.  Avoid stranded assets due
to changing markets and Canadian gas flows.
* Continue improvement of decision-making tools for valuing of long and short-term capacity and the profitability of individual deals.
* Significantly improve ability to optimize system operations to create capacity, to conserve fuel, and to reduce unaccounted-for gas.
Hold the line on O&M.
* Pursue identification, evaluation and possible implementation of viable acquisition, alliance, or joint venture opportunities.
* Improve customer service to solidify customer loyalty and develop a Company culture targeted at excellence in [NAME].
* Improve organizational effectiveness.
* Exploit advances in technology.
[NAME]
2001 – 2003 OPERATING & STRATEGIC PLAN
BUSINESS PLAN
* Anticipate continuing changes in North American gas flows, pursue new market opportunities for natural gas, protect current markets,
and capture end-users in potential markets capable of by-pass.
* Continue improvement of decision-making tools for valuing of long and short-term capacity and the profitability of individual deals.
* Significantly improve ability to optimize system operations to create capacity, to conserve fuel, and to reduce unaccounted-for gas.
Hold the line on O&M.
* Pursue identification, evaluation and possible implementation of viable acquisition, alliance, or joint venture opportunities.
* Improve customer service to solidify customer loyalty and develop a Company culture targeted at excellence in [NAME].
* Improve organizational effectiveness.
* Exploit advances in technology.
Spreadsheet: 193974d1353000470-multiple-formulas-needed-in-one-cell-to-create-a-value-in-a-new-cell-media-tracking-percentage-comparison1-ver3
Sheet: Tables - Avg Daily Sales

Avg Daily Sales (Avg)
 |  |  |  |  |  |  |  |  |  | Vlookup Table
Medium |  |  |  |  |  |  |  |  |  | Points Score |  |  | Sales - excluding campaigns
 | TV | Radio |  |  |  |  |  |  |  | -100 | 1 |  | Avg daily sales compared to all sales
Brisbane |  |  |  |  |  |  |  |  |  | -0.3 | 2 |  |  | Low | High | Pts
Adelaide |  |  |  |  |  |  |  |  |  | -0.1 | 2.5 |  |  | 1 | + | 5
Perth |  |  |  |  |  |  |  |  |  | 0.1 | 3 |  |  | 0.3 | 1 | 4
Sydney |  |  |  |  |  |  |  |  |  | 0.3 | 4 |  |  | 0.1 | 0.3 | 3
Melbourne |  |  |  |  |  |  |  |  |  | 1 | 5 |  |  | -0.1 | 0.1 | 2.5
Newcastle |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.3 | -0.1 | 2
Gold Coast |  |  |  |  |  |  |  |  |  |  |  |  |  | + | -0.3 | 1
ACT
TV Station
 | Seven Network | Nine Network | Network Ten | Prime7 | NBN | SCA | WIN
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Radio Station
 | ATN | 97.3 | Triple M | Beat 105 | Nova | Sea FM | Gold FM | Hot Tomato | 2DAY | Mix | WSFM | FOX FM | 92.9 | 96FM | NXFM | KOFM | SAFM | 104.7
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Reach % |  |  |  |  |  |  | TV Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Radio Reach % |  |  |  |  |  |  | Radio Frequency %
 | 0-50% | 50-60% | 60-70% | 70-80% | 80-100% |  |  | 0-40% | 40-50% | 50-60% | 60-70% | 70-100%
Brisbane |  |  |  |  |  |  | Brisbane
Adelaide |  |  |  |  |  |  | Adelaide
Perth |  |  |  |  |  |  | Perth
Sydney |  |  |  |  |  |  | Sydney
Melbourne |  |  |  |  |  |  | Melbourne
Newcastle |  |  |  |  |  |  | Newcastle
Gold Coast |  |  |  |  |  |  | Gold Coast
ACT |  |  |  |  |  |  | ACT
Spreadsheet: 881677d1729797264-conditional-formatting-with-different-date-help-sample-excel-file-etaf
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | I want to be able to have conditional formatting that will turn a cell red when it is at or over 30 days from the current date.  I am trying to have the red cells show as a notice of upcoming expiring documents that need to be updated.
2013-10-25 00:00:00 | 2027-02-10 00:00:00 | 2025-12-01 00:00:00 | 2024-01-02 00:00:00 | 2024-12-19 00:00:00
2024-07-16 00:00:00 | 2026-01-09 00:00:00 | 2026-07-08 00:00:00 | 2024-07-09 00:00:00 | 2024-07-09 00:00:00 | <<<<< Example
2014-09-10 00:00:00 | 2024-12-22 00:00:00 | 2026-08-07 00:00:00 | 2024-02-21 00:00:00 | 2024-12-19 00:00:00
2013-10-25 00:00:00 | 2024-10-03 00:00:00 | 2026-02-07 00:00:00 | 2024-02-13 00:00:00 | 2024-12-19 00:00:00
2013-10-01 00:00:00 | 2028-01-29 00:00:00 | 2025-01-16 00:00:00 | 2024-02-21 00:00:00 | 2024-12-19 00:00:00
2024-08-10 00:00:00 | 2027-12-30 00:00:00 | 2025-08-15 00:00:00 | 2024-10-22 00:00:00 | 2024-12-19 00:00:00
2024-08-10 00:00:00 | 2028-05-23 00:00:00 | 2026-02-23 00:00:00 | 2024-10-22 00:00:00 | 2024-12-19 00:00:00
2024-05-06 00:00:00 | 2027-03-27 00:00:00 | 2024-12-05 00:00:00 | 2024-08-12 00:00:00 | 2024-04-23 00:00:00
2024-03-07 00:00:00 | 2026-08-06 00:00:00 | 2026-01-26 00:00:00 | 2024-07-17 00:00:00 | 2024-12-19 00:00:00
2024-06-03 00:00:00 | 2026-05-01 00:00:00 | 2025-04-17 00:00:00 | 2024-06-04 00:00:00 | 2024-06-04 00:00:00
2024-09-04 00:00:00 | 2027-12-10 00:00:00 | 2025-06-09 00:00:00 | 2024-10-22 00:00:00 | 2024-08-26 00:00:00
2024-05-29 00:00:00 | 2028-04-10 00:00:00 | 2024-11-14 00:00:00 | 2024-10-22 00:00:00 | 2024-05-01 00:00:00
2024-05-24 00:00:00 | 2028-12-28 00:00:00 | 2025-04-24 00:00:00 | 2024-10-18 00:00:00 | 2024-05-09 00:00:00
2024-03-01 00:00:00 | 2029-05-01 00:00:00 | 2025-03-01 00:00:00 | 2024-10-22 00:00:00 | 2024-02-26 00:00:00
2021-06-07 00:00:00 | 2025-01-21 00:00:00 | 2024-10-31 00:00:00 | 2024-07-17 00:00:00 | 2024-12-19 00:00:00
2024-05-21 00:00:00 | 2032-06-23 00:00:00 | 2025-05-18 00:00:00 | 2024-10-18 00:00:00 | 2024-04-26 00:00:00
2024-09-06 00:00:00 | 2026-03-14 00:00:00 | 2024-11-15 00:00:00 | 2024-10-22 00:00:00 | 2024-12-19 00:00:00
Spreadsheet: 842088d1694158672-easy-filter-question-excel-excercise-ivar
Sheet: Sheet1

Snack type | Month | Amount
Chocolate | Januari | 3
 | Februari | 4
 | March | 5
 | April | 6
Candy | Januari | 1
 | Februari | 2
 | March | 3
 | April | 4
[NAME] | Januari | 5
 | Februari | 6
 | March | 7
 | April | 8
Spreadsheet: 273407d1382707019-sumifs-with-multiple-criteria-in-multiple-columns-multiple-criterias
Sheet: SUMMARY

 |  |  |  |  |  | Field 1
 |  |  |  |  |  | All | *
 |  |  |  |  |  | AIR
 |  | IN | LBU | All |  | CGD
 |  | Field 1 | Field 2 | Field 3 |  | MAA
 |  |  |  |  |  | MNL
 |  |  |  |  |  | PNQ
 |  |  |  |  |  | IN | AIR | MAA | PNQ
 |  |  |  |  |  | Others | MNL | CGD
 |  | Elements | Cost
 |  | Communication Cost |  |  |  | Field 2
 |  | Company Cars |  |  |  | All | *
 |  | Employee Benefits |  |  |  | -
 |  | Food & Canteen |  |  |  | ADM
 |  | Housing Expense |  |  |  | GBU
 |  | Local Data Communication |  |  |  | LBU
 |  | Salaries and Related |  |  |  | BU | LBU | GBU
 |  | Staff Training
 |  | Recruitment Cost
 |  | Travel |  |  |  | Field 3
 |  | Sales Cost |  |  |  | All | *
 |  | Support functional cost |  |  |  | CSP
 |  | Taxes |  |  |  | Disputes
 |  |  |  |  |  | FNA
 |  | Field 1 | Field 2 | Field 3 |  | HR
 |  |  |  |  |  | IT
 |  |  |  |  |  | OPS
 |  |  |  |  |  | OTCS
 |  |  |  |  |  | PEX
 |  |  |  |  |  | Sales & TNM
 |  |  |  |  |  | CE | CSP | OTCS
Spreadsheet: 682796d1592334360-hyperlink-to-select-correct-cell-reference-in-pivot-table-data-dynamically-hyperlink
Sheet: Positions in class

S.No | ID | Open Date | Admission Status | No of Positions in Class
1 | ID101 | 2020-01-01 00:00:00 | Open | 1
2 | ID102 | 2020-02-05 00:00:00 | Open | 4
3 | ID103 | 2020-02-05 00:00:00 | Open | 7
4 | ID104 | 2020-03-08 00:00:00 | Open | 1
5 | ID105 | 2020-04-10 00:00:00 | Closed | 3
6 | ID106 | 2020-06-15 00:00:00 | On-Hold | 1
7 | [NAME] | 2020-06-15 00:00:00 | Closed | 1
8 | ID108 | 2020-06-15 00:00:00 | Open | 1
9 | ID109 | 2020-12-22 00:00:00 | Cancelled | 1
10 | ID110 | 2020-06-22 00:00:00 | Open | 4
11 | ID111 | 2020-06-22 00:00:00 | Open | 1
12 | ID112 | 2020-06-30 00:00:00 | Closed | 3
Spreadsheet: a09d0616-8a41-4721-b068-094216edca3d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-05-28 09:25:32.330000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.817 | 102.692 | 102.567 | 102.192
4.5 | 102.799 | 102.674 | 102.549 | 102.174 |  | Note: | Refer To Price [NAME]
4.375 | 102.567 | 102.442 | 102.317 | 101.942 |  |  | For all Price Adjs
4.25 | 101.98 | 101.855 | 101.73 | 101.105
4.125 | 101.124 | 100.999 | 100.874 | 100.249
4 | 100.13 | 100.005 | 99.88 | 99.255
3.875 | 99.093 | 98.968 | 98.843 | 98.218
3.75 | 98.218 | 98.093 | 97.968 | 97.343
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.875 | 102.75 | 102.625 | 102.25
3.625 | 102.745 | 102.62 | 102.495 | 102.12
3.5 | 102.202 | 102.077 | 101.952 | 101.577
3.375 | 101.482 | 101.357 | 101.232 | 100.857
3.25 | 100.852 | 100.727 | 100.602 | 99.977
3.125 | 100.418 | 100.293 | 100.168 | 99.543
3 | 99.668 | 99.543 | 99.418 | 98.793 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-06-11 09:25:32.330000
30 DAY | 2014-06-26 09:25:32.330000
45 DAY | 2014-07-11 09:25:32.330000
60 DAY | 2014-07-26 09:25:32.330000
90 DAY | 2014-08-25 09:25:32.330000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.