service

Hi all, I'm having a bit of a brain explosion over this so should I would register for some help. I have a spreadsheet which has 3 columns. Column A contains a list of computer names, Column B contains a list of services, column C contains the status of the service. What I want is to count...

Dear All I have two sheets with some information on skill level of a team and with year of experience. Machine_A sheet is summary of no. of skilled person. Machine_D is sheet of data base. Let us assume i have 10 expert engineer in machine installation category. Machine_A sheet shows no. 10...

I want to preface this by saying that I am VERY much a novice Excel user (using Excel 2016). I am trying to create a client tracking list and one of the columns I have is "Date(s) of service". Every client will have a different number of services dates, which I would like to keep in the same...

Hi everyone- I’m looking to develop a formula that used a two-factor formula to find results that will be listed out in one cell. Here is a snapshot of a file I have created: https://imgur.com/a/4Kc4tZN Along the top are a list of services. Along the left are a list of features...

Hi team, I'm finding what I want to do hard to articulate, however I have 10 Columns with titles of Projects, I then have 5 Rows with Services. Each service has a Dollar amount Per Service eg $220, $118 etc. I want to enter in each Column a service used each month, and rather than show the...

I am trying to look up a column based off a town and a service for example I want to lookup Victoria, C Basic, Start so the answer would be 19, or Munjor, D EAGLE DIGITAL, Reconnect so the result, any Ideas <colgroup><col><col><col><col span="10"><col><col><col><col><col...

So here I have a table which shows which months have 4 of a specific week day and which have 5. I am doing this because for my work I work with people who get X amount of hours of service per month. So for example if someone gets 12 hours of service per month and gets it for 3 hours every...

Hi all, I work at a school and got a (probably educational) powerbi pro license. I want to experiment with powerbi dataflows but cannot see the functionality in the powerbi online service. Anyone knows why? Kind regards, MrJoosten

Dear All, I have one trouble here. i have the following sample table with employees and thier hired dates. i want to calculate thier service years until december 31 2018 only. i want a general formula to calculate thier duration date. i tried deducting but kept getting negative months. i used...

Hi All, First post here, everyday i have someone go around and record the hours on a machine kms or machine hours worked (SMU) i need to build a service register. for example i have a lighting plant that needs a service every 250hrs and every 1000hrs a more indepth service, i currently have...

I have a Years of Service column calculating correctly, I also have another column that will populate each row with "10 YRS" "15 YRS" "20 YRS" and "25 YRS" if applicable by comparing 10years 0 months etc. A user wants the column to populate for the entire 12 months of the milestone anniversary...

I have a spreadsheet with a table in it. At the bottom of the table is a field where the GST is calculated for entries in the table. The GST is 10% of the value. I had the following code in it that calculated the GST correctly: =ROUNDDOWN(SUM(npss_quote[Price ex. GST])*0.1,2) There are...

Hello, Our staff receive a recognition for every five years of service. I have been asked to add some columns to a spreadsheet that will show (1) the next year when the person will receive a 5-year recognition and (2) when that year does occur what interval that will be (i.e. a person hired...

Hi All, My brain has gone completely blank. I've got a table of data which id like to extract certain results according to date. So for example multiple people used the service within January, from this id like to work out the number of adults, if they were registered, total cost, what service...

Good evening Everyone!! I am confident that someone in this forum will be able to assist me with my dilemma. I am the payroll processor at a Golf Club management Company where we host several event functions in different venues on property. There will be times that we have 2 or 3 functions...

Hello, First off I would like to say I am very new to macros and VBA in excel. I am trying to create a database that will log and track when our equipment is taken out of service and back in service. I would like for when my techs take a forklift out of service they click on the lift number...

Do you know of a way to forecast a monthly service level if you have the monthly volume (all up), AHT and actual FTE that will be staffed?

Hello all, I am a newbie with VBA and new to this forum, so please excuse any poor terminology. I have created a form that I fill in when working with customers and I have created a VBA which copies the filled in data to another sheet. The problem I am facing is that my code for pasting into...

hello everyone, tried doing with dax and regular excel methods but scratching my head here is a table example. the "style" number is repeated because there are multiple vendors that source the product. i simply want to concatenate each of the vendor names together separated by a comma. how...

i am using year of service formula as below but if the date is blank it is catching 119 instead of zero i want to do zero service =DATEDIF(A2,TODAY(),"y")&" Years "&DATEDIF(A2,TODAY(),"ym")&" Months "&DATEDIF(A2,TODAY(),"md")&" Days" <colgroup><col><col span="2"></colgroup><tbody> 21-Jun-97...