tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Pwr Settlemt

 | Power Settlement
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 642322.1868
 | Analyst & Associate | 0 |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 160408.6092
ENAEMPEX | Employee Expense |  |  |  |  |  | 14305.2 | Other
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 0
ENAOUTSV | Outside Services | 0 |  |  |  |  | 0 | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense |  |  |  |  |  | 19741.176
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  | 92433.6 | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  | 19807.2 | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 8 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 0 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 91819d1291487481-vlookup-in-a-macro-for-multiple-ranges-help-moving-vlookup-macro
Sheet: Sheet1

 | Ok so the data i recieve is in the format as below, as numbers not formulae. |  |  |  |  |  | I want to compare the highest figure or the Ranked 1 data row, with the highest figure of the other ranks whithin that data set.
 |  |  |  |  |  |  | In this work book i have over 500 datasets i presume i need a macro to overcome the various loops, that occur as a result of formulae (i have tried many for this colomn, but always get arrows on the screen indicatin a loop.
 |  |  |  |  |  |  |  |  | ?
 |  |  |  |  |  |  |  | Highest Data value for each row
Dataset 1 | Data1 | Data2 | Data3 | Sum | Rank
 | 5 | 7 | 11 | 23 | 7
 | 6 | 14 | 13 | 33 | 6
 | 9 | 8 | 21 | 38 | 4
 | 14 | 11 | 15 | 40 | 3
 | 15 | 16 | 15 | 46 | 1
 | 14 | 14 | 15 | 43 | 2
 | 8 | 5 | 9 | 22 | 8
 | 12 | 18 | 5 | 35 | 5
Dataset 2 | Data1 | Data2 | Data3 | Sum | Rank |  |  |  |  | These cells should be
 | 5 | 7 | 11 | 23 | 4 |  |  |  |  | <- | 15
 | 6 | 14 | 13 | 33 | 3 |  |  |  |  | <- | 15
 | 9 | 8 | 21 | 38 | 2 |  |  |  |  | <- | 15
 | 14 | 11 | 15 | 40 | 1 |  |  |  |  | <- | 15
Dataset 3 | Data1 | Data2 | Data3 | Sum | Rank
 | 5 | 7 | 11 | 23 | 5 |  |  |  |  | <- | 25
 | 6 | 14 | 13 | 33 | 6 |  |  |  |  | <- | 25
 | 15 | 25 | 15 | 46 | 1 |  |  |  |  | <- | 25
 | 14 | 14 | 15 | 43 | 2 |  |  |  |  | <- | 25
 | 8 | 5 | 9 | 22 | 8 |  |  |  |  | <- | 25
 | 12 | 18 | 5 | 35 | 5 |  |  |  |  | <- | 25
Dataset 4 | Data1 | Data2 | Data3 | Sum | Rank
 | 12 | 52 | 22 | 86 | 2
 | 25 | 22 | 25 | 72 | 3
 | 32 | 25 | 36 | 93 | 1
 | 11 | 10 | 12 | 33 | 5
 |  |  |  | 0 | 6 |  |  |  |  |  |  | This row here represnts where no data was obtained, however I still need cell [NAME] and [NAME] to yeild "36"
 | 12 | 15 | 16 | 43 | 4
Spreadsheet: 705040d1605865624-sum-return-vrong-result-sum
Sheet: 19 Nov

 |  |  |  | [NAME] | data2
 |  |  |  | 64,63 | 37,17
 |  |  |  | 331,43 | 110,82
 |  |  |  | 106,42 | 52,95
 |  |  |  | 124,36 | 59,87
 |  |  |  | 340,25 | 118,61
 |  |  |  | 206,17 | 89,73
 |  |  |  | 187,78 | 83,06
 |  |  |  | 334,19 | 120,94
 |  |  |  | 96,91 | 50,16
 |  |  |  | 127,13 | 60,06
Spreadsheet: 761700d1641165048-how-to-arrange-the-number-of-the-year-and-month-according-to-cell-a1-forumhelp_1-3
Sheet: Sheet1

2022-01-01 00:00:00 | Key in date
2022-01-01 00:00:00 |  | SUN | MON | TUE | WED | THU | FRI | SAT
2022-02-01 00:00:00 |  |  |  |  |  |  |  | 1 |  |  | All result only this table
2022-03-01 00:00:00 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
2022-04-01 00:00:00 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
2022-05-01 00:00:00 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
2022-06-01 00:00:00 |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
2022-07-01 00:00:00 |  | 30 | 31
2022-08-01 00:00:00
2022-09-01 00:00:00
2022-10-01 00:00:00 |  | When A2 change to 2022/2/1 , C4:I9 Result show as below  (SAMPLE)
2022-11-01 00:00:00
2022-12-01 00:00:00 |  |  |  | 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
Spreadsheet: 803292d1667378572-problem-in-nested-if-test2
Sheet: Sheet1

No | Result | [NAME]
7 | 7-25
24 | 7-25
25 | 7-25
26 | 25-50
49 | 25-50
50 | 26-50
51 | 51-299
298 | 51-299
299 | 51-299
300 | 300-500
301 | 300-500
499 | 300-500
500 | 300-500
Spreadsheet: richard_shapiro__32124__accomp
Sheet: Sheet1

Accomplishment for the Period November 2000 to April 2001
Name: | [NAME] | Region/Country: |  | WSCC Region | Primary Activity: | Electricity | Secondary Activity: | Gas
No. | Accomplishments | Customer | Value | Area |  |  |  |  | Methodology
 | (description) | (B. Unit) | ($) | Deal Support | Origination | Risk Management | [NAME] | Other
-1 | -2 | -3 | -4 | -5 | -6 | -7 | -8 | -9 | -10
Legend:
-1 | Serial Number
-2 | Description of your accomplishment
-3 | Your customer (e.g., EES, Enron Venezuela, EBS…etc.)
-4 | Dollar impact of your efforts
(5), (6), (7), (8) and (9)  Likely area of impact
-10 | Methodology used to arrive at dollar impact in 4.
Spreadsheet: 229617d1366472059-drop-box-multiple-column-sinisaj-example
Sheet: Sheet1

Faults
name | points | description
Critical | 5 | Choose this if have more than XX faults
Serious | 3 | Choose this if have between 3 and 5 faults
Moderate | 1 | Choose this if have below faults
Last check
name | points | description
Annualy | 5 | Last check more then year ago
Moderate | 3 | Last check between half and year ago
Shortly | 1 | Last check less then half year ago
Services | Faults | [NAME] | Total
AD | Critical | Moderate
email | Serious
internet | Moderate
Spreadsheet: 526163d1499168630-count-number-of-nonblank-cells-in-column-b-c-if-value-in-column-d-1-or-2-sample
Sheet: Sheet3

 | Invitee | Guest | Priority | Travelling |  | Total P1: | 25 | Total P2: | 3 | Total P3: | 3
 | Name | Date's Name | 1 | No
 | Name | Date's Name | 1 | No
 | Name | Date's Name | 1 | No
 | Name | Date's Name | 1 | No
 | Name |  | 1 | Yes
 | Name | Date's Name | 1 | Yes
 | Name |  | 1 | No
 | Name | Date's Name | 1 | No
 | Name | Date's Name | 1 | Yes
 | Name |  | 3 | No
 | Name | Date's Name | 1 | No
 | Name | Date's Name | 3 | No
 | Name | Date's Name | 1 | No
 | Name |  | 1 | No
 | Name | Date's Name | 2 | Yes
 | Name |  | 2 | Yes
 | Name | Date's Name | 1 | No
 | Name | Date's Name | 1 | Yes
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg20

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Drip Zone 19 (N) |  | Field Name: |  | Drip Zone 20 (N) |  | Field Name: |  | Drip Zone 21 (N) |  | Field Name: |  | Drip Zone 22 (N)
 |  |  |  |  |  | Area (acres): |  | 25.05 |  | Area (acres): |  | 10.95 |  | Area (acres): |  | 28.01 |  | Area (acres): |  | 33.22
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 31.3 |  | Annual Rate (in): |  | 31.3 |  | Annual Rate (in): |  | 31.3 |  | Annual Rate (in): |  | 31.3
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 114242d1310039646-colour-a-cell-if-having-a-match-in-adjacent-column-test
Sheet: Sheet2

Set A | Set B
Contig 1 | Contig 26
Contig 23 | Contig 1
Contig 43 | Contig 11
Contig 34 | Contig 34
Contig 12 | Contig 23
Contig 13 | Contig 17
Contig 14 | Contig 14
Contig 15 | Contig 15
Contig 16 | Contig 26
Contig 17 | Contig 62
Contig 18 | Contig 16
Contig 19 | Contig 17
Contig 20 | Contig 85
Contig 21 | Contig 95
Contig 22 | Contig 22
Spreadsheet: 273484d1382724544-array-formulas-book1
Sheet: October 2013 RSSM

Part # | Description | EC | DWG | OCL | AMR | Boxes | STD $ | MTS Qty | MCS Qty | [NAME] | Scrap MTS $ | Scrap To | Scrap %
1234567 | part name data | 2 number | X | XX | 3 |  | 0.01 | 1 | 1 | 1 |  | 2 digit facility code any combo of letters or numbers | 1
5678910 | varries | code | X | XX | 10 | 1 | 1 | 2 | 2 | 2 | 2 | 1X | 1
9876543 |  | varries | X | XX | 20 | 1 | 1 | 3 | 3 | 3 | 3 | X1 | 1
3000000 |  | 0 | XD | XX / XX / XX | 20 | 1 | 1 | 4 | 4 | 4 | 4 | XX | 1
0X0000 |  | 0 | X | XX | 10 | 1 | 1 | 5 | 5 | 5 | 5 | 1X | 1
1000000 |  | 0 | X | XX | 20 | 1 | 1 | 6 | 6 | 6 | 6 | X1 | 0.5
1000000 |  | 0 | X | XX / XX | 20 | 1 | 1 | 6 | 6 | 6 | 6 | XX | 0.5
 | Part Numbers |  |  |  | Box's |  |  | Total MTS$
Spreadsheet: 821045d1678406896-complex-conditional-formatting-for-visual-automatic-calendar-event-dashboard-2023
Sheet: Overview

Update | Date | Event Name | Industry | Public | Education | Location | Start Time | End Time | All docs received | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00
30-Sep | Thursday, September 28
45199_1
1-Oct
45199_1
45200_2
2-Oct
45201_1
45200_2
3-Oct
45202_1
45200_2
4-Oct
45203_1
5-Oct
45204_1
7-Oct
45206_1
8-Oct
45206_1
9-Oct
45206_1
Spreadsheet: 153330d1335875553-calculation-of-text-and-numbers-claims
Sheet: PL

 | Policy | Turnover/ | Turnover- | Settled Claims |  | Outstanding  Claims |  | Excess
 | Year | Wages | USA/Canada | (See notes 1 & 2) |  | (See notes 2 & 3) |  | Applicable
 |  | £ | £ | No | Amount £ | No | Amount £ | £
 |  |  |  | 0 | Nil | 0 | Nil
 |  |  |  | 0 | Nil | 0 | Nil
 |  |  |  | 0 | Nil | 0 | Nil
 |  |  |  | 0 | Nil | 0 | Nil
 |  | Not Insured
 | Notes
Spreadsheet: e1bd90a3-97bf-48c3-95d3-bf5cc2ab4ac7
Sheet: 28

Uke: | 28 |  |  |  |  | Navn:
 |  | Mandag |  | Tirsdag |  | Onsdag |  | Torsdag |  | Fredag |  | Lørdag |  | Søndag |  | Sum
Kvalitet | Form | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | ok | Plan | Trent | Diff. | Feedback
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
AKKUMULERT
Kvalitet | Form | Plan |  | Trent
Aerob | Kontinuerlig
 | Intervall
Anaerob | Lokalt
 | Generell
Maks.styrke | Sub.maks.
 | Tungt
 | Eksplosivt
Uth.styrke | Sirkel
 | Tungt
Spenst
Hurtighet
Koordinasjon
Bevegelighet
[NAME]
 | Sum
Spreadsheet: 83603d1283559729-formula-or-macro-to-format-a-report-formatreport1
Sheet: New Provide and HardChange

Sno | Received Date | Customer Name | SR Ref | Omars Ref | Order Type | Postcode | BT Ref | Appt Date | Telephone Number | Status | L-type CPS | Appt Confirmsheet Updated Status | Reason/Comments | CA
1 | 2010-03-09 00:00:00 |  | 1234 |  | Common Low Volume Requests | N/A | THU42457 | N/A | N/A | In Progress |  |  |  | dattanibth
2 | 2010-03-09 00:00:00 |  | 4567 |  | Wholesale Access Business Single Line New Provision | ABCDEF | THU42456 | 13/09/2010 pm | 12345678901 | Approved |  |  |  | gajjarmat
3 | 2010-03-09 00:00:00 |  | 177627 |  | Wholesale Access Multiline Aux Conversion | BCDEFG | [NAME] | N/A | 13240932434 | In Progress |  |  |  | th_y126488
4 | 2010-03-09 00:00:00 |  | 23433 |  | Digital System Change | CDEFGH | THU42454 | N/A | 89343432432 | Closed |  |  |  | dattanibth
5 | 2010-03-09 00:00:00 |  | 43433 |  | Common Low Volume Requests | DEFGHI | THU42453 | N/A | 23423432423 | In Progress |  |  |  | punjakt
6 | 2010-03-09 00:00:00 |  | 34434 |  | Common Low Volume Requests | EFGHIJ | THU42452 | N/A | 32423434324 | In Progress |  |  |  | punjakt
7 | 2010-03-09 00:00:00 |  | 344343 |  | Wholesale Access Business Single Line New Provision | FGHIJK | THU42451 | N/A | N/A | In Progress |  |  |  | dattanibth
8 | 2010-03-09 00:00:00 |  | 324343 |  | Common Low Volume Requests | GHIJKL | THU42450 | N/A | 55554353454 | Rejected |  |  |  | punjakt
9 | 2010-03-09 00:00:00 |  | 34343 |  | Wholesale Access Business Single Line New Provision | HIJKLM | THU42449 | [NAME] am | 6666666666 | In Progress |  |  |  | gajjarmat
10 | 2010-03-09 00:00:00 |  | N/A |  | Wholesale ISDN30e Change | IJKLMN | THU42448 | N/A | 8989898399 | Approved |  |  |  | punjakt
11 | 2010-03-09 00:00:00 |  | N/A |  | [NAME] | JKLMNO | THU42447 | N/A | 7634673432 | Effective |  |  |  | gajjarmat
Spreadsheet: 3e5a9615-ed46-437b-8b75-f0eb87ac1509
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7369 | 56301 | [NAME] | Bozzato | ITA | 53 | 00:12:52 | 00:01:31 | 00:40:37 | 00:00:00 | [NAME] | 1 | 01:22:41
7369 | 55904 | Christian | Troger | AUT | 52 | 00:14:15 | 00:02:26 | 00:35:11 | 00:00:00 | 00:33:11 | 2 | 01:25:05
7369 | 56314 | [NAME] | Devicenzi | ITA | 54 | 00:14:33 | 00:01:34 | 00:35:20 | 00:00:00 | 00:43:16 | 3 | [NAME]
7369 | 56507 | [NAME] | Solodovnikov | RUS | 51 | 00:16:27 | [NAME] | 00:43:32 | 00:00:00 | 00:45:02 | 4 | 01:48:36
Spreadsheet: danny_mccarty__4627__Exhibit 7 - 2001- MKM
Sheet: February 2001

 | NORTHERN NATURAL GAS COMPANY |  |  |  | Privileged and Confidential.  Prepared for
 | System Levelized Account |  |  |  | Settlement purposes only.
 | February 2001
 |  |  |  |  |  |  |  |  |  |  | SLA Account
 |  |  |  |  |  |  |  |  |  |  | Total |  | Cash Portion - |  | Future
 |  | Operational |  |  |  |  |  |  |  |  |  |  | Cash Out/ |  | Liability
 |  | Storage |  | SLA Calculation |  |  |  |  |  |  |  |  | (Cash In)
 |  | [NAME] | Volume | Dollar | Dollar |  |  |  | Net |  | SLA Impact |  | Col (e)*-1 |  | Col (d)*(g)
Line |  | (Over)/Under | Valued | Valued | Amount | Cost |  | Monthly | Cost |  | Increase/
No. | Type of Volume | 14 Bcf | [NAME] | [NAME] | (Cash Out)/ | Per Mcf |  | MIP | Per Mcf |  | (Decrease)
 |  | Col (c)+(d) |  |  | Cash In | Col (e)/(d) |  |  | Col (g)-(f) |  | Col (d)*(h)
 | Column (a) | (b) | (c) | (d) | (e) | (f) |  | (g) | (h) |  | (i) |  | (j) |  | (k)
 | February, 2001
1 | 01/01 Balance Per Books: | -512281 | -2642581 | 2130300 | -52370715 |  |  | 8.24 |  |  | 69924388 |  | 52370715
2 | Revalue 01/01 Shortfall @ Current [NAME]: |  |  |  |  | 8.24 | 1/ | 5.6802
3 | 02/01 Activity
4 | Dollar Valued Imbalance |  |  | -1505362
5 | Imbalance Tiering Gain |  |  |  | 181380
6 | Gas Purchases |  |  | 0 | 0
7 | Miscellaneous
8 | Net 02/01 Activity |  | -832458
9 | 02/01 Balance Per Books:
 | 1/  Prior Month's MIP
Spreadsheet: 795333d1662634991-formula-to-calculate-most-efficient-choice-of-data-with-smallest-remainder-efficiency
Sheet: Sheet1

 |  | Lengths of wood
 |  | 2440 | 3050 | 4220
Piece 1 | 100
Piece 2 | 145 | 145 | 145
Piece 3 | 237 | 237 | 237
Piece 4 | 345 | 345
Piece 5 | 267 | 267 | 267
Piece 6 | 134 | 134 | 134 | 134
Piece 7 | 567 |  |  | 567
Piece 8 | 2240 |  | 2240 | 2240
Piece 9 | 1234 | 1234 |  | 1234
Piece 10 | 44 | 44 |  | 44
 | Total
 | Remainder
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 12b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending December 28, by product type and supermajor currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. 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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency 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: 695343d1600165344-sorting-data-that-only-has-value-greater-than-1-times
Sheet: Code

 |  | Delays In Numbers | Time Final | Time 1
 | Shop | Number Of Delays | Longest Delay
 | Aldi | 1 | 07:55:00
 | Lidl | 2 | 01:55:00
 | Morrisons | 3 | 05:55:00
 | Sofa World | 2 | 07:03:00
 | Burger King | 3 | 09:40:00
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Struct

 | Structuring
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 1
 |  |  |  |  |  |  |  |  |  | Director | 156000
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0 |  | 1
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 830402d1684897829-need-minimum-value-in-a-sumproduct-formula-sumproduct-help
Sheet: Sheet1

At any given week I want to know the percentage of students that graduated from class as an average, however any graduates over the required amount can't count towards the average. I need to somehow take the minimum of the individual row percentages (i.e. H4/H8) between the calculated value and the maximum of 1 and then get a cumulative average from that.
 |  |  |  | [NAME]
 |  | Classes | Required # of Students | 2023-03-06 00:00:00 | 2023-03-13 00:00:00 | 2023-03-20 00:00:00 | 2023-03-27 00:00:00
 |  | A | 8 | 2 | 3 | 4 | 4
 |  | B | 6 | 0 | 0 | 5 | 8
 |  | C | 3 | 1 | 2 | 3 | 3
 |  | D | 0 | 4 | 5 | 5 | 5
 |  | E | 3 | 3 | 4 | 5 | 6
 |  | F | 6 | 4 | 4 | 4 | 6
 |  | G | 2 | 0 | 1 | 2 | 4
Spreadsheet: 760165d1640026874-help-with-complex-conditional-formatting-misc
Sheet: Sheet2

Sum of Units | Column Labels
Row Labels | Face-to-Face | Over-the-Phone | Grand Total
[NAME] | 1 | 0 | 1
30 min. | 1 | 0 | 1
11/11/2021 - Nathan Dales | 1 | 0 | 1
[NAME] 5004 | 0 | 1 | 1
15 min. | 0 | 1 | 1
11/18/2021 - Tony Daniels | 0 | 1 | 1
[NAME] | 0 | 1 | 1
30 min. | 0 | 1 | 1
11/20/2021 - Tony Daniels | 0 | 1 | 1
[NAME] | 1 | 0 | 1
30 min. | 1 | 0 | 1
11/21/2021 - Cynthia Dale | 1 | 0 | 1
[NAME] | 0 | 1 | 1
30 min. | 0 | 1 | 1
11/14/2021 - Jennifer Dale | 0 | 1 | 1
[NAME] | 1 | 0 | 1
30 min. | 1 | 0 | 1
11/10/2021 - Nathan Dales | 1 | 0 | 1
[NAME] | 0 | 1 | 1
30 min. | 0 | 1 | 1
11/26/2021 - Normand D'Amour | 0 | 1 | 1
[NAME] | 1 | 0 | 1
30 min. | 1 | 0 | 1
11/29/2021 - Lawrence Dane | 1 | 0 | 1
[NAME] | 0 | 1 | 1
30 min. | 0 | 1 | 1
11/05/2021 - Tony Daniels | 0 | 1 | 1
[NAME] | 1 | 0 | 1
30 min. | 1 | 0 | 1
11/24/2021 - [NAME] | 1 | 0 | 1
[NAME] | 0 | 2 | 2 |  | Should be yellow too because neither of these meetings are 60 min or amount to two 60 min meetings.
15 min. | 0 | 1 | 1
11/08/2021 - Jennifer Dale | 0 | 1 | 1
1 min. | 0 | 1 | 1
11/14/2021 - Jennifer Dale | 0 | 1 | 1
[NAME] | 1 | 0 | 1
49 min. | 1 | 0 | 1
11/30/2021 - Nathan Dales | 1 | 0 | 1
[NAME] | 0 | 2 | 2
80 min. | 0 | 2 | 2
11/08/2021 - Normand D'Amour | 0 | 1 | 1
11/28/2021 - Normand D'Amour | 0 | 1 | 1
[NAME] | 2 | 0 | 2
80 min. | 2 | 0 | 2
11/16/2021 - Lawrence Dane | 1 | 0 | 1
11/20/2021 - Lawrence Dane | 1 | 0 | 1
[NAME] | 0 | 2 | 2
80 min. | 0 | 2 | 2
11/22/2021 - Tony Daniels | 0 | 1 | 1
11/30/2021 - Tony Daniels | 0 | 1 | 1
[NAME] | 1 | 0 | 1
80 min. | 1 | 0 | 1
11/16/2021 - Cynthia Dale | 1 | 0 | 1
Grand Total | 9 | 11 | 20
Spreadsheet: 126544d1319739545-ranking-with-3-way-tie-breaker-rank
Sheet: Sheet1

1 | 15 | 1 | 15 | 1 | 20 | 1 | 10 | 0.5 | -50 | 20 | 0 | 0 | 10 | 0.98 | 6 | 80 | 1
1 | 15 | 1 | 15 | 1 | 20 | 1 | 10 | 0.5 | -50 | 20 | 0 | 0 | 10 | 0.985 | 6 | 80 | 2
0.927 | 9 | 0.955 | 3 | 0.928 | 12 | 0.7455 | 6 | 1.111 | -111.1 | 12 | 0.045 | -4.5 | 6 | 0.97 | 6 | 42 | 4
0.914 | 9 | 0.995 | 15 | 1 | 20 | 0.8409 | 6 | 0.782 | -78.2 | 20 | 0.087 | -8.7 | 0 | 0.969 | 2 | 64 | 3