Autoit excel databaseεργασίες

We're looking to edit an existing automated process created years back. Youll have to see the attachments to see the correlation below. We would like to generate a QR codes containing the information below to then be printed on the LP and MP cards (as seen in the ) attachment. MP Card 1) Date 2) Part Type- MP 3) Item Group Number- 1 of # 4) Order Number- ORD0076301 5) Customer Name- Legend senior living 6) Item- Legend senior living 7) MP Material Type- SPL Cordovan (#192) 8) If "No Image"- No Image 9) Item Quantity- 25 10) Product Line- SPL LB Card 1) Date 2) Part Type- LB 3) Item Group Number- 1 of # 4) Order number- ORD0076301 5) Customer Name- Legend senior living 6) Item- 4 Part 411 7) LB Material- Black 5265 8) Corners Material- SPL Cordovan (#192) 9) If "N...

I'm looking for a specialist to create a vector database in Azure, aimed at making our rule-based chat bot more efficient in token usage. You will be working with textual data. The tasks involve: - Setting up Azure AI services and integrating with our existing system - Creating a vector database to support our chatbot - Optimizing token usage The ideal candidate should be proficient in Python programming language and has experience working with Azure AI services and rule-based chat bots.

I am seeking a freelancer with experience in hosting .NET Core web applications on AWS. Although I have not decided on the specific AWS service to utilize, candidates with know-how in Elastic Beanstalk, EC2, or Lambda will be greatly appreciated. Key Requirements: - Experience in hosting .NET Core web applications on AWS. - Familiarity with Entity Framework Core and ASP.NET Core. - Proven track record in developing and deploying .NET Core applications. Past work examples will be highly valued during the selection process. As the perfect candidate, you must demonstrate your expertise in these areas and be able to contribute strategically to the decision-making process regarding the ideal AWS service for my project.

Data Entry Specialist Needed for Weekly Task Key Requirements: - Proficient in data entry and comfortable working with Google Sheets - Attention to detail and accuracy in data entry - Ability to complete the task within 1 week Ideal Skills and Experience: - Previous experience in data entry - Familiarity with Google Sheets - Excellent organizational and time management skills

...with an Access/MS SQL database, I need to directly update Drupal tables using data from our database. We can transfer data from our Access database to the MySQL database, but need to update Drupal content from this data seamlessly. We would like to be able to create content directly from our database that can then be viewed as Drupal content. The timelines are strict and the project should ideally be completed within a month. Needed Skills: - Strong PHP programming with profound Drupal knowledge. - An understanding of SQL server and Microsoft Access although we have our own MS Access developer, so this will be to support them. - Previous experience with a similar project will be a plus. Please note, the scope of what information will be included...

We require expertise in developing an Excel file that utilizes VBA code to automate specific tasks. Primary objectives of the project include: - Creation of an Excel file referenced to a specific dataset - Designing a robust VBA code system to import data from the reference file - The VBA code should perform complex calculations and data transformations pertinent to technical and economic analysis The ideal candidate will have a rich experience in data analysis, particularly in managing, interpreting, and simplifying complex data systems, with a strong proficiency in Excel and VBA code development. Familiarity with technical and economic analysis would be highly beneficial. Please ensure you have tangible examples of similar work to showcase. Accuracy, consisten...

m looking for someone to update some python code for me. I have a code than runs each day at 9am. It gets the upselling data of my staff from the previous day and sends an sms to them with their %. It only sends an sms to them if they worked the previous ...2 stores with 2 managers and each manager needs a detailed sms with all the staff at their store and each staff % for the previous day The phython code currently gets the staffs details from a website but the website doesn’t have the staffs phone number, just the name and upselling %. The name and phone number is on a different wesbite. So the code should first run a report and create/edit and excel file with all the staff name and number and then use that to sms their details. We are using twilio to sms the staff (Built ...

I require an expert in Python, specifically with experience in using pandas, I am trying to convert a csv file to excel but am experiencing issues with new line characters. Key Responsibilities: - Amend my current Python script to properly process new line characters when converting from csv to excel - Ensure the success of the conversion without any data corruption or loss Ideal Candidate: - Solid Python coding skills - Deep understanding of pandas library - Prior experience dealing with file conversion challenges This task has a sense of urgency, as I need it completed ASAP. Please bid with consideration to these requirements and the time frame.

I'm looking for an adept PHP MySQL developer to create a simple page to display both text and images sourced from our MySQL database. The primary function required is the ability to update existing entries within the database from this page. No new entries or deletions are necessary at this point. The design should be a fixed layout, ensuring clear and easy reading of the displayed data. Ideal candidates should have strong experience in PHP development, familiarity with MySQL database interaction, and a keen eye for clean and simple design. Display a image Display a web URL in a IFRAME have two buttons - GOOD, BAD which when clicked update the database, then move onto next hit Ability to enter manual queries

Tengo un Excel con unos datos en distintas pestañas que te lo que sumar y añadirle otro dato para que lo sume también.

...that can read and manipulate data from a tour-based Excel file. Specifically, here is what I need from the software: 1. Ability to read an Excel file with 8 columns. 2. The primary functionality should involve reassigning data from column 8 to column 1. However, this transfer must respect one constraint - each value must be unique. 3. Once the reassignment has been completed, the software should be able to export the changed data into a new Excel file. The programming involved in this project may require significant experience with Excel, a strong knowledge of Windows interface, and proficiency in a programming language that can interface with these programs. It’s vital that the software created can function effectively with Excel 2013. If...

I am in need of a highly skilled and experienced Excel expert who can construct a CRM system in Excel to manage my sales data that's tailored to my specific needs. This CRM system should be able to conduct the following tasks: - Capture and manage all sales data. - Track follow-ups effectively, ensuring no opportunity is missed. - Generate reports and analytics based on this data to aide in decision making, including but not limited to, sales trends and future projections.

As a business professional, I need assistance with Excel data entry. Specifically, I need expertise in compiling specific types of data from the web into an Excel format. The project's primary scope entails: - Compiling contact details from various online sources. Given your expertise, you ought to have: - Varied experience in Excel data entry. - A keen eye for detailed, accurate data compilation from the internet. - Strong organizational skills that aid in arranging data logically and usefully in Excel. - Knowledge of Excel functions and commands. - A proven track record in web research. I look forward to receiving well-informed bids from freelancers with matching skills and experience.

We're looking for a freelancer who excels in the creation and implementation of SharePoint lists. Our project involves less than 10 Excel files that need to be imported and transformed into SharePoint Lists. Once successfully implemented, we need these various Lists to synchronize their data effectively. An ideal candidate for this task will have: - Proven experience in working with SharePoint and its List feature - Familiarity with Power BI would be beneficial - Ability to provide detailed project proposals If you can provide guidance on the potentialities and limitations of Power BI functionality, that would be a plus. We value open communication, precision and a results-driven approach.

Création d'un fichier à partir de données sur internet Délais : 48h Budget : 30€

Only for Recruiter In India. Recruiter In Pune will be preferred I'm looking for an experienced HR company that maintains a comprehensive database of potential candidates for recruitment purposes. An integral part of this project will involve a sales person proficient in consultative sales skills and a telecalling team based in our Pune office on Sinhgad Road. Ideal Skills and Responsibilities: - Demonstrated experience in recruitment and HR processes. - Proven track in consultative sales. - Strong team management skills. - The sales person will be responsible for generating leads and managing client relationships. - The telecalling team will need to effectively manage and follow-up on leads generated. Please ensure that your bid includes your experience in these areas.

I need an expert in data entry to implement copying of data from 20 different PDF files, written fully in English, into separate Excel sheets. Key Requirements: - Solid understanding of Excel functionality. - Flawless literacy in English to ensure accurate data transfer. - Ability to follow my predefined format for Excel entries. - Attention to detail for data arrangement based on the sample format provided. Experience in similar data entry projects will be looked upon favorably.

I'm in need of a proficient expert in Excel, SQL, and Python for data analysis, data visualization, and automation. The data complexity is moderate, so a good understanding of data manipulation and cleansing techniques is required. IT IS A TIMED TASK - please only reach out if it’s okay Main Responsibilities Include: - Analyzing the given data - Visualizing analyzed data - Automating tasks that involve data manipulation

I am looking for a skilled freelancer to help with an Excel data entry project that entails advanced formula application. Creativity is welcomed as I am open to the freelancer deciding the most effective and efficient spreadsheet format. A sound understanding of Excel and data manipulation is essential. Knowledge in creating detail-oriented and accurate spreadsheets is a must. Ideally, your skills and experience would include: - Proficiency in Excel - Adeptness in advanced formula application - Ability to design and format effective spreadsheets - Strong attention to detail - Prior experience in data entry projects.

This project revolves around the organization and entry of both textual and numerical data from PDF files into Excel. Specifically, the task involves: - Converting data from both scanned images and text from the PDF source. - Transfering that data into a set Excel format for easier data organization. A freelancer with the ability to decipher and accurately enter data is ideal. Strong attention to detail, proficiency in Excel, and experience with PDF data extraction will be critical for this project. Capturing all the necessary details from both textual and numerical data accurately is paramount.

1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts that have ...

I'm seeking a dot net developer well-versed in the implementation of SDK functionality. The project centers aroun...product IDs using the TSC T800 RFID printer. Expertise in data encryption is crucial for success. Also, deep familiarity with TSC T800 and mastery of .NET programming are coveted. The work includes: - Configuring the TSC T800 for product ID encoding - Accurate and efficient utilisation of the SDK functionality - Assuring the reliable transfer of data to the TSC T800 and successful encoding To excel in this, understanding RFID technology, .NET proficiency, and experience working with SDKs is integral. Applicants with past work on similar projects will be preferred. This project requires precision, meticulousness, and adherence to guidelines, as error-free encodin...

Looking to optimize my current skills in a manner that generates revenue. As of now, I am particularly interested in data entry projects. Freelancers looking to bid on my project, take note: - Prior data entry experience is a key deciding factor. Showcase your experienc...generates revenue. As of now, I am particularly interested in data entry projects. Freelancers looking to bid on my project, take note: - Prior data entry experience is a key deciding factor. Showcase your experience in your application. - Illustrate your ability to deliver quality work in a timely manner. Skills you should ideally possess: - Proficient in Microsoft Office Suite, especially Excel - High attention to detail - Able to work swiftly and accurately. Let's turn our skills into a profitable ve...

I need assistance with a variety of tasks that call for advanced Excel and digital marketing expertise. Excel Tasks: - Inputting financial, sales and inventory data meticulously. - Implementing complex formulas and functions for data manipulation. Digital Marketing Tasks: - Managing social media platforms effectively creating engaging content. - Leading SEO optimizations for enhanced web ranking. - Conducting well-targeted email marketing for improved audience reach. Ideal Skills and Experience: - Proficiency in Excel, particularly data entry, functions and formulas. - Experience in diverse aspects of digital marketing such as social media management, SEO optimization, and email marketing. - Prior experience working with financial, sales and inventory data in a...

I'm in need of a professional...can assist with data cleaning, formatting and entry for my Excel sheets. This project requires an individual who is proficient in data validation as this is an essential function to successfully carry out the task. You will be working with Excel sheets specifically for data validation during data entry and database management. Experience with Excel and a good understanding of data formatting is an absolute must for this project. Key Responsibilities: - Data cleaning and formatting - Data entry and database management - Validating Excel sheets during data entry Skills and Experience: - Proficient in Excel - Experience in data validation - Knowledge in data formatting and cleaning - Strong understandin...

I am looking for an experienced and detail-oriented data entry specialist who can help enter textual data from digital documents into a spreadsheet. The successful candidate should have: - Expertise in data entry. - Strong attention to detail to ensure accuracy - Proficiency in using spreadsheets. - The ability to maintain confidentiality, as the digital...Strong attention to detail to ensure accuracy - Proficiency in using spreadsheets. - The ability to maintain confidentiality, as the digital documents contain sensitive information. Your main task will be to meticulously transfer the textual data from these documents into a well-organised spreadsheet, maintaining utmost accuracy. Experience in working with digital documents and proficiency in Excel/spreadsheet software would...

I need a professional with great proficiency in excel's formulas, functions and Pivot Tables to assist with data manipulation. I've data from 1,300 retail shops, covering 5 different benchmarks, which needs to be manipulated and presented using Pivot Tables - and updated from the example (attached) and for a current error on one state to be rectified. This data is categorized by state, shop size and type, and is numeric. The freelancer should be exceptionally skilled in data manipulation using Excel's advanced functions, and visually presenting the data using Pivot Tables. Prior experience in handling large retail datasets will be an added advantage. In addition to this job, ongoing quarterly maintenance and updates of the pivot tables is required.

genere una formula en excel que permita comparar la franja fin (columna v2 con la hora actual, si la hora actual esta a 1 hora de cumplirse con la franja fin columna V2 y su estado operativo (columna b2) se encuentra en asignado,reportado, o sin planeacion genere una alerta de proximo a vencer, si la hora actual excedio a la franja fin (columna v2) y su estado operativo es asignado, reportado,aplazado arrojar por fuera de la franja horaria. si el estado operativo columna es con novedad o cumplido traer el estado conforme esta en la columna b2 ..... tener en cuenta que la columna v2 esta dada en un formato hora ejemplo 05:00 PM y haga todos los ajustes en la formula para que se deje trabajar con la fecha y hora actual.

I require an expert in Excel modelling to build a robust procurement model focused on cost analysis that delivers an output that will be uploaded to a system. Ideal Experience & Skills: - Outstanding Excel modelling - Outstanding knowledge of procurement and cost measures - Experience with both direct and indirect cost analysis Responsibilities: - Build an Excel model for procuring cost data - The model shall analyze costs, savings and working capital and deliver two outputs to upload to a system. First output will be what the x person has identified as the savings, second output will be what y person decides will be the acceptable solution - Ensure the model generates accurate tracking and control outputs - Create change log - Visually appealing model that lo...

I'm seeking a data entry professional for personal use. The role requires dedication of 1-2 hours daily, ideally someone with speed and precision. Skills and Experience: - Proficiency in MS Excel - Fast typing skills Your primary task will be to assist me in personal data entry tasks, which I expect to be completed in a proficient and timely manner. Only those with the necessary skills and experience should apply. Thanks.

Saya membutuhan rangkuman excel terbaru daftar ongkos kirim. pengiriman JNE ke seluruh indonesia. Ongkos kirim updated per tahun 2024. Tidak menerima data lama. Dibutuhkan semua ongkos kirim jne dari kecamatan sukajadi , Bandung. Misalnya juduk excel = semua data ongkos kirim pengiriman dari kec, sukajadi . Bandjng Saya butuh kolom A = provinssi Kolom B = kota/kecamatan Kolom C = kecamatan Kolom D = keluruhan Kolom E = kode pos Kolom F = ongkos kirim JNE OKE Kolom G= ongkos kirim JNE reg

...proficient Excel workbook developer who can design a system from scratch for me. The primary purpose of this workbook is to keep daily track of business transactions with great accuracy. The following features are crucial for the workbook: - Functionality to track daily transactions. - Automated monthly report generation to precisely sum up the data of a month. - The monthly report should include particulars such as expense tracking, revenue tracking, profit calculations as well as an end of the month balance sheet, tracking of sales, and out payments. In the Sales and Out Payments Tracking section, it is vital to monitor the quantity sold, payment received, and payment date. A closing sheet is also something I'm interested in. The ideal candidate would be well-skilled...

I'm seeking a data analyst who can effetively convert a database from zip format to Excel. Requirements: - Proficient with handling both textual and numerical data - Expert in consolidating database tables into one Excel sheet - Strong understanding of applying specific formatting conditions Skills and Experience: - Proficient in Excel and database management - Experience working with .zip files - Exceptional attention to detail and organizational skills - Proven experience with similar tasks in the past The successful candidate should be able to maintain the integrity of the original data while fulfilling my custom formatting requirements.

I'm seeking a skilled data miner to extract and deliver usernames from 88k followers of a specific Twitter account. This scraping must be GDPR compliant, aligning with my IOC licence. This means you need to delete after excel is made... Even though I only need the usernames, the information should be housed in an Excel spreadsheet. Your expertise in data scraping, particularly from social media platforms, and a solid understanding of compliance requirements, will be crucial to completing this task.

you will be tasked to analyze the company current financial situation using dcf analysis and valuation and then write a small report.

I require a proficient data entry freelancer for a high-priority project. Your task involves generating a comprehensive CSV list, including specific details...to complete the entry Specifically, the CSV list should include: - Names - Phone Numbers - Emails - Websites Timelines and Delivery: I am on a tight schedule and need delivery ASAP. Professionals who can assure prompt delivery will be preferred. Required Skills: - Keen attention to detail - Proficiency in Data Entry - Experience in navigating search engines, specifically Google - Strong Excel/CSV handling skills - Ability to work under pressure and meet tight deadlines Please ensure you can accommodate these requirements before making a bid. Your understanding and quick action are appreciated. 1000 entries per week...

I'm seeking an experienced social media manager who can expertly utilize Facebook and Instagram to enhance my brand's engagement with young adults and parents. The ideal candidate will: - Excel at using Facebook and Instagram to drive engagement - Understand social media strategies tailored to young adults and parents - Have a proven track record for successfully generating leads through social media campaigns In this role, you will be expected to: - Plan and implement effective social media strategies - Monitor and analyze performance data to enhance our lead generation - Create engaging content that speaks to our target audience and encourages lead generation. This is an excellent opportunity to contribute to digital marketing efforts that directly support our ...

I am looking for an experienced professional who is proficient in data collection. The task involves collecting both individual and company contacts, particularly their roles within their given organizations and their email addresses. Ideal Skills: - Effective Internet research - High attention to detail - Data entry - Experience with Microsoft Excel or similar Responsibilities would include: - Comprehensively searching for over 500 individual and company contacts - Gathering important data including email addresses and roles within organizations - Compiling this information in an organized and accessible format I look forward to working with someone who can provide prompt, accurate results.

I need assistance with data entry into an Excel spreadsheet that is yet to be created. The data to be entered includes both numerical and text information. Key responsibilities will include: - Creating a user-friendly and intuitive Excel spreadsheet for my needs. - Entering both numerical and text data into the spreadsheet. Ideal candidate would have skills and experience in: - Excel spreadsheet creation - Data entry, specifically dealing with both numerical and text data - Attention to detail - Meeting project deadlines Please provide examples of past projects similar to this one.

A CALL WILL BE REQUIRED TO GO OVER THE JOB IN DETAIL BEFORE AWARDING NO IFS NO BUTS I need someone with good data collection skills. I need some data put into a spreadsheet it will have 3 columns SHOP NAME, POSTCODE, TELEPHONE NUMBER i will provide links and you have to send me the full sheet back with all the details you may have to search the web to get the phone number the most important info is the TELEPHONE NUMBER and it must be correct any mistakes and you will NOT be paid. this is ongoing work for the right candidate

I need a professional to perform qualitative coding on four interview transcripts using thematic analysis. The interview materials are text transcripts and need to be thoroughly a...thematic analysis. The interview materials are text transcripts and need to be thoroughly analyzed for key themes and patterns. Requirements: - Ability to analyze using thematic analysis - Experience in qualitative research - Proficiency in or NVivo software Your job will be to identify and code prevalent themes, using your expertise in thematic analysis. Instead of a Word document, Excel spreadsheet, or PDF, I need the final coded data in either or NVivo format. Accuracy and depth are key elements for this project, and a strong track record in qualitative research will be highly beneficial.

A CALL WILL BE REQUIRED TO GO OVER THE JOB IN DETAIL BEFORE AWARDING NO IFS NO BUTS I need someone with good data collection skills. I need some data put into a spreadsheet it will have 3 columns SHOP NAME, POSTCODE, TELEPHONE NUMBER i will provide links and you have to send me the full sheet back with all the details you may have to search the web to get the phone number the most important info is the TELEPHONE NUMBER and it must be correct any mistakes and you will NOT be paid. this is ongoing work for the right candidate

I require a talented and experienced database architect to efficiently design and establish an SQL database for my project. Key Functions: - The database should proficiently support data storage and retrieval. Key Details: - Unfortunately, I can't provide specifics about the type of data to be stored. Understanding of a broad range of data types and versality is crucial. Ideal Skills: - Advanced knowledge of SQL - Expertise in database architecture - Excellent problem-solving skills - Ability to work without specific data requirements Time Frame: - This project is urgent. I need it completed as soon as possible, so efficiency and dedication are essential. I look forward to working with a meticulous and dedicated professional who can meet these...

For an upcoming project, I am in need of a dedicated freelancer who can do more than just word processing. I have a word table, its aim is organization of data, and I need it converted into an Excel table with the same structure. A keen understanding of data organization would be crucial to this task. Ideal Skills and Experience: •Excellent knowledge of Microsoft Word and Excel •Proven ability to convert Word documents into Excel files •Detailed understanding of tables and their formatting in both Word and Excel •Strong data organization skills.

I need a freelancer well-versed in internet research and Google Sheets who can collect as many contacts as possible from different divisions of hockey teams. I have a website where many of these things are available I just need someone to grab them and build out a Google sheet. These include their names, email addresses, job titles, and phone numbers. Key Tasks: - Internet research to locate hockey team contacts - Building a comprehensive Google sheet These contacts will be used for marketing outreach, so accuracy and precision are essential. The more contacts you can gather, the better. Ideal Skills: - Experience with Internet Research - Proficiency in Google Sheets - Attention to detail - Experience in Data Entry

Looking to develop an Excel spreadsheet that will streamline tracking of Profits & Losses (P&L), sales, and payments. This obligation demands: - Create excel forms for each client/sale that will encompass information related to change orders, tracking of revenues, tracking of expenses by vendors and liabilities, and profit/loss analysis broken down for each client - Calculations: The spreadsheet must include key formulas such as gross profit margin, profit margin per customer, and payment reconciliation. Ideal candidate should possess advanced Excel skills with a robust understanding of finance and sales metrics. Previous experience in such tasks will be advantageous.

I need someone with good data collection skills. I need some data put into a spreadsheet it will have 3 columns SHOP NAME, POSTCODE, TELEPHONE NUMBER i will provide links and you have to send me the full sheet back with all the details you may have to search the web to get the phone number the most important info is the TELEPHONE NUMBER and it must be correct any mistakes and you will NOT be paid. this is ongoing work for the right candidate

I'm in need of an Excel guru to take on my project that entails budgeting and expense tracking. The gravity of this project leans on the advanced, as the utilization of pivot tables, VLOOKUP, and macros would be crucial. Completing this project demands a strong understanding and practical experience of: - Microsoft Excel - Advanced Excel functions (pivot tables, VLOOKUP, macros) - Finance and accounting (budgeting & expense tracking) If you think you've got what it takes to navigate through the complex labyrinth of numbers in this Excel project, then show me what you've got. Your detailed knowledge of finance and Excel will be put to good use. Looking forward to working with you!

I'm seeking an expert in Excel who can create a formula suitable for analyzing my account transaction data. The specific task at hand involves automating the summing of transactions. The ideal candidate will have: - Proficiency in Excel and data analysis - Proven ability to create complex Excel formulas or VGA macros - Attention to detail I need a formula which will bring up the last value from worksheet "Transactions" column O (looking for multiple dates which are the same), and putting it into D7. In addition, the result needs to change based on the date being greater or equal to worksheet "Account Balance" D3 and less than or equal to worksheet "Account Balance" D4. So, using the attached spreadsheet, the result in "Accou...

I am in search of a highly skilled Power BI analyst to dissect my sales data currently in Excel Spreadsheet format, .csv file and share the dashboard. The ideal candidate will have a strong background in sales analysis with the ability to generate insightful reports that can inform strategic business decisions. Key Responsibilities; - Analyze large amounts of raw data to find patterns and use them to optimize our performance. - Build and maintain reports, dashboards, and metrics to monitor the sales performance. Requirements; - Proven experience in data analysis and data modelling in Power BI. - Strong proficiency and working knowledge with Excel Spreadsheets. - High level analytical skills, attention to detail, and ability to make data-driven decisions is critically impor...