Find Jobs
Hire Freelancers

Budget planner circular reference problem

$10-30 AUD

Suoritettu
Julkaistu yli 9 vuotta sitten

$10-30 AUD

Maksettu toimituksen yhteydessä
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.
Projektin tunnus (ID): 6378668

Tietoa projektista

14 ehdotukset
Etäprojekti
Aktiivinen 10 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän 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 1 päivässä
5,0 (2 arvostelua)
1,4
1,4
14 freelancerit tarjoavat keskimäärin $30 AUD tätä projektia
Käyttäjän avatar
I am an expert in delivering custom tools and softwares willing to discuss further about the project specifications.
$84 AUD 3 päivässä
5,0 (10 arvostelua)
5,1
5,1
Käyttäjän 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 1 päivässä
4,8 (16 arvostelua)
4,2
4,2
Käyttäjän 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 1 päivässä
4,9 (3 arvostelua)
2,9
2,9
Käyttäjän 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 1 päivässä
5,0 (4 arvostelua)
2,4
2,4
Käyttäjän 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 1 päivässä
5,0 (2 arvostelua)
2,2
2,2
Käyttäjän avatar
Предложение еще не подано
$25 AUD 5 päivässä
5,0 (1 arvostelu)
0,2
0,2
Käyttäjän 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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän 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 2 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän 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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän 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 3 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän 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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän 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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan AUSTRALIA lippu
Orange, Australia
5,0
2
Liittynyt elok. 27, 2014

Asiakkaan vahvistus

Muita töitä tältä asiakkaalta

Help manage a stockpile
$30-250 AUD
Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.