monitoring

Hi all, I have been toying around with the shell notification apis in order to be able to monitor file activity in folders such as creating, deleting , renaming, copying, updating files & folders etc ... I thought I would post here what I have come up with in case someone finds it useful. The...

Hi All Good Morning I have been asked to analyse Quarter monitoring fromcompanies into power bi The monitoring forms are in excel format with for Q1, and the other tabs would have Q2, Q3, Q4 tabs. the monitoring formformat does not change for each quarter. The information is input into...

Hi guys, hoping for a bit of help here regarding formulas. I don't expect the full formula to be written out, but just some rough guidelines and to how you think I should go about sorting this issue. I am composing a spreadsheet which I am tracking the hours in which workers have worked. As a...

Good morning. I'm a new user to this forum but have been using it for a while now to learn and expand my skill set on different formulas. With that being said, I'm stumped on this one. Here's what I'm trying to do with the data below. If the Column D equals "Monitoring" then I want to count...

Hello Guys! 2nd time posting in the forum :) My first question was promptly answered by one of us so very much positive that someone could again help me with my problem. It's probably something basic but I don't have much knowledge about formulas so... I'd like to include the person's name on...

Hi! Let me apologize for the vague title but the one thing that i'm looking for I don't even know if it has a technical name -which limits my ability to google it-. I have a file with 22.000 rows and these are the headers for each column: SERIAL NUMBER LOCATION_MONITORING LEVEL EFFECTIVE...

Is there a way to connect a directory to a spreadsheet so that when a file is added to the directory, its information (file name, author, date modified, etc) is added to the spreadsheet. I am looking to keep track of what all comes into a certain folder. The following two programs are close to...

Good day, For our next project we would like to use a master excel file (monitoring dashboard) that brings together all the information stored in 4 individual excel files in a cloud. The 4 individual excel users should not see the master file (as they should not see each others work) but I...

Hi All, I've been struggling in how to come up with a decent formula in order to see the trending regarding weight loss/weight gain for our group over a duration of 12 weeks. I've used the if formula, but still unable to create a decent formula that would address our trending. we do weekly...