How to allocate the shared expenses to the right business units with the cost allocation methods and the identified activities’ data

Previously, the organization did the business by aiming at the growing number of sales from each business unit because with only the achievement of sale, the company could make the profit as required.

Currently, the philosophy of business proceeding has been changed from focusing only a number of sales to cost supporting sales. As we know that the cost drives the competitive pricing and this enables any business to sustain the ability of competing in the market.

What can the PivotTable Report do further to the basic?

I have already written the PivotTable report four times. All of them have involved much the basics to create the report with the designed layout (design). However, to make our report more interesting, we need to use more abilities available in the PivotTable tools (Options) and the conditional formatting. The conditional formatting forms a part of Home tab instead of the PivotTable tools but it can be used to highlight the number on the PivotTable report.

The report, our readers have required today, is not just the report with the sum of values. We all know that they require not only the timely basic report but also the capable report for analysing.  PivotTable report can answer these questions reasonably although the answer is not absolutely complete due to the concern of calculation’s accuracy. Tools (Options) of PivotTable can make the analytical report of which the number can be highlighted with the conditional formatting of Home tab.

What I have found on Facebook as the user and the blogger (Part I)

Before being the user on Facebook, I have been writing the stories on my blog, howto-i.blogspot.com (howto information). To increase the number of readers for my blog causes me to think about the promotion with the social networks such as Facebook, Tweeter, etc. And when I have decided to play in the field of Facebook, I start reading the book to know what features are in Facebook and how I can use them.  Following the book, I have my own account and my own page named “Surinee1” and “SurineePage” respectively. All Surinee1 relating processes have been done from sign up with the preliminary information, Email confirmation, and friend finder to the last step of the profile information and the profile photo. And then, Surinee1 moves towards SurineePage, my page of Facebook. Now it is the time that I would like to share the following story from what I have found on Facebook as the user and the blogger.                              

This photo is the one of the several stories for sharing

Learn by video of PivotTable Report in Tabular Form

The topic video presents the process from the data list to the finished report in the designed visual style.  In accordance with the video, we know where we can insert the PivotTable report from the data list and what we have to do with the field list. Additionally, the dropdown lists within those building functions show the displaying results when we choose them.

We have already talked about the building functions on the several posts so we will focus more on this video at the dropdown lists within the building functions.

List of Conjunctive Adverbs and their example sentences

After writing the sentence structures, I have had my own target to gather conjunctions altogether as many as I can with their example sentences. As we know that the conjunctions connect words, phrases and clauses together to make the communications smoothly and clearly. And this is why I would like to present the conjunctions next to the sentence structures.

There are several conjunction types : Coordinating Conjunctions, Conjunctive Adverbs, Correlative Conjunctions and Subordinate Conjunctions. But the first type of conjunctions on this post is the conjunctive adverb and you can see how many the conjunctive adverbs there are.

Untethered Jailbreak to iOS 5.1.1 for iPhone 3gs unlocked with baseband 06.15.00

This writing follows the previous post of untethered jailbreak for iOS 5.1.1 but not for the locked sim. There are some links disclosing the solutions for those with the locked sims which are not unlocked with the iPad baseband of 06.15.00. Our iPhone 3gs which was unlocked with the iPad baseband 06.15.00 cannot be completed with those solutions. We can jailbreak it to iOS 5.1.1 but we cannot unlock it to get the call in place as usual. We have tried different ways but we have not yet got the key application to unlock it until we have found the link below. We also downgraded it to the previous iOS which we have kept SHSH blobs(link is in my blog too!) before finding this link.

Erase All Content & Settings before Untethered jailbreak for iOS 5.1.1

At the moment of this typing today, there are many people doing jailbreak for iOS 5.1.1 including Thailand. We have started the process in the late afternoon and finished it over midnight. Actually the detail of process is easy and it can be followed by jailbreakers. However, any problems can happen during working. We have already had the links for you to read and download and have also had some solutions mixing with reminders for managing the specific problem from erasing all contents & settings before jailbreaking.

PivotTable Reports in Three Forms of Report Layout (Part Three)

 We can use PivotTable Menu to create a new PivotTable report according to PivotTable (Part One). And we know that the data of the list with the labelled columns suits the PivotTable Filed List due to PivotTable (Part Two). As a result, we can have the finished reports in different forms with the provided data. The following details and pictures of the finished reports, Compact, Outline and Tabular, are going to be explained below. 

The PivotTable Reports in Three Forms of the option of Report Layout

 

PivotTable Field List and Data of the list with the labelled columns (Part Two)

In connection with PivotTable (part one), you can build the reports in many ways. However, what the report looks like is another matter. And one thing is for sure, the data you want to turn into the report should be the list with the labelled columns. In order to understand the same thing, you should know about the Field List of the PivotTable Tools.

PivotTable Field List comprises of Fields, Report filter, Column labels, Row labels and Sigma Values.

The table is raised as the example below.

	Month (field header=item label)	Product Type (field header=item label)
Row1	Jan (item)	Computer (item)
Row2	Feb (item)	Computer (item)
Row3	Feb (item)	Others  (item)

How to use PivotTable to build the reports (part one)

PivotTable here is PivotTable in Microsoft excel version 2010. PivotTable can build the report in several forms from the database in the short time. The efficiency of the PivotTable report is variable to the change in options, design and your determination. Start first as to how to build the PivotTable report, part one, and go further to more complicated details next writing so that you can adapt them for your own work.

PivotTable WizardButton 

PivotTable Insert

There are more pictures in the story waiting for your viewing.

Can’t sign in to YouTube app on iPad2

I have got the question as to how to keep the video contents into each group on iPad2. I recommend YouTube application to make the playlist. It is surprising that we can’t sign in to YouTube app on iPad2 although the username & password are as same as those of YouTube on the computer. Finally I can sign in and would like to share the following process.

Auto Restart again & again on GT-S3850 CorbyII

Recently I have seen auto restart problem on Samsung GT-S3850. At first I didn’t pay my attention much to this model because it is not the phone running on iOS or Android that I am currently using. However, I have ever used thoroughly the smart phone and the previous versions of the firmware so I gradually pay the interest to look for the solutions for auto restart and stuck in the phone logo.

I have known before that this problem might be solved with the flashing on the phone. As a result, I find the files to be used to restore the phone’s firmware by flashing it.

Reminder + Solution for iPhone 3GS jailbroken

There are the following items to be shared as the reminder and solution for iPhone 3GS jailbroken.

·       Keep away from Restore button on iTunes as it will update your phone to the latest version of the firmware that cannot be jailbroken at that time. (Your iPhone will operate like iPod touch.)

                                

·       If you have the problem with your phone, ensure what solution you will use before restoring your phone with iTunes.

How to root Android Phones

If we know Jailbreak on iPhone, we can easily understand why we need Rooting on Android phone about which we are going to talk.

Rooting on Android phone enables us to utilize the memory on SD card as well as the memory on phone.

Without rooting, all applications we have installed will go to the memory of phone eventhough we have identified the destination of storage, i.e. SD card.

Before jumping towards Rooting, we should check below what we need to prepare & study:

Brief of Sentence Structures

Several things have been done and prepared during & after the flooding. As a result, I have had the one of those to present. Hope that it would be useful as the brief to be referred to. In addition to the brief of writing, I have just added the diagram below.

The Four Standard Sentence Structures

1) Simple Sentence

1)   A sentence has only one independent clause also known as the main clause.

2)   The simple sentence can have two nouns or verbs called the compound noun or verb. The compound noun or verb is not the compound sentence.

3)   Phrases, added to the main clause, can act as the adjective to modify noun or the adverb to modify verb in the simple sentence, etc.

Simple Sentence:

Another book was so interesting to the readers, given at the New Year party. (participial phrase to modify noun)

The boys and girls did their workshop to practice their knowledge. (infinitive phrase to modify verb)

The way to know him is to compare him, not with nature, but with other men. (infinitive phrase to modify noun)