tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 851934d1702051747-matching-groups-that-are-designated-by-dates-of-a-project-to-a-given-timeline-book2
Sheet: Sheet1

 |  |  |  |  |  |  | 2023-01-01 00:00:00
 | Group 1 | Group 2 | Group 3 | Group 4 | Group 5
Project A | 2023-01-02 00:00:00 | 2023-02-05 00:00:00 | 2023-03-06 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 |  | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5 | Need dynamic formula
Project B | 2023-04-15 00:00:00 | 2023-07-13 00:00:00 | 2023-01-09 00:00:00 | 2023-09-10 00:00:00 | 2023-02-20 00:00:00 |  | Group 3 | Group 5 | Group 5 | Group 1 | Group 1 | Group 1 | Group 2 | Group 2 | Group 4 | Group 4 | Group 4 | Group 4 | Need dynamic formula
Project C | 2023-05-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-02-01 00:00:00 | 2023-01-01 00:00:00 |  | Group 5 | Group 4 | Group 2 | Group 3 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1 | Need dynamic formula
Spreadsheet: 151888d1335176491-pivot-table-report-design-problem-report-design2
Sheet: Sheet2

Name | Project | FY | Period | Allocation | Actual
name1 | project1 | 2012 | 1 | 0.6 | 0.5
name1 | project2 | 2012 | 1 | 0.4 | 0.5
name1 | project1 | 2012 | 2 | 0.6 | 0.5
name1 | project2 | 2012 | 2 | 0.4 | 0.5
[NAME] | project1 | 2012 | 1 | 0.8 | 0.5
[NAME] | project2 | 2012 | 1 | 0.2 | 0.5
[NAME] | project1 | 2012 | 2 | 0.8 | 0.5
[NAME] | project2 | 2012 | 2 | 0.2 | 0.5
etc...
Spreadsheet: 866091d1713026380-coordinate-conversion-1900-md-state-plane-coordinate-conversions-md-1900-2-calcs-
Sheet: Alaska Example

Calculations found here: |  | https://geodesy.noaa.gov/library/pdfs/Special_Publication_62_4.pdf
 | [NAME]. 3
 |  | Maryland Constants
 |  | L1 | 3000000
 |  | L2 | 633600
 |  | L3 | 15893950.36
 |  | [NAME] | 16564628.77
 |  | L5 | 0.9998480641
 |  | L6 | 0.796922394
 |  | L7 | 3161
 |  | L8 | 47.87068
 |  | L9 | 3.79919
 |  | L10 | 5.9155
 |  | L11 | 44
 |  |  |  | Constant
Coordinates to State Plane |  |  |  | 10^8
 | Degree | Minutes | Seconds
Φ (Lat) | 54 | 27 | 30
ʎ (Long) | 164 | 2 | 30
 |  |  |  | Lat Seconds/3600
Easting (x) |  |  |  | s
Northing (y) |  |  | Radius | R
 |  |  | Degree and minutes | Φ'
 |  |  | Remainder in seconds | Φ''
 |  |  |  | [NAME]
 |  |  |  | cosΦ
 |  |  | Theta | Θ
 |  |  |  | sinΘ
 |  |  |  | sin(Θ/2)
 |  |  | Easting | x
 |  |  | Northing | y
 |  |  | Scale Factor | K
State Plane to Coordinates
 |  |  |  | x/y
Easting (x) | 5533424.3913 |  | Theta | Θ
Northing (y) | 1473805.1278 |  | Dec. Degree of Theta | Θ for ʎ
 |  |  | Long. in Seconds | ʎ
 |  |  | Long. Dec. Degree | ʎ/3600
[NAME]
Decimal Long |  |  | Radius | R
 |  |  |  | s1
 |  |  |  | s2
 |  |  |  | s3
 |  |  |  | s
 |  |  | Omega | w' |  | w' (decimal degrees)
 |  |  |  | w'' |  | w''(decimal degrees)
 |  |  |  | w |  | w (decimal degrees)
 |  |  |  | sinw
 |  |  |  | cosw
 |  |  | Phi | Φ' |  | Φ' (decimal degrees)
 |  |  |  | Φ'' |  | Φ''(decimal degrees)
 |  |  |  | Φ |  | Φ(decimal degrees)
 |  |  | Use Theta for | cosΘ
 |  |  | these constants | sin(Θ/2)
Spreadsheet: 7b99bfe9-26e8-4931-84a1-cd9eb0c4135f
Sheet: Sheet1

Svoz komunálního odpadu na rok 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | Po | Út | St | Čt | Pá | So | Ne |  |  | Po | Út | St | Čt | Pá | So | Ne
[NAME] |  |  |  |  |  |  | 1 |  | červenec |  |  |  |  |  |  | 1
 | 2 | 3 | 4 | O | 6 | 7 | 8 |  |  | 2 | 3 | 4 | O | 6 | 7 | 8
 | 9 | 10 | 11 | O | 13 | 14 | 15 |  |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | O | 20 | 21 | 22 |  |  | 16 | 17 | 18 | OP | 20 | 21 | 22
 | 23 | 24 | 25 | OP | 27 | 28 | 29 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | 30 | 31 |  |  |  |  |  |  |  | 30 | 31
únor |  |  | 1 | O | 3 | 4 | 5 |  | srpen |  |  | 1 | O | 3 | 4 | 5
 | 6 | 7 | 8 | O | 10 | 11 | 12 |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | 13 | 14 | 15 | O | 17 | 18 | 19 |  |  | 13 | 14 | 15 | O | 17 | 18 | 19
 | 20 | 21 | 22 | OP | 24 | 25 | 26 |  |  | 20 | 21 | 22 | 23 | 24 | 25 | 26
 | 27 | 28 | 29 |  |  |  |  |  |  | 27 | 28 | 29 | OP | 31
březen |  |  |  | O | 2 | 3 | 4 |  | září |  |  |  |  |  | 1 | 2
 | 5 | 6 | 7 | O | 9 | 10 | 11 |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | 12 | 13 | 14 | O | 16 | 17 | 18 |  |  | 10 | 11 | 12 | O | 14 | 15 | 16
 | 19 | 20 | 21 | O | 23 | 24 | 25 |  |  | 17 | 18 | 19 | 20 | 21 | 22 | 23
 | 26 | 27 | 28 | OP | 30 | 31 |  |  |  | 24 | 25 | 26 | OP | 28 | 29 | 30
duben |  |  |  |  |  |  | 1 |  | říjen | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 2 | 3 | 4 | O | 6 | 7 | 8 |  |  | 8 | 9 | 10 | O | 12 | 13 | 14
 | 9 | 10 | 11 | O | 13 | 14 | 15 |  |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 16 | 17 | 18 | O | 20 | 21 | 22 |  |  | 22 | 23 | 24 | OP | 26 | 27 | 28
 | 23 | 24 | 25 | OP | 27 | 28 | 29 |  |  | 29 | 30 | 31
 | 30
[NAME] |  | 1 | 2 | O | 4 | 5 | 6 |  | listopad |  |  |  | O | 2 | 3 | 4
 | 7 | 8 | 9 | O | 11 | 12 | 13 |  |  | 5 | 6 | 7 | O | 9 | VN | 11
 | 14 | 15 | 16 | 17 | 18 | VN | 20 |  |  | 12 | 13 | 14 | O | 16 | 17 | 18
 | 21 | 22 | 23 | OP | 25 | 26 | 27 |  |  | 19 | 20 | 21 | O | 23 | 24 | 25
 | 28 | 29 | 30 | 31 |  |  |  |  |  | 26 | 27 | 28 | OP | 30
červen |  |  |  |  | 1 | 2 | 3 |  | prosinec |  |  |  |  |  | 1 | 2
 | 4 | 5 | 6 | O | 8 | 9 | 10 |  |  | 3 | 4 | 5 | O | 7 | 8 | 9
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  |  | 10 | 11 | 12 | O | 14 | 15 | 16
 | 18 | 19 | 20 | OP | 22 | 23 | 24 |  |  | 17 | 18 | 19 | O | 21 | 22 | 23
 | 25 | 26 | 27 | 28 | 29 | 30 |  |  |  | 24 | 25 | 26 | OP | 28 | 29 | 30
 |  |  |  |  |  |  |  |  |  | 31
 | O | odpady |  |  | OP | [NAME] |  |  |  | VN | velkoobjemový a nebezpečný
Spreadsheet: 762544d1641628853-vlookup-for-multiple-criteria-vlookup
Sheet: Sheet2

DM Count
DM Co-ordinators
Month | (All)
Count of DM No. |  | Status
MUD ID | DM  Co-ordinator | Completed | Pending | Grand Total
ay646410 | Aniket Yashwant |  | 1 | 1
[NAME] | [NAME] | 1 |  | 1
cb832551 | [NAME] |  | 1 | 1
dvr95541 | Dande Reddy |  | 1 | 1
gg336016 | [NAME] | 1 |  | 1
md891090 | [NAME] |  | 1 | 1
mg104360 | [NAME] |  | 1 | 1
nm846496 | Naraparaju Manasa |  | 1 | 1
rh294814 | [NAME] |  | 1 | 1
Spreadsheet: 06768681-9f57-4ab1-a768-23efa171e32e
Sheet: Sheet1

. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
NAME | STATE | ARRIVE | DEPART
Penny & Jamie | MD | 2 | 9
Pam & Ronnie | OK | 5 | 12
Donna & Pat | WI | 7 | 11
Beverly & Tom | MI | 9 | 23
Donna & Curtis | TX | 10 | 17
Nikki & Josh | SC | 13 | 20
Cathy & Alan | MI | 13 | 23
Tina & Jodi | Newfoundland | 13 | 20
Brian & Star | WI | 20 or 25 | 26 or 7th
David & Mary | NH | 23 | 2010-03-01 00:00:00
Barb & ? | ? | 6 | 14
Harold & Sabrina | OH | 19 | 26
Darryl & Candace | Regina, Sask. | 14 | 21
Josh & Jennie | MN | 8 | 14
[NAME] | Toronto | 1 | 10
Ted & Cindy | FL | 19 | 27
Dave & Cheryl | ? | 2010-01-29 00:00:00 | 5
Tim & Salina | ? | 15 | 22
Graham & Maureen | UK | 9 | 23
Rex & Gloria | UK | 9 | 23
[NAME] | UK | 9 | 30
Chris & Ann | Canada | 16 | 2010-03-02 00:00:00
Bill & Lana | MI | 18 | 25
Anne & Martin | UK | 10 | 19
Renee & Steve |  | 7 | 13
Dawn & Bill | MI | 10 | 19
Rachael & Jason | FL | 8 | 13
Ron & Heather | MA | 10 | 20?
Mike & Cami |  | 7 | 14
Tiffany & Jesse | Iowa | 20 | 27
Andy & Kristina | Canada | 10 | 17
Joe & Lynn | WI | 11 | 18
[NAME] | MD | 11 | 17
Elmer & Sue | MI | 11 | 18
Eric & Beth |  | 5 | 9
Mike & Kathy | WV | 20 | 27
Steve & Sara | WA | 20 | 26
Christian & Crystal | MI | 16 | 23
Brian & Alison | SD | 26 | 2010-03-05 00:00:00
David & Candide | Canada | 17 | 27
Andy & Jill | Canada | 6 | 13
Randy & Carol |  | 5 | 15
Spreadsheet: 06ba2902-ad65-4d38-b6aa-168674f16992
Sheet: Sheet1

Table 3--Cash feed grain prices, 3/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Mkt year and month 1/ | Corn, No. 2 yellow,  Central IL (dollars per bushel) |  |  | Corn, No. 2 yellow,  Gulf ports, LA  (dollars per bushel) |  |  | Sorghum, No. 2 yellow,  Plainview to [NAME], TX  (dollars per cwt) |  | Sorghum, No. 2 yellow,  Gulf ports, LA  (dollars per cwt)
 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2012/13
Sep | 4.51 | 6.77 | 7.7 | 5.225 | 7.5 | 8.145 | 7.74 | 11.48 | 9.79 | 12.88 | 12.965
Oct | 5.19 | 6.23 | 7.48 | 5.985 | 6.975 | 8.155000000000001 | 8.54 | 10.73 | 10.395 | 12.08 | 13.2
Nov | 5.33 | 6.26 | 7.39 | 6.05 | 6.97 | 8.175 | 8.78 | 10.96 | 10.745 | 12.44 | 13.095
Dec | 5.65 | 5.96 | 7.23 | 6.36 | 6.57 | 7.845 | 9.62 | 10.5 | 11.1 | 11.82 | 13.14
Jan | 6.1 | 6.25 | 7.17 | 6.73 | 6.935 | 7.699999999999999 | 10.46 |  | 11.905 | 12.2 | 13.13
Feb | 6.69 | 6.41 | 7.15 | 7.435 | 7.1 | 7.695 | 11.42 |  | 12.625 | 12.09 | 13.115
Mar | 6.59 | 6.46 |  | 7.375 | 7.13 |  | 11.45 |  | 12.64 | 12.035
Apr | 7.33 | 6.34 |  | 8.11 | 6.96 |  | 12.78 |  | 13.675 | 11.94
May | 7.08 | 6.27 |  | 7.82 | 6.84 |  | 12.22
Jun | 7.17 | 6.3 |  | 7.89 | 6.785 |  | 12.21
Jul | 6.96 | 7.85 |  | 7.64 | 8.455 |  | 10.69 |  | 12.65
Aug | 7.3 | 8.15 |  | 7.88 | 8.435 |  | 11.47 |  | 13.71 | 13.47
Mkt year | 6.324999999999999 | 6.604166666666665 |  | 7.041666666666667 | 7.22125 |  | 10.615 | 10.9175 | 11.9235 | 12.32833333333333
 | Barley, No. 2 feed,  Minneapolis, MN  (dollars per bushel) |  |  | Barley, No. 3 malting,  Minneapolis, MN  (dollars per bushel) |  |  | Oats, No. 2 white heavy,  Minneapolis, MN  (dollars per bushel)
 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2012/13 | 2010/11 | 2011/12 | 2012/13
Jun | 2.2275 | 5.06 | 5.15 | 3.2 | 7.395 | 7.03 | 2.3875 | 3.675 | 3.365
Jul | 2.06 | 5.18 | 5.52 |  | 7.72 | 6.89 | 2.58 | 3.68 | 3.95
Aug | 2.5425 | 5.25 | 5.78 |  | 7.83 | 6.95 | 2.6875 | 3.69 | 3.985
Sep | 2.9925 | 5.14 | 5.58 |  | 7.76 | 6.99 | 3.135 | 3.72 | 3.885
Oct | 3.32 | 5.16 | 5.51 |  | 7.64 | 7.11 | 3.5625 | 3.51 | 3.98
Nov | 3.57 | 5.29 | 5.49 | 4.7 | 7.6 | 7.23 | 3.5375 | 3.36 | 3.85
Dec | 3.888 | 5.17 | 5.29 | 5.1595 | 7.32 | 7.22 | 3.88 | 3.3 | 3.94
Jan | 4.15 | 5.24 | 5.08 | 5.58 | 7.2 | 7.09 | 3.93 | 3.16 | 3.79
Feb | 4.62 | 5.26 | 5.16 | 5.91 | 7.07 | 7.04 | 4.075 | 3.455 | 4.07
Mar | 4.74 | 5.37 |  | 5.92 | 7.05 |  | 3.55 | 3.475
Apr | 5.05 | 5.18 |  | 6.2 | 7.03 |  | 3.83 | 3.55
May | 4.83 | 5.21 |  | 6.43 | 7 |  | 3.55 | 3.475
Mkt year | 3.665874999999999 | 5.209166666666667 |  | 5.3874375 | 7.384583333333333 |  | 3.392083333333332 | 3.504166666666666
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Simple average of monthly prices for the marketing year. Source: USDA, Agricultural Marketing Service, http://marketnews.usda.gov/portal/lg.
Data run: 3/10/2013
Spreadsheet: 112457d1308588182-graphing-ranges-range-graphing-dilemma
Sheet: Sample

 |  |  |  |  |  | 50 | 52 | 54 | 56 | 58 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 74 | 76 | 78 | 80 | 82 | 84 | 86 | 88 | 90 | 92 | 94 | 96 | 98 | 100 | Dist to next point | Betwn points
Store X | Threshold - 50th | Benchmk 95th | Green Start | Base- Line | Current Perf
Measure #1 | 66.02 | 82.52 | 64 | 66.07060981201244 | 66
Measure #2 | 75 | 84.7 | 71.84777947990081 | 70.3977794799008 | 72
Measure #3 | 79.42 | 89 | 82.0066155814025 | 81.2166155814025 | 85
Measure #4 | 59.28 | \ | 57 | 56.2515821606725 | 58.5
Measure #5 | 61.82 | 77.69 | 63.57888305204094 | 62 | 60
Notes:
Blue range = B start, C end
Green range =D Start, C end
Orange marker = CurrentPerformance
Spreadsheet: 220728d1363250722-combine-if-and-vlookup-and-sum-it-sample
Sheet: PAYMENT

NO CUST | NO | NO INV | COMPANY | CP | INVOICE | PAYMENT | DISCOUNT | TOTAL | BALANCE
A11 | 1 |  |  |  |  | 1000
A12 | 1 |  |  |  |  | 500 | 200
A13 | 1 |  |  |  |  | 500 | 200
Spreadsheet: 810705d1671971811-i-need-help-in-if-function-and-select-multiple-choose-multiple-choice-ans
Sheet: Sheet1

text3 | 9 |  |  | text1 |  | 1 | 6 | 11 |  |  | =IF(A1="Text1",$G$1:$G$5,IF(A1="Text2",$H$1:$H$5,IF(A1="Text3",$I$1:$I$5,"")))
 |  |  |  | text2 |  | 2 | 7 | 12
 |  |  |  | text3 |  | 3 | 8 | 13
 |  |  |  |  |  | 4 | 9 | 14
 |  |  |  |  |  | 5 | 10 | 15
Spreadsheet: jeff_dasovich__14138__2000WK15final
Sheet: Payout

 |  | Total | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | LPS | Wk 15 | Wk 16 | Wk 17 | Season | [NAME]
 | [NAME] |  |  | 42.5 |  |  |  |  |  | 65 |  |  |  | 20 | 50 |  |  | 65
 | Mike&Lisa |  |  |  |  |  |  |  |  |  |  |  | 65 | 35 |  |  | 120
 | Narvco |  | 65 |  |  | 50 |  |  |  |  |  |  | 50 |  | 35
 | [NAME] |  |  | 65 |  |  | 50 |  |  |  |  | 65
 | Eldon |  | 18.33 |  |  |  |  |  |  |  |  | 50 | 35 |  | 65
 | Sheas |  |  |  |  |  |  | 65 |  |  |  |  |  |  | 20 | 4 |  | 50
 | Barrie |  |  |  | 20 |  | 65 |  | 50
 | Cameron |  |  |  | 65 |  |  |  |  | 20 | 20
 | [NAME] |  |  |  |  |  |  |  | 65 |  |  |  |  |  |  | 65
 | [NAME] |  |  |  |  |  |  |  |  |  |  | 35 |  | 65 |  | 4 |  | 20
 | [NAME] |  |  |  |  | 65 |  | 50 |  |  |  |  |  |  |  | 4
 | Hank |  |  | 42.5 |  |  | 20 |  |  |  |  | 20
 | JAM |  | 50 |  |  |  |  |  |  | 50
 | [NAME] |  |  |  | 50 |  |  |  |  |  | 35 |  |  |  |  | 4
 | Helmet |  |  |  |  |  |  |  |  | 35 | 50 |  |  |  |  | 4
 | [NAME] |  |  |  |  |  |  | 35 |  |  |  |  |  | 50
 | Growney |  | 18.33 |  |  |  |  |  |  |  | 65
 | Daryl |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  | 50
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 | WAM |  |  |  |  |  | 35 | 20
 | [NAME] |  | 18.34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 | [NAME] |  |  |  | 35
 | Carlton |  |  | 20
 | Prentice |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | [NAME]
 | TOTAL DOLLARS PAID OUT
Spreadsheet: 173102d1344437612-listing-all-results-that-match-a-test-array-query-modified-by-tigeravatar-
Sheet: Sheet1

Name | [NAME] |  |  |  |  |  |  |  |  |  |  | Grade | Names
Student 1 | 1a-2a |  |  |  |  |  |  |  |  |  |  | 1a-2a | Student 1 | Student 18 | Student 22 | Student 36
Student 2 | 2a-3c |  |  |  |  |  |  |  |  |  |  | 1b-5a | Student 7 | Student 20 | Student 21 | Student 34
Student 3 | 5a-2c |  | [NAME] | Name |  |  |  |  |  |  |  | 2a-3c | Student 2 | Student 15 | Student 26 | Student 33
Student 4 | 2c-2c |  | 1a-2a | Student 1 |  |  |  |  |  |  |  | 2c-2c | Student 4 | Student 19 | Student 24 | Student 35
Student 5 | 4a-5c |  |  | Student 18 |  |  |  |  |  |  |  | 2c-5a | Student 9 | Student 13 | Student 23 | Student 32
Student 6 | 3c-2b |  |  | Student 22 |  |  |  |  |  |  |  | 3a-3a | Student 8 | Student 12 | Student 28 | Student 37
Student 7 | 1b-5a |  |  | Student 36 |  |  |  |  |  |  |  | 3c-2b | Student 6 | Student 16 | Student 30 | Student 38
Student 8 | 3a-3a |  | 1b-5a | Student 20 |  |  |  |  |  |  |  | 4a-5c | Student 5 | Student 17 | Student 29 | Student 31
Student 9 | 2c-5a |  |  | Student 21 |  |  |  |  |  |  |  | 4b-5b | Student 10 | Student 11 | Student 25 | Student 39
Student 10 | 4b-5b |  |  | Student 34 |  |  |  |  |  |  |  | 5a-2c | Student 3 | Student 14 | Student 27 | Student 40
Student 11 | 4b-5b |  |  | Student 7
Student 12 | 3a-3a |  | 2a-3c | Student 15
Student 13 | 2c-5a |  |  | Student 2
Student 14 | 5a-2c |  |  | Student 26
Student 15 | 2a-3c |  |  | Student 33
Student 16 | 3c-2b |  | 2c-2c | Student 19
Student 17 | 4a-5c |  |  | Student 24
Student 18 | 1a-2a |  |  | Student 35
Student 19 | 2c-2c |  |  | Student 4
Student 20 | 1b-5a |  | 2c-5a | Student 13
Student 21 | 1b-5a |  |  | Student 23
Student 22 | 1a-2a |  |  | Student 32
Student 23 | 2c-5a |  |  | Student 9
Student 24 | 2c-2c |  | 3a-3a | Student 12
Student 25 | 4b-5b |  |  | Student 28
Student 26 | 2a-3c |  |  | Student 37
Student 27 | 5a-2c |  |  | Student 8
Student 28 | 3a-3a |  | 3c-2b | Student 16
Student 29 | 4a-5c |  |  | Student 30
Student 30 | 3c-2b |  |  | Student 38
Student 31 | 4a-5c |  |  | Student 6
Student 32 | 2c-5a |  | 4a-5c | Student 17
Student 33 | 2a-3c |  |  | Student 29
Student 34 | 1b-5a |  |  | Student 31
Student 35 | 2c-2c |  |  | Student 5
Student 36 | 1a-2a |  | 4b-5b | Student 10
Student 37 | 3a-3a |  |  | Student 11
Student 38 | 3c-2b |  |  | Student 25
Student 39 | 4b-5b |  |  | Student 39
Student 40 | 5a-2c |  | 5a-2c | Student 14
 |  |  |  | Student 27
 |  |  |  | Student 3
 |  |  |  | Student 40
Spreadsheet: 60f8e010-d1e2-4dd8-905c-4747eb38ecf0
Sheet: Sheet1

Table S3. Non-uniform distribution of transcription factor binding sites in 1234 ChIP-PET clusters. | Unnamed: 1
Matrix ID | KS P-Value (Uniformity Test)
V$ER_Q6 | 0
V$AP1_Q4_01 | 9.26031e-05
V$MAF_Q6_01 | 0.000154511
V$CDX_Q5 | 0.000179074
V$HNF4_DR1_Q3 | 0.000211917
V$PAX4_04 | 0.000367927
V$AP1FJ_Q2 | 0.001221904
V$XPF1_Q6 | 0.001761561
V$HNF3_Q6_01 | 0.002094836
V$TEF1_Q6 | 0.003514786
V$PAX4_02 | 0.003579646
V$HNF1_Q6 | 0.00380395
V$IRF_Q6 | 0.004269518
[NAME] | 0.005280014
V$PAX3_B | 0.0106795
V$MZF1_01 | 0.01395462
V$CEBP_Q2 | 0.01458712
V$HEB_Q6 | 0.01620494
V$CREB_01 | 0.01692855
[NAME] | 0.01905445
V$TBP_Q6 | 0.02625256
V$HNF4_Q6_01 | 0.02833451
V$AP1_Q4 | 0.02911702
V$YY1_Q6_02 | 0.0320748
V$LMO2COM_02 | 0.03273565
V$YY1_Q6 | 0.03290717
[NAME] | 0.03419564
V$CDXA_01 | 0.03586093
V$USF_Q6 | 0.03782217
V$AP3_Q6 | 0.03785829
V$FOXP3_Q4 | 0.03875088
V$HNF3_Q6 | 0.04125332
V$CREBP1CJUN_01 | 0.0420016
V$YY1_01 | 0.04380453
V$SF1_Q6 | 0.0452036
V$COUPTF_Q6 | 0.04952814
V$PAX_Q6 | 0.05159526
V$AP2_Q6_01 | 0.05515753
Spreadsheet: 214716d1361080435-need-help-with-populating-worksheet-with-rows-from-other-sheet-based-on-criteria-2013-pinto-schedule
Sheet: Phillies

Field | Date | Day | Start Time | Away | AC | HC | Home |  | Code | Team | Away Games | Home Games | Total Games
 |  |  |  |  |  |  |  |  | 1 | A's
 |  |  |  |  |  |  |  |  | 2 | Cubs
 |  |  |  |  |  |  |  |  | 3 | Dodgers
 |  |  |  |  |  |  |  |  | 5 | Pirates
 |  |  |  |  |  |  |  |  | 6 | Tigers
 |  |  |  |  |  |  |  |  | 7 | Yankees
Spreadsheet: 56367d1256566649-formula-count-occurences-in-a-specific-time-period-sarahmad
Sheet: Sheet1

Hospital Number | Date | Theatre | Hour | Time into PACU | Time Out of PACU
 | 2009-10-10 00:00:00 |  |  | 09:00:00 | 11:20:00
 | 2009-10-10 00:00:00 |  |  | 20:50:00 | 02:00:00
 | 2009-10-10 00:00:00 |  |  | 08:01:00 | 23:00:00
Hour | # Patients
09:01:00 | 2
21:00:00 | 2
Spreadsheet: 192065d1352299549-link-the-background-color-to-background-color-of-another-cell-longxin-conditional-formatting-for-dates-holidaysheetcalculations_template
Sheet: Q2

Apr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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 | 26 | 27 | 28 | 29 | 30
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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 | 26 | 27 | 28 | 29 | 30 | 31
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Jun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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 | 26 | 27 | 28 | 29 | 30
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Spreadsheet: 108280d1305299111-excel-2007-if-formula-attendance-sheet-for-testing
Sheet: Attendance Infraction Input

 |  | Manufacturing   Department # 00000
 |  | [NAME] |  |  |  |  |  |  |  |  |  | Current Status
 | Month | Date | Employee Name | Employee # | Infraction | Infraction Code | Severity | Previous Infractions? | # Days Since Last Infraction | Action Required? |  | Action to be Taken | Action taken on:
 |  |  | Employee Master List |  | Infraction List |  |  |  |  |  |  | Actions
 |  | 2011-04-01 00:00:00 | Test 1 |  | Early Departure
 |  | 2011-04-11 00:00:00 | Test 3 |  | No Show
 |  | 2011-06-05 00:00:00 | Test 1 |  | No Call/No Show
 |  | 2011-06-09 00:00:00 | Test 3 |  | Late Arrival
 |  | 2011-06-12 00:00:00 | Test 2 |  | No Call/No Show
 |  | 2011-06-13 00:00:00 | Test 3 |  | Early Departure
 |  | 2011-06-14 00:00:00 | Test 8 |  | No Call/No Show
 |  | 2011-06-15 00:00:00 | Test 2 |  | No Call/No Show
 |  | 2011-06-16 00:00:00 | Test 3 |  | Late Arrival
 |  | 2011-06-17 00:00:00 | Test 4 |  | Early Departure
 |  | 2011-07-12 00:00:00 | Test 3 |  | No Call/No Show
 |  | 2011-08-02 00:00:00 | Test 1 |  | No Call/No Show
 |  | 2011-09-12 00:00:00 | Test 7 |  | Early Departure
 |  | 2011-10-02 00:00:00 | Test 1 |  | Late Arrival
 |  | 2011-10-04 00:00:00 | Test 3 |  | Late Arrival
 |  | 2011-10-09 00:00:00 | Test 3 |  | No Show
 |  | 2011-10-11 00:00:00 | Test 13 |  | No Call/No Show
 |  | 2011-10-12 00:00:00 | Test 5 |  | Late Arrival
 |  | 2011-10-16 00:00:00 | Test 13 |  | Early Departure
 |  | 2011-10-20 00:00:00 | Test 5 |  | No Call/No Show
 |  | 2011-10-22 00:00:00 | Test 4 |  | No Show
 |  | 2011-10-25 00:00:00 | Test 8 |  | Late Arrival
Spreadsheet: 124320d1318336082-data-extraction-for-insurance-policy-data-extraction-and-auto-insurance-formulas
Sheet: Solution

Calculate automobile liability.
Name of Insured | Policy Formula | BI | [NAME] | Prop | Injured #1 Medical Expenses | Amount Paid Ins. Co. for #1 | Injured #2 Medical Expenses | Amount Paid Ins. Co. for #2 | Amount of Property Damage | Property Damage Ins. Co. Pays | Property Damage Insured Pays | Medical Expense Insured Pays | Total Insured Pays | Insurance Company Pays
Hendrix, [NAME] | 40/50/25 |  |  |  | 20000 |  | 23000 |  | 22000
Ivy, Denia | 300/30/40 |  |  |  | 50500 |  | 56000 |  | 28000
Jeans, [NAME] | 50/75/50 |  |  |  | 29000 |  | 42000 |  | 15000
Martinez, [NAME] | 20/25/100 |  |  |  | 35000 |  | 12000 |  | 18000
[NAME], [NAME] | 75/100/50 |  |  |  | 30000 |  | 19000 |  | 65000
Directions:
[NAME] the Policy Formula’s amount for one person's injury to Injured #1’s Medical Expenses and key in Column D the Amount Paid by the Insurance       Company for Injured #1. (The first amount in Policy Formula is the maximum paid for any one person injured.)
[NAME] the maximum amount for one person's injuries to Injured #2’s expenses and key in Column F the Amount Paid by the Insurance Company for       Injured #2.(Be sure to consider what has been paid for #1 and the maximum allowable, which is the second figure in the Policy Formula.) Normally an equal        amount would be paid to the Injured, but for this exercise, pay the second Injured the difference.
c.  Compare the Policy Formula’s maximum for property damage and key in Column H the amount the insurance company will pay. In column I, calculate          the amount the insured pays. (Subtract Column H from Column G.)
d.  Enter multimath formulas in Column J to calculate the Amount Insured Pays. (Add Injured #1’s and #2’s expenses and then subtract the Amount Paid by        Insurance Company for each.) The difference is what the Insured must pay of the medical expenses.
e.  Enter formulas in Column K to calculate Total Insured Pays of property damages and medical expenses.
f.  Enter formulas to calculate the total amount the Insurance Company Pays.
I am having trouble with column C, D, E. My formulas are not working right. For example, if I were to change my policy formula to a three-digit in any of the
three partitions, then my formulas in column C,D,E are not going to work.
I need a very flexible formula in C,D, E that would work for all scenarios. I tried to key in the other formulas for the rest of the table, but I am not sure if I got it right. Would someone please look into
my table to see if you can spot mistakes. Please feel free to modify this sheet as you like. Thanks.
 |  |  | Wrong Results
Spreadsheet: 683406d1592717324-return-all-empty-and-blank-string-cells-blank-and-empty-cells
Sheet: Sheet1

 |  |  |  | Current Array - Incorrect Values and Zeros |  |  |  |  | What I Want
 | Text | Test1 |  |  |  |  |  |  | Test1
 | [NAME] of ="" |  |  |  |  |  |  |  | Test2
 | Text | Test2 |  |  |  |  |  |  | Test3
 | Empty cell
 | Text | Test3