Student Behaviour Tracker
This is a very cheeky request for help. Now approaching 70 I've forgotten most of what I knew about Excel. I'm a Chair of Governors at an 11-16 school. I receive notifications about pupils who have been suspended (also known as fixed term exclusion). Roughly I have about 200 individual suspensions over 1 year. I want to record and analyse these. The information to record is Name: Last and First (about 30-40 students) Reason for exclusion (usually 1 or possibly 2 out of about 8 categories) Length of exclusion 1 - 15 days Flags e.g. SEND; PP, Year group: 7, 8 , 9 10, 11 Date As many of the students are repeat offenders I'd like to set the spreadsheet up so by either by typing the name or through an editable drop down list the name appears once and then the reason for the suspension and date is entered (as opposed to multiple entries appearing on the same page). I'd then like the spreadsheet to report, using an editable date range: By pupil name; the number of suspensions; total number of days and total number of days for each category of exclusion By suspension category: number of suspensions; total number of days for each category By flag: number of suspensions; total number of days for each category Year group: 7, 8 , 9 10, 11: number of suspensions; total number of days for each category I've looked at some cheap packages e.g. at Etsy but I cant see anything that does this. There are commercial packages, intended for whole school, but cost several hundred - thousand plus, pounds. Thanks in advance if you are interested and my apologies to you if you feel this is an inappropriate request. Regards Nick
Formula Help
I have a spreadsheet I use for bidding construction work. On items 1-40 the formula in cells G22-G65 work like they are supposed to. From G66 to G88 where the sheet stops, the formula returns #NAME?. I've checked the formula from G65 to G66 and below, and they appear to be correct. I can't figure out what the problem is. This is the formula that works. =IF(D65>0,'40'!Rate+$G$18,0) This is the formula that does not work. =IF(D66>0,'41'!Rate+$G$18,0) The '40' and '41' refer to individual sheets within the workbook that contain the data in the !Rate cell. I've been looking at this for hours and can't figure it out. Any help or advice would be great.
Stacked Excel Formula
Hello everyone. I've spent the past 2-3 hours trying to figure this out on my own without luck. What I'm needing is a formula that will check D11 (highlighted) to make sure that it's within the parameters listed below it (<17), then I need it to do the same for H11 and I11 (highlighted) and enter the number (1-3) that are not "equal to or greater/less than" into K11. K11 reflects how many samples in Row 11 that are outside of those parameters. I'm trying to make this worksheet more automated and this is the one thing that I cant figure out. Example 1: (all numbers are within parameters, so a 0 is entered into column K) Example 2: (column G is not within the parameters, therefor there is 1 entry in column K)
Link 2 sheets, then sort column A on sheet 2 alphabetically and match correct data
I have two sheets on the same spreadsheet, and I want to pull in the data from 4 different columns to the second sheet and have it automatically update when there are changes or additions to the first sheet. I have a couple issues making this happen - the main one is that the data in my first sheet is custom sorted by color, but I want the new sheet to take the data from column B on sheet 1 and sort it alphabetically, and take the other columns and match them correspondingly to the correct values they match to from column B on the first sheet. Secondly, for blank cells, I want it to leave them blank instead of inputting zero, or any dates. I don't know if this is all even possible, or if I should just remove my custom filters from sheet 1 by cell color and just link it that way. I've spent hours trying to find formulas that work. Please see attached images for reference on what I've tried, and for more clarification as to exactly what I'm requesting. Sorry for the copious redacting, I wanted to be safe rather than sorry with identifiable info regarding this. Any help would be greatly appreciated.
Time sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then grand total for the week. For our pay system we do things in 6 minute increments. I found a sample sheet through Excel, but the formula we have still isnt just right. Here is what I have and the formula for the hours worked is what I am needing help on. Any help is very much appreciated!Excel returns incorrect answer to simple multiplication.
I'm saving a few favourite math examples, and ran into a problem - the last of the calculations came back with an incorrect answer. I'm using a simple =cell1*cell2 formula. It should end with 21. Please help I'm using android app. All cells formatted as numbers.Tender Tracker formula help
Hello, I am creating a spreadsheet to track tenders for various part numbers so that I can track when each part number is up for renewal. Is it possible to create a formula which based on the tender renewal date, excel would colour fill the row up until that date which is in the top row? Example screenshot. Not sure how to add an excel fileTop n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.How to unlink cells in Format Control
I am developing a survey in excel (because the questions are complicated and long and do not format well in e.g. MS Forms) and using option buttons to choose responses. Each question has 6 potential responses. In developer I have inserted a group box, into which I placed 6 option buttons. After formatting the buttons so that they snap to the excel grid I then linked them to a cell to make calculating responses easier. On-line advice then suggested that I could copy and paste these to each new question. However, by doing this, I am only able to choose 1 option as they are ALL linked to the same cell. How do I unlink each group box of 6 option buttons so that I can link each group individually to a different cell for each question? Or - do I have to create a group box and option boxes from scratch for each question set? I have removed the questions for simplicity of view (note that there are 6 in Q1 and Q2 not visible) and highlighted the linked cell from Q1. As you can see - for Q5 this has given an answer of 26 (the 26th option button) rather than 2 (the 2nd button in Q5)
