Excel spreadsheet
$30-250 AUD
Paguhet në dorëzim
Please use attached excel spreadsheet for reference.
Please answer questions at bottom.
Please read all my requests before bidding.
I'm after a quick turn around time, within 5 days
if you're unsure of any of my requirements, it falls on you to gain clarity
These tables will be used for data entry that we collect from our clients when they book with us.
There are 24 columns.
Future bookings table:
• Any row that has a future date within 7 days of the current date (Today) will be highlighted in green. See attached spread sheet for colour reference.
• Any row that has a future date between 7 days and 14 days from the current date (Today) will be highlighted in light red. See attached spread sheet for colour reference.
• Any row that doesn’t meet the above criteria will be left as white.
• If the package has been checked to “360 Video Booth” that row will be highlighted to yellow, the yellow will always supersede the green and light red. This yellow will not highlight columns “A & B” See attached spread sheet for reference.
• If column “K, T, U, V, W” is checked to “NO” highlight that cell as red. The red highlight will supersede the highlighted “yellow” rows too until that cells value has changed. If any other cell is left blank, also highlight that cell as red except for column “X”. Once a cell has been checked to “Yes” or as any value/entry is reverts back to its assigned colour. For example: Column “P” row “9” is highlighted bright red because there’s no entry, once an entry has been entered, that cell will go back to light red colour.
• Every entry into the “Future Bookings Table” will always display the nearest date to today’s date at the top.
• Once a date has passed the current date (Todays date) it then gets removed from Future bookings table and placed into Completed bookings table.
• I would like the Future Bookings Table to grow and shrink with each new entry and passing entry.
• In columns “A, C, H, I, J, M, O, P, Q, S” can you add a blank selection to the dropdown lists in the cells.
Completed Bookings table:
• Display closest date to the current date at top of table.
• All rows will be “white” unless the 360 package was selected which can stay yellow.
Charts and Graphs:
1. Each sheet will represent 1 year from 1st July to 30th June.
2. I would like all tables to be dynamic and not have a pre-defined set of rows defined, rather that the table grow with each entry that’s entered or shrink with entries that expire (Table specific)
Chart data:
1. Make sheets that interact for the next 10 years showing the previous year’s data on the current year’s chart. (Only for line charts) This helps compare my growth from the year previously. For example. Sheet 2 will display a faint line from previous year (Sheet 1) so we can visually track growth. Sheet 3 will show sheet 2 and so on. If you require further clarification here please ask
2. At the bottom of the page, I would like 2-line charts;
• Total hire price for each month (from July – June) See attached spread sheet for reference.
• Total booking for each month (from July – June) See attached spread sheet for reference.
3. I would like 6 pie graphs that each show the yearly count, See attached spread sheet for reference.
• photo strips chosen.
• backdrops chosen.
• Packages
• Company
• Event type
• How did you find us?
4. All charts and graphs to show figures. See attached spreadsheet for reference.
Questions:
1. How long will this take?
2. Do you have 100% confidence you can get the job done?
3. Why should I hire you?
ID Projekti: #37365440
Rreth projektit
Është zgjedhur fitues:
(I WILL COMPLETE THIS TASK FOR 25AUD ONLY) Regarding your project (Excel spreadsheet), We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have Më shumë
55 profesionistë freelancer dërguan një ofertë mesatare prej $128 për këtë punë
1. How long will this take? It will take 48 hours. after which I will be available for unlimited corrections, if any. 2. Do you have 100% confidence you can get the job done? This is my field, and I am 100% confident. Më shumë
Hello! My name is Sandeep and I am part of the team at ESOLUTIONS SS. We understand you are seeking a quick turn-around for your Excel spreadsheet project, and we are confident that our skillset and experience make us Më shumë
Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!
Hello. I understand that you are seeking a quick turn around time within 5 days if needed for any clarification of my requirements. Furthermore, I would like to be involved in the process from start to finish so that I Më shumë
5 days.100% sure i can do it. I understand the work. Senior excel expert. 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 Më shumë
Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time Më shumë
--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, Më shumë
Hi, i have checked your attached files both sample and instructions as well. and I am well be able to do this task as per your requirements. And my skills are, I am very good in Excel VBA, Macro charts etc. I have don Më shumë
Hello, I have checked the requirements and basis on that enlisted points can be fixed thru VBA coding. Rest can manage. • Once a date has passed the current date (Todays date) it then gets removed from Future booking Më shumë
I understand you are looking for a quick turn-around time within 5 days and I believe I am the best fit for this job. With my extensive experience in data analysis and Excel, I am confident that I can complete this pro Më shumë
I understand from your description that you are looking for a quick turn around time within 5 days for this project. I am confident that my skillset and experience make me the best fit for this job. I am a professiona Më shumë
I understand what you want and I believe I can fulfill the assignment. I invite you to contact me so I can start the project right away.
hi can i complte your project because i am a expert in typing i will complte your project very fast and start very fast pleas give me one chance pleas give me your project Thankyou
Hi! Hope you are well. I read all above description and understand the need related to the project. I can provide the high level of service that you are looking for. I would welcome the opportunity to discuss my skills Më shumë
Hi, Let's do it! i have a very fast typing speed with high accuracy level. Let's chat about this. You can get the work done anytime within 24 hours, I am always free.