tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 220786d1363265872-data-validation-three-way-book-one-costt
Sheet: Sheet1

 | 1 | 3 | 12 | 18 | 24
 | data
 | 2.5 | 11 |  | 12.5 | 13
 | 5 | 14 |  | 15 | 17
 | 7.5 | 16 |  |  | 21
 | 12.5 | 19 |  |  | 25 |  |  |  |  | Simo
 | 15 |  |  |  | 29 |  |  |  |  | Voice
 | simo |  | 2.5 |  | 33 |  |  |  |  | RedHot
 | 10.5 |  | 5 |  | 37 |  |  |  |  | Data
 | 13 |  | 7.5 |  | 42
 | 15.5 |  | 12.5 |  | 47
 | 18 |  | 15 |  | 49
 |  |  | 20
 |  |  | 27
 |  |  | 32 |  |  | redhot 12 | voice 12 | voice 24 | simo 1 | simo 12 | data 1 | data 24 | data 3
 |  |  |  |  |  | 47 | 35 | 13 | 10.5 | 10.5 | 2.5 | 15 | 22.8
 |  |  |  |  |  | 52 | 39 | 17 | 13 | 15.5 | 5 | 20
 |  |  |  |  |  | 59 | 43 | 21 | 15.5 | 20.5 | 7.5 | 27
 |  |  |  |  |  | 64 | 47 | 25 | 18 | 26 | 12.5 | 32
 |  |  |  |  |  | 69 | 52 | 29 |  | 32.5 | 15
 |  |  |  |  |  |  |  | 33 |  | 38
 |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  | 47
 |  |  | Simo |  | 13
 |  |  | 10.5 |  | 17
 |  |  | 15.5 |  | 21
 |  |  | 20.5 |  | 25
 |  |  | 26 |  | 29
 |  |  | One Net |  | 33
 |  |  | 32.5 |  | 37
 |  |  | 38 |  | 42
 |  |  | Red hot |  | 47
 |  |  | 47 |  | 49
 |  |  | 52
 |  |  | 59
 |  |  | 64
 |  |  | 69
 |  |  | Voice
 |  |  | 35
 |  |  | 39
 |  |  | 43
 |  |  | 47
 |  |  | 52
Spreadsheet: 455807d1460502839-matching-values-with-two-ranges-of-data-test
Sheet: Original Data

EE # | Last Name | First Name | E-mail | Medical | Eff Start Date | Eff End Date | Dept | Hire Date | Term Date | Status Code | Position Status | Prior to May 1st | After May 1st
2004 | [NAME] | Thelma |  |  |  |  | First Care-LaMiradaClinic | 08/10/2015 |  | Active | Full Time |  | 99.23
1923 | [NAME] | Alexis Christine |  |  |  |  | First Care-LaMiradaClinic | 02/16/2015 |  | Active | Full Time |  | 93.5
1849 | Del Mundo | [NAME] |  | D40 | 03/09/2015 |  | First Care-LaMiradaClinic | 09/02/2014 |  | Active | Full Time | 91.71 | 93.87
875 | Encinas | [NAME] |  | D40 | 05/10/2010 |  | First Care-LaMiradaClinic | 05/13/2004 |  | Active | Full Time | 102.63 | 106.12
2046 | [NAME] | Rico |  |  |  |  | First Care-LaMiradaClinic | 10/29/2015 |  | Active | Full Time |  | 97.99
1993 | Fayez | Maged |  |  |  |  | First Care-LaMiradaClinic | 07/14/2015 |  | Active | Full Time |  | 117.99
1914 | Galvan | Elena |  |  |  |  | First Care-LaMiradaClinic | 01/22/2015 |  | Active | Full Time | 86.45 | 93.5
2054 | [NAME] | Jesica |  |  |  |  | First Care-LaMiradaClinic | 11/16/2015 |  | Active | Full Time |  | 59.37
959 | Lopez | Armando |  | D40 | 05/03/2012 | 06/11/2012 | First Care-Ontario | 06/13/2005 |  | Active | Full Time | 220.66 | 199.62
1054 | Lopez | [NAME] |  |  |  |  | First Care-Garden Grove | 08/09/2006 |  | Active | Full Time | 96.12 | 104.62
1836 | Lopez | Charlene |  |  |  |  | First Care-Anaheim | 08/11/2014 |  | Active | Full Time | 86.79 | 97.99
1189 | Lopez | Karina |  | D40 | 05/10/2010 | 06/11/2012 | SCOSMC-LaMiradaClinic | 01/23/2008 | [NAME] | Voluntary Resignation | Full Time | 86.45 | 93.5
1984 | Lopez | Lauren |  |  |  |  | First Care- Long Beach | 06/16/2015 | 08/11/2015 | Voluntary Resignation | Full Time |  | 93.5
1947 | Lopez | Lilian |  |  |  |  | First Care- Long Beach | 04/13/2015 | 07/09/2015 | Voluntary Resignation | Full Time |  | 97.99
1256 | Lopez | [NAME] |  | D40 | 05/01/2014 | 07/01/2015 | Billing | 10/08/2008 | 07/30/2015 | Voluntary Resignation | Part Time | 88.53 | 97.99
2053 | Lopez | Samantha |  |  |  |  | First Care-Corona Clinic | 11/16/2015 |  | Active | Full Time |  | 101.63
1787 | Lopez | [NAME] |  |  |  |  | Office | 04/28/2014 |  | Active | Full Time | 86.45 | 93.5
1553 | Lopez | Yecenia |  |  |  |  | First Care-Colton | 03/30/2012 |  | Active | Full Time | 99.69 | 106.12
1475 | Lopez | Yvette |  | D40 | [NAME] |  | Colton-Referrals | 05/23/2011 |  | Active | Full Time | 91.71 | 99.23
1578 | [NAME] | Veronica |  |  |  |  | Colton-Referrals | 06/18/2012 |  | Active | Full Time | 105.64 | 115.75
861 | [NAME] | Yvette |  | D40 | [NAME] |  | SCOSMC-LaMiradaClinic | 03/08/2004 |  | Active | Full Time | 117.21 | 123.88
Spreadsheet: 497394aa-327e-467c-a079-bc0b6ac50295
Sheet: Sheet1

 | First Name | Last Name | City | Country | club
1 | Glenda | [NAME] | Edenbridge | United Kingdom
2 | [NAME] | [NAME] | Tecumseh | Canada
3 | [NAME] | Rochman | Toronto | Canada
4 | Marie-Hélène | ROUCH | DUNES | France
5 | [NAME] | Venot | mettray | France
 | 5 | 5 | 5 | 5
Spreadsheet: 356284d1415045798-move-an-entire-row-to-a-new-sheet-based-on-the-value-of-a-cell-job-requisition-workbook
Sheet: WESTMONT

Westmont Healthcare Community |  |  |  | Administrator: [NAME]: |  | EEO: [EMAIL] Phone: [PHONE]
Requisition # | Job Title | Department | [NAME] | Position Open | Offer Accepted | Shift | Reason for Opening | Days Open | Satus
WESTM14003 | CNA | Nursing | 10.25 | 2014-10-30 00:00:00 |  | FT DAY | New Position
WESTM14002 | RN | Nursing | 22 | 2014-10-30 00:00:00 |  | FT DAY | New Position
WESTM14001 | LPN | Nursing | 17.25 | 2014-10-30 00:00:00 |  | FT EVENING | New Position
Spreadsheet: 759609d1639616710-sum-if-array-produces-zero-arrayproblem
Sheet: Worksheet 2

Date |  | Name |  |  | G | Min | Poss
2021-10-20 00:00:00 |  | P1 |  |  | 1 | 15.54
2021-10-20 00:00:00 |  | P2 |  |  | 1 | 23.47
2021-10-20 00:00:00 |  | P3 |  |  | 1 | 19.01
2021-10-20 00:00:00 |  | P4 |  |  | 1 | 41.26
2021-10-20 00:00:00 |  | P5 |  |  | 1 | 13.25
2021-10-20 00:00:00 |  | P6 |  |  | 1 | 2.15
2021-10-20 00:00:00 |  | P7 |  |  | 1 | 19.45
2021-10-20 00:00:00 |  | P8 |  |  | 1 | 34.12
2021-10-20 00:00:00 |  | P9 |  |  | 1 | 38.56
2021-10-20 00:00:00 |  | P10 |  |  | 1 | 33.44
2021-10-20 00:00:00 |  | P11 |  |  | 1 | 12.77
2021-10-20 00:00:00 |  | P12 |  |  | 1 | 4.95
2021-10-20 00:00:00 |  | P13 |  |  | 1 | 28.04
2021-10-20 00:00:00 |  | P14 |  |  | 1 | 33.33
2021-10-20 00:00:00 |  | P15 |  |  | 1 | 27.45
2021-10-20 00:00:00 |  | P16 |  |  | 1 | 12.88
2021-10-20 00:00:00 |  | P17 |  |  | 1 | 18.4
2021-10-22 00:00:00 |  | P18 |  |  | 1 | 3.6
2021-10-22 00:00:00 |  | P19 |  |  | 1 | 5.88
2021-10-22 00:00:00 |  | P20 |  |  | 1 | 6.9
Spreadsheet: 141063d1329064040-vlookup-with-two-tables-ciao-2-
Sheet: Sheet1

range 1 |  |  | range 2
shoes | 80 |  | jeans | 70
skirt | 30 |  | t-shirt | 10
socks | 5 |  | sneakers | 100
item to lookup: | socks
number: | 2
price: | 10
Spreadsheet: 357434d1415394477-reversing-the-order-of-a-list-sample-reverse
Sheet: Sheet1

dog |  | piano |  | ford
cat |  | flute |  | toyota
horse |  |  |  | nissan
[NAME] |  |  |  | chrystler
 |  |  |  | lamborgini
 |  |  |  | porche
[NAME] |  | flute |  | porche
horse |  | piano |  | lamborgini
cat |  |  |  | christler
dog |  |  |  | nissan
 |  |  |  | toyota
 |  |  |  | ford
Spreadsheet: 33707d1230329956-match-multiple-values-in-two-columns-contacts
Sheet: LISTII

Criteria |  | Criteria
0 |  | 21
BADNUM | PHONE | CORP | ADDRESS | ST | ZIP
4143891680 | [PHONE] | TRINITY GROUP TECHNOLOGIES INC | 1950 DEYERLE AVE          H | VA | 22801
3077337545 | [PHONE] | BLUE WING EXPRESS INC | 911 LIVE OAK DR | VA | 23320
7247720242 | [PHONE] | PURSE SUIT OF HAPPINESS | 1908 BOULEVARD | VA | 23834
7246566181 | [PHONE] | Commitment Marketing LLC | PO Box 085435 | WI | 53408
7027300046 | [PHONE] | Milwaukee Hand Ctr | 2801 W Kinnickinnic River Pkwy | WI | 53215
2152304143 | [PHONE] | Publishing Perfection | PO Box 307 | WI | 53052
5706221190 | [PHONE] | Sleek Contours LLC | 1515 W Wisconsin Ave | WI | 54914
6093435211 | [PHONE] | Winvesco Inc | PO Box 1108 | WY | 83001
7177648160 | [PHONE] | Mobotec | 217 Executive Dr | PA | 16066
7026337763 | [PHONE] | Caring Foundation | 1000 S Mercer St | PA | 16101
6107777117 | [PHONE] | Concepts For Ind Inc | 200 6th St | PA | 18644
6144430227 | [PHONE] | Credit Report Advocates | 1276 Providence Rd | PA | 19018
6144287525 | [PHONE] | NCR Co | 317 [NAME] | PA | 15904
6148916912 | [PHONE] | [NAME] | Post Rd | PA | 19061
2167515712 | [PHONE] | Homewood Head Start | 10 Albertise Way | PA | 15208
4198180004 | [PHONE] | Allied Specialty Tube Inc | 22 Village Center Dr | PA | 19607
[PHONE] | [PHONE] | Henkels & Mc Coy Inc | 1260 New Rodgers Rd | PA | 19007
[PHONE] | [PHONE] | [NAME] | 67 Buck Rd | PA | 18966
[PHONE] | [PHONE] | Maximus | 102 W Jefferson St | TN | 38478
 | [PHONE] | ABM Walk In Care | 2280 Frayser Blvd | TN | 38127
 | [PHONE] | [NAME] | 24235 [NAME] | TN | 37892
 | [PHONE] | [NAME] | 499 S Hollywood St | TN | 38111
 | [PHONE] | [NAME] | PO Box 11287 | TN | 37939
 | [PHONE] | God's Mountain Retreat | 458 [NAME] | TN | 37385
 | [PHONE] | Foundations - Early Intrvntn | PO Box 155 | TN | 37061
 | [PHONE] | E F Expressions Inc | 134 S 700 W | UT | 84104
 | [PHONE] | E Taewon Trading | 12101 Factory Outlet Dr | UT | 84020
 | [PHONE] | Ela's Market | 1151 S Redwood Rd | UT | 84104
 | [PHONE] | F T Casuals | 10450 S State St # 1334 | UT | 84070
 | [PHONE] | Richmond American Homes | 11282 High Crest Ln | UT | 84095
 | [PHONE] | Intrust Group | 2825 E Cottonwood Pkwy # 500 | UT | 84121
 | [PHONE] | Labor Lenders | 3555 S 3200 W | UT | 84119
 | [PHONE] | I ONE MOBILE INC | 322 E BROAD ST | VA | 23219
 | [PHONE] | RIVER DISTRICT ALLIANCE | 23 S 13TH ST | VA | 23219
 | [PHONE] | LAST FLIGHT OUT | 2900 ATLANTIC AVE | VA | 23451
 | [PHONE] | CENTER-INNOVATIVE TECHNOLOGY | 212 S JEFFERSON ST | VA | 24011
 | [PHONE] | CANCER OUTREACH ASSOC | 98 15TH ST NW | VA | 24273
 | [PHONE] | PHMA | 154 FORT EVANS RD NE | VA | 20176
 | [PHONE] | WILLARD GROUP | 1497 CHAIN BRIDGE RD | VA | 22101
Spreadsheet: 678866d1590088299-formula-to-count-no-of-entries-by-month-and-year-2020-05-21-oeldere-dbroek-678860d1590086853-formula-to-count-no-of-entries-by-month-and-year-
Sheet: PT

Rijlabels | Average [NAME] |  |  |  |  |  |  | Total
2017 | 0.7811802232854864 |  |  |  |  | Month | Average | Trials
1 | 0.7792397660818713 |  |  |  | 1 | 42766 | 0.7792397660818713 | 24
2 | 0.7780864197530863 |  |  |  | 2 | 42794 | 0.7786786786786788 | 18
3 | 0.7780864197530863 |  |  |  | 3 | 42825 | 0.7784848484848484 | 18
4 | 0.7937037037037038 |  |  |  | 4 | 42855 | 0.7817460317460316 | 15
5 | 0.7792397660818713 |  |  |  | 5 | 42886 | 0.7812109862671658 | 19
6 | 0.7885620915032681 |  |  |  | 6 | 42916 | 0.782389937106918 | 17
7 | 0.7937037037037038 |  |  |  | 7 | 42947 | 0.7837924701561063 | 15
8 | 0.7792397660818713 |  |  |  | 8 | 42978 | 0.7831746031746029 | 19
9 | 0.7753472222222223 |  |  |  | 9 | 43008 | 0.7823717948717945 | 16
10 | 0.7792397660818713 |  |  |  | 10 | 43039 | 0.7820317460317459 | 19
11 | 0.7780864197530863 |  |  |  | 11 | 43069 | 0.781663788140472 | 18
12 | 0.7753472222222223 |  |  |  | 12 | 43100 | 0.7811802232854864 | 16
2018 | 0.6033333333333333
1 | 0.6033333333333333
2 | #[NAME]!
Eindtotaal | 0.7770249221183801
Spreadsheet: 73582d1274218282-lookup-with-2-criteria-then-grouped-lookup-based-on-2-criteria
Sheet: Sheet1

 | 1 | v1 | $ |  | Result:
 | 2 | v1 | $ |  |  | v1 | v2
 | 3 | v1 | $ |  | 1 | $ | $
 | 4 | v2 | $ |  | 2 | $ | $
 | 5 | v2 | $
 | 6 | v1 | $
 | 7 | v1 | $
 | 8 | v1 | $
 | 9 | v1 | $
 | 10 | v1 | $
 | 1 | v2 | $
 | 2 | v2 | $
 | 3 | v1 | $
 | 4 | v1 | $
 | 5 | v1 | $
 | 6 | v1 | $
 | 7 | v1 | $
 | 8 | v2 | $
 | 9 | v2 | $
 | 10 | v1 | $
 | 1 | v1 | $
 | 2 | v1 | $
 | 3 | v1 | $
 | 4 | v1 | $
 | 5 | v2 | $
 | 6 | v2 | $
 | 7 | v1 | $
 | 8 | v1 | $
 | 9 | v1 | $
 | 10 | v1 | $
Spreadsheet: 725661d1616781456-solved-function-to-track-how-many-items-different-warehouses-have-received-sent-track_warehouse_item_stock_example
Sheet: Tabelle1

Initial Table:
WS Location: | Action: | Number of units:
A | received | 27
B | received | 18
A | sent | 12
C | received | 35
B | sent | 9
Desired Summary:
WS Location: | Current stock:
A
B
C
Spreadsheet: 1cc616c8-8a26-41d2-af87-c66bd282fd2c
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Modern Languages
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 846503d1697672457-formula-to-auto-fill-tables-repeat-interviews
Sheet: TEST

Data Collector | Interviewee Name | Over 50 | Homeowner | Married | Pets | Ranking | Interview Again? |  | Data Collecter
Alpha | [NAME] | Yes | Yes | Yes | Yes | Perfect | Yes |  | Alpha
Alpha | [NAME] | Yes | No | Yes | No | Good | Yes |  |  | Interview Again - Yes | Interview Again - No
Alpha | [NAME] | No | Yes | No | No | Average | No |  | Over 50 | 2
Alpha | [NAME] | No | No | No | No | Bad | No |  | Under 50 |  | 1
Beta | Foxtrot | Yes | No | Yes | Yes | Perfect | Yes
Beta | [NAME] | Yes | No | Yes | Yes | Good | Yes |  | Homeowner | 1 | 1
Beta | Mo | No | Yes | No | No | Average | Yes |  | Non - Homeowner | 1
Beta | [NAME] | No | Yes | No | No | Bad | No
[NAME] | Lemon | Yes | Yes | Yes | Yes | Perfect | No |  | Married | 2
[NAME] | [NAME] | Yes | No | Yes | Yes | Good | No |  | Unmarried |  | 1
[NAME] | Malcom | No | No | No | No | Average | Yes
[NAME] | [NAME] | No | No | No | No | Bad | No |  | Pets | 1
Delta | Beta | Yes | Yes | Yes | Yes | Perfect | Yes |  | No Pets | 1 | 1
Delta | Sandra | Yes | No | Yes | Yes | Good | Yes
Alpha | Golf | No | Yes | No | No | Average | No |  | Ranking - Perfect | 1
Goose | [NAME] | No | No | No | No | Bad | No |  | Ranking - Good | 1
 |  |  |  |  |  |  |  |  | Ranking - Average |  | 1
 |  |  |  |  |  |  |  |  | Ranking - Bad
 |  |  |  |  |  |  |  |  | Interviewer Name
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Interview Again - Yes | Interview Again - No
 |  |  |  |  |  |  |  |  | Over 50
 |  |  |  |  |  |  |  |  | Under 50
 |  |  |  |  |  |  |  |  | Homeowner
 |  |  |  |  |  |  |  |  | Non - Homeowner
 |  |  |  |  |  |  |  |  | Married
 |  |  |  |  |  |  |  |  | Unmarried
 |  |  |  |  |  |  |  |  | Pets
 |  |  |  |  |  |  |  |  | No Pets
 |  |  |  |  |  |  |  |  | Ranking - Perfect
 |  |  |  |  |  |  |  |  | Ranking - Good
 |  |  |  |  |  |  |  |  | Ranking - Average
 |  |  |  |  |  |  |  |  | Ranking - Bad
 |  |  |  |  |  |  |  |  | Interviewer Name
 |  |  |  |  |  |  |  |  | Beta
 |  |  |  |  |  |  |  |  |  | Interview Again - Yes | Interview Again - No
 |  |  |  |  |  |  |  |  | Over 50
 |  |  |  |  |  |  |  |  | Under 50
 |  |  |  |  |  |  |  |  | Homeowner
 |  |  |  |  |  |  |  |  | Non - Homeowner
 |  |  |  |  |  |  |  |  | Married
 |  |  |  |  |  |  |  |  | Unmarried
 |  |  |  |  |  |  |  |  | Pets
 |  |  |  |  |  |  |  |  | No Pets
 |  |  |  |  |  |  |  |  | Ranking - Perfect
 |  |  |  |  |  |  |  |  | Ranking - Good
 |  |  |  |  |  |  |  |  | Ranking - Average
 |  |  |  |  |  |  |  |  | Ranking - Bad
Spreadsheet: 683547d1592824931-distribute-numbers-based-on-date-and-complexity-distribution-example-v1
Sheet: Sheet1

 | Project | complexity | phase 1 | phase 2 | phase 3 | phase 4 | 2020-05-20 00:00:00 | 2020-06-03 00:00:00 | 2020-07-20 00:00:00 | 2020-08-29 00:00:00 | 2020-09-20 00:00:00 | 2020-10-20 00:00:00 | 2020-11-20 00:00:00 | 2020-12-20 00:00:00 | 2021-01-20 00:00:00 | 2021-02-20 00:00:00 | 2021-03-20 00:00:00 | 2021-04-20 00:00:00 | 2021-05-20 00:00:00 | 2021-06-20 00:00:00 | 2021-07-20 00:00:00 | 2021-08-20 00:00:00 | 2021-09-20 00:00:00 | 2021-10-20 00:00:00 | 2021-11-20 00:00:00 | 2021-12-20 00:00:00 | 2022-01-20 00:00:00 | 2022-02-20 00:00:00 | 2022-03-20 00:00:00 | 2022-04-20 00:00:00 | 2022-05-20 00:00:00 | 2022-06-20 00:00:00 | 2022-07-20 00:00:00
 | Alpha | X1 | 2020-05-28 00:00:00 | 2020-09-29 00:00:00 | 2021-01-21 00:00:00 | 2021-04-21 00:00:00
 | Beta | X2 | 2020-09-20 00:00:00 | 2020-12-20 00:00:00 | 2021-05-22 00:00:00 | 2021-08-22 00:00:00
 | Gamma | X3 | 2021-01-21 00:00:00 | 2021-08-20 00:00:00 | 2021-12-23 00:00:00 | 2022-05-23 00:00:00
 | Omega | X4 | 2021-03-21 00:00:00 | 2021-09-21 00:00:00 | 2022-04-24 00:00:00 | 2022-09-24 00:00:00
 |  |  |  | Total Phase 1 | Total Phase 2 | Total Phase 3 | Total phase 4 | Total Project hours
 |  |  | X1 | 33 | 8 | 22.5 | Closure of project, no hours | 67.5
 |  |  | X2 | 12 | 27 | 181.5 |  | 247.5
 |  |  | X3 | 12 | 27 | 181.5 |  | 247.5
 |  |  | X4 | 15 | 30 | 181.5 |  | 253.5
Spreadsheet: 5a9ffc6c-3668-465e-9cc0-9a40ec7c639e
Sheet: Reported Counts

Auto Collision Insurer
Exhibit I (Sheet 2) p.216
Reported Claim Counts
PART 1 - Data Triangle
AY | 6
2003-2 | 3556 | 3314 | 3301 | 3299 | 3295 | 3294 | 3293 | 3293 | 3293 | 3292
2004-1 | 3492 | 3262 | 3250 | 3247 | 3247 | 3245 | 3245 | 3244 | 3243
2004-2 | 2980 | 2712 | 2704 | 2702 | 2700 | 2700 | 2699 | 2699
2005-1 | 2896 | 2768 | 2761 | 2758 | 2758 | 2758 | 2757
2005-2 | 2814 | 2650 | 2640 | 2639 | 2638 | 2636
2006-1 | 2808 | 2712 | 2704 | 2701 | 2700
2006-2 | 2799 | 2675 | 2670 | 2668
2007-1 | 2578 | 2533 | 2529
2007-2 | 2791 | 2778
2008-1 | 3139
AY |  |  |  |  |  |  |  |  |  | 60-Ult
2003-2
2004-1
2004-2
2005-1
2005-2
2006-1
2006-2
2007-1
2007-2
Simple
L5
L3
L2
Medial
L5x1
Vol Wtd
L5
L3
Geo
[NAME]
Prior
Sel |  |  |  |  |  |  |  |  |  | 1
CDF to Ult
% Paid
Spreadsheet: 698517d1602014736-proportional-distribution-upto-the-cap-test
Sheet: Iteration 1 

 |  |  |  |  |  |  | [NAME] for Cell G7/G18???
Example 1
 |  | Inventory Available |  | 7000
 | Total
 | Item | Required | [NAME] cap | Proportional dist. Without cap | Proportional dist. With [NAME] | Requirement with cap | Delta b/w with and without cap
 | A | 0 | 2000 |  |  | 0
 | B | 4000 | 2000 |  |  | 2000 |  | * Delta is to be distributed proportionally to other item upto there CAP
 | C | 4500 | 5000 |  |  | 5000
 | D | 0 | 5000 |  |  | 0
Example 2 |  | Inventory Available |  | 7000
 | Total
 | Item | Required | [NAME] cap | Proportional dist. Without cap | Proportional dist. With [NAME] | Requirement with cap | Delta b/w with and without cap
 | A | 2000 | 2000
 | B | 4000 | 2000 |  |  | 2000 |  | * Delta is to be distributed proportionally to other item upto there CAP
 | C | 4500 | 5000 |  |  |  |  | * Here 434.78 is proportionally divided between [NAME] (A, C, D)whose CAP is not yet met
 | D | 1000 | 5000
Spreadsheet: 87229d1287072659-data-validation-allowing-invalid-entries-ecd-diary-beta-1
Sheet: Nov '10

 | Week Total | Daily Average |  | Week Remaining Hrs | Date | S&F Hrs Total | Rep/Paint Total | Slot 1 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 2 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 3 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 4 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 5 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 6 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 7 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 8 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 9 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 10 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 11 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 12 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 13 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 14 | Est. Initials | S&F Hrs | Rep/Paint Hrs | Slot 15 | Est. Initials | S&F Hrs | Rep/Paint Hrs
S&F Capacity | 340 | 68 | S&F Hrs Remaining | -12.14999999999998 | Mon 1 Nov 10 | 85.7 | 28.5 | 36289 | JJ | 7.1 | 8 | 35533 | CD | 3.3 | 0 | 35331 | CD | 6.5 | 0 | 36250 | CD | 8.3 | 0 |  |  |  |  | 36199 | RM | 7.1 | 0 | 36067 | RM | 11.2 | 0 | 36224 | RM | 9.4 | 9 | 36261 | RM | 9.4 | 3 | 36249 | DL | 9.6 | 6 | 35600 | DL | 6.9 |  | 36327 | CD | 6.9 | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  | S&F Hrs Reduction
Rep & Pnt Capacity | 382.5 | 76.5 | Rep/Pnt Hrs Remaining | 75.40000000000003 | Tues 2 Nov 10 | 107.55 | 101.6 | 35403 | KG | 8.5 | 17.1 | 35701 | KG | 0.5 | 0 | 36051 | IS | 13.05 | 24.5 | 36290 | JM | 6.7 | 6 | 36062 | DC | 8.3 | 6 | 36207 | DC | 14.6 | 9 | 35267 | KG | 10.6 | 10 | 36280 | JM | 8.3 | 10 | 35950 | KG | 7.8 | 0 | 36273 | DC | 8.2 | 5 | 36235 | RM | 13.4 | 14 | 36262 | RM | 7.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep/Pnt Hrs Reduction
 |  |  |  |  | Wed 3 Nov 10 | 77.39999999999999 | 59.3 | 36109 | KG | 6.3 | 1.8 |  | KG | 1.2 | 0 | 36298 | KG | 9.3 | 3.5 | 36259 | JJ | 11.5 | 0 | 36310 | JJ | 7.8 | 9.5 | 36245 | JJ | 8.4 | 5 | 36370 | JM | 10.5 | 14.5 | 36475 | CD | 9.55 | 11 | 36325 | JJ | 4.1 | 0 | 36471 | CD | 8.75 | 12 | 36666 | CD | 0 | 2
 |  |  |  |  | Thur 4 Nov 10 | 46.1 | 69.2 | 36093 | IS | 10.3 | 13.5 | 36277 | IS | 13.5 | 15.5 | 36236 | AF | 10.4 | 18.2 | 36101 | DL | 11.9 | 22
 |  |  |  |  | Fri 5 Nov 10 | 35.4 | 48.5 | 35968 | AF | 14.5 | 40 | 35980 | DL | 13.6 | 4.5 | 36343 | DL | 1 | 0 | 35413 | IS | 6.3 | 4
Spreadsheet: 719482d1613676832-timezone-conversion-in-a-weekly-view-sched-conversion
Sheet: MST View

 |  |  |  |  |  |  |  | Mountain (AZ) Time
Emp ID | Emp Name | Shift | Shift Type | RD1 | RD2 | RD3 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 227287b0-c666-46ab-a845-4e4a3327ce13
Sheet: .

MONTH END FINANCIAL REPORTING DATES
FOR FISCAL YEAR 2015
The dates below indicate when month end financial reporting is expected to be available based on the established closing schedule.  The Controller's office closes the fiscal month on the fourth working day of the proceeding month.  If problems occur that result in a delay in closing, the BAS forum group will be notified by    e-mail.
Reports are available the 5th business day of the following month.
Fiscal month | Calendar month | Date the month end financial reports are expected to be available
01 | July 2014 | 2014-08-07 00:00:00
02 | Aug. 2014 | 2014-09-08 00:00:00
03 | Sept. 2014 | 2014-10-07 00:00:00
04 | Oct. 2014 | 2014-11-07 00:00:00
05 | Nov. 2014 | 2014-12-05 00:00:00
06 | Dec. 2014 | 2015-01-08 00:00:00
07 | Jan. 2015 | 2015-02-06 00:00:00
08 | Feb. 2015 | 2015-03-06 00:00:00
09 | March 2015 | 2015-04-07 00:00:00
10 | April 2015 | 2015-05-07 00:00:00
11 | May 2015 | 2015-06-05 00:00:00
12 | June 2015 | to be announced
To obtain month end reports, sign into [NAME], click on the "My Action Items" tab and then
"Finance Reports."
To obtain reports for June 2007 and prior months go to the Financial Records System (FRS).
http://financial-info.kent.edu/