tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 740469d1626353094-not-calculating-correctly-after-certain-line-value-error-sfsales-dec-2020-to-present-july-2021
Sheet: Cost and Expenses

Costs |  |  |  |  |  |  |  |  |  |  | Once Off or Recurring Expenses
Date Purchased | Description | Notes | Unit [NAME] | Qty | Cost | Subtotal | Shipping (if applicable) | Customs (if applicable) | Cost Each | Cost Each (inc. shipping and customs) |  | Date Purchased | Description | Unit [NAME] | Qty | Sum | Subtotal
2020-10-25 00:00:00 | [NAME] | Sizes are 50mm x 10mm | 5000 | 1 |  |  |  |  |  |  |  | 2020-10-25 00:00:00 | [NAME] | 5000 | 1
2021-01-14 00:00:00 | [NAME] |  | 960 | 1 | 2900 |  | 4 |  |  |  |  | 2020-06-18 00:00:00 | Promotional Gazebo | 1 | 5
2020-04-19 00:00:00 | [NAME] |  | 10000 | 1 |  |  |  |  |  |  |  | 2020-10-20 00:00:00 | Gumtree Marketing | 1 | 1
2020-01-01 00:00:00 | Nutrition Labels |  | 5000 | 1 |  |  |  |  |  |  |  | 2021-03-03 00:00:00 | Trial Run of Labels Ridwan | 1 | 600 | 600 | 600
2020-01-01 00:00:00 | [NAME] |  | 5000 | 1
2020-10-10 00:00:00 | Foil Bag Size 1 | The 1kg refill bag | 100 | 1
2020-10-10 00:00:00 | Foil Bag Size 2 | 250g refill | 100 | 1 | 200
2020-10-10 00:00:00 | Foil Bag Size 3 | 50g | 100 | 1
2020-12-19 00:00:00 | Foil Bag Size 4 Printed | 250g Printed Refill | 20000 | 1 | 24350 |  | 1600 | 10000
 | [NAME] 10 | 1 kg Drawstrings |  | 1 | 1040
 | [NAME] | 800g drawstrings
2021-02-01 00:00:00 |  | Postal fee for zip locks | 1 | 1 | 1337.96
2021-02-02 00:00:00 |  | Postal fee for zip locks | 1 | 1 | 295
2021-02-02 00:00:00 | Detpak | Brown bags | 1000 | 1 | 1794
2021-02-04 00:00:00 | Printulu Flyers 1 |  | 10000 | 1 | 4248.96
2021-02-04 00:00:00 | [NAME] Top up 1 | FW Satchel | 20 | 1 | 1500
2021-02-04 00:00:00 | Cotton twine 304 |  | 1 |  | 69
Read Me Guide:
Costs refer to the default purchases that will possibly recur throughout the lifetime of the business, such as packaging
Description (column B) should be descriptive enough for your own personal reference.
Unit [NAME] (column C) must be numeric values only and should contain the quantity per roll, bale, or box. E.g. you purchased 5000 labels, and received them as 2 rolls with 2500 labels on each roll. Column C should hold the value of 2500, then put the number of rolls in Qty (column D). This will correctly record the number of items in your inventory and the correct cost.
Drag the tables to open more fields.
Do not edit grey zones.
Important: When changing the "description" do not forget to make the same changes across the document (use the find and replace function across the full document)
Spreadsheet: d377a244-3094-4881-a813-8d48c01e197f
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (7 Entries):
 | 5 Laboratory apparatus 5.4 Laboratory technology and equipment 5.4.8 Vendor products 5.4.8.3 Plastic parts for analytical and laboratory equipment
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Berghof Products + Instruments GmbH | Germany | [NAME] | 72800 | A1.417
2 | BRAND GMBH + CO KG Fabrik für Laborgeräte | Germany | Wertheim | 97877 | B1.323/422
3 | CubiDesign Gehäuse GmbH | Germany | Hildesheim | 31137 | B2.102
4 | Fibracon : Insoll Machined Plastics | United Kingdom | High Peak | SK23 0QZ | B2.314
5 | IDEX Health & Science | Germany | Wertheim | 97877 | A3.221/320
6 | National Lab GmbH Kälte- und Temperiertechnik | Germany | [NAME] | 23879 | B2.200
7 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
Spreadsheet: 802406d1666827027-search-comma-separated-values-with-one-result-search-example
Sheet: Sheet1

Part Number with Serial Number  Mixed Up |  |  | Part Numbers |  | [NAME]:  Each of the Column D values search Column A: Results One Part Number with accociated Serial Number
PN555 | SN3 |  | PN123, PN2211 |  | PN123 | SN1
PN444 | SN6 |  | PN1234 |  | PN1234 | SN33
PN333 | SN2 |  | PN12345 |  | PN12345 | SN4
PN12345 | SN4 |  | PN111, PN222 |  | PN222 | SN54
PN1234 | SN33 |  | PN333 |  | PN333 | SN2
PN222 | SN54 |  | PN444 |  | PN444 | SN6
PN123 | SN1 |  | PN555, [NAME] |  | PN555 | SN3
Spreadsheet: 62045d1262946959-timekeeping-example
Sheet: Sheet3

Level | Count | Result |  |  |  |  | Hour Worked Hour: Min |  |  |  | Hour Worked Hour: Min
1001 | 1234 |  | Level | Qty | Box# |  | Mon | [NAME] |  |  | Mon | [NAME]
1006 | 910 |  |  |  |  |  | 08:30:00 | 04:00:00 |  |  | 08:30:00 | 04:00:00
1007 | 728 |  |  |  |  |  | 02:00:00 | 04:00:00
1008 | 560
1009 | 718
1010 | 704
1011 | 146
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Jul2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-07-01 00:00:00
2021-07-02 00:00:00
2021-07-03 00:00:00
2021-07-04 00:00:00
2021-07-05 00:00:00
2021-07-06 00:00:00
2021-07-07 00:00:00
2021-07-08 00:00:00
2021-07-09 00:00:00
2021-07-10 00:00:00
2021-07-11 00:00:00
2021-07-12 00:00:00
2021-07-13 00:00:00
2021-07-14 00:00:00
2021-07-15 00:00:00
2021-07-16 00:00:00
2021-07-17 00:00:00
2021-07-18 00:00:00
2021-07-19 00:00:00
2021-07-20 00:00:00
2021-07-21 00:00:00
2021-07-22 00:00:00
2021-07-23 00:00:00
2021-07-24 00:00:00
2021-07-25 00:00:00
2021-07-26 00:00:00
2021-07-27 00:00:00
2021-07-28 00:00:00
2021-07-29 00:00:00
2021-07-30 00:00:00
2021-07-31 00:00:00
Totals:
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: February

Employee Absence Schedule
February | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 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 | 302 | 31 | CL | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] |  |  |  |  |  | T | T
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
 |  |  |  |  |  | Cl | Call-in |  |  | T |  |  |  | NCNS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No show
Spreadsheet: 477638d1472447933-conventional-index-match-not-perhaps-2-other-ways-with-condition-index-match-2-other-ways-or-might-need-offset
Sheet: Desired Index-Match 2

VALUE-1 | POINTS-1 | VALUE-2 | POINTS-2 | VALUE-3 | POINTS-3 | VALUE-4 | POINTS-4 | VALUE-5 | POINTS-5 | VALUE-6 | POINTS-6
100 | 4 | 10 | 7 | 10 | 7 | 99 | 4 | 13 | 35 | 120 | 4
110 | 4 | 31 | 6 | 14 | 6 | 2 | 4 | 34 | 22 | 100 | 4 |  |  |  |  |  |  | Value  1  -> | 120 | 115 | 110 | 105 | 101 | 100 | 99 | 93 |  | 90
105 | 4 | 18 | 5 | 25 | 6 | 92 | 4 | 93 | 4 | 116 | 4 |  |  |  |  |  |  | Points 1  ->
115 | 4 | 26 | 5 | 90 | 4 | 93 | 4 | 99 | 4 | 90 | 4
120 | 4 | 14 | 5 | 116 | 4 | 90 | 4 | 100 | 4 | 101 | 4 |  |  |  |  |  |  | Value  2  -> | 112 | 110 | 105 | 101 | 100 | 90 | 5
101 | 4 | 90 | 4 | 120 | 4 | 101 | 4 | 120 | 4 | 93 | 4 |  |  |  |  |  |  | Points 2  -> | 4 | 4 | 4 | 4 | 4 | 4 | 4
90 | 4 | 101 | 4 | 100 | 4 | 120 | 4 | 116 | 4 | 92 | 4
93 | 4 | 112 | 4 | 99 | 4 | 115 | 4 | 90 | 4 | 33 | 4 |  |  |  |  |  |  | Value  3  -> | 120 | 116 | 110 | 105 | 100 | 99 | 93 | 90 | 12
92 | 4 | 100 | 4 | 93 | 4 | 105 | 4 | 2 | 4 | 16 | 4 |  |  |  |  |  |  | Points 3  -> | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
99 | 4 | 110 | 4 | 12 | 4 | 110 | 4 | 36 | 3 | 34 | 4
2 | 3 | 105 | 4 | 110 | 4 | 100 | 4 | 24 | 3 | 8 | 4 |  |  |  |  |  |  | Value  4  -> | 120 | 115 | 110 | 105 | 101 | 100 | 99 | 93 | 92 | 90 | 2 | 1
29 | 3 | 5 | 4 | 105 | 4 | 1 | 4 | 17 | 3 | 26 | 4 |  |  |  |  |  |  | Points 4  ->
30 | 3 | 9 | 4 | 33 | 4 | 6 | 3 | 8 | 3 | 9 | 4
6 | 3 | 29 | 4 | 24 | 4 | 35 | 3 | 9 | 3 | 27 | 4 |  |  |  |  |  |  | Value  5  -> | 120 | 116 | 100 | 99 | 93 | 90 | 2
4 | 2 | 27 | 3 | 9 | 3 | 30 | 3 | 3 | 3 | 11 | 4 |  |  |  |  |  |  | Points 5  -> | 4 | 4 | 4 | 4 | 4 | 4 | 4
20 | 2 | 7 | 3 | 22 | 3 | 31 | 3 | 23 | 3 | 29 | 4
23 | 2 | 30 | 3 | 15 | 3 | 18 | 3 | 12 | 3 | 18 | 1 |  |  |  |  |  |  | Value  6  -> |  | 116 | 101 | 100 | 93 | 92 | 90 | 34 | 33 | 26 | 16 | 8
7 | 2 | 34 | 3 | 35 | 3 | 23 | 3 | 20 | 2 | 36 | 1 |  |  |  |  |  |  | Points 6  ->
18 | 2 | 22 | 3 | 23 | 3 | 15 | 3 | 30 | 2 | 7 | 0
17 | 2 | 15 | 3 | 3 | 3 | 9 | 2 | 35 | 2 | 25 | 0
10 | 1 | 36 | 2 | 29 | 3 | 33 | 2 | 29 | 2 | 17 | 0
33 | 1 | 13 | 2 | 6 | 3 | 32 | 2 | 7 | 2 | 35 | 0
21 | 1 | 12 | 2 | 36 | 3 | 7 | 2 | 33 | 2 | 3 | 0
8 | 1 | 4 | 2 | 11 | 2 | 34 | 2 | 27 | 2 | 21 | 0
16 | 1 | 17 | 2 | 21 | 2 | 36 | 2 | 6 | 2 | 5 | 0
35 | 1 | 6 | 2 | 8 | 2 | 3 | 2 | 4 | 2 | 23 | 0
31 | 1 | 28 | 2 | 32 | 2 | 10 | 2 | 1 | 1 | 1 | 0
13 | 1 | 35 | 2 | 19 | 2 | 21 | 2 | 14 | 1 | 19 | 0
36 | 1 | 8 | 2 | 16 | 2 | 13 | 1 | 25 | 1 | 2 | 0
9 | 1 | 24 | 2 | 18 | 2 | 27 | 1 | 5 | 1 | 20 | 0
12 | 1 | 2 | 1 | 17 | 1 | 24 | 1 | 2 | 1 | 14 | 0
15 | 0 | 20 | 1 | 30 | 1 | 5 | 1 | 32 | 0 | 32 | 0
34 | 0 | 33 | 1 | 31 | 1 | 14 | 1 | 26 | 0 | 6 | 0
22 | 0 | 25 | 1 | 4 | 1 | 12 | 1 | 28 | 0 | 24 | 0
3 | 0 | 19 | 0 | 34 | 1 | 8 | 0 | 19 | 0 | 4 | 0
24 | 0 | 32 | 0 | 13 | 0 | 2 | 0 | 11 | 0 | 22 | 0
Spreadsheet: 720170d1614048822-inserting-additional-criteria-to-an-if-statement-worktimecalcefupdated
Sheet: Incorrect

STRT | END | WRK | RT | ST | OT |  | Overall Day
 |  |  |  |  |  |  | Report | 05:08:00
 |  |  |  |  |  | Incorrect | Start Shift
 |  |  |  | 7.75 | 1.5 | Correct | End Shift | 09:37:00
 |  |  |  |  |  |  | 1st Half Pay
 |  |  |  |  |  |  |  | Break
 |  |  |  |  |  |  | Report | 13:02:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | 11th Hour
 |  |  |  |  |  |  | End Shift | 17:52:00
 |  |  |  |  |  |  | Straight Time
 |  |  |  |  |  |  | Overtime
Spreadsheet: 0719ca6f-edb4-4bcd-805a-b4a22c4bf2e1
Sheet: Travel (580)

Part II Budget Detail
Expenditures for transportation, meals, hotel, and other expenses associated with staff (on payroll) travel for the school.  Payments for per-diem in lieu of
reimbursements for subsistence (room and board) also are charged here.  Provide details such as names of staff (on payroll) who will be conducting
activities of this project and will be drawing from this fund source.
Travel (580)
Description | Project Year 1 | Project Year 2 | Project Year 3 | Total
Spreadsheet: kimberly_watson__20592__Michelle - timeline
Sheet: PROS

ET&S REVENUE MANAGEMENT PROJECT
Timeline Differences
High Level Timeline
 | 1999-07-01 00:00:00 | 1999-08-01 00:00:00 | 1999-09-01 00:00:00 | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00
 | Stage 1 |  |  |  |  | 12/99
 |  |  | Stage 2 |  |  | 12/99
 |  |  |  |  |  | Stage 3 |  |  | 3/99
 |  |  |  |  |  |  | Stage 4 |  |  |  |  | 6/00
 |  |  |  |  |  |  |  |  |  |  |  |  | Stage 5 |  |  | 10/00
Project Plan Detailed Timeline
 | 1999-07-01 00:00:00 | 1999-08-01 00:00:00 | 1999-09-01 00:00:00 | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00
 | Pre-Launch 7/6/99 | 8/16/99
 | Stage 1           7/6/99 |  |  |  |  | 12/16/99
 |  | Stage 2                8/16/99 |  |  |  | 12/16/99 | 1/26/00
 |  |  |  |  |  | Stage 3                12/16/99 |  |  |  | 4/13/00 |  |  | 7/26/00
 |  |  |  |  |  |  | Stage 4                1/4/00 |  |  |  |  | 6/29/00 | 7/26/00
 |  |  |  |  |  |  |  |  |  |  |  | Stage 5                6/29/00 |  |  |  | 10/27/00 | 11/2/00
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0106

 | Date: | 2013-01-06 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 5 | 35.56
 | 11:00:00 | 30 | 185.19
 | 12:00:00 | 57 | 496.59
 | 13:00:00 | 56 | 502.87
 | 14:00:00 | 54 | 359.36
 | 15:00:00 | 35 | 275.34
 | 16:00:00 | 44 | 307.18
 | 17:00:00 | 31 | 247.94
 | 18:00:00 | 35 | 339.89
 | 19:00:00 | 35 | 270.29
 | 20:00:00 | 28 | 233.02
 | 21:00:00 | 20 | 117.04
 | 22:00:00 | 17 | 115.21
 | 23:00:00 | 9 | 52.53
 | 1900-01-01 00:00:00 | 6 | 34.11
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 731215d1620231763-conditional-format-consecutive-numbers-2017-remission-figures
Sheet: Sheet1

 | Month | Movement
 | Jan | 79
 | Feb | 82
 | Mar | 77
 | Apr | 70
 | May | 123
 | Jun | 157
 | Jul | 118
 | Aug | 78
 | Sep | 141
 | Oct | 90
 | Nov | 101
 | Dec | 49
 | Total
 | Busiest Consecutive
Spreadsheet: 165338d1341183524-project-timeline-calculation-it-contracting-pipeline-by-state-07012012
Sheet: Plan

 | Table3
 | State | FY2010_SP | Cnty_Agcy | P_Sec_Inst | Contacts | [NAME] | Start | Finish | PLACEMENT
 | California | 2409.487604556806 | 58 | 70 |  |  | 2012-07-01 00:00:00
 | New York | 1788.824460552066 | 62 | 101
 | Texas | 1215.428490624481 | 254 | 60
 | Illinois | 1189.191343407895 | 100 | 49
 | Ohio | 1034.534305810557 | 88 | 52
 | Pennsylvania | 821.4270940853368 | 67 | 83
 | Florida | 793.3814105877623 | 67 | 30
 | North Carolina | 666.9240753706189 | 98 | 46
 | New Jersey | 614.6944819628037 | 21 | 27
 | Massachusetts | 611.2163809290954 | 14 | 56
 | Wisconsin | 563.2109672357537 | 72 | 29
 | Alabama | 541.815359554758 | 67 | 25
 | Louisiana | 541.12863199888 | 64 | 20
 | Georgia | 511.761790684774 | 159 | 36
 | Virginia | 491.8142053249891 | 136 | 40
 | Michigan | 487.8569663581036 | 83 | 36
 | Washington | 465.9488193119547 | 39 | 16
 | Maryland | 432.399270856357 | 23 | 23
 | Indiana | 403.7032272217629 | 92 | 42
 | Arizona | 374.109317530906 | 15 | 5
 | Minnesota | 371.129504765048 | 87 | 25
 | Mississippi | 366.7035803161941 | 82 | 15
 | Connecticut | 358.7975435739108 | 8 | 19
 | West Virginia | 354.9620868710744 | 55 | 17
 | Kentucky | 348.7425247458587 | 120 | 24
 | Missouri | 331.296430914615 | 114 | 15
 | Tennessee | 312.145893646529 | 95 | 34
 | Arkansas | 283.1521335552869 | 75 | 17
 | Colorado | 264.8473793475591 | 64 | 16
 | Oklahoma | 262.4666484496651 | 77 | 20
 | Iowa | 248.8896416118606 | 99 | 29
 | Oregon | 228.1122513673997 | 36 | 18
 | Kansas | 202.4469543453758 | 103 | 20
 | New Mexico | 202.1081708726665 | 33 | 9
 | South Carolina | 197.4019168919547 | 46 | 26
 | Alaska | 171.9302437702147 | 27 | 4
 | Hawaii | 171.8594537298531 | 5 | 5
 | Utah | 146.4173466883235 | 29 | 6
 | Nevada | 146.092768419409 | 17 | 3
 | Nebraska | 131.3181955874834 | 93 | 16
 | Delaware | 117.6701565096356 | 3 | 5
 | Maine | 104.3968447839554 | 16 | 14
 | Rhode Island | 86.43239372222516 | 5 | 8
 | Idaho | 85.67050242156533 | 44 | 9
 | Montana | 77.85876681692753 | 57 | 9
 | New Hampshire | 73.4864229696679 | 10 | 13
 | Wyoming | 66.81075940528135 | 23 | 1
 | Vermont | 65.03012962767303 | 14 | 14
 | North Dakota | 57.69276203594998 | 53 | 8
 | South Dakota | 49.27238827117637 |  | 11
 | Total
Spreadsheet: 796555d1663345448-drag-formula-that-needs-symbols-across-columns-got-it-to-work
Sheet: Sheet1

 | Word | Letters |  | Number of Letters | 6 | 1 | 3
 | Thanks
 | Thanks |  |  |  | Thanks |  | Lot
 | Thanks |  |  |  | Thanks |  | Lot
 | Thanks |  |  |  | Thanks
 | Thanks |  |  |  | Thanks
 | Thanks |  |  |  | Thanks
 | A
 | Lot
 | Lot
 | Lot
Spreadsheet: 887656d1737949422-index-sumproduct-spill-issue-afl-supercoach-2025-test
Sheet: COL

PLAYER | TOT | AVG |  |  |  | 0 | 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
 |  | CBA | CBA 1H | CBA2H | CBA L5
[NAME] | 489 |  |  |  |  | 64 | 54 | 70 | 44 | 58 |  | 85 | 75 | 79 | 67 | 85 | 71 | 84 | 91 | 88 |  | 84 | 82 | 81 | 91 | 74 | 81 | 71 | 62 | 73
[NAME] | 482 |  |  |  |  | 79 | 57 | 57 | 26 | 88 |  | 61 | 57 | 89 | 88 | 85 | 83 | 84 | 70 | 83 |  | 84 | 86 | 81 | 64 | 85 | 85 | 89 | 69 | 54
[NAME] | 364 |  |  |  |  | 39 | 61 | 60 | 70 | 33 |  | 52 | 64 | 75 | 79 | 93 | 71 |  |  |  |  | 71 | 68 | 41 | 67 | 70 | 77 | 86 | 73 | 62
[NAME] | 237 |  |  |  |  | 76 | 75 | 73 | 85 | 83 |  | 76 | 75 |  |  | 0 |  |  |  |  |  | 39 | 79 | 74 | 70 |  | 12
[NAME] | 103 |  |  |  |  | 39 |  | 57 | 67 | 67 |  | 73 | 54
[NAME] | 362 |  |  |  |  | 21 | 39 | 3 | 30 | 21 |  | 27 | 36 | 68 | 79 | 81 | 83 | 77 | 91 | 88 |  | 74 | 68 | 48 | 58 | 78 | 69 | 68 | 42 | 31
[NAME] | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 65
[NAME] | 62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 56 | 6 | 52 | 58 | 36 | 23
[NAME] | 130 |  |  |  |  | 36 | 46 | 30 | 56 | 42 |  | 15 | 25 | 21 | 33 | 15 | 17 |  |  |  |  |  |  |  |  | 26 | 19 | 29 | 38 | 27
[NAME] | 62 |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 25 | 26 | 25 | 26 | 39 | 15 |  | 23 |  |  | 0 | 15
Finlay Macrae | 54 |  |  |  |  |  | 32 | 27 | 22 |  |  |  |  |  | 13 | 4 |  | 0 | 61 | 20 |  |  |  |  |  |  |  |  |  | 19
[NAME] | 67 |  |  |  |  | 0 | 0 | 0 |  | 0 |  | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 4 | 33 |  | 0 | 0 | 0 | 21 | 0 | 0 | 18 | 81 | 69
[NAME] | 51 |  |  |  |  | 24 | 0 | 0 | 0 | 0 |  | 0 | 0 | 14 |  |  | 17 | 55 | 4 | 38 |  | 3 |  |  |  |  | 0 | 0 | 4 | 0
[NAME] | 64 |  |  |  |  | 18 | 18 | 10 | 0 | 8 |  | 3 | 7 | 0 | 17 | 11 | 21 | 35 | 26 | 23 |  | 3 | 0 | 0 | 18 | 0 | 0 | 0 | 0 | 0
[NAME] | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 5 |  | 16 | 18 | 11 | 0
[NAME] | 32 |  |  |  |  | 3 | 18 | 10 | 0 | 0 |  | 9 | 0 | 21 | 0 | 0 | 0 | 23 | 4 | 3 |  | 3 | 0 | 0 | 3 | 0 | 0 | 4 | 8 | 0
[NAME] | 15 |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 13 | 16 | 9 | 8 |  | 0 | 0 | 7 |  |  | 0 | 0 | 0
[NAME] | 1 |  |  |  |  | 0 | 0 | 3 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0
Total Team CBAs |  |  |  |  |  | 33 | 28 | 30 | 27 | 24 |  | 33 | 28 | 28 | 24 | 27 | 24 | 31 | 23 | 40 |  | 31 | 28 | 27 | 33 | 27 | 26 | 28 | 26 | 26
Spreadsheet: 59077d1259510192-generate-a-master-spreadsheet-master
Sheet: Sheet1

Initiatives | Implementation Months | Category | Elec. Saved kW | Utilisation | MWh saved per year | CAPEX | Elec. Savings R/yr | Opex R/yr | Pay back yrs | Relative CAPEX R million /MW
a |  |  |  |  | 0 |  | 0 |  | #N/A | #N/A
a |  |  |  |  | 0 |  | 0 |  | #N/A | #N/A
Spreadsheet: 847982d1698805719-cannot-get-closest-match-to-work-within-reverse-lookup-with-a-2-dimensional-array-testdata-revlookup-closestmatch-2darray
Sheet: Sheet2

GOAL - To be able to do a Reverse Lookup for a Closest Match result
 | Currently am able to perform a Reverse lookup with an [NAME]for multiple categories, and a Reverse Lookup with [NAME] for a single category.
 | Example:  If I am in category 1003 and I sell 3,100 units, I am closest the 3rd percentile, but the formula yield 2nd percentile.
 | GIVEN #1:  CATEGORY | 1003
 | GIVEN #2: UNITS | 2900 |  | Example:  If I am in category 1003 and I sell 3,100 units, I am at the 3rd percentile
 | ANSWER WANTED: WHICH PERCENTILE? | 0.02 |  | #N/A
 | Exact Match Formula Description
F1: | Exact Match Formula for This Scenario
 | Exact Match Test | 0.02 | If I am in category 1003 and I sell 3,000 units, I am at the 3rd %tile.  However, if I sell 2,900 units my closest match should be 3%tile
F2: | Closest Match Formula for just one category row | {=INDEX(B1:G1,MATCH(MIN(ABS(B4:G4-J4)),ABS(B4:G4-J4),0))}      Note: brackets are from Ctrl+Shift+Enter
 | Result using Category 1003 and Units 3100 | 0.03 | If I am in category 1003 and I sell 3,100 units, I am at the 3rd percentile
 | Attempts to incorporate both | =INDEX(B1:G1,,MATCH((MIN(ABS(B4:[NAME]:G6,MATCH(J4,A2:[NAME])))
 | Question - Need to nest another INDEX function and/or how to incorporate the MIN & ABS functions?
Spreadsheet: kate_symes__18181__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800
 | 2001-02-25 00:00:00 |  |  |  |  |  | 132.88 | 14400
 | 2001-02-24 00:00:00 |  | 177.7 | 16000 | 131.62 | 11200
 | 2001-02-23 00:00:00 |  | 179.36 | 17040 | 131.62 | 11200
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
 | 2001-02-18 00:00:00 |  |  |  |  |  | 261.52 | 23280
 | 2001-02-17 00:00:00 |  | 323.71 | 16720 | 264.62 | 8840
 | 2001-02-16 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-15 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-14 00:00:00 |  | 267.18 | 20320 | 202.45 | 6200
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
 | 2001-02-12 00:00:00 |  | 195.13 | 7760 | 159.51 | 6920
 | 2001-02-11 00:00:00 |  |  |  |  |  | 159.15 | 18960
 | 2001-02-10 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-09 00:00:00 |  | 154.29 | 10160 | 124.69 | 6320
 | 2001-02-08 00:00:00 |  | 175.42 | 14400 | 142.48 | 5160
 | 2001-02-07 00:00:00 |  | 170.73 | 11184 | 140.82 | 10680
 | 2001-02-06 00:00:00 |  | 167.38 | 11280 | 146.9 | 6640
 | 2001-02-05 00:00:00 |  | 165.77 | 7120 | 151.67 | 6392
 | 2001-02-04 00:00:00 |  |  |  |  |  | 152.31 | 20376
 | 2001-02-03 00:00:00 |  | 181.02 | 12256 | 156.16 | 8432
 | 2001-02-02 00:00:00 |  | 179.62 | 13336 | 156.19 | 7512
 | 2001-02-01 00:00:00 |  | 219.11 | 13984 | 176.57 | 4368
 | 2001-01-31 00:00:00 |  | 238.8 | 20288 | 184.92 | 4640
 | 2001-01-30 00:00:00 |  | 222.41 | 19968 | 176.45 | 6240
 | 2001-01-29 00:00:00 |  | 227.4 | 21840 | 181.89 | 4440
 | 2001-01-28 00:00:00 |  |  |  |  |  | 181.89 | 13320
Spreadsheet: 185585d1349775591-dynamic-vlookups-ordinary-sumproduct
Sheet: Sheet1

Location | Location A | Location B | Location C |  |  |  | [NAME]
Item A | 500 | 0 | 20
Item B | 50 | 20 | 30
Item C | 0 | 0 | 10
Item D | 12 | 15 | 10
Total Price