Using functions in google spreadsheetdela

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

V svoje poslovanje bi radi vključili digitalni marketing in oglaševanje. Radi bi prodrli na izbrane evropske trge in tam razširili našo prepoznavnost.

need help with spreadsheet formula

I will do google sheets work as we have discussed

I need my Google document converted into a word file for unspecified reasons. While the main purpose of the conversion was not stated, it could possibly be for editing, formatting, sharing with others, or printing as a hard copy. Therefore, the successful freelancer should ideally be experienced in handling such tasks and be ready to preserve any formatting elements present in the Google document. Please include in your application any past work related to this project or a detailed project proposal showcasing your approach towards this task. Note that the conversion must preserve fonts and styles, headers and footers, and bulleted and numbered lists.

...have a Journal App built in PHP/JavaScript/Laravel which allows to enter Journal entries, country, some photos and one video of limited size, different costs etc (see ). The job is to implement the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin is there for this. Each created map should have unique link. Creator of map can embed the map in his blog, allow/disallow

I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on ...

I need a knowledgable Google Ads specialist to develop an impactful advertising campaign for my women's ethnic wear clothing brand that targets women aged 26-40. The primary goal of the campaign is to drive sales. Your expertise in creating targeted, effective adverts will be crucial in this regard. Skills & Experience: - Profound understanding of Google Ads - Past experience with fashion or clothing brands is beneficial - Proven track record of driving sales - Knowledge of targeting demographics effectively, specifically women aged 26-40.

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

Complete SPSS data analysis to test hypotheses relating to social media usage and exercise addiction. The goal is to identify and delineate trends and patterns from the data. Include a report for the results using APAstyle

...a skilled Google Ad expert to help with my Google ads. Build a online shopping site with small electronics parts retailing, ran the Google ADs for a few months from beginning(daily spending is around $10 because it's new site) however after running for a few months, the AD was suspended due to Circumventing systems policy as per Google informaton. Each time emailed Google but with with the same reply Need a Google AD expert to look at the issue and fix this issue for me. Key Responsibilities: - Analyze the current situation and provide a detailed report on the account's issues. - Provide a plan to fix the account issue and get it reinstated. - Once the account is operational again, manage and optimize the search and display ads. S...

I'm in need of a skilled Android developer who can create a dynamic betting app for me. The app should boast live betting functionality, virtual games, and seamless payment integration. Key Features: - **Live Betting**: The app should provide users with the ability to place bets on various events in real-time. This feature should have a stable and quick updating mechanism. - **Virtual Games**: Users should be able to engage in virtual games which will enhance the entertainment value of the app. - **Payment Integration**: The app should support secure and flawless payment processing. User Registration: The registration process should be user-friendly, yet secure. I envision a multi-faceted approach where users can register via: - **Email and Password**: This is...

I'm in need of an experienced developer to create a Twitter (X) TT Admin Panel with advanced functionality. The admin panel should enable: - User Management: Specifically, it needs to enable functions such as posting, retweeting, favoriting, and commenting. - Content Moderation: The system needs to robustly support content moderation. - Analytics Tracking: It should be capable of tracking analytics. - Adding users to the system (to be added from outside) Importantly, I also require the ability to schedule posts in advance. The ideal freelancer for this project should have extensive experience in admin panel development, excellent knowledge of Twitter's features and user functions, and a comprehensive understanding of analytics tracking. Mas...

I'm seeking a PPC executive with extensive experience in managing Google Ads and Facebook Ads. Key Responsibilities: - Crafting and optimizing PPC campaigns on Google Ads and Facebook Ads - Analyzing data to generate valuable insights and drive campaign success - Monitoring campaign performance and adjusting strategies as needed Ideal Skills: - Strong understanding of Google Ads and Facebook Ads platforms - Proficient in data analysis and making data-driven decisions - Strategic thinker with excellent problem-solving skills - Experience in increasing website traffic through Facebook Ads - Excellent communication and reporting skills

I have a script written in AHK for Windows. I would like this script to be rewritten for MacOS using Python. In order to ensure that the MacOS script is as close as possible to the original Windows script, the sound functionalities need to be replicated exactly. Key Skills Needed: - Proficiency in Python - Experience with MacOS scripting - Understanding of AHK (previous experience with this language would be beneficial) - Proficient in sound control within scripting The ideal candidate for this role would be someone who has a good understanding of AHK and Python, and is able to adapt the sound functionality of the AHK script to MacOS, while keeping the original features and functions of the script intact. $Numpad2:: If (toggle1) { Send {v up}...

I need a professional to enhance my WordPress website by integrating key raffle functions. The following elements are required: 1. Random Number Generator: To ensure fair raffle draws. 2. Entry Submission Form: This must collect participant's name, email address, and phone number. 3. Prize Selection Mechanism: A system to determine and announce the raffle winners. Experience with WordPress sites, understanding raffle systems, and the ability to create an intuitive submission form are key skills needed for this project. An understanding of customer data handling would be beneficial. Famely, the aim is to complete an under construction site whilst ensuring a user-friendly experience for raffle participants.

I'm looking to have a Python API built to generate a multiple-choice question bank for schoolchildren in various subjects (such as Mathematics and English) using AI APIs like ChatGPT. The API should allow for different difficulty levels for the questions. Key Requirements: Development in Python. The API should possess the following functionalities: Input Parameters: a. Users will specify the number of questions needed in one set. b. Users will indicate the topic of the questions. For example, if they want a question bank on Mathematics focusing on BODMAS, they will provide keywords like "BODMAS." Users can provide multiple keywords such as "BODMAS," "Ratio," "Percentage," etc. Similarly, for English, keywords could...

I am looking for a skilled Data Extraction/Lead Generation Specialist to assist us in compiling a list of project leads. A specific website containing the all the information we need will be provided. The task is about collecting the information and storing them into a structured Google Sheet or Excel spreadsheet of about 500-1000 entries. Please submit your proposal with your rate for the project.

I'm on the lookout for a skilled Shopify developer to construct a custom template for my upcoming e-commerce s... For you to know this is a current website with products already on offer, they will need to be adapted to fit in with the new format. - I require functionality on my product pages, including: - Customer review features - Size/color selection options - Product videos - Selection based on product type (e.g. red, black, blue) The ideal candidate for this project has a solid experience in Shopify development and a keen eye for detail. A strong understanding of the platform and its functions is a must, as are good design skills and the ability to bring creative solutions to the table. Please provide examples of similar projects you'...

...builder with a niche in affiliate tracking software integration, specifically with experience in eLitius or similar. This project is focused more towards developing functionality on the backend as opposed to the front end design. Key Website Features Needed: - Integration of Affiliate Tracking Software - Comprehensive Backend Functionality - Responsive Design that looks and functions well on all devices Website Purpose: The main goal of this website is to share information and articles, rather than selling products or services. Target Audience: The website should be designed with both individual consumers and business clients in mind. Ideal Experience/Skills: - Proven experience with eLitius, or similar affiliate tracking software - Str...

...complexity web development project. Features and functionalities include multiple integrations and more advanced functions which require strong skills in problem-solving, detail-orientation and experience with diverse web integration. While I'm uncertain of which Angular version would be ideal, I am open to suggestions from experienced developers. Therefore, a sound understanding of AngularJS (1.X) and Angular 2+ is expected. • Expertise Required - Angular development - Familiarity with AngularJS (1.X) and Angular 2+ - Handling multiple integrations - Building advanced web functionalities - Problem-solving skills Please consider these requirements before making a bid. In your proposal, identify which Angular version you recommend and why. Looking ...

I am looking for a skilled developer to create a mobile app primarily for business users. The app's main function is to deliver location-based notifications...create a mobile app primarily for business users. The app's main function is to deliver location-based notifications. For this project, the app should only be developed for the Android platform. Key functions and requirements include: - Implementing efficient location-tracking systems - Setting up push notifications based on user's location - Ensuring user-friendly UI/UX for business users Ideal developer skills and experience: - Extensive experience in developing Android applications - Familiarity with location-based services - Understanding of push notification setup - Proven track record in c...

I am looking for an experienced professional in Google Ads to help me generate leads for my business. Key Requirements: - Experience in running Google Ads campaigns, specifically for lead generation - Ability to identify and target the right audience for the ads Your responsibilities will include: - managing Google Ads campaigns - Optimizing campaigns to achieve the goal of lead generation - Regularly monitoring and reporting on the performance of the campaigns Ideal Skills: - Google Ads certification - Strong analytical skills - Excellent understanding of lead generation techniques Please submit your proposal if you have proven experience in running successful Google Ads campaigns with a lead generation focus.

I want to change jobs and I ...will discuss. My requirements for the position are very specific. I have a LinkedIn profile. I research myself too, but I feel I don't put enough time. The task is to find jobs posts matching my profile and the requirements that I will provide, and to input all the results in a spreadsheet. Work time: once a week for about 2 hours, or twice a week for about 1 hour. Required Skills: - Prior experience in HR or recruitment - Much experience in job searching on LinkedIn, Indeed, etc. - Familiarity with job market trends in the HR field * I am not looking for just a normal web searcher. Payment - The bidding amount is for one month's (4 weeks) work - If results are good, I will create a new milestone for another...

I have a spreadsheet/pdf of items with new prices. I need the new prices to be reflected on my website, both in Woocommerce itself, but also on one static page.

For my Google Business listing, I'm seeking a professional who can proficiently incorporate a phone number to foster better communication with our customers. The key requirements for this job are as follows: - Knowledge and experience with Google Business listings. - Ability to add a phone number using the local format. - Proficiency in editing and curating business descriptions. The addition of the phone number to the Google Business listing will offer a more straightforward point of contact for our customers, hence improving our customer service. Alongside this, I need the description of our services to be updated as well, thus enhancing the detail and clarity of what we offer. Please apply if you're well-versed in the functionalitie...

I need a skilled freelancer who can efficiently convert a Google Doc into a Word document. -Significant to the project is maintaining all existing styles and formats on the Google Doc in the converted Word document. -A table of contents is required to be added to the Word file. -A sound understanding of Google Docs and Microsoft Word is ideal, with emphasis on expertise in style preservation during conversion.

...seeking an experienced coder to write a TradingView strategy script for me. Your advanced knowledge of Pine Script will be essential in this project. Key requirements: - Conceivable proficiency in Pine Script for creating the desired strategy script. - Understanding of TradingView platform to ensure the script is compatible and functions well. - Awareness of various trendline trading methods. The resulting script should be centered on trendline trading. Your role will involve creating a script that operates effectively on the TradingView platform. Prior experience in similar projects will be advantageous. Please include samples of your previous work in your bid. Thanks, and I look forward to a productive collaboration. Details: I will provide m...

Je suis dans le secteur des services et je recherche un professionnel qualifié pour créer et gérer mes campagnes Google Ads. Mon objectif principal est d'augmenter les ventes de mon entreprise. La concurrence dans mon secteur est élevée, j'ai donc besoin de quelqu'un capable de naviguer efficacement dans ce paysage. Exigences clés : - Expérience avérée dans la création et la gestion de campagnes Google Ads réussies, spécifiquement pour les services. - Capacité à mettre en place des campagnes qui stimulent les ventes et maximisent le retour sur investissement. - Solides compétences en analyse pour suivre et rendre compte des performances des campagnes.

Need fix this error on anydesk Google Campaing Not eligible for Compromised site

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

There are basic functions created, if you contact me I will explain what is missing My project involves interacting with an API (specifically Yahoo Finance) to collect information about stocks or mutual funds. I use the venv environment along with Python to accomplish this task. Subsequently, the goal is to display this data on the screen using React. The application will have a search function that will allow users to access a large amount of information. Additionally, there will be a section where users can enter multiple stocks for comparison purposes. The program will analyze these inputs to determine the best investment option. Additionally, the app includes several display options, such as graphs, to display these comparisons effectively. Additionally, I intend to inc...

I'm in need of an expert researcher who can help with extracting text content from two specific websites to be used for data intelligence. Key Responsibilities: - Extracting text content from the given webites - Populating the relevant data in a spreadsheet, this will be provided for you. Ideal Skills and Experience: - Proficiency in web research techniques - Experience with data extraction and population - Ability to understand and navigate through websites efficiently - Understanding of data intelligence - Attention to detail to ensure accurate data entry The end goal is to have a well-populated spreadsheet with the extracted text content from the specified websites. A successful project completion will require close adherence to the instruction...

I have a need for a spreadsheet that allows me to calculate total price based on numerous factors: Various products with different prices per user and minimum sale prices Total Price based on a calculation of User Count (factoring a minimum that must be met - Hard set) Price factoring in a margin that can be manually entered and calculated Price that factors off of the previous input with an additional margin calculation that can be manually changed Key Requirements: - Data Entry: I will manually input sales data into the spreadsheet. - Calculation: The spreadsheet should be able to calculate unit prices and margins based on the sales data provided. Ideal Skills: - Advanced Excel skills: Proficiency in creating complex formulas for unit price and margi...

I'm seeking an informed individual who is proficient in company research - particularly on LinkedIn. This project requires you to investigate companies within the Fintech, HealthTech and RegTech industries. Your primary focus will be determining the company size (40 to 250 employees), the industry (Fintech/HealhTech/RegTech) they belong to, and the location (UK/Germany/Spain/Italy/France/Malta) of their business. Additionally, you will need to dig deeper to find the number of Talent Team members. High-level tasks: - Identify specific LinkedIn companies that match brief. - Data entry of URL, company size, talent team size, industry, and location on Excel spreadsheet. The ideal candidate will have previous experience in similar research work and possess knowle...

I have an error in my asp.net MVC application. The form is using AJAX to show particular dropsownlist data. its working fine but if the validation works, the ajax call is reseting and stop working.

...website in PDF format. This user guide will be an essential tool for users to navigate and understand the various tools and features of my site. Key Aspects to Address: - Shopping and checkout process - A step-by-step guide of how to shop, add items to the cart and checkout successfully. - Account registration and profile setup - Detailed explanation on how to create and set up a user profile, including important tips to optimize user experience. - Using interactive tools or features - Walkthroughs and explanations of the interactive tools available, how to use them and their benefits. Feature Highlights: - Search functionality - An overview about the benefits and how to use the search feature effectively to find products. - Many functionalities - Highlight other numer...

I need a professiona...specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prio...

I'm in need of a qualified professional to establish a merchant feed for my website and set up Google Shopping Ads.

I'm looking for a freelancer who can help me create a daily PDF spreadsheet for data visualization using Adobe Acrobat. Key Requirements: - The PDF spreadsheet will primarily be used for data visualization, so experience in transforming data into visual representations is a must. - The data will be updated daily, so the freelancer should be able to efficiently handle daily updates and maintain the integrity of the visualization. Ideal Skills: - Proficient in Adobe Acrobat - Strong background in data visualization - Experience in handling daily data updates Please provide a brief overview of how you would approach this project.

I need a data scraping tool to pull business names and addresses from Google and Google Maps. - The tool should be able to extract this information in an organized and comprehensive manner, enabling me to create a database for further analysis. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques. - Experience working with Google and Google Maps APIs. - Ability to organize and structure data effectively. - Data to be compiled in an excel spreadsheet - Prior knowledge of extracting business information from online sources is a plus. Looking forward to your proposals.

I'm l...to create a visually appealing PDF spreadsheet for me. This spreadsheet is intended for the presentation of information, and should be optimized for printing. Key Responsibilities: - Designing and formatting the spreadsheet to ensure a professional and engaging appearance. - Implementing a clear structure that makes the data easy to follow. - Ensuring that the design is optimized for printing, with appropriate margins, font sizes, and color choices. Requirements: - Prior experience in designing PDFs for print. - Understanding of how to present data in a visually appealing and easy-to-understand manner. - Attention to detail and the ability to follow design guidelines. If you're confident in your ability to create a stunning and...

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I am in need of a skilled data entry operator to assist with the transfer of input of text data. Your main task is to take text data from an online database and accurately enter it into an Excel spreadsheet. Requirements: - Ability to accurately enter text data - Proficient in Excel - Experience sourcing data from online databases - Diligent and detail-oriented to ensure no errors are made during data transfer - Strong English language skills to ensure effective communication The ideal freelancer for this project is someone with proven data entry experience, excellent Excel skills, and vast familiarity with online databases. Being a detail-oriented person with great concentration skills will be a huge plus.

...my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your main goal would be to improve the pr...

I need an...you're suitable for this role. I look forward to your insights and ideas. Design examples for guidelines will be provided. Full vision will be provided before start of project. Minor changes and improvements will occur on the way if needed. ***Need to run in sub folder*** Php, sql, html, css only. No backdoor connections No hidden code Full transparency of code No ownership over code/project for developer No tip No access to server No zip file No extra payments No delays over 10 days. Need to run in sub folder. If no returning correspondence from developer for more than 24h the project will go to another developer. Live demonstration of progress. Other requirements may be applied prior to project start. Communication o...

...register up to three keywords: For example: "강남맛집, 압구정맛집, 서울맛집" (Keywords) - "강남로코컴플렉스" (Business name) For example: "강남맛집(강남로코컴플렉스) 11위, 압구정맛집(강남로코컴플렉스) 6위, 서울맛집(강남로코컴플렉스) 30위" Member functions - Permission separation into Master, Manager, and Team Leader: Master - Can view all registered items Manager - Can only view items registered by themselves or by their subordinate team leaders Team Leader - Can only view items registered by themselves Search/Filter function: Business name and keyword search function Filter by registration year and month (initial ranking) (Only shows items registered for that month, in registration order) History screen link sharing function: This link is valid for only one week Only the corresponding screen can be vie...

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I am in need of an expert on the Google Ads API. The project is urgent and involves both setting up and managing the API. Key Tasks: - Setting up the Google Ads API: You will be responsible for the initial setup and configuration of the Google Ads API. - Managing Ad Groups and Keywords: I need assistance in creating, editing, and managing ad groups and keywords effectively. Ideal Skills & Experience: - Proven expertise in working with the Google Ads API. - Previous experience in setting up and configuring the API. - Strong background in managing ad groups and keywords. - Ability to understand and effectively implement API calls. I need this project completed as soon as possible. If you believe you have the necessary ski...

I'm in need of a talented designer to help me create a modern and sleek corporate web profile for my company on my registered domain I'm looking to include: - Comprehensive company history and background with photos & video - Detailed description of our products and services with photos & video - contact us The key points for this project: - Design should be modern and sleek - The primary audience is potential clients or customers Ideal skills and experience for this project include: - Proven experience in graphic design and corporate branding - Understanding of modern design trends - Ability to present information in a clear and engaging manner - Prior experience in creating corporate profiles or similar documents is a plus Please share yo...