tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50500ba0-2a39-490d-944b-e80726cb864f
Sheet: Table 2.3

Monthly Statistical Bulletin
2.3 Wage price index
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Wage price index (a) (b) – index
September | 101.8 | 105.5 | 109.3 | 113.4 | 116.4
December | 102.6 | 106.6 | 110.4 | 114.2 | 117.2
March | 103.6 | 107.6 | 111.4 | 115 | 118
June | 104.4 | 108.4 | 112.5 | 115.8 | 118.7
Annual average | 103.125 | 107.025 | 110.9 | 114.575 | 117.575
Quarterly change (b) – per cent
September | 0.4935834155972429 | 1.053639846743293 | 0.830258302583009 | 0.8000000000000007 | 0.5181347150259086
December | 0.7858546168958647 | 1.042654028436019 | 1.006404391582816 | 0.7054673721340388 | 0.6872852233676952
March | 0.974658869395717 | 0.9380863039399667 | 0.9057971014492683 | 0.7005253940455258 | 0.682593856655278
June | 0.7722007722007929 | 0.743494423791824 | 0.9874326750448859 | 0.6956521739130306 | 0.5932203389830581
Annual change (b) – per cent
September | 3.140830800405259 | 3.63457760314343 | 3.601895734597149 | 3.751143641354071 | 2.645502645502651
December | 2.908726178535592 | 3.898635477582846 | 3.564727954971869 | 3.442028985507251 | 2.626970227670755
March | 2.982107355864816 | 3.861003861003853 | 3.531598513011169 | 3.23159784560143 | 2.60869565217392
June | 3.060217176702862 | 3.831417624521083 | 3.782287822878216 | 2.933333333333321 | 2.504317789291877
Annual average | 3.124999999999986 | 3.781818181818188 | 3.620649380985751 | 3.313796212804339 | 2.596371578659801
(a) Total hourly rate of pay excluding bonuses, all sectors. Index base: 2008–09 = 100.0.
(b) Quarterly figures are seasonally adjusted.
Source: ABS, Wage Price Index, Australia, Cat. no. 6345.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6345.0&viewtitle=Labour%20Price%20Index,%20Australia~Dec%202007~Latest~20/02/2008&&tabname=Past%20Future%20Issues&prodno=6345.0&issue=Dec%202007&num=&view=&
Note: Prior to September quarter 2012, this publication was known as Labour Price Index. The catalogue number (6345.0) remains unchanged.
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 12 November 2015
Spreadsheet: 852977d1702946423-vlookup-i-think-for-getting-info-between-these-2-charts-combo-copy
Sheet: Sheet1

Item | Description | Price | Qty | Lead Time
METSACRYLIQ0064 | ** HAZMAT SHIPS FROM DTAMP Fast Cure Acrylic Liquid 64 Ounces | 98.85 | 91 | 14
METSACRYPOW0005 | ** HAZMAT SHIPS FROM DTAMP Fast Cure Acrylic Powder  5 lb Container | 152.23 | 84 | 14
METSACUT007HNFT | [NAME] For Hard Non  Ferr 7" x .035 x .500" (10/PK) | 156.36 | 9 | 60
METSACUT010HNFT | [NAME] 10"x.062"x32MM 10/Bx | 212.36 | 7 | 60
[NAME] | [NAME] RC45 10"x.062"x32MM (10 Pk) | 858.41 | 4 | 60
METSACUT012HS60 | [NAME] RC60 12"x.062"x32MM 10/Bx | 712.41 | 19 | 60
METSACUT228HNFT | [NAME] SiC Non-Ferrous 10/Bx. | 312.52 | 3 | 60
METSACUT228HS60 | [NAME] For RC60 Steel 10/Bx. | 487.52 | 6 | 60
METSACUTGFL0128 | ** HAZMAT SHIPS FROM DTAMP Water Soluble Cutting Fluid Gold Formula Gallon | 52.41 | 21 | 14
METSALSY.050GAL | [NAME] Micron 1 Gallon | 666.13 | 5 | 14
METSBAKEGRN0025 | ** POURABLES SHIP FROM DTAMP Green Phenolic Powder 25 [NAME]. | 144.92 | 16 | 7
[NAME] | Metal Mounting Clip 100/Pk. | 37.64 | 173 | 30
[NAME] | Plastic Mounting Clip 100/Pack | 38.53 | 416 | 30
METSCOLLCS50128 | Colloidal Silica Suspension 0.05 [NAME] | 186.62 | 15 | 7
METSDCUTW05H015 | [NAME]Conc 5"x.015"x.5" | 361.04 | 11 | X
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 517611 | 7548036 | 517611 | 746161 | 1035222 | 8294197
 | Loans |  | 21500 |  |  |  | 21500
 | Municipal |  | 3361 |  | <1,000 |  | 3361
 | Recovery
 | Sovereign | 33599 | 2653381 | 33599 | 238871 | 67199 | 2892251
Index Tranche | Asia |  |  |  | <100 |  | <100
 | Europe |  | 797854 |  | 86366 |  | 884220
 | North America |  | 894465 |  | 33463 |  | 927929
Index | Asia | 1313 | 294826 | 1613 | 46067 | 2926 | 340893
 | Europe | 280157 | 2503090 | 280187 | 393030 | 560345 | 2896120
 | North America | 459676 | 1457453 | 487374 | 322839 | 947050 | 1780292
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL |  | 1292357 | 16173965 | 1320385 | 1866797 | 2612741 | 18040762
Estimated gross notional amount outstanding, January 18 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 140051d1328610616-excel-vlookup-with-max-statement-into-another-table-test-2
Sheet: Sheet2

Original Table with Multiple amounts per user |  |  |  |  | New Table
User | PRODUCT_ID | ACTIVITY_AMOUNT |  |  | User | PRODUCT_ID | Activity Amount
A | 195597 | 1.99 |  |  | A
A | 704627 | 15 |  |  | B
A | 158876 | 19.99 |  |  | C
A | 308304 | 1 |  |  | D
A | 292412 | 5 |  |  | E
A | 277074 | 155.66 |  |  | F
B | 919993 | 22.99 |  |  | G
B | 283007 | 299.99 |  |  | H
C | 252213 | 2
C | 216627 | 117.72
D | 226964 | 1299.99
D | 243480 | 237.66
E | 261730 | 14.99
E | 277462 | 149.99
E | 159775 | 79.99
F | 273438 | 49.99
F | 264205 | 99.99
G | 970673 | 99.9
G | 295175 | 99.99
H | 239082 | 49.99
H | 273594 | 59.99
H | 229240 | 16.49
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Fundies-Hou

 | Fundamentals
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 | 1
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 6
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 4
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 4
 |  |  |  |  |  |  |  | Director | 143000 | 1
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  |  | 1
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: e39735e1-d7bf-47de-ae05-d9599a3d7684
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
FOL | Test | FOL | Folate, Serum | Folate, S | Competitive Binding Receptor Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL Collection Instructions: Fasting (8 hours) Additional Information: Do not order on patients who have recently received methotrexate or other folic acid antagonists. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =4.0 mcg/L <4.0 mcg/L suggests folate deficiency | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same Day/1 day | 3 days | 1 | 82746 |  |  |  |  | Rochester
FOL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FOL | Result | FOL | Folate, S | Folate, S | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 2284-8
Spreadsheet: 159562d1338749668-return-all-values-based-on-a-date-range-book1
Sheet: MasterList

Client name | Date | Priority | Description
a | 2012-06-04 00:00:00 | 1 | Some Description here 1
b | 2012-06-04 00:00:00 | 2 | Some Description here 2
c | 2012-06-04 00:00:00 | 3 | Some Description here 3
d | 2012-06-03 00:00:00 | 4 | Some Description here 4
e | 2012-06-06 00:00:00 | 5 | Some Description here 5
f | 2012-06-06 00:00:00 | 6 | Some Description here 6
g | 2012-06-06 00:00:00 | 7 | Some Description here 7
h | 2012-06-07 00:00:00 | 8 | Some Description here 8
i | 2012-06-07 00:00:00 | 9 | Some Description here 9
j | 2012-06-07 00:00:00 | 10 | Some Description here 10
k | 2012-06-07 00:00:00 | 11 | Some Description here 11
l | 2012-06-07 00:00:00 | 12 | Some Description here 12
m | 2012-06-07 00:00:00 | 13 | Some Description here 13
n | 2012-06-07 00:00:00 | 14 | Some Description here 14
o | 2012-06-07 00:00:00 | 15 | Some Description here 15
p | 2012-06-07 00:00:00 | 16 | Some Description here 16
q | 2012-06-07 00:00:00 | 17 | Some Description here 17
r | 2012-06-11 00:00:00 | 18 | Some Description here 18
s | 2012-06-13 00:00:00 | 19 | Some Description here 19
t | 2012-12-15 00:00:00 | 20 | Some Description here 20
u | 2012-07-07 00:00:00 | 21 | Some Description here 21
v | 2012-07-17 00:00:00 | 22 | Some Description here 22
w | 2012-07-17 00:00:00 | 23 | Some Description here 23
x | 2012-07-17 00:00:00 | 24 | Some Description here 24
y | 2012-07-17 00:00:00 | 25 | Some Description here 25
z | 2012-07-17 00:00:00 | 26 | Some Description here 26
Spreadsheet: 858455d1707146889-sumif-with-a-concatenate-in-the-first-argument-sumif-with-a-concatenate-in-the-first-argument-copia
Sheet: Planilha2

Sis.G | Sis.C | Sis.D | Sis.V | Sis.D | Sis.O
Income | ub | Lumi | 2720 | 2024-02-05 00:00:00 | Al
Income | ub | Alie | 1440 | 2024-02-05 00:00:00 | Al
Income | ub | Ocai | 900 | 2024-02-02 00:00:00 | Al
Income | ub | Ocai | -90 | 2024-02-02 00:00:00 | De
Income | ub | [NAME] | 480.39 | 2024-01-13 00:00:00 | Al
Income | ub | [NAME] | 9.61 | 2024-01-13 00:00:00 | Mu
Income | ub | [NAME] | 1500 | 2024-01-10 00:00:00 | Al
Income | ub | [NAME] | -2.9 | 2024-01-10 00:00:00 | Ta
Income | ub | Espa | 4500 | 2024-01-10 00:00:00 | Al
Income | ub | Espa | 4000 | 2024-01-10 00:00:00 | Al
Income | ub | Espa | 3000 | 2024-01-10 00:00:00 | Al
Income | ub | Espa | 65.68 | 2024-01-10 00:00:00 | Co
Income | ub | Espa | 65.68 | 2024-01-10 00:00:00 | Co
Income | ub | Espa | 29.81 | 2024-01-10 00:00:00 | Co
Income | ub | Espa | 29.81 | 2024-01-10 00:00:00 | Co
Income | ub | Espa | -2.9 | 2024-01-10 00:00:00 | Ta
Income | ub | Espa | -2.9 | 2024-01-10 00:00:00 | Ta
 |  | TOTAL | 18642.28
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -2
2 | -1
3
4
5 | -896
6 | -2012
7 | -2035 | 681
8 | -2068 |  |  |  |  |  |  |  |  |  | Avg
9 | -1970 | 908 |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
10
11 |  |  |  |  |  |  | 2001-01-01 00:00:00 | -50582 | -68700 |  | 8.21
12 |  |  |  |  |  |  | 2001-02-01 00:00:00 | -54068 | -70278 |  | 5.62
13 |  |  |  |  |  |  | 2001-03-01 00:00:00 | -58719 | -82564 |  | 4.98
14 |  |  |  |  |  |  | 2001-04-01 00:00:00 | -52309 | -39370 |  | 4.87
15 |  |  |  |  |  |  | 2001-05-01 00:00:00 | -57841 | -49325 |  | 3.82
16 |  |  |  |  |  |  | 2001-06-01 00:00:00 | -50325 | -65214 |  | 3.2
17 |  |  |  |  |  |  | 2001-07-01 00:00:00 | -43678 | -59252 |  | 2.77
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -355805
2002-01-09 00:00:00
CBS Volume
 |  |  | -44621
Spreadsheet: 266813d1379754479-formula-to-obtain-different-rows-between-ranges-samplefile
Sheet: Hoja1

[NAME] | Car Type | Number Sold | Unit Price |  |  | # | [NAME] | Car Type | Number Sold | Unit Price
Barnhill | [NAME] | 5 | 2200 |  |  | 13 | Barnhill | [NAME] | 5 | 2200
Ingle | [NAME] | 6 | 2300 |  |  | 7 | Ingle | [NAME] | 6 | 2300
Jordan | Rone | 3 | 2000 |  |  | 32 | Jordan | [NAME] | 3 | 2000
Pike | [NAME] | 9 | 2150 |  |  | 2 | Pike | [NAME] | 9 | 2150
Sanchez | [NAME] |  | 2250 |  |  | 91 | Sanchez | [NAME] | 6 | 2250
Belcher |  | 8 | 2000
32 | Jordan | Rone | 3 | 2000
91 | Sanchez | [NAME] |  | 2250
 | Belcher |  | 8 | 2000
Spreadsheet: rick_buy__32796__NP Daily Marks
Sheet: COB 091901

The New Power Company
Credit Exposure by Enron Entity
As of COB September 19, 2001
Enron Entity | Fin. MTM | Phy. MTM | Net Del. (1) | Net Exp.
Enron Energy Services, Inc. | 5074723 | 41803257 | 301295
Enron North America Corp. | 51276017 | 5906879 | 6922098
Enron Power Marketing, Inc. | 0 | 7715129
 |  |  | In Collateral (2) | -109300000
 |  |  | Treashold (3) | 0
 |  |  | Total Exposure
(1) Net Del. For EPMI capacity payments have been adjusted to reflect EnPower's marks
(2) Per Master Netting Agreement Collateral in the amount of $109.3MM is applied across Enron Entities
(3) Not in compliance with unrestricted cash covenant
Spreadsheet: 118333d1313612234-weekly-total-transferred-to-other-workbook-week-1
Sheet: Table

PREMIER LEAGUE FORECAST
WEEK 1
 | Pos | Name | Pts
 | 1 | [NAME] | 18
 | 2 | [NAME] | 17
 | 3 | [NAME] | 16
 | 4 | [NAME] | 16
 | 5 | [NAME] | 16
 | 6 | Big Slu | 15
 | 7 | [NAME] | 15
 | 8 | [NAME] | 15
 | 9 | [NAME] | 14
 | 10 | [NAME] | 14
 | 11 | [NAME] | 14
 | 12 | [NAME] | 14
 | 13 | [NAME] | 13
 | 14 | [NAME] | 13
 | 15 | [NAME] | 13
 | 16 | [NAME] (Happy G) | 13
 | 17 | [NAME] | 13
 | 18 | [NAME] | 13
 | 19 | [NAME] | 13
 | 20 | D.G.Dillon | 12
 | 21 | [NAME] | 12
 | 22 | R.Lennewell | 11
 | 23 | Amanda Green | 11
 | 24 | [NAME] | 11
 | 25 | [NAME] | 11
 | 26 | [NAME] | 11
 | 27 | [NAME] | 9
 | 28 | [NAME] | 9
 | 29 | [NAME] | 9
 | 30 | [NAME] | 9
 | 31 | [NAME] | 9
 | 32 | [NAME] | 9
 | 33 | [NAME] (Happy G) | 9
 | 34 | [NAME] | 8
 | 35 | [NAME] | 8
 | 36 | [NAME] | 8
 | 37 | [NAME] | 8
 | 38 | [NAME] | 8
 | 39 | [NAME] | 8
 | 40 | [NAME] | 8
 | 41 | [NAME] | 8
 | 42 | [NAME] | 8
 | 43 | Flan | 8
 | 44 | [NAME] | 8
 | 45 | [NAME] | 8
 | 46 | J.Chesworth | 8
 | 47 | [NAME] | 8
 | 48 | [NAME] | 7
 | 49 | T.Biggins | 7
 | 50 | [NAME] | 7
 | 51 | J.Biggins | 6
 | 52 | [NAME] | 6
 | 53 | [NAME] | 6
 | 54 | [NAME] | 6
 | 55 | Stuart Parkinson | 6
 | 56 | [NAME] | 6
 | 57 | D.McLean | 6
 | 58 | [NAME] | 6
 | 59 | [NAME] | 6
 | 60 | [NAME] | 6
 | 61 | [NAME] | 6
 | 62 | [NAME] | 6
 | 63 | [NAME] | 6
 | 64 | [NAME] | 6
 | 65 | Freyah | 4
 | 66 | [NAME] | 4
 | 67 | [NAME] | 4
 | 68 | [NAME] | 4
 | 69 | [NAME] | 4
 | 70 | [NAME] | 4
 | 71 | [NAME] | 4
 | 72 | [NAME] | 4
 | 73 | [NAME] | 4
 | 74 | [NAME] | 4
 | 75 | [NAME] | 4
 | 76 | S.Downing | 2
 | 77 | [NAME] | 2
Spreadsheet: 709466d1608312903-do-i-use-index-and-match-to-count-products-on-different-sheets-stock-check-blanks-2
Sheet: A Aisle

 | Product code | Qty |  |  | Product code | Qty |  |  |  |  |  | A Aisle
A1A | apples | 3 |  | A5A |  |  |  |  |  |  |  | B Aisle
A1B | pears | 76 |  | A5B |  |  |  | want to count all of the different products |  |  |  | C Aisle
A1C | oranges | 44 |  | A5C |  |  |  | on this sheet: |  |  |  | D Aisle
A1D | grapes | 20 |  | A5D |  |  |  |  | This sheet | All sheets |  | E Aisle
A1E | plums | 50 |  | A5E |  |  |  | apples |  |  |  | F Rear Aisle
 |  |  |  |  |  |  |  | pears |  |  |  | F Front Aisle
A2A |  |  |  | A6A |  |  |  | oranges |  |  |  | G Aisle
A2B |  |  |  | A6B |  |  |  | grapes |  |  |  | Z Aisle
A2C |  |  |  | A6C |  |  |  | plums
A2D |  |  |  | A6D
A2E |  |  |  | A6E |  |  |  | Then I want to count all ths same products on the other sheets
 |  |  |  |  |  |  |  | to give me a grand total of my products.
A3A |  |  |  | A7A
A3B |  |  |  | A7B | apples | 2 |  | I have used fruit as an example
A3C |  |  |  | A7C | apples | 19
A3D |  |  |  | A7D | oranges | 5
[NAME] |  |  |  | A7E
A4A |  |  |  | A8A
A4B |  |  |  | A8B
A4C |  |  |  | A8C
A4D |  |  |  | A8D
A4E |  |  |  | A8E
 | Product code | Qty |  |  | Product code | Qty
A9A |  |  |  | A13A
A9B |  |  |  | A13B
A9C |  |  |  | A13C
A9D |  |  |  | A13D
A9E |  |  |  | A13E
A10A |  |  |  | A14A
A10B |  |  |  | A14B
[NAME] |  |  |  | A14C
A10D |  |  |  | A14D
A10E |  |  |  | A14E
A11A |  |  |  | A15A
A11B |  |  |  | A15B
A11C |  |  |  | A15C
A11D |  |  |  | A15D
A11E |  |  |  | A15E
A12A |  |  |  | A16A
A12B |  |  |  | A16B
A12C |  |  |  | A16C
A12D |  |  |  | A16D
A12E |  |  |  | A16E
 | Product code | Qty |  |  | Product code | Qty
A17A |  |  |  | A21A
A17B |  |  |  | A21B
A17C |  |  |  | A21C
A17D |  |  |  | A21D
A17E |  |  |  | A21E
A18A |  |  |  | A22A | apples | 8
A18B | pears | 44 |  | A22B | apples | 1
A18C | oranges | 6 |  | A22C
A18D | grapes | 11 |  | A22D
A18E |  |  |  | A22E
A19A |  |  |  | A23A | pears | 12
A19B | plums | 66 |  | A23B | oranges | 3
A19C | plums | 2 |  | A23C | grapes | 95
A19D |  |  |  | A23D | plums | 2
A19E |  |  |  | A23E
A20A | apples |  |  | A24A
A20B |  |  |  | A24B
A20C | pears |  |  | A24C | plums | 6
A20D | oranges |  |  | A24D
A20E | grapes |  |  | A24E
 | Product code | Qty |  |  | Product code | Qty
A25A |  |  |  | A29A
A25B |  |  |  | A29B | apples | 8
A25C |  |  |  | A29C | apples | 4
A25D |  |  |  | A29D
A25E |  |  |  | A29E
A26A |  |  |  | A30A
A26B |  |  |  | [NAME]
A26C |  |  |  | A30C
A26D |  |  |  | A30D
A26E |  |  |  | A30E
A27A |  |  |  | A31A
A27B |  |  |  | A31B
A27C |  |  |  | A31C
A27D |  |  |  | A31D
A27E |  |  |  | A31E
A28A |  |  |  | A32A
A28B |  |  |  | A32B
A28C |  |  |  | A32C
A28D |  |  |  | [NAME]
A28E |  |  |  | A32E
 | Product code | Qty
A33A
A33B
[NAME]
A33D
A33E
Spreadsheet: 713959d1611040143-vlookup-match-data-in-two-different-columns-with-multiple-criteria-sample-data
Sheet: PIVOT

Final Category | CustomerName | Sum of QTY
[NAME] | GRAND MECURE PUKA PARK  VACATION CLUB2 | 106.1012
 | GRAND MECURE PUKA PARK ( VACATION CLUB) | 3309.47214
 | [NAME]  (CP HOTELS LTD)  ( ) | 17465.46
 | NOVOTEL  CATHEDRAL SQ   ( ) | 91.36
 | NOVOTEL AND IBIS ELLERSLIE  ( ) | 129257.14
 | NOVOTEL  AIRPORT  ( ) | 17147.07
 | [NAME]( ) | 1048.11
 | PULLMAN  PRINCESS ST   ( ) | 11635.41
 | SO   CUSTOM STREET HOTEL LIMITED ( ) | 1790.45
 | SOFITEL   VIADUCT   ( ) | 14521.29
 | THE SEBEL  2 | 114833.5553600002
DISTRIBUTION Total |  | 311205.4187000003
FRESH SEAFOOD | NOVOTEL AND IBIS ELLERSLIE  ( ) | 690.508
 | NOVOTEL  AIRPORT  ( ) | 315.277
 | [NAME]( ) | 5071.596000000001
 | PULLMAN  PRINCESS ST   ( ) | 684.4
 | SOFITEL   VIADUCT   ( ) | 4611.6
FRESH SEAFOOD Total |  | 11373.381
[NAME] | GRAND MECURE PUKA PARK ( VACATION CLUB) | 267.5
 | NOVOTEL AND IBIS ELLERSLIE  ( ) | 12391.7878
 | NOVOTEL  AIRPORT  ( ) | 5193.449999999999
 | PULLMAN  PRINCESS ST   ( ) | 318.93
 | SOFITEL   VIADUCT   ( ) | 1396.01
 | THE SEBEL  2 | 5621.581699999999
FROZEN SEAFOOD Total |  | 25189.2595
MEAT+SMALLGOODS | [NAME]  (CP HOTELS LTD)  ( ) | 18913.9135
 | NOVOTEL  CATHEDRAL SQ   ( ) | 3641.4824
 | NOVOTEL AND IBIS ELLERSLIE  ( ) | 36368.76040000001
 | NOVOTEL  AIRPORT  ( ) | 22422.9741
 | SOFITEL   VIADUCT   ( ) | 6069.778099999999
 | THE SEBEL  2 | 29785.8455
MEAT+SMALLGOODS Total |  | 117202.754
POULTRY+DUCK | GRAND MECURE PUKA PARK ( VACATION CLUB) | 3695.95
 | [NAME]  (CP HOTELS LTD)  ( ) | 19105.5336
 | NOVOTEL  CATHEDRAL SQ   ( ) | 3748.976999999999
 | NOVOTEL AND IBIS ELLERSLIE  ( ) | 26102.2921
 | NOVOTEL  AIRPORT  ( ) | 13398.2038
 | [NAME]( ) | 309.559
 | PULLMAN  PRINCESS ST   ( ) | 2333.68
 | SOFITEL   VIADUCT   ( ) | 5797.404999999999
 | THE SEBEL  2 | 10505.3464
POULTRY+DUCK Total |  | 84996.9469
Grand Total |  | 549967.7601000004
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
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
2002-01-31 00:00:00 |  |  | 17587
2002-02-18 00:00:00
CBS Dollars
 |  |  | 385897
Spreadsheet: 696502d1600863786-need-formula-which-will-ignore-blank-cells-and-find-next-cell-with-value-then-calc-excel-forum
Sheet: MBS1 KBJ210MP

DATE | Diesel |  |  | Benchmark
 | [NAME] | Opening Reading | Closing Reading | Total Litres | KM's travelled | km/L | L/100km
c/f | 14577 | 412821.4 | 412926.4
2020-09-01 00:00:00 | 14964 | 414831.6 | 414967.6
2020-09-04 00:00:00
2020-09-04 00:00:00
2020-09-05 00:00:00 | 15331 | 417376.7 | 417498.2
2020-09-05 00:00:00
2020-09-07 00:00:00
2020-09-07 00:00:00
2020-09-07 00:00:00
2020-09-07 00:00:00
2020-09-08 00:00:00
2020-09-08 00:00:00
2020-09-09 00:00:00
2020-09-10 00:00:00 | 15794 | 419800.9 | 419941.9
2020-09-10 00:00:00
2020-09-10 00:00:00
2020-09-10 00:00:00
2020-09-10 00:00:00
2020-09-10 00:00:00
2020-09-10 00:00:00
2020-09-16 00:00:00 | 16344 | 422516.2 | 422680.2
2020-09-16 00:00:00
2020-09-16 00:00:00
2020-09-17 00:00:00
2020-09-17 00:00:00
2020-09-18 00:00:00 | 16800 | 424251.5 | 424390