Excel spreadsheet match 301 redirectsJobs
I would like to create a solution (can be EXCEL, etc.) for creating working schedule, your solution must have these features: 1. Allow multiple locations, with different schedules and number of workers; 2. Setup multiple workers, set dayoff, hours per week, min hours per day and max hours per day; Example: The worker can have 2 days off (w2 = Monday, w3 = Tuesday, …), should work 48 hours per week, and 5 until 8 hours per day (in sequence, 10:00 – 15:00). 3. Views per week, per month (and per location or per worker) – generate a week / month schedule per location and per worker. 4. A random button to regenerate all again 5. And a button to make equilibrium (YES or NO), with YES on this button, your solution will try to adjust the schedule to ensure the &ldquo...
I have a data entry task that involves working with scanned documents and populating an Excel spreadsheet. Key Requirements: - Typing text from scanned documents into the spreadsheet - Entering numerical data accurately - Copy-pasting relevant information - Organizing and maintaining the data in the Excel format Ideal Skills: - Proficiency in data entry to ensure accurate and timely completion of the task - Familiarity with Excel to efficiently manage and organize the data - Experience working with scanned documents is a plus, though not necessary This task requires meticulous attention to detail, as the data will be used for further analysis, so accuracy is key. The work will be ongoing, so I'm looking for someone reliable and committed to compl...
I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
...Email Whether they are running Facebook Ads (Yes/No) Whether they are running Google Ads (Yes/No) Additional Information: The freelancer should use reputable sources and methods to gather accurate and up-to-date information. The leads should be provided in a structured format, preferably a spreadsheet. We are looking for quality leads, so attention to detail and accuracy are crucial. The project may require researching and verifying information manually to ensure its validity. Deliverables: A spreadsheet containing the requested information for each lead. Regular updates on the progress of lead generation. Timeline: The project should be completed within [insert timeframe]. Budget: Please provide your quote for the entire project based on the number of leads generated...
I'm in need of a professional who can accurately convert scanned PDFs into Excel. 3 different sheet for each supplier. The PDFs are inventory sheets that need to be organized by item number. These sheets will be used for inventory management, so it's crucial that the data is correctly transposed. Key Requirements: - Convert scanned PDFs to Excel - Organize data by item number - Implement conditional formatting to ensure data accuracy Ideal Skills: - Proficiency in data entry and conversion from PDF - Advanced Excel skills, especially in organization and conditional formatting - Experience with inventory management or similar data handling is a plus I look forward to receiving bids from professionals who can guarantee quick and accurate work.
I need a freelancer to take a set of handwritten numbers and enter them into a spreadsheet. The handwritten numbers are clear and legible in the photo provided. The spreadsheet should be arranged exactly as the numbers appear on the photo, with no alterations in the sequence. Ideal Skills and Experience: - Excellent attention to detail and accuracy - Proficiency in data entry and using spreadsheet software - Ability to follow detailed instructions closely - Prior experience with similar projects would be a plus
...API. The ideal candidate will have experience in API integration and database management. Key Project Requirements: - Implement a bulk upload feature for FNSku to ASIN conversion - Utilize Amazon API to extract the ASIN number from the given FNSku - Develop an API database to store and retrieve the ASIN number and the FNSku Additional Functionalities: - Ensure the system allows bulk upload of Excel files - Incorporate the ability for users to download the conversion results - It's essential that results can be downloaded in a specific format, and in this case, directly to an API database. Ideal Skills and Experience: - Prior experience with Amazon API integration and product data extraction - Proficiency in bulk data processing and manipulation - Strong understanding of d...
...t=GBt9a1mvJCtDV3zm-1 Key Features: - The key feature of my site should be highly focused on Product/Service Information. I want these elements to take center stage, providing clear, easy access to all concerned users. Ideal Candidate: - The ideal candidate for this project should have notable experience in WordPress development, possess great attention to detail and the ability to perfectly match the existing design. - You need to have a keen understanding of WordPress' features and limitations, demonstrating the ability to creatively tackle any design challenges that might arise. - Experience in creating sites which highlight product/service information is a huge plus, along with a keen understanding of how to evoke a professional and formal tone through design element...
I have a research paper in Word format which needs to be formatted promptly in the template's layout, requirement, and format. The original paper follows no particular citation style; instead, the formatting should be adjusted to match the template's requirements. The template and its requirements will be provided Key Requirements: - Transforming the content of an existing Word document into a template-required format. - Ensuring a consistent, professional appearance throughout the document. The ideal freelancer for this project should have: - Proficiency in MS Word and formatting tools. - Familiarity with different citation styles and their application. The project has a tight deadline, so quick and efficient work is essential. Please only apply if you can meet the A...
...containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data retrieval from QR scans. This entails a complex task, requiring ...
Having a platform where life partners can find each other with ease is my vision. I need the assistance of an adept Flutter developer to create a Progressive W...A Profile area: Users should be able to conveniently create and edit their profiles. I want user profiles to contain their photos, education, profession as well as their varied interests and hobbies. **Ideal Skills** - Extensive experience in Flutter development and PWA. - A proven track in app interface design for user-friendly applications. - Proficiency in implementing a robust search and match algorithm. - Familiarity with integrating diverse login methods in app development. I seek a developer with a deep comprehension of these elements, for seamless communication and to deliver an excellent, easy-to-use matrimonial...
I'm in need of a versatile data scientist who can expertly navigate both Python and R. For this assignment, you should be proficient in various data analysis techniques including: - Predictive modeling - Data visualization - Statistical analysis The dataset I'll provide comes in Excel format. Your task will be to demonstrate these techniques in Python and R as accurately as possible. Please submit a bid if you're confident in your ability to efficiently illustrate professional-level data analysis in both languages. For now, I only need Part 1 and Part 3 to be done. Part 1 has multiple subparts and should be done in R language. While Part 3 should be done in Python
I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I need a word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
I am in need of a freelancer skilled in data extraction and organisation, ...links, activity links, food and drink, as well as unique experiences. (About 200 cities have to be extracted ). Please organise all of these links in a spreadsheet by the city they cater to. Additionally, I require an accompanying short description for each link provided. Proficiency in Excel and a meticulous attention to detail to ensure accuracy is key. Freelancers who have previously worked on similar projects and can demonstrate strong familiarity with Viator's affiliate system will be greatly preferred. Please confirm understanding of these requirements within your bid. Skills and Experience: - Data Extraction - Excel / Spreadsheet Management - Attention to Detail - Familia...
...develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency in Microsoft Excel...
I'm in need of a CSS specialist who can resolve the inconsistent styling issue with my OneTrust CSS buttons. The proble...problem lies primarily with the color, which is incorrect and lacking cohesion with my brand-specific palette. Ideal skills and experience: - Deep understanding of CSS - Prior experience with OneTrust - Proficiency in responsive design - Clear grasp of alignment fundamentals Responsibilities will include: - Identifying the root causes of the color inconsistency - Restyling these CSS buttons to match our brand-specific color scheme - Ensuring the changes are reflected across all device types (responsiveness). Your bid will stand out if you have a proven track record with this kind of work. Please provide an estimate of time to complete the job as part of...
I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.
Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding -...
...details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward to working with someone who can help streamline ...
Looking for an experienced web developer who can take my Google Sheets table / Excel spreadsheet with the custom formula and turn it into an engaging, dynamically updatable and nicely styled website which I can embed into multiple sections of my WordPress site. Skills and Experience: - Proficient use of WordPress - Extensive experience with website development and design - Sound knowledge of Google sheets and its functionalities - The developer should be able to make the sheet customizable and allow for data updating. Please include your experience relevant to the job as part of your application. Don't worry about showcasing your past work or drafting a detailed project proposal - your background in web development and WordPress is what's most important to me...
I am in urgent need of an experienced web developer to duplicate Website A, with its distinct design layout, content organization, and functionality. Key Tasks: - Precisely replicate the design layout of Website A - Copy the exact content organization method present in Website A - Ensure the functionality of the original website is maintained to the letter - Create admin ...organization, and functionality. Key Tasks: - Precisely replicate the design layout of Website A - Copy the exact content organization method present in Website A - Ensure the functionality of the original website is maintained to the letter - Create admin area that can edit all fields and pictures ,website logo , phone number , and font THE BUDGET IS FIXED PLEASE DON T BID IF YOUR PRICE DOES NOT MATCH...
I need a mobile application built in Flutterflow, able to receive alarm data in JSON format. The app should: - Support both iOS and Android platforms. - Implement user authentication using email and password. - Match the received alarm data to the user the device is linked to. - Send a push notification to the app whenever an alarm is received with the user details that the alarm is linked to. - The home screen will change with the alarm state showing the user information of the linked account to the alarm -The alarm needs to be acknowledged or it will continue alerting. -Information to be displayed when an alarm is received includes the following - Name Surname, Contact numbers, Map of where alarm is(coordinates will be included in the JSON data) - Users will be added on the app...
I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.
I'm in need of a skilled Shopify developer to ensure that our UK/Europe traffic is directed to our UK store on the platform. The primary objective of this redirection is to optimize the shopping experience for these visitors by providing them with prices in their local currency. Key Responsibilities: - Develop a solution that automatically redirects traffic from the UK/Europe to our UK store based on the visitor's location. - Implement this redirection with the aim of optimizing for local currencies. Ideal Skills and Experience: - Proven experience with Shopify development. - Familiarity with geolocation-based redirections. - Previous work on currency optimization within an e-commerce context.
...working on our Power App, using it to collect date data that they later send to an Excel spreadsheet. Unfortunately, we're facing an issue wherein the date picked up by the Power App appears to be a day behind the date actually entered. Your task will be to investigate and rectify this date discrepancy issue, ensuring that the date data picked up by the Power App is accurate and aligns with the data entered by the user. Key tasks and responsibilities would include: - Analyzing the date data flow within the Power App to understand the root cause of the discrepancy - Implementing a fix that ensures the date picked up is the same as the date entered - Verifying that the data is correctly being sent to Excel, reflecting the accurate date Ideal Skills & Exp...
1- Convert the excel data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. This flag should provide the user wit...
I need a proficient data entry operator to assist a task involving typing handwritten documents into Excel spreadsheets. The ideal candidate would have previous experience in data entry, and a high speed typing ability. Accuracy is key in this project, as they'll be transcribing valuable information, it's critical every detail is correct. Time management skills are also important, as there's a specific deadline to complete the task. If you've done similar jobs in the past, please mention it in your proposal. I look forward to working together.
I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.
Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.
Wir sind ein Gastronomiebetrieb und möchten die Kontrollen und Übersichten über diverse Verkäufe, Arbeitszeiten der Mitarbeiter und ähnlichem vereinfacht und am besten mit Automationen in Excel-Listen eintragen. Auswertungen der Verkäufe usw. werden per Mail des Kassensystem-Dienstleisters an uns gesendet. Diese Auswertungen sollen dann in die Excel-Listen eingefügt werden. Mit wenig oder am Besten, durch Automationen, mit keinem Aufwand. Sinn ist es Arbeitszeit zu sparen und Fehler zu vermeiden.
...analyst to organize and create detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors. ### Objectives - **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes. - **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand and utilize the information effectively for sales and marketing strategies. ### Scope of Work 1. **Data Org...
I'm in search of a talented and hard-working freelancer to help me with an Excel task. The job at hand is complex and demands someone with strong analytical skills and attention to detail. The primary objective of this project is to achieve a high level of accuracy and efficiency in the output. Thise means that the quality of work is paramount. To succeed in this role, you must have a good understanding of Excel, be able to think logically, and work meticulously. Key Skills & Experience: - Proven track record in Excel data management - Strong analytical and problem-solving abilities - Attention to detail - Ability to work autonomously I look forward to receiving your application, and I will be in touch with the successful candidate soon.
...streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating exc...
I'm looking for a freelancer who can provide me with the links to Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Co...Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Compile a list of specified Facebook pages - Deliver the links in google seets Ideal Skills and Experience: - Proficiency in Internet Research - Experience with Excel or Google Sheets - Strong attention to detail - Ability to follow instruct...
I'm currently in the market for a seasoned WordPress developer who is well-versed in all aspects of website creation - from the conceptual stages to the final product. Key tasks required: - Web customization tailored to my specific requirements - Plugin development for added site functionality - Theme installation that aligns with the overall a...I'm in need of design assistance, your ability to suggest and implement compelling and user-friendly designs is crucial. Top Priority: - User Experience: The site needs to be easy to navigate, responsive, and intuitive. If you have an eye for design, experience in WordPress website creation, and a commitment towards crafting a top-tier user experience, I'd love to hear from you. If your skills match the requirements, fee...
Please watch video: The following should apply to products with attribute "Bossu product type" set as: Refurbished Consoles, Sell Mobile Phones, Refurbished Video Game Controllers, Sell Consoles & Smartwatch 1) We will create configurable products for some of the products, but match simple products to it, we want certain attributes to show as selectable 2) Only simple products should continue to show in the catalog/category pages and not configurable products 3)Options will appear as swatch in product page 4) If there are simple products part of a configurable product with multiple colours, the colours should show in the category/catalog pages 5) Simple products associated with configurable product SHOULD show individually
I'm looking for a skilled freelancer to enhance my Google Spreadsheet with a few specific features 1. Protect on Edit Functionality: I'd like to add a protection mechanism that ensures the spreadsheet can be edited by all users but avoids accidental changes to existing data. 2. Automated Data Analysis: I'm looking to automate the process of data analysis in the spreadsheet. Your solution should be efficient and user-friendly. 3. Make analysis available in existing web page 3. Export to other existing database It is important that the sheet can be accessed and run from Google Workspace with mainstream browsers without requiring usr to download extensions, run scripts, etc Happy to work on time based payments and will contract item 1 first and then mo...
DESEO HACER UN CAMBIO DE TARIFAS DE UN DOCUMENTO EN WORD DONDE ACTUALIZAR EN BASE AL TEXTO INICIAL SOLAMENTE MODIFICAR LOS IMPORTES QUE SE INDICAN CON LOS CONCEPTOS E IGUALMENTE A EXCEL POR APARTADOS
I am seeking a creative professional to create a company letter...professional. We already have a brief. We already have all the brand colours and elements but just need someone to put everything together on illustrator. There are 6 points on the brief. Key elements to be included: - Company logo - Company name and address - Contact information Deliverable Details: - The final design should be delivered in a Word document. Color Scheme: - The color scheme should match the company's brand colors. (colour code to be advised) Ideal Candidate: - A graphic designer with experience in creating company letterheads and a strong understanding of consistent branding. Your portfolio should display your ability to create professional and clean designs. Understanding of Microsoft Wor...
I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and formatting templates in Wor...
I am in need of an experienced and knowledgeable professional to assist in the development of a comprehensive training program for individuals aspiring to become advanced pentesters. Key responsibilities: - Create a structured, in-depth training curriculum focused on web applications, networks, and mobile applications pentesting. - Design ...particularly in the areas of web applications, networks, and mobile applications. - Prior experience in designing and delivering training programs, workshops, or courses. - Strong communication skills and the ability to explain complex technical concepts in a clear and concise manner. The goal of this project is to equip participants with the necessary skills, knowledge, and practical experience to excel as advanced pentesters in a professiona...
I am looking for a skilled Power BI specialist to help me create an engaging and dynamic dashboard. The primary data source for this project will be an Excel spreadsheet. Key Metrics and Visualizations: - The dashboard should highlight key metrics and KPIs such as sales figures, customer engagement metrics, and operational efficiency. - I would like to see a mix of different chart types in the dashboard, including bar charts, line graphs, and pie charts. Ideal Skills and Experience: - Proficiency in Power BI and data visualization techniques - Experience working with Excel spreadsheets as a data source - Ability to create dynamic and engaging dashboards that effectively highlight key metrics - Knowledge of various chart types and the ability to recommend the most ...
...menu data, which exceeds 500 entries, in Excel. My project primarily involves handling text data. Here's what you would focus on: - Categorizing different types of food items. - Ensuring accuracy and consistency in data entry. While not a firm requirement, familiarity with culinary vocabulary could be beneficial. Additionally, someone proficient in MS Excel and particularly experienced in data categorization would be ideal. I appreciate your consideration and look forward to potentially working with you. Paid project: remote work Seeking Assistance: Categorizing Online Menu Data in Excel Hey guys, I hope you're doing well! I'm reaching out because I could use your expertise for a project I'm working on involving categorizing online me...
I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!
