tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 767636d1644567458-separate-salutation-and-name-test-2
Sheet: Sheet2

Sr | Mem.No | [NAME].Name |  |  |  |  |  |  |  | A/M | [NAME]
2084   D214               MAJ.GEN. (RETD) ASHWANI KUMAR DEWAN (AVSM'ASHWIN', 41,JAMKHED ROAD,                                                                                                                                                                 AHMEDNAGAR-414002                          [EMAIL] |  |  |  |  |  |  |  |  |  | ACM | Air Chief [NAME]
1910 | B396 | A/M M S BAWA |  |  |  |  |  |  |  | ADM | Admiral
2774 | S583 | A/M JAGDISH KUMAR [NAME] |  |  |  |  |  |  |  | Admiral. | Admiral
411 | M060 | ACM O P MEHRA |  |  |  |  |  |  |  | [NAME]. | Admiral
2763 | S562 | ACM N.C. SURI |  |  |  |  |  |  |  | ADMR. | Admiral
690 | T121 | ADM RADHAKRISHAN HARIRAM TAHILIANI (RETD) |  |  |  |  |  |  |  | Air CDRE | Air Commodore
896 | A155 | ADMR. PERBODH NATH AGARWAL |  |  |  |  |  |  |  | [NAME] | Air Commander
2657 | R195 | ADMIRAL. SUSHIL RAMSAY |  |  |  |  |  |  |  | Air COM. | Air Commodore
33 | A148 | AIR CDRE A.R. ANAND |  |  |  |  |  |  |  | [NAME] | [NAME]
48 | B066 | AIR MSHL T S BRAR |  |  |  |  |  |  |  | AVM | Air Vice [NAME]
137 | C124 | AIR COM. N CHATRATH |  |  |  |  |  |  |  | Baba | Baba
162 | C218 | AIR MSHL IQBAL SINGH CHHABRA, PVSM-AVSM(RE |  |  |  |  |  |  |  | Mr | Mr
2727 | S476 | AIR MSHL B.S. SIKAND
2769 | S572 | AIR MSHL MAN MOHAN SINHA
2913 | T019 | AIR CMDR S.B. THAPPAR
32 | A145 | AVM POORAN DEV ADLAKHA
445 | M276 | Mr S M MAYOR
1906 | B384 | AVM I.D. BHALLA
932 | B275 | BABA H S BEDI
Spreadsheet: 219071d1362661366-formula-for-changing-numbers-example-2
Sheet: Sheet1

Event | Item | Qty | Qty Used | Qty Left |  |  |  |  |  |  | Item | Stock
1 | [NAME] | 100 | 10 |  |  |  |  |  |  |  | [NAME] | 100
2 | [NAME] | 500 | 30 |  |  |  |  |  |  |  | [NAME] | 500
3 | [NAME] | 300 | 100 |  |  |  |  |  |  |  | [NAME] | 300
4 | [NAME]
5 | [NAME]
6 | [NAME]
Spreadsheet: 107613d1304722964-copying-multiple-columns-into-single-row-index15
Sheet: output

 | Return on assets |  |  |  |  | Return on equity |  |  |  |  | Current ratio
company "A" | -0.1355283944458302 | -0.004214359596857609 | 0.07733865496699563 | 0.07356177583212391 | 0.09791454655831264 | 0.4449094713856792 | -0.03646719431910644 | 0.1261204515722661 | 0.1606001973820902 | 0.1594770554995629 | 0.2319686411149826 | 0.4087801217376803 | 0.9403198172472872 | 1.789343965204784 | 0.8489134295585908
company "B" | 0.009146393272688532 | -0.04653300040291228 | -0.05481229460043081 | 0.007620341029123284 | 0.02548828431246775 | 0.05321640985077805 | -0.3165285620004399 | -0.4175902244955954 | 0.06668576838748255 | 0.1539064046616917 | 2.38419855552452 | 2.016933261901117 | 2.073707270042349 | 2.093521972294437 | 1.925402536603454
company "C" | 0.1018091299470296 | -0.148623009749071 | -0.6903166076784354 | -0.2754837091159961 | -0.2716170656576682 | 0.2364745416244514 | -0.4720763614927674 | 4.603205736242183 | 0.6061519778650236 | 0.2844232039147294 | 0.7643643382944335 | 0.9270019362423069 | 1.429731914320356 | 1.143366867406969 | 0.8649672338123009
Spreadsheet: eric_saibi__9782__020102
Sheet: Tradinghouse 02

Owner Name | TXU
Station Name | Tradinghouse Creek Power Station
Unit Name | Tradinghouse 02
NERC Region | ERCOT
State | TX
Fuel Type | Natural Gas
Capacity | 799 MW
Start Date | 2002-01-31 00:00:00
End Date | 2002-02-03 00:00:00
Comments | Pre Outage work for March 1 outage
SIC | 4911
Plant ID | 1000923
Unit ID | 1008673
Outage ID | 19756
Spreadsheet: a16d25d7-19d0-4641-be04-b23d28221287
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3858 | 25133 | Lew | Hollander | USA | 0 | 02:07:33 | 00:07:01 | 04:08:17 | 00:08:31 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 295125d1391606140-sorting-data-in-excel-excel-problem-example
Sheet: Sheet1

participant | when t2 | t2 correct |  | participant | t2_correct_lag_1 | t2_correct_lag_2 | t2_correct_lag_3 | [NAME] | t2_correct_lag_5 | t2_correct_lag_6 | t2_correct_lag_7 | t2_correct_lag_8
607 | 1 | 1 |  | 607
607 | 2 | 1 |  | 607
607 | 3 | 1 |  | 209
607 | 4 | 1 |  | 209
607 | 5 | 0
607 | 6 | 0
607 | 7 | 0
607 | 8 | 1
607 | 7 | 1
607 | 4 | 1
607 | 5 | 1
607 | 8 | 1
607 | 2 | 1
607 | 1 | 0
607 | 3 | 1
209 | 1 | 1
209 | 2 | 1
209 | 3 | 1
209 | 4 | 1
209 | 5 | 0
209 | 6 | 0
209 | 7 | 0
209 | 8 | 1
209 | 7 | 1
209 | 4 | 1
209 | 5 | 1
209 | 8 | 1
209 | 2 | 1
209 | 1 | 0
209 | 3 | 1
Spreadsheet: bed50bc1-5b85-4d59-bfd0-a7123f482426
Sheet: Sheet1

Unnamed: 0 | ISBerne PTC/FOISB | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Expense Claim Form
 | Name: |  |  | Date:
 | Event
 | Nature of Expenses |  | Voucher | USD | EUR | GBP | CHF | Tot  (CHF)
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 | Exchange rates (www.oanda.com)
 | Total Expenses |  |  |  |  | CHF |  | 0
 | Advance(s) obtained on …………...………………………. |  |  |  |  | CHF
 | To be reimbursed  / received |  |  |  |  | CHF |  | 0
 | Signature of claimant: |  | Signature authorising person :
 | Bank account Name (beneficiary)
 | Bank
 | Branch
 | IBAN
 | Please attach the supporting documents/bills for all the expenses claimed.
Spreadsheet: 549021d1511423210-dynamic-cell-reference-creation-example
Sheet: After

Lookup_Id | Lookup_Id2 | Lookup_Id3 | Lookup_Key | Lookup_Value | Lookup_Key3 | [NAME]
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Apples | Bananas |  |  |  |  | Watermelons
Oranges | Bananas |  |  |  |  | Watermelons
Bananas | Apples |  |  |  |  | Peaches
Bananas | Oranges |  |  |  |  | Peaches
Spreadsheet: sally_beck__33690__EIM New Cost Centers
Sheet: Sheet1

ENW - Energy Ops - EIM
Old |  | New
CO# | CCtr# | CO# | CCtr# | Cost Center Name | Org # | Org Unit Name | Dept Head | HR Rep/Contact | Financial Contact
1206 | 103401 | 083E | 140147 | ENW - ET - Mid Office - Mgmt | 1043496 | ENW-ET-Mid Off-Mgmt | [NAME] | [NAME] | Holly Heath
1206 | 103403 | 083E | 140148 | ENW - ET - Mid Office - Paper | 1043498 | ENW-ET-Mid Off-Paper | [NAME] | [NAME] | Holly Heath
1206 | 103402 | 083E | 140149 | ENW - ET - Mid Office - Lumber | 1043500 | ENW-ET-Mid Off-Lumbe | [NAME] | [NAME] | Holly Heath
1206 | 103405 | 083E | 140150 | ENW - ET - Mid Office - Asset Management | 1043501 | ENW - ET - Mid Office - Asset Management | [NAME] | [NAME] | Holly Heath
1206 | 103406 | 083E | 140151 | ENW - ET - Mid Office - Project Coordination | 1043502 | ENW-ET-Mid Off-Proj | [NAME] | [NAME] | Holly Heath
1206 | 103408 | 083E | 140152 | ENW - ET - Mid Office - Steel | 1043503 | ENW - ET - Mid Office - Steel | [NAME] | [NAME] | Holly Heath
1206 | 103404 | 083E | 140153 | ENW - ET - Mid Office - Pulp | 1043505 | ENW-ET-Mid Off-Pulp | [NAME] | [NAME] | Holly Heath
1206 | 155000 | 083E | 140154 | ENW - ET - Mid Office - Great Britian | 1043506 | ENW - ET - Mid Office - Great Britian | [NAME] | [NAME] | Holly Heath
Spreadsheet: 47045d1245948449-key-formula-concatrange-po-
Sheet: Order Form

INTERNATIONAL ORDER FORM
[NAME] To: |  |  |  | Ship To:
 |  |  |  |  |  |  |  |  | Customer #:
 |  |  |  |  |  |  |  |  | Terms: | Open-60 days
Order Date: | 2009-06-24 00:00:00 |  |  |  |  |  |  |  | Taken By: | CL
 |  |  |  | [PHONE],[PHONE],[PHONE]
P.O. No. | Product      No. | Description | Quantity | Cost/Bottle | Total | Serial No. | Exp. Date
4500191367 | 555A |  | 456
4500192681 | 457A |  | 502
4500191367 | 254BB |  | 331
4500192922 | 612BB |  | 451
4500191367 | 457A |  | 525
Special Instructions:  2009 Prices for products ordered |  |  |  | Subtotal | 0
 |  |  |  | Freight
 |  |  |  | Total
Delivery Date: |  | Not Established
SAP Due Date: |  | 2009-10-22 00:00:00
Date Wanted: |  | 2009-08-06 00:00:00
Labeling Information
Product No. | Description | Full Shippers/ Cases | Btls/Shipper | Partial Shippers/ Cases | Btls/Partial Shippers/ Cases | Total Btls
555A |  |  | #N/A
457A |  |  | #N/A
254BB |  |  | #N/A
612BB |  |  | #N/A
457A |  |  | #N/A
Gaylord | Product | GLB11A's
Cooler
Spreadsheet: 100353d1298718878-add-horizontal-line-to-stock-chart-766092
Sheet: Sheet1

 | Open | High | Low | Close | [NAME]
Stock A | 10 | 17 | 8 | 15 | 9.5
Stock B | 6 | 9 | 6 | 9 | 9.5
Stock C | 10 | 10 | 5 | 9 | 9.5
Stock D | 5 | 10 | 5 | 8 | 9.5
Stock E | 12 | 15 | 8 | 10 | 9.5
 |  |  |  |  |  |  |  |  |  | Create Stock on range A1:E6
 |  |  |  |  |  |  |  |  |  | Extend chart data range to include column F
 |  |  |  |  |  |  |  |  |  | Select Horizontal Line series and move to secondary axis
 |  |  |  |  |  |  |  |  |  | Format Horizontal line to be solid
 |  |  |  |  |  |  |  |  |  | Delete secondary axis
Spreadsheet: 10c1ba16-cb95-437e-a4b9-730b527998e8
Sheet: Sheet1

Unnamed: 0 | Center for Workforce Information & Analysis | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Revised August 27, 2014
 | Pennsylvania Average Weekly Wage
 | by Calendar Year
 | Calendar | Average
 | Year 1/ | Weekly Wage 2/ |  | % Change
 | 1970 | 137.79 |  | 0.05553853225065115
 | 1971 | 145.69 |  | 0.05733362363016189
 | 1972 | 153.71 |  | 0.05504839041801091
 | 1973 | 163.62 |  | 0.06447205777112743
 | 1974 | 179.4 |  | 0.09644297763109645
 | 1975 | 192.85 |  | 0.07497212931995534
 | 1976 | 206.44 |  | 0.07046927663987557
 | 1977 | 220.33 |  | 0.06728347219531106
 | 1978 | 232.17 |  | 0.0537375754549992
 | 1979 | 251.22 |  | 0.08205194469569717
 | 1980 | 273.7 |  | 0.0894833213916089
 | 1981 | 296.77 |  | 0.08428936792108145
 | 1982 | 312.79 |  | 0.05398119756040044
 | 1983 | 326.11 |  | 0.04258448160107418
 | 1984 | 340.89 |  | 0.04532213056943967
 | 1985 | 354.51 |  | 0.0399542374372965
 | 1986 | 369.59 |  | 0.04253758709204249
 | 1987 | 389.05 |  | 0.0526529397440408
 | 1988 | 410.09 |  | 0.05408045238401224
 | 1989 | 426 |  | 0.03879636177424474
 | 1990 | 447.36 |  | 0.05014084507042257
 | 1991 | 464.91 |  | 0.0392301502145923
 | 1992 | 491.49 |  | 0.05717235593985929
 | 1993 | 500.5 |  | 0.01833201082422835
 | 1994 | 513.61 |  | 0.02619380619380622
 | 1995 | 532.19 |  | 0.03617530811315987
 | 1996 | 552.25 |  | 0.03769330502264218
 | 1997 | 575.58 |  | 0.04224535989135363
 | 1998 | 603.25 |  | 0.04807324785433816
 | 1999 | 625.24 |  | 0.03645254869457109
 | 2000 | 650.17 |  | 0.03987268888746713
 | 2001 | 668.04 |  | 0.02748511927649692
 | 2002 | 683.37 |  | 0.02294772768097725
 | 2003 | 705.81 |  | 0.03283726239079846
 | 2004 | 735.3 |  | 0.04178178263271987
 | 2005 | 756.34 |  | 0.02861417108663141
 | 2006 | 788.47 |  | 0.04248089483565591
 | 2007 | 824.79 |  | 0.04606389589965368
 | 2008 | 846.71 |  | 0.02657646188726836
 | 2009 | 854.55 |  | 0.009259368614992049
 | 2010 | 872.08 |  | 0.02051372067169866
 | 2011 | 896.86 |  | 0.02841482432804327
 | 2012 | 923.69 |  | 0.02991548290703124
 | 2013 | 937.34 |  | 0.01477768515411012
 | 1/ Calendar Year begins January 1 and ends December 31.
 | 2/ Excludes Federal Government.
Spreadsheet: 140340d1328710721-summary-of-the-expenses-book1
Sheet: Sheet2

Sales Man
Spreadsheet: 652587d1575455871-help-with-a-string-of-if-statements-example-dec-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break Exercised? | Lease Break Date | Lease Expiry | Rent | Rent Post Void | Post Void Lease Expiry | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  |  | Yes | 2022-04-10 00:00:00 | 2020-04-09 00:00:00 |  |  | 2021-04-09 00:00:00 | 3
Expected Outcome 1 | Tenant 1 | 2020-01-01 00:00:00 | Yes | 2021-06-20 00:00:00 | 2022-06-20 00:00:00 | 500000 | 472000 | 2022-06-20 00:00:00 | 2 | 125000 | 125000 | 125000 | 125000 | 125000 | 125000 | 125000 | Void | Void | 118000 | 118000 | Void | Void | 118000 | 118000 | 118000 | 118000 | 118000 | 118000 | 118000
Expected Outcome 2 | [NAME] | 2020-01-01 00:00:00 | Yes | 2023-05-30 00:00:00 | 2022-06-20 00:00:00 | 900000 | 624000 | 2022-06-20 00:00:00 | 1 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | Void | 156000 | 156000 | 156000 | Void | 156000 | 156000 | 156000 | 156000
Expected Outcome 3 | Tenant 3 | 2019-09-05 00:00:00 | Yes | 2022-04-10 00:00:00 | 2020-04-09 00:00:00 | 1000000 | 680000 | 2021-04-09 00:00:00 | 3 | 250000 | 250000 | 250000 | Void | Void | Void |  | Void | Void | Void | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000
Initial Loan Requirement |  |  |  |  | Opening Bal
Property Value |  |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  |  | [NAME]
Term |  |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  |  | 0
Capital Allowance |  |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve
Spreadsheet: 159624d1338788676-formula-to-calculate-how-many-people-staying-at-camp-each-night-camp-spreadsheet-example
Sheet: Site Staff

Name | Last Name | Employer | Supervisor | Check-In Date (date of arrival) | Check-Out Date (date of Departure) | No. of nights | Contact # | Date Booked
[NAME] | Smith | Work and Co | [NAME] | 2012-06-01 00:00:00 | 2013-04-30 00:00:00 |  | 0400 000 000 | 29/5/2012
Spreadsheet: john_griffith__16039__2_6_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 54 | 400 | 500 | 40.7 | 51 | 1.56 | 2002-02-06 10:26:00
 | HO J2 | 55 | 640 | 740 | 40.8 | 47.3 | 1.52 | 2002-02-06 10:26:00
 | HO K2 | 55 | 820 | 920 | 40.8 | 45.8 | 1.5 | 2002-02-06 10:26:00
 | HO M2 | 55 | 950 | 1050 | 39.8 | 44 | 1.45 | 2002-02-06 10:26:00
 | HO N2 | 55 | 1040 | 1140 | 39.1 | 42.9 | 1.42 | 2002-02-06 10:26:00
 | HO Q2 | 56 | 1135 | 1235 | 38 | 41.4 | 1.4 | 2002-02-06 10:26:00
 | HO U2 | 57 | 1225 | 1325 | 37.2 | 40.2 | 1.39 | 2002-02-06 10:26:00
 | [NAME] | 58 | 1280 | 1380 | 35.8 | 38.6 | 1.36 | 2002-02-06 10:26:00
 | HO X2 | 59 | 1320 | 1420 | 34.1 | 36.7 | 1.31 | 2002-02-06 10:26:00
 | [NAME] | 59 | 1350 | 1500 | 33.3 | 37 | 1.3 | 2002-02-06 10:26:00
 | HO F3 | 60 | 1400 | 1550 | 32.5 | 36 | 1.29 | 2002-02-06 10:26: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: 168240d1342341271-conditional-format-solution-peformancetracker
Sheet: Reports due

RANK | RATEE | Assigned To | Date Assigned | Days in your Que | Dates due to Mgt | Days due to CSS | CLOSE OUT |  |  |  | diff
[NAME] | [NAME] | [NAME] | 2012-07-01 00:00:00 |  | 2012-06-05 00:00:00 |  | 2012-08-01 00:00:00
Superintendent | [NAME] | [NAME] | 2012-07-01 00:00:00 |  | 2012-06-05 00:00:00 |  | 2012-07-25 00:00:00
[NAME] | [NAME] | [NAME] | 2012-07-02 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-07-26 00:00:00
 | Red | =(H3-F3)<=50
 | Yellow | =AND((H3-F3)>50,(H3-F3)<=60)
 | Green | =(H3-F3)>60
 |  |  |  |  |  |  | 2012-07-25 00:00:00
I have a simple spreadsheet and am trying to get rows or cell (which ever one is easier but prefer row) to highlight Red, Yellow, and Green.
When the date in F3 is within Equal to or less than 50 days from H3 I want the row or cell F3 to turn red
When the date in F3 is within Equal to or less than 51-60 days from H3 I want the row or cell F3 to turn [NAME]
When the date in F3 is within Equal to or less than 61 or more days from H3 I want the row or cell F3 to stay green
On a different topic. The days the reports are due are different from [NAME] and Superintendent. Is it possible to automatically adjust the formula I have in Column F & G?
When I select [NAME], I want the formula in column F to be =H3-50 and G to be =H3-40
When I select [NAME], I want the formula in column F to be =H3-55 and G to be =H3-45
The most important part right now is the conditional, I appreciate any help. Thank you
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 152938 | 152909
2 | 163609 | 164724
3 | 163015 | 164724
4 | 165365 | 164724
5 | 155694 | 155505
6 | 155015 | 157679
7 | 148756 | 146528
8 | 153262 | 151937
9 | 154348 | 152961
10 | 155472 | 152961
11 | 154573 | 152961
12 | 157016 | 156215
13 | 153443 | 152961
14 | 149798 | 152961
15 | 154339 | 161562
16 | 160561 | 162442
17 | 158817 | 162414
18 | 164129 | 162414
19 | 157040 | 156247
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00
2002-03-19 00:00:00
CBS Dollars
 |  |  | 336911
Spreadsheet: 733069d1621371130-formula-that-considers-2-cell-values-of-one-sheet-before-copying-into-a-2nd-sheet-small-if-filtering-to-multiple-sheets-fiftyfingers-
Sheet: COMMUNITY GREEN

Title | First Name | Last Name | Address Line | City | State | ZIP Code | County | Location | Phone | Phone Ext. | Alternate Phone | E-mail Address | 2nd Email
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Community Green
Spreadsheet: 493094d1481495750-help-adding-multiple-letters-and-getting-a-result-of-1-test
Sheet: List of Work Orders

Work Order | Description | Defects Found | Safety | Downtime | Est Lab Hrs | Actual Lab Hrs | Has Follow-up Work |  | I want it to show this
915442 | GAGE - AXLE FILL & CALIBRATION TEST TANK - FIV400405 | N | N | N | 0:30 | 0:00 | Y |  | 1
915464 | GAGE - AXLE FILL & CALIBRATION TEST TANK - FIV400405 | N | N | N | 0:30 | 0:00 | N |  | 0
915691 | GAGE - AXLE FILL & CALIBRATION TEST TANK - FIV400405 | N | N | N | 0:30 | 0:00 | N |  | 0
934826 | (ENVIRONMENTAL - CI) DIESEL ENGINE - EMERGENCY GENERATOR ANNUAL PM - CHASSIS (TRAC) | N | Y | Y | 4:00 | 0:00 | N |  | 0
946666 | (ENVIRONMENTAL - CI) DIESEL ENGINE - EMERGENCY GENERATOR ANNUAL PM - IT (TRAC) | N | Y | Y | 0:00 | 4:00 | N |  | 0
946681 | (ENVIRONMENTAL - CI) DIESEL ENGINE - FIRE PUMP ANNUAL PM (A-48) (TRAC) | Y | Y | Y | 4:00 | 4:00 | Y |  | 1
950392 | +SUBSTATION 6A - BREAKER - #6A-1 (BATT. CH.) - 480v. | N | Y | N | 4:00 | 1:00 | N |  | 0
951407 | KBK RAIL SAFETY CHECK - J1 - SECTION 3 | Y | Y | Y | 12:00 | 12:00 | N |  | 1
951408 | KBK RAIL SAFETY CHECK - J1 - SECTION 5 | Y | Y | Y | 12:00 | 12:00 | N |  | 1
951409 | KBK RAIL SAFETY CHECK - J1 - SECTION 13 | N | Y | Y | 12:00 | 12:00 | N |  | 0
951410 | KBK RAIL SAFETY CHECK - J1 - SECTION 8 | Y | Y | Y | 12:00 | 12:00 | Y |  | 1
951411 | KBK RAIL SAFETY CHECK - TRANSMISSION FILL @ M41 | N | Y | Y | 12:00 | 12:00 | Y |  | 1
952348 | COLOR BOOTH 1 ELIMINATOR CLEANING | N | N | N | 8:48 | 4:24 | N |  | 0
956750 | POU NB-1 @ (X-18) INVENTORY , AND REPLENISH WORK ORDER (FIRST SHIFT) (ANYONE) | Y | N | N | 1:00 | 0:00 | N |  | 1
956809 | POU NB-2 @ (CC-18) INVENTORY , AND REPLENISH WORK ORDER (SECOND SHIFT) (ANYONE) | N | N | N | 1:00 | 0:00 | N |  | 0
956810 | B1 B110 CLAMP FIXTURE / T95209 (EL) | Y | N | Y | 1:00 | 0:00 | Y |  | 1
 | 1)   I want to work with both columns 'C' & 'H'
 | 2)   I want a formula in column J  for each row
 | 3)   It needs to show the number 1 when a 'Y' is either in 'C', 'H' or both 'C & H'
Spreadsheet: 52068d1251778445-graph-series-values-hardware-3-year-sales-auto2
Sheet: Sheet1

year | July | August | September | October | November | December | January | February | March | April | May | June | YTD | Total Year
2007 | 400000 | 500000 | 600000 | 700000 | 800000 | 900000 | 1000000 | 1100000 | 1200000 | 1300000 | 1400000 | 1500000
2008 | 400000 | 450000 | 500000 | 550000 | 600000 | 650000 | 700000 | 750000 | 800000 | 850000 | 900000 | 950000
2009 | 500000 | 525000 | 41045.11
Spreadsheet: 824768d1680809849-sumifs-based-on-4-criteria-and-grouped-by-date-sumifs-4-criteria-grouped-by-date-3-forum
Sheet: summary

Product Number | 25
Serial Number | 23
Region Number | 26
 | Sales
 | 2022-11-12 00:00:00 | 2022-11-13 00:00:00 | 2022-11-14 00:00:00 | 2022-11-15 00:00:00 | 2022-11-16 00:00:00 | 2022-11-17 00:00:00 | 2022-11-18 00:00:00 | 2022-11-19 00:00:00 | 2022-11-20 00:00:00 | 2022-11-21 00:00:00
Customer1
Customer2
Customer3
Put sales sum based on yellow criteria
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-063

 |  |  |  |  |  |  |  | 9-063
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 15acff35-e1ba-49dd-9631-d012145cb323
Sheet: Co-located Role - Planner

 | Co-located Cache Capacity Planner
 | Input: Cluster Configuration
 | VM Size | M | VM
 | Number of VM Instances | 3 | VM
 | User Data to be stored in Cache | 1500 | MB
 | High Availability Enabled | No | Yes/No
 | Output: Feasiblity & Settings
 | Is it feasible to host Cache in this cluster
 | Cache Size % (Memory required for Cache) |  | % per VM
Spreadsheet: 489315d1479209270-excel-report-from-multiple-excel-files-qrn-275-and-276
Sheet: Cable Information

Standards & Custom Pass/Fail Status
 | Custom Pass/Fail Thresholds
Identification Information
Test date: |  | 14-Nov-16
Test time: |  | 1:04 PM (GMT+03:00)
Job ID:
Customer: |  | MOC
Company: |  | Huawei
Comments:
Identification
Cable ID |  | QRN FC 12
Fiber ID |  | 275; 276
Location A
Location B
None
Location A |  |  |  |  |  |  |  | Location B
Operator: |  | devender |  |  |  |  |  | Operator:
Unit model: |  | FTB-735C-SM4-EA |  |  |  |  |  | Unit model: |  | FTB-735C-SM4-EA
Unit s/n: |  | 923275 |  |  |  |  |  | Unit s/n: |  | 923275