Vba export excel data mysql jobs
I will add these features on the Form - * Please add the header content, logo & steps to use the form as provided in the reference excel sheet. * The user should be allowed to fill the form only if the selection is 'Yes' * Please check the verbiage in the first page (Specially under Residency information - Canadian tax return (also check the order of questions here) & Residency information -US tax return) * In UN25, the selection should be a tick mark instead of just a dot. * Changes regarding the appendix as discussed in the call and also as highlighted in #3 in our previous mail. *U9 to U39, UN1 to UN25 (when a user clicks on the 'Yes', the alert box is not changed as per the previous requirement. I guess you have missed from the previous requirement...
I'm in need of a Python script that can download an Excel report from a public website every hour and upload it to a designated portal folder without any modifications. - **Task**: Script should perform the following tasks - Download an Excel report from a public website every hour. - Upload the report to a specific portal folder without any modifications. Ideal Skills: - Proficient in Python programming. - Prior experience with web scraping and automating tasks. - Familiarity with working with Excel files in Python. - Knowledge of file upload protocols and processes.
You have to make this from scratch or if you have any code i can purpuse i will buy asset tracking project 1. Setting - Define Owner - User Role Once the User logs in to the application using his AD account User is going to sync to USER Access and the admin is Able to Assign Custom role. - Email Notification – any user email define here shou...-Purpose – OEM Support End Date – EOL DATE – OEM Renewal – Support Level- Estimated Renewal Cost – Status 5. Report with Printable 6. Login – should be integrated via keycloak for single singon Note: You have to work on your local PC for this project for task 6 you can work on my server after completing the other task 1-5. also you have to deploy this on my production server database has to be my...
I'm looking for a full-time expert in PHP and MySQL for the development of a web application. Key Responsibilities: - Custom PHP coding for the web application - Ensuring robust and efficient server-side integration - Optimizing MySQL queries for performance and speed Ideal Skills and Experience: - Extensive knowledge in PHP and MySQL - Proven experience in web application development - Strong problem-solving skills and attention to detail - Excellent understanding of server-side integration - Able to work full-time and meet project deadlines.
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
...skilled Virtual/Administrative Assistant to support me, a busy C-Level Executive. The ideal candidate should possess 3-5 years of experience, particularly in: - Project Management - Business Calendar Management - Copywriting - Task Prioritization - Researching - Personal Task Management (Daily, Weekly, Monthly) - Proficiency in Microsoft Office Suite (Excel, Word) - Excellent Typing Skills - Coordinating Contacts Meetings - Outbound Phone Support - Data Entry (with Excellent Accuracy) - Other Related Business Tasks To start with, I require 5-10 hours a week. The most crucial skills for this role are Project Management, Calendar Management, and Copywriting. Your primary focus will be on managing my business calendar, so experience in this area is vital. Additionally, yo...
...skilled data professional to compile a comprehensive database of recently registered domain names along with relevant ownership or business details for the purpose of targeted outreach and lead generation for website development services. Database Scope: Collect domain registration data with a focus on recently registered domains (last 6-12 months preferred). Include data points such as: Domain Name Date of Registration Registrar Name Business/Registrant Name (if available) Contact Email or Phone (if publicly available) Country/Location Expiry Date (if accessible) Data Collection Methods: Utilize legitimate sources such as WHOIS databases, expired domain lists, and domain auction sites. No data collection that violates GDPR, CCPA, or similar da...
I'm looking for an Excel sheet that can help me track daily sales for my pizzeria. The sheet should be user-friendly and structured in a way that allows for easy data input and analysis. Key Requirements: - The Excel sheet should be designed specifically for sales tracking. - It needs to accommodate daily sales data. - It should be able to present the data in tables. - The design should be clean, simple and easy to use. I have an existing sample , if you like Ideal Skills: - Proficiency in Excel - Experience in designing sales tracking tools - Ability to present data clearly and logically Please note, the primary purpose of this Excel sheet is to keep track of my pizzeria's daily sales. It should not include any unnece...
I'm looking for an expert in Excel to create a comprehensive bidding sheet for my concrete company. The sheet should be able to accurately calculate labor costs, material costs, and time estimates for different projects. Key Features: - Formulas and calculations: The sheet should include necessary formulas to automate calculations and ensure accuracy. - Conditional formatting: This feature will help in easily identifying key data points or alerts. - Graphs and charts: Visual representation of data will be beneficial for understanding project estimates and costs at a glance. Templates: The Excel sheet should also include templates for: - Bid proposals: A pre-formatted template that I can use for submitting bids. - Invoicing: A template for creating invoice...
I'm looking for a professional freelancer to create an animated GIF image for me. This will serve as a pre-loader for m...**Animation**: The transition effects don't have to be identical to the original GIF, but it should run a nice animation of my logo. Here is the original GIF for reference: [Original GIF]() And here is my logo: [My Logo]() I can export my logo in any format and dimension. The ideal freelancer for this project should have a strong background in animation and GIF creation. Please, include your portfolio in your bid, particularly examples of elegant and sophisticated animations you've created in the past.
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
...activity. - Content Management: Add/edit/delete worksheets and articles. - Reports: Generate reports on user activity, popular worksheets, etc. #### 3.2.8 Deployment - Assist with deploying the website to a live server. - Ensure proper configuration for scalability and security. --- ## 4. Technical Requirements ### 4.1 Framework - CodeIgniter 4 (PHP Framework) ### 4.2 Database - MySQL for managing user data, worksheets, articles, and logs. - Support for allowing multiple users to register with the same email address, differentiated by unique usernames or IDs. ### 4.3 Frontend - HTML5, CSS3, JavaScript (using a responsive framework like Bootstrap). - Use a colorful and engaging template to appeal to users. - Use an SEO-friendly website template. ### 4.4 Backe...
Please Sign Up or Login to see details.
I am currently working with a budget model and need a financial modeling expert to help me complete a sensitivity analysis. The variables that need to be includ...working with a budget model and need a financial modeling expert to help me complete a sensitivity analysis. The variables that need to be included in the sensitivity analysis are: - Revenue growth rate - Operating costs - Interest rates The analysis should be conducted in Excel. Ideal candidates will have extensive experience with financial modeling, particularly with budget models, and be able to conduct a comprehensive sensitivity analysis. Proficiency in Excel is a must, and familiarity with advanced Excel functions and techniques will be an asset. Please provide examples of similar projects you...
I'm seeking a T-SQL specialist with a deep understanding of SQL Server. Your role will primarily involve optimizing and tuning an existing database. Key Responsibilities: - Performance tuning and optimization of the current database. - Manipulating and transforming data, leveraging your expertise in SQL, XML, and JSON. Ideal Skills: - Extensive experience with SQL Server and T-SQL. - Extensive experience with XML and JSON data. - SQL DBA skills are a plus. - MySQL knowledge could be useful at a later date but not for this task. Please note, if your primary response includes web development, web design, or full stack development, your response will be deleted.
I need a skilled Desktop Support Engineer for Windows 11 installation, hardware troubleshooting, and MS Office setup. Your responsibilities will include: - Installing Windows 11 on various desktops - Troubleshooting hardware issues as they arise - Installing and configuring MS Office applications (Word, Excel, Outlook) - Setting up printers and configuring computers Ideal candidates should have: - Proven experience as a Desktop Support Engineer - Strong knowledge of Windows 11 and MS Office - Excellent problem-solving skills - Ability to install and configure printers Please provide evidence of your relevant experience and your approach to troubleshooting hardware issues.
I'm seeking an Excel expert to develop a spreadsheet that will assist with calculations and comparisons for our purchases. Key Requirements: - The Excel sheet should be able to help us make comparisons and use logic to decide whether to place orders. - Data inputs will include product prices and quantities, supplier details, as well as purchase dates and times. - A primary function of the sheet will be to carry out price comparisons between different suppliers. Ideal Skills: - Proficiency in complex Excel formulas and functions. - Experience in data analysis and comparison. - Ability to create user-friendly and efficient Excel models.
I'm in need of a professional who can help me export live transaction data from to Google Sheets. The focus of this project is on trade history. Data Organization: - The trade history needs to be organized by the time of trade. Time Intervals: - I require this data to be captured and logged every minute. Ideal Skills: - Proficiency in Google Sheets. - Understanding of trade data. - Experience with data extraction from websites. - Ability to work with live data feeds. Please only respond if you have the required experience and skills. I look forward to your proposals.
I'm seeking a skilled web developer to use functional features from an adult 18+ site into one unique project. The candidate will have significant input into the design and functions of the website with ongoing support from myself. Key Components: -Implementing features such as Signup/Login, Available Now, Boost, Payment Gateway & MySQL integration for the backend database. -Designing and ensuring functionality of backend database works seamlessly. User Integration Aspects: - Creating a system for User Profile Management - Setting up mechanisms for transaction tracking The ideal candidate for this project should have: - Extensive experience in web development, specifically with adult sites - Strong understanding and skills in database design and functionality - Proven ab...
Description: We are seeking an experienced Financial Modeling Consultant with in-depth knowledge of affordable housing developmen...layering. Familiarity with compliance and reporting requirements for state and federal programs. Exceptional analytical and problem-solving skills. Excellent communication skills and ability to explain financial concepts clearly. Preferred Qualifications: Experience working with LIHTC, HUD, or other Florida-specific housing programs. Background in real estate finance or development. Proficiency in Excel and financial modeling tools. Deliverables: A refined or new underwriting model for affordable housing projects. A detailed report outlining recommendations and insights for financial decision-making. Ongoing support for financial strategy discussions ...
I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.
Description: We are seeking an experienced Financial Modeling Consultant with in-depth knowledge of affordable housing developmen...layering. Familiarity with compliance and reporting requirements for state and federal programs. Exceptional analytical and problem-solving skills. Excellent communication skills and ability to explain financial concepts clearly. Preferred Qualifications: Experience working with LIHTC, HUD, or other Florida-specific housing programs. Background in real estate finance or development. Proficiency in Excel and financial modeling tools. Deliverables: A refined or new underwriting model for affordable housing projects. A detailed report outlining recommendations and insights for financial decision-making. Ongoing support for financial strategy discussions ...
I have a data sheet ready for a Monte Carlo Simulation assignment. An Excel expert is needed to input the formulas into the sheet and complete the assignment. A formula sheet and instructions will be provided. Key Requirements: - Intermediate level complexity for the Monte Carlo Simulation - Use of Random Sampling technique - Results presentation in both tables and charts Ideal Skills/Experience: - Proficient in Excel - Experience with Monte Carlo Simulations - Able to present data in a clear and concise manner
I'm in need of an Excel expert who can assist with a complex spreadsheet designed for data analysis. Key Responsibilities: - Help with analysing data using %tile rank - Potentially adding additional features to the spreadsheet Ideal Skills: - Proficient in Excel with a deep understanding of its functions and formulas - Experience in data analysis - Able to implement automation with macros, create visualizations with charts, and use conditional formatting if needed I am open to suggestions for additional features that could improve the functionality of the spreadsheet. Please provide a comprehensive proposal outlining how you would approach this project.
I need a freelancer to help with maintaining my Excel files. My datasets typically range from 1,000 to 10,000 rows. Ideal Skills: - Proficiency in Excel 365 - Data cleanup and organization - Troubleshooting formulas and functions - Macro creation and automation Experience with large datasets and Excel 365 is essential. Tasks may include data organization and cleanup. I look forward to your proposals.
I require a Microsoft Excel expert to assist with data analysis and visualization. The data is currently in an Excel spreadsheet and needs to be analyzed using descriptive statistics. Your tasks will primarily include: - Interpreting data and providing meaningful insights - Creating visual representations of the data Ideal skills and experience for the job include: - Proficiency in Microsoft Excel - Experience in data analysis and visualization - Strong understanding of descriptive statistics
We need someone to scrape website data and social media posts. Please download every Tiktok post from Return Home: @returnhomenor?lang=en We will need the videos, text description, hashtags, and all comments (and their associated data). In doing so, we ask that you create an Excel spreadsheet, a folder with video downloads, and a folder of Word documents that include the comments on each video. We provide a detailed description below. 1. Excel Spreadsheet: Please create an excel spreadsheet with the following columns. Column A: Label: “Video title” In this column, please provide the video title to match the title of the video download. For example, if you look at this TikTok video (@returnhomenor/video/7164090596796157230?lang=en), you woul...
...analysed and inserted in a excel spread sheet. The emails to be analysed will come from our customers providing a list of available haulage collections/deliveries. The emails will be in a general inbox which will also contain non transport related emails and these should be ignored. The emails are all in different formats for each customer but all should contain collection location, collection date, delivery location and delivery date. Due to every email being in a different format I am looking for an intelligent solution that can analyse the email, decide if its offering us haulage collections, determine which customer its from, determine the collection site and date, determine the delivery site and date and then pass this information to a formated excel spreadsh...
We are seeking a skilled bookkeeper to assist with the conversion of our business bank and credit card statements from PDF format to Excel. This is essential for the preparation of our financial statements for tax filing purposes. There are around 290 statements, containing around 1000 pages. The ideal candidate should be detail-oriented and proficient in accounting software. Experience with financial reporting and knowledge of tax regulations will be needed. We are looking to have this done ASAP, preferably by the end of the day this week on Wednesday. If you have a strong background in bookkeeping and are comfortable working with various file formats, we would love to hear from you.
I'm in need of a Back-End Developer to complete a Construction Project Management web platform. The front-end is mostly done, using HTML/CSS/JavaScript, and now requires a skilled professional to handle the back-end tasks, primarily using Flask (Python) and MySQL. Your key responsibilities will include: - Developing a secure user registration and login system, managing two specific user roles: Admin and General User. - Designing and building a robust MySQL database to store project and user data. - Enabling dynamic project entry by division (there are 16 divisions, each with unique input fields). - Creating an API to handle form submissions and display project metrics in real-time. - Ensuring the platform is scalable for future growth and additional features. - ...
Project Description: Develop a WooCommerce Integration with ProdSys ERP Overview We are seeking a skilled developer to create a custom WooCommerce extension that integrates our WooCommerce store with ProdSys ERP, a robust ERP system designed for SMBs in production industries. This integration aims to streamline our operations by automating data exchange between the two systems. About ProdSys ERP ProdSys ERP is a comprehensive SaaS-based ERP system tailored for businesses in production industries. Key features of ProdSys include: Project Management: Tracks income, expenses, hours, and materials at a project level. Multi-Language Support: Available in over 30 languages, enabling international usability. Scalability: Designed to cater to the dynamic needs of SMBs. Modular S...
I need assistance with reformatting my spreadsheet to improve its layout and visual appeal. Additionally, I require help with performing some statistical analyses, specifically calculating means, medians, standard deviations, and variances. Ideal candidates should have: - Proficient skills in Excel or similar spreadsheet software - Experience with data formatting - Strong understanding of statistical functions and analysis
...Development of a data management application for didactic processes, based on a topic of your choice. The individual project consists of two modules (files): • A descriptive module (a word-processed document) • A calculation module (developed in a data processing application) The project should generally follow the structure below, tailored to the specifics of your specialization: 1. Formulation of the theme/topic, including the objectives/requirements proposed for the project. 2. Specification of the studied characteristic(s), data volume/sample size, etc. 3. Data collection (miniaturized), with sources indicated (e.g., yearbooks, surveys, questionnaires, or other sources). 4. Preliminary data processing, such as coding, systematizing, group...
...edition which allows me to export the reports “Safety Culture” created to both a Word and also an Excel format. Word Format The export format contains all of the data which I have collated in my iPhone report into a lengthy and detailed report, complete with photographs illustrating each defect which I have identified and listing remedial work which I have deemed is necessary. What I require as far as Word is concerned is the following: A Macro, triggered on the click of a button, to ensure that the report is modified to suit the attached example of how I would like the report to look after triggering the Macro. All the remedial information (which is already mentioned within the report underneath each defect) is then grouped together at the en...
...technical support for mobile app users. - Providing product/service information for new sales and closing them. - Scheduling appointments. Ideal Skills: - Excellent communication skills - in english and be very fluent in english. - Problem-solving skills - Experience in customer service and must be able to be super friendly with customers. - Familiarity with VoIP systems -Must be good with excel, words, docs. Please note that specific admin tasks have not yet been defined, and will be many different admin tasks. we are looking for someone who wants to work and can wear multiple hats at anytime, doing whatever tasks given them. we are looking for someone reliable and can work at any given schdeule moment.. no excuses and no exceptions. our work hours in USA is 8am...
Hi there - I'll help you create a database for your invetor's information in Excel workbook. Thanks for your work!
...looking for a highly organized Data Assistant to help us make sense of our numbers and stay ahead of the game. Role Overview: We’re seeking someone detail-oriented and data-savvy to gather and analyze key performance metrics across our platforms. If you have a knack for spotting trends in analytics, SEO, and social media stats, this is the perfect role for you. Key Responsibilities: Collect and organize data from Google Analytics, SEO tools, social media platforms, and email marketing platforms. Track and report on KPIs, including website traffic, social engagement, and newsletter performance. Create easy-to-digest reports and visualizations for the team. Analyze trends and provide actionable insights to improve performance. Work closely with the team to opt...
...assistance with migrating product data from my existing website hosted on City Hive () to Shopify. Since City Hive lacks a direct export feature, this project requires scraping the product data and preparing it for import into Shopify, ensuring all essential details are included. Key Project Requirements: Data Extraction: Scrape or extract product data from the website, including product titles, descriptions, pricing, images, categories, brands, and options/variants. Example product page: Legend Vineyard Exclusives LVE Cabernet Sauvignon. Ensure that product categories (e.g., Wine, Spirits), brands (e.g., John Legend), and relevant attributes (e.g., Cabernet Sauvignon, Red Wine, Napa Valley) are captured. CSV File Preparation for Shopify: Format th...
I am seeking a Zoho CRM Report expert. The task involves building a Lead Status Report and a Deal Pipeline sheet, like an excel sheet, these sheets must be able to filter by seller, will be based on data from Zoho CRM data reports and will need to be AUTOMATICALLY updated daily (access to Zoho will be granted upon hiring). The Lead Status Report should include the concepts shown in the reference screenshots. The ideal candidate will have: - Proficiency in Excel and data visualization - Proven experience with Zoho CRM - Ability to set up automated reporting systems is A MUST - Strong attention to detail - Excellent communication skills to explain the data clearly.
Looking for a seasoned backend developer. Looking for a backend developer for a fast paced project. Must have very strong MySQL skills, CodeIgniter, PHP, Java. Ability to provide API for Mobile developers. Must be able to test the webapp themselves. Document their work as stated for the project. We are looking for someone who can work with existing code and can deliver error free and perfectly working code quickly and completely. Entire task has to be completed and tested within 5 days of award. Work involves modifying existing Braintree payment module so that its is replaced with Paypal's Braintree SDK. The solution has to work with current API integration. Developer is expected to test thoroughly before handing over code. Freelancer/ developer must have prior experience w...
I'm looking for a skilled freelancer to set up a Mac and create an automated daily report from stock broker accounts. This project involves: - Using Python to extract and analyze stock data - Integrating with the broker API (specific API to be determined) - Incorporating volatility indicators (to be specified) - Ensuring the final product can be easily imported into Excel The ideal candidate should be detail-oriented and accurate in data reporting. Proficiency in Python and Excel is essential, as is experience in financial data analysis. If you can deliver reliable reports, I would love to hear from you.
Looking for a backend developer for a fast paced project. Must have very strong MySQL skills, CodeIgniter, PHP, Java. Ability to provide API for Mobile developers. Must be able to test the webapp themselves. Document their work as stated for the project. We are looking for someone who can work with existing code and can deliver error free and perfectly working code quickly and completely. Entire task has to be completed and tested within 5 days of award. Work involves modifying existing Braintree payment module so that its is replaced with Paypal's Braintree SDK. The solution has to work with current API integration. Must have done this type work before Must be able to work with phpmyadmin and FTP. NO CONTROL PANEL ACCESS WILL BE PROVIDED. Hourly Rate is Rs.575 per hour ...
I need an expert in Artificial Intelligence, ChatGPT, Python, Machine Learning: can be expert in any of them The job is to collect data from the internet (NOT from one particular website, but from the worldwide web in general) and populate an Excel sheet that I provide The data is about businesses, and will be used on a business website
I have suppliers I have user and password to log in then I get my special discounted prices. I want a scrpit to download detials whenever required of the all items in excel or CSV format like item code, item detials and description, item price, item stock with differnt color options mentioned.
I'm looking for a skilled developer with extensive experience in PHP 8, Laravel framework, and MySQL. The project involves integrating Binance Smart Chain (BSC) payment features into my website, specifically focusing on token transactions. Key requirements include: - Implementing the ability to receive tokens. - Developing a system to check token balances. User authentication for this project is straightforward; there's no need for complex methods like OAuth or JWT. A solid understanding of the Laravel framework and PHP 8 is crucial, along with experience in working with MySQL. Prior experience with Binance Smart Chain will be highly beneficial for this project. Please include examples of similar projects you've worked on in your bid. Maximum one day to comp...
Already i check the Attachments excel sheet and i agree client timeline and budget $15.
Same as previous jobs, payment released after all corrections
...- Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont waste your time and bid If you have exp...
...payrolls in Excel Macros. Ideal Skills and Experience: - High level excel macros and VBA experience is required... Project scope: Prepare a banking Neft challan for bulk transfers and payrolls. 1. A database for vendor banking details ( infinite data feed required) 2. A database for employee banking details (infinite data feed required) 3. A payroll database , ( considering attendance , ESI & PF calculations, Salary advance, other deductions, Allowances, HRA, Salary) 4. Banking NEFT challan for vendor - button for creating print page in A5/A4 data on a company letter head based on data size 5. Banking NEFT challan for Payroll - button for creating print page in A5/A4 data on a company letter head based on data...