Date vba excel sql jobs

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

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 working with Java/Spring/JavaFX for the programm...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable. I cu...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.

Please Sign Up or Login to see details.

...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...

Let's do it. let's do it. let's do it

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I'm looking for an efficient data entry professional to input a variety of data into Excel for me. The required data includes: - Text data - Numeric data - Date and time data The main purpose of this data entry is to facilitate data analysis and the creation of reports. There are approximately 100-500 data entries in total. Ideal Skills: - Proficient in Microsoft Excel - Excellent attention to detail - Strong analytical skills - Previous experience with large volumes of data input

...adding a special touch to the birthday surprise. - The core feature of the video should be a custom caricature of my son. Creativity is encouraged whilst ensuring that the caricature is likable and recognizable. - Incorporate pictures of my son strategically throughout the animation to add a personal touch. However, ensure it remains subtle and tastefully done. - Photos right from his birth till date will be shared and need to be incorporated in the video Successful candidates should have a strong background in animation and particular skill in caricature design. An added plus would be expertise in creating custom animations with high entertainment value. The ability to interpret guidance and add creative input is also vital. Finally, a knack for comedy would make the video extr...

I have a specific design concept in mind for a certificate that I need created in an Adobe PDF format. Please use this design and copy this design attached. Change the dog picture to the cat picture attached Change dog name Poncho to the cat's name MILLIE Change the dog owner to the cat owner: HANNAH MIEHE Registration Date change to: MAY 20TH, 2024 ADD/keep THE LOGOS ATTACHED TO THE CERTIFICATE TEXT EDIT above I will provide you with all the necessary assets for the design, including a photo and my brand logo. Your role will be to incorporate these into the certificate in a way that aligns with my concept. Ideal skills and experience for this project include: - Proficiency in Adobe Photoshop and Illustrator - Experience in creating visually appealing design lay...

I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...

I'm launching a brand new Arabic podcast focusing on news and current affairs. My vision is to build a stro...Knowledge of current affairs and news reporting - Familiarity with the podcast landscape and trends Your role will be to help me: - Develop a podcast format that will resonate with our audience - Produce and edit high-quality, engaging audio content - Optimize and customize content for each social media platform - Plan and implement a social media strategy to grow our online presence - Stay up-to-date with the latest news and trends to keep our content relevant I don't have a strict deadline for this project, so I'm looking for someone who can commit to making this a long-term success. If you're passionate about the Arabic language, news, and social med...

...informative, engaging, and optimized for search engines. Conduct keyword research to identify high-potential keywords and topics. Optimize existing blog articles to improve their search engine rankings. Develop content strategies to increase organic traffic and improve user engagement. Collaborate with the marketing team to ensure content aligns with overall brand strategy and goals. Stay up-to-date with the latest SEO trends, tools, and best practices. Requirements: Proven experience as an SEO copywriter or similar role. Strong understanding of SEO principles and best practices. Excellent writing, editing, and proofreading skills. Ability to conduct thorough research and present complex information clearly and concisely. Experience with SEO tools such as Google Analytics, SEMr...

Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.

As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financial acumen are also a plus.

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I'm in need of a specialised makeup artist, primarily for a special event catering towards adults. Venue-gwalior (lashkar city) madhya pradesh. Date of event- 9 july 2024 The Specifics: - The event specifically targets adults so the themes, tone and overall approach should be sophisticated and professional. - A natural makeup style is preferred. It's essential that the makeup enhances the inherent beauty of each individual rather than overpowering it. Ideal Skills and Experience: - Extensive experience in special event makeup services. - Proven ability to deliver natural makeup styles successfully. - Experience working with adults and understanding their skincare needs and aesthetic preferences. In your bid, please include examples of you...

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurately reflected in the E...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

Hi Bhawan, creating this milestone to record the hours to date. Tracking of 14.5 hours as of 19 May.

I would like to design a program (bot) that will find a specific product on the website, add the product when it first becomes available in stock, add to the shopping cart, then automatically check out the item with the corresponding profile assigned for billing and shipping information. The drop date for the product is set for the 24th of this Friday as I would need this completed prior to the drop date.

...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...

I'm looking for a skilled content writer to create 500-1000 word articles for my website on technology, finance, and health. The successfu...of the project is 0.1 to 0.15 PPW, so don't bid if you don't agree with the budget. Key Requirements: - Ability to write engaging and informative content on the mentioned topics - Should be plagirism--free (we will check in copyscape) and AI-free (we will check in copyleaks) - Experience in SEO writing for online content - Excellent research skills to produce high-quality, accurate, and up-to-date material - Consistency in delivering projects in a timely manner I am looking to pay on a per-project basis, making this an ideal part-time position for those with the right skills and experience. Please provide a sample of your pre...

...Shopify and the Order Printer app to assist me in updating the 'Order Forms' and 'Tax Invoice' templates. The previous version of the app has been updated, and as a result, the code for these templates needs to be adapted. The 'Order forms template' must have: Order Number and Order Date Notes from Customer Quantity, Item Details fields including variants and customisation details. Estimated Delivery Date Customer & Shipping Details The 'Tax Invoice' must have: TAX INVOICE Logo Order Number and Order Date Business Name & Address ABN: Customer Name & Address Quantity, Item Details and variant Pricing, Discounts etc Tax displayed as GST Your main focus will be to ensure that the 'Order Forms...

I am in need of an experienced developer who can help build a web application using HTML, CSS, and JavaScript. The web app should be designed with interactive features, specifically real-time data updates. Key Features: - The app should display the current time and date for different time zones in real time Skills and Experience Required: - Proficiency in HTML, CSS, and JavaScript - Experience in building web applications with real-time data updates - Knowledge of time zones and working with time and date in JavaScript Please let me know if you're the right person for this job.

We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.

Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

Hello Freelancers, I am looking for an experienced professional who can assist me in extracting specific details from Tally using ODBC. The required data fields include: Purchase date Invoice number Vendor name Product (inventory name) Product quantity Rate Amount SGST CGST IGST Freight charge Gross amount The task involves creating a TDL (Tally Definition Language) or TCP (Tally Compiled Program) file that will facilitate the extraction of this data from the Tally database using ODBC Requirements: Strong knowledge and experience with Tally and its database structure. Proficiency in TDL or TCP file creation. Familiarity with ODBC for database connectivity. Ability to automate the extraction process to ensure seamless and accurate data retrieval. Deliverables: A functional TDL or...

...CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in ident...

I own a blog and I'm looking for a skilled freelancer who can assist me in acquiring high authority backlinks that wil...reputable sources and relevant to the content on my blog. - Analysis of my current backlink profile and making necessary adjustments to improve SEO performance. - Consistent monitoring of the backlinks to ensure they are active and continuously contributing to my website's growth. Ideal Freelancer: - Proven experience in building high authority backlinks. - Familiarity with SEO practices and up-to-date knowledge on the latest algorithm changes. - Previous work with blogs is a plus. - Excellent communication and reporting skills to keep me updated on the progress. In your application, please provide examples of your past work in acquiring backlinks, par...

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...

...typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Tools -> MySQL -> PHPMyAdmin. Here, you can directly view and edit the data in your tables and ensure that all da...

I am in need of an experienced developer who can help build a web application using HTML, CSS, and JavaScript. The web app should be designed with interactive features, specifically real-time data updates. Key Features: - The app should display the current time and date for different time zones in real time Skills and Experience Required: - Proficiency in HTML, CSS, and JavaScript - Experience in building web applications with real-time data updates - Knowledge of time zones and working with time and date in JavaScript Please let me know if you're the right person for this job.

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

... Teams can mark their availability for matches, view other available teams, and communicate directly to arrange matches. Core Features: User Registration and Profiles: Teams and individual players can create profiles. Profile information includes team name, location, contact details, skill level, and availability. Match Availability: Teams can post their availability for matches, specifying date, time, and location preferences. A calendar view for teams to manage their availability. Search and Matchmaking: Teams can search for other available teams based on location, skill level, and preferred match dates. Automated matchmaking suggestions based on compatibility (e.g., location, skill level). Communication Tools: In-app messaging system for teams to discuss and finalize mat...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation