tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 11d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | <100 | <100 | <100 | <100 | 142 | 162 | 138 | 442
FRA | 5732 | 5198 | 2876 | 3348 | <100 |  |  | 17154
IRS- [NAME] | <100 | 286 | 432 | 1770 | 6579 | 9620 | 10674 | 29361
OIS | 182 | 326 | 202 | 782 | 114 |  |  | 1606
VNS | <100 |  |  |  |  |  |  | <100
Zero Coupon | <100 |  | <100 | <100 | <100 | <100 | 104 | 104
TOTAL | 5914 | 5810 | 3510 | 5900 | 6835 | 9782 | 10916 | 48667
Estimated swap transaction volumes, week ending February 15, by product type and tenor (millions of USD), all participant types and currencies.
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 Data Dictionary for tenor bucket descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 145d192e-b3f6-4abc-8069-52f213d489ca
Sheet: Country

Country | Titles | Percentage
France | 42
Germany | 28
Italy | 22
Sweden | 17
Japan | 16
Russia | 16
Argentina | 13
Spain | 12
Norway | 9
Turkey | 9
Quebec | 8
China | 7
Netherlands | 6
Poland | 6
Austria | 5
Chile | 5
Denmark | 5
Cuba | 4
Greece | 4
Iceland | 4
Israel | 4
Mexico | 4
Switzerland | 4
Algeria | 3
Bulgaria | 3
Hungary | 3
Iran, Islamic Republic of | 3
Finland | 2
Iraq | 2
Morocco | 2
Peru | 2
Portugal | 2
Various | 2
Albania | 1
Azerbaijan | 1
Belarus | 1
Brazil | 1
Cameroon | 1
Congo | 1
Costa Rica | 1
Croatia | 1
Czech Republic | 1
Egypt | 1
Estonia | 1
Guatemala | 1
Haiti | 1
India | 1
Ireland | 1
Latvia | 1
Lebanon | 1
Lithuania | 1
Mozambique | 1
Pakistan | 1
Puerto Rico | 1
Romania | 1
South Africa | 1
South Korea | 1
Syrian Arab Republic | 1
Wales | 1
Spreadsheet: 850178d1700565217-completing-two-data-tables-with-two-criteria-data-19-aligw
Sheet: data

 | TABLE 0
Job | Data | Field 1 | Field 2 | Field 3 | Field 4
[NAME] | 2023-02-01 00:00:00 | A | Lamp | 1002 | ABCD
[NAME] | 2023-02-01 00:00:00 | C | Lamp2 | 1005 | AFGH
[NAME] | 2023-05-10 00:00:00 | D | Lamp3 | 1006 | FGHT
[NAME] | 2023-05-12 00:00:00 | S | Lamp10 | 1009 | [NAME]
[NAME] | 2023-06-06 00:00:00 | H | Lamp3 | 1010 | KTYU
[NAME] | 2023-07-07 00:00:00 | Y | Lamp10 | 1010 | BHTF
[NAME] | 2023-08-15 00:00:00 | G | Lamp5 | 1008 | KHTY
[NAME] | 2023-09-16 00:00:00 | D | Lamp6 | 1007 | LUGB
[NAME] | 2023-09-16 00:00:00 | C | Lamp8 | 1006 | INGA
[NAME] | 2023-10-12 00:00:00 | V | Lamp20 | 1005 | [NAME]
[NAME] | 2023-10-15 00:00:00 | N | Lamp0 | 1004 | OPRT
 | Select data: | 2023-07-07 00:00:00
 | TABLE 1 | Field 1 | Field 2 | Field 3 | Field 4
 | [NAME] |  |  |  |  |  | <----  !!! If the date selected in cell 'C15' has for '[NAME]' a single row extracted from the first table above (Table 0), then only that row will be displayed, the other rows remaining empty in Table 1. Idem Table 2. If there are more rows for [NAME] with the same data, only those lines will be displayed, etc., the other lines remaining empty.
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | TABLE 2 | Field 1 | Field 2 | Field 3 | Field 4
 | [NAME] |  | Lamp10 | 1010 | BHTF
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 540751d1506948790-check-count-between-two-cells-check-count-between
Sheet: Sheet1

 | 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 | INTERVAL
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
 | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | OFF | OFF | -
 | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | -
 | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | - | - | - | - | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
 | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | -
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | -
 | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | -
 | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | OFF | OFF | -
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | -
 | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | - | - | - | OFF | OFF | - | - | -
 |  |  |  |  |  |  |  | Note:
 |  |  |  |  |  |  |  | Start from the OFF in each row
 |  |  |  |  |  |  |  | In the First Row, Off is column E3 & F3, So next there are 5 Hyphens so the output should be 5-5-5-5
 |  |  |  |  |  |  |  | [NAME] and should consider only the hyphen repeats between Off
Spreadsheet: 4fb24ab6-35b7-4c8c-8e9b-0aac4ab9ee45
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Wills Point Shootout
 |  |  |  | Dec. 8, 9, 10
 |  |  |  | Varsity Division
 | Round [NAME]
 | White Pool |  |  | Blue Pool
 | Athens |  |  | North Lamar
 | Edgewood |  |  | [NAME]
 | [NAME] |  |  | T.C.A.
 | Royse City |  |  | Wills Point
 | Thursday, Dec. 8
 | 09:00:00 | Edgewood vs. Royse City
 | 10:25:00 | Athens vs. [NAME]
 | 11:50:00 | Wills Point vs. North Lamar
 | 13:15:00 | T.C.A. vs. [NAME]
 | 14:40:00 | [NAME] vs. [NAME]
 | 16:05:00 | Royse City vs. Athens
 | 17:30:00 | North Lamar vs. T.C.A.
 | 18:55:00 | [NAME] vs. Wills Point
 | Friday, Dec. 9
 | 09:00:00 | Royse City vs. [NAME]
 | 10:25:00 | Edgewood vs. Athens
 | 11:50:00 | Wills Point vs. T.C.A.
 | 13:15:00 | North Lamar vs. [NAME]
 | **First team listed will wear white uniforms.**
 | **Bracket play will begin at 3:30 pm on Friday.**
 | [NAME] seeding determined by:
 | 1) Record in pool play.
 | 2) Total points allowed.
 | 3) Total points scored.
 | 4) Coin Flip (if needed).
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: Apr 2001

April 2001 Production Month
Cash In\Out After Bookout | 21 | Majority is due FGT
 | 18 | Minority is due Shippers
le_nm | [NAME] | inv_amt | sum_mmbtu_qty
ALABAMA ELECTRIC COOPERATIVE, INC. | CIO | -15895.72 | -3022
BP ENERGY COMPANY | CIO | -3161.6 | -608
CITRUS TRADING CORPORATION | CIO | -3385.2 | -651
EL PASO MERCHANT ENERGY, L.P. | CIO | -1523.6 | -293
[NAME], L.P. | CIO | -12963.6 | -2770
FLORIDA POWER AND LIGHT COMPANY | CIO | -1194715.6 | -229753
FLORIDA POWER CORPORATION | CIO | -307054.8 | -59049
HIGHLAND ENERGY COMPANY OF TEXAS | CIO | -10316.8 | -2480
INFINITE ENERGY, INC. | CIO | -328867.24 | -63336
ORLANDO COGEN FUEL, INC | CIO |  | -23088
ORLANDO COGEN FUEL, INC | CIO | -76117.6 | -14638
ORLANDO UTILITIES COMMISSION | CIO | -12298 | -2365
PEOPLES GAS SYSTEM, A DIVISION OF TAMPA | CIO | -3360319.04 | -531063
PREMIER SERVICES CORP | CIO | -5.2 | -1
PRIOR INTRASTATE CORPORATION | CIO | -103.14 | -83
REEDY CREEK IMPROVEMENT DISTRICT | CIO | -50291.28 | -10746
RELIANT ENERGY SERVICES, INC. | CIO | -19494.53 | -3213
ST. JOE NATURAL GAS COMPANY | CIO | -1721.2 | -331
TALLAHASSEE, CITY OF | CIO | -166691.2 | -32056
TECO POWER SERVICES CORPORATION | CIO | -122639.4 | -26205
Total Due 18 shippers
ADAMS RESOURCES MARKETING, LTD. | CIO | 657.5 | 125
ALABAMA ELECTRIC COOPERATIVE, INC. | CIO | 15895.72 | 3022
ALABAMA POWER COMPANY | CIO | 6808.02 | 1293
BAPTIST MEDICAL CENTER | CIO | 8736.86 | 1661
CARGILL FERTILIZER,  INC | CIO | 5.26 | 1
CELOTEX CORPORATION | CIO | 7174.64 | 1364
CINERGY MARKETING & TRADING, LLC | CIO | 3745.12 | 712
CLARKE-MOBILE COUNTIES GAS DISTRICT | CIO | 28518.93 | 5391
DYNEGY GAS TRANSPORTATION, INC. | CIO | 165916.18 | 31543
DYNEGY GAS TRANSPORTATION, INC. | CIO | 2012950 | 364000
DYNEGY POWER CORP. | CIO | 10.52 | 2
ENRON NORTH AMERICA CORP. | CIO | 4026 | 765
FLORIDA GAS UTILITY | CIO | 491.83 | 11849
FLORIDA PUBLIC UTILITIES COMPANY | CIO | 24727.26 | 4701
NUI CORPORATION | CIO | 21.04 | 4
ORLANDO COGEN II | CIO | 21.04 | 4
PRIOR INTRASTATE CORPORATION | CIO | 15895.72 | 3022
SOUTH FLORIDA NATURAL GAS, INC. | CIO | 1843.08 | 348
TECO GAS SERVICES, INC. | CIO | 5.26 | 1
TEXACO NATURAL GAS, INC. | CIO | 264750 | 50000
TEXICAN NATURAL GAS COMPANY | CIO | 1689.51 | 292
UNOCAL ENERGY TRADING, INC. | CIO | 1236.1 | 235
Total Due FGT   22 shippers
Spreadsheet: 474359d1470743826-pay-verify-using-vba-reg-attendance
Sheet: CMSE-H-JUNE-2016

 |  |  |  |  | [NAME] FOR THE MONTH OF  JUNE2016
Attendence Report for the Period :
SL NO. | COL - 3 | Emp. Code | Employee Name | Date of Joining | Designation | Department | Dates : LWP / Long Leave/ Date of Resignation & Last Working Day/ Date of Joining | LOPs | No of days Payable | No. of Days in the month | Arrears Days
1 | CMSE | 10421 | SARVESH MUNI | 2009-04-21 00:00:00 | ASSISTANT | ADMIN |  | 0 |  | 31
2 | CMSE | 10422 | SIREESHA B | 10/06/2014 | ASSISTANT | ADMIN |  | 0 |  | 31
3 | CMSE | 10423 | VIJAYALAKSHMI.N | 01/06/2009 | NABH COORDINATOR | ADMIN |  | 0 |  | 31
4 | CMSE | 10424 | KALPANA.B.J | 01/03/2010 | PERSONAL SECRETARY | ADMIN |  | 0 |  | 31
5 | CMSE | 10425 | SHIVASHANKAR.H.C | 2014-11-24 00:00:00 | ASSISTANT | ADMIN |  | 0 |  | 31
6 | CMSE | 10426 | BAKTHAVACHALAM.P | 2015-12-01 00:00:00 | ATTENDER | ADMIN |  | 0 |  | 31
7 | CMSE | 10427 | G ALAMEEN | 2011-06-27 00:00:00 | TECHNICIAN | ANAESTHESIA -CTVS |  | 0 |  | 31
8 | CMSE | 10883 | VIJAY KUMAR S BRIDER | 2012-11-15 00:00:00 | DUTY DOCTORS | COMMUNITY MEDICINE - BRIDER |  | 0 |  | 31
9 | CMSE | 10884 | RAJENDRA REDDY P S | 2013-07-01 00:00:00 | DUTY DOCTORS | COMMUNITY MED-KANAMMAGALA |  | 0 |  | 31
10 | CMSE | 10885 | BHARATH L SETTY | 2014-05-11 00:00:00 | DUTY DOCTORS | COMMUNITY MED-KANAMMAGALA | CL -16/07/2016 | 0 |  | 31
11 | CMSE | 10886 | SUNITHA V. | 2016-07-01 00:00:00 | DIETICIAN | DIETARY | LWD: 01/03/2016
12 | CMSE | 10887 | NANDHINI C | 2016-07-18 00:00:00 | LAB TRAINEE | PHLEBOTOMY | LWD : 08/02/2016
13 | CMSE | 10888 | KAVITHA S | 2015-12-04 00:00:00 | LAB TRAINEE | PHLEBOTOMY | LWD: 10/02/2016
14 | CMSE | 10889 | ASHOK.K | 14/12/2012 | CATH LAB INCHARGE | CARDIOLOGY | LWD: 04/04/2016
15 | CMSE | 10890 | MANAVARTHAL P. | 2014-11-24 00:00:00 | JR. LAB TECHNICIAN - I | BIO CHEMISTRY | LWD: 10/02/2016
16 | CMSE | 10891 | RAMYA KISHOR | 2015-12-01 00:00:00 | YOGATHERAPIST | YOGATHERAPY | LWD : 20/04/2016
17 | CMSE | 10892 | MURALI B | 2011-06-27 00:00:00 | DATAENRTY OPERATOR | PATHOLOGY | LWD : 21/01/2016
18 | CMSE | 10893 | [NAME] | 2012-11-15 00:00:00 | Computer Operator | NEURO SURGERY | LWD: 10/11/2015
19 | CMSE | 10894 | [NAME] | 2013-07-01 00:00:00 | MEDICAL SOCIAL WORKER | NEPHROLOGY | Leave with out intimation on: [NAME]
20 | CMSE | 10895 | RATHNA S | 2014-05-11 00:00:00 | LAB TRAINEE | MICROBIOLOGY | LWD : 02/02/2016
21 | CMSE | 10896 | MRS.YUVARANI | 2016-07-01 00:00:00 | COMPUTER OPERATOR | MEDICAL RECORDS | ML -21/12/2015 TO 20/03/2016   LWD: 21/03/2016
22 | CMSE | 10897 | REKHA S | 2016-07-18 00:00:00 | TECHNICIAN | LAB-PATHOLOGY | LWD: 05/04/2016
23 | CMSE | 10898 | [NAME] | 2016-02-29 00:00:00 | [NAME] | Laboartory | LWD: 02/04/2016
24 | CMSE | 10899 | MADHAVI J | [NAME] | SOCIAL WORKER | CARDIOTHORASIC & VASCULAR SURG | HOLD SALARY
Spreadsheet: 752247d1634663216-calculate-cost-of-pto-to-reach-a-standard-time-mock-pto-cost-calculation-start
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 44471
Scenario |  | Start | Bridged Start Date | Term Date | Time Profile | Date will be standard |  | Status | Rate | Standard Hours | Weekly Rate | Review | Plan | Accounting Period | Total Years at Hire | Stand/Policy Hour | Plan Hour | Difference | Plan Hours Tenure | Total Years to level | Cost for Plan Per week | Hire Week | Remaining Yr % | Remain Year Time (weeks) | Remaining Weeks to pay | RY Costs | Ann'l Cost | Multiplier | Total Cost
Regular Hire | ID1 | 2021-10-10 00:00:00 | 2021-10-10 00:00:00 |  | NonExCO1 - NonExempt FT wCashOut - 1 wk | 2021-10-10 00:00:00 |  |  | 10 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New Hire w Neg add'l week | ID2 | 2021-10-10 00:00:00 | 2019-10-10 00:00:00 |  | [NAME] wCashOut - 2 wks |  |  |  | 10 | 40
Tenured | ID2 | 2021-10-10 00:00:00 | 2018-10-10 00:00:00 |  | NonExCO3 - NonExempt FT wCashOut - 3 wks |  |  |  | 10 | 40
Random Scenario | ID3 | 2021-10-10 00:00:00 | 2017-10-10 00:00:00 |  | NonExCO4 - NonExempt FT wCashOut - 4 wks |  |  |  | 10 | 40
 |  | 2000-01-01 00:00:00
 |  | 2003-12-31 00:00:00
Spreadsheet: eric_saibi__9961__110801
Sheet: Millstone 03 

Owner Name |  | Dominion Resourcces
Station Name |  | Millstone Nuclear Power Station
Unit Name |  | Millstone 03
NERC Region |  | NPCC
State |  | CT
Fuel Type |  | Nuclear
Capacity |  | 1,253 MW
Start Date
End Date
Comments |  | Unit is derated to 20% and will be doing repairs at this level they  are not planning on  the unit coming off-line as of now. They hope to start ramping up by Monday.
SIC |  | 4911
Plant ID |  | 1512472
Unit ID |  | 1008267
Outage ID
Spreadsheet: 762744d1641794772-plus-minus-season-long-total-swindy-totals
Sheet: Sheet1

 | MUST USE CODES |  |  | TOURNAMENT TOTALS |  |  |  |  |  | GOLFER LEADERBOARD |  |  | SWINDLER LEADERBOARD
 | SWINDLERS | GOLFERS |  | EVENT/DAY | SWINDLER | GOLFER | PLUS/MINUS | EVENT |  | GOLFER | SEASON TOTAL |  | SWINDLER | SEASON TOTAL |  | GOLFER | SEASON TOTAL |  | SWINDLER | SEASON TOTAL |  |  | Tourney of Champs / R2 | Tourney of Champs / Rr
 | Bad Boys | JT |  | Tourney of Champs / R1 | Texan | JT | 15 |  |  |  | 0 |  |  | 225 |  | JT |  |  | Texan
 | Bear Jew | Rahm |  |  | Ricky | Rahm | 70 |  |  | Rahm | 0 |  | [NAME] | 220 |  | Rahm |  |  | Ricky
 | Big Cat | X |  |  | Rhino | X | 45 |  |  | X | 0 |  | Big Cat | 170 |  | X |  |  | Rhino
 | [NAME] | [NAME] |  |  | Shetty | [NAME] | 60 |  |  | [NAME] | 0 |  | Ricky | 135 |  | [NAME] |  |  | Shetty
 | Buggy | Hovland |  |  | [NAME] | Hovland | 55 |  |  | Hovland | 0 |  | Pilot Jon | 120 |  | Hovland |  |  | [NAME]
 | Chief | Spieth |  |  | [NAME] | Spieth | 35 |  |  | Spieth | 0 |  | Rhino | 40 |  | Spieth |  |  | [NAME]
 | Dingo | Cantlay |  |  | Big Cat | Cantlay | 75 |  |  | Cantlay | 0 |  | [NAME] | 10 |  | Cantlay |  |  | Big Cat
 | Doc |  |  | Tourney of Champs / R2 |  |  |  |  |  |  |  |  | Bad Boys | 0 |  |  |  |  | Bad Boys
 | Fluff |  |  |  | Rhino | JT | 55 |  |  |  |  |  | Fluff | 0 |  |  |  |  | Fluff
 | JVC |  |  |  | Rhino | Rahm | 50 |  |  |  |  |  | JVC | 0 |  |  |  |  | JVC
 | Mitchies |  |  |  | Shetty | X | 15 |  |  |  |  |  | Doc | 0 |  |  |  |  | Doc
 | Pilot Jon |  |  |  | [NAME] | [NAME] | 70 |  |  |  |  |  | Buggy | 0 |  |  |  |  | Buggy
 | Redneck |  |  |  | Mitchies | Hovland | 40 |  |  |  |  |  | Bear Jew | 0 |  |  |  |  | Bear Jew
 | Rhino |  |  |  | Pilot Jon | Spieth | 60 |  |  |  |  |  | Chief | 0 |  |  |  |  | Chief
 | Ricky |  |  |  | Redneck | Cantlay | 10 |  |  |  |  |  | Dingo | 0 |  |  |  |  | Pilot Jon
 | Shetty |  |  | Tourney of Champs / Rr |  |  |  |  |  |  |  |  | Mitchies | -20 |  |  |  |  | Redneck
 | Snowden |  |  |  | Snowden | JT | 75 |  |  |  |  |  | [NAME] | -50 |  |  |  |  | Dingo
 | Texan |  |  |  | Texan | Rahm | 35 |  |  |  |  |  | Shetty | -130 |  |  |  |  | [NAME]
 | [NAME] |  |  |  | [NAME] | X | 60 |  |  |  |  |  | Redneck | -230 |  |  |  |  | Snowden
 | [NAME] |  |  |  | [NAME] | [NAME] | 40 |  |  |  |  |  | Texan | -305 |  |  |  |  | Mitchies
 |  |  |  |  | [NAME] | Hovland | 20
 |  |  |  |  | [NAME] | Spieth | 30
 |  |  |  |  | [NAME] | Cantlay | 40
Spreadsheet: 845393d1696929619-formula-for-price-comparison-example-xls-costing-comparison
Sheet: Sheet1

Shop | Item | Size (Milliletres) | Item cost | Quantity | Cost per Milliletre
AMAZON | [NAME] | 460 | 38.2 | 6
EBAY | [NAME] | 640 | 25.5 | 4
 |  |  |  |  | Above and Below: I am looking for a formula that uses the data in the 3 preceding cells that calculates the cost per Ml or [NAME].
Shop | Item | [NAME] ([NAME]) | Item cost | Quantity | Cost per Grams
B&M | [NAME] | 200 | 1.5 | 2
Tesco | [NAME] | 150 | 1.25 | 5
Essentially I want the Total to show the cost per Ml or per [NAME] so I can see which item is best value!
 |  |  |  |  | Required outcome (Note totals are examples as I don't have the mathematical skills to work this out! Hence needing a formula):
Shop | Item | Size (Milliletres) | Item cost | Quantity | Cost per Milliletre
AMAZON | [NAME] | 460 | 38.2 | 6 | 1.24
EBAY | [NAME] | 640 | 25.5 | 4 | 1.56
Spreadsheet: 852275d1702365969-help-in-calculation-in-excel-calculation
Sheet: Sheet1

Month | Sell | Received
Jan | 100
Feb | 150
Feb | 50
Feb | 10
Mar | 200
Apr | 300
 |  | 700
 | Total Amount | Total Received
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: Oct 2000

October 2000 Production Month
Cash In\Out after [NAME] | 19 | Minority is Due Shippers
 | 26 | Majority is Due FGT
le_nm | [NAME] | inv_amt | sum_mmbtu_qty
ADAMS RESOURCES MARKETING, LTD. | CIO | -339.02 | -67
ANHEUSER BUSCH COMPANIES, INC | CIO | -5894.9 | -1165
ASHLAND CHEMICAL COMPANY | CIO | -146.74 | -29
CINERGY MARKETING & TRADING, LLC | CIO | -1907.62 | -377
CITRUS TRADING CORPORATION | CIO | -11567.16 | -2286
COASTAL MERCHANT ENERGY, L.P. | CIO | -1791.24 | -354
DUKE ENERGY TRADING AND MARKETING,L.L.C. | CIO | -116.38 | -23
DYNEGY GAS TRANSPORTATION, INC. | CIO | -5854.42 | -1157
[NAME], L.P. | CIO | -404.8 | -80
FLORIDA GAS UTILITY | CIO | -14726.82 | -2390
FLORIDA POWER AND LIGHT COMPANY | CIO | -617411.08 | -122018
HOUSTON PIPE LINE COMPANY | CIO | -23529 | -4650
INFINITE ENERGY, INC. | CIO | -355060.2 | -70170
NOBLE GAS MARKETING, INC. | CIO | -40596.38 | -8023
NUI CORPORATION | CIO | -15615.16 | -3086
ORLANDO COGEN FUEL, INC | CIO | -66822.36 | -13206
ORLANDO UTILITIES COMMISSION | CIO | -318.78 | -63
TALLAHASSEE, CITY OF | CIO | -547608.38 | -108223
UNOCAL ENERGY TRADING, INC. | CIO | -4710.86 | -931
Total Due 19 Shippers
ALABAMA POWER COMPANY | CIO | 11635.9 | 2266
ALUMINUM COMPANY OF AMERICA | CIO | 67317.89 | 12029
BAPTIST MEDICAL CENTER | CIO | 4827.33 | 941
BP ENERGY COMPANY | CIO | 1241.46 | 242
CARGILL FERTILIZER,  INC | CIO | 15.39 | 3
CELOTEX CORPORATION | CIO | 3549.96 | 692
CHESAPEAKE UTILITIES CORPORATION | CIO | 46472.67 | 9059
CLARKE-MOBILE COUNTIES GAS DISTRICT | CIO | 28613.74 | 5551
CORAL ENERGY RESOURCES, L.P. | CIO | 35.91 | 7
CUTRALE CITRUS JUICES USA, INC. | CIO | 10.26 | 2
EL PASO MERCHANT ENERGY, L.P. | CIO | 2416.23 | 471
ENRON NORTH AMERICA CORP. | CIO | 97546.7 | 18964
FLORIDA POWER CORPORATION | CIO | 149819.69 | 25877
FLORIDA PUBLIC UTILITIES COMPANY | CIO | 104708.43 | 20411
HIGHLAND ENERGY COMPANY OF TEXAS | CIO | 18.47 | 3
NATIONAL GYPSUM COMPANY | CIO | 1007.95 | 170
ONYX GAS MARKETING COMPANY, L.C. | CIO | 59246.37 | 11549
ORLANDO COGEN II | CIO | 20.52 | 4
PEOPLES GAS SYSTEM, A DIVISION OF TAMPA | CIO | 6053.4 | 1180
PRIOR INTRASTATE CORPORATION | CIO | 30395.25 | 5925
SOUTH FLORIDA NATURAL GAS, INC. | CIO | 906.2 | 167
SOUTHEAST ALABAMA GAS DISTRICT | CIO | 15431.04 | 3008
SOUTHERN COMPANY SERVICES | CIO | 1191.8 | 231
TECO GAS SERVICES, INC. | CIO | 25.65 | 5
TEXACO NATURAL GAS, INC. | CIO | 5843.07 | 1139
WESTERN GAS RESOURCES INC | CIO | 25.65 | 5
Total Due FGT   26 shippers
Spreadsheet: 725394d1616665988-average-ifs-with-or-average-ifs
Sheet: Sheet1

Department | Status | [NAME] time
A | In Progress | 2
A | In Approval | 30
C | In Progress | 18
C | In Progress | 6
A | In Progress | 20
A | In Review | 10
Calculations
Department | Average turnaround time
A
B
C
Spreadsheet: jim_schwieger__14303__Bronco Playoff Schedule
Sheet: Sheet1

Bronco Maroon [NAME]
#1 Braves-Labay 8
WLY#5 @ 8:00pm | #1 Braves-Labay
#8 Marlins-Bleyl 6 |  | Winner of Round 2
 | Friday 5/18
 | BC#2 @ 8:00pm
#5 Cardinals-Hamilton
5/16 Wednesday | Winner of 4 vs. 5
BC#2 @ 8:00pm
#4 A's-Hamilton |  | Monday 5/21
 |  | WLY#5 @ 7:00pm
Game #1217
#3 Reds-Cook
5/16 Wednesday | Winner of 3 vs.6
WLY#5 @ 6:00pm
#6 Dodgers-Truitt
 | Friday 5/18
 | BC#2 @ 6:00pm | Winner of Round 2
#7 Astros-Campbell
5/16 Wednesday | #2 Angels-Arnold
BC#2 @ 6:00pm
#2 Angels-Arnold
Spreadsheet: 737531d1624457280-top-10-but-only-newest-data-testbook
Sheet: Data

Jalika | Elf | 1750 | 2020-12-21 00:00:00
[NAME] | [NAME] | 1380 | 2021-02-02 00:00:00
[NAME] | [NAME] | 1351 | 2021-02-10 00:00:00
[NAME] | [NAME] | 1350 | 2021-02-02 00:00:00
Maltris | Elf | 1277 | 2021-03-12 00:00:00
Xelten | Elf | 1004 | 2021-02-02 00:00:00
[NAME] | Human | 1004 | 2021-02-10 00:00:00
Antharos | Gor'Tog | 958 | 2021-02-02 00:00:00
Brahmer | Elf | 925 | 2020-10-21 00:00:00
[NAME] | Elf | 50 | 2020-05-05 00:00:00
[NAME] | [NAME] | 1510 | 2021-06-23 00:00:00
Spreadsheet: 605622d1547185678-data-required-in-a-easy-way-in-a-complex-file-18-19-costing1
Sheet: FORMULA

IMP | Item |  | Qty |  |  | IMP-No | Item
K-9999 | MD-RINT35030 |  | 50
 | MD-RINT35015 |  | 10
 | MD-RINT35040 |  | 100
 | ----
a-8888 | SD-YOUP |  | 50
 | RD-YOUP |  | 100
 | sheeth introducer |  | 10
 | -----
K-8989 | MD-BBB841 |  | 50
 | MD-M111207A |  | 100
 | MD-RCL84100 |  | 500
 | yunkersection |  | 50
=IF(COUNTIF(A$1:A1,LOOKUP("z",'Main-DATA'!B$1:INDEX('Main-DATA'!B:B,AGGREGATE(15,6,ROW('Main-DATA'!B$2:B$9999)/MMULT(--(LEFT('Main-DATA'!$C$2:$C$9999)={"m","s","a"}),{1;1;1})/ISNUMBER('Main-DATA'!$E$2:$E$9999),ROWS(A$2:A2))))),"",LOOKUP("z",'Main-DATA'!B$1:INDEX('Main-DATA'!B:B,AGGREGATE(15,6,ROW('Main-DATA'!B$2:B$9999)/MMULT(--(LEFT('Main-DATA'!$C$2:$C$9999)={"m","s","a"}),{1;1;1})/ISNUMBER('Main-DATA'!$E$2:$E$9999),ROWS(A$2:A2)))))
Spreadsheet: 100719d1298994062-excel-2007-vlookup-pic-advfilterbutton
Sheet: Sheet1

Data |  |  | Criteria |  |  | Adv Filter output
Inv# | Value |  | Inv# | Value |  | Inv# | Value
75 | 45 |  | 15 |  |  | 15 | 15
85 | 74 |  |  |  |  | 15 | 98
85 | 63 |  |  |  |  | 15 | 49
14 | 58 |  | Change the number |  |  | 15 | 49
15 | 15 |  | in Cell D3 above and
21 | 22 |  | then press the button
85 | 41
45 | 18
85 | 98
85 | 100
75 | 35 |  | Look at the Macro
14 | 68 |  | to see what it does.
15 | 98
14 | 78
15 | 49
21 | 35
21 | 78
45 | 81
14 | 83
15 | 49
85 | 55
75 | 56
45 | 55
45 | 75
Spreadsheet: 598775d1542715450-sum-formula-for-rolling-12-month-data-total-excel-data-sample
Sheet: Data Sample

 |  | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00
 | Monthly Total Sales: | 154408.33 | 175290.59 | 234679.01 | 238567.02 | 287280.45 | 222676.76 | 292238.45 | 304157.55 | 316209.23 | 381540.1 | 488927.97 | 352672.75 | 339941.25 | 365955.61 | 350964.38 | 386802.46 | £            -
 |  | 2018-10-01 00:00:00
 | Rolling 12 Month Spend:
 | Monthly Total Sales:
Spreadsheet: 60355d1260908187-nested-if-statements-inventory-segmentation-1
Sheet: Table

NO table |  | YES Table
AWARD RIBBON | 273 | BOWL | 273
BOWL | 581 | CENTERPIECE | 273
CUP | 472 | CUP | 273
DECORATION | 273 | NAPKINS | 273
FAVORS | 273
JEWELRY | 273
NAPKINS | 205
TABLE COVER | 273