Find Jobs
Hire Freelancers

Custom Spreadsheet with DOB-Based Product Codes

£20-250 GBP

Completato
Pubblicato 19 giorni fa

£20-250 GBP

Pagato al completamento
I'm in need of a custom solution that will allow me to allocate product codes based on an individual's Date of Birth (DOB). Specifically, here are the key functionalities I'm expecting: - Using date range 'born on or after 1 Aug 2012', the spreadsheet will allocate the product code 'Junior (U12)'. - The solution should also consider instances where the DOB doesn't fall within any particular date range, stamping such instances as 'Date Range Check'. - Besides the 'Junior (U12)' product code, I want the solution to accommodate the allocation of other product codes based on different date ranges. These include: - 'Secondary School (12-16)' Born before 1 Aug 2012 but on or after 1 Aug 2008 - 'Youth (16-18)' Born before 1 Aug 2008 but on or after 1 Aug 2006 - 'Young Adult (18-21)' Born before 1 Aug 2006 but on or after 1 Aug 2003 - 'Adult (21-65)' Born before 1 Aug 2003 but on or after 1 Aug 1959 - 'Senior Citizen (65 & over)' Born before 1 Aug 1959 The spreadsheet generated should also permit the user to modify the Date Range for each category as and when required. The ideal freelancer for this job is someone proficient in Excel and well-versed in creating custom solutions with age-based categorization or similar mechanisms.
Rif. progetto: 38039586

Info sul progetto

36 proposte
Progetto a distanza
Attivo 8 giorni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
£0 GBP in 7 giorni
5,0 (50 valutazioni)
5,8
5,8
36 freelance hanno fatto un'offerta media di £125 GBP
Avatar dell'utente
Hello Drew , I am an expert in excel tasks,I saw the details and I understood well how to execute this task within the mentioned timeline . Please contact me to discuss more ,looking forward to work with you. Thanks.
£250 GBP in 1 giorno
4,9 (1115 valutazioni)
8,5
8,5
Avatar dell'utente
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
£150 GBP in 3 giorni
5,0 (503 valutazioni)
8,0
8,0
Avatar dell'utente
Hi there! As I have read, I see you helping. I can create a custom solution for you, allocating product codes based on Date of Birth. and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Best regards, Giovanni.
£20 GBP in 1 giorno
4,9 (65 valutazioni)
7,0
7,0
Avatar dell'utente
Hello, I'd be glad to develop the Excel sheet allowing you to map Product codes with customers DOB. In addition, the solution will allow you to modify the DOB ranges for each code category. Looking forward to chat with you soon for more details. Best regards. Lyes.
£110 GBP in 1 giorno
5,0 (18 valutazioni)
5,9
5,9
Avatar dell'utente
Throughout my career as a data analyst, I have acquired a deep understanding of Excel and a knack for solving complex problems efficiently. Your project requires exactly the kind of expertise I bring to the table. I am confident that with my skills, we can develop a well-organized and dynamic spreadsheet that meets all your requirements. I have considerable experience in creating custom solutions tailored around unique variables such as age and, specifically, DOB categorization. This means I am well-equipped to handle the task of allocating product codes based on date ranges you specified. I assure you that the spreadsheet I create will take into account every possible scenario- giving code allocations for DOBs falling within specific windows, 'Date Range Check' for those outside. Additionally, while crafting your solution in Excel, I'll make sure it's highly configurable by keeping any future date range modifications in mind. My commitment goes beyond timely completion; it extends to ongoing support even after delivery. By choosing me, not only will you get a solution that precisely meets your needs but also lifetime access to the reliability of my skills and assistance for any possible data requirements down the road.
£100 GBP in 2 giorni
5,0 (12 valutazioni)
4,0
4,0
Avatar dell'utente
Hey Drew M., I have carefully read the project description regarding the need for a custom spreadsheet that allocates product codes based on an individual's Date of Birth (DOB). To address this requirement, I plan to create a dynamic Excel spreadsheet that will automatically assign the appropriate product code based on the specified date ranges. The solution will include functions to allocate product codes such as 'Junior (U12)', 'Secondary School (12-16)', 'Youth (16-18)', 'Young Adult (18-21)', 'Adult (21-65)', and 'Senior Citizen (65 & over)' based on the DOB entered. Additionally, the spreadsheet will allow for easy modification of date ranges for each category to ensure flexibility and accuracy. With my expertise in Excel and experience in creating custom solutions for age-based categorization, I am confident in delivering a tailored solution that meets your requirements effectively. Please initiate the chat to discuss further details. Best regards
£50 GBP in 1 giorno
5,0 (2 valutazioni)
3,0
3,0
Avatar dell'utente
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
£35 GBP in 2 giorni
4,6 (10 valutazioni)
2,5
2,5
Avatar dell'utente
Hiya I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, Yii, NodeJS, ReactJS, Angular, Vue.js, HTML5, CSS3 and jQuery. I can do this project. Please hire me. I think, You will contentment with my skills. I can fix your site issue successfully I am looking forward to having further discussions with you and can start working immediately. Best regards, Giáp Văn Hưng
£250 GBP in 7 giorni
4,5 (3 valutazioni)
1,9
1,9
Avatar dell'utente
As a specialist in Excel, I can develop a powerful, tailor-made solution for your specific product code allocation needs. Your project demands precise date comparisons and extensive conditional formatting - both areas that I excel at. Trust me to create a logical, user-friendly spreadsheet that handles all the specific date ranges and produces the corresponding product codes flawlessly. I also understand the importance of flexibility in such projects and would design your spreadsheet with this in mind. It will allow for easy modifications of the date ranges for each category without disrupting the integrity of the formulas or other functionalities. What sets me apart from competitors is my ingrained commitment to creativity and graphical acuity. Despite this not being solely a design-oriented project, my graphic design skills assist me in delivering not just functionality, but also aesthetic appeal and usability to the end product. With me on board, you're getting a freelancer who can provide effective data manipulation combined with an eye-catching interface that allows easy understanding and use of your spreadsheet solution. Let me impress you with my prowess in Excel and Google Sheets!
£20 GBP in 7 giorni
4,3 (3 valutazioni)
2,1
2,1
Avatar dell'utente
Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includesExcel and Google Sheets, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.
£207 GBP in 2 giorni
5,0 (1 valutazione)
1,4
1,4
Avatar dell'utente
Hello there, I do my work properply and get it done on time. I know copy typing very well. Can we talk now? Waiting for your valuable reply! Regards, vaibhav gupta
£150 GBP in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
My extensive experience in this field, coupled with a proven track record of delivering exceptional results makes me the best candidate for this freelance project. With hands-on experience, I have honed my skills in these type of related to the project, allowing me to tackle challenges effectively and efficiently. Furthermore, my strong communication skills enable me to collaborate seamlessly with clients and team members, ensuring that project goals are understood and met with precision. I am adept at managing deadlines and prioritizing tasks to deliver quality work on time, every time. Moreover, my passion for aspect related to the project drives me to continuously learn and innovate, staying ahead of industry trends and best practices. This dedication to excellence reflects in the results I produce, consistently exceeding expectations. Additionally, my ability to think creatively and problem-solve under pressure equips me to navigate any obstacles that may arise during the project lifecycle, ensuring smooth progress and successful outcomes. In conclusion, my combination of expertise, professionalism, and dedication positions me as the ideal candidate to deliver outstanding results for this freelance project. I am committed to bringing my skills and experience to the table, contributing to the project's success from start to finish.
£50 GBP in 7 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hii I am Krishna I am a data entry expert and best command on Excel I am needful person for this project Contact me 8126555128
£135 GBP in 7 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A super easy task to be done......I will give u the best small custom software for ur tasks.....................thanks for posting the job.............
£30 GBP in 1 giorno
5,0 (1 valutazione)
0,0
0,0

Info sul cliente

Bandiera: UNITED KINGDOM
Carrickfergus, United Kingdom
0,0
0
Metodo di pagamento verificato
Membro dal apr 26, 2024

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.