Use Excel To Calculate Your Holiday Costs

The kalmstrom.com CEO is a Microsoft Certified Expert on Excel 2010 so he has a lot of knowledge to share. If you just know the tricks, you can use Excel to simplify many different kinds of analyzing and calculating tasks. You may also show the results in illustrative graphs and tables.

Demo on cost calculation with Excel
The video above was published in the Tips section of www.kalmstrom.com yesterday. Here Peter shows how to use Excel to analyze the costs for a holiday trip. Even if you are not planning a journey right now I recommend you to  have a look at the demo if you want to learn more about Excel 2010. When calculating the costs and changing the parameters Peter shows many things that you might find useful also when you work with other tasks in Excel.

Excel tips and tricks
While creating the holiday calculator Peter teaches us how to copy formatting and currency, name cells to use them in formulas,  format text as tables, add Total rows  and create a formula for calculating costs. He also shows how to lock certain cells in a table and leave others open for changes that will affect the totals.

BI tool for data exploration
If you need a tool for more advanced analyzes, I suggest that you take a look at the kalmstrom.com OLAP Reporting Tool. This application is integrated in most of the kalmstrom.com products, but it is also used separately by many customers to facilitate business intelligence.  Peter has of course also made a series of video demonstrations on how OLAP Reporting Tool helps management study and draw conclusions from data. You are welcome to have a look!

Connect To kalmstrom.com On LinkedIn

For a rather long time I have not done much about my representation on LinkedIn, but now I have decided to use it as an alternative to Facebook and Twitter. Many in my branch prefer the more professionally aimed LinkedIn to other social media, and I have therefore updated my LinkedIn account with much more info than before.

kalmstrom.com Blog
To make the kalmstrom.com Blog easier to follow for my LinkedIn contacts I have connected it to LinkedIn. This way all my contacts can see our latest posts on their LinkedIn homepage. The blog is the best way to follow what happens to the kalmstrom.com products, and we also give comments on other activities in the branch or near the kalmstrom.com team members.

kalmstrom.com products
Kate has updated the LinkedIn information about kalmstrom.com Business Solutions and also added some of our products. As they are new on LinkedIn we have not yet received any recommendations on them, but I am sure they will come.

Connect
I have sent connect invitations to some Community Member who were suggested to me, but please don’t wait if you did not receive one yet. Connect to me instead! I will be happy to say yes.

Peter Kalmstrom
CEO, kalmstrom.com Business Solutions

OLAP Reporting Tool Gives Community Statistics

Last week kalmstrom.com Community celebrated 2 years, and we have now looked at the statistics a bit, of course using our own applicationOLAP Reporting Tool. Here are some interesting facts and changes.

How many products?
Community Members are entitled to use the kalmstrom.com applications freely, without any extra costs for additional products. This is obviously not the feature that dips the scales in our favor, though, because ever since the start most of the Community Members have been using only one of the kalmstrom.com products.

The main selling point when choosing kalmstrom. com is something else. Organizations search for a product that fits their needs, and when they discover the kalmstrom.com solution they find it worth the money regardless of the possibility to have more. Today 87 % of the Community Members are using one product, 8 % are using two and only 5 % are using three products. Nevertheless we will keep that option open to all our current and future Members.

What products?
PF HelpDesk has been the kalmstrom.com flagship for many years, and this tool for issue tracking within Outlook is still the most popular one. After it TimeCard for Outlook and HelpDesk OSP for Outlook and SharePoint has approximately the same number of user organizations. Calendar Browser is used by only 10 % of the Community Members, but during the last few months we have had two new Premium Members on our resource booking application for Outlook. As we also see an increasing interest in evaluating Calendar Browser, we believe it will have a higher user percentage next year.

Who are the Community Members?
All kinds of organizations have joined kalmstrom.com Community, from small local businesses over public and governmental entities to large worldwide companies. It is fascinating to see how the percentage of Members from outside Europe and USA has grown during the two years of kalmstrom.com Community. From 8 % after 6 months the figure has now risen to 22 %.

We still get most new Community Members from Western Europe and the US, but we are excited about the kalmstrom.com expansion in other parts of the world. The fact that they know about and trust kalmstrom.com Business Solutions in New Zeeland, Australia and Canada is no surprise, but we now also have Members in South Africa, Russia, United Arab Emirates, Singapore, Hong Kong, Greenland and Barbados ‒ just to mention some of the new countries.

Discount to schools and charities
As both Sigge, Siret and I are former teachers it feels good to be able to give a 50 % discount on the Community fees to educational institutions. The kalmstrom.com products are especially popular among universities. We also grant this discount to charities, and we hope it will give them a possibility to do a bit more good with the money they else would have paid for software ‒ or give them the possibility to work more efficiently with software they could not afford at all without the discount. The percentage of schools and charities has been relatively stable at around 18 % all the time during the two years since we launched kalmstrom.com Community.

Promising future for kalmstrom.com Community
Looking back gives knowledge and inspiration, but mostly the kalmstrom.com team is looking forward instead. We study the development in our branch, carefully choose our battles and select the challenges that might be useful to overcome or sidestep. The future for kalmstrom.com Community looks bright, and next blog will probably be about future plans or new releases again.

Peter Kalmstrom, SharePoint Expert, Software Developer and Professor

The kalmstrom.com CEO is a true renaissance man. Peter is not only a skilled software developer with expert, Microsoft certified knowledge of Office and SharePoint, but he is also a good professor. He likes to teach, and therefore he has chosen to conduct a number of advanced courses for IT professionals.

SharePoint development

Last week Peter had a‎ 5-day SharePoint-course for developers on the subject of  Developing Solutions with SharePoint 2010. The course gives an overview of all the different kinds of SharePoint development. Both server-side and client-side data access methods are covered, and the attendees get a chance to try as well Silverlight as Java script and .NET coding against SharePoint.

SharePoint a flexible tool

Lately Peter has held no less than four different whole-week courses, covering SharePoint from the developer, administrator, power user and designer/

webmaster perspectives.

Peter finds SharePoint an extremely wide platform, with an immense potential for building applications, collaborating and managing documents. By teaching Peter can let others share his knowledge about all of these things.

Rewarding task

Peter himself also learns a lot from the attendees on his courses. They come from large Swedish organizations and consulting agencies and possess experiences that Peter is interested in learning from. He brings his new knowledge to the kalmstrom.com team and lets it influence his decisions, and that way Peter's teaching sessions in the end also benefit kalmstrom.com Business Solutions.

How TimeCard Can Report Time For People Who Don’t Even Use TimeCard!

TimeCard “Report on behalf of” feature
In an earlier blog post about TimeCard I introduced a new feature that will come with the next version of this kalmstrom.com application for time reporting from within the Outlook calendar. The new TimeCard feature is called “Report on behalf of”, and it allows one person to report the time other people have appointed in their calendars.

No TimeCard installation
The kalmstrom.com team of course wants everyone to use TimeCard, but with the new feature it is actually possible to report time also for people who don’t have TimeCard installed on their computers. It could be for example someone who needs to use a Mac instead of a PC. Let’s call this person Linda.

Shared calendar
In this case a person with TimeCard installed - I will call him Jack - must have access to Linda’s Outlook calendar. This calendar may very well be on Microsoft's cloud based Office 365, if Linda and Jack are not connected in a local network.

Add person to the TimeCard database
For this to work Linda has to be added to the central database used for TimeCard reports. If Linda is not there the first time Jack reports her time, he will be asked if he wants to add her. Adding persons to the database may also be done manually or with a little tool for add/edit/delete users that the kalmstrom.com team has developed and will send to Community Members on request.

Tagging appointments with time reporting data
As Linda has no TimeCard application installed, she cannot tag her appointments with the values that convert them into timesheets. Instead John will to that for her. This is easily managed, since the values for Customer and Project ‒ or whatever John’s and Linda’s company has chosen as metadata visible to the end users ‒ are selected from dropdowns.

Reporting time
When John has tagged Linda’s calendar appointments with TimeCard values he simply clicks the OK button to report her time. When Linda is added to the database and Jack has entered her calendar, her name comes up as the default name in the User dropdown John can choose from when he reports time. To be sure everything is right he is also asked if he is sure he wants to report time for Linda.

Staying in Outlook
As TimeCard is fully integrated in Outlook John never has to leave it when he reports time. After reporting Linda's hours he may go to a new calendar and repeat the process for another person ‒ or continue working with other tasks in Outlook.