tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__16160__1_25_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 57 | 150 | 220 | 36.3 | 53.3 | 1.61 | 2002-01-25 15:08:00
 | [NAME] | 58 | 600 | 700 | 44.6 | 52.1 | 1.76 | 2002-01-25 15:08:00
 | [NAME] | 64 | 940 | 1040 | 46.1 | 51 | 1.95 | 2002-01-25 15:08:00
 | [NAME] | 65 | 1150 | 1230 | 45.2 | 48.3 | 1.91 | 2002-01-25 15:08:00
 | [NAME] | 65 | 1290 | 1390 | 43.5 | 46.9 | 1.85 | 2002-01-25 15:08:00
 | HU N2 | 65 | 1350 | 1430 | 41.3 | 43.7 | 1.74 | 2002-01-25 15:08:00
 | [NAME] | 64 | 1400 | 1500 | 39.8 | 42.7 | 1.66 | 2002-01-25 15:08:00
 | HU U2 | 62 | 1400 | 1500 | 38 | 40.8 | 1.54 | 2002-01-25 15:08:00
 | [NAME] | 59 | 1375 | 1525 | 36.9 | 41 | 1.44 | 2002-01-25 15:08:00
 | [NAME] |  |  |  | 35.9 | 39.8 | 1.36 | 2002-01-22 15:03:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: eric_saibi__9894__Ercot Prices with Oct 25
Sheet: Oct 25

Time | North | South | West
15 | 5.18 | 5.18 | 5.18
30 | 1.6 | 1.6 | 1.6
45 | 1.9 | 1.9 | 1.9
100 | 2 | 2 | 2
115 | 1.8 | 1.8 | 1.8
130 | 2 | 2 | 2
145 | 6.24 | 6.24 | 6.24
200 | 6.53 | 6.53 | 6.53
215 | 3.9 | 3.9 | 3.9
230 | 4.6 | 4.6 | 4.6
245 | 4.4 | 4.4 | 4.4
300 | 3.7 | 3.7 | 3.7
315 | 1.9 | 1.9 | 1.9
330 | 1.9 | 1.9 | 1.9
345 | 1.9 | 1.9 | 1.9
400 | 1.84 | 1.84 | 1.84
415 | 6.5 | 6.5 | 6.5
430 | 6.3 | 6.3 | 6.3
445 | 7.5 | 7.5 | 7.5
500 | 6.2 | 6.2 | 6.2
515 | 5.7 | 5.7 | 5.7
530 | 5.2 | 5.2 | 5.2
545 | 7.4 | 7.4 | 7.4
600 | 1.9 | 1.9 | 1.9
615 | 1 | 1 | 1
630 | 1.6 | 1.6 | 1.6
645 | 1.9 | 1.9 | 1.9
700 | 9 | 9 | 9
715 | 9.1 | 9.1 | 9.1
730 | 9.05 | 9.05 | 9.05
745 | 9.29 | 9.29 | 9.29
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 1

 | December 27 | January 3 | January 10 | January 17 | January 24
Total Interest Rate* | 367274928 | 342535726 | 345289146 | 342354081 | 329761154
Cleared** | 223388590 | 199536842 | 202604498 | 202151426 | 193525112
Uncleared | 143886338 | 142998884 | 142684648 | 140202655 | 136236042
Total Cross-Currency | 14137477 | 14341303 | 14384232 | 14188171 | 16888898
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 14137477 | 14341303 | 14384232 | 14188171 | 16888898
Total Credit | 8580339 | 8561452 | 8794206 | 8700274 | 8179491
Cleared | 2032736 | 2018663 | 2036194 | 2004391 | 2108766
Uncleared | 6547603 | 6542789 | 6758012 | 6695883 | 6070725
Total FX**** | 31450000 | 31450000 | 31450000 | 31450000 | 31450000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity**** | 4420000 | 4420000 | 4420000 | 4420000 | 4420000
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**** | 1700000 | 1700000 | 1700000 | 1700000 | 1700000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 427562744 | 403008481 | 406037584 | 402812526 | 392399543
Weekly snapshot, gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. For cleared swaps, this table reflects only one of the two swaps that results from the clearing process; therefore, the numbers on this table are analogous to the notional value of futures open interest.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
****These numbers are estimates.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 130588d1322477280-vlookup-december
Sheet: 20

 |  |  |  | 2011-12-20 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 46511d1245346014-help-sum-of-a-range-based-on-two-variables-checkbook
Sheet: Sheet1

 | Type of Transaction | Check Number | Date | Description of Transaction | Payment/Debit | Deposit/Credit | Balance
 | Initial Balance |  |  | Initial Balance |  |  | 400
 | Credit Card |  | 2009-12-04 00:00:00 | Bought food | 37
 | Check | 125 | 2009-12-05 00:00:00 | Bought supplies | 127 |  |  |  | Monthly Calculator
 | Deposit |  | 2009-12-06 00:00:00 |  |  | 1000 |  |  | Enter Beginning Date: |  |  | 2009-12-05 00:00:00
 | Check | 126 | 2009-12-07 00:00:00 |  | 200 |  |  |  | Enter End Date: |  |  | 2010-02-12 00:00:00
 | Card |  | 2009-12-08 00:00:00 |  | 150
 | Check | 127 | 2009-12-09 00:00:00 |  | 94 |  |  |  | Beginning Balance
 | Check | 128 | 2009-12-10 00:00:00 | Cheesecake | 1250 |  |  |  | Deposits |  |  |  |  | Should Equal:
 | Check | 129 | 2009-12-11 00:00:00 |  | 17.55 |  |  |  | Payments
 | Check | 130 | 2009-12-12 00:00:00 |  | 19.5 |  |  |  | Concluding Balance
 | Deposit |  | 2010-01-12 00:00:00 |  |  | 500
 | Deposit |  | 2010-02-12 00:00:00 |  |  | 1000 |  |  | Transaction Lookup
 | Check | 131 | 2010-02-13 00:00:00 | Supplies | 25 |  |  |  | Enter Date: |  |  | 2009-12-05 00:00:00
 |  |  |  |  |  |  |  |  | Enter Check Number:
 |  |  |  |  |  |  |  |  | Type of Transaction
 |  |  |  |  |  |  |  |  | Check Number
 |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  |  |  | Description of Transaction
 |  |  |  |  |  |  |  |  | Payment/Debit
 |  |  |  |  |  |  |  |  | Deposit/Credit
 |  |  |  |  |  |  |  |  | Balance
Spreadsheet: 539949d1506442943-sumif-formula-giving-me-a-bit-of-trouble-team-member-variance-log
Sheet: SEPT 2017

 | CAGE | [NAME] | [NAME] | Total
FRI | 2017-09-01 00:00:00 |  | 55 |  | No Points LB
SAT |  | 5
SUN
MON
TUE |  |  | 5
WED
THU |  | 1
FRI
SAT |  | 1
SUN
MON
TUE
WED
THU
FRI
SAT
SUN |  | -10 |  |  | No Points LB
MON
TUE
WED
THU |  | 3
FRI
SAT
SUN
MON
TUE
WED
THU
FRI
SAT
Total
 | Points
Spreadsheet: 05385462-5240-41e7-9d58-c8963fa9a894
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 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), 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 | A2413770V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 97519d1296670260-wondered-if-someone-could-give-me-some-advice-excel-2007-program-clydesdale-bank-scottish-premier-league-fixtures-results-and-league-table-season-2010-2011
Sheet: Team Setup

Number of Clubs | 12 |  | No | Club Name
 |  |  | 1 | Aberdeen | [NAME]
 |  |  | 2 | Celtic | Celtic Park
 |  |  | 3 | Dundee Utd | Tannadice Park
 |  |  | 4 | [NAME] | New Douglas Park
 |  |  | 5 | Hearts | Tynecastle
 |  |  | 6 | Hibernian | Easter Road
 |  |  | 7 | Inverness CT | Caledonian Stadium
 |  |  | 8 | Kilmarnock | Rugby Park
 |  |  | 9 | Motherwell | Fir Park
 |  |  | 10 | Rangers | Ibrox Stadium
 |  |  | 11 | [NAME] | McDiarmid Park
 |  |  | 12 | [NAME] | [NAME]
Spreadsheet: 67582d1268159900-adding-value-of-cells-but-cell-determined-by-dropdown-list-test-1
Sheet: March

Ordered | Name
1 | Book 1
 | Book 2
 | Book 3
2 | Book 4
 | Book 5
 | Book 6
3 | Book 7
 | Book 8
 | Book 9
4 | Book 10
 | Book 11
 | Book 12
5 | Book 13
 | Book 14
6 | Book 15
 | Book 16
 | Book 17
7 | Book 18
 | Book 19
 | Book 20
Spreadsheet: mark_taylor__24663__HL&P
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER:
COUNTERPARTY: | Houston Lighting & Power Co. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating | A-
STRUCTURE | COUNTERPARTY | ECT
GUARANTOR (RATING) |  | Enron Corp
LIMIT $ MILLIONS |  | 15
Incorporation State |  | OR
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings
 | 10 | 10
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor
Debt Ratings Change | X | X | Tied to EnronCorp
-Below = S&P/Moody's | BBB- | BBB- | Tied to Houston Industries Inc.
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-Cash Flow/CMLTD
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 50 | 50 | Enron Corp/ Houston Industries
-Guarantor ($[NAME]) | 50 | 50
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS: | Please note that HL&P has debt ratings for mortgage bonds which are secured. That is why we tie to parent
 | Houston Industries debt
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | X3-3263
Spreadsheet: 824385d1680535937-search-a-text-for-a-array-of-values-data
Sheet: Sheet1

Text | Found
1. [NAME] (R42520)
2. Supply and Demand Inquiry (P4021)
3. [NAME] (R42520) from Customer Service Inquiry
4. [NAME] (R42750)
5. Online Invoice Inquiry (P42230)
1. Ship(R45100A) |  | This is incorrect. it should come as R45100A, but its showing R45100(as this also exist in list)
1. Ship and Debit (R45101)
3. text (R41567)
1.XYZ(R420101)
1.Debit (R45101)
some rpeort(R42356)
Spreadsheet: 694487d1599643211-how-to-count-repeating-purchase-from-different-year-testrpt-1-
Sheet: 2018

No | Name | Product | previous order
1 | Adam | [NAME]
2 | [NAME] | USB
3 | [NAME] | PS4
4 | Thor | [NAME]
5 | Thor | KEYBOARD
6 | Adam | [NAME]
7 | [NAME] | KEYBOARD
8 | Dude | KEYBOARD
9 | Duke | [NAME]
10 | Broly | HEADPHONE
Spreadsheet: 165214d1341095856-i-need-to-calculate-a-fixed-percentage-of-closed-to-total-orders-use-solver
Sheet: Sheet1

1000 | 0 |  | 0.915
915 | 0
 |  |  | result
 |  |  | 0
 |  |  |  |  | use solver
 |  |  |  |  | set target cell | d1
 |  |  |  |  | to value of | 0.92
 |  | ** |  |  | by changing | B1:B2
 |  |  |  |  | constraints | b1=b2 | b1=int | b2=int | B1:B2>0
Spreadsheet: dbd27383-ca01-4c6a-ae50-d1f3ed9734d2
Sheet: Sheet1

[NAME] the Lakota Area A... (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/25/2013 11:44:46 AM
Precincts Reporting: 505/505 - Total Ballots Cast: 102066
2010 Primary Election - OFFICIAL RESULTS
Precinct | Yes | No | TOTALS
Precinct 01 | 152 | 65 | 217
TOTAL | 152 | 65 | 217
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 62064d1262960360-sum-problem-book1
Sheet: Sheet1

 | Part Code | Cost
 | gw40586 | 0.9
 | gw40426 | 1.25
 | dx45869 | 0.5
 | mv45628 | 4.59
 | dx45869 | 5.02
 | dx45215 | 1.99
 | dx32326 | 4.1
 | mv12536 | 3.65
 | mv48562 | 8.1
 | mv45625 | 5.25
 | mv45823 | 1.45
 | dx88965 | 7.25
 | dx48775 | 3.65
 | dx54538 | 5.62
 | Total - dx & mv codes
 | All the above part numbers are constructed with two letters (either gw, mv or dx) followed by 5 various numbers.
 | I am looking for the total cost of all the dx and mv part codes
 | CHEERS for the help
Spreadsheet: 108563d1305614174-min-max-medium-if-inspection-report
Sheet: Function

 | MIN | MAX | MEDIUM | MEDIAN | TYPEVALUE
ABB
AKA
ALB
ALV
ASU
AXB
BAH
BAM
BEH
BJH
BLB
BLU
BMP
BRÄ
DAS
DUV
ENG
FAR
FAS
FHP
FIJ
FRÄ
GAS
GLB
GUP
GUÄ
GÄR
HAB
HAG
HJU
HLU
HOT
HSÅ
HUB
HUV
HYÖ
HÄG
HÄS
HÖD
HÖT
HÖÄ
ILT
JOL
KAP
KIS
KRB
KTG
KÄT
LIH
MAS
MBP
MIK
MRT
MÄH
MÖR
NOR
NÄR
ODP
RIB
RIS
RMG
ROS
RÅC
RÅG
RÅH
SAB
SBG
SEP
SHA
SKB
SKH
SKT
SKY
SLU
SMO
SNK
SOC
SOP
STB
STD
SVM
SÄT
TAK
TCE
TEH
TEN
TFP
THP
UNT
VBY
VRE
VÅB
VÅG
VÄS
VÄT
ZID
ÅKH
ÄBP
ÖBG
ÖMT
Spreadsheet: 774121d1648221104-identify-records-with-specific-condition-makaveeti-aligw
Sheet: Sheet1

ID | Code | Status | Logins | Expected | [NAME]
253071690049 | Blue | Active | 2
566369030103 | Green | Active | 0
566369030103 | Blue | Active | 0
566369030103 | Orange | Inactive | 0
566369030103 | Purple | Active | 16
560122395105 | Blue | Active | 0
560122395105 | Green | Active | 0
560122395105 | Purple | Active | 7
560122395105 | Orange | Active | 2
558415928107 | Pink | Active | 0 | Never
558415928107 | Turquoise | Active | 0 | Never
558415928107 | Bergundy | Active | 0 | Never
558415928107 | Red | Active | 0 | Never
558415928107 | None | Active | 0 | Never
558415928107 | White | Active | 0 | Never
558415928107 | Blue | Active | 0 | Never
558415928107 | Black | Active | 0 | Never
558415928107 | Grey | Active | 0 | Never
579036465109 | Duck | Active | 1
579036465109 | Red | Active | 334
766862153562 | Green | Active | 0 | Never
Spreadsheet: 266418d1379607859-how-to-lookup-values-on-a-table-and-get-column-headers-for-filtered-criteria-partsmodel-concatenation
Sheet: Sheet1

DESIRED OUTPUT |  |  | In need of the ability to look up the part on the PARTSMODELS table
part | model |  | for options in the MODELS FILTER only:
76532 | C227E |  | If there is a >0 value in the part/model matrix, then put model values under model column
128817 | C232 |  | otherwise, leave blank
128819 | C232 C227E
 |  |  | note: there are 91 columns and 2500 rows in the complete PARTSMODELS table
 |  |  | note: the models filter helps us know what parts go with only a certain selection of models
 |  |  | note: some of the parts could go on all 91 models, so we use the models filter
 | PARTSMODELS |  |  |  |  |  |  |  |  | MODELS FILTER
 | model |  |  |  |  |  |  |  |  | C232
part | C227 | C227 NR | C227 T4B | C227E | C232 | C232 NR | C232 T4A |  |  | C227E
76344 | 1 | 1 | 1 | 1 | 1 | 1 | 1
76347 | 1 | 1 | 1 | 1 | 1
76350 | 2 | 2 | 2 | 2 | 2 | 2 | 2
76532 | 1 | 1 | 1 | 1
84570 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | Parts
86071 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |  |  | 76532
86526 |  |  |  |  | 1 | 1 | 1 |  |  | 128817
100197 |  |  |  |  | 1 | 1 | 1 |  |  | 128819
128817 |  |  |  |  | 1
128819 | 1 | 1 | 1 | 1 | 1 | 1 | 1
144124
Spreadsheet: 90653d1290444000-count-a-number-of-times-a-string-appears-but-display-the-number-sequence-number-sequence
Sheet: Sheet1

A | A 9
A | A 8
A | A 7
B | B 7
A | A 6
C | C 1
D | D 3
D | D 2
D | D 1
A | A 5
A | A 4
A | A 3
A | A 2
A | A 1
B | B 6
B | B 5
B | B 4
B | B 3
B | B 2
B | B 1
Spreadsheet: sara_shackleton__37291__ISDA Master Swap Agreement Sheet
Sheet: Sheet1

ISDA Master Swap Agreement Worksheet
 |  | ATTORNEY: | [NAME], x35620
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | Tillamook People's Utility District | CONTACT: | [NAME]
ADDRESS: | 1115 Pacific Avenue | TITLE:
 | [NAME] 433 | PHONE: | (503) 815-8650
 | Tillamook, Oregon 97141-0433 | FAX: | (503) 842-4161
Incorporation State |  | S&P | A- (SPUR)
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp. (Baa1)
LIMIT $ Actual |  | 10000000
Incorporation State |  | OR
COLLATERAL  THRESHOLD | 500000 | 10000000
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change | *See Comments | Senior, Unsecured | *Standard & Poor Underlying Rating
-Below = S&P/Moody's | BBB- | BBB- | (SPUR) below BBB- or is not rated.
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth
-EBITDA/Interest | 1.5x
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty | 5000000
-Guarantor |  | 100000000
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO: x
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
ISDA qualified:  FY'99 net worth of $25,989M and revenues of $20,758MM.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-7712
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: Chase

 | Janurary |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense | Income | Expense
 | Chase
 | Month | Day | Transactions | Category | Description | Subcategory | Amount
Spreadsheet: 191568d1352145306-sorting-out-duplicates-and-placing-only-the-unique-numbers-workbook117
Sheet: Sheet1

-0.5179153094462541
0.3843648208469055
1.286644951140065
0.3192182410423452
1.498371335504886
0.5146579804560261
0.3680781758957654
0.3517915309446256
-0.6156351791530945
-0.7459283387622149
1.286644951140065 |  |  |  |  |  |  |  |  | standalone formula
0.3355048859934853
0.3029315960912053
0.3680781758957654
-0.7947882736156351
0.2214983713355048
0.1726384364820845
-1.680781758957655
-0.5179153094462541
-0.4039087947882736
 |  |  | two decimal places
Spreadsheet: 819014d1677172936-calculate-difference-between-2-datetimes-in-hours-excluding-weekends-and-holidays-working-hours-assignment
Sheet: Sheet1

Requested | Solved | Hours Difference |  |  | Holidays |  | Shift Start Time | Shift End Time |  | Working Days
2022-08-01 14:54:00 | 2022-09-02 17:13:00 |  |  |  | 2022-08-27 00:00:00 |  | 10:00:00 | 19:00:00 |  | Monday to Friday
2022-08-19 09:43:00 | 2022-09-15 22:02:00 |  |  |  | 2022-08-25 00:00:00
2022-08-19 17:34:00 | 2022-09-01 15:06:00
2022-08-23 14:48:00 | 2022-08-31 17:03:00
2022-08-23 19:52:00 | 2022-09-15 22:01:00
2022-08-24 04:46:00 | 2022-09-14 22:45:00
2022-08-24 17:02:00 | 2022-09-02 17:31:00
2022-08-25 22:19:00 | 2022-08-30 13:21:00
2022-08-26 22:36:00 | 2022-08-31 16:23:00 |  |  |  |  | Question:- | I have 2 columns, one is for Requested and another is for Requested (column A) and another is for Solved (Column B). I want difference between solved and requested column in hours. Below are the conditions to calculate this. 1) [NAME] should exclude Saturday & Sundays as those are non-working days for us. 2) [NAME] should exclude Holiday list as shown in column F. 3) [NAME] should consider shift timing as working day instead of default 24 hours. 4) Shift timing can change anytime so that I puted it differently in cell H1 & I1 respectivly.
2022-08-26 23:46:00 | 2022-08-31 14:23:00
2022-08-27 01:22:00 | 2022-08-29 22:02:00
2022-08-27 01:28:00 | 2022-08-30 20:48:00
2022-08-27 01:31:00 | 2022-08-29 22:02:00
2022-08-27 01:34:00 | 2022-08-29 22:03:00
2022-08-27 01:38:00 | 2022-08-29 18:57:00
2022-12-26 22:48:00
2022-12-27 01:56:00 | 2022-12-29 13:01:00
2022-12-27 12:57:00 | 2022-12-28 20:30:00
2022-12-27 15:17:00 | 2022-12-27 18:38:00
2022-12-27 20:05:00 | 2022-12-28 13:14:00
2022-12-27 20:17:00 | 2022-12-28 14:46:00
2022-12-28 00:20:00 | 2022-12-28 13:24:00
2022-12-28 18:47:00 | 2022-12-28 19:13:00
2022-12-28 21:33:00 | 2022-12-28 21:56:00
2022-12-28 22:04:00 | 2022-12-28 22:12:00
Spreadsheet: 127909d1320679293-excel-2007-adding-negative-numbers-help
Sheet: Sheet1

 | Gains | Losses | [NAME] gain | [NAME] loss | AA | BB
-12.4
-1.48
13.94
4.44
19.44
-23.1
-25.5
2.01
-5.05
-51.2
-12.2
-39.3
5.62
-8.24
-6.38
-45.6
23.47
5.7
10.49
-13.2
-2.91
14.75
-12.5
-69.4
64.59
-32.8
26.88
-17.4
-14
10.45
-34.6
-67.7
-10.5
-17.9
3.7
-38.1
6.45
10.28
5.13
-10.7
-82.7
-50.4
-17.1
-30.9
-0.75
0
0
16.19
-13.9
-1.82
-52.6
36.17
-22.5
-11.9
17.14
-33.7
-31
-38
-23.8
-23.4
-70.9
-30.6
-23.2
-35.3
33.9
-7.02
56.36
-3.61
28.81
64.49
21.13
31.53
-16.3
15.49
-3.37
7.32
41.09
20.34
86.34
25.22
60.47
-18.4
-9.68
-20
-19.1
-15.4
-12.5
-36.6
42.03
-5.88
81.54
-10.7
-24.4
-1.85
10.64
-22.7
-5.66
-53.3
-60
-53.3
36.84
-3.85
-16.6
-44.1
-40
57.14
48.72
-47.6
-49.4
-18.1
-61
41.67
79.08
4.21
56.8
-39.7
-17.3
19.54
15.56
57.14
83.6
11.5
-32.3
26.76
-18.7
-28.1
30.3
-11.8
-29.2
-30.9
-39.3
-14
-39.1
-23
-19
-2.56
5.41
7.14
64.44
-38.4
-11.1
-44
-28.9
18.03
42.48
-44.6
-9.68
-64.9
-76.2
-45.4
-48.1
-75.3
-3.88
-74.6
62.32
-10.6
-62.7
16
57.33
2.44
-75.6
-64.1
-34.1
-62.6
-68.1
-46.3
-26.9
-33.3
-70
-67.9
-63.7
-44.2
-41.4
5.71
-57.6
19.35
43.33
-10.8
8.47
2.92
-75.7
-33.3
-43.2
-7.59
13.11
38.18
4.55
-2.04
-78.2
12.9
32.61
6.98
-9.43
23.08
-35.2
-56.4
-50
-6.67
-15.2
31.31
-37
-8.82
14.71
43.21
57.89
44.31
11.81
-16.6
50
24.32
-11.4
-15.6
20
37.04
-10.3
-8.57
-100
-44.4
-23.8
52.63
-47.8
-40.6
-37.5
-14.2
-27.8
-30.6
95.9
-29.6
-83.4
19.86
-34.2
4.43
34.83
5.17
8.11
-11.5
4.35
-18.3
-15.2
29.67
0.6
32.74
-3.6
53.25
49.51
-30.6
-13.5
-36.2
13.94
-16.1
43.55
4.58
6.82
39.13
50
37.37
18.68
11.39
43.14
-42.8
3.23
-22.6
-46
17
0.75
3.11
-22.7
43.93
28.68
-6.15
-22
31.85
22.76
-11.4
33.33
-10.4
-32.4
27.59
3.03
31.33
10.26
-64.8
19.35
-9.26
-22.5
-10
1.49
-18.3
5.41
-9.28
25
-72.2
16.76
5.11
39.2
45.78
21.79
51.79
37.37
20.25
66.87
21.13
8.77
35.06
19.27
-58.2
-34.2
6.98
-8.53
-19
1.75
-16.4
49.21
33.33
47.25
12.75
60
-46.2
-41.6
-48.7
-10.1
-33.9
25.42
6.54
2.56
32.33
-5.45
15
-10.2
-70.5
24.03
53.01
19.35
-12.2
-19
-30.9
12.68
-18.6
10.05
36.07
-57.3
2.54
35.71
89.32
-12.3
-6.67
5.88
55.41
-54.7
44.5
13.04
32.74
3.03
45.37
-37.3
-13.3
-43.6
-39.7
-7.02
-37.9
-41.3
-51.3
-51
-27.3
-4.69
8.54
10.53
32.58
-35.4
-3.35
-25.6
8.85
-11
-12