Fermé

Excel Workbook for Strata Management

Hi,

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

Compétences : Saisie de Données, Excel, Microsoft Office, Gestion de Projet, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Sydney, Australia

Nº du projet : #19630352

21 freelance font une offre moyenne de $222 pour ce travail

schoudhary1553

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(330 Commentaires)
7.9
tiaratechies

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(53 Commentaires)
6.7
polarjin2017

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(87 Commentaires)
6.6
aubrey03

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(103 Commentaires)
5.7
dfexcel

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(9 Commentaires)
5.2
daniyal3214

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(51 Commentaires)
5.4
xinglong717

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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(10 Commentaires)
4.2
romanapanovich

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(2 Commentaires)
3.5
StephanEdwards

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(2 Commentaires)
3.0
yourhiredhand

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(2 Commentaires)
2.3
ArturQQ

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(2 Commentaires)
1.4
bangleface660

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
0.6
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(0 Commentaires)
0.0
ritikashish2

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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
johnprogramming2

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
ppgangabada

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0
ShumsFaruk

Dear Sir, Hope you are doing well! Though I am new to Freelancer.com, 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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0
ravibach

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
tupac2koy

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(0 Commentaires)
0.0
Fahdrehman10

Being an engineer and Microsoft Office Certified Expert, i can help you with this quite efficiently

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0