Find Jobs
Hire Freelancers

excel spreadsheet

£1500-3000 GBP

Cerrado
Publicado hace alrededor de 2 meses

£1500-3000 GBP

Pagado a la entrega
We are a practice of Architects, landscape Architects, Engineers, Interior Designers, etc and need to create a new updated fee template. The purpose of this is to try to pre-empt as much as we can from the outset, locking down the essential information, but clearly every opportunity will be different and there will need to be some flexibility/adaptability. I have develo0ped the principles of this as far as I can, so I am now in the position to ask you to develop it further for me. The next step is to share this with an excel expert to make it ‘clever’. The intention is that it becomes automated as much as possible which, I’m told, is all possible using macros. So for example: • If you are doing a single discipline bid, you tell the spreadsheet and it hides everything you don’t need and all the other tabs that become irrelevant. o We also set the template to automate the discipline colours and brands • The same applies for work stages – we define what’s needed and the fee template adjusts automatically • Same for the fee – we tell it the start and end dates and duration of each work stage, apply a fee split and it works everything out for us and puts all the milestone payments into a schedule – this same schedule, by its very nature defines a basic timeline/programme. A detailed programme can also be completed. o I know this can be done but I don’t know how to – I’d like the programme to be a bit more automated by being able to add dates to each task and the cells automatically populate – we can also track progress of each task using a % estimate • All hourly rates linked back to a protected source document kept up to date separately (only by a few people) • All T&C’s also linked back to a protected source document kept up to date separately (only by a few people) • Drag and drop images/client logos into the document and they are auto sized • Names and contact details are automated • Automated section numbering all change when tabs are not needed • Repeating rows on pages such as ‘Project team’ • Formatting all fixed, locked and automated to protect the brand • All yellow text need user input – everything else locked down – hopefully its just a case of tweaking or deleting • User can chose how to calculate fee either by percentage or using staff rates and no. of day – they can do both to compare and chose which to use to populate the final table It would be helpful to have an initial chat first, so please let me know when you are free and I’ll set up a Teams call. I can then give you a tour of the spreadsheet and we can understand what is involved.
ID del proyecto: 37801638

Información sobre el proyecto

62 propuestas
Proyecto remoto
Activo hace 13 días

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
62 freelancers están ofertando un promedio de £2.129 GBP por este trabajo
Avatar del usuario
Hi, my name is Selim. I am the Director of ANC, registered in the UK. We are based in Solihull. I read your "excel spreadsheet" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and keen to discuss project details when you are available... I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my work. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply... Kind Regards, Selim
£1.500 GBP en 20 días
5,0 (350 comentarios)
8,3
8,3
Avatar del usuario
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
£2.200 GBP en 10 días
4,9 (606 comentarios)
8,5
8,5
Avatar del usuario
Hello Sir, I am among the highest rated Excel developers and I can deliver your required solution in a quick time. Please invite for a chat and share your Excel sheet so I may take a look. Let's kick off the project. Thank you, Usman
£2.000 GBP en 5 días
5,0 (96 comentarios)
7,4
7,4
Avatar del usuario
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
£3.000 GBP en 15 días
5,0 (192 comentarios)
7,1
7,1
Avatar del usuario
Since 2000 I have been working on Visual Basic (VB6 and VB.NET) and MSSQL, and MS Access MDB. Also Excel spread sheet. So more than 20 years of experience in Visual Basic to build any kind of Windows application. I have created Point of Sales, Inventory, Accounting, Back Office, Hardware Controller System, etc. If you need a good delivery of job and move this project to successful then message me, please. Since 2015 I have been working in C/C++/C# programming. So more than 7(seven) years of experience in C/C++/C# programming. I can build any class, function or method for you. Also expert in data structure building and OOP. Very good in C++ MFC and C++ WinUI 3 for GUI design to build Windows and Console applications and C/C++/C# image processing. If you want a good delivery of the project, then send me a message, please.
£3.000 GBP en 30 días
5,0 (17 comentarios)
6,3
6,3
Avatar del usuario
I specialize in Excel spreadsheet automations and can definitely assist in creating a dynamic fee template for your practice. With over 10 years of experience in development, including expertise in macros and automation, I can ensure a tailored solution that streamlines your processes. By customizing the spreadsheet to hide irrelevant tabs, automate branding, adjust fee structures, track progress, and integrate protected documents, I can optimize efficiency and accuracy. I invite you to review my profile for feedback and portfolio, and I look forward to discussing the project details further with you.
£2.400 GBP en 7 días
5,0 (6 comentarios)
5,9
5,9
Avatar del usuario
Hi, Can you share a sample of current file and discuss about?. I am a programmer skilled in Visual Basic, MS EXCEL and VBA. Best regards, Michael
£2.000 GBP en 5 días
5,0 (70 comentarios)
5,9
5,9
Avatar del usuario
Good day Kirsty, Kindly let us know about sample sheet, in which the mentioned functionalities are to be created? I am flexible in prices, as quality & long-term relationship is more important. Look forward to hearing from you. Regards, Yasir LEADconcept
£3.000 GBP en 60 días
4,9 (4 comentarios)
6,1
6,1
Avatar del usuario
Hi Hope you are doing good! I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Best Regards Arun
£1.500 GBP en 7 días
5,0 (45 comentarios)
5,7
5,7
Avatar del usuario
Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks Anjali
£1.500 GBP en 7 días
5,0 (15 comentarios)
5,8
5,8
Avatar del usuario
Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). I successfully delivered Dashboard, Scorecard, KPI Tracker, heatmap & ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can support you to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics Excel | VBA | Power BI | SQL | OCR | GSheet
£2.250 GBP en 7 días
5,0 (27 comentarios)
4,8
4,8
Avatar del usuario
Hello, I have a BEng in Software Engineering and I have 20 years of Excel experience including developing macros.. I have experience with similar projects. I am happy to have a call on Teams to discuss further. With the dates I can add in formulas once there is a start date to add the number of days a task is going to take. If the date is calculated on adding to the previous task's date then if a task date is changed all the following tasks will be updated.
£1.500 GBP en 28 días
5,0 (3 comentarios)
4,9
4,9
Avatar del usuario
With your practice's need for an excel expert to take your fee template to the next level, my team and I at Einnovention would be an excellent fit. Our expertise in all latest frameworks and languages puts us in a unique position to leverage macros and fully automate your spreadsheet, thereby saving you precious time and effort. We will optimize your document to hide irrelevant tabs, adjust work stages automatically, and even create detailed timelines with progress tracking features. Additionally, our proficiency in CMS including WordPress and web APIs could prove extremely valuable when linking hourly rates and T&C’s back to protected source documents. This streamlines updates and minimizes errors. And since protection of your brand is crucial, we'll ensure your formatting is fixed, locked, and automated while enabling drag-and-drop functionalities for images. Our team's 4.9/5 rating from completing over 248 projects on Freelancer.com signifies our commitment to client satisfaction. Offering services such as unlimited repetitions and free support for over two weeks further manifests our dedication to delivering a product that truly reflects your vision. I am eager to sit down with you via Teams call to fully grasp what's needed before executing a customized solution for your firm. Let's make this project not just 'clever', but indispensable for the daily workings of your architecture practice!
£2.150 GBP en 7 días
5,0 (1 comentario)
4,1
4,1
Avatar del usuario
My name is Muzammal and I have been providing IT solutions for over a decade now. I specialize in Excel and have extensive experience in utilizing macros to automate tasks and create user-friendly templates. For your project, the ability to create a fee template that adjusts based on inputs such as discipline, work stages, start and end dates, and fee splits is something I can deliver flawlessly. I'm confident that I can build an excel spreadsheet that not only preempts essential information but also allows for flexibility in each project. Moreover, my skills extend beyond Excel. I and my team are proficient in programs like Autocad, Revit, Fusion360 which make me well-equipped to understand the intricacies of your architectural practice's needs and ensure compatibility with your protected source documents and brand guidelines. Lastly, I always believe in collaboration and clear communication between clients and freelancers. Therefore, before delving into the project, I aim to discuss your requirements thoroughly via a Teams call to better comprehend your vision for the spreadsheet. My aim would be to further "clever" the principles that you've already developed while incorporating automation using my expertise in Excel including VBA/macros. Choose me and let's build an exceptional fee template together!
£1.500 GBP en 1 día
3,7 (23 comentarios)
5,6
5,6
Avatar del usuario
With a comprehensive understanding of data manipulation and management in Excel, I am confident that I can turn your existing fee template into a smart, automated masterpiece. My experience extends to using macros for streamlining tasks just like yours, whether it is hiding irrelevant tabs, adapting to different project scenarios, automating discipline colors and brands, and more. I strongly believe in the power of efficiencies garnered through technology; by incorporating macros into your spreadsheet, not only can we significantly reduce repetitive manual tasks but also increase accuracy and save time. Additionally, I am skilled in creating relational databases and designing efficient database structures which perfectly aligns with your need to connect hourly rates and T&C's to protected source documents. Ultimately, what sets me apart is my attention to detail and my continuous pursuit of delivering high-quality output. I am delighted at the opportunity to show you how effective and streamlined your fee template can become. Let's get on a Teams call so I can fully understand your needs and provide you with an integrated solution that surpasses your expectations.
£1.550 GBP en 1 día
5,0 (9 comentarios)
2,7
2,7
Avatar del usuario
Hi there, I can perfectly handle this project for you meeting all the requirements you've listed; • If you are doing a single discipline bid, you tell the spreadsheet and it hides everything you don’t need and all the other tabs that become irrelevant. o We also set the template to automate the discipline colours and brands • The same applies for work stages – we define what’s needed and the fee template adjusts automatically • Same for the fee – we tell it the start and end dates and duration of each work stage, apply a fee split and it works everything out for us and puts all the milestone payments into a schedule – this same schedule, by its very nature defines a basic timeline/programme. A detailed programme can also be completed. o programme to be a bit more automated by being able to add dates to each task and the cells automatically populate – we can also track progress of each task using a % estimate • All hourly rates linked back to a protected source document kept up to date separately (only by a few people) • All T&C’s also linked back to a protected source document kept up to date separately (only by a few people) • Drag and drop images/client logos into the document and they are auto sized etc.... I can deliver this project in 1 day. Please reach out. I will begin right away. Also, my bid is negotiable
£1.500 GBP en 1 día
5,0 (3 comentarios)
2,1
2,1
Avatar del usuario
Yes I have read your project and understood requirements but have some doubts. please message me so we can discuss in detail. i am ready to start work.
£2.250 GBP en 7 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
Hello I’ve carefully checked your requirements and really interested in excel spreadsheet. I am confident for your project because I have skills of Microsoft Office, Data Entry, Visual Basic, Excel and Data Processing. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details. Sincerely, Yehor.
£1.500 GBP en 15 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I understand that my background in data entry at DHL Express may not immediately align with your project needs on the surface, but I believe it grants me a unique perspective and skillset that could greatly benefit your Architectural firm. Working with DHL, I had to manage and handle complex sets of information on a regular basis for high-profile clients - which includes skills such as managing different sections, performing data analysis, and ensuring data accuracy. With these skills, I am confident that I can effectively tackle the different components within your fee template: automating processes using macros to cater for various disciplines and work stages; incorporating start/end dates & durations for accurate milestone payments; linking updatable sources for hourly rates and T&Cs, among others. I recognize the need for adaptability in fee templates due to project variability, and I can create an Excel solution that allows for easy customization to suit individual projects' needs. Overall, my experience has taught me the value of attention to detail and providing top-notch customer service; qualities that you can count on as I'll be actively working with you from start to finish. Let's have that initial chat about your spreadsheet! I look forward to showcasing how my expertise in data entry can elevate your fee generation process.
£2.250 GBP en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello Kirsty C., I am Viraj, a Finance executive, accounts assistant, and MIS reports generator with 8 years of experience. As an advanced Microsoft Excel operator with 12 years of experience, I have carefully read the requirements for the project regarding creating an updated fee template for your practice of Architects, landscape Architects, Engineers, and Interior Designers. To address your needs, I will develop a dynamic Excel spreadsheet using Visual Basic and macros to automate various functions such as hiding irrelevant information, adjusting fee templates based on work stages and duration, automating hourly rates and T&C's, incorporating drag-and-drop image features, and more. The spreadsheet will be user-friendly, allowing for easy input and customization. I would like to discuss this project further with you. Please initiate a chat so we can delve deeper into the specifics. Thanks, Viraj
£2.200 GBP en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Bromsgrove, United Kingdom
0,0
0
Miembro desde feb 23, 2024

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.