Practice Writing of Chinese Radicals With Two Sheets Of Papers

Finally I have found the article for this blog. I am sorry for not updating my blog for quite a long time. As always I convert my learning to text, photos and files. The topic is Chinese language but focused to Chinese character writing. It is helpful to the beginners who have felt that Chinese characters are difficult to be identified and remembered.

As we know if we are not Chinese, we must learn Pin Yin firstly to know pronunciation of Chinese language. Pin Yin is a set of the consonant and vowel sounds with tone marks of Chinese which are listed out in English in order to pronounce. That’s the reason why we can speak Chinese but we don’t know Chinese characters. Pin Yin is good to start but it should be continued with Chinese characters after all. (what about two sheets of papers?)

The first sheet of two sheets

Free Psd Files for Working with Photoshop Tutorials

As we know, a lot of Photoshop Tutorials on the various websites are available for us to practice our skills for Photoshop(CS6). During the practices, I have found that some tutorials are so detailed that the beginners can follow the processes while some are not. In order to simply follow the processes, the free Psd files will be provided for working with the selective Photoshop tutorials below.

The following video is for the third type Psd files

Enlarge on Calculations of Present Value Formulas in Excel for Continuous Compounding & Perpetuity

We will talk about the rest of PV in this article to complete all previously mentioned. As usual, we use Microsoft Excel to mathematically calculate the formulas or to insert Function to return the solution. Moreover, we will enlarge on the certain formulas by proving the different forms around the bottom of the page or in the link file. Logarithm is also used to calculate the number of the years in the financial formula.

As below, I provide you the picture with the description and the link file to each item. Also note that the two new functions have been used in the link files: EXP and Seriessum.

1 PV of a Future Sum with Continuous Compounding:

Financial Formulas and Functions on Microsoft Excel for Present Value

Previously we talked about the future value which is one of the two main types of time value of money. Accordingly, we should continue time value of money to know more about the second type i.e. Present Value called PV for this article.
The point of this article is showing us the calculations of the various financial formulas of PV with Microsoft Excel. Each financial formula and its own pattern and details come along with the calculation of the given values of all elements from the formula in addition to the PV function on Microsoft Excel. As the result, we can choose the right one to match our criteria and know how to exercise it to meet our requirements. To ensure the results of the following pictures and files relevant to the financial formulas mentioned above, the online calculator as below can work with the pictures or files.

1) PV of a Future Sum: Given FV= 300.73 the only one future sum, r= 6% interest, n= 7 the number of years.

Fill in function arguments of PV as follows: Rate= 6%, Nper= 7, FV= -300.73, Type= 0 (end= ordinary) or leave it blank

2) PV of a Future Sum with Compounding: the same as above with the additional compounding per year= 12.

Fill in function arguments of PV as follows: Rate= 6%, Nper= 7*12, FV= -300.73, Type= 0 (end= ordinary) or leave it blank

Financial Formulas and Functions on Microsoft Excel for Future Value

As we know, Microsoft Excel is the good tool to set up the formulas and functions for calculating the numbers on its spreadsheets and those spreadsheets can range from simple to sophistication upon the ribbon tab settings. However, we have to concentrate the certain formulas and functions out of the several lists to limit the article reading.
The certain formulas and functions which we will be talking about are relative with the future value, a name coming with the following various calculating financial forms.

FV of Single Sum:  The only one principal of 200 is for the whole time of seven years. The picture shows us the details on the spreadsheets while the linking file will tell us how to calculate these details with Microsoft Excel.

How to fill in the chainladders with the data of the inventory, sales and purchase (part one)

Previously I did a lot the chainladders filled up with the claim data of the insurance business to look into the development and the trend of the incurred claims. Not only I had to find and gather the claim data for those chainladders, but I also did the interpretation and projected the trend of the upcoming incurred claims on the quarterly basis.
At that time the regional team header used to tell me that the other significant business data could also be analyzed through those chainladders. To extend this idea, I have determined the data of the inventory, sales and purchase for the chainladders to give us more business information. See below the example.

Given that the purchase results from the current inventory less the beginning inventory plus sales, we can build the development and the trend of these three items from the actual data at each end of the time from the past to the present and the estimate projected data for the future. The process is shown below.

List of the subordinate conjunctions and their example sentences

I write this post in connection with the brief of sentence structures and as I mentioned in my previous post of List of conjunctive adverbs and their example sentences. Subordinate conjunction, in addition to the conjunctive adverb, is the second type I want to memo onto my blog and share with you.

For more information, the dependent clause is the subordinate clause and the subordinate clause can be the adverbial clause or the adjective clause or the noun clause (also known as nominal clause). However those clauses have the different functions: the adverbial clause functions like adverb in the sentence while the adjective clause functions like adjective in the sentence and the noun clause functions like noun (subject, object and complement, etc.) in the sentence.

Again, the adverbial clauses are after the subordinate conjunctions and function like adverbs to indicate time, condition, purpose, reason, result, contrast, place, manner and degree.  Accordingly, the list of subordinate conjunctions and their example sentences will be categorized upon their indicating in my writing.

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.