Excel date range formulaроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
...a strong PHP background to perform an extensive redesign of all pages of my existing website. The project involves: 1. Layout Redesign: The task requires a full redesign of both the homepage and content pages. This includes aspects of the navigation menu as well, ensuring a seamless browsing experience for visitors. 2. Content Modification: Some content sections need adjustments. Changes will range from removal, addition, or rearrangement. Details will be provided during the project's commencement. Ideal candidates should have strong UX/UI design skills, experience in PHP web development, and a keen eye for detail. Strong communication skills are essential, as I expect regular updates on project progression. Show me your previous redesign projects to showcase your capabil...
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
...real-time, detailed shipment tracking system is also a must-have. This will provide users with up-to-date information about the whereabouts of their shipments, enhancing transparency and trust. - Quotation Creation: The platform should allow users to create and customize quotations easily. This feature will help users plan and budget their logistics operations. Audience: - The platform should cater to a variety of users, including freight forwarders, shippers, and logistics companies. It's essential that the platform is user-friendly and accessible to individuals with varying levels of expertise in logistics. Logistics and Freight Options: - The platform should cover a comprehensive range of freight options, including air freight, sea freight, and road freight. This...
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
...labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 29 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be communicated and facilitated on our end to ensure a seamless transition. **Ideal Skills and Experience:** - **Organiza...
... labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 4 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be communicated and facilitated on our end to ensure a seamless transition. **Ideal Skills and Experience:** - **Organizat...
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
The objective of this project is to develop a modern, user-friendly website for our home services company, offering a comprehensive range of plumbing, heating, cooling, and other home services. The website will serve as a digital storefront and informational hub, enabling customers to easily browse and understand the services offered, request quotes, and schedule appointments. The website will have about 70 pages. Key Features and Functionalities: - Service Listing and Description: The website will have dedicated sections for each service category (Plumbing, Drains, Heating, Cooling, Pool Heaters, and Other Services), with detailed descriptions and breakdowns of specific services offered under each category. - Service Area Coverage: Clearly communicate the geographic areas se...
I am looking for assistance in optimizing battery performance through Matlab simulation. Due to the project specifics not being clarified, the professional should be comfortable and experienced in working with a range of battery types such as Lithium-ion, Lead-acid battery and Nickel-metal hydride batteries. Key points to consider for this project: Skills and Experience • Understanding and experience in working with various battery types • Proficiency in Matlab for creating simulations and testing • Strong analytical modeling skills Project Objectives • Provide research and suggestions on optimizing battery life, decreasing charging time and improving power output. • Develop a comprehensive Matlab model suitable for variety of scenario...
I am looking for a skilled video editor who can create and edit engaging videos for my social media presence. - Platforms: The videos will be posted on Instagram, YouTube, and TikTok. - Style: The videos should be designed to be fun and energetic, in line with my social media brand. - Length: I will need a range of video lengths, depending on the platform. Short, snappy videos for Instagram and TikTok, and longer, more in-depth videos for YouTube. Ideal candidates will have experience in creating social media video content and can demonstrate a strong grasp of the different editing styles required for each platform. A portfolio showcasing previous work in this area would be highly desirable. The ability to produce engaging, dynamic content while adhering to branding guidelines i...
Searching for a creative partner to produce compelling videos for an established psychology and mental health focused YouTube channel. Here's what the ideal candidate brings to the table: • Expertise in YouTube algorithm for channel monetization • Capabilities to generate content on a wide range of topics - Depression and anxiety, Self-help and personal growth, Relationship advice and any subject related to psychology and mental health. • Insight into audiences of all ages • Ability to produce and upload new videos as frequently as possible, with a minimum commitment of twice a week. Ideal Skills: • Proficient in video creation and editing. • Strong understanding of YouTube algorithm, SEO, and techniques to drive viewer engagement. • In-dept...
...navigarea pe site, optimizați metadatele și îmbunătățiți viteza site-ului. - Optimizare SEO off-page: creați backlink de înaltă calitate, gestionați listele locale, creați postări captivante pentru invitați și monitorizați mențiunile pe rețelele sociale. Freelancerul ideal ar trebui să aibă un istoric de succes în furnizarea de strategii SEO atât on-page, cât și off-page. Caut persoane bazate pe date care au ajutat clienții anteriori să îmbunătățească vizibilitatea site-ului și să crească traficul pe site. Competența în utilizarea instrumentelor SEO precum Semrush, Ahrefs și Moz este esențială. În plus, cunoștințele solide despre cele mai bune practici SEO în continuă schimbare, împreună cu abilități excelente de comunic...
I have a CS-Cart Multi-Vendor site that experienced a severe breakdown following a failed upgrade. This has led to a range of issues from broken layout to persistent error messages. Additionally, after the failed upgrade, the database is out of sync. The site needs urgent attention to get it back on track. Your primary role on this project will be: - Debug and fix the bad upgrade: This includes addressing the broken layout, error messages, and the out-of-sync database issue. - Server Configuration & Security Audit: Given that I've made changes to the server configuration and security settings post the failed upgrade, it's crucial to assess these modifications and ensure they're functioning optimally and not contributing to the site's issues. - Optimization...
I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the website will provide common real estate features such as property searches, property listings, and a contact form. Moreover, the website would ideally cater to a range of purposes, from displaying property listings to generating leads and providing company information. Ideal Skills and Experience: - Proficiency in web development with React - Past experience in real estate website creation - Understanding of lead generation mechanisms - Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous real estate we...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I am seeking a skilled developer to create a dynamic HTML website for my e-c...comprehensive e-commerce setup, capable of handling product listings, shopping cart functionality, and secure checkout processes. Key Requirements: - Previous experience in e-commerce website development. - Proven expertise in HTML and delivering responsive websites. - A thorough understanding of e-commerce and online payment systems. - Ability to work within a tight deadline, with a targeted completion date of within a month. Note: The specifics of the payment methods to be integrated are not finalized yet, as I’m open to suggestions. Your professional input and guidance in this area would be highly appreciated. Looking forward to collaborating with a skilled professional who can bring this v...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
I'm searching for an experienced WordPress developer to handle the monthly maintenance tasks of my website. Key Responsibilities: - Regular content updates: The ideal candidate will be responsible for making regular updates to the site's content. These updates need to be made on a monthly basis. - Security monitoring: Ensuring the website is secure and protecte...tasks such as image optimization, code cleanup, etc. Ideal Skills: - Proven experience with WordPress website maintenance - Proficiency in handling regular content updates - Strong background in security monitoring for WordPress websites - Demonstrable experience in performance optimization I'm looking for someone who can commit to this role on a monthly basis, ensuring the site is always up-to-date, sec...
...various platforms? Join us to plan and execute paid advertising strategies that effectively target and acquire customers while maximizing ROI Requirements: Proven experience and expertise in your respective field of digital marketing. Strong analytical skills and the ability to interpret data to drive informed decisions. Excellent communication and collaboration skills. A passion for staying up-to-date with the latest trends and developments in digital marketing. Benefits: Competitive salary and benefits package. Opportunity for career growth and advancement within a thriving agency. Collaborative and supportive work environment. Access to cutting-edge tools and resources to enhance your skills. To apply please: 1. Provide a few examples of your work 2. Let me know what you c...
I'm looking for an experienced professional to create high-quality video content centered around Vedic Mathematics. The content will be aimed at educating students, hence should be engaging, clear and informative. Key Responsibilities and Requirements: - Develop a series of video content on Vedic Mathematics. This will involve covering a wide range of topics and concepts within the discipline. - Utilize an electronic pen and tab for creating these videos. Proficiency in using this technology is a must. - The primary objective of the videos is to provide educational support to students. Therefore, the content should be presented in a manner that is easy to understand and follow. Ideal Candidate: - Prior experience in creating educational content, particularly in Mathematics, w...
I'm in search of skilled son...capable of writing for other categories. - Reference Tracks: I have over 40 reference tracks that I'll need you to work with. - Purpose: The tracks you'll be writing lyrics for are intended for promotional and maybe commercial use down the line. Ideal candidates will have: - A strong understanding and appreciation for rap, trap, and R&B music. - Proven experience in writing lyrics for a wide range of genres. - Ability to creatively adapt and work with multiple reference tracks Of me melodizing and flowing. - A portfolio or examples of previous work that demonstrate your songwriting skills. -$25 a song if they start growing after release the raise goes with the business so need to be comfortable hustling at first with commissions ...
...a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simulta...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shift...
I have a project in AutoCAD that involves a range of design tasks - from creating 2D drawings to rendering images from CAD files. Key Requirements: - Creating 2D Drawings: These should have intermediate details, including dimensions and material specifications - Designing 3D Models: Expertise in Mechanical 3D modeling is essential - Rendering Images from CAD Files: You should be able to produce high-quality visualizations from the CAD data Ideal Skills and Experience: - Proficient in AutoCAD software, specifically within the Mechanical field - Experience in creating detailed 2D drawings and 3D models - Strong portfolio of previous CAD work, particularly in rendering images from CAD files - Understanding of material properties and dimensions in a Mechanical context I'm looki...
I'm in need of a meticulous proofreader who can enhance the quality of my academic papers and creative works. The documents I need help with range from 500 to 1000 words, and I'm expecting an in-depth review of language and structure. Key Responsibilities: - Proofreading: Correct any grammar, spelling, and punctuation errors. - Sentence Structure: Review the flow and coherence of the text. - Style & Formatting: Ensure consistency and coherence in writing style. Ideal Skills and Experience: - Strong command of English language. - Previous experience in proofreading academic papers and creative writing. - Proficiency in identifying and correcting structural issues in writing. - Attention to detail and ability to consistently meet deadlines. I'm looking for a reli...
...and brand-reinforcing profile and banner images that capture the essence of the respective franchises. - Branding & Templates for Social Media: Create cohesive branding materials and templates for social media platforms that embody the themes of Sci-fi, Fantasy, Cyberpunk, and Horror, with a specific focus on Machines & gears. - Static & Animated Visual Elements for Videos and Posts: Develop a range of static and animated elements that can be seamlessly integrated into both long and short format videos and posts, specifically: - video frames, - subtitles stylings, - thumbnails, - background images, - circular character frames. These elements should be eye-catching, diverse, and tailored to each franchise's unique visual identity. - We are 2 people in this pr...
I'm seeking an experienced website designer to create an e-commerce platform for my business. This platform will serve to highlight and sell our range of products, and we expect to list between 100 and 500 individual items. Key Project Elements: - An intuitive and attractive product listing and description feature, ensuring our customers can easily browse and understand our offerings. - A user-friendly and secure shopping system, giving clients confidence in their purchases. Ideal Skills Required: - Experience in web design, ideally with a portfolio of e-commerce sites. - Knowledge of SEO best practices to optimize product visibility. - Strong graphic design ability to ensure the site is visually appealing. - Experience in creating user-friendly interfaces for easy navigation...
...and store the precise location of the driver when a photo is taken. - Date and time stamping: Each photo taken should be automatically stamped with the current date and time. - Picture capture functionality: The app should provide an intuitive and user-friendly interface for capturing images. It is crucial that the app also includes a secondary functionality for flight tracking. The app should be able to link to flight schedules, write the time and date of a passenger's landing, and store it for the driver to ensure the accuracy of the pick-up time. The skills required for this job include: - Strong experience in app development, particularly in location-based services. - Proficiency in integrating GPS services, date and time functions, and camera fun...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
We are seeking a motivated and enthusiastic SEO Intern to join our team. This is an excellent opportunity for someone who is passionate about digital marketing and eager to gain hands-on experience in search engine optimization. Respo...keyword research and analysis to identify new opportunities for content optimization Help optimize website content, including writing meta tags, meta descriptions, and optimizing on-page elements Support link building efforts by researching and identifying potential link opportunities Monitor and report on website performance using tools such as Google Analytics and Google Search Console Stay up-to-date with the latest trends and best practices in SEO and digital marketing Collaborate with team members on various SEO initiatives and projects Qualifi...
I'm looking for a professional to assist with the creation of a YouTube channel focused on insurance. The main aim of this channel is to educate the viewers about various aspects of insurance, particularly annuity and Medicare. Key responsibilities include: - Creating engaging, informative video content related to annuity and Medicare. - Ensuring that the content is accurate, up-to-date, and easy to understand for laymen. - Suggesting creative ideas and strategies for content diversification. Ideal candidates should have: - Prior experience in creating content on insurance topics. - An understanding of annuity and Medicare. - Excellent video editing skills to ensure high-quality output. - Strong communication and collaboration skills to work with me in creating a channel tha...
My WordPress website is redirecting to unknown sites and showing signs of injected Javascript. I've experienced this issue despite keeping my WordPress and plugins up to date. Key Requirements: - Identify the malware and its entry point - Remove all malware and traces of injected Javascript - Restore website to its original, clean state - Provide recommendations to prevent future attacks I have full access to my website's hosting environment. Ideal candidates should have proven experience in malware removal for WordPress sites and possess a strong understanding of web security best practices. Please share your approach and experience in your bid.
I am currently in need of comprehensive, multi-faceted telemedicine services to significantly enhance the accessibility, convenience, and cost-effectiveness of heal...cost-effectiveness of healthcare. Ideal candidates or companies for this project would possess: - Proven experience in the telemedicine field. - Examples of past work. - Detailed proposal showcasing their proposed approach to the project. Though the answers to what specific type of telemedicine service I'm looking for remain unanswered, a proficient provider should be equipped to offer a broad range of services, particularly in the following areas: - Virtual consultations - Remote patient monitoring - Diagnostic services Telehealth in New York. Must have providers onboard and has to be ...
I'm in need of a virtual assistant to support me with a range of tasks related to real estate and administration. Can work from 12pm spanish time. Ideally from ARGENTINA or an equivalent/closer time zone to Spain. English level: Upper intermediate or higher. Spanish level: Advanced or higher. Key responsibilities include: - Managing my inbox and responding to emails - Handling various administrative tasks - Conducting research on different topics - Organizing information in Excel - Scheduling appointments and managing my calendar The ideal candidate should: - Be able to dedicate between 10-20 hours per week to this role. - You can make calls and videocalls and mantain fluid communication. - Possess strong organizational and time management skills. - Have a backgroun...
I'm a painter, interior and fashion designer with a substantial following on Instagram. While my Content Quality is appreciated, I'm looking for a professional who can boost my Engagement Rate. The primary focus of this project is to bring my followers closer to my content, and ensure that they are actively engaging with it. This will involve implementing a range of engagement strategies that are both interactive and interesting. Key Requirements: - Proven experience in increasing Instagram Engagement Rates and followers - A good understanding of art and design and its audience on Instagram - Creative and thoughtful approach to interaction and storytelling - Ability to work with me to develop strategies that match my style and goals While I haven't selected specif...
...Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has be...
I urgently require a web scraper proficient in extracting data from xing.de. I will provide a file of specific company names, for which I want to obtain the number of employees. Your task will involve: - Gathering accurate and up-to-date data on the number of employees for each company on the list - Formatting the information suitably for my usability. You need to have proven experience in web scraping, particularly on professional platforms such as Xing. Familiarity with German language platforms is beneficial. The deliverable is a neatly formatted file containing company names and their respective employee numbers.
I am looking for a skilled Android developer who can create an engaging, robust, and seamless B2B ecommerce application for my cement manufacturing unit. Key Features: - Product Catalog: The app should showcase our comprehensive range of products for easy browsing and selection. - Order Management: A seamless and user-friendly system is required for order placement, tracking, and confirmation. - Inventory Tracking: Real-time updating of inventory for an optimal supply chain management. - SAP Integration: Capability to integrate with our current SAP system for streamlined business operations. - Order Splitting: An option to divide order in case of large demand. - Truck Ordering: Enable easy booking and scheduling for transporting bulk orders. User Role: The app should be built p...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script to send the smaller ...
