[BangPypers] BangPypers Digest, Vol 78, Issue 2
sahil chug
sahil2422 at gmail.com
Tue Feb 11 14:12:09 CET 2014
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 <sahil2422 at 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-request at python.org> wrote:
>
>> Send BangPypers mailing list submissions to
>> bangpypers at 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-request at python.org
>>
>> You can reach the person managing the list at
>> bangpypers-owner at 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 <shashidhar85 at gmail.com>
>> To: Bangalore Python Users Group - India <bangpypers at python.org>
>> Subject: [BangPypers] { Parsing }
>> Message-ID:
>> <CAL2NvRxytb0UDqEQXWCcU4hEf7BB8Ht=
>> TZmLVVKeud9RJX8wVw at 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 "cukes at 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
>> shashidhar85 at gmail.com
>> +919900093835
>>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Tue, 11 Feb 2014 15:59:53 +0800
>> From: Vaikuntham Jagannath <vjagannath09 at gmail.com>
>> To: Bangalore Python Users Group - India <bangpypers at python.org>
>> Subject: Re: [BangPypers] { Parsing }
>> Message-ID:
>> <
>> CAJ6C5wgE_8qG+FkoLvpCCwAqRm2bGbjQCORnf12vzLvZMkyQAw at 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 <
>> shashidhar85 at 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 "cukes at 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
>> > shashidhar85 at gmail.com
>> > +919900093835
>> > _______________________________________________
>> > BangPypers mailing list
>> > BangPypers at python.org
>> > https://mail.python.org/mailman/listinfo/bangpypers
>> >
>>
>>
>> ------------------------------
>>
>> Message: 3
>> Date: Tue, 11 Feb 2014 14:47:51 +0530
>> From: Shashidhar Paragonda <shashidhar85 at gmail.com>
>> To: Bangalore Python Users Group - India <bangpypers at python.org>
>> Subject: Re: [BangPypers] { Parsing }
>> Message-ID:
>> <
>> CAL2NvRx7wdzq6+MaX1WDUCf27Z0zJzUpOdN7AA_8cPRc-7v0-A at 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
>> shashidhar85 at gmail.com
>> +919900093835
>>
>>
>> On Tue, Feb 11, 2014 at 1:29 PM, Vaikuntham Jagannath <
>> vjagannath09 at 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 <
>> > shashidhar85 at 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 "cukes at 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
>> > > shashidhar85 at gmail.com
>> > > +919900093835
>> > > _______________________________________________
>> > > BangPypers mailing list
>> > > BangPypers at python.org
>> > > https://mail.python.org/mailman/listinfo/bangpypers
>> > >
>> > _______________________________________________
>> > BangPypers mailing list
>> > BangPypers at python.org
>> > https://mail.python.org/mailman/listinfo/bangpypers
>> >
>>
>>
>> ------------------------------
>>
>> Subject: Digest Footer
>>
>> _______________________________________________
>> BangPypers mailing list
>> BangPypers at python.org
>> https://mail.python.org/mailman/listinfo/bangpypers
>>
>>
>> ------------------------------
>>
>> End of BangPypers Digest, Vol 78, Issue 2
>> *****************************************
>>
>
>
>
> --
> *sahil* chug
>
--
*sahil* chug
More information about the BangPypers
mailing list