PleaseTech blog

We aim to provide useful, pertinent and sometimes fun insights into the world of document collaboration and the workings of a technology company

Microsoft Word - the most complex software product in the world?

Posted by David Cornwell on 10. June 2015 11:09

Founder/CEO of PleaseTech Ltd - collaborative document review and co-authoring for the enterprise.


“Microsoft Word must be one of the most complex software products in the world” was the thought I had a couple of weeks ago whilst sitting in a hotel room in Seattle preparing to give a Word Master Class presentation at the APMP Bid & Proposal Conference 2015.

I’d just done the maths. Word 2010 has 10 menus (not including the Help function) with over 350 commands. The standard and formatting toolbars alone have around 200 options. What does the web say on the subject? Excel certainly features in some of the ramblings of people who consider such things and most agree that Word has several millions lines of code behind it. Of course, Word is part of the Office Suite and has a number of items in common. The exact number of lines of code in the Office suite is a Microsoft secret but one helpful blog post noted that LibreOffice (broadly functionally equivalent) has just over 7 million lines of code and just under 1.5 million comments (within the code).

Whatever the statistics I think we can agree it’s more complex than your average user needs. Indeed, it’s said that '90% of people only ever use 10% of the functionality'. Of course, not everyone uses the same 10% and therein lies the rub. There are so many ways to do things in Word and, with many people ‘self-taught’, it means that you can very quickly get into a complete mess. In fact, one of our key benefit messages with respect to PleaseReview for document authors is that reviewers can ‘mark-up the document but not mess it up’.

So this inevitably brings us onto best practice. Whilst some clients, typically those in the Pharmaceutical Industry, use standardized templates which (usually) follow best practice, there are many who are using internal (and sometimes very poorly developed) templates and others who are using templates developed 20 years ago which have been progressively updated to the newer versions of Word and, as such, contain a whole load of what can only be described as garbage. 

How do we know this? It’s simple, we have the challenge of taking these various documents, processing them and displaying them in PleaseReview, our collaborative review software. This is difficult enough if the document is a nice consistent document based on Word Styles and following best practice. It’s not at all straightforward if the document is a mess of styles, direct formatting, lists lined up with spaces and so on. 

The types of thing we see are hand typed tables of contents; hand typed numbered lists; hybrids of where the initial TOC/list has been manually edited; direct formatting, drawings all over the place and, of course, manual cross references – I’m sure you get the picture. 

So, when we were considering new topics for speaking slots at events we came up with the concept of the Word Master Class. Offering to speak on document collaboration or document review was not really an option as, by definition, we had to discuss our own products and this was considered as a product pitch. These are deeply frowned upon in conferences and therefore to be avoided.

So the Word Master Class was developed. It leverages the company’s detailed knowledge of Word, helps us as we want nice consistent documents based on Styles and following best practice and appears to be a subject a lot of people want to listen to. It’s proving very popular and receiving some great feedback. An example is given below:

“I attended your session today and wanted to reach out and say thank you. In one hour you managed to save me a serious amount of time formatting and editing documents. Can you please send me the instructions so I can try the new techniques on my own? Again, thanks for opening my eyes to easy tricks to solving everyday proposal problems!”

The Master Class is constantly evolving based on feedback and further research. In addition to the more serious material, we try to cover some of the more quirky items to lighten the mood. A specific trick is the ‘Rand’ function. Typing '=RAND(x,y)' – where x & y are numbers - will generate random Lorem Ipsum text where x is the number of paragraphs and y is the number of lines per paragraph. Most people understand that Lorem Ipsum text is dummy text used to test document layouts, etc. Just to give some background on Lorem Ipsum, its origin is in the early days of typesetting (in the early 1500s) when an unknown printer took a gallery of type and scrambled it to make a type specimen book. Since then, further research has concluded that it has roots in a piece of classical Latin literature from 45 BC (source: Lipsum.com). I use the Rand function regularly when demonstrating co-authoring and it occasionally raises a comment along the lines of "I didn’t know you could do that in Word". 

Whilst writing this blog I thought I’d research 'Microsoft Word and humor' to see if there was anything which caught my eye. Well I’m very grateful to a chap called William Smith who preserved and published this exchange from a Microsoft Word forum which was about to be terminated. 

In short and in summary, the questioner concludes that “Latin seems a bizarre choice”. I guess if we look beyond the immediate humor this demonstrates that it’s not just professional writers who use Word. Almost everyone uses it and, if they haven’t been trained (and they frequently haven’t), they somehow make it look right using their limited knowledge. This even applies to people who spend a considerable amount of their time using Word in a professional capacity. 

In fact, it’s precisely these people – people who may be subject matter experts who end up writing documents rather than Word experts – who are the target audience for our Master Class. 

Anyway, the Word Master Class is a 45 minute presentation/demonstration of some of the features of Word, covering the use of Styles, Section Breaks, Outline View, Drawings, Hyperlinks and Cross References, Macros and the Quick Access Toolbar. We will be running the Word Master Class as a webinar in the 2nd half of the year so, if it’s of interest, send us an email and we will advise you of the webinar details as soon as available.

 

Document review, Labradors, webinars and cartoons...

Posted by Sarah Edmonds on 3. March 2015 11:02

The other half of marketing... Google


Hopefully somebody’s reading this blog as it forms part of our marketing communications strategy. This strategy is based on a wide variety of activities such as insightful content management, analyst relations, exhibition presence, speaking opportunities, whitepapers, webinars, partner activity, our cartoon website, social media as well as a variety of literature, and of course our website.  But amongst all this, what is the most effective method for really engaging with our customers and prospects and for getting a conversation started?

There is absolute value in producing whitepapers and conducting webinars, which can be viewed and listened to again on our SlideShare page.  The proof is in the pudding as hundreds of people visit this page. Not all visits turn into leads, but some do.  It also positions us as an authority and a market expert in the field of document review and co-authoring. This is broadly considered as ‘thought leadership’.

The same can be said for our YouTube page, here people can find the short animated films we’ve created which detail and demo the product, PleaseReview, and why you might need it.  We know that reading presentations and whitepapers can be a little dry at times and, as you can tell from our cartoons, we are anything but ‘dry’. So we often animate the results of any research we’ve conducted.  It humanizes our communications and projects our company’s personality. What we do is deadly serious but communicating it needn’t be dry. After all, our customers and prospective customers aren’t machines; they’re normal folk who absorb information in a range of ways from watching TV to reading a paper.

And these normal folk don’t want to spend their days solely thinking and looking at work related subjects, even when at work checking out their LinkedIn, Twitter or Facebook streams – we all do it… Sometimes we just want a bit of light hearted fun, something that doesn’t tax the brain, something that makes us laugh.  So, for example, we took a look at our database and segmented job titles against names to establish the most popular names amongst various job positions, such as medical writers (Heather by the way).  And people loved it - they liked it, commented on and retweeted it.  And the response to our online quiz which allows people to find out what sort of document review personality they are (Labrador, squirrel, lion or dolphin) has gone through the roof.  

Hopefully whilst they’re on our website having a bit of fun, curiosity has got the better of them and they’ve had a little look around the site.  And maybe, just maybe they found something else they quite liked…

 

Looking back at 2014 and forward to 2015 - views from PleaseTech CEO, David Cornwell

Posted by David Cornwell on 19. January 2015 12:16

Founder/CEO of PleaseTech Ltd - collaborative document review and co-authoring for the enterprise.


Welcome to 2015 which has started at a gallop!  

As is traditional, the first part of my January blog is somewhat repetitive as I say that the previous year was yet another successful one for PleaseTech with revenue growth, new clients and some great product enhancements! 

2014 delivered 25% growth in sales order value over 2013 with 36 new clients and a massive 35% growth in annual recurring revenue (ARR).  Of particular note is that revenue from term license sales rose over 70% reflecting the industry trend towards renewable licenses.  Maintaining the headline sales growth whilst, at the same time, boosting ARR growth is, we think, an impressive achievement.

I am a fully paid up member of the ‘turnover is vanity, profit is sanity and cash is reality’ brigade. So I’m delighted to report that we remain profitable and continue to retain a healthy cash balance. Profit gives us the ability to invest in new people and to further grow the business, which is exactly what we plan to do in 2015.

With approximately 65% of 2014 sales, the trend of Life Sciences being our largest sector continues. However, this is down from 80% last year reflecting our success in expanding into other sectors. Once again, North America is our largest market accounting for 77% of all sales. This is in line with the trend of North America averaging around 73% of sales over the last five years.

In terms of product, 2014 saw the release of PleaseReview v5.1. Key enhancements included: 

  • The introduction of a context-based review capability; 
  • Additional review workflow capabilities such as hierarchical/tiered reviews;
  • Enhanced post-review reporting capabilities; 
  • An optional Archive feature;
  • Enhancements to the review templating capability now called ‘Review Types’;
  • Enhancements to the configurability of the system to facilitate its use in large corporations with disparate configuration requirements;
  • A cost-center licensing capability. 

These enhancements continue to establish our thought leadership in the critical business process of document review, which is exemplified by our ‘Beyond Review’ strategy. This strategy uses the metrics from the business process optimization associated with using PleaseReview, for further analysis and optimization. 

We continue to have our enterprise clients at the forefront of our thinking and conversations with them both in terms of the infrastructure challenges they face and in the details of the complexities of their review requirements continue to drive our development. 

Once again 2014 saw customer praise for our service and support. For example, a customer commented: “I definitely have to say that your company has raised the bar for vendor support.  Nick continues to go above and beyond my expectations for support.  I truly appreciate everything your team does.”

As ever we continue to develop partner relations and deliver new integrations. Last year we delivered integrations with Veeva Vault, CARA for Documentum and OKTA.

All of this was accomplished whilst, at the same time, undertaking one of the most stressful things a company can do which is the move to larger premises!  

So, looking back I think we can be proud of what we achieved in 2014. 

What can we expect in 2015?  Well, from our perspective the answer is: more of the same.  We will continue to work hard and deliver excellent software. 

We expect to release PleaseReview v6.0 which will include a substantial upgrading of PleaseReview’s user interface. The idea is to borrow from the consumer web so that anyone familiar with standard consumer technologies and web applications will feel immediately ‘at home’ when reviewing a document in PleaseReview. This approach will help minimize training and will support enterprise-wide rollout and adoption for new and existing clients to increase their ROI.

Work on other integrations and partnerships is a constant theme as is expansion of the team.  Already 2015 has seen two new starters!

From a personal perspective a year wouldn’t be the same without a physical challenge or two. There is early stage planning for Everest Base Camp but, for more immediate motivation, I have signed up for the South Wales Three Peaks Trial Gold walk at the end of March, which is a 20 mile walk with a total ascent of 5,000 feet. That will keep me focused for now!

If you want to follow what we are up to here at PleaseTech, do visit our website or follow our LinkedIn company page.

Thanks!

 

The power of partner webinars: working with Veeva and Generis broadens PleaseTech’s reach.

Posted by Sarah Holden on 3. December 2014 11:14

Half of the PleaseTech marketing team.


Over the last couple of weeks we have held two webinars. I have to say, a well-executed webinar that brings useful information to a specific audience is hard to beat in terms of generating real interest and giving the sales folk plenty to do.

In each instance, we worked with a partner. Not only does this give us compelling content to share, but our brand/product story reaches a new audience. In fact, these last webinars have given our sales people as many, if not more, follow up leads than some of the events we pay big bucks to attend.

Firstly we were presenting our PleaseReview integration with Veeva Vault. Veeva provides life sciences organizations with cloud based solutions for regulated content management. The integration of Veeva Vault with PleaseReview provides a complete and seamless process for document collaboration: 

 

The webinar elicited a large audience of existing Veeva customers looking to enhance their current process and interested parties looking for a complete solution. The volume of questions during the event was proof that having experts on hand and a live demonstration of the software was a far more effective means of generating interest than other, more traditional, methods of communication.

To view a recording of the webinar, please do visit Veeva’s website

 

Our second partner webinar was held in partnership with Generis, the creators of CARA - a fast, configurable user interface and business rules engine for the creation, approval and management of documents for leading content management platforms. The integration between CARA and PleaseReview is initially for Documentum users only and is one of the two contenders in the replacement of Documentum’s Webtop. As such, it is also geared towards providing an end to end document lifecycle solution for life sciences companies. 

In this instance, the webinar was marketed to existing CARA customers and counted both multi-national pharmaceuticals and emerging biotechs amongst the audience.

A more widely targeted webinar is expected in the New Year. However, to learn more about the integration, you can view the webinar recording here

   

Document review is a non-trivial business problem for many companies

Posted by David Cornwell on 2. October 2014 11:46

Founder/CEO of PleaseTech Ltd - collaborative document review and co-authoring for the enterprise.


How do we know that document review is a non-trivial business problem for many companies? The answer is quite simply that we spend our time talking with existing and prospective clients who have done the analysis. In order to justify a PleaseReview investment, they take the time and trouble to look at the benefits and build a business case and, if we are lucky, they share it with us!

For example, last week I was with a PleaseReview prospective customer. We were discussing the business case on which his PleaseReview project is based. He explained that the first business case he had calculated showed such a large benefit that he had to revise it as he didn't think it would be believed! He then recalculated it using conservative assumptions. These included only including those reviews with more than four participants and only taking into account the time saved by the document author not having to consolidate comments and changes with the ‘copy and paste’ process. BTW: This 'conservative' business case was estimated to save an average of eight hours per document - that is a working day!

In this particular company, there were 'thousands' of documents reviewed per year.

Furthermore, no consideration was given to the time saving at review meetings or any of the other standard benefits delivered by a PleaseReview system. And yet, even without this, the payback on the project was well under six months!

We know another company based its PleaseReview business case purely on the time saved in review meetings. During the software pilot, meetings which were scheduled to take all day were completed in a matter of hours. Thousands of hours per year would be saved if they went ahead with the purchase. This made PleaseReview a ‘no brainer’.

But, I hear you cry, statistics! I need statistics!

Well how about these statistics from live PleaseReview systems?

I found the following numbers from one of our clients: over a six year period this client has had around 20,000 documents involved in about 6,000 reviews, so an average of 3.4 documents per review and 3,333 documents per year. The user base is close to 1,500 and the client has historically had an average of 12 participants involved in each review.

So, if my sums are correct and assuming that the client gets the same level of saving (i.e. eight hours per document) over the last six years this client has conservatively saved around 26,600 hours per year. Let’s say that is an over estimate and base the calculation on reviews rather than documents. The figures now show a saving of ‘only’ 8,000 hours per year (based on 1,000 reviews, each with an eight hour saving) which equates to over 660 hours per month or 83 days per month. This is a considerable benefit.

Reviews can, of course, contain many comments and changes and the time saving will depend on the number of comments and changes.

Data from another client extracted from a single month in the middle of 2013, reveals an average of 175 comments/review. However, this is slightly skewed by the fact that one review had over 3,000 comments/changes whilst another had over 250! However, if you eliminate the extremes there was an average of just under 50 comments/changes per review.

I was actually sitting in a meeting at this client’s site when the above statistics were discussed. A senior manager was absolutely amazed that they had a business process which involved so many documents and so many people reviewing them. The ‘front line’ team explained that, before PleaseReview, it was a ‘horrid’ process that had taken weeks and now at least it was under some sort of control. In fact, the users now felt that they couldn’t do their job without PleaseReview. Further proof that document review really is a non-trivial business process.

Another client says: “we have cut the review time of most documents in half and turnaround time is much faster with the comments being automatically collated. I can’t say enough about the time that we have saved”. They also noted that the production of productivity reports was simplified.

Productivity reporting brings up the question of metrics. I’ve just quoted statistics from thousands of reviews with thousands of comments from a user base of thousands. Who has got time to collate that stuff? The answer is, of course, a database. It’s all there in the database and therefore it takes a matter of minutes to calculate the statistics.

How many people have any metrics around their document review process? Those using PleaseReview do. With metrics comes the ability to look at the business process – if only to show amazement that you have such a process!

PleaseReview v5.1 introduced additional analysis options including the ability to examine the data by document section using Excel.  Using standard Excel analysis features such as pivot tables, it is possible to rapidly produce reports on, for example, the number of accepted and rejected comments and changes per document section.

A simple sample report is shown below. The report details the number of rejected comments and changes per document section in the review. Using standard Excel filters this could, for example, be restricted to rejected changes, or comments, or any combination of desired search criteria.  This gives users a great tool for improving the quality of future documents, identifying training requirements, and so on.  

 

 

So it can be seen that PleaseReview can scale to very large user bases and review requirements.

However, of course, not every client is going to have such extreme requirements. Remember that the figures presented were averages. These clients run some very small reviews, with single documents as well.

The key point is that, without PleaseReview, the basic process of document review is an inefficient and cumbersome one. Highly paid and highly skilled medical and technical writers should not be spending their time copying and pasting! It’s hardly an efficient use of people’s time, energy and enthusiasm. With everyone pressed for time and having to ‘do more with less’, efficiency is mandatory.

Obviously the examples I have quoted are based around larger, heavily document intensive companies, but the same pain points and advantages are experienced by smaller companies with smaller teams. With smaller teams the relative percentage savings can be just as large. We have clients who gain significant benefits from just a user base of 30 people as well as those with thousands of people.

PleaseReview streamlines the process, saves everyone time and pays for itself in no time at all. Perhaps that is why, in an average year, 30% of our revenue comes from existing clients buying more licenses and 50% of our clients have purchased additional licenses.  Repeat business is the best endorsement a company can have and it acts as a great encouragement to the entire team.

So, many thanks to our clients – please keep up the good work and keep making the savings.  And don't forget to keep telling us about it!

 

header bg