tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 17f67227-444f-4fd5-a658-76cb5b88fa1a
Sheet: Sheet1

CITY NATIONAL CORP | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
144
[NAME]
NO TITLE
UNITED STATES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMB APPROVAL
SECURITIES AND EXCHANGE COMMISSION
Washington, D.C. 20549
FORM 144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMB Number: 3235-0101
NOTICE OF PROPOSED SALE OF SECURITIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expires: February 28, 2014
PURSUANT TO RULE 144 UNDER THE SECURITIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Estimated average burden
ACT OF 1933 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hours per response . . . 1.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEC USE ONLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOCUMENT SEQUENCE NO.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CUSIP NUMBER
ATTENTION: |  | Transmit for filing 3 copies of this form
 |  | concurrently with either placing an order
 |  | with a broker to execute sale or executing
 |  | a sale directly with a market maker.
1 (a) NAME OF ISSUER (Please type or print) |  |  |  |  |  | (b) IRS IDENT. NO. |  |  |  | (c) S.E.C. FILE NO. |  |  |  |  | WORK LOCATION
CITY NATIONAL CORPORATION |  |  |  |  |  | 95-2568550 |  |  |  | 001-10521
1 (d) | ADDRESS OF ISSUER |  | STREET |  |  |  |  | CITY |  |  |  | STATE | ZIP CODE |  | (e) TELEPHONE NO.
 |  |  | 555 SOUTH FLOWER STREET |  |  |  |  | LOS ANGELES |  |  |  | CA | 90071 |  | AREA |  | NUMBER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 213 |  | 673-7700
2 (a) | NAME OF PERSON FOR WHOSE ACCOUNT THE SECURITIES |  |  |  | (b) |  | RELATIONSHIP TO ISSUER |  | (c) |  | ADDRESS STREET |  |  | CITY |  | STATE |  | ZIP CODE
 | ARE TO BE SOLD
[NAME] |  |  |  |  | CHAIRMAN OF THE BOARD, CEO AND PRESIDENT |  |  |  | 400 NORTH ROXBURY DRIVE |  |  |  |  | BEVERLY HILLS |  | CA |  | 90210
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 706093d1606466407-subtract-if-text-match-example-1-
Sheet: Sheet1

 | MAY
ROOM TYPE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
PREMIUM MAISONNETTE SEA VIEW/3 BEDROOMS & PRIVATE POOL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 13 | PANORAMIC DOUBLE SEA VIEW
PANORAMIC DOUBLE SEA VIEW | 0 | 8 | 0 | 0 | 0 | 13 | 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 |  |  | 4 | SUPERIOR SEA VIEW
HONEYMOON SUITE SEA VIEW PRIVATE POOL | 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 | 0 |  |  | 3 | COCOON ROOM SEA VIEW WITH POOL
 | 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 | 0 |  |  | 5 | DELUXE SEA VIEW SHARING POOL
 | 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 | 0 |  |  | 15 | DELUXE SEA VIEW CHILL OUT POOL
 | 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 | 0 |  |  | 8 | JUNIOR SUITE SEA VIEW
 | 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 | 0 |  |  | 2 | HONEYMOON SUITE SEA VIEW PRIVATE POOL
 | 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 | 0 |  |  | 3 | PRESTIGE SUITE SEA VIEW
 | 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 | 0 |  |  | 6 | PRESTIGE SUITE SEA VIEW PRIVATE POOL
 | 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 | 0 |  |  | 1 | PREMIUM MAISONNETTE SEA VIEW/2 BEDROOMS & PRIVATE POOL
 | 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 | 0 |  |  | 1 | PREMIUM MAISONNETTE SEA VIEW/3 BEDROOMS & PRIVATE POOL
TOTAL | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AVAILABLE ROOMS
PANORAMIC DOUBLE SEA VIEW
HONEYMOON SUITE SEA VIEW PRIVATE POOL
PREMIUM MAISONNETTE SEA VIEW/3 BEDROOMS & PRIVATE POOL
Spreadsheet: 103235d1301000021-compare-two-data-tables-excel-help
Sheet: Data Source

SKU | Inventory Level | Exists ?
APL2-IPAD2-20-E4OTR | Pre-Order. |  |  |  | Legend
16-001 | Pre-Order. |  |  |  | in stock | in stock, pre order, out of stock on order, special order.
16-002 | Pre-Order. |  |  |  | out of stock | out of stock
16-008 | Pre-Order.
16-007 | Pre-Order.
16-006 | Pre-Order.
16-005 | Pre-Order.
16-004 | Pre-Order.
16-003 | Pre-Order.
iCC2010FLO | In stock.
iCC2010PNK | In stock.
iCC2010GRN | In stock.
iCC2010ORG | In stock.
iCC2010BGE | In stock.
iCC2010BLU | In stock.
NL-HAI2-0311 | Pre-Order.
BZ-ACFI2-0311 | In stock.
NL-BAI2-0311F | In stock.
NL-BAI2-0311 | In stock.
FPD2P | In stock.
FPD2AG | Pre-Order.
FPD2UC | Pre-Order.
IPD2CFW | Pre-Order.
[NAME] | Pre-Order.
IPD2FLBK | Pre-Order.
IPD2PCPU | Pre-Order.
IPD2PCBK | Pre-Order.
IPD2PC | Out of Stock.
IPD2TPUP | In stock.
IPD2TPUPU | In stock.
IPD2TPUBK | Pre-Order.
IPD2TPUC | In stock.
17121 | Pre-Order.
17114 | Pre-Order.
17107 | Pre-Order.
17091 | Pre-Order.
17053 | Pre-Order.
17046 | Pre-Order.
IPDA-0001 | Pre-Order.
602956008606 | Pre-Order.
602956008590 | Pre-Order.
602956008569 | Pre-Order.
602956008583 | Pre-Order.
602956008576 | Pre-Order.
602956008552 | Pre-Order.
602956008545 | Pre-Order.
602956008538 | Pre-Order.
602956007722 | Pre-Order.
iPad1 | In stock.
iPad0 | In stock.
APL8-IPAD1-20-E4OTR | Out of Stock. On order.
AP-818RE | Out of Stock. On order.
AP-818BK | Out of Stock. On order.
AP-818GR | Out of Stock. On order.
AP-818BL | Out of Stock. On order.
AP-818GD | Out of Stock. On order.
AP-818 | Out of Stock. On order.
PENPAL | Out of Stock.
ST-858 | In stock. On order.
ST-828 | In stock.
ST-818 | In stock. On order.
IPAD-RECLINER | In stock.
SPTBLK | In stock.
SPTGRA | In stock.
15325 | In stock.
15318 | In stock.
15301 | In stock.
IBOG-BL | In stock.
IBOG-GR | In stock.
IBOG-BK | In stock.
AIRPOUCH | Special Order.
BSKXS-BLR | In stock.
SUMO-IPADSG1 | In stock.
SUMO-IPADSC1 | In stock.
15295 | In stock.
15288 | Pre-Order.
15271 | Pre-Order.
IPAD-141 | In stock.
BTKEYMINI | In stock.
USBC3 | Out of Stock.
TSLXS-BLK | Out of Stock.
IPA2-SP-2C | In stock. On order.
iCC1193 | Pre-Order. On order.
iCC1194 | In stock.
iCC2011PNK | In stock.
[NAME] | In stock. On order.
iCC818BLU | Pre-Order.
iCC818PNK | Out of Stock.
iCC818WHT | Out of Stock.
iCC818GRY | Out of Stock.
iCC818BLK | Out of Stock.
iCC816BRN | Pre-Order. On order.
iCC816GRY | Pre-Order. On order.
iCC816BLK | Out of Stock.
Spreadsheet: 871331d1717714803-use-all-data-from-one-row-to-make-a-new-sheet-vt-data-sample
Sheet: All Data

Name | Student ID | Status | WS | Start Date | Grad Date | VTNE Code | RVT | Badges | Resume | [NAME] | FA Exit
Sample Student | 1234 | Active | 15 | 2024-05-01 00:00:00 | 2025-06-24 00:00:00 | qwerty | Yes | 12 | Yes | 2025-06-20 00:00:00 | 2025-06-23 00:00:00
[NAME] | 2345 | [NAME] | 16 | 2024-05-01 00:00:00 | 2025-06-24 00:00:00 | asdfg | No | 8 | No
Jonny Student | 3456 | Warning | 18 | 2024-05-01 00:00:00 | 2025-06-24 00:00:00
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-11

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-11 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 8f997809-a90c-4cd6-9a2d-d98eeb8f2a95
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (6 [NAME]):
 | 6 Reagenzien, [NAME] für die Lebensmittelanalytik
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | AES Chemunex | Frankreich | Bruz | 35172 | B1.214
2 | [NAME] [NAME] und Laborbedarf | Deutschland | Karlsruhe | 76185 | B1.303/406
3 | Extrasynthese | Frankreich | [NAME] Cedex | 69730 | B2.222
4 | Livchem Logistic GmbH | Deutschland | Frankfurt | 65933 | A1.508B
5 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
6 | Th. Geyer GmbH & Co. [NAME] | Deutschland | Renningen | 71272 | B1.430
Spreadsheet: 682395d1592064050-find-date-of-which-employee-satisfies-two-conditions-sample-2
Sheet: BONOUS

CODE | NET LIVES | NET FP | DATE(YYYYMMDD) |  |  | CHANGE DATE
 |  |  |  |  |  | AS REQUIRED
192 |  |  | 20190828 |  |  | 20190401 | 20200331
727 |  |  | 20200214
888 |  |  | 20190614
 |  |  |  |  |  | PROJECT : IF AN EMPLOYEE (SHOWN IN SHEET NBD COLUMN "EM-CODE) COMPLETES SIX UNIQUE ORDERS(UNIQUE ORDER MEANS: ' ORDER-NO' WITH UNIQUE' DOB')
 |  |  |  |  |  | AND SUM OF ALL ORDER PREM IS >=50000 IN GIVEN DATE RANGE .EMPLOYEE IS ELIGIBLW FOR BONUS FROM DATE ON WHICH HE SATISFIES TWO CONDITIONS.
 |  |  |  |  |  | SOLUTION REQUIRED : I WANT TO DISPLAY DATE IN COL. [NAME] YYYYMMDD FORMAT(AS SHOWN IN COL. 'C' OF 'NBD' SHEET) ON WHICH EMPLOYEE SATISFY ABOVE MENTIONED
 |  |  |  |  |  | TWO CONDITIONS. SO THAT I CAN CALCULATE BONOUS FROM THAT DATE.
 |  |  |  |  |  | EXPECTED RESULT IS GIVEN IN COL. D
Spreadsheet: 2457278b-3374-4da7-ad36-7dcc0b990bbe
Sheet: Sheet1

Securities | % of Assets
Alimentatn Couche-Tard B | 4.32%
Bell Aliant Inc | 4.02%
Metro Inc. | 3.75%
Fairfax Financial Holding | 3.72%
BCE Inc. | 3.65%
Dollarama Inc. | 3.57%
Cdn Utilities Cl A NVS | 3.20%
Pembina Pipeline Inc | 3.04%
Emera Inc. | 2.97%
Weston(George) Ltd. | 2.87%
Tim Hortons Inc. | 2.83%
Empire Company Cl A NVS | 2.83%
Inter Pipeline Ltd. | 2.80%
Keyera Corp | 2.70%
Loblaw Companies Ltd. | 2.62%
Franco-Nevada Corp | 2.60%
RioCan REIT | 2.58%
Canadian REIT | 2.54%
ATCO Ltd Class I | 2.51%
Enbridge Inc. | 2.50%
Open Text Corp. | 2.50%
AltaGas Ltd | 2.45%
TELUS Corp. | 2.44%
TransCanada Corp. | 2.37%
Fortis Inc. | 2.19%
Saputo Inc. | 2.16%
Intact Financial Corp | 2.05%
Shaw Communicatn Cl B Nvs | 2.05%
Rogers Communications Inc | 2.01%
Valeant Pharmaceuticals | 1.93%
CGI Group Inc Cl A | 1.81%
Catamaran Corporation | 1.79%
CAE Inc. | 1.70%
Canadian Tire Corp Cl A | 1.67%
West Fraser Timber Co Ltd | 1.63%
H&R REIT | 1.61%
TransAlta Corp. | 1.50%
Thomson Reuters Corp | 1.50%
CI Financial Corp | 1.26%
IGM Financial Inc. | 1.24%
Cash | 0.53%
Total Holdings in Portfolio | 41
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 162000 | 164214
2 | 165112 | 164214
3 | 166252 | 167214
4 | 159596 | 159052
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  | 4822
2001-07-04 00:00:00
Spreadsheet: 486136d1477336088-variable-weight-question-weight-average
Sheet: Sheet1

Rank | Company | Sector | Industy | Total | Event Attendance | Strong Connections | Average Connections | Weak Connections | Score | Giving | Lookup ID | Score2 | Related Philanthropy (Low range) | Score3 | Cause giving | Score4
 | A | Retail | Apparel |  | Yes | 0 | 4 | 4 |  | 50000 | 8-46186792 |  | 352250 |  | Yes
 | B | Retail | - |  | No | 0 | 1 | 1 |  | 45102.08 | 8-19413117 |  | 763100 |  | Yes
 | C | Health Care | Pharmaceuticals, Biotech |  | No | 2 | 0 | 0 |  | 0 | 0 |  | 1223227 |  | Yes
 | D | Personal Products | - |  | No | 0 | 0 | 0 |  | 23006.28 | 8-46405084 |  | 400000 |  | Yes
 | E | Public sector, Plastics | - |  | No | 2 | 0 | 0 |  | 0 | 8-47129991 |  | 200000 |  | Yes
 | F | Consumer Durables | Apparel |  | Yes | 0 | 0 | 0 |  | 6060.95 | 8-19440261 |  | 737500 |  | Yes
 | G | Retail | Wellness & Skincare Products |  | No | 0 | 0 | 0 |  | 20000 | 8-46197870 |  | 5000 |  | Yes
 | H | Benefit Adminnistration | - |  | No | 0 | 0 | 0 |  | 30832.52 | 8-19407419 |  | 0 |  | Yes
 | I | Retail | Footwear |  | Yes | 1 | 0 | 1 |  | 45 | 8-19404945 |  | 28000 |  | Yes
 | J | Business & Consumer Services | Medical Products |  | Yes | 1 | 0 | 0 |  | 0 | 0 |  | 207500 |  | Yes
 | K | Energy | Oil & Gas |  | No | 0 | 0 | 1 |  | 125.54 | 8-46639118 |  | 135000 |  | Yes
 | L | Hospitality | Restaurants |  | No | 0 | 0 | 3 |  | 231.71 | 8-37931456 |  | 300 |  | Yes
 | M | Retail | Personal Products |  | No | 0 | 0 | 1 |  | 500 | 8-19466824 |  | 1050 |  | Yes
 | N | Retail | - |  | No | 0 | 0 | 0 |  | 0 | 0 |  | 570250 |  | Yes
 | O | - | Hospitals & Patient Services |  | No | 0 | 0 | 2 |  | 0 | 0 |  | 11501 |  | Yes
 | P | Retail | - |  | No | 0 | 0 | 0 |  | 11000 | 8-46347696 |  | 75000 |  | No
 | Q | Other | - |  | No | 0 | 0 | 0 |  | 0 | 8-48528649 |  | 300 |  | Yes
 | R | - | Textiles |  | Yes | 2 | 0 | 0 |  | 0 | 0 |  | 100 |  | No
 | S | Business & Consulting Services | - |  | No | 0 | 0 | 0 |  | 12241 | 8-46145049 |  | 0 |  | No
 | T | Technology | Computer Software |  | No | 0 | 2 | 1 |  | 0 | 0 |  | 0 |  | No
 | U | - | Textiles |  | Yes | 0 | 1 | 1 |  | 0 | 0 |  | 0 |  | No
 | V | Consumer Durables | Footwear |  | Yes | 0 | 0 | 1 |  | 0 | 0 |  | 0 |  | No
 | W | Basic Materials | Plastics & Synthetics |  | No | 0 | 0 | 1 |  | 0 | 0 |  | 0 |  | No
 | X | Retail | - |  | No | 0 | 0 | 0 |  | 0 | 0 |  | 0 |  | No
Notes and Methodology
Rankings are based on a consideration of the following variables: RelSci connections and St. Jude giving are worth up to 30% each while philanthropic giving to health-related organizations and donations to cancer-specifc organizations are worth up to 20% each.
Additional 2nd degree connections are available for the each of the above companies with RelSci profiles.
Spreadsheet: 699285d1602520162-error-in-autofilling-for-patterned-rows-help-me-pleasee
Sheet: Similarity

 | SIM | SIM(1,1) | SIM(1,2) | [NAME]) | SIM(1,4) | SIM(1,5) | SIM(2,1) | SIM(2,2) | SIM(2,3) | SIM(2,4) | SIM(2,5) | SIM(3,1) | SIM(3,2) | SIM(3,3) | SIM(3,4) | SIM(3,5) | SIM(4,1) | SIM(4,2) | SIM(4,3) | SIM(4,4) | SIM(4,5) | SIM(5,1) | SIM(5,2) | SIM(5,3) | SIM(5,4) | SIM(5,5)
 | SIM(1,1) | 1
 | SIM(1,2) | 0.1866054968633707
 | [NAME]) | 0.25
 | SIM(1,4) | 0.5
 | SIM(1,5) | 0.5
 | SIM(2,1) | 0.1866054968633707
 | SIM(2,2) | 1
 | SIM(2,3) | 0.3333333333333333
 | SIM(2,4) | 0.1951941016011038
 | SIM(2,5) | 0.25
 | SIM(3,1) | 0.3333333333333333
 | SIM(3,2) | 1
 | SIM(3,3) | 0.25
 | SIM(3,4) | 0.3333333333333333
 | SIM(3,5) | 0.5
 | SIM(4,1) | 0.1951941016011038
 | SIM(4,2) | 0.25
 | SIM(4,3) | 1
 | SIM(4,4) | 0.4142135623730951
 | SIM(4,5) | 0.5
 | SIM(5,1) | 0.1907435698305462
 | SIM(5,2) | 0.3333333333333333
 | SIM(5,3) | 0.4142135623730951
 | SIM(5,4) | 1
 | SIM(5,5) | 0.1350781059358212
Spreadsheet: 1469308f-5f8b-4926-bb96-63ee54fa33c3
Sheet: Sheet1

Threshold for genes that under positive perturbation | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | ρg > 2 | Unnamed: 5 | Unnamed: 6
Threshold for enriched gene ontology terms |  |  |  | p-value < 0.01
GOBPID | Pvalue | OddsRatio | ExpCount | Count | Size | Term (Biological process)
GO:0044249 | 9.3e-19 | 2.152638044 | 140.6731475 | 237 | 647 | cellular biosynthetic process
GO:0009059 | 9.3e-19 | 2.152638044 | 140.6731475 | 237 | 647 | macromolecule biosynthetic process
GO:0006412 | 9.3e-19 | 2.152638044 | 140.6731475 | 237 | 647 | translation
GO:0006399 | 4.46e-14 | 3.941569072 | 28.04766001 | 67 | 129 | tRNA metabolic process
GO:0006457 | 2.16e-12 | 2.389772763 | 65.00969259 | 118 | 299 | protein folding
GO:0006091 | 5.71e-11 | 1.788377777 | 138.4989103 | 208 | 637 | generation of precursor metabolites and energy
GO:0051186 | 1.17e-08 | 1.969534565 | 73.27179399 | 118 | 337 | cofactor [NAME] process
GO:0044260 | 3.03e-08 | 1.285228576 | 725.5669286 | 842 | 3437 | cellular macromolecule metabolic process
GO:0016070 | 5e-08 | 1.57827092 | 160.0238587 | 221 | 736 | RNA metabolic process
GO:0009056 | 5.35e-08 | 1.314004288 | 529.4267607 | 632 | 2435 | catabolic process
GO:0071843 | 6.51e-08 | 1.951492407 | 67.40135352 | 108 | 310 | cellular component biogenesis at cellular level
GO:0006139 | 8.56e-08 | 1.307273604 | 533.7752351 | 635 | 2455 | nucleobase-containing compound metabolic process
GO:0019538 | 2.27e-07 | 1.240556006 | 883.1751549 | 1001 | 4062 | [NAME] process
GO:0002376 | 5.12e-07 | 1.290731773 | 512.032863 | 605 | 2355 | immune system process
GO:0042254 | 1.32e-06 | 2.148898154 | 39.78854095 | 68 | 183 | ribosome biogenesis
GO:0009308 | 5.86e-06 | 1.545746586 | 118.495928 | 162 | 545 | amine metabolic process
[NAME] | 5.86e-06 | 1.545746586 | 118.495928 | 162 | 545 | cellular amino acid metabolic process
GO:0043436 | 5.86e-06 | 1.545746586 | 118.495928 | 162 | 545 | oxoacid metabolic process
GO:0007005 | 9.11e-05 | 1.701713978 | 55.87789631 | 82 | 257 | mitochondrion organization
GO:0044238 | 0.000259659 | 1.28110414 | 263.3755095 | 312 | 1306 | [NAME] process
GO:0006259 | 0.000310681 | 1.284368336 | 240.2532117 | 287 | 1105 | DNA metabolic process
GO:0071844 | 0.00066957 | 1.810344828 | 32.61355816 | 50 | 150 | cellular component assembly at cellular level
GO:0034621 | 0.00066957 | 1.810344828 | 32.61355816 | 50 | 150 | cellular macromolecular complex subunit organization
GO:0022618 | 0.00066957 | 1.810344828 | 32.61355816 | 50 | 150 | ribonucleoprotein complex assembly
GO:0016192 | 0.001365289 | 1.231869565 | 271.7796513 | 315 | 1250 | vesicle-mediated transport
GO:0006950 | 0.004142479 | 1.12305001 | 843.3866139 | 904 | 3879 | response to stress
GO:0065003 | 0.00461608 | 1.199549257 | 272.4319225 | 310 | 1253 | macromolecular complex assembly
GO:0061024 | 0.00907844 | 1.214114019 | 192.8548406 | 222 | 887 | membrane organization
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: Mortgage

MORTGAGE
MONTH | YEAR | APR | PAYMENT | BALANCE
2008-01-01 00:00:00 | 2008 |  | 925
2008-02-01 00:00:00 | 2008 |  | 925
2008-03-01 00:00:00 | 2008 |  | 925
2008-04-01 00:00:00 | 2008 |  | 925
2008-05-01 00:00:00 | 2008 |  | 925
2008-06-01 00:00:00 | 2008 |  | 925
2008-07-01 00:00:00 | 2008 |  | 925
2008-08-01 00:00:00 | 2008 |  | 925
2008-09-01 00:00:00 | 2008 |  | 925
2008-10-01 00:00:00 | 2008 |  | 925
2008-11-01 00:00:00 | 2008 |  | 925
2008-12-01 00:00:00 | 2008 |  | 925
2009-01-01 00:00:00 | 2009 |  | 925
2009-02-01 00:00:00 | 2009 |  | 925
2009-03-01 00:00:00 | 2009 | 6.59 | 925
2009-04-01 00:00:00 | 2009 |  | 925
2009-05-01 00:00:00 | 2009 |  | 925
2009-06-01 00:00:00 | 2009 |  | 925
2009-07-01 00:00:00 | 2009 |  | 925
2009-08-01 00:00:00 | 2009 |  | 925
2009-09-01 00:00:00 | 2009 |  | 925
2009-10-01 00:00:00 | 2009 |  | 925
2009-11-01 00:00:00 | 2009 |  | 925
2009-12-01 00:00:00 | 2009 |  | 925
2010-01-01 00:00:00 | 2010 |  | 925
2010-02-01 00:00:00 | 2010 |  | 925
2010-03-01 00:00:00 | 2010 |  | 925
2010-04-01 00:00:00 | 2010 |  | 925
2010-05-01 00:00:00 | 2010 |  | 925
2010-06-01 00:00:00 | 2010 |  | 925
2010-07-01 00:00:00 | 2010 |  | 925
2010-08-01 00:00:00 | 2010 |  | 925
2010-09-01 00:00:00 | 2010 |  | 925
2010-10-01 00:00:00 | 2010 |  | 925
2010-11-01 00:00:00 | 2010 |  | 925
2010-12-01 00:00:00 | 2010 |  | 925
Spreadsheet: 699728d1602744801-selection-from-a-table-excel-help-v3
Sheet: Condition

 | Data input Field | Data Input Field | Calculated field
Item | Useful Life | Age | Rating |  |  |  |  |  |  | Rating (based on age range)
 |  |  | Based on age range |  |  |  |  |  | Useful life | 1 | 2 | 3 | 4 | 5
aa | 4 | 3 |  | with D5 circular ref |  |  |  |  | 2 | 0.5 | 1 | 1.5 | 2 | >2
bb | 18 | 10 |  | circular ref removed (C5) |  |  |  |  | 3 | 0.75 | 1.5 | 2.25 | 3 | >3
cc | 18 | 3 |  | C5 pointing to rating |  |  |  |  | 4 | 1 | 2 | 3 | 4 | >4
dd | 40 | 10 |  |  |  |  |  |  | 5 | 1.25 | 2.5 | 3.75 | 5 | >5
ee | 40 | 1 |  |  |  |  |  |  | 6 | 1.5 | 3 | 4.5 | 6 | >6
ff | 40 | 23 | 3 |  | example result (no formula) |  |  |  | 7 | 1.75 | 3.5 | 5.25 | 7 | >7
gg | 8 | 5 |  |  | orginal formula to select rage range |  |  |  | 8 | 2 | 4 | 6 | 8 | >8
hh |  |  |  |  |  |  |  |  | 10 | 2.5 | 5 | 7.5 | 10 | >10
ii |  |  |  |  |  |  |  |  | 12 | 3 | 6 | 9 | 12 | >12
jj |  |  |  |  |  |  |  |  | 15 | 3.75 | 7.5 | 11.25 | 15 | >15
 |  |  |  |  |  |  |  |  | 18 | 4.5 | 9 | 13.5 | 18 | >18
 |  |  |  |  |  |  |  |  | 20 | 5 | 10 | 15 | 20 | >20
 |  |  |  |  |  |  |  |  | 25 | 6.25 | 12.5 | 18.75 | 25 | >25
 |  |  |  |  |  |  |  |  | 30 | 7.5 | 15 | 22.5 | 30 | >30
 |  |  |  |  |  |  |  |  | 40 | 10 | 20 | 30 | 40 | >40
 |  |  |  |  |  |  |  |  |  | Age table
 | I am trying to provide a "rating" based actual "age" within an items "useful life".  The age table is a simple proportion of the 1 to 5 rating for each useful life year, against the "rating".  Each "age" falls within a range of each "rating" as is not unique it each useful life.   I would like to be able to generate a "rating" in column D for each item based on the "useful life", corresponding to the "age" range of that row.  The "rating" formula in Column D seems fine for working out the rating based on an "age" range along a row but I am hoping to generate this selection by matching the "useful life" in Column B to Column J in the table.  I am not sure if there is an INDEX / MATCH function I can use or it is just something simple and I cannot see it - appreciate any help
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 53256 | 50455
2 | 35225 | 42864
3 | 9749 | 31925
4 | 13680 | 13148
5 | 39257 | 39446
6 | 39309 | 39455
7 | 17078 | 21455
8 | 38021 | 38122
9 | 50313 | 34788
10 | 41422 | 41455 | -663
11 | 41404 | 41455 | -302
12 | 51512 | 46739
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00
2001-08-12 00:00:00
CBS Dollars
Spreadsheet: 857338d1706361431-formula-index-match-with-binning-buckets-and-other-criteria-combined-excel-issuev2
Sheet: Sheet1 (2)

 |  |  |  |  |  |  | Question
 |  |  |  |  |  |  | Give the corresponding rate for the following criteria
 |  |  |  |  |  |  | Tijd | 10
 |  |  |  |  |  |  | NHG | Nee
 |  |  |  |  |  |  | Label | a
 |  |  |  |  |  |  | LTV | 0.94
 |  |  |  |  |  |  | Solution
 |  |  |  |  |  |  | Only could do this
 |  |  |  |  |  |  | Tijd | NHG | LABEL | 0
 |  |  |  |  |  |  | 10 | NEE | A | 0.0377 | 0.0378 | 0.0389 | 0.0389 | 0.04 | 0.0408 | 0.0409
 |  |  |  |  |  |  | 10 | NEE | A
 |  |  |  |  |  |  | 10 | NEE | A
 |  |  |  |  |  |  | 10 | NEE | A
 |  |  |  |  |  |  | 10 | NEE | A
 |  |  |  |  |  |  | 10 | NEE | A
 |  |  |  |  |  |  | 10 | NEE | A