$$Excel-Macros$$ Client in Houston TX need Sr IT Project Manager - SAP Financials

2016-03-14 Thread MADHU-GenuineItLlc
Hi Partner,

Hope you are doing great …

Please send resume to ma...@genuineitllc.com



*Title : Sr IT Project Manager – SAP Financials *

*Location: Downtown Houston*



*Comm skills are really important for this group, PMP is required*



*JD:-*
Reporting to the IT Project Delivery team, this position will be
responsible for the leadership and management of multiple SAP project
implementations.  The first potential projects will include various SAP
Financial projects utilizing SAP FI/CO and 3rd party financial modules.



This position also ensures the successful transfer of knowledge from the
project team to the post-implementation support organization and all
employees affected by the implementation. The position works closely with
business, IT business analysts, and IT technical teams, serving as an
expert project manager resource.


This is a position of influence, negotiation and expectation management:

· Maintains complete autonomy for the management of the business
project to meet the needs of the business, as outlined in the business case
and articulated by the steering committee

· Coaches and mentors project team members

· Maintains and controls the project budget, schedule and resources

· Responsible for project planning, resource allocation, steering
committee leadership and team organizational structure management

· Manages project financials for resources and assets including
monthly accruals and forecasting

· Responsible for project communications

· Manages project scope, risk and issue resolution

· Responsible for quality of project deliverables

· Responsible for ensuring that the project can deliver the
benefits outlined in the business case and that it meets the reasonable
expectations of end users

· Must have senior communication skills with executive presence
skills and influence


* Primary Contacts*

· Line-of-business managers for business users affected by the
project

· IT Business Analysts

· IT line managers for all IT associates involved in the selection,
design, implementation, rollout and/or update of business applications

· IT Developers and Testers

· Business stakeholders

· Heads of governance bodies needed to make the necessary decisions

· Hardware, software and service vendors



*Job Requirements*

· Bachelor's degree in business administration, information
systems, or related field.  MBA a plus.

· *10 to 15 years of IT and industry related experience with large,
global organizations.  A minimum of 8 years in a project management role,
managing medium to large global teams.*

· Experience managing medium to large SAP projects is a plus.

· Experience working with SAP/Non-SAP integration

· *Experience working as a project manager in Manufacturing and/or
Chemical companies.*

· SAP Domain experience a plus, (FI/CO, BW, MDM, PM, HR, APO, SRM,
S&OP).

· Agile project management experience a plus

· Project Management certification; PMP certification from the
Project Management Institute preferred.

· Occasional travel to plant locations many be required

---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to t

$$Excel-Macros$$ Client in Hoston TX need Cisco Information Server (CIS) Consultant Only Locals please

2016-03-14 Thread MADHU-GenuineItLlc
Hi Partner,

Hope you are doing great …

Please send resume to ma...@genuineitllc.com



*TITLE : Cisco Information Server (CIS)*

*Local or within TX to come down for F2F*



Jd:-



This consultant has technical or functional skills in a particular area of
structured systems implementation efforts. The key characteristics of this
consultant are as follows:


*- Experience in BW support / development, SEM experience, Knowledge of
Star-Schema design, - has worked in at least one systems implementation
project, applying preferred practice business processes, - excellent
written and verbal English communication skills*



*CIS Consultant:*
•

*Min. 2 yrs. experience, solid understanding of Cisco Information Server
(CIS) / Composite • Extensive experience in data (Canonical) modeling • 3+
years’ experience with SQL; strong SQL development skills*
• Proven SQL performance tuning experience
• Development, testing, maintenance and support of enterprise logical data
models
• Provide technical guidance to developers who utilize CIS (Composite)
Software
• Performance tune CIS (Composite) views in order to provide the best
possible query results
• Contribute to developing standards, policies and procedures for
implementing enterprise logical data models within our CIS Data
Virtualization environment
• Ensure design consistency with development standards/guidelines
• Assign/maintain security of published views using our corporate data
access security model
• Investigate production issues within CIS / Composite env.





---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Client in Hoston TX need Cisco Information Server (CIS) Consultant Only Locals please

2016-03-14 Thread MADHU-GenuineItLlc
Hi Partner,

Hope you are doing great …

Please send resume to ma...@genuineitllc.com



*TITLE : Cisco Information Server (CIS)*

*Local or within TX to come down for F2F*



Jd:-



This consultant has technical or functional skills in a particular area of
structured systems implementation efforts. The key characteristics of this
consultant are as follows:


*- Experience in BW support / development, SEM experience, Knowledge of
Star-Schema design, - has worked in at least one systems implementation
project, applying preferred practice business processes, - excellent
written and verbal English communication skills*



*CIS Consultant:*
•

*Min. 2 yrs. experience, solid understanding of Cisco Information Server
(CIS) / Composite • Extensive experience in data (Canonical) modeling • 3+
years’ experience with SQL; strong SQL development skills*
• Proven SQL performance tuning experience
• Development, testing, maintenance and support of enterprise logical data
models
• Provide technical guidance to developers who utilize CIS (Composite)
Software
• Performance tune CIS (Composite) views in order to provide the best
possible query results
• Contribute to developing standards, policies and procedures for
implementing enterprise logical data models within our CIS Data
Virtualization environment
• Ensure design consistency with development standards/guidelines
• Assign/maintain security of published views using our corporate data
access security model
• Investigate production issues within CIS / Composite env.





---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Re: Need help Using Isblank and days360 in Macro

2016-03-14 Thread Pankaj Sharma
Hi Maju,,,i think if you provide some example sheet, you will get your 
answer very soon.


 



On Wednesday, March 9, 2016 at 8:23:53 PM UTC+5:30, Maju wrote:
>
> Hello all!
>
>  
>
> Please I need macro help with the below in red: 
>
> What is the best way to achieve this without using the formula that I got 
> from running the macro and also making the code short? I have already 
> completed the Sum in column AH
>
>  
>
>  
>
>1. 
>
>Column AI to the last row should have the below :
>
> =IF(ISBLANK(I2)," ",YEAR(I2+184)) this in VBA is 
>
> ActiveCell.FormulaR1C1 = "=IF(ISBLANK(RC[-29]),"" "",YEAR(RC[-29]+184))"
>
>
>  2 Column AJ to the last row should have the below
>
> =IF(ISBLANK(G2)," ",IF(ISBLANK(I2)," ",DAYS360(G2,I2)))  this in VBA is
>
> "=IF(ISBLANK(R[-1]C[-31]),"" "",IF(ISBLANK(R[-1]C[-29]),"" 
> "",DAYS360(R[-1]C[-31],R[-1]C[-29])))"
>
>  
>
> 3. Column AK to the last row should have the below
>
> =IF(ISBLANK(I2)," ",DAYS360(I2,TODAY()))this in VBA is
>
> "=IF(ISBLANK(R[-2]C[-29]),"" "",DAYS360(R[-2]C[-29],TODAY()))"
>
>  
>
>  
>
> This is summing the value in Ah
>
>   Dim CurCell As Object
>
>   'Summing severals rows and putting the value in column AH
>
>   For Each CurCell In Range("ah2:ah" & Cells(Rows.Count, 
> "B").End(xlUp).Row)
>
>   CurCell.Value = CurCell.Offset(0, -10).Value _
>
>   + CurCell.Offset(0, -9).Value + CurCell.Offset(0, 
> -8).Value + CurCell.Offset(0, -7).Value + CurCell.Offset(0, -6).Value
>
> CurCell.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* 
> ""-""??_);_(@_)"
>
> Next
>
>  
> Thanks
>
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Re: GOAL SEEK

2016-03-14 Thread Pankaj Sharma
Hi buddy,

Find the below link to understand Goal Seek basic... 

https://youtu.be/7QIBvMPC9vM




 
*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*   
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj 
*

  
*We meet for a reason, either you're a blessing or a lesson...*

On Thursday, March 10, 2016 at 8:13:14 PM UTC+5:30, GENIUS wrote:
>
> in the attachment I have a macro in which  GOAL SEEK has been specified.   
> can anyone explain it to me how the figures in column E calculated when we 
> press GOAL SEEK button
> in another word, I want to understand  how this macro has been written
>
>
>
>

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


$$Excel-Macros$$ Use xlsm as backend for html page

2016-03-14 Thread Kat
Hi guys,

I have a xlsm file in which it has file name, drawing folder name, revision 
and date updated. I was wondering whether could I use xlsm file as backend 
while using html page as front end. I would like to create a html page in 
which it has search, download and upload function where the data will be 
grabbed from the xlsm file. May I know how could I achieve this?

Thanks in advance.

-- 
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 @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.