Functions in google sheetsdela
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.
We are looking for developers who are proficient in WooCommerce and Google Sheet API to help with our ongoing project to improve some of it's functionalities and features. Key Responsibilities: - Assist in setting up WooCommerce functionalities on a website, including product catalog, shopping cart, and payment gateway integration. - Implement integration with Google Sheet API for specific data processing & syncing requirements. Ideal Candidate: - Proficient in WooCommerce, including setting up product catalog, shopping cart, and payment gateway integration. - Experienced in integrating external APIs, specifically Google Sheet API, App Scripts Programming. - A good understanding of data processing and how to leverage Google...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in da...
I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.
...that the customization choices will show on the picture in real time. In other words, the picture will change each time a customization is added. I need ONE PAGE created for web store (wordpress/woocommerce). Must have a visual product customizer. Meaning that a customer will have the option to customize the item and see the changes they make in real time. Not just colors and sizes though, but entering texts and choosing adornments, etc. Here is an example of what I am needing (not my website, just one I found online). If you can duplicate this page exactly I would be pleased. SPECIAL NOTE ( I only need one page. It must have a product that functions like this one :
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about eac...customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs completed and payments owed for easy reference. **Additional Features:** - The ability to filter and sort jobs by date, installer, or customer. - An input form for easily adding new job entries. **Skills Required:** - Proficiency in Microsoft Excel, including formulas and data validation. - Experience creating user-friendly and automated Excel sheets. **Deliverables:** - A fully functional Excel sheet as described. - Instructions for use and any necessary d...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specifically adjac...
I’m looking for a skilled freelancer to assist in implementing specific modules in Odoo and integrating third-party apps in a bid to significantly improve the customer experience as well as streamline our business systems. You should have: - Outstanding experience and expertise in Odoo implementation and project management. - Proven track record in integrating third-party software and adapting functionalities. - Exceptional familiarity with CRM, Inventory Management, Accounting, and us of Odoo apps to manage food delivery. Key tasks include: 1. Data Migration: -Taking CSV files of my exported sales data from Shopkeep and importing it into Odoo without loss of critical information in order to enable reporting on old sales data. 2. Odo...
Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501
I'm looking for a Google Ads expert to review my Google Ads account focusing on campaign structure and target audience to enhance lead generation. Specifically, I'm looking for someone to review in comparison to another specified month where campaigns were much more successful. Key Areas: - **Campaign Structure**: Your task would be to evaluate and provide feedback on the overall structure of my existing campaigns. This includes the organization of ad groups, the relevance of keywords, and the alignment of ad creatives with the campaign goals. - **Target Audience**: I need a detailed examination of my target audience. This would involve assessing how well my current targeting aligns with the interests and behaviors of my ideal leads. You will be expected to...
I'm in urgent need of a Google Pay redeem code valued at 1000 INR. I'm specifically looking for a code that can be used to purchase apps or games. While I'm not yet sure which applications or games I'll be purchasing, I'm highly motivated to get the code as quickly as possible. Ideal Skills: - Experience with online payments and redeem codes - Efficient and reliable service - Proven track record of fast delivery Please keep in mind that I need the code immediately.
I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface design for a seamless user experience.
I'm looking to integrate Open AI capabilities with Google Sheets to create an AI assistant that can provide our customer real time inventory information when asked. Key Project Details: - The main task of the AI assistant will be to provide real-time inventory information from Google Sheet that contains our inventory data. Ideal Skills: - Solid experience with Google Sheets API - Proven track record of integrating AI tools with external data sources - Understanding of real-time data processing and automation - Familiarity with predictive inventory management would be a plus I'm looking for a freelancer who can bring both technical expertise and creative problem-solving skills to this project.
I am in search of a skilled KNX engineer to design a comprehensive home automation solution for a 4 room apartment. Key Requirements: - The scope will involve creating an AutoCAD file, a wiring plan, and a 2D structure for the products in the architecture plan. - You must also provide a list of quantities. Specific Features & Functions: - The automation project should include lighting control and temperature control. Integration: - There is no need for voice control or mobile app integration. Scalability: - The system should be designed to be scalable for future upgrades or additions. Ideal Skills: - Proficiency in KNX engineering with a portfolio demonstrating similar projects. - Strong AutoCAD skills. - Ability to design for scalability and futu...
I'm seeking a skilled robotics engineer to simulate basic robotic movements in Gazebo. My project's scope includes: - Engineering a robotic system to perform automated maneuvers. - Implementing basic movements such as forward motion, turning, and stopping. Your expertise should ideally include: - Proficiency in robotics engineering inclusive of controller expertise and Gazebo simulation. - Familiarity with automated systems and their movements. I anticipate this project to be less complex but I demand accuracy in basic functions.
I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Pr...
...manage and promote my Etsy shop. Key Tasks: - I need to list products in my shop, particularly those within jewelry, home decor and art and craft supplies. - I currently have less than 50 listings on my shop, so there’s a scope for expanding the product range. - I am looking for a professional who can devise a sales-driven strategy to enhance visibility and attract potential buyers. -i want someone who can build google my business profile and manage the same. Ideal Skills and Experience: - Proficiency in Etsy shop & google my business management and promotion. - A track record of increasing sales for similar businesses. - Familiarity with jewellery, home decor, and art & craft supplies markets. Please include in your proposal your...
...manage and promote my Etsy shop, as well as open my google business shop. I have an inventory of handmade and unique items, and I need help with both platforms for better visibility and improved customer engagement. Your tasks would primarily include: - Inventory Management: Keeping track of existing inventory, update listing details if necessary and coordinate to replenish stock. Knowledge of Etsy’s listing system is necessary. - Promotion: Create and execute Social Media promotion strategies for both Etsy Shop and Google Business. You should have experience in leveraging different social media platforms for business promotion. Ideal candidate would have prior experience managing Etsy shops and Google Business listings, with proven results in...
Some functions are not working properly. All files of the site are hosted and the site is complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and erro...
I need a skilled website developer to help me upload my WordPress website templates to Hostinger. Key Responsibilities: - Assistance with uploading my existing WordPress website templates to Hostinger - Ensuring the website functions correctly post-upload Ideal Skills: - Proficiency in WordPress and Hostinger - Experience in website template upload and customization - Good communication skills Please note: I am not looking for website design or content creation; this project is solely for technical assistance with the upload process.
...help me resolve an issue with Google Login on my Android app. -When we generate release version of the APK Login with Google works perfectly, but upon publishing it to the Google Play Store, it encounters issues. The error message encountered is: PlatformException(sign_in_failed, com.google.android.gms.commeon.api.b:10:, null, null). Ideal skills and experience: - Proficiency in Flutter and Dart - Experience with Google Login integration in Flutter - Ability to troubleshoot and resolve authentication issues - Strong understanding of Android app development - Good communication skills and the ability to collaborate effectively with the rest of the team. If you believe you have the expertise and experience to tackle this problem effectively,...
I'm in need of a skilled freelancer to embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets...
I'm experiencing frequent slowdowns on my Moodle quiz site when more than 200 users are taking the quiz concurrently. The site is hosted on a dedicated server. Key Points: - The ...simultaneously. - The hosting environment is a dedicated server. Your role as a freelancer would involve: - Identifying the performance bottlenecks on the site. - Implementing optimizations to ensure the quiz functions smoothly for a large number of concurrent users. Ideal Skills and Experience: - Extensive experience with optimizing Moodle sites for high traffic situations. - Proficiency in configuring and fine-tuning server resources. - A strong understanding of Moodle's architecture and how it handles multiple simultaneous users. - Exceptional problem-solving skills and ability ...
I'm looking for a skilled professional to help create an app or web page that is primarily focused on data management. Key Requirements: - The app shoul...focused on data management. Key Requirements: - The app should allow users to interact through forms. It should be easy to use and intuitive. - The app should be able to integrate seamlessly with Google Sheets. This means that data collected through the forms should be stored directly in a Google Sheet. I'm looking for someone who has experience in: - Developing apps that are used for data management. - Creating forms that are user-friendly and easy to interact with. - Integrating apps with Google Sheets. If you have experience in these areas and are confident in...
I need an expert in Selenium to automate functionality testing of our web application. This project aims to ensure the application functions as expected with regular, automated testing. Key Responsibilities: - Developing automated functions testing for our web application - Ensuring tests are compatible with Google Chrome. Ideal Skills: - Proficient with Selenium - Familiar with functionality testing. - Reliable and consistent test development. Previous experience with Selenium-based functionality testing in Chrome is highly desirable.
I am experiencing a recurring issue with my WordPress website where plugins ...they are found deactivated again the following day. I need assistance with creating a backup of the website and safely updating WordPress along with all plugins, including Elementor, to ensure the website functions correctly without any plugins deactivating unexpectedly. Your expertise in resolving this issue and restoring full functionality to my website would be greatly appreciated. The primary task is to identify and fix the issue that's causing the plugin deactivation. Ideal freelancers for this project should have: - Strong experience with WordPress plugin development. - Proficiency in troubleshooting and debugging WordPress issues. - Ability to work quickly and efficiently, as t...
I'm looking for a skilled developer with experience in cTrader platform and C# programming to create a custom Renko-based cBot for me. Key Requirements: - C# Proficiency: The developer should be well-versed in C# programming language, as the cTrader platform typically uses this language for cBots. - cTrader Platform Knowledge: Experience with this platform is essential, the developer should have a strong understanding of how to work with its APIs and develop cBots. - Custom Renko Functionality: I need the developer to implement a custom brick size for Renko charts in the cBot. -Automated Trading Execution: The cTrader bot should be able to automatically execute trades based on the parameters of the strategy. - Backtesting and optimisation capabilities: The idea...
Project Overview: I am seeking to have a custom Google Sheets system created for a group within a GTA V roleplay server. Our group imports special items for other groups, and we need an efficient way to manage these transactions. Requirements: Main Sheet: Buttons: Treasury Deposit/Withdrawal: A button that, when clicked, presents a dialog or an input field directly on the sheet to enter the deposit or withdrawal amount. Shipment: A button that allows users to input the following details: gangName memberName itemOrdered itemQuantity weightUsed currentWeight weightAfter orderedBy Automatic calculation of the total weight and price for each item (a list of items, their prices, and weights will be provided). TreasuryDB: A dedicated sheet to track all deposit and withdrawal ...
For this project, I'm seeking a proficient iOS Developer to build a simple directory app. This app should contain the basic functionalities such as user search, view, and more. It should be developed with a left drawer navigation system. The main skills and experiences preferred for this task include: - Proficiency in iOS Development - Experience in designing and implementing search and navigation functions - Knowledge of directory structure and data management The completion of the project is expected within a month, therefore a commitment to meeting this deadline is necessary.
One month Google Ads work for a website
I need help setting up my nextjs website's cookie consent to be compatible with Google Consent v3. Key Requirements: - Write codes to setup cookie consent with google tag manager. - Ensure the cookie consent setup is specifically for Google Consent v3 compatibility. - Make sure the setup with Google tag manager. Ideal Skills: - Next js. - Familiarity with Google Consent Mode v3.
As the project owner, I'm seeking a professional skilled in Pine Script with experience in retrieving code from private scripts on Trading view. The key objectives of this project include: - Extracting the Pine Script code from a specific invite-only script (the script name will be shared privately upon project commencement). Unfortunately, it's currently unknown which specific script to be used, but clarity will be provided as the project progresses. - Discern the implemented functions within the script. The functionalities mainly centered around recognizable trading indicators like Moving averages, Pivots, Fibonacci and MACD. - The code extraction should consider compatibility with variable timeframes. Whilst exact timeframes aren't specified yet, f...
...than 200 items. However, there is no need to develop the product and product descriptions for all the products. Some templates and editable product box will suffice my need. Some Key Requirements: - WordPress Expertise: Must be proficient with the WordPress platform. Having prior knowledge of Hostinger is desirable but not required. - eCommerce Experience: Prior experience in developing online stores with all the functions is necessary. - Minimums 2 months of support after go-live. - Should be compatible with Mobile browsers as well. - User Login Panel, Shopping Cart, Newsletter Generation, etc., are essential. - No Webhosting Set-up since I already have a subscription on Hostinger. - Payment Gateway Integration If you think you're the right person for this job, p...
...mobile app developer to create a social networking application geared towards professionals. Key Features: - User Registration and Profile Creation - Messaging System - Networking and Connection Building Features - News Feed for Professional Updates - Job Listing and Recruitment Section - In-App Search and Filter Functions - Notification System - Integration with Existing Social Media Platforms Skills and Experience: - Proficient in mobile app development - Previous experience in creating social networking applications - Strong understanding of user experience and design principles - Ability to integrate various APIs - Familiarity with data security and privacy standards This is a unique project and I am looking for a freelancer who c...
...facing some persistent issues with Google Search Console and I need an expert to help me resolve them. Key tasks involved: - Fixing Indexing Issues: There are some pages on my site that aren't being indexed properly by Google. This could be due to various reasons like crawling errors, server problems, etc. - Resolving Sitemap Errors: I've been receiving errors related to the sitemap of my website. This could be contributing to the indexing problems. - Addressing Mobile Usability Issues: Google has flagged some mobile usability issues on my site. I want to ensure my website is fully mobile-friendly and complies with Google's guidelines. Ideal Skills and Experience: - Strong understanding of Google Search Console: You should have a deep unders...
...seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet ...
I'm looking for an expert to create and oversee a Google Ads campaign for my e-commerce business. - Goal: The primary goal of this campaign is to increase sales. Your strategies should be geared towards this objective. - Target Audience: The target audience for this campaign is a national one. You should have an understanding of how to tailor ads to draw attention from across the country. Our customer base is largely Business to Business, and we are wanting to market Australia wide. - Google Shopping ads have traditionally worked well for us also. The ideal freelancer for this project should have demonstrable experience in managing Google Ads for e-commerce businesses, ideally in the industrial fittings industry, with a strong track record of in...
I'm looking for a C# developer to build an application for me. You need to make C# application (app/web/console whatever is best for you). Basically, it is POST, GET, PUT, DELETE requests against API. Problem is that there is limited documentation, so you must conclude based on swagger documentation how to implement each of functions. Swagger link will be provided. Please, apply for this job if you can do it TODAY.
As a business based in the Grey Industry, we're looking for a Google Ads expert with a proven track record in lead generation. Key Requirements: - The main goal of our campaign is to generate B2C leads. Your experience in targeting and appealing to this demographic is crucial. - Expertise in Google Ads and a strong understanding of lead generation strategies is a must. - A background in the Grey Industry or similar industries is a definite plus, but not mandatory. Key Deliverables: - Develop a Google Ads campaign tailored to our B2C audience to effectively generate leads. - Monitor and optimize the campaign to ensure a high lead conversion rate. Skills and Experience: - Proven experience in successful lead generation ca...
I am in need of a skilled developer to create a customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficien...
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and mo...need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compa...
...automation features in my living space. I'm interested in automating lighting, heating/cooling and integrating specific features for each area. Key Requirements: - Lighting Automation: I need the system to include dimming capabilities, color changing lights, and motion sensor lights. It should be able to adapt to different lighting needs and situations. - Heating/Cooling Automation: I have a smart thermostat and I would like it to be integrated into the system. The system should allow for optimal temperature control and adapt to my preferences. Ideal Skills: - Home Automation: Experience with setting up and integrating smart home features is a must. - Lighting Systems: Proficiency in configuring lighting systems with various functions. - HVAC System...
I am in need of an expert in Google Ads to help with lead generation for my software, which caters to enterprise companies. Key Requirements: - Develop and execute a Google Ads campaign focused on targeting enterprise companies. - Regularly monitor and optimize the campaign to ensure leads are being generated consistently. - Provide regular reports on the performance of the campaign, including the number of leads generated and the ROI. - Explain your actions at each step. Ideal Skills and Experience: - Proven track record of successful lead generation campaigns targeting enterprise companies. - Extensive experience with Google Ads, particularly in the B2B software industry. - Strong analytical skills to interpret campaign performance data and ma...
I am looking for a well-qualified freelancer to help me develop a motivational app using AI. The user interface required for the app will be a mobile application. We will also need an admi...a mobile application. We will also need an admin panel to manage user subscriptions. Additionally, AI scripts need to be incorporated into the app as well. The purpose of the app is to motivate users and encourage them to reach their goals. The freelancer I choose to work with must possess advanced experience in both mobile application development and AI programming. They should be comfortable working with both UI/UX design and backend development to ensure that the app functions correctly. Project Brief -
My Wordpress site has some issues. Also a lot error alerts in Google search console need expert to fix that
I'm looking for a skilled Visual Basic 6 programmer to adjust functionality within my VB6 source code. The task primarily involves expanding reporting functions to include more tables. Ideal applicants should have: - Extensive experience in VB6 programming. - Previous work involving functionality adjustments, particularly in Reporting and Data Management. - A keen eye for detail to maintain existing code integrity while implementing changes. - Strong understanding of data management and manipulation in VB6. Your role will be solely focused on altering the existing VB6 code and ensuring the changes don't disrupt the software's operational flow. Familiarity with VB6 and past projects involving Reporting changes are crucial.
I am searching for a freelancer to enhance my local search rankings by creating and managing map citations on Google My Business to reach the top 3 positions with guaranteed results. If you cannot provide a guarantee, please do not apply for this job. Key Responsibilities: - Create high-quality Google Map Citations for my business - Ensure all information is up-to-date and accurate - Regularly monitor and update the citations to maintain their effectiveness Ideal Candidate: - Experience in local SEO and Google My Business - Proven track record in improving local search rankings through map citations - Detail-oriented and a stickler for accuracy - Capable of managing and updating the citations on an ongoing basis - Strong communication skills for reporti...
I'm in need of a skilled individual who is proficient in both PHP and Google Gemini. The primary task is to integrate this platform with my PHP website. Key requirements include: - Basic data syncing: The main goal is to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The ideal candidate must have: - Demonstrated expertise in PHP and Google Gemini. - Prior experience in integrating Google Gemini with websites. - Strong communication skills to understand my requirements and provide updates on the integration process.
