visits

Hello all. I'm a basic Excel user trying to create a spreadsheet for a friend - also a basic Excel user - who owns a dog grooming business. It will be your standard client list, with a few special columns like: Special Needs (like muzzle - will bite, or soothing oatmeal shampoo for skin...

Hello, I have a problem that I cannot solve... I have a dataset that includes an "Arrival Time", an "Exit Time", and a calculated "Hours in Department". I am trying to calculate to number of visits that are currently in the department at each hour of the day. Example: I have 3 visits that...

I have data that shows visits of customers Their name, the date they visited and how much they spent. I need to create a visual of this information to show if customers vary from there usual pattern of visits per week. If they always attend on the same day and if their spend increases. Please help

I am working with a large data set. The values are included in two different columns. A lot of the values have very little value to the overall report impact. What I want to do is identify the top 10 items by percentages that have a number greater than 50 in my top 10 table separate from the...

Hi, I have a large dataset detailing attendance over time at a leisure centre. At the moment, my data is organised as the calendar week in the top row, with each member’s number of visits in the rows below. Now I would like to restructure my data and organise it as visits in the first month...

Hi, I have customer numbers in column A with the number of visits in column B. There are duplicates in the customer number column (one record per visit), I calculated column B to count the number of visits for each customer so I will have the calculated number of visits also duplicated for...

I have 3 columns (A:C) - header names are PatientID, Reason, Paid Reason is the reason for the visit, Paid shows if the visit has been paid for. So the data looks like this: 192837 Reason1 Y 459357 Reason2 Y 459379 Reason2 Y 192837 Reason1 Y 459357 Reason2 Y 342873 Reason3 N 345035 Reason2 N...

<tbody> A B C D E F Name Store # Number of Visits Name Count of Visits Joe 1542 3 Joe 3 Joe 1872 4 Brad 2 Joe 1932 3 Sarah 3 Brad 5323 2 Brad 2142 3 Sarah 6745 0 Sarah 0896 2 Sarah 3242 3 Sarah 5735...

Hi, I am new to Access, so bare with me. I have 2 tables, both with date fields. One tables records visits to a website, by date, and the other records sign-ups by date. I have created a cross-tab query to count the visits by month and a second cross-tab query to count sign-ups by month...

Hi, I am new to Access and trying to learn as I go along...so forgive me if the below is basic. I have a table that tracks visits to a website on a daily basis. The information is (currently) added in manually but I am looking to create a query that has a header for each month with a sum of...

<style type="text/css"> Page { margin: 2cm } p { margin-bottom: 0.25cm; line-height: 115% } </style>I have 2 columns ofdata, the First is a list of Times in HH:MM:SS format and the SecondWeb sites visited, I need a formula that reads the time columnminutes and counts the number of web sites...

I work in a medical office and am trying to track patient visits. I have One worksheet (SheetA) that has all the patient Names and demographic info in a table, and also includes how many visits that patient has been authorized to receive and a column with the number of visits remaining. In...

Hi All, I’ve been trying to automate a spreadsheet for a while now and I’m completely stuck with how to do it. I have a job card that comes to the office and it has frequency of visits on it. The choice of frequencies are 52 weeks (once a year), 26 weeks (every 6 months), 13 weeks (every 3...

I have a dataset with about 500 rows, each row resembling a page. Each page had so many visitors, generated x amount of dollars, and had x number enter on it as their first page view. I'm trying to give an overall rank for each page based on the visits, revenue, and entries and compare across...

Hello, I am trying to use the frequency formula, but with multiple values. For example: I have 2 columns: "'Nth' Visit" and "Days between visits". In the "nth" visit it shows which number visit a certain date is for a customer. This ranges from 1 visit to 7 visits. What i am wanting to do...

I am using Excel 10. If I have multiple reps that have scheduled visits, and the scheduled visits I want to track are identified with the numbers 2-51. How do I identify the missing visits according to the rep? I have found a few great VBAs for the missing numbers, have not found a solution...

Hi guys, I am trying to get an average time on site for service engineers on regular visits to regular customers from 2 sheets. Sheet one has a manually filled log listing engineer, customer and time on visit in date order. Sheet 2 lists all customers in 1 column, then counts visits to each...