We all know how to export the Schedules prepared in the Primavera tool into a spreadsheet format, if not view the tutorial just below.
After Exporting, sometimes it needs to be modified further so as to use it for other reporting purposes, updating of the data in excel. But unfortunately the P6 Exports the data as TEXT format and not into the exact existing format. and Simple "Format Cell" Function in Excel wont solve our problem and this needs a small exercise to make the data to handle simpler. A Sample export of the schedule in P6 into an Excel format has been shown below and the tip will be explained further to that.
If you look at the "Duration" in the Column E of the spreadsheet, you will notice apostrophe (') in front of the duration fields. Similarly you will find it in the date fields even
All the data fields will have this apostrophe (') symbol as the data has been exported in the text format.
Now, let us see the tip/trick to format these fields into the desired format.
Step 1:
Select the column E which needs to be converted to the number format. and click on the "Data" Field in the menu bar.
Step 2:
Now select the "Text to Columns" field in the same menu ribbon. Then you will be able to see the "covert text to columns wizard will be popped up.
In the "Convert text to Columns Wizard -Step 1 of 3, select the "Delimited" option and click "Next"
In the "Convert text to Columns Wizard -Step 2 of 3, select Tab Check box under the delimited group. And in the "text Qualifier" drop down box, select the apostrophe ' and then click on "Next".
In the "Convert text to Columns Wizard -Step 3 of 3, Do not change any of the default settings and Click "Finish" Button and now you will see the data in the Text format in the Column E Converting into Number Format.
Now for the Date Fields,follow the steps as explained above and after removing the Apostrophe symbol as above.In the Format Cell" Dialog, select the "numbers" tab and under category ,select "Custom" and under Type list ,select "dd-mmm-yy" and click ok.
And now the Final cleaned up Spreadsheet will be visible as below and it can be shared and updated with other planners, which would make your updating simpler.
Hope this tip helps you a lot, and any queries can be posted here. A video of this exercise has been posted below for further better understanding.
After Exporting, sometimes it needs to be modified further so as to use it for other reporting purposes, updating of the data in excel. But unfortunately the P6 Exports the data as TEXT format and not into the exact existing format. and Simple "Format Cell" Function in Excel wont solve our problem and this needs a small exercise to make the data to handle simpler. A Sample export of the schedule in P6 into an Excel format has been shown below and the tip will be explained further to that.
If you look at the "Duration" in the Column E of the spreadsheet, you will notice apostrophe (') in front of the duration fields. Similarly you will find it in the date fields even
All the data fields will have this apostrophe (') symbol as the data has been exported in the text format.
Now, let us see the tip/trick to format these fields into the desired format.
Step 1:
Select the column E which needs to be converted to the number format. and click on the "Data" Field in the menu bar.
Step 2:
Now select the "Text to Columns" field in the same menu ribbon. Then you will be able to see the "covert text to columns wizard will be popped up.
In the "Convert text to Columns Wizard -Step 1 of 3, select the "Delimited" option and click "Next"
In the "Convert text to Columns Wizard -Step 2 of 3, select Tab Check box under the delimited group. And in the "text Qualifier" drop down box, select the apostrophe ' and then click on "Next".
In the "Convert text to Columns Wizard -Step 3 of 3, Do not change any of the default settings and Click "Finish" Button and now you will see the data in the Text format in the Column E Converting into Number Format.
Now for the Date Fields,follow the steps as explained above and after removing the Apostrophe symbol as above.In the Format Cell" Dialog, select the "numbers" tab and under category ,select "Custom" and under Type list ,select "dd-mmm-yy" and click ok.
And now the Final cleaned up Spreadsheet will be visible as below and it can be shared and updated with other planners, which would make your updating simpler.
Hope this tip helps you a lot, and any queries can be posted here. A video of this exercise has been posted below for further better understanding.
This comment has been removed by the author.
ReplyDeleteVery nice post regarding project management
ReplyDeleteTechchoc
thank you umair...
DeleteThis information you provided in the blog that is really unique I love it!! Thanks for sharing such a great blog. Keep posting..
ReplyDeletePrimavera training
Primavera Course
Primavera Institute
Thanks a lot for your valuable feedback...
DeleteNice Post. Got to learn new things from this post. I am amazed to see how well you organized this post. your blog style is also very impressive and beautiful. I am very impressed. Great work! Thanks for sharing.
ReplyDeletePrimavera P6 Tutorial
nice post.
ReplyDeleteDataScience Training
DataStage Training
Interesting post. Excellent thought, highly inspiring. Waiting for your future blogs.
ReplyDeletePrimavera Training in Chennai
Primavera Course in Chennai
Best Primavera Training in Chennai
Primavera Training in OMR
Spoken English Classes in Chennai
Best Spoken English Classes in Chennai
SAS Training in Chennai
SAS Course in Chennai
This is really impressive post, I am inspired with your post, do post more blogs like this, I am waiting for your blogs.
ReplyDeleteAviation Academy in Chennai
Air hostess training in Chennai
Airport management courses in Chennai
Ground staff training in Chennai
aviation training in Chennai
air hostess academy in Chennai
Airport Management Training in Chennai
airport ground staff training courses in Chennai
This software of QuickBooks comes with various versions and sub versions. Online Payroll and Payroll for Desktop may be the two major versions and they're further bifurcated into sub versions. Enhanced Payroll and Full-service payroll are encompassed in Online Payroll whereas Basic, Enhanced and Assisted Payroll come QuickBooks Payroll Support Phone Number
ReplyDeleteThanks for article.. also check these Primavera P6 Tricks
ReplyDeleteDial our number to get in touch with our technical specialists available twenty-four hours a day at QuickBooks Support Number.
ReplyDeleteproblem in upgrading the software in the newer version so that you could avail the newest
ReplyDeleteQuickBooks Tech Support Phone Number features, trouble in generating advanced reports, difficulty with opening company file in multi-user mode and thus on and so on.
Welcome aboard, to your support site par excellence where all of your worries linked to the functioning of QuickBooks Enterprise will undoubtedly be addressed by our world-class team of QuickBooks Enterprise Support Number USA within the blink of a watch. If you're experiencing any hiccups in running the Enterprise version of the QuickBooks software for your needs, it is best never to waste another second in searching for an answer for your problems.
ReplyDeleteMaybe you have trapped into a problem with Intuit product and payroll services? You might be happy to understand the best approach to get hold of the consumer support team by dialing QuickBooks 24/7 Payroll Support Phone Number USA. AccountWizy welcome you 24*7 to gain access to the different support services of Intuit products asking for QuickBooks enhanced payroll support.
ReplyDeleteall that's necessary would be to dial QuickBooks Tech Support Phone Number. Show patience; they are going to inevitably and instantly solve your queries.
ReplyDeleteMost of the flourishing Businesses square measure currently on QuickBooks Customer Support Number as a result of the apprehend QuickBooks is that the best once it involves accounting desires and management desires.
ReplyDeleteThis software of QuickBooks Payroll Tech Support Number comes with various versions and sub versions. Online Payroll and Payroll for Desktop may be the two major versions and they're further bifurcated into sub versions.
ReplyDeleteQuickBooks Error Code 6000-301 occurs when accessing the company file in Quickbooks accounting software. This error could be brought on by various defect and damages to QuickBooks desktop. QuickBooks Error -6000, -301 encounters while wanting to use a desktop company file.
ReplyDeleteQuickBooks Help & Support Services provide methods to all your valuable QuickBooks problem and in addition assists in identifying the errors with QuickBooks data files and diagnose them thoroughly before resolving these problems.
ReplyDeleteOur specialist can surely do wonders in addition they get it done every day when a person comes to us along with their QuickBooks problems. Our QuickBooks Tech Support Number team team, especially, tackle every bugs and error of QuickBooks. As a result, among others.
ReplyDeleteAny QuickBooks user faces any sort of identified errors in their daily accounting routine; these errors can vary from 1 another to a large degree, so our dedicated QuickBooks Support Phone Number are well equipped with their tools and expertise to present best possible resolutions right away to our customers.
ReplyDeleteThe list consist of the most typical problems that our QuickBooks Support Phone Number team have surely taken down:
ReplyDeleteQuickBooks Tech Support Phone Number has made scores of internet marketers to get into and sort using their overall financial expenses, manage their accounts swiftly and derive proper plan for future business purposes.
ReplyDeleteYou can type out and send a mail about the errors that have been annoying while using QuickBooks software or dial the Quickbooks Tech Support to obtain quick support through the experts.
ReplyDeleteQuickBooks Error Code 6000-301 encounters while trying to use a desktop company file. This may be either resolved by fixing manually with guidance received from QuickBooks experts or availing contact support from the specialist.
ReplyDeleteAccess it the spot support for QuickBooks for rectifying the technical glitches:
ReplyDeleteGive a call at QuickBooks Payroll Support, if you're encountering any difficulties which can be mentioned previously. If you are facing virtually any problems with your QuickBooks, you'll be able to also make instant calls. Your queries are certain to get resolved with no delays. The locus of your services may be based upon delivering services in shortest span of that time period, without compromising aided by the quality of your services. Our support team is engaged in pre-research to create themselves prepared in advance for the possible errors of QuickBooks. This practice helps them produce you the specified wind up in the given time window. We are there to assist you at QuickBooks Tech Support 24*7 as we try not to disassociate ourselves together with your troubles even through the wee hours.
Issues like these and all the other complex ones are particularly easily resolved by our team at QuickBooks Tech Support Number Our customer support executives are experienced, talented, hardworking a simple yet effective. They put their hundred percent efforts and make certain to have you avail their 24*7 assistance. Call us at our toll-free number or drop us a mail.
ReplyDeleteOur Professionals have designed services in a competent means in order that they will offer the mandatory methods to the shoppers. we now have a tendency to at QuickBooks client Service are accessible 24*7 you just need certainly to call our 247 Tech Support Number which can be found available on the market on our website. Unneeded to state, QuickBooks has given its utmost support to entrepreneurs in decreasing the price otherwise we’ve seen earlier, however, an accountant wont to help keep completely different accounting record files. Utilising the assistance of QuickBooks, users will maintain records like examining, recording and reviewing the complicated accounting procedures.
ReplyDelete
ReplyDeleteSometimes, many QuickBooks Enterprise Support Phone Number users face unexpected issues such as simply linked to QuickBooks online accountant once they just grow their practice for business. Not to mention, some issues associated with QuickBooks company file, QuickBooks email service and heavy and unexpected QuickBooks error 1603 and a whole lot more.
QuickBooks Payroll Tech Support Number has recently redesigned its Support Center and improved the in-software search bar to assist customers find answers to their questions. Phone wait times have also decreased significantly since our last review.
ReplyDeleteIf not, this might be basically the right time to get the QuickBooks Support Phone Number. We have trained staff to soft your issue. Sometimes errors could also happen because of some small mistakes. Those are decimals, comma, backspace, etc.
ReplyDeleteOne will manage the Payroll, produce Reports and Invoices, Track sales, file W2’s, maintain Inventories by victimization QuickBooks. detain mind that QuickBooks Customer Service isn’t solely restricted towards the options that we have a tendency to simply told you, it's going to do a lot more and it’ll all feel as simple as pie.
ReplyDeleteOur Quickbooks technical Support Team help them in a proper way. One of the best technical help is available for Quickbooks Payroll support related issue. We are sure to help you out with your account related queries and much more. The pro advisor has completed professional training and has experience in accountancy. If you would like to learn How To Troubleshoot Quickbooks Error 9999, you can continue reading this blog.
ReplyDelete