$$Excel-Macros$$ Re: Need Help in calculation of score

[SG]

Hi Mandeep,

Sorry for the confusion. 
Final score is 100 if all are Yes.
I need the formula in Colum "I" for Score.(Distribution of Score in case of 
"NA" should be calculated here.)
Data in K:P are the values for "Yes" & "No" of data in B:H.

PFA updated sheet. The difference in headers are typo errors.

Regards,
SG

On Thursday, January 7, 2016 at 1:11:40 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hi SG,
>
> Things I would like to know !!! 
> 1) What is required You need formula in column "I" or You need to 
> distribute data in "K3:P5" 
> 2) Why headers(%) B:H and k:P are different? are they being used in 
> formulas for calculation.
> 3)   What is final Score ?
>
> Can we have the result set below your question with result required 
> manually for better understanding. 
>  
> Regards,
> Mandeep baluja 
>
>
>
>
>
>

-- 
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.


Book1.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Need Help in calculation of score

[Mandeep Baluja]

>
>  Hey check this out !! 
>>
>
Regards, 
Mandeep baluja 
 

-- 
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.


SG (2).xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Need Help in calculation of score

[SG]

Hi Mandeep,

Please refer to the comment in attached sheet.
I hope it would get clear now. :)


On Thursday, January 7, 2016 at 2:06:11 PM UTC+5:30, Mandeep Baluja wrote:
>
> Hey SG,
>
> Correct me if I am wrong !! 
> 1)If Parameter M(Fatal) is No, then total score would be 0 Formula should 
> be =IF(H3="No",0
>
> 2)If any parameter is "No", then its score should get deducted from final 
> score formula should be IF(COUNTIF($B$3:$H$3,"No")>0,100-SUM(K3:P3)
>   Now on combining these two formulas 
> is =IF(H3="No",0,IF(COUNTIF($B$3:$H$3,"No")>0,100-SUM(K3:P3)
>
> Confusion !! 
> 3) if any of parameter is NA then its score must be distributed in rest 
> of the parameters.(Not to M(Fatal) parameter)
> *Score must be distributed in rest of parameters ??? Does it mean 
> formula should do distribution on which cells ? because k3:p5 is already 
> filled with your formula.Can you put the output manually below your data.*
>
> *Regards,*
> *Mandeep baluja *
>
>
>

-- 
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.


Book1 - Copy.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Need Help in calculation of score

[Mandeep Baluja]

Hey SG,

It's very difficult to understand your query what you wish or what you want 
to achieve as may be we both are using different terminology or might be 
explanation. Sorry to say Hope someone will help you with these given below 
instructions as I am not able to matchup the aim.
 
You Wrote:-
1) What i need is to calculate the final score in column "I"
2) however, i'm, not able to do distribution of score. "Here the 
distribution is given in range("K3:P5")"
3) if any of parameter is NA then its score must be distributed in rest of 
the parameters.(Not to M(Fatal) parameter) 
4) Sorry for the confusion. Final score is 100 if all are Yes.
5) I need the formula in Colum "I" for Score.(Distribution of Score in case 
of "NA" should be calculated here.)
6) The difference in headers are typo errors.
7) d4 & e4 are no..that means their score 30& 10 = 40 gets divided by 4. so 
the score in k4  is 20,l4=30,m4=0,n4=0,o4 =25 & p4=25,*so that final score 
in i4 is 100. if any parameter goes "No"*, then its number get deducted 
from total score.
8) Also, in k11, why the score is 20. It should be 10 only according to the 
header & same for rest of the cells.


Regards,
Mandeep baluja 





-- 
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$$ vba code help for the open file location

[Kat]

 Hi all, 

I was wondering how could I make the open folder button for file name 
column instead of file location path column? For instance, from the picture 
below, when I point my cursor to 
C:\Users\maggie\Desktop\coke\diet\apr\2F6KB026 and click open file button, 
it will open the file 2F6KB026. At the moment, I would like to open the 
file 2F6KB026 by pointing my cursor to 2F6KB026. Please see attached for 
the vba code.

Thanks in advanced.


Cheers

-- 
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.


update button code.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Assigning a folder to merge the files in that folder

[Devendra Sahay]

Hi Experts,

Currently I am using below code to merge a set of excel files in one file,
but I have to change the path in code, each time for run this code. So if
we can assign a path at the time of running this code, would be helpful. So
please assist.
I have highlighted the code, where am assigning the path to get the .xls
files in that folder & merge them.,

Note- This code create a merged file in the same workbook.

Code--

Sub Merge_Files()
Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Dim i As Long
Dim col_no As Long, row_no As Long
Dim arr_ws As Variant
Dim ws1 As Worksheet, wb1 As Workbook
Dim col_ws1 As Long, row_ws1 As Long

Set wb1 = ThisWorkbook
Set ws1 = ActiveSheet

'Create an instance of the FileSystemObject
Set objFSO = CreateObject("Scripting.FileSystemObject")
'Get the folder object
Set objFolder = objFSO.GetFolder("C:\Users\Desktop\(Tech-Specs 3.4)\BULK
Excel")
i = 0
'loops through each file in the directory and prints their names and path
For Each objFile In objFolder.Files
i = i + 1
Workbooks.Open FileName:=objFile
row_no = ActiveSheet.Range(Cells(Rows.Count, 1), Cells(Rows.Count,
1)).End(xlUp).Row
col_no = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1,
Columns.Count)).End(xlToLeft).Column
arr_ws = ActiveSheet.Range(Cells(1, 1), Cells(row_no, col_no))
ActiveWorkbook.Close savechanges = no
ws1.Activate
If ws1.Range("A1").Value <> "" Then
row_ws1 = ActiveSheet.Range(Cells(Rows.Count, 1),
Cells(Rows.Count, 1)).End(xlUp).Row + 1
col_ws1 = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1,
Columns.Count)).End(xlToLeft).Column
Else
row_ws1 = 1
col_ws1 = 1
End If
ws1.Range(Cells(row_ws1, 1), Cells(row_ws1 + row_no - 1, col_no)) =
arr_ws

Next objFile
End Sub



-- 

With Regard !!!
Devendra Rahi

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 http://groups.google.com/group/excel-macros.

-- 
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 Houston TX need 3 PHP Consultants

[MADHU-GenuineItLlc]

Hi Partner,

Hope you are doing great …

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



*Title : PHP Consultants*

*Duration: 1 year *

*Location: in Houston, TX*



JD:-

Assists in the evaluation of client area application systems/programming
requirements and processes (e.g., new, enhancements or maintenance)



*PHP4/5*

*OOP/OOD concepts*

*HTML5/CSS*

*Use of PHP Frameworks (Symfony, CakePHP, Codeignitier, etc)*

Experience using MySQL/MySQL command line

Knowledge of API development including use of multiple different protocols
(JSON/WSDL)

Strong understanding of Linux and LAMP

Hands-on use of technologies, ranging from front-end user interfaces
through back-end systems

Understanding of MVC (Model/View/Controller) development approach

Experience using version control Git/SVN



---

*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: vba code help for the open file location

[Mandeep Baluja]

Check this out !! 

REgards, 
Mandeep baluja 

-- 
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.


update button code.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: vba code help for the open file location

[Kat]

Hi Baluja, 

It works well. Thanks a lot for your help. Appreciate that.


Cheers

On Friday, 8 January 2016 13:24:17 UTC+8, Mandeep Baluja wrote:
>
> Check this out !! 
>
> REgards, 
> Mandeep baluja 
>

-- 
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.

Re: $$Excel-Macros$$ Assigning a folder to merge the files in that folder

[Devendra Sahay]

Hey Mandeep,

Its working properly. Thanks ☺☺

On Thu, Jan 7, 2016 at 10:47 PM, Mandeep Baluja 
wrote:

> Check this code now !!
>
> Regards,
> Mandeep baluja
>
> Sub Merge_Files()
> Dim objFSO As Object
> Dim objFolder As Object
> Dim objFile As Object
> Dim i As Long
> Dim col_no As Long, row_no As Long
> Dim arr_ws As Variant
> Dim ws1 As Worksheet, wb1 As Workbook
> Dim col_ws1 As Long, row_ws1 As Long
>
> Set wb1 = ThisWorkbook
> Set ws1 = ActiveSheet
>
> Set d = Application.FileDialog(msoFileDialogFolderPicker)
> d.Show
>  fldpath = d.SelectedItems(1) & "\"
>
> 'Create an instance of the FileSystemObject
> Set objFSO = CreateObject("Scripting.FileSystemObject")
> 'Get the folder object
> Set objFolder = objFSO.GetFolder(fldpath)
> i = 0
> 'loops through each file in the directory and prints their names and path
> For Each objFile In objFolder.Files
> Debug.Print objFile
> i = i + 1
> Workbooks.Open Filename:=objFile
> row_no = ActiveSheet.Range(Cells(Rows.Count, 1), Cells(Rows.Count,
> 1)).End(xlUp).Row
> col_no = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1,
> Columns.Count)).End(xlToLeft).Column
> arr_ws = ActiveSheet.Range(Cells(1, 1), Cells(row_no, col_no))
> ActiveWorkbook.Close savechanges = no
> ws1.Activate
> If ws1.Range("A1").Value <> "" Then
> row_ws1 = ActiveSheet.Range(Cells(Rows.Count, 1),
> Cells(Rows.Count, 1)).End(xlUp).Row + 1
> col_ws1 = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1,
> Columns.Count)).End(xlToLeft).Column
> Else
> row_ws1 = 1
> col_ws1 = 1
> End If
> ws1.Range(Cells(row_ws1, 1), Cells(row_ws1 + row_no - 1, col_no)) =
> arr_ws
>
> Next objFile
> End Sub
>
> --
> 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.
>



-- 

With Regard !!!
Devendra Rahi

-- 
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 Basking Ridge, NJ need Technical Business Analyst/ PM

[MADHU-GenuineItLlc]

Hi Partner,

Hope you are doing great …

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



Person would be coming in to PM with SOE Web Portal that client is
developing. Looking for someone who can come in and answer all questions
about the website. Need someone who is web savvy and customer focused.
Development background helpful. Enterprise experience also helpful.



*Interview Process is Phone Screen then in person (2 rounds). *



*Location:* *Basking Ridge, NJ *

*Duration: 12 months+*



*Duties and Responsibilities*

Join the asset and vendor management team within Corporate Technology and
help us implement new and innovative ways to manage our software and
hardware assets more efficiently.  In addition, be on the forefront of
defining technology standards and introducing cutting edge technologies
into our compute environment.

Candidate will be responsible for differing functions across the Enterprise
Asset Management, Standards, and Cloud team.  Responsibilities may include
detailed analysis on technology in use across the enterprise, research and
analysis of emerging technology and industry trends, and the preparation of
internal communications and presentations to promote our organization’s
platforms and goals.

Candidate will also work closely with various groups across the enterprise
to promote the use of asset management and standards tools and help resolve
issues impeding the use of these tools.



*Qualifications*

 Excellent written and oral communication skills.  Presentation skills are
also critical.

   - Strong organizational and project management skills
   - Ability to work within a high pressure, often changing environment,
   and be able to adjust priorities as needed
   - Ability to create alliances and resolve conflict with other groups in
   order to be successful
   - Comfortable with executive updates and presentations
   - Excellent mix of technical and business acumen
   - Strong technical foundation and experience with a wide array of
   technologies
   - Position is located in Basking Ridge, NJ
   - Experience with Scrum needed





---

*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.