tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882462d1730839965-formula-to-determine-which-records-need-sampled-formulatodeterminewhichrecordstosample
Sheet: Sheet1

 | ID | OtherData | OtherData2 | OtherData3 | UserName | [NAME] |  |  |  |  |  |  | Total Records (a)
 | 11 | Test | Test | Test | [NAME] | Audit |  | 1st record of user name |  |  |  | 0.3 | Desired Sample Percentage (b)
 | 22 | Test | Test | Test | [NAME] | Don't Audit |  | skip |  |  |  |  | c = a x b (rounded to nearest whole number)
 | 33 | Test | Test | Test | [NAME] | Don't Audit |  | skip |  |  |  |  | c / a = sample every X record (round to nearest whole number)
 | 99 | Test | Test | Test | [NAME] | Audit |  | 3rd record of same user
 | 10 | Test | Test | Test | [NAME] | Audit |  | 1st record of user name
 | 12 | Test | Test | Test | Trish | Audit |  | 1st record of user name
 | 44 | Test | Test | Test | Trish | Don't Audit |  | skip
 | 55 | Test | Test | Test | Trish | Don't Audit |  | skip
 | 56 | Test | Test | Test | Trish | Audit |  | 3rd record of same user
 | 16 | Test | Test | Test | Trish | Don't Audit |  | skip
 | 17 | Test | Test | Test | Trish | Don't Audit |  | skip
 | 18 | Test | Test | Test | Trish | Audit |  | 3rd record of same user
 | 23 | Test | Test | Test | Trish | Don't Audit |  | skip
 | 44 | Test | Test | Test | [NAME] | Audit |  | 1st record of user name
 | 80 | Test | Test | Test | [NAME] | Don't Audit |  | skip
 | 81 | Test | Test | Test | [NAME] | Don't Audit |  | skip
 | 15 | Test | Test | Test | [NAME] | Audit |  | 3rd record of same user
 | 23 | Test | Test | Test | Kenny | Audit |  | 1st record of user name
 | 77 | Test | Test | Test | Kenny | Don't Audit |  | skip
 | 62 | Test | Test | Test | Kenny | Don't Audit |  | skip
 | 59 | Test | Test | Test | Kenny | Audit |  | 3rd record of same user
 | 4 | Test | Test | Test | Kenny | Don't Audit |  | skip
 | 28 | Test | Test | Test | Kenny | Don't Audit |  | skip
Spreadsheet: 271288d1381892678-sum-adjacent-cell-to-a-reference-throughout-workbook-copy-of-xl0000040
Sheet: WE 19th Jan

Date | Order # | Company | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
20.01.14
20.01.14
20.01.14
20.01.14
20.01.14
Spreadsheet: 153718d1336028101-how-to-change-data-rows-to-columns-datarowstocolumns
Sheet: Sheet1

[NAME] | Pinellas
[NAME] | Pasco
[NAME] | Pasco
[NAME] | Dade
[NAME] | Lake
[NAME] | Orange
this part is a named range |  | this part will get all names with out their duplicates
 |  | and this is sorted
Spreadsheet: 162930d1340120800-pull-information-based-on-week-date-falls-under-staff-by-week
Sheet: Sheet1

Week | Start of Week | End of Week | Staff
Week 1 | 2012-07-09 00:00:00 | 2012-07-15 00:00:00 | 11
Week 2 | 2012-07-16 00:00:00 | 2012-07-22 00:00:00 | 15
Week 3 | 2012-07-23 00:00:00 | 2012-07-29 00:00:00 | 16
Week 4 | 2012-07-30 00:00:00 | 2012-08-05 00:00:00 | 11
Week 5 | 2012-08-06 00:00:00 | 2012-08-12 00:00:00 | 17
Week 6 | 2012-08-13 00:00:00 | 2012-08-19 00:00:00 | 11
Week 7 | 2012-08-20 00:00:00 | 2012-08-26 00:00:00 | 21
Week 8 | 2012-08-27 00:00:00 | 2012-09-02 00:00:00 | 11
Week 9 | 2012-09-03 00:00:00 | 2012-09-09 00:00:00 | 14
Week 10 | 2012-09-10 00:00:00 | 2012-09-16 00:00:00 | 11
 | 2012-07-09 00:00:00
Staff
Spreadsheet: 815513d1675006630-need-to-sum-a-row-of-8-noncontiguous-numbers-and-then-select-the-highest-6-clasificacion-ans
Sheet: ÉLITE

 | CATEGORÍA ÉLITE | 1ª Prueba |  | 1ª Prueba |  | 1ª Prueba |  | 1ª Prueba |  | 1ª Prueba |  | 1ª Prueba |  | Total | Cuatro Mejores Resultados | Cinco Mejores Resultados
 |  | 16/10 |  | 13/11 |  | 15/01 |  | 19/02 |  | 19/03 |  | 23/04
 | NOMBRE | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos
1 | ADRIAN SANCHEZ | 1 |  | 3 |  | 5 |  | 0 |  | 0 |  | 0
2 | ALFONSO GUERRERO | 2 |  | 5 |  | 9 |  | 1 |  | 3 |  | 17
3 | ANTONIO NIETO | 9 |  | 2 |  | 5 |  | 1 |  | 17 |  | 25
4 | CARLOS BELMONTE | 1 |  | 1 |  | 1 |  | 1 |  | 9 |  | 13
5 | CARLOS CABELLO | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
6 | DANIEL GASPAR | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
7 | DANIEL VANDERSTAPPEN | 1 |  | 2 |  | 3 |  | 21 |  | 9 |  | 13
8 | [NAME] | 1 |  | 2 |  | 21 |  | 5 |  | 9 |  | 13
9 | FRANCISCO DIAZ PIZARRO | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
10 | FRANCISCO JAVIER TORRES | 1 |  | 2 |  | 5 |  | 5 |  | 9 |  | 13
11 | FRANCISCO PALACIOS | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
12 | GUILLERMO FERNANDEZ | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
13 | ISIDRO UREÑA | 1 |  | 1 |  | 1 |  | 1 |  | 3 |  | 3
14 | IVELYN BOYANOV | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
15 | JACOBO GARCIA | 1 |  | 2 |  | 5 |  | 5 |  | 9 |  | 13
16 | [NAME] | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 5
17 | JESUS CRESPO | 1 |  | 2 |  | 3 |  | 5 |  | 1 |  | 13
18 | JESÚS PEÑAS | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
19 | JORGE ABDENEBBI | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
20 | [NAME] | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
21 | JUAN ANTONIO PINA | 1 |  | 2 |  | 3 |  | 3 |  | 9 |  | 13
22 | JUAN MANUEL MACHUCA | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
23 | LUIS SORIA | 1 |  | 2 |  | 3 |  | 1 |  | 9 |  | 13
24 | PEDRO CASADO | 1 |  | 2 |  | 3 |  | 3 |  | 9 |  | 13
25 | RAFAEL GUZMAN | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
26 | SALVADOR GARCIA | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
27 | SAMIR KADDUR | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
28 | SEBASTIAN SAMPSON | 1 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
29 |  | 2 |  | 3 |  | 5 |  | 9 |  | 13
30
31
32
Spreadsheet: 70804d1271493652-sorting-data-based-on-individual-fields-book1-1
Sheet: Yearlys

Education Database
Name | Unit | Clinical | Course 1 | Course 2 | Course 3 |  |  |  | Total Staff = | 10
[NAME] | Administration | No | 2009-04-03 00:00:00 | 2009-09-07 00:00:00 | 2009-05-19 00:00:00 |  |  |  | Course 1 Completed % = | 0.6 | 0
[NAME] | Housekeeping | No | 2010-04-17 00:00:00 | 2009-05-19 00:00:00 | 2009-09-07 00:00:00 |  |  |  | Course 2 Completed % = | 0.6
flinstone | Maintenance | No | 2009-05-18 00:00:00 | 2009-03-29 00:00:00 | 2010-03-15 00:00:00 |  |  |  | Course 3 Completed % = | 0.7
jane | Maternity | Yes | 2010-03-17 00:00:00 | 2009-04-29 00:00:00 | 2010-02-18 00:00:00
wilma | Maternity | Yes | 2010-03-17 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00 |  |  |  | Course 1 (Clinical)%= | 0.4
[NAME] | Maternity | Yes | 2010-02-18 00:00:00 | 2010-02-18 00:00:00 | 2010-02-18 00:00:00 |  |  |  | Course 1 (Non Clinical)%= | 0.2222222222222222
buggery | Medical | Yes | 2010-02-18 00:00:00 | 2009-05-19 00:00:00 | 2010-04-17 00:00:00
fellow | Executive | No
jonny bigs | Allied Health | Yes
[NAME] | ICU | Yes
Spreadsheet: 869482d1716040596-empty-row-after-every-group-of-data-book1-gk-v2
Sheet: Sheet1

 |  | User Enter three columns
 |  | Region | Employee | Product |  |  |  | Employee | Pro-1 | Pro-2 | Pro-3
 |  | REG-1 | Emp-1 | Pro-1 |  |  | REG-1 | Emp-1 | x
 |  | REG-1 | Emp-2 | Pro-2 |  |  | REG-1 | Emp-2 |  | x
 |  | REG-1 | Emp-3 | Pro-1 |  |  | REG-1 | Emp-3 | x
 |  | REG-1 | Emp-4 | Pro-2 |  |  | REG-1 | Emp-4 |  | x
 |  | REG-1 | Emp-5 | Pro-1 |  |  | REG-1 | Emp-5 | x
 |  | REG-1 | Emp-6 | Pro-2 |  |  | REG-1 | Emp-6 |  | x
 |  | [NAME] | Emp-1 | Pro-3 |  |  | REG-1 Total |  | 0.5 | 0.5 | 0
 |  | [NAME] | Emp-2 | Pro-2 |  |  | [NAME] | Emp-1 |  |  | x
 |  | [NAME] | Emp-3 | Pro-3 |  |  | [NAME] | Emp-2 |  | x
 |  | [NAME] | Emp-4 | Pro-2 |  |  | [NAME] | Emp-3 |  |  | x
 |  | REG-3 | Emp-1 | Pro-3 |  |  | [NAME] | Emp-4 |  | x
 |  | REG-3 | Emp-2 | Pro-2 |  |  | REG-3 | Emp-1 |  |  | x
 |  | REG-3 | Emp-3 | Pro-3 |  |  | REG-2 Total | #N/A | 0 | 0.5 | 0.5
 |  | REG-3 | Emp-4 | Pro-2 |  |  | REG-3 | Emp-2 |  | x
 |  | REG-4 | Emp-1 | Pro-3 |  |  | REG-3 | Emp-3 |  |  | x
 |  | REG-4 | Emp-2 | Pro-1 |  |  | REG-3 | Emp-4 |  | x
 |  | REG-4 | Emp-3 | Pro-3 |  |  | REG-4 | Emp-1 |  |  | x
 |  | REG-4 | Emp-4 | Pro-2 |  |  | REG-3 Total | #N/A | 0 | 0.5 | 0.5
 |  | REG-4 | Emp-5 | Pro-1 |  |  | REG-4 | Emp-2 | x
 |  | REG-4 | Emp-6 | Pro-3 |  |  | REG-4 | Emp-3 |  |  | x
 |  |  |  |  |  |  | REG-4 | Emp-4 |  | x
 |  |  |  |  |  |  | REG-4 | Emp-5 | x
 |  |  |  |  |  |  | REG-4 | Emp-6 |  |  | x
 |  |  |  |  |  |  | REG-4 Total | #N/A | 0.3333333333333333 | 0.1666666666666667 | 0.5
 |  |  |  |  |  |  | Grand Total |  | 0.25 | 0.4 | 0.35
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 5 Reading

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 5
Grade 5 Reading [NAME]
Raw Score | Scale Score**** | Level
0 | 84 | D
1 | 103 | D
2 | 116 | D
3 | 124 | D
4 | 131 | D
5 | 138 | D
6 | 144 | D
7 | 151 | D
8 | 159 | D
9 | 166 | D
10 | 172 | D
11 | 177 | D
12 | 181 | D
13 | 184 | D
14 | 187 | D
15 | 190 | P
16 | 193 | P
17 | 195 | P
18 | 197 | P
19 | 200 | M
20 | 203 | M
21 | 205 | M
22 | 209 | M
23 | 212 | M
24 | 217 | M
25 | 223 | M
26 | 232 | E
27 | 249 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2012 and 2008/2009/2010/2011 Science MTAS metrics are not comparable
****2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 74068d1274687876-charting-every-second-data-point-copy-of-chart
Sheet: Sheet1

 | Yield1 | Yield2 | Rent1 | Rent2 |  |  | Yield1 | Yield2 | Rent1 | Rent2
2005-03-01 00:00:00 | 0.085 | 0.075 | 115 | 125 |  | 2005-03-01 00:00:00 | 0.085 | 0.075 | 115 | 125
2005-06-01 00:00:00 | 0.085 | 0.075 | 115 | 125 |  | 2005-09-01 00:00:00 | 0.0825 | 0.075 | 115 | 125 | chart off this table
2005-09-01 00:00:00 | 0.0825 | 0.075 | 115 | 125 |  | 2006-03-01 00:00:00 | 0.08 | 0.0775 | 115 | 125
2005-12-01 00:00:00 | 0.08375 | 0.075 | 115 | 125 |  | 2006-09-01 00:00:00 | 0.0775 | 0.075 | 120 | 130
2006-03-01 00:00:00 | 0.08 | 0.0775 | 115 | 125 |  | 2007-03-01 00:00:00 | 0.075 | 0.08 | 120 | 130
2006-06-01 00:00:00 | 0.08 | 0.0775 | 120 | 130 |  | 2007-09-01 00:00:00 | 0.07 | 0.07 | 120 | 130
2006-09-01 00:00:00 | 0.0775 | 0.075 | 120 | 130 |  | 2008-03-01 00:00:00 | 0.07 | 0.075 | 120 | 130
2006-12-01 00:00:00 | 0.0775 | 0.0725 | 120 | 130 |  | 2008-09-01 00:00:00 | 0.0788 | 0.0825 | 130 | 140
2007-03-01 00:00:00 | 0.075 | 0.08 | 120 | 130 |  | 2009-03-01 00:00:00 | 0.0875 | 0.0875 | 125 | 135
2007-06-01 00:00:00 | 0.0725 | 0.08 | 120 | 130 |  | 2009-09-01 00:00:00 | 0.09 | 0.09 | 125 | 135
2007-09-01 00:00:00 | 0.07 | 0.07 | 120 | 130 |  | Mar-10 | 0.0888 | 0.09 | 125 | 135
2007-12-01 00:00:00 | 0.065 | 0.0725 | 120 | 130 |  | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
2008-03-01 00:00:00 | 0.07 | 0.075 | 120 | 130 |  | 1900-01-01 00:00:00 | 0 | 0 | 0 | 0
2008-06-01 00:00:00 | 0.0788 | 0.08 | 130 | 140
2008-09-01 00:00:00 | 0.0788 | 0.0825 | 130 | 140
2008-12-01 00:00:00 | 0.0838 | 0.085 | 130 | 140
2009-03-01 00:00:00 | 0.0875 | 0.0875 | 125 | 135
2009-06-01 00:00:00 | 0.09 | 0.0875 | 125 | 135
2009-09-01 00:00:00 | 0.09 | 0.09 | 125 | 135
2009-12-01 00:00:00 | 0.0888 | 0.09 | 125 | 135
Mar-10 | 0.0888 | 0.09 | 125 | 135
Spreadsheet: 155817d1337066583-opinions-on-how-to-model-this-data-database-examples
Sheet: table

Average ranking by women with incomes greater than 50000
Gender | Income | Question 1 | Question 2 | Question 3 | Question 4 | Question 5 | Question 6 | Question 7 | Question 8 | Question 9 | Question 10 | count
female | >50000
Distribution of responses to question 1
Question 1 | Number
1
2
3
4
5
Average Response to Question 1 by Gender
Gender | Gender
male | female | Female
 |  | Male
 |  | All
Total Income by gender
Gender | Gender
male | female | Female
 |  | Male
 |  | All
Spreadsheet: 886731d1736845627-filter-function-ignore-blank-rows-filter-ignore-blank-rows
Sheet: Sheet1

 | A | B | C | D |  |  | A | B | C | D
 | HANNAH | 200 | RED | 6450 |  |  |  | 200 | RED | 6450
 | EDWARD | 400 | RED | 8420 |  |  | EDWARD | 400 | RED | 8420
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | MIRANDA | 300 | BLUE | 9050 |  |  | MIRANDA | 300 | BLUE | 9050
 | [NAME] | 250 | RED | 8200 |  |  | [NAME] | 250 | RED | 8200
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | OSCAR | 100 | RED | 3350 |  |  | OSCAR | 100 | RED | 3350
 | ANNIE | 250 | RED | 8100 |  |  | ANNIE | 250 | RED | 8100
 | ROMEO | 100 | BLUE | 3340 |  |  | ROMEO | 100 | BLUE | 3340
Spreadsheet: 33961d1230929158-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-revised
Sheet: 410 b Ratio Per tst

RATIO PERCENTAGE TEST
Treasury Regulation 1.410(b)-2(b)(2)
TOTAL EMPLOYEES: | 4
STATUTORY EXLUSIONS:
MINIMUM AGE & SERVICE | 0
COLLECTIVELY BARGAINED | 0
NONRESIDENT ALIENS | 0
TOTAL EXCLUDED | 0
TOTAL # OF EMPLOYEES NOT EXCLUDED(INCLUDES TERM>500 HRS) | 4
COVERAGE TEST RESULTS
(1)   NONHIGHLY COMPENSATED EES BENEFITING | 0 |  | NHCE B | 0
(2)   divided by # OF ELIGIBLE NON-HIGHLY COMPENSATED EMPLOYEES | 0 |  | NHCE | 0
(3)   PERCENTAGE OF NON-HIGHLY COMPENSATED EES BENEFITING | #N/A
(4)   HIGHLY COMPENSATED EES BENEFITING | 0 |  | HCE B | 0
(5)   divided by # of ELIGIBLE HIGHLY COMPENSATED EES | 0 |  | HCE | 0
(6)   PERCENTAGE OF HIGHLY COMPENSATED EES BENEFITING | #N/A
RATIO ON NON-HIGHLY COMPENSATED EES BENEFITING TO HIGHLY COMPENSATED EES BENEFITING | #N/A
Spreadsheet: 167310d1341948795-trying-to-create-a-summary-page-testbooka
Sheet: Area 1

Area 1
Effect | Status | Work order | Notes
Effect 1A | In Service
Effect 2A | In Service
Effect 3A | In Service
Effect 4A | In Service
Effect 5A | In Service
Effect 6A | OOS |  | [NAME]
Effect 7A | In Service
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 14b

Product1 | HY6 | IG | Other | TOTAL
Index Tranche | 3 | 4 | 0 | 7
Index | 1999 | 1912 | 2612 | 6523
Other | 0 | 0 | 32 | 32
TOTAL | 2002 | 1916 | 2644 | 6562
Spreadsheet: ca271a4b-2361-4d53-9cc7-538c2bc6bdbc
Sheet: Power by Week

Team | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Average | Highest | Lowest | Biggest Gap | Team Change Code | Change from Last Week | Change from Week 1
Houston Texans | 6 | 4 | 2 | 1 | 1 | 1 | 2
San Francisco 49ers | 5 | 2 | 1 | 4 | 4 | 3 | 5
Baltimore Ravens | 4 | 3 | 6 | 3 | 3 | 4 | 4
Atlanta Falcons | 12 | 6 | 3 | 2 | 2 | 2 | 1
New England Patriots | 2 | 1 | 5 | 8 | 6 | 5 | 7
New York Giants | 1 | 7 | 8 | 6 | 10 | 7 | 3
Green Bay Packers | 3 | 5 | 4 | 7 | 8 | 12 | 8
Chicago Bears | 11 | 8 | 12 | 11 | 9 | 6 | 6
Philadelphia Eagles | 7 | 12 | 7 | 9 | 7 | 11 | 13
Arizona Cardinals | 19 | 20 | 14 | 5 | 5 | 9 | 11
Pittsburgh Steelers | 8 | 11 | 9 | 16 | 16 | 10 | 14
Denver Broncos | 10 | 9 | 10 | 14 | 13 | 17 | 12
San Diego Chargers | 15 | 14 | 11 | 13 | 11 | 14 | 16
Dallas Cowboys | 14 | 10 | 15 | 12 | 15 | 13 | 18
Detroit Lions | 9 | 13 | 13 | 18 | 20 | 20 | 19
Cincinnati Bengals | 16 | 18 | 16 | 15 | 12 | 15 | 21
[NAME] | 22 | 26 | 17 | 10 | 17 | 16 | 9
Washington Redskins | 25 | 15 | 20 | 22 | 18 | 21 | 15
Minnesota Vikings | 31 | 28 | 29 | 21 | 14 | 8 | 10
New York Jets | 20 | 17 | 18 | 17 | 23 | 25 | 23
Tampa Bay Bucs | 24 | 21 | 21 | 20 | 22 | 23 | 22
New Orleans Saints | 13 | 16 | 24 | 28 | 28 | 24 | 24
Buffalo Bills | 23 | 24 | 22 | 19 | 21 | 27 | 25
St. Louis Rams | 29 | 27 | 23 | 25 | 19 | 18 | 20
Carolina Panthers | 21 | 23 | 19 | 23 | 24 | 26 | 28
Tennessee Titans | 18 | 22 | 26 | 24 | 25 | 28 | 27
[NAME] | 27 | 30 | 25 | 29 | 26 | 19 | 17
Kansas City Chiefs | 17 | 19 | 28 | 26 | 27 | 30 | 32
Oakland Raiders | 26 | 25 | 30 | 27 | 29 | 29 | 29
Indianapolis Colts | 32 | 32 | 27 | 31 | 31 | 22 | 26
[NAME] | 28 | 29 | 31 | 30 | 30 | 31 | 31
[NAME] | 30 | 31 | 32 | 32 | 32 | 32 | 30
Spreadsheet: 1d57df18-c6f7-44e0-b85f-032f68e7f557
Sheet: Sheet1

Note: P=Permanent | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Library:  Office of Director
Record Series | In Office | Archives | Total Retention Period | Notes
Annual Reports (required until ca. 2003) | Send to Archives | P | P
Monthly reports submitted since Annual Reports terminated | 2 years | P | P
Annual/biennial statistical reports submitted to ACRL, ALS | 1 year | P | P
Successful grant proposals | 3 years | P | P
Oral/written presentations for Planning/Budget | 2 years | P | P
Materials Budget showing allocations for various schools/depts. | 2 years | P | P
Collection Analysis comparing RU with IL peer schools, 2003 | Send to Archives | P | P
Job descriptions | Current |  | Current
Automation licenses | Current |  | Current
Faculty/Library Committee minutes | 2 years | P | P
Performance reviews | 3 years |  | 3 years
Spreadsheet: 143243d1330322974-catergoize-text-in-excel-sheet-color-text-match
Sheet: Sheet1

[NAME] |  |  |  |  |  | Master Categories
Red2 |  |  |  |  |  | Blue* | 1
Blue8 |  |  |  |  |  | Green* | 2
[NAME] |  |  |  |  |  | Red* | 3
Green6
Spreadsheet: 830405d1684900560-excel-fomular_index-match-and-min-max-fomular_th_in
Sheet: Sheet7

 |  |  |  |  |  |  |  |  |  | RESULT WITH FOMULAR HERE
Month | Printer Type | Brand | Model No. | AA COM | Source | BBB | Source | CCC | Source | Best Price Offering | [NAME] | Minimum Price
 |  |  |  | 4690 |  | 4390 |  | 3750 |  |  |  |  | if have price > 0 in 3 column this fomular will work
 |  |  |  | 5690 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for 2 value, this formular will work
 |  |  |  | 0 |  | 7890 |  | 7790 |  |  |  |  | if have min = 0 only 1 value.it is false. i need to show CCC (7790 best price)
 |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for all column. This fomular will work
 |  |  |  | 5955 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  | 0 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column and found 0.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  |  |  |  |  |  | if use Min function will be count 0 .please suggest the best one fomular to cover all result?
Spreadsheet: 216869d1361911250-complex-vlook-and-or-index-formula-question-expert-advice-needed-excel-forum-sample-1
Sheet: Data

JobNo | Name | Emp No. | Category | RC | Trans Date | Hours | Cost | Revenue
 | THOMAS-CHUN, MARGARET J | 23043 | UNBILLABLE/ FIXED PRICE LABOR |  | 2012-12-31 00:00:00 | 8 | 811.9 | 811.9
 | THOMAS-CHUN, MARGARET J | 23043 | UNBILLABLE/ FIXED PRICE LABOR |  | 2013-01-15 00:00:00 | 10 | 933.59 | 933.59
 | THOMAS-CHUN, MARGARET J | 23043 | [NAME] Analyst (Master) CY4 |  | 2013-01-31 00:00:00 | 3 | 298.53 | 298.53
 | THOMAS-CHUN, MARGARET J | 23043 | [NAME] Analyst (Master) CY4 |  | 2013-01-31 00:00:00 | 1 | 99.52 | 99.52
 | THOMAS-CHUN, MARGARET J | 23043 | [NAME] Analyst (Master) CY4 |  | 2013-01-31 00:00:00 | 15 | 1492.67 | 1851.3
 | THOMAS-CHUN, MARGARET J | 23043 | [NAME] Analyst (Master) CY4 |  | 2013-01-31 00:00:00 | 64 | 6368.64 | 7898.88
 | THOMAS-CHUN, MARGARET J | 23043 | [NAME] Analyst (Master) CY4 |  | 2013-02-15 00:00:00 | 56.75 | 5656.66 | 7004.09
 | THOMAS-CHUN, MARGARET J | 23043 | [NAME] Analyst (Master) CY4 |  | 2013-02-15 00:00:00 | 8 | 797.42 | 987.36
 | THOMAS-CHUN, MARGARET J | 23043 | [NAME] Analyst (Master) CY4 |  | 2013-02-15 00:00:00 | 20.25 | 2018.45 | 2499.26
Spreadsheet: 744108d1628959368-get-info-depending-on-highlighted-cell-example-2
Sheet: Sheet1

12345 | abc | 100 |  |  |  |  |  |  |  |  | 12345 | abc
5678 | okl | 10 |  |  |  |  |  |  |  |  | 5678 | okl
345 | [NAME] | 5 |  |  |  |  |  |  |  |  | 345 | [NAME]
987 | jo | 2 |  |  |  |  |  |  |  |  | 987 | jo
 |  | Result that I am looking for
12345 | abc | 100 |  |  |  |  |  |  |  |  | 12345 | abc | 100
5678 | okl | 10 |  |  |  |  |  |  |  |  | 5678 | okl
345 | [NAME] | 5 |  |  |  |  |  |  |  |  | 345 | [NAME]
987 | jo | 2 |  |  |  |  |  |  |  |  | 987 | jo | 2
Spreadsheet: 250477d1373950685-delete-all-rows-in-workbook-with-same-title-ffcs-sample
Sheet: raw1

Pos | Player | PassYards | PassTDs | RushYds | RushTDs | Fumbles | Tot Pts
QB 1 | [NAME] | 5000 | 38 |  |  | 2 | 350
QB 2 | [NAME] | 4800 | 36 |  |  | 3 | 335
QB 3 | [NAME] | 3600 | 29 |  |  | 4 | 325
QB 4 | [NAME] | 4000 | 35 |  |  | 3 | 320
QB 5 | [NAME] | 4500 | 39 |  |  | 1 | 315
RB 1 | [NAME] |  |  | 1600 | 13 | 2 | 170
RB 2 | [NAME] |  |  | 1480 | 12 | 1 | 165
RB 3 | [NAME] |  |  | 1450 | 10 | 0 | 162
RB 4 | [NAME] |  |  | 1350 | 9 | 2 | 155
RB 5 | [NAME] |  |  | 1300 | 10 | 3 | 150
Spreadsheet: 45428d1244145531-importing-values-from-sheets-to-create-unique-list-flagsend
Sheet: Europe

Europe & The Middle East
36 | Country | Sent? | Date Sent | Date Received | Location | Contact | Notes
0 | Albania
0 | Austia
0 | Bangladesh
37 | Belgium | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
38 | France | Yes |  |  | Cornerstone
39 | Germany | Yes |  |  | Cornerstone
40 | Great Britain | Yes |  |  | Cornerstone
41 | Hungary | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
42 | Israel | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4090
43 | Italy | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4091
44 | Kazakistan | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4092
45 | Lebanon | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4093
0 | Malta
0 | [NAME]
0 | Netherlands
0 | Norway
46 | Romania | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
0 | Russia
0 | Spain
47 | Turkey | Yes | June 1, 2009 |  | Georgia | [NAME] (478)-278-4089
0 | Ukraine
0 | Uzbekistan
 | Total Countries: | 22
Spreadsheet: 767574d1644523489-distribute-a-number-from-a-cell-across-others-based-on-the-percentage-of-another-cell-distribute-based-on-individual-percentage-of-available
Sheet: Team Assignments

FRUIT | TOTAL AVAILABLE | TOTAL TO PICK | TEAM 1 | TEAM 2 | TEAM 3 | TEAM 4 | TOTAL ASSIGNED
ORANGES |  | 50
APPLES |  | 11
 |  |  | Calculate how many to "pick" based on their individual percentage of B.
 |  |  | The sum of D:G must be exactly the value in C.  Must be whole numbers.
Spreadsheet: 733417d1621564777-counting-number-of-data-sequences-in-list-of-reults-simple-list-of-results
Sheet: Sheet1

B
P
B
T
B
P
B
T
B
B
B
B
P
P
B
P
B
P
P
P
B
B
P
B
B
T
B
B
P
B
Spreadsheet: 706155d1606501278-dip-in-bell-curve-data-distribution-generator-r1-1-2-
Sheet: input data

Data Distribution Generator |  |  |  | Start of date range --> |  | Start Date: | 2022-10-15 00:00:00
 |  |  |  | Interval date range --> |  | Interval Range: | Monthly |  |  |  |  |  | [NAME] (day) |  | --> fill this cell if interval range is "Custom"
Task | Start | Finish | Duration | Total Quantity | Curve Type
Test-1 | 2020-12-01 00:00:00 | 2022-10-15 00:00:00 |  | 150000 | Bell Shaped
 |  |  |  | : Cells with formula/data, make sure every cell is containing default formula
TUTORIAL >
No macro, only formula with named ranges |  |  |  | Not Producing Perfect Bell--> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <----This is the monthly total instead of the cumulative total
Create Data Distribution
1. Input Task
2. Input Start & Finish Date
3. Input Total Quantity
4. Choose Curve Type
5. Set timescale "Start Date:"
6. Set timescale interval "Interval Range:"
Widen Timescale Range
1. Set start date & interval range
2. Select 1 full column (for example, "H:H")
3. Copy
4. Paste at next to entire last column date range
Narrow Timescale Range
1. Select entire last column in date range (for example, "AC:AE")
2. Delete selected columns
Add New Curve Type
1. Input new curve type below existing curve type in sheet "curve"
2. Input distribution value from 0% to 100% duration, sum of these numbers must be 100%
3. You can also delete manually unnecessary curve type & its value
Add more tasks
1. Copy entire row of last task (for example, "20:20")
2. Right click, and select "Insert Copied Cells"
3. To insert multiple tasks at once, select multiple entire rows (for example, "20:22") and do step 2 above
Customize the format as you like
See sample data here