Create excel spreadsheet / develop a simple program to display spending -- 2
$30-250 USD
着払い
I record (note down) my personal spending in around 135 categories (tags). I would like to be able to monitor increases and decreases in this spending (each of 135 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 £.
The spreadsheet/program should be able to be expanded at a later date to include dozens of other tags/categories I might like to track also.
Attachment 1: Image showing some of the 135 categories (the 3 or 4 letter abbreviations all mean something - I will explain later but not important to project)
Attachment 2: An amateur spreadsheet to 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.
It's a kind of complicated but I will be available on Freelancer Messenger to help clarify things.
Sorry to make a couple of final changes - hopefully they won't change your mind about bidding on the project! - what comes below supercedes anything in the original description or in the attachments where there are any conflicts:
There will be a final total of 149 categories (instead of 135).
There will also be 8 ‘virtual’ categories that will be generated by the winning bidder based on the monthly/weekly data I supply. For these 8 - this means developing formulas (e.g. SUM) - each of the 8 formulas will be based on 2 or more (real) (sub-)categories.
Graphing/Charting (dynamic) will only ever be for 18 categories in total (10 ‘real’ and 8 ‘virtual’).
The output (spreadsheet etc) must be as easy-to-use in e.g. 10 years time (with 120 months/520 weeks) of data as in 10 weeks’ time. This is vital.
I will supply the winning bidder with ready-made monthly/weekly totals dating from the start of 2014. These are available now.
I am available to chat 07:00 to 22:00 UK time (7 days) via the Android app. I am happy to go over the instructions in fine detail at almost any time.
I will be available to examine any output only in the evenings UK time.
You may have different ideas as to how to design this software/spreadsheet- I’d like to hear any ideas.
There's also an updated Budget Tracker Spreadsheet which takes the place of v05-02. It's slightly easier to read but I can't seem to attach it to this description. There are no real changes to the layout of the previous spreadsheet anyway and I've already written up everything else at the start of this edit.
Thank you
プロジェクトID: #6504470
プロジェクトについて
23人のフリーランサーが、平均$185 で、この仕事に入札しています。
Hello Sir - 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 amo もっと
Hi, I'll be happy to help you with this project. Guaranteed quick turnaround on most jobs. Please feel free to message me if you need to discuss any questions \
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. I'm thinking a mix of formulas and macros to process the informati もっと
Hi: Please note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my projects are related to Excel and macros. Please connect with me to discuss more.
Hi there. I would be able to design an Excel sheet with an excellent and comfortable to use Excel interface for you to keep track of spendings in multiple categories. I have previously designed several Excel sheets bef もっと
Hey there....I reviewed the revised description and am aligned to the changes you are looking for...I have revised the bid a bit and am ready to get started right away. Below is the original message I had sent. ---- もっと
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. We can do following 1. provide a drop down menu for all categories , where you can select the spend item and r もっと
Hello, pls check my portfolio and contact me if interested. Thanks, Tom__________________________________________________________________________________
I am a qualified IT professional, having more than 10 years of professional experience in database development and building powerful applications in MS Access and MS Excel (Version 2000 to 2013). I have more then 10 もっと
Hi there, we are expert in data analysis and automation. VBA is the powerful programming language which drives data automation in excel. your solution will be excel based but with with a look of web interface (clean もっと