web analytics

Monthly Archives: July 2013

REVIEW: PHONE POWER VOIP SERVICE

Voip

Traditional calling services like PSTN are now replaced by new and powerful VoIP services that only require broadband internet connection and a suitable hardware to work. Every day there are many new VoIP companies that appear and struggle to get a bigger piece of the market, because the VoIP market is constantly growing. People have realized that VoIP is much cheaper than traditional phone lines that require a lot of maintenance. For those who are not familiar with VoIP, we will provide a short description about the service.

The term VoIP stands for Voice over Internet Protocol. It is a new way of communication that replaces the traditional copper lines and old phones. The concept is the same but the equipment and the way how the voice is transferred to the recipient is new. This technology uses broadband Internet (high speed internet access is preferable in order to achieve better sound quality) to transfer the voice call to the final recipient. A simple schematic on how the VoIP works is presented on figure 1

BUILDING WEB FORMS IN GOOGLE DRIVE

Google Drive

All those fancy and overpriced forms where people fill up surveys or questionnaires are now history thanks to Google Drive. Building web forms for your business or your specific needs has never been easier, and the best thing is that you do not need coding to build a great looking and responsive web form, that will gather the results you need. In this article we will describe how you can build a great web form. We developed a web form for a company that asked us for help, regarding the problem of tracking their clients. We built an online system that gathers data about patients and sorts the data according a given algorithm that the user defines. Google Drive web forms uses a software that is similar to Excel as database, so if you know Excel you won’t have any troubles building any forms.

The first step is to open your Google account and head up to the Google Drive menu. You will see a new screen will popping up, where the user is asked to make a selection between several choices like, Folder, Document, Spreadsheet, Form or Drawing. Our choice is Form. We have made a graphical presentation so everyone could see what has to be done.

HOW TO CREATE A CALENDAR IN MICROSOFT EXCEL 2010

Microsoft Excel 2010

You all know that Microsoft Excel 2010 is a powerful tool, and with just a spark of imagination you can build anything you can imagine. Microsoft Excel also supports Visual Basic, so if you are experienced in coding you can develop applications while you are using Excel as a database. In this article we will show you how you can build a calendar for your needs and avoid paying those expensive calendars from publishing companies. You can insert your logo inside if you own a company and just print the calendar and give away to your close ones or customers. Just follow this step by step tutorial and the calendar will be done in just a few minutes. There is also an option to build your own interactive calendar by inserting VB code into the Excel sheet, but advanced knowledge of VB is requested.

The first step is to open your new Excel 2010 document and head up to the File tab on the ribbon, like we have presented in figure 1.

HOW TO CREATE A SPEEDOMETER CHART IN MICROSOFT EXCEL 2010 – PART 2

Microsoft Excel 2010

This article is a continuation of PART 2 of the article about creating a Speedometer Chart in a Microsoft Excel 2010.

After you have done all the steps from PART 1 of this article, what you need to do is first to add another series of data in order to form the slots for the dial labels. In order to do that just click the chart so it is highlighted and click on Source Data and then choose the Series button. After that click the Add button in order to create new series and select the C2:C13 range under the Values option. Then click on the Add button in order to add a third series that will create the arrow. Now select the E2:E5 range from the Values option.

HOW TO CREATE A SPEEDOMETER CHART IN MICROSOFT EXCEL 2010 – PART 1

Microsoft Excel 2010

This article is about creating a Speedometer Chart in Microsoft Excel 2010.

Microsoft Excel 2010 makes it available to create an impressive, workable Speedometer Chart, complete with a moving arrow by making a combination of several different types of charts. What is also very good about creating this Speedometer Chart is that you can control it with a scroll bar.

The Excel 2010 Chart Wizard gives us a lot of options when it comes up to chart, but in this case the Speedometer Chart is not one of them. We will show you how to create this type of chart because you can use it as a fancy way to present your data. In Excel you can also add a scrollbar in the Control Toolbox toolbar with which you can change the chart itself and sheet data at the same time.

What we need to do now is to have some data like in the picture below and create a Doughnut Chart, which is pretty much a Pie Chart, but the trick is that it can contain multiple series and the Pie hart can’t do that.