Find Jobs
Hire Freelancers

Budget planner circular reference problem

$10-30 AUD

Terminado
Publicado hace más de 9 años

$10-30 AUD

Pagado a la entrega
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.
ID del proyecto: 6378668

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,4
1,4
14 freelancers están ofertando un promedio de $30 AUD por este trabajo
Avatar del usuario
I am an expert in delivering custom tools and softwares willing to discuss further about the project specifications.
$84 AUD en 3 días
5,0 (10 comentarios)
5,1
5,1
Avatar del usuario
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 en 1 día
4,8 (16 comentarios)
4,2
4,2
Avatar del usuario
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 en 1 día
4,9 (3 comentarios)
2,9
2,9
Avatar del usuario
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 en 1 día
5,0 (4 comentarios)
2,4
2,4
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,2
2,2
Avatar del usuario
Предложение еще не подано
$25 AUD en 5 días
5,0 (1 comentario)
0,2
0,2
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Orange, Australia
5,0
2
Miembro desde ago 27, 2014

Verificación del cliente

Otros trabajos de este cliente

Help manage a stockpile
$30-250 AUD
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.