•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need a formula to help roll over #’s if it is past a certain day and question on password protection
Our take
Are you grappling with password protection for sensitive employee bonus data while seeking an effective formula to manage contract rollovers? Ensuring your semi-confidential information remains secure in a cloud-accessible spreadsheet is crucial, especially when multiple users need access. Additionally, crafting a formula that accurately calculates bonuses based on contract status, even when payments extend across months, can streamline your workflow. In this guide, we’ll explore robust methods to enhance your spreadsheet's security and create dynamic formulas that adapt to your evolving data needs.
Okay first thing: password protection. I added it to my sheet that is in a cloud that the entire company has access to. This information is semi confidential. How protected actually is it? And do I need to take more steps to protect it? It is info about pay for specific employees that make bonuses based on a percentage of signed contracts. They need access and my boss needs access but no one else.
Next: I have 2 days workbooks. One with the basic information that transfers onto the protected workbook via query. So in the password protected workbook, I am trying to calculate the bonuses. For example, the data collected is how much the payment was and who did the assisted the contract. They get 5% of that payment. However the contracts can stretch til months in advance. For example: I have one where the consult was created in January and the signing is in February. The data from the consult is in January but there is no confirmation on if it is signed. But they need to be paid on a monthly basis. So is there a way to make a formula that adds up what has been marked as true but then cuts off and stops working after a date (like Jan). So then is it possible to make another one that carries over what is left and adds it together so that if it is signed in March or another month, they will get paid for that contract in that month? If you have any questions or need clarification please ask. I am new to excel and want to figure this out
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Working on creating a formula to use information across two cells to determine calculations in other cells(reposted first post got removed) I'm not certain the IF formula(s) are what I need but I'm not sure what else to use. Trying to create a spreadsheet for work: the premise is that if one or two people are the Contact for a project, they will split 5% of the project's earnings, each getting 2.5%; if only one person, they get 5%. The same for if one or two people who are the Winners for the project. I need some way for the spreadsheet to be able to see that if someone's initials are under either Contact or Winner, to then give them either 5% of the net income if they are the only Contact or only Winner, or 2.5% if they share either spot with someone else. The total amount of the net income given out as a bonus will always come to 10%. The first picture shows my 'backend' sheet and a formula I was trying that would calculate 2.5% of the Net Income if someone's initials showed up on the project, but this doesn't work if their initials only show up once because then they would need to get 5%. I would also hope there would be a less clunky way to do this many calculations. The second picture is a section of the main page of the sheet showing the Contact and Winner columns, the Net Income the bonus comes out of, and then the Total C/W amount under everyone's initials that adds up their total bonuses. Backend sheet, 'points' refers to first sheet First sheet of spreadsheet Please let me know if I have not been thorough enough with explaining what I'm trying to do, I'm so deep in this now that I am really really confused and just need help straightening this all out. Using newest version of Excel on a macbook, have also been working on same spreadsheet in Windows. I'm not a beginner at excel but not all that good either. TYSM in advance. submitted by /u/Financial_Device7400 [link] [comments]
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]
- protect all but one cellI created a excel spreadsheet for co-workers to type a date into one cell and new date ranges appear based on that one cell. The sheet also has other info that I don't want disturbed. How can I make it so that just that one cell allows for data entry without making a password for the sheet? submitted by /u/CorrectMeasurement [link] [comments]
- Need formula advice for a personal portfolio management excel.Im creating a Finance excel and fear ive bitten off more than i can chew. I have extensive experience with excel but could use advice in one area. Background of Excel. The document has a 'transactions tab' that manually tracks all financial trades made, by Date, Account, Asset, Quantity (there are more columns not relevent for this). I have sheets for manually input price data for each asset, this culminates in a 'price master' tab containing Asset Date Price table, of all the price table data (note it doesnt contain dates of weekend trading for securities). The goal was/is to create an "As at" portfolio valuation across all accounts. This sheet contains Date (sequentially down), Account 1, Account 2, Account 3...... I have spent a while trying to create a formula for this as at valuation. It is required to calculate the total account value in each account column as at the row date. To do this, it must first calculate the cumulative quantity of unique each asset (from the transactions table)(row date and all prior dates) multiplying it by that assets price for that date in the price table. The total of these will be the total account value as at that date. (when a date isnt available it should find the last date with a value and use this, this part i have solved). The workbook utilises some heavy formula but this one has stuck me. I have tried creating a positions table, but had difficulty stopping the end of the sum if when the date of the transaction went past the date it should calculate to. Any help or advice is appreciated, happy to provide extensive additional detail and example formula. submitted by /u/Tp616 [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#Excel compatibility#cloud-based spreadsheet applications#real-time data collaboration#intelligent data visualization#AI formula generation techniques#rows.com#financial modeling with spreadsheets#password protection#bonuses#confidential information#employee pay#excel formula#payment calculation#access control#monthly payments