SCA Computer Professional Exemption Criteria

Consideration of Computer Professional vs Non-Exempt

NOTE - this information and these values were accurate in 2010 and may no longer be valid or applicable in any way.  Obviously, this is a process only as the comparison to job duties / job descriptions is not provided in the below explanation.

 

I compared the job duties outlined in the job descriptions to the duties listed in the FLSA's computer professional exemption test.  I believe that under Federal law all positions would be exempt based on the job duties and the overall nature of the jobs.  As far as California regs, I found that the computer professional exemption would apply as well.  However, the minimum hourly rate for a California Computer professional is much higher than the minimum hourly rate established under the FLSA.  For 2010, Computer professionals must earn a minimum fixed salary of $79,587.50 per year or $37.94 per hour for all hours worked in addition to meeting the duties requirements outlined below.

Update: Additional information can be found at this link http://www.dir.ca.gov/dlse/dlseWagesAndHours.html under the heading "Exemption for computer software employee (Labor Code Section 515.5)"



vlookup on multiple criteria

This site explains how to perform vlookup on multiple criteria using an array

http://support.microsoft.com/kb/59482

I modified the forumla slightly to provide a "0" response if one of the lookup values is blank, thus preventing a N/A# error

{=IF(R5="",0,(INDEX('Rate Table'!$F$5:$F$63,MATCH(A5&D5&R5,'Rate Table'!$B$5:$B$63&'Rate Table'!$E$5:$E$63&'Rate Table'!$A$5:$A$63,0)))}

The absolute key here is that you cannot just hit ENTER, you must hit ENTER+SHIFT+CTRL in order for excel to recognize this as an array formula.  You do not enter the "squiggly" brakets, excel will do that automatically if the formula is entered correctly.

Recipe for Black Bean Goat Cheese Dip

This is delicious.  Black Bean Goat Cheese Dip

Dash's First Nosework 1 Trial

 

 

I am super proud of Dash.  He handled the atmosphere of the trial beautifully which is a big accomplishment for him.  I also think he had a really good time and he did just great!  I wrote this throughout the day so I wouldn't forget how each element went.

 

Element 1: Interior
Dash was great!  He went right in the room and straight to odor. I almost called it but wasn't sure *exactly* where source was and wanted to take my time to be sure.  So he did one quick circuit of the room and I could tell he was working and not exploring and came right back to it and I called it and we were right.  I feel like he found it in about 40 seconds. Will be interesting to find out our actual time. Not that I care about time at this point, I just want him to have fun and do well.

 

Element 2: Vehicles
I was apprehensive about this element because we haven't practiced much.  But told myself to relax and trust my dog. There were three vehicles and as Dash went over the start line he was walking a little timidly and not his normal forward walk.  He was completely bypassing the first vehicle and was headed past the second vehicle.  I was a little worried that he wasn't focused on the vehicles but I could hear Ron's guidance that he gave in the morning briefing: "Don't think for your dog!  He knows what he's doing.  Trust your dog!".  As Dash got closer to the second vehicle he turned hard to the left and stuck his head right into the wheel well and was spot on source!  He had basically bee-lined right to it!  I think we were under 30 seconds.

 

Now a couple hours until the next two elements. I will try not to psych myself out in the meantime!

 

Element 3: Containers
Dash started this one a little distracted and was not very focused on the boxes. He wasn't being methodical. But I kept subtly redirecting him to different areas. I think he was somewhat working the whole time but not 100% focused.  I could see his body movement change just a little and he hit a box and I called it immediately. I was right but maybe should have waited another second to be positive.  The judge complimented me on my handling for staying calm and directing him without interfering with him (big grin - I have a great instructor!).  Our time felt very very long. I think they said we were at 1:30.

 

Element 4: Exterior
Dash rocked this one!  He came off the start line and worked his way down the wall of the planters and turned the corner and stuck his nose right on source. This one and vehicles were definitely the best. This one felt like 15 or so seconds.

 

So now we hang out a few hours until they do awards.

 

Dash and I are settled in at home now  He slept like a log the whole way.  And the results are....

• Container 1:31.98
• Interior 0:35.41
• Vehicle 0:12.89 we got First place out of about 48 dogs (and he received a Pronounced mark from the Judge)
• Exterior 0:10.02 we got First place out of about 48 dogs (and he received a Pronounced mark from the Judge)
• Total time 2:30.30

In hindsight I would change one thing about the way I worked containers.  The setup was such that the start line was at about a 45 degree angle to the boxes.  So if you "squared up" on the start line so that you were directly facing the line, that meant your dog was only looking at the top left corner of the search area with the majority of the boxes off to the right.  Dash went straight to where I had him pointed...the top left area with just a few boxes.  If I were to work it again, I would "square up" on the boxes prior to my search instead of on the start line since the dogs don't realize there is tape or a start line.  We still would have crossed the start line, it would have just put his focus on the whole area.  But truly, I couldn't be happier!

ITAR stuff

Current as of 16 May 2012

For ITAR Violations, in addition to the penalties to the company, the individual employee may be faced with: 

Willful Violations:  "Individual - A fine of up to $250,000 or imprisonment for up to ten years, or both, for each violation."
Knowing Violations:  "Individual - A fine of up to the greater of $50,000 or five times the value of the exports or imprisonment for up to five years, or both, for each violation."

Note that a single case may involve multiple violations and these penalties are for each violation.

source:  http://www.law.cornell.edu/uscode/html/uscode50a/usc_sec_50a_00002410----000-.html
TITLE 50, APPENDIX App. > EXPORT > § 2410 Violations

Kudos Received

8/30/11 Tom McCabe

Amy, sorry my flight was late and could not review. But I would not jhave changed a thing. Perfect presentation and more importantly, perfect facilitation today. Thank you for the professional competence you showed today in leading the team through your very complex and challenging ares. I think youmade a huge difference I'm making the workshop a resounding success. Got nothing but positive feedback from some newly opened eyes!

VR,

Tommy

12/10/10 Wayne Gibbons

Amy….my sincere thanks for your level of support to this office over these past five weeks.  Your daily coordination with our govt. counterparts and this office in coming to successful closure on a multitude of contract mods for both MTSS and SCETC/ATG has been no small task.     Compounding the timely execution of the contract mods was  my short tenure here and the absence of our operations officer.  In spite of these personnel handicaps, I believe we were successful in meeting govt. requirements…….due in large measure to your support.  Again, thanks!

Wayne

11/21/10 Jim Hawn

Just wanted to tell you that Amy has been doing heroic work on the ATG contract, dealing with all the changes and many frustrations as we've gone through this process.  Well deserving of some kudos from above.

Jim

Headers in Excel

Notes on how to set up "dynamic" headers in Excel so you can update the variable data within a worksheet and through running a Macro will then update in each page header.  This allows you to avoid having to update the header data individually on each worksheet.

-------

DO NOT RENAME THIS WORKSHEET TAB - IT MUST BE "Sheet4"

 

Information to include in cell A3:  "Proposal Dated: 21 November 2011"  Note, this RightHeader information MUST remain in cell A3

 

To insert this information into your header:

1) SAVE your file

2) SAVE AS a new revision (note, you must select "Save as type" as "Excel Macro-Enabled Workbook")

*These two steps are important because this "header process" is done by MACRO

There is no way to UNDO a MACRO once it has been run             

You can overright the information by changing the text in cell A3 and then rerunning the MACRO            

But, if something goes amiss and messes up all the other page formatting you will be very upset that you skipped these two steps, I promise.

3) Click on the "Developer" tab

4) Click on the "Macros" button

5) Select:

"ThisWorkbook.PrintReport"

6) Click "Run"

Note, if your Developer tab isn't showing:

Right click on any other tab (ie Page Layout)

Select "Customize the Ribbon"

On the right side of the window, make sure the check box beside "Developer" is checked           

 

The macro code should be added to "ThisWorkbook" under the "Genaral" tab as a "Print Report" and is written as follows:

 

Sub PrintReport()

    Dim wks As Worksheet

    Dim ftr

    ftr = Sheet4.Range("A3").Value

    For Each wks In Worksheets

        With wks.PageSetup

            .RightHeader = "&""Times New Roman,Italic""" & ftr

        End With

    Next wks

End Sub