Table of Contents FRP301 - Advanced Excel

01-Introduction Review of COUNTIF, SUMIF, and absolute referencing

03-VLOOKUP Understand the two ways to use VLOOKUP
03-Date to Period Conversion How to add Period, Fiscal Year, and Month to a table
03-Date Table
04-Pivot Table 1 Introduction to pivot tables. Build a basic pivot table
04-Pivot Table 2 Pivot Charts
05-filter1 Advanced Filter to find a subset of data
05-filter2 Find unique values and copy to another location
06-CF Row Banding Create a dropdown lookup with application to conditional formatting
02-IF How to use IF, IF(AND, IF(OR
02-IF-ISERROR Hiding Error Cells
02-If-Nested Using nested IF functions
TEXT Explanation of the TEXT feature
Database Functions Explanation of Database Functionality
FRP301 Formula
Printable Handouts
 Return to TOC Review of COUNTIF and SUMIF
214 ct_core_hr_tl_sick_report
ID Empl Rcd# Name TRC Earn Code Quantity Rpt Dt DAY TRC Countif Sumif
311587 0 Smith,Jacob SP SIC 2.000000 12/16/2010 THURSDAY SP
645109 0 Johnson,Michael SFFNR SIC 8.000000 12/15/2010 WEDNESDAY SFFNR
645109 0 Johnson,Michael SFFNR SIC 8.000000 12/16/2010 THURSDAY SFAM
835119 0 Williams,Joshua SFAM SIC 5.000000 12/15/2010 WEDNESDAY SFNRL
921565 0 Jones,Matthew SFNRL SIC 8.000000 12/16/2010 THURSDAY SICK
904174 0 Brown,Daniel SP SIC 4.000000 12/16/2010 THURSDAY
108501 0 Davis,Christopher SFAM SIC 3.500000 12/15/2010 WEDNESDAY
806984 0 Miller,Andrew SICK SIC 8.000000 12/16/2010 THURSDAY
605544 0 Wilson,Ethan SFFNR SIC 8.000000 12/15/2010 WEDNESDAY DAY Countif Sumif
261528 0 Moore,Joseph SICK SIC 8.000000 12/15/2010 WEDNESDAY MONDAY
261528 0 Moore,Joseph SICK SIC 8.000000 12/16/2010 THURSDAY TUESDAY
682726 0 Taylor,William SP SIC 1.000000 12/15/2010 WEDNESDAY WEDNESDAY
682726 0 Taylor,William SP SIC 1.500000 12/16/2010 THURSDAY THURSDAY
268234 0 Anderson,Anthony SP SIC 1.500000 12/15/2010 WEDNESDAY FRIDAY
537900 0 Thomas,David SP SIC 2.000000 12/15/2010 WEDNESDAY
935382 0 Jackson,Alexander SP SIC 3.500000 12/15/2010 WEDNESDAY
602526 0 White,Nicholas SP SIC 2.000000 12/15/2010 WEDNESDAY COUNTIFS or SUMPRODUCT
624084 0 Harris,Ryan SP SIC 1.250000 12/16/2010 THURSDAY
341458 0 Martin,Tyler SICK SIC 8.000000 12/16/2010 THURSDAY Occurrences
674630 0 Thompson,James SP SIC 2.750000 12/16/2010 THURSDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total
674630 0 Thompson,James SFAM SIC 1.000000 12/16/2010 THURSDAY SP
752850 0 Garcia,John SFAM SIC 1.250000 12/15/2010 WEDNESDAY SFFNR
951321 1 Martinez,Jonathan SP SIC 8.750000 12/17/2010 FRIDAY SFAM
311587 0 Smith,Jacob SFNRL SIC 4.000000 12/17/2010 FRIDAY SFNRL
140990 0 Robinson,Noah SP SIC 2.000000 12/28/2010 TUESDAY SICK
883669
COUNTIF/ SUMIF 0 Clark,Brandon
Notes (all versions of Excel) SICK SIC 4.750000 12/22/2010 WEDNESDAY Total
733760 0 Rodriguez,Christian SP SIC 3.500000 12/20/2010 MONDAY
474941 0 Lewis,Dylan SP SIC 2.500000 12/22/2010 WEDNESDAY
The COUNTIF function counts the number of items which match a criteria set by the user
474941 0 Lewis,Dylan SP SIC 1.500000 12/28/2010 TUESDAY
=COUNTIF(CriteriaRange,CriteriaToMatch)
615307 0 Lee,Samuel SP SIC 4.000000 12/17/2010 FRIDAY SUMIFS or SUMPRODUCT
The SUMIF function adds the value of items which match a criteria set by the user.
144775 0 Walker,Benjamin SP SIC 2.000000 12/28/2010 TUESDAY
=SUMIF(CriteriaRange,CriteriaToMatch,RangeToSum)
54857 0 Hall,Zachary SP SIC 1.000000 12/21/2010 TUESDAY Hours
Examples
969490 0 Allen,Nathan SFAM SIC 3.000000 12/21/2010 TUESDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY Total
=SUMIF(D37:D80,"11000",P37:P80)
969490 0 Allen,Nathan
=SUMIF(Fund,F20,Total_Amt) SICK SIC 8.000000 12/22/2010 WEDNESDAY SP
579919 0 Young,Logan SICK SIC 2.000000 12/22/2010 WEDNESDAY SFFNR
599675 0 Hernandez,Justin
COUNTIFS/ SUMIFS Notes (Excel 2007/2010 only)SP SIC 2.000000 12/22/2010 WEDNESDAY SFAM
COUNTIFS and SUMIFS
625135 allow for multiple AND conditions
0 King,Gabriel SP SIC 1.000000 12/28/2010 TUESDAY SFNRL
=COUNTIFS(Criteria1Range,Criteria1,Criteria2Range,Criteria2)
664825 0 Wright,Jose SICK SIC 8.000000 12/30/2010 THURSDAY SICK
=SUMIFS(RangeToSum,Criteria1Range,Criteria1,Criteria2Range,Criteria2)
664825 0 Wright,Jose SICK SIC 6.000000 12/29/2010 WEDNESDAY Total
459949 0 Lopez,Austin SP SIC 2.000000 12/17/2010 FRIDAY
375792
SUMPRODUCT Notes 0 Hill,Kevin
(all versions of Excel) SFNRL SIC 4.000000 12/20/2010 MONDAY
459949
Using AND criteria0 Lopez,Austin SFAM SIC 8.000000 1/3/2011 MONDAY
459949 0 Lopez,Austin SFAM SIC 4.000000 1/4/2011 TUESDAY
=SUMPRODUCT((Criteria1Range=Criteria1)*(Criteria2Range=Criteria2)) - To Count items
869277 0 Scott,Elijah SICK SIC 8.000000 12/29/2010 WEDNESDAY
=SUMPRODUCT((Criteria1Range=Criteria1)*(Criteria2Range=Criteria2)*RangeToSum) - To Sum items
389844 0 Green,Caleb SICK SIC 2.000000 12/22/2010 WEDNESDAY
Note: The RangeToSum is not in its own parenthetical phrase

The Criteria to Match can be a word "11000"), an agebraic function (">0"), or a cell reference (N20)
The Criteria to Match can be a wildcard where * is any number of spaces and ? Is a single space
 COUNTIFS and SUMIFS allow for multiple AND conditions
=COUNTIFS(Criteria1Range,Criteria1,Criteria2Range,Criteria2)
=SUMIFS(RangeToSum,Criteria1Range,Criteria1,Criteria2Range,Criteria2)

SUMPRODUCT Notes (all versions of Excel)

Using AND criteria
=SUMPRODUCT((Criteria1Range=Criteria1)*(Criteria2Range=Criteria2)) - To Count items
=SUMPRODUCT((Criteria1Range=Criteria1)*(Criteria2Range=Criteria2)*RangeToSum) - To Sum items
Note: The RangeToSum
389844 is not in its own parentheticalSICK
0 Green,Caleb phrase SIC 8.000000 12/23/2010 THURSDAY
873164 0 Adams,Robert SICK SIC 3.000000 12/28/2010 TUESDAY
935382 0 Jackson,Alexander
The Criteria to Match SICKfunction SIC
can be a word "11000"), an agebraic 8.000000
(">0"), or a cell reference (N20)12/30/2010 THURSDAY
935382 0 Jackson,Alexander
The Criteria to Match can be a wildcard where * is any SICK SIC and ? Is a single
number of spaces 8.000000
space 12/29/2010 WEDNESDAY
555166 0 Baker,Thomas SICK SIC 8.000000 12/22/2010 WEDNESDAY
555166 0 Baker,Thomas SICK SIC 6.250000 12/21/2010 TUESDAY
555166 0 Baker,Thomas SFNRL SIC 4.000000 12/17/2010 FRIDAY
503495 0 Gonzalez,Jordan SP SIC 2.000000 12/20/2010 MONDAY
503495 0 Gonzalez,Jordan SP SIC 8.000000 12/22/2010 WEDNESDAY
935382 0 Jackson,Alexander SICK SIC 8.000000 12/28/2010 TUESDAY
35938 0 Nelson,Cameron SP SIC 2.000000 12/17/2010 FRIDAY
162126 0 Carter,Jack SP SIC 3.000000 12/20/2010 MONDAY
453743 0 Mitchell,Hunter SFAM SIC 3.250000 12/20/2010 MONDAY
674630 0 Thompson,James SICK SIC 8.000000 12/20/2010 MONDAY
422727 0 Perez,Jackson SFNRL SIC 8.000000 12/21/2010 TUESDAY
820836 0 Roberts,Angel SFNRL SIC 4.000000 12/17/2010 FRIDAY
647912 0 Turner,Isaiah SP SIC 2.500000 12/17/2010 FRIDAY
363618 0 Phillips,Evan SP SIC 1.000000 12/21/2010 TUESDAY
309284 0 Campbell,Isaac SP SIC 8.000000 12/20/2010 MONDAY
694606 0 Parker,Mason SP SIC 0.750000 12/20/2010 MONDAY
694606 0 Parker,Mason SP SIC 0.500000 12/29/2010 WEDNESDAY
942722 0 Evans,Luke SP SIC 1.000000 12/21/2010 TUESDAY
689783 0 Edwards,Jason SP SIC 3.000000 12/29/2010 WEDNESDAY
572634 0 Collins,Gavin SFAM SIC 8.000000 12/17/2010 FRIDAY
572634 0 Collins,Gavin SFFNR SIC 8.000000 12/20/2010 MONDAY
572634 0 Collins,Gavin SFFNR SIC 8.000000 12/21/2010 TUESDAY
572634 0 Collins,Gavin SFFNR SIC 8.000000 12/22/2010 WEDNESDAY
53568 0 Stewart,Jayden SICK SIC 8.000000 12/30/2010 THURSDAY
341458 0 Martin,Tyler SICK SIC 8.000000 12/30/2010 THURSDAY
645109 0 Johnson,Michael SICK SIC 4.000000 12/21/2010 TUESDAY
645109 0 Johnson,Michael SICK SIC 8.000000 12/22/2010 WEDNESDAY
645109 0 Johnson,Michael SICK SIC 8.000000 12/23/2010 THURSDAY
309793 0 Sanchez,Aaron SFNRL SIC 2.000000 12/22/2010 WEDNESDAY
689074 0 Morris,Connor SICK SIC 8.000000 12/28/2010 TUESDAY
689074 0 Morris,Connor SICK SIC 8.000000 12/29/2010 WEDNESDAY
689074 0 Morris,Connor SICK SIC 8.000000 12/30/2010 THURSDAY
609303 1 Rogers,Aiden SICK SIC 8.000000 12/28/2010 TUESDAY
185450 0 Reed,Aidan SICK SIC 4.000000 12/21/2010 TUESDAY
525099 0 Cook,Kyle SICK SIC 8.000000 12/20/2010 MONDAY
217327 0 Morgan,Juan SICK SIC 8.000000 12/17/2010 FRIDAY
585545 0 Bell,Charles SICK SIC 8.000000 12/28/2010 TUESDAY
853351 0 Murphy,Luis SP SIC 2.000000 12/20/2010 MONDAY
853351 0 Murphy,Luis SP SIC 4.000000 12/17/2010 FRIDAY
853351 0 Murphy,Luis SICK SIC 8.000000 12/21/2010 TUESDAY
972886 0 Bailey,Adam SP SIC 1.000000 12/20/2010 MONDAY
934035 0 Rivera,Lucas SFAM SIC 4.000000 1/4/2011 TUESDAY
459949 0 Lopez,Austin SFAM SIC 5.000000 1/4/2011 TUESDAY
459949 0 Lopez,Austin SFAM SIC -4.000000 1/4/2011 TUESDAY
459949 0 Lopez,Austin SFAM SIC 3.000000 1/5/2011 WEDNESDAY
377203 0 Cooper,Brian SP SIC 1.000000 1/3/2011 MONDAY
728279 0 Richardson,Eric SICK SIC 7.000000 1/6/2011 THURSDAY
642295 0 Cox,Adrian SFAM SIC 8.000000 1/7/2011 FRIDAY
624084 0 Harris,Ryan SP SIC -1.250000 12/16/2010 THURSDAY
624084 0 Harris,Ryan SP SIC 1.750000 12/16/2010 THURSDAY
728279 0 Richardson,Eric SP SIC 2.000000 12/16/2010 THURSDAY
140990 0 Robinson,Noah SP SIC 3.000000 12/16/2010 THURSDAY
198333 1 Howard,Nathaniel SICK SIC 4.000000 12/16/2010 THURSDAY
44371 0 Ward,Sean SICK SIC 3.000000 12/15/2010 WEDNESDAY
44371 0 Ward,Sean SICK SIC 8.000000 12/16/2010 THURSDAY
988116 0 Torres,Alex SICK SIC 7.000000 12/15/2010 WEDNESDAY
500684 0 Peterson,Carlos SP SIC 1.000000 12/16/2010 THURSDAY
429643 0 Gray,Bryan SICK SIC 8.000000 12/15/2010 WEDNESDAY
429643 0 Gray,Bryan SP SIC 2.750000 12/16/2010 THURSDAY
738503 0 Ramirez,Ian SP SIC 1.250000 12/16/2010 THURSDAY
55381 0 James,Owen SP SIC 8.000000 12/15/2010 WEDNESDAY
115195 0 Watson,Jesus SP SIC 1.500000 12/15/2010 WEDNESDAY
545521 0 Brooks,Landon SICK SIC 2.250000 12/16/2010 THURSDAY
775444 0 Kelly,Julian SP SIC 1.000000 12/16/2010 THURSDAY
856465 0 Sanders,Chase SP SIC 6.000000 12/15/2010 WEDNESDAY
555242 0 Price,Cole SP SIC 3.500000 12/16/2010 THURSDAY
251999 0 Bennett,Diego SICK SIC 1.500000 12/16/2010 THURSDAY
99193 0 Wood,Jeremiah SICK SIC 4.000000 12/15/2010 WEDNESDAY
99193 0 Wood,Jeremiah SICK SIC 8.000000 12/16/2010 THURSDAY
392062 0 Barnes,Steven SICK SIC 8.000000 12/16/2010 THURSDAY
422727 0 Perez,Jackson SFNRL SIC 2.000000 12/16/2010 THURSDAY
377203 0 Cooper,Brian SP SIC 1.000000 12/22/2010 WEDNESDAY
654062 0 Ross,Sebastian SICK SIC 8.000000 12/21/2010 TUESDAY
755355 0 Henderson,Xavier SICK SIC 8.000000 12/21/2010 TUESDAY
555862 0 Coleman,Timothy SP SIC 2.000000 12/17/2010 FRIDAY
338561 0 Jenkins,Carter SP SIC 1.000000 12/28/2010 TUESDAY
226479 0 Perry,Wyatt SP SIC 1.000000 12/20/2010 MONDAY
226479 0 Perry,Wyatt SP SIC 2.000000 12/23/2010 THURSDAY
500684 0 Peterson,Carlos SFNRL SIC 3.000000 12/20/2010 MONDAY
462639 0 Powell,Brayden SICK SIC 5.000000 12/29/2010 WEDNESDAY
793716 0 Long,Blake SP SIC 1.000000 12/17/2010 FRIDAY
301384 0 Patterson,Hayden SP SIC 4.000000 12/28/2010 TUESDAY
113347 0 Hughes,Devin SP SIC 2.000000 12/17/2010 FRIDAY
398541 0 Flores,Cody SICK SIC 8.000000 12/28/2010 TUESDAY
288928 0 Washington,Richard SFAM SIC 6.000000 12/17/2010 FRIDAY
775167 0 Butler,Seth SICK SIC 3.000000 12/20/2010 MONDAY
775167 0 Butler,Seth SICK SIC 3.000000 12/17/2010 FRIDAY
775444 0 Kelly,Julian SICK SIC 8.000000 12/29/2010 WEDNESDAY
775167 0 Butler,Seth SICK SIC 8.000000 12/21/2010 TUESDAY
775167 0 Butler,Seth SICK SIC 3.000000 12/22/2010 WEDNESDAY
775167 0 Butler,Seth SICK SIC 3.000000 12/28/2010 TUESDAY
775167 0 Butler,Seth SICK SIC 3.000000 12/29/2010 WEDNESDAY
130559 0 Simmons,Dominic SP SIC 2.000000 12/22/2010 WEDNESDAY
437881 0 Foster,Jaden SP SIC 3.500000 12/20/2010 MONDAY
641295 0 Gonzales,Antonio SP SIC 3.000000 12/17/2010 FRIDAY
371859 0 Bryant,Miguel SICK SIC 4.000000 12/21/2010 TUESDAY
371859 0 Bryant,Miguel SICK SIC 2.000000 12/22/2010 WEDNESDAY
245734 0 Alexander,Liam SICK SIC 8.000000 12/29/2010 WEDNESDAY
569961 0 Russell,Patrick SP SIC 1.000000 1/3/2011 MONDAY
245734 0 Alexander,Liam SICK SIC 8.000000 12/28/2010 TUESDAY
545521 0 Brooks,Landon SICK SIC 2.000000 12/28/2010 TUESDAY
115195 0 Watson,Jesus SP SIC 0.500000 12/29/2010 WEDNESDAY
798649 0 Griffin,Carson SP SIC 3.500000 12/17/2010 FRIDAY
747126 0 Diaz,Jesse SFAM SIC 8.000000 12/28/2010 TUESDAY
739647 0 Hayes,Tristan SP SIC 2.000000 12/29/2010 WEDNESDAY
292456 0 Myers,Alejandro SFAM SIC 0.500000 12/22/2010 WEDNESDAY
425584 0 Ford,Henry SP SIC 8.000000 12/28/2010 TUESDAY
872321 0 Hamilton,Victor SP SIC 1.750000 12/22/2010 WEDNESDAY
261528 0 Moore,Joseph SICK SIC 8.000000 12/17/2010 FRIDAY
280348 0 Graham,Trevor SICK SIC 8.000000 12/21/2010 TUESDAY
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/23/2010 THURSDAY
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/28/2010 TUESDAY
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/29/2010 WEDNESDAY
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/30/2010 THURSDAY
170542 0 Wallace,Jake SICK SIC 8.000000 12/21/2010 TUESDAY
170542 0 Wallace,Jake SICK SIC 4.000000 12/20/2010 MONDAY
99193 0 Wood,Jeremiah SICK SIC 6.750000 12/17/2010 FRIDAY
682726 0 Taylor,William SP SIC 2.000000 12/29/2010 WEDNESDAY
689074 0 Morris,Connor SICK SIC -8.000000 12/28/2010 TUESDAY
689074 0 Morris,Connor SICK SIC 8.000000 12/28/2010 TUESDAY
689074 0 Morris,Connor SICK SIC -8.000000 12/29/2010 WEDNESDAY
689074 0 Morris,Connor SICK SIC 8.000000 12/29/2010 WEDNESDAY
689074 0 Morris,Connor SICK SIC -8.000000 12/30/2010 THURSDAY
689074 0 Morris,Connor SICK SIC 8.000000 12/30/2010 THURSDAY
609303 1 Rogers,Aiden SICK SIC 8.000000 12/28/2010 TUESDAY
609303 1 Rogers,Aiden SICK SIC -8.000000 12/28/2010 TUESDAY
112940 0 Woods,Riley SICK SIC 8.000000 1/5/2011 WEDNESDAY
112940 0 Woods,Riley SP SIC 3.500000 1/7/2011 FRIDAY
389844 0 Green,Caleb SP SIC 1.750000 1/12/2011 WEDNESDAY
389844 0 Green,Caleb SP SIC 2.000000 1/14/2011 FRIDAY
389844 0 Green,Caleb SP SIC 2.000000 1/5/2011 WEDNESDAY
112940 0 Woods,Riley SICK SIC 8.000000 1/3/2011 MONDAY
112940 0 Woods,Riley SICK SIC 8.000000 1/4/2011 TUESDAY
402483 0 Cole,Colin SP SIC 1.000000 1/3/2011 MONDAY
625135 0 King,Gabriel SP SIC 8.000000 1/5/2011 WEDNESDAY
5435 0 West,Jared SFAM SIC 2.500000 1/6/2011 THURSDAY
798649 0 Griffin,Carson SFAM SIC 1.500000 1/6/2011 THURSDAY
113347 0 Hughes,Devin SFAM SIC 1.500000 1/5/2011 WEDNESDAY
596745 0 Jordan,Jeremy SICK SIC 8.000000 1/5/2011 WEDNESDAY
596745 0 Jordan,Jeremy SP SIC 0.750000 1/13/2011 THURSDAY
846953 0 Owens,Mark SICK SIC 3.000000 1/10/2011 MONDAY
138199 0 Reynolds,Caden SFAM SIC 8.000000 1/3/2011 MONDAY
138199 0 Reynolds,Caden SP SIC 1.000000 1/6/2011 THURSDAY
138199 0 Reynolds,Caden SP SIC 0.750000 1/10/2011 MONDAY
747126 0 Diaz,Jesse SP SIC 2.000000 1/11/2011 TUESDAY
375792 0 Hill,Kevin SP SIC 2.000000 1/7/2011 FRIDAY
471981 0 Fisher,Garrett SP SIC 3.500000 1/10/2011 MONDAY
942722 0 Evans,Luke SICK SIC 8.000000 1/3/2011 MONDAY
942722 0 Evans,Luke SICK SIC 8.000000 1/4/2011 TUESDAY
942722 0 Evans,Luke SICK SIC 8.000000 1/5/2011 WEDNESDAY
942722 0 Evans,Luke SICK SIC 8.000000 1/6/2011 THURSDAY
942722 0 Evans,Luke SICK SIC 8.000000 1/7/2011 FRIDAY
544430 0 Ellis,Parker SICK SIC 1.500000 1/10/2011 MONDAY
904174 0 Brown,Daniel SP SIC 4.000000 1/4/2011 TUESDAY
904174 0 Brown,Daniel SP SIC 4.000000 1/11/2011 TUESDAY
268234 0 Anderson,Anthony SP SIC 1.500000 1/6/2011 THURSDAY
66388 0 Harrison,Marcus SICK SIC 8.000000 1/7/2011 FRIDAY
209328 0 Gibson,Vincent SP SIC 1.750000 1/3/2011 MONDAY
27178 0 Mcdonald,Kaleb SP SIC 8.000000 1/11/2011 TUESDAY
129044 0 Cruz,Kaden SP SIC 1.000000 1/11/2011 TUESDAY
560101 0 Marshall,Brady SP SIC 1.500000 1/6/2011 THURSDAY
162126 0 Carter,Jack SP SIC 3.000000 1/6/2011 THURSDAY
694606 0 Parker,Mason SP SIC 2.000000 1/4/2011 TUESDAY
968003 0 Ortiz,Colton SP SIC 3.000000 1/12/2011 WEDNESDAY
 Return to TOC CT_CORE_FIN_PO_BAL_ALL_PO
Unit PO PO Date Vendor Name 1 Line Dist Line
DOTM1 0000119202 1/9/2013 GENUINE PARTS COMPANY 2 1
DOTM1 0000119202 1/9/2013 GENUINE PARTS COMPANY 1 1
DOTM1 0000119204 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 1 1
DOTM1 0000119204 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 2 1
DOTM1 0000119205 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 1 1
DOTM1 0000119205 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 3 1
DOTM1 0000119205 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 5 1
DOTM1 0000119205 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 2 1
DOTM1 0000119205 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 4 1
DOTM1 0000119206 1/9/2013 NUTMEG INTERNATIONAL TRUCKS INC 1 1
DOTM1 0000119207 1/9/2013 SOUTHERN CONNECTICUT FREIGHTLINER 1 1
DOTM1 0000119208 1/9/2013 SOUTHERN CONNECTICUT FREIGHTLINER 1 1
DOTM1 0000119210 1/9/2013 TRI COUNTY CONTRACTORS SUPPLY 1 1
DOTM1 0000119210 1/9/2013 TRI COUNTY CONTRACTORS SUPPLY 2 1
DOTM1 0000119211 1/9/2013 ALLSTON SUPPLY CO INC 1 1
DOTM1 0000119212 1/9/2013 TOCE BROS INC 1 1
DOTM1 0000119213 1/9/2013 CAMEROTA TRUCK PARTS 1 1
DOTM1 0000119214 1/9/2013 FORESTRY SUPP INC 1 1
DOTM1 0000119215 1/9/2013 COURVILLES GARAGE INC 1 1
DOTM1 0000119216 1/9/2013 MIRABELLI AUTOMOTIVE LLC 1 1
DOTM1 0000119216 1/9/2013 MIRABELLI AUTOMOTIVE LLC 2 1
DOTM1 0000119217 12/21/2012 EOS CCA 1 1
DOTM1 0000119218 12/21/2012 VIKING-CIVES USA 1 1
DOTM1 0000119219 12/21/2012 VIKING-CIVES USA 1 1
DOTM1 0000119220 12/21/2012 STAPLES CONTRACT & COMMERCIAL INC 1 1
DOTM1 0000119220 12/21/2012 STAPLES CONTRACT & COMMERCIAL INC 2 1
DOTM1 0000119221 12/21/2012 DENNISON LUBRICANTS 1 1
DOTM1 0000119223 12/21/2012 DENNISON LUBRICANTS 1 1
DOTM1 0000119223 12/21/2012 DENNISON LUBRICANTS 2 1
DOTM1 0000119225 12/21/2012 CONNECTICUT POLICE CHIEFS ASSOC 1 1
DOTM1 0000119228 12/21/2012 TOWN OF EAST LYME 2 1
DOTM1 0000119228 12/21/2012 TOWN OF EAST LYME 1 1
DOTM1 0000119228 12/21/2012 TOWN OF EAST LYME 2 1
DOTM1 0000119228 12/21/2012 TOWN OF EAST LYME 1 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 14 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 16 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 16 2
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 6 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 7 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 8 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 9 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 10 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 12 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 11 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 15 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 5 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 17 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 13 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 3 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 4 1
DOTM1 0000119229 1/7/2013 GRAINGER INDUSTRIAL SUPPLY 2 1
DOTM1 0000119230 12/21/2012 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119231 12/21/2012 GENUINE PARTS COMPANY 3 1
DOTM1 0000119231 12/21/2012 GENUINE PARTS COMPANY 5 1
DOTM1 0000119231 12/21/2012 GENUINE PARTS COMPANY 1 1
DOTM1 0000119231 12/21/2012 GENUINE PARTS COMPANY 2 1
DOTM1 0000119231 12/21/2012 GENUINE PARTS COMPANY 4 1
DOTM1 0000119232 12/21/2012 GENUINE PARTS COMPANY 7 1
DOTM1 0000119232 12/21/2012 GENUINE PARTS COMPANY 6 1
DOTM1 0000119232 12/21/2012 GENUINE PARTS COMPANY 5 1
DOTM1 0000119232 12/21/2012 GENUINE PARTS COMPANY 4 1
DOTM1 0000119232 12/21/2012 GENUINE PARTS COMPANY 2 1
DOTM1 0000119232 12/21/2012 GENUINE PARTS COMPANY 1 1
DOTM1 0000119232 12/21/2012 GENUINE PARTS COMPANY 3 1
DOTM1 0000119233 12/21/2012 GENUINE PARTS COMPANY 1 1
DOTM1 0000119233 12/21/2012 GENUINE PARTS COMPANY 2 1
DOTM1 0000119234 12/7/2012 SOUTHERN CONNECTICUT FREIGHTLINER 1 1
DOTM1 0000119234 12/7/2012 SOUTHERN CONNECTICUT FREIGHTLINER 2 1
DOTM1 0000119235 12/7/2012 F W WEBB COMPANY 1 1
DOTM1 0000119239 12/7/2012 AUTOMATION INC 1 1
DOTM1 0000119240 12/7/2012 C N WOOD OF CONNECTICUT LLC 1 1
DOTM1 0000119242 12/7/2012 OVERHEAD DOOR CO 2 1
DOTM1 0000119242 12/7/2012 OVERHEAD DOOR CO 3 1
DOTM1 0000119288 12/21/2012 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119296 11/20/2012 NEW ENGLAND TRUCK EQUIPMENT LLC 1 1
DOTM1 0000119297 11/20/2012 ULTIMATE AUTOMOTIVE INC 2 1
DOTM1 0000119297 11/20/2012 ULTIMATE AUTOMOTIVE INC 1 1
DOTM1 0000119297 11/20/2012 ULTIMATE AUTOMOTIVE INC 3 1
DOTM1 0000119298 11/20/2012 MISTERSCAPES LLC 1 1
DOTM1 0000119299 11/20/2012 GRAINGER INDUSTRIAL SUPPLY 2 1
DOTM1 0000119299 11/20/2012 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119300 11/20/2012 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119300 11/20/2012 GRAINGER INDUSTRIAL SUPPLY 2 1
DOTM1 0000119300 11/20/2012 GRAINGER INDUSTRIAL SUPPLY 3 1
DOTM1 0000119301 11/20/2012 GRANITE GROUP INDUSTRIAL SUPPLY 1 1
DOTM1 0000119302 11/20/2012 TOCE BROS INC 1 1
DOTM1 0000119302 11/20/2012 TOCE BROS INC 2 1
DOTM1 0000119303 11/20/2012 C & C JANITORIAL SUPPLIES INC 1 1
DOTM1 0000119304 11/20/2012 EER LIMITED 1 1
DOTM1 0000119305 11/20/2012 CCM CONSTRUCTION SERVICES INC 2 1
DOTM1 0000119305 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119305 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119305 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119305 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119306 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119306 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119306 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119306 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119306 11/20/2012 CCM CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119307 11/20/2012 KELLY CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119307 11/20/2012 KELLY CONSTRUCTION SERVICES INC 1 1
DOTM1 0000119308 11/20/2012 GRAINGER INDUSTRIAL SUPPLY 3 1
DOTM1 0000119309 11/20/2012 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119310 11/20/2012 FLEETPRIDE INC 2 1
DOTM1 0000119310 11/20/2012 FLEETPRIDE INC 1 1
DOTM1 0000119311 11/20/2012 FLEETPRIDE INC 2 1
DOTM1 0000119311 11/20/2012 FLEETPRIDE INC 1 1
DOTM1 0000119312 11/20/2012 FLEETPRIDE INC 1 1
DOTM1 0000119313 11/20/2012 DENNISON LUBRICANTS 2 1
DOTM1 0000119313 11/20/2012 DENNISON LUBRICANTS 1 1
DOTM1 0000119314 11/20/2012 AQUARION WATER COMPANY OF CT 1 1
DOTM1 0000119315 11/20/2012 CONNECTICUT COMMUNITY PROVIDERS 2 1
DOTM1 0000119315 11/20/2012 CONNECTICUT COMMUNITY PROVIDERS 4 1
DOTM1 0000119315 11/20/2012 CONNECTICUT COMMUNITY PROVIDERS 3 1
DOTM1 0000119315 11/20/2012 CONNECTICUT COMMUNITY PROVIDERS 1 1
DOTM1 0000119316 11/20/2012 F W WEBB COMPANY 3 1
DOTM1 0000119316 11/20/2012 F W WEBB COMPANY 2 1
DOTM1 0000119316 11/20/2012 F W WEBB COMPANY 1 1
DOTM1 0000119316 11/20/2012 F W WEBB COMPANY 4 1
DOTM1 0000119317 2/13/2013 THE LEXINGTON GROUP INC 1 1
DOTM1 0000119317 2/13/2013 THE LEXINGTON GROUP INC 1 1
DOTM1 0000119320 2/13/2013 VIKING-CIVES USA 1 1
DOTM1 0000119321 2/13/2013 MARGO SUPPLIES LTD 5 1
DOTM1 0000119321 2/13/2013 MARGO SUPPLIES LTD 4 1
DOTM1 0000119321 2/13/2013 MARGO SUPPLIES LTD 1 1
DOTM1 0000119321 2/13/2013 MARGO SUPPLIES LTD 2 1
DOTM1 0000119321 2/13/2013 MARGO SUPPLIES LTD 3 1
DOTM1 0000119323 11/13/2012 STAPLES CONTRACT & COMMERCIAL INC 5 1
DOTM1 0000119323 11/13/2012 STAPLES CONTRACT & COMMERCIAL INC 4 1
DOTM1 0000119323 11/13/2012 STAPLES CONTRACT & COMMERCIAL INC 6 1
DOTM1 0000119323 11/13/2012 STAPLES CONTRACT & COMMERCIAL INC 1 1
DOTM1 0000119323 11/13/2012 STAPLES CONTRACT & COMMERCIAL INC 3 1
DOTM1 0000119323 11/13/2012 STAPLES CONTRACT & COMMERCIAL INC 2 1
DOTM1 0000119325 2/13/2013 ALL PHASE ELECTRIC SUPPLY COMPANY 1 1
DOTM1 0000119326 2/13/2013 DEPT OF TRANSPORTATION 1 1
DOTM1 0000119327 2/13/2013 B & B ROADWAY LLC 2 1
DOTM1 0000119327 2/13/2013 B & B ROADWAY LLC 4 1
DOTM1 0000119327 2/13/2013 B & B ROADWAY LLC 3 1
DOTM1 0000119327 2/13/2013 B & B ROADWAY LLC 1 1
DOTM1 0000119331 2/13/2013 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119332 2/13/2013 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119333 2/13/2013 SUBURBAN STATIONERS INC 2 1
DOTM1 0000119333 2/13/2013 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119333 2/13/2013 SUBURBAN STATIONERS INC 3 1
DOTM1 0000119333 2/13/2013 SUBURBAN STATIONERS INC 4 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 6 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 8 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 7 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 5 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 4 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 11 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 9 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 3 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 10 1
DOTM1 0000119334 2/13/2013 GRANITE GROUP INDUSTRIAL SUPPLY 12 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 1 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 1 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 1 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119339 2/13/2013 C & C HYDRAULICS INC 2 1
DOTM1 0000119342 2/13/2013 NORTHLAND INDUSTRIAL TRUCK CO 1 1
DOTM1 0000119342 2/13/2013 NORTHLAND INDUSTRIAL TRUCK CO 2 1
DOTM1 0000119342 2/13/2013 NORTHLAND INDUSTRIAL TRUCK CO 5 1
DOTM1 0000119342 2/13/2013 NORTHLAND INDUSTRIAL TRUCK CO 3 1
DOTM1 0000119342 2/13/2013 NORTHLAND INDUSTRIAL TRUCK CO 4 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 4 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 9 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 8 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 3 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 10 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 6 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 1 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 2 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 7 1
DOTM1 0000119343 2/13/2013 STAPLES CONTRACT & COMMERCIAL INC 5 1
DOTM1 0000119345 2/13/2013 DENNISON LUBRICANTS 1 1
DOTM1 0000119346 2/14/2013 NORMAN R BENEDICT ASSOC INC 1 1
DOTM1 0000119347 2/14/2013 JOHN LO MONTE REAL ESTATE AP 1 1
DOTM1 0000119348 2/14/2013 ALL WASTE INC 1 1
DOTM1 0000119349 2/14/2013 GLOBAL PAYMENTS DIRECT INC 1 1
DOTM1 0000119351 2/14/2013 NORTHEAST PASSENGER TRANS ASSOC 1 1
DOTM1 0000119353 2/14/2013 25 VAN ZANT STREET CONDOMINIUM INC 1 1
DOTM1 0000119354 2/14/2013 J & S RADIO SALES 1 1
DOTM1 0000119355 2/14/2013 MISTERSCAPES LLC 1 1
DOTM1 0000119355 2/14/2013 MISTERSCAPES LLC 2 1
DOTM1 0000119359 2/15/2013 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119360 2/15/2013 SUBURBAN STATIONERS INC 2 1
DOTM1 0000119360 2/15/2013 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 8 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 7 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 9 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 2 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 6 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 5 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 4 1
DOTM1 0000119361 2/15/2013 SUBURBAN STATIONERS INC 3 1
DOTM1 0000119362 2/15/2013 SUBURBAN STATIONERS INC 5 1
DOTM1 0000119362 2/15/2013 SUBURBAN STATIONERS INC 3 1
DOTM1 0000119362 2/15/2013 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119362 2/15/2013 SUBURBAN STATIONERS INC 4 1
DOTM1 0000119362 2/15/2013 SUBURBAN STATIONERS INC 7 1
DOTM1 0000119362 2/15/2013 SUBURBAN STATIONERS INC 6 1
DOTM1 0000119362 2/15/2013 SUBURBAN STATIONERS INC 2 1
DOTM1 0000119363 2/15/2013 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119364 2/15/2013 SUBURBAN STATIONERS INC 1 1
DOTM1 0000119364 2/15/2013 SUBURBAN STATIONERS INC 2 1
DOTM1 0000119364 2/15/2013 SUBURBAN STATIONERS INC 4 1
DOTM1 0000119364 2/15/2013 SUBURBAN STATIONERS INC 3 1
DOTM1 0000119364 2/15/2013 SUBURBAN STATIONERS INC 6 1
DOTM1 0000119364 2/15/2013 SUBURBAN STATIONERS INC 5 1
DOTM1 0000119365 2/15/2013 HARTFORD LUMBER COMPANY 1 1
DOTM1 0000119366 2/15/2013 SHIPMANS FIRE EQUIP CO INC 1 1
DOTM1 0000119367 2/15/2013 HOLLISTON SAND COMPANY INC 1 1
DOTM1 0000119368 2/15/2013 CANNON INSTR CO 1 1
DOTM1 0000119369 1/15/2013 ALAN SYLVESTRE 1 1
DOTM1 0000119370 2/15/2013 DEPT OF PUBLIC SAFETY 1 1
DOTM1 0000119375 1/15/2013 GRAINGER INDUSTRIAL SUPPLY 1 1
DOTM1 0000119376 1/15/2013 A & A OFFICE SYSTEMS INC 2 1
DOTM1 0000119376 2/15/2013 A & A OFFICE SYSTEMS INC 1 1
DOTM1 0000119377 1/15/2013 J & S RADIO SALES 1 1
DOTM1 0000119377 1/15/2013 J & S RADIO SALES 2 1
DOTM1 0000119381 2/15/2013 SAS INSTITUTE INC 6 1
DOTM1 0000119381 2/15/2013 SAS INSTITUTE INC 3 1
DOTM1 0000119381 2/15/2013 SAS INSTITUTE INC 4 1
DOTM1 0000119381 2/15/2013 SAS INSTITUTE INC 1 1
DOTM1 0000119381 2/15/2013 SAS INSTITUTE INC 2 1
DOTM1 0000119381 2/15/2013 SAS INSTITUTE INC 5 1
DOTM1 0000119383 2/15/2013 EMC CORPORATION 1 1
DOTM1 0000119384 2/15/2013 WATER & WASTE EQUIP INC 1 1
DOTM1 0000119385 1/19/2013 CITY OF GROTON 1 1
DOTM1 0000119386 1/19/2013 TOWN OF CHESHIRE 1 1
DOTM1 0000119387 11/16/2012 FLEETPRIDE INC 1 1
DOTM1 0000119388 1/19/2013 EPLUS TECHNOLOGY INC 6 1
DOTM1 0000119388 1/19/2013 EPLUS TECHNOLOGY INC 4 1
DOTM1 0000119388 1/19/2013 EPLUS TECHNOLOGY INC 7 1
DOTM1 0000119388 1/19/2013 EPLUS TECHNOLOGY INC 1 1
DOTM1 0000119388 1/19/2013 EPLUS TECHNOLOGY INC 2 1
DOTM1 0000119388 1/19/2013 EPLUS TECHNOLOGY INC 3 1
DOTM1 0000119388 1/19/2013 EPLUS TECHNOLOGY INC 5 1
DOTM1 0000119392 2/21/2013 PULLMAN & COMLEY LLC 1 1
PO Amount Voucher Amount Voucher Fund Account SID Due Date Acctg Date
38.94 38.94 0000559598 12001 53015 10020 2/11/2013 2/19/2013
30.51 30.51 0000559598 12001 53015 10020 2/11/2013 2/19/2013
568.32 568.32 0000559050 12001 53015 10020 2/12/2013 2/15/2013
128.90 128.90 0000559050 12001 53015 10020 2/12/2013 2/15/2013
12.60 - 12001 53015 10020 2/6/2013
7.80 - 12001 53015 10020 2/6/2013
- - 12001 53015 10020 2/6/2013
88.15 - 12001 53015 10020 2/6/2013
32.50 - 12001 53015 10020 2/6/2013
776.38 776.38 0000559010 12001 53015 10020 2/7/2013 2/14/2013
1,022.34 - 12001 53015 10020 2/11/2013
26.35 26.35 0000560369 12001 53015 10020 2/7/2013 2/21/2013
92.92 - 12001 53015 10020 2/5/2013
154.98 - 12001 53015 10020 2/5/2013
53.90 53.90 0000560153 12001 54100 10020 2/6/2013 2/20/2013
1,166.40 1,166.40 0000558405 12001 53015 10020 2/1/2013 2/13/2013
670.26 670.26 0000559795 12001 53015 10020 2/8/2013 2/19/2013
518.76 518.76 0000560519 12001 54070 10020 2/5/2013 2/21/2013
162.24 162.24 0000560917 12001 53015 10020 2/21/2013 2/22/2013
1,072.50 1,072.50 0000560787 12001 53012 10020 1/31/2013 2/21/2013
276.86 276.86 0000560787 12001 53015 10020 1/31/2013 2/21/2013
325.41 325.41 0000558246 12001 51580 10020 1/31/2013 2/7/2013
5,858.48 - 12001 53015 10020 2/17/2013
162.20 - 12001 53015 10020 2/17/2013
16.56 16.56 0000559788 21009 54070 40001 2/1/2013 2/19/2013
19.44 19.44 0000559788 21009 54070 40001 2/1/2013 2/19/2013
1,733.28 1,733.28 0000560130 12001 53015 10020 2/9/2013 2/20/2013
3,031.60 3,031.60 0000560479 12001 53015 10020 2/9/2013 2/21/2013
228.28 228.28 0000560479 12001 53015 10020 2/7/2013 2/21/2013
52.48 52.48 0000559004 12062 55050 20559 2/7/2013 2/14/2013
3,250.00 - 13033 55850 40001 2/11/2013
3,900.00 - 13033 55850 40001 2/11/2013
3,250.00 3,250.00 0000559611 13033 55850 40001 2/11/2013 2/19/2013
3,900.00 3,900.00 0000559611 13033 55850 40001 2/11/2013 2/19/2013
530.40 - 12001 53402 10020 2/8/2013
55.84 - 12001 53402 10020 2/8/2013
55.84 - 12001 53402 10020 2/8/2013
45.84 - 12001 53402 10020 2/8/2013
23.88 - 12001 53402 10020 2/8/2013
22.10 - 12001 53402 10020 2/8/2013
19.88 - 12001 53402 10020 2/8/2013
24.36 - 12001 53402 10020 2/8/2013
26.06 - 12001 53402 10020 2/8/2013
139.05 - 12001 53402 10020 2/8/2013
35.21 - 12001 53402 10020 2/8/2013
49.19 - 12001 53402 10020 2/8/2013
23.87 - 12001 53402 10020 2/8/2013
68.28 - 12001 53402 10020 2/8/2013
42.98 - 12001 53402 10020 2/8/2013
17.68 - 12001 53402 10020 2/8/2013
13.77 - 12001 53402 10020 2/8/2013
 137.90 - 12001 53402 10020 2/8/2013
443.64 443.64 0000559754 12001 54071 10020 2/1/2013 2/19/2013
52.80 52.80 0000559260 12001 53015 10020 2/11/2013 2/15/2013
44.40 44.40 0000559260 12001 54070 10020 2/11/2013 2/15/2013
200.08 200.08 0000559260 12001 53015 10020 2/11/2013 2/15/2013
770.80 770.80 0000559260 12001 53015 10020 2/11/2013 2/15/2013
142.00 142.00 0000559260 12001 53015 10020 2/11/2013 2/15/2013
768.00 768.00 0000559254 12001 53406 10020 2/11/2013 2/15/2013
32.16 32.16 0000559254 12001 53406 10020 2/11/2013 2/15/2013
64.00 64.00 0000559254 12001 53406 10020 2/11/2013 2/15/2013
287.50 287.50 0000559254 12001 53406 10020 2/11/2013 2/15/2013
385.92 385.92 0000559254 12001 53015 10020 2/11/2013 2/15/2013
35.22 35.22 0000559254 12001 53015 10020 2/11/2013 2/15/2013
1,072.00 1,072.00 0000559254 12001 54120 10020 2/11/2013 2/15/2013
181.32 181.32 0000559600 12001 53015 10020 2/6/2013 2/19/2013
19.74 19.74 0000559600 12001 53015 10020 2/6/2013 2/19/2013
90.40 - 12001 53015 10020 2/7/2013
56.90 - 12001 53015 10020 2/7/2013
98.15 98.15 0000560808 12001 53402 10020 2/6/2013 2/22/2013
116.00 116.00 0000559819 12001 53015 10020 2/7/2013 2/19/2013
54.33 54.33 0000560112 12001 53406 10020 2/5/2013 2/20/2013
675.00 - 12001 53401 10020 2/7/2013
500.00 - 12001 53401 10020 2/7/2013
36.00 36.00 0000560172 12001 54060 10020 2/5/2013 2/20/2013
9,981.33 9,981.33 0000560951 12001 53015 10020 2/5/2013 2/22/2013
471.25 471.25 0000560955 12001 53015 10020 2/6/2013 2/22/2013
131.90 131.90 0000560955 12001 53012 10020 2/6/2013 2/22/2013
1,130.34 1,130.34 0000560955 12001 53015 10020 2/6/2013 2/22/2013
39,150.00 39,150.00 0000558725 12001 53401 10020 2/11/2013 2/14/2013
59.16 59.16 0000559750 12001 53402 10020 2/11/2013 2/19/2013
40.32 40.32 0000559750 12001 53402 10020 2/11/2013 2/19/2013
183.04 183.04 0000559751 12001 53402 10020 2/13/2013 2/19/2013
304.72 304.72 0000559751 12001 53402 10020 2/13/2013 2/19/2013
27.48 27.48 0000559751 12001 53402 10020 2/13/2013 2/19/2013
321.20 321.20 0000560735 12001 53402 10020 2/13/2013 2/21/2013
2,856.00 2,856.00 0000559789 12001 53015 10020 2/7/2013 2/19/2013
118.00 118.00 0000559789 12001 53015 10020 2/7/2013 2/19/2013
55.17 - 12001 54100 10020 2/14/2013
976.30 976.30 0000559806 12001 53015 10020 2/7/2013 2/19/2013
68,883.36 68,883.36 0000558916 12001 53401 10020 2/11/2013 2/14/2013
136,001.60 19,488.00 0000558913 12001 53401 10020 2/11/2013 2/14/2013
136,001.60 25,370.24 0000558914 12001 53401 10020 2/11/2013 2/14/2013
136,001.60 30,134.72 0000560068 12001 53401 10020 2/11/2013 2/20/2013
136,001.60 61,008.64 0000558916 12001 53401 10020 2/11/2013 2/14/2013
79,119.32 5,880.00 0000558905 12001 53401 10020 2/11/2013 2/14/2013
79,119.32 8,820.00 0000558910 12001 53401 10020 2/11/2013 2/14/2013
79,119.32 12,568.50 0000558907 12001 53401 10020 2/11/2013 2/14/2013
79,119.32 25,382.00 0000558912 12001 53401 10020 2/11/2013 2/14/2013
79,119.32 26,468.82 0000558909 12001 53401 10020 2/11/2013 2/14/2013
77,235.76 2,597.00 0000559783 12001 53401 10020 2/11/2013 2/19/2013
77,235.76 74,638.76 0000559782 12001 53401 10020 2/11/2013 2/19/2013
39.38 39.38 0000559747 12001 53402 10020 2/12/2013 2/19/2013
22.80 - 12001 53402 10020 2/11/2013
 370.32 370.32 0000559314 12001 53015 10020 2/15/2013 2/15/2013
68.96 68.96 0000559314 12001 53015 10020 2/15/2013 2/15/2013
133.54 133.54 0000559313 12001 53013 10020 2/11/2013 2/15/2013
52.85 52.85 0000559313 12001 53013 10020 2/11/2013 2/15/2013
152.50 152.50 0000559309 12001 53015 10020 2/12/2013 2/15/2013
142.31 142.31 0000560793 12001 53015 10020 2/13/2013 2/22/2013
1,889.91 1,889.91 0000560793 12001 53015 10020 2/13/2013 2/22/2013
1,750.00 1,750.00 0000558891 13033 55470 40001 2/13/2013 2/14/2013
75.60 - 13033 54060 10020 1/31/2013
75.60 - 13033 54060 10020 1/31/2013
75.60 - 13033 54060 10020 1/31/2013
138.24 - 13033 54060 10020 1/31/2013
18.12 18.12 0000560527 13033 53402 10020 2/13/2013 2/21/2013
18.24 18.24 0000560527 13033 53402 10020 2/13/2013 2/21/2013
29.52 29.52 0000560527 13033 53402 10020 2/13/2013 2/21/2013
114.84 114.84 0000560527 13033 53402 10020 2/13/2013 2/21/2013
10,132.50 5,066.25 0000558671 13033 51200 10020 2/14/2013 2/13/2013
10,132.50 5,066.25 0000558672 13033 51200 10020 2/14/2013 2/13/2013
1,124.61 - 21009 53406 10020 2/9/2013
73.50 - 21009 54070 10020 2/1/2013
59.50 - 21009 54070 10020 2/1/2013
315.00 - 21009 54070 10020 2/1/2013
315.00 - 21009 54070 10020 2/1/2013
90.00 - 21009 54070 10020 2/1/2013
3.80 3.80 0000560801 21009 54060 10020 2/5/2013 2/22/2013
3.80 3.80 0000560801 21009 54060 10020 2/5/2013 2/22/2013
3.80 3.80 0000560801 21009 54060 10020 2/5/2013 2/22/2013
36.92 36.92 0000560801 21009 54060 10020 2/5/2013 2/22/2013
19.56 19.56 0000560801 21009 54060 10020 2/5/2013 2/22/2013
11.36 11.36 0000560801 21009 54060 10020 2/5/2013 2/22/2013
636.00 - 21009 53402 10020 2/13/2013
250.00 250.00 0000558887 12062 51620 22086 2/7/2013 2/14/2013
1,300.00 - 13033 52541 40001 2/7/2013
40.00 - 13033 52541 40001 2/7/2013
196.00 - 13033 52541 40001 2/7/2013
1,200.00 - 13033 52541 40001 2/7/2013
203.70 - 21009 53402 10020 2/8/2013
69.88 - 21009 53402 10020 2/11/2013
10.80 10.80 0000560176 21009 54060 10020 2/14/2013 2/20/2013
10.38 10.38 0000560176 21009 54060 10020 2/14/2013 2/20/2013
5.74 5.74 0000560176 21009 54060 10020 2/14/2013 2/20/2013
7.78 7.78 0000560176 21009 54060 10020 2/14/2013 2/20/2013
3.12 3.12 0000560742 21009 53402 10020 2/8/2013 2/21/2013
3.98 3.98 0000560742 21009 53402 10020 2/8/2013 2/21/2013
4.34 4.34 0000560742 21009 53402 10020 2/8/2013 2/21/2013
4.78 4.78 0000560742 21009 53402 10020 2/8/2013 2/21/2013
13.88 13.88 0000560742 21009 53402 10020 2/8/2013 2/21/2013
1.08 1.08 0000560742 21009 53402 10020 2/8/2013 2/21/2013
7.44 7.44 0000560742 21009 53402 10020 2/8/2013 2/21/2013
6.28 6.28 0000560742 21009 53402 10020 2/8/2013 2/21/2013
7.08 7.08 0000560742 21009 53402 10020 2/8/2013 2/21/2013
8.16 8.16 0000560742 21009 53402 10020 2/8/2013 2/21/2013
1,485.00 495.00 0000560058 21009 53015 10020 2/13/2013 2/20/2013
 1,485.00 495.00 0000560062 21009 53015 10020 2/13/2013 2/20/2013
1,485.00 495.00 0000560067 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560072 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560073 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560077 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560079 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560083 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560085 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560086 21009 53015 10020 2/13/2013 2/20/2013
4,200.00 525.00 0000560088 21009 53015 10020 2/13/2013 2/20/2013
495.00 - 21009 53402 10020 2/13/2013
265.00 - 21009 53402 10020 2/13/2013
50.00 - 21009 53402 10020 2/13/2013
30.00 - 21009 53402 10020 2/13/2013
100.00 - 21009 53402 10020 2/13/2013
20.28 20.28 0000560152 12001 54060 10020 2/14/2013 2/20/2013
13.78 13.78 0000560152 12001 54060 10020 2/14/2013 2/20/2013
11.04 11.04 0000560152 12001 54060 10020 2/14/2013 2/20/2013
3.96 3.96 0000560152 12001 54060 10020 2/14/2013 2/20/2013
3.00 3.00 0000560152 12001 54060 10020 2/14/2013 2/20/2013
1.38 1.38 0000560152 12001 54060 10020 2/14/2013 2/20/2013
2.21 2.21 0000560152 12001 54060 10020 2/14/2013 2/20/2013
8.45 8.45 0000560152 12001 54060 10020 2/14/2013 2/20/2013
20.60 20.60 0000560152 12001 54060 10020 2/14/2013 2/20/2013
0.17 0.17 0000560152 12001 54060 10020 2/14/2013 2/20/2013
4,389.00 - 12001 53015 10020 2/15/2013
1,120.00 1,120.00 0000559533 13033 51190 12175 2/14/2013 2/15/2013
700.00 700.00 0000559535 12062 51190 22086 2/14/2013 2/15/2013
285.00 285.00 0000559226 13033 53450 10020 2/28/2013 2/15/2013
57.84 57.84 0000559755 13033 53038 10020 2/14/2013 2/19/2013
175.00 175.00 0000560207 13033 51780 10020 2/14/2013 2/20/2013
139,386.00 139,386.00 0000559206 13033 55470 40001 2/14/2013 2/15/2013
474.30 474.30 0000560940 13033 54060 10020 2/7/2013 2/22/2013
4,125.00 4,125.00 0000559836 13033 53401 10020 2/14/2013 2/19/2013
2,750.00 2,750.00 0000559836 13033 53401 10020 2/14/2013 2/19/2013
37.62 37.62 0000560175 12062 54060 10020 2/12/2013 2/20/2013
11.80 11.80 0000560254 12062 54060 10020 2/16/2013 2/20/2013
7.02 7.02 0000560254 12062 54060 10020 2/16/2013 2/20/2013
5.42 5.42 0000560179 12062 54060 10020 2/13/2013 2/20/2013
5.42 5.42 0000560179 12062 54060 10020 2/13/2013 2/20/2013
5.42 5.42 0000560179 12062 54060 10020 2/13/2013 2/20/2013
11.90 11.90 0000560179 12062 54060 10020 2/13/2013 2/20/2013
21.12 21.12 0000560179 12062 54060 10020 2/13/2013 2/20/2013
2.16 2.16 0000560179 12062 54060 10020 2/13/2013 2/20/2013
2.16 2.16 0000560179 12062 54060 10020 2/13/2013 2/20/2013
14.54 14.54 0000560179 12062 54060 10020 2/13/2013 2/20/2013
0.96 0.96 0000560179 12062 54060 10020 2/13/2013 2/20/2013
84.91 84.91 0000560847 12062 54060 10020 2/28/2013 2/22/2013
74.07 74.07 0000560852 12062 54060 10020 2/28/2013 2/22/2013
15.97 15.97 0000560847 12062 54060 10020 2/28/2013 2/22/2013
79.49 79.49 0000560852 12062 54060 10020 2/28/2013 2/22/2013
3.25 3.25 0000560847 12062 54060 10020 2/28/2013 2/22/2013
16.56 16.56 0000560847 12062 54060 10020 2/28/2013 2/22/2013
 7.20 7.20 0000560847 12062 54060 10020 2/28/2013 2/22/2013
60.30 60.30 0000560237 12062 54060 10020 2/13/2013 2/20/2013
123.96 123.96 0000560182 12062 54060 10020 2/15/2013 2/20/2013
72.34 72.34 0000560182 12062 54060 10020 2/15/2013 2/20/2013
193.48 193.48 0000560182 12062 54060 10020 2/15/2013 2/20/2013
56.82 56.82 0000560182 12062 54060 10020 2/15/2013 2/20/2013
32.40 32.40 0000560182 12062 54060 10020 2/15/2013 2/20/2013
3.19 3.19 0000560182 12062 54060 10020 2/15/2013 2/20/2013
172.80 172.80 0000560746 12062 52541 10020 2/12/2013 2/21/2013
264.95 - 12062 52541 10020 2/11/2013
3,784.56 3,784.56 0000560687 12062 54074 10020 2/13/2013 2/21/2013
- - 12062 51982 10020 2/13/2013
76.23 76.23 0000560202 12062 54770 12175 2/15/2013 2/20/2013
2,739,843.00 2,739,843.00 0000559804 21009 51970 40001 2/15/2013 2/19/2013
21.64 - 13033 54070 10020 2/17/2013
336.16 - 13033 54060 10020 2/15/2013
336.16 - 13033 54060 10020 2/15/2013
296.40 296.40 0000559784 21009 54120 40001 1/11/2013 2/19/2013
503.50 503.50 0000559784 21009 54120 40001 1/11/2013 2/19/2013
910.00 600.00 0000560236 13033 53755 12175 2/5/2013 2/20/2013
830.00 710.00 0000560236 13033 53755 12175 2/5/2013 2/20/2013
830.00 635.00 0000560236 13033 53755 12175 2/5/2013 2/20/2013
1,540.00 1,540.00 0000560236 13033 53755 12175 2/5/2013 2/20/2013
830.00 415.00 0000560236 13033 53755 12175 2/5/2013 2/20/2013
830.00 415.00 0000560236 13033 53755 12175 2/5/2013 2/20/2013
222.00 - 13033 53920 10020 2/15/2013
5,000.00 - 13033 53402 10020 2/15/2013
647.78 647.78 0000559771 12062 55050 22086 2/19/2013 2/19/2013
2,804.40 2,804.40 0000559798 12062 55050 22086 2/19/2013 2/19/2013
306.72 306.72 0000560156 12062 53015 10020 2/20/2013 2/20/2013
184.80 - 12062 53920 10020 2/19/2013
56.94 - 12062 53920 10020 2/19/2013
135.50 - 12062 53920 10020 2/19/2013
3,083.93 - 12062 53920 10020 2/19/2013
959.44 - 12062 53920 10020 2/19/2013
959.44 - 12062 53920 10020 2/19/2013
366.91 - 12062 53920 10020 2/19/2013
153,645.92 153,645.92 0000560794 21022 51230 40001 2/21/2013 2/22/2013
Acctg Date
 214 ct_core_hr_tl_sick_report Return to TOC
ID Empl Rcd# Name TRC Earn Code Quantity Rpt Dt
311587 0 Smith,Jacob SP SIC 2.000000 12/16/2010
645109 0 Johnson,Michael SFFNR SIC 8.000000 12/15/2010
645109 0 Johnson,Michael SFFNR SIC 8.000000 12/16/2010
835119 0 Williams,Joshua SFAM SIC 5.000000 12/15/2010
921565 0 Jones,Matthew SFNRL SIC 8.000000 12/16/2010
904174 0 Brown,Daniel SP SIC 4.000000 12/16/2010
108501 0 Davis,Christopher SFAM SIC 3.500000 12/15/2010
806984 0 Miller,Andrew SICK SIC 8.000000 12/16/2010
605544 0 Wilson,Ethan SFFNR SIC 8.000000 12/15/2010
261528 0 Moore,Joseph SICK SIC 8.000000 12/15/2010
261528 0 Moore,Joseph SICK SIC 8.000000 12/16/2010
682726 0 Taylor,William SP SIC 1.000000 12/15/2010
682726 0 Taylor,William SP SIC 1.500000 12/16/2010
268234 0 Anderson,Anthony SP SIC 1.500000 12/15/2010
537900 0 Thomas,David SP SIC 2.000000 12/15/2010
935382 0 Jackson,Alexander SP SIC 3.500000 12/15/2010
602526 0 White,Nicholas SP SIC 2.000000 12/15/2010
624084 0 Harris,Ryan SP SIC 1.250000 12/16/2010
341458 0 Martin,Tyler SICK SIC 8.000000 12/16/2010
674630 0 Thompson,James SP SIC 2.750000 12/16/2010
674630 0 Thompson,James SFAM SIC 1.000000 12/16/2010
752850 0 Garcia,John SFAM SIC 1.250000 12/15/2010
951321 1 Martinez,Jonathan SP SIC 8.750000 12/17/2010
311587 0 Smith,Jacob SFNRL SIC 4.000000 12/17/2010
140990 0 Robinson,Noah SP SIC 2.000000 12/28/2010
883669 0 Clark,Brandon SICK SIC 4.750000 12/22/2010
733760 0 Rodriguez,Christian SP SIC 3.500000 12/20/2010
474941 0 Lewis,Dylan SP SIC 2.500000 12/22/2010
474941 0 Lewis,Dylan SP SIC 1.500000 12/28/2010
615307 0 Lee,Samuel SP SIC 4.000000 12/17/2010
144775 0 Walker,Benjamin SP SIC 2.000000 12/28/2010
054857 0 Hall,Zachary SP SIC 1.000000 12/21/2010
969490 0 Allen,Nathan SFAM SIC 3.000000 12/21/2010
969490 0 Allen,Nathan SICK SIC 8.000000 12/22/2010
579919 0 Young,Logan SICK SIC 2.000000 12/22/2010
599675 0 Hernandez,Justin SP SIC 2.000000 12/22/2010
625135 0 King,Gabriel SP SIC 1.000000 12/28/2010
664825 0 Wright,Jose SICK SIC 8.000000 12/30/2010
664825 0 Wright,Jose SICK SIC 6.000000 12/29/2010
459949 0 Lopez,Austin SP SIC 2.000000 12/17/2010
375792 0 Hill,Kevin SFNRL SIC 4.000000 12/20/2010
459949 0 Lopez,Austin SFAM SIC 8.000000 1/3/2011
459949 0 Lopez,Austin SFAM SIC 4.000000 1/4/2011
869277 0 Scott,Elijah SICK SIC 8.000000 12/29/2010
389844 0 Green,Caleb SICK SIC 2.000000 12/22/2010
389844 0 Green,Caleb SICK SIC 8.000000 12/23/2010
873164 0 Adams,Robert SICK SIC 3.000000 12/28/2010
935382 0 Jackson,Alexander SICK SIC 8.000000 12/30/2010
935382 0 Jackson,Alexander SICK SIC 8.000000 12/29/2010
555166 0 Baker,Thomas SICK SIC 8.000000 12/22/2010
555166 0 Baker,Thomas SICK SIC 6.250000 12/21/2010
555166 0 Baker,Thomas SFNRL SIC 4.000000 12/17/2010
503495 0 Gonzalez,Jordan SP SIC 2.000000 12/20/2010
503495 0 Gonzalez,Jordan SP SIC 8.000000 12/22/2010
935382 0 Jackson,Alexander SICK SIC 8.000000 12/28/2010
035938 0 Nelson,Cameron SP SIC 2.000000 12/17/2010
162126 0 Carter,Jack SP SIC 3.000000 12/20/2010
453743 0 Mitchell,Hunter SFAM SIC 3.250000 12/20/2010
674630 0 Thompson,James SICK SIC 8.000000 12/20/2010
422727 0 Perez,Jackson SFNRL SIC 8.000000 12/21/2010
820836 0 Roberts,Angel SFNRL SIC 4.000000 12/17/2010
647912 0 Turner,Isaiah SP SIC 2.500000 12/17/2010
363618 0 Phillips,Evan SP SIC 1.000000 12/21/2010
309284 0 Campbell,Isaac SP SIC 8.000000 12/20/2010
694606 0 Parker,Mason SP SIC 0.750000 12/20/2010
694606 0 Parker,Mason SP SIC 0.500000 12/29/2010
942722 0 Evans,Luke SP SIC 1.000000 12/21/2010
689783 0 Edwards,Jason SP SIC 3.000000 12/29/2010
572634 0 Collins,Gavin SFAM SIC 8.000000 12/17/2010
572634 0 Collins,Gavin SFFNR SIC 8.000000 12/20/2010
572634 0 Collins,Gavin SFFNR SIC 8.000000 12/21/2010
572634 0 Collins,Gavin SFFNR SIC 8.000000 12/22/2010
053568 0 Stewart,Jayden SICK SIC 8.000000 12/30/2010
341458 0 Martin,Tyler SICK SIC 8.000000 12/30/2010
645109 0 Johnson,Michael SICK SIC 4.000000 12/21/2010
645109 0 Johnson,Michael SICK SIC 8.000000 12/22/2010
645109 0 Johnson,Michael SICK SIC 8.000000 12/23/2010
309793 0 Sanchez,Aaron SFNRL SIC 2.000000 12/22/2010
689074 0 Morris,Connor SICK SIC 8.000000 12/28/2010
689074 0 Morris,Connor SICK SIC 8.000000 12/29/2010
689074 0 Morris,Connor SICK SIC 8.000000 12/30/2010
609303 1 Rogers,Aiden SICK SIC 8.000000 12/28/2010
185450 0 Reed,Aidan SICK SIC 4.000000 12/21/2010
525099 0 Cook,Kyle SICK SIC 8.000000 12/20/2010
217327 0 Morgan,Juan SICK SIC 8.000000 12/17/2010
585545 0 Bell,Charles SICK SIC 8.000000 12/28/2010
853351 0 Murphy,Luis SP SIC 2.000000 12/20/2010
853351 0 Murphy,Luis SP SIC 4.000000 12/17/2010
853351 0 Murphy,Luis SICK SIC 8.000000 12/21/2010
972886 0 Bailey,Adam SP SIC 1.000000 12/20/2010
934035 0 Rivera,Lucas SFAM SIC 4.000000 1/4/2011
459949 0 Lopez,Austin SFAM SIC 5.000000 1/4/2011
459949 0 Lopez,Austin SFAM SIC -4.000000 1/4/2011
459949 0 Lopez,Austin SFAM SIC 3.000000 1/5/2011
377203 0 Cooper,Brian SP SIC 1.000000 1/3/2011
728279 0 Richardson,Eric SICK SIC 7.000000 1/6/2011
642295 0 Cox,Adrian SFAM SIC 8.000000 1/7/2011
624084 0 Harris,Ryan SP SIC -1.250000 12/16/2010
624084 0 Harris,Ryan SP SIC 1.750000 12/16/2010
728279 0 Richardson,Eric SP SIC 2.000000 12/16/2010
140990 0 Robinson,Noah SP SIC 3.000000 12/16/2010
198333 1 Howard,Nathaniel SICK SIC 4.000000 12/16/2010
044371 0 Ward,Sean SICK SIC 3.000000 12/15/2010
044371 0 Ward,Sean SICK SIC 8.000000 12/16/2010
988116 0 Torres,Alex SICK SIC 7.000000 12/15/2010
500684 0 Peterson,Carlos SP SIC 1.000000 12/16/2010
429643 0 Gray,Bryan SICK SIC 8.000000 12/15/2010
429643 0 Gray,Bryan SP SIC 2.750000 12/16/2010
738503 0 Ramirez,Ian SP SIC 1.250000 12/16/2010
055381 0 James,Owen SP SIC 8.000000 12/15/2010
115195 0 Watson,Jesus SP SIC 1.500000 12/15/2010
545521 0 Brooks,Landon SICK SIC 2.250000 12/16/2010
775444 0 Kelly,Julian SP SIC 1.000000 12/16/2010
856465 0 Sanders,Chase SP SIC 6.000000 12/15/2010
555242 0 Price,Cole SP SIC 3.500000 12/16/2010
251999 0 Bennett,Diego SICK SIC 1.500000 12/16/2010
099193 0 Wood,Jeremiah SICK SIC 4.000000 12/15/2010
099193 0 Wood,Jeremiah SICK SIC 8.000000 12/16/2010
392062 0 Barnes,Steven SICK SIC 8.000000 12/16/2010
422727 0 Perez,Jackson SFNRL SIC 2.000000 12/16/2010
377203 0 Cooper,Brian SP SIC 1.000000 12/22/2010
654062 0 Ross,Sebastian SICK SIC 8.000000 12/21/2010
755355 0 Henderson,Xavier SICK SIC 8.000000 12/21/2010
555862 0 Coleman,Timothy SP SIC 2.000000 12/17/2010
338561 0 Jenkins,Carter SP SIC 1.000000 12/28/2010
226479 0 Perry,Wyatt SP SIC 1.000000 12/20/2010
226479 0 Perry,Wyatt SP SIC 2.000000 12/23/2010
500684 0 Peterson,Carlos SFNRL SIC 3.000000 12/20/2010
462639 0 Powell,Brayden SICK SIC 5.000000 12/29/2010
793716 0 Long,Blake SP SIC 1.000000 12/17/2010
301384 0 Patterson,Hayden SP SIC 4.000000 12/28/2010
113347 0 Hughes,Devin SP SIC 2.000000 12/17/2010
398541 0 Flores,Cody SICK SIC 8.000000 12/28/2010
288928 0 Washington,Richard SFAM SIC 6.000000 12/17/2010
775167 0 Butler,Seth SICK SIC 3.000000 12/20/2010
775167 0 Butler,Seth SICK SIC 3.000000 12/17/2010
775444 0 Kelly,Julian SICK SIC 8.000000 12/29/2010
775167 0 Butler,Seth SICK SIC 8.000000 12/21/2010
775167 0 Butler,Seth SICK SIC 3.000000 12/22/2010
775167 0 Butler,Seth SICK SIC 3.000000 12/28/2010
775167 0 Butler,Seth SICK SIC 3.000000 12/29/2010
130559 0 Simmons,Dominic SP SIC 2.000000 12/22/2010
437881 0 Foster,Jaden SP SIC 3.500000 12/20/2010
641295 0 Gonzales,Antonio SP SIC 3.000000 12/17/2010
371859 0 Bryant,Miguel SICK SIC 4.000000 12/21/2010
371859 0 Bryant,Miguel SICK SIC 2.000000 12/22/2010
245734 0 Alexander,Liam SICK SIC 8.000000 12/29/2010
569961 0 Russell,Patrick SP SIC 1.000000 1/3/2011
245734 0 Alexander,Liam SICK SIC 8.000000 12/28/2010
545521 0 Brooks,Landon SICK SIC 2.000000 12/28/2010
115195 0 Watson,Jesus SP SIC 0.500000 12/29/2010
798649 0 Griffin,Carson SP SIC 3.500000 12/17/2010
747126 0 Diaz,Jesse SFAM SIC 8.000000 12/28/2010
739647 0 Hayes,Tristan SP SIC 2.000000 12/29/2010
292456 0 Myers,Alejandro SFAM SIC 0.500000 12/22/2010
425584 0 Ford,Henry SP SIC 8.000000 12/28/2010
872321 0 Hamilton,Victor SP SIC 1.750000 12/22/2010
261528 0 Moore,Joseph SICK SIC 8.000000 12/17/2010
280348 0 Graham,Trevor SICK SIC 8.000000 12/21/2010
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/23/2010
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/28/2010
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/29/2010
515931 0 Sullivan,Bryce SICK SIC 8.000000 12/30/2010
170542 0 Wallace,Jake SICK SIC 8.000000 12/21/2010
170542 0 Wallace,Jake SICK SIC 4.000000 12/20/2010
099193 0 Wood,Jeremiah SICK SIC 6.750000 12/17/2010
682726 0 Taylor,William SP SIC 2.000000 12/29/2010
689074 0 Morris,Connor SICK SIC -8.000000 12/28/2010
689074 0 Morris,Connor SICK SIC 8.000000 12/28/2010
689074 0 Morris,Connor SICK SIC -8.000000 12/29/2010
689074 0 Morris,Connor SICK SIC 8.000000 12/29/2010
689074 0 Morris,Connor SICK SIC -8.000000 12/30/2010
689074 0 Morris,Connor SICK SIC 8.000000 12/30/2010
609303 1 Rogers,Aiden SICK SIC 8.000000 12/28/2010
609303 1 Rogers,Aiden SICK SIC -8.000000 12/28/2010
112940 0 Woods,Riley SICK SIC 8.000000 1/5/2011
112940 0 Woods,Riley SP SIC 3.500000 1/7/2011
389844 0 Green,Caleb SP SIC 1.750000 1/12/2011
389844 0 Green,Caleb SP SIC 2.000000 1/14/2011
389844 0 Green,Caleb SP SIC 2.000000 1/5/2011
112940 0 Woods,Riley SICK SIC 8.000000 1/3/2011
112940 0 Woods,Riley SICK SIC 8.000000 1/4/2011
402483 0 Cole,Colin SP SIC 1.000000 1/3/2011
625135 0 King,Gabriel SP SIC 8.000000 1/5/2011
005435 0 West,Jared SFAM SIC 2.500000 1/6/2011
798649 0 Griffin,Carson SFAM SIC 1.500000 1/6/2011
113347 0 Hughes,Devin SFAM SIC 1.500000 1/5/2011
596745 0 Jordan,Jeremy SICK SIC 8.000000 1/5/2011
596745 0 Jordan,Jeremy SP SIC 0.750000 1/13/2011
846953 0 Owens,Mark SICK SIC 3.000000 1/10/2011
138199 0 Reynolds,Caden SFAM SIC 8.000000 1/3/2011
138199 0 Reynolds,Caden SP SIC 1.000000 1/6/2011
138199 0 Reynolds,Caden SP SIC 0.750000 1/10/2011
747126 0 Diaz,Jesse SP SIC 2.000000 1/11/2011
375792 0 Hill,Kevin SP SIC 2.000000 1/7/2011
471981 0 Fisher,Garrett SP SIC 3.500000 1/10/2011
942722 0 Evans,Luke SICK SIC 8.000000 1/3/2011
942722 0 Evans,Luke SICK SIC 8.000000 1/4/2011
942722 0 Evans,Luke SICK SIC 8.000000 1/5/2011
942722 0 Evans,Luke SICK SIC 8.000000 1/6/2011
942722 0 Evans,Luke SICK SIC 8.000000 1/7/2011
544430 0 Ellis,Parker SICK SIC 1.500000 1/10/2011
904174 0 Brown,Daniel SP SIC 4.000000 1/4/2011
904174 0 Brown,Daniel SP SIC 4.000000 1/11/2011
268234 0 Anderson,Anthony SP SIC 1.500000 1/6/2011
066388 0 Harrison,Marcus SICK SIC 8.000000 1/7/2011
209328 0 Gibson,Vincent SP SIC 1.750000 1/3/2011
027178 0 Mcdonald,Kaleb SP SIC 8.000000 1/11/2011
129044 0 Cruz,Kaden SP SIC 1.000000 1/11/2011
560101 0 Marshall,Brady SP SIC 1.500000 1/6/2011
162126 0 Carter,Jack SP SIC 3.000000 1/6/2011
694606 0 Parker,Mason SP SIC 2.000000 1/4/2011
968003 0 Ortiz,Colton SP SIC 3.000000 1/12/2011
DAY
THURSDAY
WEDNESDAY
THURSDAY
WEDNESDAY
THURSDAY
THURSDAY
WEDNESDAY
THURSDAY
WEDNESDAY
WEDNESDAY
THURSDAY
WEDNESDAY
THURSDAY
WEDNESDAY
WEDNESDAY
WEDNESDAY
WEDNESDAY
THURSDAY
THURSDAY
THURSDAY
THURSDAY
WEDNESDAY
FRIDAY
FRIDAY
TUESDAY
WEDNESDAY
MONDAY
WEDNESDAY
TUESDAY
FRIDAY
TUESDAY
TUESDAY
TUESDAY
WEDNESDAY
WEDNESDAY
WEDNESDAY
TUESDAY
THURSDAY
WEDNESDAY
FRIDAY
MONDAY
MONDAY
TUESDAY
WEDNESDAY
WEDNESDAY
THURSDAY
TUESDAY
THURSDAY
WEDNESDAY
WEDNESDAY
TUESDAY
FRIDAY
MONDAY
WEDNESDAY
TUESDAY
FRIDAY
MONDAY
MONDAY
MONDAY
TUESDAY
FRIDAY
FRIDAY
TUESDAY
MONDAY
MONDAY
WEDNESDAY
TUESDAY
WEDNESDAY
FRIDAY
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
THURSDAY
TUESDAY
WEDNESDAY
THURSDAY
WEDNESDAY
TUESDAY
WEDNESDAY
THURSDAY
TUESDAY
TUESDAY
MONDAY
FRIDAY
TUESDAY
MONDAY
FRIDAY
TUESDAY
MONDAY
TUESDAY
TUESDAY
TUESDAY
WEDNESDAY
MONDAY
THURSDAY
FRIDAY
THURSDAY
THURSDAY
THURSDAY
THURSDAY
THURSDAY
WEDNESDAY
THURSDAY
WEDNESDAY
THURSDAY
WEDNESDAY
THURSDAY
THURSDAY
WEDNESDAY
WEDNESDAY
THURSDAY
THURSDAY
WEDNESDAY
THURSDAY
THURSDAY
WEDNESDAY
THURSDAY
THURSDAY
THURSDAY
WEDNESDAY
TUESDAY
TUESDAY
FRIDAY
TUESDAY
MONDAY
THURSDAY
MONDAY
WEDNESDAY
FRIDAY
TUESDAY
FRIDAY
TUESDAY
FRIDAY
MONDAY
FRIDAY
WEDNESDAY
TUESDAY
WEDNESDAY
TUESDAY
WEDNESDAY
WEDNESDAY
MONDAY
FRIDAY
TUESDAY
WEDNESDAY
WEDNESDAY
MONDAY
TUESDAY
TUESDAY
WEDNESDAY
FRIDAY
TUESDAY
WEDNESDAY
WEDNESDAY
TUESDAY
WEDNESDAY
FRIDAY
TUESDAY
THURSDAY
TUESDAY
WEDNESDAY
THURSDAY
TUESDAY
MONDAY
FRIDAY
WEDNESDAY
TUESDAY
TUESDAY
WEDNESDAY
WEDNESDAY
THURSDAY
THURSDAY
TUESDAY
TUESDAY
WEDNESDAY
FRIDAY
WEDNESDAY
FRIDAY
WEDNESDAY
MONDAY
TUESDAY
MONDAY
WEDNESDAY
THURSDAY
THURSDAY
WEDNESDAY
WEDNESDAY
THURSDAY
MONDAY
MONDAY
THURSDAY
MONDAY
TUESDAY
FRIDAY
MONDAY
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
MONDAY
TUESDAY
TUESDAY
THURSDAY
FRIDAY
MONDAY
TUESDAY
TUESDAY
THURSDAY
THURSDAY
TUESDAY
WEDNESDAY
 Return to TOC

The VLOOKUP function scans down the row headings at the side of a table to find a specified item. When it is found, it then
scans across to pick a cell entry.

=VLOOKUP(ItemToFind,RangeTo LookIn,ColumnToPickFrom,SortedOrUnsorted)
Example: =VLOOKUP(B19,E19:F66,2,FALSE)

B19 = Item to Find

E19:F66 = The Range to look in to find the item
2 = Once the item is found select the item in this column
FALSE = An exact match is required (Assumes unsorted, but the list may be sorted)

TRUE would indicate an exact match is not required (Assumes sorted, and the function will fail if the reference list is unsorte

Use VLOOKUP to match one item with another.

Character Show Character

Carlton Lassiter  Maddie Hayes 
Dale Cooper Sam Malone 
David Addison  David Addison 
Dexter Morgan  Adrian Monk
Dr. Elliot Reid  Jeff Greene 
Dr. Gregory House  Norm Peterson 
Edmund Blackadder  Matt Saracen 
Eric Cartman  Barney Stinson 
Fox Mulder  Bill McNeal 
George Costanza  Harry Solomon 
Gloria Pritchett  Kim Bauer 
Hank Hill  Gloria Pritchett 
Harold T. Stone Jack Bauer 
Harry Solomon  George Costanza 
Homer Simpson  Phil Dunphy 
Hurley Reyes  Lynette Scavo 
Jack Bauer  Hank Hill 
Jack Malone  Veronica Mars 
Jeff Greene  Walter White 
Jim Ignatowski Shawn Spencer 
John Locke  Bob Kelso
Kim Bauer  Monica Bing 
Liz Lemon  Harold T. Stone
Lorelai Gilmore  Carlton Lassiter 
Lynette Scavo  Eric Cartman 
Maddie Hayes  Mark Green
Matt Saracen  Red Forman 
Monica Bing  Phillip J. Fry 
Natalie Teeger  Robert Barone 
Niles Crane  Benjamin Linus 
Norm Peterson  Fox Mulder 
Phil Dunphy  Jack Malone 
Phillip J. Fry  John Locke 
Jim Ignatowski
Homer Simpson 
Edmund Blackadder 
Carlton Banks 
Dr. Elliot Reid 
Russ Geller
Dale Cooper
Natalie Teeger 
Dr. Gregory House 
Dexter Morgan 
Hurley Reyes 
Lorelai Gilmore 
Niles Crane 
Liz Lemon 
Sheldon Cooper 
a specified item. When it is found, it then

ction will fail if the reference list is unsorted)

Show Student Grade Letter Grade No. Grade

Moonlighting Russ Geller 98 0
Cheers Sheldon Cooper  79 60
Moonlighting Dexter Morgan  72 64
Monk Red Forman  93 67
Curb Your Enthusiasm Harold T. Stone 64 70
Cheers Shawn Spencer  92 74
Friday Night Lights Jim Ignatowski 70 77
How I Met Your Mother John Locke  91 80
NewsRadio Bill McNeal  96 84
3rd Rock from the Sun Adrian Monk 68 87
24 Lynette Scavo  51 90
Modern Family Robert Barone  94 94
24 Sam Malone  74 97
Seinfeld Homer Simpson  53
Modern Family Dr. Elliot Reid  89
Desperate Housewives Bob Kelso 55
King of the Hill Dr. Gregory House  79
Veronica Mars Dale Cooper 98
Breaking Bad Hurley Reyes  95
Psych Lorelai Gilmore  63
Scrubs Harry Solomon  57
Friends Hank Hill  91
Night Court Carlton Lassiter  95
Psych Barney Stinson  97
South Park Walter White  97
ER Matt Saracen  70
That '70s Show George Costanza  55
Futurama Jack Malone  89
Everybody Loves Raymond Carlton Banks  77
Lost Veronica Mars  90
The X Files Jack Bauer  79
Without A Trace Kim Bauer  84
Lost Jeff Greene  56
Taxi Norm Peterson  52
The Simpsons Eric Cartman  94
Blackadder Natalie Teeger  55
The Fresh Prince of Bel-Air David Addison  54
Scrubs
Friends
Twin Peaks
Monk
House, M.D.
Dexter
Lost
Gilmore Girls
Frasier
30 Rock
The Big Bang Theory
Letter Grade
F
D-
D
D+
C-
C
C+
B-
B
B+
A-
A
A+
Return to TOC

Contract Expire Dt Period FY Month Quarter

9/30/2013
7/31/2013
11/30/2013
9/30/2013
6/30/2014
3/31/2014
6/30/2014
5/31/2015
10/31/2013
5/31/2015
3/31/2014
7/31/2014
12/31/2013
7/31/2014
11/30/2015
3/31/2014
9/30/2017
6/30/2016
6/30/2015
8/31/2014
2/28/2015
8/31/2014
12/31/2015
12/31/2015
2/29/2016
3/31/2014
2/29/2016
7/31/2014
7/31/2014
11/30/2015
5/31/2015
1/31/2016
11/30/2013
11/30/2013
10/31/2013
4/30/2014
9/30/2013
11/30/2013
11/30/2013
3/31/2014
6/30/2014
9/30/2013
9/30/2014
12/31/2015
3/31/2014
6/30/2014
6/30/2018
10/31/2013
11/30/2013
4/2/2016
6/30/2014
7/31/2014
9/30/2017
3/31/2014
3/31/2014
8/31/2013
9/30/2017
2/29/2016
9/30/2017
12/31/2015
5/31/2015
5/31/2015
9/30/2013
9/30/2015
4/30/2016
4/30/2016
3/31/2014
10/31/2013
3/31/2015
11/30/2014
11/30/2014
6/30/2014
4/30/2014
5/31/2015
12/31/2015
11/30/2014
11/30/2014
3/31/2014
4/2/2016
8/31/2014
3/31/2014
9/30/2013
12/31/2013
3/31/2014
9/30/2017
1/4/2014
9/30/2017
3/31/2014
9/30/2015
10/31/2013
12/31/2016
8/31/2014
12/31/2013
4/2/2016
9/30/2013
9/30/2017
12/31/2013
12/31/2015
6/1/2016
3/31/2015
12/31/2015
9/30/2013
Return to TOC
CT Fiscal Conversion Federal Fiscal Conversion
Date Period Fiscal Year Month Fiscal Qtr Date Period
1/1/2003 7 2003 3 1/1/2003 4
2/1/2003 8 2003 3 2/1/2003 5
3/1/2003 9 2003 3 3/1/2003 6
4/1/2003 10 2003 4 4/1/2003 7
5/1/2003 11 2003 4 5/1/2003 8
6/1/2003 12 2003 4 6/1/2003 9
7/1/2003 1 2004 1 7/1/2003 10
8/1/2003 2 2004 1 8/1/2003 11
9/1/2003 3 2004 1 9/1/2003 12
10/1/2003 4 2004 2 10/1/2003 1
11/1/2003 5 2004 2 11/1/2003 2
12/1/2003 6 2004 2 12/1/2003 3
1/1/2004 7 2004 3 1/1/2004 4
2/1/2004 8 2004 3 2/1/2004 5
3/1/2004 9 2004 3 3/1/2004 6
4/1/2004 10 2004 4 4/1/2004 7
5/1/2004 11 2004 4 5/1/2004 8
6/1/2004 12 2004 4 6/1/2004 9
7/1/2004 1 2005 1 7/1/2004 10
8/1/2004 2 2005 1 8/1/2004 11
9/1/2004 3 2005 1 9/1/2004 12
10/1/2004 4 2005 2 10/1/2004 1
11/1/2004 5 2005 2 11/1/2004 2
12/1/2004 6 2005 2 12/1/2004 3
1/1/2005 7 2005 3 1/1/2005 4
2/1/2005 8 2005 3 2/1/2005 5
3/1/2005 9 2005 3 3/1/2005 6
4/1/2005 10 2005 4 4/1/2005 7
5/1/2005 11 2005 4 5/1/2005 8
6/1/2005 12 2005 4 6/1/2005 9
7/1/2005 1 2006 1 7/1/2005 10
8/1/2005 2 2006 1 8/1/2005 11
9/1/2005 3 2006 1 9/1/2005 12
10/1/2005 4 2006 2 10/1/2005 1
11/1/2005 5 2006 2 11/1/2005 2
12/1/2005 6 2006 2 12/1/2005 3
1/1/2006 7 2006 3 1/1/2006 4
2/1/2006 8 2006 3 2/1/2006 5
3/1/2006 9 2006 3 3/1/2006 6
4/1/2006 10 2006 4 4/1/2006 7
5/1/2006 11 2006 4 5/1/2006 8
6/1/2006 12 2006 4 6/1/2006 9
7/1/2006 1 2007 1 7/1/2006 10
8/1/2006 2 2007 1 8/1/2006 11
9/1/2006 3 2007 1 9/1/2006 12
10/1/2006 4 2007 2 10/1/2006 1
11/1/2006 5 2007 2 11/1/2006 2
12/1/2006 6 2007 2 12/1/2006 3
1/1/2007 7 2007 3 1/1/2007 4
2/1/2007 8 2007 3 2/1/2007 5
3/1/2007 9 2007 3 3/1/2007 6
4/1/2007 10 2007 4 4/1/2007 7
5/1/2007 11 2007 4 5/1/2007 8
6/1/2007 12 2007 4 6/1/2007 9
7/1/2007 1 2008 1 7/1/2007 10
8/1/2007 2 2008 1 8/1/2007 11
9/1/2007 3 2008 1 9/1/2007 12
10/1/2007 4 2008 2 10/1/2007 1
11/1/2007 5 2008 2 11/1/2007 2
12/1/2007 6 2008 2 12/1/2007 3
1/1/2008 7 2008 3 1/1/2008 4
2/1/2008 8 2008 3 2/1/2008 5
3/1/2008 9 2008 3 3/1/2008 6
4/1/2008 10 2008 4 4/1/2008 7
5/1/2008 11 2008 4 5/1/2008 8
6/1/2008 12 2008 4 6/1/2008 9
7/1/2008 1 2009 1 7/1/2008 10
8/1/2008 2 2009 1 8/1/2008 11
9/1/2008 3 2009 1 9/1/2008 12
10/1/2008 4 2009 2 10/1/2008 1
11/1/2008 5 2009 2 11/1/2008 2
12/1/2008 6 2009 2 12/1/2008 3
1/1/2009 7 2009 3 1/1/2009 4
2/1/2009 8 2009 3 2/1/2009 5
3/1/2009 9 2009 3 3/1/2009 6
4/1/2009 10 2009 4 4/1/2009 7
5/1/2009 11 2009 4 5/1/2009 8
6/1/2009 12 2009 4 6/1/2009 9
7/1/2009 1 2010 1 7/1/2009 10
8/1/2009 2 2010 1 8/1/2009 11
9/1/2009 3 2010 1 9/1/2009 12
10/1/2009 4 2010 2 10/1/2009 1
11/1/2009 5 2010 2 11/1/2009 2
12/1/2009 6 2010 2 12/1/2009 3
1/1/2010 7 2010 3 1/1/2010 4
2/1/2010 8 2010 3 2/1/2010 5
3/1/2010 9 2010 3 3/1/2010 6
4/1/2010 10 2010 4 4/1/2010 7
5/1/2010 11 2010 4 5/1/2010 8
6/1/2010 12 2010 4 6/1/2010 9
7/1/2010 1 2011 1 7/1/2010 10
8/1/2010 2 2011 1 8/1/2010 11
9/1/2010 3 2011 1 9/1/2010 12
10/1/2010 4 2011 2 10/1/2010 1
11/1/2010 5 2011 2 11/1/2010 2
12/1/2010 6 2011 2 12/1/2010 3
1/1/2011 7 2011 3 1/1/2011 4
 2/1/2011 8 2011 3 2/1/2011 5
3/1/2011 9 2011 3 3/1/2011 6
4/1/2011 10 2011 4 4/1/2011 7
5/1/2011 11 2011 4 5/1/2011 8
6/1/2011 12 2011 4 6/1/2011 9
7/1/2011 1 2012 1 7/1/2011 10
8/1/2011 2 2012 1 8/1/2011 11
9/1/2011 3 2012 1 9/1/2011 12
10/1/2011 4 2012 2 10/1/2011 1
11/1/2011 5 2012 2 11/1/2011 2
12/1/2011 6 2012 2 12/1/2011 3
1/1/2012 7 2012 3 1/1/2012 4
2/1/2012 8 2012 3 2/1/2012 5
3/1/2012 9 2012 3 3/1/2012 6
4/1/2012 10 2012 4 4/1/2012 7
5/1/2012 11 2012 4 5/1/2012 8
6/1/2012 12 2012 4 6/1/2012 9
7/1/2012 1 2013 1 7/1/2012 10
8/1/2012 2 2013 1 8/1/2012 11
9/1/2012 3 2013 1 9/1/2012 12
10/1/2012 4 2013 2 10/1/2012 1
11/1/2012 5 2013 2 11/1/2012 2
12/1/2012 6 2013 2 12/1/2012 3
1/1/2013 7 2013 3 1/1/2013 4
2/1/2013 8 2013 3 2/1/2013 5
3/1/2013 9 2013 3 3/1/2013 6
4/1/2013 10 2013 4 4/1/2013 7
5/1/2013 11 2013 4 5/1/2013 8
6/1/2013 12 2013 4 6/1/2013 9
7/1/2013 1 2014 1 7/1/2013 10
8/1/2013 2 2014 1 8/1/2013 11
9/1/2013 3 2014 1 9/1/2013 12
10/1/2013 4 2014 2 10/1/2013 1
11/1/2013 5 2014 2 11/1/2013 2
12/1/2013 6 2014 2 12/1/2013 3
1/1/2014 7 2014 3 1/1/2014 4
2/1/2014 8 2014 3 2/1/2014 5
3/1/2014 9 2014 3 3/1/2014 6
4/1/2014 10 2014 4 4/1/2014 7
5/1/2014 11 2014 4 5/1/2014 8
6/1/2014 12 2014 4 6/1/2014 9
7/1/2014 1 2015 1 7/1/2014 10
8/1/2014 2 2015 1 8/1/2014 11
9/1/2014 3 2015 1 9/1/2014 12
10/1/2014 4 2015 2 10/1/2014 1
11/1/2014 5 2015 2 11/1/2014 2
12/1/2014 6 2015 2 12/1/2014 3
1/1/2015 7 2015 3 1/1/2015 4
2/1/2015 8 2015 3 2/1/2015 5
3/1/2015 9 2015 3 3/1/2015 6
 4/1/2015 10 2015 4 4/1/2015 7
5/1/2015 11 2015 4 5/1/2015 8
6/1/2015 12 2015 4 6/1/2015 9
7/1/2015 1 2016 1 7/1/2015 10
8/1/2015 2 2016 1 8/1/2015 11
9/1/2015 3 2016 1 9/1/2015 12
10/1/2015 4 2016 2 10/1/2015 1
11/1/2015 5 2016 2 11/1/2015 2
12/1/2015 6 2016 2 12/1/2015 3
1/1/2016 7 2016 3 1/1/2016 4
2/1/2016 8 2016 3 2/1/2016 5
3/1/2016 9 2016 3 3/1/2016 6
4/1/2016 10 2016 4 4/1/2016 7
5/1/2016 11 2016 4 5/1/2016 8
6/1/2016 12 2016 4 6/1/2016 9
7/1/2016 1 2017 1 7/1/2016 10
8/1/2016 2 2017 1 8/1/2016 11
9/1/2016 3 2017 1 9/1/2016 12
10/1/2016 4 2017 2 10/1/2016 1
11/1/2016 5 2017 2 11/1/2016 2
12/1/2016 6 2017 2 12/1/2016 3
1/1/2017 7 2017 3 1/1/2017 4
2/1/2017 8 2017 3 2/1/2017 5
3/1/2017 9 2017 3 3/1/2017 6
4/1/2017 10 2017 4 4/1/2017 7
5/1/2017 11 2017 4 5/1/2017 8
6/1/2017 12 2017 4 6/1/2017 9
7/1/2017 1 2018 1 7/1/2017 10
8/1/2017 2 2018 1 8/1/2017 11
Federal Fiscal Conversion
Fiscal Year Month Fiscal Qtr State Fiscal Period
2003 2 < =IF(MONTH(B4)+6>12,MONTH(B4)-6,MONTH(B4)+6)
2003 2 < =CHOOSE(TEXT(B4,"m"),7,8,9,10,11,12,1,2,3,4,5,6)
2003 2
2003 3 Federal Fiscal Period
2003 3 < =IF(MONTH(B4)+3>12,MONTH(B4)-9,MONTH(B4)+3)
2003 3 < =CHOOSE(TEXT(H4,"m"),4,5,6,7,8,9,10,11,12,1,2,3)
2003 4
2003 4 State Fiscal Year
2003 4 < =IF(MONTH(B4)+6>12,YEAR(B4)+1,YEAR(B4))
2004 1
2004 1 Federal Fiscal Year
2004 1 < =IF(MONTH(B4)+3>12,YEAR(B4)+1,YEAR(B4))
2004 2
2004 2 State Fiscal Quarter
2004 2 < =MOD(CEILING(22-7+MONTH(B4),3)/3,4)+1
2004 3 < =CHOOSE(TEXT(B4,"m"),3,3,3,4,4,4,1,1,1,2,2,2)
2004 3
2004 3 Federal Fiscal Quarter
2004 4 < =MOD(CEILING(22-10+MONTH(B4),3)/3,4)+1
2004 4 < =CHOOSE(TEXT(H4,"m"),2,2,2,3,3,3,4,4,4,1,1,1)
2004 4
2005 1
2005 1
2005 1
2005 2
2005 2
2005 2
2005 3
2005 3
2005 3
2005 4
2005 4
2005 4
2006 1
2006 1
2006 1
2006 2
2006 2
2006 2
2006 3
2006 3
2006 3
2006 4
2006 4
2006 4
2007 1
2007 1
2007 1
2007 2
2007 2
2007 2
2007 3
2007 3
2007 3
2007 4
2007 4
2007 4
2008 1
2008 1
2008 1
2008 2
2008 2
2008 2
2008 3
2008 3
2008 3
2008 4
2008 4
2008 4
2009 1
2009 1
2009 1
2009 2
2009 2
2009 2
2009 3
2009 3
2009 3
2009 4
2009 4
2009 4
2010 1
2010 1
2010 1
2010 2
2010 2
2010 2
2010 3
2010 3
2010 3
2010 4
2010 4
2010 4
2011 1
2011 1
2011 1
2011 2
2011 2
2011 2
2011 3
2011 3
2011 3
2011 4
2011 4
2011 4
2012 1
2012 1
2012 1
2012 2
2012 2
2012 2
2012 3
2012 3
2012 3
2012 4
2012 4
2012 4
2013 1
2013 1
2013 1
2013 2
2013 2
2013 2
2013 3
2013 3
2013 3
2013 4
2013 4
2013 4
2014 1
2014 1
2014 1
2014 2
2014 2
2014 2
2014 3
2014 3
2014 3
2014 4
2014 4
2014 4
2015 1
2015 1
2015 1
2015 2
2015 2
2015 2
2015 3
2015 3
2015 3
2015 4
2015 4
2015 4
2016 1
2016 1
2016 1
2016 2
2016 2
2016 2
2016 3
2016 3
2016 3
2016 4
2016 4
2016 4
2017 1
2017 1
2017 1
2017 2
2017 2
2017 2
2017 3
2017 3
2017 3
2017 4
2017 4
MONTH(B4)+6)
2,1,2,3,4,5,6)

MONTH(B4)+3)
0,11,12,1,2,3)
 Return to TOC CT_CORE_FIN_AP_VCHR_DT_COMPARE

The IF function tests a condition

If the condition is met it is considered to be TRUE
If the condition is not met it is considered as FALSE
=IF(Condition,ActionIFTrue,ActionIfFalse)
Examples
=IF(B15>=10,"Bonus","Slacker")
=IF(AND(B15>=10,C15<=3),"Bonus","Slacker") Bonus
=IF(OR(B15>=10,C15<3),"Bonus","Slacker") Slacker

The TRUE, FALSE section can also be a cell references or additional formulas

Days Between IF AND OR

Vchr Entry and Bonus / Bonus / Bonus /
Business Unit # of Vouchers Payment User Slacker Slacker Slacker
OSCM1 5 2 Jim Ignatowski
OSCM1 13 5 John Locke 
OSCM1 8 5 Kim Bauer 
OSCM1 33 4 Liz Lemon 
OSCM1 14 3 Lorelai Gilmore 
OSCM1 25 2 Lynette Scavo 
OSCM1 5 3 Maddie Hayes 
OSCM1 2 3 Matt Saracen 
OSCM1 15 4 Monica Bing 
OSCM1 12 3 Natalie Teeger 
OSCM1 7 3 Niles Crane 
OSCM1 11 3 Norm Peterson 
OSCM1 1 3 Phil Dunphy 
OSCM1 2 1 Phillip J. Fry 
OSCM1 27 4 Red Forman 
OSCM1 15 1 Robert Barone 
Real world problem
In the cells in row 37, the user wants a 1 if the cell in row 39 has a number, or a 0 if the cell is empty

July August September October-12 November-12 December-12 January-13 February-13 March-13

16,224 16,943 16,029 16,472 16,336 16,450 16,691 16,411

Answer is in the cell below

Answer is in the cell below

April-13 May-13 June-13
- - -
 Return to TOC
Dept Account SID Budget Assoc Pre- Encumbrance Expense
Revenue Encumbrance
DOB37011 50110 10010 1,301,790.11 - - - 1,127,344.67
DOB37011 50120 10010 28,120.39 - - - 28,120.39
DOB37011 50150 10010 - - - - -
DOB37011 50160 10010 36,648.50 - - - 32,011.50
DOB37011 50170 10010 - - - - -
DOB37011 50190 10010 39,860.00 - - - 39,860.00
DOB37011 50410 10010 - - - - -
DOB37011 50410 12244 915.40 - - - 768.05
DOB37011 50420 10010 - - - - -
DOB37011 50420 12244 132,190.35 - - - 105,327.44
DOB37011 50430 10010 - - - - -
DOB37011 50430 12244 2,204.88 - - - 2,043.13
DOB37011 50441 10010 - - - - -
DOB37011 50441 12244 74,114.67 - - - 62,122.79
DOB37011 50442 10010 - - - - -
DOB37011 50442 12244 19,164.69 - - - 16,553.92
DOB37011 50460 12244 12,446.10 - - - 10,197.10
DOB37011 50471 10010 - - - - -
DOB37011 50471 12244 368,461.38 - - - 335,749.81
DOB37011 50511 12244 48,522.91 - - - 48,522.91
DOB37011 50710 10010 59.88 - - - 59.88
DOB37011 50740 10010 - - - - -
DOB37011 50780 10010 - - - - -
DOB37011 50780 10020 3,325.10 - - - 2,310.10
DOB37011 50780 35181 487.84 - - - 487.84
DOB37011 50790 10010 - - - - -
DOB37011 50790 10020 29,426.40 - - - 29,426.40
DOB37011 50800 10010 - - - - -
DOB37011 50800 10020 2,287.31 - - - 1,981.31
DOB37011 51114 10020 - - - 40.30 -
DOB37011 51115 10020 120.90 - - - 120.90
DOB37011 51180 10020 2,186.59 - - - 2,186.59
DOB37011 51180 35181 50.00 - - - 50.00
DOB37011 51200 10020 - - - - -
DOB37011 51210 10020 209,100.00 - - - 209,100.00
DOB37011 51230 10020 - - - - -
DOB37011 51245 10020 - - - - -
DOB37011 51290 10020 4,930.00 - - - 3,735.00
2,316,413.40 0.00 0.00 40.30 2,058,079.73
Remaining Percent

174,445.44 87%
- 100% 0 =ISERROR(J4)
- #DIV/0! 1 =ISERROR(J5)
4,637.00 87%
- #DIV/0!
- 100% Hide Those Messy Error Symbols
- #DIV/0!
147.35 84% The ISERROR function is a TRUE / FALSE test of a cell's
- #DIV/0! content to determine whether an error has been
26,862.91 80% generated. It will return FALSE if no error has been
- #DIV/0! generated, and TRUE if there is an error.
161.75 93%
Combined with the IF function ISERROR can be used to
- #DIV/0! hide those errors.
11,991.88 84%
- #DIV/0! The syntax is:
2,610.77 86%
2,249.00 82% =IF(ISERROR(formula to be evaluated),"Answer if
- #DIV/0! TRUE",formula to be evaluated)
32,711.57 91%
In this example
- 100%
- 100% =IF(ISERROR(H3/D3)," ",H3/D3)
- #DIV/0!
- #DIV/0! Excel 2007/2010 only
1,015.00 69% IFERROR(FormulaToBeEvaluated,ActionToTake)
- 100% =IFERROR(H3/D3,"")
- #DIV/0!
Only invokes the ActionToTake if the
- 100%
FormulaToBeEvaluated creates an error
- #DIV/0!
306.00 87%
(40.30) #DIV/0!
- 100%
- 100%
- 100%
- #DIV/0!
- 100%
- #DIV/0!
- #DIV/0!
1,195.00 76%
258,293.37
Trial Balance Re 1835 Return to TOC CT_CORE_FIN_GL_TRIAL_BALANCE
Ledger Acct DeptID Fund SID Sum Total Amt
MOD_ACCRL 40210 SDE64270 11000 18010 -60.350
MOD_ACCRL 42434 SDE64270 11000 18010 -656538.640
MOD_ACCRL 43405 SDE64270 11000 18010 -1775.000
MOD_ACCRL 43451 SDE64270 11000 18010 -1707.000
MOD_ACCRL 43724 SDE64270 11000 18010 -30.000
MOD_ACCRL 44011 SDE64270 11000 18010 -704.350
MOD_ACCRL 44321 SDE64270 11000 18010 -500.000
MOD_ACCRL 44410 SDE64270 11000 18010 -283.000 Advanced Filter to find a subset of values
MOD_ACCRL 45020 SDE64270 12060 20500 -75874.270 Required:
MOD_ACCRL 45020 SDE64270 12060 20508 -3997776.940
MOD_ACCRL 45020 SDE64270 12060 20514 -244913.000 1. Highlight and copy those fields on the header row you want to use as
criteria and paste them to the right. Note: Your criteria only needs to include
MOD_ACCRL 45020 SDE64270 12060 20518 -3106733.400
those items you want to use as criteria. If you are not using the copy and
MOD_ACCRL 45020 SDE64270 12060 20524 -294485.210 paste feature then you must type criteria exactly the same way as it appears
MOD_ACCRL 45020 SDE64270 12060 20533 -4493.000 in the header data field. This becomes your criteria area.
MOD_ACCRL 45020 SDE64270 12060 20540 -769990.000 2. Place your cursor in the data area.
MOD_ACCRL 45020 SDE64270 12060 20544 -130613.340 3. Data > Filter > Advanced Filter (the Advanced Filter dialog box displays)
MOD_ACCRL 45020 SDE64270 12060 20548 -15935.000 (2007: Data ribbon > Sort & Filter-Advanced)
MOD_ACCRL 45020 SDE64270 12060 20553 -34289.370 4. Check the Copy To Another Location radio button (preferred)
5. List Range: Self selected so long as you placed your cursor in the data
MOD_ACCRL 45020 SDE64270 12060 20560 -14201220.110
area. Otherwise, click the lookup and select the data area (including the
MOD_ACCRL 45020 SDE64270 12060 20679 -14243639.690 headers). Click the lookup to return to the Advanced Filter dialog.
MOD_ACCRL 45020 SDE64270 12060 20680 -185671.450 6. Criteria Range: Click the lookup and select the criteria area (include the
MOD_ACCRL 45020 SDE64270 12060 20682 -26200.000 header fields and the criteria fields.
MOD_ACCRL 45020 SDE64270 12060 20742 -681580.330 7. Copy To: Click the lookup. Select where you want the unique values to
MOD_ACCRL 45020 SDE64270 12060 20765 -150.330 display.
MOD_ACCRL 45020 SDE64270 12060 20770 -34681.140 o If you select just the one cell then the filter will return the same number of
MOD_ACCRL 45020 SDE64270 12060 20784 -592356.930 columns as are displayed in the data area.
o If you only want to return selected columns then you should set that up
MOD_ACCRL 45020 SDE64270 12060 20809 -150.330
before you use the filter. Select the column headers you want returned and
MOD_ACCRL 45020 SDE64270 12060 20826 -404518.950 place them in the Copy To location. Using the Copy To lookup, select those
MOD_ACCRL 45020 SDE64270 12060 20848 -43457.420 headers. Click the lookup to return to the dialog
MOD_ACCRL 45020 SDE64270 12060 20854 -863165.090 8. Click OK.
MOD_ACCRL 45020 SDE64270 12060 20858 -2859438.630
MOD_ACCRL 45020 SDE64270 12060 20863 -855872.750 Notes:
MOD_ACCRL 45020 SDE64270 12060 20868 -845022.370 AND/OR: Criteria on the same row constitute the AND criteria. Criteria on
different rows constitute the OR criteria. = is assumed. Other operators
MOD_ACCRL 45020 SDE64270 12060 20870 -320826.170
include: <, <=, >=, >, <>
MOD_ACCRL 45020 SDE64270 12060 20873 -331563.610 Use copy and paste. You can type, but the spelling has to be exact.
MOD_ACCRL 45020 SDE64270 12060 20902 -15465.540 You can specify the columns that you want to extract. If you want to extract
MOD_ACCRL 45020 SDE64270 12060 20909 -7855.040 all columns, you can leave the extract range empty.
MOD_ACCRL 45020 SDE64270 12060 20949 -25013.670
MOD_ACCRL 45020 SDE64270 12060 20977 -20887929.150
MOD_ACCRL 45020 SDE64270 12060 20983 -610861.900
MOD_ACCRL 45020 SDE64270 12060 21074 -129089.700
MOD_ACCRL 45020 SDE64270 12060 21592 -334658.340
 Use copy and paste. You can type, but the spelling has to be exact.
You can specify the columns that you want to extract. If you want to extract
all columns, you can leave the extract range empty.

MOD_ACCRL 45020 SDE64270 12060 22028 123666.680

MOD_ACCRL 45020 SDE64270 12060 22051 -21482.000
MOD_ACCRL 45020 SDE64270 12060 22163 -190965.000
MOD_ACCRL 45020 SDE64270 12060 22223 -225014.450
MOD_ACCRL 45020 SDE64270 12060 22307 -384952.870
MOD_ACCRL 45020 SDE64270 12060 29010 -2232582.000
MOD_ACCRL 45020 SDE64270 12060 29011 -6811293.000
MOD_ACCRL 45020 SDE64270 12060 29012 -240890.000
MOD_ACCRL 45020 SDE64270 12060 29013 -408459.000
MOD_ACCRL 45020 SDE64270 12060 29033 -10074.000
MOD_ACCRL 46300 SDE64270 11000 18010 4361.050
MOD_ACCRL 50110 SDE64270 11000 10010 566039.360
MOD_ACCRL 50150 SDE64270 11000 10010 56328.760
MOD_ACCRL 50410 SDE64270 11000 10010 0.000
MOD_ACCRL 50420 SDE64270 11000 10010 0.000
MOD_ACCRL 50430 SDE64270 11000 10010 0.000
MOD_ACCRL 50441 SDE64270 11000 10010 0.000
MOD_ACCRL 50442 SDE64270 11000 10010 0.000
MOD_ACCRL 50471 SDE64270 11000 10010 0.000
MOD_ACCRL 50710 SDE64270 11000 10010 0.000
MOD_ACCRL 50710 SDE64270 11000 10020 1080.000
MOD_ACCRL 51761 SDE64270 11000 10020 522.000
MOD_ACCRL 51764 SDE64270 11000 10020 10868.070
MOD_ACCRL 51850 SDE64270 11000 10020 751.920
MOD_ACCRL 51873 SDE64270 11000 10020 -1748.710
MOD_ACCRL 51874 SDE64270 11000 10020 -622.710
MOD_ACCRL 52511 SDE64270 11000 10020 7081.200
MOD_ACCRL 52531 SDE64270 11000 10020 532.000
MOD_ACCRL 53011 SDE64270 11000 10020 7895.000
MOD_ACCRL 53755 SDE64270 11000 10020 356.000
MOD_ACCRL 53900 SDE64270 11000 10020 142.560
MOD_ACCRL 54060 SDE64270 11000 10020 4863.000
MOD_ACCRL 44092 SDE64301 21003 42305 -173.060
MOD_ACCRL 45500 SDE64301 12060 35184 -706.370
MOD_ACCRL 47100 SDE64301 12060 20409 -335046.000
MOD_ACCRL 47100 SDE64301 12060 20628 -288251.820
MOD_ACCRL 47100 SDE64301 12060 29077 -372111.000
MOD_ACCRL 47100 SDE64301 12060 29079 -50268.000
MOD_ACCRL 50750 SDE64301 11000 10020 1881.000
MOD_ACCRL 51112 SDE64301 11000 10020 1909.500
MOD_ACCRL 51250 SDE64301 11000 10020 2500.000
MOD_ACCRL 51290 SDE64301 12060 20247 644.530
MOD_ACCRL 51290 SDE64301 12060 20264 964.460
MOD_ACCRL 51290 SDE64301 12060 20277 3033.090
MOD_ACCRL 51290 SDE64301 12060 20283 -1292.210
MOD_ACCRL 51290 SDE64301 12060 20404 115721.330
MOD_ACCRL 51290 SDE64301 12060 20595 2998.320
MOD_ACCRL 51290 SDE64301 21003 40001 1479.260
MOD_ACCRL 51510 SDE64301 11000 10020 600.000
MOD_ACCRL 51620 SDE64301 11000 10020 19868.530
MOD_ACCRL 51620 SDE64301 12060 20125 545.230
MOD_ACCRL 51620 SDE64301 12060 20264 0.000
MOD_ACCRL 51620 SDE64301 12060 20404 9884.770
MOD_ACCRL 51620 SDE64301 12060 20595 2800.000
MOD_ACCRL 51640 SDE64301 11000 10020 7509.000
MOD_ACCRL 51672 SDE64301 11000 10020 513.000
MOD_ACCRL 51675 SDE64301 11000 10020 200.000
MOD_ACCRL 51694 SDE64301 11000 10020 29950.000
MOD_ACCRL 51695 SDE64301 21003 40001 11292.750
MOD_ACCRL 51761 SDE64301 11000 10020 35.000
MOD_ACCRL 51764 SDE64301 11000 10020 4399.010
MOD_ACCRL 51780 SDE64301 11000 10020 73760.000
MOD_ACCRL 51981 SDE64301 11000 10020 84.000
MOD_ACCRL 52511 SDE64301 11000 10020 3105.000
MOD_ACCRL 52541 SDE64301 11000 12240 1500.000
MOD_ACCRL 53011 SDE64301 11000 10020 6346.000
MOD_ACCRL 53017 SDE64301 11000 10020 7762.320
MOD_ACCRL 53018 SDE64301 11000 10020 1878.570
MOD_ACCRL 53020 SDE64301 11000 10020 13900.980
MOD_ACCRL 53021 SDE64301 11000 10020 300.000
MOD_ACCRL 53401 SDE64301 11000 10020 50.400
MOD_ACCRL 53755 SDE64301 12060 20125 4105.000
MOD_ACCRL 53755 SDE64301 12060 20247 1559.610
MOD_ACCRL 54060 SDE64301 11000 10020 1863.650
MOD_ACCRL 54060 SDE64301 12060 20404 457.350
MOD_ACCRL 54150 SDE64301 12060 20125 1590.000
MOD_ACCRL 54190 SDE64301 11000 10020 1755.970
MOD_ACCRL 54190 SDE64301 12060 20283 3608.280
MOD_ACCRL 54190 SDE64301 12060 20404 161.800
MOD_ACCRL 44410 SDE64305 11000 18010 -15.960
MOD_ACCRL 50110 SDE64305 11000 10010 1284746.510
MOD_ACCRL 50110 SDE64305 12060 20409 49407.690
MOD_ACCRL 50110 SDE64305 12060 20628 29188.870
MOD_ACCRL 50150 SDE64305 11000 10010 41208.770
MOD_ACCRL 50150 SDE64305 12060 20404 0.000
MOD_ACCRL 50160 SDE64305 11000 10010 3657.980
MOD_ACCRL 50410 SDE64305 11000 10010 0.000
MOD_ACCRL 50410 SDE64305 12060 20628 33.950
MOD_ACCRL 50420 SDE64305 11000 10010 0.000
MOD_ACCRL 50420 SDE64305 12060 20404 0.000
MOD_ACCRL 50420 SDE64305 12060 20409 10028.760
MOD_ACCRL 50420 SDE64305 12060 20628 3819.270
MOD_ACCRL 50430 SDE64305 11000 10010 0.000
MOD_ACCRL 50430 SDE64305 12060 20404 0.000
MOD_ACCRL 50430 SDE64305 12060 20409 143.070
MOD_ACCRL 50430 SDE64305 12060 20628 83.820
MOD_ACCRL 50441 SDE64305 11000 10010 0.000
MOD_ACCRL 50441 SDE64305 12060 20404 0.000
MOD_ACCRL 50441 SDE64305 12060 20409 1437.940
MOD_ACCRL 50441 SDE64305 12060 20628 1767.390
MOD_ACCRL 50442 SDE64305 11000 10010 0.000
MOD_ACCRL 50442 SDE64305 12060 20404 0.000
MOD_ACCRL 50442 SDE64305 12060 20409 714.180
MOD_ACCRL 50442 SDE64305 12060 20628 413.340
MOD_ACCRL 50471 SDE64305 11000 10010 0.000
MOD_ACCRL 50471 SDE64305 12060 20404 0.000
MOD_ACCRL 50471 SDE64305 12060 20409 9593.920
MOD_ACCRL 50471 SDE64305 12060 20628 11631.750
MOD_ACCRL 50473 SDE64305 11000 10010 0.000
MOD_ACCRL 50473 SDE64305 12060 20409 6549.760
MOD_ACCRL 50710 SDE64305 11000 10010 0.000
MOD_ACCRL 50710 SDE64305 11000 10020 635.500
MOD_ACCRL 50710 SDE64305 12060 20409 54.000
MOD_ACCRL 50780 SDE64305 11000 10010 0.000
MOD_ACCRL 50780 SDE64305 11000 10020 5.000
MOD_ACCRL 50800 SDE64305 11000 10010 1342.550
MOD_ACCRL 50800 SDE64305 11000 10020 7522.350
MOD_ACCRL 50800 SDE64305 12060 20409 654.500
MOD_ACCRL 50800 SDE64305 12060 20628 109.450
MOD_ACCRL 51290 SDE64305 11000 10020 4330.000
MOD_ACCRL 51570 SDE64305 11000 10020 538.750
MOD_ACCRL 54130 SDE64305 21003 42305 513.480
MOD_ACCRL 45020 SDE64310 12060 20311 -65.000
MOD_ACCRL 53755 SDE64315 11000 10020 863.910
MOD_ACCRL 53760 SDE64315 11000 10020 9117.000
MOD_ACCRL 51761 SDE64320 11000 10020 1288.640
MOD_ACCRL 53820 SDE64320 11000 10020 1960.270
MOD_ACCRL 53870 SDE64320 11000 10020 1245.670
MOD_ACCRL 43511 SDE64346 21003 40001 -2667.000
MOD_ACCRL 44092 SDE64346 21003 42305 -1800.000
MOD_ACCRL 50110 SDE64346 11000 10010 79961.460
MOD_ACCRL 50150 SDE64346 11000 10010 13644.160
MOD_ACCRL 50170 SDE64346 11000 10010 458.500
MOD_ACCRL 50410 SDE64346 11000 10010 0.000
MOD_ACCRL 50420 SDE64346 11000 10010 0.000
MOD_ACCRL 50430 SDE64346 11000 10010 0.000
MOD_ACCRL 50441 SDE64346 11000 10010 0.000
MOD_ACCRL 50442 SDE64346 11000 10010 0.000
MOD_ACCRL 50471 SDE64346 11000 10010 0.000
MOD_ACCRL 50710 SDE64346 11000 10010 0.000
MOD_ACCRL 50710 SDE64346 11000 10020 135.000
MOD_ACCRL 50800 SDE64346 11000 10010 0.000
MOD_ACCRL 50800 SDE64346 11000 10020 157.300
MOD_ACCRL 52531 SDE64346 11000 10020 392.000
MOD_ACCRL 53035 SDE64346 11000 10020 587.600
MOD_ACCRL 53311 SDE64346 11000 10020 6232.260
MOD_ACCRL 53338 SDE64346 11000 10020 2609.290
MOD_ACCRL 53361 SDE64346 11000 10020 204.000
MOD_ACCRL 53390 SDE64346 11000 10020 765.710
MOD_ACCRL 53450 SDE64346 11000 10020 505.500
MOD_ACCRL 54060 SDE64346 11000 10020 10.120
MOD_ACCRL 54150 SDE64346 12060 90447 310.730
MOD_ACCRL 55710 SDE64346 12060 90447 5679.560
MOD_ACCRL 44410 SDE64370 11000 18010 -89365.870
MOD_ACCRL 47100 SDE64370 12060 21964 -93750.000
MOD_ACCRL 47200 SDE64370 12060 90484 -99043.000
MOD_ACCRL 55050 SDE64370 11000 12113 492991.000
MOD_ACCRL 55050 SDE64370 12052 40310 0.000
MOD_ACCRL 55050 SDE64370 12052 42860 -7928.000
MOD_ACCRL 55050 SDE64370 12052 42861 -119529.500
MOD_ACCRL 55050 SDE64370 12060 20500 75874.270
MOD_ACCRL 55050 SDE64370 12060 20508 3820107.980
MOD_ACCRL 55050 SDE64370 12060 20514 249118.000
MOD_ACCRL 55050 SDE64370 12060 20518 3090938.110
MOD_ACCRL 55050 SDE64370 12060 20524 1476.000
MOD_ACCRL 55050 SDE64370 12060 20540 769990.000
MOD_ACCRL 55050 SDE64370 12060 20544 129999.430
MOD_ACCRL 55050 SDE64370 12060 20548 15935.000
MOD_ACCRL 55050 SDE64370 12060 20560 13710722.440
MOD_ACCRL 55050 SDE64370 12060 20679 18120074.240
MOD_ACCRL 55050 SDE64370 12060 20682 56002.000
MOD_ACCRL 55050 SDE64370 12060 20742 670611.450
MOD_ACCRL 55050 SDE64370 12060 20770 40506.000
MOD_ACCRL 55050 SDE64370 12060 20784 700531.670
MOD_ACCRL 55050 SDE64370 12060 20826 430277.810
MOD_ACCRL 55050 SDE64370 12060 20854 748128.930
MOD_ACCRL 55050 SDE64370 12060 20858 2929719.530
MOD_ACCRL 55050 SDE64370 12060 20863 1315625.000
MOD_ACCRL 55050 SDE64370 12060 20868 907809.290
MOD_ACCRL 55050 SDE64370 12060 20870 60000.000
MOD_ACCRL 55050 SDE64370 12060 20873 348688.500
MOD_ACCRL 55050 SDE64370 12060 20902 12000.000
MOD_ACCRL 55050 SDE64370 12060 20909 2056.930
MOD_ACCRL 55050 SDE64370 12060 20977 24581690.120
MOD_ACCRL 55050 SDE64370 12060 20983 876252.880
MOD_ACCRL 55050 SDE64370 12060 21074 16370.000
MOD_ACCRL 55050 SDE64370 12060 21592 364202.000
MOD_ACCRL 55050 SDE64370 12060 21964 31250.000
MOD_ACCRL 55050 SDE64370 12060 22028 31000.000
MOD_ACCRL 55050 SDE64370 12060 22051 21294.050
MOD_ACCRL 55050 SDE64370 12060 22223 277223.000
MOD_ACCRL 55050 SDE64370 12060 22307 383694.000
MOD_ACCRL 55050 SDE64370 12060 26025 30000.000
MOD_ACCRL 55050 SDE64370 12060 29010 3565509.000
MOD_ACCRL 55050 SDE64370 12060 29011 13133270.000
MOD_ACCRL 55050 SDE64370 12060 29012 490938.000
MOD_ACCRL 55050 SDE64370 12060 29013 460463.000
MOD_ACCRL 55050 SDE64370 12060 29033 29949.000
MOD_ACCRL 55050 SDE64370 12060 30256 13100.000
MOD_ACCRL 55050 SDE64370 13009 40896 4449421.980
MOD_ACCRL 55050 SDE64370 13010 40901 130259455.850
MOD_ACCRL 55070 SDE64370 11000 16021 3870004.000
MOD_ACCRL 55070 SDE64370 11000 16101 490000.000
MOD_ACCRL 55070 SDE64370 11000 16106 249999.000
MOD_ACCRL 55070 SDE64370 11000 16119 22511868.000
MOD_ACCRL 55070 SDE64370 11000 16202 224662.000
MOD_ACCRL 55070 SDE64370 11000 17030 10348671.000
MOD_ACCRL 55070 SDE64370 11000 17043 14762142.000
MOD_ACCRL 55070 SDE64370 11000 17045 3292553.000
MOD_ACCRL 55070 SDE64370 11000 17053 76412.000
MOD_ACCRL 55070 SDE64370 11000 17057 56604524.000
MOD_ACCRL 55070 SDE64370 12060 20977 125428.000
MOD_ACCRL 55080 SDE64370 11000 16072 646510.000
MOD_ACCRL 55080 SDE64370 11000 17045 146836.000
MOD_ACCRL 55110 SDE64370 12060 20508 177668.960
MOD_ACCRL 55110 SDE64370 12060 20518 8181.290
MOD_ACCRL 55110 SDE64370 12060 20540 9836.000
MOD_ACCRL 55110 SDE64370 12060 20544 604.910
MOD_ACCRL 55110 SDE64370 12060 20560 490497.670
MOD_ACCRL 55110 SDE64370 12060 20680 250000.000
MOD_ACCRL 55110 SDE64370 12060 20742 52957.230
MOD_ACCRL 55110 SDE64370 12060 20784 256549.630
MOD_ACCRL 55110 SDE64370 12060 20858 31541.600
MOD_ACCRL 55110 SDE64370 12060 20873 -1.490
MOD_ACCRL 55110 SDE64370 12060 20909 -0.210
MOD_ACCRL 55110 SDE64370 12060 20977 2240366.000
MOD_ACCRL 55110 SDE64370 12060 21592 -7342.910
MOD_ACCRL 55110 SDE64370 12060 29011 2543581.000
MOD_ACCRL 55110 SDE64370 12060 29013 61431.000
MOD_ACCRL 55110 SDE64370 12060 29033 25000.000
Return to TOC
When using the filter feature to extra
set up your criteria and results area

In cell A1, type your criteria heading

In cell A2, type your criteria (in this e
In Cell A8, type the first field you wan
In cell B8, type the second field you
Total Amt)

Extract Data to Another Workshee

If the database is on Sheet1, you ca

Excel Advanced Filter:
1. Go to Sheet 2 (06-Filter2)
2. Select a cell in an unused part of
3. From the Data menu, choose Filte
the Data tab on the Ribbon, then clic
4. Choose Copy to another location.
5. Click in the List Range box
6. Select Sheet 1, and select the dat
7. (optional) Click in the Criteria rang
8. Select the criteria range
9. Click in the Copy to box.
10. Select the cell on Sheet 2 in whic
the headings that you have typed on
11. (optional) Check the box for Uniq

Advanced Filter to find unique val

1. The Unique values feature is a su

Otherwise, it is set up in exactly the
2. Data > Filter > Advanced Filter (th
(2007: Data ribbon > Sort & Filter-Ad
3. Check the Copy To Another Locat
4. List Range: Click the lookup. High
your data of interest. You must includ
5. Criteria Range: Ignore
6. Copy To: Click the lookup. Select
display.
7. Check the Unique Records Only c
8. Click OK.

Note: If you are trying to find unique

does not like to deal with calculated
To solve this problem, you copy the
feature paste "just values". This leav
calculation.

Also, this process assumes there wi

include the header row Excel will sho
include the header row Excel will sho
 using the filter feature to extract data to a remote location, it is wise to
your criteria and results area beforehand.

A1, type your criteria heading (in this example: SID)

A2, type your criteria (in this example: 20*)
A8, type the first field you want to extract. (in this example, SID)
B8, type the second field you want to extract. (in this example, Sum
Amt)

ct Data to Another Worksheet

database is on Sheet1, you can extract data to Sheet2, by using an

Advanced Filter:
to Sheet 2 (06-Filter2)
ect a cell in an unused part of the sheet (cell A1 in this example).
m the Data menu, choose Filter, Advanced Filter.(In Excel 2007, click
ata tab on the Ribbon, then click Advanced Filter.)
oose Copy to another location.
k in the List Range box
ect Sheet 1, and select the database.
ional) Click in the Criteria range box.
ect the criteria range
k in the Copy to box.
lect the cell on Sheet 2 in which you want the results to start, or select
adings that you have typed on Sheet 2.
ptional) Check the box for Unique Values Only

nced Filter to find unique values

Unique values feature is a subset of the filtering operation.

wise, it is set up in exactly the same way as any other filter.
a > Filter > Advanced Filter (the Advanced Filter dialog box displays)
Data ribbon > Sort & Filter-Advanced)
eck the Copy To Another Location radio button (preferred)
Range: Click the lookup. Highlight the column of data that contains
ata of interest. You must include the column header.
eria Range: Ignore
py To: Click the lookup. Select where you want the unique values to
y.
eck the Unique Records Only checkbox.
k OK.

If you are trying to find unique values from a calculated field, Excel
not like to deal with calculated functions (e.g., the concatenated fields).
ve this problem, you copy the range and, using the Paste Special
e paste "just values". This leaves the data while removing the
ation.

his process assumes there will be a header row, so if you don’t

e the header row Excel will show the first unique value twice.
e the header row Excel will show the first unique value twice.
 Return to TOC ct_pc_to_gl_ledger

PC BusineFund SID Department Program Account Budget ReFiscal YeaAccountinProject

DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04000
DOTM1 12011 40010 DOT57931 32003 52033 2011 2011 2 DOT04000
DOTM1 12001 12378 DOT57931 32003 52033 2011 2011 2 DOT04200
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04200
DOTM1 12062 22106 DOT57533 35002 51210 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57533 35002 51210 2011 2011
Use Conditional Formatting to Dynamically Highlight 2 DOT07099
Rows of Data
DOTM1 12062 22106 DOT57353 35002 51210 2011 2011 2 DOT07099
DOTM1 12001 12017 DOT57353 In the 51210
35002 Intermediate 2011class, students2011were shown how to place a line divider
2 DOT01702
DOTM1 12062 22106 DOT57533 this
35002 exercise,
51210 we will
2011 create a dropdown
2011 list that will be
2 DOT07099used to determine
DOTM1 12062 22101 DOT57533 highlighted.
35002 51210 2011 2011 2 DOT01702
DOTM1 12062 22101 DOT57353 35002 51210 2011 2011 2 DOT01702
Step 1 ~ Create a unique list. This was shown in the "Filter" exercise. This
DOTM1 12062 22106 DOT57533 35002
unique lists in columns Q. You can create more. 2 DOT07099
51210 2011 2011
DOTM1 12001 12378 DOT57931 32003
Place 52033
your cursor2011 in B3. 2011 2 DOT04270
DOTM1 12001 12175 DOT57931 32003
Label it53311
SID 2011 2011 2 DOT00320
DOTM1 12001 12175 DOT57931 32003 53311 2011 2011 2 DOT01430
DOTM1 12001 12175 DOT57931 Step 252033
32003 ~ Create a2011 dropdown menu. 2011 2 DOT01702
DOTM1 12062 21359 DOT57931 Place 52033
32003 you cursor 2011in cell B4 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 Navigation:
32003 53311Data 2011> Data Validation2011 > Data Validation > (Data Validation dia
2 DOT01640
List (Allow dropdown)
DOTM1 12062 21361 DOT57931 32003 52033
Click the range icon 2011 to the right of2011
the Source field. 2 DOT01702
DOTM1 12062 21361 DOT57931 32003 52033
Highlight the data2011in column Q ~ 2011Click the range2icon DOT01702
to the right.
DOTM1 12062 22106 DOT57533 35002
Click OK51210 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57533 35002 51210
Optional: Repeat 2011for other headings. 2011 2 DOT07099
DOTM1 12062 22106 DOT57353 35002 51210 2011 2011 2 DOT07099
DOTM1 12001 12175 DOT57931 Step 352033
32003 ~ Create the 2011 conditional Format
2011 2 DOT04330
DOTM1 12001 12175 DOT57931 Highlight
32003 the
52033 range:
2011 A9:O130 2011 2 DOT04420
Navigation: Home > Conditional Formatting > New Rule > Use a formula
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04310
Format > Conditional Formatting (dialog opens) > Formula is (from dropdo
DOTM1 12062 22106 DOT57533 35002 51210 2011 2011 2 DOT07099
DOTM1 12001 12175 DOT57931 32003 55670
SID: =$C9=$B$4 2011 2011 2 DOT00360
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 The
32003 important
52033 thing
2011 to remember is that
2011 in the data table you need only lo
2 DOT01702
DOTM1 12001 12175 DOT57931 ($C9),
32003 but
52033 in the criteria
2011 area you must
2011 lock both column
2 DOT01702 and row ($B$4).
DOTM1 12001 12168 DOT57931 32002 52033 2011 2011 2 DOT04020
Click the Format Icon to the right: select the Patterns tab.
DOTM1 12011 40010 DOT57931 32003 52033 2011 2011 2 DOT04000
Select a shade
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04000
DOTM1 12001 12378 DOT57931 32003 52033
Click OK twice 2011 2011 2 DOT04120
DOTM1 12001 12378 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12175 DOT57342 Test your
32003 52033work. 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT00630
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12378 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04120
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT00940
DOTM1 12062 21361 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12062 22099 DOT57931 32003 51210 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 32003 51230 2011 2011 2 DOT04000
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04100
DOTM1 12001 12378 DOT57931 32003 52033 2011 2011 2 DOT04100
DOTM1 12062 22102 DOT57191 34001 55850 2011 2011 2 DOT03010
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04100
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04100
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04420
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04530
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04410
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04100
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12062 22106 DOT57353 35002 51210 2011 2011 2 DOT07119
DOTM1 12062 22106 DOT57353 35002 51210 2011 2011 2 DOT07119
DOTM1 12062 22101 DOT57931 32003 52033 2011 2011 2 DOT04720
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04720
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04160
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04270
DOTM1 12062 21361 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12062 22101 DOT57931 32003 52033 2011 2011 2 DOT04760
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04270
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT01702
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04320
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04310
DOTM1 12062 22106 DOT57533 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57353 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57533 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57353 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57533 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57353 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04780
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04780
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04740
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04800
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04720
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04760
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04740
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04780
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04800
DOTM1 12062 21359 DOT57931 32003 45020 2010 2011 2 DOT01702
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04780
DOTM1 12062 21359 DOT57931 32003 45020 2010 2011 2 DOT01702
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04720
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04760
DOTM1 12062 21359 DOT57931 32003 45020 2010 2011 2 DOT01702
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04780
DOTM1 12062 22101 DOT57931 32003 45020 2010 2011 2 DOT04740
DOTM1 12062 22100 DOT57191 34001 51892 2011 2011 2 DOT03010
DOTM1 12062 22102 DOT57951 32002 55890 2011 2011 2 DOT03000
DOTM1 12062 22100 DOT57191 34001 51892 2011 2011 2 DOT03000
DOTM1 12001 12175 DOT57931 32003 52033 2011 2011 2 DOT04780
DOTM1 12001 12175 DOT57911 32003 52033 2011 2011 2 DOT04780
DOTM1 12062 22101 DOT57533 35002 51210 2011 2011 2 DOT01702
DOTM1 12001 12017 DOT57533 35002 51210 2011 2011 2 DOT01702
DOTM1 12062 22108 DOT57191 34001 10446 2011 2011 2 DOT00630
DOTM1 12062 22106 DOT57353 35002 10446 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57533 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22101 DOT57533 35002 45020 2011 2011 2 DOT01702
DOTM1 12062 22106 DOT57533 35002 51210 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57533 35002 10446 2011 2011 2 DOT07099
DOTM1 12001 12017 DOT57533 35002 51210 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57353 35002 51210 2011 2011 2 DOT07099
DOTM1 12062 22108 DOT57191 34001 10446 2011 2011 2 DOT01360
DOTM1 12001 12017 DOT57533 35002 10446 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57353 35002 45020 2011 2011 2 DOT07099
DOTM1 12001 12017 DOT57353 35002 51210 2011 2011 2 DOT07099
DOTM1 12001 12017 DOT57353 35002 10446 2011 2011 2 DOT07099
DOTM1 12062 22101 DOT57533 35002 45020 2011 2011 2 DOT01702
DOTM1 12062 22106 DOT57353 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22106 DOT57533 35002 45020 2011 2011 2 DOT07099
DOTM1 12062 22108 DOT57191 34001 10446 2011 2011 2 DOT00920
 SID
12017
12168
12175
12378
21359
Activity Amount Journal DaJournal IDLedger 21361
TT0000 45044 40391 AP008221 MOD_ACCRL 22099
TT0000 11228.75 40391 AP008221 MOD_ACCRL 22100
TT0000 1567610 40392 AP008221 MOD_ACCRL 22101
TT0000 2000000 40392 AP008221 MOD_ACCRL 22102
TT0000 22793.98 40392 AP008225 MOD_ACCRL 22106
TT0000 51159.31 40392 AP008225 MOD_ACCRL 22108
UR0000 57506.11 40393 AP008227 MOD_ACCRL 40010
UR0000
ght Rows of Data 25871.18 40393 AP008227 MOD_ACCRL
UR0000 24652.06 40393 AP008227 MOD_ACCRL
ow to place TT0000
a line divider separating
779.05 like items.
40393 In
AP008227 MOD_ACCRL
will be used to determine
UR0000 which
54183.5rows should be
40393 AP008227 MOD_ACCRL
TT0000 9076.43 40393 AP008227 MOD_ACCRL
TT0000 6232.35 40393 AP008227 MOD_ACCRL
the "Filter" exercise. This exercise has provided one
UR0000 22125.19 40393 AP008227 MOD_ACCRL
TT0000 38036.14 40394 AP008230 MOD_ACCRL
TT0000 1250 40394 AP008230 MOD_ACCRL
TT0000 2000 40394 AP008235 MOD_ACCRL
TT0000 16295 40394 AP008235 MOD_ACCRL
TT0000 16507.83 40394 AP008235 MOD_ACCRL
tion > (Data TT0000
Validation dialog2600
opens) Settings (tab) > MOD_ACCRL
40394 AP008235
d. TT0000 78372.8 40394 AP008235 MOD_ACCRL
TT0000
icon to the right. 40000 40395 AP008235 MOD_ACCRL
UR0000 36719.01 40395 AP008235 MOD_ACCRL
UR0000 292.05 40395 AP008235 MOD_ACCRL
UR0000 130536.7 40395 AP008235 MOD_ACCRL
TT0000 12238.12 40396 AP008239 MOD_ACCRL
TT0000 33909.88 40396 AP008239 MOD_ACCRL
w Rule > Use a formula ... (2007/2010) or
TT0000 283731.7 40396 AP008239 MOD_ACCRL
> Formula is (from dropdown) (97-2003)
UR0000 34690.86 40396 AP008244 MOD_ACCRL
EQ0000 854.2 40399 AP008248 MOD_ACCRL
TT0000 137189.4 40399 AP008248 MOD_ACCRL
ta table you TT0000
need only lock2965.2
the column40399
reference
AP008248 MOD_ACCRL
column and TT0000
row ($B$4). 2831.75 40399 AP008248 MOD_ACCRL
TT0000 16902.14 40401 AP008254 MOD_ACCRL
erns tab.
TT0000 2000000 40401 AP008254 MOD_ACCRL
TT0000 3433819 40401 AP008254 MOD_ACCRL
MS0000 552653 40402 AP008259 MOD_ACCRL
MS0000 188818.3 40402 AP008264 MOD_ACCRL
TT0000 2367.25 40402 AP008264 MOD_ACCRL
TT0000 14199.34 40402 AP008264 MOD_ACCRL
TT0000 1052996 40402 AP008264 MOD_ACCRL
TT0000 27567.5 40402 AP008264 MOD_ACCRL
TT0000 114983 40402 AP008264 MOD_ACCRL
TT0000 38903.5 40402 AP008264 MOD_ACCRL
TT0000 47672.75 40402 AP008264 MOD_ACCRL
TT0000 65992 40402 AP008264 MOD_ACCRL
TT0000 170440.5 40402 AP008264 MOD_ACCRL
TT0000 5371.75 40402 AP008264 MOD_ACCRL
TT0000 40000 40403 AP008264 MOD_ACCRL
TT0000 1890.52 40403 AP008264 MOD_ACCRL
TT0000 180408 40403 AP008264 MOD_ACCRL
TT0000 51814.5 40403 AP008268 MOD_ACCRL
TT0000 510452 40403 AP008268 MOD_ACCRL
UT0000 116.66 40406 AP008273 MOD_ACCRL
TT0000 17806 40406 AP008273 MOD_ACCRL
TT0000 50216 40406 AP008273 MOD_ACCRL
TT0000 15244.47 40407 AP008273 MOD_ACCRL
TT0000 54202.01 40407 AP008273 MOD_ACCRL
TT0000 97857.24 40407 AP008273 MOD_ACCRL
TT0000 2192056 40403 AP008278 MOD_ACCRL
TT0000 4977 40409 AP008287 MOD_ACCRL
UR0000 45588.05 40414 AP008299 MOD_ACCRL
UR0000 11418.13 40414 AP008299 MOD_ACCRL
TT0000 54183.98 40414 AP008302 MOD_ACCRL
TT0000 1381.75 40414 AP008302 MOD_ACCRL
EQ0000 5699.82 40414 AP008302 MOD_ACCRL
EQ0000 752.2 40414 AP008302 MOD_ACCRL
TT0000 80000 40414 AP008302 MOD_ACCRL
TT0000 2831.75 40414 AP008302 MOD_ACCRL
TT0000 17882.38 40414 AP008302 MOD_ACCRL
TT0000 11828.59 40414 AP008302 MOD_ACCRL
TT0000 16.51 40414 AP008302 MOD_ACCRL
TT0000 74663.7 40415 AP008302 MOD_ACCRL
TT0000 49690.45 40416 AP008307 MOD_ACCRL
TT0000 453748.9 40416 AP008307 MOD_ACCRL
UR0000 -117165 40395 AR008245MOD_CASH
UR0000 -122184 40395 AR008245MOD_CASH
UR0000 -141943 40402 AR008265MOD_CASH
UR0000 -21912.96 40402 AR008265MOD_CASH
UR0000 -63735.1 40409 AR008288MOD_CASH
UR0000 -116033 40409 AR008288MOD_CASH
TT0000 -8690.14 40410 AR008298MOD_CASH
TT0000 -14762 40410 AR008298MOD_CASH
EQ0000 8 40410 AR008298MOD_CASH
TT0000 -3376 40410 AR008298MOD_CASH
TT0000 -26659.48 40410 AR008298MOD_CASH
TT0000 -14576.98 40410 AR008298MOD_CASH
TT0000 -132060 40410 AR008298MOD_CASH
EQ0000 -0.34 40410 AR008298MOD_CASH
TT0000 -818.45 40410 AR008298MOD_CASH
TT0000 -8049 40410 AR008298MOD_CASH
TT0000 -7412.66 40410 AR008298MOD_CASH
TT0000 -228086 40410 AR008298MOD_CASH
TT0000 -28023.24 40414 AR008331MOD_CASH
TT0000 -0.07 40414 AR008331MOD_CASH
TT0000 -189698 40414 AR008331MOD_CASH
TT0000 -0.04 40414 AR008331MOD_CASH
TT0000 -188592 40414 AR008331MOD_CASH
UT0000 26805.68 40406 DOTDG001MOD_ACCRL
EQ0000 -6629.987 40417 DOTDG001MOD_ACCRL
UT0000 -4030.013 40420 DOTDG001MOD_ACCRL
TT0000 31781 40421 DOTDG001MOD_ACCRL
TT0000 -31781 40421 DOTDG001MOD_ACCRL
TT0000 2310.98 40414 DOTPF001MOD_ACCRL
TT0000 288.87 40414 DOTPF001MOD_ACCRL
UT0000 132.48 40392 PCR08223MOD_ACCRL
UR0000 2739.12 40393 PCR08227MOD_ACCRL
UR0000 -141943 40393 PCR08227MOD_ACCRL
TT0000 -80.25 40393 PCR08227MOD_ACCRL
UR0000 -17742.9 40393 PCR08227MOD_ACCRL
UR0000 17742.9 40393 PCR08227MOD_ACCRL
UR0000 17742.9 40393 PCR08227MOD_ACCRL
UR0000 -2739.12 40393 PCR08227MOD_ACCRL
UT0000 41.96 40393 PCR08227MOD_ACCRL
UR0000 -17742.9 40393 PCR08227MOD_ACCRL
UR0000 -21912.96 40393 PCR08227MOD_ACCRL
UR0000 2739.12 40393 PCR08227MOD_ACCRL
UR0000 -2739.12 40393 PCR08227MOD_ACCRL
TT0000 80.25 40393 PCR08227MOD_CASH
UR0000 21912.96 40393 PCR08227MOD_CASH
UR0000 141943.2 40393 PCR08227MOD_CASH
UT0000 32.11 40394 PCR08233MOD_ACCRL
 Return to TOC CT_CORE_BUDGET_STATUS_REPORT
Ledger Acct DeptID Fund SID Program Budget Period Period Ledger Grp Total Amt Scenario 1 Scenario 2
KK_APP_BD 50000 OSC15000 11000 10010 00000 2009 1 KK_APPROP (20,415,618.00)
KK_APP_BD 50000 OSC15000 12001 10010 00000 2009 1 KK_APPROP (71,426,000.00)
KK_APP_BD 50000 OSC15000 12052 10010 00000 2009 0 KK_APPROP (324,000.00)
KK_APP_BD 50000 OSC15000 11000 10020 00000 2009 1 KK_APPROP (6,008,110.00)
KK_APP_BD 50000 OSC15000 12001 10020 00000 2009 1 KK_APPROP (242,000.00)
KK_APP_BD 50000 OSC15000 12052 10020 00000 2009 0 KK_APPROP (105,305.00)
KK_APP_BD 50000 OSC15000 11000 10050 00000 2009 1 KK_APPROP (100.00)
KK_APP_BD 50000 OSC15000 12001 10050 00000 2009 1 KK_APPROP (282,794.00)
KK_APP_BD 50000 OSC15000 12052 10050 00000 2009 0 KK_APPROP (5,800.00)

Scenario 1
Name your SID ranges (this creates an absolute reference for the SID field) SID percent
10010 = Payroll 10010 1.2
10020 = oe 10020 0.9
10050 = equip 10050 0.75
Name each percent range (this creates an absolute reference to the percentage)
1.1 = pay_1 Documenting your assumptions
0.95 = oe_1 is considered a best practice
0.5 = equip_1
This allows you to change the parameters independently of the formua

Your formula becomes:

=IF(E3=payroll,O3*pay_1,IF(E3=oe,O3*oe_1,IF(E3=equip,O3*equip_1,"")))
Fill down

To change the scenario, you only need to update the percent field.

You are allowed to nest up to seven (7) if statements

Scenario 2
=IF(ISERROR(VLOOKUP(E3,table,2,0)),"",O3*VLOOKUP(E3,table,2,0)) all versions of Excel
or
=IFERROR(O3*VLOOKUP(E3,table,2,0),"") Excel 2007/2010
Basic Form
=O3*VLOOKUP(E3,table,2,0)
 Return to TOC

The TEXT function converts a number to a text format

The formatting for the text needs to be specified in the function.

'=TEXT(NumberToConvert,FormatForConversion)

Original
Number Converted To Text
10 10.00 =TEXT(F4,"0.00")
10 $10.00 =TEXT(F5,"$0.00")
10 10 =TEXT(F6,"0")
10 $10 =TEXT(F7,"$0")
10.25 10.3 =TEXT(F8,"0.0")
10.25 $10.25 =TEXT(F9,"$0.00")
1/1/2009 Thu =TEXT(F10,"ddd")
1/1/2009 Jan-09 =TEXT(F11,"mmm-yy")
1/1/2009 Jan =TEXT(B19,"mmm")
1/1/2009 January =TEXT(F12,"mmmm")
1/1/2009 Thursday =TEXT(F13,"dddd")
1/1/2009 01-01-09 =TEXT(F14,"mm-dd-yy")
1/1/2009 Jan-01-09 =TEXT(B22,"mmm-dd-yy")
1/1/2009 Thursday, January 01, 2009 =TEXT(B23,"dddd, mmmm dd, yyyy")
1/1/2009 Month beginning January 01, 2009 ="Month beginning "&TEXT(B25,"mmmm dd, yyyy")
TODAY Saturday, 7/3/2021 =TEXT(TODAY(),"dddd, m/d/yyyy")
mm dd, yyyy")
Return to TOC
FRP301 Formulae

01-Intro
=COUNTIF(Range,Criteria)
=SUMIF(Range,Criteria,RangeToSum)
=COUNTIFS(CriteriaRange1,Criteria1,CriteriaRange2,Criteria2) Excel 2007/2010
=COUNTIFS(TRC,$J24,DAY,K$23) ~ example from the exercise
=SUMIFS(RangeToSum,CriteriaRange1,Criteria1,CriteriaRange2,Criteria2) Excel 2007/2010
=SUMIFS(Quantity,TRC,$J37,DAY,K$36) ~ example from the exercise

02 -IF
=IF(ConditionToTest,IfTrue,IfFalse)
=IF(AND(Condition1,Condition2, …,Condition30),"IfTrue,IfFalse)
=IF(OR(Condition1,Condition2, …,Condition30),"IfTrue,IfFalse)

AnswerIfTrue
(example) =IF(ISERROR(H3/D3)," ",H3/D3)
=IFERROR(FormulaToBeEvaluated,”AnswerIfError”) Excel 2007/2010

Multi-condition
=IF(Condition,IfTrue,[IfFalse],IF(Condition,IfTrue,[IfFalse],IF(Condition,IfTrue,IfFalse,)))

Multi-condition using VLOOKUP

=IFERROR(O3*VLOOKUP(E3,table,2,0),””) Excel 2007/2010

03-VLOOKUP
=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,Unsorted[false]OrSorted[true])
=VLOOKUP($B4,CT_tbl,COLUMN(B1),1) ~ example from exercise

04-LARGE, SMALL
=RANK(CellRef,Range,1 or 0) where 1 = ascending order and 0 = descending order

=SMALL(LIST,5) (Range,RankPlaceSought)
=LARGE(LIST,4) (Range,RankPlaceSought)
=SUMIF(List,">="&LARGE(List,5),List) (Range,Criteria,RangeToSum) Sums a range
=SUMIF(LIST,"<="&SMALL(LIST,5),LIST)
=MIN(LIST) (Range) Shows the lowest value
=MAX(LIST) (Range) Shows the highest value

Conditional Formatting
=A7>=LARGE(LIST,5) shows top five
=A7<=SMALL(LIST,5) shows bottom five
08-SUMPRODUCT
=SUMPRODUCT((Range1=Criteria)*(Range2=Criteria)*…(Range29=Criteria)*RangeToSum)
=SUMPRODUCT((TRC=$J37)*(DAY=K$36)*Quantity) ~ example from Intro to find a sum

=SUMPRODUCT((Range1=Criteria)*(Range2=Criteria)*…(Range30=Criteria))
=SUMPRODUCT((TRC=$J37)*(DAY=K$36)) ~ example from Intro to find a count

Algebraic operators: =,>, <,<=,>=,<>

Miscellaneous

=ROW(A1) equals 1
=ROW(A2) equals 2 etc.
=COLUMN(A1) equals 1
=COLUMN(B1) equals 2 etc.

State Fiscal Period

=IF(MONTH(B4)+6>12,MONTH(B4)-6,MONTH(B4)+6)
Federal Fiscal Period
=IF(MONTH(B4)+3>12,MONTH(B4)-9,MONTH(B4)+3)
State Fiscal Year
=IF(MONTH(B4)+6>12,YEAR(B4)+1,YEAR(B4))
Federal Fiscal Year
=IF(MONTH(B4)+3>12,YEAR(B4)+1,YEAR(B4))
State Fiscal Quarter
=MOD(CEILING(22-7+MONTH(B4),3)/3,4)+1
Federal Fiscal Quarter
=MOD(CEILING(22-10+MONTH(B4),3)/3,4)+1
Substitute your target cell for B4 in each example
Return to TOC

Instructor Notes

Pivot Tables

DataPig Periodic Table of Keyboard Shortcuts