tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a3cbd930-f84c-4d08-8795-3b1ba338bb29
Sheet: Sheet1

Global X MLP ETF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Fund Holdings Data as of 4/17/2014
% of Net Assets | Name | Identifier | Market Price($) | Shares Held | Market Value($)
5.61 | SPECTRA ENERGY PARTNERS | 84756N109 | 53.63 | 93234 | 5000139.42
5.38 | ENTERPRISE PRODUCTS PRTNR | 293792107 | 72.95 | 65714 | 4793836.3
5.37 | MAGELLAN MIDSTREAM | 559080106 | 73.12 | 65377 | 4780366.24
5.36 | PLAINS ALL AMERN PIP | 726503105 | 57.09 | 83573 | 4771182.57
5.32 | [NAME] PARTNERS | 118230101 | 76.85 | 61652 | 4737956.2
5.3 | KINDER MORGAN ENERGY PRTN | 494550106 | 77.49 | 60907 | 4719683.43
5.29 | ACCESS MIDSTREAM PARTNERS | 00434L109 | 58.93 | 79968 | 4712514.24
5.23 | ENERGY TRANSFER PARTNERSP | 29273R109 | 56.06 | 83093 | 4658193.58
5.13 | [NAME] PARTNERS LP | 96950F104 | 51.25 | 89140 | 4568425
5.05 | ONEOK PARTNERS LP | 68268N103 | 56.7 | 79335 | 4498294.5
5 | MARKWEST ENERGY-PART UTS | 570759100 | 64.87 | 68726 | 4458255.62
3.96 | SUNOCO LOGISTICS PRTS | 86764L108 | 88.37 | 39900 | 3525963
3.89 | TARGA RESOURCES PARTNERS | 87611X105 | 61.33 | 56459 | 3462630.47
3.85 | ENBRIDGE ENERGY PARTNERS | 29250R106 | 28.94 | 118383 | 3426004.02
2.95 | REGENCY ENERGY PARTNERS | 75885Y107 | 27.05 | 97202.5 | 2629327.63
2.87 | WESTERN GAS PARTNERS L.P. | 958254104 | 67.44 | 37957 | 2559820.08
2.77 | DCP MIDSTREAM PARTNER LLP | 23311P100 | 51.84 | 47571 | 2466080.64
2.7 | EL PASO PIPELINE PART LP | 283702108 | 33.16 | 72527 | 2404995.32
2.65 | NUSTAR ENERGY LP | 67058H102 | 55.1 | 42851 | 2361090.1
2.36 | GENESIS ENERGY L.P. | 371927104 | 55.26 | 38097 | 2105240.22
2.27 | AMERIGAS PARTNERS-LP | 030975106 | 44.42 | 45510 | 2021554.2
2.26 | CRESTWOOD MIDSTREAM PART | 226378107 | 24.07 | 83474 | 2009219.18
1.78 | ENLINK MIDSTREAM PARTNERS | 29336U107 | 30.5 | 52124 | 1589782
1.6 | SUBURBAN PROPANE PARTNERS | 864482104 | 42.9 | 33297 | 1428441.3
1.46 | ATLAS PIPELINE PARTNERS | 049392103 | 32.19 | 40408 | 1300733.52
1.46 | [NAME] | 87233Q108 | 50.3 | 25802 | 1297840.6
1.41 | TESORO LOGISTICS LP | 88160T107 | 62.43 | 20092 | 1254343.56
1.33 | NGL ENERGY PARTNERS LP | 62913M107 | 38.11 | 31082 | 1184535.02
1.13 | ALLIANCE RESOURCE PTNRLP | 01877R108 | 84.6 | 11857 | 1003102.2
1.01 | EV ENERGY PARTNERS L.P. | 26926V107 | 35.9 | 25075 | 900192.5
0.97 | NORTHERN TIER ENERGY LP | 665826103 | 26.81 | 32297 | 865882.57
0.96 | CRESTWOOD EQUITY PARTNERS | 226344109 | 13.8 | 61915 | 854427
0.95 | [NAME]. PART. | 096627104 | 15.72 | 53782 | 845453.04
0.71 | CHENIERE ENERGY PARTNERS | 16411Q101 | 33.8 | 18624 | 629491.2
0.69 | NATURAL RESOURCE PART. LP | 63900P103 | 16.17 | 37755 | 610498.35
0.02 | CASH | CASH | 1 | 14290.4 | 14290.4
Spreadsheet: 919e47f9-a98d-4251-b5ce-d255f17f985e
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38627423 | 2013-11-20 10:11:06 | AXIS | 1 | 5 | 4 | 1007284 | Temple58 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
38627572 | 2013-11-20 10:26:38 | ALLIES | 0 | 3 | 5 | 1007284 | Temple58 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
38647786 | 2013-11-21 21:59:35 | AXIS | 0 | 3 | 6 | 506159 | Hurletout | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38648006 | 2013-11-21 22:14:28 | ALLIES | 1 | 6 | 3 | 506159 | Hurletout | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38648207 | 2013-11-21 22:42:55 | ALLIES | 0 | 5 | 6 | 1382057 | diallo65 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
38648606 | 2013-11-21 22:59:00 | AXIS | 0 | 1 | 6 | 1382057 | diallo65 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
38804679 | 2013-12-02 19:24:15 | ALLIES | 1 | 4 | 3 | 1351059 | misterfunny | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
38804846 | 2013-12-02 19:33:39 | AXIS | 1 | 4 | 2 | 1351059 | misterfunny | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
Spreadsheet: 827685d1682953603-if-statement-to-find-number-between-range-written-in-one-cell-xlookup-with-left-aligw
Sheet: Sheet1

Code | Description |  | Range | Description |  | t |  | tt |  | f |  | FINAL
1019 |  |  | 1000:1100 + 3101 + 4001 | Buttermilk |  |  | 4001 Buttermilk |  | Buttermilk |  | Buttermilk
2039 |  |  | 1101:2100 + 5005 | Pistcahio |  | 5005 Pistcahio | 0 Pistcahio | 4001 | Buttermilk | 4001 | Buttermilk
1110 |  |  | 2101:3100 | [NAME] |  | 0 [NAME] | 0 [NAME] | 5005 | Pistcahio | 5005 | Pistcahio
3101 |  |  |  |  |  |  |  | 0 | Pistcahio
 |  |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  |  |  | Here to show how the formula works.
Spreadsheet: 54309d1254317919-how-to-calculate-a-total-dependant-on-variables-preq-20template-1-
Sheet: Sheet1

 |  |  | Purchase Requisition
 | All items marked with a * must be completed by requester
 |  |  |  | *Delivery Address |  |  |  | Order No. Issued by [NAME]
 | *Requester's Name
 | Department & Tel. No. |  |  |  |  |  |  | *Division Cost Centre
 | *Suggested Supplier :
 | *Suppliers Address:
 |  |  |  |  |  |  |  | *Requesters Reference No.
 | Suppliers A/C Number
 | Quote / Contract Ref |  |  |  |  |  |  | *Today's date
 | *Delivery Date Required |  |  |  |  |  |  | 2009-09-30 00:00:00
 |  | (Important :Delivery Date must be a date.  [NAME] will be acted on before " ASAP" )
pos | Product Code | *Description of Material / Services | *Unit of | *Quantity | *Unit Price | *Line Value | *Project Code |  | Activity | *Tax
 |  | Everything the supplier will charge you for should be detailed  on this Requisition…eg. Carriage : Service Costs etc | Purchase |  | + | ex VAT |  |  | Code | System
1 |  | Stuff | EA | 1 | 100 | 85 | X |  | X | A
2 |  | More Stuff | EA | 2 | 50 | 95 | X |  | X | B
3 |  | Yet More Stuff | EA | 1 | 25 | 25 | X |  | X | Z
4 |  |  |  |  |  | 0 |  |  |  | Z
5 |  |  |  |  |  | 0 |  |  |  | Z
6 |  |  |  |  |  | 0 |  |  |  | Z
7 |  |  |  |  |  | 0 |  |  |  | Z
8 |  |  |  |  |  | 0 |  |  |  | Z
9 |  |  |  |  |  | 0 |  |  |  | Z
10 |  |  |  |  |  | 0 |  |  |  | Z
 |  |  |  |  | Order Value | 205
 | Tax System
A | 0.15 | VAT
B | 0.05 | VAT
M | 0 | Medical Use
E | 0.5 | Exempt
Z | 0 | Zero Rated
Spreadsheet: 710477d1609005672-assign-installment-payment-automatically-across-time-line-test-2
Sheet: Sheet1

Assumptions:
1. Deposit | Type | Nos of installments | Deposit % | Deposit ($) | Sale start date | Sale end date |  | 2. Principle | 1000000
 | Installment 1 | 12 |  |  | 2021-01-30 00:00:00
 | Installment 2 | 24 |  |  | 2021-04-01 00:00:00
 | Installment 3 | 36 |  |  | 2021-12-15 00:00:00
 | Installment 4 | 48 |  |  | 2022-03-03 00:00:00
 | Installment 5 | 60 |  |  | 2022-05-01 00:00:00
2. Calculations
Date | Nos | 2021-01-30 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | 2026-01-31 00:00:00 | 2026-02-28 00:00:00 | 2026-03-31 00:00:00 | 2026-04-30 00:00:00 | 2026-05-31 00:00:00 | 2026-06-30 00:00:00 | 2026-07-31 00:00:00 | 2026-08-31 00:00:00 | 2026-09-30 00:00:00 | 2026-10-31 00:00:00 | 2026-11-30 00:00:00 | 2026-12-31 00:00:00 | 2027-01-31 00:00:00 | 2027-02-28 00:00:00 | 2027-03-31 00:00:00 | 2027-04-30 00:00:00 | 2027-05-31 00:00:00
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
Spreadsheet: 42261d1240865475-sum-of-cells-with-a-variable-cell-multiplier-itc-scoring_sheet
Sheet: Rifle

 |  |  |  |  | Rifle ITC
 |  |  |  |  | PHASE 1 |  |  |  | PHASE 2 |  |  |  |  |  |  |  | AWARDS
 |  |  |  |  | 40 | Target time |  |  | 55 | Target Time
 |  |  | Member |  | Time | Missed Targets | Score |  | Time | Missed Targets | Score |  | Total | Award |  |  | Gold | Silver | [NAME]
 |  | 1 | [NAME] |  | 40 | 0 | 50 |  | 55 | 0 | 50 |  | 100 | Gold |  |  | [NAME] | [NAME] | [NAME]
 |  | 2 | [NAME] |  | 50 | 0 | 20 |  | 55 | 0 | 50 |  | 70 | [NAME] |  |  | [NAME] | [NAME] | [NAME]
 |  | 3 | [NAME] |  | 45 | 0 | 35 |  | 55 | 0 | 50 |  | 85 | Silver |  |  | [NAME] | [NAME] | [NAME]
 |  | 4 | [NAME] |  | 60 | 0 | -10 |  | 55 | 0 | 50 |  | 40 |  |  |  | [NAME] | [NAME] | [NAME]
 |  | 5 | tom |  | 41 | 0 | 47 |  | 55 | 0 | 50 |  | 97 | Gold |  |  | [NAME] | [NAME] | [NAME]
 |  | 6 | ernie |  | 39 | 1 | 43 |  | 55 | 0 | 50 |  | 93 | Gold |  |  | [NAME] | [NAME] | [NAME]
 |  | 7 | Lesley |  | 42 | 1 | 36 |  | 55 | 0 | 50 |  | 86 | Silver |  |  | [NAME] | [NAME] | [NAME]
 |  | 8 | [NAME] |  | 46 | 0 | 32 |  | 55 | 0 | 50 |  | 82 | Silver |  |  | [NAME] | [NAME] | [NAME]
 |  | 9 | Rita |  | 41 | 0 | 47 |  | 55 | 0 | 50 |  | 97 | Gold |  |  | Rita
 |  | 10 | Sue |  | 39 | 0 | 51 |  | 55 | 0 | 50 |  | 101 | Gold |  |  | Sue
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
Spreadsheet: 017bd64b-ad71-43e7-a5b9-db919851fd7b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 27. LEASE FINANCE COMMITMENTS, Summary:Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total lease finance commitments ; |  |  | Original | A2414208C | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Seasonally Adjusted | A2414207A | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Trend | A2414206X | 1975-10-01 00:00:00 | 2012-07-01 00:00:00 | 442 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 68f794bb-c05f-42ba-b331-dae970d4c0e8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
3611 | 15403 | Maxime | Klein | FRA | 1 | 00:19:18 | 00:00:00 | 00:34:18 | 00:00:00 | 00:24:38 | 1 | 01:18:14
3611 | 21896 | [NAME] | Wohlgemuth | FRA | 2 | 00:26:27 | 00:00:00 | 00:38:21 | 00:00:00 | 00:29:15 | 2 | 01:34:03
Spreadsheet: 163987d1340591670-calculate-opponents-win-loss-record-tennis-tourney-2012v2
Sheet: Prelims

Winner | Score |  |  | [NAME] |  | Name | W | L | Win % | Games-W | Games-L | Games-% | Opponents-W | Opponents-L | Opponents-Win% | Power Rank | Rank |  | w | l | w | l
[NAME] | 6 | - | 1 | [NAME] |  | [NAME]
Kris | 6 | - | 0 | [NAME] |  | [NAME]
Kris | 6 | - | 0 | [NAME] |  | [NAME]
[NAME] | 6 | - | 2 | [NAME] |  | [NAME]
[NAME] | 7 | - | 5 | Shawn |  | [NAME]
Shannon | 6 | - | 0 | [NAME] |  | [NAME]
[NAME] | 6 | - | 2 | [NAME] |  | [NAME]
Shannon | 6 | - | 3 | Shawn |  | [NAME]
Kris | 6 | - | 0 | [NAME] |  | Kris
[NAME] | 7 | - | 5 | [NAME] |  | [NAME]
[NAME] | 6 | - | 2 | [NAME] |  | [NAME]
Kris | 6 | - | 0 | Shawn |  | Shannon
[NAME] | 6 | - | 1 | [NAME] |  | Shawn
Shannon |  | - |  | [NAME] |  | [NAME]
Shannon |  | - |  | [NAME] |  | Trevor
[NAME] | 6 | - | 4 | Shannon
[NAME] | 6 | - | 0 | [NAME]
[NAME] | 6 | - | 0 | [NAME]
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
Spreadsheet: 776069d1649490294-hiding-a-column-gives-an-error-you-cannot-move-objects-outside-of-the-sheet-test2
Sheet: PowerQuery

Source.Name | Field Title | Field Value
Facture 2022-001.xlsm | Date de facturation : | 2022-01-12 00:00:00
Facture 2022-001.xlsm | Numéro de facture : | 2022-001
Facture 2022-002.xlsm | Date de facturation : | 2022-01-12 00:00:00
Facture 2022-002.xlsm | Numéro de facture : | 2022-002
Facture 2022-003.xlsm | Date de facturation : | 2022-01-12 00:00:00
Facture 2022-003.xlsm | Numéro de facture : | 2022-003
Facture 2022-004.xlsm | Date de facturation : | 2022-02-21 00:00:00
Facture 2022-004.xlsm | Numéro de facture : | 2022-004
Facture 2022-005.xlsm | Date de facturation : | 2022-03-10 00:00:00
Facture 2022-005.xlsm | Numéro de facture : | 2022-005
Facture 2022-006.xlsm | Date de facturation : | 2022-04-01 00:00:00
Facture 2022-006.xlsm | Numéro de facture : | 2022-006
Facture 2022-007.xlsm | Date de facturation : | 2022-04-01 00:00:00
Facture 2022-007.xlsm | Numéro de facture : | 2022-007
Spreadsheet: 839109d1691669085-lookup-based-on-2-values-exceltest
Sheet: Sheet2

 | Class
 | A
 | B
 | C
 | D
 | E
 | name | A | B | C | D | E
 | Fred | 37.79 | 39.33 | 39.54 | 38.81 | 40.24
 | [NAME] | 38.64 | 39.33 | 37.84 | 39.29 | 40.35
 | Sandra | 36.65 | 39.53 | 39.3 | 39.44 | 40.21
 | [NAME] | 38.8 | 39.96 | 37.73 | 38.31 | 40.98
Spreadsheet: 64273d1265141248-search-tabs-and-return-results-kc_environmental_aspects-1-
Sheet: Process - Activity 9

Operating Condition | Process Evaluated | Maintenance | Date |  |  | Enter Date |  | Team | 0
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0 | 6 | Yes
 |  |  |  |  | 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 | 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 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | 0 | 0 | 0
Spreadsheet: 883364d1731990469-formula-to-update-clients-clients-updated_r1
Sheet: Sheet1

 | I am kindly requesting for a formula that list the names that appear in both tables. Thank you.
 |  |  |  |  |  |  |  |  |  | Desired Solution
 | Date | Name | I.D Number |  | Date | Name | I.D Number |  |  | Name | I.D Number
 | 2024-01-05 00:00:00 | [NAME] | CT 461 |  | 2024-01-01 00:00:00 | [NAME] | CT 275 |  |  | [NAME] | CT 461
 | 2024-01-05 00:00:00 | [NAME] | CT 432 |  | 2024-01-01 00:00:00 | ADAROSE | CT 408 |  |  | [NAME] | CT 432
 | 2024-01-05 00:00:00 | SIDRA | CT 449 |  | 2024-01-01 00:00:00 | ADONIS | CT 233 |  |  | SIDRA | CT 449
 | 2024-01-05 00:00:00 | TEBOGO | CT 442 |  | 2024-01-01 00:00:00 | AGAPE | CT 249 |  |  | TEBOGO | CT 442
 | 2024-01-05 00:00:00 | ANENYASHA | CT 486 |  | 2024-01-01 00:00:00 | ALEX | CT 002 |  |  | ANENYASHA | CT 486
 | 2024-01-05 00:00:00 | [NAME] | CT 4860 |  | 2024-01-01 00:00:00 | AMAL | CT 003
 | 2024-01-05 00:00:00 | MARY | CT 4861 |  | 2024-01-01 00:00:00 | AMBER | CT 420 |  |  | No1. CountIf not available, because "ANENYASHA" has additional space in the right table
 |  |  |  |  | 2024-01-01 00:00:00 | ANDILE | CT 004 |  |  |  | CT 461
 |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | CT 461 |  |  | [NAME] | CT 432
 |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | CT 432 |  |  | SIDRA | CT 449
 |  |  |  |  | 2024-01-01 00:00:00 | SIDRA | CT 449 |  |  | TEBOGO | CT 442
 |  |  |  |  | 2024-01-01 00:00:00 | TEBOGO | CT 442
 |  |  |  |  | 2024-01-01 00:00:00 | ANENYASHA | CT 486 |  |  | No2. MATCH not available also , because "ANENYASHA" has additional space in the right table
 |  |  |  |  |  |  |  |  |  |  | CT 461
 |  |  |  |  |  |  |  |  |  | [NAME] | CT 432
 |  |  |  |  |  |  |  |  |  | SIDRA | CT 449
 |  |  |  |  |  |  |  |  |  | TEBOGO | CT 442
 |  |  |  |  |  |  |  |  |  | No3. MATCH after TRIM is ok, what ever apaces at the any ends
 |  |  |  |  |  |  |  |  |  |  | CT 461
 |  |  |  |  |  |  |  |  |  | [NAME] | CT 432
 |  |  |  |  |  |  |  |  |  | SIDRA | CT 449
 |  |  |  |  |  |  |  |  |  | TEBOGO | CT 442
 |  |  |  |  |  |  |  |  |  | ANENYASHA | CT 486
Spreadsheet: 71658d1272396302-how-to-add-scores-after-the-use-of-index-formula-dikkebeer1-tester-pages
Sheet: 4X4POOL

 | AUTO LOTING |  |  |  | HF |  | 180
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  | A |  | 1 | 5 | 9 | 13 |  | 18 |  |  | a |  | e |  | 3 | 0
 | 1 | a |  |  |  |  |  |  | 1 | a | 0 | 3 | 3 | 2 |  | 8 |  |  | I |  | m |  | 1 | 2
 | 2 | b |  |  |  |  |  |  | 5 | e | 0 | 0 | 1 | 0 |  | 1
 | 3 | c |  |  |  |  |  |  | 9 | I | 0 | 2 | 0 | 1 |  | 3 |  |  | e |  | m |  | 0 | 3
 | 4 | d |  |  |  |  |  |  | 13 | m | 1 | 3 | 2 | 0 |  | 6 |  |  | a |  | I |  | 3 | 0
 | 5 | e
 | 6 | f |  |  |  |  |  |  | B |  | 2 | 6 | 10 | 14 |  | 18 |  |  | m |  | a |  | 1 | 2
 | 7 | g |  |  |  |  |  |  | 2 | b | 0 | 1 | 2 | 1 |  | 4 |  |  | I |  | e |  | 2 | 1
 | 8 | h |  |  |  |  |  |  | 6 | f | 2 | 0 | 2 | 2 |  | 6
 | 9 | I |  |  |  |  |  |  | 10 | j | 1 | 1 | 0 | 1 |  | 3
 | 10 | j |  |  |  |  |  |  | 14 | n | 2 | 1 | 2 | 0 |  | 5 |  | B
 | 11 | k |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b |  | f |  | 1 | 2
 | 12 | L |  |  |  |  |  |  | C |  | 3 | 7 | 11 | 15 |  | 18 |  |  | j |  | n |  | 1 | 2
 | 13 | m |  |  |  |  |  |  | 3 | c | 0 | 2 | 3 | 0 |  | 5
 | 14 | n |  |  |  |  |  |  | 7 | g | 1 | 0 | 3 | 2 |  | 6 |  |  | f |  | n |  | 2 | 1
 | 15 | o |  |  |  |  |  |  | 11 | k | 0 | 0 | 0 | 3 |  | 3 |  |  | b |  | j |  | 2 | 1
 | 16 | p |  |  |  |  |  |  | 15 | o | 3 | 1 | 0 | 0 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n |  | b |  | 2 | 1
 |  |  |  |  |  |  |  |  | D |  | 4 | 8 | 12 | 16 |  | 18 |  |  | j |  | f |  | 1 | 2
 |  | TRANSPORT LIJN |  |  |  |  |  |  | 4 | d | 0 | 3 | 1 | 2 |  | 6
 |  | FINALISTEN |  |  |  |  |  |  | 8 | h | 0 | 0 | 1 | 0 |  | 1
A1 |  | a |  |  |  |  |  |  | 12 | L | 2 | 2 | 0 | 3 |  | 7 |  | C
D2 |  | d |  |  |  |  |  |  | 16 | p | 1 | 3 | 0 | 0 |  | 4 |  |  | c |  | g |  | 2 | 1
B1 |  | f |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k |  | o |  | 3 | 0
C2 |  | c
C1 |  | g |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g |  | o |  | 2 | 1
B2 |  | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c |  | k |  | 3 | 0
D1 |  | L
A2 |  | m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | o |  | c |  | 3 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k |  | g |  | 0 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d |  | h |  | 3 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L |  | p |  | 3 | 0
 |  |  | 180 +hf (hoogste alleen) en pers. Score moet nog optellen  waarbij hf bij optellen als 1 moet gaan dienen en waarbij in beeld de echte hf staat |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | h |  | p |  | 0 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d |  | L |  | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p |  | d |  | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L |  | h |  | 2 | 1
Spreadsheet: 197812d1354565932-look-up-dummy1-dhoang25-oeldere-
Sheet: Summary

Associate_Name | Process Code - 1111 | Process Code - 2222 | Process Code - 4444 | Process Code - 5555 | Process Code - 7777 | Process Code - 9999
[NAME] | USED | USED
[NAME] | USED |  |  | USED | USED
Adam | USED | USED | USED |  | USED | USED
Spreadsheet: 85181d1285237537-credit-note-log-master-credit-note
Sheet: Credit Note

1ST CLASS PACKAGING 3 KINGSFIELD BUSINESS PARK GLADSTONE ROAD NORTHAMPTON NN5  7PP |  |  |  | Phone: | +44(0)[PHONE]
 |  |  |  | Fax: | +44(0)[PHONE]
 |  |  |  | E-mail: | [EMAIL]
[NAME]
[EMAIL] [EMAIL]
Credit Note
 |  |  |  |  | [NAME] To:
 | Credit Note # |  |  |  | Cleaver Scientific
 | Date: | 2010-09-23 00:00:00 |  |  | Unit 4, Triton Park
 | Customer ID: | 1stclass |  |  | [NAME]
 |  |  |  |  | Swift Valley
 |  |  |  |  | Rugby
 |  |  |  |  | CV21 1SG
 |  |  |  |  | United Kingdom
Credit Note # | Part Number | Quantity | Rejection Reason | Unit Cost | VAT | Total Due
 |  |  |  |  |  | 0
Reminder: All charges will be deducted from your next invoice
 | REMITTANCE
 | Customer ID: | 1stclass
 | Statement #: | 0 | ALL NON-CONFORMING PARTS WILL BE KEPT AT CLEAVER SCIENTIFIC FOR 30 DAYS ONLY DURING WHICH TIME YOU MAY REQUEST OR ARRANGE THE RETURN OF THE GOODS AT YOUR COST. AFTER THIS PERIOD OF TIME THE PARTS WILL BE DISPOSED OF AND ANY COSTS INCURRED WILL BE FORWARDED ON TO THE SUPPLIER.
 | Date: | 2010-09-23 00:00:00
 | Amount Due: | 0
 | Amount Enclosed:
Spreadsheet: 850281d1700653888-calculate-0-10-difficulty-based-on-multiple-inputs-each-of-differing-weighting-difficulty-calculator
Sheet: Sheet1

Distance | 41.23
Elevation | 545
[NAME] | 11.5
Difficulty (0-10)
Inputs | Weighting |  | Minimum Value | Maximum Value | Notes
Distance | 0.5 |  | 0.01 | 50 | Anything >50 receives [NAME] score
Elevation | 0.4 |  | 0.01 | 800 | Anything >800 recieves [NAME] score
[NAME] | 0.1 |  | 0.01 | 22 | Anything >22 recieves [NAME] score
 |  | 10
Special Conditions
 | equal or greater than | Regardless of other inouts
If Distance > | 75 | Total difficulty automatically |  | 10
If Elevation > | 1000 | Total difficulty automatically |  | 10
If [NAME] | 25 | Total difficulty automatically |  | 9
Notes:
Items in red subject to change / sensitivity analysis
Items in yellow cells to be populated on a case-by-case basis
Item in blue cell to be autocalculated & rounded to nearer 0.5
Example 1 with easy round numbers
Distance = 25, therefore scoring 2.5 points
Elevantion = 600, therefore scoring 3 points
[NAME] gradient = 30, therefore scoring 1 point
Total score: 2.5 + 3 + 1 = 6.5
BUT, [NAME] gradient >22 therefore total score to be calculated as 9 (based on E17)
Example 2
Distance = 41.23
Elevation = 545
[NAME] gradient = 11.5
Total score?
Spreadsheet: 581456d1531318516-conditional-format-top-and-bottom-2-values-in-each-row-example
Sheet: Sheet1

Date | AUDCAD | AUDJPY | AUDNZD | AUDUSD
2013-03-29 00:00:00 | 5 | 4 | 3 | 2 | << This row has been conditionally formatted to show the top 2 (green) and bottom 2 (red). I'd like to copy the conditional formatting down the whole sheet displaying top 2 and bottom 2 in each row.
 | 3 | 4 | 6 | 1 | <<This row should therefore highlight cells [NAME] and [NAME] for top 2 and B3 and E3 for bottom 2
 | 2 | 1 | 5 | 4 | << This row D4 and E4 for top 2, B2 and C2 for bottom 2 etc.
 | 7 | 9 | 12 | 3
 | 4 | 6 | 5 | 3