Global sum multiple tabs excelpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Two years ago, I had a plugin created to calculate the price of pencil printing. After updating the woocommerce, my files were probably overwritten - the price with the print on the product page, in the cart and others is not displayed. You will need a good knowledge of the core of woocommerce and programming ...woocommerce and programming Link for example : input quantity 100 - select "potisk předmětu - online kalkulačka" click "zvolte technologii" select "tamponový tisk" click "Upřesněte technologii" select "jednobarevný potisk" click vypočítat cenu potisku ... now see only NaN Kč... Nan - It should be the sum of the price of the products + the price of the print Multiple files need to be modif...
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
****Please read brief **** Multiple Language E commerce site (Czech, German, English, Polish) We will provide the translations Hello, I'm looking to extend my website (WordPress) and introduce an effective SEO friendly online store. We aim to create the online store under our current domain and server. We will accept cash upon delivery within a specific area, we will also accept bank transfer, Paypal, Google Wallet and Stripe payments. This E commerce site will need to be integrated into our WordPress theme (Avada). There is 6 food products we will sell online (not much) We have already purchased WPML and its associated plugins that can offer multiple languages. I am looking for an experienced professional to do this job. Please read this brief b...
Storecheckers are a Global Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits and audits. This assignment is an audit of an Examination Centre, checking that the security standards are being met. You MUST HAVE fluent English skills, and you must be able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we ...
Storecheckers are a Global Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits and audits. This assignment is an audit of an Examination Centre, checking that the security standards are being met. You MUST HAVE fluent English skills, and you must be able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we ...
Storecheckers are a Global Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits and audits. This assignment is an audit of an Examination Centre, checking that the security standards are being met. You MUST HAVE fluent English skills, and you must be able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself is very simple and easy, as we ...
...development - This involves creating a secure and efficient server-side system. Proficiency in Node Js or any suitable scripting language is crucial. * Database integration - You will be tasked with integrating MongoDB into the project. Knowledge and experience in MongoDB use is required. Specific features to be added include: * Real-time multiplayer - This includes facilitating and managing multiple number of games simultaneously. Experience in creating real-time applications with WebSocket or similar technologies is desired. * AI opponent - Should have experience in creating a sophisticated AI system capable of playing chess at various difficulty levels. * Leaderboard tracking - Require experience in creating and managing a leaderboard system that tracks players’ progre...
I'm in need of purchasing a bulk of 4 verified AWS ac...confirmed and verified. - Each account should possess a total of 500 VCPUs. - Experience in dealing with and procuring bulk AWS accounts is a plus. - Prior knowledge of managing and organizing AWS resources in multiple accounts. Additional Details: - I'm not looking for a new account to be created; rather, I seek pre-existing and ready-to-use accounts. - These accounts should be solely intended for the project separation, and the transition should be seamless and non-disruptive. Ideal Candidate: - Experienced in AWS account management. - Proficient in separating and securing multiple projects on AWS. - Reliable and capable of providing verified AWS accounts in bulk. - Good communication skills to ensure sm...
I'm in need of a highly talented and adaptable video editor who can expertly handle a variety of editing tasks. Due to the undefined nature of the video content, all applicants are required to be proficient in editing videos across multiple genres, from corporate to travel to wedding videos. Skills and qualifications: - Extensive experience in video editing - Proficient in video editing software - Demonstrated ability to edit videos in multiple genres - Precision, attention to detail, and creativity To be deemed successful, freelancers should include in their application: - Portfolio of previous work including but not limited to corporate, travel, and wedding videos. - Relevant experiences related to video editing. - Detailed proposal highlighting how you plan to meet ...
...your approach. Each paragraph within the blog should have a clear topic sentence, body, and conclusion with transitions to move from one idea to the next. You will complete a rough draft and a final draft for this assessment. Content: You should focus on the information that you think would be most useful to students. You have two options: You can go for breadth, by including material from multiple topics (weeks) covered in the class; OR You can go for depth and include only material from 1 specific topic covered in the class. To demonstrate originality, include information from at least three sources shared with you within this course or the course you choose to highlight in your blog. You may use any assigned course readings or material shared with you by your instructor....
...or similar certification preferred. • Minimum of 5 years of accounting experience, particularly in a corporate setting. • Strong understanding of GAAP and financial reporting. • Proficient in accounting software (e.g., Xero, QuickBooks, SAP, Oracle). • Excellent analytical, problem-solving, and decision-making skills. • Strong attention to detail and ability to prioritize and manage multiple tasks. • Excellent communication and interpersonal skills. Benefits: • Competitive salary and comprehensive benefits • Opportunities for professional development and career advancement. • Flexible work hours and remote work available. • Supportive team environment and leadership committed to your professional growth. ...
...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 Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Mark...
...**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:** - **Organizational Ability:** Demonstrated proficiency in managing multiple tasks efficiently. - **Attention to Detail:** Accurate entry of product data, understanding of the importance of precise information. - **Communication:** Clear and responsive communication, especially regarding updates or any challenges faced during the task. - **Local Knowledge:** Familiarity with retail stores that potentially stock the specified soft drink brand would be advant...
...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 ...
...**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:** - **Organizational Ability:** Demonstrated proficiency in managing multiple tasks efficiently. - **Attention to Detail:** Accurate entry of product data, understanding of the importance of precise information. - **Communication:** Clear and responsive communication, especially regarding updates or any challenges faced during the task. - **Local Knowledge:** Familiarity with retail stores that potentially stock the specified soft drink brand would be advanta...
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'm in need of an experienced web developer to create an interactive multiple choice exam website. This platform is intended to be a valuable resource for both educators and students alike. Key Features: - Support for multiple choice exams: The website should allow for the easy creation and administration of multiple choice tests. - User accounts: The website will require user accounts for exam takers. These should be simple and easy to create, but also secure. - Comprehensive dashboard: Both users and admins should have access to a comprehensive dashboard for tracking user progress and other key performance metrics. Ideal Skills: - Proficiency in web development, particularly with creating interactive websites - Experience with user account management and au...
...should have a capacity above 150 kW. We have multiple sites across the US where we need designs. Key requirements: - Design a DC Fast EV Charging Station: The project calls for a full-fledged design of a DC Fast EV Charging Station. - Adaptation for urban areas and commercial properties: The station should be optimized for city settings as well as businesses. - High capacity: The charging station must support charging above 150 kW. Ideal skills for this project include: - Experience with EV charging station design - Knowledge of urban and commercial design requirements - Understanding of high capacity electrical systems - Proficiency in relevant design software - Certified engineer who can sign and stamp documents for submission in multiple states If you have a backg...
I'm looking for a developer with in-depth experience in creating smart contracts on the Ethereum blockchain. Key Requirements: - Develop a multisend smart contract that supports ERC20 tokens. The contract should allow for the distribution of ERC20 tokens to multiple recipients in a single transaction. - Implement pause functionality as a security feature. This is crucial to protect the contract from any potential vulnerabilities or attacks. - We would like to be able to interact with the contract if possible (on etherscan) Ideal skills and experience: - Proficiency in Solidity, the programming language used for Ethereum smart contracts. - Prior experience in developing multisend contracts and incorporating pause functionality. - Knowledge of best practices for smart contrac...
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.
I'm seeking a Customer implementation go-live implementation manager Need a very strong customer focused project manager skills Work with the business and customer teams managing multiple streams of work for a project implementation go-live Gap analysis on application deployment V implementation deployment Highly pressured deadline, with lots of client focus
I need an expert to help me select the most suitable all in 1 programming language for building various applications targeting multiple platforms (mainly web) 1. I would like to build applications for Web, iOS, Android, Windows 10, Linux, and MacOS & embedded systems (like micro controllers) from single code base 2. I want to learn a language in which we write a code once and can compile for any platform. 3. One possible answer to my questions is JavaScript. We can build server side apps in JS using Node.js & Next.js. Javascript can be embedded in HTML on client side too. We can build desktop apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Da...
...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 APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
I'm in search of a multiple Remote Assistants to search and apply to internship opportunities for me and multiple friends. The successful candidate will be primarily tasked with searching various internship opportunities and subsequently submitting the applications. The main responsibilities will be: - Finding eligible internship opportunities from job boards given specified requirements (ex. "Summer 2024 Software Internship) - Submitting applications to said opportunities given a resume and some info You will get paid $2.5 for every 100 internships you apply with us (no negotiation), and there are a huge amount of internships available for you to apply and make money. If you are interesting in working for me, PLEASE SEND ME A CHAT MESSAGE with the earliest time ...
I have an Excel sheet with construction project data that I'd like to convert into a Power BI report. This sheet includes data from various projects of different types in a mix-use development setting. Key requirements: - Convert the Excel sheet data to a visually appealing and informative Power BI report - Create a Power BI report that can be easily updated with new data and link with Excel sheets - Ensure the report is user-friendly and can be navigated easily - Internal Links within Power BI to enhance user interaction Ideal skills and experience: - Proficient in Power BI, with a portfolio that showcases similar projects - Experience in working with construction project data, preferably mix-use developments - Excellent data visualization and report creatio...
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis&...
I'm looking for a data expert to merge two sets of 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 iden...
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis&...
...enhancing my inventory management. It's vital to underscore that my priority area is improving the SEO of my product listings - a mission-critical aspect of gaining visibility amongst the plethora of products on Amazon. Key Focus Areas: 1. **High-Quality Product Imaging:** A picture is worth a thousand words and, in the ecommerce space, it's worth more. The images should be sharp, well lit and from multiple angles to provide a comprehensive view of the product. 2. **Detailed Product Descriptions:** The descriptions need to be comprehensive and compelling, highlighting the key features and benefits of the product while simultaneously being SEO-friendly. 3. **Accurate Product Specifications:** The specifications need to be 100% accurate, eliminating any potential for c...
...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 pages of t...
I'm looking for an experienced cold caller who can efficiently make appointment setting calls on a global scale. The ideal candidate must have: - Proven track record in cold calling and appointment setting - Understanding and experience in dealing with international markets - Sound knowledge of the online products industry The main responsibilities include: - Identifying and targeting global potential leads - Making effective cold calls to these international prospects - Successfully setting appointments with these leads Skills and Experience required: * Cold calling experience * Excellent communication skills * Knowledge of the online product market. Your hard work will broaden our global presence and help us venture successfully into new markets.
...candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: - 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. To excel in this role, you'll need to work approximately 6 hours a day, 6 days a week. This schedule is designed to ensure continuity in my operations while allowing flexibility for you. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and Po...
I'm in need of a skilled developer to create a robust CodeIgniter module that integrates with multiple APIs. The main purpose of this module is to enable seamless communication with various services including calling contact, Google Meet, SMS, and Email. Key Details: - The module should include a custom API integration for calls, Google Meet, SMS, and Email. - For contact calls, the primary functionality required is a 'Click to call' API. This should allow users to conveniently initiate calls directly from within the system. Skills and expertise that are required for this job include: - Proficiency in CodeIgniter and understanding of MVC framework. - Prior experience in integrating APIs, preferably for contact calls, Google Meet, SMS, and Email. - A solid grasp of...
I'm looking for a creative and experienced video creator who can produce a 8-12 minute Youtube video. The video will be aimed at a general audience, so it should be engaging and accessible for all ages. The main content of the video will be Bible quizzes, consisting of multiple choice questions. Skills and experience in the following areas are desired: - Video editing - Scriptwriting - Creating engaging and informative content for a general audience The ideal freelancer for this project will be able to produce a high-quality, professional video that is both entertaining and educational. Provide direct links to your work related to his project. !No links - no consideration and project will be removed from bids. Please don't ask me to search your website for work. I...
I'm in need of a creative and professional logo design fo...Business Name: Precision Pro Mobile Detailing - Preferred Color Scheme: Blue and Silver (any other if looks good) - Desired Elements: Car Silhouette and Water Droplets Ideal Skills and Experience: - Proficient in graphic design and logo creation - Experience in creating professional and eye-catching logos - Understanding of color psychology and its application in branding - Ability to incorporate multiple elements seamlessly - Strong communication skills to understand and implement feedback Please provide a portfolio of your previous works, particularly any related to the automotive or service industry. I'm looking for a logo that's not only visually appealing but also reflects the precision and quality tha...
We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, C...
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
I have a need for a professional with experience in Google Maps data management. My project involves: - Inserting 'Website' infor...entry to several destination points on Google Maps. - Regularly updating this information directly on the Google Maps platform. This position is well suited for someone with: - Practical knowledge and experience in handling Google Maps data. - Attention to detail and commitment to maintain accurate, up-to-date information. - Ability to manage bulk data and ensure information consistency across multiple destinations. Please note: This job does not involve any work on existing websites or website integration. We only need to add and maintain data directly on the Google Maps platform. *We pay when we check after 10 days the approved website...
...Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that supports efficient data aggregation and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop a...
...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 the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
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.
