Excel Automation - Custom Spreadsheet Creation -- 2
$250-750 USD
Pagado a la entrega
I'm looking for an expert who can automate the creation of a multi-sheet Excel spreadsheet based on my input data. The data will primarily consist of text and numbers and will dictate the contents of specific cells rows and columns.
Key Requirements:
- VB for Excel
- Cell Formatting: Certain cells must be formatted in a specific way. This includes the use of conditional formatting and specific cell colours. Your attention to detail in this aspect is key to the successful completion of the project.
- Spreadsheet Structure: The project involves creating a multi-sheet spreadsheet. Each sheet will have its unique layout and requirements.
The data then in spreadsheets will form a dashboard.
Logic in creating spreadsheets:
1. Receive pdf of solar farm layout
2. Understand the layout of the holes that need to be drilled, posts to be installed, structure to be installed and modules to be installed.
3. Understand that each post, structure, and module has a number that makes it identifiable.
4. Use the pdf to understand and create an Excel spreadsheet. i.e. the first row has 200 holes. The second row is 205, then 210, 2012 etc.
5. Use the pdf to understand the first row has 2500 modules. The next 2600 etc.
6. Point 4 and 5 above are two different layout requirements.
The attached pictures are
1. Sample of what the drilling diagram layout would look like in Excel.
2. Sample of what the module layout would look like in Excel.
3. Sample of the layout received for a new project in pdf format.
The project is not to automatically extract data from .pdf.
The project is for the individual to read the pdf and understand what a solar farm layout would look like to go and create Excel spreadsheets. Not manually but by inserting data into "input cells" in Excel that will create a similar layout as seen in the pdf received. Don't get confused, it's not converting PDF data into Excel. It's using the pdf information and manually inputting data in cells that will automatically create a layout that looks like the one you "see" on pdf.
Nº del proyecto: #38628597
Sobre el proyecto
51 freelancers están ofertando un promedio de $465 por este trabajo
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 look Más
Hello Sir, With a wealth of experience in Excel and a solid understanding of Solar systems, I am ready to start working on it. Let's discuss and kick off. Thank you, Usman
Hello, I am writing to express my interest in the project you've outlined. With 8 years of experience as a professional software developer specializing in Python, I possess a strong background in automating processes Más
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide i Más
I am Excel VBA developer and have excellent experience in creating multi-sheet Excel spreadsheets based on input data. I am proficient in VB for Excel and can handle cell formatting with attention to detail. I can effi Más
Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to create a multi-sheet Excel spreadsheet based on input data.. I provide complete ranges of solut Más
Hi There! I have understood the requirements for the task. I have 8+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot table Más
With over half a decade of experience under my belt, I've developed a deep understanding of Excel and Visual Basic that I'm confident will be invaluable in delivering the custom spreadsheet you require. This project, w Más
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform Más
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
Hi there, I have read the brief details of the project u posted. I believe i can help u as I have great experience doing projects with Visual Basic for Apps, Excel, Visual Basic, Software Architecture and Data Process Más
Hello, I have carefully reviewed the details before placing a bid on your project. I am confident that I can complete the task and provide you with an effective solution. With over 14 years of experience in reporting Más
** US born/educated/based and I speak perfect English | Graduated Penn State University ** ** Prof Consulting: 7 yrs for large corporations like Microsoft, Salesforce, Home Depot ** I've reviewed your files and projec Más
WANT TO AUTOMATE YOUR EXCEL SPREADSHEETS EFFICIENTLY? I understand the importance of accurate cell formatting and creating a multi-sheet layout. With over 55 5-star reviews in similar projects, I have the expertise in Más
Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver h Más
Hello! I have extensive experience in VB for Excel and can automate the creation of multi-sheet Excel spreadsheets based on your input data. I understand the key focus here is translating the solar farm layout from you Más
