I am using excel as point of sale book (to record customer name, service, and total price etc.) at our hair salon. We have employees that may be there to manage alone from time to time, and enter clients into excel. Our worry is straight forward, and involves them erasing what they wrote. I am confident that the actual service and price is entered at the beginning, but want to track their changes to their own entries.
The "track changes" would work if it "tracked changes" after entry. But it seems to track the last change from saving. For example....the employee enters $40.25 presses enter--after she knows she can get away with a change, she may erase it altogether or change it to say $16.75.
I'm looking for a vacation spreadsheet that tracks vacation has a column that lists the carryover and the yearly accrual. Ive seen several that list all employees but I am looking for one that is by employee. Where you can list the dates and it totals the days and links back to current available and deducts the days. I saw one online for purchase I like but was not able to download.
I want to track daily sales of a shop with the tenders (Cash, Master, Visa)seperated.
Everyday there will be a file ctp.dbf from a folder YYYYMMDD (previous day date) which contains sales details.
I tried to use sumif commands and everything is working fine. everytime i have to open book.xls and from it I do a files>Open to open the ctp.dbf for the calculation to be done. is there a way where by i can open 1 file and everthing i calculated properly?
Also this book.xls can only do for 1 day how can i go about having the daily sales detail of the month (look something like sales summary.xls) or even year in 1 excel file?
attached is book.xls and sales summary.xls for reference.
I'm trying to auto input names from my schedule into dailytasks for my servers. Sometimes the amount of servers on a specific day changes(i.e Mondays 3 to 5 servers and Friday - Sunday there is 4-6 servers on) and times could change also as of now it works with
=VLOOKUP("6:00",AC$25:AJ$46,8,FALSE)
Not sure how to set up lookup value and return the name
I have a list of all employees and the start date and end date they had an specific salary some dates overlap because they were working in different projects at the same time. I am looking for a function that will verify if any dates are overlapping for each employee. Some will have only one or two rows others have several rows. Here is the sample of the data?
I have a spreadsheet that contains developer related data. I want to be able to do a weekly analysis of average construction time and costs. The problem I am running into is properties enter rehab phase and exit rehab phase throughout the week.
For example:
I want to know the average $ spent and total rehab time week 1 of april. I may have 4 homes that entered rehab that week and 3 that move out of rehab that week. Moreover, I need to ensure those homes that entered and are still in rehab for that week are counted. How do I accomplish this feat?
in range B9:B187 I have names and I have their attendance in I9:AM187 I have all the dates in I8:AM8
attendance codes are PL SL CL LWP TRG & P. I want to segregate all PL SL CL LWP and TRG
I want the output in a different sheet where in column A I will should get name, in column B I should get type "SL PL CL LWP TRG", in column C I should get start date and in column I should get end date.
I have a list of names and want to print an attendance certificate off for each individual on that list. is there a way of doing this automatically or is it copy/paste.. print.. then do next one.
I am recording attendance to our various activities as follows (screenshot):
Column A show the activity
Columns B onwards show attendance by day of the week (names gathered from list).
Now I've got a simple formula =COUNTA(Sep!B4:AE51) to count the total attendance for the month, modifying the range to cater for each activity, but it would be better if I could keep the range the same and modify the activity.
Also, I would like a formula to show the attendance at each activity by the day of the week (ie to show the total and average attendances for Mondays or Tuesday etc).
If you take a look at the spreadsheet you'll see that there are 11 sessions. I'd like to figure out a way by looking at the attendance log to get the percentage/number of people from a certain unit that attended each session. The Y's means that they were present and the N's means that they weren't.
I tried = countif( range,"12WT") which I guess is wrong because it only counts the number of times the word 12WT appears. It doesn't count the number of time a person from 12WT attended the session which is what I'm looking for. How do I go about getting the percentage of people that attended from each unit?
For all the units that didn't attend, is there a formula that would list the units that didn't attend according to the session number? For instance for session one, someone for EC, 9WT, didn't attend. Is there a way that the end result for the formula could be: EC,9WT. Or, does the result for every formula always have to be numeric?
I'm making an attendance list that calculates regular hour and overtime hours for days in a month on rows. Besides the number of hours, there's input for v and s, which stand for vacations and sick days. I'm using the "if" function to separate hour and overtime, and when I put v or s in a cell it messes up my totals. Is there a way to make it so that the cells with v or s don't affect my other columns?
I would like to have a workbook with class lists for 21 classrooms.
Then I would like to use this each month to generate a workbook that has one sheet per class with the teacher name and class name as an overall header. The row stubs would be the student names. The 2 column headers would be the weekdays (Mon through Fri) and the day of the month as a number.
It seems that this could very well be an application that already exists. It seems like the kind of thing a business would create and put on the web as a free download as a good will thing.
Does such an application already exist? If not, is there a small example of populating a workbook with information in another workbook?
I've started with an Attendance tracking template that I found in Excel. My company has implemented an attendance policy where each employee is allowed up to 10 points before they are terminated. A 1/2 point is given for arriving late or leaving early and a whole point is given for an unscheduled absence. The points stay on the employee's record for one year, after that time period it drops off their record. We want to monitor each employee's cumulative points.
So, I'm looking for a way to look back 1 year from the current date and add up the cumulative points over that period.
I am trying to create a 'simple' spreadsheet which will allow me to check how many children are going to be attending my nursery and split them into the different age bands.The columns I am using at the moment are
Name D.o.B Start date Mon AM Mon PM Tues AM Tues PM
I need to be able to split this data into three age groups: Babies (under 2 years), Tweenies (2-3 years) and Pre-school (3+).I would also like the formula to take account of the start date so to remove children from the list who will not have started by this data.
The idea is that I can use this as a quick look to see if I can accept another child / give me an idea of staffing needs. I know there is software out there that can do all this and more, and used to use them on previous nurseries, however this is a new start nursery which does not have the cash to pay for the software at the moment so I am looking to save myself a few hours of checking it all myself until the nursery is up and running and can afford the software which we would hopefully buy in year 2.
I would like for a vba programmer to tell me if the following program can be written before I attempt to code it. When I open Excel I want to see cells containing names in a square array with red backgrounds. As I click on each cell I want the cell to turn green and I want an alphabetized column of the names to have a 1 recorded(after I click) indicating that the person is present. If a person's name is red then I need a 0 recorded. If possible, I would like to be able move over one column each day that I take attendance by clicking on a cell in a row above the column of names. I am a math professor and I write computer code most every day but I have only written some small routines in vba that did not involve events.
I have been creating a simple database to hold a record of attendance.
I'm now at the stage where I want to create a worksheet that cannot be modified; but rather is something the user can look at in a glance.
I need forming a SUMIFS formula that will look for monthly periods of the times late, sick, absent etc and add them up to return to one place.
So the dependants will be the month, the employee and the type of record (late, sick, holiday)
I have created a userform that I can use to add in the raw data, so I'm not sure what range I can create, as every time new data is added it finds the next available row.
Here is what I'm using so far: [Code] ........
What the Overview will look like : Overview.PNG
What the raw data looks like : Raw Data to use.PNG
Do I need to introduce a matched up column that has the employee name and date?
I have an attendance sheet for our Company Employees.
This attendance sheet shows the salary of the month from the total basic salary / hour and overtime / hour of each employee.
I found a problem in this sheet. When i reduced overtime charges in the last of this sheet so the Total Salary of the month was not changing. I couldn't found any mistake in formulas.
I've got an Excel 2007 spreadsheet that I want to use to take the attendance in the school where I teach. I've got it more or less the way I want it, but there are 2 improvements I'd like to make:
1. I don't want to have press Enter to go down to the next cell. If a kid is present, I want to press 'p' and automatically be one cell lower.
2. When I open the spreadsheet (which contains multiple worksheets for different classes), I'd like it to open at today's date on the left regardless of which worksheet I go to (I've frozen the first four columns, so I'd like 'today's column' to appear next to them). I've put the dates in row 1. I've put the dates in the format ddd, d/m/y. (I don't know if that info makes any difference, hence I'm including it). I've already looked up some posts on this and copied and pasted a few different suggestions, but none worked.
I have an attendance file w/least 30 sheets. 29 of the sheets are for each separate group. The other sheet is the main one where I need to collect information like "total participants in attendance" and "total members in group" Then I divide those two and get the percentage of attendance.
The sheets containing the individual groups info are set up like this... (1=they were in attendance)
GROUP 1 Name / January / February / March/ Jess________1________0________1 Ryan_______1________1________0 Joe ________1________0________0 ---------------------------------- total P ____3________1_________1 members___3________3_________3 % _______100_______33________33
I know I can manually go through and link the sums of participation and total group size into the main sheet, but I have a lot of workgroups and need to do this every month, is there an easier way? I am willing to change the set up of the sheets.
I am looking to track changes on a "Log" sheet throughout an entire workbook. The following code (found here and given below) will give me:
The cell . The date/time it was changed . What the new content in that cell is
The two points I would like it to include, in order of importance, is: The name of the worksheet that cell exists in. The user that made that change*Bonus points* a hyperlink that'll bring me to the worksheet that was edited.
VB: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim r As Long, OutSht As Worksheet Application.EnableEvents = False Set OutSht = Sheets("Log")
I have a worksheet that has multiple units listed on it. Each unit has a materials used list with quantities. I want to reference this column to another sheet and get a total materials needed list and also reference it to my inventory and subtract that number from my materials on hand. how can I do this?
So far I was able to find solutions to all of my small problems with excel just by searching here but with this one I need help and ideas how can it be done differently.
We need to track inventory from when its taken, when it was installed and we need to know every month when inventory is counted how much do we have on hand in our truck....
I'd like to make a vba macro in excel which will be just like "Track changes" feature. I'd like to track changed cells and when and who did it. (Date, User, Cell, Last value, New value). It is important to make a report in separate worksheet and automatically fill this worksheet when the user save changes.
Aaron Blood has created an excellent DDE Change Tracking.
The file is in the download area of [url]
The macro, in the xls file, archive the data from top (a1) to the End of the worksheet.
I want invert the way to file/archive the data… copying all the cells already filled, a cell down and filing the top ( A1...) with the last DDE value (In the TracK sheets).
How can I do that?
The primary code is:
Sub Change_Tracker(Watch As String, TrackOn As String)
Dim NextCell As Range, r As Double, c As Double
With Worksheets(TrackOn) r = .Rows.Count Set NextCell = .Cells(r, 1).End(xlUp).Offset(1, 0) End With
I manage a small motel with 6 rooms and I'm trying to write a simple program to track my customer reservations including their details. All the commercial software is too elaborate and way out of my price range. I'm slowly learning excel but this has proved beyond my capabilities.
I want to create a spreadsheet that I can export my transactions from my credit card onto -- is there a way to make it so that the transactions that haven't been covered by my most recent payment(s) are red, while the ones that are paid are green without manually going through & doing it? I know there's the IF, TRUE, FALSE formulas, but I'm confused on how to use them.
Basically, if I spend $1,000 between 5 transactions and make a $400 payment, I want the oldest transactions totalling up to $400 to turn green, while the remaining are stay red until a new payment is posted.