Excel Management Tool


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


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.

Evner: .NET, Excel, VB.NET, Visual Basic, Visual Basic for Apps

Se mere: project tracking template excel free download, project management dashboard excel template free, multiple project tracking template excel, free project management templates excel 2007, excel project management template, free excel project management tracking templates, project management dashboard excel, excel task tracker template, role management tool aspnet, google apps content management tool, web based excel import tool, project management tool database design, rsvp seating management tool, hospital management tool dotnet application, chit fund management tool, excel inventory tool, excel management purpose, excel pricing tool, content management tool fwa, php ajax free user management tool

Om arbejdsgiveren:
( 0 bedømmelser ) Australia

Projekt ID: #17435029

24 freelancere byder i gennemsnit $711 på dette job

$600 AUD in 3 dage
(258 bedømmelser)

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 Flere

$500 AUD in 10 dage
(255 bedømmelser)

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

$1000 AUD in 3 dage
(211 bedømmelser)

Hi, I have experience in financial management tools and I already built a Cash flow Application in MS Excel which manages the cash-in and the cash-out for various financial products including loans and interest. This Flere

$1500 AUD in 10 dage
(54 bedømmelser)
$555 AUD in 10 dage
(41 bedømmelser)

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. Ki Flere

$666 AUD in 10 dage
(55 bedømmelser)

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Flere

$500 AUD in 12 dage
(65 bedømmelser)

With 2+ years in Financial Analysis and piloting of successful Finance projects in Excel, I am an ideal candidate. I have experience with a variety of packages and data formats including Excel dashboards and organizati Flere

$1000 AUD in 10 dage
(3 bedømmelser)

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 ha Flere

$555 AUD in 10 dage
(5 bedømmelser)

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.

$1000 AUD in 10 dage
(41 bedømmelser)

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 Flere

$833 AUD in 45 dage
(14 bedømmelser)

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 dage
(45 bedømmelser)

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, Rad Flere

$750 AUD in 10 dage
(64 bedømmelser)

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 dage
(1 bedømmelse)

Hi Mate, Me and my team is expert in the Web development and deliver the number of projects and handle very tight projects and make possible with the number of best features. I can help you to build this job for Flere

$1666 AUD in 25 dage
(1 bedømmelse)

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 dage
(4 bedømmelser)
$600 AUD in 20 dage
(0 bedømmelser)

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 thi Flere

$300 AUD in 3 dage
(0 bedømmelser)

Hello, nice to meet you. I have checked description carefully. I have full experience for Excel, VBA, Macro, Excel+Program language. I can satisfy your requirements and promise high quality in work. I want to discu Flere

$722 AUD in 10 dage
(0 bedømmelser)

hello,how are you. i read your bid carefully. i am C#, VB.Net expert and have full experience for 7 years. C#, VB.Net is my top skill and my interested skill. I can provide most quality and high fast. if you want t Flere

$555 AUD in 10 dage
(0 bedømmelser)