tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768059d1644821230-tables-referencing-main-table-cant-use-sort-tabels
Sheet: SKLADIŠČE

 | SKLADIŠČE
 |  |  |  | STRANKA:
 |  |  |  | Risba št.: |  |  |  | KOSOV:
 |  |  |  | Ime :
IME | POZ. | DEB. | ŠIRINA | DOLŽINA | KOS. | Material | OPOMBA | [NAME] | N.TEŽA | LIST
 |  |  |  |  |  | [NAME] | SKUPAJ:
Spreadsheet: 105542d1302861778-how-to-work-out-a-time-formula-to-ignore-certain-information-monthly-register-v3
Sheet: APRIL

MONTH: |  |  | APRIL
DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS |  | DATE |  | NAME | START 1 | FINISH 1 | START 2 | FINISH 2 | HRS PER PERSON | DAILY HOURS
FRI | 1 |  |  |  |  |  |  |  |  | WED | 13 |  |  |  |  |  |  |  |  | MON | 25
SAT | 2 |  |  |  |  |  |  |  |  | THU | 14 |  |  |  |  |  |  |  |  | TUE | 26
SUN | 3 |  |  |  |  |  |  |  |  | FRI | 15 |  |  |  |  |  |  |  |  | WED | 27
MON | 4 |  |  |  |  |  |  |  |  | SAT | 16 |  |  |  |  |  |  |  |  | THU | 28
TUE | 5 |  |  |  |  |  |  |  |  | SUN | 17 |  |  |  |  |  |  |  |  | FRI | 29
WED | 6 |  |  |  |  |  |  |  |  | MON | 18 |  |  |  |  |  |  |  |  | SAT | 30
THU | 7 |  |  |  |  |  |  |  |  | TUE | 19
FRI | 8 |  |  |  |  |  |  |  |  | WED | 20
SAT | 9 |  |  |  |  |  |  |  |  | THU | 21
SUN | 10 |  |  |  |  |  |  |  |  | FRI | 22
MON | 11 |  |  |  |  |  |  |  |  | SAT | 23
TUE | 12 |  |  |  |  |  |  |  |  | SUN | 24
Spreadsheet: 711127d1609451296-most-current-date-in-a-row-dates
Sheet: Test Revisions (2)

Location | AOR | HL Received LL Comments | AOR Received LL Comments | LL Comments Completed And Sent To HL | # of Days | (H) [NAME]) AHJ-(L)LL | Plans to HL | Submited To City (Permit) | Comments or Approved | Received Back From AHJ | # of Days | Rev# | (H) [NAME]) AHJ-(L)LL | Plans Submitted to HL | Date Submitted to AHJ | Comments or Approved | Received Back From AHJ | # of Days | Rev# | (H) [NAME]) AHJ-(L)LL | Plans Submitted to HL | Date Submitted to AHJ | Comments or Approved | Received Back From AHJ | # of Days | Rev# | (H) [NAME]) AHJ-(L)LL | Plans Submitted to HL | Date Submitted to AHJ | Comments or Approved | Received Back From AHJ | # of Days | Rev# | (H) [NAME]) AHJ-(L)LL | Plans Submitted to HL | Date Submitted to AHJ | Comments or Approved | Received Back From AHJ | # of Days
[NAME] , FL Exterior | pb2 | 2020-10-13 00:00:00 |  | 2020-10-13 00:00:00 |  | H-A-L | 2020-06-25 00:00:00 | 2020-06-25 00:00:00 |  |  |  | 1 | H-A | 2020-10-06 00:00:00 | 2020-10-06 00:00:00 |  | 2020-12-30 00:00:00 |  | 2 | H-A-L | 2020-12-03 00:00:00 | 2020-12-03 00:00:00
[NAME] , FL Interior | pb2 | 2020-10-13 00:00:00 |  | 2020-10-13 00:00:00 |  | H-A-L | 2019-04-05 00:00:00 | 2019-04-05 00:00:00 |  |  |  | 1 | H-A | 2020-01-03 00:00:00 | 2020-01-03 00:00:00 |  |  |  | 2 | H-A-L | 2020-03-24 00:00:00 | 2020-03-24 00:00:00
Spreadsheet: 776907d1649970751-mfg-capacity-allocation-challenge-capacity-model-sample-041422-r4
Sheet: Sheet2

HOURS TO COMPPLETE | MECH HOURS | MECH [NAME] | 2022-03-21 00:00:00 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | 2022-03-24 00:00:00 | 2022-03-25 00:00:00 | 2022-03-26 00:00:00 | 2022-03-27 00:00:00 | 2022-03-28 00:00:00
192 | 38.40000000000001 | 2022-03-23 00:00:00 | 0 | 0 | 38.40000000000001 | 0 | 0 | 0 | 0 | 0
288 | 57.6 | 2022-03-23 00:00:00 | 0 | 0 | 57.6 | 0 | 0 | 0 | 0 | 0
48 | 9.600000000000001 | 2022-03-24 00:00:00 | 0 | 0 | 0 | 9.600000000000001 | 0 | 0 | 0 | 0
48 | 9.600000000000001 | 2022-03-25 00:00:00 | 0 | 0 | 0 | 0 | 9.600000000000001 | 0 | 0 | 0
 |  | Need to spread hours such that no cel in the AE10 to AL13 exceeds the value in cell AD2 (daily capacity hrs).
 |  | Example:
 |  | Cell AG10 shows |  |  | 38.4 |  |  |  |  |  | 38.4
 |  | desired result |  |  | 8 | 8 | 8 | 8 | 6.4 |  | 38.4
Spreadsheet: benjamin_rogers__1068__gencomodel
Sheet: Base Revenue

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual | Fuel | Annual | VOM | Annual | SO2 | Annual | NOx | Annual
 | Bucket 1 | Bucket 2 | Bucket 3 | Bucket 4 | Bucket 5 | Bucket 6 | Bucket 7 | Bucket 8 | Bucket 9 | Bucket 10 | Bucket 11 | Bucket 12 | Bucket 13 | Bucket 14 | Bucket 15 | Bucket 16 | Bucket 17 | Bucket 18 | Bucket 19 | Bucket 20 | Monthly Total | Second Call | First Call | Revenue | Cost | Fuel | Cost | VOM | Cost | SO2 | Cost | NOx
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue | Revenue
2000-01-15 00:00:00
Spreadsheet: 57870d1258072385-cell-references-between-sheets-sample-spreadsheet-august-09
Sheet: ALL

PRIORITY (1-3) | ASSIGNED TO | UTlLITY | STATUS | JOB TITLE
1 | BB | G | A | -        Complile Walterville chevron notes from 2006 & ?
2 | BB | G | C | Shoot Chevron drops [NAME] request low H20 near end of summer+topo Lisa/Cheri
3 | BB | E | C | -        Pin RP Timberline/Timberline for Vlt retaining wall/[NAME], done, wait til job over (July 09)
1 | BB | E | C | -        Rewrite Triangle 5/Millican easement – description to [NAME]
1 | RCH | E | H | -        Boundary survey 1920/1930 Augusta (June 09)
1 | RCH | E | A | -        File Westec Drive Survey (July 09)
2 | RCH | G | C | -        Stake entrance to boat ramp for Marcus Lynch to relocate a power pole.  (June 09)
3 | RCH | G | A | -        Bndry survey/lot line adj. btwn. EWEB house and neighbor for well/Mck. Bridge (July 09)
2 | RCH | G | A | -        Continue support for radio twr. Sites, Spring 09 add final control for consultants
1 | UNASSIGNED | W | C | New Laurel Hill Reservoir File and survey
2 | UNASSIGNED | W | A | [NAME]. 975 property line adjustment (neighbor to hire work done, work with [NAME] to define EWEB needs)
2 | UNASSIGNED |  |  | Check misc pin RPs
1 | UNASSIGNED | O |  | Stay up to date with any requests from Property management section
Spreadsheet: 845941d1697223479-slider-to-adjust-the-values-in-a-pivot-table-to-a-hypothetical-what-if-scenario-test
Sheet: Sheet1

TYPES | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Type 1 | 210 |  |  |  |  |  |  | 210 |  |  |  | 7.777777777777778
Type 2 | 69 |  |  |  |  |  |  | 69 |  |  |  | 75
Type 3 | 343 |  |  |  |  |  |  | 343 |  |  |  | 343
Type 4 | 13 |  |  |  |  |  |  | 13 |  |  |  | 387283
Type 5 | 1 |  |  |  |  |  |  | 1 |  |  |  | 601
Type 6 | 4984 |  |  |  |  |  |  | 4984 |  |  |  | 3814
Type 7 | 31 |  |  |  |  |  |  | 31 |  |  |  | 104.625
Type 8 | 64968 |  |  |  |  |  |  | 64968 |  |  |  | 47361.67200000001
Type 9 | 94 |  |  |  |  |  |  | 94 |  |  |  | 139
Type 10 | 16 |  |  |  |  |  |  | 16 |  |  |  | 10
Spreadsheet: 693505d1598995234-sum-if-multiple-criteria-sum-if-formula-help
Sheet: Sheet1

[NAME] | Values | Control | Test |  |  |  | Test | Control | %Control | % Test | CONTROL TOTAL | TEST TOTAL
Affinity | Dislike itDislike it | 6 | 5 |  |  | Affinity |  |  |  |  | 156 | 304
Affinity | Hate itHate it | 1 |  |  |  | Consideration
Affinity | Like itLike it | 65 | 132 |  |  | CTA
Affinity | Love itLove it | 59 | 126
Affinity | NeutralNeutral | 25 | 41
Consideration | Somewhat likely | 59 | 90
Consideration | Very likely | 77 | 153
CTA | Somewhat likely | 71 | 108
CTA | Very likely | 52 | 153
Spreadsheet: 01ab682b-73b2-451b-a271-5a688c0a555e
Sheet: Sheet1

Release: Annual Estimates of the Population of Metropolitan and Micropolitan Statistical Areas | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=111
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-23 11:59 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population of Metropolitan and Micropolitan | 2005-06-07 00:00:00 | Current
Statistical Areas
Link:
http://www.census.gov/popest/ | 2005-06-07 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2005-06-07 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2005-06-07 00:00:00
2006-01-19 00:00:00
2006-08-21 00:00:00
2006-09-14 00:00:00
2007-04-05 00:00:00
2008-03-27 00:00:00
2009-03-19 00:00:00
2010-03-25 00:00:00
2012-04-05 00:00:00
2013-03-27 00:00:00
2014-06-20 00:00:00
Spreadsheet: 165548d1341261709-sorting-a-class-schedule-class-schedule
Sheet: Sheet2

Name | Hour 1 | Hour 2 | Hour 3 | Hour 4 | Hour 5 | Hour 6 | Hour 7
Student 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Student 2 | 7 | 1 | 2 | 3 | 4 | 5 | 6
Student 3 | 6 | 7 | 1 | 2 | 3 | 4 | 5
Student 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4
Student 5 | 4 | 5 | 6 | 7 | 1 | 2 | 3
Student 6 | 3 | 4 | 5 | 6 | 7 | 1 | 2
Student 7 | 2 | 3 | 4 | 5 | 6 | 7 | 1
Student 8 | 3 | 6 | 4 | 2 | 1 | 7 | 5
Student 9 | 5 | 3 | 6 | 4 | 2 | 1 | 7
Student 10 | 7 | 5 | 3 | 6 | 4 | 2 | 1
Student 11 | 1 | 7 | 5 | 3 | 6 | 4 | 2
Student 12 | 2 | 1 | 7 | 5 | 3 | 6 | 4
Student 13 | 4 | 2 | 1 | 7 | 5 | 3 | 6
Student 14 | 6 | 4 | 2 | 1 | 7 | 5 | 3
Student 15 | 6 | 4 | 2 | 7 | 5 | 3 | 1
Student 16 | 1 | 6 | 4 | 2 | 7 | 5 | 3
Student 17 | 3 | 1 | 6 | 4 | 2 | 7 | 5
Student 18 | 5 | 3 | 1 | 6 | 4 | 2 | 7
Student 19 | 7 | 5 | 3 | 1 | 6 | 4 | 2
Student 20 | 2 | 7 | 5 | 3 | 1 | 6 | 4
Student 21 | 4 | 2 | 7 | 5 | 3 | 1 | 6
Student 22 | 4 | 2 | 3 | 5 | 6 | 1 | 7
Student 23 | 7 | 4 | 2 | 3 | 5 | 6 | 1
Student 24 | 1 | 7 | 4 | 2 | 3 | 5 | 6
Student 25 | 6 | 1 | 7 | 4 | 2 | 3 | 5
Student 26 | 5 | 6 | 1 | 7 | 4 | 2 | 3
Student 27 | 3 | 5 | 6 | 1 | 7 | 4 | 2
Student 28 | 2 | 3 | 5 | 6 | 1 | 7 | 4
Student 29 | 2 | 1 | 3 | 6 | 7 | 4 | 5
Student 30 | 5 | 2 | 1 | 3 | 6 | 7 | 4
Student 31 | 4 | 5 | 2 | 1 | 3 | 6 | 7
Student 32 | 7 | 4 | 5 | 2 | 1 | 3 | 6
Student 33 | 6 | 7 | 4 | 5 | 2 | 1 | 3
Student 34 | 3 | 6 | 7 | 4 | 5 | 2 | 1
Student 35 | 1 | 3 | 6 | 7 | 4 | 5 | 2
Spreadsheet: 809491d1671116147-ranking-formular-rank333
Sheet: ASILIMIA UFAULU KISHULE

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA MUHULA WA PILI DARASA LA TATU, NOVEMBA 2022
D. NAFASI YA SHULE KWA ASILIMIA [NAME] MWANAFUNZI
NA | SHULE | KATA | WALIOFANYA |  |  | WALIOFAULU |  |  | A |  |  | B |  |  | C |  |  | % [NAME] | WASTANI WA ALAMA | D |  |  | E |  |  | % YA WALIOFELI | [NAME] SHULE
 |  |  | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML | WAV | WAS | JML |  |  | WAV | WAS | JML | WAV | WAS | JML
1 | KALOLENI
2 | SHEKINA |  | 4 | 2 | 6 | 4 | 2 | 6 | 4 | 2 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 288 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 837826d1690454125-create-unique-combinations-example
Sheet: Sheet1

 |  |  |  |  |  |  | Merged
 |  |  |  |  |  |  | AAA 1 |  | Product - Campaign Combo (For every product, create unique combinations based on Classification)
 | Campaign | Classification |  | Product | Classification |  | AAA 5 |  | Product | Campaign | Combo
 | 1 | Apple |  | AAA | Apple |  | DDD 1 |  | AAA | 1
 | 2 | Orange |  | BBB | [NAME] |  | DDD 5 |  | AAA | 5
 | 3 | Orange |  | CCC | Tomato |  | BBB 4 |  | BBB | 4
 | 4 | [NAME] |  | DDD | Apple |  | EEE 2 |  | CCC | 6
 | 5 | Apple |  | EEE | Orange |  | EEE 3 |  | DDD | 1
 | 6 | Tomato |  |  |  |  | CCC 6 |  | DDD | 5
 | 7 | Orange |  |  |  |  | EEE 7 |  | EEE | 2
 |  |  |  |  |  |  |  |  | EEE | 3
 |  |  |  |  |  |  |  |  | EEE | 7
Spreadsheet: b571a109-8ca6-4d26-9146-383bf5ec6095
Sheet: Sheet1

Function Annotation | p-value | # Molecules | Molecules
differentiation of astrocytes | 2.39e-06 | 5 | BMP2, DLL3, NOG, OLIG2, SOX6
generation of neurons | 4.49e-05 | 4 | HEY2, NOG, OLIG1, OLIG2
neurogenesis | 4.83e-05 | 12 | BMP2, BMPR1A, DLL3, DSCAM, EPHB1, HEY2, MYCN, NOG, NTRK2, OLIG1, OLIG2, RP11-35N6.1
contact growth inhibition | 9.95e-05 | 6 | BMP2, BMPR1A, CAMK2A, IFI16, LATS2, MYCN
cell death | 0.000272 | 32 | ADCYAP1R1, ALCAM, BID, BMP2, BMPR1A, CALCRL, CAMK2A, CDHR1, CFH, [NAME], ENO1, ETS1, GRIA4, GRIK2, HSPB6, IFI16, KCNIP1, LAMP2, LATS2, [NAME], MYC, MYCN, NOG, NTRK2, RASL10A, RASSF4, RGN, SOX6, TFAP2A, TNFRSF21, [NAME], ZEB1
development of blood vessel | 0.000815 | 10 | BMP2, BMPR1A, CHD7, [NAME], [NAME], ETS1, HEY2, MYC, NOG, NTRK2
benign tumor | 0.00115 | 11 | ADCYAP1R1, ALCAM, CALCRL, CFH, [NAME], MN1, MTHFD2, MYC, NTRK2, RAP2B, ZEB1
Spreadsheet: sally_beck__33698__MgmtSum-Q2-0609
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON NORTH AMERICA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
TOT_ALLOCATION | 2ND QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-06-01 00:00:00
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
[NAME] | Gas Trading |  | 0
ASST_TRD | Texas Desk
[NAME] | Power Trading |  |  |  |  | Entire cap charge number in DPR
IR_FX | Financial Drift
ECT_INV_IRFX | Financial Trading
CANADA | Canada Trading |  | 0 | 0
COAL | Coal-Trading |  | 0 | 0 |  |  |  |  |  | 1127
WEATHER | GRM -  Weather |  |  |  |  |  |  |  |  | 919
SO2 | Emissions
 | Total Trading & Risk Mgmt
E_ORG | East Midstream
W_ORIG | West Midstream |  | 938 |  |  | Big Horn, Cactus
DWNSTRM_IND_ORIG | Industrial Downstream |  |  |  |  | Merlin (City Forest, Oconto Falls) |  |  |  | 2620
N_BS_DEV | Generation Investments |  | 6038
 | Coal Origination & Finance |  | 639 | 717 |  |  |  |  |  | 1127 | 814
 | Canada Origination & Finance |  | 165 | 376 |  |  |  |  |  |  | 1195
ASST_ORIG | ENA Upstream Assets |  | 12003
INSURANCE | GRM - New Products |  | -510 |  |  |  |  |  |  | 418
MEXICO | Mexico
 | Total Origination
EQUITY | Principal Investing |  | 655 |  |  | Condor (Quanta)
PROD_FIN | Energy Capital Resources |  | 2495 |  |  | Merlin (HV Marine, LSI, Ridgelake)
ASST_MGT_AND_RESTRCT | Special Assets
CTG_ASSETS | CTG Assets |  | 5042
 | CTG Assets
 | Total Investing
CTG | Commercial Transactions Group
OF_CHAIR | Office of the Chairman |  |  |  |  |  |  |  |  | 4286
 | Capital Charge Offset
 | Total Commercial
GROUP | Group
 | Enron Net Works |  | 0 | 0 | 0 |  |  |  |  | -13343 | -13343
 | Total
Spreadsheet: 585743d1533921591-correcting-bad-addresses-in-an-excel-list-mailing-list-part-i-rel
Sheet: Sheet1

 | 1 |  | 1
 | 2 |  | 3
 | 3 |  | 5
 | 4 |  | 7
 | 5 |  | 9
 | 6 |  | 11
 | 7 |  | 13
 | 8 |  | 15
 | 9 |  | 17
 | 10 |  | 19
 | 11 |  | 21
 | 12 |  | 23
 | 13 |  | 25
 | 14 |  | 27
 | 15 |  | 29
 | 16 |  | 31
 | 17 |  | 33
 | 18 |  | 35
 | 19 |  | 37
 | 20 |  | 39
Spreadsheet: 213796d1360659978-using-combo-box-to-show-monthly-variable-data-test
Sheet: Sheet2

 | Jan Data |  |  |  |  | TL Name:
 |  | Advisor | CM | NTU | Fees | Own Access | Incentives | Refunds | Variances | Observations | Audit | Security | Folders |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All
 |  |  |  | Crits & Customer |  | EOD & Verbal |  | Advisor Errors
 |  | Calls | AS | Cust Contact | Advisor Feedback | EOD % logged | Logging & Outstandimg | Number of AE | Knowledge | Briefs
Spreadsheet: 196523d1354031233-sumproduct-problem-combined-with-filtering-sumproductissue
Sheet: Sheet1

Need to Filter
on range and get sumproduct total here
 |  |  | Price | Units
 |  | Range 2 | 43400
 | B | C | D | E
 | Range 1 | Item1 | 6 | 500
 | Range 1 | Item 2 | 59 | 100
 | Range 1 | Item 3 | 6 | 800
 | Range 1 | Item 4 | 5 | 100
 | Range 1 | Item 5 | 6 | 500
 | Range 1 | Item 6 | 5 | 1000
 | Range 2 | Item 1 | 59 | 500
 | Range 2 | Item 2 | 6 | 100
 | Range 2 | Item 3 | 6 | 800
 | Range 2 | Item 4 | 5 | 100
 | Range 2 | Item 5 | 6 | 500
 | Range 2 | Item 6 | 5 | 1000
Spreadsheet: 826398d1681987625-automatic-color-from-date-warranty-color
Sheet: Sheet1

Server | Purchased | Warranty
Test1 | 2021-08-12 00:00:00
Test2 | 2020-03-02 00:00:00 |  |  |  |  | More than 5 years
Test3 | 2019-06-08 00:00:00 |  |  |  |  | Between 4 and 5 years
Test4 | 2017-07-21 00:00:00 |  |  |  |  | less than 4 years
Test5 | 2012-05-23 00:00:00
Test6 | 2015-03-14 00:00:00
[NAME] | 2019-01-01 00:00:00
 | Cell C1 should be the colour GREEN if the date in B1 is more than 5 years, or YELLOW if it the date in B1 is between 4 and 5 years or green if it is less than 4 years
 | =IF(B1<TODAY()-1825,"GREEN",IF(B1<=TODAY()-1460,"YELLOW","GREEN"))
 | =IF(TODAY()-A1>=(365*5), "RED", "GREEN")
Spreadsheet: 170795d1343408923-route-planning-route_example
Sheet: Ark1

 | MONDAY
 | INPUT THE ACTUAL SHOPS GETTING DELIVERIES |  |  |  |  | NORTH | WEST | EAST | SOUTH | SOUTH #2
 | Shop 1 |  |  |  |  | Shop 5 | Shop 1 | Shop 3 | Shop 8 | n/a
 | Shop 2 |  |  |  |  | Shop 4 | Shop 9 | Shop 7 | Shop 10
 | Shop 3 |  |  |  |  | Shop 6 | Shop 2
 | Shop 4
 | Shop 5
 | Shop 6
 | Shop 7
 | Shop 8
 | Shop 9
 | Shop 10
 | TUESDAY
 | INPUT THE ACTUAL SHOPS GETTING DELIVERIES |  |  |  |  | NORTH | WEST | EAST | SOUTH | SOUTH #2
 | Shop 3 |  |  |  |  | Shop 5 | n/a | Shop 3 | Shop 8 | Shop 13
 | Shop 5 |  |  |  |  | Shop 6 |  | Shop 7 | Shop 10 | Shop 11
 | Shop 6 |  |  |  |  | Shop 12 |  | Shop 15
 | Shop 7
 | Shop 8
 | Shop 10
 | Shop 11
 | Shop 12
 | Shop 13
 | Shop 15
Spreadsheet: 716972d1612439912-link-data-across-tabs-capacity-plan-option-2-1-2-final
Sheet: Confirmed MV

 | Resource Working Days Overview |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  |  |  | 2 |  |  |  | Year |  |  | 2021
 | Resource Groups
 | MTCSS 1
 | MTCSS 2
 | CONTRACT 1
 | CONTRACT 2
 | CONTRACT 3
 | CONTRACT 4
 | SPRAY 1
 | SPRAY 2
Spreadsheet: 98589d1297442234-interpolating-values-from-graph-interpolation
Sheet: Sheet1

6 | 0.02661464155312751
13 | 0.04484544361147888
20 | 0.07110034331758838
27 | 0.06534108526171568
34 | 0.07626802776332205
41 | 0.07752878228552613
48 | 0.07366893298000443
55 | 0.08388156358673608
62 | 0.08925351725572947
69 | 0.1042645017884926
76 | 0.1047021103169578
83 | 0.109953503796897
90 | 0.1102754079092497
97 | 0.1179222555202736
104 | 0.1181769455176341
111 | 0.1208668052306281
118 | 0.1358952544873072
125 | 0.1360955997365683
132 | 0.1362748940899556
139 | 0.1413989745773557 |  |  |  |  |  |  | X1 | X2 | xDiff | x1 to X | Interp
146 | 0.1365824416220743 |  |  |  | enter X value | 70
153 | 0.1367153652534069 |  |  |  | y value from interpolation |  |  | y1 | y2 | yDiff
160 | 0.1368368213221456
167 | 0.1419298055702297
174 | 0.1520072888005675 |  |  |  | Put a number in X Value and press Enter
181 | 0.1571019253611926
195 | 0.1622925591605711
223 | 0.1676275362968882
251 | 0.1829381729165283
279 | 0.1982400265447825
307 | 0.223595934321421
335 | 0.2540102053484257
363 | 0.2844584608525369
Spreadsheet: 848549d1699280877-data-validation-dynamic-list-test2
Sheet: Blad1

Name | Color |  | Ellen | [NAME] | Mitch | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  |  | Yellow | Red | [NAME] | Orange | Yellow | Blue | Pink
[NAME] | Blue |  | Green | Green | Orange | Pink | Blue | Orange | Yellow
[NAME] |  |  |  | Blue | Orange | Blue | Pink |  | Blue
 |  |  |  | Pink | Blue
Spreadsheet: 31b00023-7f9c-493b-8dcc-c99070055c18
Sheet: Sheet1

Table 3--U.S. fiber supply | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Feb. | Mar. | Apr. | Apr.
Item | 2012 | 2012 | 2012 | 2011
 | 1,000 480-lb. [NAME]
Cotton:
Ginnings | 375 | 0 | 0 | 0
Imports since August 1 | 9.8 | 11.3 |  | 4.8
Stocks, beginning | 11943 | 10633 | 8720 | 8359
At mills |  |  |  | 158
Public storage |  |  |  | 6254
CCC stocks | 3744 | 3016 | 2392 | 2704
 | Million pounds
Manmade:
Production | 518.2 | 544.7 | 535.9 | 539.5
Noncellulosic | 518.2 | 544.7 | 535.9 | 539.5
Cellulosic
Total since January 1 | 993.1 | 1477.8 | 2013.7 | 2110.2
 | Jan. | Feb. | Mar. | Mar.
 | 2012 | 2012 | 2012 | 2011
 | Million pounds
Raw fiber imports: | 148.5 | 140.1 | 161.9 | 153.2
Noncellulosic | 133.4 | 127.1 | 144.8 | 137.7
Cellulosic | 15.1 | 13 | 17.1 | 15.5
Total since January 1 | 148.5 | 288.6 | 450.5 | 415.8
 | 1,000 pounds
Wool and mohair:
Raw wool imports, clean | 711.7 | 968.1 | 1018.9 | 564.5
48s-and-finer | 247.1 | 462.1 | 333.5 | 362.2
Not-finer-than-46s | 464.6 | 506 | 685.4 | 202.3
Total since January 1 | 711.7 | 1679.7 | 2698.6 | 1872.8
Wool top imports | 376.2 | 268.1 | 243.3 | 355.4
Total since January 1 | 376.2 | 644.3 | 887.6 | 1047.9
Mohair imports, clean | 0 | 0 | 0 | 0
Total since January 1 | 0 | 0 | 0 | 2.3
NA = Not available.
Last update:  06/13/12.
Sources: USDA, National Agricultural Statistics Service; USDC,
U.S. Census Bureau; and [NAME].
Spreadsheet: benjamin_rogers__1254__Merchanr Peaker CSFB Comps_DCF1
Sheet: DCF Exit Year 2 - $6

DCF Analysis
Consolidated UFCF - $6/kW-month
 |  |  |  | CONTRACT PERIOD
 |  |  |  | 2001 | 2002 | 2003
EBITDA |  |  |  | 193.6809336759508 | 193.097064143352 | 177.8113210162394
 | % Annual Growth |  |  |  | -0.003014594784924274 | -0.002867516193575503
Depreciation |  |  |  | 44.22506419986609 | 44.22506419986609 | 44.22506419986609
EBIT |  |  |  | 149.4558694760847 | 148.8719999434859 | 133.5862568163733
Taxes on EBIT |  |  | 0.387 | -57.86635189958819 | -57.64028918318068 | -51.69733668921432
Unlevered Net Income |  |  |  | 91.58951757649652 | 91.23171076030523 | 81.888920127159
Plus:  Depreciation |  |  |  | 44.22506419986609 | 44.22506419986609 | 44.22506419986609
Plus:  Deferred Income Taxes |  |  |  | 28.93505545832036 | 47.38350150024837 | 41.73707264291678
Plus:  WC Adjustments (Property Taxes) |  |  |  | 0.1795618985999997 | 0.3466470000000004 | 0.1900860000000002
Unlevered Free Cash Flow |  |  |  | 164.929199133283 | 183.1869234604197 | 168.0411429699419
 | % Annual Growth |  |  |  | 0.1107003758163057 | -0.001520431084348961
Valuation Matrix
 |  |  | $ CAPITAL COST / kW
 | DISCOUNT RATE |  | 400 |  | 410 |  | 420 |  | 430
 | 0.095 |  |  |  |  |  |  |  |  |  | PV of 2001-2002 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  | PV of 2001-2002 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  | PV of 2001-2002 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
 |  |  |  |  |  |  |  |  |  |  | PV of 2001-2002 UFCF
 |  |  |  |  |  |  |  |  |  |  | PV of Terminal Value
 |  |  |  |  |  |  |  |  |  |  | Enterprise Value
Spreadsheet: 887745d1738070519-longer-text-to-be-returned-from-a-match-with-a-shorter-text-problem
Sheet: Sheet1

Text 1 | Text 2 | Desired outcome
TextABC1.ccooocs | TextABC6 | TextABC1.ccooocs
TextABC2.ccooosfd | TextABC2 | TextABC2.ccooosfd
TextABC3.ccooofgds | TextABC1
TextABC4.ccooo | TextABC4 | TextABC4.ccooo
TextABC5.ccooofg | TextABC5 | TextABC5.ccooofg
TextABC6.ccooo |  | TextABC6.ccooo
TextABC7.ccooo
TextABC8.ccooo
TextABC9.ccooo