Find Jobs
Hire Freelancers

Budget planner circular reference problem

$10-30 AUD

Abgeschlossen
Veröffentlicht vor mehr als 9 Jahren

$10-30 AUD

Bezahlt bei Lieferung
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.
Projekt-ID: 6378668

Über das Projekt

14 Vorschläge
Remote Projekt
Aktiv vor 10 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 Tag
5,0 (2 Bewertungen)
1,4
1,4
14 Freelancer bieten im Durchschnitt $30 AUD für diesen Auftrag
Avatar des Nutzers
I am an expert in delivering custom tools and softwares willing to discuss further about the project specifications.
$84 AUD in 3 Tagen
5,0 (10 Bewertungen)
5,1
5,1
Avatar des Nutzers
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 Tag
4,8 (16 Bewertungen)
4,2
4,2
Avatar des Nutzers
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 Tag
4,9 (3 Bewertungen)
2,9
2,9
Avatar des Nutzers
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 Tag
5,0 (4 Bewertungen)
2,4
2,4
Avatar des Nutzers
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 Tag
5,0 (2 Bewertungen)
2,2
2,2
Avatar des Nutzers
Предложение еще не подано
$25 AUD in 5 Tagen
5,0 (1 Bewertung)
0,2
0,2
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von AUSTRALIA
Orange, Australia
5,0
2
Mitglied seit Aug. 27, 2014

Kundenüberprüfung

Andere Aufträge von diesem Kunden

Help manage a stockpile
$30-250 AUD
Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.