tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30150__9907_OA
Sheet: STG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ALL
REGION:  STORAGE
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  | 0
2 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  | Interdesk |  |  |  |  |  |  |  |  |  |  |  | 1428267 |  |  |  |  |  | -14792 |  |  |  | -17413
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 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
23 | Fuel: |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | -43915 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate |  |  |  |  |  |  |  | 123262
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  | 0 |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | -213900 |  |  |  | -156221.76 |  | 16908
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  |  |  |  |  |  |  |  |  | -376583
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | -225 |  | 0
 |  | TOTAL
Spreadsheet: 54d88a68-0f8f-46f6-a55a-872a5173cd1a
Sheet: 6174

[NAME]'s constant
Four digits |  | 1234 |  |  |  |  |  |  |  |  |  | Please enter four digits
 |  |  |  |  |  |  |  |  |  |  |  | Please, at least two different digits
Attempt | #1 | #2 | Outcome
www.excel.is | [NAME] | [NAME] | [NAME]
Spreadsheet: 109143d1306075281-search-table-values-salary
Sheet: Sheet1

[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
1 | 8287 | 8393 | 8501 | 8610 | 8721 | 8834 | 8948 | 9064
2 | 8932 | 9047 | 9162 | 9281 | 9400 | 9522 | 9646 | 9772
3 | 9628 | 9751 | 9876 | 10004 | 10133 | 10265 | 10398 | 10534
4 | 10358 | 10491 | 10626 | 10763 | 10904 | 11045 | 11189 | 11335
5 | 11145 | 11288 | 11434 | 11581 | 11732 | 11884 | 12040 | 12197
6 | 11992 | 12146 | 12302 | 12462 | 12624 | 12788 | 12955 | 13125
7 | 12880 | 13045 | 13213 | 13384 | 13558 | 13734 | 13913 | 14096
8 | 13833 | 14011 | 14192 | 14375 | 14561 | 14750 | 14942 | 15138
9 | 14857 | 15048 | 15242 | 15439 | 15639 | 15842 | 16048 | 16257
10 | 15948 | 16153 | 16360 | 16571 | 16786 | 17003 | 17225 | 17449
11 | 17099 | 17318 | 17540 | 17765 | 17994 | 18227 | 18464 | 18703
12 | 18333 | 18568 | 18805 | 19047 | 19291 | 19541 | 19793 | 20050
13 | 19658 | 19908 | 20162 | 20420 | 20682 | 20948 | 21219 | 21493
14 | 21078 | 21346 | 21618 | 21894 | 22174 | 22459 | 22748 | 23041
15 | 22688 | 22994 | 23305 | 23621 | 23941 | 24266 | 24598 | 24934
16 | 24423 | 24752 | 25085 | 25424 | 25767 | 26117 | 26472 | 26832
17 | 26292 | 26644 | 27002 | 27366 | 27736 | 28110 | 28491 | 28878
18 | 28305 | 28684 | 29068 | 29458 | 29854 | 30256 | 30666 | 31080
19 | 30474 | 30880 | 31292 | 31711 | 32137 | 32568 | 33008 | 33453
20 | 32810 | 33246 | 33688 | 34140 | 34596 | 35059 | 35530 | 36009
21 | 35219 | 35685 | 36158 | 36638 | 37125 | 37620 | 38123 | 38633
22 | 37812 | 38310 | 38815 | 39327 | 39848 | 40376 | 40913 | 41457
23 | 40604 | 41136 | 41676 | 42223 | 42778 | 43343 | 43916 | 44498
24 | 43612 | 44179 | 44756 | 45340 | 45934 | 46537 | 47148 | 47769
25 | 46848 | 47456 | 48071 | 48696 | 49330 | 49974 | 50268 | 51292
26 | 50334 | 50982 | 51642 | 52310 | 52988 | 53676 | 54374 | 55083
27 | 54088 | 54782 | 55487 | 56201 | 56926 | 57662 | 58408 | 59166
28 | 58132 | 58874 | 59628 | 60392 | 61167 | 61953 | 62752 | 53562
29 | 62488 | 63282 | 64088 | 64905 | 65735 | 66576 | 67431 | 58296
30 | 67944 | 68814 | 69697 | 70592 | 71500 | 72422 | 73356 | 74305
31 | 79729 | 80777 | 81841 | 82921 | 84017 | 85130 | 86261 | 87408
32 | 91226 | 92425 | 93642 | 94878 | 96132 | 97405 | 98698 | 100011
33 | 107470
Spreadsheet: 21248d1208467746-allowing-text-based-on-a-few-things-magazinetest
Sheet: Magazine List

Magazine | Issue | # of Copies Received | Distribution Date | GB | MC | AD | ML | BR | KP | RL | MI | SN | CT | GJ
Abitare | 2007-03-01 00:00:00 | 1 | July 3, 2007
Abitare | 2007-04-01 00:00:00 | 1 | Oct. 17, 2007
Bravacasa | 2008-05-01 00:00:00 | 1 | Aug. 22, 2007
Building Operating Management | 2007-05-01 00:00:00 | 1 | Aug. 30, 2007
Business 2.0 | 2007-05-01 00:00:00 | 1 | Sept. 25, 2007
Business 2.0 | 2007-06-01 00:00:00 | 1 | Jan. 9, 2008
[NAME]'s | 2007-11-19 00:00:00 | 1 | March 7, 2008
[NAME]'s | 2007-11-26 00:00:00 | 2 | Feb. 12, 2008
[NAME]'s | 2007-12-03 00:00:00 | 2 | March 7, 2008
[NAME]'s | 2007-12-10 00:00:00 | 2 | Feb. 4, 2008
d(x)I | 2008-03-01 00:00:00 | 2 | Apr. 15, 2008
Spreadsheet: john_griffith__16012__2_4_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 59 | 525 | 625 | 46.6 | 55.5 | 1.89 | 2002-02-04 10:18:00
 | [NAME] | 66 | 560 | 660 | 29.2 | 34.4 | 1.32 | 2002-02-04 10:18:00
 | [NAME] | 66 | 1070 | 1170 | 43.8 | 48 | 1.9 | 2002-02-04 10:18:00
 | [NAME] | 66 | 1230 | 1330 | 42.6 | 46.1 | 1.84 | 2002-02-04 10:18:00
 | HU N2 | 66 | 1300 | 1400 | 40.4 | 43.6 | 1.74 | 2002-02-04 10:18:00
 | [NAME] | 65 | 1350 | 1450 | 38.7 | 41.6 | 1.64 | 2002-02-04 10:18:00
 | HU U2 | 63 | 1360 | 1460 | 37.2 | 39.9 | 1.53 | 2002-02-04 10:18:00
 | [NAME] | 60 | 1325 | 1425 | 35.7 | 38.4 | 1.4 | 2002-02-04 10:18:00
 | [NAME] | 60 | 1300 | 1450 | 32.9 | 36.7 | 1.31 | 2002-02-04 10:18:00
 | [NAME] | 60 | 1300 | 1450 | 31.4 | 35.1 | 1.25 | 2002-02-04 10:18:00
 | HU F3 | 60 | 1300 | 1450 | 30.1 | 33.6 | 1.2 | 2002-02-04 10:18:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | HU H3
 | [NAME]
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU M3
Spreadsheet: 809649d1671198436-index-and-match-from-2nd-sheet-update-dis-ans
Sheet: Sheet2

Code | Place to buy from | Price | Discount
Azb123 | Mall
987KUH | Metro station
BU7663 | Online shops
BU7664 | Metro station
BU7665 | Mall
BU7666 | Online shops
BU7667 | Mall
Spreadsheet: 271467d1381945771-want-to-lookup-multiple-matching-criteria-and-return-multiple-data-in-columns-sample
Sheet: Sheet1

Source Data
Equipment type | stop sequence | depart time | return time
30 | 1 | 09:00:00 | 12:00:00
30 | 2 | 09:00:00 | 12:00:00
30 | 3 | 09:00:00 | 12:00:00
48 | 1 | 10:00:00 | 11:00:00
52 | 1 | 07:00:00 | 15:00:00
52 | 2 | 07:00:00 | 15:00:00
52 | 3 | 07:00:00 | 15:00:00
52 | 4 | 07:00:00 | 15:00:00
30 | 1 | 13:00:00 | 19:00:00
30 | 2 | 13:00:00 | 19:00:00
Desired output
52 |  | 48 |  | 30
[NAME] | Return | [NAME] | Return | [NAME] | Return
07:00:00 | 15:00:00 | 10:00:00 | 11:00:00 | 09:00:00 | 12:00:00
 |  |  |  | 13:00:00 | 19:00:00
Spreadsheet: 1427bbab-c30e-4139-aeb3-b89ad84693d5
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: |  |  | 2013-12-27 09:26:19.900000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 102.499 | 102.374 | 102.249 | 101.874 |  | and are added to price quote
4.875 | 101.913 | 101.788 | 101.663 | 101.288
4.75 | 101.387 | 101.262 | 101.137 | 100.762 |  | Note: | Refer To Price [NAME]
4.625 | 100.598 | 100.473 | 100.348 | 99.973 |  |  | For all Price Adjs
4.5 | 99.607 | 99.482 | 99.357 | 98.732
4.375 | 98.569 | 98.444 | 98.319 | 97.694
4.25 | 97.974 | 97.849 | 97.724 | 97.099
4.125 | 97.104 | 96.979 | 96.854 | 96.229
4 | 96.028 | 95.903 | 95.778 | 95.153 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.251 | 102.126 | 102.001 | 101.626
3.875 | 101.514 | 101.389 | 101.264 | 100.889
3.75 | 100.8 | 100.675 | 100.55 | 100.175
3.625 | 100.406 | 100.281 | 100.156 | 99.781
3.5 | 99.829 | 99.704 | 99.579 | 98.954
3.375 | 99.064 | 98.939 | 98.814 | 98.189
3.25 | 98.26 | 98.135 | 98.01 | 97.385 |  | 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 | 2014-01-10 09:26:19.900000
30 DAY | 2014-01-25 09:26:19.900000
45 DAY | 2014-02-09 09:26:19.900000
60 DAY | 2014-02-24 09:26:19.900000
90 DAY | 2014-03-26 09:26:19.900000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 328280d1403853297-vlookup-to-hyperlink-to-cell-on-same-worksheet-vlookup-to-hyperlink-to-cell-on-same-worksheet
Sheet: Sheet1

 | Enter [NAME] | Hyperlink to Number
 | d
 |  |  |  | List | Number
 |  |  |  | a | 2
 |  |  |  | b | 3
 |  |  |  | c | 4
 |  |  |  | d | 5
 |  |  |  | e | 6
 |  |  |  | f | 7
 |  |  |  | g | 8
 | I need to find a way to incorporate a hyperlink in the vlookup cell (C3) to the corrisponding cell column F (F7)
Spreadsheet: lindy_donoho__21978__tw_priority_rate
Sheet: Eff Nov 1, 2001 - Dec 31, 2001

Transwestern Pipeline Company
Contracts Under the Global Settlement
Priority Rates (Reservation and Demand Surcharges)
Contract | Shipper | Receipt to Delivery | Reservation | Shared Cost | TCR II No. 1 | TCR II No. 2 | GRI Demand | Total |  | Commodity | ACA | GRI
Number | Name | Area | Rate | Surcharge | Surcharge | Surcharge | Surcharge | Rate |  | Rate | Surcharge | Surcharge
8255 | Southern California Gas Company | East of Thoreau to California (W. of Thoreau) | 0.3297 | - | 0.0051 | 0.0007 | 0.003 |  |  | 0.0243 | 0.0021 | 0.007
20834 | Citizens Utilities Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1074 | - | - | - | - |  |  | 0.0011 | - | -
20835 | Conoco Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1074 | - | - | - | - |  |  | 0.0011 | - | -
21175 | Pacific Gas & Electric Company(Gas) | San Juan Lateral to Thoreau/San Juan Pt. | 0.1074 | - | - | - | - |  |  | 0.0011 | - | -
26677 | El Paso Energy Marketing Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1074 | - | - | - | - |  |  | 0.0011 | - | -
26371 | Duke Energy Trading and Marketing. LLC | San Juan Lateral to Thoreau/San Juan Pt. | 0.1074 | - | - | - | - |  |  | 0.0011 | - | -
25923 | Texaco Natural Gas Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1074 | - | - | - | - |  |  | 0.0011 | - | -
20715 | Southern California Gas Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1074 | - | - | - | - |  |  | 0.0011 | - | -
20747 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2659 | - | 0.005 | 0.0007 | 0.003 |  |  | 0.0165 | 0.0021 | 0.007
20748 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2659 | - | 0.005 | 0.0007 | 0.0018 |  |  | 0.0165 | 0.0021 | 0.007
21165 | Pacific Gas & Electric Company(Gas) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2659 | - | 0.0051 | 0.0007 | 0.003 |  |  | 0.0165 | 0.0021 | 0.007
26678 | El Paso Energy Marketing Company | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2659 | - | 0.005 | 0.0007 | 0.003 |  |  | 0.0165 | 0.0021 | 0.007
26372 | Duke Energy Trading and Marketing. LLC | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2659 | - | 0.005 | 0.0007 | 0.003 |  |  | 0.0165 | 0.0021 | 0.007
25924 | Texaco Natural Gas Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2659 | - | 0.0051 | 0.0007 | - |  |  | 0.0165 | 0.0021 | -
20822 | Citizens Utilities Company | Thoreau/San Juan Pt. to East of California (W. of Thoreau) | 0.1715 | - | 0.0027 | 0.0004 | 0.0018 |  |  | 0.0165 | 0.0021 | 0.007
NOTE --- | Per CBS Negotiated Rate System, the termination date for the rates listed above are as follows:
 | Reservation | Recalculation eff every Nov 1st
 | SCS | 2001-10-31 00:00:00
 | TCR II No. 1 | 2005-10-31 00:00:00
 | TCR II No. 2 | 2006-10-31 00:00:00
 | GRI Demand | Recalculation eff every Jan 1st **
 | ** Calculation made every year to determine which contracts are High Load vs. Low Load
Spreadsheet: bb5de293-6d25-453e-87ac-2ac8e64b949b
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (30 [NAME]):
 | 3 Mess-, [NAME] und Qualitätskontrolle 3.5 Thermische Größen
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | AES Chemunex | Frankreich | Bruz | 35172 | B1.214
2 | [NAME] GmbH | Deutschland | Hamburg | 22297 | B1.121/220
3 | [NAME] | Österreich | Graz | 8054 | A2.110
4 | BÄHR-Thermoanalyse GmbH | Deutschland | [NAME] | 32609 | A1.234A
5 | Büchi Labortechnik GmbH | Deutschland | Essen | 45127 | A2.405
6 | Bürkert GmbH & Co. [NAME] | Deutschland | Ingelfingen | 74653 | A1.304
7 | [NAME] und Analysentechnik GmbH | Deutschland | Haar | 85540 | [NAME]
8 | ebro Electronic GmbH | Deutschland | Ingolstadt | 85055 | A1.201/302
9 | Ellab GmbH | Deutschland | Bockel | 27404 | B1.501
10 | Invensys Systems GmbH >EUROTHERM< | Deutschland | Limburg | 65549 | B2.418
11 | GE Healthcare | Deutschland | München | 80807 | A3.331/430
12 | [NAME] Kältemaschinenbau GmbH | Deutschland | Offenburg | 77656 | B2.311/414
13 | IKS International bv | Niederlande | Rosmalen | 5249 JK | A3.263
14 | Julabo Labortechnik GmbH | Deutschland | Seelbach | 77960 | [NAME]
15 | LECO Instrumente GmbH | Deutschland | Mönchengladbach | 41199 | A1.324
16 | LEONI Fiber Optics GmbH | Deutschland | Neuhaus-Schierschnitz | 96524 | A2.234
17 | Mettler-Toledo GmbH | Deutschland | Gießen | 35396 | A2.101/202
18 | Netzsch-Gerätebau GmbH | Deutschland | Selb | 95100 | A1.301
19 | Parr Instrument (Deutschland) GmbH | Deutschland | Frankfurt | 60439 | A2.226
20 | [NAME] | Deutschland | Waldbronn | 76337 | A2.217
21 | ProSense GmbH | Deutschland | München | 81545 | A2.239
22 | Ludwig Schneider GmbH & Co.[NAME] | Deutschland | Wertheim a. M. | 97877 | B1.121/220
23 | SETARAM Instrumentation | Frankreich | Caluire | 69300 | A1.333/430B
24 | SOCACHIM Sprl | Belgien | Brüssel | 1200 | A1.238
25 | SOLITON GmbH | Deutschland | Gilching | 82205 | A1.402
26 | TA Instruments Unternehmensbereich Waters GmbH | Deutschland | Eschborn | 65760 | A1.234B
27 | Telemeter Electronic GmbH | Deutschland | Donauwörth | 86609 | A2.502
28 | Testo AG | Deutschland | Lenzkirch | 79853 | A1.125/222
29 | Thass Thermal Analysis & Surface Solutions GmbH | Deutschland | Friedberg | 61169 | A1.227
30 | THERMOCOAX GmbH | Deutschland | Stapelfeld | 22145 | A2.442
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr-Najla Almery

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation after deducting 5% Admin | 0.5
 |  | Procedure in Clinics after deducting consumables and 5% Admin | 0.5
 |  | OR in Clinics from gross (40% & 70%)
 |  | OR outside Clinics after hospital expenses and 5% Admin | 0.6
Doctor Calculation
 |  | Gross Revenue | 136147.5
 |  | Doctor Revenue
 |  | Consultation Revenue | 11937
 |  | Net Revenue
 |  | Amount to be paid
 |  | [NAME] (65%)
 |  | Clinics Share (35%)
 |  | Amount to be Paid
 |  | Procedure in the Clinics Revenue | 34871
 |  | Consumables | 28285.3
 |  | Depreciation | 1000
 |  | Net Revenue
 |  | Amount to be paid
 |  | OR in the Clinics Revenue | 28230
 |  | Consumables | 0
 |  | Net Revenue
 |  | Doctor [NAME] (40%)
 |  | OR in the Clinics Revenue- Complex | 58513
 |  | Doctor [NAME] (70%)
 |  | Amount to be paid
 |  | OR outside the Clinics Revenue | 0
 |  | Hospital Fees | 0
 |  | Net Revenue
 |  | Amount to be paid
 |  | Total Amount to be Paid
 |  | Deduction
 |  | External Anesthesia Commission
 |  | OHE 5%
 |  | [NAME] | 3500
 |  | Nurses Overtime
 |  | Amount Earned by the Doctor
 |  | Less: Advance Payment (Salary) | 31587 | Salary of Nov 2023
 |  | Remaining Balance for the Doctor
Prepared By …................. |  |  | CFO: | .......................
Spreadsheet: 878195d1725256976-filtering-duplicate-values-mosom20
Sheet: Sheet1

Data that I have: |  |  |  |  |  |  |  | I can get the duplicate rows up to the user's first row: |  |  |  |  |  |  |  |  |  | I can then list them better: |  |  |  |  |  |  |  |  |  | What I want (unique users, unique roles):
Anakin | Skywalker |  | Role 1 | Role 2 | Role 3 |  |  |  | Role 4 | 0 | 0 |  |  |  |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 2 | Role 4 |  |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4
Anakin | Skywalker |  | Role 2 | Role 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 2 | Role 4 |  |  |  |  |  |  |  | Princess Leia | Role 1 | Role 2 | Role 3 | Role 4
Princess | Leia |  | Role 1 | Role 2 | Role 3 | Role 4 |  |  | Role 4 | 0 | 0 |  |  |  |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 3 | Role 4 |  |  |  | Han Solo | Role 1 | Role 2 | Role 3 | Role 4 | Role 5
Princess | Leia |  | Role 3 | Role 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 3 | Role 4 |  |  |  |  |  |  |  | [NAME] | Role 1 | Role 2 | Role 3 | Role 4 | Role 5 | Role 6
Han | Solo |  | Role 1 |  |  |  |  |  | Role 3 | Role 4 | 0 |  |  | Role 3 | Role 5 | 0 |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 2 | Role 3 | Role 5 |  |  | Obi [NAME] | Role 1 | Role 2
Han | Solo |  | Role 2 | Role 3 | Role 4 |  |  |  | Role 3 | Role 5 | 0 |  |  |  |  |  |  |  | Role 2 | Role 3 | Role 4 | Role 2 | Role 3 | Role 5 |  |  |  | [NAME] | Role 3 | Role 4
Han | Solo |  | Role 2 | Role 3 | Role 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 2 | Role 3 | Role 5
[NAME] | Skywalker |  | Role 5 | Role 6 |  |  |  |  | Role 3 | 0 | 0 |  |  | Role 3 | Role 4 | 0 |  |  | Role 5 | Role 6 | Role 1 | Role 3 | Role 2 | Role 3 | Role 4
[NAME] | Skywalker |  | Role 1 | Role 3 |  |  |  |  | Role 3 | Role 4 | 0 |  |  |  |  |  |  |  | Role 1 | Role 3 | Role 2 | Role 3 | Role 4
[NAME] | Skywalker |  | Role 2 | Role 3 | Role 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 2 | Role 3 | Role 4
Obi Wan | Kenobi |  | Role 1 | Role 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 1 | Role 2
[NAME] | [NAME] |  | Role 3 | Role 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 3 | Role 4
the data lists users' access in different areas, and thus has duplicates, both in users and in roles. |  |  |  |  |  |  |  | I've managed to bring any roles from duplicates users up to the first instance of the user, but |  |  |  |  |  |  |  |  |  | I've managed to list the roles without the spaces, but the duplicate users and the duplicate roles are still there |  |  |  |  |  |  |  |  |  | What I want is a list of unique users, with their unique list of roles. The order of the roles doesn’t matter.
 |  |  |  |  |  |  |  | duplicates roles are still there
Spreadsheet: 93348d1292947958-v-lookup-with-2-options-work-order-tracking-example
Sheet: LookupTbl_Inspectors

FacilityNumber | InspectorLastName | InspectorFirstName | AreaCommanderLastName
CO0527 | MOORE | SCOTT | FEENEY
CO0530 | WILLIAMSON | [NAME] | FEENEY
CO0624 | FROST | JEFFREY | LUNDY
CO1977 | WIEDENBECK | STEPHEN | FEENEY
ND0046 | MORENO | EDUARDO | BUSCHY
UT0032 | WILLIAMSON | [NAME] | FEENEY
Spreadsheet: 755553d1636955698-retrieve-specific-no-text-date-from-string-of-text-data_file
Sheet: Sheet1

Incorrect
Raw Data | Result (retrieve the numbers and underscore only - omit other characters) | Result (retrieve only 8 digits that are joined together) | Result (retrieve only the first date, if any, shld be in DD/MM/YYYY) | Result (retrieve second date in string, if any, shld be in DD/MM/YYYY)
Raja 20211113_83378- complete his project of 23/10/2021, by 25/10/2021
[NAME] has 81918191, by 21/10/2021 of 26/11/2021-
[NAME] has ABCD-1212-14444-4444 of 8811001 by 24/11/2021,
[NAME] has 2029221_2291A by 28/10/2021
[NAME] wants ABCD-111-222-991 of 25/10/2021*
Correct
Raw Data | Result (retrieve the numbers and underscore only - omit other characters) | Result (retrieve only 7 or 8 digits that are joined together) | Result (retrieve only the first date, if any, shld be in DD/MM/YYYY) | Result (retrieve second date in string, if any, shld be in DD/MM/YYYY)
Raja 20211113_83378- complete his project of 23/10/2021, by 25/10/2021 | 20211113_83378 | #N/A | 2021-10-23 00:00:00 | 2021-10-25 00:00:00
[NAME] has 81918191 by 21/10/2021 of 26/11/2021- | #N/A | 81918191 | 2021-10-21 00:00:00 | 2021-11-26 00:00:00
[NAME] has ABCD-1212-14444-4444 of 8811001 by 24/11/2021, | #N/A | 88110011 | 2021-11-24 00:00:00 | #N/A
[NAME] has 2029221_2291A by 28/10/2021 | 2029221_2291 | #N/A | 2021-10-28 00:00:00 | #N/A
[NAME] wants ABCD-111-222-991 of 25/10/2021* | #N/A | #N/A | 2021-10-25 00:00:00 | #N/A
Spreadsheet: 112685d1308731883-predictive-date-formula-excel-predictive-days-test
Sheet: Sheet1

 |  |  |  |  |  |  | Invoiced Days |  |  |  |  |  |  | 2011 Bank Holidays
Consultant | Start Date | End Date | PO days | Days Left on PO | Proposed End |  | Mar | Apr | May | Jun | Jul | Total |  | New Year's Day | 2011-01-03 00:00:00 | Monday
[NAME] | 2011-03-24 00:00:00 | 2011-06-22 00:00:00 | 60 |  |  |  | 6 | 15 | 16 | 0 | 0 |  |  | Good Friday | 2011-04-22 00:00:00 | Friday
Dr Acula | 2011-06-01 00:00:00 | 2011-08-23 00:00:00 | 60 |  |  |  |  |  |  |  |  |  |  | Easter Monday | 2011-04-25 00:00:00 | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | The Royal Wedding | 2011-04-29 00:00:00 | Friday
 |  |  |  |  | Month Start |  |  |  |  |  |  |  |  | May Day Holiday | 2011-05-02 00:00:00 | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Spring Bank Holiday | 2011-05-30 00:00:00 | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer Bank Holiday | 2011-08-29 00:00:00 | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Boxing Day Holiday | 2011-12-26 00:00:00 | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day Holiday | 2011-12-27 00:00:00 | Tuesday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2012-01-02 00:00:00 | Monday
Spreadsheet: 38524d1236690114-summarizing-data-over-several-sheets-new-bolts-list
Sheet: BoltsP1

 | BOLTS LIST | BOLTS LIST
CLIENT |  |  |  |  |  | JOB No. |  | A
PLANT |  |  |  |  |  |  | LIST No.   1   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
1 | 56 |  | 50 | M12
2 | 40 |  |  | M16
3 | 30 |  |  | M16
4 | 30 |  |  | M10
5 | 100 |  |  | M12
6 | 80 |  |  | M20
7 | 60 |  |  | M20
8 | 40 |  |  | M12
9 | 50 |  |  | M12
10 | 30 |  |  | M16
11
12
13
14
15
16
17
18
19