tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274966d1383294358-sumproduct-indirect-array-containing-both-ors-and-ands-example
Sheet: example3

 | THIS WOULD BE THE IDEAL TABLE CONFIGURATION |  |  |  |  |  |  |  |  |  |  | BUT THIS IS HOW I ENDED UP CREATING THE TABLE FOR THE SUMPRODUCT
 | OR |  |  |  | AND | AND | Result of Values that meet criteria to be included in INDIRECT TEST sumproduct |  |  |  |  | OR 1 |  | OR 2 |  | OR 3 |  | OR 4 |  | AND | AND | Result of Values that meet criteria to be included in INDIRECT TEST sumproduct
 | 12345 | 11111 | 54321 | ABCDE | YEAR | Random Number |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR | Random Number
 | 0 | 0.6 | 0 | 0 | 2017 | 400 | 240 |  |  |  |  | 12345 | 0 | 11111 | 0.6 | 54321 | 0 | ABCDE | 0 | 2017 | 400 | 240
 | 0 | 0 | 0.5 | 0 | 2017 | 600 | 0 |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0.5 | ABCDE | 0 | 2017 | 600 | 0
 | 0.5 | 0 | 0 | 0 | 2014 | 300 |  |  |  |  |  | 12345 | 0.5 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2014 | 300
 | 0 | 0 | 0.4 | 0 | 2017 | 800 | 0 |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0.4 | ABCDE | 0 | 2017 | 800 | 0
 | 0 | 0.4 | 0 | 0.5 | 2014 | 600 |  |  |  |  |  | 12345 | 0 | 11111 | 0.4 | 54321 | 0 | ABCDE | 0.5 | 2014 | 600
 | 1 | 0 | 0 | 0 | 2013 | 600 |  |  |  |  |  | 12345 | 1 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2013 | 600
 | 0 | 0 | 0 | 0 | 2016 | 350 |  |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2016 | 350
 | 0 | 0.5 | 0.4 | 0 | 2018 | 4000 |  |  |  |  |  | 12345 | 0 | 11111 | 0.5 | 54321 | 0.4 | ABCDE | 0 | 2018 | 4000
 | 0.4 | 0 | 0 | 0 | 2014 | 1000 |  |  |  |  |  | 12345 | 0.4 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2014 | 1000
 | 0 | 0 | 0 | 0.4 | 2017 | 600 | 0 |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0 | ABCDE | 0.4 | 2017 | 600 | 0
 | 0 | 0 | 0 | 0.3 | 2014 | 600 |  |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0 | ABCDE | 0.3 | 2014 | 600
 | 0 | 0 | 0 | 0 | 2013 | 350 |  |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2013 | 350
 | 0 | 0 | 0.4 | 0 | 2017 | 600 | 0 |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0.4 | ABCDE | 0 | 2017 | 600 | 0
 | 0.2 | 0 | 0 | 0 | 2014 | 600 |  |  |  |  |  | 12345 | 0.2 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2014 | 600
 | 0 | 0 | 0 | 0 | 2013 | 350 |  |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2013 | 350
 | 0 | 0 | 0 | 0 | 2016 | 4000 |  |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0 | ABCDE | 0 | 2016 | 4000
 | 0 | 0 | 0 | 0.2 | 2017 | 1000 | 0 |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0 | ABCDE | 0.2 | 2017 | 1000 | 0
 | 0 | 0 | 0.4 | 0 | 2014 | 600 |  |  |  |  |  | 12345 | 0 | 11111 | 0 | 54321 | 0.4 | ABCDE | 0 | 2014 | 600
 | 0 | 0.5 | 0 | 0 | 2022 | 4 |  |  |  |  |  | 12345 | 0 | 11111 | 0.5 | 54321 | 0 | ABCDE | 0 | 2022 | 4
 | Blue cells meet criteria within sumproduct but green is whole rows that meet all criteria on Overview sheet
Spreadsheet: 146366d1332150911-knowing-two-cells-in-a-list-count-the-number-of-cells-levels-between-them-data1
Sheet: Sheet1

 | Start | Finish | Levels
 | 2b | 4c | 7
 | 4a | 4a | 0
 | 4a | 4c | 2
 | 3a | 4c | 5
 | Levels
 | 1a | 1
 | 1b | 2
 | 1c | 3
 | 2a | 4
 | 2b | 5
 | 2c | 6
 | 3a | 7
 | 3b | 8
 | 3c | 9
 | 4a | 10
 | 4b | 11
 | 4c | 12
 | 5a | 13
 | 5b | 14
 | 5c | 15
Spreadsheet: 170268d1343224379-auto-updating-info-in-multiple-spreadsheets-from-one-spreadsheet-mochmillsamples
Sheet: Sheet2

13 | 2 | 90 | 22 | 0 | 1 | 1 | 0 | 16 | 3 | [NAME] | 100 | 200 | 3 | 3 | 3 | 3T | 2 | 3 | 0 | 200
22 | 97 | 92 | 61 | 8 | 80 | 40 | 18 | 62 | 95 | [NAME] | 500 | 300 | 4 | 4 | MSF | MST | 3 | 4 | 1 | M200
24 |  |  |  | 18 | 91 | 80 |  |  |  | [NAME] | 900 |  | 6 |  |  | DRITHERM | 4 | 6 | 2
 |  |  |  | 60 | 93 | 91 |  |  |  | [NAME] | 1300 |  |  |  |  |  | 5 | 70 | 3
 |  |  |  |  | 94 |  |  |  |  |  | 1700 |  |  |  |  |  | 6 | 200 | 13
 |  |  |  |  |  |  |  |  |  |  | 2100 |  |  |  |  |  | 8 | 300 | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | MSF | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | M3T | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | MST | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HICOM | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
Spreadsheet: 98140d1297178043-function-to-return-max-value-for-a-range-safety-incentive
Sheet: Sheet2

Clk | First Name | Last Name | Start Date | $'s Due | No Puzzle
21 | Curtis | Mitchell | 2006-10-01 00:00:00 | 40 | Y
23 | Melvin | Burks | 2009-03-01 00:00:00 | 40 | Y
24 | [NAME] | Overstreet | 2007-08-01 00:00:00 | 40 | Y
32 | Doug | King | 2010-10-01 00:00:00 | 40 | Y
33 | [NAME] | Burks | 2004-12-01 00:00:00 | 40 | Y
44 | [NAME] | Burks | 2008-03-01 00:00:00 | 40 | Y
76 | [NAME] | Lipscomb | 2008-02-01 00:00:00 | 40 | Y
81 | [NAME] | [NAME] | 2006-03-01 00:00:00 | 40 | Y
99 | [NAME] | Burks | 2006-02-01 00:00:00 | 40 | Y
106 | Gregory | Sandidge | 2010-10-01 00:00:00 | 40 | Y
109 | [NAME] | Hall | 2010-10-01 00:00:00 | 40 | Y
113 | [NAME] | Poe | 2011-02-01 00:00:00 | 0 | Y
116 | [NAME] | Harvey | 2011-02-01 00:00:00 | 0 | Y
118 | [NAME] | King | 2010-10-01 00:00:00 | 40 | Y
120 | [NAME] | Hines | 2008-08-01 00:00:00 | 40 | Y
129 | Clyde | Wise, Jr | 2009-01-01 00:00:00 | 40 | Y
132 | [NAME] | Martin | 2007-06-01 00:00:00 | 40 | Y
134 | Timmy | Tyree | 2008-02-01 00:00:00 | 40 | Y
135 | [NAME] | [NAME] | 2011-02-01 00:00:00 | 0 | Y
137 | [NAME] | Tyree | 2008-02-01 00:00:00 | 40 | Y
140 | [NAME] | [NAME] | 2010-07-01 00:00:00 | 40 | Y
141 | Ray | Cunningham | 2010-10-01 00:00:00 | 40 | Y
144 | [NAME] | Grishaw | 2010-07-01 00:00:00 | 40 | Y
145 | [NAME] | Marcus | 2008-06-01 00:00:00 | 40 | Y
146 | [NAME] | Marcus | 2008-03-01 00:00:00 | 40 | Y
150 | [NAME] | Fitzgerald | 2009-11-01 00:00:00 | 40 | Y
152 | Ricky | Burks | 2008-07-01 00:00:00 | 40 | Y
154 | [NAME] | St.Clair | 2007-10-01 00:00:00 | 40 | Y
155 | [NAME] | Banton | 2008-12-01 00:00:00 | 40 | Y
156 | [NAME] | [NAME] | 2008-11-01 00:00:00 | 40 | Y
157 | [NAME] | Toliver | 2011-02-01 00:00:00 | 0 | Y
158 | [NAME] | Pennix | 2007-10-01 00:00:00 | 40 | Y
160 | Ricky | Burks, Jr | 2010-04-01 00:00:00 | 40 | Y
161 | Alvin | [NAME] | 2009-03-01 00:00:00 | 40 | Y
162 | [NAME] | [NAME] | 2010-11-01 00:00:00 | 35 | Y
163 | [NAME] | King | 2009-03-01 00:00:00 | 40 | Y
165 | [NAME] | Queener | 2009-03-01 00:00:00 | 40 | Y
167 | [NAME] | Hawes, II | 2010-05-01 00:00:00 | 40 | Y
170 | [NAME] | Overstreet | 2010-12-01 00:00:00 | 30 | Y
177 | [NAME] | Elam | 2009-03-01 00:00:00 | 40 | Y
182 | [NAME] | Roberson | 2007-10-01 00:00:00 | 40 | Y
190 | [NAME] | Grove | 2008-11-01 00:00:00 | 40 | Y
194 | [NAME] | [NAME] | 2008-02-01 00:00:00 | 40 | Y
202 | [NAME] | [NAME] | 2008-02-01 00:00:00 | 40 | Y
208 | [NAME] | [NAME] | 2008-03-01 00:00:00 | 40 | Y
210 | [NAME] | Coffey | 2004-12-01 00:00:00 | 40 | Y
229 | [NAME] | Chambers | 2008-03-01 00:00:00 | 40 | Y
233 | [NAME] | Napier | 2010-12-01 00:00:00 | 30 | Y
240 | [NAME] | Mays | 2008-06-01 00:00:00 | 40 | Y
245 | [NAME] | Camden, Jr | 2011-02-01 00:00:00 | 0 | Y
252 | [NAME] | [NAME] | 2008-08-01 00:00:00 | 40 | Y
258 | Damion | Totty | 2010-07-01 00:00:00 | 40 | Y
269 | [NAME] | Stone | 2007-11-01 00:00:00 | 40 | Y
274 | [NAME] | Stone | 2010-10-01 00:00:00 | 40 | Y
276 | [NAME] | Calloway | 2009-11-01 00:00:00 | 40 | Y
287 | Shannon | Moses | 2010-07-01 00:00:00 | 40 | Y
 |  |  |  | 2015
 |  |  |  | 2015
 |  |  |  | 2015
Spreadsheet: 883068d1731556818-result-to-check-multiple-conditions-and-logics-conditional-formula
Sheet: Sheet2

Project No | Buliding No | Ph. | Child Part | Parent Part Mark | Total Weight | Quantity. | Thickness | [NAME] 1 | Length 1 | Item Code | Item | [NAME] 2 | Stiffener
HY-07133 | A1 | 2 | ST6 | C115 | 64.698 | 2 | 16 | 175 | 1450 | HY-07133A12C115 | ST | 175
HY-07133 | A1 | 2 | W53 | C115 | 1681.551 | 1 | 12 | 1450 | 12129 | HY-07133A12C115 | W | 1450
HY-07133 | A1 | 2 | SP2 | C115 | 223.268 | 1 | 32 | 510 | 1717 | HY-07133A12C115 | SP | 510
HY-07133 | A1 | 2 | SP1 | C115 | 141.153 | 1 | 28 | 370 | 1710 | HY-07133A12C115 | SP | 370
HY-07133 | A1 | 2 | F16 | C115 | 621.924 | 1 | 20 | 370 | 10548 | HY-07133A12C115 | F | 370
HY-07133 | A1 | 2 | F17 | C115 | 706.475 | 1 | 20 | 370 | 11982 | HY-07133A12C115 | F | 370
HY-07133 | A1 | 2 | W44 | C116 | 1250.522 | 1 | 12 | 1450 | 9020 | HY-07133A12C116 | W | 1450
HY-07133 | A1 | 2 | ST47 | C116 | 20.421 | 1 | 10 | 177 | 1448 | HY-07133A12C116 | ST | 177
HY-07133 | A1 | 2 | BP1 | C116 | 397.989 | 1 | 36 | 750 | 1850 | HY-07133A12C116 | 0 | 750
HY-07133 | A1 | 2 | SP1 | C116 | 141.153 | 1 | 28 | 370 | 1710 | HY-07133A12C116 | SP | 370
HY-07133 | A1 | 2 | F12 | C116 | 531.831 | 1 | 20 | 370 | 9020 | HY-07133A12C116 | F | 370
HY-07133 | A1 | 2 | F165 | C116 | 531.831 | 1 | 20 | 370 | 9020 | HY-07133A12C116 | F | 370
HY-07133 | A1 | 2 | W45 | C117 | 1243.59 | 1 | 12 | 1450 | 8970 | HY-07133A12C117 | W | 1450
HY-07133 | A1 | 2 | ST85 | C117 | 20.421 | 1 | 10 | 177 | 725 | HY-07133A12C117 | ST | 177 |  | (I15+M15)*2 since J15 is 50% of i14.
HY-07133 | A1 | 2 | SP1 | C117 | 282.306 | 2 | 28 | 370 | 1710 | HY-07133A12C117 | SP | 370
Condition-1: | Length (Col.J) of Item Code (Col.K) should be lesser than 90% of Col.i
Condition-2 | contains ST in Col.L
Condition-3 | Highest Width1 (Col.i) value that contains W in Col.L of same Item Code
Example: | J2 (1450) is 100% (Greater than 90%) of i3 (1450) (for Item Code HY-07133A12C116) contained W in Col.L
Solution to be displayed in N2 (where ST is shown in Col.L for respective Item Code
If the above condition fails, the result should be Width1 (Col.i)+Width2 (Col.M) multiply with 2
Spreadsheet: 593445d1539155595-populate-cell-based-on-previous-cells-formula-book1
Sheet: Sheet1

 |  |  |  |  |  | Q |  |  | A
 |  |  |  |  |  | W |  |  | B
 |  |  |  |  |  | E |  |  | C
 |  |  |  |  |  | R |  |  | D
 |  |  |  |  |  | T |  |  | E
 |  |  |  |  |  | Y |  |  | F
 |  |  |  |  |  | U |  |  | G
 |  |  |  |  |  | I |  |  | H
 |  |  |  |  |  | O |  |  | I
 |  |  |  |  |  | P |  |  | J
Spreadsheet: 3beb4746-537e-44f7-8845-f4a3ddbf50e4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  |  | Table 31  Relative household by age of the head and spouse
 |  |  |  |  |  |  | 2008 Annual Average |  |  |  |  |  | (Ten thousand households)
 |  |  |  |  |  |  | Age of the spouse of the head |  | Age of the head
 |  |  |  |  |  |  |  |  | Total | Male |  | Female
 |  |  |  |  |  |  |  |  |  | Younger than 65 years old | 65 years old or more | Younger than 60 years old | 60 years old or more
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
3100 | [NAME] |  | 1 |  |  |  | Total (incl. without a spouse) | 1 | 3385 | 2152 | 889 | 206 | 138
3100 | [NAME] |  | 1 |  |  |  | Female | 2 | 2879 | 2037 | 842 | - | -
3100 | [NAME] |  | 1 |  |  |  | Younger than 60 years old | 3 | 1899 | 1862 | 37 | - | -
3100 | [NAME] |  | 1 |  |  |  | 60 years old or more | 4 | 980 | 176 | 805 | - | -
3100 | [NAME] |  | 1 |  |  |  | Of which household only of a        married couple | 5 | 603 | 91 | 511 | - | -
3100 | [NAME] |  | 1 |  |  |  | Male | 6 | 17 | - | - | 14 | 4
3100 | [NAME] |  | 1 |  |  |  | Younger than 65 years old | 7 | 14 | - | - | 13 | 1
3100 | [NAME] |  | 1 |  |  |  | 65 years old or more | 8 | 3 | - | - | 0 | 3
3100 | [NAME] |  | 1 |  |  |  | Of which household only of a        married couple | 9 | 2 | - | - | 0 | 2
 |  |  |  |  |  |  | (regrouped)
3100 | [NAME] |  | 1 |  |  |  | Household with an aged person | 10 | 1012 | 310 | 658 | 25 | 18
3100 | [NAME] |  | 1 |  |  |  | Household without an aged person | 11 | 2373 | 1841 | 231 | 181 | 120
Spreadsheet: 4fcfd8e7-d9f9-4643-9746-8ce97a5a4deb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Rank | Form of multiple-regression model | AICc | No. parameters | ∆i | wi
1 | Proximity + Mound ID | 102.3692363636364 | 3 | 0 | 0.1541818049730715
2 | Proximity + Tree size + Mound ID + Sqrt(Tree size) + Proximty*Sqrt(Tree size) | 102.4163 | 5 | 0.04706363636364586 | 0.1505959826985721
3 | Proximity + Tree size + Mound ID + Proximity*Tree size | 102.4715 | 5 | 0.1022636363636451 | 0.1464963684923433
4 | Sqrt(Proximity) + Tree size + Mound ID + Tree size*Sqrt(Proximity) | 103.1418 | 5 | 0.7725636363636426 | 0.1047787139090066
5 | Sqrt(Proximity) + Sqrt(Tree size) + Mound ID + Sqrt(Proximity)*Sqrt(Tree size) | 103.1874 | 5 | 0.8181636363636358 | 0.1024167875105887
6 | Sqrt(Proximity) + Mound ID | 103.3614363636364 | 3 | 0.9921999999999969 | 0.0938814163689235
7 | Proximity + Sqrt(Tree size) + Mound ID | 103.6945846153846 | 4 | 1.325348251748252 | 0.07947625771871879
8 | Proximity + Tree size + Mound ID | 103.8116846153846 | 4 | 1.442448251748246 | 0.0749565289885452
… | … | … | … | … | …
24 | Constant only | 161.6510235294118 | 1 | 59.3 | 0
Spreadsheet: 78123d1278544089-excel-2007-formula-and-date-range-sequence-salestracker
Sheet: Sheet1

New Business Phased Tracker
2010
February
Target | 3
Actual | 4
Phased
Month to Date
 |  |  |  |  |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: andy_zipper__548__11_19_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 50 | 320 | 370 | 54.2 | 62.7 | 1.84 | 2001-11-19 10:56:00
 | HO F2 | 51 | 730 | 830 | 56.6 | 64.4 | 1.94 | 2001-11-19 10:56:00
 | HO G2 | 52 | 1020 | 1150 | 56.7 | 64 | 1.97 | 2001-11-19 10:56:00
 | [NAME] | 52 | 1130 | 1250 | 53.3 | 59 | 1.84 | 2001-11-19 10:56:00
 | HO J2 | 51 | 1200 | 1325 | 51.1 | 56.4 | 1.72 | 2001-11-19 10:56:00
 | HO K2 | 51 | 1230 | 1400 | 47.1 | 53.7 | 1.62 | 2001-11-19 10:56:00
 | HO M2 | 52 | 1310 | 1500 | 44.9 | 51.5 | 1.58 | 2001-11-19 10:56:00
 | HO N2 |  |  |  | 42.3 | 45.4 | 1.46 | 2001-11-16 14:52:00
 | HO Q2 |  |  |  | 36.8 | 42.5 | 1.37 | 2001-11-16 14:52:00
 | HO U2 |  |  |  | 36.9 | 40.9 | 1.37 | 2001-11-16 14:52:00
 | [NAME] |  |  |  | 38.4 | 42.2 | 1.42 | 2001-11-15 14:53:00
 | HO X2 |  |  |  | 37.9 | 40.3 | 1.38 | 2001-11-15 14:53:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 07466b93-9fee-4cc1-a2c0-5189b737a5f5
Sheet: Miscellaneous Services

[NAME]
Item # | Item | Year | Install Price | Deinstall Price | Move Price | Relocate Price
 | Mail box | 1 | 17.05
 | (key system) | 2 | 17.22
 |  | 3 | 17.4
 |  | 4 | 17.57
 |  | 5 | 17.74
 | Program change to voice mailbox | 1 | 20.46
 | First on an order | 2 | 20.66
 | (key system) | 3 | 20.87
 |  | 4 | 21.08
 |  | 5 | 21.29
 | Program change to voice mailbox | 1 | 17.05 | 17.05 | 27.28 | 23.87
 | each additional on same order | 2 | 17.22 | 17.22 | 27.55 | 24.11
 | (key system) | 3 | 17.4 | 17.4 | 27.83 | 24.35
 |  | 4 | 17.57 | 17.57 | 28.11 | 24.59
 |  | 5 | 17.74 | 17.74 | 28.39 | 24.84
 | Active automated attendent | 1 | 17.05 | 17.05 | 27.28 | 23.87
 | Per Layer | 2 | 17.22 | 17.22 | 27.55 | 24.11
 | (key system) | 3 | 17.4 | 17.4 | 27.83 | 24.35
 |  | 4 | 17.57 | 17.57 | 28.11 | 24.59
 |  | 5 | 17.74 | 17.74 | 28.39 | 24.84
Spreadsheet: 684757f4-561b-4564-991f-1c3484527d42
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FBLUG | Test | FBLUG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FBLUG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FBLUG | Result | FBLUG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 697821d1601557490-solved-help-analyzing-data-in-a-table-shared-expense-who-owes-whom-splitting-costs-tactics_updated
Sheet: Balance

Balance | [NAME] | Adam | Emma | Ellen | [NAME] | [NAME] | Emily | [NAME] | chk |  |  | Debtor | Recipient | Amount
start
1
2
3
4
5
6
7
8
9
10
Spreadsheet: andy_zipper__165__DYNEGY-ICE VOL Apr9
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-9-01 thru Apr-9-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-09-01 | 125563323 |  | Sold | Firm-LD Peak | Palo | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | El Paso Merchant Energy L.P. | 280 | USD / MWh | 25 | Hourly | 10400 | MWhs | Motley, M
Apr-09-01 | 185025969 |  | Bought | Firm-LD Peak | Ent | 2001-04-02 00:00:00 | Apr-01-02 | Apr-30-02 |  |  |  | American Electric Power Service Corp. | 43.5 | USD / MWh | 50 | Hourly | 17600 | MWhs | [NAME], R
Apr-09-01 | 806516622 |  | Bought | Firm-LD Peak | Palo | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | American Electric Power Service Corp. | 286 | USD / MWh | 25 | Hourly | 10400 | MWhs | Fischer, M
Apr-09-01 | 144894117 |  | Bought | Firm-LD Peak | Ent | Bal Week | Apr-11-01 | Apr-13-01 |  |  |  | American Electric Power Service Corp. | 68 | USD / MWh | 50 | Hourly | 2400 | MWhs | Carson , M
Apr-09-01 | 136372521 |  | Bought | Firm-LD Peak | Ent | Bal Week | Apr-11-01 | Apr-13-01 |  |  |  | American Electric Power Service Corp. | 68 | USD / MWh | 50 | Hourly | 2400 | MWhs | Carson , M
Apr-09-01 | 131194318 |  | Bought | Firm-LD Peak | Cin | 2001-06-01 00:00:00 | Jun-01-01 | Jun-30-01 |  |  |  | American Electric Power Service Corp. | 79.75 | USD / MWh | 50 | Hourly | 16800 | MWhs | [NAME], R
Apr-09-01  Deals
Spreadsheet: 843721d1695529426-looking-for-non-array-formula-to-show-dates-in-e2-e6-if-condition-in-column-a5-is-met-sample_weekdayextraction-1-
Sheet: Sheet1

2022-11-01 00:00:00 |  | Desired Output | DayList | Desired Output | DayList |  | Month Numbering | Date | Nth Day | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  | 1 | 2022-01-01 00:00:00 | 5 | 2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 2022-01-16 00:00:00 | 2022-01-23 00:00:00 | 2022-01-30 00:00:00
 |  | 2022-11-13 00:00:00 |  |  |  |  | 2 | 2022-02-01 00:00:00 | 4 | 2022-02-06 00:00:00 | 2022-02-13 00:00:00 | 2022-02-20 00:00:00 | 2022-02-27 00:00:00
DayList |  | 2022-11-20 00:00:00 |  |  |  |  | 3 | 2022-03-01 00:00:00 | 4 | 2022-03-06 00:00:00 | 2022-03-13 00:00:00 | 2022-03-20 00:00:00 | 2022-03-27 00:00:00
Saturday |  | 2022-11-27 00:00:00 |  |  |  |  | 4 | 2022-04-01 00:00:00 | 4 | 2022-04-03 00:00:00 | 2022-04-10 00:00:00 | 2022-04-17 00:00:00 | 2022-04-24 00:00:00
 |  |  |  |  |  |  | 5 | 2022-05-01 00:00:00 | 5 | 2022-05-01 00:00:00 | 2022-05-08 00:00:00 | 2022-05-15 00:00:00 | 2022-05-22 00:00:00 | 2022-05-29 00:00:00
 |  |  |  |  |  |  | 6 | 2022-06-01 00:00:00 | 4 | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2022-06-26 00:00:00
 |  |  |  |  |  |  | 7 | 2022-07-01 00:00:00 | 5 | 2022-07-03 00:00:00 | 2022-07-10 00:00:00 | 2022-07-17 00:00:00 | 2022-07-24 00:00:00 | 2022-07-31 00:00:00
 |  |  |  |  |  |  | 8 | 2022-08-01 00:00:00 | 4 | 2022-08-07 00:00:00 | 2022-08-14 00:00:00 | 2022-08-21 00:00:00 | 2022-08-28 00:00:00
 |  |  |  |  |  |  | 9 | 2022-09-01 00:00:00 | 4 | 2022-09-04 00:00:00 | 2022-09-11 00:00:00 | 2022-09-18 00:00:00 | 2022-09-25 00:00:00
 |  |  |  |  |  |  | 10 | 2022-10-01 00:00:00 | 5 | 2022-10-02 00:00:00 | 2022-10-09 00:00:00 | 2022-10-16 00:00:00 | 2022-10-23 00:00:00 | 2022-10-30 00:00:00
 |  |  |  |  |  |  | 11 | 2022-11-01 00:00:00 | 4 | 2022-11-06 00:00:00 | 2022-11-13 00:00:00 | 2022-11-20 00:00:00 | 2022-11-27 00:00:00
 |  |  |  |  |  |  | 12 | 2022-12-01 00:00:00 | 4 | 2022-12-04 00:00:00 | 2022-12-11 00:00:00 | 2022-12-18 00:00:00 | 2022-12-25 00:00:00
 |  |  |  |  |  |  | DayList | DayList #
 |  |  |  |  |  |  | Sunday | 1
 |  |  |  |  |  |  | Monday | 2
 |  |  |  |  |  |  | Tuesday | 3
 |  |  |  |  |  |  | Wednesday | 4
 |  |  |  |  |  |  | Thursday | 5
 |  |  |  |  |  |  | Friday | 6
 |  |  |  |  |  |  | Saturday | 7
Spreadsheet: jeff_dasovich__14218__problem 1
Sheet: Sheet1

Problem 1: Go-Bear Racecar Company (GBRC)
Issue:  Solving the [NAME] production problem related to the fit between shaft and bearing.
Goal:  Bearing diameter to exceed Shaft's diameter by at least .005 inches but less than .009 inches.
 | ABC Bearing Diameter | GBRC Shaft Diameter | Difference between Bearing and Shaft | Difference between current and proposed Shaft design policies
Current | 1.004333333333333 | 1
Proposed |  | 0.997
Logical test to determine if the proposed policy is at least as good as the current policy.
Current
Measures the success or failure of the Current production policy (1=success, 0=failure) |  |  | Measures if the Proposed policy is at least as good as the Current method (P >= C)
Proposed
Measures the success or failure of the Proposed production policy (1=success, 0=failure)
Key
Forecast
Assumption
Spreadsheet: 0277db26-01a9-4367-80c8-5ac80b97deea
Sheet: K-5

MENU - K-5
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No or True/False
 |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
Grains (1 oz eq per day)  (7-10 oz eq per week) |  |  |  |  |  |  |  |  |  |  |  |  | Total "Grain" Servings           (Grain servings + MMA sesrvings)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Mt/MA (NOT required) (May count as grain if at least 1 oz eq of grain already being served)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Fruits (1/2 Cup per day) (2 1/2 cups per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
[NAME] (1 Cup per day) (5 per week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Decimal Equivalents
1/8 Cup | 0.125
1/4 Cup | 0.25
3/8 Cup | 0.375
1/3 Cup | 0.333
1/2 Cup | 0.5
5/8 Cup | 0.625
2/3 Cup | 0.666
3/4 Cup | 0.75
7/8 Cup | 0.875
1 Cup | 1