actual

Hello, i'm after a way to change a cells color based on the value of that cell in relation to the value in an adjoining cell. essentially what the actual value is in relation to the target value. if the actual value cell is lower than the target value cell then i want it to turn red, and green...

Hi All, I have a bit of a challenge... I use this retail software that spits out these awful csv reports that don't provide the information I need -- unfortunately it lumps all sales together, whether they are actual sales or comps. I want to create a formula or formulas to isolate all items...

Hi, I'm trying to sum every 3rd column up to the current week in order to have a current year to date sum up to our current fiscal week (or any fiscal week chosen). Below is the current setup, any ideas with sumproduct, offset, mod probably make sense but I can't wrap my head around what the...

Hi friends I have the following data with me: 31-May-2019 30-June-2019 31-Jul-2019 ........ ........ 31-Oct-2023 While I would need these dates as values (for my other formulas in sheet), I want to "display" Quarter and Financial year number against selected dates on the Dashboard. For e.g...

Hi All, I've seen many posts with questions similar to my own but cant find one to solve my problem. In fact I have a few issues which I will detail here, any solutions to any of them will be extremely helpful. I have a report I export into excel, the report is multiple sheets each sheet...

I have a data model pivot table with a column named "2019 Actual" which shows sales amount. The column resides on the "CombinedAllYears" table. I don't technically have dates (4/1/2019, 4/2/2019, etc) in the table, just month names "Jan", "Feb" etc. I also have a "Store" slicer and want the...

Can anyone tell me why this code will return N/A even though when I walk through it the steps look like it should return an actual result? =IF(OR($I$3="RHP",$I$3="LHP",VLOOKUP($G$3,STATS19pitch,16,FALSE)),VLOOKUP($G$3,STATS19sb,15,FALSE))

All, I need to calculate whether a production item is On-Time (early or on-time), or Late, using workdays only to calc. I also want to be able to get a summary or total by month or similar. I have the following set up already: Deadline Date Actual Production Date If Actual is earlier or same as...

https://www.flickr.com/photos/156921257@N03/46482426265/in/dateposted-public/ I want to see both department actual in the same chart different line, department 91 in blue line and department 81 in green line and the budget in blue line. now I can only slice one department all to see all...

I want to see both department actual in the same chart different line, department 91 in blue line and department 81 in green line and the budget in blue line. now I can only slice one department all to see all departments actual in the same chart. can I do it without changing the actual data...

so i currently have two sheets on a spreadsheet. one called active months, the other called payroll. in the active months sheet i have 3 columns. one for each month of a quarter. so for example i currently have in there jan, feb and mar. i then have a list of employers with their start/end...

Hello all, Hoping you can provide some help to a monthly task... I have a table with a list of individuals with a last date of attendance in one column followed by the 12 months. I have provided an example below: <tbody> Name Actual Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct X1...

Hello, I just starting using Power BI and i'm loving the tool. I have a question about following dataset (monthly load into Power BI) <tbody> date categorie account audittrail data 01.01.2019 Q1 Planning Input 15 01.01.2019 Actuals Actual upload 20 01.01.2019 RAF1 Actual upload 10...

Looking to sum Actual, Budget, Variance YTD data in last three columns in the correct column based on the number in current period, tried sumifs, sum/index, and sumproduct didn’t work. <tbody> Current Year 2019 Current Period 2 Actual Budget Variance...

Hi I was assigned a project at my work to represent a visual graph on appointment duration. I schedule appointments for my doctor and our boss wants to see if hes completing the scheduled appointments on time. I was thinking of using a visual chart that would compare his actual scheduled...

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?

I have a formula that i use to pull out clients names that state "yes" if they are new. The formula has been working for a while and now it is not. On my very first cell, where I have the formula...

Hi Guys! I'm getting frustrated with my indolence in solving the following problem. Hope some smart good people can help me :) I have a spreadsheet in which I add project actual and forecast cost on monthly basis. There is around 500 different projects which, obviously, have different duration...

Hi there, I was wondering if someone could offer a novice a helping hand? I'm pulling together a dashboard to display, amongst other things, the cumulative daily % variance of actual v target. I have the days of the month in A2-A33 and the actual cumulative +/- % in F2-F33. The only thing I...

Does anyone have a simple excel tool to calculate schedule performance based on the number of days in a project, hours estimated and actual hours to date to show if a project is tracking to schedule, ahead or behind?