Excel Workbook for Strata Management


We are needing a template workbook constructed that has a master sheet that will compile info from all the other sheets within, to help our Strata Managers prioritise their "to-do's / tasks" for all of their portfolios (each Strata Manager has a different quantity of Unit Plans and Complex’s)

So, i was thinking that then each Strata Manager could add in a sheet for each complex and be able to add in each one a list of "to-do's / tasks" This list could include a quote or work order and what status it is at (sent to contractor, in progress, awaiting EC, complete) or simpler tasks like when the next AGM and other meeting types are scheduled for (again with status like awaiting EC, or meeting scheduled for 01/01/1900) or even things just like complaints or queries that people may place that require attention (noise complaint, insurance claims etc) I was thinking that if on each sheet we could have a heading space where they could title the Unit Plan number, complex name, EOFY and perhaps a few other things that is just general info. Then have columns for: the date started – deadline date – level of priority - what the task is – status of task – last date this task was updated – count of how many days – notes / comments (I can add in the drop down lists for the correct options at the end  )

Then if this information off each sheet for each Unit Plan Complex could formulate to the master sheet at the beginning of the workbook to assist the Strata Managers to be able to have a snapshot / summary of all their tasks across all of their portfolio in date due (possibly only business days M/T/W/T/F?) and then by priority. Obviously you could also just add in the filter at the top so they can sort how they like if this will not muck up the formula?

This workbook would be being used by people with a wide range of computer skills, and some with minimal Excel knowledge. So it would be great if eventually we can have the workbook as locked and protected as possible (but still have the appropriate cells where they can type whatever, or add it in) to avoid mistakes being made / the workbook being broken.

It would be nice if the workbook template could perhaps be made to look professional and possibly adding in our logo.

Thank you

Taidot: tiedonsyöttö, Excel, Microsoft Office, projektinhallinta, Visual Basic

Näytä lisää: free property management spreadsheet excel template for tracking rental income and expenses, rental property record keeping template excel, rental property spreadsheet template, rental property excel spreadsheet free, property management spreadsheet free download, free property management forms templates, property management forms pdf, google sheets rental property, excel workbook software, convert excel workbook windows application, convert excel workbook, convert excel workbook stand alone application, convert excel workbook standalone, data excel workbook master workbook using vba, convert excel workbook visual basic, lists business mail addresses germany, upload excel workbook turbolister, excel sheet time management, excel workbook update service, convert excel workbook stand alone program

Tietoa työnantajasta:
( 0 arvostelua ) Sydney, Australia

Projektin tunnus: #19630352

22 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

$250 AUD 7 päivässä
(328 arvostelua)

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. This is Excel /VBA result which I 've done This is what i have done i Lisää

$140 AUD 7 päivässä
(83 arvostelua)

Hello, If you are looking for a senior excel developer that has an experience of more than 15 years, with experience in creating master sheets while fetching data from other sheets. Then I'm the one that can fulfil you Lisää

$1500 AUD 7 päivässä
(48 arvostelua)

Hi, I have carefully reviewed the detailed job description provided on this job post. Based on hands-on job experience in Facility Management and with my expertise in Excel template design, I will create and deliver a Lisää

$188 AUD 3 päivässä
(9 arvostelua)

I am an MS Excel and Access Specialist and an experienced Freelancer who is dedicated to provide quality results within a reasonable timeline and budget. Accuracy is my priority so I believe I am the best freelancer fo Lisää

$250 AUD 3 päivässä
(98 arvostelua)

I am a professional Data analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to perform automation, data analytics and various other task Lisää

$90 AUD 1 päivässä
(51 arvostelua)

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$155 AUD 3 päivässä
(25 arvostelua)

Hi All You say about is better done in Google Sheet 1- web access 2- there is integrated "version control" 3- there is some kind of "access control" - You can provide access to each tab to some user and to some user no Lisää

$120 AUD 2 päivässä
(2 arvostelua)

Hi, How are you today? I have experience in developing like your project. and I have sample code for your project. I have just read your job description carefully and I am very interesting in your job. I am a senior C, Lisää

$200 AUD 7 päivässä
(8 arvostelua)

Good day, Sydney Excel expert here, willing to build an agile based tool for your purposes. I have similar UX driven experience in workbooks for varying Excel aptitude users, and will collaborate to extend from your ba Lisää

$250 AUD 4 päivässä
(2 arvostelua)

I can offer you a simple yet effective solution on how to maintain a file with multiple users. Lets discuss on how to complete this project the soonest. Hope to hear from you soon.

$66 AUD 1 päivässä
(2 arvostelua)

Hello, have a lot of relevant experience, looking forward to work with you. Expert in: ☆ VBA ☆ (Excel, access) ☆ C# ☆ SQL ☆ Google script ☆ Python Quality and problem oriented solutions guaranteed. Experienced with d Lisää

$222 AUD 2 päivässä
(2 arvostelua)

Hi, I am an expert of Ms- Word, Ms- excel, Ms- Access, Ms- Power point and my typing speed is very good. I have 4 years’ experience as a data entry operator and also I do proofreading and internet research. Thanks for Lisää

$65 AUD 7 päivässä
(1 arvostelu)
$155 AUD 4 päivässä
(0 arvostelua)

Dear Hiring Manager, I have gone through your job requirement and I understand that it requires a high-speed typing skill with 100% accuracy. I have 10+ years of experience working with Ms. Excel and MS Office tools. Lisää

$30 AUD 7 päivässä
(0 arvostelua)

Hello I have walked through your note and enough confidence that I can work on your project I am having 10 years of rich experience as Mobile & Web Developer and also know graphics designing means in my career i learn Lisää

$250 AUD 2 päivässä
(0 arvostelua)

Hi, Your requirement exactly matches my latest excel development which you can refer below. Just click on the link and have a look. [login to view URL] You will be p Lisää

$150 AUD 5 päivässä
(0 arvostelua)

Dear Sir, Hope you are doing well! Though I am new to, I am experienced Ms Excel & VBA Genius (Expert Level Skill) by profession. I have earned Distinguished Expert of the year 2017 for Ms Excel & Ms Lisää

$166 AUD 1 päivässä
(0 arvostelua)

Accuracy and quick TAT guaranteed. Payment can be made only if satisfied with the result. please connect on Messenger to take this forward!

$111 AUD 3 päivässä
(0 arvostelua)

I believe i can do the advertised post, i have enough knowledge and skills which will be an advantages towards others. Relevant Skills and Experience Computer literate and efficient in the use of microsoft excel

$155 AUD 3 päivässä
(0 arvostelua)