Excel vba insert csv data access databaseงาน
I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.
I'm in need of a talented individual who can build a Python script for me. The ideal candidate woul...need of a talented individual who can build a Python script for me. The ideal candidate would have demonstrated experience dealing with: - Information retrieval from potentially chaotic and unstructured scanned images and PDF files. - The ability to extract and segregate text, images, and tables. - Output the extracted data into a organized CSV file format. Expertise in Python is a prerequisite for this task. A knack for navigating unstructured data and strong knowledge in data extraction would be valuable to ensure a comprehensive approach to this task. Experience with Optical Character Recognition (OCR) could be beneficial too. If this sounds like your...
Need someone who can analize data from a excel and contact customer with missing data
I need a sSharepoint expert to help me resolve a 'Page not loading' error on my Sharepoint site. The error is as follows: Sorry, something went wrong One of the properties of the Web Part has an incorrect format. Microsoft SharePoint Foundation cannot deserialize the Web Part. Check the format of the properties and try again. I will give you access to the server via Anydesk. If possible can you fix this asap tonight for me. Specific Tasks: - Investigate and identify the root cause of the 'Page not loading' issue - Develop and implement a solution to fix the error Ideal Skills and Experience: - Proficient in Sharepoint site development and customization - Extensive experience in troubleshooting and resolving Sharepoint errors - Strong problem-solving skil...
...The system should accurately track our inventory of office supplies, providing real-time updates on what's in stock. 2. Reporting and Analytics: I want the ability to generate useful reports and insights, such as inventory usage trends and re-order reminders. 3. Create bar codes for each item that contains info about the item, item location, age of item, manufacturer, retailer. -In terms of access, less than 10 users should be accommodated. It's crucial that the system you set up is user-friendly and easy to understand. -Ideal skills: You should have considerable experience in setting up open-source ERP systems and familiarity with office supply inventory would be a plus. Understanding of the reporting tools and analytics is important, and ability to train a small t...
I'm in need of an experienced web developer to create a comprehensive online coaching website with Learning Management System (LMS) capabilities. The website will need to feature: - Video lectures - Text-based lessons - Interactive quizzes The website must also include user registration and login functionality, allowing users to create accounts and access exclusive content. It is important that the registration process is user-friendly and secure, with options for social media integration. In addition, the website will need to be integrated with a payment gateway to facilitate transactions for course enrollment and purchases. This should be seamless and highly secure, ensuring a smooth user experience. Finally, the website should be equipped with email marketing tools, allow...
I am looking for a freelancer who can help me obtain an .edu email address. The purpose of this is to access student discounts, educational resources, and exclusive software. I have specific educational resources and software in mind that I would like to be able to access. I am not sure yet which specific resources and software I am looking to access, but I am looking for your expertise in obtaining the .edu email address and pointing me in the right direction. I do not require assistance in setting up or registering for the specific resources and software after obtaining the .edu email. I am confident that I will be able to handle the setup and registration process on my own.
Will be written with rad studio 1- Barcode Integration: A system capable of recognizing barcode-labeled products and integrating with barcode scanners to facilitate easy identification and processing of products. 2-Product Tracking: A system that allows detailed information to be recorded for each product, including product name, code, description, price, quantity...managing orders from suppliers. 7-Customer Management: Recording customer information and tracking customer orders. 8-Reporting and Analysis: Reporting and analysis of inventory status, sales, profitability, etc., to evaluate business performance. 9-User Authorization and Security: User management and authorization feature to ensure different users have different levels of access and to maintain the security of wareh...
...investors. I am in the initial phase of developing a Software as a Service (SaaS) product that focuses on providing qualitative assistance to individual investors in creating their investment theses. I'm looking for a skilled developer to build a Minimum Viable Product (MVP). The MVP must include the following basic. functionalities: 1. Search and access to business information. 2. Annotation tools and creation of investment thesis. 3. Basic data visualization to present information in an understandable way. Specific Requirements: - Experience - Ability to create intuitive and accessible user interfaces. Key Features will include: - Investment portfolio tracking, - Risk assessment tools, - Investment recommendations Your task will also include creation of ...
...incorporate: - Listing Creation: This should enable a more streamlined process for the creation of listings in bulk. It should include features like customizable templates for the listings and an image gallery where I can easily upload and manage photos for listed items. - Inventory management with invoice creation -Email feature to send invoice through emails - Order Management: Ability to access and manage customer transactions effectively. - Inventory Management: Track available inventory promptly against sales and listings. - Transaction Retrieval: The application should include capabilities to retrieve transactions aiding in accounting processes. -should support multiple accounts for both eBay and PayPal accounts eBay -should be able to retrieve all listing for the ...
Task list 1) We hade a PsgSQL database with ticker data. We need to create another streaming data table with 1 min aggregate. Data table should update constantly, ideally each time ticker dateable is added with data 2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection 3) We need to write ports to the SQL data table to allow internet connection 4) We need instrument to add historical 1 min data to the database created on stage 1 5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present in 1 min database Conditions: We d...
I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time data in Exc...
I am nearing the completion of a PCF control for a model-driven form but require assistance in coding specific to data access and interaction. The coding challenge I have encountered involves fine-tuning the control, which is about 90% complete. What's left is to finalize it and deploy it to my development environment. The ideal freelancer for this task would have: - Proficiency in coding, particularly related to PCF controls and model-driven forms. - Strong expertise in data access and interaction. - Extensive experience in deploying controls to a development environment. - Ability to immediately lend a hand and help get this over the finish line. Please, only those with a deep understanding of these areas and able to resolve this swiftly should bid.
I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.
(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appreciated.
I'm seeking a proficient Microsoft Word VBA expert. Your responsibility will be: - Automating repetitive tasks to increase efficiency - Creating custom macros to fulfill specific needs - Developing interactive forms, enhancing our team’s productivity The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is def...
I am looking for an expert in .NET Core application development to Integrate Hangfire ...for an expert in .NET Core application development to Integrate Hangfire into a .NET Core web application for background job scheduling, focusing on configuring Hangfire with SQL Server, setting up dependency injection for job and CSV generation services, and defining job logic for various recurring tasks. This task includes implementing a secure Hangfire Dashboard for job monitoring and management, and creating specific recurring jobs (e.g., monthly, hourly) with logic tailored to business needs, such as generating CSV files. Ensure the solution encompasses database setup instructions for Hangfire, adherence to best practices in job scheduling, and thorough testing of job config...
...projects on the form can change. I need this sheets data to be used to determine if a project is currently occupied and to generate a weekly time report by project and employee. - Determine project occupancy: The solution should utilize the check-in/out times to determine whether a project is currently occupied or not. -Occupancy: Displayed on a Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal Skills: - Proficiency in data analysis and automation - Experience in project management and time tracking - Excel expertise - S...
I'm in need of a qualified freelancer to create an annotated bibliography for me. Here's what you must know: - Sources: I require less than 10 sources. The sources should be a mix of academic journal articles and online articles. Additionally, it's crucial to include at least one primary s...and online articles. Additionally, it's crucial to include at least one primary source in the mix. - Citation Style: The bibliography should follow the APA citation style. This will be for a cultural analysis on a country song and American values. The ideal freelancer for this job would have a background in academic writing and experience with the APA citation style. Proven research skills and access to credible academic databases are also crucial. Proficiency in English l...
I'm looking for a talented web designer/developer who can create a visually striking website with parallax effects for my target audience of gamers. Key Features: - Banner image: A captivating visual to grab attention - How to play section: Providing essential information in an engaging way - About the app: Detailing the background of the app in a clear and concise manner - Contact: Easy access for users to reach out - Footer with social icons: Encouraging social engagement Ideal Skills: - Proficiency in modern web design and development - Experience with parallax effects - Understanding of user experience principles, particularly for gamers - Strong communication skills to capture the essence of the app and present it in an engaging way If you have a strong portfolio and c...
I am having an issue with my website generating a 500 internal server error when trying to access certain sections, primarily the 'INFORMATIONS' page. Additionally, the website is experiencing significant slowness overall. Key Requirements: - Fix the 500 internal server error that occurs when accessing specific tabs on the website. - Identify the root cause of the issue and implement a lasting solution. - Optimize the website for performance to reduce overall slowness. The issue seems to have originated from recent changes made to the website, specifically the installation of new plugins or extensions. Therefore, the ideal candidate should be experienced in: - Website troubleshooting and error resolution. - Server configuration and optimization. - Plugin and extension ma...
I need changes to my website. You must be familiar with Wix, Shopify, and Wordpress. I have only 3 to 4 small changes needed on the website. I will share with you in chat. YOU need to work on any desk or team viewer because I don't have access of website. The budget is 10AUD for this job............Not take more then one hour to fix.
the .db database is for an android app for my personel usage. The APP crash when i click on some records. And I can't delete those records by DB browser. I will give you the error records ID. And you just delete them. The app is in chinese language.
I need changes to my website. You must be familiar with Wix, Shopify, and Wordpress. I have only 3 to 4 small changes needed on the website. I will share with you in chat. YOU need to work on any desk or team viewer because I don't have access of website. The budget is 10AUD for this job............Not take more then one hour to fix.
...for showcasing our properties. Key features must include: - Property listing pages to display our available properties comprehensively. - A photo gallery for each property to display multiple images. - A simple interface for updating and editing property photos and listing information swiftly. - A design that's compatible with both mobile and desktop for user convenience. - An added feature to insert videos enhancing the user's understanding of the property. - A modern and sleek design that's visually appealing, drawing in potential clients. - In terms of user interaction, the website must include a contact form for easy submissions. The ideal candidate has proven experience in website development, particularly with real estate platforms. An understanding of inte...
For my...would like to build a thorough and searchable database that reflects candidates and their voting records on environmental issues. This database will cover candidates from all political parties to provide an unbiased perspective. I intend for this tool to aid voters in making an informed decision about who aligns most with their viewpoints. Key features should include: - A profile for each candidate which will house details on their voting record and policy positions related to the environment. Preferred skills and experience: - Database development and management - Excellent understanding of politics, particularly environmental policies - Strong research skills to ensure accuracy and comprehensiveness of all data - Ability to present data in...
More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.
I'm seeking an expert who can decrypt an AES encrypted .cap file. The file contains encrypted data I need to access for educational purposes. Key requirements include: - Expertise in decrypting AES encrypted files - Ability to efficiently and securely recover the data from the .cap file - Strong commitment to data privacy and confidentiality Please provide examples of similar work you have done in the past, and outline your proposed approach to this task.
am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise,...
...driving course registrations. I want a school-like style. This is a private mature student education company. READ: IF YOU WANT THE JOB - SUBMIT YOUR PORTFOLIO HERE: Here is the work so far, I want a re-design to better suit. Key Features: - A dedicated course schedule and descriptions section utilizing a dropdown system for easy navigation and information access. Requirements: - Experience in creating educational or training websites is preferred. - Strong capabilities in designing user-friendly, intuitive layouts. - A good understanding of aesthetic principles as the website should be appealing. - I possess all the content for course descriptions, so you'll only have to focus on the design. This is a great opportunity for web designers eager to create
As per requirement, I will deliver the required district's School details in Excel format
I need changes to my website. You must be familiar with Wix, Shopify, and Wordpress. I have only 3 to 4 small changes needed on the website. I will share with you in chat. YOU need to work on any desk or team viewer because I don't have access of website. The budget is 10AUD for this job............Not take more then one hour to fix.
I am looking for a proficient developer to build a profile management system. The system should be a combination, having all the major specifications mentioned below, from the platforms Vkardz, and linktree. Features: - Social media integration: This will allow users to connect their various social media accounts for ease of access. - Customizable templates: I want users to personalize their profiles to their taste and needs. - Analytics and Reporting: This feature will show the profile's performance and user interaction overtime. - Comprehensive features: The system should be based on Vkardz, , and linktree, therefore the functionally should mirror and improve on these. - Contact information display: This should allow users to display their contact info easily. - Bio
Hello Nagaraj, I'm having a problem with Google Search and the error keeps appearing frequently: Unauthorized access to internal API. See To fix it, I have to monitor the websites frequently and constantly clear the cache. Could you find a solution to fix the problem? The error occurred on both sites: and
I'm seeking a skilled professio...Your main responsibility will be to guide our team through this process, leveraging your expertise in AWS and Git. Key responsibilities: - Enable version control capability with AWS CodeCommit and Git. - Configure team-level access control within the setup. - Implement feature branching as the preferred Git workflow. Ideal skills and experience: - Extensive expertise in AWS and Git. - Proven experience setting up AWS CodeCommit and pipelines. - In-depth understanding of Git workflows, particularly feature branching. - Strong knowledge in setting up team-level access control. Your guidance and knowledge will be a key contribution to the team’s proficiency in version control and feature-branching strategy ensuring a well-structur...
I'm seeking a proficient individual who can efficiently capture a livestream video from a specific website and broadcast it on my private server. Specifically: - Capture live video feed from ''. - Video capturing should be achieved through direct link access. - Upon successful capture, video requires broadcasting onto my private server. The ideal candidate should have an in-depth understanding of video capture technology, specific experience with direct link access, and the capability to set up reliable broadcasts on a private server. Familiarity with various livestream platforms and advanced server handling would be advantageous. Please, only apply if you can demonstrate prior experience related to these tasks.
...issue has led to slow loading times, unusual pop-up advertisements, broken links, and total lack of access to backend configurations including post/page management, theme setting modifications, and plug-in additions/modifications. I should mention that there have been no recent changes to backend configurations prior to the occurrence of this issue. Strong skills are required in: - WordPress Troubleshooting; - Understanding of backend configurations; - Expertise in dealing with 403 errors; - Ability to identify and remove website infections; - Proficiency in FTP adjustments; The chosen freelancer will need to eliminate the infection, resolve the 403 error and restore full backend access to my WordPress site without causing additional issues. As I depend on this site fo...
...create and deploy a unitary contact database. This system will be the hub for all contact information streaming from various sources such as VoIP, O365, WhatsApp, HubSpot, and Sigparser. Key Requirements: - Integration with Various Platforms: You should possess extensive knowledge in integrating various platforms into a central database. Experience with VoIP, O365, WhatsApp, is a must, experience with HubSpot and Sigparser will be highly valued. - Contact Syncing: The database should have the capability to sync contact details across all integrated platforms promptly and accurately. - CRM Integration: An essential part of this project is effectively linking the database with customer relationship management (CRM) systems. This would allow me to acce...
...with in-depth understanding of Android's file system and security model. - The app should possess functionalities that include accessing system files, modifying system settings, and executing privileged commands. - There are no requirements for interacting with any external hardware devices or sensors. Ideal Skills: - Strong experience in Android development - Deep knowledge of Termux and root access - Understanding of Android system files, running commands and automation. Only need the script for running on termux. open browser, make search, click on a organic link. etc.. I have two rooted device and trying to make an automation system for my school project but could solved termux side. If you already have it will be faster. If this sounds like you, I'd be delig...
I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in a numbe...appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data presentat...
...current data usage in our application, "Transteam". Your task involves: - Reviewing and cataloguing current app permissions, particularly in reference to accessing user contacts. - Ensuring our compliance with platforms' terms and developer policies including Meta Platform. - Demonstrating concrete and substantial experience with similar projects. I am interested in your professional competence more than a detailed proposal or proofs of past works. - Implementing data-handling certification feature. Applicants with a deep understanding of data handling, user privacy, app permissions, and compliance will be preferred. Knowledge of the technology underlying the "Meta Platform" will be a major advantage. Ensure you have the necessary certif...
...seasoned developer for an advanced VBA application. This application should principally assist in data analysis, while also automating routine tasks. The exact tasks that need automation include data import/export and manipulation. Key Requirements: - Development of a VBA app with a robust data analysis feature - The app should automate data import/export and manipulation tasks The application should also be capable of seamlessly integrating with various software tools. While Microsoft Excel and Access are a given, the ability to integrate with other tools is also vital. Having experience working with a variety of software packages is a considerable advantage. Skills and Experience Required: - Proven experience in VBA de...
I'm looking for an experienced Android developer to help me troubleshoot some issues with my app that's near completion. Key Requirements: - Experience: Please provide examples of previous projects where you successfully resolved app crashing issues. - Experience with Java: The app is coded in Java, so experience with this language is essential. - Will allow remote access only. I will not share code. Your role in this project would be to identify the cause of the app crashes and provide a solution. You should be able to work quickly and efficiently, as the app is close to completion and we're keen to resolve these issues as soon as possible. The ideal candidate should have strong troubleshooting skills, excellent attention to detail, and a proven track record of del...
I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...
I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline...
Hi everyone, We're in need of a decent video editor, to edit mobile videos and put lyrics of the songs we provide over the videos. Basically the process is this: you download a clip up to 15 seconds long and put it in capcut - insert a song - add lyrics on screen and post it. That is the whole job. 10 minutes of work. You are required to make 2-3 of these videos a day and post them on our page. You must post 2-3 videos every day. Job duration is 4 weeks. So for 4 weeks you will have to post 2 clips a day on the pages. Requirements: - capcut - great english (in writting and understanding) - understanding of posting on social media The job is incredibly easy, all details will be provided - where to find clips, which songs to put in videos etc. Waiting on your proposal...
...insights. - Stay abreast of the latest AI advancements that can enhance our investor discovery and profiling processes. - Ensure compliance with all applicable data protection and privacy laws during the investor discovery process. **Skills and Qualifications:** - Proven experience in AI, machine learning, or data science, with a strong portfolio of projects demonstrating your expertise in investor profiling or similar areas. - Proficiency in programming languages such as Python or R, and familiarity with AI and machine learning frameworks (e.g., TensorFlow, PyTorch). - Strong analytical skills with the ability to interpret complex data and translate it into actionable insights. - Excellent problem-solving abilities and a creative approach to identifying and reachi...
I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.
I'm looking for a skilled professional who can assist me in gaining access to my locked Facebook account. The problem seems to be in verifying my identity. Your role would be to guide me through the required steps to confirm my identity via email. Due to potential prior attempts, any troubleshooting expertise would be beneficial. Key requirements for this task include: - Proficiency in Facebook's identity verification process - Expertise in email-based verification methods - Strong problem-solving skills, especially relating to technological and verification issues - Ability to guide me through the whole process patiently If you have prior experience with similar issues, it is strongly preferred.
We are seeking an experienced app developer to assist us with the deployment of our Android application on the Google Play Store. The app has already been developed and tested, and we are now ready to publish it to the Google Play Store. Responsibilities: Prepare the necessary assets and documentation required for app submission. Ensure that the app ...Excellent communication skills and ability to provide timely updates on project progress. Prior experience with app development and knowledge of best practices is a plus. How to Apply: If you meet the requirements and are interested in this opportunity, please submit your proposal outlining your relevant experience and approach to app deployment on the Google Play Store. Note: We are not requesting access to your Google Play Consol...