Budgeting excel sheet, VBA file importer.
Budget: $30 – $250 NZD
I am in need of a freelancer who can create a budgeting excel sheet with the following features for $100.
-Be able to correct VISA import values. i.e credit is $100 positive and D Debit in a negative (-$100).
-This is a charitable to help people understand their purchase decisions.
- Automatic calculations and formulas for easy tracking and management of income and expenses.
- The ability to import and export files using VBA modules.
- Specifically, I need the ability to import text files into the excel sheet.
Ideal skills and experience for this job include:
- Proficiency in Excel and VBA programming.
- Experience in creating complex excel sheets with automatic calculations and formulas.
- Knowledge of file import and export using VBA modules.
The expert programmer most look thought the current coding and understand the needs of the program, to deliver all required outcomes to the end user.
- [ ] The programme must still import bank .csv files of any format and correctly position all contained data only once per unique row instance. The data must be accurate to the original .csv and allow the current program to add data, correlate, sum and chart the data with %100 accuracy.
- [ ] Your job is to ensure all instances of VISA data imports are imporeds with the correct value to the sheet, i.e $100"C" is only $100 and $100 "D" is only listed once each unique instance as $-100, debit.
- [ ] All of the programming is complete except the credit/debit importing. the coding can be added to the post import page if that is easier.
- [ ] The coder is responsible for their work and any fixing of their work in the future.
If you have the skills and experience necessary for this project, please submit your proposal.
-Be able to correct VISA import values. i.e credit is $100 positive and D Debit in a negative (-$100).
-This is a charitable to help people understand their purchase decisions.
- Automatic calculations and formulas for easy tracking and management of income and expenses.
- The ability to import and export files using VBA modules.
- Specifically, I need the ability to import text files into the excel sheet.
Ideal skills and experience for this job include:
- Proficiency in Excel and VBA programming.
- Experience in creating complex excel sheets with automatic calculations and formulas.
- Knowledge of file import and export using VBA modules.
The expert programmer most look thought the current coding and understand the needs of the program, to deliver all required outcomes to the end user.
- [ ] The programme must still import bank .csv files of any format and correctly position all contained data only once per unique row instance. The data must be accurate to the original .csv and allow the current program to add data, correlate, sum and chart the data with %100 accuracy.
- [ ] Your job is to ensure all instances of VISA data imports are imporeds with the correct value to the sheet, i.e $100"C" is only $100 and $100 "D" is only listed once each unique instance as $-100, debit.
- [ ] All of the programming is complete except the credit/debit importing. the coding can be added to the post import page if that is easier.
- [ ] The coder is responsible for their work and any fixing of their work in the future.
If you have the skills and experience necessary for this project, please submit your proposal.