Count command in excelроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
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.
...This links the outer carton barcode with the Qr code - Each scanned QR code will be recorded in the database along with the timestamp. - The application will maintain a count of how many times each unique QR code is scanned. 2. Barcode Scanning (Y Person): - Y person will have the ability to scan barcodes of outer cartons using their mobile device's camera. - Each scanned barcode will be linked with the corresponding QR code in the database. - The application will generate reports based on the QR codes linked with the scanned barcodes, providing insights into the frequency of scans for each QR code. 4. Reporting: - The application will generate reports that display: - Total count of scans for each unique QR code. - Frequency o...
I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Feature Integration: The first task involves adding a basket feature to the site. The feature should incorporate the ability to both add and subtract items, and should clearly display the total cost of the items in the basket. Additionally, the basket should be designed to support Stripe payment integration so when when paying total cost will be on stripe showing the products. - Registration Redirection Fix: The second task is addressing a critical issue with the registration process. Currently, upon successful registration, the user remains on the registration page. This is not the intended behavior, and I need a solu...
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.
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...
I am seeking a native German speaker to act as a virtual sales agent. The project involves - Promoting and selling a variety of services to a German-speaking audience - Operating on a virtual platform - Translation or localization of conten...virtual sales agent. The project involves - Promoting and selling a variety of services to a German-speaking audience - Operating on a virtual platform - Translation or localization of content may be necessary The ideal candidate will have a strong sales background, be fluent in German, and have room for flexibility in terms of services sold. Fields of work could include (but are not limited to) insurance, real estate or retail products. Proficiency in English would also be beneficial, but primarily, a strong command o...
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.
...perfect command of CAD or similar software. The idea would be to have facade plans with and without the concrete blocks I attach what we expect in the design (we must include the lintel (20 cm high), but below that there is the formwork of the rolling shutter (30cm), the window or French window door (variable dimension) and its supports (5cm) It is not necessary to include the window or the doors sill but simply take their dimensions into consideration when creating the plan. I simply want a masonry plan with the lintels and formwork for the roller shutters, as well as the empty space for the joinery, but we also have to add 1.5 extra cm on each side for the windows. so if a window is 140 cm wide it must be sized at 143 cm. All dimensions should be in plans Pleas...
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.
...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 wi...
I'm looking for a freelancer to develop a company profile for my business, with a primary focus on . The profile should be in PDF format and written in English. "Rqeem Valuation & Consulting is a certified entity by TAQEEM for providing business as well as machinery & equipment valuations for different purposes such as M&A transactions, internal decision making, litigation, and financial reporting. As a member of the Saudi Authority for Accredited Valuers (Taqeem), our enduring leadership, collaboration, and focus on anticipating what the future looks like for our clients has positioned us as a trusted partner in the industry." Key Requirements: - The company profile should be compelling, engaging, and concise, tailored to attract potential ...
...freelancer to create a non-fiction audiobook of approximately 3 hours in length (33,000 words), intended for an adult audience. The book is about my journey to healing from cancer (see attached book cover). I need someone that can deliver with soft authority in an upbeat, but empathetic tone and convey a message to the reader of HOPE with a positive 'you can do this attitude' behind your voice. Your role will involve: - Producing a clear, engaging audio narration of the book. - Assisting in promoting the audiobook to reach an optimum audience. (If you are a vocalist, but not a promoter or vice versa I may decide to split this into two roles, as needed.) Requirements: - Proven experience in audiobook narration, particularly in the non-ficti...
I'm in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses 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 PowerPoi...
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 Day...
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 me...
I need an expert to work on my English and Psychology projects. Both projects involve a degree of proofreading and editing tasks. The English project focuses on scientific literature, re...editing tasks. The English project focuses on scientific literature, requiring specific attention. Key Responsibilities: - Fine-tune the coherence and flow of the English project - Bring psychological insight into the editing process for the Psychology project Ideal Skills: - Proofreading and editing expertise - Sound knowledge of scientific literature - Background in Psychology preferred - Excellent English Grammar and Syntax command - Attention to detail and accuracy Your role will be primarily to ensure my projects' content is polished, and all psychological assertions are accura...
I am currently experiencing several issues with my Flutter project and urgently require skilled assistance. The primary problems include persistent build errors and several UI layout issues. Ideally, the chosen candidate will be proficient in working with the Flutter framework, experienced in solving similar issues, and familiar with both Android and iOS development. • Build Errors: My project has been spawning various build errors that hinder the execution of the application. The freelancer is expected to help identify and rectify these errors. • UI Layout Problems: There are also vital concerns with the user interface layout. Some pages don't render correctly on different screen sizes, and the general responsiveness of the UI is inconsistent. The task woul...
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
I am seeking an experienced academic editor to thoroughly review and revise my social work PhD dissertation. The word count exceeds 25,000 words, so meticulous attention to detail is crucial. Key Tasks: - Detailed editing and restructuring where necessary - Intensive focus on the Literature Review section - Maintain proper academic formatting and citation style Ideal Freelancer: - Previous experience in academic editing, particularly dissertations - Familiarity with social work or similar disciplines - Exceptional proficiency in English and academic writing conventions Needless to say, respectful handling of sensitive research content is expected, along with maintaining the confidentiality of the work shared.
...Bootloader with the Metro theme. This is a technically demanding task requiring the following: - Profound knowledge in Operating System installations. - Expert ability to setup multiboot configurations. - Experience with the Burg Bootloader is highly desirable. - Familiarity with the Metro theme. The purpose of the multiboot configuration is to provide a platform where I can experiment with different operating systems. Please ensure the optimal setup is achieved such that I can independently manage the system with ease. Your experience with setting up multiboot machines will be key to the project's success. Please note, while I have some prior experience with multiboot machines, I count on you to provide expert guidance throughout the process. Your patience and ...
I'm urgently in need of a technical artist who possesses an exceptional command of Maya, Blender, and 3ds Max. Your responsibilities would primarily include: - Conceptualising and developing models for 3D printing - Leveraging your expertise in the mentioned tools to deliver top-grade, perfectly crafted models The project commences ASAP, so time-crucial delivery is key. Proficiency in modeling is a prerequisite while experience in conceptualisation for 3D printing would greatly count in your favor. I look forward to your swift responses and potential working partnership.
I'm seeking a seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or 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 ...
Perform an in-depth sensitivity analysis of a Pressure Swing Adsorption (PSA) process for CO2 capture using zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. 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 an...
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 ...
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
We need a freelancer to carry out a simple task. It is about verifying that a shipment matches against a packing list. The Freelancer must go to the factory or warehouse where the shipment is located, count the products and take photos according to a manual that we will send; stay in the factory or warehouse until the containers are filled out and take pictures of the loading process according to the manual we would provide
Need a solution A barcode app to print and track our inventory. (Barcode&QR desirable)Online - Webbased. ProductCode/SupplierCode/Category/SubCategory/Batch/Colour/Siz...inventory. (Barcode&QR desirable)Online - Webbased. ProductCode/SupplierCode/Category/SubCategory/Batch/Colour/Size/Expiry/Selling PriceA/X/X/X/X/X/XX/XX/XXXX/XXXXXX.00Item description must print on the lable More details: We wish to use this app to count our inventory using bar code scanners Also when items are placed in a box to transfer between two shops, we need it to be able to use the scanner and count accuracy. Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Experience How soon d...
I need a proficient Gujarati speaker who is also adept at data entry. This task involves posting content on a website, specifically lyrics. The timeframe for completion is flexible. The ideal candidate should have: - Strong command over the Gujarati language - Experience in data entry tasks - Interest in music and lyrics would be a plus - Excellent attention to detail and accuracy The key deliverables for this project are: - Accurate transposition of lyrics into the website - Ensuring all Gujarati language nuances are respected - Regular updates on the task progress and completion
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.
Job Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external A...
...data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique identifiers. - Be deta...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pag...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
As an important player in the pharmaceutical industry, we are seeking an efficient and resourceful AI/ML engineer who can harbour their expertise in enhancing our cold chain operations. The specific responsibilities will include: - Conducting meticulous data analysis and modeling - Developing precise and efficient AI algorithms - Integrating existing systems with developed ML models Our project predominantly concentrates on temperature-sensitive medications, which adds a layer of vitality to the precision and accuracy of our operations. Hence, the ideal candidate should have a background in pharmaceutical logistics or healthcare and a solid command over machine learning algorithms. With the potential of AI/ML, we aim to escalate the accuracy in the tra...
...time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CSI. That is, each sample must be modelled individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in...
I'm searching for a versatile individual to create engaging posts on my Instagram account in Romanian. Key Responsibilities: - Develop text-based posts: The posts need to be in Romanian and should be engaging, informative, and relevant to the modern lifestyle. - Create image-based posts: Visuals are crucial for this project. The images should be high-quality and match the interests of young adults and parents in Romania. - Produce video-based posts: It would be great if you can create short, interesting videos that can capture the attention of my audience. Key Objectives: - Increasing brand awareness: The content you create should help to establish my brand as a reputable and well-known entity within the Romanian market. - Promoting products/services: The posts ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attentio...
...Project Details: - Word Count: 7000-10000 words - Objective: To write an academic paper based on our proposed method and offered results Your main responsibilities for this project will include: - Crafting a comprehensive academic paper on the relationship between EEG data, Autism, and Deep Learning. - Writing a literature review that underpins our proposed method and results. - Ensuring the paper adheres to academic standards, including proper citation and referencing. Ideal Skills and Experience: - Proven track record in academic writing in the EEG data, Autism, and Deep Learning domain. - Strong understanding of academic research methodologies. - Knowledge of deep learning models and their applications in Autism research. - Experience in conductin...
...integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Ideal Skills and Experience: - Strong experience in data analysis and visualization - Proficiency in integrating data from multiple sources - Familiarity with procurement processes and KPIs If you have prior experience ...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
