Excel sql query based on cell value jobs
I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.
...platform game with gambling mechanics. - The central mechanic of the game should revolve around 'Winning Virtual Currency or Tokens'. - The virtual currency or tokens won in the game should have real-world value in the form of cryptocurrency. - Familiarity with Solana blockchain technology is a must, for the integration of the virtual currency. Ideal Abilities: - Excellent skills in blockchain technology, particularly Solana. - Proven track record in game development, specifically platform games with incorporated gambling mechanics. - Experience in designing games with real-world value virtual currency system would be a major plus. My objective is to create a unique, engaging, and exciting game environment where players can win real cryptocurrency. I look forw...
...but elegant. Team Leadership: As a seasoned engineer, you’ll mentor junior team members, foster collaboration, and drive technical excellence. Cloud Solutions: Familiarity with Azure or AWS is essential. You’ll architect, deploy, and manage cloud-based solutions. Data Import Strategy: Devise a robust strategy for importing data efficiently, ensuring data quality, and maintaining performance. Collaboration: Work closely with cross-functional teams, including data scientists, analysts, and product managers. Requirements Participate in a team-based Agile Scrum Environment: Supports design, development, implementation, and maintenance of software programming applications. Regularly participate in Agile ceremonies and assist in work sizing/estimation Participat...
I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry...contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such...
I want to Build an Android app where Shop owner can register and can create invoice and print the invoices through tharmal printer. I need someone who have knowledge on Billing can bid here. Send me complete details what feture you can provide me, Backend on Codeigniter 4
I have a virtual private server (VPS) running on Linux which is experiencing high CPU usage. This is bogging down the performance of the system and creating a productivity bottleneck. Job Scope: - Analyze the reasons for the high CPU usage - Implement efficient solutions to reduce the CPU usage without compromising on essential processes - Optimize the performance of the system - Establish measures for consistent monitoring and preventive maintenance Ideal skills: - Expertise in Linux server management - Proficiency in performance optimization strategies - Experience in IT troubleshooting and problem-solving - Knowledge of server security strategies - High attention to detail If you have the necessary skills and experience to resolve this server speed issue, I invite ...
Location: Trinity, North Carolina, 90% on-site (see info in the requirements section) Job Type: Freelance/Part-Time - Possibility for long-term assignments Employment Type: Contract – Project oriented This project is ideal for students and entry-level professionals. Involves assisting with product photography and videography for my new online store opening. If you have a knack for capturing stunning, unique images and are ready to bring your creative flair to my product range, I want to hear from you! Responsibilities: • Assist in setting up photography scenes with limited props, a trip(s) to purchase necessary items will likely be involved. • Provide guidance on lighting techniques, photography methods, and tips to capture the best images ...
As Pricing Strategy Manager, my focus is on enhancing revenue for my business through strategic pricing. Your role will be to craft and implement pricing strategies that align with our specific business objectives and market dynamics. Key Responsibilities: - Develop strategies that are designed to increase revenue. - Ensure that the pricing strategies are competitive, offering value to our target market. - Collaborate with other teams to understand the business needs and market trends. - Regularly analyze and review the effectiveness of the implemented strategies. Your work will directly impact our company's profit margins and market share, and your success will be measured by the revenue growth we see as a result of your pricing strategies. Ideal Skills and Experien...
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.
...create a chatbot whatsapp business integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal
...are: - User Authentication: This will be based on an email and password login system. The focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experi...
Work with ftp. Developer who can follow. Linking the value to the dropdown only
...produce engaging, informative articles. The focus will be on technology, with each article falling within the 1000-1500 word range. Requirements: - A flair for writing with at least a basic understanding of technology. - The ability to produce articles that are both informative and entertaining. - A good grasp of the English language. SEO optimization is required, but specific keywords won't be provided. This means you should be able to write in a way that naturally incorporates SEO best practices into the content. The articles are to be in a conversational, yet professional style. They should be well-researched and provide value to the reader. The goal is to keep the audience engaged while providing them with useful insights on the latest tech trends, innov...
...creating a LinkedIn company page and generating compelling content using tools like Photoshop to enhance our online presence. Responsibilities: LinkedIn Company Page Creation: Develop a professional LinkedIn company page that effectively showcases our services and engages our target audience. Content Creation: Produce captivating visual content using tools like Photoshop to accompany our posts on LinkedIn and other social media platforms. Client Acquisition: Proactively reach out to potential clients who require transportation or customs clearance services, establishing rapport and fostering long-term relationships. Promotional Strategy: Devise and implement innovative strategies to promote our services, leveraging both online and offline channels to maximize our reach. Client ...
We're a passionate team building a FinTech startup focused on helping early-stage FinTech companies acquire high-quality leads and accelerate growth. We're seeking a seasoned lead generation specialist to join us on this exciting journey. Project Details: You'll be responsible for crafting a comprehensive lead generation strategy targeting decision-makers within the FinTech space, specifically early-stage startups. We aim for a steady flow of qualified leads with in-depth information like Name, Email, Title, Company Size, Industry, Revenue Range, and Social Media presence. These leads will be nurtured through targeted email marketing campaigns and social media outreach. Ideal Candidate: We're looking for a freelancer with at least 3 years of B2B lead g...
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
Portal details: We are seeking a highly skilled Drupal developer tin developing our existing Case Management System into a modular and API-driven architecture. The project involves migrating from Drupal 6 to the latest version of Drupal while implementing a Model-View-Controller (MVC) pattern to enhance maintainability and scalability. Responsibilities: • Analyze the existing codebase to identify areas for modularization and API integration. • Design and implement modular architecture following MVC principles, ensuring clear separation of concerns. • Develop RESTful APIs to facilitate communication between modules, adhering to industry best practices. • Refactor and migrate existing functionalities into the new architecture, replacing hard-coded dependencies with AP...
...to create a quiz that can be embedded into a website page builder using their embed feature. The quiz should be manageable from my dashboard, the script will be on it's own domain. Key Aspects: - Creation: The plugin should enable the user to create quizzes. Please advise on the best quiz type to use. - Embedding: The plugin should allow for easy embedding into website pages or blog posts. Being able to place the quiz in a sidebar widget would be a bonus. - Interaction: I am open to different ways for users to interact with the quiz, either by clicking on options, typing answers, or selecting from dropdown menus. Your insights on the most user-friendly option are welcome. - Management: The plugin should provide an interface to manage the quizzes. Id...
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
Hello our company has built an online open banking payment gateway. I need people that have Lloyds, HSBC, NatWest, Barclays, Standard bank accounts. I will create a link for you with 12GBP value , i would like you to record a video of the full procedure while you are paying it and what difficulties and describe what difficulties did you face. You will get paid 25GBP for your work , (12 of your payment + 13 for your 3 precius minutes)
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
...task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strateg...
...project. You must mention "Dell" in the proposal in order to be noticed. Here is a brief for List of Features. 1. Invoice Currency Conversion using API and storing conversion rate in the database with date 2. Storing invoice value in base currency that is calculated based on conversion rate in the database so the total revenue is correct. 3. Invoice Custom Field Behavior changing, width of dropdown, custom field value and description 4. Invoice Total in Words in Customer Currency and Base Currency 5. Testing possibility to integrate Amazon S3 for file storage on Perfex CRM 6. Project Overview Screen, Task Details, Billing Calculations Customization. 7. Notifications Screen Customization for Mobile View 8. Notification integration wi...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extr...in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like...
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
...controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic controller that can dynamically handle all tables within the database. This approach requires sophisticated coding to manage CRUD operations generically across all tables. 3. Metadata-Driven Arch...
For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.
...refer their github repo. When anyone scans the qr code on the card they would be taken to a page where it says a thank you for using this card you will be redirected in a few seconds. 3. Once they log in they can create a digital profile page something along the lines of this repo on github enbizcard. They generate html files and is not easy to edit any details. In this site if the user comes back to edit any details they need to create the profile from the scratch. i want the details to be editable at any point of time. Once the profile is created it would be available for public access on a url like No body but the logged in user can only be allowed to edit the profile. 4. I want the usersite In url to be a hash value of the user and not the username as...
I need a skilled cameraman equipped for studio-style shooting of a leadership and management course. Ideally, you have experience in educational or instructional video capture, with a strong understanding of the balance between value content and compelling presentation. Here's what I’m looking for: - Filming in a studio interview-style setting - Utilizing a 4K camera for a high definition recording - Equipped with professional audio equipment for clear & crisp sound - Able to provide lighting setups for interviews would be a plus You may need to assist with scene setup to ensure the final output encapsulates a professional and conducive learning environment. Knowledge of teleprompter operation is beneficial though not mandatory. Your ability to edit the video for t...
I am searching for a professional, capable of accessing and securing contact details of a policy advisor in the Prime Minister's Office. If you have extensive experience and sound connections within governmental institutions, your expertise would be of great value. Key responsibilities include: - Information gathering, particularly contact details - Networking within the Prime Minister's Office The ideal person for this job must have: - Proven experience in governmental networking and information gathering - Credible connections within the Prime Minister's Office - A track record that demonstrates discretion and professionalism Please note that this task requires strict confidentiality and adherence to all relevant laws and regulations.
I'm in need of a competent and experienced researcher to create a case study that analyses the effectiveness of a particular military training approach. Key Deliverables: - The case study must be well-researched, objective, and focus solely on the training effectiveness. - It should engage the reader, providing valuable insights and conclusions that can be drawn from the analysis. - The audience for this case study will be military personnel, so experience in creating such content is highly advantageous. Ideal Skills and Experience: - Strong research and analytical skills, preferable in military training methodologies and practices. - Ability to craft engaging and informative content. - Prior experience with case study writing, particularly those aimed at military professi...
...specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth analysis so your att...
I am looking for a talented and experienced claymation artist to design a unique, realistic, and engaging human-like character, primarily for en...and engaging human-like character, primarily for entertainment purposes. Key Responsibilities: - Design and create a claymation character that mirrors human characteristics and features - Render the character in a realistic fashion, with attention to detail and accuracy - Should possess an exceptional creative flair, keeping the entertainment value high Ideal Candidate: - Proven expertise in claymation - Strong portfolio demonstrating a focus on realism and detailed work - Exceptional creativity and innovation - Experience in entertainment-centric projects would be favourable Looking forward to witnessing your unique vision ...
I'm in search of a talented developer to create a web-based CRM system for my business. Here's what I need: - The CRM system should be accessible through a web browser. - Its primary function will be sales tracking. I want a solution that will help me monitor and manage sales effectively. I envision the CRM system to perform sales tracking in the following ways: - By individual salesperson: The system should show the performance of each salesperson. This way, I can analyze their work, reward high performers, and provide feedback to those who need improvement. - By team: It should also provide an overview of each sales team's performance. This will help me assess the overall productivity and effectiveness of my salesforce. - By product/service: The CRM system shou...
I'm seeking a skilled financial analyst to prepare a detailed report on Company C's financial health. The primary goal of this analysis is to provide insights on the company's performance and help in making well-informed recommendations. Key aspects to emphasize in the report: - Revenue growth: A clear picture of the company's revenue trends. - Profit margins: Analysis of the company's profitability and how it compares to industry standards. - Debt levels: Understanding the company's debt situation and its potential impact on future performance. - Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysi...
I require a webpage which will primarily serve to display information by filtering it. Key functionality would involve options to add, remove, edit the items (by me only). Most importantly to filter them by anyone visiting the website. The items are filtered by multiple tags that the items should have, they can have 0, 1, 2 or many of th...should have, they can have 0, 1, 2 or many of the same “category” types. They also need to have categories for easy separation. The webpage will have roughly 100-200 items. More detailed information can be given privately. This webpage is for personal and group of friends use, not professional. The items themselves will consist of an icon of the item (32x32 pixel) and will follow the information on the items for the remaining 95% ...
...interface that works flawlessly on the TradingView platform and setup the stock indicators below the chart. I want the scan results calculated using a one hour period and one month time range to pinpoint when the PPO line is about to cross or has just crossed the PPO signal line and the +DI line is about to cross or has just crossed the -DI line. The indicators are below the stock chart in the order of PPO, ADX, Williams% R, Full Stochastics %K, ATR, RSI, Accumulation / Distribution and MFI. The stock chart will show the EMA(9) and the EMA(15), candlesticks and the Parabolic SAR. Also, I would like an alert sent to my cellphone when a stock meets the criteria above. Here is the script I have used with StockCharts where x means crossed over the value listed after t...
I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling be...
I need help with Freelancer who is based in Oman only...So bid accordingly....
I am seeking to create a marketplace using Magento for selling beauty and cosmetics from various brands. This platform will be complete with various essential features, comprehensive affiliate module, and multiple payment methods. - Marketplace Features: The site should contai...- Affiliate Module: The marketplace will also need a robust affiliate module with functionalities including affiliate tracking and reporting, commission and payout management, promotional tools and banners, alongside a recruiting program. The ideal freelancer for this job would have excellent experience in Magento development, payment gateway integration, and affiliate marketing. Having worked on similar projects such as marketplaces or affiliate systems would be a plus. I look forward to receiving your ...
I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.
...again supply the username and password via command line. - The solution should include a set of servers to run both backend and frontend services. I want to be able to make a small change in the script to scale up or down the number of servers. This servers need to run AWS Linux, Java 21, node js 12, and datadog agent. We will start with 1 EC2 instance but as I said I want to be able to change that value and scale up (or down as needed). - The EC2 instances need to upload a config file for Datadog agent, part of this we need to supply the datadog api_key, which will be supplied in the command line via variables. The script needs to update that key in the datadog config file. - There are also a few directories which need to be created under /etc/datadog-agent/conf.d/ and files ...
I'm looking for a proficient sales representative to sell my services. Mandatory Skills: - Exceptional customer service - In-depth technical knowledge - Superior negotiation skills - Perfect English and Spanish is a must! Compensation Strategy: The chosen representative will be paid on an hourly basis. Experience in selling services is a must, as they will need to convincingly communicate the value of our offerings. The ideal candidate should be able and ready to handle client inquiries effectively and meet the sales objectives. You must be able to thrive in customer service, possess technical knowledge, and have leading negotiation skills. Your experience will reflect your understanding of client needs and help meet our business goals.
Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India
...landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulated by central authorities, Bitcoin is governed by a network of nodes that collectively validate and record transactions on a public ledger known as the blockchain. The Mechanics of Bitcoin At its core, Bitcoin is a digital asset that can be exchanged and transferred electronically. Each Bitcoin is represented by a unique cryptographic code stored on the blockchain, which ensures the integrity and security of the network. ...
