Provide a Custom tracker in Excel using VBA
- Views 101
What you get with this Offer
If you answered yes to any of these questions, then this offer is for you!
I will create a custom tracker using Excel and VBA that will help you achieve your goals and objectives. I have extensive experience and knowledge in Excel and VBA, and I can create a tracker that suits your requirements and expectations.
Depending on your budget and needs, you can choose from three tiers of my offer:
- Basic tracker (Default): 2 sheets (master, database). 8 variables. Data entry form, formulas, macros.
- Advanced tracker (ADD-ON): 3-4 sheets (master, database, graphs). 16 variables. Data entry form, formulas/macros.
- Premium tracker (ADD-ON): 8 sheets (master, database, graphs). 32 variables. Data entry form. 4 other sheets connect.
Each tier includes the following features and benefits:
- A professional and user-friendly design, using Excel templates, formatting, and styles.
- A data entry form, on cells (default) or using Excel UserForms (separate window) as you require, to enter and validate the data easily and accurately.
- A database, using Excel functions and formulas if required, to store and organize the data properly and securely.
- A master sheet, containing data entry form, and graphs if applicable.
- A graph sheet, using Excel charts and conditional formatting, to visualize and analyze the data and progress of the tasks (For Advanced and Premium only).
- A comprehensive instructions (on Tracker UI), and if you want a documentation and instructions, on separate file, like Word or PDF, to explain how to use the tracker, you can order its ADD-ON.
- A support and maintenance service, using PPH messages or email, to provide you with assistance and revisions if needed.
Why choose me for your project?
- I have over 4 years of experience and expertise in Excel and VBA development.
- I have completed many projects on several platforms, with a 100% satisfaction rate and a 5-star rating.
- I have a portfolio and testimonials of my previous work highlights, which you can check out on my profile or request from me.
- I have a passion and enthusiasm for creating trackers that provide solutions and insights for my clients.
Thank you for your interest in my offer. I look forward to hearing from you and working with you.
Get more with Offer Add-ons
-
I can provide Additional Revision
Requires no additional time
+$5 -
I can provide Additional Graph/Chart
Requires no additional time
+$5 -
I can add Additional Entry Variation
Additional 1 working day
+$10 -
I can add Data Source Connectivity
Additional 2 working days
+$25 -
I can provide Separate User Guide
Requires no additional time
+$19 -
I can provide Advanced Tracker (3-4 sheets (master, database, graphs). 16 variables entry form, formulas)
Additional 2 working days
+$44 -
I can provide Premium Tracker 8 sheets (master, database, graphs). 32 var entry, 4 other sheets connection
Additional 4 working days
+$94
What the Freelancer needs to start the work
The purpose and scope of the tracker.
What kind of data and tasks do you need to track? How often do you need to update the tracker (Into Cells Input, Buttons Control,...etc)?
The functionality and features of the tracker.
What kind of formulas, macros, or charts do you need to use? Do you have any specific requirements or preferences for the data entry form, Input Control, the database, or the graphs (if included)?
Numbers Meaning.
Please Include any Custom Equations to calculate your data outputs (if any). Or Provide any additional Info about required desired outputs to be included.
The layout and design of the tracker.
How do you want the tracker to look like? What colors, fonts, and styles do you prefer? Do you have any examples or templates that you like? You may provide any type of illustration.
On-Tracker Instructions?!
Do you want Instructions on the tracker for how to use it? I am embedding instructions by default, please clarify if you don't want it on the tracker.