tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155383d1336780566-excel-2007-how-to-create-a-list-that-returns-unique-values-copy_hot-list
Sheet: HOT COMP

HOT LIST COMPILATION
Structure of Data Set - This just looks if a university is rated as 'hot'.  The array starts on line 4 and ends on line 56, so if you add a sheet ensure you format it correctly.  If you add a state, just add a column to this page, copy any of the other column's formulas and change the sheet it is pointing to and copy it down.
[NAME] | HOT | SENT
# | Michigan | Illinois | DC | PA | MAINE | CONN | ALABAMA | NY | TEXAS | MASS | OKLAHOMA | KANSAS | CALI | INDIANA | WV
1
Spreadsheet: 715860d1611891023-sum-multiple-categories-in-the-same-formula-for-each-month-forum-excel-28-jan-2021
Sheet: Pmnt c.c.+fct fam

 |  |  |  | 1
Date | Description | Paiement | Mode paiement | [NAME] | Cycle | Néc./Luxe
2020-01-01 00:00:00 | [NAME] (payé le 19-sep-2019) | -300 | Comptant | Logement | Irrégulier | Nécessité
2020-01-01 00:00:00 | [NAME] (payé le 19-sep-2019) | -30 | Comptant | [NAME]/chauffage | Irrégulier | Nécessité
2020-01-01 00:00:00 | Internet [NAME] (payé le 19-sep-2019) | -20 | Comptant | Internet | Irrégulier | Nécessité
2020-02-01 00:00:00 | Loyer février (payé le 19-sep-2019) | -300 | Comptant | Logement | Irrégulier | Nécessité
2020-02-01 00:00:00 | Hydro février (payé le 19-sep-2019) | -30 | Comptant | [NAME]/chauffage | Irrégulier | Nécessité
2020-02-01 00:00:00 | Internet février (payé le 19-sep-2019) | -20 | Comptant | Internet | Irrégulier | Nécessité
Spreadsheet: 774890d1648710734-find-the-max-and-the-min-values-with-index-and-match-function-for-each-row-index-and-match-to-find-max-and-min-values-etaf
Sheet: Sheet 1

 |  | Test 1 | Test 2 | Test 3 | Test 4 | Test 5 | Test 6 | Average
 | Student 1 | 70 | 54 | 92 | 33 | 61 | 99 |  |  |  | Student | Student 7
 | Student 2 | 93 | 69 | 69 | 35 | 81 | 37 |  |  |  | Test | Test 1
 | Student 3 | 95 | 66 | 62 | 36 | 71 | 41 |  |  |  | Marks
 | Student 4 | 73 | 75 | 82 | 89 | 93 | 41 |  |  |  | Average
 | Student 5 | 49 | 57 | 52 | 58 | 75 | 61 |  |  |  | Total Score |  |  |  |  |  | I am trying to find out the [NAME] and the Min values for each row for student 1 to Student 11. When I select the student number on cell M4 the Min and [NAME] value cells for the student should fetch on the cells M15 and M16 respectively.  I tried the below formula but it's showing #N/A (refer the attached file).  =INDEX(B9:I20,MATCH(MAX(B10:H10,0),0))  For eg when I select Student 1 the [NAME] value should be 99 and the Min value should be 33.
 | Student 6 | 71 | 74 | 38 | 59 | 45 | 36 |  |  |  | Min Score
 | Student 7 | 98 | 34 | 74 | 84 | 97 | 35 |  |  |  | [NAME]
 | Student 8 | 36 | 38 | 86 | 93 | 93 | 30
 | Student 9 | 53 | 97 | 48 | 44 | 91 | 76
 | Student 10 | 95 | 83 | 38 | 32 | 58 | 99
 | Student 11 | 50 | 60 | 50 | 60 | 50 | 60
 | Total Score
Spreadsheet: 39751d1238029277-aging-formula-677134-receivables-ageing
Sheet: Sheet1

New Charges | Pmts. Received | Credits Received | Balance Due | 30 days | 60 days | 90 days | 120 days | 150 days | 180 days | Don't delete this column
1263.32 | 0 | 0 | 1263.32 | 0 | 0 | 0 | 0 | 0 | 0
2498.03 | 0 | 47.08 | 3714.27 | 1216.24 | 0 | 0 | 0 | 0 | 0
3937.38 | 0 | 0 | 7651.650000000001 | 2498.030000000001 | 1216.24 | 0 | 0 | 0 | 0
1964.98 | 1217.48 | 211.86 | 8187.290000000001 | 3937.38 | 2284.93 | 0 | 0 | 0 | 0
213.92 | 2361.33 | 0 | 6039.880000000001 | 1964.98 | 3860.98 | 0 | 0 | 0 | 0
1922.13 | 3937.38 | 0 | 4024.630000000002 | 213.9200000000001 | 1888.580000000001 | 0 | 0 | 0 | 0
4387.16 | 1753.12 | 0 | 6658.670000000002 | 1922.130000000001 | 213.9200000000001 | 135.4600000000009 | 0 | 0 | 0
1471.71 | 1996.47 | 0 | 6133.910000000002 | 4387.16 | 275.0400000000027 | 0 | 0 | 0 | 0
878.54 | 3653.72 | 0 | 3358.730000000003 | 1471.709999999999 | 1008.480000000003 | 0 | 0 | 0 | 0
3759.75 | 1471.71 | 0 | 5646.770000000004 | 878.5400000000009 | 1008.480000000003 | 0 | 0 | 0 | 0
12637.75 | 832.7 | 176.55 | 17275.27 | 3759.75 | 877.7700000000041 | 0 | 0 | 0 | 0
1792.11 | 3759.75 | 0 | 15307.63 | 12637.75 | 877.7700000000041 | 0 | 0 | 0 | 0
4759.94 | 12461.2 | 1315.71 | 6290.660000000003 | 1530.720000000001 | 0 | 0 | 0 | 0 | 0
1677.17 | 688.26 | 0 | 7279.57 | 4759.940000000002 | 842.4599999999991 | 0 | 0 | 0 | 0
708.69 | 3444.23 | 7.26 | 4536.769999999997 | 1677.169999999998 | 2150.909999999996 | 0 | 0 | 0 | 0
2775.71 | 0 | 0 | 7312.479999999996 | 708.6900000000023 | 1677.169999999998 | 2150.909999999996 | 0 | 0 | 0
58.42 | 1677.17 | 0 | 5693.729999999996 | 2775.709999999999 | 708.6900000000023 | 1677.169999999998 | 473.739999999998 | 0 | 0
1146.59 | 0 | 0 | 6840.319999999992 | 58.41999999999825 | 2775.709999999999 | 708.6900000000023 | 1677.169999999998 | 473.739999999998 | 0
4669.49 | 58.42 | 701.43 | 10749.95999999999 | 1146.589999999997 | 58.41999999999825 | 2775.709999999999 | 708.6900000000023 | 1391.059999999998 | 0
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 848360d1699080575-formula-to-return-sum-based-on-year-yyyy-sample57
Sheet: Sheet1

Date | Total |  |  |  |  |  | Date | sum
2022-09-19 00:00:00 | 434 |  |  |  |  |  | 2022 | 5895
2022-09-21 00:00:00 | 601 |  |  |  |  |  | 2023 | 6084
2022-09-25 00:00:00 | 599 |  |  | Total 2022
2022-10-01 00:00:00 | 1367 |  |  | Total 2023
2022-10-05 00:00:00 | 1976
2022-10-23 00:00:00 | 918
2023-01-05 00:00:00 | 998
2023-01-08 00:00:00 | 675
2023-01-09 00:00:00 | 316
2023-01-10 00:00:00 | 918
2023-01-15 00:00:00 | 548
2023-02-25 00:00:00 | 673
2023-03-06 00:00:00 | 135
2023-03-08 00:00:00 | 985
2023-03-09 00:00:00 | 634
2023-03-11 00:00:00 | 202
Spreadsheet: 536991d1504784494-finding-and-copying-moving-data-book3
Sheet: Sheet1

Name | Address
Q | 758 Main Street
W | 853 Side Street
E | 709 [NAME]
R | 958 Main Street
T | 937 Side Street
Y | 435 Main Street
U | 969 Main Street
I | 508 Main Street
O | 737 Main Street
P | 405 Side Street
A | 196 Main Street
S | 226 Main Street
D | 658 Side Street
F | 727 [NAME]
G | 455 [NAME]
H | 823 Main Street
J | 308 Main Street
K | 596 Side Street
L | 206 Main Street
Spreadsheet: 3587f6e1-ceaa-414b-a2f3-363a6ab9bfb8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFRED | Test | FFRED | Friedreich Ataxia Repeat Expansion Analysis - Unknown Mutation | Friedreich Ataxia-FRDA Gene Seq | Southern Blot, PCR | EDTA (lavender-top) tube: EDTA |  |  | 5 | mL | Collect EDTA (lavender-top) tube. Ship ambient.  Adults/Children 3-5 mL; [NAME]    Note:  Completed and submit with specimen - Baylor Molecular form | 3 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | A final report will be faxed under separate cover.    Test Performed By:  Baylor Medical Genetics Laboratories                                         2450 [NAME].                                         Houston, TX  77021 | Upon receipt | 21 days | 23 - 27 days | 1 | 81401 |  |  |  |  | Baylor Medical Genetics Laboratories
FFRED | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FFRED | Result | [NAME] | Friedreich Ataxia-FRDA Gene Seq | Friedreich Ataxia-FRDA Gene Seq | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 9c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Fixed-Float | 61075 | 257767 | 120552 | 201542 | 337057 | 240942 | 130074 | 16127
FRA | 3608 | 11316 | 28100 | 12557 | 2585 | 0 | 0 | 0
OTHER* | 3691 | 16673 | 22453 | 32927 | 157796 | 83117 | 73425 | 6017
TOTAL
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, OIS, Swaption, and Basis.
Spreadsheet: 840669d1692897181-detect-and-remove-outliers-from-dataset-exposure-spudster656_new
Sheet: EcoliMN

Susceptibility for KLEB_FL
0.4 | std |  |  |  |  | Upper Boundary
0.8 | mean |  |  |  |  | Lower Boundary
0.8 | Min
0.1 | [NAME]
0.5
Susceptibility for [NAME]
0.9 | std |  |  |  |  | Upper Boundary
0.6 | mean |  |  |  |  | Lower Boundary
0.6 | Min
0.4 | [NAME]
0.4
* No data value exceed the upper boundary or fall behind the lower boundary
Spreadsheet: 72890d1273593612-lookup-or-index-formula-forum-example
Sheet: Sheet1

 |  | City |  |  |  |  |  |  |  | Effort | Last 5
 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  | CIN
 |  | PIT |  |  |  |  |  |  |  | HD
 |  | WAS |  |  |  |  |  |  |  | AD
 |  | NYM
 |  | FLA
 |  | CHC
 |  | HOU
 |  | STL |  |  |  |  |  |  |  | HF
 |  | ATL |  |  |  |  |  |  |  | AF
 |  | MIL
 |  | PHI
 |  | COL |  |  |  |  |  |  |  | HD
 |  | LAD |  |  |  |  |  |  |  | AD
 |  | ARI
 |  | SD
 |  | SF |  |  |  |  |  |  |  | HF
 |  | SEA |  |  |  |  |  |  |  | HF | p | n | n | n | n
 |  | BAL
 |  | NYY
 |  | DET |  |  |  |  |  |  |  | HD
 |  | TOR |  |  |  |  |  |  |  | AD
 |  | BOS
 |  | OAK
 |  | TEX |  |  |  |  |  |  |  | HF
 |  | CLE
 |  | KC
 |  | CHW
 |  | MIN |  |  |  |  |  |  |  | HF
 |  | TB |  |  |  |  |  |  |  | AF
 |  | LAA
 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 845526d1697016072-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerliveck76bak
Sheet: Handicaps

 |  |  | 2023-12-04 00:00:00 | 2024-01-08 00:00:00 | 2024-02-05 00:00:00 | 2024-03-04 00:00:00 | 2024-04-08 00:00:00 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00
Team/Hcap | StartHcp | Hcaps for 13/11 | Hcaps for 04/12 | Hcaps for 08/01 | Hcaps for 05/02 | Hcaps for 04/03 | Hcaps for 08/04 | Hcaps for 06/05 | Hcaps for 03/06
Team1
Player1 | 12
Player2 | 17
Player3 | 16
Player4 | 17
Team2
Player5 | 10
Player6 | 15
Player7 | 19
Player8 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: 100c2a5b-90a8-4576-b37c-2b1ce227e628
Sheet: Forward Reserve

Reserve Asset Detail Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserve Asset Detail Report |  |  |  |  |  |  |  |  | Reserve Asset Detail Report
SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV |  |  |  |  |  |  |  |  | SD_RSVASTDTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME] |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  |  | Asset |  |  |  | Ten-Minute Non-Spin Reserve |  |  |  |  |  |  |  | Thirty-Minute Non-Spin Reserve
Trading Interval | Reserve Zone ID | Reserve Zone Name | Asset ID | Asset Name | Asset Type | Ownership Share | Forward Reserve TMNSR Available MWs | Forward Reserve TMNSR Assigned MWs | Asset Forward Reserve TMNSR Delivered MWs | Forward Reserve TMNSR Energy Obligation Credit MWs | Asset TMNSR Failure-to-Reserve Penalty Exempt MWs | Participant Share Asset Forward Reserve TMNSR Delivered MWs | Participant Share of Forward Reserve TMNSR Energy Obligation Credit MWs | Participant Share Asset TMNSR Failure-to-Reserve Penalty Exempt MWs | Forward Reserve TMOR Available MWs | Forward Reserve TMOR Assigned MWs | Asset Forward Reserve TMOR Delivered MWs | Forward Reserve TMOR Energy Obligation Credit MWs | Asset TMOR Failure-to-Reserve Penalty Exempt MWs | Participant Share Asset Forward Reserve TMOR Delivered MWs | Participant Share of Forward Reserve TMOR Energy Obligation Credit MWs | Participant Share Asset TMOR Failure-to-Reserve Penalty Exempt MWs | Forward TMNSR Obligation Charge Limit MWs | Forward TMOR Obligation Charge Limit MWs | Forward TMNSR Obligation Charge MWs | Forward TMOR Obligation Charge MWs | Participant Share Forward TMNSR Obligation Charge MWs | Participant Share Forward TMOR Obligation Charge MWs | Subaccount ID | Subaccount Name
Hour End | Number | String | Number | String | String | % | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | MWh | String | String
Spreadsheet: 182026d1348240915-requesting-critique-of-my-retirement-spreadsheet-retire-calc3-send
Sheet: investment pre inf

 |  | age | balance | Cumulative Contribution | Principle | Gain | Ex. Ratio | ending Balance
Spreadsheet: 467202d1466613175-match-up-the-sku-numbers-between-two-pages-and-transfer-the-prices-sku-and-price
Sheet: Sheet 1 Correct Prices

This sheet has the CORRECT PRICES on it, but no Parent SKU numbers
SKU | PRICE | WHAT
1120 | 43.45 | Box
1120-s | 1.87 | Sample
16004131TPWV | 85.32 | Box
16004131TPWV-s | 4.24 | Sample
17-1700 | 33.27 | Box
17-1700-s | 1.87 | Sample
Spreadsheet: 491859d1480674518-mulitple-rows-to-a-single-column-leave-blanks-out-test-frames
Sheet: RNG (2)

 |  |  |  | FRAMES
 |  |  |  | Column | A | B | C | D | E | F | G | H | I | J | K | L
 |  |  |  | Row 1 | [NAME] | [NAME] | CDT1
 |  |  |  | Row 2 | DES2 | BCS2 | CDA2 | [NAME]
 |  |  |  | Row 3 | ABC3 | BCD3
 |  |  |  | Row 4 | DET4 | EFT4 | FGT4 | ABA4
 |  |  |  | Row 5
 |  |  |  | Row 6
 |  |  |  | Row 7
 |  |  |  | Row 8
 |  |  |  | Row 9
 |  |  |  | Row 10
 |  |  |  | Row 11
 |  |  |  | Row 12
 |  |  |  | Row 13
 |  |  |  | Row 14
 |  | Neet to list above items sorted in a single column |  |  |  | Need to list each row left to right with comma seperated and with a PERIOD (.) at end
 |  | Raw Data (via formula) BY ROW LEFT TO RIGHT | Raw Data in Column "C" Sorted | NEEDED RESULT #1 |  | Concatenate Transpose Columns (A to L)  Leave Blanks out |  |  | Needed Result #2
 |  |  |  | ABA4 |  |  | If I use an Array |  | Row1: GHT1, [NAME], CDT1.
 |  |  |  | [NAME] |  |  | formula I get this |  | Row2: DES2, BCS2, CDA2, [NAME].
 |  |  |  | ABC3 |  |  | but only the first |  | Row3: ABC3, BCD3.
 |  |  |  | BCD3 |  |  | cell value & |  | Row4: DET4, EFT4, FGT4, ABA4.
 |  |  |  | BCS2 |  |  | no blanks
 |  |  |  | [NAME]
 |  |  |  | CDA2 |  |  | If I use a regular
 |  |  |  | CDT1 |  |  | formula I get the values
 |  |  |  | DES2 |  |  | starting with column
 |  |  |  | DET4 |  |  | "B" (G) and blanks
 |  |  |  | EFT4 |  |  | show as zeros (0)
 |  |  |  | FGT4 |  |  | but still only the
 |  |  |  | [NAME] |  |  | first cell value
Spreadsheet: kevin_hyatt__19604__Base Model 111601
Sheet: Assumptions

Project Assumptions and Valuation Summary
MODEL ASSUMPTIONS |  |  |  |  | Warning Flags:
PROJECT LOGISTICS
 | Name of project: |  | Wolverine
 | Enron Owner |  | ETS
 | Enron Financial Partner |  | None |  | TARGET SUMMARY
 | Enron % Equity Ownership |  | 1
 | Financial Partner Return |  | 0 |  | MARKET CAPITALIZATION |  |  | RATE BASE
 | Partner(s): |  | None |  | Target Outstanding Shares | 132000 |  | From 10K
 | Partner % Ownership |  |  |  | Target Share Price | 23.125 |  | Plant In-Service | 731246
 | Year of Acquisition |  | 2002 |  | Market Capitalization |  |  | Accum. Dep. | 243006
 | Length of Contract (yrs.) |  | 10 |  |  |  |  | Def. Taxes | 62741
 | Enron Shares Outstanding |  | 880000 |  | VALUATION SUMMARY |  |  | Total
 | Enron Share Price |  | 28.3 |  | 2000 Net Income |  |  | Return | 0.11
 | Figures |  | US$ '000s |  | Multiple | 15 |  | Net Income Proxy
 |  |  |  |  | Implied Valuation
ECONOMIC ASSUMPTIONS |  |  |  |  | 2000 EBITDA
 | Corporate Income Tax |  | 0.385 |  | Multiple | 10
 | Book Depreciation (Years) |  | 40 |  | Implied Valuation
 | Consolidated NPV Core Rate |  | 0.125 |  | DCF Valuation
 | Project Premium |  | 0
 | Dividend Tax Rate |  | 0
 | Structured Dividend Tax Rate |  | 0.077
 | Additional Debt After Tax @ |  | 0.07
 | Cost of 3rd Party Equity |  | 0.12
DEBT
 | Financial Leverage Rate |  | 0.5
 | Interest Rate
 | Retirement (Years)
ASSET ASSUMPTIONS
 |  | Include in Valuation (1=Yes, 0=No) | Potential Owner | Salvage Multiple (x EBITDA) | Revenue Scenario | Expense Scenario | NPV Core Rate | Macros
 |  | 1 |  | 12 |  | 1 | 0.125
 | % Involvement | 1
 |  | 1 |  | 12 |  | 1 | 0.125
 | % Involvement | 1
 |  | 1 |  | 12 |  | 1 | 0.125
 | % Involvement | 1
Revenue Scenario Assumption- Scenario Discription
 |  | Asset 1
 | 1. Base Case
 | 2. Optimistic | 10% increase
 | 3. Pessimistic | 10% decrease
Expense Scenario  Assumption - Scenario Discription
 |  | Asset 1
 | 1. Base Case
 | 2. Optimistic | 10% decrease
 | 3. Pessimistic | 10% increase
Spreadsheet: 782944d1654440805-vlookup-or-index-match-multiple-crierias-ranking-by-points-system
Sheet: Sheet1

Results
 | RATINGS CRITERIA |  |  |  |  |  |  |  |  |  | POINTS FOR CLASS SYSTEM |  |  |  |  |  |  |  |  |  |  |  | RANKING |  |  |  |  |  |  |  |  |  | Points allocated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL POINTS
Numbers | A | B | C | D | E | F | G | H | J |  | RANK | A | B | C | D | E | F | G | H | J |  |  | A | B | C | D | E | F | G | H | J |  |  | A | B | C | D | E | F | G | H | J
1 | 92.99558993702065 | 122 | 107 | 113.75 | 160.389210500364 | 106.926140333576 | 100 | 113.75 | 129 |  | 1 | 12.63 | 12.63 | 12.63 | 12.63 | 12.63 | 15 | 15 | 15 | 15 |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 13 | 8
2 | 90.99131529678017 | 106 | 104 | 110.25 | 159.7703164723415 | 106.5135443148944 | 100 | 107.25 | 114 |  | 2 | 10.26 | 10.26 | 10.26 | 10.26 | 10.26 | 12.5 | 12.5 | 12.5 | 13 |  | 2 |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 3 | 6
3 | 91.5517743830653 | 73 | 77 | 78.25 | 168.5708381991382 | 112.3805587994255 | 72 | 48.25 | 77 |  | 3 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 | 10 | 10 | 10 | 10 |  | 3 |  |  |  |  |  |  |  |  |  |  | 3 | 0
4 | 95.00438345391991 | 73 | 76 | 71.25 | 167.5619667451623 | 111.7079778301082 | 74 | 40.25 | 80 |  | 4 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 | 7.5 | 7.5 | 7.5 | 7.5 |  | 4 |  |  |  |  |  |  |  |  |  |  | 4 | 0
5 | 97.95247459680645 | 73 | 74 | 71.5 | 167.557435696626 | 111.704957131084 | 69 | 38.5 | 79 |  | 5 | 3.16 | 3.16 | 3.16 | 3.16 | 3.16 | 5 | 5 | 5 | 5 |  | 5 |  |  |  |  |  |  |  |  |  |  | 5 | 0
6 | 82.21011281418235 | 122 | 124 | 116.25 | 163.0931814218198 | 108.7287876145465 | 117 | 133.25 | 117 |  | 6 | 0.79 | 0.79 | 0.79 | 0.79 | 0.79 | 0 | 0 | 0 | 0 |  | 6 |  |  |  |  |  |  |  |  |  |  | 6 | 0
7 | 94.42414100058294 | 108 | 104 | 109.25 | 160.0023079773791 | 106.6682053182527 | 112 | 106.25 | 99 |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 7 |  |  |  |  |  |  |  |  |  |  | 7 | 0
8 | 98.36681925727805 | 73 | 80 | 78.5 | 168.3864984502218 | 112.2576656334812 | 73 | 51.5 | 77 |  | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8 |  |  |  |  |  |  |  |  |  |  | 8 | 0
9 | 92.85991867549063 | 73 | 78 | 75 | 162.9858059640548 | 108.6572039760365 | 79 | 46 | 75 |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 9 |  |  |  |  |  |  |  |  |  |  | 9 | 0
10 | 98.60003113534273 | 73 | 81 | 87.25 | 157.7035585902581 | 105.1357057268387 | 82 | 61.25 | 85 |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 |  |  |  |  |  |  |  |  |  |  | 10 | 0
11 | 86.0056672495971 | 119 | 122 | 121.5 | 161.9180360282746 | 107.9453573521831 | 118 | 136.5 | 112 |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 11 |  |  |  |  |  |  |  |  |  |  | 11 | 0
12 | 94.02750133159597 | 71 | 81 | 77 | 161.6719072820831 | 107.7812715213887 | 77 | 51 | 55 |  | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 12 |  |  |  |  |  |  |  |  |  |  | 12 | 0
13 | 92.4480580873024 | 73 | 77 | 80 | 164.2923364710751 | 109.52822431405 | 91 | 50 | 72 |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 13 |  |  |  |  |  |  |  |  |  |  | 13 | 0
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (14)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
14.01
14.02
14.03
14.04 |  |  |  |  |  |  |  |  |  | 0
14.05 |  |  |  |  |  |  |  |  |  | 0
14.06 |  |  |  |  |  |  |  |  |  | 0
14.07 |  |  |  |  |  |  |  |  |  | 0
14.08 |  |  |  |  |  |  |  |  |  | 0
14.09 |  |  |  |  |  |  |  |  |  | 0
14.1 |  |  |  |  |  |  |  |  |  | 0
14.11 |  |  |  |  |  |  |  |  |  | 0
14.12 |  |  |  |  |  |  |  |  |  | 0
14.13 |  |  |  |  |  |  |  |  |  | 0
14.14 |  |  |  |  |  |  |  |  |  | 0
14.15 |  |  |  |  |  |  |  |  |  | 0
14.16 |  |  |  |  |  |  |  |  |  | 0
14.17 |  |  |  |  |  |  |  |  |  | 0
14.18 |  |  |  |  |  |  |  |  |  | 0
14.19 |  |  |  |  |  |  |  |  |  | 0
14.2 |  |  |  |  |  |  |  |  |  | 0
14.21 |  |  |  |  |  |  |  |  |  | 0
14.22 |  |  |  |  |  |  |  |  |  | 0
14.23 |  |  |  |  |  |  |  |  |  | 0
14.24 |  |  |  |  |  |  |  |  |  | 0
14.25 |  |  |  |  |  |  |  |  |  | 0
14.26 |  |  |  |  |  |  |  |  |  | 0
14.27 |  |  |  |  |  |  |  |  |  | 0
14.28 |  |  |  |  |  |  |  |  |  | 0
14.29 |  |  |  |  |  |  |  |  |  | 0
14.3 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 727737d1618065371-updating-index-function-mealplan
Sheet: My New Recipe

 |  | My New Recipe |  |  | Starter | Recipe Index
 |  | Amount | Measurement | Ingredient | Directions | Preparation Time
 |  | 1 | Box | Crackers | Using a knife, smear desired amount of cream cheese onto one side of a cracker.   Place a small slice of smoked salmon on top of the cream cheese.  Add several drops of honey mustard-dill sauce on top of the salmon.  Top with a small amount of dill | 5 Minutes
 |  | 1 | Package | Cream Cheese
 | Calories | 1 | Package | [NAME]
 | 60 | 1 | Tablespoon | Honey mustard-dill sauce |  | Cook Time
 |  | 5 | Sprig(s) | Fresh Dill |  | 0 Minutes
 | Recipe Tags
 | salmon, crackers, cream cheese
 |  |  |  |  |  | Yield (Servings)
 | Comments |  |  |  |  | 12 Servings
 | A recipe in progress
Spreadsheet: 160192d1339001591-conditional-sum-with-linked-conditions-in-different-tables-copy-of-conditionalsum
Sheet: Input2

Person \ Week number |  | 1 | 2 | 3
[NAME] | Driver | 1 | 1 | 1
[NAME] | Driver | 1 | 1
Chelsea | Architect |  | 1
Nina | Salesperson |  |  | 1
[NAME] | Salesperson |  | 1 | 1
Spreadsheet: 866991d1713895170-summation-based-on-multiple-criterias-from-different-sheets-with-indirect-function-19042024-sample-file-for-xlforum-sanjuss2-
Sheet: 28022024

Data
Sr. | BrCd | Prd | Acct | Class | Amount
1 | 3 | 701 | 45 | [NAME] | 15000
2 | 2 | 701 | 57 | S2 | 18000
3 | 2 | 512 | 2 | S1 | 4500
4 | 5 | 603 | 4568 | [NAME] | 180000
5 | 15 | 518 | 140 | S1 | 12000 | Close
6 | 6 |  |  | S3
7 |  |  |  | S3
8 |  |  |  | S2
9 |  |  |  | [NAME] | 5000 | Close
10 |  |  |  | S1