tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4094beb4-208f-41ce-940f-6c7b96a8eed3
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-10-02 09:34:13.820000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
3.625 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.5 | 101.882 | 101.757 | 101.632 | 101.257
3.375 | 101.071 | 100.946 | 100.821 | 100.446 |  | Note: | Refer To Price [NAME]
3.25 | 100.235 | 100.11 | 99.985 | 99.61 |  |  | For all Price Adjs
3.125 | 99.36 | 99.235 | 99.11 | 98.485
3 | 97.86 | 97.735 | 97.61 | 96.985
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.125 | 102.125 | 102 | 101.875 | 101.5
3 | 101.678 | 101.553 | 101.428 | 101.053
2.875 | 101.091 | 100.966 | 100.841 | 100.466
2.75 | 100.462 | 100.337 | 100.212 | 99.837
2.625 | 99.712 | 99.587 | 99.462 | 98.837
2.5 | 98.711 | 98.586 | 98.461 | 97.836
 |  |  |  |  |  | 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-10-16 09:34:13.820000
30 DAY | 2012-10-31 09:34:13.820000
45 DAY | 2012-11-15 09:34:13.820000
60 DAY | 2012-11-30 09:34:13.820000
90 DAY | 2012-12-30 09:34:13.820000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 2

 | Oct 26 |  | Nov 2 |  | Nov 9 |  | Nov 16
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 378058202 | 378058202 | 378031410 | 378031410 | 379472036 | 379472036 | 377403821 | 377403821
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16352798 | 16352798 | 16595767 | 16595767 | 16458308 | 16458308 | 16476083 | 16476083
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 22002320 | 22002320 | 22043739 | 22043739 | 22022016 | 22022016 | 22026049 | 22026049
Dealers** | 18743202 | 18721776 | 18794550 | 18768714 | 18755845 | 18734920 | 18742698 | 18721286
Buyside | 3259119 | 3280544 | 3249189 | 3275025 | 3266171 | 3287096 | 3283351 | 3304763
Total Equity | 5895050 | 5895050 | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type 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: 146090d1331896605-graph-detail-819967-graph-detail
Sheet: Sheet1

 | 2012-01-12 00:00:00 | 2012-02-12 00:00:00
SALES | 6340.1 | 7573
MATERIALS | 2895.7 | 3332.4
LABOUR | 598.2 | 637.7
COS OVERHEAD | 1826.4 | 1766.8
D&L | 430 | 456.8
SELLING EXP | 530.6 | 532.2
G&A | 669.7 | 988.5
OP. PROFIT | -610.5 | -141.4
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: TTM Recon Q3FY11

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations - Trailing Twelve Months (TTM)
(in millions, except per share data)
 | Trailing Twelve Months Ended December 31, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on licensed intellectual property commitment (COGS) |  | Loss on Strategic Investments |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 3478 |  | 0 |  | 205 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3683
Cost of revenue | 1469 |  | -11 |  | 0 |  | 2 |  | 0 |  | 0 |  | -3 |  | 0 |  | 1457
Gross profit | 2009 |  | 11 |  | 205 |  | -2 |  | 0 |  | 0 |  | 3 |  | 0 |  | 2226
Operating expenses:
Marketing and sales | 724 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -20 |  | 0 |  | 704
General and administrative | 305 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -41 |  | 0 |  | 264
Research and development | 1136 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -114 |  | 0 |  | 1022
Acquisition-related contingent consideration | -23 |  | 23 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 59 |  | -59 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 182 |  | 0 |  | 0 |  | 0 |  | 0 |  | -182 |  | 0 |  | 0 |  | 0
Total operating expenses | 2383 |  | -36 |  | 0 |  | 0 |  | 0 |  | -182 |  | -175 |  | 0 |  | 1990
Operating income (loss) | -374 |  | 47 |  | 205 |  | -2 |  | 0 |  | 182 |  | 178 |  | 0 |  | 236
Gain on strategic investments | 22 |  | 0 |  | 0 |  | 0 |  | -22 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income, net | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 4
Income (loss) before provison for income taxes | -348 |  | 47 |  | 205 |  | -2 |  | -22 |  | 182 |  | 178 |  | 0 |  | 240
Provision for income taxes | 49 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 18 |  | 67
Net income (loss) | -397 |  | 47 |  | 205 |  | -2 |  | -22 |  | 182 |  | 178 |  | -18 |  | 173
Loss per share |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Diluted | -1.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diluted |  | 0.52
Spreadsheet: jeff_dasovich__14083__ENRON2
Sheet: UNDERCOLLECTIONS

ESTIMATED UNDERCOLLECTION MONTH ENDING JANUARY 2001 FOR PG&E
TCBA
TRA
[NAME] | -150
Net Undercollection |  |  | $/MWH
Above Book Proceeds from Sale of Transmission | -2500
REMAINING UNDERCOLLECTION |  |  | $/MWH
ESTIMATED UNDERCOLLECTION MONTH ENDING JANUARY 2001 FOR SCE
TCBA | -603
TRA | 5465
PXRMA | -1064
HGMA | -695
UFCCMA | 88
Net Undercollection |  |  | $/MWH
Above Book Proceeds from Sale of Transmission
REMAINING UNDERCOLLECTION |  |  | $/MWH
10 Years of Sales for Amortization of Balance | 800
Spreadsheet: 110853d1307447709-calendar-for-on-call-rota-problem-solver_shift_rota
Sheet: Sheet1

 |  |  | Late | Early | Mid | On call | Criteria 1 | [NAME]
 |  | [NAME] |  |  |  |  | 0 | 0
 |  | [NAME] |  |  |  |  | 0 | 0
 |  | [NAME] |  |  |  |  | 0
 |  | Nick |  |  |  |  | 0 | 0
 |  | Tot staff | 0 | 0 | 0 | 0 |  | 0
 |  | Demand | 1 | 2 | 1 | 1
 | Diff: Tot staff - Demand |  | -1 | -2 | -1 | -1 |  |  |  |  | This requires that Solver is installed
 | Objct func. | 5 | To be minimized |  |  |  |  |  |  |  | Check: Tools -> Add-Ins and see if box marked "Solver" is ticked,
 |  |  |  |  |  |  |  |  |  |  | if not you must first install Solver.
 |  |  |  |  |  |  |  |  |  |  | To run this goto Tools-> Solver and click button "Solve"
 |  |  |  |  |  |  |  |  |  |  | To do a rerun of the problem 1st clear area D5 to G8 before
 |  |  |  |  |  |  |  |  |  |  | you run Solver again.
Spreadsheet: 2d2cff55-1ef8-46b3-b335-86edac46102e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7378 | 7671 | [NAME] | [NAME] | GBR | 296 | [NAME] | 00:05:13 | 01:19:09 | 00:02:08 | 01:00:47 | 1 | 03:03:16
7378 | 29832 | Avner | [NAME] | ISR | 297 | [NAME] | 00:06:02 | 01:35:49 | 00:00:00 | 00:00:00 | 2 | 03:33:01
Spreadsheet: 33974d1230939300-linking-to-last-record-in-a-spreadsheet-excelforum_2003_upload
Sheet: data

year | weight | length
1994 | 28 | 171
1995 | 23 | 154
1996 | 26 | 150
1997 | 22 | 111
1998 | 34 | 202
1999 | 24 | 123
2000 | 27 | 134
2001 | 21 | 121
2002 | 25 | 132
2003 | 19 | 112
2004 | 31 | 135
2005 | 22 | 126
2006 | 27 | 145
2007 | 28 | 147
2008 | 56 | 301
Spreadsheet: 871156d1717574362-struggling-with-multiple-dependent-drop-downs-cambridge-fireworks-stock-and-display-sheet-24-25-2-
Sheet: FT

Firework Type | < Sorted with spaces removed
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Flashpot
Fountain
Fountain
Fountain
Ignitor
Mine
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Strobe
Strobe
Spreadsheet: 698865d1602207723-formating-to-highlight-a-cell-when-a-date-on-a-row-meets-a-day-column-then-color-intercept-test-for-daddy
Sheet: Sheet1

 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
2020-10-01 00:00:00 | 2020-10-07 00:00:00
2020-10-08 00:00:00 | 2020-10-14 00:00:00
2020-10-15 00:00:00 | 2020-10-21 00:00:00
2020-10-22 00:00:00 | 2020-10-28 00:00:00
2020-10-29 00:00:00 | 2020-11-04 00:00:00
2020-11-05 00:00:00 | 2020-11-11 00:00:00
 |  |  | =AND($A4)<$A$1,$C$3:$N$3=TEXT(WEEKDAY(TODAY()),"dddd"))
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
2020-10-01 00:00:00 | 2020-10-07 00:00:00
2020-10-08 00:00:00 | 2020-10-14 00:00:00
2020-10-15 00:00:00 | 2020-10-21 00:00:00
2020-10-22 00:00:00 | 2020-10-28 00:00:00
2020-10-29 00:00:00 | 2020-11-04 00:00:00
2020-11-05 00:00:00 | 2020-11-11 00:00:00
 |  | i am trying to do a condition formatting to highlight a cell when a date range on a row meets a day column and cell date then color intercept.
 |  | I was able to come up with a formula but i need those cells to be empty so i can use it to add a text. So i thought of using the condition features to highlight the cell. see formula below, i like this formula but it is not what i had in mind. also see attachment.
 |  | [HTML]'=AND($A4)<$A$1,$C$3:$N$3=TEXT(WEEKDAY(TODAY()),"dddd"))
Spreadsheet: 267717d1380148863-how-do-i-stop-a-formula-once-a-sum-is-satisfied-example-forum
Sheet: Sheet1

Debt replacement | Yes
One time emission | No
Number of disbursements | 5
Fixed % per disbursement
Month of replacement | 8
Debt | 1000000
[NAME] |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
%
Debt
Spreadsheet: 153251d1335828103-search-value-and-return-a-set-of-values-in-the-row-weatherdata_sample
Sheet: InsertIntoTable

MIAMI
Average Solar Radiation based on NREL Data
kWh/m^2/day | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Mount0
Mount1
Mount2
Mount3
Mount5
Mount6
Mount7
Mount8
Mount9
Spreadsheet: 524865d1498413084-interest-calculations-for-a-duration-of-period-with-compound-interest-on-quarterly-basis-interest-calculations
Sheet: Sheet1

sl.no | investment | % int | from | to | no.of days | int
1 | 10000 | 5 | 2016-12-31 00:00:00 | 2017-03-31 00:00:00
2 | 12000 | 4 | 2016-05-12 00:00:00 | 2017-03-31 00:00:00
3 | 15000 | 4 | 2016-03-31 00:00:00 | 2017-03-31 00:00:00
Spreadsheet: 809065d1670869435-i-need-an-if-nested-funtion-valores-por-assistencia
Sheet: Sheet2

7/03/22-9/25/22 |  |  | 1-10/7/2022 | 2-10/14/2022 | 3-10/21/2022 | 4-10/28/22 | 5-11/04/2022 | 6-11/11/2022 | 7-11/18/2 | 8-11/25/2022 | 9-12/02/2022 | 10-12/09/2022 | 11-12/16/2022 | 12-12/23/2022 | 13-12/30/2022 | 13- | 3rd Quarter 2022-TEAMSTERS LOCAL 385 Hourly Bonus
PTO during July-Sep only and IF IS NOT PRE-APPROVE WILL COUNT |  |  | W.E. |  |  |  |  |  |  |  |  |  |  |  |  |  | Attendance |  | MOST % | Teardown %
File # | Name | status act or not |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hrs Missed | Bonus Level |  |  | Total Bonus
170002 | Acevedo,[NAME] | Active | 1 |  | 1 |  |  | 2 |  |  |  |  |  |  |  |  |  | 75 | 0 | 0
170421 | Alamo,Christian | Active |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 0 | 0
170375 | Almanzar,[NAME] | Active | 3.72 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 0 | 0
170008 | Alston,[NAME] | Active |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 0 | 0
170395 | [NAME],[NAME] | Active | 1 |  | 2 |  | 1 |  | 3.1 |  |  |  |  |  |  |  |  | 75 | 0 | 0
170318 | Barnes,Willie | Active |  | 3 | 5 | 1 | 3 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | CRITERIA
 | 0 missed time | 150
 | 0.1 to 3.99 | 100
 | 4 to 8 | 75
 | more than 8 | 0
Spreadsheet: 885475d1735086639-granulating-weekly-timesheet-to-days-vlookup-index-formula-granulating-weekly-timesheet-to-days-version-2
Sheet: Original

Week Start | Employee | Pay Item | Class/Project | Service/Role | Hours | Description | Sun | Mon | Tue | Wed | Thu | Fri | Sat
2024-12-01 00:00:00 | [NAME] | Regular Pay | [NAME] | Management | 12 | Working on this stupid spreadsheet |  | 4 | 8 |  | 2 | 2
2024-12-01 00:00:00 | [NAME] | Sick | HR | Stat/Vac/Sick | 8 | [NAME] |  |  |  | 4
2024-12-01 00:00:00 | Bojangles | Regular Pay | Lodge | Reporting | 7 | Building walls |  | 4 | 2 | 1
2024-12-01 00:00:00 | Slugger | Regular Pay | Geese | Reporting | 1 | Reporting on Geese etc |  |  | 1
Date | Employee | Pay Item | Class/Project | Service/Role | Hours | Description
 |  |  |  |  |  |  |  | all_hours | =Original!$I$2:$M$5
 | [NAME] |  |  |  |  |  |  | all_week | =Original!$I$1:$M$1
 | [NAME] |  |  |  |  |  |  | eachday | =MATCH(all_week,all_week,0)
 | [NAME]
 | [NAME]
 | Bojangles
 | Bojangles
 | Bojangles
 | Slugger
Spreadsheet: ff229331-b170-4960-b0e4-1bb7d46cce1f
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
TYPES OF DEPOSITS: |  |  | APRIL 30 |  |  | DEPOSITS |  |  | WITHDRAWALS |  |  | MAY 31
CHECKING ACCOUNTS
WELLS FARGO GENERAL CHECKING |  | $ | 49316.05999999959 |  | $ | 2003561.19 |  | $ | 1943763.11 |  | $ | 109114.1399999994
WELLS FARGO HOLD ACCT (DEVELOPER DEPOSITS) |  |  | 23739.75 |  |  | 0 |  |  | 0 |  |  | 23739.75
RANCHO BANK CITRUS PLAZA OPERATING  ACCT |  |  | 88606.98 |  |  | 35557.08 |  |  | 17351.02 |  |  | 106813.04
RANCHO BANK CITRUS PLAZA OPERATING  ACCT (MM) |  |  | 9091.789999999994 |  |  | 1.99 |  |  | 0 |  |  | 9093.779999999993
RANCHO BANK CITRUS PLAZA SECURITY DEPOSIT ACCT |  |  | 120063.95 |  |  | 73.7 |  |  | 0 |  |  | 120137.65
PACIFIC WESTERN NAT BANK RDA PROGRAMS (SBA/FTHB/HPP) |  |  | 13722.94 |  |  | 0 |  |  | 0 |  |  | 13722.94
SUB-TOTAL |  | $ | 304541.4699999996 |  | $ | 2039193.96 |  | $ | 1961114.13 |  | $ | 382621.2999999994
OTHER INVESTMENTS:
LOCAL AGENCY INVESTMENT FUND (LAIF) |  |  | 17348503.09 |  |  | 1934000 |  |  | 1541000 |  |  | 17741503.09
LOS ANGELES COUNTY POOL (LACIP) |  |  | 1851871.67 |  |  | 3781.95 |  |  | 0 |  |  | 1855653.62
SUB-TOTAL |  | $ | 19200374.76 |  | $ | 1937781.95 |  | $ | 1541000 |  | $ | 19597156.71
TOTAL |  | $ | 19504916.23 |  | $ | 3976975.91 |  | $ | 3502114.13 |  | $ | 19979778.01
COMMUNITY FACILITIES DISTRICT REVENUE FUND
WELLS FARGO BANK C.F.D. CHECKING |  | $ | 2166.079999999958 |  | $ | 442025.19 |  | $ | 442000 |  | $ | 2191.26999999996
LOS ANGELES COUNTY POOL (LACIP) SALES TAX |  |  | 0 |  |  |  |  |  |  |  |  | 0
LOS ANGELES COUNTY POOL (LACIP) |  |  | 924810.32 |  |  | 443416.82 |  |  | 0 |  |  | 1368227.14
TOTAL FOR C.F.D. REVENUE FUND |  | $ | 926976.3999999999 |  | $ | 885442.01 |  | $ | 442000 |  | $ | 1370418.41
*NEGATIVE BALANCE REFLECTS OUTSTANDING CHECKS
It has been verified that this investment portfolio is in conformity with the City of West Covina's investment policy which was approved by the City Council on January 18, 2005.
The investment portfolio provides sufficient cash flow liquidity to meet estimated expenditures for the next six months. This report is accurate with respect to all information received as of June 24, 2005.
EARNED INTEREST YIELD THIS PERIOD:  2.856% |  |  |  |  |  | SIX-MONTH TREASURY BILL YIELD:  3.08%
REVIEWED BY: |  |  |  |  |  | PREPARED BY:
_________________________________________________ |  |  |  |  |  | _________________________________________________
[NAME], City Controller |  |  |  |  |  | [NAME], Revenue Services Supervisor
SUBMITTED BY: |  |  |  |  |  | APPROVED BY:
_________________________________________________ |  |  |  |  |  | _________________________________________________
[NAME], Finance Director |  |  |  |  |  | [NAME], City Treasurer
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Mining Tech Cert 3

MINING TECHNOLOGY
Certificates
Student Name:
ID #
Mining Technician Assistant II | Semester | Grade
___ MNG 123 (4) Mining Electricity I
___ MNG 125 (1) Mining Electricity I Lab
___ ET/ELT 265 (3 Applied Fluid Power
OR ___ FPX 100 (3) Fluid Power
AND ___ FPX 101 (2) Fluid Power Lab
Mining Technician I
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
___ MNG 160 (3) Elements of Underground Mining
___ MNG 161 (1-3) Elements of Underground Mining Lab
___ MNG 150 (3) Mining Laws
___ MNG 286 (3) [NAME] and Ventilation
Mining Technician II
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
___ MNG 123 (4) Mining Electricity I
___ MNG 125 (1) Mining Electricity I Lab
___ MNG 150 (3) Mining Laws
___ MNG 286 (3) [NAME] and Ventilation
___ MNG 190 (3) Mine Emergency Technician
OR ___ KHP 190 (2) First Aid and Emergency Care
___ IMT 100 (3) Welding for Maintenance
___ IMT 101 (2) Welding for [NAME]
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 133596d1324493142-listing-many-unique-values-based-on-an-if-statement-book1-modified-by-tigeravatar-
Sheet: RawData

Participant # | Store | Reason |  | Store
1 | World's Away | Convenient and store owner rocks! |  | World's Away
2 | World's Away | Regular business/purchases/second home |  | Good as New
3 | World's Away | Product/price |  | [NAME]'s [NAME]
4 | World's Away | One of my favourite stores
5 | Good as New | love to shop here-got couch & love seat here great people very helpful
6 | [NAME]'s [NAME] | Kindest, most economical, special business
7 | [NAME]'s [NAME] | a friend
Spreadsheet: 767330d1644416985-what-formula-should-i-use-to-get-total-value-date-wise-datetotal
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4
Date | Amount |  | Total
2022-01-02 00:00:00 | 202
2022-01-02 00:00:00 | 200
2022-01-02 00:00:00 | 456
2022-01-02 00:00:00 | 356
2022-01-02 00:00:00 | 345
2022-01-02 00:00:00 | 867
2022-01-03 00:00:00 | 454
2022-01-03 00:00:00 | 345
2022-01-03 00:00:00 | 444
2022-01-03 00:00:00 | 346
2022-01-04 00:00:00 | 34
2022-01-04 00:00:00 | 267
2022-01-05 00:00:00 | 367
2022-01-05 00:00:00 | 43
2022-01-05 00:00:00 | 65
2022-01-05 00:00:00 | 774
Spreadsheet: 746050d1630462538-finding-difference-of-two-dates-for-the-same-customer-name-and-the-same-receipt-type-and-c-interest-calculation
Sheet: Data

Sr. No | Party Name | Receipt Type | Date | Amount
1 | Laopala RG Ltd. | Land Premium | 2018-11-10 00:00:00 | 50000
2 | [NAME] | Lease Rent | 2018-11-15 00:00:00 | 20000
3 | Laopala RG Ltd. | Lease Rent | 2018-12-04 00:00:00 | 70000
4 | [NAME] | Lease Rent | 2019-01-20 00:00:00 | 40000
5 | Laopala RG Ltd. | Lease Rent | 2019-02-17 00:00:00 | 20000​
 |  | …. And so on, there are n number of receipt types and Parties
1 | Rate of Interest is 12% and Financial Year is (01/04/2018 to 31/03/2019 containg 365 days)
2 | There is another worksheet name Output, Which has only unique party names, where interest has to calculated, It also contains expected results and calculation method
3 | From this table, I want to calculate total calculate Interest for the year (01/04/2018 to 31/03/2019) for each Receipt Type for each party
4 | Interest will be calculated as = [Amount]*[No of Days/365]*[12%]
5 | For Example, in case of Laopala RG Ltd, there are two types of receipts (a) Land Premium and (b) Lease Rent and interest has to calcuated for both type of receipts separately
 | a. In case of  land Premium :
 | Interest will calculated for (31/03/2019- 10/11/2018) = 141 Days on 50000,
 | b. In case of Lease Rent :
 | Laopala RG Ltd made first payment for Lease Rent on 04/12/2018 of 70000 and next payment on 17/02/2019.. therefore Interest has to be calculated for the year (01/04/2018 to 31/03/2019) as follows
 | 1. (17/02/2019 -04/12/2018)= 75 Days on 70000
 | 2. (31/03/2019 - 17/02/2019) =42 Days on ( 70000 + Amount in 1. Above)
6 | Interest on Lease Rent only will be total = 1+2 in a single cell
7 | Can this be done using Excel [NAME] (Excel 2007 or Excel 2013 only) ? No VBA due to frequent transfer of files on gmail
8 | Though this is similar to interest on ledger balances of a Party with two major difference, table consists more than one party and interest is to be calculated for each receipt type separately.