Data analysis with excel pivot tablesроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm looking to collaborate with a skilled freelancer to develop a comprehensive online module on research methodology. This module is aimed at non-clinical staff and graduate students who are beginners in the field of research methodology. Key Objectives: - Develop a module consisting of 5 to 10 engaging lectures - Covering key topics such as Introduction to Research Methodology, Data Collection Methods, Data Analysis Techniques, Basic Statistics, and Writing Manuscripts for Publication - Ensure the content is beginner-friendly Ideal Skills and Experience: - Experience in developing educational content or courses in the field of research methodology - Strong understanding of research methodology and the ability to simplify complex concepts for beginners -...
I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.
...design and implement a two-axis machine control system that is capable of: - Effectively controlling and managing the movements of the system along two axes with a LIMITED RANGE. Your expertise in designing systems with the necessary navigation strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-off, NEMA 23 stepper motor mov...
I am seeking a proficient Revit and AUTOCAD and ETABS. Looking forward to working with you. Thank you.
I require a professi...following: - Ensuring the entire document is formatted consistently for a professional and cohesive look. This includes font, headings, and spacing. - Creating and formatting a Table of Contents - Setting up headings and subheadings in the document according to the specified style. - Ensuring font, spaces and tables are properly formatted ensuring a professional look. The preferred formatting details are as follows: - Font: 12pt Times New Roman - Headings and Subheadings: Italicized with the same font size Ideal candidates for this job should have: - Solid experience in formatting academic or scientific documents. - Proficiency in Microsoft Word, including advanced knowledge of style and formatting tools. - Strong attention to detail and ability to ...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking a professional with expertise in sound and vibration analysis to assist me with various tasks in this area. The specifics are as follows: - The tasks will include both noise and vibration analysis. - You'll be required to utilize advanced analytical techniques to solve problems related to sound and vibration. Ideal candidates should have: - Proven experience in Sound and vibration analysis. - Strong knowledge of analytical techniques and tools within this field. - Excellent problem-solving skills and the ability to work This is a great opportunity to work with a client who values expertise and professionalism in sound and vibration analysis. one day deadline
I ordered a 16’ x 24’ storage shed from Heartland Sheds company, but they could not install it due to my steep slope here. But I already submitted my permit request for it and it was approved. The contractor who supposed to assemble the shed on site suggested to build a cinder block foundation than he could put the shed on it. I did that, but now the building inspector wants me to get an Appendix G form filled out and stamped by a PE to verify the footer and foundation meets NC building codes. Luckily I have plenty of photos and receipts documenting the entire project from excavation to finish. I offer $1,000.00 to get the job done.
...skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task will be to fetch data, analyze it...
I am seeking a YouTube analytics expert to help improve the watch time analytics of my channel. Key Responsibilities: - Analyze current watch time patterns and identify areas for improvement - Provide recommendations to boost...recommendations to boost viewer engagement and retention - Suggest strategies to enhance the overall analytics of my channel Ideal Candidate: - Proven experience in improving watch time analytics on YouTube - Strong understanding of viewer behavior and engagement on the platform - Excellent data analysis skills - Up-to-date knowledge of YouTube algorithms and best practices - Experience in the entertainment content industry would be a plus Please note, I am looking for someone who can not only analyze the data but also provide actionable str...
...experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project wit...
I have a project that involves sound and vibration analysis. Key Requirements: - Assistance with sound and vibration analysis - Conducting vibration analysis, specifically focusing on frequency response, more details in the file below Ideal Skills and Experience: - Proficiency in MATLAB - Experience in sound and vibration analysis - Strong understanding of frequency response analysis - Excellent technical writing skills for the preparation of a detailed report. Your primary responsibility will be to help me in analyzing sound and vibration and preparing a written report on your findings. It is important that you have a good grasp of MATLAB and previous experience in similar tasks.
I'm looking for a skilled freelancer with prior experience in data scraping to help me extract specific text content and URLs from a public site. Key Details: - Your main task will be to collect the text content and URLs from the site. - Previous experience in a similar project is a must. - Please provide me with details regarding your experience in your application. The purpose of this data scraping project is for market analysis.
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗...
...we can start with open source articles as a start. the articles will be published after translating them into arabic in a website and then they will be available to read for free, but for downloading the pdf file of the translated article, readers will need to register an account. Service is free of charge. a demo website will be available soon for more calrity. Key Components: - Market Analysis and Strategy: The plan should include an in-depth market analysis and outline our strategic approach to reaching and engaging our target audience. - Operational Plan and Technology Requirements: You'll need to detail the operational structure, technology stack, and any other technical prerequisites. - Financial Projections and Funding Needs: I’m looking for a det...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performanc...
I'm in search of a skilled data analyst with expertise in health and medicine for a comprehensive meta-analysis project - Focusing on the health and medicine subject area - Including data sources from peer-reviewed journals - Presenting the results in graphical charts, statistical tables, and a narrative summary Ideally, you should have experience in: - Meta-analysis, especially within the health and medicine domain - Working with various data sources, particularly from peer-reviewed journals - Proficiency in creating and interpreting graphical charts and statistical tables - Crafting a concise and informative narrative summary from the analysis This project requires attention to detail, critical thinking, and t...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
...design and implement a two-axis machine control system that is capable of: - Effectively controlling and managing the movements of the system along two axes with a LIMITED RANGE. Your expertise in designing systems with the necessary navigation strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-off, NEMA 23 stepper motor mov...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I need a comprehensive analysis of the youth demographics including the religious inclinations within my nonprofit area. Key areas of focus should be: - Demographic Breakdown: This includes age, gender, and ethnicity of the young people in the area. - Church Attendance/Religion Stats: Quantify the religious tendencies, including the specific denominations if applicable, and frequency of church attendance. The purpose of this analysis is threefold: - Target Audience Identification: Understanding who the majority of young persons in my area are, allowing better tailoring of our outreach programs. - Community Needs Assessment: Identifying specific needs within the young demographic based on their religious and societal norms. - Outreach Program Planning: The data w...
I'm seeking an experienced professional to develop a comprehensive and effective Confidential Information Memorandum (CIM) for my technology business. This document will be a key tool in t...engaging manner to showcase the company's financial health and growth potential. - M&A Understanding: A solid understanding of mergers and acquisitions is crucial, as the CIM needs to be structured in a way that aligns with the expectations of potential buyers. Ideal Skills: - Proven experience in preparing CIMs, especially for technology companies. - Strong financial analysis and projection skills. - Excellent written communication and presentation abilities. - Understanding of the M&A process and dynamics. - Ability to work with confidential information and adh...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
...space. - Competitor Analysis: While the primary focus is on Talens, it will be valuable to understand how other brands like Nike, Adidas, and Apple are being displayed in the retail outlets. - Customer Behavior: I'm particularly interested in how the retail displays are shaping customer behavior and purchase decisions. Ideal candidates should have a background in visual merchandising, market research, or a related field. Specific qualifications include: - Proven track record in conducting retail research, especially within the Chinese market. - Strong analytical skills to interpret the data and provide meaningful insights. - Familiarity with art supply brands and the retail industry would be beneficial. The output of this project will be a detail...
I'm seeking an expert to analyze a key aspect of my HR paper from journal with title Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Research context Methodology with results Discussion Overview Critique and significance of the paper the outcome is report and power point slides the due date is 22-5-2024
I'm in need of a skilled professional who can produce a high-quality case study report focusing on marketing strategies within the retail industry. Key Deliverables: - Thorough Analysis: The case study should delve into various effective marketing strategies within the retail sector, potentially highlighting particular successes and failures. - Practical Recommendations: Based on the case study's findings, the report should provide actionable recommendations for developing appropriate marketing strategies in the industry. Ideal Skills and Experience: - Proven Experience in Case Study Writing: You should have a strong track record of creating engaging and insightful case studies. - Retail Marketing Expertise: A deep understanding of the retail sector and its marketing dyn...
...company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data...
As part of my endeavor to secure my systems, I am seeking an ethical hacker to primarily focus on data security. By extensively exploring the potential weaknesses and vulnerabilities, your primary goal will be to prevent unauthorized access. Here's what I require: * In-depth evaluation and analysis of our data security framework * Identification of any potential vulnerabilities and security loopholes * Devise strategies to fortify the data security dimensions against malicious hackers The ideal candidate should possess: * Extensive experience in ethical hacking and data security * Strong analytical skills and a keen eye for spotting weaknesses and vulnerabilities in data security * Ability to devise actionable strategies to address the ...
...main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer with a solid understanding of data analysis...
I'm seeking a skilled and experienced individual to craft a concise and compelling pitch deck. The purpose of this pitch deck is to secure funding for my project. Key Sections: - Market Analysis: You'll need to conduct comprehensive market research and present it in a succinct, engaging way. - Business Model: I need a clear, concise explanation of how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my proj...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
...mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selected solutions CAD Modeling of a Mechanism Estimated Time: 8 hours Evaluation Criteria: General appearance and manufacturability of parts Quality and cleanliness of part modeling and construction trees Accurate assembly definition and kinematic mobility Definition of stops for ...
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
...specifically on Google. My site is dedicated to selling virtual goods for Final Fantasy XI, and I'm looking to enhance visibility and draw in more potential customers. Key Responsibilities: - Conduct a thorough analysis of my website's current SEO situation, pinpointing areas for improvement. - Implement effective SEO strategies to boost my site's ranking on Google. - Optimize keywords and meta tags. - Rectify existing SEO errors, broken links, and other issues that might be hindering my site's visibility. The ideal candidate will have: - Proven experience in SEO, particularly with e-commerce sites. - Expertise in Google SEO strategies. - Strong knowledge of keyword and meta tag optimization. - A keen eye for identifying and rectifying SEO errors and ...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of th...
I'm seeking a skilled content writer to craft a detailed and informative article about coffee tables. The piece should be around 1,200 to 1,500 words and cover various aspects of coffee tables, including their history, different styles and designs, and material options. Moreover, I need the article to highlight the distinctions between residential and commercial coffee tables. Key points to consider: - Research and include the origin and history of coffee tables - Discuss popular styles and designs in the contemporary market - Elaborate on the differences between residential and commercial coffee table considerations - Write in a style that's accessible and engaging for a general audience - Must contain 3 to 5 links as references within the article, t...
We are seeking a highly skilled and motivated Google Ads and Facebook Ads Specialist to join our dynamic marketing team. The ideal candi...(Search, Display, YouTube) and Facebook Ads (Feed, Stories, Audience Network). Utilize advanced targeting techniques, including demographic, behavioral, and geographic targeting. Optimization and Analysis: Monitor and analyze campaign performance data to identify trends and insights. Perform A/B testing to continually refine ad copy, creatives, and targeting strategies. Optimize campaigns to maximize ROI, reduce cost per lead (CPL), and achieve the highest possible lead quality. Budget Management: Manage and allocate advertising budgets effectively across various campaigns. Ensure spending aligns with the overall marketing budget ...
...and Community Building: -Engage with followers and respond to comments and messages. -Organize and manage giveaways for followers Research and Analysis: -Conduct research on digital beauty trends and skincare ingredients. -Monitor and report on social media analytics to measure the impact and adjust strategies accordingly. -Shopify Management: -Update and manage product listings on Shopify. -Assist with order processing and customer inquiries. Requirements: -Proven experience as a Virtual Assistant or relevant role. -Proficiency in using ChatGPT for content creation and customer engagement. -Strong knowledge of Shopify and its functionalities. -Excellent research skills and the ability to stay up-to-date with industry trends. -Exceptional copywriting skills...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I'm in need of a generative artificial intelligence that can analyze given text inputs and provide suggestions based on the analysis. The main purpose of this AI would be for data analysis. Key Requirements: - The AI should be primarily text-based. - It should be able to process and analyze the supplied text. - The output should be suggestions derived from the analysis. Ideal Skills and Experience: - Previous experience in developing generative AI systems. - Proficiency in natural language processing and data analysis. - Strong understanding of machine learning algorithms.
I need a Java or python3 programmer to create a sensor-data generator for the website www.voeazul.com.br. The objective is to send a POST request to the site with valid sensor-data in order to obtain a particular cookie (_abck) for data analysis purposes. The sensor data to be simulated includes mouse movements, keyboard interactions, and browser interactions. Key Requirements: - Create a sensor-data generator in Java or python3 - The generator should simulate mouse movements, keyboard interactions, and browser interactions - The sensor-data should be valid enough to trigger the generation of the _abck cookie upon sending a POST request to Ideal Skills and Experience: - Proficiency in Java/python3 programming - Experience in web ...
I'm looking for a detailed and engaging article that introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words, and provide a mix of information and benefits that really sells the concept of these tables. Key Points to Cover: - Introduction to different types of large conference tables available in the market - Factors to consider when choosing the right large conference table - Benefits and advantages of utilizing large conference tables in a professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be professiona...
I'm seeking a skilled writer to draft an informative article about round conference tables. The piece will be aimed at a general audience, therefore, it's imperative that the content is engaging and easy to understand. Key Points: - The primary focus should be on educating readers about the unique benefits and features of round conference tables. - The article should highlight the distinctive qualities of round tables in comparison to other shapes, particularly emphasizing how these tables promote communication and collaboration, and their versatility in seating arrangements. - Article should be between 1,000 to 1,200 words - Article needs to contain 3 to 5 references to certain websites, which will be provided upon awarding of the project Ideal Ski...
