tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 680477d1591040735-inverting-non-square-matrix-for-bootstrapping-spot-rates
Sheet: Sheet1

Given yield curve:
Time | t0 | t1 | t2 | t3 | [NAME]
[NAME] | -100 | 105 | 0 | 0 | 0
[NAME] | -100 | 6 | 106 | 0 | 0
[NAME] 3 | -100 | 7 | 7 | 107 | 0
[NAME] | -100 | 8 | 8 | 8 | 108
These are are so-called coupon bonds; clearly the YTM (yield-to-maturiy/IRR) is: 5%, 6%, 7% and 8%, respectively
With a price at 100, all bonds are priced at par (Par-Bonds)
I now want to construct a zero coupon curve (spot rate curve) from these bonds
The usual tehnique is called bootstrapping
I would like to achieve this with linear algebra, so should be able with standard matrix multiplication techniques
Bootstrapping basically calculates forward rates from the given yield curve and then calculates the spot rates under a no arbitrage condition
Let fi,j be the forward rate from period i to j |  |  |  |  | i ≠ j, i < j
let s0,j be the spot rate for period j |  |  |  |  | j = {1;2;3;4}
Therefore: | f0,1 =  s0,1 | =
 | f1,2 | = |  |  |  | Check: |  | ensure value equality (no arbitrage) between a 2 yr. coupon bond and the the yr. bond which is then reinvested at the TBD forward rate for another year
 | s0,2 | = |  |  |  | Check: |  | equals a 2-yr. zero coupon bonds
 | etc.
Solving with linear algebra
 |  | Coefficient Matrix (A) |  |  |  |  | Constant Matrix (B)
 |  |  | 0 | 0 | 0
 |  | 6 | 106 | 0 | 0 |  | 100
 |  | 7 | 7 | 107 | 0 |  | 100
 |  | 8 | 8 | 8 | 108 |  | 100
 |  | Let X be the variable matrix
 |  | When A * X = B, then X = A-1 * B |  |  | (assumes A is a square matrix and invertible)
 |  | Inverse of A |  |  |  |  | = equivalent discount factors 1/(1+s0,j)j |  |  |  |  | Check | Alt. 2
 |  |  | 0 | 0 | 0 |  |  |  |  |  | = s0,1
 |  | -0.0005390835579514824 | 0.009433962264150943 | 0 | 0 |  | 0.889487870619946 |  | 0.06030298700061398 |  | = s0,2
 |  | -0.0005877858108505261 | -0.0006171751013930523 | 0.009345794392523364 | 0 |  | 0.8140833480279784 |  | 0.07096935222764222 |  | etc.
 |  | -0.0006219955670375937 | -0.0006530953453894733 | -0.0006922810661128418 | 0.009259259259259259 |  | 0.7291887280719349 |  | 0.08215635286707967
Now assume non-square matrix, e.g. only 1-, 2- and 4- yr. bonds given
Term
1
3
4
 |  | Multiply with Transpose of A to create square matrix
 |  | AT * A |  |  |  |  | AT * B
 |  |  | 700 | 64 | 864
 |  | 700 | 11300 | 64 | 864 |  | 11400
 |  | 64 | 64 | 64 | 864 |  | 800
 |  | 864 | 864 | 864 | 11664 |  | 10800
 |  | Solution??? |  |  |  |  |  | why is this solution different than above for s0,1?
 |  |  |  |  |  |  | 0.8968445148849467 | why is this solution different than above for s0,2?
 |  | Is AT * A invertible? |  |  |  |  | 0 | do these mean there's no unambiguous solution for s0,3 and s0,4?
 |  |  |  |  |  |  | 1 | do these mean there's no unambiguous solution for s0,3 and s0,4?
 |  |  | -5.134129123347453e-06 | 0 | -1.123595505617978e-05
 |  | -5.134129123347452e-06 | 8.929025508387764e-05 | 0 | -5.552616342909621e-06
 |  | 1.742800744941745e-05 | -8.415612596053017e-05 | 118747255799808 | -8796093022208 | do these results make sense?
 |  | -7.62939453125e-06 | 0 | -8796093022208 | 651562446089.4816
Spreadsheet: 783077d1654559787-need-adjacent-cell-data-from-max-value-cell-address-adjacent-cell-data
Sheet: Sheet1

Project Name | Test A1 Date | Test A1 Outcome | Test A2 Date | Test A2 Outcome | Test B1 Date | Test B1 Outcome | Test B2 Date | Test B2 Outcome | Max Test Date | [NAME]
A | 2022-01-01 00:00:00 | Success |  |  | 2022-01-15 00:00:00 | Success
B | 2022-01-02 00:00:00 | Failure | 2022-02-02 00:00:00 | Failure
C | 2022-01-01 00:00:00 | Failure | 2022-02-01 00:00:00 | Success | 2022-02-15 00:00:00 | Failure | 2022-03-15 00:00:00 | Success
D | 2022-01-01 00:00:00 | Success |  |  | 2022-01-15 00:00:00
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 650 | 589
2 | 625 | 589
3 | 616 | 589
4 | 599 | 589
5 | 595 | 589
6 | 616 | 589
7 | 629 | 589
8 | 662 | 589
9 | 681 | 589
10 | 711 | 589
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 148916.73
2001-12-10 00:00:00
CBS Volume
 |  |  | 28495
Spreadsheet: 48f85cc7-2e09-487b-8fce-12aa07ffce1b
Sheet: INVENTORY

White Whale Web Services
Washington College website content review
Site Inventory Worksheet
Step One: Inventory
Click through every page in your site. I know it seems daunting, but if it’s not you, someone else out there is doing it and finding those things you’d rather not see.
Page name (URL) | Topics Covered | Is this info listed elsewhere on the WC site? | All links checked | Can the info on this page be combined with another page? | Would the info here be more effective as or complemented by a news story, blog, photo, video, or event listing?
Page name (URL) | Topics Covered | Is this info listed elsewhere on the WC site? | All links checked | Can the info on this page be combined with another page? | Would the info here be more effective as or complemented by a news story, blog, photo, video, or event listing?
Page name (URL) | Topics Covered | Is this info listed elsewhere on the WC site? | All links checked | Can the info on this page be combined with another page? | Would the info here be more effective as or complemented by a news story, blog, photo, video, or event listing?
Spreadsheet: 836123d1689107925-dividing-currency-across-several-cells-sampleallocation
Sheet: Sheet1

2023 Budget Allocation
 | 2021 | Appraisal | Appraisal | Collection | Collection | 2023
 | [NAME] | Budget % | Budget Amt | Budget % | Budget Amt | Total Due
County | 1346118.7 | 0.43 | 49123.16 | 0.4533 | 24265.77
2023 Allocations | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Total
County
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: JULY 4

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-07-04 00:00:00 | 2011-07-05 00:00:00 | 2011-07-06 00:00:00 | 2011-07-07 00:00:00 | 2011-07-08 00:00:00 | 2011-07-09 00:00:00
[NAME] | holiday | off | 8:00-5:00 | 8:30-5:30 | 8:30-5:30 | 9:15-5:15
 |  |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 39
[NAME] | holiday | vacation | vacation | vacation | vacation
 |  |  |  |  |  |  | 40
Ray | holiday | 8:00-4:00 | 8:00-5:30 | 7:00-4:00 | 8:00-5:00
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | off | 39.5
Mark | holiday | 9:30-5:30 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:00
 |  | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00 | 39
[NAME] | holiday | 8:30-5:30 | off | 7:00-4:00-HOMER | 8:30-5:30 | 9:15-5:15-ctr
ctr 12-2 |  | 11:00-12:00 |  | 1ub | 11:00-12:00 | 11:00-12:00 | 39
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00 | 15
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours | 211.5
Spreadsheet: 828629d1683645248-while-using-xlookup-the-first-2-lines-work-than-it-stops-testboox
Sheet: electricityOutLow

Datum | value (kWh)
2022-01-01 01:00:00 | 1.41955055799999
2022-01-01 02:00:00 | 2.247197391
2022-01-01 03:00:00 | 2.574851957
2022-01-01 04:00:00 | 0.069572764
2022-01-01 05:00:00 | 0
2022-01-01 06:00:00 | 0
2022-01-01 07:00:00 | 0
2022-01-01 08:00:00 | 0
2022-01-01 09:00:00 | 0
2022-01-01 10:00:00 | 0
2022-01-01 11:00:00 | 0
2022-01-01 12:00:00 | 0
2022-01-01 13:00:00 | 1.840630418
2022-01-01 14:00:00 | 3.416205384
2022-01-01 15:00:00 | 3.244140541
2022-01-01 16:00:00 | 0
2022-01-01 17:00:00 | 0
2022-01-01 18:00:00 | 0.432603896
2022-01-01 19:00:00 | 2.251169045
2022-01-01 20:00:00 | 3.3671111
2022-01-01 21:00:00 | 3.058103752
2022-01-01 22:00:00 | 3.188879973
2022-01-01 23:00:00 | 3.35416561
2022-01-02 00:00:00 | 2.002398208
2022-01-02 01:00:00 | 0.020372437
2022-01-02 02:00:00 | 0
2022-01-02 03:00:00 | 0
2022-01-02 04:00:00 | 0
2022-01-02 05:00:00 | 0
Spreadsheet: 177465d1346319113-return-last-column-last-column
Sheet: Sheet1

 | Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | Current | 210 | 742 | 63 | 366 | 577 | 667 | 549 | 21 | 799 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0-30 Days overdue | 291 | 597 | 197 | 361 | 522 | 847 | 26 | 237 | 220 | 557 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 31-60 Days overdue | 728 | 603 | 315 | 113 | 603 | 216 | 354 | 91 | 283 | 671 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 61-90 Days overdue | 214 | 813 | 72 | 679 | 143 | 479 | 428 | 799 | 494 | 662 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Over 90 Days overdue | 875 | 788 | 263 | 33 | 548 | 276 | 575 | 521 | 674 | 154 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Current Provision | 444 | 427 | 229 | 124 | 775 | 185 | 248 | 104 | 445 | 858 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0-30 Days Provision | 354 | 703 | 777 | 389 | 542 | 316 | 559 | 709 | 247 | 444 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 30+ Days Provision | 171 | 9 | 523 | 354 | 421 | 449 | 10 | 403 | 459 | -16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Current
 | 0-30 Days overdue
 | 31-60 Days overdue
 | 61-90 Days overdue
 | Over 90 Days overdue
 | Current Provision
 | 0-30 Days Provision
 | 30+ Days Provision
Spreadsheet: chris_germany__1960__ENA-Reliant Prepay
Sheet: Summary

ENA Prepays to Reliant
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 |  |  | Prepayment
 |  | Date | (Purchases) | Comments
 | Wed | 2002-02-06 00:00:00 | 22500
 | Fri | 2002-02-08 00:00:00 | 20000
 | Thu | 2002-02-14 00:00:00 | 26000
 | Thu | 2002-02-21 00:00:00 | 10000
 | Thu | 2002-02-28 00:00:00 | 19000
 |  | Total Prepays Feb 2002
 |  | Feb 2002 Swing Purchases
 |  | Cash Balance on 2/28/02
 | Wed | 2002-03-06 00:00:00 | 42000
 | Thu | 2002-03-14 00:00:00 | 25000
 | Thu |  | 30000 | 3/22/02 9:00AM  verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 40000 | To be applied to Prepayment for FGT and TRKL swing activity.  3/29/02  2:45 PM verfied payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 701760 | To be applied to Apr 2002 Baseload Purchase on Trunkline.  3/29/02 2:45 PM verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 989700 | To be applied to Apr 2002 Baseload Purchase on Florida.  3/29/02 2:45 PM verified payment with [NAME].
 |  | Total Prepays Mar 2002
 |  | Mar 2002 Swing Purchases
 |  | Cash Balance on 3/31/02
 | Thu | 2002-04-04 00:00:00 | 37000 | 4/8/02 1:45 PM verified payment with [NAME]
 | Thu |  | 0
 | Thu |  | 0
 | Thu |  | 0
 |  | Total Prepays Apr 2002
 |  | Apr 2002 Baseload Purchase on Trunkline |  | Sitara #1202698
 |  | Apr 2002 Baseload Purchase on Florida |  | Sitara #1203148
 |  | Apr 2002 Swing Purchases |  | Sitara #1203186
 |  | Total Apr 2002 Purchases
 |  | Current Cash Balance
Spreadsheet: 66884d1267561595-sum-values-based-on-multiple-criteria-comma-delimited-in-a-single-cell-sample
Sheet: target

dept | code set | month | total |  | should be
 | Z31 | january |  |  | 80271
DEPT OF ANESTHESIOLOGY | Z31 | february |  |  | 63134
DEPT OF GYN/OB | Z31 | march |  |  | 15346
DEPT OF EMERGENCY MEDICINE | Z31 | april |  |  | 1791
Spreadsheet: 713666d1610872584-how-can-i-make-calculations-on-specific-rows-book1
Sheet: Sheet1

 |  |  | result1 | [NAME]
1 | -99.958 | -28.8493
2 | -71.5378 | -26.7728
3 | -91.6913 | -40.9039
4 | -69.0989 | -12.9501
5 | -79.6443 | -9.20575
6 | -92.1975 | -20.0276
7 | -99.7732 | -14.2607
8 | -80.3767 | -18.1604
9 | -84.6001 | -14.448
10 | -77.9438 | -19.9783
11 | -78.1061 | -20.1301
12 | -84.2685 | -0.17871
13 | -112.111 | 11.0797
14 | -81.7635 | -22.4987
15 | -106.101 | 4.03345
16 | -74.0009 | 12.8209
17 | -124.057 | 22.0852
18 | -113.385 | 29.6869
19 | -96.8629 | 9.03771
20 | -76.8913 | -21.2576
21 | -79.5837 | 6.36682
22 | -77.9276 | 5.52165
23 | -101.614 | 78.0871
24 | -129.132 | 58.162
25 | -150.789 | 61.9639
26 | -113.644 | 60.4537
27 | -135.757 | 53.8951
28 | -122.641 | 63.0188
Spreadsheet: 35385d1232992489-excel-2007-dropdown-different-sums-possible-p47-2009
Sheet: Sheet1

Vārds: | Nadežda [NAME]
Dzīvokļa nr. |  | [NAME] aprēķins
Dzīvokļa platība: |  | Datums | Īres maksa | Ūdens un kanalizācija | [NAME] elektrība | Patērētā elektrība | Īpašuma nodoklis | [NAME] | CAS izvešana | ASU | ŪTA | Dzīvnieku [NAME] | Šķūnis/ pieliekamais | Jāmaksā
Iedzīvotāju skaits: |  | [NAME]
Īres/apsaimn. Maksa: |  | [NAME]
Elektrība 1kw: | 0.071 | Marts
Ūdens 1m3 | 0.72 | Aprīlis
L&T : | 1.18 | Maijs
[NAME] | 0.0388 | Jūnijs
Dzīvnieki |  | [NAME]
Šķūnis: |  | Augusts
Pieliekamais: |  | [NAME]
 |  | [NAME]
 |  | Novembris
 |  | Decembris
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: 60 20 20 RMS

DGB20 for Coffs Council
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | 20mm Roadbase | White Roadbase | Pit Fines | 10mm | Crun 210513 | Ammd 20mm Scalps | ROSA | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 114.9310344827586 | 100 | 100 | 14.93103448275862
19 | 99 | 100 | 100 | 100 | 99 | 100 | 100 | 114.2265517241379 | 95 | 100 | 14.22655172413795 | 0.7044827586206708
13.2 | 86 | 86 | 100 | 100 | 89 | 90 | 100 | 101.9544827586207 | 78 | 92 | 9.9544827586207 | 12.27206896551725 | 6 | 18 | 0
9.5 | 69 | 68 | 100 | 87 | 75 | 72 | 100 | 85.9748275862069 | 63 | 83 | 2.974827586206899 | 15.9796551724138 | 7 | 17 | 0
6.7 | 54 | 54 | 100 | 28 | 59 | 57 | 100 | 72.29379310344827 | 50 | 70 |  |  | 10 | 21
4.75 | 42 | 42 | 100 | 7 | 45 | 46 | 100 | 61.17103448275862 | 44 | 64 | 0 | 24.80379310344828 | 13 | 25 | 0
2.36 | 26 | 29 | 100 | 2 | 26 | 30 | 100 | 47.00793103448277 | 33 | 49 | 0 | 14.16310344827586 | 7 | 19 | 0
0.425 | 11 | 17 | 65 | 0 | 8 | 8 | 100 | 25.98724137931034 | 14 | 23 | 2.987241379310344 | 21.02068965517242 | 14 | 30 | 0 |  | 55.28267423692259
0.075 | 5.5 | 12 | 35 | 0 | 3 | 4 | 100 | 14.32810344827586 | 7 | 14 | 0.3281034482758631 | 11.65913793103448 | 6 | 13 | 0 |  | 55.13514589387366 | 0.5513514589387365
0.0135 | 3.5 | 6 | 17 | 0 | 1 | 2 | 40 | 7.581206896551725 | 3 | 7 | 0.5812068965517252 | 6.746896551724138 | 3 | 8 | 0 |  | 52.91144724017184
PI | 0 | 7 | 0 |  |  |  |  | 1.018470602284941
Ratio | 61.29 | 19.35 | 19.35 | 0 | 0 | 0 | 0 | 87
 | Raw Feed | Dust | White | Pit Fines
 | 48 | 12 |  | 20
 | 16.6 |  | 3.3
 | 64.6 | 12 | 3.3 | 20
 | 19.57575757575757 | 3.636363636363637 | 1 | 6.060606060606061
 | 20 | 4 | 1 | 6 | 31
 | 64.51612903225806 | 12.90322580645161 | 3.225806451612903 | 19.35483870967742 | 100
 | 16.12903225806452 |  | 16.12903225806452
 | 48.38709677419355
 | 61.29032258064517 |  | 19.35483870967742 | 19.35483870967742 | 100
Spreadsheet: 300764d1393558249-matching-duplicatess-correspondng-value-book1
Sheet: Sheet1

Name | Class
Alpha | A
Beta | B
[NAME] | C
Delta | D
Echo | E |  | My intended result
Alpha | F |  |  | Class 1 | Class 2
Beta | G |  | Alpha | A | F
 |  |  | Beta | B | G
Spreadsheet: 674315d1587752693-adding-to-running-total-and-applying-carryover-rules-for-time-off-accruals-testingaccruals
Sheet: Sheet1

Name | Vacation | StartDate | YearsWorked | NextAnniversary | HoursPerYearToBeGiven
[NAME] |  | 2019-10-08 00:00:00
[NAME] |  | 2008-09-15 00:00:00
[NAME] |  | 2016-04-22 00:00:00
[NAME] |  | 2018-12-09 00:00:00
Spreadsheet: 832557d1686430618-xirr-show-return-every-month-along-life-of-an-investment-xirr
Sheet: Sheet1

ACCOUNT
DATE | ACCOUNT VALUE | CASH (IN)/OUT | XIRR
2021-05-17 00:00:00 | 250000 | -250000
2021-06-01 00:00:00 | 250000.96 | 0
2021-06-14 00:00:00 |  | -69020.35
2021-07-01 00:00:00 | 318529.48 | 0
2021-08-01 00:00:00 | 320375.41 | 0
2021-09-01 00:00:00 | 325669.94 | 0
2021-09-17 00:00:00 |  | 0
2021-10-01 00:00:00 | 313940.22 | 0
2021-11-01 00:00:00 | 329559.11 | 0
2021-11-10 00:00:00 |  | -10000
 | 332602.54 | 0
 | 343930.85 | 0
 | 326661.15 | 0
 | 321087.29 | 0
 | 325883.26 | 0
2022-04-13 00:00:00 |  | 51500
 | 252582.59 | 0
 | 253731.72 | 0
 | 234115.87 | 0
 | 252041.4 | 0
 | 242512.17 | 0
 | 221260.51 | 0
 | 236149.09 | -15000
 | 266498.04 | -10000
 | 275187.31 | -12000
 | 304876.76 | 0
 | 298423.61 | 0
 | 306798.48 | 0
 | 308715.74
Spreadsheet: 809850d1671374303-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01-1-
Sheet: GL-MO 4

General Ledger
Account # / Date | Item Description | Ck# | EXPENSES | INCOME | Balance
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Expenses:
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Beginning Balance
 | Total
 | Monthly beginning total |  | Total Debits | Total Credits
 | Total debits & credits
 | Monthly End Total
Spreadsheet: 7c624cc5-a107-4d43-9cf7-122169201516
Sheet: Sheet1

Last Name | Unnamed: 1 | First Name | Unnamed: 3 | DOB | Unnamed: 5 | ID#
School |  | Current Grade |  | Teacher |  | Additional Support  Yes    No
Initial PLP Date |  | Grade initiated
Data Analysis
Word ID | _________ | Letter ID | ____/26 | Sound ID | ____/26 | Date
Word ID | _________ | Letter ID | ____/26 | Sound ID | ____/26 | Date
Word ID | _________ | Letter ID | ____/26 | Sound ID | ____/26 | Date
Developmental Reading Assessment (DRA) |  | Level/Date |  | Level/Date |  | Level/Date
Fountas and Pinnell Instructional Level |  | Level/Date |  | Level/Date |  | Level/Date
State Assessment Results |  | Score/Date |  | Score/Date
ELL Proficiency (ESL Students) |  | Score/Date |  | Score/Date
Strengths and Instructional Needs
Date | Element of Literacy |  | Strengths |  |  | Instructional Needs
 | Oral Language
 | Phonemic Awareness
 | Phonics
 | Fluency
 | Vocabulary Development
 | Text Comprehension
 | Writing
Current Classroom Instructional Strategies
History of Parent Communication
Date | Letter/Email |  | Conference |  | Phone Contact
 |  |  | Action Plan
Last Name |  | First Name |  | DOB |  | ID#
Service Provider | (Print Name) |  |  |  | Position
Goals and Strategies
Date | Progress Goal (based on Instructional Need |  | Strategies/Materials |  |  | Duration/Frequency
Home/School Connection
Date | Progress Goal (based on Instructional Need |  | Recommended Strategy |  |  | Contact Method
Progress Monitoring and Intervention Results
Date | Assessment |  |  | Results
Check the appropriate box. Make any appropriate notations.
Date | No PLP | New PLP |  | New PLP with Intensive Student Data Review              Consideration for Additional Support
Spreadsheet: 544774d1509025107-index-and-match-formula-with-multiple-criteria-sample-workbook-for-payroll
Sheet: Report

 | Department Head | Department | Month | Salary
 | A | Human Resource | Jan | 5
 | A | Finance | Feb | 9
 | A | Account | Mar | 16.2
 | A | IT | Apr | 29.16
 | A | Software Development | May | 52.49
 | B | Human Resource | Jan | 37.97
 | B | Finance | Feb | 68.34
 | B | Account | Mar | 123.02
 | B | IT | Apr | 221.43
 | B | Software Development | May | 398.58
Spreadsheet: 112205d1308318250-simplify-a-complex-formula-sample1
Sheet: April

April Numbers as of  06/07/2011
Name | # | W1 | [NAME] | U1 | U2 | EMS | Com. | Total
name | 10 | 42513 | 65483.3
name | 7 | 12345 | 67894
name | 20 | 65483.3 | 12345
name | 16 | 65483.3 | 12166
name | 13 | 65483.3 | 5495.12
name | 9 | 42513 | 2654.12 |  | 5495.12
name | 8 | 32156 | 1245 | 1245 |  | 5
name | 23 | 12345 | 21654
name | 24 | 12345 | 12345
---------------------------------------------------------------------------------
name | 21 | 1245 | 1245 | 1245 | 1245 | 6842 | 2654.12
name | 22 |  |  | 1245 | 1245 | 6548
 |  |  |  |  | W Total
 |  |  |  |  | U, EMS, & Com Total
 |  |  |  |  | TOTAL
Spreadsheet: 753136d1635264871-reduce-quantities-stock-quantity-replacement-by-order-lyla22-
Sheet: Sheet1

 |  |  | Stock ID |  | 23 | 23 | 24 | 25 | 26 | 26
RAW ORDER DATA |  |  | Available |  | 200000 | 300000 | 100000 | 50000 | 100000 | 100000 |  |  | RAW BATCH DATA |  |  |  |  | DESIRED OUTPUT:
 |  |  | [NAME] |  | 777 | 666 | 222 | 999 | 1234 | 4567
Stock ID | Order No | [NAME] | Order Date |  |  |  |  |  |  |  | Sufficient Stock |  | Stock ID | Available | [NAME] |  |  | Stock ID | [NAME] | Order Date | Proposed Allocation | [NAME]
23 | 1 | 100000 | 2021-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | 23 | 200000 | 777 |  |  | 23 | 100000 | 2021-04-01 00:00:00 | 100000 | 777
23 | 2 | 150000 | 2021-05-01 00:00:00 |  |  |  |  |  |  |  |  |  | 23 | 300000 | 666 |  |  | 23 | 150000 | 2021-05-01 00:00:00 | 100000 | 777
23 | 3 | 50000 | 2021-05-20 00:00:00 |  |  |  |  |  |  |  |  |  | 24 | 100000 | 222 |  |  |  |  |  | 50000 | 666
23 | 4 | 25000 | 2021-05-26 00:00:00 |  |  |  |  |  |  |  |  |  | 25 | 50000 | 999 |  |  | 23 | 50000 | 2021-05-20 00:00:00 | 50000 | 666
23 | 5 | 150000 | 2021-05-27 00:00:00 |  |  |  |  |  |  |  |  |  | 26 | 100000 | 1234 |  |  | 23 | 25000 | 2021-05-26 00:00:00 | 25000 | 666
24 | 6 | 50000 | 2022-08-01 00:00:00 |  |  |  |  |  |  |  |  |  | 26 | 100000 | 4567 |  |  | 23 | 150000 | 2021-05-27 00:00:00 | 150000 | 666
24 | 7 | 100000 | 2022-09-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 50000 | 2022-08-01 00:00:00 | 50000 | 222
24 | 8 | 10000 | 2022-12-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 100000 | 2022-09-08 00:00:00 | 0 | Insufficient Stock
25 | 9 | 40000 | 2023-02-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 10000 | 2022-12-05 00:00:00 | 0 | Insufficient Stock
25 | 10 | 15000 | 2023-05-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 40000 | 2023-02-05 00:00:00 | 40000 | 999
26 | 11 | 140000 | 2023-08-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 15000 | 2023-05-08 00:00:00 | 0 | Insufficient Stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 150000 | 2023-08-08 00:00:00 | 100000 | 1234
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000 | 4567
Spreadsheet: 266826d1379770572-how-to-one-text-be-converted-to-another-example-1-
Sheet: Sheet1

 | Codes | lukarts code |  | Use Below Formula and Add conditions you want
 | MI-ACCMED
 | DG-CCSS-1104 | DG-CCSS-1104
 | EDG-CCSS-1104 | DG-CCSS-1104
 | MI-SACW
 | MI-ADCENT
 | MI-MIAMS | MI-MIAMS
 | MI-MIAMSHC | MI-MIAMS
 | MI-MIAMSNT | MI-MIAMS
 | MI-MIAMSNAF | MI-MIAMS
 | MI-MIAMSWBS | MI-MIAMS
 | MI-ADNGS
 | MI-PESEM
Spreadsheet: 827361d1682627693-sumif-for-same-column-value-in-one-and-different-value-in-another-sumifs-etaf
Sheet: Sheet1

[NAME] | 1980-05-01 00:00:00 | 50
[NAME] | 1980-05-01 00:00:00 | 20
[NAME] | 1981-08-02 00:00:00 | 10
[NAME] | 1978-04-12 00:00:00 | 25
[NAME] | 1990-05-05 00:00:00 | 30
[NAME] | 1990-05-05 00:00:00 | 50
Pity Foo | 1965-03-04 00:00:00 | 15
Pity Foo | 1956-04-03 00:00:00 | 20