tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: joe_parks__14513__P&L_JUN01
Sheet: GasDaily

2000-09-01 00:00:00 |  | HH | ANR-S |  | NAT LA |  | trkl-stx |  | TEXOK-E |  | Trunk-wla |  | Trunk-ela |  | ngpl-stx |  | KATY |  | CGT-ons |  | WAHA |  | PERMIAN |  | TGT |  | 500 |  | 800 |  | HSC |  | CHIC |  | consum |  | MICH |  | TCO |  | CNG-N |  | CNG-s |  | TransZ3
 |  |  | LA |  | LA |  | stx |  | ET |  | LA |  | LA |  | CORPUS
FOM | A | 3.74
GD 1st |  | 3.73 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.83 |  |  |  | 3.63 |  |  |  |  |  |  |  |  |  | 3.83
2 | CC | 3.705 | 3.55 |  | 3.65 |  | 3.64 |  | 3.625 |  | 3.59 |  | 3.565 |  | 3.585 |  | 3.725 |  | 3.655 |  | 3.55 |  | 3.51 |  | 3.66 |  | 3.63 |  | 3.61 |  | 3.77 |  | 3.75 |  | 3.89 |  | 3.93 |  | 3.875 |  | 3.93 |  | 3.94 |  | 3.705
3 | CC | 3.705 | 3.55 |  | 3.65 |  | 3.64 |  | 3.625 |  | 3.59 |  | 3.565 |  | 3.585 |  | 3.725 |  | 3.655 |  | 3.55 |  | 3.51 |  | 3.66 |  | 3.63 |  | 3.61 |  | 3.77 |  | 3.75 |  | 3.89 |  | 3.93 |  | 3.875 |  | 3.93 |  | 3.94 |  | 3.705
4 | CC | 3.705 | 3.55 |  | 3.65 |  | 3.64 |  | 3.625 |  | 3.59 |  | 3.565 |  | 3.585 |  | 3.725 |  | 3.655 |  | 3.55 |  | 3.51 |  | 3.66 |  | 3.63 |  | 3.61 |  | 3.77 |  | 3.75 |  | 3.89 |  | 3.93 |  | 3.875 |  | 3.93 |  | 3.94 |  | 3.75
5 | CC | 3.945 | 3.825 |  | 3.91 |  | 3.89 |  | 3.89 |  | 3.855 |  | 3.82 |  | 3.83 |  | 3.965 |  | 3.9 |  | 3.88 |  | 4.005 |  | 3.9 |  | 3.835 |  | 3.83 |  | 3.995 |  | 4 |  | 4.095 |  | 4.14 |  | 4.095 |  | 4.155 |  | 4.16 |  | 3.955
6 | CC | 3.985 | 3.89 |  | 3.97 |  | 3.91 |  | 3.97 |  | 3.935 |  | 3.865 |  | 3.9 |  | 4.035 |  | 3.92 |  | 3.99 |  | 4.025 |  | 3.935 |  | 3.86 |  | 3.855 |  | 4.075 |  | 4.08 |  | 4.145 |  | 4.19 |  | 4.125 |  | 4.175 |  | 4.19 |  | 4.015
7 | CC | 3.75 | 3.67 |  | 3.72 |  | 3.7 |  | 3.7 |  | 3.67 |  | 3.645 |  | 3.645 |  | 3.76 |  | 3.695 |  | 3.665 |  | 3.635 |  | 3.71 |  | 3.66 |  | 3.66 |  | 3.795 |  | 3.84 |  | 3.88 |  | 3.905 |  | 3.875 |  | 3.96 |  | 3.955 |  | 3.785
8 | CC | 3.68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.655 |  |  |  | 3.525 |  |  |  |  |  |  |  |  |  | 3.685
9 | CC | 3.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.6 |  |  |  | 3.35 |  | 3.22 |  |  |  |  |  |  |  | 3.63
10 | CC | 3.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.6 |  |  |  | 3.35 |  | 3.22 |  |  |  |  |  |  |  | 3.64
11 | CC | 3.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.6 |  |  |  | 3.35 |  | 3.22 |  |  |  |  |  |  |  | 3.64
12 | CC
13 | CC
14 | CC
15 | CC
16 | CC
17 | CC
18 | CC
19 | CC
20 | CC
21 | CC
22 | CC
23 | CC
24 | CC
25 | CC
26 | CC
27 | CC
28 | BB
29 | CC
30 | DD |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
31 | EE |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  | 0
mtd average
dif from hub
dif from 1st
last 3 days
last 5 days
last 7 days
GDA from IF
 |  | c | d | e | f | e | g | e | h | e | i | e | j | e | k | e | l | e | m | e | n | e | o | e | p | e | q | e | r | e | s | e | t | e | u | e | v | e | v | e | v | e | v | e | v | e | af | ag | ah | ai | aj | ak | al | am | an | ao | ap
Spreadsheet: 762759d1641802249-summing-the-mutiple-ranges-where-the-same-header-are-there-tried-sumifs-index-xlookup-testing
Sheet: Summary

 |  |  | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00
6 | A
7 | A
8 | A
9 | A
10 | A
11 | A
12 | A
 | Total
6 | B
7 | B
8 | B
9 | B
10 | B
11 | B
12 | B
 | Total
6 | C
7 | C
8 | C
9 | C
10 | C
11 | C
12 | C
 | Total
Spreadsheet: 61437d1262283603-sorting-data-by-date-within-a-date-range-month-factors
Sheet: Sheet1

date range
2008-05-01 00:00:00 | to | 2009-04-30 00:00:00
Month | Factor |  |  |  |  | factors
January |  |  | 5 | 2008 | 2008-05-01 00:00:00 | 1.27
February |  |  | 6 | 2008 | 2008-06-01 00:00:00 | 1.23
March |  |  | 7 | 2008 | 2008-07-01 00:00:00 | 1.25
April |  |  | 8 | 2008 | 2008-08-01 00:00:00 | 1.27
May |  |  | 9 | 2008 | 2008-09-01 00:00:00 | 1.01
June |  |  | 10 | 2008 | 2008-10-01 00:00:00 | 1.25
July |  |  | 11 | 2008 | 2008-11-01 00:00:00 | 1.260056818181818
August |  |  | 12 | 2008 | 2008-12-01 00:00:00 | 1.055634920634921
September |  |  | 13 | 2008 | 2009-01-01 00:00:00 | 1.25
October |  |  | 14 | 2008 | 2009-02-01 00:00:00 | 1.332240663900415
November |  |  | 15 | 2008 | 2009-03-01 00:00:00 | 1.012375296912114
December |  |  | 16 | 2008 | 2009-04-01 00:00:00 | 1.352040816326531
Spreadsheet: 765722d1643548181-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Deal Processing

TO BE PROCESSED |  |  |  |  |  |  |  | PROCESSED
Sales Rep | Year | Vehicle | Client | Business Manager | STATUS |  |  | Sales Rep | Year | Vehicle | Client | Business Manager
Spreadsheet: 678042d1589687430-analysing-a-list-and-creating-a-chart-example2
Sheet: Sheet1

 |  |  |  |  |  |  | Lists
 |  |  |  |  |  |  | 1 | 2 | 3 | 4
List 1 | a | b | c | d |  | a | x | x
List 2 | a | c | d | e |  | b | x |  |  | x
List 3 | c | d | e | f |  | c | x | x | x
List 4 | b | d | e | f |  | d | x | x | x | x
 |  |  |  |  |  | e |  | x | x | x
 |  |  |  |  |  | f |  |  | x | x
Spreadsheet: 236731d1368970294-different-real-cell-value-from-whats-showing-or-hidden-value-pls-help-activation-log
Sheet: New Mobile Activations

Mobile
Employee  Name:
Employee ID: | 1516
[NAME]/Month: | 2013-05-01 00:00:00
[NAME] | [NAME]. | Date | Equipment Model | IMEI | Post Paid Code |  | Prepaid Code | [NAME] | Rate Plan |  | Rate Plan Commission |  | Accessories | Sub Total
 |  |  |  |  | 1yr Contract | 2yr Contract |  |  | $1.00-$49.99 | $50.00-$99.99 | $1.00-$49.99 | $50.00+
 |  |  |  |  |  |  |  |  | 0 | 70 |  | 54 | 100
 |  |  |  |  |  |  |  |  | 19.99 | 0 |  | 0 | 100
 |  |  |  |  |  |  |  |  | 0 | 59.99 |  | 54 | 100
 |  |  |  |  |  |  |  |  | 39.99 | 0 |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: ad882aa1-1164-4de2-b48e-774b44e1977c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32
 | 130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | o
 | 120
T | 110
H | 100
R | 90
U | 80
S | 70
T | 60
 | 50
Lbs. | 40 |  |  |  |  |  |  |  |  |  | X
 | 30
 | 20
 | 10
 | 0 | X
 |  | 0 | 25 | 50 | 75 | 100 | 125 | 150 | 175 | 200 | 225 | 250 | 275 | 300 | 325 | 350 | 375 | 400 | 425 | 450 | 475 | 500 | 525 | 550 | 575 | 600 | 625 | 650 | 675 | 700 | 725 | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | P | R | E | S | S | U | R | E |  | (Psig.)
Spreadsheet: 705722d1606282554-need-a-dynamic-sum-formula-book2
Sheet: BOOK

 |  | 2020-11-18 00:00:00
Location | Location | First Name | Last Name | Title | Invitations | Logins | Views | Views per Login | Invitations per Login
 |  |  |  |  |  | need sum of albany here
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  | 5
 |  |  |  |  |  | 6
 |  |  |  |  |  | 7
 |  |  |  |  |  | need sum of albuquerque here
 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
Spreadsheet: 768383d1644943430-index-match-that-compares-if-date-is-between-two-dates-and-returns-yes-or-no-practice
Sheet: Apr-Jun

Date = Mon-Sun Weekly completion
Salary | 4/5-4/11 | 4/12-4/18 | 4/19-4/25 |  | 4/26-5/2 | 5/3-5/9 | 5/10-5/16 | 5/17-5/23 | 5/24-5/30 | 5/31-6/6 | 6/7-6/13 | 6/14-6/20 | 6/21-6/27 | 6/28-7/4 |  |  |  | 1/11-1/18 | 1/11-1/19 | 1/11-1/20
*[NAME] | √
*[NAME] Merten | VAC
*[NAME] | X
Hourly | 4/5-4/11 | 4/12-4/18 | 4/19-4/25 |  | 4/26-5/2 | 5/3-5/9 | 5/10-5/16 | 5/17-5/23 | 5/24-5/30 | 5/31-6/6 | 6/7-6/13 | 6/14-6/20 | 6/21-6/27 | 6/28-7/4
OPEN | √
[NAME] | X
[NAME] | √
[NAME] | X
Dewayne Pillow | √
[NAME] | X
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | √
[NAME] | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blacked cells = N/A           * = Mon-Fri shifts |  |  | X
[NAME] | X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAC
[NAME] | √ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF
[NAME] | X
[NAME] | X
Shannon Reeves | √
[NAME] | X
[NAME]
[NAME] | X
[NAME]
[NAME] | X
[NAME] | X
[NAME] | X
[NAME] | X
[NAME]
[NAME]
OPEN | X
[NAME] | X
[NAME] | √
Lance May | X
[NAME] | √
[NAME] | X
[NAME] | X
[NAME] | √
[NAME] | √
[NAME] | X
[NAME] | X
[NAME] | √
Spreadsheet: 151218d1334833116-pivot-table-how-to-sort-drop-down-lists-da6126-ctreconciler-redacted_reply
Sheet: CT Reconcile

Version | 2012-04-16-01 | CT Reconcile
MWH Ref | 0
Taxpayer name | 0
CT ref | 0
Control account | CT (734, 735, 831, 832, 833)
Run date/time | 2012-04-19 16:25:30
 |  | APE | (All)
 |  | Processed? | FALSE
 |  | Reconciled? | (All)
 |  | Sum of Movement total £ Dr/(Cr) | Account
 |  | CTPE | 485 PL Int | 771 BS Bank | Grand Total
 |  | 2010-04-30 00:00:00 | 66.68 | -3866.68 | -3800
 |  | Grand Total | 66.68 | -3866.68 | -3800
Spreadsheet: 0385c864-4329-4c28-961a-5128848fad14
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 43. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (VIC), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413792J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413793K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413794L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413795R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413796T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413797V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413798W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413799X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413800W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413801X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413802A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 7e43e4cf-3564-4c86-940c-33a21ed5c8b3
Sheet: RATES

 |  |  | K-REP BANK LTD
 |  |  | FOREIGN EXCHANGE RATES
 | Date | 2012-04-05 00:00:00 |  |  |  | Spot Value | 2012-07-05 00:00:00
CURRENCY | CASH |  | MEAN | CHEQUE |  | TT
 | BUY | SELL |  | BUYING | SELLING | BUYING | SELLING
USD
GBP
EURO
SA [NAME] | 9.76 | 11.8
KES/USHS | 28.7 | 30.89
KES/TSHS | 17.92 | 20.08
CAN $ | 83.52 | 85.75
S FRANC | 90.15 | 92.4
JPY(100) | 102.93 | 105.12
IND RUPEE | 1.56 | 1.58
AUD | 84.86 | 87.1
AE DHIRAM | 21.68 | 23.73
Rates against shillings are good for amounts above USD 5,000.00 or equivalent.
For amounts in excess of USD 5,000.00 or its equivalent, please contact TREASURY  for firm quotations
 | RATES ARE INDICATIVE
INTERBANK RATES FROM CBK |  |  |  | INTERBANK RATES
 | Buying | Selling |  |  | Buying | selling
USD |  |  |  | USD | 83.1 | 83.3
GBP |  |  |  | GBP | 1.619 | 1.6192
EURO |  |  |  | EURO | 1.3151 | 1.3153
PREPARED BY: Eliud Oware |  |  |  | VERIFIED BY: [NAME] |  |  |  | Time&Date ----------------------------------------------
 |  | Bank A/c No. | Name of Bank | Amount |  | Rate | Purpose | M Date | CBK use only
 |  | [PHONE] | Charter House | 50012328.75 |  |  | Repayment | 2005-04-29 00:00:00
 |  | [PHONE] | Paramount | 10002356.15 |  |  | Repayment | 2005-04-29 00:00:00
 |  | [PHONE] | Credit Bank | 12002465.75 |  |  | Repayment | 2005-04-29 00:00:00
 |  | [PHONE] | I & M Bank | 20004931.5 |  |  | Repayment | 2005-04-29 00:00:00
 |  | [PHONE] | Fina Bank | 20004767.1 |  |  | Repayment | 2005-04-29 00:00:00
 |  | [PHONE] | Consolidated Bank | 30006904.1 |  |  | Repayment | 2005-04-29 00:00:00
 |  | [PHONE] | Kcb ltd | 25005821.9 |  |  | Repayment | 2005-04-29 00:00:00
 |  | [PHONE] | K-RepBank-Cbk Mombasa | 3000000 |  |  | Transfer | 2005-04-29 00:00:00
 |  |  | Total
Spreadsheet: 83214d1283250849-selecting-oldest-date-from-list-test
Sheet: Sheet1

Supplier | Last Invoice date |  | 2010-02-01 00:00:00
A | 2010-10-01 00:00:00 | No
A | 2010-10-02 00:00:00 | No
A | 2010-10-03 00:00:00 | No
A | 2009-10-04 00:00:00 | Yes
B | 2010-05-01 00:00:00 | No
B | 2010-05-02 00:00:00 | No
B | 2010-05-03 00:00:00 | No
B | 2009-05-04 00:00:00 | Yes
C | 2007-05-01 00:00:00 | Yes
C | 2007-05-02 00:00:00 | Yes
C | 2007-05-03 00:00:00 | Yes
C | 2007-05-04 00:00:00 | Yes
Spreadsheet: 39636d1237918923-lookup-across-3-columns-to-get-total-value-sumproduct-datesandcategorysummary
Sheet: Sheet3

Date | Category | Amount Paid |  |  |  |  | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00
2007-01-10 00:00:00 | Education | 1000 |  |  |  | Products | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 510 | 25
2007-01-31 00:00:00 | Education | 40 |  |  |  | Stationery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
2007-03-03 00:00:00 | Products | 10 |  |  |  | Education | 1040 | 0 | 0 | 0 | 0 | 50 | 600 | 0 | 125
2007-04-27 00:00:00 | Equipment | 180
2007-06-27 00:00:00 | Education | 50
2007-07-27 00:00:00 | Education | 600
2007-09-17 00:00:00 | Products | 400
2007-09-17 00:00:00 | Products | 100
2007-09-18 00:00:00 | Stationery | 20
2007-09-20 00:00:00 | Products | 10
2007-09-20 00:00:00 | Education | 125
2007-10-04 00:00:00 | Products | 25
Results:
Spreadsheet: 00c44e93-e2fd-4a89-84f9-a325683ae3fb
Sheet: Q7 TOM

TOM
n | 1.06^n | 1.02^n | 120000 | 400000 | payment
0
1
2
3
4
5
6 |  |  |  |  | FVs
7
8
9
10
11
12
 | NPV Version
year | cash flow at end of year
0 | 0
1
2 | 0
3
4 | 0
5 | 0
6
Spreadsheet: benjamin_rogers__1109__contact numbers
Sheet: Sheet1

 | M:
 |  | Genco
 |  |  | Control Areas
 |  |  |  | C_A_Reporting
 |  |  |  |  | ECAR
 |  |  |  |  |  | ENWI
 |  |  |  |  |  |  | ENWI_Compliance
 |  |  |  |  |  |  | ENWI_FERC
 |  |  |  |  |  |  | ENWI_DOE
 |  |  |  |  |  |  | ENWI_ECARnet
 |  |  |  |  |  | ENWC
 |  |  |  |  |  |  | ENWC_Compliance
 |  |  |  |  |  |  | ENWC_FERC
 |  |  |  |  |  |  | ENWC_DOE
 |  |  |  |  |  |  | ENWC_ECARnet
 |  |  |  |  | MAIN
 |  |  |  |  |  | ENLC
 |  |  |  |  |  |  | ENCL_Compliance
 |  |  |  |  |  |  | ENLC_FERC
 |  |  |  |  |  |  | ENLC_DOE
 |  |  |  |  |  |  | ENLC_MAINet
 |  |  |  |  | SERC
 |  |  |  |  |  | ENSE
 |  |  |  |  |  |  | ENSE_Compliance
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | ENSE_DOE
 |  |  |  |  |  | ENCA
 |  |  |  |  |  |  | ENCA_Compliance
 |  |  |  |  |  |  | ENCA_FERC
 |  |  |  |  |  |  | ENCA_DOE
 |  |  |  |  |  | ENNA
 |  |  |  |  |  |  | ENNA_Compliance
 |  |  |  |  |  |  | ENNA_FERC
 |  |  |  |  |  |  | ENNA_DOE
 |  |  |  |  |  | ENGL
 |  |  |  |  |  |  | ENGL_Compliance
 |  |  |  |  |  |  | ENGL_FERC
 |  |  |  |  |  |  | ENGL_DOE
Spreadsheet: 59354d1259848146-index-match-book1
Sheet: Sheet1

 | Alpha | Beta | Gamma | Delta | Epsilon
One | 6 | 5 | 7 | 4 | 0
Two | 1 | 2 | 4 | 3 | 5
Three | 5 | 4 | 0 | 7 | 8
Four | 6 | 0 | 2 | 3 | 4
Five | 6 | 4 | 5 | 0 | 9
 |  |  |  |  |  |  | Epsilon
 |  |  |  |  |  | Two | ?
 |  |  |  |  |  | Three | ?
 |  |  |  |  |  | Five | ?
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 15b

 |  | Transactions
Product |  | HY** | IG | Other
Index Tranche* | Asia |  |  | <100
 | Europe |  |  | <100
 | North America | 218 | 890 | <100
Index | Asia |  | <100 | <100
 | Europe |  |  | 4021
 | North America | 1749 | 2599 | 154
TOTAL |  | 1967 | 3489 | 4175
Estimated swap transaction volumes, week ending November 30, by product type and grade (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type as more complete data becomes available.
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 product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 845425d1696950996-calculating-time-difference-where-time-format-includes-millisecond-time
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Added "." between sec and millisec.
 | Start timestamp | end timestamp |  |  | Start-time | End-time | Difference (Secs number) |  |  | Start-time | End-time | Difference (Seconds number)
 | 08/09/2023 11:35:02:286 | 08/09/2023 11:35:02:457 |  |  | 11:35:02:286 | 11:35:02:457 |  |  |  | 11:35:02.286000 | 11:35:02.457000
 | 08/09/2023 11:35:02:547 | 08/09/2023 11:35:03:287 |  |  | 11:35:02:547 | 11:35:03:287 |  |  |  | 11:35:02.547000 | 11:35:03.287000
 | 08/09/2023 11:35:05:288 | 08/09/2023 11:35:05:890 |  |  | 11:35:05:288 | 11:35:05:890 |  |  |  | 11:35:05.288000 | 11:35:05.890000
 | 08/09/2023 11:35:06:335 | 08/09/2023 11:35:06:567 |  |  | 11:35:06:335 | 11:35:06:567 |  |  |  | 11:35:06.335000 | 11:35:06.567000
 | 08/09/2023 11:35:07:289 | [NAME] 11:39:08:120 |  |  | 11:35:07:289 | 11:39:08:120 |  |  |  | 11:35:07.289000 | 11:39:08.120000
Spreadsheet: 146414d1332173465-inserting-multiple-columns-example
Sheet: Before

A | B | C | D | E | F | G
1 | 1 | 1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3 | 3 | 3
4 | 4 | 4 | 4 | 4 | 4 | 4
Spreadsheet: 876267d1722954214-i-have-a-excel-sheet-of-finance-calculator-i-want-help-regarding-some-formula-new-calc1
Sheet: Sheet1

EASY EMI CALCULATOR
 |  | LAPTOP AMOUNT : | 30000 |  |  |  |  |  | EMI'S
 |  |  |  |  |  |  |  |  | FILE CHARGE
 |  | LOAN AMT : | 40000 |  |  |  |  |  | PROCESSING FEES
 |  | FILE CHARGE | 500 |  |  |  |  |  | LAPTOP BALANCE AMOUNT
 |  | PROCESSING | 1.8 | % |  | DOWN PAYMENT :
 |  | SCHEME | 12 | 4 |  |  |  |  |  |  |  |  | TOTAL | EXTRA
 |  |  |  |  |  |  |  |  | DOWNPAYMENT
 |  |  |  |  |  |  |  |  |  |  |  |  | Why is total amount payable
 |  |  |  |  |  |  |  |  |  |  |  |  | less than the Loan Amt?
 |  |  |  |  |  |  | AMOUNT |  | EMI's
 |  |  |  |  |  | MONTHLY EMI : |  | X |  | =
 |  | ELIGIBILITY |  |  |  | Loan Amt |  | <- Result |  |  | If required Downpayment in H21, then
 |  |  |  |  |  | Downpayment | 5000 | <- Input |  |  | Loan Amt = (H21-D7-D4)/(E9/D9+D8/100-1)
40000
Spreadsheet: 136312d1326533590-vlookup-limits-multi-year-testing-data-sheets2
Sheet: student record

 |  | PERSOPNAL TESTING RESULTS
YEAR | 2011
ID/Name | 111
 |  | spelling | maths | reading
 | Current Year
 | Previous Year
 | Improvement
 |  |  |  |  |  | 4
 |  |  |  |  |  | 2
Spreadsheet: 702580d1604420024-extract-largest-values-help_largestvalues
Sheet: Ark1

 | Total | City | Due Date | Status
 | 5000 | Dublin | 5.11.2020 | Delivered |  |  | Madrid |  |  | Madrid
 | 10 | London | 5.11.2020 |  |  | 10000 | Paris |  | 10000 | Paris
 | 10 | Paris | 6.11.2020 | Delivered |  | 55 | London |  | 55 | London
 | 10000 | Paris | 4.11.2020 |  |  |  |  |  | 10 | London
 | 55 | London | 25.11.2020
 | 25000 | Glasglow | 25.11.2020 | Delivered
 | 33000 | Madrid | 25.11.2020
Spreadsheet: 130691d1322518198-filtering-repeated-data-1-column-based-on-2nd-column-criti-satisfying-multiple-cond-advanced-filt
Sheet: Sheet1

Participant ID | Quarter # | Data 1 | Date 2
[NAME] | 1 | 45 | Yes |  |  |  | Criteria
[NAME] | 2 | 67 | No
[NAME] | 3 | 44 | Yes |  |  |  | Quarter # |  | Participant ID | Quarter # | Data 1 | Date 2
[NAME] | 4 | 55 | Yes |  |  |  | >0 |  | [NAME] | 1 | 45 | Yes
[NAME] | 1 | 55 | Yes |  |  |  | <20 |  | [NAME] | 2 | 67 | No
[NAME] | 2 | 44 | No |  |  |  |  |  | [NAME] | 3 | 44 | Yes
[NAME] | 3 | 43 | Yes |  |  |  |  |  | [NAME] | 4 | 55 | Yes
[NAME] | 4 | 66 | No |  |  |  |  |  | [NAME] | 1 | 55 | Yes
[NAME] | 5 | 67 | No |  |  |  |  |  | [NAME] | 2 | 44 | No
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 43 | Yes
 |  |  |  |  |  |  |  |  | [NAME] | 4 | 66 | No
 |  |  |  |  |  |  |  |  | [NAME] | 5 | 67 | No
Spreadsheet: 788377d1658423500-inserting-row-above-table-changes-formulas-despite-structured-references-sampleproblem
Sheet: Values

Column1 | Category A 100% | Category A 75% | Category A 50% | Category B 100% | Category B 75% | Category B 50% | Category C 100% | Category C 75% | Category D 100% | Category D 75% | Category D 50%
A01 | 1 | 1 | 1 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A02 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A03 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A04 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A05 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A06 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A07 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A08 | 3 | 3 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A09 | 4 | 4 | 4 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A10 | 5 | 5 | 6 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
Spreadsheet: 45316d1244075148-nesting-vlookup-in-if-vice-versa-and-pivot-table-sample
Sheet: Feb Summary

Model | Year-to-Date: Cat1 | Year-to-Date: Cat2 | Total YTD
500 |  |  | 0
750 |  |  | 0
900 |  |  | 0
AB |  |  | 0
AD |  |  | 0
AG |  |  | 0
AL |  |  | 0
AN |  |  | 0
BX |  |  | 0
BZ |  |  | 0
CA |  |  | 0
CB |  |  | 0
DE |  |  | 0
DF |  |  | 0
DS |  |  | 0
DV |  |  | 0
DX |  |  | 0
FA |  |  | 0
GL |  |  | 0
GM |  |  | 0
MF |  |  | 0
MR |  |  | 0
OA |  |  | 0
OB |  |  | 0
OR |  |  | 0
RA |  |  | 0
RF |  |  | 0
TM |  |  | 0
ZP |  |  | 0
Grand Total | 0 | 0 | 0
Spreadsheet: 173623d1344619271-if-and-statement-with-less-or-greater-than-samplefile
Sheet: table

Score |  |  | Deduct
0 - 72 | 0 | 72 | 0
73 - 75 | 73 | 75 | 0.5
76 - 80 | 76 | 80 | 1
81 - 85 | 81 | 85 | 1.5
86 - 90 | 86 | 90 | 2
91 - 95 | 91 | 95 | 2.5
96 - 100 | 96 | 100 | 3
101 - 104 | 101 | 104 | 3.5
105 - 109 | 105 | 109 | 4
110 - 114 | 110 | 114 | 4.5
115 - 119 | 115 | 119 | 5
120 - 124 | 120 | 124 | 5.5
125 - 129 | 125 | 129 | 6
130 - 134 | 130 | 134 | 6.5
135 - 139 | 135 | 139 | 7
140 - 144 | 140 | 144 | 7.5
145 - 149 | 145 | 149 | 8
150 - 154 | 150 | 154 | 8.5
155 - 159 | 155 | 159 | 9
Spreadsheet: 743610d1628615744-is-index-and-match-match-match-possible-help
Sheet: Sheet1

 | 320
 | 24
 | 124
 | FULL
 |  |  |  |  | Weight klb |  |  | 172 | 166 | 158 | 150 | 142 | 134 | 126 | 118 | 110 | 102 | 96
 |  |  |  |  | VLS CONF Full (kt) (=VREF) CG<25% | FULL | 0 | 150 | 147 | 144 | 140 | 136 | 132 | 128 | 124 | 120 | 116 | 112
 |  |  |  |  | VLS CONF Full (kt) (=VREF) CG>=25% | FULL | 25 | 148 | 145 | 142 | 138 | 134 | 130 | 126 | 122 | 118 | 114 | 110
 |  |  |  |  |  | 3 | 0 | 155 | 153 | 149 | 145 | 141 | 137 | 133 | 129 | 125 | 120 | 117
 |  |  |  |  |  | 3 | 25 | 153 | 151 | 147 | 143 | 139 | 135 | 131 | 127 | 123 | 118 | 115