tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7a840ce4-783a-4a7d-9d72-9171468b3b7a
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
 |  | U.S. Census Bureau
 |  | Source: Monthly Retail Trade and Food Services
 |  | 4541: Electronic Shopping and Mail-order Houses: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2013
 |  | Data Extracted on: July 23, 2014 (8:19 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 2692 | 2285 | 2484 | 2506 | 2483 | 2602 | 2665 | 2673 | 2932 | 3436 | 3922 | 4530
1993 | 3057 | 2739 | 3299 | 2962 | 2791 | 2667 | 2621 | 2895 | 3280 | 3869 | 4955 | 5542
1994 | 3532 | 3141 | 3898 | 3619 | 3464 | 3296 | 3097 | 3597 | 3812 | 4309 | 5254 | 6018
1995 | 3939 | 3341 | 4121 | 3650 | 3943 | 3710 | 3568 | 4080 | 4357 | 5021 | 6113 | 6837
1996 | 4549 | 4226 | 4703 | 4566 | 4563 | 4250 | 4442 | 4586 | 4875 | 5816 | 6676 | 7854
1997 | 5042 | 4577 | 5594 | 5491 | 5304 | 5204 | 5198 | 5165 | 6080 | 6693 | 7029 | 8690
1998 | 5794 | 5455 | 6528 | 6096 | 6111 | 5977 | 6115 | 6056 | 6711 | 7483 | 8156 | 9815
1999 | 6491 | 6391 | 7595 | 7128 | 6925 | 7222 | 6964 | 7514 | 8033 | 8552 | 9604 | 11863
2000 | 8087 | 8074 | 9425 | 8409 | 8692 | 8865 | 8229 | 9297 | 9442 | 10324 | 11388 | 13558
2001 | 9343 | 8333 | 9710 | 8898 | 9214 | 8908 | 8727 | 9551 | 8420 | 10118 | 10903 | 12624
2002 | 9912 | 8925 | 9670 | 9684 | 9713 | 8969 | 9478 | 9845 | 9678 | 10738 | 11412 | 14190
2003 | 10568 | 9654 | 10403 | 10415 | 10322 | 10185 | 10511 | 10641 | 11253 | 12099 | 12162 | 16091
2004 | 11989 | 11260 | 12621 | 12030 | 11706 | 11840 | 11655 | 12540 | 12412 | 13030 | 14604 | 18470
2005 | 13209 | 12317 | 14154 | 13352 | 13639 | 13634 | 13107 | 14910 | 14318 | 15022 | 16922 | 21316
2006 | 15811 | 14531 | 17046 | 15024 | 16071 | 15795 | 14768 | 16897 | 16050 | 17497 | 19037 | 23724
2007 | 17540 | 16118 | 18040 | 16927 | 18053 | 17211 | 17617 | 18523 | 17206 | 19574 | 21583 | 25289
2008 | 18635 | 17368 | 17942 | 18612 | 18546 | 18039 | 18492 | 18035 | 18444 | 18946 | 18875 | 26269
2009 | 18076 | 16675 | 18342 | 17773 | 17644 | 18494 | 18421 | 18541 | 18998 | 19558 | 21773 | 29377
2010 | 19345 | 18208 | 21374 | 20152 | 19790 | 20787 | 19659 | 21369 | 21115 | 21196 | 25030 | 32619
2011 | 22041 | 20503 | 23622 | 21772 | 22927 | 22823 | 21365 | 24054 | 23062 | 23733 | 28733 | 36217
2012 | 24157 | 23592 | 25274 | 23807 | 25705 | 24434 | 24460 | 26828 | 25047 | 27136 | 32462 | 39641
2013 | 28437 | 25749 | 27988 | 28218 | 28748 | 26975 | 28349 | 29297 | 28283 | 29657 | 33381 | 44500
Spreadsheet: 713687d1610882194-calculating-of-1st-and-2nd-higher-values-first-and-second-high-value
Sheet: Tabelle1

1 | X | 2 |  | 1st higher value | 2nd higher  value
1 | 5 | 2 |  |  |  | correct
4 | 1 | 0 |  |  |  | correct
4 | 0 | 1 |  |  |  | correct
2 | 2 | 1 |  |  |  | correct is 1X or X1
2 | 1 | 2 |  |  |  | correct is 12 or 21
5 | 0 | 0 |  |  |  | If 2 values are equal than the output result  should be both values such in this example: 1 & X2
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -173 | -170 |  |  | -1576 | -1050
2 | -214 | -170 |  |  | -1603 | -1050
3 | -199 | -170 |  |  | -1406 | -1050
4 | -152 | -170 |  |  | -1400 | -1050
5 | -147 | -170 |  |  | -1303 | -1050
6 | -164 | -170 |  |  | -1240 | -1050
7 | -174 | -170 |  |  | -1112 | -1050
8 | -164 | -170 |  |  | -876 | -1050
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | -35540.33
2002-01-08 00:00:00
CBS Volume
 |  |  | -3434
Spreadsheet: 866396d1713319462-help-with-basic-table-example
Sheet: Data

ID | NAME | START | END | CAR
12 | [NAME] | 2024-04-19 17:15:00 | 2024-04-24 17:15:00 | Toyota |  | Select ID: | 13
13 | [NAME] | 2024-04-19 11:00:00 | 2024-04-22 08:00:00 | [NAME]
14 | [NAME] | 2024-04-19 08:00:00 | 2024-04-19 17:00:00 | Kia
15 | [NAME] | 2024-04-19 10:00:00 | 2024-04-19 16:00:00 | Ute
Spreadsheet: 172198d1344022432-create-a-drop-down-box-in-a-worksheet-based-on-certain-values-gazps-workbook-example
Sheet: 123456

Source | [NAME] | CREDITED |  |  | Customer | Balance |  |  | Lookup list
123456 | 222222 | 100 |  |  | 123456 |  |  |  | 123456 |  | Customer | 222222
123456 | 333333 | 20 |  |  | 222222 |  |  |  | 222222 |  | Balance
333333 | 222222 | 75 |  |  | 333333 |  |  |  | 333333
123456 | 999999 | 50 |  |  | 999999 |  |  |  | 999999
999999 | 222222 | 10
123456 | 333333 | 25
Spreadsheet: 78575d1278952095-percent-change-question-excel-problem
Sheet: Sheet1

102.5 | 58.28
56.78 | 32.04
34.86 | 24.19
25.06 | 14.8
17.65 | 9.13
8.51 | 0
6.36 | 0
4.68 | 0
5.66 | 2.99
2.11 | 0
1.87 | 0
10.73 | 9.12
0.87 | 0
0.57 | 0
0.26 | 0
0.08 | 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
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 | 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
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 | 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
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0.62 | 0.94
0.86 | 1.26
0 | 1.12
14.37 | 16.44
0.4 | 2.59
0 | 3.27
0.57 | 4.57
4.58 | 9.56
9.24 | 14.32
8.44 | 15.15
42.82 | 50.49
8.14 | 15.87
30.97 | 39.18
0.41 | 9.99
20.19 | 31.17
2.4 | 17.57
7.17 | 22.4
13.18 | 29.33
0 | 31.59
35.42 | 85.85
43.45 | 111.28
353.12 | 104.26
128.27 | 0
106.84 | 31.67
106.49 | 33.38
82.81 | 25.64
56.65 | 0
125.96 | 75.42
108.6 | 60.15
37.54 | 2.67
146.39 | 114.36
95.46 | 68.82
66.85 | 40.25
67.97 | 43.88
34.46 | 11.08
68.71 | 46.91
142.81 | 121.7
57.15 | 36.75
19.96 | 0.3
75.09 | 59.05
14.67 | 0.9
16.21 | 2.98
41.85 | 30.79
19.93 | 8.93
22.43 | 12.15
25.29 | 16.51
24.13 | 16.88
19.28 | 12.08
93.13 | 86.6
12.04 | 6.14
62.92 | 57.79
4.7 | 0
10.93 | 7.4
21.58 | 18.13
35.82 | 32.38
3.4 | 0
7.03 | 3.64
26.91 | 24.15
94.11 | 91.46
4.46 | 2.06
12.36 | 10.02
14.89 | 12.65
61.88 | 59.72
13.69 | 11.8
3.82 | 2.23
7.91 | 6.78
1.09 | 0
35.64 | 34.76
0.64 | 0
51.02 | 50.48
0.34 | 0
0.31 | 0
0.31 | 0
0.19 | 0
1.02 | 0.91
2.1 | 2.01
0.08 | 0
0.3 | 0.24
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 | 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
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 | 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
0 | 0
0
81.66 | 81.67
0 | 0.15
0 | 0.24
10.61 | 10.96
0 | 0.39
0 | 0.4
0 | 0.45
0 | 0.48
0 | 0.49
0 | 0.54
2.27 | 2.87
0 | 0.7
0 | 0.73
0 | 0.89
0.71 | 1.61
0.93 | 1.87
0.47 | 1.55
0.35 | 1.78
0 | 1.8
17.61 | 19.42
1.69 | 3.56
18.4 | 20.64
49.12 | 51.94
16.76 | 19.64
0 | 3.13
1.51 | 4.66
20.06 | 23.78
0.97 | 4.73
35.32 | 39.51
0 | 4.52
53.6 | 58.39
1.02 | 6.05
6.57 | 11.62
62.26 | 67.59
1.2 | 6.57
30.75 | 36.79
21.17 | 27.32
42.99 | 49.69
21.27 | 28.64
7.83 | 15.26
13.06 | 21.01
14.78 | 22.76
10.04 | 18.19
23.08 | 31.57
6 | 14.63
32.16 | 41.02
20.23 | 29.32
0 | 9.98
62.23 | 72.27
38.17 | 48.21
14.88 | 24.94
12.63 | 23.36
0.19 | 10.94
0.93 | 12.83
9.56 | 21.84
27.15 | 40.51
48.78 | 62.63
65.27 | 80.11
26.74 | 42.01
25.74 | 42.13
82.64 | 99.11
8.03 | 24.91
15.11 | 32
25.31 | 42.4
65.65 | 83.09
31.28 | 51.71
21.34 | 42.41
11.02 | 34.02
13.14 | 37.95
0 | 25.71
46.36 | 72.85
28.48 | 55.76
36.5 | 68.07
39.25 | 71.3
7.07 | 48.46
52.44 | 93.84
16.77 | 62.04
170.26 | 215.58
5.42 | 51.62
49.45 | 102.58
96.72 | 151.16
97.86 | 183.27
Spreadsheet: 3a36e0b2-07c3-43f2-bea0-1cd5954703ae
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: |  |  | 2013-08-27 09:35:15
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.75 | 101.872 | 101.747 | 101.622 | 101.247
4.625 | 101.174 | 101.049 | 100.924 | 100.549 |  | Note: | Refer To Price [NAME]
4.5 | 100.305 | 100.18 | 100.055 | 99.68 |  |  | For all Price Adjs
4.375 | 99.392 | 99.267 | 99.142 | 98.517
4.25 | 98.679 | 98.554 | 98.429 | 97.804
4.125 | 97.907 | 97.782 | 97.657 | 97.032
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.125 | 102 | 101.875 | 101.5
3.875 | 101.795 | 101.67 | 101.545 | 101.17
3.75 | 101.178 | 101.053 | 100.928 | 100.553
3.625 | 100.806 | 100.681 | 100.556 | 100.181
3.5 | 100.299 | 100.174 | 100.049 | 99.424
3.375 | 99.557 | 99.432 | 99.307 | 98.682
3.25 | 98.825 | 98.7 | 98.575 | 97.95 |  | Minimum loan amount:
3.125 | 97.916 | 97.791 | 97.666 | 97.041 |  | 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 | 2013-09-10 09:35:15
30 DAY | 2013-09-25 09:35:15
45 DAY | 2013-10-10 09:35:15
60 DAY | 2013-10-25 09:35:15
90 DAY | 2013-11-24 09:35:15
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 35692d1233292712-search-for-particular-value-book2
Sheet: Sheet1

1 | 40 |  | TA2 | TD1 |  |  |  | 0 | TA1
1 | 26 |  | TA2 | TB14 |  |  |  | 1 | TA2
40 | 13 |  |  |  |  |  |  | 2 | TA3
14 | 39 |  |  |  |  |  |  | 3 | TA4
0 | 13 |  |  |  |  |  |  | 4 | TA5
1 | 3 |  |  |  |  |  |  | 5 | TA6
40 | 28 |  |  |  |  |  |  | 6 | TA7
0 | 2 |  |  |  |  |  |  | 7 | TA8
39 | 27 |  |  |  |  |  |  | 8 | TA9
26 | 28 |  |  |  |  |  |  | 9 | TA10
14 | 1 |  |  |  |  |  |  | 10 | TA11
2 | 41 |  |  |  |  |  |  | 11 | TA12
14 | 26 |  |  |  |  |  |  | 12 | TA13
39 | 0 |  |  |  |  |  |  | 13 | [NAME]
26 | 28 |  |  |  |  |  |  | 14 | [NAME]
0 | 13 |  |  |  |  |  |  | 15 | TB3
1 | 39 |  |  |  |  |  |  | 16 | TB4
27 | 15 |  |  |  |  |  |  | 17 | TB5
1 | 40 |  |  |  |  |  |  | 18 | TB6
1 | 26 |  |  |  |  |  |  | 19 | TB7
40 | 13 |  |  |  |  |  |  | 20 | TB8
14 | 39 |  |  |  |  |  |  | 21 | TB9
0 | 13 |  |  |  |  |  |  | 22 | TB10
1 | 3 |  |  |  |  |  |  | 23 | TB11
40 | 28 |  |  |  |  |  |  | 24 | TB12
0 | 2 |  |  |  |  |  |  | 25 | TB13
39 | 27 |  |  |  |  |  |  | 26 | TB14
26 | 28 |  |  |  |  |  |  | 27 | TC1
14 | 1 |  |  |  |  |  |  | 28 | TC2
2 | 41 |  |  |  |  |  |  | 29 | TC3
14 | 26 |  |  |  |  |  |  | 30 | TC4
39 | 0 |  |  |  |  |  |  | 31 | TC5
26 | 28 |  |  |  |  |  |  | 32 | TC6
0 | 13 |  |  |  |  |  |  | 33 | TC7
1 | 39 |  |  |  |  |  |  | 34 | TC8
27 | 15 |  |  |  |  |  |  | 35 | TC9
26 | 28 |  |  |  |  |  |  | 36 | TC10
14 | 1 |  |  |  |  |  |  | 37 | TC11
2 | 41 |  |  |  |  |  |  | 38 | TC12
14 | 26 |  |  |  |  |  |  | 39 | TC13
39 | 0 |  |  |  |  |  |  | 40 | TD1
26 | 28 |  |  |  |  |  |  | 41 | TD2
0 | 13 |  |  |  |  |  |  | 42 | TD3
1 | 39 |  |  |  |  |  |  | 43 | TD4
27 | 15 |  |  |  |  |  |  | 44 | TD5
1 | 40 |  |  |  |  |  |  | 45 | TD6
1 | 26 |  |  |  |  |  |  | 46 | TD7
40 | 28 |  |  |  |  |  |  | 47 | TD8
0 | 2 |  |  |  |  |  |  | 48 | [NAME]
39 | 27 |  |  |  |  |  |  | 49 | TD10
26 | 28 |  |  |  |  |  |  | 50 | TD11
14 | 1 |  |  |  |  |  |  | 51 | TD12
2 | 41
14 | 26
15 | 1
15 | 41
2 | 39
14 | 40
42 | 27
41 | 0
30 | 0
0 | 4
13 | 0
14 | 27
40 | 26
0 | 15
40 | 15
13 | 15
3 | 27
14 | 13
39 | 41
13 | 32
17 | 40
27 | 1
30 | 26
42 | 39
39 | 0
13 | 43
42 | 39
27 | 27
14 | 13
26 | 30
13 | 41
26 | 0
41 | 2
2 | 17
13 | 27
13 | 28
28 | 26
14 | 1
15 | 41
28 | 3
30 | 3
2 | 2
14 | 14
26 | 26
43 | 1
42 | 40
41 | 39
28 | 39
0 | 14
41 | 40
30 | 27
39 | 27
14 | 29
16 | 0
27 | 29
40 | 27
41 | 29
41 | 40
40 | 39
0 | 14
16 | 41
26 | 14
41 | 13
15 | 17
41 | 14
28 | 16
4 | 27
13 | 0
26 | 41
13 | 2
39 | 40
27 | 15
40 | 1
40 | 1
39 | 13
39 | 29
39 | 16
14 | 39
4 | 0
16 | 15
0 | 15
44 | 14
30 | 26
27 | 13
15 | 14
42 | 39
27 | 0
39 | 15
27 | 14
2 | 42
0 | 40
27 | 41
27 | 40
16 | 39
40 | 1
41 | 15
15 | 0
28 | 27
3 | 0
16 | 14
1 | 39
4 | 27
28 | 43
26 | 41
13 | 42
27 | 31
40 | 2
42 | 0
2 | 26
28 | 4
0 | 30
39 | 13
39 | 1
27 | 40
1 | 0
3 | 3
0 | 27
14 | 17
44 | 0
39 | 41
39 | 14
40 | 28
27 | 16
3 | 42
26 | 3
39 | 13
27 | 15
1 | 2
13 | 3
26 | 26
1 | 30
27 | 16
39 | 0
41 | 30
0 | 29
29 | 2
28 | 27
28 | 40
17 | 39
0 | 40
2 | 28
26 | 2
14 | 41
2 | 13
15 | 40
40 | 39
41 | 15
3 | 0
27 | 0
5 | 40
14 | 13
28 | 2
14 | 41
13 | 28
13 | 26
0 | 26
Spreadsheet: 844829d1696497342-power-query-somewhat-complicated-table-transformation-function-complicated_conversion
Sheet: Sheet1

 | input
 | Column 1 | Column 2 | Column 3 | Column 4 | Column 5
 | item_ name | parameter_name | parameter_unit | A001 | A002
 | QT | mass | [NAME] | 15 | 12
 | QT | density | kg/L | 1.2 | 1.15
 | QT | volume | L | 12.5 | 10.43478260869565
 | QT | reo | - | 2.4 | 2.1
 | output
 | item_ name | parameter_name | parameter_unit | batch | value
 | QT | mass | [NAME] | A001 | 15
 | QT | density | kg/L | A001 | 1.2
 | QT | volume | L | A001 | 12.5
 | QT | reo | - | A001 | 2.4
 | QT | mass | [NAME] | A002 | 12
 | QT | density | kg/L | A002 | 1.15
 | QT | volume | L | A002 | 10.43478260869565
 | QT | reo | - | A002 | 2.1
Spreadsheet: 690213d1596957063-extract-the-latest-account-balance-based-on-dates-test
Sheet: EOM 31.7

 | Ledger balance (end of day) | Ledger balance date
1-001 | 64.82 | 2020-01-07 00:00:00
1-001 | 73.32 | 2020-02-07 00:00:00
1-001 | 47532 | 2020-03-07 00:00:00
1-001 | 53032 | 2020-06-07 00:00:00
1-001 | 53032 | 2020-07-07 00:00:00
1-001 | 53032 | 2020-08-07 00:00:00
1-001 | 53032 | 2020-09-07 00:00:00
1-001 | 99.55 | 13/07/2020
1-001 | 31.85 | 2020-10-07 00:00:00
1-001 | 76.84 | 14/07/2020
1-001 | 28.47 | 15/07/2020
1-001 | 5.93 | 28/07/2020
1-001 | 47.46 | 31/07/2020
1-001 | 77.28 | 16/07/2020
1-001 | 698.1 | 17/07/2020
1-001 | 698.1 | 20/07/2020
1-001 | 5.91 | 29/07/2020
1-001 | 5.91 | 30/07/2020
1-001 | 11.29 | 21/07/2020
1-001 | 11.29 | 22/07/2020
1-001 | 82.05 | 23/07/2020
1-001 | 82.33 | 24/07/2020
1-001 | 37.75 | 27/07/2020
5-330 | 23.78 | 31/07/2020
5-330 | 18.98 | 23/07/2020
5-330 | 18.98 | 24/07/2020
5-330 | 18.98 | 29/07/2020
5-330 | 18.98 | 30/07/2020
5-330 | 28.09 | 20/07/2020
5-330 | 28.09 | 21/07/2020
5-330 | 28.09 | 22/07/2020
5-330 | 12.24 | 2020-08-07 00:00:00
5-330 | 12.24 | 2020-09-07 00:00:00
5-330 | 12.24 | 2020-10-07 00:00:00
5-330 | 12.24 | 13/07/2020
5-330 | 12.24 | 14/07/2020
5-330 | 12.24 | 15/07/2020
5-330 | 12.24 | 16/07/2020
5-330 | 12.24 | 17/07/2020
5-330 | 18.13 | 2020-01-07 00:00:00
5-330 | 18.13 | 2020-02-07 00:00:00
5-330 | 18.13 | 2020-03-07 00:00:00
5-330 | 18.13 | 2020-07-07 00:00:00
2-001 | 2299 | 15/07/2020
2-001 | 2299 | 16/07/2020
2-001 | 2299 | 17/07/2020
2-001 | 2299 | 18/07/2020
2-001 | 2299 | 20/07/2020
2-001 | 2299 | 21/07/2020
2-001 | 2299 | 22/07/2020
2-001 | 2299 | 23/07/2020
2-001 | 2299 | 24/07/2020
2-001 | 2299 | 27/07/2020
2-001 | 2299 | 28/07/2020
2-001 | 2299 | 29/07/2020
2-001 | 2299 | 30/07/2020
2-001 | 2299 | 31/07/2020
2-001 | 11599 | 2020-01-07 00:00:00
2-001 | 11599 | 2020-02-07 00:00:00
2-001 | 11599 | 2020-03-07 00:00:00
2-001 | 11599 | 2020-04-07 00:00:00
2-001 | 11599 | 2020-06-07 00:00:00
2-001 | 11599 | 2020-07-07 00:00:00
2-001 | 11599 | 2020-08-07 00:00:00
2-001 | 11599 | 2020-09-07 00:00:00
2-001 | 11599 | 2020-10-07 00:00:00
2-001 | 11599 | 13/07/2020
2-001 | 11599 | 14/07/2020
3-101 | 66.29 | 2020-01-07 00:00:00
3-101 | 66.29 | 2020-02-07 00:00:00
3-101 | 66.29 | 2020-03-07 00:00:00
3-101 | 66.29 | 2020-05-07 00:00:00
3-101 | 66.29 | 2020-06-07 00:00:00
3-101 | 66.29 | 2020-07-07 00:00:00
3-101 | 66.29 | 2020-08-07 00:00:00
3-101 | 51.39 | 20/07/2020
3-101 | 51.39 | 21/07/2020
3-101 | 51.39 | 22/07/2020
3-101 | 51.39 | 23/07/2020
3-101 | 51.39 | 24/07/2020
3-101 | 51.39 | 26/07/2020
3-101 | 12.07 | 17/07/2020
3-101 | 12.07 | 19/07/2020
3-101 | 12.07 | 15/07/2020
3-101 | 12.07 | 16/07/2020
3-101 | 84.97 | 13/07/2020
3-101 | 84.97 | 14/07/2020
3-101 | 6.29 | 2020-10-07 00:00:00
3-101 | 6.29 | 2020-12-07 00:00:00
3-101 | 70.64 | 28/07/2020
3-101 | 70.64 | 29/07/2020
3-101 | 70.64 | 30/07/2020
3-101 | 51.36 | 27/07/2020
3-101 | 66.29 | 2020-09-07 00:00:00
Spreadsheet: 445327d1454891695-vacation-tracking-from-an-anniversary-date-from-year-to-year-holiday
Sheet: Data

Who | When | Hours |  |  |  |  | 1 |  | 2015
[NAME] | 2016-01-01 00:00:00 | 4 |  |  |  |  | 2 |  | 2016
[NAME] | 2016-01-02 00:00:00 | 5 |  |  |  |  | 3 |  | 2017
[NAME] | 2016-01-03 00:00:00 | 6 |  |  |  |  | 4 |  | 2018
[NAME] | 2016-01-04 00:00:00 | 7 |  |  |  |  | 5
[NAME] | 2016-01-05 00:00:00 | 8 |  |  |  |  | 6
tom | 2016-01-03 00:00:00 | 2 |  |  |  |  | 7
tom | 2016-01-04 00:00:00 | 3 |  |  |  |  | 8
tom | 2016-01-05 00:00:00 | 4 |  |  |  |  | 9
tom | 2016-01-06 00:00:00 | 5 |  |  |  |  | 10
tom | 2016-01-07 00:00:00 | 6 |  |  |  |  | 11
fred | 2016-01-01 00:00:00 | 8 |  |  |  |  | 12
[NAME] | 2016-01-06 00:00:00 | 5
tom | 2016-02-15 00:00:00 | 2
[NAME] | 2016-02-18 00:00:00 | 4
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: FA 05 - Data

[NAME]
Focus Area 05 - Diabetes - Pennsylvania
Objective Number | Objective Title | Baseline Data | Final Data | HP2010 Goal | Target Progress
05-01 | Diabetic Adults who Took a Class to Manage their Diabetes (age-adjusted percentage) | 55 ± 11 (2000) | 57 ± 8 (2009) | 60 | Moved toward target
05-03 | Adults Diagnosed with Diabetes (age-adjusted per 1,000 population) | 53 ± 9 (1998) | 81 ± 7 (2009) | 25 | Moved away from target
05-05 | Diabetes (underlying or contributing cause) Deaths (age-adjusted per 100,000 population) | 86.1 (1996) | 75.9 (2008) | 45 | Moved toward target
05-12 | Diabetic Adults who have a Glycosylated Hemoglobin Measurement Twice a Year (age-adjusted percentage) | 68 ± 12 (2006) | 76 ± 9 (2009) | 50 | Met or exceeded target
05-13 | Diabetic Adults who have an Annual Dilated Eye Exam (age-adjusted percentage) | 67 ± 13 (2000) | 62 ± 9 (2009) | 75 | Moved away from target
05-14 | Diabetic Adults who have an Annual Foot Exam (age-adjusted percentage) | 77 ± 10 (2000) | 72 ± 9 (2009) | 75 | Moved away from target
05-17 | Diabetic Adults who Perform Self-Blood-Glucose-Monitoring Daily (age-adjusted percentage) | 49 ± 14 (2000) | 61 ± 9 (2009) | 60 | Met or exceeded target
Note: The list of objectives above are limited to those for which Pennsylvania data were available.
Spreadsheet: 811281d1672392122-how-to-get-three-middle-number-from-list-moderation-exam-marks2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  | moderation marks
 | No. | Name | Matric No. | T1 | T2 | T3 | T4 | T5 | Math |  |  |  |  |  | math
 | 1 | [NAME] | 68751 | 10 | 12 | 15 | 18 | 10 |  |  |  |  |  | Highest 1 |  |  |  | SORT(FILTER(L6:[NAME]:M54>=LARGE(M6:M54,3)),2,-1)
 | 2 | Alexandra | 41803 |  |  |  |  |  |  |  |  |  |  | Highest 2 |  |  | <==
 | 3 | [NAME] | 20636 |  |  |  |  |  |  |  |  |  |  | Highest 3
 | 4 | Amanda | 34789 |  |  |  | 9 |  |  |  |  |  |  | middle 1 |  |  |  | ?
 | 5 | Amelia | 76662 |  |  |  | 11 |  |  |  |  |  |  | middle 2
 | 6 | [NAME] | 26158 |  |  |  | 13 |  |  |  |  |  |  | middle 3
 | 7 | [NAME] | 95100 |  |  | 9 | 15 |  |  |  |  |  |  | Lowest 1 |  |  |  | SORT(FILTER(L6:M54,M6:M54<=SMALL(M6:M54,3)),2,1)
 | 8 | [NAME] | 21301 |  |  | 11 | 17 |  |  |  |  |  |  | Lowest 2 |  |  | <==
 | 9 | Anna | 96074 |  |  | 13 | 19 |  |  |  |  |  |  | Lowest 3
 | 10 | Anne | 89705 |  | 18 | 15 | 13
 | 11 | [NAME] | 17900 |  | 16 | 17 | 19
 | 12 | Ava | 90594 | 15 | 14 | 19 | 14 | 19 |  |  |  |  |  | LET(t,CHOOSECOLS(C6:J54,1,8),f,FILTER(t,INDEX(t,,2)),TAKE(SORT(f,2,-1),3))
 | 13 | [NAME] | 13064 | 12 | 12 | 13 | 17 | 13
 | 14 | [NAME] | 12687 | 16 | 10 | 19 | 15 | 19
 | 15 | Carol | 80939 | 17 | 9 | 14 | 16 | 14
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
Spreadsheet: 214719d1361085426-which-formula-to-use-for-adding-two-columns-according-to-specific-criteria-adding-more-than-2-columns-based-on-criteria
Sheet: Sheet1

424 | 4.75 | 425 | 3.5 | 424 | 2
336 | 2.5 | 336 | 3.5 | 336 | 2.5
999 | 2 | 256 | 3.5 | 568 | 2.75
424 | 2 | 256 | 2.5 | 698 | 6
336 | 2.5 | 1245 | 5.5 | 425 | 2.5
125 | 2 | 158 | 6 | 424 | 6
424
336
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 | -9355 | -6760
2
3 | -25717 | -26918
4 | -4213 | -3841
5 | -5195 | -6864
6 | -26540 | -16843
7 | -31632 | -16843
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-09-30 00:00:00 |  |  | -21514
2001-10-07 00:00:00
CBS Dollars
 |  |  | -132953
Spreadsheet: 777453d1650387057-sum-is-off-by-01-according-to-calculator-sheet-shared-1
Sheet: Pricing (4)

wrong off by - .01
 |  |  |  |  |  |  |  | ns | gs | [NAME] | grw
[NAME] | 25 | Waste Factor
Thickness | 1.25
[NAME] | 7.75 |  |  |  |  |  |  |  | Thickness * Width
Margin | 0.55 |  |  |  |  |  |  |  | Margin * Total Footage / Footage A mplus (calculator in mind)
Set up | 100
Run Charge |  | Other | 30 |  |  |  |  |  | Set up / Footage A
Knife Charge | 90 | K Width | 4 |  |  |  | [NAME] |  | Run charge
Freight Charge |  | Freight Cost | 180 |  |  |  |  |  | other run charge
[NAME] | Glue |  |  |  | list all items used to calculate this total |  |  |  | determining factor for run charge
Footage A | 20 |  |  |  |  |  |  |  | knife charge * kwidth +0.5 / footage A
Footage + | 20 |  |  |  |  |  |  |  | freight charge / .75 /  total footage
Total footage |  |  |  |  |  |  |  |  | freight charge
Sub total |  |  |  |  | 0 |  |  |  | determing cell for freight
Cells with boxes have drop downs all others are fillable |  |  |  |  | 0
Sell Price |  |  |  |  |  |  |  |  | SUM(G3*I5) |  | cost * (thickness* width)
 |  |  |  |  |  |  |  |  | SUM(I17/12) |  | cost * (thickness* width) /12
 |  |  |  |  |  |  |  |  | sum I18/margin |  | cost * (thickness * width) / 12 / margin
 |  |  |  |  |  |  |  |  | I19*total footage |  | cost * (thickness * width) / 12 / margin * total footage
selection from strip or gross * I5 = / 12 / I6 + I7 = +  I8 + I9 +I10 + C11 needs to be broken up |  |  | Not used |  |  |  | base cost |  | i20/footage a |  | cost * (thickness * width) / 12 / margin * total footage / footage a
+I8+I11+I12+I13+C11) |  |  | Not used |  |  |  |  |  |  |  |  | base cost not rounded
 |  |  | Not used |  |  |  |  |  | [NAME] (run charge determining factor)
 |  |  |  |  |  |  |  |  | I23 + knife charge*width…
Enter footage in cell B12 and enter the additional footage in B13. All cells require input that effect the formulas. There are dropdowns for each category that require you to select one or input their own info. Each blank field with a box outline needs to be filled or left blank
 |  |  |  |  |  |  |  |  | net strip cost sell based on brian numbers |  |  |  | I21  + I8 + I11 + I12 + I15 + D11