Parse Characters from a Cell

(LEFT(B55,22))

01302.03.3001.000.1000 - OY3 LABOR SUNK COSTS

will pull:  01302.03.3001.000.1000

Insert Excel File Name into a Cell

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

source of information:  http://mrspreadsheets.com/1/post/2013/01/excel-function-tutorial-7-insert-the-current-file-name-into-a-cell-with-getcell.html

Ostensible Subcontractor Affiliation links

http://smallgovcon.com/tag/ostensible-subcontractor-affiliation/

http://www.acq.osd.mil/osbp/councils/marc/resources/201111-small-business-teaming.pdf

http://www.cbh.com/teaming-agreements-and-the-ostensible-contractor-rule/

http://www.ecfr.gov/cgi-bin/text-idx?c=ecfr&tpl=/ecfrbrowse/Title13/13cfr121_main_02.tpl

http://www.ncmahq.org/docs/default-source/default-document-library/articles/cm0911---14-22

Kudos - 12 July 2014

Steve Baird regarding major proposal effort - Amy, thanks... The way you built your spreadsheet really assisted us in running all the different options in a very time sensitive environment ....it was a pleasure.

Excel formula

Old Salary X % Reduction = New Salary

When you only know the new salary and % reduction that was used, the formula to derive the old salary is:

<New Salary> / ( 1 - <Percent Reduction>)

Kudos - 25 November 2013

Deb Aitkin - I so very much appreciate your comments.  I heartily agree that Amy is a great asset to our company!  I know that MCTP has always been one of those "moving target" types of contracts and it really keeps her on her toes.  THanks again.

Norm Greczyn - I am the PM for the Cubic portion (as a sub) of the MCTP contract. Recently we went through the development of a proposal for OY 2 of this contract and then, a little over a week out from the start of the OY, we had to embark upon an extensive revision. I would like to command Amy Hunter for outstanding work on this endeavor, which was far from easy. I have now worked with Amy for two years as the PM here, and she has always been a tremendous asset: very precise, always willing to take the time to explain things to me, and tireless in her pursuit of excellence. I am very happy to have her working this contract. She takes great care of Cubic and its employees!

Disable the Similar Items Pop Up

I started getting a pop up window on shopping websites that would show me similar type items.  Turns out it was part of the Pinterest extension that I added to Chrome.  Easy enough to turn off, just go to Chrome's Settings>Extensions>Pinterest Options>Disable "Visual Deals"