Vba macro check data quality työt
Minulla on edelliseen projektiimme liittyvää jatkuvaa työtä 'Design high quality vector logo for healthcare/beauty firm'
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
...dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be...
Landing Page for my website it will have animation and interactive elements, looking for some one who can finish it in 12-14 hours. Please check the attached pdf for details. my budget is $50 AUD
My WordPress site has issues appearing in the Site Health screen. I'm looking for an expert to resolve these issues and ensure my site is running at its best. Key Responsibilities: - Identify and address issues highlighted in the Site Health screen - Implement fixes to improve site performance - Provide a detailed report of the work done and potential improvements for future maintenance Ideal Skills & Experience: - In-depth knowledge of WordPress and its Site Health feature - Proven experience in troubleshooting and fixing WordPress site issues - Ability to optimize site performance and ensure it runs smoothly - Strong communication skills and ability to provide clear, actionable recommendations.
I am seeking expert app developers to create a multi-platform application - compatible with both ...developers to create a multi-platform application - compatible with both iOS and Android, aimed to connect patients and doctors seamlessly. Key Functionalities: Patient Use: - Ability to book appointments - Access to check doctor's availability - Facilitate online consultations Doctor Use: - Efficiently manage appointments - Send notifications to patients - Gain access to patient medical records Ideal candidates should have a strong background in healthcare application development, expertise in both iOS and Android platforms, and a keen understanding of HIPAA compliance and medical data security. Proficiency in UX/UI for easy navigation for both patient and doctor in...
I'm seeking an expert consultant who specializes in quality control within the packaged food industry. The role will be focused on quality assurance process improvement, specifically to streamline and optimize these processes. The ideal candidate will have: - Extensive experience in the packaged food production industry - In-depth knowledge of quality control processes - Experience in quality assurance process improvement - Strong background in packaged food safety standards - Demonstrated success in optimizing quality control procedures Your expertise will be invaluable in helping to ensure the highest level of quality in our packaged food products.
Landing Page for my website it will have animation and interactive elements, looking for some one who can finish it in 12-14 hours. Please check the attached pdf for details.
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
...NodeJS applications, Alex did a talk about it and the slides are available to read at where the important slides for this challenge are 17-53. hint2: The web application is using the EJS template engine for rendering templates. Alex talked about a Prototype Pollution gadget that could be exploited to get RCE when EJS renders a template, you should check the link to an article and read the last bit. https://docs.google.com/presentation/d/1Ae38Nv6mUntog3AIcI9m_IuBfoxBWoEsw7njI2x8EX0/edit#slide=id.g22e32f4d19a_0_16 hint3: The format of the payload is slightly different to the payload in the referenced article in the second hint. The following code snippet will help you figure out how your payload should be formatted. for (const key in userInput)
Estoy buscando ayuda para prospectar y concertar citas para 2 de mis clientes. Ofrezco: 100 USD por 30 Citas Cerradas con clientes Calificados (yo te entrego el check list para saber si califica) Comisión por Venta cerrada en la llamada que agendaste Después del periodo de prueba de 30 citas aumenta a 120 Usd por las misma meta de 30 citas si agendas un cliente AAA y el Closer la cierra te doy bono adicional de 100 USD. Tus funciones: Buscar a los prospectos y lograr que acepten la llamada con el consultor precalificarlos para saber si son potenciales para comprar los productos Lograr que el Prospecto llegue con alto grado de interés a la llamada con el Consultor Detalles adicionales: El medio de prospección serian redes sociales y llamada telef&oacut...
Looking for some one who can provide UI for landing page (in XD) of my website. Check attachment. Looking for some one who can do in 12 hours. Once UI approved we can work again for development stage.
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical condi...
I am in need of someone who can help me gather email addresses, we...sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websites, and phone numbe. 4. To manually check the result and collect Website name, Email address and phone number. if there are more than one email address please includ...
...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and...
I'm looking for an experienced software devel...without glitches. - Booking Confirmation: Once a ticket is booked, an immediate confirmation should be sent to the user. This will require integration with email or other notification systems. - Seat Availability Check: Crucially, the software should allow users to check seat availability in real-time. This feature is crucial for making instant decisions on bookings. Ideal skills and experience for the project include proficiency in Windows-based software development and previous experience creating booking systems or similar software. Knowledge of integrating real-time data, like seat availability, into a software system is highly desirable. Experience in working with ticket-booking software will make you an exce...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
I'm seeking an experienced developer proficient in Node.js to create an online booking system for my hotel. Key Tasks: - Developing a booking system with easy-to-use interfaces for single rooms only. - Building an efficient room availability calendar. It is crucial for visitors to be able to easily check room availability and make immediate online reservations. Ideal Skills and Experiences: - Extensive experience in Node.js. Please provide proof of previous similar projects. - UI/UX design. The system should not only work efficiently but also be user-friendly and visually appealing. - Previous experience in building hotel reservation systems is a definite advantage. The goal is to streamline the process and increase my bookings. Please refer to the tasks and skills requ...
I'm seeking an expert audio engineer who can produce a high-quality WAV sound format file that records music in gigabyte quality. The resulted file needs to be compatible to play on various platforms including but not limited to YouTube, Spotify etc. Specifics: - The file should offer unlimited recording capability, with no restrictions in terms of length. - Must possess proven experience in music editing and file formation. Skills in working specifically with WAV formats is a plus. - Familiarity with audio quality requirements for various platforms (YouTube, Spotify, etc.) is crucial. The importance of quality, compatibility, and versatility in this project cannot be overstated. Applicants should bid with relevant portfolio samples demonstrating the abi...
Hi guys, Thanks for your interest in writing for us. IMPORTANT: Human writing only - No AI or Rewriting - (we check) AGAIN BECAUSE THERE ARE SO MANY CHEATERS: NO AI - NO UNDETECTABLE AI AS WE STILL SEE - DON'T WASTE YOUR OR OUR TIME IF YOU DON'T WRITE MANUALLY !!! What we offer: *Writing work at the entry rate of $20/1000 words with room for growth. *Flexibility: No Skyping, no phone calls, accept projects when you have the time to complete them, take time off when you need (letting us know in advance is good practice). *Easy to work with: We reply to questions fast, will provide valuable input and feedback on every single task you complete. *We've been in the content writing and marketing business for 15 years and have worked with more than 2000 clients. ...
I finished your project successfully. Please check and let me know the result. I want you to give me 5 stars review after release a milestone. I will give you 5 stars review.
...a skilled WIX developer to assist me in creating a sophisticated website with E-commerce functionality. Key Requirements: 1. Wix online course setup 2. Membership site setup on Wix 3. Wix full website creation 4. Course Landing page design 5. Membership restriction page 6. Course upload 7. Course thumbnails design 8. Section and step setup properly 9. Course booking 10. Wix sales funnel 11. Check out page customization 12. Email design, email series, workflow, and automation 13. Setup public, Private, and secret course 14. Form, survey, Quiz, Poll, and Questionnaire 15. Design 4 Badge for each Course to assign to student base on the course they attend 16. Wix course drip 17. Payment Gateway integration 18. Domain integration Please Note: - Content and Imagery: I will be prov...
I am in need of a skilled professional who can develop a Rhino Grasshopper script for a pipe network. This script. Check attachment for specs. Ideal skills and experience for this project include: - Proficiency in Rhino and Grasshopper - Strong background in architecture and structural engineering - Experience in developing similar scripts. Please note that the specifics of the script are outlined in the document that will be provided upon engagement. I am looking for a professional who can deliver high quality work within the specified requirements.
I currently have a low-resolution PNG logo that I'm very unsatisfied with. I don't want any changes to the design or colors, I just need it to be remade in high resolution so that it looks crisp and professional.
I'm in need of a thorough background check of a potential employee in Malaysia. This requires searching for and providing information on criminal convictions, arrests, and sentences. Key Requirements: - Check for Convictions, Arrests, and Sentences: The primary aim of this screening is to uncover any past criminal activities of the candidate. - National Level Records: The search should focus only on national level records. The findings will be used for: - Employment Screening: The purpose of this check is to evaluate the potential risks posed by the candidate and make a well-informed hiring decision based on the facts presented. Ideal Candidate: - Experience: A background in legal work, law enforcement, or private investigation would be beneficial. - Discret...
I'm seeking an expert in Failure Mode and Effects Analysis (FMEA) and Process Failure Mode and Effects Analysis (PFMEA) to help in refining our manufacturing processes, primarily concerning Product A, Product B, and Process C. The ultimate goal is to improve the product quality, enhance efficiency, and bolster safety. Expectations: - Thorough inspection and analysis of current processes - Identification and rectifications of potential failure points - Suggestion of practical changes to enhance product quality, efficiency, and safety. Ideal skills & experience: - Proficiency in FMEA and PFMEA - Background in the manufacturing industry - Previous work with similar products and processes will be appreciated.
...work in the following areas: - Data Entry: This involves entering specific data into the website's database and ensuring that all entries are accurate and up to date. - Customer Support: Providing timely and helpful responses to any customer inquiries or issues that may arise on the website. - Content Creation: Generating engaging, informative content for the website to keep visitors interested and coming back for more. The purpose of the site is to assist me with my work, and I need someone who can provide this assistance on a daily basis. It's crucial that the freelancer I choose is reliable and capable of handling these tasks efficiently and effectively. hello I would like to check the legitimacy of the website I am currently building. Also, you can ...
...Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integra...
I am generating QR code for prefill Iphone sms content. Overally, It works well. But when there is ':' in the content, the message is cuted in the iphone content. For example, "Thank you Mike : Bye" => "Thank you Mike " "It is search link " => "It is search link https" I am looking for someone who can fix it immediately. You can test in the attached file. Only bid after you check the attached test file. and start bid with "QR code". Thank you
I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box
I'm seeking an expert in Solidworks design to create instrument GA drawings for water quality analysers. Proficiency in mechanical instruments and knowledge of water quality analysers is indispensable for this task. Key responsibilities will include: - Designing comprehensive water quality analyser models using Solidworks in 3D & 2D GA. - Incorporating specifics of mechanical instruments in analyser designs. - Adapting designs based on functional aspects of analysers. Ideal applicants should be seasoned Solidworks designers with hands-on experience in mechanical instruments. Understanding of water quality analysers would make a perfect fit. If you are meticulous and adept at interpreting technical standards, I'd be glad to work with you.
I'm in the health and wellness industry, and I publish product reviews as my primary content. I'm looking for an experienced SEO specialist who can help me obtain high-quality backlinks to improve my search engine rankings. Key Project Requirements: - Delivering high-quality backlinks from relevant, authoritative websites in the health and wellness niche. - Ensuring that the backlinks are organic and white-hat, in line with Google's guidelines. Ideal Skills and Experience: - Proven track record of successful SEO projects, especially in the health and wellness industry. - Strong understanding of how backlinks impact search engine rankings and credibility. - Ability to secure backlinks from reputable sources without resorting to black-hat tactics.
...account health warnings • Doing regular audits to our product listings to ensure proper operations • Inventory Forecast and Review Management • Communicate with clients (e.g. questions about shipping, content revisions, etc.) • Staying informed with Amazon’s best practices, new trends and technologies, and platform updates • Inspecting landing pages, product information and all other listings to check if they conform to your checklist Preferred skills • Minimum 3+ years of experience working as an Amazon Account Manager or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timeli...
I'm currently seeking a skilled 3D artist to assist with a 3D modeling project. I have a model of a baseball hat that currently lacks a sandwich trim on the front of the visor. I need someone to modify the existing model to include the sandwich trim, matching the design of the real hat. The final model should be ready for rendering using Corona. Please check the attached images for references.
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
I'm seeking a professional video editor who can revamp my Instagram reels. The ideal candidate should: * Expertise in adding filters and effects to make the content more engaging. * Proficient in adding music and sound effects to enhance the interest of the audience. * Abi...revamp my Instagram reels. The ideal candidate should: * Expertise in adding filters and effects to make the content more engaging. * Proficient in adding music and sound effects to enhance the interest of the audience. * Ability to incorporate text and captions creatively. * Proficient in various transition effects: fade, slide and blur to create a seamless flow. * Prioritize high-quality outputs- low or medium quality won't suffice here. I encourage any freelancer with demonstrated experien...
? Calling All Visionary Video Editors! My name is Linus, founder of an innovative advertising agency based in Norway. We’re on a mission to transform advertising through compelling video content that not only engages but inspires. As we prepare for ambitious expansions, including breaking into the dynamic Chinese market, we are searching for the best video editing talent out there. Why Join Us? • Innovate: Work on groundbreaking projects that redefine advertising standards. • Expand: Be part of our exciting expansion into new markets, starting with China. • Collaborate: Join a diverse team of creatives from Norway and beyond, all driven to create stunning visual stories. We are looking for professionals who are passionate about video editing and eager to push cr...
...platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking Order Payment Order Deliv...
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue(&quo...
I'm in need of a Good Quality Inspector to assess the condition and organization of Spiral Separator Components in Carrara, QLD 4211, Australia. The role calls for a professional with: - Keen attention to detail - Familiarity with industry standards The job entails focusing on a selection of components. Responsibilities include: - Unpacking and organizing components - Verifying items against the packing list - Ensuring proper labeling - Inspecting each component for any damage - Reporting any missing or damaged items Having strong communication skills is a must, as any discrepancies need to be accurately reported. Previous experience with spiral separators or similar machinery would be advantageous.
I am looking for an accomplished specialist in report writing who can deliver a detailed and effective quality control inspection report for factories located in China. This report is specifically intended for external auditors usage and thus, it must be both accessible and impressive in its detail and clarity. While detail being key, simplicity should be above all else. Key Requirements Include: - Performance Evaluation: Analyze and document the performance of various processes of the factories product. - Compliance with Standards: Evaluate and report on the compliance of processes with established standards if applicable. - Detection of Defects: Detect and describe any defects encountered during the inspection. - Process Failure Theory: Include a section on the potential reasons ...
Sorry I forgot to add the video I wanted to be edited. Its now here under "can you make it" please review Looking for someone to add 2 edits to this video : 1: at :07 when i say no money, no credit cards and no plan. I want the symbols of circle with line through it to pop up 1 at a time as Im saying it so all 3 are on the screen. Ive attached example pic of what I mean. (ex.1...to Berlin. Also it doesnt need to be straight line to berlin make sure it moves around a little bit. I am also looking for an editor to hire for a week while im in europe, so if you are able to do a good job on this I may hire you to edit 7 videos, 1 per day ~$50-$100 per video. Please show me what you can do and feel free to send any other vlog style videos you have done in the past so I can che...
