tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: stacey_white__39201__new BOOK REQUEST TAGG
Sheet: Sheet1

From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Requestor: | [NAME]
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
PWR-GAS-NW | POWERGASNORTHWEST | x |  |  |  | NYMEX | x |  |  |  |  |  | NG/MMBtu/USD | [NAME] | MTM | Netco | ASAP
PWR-GAS-SW | POWERGASSOUTHWEST | x |  |  |  | NYMEX | x |  |  |  |  |  | NG/MMBtu/USD | [NAME] | MTM | Netco | ASAP
PWR-GAS-CALI | POWERGASCALIFORNIA | x |  |  |  | NYMEX | x |  |  |  |  |  | NG/MMBtu/USD | [NAME] | MTM | Netco | ASAP
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
 |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Book | Login |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC
Administrator* | Names |  |  |  |  |  |  |  |  |  |  |  | Hierarchy
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
Heather Dunton
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | PORTFOLIO NAME |  | Added (Y/N) | Processors ID
Casey Evans |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM
 |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD
 |  |  |  |  |  |  |  |  |  |  |  | IF: | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
Spreadsheet: 725817d1616906479-list-combinations-that-equal-over-10-excel-help-over-10-combos
Sheet: Sheet1

number | v | h |  |  |  |  |  | Example |  |  |  |  | 0.1
982 | -0.103388572841949 | -0.1222112292851845
983 | -0.1003610108303251 | -0.08862815884476516
924 | -0.1242986525292691 | -0.09255577645239665
925 | -0.1141618497109826 | 0.149132947976879
926 | -0.03741392501912766 | -0.156847742922724
927 | -0.08144519289650953 | -0.1515003061849356
928 | 0.01385542168674703 | -0.1566265060240966
929 | -0.09638019098378858 | -0.1157672662669332
934 | -0.07464528069093157 | -0.1689080814312152
935 | -0.07020714583622945 | -0.1567009592659537
936 | 0.01448511983144596 | -0.1708454042665264
Spreadsheet: 751946d1634470068-how-can-i-sort-a-column-of-military-times-from-earliest-to-latest-sorting-military-times
Sheet: Sheet1

17:14:00 | A
18:24:00 | B
16:10:00 | C
16:45:00 | D
17:55:00 | E
15:25:00 | F
16:35:00 | G
17:45:00 | H
16:53:00 | I
18:38:00 | J
18:10:00 | K
20:05:00 | L
01:15:00 | M
04:10:00 | N
02:20:00 | O
04:55:00 | P
01:30:00 | Q
21:41:00 | R
Spreadsheet: 867104d1713990483-creating-a-formula-sample-sheet
Sheet: Sheet1

2024-01-01 07:36:15.363000 | [NAME] |  |  | 2024-01-01 00:00:00 | [NAME]
2024-01-01 16:16:16.443000 | Cathy |  |  | 2024-01-02 00:00:00 | Cathy
2024-01-01 16:16:16 | [NAME] |  |  | 2024-01-03 00:00:00 | [NAME]
2024-01-01 16:54:48.400000 | [NAME] |  |  | 2024-01-04 00:00:00 | Cathy
2024-01-01 16:54:48.400000 | [NAME]
2024-01-01 16:46:46.357000 | Cathy
2024-01-01 16:46:46.357000 | [NAME]
2024-01-01 16:46:46.357000 | [NAME]
2024-01-01 16:46:46.357000 | Cathy
2024-01-01 16:47:06.403000 | Cathy
2024-01-01 16:47:06.403000 | [NAME]
2024-01-01 16:47:06.403000 | [NAME]
2024-01-01 16:47:06.403000 | Cathy
2024-01-01 16:02:25.557000 | [NAME]
2024-01-01 16:02:25.557000 | [NAME]
2024-01-01 16:30:46.747000 | Cathy
2024-01-01 16:30:46.747000 | [NAME]
2024-01-01 13:26:48.213000 | [NAME]
2024-01-01 13:26:48.213000 | [NAME]
2024-01-01 16:43:03.347000 | Cathy
2024-01-01 16:43:03.347000 | [NAME]
2024-01-01 15:00:54.713000 | [NAME]
2024-01-01 15:00:54.713000 | [NAME]
2024-01-01 16:34:25.623000 | Cathy
2024-01-01 16:34:25.623000 | [NAME]
2024-01-02 21:42:55.513000 | [NAME]
2024-01-02 21:42:55.513000 | Cathy
2024-01-02 21:42:55.513000 | [NAME]
2024-01-02 21:42:55.513000 | [NAME]
2024-01-02 21:54:00 | [NAME]
2024-01-02 21:55:21.920000 | Cathy
2024-01-02 21:55:21.920000 | [NAME]
2024-01-02 21:55:30.117000 | [NAME]
2024-01-02 21:55:30.117000 | Cathy
2024-01-02 19:36:30.960000 | Cathy
2024-01-02 19:36:30.960000 | [NAME]
2024-01-02 19:36:51.480000 | [NAME]
2024-01-02 19:36:51.480000 | Cathy
2024-01-02 22:24:27.573000 | [NAME]
2024-01-02 22:24:27.573000 | [NAME]
2024-01-02 22:46:29.153000 | Cathy
2024-01-02 22:46:29.153000 | [NAME]
2024-01-02 22:48:09.753000 | [NAME]
2024-01-02 22:48:09.753000 | [NAME]
2024-01-02 22:48:37.080000 | Cathy
2024-01-02 22:48:37.080000 | [NAME]
2024-01-02 22:48:28.587000 | [NAME]
2024-01-02 22:48:28.587000 | [NAME]
2024-01-02 22:54:32.757000 | [NAME]
2024-01-02 22:54:32.757000 | Cathy
2024-01-02 22:56:40.123000 | [NAME]
2024-01-02 21:55:21.920000 | Cathy
2024-01-03 21:55:22 | [NAME]
2024-01-03 21:55:30 | [NAME]
2024-01-03 21:55:30 | Cathy
2024-01-03 19:36:31 | Cathy
2024-01-03 19:36:31 | [NAME]
2024-01-03 19:36:51 | [NAME]
Spreadsheet: 98960d1297769316-lots-of-data-to-collate-and-remove-duplicates-example
Sheet: DATA

Code | Back/Foward Code | Back Figure | Forward Figure
Code1 | Code2 | 9 | 22 |  | << rows are repeated < only require ONE of the same row
Code1 | Code2 | 9 | 22 |  | << rows are repeated < only require ONE of the same row
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0 |  | Back and Forward Figures Should Match (opposite entry) for each Code
Code1 | 0 | 0 | 0 |  | You can see that Code1  has Code2 in column b -  9 BACK and 22 FORWARD
Code1 | 0 | 0 | 0 |  | therefore
Code1 | 0 | 0 | 0 |  | Code2 should have Code1 in column B - 22 BACK and 9 FORWARD
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code1 | 0 | 0 | 0
Code2 | Code1 | 22 | 9
Code2 | Code1 | 22 | 9
Code2 | Code3 | 10 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code2 | 0 | 0 | 0
Code3 | Code2 | 0 | 10
Code3 | Code4 | 10 | 5
Code3 | Code5 | 22 | 4
Code3 | Code5 | 22 | 4
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code3 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | Code3 | 5 | 10
Code4 | Code5 | 8 | 6
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code4 | 0 | 0 | 0
Code5 | Code3 | 4 | 22
Code5 | Code3 | 4 | 22
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Code5 | 0 | 0 | 0
Spreadsheet: 718150d1613014504-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 12

 |  |  | Date | 2021-01-12 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 1 day, 0:00:00 | 1 day, 0:00:00 | 1900-01-01 00:00:00 |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: kevin_ruscitti__20254__NGPL_RATES
Sheet: trunk

INCLUDES GRI TO MARKET AREA | trnk wla | Gas Cost | 6.36 |  |  |  |  | 5
 | [NAME] |  | 6.32
 | trnk stx |  | 6.36
 |  |  |  | Delivered |  | Grossed up Volume
Pipeline | Comm $ | Fuel% | Rate | w/OUT | W/GRI | 10000
TRUNKLINE |  |  |  |  | 0.0072
FIELD |  |  |  |  |  |  |  |  | 5.11 | 5.195
Field zone to field zone |  | 0.0145 |  |  |  |  |  |  | 5.275 | 5.21
field to zone 1A |  | 0.0239
field to zone 1b |  | 0.0294
field to zone 2 |  | 0.0323
zone 1A to zone 1A |  | 0.01155
zone 1A to zone 1B |  | 0.021
zone 1A to zone 2 |  | 0.0239
Gulf Coast Mainline to Market |  | 0.0303
TXOK
Louisiana to TXOK |  | 0.011
TXOK to TXOK |  | 0.016
STX to TXOK |  | 0.0226
Iowa - Illinois to Market |  | 0.0181
Amarillo to Market | 0.0173 | 0.0319
Midcontinent to Market | 0.0243 | 0.0452
Permian to Market | 0.0303 | 0.0629
 | Comm
Penzoil contract | 0.0004 |  |  |  |  | 92000 | 5.25
 |  |  |  |  |  | 35000 | 5.266
 | 0.0015
Spreadsheet: 75684d1276222673-using-count-function-with-dates-grouped-into-months-book1
Sheet: Sheet1

incident | date 1 | date 2
1 | 2010-04-03 00:00:00
1
1 | 2010-03-03 00:00:00 | 2010-04-04 00:00:00
2 | 2010-03-01 00:00:00
2 | 2010-01-01 00:00:00 | 2010-03-02 00:00:00 |  |  |  | Jan |  | Feb |  | Mar |  | Apr |  | May
2 | 2010-05-03 00:00:00 |  |  |  |  | date 1 | date 2 | date 1 | date 2 | date 1 | date 2 | date 1 | date 2 | date 1 | date 2
2 | 2010-02-02 00:00:00 |  |  |  | 1
2 |  | 2010-04-03 00:00:00 |  |  | 2
3 | 2010-04-03 00:00:00 |  |  |  | 3
3 |  |  |  |  | 4
3 | 2010-01-25 00:00:00 | 2010-03-23 00:00:00 |  |  | 5
3
4 | 2010-04-30 00:00:00 | 2010-04-03 00:00:00
4 | 2010-01-01 00:00:00 | 2010-03-01 00:00:00
5 | 2010-05-24 00:00:00
Spreadsheet: 100548d1298906739-auto-input-date-range-teacher-calendar-practice
Sheet: 1st 9 Wks

First Nine Weeks |  |  | (8/24 - 10/22), 2011 |  |  | I need look for the first and last date and auto place in D and E1 with the year 2011
2011-08-22 00:00:00
Spreadsheet: 229688d1366511405-how-to-get-the-content-of-the-row-as-the-content-of-a-column-how-to-get-thecontent
Sheet: Sheet1

subject |  |  |  | subject | MATHS
MATHS |  |  |  | subject | BIOLOGY
subject |  |  |  | subject | PHYSICS
BIOLOGY |  |  |  | subject | CHEMISTRY
subject |  |  |  | subject | ENGLISH
PHYSICS
subject
CHEMISTRY
subject
ENGLISH
Spreadsheet: 756517d1637609463-using-a-named-range-array-inside-an-offset-function-yearlyimpactdata_futurevalues-1-
Sheet: Sheet1

Years:
Revenues | 12000
 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2035-12-31 00:00:00
ImpactInput | 0.03 | 0.02 | 0.01 | 0.02 | 0.01
 |  | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00 | 2032-12-31 00:00:00 | 2033-12-31 00:00:00 | 2034-12-31 00:00:00 | 2035-12-31 00:00:00
ActualImpact |  | 1.02 | 1.02 | 1.02 | 1.01 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.02 | 1.01
Target:
Using NamedRange:
 |  | 12607.2 | 12859.344 | 13116.53088 | 13247.6961888 | 13512.650112576 | 13782.90311482752 | 14058.56117712407 | 14339.73240066655 | 14626.52704867988 | 14919.05758965348 | 15217.43874144655 | 15521.78751627548 | 15832.22326660099 | 15990.54549926701
Spreadsheet: 468674d1467446376-copy-paste-special-between-sheets-problem1
Sheet: 2feb

 |  | st rita2 |  |  |  | kontich |  |  |  | [NAME] | rumst
 |  | 9,98/u | 13,26/u |  | 13,26/u | 9,98/u | 13,26/u | 13,26/u | 6,63/u | 20/u | 14/u | 14/u
 |  | 24.95 | 19.89 |  | 33.15 | 19.96 | 26.52 | 33.15 | 16.58 | 70 | 35 | 24.5
 |  | za | za | woe | di | za | za | di | do | ma | zo | woe
 |  | 9-11.30 | 11.30-13 | 13-15 | 20-22.30 | 9-11 | 11-13 | 20-22.30 | 20-22.30 | 19-22.30 | 19-21.30 | 20.30-22.15
ma | 2015-02-01 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-02-02 00:00:00 |  |  |  | npok
wo | 2015-02-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
do | 2015-02-04 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-02-05 00:00:00
za | 2015-02-06 00:00:00 | ok | ok
zo | 2015-02-07 00:00:00 |  |  |  |  |  |  |  |  |  | x
ma | 2015-02-08 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-02-09 00:00:00 |  |  |  | pok
wo | 2015-02-10 00:00:00
do | 2015-02-11 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-02-12 00:00:00
za | 2015-02-13 00:00:00 | ok | ok
zo | 2015-02-14 00:00:00 |  |  |  |  |  |  |  |  |  | x
ma | 2015-02-15 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-02-16 00:00:00 |  |  |  | npok
wo | 2015-02-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
do | 2015-02-18 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-02-19 00:00:00
za | 2015-02-20 00:00:00 | ok | ok
zo | 2015-02-21 00:00:00
ma | 2015-02-22 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-02-23 00:00:00 |  |  |  | npok
wo | 2015-02-24 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
do | 2015-02-25 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-02-26 00:00:00
za | 2015-02-27 00:00:00
zo | 2016-02-28 00:00:00 |  |  |  |  |  |  |  |  |  | x
ma | 2016-02-29 00:00:00 |  |  |  |  |  |  |  |  | ok
Spreadsheet: 85922d1285917252-text-into-a-cell-2010-09-28-vendas-de-animais-janeiro-2010
Sheet: Lista Facturas a receber

LISTAGEM RECEBIMENTOS DAS VENDAS - JANEIRO 2010
Nº FACT. INTERNA MÊS | FORNECEDOR | Nº FACTURA | DATA FACTURA | PRAZO PAGAMENTO | DATA VENCIMENTO | DIAS PARA PAGAMENTO | TIPO PAGAMENTO | VALOR A PAGAR C/ IVA | TIPO DE PRODUTO / QUANTIDADE
F1
F2 |  |  |  |  |  |  |  |  | " ON THE CELL ABOVE I WANT TO HAVE THE FOLLOWING RESULT WHEN I USE THE CODES "MP" . "Vendas de matérias primas"
F3
F4
F5
F6
F7
F8
F9
[NAME]
F11
F12
F13
F14
F15
F16
F17
F18
F19
F20
F21
F22
F23
F24
F25
F26
F27
[NAME]
F29
F30
F31
F32
F33
F34
F35
F36
F37
F38
F39
F40
F41
F42
F43
F44
F45
F46
F47
F48
F49
F50
F51
F52
F53
F54
F55
F56
F57
F58
F59
F60
F61
F62
F63
F64
F65
F66
F67
F68
F69
[NAME]
F71
F72
F73
F74
F75
F76
F77
F78
F79
F80
Spreadsheet: 834998d1688220641-excel-get-the-data-after-comparision-sample-etaf
Sheet: Sheet1

PRODUCTS | AVAILABLE | IF PRODUCT IS AVAILABLE IN MORE THAN 5 STATES |  | =OR(B1="all india",COUNTA(TEXTSPLIT(B1,","))>4) | =OR(B1="all india",LEN(B1)-LEN(SUBSTITUTE(B1,",",""))>=4) | ZONE | STATE | STATE | STATE | STATE | STATE | STATE | STATE | STATE
APPLE | State(s) - DELHI | NO |  |  |  | North | Jammu Kashmir | [NAME] | Delhi | Punjab | Himachal Pradesh | Chandigarh | [NAME]
ORANGE | All India | YES |  |  |  | Central | Uttar Pradesh | Madhya Pradesh | Chhattisgarh | Uttarakhand
MANGO | State(s) - KARNATAKA, TAMIL NADU, JAMMU & KASHMIR, DELHI, MAHARASHTRA, GUJARAT, ANDHRA PRADESH, UTTAR PRADESH, KERALA, WEST BENGAL, HARYANA, CHANDIGARH, PUNJAB, GOA, HIMACHAL PRADESH, BIHAR, MADHYA PRADESH, SIKKIM, ODISHA, RAJASTHAN, CHHATTISGARH, UTTARAKHAND, [NAME] | YES |  |  |  | East | Bihar | Odisha | Jharkhand | West Bengal | Sikkim
BANANA | State(s) - GUJARAT | NO |  |  |  | West | Gujarat | Daman Diu | Maharashtra | Dadra Nagar Haveli | Goa
GRAPES | State(s) - DELHI | NO |  |  |  | South | Karnataka | Kerala | [NAME] | Telangana | [NAME] | [NAME] | Andaman Nicobar | Lakshadweep
PINAPPLE | State(s) - UTTAR PRADESH | NO |  |  |  | Northeast | Manipur | Mizoram | Tripura | Nagaland | Meghalaya | Assam | Arunachal Pradesh
PEANUT | State(s) - UTTAR PRADESH | NO
TOMATO | State(s) - MADHYA PRADESH | NO
POTATO | All India | YES
CARROT | State(s) - MADHYA PRADESH | NO
OIL | State(s) - JAMMU & KASHMIR, DELHI, HARYANA, CHANDIGARH, PUNJAB, HIMACHAL PRADESH, RAJASTHAN | YES
 | State(s) - JAMMU & KASHMIR, DELHI, HARYANA, CHANDIGARH, PUNJAB
 | NOTE
 | THE PRDUCT IS AVAILABLE IN SOME STATES BUT I WANT THE ONLY THOOSE PRODUCTS WHICH ARE AVALABLE IN MORE THAN 5 STATES.
Spreadsheet: 76296d1276803054-piecewise-function-example
Sheet: Sheet1

Net value | 0 | 3 | 8 | 19 | 40 | 120
Return | 0 | 0 | 0 | 0 |  |  |  |  | Return Milestones | percentage of net
 |  |  |  |  |  |  |  |  | <25 | 0
 |  |  |  |  |  |  |  |  | 25-50 | 0.025
 |  |  |  |  |  |  |  |  | 50-100 | 0.05
 |  |  |  |  |  |  |  |  | >100 | 0.1
Because the milestone of above 25 has already been reached, you don't take the percentage of it again.
Rather, you take the 3% of 50-25 and add it to 10% of the difference between 120 and 100 to find the net return
Spreadsheet: 889732d1740648694-list-duplicates-based-on-cell-reference-test8
Sheet: Sheet1

ReturnNo | Line# | SKU | Description | BoxCount |  |  | ReturnNo |  |  |  |  |  | ReturnNo
E_1234 | 1 | 717.6322 | Sale | 2 |  |  | E_1234 |  |  |  |  |  | E_1234
E_1234 | 2 | 818.8011499999999 | Return | 2
E_2345 | 1 | 1200.60115 | Sale | 2 |  |  | Line | Sku | Description | Boxes | Comment |  | Line | Sku | Description | Boxes | Comment
E_2345 | 2 | 1200.6046 | Sale | 1 |  |  |  |  |  |  |  |  | 1 | 717.6322 | Sale | 2
E_2345 | 3 | 1200.60115 | Return | 2 |  |  |  |  |  |  |  |  | 2 | 818.8011499999999 | Return | 2
E_2345 | 4 | 1200.6046 | Return | 1
E_3456 | 1 | 711.8522999999999 | Sale | 1
E_3456 | 2 | 711.8522999999999 | Return | 1
Spreadsheet: 545310d1509395603-modify-formula-in-column-e-to-exclude-recurring-customer-names-in-column-a-book1
Sheet: Sheet1

Customer Name | Region | Division | Category | Sr. No. of Unique Customers per Region per Division per Category (Output by [NAME]) | Sr. No. of Unique Customers per Region per Division per Category (Desired Output)
ABC Communication | Central | CND | Private |  | 1
ABC Communication | Central | CND | Government |  | 0.5
ABC Communication | Central | CND | Semi-Government |  | 1
ABC Communication | Western | CND | Semi-Government |  | 0.33
ABC Communication | Western | CND | Semi-Government |  | 0.33
ABC Communication | Western | CND | Semi-Government |  | 0.33
ABC Communication | Western | END | Semi-Government |  | 1
ABC Communication | Western | CND | Government |  | 1
ABC Communication | Central | CND | Government |  | 0.5
ABC Communication | Central | Multi | Government |  | 1
United Company | Eastern | CND | Private |  | 1
United Company | Western | BBT | Private |  | 0.5
United Company | Western | BBT | Private |  | 0.5
United Company | Central | BBT | Private |  | 1
United Company | Central | CKQ | Private |  | 0.25
United Company | Central | CKQ | Private |  | 0.25
United Company | Central | CKQ | Private |  | 0.25
United Company | Central | CKQ | Private |  | 0.25
Industrial | Central | CKQ | Private |  | 1
Spreadsheet: 0d0106c2-b525-480c-93b6-24bfcba9cb57
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-14 09:22:35.640000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 101.464 | 101.339 | 101.214 | 100.839 |  | and are added to price quote
4.625 | 100.428 | 100.303 | 100.178 | 99.803
4.5 | 99.957 | 99.832 | 99.707 | 99.332 |  | Note: | Refer To Price [NAME]
4.375 | 99.348 | 99.223 | 99.098 | 98.723 |  |  | For all Price Adjs
4.25 | 98.254 | 98.129 | 98.004
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.476 | 101.351 | 101.226 | 100.851
4 | 101.131 | 101.006 | 100.881 | 100.506
3.875 | 100.742 | 100.617 | 100.492 | 100.117
3.75 | 100.208 | 100.083 | 99.958 | 99.583
3.625 | 99.121 | 98.996 | 98.871
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-28 09:22:35.640000
30 DAY | 2011-07-13 09:22:35.640000
45 DAY | 2011-07-28 09:22:35.640000
60 DAY | 2011-08-12 09:22:35.640000
90 DAY | 2011-09-11 09:22:35.640000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 6bce661a-b847-42ca-9701-3faab44bd17e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259018 | 23650 | [NAME] | Dasse | FRA |  | 00:22:49 | 00:01:01 | 00:42:01 | 00:00:49 | 00:12:43 | 1 | 01:19:22
Spreadsheet: 801652d1666281573-reaching-a-minimum-threshold-using-sumif-example-worksheet-costs-1-
Sheet: Sheet1

 | Measure | Cost | Score following measure
 | 1 | 0 | 57.69
 | 2 | 0 | 57.69
 | 3 | 788 | 65.76
 | 4 | 418 | 66.94
 | 5 | 8000 | 75.32
 | 6 | 189 | 75.41
 | 7 | 4114 | 76.79
 | 8 | 718 | 76.97
 | 9 | 1990 | 77.46
 | 10 | 10180 | 79.66
 | 11 | 990 | 79.87
 | 12 | 6512 | 100.53
 | Cost to achieve over 69
Spreadsheet: john_griffith__16151__1_25_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 53 | 160 | 260 | 41.7 | 67.8 | 1.82 | 2002-01-25 10:24:00
 | [NAME] | 54 | 600 | 680 | 47.9 | 54.4 | 1.74 | 2002-01-25 10:24:00
 | HO J2 | 54 | 825 | 925 | 48 | 53.8 | 1.73 | 2002-01-25 10:24:00
 | HO K2 | 54 | 950 | 1050 | 44.9 | 49.7 | 1.61 | 2002-01-25 10:24:00
 | HO M2 | 54 | 1075 | 1175 | 43.7 | 47.8 | 1.55 | 2002-01-25 10:24:00
 | HO N2 | 54 | 1125 | 1225 | 41.4 | 45.1 | 1.47 | 2002-01-25 10:24:00
 | HO Q2 | 55 | 1200 | 1300 | 39.7 | 43 | 1.43 | 2002-01-25 10:24:00
 | HO U2 | 56 | 1275 | 1375 | 38.3 | 41.4 | 1.4 | 2002-01-25 10:24:00
 | [NAME] | 57 | 1300 | 1450 | 36.1 | 40.3 | 1.37 | 2002-01-25 10:24:00
 | HO X2 | 58 | 1375 | 1525 | 35.4 | 39.3 | 1.36 | 2002-01-25 10:24:00
 | [NAME] | 59 | 1400 | 1550 | 33.9 | 37.6 | 1.33 | 2002-01-25 10:24:00
 | HO F3 | 59 | 1425 | 1625 | 33.1 | 37.8 | 1.31 | 2002-01-25 10:24:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]