Find Jobs
Hire Freelancers

Budget planner circular reference problem

$10-30 AUD

Completed
Posted over 9 years ago

$10-30 AUD

Paid on delivery
I have designed a personal budget planner that automatically looks at the month and date then deducts my direct debits depending on when they are due to come out in the month. The issue I am having is that when a new month starts the previous months numbers revert back to 0 as the condition is false again. I need the numbers to stay once the date has passed so I can keep a running balance.
Project ID: 6378668

About the project

14 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
If you want your personal budget planner to be absolutely perfect, then I'm the freelancer for the job. I've spent the past 20 years as a Business Analyst in large corporates, working with critical data and formulae in Excel every day. My proofreading skills and attention to detail guarantee an error-free end result. Being a great communicator with a positive outlook makes it easy and enjoyable for you to deal with me, and you can always rely on my professionalism and efficiency. I'm an independent freelancer, so you know that you will have my personal attention and expertise. Any communication will be directly between you and me, with no middleman to confuse the issue. I love what I do and take great pride in delivering work of the highest quality. I look forward to working with you on this project, Rae
$30 AUD in 1 day
5.0 (2 reviews)
1.4
1.4
14 freelancers are bidding on average $30 AUD for this job
User Avatar
I am an expert in delivering custom tools and softwares willing to discuss further about the project specifications.
$84 AUD in 3 days
5.0 (10 reviews)
5.1
5.1
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my excel reviews. I'm thinking of creating a macro that automatically copy and paste your automated debits when the month ends, but eliminating formulas and pasting only the values ​​(for thus not be changed again). But I can not determine where the debits are loaded, that is, that I should protect cells using a macro to save your information. Chat with me. greetings
$30 AUD in 1 day
4.8 (16 reviews)
4.2
4.2
User Avatar
When a formula (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).) refers back to its own cell, either directly or indirectly, it is called a circular reference. Microsoft Office Excel cannot automatically calculate all open workbooks when one of them contains a circular reference. However it could be corrected obviously but a lot depends upon the formulae you used to form your planner. I am a qualified finance professional and a visiting faculty of finance. In most of the cases we use excel to accomplish the work of our clients. I hope I can meet your expectation, but, as I said, a lot depends on the preparation of the excel utility by you. Whatever it is it could be done of course. I hope to hear from you soon. With Best Regards, cmatapas.
$30 AUD in 1 day
4.9 (3 reviews)
2.9
2.9
User Avatar
I am ready to do the job for you and can do it nicely with very good output in time. Please, check reviews of my past projects.
$30 AUD in 1 day
5.0 (4 reviews)
2.4
2.4
User Avatar
Hi, I have a simple addition to your Direct Debit Amounts formula that should solve your monthly restart problem. I can implement it for you pretty easily, and even add a small extra tidbit to make the formulas a little more "copy and pastable" (to reduce the time spent on each individual instance of the formula) if you'd like. Please let me know if you're interested, or if you have any questions, Thanks! -David Update: I've gone ahead and implemented the additions I mentioned above, so the file is basically ready for you, if you would like it from me. Also, I notice that Foxtel and Equanimity go off of day 18 in your formulas instead of the 15/30 pattern of the rest, but on your Direct Debits tab, you have them marked as days 12 and 15. Is that deliberate? and if not, would you like your formulas to reference the number you have marked on the tab to provide further uniformity?
$30 AUD in 1 day
5.0 (2 reviews)
2.2
2.2
User Avatar
Предложение еще не подано
$25 AUD in 5 days
5.0 (1 review)
0.2
0.2
User Avatar
i am a student of nursing and i need money for my study and it very helpful to my family during this time only waiting my exam therefore please offer me this job thank you
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello today is my first day at freelancer, So If you choose me I will be grateful. I can have your spreadsheet ready for tomorrow. Greetings! Mariano
$20 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
sir i had experience working in BPO where we keep database of 9 lakhs 61 thou calls and other details so i can easily work on your project the bid i place is negotiable thanks for giving me the chance to work in advance
$16 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Estas usando una formula incorrecta, necesitas que en todos los meses los debitos directos queden como gastos de ese mes al cambiar el mes en la hoja formulas. Saludos
$25 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I CAN fix the issue that you have with your budget planner. Since excel is one my forte, you can be guaranteed good work on this project, that too within a small time frame. ==================================================================================================================================================== I am a multi-faceted professional having 5 years of experience, starting from working as a research assistant at Georgia Tech, Logistics Analyst at Nokia, Sales & Operations Manager at Sandisk to starting my own company which provides consulting/freelancer services. I have a Masters in Industrial Engineering from Georgia Tech, and an engineering undergraduate from Delhi College of Engineering (One of the top engineering institution in India). My company- 'Neogistics India' is currently empaneled with IBM as their certified Business Partner, and is being mentored by Neogistics LLC, a consulting company based out of the USA. Please contact us through PM to request for any question that you might have.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am certified in MS Excel and commonly work with formulas and vba code on a regular basis and would be able to fix the code where it wouldn't read false in the condition where the month begins.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Orange, Australia
5.0
2
Member since Aug 27, 2014

Client Verification

Other jobs from this client

Help manage a stockpile
$30-250 AUD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.