Finalise \"cascade\" budget sheet

£20-250 GBP

Cancelado

Publicado

hace casi 11 años

£20-250 GBP

Pagado a la entrega

This assignment requires experience with Excel VBA. Please do NOT waste your bid if you cannot solve it. I need someone to finish off the attached Excel 2010 "budget" spread sheet that has a different approach than usual. Each month the User can select an "open ended" number of cost categories and enter limits on how much cash can be added to each category (either as a fixed sum for the month, a percentage of the total, or a limit each time the code "cycles" through the allocation),. They then enter the funds to be placed, and the programme splits the money automatically between each category until everything has been placed. This can require several "cycles", The output is then saved to the relevant Month on the database. The key changes needed: 1. If a category is already at its' limit, allow the User to withdraw funds BEFORE the programme shares out the funds 2. Enable the User to recall the month and add more funds, which are then reassigned. Any questions do not hesitate to message me.

Excel

Visual Basic

ID del proyecto: 4659625

Información sobre el proyecto

12 propuestas

Proyecto remoto

Activo hace 11 años

¿Buscas ganar dinero?

Dirección de email

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

12 freelancers están ofertando un promedio de £155 GBP por este trabajo

@svet63

Pls see PM. Regards, Svet.

£250 GBP en 5 días

5,0

(73 comentarios)

6,6

@Teloquence

Consider it done. Check your PM for my bid details.

£157 GBP en 2 días

5,0

(73 comentarios)

5,6

@Nhcuong

Dear Sir, i can do a lot of VBA programming. Can you clarify some points in your allocation algorithm. does this mean: 1/ the fund is need to be assigned to many (not fixed) cost categories 2/ these categories have maximal amount or percentage of the a/m fund. 3/the routine should allocate the fund to all categories in the way that does not exceed the set limits (in amount or in % of the Fund) 4/the sum of these categories costs should be equal the Fund. Best regards, Cuong NH

£180 GBP en 3 días

4,8

(28 comentarios)

4,9

@tamrakar81

hi , I have check excel and macro .. I can help you with it . Regards,

£206 GBP en 8 días

5,0

(18 comentarios)

4,5

@sajidmahmud

Dear Sir, I am extremely interested to your project and ready to start immediately. More details in PMB. Thanks

£150 GBP en 5 días

4,4

(10 comentarios)

2,9

@ednriu

Sir, I am experienced VBA programmer. I am ready to help You.

£150 GBP en 7 días

5,0

(3 comentarios)

2,5

@pentium7

Hi i can help with this

£150 GBP en 5 días

0,0

(0 comentarios)

0,0

@VKSehgal

Comprehensive experience on MS Excel, Access and VBA. Project shall be delivered post comprehensive testing and exceeding your expectations.

£111 GBP en 5 días

0,0

(0 comentarios)

0,0

@mmp3396

I'm ready to do this job. I had worked much with Excel VBA.

£55 GBP en 7 días

0,0

(0 comentarios)

0,0

@ohenekorang

I am happy to take on this role and will provide you with the quality service that will not be available anywhere. I am a qualified accountant with a masters degree and have many years experience in industry and commerce.

£150 GBP en 3 días