Find Jobs
Hire Freelancers

Excel Management Tool

$250-750 AUD

Closed
Posted over 5 years ago

$250-750 AUD

Paid on delivery
HIGH LEVEL REQUIREMENTS: We require an excel worksheet to manage investors, our assets and their [login to view URL] tool also needs to produce regular reporting using templates that we can amend or add to from time to time. All the data analysis needs to be done in excel so does not require any development other than providing a series of clickable buttons that invokes the excel functions (either data anlaysis/charts/etc.) The analaysiscould include: what if analysis,forecasting, etc. The worksheet needs to blend Ezcel with VB in order to mask the usage of Excel (forms), except when accessing the records in their source location which needs to be isolated and controlled in dedicated sheets that allows any manual maintenance in the event of any failure of the development.  The worksheet needs to identify all phases of the transaction lifecycle from Application through to Reporting. These phases includes: a. Application (capture client static data and record the status of the applicant in particular: Prospect/Applied/Verified, etc. (if Verified then a unique alpha-numeric number must be allocated) b. Registration: Post Verification and Confirmation of payment: Unregistered/Registered (if Registered then a unique alpha-numeric number must be allocated) c. Custody: Unconfirmed/Confirmed (if Confirmed then a unique alpha-numeric number must be allocated) d. Static and General Data Management (all data must be based on configurable fields that allows the administrator to add/remove/amend fields as required. Fields must either be Mandatory or Optional where Mandatory requires appropriate data. All searchable or numeric fields requires verifiable data in a predetermined format.  e. Asset Valuation (a predetermined frequency validated against separately definable fields that determine the format of the verifiable data) f. Unit Pricing (please see Unit Pricing section below) g. Redemptions (Redemptions must be done in a manner that firstly validates the degree of entitlement to redeem, as well as the cycle within which to redeem. A redemption request must be entered (status is Pending), it then requires validation (status Validated), then has to be approved (status Approved). Once approved it must be paid in the next possible cycle, prior to the setting of the unit price for the next cycle) h. Accounting (Accrual accounting. Refer Abed for specifics) i. Reporting (Required reports include:                 1) Monthly Management Reports                       i) Project vs Fund vs Group vs Consolidated (Organisational structure reporting)                       ii) Changes to Unit Prices for this period (before/after)                       iii) Total units issued/redeemed/circulated                       iv) Total number of investors (unique and investments)    2) Performance Reports (tba)  3) Accounting Reports (refer Abed) 4) Compliance Reports (tba) 5) Other Reports UNIT PRICING: This has to be a tightly controlled part of the IMT. The main input is the valuation of each asset within each project, rolled up into one project value.  Therefore, there has to be an area where we can create assets and projects. Moody importantly,  the formula for determining Unit price MUST be completely variable based on  a number of fields as and input value that is also customisable. The Unit price section therefore all consist of a field that dictates the number of variables and also names those variables (e g/ units issued, asset valuation,  allowable deductions, etc.).  There are some areas that will require more in-depth discussion with the successful excel developer.
Project ID: 17435029

About the project

18 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average $657 AUD for this job
User Avatar
Hi there, Warm Greetings We came along with your request for Excel Management Tool and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of .NET, Excel, VB.NET, Visual Basic, Visual Basic for Apps We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$500 AUD in 10 days
4.9 (371 reviews)
8.1
8.1
User 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, models and macros. Check my reviews. Best regards
$1,000 AUD in 3 days
4.9 (282 reviews)
7.1
7.1
User Avatar
Dear Sir, I am excel expert and software developer. I have developed multiple excel tool or software for multiple clients with high quality. I am interested in working with your project. Looking to hearing from you. Kind regards FYI, I am handling the project myself.
$666 AUD in 10 days
4.9 (133 reviews)
6.6
6.6
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
$1,000 AUD in 10 days
5.0 (131 reviews)
6.6
6.6
User Avatar
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. So, I can develop the program in Excel VBA Programming to accomplish your requirements. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio Ready to start please reply soon. Thanks, Virendra
$750 AUD in 10 days
4.8 (96 reviews)
5.8
5.8
User Avatar
HI Going thru your requirement i would suggest you should look at a database for storage and may be look at excel as front end or even C#/PHP based front end. This will make the application more maintainable as well as data will be maintained separately. if required the data can be downloaded separately If you are interested i can work you to elaborate the requirements and design and implement this system The pricing needs I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been executing projects for Microsoft as a customer across various technologies like DotNet, SQL Server, SSIS, SSRS. have executed many turn key projects for them in their licensing space which is very critical for them. Will be able to leverage this experience to deliver this project successfully. to be revisited based on the scope. Thanks Regards Vaidy
$833 AUD in 45 days
4.9 (16 reviews)
5.6
5.6
User Avatar
To Whom It May Concern: I am an expert in Excel development with 15+ years of experience and good track records. Hello, Nice to meet you, I hope you are well Here is a senior Excel developer, langlang. I have read your job description with exciting mood :) In one word, I can say <I can do your project> proudly !!!! Please check my reviews; www.freelancer.com/u/langlangfan I am interested in your projects and I believe I can deliver rich features of the application to beat your imagination. Let's work together to make it happen. Let me know if you are interested and we can always start with something small.
$555 AUD in 10 days
5.0 (5 reviews)
5.2
5.2
User Avatar
As description in your requirement. I'm sure to complete this tool for you with an and-in and macro. inbox me if you have any question about my skill or this project. Thank for your attention HuyPQ.
$444 AUD in 10 days
4.8 (48 reviews)
5.1
5.1
User Avatar
Hi, I've been in excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further. Thanks, Marlou
$722 AUD in 10 days
2.3 (6 reviews)
4.1
4.1
User Avatar
I have briefly read the description on Excel Management Tool development, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well.
$250 AUD in 10 days
5.0 (1 review)
1.4
1.4
User Avatar
Hello, I am an expert in Excel and I prepare all sorts of analyzing yo need to be appeared on the excel sheet. I can send to you some sample of my previous works, so you would be sure that I am capable of doing this project. I guarantee my work for a week after it's finished, it means you can comeback to me asking for further modifications. Looking forward to talk with you. Regards, Hannaneh
$300 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are a web developing and designing company with various other facilities such as web content and digital marketing related to all types of specializations. Additional considerations and implementations are assisted concerning the requirement of the work. We specialize in content writing and its types such as academic and blog writing for UK, US, Australia, Singapore and other countries. Our diverse functions in various fields include: 1. Website Designing 2. Website Development 3. S.E.O. & Digital Marketing 4. Android Application Development 5. iOS Application Development 6. Content Writing 7. Software Development 8. Python Development 9. Java Development 10. C# Development 11. Windows Development 12. Windows Development 13. Ionic Development 14. Angular JS Development 15. Rest Framework Development 16. Wordpress/Magento/Opencart/Drupal Development Our assured services *Punctual Work *24/7 Availability *Plagiarism Free Work *Free support and assistance *Uncompromized Quality
$800 AUD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Jul 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.