tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 843193d1695122507-formula-to-return-list-base-on-count-extra-row-in-formula
Sheet: Sheet1

 | Staff | Month |  |  | Staff | Month
 | JR | [NAME] |  |  |  |  |  |  | [NAME]
 | Jojo | Feb'23 |  |  | Jojo | [NAME] |  | Jojo | [NAME]
 | [NAME] | Mar'23 |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 | [NAME] |  |  |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 | Holland |  |  |  | Holland | [NAME] |  | Holland | [NAME]
 | Beckham |  |  |  | Beckham | [NAME] |  | Beckham | [NAME]
 |  |  |  |  | JR | Feb'23 |  | JR | Feb'23
 |  |  |  |  | Jojo | Feb'23 |  | Jojo | Feb'23
 |  |  |  |  | [NAME] | Feb'23 |  | [NAME] | Feb'23
 |  |  |  |  | [NAME] | Feb'23 |  | [NAME] | Feb'23
 |  |  |  |  | Holland | Feb'23 |  | Holland | Feb'23
 |  |  |  |  | Beckham | Feb'23 |  | Beckham | Feb'23
 |  |  |  |  | JR | Mar'23 |  | JR | Mar'23
 |  |  |  |  | Jojo | Mar'23 |  | Jojo | Mar'23
 |  |  |  |  | [NAME] | Mar'23 |  | [NAME] | Mar'23
 |  |  |  |  | [NAME] | Mar'23 |  | [NAME] | Mar'23
 |  |  |  |  | Holland | Mar'23 |  | Holland | Mar'23
 |  |  |  |  | Beckham | Mar'23 |  | Beckham | Mar'23
 |  |  |  |  |  |  | <---- how to get rid of this in my formula
Spreadsheet: 32339d1228441007-how-to-choose-the-highest-5-numbers-from-4-different-worksheets-4accendo
Sheet: Marvel #1

 | Name | Height (CM) | Intelligence | Strength | Speed | Agility | Fighting Skills
 | Storm | 178 | 4 | 27 | 12 | 14 | 69
 | Professor X | 180 | 7 | 24 | 1 | 12 | 64
 | Hawkeye | 188 | 3 | 26 | 4 | 16 | 80
 | Mysterio | 178 | 3 | 23 | 3 | 14 | 70
 | Invisible Woman | 165 | 3 | 23 | 2 | 12 | 70
 | [NAME] | 183 | 3 | 27 | 4 | 12 | 86
 | Mr Fantastic | 183 | 9 | 23 | 2 | 22 | 65
 | The Thing | 180 | 3 | 47 | 8 | 12 | 85
 | Ghost Rider | 181 | 3 | 37 | 8 | 15 | 66
 | Dr Octopus | 173 | 7 | 23 | 2 | 12 | 65
 | Elektra | 173 | 4 | 15 | 6 | 16 | 80
 | Black Widow | 168 | 4 | 26 | 4 | 14 | 81
 | Iron Man | 183 | 6 | 48 | 2 | 12 | 85
 | Thor | 195 | 4 | 49 | 9 | 19 | 85
 | Apocalypse | n/a | 8 | 50 | 16 | 22 | 80
 | Dr Strange | 184 | 5 | 35 | 4 | 14 | 85
 | Black Panther | 180 | 7 | 29 | 7 | 17 | 79
 | Dr Doom | 186 | 8 | 48 | 4 | 13 | 70
 | Captain America | 186 | 4 | 29 | 6 | 16 | 86
 | [NAME] | 205 | 3 | 48 | 2 | 10 | 63
 | Silver Surfer | 190 | 4 | 46 | 13 | 18 | 72
 | Magneto | 185 | 8 | 46 | 2 | 12 | 81
 | Kingpin | 198 | 7 | 30 | 4 | 13 | 75
 | Spider-man | 175 | 7 | 36 | 11 | 21 | 66
 | The Beast | 177 | 5 | 35 | 10 | 20 | 72
 | Blade | 185 | 3 | 29 | 5 | 14 | 85
 | Venom | 188 | 3 | 38 | 10 | 20 | 64
 | Green Goblin | 178 | 6 | 35 | 10 | 18 | 55
Spreadsheet: 794018d1661853592-index-and-match-with-multiple-with-rows-sample-workbook
Sheet: Calibration Certificate Page 1 

Certificate of Calibration | Issued by: Gas Analysis Services Ltd. Unit 1C N11, South Point Business Park, [NAME], Rathnew Co. [NAME], Ireland.                                  [NAME]: +353-(0)1-2761984, [NAME]: [EMAIL]. www.gasanalysis.eu
Certificate No. |  |  |  |  | Page 1 of 1
Customer |  |  |  | Service Report Number
Site Address |  |  |  | Calibration Certificate Number
User Contact Details |  |  |  | Test Engineer
Test Location |  |  |  | Analyser Serial Number
Instrument Make and Model |  |  |  | Date of Calibration
Average Ambient Conditions during calibration |  | Temp in Deg C |  | Pressure in mBar
 |  | % RH |  | Date & Time
Measurement Performance | Gas | T90 in Seconds | [NAME] | Repeatability | Zero Drift (Period) | Span Drift(Period)
Cell 1 |  | N/A | N/A | N/A | N/A | N/A
Cell 2 |  | N/A | N/A | N/A | N/A | N/A
Cell 3 |  | N/A | N/A | N/A | N/A | N/A
Cell 4 |  | N/A | N/A | N/A | N/A | N/A
Measurement Calibration | [NAME]. | [NAME]. | [NAME] | Value before Adj. | Deviation from [NAME]. | Value after Adj.
Cell 1 Low Cal
Cell 1 High Cal
Cell 2 Low Cal
Cell 2 High Cal
Cell 3 Low Cal
Cell 3 High Cal
Cell 4 Low Cal
Cell 4 High Cal
Calibration Comment
Additions to, deviations, or exclusions from the method LP021
1. Method of Measurement
All Calibrations are performed in accordance with the standard operating procedure LP-021 documented in Gas analysis Services Quality management system. The methods involve analysing certified calibration gas standards (Traceable to National and/or International Standards)on Gas Analysis Instruments under test and reporting the results.
2.  Measurement Performance Values
Where Information hasn’t been provided by or documented by the manufacturer, it is recorded as N/A.(Not Applicable)” Performances stated as a percentage of the FSR (Full scale range) have been determined based on the upper range of the  high  calibration gas concentration.
3.  Reproduction of certificates
Certificates should not be copied except in full and with the written permission of Gas Analysis Services and they only refer to the instrument identified on the certificate.
4. Next Calibration date
The next calibration date is not stated on the calibration cert as it is a customer specific risk assessment that should determine the date. The interval should be a function of the process characteristics and the measurement accuracy and drift specifications. The next calibration date stated on GAS Service Report Template LF-037 is recorded as a recommendation as agreed by the customer
 | Complete (Yes/No) | Approved Signatory | Position | Signature |  | Date
Calibration Status
Calibration Certificate Template LF-038 Issue No. 2
Spreadsheet: 40325d1238619820-embedding-if-statements-into-if-statement-agreement-example
Sheet: Sheet2

 |  |  |  |  |  |  |  | SALES AGREEMENT #
 |  |  |  |  |  |  |  | DATE: |  | BUYER PO#:
 |  |  |  |  |  |  |  | PAGE 1 |  | REP:
 | [NAME]: |  |  |  |  |  |  | [NAME] Name:
 | [NAME]: |  |  |  |  |  |  | [NAME]:
 | Address1: |  |  |  |  |  |  | Address1:
 | Address2: |  |  |  |  |  |  | Address2:
 | City: |  |  |  |  |  |  | City:
 | State: | NC | [NAME]: |  |  |  |  | State: |  | [NAME]:
 | Phone Number: |  |  |  |  |  |  | Phone Number:
 | [NAME]: |  |  |  |  |  |  | [NAME]:
1. | SALE: Seller agrees to sell and BUYER agrees to purchase from SELLER the machines and features listed below (referred to as "Equipment")
 | in accordance with the terms and conditions specified herein.
Line # |  | Qty. | Part # |  | Serial # |  | Description |  |  | Unit Price | Sale Price
0001 |  | 10 |  |  |  |  |  |  |  | 15 | 150
0002 |  | 175 |  |  |  |  |  |  |  | 15 | 2625
0003 |  | 10 |  |  |  |  |  |  |  | 15 | 150
0004 |  | 200 |  |  |  |  |  |  |  | 15 | 3000
0005 |  | 10 |  |  |  |  |  |  |  | 15 | 150
0006 |  | 50 |  |  |  |  |  |  |  | 15 | 750
0007 |  | 10 |  |  |  |  |  |  |  | 15 | 150
0008 |  | 15 |  |  |  |  |  |  |  | 15 | 225
0009 |  | 10 |  |  |  |  |  |  |  | 15 | 150
0010 |  | 35 |  |  |  |  |  |  |  | 15 | 525
0011 |  | 10 |  |  |  |  |  |  |  | 15 | 150
0012 |  | 90 |  |  |  |  |  |  |  | 15 | 1350
0013 |  | 10 |  |  |  |  |  |  |  | 15 | 150
0014 |  | 150 |  |  |  |  |  |  |  | 15 | 2250
0015 |  | 10 |  |  |  |  |  |  |  | 15 | 150
 |  |  |  |  |  |  |  |  |  | Total Sales | 11925
 |  |  |  |  |  |  |  |  | Freight |  | 150
Tax Exempt? (Y/N) |  | Y |  | Taxable Sales |  | 11925 |  |  | Tax | 0.0675 | 804.9375
 |  |  |  |  |  |  |  |  | Total |  | 12879.9375
2. | SHIP TO LOCATION: (if different from BUYER's address above):
3. | SALES PRICE AND PAYMENT: The sales price of the equipment is          $ |  |  |  |  |  |  | , such amount BUYER agrees to pay as follows:
A) |  | in advance upon execution of this agreement; and
B) | the balance of   $ |  |  | due |  | with a prorated late payment charge of |  |  |  | % per month
 | on any unpaid balance. SELLER shall have the right to require BUYER to execute a promissory note evidencing any unpaid balance
 | of the sale price.
4. | ACCEPTANCE: If the agreement is not executed by [NAME] and returned to SELLER on or before |  |  |  |  |  |  |  |  | , the agreement is voidable
 | at the option of the SELLER.
 | BUYER: |  |  |  |  |  |  | SELLER:
 | Name: |  |  |  |  |  |  | Name:
 | Title: |  |  |  |  |  |  | Title:
 | Signature: |  |  |  | Date: |  |  | Signature: |  | Date:
Spreadsheet: 271913d1382105991-sumifs-on-multiple-seelction-calculating-multiple-ranges_draggan-181013
Sheet: Sheet1

 |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | --> change this to format date |  |  |  |  | Month | May
5010 |  | -156157 | -156157 | -156156 | -159651 | -156030 | -156029 | -156030 | -156030 | -156029
5011 |  | 7460 | 7460 | 7460 | 7460 | 7460 | 7460 | 7460 | 7460 | 7460 |  |  |  |  |  |  |  |  | Quarter
5020 |  | -72919.85 | -68826.16999999998 | -67866.19 | -76437.6 | -70519.59000000003 | -68845.59999999998 | -63556.54999999999 | -63915.26000000007 | -65122.12 |  |  |  |  |  | Jan | Q_1
5030 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | -1950 | 0 |  |  |  |  |  | Feb | Q_1
5040 |  | -47236 | -1551 | -1552.099999999999 | -1668 | -1668 | -4429.43 | -1682 | -3632 | -3180.850000000006 |  |  |  |  |  | Mar | Q_1
5060 |  | -18210.5 | -18828.75 | -18828.75 | -18828.75 | -22353.5 | -18828.75 | -18828.75 | -18828.75 | -18828.75 |  |  |  |  |  | Apr | Q_2
5063 |  | -528.01 | -548.76 | -484 | -1136.75 | -536.75 | -2054.42 | -844 | -250.5 | -802.5 |  |  |  |  |  | May | Q_2
5090 |  | -333 | -333 | -1893.78 | -3926.54 | -327.5 | 0 | -979.9400000000005 | 0 | 0 |  |  |  |  |  | Jun | Q_2 | --> only use column Q
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul | Q_3
5410 |  | -5887 | -25465.15 | -5868.900000000001 | 0 | -999.1999999999971 | -2135.25 | -3660 | -74008.66 | 48488.73000000001 |  |  |  |  |  | Aug | Q_3
5419 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | Sep | Q_3
5440 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | Oct | Q_4
5460 |  | -4441.15 | -6003.460000000001 | -17203.79 | -2473.099999999999 | -1402 | -11598.4 | -1524.199999999997 | -10491.26 | -9191.199999999997 |  |  |  |  |  | Nov | Q_4
5480 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | Dec | Q_4
5611 |  | -535.49 | -965.1299999999999 | 0 | -527.8900000000001 | -489.5800000000002 | -805.7599999999998 | -1427.86 | 0 | -518.3999999999996
5612 |  | -2479 | -2479 | -2479 | -3161 | -1783 | 507 | -2654 | -1589 | -1589 |  |  |  |  |  |  |  | Month | Quarter |  | Acc from | Acc to
5613 |  |  | 0 | -2831 | 0 | 0 | -2057 | -1271 | 0 | 0 |  |  |  |  |  |  | Local costs |  |  |  | 5000 | 5099
5615 |  | -36890.99 | -37031.68 | -36705.25 | -36673.98 | -31669.98000000001 | -21793.91 | -26996.37 | -26952.94 | -27012.76999999999 |  |  |  |  |  |  | Energy costs |  |  |  | 5400 | 5499
5616 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | Title 3 |  |  |  | 5600 | 5699
5619 |  |  | -14859.2 | 0 | -2240 | -1716.75 | 0 | -5360.799999999999 | 0 | 0 |  |  |  |  |  |  |  | formula "Month" change
5620 |  | -545 | -545 | -545 | -545 | -4997 | -545 | -545 | -545 | -545
5640 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5699 |  | -1193.2 | -1683.44 | -1763.6 | -13434.67 | -1486.400000000001 | -278.3999999999978 | -1224.400000000001 | -1060.799999999999 | -600
Spreadsheet: 84f18e5f-f8b6-4601-a9a9-5291dd3474bf
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
FHEXA | Test | FHEXA | Hexagonal Phospholipid Neutralization | Hexagonal Phospholipid Neutral | Clot | Light blue-top (citrate) tube: LgtBlu |  |  | 1 | mL | Draw blood in a light blue-top (Sodium citrate) tube(s). Spin down and send 1 mL citrated plasma frozen in a plastic vial.  Note:  Separate specimens must be submitted when multiple tests               are ordered. | 0.5 mL | Specimens other than	Plasma Anticoagulants other than	Sodium citrate Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | <8  sec   This is a qualitative assay and is therefore reported as positive for lupus anticoagulant or negative. The quantitative value is provided as an aid in diagnosis.    Test Performed by: [NAME] Upland Dr.                               Suite 100                               Englewood, CO 80112 | Monday through Thursday, Saturday | 1 - 3 days | 2 - 10 days | 1 | 85598 |  |  |  |  | Esoterix Coagulation
FHEXA | [NAME] | NACIT | [NAME] |  |  |  | Frozen
FHEXA | Result | Z0210 | Hexagonal Phospholipid Neutral | Hexagonal Phospholipid Neutral | Numeric |  |  |  |  | sec |  |  |  |  |  |  |  |  |  | 3282-1
Spreadsheet: tracy_geaccone__40281__EMNNG01CE
Sheet: RegAmort

PRINT: PAGE1
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Gas Research Institute (GRI) Calculation
2001 GRI Rate   (INPUT)
North Transport Commodity Volume   (INPUT VOLUME) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Full Margin % |  | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828 | 0.828
Full Margin Volume - North
South Transport Commodity Volume   (INPUT VOLUME) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0
Full Margin Volume - South
Commodity GRI Expense - North
- South
Total Transport Commodity GRI Expense
Total Transport Demand GRI Expense (INPUT $ AMOUNT) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total GRI Expense
REGULATORY AMORTIZATION EXPENSE
Regulatory Commission Expense | Link D.T. | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60
ACA Expense Amortization | Link D.T. | 243 | 243 |  |  |  |  |  |  |  | 250 | 250 | 250
GSR / GSR R.A. / Rev. Auction 1 (Tracked) | Linked
Order 528 75% Expense | Linked
GRI - Transport Commodity (9302-701) |  | 655 | 539 | 434 | 430 | 143 | 239 |  | 287 | 309 | 372
- Transport Demand |  | 78 | 99 | 92 | 52 | 53 | 54 |  | 143 | 145 | 147 | 235 | 234
- Discount Adjustment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- GRI Savings Adjustment |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
FAS 106 Amortization | Link D.T. | 86 | 85 | 86 | 86 | 86 | 85 | 86 | 85 | 86 | 85 | 86 | 86
2223 Dodge Street Buyout Amortization | Link D.T. | 31 | 31 | 32 | 31 | 31 | 32 | 31 | 31 | 32 | 31 | 32 | 32
Severance & Relocation Amortization | Link D.T. | 127 | 126 | 127 | 126 | 127 | 126 | 127 | 126 | 127 | 126 | 127 | 127
Uncollectible Accounts Amortization | Link D.T. | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 27 | 28 | 28 | 28 | 28
Fuel / UAF Amortization | Link D.T. | 218 | 218 | 218 | 217 | 218 | 218 | 218 | 217 | 218 | 218 | 219 | 219
Equivalent Unit Risk Amortization | Link D.T. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GSR Expense - Demand Tracker | Linked
- Commodity Tracker | Linked
GSR R.A. Expense Tracker | Linked
Order 528 Expense Tracker | Linked
IMP Amortization | Link D.T. | -143 | -143 | -144 | -143 | -143 | -144 | -143 | -144 | -143 | -144 | 349 | 350
GSR R.A. Writeoff (1/01), [NAME] (4/01) |  | 103 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
South Georgia (FAS 96) Adjustment | Link D.T. | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 3
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL REGULATORY AMORTIZATION
Spreadsheet: 292360d1390574135-lookup-based-on-the-next-consecutive-value-book5
Sheet: Sheet1

 |  |  |  |  | Null Value
AAA |  |  |  | AAA | 4
A1 | 1 |  |  | BBB | 8
A2 | 2
A3 | 3
Null | 4
BBB
B1 | 5
B2 | 6
B3 | 7
Null | 8
Spreadsheet: larry_campbell__20969__Kingman Calcs
Sheet: 1999 EIQ

[NAME]
KINGMAN COMPRESSOR STATION #1
1999 ARIZONA EMISSIONS
NATURAL GAS FIRED PIPELINE COMPRESSOR ENGINE ANNUAL EMISSIONS BASED ON TEST DATA
POINT 101: STACKS 001,002,003
STACK | TOTAL | RATED | EMISSION FACTORS (lb/hp-hr) and (lb/hr) |  |  |  |  | ANNUAL EMISSIONS (TONS/YR) |  |  |  |  | Fuel
I.D. | ANNUAL | HORSE | (3) |  | (3) | (2) | (1) |  |  |  |  |  | Usage | % Run
# | HOURS | POWER | SO2 | NOX | CO | nm-VOC | PM10 | SO2 | NOX | CO | nm-VOC | PM10 | ([NAME]) | Time
001 | 2426.1666 | 4000 |  |  |  |  | 0.0095 |  |  |  |  |  | 67.928
002 | 2241.5 | 4000 |  |  |  |  | 0.0095 |  |  |  |  |  | 62.748
003 | 2723.4666 | 4000 |  |  |  |  | 0.0095 |  |  |  |  |  | 76.244
TOTAL
NOTES:
(1) Emission factor for PM10 from AP-42, Table 3.2-3, 100% of Total Outlet particulate is assumed to be PM10.
(2) Engine emission factors for NOx, CO, and nm-VOC from stack testing data.
(3) SO2 emission factors from EPA's database "AFSEF" using average fuel consumption of 8500 Btu/hp-hr and 1046 Btu/scf.
(4) Engine emission factors for NOx, CO, and nm-VOC for Units 001, 002, and 003 from stack testing data.
TEST DATA
 | TEST 1 | TEST 2 | TEST 3 | AVG
UNIT 001 | (lb/hr) | (lb/hr) | (lb/hr) | (lb/hr)
NOx | 90.3 | 82.4 | 73.2
CO | 8.1 | 8.2 | 8.6
VOC | 0.531 | 0.512 | 0.465 | 0.503
UNIT 002 | (lb/hr) | (lb/hr) | (lb/hr) | (lb/hr)
NOx | 71.9 | 68 | 67.5
CO | 11.5 | 11.5 | 11.6
VOC | 0.618 | 0.609 | 0.593 | 0.606
UNIT 003 | (lb/hr) | (lb/hr) | (lb/hr) | (lb/hr)
NOx | 80.4 | 86.9 | 87.9
CO | 8.7 | 8.6 | 8.9
VOC | 0.28 | 0.293 | 0.292 | 0.288
* NOx and CO data were obtained from the emission test conducted between July 27-29, 1998
Spreadsheet: 883188d1731691636-use-the-other-formula-instead-of-vlookup-formula-file-a-vehile-ecel-help-forum-3
Sheet: form (2)

 | ABC INTERNATIONAL COMPANY
 | OPERATIONAL VEHICLE DUTY SLIP No:
Employe No. | 0001-10 |  | epi#
Name |  |  | name
Design |  |  | design
Date |  |  | date
From |  |  | start time
to |  |  | end time
Place / Address where vehicle required: |  |  | PLACE
Purpose:- |  |  | PURPOSE
Vehicle No. |  |  | reg#
Type of Vehicle Required: |  |  | type
Make |  |  | make
Power(CC) |  |  | capacity
 |  |  | slip no.
 |  |  | date end
[NAME] at the start of duty:-- |  |  | start reading
at the end of duty |  |  | end reading
Total running of this visit:- |  |  | Total
Spreadsheet: 822370d1679318158-forecast-of-orders-orders-forecast
Sheet: Sheet1

 | Order Hour | 2023-03-17 00:00:00 | 2023-03-18 00:00:00 | 2023-03-19 00:00:00 | 2023-03-20 00:00:00
 | 0 | 108.84 | 118.52 | 272.1 | 334.7122082213551
 | 1 | 39.68 | 44.08 | 118.52 | 234.3085640790499
 | 2 | 19.5 | 19.5 | 54.46 | 231.5735615994201
 | 3 | 11.1 | 12.12 | 31.7 | 74.14060751098887
 | 4 | 12.64 | 11.62 | 32.26000000000001 | 75.85374093229542
 | 5 | 34.62 | 30.82 | 67.6 | 157.8937969970867
 | 6 | 105.06 | 119.44 | 203.78 | 385.205563523853
 | 7 | 188.3 | 221.66 | 404.72 | 400.8331472893271
 | 8 | 221.72 | 232.04 | 446.04 | 460.1917175889837
 | 9 | 237.96 | 240.88 | 511.68 | 517.5980933573591
 | 10 | 225.02 | 249.74 | 457.5 | 523.5075259086175
 | 11 | 209.82 | 237.36 | 411.24
 | 12 | 203.42 | 241.48 | 417.32
 | 13 | 218.02 | 251.58 | 424.48
 | 14 | 225.2 | 265.68 | 439.36
 | 15 | 223.64 | 291.94 | 382.4
 | 16 | 250.28 | 320.38 | 498.72
 | 17 | 257.68 | 388.8 | 542.04
 | 18 | 268 | 422.9 | 557.3199999999999
 | 19 | 301.1 | 481.5 | 576.1600000000001
 | 20 | 347.26 | 629.92 | 656.26
 | 21 | 375.04 | 657.72 | 764.62
 | 22 | 398.62 | 635.7 | 784.5600000000001
 | 23 | 374.54 | 637.38 | 742.12
 | total orders | 4857.059999999999 | 6762.759999999999 | 9796.960000000001
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 7

 | Jul 19 | Jul 26 | Aug 2 | Aug 9 | Aug 16
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 695469d1600235245-what-is-the-formula-to-calculate-the-number-of-combination-sample0916
Sheet: Sheet2

Supplier | Fruit Type |  | Item | Fruit Type1 | Fruit Type2 | Fruit Type3 | Number combination
A | Bananas |  | 1 | Bananas | Apples | Oranges
A | Apples |  | 2 | Apples | Oranges
A | Oranges |  | 3 | Bananas | Apples
B | Apples |  | 4 | Apples
B | Bananas |  | 5
C | Apples
C | Oranges |  | Example Item 2
C | pineapple |  |  | Types of fruits Apples,Oranges (User input)
C | Kiwi |  |  | The A supplier can provide two kinds of fruits Apples and Oranges
D | Oranges |  |  | The C supplier can provide two kinds of fruits Apples and Oranges
D | Apples |  |  | The D supplier can provide two kinds of fruits Apples and Oranges
 |  |  |  | So Total 3 Number combination
Spreadsheet: 836845d1689682552-reverse-proportional-distribution-example
Sheet: Sheet1

Item | Reviews | Ranking | New Rank
A | 161 | 499
B | 6774 | 500
C | 5744 | 504
D | 9484 | 498
E | 30 | 500
Item | Reviews | Ranking | New Rank
A | 1 | 499
B | 2 | 500
C | 3 | 504
D | 4 | 498
E | 5 | 500
Spreadsheet: 783468d1654845825-automatic-define-name-for-multiple-name-ranges-multiple-data-with-single-name-automatic-name-range
Sheet: Sheet1

 | NAME | VALUE
 | Q1 | JAN
 | Q1 | FEB
 | Q1 | MAR
 | Q2 | APR
 | Q2 | MAY
 | Q2 | JUN
 | Q3 | JUL
 | Q3 | AUG
 | Q3 | SEP
 | Q4 | OCT
 | Q4 | NOV
 | Q4 | DEC
Spreadsheet: 539462d1506145474-excel-get-all-data-from-another-sheet-ho-status
Sheet: Summary

Date | Tack Pack No | Item | [NAME] | Merchandiser | Season | Cutting Status | [NAME] | Production Status | Finishing Status | [NAME] | [NAME]
Spreadsheet: 733290d1621492897-help-with-formula-to-extract-multiple-values-from-table-test-workbook
Sheet: Table

 |  | Framer |  |  |  |  |  |  |  |  |  | Help with formula to extract multiple values from table
Address | Job# | Framer | Start | Finish | Bricky | Actual start | Actual Finish |  |  |  |  | GDay guys. First post on here. I will preface this with saying that Im not an excel expert but have a good understanding of using formulas
123 Sample St | 1234 | Mark | 2018-04-04 00:00:00 | 2018-04-11 00:00:00 | [NAME] | 2018-04-30 00:00:00 | 2018-05-11 00:00:00 |  |  |  |  | That being said i have a task that i have no idea how to solve. Have tried using various lookup methods but cant get it to do what i want
Test st 1 |  | Ian | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | [NAME] | 2021-06-01 00:00:00 | 2021-06-10 00:00:00 |  |  |  |  | I have a table (list of jobs and trades allocated to work on that job) that i want to pull data from and group together on another sheet. See attached excel sheet
Test st 2 |  | [NAME] | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | [NAME] | 2021-06-02 00:00:00 | 2021-06-11 00:00:00 |  |  |  |  | The list of jobs will get added to over time so i need something that can search a growing list
Test st 3 |  | Mark | 2021-05-13 00:00:00 | 2021-05-20 00:00:00 | [NAME] | 2021-06-06 00:00:00 | 2021-06-20 00:00:00 |  |  |  |  | What i want to do is search the framer column (F) on my Table sheet for a specific name (eg [NAME]) and then pull the address (column A), start date (column G) and finish date (column H) and then list them in order of date on a separate sheet. The output has been done manually
test st 4 |  | Mark | 2021-05-21 00:00:00 | 2021-05-28 00:00:00 | [NAME] | 2021-06-15 00:00:00 | 2021-06-30 00:00:00 |  |  |  |  | Then i want to do the same for various other trades like brick layers
Test st 5 |  | Ian | 2021-05-18 00:00:00 | 2021-05-23 00:00:00 | [NAME] | 2021-06-07 00:00:00 | 2021-06-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | I have no idea if this is even possible or if maybe it can be done with a pivot table?