Free Download

Learn 7 Reasons Why Becoming a Technical Writer is a Great Career Move!

New Graphic

PLUS, Get a FREE
TECH WRITING TIP
Every Week! 

Subscriber Counter

We value your privacy. We will not share your information with anyone.

An Embarrassing Start to My Technical Writing Career

(Please leave a comment, good or bad, I appreciate them all. What questions do you have? I’m interested to know. Many thanks!)

© Ugur Akinci

I have a confession to make today…

I’m embarrassed and actually still blush a little when I remember how I started my tech writing career.

The year was 1998.

At the time I was a reporter for a print daily covering the U.S. State Department and the U.S. Congress.

It was an exciting job which allowed me to rub elbows with the rich and famous, the movers and shakers of the nation’s capital.

These were all powerful men and women, way above my socioeconomic class and pay grade.

If it weren’t for my credentials as a journalist, I’d never have the chance to share the same room with them.

Once for example I rode the same elevator with the late Sen.Ted Kennedy of Massachusetts. Perhaps a trivial moment by the standards of many people but I still remember that day.

Other times I would attend the press briefings at the White House even though I was not an accredited White House reporter. To be in the same room with a Cabinet Secretary or the President of the United States is an experience I’ll cherish as long as I live.

However, the truth is I wasn’t making any money at all.

The print journalism was already in trouble and I knew I had to something else if I were to take care of my family.

One morning as my wife was leaving the house I asked her where she was going. “To my head hunter,” she said. Back then she was a newbie computer programmer looking for a job.

“You wanna come too?” my wife asked.

And for no good reason at all, for reasons I still cannot explain, I said “Yes, why not?”

So we went together to this glass-and-chrome employment agency office in a commercial tower in Rockville, Maryland.

After the usual exchange of pleasantries, my wife introduced me as a writer in-between jobs, which in a sense was true.

After she listened to me for a few minutes, the recruiter said something that changed my life forever:

“I might have something for you… would you considering a technical writing position?” she asked.

And like an idiot, I said … “What is that?”

My god, I still cringe when I remember that moment. Whew!

The truth is, like millions of people in the world, I also had not heard of “technical writing” before.

She explained to me patiently what tech writing was and why it would be a great fit for me given my technical and creative sides. I kept nodding my head and the rest is history, as they say.

So if you at this point also do not have a very clear idea of what technical writing is, it’s completely understandable because once upon a time I didn’t know what the heck it was either. There’s a beginning to everything, isn’t it?

 

How to Create a Daily Job Alert Feed

WORKING - MorgueFiles© Ugur Akinci

Here are three email job alert feeds that I use all the time. When you create any of these, you’ll find an email in your inbox every day listing the jobs available for your search keyword(s).

GLASSDOOR

1) Create a free account.
2) Go to https://www.glassdoor.com/index.htm
3) Make a search with keywords, company, or title. For example let’s use “writer” as a search keyword. For the city, we’ll use “New York City”.
4) Click Search. This will take you to search results page.
5) Click the Create Job Alert button to receive daily job alerts about writing jobs in NYC.

GOOGLE

1) Sign on to your free Google or Gmail account.
2) Go to https://www.google.com/alerts
3) Enter a keyword into the “Create an alert about…” field.
4) Configure alert options by clicking the Show Options drop-down list.
5) Click the Create Alert button.

CRAIGSLIST

1) Log in to your free Craigslist account.
2) Go to the Craigslist page for the city you are interested in.
3) Click the JOBS category title.
4) In the JOBS page, make a search with a keyword.
5) Click Email Alert link right next to the search field.

Free photo courtesy of MorgueFile.com

Selected Technical Writing Jobs for Jan 16, 2016

Microsoft Word Tutorials: For Word 2010 and 2013, Vol 1

Microsoft Word Tutorials: For Word 2010 and 2013, Vol 1

TCC has a new logo!

Here is our new logo that we’ll use in all our communications:

TCC_LOGO_JPG

 

Did you like it? Let me know what you think. Thanks. Ugur

How to Write Cause and Effect Sentences and Paragraphs Properly for Building Convincing Arguments

How to Write Cause and Effect Sentences and Paragraphs Properly for Building Convincing Arguments© Ugur Akinci

Cause and Effect Sentence

Writing a cause and effect sentence is very commonplace in both fiction and non-fiction works.

Its structure is very simple and straight forward.

There are two basic types of cause and effect sentences:

1) You start with a CAUSE, then connect it to an EFFECT with a CONJUNCTION.

2) You start with an EFFECT, then connect it to a CAUSE with a CONJUNCTION.

An alternative form starts with the CONJUNCTION:

3) You start with a CONJUNCTION, then follow it with a CAUSE, comma, and an EFFECT.

What is a “Conjunction”?

A conjunction is a sentence component that JOINS two clauses, two parts of a sentence.

Although it sounds complicated, actually it’s not since you already know and use dozens of conjunctions in daily life.

For example, every time you use AND you are using a conjunction.

Other examples: OR, NOR, YET, THEREFORE, BECAUSE, SO, WHEN, AFTER, BEFORE, SINCE, etc.

1) Sentences that start with a CAUSE and end with an EFFECT

“He studied hard for the SAT exam [CAUSE] and [CONJUNCTION] got a perfect 800 [EFFECT].”

“They trained hard [CAUSE] but [CONJUNCTION] they still lost the match [EFFECT].”

2) Sentences that start with an EFFECT and end with a CAUSE

“She has been unhappy [EFFECT] since [CONJUNCTION] she was assigned to this case [CAUSE].”

“We chose him [EFFECT] due to [CONJUNCTION] his MBA [CAUSE].”

3) Sentences that start with a CONJUNCTION

“Because [CONJUNCTION] of the severe weather alert [CAUSE], all flights have been cancelled [EFFECT].”

“Now that [CONJUNCTION] you’ve seen the evidence [CAUSE], I’m sure you can write a better report [EFFECT].”

Cause and Effect Paragraph

Writing a cause and effect paragraph is not that hard: you can either start by a cause and then explaining the effects; or the other way around – start with the effect and explain the causes.

Let’s examine these two different types of paragraphs one by one:

1) Paragraphs that start with a CAUSE

Let’s say you start your paragraph with “rising fertility rate in rural villages.” That’s a CAUSE.

What would be the effects? Let’s mention three:

  1. Population increase.
  2. Falling living standards (if agricultural productivity remains the same).
  3. Thus eventually a migration to cities.

Importance of Assumptions

Here as you can see the crucial component is the ASSUMPTION that agricultural productivity will remain the same. This is important because if the productivity goes up it can support a growing population and thus there won’t be any urban migration.

You start with a TOPIC SENTENCE which describes the CAUSE. Then you continue by listing the EFFECTS. Important thing is to make clear what your ASSUMPTIONS are including in your reasoning and mentioned very clearly.

Example:

“Fertility rate has risen 7% in Western XYZ between 1990-2010 [THE CAUSE].

One effect of this would be increased pressure on food resources, if we assume that the agricultural productivity remains the same [THE ASSUMPTION].

A second and related effect would be dropping standard of living in Western XYZ.

We should expect this to lead to an eventual migration to the cities in the region like La Capital [THE EFFECT].”

2) Paragraphs that start with an EFFECT

You start with a TOPIC SENTENCE which describes the EFFECT. Then you continue by listing the CAUSES. Important thing again is to make clear what your ASSUMPTIONS are.

Example:

“Those with a college degree are shown to earn a million dollars more over a lifetime than those who do not go to college at all [THE EFFECT].

One reason why this is so is the higher paying jobs available to college graduates [CAUSE 1].

Another reason is college graduates are more comfortable with high-technology which helps them start high-profit businesses [CAUSE 2].

Of course, we are here assuming that the two groups (college and non-college) start off their adult lives more or less from the similar socioeconomic backgrounds.”

As you can see, even though there is a structure to the way a cause-paragraph is written [TOPIC SENTENCE first, followed by supporting effect or cause sentences], there are no standard phrases or keywords that you need to use while writing them.

As a writer you should use your creativity and come up with the correct style to stitch together the cause and effect elements together as shown in the above examples.

5 Reasons Not to Convert to Structured Authoring

5 Reasons Not to Convert to Structured Authoring© Ugur Akinci

Introduction

XML-based structured authoring has been one of the hottest topics in the technical writing community for quite a while. Shifting from traditional documentation to “structured documentation” has been the “holy grail” of top-echelon technical communicators for the good part of the last decade. In one survey reported by Scott Abel of The Content Wrangler, for example, 44% of the companies surveyed said they were using XML-based structured authoring. That’s an impressive number indeed.

Yet, as I can tell you from my own personal experience as a Fortune 100 technical writer, the transition is not always smooth and easy. Even though they are usually touted as the next best thing after sliced bread, structured authoring and platforms like DITA (Darwin Information Typing Architecture) have their own disadvantages and hurdles as well.

Here are five of them.

The Need

The most serious obstacle standing in the way of converting to structured authoring is this: perhaps you do not have a real need, a good business case why you should convert. Ask yourself: will your documents be read by customers in different countries talking different languages? Will the content of your documents be published in many different formats like PDF, HTML, digital content on mobile phones and pads, and even in publicly accessible kiosks? Will they be updated regularly or frequently? Will you reuse the same modular content in different combinations to create different deliverables? You need to give a strong “Yes!” answer to these questions to justify the conversion.

The Cost

The transition takes a serious commitment of resources. You need to purchase not only a reliable, robust and scalable CMS (Content Management System) but also hire the correct SMEs (Subject Matter Experts) to lead and manage the transition. We are talking about an investment of not hundreds or thousands of dollars, but easily of tens of thousands of dollars, either paid upfront or budgeted monthly. In some cases the total cost can climb up to well over six figures. When they hear the real numbers, most small and medium businesses have a change of heart and decide that perhaps they should “wait a little more” before taking the plunge.

Management Buy-In

Structured authoring requires cleaning up the legacy files. DITA expert JoAnn Hackos of ComTech suggests four kinds of decisions that documentation managers need to make: 1) What to convert, 2) What to reuse, 3) What to rewrite, and 4) What to leave behind (see https://www.youtube.com/watch?v=x8lTRxzh7b0).

To get the management agree on all these four questions is a monumental task in itself since it can get political easily. Managers protect their own turfs and area of operation. Getting rid of certain documents, rewriting others, or changing their mode and scope of distribution affect their own decision making autonomy directly. So it sometimes becomes an inter-departmental battle to decide what to do with the legacy documents. That in itself may delay the conversion significantly as well.

Staff Buy-In

Structured Authoring has a steep learning curve. Training not only takes time but money as well. You need to have a team of technical writers willing to make the transition by learning new tricks and devoting themselves to the conversion. When the team leader or one of the writers support the decision but the others don’t, team spirit and productivity suffer. Some writers love the way they traditionally do their job and they are threatened by this “new hi-tech mumbo jumbo.” It’s totally out of their comfort zone; and so they resist the process.

Thus even when the management commits the appropriate resources, internal staff conflict can make the transition a most unpleasant experience indeed.

The Structure

Even if you answered all the above concerns satisfactorily, you’ll still need to structure the conversion, as all structured authoring experts agree. And by “to structure” this is what they mean: you cannot one day just start slapping XML tags to document components and think you’re converting them into “structured documents.” The conversion needs a much more comprehensive effort than that.

You first of all need a “Content Strategy.” You need to know where you are heading; how you will assure quality; how you will distribute the new content; how you will measure the results; etc.

After that, you need a “Content Model,” that is, which XML-based conversion platform are you going to use? Will it be DITA, one of the widely-adopted platforms, or another like DocBook, S1000D, TEI, SPFE, Markdown, or a totally custom-made platform with specific XML components for your niche?

Following that you’ll need a Pilot Study to test the limits and outcomes of the conversion. If your legacy documents have a lot of visual elements embedded into highly-designed page layouts, for example, the structured outcome may not be what you were expecting. This may give you an opportunity to tweak your style sheets and redesign your templates. During the pilot phase you may also find out that you have difficulty with some of the output formats. This is the time to correct such errors or find workaround solutions. Once the pilot project starts to generate the kind of outputs you are pleased with you can go into full production and scale up your production.

As Scott Abel says: “Don’t jump in [to structured authoring] without a clear business case, a repeatable strategy, and measurable goals” (http://thecontentwrangler.com/2006/07/30/10_dita_lessons_learned/).

Conclusion

Do your homework and ask all the above questions before making a commitment to structured authoring.

This is a long-term conversion project that requires significant investment of time, money, and human capital. It’s better to stay on the sidelines and watch where this particular documentation niche is going than investing heavily because “it’s the new sexy trend to follow” and suffer in the end.

Structured Authoring and the Evolution of XML Standards - Two Perspectives on XML

 

Structured Authoring XML technical writingBy Max Dunn

I have been working with XML since it was a glimmer in the eye of Jon Bosak. In fact, before XML was conceived, there was SGML; going from SGML to XML represented a streamlining for the web, but at its core there was not much functional difference; in fact XML is a subset of SGML. The key concept of semantic markup is central to the core value of SGML/XML.

The two main perspectives I have seen are Document-centric XML and Data-centric XML. SGML initially appeared in support of document-centric work: managing all the technical documents or contracts of IBM or Boeing, for example. Charles Goldfarb has maintained that “SGML literally makes the infrastructure of modern society possible” and I think he’s right – hmm, should we blame him for the lengths to which humans have gone to destroy the earth?

The document-centric XML world is really a direct continuation of SGML. When XML came out as a standard in 1998, those of us working with document-centric XML became giddy with excitement, anticipating that the standards being proposed at the time (notably XML itself, XLink, XML Schema, RDF, XSL and pre-cursors to SVG) would finally facilitate tools that made publishing work for organizations that weren’t quite as big as IBM or the Department of Defense. The vision of a semantic web and ubiquitous XML multi-channel publishing, seemed to be growing a foundation in theories gaining critical mass, with apparent support of software companies. It appeared these vendors might actually adopt the standards of the committees they were sitting on. “Throw away Xyvision!” I told my boss at Bertelsmann, “this XSL-FO will completely revolutionize database publishing!”

We were sorely disappointed over the next five years. In the years before 1998 W3C standards seemed magical; concepts from the standards were implemented relatively quickly, without perfection but with steady progress: browser updates would reflect CSS and HTML advances; even Microsoft was shamed into some level of compliance. But the monopolistic tendencies of those on the standards committees, coupled with the academic approach of some of the standards committees, managed to make it less and less likely that a given standard would find a functional implementation.

And there was that other perspective – the data-centric side of things. For many reasons, XML was at the right place at the right time in terms of data management and information exchange. In fact, the very year that XML became a standard, it also became the dominant way that machines (servers) talked to each other around the world. Highly convenient for exchanging info, as firewalls would tend to block anything but text over http, while XML markup would allow any sort of specification for data structures, and validation tools would ensure no info was lost.

In 1998, when you asked a programming candidate “what do you know about XML?” only the document-centric people would know anything. By 2000, everyone doing any serious programming “knew” about XML. Trouble was, they typically knew about “XML” only in the much easier-to-use, irrelevant-to-publishing, sense.

And the standards now had to accommodate two crowds. The work of the W3C XML Schema Working Group, in particular, showed the disconnect. Should a schema be easily human readable? What was the primary purpose of Schema? Goals were not shared by the document- and data-centric sides, and data-centric won out, as they have tended to dominate the XML space ever since that time. RELAX NG came about as an alternative, and if you contrast RELAX NG with W3C Schema, you will see the contrast between the power of a few brilliant individuals aligned in purity of purpose and the impotence of a committee with questionable motives and conflicting goals. Concurrent with a decline in the altruism of committee participants was the huge advance of data-centric XML and the disproportionate representation of that perspective.

Ten years later, we find in the document-centric world that toolsets related to XML in a data sense – parsing, transforming, exchanging info – have made great leaps forward, but we are in many ways still stuck in the 1990s in terms of core authoring and publishing technologies. It is telling that descendants of the three great SGML authoring tools as of 1995 – FrameMaker+SGML, Arbortext Epic, and SoftQuad’s Author/Editor, are, lo and behold, the leading three XML authoring tools in 2009.

There have been some slow-paced advances in document-centric XML standards and tool chains as well, especially the single bright light out there for us, Darwin Information Typing Architecture (DITA) which came out of IBM like XML itself. Yet standards for rendition, XSL-FO and SVG especially, have not advanced along with core proprietary rendition technologies such as InDesign, Flash, or Silverlight, though all of these enjoy nicely copied underpinnings pillaged from the standards. More important, nothing has stepped in to replace the three core authoring tools: the “XML support” of Microsoft Word and Adobe InDesign, for example, do not approach the capabilities of a true XML authoring application. There are a proliferation of XML “editors” but most of the new ones are appropriate for editing a WSDL file or an XML message (the data-centric forms of XML), not a full-fledged document.

Meanwhile, on the data-centric front, XML has simply permeated every aspect of computing. There are XML data types in database systems, XML features in most programming languages, XML configuration files at the heart of most applications, and XML-based Web Services available in countless flavors.

Document-centric XML is simply a deep challenge that will take more time (and probably more of a commercial incentive) to tackle. For the time being, structured authoring managed the XML way is still implemented mainly by very large organizations: such an approach has “trickled down” from organizations the size of IBM to organizations the size of Adobe (which does, in fact, use DITA now), but there are not tool chains yet available that will bring it down much further. The failure of the W3C XML Schema Working Group to provide a functional specification supporting document-centric XML can hardly be underestimated.

As long as content is not easily authored in a semantically rich, structured fashion, the vision of the semantic web will remain an illusion. When and if document-centric XML gets more attention from standards bodies and software vendors, human communications will become far more efficient and effective.

Max Dunn has been programming typographical output for over 15 years. In 2000, after 4 years directing programming at Bertelsmann Industry Services, Max founded Silicon Publishing, a development company specializing in document generation and dynamic web site automation.

TOP 3 Ph.D. Programs in Technical Communication in the United States

© Ugur Akinci

A full-fledged doctoral program that focuses exclusively on technical writing and communication is still a rare bird out in the market today.

Here are the top 3 Doctor of Philosophy (Ph.D.) programs in the United States on technical communication – the highest academic degree you can get as a technical writer and communicator.

TOP 3 Ph.D. Programs in Technical Communication

1) Illinois Institute of Technology

Name of the degree: “Ph.D. in Technology and Humanities” (used to be called “Ph.D. in Technical Communication”)

This is not a practical hands-on program that prepares technical writers for the real world of technical writing out there. However, if you’d like to be an academic and do research and teaching in a university setting in the field of technical communication then this might be what you are looking for. It is a 72-hour program beyond the bachelor’s degree. Students who have earned a master’s degree in a relevant field may transfer up to 30 credit hours.

For more info: https://humansciences.iit.edu/humanities/programs/graduate-programs/phd-technology-humanities

TOP 3 Ph.D. Programs in Technical Communication

2) University of Minnesota

Name of the degree: “Ph.D. in Rhetoric and Scientific and Technical Communication (RSTC)”

This is also a research degree aimed at preparing technical writing students for faculty positions. It is not designed to prepare technical writers to work in government and private sector.

Ph.D. candidates must earn a minimum of 42 credits in coursework, at least 27 of which must be taken in Writing Studies classes and seminars.

For more info: http://writingstudies.umn.edu/grad/phd/

TOP 3 Ph.D. Programs in Technical Communication

3) Texas Tech University

Name of the degree: “DOCTOR OF PHILOSOPHY IN TECHNICAL COMMUNICATION & RHETORIC”

The program provides a broad base to conduct research in technical editing, design, rhetorical theory, online documentation, publications management, and usability testing.

60 credit hours are needed to complete the program.

For more info: http://www.depts.ttu.edu/elearning/doctoral/technical-communication/

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.

Proposal Planning and Writing for RFPs: Write Great Proposals to Win U.S. Government Contracts

6-5-2015 2-31-32 PM

Proposal Planning and Writing for RFPs” is a 51-page (8.5” x 11”) comprehensive volume describing in over 10,000 words every aspect of responding to a government RFP (Request For Proposal).

This e-book even covers the questions that need to be asked to decide whether an RFP is the correct one, way before the prosal writers type the first word on their keyboards.

Government proposal writing is a fast changing field and thus RFP how-to guides need to be updated on a regular basis. This edition includes the latest developments and references in the field.

Proposal Planning and Writing for RFPs” is researched, developed and written over a 6 month period with the following two groups of audiences in mind:

1) BUSINESS and TECHNICAL WRITERS assigned to write a proposal in response to an RFP. There is plenty in here to guide a writer from start to finish, including a detailed description of every component that a good proposal needs to have.

2) PROJECT MANAGERS whose jobs are much harder since not only they need to hire and direct the RFP writers, but they also must first evaluate if the RFP is actually the right one. If that research yields a positive result, then they need to shoulder the even more ardous task of putting together an RFP project team and driving the delicate process to its very end. This ebook also has chapters exclusively written for such project managers.

The main chapters are:

1) Introduction and Terminology

2) Six Set-Aside Programs (for small businesses)

3) Subcontracting facts

4) GSA Schedules

5) Focus on Selected Agencies and Resources

6) First Things First – the things you need to do to start the process

7) Questions to ask BEFORE you start to write your proposal

8) Questions to ask BEFORE you start to send out your proposal

9) Parts of the proposal

10) 5W + H Reality Check

11) Watch Out for the “Fishing Expeditions”

12) Step-by-Step Reply Process for RFP Managers

13) RESOURCES: U.S. Federal Procurement Web Sites (69 web sites)

14) RESOURCES: U.S. State & Local Procurement Web Sites (71 web sites)

15) GLOSSARY

Chapter 13 is a unique chapter: it describes a step-by-step development process for the proposal management team, starting with the assignment of responsibilities and selection of work teams all the way to writing the final draft and bringing the project to a successful conclusion.

The updated and alphabetized list of 140 federal and state procurement web sites in the resource chapters alone is worth the modest price of this comrehensive guide.

Those two chapters alone can save you untold hours of searching for the appropriate resources. Knowing where those web sites are important to find the right RFP or project bid. Now you have them all under your finger tips in two convenient lists.

Proposal Planning and Writing for RFPs” is recommended for all business teams, project managers, business and technical writers, and all those who would like to get their share from the annual $500 billion U.S. federal procurement pie.

AP Style Quiz Book: 150 Questions with Answers to Test your AP Stylebook Knowledge

51pnr5UEeYL._BO2,204,203,200_PIsitb-sticker-v3-big,TopRight,0,-55_SX278_SY278_PIkin4,BottomRight,1,22_AA300_SH20_OU01_

AP_Style_R1

AP_Style_R4

Top 7 Must-Have MS Excel Templates to Simplify Your Life

Casey-Markee_30425
By Casey Markee

If you have access to Microsoft Excel or a similar program, you can use it to simplify your life with these handy templates. These templates work in Excel and many of them work in the Open Office Calc program. There are many to choose from but here are the top 7 Excel templates that will simplify your finances and planning activities on a daily basis.

1.  Monthly Calendar Template:  You’ll never have to buy an expensive calendar again with this template. You can create professional looking calendars for every month out of the year. You can type in important events before you print off the pages. You can also customize the calendar to make Monday the first day of the week.

2.  To-Do List Template:  If you’re like most people, you have a growing to do list that needs your attention. Instead of writing your tasks down in several different places, you can stay organized with the To Do List template. The template is customizable and is very simple to use. You can type in tasks before printing or write them in later. You can even categorize your tasks to simplify your life.

3.  Printable Grocery List:  Shopping for groceries is made simple with this template to keep you organized. You can classify your purchases by sections of the grocery store so you won’t have to walk all the way across the store to get the one item you forgot. The template pack also includes a general shopping list, which is helpful during the holiday season.

4.  Personal Budget Template:  These days it seems like everyone is interested in saving money. If you need to budget your monthly income, this personal budget spreadsheet can make the process easy. This template helps you make a budget for the entire year. You can use the suggested spending categories or create your own so that it totally suits your needs.

5.  Expense Tracking Sheet:  Once you’ve built a budget, you need to keep track of how much you are spending. This can be made easier by using the Expense Tracking Sheet. It works similar to a checkbook register, but you can use different columns for separate expenses. You can use this template for expenses in any category. It is also helpful if you are doing a major remodeling project, own a small business or want to see where your money is going.

6.  Debt Reduction Snowball Calculator:  Reducing debt is a worthy goal and it can be made much easier with this spreadsheet template. There are many different ways that you can organize paying off your debt. This amortization calculator and debt spreadsheet allows you to try many different methods, including the debt snowball method, to see which one works best for your expenses. Once you play around with the different methods, you can put your plan into action.

7.  Daily Food Log:  Whether you’re trying to lose weight or you’re just on a special diet, this template can come in handy. The printable template comes with three complete days on one sheet. You can write your meals and food items on separate lines and then track calories, fat grams or food groups.

These seven templates just scratch the surface of what is possible with a spreadsheet program. By downloading these templates, you’ll be on your way to having a more organized and simplified life. Do a search on Google for them today and start simplifying your life tomorrow.

Simplify your life with one of dozens of custom Excel templates from Vertex42.com.

Mini-TOC in Adobe FrameMaker 2015 – A Life Saver!

FrameMaker 2015 MINI TOC

© Ugur Akinci

Adobe FrameMaker 2015 has been released this month (June 2015) and I’m really pleased with some of the new features they packed into this new version.

My most favorite new feature is mini-TOC which I know I’ll be using during my daily work. I’m grateful for it.

No one has any idea about the untold hours I’ve spent in the past constructing these chapter-specific mini-TOCs.

Such mini-TOCs are a must when you have chapters in a book as long as mini-books. When you have a 100-page long chapter, for example, with 20 or 30 sections in it, to have a TOC in the beginning of the chapter is a really user-friendly feature.
But until now the only way to construct such a mini-TOC was to cross-reference each and every section heading and section page number by using a table, a user-define mini-TOC paragraph tag created just for that purpose, and generating each link one by one – a very time-consuming affair.

But in FrameMaker 2015 you can create such mini-TOCs automatically and update and maintain them automatically as well.

Well done Adobe!

Avoid These Common Grant Writing Mistakes

GRANT WRITINGBy Jonathon Ross Carrington

“The economy is down.”

“I am too busy to finish writing this grant by the deadline.”

“I don’t know where to start on writing grants, and I don’t have the staff or money.”

“The funding agency has never heard of me!”

Does this sound like you? They are common excuses made by leaders of nonprofit organizations to justify the reason for not receiving grant funds. It is very easy to make excuses; however, if you don’t try, you will never know what will happen. Your programs deserve grant funding.

The real reason why your program is not awarded grant funding is because of simple, amateur mistakes in your grant proposal submission. The mistakes stem from the lack of experience with grant writing and the lack of time management and research skills. One of the biggest mistakes found in most grant applications is the lack of familiarity with the funding agency. Before you make another mistake in your grant proposal, take a look at the most commonly known mistakes made in the grant proposal process.

STAGE ONE: MISTAKES IN UNDERSTANDING THE PROPOSAL PROCESS

Submitting Generic Proposals

First-time grant seekers are unfamiliar with the general process: common grant proposal elements and how proposal writing works. There is this belief that submitting a canned grant proposal from an online template or book will do the job in receiving the grant. The canned proposal submission reveals a laziness of the applicant and disconnection from the goals and mission of the granting agency.

Not following instructions or reading the Request for Proposals (RFP)

When you do not follow instructions, you have a poor chance of receiving the grant. Foundations, corporations, and government agencies receive thousands of grant proposals, and determine your ability to follow instructions by the way the proposal is presented to the agency.

Solutions: Take time to understand the proposal process by enrolling in an online grant writing workshop or conference that teaches the basics of grant writing, or go to your local library and check out grant writing books to learn the process. Knowing your grantor is key to developing a relationship with a funding agency. Take time to learn their mission, granting purposes, and results or outcomes expected from your program.

Grant program officers look at whether or not you followed the RFP instructions. If a funding agency requests a three-year operating budget, then create one. If they request paper clips rather than staples, then use paper clips. If they only accept applications from pre-selected organizations, then don’t apply.

STAGE TWO: MISTAKES IN CREATING PROPOSAL TIMETABLES

Submitting the Proposal Late

Proposals are often received after the deadline, which is presented as a rushed and incomplete application. Applicants are known to request an extension to complete the application.

Contacting the Foundation with Last-Minute Questions

Applicants contact program officers at the most busiest times of the day. They call or e-mail with last-minute questions. Funding agencies will not answer or return your calls and/or e-mails in a timely manner.

Solutions: Create a timetable with deadlines from the start and end of writing your proposal. Timetables always change your research progresses. Visit their website first to see if a FAQ section answers any frequently asked questions. Schedule a time in advance to speak with a agency representative for additional assistance to compile all of the information you need before writing the proposal.

STAGE THREE: MISTAKES IN CONDUCTING RESEARCH

Failure to thoroughly research the funding agency’s interests

Proposals do not succeed because of its superficial research. It is not enough information to know that the foundation makes grants for education. Do they support K-12? Higher education? Adult education? Do they specialize in organizations with high poverty schools?

Focusing on the needs that your program does NOT plan to address

Applicants go overboard with information about the need of the organization rather than the needs that the project will address.

Asking for the wrong amount

Grant applicants request substantially less or more than the typical grant size of a funding agency. If you ask for less, then you have underestimated your program’s need and the agency’s giving. If you ask for more, then you have not done the sufficient research about the funding agency’s grant size.

Solutions: Identify and locate all of the information you need to develop a solid proposal. Identify the perceived need that your program addresses, the solution that your organization proposes, and the nature, mission, and methods of funding sources you hope to approach. Research past grant making history of your potential funding sources. Determine the grant size awarded to similar organizations, which is the amount that you want to request in your application.

Your research questions are thoroughly answered in the foundation’s guidelines, online research databases, the agency’s website, and the IRS 990 form. Outline how your program will deliver the services to the people who need it. Include what your organization can do for more people in receiving the grant in a general operating support request.

STAGE FOUR: MISTAKES IN BUILDING YOUR PROPOSAL’S FOUNDATION

Too much emphasis on the “why”, not enough on the “how”

When a poorly written proposal is submitted to a funding agency, reviewers have little patience for bad writing. Many novice grant writers present an overly sentimental story about the problems of their target population, and why the program should be funded rather than how the program will address the need.

Solutions: Recognize how each potential source will make a good match for your proposal. You should be equipped with the information to address the perceived problem and the proposed solution. Present a step-by-step guide for the reader on how your program will meet the need by including measurable goals and objectives and an explicit, actionable plan. Include how you will record, collect and measure information on your program’s successes and outcomes.

STAGE FIVE: MISTAKES IN PREPARING YOUR APPROACH TO FUNDING AGENCIES

Not participating in informational calls/seminars

Proposals are denied because of detailed information missed in an informational session conducted by the funding agency. Not all of the details can be found in the RFP. Many organizations have experienced cases where their proposal did not comply with a restriction explained in a meeting, disqualifying their proposal.

Preaching to the choir

Organizations assume that funding agencies know everything about the applicant’s organization, especially when describing the capacity to carry out projects, using industry jargon, and other catch phrases.

Solutions: Attend the informational seminars and calls and collect additional information and material you may need to know about the funding agency. Use simple language throughout your proposal and present a clear case about your program’s need.

STAGE SIX: MISTAKES IN WRITING THE BODY OF YOUR PROPOSAL

Not enough detail

Nonprofit executives become absorbed in day-to-day business of fulfilling the agency’s mission that certain details about the programs, organization, and mission statement often get left out of the proposal.

Too much detail

Sometimes, proposals have too much information that embellishes the problem or ideas about the project.

Submitting sloppy budgets

Program offers detect over hundreds, if not, thousands of sloppy budgets every year. They will know if you left out a major item or padded the salaries.

Inadequate/Unrealistic cost analysis

Proposals have unrealistic cost estimates that make nonprofits appears fiscally inexperienced and incompetent. Also,proposals miss the mark in including income projections, making your organization appear too dependent.

Lack of Quantitative Data

Nonprofit grants are too light on hard data, with no quantifiable objectives and results.

Not Asking for the Money

Many proposals forget to include the amount of the grant they seek in the proposal.

Solutions: Structure each section of the project. Grant reviewers are learning about your project for the first time so provide specific information. Each section of your narrative shows how the funds will be used responsibly and effectively by your organization. Prepare the budget with same care as the narrative and match each section point for point.

STAGE SEVEN: MISTAKES IN REVIEWING AND REVISING YOUR PROPOSAL

Careless Editing and Proofreading

Program officers have to read over 600 grant proposals on the same topic. The problem with some proposals is that they find themselves re-reading sentences in your proposals due to typographical and grammatical errors.

Not using the checklist provided in the RFP

Many nonprofits don’t look at the checklist provided by the funding agency. Lots of applicants leave out required pieces of the proposal, disqualifying the candidate from the start.

Solutions: After finishing your proposal, review the proposal carefully. Refer to the funder’s proposal guide and verify all of the essential information is included in the proposal. Proofread for grammar, spelling and syntax errors, and have a friend or colleague read it for you. The checklist is usually found in the guidelines; and it is important for a funding agency to know that you followed their directions and did not miss any required pieces of the application.

PHASE EIGHT: MISTAKES IN SUBMITTING YOUR APPLICATION

Simply not asking for the grant you need, or not submitting the grant at all

Grantseekers love to make excuses such as: “It’s not the right time to apply for the grant” or “The economy is down” or “I am too busy to finish the proposal before the deadline” or “Grantors don’t know who we are”.

Solutions: Submit the proposal according to the RFP guidelines in a timely manner whether or not it is the right time to apply. The economy will always have its ebbs and flows, but does not excuse your organization from asking for a grant from a funding agency. If your organization is too busy to ask for funds for a deserving program, then your organization should not even exist. Make time to ask for support for your programs, and also take time to develop a rapport with a prospective funder. Excuses are easy to come by, but you will continue to make these mistakes and never get any funding if you just don’t try.

Jonathon Carrington is a writer, consultant, and manager.

How to Use COUNTIFS Function with Multiple Criteria in MS Excel

MS EXCEL LOGO
By BJ Johnston

This article is inspired by a question I was asked by a website visitor. The question was along the lines of how to count a number of items in a list that met more than one criteria, for example how many orders of Beannie_H hats were for Size Large. The two criteria being for hats called Beannie_H and Size Large.

The easiest way to answer these type of questions is with the COUNTIFS function in Excel.

COUNTIFS is available in Excel versions 2007 onwards.

The syntax of the Formula is

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]… )

So, here is our sample extract of order data to base our query.

Order Product Size Volumes

342 Beannie_H LARGE 45

343 Beannie_H SMALL 48

344 Beannie_J LARGE 65

345 Beannie_H LARGE 100

346 Beannie_H LARGE 75

347 Beannie_H LARGE 23

348 Beannie_H LARGE 25

349 Beannie_J SMALL 78

350 Beannie_J LARGE 200

351 Beannie_J MEDIUM 100

352 Beannie_J LARGE 43

353 Beannie_J SMALL 57

354 Beannie_J LARGE 45

We want to know how many orders of Beannie_H hats in size LARGE were placed in the above list of orders.

Select the cell that you want to type the formula in

Hit = and the type COUNTIFS(

Next select the cells that contain the values you want to check for the first criterion- in this example it is the Product _Ref Column which is C2:C15

Hit comma then “Beannie_H” (Because this is a text criterion, it is enclosed in double quotation marks)

Type comma to begin the next set of criterion- in this case it is D2:D15

With a final comma we can then Type”LARGE”

Your formula should look like this

=COUNTIFS(C2:C15,”Beannie_H”,D2:D15,”LARGE”)

We have 5 orders for LARGE Beannie_H hats in our order data.

Instead of typing in criterion, you can refer to a cell instead- in which case the formula would look like this where our criteria of Beannie_H is held in cell C4

=COUNTIFS(C2:C15,C4,E2:E15,”>50″)

If you wanted to use operators such as greater than or less than or equal to (<>=), then they need to be enclosed on double quotation marks. So, your formula would look like this

=COUNTIFS(C2:C15,C3,E2:E15,”>50″) this will search for any orders that are for Beannie_H hats for volumes over 50.

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.

Principles of Grant Writing in a Recession Economy

Dr.-Jeffrey-J.-Rodman_356935
By Dr. Jeffrey J. Rodman

Christian ministries and churches have asked themselves this question. How will this turmoil affect a funding sources giving to my ministry? Is grant writing still viable in this economy? The answer is yes, grant writing is still viable, EVEN in this economy.

This does not mean any of us can continue with business as usual. We will need to adapt our strategies, but we certainly will not have to discard them. Adaptation is nothing new to grant writers. On the contrary, those of us who have written grant proposals adapt with every Letter of Inquiry, with every proposal, to every funding source…adaptation is just part of the grant writing process. If the economy started booming tomorrow, we would need to adapt to that change as well.

So, what works? How do you acknowledge economic turmoil, yet seek funding? Here are six ways you can adapt your grant development strategy to the current market:

Think Locally

This is always true. The closer a funding source is to your organization geographically, the more likely they are to fund your ministry. Moreover, in this environment, funding sources are likely to stay even closer to home.

Understand that there are real people behind these foundations who drive through your community everyday. They read the local paper. They watch the local news. Worship at a local church. This naturally compels them to want to relieve the suffering that they see. The suffering and struggles that they see are more tangible to them. If you can concretely display how your ministry is meeting the needs that they are already aware of, you are more likely to get funded.

Make it Personal

Many funding sources discourage personal contact with a foundation. You will read “no phone calls” or “initial contact through letter only.” This serves as a gate-keeping function for funding sources.

If they require a little bit more work in order to make contact, they will weed out many of the organizations that are less serious, less qualified, and less prepared.

However, it is now more critical than ever to make a personal contact with the foundation BEFORE submitting a Letter of Inquiry (LOI). Changes in the market and the economy may have changed their giving habits. Foundations that were giving 6 months ago may not be giving today.

Some funding sources are only funding existing grantees. Others are reducing award amounts or changing their focus. The only way to know this is through a personal contact with the funding source.

Focus on People

Focus on the issues that will make an impact on people. During difficult times, a stronger focus on programs and services makes for a more compelling case for funding than a new building or capital upgrade.

Discuss how your particular program will have an immediate impact on the people you serve. Often it is helpful to state a brief example of a current client served by your ministry and how your services directly benefited him, changing his life or personal situation.

Of course, it may seem that an increased focus on programs and services means you will be focusing less on operating expenses and current and future building projects. Not necessarily. Those interested in giving toward operating expenses or capital projects may be harder to find, but they are there if you spend enough time doing your research.

However, for funding sources that are interested in both programming and capital projects… lean toward a request for programming.

Keep Doing What you Do

Now is probably not the time to try out some new and innovative idea that you have to see if it will work or not. A program with a history of success will prove less risky and more fundable than a new and unproven program.

Build on your current programs. Expanding a program to serve more people and fill a community need will be attractive to the right funding source for two reasons: it accurately portrays your past effectiveness and it projects the increased benefits of expanding an already-successful program.

If you do launch a new project, make a strong case showing how your past success predicts a high expectation of success for this venture. Discuss why you are initiating a new program rather than building on existing programs. A discussion of how this fills a need in the community or target population will also be important.

Ask for the Right Amount

This is always important! Do not ask for too little or too much.

Asking a very large funding source for a small grant might seem to be a good idea. You think, “They will not even notice the $10,000 grant in the billions they give away.” But even these smaller grants require an administrative process that is sometimes quite cumbersome in very large foundations. Managing and administering funding that is for only $10,000 may require too much administration for the perceived benefits.

Of course, asking for too much money can also be a problem. This is especially true if the funding source has a stated limit on grant requests. Requesting more than the stated limit means that you did not do your research and are not following the guidelines established by the funding source.

Some funding sources perform a technical review of proposals to see if the guidelines were followed before reviewing the actual content and merits of the program and organization.

The right amount of money is based on the amount that you need to adequately run the program or provide the service. Do not try to pad the budget in case they give you less than you request and don’t ask for less than you need because you just want to bring in the funding. You will also want to fund the program through multiple funding sources. A good rule is to have no more than 25% of a program funded by any one source.

Request From the Right Funding Source

You can write the best proposal ever written. Have the most compelling need. Have a great program in a superbly run organization in a deserving community. But if you keep sending this proposal to the wrong funding sources, the proposal will NEVER get funded.

Grant writing is really a misnomer as most good grant writers spend the large majority of their time in research and only a small percentage actually writing. How much? A successful grant writer will likely spend about 85% of their time researching funding sources and matching them to their organization. The remaining 15% of the time they will spend in writing. Of this, rewriting, reviewing, and editing take up the bulk of the actual “writing” time.

The secret to great grant writing is really to perform great grant research. Better research will lead to better writing because you will have a better understanding of the funding source.

Better research will lead to better results when funding sources know that you are writing directly to them. Like each of us, a grant administrator can tell when you have sent them a general form letter that you are going to send to every other foundation in the city.

Remember, most organizations do not need 100 foundation grant awards each year. Most ministries need 5 to 10 foundation grants to augment the support they receive from individual donors, special events, service fees, and other funding sources.

Grant writing is difficult, demanding, and …worth the effort. Ministries that are willing to implement a consistent, persistent, and organized grant development strategy will see results and will find the effort to be profitable. These 6 keys to success will help guide that strategy and make grant writing profitable for your ministry, even during these turbulent times.

Jeffrey J. Rodman is the founder, President, and CEO of Here-4-You Consulting and Grant Writing providing consultation for grant writing and funding development nationally and internationally to Christian ministries and Churches. http://www.npfunds.com

 

How to Use the EXACT Function To Force Upper Case Data Entry Into MS Excel

MS EXCEL LOGO
By BJ Johnston

One of the most important factors in good data analysis is clean data. Dirty data can make even simple analysis tasks become much more complicated than they need be, or even give incorrect trends in data.

Ensuring that data is entered correctly is best carried out by enforcing data validation and essentially guiding users to enter the data to your specific requirements. Data validation can be easily controlled in Excel. Here I am going to show you how to force your users to type into Excel in UPPER case. I have found this most useful for postcode entry for the postal services.

We can force the upper case entry by using the EXACT Function in Excel along with Data Validation. Here’s how to use it:-

Select your list of cells that you wish to apply data validation to, for example it could be a list in cells A2:A20. These will be the cells that we will be using for typing postal codes in upper case.

To apply the validation formula

Home Button
Data Tab
Data Validation Button
Select Allow Custom Validation Criteria
Type the following into the formula bar

=EXACT(A2,UPPER(A2))

Then just hit Ok. You then need to drag the formula down the length of the column of cells you want this validation to apply to. In our case it is A2:A20. So, drag the formula down to A20.

That’s all well and good, the user will be warned if they do not enter upper case characters into the specified cells. If we leave this validation as is they will receive a generic message that will warn them that the value they entered is not valid.

A better solution would be a more informative message to the user, guiding them to required entry into the specified cell. This is more productive, informative and less likely to cause user frustration and compliance.

The way to do this is to create a ‘Custom Message’. So, let’s get back to our Data Validation Tab and select Error Alert.

Select the Icon to display, you have the choice of

Stop
Warning
Information

AND you can type a custom message to your users. In this example something like ‘Please Use UPPER CASE only’ would be good, and I would maybe use the warning sign as a Icon to grab the users attention.

This is an example of using a formula (in the case EXACT) with the Data Validation ensuring your data is in the correct format at entry stage to aid or enforce the practice if clean and accurate data.

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

How to Export More Than 65000 Lines From MS Access To MS Excel

MS EXCEL LOGO
By BJ Johnston

This is a problem that I have asked about many times and one that you will no doubt have come across if you use Access and Excel together and export any data from Access on a regular basis. The issue is an error or warning in Microsoft Access when trying to export data to Microsoft Excel that says

‘You selected more records than can be copied onto the clipboard at one time’ when exporting data from Microsoft Access to Microsoft Excel.

By default when exporting data from Access you would normally follow this method

  1. Select External data
  2. Got to Export
  3. Hit Excel
  4. You will be given a choice to select the destination for your data
  5. Select where you want to save your exported data
  6. In the Specify Report Options Area- you have the option to select and tick Export Data With Formatting And Layout
  7. You also have the option to open the destination file after the export operation is complete- tick if you want to utilise this option
  8. Hit OK

You may now get the above error at this stage if you have ticked the Export Data With Formatting And Layout Option and are trying to export more than 65,000 data lines

When the data is exported you can then hit Close.

From Excel 2007 onwards the capacity of Excel Rows is way more than previous versions (in fact it is 1,048,576 whereas previous versions the capacity. So, why is Access limiting me to 65000 lines?! like in Pre 2007 times.

Not quite pre- historic but it is sure as heck feeling like it when you get the above warning when exporting data.

When you select the Export Data With Formatting And Layout Option in Specify Report Options Excel will actually copy the contents to the old style Office Clipboard, hence you get the warning of not being able to copy more than the 65,000 lines.

So, to avoid the error all you need to do is un tick the Export Data With Formatting And Layout Option in Specify Report Options Excel, if it is ticked then go right ahead and hit OK. This will enable you to export more than one million lines- from Access, but no formatting or layout settings will be transferred over.

The issue is not one that is difficult to resolve but it is not an obvious solution either. But once you know why the issue is happening it is really easy to resolve.

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

How to Calculate a Rolling Or Moving Average Using OFFSET Function in MS Excel

MS EXCEL LOGO
By BJ Johnston

Calculating moving averages can be a really useful way to look at trends in your data, and we can easily set up a formula in Excel to always look at the last 3 or 6 or any numbers of months in your data.

They are one of the most used and popular indicators. The best place to start is by understanding the most basic type of trend the simple moving average (SMA). No matter how long or short of a moving average you are looking to plot and track, the basic calculations remain the same time and time again.

Let’s take a look at an example. I want to know the last 3 months average sales of my Beanie Hats… always the last three months even when my new monthly sales data is added into my spreadsheet.

I have entered the number of months I want to use for the moving average in cell G6. (In this way I can easily change the number of months I want to look at in my formula- I may at some point want to look at 6 months or 9 months). The formula in G5 ( where I want my formula result to display) reads –

=AVERAGE(OFFSET(C7,COUNT(C:C)-G6,0,G6))
Date Volumes
Jun-14 50
Jul-14 65
Aug-14 35
Sep-14 87
Oct-14 99
Nov-14 89
Dec-14 150
Jan-15 250
Feb-15 257
Mar-15 146
Apr-15 150

My Dates are in Column B and my values are in Column C and begin in row 7.

Let’s break this down and work out what Excel is doing.

First of all, the OFFSET function returns a range in Excel, and we want this to always be the last 3 (or however many specified in our G6 cell). OFFSET takes the following arguments –

reference,rows,cols,height,width

So, we will tell the OFFSET function to create a new range with the starting cell being 7 cells below C4 (the first volume cell), and continuing for 3 cells down. How does it know to start 7 cells down?

By entering COUNT(C:C)-G6 as the reference, COUNT(C:C) returns the amount of cells containing numbers in the column C.. in this case 10. Subtract 3 as we want just the last 3.

Then…

Wrap it all in the AVERAGE function. We now have a moving average calculated automatically by Excel, we can change the number of months easily by changing the value of Cell G6.

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.

How to Fix a Microsoft Excel 2010 Crash

MS EXCEL LOGO
By A. Honey

Office Excel 2010 is a very popular and useful program came with Office 2010 suite. It allows its users to create spreadsheets and do much more things than its earlier versions. However, it has been noted that Excel 2010 crashes while exiting the program, and on runtime period as well. Some users also claimed that Excel 2010 was crashed after they upgraded it from Microsoft Excel 2003. Here are some steps to prevent the program from being crashed.

1. Disable a Registry Key for LoadBehavior
2. Fix the System Registry
3. Reapply the Service Pack and Reinstall the Program
4. Disable Malfunctioning Add-Ins

Disable a Registry Key for LoadBehavior

Those who are encountering Microsoft Excel 2010 crash problem after they upgraded from Excel 2003 should perform this step. Be careful while modifying the registry. Any incorrect step may lead to system instability.

1. Click Start | Run.
2. Type RegEdit and press ENTER.
3. Expand this hive: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins
4. Double click a key named LoadBehavior to modify its value.
5. Type 0 by removing the existing value 3 and press ENTER.
6. Restart Microsoft Excel 2010.

Fix the System Registry

Due to invalid or improper entries in the system registry, Excel 2010 may crash. It’s a well known thing that if a program retrieves incorrect information from the registry, an error occurs or the program crashes.

Reapply the Service Pack and Reinstall the Program

Another cause for Microsoft Excel 2010 crash is the corrupted installation of the Service Pack or of the program itself.

To reapply the service pack, run the setup program and follow the on screen instructions. To reinstall the whole program, follow these:

1. Click Start | Control Panel.
2. For Windows XP, double click Add or Remove Programs. For Windows Vista/ 7, click Programs | Uninstall a Program.
3. Select Microsoft Office 2010 from the list of installed programs.
4. Click Uninstall button.
5. No need to uninstall any other programs in the office suite except Excel. So, click Change or Remove Programs.
6. Follow the on screen instructions, and only uninstall Microsoft Excel.
7. Re-run the setup program to install the program again.

Disable Malfunctioning Add-Ins

There is a possibility of crashing Excel 2010 by third party add-ins. Suppose, if you had installed an add-in through a program (say, a PDF creating program), and it’s not compatible with Excel.

To disable the malfunctioning add-ins follow these steps:

1. Open Excel.
2. Click the Office logo.
3. Click Excel Options.
4. Click Add-Ins tab in the Excel Options dialog.
5. Disable the newly installed third-party add-ins, if installed.
6. Click OK.
7. Restart the program for the changes to take effects.

The above guidelines allow you to take measures to fix [http://www.reginout.com/lp1]Excel 2010 Crashes and keep your Windows properly maintained. Prevention is the best cure.

To fix Hidden Errors in Windows Registry Now use this globally recognized Intel Software Partner utility here: Excel 2010 Crash Fix.

Basic Software Documentation Terms You Should Know

User Guide vs. System Admin Guide© Ugur Akinci

(Thanks to Deepti K. for her kind contribution to this list.)

It helps to know what the following are if you’re documenting any software products. It cuts down on your preparation time and saves you from getting those “funny stares” from the developers/engineers when it becomes apparent that you don’t know what you’re talking about.

Rule of thumb: always do your homework first and get the lingo down before approaching an engineer for more information.

So, make sure you’re familiar with these concepts (it helps at job interviews too):

  • A “build”
  • A “release”
  • Release notes
  • A “bug”
  • A “show-stopper bug” (or “a Blocker issue”)
  • “Bug tracker” or just plain “Tracker”
  • SourceSafe
  • Version control
  • Configuration
  • Configuration Management (also check out: Agile, a CM software)
  • Specs (or Requirements)
  • Functional specs (or Functional Requirements)
  • MRD (Marketing Requirements Document)
  • Scope document
  • Design document
  • Database (DB)
  • Relational database
  • Flatfile database
  • System architecture
  • N-tier system architecture
  • Client/Server
  • Client-side vs. Server-side (as in “Javascript is a client-side script but PHP is not”)
  • A “script” and its difference from a  “[programming] language”
  • Difference between Javascript and Java
  • Test Cases
  • Use Cases
  • Hot fix or a Patch
  • and basic terms from the Agile environment

Let me know if you can remember any other SW terms to add to this list or you need help with any of these terms.

Goal-Focused and Structured Technical Writing

© Ugur Akinci

PREMISE

  • Most of the technical documentation that exists in the world today is feature-focused.
  • It is also unstructured: there is no well-defined hierarchy between the components of the document. For example, there is no enforcement of a hierarchical rule like “every task description shall be followed by a reference section.”

PROBLEM

Most of the time the end-user has a problem to solve, not a desire to read every feature of an option. Most of the current documents do not address that end-user need since they are not written with a goal-focused framework.

FEATURE-FOCUSED TECHNICAL DOCUMENT STRUCTURE

Feature-Focused Technical Document Structure

SOLUTION

  1. Start from GOALS, that is, what the users are trying to achieve or keeping them awake at night.
  2. Determine the ACTIVITY that will make reaching that goal possible.
  3. Provide the essential INFORMATION that will make that activity possible.

EXAMPLE

  1. GOAL: To allow contractors into a site only during certain hours of the day.
  2. ACTIVITY: Create a CONTRACTOR user type with limited access code.
  3. INFORMATION: Steps to follow to create a “Contractor” user type with limited access code.

GOAL-FOCUSED TECHNICAL DOCUMENT STRUCTURE

Goal-Focused Technical Document Structure

3-TOPIC FRAMEWORK

This goal-oriented structure requires documents be written according to a 3-topic document framework currently used by some Fortune 100 corporations like Rockwell International.

  • DITA: These are the standard structured-authoring topic categories used by DITA (Darwin Information Typing Architecture) scheme. Thus, re-writing our documents by “bursting” the current feature-laden catch-all topics into smaller and leaner more-granular topics would provide a smooth transition to XML-based structured authoring as well.
  1. First topic: CONCEPT. Answers the “What is?” question. Derives from the customer GOAL or PAIN POINT.
  2. Second topic: TASK. Answers the “How do I do it?” question. Derives from the ACTIVITIES INFO needed to achieve that goal.
  3. Third topic: REFERENCE. Answers questions like “What are the specs?” or “What is the list of all the commands available?” Derives from the FEATURES DATA to support the activities in question.

BENEFITS

  1. CONSISTENCY. The topic rules built into a structured document are enforced by the structured authoring software (like Structured FrameMaker). This builds user confidence in the documents and creates a more positive user experience.
  2. MINIMALISM. Topics are kept to a minimum. Each topic addresses only one finely-tuned issue. User fatigue and cognitive overload are kept to a minimum. Comprehension and retention are maximized.
  3. REUSABILITY. Since topics are granular and modular, they can be reused in combination with other topics. For example, a topic that describes how to configure access codes can be used with creating a contractor user type. This lowers cost of authoring.
  4. LOWER COST OF LOCALIZATION. This type of documentation has proven to minimize the costs of localization.
  5. SINGLE SOURCING. Once created, this type of XML-based documents can be delivered on a number of different platforms by using the same source files, including HTML5 responsive-layout deliverables for mobile platforms, Kindle and ePub formats, MS HTML Help, Web Help, and like.
  6. ECONOMY OF UPDATES. To update such documents it is not necessary to update each deliverable individually. Once the XML-based source files are updated, they can be republished and pushed on to different delivery platforms. This lowers cost of production and distribution.

WHAT IS NEEDED?

  1. Goal-oriented structured documentation require management by-in. Without management support, the shift from unstructured to structured authoring cannot be accomplished.
  2. The writers need to have access to “customer pain-point” data. Without such data the writers would not know what the important documentation GOALS are.
  3. The writers and the management need to have consensus on the “framework,” that is, the kind of TOPICS that will be included in the documents.
  4. Additional tech writing hours may be needed to sift through both the customer goals and break down topics to individual CONCEPTS and then rebuild them again into a structured document. The initial phase might be very labor-intensive indeed. But once it is done, future updates should be easy and less labor-intensive.