tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 886985d1737057445-cells-need-to-trigger-changes-in-graph-2025-chart
Sheet: 20% (Year1999)

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

 | Score |  |  |  | Absolute Strengths | Absolute development Areas | Relative Strengths | Relative development areas
1 | 6.7
2 | 6.7
3 | 5.8
4 | 7.25
5 | 5.5
6 | 6.2
7 | 7.5
8 | 6.625
9 | 5.375
10 | 6.5
11 | 7.083333333333333
12 | 5.785714285714286
13 | 7
14 | 7.25
15 | 5.916666666666667
16 | 6.4
17 | 5.928571428571429
18 | 6.75
19 | 5.625
20 | 6.214285714285714
21 | 7.125
22 | 6.428571428571429
23 | 5.8
24 | 7.05
Spreadsheet: 873769d1720337202-how-to-find-total-of-working-hours-from-a-single-cell-2024
Sheet: july

[NAME] | 31 |  |  | ΡΕΠΟ
ΞΕΚΙΝΑΕΙ | 2024-07-01 00:00:00
ΒΗΜΑ | 1
 | ΙΟΥΛΙΟΣ |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ |  |  | [NAME] ΡΑΦΑΕΛΑ | KROSHKINA MARIA | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
 |  | 11.00-22.00 |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-22.00 | 15-00-21.00 |  | 11 hoursand 00 minutes
 | 2024-07-02 00:00:00 | 09.30-22.00 |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00 |  |  |  |  |  |  |  |  | 9 hours 00 minutes
 | 2024-07-03 00:00:00 | 09.30-22.00 |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00
 | 2024-07-04 00:00:00 | ΟΡΘΟΠΑΙΔΙΚΟΣ |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.00 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00
 | 2024-07-05 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09.00-17.00 | 11.00-17.00 | 16.00-22.01 | 09.00-22.00 | 17.00-22.00 | 09.00-13.00  &  17.00-22.00 | 16-00-21.00
 | 2024-07-06 00:00:00 | ΔΕΝ ΗΡΘΕ |  | 09.00-17.00 | 11.00-17.00 | ΡΕΠΟ | 09.00-22.00 | 17.00-22.00 | 09.00-22.00 | 16-00-21.00
 | 2024-07-07 00:00:00 | ΔΕΝ ΗΡΘΕ |  | ΡΕΠΟ | ΡΕΠΟ | 10.00-18.00 | 10.00-18.00 | ΡΕΠΟ | 10.00-18.00 | ΡΕΠΟ
 | 2024-07-08 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-10 00:00:00
 | 2024-07-11 00:00:00
 | 2024-07-12 00:00:00
 | 2024-07-13 00:00:00
 | 2024-07-14 00:00:00
 | 2024-07-15 00:00:00
 | 2024-07-16 00:00:00
 | 2024-07-17 00:00:00
 | 2024-07-18 00:00:00
 | 2024-07-19 00:00:00
 | 2024-07-20 00:00:00
 | 2024-07-21 00:00:00
 | 2024-07-22 00:00:00
 | 2024-07-23 00:00:00
 | 2024-07-24 00:00:00
 | 2024-07-25 00:00:00
 | 2024-07-26 00:00:00
 | 2024-07-27 00:00:00
 | 2024-07-28 00:00:00
 | 2024-07-29 00:00:00
 | 2024-07-30 00:00:00
 | 2024-07-31 00:00:00
Spreadsheet: 764313d1642687792-variable-sheet-name-in-vlookup-test-3-etaf
Sheet: MASTER

 | CODE | [NAME] | CODE FOURNISSEUR | FOURNISSEUR | PART # | LAST PRICE
 | AAA-0001 | TUBE ABS 2'' X 12' | 1
 | AAA-0002 | TUBE ABS 3'' X 12' | 1
 | AAA-0003 | TUBE ABS 4'' X 12' | 1
 | AAA-0004 | TUBE ABS 5'' X 12' | 1
 | AAA-0005 | TUBE ABS 6'' X 12' | 2
 | AAA-0006 | TUBE ABS 7'' X 12' | 2
Spreadsheet: 715442d1611705998-formula-for-selecting-one-of-24-option-log-on-formula
Sheet: Sheet2

Name1 | surname1 |  |  |  |  | 1 |  |  |  |  |  |  | noemail.co.uk
[NAME] | surname2 |  |  |  |  | 1 |  |  |  |  |  |  | ihss.co.uk
Name3 | surname3 |  |  |  |  | 1
Name4 | surname4 |  |  |  |  | 1
Name5 | surname5 |  |  |  |  | 1
Name6 | surname6 |  |  |  |  | 1
Name7 | surname7 |  |  |  |  | 1
Name8 | surname8 |  |  |  |  | 1
Name9 | surname9 |  |  |  |  | 1
Name10 | surname10 |  |  |  |  | 1
Name11 | surname11 |  |  |  |  | 1
Name12 | surname12 |  |  |  |  | 1
Name13 | surname13 |  |  |  |  | 1
Name14 | surname14 |  |  |  |  | 1
Name15 | surname15 |  |  |  |  | 1
[NAME] | surname16 |  |  |  |  | 1
Name17 | surname17 |  |  |  |  | 1
Name18 | surname18 |  |  |  |  | 1
Name19 | surname19 |  |  |  |  | 1
[NAME] | surname20 |  |  |  |  | 1
Name21 | surname21 |  |  |  |  | 1
Name22 | surname22 |  |  |  |  | 1
Name23 | surname23 |  |  |  |  | 1
Name24 | surname24 |  |  |  |  | 1
Spreadsheet: 105814d1303113584-display-data-from-1-sheet-to-another-sheet-automatically-sample
Sheet: Cork

4:25  Cork | Cork | Hurdle
4:55  Cork | Cork | Hurdle
5:25  Cork | Cork | Hurdle
5:55  Cork | Cork | Hurdle
6:25  Cork | Cork | Hurdle
6:55  [NAME] | Cork | Flat
2:25  Cork | Cork | Hurdle
2:55  [NAME] | Cork | Hurdle
3:25  Cork | Cork | Chase
Spreadsheet: 707435d1607275214-using-a-list-to-reduce-worksheets-copy-of-midshires-master
Sheet: master

1 | PLAYER | Playing Handicap | Official Handicap | Exact handicap | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Par 3 | Adjusted stableford points | Official [NAME] points | Handicap Alteration (Official) | Handicap Alteration (Unofficial) |  |  |  |  |  | Stroke Index
1 |  |  |  |  | PAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted H'Caps |  |  | Official H'Caps
1 |  |  |  |  | S/I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New H'Cap |  |  |  |  | S/I 1 | S/I 2 | S/I 3 | S/I 1 | S/1 2 | S/1 3
1 | [NAME] |  |  |  |  | 3 | 4 | 5 | 4 | 3 | 4 | 5 | 4 | 3 | 2 | 3 | 4 | 5 | 6 | 7 | 7 | 3 | 4
1 | [NAME] |  |  |  |  | 4 | 4 | 5 | 4 | 4 | 4 | 5 | 4 | 3 | 3 | 3 | 4 | 5 | 6 | 7 | 7 | 4 | 4
0 | [NAME] |  |  |  |  | 5 | 4 | 5 | 4 | 5 | 4 | 5 | 4 | 3 | 4 | 3 | 4 | 5 | 6 | 7 | 7 | 5 | 4
0 | [NAME] |  |  |  |  | 6 | 4 | 5 | 4 | 6 | 4 | 5 | 4 | 3 | 5 | 3 | 4 | 5 | 6 | 7 | 7 | 6 | 4
0 | [NAME] |  |  |  |  | 7 | 4 | 5 | 4 | 7 | 4 | 5 | 4 | 3 | 6 | 3 | 4 | 5 | 6 | 7 | 7 | 7 | 4
0 | [NAME] |  |  |  |  | 8 | 4 | 5 | 4 | 8 | 4 | 5 | 4 | 3 | 7 | 3 | 4 | 5 | 6 | 7 | 7 | 8 | 4
0 | [NAME] |  |  |  |  | 9 | 4 | 5 | 4 | 9 | 4 | 5 | 4 | 3 | 8 | 3 | 4 | 5 | 6 | 7 | 7 | 9 | 4
0 | [NAME] |  |  |  |  | 10 | 4 | 5 | 4 | 10 | 4 | 5 | 4 | 3 | 9 | 3 | 4 | 5 | 6 | 7 | 7 | 10 | 4
0 | [NAME] |  |  |  |  | 11 | 4 | 5 | 4 | 11 | 4 | 5 | 4 | 3 | 10 | 3 | 4 | 5 | 6 | 7 | 7 | 11 | 4
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | Neville Ankers
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
 | Number of Players |  |  |  | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
 |  |  |  |  | PAR
 | Average Score |  |  |  | S/I
 | PARS
 | BIRDIES
 | Total Score
Spreadsheet: 803357d1667407772-count-cells-with-content-test-
Sheet: Sheet1

 |  |  | Code | Ethnicity  (2001 Census Categories) |  |  |  |  | Reg
 |  |  |  | Other ethnic group: Arab, Arab Scottish or Arab British - Scotland ethnic category 2011 census |  |  |  |  | S
 |  |  |  | White British - ethnic category 2001 census |  |  |  |  | S
 |  |  | E01030743 | [NAME] or British Bangladeshi - ethnic category 2001 census |  |  |  |  | S
 |  |  |  | N African Arab/Iranian (NMO)
 |  |  | E01030711 | Any other group - ethnic category 2001 census
 |  |  |  | English - ethnic category 2001 census
 |  |  |  | White British - ethnic category 2001 census
 |  |  |  | White British - ethnic category 2001 census
 |  |  |  | Indian or British Indian - ethnic category 2001 census
 |  |  |  | White British
 |  |  |  | Punjabi - ethnic category 2001 census |  |  |  |  | S
 |  |  |  | White British - ethnic category 2001 census |  |  |  |  | S
 |  |  | E01030709 | White British
 |  |  | E01030709 | Indian or British Indian - ethnic category 2001 census
 |  |  |  | English - ethnic category 2001 census |  |  |  |  | C
Spreadsheet: 761461d1640920041-formula-for-searching-a-document-for-multiple-search-terms-simultaneously-formula-test
Sheet: Sheet1

 |  |  | With SUM - column A | With SUM - column B |  | Without SUM - column A | Without SUM - column B
[NAME] | [NAME]
[NAME], [NAME], 8 1/2" | [NAME], [NAME], 8 1/2"
Headed Reamer, 9 mm | Headed Reamer, 9 mm
Headed Reamer, 7 mm | Headed Reamer, 7 mm
Spreadsheet: 63421d1264346371-date-and-count-number-of-items-mtd-testsheet
Sheet: Data

Name | Job Type | Date | Amount
[NAME] | Code 01 | 2010-01-19 00:00:00 | 100
[NAME] | Code 01 | 2010-01-20 00:00:00 | 101
[NAME] | Code 01 | 2009-11-12 00:00:00 | 102
[NAME] | Code 01 | 2009-11-13 00:00:00 | 103
[NAME] | Code 01 | 2009-11-14 00:00:00 | 104
[NAME] | Code 01 | 2009-12-24 00:00:00 | 105
[NAME] | Code 02 | 2009-12-25 00:00:00 | 106
[NAME] | Code 02 | 2009-10-06 00:00:00 | 107
[NAME] | Code 02 | 2009-10-07 00:00:00 | 108
[NAME] | Code 02 | 2009-10-08 00:00:00 | 109
[NAME] | Code 02 | 2009-10-09 00:00:00 | 110
[NAME] | Code 02 | 2009-10-10 00:00:00 | 111
[NAME] | Code 02 | 2009-10-11 00:00:00 | 112
[NAME] | Code 02 | 2010-01-01 00:00:00 | 113
[NAME] | Code 01 | 2010-01-02 00:00:00 | 114
[NAME] | Code 01 | 2010-01-03 00:00:00 | 115
[NAME] | Code 01 | 2010-01-04 00:00:00 | 116
[NAME] | Code 02 | 2009-10-15 00:00:00 | 117
[NAME] | Code 01 | 2009-10-16 00:00:00 | 118
[NAME] | Code 01 | 2010-01-07 00:00:00 | 119
[NAME] | Code 02 | 2010-01-08 00:00:00 | 120
[NAME] | Code 01 | 2010-01-09 00:00:00 | 121
Spreadsheet: kate_symes__18497__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120 | 231.33 | 632 | 127.03 | 579
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
Spreadsheet: benjamin_rogers__1294__Caledonia
Sheet: Cash Flow Statement

Cash Flow Statement
 |  |  | 1
Pretax Book Income
Plus Depreciation & Amortization
Plus Accrued Prop Tax Expense
Less Property Tax Payment
Accrued Interest
Less Interest Payments
Less Principal Payments
Subtotal
Less Debt Reserve Funding |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Plus Release of Debt Reserve |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Additional Capital Expenditures |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Initial Working Capital Adjustment |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pretax Cash Flow
Total Income Tax Expense (Benefit)
After Tax Cash Flow
Preferred Equity
Cash Flow Available to Preferred Equity
Beginning Balance
Dividends
Accrued Dividends To Date |  | 0
Dividends Paid
Ending Principal Amount
Common Equity
Cash Flow Available to Common Equity
Dividends Paid to Common Equity
[NAME]
Cash Beginning Balance |  |  | 0
Add Cash generated
Ending balance
[NAME]
Spreadsheet: 32447d1228589138-calculating-percentiles-664727-pvd
Sheet: coal

 |  |  |  |  | d0 | 1.505350244859627
 |  |  |  |  | k | 5
 |  |  |  |  | RMS error | 0.01145114932961967
Anthracite |  |  |  |  | Porosity = Vvoid/Vtotal = 70/200 = .350
Sieve Opening  (mm) | Empty Sieve Weight (g) | Weight of Sieve + Filter Media (g) | Weight of Filter Media (g) | Cumulative Mass (g) | % of Media Passing | cdf
0.25 | 370 | 370 | 0 | 169.7 | 0 | 0.0001263236958528591
0.42 | 472.1 | 472.6 | 0.5 | 169.7 | 0 | 0.00168924091464473
0.59 | 424.7 | 429 | 4.3 | 169.2 | 0.0029 | 0.009205884621927063
0.84 | 442.3 | 460 | 17.7 | 164.9 | 0.028 | 0.05266397464007044
1 | 492.9 | 640.1 | 147.2 | 147.2 | 0.133 | 0.121345602548192
2.38 | 447.8 | 447.7 | 0 | 0 | 1 | 0.9999487418704184
Spreadsheet: 118945d1314108336-summing-based-on-multiple-criteria-test-sheet
Sheet: Data Paste Sheet

 | Test
 |  | Date | Location | Name | Type | N/A | Total
 |  | 2001-01-01 00:00:00 | Home | [NAME] | Old |  | 10
 |  | 2002-01-01 00:00:00 | School | [NAME] | Old |  | 10
 |  | 2003-01-01 00:00:00 | Work | [NAME] | Old |  | 10
 |  | 2004-01-01 00:00:00 | Home | [NAME] | Old |  | 10
 |  | 2005-01-01 00:00:00 | School | [NAME] | Old |  | 10
 |  | 2006-01-01 00:00:00 | Work | [NAME] | Old |  | 10
 |  | 2007-01-01 00:00:00 | Home | [NAME] | Old |  | 10
 |  | 2008-01-01 00:00:00 | School | [NAME] | Old |  | 10
 |  | 2009-01-01 00:00:00 | Work | [NAME] | Old |  | 10
 |  | 2010-01-01 00:00:00 | Home | [NAME] | Old |  | 10
 |  | 2011-01-01 00:00:00 | School | [NAME] | Old |  | 10
 |  | 2012-01-01 00:00:00 | Work | [NAME] | Old |  | 10
 |  | 2013-01-01 00:00:00 | Home | [NAME] | Old |  | 10
 |  | 2014-01-01 00:00:00 | School | [NAME] | Old |  | 10
 |  | 2015-01-01 00:00:00 | Work | [NAME] | Old |  | 10
 |  | 2016-01-01 00:00:00 | Home | [NAME] | Old |  | 10
Spreadsheet: 666069d1583460588-help-make-a-formula-adding-ingredient-unit-conversion_carton_box_pump_cup-choy96-2-
Sheet: Sheet1

1 carton | = | 16 box
1 box | = | 5 pump
1 pump | = | 3 cup
customer | usage (pump) | stock in (cartoon) | balance ingredient | office balance | worker 1 | worker 2 | worker 3 | worker 4 | worker 5 | total | Status
 |  |  | 1b
[NAME] | 2b 3p 1cu | 5ca |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carton | 1
Cally | 8b 4p 2cu |  |  |  |  |  |  |  |  |  |  |  |  | ca |  |  |  | Box
[NAME] | 9b 3p 2cu |  |  | 0 | 0 | 0 | 4p | 4p | 3ca 10b 0p 1cu |  |  |  |  | b |  |  |  | Pump
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cup
ca= carton, b=box, p=pum, cu=cup
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 119821d1314775261-search-function-question
Sheet: Sheet1

List
ID&Code | ID | Code | Relationship | Name
1242323 | 12423 | 23 | Father | [NAME] S.(ALM)
1242325 | 12423 | 25 | Mother | [NAME]
1242327 | 12423 | 27 | Sibling | [NAME]
1242327 | 12423 | 27 | Sibling | [NAME] S.(ALM)
1242327 | 12423 | 27 | Sibling | [NAME]
1. Find out [NAME] from list |  | ID | 12423
Code | Relationship | Name |  | Answer
23 | Father | [NAME] S.(ALM) |  | Correct
25 | Mother |  |  | Correct
27 | Sibling |  |  | [NAME] S.(ALM)
Spreadsheet: 770410d1646055327-lookup-value-across-multiple-sheets-and-count-number-of-matching-occurrences-vlookupcount_sample
Sheet: Sheet5

[NAME] | On time
[NAME] | Available from 8.02
Mark | Available from 8.02
[NAME] | Available from 8.02
[NAME] | On time
Stephen | On time
[NAME] | Available from 8.10
[NAME] | Available from 8.04
[NAME] | On time
Mark | Available from 8.02
[NAME] | Available from 8.01
Spreadsheet: 132443d1323767996-vlookup-to-search-3rd-column-instead-of-fitst-forum
Sheet: Arkusz2

[NAME] | data2 | data3 | data4
q | 1 | a | 4
w | 2 | s | 4
e | 3 | f | 4
r | 4 | g | 4
t | 5 | h | 4
 | g
Spreadsheet: 885848d1735724180-clarification-needed-for-excel-expert-practice-tasks-excelexpert_1-3c
Sheet: Store Inventory List

[NAME] House Store Inventory |  |  |  |  | 
TOTAL ESTIMATED VALUE OF ALL ITEMS: |  |  |  |  |  | INVENTORY DATE:
 | LOCATION: |  |  |  |  | Store Manager:
 |  |  |  |  |  | Manager's Phone:
 | ADDRESS: |  |  |  |  | Store Phone:
 |  |  |  |  |  | Emergency Contact Phone:
Item # | Category | Description | [NAME] model | Qty | Buy Date | Buy Location | Price | Current Value | Notes | Photo?
1 | Ski Gear | ASH-1012 |  | 20 |  |  | 203.7
 | Ski Apparel | ASH-1310 |  | 6 |  |  | 45.78
 | [NAME] | ASH-1714 |  | 31 |  |  | 18.91
 | Helmets | ASH-1811 |  | 3 |  |  | 61.57
 | Anytime Apparel | ASH-2002 |  | 9 |  |  | 138.96
 | Edibles | ASH-1458 |  | 39 |  |  | 4.7
Spreadsheet: 789031d1658850170-how-to-use-offset-index-to-copy-formula-horizontally-when-dragging-down-orc-rate-comparison-with-graphs-test
Sheet: Sheet2

 | Month | Office | TCIR | DART | DAFW
 | Jan | Office 1
 | Jan | Office 2
 | Jan | Office 3
 | Jan | Office 4
 | Jan | BLS
 | Feb | Office 1
 | Feb | Office 2
 | Feb | Office 3
 | Feb | Office 4
 | Feb | BLS
 | Mar | Office 1
 | Mar | Office 2
 | Mar | Office 3
 | Mar | Office 4
 | Mar | BLS
 | Apr | Office 1
 | Apr | Office 2
 | Apr | Office 3
 | Apr | Office 4
 | Apr | BLS
 | May | Office 1
 | May | Office 2
 | May | Office 3
 | May | Office 4
 | May | BLS
 | Jun | Office 1
 | Jun | Office 2
 | Jun | Office 3
 | Jun | Office 4
 | Jun | BLS
 | Jul | Office 1
 | Jul | Office 2
 | Jul | Office 3
 | Jul | Office 4
 | Jul | BLS