Query bigquery from sheets jobs

I am looking for a skilled professional to help me with the following project: - Crawl and download containers from Docker Hub and GitHub Container Registry - Extract all binaries, etc, from the containers - Publish the extracted binaries as deb packages in an APT repository - Utilize AI to ensure the repository is kept up-to-date with new and updated binaries daily. Ideal Skills: - Strong experience with container technologies, especially Docker and GitHub Container Registry - Proficiency in building and maintaining APT repositories - Knowledge of AI for automated software updates - Excellent understanding of binary extraction and packaging - Previous experience in software distribution is a plus. Please apply with your relevant experience and a brief outline of how you w...

...to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets it produces). ii. It uses a “What is your current yearly revenue” number and pulls against an array (worksheet) – For the 8 other reports, it pulls data from the column in the array to produce reports. b. Customer EBITDA and P&L – Some data from the array is utilized here, and this being a cus...

I need a professional to scrape specific information from an one page weblink and present it in an Excel file. The details will include: - IMAGE LINK - Product Name - Price1 -Price 2 - Link to Product Page - Stock Availability (I lager) The freelancer that can deliver fast will be prefered.

You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.

I am seeking a skilled data scrapper to retrieve specific information from 'Website 1'. a full comprehension of various types of data is needed for a successful scrape. The types of data required include: - Textual content - Metadata Specifically, within the textual content, I require: - Titles - Descriptions - Prices - Linked products - Related products An ideal candidate would demonstrate extensive experience in data scraping, with a keen focus on retrieving accurate and relevant information. A good understanding of e-commerce sites and familiarity with Metadata and APIs will be advantageous. Please, I urge you to utilize ethical scraping methods in accordance with the rules and regulations of the source website. Looking forward to working with a meticulous and...

I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and exper...

I'm in need of a Google Sheets scripting expert who can help me create a bidirectional data transfer system in Google Sheets. - The task involves transferring ALL data from one main sheet to multiple other sheets. - The data should be copied as well as linked to the other sheets. - The script should work bidirectionally, meaning any changes made in the source sheet should be reflected accurately in all the other sheets and vice versa. Ideal Skills and Experience: - Proficiency in Google Sheets scripting, specifically working with data transfer and bidirectional systems. - Knowledge of how to copy and link data between sheets. - Experience in creating and maintaining bi-directional data systems. - Ability to ensure that the scri...

I'm in need of a professional who can help with qualitative analysis of interviews conducted with subject matter experts. Key tasks include: - Conduct thematic analysis - Conducting a thorough qualitative analysis of the interviews - Identifying trends and patterns in the feedback ...qualitative analysis of interviews conducted with subject matter experts. Key tasks include: - Conduct thematic analysis - Conducting a thorough qualitative analysis of the interviews - Identifying trends and patterns in the feedback - Gaining insights based on the experts' opinions Skills and Experience: - Proven experience in conducting qualitative analysis - Familiarity with interpreting feedback from industry professionals and subject matter experts - Strong analytical skills to ident...

It seems people do not read the requirements and conditions and once I start the trial, people are failing to perform. Also, too many bids from countries I do not desire; Pakistan, Bangladesh, India, etc. I need a freelancer from LATIN AMERICA only. I need close to EST time!! Furthermore, I need a BILINGUAL freelancer!! So READ before biding. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, ...

I am seeking an Excel expert with strong data analytics skills to create an Excel sheet primarily for data analysis. The main function of the Excel sheet will be to conduct descriptive analysis. Ultimately, this analysis will assist me to forecast sales trends. Key Requirements: - Expertise in Excel and data analytics - Knowledge in sales forecasting - Experience developing descriptive analytic platforms - Familiarity with project management and financial tracking is a plus I expect the final document to provide me with detailed insights to make informed decisions about future sales strategies. If you possess the necessary skills and experience, I look forward to receiving your bid.

I'm in need of an Excel Spreadsheet expert to help with a few key tasks: - Revamp the Weight Loss Tracking Sheet: The current formula isn't functioning as intended. Your job will...fix the problem. - Nutrition Plan Integration: Blend the Weight Loss Tracking Sheet with a separate nutrition plan in the same Excel document. The two should have a uniform look, with consistent colours and my branding. - Branding Adjustments: Remove branding from the Weight Loss Tracking Sheet and ensure it matches the nutrition plan in terms of aesthetics. Your expertise in Excel formulas and formatting, as well as design skills will be key in completing this project successfully. Also please make a copy of the tracking sheets below so I have master copies and don’t mess wit...

...transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of specific details is not required. Wish me a Happy Birthd...

I'm looking to enhance my Shopify store's B2B functionality by integrating two essential features from Sparklayer: - "Quick Buy" Page: This will substitute our current List view, enabling clients to quickly see prices and make bulk orders without navigating through individual product pages. (example is visible in another installed theme) - 'Unit Cost' Display on Product Page: Prices need to be shown in kilograms and automatically sync with Shopify's unit pricing, factoring in base price and dynamic calculations. (example code: ) Ideal candidate should have: - Proven experience with Shopify theme customization - Knowledge of B2B eCommerce solutions - Familiarity with Sparklayer integration - Fluency in JavaScript, HTML/CSS, and Liquid - Ability t...

I'm in need of a skilled estimator who can work with 3D models to provide a comprehensive quantity takeoff for my residential construction project. Key Responsibilities: - Review and interpret the provided 3D models to calculate the quantity of materials needed for the project - Develop a detailed estimate for the entire project, broken down into relevant components such as labor, materials, equipment, etc. - Highlight any potential cost-saving measures or areas of concern based on the estimation Ideal Skills and Experience: - Extensive experience in construction estimation, particularly for residential projects - Proficiency in working with 3D modeling software and translating the models into accurate quantity takeoffs - Strong attention to detail and the ability to identify pote...

I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.

...Remove the "//const MongoClient = require("mongodb").MongoClient;” line 2 - Run ‘docker compose up’ to start the code 3 - Fix the code so it does not crash 4 - Demonstrate a working connection between the application and a remote Mongo Atlas database (you will need to create one yourself or point to one). The data does not matter, I just need to see examples of: a) A READ query, b) An UPDATE query, c) A CREATE new record query Error See this file for a description of the error which needs to be fixed - Debugging The application connects to a remote Mongo Atlas database correctly if the code is run outside the container. I’ve developed a simple Mongo connection js file which tests this. The output is shown here - h...

Following are the requirements of task to be fulfilled. 1- Task is to visit the Galatasaray university physically and Take 5 to 6 geotagged photos of with name board captured and from outside the building. 2- Get the verification form filled, signed and stamped by the HR of Galatasaray university, and also stamp the certificate. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If Galatasaray university, does not found on given address than take the 7 to 8 geotagged photos of exact address with right left name boards photos and make a small few seconds video of address . Also get the details of any nearby business ( Name of person, Business name and Contact

...developer to construct a PDF data sheet generator for products from a database. Key Project Objectives: - Create section generator user input screen to enter named sections which can be used across different products. - Have the ability to adjust sort order of sections are rendered when the PDF is generated. - Incorporate re-usable generic sections within the generated PDFs to maximize efficiency. - Use links to insert pictures for diagrams and product image. Ideal Skills and Experience: - Proficient in PHP Development - Proficient with a PDF generation library, (ideally TCPDF) - Experience in working with databases - Experience in image handling and manipulation for the chosen PDF library. The final product should generate data sheets that are both visually engaging ...

I'm looking for an expert in Excel, preferable someone who is adept at managing and organizing large volumes of financial data. The task primarily revolves around: • Data entry and organization: You will be given vast amounts of financial data which I expect you to expertly enter and organize into Excel sheets. • Handling extensive data: You should be adept in working with over 10,000 rows/columns of data. • Using Excel functionalities: You should be familiar with Excel formulas and functions to format, sort, and organize the data effectively. Your experience in dealing with extensive financial data will be highly beneficial. I look forward to working with organized, accurate, and efficient freelancers. Remember, it's all about the details - accuracy is ...

I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sales strategies.

I have an autocad drawing of a house I need someone to calculate the surface area of the facade for the stone work only excludnig the windows adding to the the exterior part of the boundry wall

Wanted Online Internet job workers. Job is only through Internet. Work from home part time jobs. You can earn Rs.750-2000/- daily. These are genuine Data entry jobs & Internet jobs. No Investment required Online Captcha Typing Jobs Without Investment

I need an expert in PowerBI to help us recreat...and Activity Report - The Sales Report should include Revenue, Quantity Sold, and Top-Selling Products - The Financial Report should be a recreation of a Profit and Loss Statement, Balance Sheet, and Cash Flow Statement from our previous data in Sage Ideal Skills and Experience: - Proficiency in PowerBI tools - Previous experience with migrating reports from Sage to Business Central would be a huge advantage - Strong analytical skills to ensure the reports are accurate and comprehensive Please note that we can provide you with the necessary data and previous reports from Sage to facilitate your work. I'm looking forward to receiving your proposals. I have also attached a couple of sage reports that we are after i...

...functions involved: add_post Here I build a Wordpress Query containing data from the POST request. Then I run a "wp_inset_post" function with this query. From that Wordpress function you will then receive a "post_id" with which I will add photos to the post. change_post Same as "add_post" but I use the "update_post" function because I already know the post_id. Then I'll delete all the photos from this post and add them again. I do this because I cannot tell from the file name of a photo whether it has been changed. check_vehicle (controleer_voertuig) (apologies, Dutch names in code are not neat) This checks whether the data from VWE has images, otherwise I will not process it. process_photo...

I need a developer to build a PHP app using Google Sheets as a database. I want add a text on a field it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice ...

I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.

I'm looking for a capable developer with a good understanding of Bootstrap CSS to convert a moderately complex Figma web design into a responsive HTML. Key Requirements: - Conversion specifically from Figma Web App - Ability to handle moderate complexity designs - Ensure responsiveness across desktop, tablet, and mobile - Use of Bootstrap CSS to maintain consistency and speed up the development process Please only bid on this project if you have a strong knowledge of Figma, Bootstrap and responsive web development. Your experience in similar projects will be a strong asset.

I'm looking for a Google App Script developer who can create intermediate custom functions for me. These functions need to handle data processing across multiple sheets or documents, and also fetch data from external sources. The ideal candidate should have experience in: - Creating intermediate complexity custom functions on Google App Script - Handling data processing across multiple sheets or documents - Fetching data from external sources using APIs or other services Additional expertise in Google Apps and data analysis is a plus. A detailed understanding of the entire Google Apps ecosystem and the ability to work with external APIs will be essential to deliver the project effectively.

data collection as per sample web scraping fro

I'm in need of an experienced Photoshop expert to help remove unwanted reflections from a batch of 1-5 images in total. Key Requirements: - The main objective is to eliminate reflections on the images to ensure they are distraction-free. Final Deliverables: - The final images should maintain the same resolution as the original ones. Ideal Skills and Experience: - Proficiency in Photoshop with a strong background in image editing. - Previous experience in reflection removal is a plus. - Attention to detail to ensure the final deliverables are of high quality and free from any imperfections.

As a team heavily reliant on Google Sheets for our daily reporting, we're looking for a proficient freelancer who can automate the process of compiling our marketing metrics. Key Tasks: - Automate the process of copying data between sheets - Ensure data collation for metrics such as click-through rates, conversion rates, and social media engagement Ideal Skills and Experience: - Extensive knowledge in Google Sheets - Experience in automation and data analysis - Knowledge of marketing metrics would be an asset

I am in need of an experienced Software Tester to evaluate the quality of a mobile application on both iOS and Android platforms. The main focus of the testing should be on Functional, Usability, and Performance aspects. Key Responsibilities: - Perform detailed Functional Testing to ensure that the mobile app meets all specified requirements and functions correctly. - Conduct Usability Testing to assess the user-friendliness of the app and identify any areas for improvement. - Carry out Performance Testing to evaluate the speed, responsiveness, and stability of the mobile application. Ideal Skills and Experience: - Proven experience in testing mobile applications, preferably on both Android and iOS platforms. - Strong understanding of software Quality Assurance processes and methodologie...

I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? Within a month

I have a personal photo in which there's an object in the background that I'd like to have removed. This is for personal use, so I'm looking for it to be done with high-quality editing. The task involves: - Removing a background item from a single personal photo (sticker on window in attached photo, Pokémon/icons on the bench and other cable car) - Ensuring that the edited photo looks natural and professionally done as the photo will be for personal I think this should be pretty straightforward but I’m open to your creative suggestions on how to best achieve this edit!

I'm in need of a proficient video editor who specializes in creating engaging and dynamic social media content. Here's what the job entails: - You will be creating less than 1-minute videos primarily focusing on event highlights. - The content needs to be visually stimulating, concise and should effectively showcase the highlights of the event. - A strong understanding of social media trends is key to meet the audience's expectations. Ideal Skills: - Video Editing - Strong narrative storytelling abilities - Previous experience, will need a portfolio This work will be on a monthly basis so a committed and reliable individual is preferred. Have your portfolio ready to discuss. How much per a 1 min or less video?

...interactive, drag-and-drop enabled character builder - Integration of a comprehensive Pokemon database - Provide easy access to rulebooks - Installation of an egg session counter - Ability to trade Pokemon within teams - Automatic speed list generation for players and chosen Pokemon - Incorporation of a loyalty/friendship tracker - A user-friendly system for sorting, adding, and removing Pokemon from parties - A quest log/reminder feature for victory points - Capability to generate Fakemon within established rules Built in pokemart with the GM To easily adjust prices and what not along with ability to setup specials/deals Ability to set up towns (EX Team flow enters twist tree, changes quest log, changes mart?/ mystery eggs?) Ability to easily subtract and add combat stages E...

I'm looking for a skilled Excel expert to automate the formatting of a spreadsheet from a Quickbooks export. Key Requirements: - I primarily need the freelancer to set up and automate formatting in my Quickbooks Excel spreadsheets. - The final formatting should be both visually appealing and easy to read for the end user, we will provide guidance on what the end result should look similar to. Ideal Skills and Experience: - Strong proficiency in Excel, especially with automating processes and conditional formatting. - Previous experience working on projects involving data visualization and presentation. - A good eye for design to ensure the data is clearly differentiated and visually engaging.

I need an expert in Google Sheets to create a spreadsheet that will help me with data storage and organization, calculation and analysis, as well as collaboration and sharing. - You will be working with 1-5 sheets, and you should be able to help me set up the data in a logical and user-friendly way. - I would require some basic formulas to be implemented, so knowledge of formulas like SUM and AVERAGE is a must. - Lastly, I need to ensure that the sharing and collaboration aspects of the sheet are secure and work smoothly. - Previous experience with similar projects is a plus.

We don't want our employees to see the phone numbers of customers on whatsapp and chat with them. We just want to restrict whatsapp usage to making calls only without visibility of the numbers. So best is that if the GUI of WhatsApp Desktop is not visible and we access it using another app. Either from browser or another windows app. Alternative is that we do this with android app

I'm looking for a Google Sheets expert to help with the following tasks: - Implementing formulas for summing and averaging data - Applying conditional logic for data analysis - Setting up conditional formatting for better data visualization - Creating data validation rules for accurate data input - Designing custom charts and graphs for enhanced data representation. The ideal candidate for this project should have a strong background in Google Sheets and data analytics. Experience with complex formula implementation and data visualization is a plus. Being detail-oriented is crucial, as accurate data handling is a key aspect of this project.

Create a Mega menu type menu that will be copied from another website also made on Wordpress. The menu will be linked to the categories already created in wordpress. It should also have a minimalist design.

I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.

...analytic skills related to working with unstructured datasets. Experience with big data tools: Hadoop, Spark, Kafka, etc. Experience with data pipeline and workflow management tools. Experience with AWS cloud services: EC2, EMR, RDS, Redshift. Experience with object-oriented/object function scripting languages: Python, Java, Scala, etc. Proficiency in SQL and experience with relational databases, query authoring (SQL) as well as familiarity with a variety of databases. Excellent problem-solving skills and ability to work independently or as part of a team. Strong communication and collaboration skills to effectively work with teams across the organization. What We Offer: Competitive salary and comprehensive benefits package. Opportunities for professional development and career...

...management. Building a New Website from Scratch 1. Project Planning and Requirements Gathering: Define project goals, target audience, and website functionalities. Create a sitemap to outline the website's structure and content hierarchy. Gather user stories and requirements to capture desired features and user interactions. 2. Technology Stack Selection: Front-end: Choose a JavaScript framework (React, Angular, Vue.js) considering factors like project complexity, team expertise, and desired features. Back-end: Select a server-side technology (Node.js, Python with Django/Flask, PHP with Laravel) based on performance requirements, scalability needs, and developer familiarity. Database: Choose a suitable database (MySQL, PostgreSQL, MongoDB) based on data structure, quer...

I'm seeking a google sheets expert to design and set up a customized sales and expense tracking system for my start-up smoothie/juice outlet. - The system will primarily track weekly sales - The expense tracking should be moderately detailed, breaking down expenses into categories such as ingredients and utilities. - The ideal sheet will include forecasting models, particularly incorporating seasonal adjustments and growth rate calculations for sales. The freelancer should have: - Proficiency in Google Sheets, particularly in setting up automated calculations and formatting for ease of use and understanding. - Experience in financial modeling and projection, with specific experience in the food/beverage sector being a plus. I'm looking for a system that can ...

I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.

I discovered LM Studio and its server functionality but I didn't quite understand how to use API from external devices (tablets, smartphones)

I'm looking for a skilled individual to erase logo watermarks from a collection of approximately 700 JPEG and PNG principally images. Each image contains a watermark of medium complexity that needs to be professionally and thoroughly removed without compromising the quality and integrity of the image. Key Requirements: - Keen eye for detail to ensure complete logo removal - Ability to maintain the quality and integrity of the JPEG images Prior experience with similar projects will be highly beneficial. We split the project in 7 pack of 100 images to finish fastly Bid per a pack of 100 images

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.