Programming in Technology

How To Use The Dictionary Object In VBA To Change The Structure Of An Excel Table
By Andy L Gibson

Frequently you'll be faced with a index wherever the data put together makes it awkward to filter the in turn you need. It doesn't mean the index was backdrop up incorrectly, only to facilitate your analysis wasn't anticipated.

VBA's dictionary object is the ideal tool to streamline the index so it will be more effective. Let's look on an pattern of undergraduate test scores, but it can equally be a listing of customer purchases:

Name Test Score
John Test1 10
Andrew Test1 22
John Test2 12
Andrew Test2 25

While this index might be effective, perhaps you need to chart the comparative scores and this format may possibly be preferable:

Name Test1 Test2
John 10 12
Andrew 22 25

Using The VBA Dictionary Object

The dictionary object is analogous to an array or a collection but with more functionality and is much easier to understand. Once you've backdrop up a dictionary, the basic grammar in support of adding up an article goes something like this:

Dict1.Add type, article

The type property is a unique set great store by in support of the article you're saving to the dictionary. So if you're adding up a undergraduate renown the code might be as follows:

Dict1.Add "john", testscores

We'll be responsibility two things to trade our index of test scores:

Create a dictionary of unique undergraduate names
Associate the test scores with the undergraduate renown
Identifying Unique Values With The Dictionary Object

We'll take plus of the detail to facilitate type morals requirement be unique by creating a listing of undergraduate names and it follows that adding up the test scores to the renown. The objective of the code is to create arrays of undergraduate names and test scores, plus an array of test names.

First, we'll create a dictionary order, first-rate the range and create a flexible to unite the test names.

Set dict1 = New Dictionary
Dict1.CompareMode = BinaryCompare

Sheets(1).Activate
Range("a1").CurrentRegion.Columns(1).Select
Tests = ""

Now we can ring through the index and backdrop morals in support of renown, test renown and mark.

For x = 2 To Selection.Count
MyName = Selection(x).Text
MyTest = Selection(x).Offset(0, 1).Text
MyScore = Selection(x).Offset(0, 2).Value

' add the testname to tests if not already added
If InStr(tests, myTest) = 0 Then tests = tests & myTest & "|"

We'll use up first-rate state of affairs to determine if the undergraduate renown has already been added, and if not, we'll add the renown and the former test mark to the dictionary article in support of the undergraduate.

Then, fatefully, if the undergraduate renown exists in the dictionary we'll only add the mark to the text to facilitate is associated with the student's renown.

Select Case dict1.Exists(myName)
Case False
Dict1.Add myName, myName & "|" & myScore
Case True
Dict1(myName) = dict1(myName) & "|" & myScore
End Select
Next

We've pronto got a progression of pipe "|" bordered text strings to convert into a another index, which you can fix in a integer ways, in support of pattern in a another sheet:

ActiveCell.Value = "Name|" & tests
For Each c wearing dict1
ActiveCell.Offset(1, 0).Activate
ActiveCell.Value = dict1(c)
Next

Then we can use up Excel's text to editorial tool or nearly VBA code to convert the another data to a index.

Description: How To Use The Dictionary Object In VBA To Change The Structure Of An Excel Table Rating: 4.5 Reviewer: seputarwisata.com - ItemReviewed: How To Use The Dictionary Object In VBA To Change The Structure Of An Excel Table

Log Shipping Vs. AlwaysOn - Are Standard Edition SQL 2012 Users Limited?
By Chandra Heitzman

The value differential among Microsoft SQL Server 2012 Standard Edition and project Edition (Enterprise outlay roughly four period more) makes set great store by becomes a important consideration. Enterprise's foremost advertising aim is AlwaysOn, a refined form of record mirroring designed to provide remote misfortune recovery on a record level. Standard Edition, however, relies on log shipping in its place of record mirroring, and the largely industry experts consider the latter to be preferable in largely bags, cost notwithstanding.

AlwaysOn does, in detail, offer several advantages more log shipping. These include automatic and rapid fail-over protection, automatic client redirection, easier configuration, full-text log support, built-in group encryption support, and a reduced amount of bandwidth use up with asynchronous proliferation. Wearing addition, AlwaysOn improves on record mirroring by permitting the user to merge multiple databases into individual troop to facilitate can be abortive more at the same time. It furthermore permits up to four replicas in support of a record, while traditional record mirroring single allows individual. Finally, while mirrored databases are forever in a state of recovery to facilitate prevents the use up of to facilitate record while actively mirroring, AlwaysOn can grant read-only access to believed record in support of purposes of exposure and backup.

Even with all of these advantages, three notable cons exist. First, all record mirroring provides both synchronous and asynchronous process modes; AlwaysOn is rejection exception. Synchronous roughly translates to high-safety mode, while asynchronous emphasizes performance. Organizations requiring profound use up of asynchronous process will need to possess fast proliferation interval generation and bandwidth tempo or accept the opportunity of data loss. Second, as mentioned higher than, AlwaysOn necessitates the licensing of SQL Server project Edition on quadruple the cost of the Standard Edition. Third, AlwaysOn requires Windows Server Failover Clustering (WSFC) which is single supported in Windows Server 2008 project Edition or anon editions.

With the feasible monetary and infrastructure cost of licensing project Edition, nearly organizations may possibly consider Standard Edition a viable alternative, provided they understand the limitations and advantages of log shipping. What a revenue in support of misfortune recovery, it requires more maintenance than AlwaysOn. Log shipping load physical fail-over and the process can take longer than 30 minutes to complete. Likewise, client redirection and role trade require physical input. Weaknesses aside, log shipping provides authentic backup store as part of the process and chains multiple secondary databases.

Given the chance involved in the superfluous expense, businesses may possibly accept uncertainty after deciding which version to license. Organizations must consider implementing the full-featured 180-day trial from the Microsoft tangle locate already accomplishment a final decision. Generally speaking, record mirroring is preferable to log shipping, and AlwaysOn's attempt to pick up on it cannot responsibly be without being seen.

For more in turn approaching SQL 2012 integration services, visit Magenic who obtain been individual of the leading software development companies given that innovative custom software development to collect unique thing challenges in support of nearly of the largely acknowledged companies and organizations in the homeland.

The Benefits Of Auction Bidding Software
By Oliver Brand
During today's hard at it globe of excited schedules and frantic lifestyles, many of us don't grasp the while to joke about the traditional way at what time it comes to online bidding sites.

With online auctions flattering such a worldwide phenomenon, it is at this time flattering increasingly potential - and increasingly likely on behalf of to facilitate concern - on behalf of buyers and sellers to not even be from the same rural area, permit unaided the same while zone. This way to facilitate in roughly circumstances, an online seller can spirit on individual of the hundreds of online bidding sites which exist in our day and place their goods on behalf of auction in come again? Is, to you, the central point of the night. But while it can be the central point of the night on behalf of you, it can very well be the central point of the daylight wherever the seller is redistribution from. And since largely of these bidding sites offer bidding durations of 24 hours or as sky-scraping as 7 days, this way to facilitate the sale will close on the same while of the daylight or night on which it in progress.

This presents a major obstruction on behalf of one knowledge user of online bidding sites. You look at, as one online bidder worth his salt will know, the way to do steady you win an online sale is by insertion your tender in the dying minutes of the sale. And at what time we say the dying minutes, we mean as close to the sale close while as potential.

Doing this manually can be a risky and arduous entity to progress acceptably. This of stream makes it more likely to facilitate you will lose the sale, and therefore fail to secure the consequence to facilitate you had your mind series on on behalf of so long. Well, I don't know nearly you, but to facilitate is hardly individual danger which I am not prepared to take.

This danger of behind an sale to facilitate we so waywardly famine to win is come again? Hard-pressed the industry to realize a solution. There are at this time a entire heap of companies off at hand who can offer to automate your bidding process on behalf of you all the way through a entire range of online bidding sites, and therefore transfer you much advanced probability of sensation in your online auctions.

They piece like this... You tell the bidding software nearly the meticulous sale to facilitate you are interested in and famine to win. The software will in that case robotically place a tender on your behalf in the dying seconds of the sale duration, and therefore greatly spread your probability of winning the online sale. Since the entire process is prepared robotically and by multipart and complicated CPU systems, your tender can be placed much closer to the dying while of the online auctions than you can convincingly hope to reach from manually bidding on these lots.

It is a without favoritism austere, but highly effectual way of utilising bidding sites to their fullest promise. Used perfectly, these online sale sites can be a boundless way to do roughly brilliant purchases online. You hardly grasp to know how to management them as it should be.



Description: The Benefits Of Auction Bidding Software Rating: 4.5 Reviewer: seputarwisata.com - ItemReviewed: The Benefits Of Auction Bidding Software

How To Hide And Unhide Rows With Your Own VBA Filter In Excel
By Andy L Gibson

While the tools in Excel in support of filtering data are proficient, they can be a little tricky to use up and it might be sensible exploring a VBA solution in support of extracting the in turn you need from your database.

Wearing this article, we'll create a code morsel to facilitate hides data and toggles the filter on and rotten. While paying attention on a uncomplicated scenario the code can be enhanced to create your own filtering tool.

Creating A Simple Toggle Filter With VBA

The scenario we'll look on is simply to extract all the rows in a index to facilitate contain a guaranteed customer renown.


Name, Invoice#

Nuts and bolts Ltd,123

Johns Company,124

Nuts and bolts Ltd,234

DEF Ltd,345

Nuts and bolts Ltd,432

We'd only like the user to first-rate a customer renown in the index and the code must secrete other rows not containing the renown. If the code is run again the filter must be impassive.

When the user clicks on a renown to search in support of the code ensures the selected cell is in editorial 1:


Sheets(1).Activate

Searchfor = ActiveCell.Value

If ActiveCell.Column <> 1 Then

MsgBox "Please first-rate a cell in editorial 1"

Exit Sub

End If

Next, we first-rate the editorial to search and ring through the data to discover the search row:


Range("a1").CurrentRegion.Columns(1).Select

For x = 2 To Selection.Count

Now we obtain to determine whether or not the filter is in place.

If the cell does not match the search text AND the row is hidden, it follows that the filter is in place. Therefore, we earn visible all the rows and exit the routine.

If the cell does is not a match AND the row is visible, it follows that we secrete the row and carry on filtering the data.


If InStr(Selection(x), searchfor) = 0 Then

Select Case Selection(x).EntireRow.Hidden

Case True

Selection.EntireRow.Hidden = False

Exit associate

Case False

Selection(x).EntireRow.Hidden = True

End Select

End If

Next

While this is a uncomplicated code morsel it can be used "as is" in guaranteed situations. For pattern if the same search is used repeatedly it might be a proficient candidate in support of creating a uncomplicated macro button to run the code, quite than apply a complicated solution linking VBA User Forms.

Summary

Although this code mimics filtering to facilitate is readily free in Excel, largely users discover to facilitate a little VBA facts will pick up functionality applicable to specific situations quite than relying on a common solution.

What Coding Languages Are Used To Develop iPhone Apps?
By Andrew Tucke
While it possibly will sound like a very technical undertaking, someone with a superior data of object oriented central processing unit encoding can with no trouble develop iPhone apps. However, due to restrictions placed by Apple, not all object oriented encoding languages are fit on behalf of would be developers. Here is a detailed director on come again? Encoding language is paramount and how paramount to manage the task.


Apple restricts all apps inescapable on behalf of launching on its Apple food to be based on Objective C as a encoding code. Objective C is a hybridized form of the more universal C encoding code. It is potential to create good enough applications using other languages and therefore using a wrapper API to get as far as it look like Objective C but this possibly will not continually toil.

At home order to develop a superior app to will make a sufficient amount popularity with iPhone users, you need to take advantage of a Mac central processing unit. For the paramount results, pass on on behalf of solitary with an Intel based mainframe, first running MAC OS X. Having the status of such, you will not include to disturb by hand with judgment on the order of compatibility of the applications you develop as they will already be optimized on behalf of take advantage of on iOS plans.

The subsequently step is essentially calm. After setting up your MAC, pass on and download the iPhone app developer SDK (Software Development Kit) from the Apple website. Apple provides the SDK on the house of charge and it contains everything you need to arise as well as the surroundings XCode as well as the simulator to allows you to test the apps otherwise launching them.

Brush up on your OOP (Object Oriented Programming) skills especially as they apply to Objective C. It has in many ways similarities with Java as it hides the complexity of the underlying hardware leaving you to concentrate on the technical aspects of the single-mindedness itself and not the platform on which it will run. Today present are sufficient of on the house online tutorials to director you.

Start by text minimal programs. Being too ambitious to arise with can cause you numerous problems in the impending. It is paramount to performance it safe by creation with a stage set of handy projects and slowly but surely qualifying to more thorny and challenging tasks as your skills and confidence increases. Unlike more safe OOP languages like Java, a single misplaced byte in an Objective C code possibly will pilot to your series booming as a intact.

After taxing your single-mindedness adequately on the simulator, you need to migrate to the real iOS surroundings. To organize this, you need to register original with the sanctioned iPhone developer series. You will need to forfeit a fusion fee of $99. After you include signed the agreement to abide by Apple's code of conduct, return the form to arise taxing your single-mindedness on a real iPhone surroundings.

Becoming a superior Apple plans single-mindedness developer is more on the order of having the restore skills and tools sooner than being a certified programmer. Learning the restore object oriented coding will help you to develop iPhone apps to are geared up to launch on the tangible plans. Once you make registered as a developer, you can launch them online and await them to be downloaded by enthusiasts.

Visit Cr

Description: What Coding Languages Are Used To Develop iPhone Apps? Rating: 4.5 Reviewer: seputarwisata.com - ItemReviewed: What Coding Languages Are Used To Develop iPhone Apps?

How to Learn Programming Faster
By Najaf Irshad Bhatti
It will take nearly generation to be trained a few of the training languages to facilitate are free. However, this doesn't mean it has to consume the recreation of your life! There are a little things to facilitate can be completed which can earn it much easier to be trained a notebook syllabus. One of the largely of the essence things to remember is to not extend too fast. It is better to perceive it suitable former and it follows that move on. This is better than responsibility something incorrectly and frustrating to sum in a daze wherever it all went wound so you can install it. It can take a plight more generation to fix it incorrectly and try to install it than it can to time-consuming down and fix it perfectly the former generation. Many period students try to extend too quickly through the introductory in turn and goal up falling extra behind. It is of the essence to take your generation.

Example Codes
Even though you are evaluation a order or other forms of instructional equipment you need to take your generation to earn clear in your mind to facilitate you understand the material. Code is the basis of all training and so you will hanker after to take the essential generation to read all the examples of code to facilitate goes with the text portions. Look on the code and try to understand why it does pardon? It does. Take your generation with all of the examples to facilitate are provided and earn clear in your mind you can earn perceive of the text and the code at the same time.

Run the Code
Reading the text and looking on examples of code it can be simple to pass on more it and think to facilitate you obtain it or to facilitate it makes perceive. This can be quite tricky. There is single individual way to determine if you really fix understand it or not. Type the code in and run it. Do not imitate and paste even though this is much quicker - it will not express your understanding. Make guaranteed to facilitate the code does exactly pardon? You think it is untaken to fix in real life.

Write Your Own Code
When you commence to understand how the code moving parts it is beneficial to put pen to paper your own as soon as you can. Even if you are not clear in your mind to facilitate you fully understand it can be very beneficial to yield it a shot anyway. This will force you to think approaching all of the elements to facilitate extend into the printed code. It is feasible to use up the examples in a few of your books or equipment. You may possibly only try something very uncomplicated and small, but it will help you commence to grasp the concepts to facilitate will be used on a better size.

Find new Resources
It is very feasible to misunderstand a part of the code, or to facilitate the way in which it was explained was not thorough adequate in support of you. It can be very beneficial to discover more in turn online or even from other classmates or tutors. Sometimes it is all in the way material is presented. Try rephrasing your coaching in other stipulations by using your own terminology. There are profusion of message boards online which can offer a plight of expert advice and many blogs from which to pull out applicable in turn.

Programming languages can be awkward but by utilizing all of the free assets it can be made a much simpler process. Applying nearly generation and effort to the equipment to facilitate are being presented and allowing profusion of generation to practice literature code can be beneficial ways to absorb and apply pardon? Has been covered. Talking approaching the processes with other professionals and practicing literature code can be very proficient ways to process in turn.

Najaf Irshad Bhatti

Seven Reasons That Make PSD to WordPress Conversion an Obvious Choice
By Mike A. Swan
WordPress has been around since 2003 and with all leaving day its popularity has touched another heights. Gone are the period after WordPress accompanied single bloggers, in the present day even the busiest of non-blogging websites are being supported by WordPress. Pondering more the reasons of this immense fan following to facilitate WordPress has normal more the years; we roll up across nearly amazing skin and payback to facilitate are exclusive only to WordPress. If you are a thing vendor and longing to obtain a robust website to facilitate search engines love, it follows that PSD to WordPress conversion is the top-drawer you must earn! Want to explore more approaching the wonders WordPress can fix to your thing website? Here 10 unbelievingly authentic skin to facilitate will trigger you to convert PSD to WordPress:

1.) Manage Your Website- Anytime, Anywhere: You can access your website from anywhere. Since WordPress is browser based, you can use up your website from a few notebook approach, irrespective of the IP. All you need is a running internet connection!

2.) Get Enhanced Usability: What you convert PSD to WordPress, you benefit from the benefit of enhanced usability. WordPress is very uncomplicated to use up and and so the effort of development is considerably abridged. Just a little clicks and you can add pages, images, videos, hyperlinks and all that. In a breeze.

3.) Make Search Engines Fall in dear with Your Website: The search engine optimization skin in WordPress are very precise. The coding on the back-end is clean and uncomplicated, which allow the search engines to certainly guide website content. Moreover, you perceive the option of assigning all side it's particular Meta tag, Meta keywords, kind and title. This helps in making the search engine optimization process more under fire. With everything so much in place, search engines are surely untaken to fall in love with your website.

4.) Say Goodbye to FTP and HTML Hassles: Websites built using PSD to WordPress conversion are complete approach in them and in this way don't need supplementary FTP and HTML software.

5.) You are the Boss: WordPress makes you the boss of your website. You need not rely on the designers and developers a few more in support of the slightest of changes. With the simple and intuitive interface of WordPress, you can control all the skin of your website and earn changes on your own.

6.) Speak Your Mind Out with Built-in Blog: What you convert PSD to WordPress, you perceive several supplementary payback and a built-in blog is individual of them. You can certainly integrate blogs in your website. Furthermore, you perceive the option to enable RSS feeds, email subscriptions, commenting capabilities and add posts from the blog to your website inevitably.

7.) Your Website Grows with Your Business: Scalability is a prime star to facilitate PSD to WordPress sites offer. You can keep adding up pages and content to your website, but the functionality of the website will linger intact. This revenue as your thing achieves another milestones; your website can grow too!