How to Import Contacts from Excel Sheet into iPhone and iCloud #how #to #import #excel #contacts #into #iphone, #export/transfer/upload/open #contacts #from #excel #to #iphone, #transfer #excel #contacts #to #iphone/icloud, #to #iphone #contacts #converter/conversion, #sync #icloud #to #iphone #contacts, #copy #excel/icloud #contacts #to #iphone


#

How to Import Excel Contacts into iPhone

Starting from ‘Project Purple’ to becoming a class of Smartphone; ‘Apple iPhone’ firmly managed to break through the criticism and become a successful line of phone. iCloud on the other hand ensures that every user is updated with the latest of everything without any efforts required to be made. Apart from handling updates on your devices and helping you find it when lost, iCloud also comes handy in sharing data. vCard file containing both; single or multiple contact information can be imported on the platform and further shared ahead.

If there is any requirement of importing contacts from MS Excel sheet into iPhone or iCloud device then go for the process of Excel to iPhone contacts conversion discussed below.

To Export Contacts from MS Excel Sheet into iPhone, Follow 3 Steps

To execute process of Excel to iPhone contacts conversion. it is required to first transfer the contacts from Excel spreadsheet into iCloud. After contacts gets transferred into iCloud then it can be easily import into iPhone device.

  • Download “RecoveryTools for MS Excel ” converter tool, Click Browse to select the Excel file and then after file gets successfully load then click on “Next”

  • Once Excel file gets successfully added, then start the procedure of mapping Excel field with vCard field, after mapping each field click on add and then map another filed. Once done with the mapping process, click on “Next”
    • “vCard 3.0 Version” to get vCard file format of 3.0 edition
    • “Allow Empty Email Address” to get converted those contacts which doesn’t have email addresses

    To, save exported contacts from Excel into vCard select a destination location. By default. software saves VCF file in desktop.

  • Now when all contacts from Excel spreadsheet is transferred into VCF file, then this vCard file can be easily imported into iCloud and after successful addition of contacts into iCloud it can be sync with iPhone smoothly.

After completion of Excel to vCard conversion, now users need to import vCard file saved contacts into iCloud which can be further copied into iPhone device.

  • To start the process of VCF to iCloud conversion process, open www.icloud.com in your browser

  • Now you will be asked to sign-in with your Apple ID and PW. enter the details to access your account in iCloud
  • Now you will get the following screen, from the available menu options click on “Contacts”

  • In the bottom left corner you will get a gear icon. click on it and from the available options click on “Import vCard”

  • Select the VCF file from your machine and then click on “Open”

  • Now, vCard to iCloud importing process will be started automatically

  • After contacts gets successfully added in iCloud account, you can easily check them

    Once the contacts get added in iCloud account, it gets automatically synchronized with your iPhone device if you have already added the same iCloud account in your device. To check whether contacts from iCloud to iPhone get successfully transferred then check the contacts in your iPhone device.

    Now when the contacts gets copied from iCloud into iPhone device then users can open the contacts and check the information stored in it. Excel to iCloud converter tool is effective utility to transfer all contacts from Excel spreadsheet into iPhone device.

    Copyright 2012-2017 RecoveryTools . All rights reserved


  • Know The Rules For Roth 401(k) Rollovers #rollover #into #roth #ira


    #

    Know The Rules For Roth 401(k) Rollovers

    During turbulent financial times, when layoffs are rampant, it is important to have a sound financial plan to weather the uncertainties. It is equally important to be aware of what your options are with regard to your employer-sponsored retirement plan in the event you are let go. The rollover options for 401(k) accounts are probably well known by now, but this may not be the case for Roth 401(k) accounts. If your job is at stake or you’re considering a career move, read on for a look at options for handling your Roth 401(k) account. (For background reading, see A Closer Look At The Roth 401(k) .)

    Roth Contributions and Gross Income
    The Economic Growth and Tax Relief Reconciliation Act of 2001 (EGTRRA) provided for designated Roth contributions that new or existing 401(k) and 403(b) plans can accept. This new feature became effective for years beginning on or after January 1, 2006. Unlike deferrals to traditional 401(k) accounts, the deferrals to a Roth 401(k) are on an after-tax basis. In other words, the amount of the Roth contribution is included in an individual’s gross income and therefore taxed on the amount being deferred as if the individual had actually received the money.

    The rollover options for a Roth 401(k) follow those of a traditional 401(k). That is, you can roll the funds over to an IRA or into a new employer’s 401(k). Just like the distribution of a traditional 401(k) is moved into a traditional IRA, the distribution from a Roth 401(k) rolled into a Roth IRA. If your new employer has a Roth 401(k) option and allows for transfers, you may also be able to roll the “old” Roth 401(k) into the “new” Roth 401(k).

    The best way to accomplish either rollover is from trustee to trustee. This ensures a seamless transaction that will not be challenged later by the IRS as to whether it was made for the full amount or in a timely manner. If, however, you do decide to have the funds sent to you instead of directly to the new trustee, you can still roll over the entire distribution to a Roth IRA within 60 days of receipt. If you choose this route, however, the payer is generally required to withhold 20%.

    Distributions Issues
    What happens, though, when you want to take distributions from either the new Roth 401(k) or the Roth IRA that houses the rollover funds? As far as distributions from the new Roth 401(k), that depends on the plan itself; your new employer’s human resources department should be able to assist with that.

    Roth IRA contributions can be withdrawn at any time tax-free and penalty-free regardless of age. However, the rules for distributions of earnings vary. As you may already know, a qualified distribution from a Roth IRA is one that is made after the five-year rule is met and after age 59.5, after death, as a result of disability or for a first home purchase (limits apply). These qualified distributions are both tax and penalty free. Nonqualified distributions subject to income taxes are distributions of earnings that do not meet the five-year holding rule but are made after the age of 59.5, due to disability, death or for a “life event”. Nonqualified distributions subject to both income taxes and penalties are distributions of earnings in which the five-year rule are not met and the individual is not at least 59.5, disabled, deceased or experiencing a “life event”. This may sound relatively simple but the five-year rule can be tricky. (For more insight, read Asset Distributions A Key Consideration For Retirees .)

    If you decide to roll over the funds from your old Roth 401(k) to your new Roth 401(k) by trustee-to-trustee transfer (also called a direct rollover ), the number of years the funds were in the old plan can count toward the five-year period for qualified distributions. However, the previous employer must contact the new employer about the amount of employee contributions and the first year they were made. (For other considerations, see How After-Tax Rollovers Affect Your IRA .)

    If an employee did only a partial rollover to the new Roth 401(k), additional reporting would be necessary by the new Roth 401(k) and the five-year period starts again. That is, you do not get credit for the amount of time the funds were in your old Roth 401(k).

    From Roth 401(k) to IRA
    If the rollover is to a Roth IRA instead, the holding period within the Roth 401(k) does not carry over. That is, if the client has an existing Roth IRA, once the Roth 401(k) distribution is in the account, it has the same holding period as the Roth IRA funds. For example, let’s assume that the Roth IRA was opened in 2000. You worked at your employer from 2006-2009 and were then let go or quit. Because the Roth IRA that you are rolling the funds into has been in existence for more than five years, the full distribution rolled into the Roth IRA meets the five-year rule for qualified distributions. On the other hand, if you did not have an existing Roth IRA and had to establish one for purposes of the rollover, the five-year period begins the year the Roth IRA was opened, regardless of how long you have been contributing to the Roth 401(k).

    Conclusion
    Rolling over a Roth 401(k) into a Roth IRA is usually the optimal thing to do particularly because the options within an IRA are typically significantly greater and better than within a 401(k) plan. Although it is usually not advisable to tap retirement funds, in desperate times the unthinkable may become the only option. The need for these retirement funds should be considered prior to rolling the money into an IRA, particularly if there is not one already in place, as this would begin the five-year holding period anew. Before making a decision, speak to your tax or financial advisor about what may be best for you.


    Knowledge Base #determine #number #of #learners #who #have #completed #different #stages #of #multiple #online #courses,array #formula,blank,calculate,calculatetable,countif,distinctcount,filter,frequency,hasconevalue,if,match,max,min,row,sumproduct,vlookup,iferror,index,small,cubemember,cuberankedmember,cubeset,cubevalue,topcount.,generate #a #list #of #assignees #for #different #projects #based #on #a #competency #matrix,address,indirect,sum #the #largest #5 #of #the #last #10 #numbers #in #a #row #ignoring #blanks,column,offset,subtotal,sum,cortana,sand #dance,powerbi.com,powerbi #desktop,natural #language #queries,convert #a #text #entry #into #its #number #equivalent,len,lookup,mid,rept,text,compute #an #average #for #the #same #day #in #the #past #3 #years,averagex,countax,earlier,format,year,visualising #data #flows #using #custom #visuals,summarise,union,sales #data #modelling #and #interactive #visualisations #of #an #e-commerce #company


    #

    The firm may or may not have glass sheets of this specific size. The objective is to identify glass sheets, from the inventory on hand, which match customer specifications. If there is no exact match, then one must be able to obtain all inventory items which have the same Thk (MM) and CAT as the customer specified dimensions but the Length and thickness should be more than equal to the customer specified dimensions. The length and width can then be trimmed to match the exact customer dimensions. Furthermore, the result returned should:

    1. List only the Top 30 glass sheets available in inventory; and
    2. List those Top 30 glass sheets in ascending order of wastage (wastage caused when the glass sheet is trimmed to match the customer specified dimensions)

    You may refer to my solution in this workbook. I have shared two solutions – one using Excel formulas and the other using Power Query a.k.a. Get and Transform in Excel 2016. Please read the Comments in cells F1, J9 and J16 of the “Solutions” worksheet. The difference between the 2 solutions is:

    1. Formula driven solution This is in range J10:AM14 of the Solutions worksheet. This is a semi dynamic solution (as compared to the Power Query solution). To get the models in ascending order of wastage, one will have to create an Area column in the base data and sort that column in ascending order.
    2. Power Query solution – This is in range J17:AM21 of the Solutions worksheet. This is a dynamic solution. Just change the customer specified dimensions in range G2:J2 of the Data and Query worksheet. Thereafter just right click on any cell in the range below and select refresh.

    Posted by Ashish Mathur on November 2, 2016

    Here is a simple four column dataset

    A simple Pivot Table (with a slicer) created from this dataset looks like this

    The objective is to determine the Top 3 users of each week for each slicer selection. Unfortunately, there is no way to sort multiple columns of a Pivot Table all at once. Once may either sort by the Grand Total column or by the individual week wise columns. Since we do not want to sort by the Grand Total column, the only way out is to sort the individual week wise columns. The expected result should look like this:

    I have solved this problem by using CUBE formulas. You may refer to my solution in this workbook .

    Posted by Ashish Mathur on September 20, 2016

    Here is a small sample of a Project matrix which shows tasks to be accomplished for various projects. There can only be upto 6 tasks per project.

    From these two tables, one may want to generate another table showing which employees can be assigned to which project (only those employees should be assigned to a project who can complete all tasks). So the ideal solution is to create another column (8th column) in the Project matrix table above which should have a drop down (Data Data Validation) for every project showing which employees are competent for that project.

    Here’s an illustration :

    Assuming that the Project matrix is in range A1:G4 (headers are in row 1)

    1. In cell H2 (for Project1), the drop down should show Jane, Lynda, Paddy and Tom. Mary should not appear there because she cannot perform one of the 3 tasks required to complete the project i.e. Gardener.
    2. In cell H3 (for Project2), the drop down should show Lynda, Paddy and Tom. Jane and Mary should not appear there because they cannot perform the Digging and Engineering tasks respectively.

    The solution is dynamic for the following:

    1. Projects added to the Project matrix Table; and
    2. Tasks added (upto 6 only) or edited in the Project matric Table; and
    3. Employees added to the Competency matrix Table; and
    4. Tasks added to the Competency matrix Table

    I have solved this problem by using:

    1. Power Query; and
    2. Formulas in Data Data Validation.

    You may download my solution workbook from here or here .

    The objective is to generate the numeric code for text code of any length entered in a certain cell. For example, a user will type a certain text code, say ABEJ and the expected result should be 1250. For JABF, the result should be 0126. The text entry and text length are both user determined.

    With ABEJ, typed in cell D2, enter this array formula in cell E2

    This formula can now be copied down for generating the numeric code for all text codes entered in column D.

    Posted by Ashish Mathur on January 28, 2016

    Assume a simple two column dataset with dates in column A and numbers in column B. The dates in column A are from January 1, 2013 to December 31, 2016 and numbers in column B are for the period January 1, 2013 to December 31, 2015 (there are no numbers for January 1, 2016 to December 31, 2016).

    The objective is to “Compute an average for each day of calendar year 2016. The average should be for the occurrence of that day in the previous 3 years”. Here’s an example:

    1. January 1, 2016 was a Friday (the first Friday of 2016) and is in cell A1097
    2. In cell B1097, the average should be computed as: Average of the “First Friday of each of the previous 3 years”
    3. January 8, 2016 was a Friday (the second Friday of 2016) and is in cell A1104
    4. In cell B1104, the average should be computed as: Average of the “Second Friday of each of the previous 3 years”

    I have solved this problem with the help of the PowerPivot. You may refer to my solution in this workbook .

    Posted by Ashish Mathur on January 17, 2016

    Given this dataset, one may want answers to the following questions:

    1. Of all those passengers who originated their journey (City of Origin) from Chandigarh, how many terminated their journey (City of destination) in New Delhi via different modes of transport; and
    2. Of all those passengers who terminated their journey (City of destination) in Jammu, how many arrived in Amritsar (City of Origin) via different modes of transport; and
    3. Of all those passengers who travelled by Bus, how many travelled from City A (City of Origin) to City X,Y,Z (City of destination)

    While one can analyse/slice and dice this data using Pivot Tables, one cannot visualize this data very clearly (even after creating a Pivot chart). I have attempted to visualize this data using a software called PowerBI desktop (a free for download and use Business Intelligence software from Microsoft which rolls all of Excel’s BI tools into 1 – PowerPivot, Power Query, Power Map and Power View).

    You may download the source Excel workbook and the Power BI desktop workbook from this link .

    You may also watch a short video here:

    Posted by Ashish Mathur on November 13, 2015

    In this workbook. I have Sales data of an E-Commerce Company for 3 months. The typical columns in the base data are:

    1. Order Date/Time
    2. City to which orders were shipped
    3. Order Number
    4. Payment Type i.e. Cash on delivery, Net Banking, EMI’s
    5. Order Status i.e. Delivered or cancelled
    6. SKU’s which the ordered items fall into
    7. Products which the ordered SKU’s fall into
    8. Categories which the ordered products fall into

    Given this simple tabular representation, one may want to analyse and visualize this dataset from multiple perspectives based on user selections, such as

    “What was the revenue earned from the Top 5products in the A100 category in April for orders shipped to New Delhi ?”

    In this query framed above, the end user should have the leeway to select any/all of the underlined facets. So one can either choose revenue earned or Number of orders. Likewise, one can either select Top 5 products or Top 15 products/Top 5 SKU’s etc.

    With relative ease, one should also be able to “Perform an affiliate analysis” showing which categories are ordered together (to study affiliations). Please review this post for an independent discussion on “Affinity Analysis”.

    Furthermore, one should be able to perform a free form timeline search such as – “I would like to study growth in Total revenue of March 2-8 2015 over Feb 1-4 2015”

    You may download the workbook from the link shared above.

    You may watch similar videos showcasing the capabilities of Business Intelligence in MS Excel:

    Here’s a video showing the capabilities of this Sales data model

    You may also watch this short video to see how I visualized the revenue flow from Categories to Shipping cities during different Order periods using Custom visuals available in PowerBI desktop.

    Please feel free to download the PowerBI desktop workbook of the video shown above from here .

    For a detailed overview of Sankey diagrams (a Custom visual available in PowerBI desktop), you may refer to my Blog article here .

    Another great Custom visual (Sand Dance) which allows data discovery has been shown at this link. At that link, you will also be able to see how I queried the underlying dataset using “Natural Language”.


    Creating an Email Blast #andrew #duck,awebber,aweber,best #dimensions #to #make #email #blast,blast #companies,building #an #email #blast #template,building #blast #email #templates,can #i #create #an #eblast #in #word,can #you #use #word #doc #for #email #blast,cari #adams,cintia #nunes,constant #contact,crafting #a #email #blast,create #a #email,create #a #email #blast,create #a #simple #e #blast #in #ms #word,create #an #eblast #in #word,create #an #email #blast #in #word,create #e-mail #blast #with #links,create #eblast #from #word #document,create #email #blast #using #word #2010,create #email #blast #with #link,creating #an #e #mail #blast #template,creating #an #eblast #in #word,creating #an #email #blast,creating #an #email #blast, #filetype:pdf, #filetype:ps, #filetype:dwf, #filetype:kml, #filetype:kmz, #filetype:xls, #filetype:ppt, #filetype:doc, #filetype:rtf, #filetype:swf,creating #an #email #blast #database,creating #an #email #blast #from #a #webpage,creating #an #email #blast #in #outlook,creating #e #blasts,creating #e #blasts #with #links,creating #e-blasts #from #microsoft #word,creating #eblast #in #word,creating #eblasts #using #microsoft #word,creating #email #blast #in #microsoft #word,creating #email #blasts, #filetype:pdf, #filetype:ps, #filetype:dwf, #filetype:kml, #filetype:kmz, #filetype:xls, #filetype:ppt, #filetype:doc, #filetype:rtf, #filetype:swf,creating #email #blasts #for #your #company,creating #email #blasts #with #outlook,death #valley,design #a #email #blast #in #microsoft,design #an #email #blast,designing #an #email #blast,designing #an #email #blast #in #word,designing #email #blast,dimension #for #email #blast,dimensions #for #email #blast,e #blast #template #size,eblast #template #for #word,eblast #templates #ms #word,eblast #using #microsoft #word,ecommerce #email #blast #template,email #blast,email #blast #companies,email #blast #create #template #online,email #blast #creating,email #blast #design #dimensions,email #blast #dimensions?,email #blast #email #formatting #free,email #blast #how-to #word,email #blast #in #microsoft #word,email #blast #promotion,email #blast #server,email #blast #servers,email #blast #template,email #blast #template #format #ms #word,email #blast #template #outlook #2010,email #blast #templates,email #blast #templates #in #word #free,email #blast #templates #microsoft,email #blast #test #online #outlook,email #blasts,email #blasts #free,email #marketing,email #providers,emails,fairfield #inn,formatting #an #e #blast #in #word,free #email,free #email #blast,free #email #blast #template,free #email #blast #templates,free #email #blast #templates #in #micosoft #word,free #email #blast #templates #in #word,holster,how #create #email #blast,how #to #create #a #blast #email #in #word,how #to #create #a #eblast #from #word,how #to #create #a #eblast #in #word,how #to #create #a #email #blast #promotion,how #to #create #a #email #blast #server,how #to #create #a #email #blast #template #in #word,how #to #create #an #eblast,how #to #create #an #eblast #template,how #to #create #an #email #blast,how #to #create #an #email #blast #in #word,how #to #create #an #email #blast #page,how #to #create #and #email #blast,how #to #create #blast #emails,how #to #create #curaytor #email #blast,how #to #create #different #email #blast #in #outlook #2010,how #to #create #eblast #in #microsoft #outlook,how #to #create #email #blast #microsoft #word,how #to #create #email #blast #template,how #to #create #email #blasts #from #scratch,how #to #create #own #email #blast,how #to #create #wonderful #eblast #with #word #doc,how #to #design #an #email #blast,how #to #develop #a #email #blast #series,how #to #do #an #e #blast #from #word,how #to #do #your #own #email #blasts,how #to #eblast #a #word #document,how #to #format #an #eblast #email,how #to #generate #an #email #blast,how #to #make #a #design #for #a #email #blast,how #to #make #a #email #blast,how #to #make #an #eblast #in #word,how #to #make #an #eblast, #social,how #to #make #an #email #blast,how #to #make #email #blast,how #to #make #email #blast #with #live #links,how #to #make #word #into #e-blast,how #to #reate #an #email #blst #template,how #to #send #eblast #in #word,launching #eblasts #with #microsoft #outlook,le #meridien #hotels,liver #damage #keflex,mail #blast,mail #blast #server,make #email #blast #from #microsoft #word,making #a #mail #blast,microsoft #outlook #email #blasts,microsoft #word #e-mail #blast #templates,olympic #airways,omni #hotels,popular #email #blast,product #email #blasts #format,publisher #e-mail #blast #template,raul #trambitas,send #eblast #from #outlook,send #email #blasts #free,shamlin,size #to #make #free #email #blasts,streamsend,swf #email #blast,tap #air #portugal,terry #canny,top #email #service,top #email #service #providers?,tripadvisor,unique #email #blasts,use #word #to #make #a #email #blast #template,virgin #atlantic,what #size #do #you #design #an #email #blast #at?,what #size #to #design #an #email #blast,word #2010 #email #blast #template,word #e-blasts


    #

    Creating an Email Blast

    Creating an email blast to market your products to your email list can be very easy or very hard. The difference is found in your email service provider.

    If you are able to basic formatting in MS Word, you will probably be able to use and modify email blast templates to create a unique email blast on your own.

    Reputable email service providers will have dozens of templates and an easy to use interface where you can craft your message. Once your message is ready, most email providers have a tool that will help you upload your list and schedule your send.

    We advise all clients to sign up with multiple email blast companies and create test email blast campaigns in order to find out which one is the easiest to use. Below you will find links to get a free trial from top email service providers. All of the email blast companies below have great support and are very user friendly.

    Remember, with all online marketing, you have only seconds to capture the attention of your prospects. By keeping your design viewable with out scrolling, you will increase response rates.

    Create your email blast today – Free Trial (use links below)

    Sign up for a free trial with the most popular email service providers. Send a few email blasts for free through each email company, then keep the one that works best for you.

    Each of the email blast companies below offers a free trial where you can send your free email blast. We’ve ranked them with the largest free email blast first.

    Free Email Blast Promotion

    1. StreamSend – We prefer StreamSend over all the others. Their setup is easy to use, intuitive and not very expensive. We prefer StreamSend because they charge based on emails sent, not the size of your list. This is important for people who might send once or twice a month.
    2. Awebber – A great platform for people who want to try their hand at marketing automation – where you create a email sales campaign and then send on a time delay (ex. 1 email per day for 7 days.) Awebber charges based on the size of your list, so they may be a good choice if you plan on sending once a week or more.
    3. GetResponse – For marketers looking for more than just an email service provider, GetResponse provides multi-media email blast capabilities, cross-channel tracking and automation, GetResponse may be for you. Not quite as easy to use as StreamSend, but more features. If you want to combine email marketing with social marketing and video, then GetResponse has the tools to do the job.

    Link to this article

    If you find this article valuable please share it on your blog or website with this code:

    Be Sociable, Share!


    Race into Pigeon Forge for Classic Car Shows #low #cost #auto #insurance


    #auto shows
    #

    Pigeon Forge Car Shows

    Automotive enthusiasts head out to the  Smoky Mountains every year to attend at least one Pigeon Forge car show.

    These car shows feature more than just rare and unique autos. Visitors can spend the day looking over new products, swap meet items, and interactive displays from vendors. Workshops are also available for those who are seeking answers to technical questions about autos. All of the Pigeon Forge car shows are a great experience for all who attend.

    Just because you’re visiting for a car show doesn’t mean you have to miss out on all the other great  Pigeon Forge attractions. Also, if you need to make lodging arrangements there is a large variety of  Pigeon Forge accommodations  available.

    View a video of ScottieD’s Dirty Dozen from the Pigeon Forge Spring Rod Run.

    Scroll down to see a complete list of cars shows taking place in Pigeon Forge for the year. 

    Please remember, when there’s a car show or parade in Pigeon Forge, there will be traffic congestion and delays. Most of our guests sit back and enjoy the show; however we suggest noting the dates of these events when planning your visit.


    AutoZone Shifts Into High Gear With New Reporting Solution #waukegan #auto #auction


    #www.auto zone.com
    #

    AutoZone Shifts Into High Gear With New Reporting Solution

    National Retailer Uses WebFOCUS to Tune Up Operational Reporting at 5,200 Stores

    AutoZone attributes its success to its ability to provide customers with the right parts at the right prices. Each of its more than 5,200 stores carries an extensive line of parts for cars, SUVs, vans, and light trucks, including new and remanufactured hard parts, maintenance items, and accessories. Many stores also have a commercial sales program that provides commercial credit and prompt delivery of parts and other products to local, regional, and national repair garages, dealers, service stations, and public sector accounts.

    Since opening its first store in 1979, AutoZone has leveraged technology to grab the lead in the automotive aftermarket industry. Using a highly efficient business model for logistics and distribution, the company has grown steadily for more than three decades. In 1989 AutoZone began using a Store Management System (SMS) to help keep stores stocked with the parts customers need. Soon after, it became the first auto parts retailer to register customer warranties in a computer database. In 1994, AutoZone established a satellite system to broadcast parts information from store to store. The company also has an active online presence.

    It’s an information-intensive business, and that’s why business intelligence (BI) is so important.

    In the past, the IT department generated most of AutoZone’s corporate reports from a mainframe system at AutoZone’s Store Support Center. While these reports were adequate for monitoring basic activities, as the company grew, managers soon discovered they needed additional reporting capabilities.

    AutoZone turned to Information Builders WebFOCUS BI platform, a move that has enabled the company to continue its tradition of technical leadership. WebFOCUS is used throughout the entire organization – from HR training and annual reviews to store operations, wholesale sales support, and customer satisfaction reporting.

    “We wanted to obtain a general-purpose reporting environment that could reveal operational metrics to our management team on demand,” says David Glasscock, director of operation support at AutoZone. “Ideally, this reporting system would be available to our users in the field, so individual store managers could access pertinent data when they needed it. WebFOCUS is giving our store managers access to data that they couldn’t access before. Our reports are timelier, more accurate, and more consistent. That makes a real difference in our operations.”

    Calibrating Custom Reports for a Remote Workforce

    Information Builders demonstrated a platform-agnostic solution that could run on Linux, AIX, and even a mainframe Linux partition. Additionally, each developer license came with eleven days of training. At the time, other BI vendors didn’t offer such training.

    “We didn’t want a reporting environment that could only be understood by analysts,” Glasscock says. “Instead, we needed a user-friendly system that would encourage people to create reports in an intuitive way. WebFOCUS was less expensive than the other BI solutions, and easier for our employees to use.”

    Due to its thin-client deployment architecture, remote users only need a standard Web browser to access the WebFOCUS environment. This is ideal for AutoZone because it enables the IT department to control the data on the reporting servers, yet managers at individual stores can help themselves to the information they need.

    Instead of continually creating new reports, Glasscock and his team are building a library of reports that managers in the sales, HR, and finance departments can access when necessary.

    Moving Into the Fast Lane With Report Templates

    Another thing AutoZone likes about WebFOCUS is its ability to access multiple data sources simultaneously – including flat files from the mainframe, text files, and relational databases. Installed on a Linux platform, WebFOCUS uses iWay Software integration adapters to seamlessly access data from DB2 databases, Informix databases, and flat files. In some cases, data is loaded into data marts that have been pre-sorted and structured for operational reporting. In other cases, users access data from production data sources directly, and even pull data from two different types of databases into a single cohesive report.

    Glasscock especially likes the way WebFOCUS uses reporting templates to let users specify report dimensions, calculations, measures, and other variables, all through a standard Web browser. For example, one report reveals how well the stores are complying with AutoZone’s inventory

    management programs.

    Enterprise Reporting

    WebFOCUS enables timely, accurate business data to be transformed, in real time, into richly formatted reports that can be accessed by everyone across the organization. AutoZone’s BI environment delivers information to more than 5,200 stores, 400 district managers, 50 regional managers, six divisional vice presidents, and 200 users at headquarters – between 10,000 and 20,000 users total.

    Putting End Users in the Driver’s Seat

    WebFOCUS includes dynamic load-balancing technology to transparently route report requests among servers, ensuring rapid and consistent results.

    “We’ve sized the current environment for our needs,” says Glasscock. “As we expand our reporting environment and the workload increases, we can add additional reporting servers that have been clustered to ensure good reliability and performance.”

    Fulfilling AutoZone’s commitment to customer satisfaction means always having accurate information about key performance indicators (KPIs), sales, and labor requirements. Glasscock says WebFOCUS helps AutoZone meet these demands by delivering information that makes everyone in the organization more productive.

    “The biggest benefit I see is in consistent, timely reporting,” he says. “We can move very quickly with this product, which means we can update and change our reporting strategy based on the evolving needs of the company. WebFOCUS gives us a lot of flexibility as we respond to the needs of the automotive market.”


    Car crashes into Londonderry auto parts store #auto #loan #calculater


    #auto store
    #

    Car crashes into Londonderry auto parts store

    By ELI OKUN

    Union Leader Correspondent

    LONDONDERRY A car crashed through the doors into the O Reilly Auto Parts store on Garden Lane Tuesday afternoon, causing some damage inside the store but no injuries.

    Town police and fire officials responded to the scene shortly before 3 p.m. The driver had steered the car entirely inside the store.

    The driver was a woman in her mid-60s, said Fire Chief Darren O’Brien.

    A building inspector was called to the scene to examine the substantial damage, though there didn’t appear to be structural concerns, O’Brien said

    Later that afternoon, caution tape blocked off the store s entryway, but inside could be seen some aisles of merchandise that had been knocked aside, with items strewn on the floor, as employees worked to clean up the store.

    A Londonderry police officer at the scene said officials didn t believe there was alcohol involved it seemed the driver had accidentally stepped on the gas and accelerated. Neither the driver nor anyone in the store were hurt. But the officer declined to provide more information, citing an ongoing investigation.


    Race into Pigeon Forge for Classic Car Shows #auto #parts #discount


    #auto shows
    #

    Pigeon Forge Car Shows

    Automotive enthusiasts head out to the  Smoky Mountains every year to attend at least one Pigeon Forge car show.

    These car shows feature more than just rare and unique autos. Visitors can spend the day looking over new products, swap meet items, and interactive displays from vendors. Workshops are also available for those who are seeking answers to technical questions about autos. All of the Pigeon Forge car shows are a great experience for all who attend.

    Just because you’re visiting for a car show doesn’t mean you have to miss out on all the other great  Pigeon Forge attractions. Also, if you need to make lodging arrangements there is a large variety of  Pigeon Forge accommodations  available.

    View a video of ScottieD’s Dirty Dozen from the Pigeon Forge Spring Rod Run.

    Scroll down to see a complete list of cars shows taking place in Pigeon Forge for the year. 

    Please remember, when there’s a car show or parade in Pigeon Forge, there will be traffic congestion and delays. Most of our guests sit back and enjoy the show; however we suggest noting the dates of these events when planning your visit.


    Car crashes into Londonderry auto parts store #classy #auto


    #auto store
    #

    Car crashes into Londonderry auto parts store

    By ELI OKUN

    Union Leader Correspondent

    LONDONDERRY A car crashed through the doors into the O Reilly Auto Parts store on Garden Lane Tuesday afternoon, causing some damage inside the store but no injuries.

    Town police and fire officials responded to the scene shortly before 3 p.m. The driver had steered the car entirely inside the store.

    The driver was a woman in her mid-60s, said Fire Chief Darren O’Brien.

    A building inspector was called to the scene to examine the substantial damage, though there didn’t appear to be structural concerns, O’Brien said

    Later that afternoon, caution tape blocked off the store s entryway, but inside could be seen some aisles of merchandise that had been knocked aside, with items strewn on the floor, as employees worked to clean up the store.

    A Londonderry police officer at the scene said officials didn t believe there was alcohol involved it seemed the driver had accidentally stepped on the gas and accelerated. Neither the driver nor anyone in the store were hurt. But the officer declined to provide more information, citing an ongoing investigation.


    Philadelphia Auto Show 2015 drives into town Jan. 31-Feb. 8


    #philly auto show
    #

    The Convention Center hosts a week of displays and events

    PhillyVoice Staff

    Car fanatics, start your engines: the Philadelphia Auto Show drives into the Pennsylvania Convention Center Saturday, Jan. 31, through Sunday, Feb. 8. More than 700 vehicles will be on display in 700,000 square feet of space just waiting for you to ooh  and ahh.

    The show is perfect for attendees who are in the market for a new car. Manufacturers will host displays full of knowledgeable people to give you info about your top picks. Better yet, the PAS is a non-selling show, so the “product specialists” won’t be too pushy.

    The best part about the show, of course, is getting to sit in tons of cars. You can pretend you’re a cast member from one of the seven “The Fast and the Furious” movies all day long. Personally, I attend every year just to sit in the latest Volkswagen Beetle and pretend I can afford it.

    The show’s lineup includes 2016 pre-production models from Fiat, Lincoln, Mazda and Buick, along with plenty of Aston Martin, Bentley, Ferrari and Maserati exotics. Classic cars from the ’20s and ’50s also will be on display.

    Over the course of the week, Jeep, Toyota and Kia will offer “Ride Drive” opportunities for select vehicles. At the show’s Face-Off display, you can vote for your favorite car – import versus domestic – and enter to win prize packs that include NASCAR and IndyCar tickets. You’ll also be able to check out custom vehicles owned by Philadelphia Eagles like Chris Polk, Najee Goode and Jeremy Maclin.

    The show will have plenty of food and drink vendors on hand, but with a hand stamp, you can head out to Reading Terminal Market for your midday meal, too. If you’re worried about crowding, head to the show on Super Bowl Sunday when the rest of the world is gearing up for the big game.

    Philadelphia Auto Show

    Saturday, January 31 through Sunday, February 8

    Saturdays: 9 a.m.-10 p.m. Weekdays: Noon-10 p.m.

    Sunday, Feb. 1: 9 a.m.-6 p.m. Sunday, Feb. 8: 9 a.m.-8 p.m.

    Adults: $13, Children ages 7-12: $6, Children 6 and under: Free

    Pennsylvania Convention Center