Convert excel vba sql jobs
I'm looking for a proficient Python developer who can create 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 ...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 Budget is 30 usd it could lead to long term Please feel free to propose what you think wo...
I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.
I have an Excel sheet locked with input data that needs adjustment for proper calculations. The sheet is primarily for data analysis. Key Tasks: - Unlock the sheet to facilitate modifications - Adjust specific numbers to correct data input errors - Modify calculation formulas to ensure accurate outcomes Ideal Skills and Experience: - Proficiency in Excel, including unlocking sheets, modifying data, and adjusting formulas - Strong attention to detail to identify and correct data input errors - Experience in data analysis to understand the context and purpose of the adjustments
I need mixed data (text and numbers) from a PDF entered into an Excel spreadsheet. The ideal freelancer should be proficient in data entry, have excellent attention to detail, and be experienced in working with both PDFs and Excel. Key Requirements: - Entering mixed data (text and numbers) from a PDF into an Excel spreadsheet - Formatting the data into standard tables - Applying conditional formatting as per the requirements Please ensure you have a strong understanding of how to implement conditional formatting in Excel, as this will be a crucial part of the task.
I need my logo, which is currently in JPG format, converted into an AI vector format. Additionally, I require various color schemes for the logo. - Color Variations: I would like to see different color schemes for the logo. The logo should look ok on a white/gray/black background. - Color Suggestions: I'm open to suggestions for the color codes. Ideal skills for this project include proficiency in Adobe Illustrator, graphic design expertise, and experience with logo/vector conversion.
I need a skilled professional to convert my Photoshop PSD logo file into an SVG version 1.0 or 1.1. The final file size must not exceed 15 kB with the background removed. The primary use of this SVG logo will be for a website, so it is crucial that the logo is accurately converted to maintain its quality and scalability for web use. Ideal Skills and Experience: - Proficiency in Adobe Photoshop and SVG file formats - Experience in graphic design and logo conversion - Ability to ensure file size limitations are met without compromising quality
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 looking for a proficient Python developer who can create 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. T...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 think wo...
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 creating interactiv...
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 ...
Change website so that this good readable on all devices like mobile telephone.
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
I'm looking for a professional to help with my financial record-keeping. The project involves organizing my invoices into PDF format for easy storage and retrieval. Key Requirements: - Convert invoices into PDF format - Ensure all PDFs are searchable Skills and Experience: - Proficient in PDF creation software - Attention to detail - Experience with financial record-keeping
I'm looking for a professional illustrator with a strong portfolio and experience in creating clean, sami realistic colored line-art designs for one of the chil...illustrator with a strong portfolio and experience in creating clean, sami realistic colored line-art designs for one of the children's books i am making about my father. Attached you'll find the original illustration and images of my father Please keep the entire scene exactly the way it is. I need to only replace this old man’s face (the one who is cooking) with this new face attached Key Tasks: - Convert a provided photo into line-art - Alter a face in a pre-existing storybook illustration Ideal Skills: - Strong artistic skills - Experience in creating engaging line-art - Attention to detail - A...
I'm looking to convert my 32x28 detached garage into a modern-style guest house. This ADU (Accessory Dwelling Unit) will serve as a guest house primarily, so it needs to be comfortable and functional. Key Features: - The ADU should contain a kitchenette, bathroom, living area, and a small office space. - The interior design should lean towards a modern aesthetic. Ideal Skills: - Experience in garage conversions. - Expertise in modern interior design. - Knowledge of building codes and regulations for ADUs.
...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 interface...
I need a professional to convert my PSD/PSB logo into Adobe Illustrator's vector format. The logo needs to be pure vector and saved in 3 layers. Details: - No modifications to the logo are required, just a straight conversion. - The primary use for the logo will be on digital platforms, so it should be optimized for that. - I want to retain the original colors of the logo, so no additional color versions are needed. Ideal candidates for this project are professionals with extensive experience in graphic design, specifically in converting files to vector format. Proficiency in Adobe Photoshop and Illustrator is a must. This should take an experienced person only a few minutes. Logo is in the below link
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 skilled translator to convert a variety of creative documents from English to Spanish. This project demands not just language skills, but a keen understanding and appreciation for creative content. Your translation should capture the tone, style, and intent of the original documents. Prior experience with creative content is highly valued.
Seeking a professional in Greece to convert my novel into ePub and Mobi formats. Requirements: - Convert my novel into ePub and Mobi formats - Format the e-book for Kobo compatibility Ideal Freelancer Skills: - E-book conversion - Familiarity with Kobo formatting requirements
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 made drawings in a picture to illustrate changes in my house design. I want YOU to make a PROFESSIONAL drawing of this, so it can be used as documentation in a building prossess. Please draw the building with all of the table covering on the walls horizontal, not vertikal. The final result should be stored as both .jpg and .pdf files.
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
I'm seeking a dedicated sales professional to promote my accounting software and bookkeeping services targeting the Finance sector in the UK, USA, Canada, Australia, and South Africa. Key Responsibilities: - Implement an email marketing strategy to reach potential clients - Convert leads to direct sales through effective communication and persuasion skills Ideal Candidate: - Proven experience in sales, specifically in the Finance industry - Proficient in email marketing strategies - Excellent communication and persuasion skills - Experience selling software preferred
I'm seeking a WordPress developer to convert my design into a 3-4 page minimalist business site . Ideal Skills: - WordPress expertise - Minimalist design implementation - Converting designs into WordPress pages Please note, WooCommerce need to be add to it, However, I expect the developer to have a good understanding of standard business blog features and SEO best practices. The primary purpose of the blog is to serve as a platform for my business.
I'm in search of a proficient travel agent who can attract and convert clients to book our variety of tours. Our offerings span across adventure, cultural, and relaxation tours, catering to a wide target audience including solo travelers, couples, and families. Key Responsibilities: - Utilize travel forums and email campaigns to target potential clients. - Convert leads into bookings for our tours. Ideal Skills and Experience: - Previous experience as a travel agent is highly preferred - Proficiency in email campaign strategies and travel forum engagement - Exceptional interpersonal and sales skills - Ability to cater to a diverse audience. Pay :$20000-$30000 annually (On commission)
I'm looking for a proficient Python developer who can create 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. T...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 think wo...
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 in need of a CAD professional who can convert a 2D CAD drawing into a 3D CAD drawing using SolidWorks. The final 3D model needs to be identical to the 2D drawing, as it will be used for manufacturing purposes. Key Requirements: - Convert a provided 2D CAD drawing into a 3D CAD drawing in SolidWorks. - Ensure the 3D model is an exact replica of the 2D drawing. - Deliver the final 3D model in DWG format. - Provide 2D cross sections at specified parts, to be discussed later. Ideal Skills and Experience: - Proficient in SolidWorks. - Experienced in CAD drawing conversion. - Able to deliver precise and high-quality 3D models.
I'm looking for a proficient Python developer who can create 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. T...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 think wo...
I need a skilled professional to convert my 2D AutoCAD drawings into a 3D video mockup for architectural visualization purposes. The mockup should cover: - The exterior façade - The interior layout - The landscaping and surroundings The level of detail required in the 3D video mockup is basic shapes and textures. Ideal skills for this job include: - Proficiency in AutoCAD and 3D modeling software - Experience in creating architectural visualizations - Ability to work with basic shapes and textures Similar to the below:
I need a mechanical engineer to convert a 3D model of a skate-ramp into 2D production drawings using. The 3D model is in STEP format. We have a deadline for today (Sunday) evening central european time so only engineers who are available directly for the full day can apply. Key Requirements: - Conversion of the 3D skate-ramp model into detailed 2D production drawings - Proficiency in using AutoCAD or solidworks for creating the 2D drawings - Inclusion of dimensions and tolerances in the 2D drawings - Attention to detail to ensure all dimensions and tolerances are accurately represented Ideal Skills and Experience: - Strong background in mechanical engineering - Extensive experience with AutoCAD or solidworks - Previous work involving creating production drawings from 3D models - ...
...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...
...geospatial data and related solutions, we believe your support will ensure the project's success. Project Overview: • Objective: To convert and integrate existing GIS layers into a PostgreSQL database. • Scope of Work: 1. Analyze the provided GIS layers to determine compatibility and necessary preprocessing. we have a white listed ip (tunnel) that allow us to access MapsServers and Features Servers in the browser. 2. Convert the GIS layers into PostgreSQL format, including relevant spatial indexing. 3. Ensure data integrity, performance optimization
...developer to extend this cursor with 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 fo...
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.
I'm looking for a professional graphic designer who can take my existing logo and transform it into a high-quality vector format. Key Requirements: - Convert my current logo into a vector format without altering its classic style. - Deliver the final product in a clean, modern and minimalist aesthetic. - Ensure the redesigned logo is suitable for a wide range of applications, from business cards to billboards. Ideal Skills: - Proficiency in Adobe Illustrator or equivalent vector software. - Strong understanding of modern, classic, and minimalist design principles. - Excellent attention to detail and a passion for quality.
I'm looking for a professional translator to convert my 6-page French school report into clear, general English. - Purpose: The translation is intended for academic use. - Adaption: I need the translation to be adapted to more general English, rather than retaining the original terminology or translating into academic English. - Certification: A certified translation is required. Ideal candidates for this project should have a strong background in translation, particularly from French to English, with experience translating academic documents. Certification as a translator is mandatory for this job. Your ability to produce a clear, accurate, and certified translation will be crucial for the successful completion of this project.
...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 ...
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 have a design for a logo for my hot sauce brand. The logo is currently in raster format (JPEG, PNG) and I would like to keep the current color scheme. I am looking for a graphic designer who can: - Refine my existing logo design - Convert it from a raster to a vector format - Provide the final design in multiple formats for print and digital use Your portfolio should demonstrate: - Experience with logo design, particularly in the food industry - Ability to work with existing designs - Proficiency in vector graphic software Please reach out if you believe you can assist with this project.
python code to Pine Script convert a Python trading indicator into TradingView PineScript.
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...
I'm looking for a seasoned writer with a strong grasp on technology and a professional writing style to pen 60 blogs a month, each around 1000 words. K...and a professional writing style to pen 60 blogs a month, each around 1000 words. Key Requirements: - In-depth understanding of the technology sector, especially in areas like Artificial Intelligence, Cybersecurity, Gadgets and Reviews - Exceptional content writing skills to create engaging and informative pieces - Proficiency in SEO to ensure the blogs reach a wider audience - Capability to convert images and data into infographics for blog inclusion - Experience in data entry and assignment writing Your writing should always maintain a professional and formal tone. Please provide samples of your previous work in the te...
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
