How to extract data from oracle database into excel using vba jobs
ShiftScale Digital is seeking a highly skilled and detail-oriented Product Data Management Specialist to join our team. The ideal candidate will be responsible for managing product data imports, edits, updates, and more for Shopify and WooCommerce sites. This role requires expertise in efficiently managing and manipulating data in Excel, building out product catalogs, and creating relationships between products. The candidate should also be proficient in scraping data from vendor websites and formatting it correctly for website display.
...need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to c...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase thei...
...The ideal bot should be able to perform several functions: - IS A MUST TO KNOW WHAT IS QUEUE-IT SYSTEM - Search and display available tickets - Add tickets to cart and checkout - Send notification when tickets are available - Simultaneous requests : send multiple requests at once to increase chances of securing tickets - Queue management : handle queue-it system's virtual waiting room effectively, maintain session and user states to handle queue redirects - Human Simulation : mimic human behavior to avoid detection (randomized request intervals) - Technical requirements - use session management and different proxies/ips, implement captcha solving techniques or third-party captcha services if there is any available captcha yet to be ...
I'm seeking a seasoned professional to carry out a web penetration test on my website, with a specific focus on database security. I aim to ensure that potential vulnerabilities in this area are identified and addressed before they can be exploited by malicious entities. Key Responsibilities: - Conduct thorough database security testing to identify potential vulnerabilities - Provide a comprehensive, detailed report of your findings, which should be easily understandable even for non-technical stakeholders - Offer recommendations for improving the security of the database, along with a strategy for implementing these changes - Adhere to the highest ethical standards in the industry, ensuring your approach aligns with the best practices...
I need a single form to register two different types of users on my wordpress website. See the attachment. I'm looking to set up a WordPress site that supports dual user registration - customers and instructors. Key Requirements: - The registration form should be able to collect specific information from both user types including name, email address and phone number. - Customers should have the ability to search for instructors and book lessons with them. - Instructors should be able to create, manage and edit their profiles. I'm seeking a skilled developer who can implement these functionalities seamlessly. Experience in WordPress and user registration systems is a must. The ideal candidate should also have a good understanding of ...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
I need to have a girl removed from a short, high-definition video of myself and my sister. The video is less than a minute long. The girl to be cropped out is positioned in the middle of the video and I want the edited outcome to feature just my sister and I. Key tasks include: - Identify and crop out the girl from the video - Ensure smooth transition and maintain overall video quality - Final video should be in high-definition Skills and experience necessary: - Proficiency in video editing software (Adobe Premiere Pro, Final Cut Pro...) - Ability to crop out individuals effectively and smoothly - Experience with transitional effects may be necessary - Attention to detail and creativity.
Develop macro-enabled Excel file to handle CSV
...professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while ma...
I have written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , insid...
...the 1. Main templetate would be but with an additional screen using other 3 packages. 2. Create Okta native app on Application flow: 1. On Start app if not authenticated, show screen with Login button (middle of screen) 2. When Login button is clicked, goto Okta authenticate 3. If Authenticated : 3.1 Goto to new screen with big round button in the middle of the screen -> "SCAN" 3.2 When clicked, a BLE scan is started for 4 sec. 3.3 If one specific BLE device for the scan is found (based on ID), present faceID prompt and if succeded call a function with haptic feedback 3.4 then back to screen with "SCAN" Button That's it, so all code is available in the pub example packages, I just need a merged
I have a photo where I would like to remove a person who is on the side. (Want to keep only the girl in the black shirt) remove the other one on the left of her Key requirements: - Remove the person on the side of the photo while keeping the background intact. The background is mixed, with some areas more complex than others. It's essential that the background maintains its original look, even after the person is removed. - The final use of the edited photo will be for personal use, so the editing needs to be of a high quality. Ideal freelancer: - Previous experience in photo editing, specifically in object removal while maintaining the background. - Proficiency in tools like Photoshop or similar software. - Attention to detail and ability to...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
...be a product catalog for windows, with a design similar to quartzluxurywindows.com. AND a 10 pages Product Brochure/booklet from a sample hardcopy Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of SEO best practices to ensure the website is search ...
I am in need of a Pyth...I require someone who can proficiently extract data from various websites. The specifics of the data may vary from text content, images, links, to contact information. Your key responsibilities will include: - Writing effective and efficient Python scripts to scrape data - Ensuring the data is extracted accurately and in a structured format - Delivering the data in a timely manner The ideal candidate should have: - Proficient experience in Python and web scraping - A strong understanding of data extraction techniques - Proven experience in handling and parsing a variety of data types - Excellent communication skills and the ability to meet deadlines Please be prepared ...
...and web-savvy freelancer/contractor to build a comprehensive database of sign manufacturers/companies in France. Project Scope: • Research and identify qualified sign manufacturers/companies/suppliers/sellers/stores across France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data col...
...with a design similar to quartzluxurywindows.com. Key Features: - Product Catalog: The main functionality of the website will be to display the range of windows that we offer. The windows should be categorized by product type, similar to the organization on quartzluxurywindows.com. Requirements: - Experience in developing custom websites, particularly product catalogs. - Strong understanding of web design with an emphasis on user experience. - Ability to replicate the design and functionality of an existing website (). - Familiarity with organizing products by category. Optional: - Knowledge of SEO best practices to ensure the website is search engine friendly. - Experience with integrating online quote forms or other interactive features into...
I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion is to extract text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining form...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data...
I have a Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word
I'm seeking a skilled professional who can help me with a malware issue affecting multiple websites I own. - All my websites are experiencing the same type of malware. - The primary issue I'm facing is the presence of the malware on the websites. The ideal candidate for this job should have the following skills and experience: - Proven experience in malware removal a...affecting multiple websites I own. - All my websites are experiencing the same type of malware. - The primary issue I'm facing is the presence of the malware on the websites. The ideal candidate for this job should have the following skills and experience: - Proven experience in malware removal and website security. - Familiarity with various malware scanning tools. - Implement security measures t...
I'm looking for an experienced hacker who specializes in database scraping to assist with lead generation. My main aim is to get detailed contacts to grow my business. - Specific Tasks: - Database scraping - Extract contact details - Contact Information: - Email addresses - Phone numbers Ideal candidates should have previous experience in the field. Proficiency in data mining and scraping is a must, along with an understanding of lead generation strategies. Strong grips and successful track records on obtaining accurate contact details are key to perform this job efficiently.
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I'm in need of a professional who can help with data entry into spreadsheets. This is a straightforward task based on digital files I'll provide. Key Responsibilities: - Entering data accurately and efficiently into spreadsheets - Ensuring the correct format and organization of the data Ideal Skills and Experience: - Proficiency in data entry - Experience with spreadsheets - Strong attention to detail
...seeking a Python expert to delve into a specific set of emails and tackle both sentiment analysis and classification tasks. Key Tasks: - Sentiment Analysis: I want to understand the overall sentiment of the email data. You will be required to identify and extract the prevailing sentiment from the emails. - Email Classification: The project includes categorizing the emails into predefined categories. This will involve analyzing the content and context of the emails to sort them into different classes. Requirements: - Proficient in Python: As Python is my preferred language for this, you should have a strong grasp of Python and its libraries for carrying out sentiment analysis and text classification. - Email Analys...
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
More details: *What specific type of claims do you expect the expert consultant to identify? Delays, Cost overruns, Scope changes *How many projects do you need the expert consultant to review? 4 *Project documents will be supplied. *Reference Contract: FIDIC Red Book *How soon do you need your project completed? ASAP
...based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. If y...
Recreate about 90 slides to a popular learning platform. Some images may need to be resized or replaced with stock images.
I'm looking for an experienced developer to help with real-time text data scraping via API and management using BeautifulSoup. This project is primarily focused on retrieving text data and storing it in a database. Key Responsibilities: - Implement an API scraper to continuously retrieve text data in real-time - Utilize BeautifulSoup for data extraction and management - Develop a robust database to store all the scraped text data The ideal candidate should have: - Proficiency in Python programming language - Strong experience with API scraping and BeautifulSoup - Previous work involving real-time data scraping - A good understanding of database management It is important that the data...
I have 20 pages that need some content generated from ChatGPT and entering on to the page. This includes a short bit of text (150 words) for the main content and YOAST meta descriptions. I'll provide full instructions and the correct prompts to use with ChatGPT. This is a super simple copy and paste job and should only take a couple minutes per page. Please be familiar with WordPress and ChatGPT so you can get this done quickly. Also you will need to update the DNS in your local hosts file to be able to access the site (I can show how) This is 1hrs work at most so please bid accordingly.
I have 11 simple digital imags that I need converted to an .STL file so I can have it 3D printed. The design contains basic geometric shapes and lacks complex curves or textures. Key Requirements: - Convert a simple digital image into an .STL file for 3D printing - Ensure the file is optimized for 3D printing to avoid any issues during the printing process. Ideal Skills and Experience: - Proficiency in CAD software - Experience in 3D modeling, particularly converting images into .STL files - Understanding of 3D printing requirements and how to optimize files for this purpose.
...expertise in Node.js and MongoDB. Your primary responsibility will be developing APIs that integrate seamlessly with external services. Key tasks include: - API development: You should have a proven track record of creating robust, efficient APIs. - Integrating with third-party services: The APIs you develop need to be able to communicate effectively with a range of external platforms. - Database design and optimization: While not the core focus, a strong understanding of MongoDB and how to optimize it for performance and scaling is beneficial. The project is centered around building a backend system that can handle a variety of tasks and interactions. While the exact scale of the project isn't currently known, the potential for growth is high. ...
We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and a proven track record of successfully raising equity capital for companies and funds in the growth stage. SKILLS AND EXPERIENCE REQUIRED: 1. Proven experience in lead generation within the financial services sector. 2. Successful track record in raising equity capital for growth-stage companies. 3. This project requires a proactive and results-oriented approach. 4. The successful freelancer will work closely with our executive team to develop and execute a comprehensive capital-raising strategy to support our company's growth obj...
I need an experienced programmer who can create a bot that will be used for automated trading on Binary.com. Key Functionalities: - The bot will be designed to execute trades based on predefined strategies. This means it should be able to analyze market conditions and place trades automatically as per the set strategy. Ideal Skills and Experience: - Proficient in Python: Since Python is my preferred programming language for this bot, you should have demonstrable experience in programming with Python. - Knowledge of Binary Trading: A good understanding of binary trading platforms and how they operate is a considerable plus. - Experience with Automated Trading: Prior experience in developing bots for automated trading is highly preferred. - Familiarity with : Give...
...someone who can create a database in MS Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
...a specific dataset that I would like to use for building the model. This dataset is of moderate complexity, featuring multiple variables. The primary goal of the model will be to understand the relationships between these variables. Key Responsibilities: - Utilize the provided dataset to develop a causal model - Ensure that the model is capable of effectively illustrating relationships between variables - Optimize the model for performance Ideal Candidate: - Proficient in Machine Learning and Python - Experience with building causal models - must have worked on techniques like robust synthetic control, dowhy, econml, trigamite, DECI and other double ML/causal techniques - Strong analytical and problem-solving skills - Ability to work with moderate to...
...proposals from experienced web scraping and data analysis firms to conduct a comprehensive data collection and analysis project. The purpose of this project is to gather detailed information on menu items, pricing, customer ratings, promotions, and deals from various food delivery mobile apps operating within our city. The goal is to mine this data for actionable insights to inform our advertising, promotional strategies, and competitive benchmarking. 2. Project Scope The selected vendor will be responsible for developing and implementing a solution to: • Subscribe to and navigate through multiple food delivery mobile apps. • Collect data on menu items including descriptions, pricing, customer...
...Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. ...
...on PHP and I'm looking to integrate it with APIs provided by multiple suppliers. These suppliers will send us three specific types of data through their APIs - customer information, product information, and order information. Key Requirements: - Connect the webapp with Supplier A, Supplier B, and Supplier C APIs. - Extract and process customer information, product information, and order information sent by these suppliers. - Display this data on the webpages of the application. - Store this data efficiently in a database. Skills and Experience: - Proficient in PHP and API integration. - Strong understanding of database management. - Experience in handling customer, product, and order data. - Detail-oriented to ensure ...
...process of saving PDF attachments from Outlook emails. Key Requirements: - Extract PDFs based on dates within the PDF text: The PDFs should be saved based on a specific criterion - dates within the PDF text. Your role will be to parse these dates and save the files in a designated folder on my computer. Skills and Experience: - Proficiency in Outlook: A deep understanding of Outlook's email management functionalities is a must for this project. - PDF Parsing: Experience with parsing text within PDFs is essential. - Automation: The ability to create a script or use a tool that can automate the process of saving the PDFs according to the specified criteria. - Efficiency: The project needs to be completed urgently, so the ideal candidate sh...
I'm looking for a developer to create a Chrome extension that will communicate with a server. The extension should be able to: - Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension ...
I'm looking for a developer to create a Chrome extension that will communicate with a server. The extension should be able to: - Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension ...
...Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office ...
