Skip Weekends when filling dates in Excel

While using date function in Excel we come across dragging a cell to fill the cells with dates. As per standard for formula it drags and fills the cell with all dates. Most of the times, we do not need weekends in those cells. So how to remove those weekends?

It is very simple. Select a cell which has date and drag it. While dragging, you get an icon with row an columns. Click on the icon. It gives you options to fill the cell with. In the list shown, select Weekdays. This will fill the cells with only weekdays and skip weekends.

-Ashish

SharePoint Workflows

I am trying to understand how workflows work in SharePoint. I want some functionality like routes in ENOVIA. I want selective email alerts.
Currently SharePoint either floods my inbox or no emails. My requirement is that the list item creator should get alert about changes in list item and workflow members should get alerts when they get tasks.

– Ashish

Posted from WordPress for Windows Phone

Political Views, Social Media and Me

These days it is becoming highly sensitive to express over internet. Its getting tracked. In a way it is really good. You cannot hide your entity on internet. But at the same time, I think this tracking is getting misused. Anyway, I am not a political leader to create a storm by expressing my views on social media like Twitter or Facebook.
Other side of this is, We all are spending a lot of time on internet using smart devices just to watch what others are doing. We are really wasting some valuable time which can be creatively used to do so many important things.

I hope things will change and all these ways to change society will be used in right way and at right time.

Point of No Return…

It has been my experience that many PLM buyers come to a conclusion that investing in PLM is point of no return. ROI on PLM investment is a favourite topic of a debate and everyone agreed that it is hard to measure PLM project success.
In my opinion PLM Project investment decisions are taken by IT department and they head these Projects. But we should make a note that PLM covers whole organization. Hence owenership of such project should belong to a group of business users and owners rather than making. IT department a victim for a feeling of coming to a point of no return and somehow complete the project. IT should be a support team to deploy the solution. Business user groups should be main point of contact while defining and validating solution. IT should be involved for infrastructure needs and scalability.
Most important role I see in success of PLM Projects is a Project Manager who understands PLM as a tool and client business environment. He/she can definitely take the project to success rather than making this investment. Only as apoint of no return.

Posted from WordPress for Windows Phone

PLM User Accounts

PLM is enterprise tool and eventually a major part of employees will have a task to do in PLM Tool. Normally PLM Tools provide User account management modules where organizations broadly call it as People and Organization.

User Roles and Responsibilities are well defined in most of the organization and PLM implementation starts with configuring Access for users. But my experience with PLM Implementation project is something confusing.

PLM Tools are deployed as a independent tool. Then administrators start creating user accounts and then roles and then assigning them to on demand basis in some cases organization go for single sign-on or LDAP integration which is another project in itself.

Though this feature has complexities involved, should PLM Vendors not provide a handy way to integrate organization users with ease of operation? Following are thoughts on the way it should be.

  1. After installing PLM Tool in production environment, PLM Tools should have a wizard to integrate available network users directly into PLM Tool.
  2. It should just have a list of users available in Organization which can be seen from PLM Tool.
  3. PLM Tools should provide creation account button/command against each user, which should take administrator to user creation and configuration wizard.
  4. This wizard should be configuration so that it can fetch data related regarding his reporting and department structure so that account approval processes can be integrated within PLM itself.
  5. Like we get task for approvals in PLM, it should be another task to approve user account and assign role by his manager.

If PLM Tools have this type of feature they will provide following benefits.

  1. Adding a user friendly feature to PLM for user accounts.
  2. Complete tracking of user accounts.
  3. Automation of workflows with available information within other tools in organization.
  4. Quality time to invest on other PLM admin activities.
  5. Managers being informed and aware of subordinate’s access and roles.
  6. Reduction in gap of understanding of a functional user of tool and administrator of a tool.

I hope that I see such future in coming days.

thanks and regards
Ashish Kulkarni