Sorry please ignoe my previous mail ..that was sent to this address by accident
On Tue, Feb 11, 2014 at 4:42 PM, sahil chug <sahil2...@gmail.com> wrote: > > Sub SumProduct(RowCount1 As Long, RowStart As Long, ColumnCount As Long) > Dim ColumnStart As Long, ResultColumn > Dim x As Long, y As Long > Dim SumProduct As Double, TempTotalSum As Double > > 'Initialize ColumnStart equal to M' > ColumnStart = 13 > > 'Initialize ResultColumn to column C' > ResultColumn = 3 > > For x = ColumnStart To ColumnCount Step 2 > 'Initialize SumProduct and TempTotalSum to 0.00' > SumProduct = 0.00 > TemTotalSum = 0.00 > For y = RowStart To RowCount1 > If Cells(y, ResultColumn).Value = "Result" Then > > 'Write to Result Row' > > If TempTotalSum = 0.00 Then > 'Checks for Divisor = 0' > Cells(y, x).Value = 0.00 > Else: > Cells(y, x).Value = SumProduct / TempTotalSum > 'fix for the total sum' > Cells(y, x+1).value = TempTotalSum > End If > > 'Reset SumProduct and tempTotalSum' > SumProduct = 0.00 > TempTotalSum = 0.00 > Else > SumProduct = SumProduct + Cells(y, x).Value * Cells(y, x + 1).Value > TempTotalSum = TempTotalSum + Cells(y, x + 1).Value > End If > > Next y > Next x > > End Sub > > > On Tue, Feb 11, 2014 at 4:30 PM, <bangpypers-requ...@python.org> wrote: > >> Send BangPypers mailing list submissions to >> bangpypers@python.org >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://mail.python.org/mailman/listinfo/bangpypers >> or, via email, send a message with subject or body 'help' to >> bangpypers-requ...@python.org >> >> You can reach the person managing the list at >> bangpypers-ow...@python.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of BangPypers digest..." >> >> >> Today's Topics: >> >> 1. { Parsing } (Shashidhar Paragonda) >> 2. Re: { Parsing } (Vaikuntham Jagannath) >> 3. Re: { Parsing } (Shashidhar Paragonda) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Tue, 11 Feb 2014 11:56:21 +0530 >> From: Shashidhar Paragonda <shashidha...@gmail.com> >> To: Bangalore Python Users Group - India <bangpypers@python.org> >> Subject: [BangPypers] { Parsing } >> Message-ID: >> <CAL2NvRxytb0UDqEQXWCcU4hEf7BB8Ht= >> tzmlvvkeud9rjx8...@mail.gmail.com> >> Content-Type: text/plain; charset=ISO-8859-1 >> >> Hello Python hackers >> >> >>> I wanted to write parser for below GHERKIN format, can anyone suggest >> best pythonic approach to parse and extract the details from below eg: >> >> >>> My need is to discard the common english words and extract rest of >> the >> text and write entries to XML ( i thought of using XML, please suggest any >> other format storage ). >> >> Feature: Password management Scenario: Forgot password Given a >> user with email "cu...@cukes.info" exists When I ask for a password >> reset Then an email with a password reset link should be sent >> >> >>> NOTE: Feature, Scenario, Given, When , Then are like keywords in >> above text >> >> >> ----------------------------------- >> Regards, >> >> Shashidhar N.Paragonda >> shashidha...@gmail.com >> +919900093835 >> >> >> ------------------------------ >> >> Message: 2 >> Date: Tue, 11 Feb 2014 15:59:53 +0800 >> From: Vaikuntham Jagannath <vjagannat...@gmail.com> >> To: Bangalore Python Users Group - India <bangpypers@python.org> >> Subject: Re: [BangPypers] { Parsing } >> Message-ID: >> < >> caj6c5wge_8qg+fkolvpccwaqrm2bgbjqcornf12vzlvzmky...@mail.gmail.com> >> Content-Type: text/plain; charset=UTF-8 >> >> Hi, >> >> Why do you want to write a parser for the Gherkin format ? If we can know >> the underlying need, then may be We can suggest you more effectively. >> >> Regards, >> Jagan >> >> On Tue, Feb 11, 2014 at 2:26 PM, Shashidhar Paragonda < >> shashidha...@gmail.com> wrote: >> >> > Hello Python hackers >> > >> > >>> I wanted to write parser for below GHERKIN format, can anyone >> suggest >> > best pythonic approach to parse and extract the details from below eg: >> > >> > >>> My need is to discard the common english words and extract rest of >> the >> > text and write entries to XML ( i thought of using XML, please suggest >> any >> > other format storage ). >> > >> > Feature: Password management Scenario: Forgot password Given a >> > user with email "cu...@cukes.info" exists When I ask for a password >> > reset Then an email with a password reset link should be sent >> > >> > >>> NOTE: Feature, Scenario, Given, When , Then are like keywords in >> above >> > text >> > >> > >> > ----------------------------------- >> > Regards, >> > >> > Shashidhar N.Paragonda >> > shashidha...@gmail.com >> > +919900093835 >> > _______________________________________________ >> > BangPypers mailing list >> > BangPypers@python.org >> > https://mail.python.org/mailman/listinfo/bangpypers >> > >> >> >> ------------------------------ >> >> Message: 3 >> Date: Tue, 11 Feb 2014 14:47:51 +0530 >> From: Shashidhar Paragonda <shashidha...@gmail.com> >> To: Bangalore Python Users Group - India <bangpypers@python.org> >> Subject: Re: [BangPypers] { Parsing } >> Message-ID: >> < >> cal2nvrx7wdzq6+max1wducf27z0zjzupodn7aa_8cprc-7v...@mail.gmail.com> >> Content-Type: text/plain; charset=ISO-8859-1 >> >> Hi >> >>> The main requirement is to build autamation script parsing the Gherkin >> format. >> >>> We planned to use Gherkin format to basically convert the test >> use-cases. >> >>> Everyone who does manual / automation test, will use Gherkin format to >> generate the test use-cases, so that Gherkin becomes a common format >> platform to build test cases. >> >> >> >> ----------------------------------- >> Regards, >> >> Shashidhar N.Paragonda >> shashidha...@gmail.com >> +919900093835 >> >> >> On Tue, Feb 11, 2014 at 1:29 PM, Vaikuntham Jagannath < >> vjagannat...@gmail.com> wrote: >> >> > Hi, >> > >> > Why do you want to write a parser for the Gherkin format ? If we can >> know >> > the underlying need, then may be We can suggest you more effectively. >> > >> > Regards, >> > Jagan >> > >> > On Tue, Feb 11, 2014 at 2:26 PM, Shashidhar Paragonda < >> > shashidha...@gmail.com> wrote: >> > >> > > Hello Python hackers >> > > >> > > >>> I wanted to write parser for below GHERKIN format, can anyone >> suggest >> > > best pythonic approach to parse and extract the details from below eg: >> > > >> > > >>> My need is to discard the common english words and extract rest >> of >> > the >> > > text and write entries to XML ( i thought of using XML, please suggest >> > any >> > > other format storage ). >> > > >> > > Feature: Password management Scenario: Forgot password Given a >> > > user with email "cu...@cukes.info" exists When I ask for a >> password >> > > reset Then an email with a password reset link should be sent >> > > >> > > >>> NOTE: Feature, Scenario, Given, When , Then are like keywords in >> > above >> > > text >> > > >> > > >> > > ----------------------------------- >> > > Regards, >> > > >> > > Shashidhar N.Paragonda >> > > shashidha...@gmail.com >> > > +919900093835 >> > > _______________________________________________ >> > > BangPypers mailing list >> > > BangPypers@python.org >> > > https://mail.python.org/mailman/listinfo/bangpypers >> > > >> > _______________________________________________ >> > BangPypers mailing list >> > BangPypers@python.org >> > https://mail.python.org/mailman/listinfo/bangpypers >> > >> >> >> ------------------------------ >> >> Subject: Digest Footer >> >> _______________________________________________ >> BangPypers mailing list >> BangPypers@python.org >> https://mail.python.org/mailman/listinfo/bangpypers >> >> >> ------------------------------ >> >> End of BangPypers Digest, Vol 78, Issue 2 >> ***************************************** >> > > > > -- > *sahil* chug > -- *sahil* chug _______________________________________________ BangPypers mailing list BangPypers@python.org https://mail.python.org/mailman/listinfo/bangpypers