tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 764b1129-3e61-43ec-9481-b0082c4bc402
Sheet: Jadwal Blok

RENCANA JADWAL PELAKSANAAN PLPG TIPE BLOK
RAYON 112 UNIVERSITAS NEGERI SEMARANG
TAHUN 2012
[NAME] : 1 MEI 2012
NO | [NAME] | TAHAP | TEMPAT PELAKSANAAN |  |  |  |  |  |  |  |  | Fakultas | [NAME]
 |  |  | DIKLAT | PATEMON | BALATKOP | BALATRANS | DIKJUR | BLKLN | KUSUMA | MURIA | Bidang Studi
1 | 3-12 MEI | I | SD/3
2 | 11-20 MEI | II |  | SD/6
3 | 12-21 MEI |  |  |  |  |  |  |  | TK/4
4 | 13-22 MEI |  | IPS/2, IPA/2
5 | 14-23 MEI |  |  |  |  |  |  |  |  | SD/2
6 | 21-30 MEI | III |  | SD/6
7 | 22-31 MEI |  |  |  |  |  |  |  | TK/4
8 | 23 MEI-1 JUNI |  | SD/3 |  |  |  |  |  |  | SD/2
9 | 31 MEI-9 JUNI |  |  | SD/6
10 | 1-10 JUNI |  |  |  |  |  |  |  | SD/4
11 | 2-11 JUNI |  | PJS/3 |  |  | SD/3
12 | 11-20 JUNI | IV |  |  |  |  |  |  | SD/4
13 | 12-21 JUNI |  | TK/3 |  |  | SD/3
14 | 17-26 JUNI |  |  | SD/6
15 | 21-30 JUNI |  | PJS/3 |  |  |  |  |  | SD/4 | SD/2
16 | 22 [NAME] | V |  |  |  | SD/3
17 | 27 [NAME] |  |  | SD/6
18 | 1 -10 JULI |  | TK/3 |  |  |  |  |  | SD/4
19 | 2-11 JULI |  |  |  |  | SD/3
20 | 7-16 JULI | VI |  | SD/6
21 | 9-17 JULI |  |  |  |  |  |  | SD/2
22 | 11-20 [NAME] |  | SD/10 |  |  |  |  |  | TK/4
23 | 12-21 JULI |  |  |  |  | SD/3
24 | 16-25juli |  |  |  |  |  | SD/4
25 | 17-26 JULI |  |  | SD/6
26 | 18 -27 JULI |  |  |  |  |  |  | SD/2
27 | 21-30 [NAME] |  | SD/10 |  |  |  |  |  | TK/4 |  | TIK/3,OTO/1,PTM/1 | FT | 5
28 | 22-31 [NAME] |  |  |  | SD/5 | SD/3 |  |  |  |  | MTK(SMA) /2, KIM/1 | FMIPA | 3
29 | 27 JULI-5 AGST | VII |  | SD/6 |  |  | PJS/4 |  |  |  | S.BDY/2, | FIS | 2
30 | 28 JULI-6 AGST |  |  |  |  |  |  | SD/2 |  |  | [NAME] | FIP | 2
31 | 31 [NAME] |  | SD/10 |  |  |  |  |  |  |  | BI(SMA)/1,JW/1 | FBS | 2
32 | 1-10 AGST |  |  |  | SD/5 | KET/2, MUL/1 |  |  | SD/4 |  | PJS/2 | FIK | 2
33 | 6-15 AGST |  |  | SD/6
34 | 7-16 AGSTS |  |  |  |  |  | SD/4 | SD/2 |  |  | S.BDY/3, PKn/1 | FIS | 4
35 | 10-30 AGST | VIII | SD/4,PJS/5,Aws/1
36 | 11-31 AGST |  |  |  | SD/5 | SD/3 |  |  | PJS/4 |  | PJS/3 | FIK | 3
 |  |  | 62 | 54 | 15 | 24 | 12 | 8 | 40 | 6 | 23
REKAP BIDANG STUDI PER GUGUS |  | SD | 40 | 54 | 15 | 21 | 8 | 8 | 20 | 6
 |  | TK | 6 |  |  |  |  |  | 16
 |  | PJS | 11 |  |  |  | 4 |  | 4 |  | 5
 |  | IPA | 2
 |  | IPS | 2
 |  | AWS | 1
 |  | Ket |  |  |  | 2
 |  | [NAME] |  |  |  | 1
 |  | TIK |  |  |  |  |  |  |  |  | 3
 |  | OTO |  |  |  |  |  |  |  |  | 1
 |  | PTM |  |  |  |  |  |  |  |  | 1
 |  | MAT |  |  |  |  |  |  |  |  | 2
 |  | [NAME] |  |  |  |  |  |  |  |  | 1
 |  | SBDY |  |  |  |  |  |  |  |  | 5
 |  | BK |  |  |  |  |  |  |  |  | 2
 |  | BI |  |  |  |  |  |  |  |  | 1
 |  | JW |  |  |  |  |  |  |  |  | 1
 |  | PKn |  |  |  |  |  |  |  |  | 1
 |  | [NAME]
Spreadsheet: 724590d1616251146-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - PARADA - Britador

 |  | CENTROS DE CUSTOS
 |  | Vale - PARADA - Britador
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | TAG | Observação
 |  | 2021-03-06 00:00:00 | Combustivel | 55750 | 7540.8 | EQ028 | Compressor
 |  | 2021-03-06 00:00:00 | Combustivel | 55751 | 7540.8 | EQ003 | TLB 315 SL
 |  | 2021-03-10 00:00:00 | Combustivel | 55760 | 7540.8 | [NAME] | Compressor
 |  | 2021-03-10 00:00:00 | Combustivel | 55787 | 7540.8 | EQ028 | Compressor
 |  | 2021-03-10 00:00:00 | Combustivel | 55761 | 3394.5 | EQ015 | Gerador
 |  | 2021-03-10 00:00:00 | Combustivel | 55761 | 1018.35 | EQ039 | Cut Machine
 |  | 2021-03-10 00:00:00 | Combustivel | 55761 | 1018.35 | EQ026 | Vibrador
 |  | 2021-03-14 00:00:00 | Combustivel | 55762 | 13624.8 | EQ059 | Compressor
Spreadsheet: 23736d1213387285-indexing-and-lookup-resourcehelp
Sheet: Sheet2

 |  | July 1-5 |  |  |  |  |  | July 8-12 |  |  |  |  |  | July 15-19 |  |  |  |  |  | July 22-26 |  |  |  |  |  | July 28-2
Project | Role | M | T | W | Th | F | Total | M | T | W | Th | F | Total | M | T | W | Th | F | Total | M | T | W | Th | F | Total | M | T | W | Th | F | Total
lookup from first sheet |  | sum up hours for each role from specific project for specific date
abc | IA |  | 4 | 1 |  |  | 5
abc | BA |  |  |  |  | 3 | 3
def | CD |  |  |  | 3 |  | 3
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 12-7 thru 12-13

 |  |  |  |  |  | System:
 |  |  | 2009-12-07 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2007-12-07 00:00:00 |  |  |  |  |  |  | Total
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 886985d1737057445-cells-need-to-trigger-changes-in-graph-2025-chart
Sheet: 20%

 | S&P 500 Annual Index Returns |  | 20% PR S&P 500 |  | 3% MYGA
Year | S&P 500 | Account Value | Interest Credited | Account Value | MYGA | Account Value
1997 |  | 100000 |  | 100000 |  | 100000
1998 | 0.2667 | 126670 | 0.05334 | 105330 | 0.03 | 103000
1999 | 0.1953 | 151409 | 0.03906 | 109448 | 0.03 | 106090
2000 | –10.14% | 136056 | 0 | 109448 | 0.03 | 109272.7
2001 | –13.04% | 118314 | 0 | 109448 | 0.03 | 112550.89
2002 | –23.37% | 90664 | 0 | 109448 | 0.03 | 115927.41
2003 | 0.2638 | 114581 | 0.05276 | 115227 | 0.03 | 119405.23
2004 | 0.0899 | 124882 | 0.01798 | 117301 | 0.03 | 122987.39
2005 | 0.03 | 128629 | 0.0006 | 124339 | 0.03 | 126677.01
2006 | 0.1362 | 146148 | 0.02724 | 127721 | 0.03 | 130477.32
2007 | 0.0353 | 151307 | 0.00706 | 128628 | 0.03 | 134391.64
2008 | –38.49% | 93069 | 0 | 128628 | 0.03 | 138423.39
2009 | 0.2345 | 117894 | 0.0469 | 134660 | 0.03 | 142576.09
2010 | 0.1278 | 129577 | 0.02556 | 138108 | 0.03 | 146853.37
2011 | 0 | 129577 | 0 | 138108 | 0.03 | 151258.97
2012 | 0.1341 | 146953 | 0.02682 | 141809 | 0.03 | 155796.74
2013 | 0.296 | 190451 | 0.0592 | 150204 | 0.03 | 160470.64
2014 | 0.1139 | 212144 | 0.02278 | 153629 | 0.03 | 165284.76
2015 | –0.73% | 210595 | 0 | 153629 | 0.03 | 170243.31
2016 | 0.0954 | 230686 | 0.01908 | 156563 | 0.03 | 175350.61
2017 | 0.1942 | 275485 | 0.03884 | 162638 | 0.03 | 180611.12
2018 | –6.24% | 258295 | 0 | 162638 | 0.03 | 186029.46
2019 | 0.2888 | 332891 | 0.05776 | 172038 | 0.03 | 191610.34
2020 | 0.1626 | 387019 | 0.03252 | 177630 | 0.03 | 197358.65
2021 | 0.2689 | 491088 | 0.05378 | 187186 | 0.03 | 203279.41
Spreadsheet: 825226d1681195328-variance-on-zero-values-book1
Sheet: Sheet1

 |  |  | Newly Created Accounts vs Last Month
 |  |  | USER | This month | Last month | [NAME] | [NAME]
 |  |  | Unit 1 | 165 | 171
 |  |  | Unit 2 | 101 | 40
 |  |  | Unit 3 | 13 | 9
 |  |  | Unit 4 | 10 | 3
 |  |  | Unit 5 | 7 | 9
 |  |  | Unit 6 | 7 | 0
 |  |  | Unit 7 | 5 | 3
 |  |  | Unit 8 | 4 | 5
 |  |  | Unit 9 | 3 | 20
 |  |  | Unit 10 | 3 | 4
 |  |  | Unit 11 | 2 | 2
 |  |  | Unit 12 | 1 | 0
 |  |  | Unit 13 | 1 | 1
 |  |  | Unit 14 | 1 | 0
 |  |  | Unit 15 | 0 | 0
 |  |  | Unit 16 | 0 | 0
 |  |  | Unit 17 | 0 | 0
 |  |  | Unit 18 | 0 | 0
 |  |  | Unit 19 | 0 | 0
 |  |  | Unit 20 | 0 | 0
 |  |  | Unit 21 | 0 | 0
 |  |  | Unit 22 | 0 | 0
 |  |  | Unit 23 | 0 | 0
 |  |  | Unit 24 | 0 | 0
 |  |  | Unit 25 | 0 | 0
Spreadsheet: 792183d1660765800-spill-error-imbedded-if-statements-unknown-origin-cwsp-financial-report-final-draft
Sheet: Financial Report

 |  |  |  |  |  |  |  | AWARD INFO |  | STATE REMAINING GRANT $ |  | EXPEDITURES
Quarter ending: [date] |  |  |  |  |  |  |  | Total Award Amount: | 1000000 | Amount Available at Grant Start |  | Total Disbursed
[CWSP Name] |  |  |  |  |  |  |  | Administrative Costs (AC): 15% | 150000 | Total Requested |  | Total Spent
[Grant ID] |  |  |  |  |  |  |  | Project Completion Costs (PCC): 85% | 850000 | Total Remaining |  | Remaining Cash on Hand
 | .
 |  | Ex: Draw only | Ex: Draw+ Adv | Ex: Draw+ Reimb
 |  | Quarter 1 | Quarter2 | Quarter 3 | Quarter 4 | Quarter 5 | Quarter 6 | Quarter 7 | Quarter 8 | Cumulative Totals | % Remaining
Administrative Costs (AC) | Total Expenditures this Quarter- AC | 37500 | 37500 | 40000 | 0 | 0 | 0 | 0 | 0 |  |  | admin pacing
 | Quarter to Date Cash Reimbursements- AC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 31000 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- AC |  |  |  |  |  |  |  |  |  |  | HIDE | and 21
 | Quarter End Remaining Cash Balance- AC |  |  |  |  |  |  |  |  |  |  | HIDE | and 23
 | Quarter End Draw Request
 | Total Amount AC Currently Requested | 37500 | 68000
Project Completion Costs (PCC) | Total Expenditures this Quarter- PCC | 20000 | 120000 | 300000 | 210000 | 0 |  |  |  |  |  | pcc pacing
 | Quarter to Date Cash Reimbursements- PCC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | New Advance Request | 0 | 100000 | 0 | 0 | 0 | 0 | 0 | 0
 | Cash Balance at Quarter Start- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Remaining Cash Balance- PCC |  |  |  |  |  |  |  |  |  |  | HIDE
 | Quarter End Draw Request
 | Total PCC Currently Requested
 | Total Draw Requested
 | Total Advance Requested
 | Quarter Total Requested |  |  |  |  |  |  |  |  |  |  | remaining state funds
 | PCC Non- Match Eligible | 0 | 20000 | 15000 | 0 | 0 | 0 | 0 | 0
 | PCC- Match Eligible
 | Interest Earned | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | goes the other way- talks to TPM tab
Spreadsheet: 842272d1694415366-using-if-ifs-with-match-function-sample-7-forum
Sheet: Sheet1

RESULT (WANT ONLY TO PICK RECORDS ONLY WHERE is 18, 19 or 20) | 18 | 19 | 20
Spreadsheet: 71470d1272209534-vlookup-cascading-multi-value-multi-lookupv101
Sheet: Sheet1

1-Mr A | Mr A | Application A |  | Mr A | Application A | Application B | Application C | Application D | Application E | Application F | Application G | Application H | Application ZZ
2-Mr A | Mr A | Application B |  | MR B | Application X | Application Y | Application Z
3-Mr A | Mr A | Application C |  | MR C | Application 1 | Application 2 | Application 3 | Application 4 | Application 5 | Application 6 | Application 7 | Application 8 | Application 9 | Application 10 | Application 11 | Application 12 | Application 13 | Application 14 | Application 15 | Application 16 | Application 17 | Application 18 | Application 19 | Application 20 | Application 21 | Application 22 | Application 23 | Application 24 | Application 25 | Application 26 | Application 27 | Application 28 | Application 29 | Application 30 | Application 31 | Application 32 | Application 33 | Application 34 | Application 35 | Application 36 | Application 37 | Application 38 | Application 39 | Application 40 | Application 41 | Application 42 | Application 43
4-Mr A | Mr A | Application D
1-Mr B | Mr B | Application X
2-Mr B | Mr B | Application Y
3-Mr B | Mr B | Application Z
5-Mr A | Mr A | Application E
6-Mr A | Mr A | Application F
7-Mr A | Mr A | Application G
8-Mr A | Mr A | Application H
1-MR C | MR C | Application 1
2-MR C | MR C | Application 2
3-MR C | MR C | Application 3
4-MR C | MR C | Application 4
5-MR C | MR C | Application 5
6-MR C | MR C | Application 6
7-MR C | MR C | Application 7
8-MR C | MR C | Application 8
9-MR C | MR C | Application 9
10-MR C | MR C | Application 10
11-MR C | MR C | Application 11
12-MR C | MR C | Application 12
13-MR C | MR C | Application 13
14-MR C | MR C | Application 14
15-MR C | MR C | Application 15
16-MR C | MR C | Application 16
17-MR C | MR C | Application 17
18-MR C | MR C | Application 18
19-MR C | MR C | Application 19
20-MR C | MR C | Application 20
21-MR C | MR C | Application 21
22-MR C | MR C | Application 22
23-MR C | MR C | Application 23
24-MR C | MR C | Application 24
25-MR C | MR C | Application 25
26-MR C | MR C | Application 26
27-MR C | MR C | Application 27
28-MR C | MR C | Application 28
29-MR C | MR C | Application 29
30-MR C | MR C | Application 30
31-MR C | MR C | Application 31
32-MR C | MR C | Application 32
33-MR C | MR C | Application 33
34-MR C | MR C | Application 34
35-MR C | MR C | Application 35
36-MR C | MR C | Application 36
37-MR C | MR C | Application 37
38-MR C | MR C | Application 38
39-MR C | MR C | Application 39
40-MR C | MR C | Application 40
41-MR C | MR C | Application 41
42-MR C | MR C | Application 42
43-MR C | MR C | Application 43
9-Mr A | Mr A | Application ZZ
Spreadsheet: 874708d1721240656-identify-name-when-one-or-more-cells-are-less-than-excel-example
Sheet: Scores

Employee Name | May 2024 | Jun 2024 | Jul 2024 | Avg
[NAME] | 4.2 | 3.433333333333333 | 4.466666666666667
[NAME] | 4
[NAME] | 3.866666666666667 | 4.116666666666666
[NAME] | 4.166666666666667 | 3.8
[NAME] | 3.7 | 3.95 | 4.283333333333333
[NAME] | 3.983333333333333 | 4.016666666666667 | 3.766666666666667
Stephen | 3.983333333333333 | 4.45 | 3.166666666666667
[NAME] | 3.5 | 4.016666666666667 | 3.766666666666667
[NAME] | 4.05 | 3.266666666666667
[NAME] | 4.016666666666667 | 3.283333333333333
Nicole | 3.883333333333333 | 3.416666666666667
[NAME] | 3.25 | 3.65
[NAME] | 3.066666666666667 | 3.783333333333333
[NAME] |  | 3.416666666666667
[NAME] | 2.133333333333333 | 4.666666666666667 | 3.433333333333333
[NAME] | 3.333333333333333 | 3.983333333333333 | 2.733333333333333
[NAME] | 2.466666666666667 | 3.8 | 3.383333333333333
[NAME] | 3.216666666666667 | 3.333333333333333 | 2.933333333333333
Michelle |  |  | 3.083333333333333
Jessica | 2.5 | 3.383333333333333 | 3.316666666666667
Spreadsheet: 764011d1642526721-excel-formula-outcome-is-inadequate-due-to-today-function-book1
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Actual | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | Forecast | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70
 |  |  |  |  |  |  |  |  |  |  |  | Actual+Forecast
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 160 | 225 | 295
Spreadsheet: 164111d1340651915-help-combine-if-and-vlookup-forumlas-or-another-way-of-getting-the-solution-test-formulas_response
Sheet: WKSHT#1

 |  |  |  | Exhibit B
 |  |  |  | worksheet #1
 | Merchant Name:
 | NAICS Code: |  |  |  |  |  | 444210
 | NAICS Description:
 | Annual Bankcard Sales: |  |  |  |  |  | 0
 | Minimum annual growth (10% or higher per HUB's projections) |  |  |  |  |  | 0.1
 | Total Projected sales
 | % of deferred delivery sales |  |  |  |  |  | 0
 | Average number of days of non-delivery risk: |  |  |  |  |  | 0
 | [NAME]. Non-Delivery Risk if merchant goes out-of-business:
 | Normal chargeback and credit return annual risk per NAICS:
 | Discount risk based on an average discount of 2.0%:
 | Gross Merchant Risk
 | less Reserve Amount
 | less Collateral Amount
 | Net Merchant Risk
 | Guaranty (s) required: Yes/No |  |  |  | Conforming Business: Yes/No
 |  |  |  |  | Conforming sales method: Yes/No
 | Collateral required: Yes/No
 | Reserve required: Yes/No
 | ACH Settlement delay:
 | Additional Conditions:
Spreadsheet: jeffrey_a_shankman__13928__JCC Swap Model-DPR (JH)
Sheet: JCC Model Inputs

 | [NAME] |  |  |  | Last Updated | 2001-09-01 00:00:00
 | Constants |  |  |  | Hedge ratios
 | Long-term Model | A | 2.0148084736178 |  | Brent(t) | 0.059 | bbl/bbl JCC
 |  | B | 0.9131348629425 |  | Brent(t-1) | 0.678 | bbl/bbl JCC
 | Error Correction | C | -0.282231790525 |  | Brent(t-2) | 0.246 | bbl/bbl JCC
 | Model | D | 0.058980809626 |  | Brent(t-3) | 0.075 | bbl/bbl JCC
 |  | E | 0.2896827120012 |  | Brent(t-4) | 0 | bbl/bbl JCC
 |  | F | 0.4197978754686 |  | Brent(t-5) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-6) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-7) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-8) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-9) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-10) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-11) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-12) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-13) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-14) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-15) | 0 | bbl/bbl JCC
 |  |  |  |  | [NAME]) | 0 | bbl/bbl JCC
 |  |  |  |  | Brent(t-17) | 0 | bbl/bbl JCC
Spreadsheet: 765432d1643313708-percent-complete-based-off-quantity-finished-and-quantity-remaining-bpm-sample-1-spreadsheet
Sheet: Sheet1

 | Step 1 | Step 2 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8 | Step 9 | Step 10 | Pass | Fail |  | Percent complete
Qty at step | 2 | 0 | 0 | 8 | 4 | 12 | 0 | 0 | 0 | 4 | 0 | 5 |  | ????
Weight based on difficulty | 1 | 2 | 3 | 8 | 6 | 4 | 5 | 9 | 8 | 7
Spreadsheet: 887796d1738124426-fixed-asset-depreciation-v2-fixed-asset-depreciation-v3
Sheet: v2

 | Summary |  | 1 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000 |  | 300000 |  |  |  |  |  |  |  |  |  |  |  |  | Input cells
 | Initial Depreciation | 0.2 |  | 0 | -60000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME] required
 | Annual Depreciation | 0.1 |  | -50000 | -80000 | -80000 | -80000 | -80000 | -80000 | -80000 | -30000 | -30000 | 0 | 0
 | Net Book Value c/f
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000
 | Initial Depreciation
 | Annual Depreciation
 | Net Book Value c/f
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remove this section
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  |  |  | 300000
 | Initial Depreciation
 | Annual Depreciation
 | Net Book Value c/f
 | Further to my post in:
 | https://www.excelforum.com/excel-formulas-and-functions/1432561-fixed-asset-depreciation.html#post6008830
 | I need a formula for Initial Depreciation and Annual Depreciation for the purchase of new assets without having to break down the 2 purchases and then add them up.
Spreadsheet: 129670d1321807349-if-condition-too-complex-testfile
Sheet: Sheet1

 | 1
[NAME]
 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00
Raw Data
 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00
Salaries | 400000 | 415000 | 421000
Wages | 375000 | 381000 | 396000
Office costs | 97428.73216127451 | 107055.176551491 | 103000
Depreciation | 26647.6209577205 | 21998.63847128575 | 31000
Spreadsheet: juan_hernandez__17711__Electricity Price information
Sheet: Sheet3

Year | 1998 | 1999 | 2000 | 2001 | [NAME]. Monthly
Jan |  | 24.23 | 32.48 | 51.15
Feb |  | 19.35 | 27.1 | 36.92
Mar |  | 21.31 | 26.83 | 44.4
Apr |  | 25.05 | 31.54 | 49.43
May | 30.7 | 28.84 | 49.94 | 40.61
Jun | 38.87 | 48.28 | 44.7 | 39.25
Jul | 55.37 | 133.96 | 38.97
Aug | 34.88 | 58.39 | 48.27
Sep | 28.5 | 27.95 | 31.7
Oct | 23.27 | 26.06 | 39.27
Nov | 22.67 | 22.79 | 44.95
Dec | 20.71 | 23.94 | 65.74
Average Yearly
Spreadsheet: 4036312d-3bcc-4e6b-bffd-a58e080e391a
Sheet: Sheet1

Oracle Real-Time Decisions Version 3.0 & 3.0.0.1  Certification Matrix | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
This matrix contains the system requirements for Oracle Real-Time Decisions (Oracle RTD), for both versions 3.0 and 3.0.0.1.  Unless otherwise noted herein, the requirements covered in this matrix apply to all platform and related end-user applications within the Oracle RTD product line.   For more information about Oracle RTD, see the Oracle RTD installation, administration, and user documentation. Documentation for Oracle RTD is available on Oracle Technology Network (OTN), at the Oracle RTD Documentation Library:
[NAME]
 |  | MENU
 |  | Hardware Requirements |  |  |  |  |  |  |  | Click
 |  | Supported and Certified Operating Systems |  |  |  |  |  |  |  | Click
 |  | Supported and Certified Application Servers |  |  |  |  |  |  |  | Click
 |  | Supported Operating Systems for Oracle RTD Client Tools |  |  |  |  |  |  |  | Click
 |  | Supported Web Browsers for Oracle RTD Client Tools |  |  |  |  |  |  |  | Click
 |  | Third Party Client Certification |  |  |  |  |  |  |  | Click
 |  | Supported and Certified Databases |  |  |  |  |  |  |  | Click
 |  | Supported and Certified Data Sources |  |  |  |  |  |  |  | Click
 |  | Supported JDBC Drivers |  |  |  |  |  |  |  | Click
 |  | Ancillary Programs |  |  |  |  |  |  |  | Click
 |  | Third Party License Agreements |  |  |  |  |  |  |  | Click
 |  | Product and Platform Availability Updates |  |  |  |  |  |  |  | Click
 |  | System Requirements and Specifications (Oracle Fusion Middleware) |  |  |  |  |  |  |  | Click
 |  | Release Notes |  |  |  |  |  |  |  | Click
 |  | Document Control |  |  |  |  |  |  |  | Click
Spreadsheet: 8e8a71e1-016b-49c8-a067-5617a4e80b64
Sheet: Attachment B2

 |  |  | STATE OF ARKANSAS
 |  |  | REQUEST FOR QUALIFICATION FOR PCMH CARE COORDINATION SUPPORT
 |  |  | RFQ NO: SP-13-0162
Attachment B2. Worksheet: Readiness for staffing
Instructions
Complete this worksheet to document your evidence demonstrating your ability to provide the level of staffing necessary to match the PCMH rollout timeline.  DHS/DMS expects that most respondents will not currently have staff available, trained, and in Arkansas ready to execute on PCMH.  The figures entered should be with reference to this PCMH effort in Arkansas, and not any other client service work.  The entirety of Attachment B will be scored based on the breakdown described in Section 4.1: Technical Proposal Requirements.
 |  |  |  |  |  |  | Percent of employees with the following qualifications
 | Planned total number of employees | No. of candidates with letters of intent | No. hired | Percent hired who are from Arkansas | Percent of hires who are trained | No. trained and available for deployment | RN license | Case management experience | Experience coordinating across medical neighborhoods | Clinical experience | Planned ratio per practice
Job type | (#) | (#) | (#) | (%) | (%) | (#) | (%) | (%) | (%) | (%) | (FTE: practice ratio)
Care coordinators
Health coaches / care navigators
Subject matter experts: Social workers
Subject matter experts: Pharmacists
Subject matter experts: Behavioral health
Community health worker
Other: ___________________
Other: ___________________
Spreadsheet: 886329d1736351826-robust-index-match-w-non-tabular-data-test-file-1-etaf
Sheet: Raw Data

Year-Week | Item # | Item Name | POS QTY | POS SALES
202401 | 12345 | Orange Pen | 5 | 1
202401 | 67890 | Blue Rock | 9 | 5
202401 | 54321 | Apple Pie | 3 | 8
Spreadsheet: 187123d1350343928-need-to-return-a-value-that-might-be-in-the-row-above-or-the-row-below-help-sample-stats
Sheet: Week 6 Result

[NAME] | 64.56 | Match Up
[NAME] | 98.42
JagerBombs | 82.58 | Match Up
[NAME] | 93.28
Smokin Chalerias | 63.56 | Match Up
Don't Tase Me Bro! | 78.94
Sunday Schoolers | 66.3 | Match Up
ThunderStorm | 94.42
[NAME] | 83.22 | Match Up
Rainbow Nation | 113.72
Rapid City Warhawks | 69.84 | Match Up
[NAME] | 107.9
Spreadsheet: 196e12d3-a5a6-4f84-98b1-f3967f457a58
Sheet: Sheet1

FY 2013 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | SEPT | REMAINING
1 | [NAME] 1 | 12252023 | 1225203 | 1225203 | 11026820
5 | PRAIRIE LAKES AEA 8 | 12262873 | 1226292 | 1226292 | 11036581
7 | AEA 267 | 25621579 | 2562162 | 2562162 | 23059417
9 | MISSISSIPPI BEND AEA 9 | 18256425 | 1825645 | 1825645 | 16430780
10 | GRANT WOOD AEA 10 | 25694279 | 2569428 | 2569428 | 23124851
11 | HEARTLAND AEA 11 | 47311975 | 4731203 | 4731203 | 42580772
12 | NORTHWEST AEA | 15237716 | 1523774 | 1523774 | 13713942
13 | GREEN HILLS AEA 13 | 14922450 | 1492246 | 1492246 | 13430204
15 | GREAT PRAIRIE AEA 15 | 13628215 | 1362826 | 1362826 | 12265389
 |  | 185187535 | 18518779 | 18518779 | 166668756