tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 820871d1678315536-replace-maiden-name-with-married-name-s666-pq-replace-maiden-name-with-married-name
Sheet: Sheet1

Name | Sales |  |  |  | Reference List: |  | Maiden Name | Married Name
[NAME] | 2000 |  |  |  |  |  | [NAME] | [NAME]
[NAME] | 1500 |  |  |  |  |  | [NAME] | [NAME]
[NAME] | 900 |  |  |  |  |  | [NAME] | [NAME]
[NAME] | 1200
[NAME] | 3500
[NAME] | 1400
[NAME] | 1000
[NAME] | 999
[NAME] | 888
 |  |  |  | I would like excel to use reference list to either replace maiden names with married name outright:
Name | Sales
[NAME] | 2000
[NAME] | 1500
[NAME] | 900
[NAME] | 1200
[NAME] | 3500
[NAME] | 1400
[NAME] | 1000
 |  |  |  | or I could add a column for married name which excel would automatically fill:
Name | Married Name | Sales
[NAME] | [NAME] | 2000
[NAME] |  | 1500
[NAME] |  | 900
[NAME] |  | 1200
[NAME] |  | 3500
[NAME] | [NAME] | 1400
[NAME] |  | 1000
Spreadsheet: 833605d1687144680-ifs-statement-and-lookup-function-workbook-1
Sheet: Sheet 1

 | Address | Floor/Level | Rise Of Floor
 | 123 Example St | 2
 | 123 Example St | 5 |  |  |  |  |  |  |  |  |  |  |  | 7 | 10
 | 123 Example St | 8
 | 500 Test St | 10
 | 500 Test St | 15
 | Please refer to 'Building List' tab for more information
Spreadsheet: 750705d1633599973-tracking-product-storage-with-multiple-criteria-edited-storing-products-excel-help-2-
Sheet: Storing

Current results
Date | Method | Product | Quantity | Location | Out of date
 | Storing | Apple |  | Shop1 | 2021-10-05 00:00:00
 | Storing | Apple |  | Shop2 | 2021-10-11 00:00:00
 | Storing | Pear |  | Shop1 | 2021-10-12 00:00:00
 | * when you change the method on 'trade list' to "Stored" it shouldn't pull the data through - it pulls the data elsewhere (formula already correct in the real workbook)
Expected result |  |  |  |  |  |  | Notes
Date | Method | Product | Quantity | Location | Out of date
 | Storing | Apple | 150 | Shop1 | 2021-10-05 00:00:00 |  | Highlighted red as it is past or equal to todays date (means its OOD) - (would prefer it to flash but red it fine if not)
 | Storing | Apple | 10 | Shop2 | 2021-10-11 00:00:00
 | Storing | Pear | 10 | Shop1 | 2021-10-12 00:00:00
 | Storing | Apple | 19.99 | Shop1 | 2021-10-07 00:00:00 |  | Highlighted red as it is past or equal to todays date (means its OOD) - (would prefer it to flash but red it fine if not)
 | One method that half works (pulls the data but if you change the method on 'Trade List' it ignores the line so theres a gap in the data
 |  | Apple | 150 | 0 | Shop1
 | Storing | Apple | 10 | 0 | Shop2
 | Storing | Pear | 10 | 0 | Shop1
 | Storing | Apple | 19.99 | 0 | Shop1
 | [NAME] solution with CF added
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 53968774 | 170897756
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 15597227 | 52794537
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 69566001 | 223692293
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -52434095 | -164709190
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -15969881 | -53878152
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 254993 | 824533
 | Total Purchases: |  | -68148983 | -217762809
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 1556074 | 4803160
12 |  | Purchases | -620000 | -1835200
 | Total Intra CTS Sales / Purchases |  | 936074 | 2967960
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 13538 | 40389
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | -2279489 | -7163324
 | Total Imbalances: |  | -2265951 | -7122935
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 133497 | 391047
18 |  | W/D (Purchase from Stg) | -255631 | -766023
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -255631 | -766023
 | Total Storage: |  | -122134 | -374976
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 34993 | 100677.4856741938
 |  |  | 0 | 0
23 | Fuel: |  | -254993 | -824533
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -479753.5961600007
25 |  | Demand | 0 | -943950.55
 | Total Transport Expense: |  | 0 | -1423704.146160001
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 35422067.8316
31 |  | Prior Month Book Balance | 0 | -9181117
 |  | Total MTM Income | 0 | 26240950.8316
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -2298863
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -58864
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -704864
 |  | TOTAL INTRA-MTH
FT-West
 |  | Current Month MTM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 543905d1508664747-powerpivot-not-working-as-intended-question
Sheet: PIVOT (mock-up)

MOCK-UP: Results I was expecting to see in the PIVOT tab:
 | Count of Consultant Name
 | Building ID | Building Name | Team ID | Team Name | Consultant ID | Consultant Name | Total
 | BID001 | Eagle | TID001 | Blue | CID001 | [NAME] | 1
 |  |  |  |  | CID003 | [NAME] | 1
 |  |  |  |  | CID012 | Satan | 1
 |  |  |  |  | CID013 | Cock | 1
 |  |  |  |  | CID015 | [NAME] | 1
 |  |  | TID003 | Yellow | CID009 | Rose | 1
 |  |  |  |  | CID010 | [NAME] | 1
 |  |  |  |  | CID014 | [NAME] | 1
 | [NAME] | Hawk | TID001 | Blue | CID001 | [NAME] | 1
 |  |  |  |  | CID003 | [NAME] | 1
 |  |  |  |  | CID012 | Satan | 1
 |  |  |  |  | CID013 | Cock | 1
 |  |  |  |  | CID015 | [NAME] | 1
 |  |  | TID002 | Red | CID002 | [NAME] | 1
 |  |  |  |  | CID008 | [NAME] | 1
 |  |  |  |  | CID011 | [NAME] | 1
 | BID003 | Vulture | TID001 | Blue | CID001 | [NAME] | 1
 |  |  |  |  | CID003 | [NAME] | 1
 |  |  |  |  | CID012 | Satan | 1
 |  |  |  |  | CID013 | Cock | 1
 |  |  |  |  | CID015 | [NAME] | 1
 |  |  | TID002 | Red | CID002 | [NAME] | 1
 |  |  |  |  | CID008 | [NAME] | 1
 |  |  |  |  | CID011 | [NAME] | 1
 |  |  | TID003 | Yellow | CID009 | Rose | 1
 |  |  |  |  | CID010 | [NAME] | 1
 |  |  |  |  | CID014 | [NAME] | 1
 | Grand Total |  |  |  |  |  | 11
Spreadsheet: 676668d1588925046-how-to-get-data-based-on-date-criteria-excel-solution-miranti-
Sheet: 1 ORI FUNC

SOLUTION FUNCTION
Periode :
TYPE | START DATE | FINISH DATE
A | 2020-03-16 00:00:00 | 2020-03-23 00:00:00
B | 2020-03-16 00:00:00 | 2020-03-23 00:00:00
C | 2020-03-17 00:00:00 | 2020-03-24 00:00:00
D | 2020-03-17 00:00:00 | 2020-03-24 00:00:00
F | 2020-03-17 00:00:00 | 2020-03-24 00:00:00
G | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
H | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
I | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
J | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
K | 2020-03-19 00:00:00 | 2020-03-26 00:00:00
L | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
M | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
N | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
O | 2020-03-20 00:00:00 | 2020-03-27 00:00:00
P | 2020-03-23 00:00:00 | 2020-03-30 00:00:00
Q | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
R | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
S | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
T | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
U | 2020-03-24 00:00:00 | 2020-03-31 00:00:00
V | 2020-03-25 00:00:00 | 2020-04-01 00:00:00
W | 2020-03-25 00:00:00 | 2020-04-01 00:00:00
X | 2020-03-26 00:00:00 | 2020-04-02 00:00:00
Y | 2020-03-26 00:00:00 | 2020-04-02 00:00:00
Z | 2020-03-27 00:00:00 | 2020-04-03 00:00:00
AA | 2020-03-27 00:00:00 | 2020-04-03 00:00:00
AB | 2020-03-27 00:00:00 | 2020-04-03 00:00:00
AC | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AD | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AE | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AF | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AG | 2020-03-30 00:00:00 | 2020-04-06 00:00:00
AH | 2020-03-31 00:00:00 | 2020-04-07 00:00:00
AI | 2020-03-31 00:00:00 | 2020-04-07 00:00:00
AJ | 2020-03-31 00:00:00 | 2020-04-07 00:00:00
AK | 2020-04-01 00:00:00 | 2020-04-08 00:00:00
AL | 2020-04-01 00:00:00 | 2020-04-08 00:00:00
AM | 2020-04-01 00:00:00 | 2020-04-08 00:00:00
AN | 2020-04-02 00:00:00 | 2020-04-09 00:00:00
AO | 2020-04-02 00:00:00 | 2020-04-09 00:00:00
AP | 2020-04-02 00:00:00 | 2020-04-09 00:00:00
AQ | 2020-04-06 00:00:00 | 2020-04-13 00:00:00
AR | 2020-04-07 00:00:00 | 2020-04-14 00:00:00
AS | 2020-04-07 00:00:00 | 2020-04-14 00:00:00
AT | 2020-04-07 00:00:00 | 2020-04-14 00:00:00
AU | 2020-04-08 00:00:00 | 2020-04-15 00:00:00
AV | 2020-04-08 00:00:00 | 2020-04-15 00:00:00
AW | 2020-04-08 00:00:00 | 2020-04-15 00:00:00
AX | 2020-04-09 00:00:00 | 2020-04-16 00:00:00
AY | 2020-04-09 00:00:00 | 2020-04-16 00:00:00
AZ | 2020-04-10 00:00:00 | 2020-04-17 00:00:00
UPDATE PRODUCTION
DATE | TYPE
Spreadsheet: 046ac9d6-574b-4b06-ba5a-82ac7fccc23d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
[NAME] [NAME] |  |  |  | [NAME] y/o Ámbito
Nº registro: [NAME]
Rellenar los campos en amarillo
Nombre y Apellidos:
Nº poliza: |  |  |  | DNI:
Marcar con una x sólo si se quieren modificar [NAME]:
Coberturas: |  |  |  | [NAME]:
 |  | Robo |  |  |  | España (+Andorra)
 |  | [NAME] |  |  |  | [NAME]
Ampliacion de equipo asegurado
[NAME] |  | [NAME] |  | Nº serie |  | Importe
Objetivos |  | [NAME] |  | Nº serie |  | Importe
Flash |  | [NAME] |  | Nº serie |  | Importe
Accesorios |  | [NAME] |  | Nº serie |  | Importe
Modificaciones de equipo asegurado
Para bajas de equipo rellenar con Importe 0
[NAME] |  | [NAME] |  | Nº serie |  | Importe
Objetivos |  | [NAME] |  | Nº serie |  | Importe
Flash |  | [NAME] |  | Nº serie |  | Importe
Accesorios |  | [NAME] |  | Nº serie |  | Importe
Nota: Para garantizar el pago en caso de robo es impresincibel adjuntar una foto con todo el equipo fotografico a asegurar y [NAME].
Spreadsheet: 145766d1331737032-compare-two-worksheet-and-insert-cust_id
Sheet: Sheet 1 (3)

CUST_ID | BLANK | CUST_ID | EMAIL_ADDRESS
9528 |  | 9894 | [EMAIL]
9894 | [EMAIL] | 10336 | [EMAIL]
14854 |  | 12509 | [EMAIL]
9035 |  | 9907 | [EMAIL]
10336 | [EMAIL] | 14000 | [EMAIL]
11970
12509 | [EMAIL]
14464
14000 | [EMAIL]
9907 | [EMAIL]
Spreadsheet: 120736d1315491246-if-value-in-column-a-respective-row-in-column-b-sign-calculator-plus3
Sheet: CALCULATOR

TO CALCULATE SQFT & ASPECT RATIO BY SIZE
 | Enter HEIGHT and WIDTH:
 | 1 | FEET | 6 | INCHES | X | 16 | FEET | 0 | INCHES |  | = |  |  | SQFT.
 | Based on dimensions above, ASPECT RATIO IS: |  |  |  |  |  |  | 1 | INCH IN HEIGHT = |  |  | INCH IN WIDTH
TO CALCULATE SQFT BY ASPECT RATIO
 | Enter WIDTH Ratio: |  |  |  | Height: | 1 | INCHES | X | [NAME]: | 7 | INCHES
 | Enter Sign HEIGHT in inches: |  |  |  | Height: | 120 | INCHES | X | [NAME]: |  | INCHES | = |  | SQFT.
 | Equivalent Size: (in feet/inches):
 |  |  | Height: |  | FEET |  | INCHES | X | [NAME]: |  | FEET |  | INCHES
TO CALCULATE SIZE BASED ON DESIRED SQFT AND ASPECT RATIO
 | Enter WIDTH Ratio: |  |  |  | Height: | 1 | INCHES | X | [NAME]: | 10 | INCHES
 | ENTER Desired SQFT: |  |  | 75
 | Size in Inches: |  | Height: |  | INCHES | X | [NAME]: |  | INCHES
 | Feet & Inches: |  | Height: |  | FEET |  | INCHES | X | [NAME]: |  | FEET |  | INCHES
TO CALCULATE VIEWER REACTION DISTANCE
 | 65 | MPH | = |  | FEET PER SECOND |  | VIEWER REACTION TIME: |  |  |  |  | SECONDS
 | ENVIRONMENT: |  |  | HIGH SPEED MULTI-LANE
 | Although most signs installations require a motorist to make the driving maneuver before the sign is passed, occassionally the maneuver can safely be made after the sign location has been passed.  In this case choose "DRIVER CAN TURN AFTER SIGN."  Simple environments are under 35 mph two to three lane; Complex environments are over 35 mph in four to five lane; and High Speed Multi-lane Environments are highways and interstates.
 | VIEWER REACTION DISTANCE:
TO CALCULATE LEGIBILITY DISTANCE
 | Enter original HEIGHT and WIDTH of ENTIRE sign:
 | 10 | FEET | 0 | INCHES | X | 10 | FEET | 0 | INCHES |  | = |  |  | SQFT.
 | Enter the original LETTER HEIGHT: |  |  |  |  | 18 | FEET | 0 | INCHES
 | Enter the font style: |  |  | [NAME] |  |  |  |  |  | Enter the speed of traffic: |  | 60 |  | MPH
 | The READABLE DISTANCE FOR MAXIMUM IMPACT for this font is: |  |  |  |  |  |  |  |  |  | FEET |  | INCHES
 | The MAXIMUM READABLE DISTANCE for this font is: |  |  |  |  |  |  |  |  |  | FEET |  | INCHES
TO REQUIRED SF TO GAIN LEGIBILITY FROM A DESIGNATED DISTANCE
 | Enter the HEIGHT and WIDTH of ENTIRE sign at 100sf:
 | 1 | FEET | 6 | INCHES | X | 16 | FEET | 0 | INCHES
 | Enter the LETTER HEIGHT at 100sf: |  |  |  |  | 1 | FEET | 0 | INCHES
 | Enter the font style: |  |  | [NAME] |  |  |  |  |  | Enter the speed of traffic: |  |  |  | MPH
 | To get the required distance of legibility of |  |  |  |  |  | 250 | FEET | your sign needs to be |  |  |  |  | SQFT.
Spreadsheet: 130262d1322144528-excel-2007-help-with-filters-copy-of-evaluation
Sheet: Evaluation

[NAME] DODAVATELE
[NAME]: | UPO 01
Položka: | výroba - OK |  |  |  |  |  |  |  | FILTERS
Dodavatel: | 4
 | body |  | body |  | body |  | váha
Nabídková cena |  |  |  |  |  |  | 35
Dodací lhůta |  |  |  |  |  |  | 35 |  | AUTOMATICALLY INSERT DATA
Platební podmínky |  |  |  |  |  |  | 20
[NAME] |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 5
VÝSLEDEK
Spreadsheet: 883138d1731617284-unique-values-and-sumif-order-_qty
Sheet: Sheet1

Ord# | Qty
81639 | 12
81640 | 1
81641 | 2
81641 | 2
81642 | 1
81644 | 2
81646 | 1
81648 | 1
81649 | 1
81650 | 2
81652 | 6
81654 | 2
81656 | 2
81657 | 19
81658 | 1
81659 | 1
81660 | 1
81660 | 19
81660 | 75
81660 | 75
Goal
81640 | 1
81642 | 1
81646 | 1
81648 | 1
81649 | 1
81658 | 1
81659 | 1
4% OF ORDERS | 50% OF SALES |  | total orders
2% OF ORDERS | 15% OF SALES
3% OF ORDERS | 11% OF SALES
7% OF ORDERS | 9% OF SALES
15% OF ORDERS | 7% OF SALES
46% OF ORDERS | 8% OF SALES
 |  |  |  | 3186 line items
Spreadsheet: d60aa4e3-04a6-4761-9fef-41e26aa65973
Sheet: Sheet1

Release: Senior Loan Officer Opinion Survey on Bank Lending Practices | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=191
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-14 11:09 PM CDT
 | Real-Time | Period
Name: | Start | End
Senior Loan Officer Opinion Survey on Bank Lending Practices | 2010-04-20 00:00:00 | Current
Link:
http://www.federalreserve.gov/boarddocs/SnLoanSurvey/ | 2010-04-20 00:00:00 | Current
Source:
Board of Governors of the Federal Reserve System | 2010-04-20 00:00:00 | Current
Notes:
For further information, please refer to the Board of Governors of the | 2010-04-20 00:00:00 | Current
Federal Reserve System's Senior Loan Officer Opinion Survey on Bank
Lending Practices release, online at
http://www.federalreserve.gov/boarddocs/SnLoanSurvey/.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-04-20 00:00:00
2010-08-16 00:00:00
2010-11-08 00:00:00
2011-01-31 00:00:00
2011-05-02 00:00:00
2011-08-15 00:00:00
2011-11-07 00:00:00
2012-01-31 00:00:00
2012-04-30 00:00:00
2012-08-06 00:00:00
2012-10-31 00:00:00
2013-02-04 00:00:00
2013-05-06 00:00:00
2013-08-05 00:00:00
2013-11-02 00:00:00
2014-02-03 00:00:00
Spreadsheet: 862633d1710306266-exclude-holidays-in-total-holiday-sample-1-3-
Sheet: Mar

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 2024-03-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 86043d1286011326-ignoring-blank-cells-in-a-chart-cash-deposits-and-orders-sample-4-
Sheet: 08-31-10

CASH ORDER
Denomination |  | 2010-08-31 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 5284100 |  | 1837000
20 |  | 3780720 |  | 878240
10 |  | 122870 | 30010 | 0
5 |  | 806790 |  | 247690
1 |  | 221118 |  | 55275
0.25 |  | 14621 | 13032 | 0 |  | 5000
0.05 |  | 5220 | 1674 | 0 |  | 2000
0.01 |  | 665 | 425 | 0 |  | 300
Total
Spreadsheet: 856349d1705608533-calendar-using-data-set-with-formulas-launch-date-calculator
Sheet: Month View Event Calendar

2024
January
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 50097
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 2415
Index Tranche | Asia | <100
 | Europe | <100
 | North America | 207
Index | Asia | 174
 | Europe | 3025
 | North America | 3699
TOTAL |  | 59617
Estimated swap transaction volumes, week ending December 7, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status 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.
**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: 869150d1715786036-schedule-formula-that-indicates-off-days-test-schedule
Sheet: MAY

INTERNS NAME |  | SUMMER SCHEDULE FOR THE MONTH OF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST |  |  |  | 2024
DATE
Enter "H" For Holiday - Enter "P" for PPED
DAY OF THE WEEK
DAFFY DUCK |  | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O
1430-2300 | off Wed & Thur
NOTES
[NAME] |  |  |  |  |  |  | O |  |  |  |  |  |  |  |  |  |  |  |  |  | O
0700-1630 | 5/4/9 1st Mon off
NOTES
[NAME] |  |  |  | O |  |  |  |  |  |  | O |  |  |  |  |  |  | O |  |  |  |  |  |  | O |  |  |  |  |  |  | O
0800-1730 | 4/10 Fri off
NOTES
BRAD PITT |  |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O
1530-2400 | off Mon & Tue
NOTES
NOTES
NOTES
NOTES
NOTES
NOTES
NOTES
Spreadsheet: 881837d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills-jot
Sheet: November

Monthly Bills Jot
From [NAME] | mortgage | 343.02
 | bills | 250.89
 | pot | 500
 | receipts | 0
 | owed | 67.71 |  |  |  |  |  | 169 |  | 1751.11
Back to jack | credit | 50 | pay off credit card |  |  |  |  | 170.57 |  | -1192.89
 |  |  |  |  |  |  |  | 17.99
 |  |  |  |  |  |  |  | lunch | 10
Mine | To Bills | 904.65 |  |  |  |  |  | water/misc | 10
 | Credit Card ex |  |  |  |  |  |  | sun lounger | 10
 | Receipts | 0 |  |  |  |  |  | evening meal | 75
 | To Pot | 0 |  |  |  |  |  |  |  | 500
 | Pay credits |  |  |  |  |  |  |  |  |  | virgin
 | Santander
 |  |  |  |  |  |  |  |  |  |  |  | 2998.83
 |  |  |  |  |  |  |  | total
 | Extra | 60
 | Car service | 100
minus |  | 150
 |  | 0
£150 leave for virgin.
Spreadsheet: 115034d1310664199-how-to-add-additional-criteria-to-a-sumif-formual-dummy
Sheet: Summary

 |  |  |  |  |  | Active & Matured |  | Information extracted from commercial tab.
 |  |  |  |  |  | ARMS & ARMS C&R |  | Information extracted from ARMS tab.
 | Active | Matured | Arms | Arms C&R |  | AL |  | Information extracted from commercial tab.
 | COUNTIF('Commercial Loans'!I3:I1200,">"&C3) | COUNTIF('Commercial Loans'!I3:I1200,"<="&C3) | COUNTIF(ARMS!C3:C600,"ARMS") | COUNTIF(ARMS!C3:C600,"ARMS C&R") |  | ARMS |  | Information extracted from commercial tab.
 |  |  |  |  |  | Officer |  | Information extracted from commercial tab.
 |  |  |  |  |  | Participation |  | Information extracted from commercial tab.
 | Alabama | ARMS | Officer | Participation | TBD | TBD |  | Information extracted from commercial tab.
 | COUNTIF('Commercial Loans'!J3:J1200,"*AL*") | COUNTIF('Commercial Loans'!J3:J1200,"ARMS") | COUNTIF('Commercial Loans'!J3:J1200, "*off*") | COUNTIF('Commercial Loans'!J3:J1200,"Part") | COUNTIF('Commercial Loans'!J3:J1200,"TBD") | *loan count is made up of loans that are 3 or more days past due
 | Total commercial loans
 | Total loans we don't collect
 |  |  |  |  |  |  | IF(E17=E28,"","LOAN COUNTS DO NOT MATCH!")
 | Total loans we collect
 | [NAME] | [NAME] | [NAME] | [NAME] | Nydia
 | COUNTIF('Commercial Loans'!J3:[NAME]") | COUNTIF('Commercial Loans'!J3:J1200,"Janie") | COUNTIF('Commercial Loans'!J3:J1200,"Marissa") | COUNTIF('Commercial Loans'!J3:J1200,"Martha") | COUNTIF('Commercial Loans'!J3:J1200,"Nydia")
 | Olivia | [NAME] | Stephen | Thelma | Yolanda
 | COUNTIF('Commercial Loans'!J3:J1200,"Olivia") | COUNTIF('Commercial Loans'!J3:J1200,"Romie") | COUNTIF('Commercial Loans'!J3:J1200,"Steve") | COUNTIF('Commercial Loans'!J3:J1200,"Thelma") | COUNTIF('Commercial Loans'!J3:[NAME]")
 | Total loans we collect |  |  | SUM(B21+C21+D21+E21+F21+B24+C24+D24+E24+F24)
 | Collector | Total amt. | Total active hit | Total matured hit | Total no. of loans | No. of active loans | No. of matured loans
 | Alabama
 | ARMS
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Nydia
 | OFF
 | Olivia
 | Participations
 | [NAME]
 | Sonia
 | [NAME]
 | TBD
 | Thelma
 | Yolo
 | Total:
Spreadsheet: 153389d1335889314-how-to-make-checkbox-and-formulas-to-work-like-autofilter-rollover-calculation
Sheet: Sheet1

Database |  |  |  |  |  |  |  |  |  | If "B" is unchecked for eg, this should be
Region | Occupation | Interest |  |  |  |  |  |  |  | the results:
A | Doctor | Music |  |  | Region | Count |  | Cell Link |  | Region | Count
A | Accountant | Sports |  |  | A | 4 |  | 1 |  | A | 4
B | Lawyer | Sports |  |  | B | 1 |  | 1 |  | B
D | Lawyer | Sports |  |  | C | 2 |  | 1 |  | C | 2
C | Doctor | Movies |  |  | D | 3 |  | 1 |  | D | 3
A | Accountant | Music
D | Doctor | Movies |  |  | Occupation |  |  |  |  | Occupation
C | Lawyer | Sports |  |  | Doctor | 4 |  | 1 |  | Doctor | 4
D | Police | Movies |  |  | Lawyer | 3 |  | 1 |  | Lawyer | 2
A | Doctor | Sports |  |  | Police | 1 |  | 1 |  | Police | 1
 |  |  |  |  | Accountant | 2 |  | 1 |  | Accountant | 2
 |  |  |  |  | Interest |  |  |  |  | Interest
 |  |  |  |  | Sports | 5 |  | 1 |  | Sports | 4
 |  |  |  |  | Music | 2 |  | 1 |  | Music | 2
 |  |  |  |  | Movies | 3 |  | 1 |  | Movies | 3