No Picture
Tech News Today

Kids and Technology – Is This Tandem Beneficial?

Today, technology has played a very big role in everyone’s life. With online banking, transactions have never been this easy and convenient. With eShopping, purchasing goods has never been this far-reaching.
All these technological advancements, however, have placed a strong hold to children too. Today, you could hardly see a kid without a PSP, a Nintendo DS or a video system at home. Talk about simple stuff, nearly every kid has a television or a computer in his room.
Truth be told, kids’ access to technology is both beneficial and dangerous. Let’s see why.
On a Positive Note
Today, more than ever, kids have unlimited access to the internet. They can play with their video gaming consoles everyday. And of course, they can watch television all day long. As a result, children are exposed to a lot of visual and auditory stimulation.
This is a good thing, because at age 0-6, a kid’s brain is still developing. So they need as much stimulation as possible to become smarter and better individuals.
By being exposed to the latest in technology, kids are taught – at an early age – about the vastness and the usefulness of the internet and other video games. Learning becomes multi-faceted as kids today no longer solely depend on one instructional medium: books.
On a Negative Light
Child psychologists and medical practitioners, however, are unanimous in identifying the negative effects of too much exposure to technology. They contend that too much visual and auditory stimulation produces “addiction-like” effects. Because kids are used to too much stimulation, they’d grow restless, anxious and even aggressive when they do not have this level of “input.” This explains why they get irritable when they are just told to stay put and not play with their PSP’s.
Second, too much exposure to technology could interfere with quality time with their families. Instead of spending their time playing or going to the park with their parents and siblings, kids would prefer to stay at home and be in the company of the computer or their home gaming sets.
Psychologists also believe that during their development years, kids should spend more time in active play, physical undertaking and even reading. With the presence of laptops and gaming consoles, however, these activities are set along the sidelines.
As a result, their social skills maybe affected. Because kids now find more meaning in playing alone, they would find it hard to appreciate the company of others. Everyone knows that social skills are very important for one’s success, as such, this has to be developed as early as 2 years of age.
The advent of technology brings with it a multitude of advantages. With technology, people are experiencing a better quality of life. But as with anything else, too much of something is bad. Therefore, it is your challenge to know when something is too much, or too little. It is up to you to balance the exposure of your child to visual and auditory stimulation. As a parent, it is your call to know when exposing your child to technology would do him more good than bad. That’s the only way for you – and your child – to take full advantage of what technology brings.…

No Picture
General Article

Creating an Invoice Using Excel

Creating an Invoice Using Excel

The elements of an invoice can be quoted as the most important constituents in a business trade as a form of evidence. Most companies, either small or large corporation firms will require you to invoice them their orders. Invoice is vital to keep an organized record of the business deals in terms of the price, quantity and details of the products or services. Usually, the invoice may come in several copies where you and your client should possess one each as a proof to avoid superfluous conflicts in the future.

The Microsoft Excel is generally a program invented to perform automatic calculations. It can evaluate mathematical calculations such as addition, multiplication or subtraction of data just by simply entering the coding information called functions into the program. As such, it is ideal to create invoices as the results will automatically be derived as the alteration of data takes place. Basically there are few simple steps you should follow to produce an invoice.

Firstly, you will need to make the headings. Enter headings for the elements of an invoice in the first row. The commonly used headings should include quantity, product, price, date, product subtotal and discounts. Then you should begin arranging the cells. Any cells containing texts should be formatted, including those having currency or dates. To perform the arrangement of cells, you can click on the cell then select “Format Cells”. Choose the “Date” from the Category box for any date sections. Then select your desired type. There is a “Currency” option in the Category box for currency cells.

Next, key in whatever data you need. Enter the information for every item or service purchased. If you do not have the information available, you may want to empty a few rows to see how the invoice might appear. Include also the formula or product subtotal into the Microsoft Excel. To evaluate the subtotal for every product, choose the having the subtotal then type “=sum(” in the formula bar. Then select the cells that contribute to the subtotal such as discounts, price and quantity and click on “Enter” to shut the formula. Then continue by making the total cells. Choose all of the cells in the row that comprises the subtotal cell. Then click on it and choose “Format Cells”. Select the “Alignment” tab, then “Merge Cells” from “Text control”.

Next select “Right” from the “Horizontal Alignment” tab and enter “Subtotal” in the cell.

After that, key in the invoice formulas. Choose the subtotal section and type “=sum(” and choose the rows containing the product subtotal. Then click on “Enter” to shut the formula. Select the “Taxes” section and key in “=[invoice subtotal cell]*[tax percentage]”. Next select “Enter” to shut the formula and continue with the “Total” cell. Type “=sum(” and select the “Taxes” and “Subtotal” cells before clicking “Enter” to shut the formula.…

No Picture
General Article

How Power Shell From CRM Solutions Allows SDK Message Throttling?

How Power Shell From CRM Solutions Allows SDK Message Throttling?

Microsoft Dynamics CRM 2011 offers a set of Power Shell commands to activate command line administration and deployment. The commands render a subset of the Deployment Web Service to allow receiving and establishing advanced settings, among a host of other things. Microsoft Dynamic CRM allows an interesting way of configuring throttling on a subset of SDK messages.

An Instance

In order to understand how the process works, it is important to take into account any particular instance, which would help in understanding how throttling can be configured for a subset. For instance, there exists a scenario in an organization where there are multiple users using the Outlook Client. The Outlook Client does possess the capability of completely going offline and then reconnecting so that it is able to sync new data. When this particular scenario takes place, the administrator observes that the organization’s CRM instance encounters poor performance as at a time many users are trying to sync data simultaneously. One method of preventing this situation is through throttling of the large number of sync jobs.

In order to activate the throttle process through CRM solutions, it is important to first configure and add Power Shell Snap in.

The command for adding PowerShell Snapin is as follows:

Add-PSSnapin .Powershell

The next step is to enable throttling and the commands that need to be followed include:

#Get the current throttle setting object from ConfigDB and

#store it in a variable.

$eTmSettings = Get-CrmSetting -SettingType EtmSettings

#Change the properties of the settings object to enable throttling.

$eTmSettings.Enabled = 1 $eTmSettings.ThrottlingEnabled = 1

#Update the settings by saving the updated settings object.

Set-CrmSetting -Setting $eTmSettings

The third step is to get the throttle settings

# Get the current throttle settings object from ConfigDB and

# store it in a variable.

$settings = Get-CrmSetting -SettingType ThrottleSettings

When these commands are executed, it creates an object with the following properties:

MapiSyncMaxConnectionsPerServer

MapiSyncPerOrgMaxConnectionsPerServer

MaxBackgroundSendEmailRequestsPerOrgPerServer

MaxBackgroundSendEmailRequestsPerServer

OfflineSyncMaxConnectionsPerServer

OfflineSyncPerOrgMaxConnectionsPerServer

OutlookSyncMaxConnectionsPerServer

OutlookSyncPerOrgMaxConnectionsPerServer

In the present scenario, it is noticed that there exists multiple throttle settings that have an impact on the Outlook Client sync behavior. Since the aim is to throttle all Outlook Client sync jobs, hence the settings that are important are

OutlookSyncPerOrgMaxConnectionsPerServer and OutlookSyncMaxConnectionsPerServer.

The kind of interaction that will take place between the two settings is described through the following coding:

if ( (_organizationMax

>= 0 && organizationCount >= _organizationMax)

|| (_serverMax >= 0 && _totalCount >= _serverMax) )

// reject job request

else

// execute job request

The fourth step is to setting the throttle settings

Since all the throttle settings are set to -1, therefore this indicates that there is no throttling. Throttling is only enabled when the value is configured to 0 or higher. If a value of 0 is used then it will disable all the requests, therefore in this scenario 1 will be used as a test value. The next step is to figure out if one should throttle requests Per Organization or Per Server. For instance if there is three organizations then the maximum number of simultaneous requests for the entire Microsoft Dynamics CRM server would be 3 if the test value of 1 is used. Using this particular logic, one will be able to decide if this request is to be rejected:

$settings. OutlookSyncMaxConnectionsPerServer = -1

$settings. OutlookSyncPerOrgMaxConnectionsPerServer = 1

Set-CrmSetting -Setting $settings

This is the overall process for establishing throttling process as part of Microsoft Dynamics CRM.…

No Picture
Current Technology News

How’s Your Technology?

Today, a business owner has a myriad of options when it comes to choices for technology. Some of the very coolest stuff comes in the form of wireless computers for medical and dental practices to increase the mobility of staff and patients. There is nothing more cool than checking in to your doctor’s office and signing in on a tablet that is handed to you. You know that this is an office that keeps up with technology. If you are in your doctor’s office, this helps to reassure you that most likely this doctor has the latest x-rays, latest equipment, and a higher knowledge level than the doctor down the street. The same goes for your dry cleaners – my guys now ONLY offer organic dry cleaning. When you walk in their shop, they just ask for your phone number, punch it into a keyboard, and the clothes come spinning around to you while they swipe your credit card. This is a very efficient system that smacks of technology and leaves you feeling warm and cozy with your organically cleaned clothes. A win-win for all!
What about the low-tech guy out there? Is there such a thing these days? Has technology taken over every industry and left us dependent on software to run our businesses? I believe there will always be room for those small niche businesses that run a low tech approach. One of the best examples I can think of is the shoe repair guy – the cobbler if you will. The guy I use only has hand tools which look like, and possibly were, made in the 1700’s. But it works for him! You walk into his shop and smell the leather everywhere. You pay only in cash since he has no credit card machine and no cash register… wait a minute, is this guy paying taxes? Anyway, his work is top notch but he has no need for high tech in his business since he is the only employee and pure skill is how he develops his business. His place is chock full of bags of repaired (and paid for) shoes. He could care less when, or if, the customer picks them up since he insists on prepayment. This is a guy who likely will never sell his business because he is not busy enough to share in the action and never will be.
If you compare these two paragraphs and think about third world countries, just imagine the opportunities there for a second career – the stuff we keep talking about. They have low to no technology right now, just imagine where they will be in five or ten years… hmmm can you hear opportunity knocking on your door yet?…

No Picture
General Article

Microsoft Excel – How to Quickly Find Repeated Values in a Column

Microsoft Excel – How to Quickly Find Repeated Values in a Column

Imagine you have an Excel spreadsheet that contains a list of values that appear in a single column, and lets say this column contains id numbers. It happens that the spreadsheet data was obtained from an invoices list of the previous month, and you are asked to obtain the number of unique customers from that list. If the list contains less than 20 or 30 rows that could be something you can easily do manually just by looking and counting them, but what happens when the list contains 200 or even 3000 rows?

That’s when you have to find a method to let Microsoft Excel do the hard work, and you can achieve that by following the steps in this example:

1. Lets say you have these simple values in column A, starting from row 1 to row 10:

BB

DD

GG

EE

GG

SS

BB

AA

KK

SS

2. First we have to get our data sorted, so we click on the first value (that would be cell A1 in the example), and then go up to the menu item called “Data” and select the option “Sort”.

3. The Sort window should appear, and by default it will show the option “Sort by” and the value “Column A”. Press the OK button. That should have changed our list into this:

AA

BB

BB

DD

EE

GG

GG

KK

SS

SS

4. Go to cell B1 and type the following formula (including the left “=” sign) and press Enter:

=IF(A1=A2, 1, 0)

5. The value in B1 should be “1”, because what the formula is doing is that when the value in cell A1 is equal to value in cell A2 then it should write a “1”, else it should show a “0”. Copy cell B1 (Ctrl+C), and paste it in cells B2 to B10, right next to every value on the list we are using.

6. This is the result we should get:

AA 0

BB 1

BB 0

DD 0

EE 0

GG 1

GG 0

KK 0

SS 1

SS 0

Notice it? Using the IF formula we have found how many repeated values exist in the list, which in this case would be the three cells that have a “1” value next to them.

This method will save you a lot of time and effort, so practice it as much as you can!…