Forum Widgets
Latest Discussions
Margin calculator for media budget
Hi, I need help formulating a calculator where the 'Fixed Margin' is separated out from the total budget. My calculation needs to add a buffer to the margin as the platform where this is inserted will reduce the nominal margin when you also include a flat cpm fee as it increases the total amount billed. For example, if margin was 20% of $10,000 then the remaining budget left should be $8,000. However, when you add a rate card on top and deliver x amount of media impressions, the effective margin as a percent of total cost is always going to be less than the nominal margin percentage. Example: Total cost: $10,000 Margin fee: 20% Flat CPM rate: $1.50 Impressions: 2,000,000 then this would lead to this: Media Cost $5,600 Margin Fee $1,400 Flat CPM rate ($1.5) $3,000 Total $10,000 Ideally, I would like to ensure the margin is kept at $2,000 (20%) so need help creating a formula that will raise the margin to a % that keeps your nominal margin rate whilst factoring the flat cpm fee and the impressions served.
Help comparing 2 different data sets
Dear Excel community, Hope everyone is keeping well :) I'm looking for some help comparing two different data sets (addresses to be precise). Sheet 2 contains a service list. Unfortunately they are formatted differently. I want to know which addresses from the Master are missing from Sheet 2. I'm not sure what is the best way to approach this without having to format the whole thing. Hope the above makes sense ?! I wanted to attach the workbook but can't seem to upload anything. Thanks Raj
Pivot Table
Hello, I am currently working on several dashboards that include multiple Pivot Tables Is there a way to filter data using the Filters field in Pivot Table design with conditions such as greater than, less than, etc.? At the moment, I have to manually select each value I want to keep, which is quite frustrating It would be very helpful to have conditional filtering available directly in this area Could you consider adding this feature in a future update? Thank you in advance,
Formula for adding multiple sheets
I am trying to add multiple things across multiple sheets. example : On sheet one, I have column a date, column b check number, column c name of place, column d category, column e withdrawal amount, column f deposit amount, column g balance, column h status (cleared or pending). this same information in on sheets 2,3,4,5 and so on. I want to create a sheet that will tell me how much I have spend with each name of place (column c). let’s say sheet one looks like this 3/23 (date) 777 (check number) John Doe (name of place) 2.00 (withdrawal amount) etc. 3/23 778 John Doe Jr. 3.00 etc sheet two 3/24 666 Joe Doe Jr. 3.00 3/24 668 Joe Doe 4.00 on my total sheet with the amount I have spend with each person/place to look like this Joe Doe — 6.00 (from the 2.00+4.00) Joe Doe Jr — 6.00 (from 3.00+3.00)
MISSING FUNCTIONS THAT I PREVIOUSLY HAD ACCESS TO
I just switched macbooks and opened my excel to discover I had a few missing functions: MAXIFS, SEQUENCE. This is not a problem regarding the software as mine is MICROSOFT365 and I used the same account previously. Is there any way I can gain these functions back! Thank you!
[DataFormat.Error] We received a malformed web response and credentials issue
Hi team :) Happy Friday !! There is an excel spreadsheet being connected with data sources and shared with users. Upon, hitting data refreshes it asks every user to edit credentials every time they hit data refresh or shows dataformat.error with malformed web response. There is no data format error though. Can anyone please assist here or know how to solve this issue ?? Thanks HappyHow to change the password of a workbook in Excel for Microsoft 365
Hello, I want to use a stronger password for an (entire) Excel file (i.e., a workbook) than the one I installed a year ago. I am aware of these articles: https://support.microsoft.com/en-us/office/protection-and-security-in-excel-be0b34db-8cb6-44dd-a673-0b3e3475ac2d https://support.microsoft.com/en-us/office/protect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599 I need to remove the first password for the workbook, and then enter the new password. For some reason, it doesn't work as outlined in the article. Any idea how I can do this? Thank you!
