Tuesday, November 4, 2014

BETTER NEIGHBORHOODS: Investment in Our Schools (Woodbridge Vision - Quarterly Newsletter)

BETTER NEIGHBORHOODS

Investment in Our Schools

As our county continues to grow, it is important to keep investing in school infrastructure in the Woodbridge District. Overcrowded classrooms are not ideal for anyone. The Prince William County School Board adopted the Fiscal Year 2015 Capital Improvement Plan (CIP) in conjunction with the Board of County Supervisors to fund five capital improvement projects to schools in the Woodbridge District. They include:

Featherstone Elementary School: A six-classroom addition ($8.8 Million) is scheduled for 2015.
Rippon Middle School: A nine-classroom addition ($7.4 Million) is scheduled for 2016.
Belmont Elementary School: A four-classroom addition ($8.6 Million) is scheduled for 2017.
Kilby Elementary School: A brand new, replacement building ($31.4 Million) is scheduled to open in 2017.
Leesylvania Elementary School: A four-classroom addition ($6.9 Million) is scheduled for 2019.

In total, five schools will receive over $60M through 2019 to expand classrooms and reduce classroom sizes in Woodbridge.

Tuesday, August 13, 2013

Showing Formulas in Excel

Did you know that you can show all formulas in excel at one time?

To quickly show all formulas in your Excel spreadsheet hold down the CONTROL key on the keyboard and press the grave accent key ( ` ).

· This key is located next to the #1 key on the top left corner of the keyboard and looks like a backwards apostrophe.

· Showing formulas does not change the spreadsheet, only the way it is displayed.

Showing formulas has several uses:

· Makes it easy to find cells containing formulas

· It allows you to quickly read through all formulas to check for errors

· When you click on a formula, Excel outlines in color the cells referenced in the formula. This helps you to trace the data being used in a formula.

· Print spreadsheets with show formulas turned on. Doing so, will allow you to search a spreadsheet for hard to find errors.

Save time by using Excel's Concatenate text function

Did you know…that you can add a bunch of text values into one cell?!?!

Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1&B1 returns the same value as =CONCATENATE(A1,B1).

For Example: CTR (6 Week Basic Labor report Download)

If you want a Full Name field, you can concatenate First Name and the Last Name column

=CONCATENATE (D3," ",E3) (yellow column)

FYI…typing ," ", into the code creates a space

\\ffx-filer1a\apps\Impromptu 7.1\Reports\ArgonST Custom Reports\Projects\Incurred Cost\6 Week Basic Labor report Download.imr

Removing the Define Code Function in MS Project

Did you know…you can remove the automated WBS structure function?

Have you ever had a problem removing the automated WBS structure function in MS Project?

Here is how to remove it:

1. Select Project > WBS > Define Code…

2. Delete the Project Code Prefix (i.e. 01569) and delete the Sequence Level (i.e. Characters (unordered))

3. Select the OK button

Num Lock key Startup

Did you know…there is away to automatically disable / enable the Num Lock key when you start your computer?

Num Lock key Startup

Click Start, click Run, and type regedit to open the Windows registry editor.

In the registry, open the below folders.

HKEY_CURRENT_USER\
Control Panel\
Keyboard\

Within the keyboard folder, you should have a string value named "InitialKeyboardIndicators" with a value of 0, 1, or 2. Below is the explanation of each of these values.

0 = Num Lock is turned OFF after the logon.
1 = Disable Num Lock.
2 = Numlock is turned ON after the logon.

Networkdays Formula

Did you know…that there is a formula that tells you how many working days there are between two given dates?!?!

Start_date is a date that represents the start date.

End_date is a date that represents the end date.

Holidays is an optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) of the serial numbers that represent the dates.

Examples

End of the Week Helpful Hints: Custom formula error message...

Custom formula error message...

Did you know…you can makes it easy to display a custom error message for formulas that produce an error?

ASAP Utilities » Formulas » Custom formula error message...

Instead of an error such as #N/A or #VALUE!, you can have your own (more logical) error message displayed when a formula results in an error.
For example, if you have a VLOOKUP formula but no result is not found then the formula will then display the value #N/A. You can this utility to tell Excel what it should display when the formula results in an error, for example to display nothing (an empty result) when no result is found or a user friendly message such as "country not found".

This utility wraps an =IF(ISERROR(old_formula),[value in case of error],old_formula) formula around the existing formulas. You can do this manually, but it is easier and faster with help of ASAP Utilities.

This utility has two advantages compared to writing the =IF(ISERROR()) formula manually:
1. It is easier and quicker because you don't have to type in the formula.
2. You can also use this utility on a range of cells with different formulas.