Fwd: $$Excel-Macros$$ MIS MASTER DATA FORMAT

2014-03-15 Thread Kannan Excel
Hi, Please find the below mail and help me as soon as possible... regards Kannan V -- Forwarded message -- From: Kannan Excel kannan.ex...@gmail.com Date: Wed, Mar 12, 2014 at 4:13 PM Subject: $$Excel-Macros$$ MIS MASTER DATA FORMAT To: Google excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Converting Fortran to VBA: Different results from the same code in two languages?

2014-03-15 Thread Gerrit Grundling
HELPFUL HINT: I paid a severe performance penalty by using WorksheetFunction.Pi. So I created a variable PI instead. There are many ways to calculate π, but I just use this simple relation π ≈ 355/113 On Saturday, 15 March 2014 10:54:42 UTC+2, Gerrit Grundling wrote: Greetings I have

Re: $$Excel-Macros$$ Help!!(Dashboard)

2014-03-15 Thread ashish koul
check chandoo.org http://office.microsoft.com/en-in/templates/dashboard-TC101915534.aspx http://www.skilledup.com/learn/business-entrepreneurship/best-free-excel-templates-dashboards/ On Thu, Mar 13, 2014 at 11:50 AM, Soum soumyendu...@gmail.com wrote: Dear Ashish, Could

Re: $$Excel-Macros$$ Need an address split up formula.....

2014-03-15 Thread ashish koul
is ACT common in all On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Is there any way out to split up an address as per the attached file format! If so then please provide me the formula or vba code (anything). Thanks in advance. -- Indrajit

$$Excel-Macros$$ Copy paste from PDF File

2014-03-15 Thread Shrinivas Shevde
Dear All I want to copy 3 lines group from PDF and want to paste in EXcel.(such I have more than 60 ) When I paste in excel its paste in 3 rows Is there any trick or idea so that this will get paste in one cell only Regards -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Save an Excel file as XML

2014-03-15 Thread ashish koul
http://office.microsoft.com/en-in/excel-help/create-an-xml-data-file-and-xml-schema-file-from-worksheet-data-HA010263509.aspx On Sat, Mar 15, 2014 at 10:28 AM, Eugene Bernard eugene.bern...@gmail.comwrote: How to save an excel table data in XML format. TIA. Eugene -- Are you =EXP(E:RT)

RE: $$Excel-Macros$$ Copy paste from PDF File

2014-03-15 Thread Ravinder
U can use f2 then paste From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Saturday, March 15, 2014 3:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Copy paste from PDF File Dear All I want to copy 3 lines

Re: $$Excel-Macros$$ Copy paste from PDF File

2014-03-15 Thread Shrinivas Shevde
Dear Ravindra Problem solved really great help Thanks Regards Shrinivas On Sat, Mar 15, 2014 at 3:56 PM, Ravinder ravindervbacli...@gmail.comwrote: U can use f2 then paste *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde

$$Excel-Macros$$ Help with forecast sheet

2014-03-15 Thread Gaz
Hi I am really struggling to write a formula that will give me how many weeks stock I have based against a monthly forecast and current stock level, It has to take in to account the rest of the monthly forecast to give me a weeks cover figure.Trying to maintain 8 weeks cover through the year,

$$Excel-Macros$$ How to convert 1 (numeric value) to One (alpha value)

2014-03-15 Thread irshad khan
Hi Team, Is it possible to convert numeric value to alpha value. example : 1 convert One 2 convert Two 3 convert Three Thanks, Irshad Khan -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Abhishek Jain
Does this make any sense? On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear All , Day before Yesterday I had gone for Interview for Data Analyst. They asked me one question but i could not answer it . The Person who has taken my interview, asked me

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread ravinder negi
pls provide some example in excel with chart On Saturday, March 15, 2014 8:12 AM, Abhishek Jain abhishek@gmail.com wrote: Does this make any sense? On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All , Day before Yesterday I had gone for

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Prafull Jadhav
Dear Abhishek Sir, thanks for reply . When we exclude the highest value from chart it average is less that is 44 and that is correct average . But When I show the this chart (included Highest Number ) to my boss , he will surprise that daily Average cabs coming is 123...and that is wrong... It

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Abhishek Jain
Dear Prafull, As per example, a total of 1717 cars were handled in 2 weeks (14 days) which means 123 (rounded off) is the correct average and it is not a wrong info. Now, the average for first week is 48 and for second week it is 197. If you want, we can show week wise averages in the graph or

Re: $$Excel-Macros$$ Need an address split up formula.....

2014-03-15 Thread Indrajit $nai
Yes Ashish... On Sat, Mar 15, 2014 at 3:39 PM, ashish koul koul.ash...@gmail.com wrote: is ACT common in all On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Is there any way out to split up an address as per the attached file format! If so

$$Excel-Macros$$ query need help

2014-03-15 Thread Prabhu Pinky
Hi experts, please find the attached file. my query is. i want to fill dates in sheet2 from sheer1. only weekdays, except sat and sun.. in sheet1 dates will be in vertical, but in sheet2 i want to fill in vertical(except sat and sunday) no alteration should be done in sheet1. please help.

Re: $$Excel-Macros$$ query need help

2014-03-15 Thread Prabhu Pinky
sorry, in sheet 1 dates will be in vertical, but in sheet 2 i want to fill in horizontal. Thanks Regards, Prabhu R On 16 March 2014 08:02, Prabhu Pinky prabhupin...@gmail.com wrote: Hi experts, please find the attached file. my query is. i want to fill dates in sheet2 from sheer1.

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Prafull Jadhav
Dear Abhishek Sir, Very good morning. If I now that ddaily frequency of cabs are between 50 to 80. Because of suddenly increased in cabs for few days this affects the overall average. I just want to show normal average.. Which excluding few days highest cabs. Regard, Prafull Jadhav. 9920553518

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread Sandeep Kumar Chhajer
Hi Praful, This happens everyday in stock market!! I think you should use moving average let's say average of every 5 days and plot everyday's moving average into graph! Thanks Regards, Sandeep Kumar Chhajer Mumbai India Sent on my BlackBerry(R) from Vodafone -Original Message-