tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861336d1709222437-formula-to-calculate-stepped-charges-stepped-charges-problem
Sheet: Problem

STEPPED | Start | End | Percentage | Value £ | Platform charge £ | Platform charge %
 | 0 | 149999.99 | 0.003 | 25000
 | 150000 | 999999.99 | 0.0025 | 50000
 | 1000000 | 2499999.99 | 0.002 | 75000
 | 2500000 | 5000000 | 0.0015 | 100000
 | 5000000 | 10000000 | 0.001 | 125000
 |  |  |  | 150000
 |  |  |  | 175000
 |  |  |  | 200000
 |  |  |  | 225000
 |  |  |  | 250000
 |  |  |  | 275000
 |  |  |  | 300000
 |  |  |  | 325000
 |  |  |  | 350000
 |  |  |  | 375000
 |  |  |  | 400000
 |  |  |  | 425000
 |  |  |  | 450000
 |  |  |  | 475000
 |  |  |  | 500000
 |  |  |  | 525000
 |  |  |  | 550000
 |  |  |  | 575000
 |  |  |  | 600000
 |  |  |  | 625000
 |  |  |  | 650000
 |  |  |  | 675000
 |  |  |  | 700000
 |  |  |  | 725000
 |  |  |  | 750000
 |  |  |  | 775000
 |  |  |  | 800000
 |  |  |  | 825000
 |  |  |  | 850000
 |  |  |  | 875000
 |  |  |  | 900000
 |  |  |  | 925000
 |  |  |  | 950000
 |  |  |  | 975000
 |  |  |  | 1000000
Spreadsheet: 9d2cd9cf-d7c8-4c2e-a20f-427b19637e83
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
64270DO013_2012 Producer Price Indexes Weighting Patterns, 2012
Released at 11:30 am (Canberra time) Fri 2 Nov 2012
Weighting Patterns for Output of the Manufacturing Industries, Australia
 | Contents
 | Tables
 | 1 | Manufacturing division
 | 2 | 11 Food product manufacturing
 | 3 | 12 Beverage and tobacco product manufacturing
 | 4 | 13 Textile, leather, clothing and footwear manufacturing
 | 5 | 14 Wood product manufacturing
 | 6 | 15 Pulp, paper and converted paper product manufacturing
 | 7 | 16 Printing (including the reproduction of recorded media)
 | 8 | 17 Petroleum and coal product manufacturing
 | 9 | 18 Basic chemical and chemical product manufacturing
 | 10 | 19 Polymer product and rubber product manufacturing
 | 11 | 20 Non–metallic mineral product manufacturing
 | 12 | 21 [NAME] metal and metal product manufacturing
 | 13 | 22 Fabricated metal product manufacturing
 | 14 | 23 Transport equipment manufacturing
 | 15 | 24 Machinery and equipment manufacturing
 | 16 | 25 Furniture and other manufacturing
 | More information available from the ABS website
 | Producer Price Indexes, Australia, Sep 2012
 | Summary
 | Explanatory Notes
 | Inquiries
 | For further information about these and related statistics, contact the National Information and Referral Service on 1300 135 070.
 | © Commonwealth of Australia 2012
Spreadsheet: 676990d1589130153-time-stamp-overlap-between-two-columns-and-identify-such-rows-with-yes-date-and-time-overlap-between-two-rows
Sheet: Sheet1

Asset ID | Reg No | DriverKey | Date | Start Time | Stop Time | Overlap (Yes/No)
TM00246 | 1047BA | 8D00005A09038901 | 2020-05-03 | 00:04:08 | 20:15:49
PK01022 | 1091WA | 0E00001654BBD701 | 2020-05-03 | 13:34:50 | 14:36:42
PK00220 | 1103DK | 3800001B6CF1CB01 | 2020-05-03 | 17:10:19 | 17:21:36
[NAME] | 1113BK | EA00005A06065C01 | 2020-05-03 | 06:04:12 | 15:38:38
PM00055 | 1124MK | 8000005A09099C01 | 2020-05-03 | 04:00:00 | 04:00:00
TP00291 | 1139YM | BA000012C1322701 | 2020-05-03 | 06:13:21 | 06:13:34
TP00252 | 1144YM | C300005A0907C601 | 2020-05-03 | 03:59:23 | 18:05:34
TP00252 | 1144YM | 3000005A09043C01 | 2020-05-03 | 14:46:26 | 18:01:30
PK00188 | 1158DS | 8F00005A09039A01 | 2020-05-03 | 17:58:47 | 23:46:37
PK00188 | 1158DS | 5E00005A09037101 | 2020-05-03 | 16:53:50 | 17:21:27
PK00188 | 1158DS | 9900005A09075301 | 2020-05-03 | 09:37:42 | 15:22:25
PK00188 | 1158DS | 4500005A09022A01 | 2020-05-03 | 17:31:43 | 17:58:47
PK00188 | 1158DS | 1D00005A0903B501 | 2020-05-03 | 03:17:33 | 23:49:31
PK00188 | 1158DS | C100005A0903B101 | 2020-05-03 | 16:01:13 | 16:41:08
PK00188 | 1158DS | AE00005A09075201 | 2020-05-03 | 16:41:08 | 16:53:50
PK00188 | 1158DS | 4500005A09075701 | 2020-05-03 | [NAME] | [NAME]
PK00188 | 1158DS | 3700005A09082001 | 2020-05-03 | 02:17:28 | [NAME]
PK00188 | 1158DS | [NAME] | 2020-05-03 | 15:22:25 | 16:01:13
PK00630 | 1167YR | 2700005A03066401 | 2020-05-03 | 04:00:00 | 04:00:00
PK00689 | 1188YS | 890000165500D601 | 2020-05-03 | 04:00:00 | 04:00:00
PK00689 | 1188YS | C900001AA411E501 | 2020-05-03 | 09:11:40 | 09:31:03
PK00689 | 1188YS | 5A00001B6D5D7001 | 2020-05-03 | 13:34:00 | 13:38:47
PK00363 | 1193WK | C900001AA411E501 | 2020-05-03 | 15:04:17 | 15:12:07
PK00363 | 1193WK | 1E00001B6CE27501 | 2020-05-03 | 07:16:55 | 08:09:36
PK00363 | 1193WK | 140000164EC0D801 | 2020-05-03 | [NAME] | 07:16:55
PK00363 | 1193WK | 890000165500D601 | 2020-05-03 | 14:05:27 | 15:12:49
CR00044 | 1228B | BB00005A0908EE01 | 2020-05-03 | 22:49:55 | 23:59:59
CR00044 | 1228B | D700005A0308BD01 | 2020-05-03 | 12:50:56 | 16:04:44
FT00013 | 1232MH | 2F00005A09077301 | 2020-05-03 | 03:32:05 | 17:07:21
PM00399 | 1245WB | FA00005A0902C301 | 2020-05-03 | 05:57:50 | 20:18:08
TP00262 | 1250HA | EB00005A0901F501 | 2020-05-03 | 01:18:53 | 01:18:53
TP00262 | 1250HA | 4B00005A09025301 | 2020-05-03 | 01:18:53 | 05:27:42
TP00105 | 1255YB | 220000192A4E9D01 | 2020-05-03 | 08:23:35 | 10:44:27
TP00105 | 1255YB | 5A00001B6D5D7001 | 2020-05-03 | 08:23:15 | 16:06:29
TM00231 | 126AK | AA00005A0C022801 | 2020-05-03 | [NAME] | 16:26:29
TP00196 | 1313WB | 4B00005A09025301 | 2020-05-03 | 05:04:36 | 05:04:41
TP00196 | 1313WB | EB00005A0901F501 | 2020-05-03 | 19:45:25 | 19:54:32
TM00269 | 1320YR | 9800005A0905E401 | 2020-05-03 | 05:57:08 | 16:55:45
BS00089 | 1340DK | 8C00005A0908EF01 | 2020-05-03 | 07:26:32 | 07:26:40
BS00089 | 1340DK | FF00005A09071D01 | 2020-05-03 | 07:26:40 | 07:42:02
TM00187 | 1362MR | 8D00005A0901BB01 | 2020-05-03 | 00:00:00 | 23:59:59
Spreadsheet: 803395d1667428442-return-a-value-when-2-conditions-are-met-if-two-words-then-question
Sheet: Sheet1

 |  |  |  |  | And/Or | Production , Marketing
 |  |  |  | Production manager
 |  |  |  | Marketing director
 |  |  |  | Sales Operative
 |  |  |  | Operations manager
 |  |  |  | Human Resources
 |  |  |  | IT manager
 |  |  |  | Supply Chain and Production
 |  |  |  | Customer Service support
 |  |  |  | Marketing advisor
Spreadsheet: 869388d1715954530-schedule-formula-that-indicates-off-days-test-schedule
Sheet: MAY

INTERN'S NAME |  | SUMMER SCHEDULE FOR THE FOUR WEEKS STARTING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY |  |  |  | 13 |  | 2024
Day in cycle |  | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00
DATE
Enter "H" For Holiday - Enter "P" for PPED
DAY OF THE WEEK
DAFFY DUCK
1430-2300 | [NAME], Sun
NOTES
[NAME]
0700-1630 | 5/4/9 1st Mon off
NOTES
[NAME]
0800-1730 | 1st Fr, 3rd Fr
NOTES
BRAD PITT
1530-2400 | 1st Mon, 2nd Tue, 3rd Thur, 4th Friday
NOTES
NOTES
NOTES
NOTES
NOTES
NOTES
NOTES
Spreadsheet: 215243d1361311639-merging-spreadsheet-data-ats-example
Sheet: Purchasing

Item Code | Qty | Due Date | Comments
KI4D----RK2-X20 | 10601.00 | 04/02/13
KN02----4S2BS21 | 4316.00 | 03/07/13 | Late
KN0205004S2-S21 | 4535.00 | 03/07/13
KN04----K4DBN21 | 2092.00 | 02/27/13
KN100625K2BXNC1 | 78871.00 | 02/19/13
KN100625K2BXNC1 | 78871.00 | 03/27/13
[NAME] | 4999.00 | 03/22/13 | late
[NAME] | 4999.00 | 04/12/13
KN2416704S4X553 | 20.00 | 01/09/13
KN4A----F6---90 | 1680.00 | 03/18/13
KN4A----F6---90 | 1680.00 | 03/25/13 | Late
KN4A----F6---90 | 1680.00 | 04/01/13
KN4C----3P1C-21 | 2285.00 | 02/20/13 | Late
[NAME] | 6417.00 | 03/01/13
[NAME] | 6417.00 | 03/08/13 | Late
[NAME] | 6417.00 | 04/10/13
Spreadsheet: 808044d1670255131-excel-copy-and-paste-workbook2
Sheet: Sheet1

 | List
 | ABCD
 | [PHONE]
 | Abcd1
 | 1234, westway rd, AB
 | yzx1234
 | 123456
 | CDEF
 | [PHONE]
 | cdef2
 | 3456, east garden, VC
 | abc4321
 | 876542
 | Result needed
Spreadsheet: 57d53b2b-693e-46a4-a633-4cc2307e7fb0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-02-02 10:08:39.230000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.25 | 102.063 | 101.938 | 101.813 | 101.438
4.125 | 102.054 | 101.929 | 101.804 | 101.429 |  | Note: | Refer To Price [NAME]
4 | 101.622 | 101.497 | 101.372 | 100.997 |  |  | For all Price Adjs
3.875 | 100.84 | 100.715 | 100.59 | 99.965
3.75 | 99.976 | 99.851 | 99.726 | 99.101
3.625 | 99.101 | 98.976 | 98.851 | 98.226
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 102.048 | 101.923 | 101.798 | 101.423
3.5 | 101.708 | 101.583 | 101.458 | 101.083
3.375 | 101.177 | 101.052 | 100.927 | 100.552
3.25 | 100.546 | 100.421 | 100.296 | 99.921
3.125 | 99.655 | 99.53 | 99.405 | 98.78
3 | 99.312 | 99.187 | 99.062 | 98.437
2.875 | 98.753 | 98.628 | 98.503 | 97.878 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-16 10:08:39.230000
30 DAY | 2012-03-02 10:08:39.230000
45 DAY | 2012-03-17 10:08:39.230000
60 DAY | 2012-04-01 10:08:39.230000
90 DAY | 2012-05-01 10:08:39.230000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: ffdb6960-3eaa-42df-81ff-df5415aac0b3
Sheet: Cash Flow

 | ([NAME]) | ([NAME])
 | Current period | Prior period
 | 1 January - | 1 January -
 | 31 March 2011 | 31 March 2010
Profit for the period before tax | 752165 | 697719
Adjustments to reconcile profit before tax to cash provided
by operating activities:
Depreciation and amortisation and impairment expense | 403720 | 374369
IFRIC 12 revenue | -676 | -4104
Gain on sale of property, plant  and equipment | -10441 | -61
Foreign currency exchange income / (expense), net | 91231 | -40191
Interest expense and income, net | -3339 | -1278
Reversal of doubtful receivables | -32590 | -42659
Allowance for doubtful receivables | 72320 | 81781
Provision for employee termination benefits | 40837 | 25736
Litigation provision | -12349 | 4347
Unused vacation provision, net | 22776 | 29412
Loss on derivative financial instruments | 26500 | -
Obselete inventory provision | 370 | -4012
Other provisions | 304 | 547
Operating profit before working capital changes | 1350828 | 1121606
Net working capital changes in:
Trade receivables and other receivables | -144543 | -70642
Other current assets and inventories | 32878 | 1000
Trade payables and other payables | -160661 | -61988
Other non-current assets | -413490 | -381205
Other current liabilities and provisions | 43459 | 9523
Other non-current liabilities and provisions | 168881 | 179772
Payments of employee termination benefits | 9135 | -754
Restricted cash | -16599 | -3930
Provision payments | -1363 | --
Income taxes paid | -146033 | -150396
Net cash provided by operating activities | 721492 | 642986
Investing activities
Interest received | 51057 | 50186
Proceeds from sale of property, plant, equipment and intangible assets | 39072 | 7725
Purchases of property, plant and equipment and intangible assets | -198228 | -215137
Net cash used in  investing activities | -108099 | -157226
Cash flows from financing activities
Proceeds from bank borrowings (Note 8) | 2683087 | 4475490
Repayment of bank borrowings (Note 8) | -3217246 | -4892916
Repayment of obligations under finance leases | -1494 | -960
Interest paid | -55702 | -63292
Derivative instrument payments | -52677 | -30195
Net cash used in financing activities | -644032 | -511873
Foreign exchange differences from balance sheet | -19249 | -
Net increase / (decrease) in cash and cash equivalents | -48888 | -26113
Foreign exchange differences on cash and cash equivalents at the beginning of the year | -4248 | --
Cash and cash equivalents at the beginning of the year | 389627 | 110600
Cash and cash equivalents at the end of the period (Note 6) | 336491 | 84487
Spreadsheet: 793954d1661809971-multiple-closest-matches-with-multiple-criteria-book1-tool_fairy-
Sheet: Summary

Current - With [NAME]
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1
Staff 2
Staff 3
Staff 4
Staff 5
Staff 6
Expected - No formulas
Name | Bk1 Rot | Bk1 Act | Bk1 Dif | Bk1 [NAME] | [NAME] | Lun Act | Lun Dif | [NAME] | Bk2 Rot | Bk2 Act | Bk2 Dif | Bk2 [NAME]
Staff 1 | 10:15:00 | 10:16:00 | 1 | 11 | 12:15:00 | 12:18:00 | 3 | 30 | 14:15:00 | 14:47:00 | 32 | 8
Staff 2 | 11:45:00 | 11:50:00 | 5 | 10 | 14:15:00 | 14:19:00 | 4 | 30 | 15:45:00 | 15:49:00 | 4 | 10
Staff 3 | 10:00:00 | - | - | - | 11:45:00 | 11:47:00 | 2 | 30 | 13:45:00 | 14:02:00 | 17 | 9
Staff 4 | 10:15:00 | 10:16:00 | 1 | 10 | 12:15:00 | 12:23:00 | 8 | 30 | 13:45:00 | 13:46:00 | 1 | 10
Staff 5 | 10:00:00 | 10:02:00 | 2 | 8.999999999999968 | 11:45:00 | 11:47:00 | 2 | 30 | 13:45:00 | - | - | -
Staff 6 | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 851397d1701640484-how-to-organize-raw-data-fields-for-maximum-extrapolation-calendar
Sheet: Raw

Date | Code
2023-11-01 00:00:00 | ABC
2023-11-02 00:00:00 | REE
2023-11-03 00:00:00 | NTE
2023-11-04 00:00:00 | MQO
2023-11-05 00:00:00 | FGE
2023-11-06 00:00:00 | KWP
2023-11-07 00:00:00 | MXB
2023-11-08 00:00:00 | QMP
2023-11-09 00:00:00 | [NAME]
2023-11-10 00:00:00 | MQO
2023-11-11 00:00:00 | KPW
2023-11-12 00:00:00 | LHD
2023-11-13 00:00:00 | REE
2023-11-14 00:00:00 | REE
2023-11-15 00:00:00 | ABC
2023-11-16 00:00:00 | MPQ
2023-11-17 00:00:00 | [NAME]
2023-11-18 00:00:00 | LHD
2023-11-19 00:00:00 | IZL
2023-11-20 00:00:00 | FGC
2023-11-21 00:00:00 | MQO
2023-11-22 00:00:00 | ABC
2023-11-23 00:00:00 | RPI
2023-11-24 00:00:00 | MQP
2023-11-25 00:00:00 | LHD
2023-11-26 00:00:00 | EER
2023-11-27 00:00:00 | NTE
2023-11-28 00:00:00 | REE
2023-11-29 00:00:00 | BDI
2023-11-30 00:00:00 | ABC
Spreadsheet: 762800d1641828412-sumifs-criteria-matching-between-tables-help
Sheet: FTE

Difference in Available FTE and Required FTE
 |  | Available | Required
Role | Resource | [NAME] | [NAME] | [NAME] | FEB Rqd | [NAME] | [NAME] | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | Fred Davies | 0.4 |  | 0.4 |  | 0.4
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | Horace Rumpole | 0.8 |  | 0.7 |  | 0.7
Manager | Lotus [NAME] | 0 |  | 0 |  | 0
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Manager | [NAME] | 0.9 |  | 0.9 |  | 0.9
Manager | [NAME] | 0.45 |  | 0 |  | 0
Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Deputy Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Deputy Manager | Fred Davies | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Deputy Manager | Horace Rumpole | 0.1 |  | 0.2 |  | 0.2
Deputy Manager | Lotus [NAME] | 0.9 |  | 0.9 |  | 0.9
Deputy Manager | [NAME] | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0 |  | 0 |  | 0
Deputy Manager | [NAME] | 0.45 |  | 0 |  | 0
Deputy Manager | [NAME] | 0.45 |  | 0.45 |  | 0.45
Horse Doctor | [NAME] | 0.45 |  | 0.45 |  | 0.45
Window [NAME] | [NAME] | 0.45 |  | 0.45 |  | 0.45
Painter | [NAME] | 0.6 |  | 0.6 |  | 0.6
Painter | [NAME] | 0.1 |  | 0.1 |  | 0.1
Decorator | [NAME] | 0.3 |  | 0.3 |  | 0.3
Decorator | [NAME] | 0.3 |  | 0.3 |  | 0.3
Decorator | Emile Dunbar | 0.3 |  | 0.3 |  | 0.3
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Fisherman | [NAME] | 0.1 |  | 0.1 |  | 0.1
Grass | [NAME] | 0.05 |  | 0.05 |  | 0.05
Gladiator | [NAME] | 0.9 |  | 0.9 |  | 0.9
Gladiator | [NAME] | 0.3 |  | 0.3 |  | 0.3
Gladiator | TBC | 0.9 |  | 0.9 |  | 0.9
laundry | [NAME] | 0.1 |  | 0.1 |  | 0.1
Bagging | Nobody Inparticular | 0.1 |  | 0.1 |  | 0.1
Bagging | Isla Skye | 0.1 |  | 0.1 |  | 0.1
Bagging | [NAME] | 0.1 |  | 0.1 |  | 0.1
Bagging | [NAME] | 0.1 |  | 0.1 |  | 0.1
Files | [NAME] | 0.1 |  | 0.1 |  | 0.1
Sales | Captain [NAME] | 0.1 |  | 0.1 |  | 0.1
Sales | [NAME] | 0.1 |  | 0.1 |  | 0.1
Buyer | Ford Prefect | 0.3 |  | 0.3 |  | 0.3
Spreadsheet: 774906d1648721330-retrieve-a-value-in-another-sheet-based-on-conditions-test-dashboard-etaf
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | FAMILY NAME | ADDRESS | POST CODE | CITY | COUNTRY | [NAME] | WEBSITE | SUBSCRIPTION | LAST BILLED IN
9 | Client 9
8 | Client 8 |  |  |  |  |  |  |  |  |  |  | Yes
7 | Client 7 |  |  |  |  |  |  |  |  |  |  | No
6 | Client 6 |  |  |  |  |  |  |  |  |  |  | No
5 | Client 5 |  |  |  |  |  |  |  |  |  |  | No
4 | Client 4 |  |  |  |  |  |  |  |  |  |  | Yes
3 | Client 3 |  |  |  |  |  |  |  |  |  |  | Yes
2 | Client 2 |  |  |  |  |  |  |  |  |  |  | Yes
1 | Client 1 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  | n Cell "Clients!" N3
 |  |  |  |  | > if Cell "Clients!" A3 matches with 1 or Multiple values in "Subscriptions!" Column A
 |  |  |  |  | > discard the rows where "Subscriptions!" Column B = No
 |  |  |  |  | > select the highest value in "Subscriptions!" Column C
 |  |  |  |  | > paste that value in "Clients!" N3
 |  |  |  |  | What's behind this idea?
 |  |  |  |  | > In Clients, I want to display the latest year in which I've billed a client.
 |  |  |  |  | > In Subscriptions, we see the subscriptions plans per client ID ("CID") and I mention whether I billed them Yes/No
Spreadsheet: 87810d1287670571-how-to-calculate-when-investment-will-run-out-investment
Sheet: Sheet1

 |  |  |  |  |  | Start Balance | Monthly Income
 | Interest | 0.06 |  |  | 0 | 1000000
 | Monthy % | 0.8
 | Start Balance | 1000000
 | Inflation | 0.03
 |  | Years |  | months
Spreadsheet: 67261d1267839647-monster-formula-help-on-late-fees-late-fee-calculation
Sheet: Sheet1

 |  |  |  |  |  | Days to | Interest Charge
Customer ID | Customer | Invoice/CM # | Amount Due | Inv Date | Due Date | 2009-12-31 00:00:00 | 0.08
211 | Jones | 14562 | 490 | 2008-07-01 00:00:00
211 | Jones | [NAME] | 19 | 2008-07-01 00:00:00
211 | Jones | LF-8532 | 20 | 2009-02-01 00:00:00
211 | Jones | LF-8533 | 21 | 2009-02-02 00:00:00
211 | Jones | Misc | 18.5 | 2009-02-02 00:00:00
211 | Jones
212 | Smith | 14563 | 490 | 2008-07-01 00:00:00
212 | Smith | LF-8534 | 21 | 2009-02-02 00:00:00
212 | Smith | LF-8534 | 21 | 2009-02-02 00:00:00
212 | Smith | Misc | 18.5 | 2009-02-02 00:00:00
212 | Smith
 |  | IF(E3>0,DATE(YEAR(E3),MONTH(E3)+1,1)," ")
 |  |  |  |  | IF(H3<>0,G$2-F3," ")
 |  |  |  |  |  |  | MONSTER FORMULA
IF($G3,$D3*$H$2/365*$G3,IF(COUNTA($A2,$A4)=2,-SUMIF(INDEX($C:$C,MATCH($A2,$A2:$A$3,0)):$C2,"LF-*",INDEX($D:$D,MATCH($A2,$A2:$A$3,0)):$D2),IF($A3<>"",SUM($H2,SUMIF($A$2:$A2,$A3,$H$2:$H2)))))
Spreadsheet: stephanie_panus__39270__Copamex ISDA2
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: | 2001-10-16 00:00:00 | DEAL MAKER: | [NAME]
COUNTERPARTY: | Copamex SA de CV | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State | Mexico | S&P Rating | BB-/Stable
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 20
Incorporation State |  | OR
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor |  | X
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | BBB- or better | 15
 | BB- to BB+ | 7
 | [NAME] | 3
 | B and below | 0
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0 | 0
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
-Below = S&P/Moody's
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 10
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
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:
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] | x6-6002