Re: $$Excel-Macros$$ Excel Qry.
PFA HTH On Thu, Aug 13, 2015 at 1:20 PM, sush.dav...@gmail.com wrote: Dear Champs Please Solve My Querry In Atteched File -- 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. For more options, visit https://groups.google.com/d/optout. -- 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. For more options, visit https://groups.google.com/d/optout. Qry.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Excel Qry.
Thanku On Thursday, August 13, 2015 at 1:39:52 PM UTC+5:30, Abhi wrote: PFA HTH On Thu, Aug 13, 2015 at 1:20 PM, sush@gmail.com javascript: wrote: Dear Champs Please Solve My Querry In Atteched File -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Excel Qry.
Dear Champs Please Solve My Querry In Atteched File -- 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. For more options, visit https://groups.google.com/d/optout. Qry.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Excel to Pdf
Hi, I have an query about exporting each sheet(multiple sheets but not all) of the excel workbook to Pdf and save this PDF by name provided in the list. This task should be automated, because there are 20 to 45 sheets in the report. Please help me sort out this time consuming task. thanks in advance. Thanks Regards, *Saravanan Raju* Mob: +91 8807708842 +91 9449716334 -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Converting Formulas to Values
If you have a range of formulas that always produce the same result (that is, dead formulas), you may want to convert them to values. You can use the Home➜Clipboard➜Paste➜Values command to do this. Suppose that range A1:A10 contains formulas that calculate a result that never changes. To convert these formulas to values: 1. Select A1:A10. 2. Choose Home➜Clipboard➜Copy (or press Ctrl+C). 3. Choose Home➜Clipboard➜Paste➜Values. 4. Press Enter or Esc to cancel paste mode. Hair Building Fiber http://www.hairbuildingfibers.co.in Shakti Prash http://www.shaktiprash.net -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent need MOBILE QA Analyst -Senior- Foster City, CA
Hi Partner, Please send resume to ma...@genuineitllc.com *Title: **Mobile QA Analyst - Senior * * Location: **Foster City, CA* * Duration: **1 year initially, then extensions to 2 years* Interview Process: Phone, then onsite Benefits: Medical, Dental, Vision, 401k The hiring manager is looking for experience in testing various mobile devices - *iPhones, Android, Windows.* ü *Must have skills:* Assoc degree or higher is a HARD REQUIREMENT (in computer science, computer engineering or relevant field) *7-10 years QA experience required .* ü Extensive experience in QA tools (ALM, Clear quest, JIRA, Rally) *Detail in resume . ü Extensive experience with web and mobile automations tools such as Selenium WebDriver, QTP, JavaScript, Appium, Cucumber, Robotium (1 or more is REQUIRED) *Detail in resume . ü Experience with testing HTML5 compliant Web, Mobile and JavaScript . ü Experience utilizing Android Studio Xcode IDE, DDMS, and Instrumentation . ü Experience in testing various mobile devices - *iPhones, Android, Windows.* Hands on experience in testing desktop web, native and hybrid mobile apps, web API's, database testing and test automation . ü Experience testing in a simulation environment . ü Understanding of MDM Provisioning *Nice to have skills:* Extensive Experience and understanding in leading QA process [Agile and Waterfall]. Experience with Java a plus Experience with database testing (SQL or Oracle are preferred) *Detail in resume Roles and *responsibilities* Independently handle total QA Process Work with a team located in both Foster City and Austin and overseas . *Projects : 80% Mobile Testing (60% IOS, 30% Android, 10% Windows) 20% Desktop. *Mobile Automation Testing (Visa moving towards this soon) . See JD for further details Description: *Mobile QA Analyst - Senior* A role critical to the implementation of QA standards throughout several projects within CIT Client Systems and Marketing. QA efforts will range from mobile projects, as well as IT tools. Work would be performed on specific projects while simultaneously supporting BAU effort. The ideal candidate would be in involved in the implementation of best practice techniques for test-driven development, value-based exploratory testing, risk identification, and production support. The resource would participate in early design discussions provide integrity to the App quality by identifying gaps, ensure critical analysis of documentation, and clarifying testing scenarios prior to development start. Providing innovative approaches to coordinate multi-region testing allowing more condensed testing schedules will be within daily activities. The position would be responsible to operate within fast-paced initiatives, in order to retain quick time to market. With the agile-like project lifecycle, the candidate would need to have a deep understanding to balance Agile QA process, and audit compliance of SDLC standards. Supporting UAT testing would require similar coordination of the same QA groups to ensure seamless testing by providing proper scheduling of data preparation and defect tracking. *Education/Experience:* Bachelor's degree in computer science, computer engineering or relevant field required 8-10 years' experience required Extensive Experience and understanding in leading QA process [Agile and Waterfall]. Hands on experience in testing desktop web, native and hybrid mobile apps, web API's, database testing and test automation Extensive experience in QA tools (ALM, Clear quest, JIRA, Rally) Experience with testing W#C/HTML5 compliant Web, Mobile and JavaScript Extensive experience with web and mobile *automations tools such as Selenium WebDriver, QTP,JavaScript, Appium, Cucumber, Robotium * Experience utilizing Android Studio Xcode IDE, DDMS, and Instrumentation Responsibility level Handle independently on the QA activities and test artifacts. Exercises independent judgment with minimal direction from supervisor *Skills:* Verbal and written communication skills, problem solving skills, customer service and interpersonal skills (Required) Strong ability to work independently and manage one's time (Required) Strong knowledge on web based applications in areas of marketing Experience in testing various mobile devices - iPhones, Android, Windows. Experience in device testing in simulation environment. *Major Job Duties and Responsibilities:* Prepare and review test plans, scenarios, scripts or procedures Develop test scripts, test conditions, input test data, and expected results for one or more test plans in a development cycle by analyzing the Functional Specifications and Business Requirements. This could include component, Database Configuration tests, computer telephony integration, user interfaces and regression tests. Manage all communications related to QA Status on a daily basis during execution. Reporting potential risks during all any stages of development
Re: $$Excel-Macros$$ Excel to Pdf
Are you familiar with macros?This is fairly straight forward with a simple macro.Especially if you're using Excel2007, 2010 or 2013.Earlier versions it's a bit more difficult. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: saravanan R sarva0...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, August 13, 2015 5:41 AM Subject: $$Excel-Macros$$ Excel to Pdf Hi, I have an query about exporting each sheet(multiple sheets but not all) of the excel workbook to Pdf and save this PDF by name provided in the list. This task should be automated, because there are 20 to 45 sheets in the report. Please help me sort out this time consuming task. thanks in advance. Thanks Regards,Saravanan RajuMob: +91 8807708842 +91 9449716334 -- 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. For more options, visit https://groups.google.com/d/optout. -- 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. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Macro from non specific cell
What you're asking for can be accomplished without a macro.In Cell A2, you'd have your starting date (or the date for the first record).Then in Cell A3, put: =IF(B3=,,IF(B3=0,A2+1,A2))and drag it down the column. Basically, this makes use of the fact that Excel stores dates as numbers.The number of days since 1/1/1900. So, to day (August 13, 2015) is 42229 That's why you can change the display format to show the date in any way you want.8/13/1513-Aug-2015Aug-20152015-08-132015Thursday So, basically adding (1) to any number is like adding 1 day to a dateAugust 12, 2015 (42228) + 1 = 42229 = August 13, 2015 The other thing is that Excel stores TIME as a fractional part of a day.6:00am is 6/24 of a day or .25 daysso, today at 6:00am is 42229.25 At this exact second:8/13/2015 at 1:55:47, Excel stores ad 42229.5804053241 So, in the function, If(B3=0,is testing to see if the time is midnight (0:00)If it is, then it adds 1 to the previous date.If not, then it copies the previous date. the nested IF statement portion:IF(B3=,, simply checks to see if the time value is blank.If it is, then it puts a blank in the date cell. Now, if you want a macro to REALLY automate the collection,then you can write a macro that loops through all of the .csvfiles in the folder, reads them and enters the data.(I'm assuming the filename has the date?) Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Ian Truslove truslo...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thursday, August 13, 2015 11:36 AM Subject: $$Excel-Macros$$ Macro from non specific cell Hi I have a monitor which records in 10 minute intervals the output from my rooftop solar panels. I transfer the daily data to an Excel 365 day ‘Master Sheet’. Unfortunately, the monitor supplies a CSV (read only file) which ONLY contains two columns with 10 minute intervals and kWh output. 13:00 1.44 13:10 1.896 13:20 1.926 13:30 2.148 13:40 2.106 13:50 2.106 I copy and paste the data into columns ‘B’ and ‘C’ and then add the relevant date into column ‘A’ 144 times. I would like to add a macro which takes the date in the LAST DATE CELL, (in the attached sheet A145) and increment it by one day. I would then like the macro to paste the same date into the next 144 cells. I’ve created a macro which does this, but it only works on the specific cell that was originally selected (A2) rather than carrying on from the new required cell (A146). I’m using Excel for Mac 2011. Any help or suggestions would be much appreciated. Best regards Ian-- 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. For more options, visit https://groups.google.com/d/optout. -- 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
$$Excel-Macros$$ Urgent need Ruby on Rails – full stack Developer ---Broomfield, CO
Hi All , Please send resume to ma...@genuineitllc.com *Title : Ruby on Rails – full stack Developer * *Location : Broomfield, CO* *Duration : 9 months* Job Description:- We are seeking a *Ruby on Rails developer with strong full stack expertise* and experience building complex public-facing web applications to enhance our Consumer Engagement Platform. We are looking for candidates who are knowledgeable of all layers of application development including system and database architecture, API development, and building JavaScript driven front-end interfaces. In this role, you will be expected to contribute to designing, coding, testing, debugging, documenting and supporting applications meeting design specifications and business requirements to deliver business value. To be successful in this position, you must be a self-starter and enjoy working with a highly collaborative team in a fast paced environment while managing multiple, concurrent tasks. Responsibilities • Develop high quality, test driven consumer web applications • Collaborate with the team on code design and decision-making • Develop and test for cross-browser and device compatibility • Work with the platform development team to effectively integrate the presentation tier with the services tier via RESTFul APIs • Troubleshoot production support issues post release deployment • Translate technically complex concepts in ways that can be understood by a diverse audience • Stay current on emerging technologies, trends and standards, browser capabilities, and accessibility issues • Influence senior leadership to adopt new ideas, products, and/or approaches • Mentor junior developers, providing assistance where needed • Handle smaller projects independently, including coordination with other teams and 3rd parties *Technical Skills and Experience * • 1+ years’ experience using Ember.js • 3+ years’ experience using Ruby on Rails to develop production web applications • Dynamic/interactive web UI development with heavy use of AJAX and HTML5, CSS3, JSON, XML • 3+ years strong Model/View/Controller implementation expertise • 6+ years of experience with the System Development Life Cycle • 6+ years of relational database (MySQL) experience • BA/BS degree in computer science or equivalent experience Assets • Healthcare industry experience • MongoDB / NoSQL experience • Strong software engineering skills including writing and consuming RESTful resources • Agile software development cycle experience • Experience working with version control systems; SVN or Git • Enterprise performance and scalability optimization expertise --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] 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 [image: cid:image004.png@01CDB5D0.74A7EE40] 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. [image: Description: stylepic_globe1]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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent need Ruby on Rails Developer --Broomfield, CO
Hi Partner, Please send resume to ma...@genuineitllc.com *Title : Ruby on Rails Developer * *Location :Broomfield, CO* *Duration :9 months* Top 5 *responsibilities* for this position: ü Feature development and defect resolution following acceptance criteria from user stories ü Write unit and functional tests for all new features and add tests where additional coverage is needed for existing features ü Contribute to the continuous improvement of our applications including regular incremental refactoring ü Collaborate with the team on code design and decision-making ü Stay current on emerging technologies, trends and standards, browser capabilities, accessibility issues ü Help provide team leadership Required Skills and Experience: o Strong Model/View/Controller implementation expertise o Proficient with Ruby on Rails (3+ years) o Strong software engineering skills including writing and consuming REST based API's o Experience with 1 or more testing frameworks (RSpec, Capybara, Cucumber, Jasmine) (2+ Years) o Experience with schema design and query optimization for relational databases (MySQL/PostgreSQL) (2+ years) o Experience working with version control systems; preferable Git o Proficient with jQuery, *Ember.js,* Angular.js, Backbone.js or similar (2+ years) o Strong communications skills Optional (but desirable) Skills and Experience: o Experience with agile development (SCRUM, Kanban, etc) o Experience building front-end applications consuming web API's o Experience with continuous integration tools (Jenkins, GitLab CI) and deployment to multiple server environments o Experience working NoSQL/Document/Graph databases (MongoDB, Hadoop similar) o *Healthcare industry experience* --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] 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 [image: cid:image004.png@01CDB5D0.74A7EE40] 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. [image: Description: stylepic_globe1]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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Urgent need in Broomfield, CO -Front-end Web Developer with Ember.js
Hi All , Please send resume to ma...@genuineitllc.com *Title :Front-end Web Developer * *Location : Broomfield, CO* *Duration :9 months* What We’re Looking For We are seeking a creative Front-end Web Developer who is proficient at conceptualizing interfaces, turning whiteboard sketches into working prototypes, and transforming meticulously designed mockups into smooth and stunning interfaces. To be successful in this position, you must be a self-starter and enjoy working with a highly collaborative team in a fast paced environment while managing multiple, concurrent tasks. Responsibilities · Develop mark-up that upholds web standards, accessibility, and usability while also being fast and lean · Stay current on the latest in front-end development practices and technology (HTML5, CSS3, responsive web design, etc.) · Collaborate with backend developers and UX designers to create best in class web applications · Build and manage tools to help us test design concepts and messaging · Strong communication skills · Strong attention to detail Skills and Experience · *Specific high expertise with **Ember.js * · 3+ years of experience with and exemplary knowledge of HTML/CSS/JS · 3+ years’ experience developing and troubleshooting cross-browser and device solutions · Practiced at progressive enhancement and/or graceful degradation · Comfortable with writing native JavaScript as well as using frameworks (Backbone, Angular, Ember) and libraries (jQuery) · Proficiency with Version control systems, especially Git. · *Healthcare industry experience* · Experience with front-end testing frameworks such as Selenium · Working within an agile development cycle · Developing mobile optimized sites · Graphic design skills · Proficient with Adobe Photoshop and Adobe Illustrator, or other graphics software --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] 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 [image: cid:image004.png@01CDB5D0.74A7EE40] 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. [image: Description: stylepic_globe1]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 http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Client in Jersey City, NJ need Security Administrator
Hi All , Please send resume to ma...@genuineitllc.com *Title : Security Administrator (2 reqs)* *Location : Jersey City, NJ* *Duration :6 months with likely extension to 12* *Job Details* Security Administrators must execute user access requests, maintain access controls for various resources, and foster data security awareness. They must stay current in security technology and assist in the development and installation of new security hardware and software and provide security-consulting services to their management. Management authorizes all lawful actions of the Security Administrators in the investigation and prevention of security violations and the protection of information. *Principal Duties Include:* 1. Responsible for security control for all the data systems and information security systems -Planning and implementation of information security controls -Provide daily security administration of all assigned systems -Review audit trails and access control violations, reporting such violations to the Monitoring Team and management when necessary. This function is limited to those systems not yet migrated to the Monitoring and Engineering Team -Assist users with problems, taking corrective action when necessary -Respond and take corrective action for Help Desk calls by reviewing and acting on entries in the Remedy System -Maintain security administration databases with up to date information, making entries as changes occur during the workday -Provide technical support for Americas Offices as requested -Provide technical support for new systems before, during and after implementation. -Review Security Controls making adjustments when necessary -Specialist in managing security administration of Head Office Systems and Trading Room applications -Assigned a specific role as a project management lead 2. Develop and update Security Procedures -Create and update security procedures in conjunction with the Security Administration Team Leader -Document security administration procedures -Ensure the complete documentation of each system -Review and maintain existing security procedures. -Ensure that audit procedures exist for critical systems 3. Provide support for Business Continuity efforts including test participation. *Act as an alternate BPO (Business Process Owner) for System Security Administration team in case System Security Administration team leader is not available during a disaster recovery situation.* 4. Maintain up to date knowledge of current industry trends in information security 5. Provide Support for internal and external auditors and examiners by preparing reports, gathering information and answering questions *Mandatory Skills* 1. Minimum two years of experience in security administration with specific knowledge of: -IBM Tivoli -Windows Active Directory -Network/Internet Security (desirable) -IBM AS/400, RACF (desirable) -Microsoft Windows NT Server and Windows 2000/2003, 2008 Server, and Windows 7 workstations -Lotus Notes versions 7.x and 8.x (desirable) -UNIX (desirable) -Sybase (desirable) -Oracle (desirable) -SQL (desirable) 2. Previous banking experience (desirable) 3. Excellent verbal and written communication skills 4. Knowledge of FFIEC standards for EDP 5. Ability to work independently 6. Strong interpersonal Skills 7. Ability to interact at all levels of management --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] 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 [image: cid:image004.png@01CDB5D0.74A7EE40] 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. [image: Description: stylepic_globe1]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. ---
$$Excel-Macros$$ Re: Urgent need MOBILE QA Analyst -Senior- Foster City, CA
When did this become a Help Wanted board? Madhu, these posts are not welcome and are in total violation of the rules. Please stop. On Wednesday, August 12, 2015 at 3:31:56 PM UTC-7, madhu nandi wrote: Hi Partner, Please send resume to ma...@genuineitllc.com javascript: *Title: * *Mobile QA Analyst - Senior Location: * *Foster City, CA Duration: **1 year initially, then extensions to 2 years* Interview Process: Phone, then onsite Benefits: Medical, Dental, Vision, 401k The hiring manager is looking for experience in testing various mobile devices - *iPhones, Android, Windows.* ü *Must have skills:* Assoc degree or higher is a HARD REQUIREMENT (in computer science, computer engineering or relevant field) *7-10 years QA experience required .* ü Extensive experience in QA tools (ALM, Clear quest, JIRA, Rally) *Detail in resume . ü Extensive experience with web and mobile automations tools such as Selenium WebDriver, QTP, JavaScript, Appium, Cucumber, Robotium (1 or more is REQUIRED) *Detail in resume . ü Experience with testing HTML5 compliant Web, Mobile and JavaScript . ü Experience utilizing Android Studio Xcode IDE, DDMS, and Instrumentation . ü Experience in testing various mobile devices - *iPhones, Android, Windows.* Hands on experience in testing desktop web, native and hybrid mobile apps, web API's, database testing and test automation . ü Experience testing in a simulation environment . ü Understanding of MDM Provisioning *Nice to have skills:* Extensive Experience and understanding in leading QA process [Agile and Waterfall]. Experience with Java a plus Experience with database testing (SQL or Oracle are preferred) *Detail in resume Roles and *responsibilities* Independently handle total QA Process Work with a team located in both Foster City and Austin and overseas . *Projects : 80% Mobile Testing (60% IOS, 30% Android, 10% Windows) 20% Desktop. *Mobile Automation Testing (Visa moving towards this soon) . See JD for further details Description: *Mobile QA Analyst - Senior* A role critical to the implementation of QA standards throughout several projects within CIT Client Systems and Marketing. QA efforts will range from mobile projects, as well as IT tools. Work would be performed on specific projects while simultaneously supporting BAU effort. The ideal candidate would be in involved in the implementation of best practice techniques for test-driven development, value-based exploratory testing, risk identification, and production support. The resource would participate in early design discussions provide integrity to the App quality by identifying gaps, ensure critical analysis of documentation, and clarifying testing scenarios prior to development start. Providing innovative approaches to coordinate multi-region testing allowing more condensed testing schedules will be within daily activities. The position would be responsible to operate within fast-paced initiatives, in order to retain quick time to market. With the agile-like project lifecycle, the candidate would need to have a deep understanding to balance Agile QA process, and audit compliance of SDLC standards. Supporting UAT testing would require similar coordination of the same QA groups to ensure seamless testing by providing proper scheduling of data preparation and defect tracking. *Education/Experience:* Bachelor's degree in computer science, computer engineering or relevant field required 8-10 years' experience required Extensive Experience and understanding in leading QA process [Agile and Waterfall]. Hands on experience in testing desktop web, native and hybrid mobile apps, web API's, database testing and test automation Extensive experience in QA tools (ALM, Clear quest, JIRA, Rally) Experience with testing W#C/HTML5 compliant Web, Mobile and JavaScript Extensive experience with web and mobile *automations tools such as Selenium WebDriver, QTP,JavaScript, Appium, Cucumber, Robotium * Experience utilizing Android Studio Xcode IDE, DDMS, and Instrumentation Responsibility level Handle independently on the QA activities and test artifacts. Exercises independent judgment with minimal direction from supervisor *Skills:* Verbal and written communication skills, problem solving skills, customer service and interpersonal skills (Required) Strong ability to work independently and manage one's time (Required) Strong knowledge on web based applications in areas of marketing Experience in testing various mobile devices - iPhones, Android, Windows. Experience in device testing in simulation environment. *Major Job Duties and Responsibilities:* Prepare and review test plans, scenarios, scripts or procedures Develop test scripts, test conditions, input test data, and expected results for one or
$$Excel-Macros$$ Client in Houston TX need Sr IT Project Manager - SAP
Client FEEDBACK IS BELOW in yellow *Program Manager with Delivery Background and Project Management* : Manufacruting Industry : Shell , Valero, petrochecmical or Oil Gas industry *Sr IT Project Manager – SAP---* *Houston TX* Reporting to the IT Project Delivery team, this position will be responsible for the leadership and management of multimillion dollar SAP project implementations. The first potential project will include leading and managing the rollout of Sales and Operations planning. The expectation is that this position will lead as well as manage all project activities via the utilization of a detail project plan and via the utilization of many years of experience with similar engagements. 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 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 · 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 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 Salesforce.com projects, or experience with the Salesforce.com application. · Experience working with SAP/Non-SAP integration. · Agile project management experience. · Project Management certification; PMP certification from the Project Management Institute preferred. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] 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 [image: cid:image004.png@01CDB5D0.74A7EE40] 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. [image: Description: stylepic_globe1]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
$$Excel-Macros$$ Re: I need macro to send bulk mail with 5 Attachment through outlook
Hi Veer there is already a post in this group which will solve your query... please search On Friday, August 14, 2015 at 8:47:38 AM UTC+5:30, Veer Dhadra wrote: Dear friends, If someone created such kind of mail sending macro please send to me. Regards//Harish Kumar -- 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. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: I need macro to send bulk mail with 5 Attachment through outlook
I am unable to find it please help On 14-Aug-2015 10:33 AM, Nasir Saikh nasirsa...@gmail.com wrote: Hi Veer there is already a post in this group which will solve your query... please search On Friday, August 14, 2015 at 8:47:38 AM UTC+5:30, Veer Dhadra wrote: Dear friends, If someone created such kind of mail sending macro please send to me. Regards//Harish Kumar -- 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. For more options, visit https://groups.google.com/d/optout. -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ I need macro to send bulk mail with 5 Attachment through outlook
Dear friends, If someone created such kind of mail sending macro please send to me. Regards//Harish Kumar -- 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. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Client in Houston TX need Oracle Applications Developer - / PL-SQL Developer---Only GC/ US Citizens
Hi Partner, Please send me resume to ma...@genuineitllc.com *Title : Oracle Applications Developer - / PL-SQL Developer * *Location :Downtown Houston* *Duration :6+ month contract with extension* *Oracle Applications Developer - / PL-SQL Developer * The Senior Oracle Applications Developer is responsible for working on assigned projects and technical initiatives in an efficient/effective manner. The Senior Oracle Applications Developer must possess a high degree of technical knowledge regarding software development and associated technology tools primarily using Oracle PL/SQL. The individual is expected to be able to code as necessary, perform detailed analysis on data structures, data integration, and existing and new applications systems. Essential Functions/Principal Accountabilities: - Provide application development, enhancements, modifications, performance tuning, and support services for assigned projects. - Work with IS technical resources to provide high availability monitoring and maintenance for assigned applications. - Understand a given software project end-to-end specifically beginning with Business Requirements, then the appropriate Data Architecture and corresponding User Interface (UI), and culminating with finished information products such as Web Viewers, Reports, Data Entry Applications, Interfaces to Other Systems, Graphical Outputs or Data Marts. - Prepare specifications for new applications, enhancements, modifications, and support issues. Also, prepare application documentation as required. - Develop and support data models and a data dictionary that supports the business requirements for tactical and strategic information products. Job Requirements: - 5-10 years’ experience in Oracle backend database development utilizing packages, procedures, function, triggers and Oracle user defined types. - 2+ years of experience in data warehousing. - Strong Data Warehousing experience, Oracle partitioning, Collection objects - Strong Oracle PL/SQL skills (strong knowledge of Oracle 9i/10g/11g) - Strong Oracle Performance tuning skills (SQL tuning) - Strong knowledge of common Oracle tools (PL/SQL Developer, TOAD, SQLPlus) - *Familiarity with Oracle RAC preferred. * - *Familiarity with VPD (Virtual Private Database) is a big plus. * - Should have data analysis skills to debug, trace and fix problems. - Bachelor’s degree required. Degree in Management Information Systems or Computer Science preferred. - *Oil and Gas Industry experience preferred. * - Provide maintenance and support of the Oracle backend - Ability to build ER Diagrams for new tables. - Proficient in working with : Collection objects, Nested Tables, Record types, Cursors, Ref Cursors, Views, Materialized Views, Partitions, FORALL, Bulk Collect, Regular Expressions, Triggers, Instead Of Triggers, Autonomous Transactions. - Design or background with one or more data extraction transformation processes (ETL). - Ability to write complex stored procedures/triggers, functions using PL/SQL to optimize processes performance with the goal to reduce processing time - Tune complex queries utilizing Indexes, Hints, and Explain Plan, to improve the performance of the application. - Involved in writing technical specs, unit test results, and user acceptance test scenarios for each project. - Directly interact with business users during UAT to provide support and solicit feedback for the purpose of improving the quality of the finished application. - Required to be on-call during work and off-hours as necessary. - May travel when necessary for system implementation and training --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] 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 [image: cid:image004.png@01CDB5D0.74A7EE40] 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. [image: Description: stylepic_globe1]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
$$Excel-Macros$$ Macro from non specific cell
Hi I have a monitor which records in 10 minute intervals the output from my rooftop solar panels. I transfer the daily data to an Excel 365 day ‘Master Sheet’. Unfortunately, the monitor supplies a CSV (read only file) which ONLY contains two columns with 10 minute intervals and kWh output. 13:00 1.44 13:10 1.896 13:20 1.926 13:30 2.148 13:40 2.106 13:50 2.106 I copy and paste the data into columns ‘B’ and ‘C’ and then add the relevant date into column ‘A’ 144 times. I would like to add a macro which takes the date in the LAST DATE CELL, (in the attached sheet A145) and increment it by one day. I would then like the macro to paste the same date into the next 144 cells. I’ve created a macro which does this, but it only works on the specific cell that was originally selected (A2) rather than carrying on from the new required cell (A146). I’m using Excel for Mac 2011. Any help or suggestions would be much appreciated. Best regards Ian -- 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. For more options, visit https://groups.google.com/d/optout. 24 Hour Data Entry. Needs a Macroxlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Macro from non specified cell
Hi -- 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) Dont post a question in the thread of another member. 3) Dont 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 : Dont 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. For more options, visit https://groups.google.com/d/optout. 24 Hour Data Entry. Needs a Macroxlsx Description: MS-Excel 2007 spreadsheet I have a monitor which records in 10 minute intervals the output from my rooftop solar panels.I transfer the daily data to a 365 day ‘Master Sheet’. Unfortunately, the monitor supplies a CSV (read only file) which ONLY contains two columns with 10 minute intervals and kWh output. 13:00 1.44 13:10 1.896 13:20 1.926 13:30 2.148 13:40 2.106 13:50 2.106 I copy and paste the data into columns ‘B’ and ‘C’ and then add the relevant date into column ‘A’ 144 times.I would like to add a macro which takes the date in the LAST DATE CELL, (in the attached sheet A145) and increment it by one day. I would then like the macro to paste the same date into the next 144 cells.I’ve created a macro which does this, but it only works on the specific cell that was originally selected (A2) rather than carrying on from the new required cell (A146).I’m using Excel for Mac 2011.Any help or suggestions would be much appreciated. Best regards Ian -- 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) Dont post a question in the thread of another member. 3) Dont 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 : Dont 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. For more options, visit https://groups.google.com/d/optout.