Excel vba sql based column valuepekerjaan

I am trying to create a script that counts stock chart candles that are above or below a certain value. specifically, I want my script to sequentially count candles once they are above the 9 simple moving average. When the candle eventually closes below the 9 sma, I want those to be counted also my current script isnt perfect and occasionally give repeating numbers plot(close) indicator("Candle Count", overlay=true) // Source for SMA calculation source = close // Calculate the 9-period SMA sma9 = (source, 9) // Variables for counters and tracking state var int aboveCount = 0 var int belowCount = 0 var bool isAboveSMA = false var bool isBelowSMA = false // Check if the body of the candle (open and close) is above or below SMA and handle counting if close > s...

La persona deberá automatizar todas las bases de nomina y prestaciones sociales de los colaboradores en excel

I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, th...

I'm seeking a skilled Webflow designer to create a site for my service-based business. The primary aim of the site is to promote our services to potential clients. Key Features: - A user-friendly booking system: This should allow clients to easily schedule our services. - Detailed service descriptions: Each of our services should be well explained to inform our clients. - Client testimonials: A section dedicated to showcasing our satisfied customers to build trust and credibility. The ideal freelancer for this project should have: - Extensive experience with Webflow: You should be able to translate our business needs into an engaging and interactive website. - A knack for service-based website design: You should understand the unique elements that such a site requires...

I'm have given interview for a job interview and need a compelling value proposition slide that emphasises my unique leadership skills and experience to secure the job Specifically, I would like to highlight: - Team Management: My experience and effectiveness in leading diverse teams. - Strategic Planning: My ability to foresee and prepare for future challenges. - Conflict Resolution: My skills in navigating disagreements and fostering a harmonious working environment. The target audience for this slide is the hiring manager. I'm looking for a freelancer with experience in creating impactful presentation slides, preferably for job interviews. Knowledge of leadership principles and their effective presentation is a plus.

I'm looking for a proficient Python developer who can create a script for m...a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you t...

I have a set of 69 KPIs in an Excel sheet, spanning across 10 projects. I need a performance formula that will automatically provide the KPIs/projects status based on specific thresholds. It's important to note that some of the KPIs are negative metrics. In addition, I require an interactive dashboard for these KPIs. The entire project is in Arabic. Key requirements: - Devise a performance formula that can assess the KPIs/projects status based on predetermined thresholds - Create an interactive dashboard in Microsoft Excel - Understand and cater for negative metrics within the KPIs - Project is in Arabic, hence understanding or capability to work in Arabic is a plus Ideal skills and experience: - Proficient in Microsoft Excel - Experience in creat...

I need a freelancer to calculate the standard deviation of a small dataset stored in a text file. The dataset has only one column. Ideal Skills: - Proficiency in statistical analysis - Experience with data manipulation - Familiarity with standard deviation calculations Please have access to either Google Sheets or Excel for this task.

Emerging Market Bond Data Extraction Project overview Extraction of trading data for sovereign bonds from specified countries over the last 30 trading days, replicating the structure of an example Excel file. Data needs - Data extraction for last 30 trading days of sovereign bonds from Kenya, Burkina Faso, Sao Tome and Principe (São Tomé-et-Príncipe), Ghana, Liberia, Zimbabwe, Peru, El Salvador, Sierra Leone, and Namibia. - Platforms that may be used include Cbonds, Bloomberg, Refinitiv Eikon, or Market Axess, etc... - Specific data columns required: issue (bond name and detail), date, time of last trade, stock exchange, bid, ask, bid ask spread, min, high, close, indicative and indicative type, volume of transactions in monetary units at par, volume of trans...

I'm looking for a freelancer who can enter data from an Excel sheet into my e-commerce website. This task involves working with electronics products and requires attention to detail and technical understanding. Key Responsibilities: - Enter product data from Excel(upto 5K data) into the website. - Include all necessary product descriptions, focusing on technical specifications and usage instructions. - Upload product images alongside the descriptions.

I need assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so ...assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so some preliminary data processing may be needed. Skills and Experience Required: - Extensive knowledge and experience with Magento is essential. - Proficiency in data processing and Excel is required, as the product information will need to be formatted for Magento. - Attention to detail is critical to ensure all product information is uploaded ...

I'm seeking assistance in creating an Excel spreadsheet dedicated to customer data entry. The primary focus will be on tracking customer contact details. Key Requirements: - Proficient in Microsoft Excel - Experience in data entry - Ability to maintain accuracy and confidentiality Ideal Skills: - Data Management - Attention to Detail - Proficiency in Excel Functions and Formulas

We are seeking a highly experienced and professional Property Manager to oversee the operations of our residential and/or commercial properties. The ideal candidate will be responsible for ensuring efficient property management, maintaining tenant satisfaction, and maximizing property value. Key Responsibilities: Manage day-to-day property operations, including leasing, maintenance, and tenant relations. Screen and approve tenants, handle lease agreements, and ensure timely rent collection. Coordinate property maintenance and repairs, ensuring compliance with safety and regulatory standards. Prepare and manage property budgets and financial reports. Conduct regular property inspections and enforce lease compliance. Provide excellent customer service to tenants and respond promptly...

...African client base, with a primary focus on: - Document storage and retrieval - Workflow automation - Permission management The DMS should be affordable and designed with ease of use as the most critical aspect. The successful freelancer will have experience in developing user-friendly web-based applications. A deep understanding of document management systems and their core functionalities is essential. Key Requirements: - Proven experience in DMS development - Excellent skills in creating web-based interfaces - Strong focus on ease of use in design - Understanding of localization for African markets - Ability to build an affordable yet robust system Your proposal should demonstrate your relevant experience and ability to deliver a user-friendly, localized DMS that m...

...code for a program which needs to be completed if there are any missing pieces. 2. You'll be responsible for programming the database, which will be SQL Server. 3. Finally, the completed program will need to be uploaded on a server, where you will also run it. The code might need improvement in the following aspects: - Functionality/features - User interface - Error handling and debugging Part II: Apps Developer I need skilled apps developers to create Android and iPhone apps based on the aforementioned program. Ideal skills and experience for the job includes: - Proficiency in Dotnet programming - Extensive experience with database SQL and MySQL Servers - Strong skills in Android and iPhone app development - Able to improve code functionality and user in...

...ambiguity. Our customers embrace clarity in their choices, expressing who they are unapologetically. * Breaking Monotony: Moving away from bland, uninspired fashion. Every design is a celebration of creativity and courage. * Empowering Individuality: Each piece is a tool for self-expression, allowing wearers to own their style and voice their values. Target Audience * Individuals aged 20-40 who value personal expression and bold fashion choices. * Creatives, innovators, and forward-thinkers who are not afraid to stand out. * People seeking high-quality garments that combine unique designs with a meaningful message. Brand Pillars 1. Originality: Designs that challenge the norm with bold patterns, vibrant colors, and distinctive cuts. 2. Expression: Garments that allow wearers to...

I have over ten Excel files containing sales figures organized by product. All these files have the same format, making them straightforward to merge. I'm seeking a freelancer who can expertly consolidate these files into one comprehensive total sheet. Ideal Skills: - Proficient in Excel - Data Analysis - Attention to Detail - Experience with Data Consolidation

I'm seeking a designer who can create an icon-based, minimalistic logo for me. The logo should reflect a strong sense of creativity, as this is the key message I want it to convey. Key Requirements: - Experience in minimalistic, icon-based logo design - Strong understanding of conveying messages through design - Ability to interpret and translate the desired emotion (creativity) into a visual form In addition to the logo, I would also like to have some animations and video materials created based on the logo. Therefore, skills in animation and video production are highly desirable.

I need column AB from this list created - email addresses for the people in each row

Project Description Room Rental System: A web-based application where users can browse, list, and book rental rooms. The system includes features like user authentication, room management, search and filters, a booking system, payment integration, and an admin dashboard for management. Built Points Frontend: Framework: React.js UI Library: Polaris or Material UI Features: User-friendly interface for browsing rooms. Room details with images and descriptions. Authentication pages (Login/Sign-up). Dashboard for user and admin functionalities. Backend: Framework: Node.js (with ). Features: User authentication using JWT. APIs for CRUD operations on rooms. Booking management. Payment integration (Stripe or Razorpay). Database: MongoDB (MongoDB Atlas for cloud hosting). Collections:

I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience in creating billing or...

I need this list data scraped for personal emails Scrub1 list worksheet ~3500 lines Column AB in pink

I need a meticulous professional to assist with data entry from scanned documents. The data consists of both text and numbers, and needs to be accurately transferred into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Excellent attention to detail - Prior experience with data entry from scanned documents - Ability to handle mixed data types (text and numbers) - Strong organizational skills

Tengo experiencia en auxiliar administrativo. Recepción de llamadas , emails, asesoría , conocimiento en office , Excel , Word entre otro. Conocimiento en programas de inventario . Resolución de problemas y pqr

Link Posting (Bilingual: English and Chinese) Publish 20 SEO-optimized links daily on our website using the provided affiliate marketing materials. Ensure each link complies with SEO standards, embedding relevant keywords and descriptions. Provide detailed descriptions for each linked tool, including: Tool introduction. Feature breakdown. Free usage details. Paid usage details. Application scenarios. Blog Writing (Bilingual: English and Chinese) Write 2 high-quality blog posts daily, focusing on either the website's overall theme or specific tool-related topics, and ensure compliance with SEO requirements. Each blog post must be at least 1000 words, with appropriate images (we will provide the image resources). Task Requirements: High-Quality Blog Articles: Articles should center arou...

Attached is a concept. It is based on a picture of Petco Park in San Diego, CA (where the Padres play). I would like to keep some sort of Southern California vibe to the logo. Specifically palm trees and it would need to make sense with the name of Ballpark Storage (which is a local play on a company of the same name that rents short term storage units near Petco Park). Any elements of the local references would be highly desired. I would like two logo's (with one variation each). One logo black/white (with the names "ballparkstorage" and "ballpark-storage") and one color with the same two names. Thank you in advance and if you have any questions please don't hesitate to ask. I'll be near my PC and/or phone until we finish up.

I'm seeking an experienced graphic designer for developing a minimalist logo and tailored custom illustrations. The scope of ...logo and tailored custom illustrations. The scope of the project involves: - Crafting a unique, minimalist logo - Creating custom illustrations to complement the brand The ideal candidate should have: - Proven experience in logo and branding design - A strong portfolio of minimalist designs - Excellent skills in creating custom illustrations As a detail-oriented and creative professional, I value open communication and a collaborative approach. I am looking for a designer who can understand and translate our brand’s vision into impactful visual elements. Ultimately, I am aiming for a cohesive, professional brand identity that resonates with o...

I need 3 to 4 A-grade product photos that match the premium quality of my product, priced at $129 AUD. The goal is to create stunning, professional images that convey value and quality. Requirements: 1. Backgrounds: • I have photos of my product and a real-life beach sand image. I need my product seamlessly placed on the beach background. • Alternatively, you have the creative freedom to design a better, more professional background if it elevates the visuals. 2. Detailed Feature Graphics: • Highlight key product details (e.g., fabric type: 210T polyester, reinforced stitching, buckles, zippers). • Include “blow-up” graphic elements, like zoomed-in callouts, to showcase these features clearly and attractively. 3. Professional Touch: • En...

I'm looking for a proficient Python developer who can create a script for m...a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you t...

...fostering positive tenant relationships, overseeing property upkeep, managing leases, and ensuring optimal occupancy levels. A strong aptitude for organization and multitasking is crucial for this position. Familiarity with property management software and local housing regulations will be advantageous. If you have a successful history in property management and a commitment to enhancing property value, we would love to connect with you! **Key Responsibilities:** - Review and rectify discrepancies in client property details - Advertise and promote properties on various partner platforms - Coordinate and manage property calendars effectively - Address account inquiries and manage bookings - Maintain a high booking acceptance rate by keeping guests informed about property availabi...

I am seeking motivated individuals to help expand my advertising network on a global scale. Evolution Advertising Network is offering a lucrative commission-based job where you can earn a 45% commission for every client you bring onboard. Ideal Candidates Should: - Target diverse sectors: This includes small businesses, large corporations, and non-profit organizations across various industries such as retail, hospitality, and health and wellness among others. - Operate on an international level: The goal is to reach clients from all corners of the world. Skills & Experience: - Experience in sales or client acquisition is highly desirable. - Strong communication and networking skills. - Ability to understand and target different industries. - A global perspective and willingn...

I need assistance with an Excel task. The project involves adding rows in Excel based on a specified number in a cell. Key Requirements: - Adding new rows containing specific formulas - Ensuring that the formulas in the new rows reference fixed cells Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in working with Excel formulas - Detail-oriented with a good understanding of fixed cell references in Excel

I'm looking for a proficient Python developer who can create a script for m...a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you t...

I'm looking for a graphic designer who can create professional-style YouTube thumbnails for my educational and tutorial content. Key Requirements: - Expertise in graphic design with a strong portfolio of YouTube thumbnails - Ability to understand and visually represent educational content - Skilled in creatin...educational and tutorial content. Key Requirements: - Expertise in graphic design with a strong portfolio of YouTube thumbnails - Ability to understand and visually represent educational content - Skilled in creating minimalistic yet professional designs - Timely delivery to align with my content schedule Your designs will play a crucial role in attracting viewers and enhancing the educational value of my channel. Experience with YouTube's design requirements a...

I need a Pyspark code that reads join rules from a txt file and applies them in the main program. The joins will be based on multiple columns, with the rules formatted as column names with conditions. The code should only implement inner joins. Ideal candidates should have comprehensive experience in Pyspark, understand how to manipulate data frames, and can write clean, efficient code.

...realistic oscilloscope image based on a int entry value. At the end this function will be crucial for a mini-game where players must determine the correct value by interpreting the generated oscilloscope image. Key Requirements: - Create a realistic oscilloscope image - Integrate grid lines and waveform amplitude into the display - Ensure the function is callable by blueprint Ideal Skills: - Proficiency in UE5.5, particularly with blueprints and C++ - Experience with game development and designing interactive elements - Understanding of realistic graphical styles - Ability to create engaging and intuitive user interfaces The oscilloscope should include grid lines and display waveform amplitude. There is no interaction, only generated image from a entry value...

...creating compelling social media posts that resonate with target audiences. In addition to my writing expertise, I offer video editing and creation as a secondary skill, allowing clients to develop content from script to screen. My experience spans editing explainer videos, social media content, and ads, allowing for a seamless process that strengthens your brand’s message. As a Virtual Assistant, I excel in efficiently managing administrative tasks, from email management to digital marketing. My expertise in social media marketing is particularly beneficial for managing e-commerce sites and ad campaigns, boosting conversions and brand visibility. I’m committed to delivering exceptional service, ensuring every project meets the highest standards. Let’s collab...

I'm an individual start-up seeking a dedicated team for ongoing maintenance and updates for my Flutter-based app, DropIn Surf. The app employs a Firebase backend, Google Maps API, and a Flutter-built admin panel. - The app's user interface and experience require the most attention. - The code can be complex, so I'm looking for someone flexible, patient, and capable of adjusting, fixing errors, and debugging as necessary. - As a start-up, budget is crucial. Ideal candidates would have extensive experience with Flutter, Firebase, and Google Maps API, with a knack for UI/UX improvement. I value a friendly and cooperative working relationship, with a team who understands the needs of a start-up. Please note that I have not yet determined a specific method for ...

...additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsheet. • Update a different table using simple IF conditions based on the calculated values. • Ensure the solution is optimized for minimal databa...

I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.

Project Title: Real Estate Cashback Platform Project Overview: This platform is designed to revolutionize the real estate industry by streamlining property sale registration while offering tangible benefits for buyers, developers, companies, and freelancers. It enables property buyers to receive 1.5% cashback of the property value directly into their digital wallet, accessible via a unique barcode. This cashback can be used freely, giving buyers greater flexibility and value. The platform also provides a legally compliant and efficient solution for developers and freelancers to register property transactions, ensuring transparency and accountability throughout the process. Key Features: For Developers and Real Estate Companies: Seamless Registration: Register as a verifi...

...with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Ideal skills and experience: - Extensive experience with Microsoft ...

...world’s first Simplified AI Agent Management Platform, designed to empower users by removing the burden of repetitive, labor-intensive tasks. DelegateX allows users to delegate their work to customized AI Agents—your X Bots—freeing up your time to focus on what truly matters. We are seeking design professionals to create a compelling brand identity that reflects our vision, highlights our unique value propositions, and inspires trust and excitement among our diverse audience. Challenge Goals We aim to establish a brand identity that: 1. Communicates Empowerment Through Delegation • Showcase how DelegateX enables users to “leave their worries behind” and delegate tasks to AI agents across various domains. • Examples include campaign me...

I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.

I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirem...skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data r...

telegram to excel btc and others coins

I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros

...secure AWS-based backend architecture that ensures seamless data ingestion, transformation, and real-time interaction with our website. Key Responsibilities Data Ingestion Schedule Python scripts using AWS Lambda to fetch data from APIs. Handle API rate limits, errors, and retry mechanisms. Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw data for further processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformatio...

...throughout the transaction process, addressing any issues or delays promptly. Maintain meticulous records and follow up to ensure smooth deal closures. What We’re Looking For We value creativity, organization, and professionalism. The ideal candidate will: Have excellent communication skills (both written and verbal). Be confident making outbound calls and thrive on building connections. Possess a knack for design and marketing (experience with Canva and Constant Contact is a plus). Demonstrate exceptional organizational skills and attention to detail, especially when coordinating transactions. Be self-motivated and excel in a remote environment. Have interest or experience in real estate (wholesaling or transaction coordination experience is a bonus!). Why Join Us?...

My web-based driving school management system built on PHP is facing some issues that need urgent attention. Ideal Skills and Experience: - Extensive experience in PHP development - Proven track record of troubleshooting web-based systems - Ability to improve system performance and user experience Please note, specific issues with the system have not been identified yet, and it would require a thorough examination of the system to determine the exact problems. The primary users of the system are students, instructors, and administrators.