Subscribe Now!

STC INDIA Presentation: Working for a Software (SW) Company

Working for a Software Company

Click  below to download the presentation slides in PDF format:

STC_INDIA_8_22_2015_PRESENTATION

How to Import a Word File into a FrameMaker Document

© Ugur Akinci

1) Create a FrameMaker (FM) file. Place your cursor in the first line of the file.

2) Select File > Import > File to browse to the Word document you’d like to import. The Import screen will display:

Importing Word to FrameMaker

3) Select the “Import by Reference” and the Word file you want and click the Import button.

4) In the Unknown File Type dialog box, select “Microsoft Word 2007” and click the Convert button:

Unkown FIle Type

5) In the Import Text Flow by Reference dialog box, leave the default values alone and click the Import button once again. FM will import the Word content.

Here is the original Word content:

WOrd version

And here is its FM version, after the import:

FM Version

It looks pretty good, correct?

Yet the looks can be deceiving since this not editable text converted into FM format yet. If you click the text in FM, the whole page will turn into an non-editable black image:

Noneditable FM

6) To convert the imported text, double click it to display the Text Inset Properties dialog box:

Text inset properties

7) Click Convert to display another dialog box:

Convert Text Insets to Text

8) Click Convert once again and the imported text will be converted into editable FM content.

How To Calculate The Number Of Workdays Between Two Dates Using NETWORKDAYS in MS Excel

MS EXCEL LOGO
By BJ Johnston

Is is easy in Excel to calculate the number of working days between two dates. Most, but not all businesses, operations or project activities and progress happen during weekdays. So, if you need to report and calculate the number of days that have elapsed between a start date and an end date of a project or project milestone for example then counting weekends in the calculation is not what you want to do, and you will need to avoid those days in your calculations. It is easy to do in Excel with the NETWORKDAYS function.

The formula NETWORKDAYS is pretty straightforward and has two required arguments or parts to it.

The syntax of the formula is

=NETWORKDAYS(start_date,end_date)

So, an example always helps when working through Excel formulas.

Below is the start date and end date of a short project. Start Date is in cell C4 and End Date is in D4.

01/01/2015-Start Date

31/03/2105-End Date

The formula calculates the number of workdays (excluding Saturdays and Sundays which is the default), in this example it is 64 days.

So, this is a straightforward calculation automatically excluding Saturdays and Sundays, but some projects could and do include Saturdays, Sundays or even both.

Well of course Excel can handle this. In this instance we can use the NETWORKDAYS.INTL function.

The difference with this formula this is that it includes an extra argument or part, a weekend code, which allows us to specify which days to exclude as a weekend day or days. The syntax of this formula is

=NETWORKDAYS.INTL(start_date,end_date,weekend)

Let’s apply the same formula- but let’s assume we know our project work was active on Saturdays also. So, we need to ensure exclude any Saturdays from the calculation of days worked on our project

So, we need to select option 17 which is Saturday only. You can choose any of the options of 1 to 17 from the drop down menu. This now increases our work days to 77 days in the period 01/01/2015 to 31/03/2015 as Saturdays are now included as normal working days and should increase the number of days worked on our project. The number of days between the two dates now increases to 77 workdays.

The NEWTWORKDAYS and NETWORKDAYS.INTL are a useful couple of Functions to have in your Excel Tool Kit.

BJ Johnston has been an advanced Excel user for 15 years and is the creator of http://www.howtoexcelatexcel.com a site that shares Excel tips and tricks with it’s enthusiastic members.