Find Jobs
Hire Freelancers

Create excel spreadsheet / develop a simple program to display spending

$30-250 USD

Cancelled
Posted almost 10 years ago

$30-250 USD

Paid on delivery
I record (note down) my personal spending in around 85 categories (tags). I would like to be able to monitor increases and decreases in this spending (each of 85 categories) (1) from week to week and (2) from month to month. I produce total weekly and total monthly amounts (all in GBP - Pound sterling) where the weeks run from Monday 00:00 to Sunday 23:59 and months run from 1st to the the last day of course. I would like to see the % change in amounts spent from X week in the past to the current week; Secondly, I would like a dynamically-generated line graph that shows change in spending for 1 or more category at a time. There is a hierarchy of categories where, for example, Food and Drink would include sub-categories such as (1) Food (2) Drink (3) Food and Drink bought from Cafes/Restaurants (4) Food that is healthy v. (5) Food that is unhealthy etc... All these categories are pre-defined and as I've said I have amounts spent on each category each week/month (for some categories, for some weeks/months, the amount may be zero). I would be looking for at least 3 screens: (1) The interface where I enter the amounts for each category the week/month just past (2) Screen showing increases/decreases (3) Line graph with X-axis = time and Y-axis = amounts in £. Attachment 1: Image showing some of the 85 categories (the 3 or 4 letter abbreviations all mean something - I will explain later but not important to project) Attachment 2: An amateur spreadsheet give a 'little' better idea of what I am looking for. I am keen to hear your ideas on what will or will not work - a program may work just as well.
Project ID: 5916688

About the project

26 proposals
Remote project
Active 10 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
26 freelancers are bidding on average $192 USD for this job
User Avatar
Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$100 USD in 3 days
5.0 (650 reviews)
8.3
8.3
User Avatar
Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award
$150 USD in 1 day
4.9 (266 reviews)
7.7
7.7
User Avatar
Hello Sir, I can help you with this job. Ready to start. Thanks, Alex ====================================
$231 USD in 3 days
5.0 (268 reviews)
7.3
7.3
User Avatar
Dear Sir/Madam, As a top rated and reliable freelancer, I am happy to help you on this task. I am an expert in Microsoft office and have a strong financial background which may help you on this project. You can visit my profile to see my qualifications, experience and ratings, and if you are comfortable with above, please send me your data files to confirm. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
$250 USD in 3 days
5.0 (187 reviews)
6.7
6.7
User Avatar
Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience working creating spreadsheets and formulas, in order to get the information I need. regards
$155 USD in 3 days
5.0 (213 reviews)
6.8
6.8
User Avatar
Hi: I have few suggestions: 1- We should design a menu driven sheet where you will get a menu at the start (menu options include: Data Entry, Dashboard to view expenses by month, weeks, change in spending habits). 2- I would suggest stack charts to view the break of expenses by week / month. Stacks are easy to understand and will allow you to draw insights easily. These are my initial suggestions, however, we can discuss more to improve the overall design and feel of the Excel. Please connect with me to discuss more.
$170 USD in 5 days
4.9 (168 reviews)
7.0
7.0
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$250 USD in 3 days
4.9 (165 reviews)
6.5
6.5
User Avatar
HI your talk about in attachments in project proposal . my page i cannot see the any documents. can you send me a again the documents.
$421 USD in 3 days
4.6 (143 reviews)
7.0
7.0
User Avatar
Hi I read the project description and understand the overall requirements of the 3 screens although I do not understand the attachments. I can create a web application using HTML/CSS/PHP/MySQL basically based on your requirements. You could host it on your PC using WAMP, or host it some webhost. Please let me know if interested. Thanks. Regards Ahsan
$350 USD in 35 days
5.0 (93 reviews)
6.7
6.7
User Avatar
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
$194 USD in 3 days
5.0 (73 reviews)
6.3
6.3
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$150 USD in 10 days
4.9 (164 reviews)
6.5
6.5
User Avatar
Hello xray3 :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not disappointed ANYONE TILL date. I have done more than 130 projects. In fact my reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :) Hope to work with you. Regards Sid
$250 USD in 5 days
4.9 (160 reviews)
6.5
6.5
User Avatar
I would very much appreciate the opportunity to complete this project for you. I'm a veteran virtual worker and have done many projects like this one in the past and would be interested in working on this project with you. I am an expert in Excel, data entry, data processing, data scrapping, website scrapping, and web research and will be able to complete the project within the soonest possible time frame you allow. As an honest and highly efficient professional I am highly detail oriented and focused on 100% accuracy, and I apply this same work ethic to my each and every work on freelancer.com. Please feel free to message me if you would like to chat before assigning the project. You can also see my past work experience and reviews here (https://www.freelancer.com/u/safiqulislam67.html). You can also ask me for a sample work if you want to judge my ability in doing this project. I would gladly appreciate this opportunity to work with you. Best regards, Shafiq
$150 USD in 3 days
5.0 (143 reviews)
6.6
6.6
User Avatar
I'm able to use Excel macros, VBAs and also for its formulas and graphs in order to exploit all of its functionalities which could help us do our management well. I think I can help you complete this project as your expectation. Kind regards, Khanh Tran.
$150 USD in 5 days
5.0 (56 reviews)
6.4
6.4
User Avatar
Hi, Your project suits my expertise very well. Lets discuss further through inbox/messages. I having 10 years of Software development experience in Winforms, ASP.NET, C#, VB.NET, SQL Server, MySQL, SQLITE & completed 68 projects in Freelancer.com in last 2 years, all the clients are satisfied & given me 5 on 5 marks in every category, you can read the reviews in my profile. www.freelancer.com/u/skctechno.html
$147 USD in 3 days
5.0 (31 reviews)
5.5
5.5
User Avatar
Hi, We are a group of analysts and have worked on Excel based report, tool & dashboard designs for last several years. At this this stage it would be good if we can send you a layout or plan design for your report. At a high level this will have a data entry set-up using which you will make entries. You would get one report sheet with all increase decreases week on week, month on month. Also you will get the charts. Entire set-up will be dynamic. We do not see the attachments. Please resend the attachments. Also if you send a message to us we would be able to send you the design. Looking forward to hear from you. Regards, Pal (d2imatrix)
$250 USD in 5 days
4.9 (33 reviews)
5.1
5.1
User Avatar
We are team of ACAs, ACCAs, CPAs, CFAs, MBAs, IT professionals and professional writers headed by Kamran Anjum (ACA, FCCA) with over 11 years of practical experience. We are detail oriented and proficient in working, believe in Total Quality Management coupled with excellent time management that makes us stand out of the crowd and helps us complete the jobs in an efficient and effective manner. We will deliver high quality end results to you. Your assignment will be prepared by Excel expert in collaboration with professional accountant and then it will be reviewed by our company head who is a Qualified Chartered Accountant. We will discuss all the details thoroughly before accepting the assignment. Trust us and your satisfaction will be GUARANTEED.
$200 USD in 3 days
4.9 (19 reviews)
4.8
4.8
User Avatar
I'm interested in your proyect, but I need more specifications of what do you want for this. I have a great manage of VBA Macros and Excel, so I propose a development with this software. I think in an Excel file that process all the information: 1) You can enter your information in a sheet of this Excel, or you can upload your information with another Excel file with a known format. 2) With this information, I can match the correct data from the pass to cross this with the current data and do the calculations needed. 3) After this, the charts and graphs will be updated and shown in a particular sheet of PDF file. If you are interested, send me a message so we can discuss the details of this job, and the price and time to finish it. Thanks!
$111 USD in 7 days
4.8 (17 reviews)
4.1
4.1
User Avatar
I have completed several assignments like this, and would be delighted to provide a solution for you. As I work from home in the Midlands, communication will also be straightforward, I work under a Confidentiality and Non-Disclosure Agreement if required, and can start as soon as you pay the fee into the site. I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work from home across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. I have an "interactive activity graph" sample where you select the start and end dates of data shown, the duration of the data from one day to a year, and the measurement frequency from daily to annually. It would let you judge my Excel skill for yourself, but you made this a "restricted" project. I can't send you an attachment unless you send me a Private Message first. I have allowed three days to complete the Project, which will enable you to view the work in progress and make any changes you want in that period. Hope you find this of interest and look forward to hearing from you Bob Allen-Turl Bob Allen-Turl
$123 USD in 3 days
4.6 (12 reviews)
4.5
4.5
User Avatar
Hi. I'm a professional developer in Excel. Please contact if you want an amazing sheet created, with a great reporting system. I never use templates, all my spreadsheets are custom-created. Regards, Ricky
$225 USD in 3 days
5.0 (2 reviews)
3.1
3.1

About the client

Flag of UNITED KINGDOM
BELFAST, United Kingdom
4.9
7
Member since Oct 27, 2004

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.