Management Of Payments
Dec 18, 2008
First, ignore the colored portions. This is how I kept track of what I had completed in the form as I created it. Clients attend class once a week and pay once a week for their classes. I'm taking this one step at a time. At the initial interview of a particular client we will determine the payment per session due, and we will enter this amount in the column labeled "payment per session. We also need to keep track of how many sessions they have paid for. So in short, I'm looking for the following:
When "amount paid" equals "payment per session" set "minimum payment due" to $0 and increase "classes paid" by +1
I figured out how to enter the payment and return the minimum payment due to "0" but how can I make the "classes paid" increase by 1 every time the minimum payment equals "0"?
View 5 Replies
ADVERTISEMENT
May 2, 2009
I have 143 macros, but I put 8 of them here b/c the post would not go through with all of them. I couldn't fit all of them on an attachment either b/c the file size was too big. However, I have this goal I have been working on for the last three months on the weekends and the last part.
I would like help with a macro that I can add onto the ones I have. I would like the macro to activate and cause a message box to appear when I open the excel doc. I would like also to be able to activate the message box and its associated macros after the document has been opened.
I would like the message box to have
- Message “The Current Time is (Macro puts current computer time here)”
- Question “How much time do you have?” then beneath this question
- Blank field labeled Hour to give answer
- Blank field labeled Minute to give answer
Depending on the current time on the computer as well as the hour and minute entered, a macro with a matching title from the list below will be selected that fits that criterion. For example, let’s say it is 5:30am and I entered 1 hr and 15 min in the empty fields of the message box. As a result the macro named “Sub Hour1Min15time530am” will be activated. Also due to the fact that the macros I have are in 15 min intervals the code would need to round to the nearest time, so if it was 5:33am when I ran the code the macro would default to 5:30am whereas if it was 5:39am when I ran the code the macro would default to 5:45am.
View 7 Replies
View Related
Apr 24, 2009
i am a builder and i want to make a spread sheet to keep track of what i have been paid and the labour costs i have paid out
so i am working on 20 houses that all have 7 stages of payment each, and 5 to 8 men working on them who receive a price for each stage, but are paid a portion of that price each week while they are working on that stage
what i am trying to do is set up a sheet to keep track of what has been paid and the balance remaining for each stage and what has been received
i have tried doing it a few different ways but im none to clever with spread sheets and what is causing me the problem is next to each payment made i need to put the date and the name of the person who was paid so it always seems to just look a cluttered mess
have any of you got any ideas of how i could simplify this and make it look neat and easy
or alternatively is there some other software that may suit this application better?
View 10 Replies
View Related
Feb 16, 2008
I am wondering if anyone could possibly help me figure out an excel function that would allow me to make a list of payments by year (from 2008 to 2015) that are received on the second tuesday of every month.
View 9 Replies
View Related
Jun 13, 2008
Does anyone know a formula that calculates the future value of an unequal payment stream? I am attempting to calculate the value of an investment plan where the periodic payment increases by 1% each period. I can get the answer by using the FV formula for each payment and then adding them up, but would like to be able to do it without having to do so.
View 9 Replies
View Related
Feb 22, 2010
Assuming the below performance report:
Day 1
Actual 1
Target 1
Achieve 1/1 = 100%
Day 2
Actual 1
Target 1
Achieve 1/1 = 100%
Day 3
Actual 9
Target 10
Achieve 9/10 = 90%
Which method do you use to report the Achievement for the 3 days?
1. Do you take the average of 100%,100%,90% to give 97%
OR
2. Do you sum Actual (Day1+Day2+Day3 = 11) / Target (Day1+Day2+Day3 =12) to give 92%
View 4 Replies
View Related
May 7, 2008
I am working on a Property Management spreadsheet to track the availability of vacant units (and upcoming vacant units). I'm trying to write a formula to count the number of current units that are listed as vacant, so that I can ultimately report on the overall unit availability as of any given period (today, 15, 30, 60, 90-days out). All of the data in this spreadsheet is dynamic and each field can change at any time. There are also a lot of blank fields as well. I am using Excel 2003.
Here are the fields/data that I am using for my analysis:
Column A - (Reporting Period Dates): A2 = 5/20/08, A3 = 6/5/08, A4 = 6/20/08, etc.
Column B - (Unit Status: V=Vacant, O=Occupied): B2 = V, B3 = V, B4 = V, B5 = V, B6 = V, B7 = V, B8 = O, B9 = O, B10 = O, B11 = O, B12 = O, B13 = O
Column C - (M/O Date. These dates represent when the current resident will move out) - Cells C2:C13 contain dates for when each tenant will move out
Column D - (M/I Date. These dates represent when the future resident will move in) - Cells D2:D13 contain dates when the future tenant will move in
If my reporting period is 5/20/08 (cell A2), then I need to calculate how many Vacant units (B2:B13) I will have as of 5/20. The formula will need to count all of the current Vacant units (B2:B13), plus it will also have to take into account any Move Outs (C2:C13) during the reporting period. For example, let's say we have an Occupied unit that is scheduled to move out on 5/15/08. The cell will show this as "O" but the formula will need to determine if the M/O date is <= the Reporting Date of 5/20/08 (A2). If so, then Excel would count this unit as a Vacant for the period.
In addition to this, I also need the formula to look at upcoming Move IN dates (D2:D13). The formula will also have to determine if the MI date is <= the Reporting date (A2). If the MI date falls prior to the Reporting Date, then this unit should be considered as Occupied and should NOT be added to the total available units. NOTE - there are quite a few cells in column D that are blank and don't have MI dates. If there isn't a MI date, then the formula should assume that those units are Vacant if it is past the prior tenants MO date.
I'm assuming that Excel can handle multiple conditions like this, however, I am not smart enough to figure it out.
View 9 Replies
View Related
Apr 4, 2013
My goal is to learn how to universally add specific codes to all clients in one shot.
Here's an example of the data I'm working with......
In column A - I currently have a list of 200 unique clients listed multiple times (1000 rows).
In column B - I have several different types of codes, but that are the same for each client.
Example:
A B
Client 1 Code A
Client 1 Code B
Client 1 Code C
Client 2 Code A
Client 2 Code B
Client 2 Code C
Etc. Etc. for 200 clients
So the question is: When adding a new code, How do I add a codes to all clients in one shot?
View 1 Replies
View Related
Dec 18, 2006
I'm using Excel to connect to an Oracle database using an HTTP connection.
I'm new to VBA and was wondering if it is possible to use cookies to keep the above sessions active?
View 5 Replies
View Related
Feb 12, 2014
I have some sales records that contain GBP payments, along with AUR, USD and EUR.
The GBP payments are not a problem, but a formula which could automatically convert AUR, USD and EUR into GBP payments would save a lot of time and reduce any chance of errors.
I have attached an example of the current layout.
Ultimately, I would like to put the sale in it's GBP amount where the boxes are blank & then a formula that detects either
A) If Original currency (the F column) is not GBP, then multiply the amount in the C column by whatever the exchange rate is in the G column.
B) If the exchange rate column G, has anything other than N/A, then multiply this by the amount in column C.
So, if the original currency in column F is in GBP, then I can enter data into the C column, and it will not change, however if the original currency in column F is not GBP, I would like the data in column C to change.
View 3 Replies
View Related
Jun 17, 2009
The example:
Coloumn A contains dates format of 12/02/2009, but another format such as 10-Apr-09 etc could be used.
Coloumn B contains the amounts of payments received, i.e £5.00, £10.00, £20.00
Now what I require is to be display in another coloumn (say Coloumn C) the number of payments that were received last week and last month and then the total value of the payments.
So the sort of result I'm looking for would be like
Assume todays date is 19-04-09
A B C
12-04-09 £5.00 Last Week 4 Payments Value £45.00
12-04-09 £10.00
13-04-09 £10.00
14-04-09 £20.00
View 9 Replies
View Related
Feb 24, 2013
I am required to fill up a sheet and provide to our Work force management team every week and it takes a lot of time from my day. I know this can be done easily with a code but I don't have enough experience with vb so can't write a good one myself
So here it goes -
I have a roster for my team (e.g. - sheet 2 "Roster") team members are required to work for 8 hours each day in their designated shift.
The codes in roster correspond to specific shift start time (e.g. - sheet 1 "codes")
Sheet - [URL]
I am required to fill up the sheet 3 "Staffing" each week for each half hour interval of a day that an advisor would be present for. So that means, I have to fill up 20 "P" for each member who is working on day from the time he would be starting his shift.
View 3 Replies
View Related
Sep 14, 2009
How can I search a range of cells that have a date entered by hand for a certain month and then sum the amounts given in another range of cells. For example, search several worksheets for payments made in September and then return the sum of those payments.
View 3 Replies
View Related
Oct 25, 2012
On a daily basis we have to manually fill in a time sheet, and I was trying to think of a way where I could just copy and paste it into excel and it would show me on another sheet the total amount of hours I have worked over the month. This gets slightly more difficult, as different clients have different campaigns, and you can work on any variety during the day (however, not all of them do).
Typical raw data looks like this:
Client
Hours
Campaign
Rubber gloves
4.1
SEO
[Code] ....
Therefore I would like to combine the data and then send it off to another report that looks like this:
Rubber gloves - SEO
Rubber Gloves - PR
Bottled Water
1/12/12
4.1
2.3
2.8
[Code] .......
This would allow me to keep a check of how many hours I am working on each campaign over the month, and ensure that I don't run over on time. I have the boxes prepared for the 2/12/12, 3/12/12, etc. where I paste the raw data, and let excel break it down and put it in the report automatically.
I have been entering the data manually so far and I'd quite like to avoid a pivot table or chart (but i am open to it).
View 3 Replies
View Related
Jun 25, 2009
Is it possible to modify the windows power settings in excel vba. I have this example, but it doesn't do anything.
Sub testPOWERCFG()
CreateObject("WScript.Shell").Run "POWERCFG /CREATE Custom1", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /CHANGE Custom1 /monitor-timeout-ac 15", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /CHANGE Custom1 /monitor-timeout-dc 10", 0, False
CreateObject("WScript.Shell").Run "POWERCFG /SETACTIVE Custom1", 0, False
End Sub
I need some code to create and activate a scheme whereby everything is on and also some code to revert back to the default settings on the machine.
View 3 Replies
View Related
Dec 20, 2009
Can periodical fixed deductions/payments be inserted automatically to the individual MONTH sheets of the workbook I uploaded ? To reduce the size of the file, I have left only ONE of the twelve month-sheets - the one for January.
Rephrased :
How to automate the entry of fixed amounts at regular intervals?
My guess is that from time to time, a macro would have to be run
- one of the macro's inputs would be the computer date and the other two inputs would be the value of the entry to be made and the value of the intervening period.
In practice there would be more than one regular entry and the values would be both positive ones and negative ones.
I guess that means one macro for each financial pattern.
Feasible or feesible (a multi-million-dollar-fee task)?
View 12 Replies
View Related
Jan 16, 2007
I need to create a sheet that will take payments away from a starting balance. The catch is that I don't know the starting balance. The interest is compounded annually at 3% and each withdrawl is different. My sheet needs to show the interest earned in each year and the account balance like a running sheet, after lets say 5 years there needs to be no money left.
View 2 Replies
View Related
Apr 30, 2013
I am trying to create a life-cycle management sheet that is simple for the user but gives specific data.
The user would input "Date", "Machine type", "Component Set No.", and "Component". This would happen over a period of time and build up a picture of how often each component was lasting and it's average life in days.
I am fine from the user input side but am struggling to figure out how to extract ONLY the data I need to display in a graph.
For example: If I want to see the average no. of days "component X" is lasting before being replaced I've not been able to extract just that data. I have tried using a pivot chart but this won't do exactly what I'm after.
See the attached for a clear explanation : Component LifeCycle Example.xlsx
View 5 Replies
View Related
Dec 10, 2013
I really need a comprehensive excel file which can manage my bank account id, savings, transactions, withdrawals, transfers etc etc. could be better if it can show any graphical interface with charts as well. I am willing to have a file so that i can manage more than one bank accounts. ( Excel 2003 is my version)
View 3 Replies
View Related
Sep 19, 2007
follows in paragraph 5 - but first, background!
I have a specific formula (received courtesy of some clever person here at Ozgrid (thanks!)) which I use to calculate the Future Value of a series of future payments that increase at a fixed annual rate and earn interest at a fixed rate.
Here it is: =Pmt1* SUMPRODUCT((1+Increase_in_payment)^(ROW( OFFSET($A$1,0,0,Term,1))-1),(1+Return_on_investment)^(Term-ROW(OFFSET($A$1,0,0,Term,1))+1))
(Example: $1000 per annum (Pmt1) is invested for 20 years (Term). The interest earned on the $1000 is 10% per annum (Return_on_investment). The $1000 increases by 5% (Increase_in_payment) each year - i.e. 19 increases - answer: $89,632 (rounded))
This formula assumes that the payment is made at the beginning of the period.
Question: I would like to change the formula to use MONTHLY payments made in advance, and interest earned on a monthly basis.
Because I REALLY do not know what the formula does, maybe I could ask for a detailed explanation thereof - maybe even from the person who supplied it to me (I cannot see who did!) - and then I can start fiddling with it myself if answers do not come.
Two previous posts of mine that dealt with somewhat different issues on the same formula are:
Determine Present Value From Future Value
and
[url]
View 9 Replies
View Related
Jul 14, 2009
I'm having trouble to get VLOOKUP to work. Basically I need to look up Management Teir information from Sheet1 onto Main sheet as per the file attached. Both RecordID columns are Text so they should work right? But VLOOKUP returns #NA error.
View 4 Replies
View Related
Jul 16, 2009
I have a spreadsheet representing a month where I am trying to figure out different scenarios for employees. One scenario is that an employee could have to move to a temporary position. In that case, I need to calculate the salary payments to temporary employees in a particular work unit. I've tried several different approaches to this problem, but am still getting the error.
One method has been using this sumproduct formula:
View 2 Replies
View Related
Apr 30, 2009
I have uploaded a sample amortization schedule.
1. I require the table to adjust itself based on the loan period and number of payments per year entered in D14 and D15 respectively.
2. Also, if a value is entered in column E, then i require the whole table to update as well.
View 7 Replies
View Related
Jan 7, 2010
I have a report which has a list of customers, each customer has 24 columns which represent the payment history over 24 months. If a payment has been made for that month the date and time (formatted correctly) will be populated in this cell.
Each customer has a product name attached to it so a product can appear several times. I need is a formula that shows the total payments recieved for a particular month for a particular product. For example.
I have managed to create the following flag which works a treat, it picks up a date an account was set up but looks at 1 column.
View 2 Replies
View Related