About this site

I really like your “The Html Calculated Column” tips, and I wondered how to do something a bit more extreme.

I have a web page that contains a large table with 19 columns and a few dozen rows. It is filled with links and created via JavaScript. My problem is that if one of my colleagues needs to add a new row, they need to know how to get access to the host, and then either use CVS to track changes or risk stomping on each others changes.

What I want is to have a SharePoint list that contains the information needed to calculate the table, so that adding a new row is just adding a new item to the list. Then, I would want a view with a CEWP with the JavaScript to read the data from the list, and replace the view with the table.

More, since my table is a bunch of quick links to the hundreds of environment deployment pages we need to manage, it defeats the purpose of the table to have any page real estate wasted on normal SharePoint navigation. So, I want the JavaScript to “display=none” all of the SharePoint content on the page except for the top navigation line, and I want to move the view selector into the top line – so that users can still switch to the normal list view and add/edit rows.

Any suggestions? Feel free to say “you are nuts”

I am trying to add a JS tool tip to a customer webpart, so that when someone hovers over a document title or list title a description of the document appears. Have you got any idea how I could go about designing this?

Thanks.

Hi Christophe,

Is there any possibility or workarounds available to make certain columns read only in a Custom List?. I’am basically thinking about a solution to control colum editing for certain users/groups without using SPD. Can this be done through jQuery?—i dont know..:).

Your thoughts please..

Thanks & Regards,
Sam

Christophe, WoW, that is a great news. Truly appreciate if you can share some reference links or scripts with instructions which you always do to try the same..

Thank you so much Christophe. Let me search for more on the subject and share here for all our folks.

Cheerz,

Sam

Hello,

I am trying to figure out how to handle a calculation for a KPI that needs to display server uptime by month as a percentage.

Currently have Excel worksheet with one row for each day. One column is “total outage minutes”. This is manually entered from one or more server downtime events. Another column calculates the uptime percentage: if there was a 2 minute outage then it gives a result of 99.86% for that day (1438 minutes up out of 1440 minutes in a day). It also has a calculated cell that gives the total average for all days in the month. Also, if there were separate outages, someone manually adds the two and enters them into the cell for that day.

This system is being replaced with a sharepoint list, so there could be days with one or more events (rows) that contain outage information – submitted by individuals who may not know about other outages for that day. There will also be days with no outage information (no list items created).

Having a hard time understanding how to calculate the average monthly uptime, because my KPI average only runs against the data (rows) that exist in the list, it doesn’t account for the rest of the days during the month when no downtime events occur. In Excel, this was just a row where “0″ was manually entered for that date. The goal is to have this information fully automated, not using Excel, and, not have a person manually enter a row of data for each day that did not have an outage. (And the outage events are actually populated by workflows running off of forms that have the outage minutes tallied by separate departments.)

The averaging problem: if in a given month there are three downtime events (for simplicity, say they are 2 minutes each) , the KPI averages 99.86%: (99.86 * 3) /3 but over a 30 day period (where 27 days had 100% uptime) the average should be 99.986. The number must be accurate to the ten-thousandths decimal point. Also, not all months have 30 days, so how is that handled?

The best I have been able to come up with is to sum the _outage_ minutes for the month and set a KPI target of 22 minutes (there are 43200 minutes in a 30-day month, and the goal is 99.95% uptime. 99.95% of 43200 is 43178 minutes.) This solution doesn’t present the data required by the execs, and it doesn’t dynamically adjust for 28,29, or 31 day months.

We have basic-intermediate SharePoint Designer expertise. I was also wondering if this can be handled by Performance Point/Dashboard Designer, which I have heard will be released free with SharePoint SP3.

Any suggestions are greatly appreciated.