Search the Community
Showing results for tags 'excel'.
-
...
-
Good afternoon all, With all that is/or isn't happening during lock down I'd like to offer some free help. I'm a self employed project controls engineer which involves detailed project management plans and reporting. This involves building logic based gantt charts, critical paths, manning graphs, cost reports etc. Basically I like planning software and excel far too much! If your current systems would require a second opinion I'm happy to help? I can provide some advice / templates that could improve your current setup. Give me a shout and we can discuss. Stay safe, Chris
- 1 reply
-
- project management
- gantt
-
(and 5 more)
Tagged with:
-
I'm putting together a spreadsheet to manage my portfolio. I currently look up and record Zoopla values for my properties each month (quite variable as it happens). I thought that others might be interested in the excel macro that I've created to scrape zoopla for the "Zoopla Estimate" for each of the properties in the portfolio. It will overwrite the last row if it matches today's date, otherwise it will create a new row with today's date. The attached has a couple of random entries and now deals with properties without a valuation. It works off the Zoopla ID of the property. Hopefully you can follow the logic in the spreadsheet. You'll need to head to the "view" tab on the ribbon and then view macros. Happy to take feedback on suggested improvements. All Transactions - blank.xlsm
-
Hi Just wondering if anyone had a good spreadsheet that they would be happy sharing? I am pretty useless when it comes to excel!! Any help would be greatly appreciated Many thanks in advance John
-
Hi, I was wondering if anyone has a spreadsheet that calculates expenses for their properties? I had tried using landlord vision but its a little too in depth. Many thanks in advance
-
Hi, can anyone help with an Excel formula to calculate stamp duty from purchase price based on the current rates for second property + purchases? Thanks
-
Hi All, Just wanted to give something back to the propertyhub as I have been listening for the past 6 months and a lot of the back dated ones and has given me the confidence to go forward into property I am looking at buying my own house hopefully before Summer. I am then looking at going into property flipping to begin with, with a friend of mine (a disillusioned teacher). Then onto investment when the funds are there. Attached is a spreadsheet I have developed: - You are able to see what is viable instead of a finger in the air. Ie. Quit our jobs and go all out into property flipping. Filling in the spreadsheet it showed us that at the start we would be required to do 2 days (contract architectural for me and supply for my friend). Both of our wives will be looking to go to 3 days when we start a family so this can be taken into account. It gives an accurate representation with all deductions factored. This spreadsheet is a guide and not a definite outcome. But the more you know the better decisions can be made. You can also use this as a convincing tool if your partner is not fully on board. Regards, Chris Finances (Getting Started).xls