tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716858d1612385562-relevant-values-in-two-cells-libro1
Sheet: Calculo

Part | Warehouse 1 | Warehouse 2 | Warehouse 1 - Stock | Warehouse 2 - Stock | Weight | Stock | Warehouse | Scenario
1 | 20 | 21 | 6 | 0 |  |  |  | Shows lightest weight with stock and location
2A | 8.95 | 9 | 0 | 6 |  |  |  | Shows wrong weight available and warehouse as there are is no stock of that weight
2B | 8.95 | 9 | 0 | 6 | 9 |  | Warehouse 2 | Line 3 should provide this result in columns F-H
Spreadsheet: 804662d1668204191-concatenate-two-words-with-spacing-in-between-excel-example-1-
Sheet: Sheet1

 | Input-1 | Input-2 |  | Output
 | Out of Network | 12345 |  | Out of Network                              12345
 | In Network | ABCDEF |  | In Network                                   ABCDEF |  | output
 | Out of Scope | Television |  | Out of Scope                            Television |  | Out of Network | 12345
 | XYZ | 12 |  | XYZ                                                           12 |  | In Network | ABCDEF
 | Scope | Laptop |  | Scope                                              Laptop |  | Out of Scope | Television
 |  |  |  |  |  | XYZ | 12
 |  |  |  |  |  | Scope | Laptop
Spreadsheet: 762588d1641649168-consecutive-dates-to-from-and-to-example2560
Sheet: Sheet1

RAW DATA |  |  |  |  | Expected Data
Name | Date |  |  |  | Name | From | To
AAB | 09/12/2021 |  |  |  | AAB | 2021-12-09 00:00:00 | 2021-12-09 00:00:00
AAB | 16/12/2021 |  |  |  | AAB | 2021-12-16 00:00:00 | 2021-12-21 00:00:00
AAB | 17/12/2021 |  |  |  | AP | 2021-12-29 00:00:00 | 2021-12-29 00:00:00
AAB | 18/12/2021 |  |  |  | AP | 2021-12-15 00:00:00 | 2021-12-15 00:00:00
AAB | 19/12/2021 |  |  |  | AR | 2021-12-16 00:00:00 | 2021-12-16 00:00:00
AAB | 20/12/2021 |  |  |  | AR | 2021-12-20 00:00:00 | 2021-12-21 00:00:00
AAB | 21/12/2021 |  |  |  | AR | 2021-12-23 00:00:00 | 2021-12-23 00:00:00
AP | 29/12/2021 |  |  |  | AR | 2021-12-25 00:00:00 | 2021-12-25 00:00:00
AP | 15/12/2021 |  |  |  | AF | 2021-12-18 00:00:00 | 2021-12-24 00:00:00
AR | 16/12/2021 |  |  |  | AS | 2021-12-08 00:00:00 | 2021-12-09 00:00:00
AR | 20/12/2021 |  |  |  | AS | 2021-12-11 00:00:00 | 2021-12-11 00:00:00
AR | 21/12/2021 |  |  |  | AS | 2021-12-26 00:00:00 | 2021-12-26 00:00:00
AR | 23/12/2021 |  |  |  | AS | 2021-12-28 00:00:00 | 2021-12-28 00:00:00
AR | 25/12/2021 |  |  |  | AS | 2021-12-12 00:00:00 | 2021-12-12 00:00:00
AF | 18/12/2021
AF | 19/12/2021
AF | 20/12/2021
AF | 21/12/2021
AF | 22/12/2021
AF | 23/12/2021
AF | 24/12/2021
AS | 08/12/2021
AS | 09/12/2021
AS | 11/12/2021
AS | 26/12/2021
AS | 28/12/2021
AS | 12/12/2021
Spreadsheet: 876357d1723041681-highlight-all-duplicates-per-row-rzcb-find-duplicates-in-single-rows-of-data
Sheet: Sheet9

[NAME] | Diag2 | Diag3 | Diag4 | Diag5 | Diag6 | Diag7 | Diag8 | Diag9 | Diag10 | Diag11 | Diag12 | Is this possible? | Duplicate Yes or No
M9901 | M5412 | M9902 | M62838 | M9903 | M545 | M9904 | M5417 |  |  |  |  | False
I129 | N182 | E559 | D509 | D509 |  |  |  |  |  |  |  | D509
M9901 | M5412 | M9902 | M62838 | M9903 | M545 | M9904 | M5417 |  |  |  |  | False
J45909 | J449 | I10 | M160 | R05 | R062 |  |  |  |  |  |  | False
E039 | D7589 | E870 | E809 | E559 |  |  |  |  |  |  |  | False
C679 | Z5111 | E860 | Z5111 |  |  |  |  |  |  |  |  | Z5111
Spreadsheet: 673545d1587435406-vlookup-index-matching-and-ranking-combine-vlookup-index-matching-and-ranking-combine
Sheet: Sheet1

Data Set |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original ↓
 | Alpha | Bravo | Coon | [NAME] | Yay | Nay | Hey |  |  |  |  |  |  |  |  |  |  | [NAME] | Coon | Bravo
A | 15 | 20 | 21 | 22 | 14 | 11 | 5 |  |  |  |  | A |  |  |  |  | A | 22 | 21 | 20
B | 25 | 74 | 8 | 5 | 2 | 1 | 15 |  |  |  |  |  |  |  |  |  |  | Bravo | Alpha | Hey
C | 11 | 36 | 54 | 78 | 21 | 31 | 61 |  |  |  |  | B |  |  |  |  | B | 74 | 25 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Hey | Coon
 |  |  |  |  |  |  |  |  |  |  |  | C |  |  |  |  | C | 78 | 61 | 54
Spreadsheet: 55611d1255708835-hyperlinks-are-breaking-broken-links
Sheet: GET_IVD_CASES

Object: | OCSE157Business
Line: | Line 1
 | Line 2
 | Line 4, 5, 6, 7
Method | Table | SELECT Columns | WHERE Columns | Other Columns
getIVDCases | TWNIVD_CASE | NCP_UPI | NCP_UPI
 |  | CASE_SUFX | CST_UPI
 |  | CST_UPI | CASE_TYPE
 |  | CASE_TYPE | CASE_STS
 |  | FUNC_AREA_CD | CASE_ESTBL_DT
 |  | CASE_CLSD_RSN | CASE_STS_EFF_DT
 |  | CASE_STS | CASE_CLSD_RSN
 |  | CASE_STS_EFF_DT | CASE_SUFX
 |  | CASE_ESTBL_DT
 |  | NON_COOP_RSN_CD
 |  | NON_COOP_EFF_DT
 | TWNPERSON | SSN | UPI
 |  | LST_NM | SSN
 |  | FRST_NM
 |  | SEX_CD
 | TWNIVD_CASELD_CASE | OFC_CD | UPI
 |  | RSP_CNTY | CASE_SUFX
 |  | SPRVS_UNIT | OFC_CD
 |  |  | PRGM_OFC_TYPE
 |  |  | SPRVS_UNIT
 |  |  | CASELD_IND
 |  |  | PSN_NMB
 | TWNSUP_UNT_POS_HST | NOMADS_USRID | OFC_CD
 |  | ASMNT_BEG_DT | PRGM_OFC_TYPE
 |  |  | SPRVS_UNIT
 |  |  | ASMNT_BEG_DT
 |  |  | ASMNT_END_DT
 |  |  | PSN_NMB
Spreadsheet: 755097d1636656091-formula-to-allocate-no-of-days-to-months-given-start-and-end-dates-resource-allocation
Sheet: Resource

 | Months
Labour Division | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Bids
Collaboration
Eng
H&S
HR
IDE
Maint Field
Procurement
Project Management
Quality
Scheme Field
Security
Service Ops
Software
Transformation
Labour Division | Qty of Units | UoM | Start | End | Duration |  | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Bids | 3.5 | mDay | 2021-08-04 00:00:00 | 2021-09-06 00:00:00
Project Management | 1 | mDay | 2021-08-04 00:00:00 | 2021-09-05 00:00:00
Maint Field | 4 | mDay | 2021-08-05 00:00:00 | 2021-08-06 00:00:00
Maint Field | 0.5 | mDay | 2021-08-10 00:00:00 | 2021-08-11 00:00:00
Bids | 4 | mDay | 2021-08-09 00:00:00 | 2021-08-10 00:00:00
Procurement | 0.5 | mDay | 2021-08-10 00:00:00 | 2021-10-10 00:00:00
Maint Field | 14 | mDay | 2021-08-19 00:00:00 | 2022-04-27 00:00:00
Maint Field | 0.5 | mDay | 2021-08-12 00:00:00 | 2021-10-13 00:00:00
Maint Field | 3 | mDay | 2021-08-09 00:00:00 | 2021-08-10 00:00:00
 | 1 | Lot | 2021-08-09 00:00:00 | 2021-08-10 00:00:00
IDE | 0.5 | mDay | 2022-08-11 00:00:00 | 2022-09-14 00:00:00
IDE | 0.5 | mDay | 2021-08-11 00:00:00 | 2021-08-11 00:00:00
Maint Field | 1 | mDay | 2021-08-16 00:00:00 | 2021-08-16 00:00:00
Maint Field | 1 | mDay | 2021-08-16 00:00:00 | 2021-08-16 00:00:00
Project Management | 1 | mDay | 2021-08-17 00:00:00 | 2022-01-31 00:00:00
Maint Field | 1 | mDay | 2022-01-17 00:00:00 | 2022-01-17 00:00:00
Maint Field | 0.5 | mDay | 2022-01-19 00:00:00 | 2022-01-20 00:00:00
Maint Field | 1.5 | mDay | 2022-01-17 00:00:00 | 2022-12-15 00:00:00
Maint Field | 0.5 | mDay | 2022-01-15 00:00:00 | 2022-02-04 00:00:00
Maint Field | 2 | mDay | 2022-01-15 00:00:00 | 2022-01-17 00:00:00
IDE | 0.5 | mDay | 2022-01-20 00:00:00 | 2022-01-20 00:00:00
Spreadsheet: 99441d1298054421-lookup-xyba-test6
Sheet: Sheet2

Name | Position |  | Level | 1
[NAME] | 1
[NAME] | 3
[NAME] | 6
[NAME] | 7
[NAME] | 8
[NAME] | 11
 | #N/A
 | #N/A
 | #N/A
 | #N/A
Spreadsheet: louise_kitchen__23838__2QYTD Orig
Sheet: Canada Gas

Canada Gas
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
Le Dain |  | Gas |  | Canada
Sangwine |  | Gas |  | Canada |  | 2528456.309120084
Oh |  | Gas |  | Canada |  | 1924877.777923839
[NAME] |  | Gas |  | Canada |  | 979480.459222311
[NAME] |  | Gas |  | Canada |  | 272578.7369761885
Hrap |  | Gas |  | Canada |  | 24873.47606727037
Abramo |  | Gas |  | Canada |  | 9043
[NAME] |  | Gas |  | Canada |  | 3273
Cowan |  | Gas |  | Canada |  | 2863.164572278276
Total
Spreadsheet: 727230d1617791911-auto-pull-and-multiple-good-company
Sheet: Production Plan

 | Crafiting duration | Quantity Output | Daily Production | Needed Production | Tables Needed
Plastic | 0.6 | 10
Plastic Parts | 0.6 | 1
Metal | 0.6 | 1
Electronic Parts | 0.6 | 5
Chemicals | 0.6 | 1
[NAME] | 0.6 | 10
Wood | 0.6 | 1
Circuit Board | 1 | 50
Integrated Circuit | 1 | 50
Plastic Case | 1 | 100
Enhanced Battery Cell | 1 | 50
Logic Circuit
7 Segment Display
Spreadsheet: 673362d1587331981-nested-index-match-formula-copy-of-rebates-spreadsheet-mike-revision-3-
Sheet: Sheet1

Door Name/Room | Suite | Type | Frame depth | Frame height | [NAME] | Fixing tag | Clearance inside (x3) | Distance from framing (x2) | Clearance below (y3) | Height of frame above slab (y2) | Rebate (x) | Rebate (y) | TWT | Framing width | Frame size for reveal size | Reveal size (Excl nib if grooved)
 | Residential | Single Slider (flat face frame) |  |  | Yes |  | 10 | 40 | 5 | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Spreadsheet: jeffrey_a_shankman__13966__MgmtSum-Q401-Global-102601
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS
4th QUARTER 2001 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Crude & Products
Coal
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight
LNG
Middle East
Puerto Rico
Finance and Structuring
Office of the Chairman
Subtotal Commercial
Group
Other Interest Related Charges
Total
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 836730d1689608673-search-and-return-multiple-results-search-mm
Sheet: Blad1

 | [NAME]
 | Search for value A3 in 'column C and D' in 'sheet2' and return the corresponding value in 'column A' from 'sheet2'. Put the found values together with a comma.
4.1
4.2
4.3 | 1,
4.4 | 1,
5.1 | 1, 2, 3,
5.2 | 1,
5.3 | 1,
6.1
6.1.1
6.1.2 | 4, 5,
6.1.3
6.2
6.3
7.1
7.2
7.3
7.4
7.5
7.5.1
7.5.2
7.5.3
8.1
8.2
8.3
9.1 | 2,
9.2 | 1,
9.2.1
9.2.2
9.3
9.3.1
9.3.2
9.3.3
10.1
10.2
Spreadsheet: 5d92583c-5656-4ebb-b710-84a13d7cab7d
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Unnamed: 12 | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  |  | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type:
[NAME]. Limit:
Daily Limit:
Sample Frequency:
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 729868d1619420341-flexible-range-dropdown-with-previous-conditions-over-the-range-of-two-sheets-tripple-dropdown-error-example
Sheet: Masterdata

left dropdown
SalesZurich
ID | Title | Salary | Co-worker Level
 | Sales Manager | 5500 | Manager
 | Sales Team Leader | 4500 | Team Leader
 | [NAME] | 3500 | Specialist
 | Sales Co-Worker | 2500 | Co-worker
Spreadsheet: 568ab64b-aa71-4999-b9c0-8a6f0aac7edb
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998412028 | Various-Tig | This Is Gospel: Meditation | 2004-07-27 | Compact Disc | Black Gospel | 5.99 | Y | Available
Taseis | 14998412721 | Various-Tig | This Is Gospel: Hymns | 2004-07-27 | Compact Disc | Black Gospel | 5.99 | Y | Available
Taseis | 14998412929 | Various-Tig | This Is Gospel: Traditional Choirs | 2004-07-27 | Compact Disc | Black Gospel | 5.99 | Y | Available
Taseis | 14998413421 | Various-Tig | This Is Gospel: Worship | 2004-07-27 | Compact Disc | Black Gospel | 5.99 | Y | Available
Taseis | 14998414725 | Various-Tig | This Is Gospel Too! | 2005-09-13 | Compact Disc | Black Gospel | 5.99 | Y | Available
Taseis | 14998410628 | Various-Tig | This Is Gospel | 2004-07-27 | Compact Disc | Black Gospel | 5.99 | Y | Available
Taseis | 14998411427 | Various-Tig | This Is Gospel: Inspirational Jazz | 2004-07-27 | Compact Disc | Jazz | 5.99 | Y | Available
Spreadsheet: 81553d1281694235-pivot-boxes-disappear-from-drop-down-once-deselected-741391
Sheet: Sheet1

Region | Jan | Feb | Mar | Apr | May | Jun
North | 99 | 34 | 7 | 88 | 93 | 83
South | 36 | 59 | 3 | 82 | 4 | 35
East | 9 | 70 | 38 | 76 | 86 | 65
West | 92 | 32 | 49 | 92 | 18 | 7
Spreadsheet: 126170d1319554784-pivot-table-grand-total-not-the-sum-of-the-column-pt-problemanswer
Sheet: PT

Driver | FAUZAN
 |  |  |  |  | Values
Date | D/Order # | Car Register No | Type of Vehicle | Comm Rate | Amount | 80% of Amount or $40 ($50 x 80%) whichever is higher | Comm Payable
40802 | BTC 173412 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
40803 | BTC 173413 | BH 2070 | Cargo Truck | 0.3 | 90 | 72 | 21.6
40805 | BTC 173414 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
40807 | BTC 173415 | BH 2070 | Cargo Truck | 0.3 | 140 | 112 | 33.6
 | BTC 173416 | BH 2070 | Cargo Truck | 0.3 | 60 | 48 | 14.4
40809 | BTC 173417 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
 | BTC 173418 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
 | BTC 173419 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
 | BTC 173421 | BH 2070 | Cargo Truck | 0.3 | 0 | 0 | 0
 | BTC 173422 | BH 2070 | Cargo Truck | 0.3 | 0 | 0 | 0
40810 | BTC 173420 | BH 2070 | Cargo Truck | 0.3 | 0 | 0 | 0
 | BTC 173423 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
40812 | BTC 173424 | BH 2070 | Cargo Truck | 0.3 | 0 | 0 | 0
 | BTC 173425 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
40815 | BTC 173426 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
 | BTC 173427 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
40817 | BTC 173428 | BH 2070 | Cargo Truck | 0.3 | 70 | 56 | 16.8
40819 | BTC 173429 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
40820 | BTC 173430 | BH 2070 | Cargo Truck | 0.3 | 70 | 56 | 16.8
40822 | BTC 173431 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
 | BTC 173432 | BH 2070 | Cargo Truck | 0.3 | 70 | 56 | 16.8
40824 | BTC 173433 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
40826 | BTC 173434 | BH 2070 | Cargo Truck | 0.3 | 50 | 40 | 12
Grand Total
Spreadsheet: errol_mclaughlin_jr__10086__Bkrqs953
Sheet: Lavo Req

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request # 953
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | Reason for Book | Administrator* | MTM | Prud | Realized
 | OIL-NG-HDG-CD-X | NG Hedge CAD Spreadsheet |  |  | X | ?W | DESK |  |  |  | X | X | NG/MMBTU/USD | [NAME] | To load [NAME] deals for Enron Direct into RisktRAC | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List:
 | kloibl |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
 | emclaug
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | BM
 | molney |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | BM
 |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JV
 |  |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS |  | Y | JV
 |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Any questions, please contact me
 | (x31462)
Spreadsheet: 822947d1679609038-conditional-formatting-using-the-right-function-staffing-workbook
Sheet: Master

 |  |  | [NAME] is to have these columns populate with all projects each employee is working on with the name of the project populated and the color of the cell shaded to the workload level (red yellow or green) as seen in the individual employee tabs' conditional formatting
 |  |  | Could we add conditional formatting to these cells based on the right most character using the RIGHT formula?
 |  |  | AA | BB | CC | DD | EE | FF | GG | HH | II | JJ | KK | LL | MM | NN
 |  | Projects
 |  |  | Project [NAME]
 |  |  | Project DEF3
Spreadsheet: bd982c61-2b28-4785-996d-98eef2c1fd16
Sheet: AMI - By Percent

District County Number | District Number | District Type | District Name | Demographic Group | Four Year Count 2011 | Four Year Percent 2011 | Four Year Count 2012 | Four Year Percent 2012 | Percent Increase | Total Increase Needed to Reach 90% Goal by 2020 | Average Annual Increase Needed to Reach 90% Goal by 2020
62 | 0625 | 01 | ST. PAUL PUBLIC SCHOOL DISTRICT | American Indian/Alaskan Native | 21 | 46.67 | 21 | 52.5 | 5.83
69 | 0709 | 01 | DULUTH PUBLIC SCHOOL DISTRICT | American Indian/Alaskan Native | 17 | 26.56 | 20 | 39.22 | 12.66
11 | 0115 | 01 | CASS LAKE-BENA PUBLIC SCHOOLS | American Indian/Alaskan Native | 18 | 30 | 24 | 38.71 | 8.71
04 | 0031 | 01 | BEMIDJI PUBLIC SCHOOL DISTRICT | American Indian/Alaskan Native | 17 | 21.52 | 26 | 30.95 | 9.43
27 | 0001 | 03 | MINNEAPOLIS PUBLIC SCHOOL DIST. | American Indian/Alaskan Native | 27 | 21.77 | 21 | 25 | 3.23
04 | 0038 | 01 | RED LAKE PUBLIC SCHOOL DISTRICT | American Indian/Alaskan Native | 9 | 8.74 | 23 | 22.77 | 14.03
27 | 4017 | 07 | MINNESOTA TRANSITIONS CHARTER SCH | American Indian/Alaskan Native | . | . | 4 | 9.09 | .
Spreadsheet: 0490e4c2-041e-4693-8ff6-3daa3855a9e3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Note: P=Permanent
Office of the President
Record Series | In Office | Archives | Total Retention Period | Notes
Correspondence | 3 years | P | P
Chronological files | 3 years | P | P
Office files | 3 years | P | P
Invoices | 2 years |  | 2 years
President's Executive Council meeting minutes/agendas/task lists | 18 months | P | P
Staff/Executive Council retreats, minutes | 3 years | P | P
Board of Trustees meeting minutes/agendas | 5 years | P | P
Speeches | 3 years | P | P
Programs of presidential events | 3 years | P | P
Search Committee files (applicant information) | 3 years |  | 3 years
Search Committee files (Planning files) | 3 years | P | P
Student Issues files relating to University policies/procedures | 3 years | P | P
International Partner agreements | Until completion | P | P
[NAME] | 3 years | P | P
Policies | Current | P | P
Contracts with Educational Alliance | Completion + 10 years | P | P
Holiday cards from Office of the President | 2 years | P | P
Miscellaneous historical documents
Signed Board form by [NAME] | Send to Archives | P | P
Original charter of University, framed in Office | Scan, reframe, and send original to Archives | P | P
Spreadsheet: 738091d1624827656-matching-unique-events-against-a-list-of-flights-with-takeoff-and-landing-time-book1
Sheet: FDM EVENTS

Reference | Event Datetime |  |  | Flight Number | Fleet | Aircraft | PIC | SIC | PF | PL | DEP | ARR | Level | Event Short Desc | Graph | Code | Value | Threshold | Type
12345678 | 2021-06-01 00:00:00 | 12:00:16 |  |  | [NAME] | X-XXXX |  |  |  |  | AAA | BBB | 1 | Air spd (rel) hi liftoff | 12345678 | TSA300 | 11 kt | [NAME] 10 kt | Safety
Spreadsheet: frank_ermis__11194__1113
Sheet: Export

[NAME] | [NAME] | Deal No. | Originator | Broker | Type | Deal Date | Status | Brk | Stmt | CP | Trd | Retro | Quantity | Comm | Delivery Ref | Index | Beg Date | End Date | N | Premium | Price | Broker Fee
Aquila Risk Management Corporation | Enron North America Corp. | YJ0340.1 |  | NatSource In | Swap | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 10000 MMBtu/day | NG | IF-ELPO/PERMIAN | NX1 | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | F |  | US -0.2750 | 77.5
Enron North America Corp. | El Paso Merchant Energy  L.P. | [NAME] | May [NAME] | GFI Group  I | OPT/Call | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 500000 MMBtu/month | NG | IF-NWPL_ROCKY_M | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F | 0.41 | US 2.50000 | 1750
Enron North America Corp. | El Paso Merchant Energy  L.P. | YJ0935.2 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 500000 MMBtu/month | NG | IF-NWPL_ROCKY_M | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F | 0.41 | US 2.50000 | 0
Aquila Risk Management Corporation | Enron North America Corp. | YJ1003.1 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 10000 MMBtu/day | NG | IF-NWPL_ROCKY_M | NX1 | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | F | 0.11 | US -0.6600 | 155
Aquila Risk Management Corporation | Enron North America Corp. | YJ1003.2 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 90000 MMBtu/day | NG | IF-NWPL_ROCKY_M | NX1 | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | F | 0.09 | US -0.6600 | 1395
El Paso Merchant Energy  L.P. | Enron North America Corp. | YJ1049.1 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 2000000 MMBtu/month | NG | IF-NWPL_ROCKY_M | NX1 | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | F | 0.08 | US -0.6600 | 1000
CMS Marketing  Services and Trading Company | Enron North America Corp. | YJ0745.1 |  | [NAME] | Swap | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 20000 MMBtu/day | NG | NGI-MALIN | NX1 | 2002-01-01 00:00:00 | 2002-01-31 00:00:00 | F |  | US -0.2050 | 155
Enron North America Corp. | CMS Marketing  Services and Trading Company | YJ0393.1 |  | [NAME] | Swap | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 20000 MMBtu/day | NG | NGI-PGE/CG | NX1 | 2002-01-01 00:00:00 | 2002-01-31 00:00:00 | F |  | US -0.1550 | 155
Enron North America Corp. | Sempra Energy Trading Corp. | [NAME] |  | TFS Energy | Swap | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 5000 [NAME]/day | NG | NGI-PGE/CG | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F |  | US 0.08000 | 267.5
Enron North America Corp. | Coral Energy Resources  L.P. | YJ1420.1 |  | Amerex USA J | Swap | 2001-11-13 00:00:00 | New deal | No | No | No | No | N | 5000 [NAME]/day | NG | NGI-SOCAL | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F |  | US 0.04000 | 267.5
Spreadsheet: 38124d1236251550-excel-2007-significant-loss-of-functionality-error-forex-journal-live
Sheet: MAYTOTALS

DATE | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | Gross P/L | PIPS | DEPOSITS & WITHDRAWALS
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
 | WINS | LOSSES | WIN $ | LOSS $ | WIN % | LOSS % | ACCOUNT $ TOTAL | PIP TOTAL | TOTAL $ IN/OUT
TOTALS
 | ACTUAL WIN/LOSS $ |  |  |  |  |  | AV. $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)
Spreadsheet: 710335d1608850679-conditional-formatting-more-than-three-colours-blood_pressure_chart
Sheet: Sheet1

Date | Time | Systolic | Diastolic | Category
2020-12-24 00:00:00 |  | 120 | 79 | Normal
2020-12-25 00:00:00 |  | 123 | 79 | Elevated
2020-12-25 00:00:00 |  | 141 | 80 | Stage 1
2020-12-26 00:00:00 |  | 182 | 121 | Stage 2
2020-12-26 00:00:00
2020-12-27 00:00:00
2020-12-27 00:00:00
2020-12-28 00:00:00
2020-12-28 00:00:00
2020-12-29 00:00:00
2020-12-29 00:00:00
2020-12-30 00:00:00
2020-12-30 00:00:00
2020-12-30 00:00:00
2020-12-31 00:00:00
2020-12-31 00:00:00