Sql bulk load excel jobs

This is a one of project; I'm looking for an Excel expert to develop a workbook enabling data analysis of multiple bank and credit card statements. This workbook must have the ability to run multiple functions/reports - Implementation of SUM and COUNT functions. - Utilization of VLOOKUP or HLOOKUP. - Creation of Pivot Tables and informative Charts. The ideal candidate would be someone with prior experience in financial analysis or data engineering, who can ensure that the workbook provides the insights needed. Ability to ensure accuracy and relevancy within the formulas and functions is essential. Attached is a sample data file. This is a pdf to excel conversion. Prior to submission, the conversion data will be sanity checked and verified. If an alternative format...

I'm looking for an expert who can help me to automate k6 Browser performance testing. If you have never worked on k6 Browser performance Please Ignore. I have an applicaion we need to find the performance of that application. eg which http request is taking time and which page is taking more time to load upto 10 to 50 users Skills/Experience Needed: * Should work in Javascript * Need to work in k6 browser performance testing * run the test locally upto 10 vus * run the test in k6 cloud upto 100 vus

Please Sign Up or Login to see details.

I have an Excel sheet with some data that needs a basic clean-up. I'm looking for someone who can help me with this task. Key Responsibilities: - Remove duplicates from the data - Ensure the data is clean and free from any inconsistencies This task is fairly straightforward and doesn't require any advanced data cleaning techniques. It's more about ensuring the data is accurate and removing any unnecessary repetitions. Ideal Skills: - Proficiency in Excel and data entry - Attention to detail - Ability to follow instructions and deliver work accurately and on time This project is ideal for someone who is starting out or looking for a quick task to complete. If you're good with Excel and data management, this would be a good fit for you.

I need an Excel expert to create an advanced sheet for employee management. This sheet would primarily serve two types of employees, sales and telecallers, and perform multiple significant tasks. Key Features: - The sheet should calculate sales data and commissions. - It must track daily leads assigned to the sales team. - It needs to generate reports on business shared between telecaller and sales teams. Design Requirements: - The design should be simple and minimalistic. - It must have color-coded cells for easy interpretation and usage. As the Excel version was not specified, the sheet should ideally be compatible with multiple versions to ensure smooth operation. Ideal Skillset: - Advanced knowledge of Excel. - Experience in creating sophisticated Excel...

Support required for vue.js, node.js, .NET and sql

I'm looking for a developer to create an airdrop script specifically for Solana SPL. The main aim of this script is to distribute tokens to a specific, pre-selected group of Solana SPL addresses/wallet. The script/app able to read the list of addresses/wallet from txt or Excel . The distribution needs to be fully automated, without requiring any manual intervention. The amount of tokens need to be specific or random from 100 to 1000 etc. Also be able to adjust the Sol sending fees. Key requirements: - The script should be designed to distribute tokens to only a specific, pre-selected group of Solona SPL users, not all users. - It should be fully automated, meaning the distribution process should not involve manual intervention. Ideal skills and experience: - Proficiency in de...

New freelancer welcome, I'm in need of a virtual assistant to help with my project , quick copy-paste job. My need video clip copy and pasts Excel sheet. I will give video link just need copy time clip. Ideal Candidate: - Proficiency in copy-pasting tasks - Ability to complete the task within a few hours - Experience in virtual assistance would be a plus. Looking forward to working with you! More discus with freelancer chat. Need strong freelance. Thanks

I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understandi...

I am struggling with a range of issues in my SQL database that are affecting my business operations. The primary challenges involve: - Slow database performance. - High CPU usage rate. - Regular timeouts and deadlock situations. The size of my database is substantial, significantly above 10GB, implying the need for a professional who can manage and improve large-capacity systems. The target areas for amelioration in the SQL database include: - Efficiency of the queries. - Table partitioning strategy. The ideal candidate should evidence expert skills and a successful track record in managing large SQL databases, improving query efficiency, and implementing effective table partitioning strategies. In-depth knowledge of comprehensive database performance tuning and ...

Hi Shaz. I am creating a project for the Load Ready project. Please upload ALL of the graphics in their FINAL formats in the usual 4 folders: 3D Box, Icon, Splash Screen and Logo. There are too many graphics sent to me by WhatsApp that it's confusing. This way, I can more easily retrieve everything from Freelancer. Thanks for understanding.

- one color but different qty for different sizes - the customise button will work with it - order details will show the qty for different sizes

I'm looking for a data entry operator who can assist me with cleaning, verifying and entering a small volume of data from handwritten documents. - The task involves verifying data for accuracy, identifying and correcting errors, and entering the information into an Excel or CSV file. - The data volume is small, around 1,000 records, making it an ideal project for someone who is detail-oriented and meticulous. Ideal candidates should have: - Experience in data entry and data cleansing tasks - Proficiency in using Excel or CSV files - High level of attention to detail - Ability to work with handwritten documents If you possess these skills and are interested in working on this engaging project, please submit your proposal.

I am currently facing connectivity troubles with the entire server where Internet Information Services (IIS) is operating on my Windows 7 system. Key responsibi...issues related to IIS, focusing on eliminating the connection problems to ensure smooth operation. 2. Secondly, I have a WordPress website that needs updating to the latest version that I have already downloaded. Bring the site up to date without affecting its functionality. 3. Lastly, there are a few SQL records requiring fixes. Desired Skills: - Expert in troubleshooting IIS running on Windows 7 - Proficient in WordPress updates and maintaining website integrity - Track record of resolving SQL record issues efficiently Please note, the priority is to get the IIS on Windows 7 working smoothly, and then focus on...

I need an experienced trainer to guide me k6 browser performance automation and reporting. I am the sole participant for this online training. Essential Qualifications: - Proven expertise in K6 advanced scripting - Proven success with load testing strategies in K6 - Experience in conducting one-on-one online training sessions - Excellent communication skills and patience to deal with queries Your primary task would be to enrich my understanding of the above-mentioned topics and help me become proficient in the application of the same. I appreciate interactive discussions and genuine assessments post training to gauge my progression. Looking forward to a knowledgeable learning process.

I would like to create a solution (can be EXCEL, etc.) for creating working schedule, your solution must have these features: 1. Allow multiple locations, with different schedules and number of workers; 2. Setup multiple workers, set dayoff, hours per week, min hours per day and max hours per day; Example: The worker can have 2 days off (w2 = Monday, w3 = Tuesday, …), should work 48 hours per week, and 5 until 8 hours per day (in sequence, 10:00 – 15:00). 3. Views per week, per month (and per location or per worker) – generate a week / month schedule per location and per worker. 4. A random button to regenerate all again 5. And a button to make equilibrium (YES or NO), with YES on this button, your solution will try to adjust the schedule to ensure the &ldquo...

I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...

Please Sign Up or Login to see details.

I require whatsapp marketing for sending my Website's content (Promotional content) to bulk audience. Need to send (@Whatsapp) Content, along with video or Image & "Call_To_Action URL" to Nearly 1 Lakhs audience. To Get Bulk Audience - Engage & Leads Generation, for Re-Targeting (again on Whatsapp), from the total Reach & Clicks (Engage). Let me know the feasibility of the Reach & statistics of the same, to get the List of Reach & Clicks, for Re-Targeting tasks.. Pls NOTE : I Require Testimonial & Demo for the Work assigning. Thanks

I'm in need of a professional who can accurately convert scanned PDFs into Excel. 3 different sheet for each supplier. The PDFs are inventory sheets that need to be organized by item number. These sheets will be used for inventory management, so it's crucial that the data is correctly transposed. Key Requirements: - Convert scanned PDFs to Excel - Organize data by item number - Implement conditional formatting to ensure data accuracy Ideal Skills: - Proficiency in data entry and conversion from PDF - Advanced Excel skills, especially in organization and conditional formatting - Experience with inventory management or similar data handling is a plus I look forward to receiving bids from professionals who can guarantee quick and accurate work.

...implement a bulk upload feature for FNSku to ASIN conversion via Amazon API. The ideal candidate will have experience in API integration and database management. Key Project Requirements: - Implement a bulk upload feature for FNSku to ASIN conversion - Utilize Amazon API to extract the ASIN number from the given FNSku - Develop an API database to store and retrieve the ASIN number and the FNSku Additional Functionalities: - Ensure the system allows bulk upload of Excel files - Incorporate the ability for users to download the conversion results - It's essential that results can be downloaded in a specific format, and in this case, directly to an API database. Ideal Skills and Experience: - Prior experience with Amazon API integration and product data ...

I'm seeking a proficient database developer to construct an online database using MS Access. This database will primarily store and manage our transaction history. Key Responsibilities: - Implement a MS Access Online databas...store and manage our transaction history. Key Responsibilities: - Implement a MS Access Online database solution - Store and manage transaction data - Generate basic reports upon request Ideal Skills: - Extensive experience with MS Access database development - Knowledge in transaction data management - Ability to create basic level reports. This project will require a clear understanding of SQL and best practices for organizing and storing transactional data. For those interested, please ensure you have relevant qualifications and proven experienc...

...containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data retrieval from QR scans. This entails a complex task, requiring ...

I'm in need of an expert in drone design and engineering to ensure that my heavy lift drone will be able to meet the requirements I have in mind. In particular, I need to ensure that it can carry a load of 325 lbs, fly for 30 minutes, and is powered by 8x) 21.5 HP gas engines. Key Requirements: - Design and load capacity: You'll need to ensure that the drone design can handle the weight of 325 lbs. - Flight time: It's crucial that the drone is able to fly for at least 30 minutes at a time. - Power flow: You should have expertise in power systems and be able to verify that the 8x) 21.5 HP gas engines are sufficient to power the drone. Ideal Skills and Experience: - Proficient in drone design and engineering. - Strong knowledge of power flow and systems. - Expe...

Project Title: Mobile Page Loading Time Optimization for Kajabi Website Description: I am looking for a skilled Kajabi developer who can help me optimize the loading time of 30 slow-loading mobile pages on my Kajabi website. Currently, the mobile pages take more than 5 seconds to load, which is causing a poor user experience and affecting my website's performance. My site is Specific Requirements: - Improve the loading time of mobile pages on my Kajabi website to ensure they load within Google's recommended timeframe (less than 2.5 seconds). - Identify and resolve any technical issues or bottlenecks that are causing slow loading times. - Implement best practices and optimization techniques to enhance the overall performance of the mobile pages. - Work closely wit...

I'm in need of a versatile data scientist who can expertly navigate both Python and R. For this assignment, you should be proficient in various data analysis techniques including: - Predictive modeling - Data visualization - Statistical analysis The dataset I'll provide comes in Excel format. Your task will be to demonstrate these techniques in Python and R as accurately as possible. Please submit a bid if you're confident in your ability to efficiently illustrate professional-level data analysis in both languages. For now, I only need Part 1 and Part 3 to be done. Part 1 has multiple subparts and should be done in R language. While Part 3 should be done in Python

I need a JavaScript expert who can identify and resolve compatibility issues in my code, and optimize it for better performance. The tasks primarily involve: Application is - "online application for digital evalution of answercopies with marks annotations" - Fixing a data fetching and display functionality that is current...in JavaScript and experience in debugging code. - A good understanding of compatibility issues in web development. - Proven experience in optimizing code for performance. Your expertise in these areas is crucial to ensuring a smooth and efficient user experience on my website. We are looking for long term association as the project is an running project it is created on asp.net c# and mvc with sql database. It is a serious job with time bound and ...

I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I am seeking expertise in moving data from our current on-premise SQL Database to Microsoft Azure. Here are the specifics required: - Experience in data migration with a focus on Microsoft SQL databases. - Expertise in handling and ensuring entity relationship correctness during the migration process. - Proven ability to maintain data integrity and quality throughout the migration process. - Availability for possible follow-ups after migration. Your bid should demonstrate a clear understanding of the task and experience with similar projects. When responding, kindly provide examples of related projects you've handled.

I am seeking expertise in moving data from our current on-premise SQL Database to Microsoft Azure. Here are the specifics required: - Experience in data migration with a focus on Microsoft SQL databases. - Expertise in handling and ensuring entity relationship correctness during the migration process. - Proven ability to maintain data integrity and quality throughout the migration process. - Availability for possible follow-ups after migration. Your bid should demonstrate a clear understanding of the task and experience with similar projects. When responding, kindly provide examples of related projects you've handled.

I'm in need of a skilled web designer to create a portfolio website for me. I have an existing website that I am looking to create a fresh, creative, professional, easy to navigate, load quick and informative site. The person who is awarded this project must have great communication skills, in the sense that when I provide feedback, you understand and integrate my comments. Or be able to tell me why my comments are not a good idea. We are based in the USA and on Eastern Standard Time. Company or person awarded this project MUST be willing to working on our time schedule, during our hours, so not to delay the project due to any possible time difference. You must not only be able to create a website, you must be creative. Have an eye for design. Here are some details: 1) ...

...develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency in Microsoft Excel...

I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.

Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?

...Minecraft shader and texture pack installations, as well as PC performance assessments. I'm running a high-end system(don’t really know if my system is high end)and would like to install shaders and texture packs to enhance the performance of the game. Key tasks include: - Install shaders and texture packs in Minecraft. - Conduct an assessment to ensure that my high-end PC can handle the added load without compromising performance. - Provide recommendations on additional tweaks or upgrades if necessary to maintain optimal performance. Ideal skills and experience: - Extensive experience with Minecraft shader and texture pack installations. - Proficiency in PC hardware and software assessment. - Ability to provide practical recommendations for performance optimization....

I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding -...

...my house. The task involves planning for a new wooden beam that is to be added to support a significant span of 13 feet. Your proven knowledge and experience in structural engineering, structural calculations, and home renovations will enable you to accurately determine the beam's specifications including size, load capacities it has to support, and how it interacts with other elements of the structure. Main values I'm looking for in a freelancer includes: - Proficiency in Load and Resistance Factor Design (LRFD) - Solid understanding of wood engineering - Experience with calculating beams for home remodeling - Compliance with local building codes and regulations Armed with these skills, you'll ideally be able to provide suitable options for the n...

...details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward to working with someone who can help streamline ...

I need an experienced developer to extend my existing PHP SQL driven platform. This project revolves around adding innovative features to the current structure. . Your job will include: - Analyzing the current structure and proposing alterations to accommodate the new functionalities robustly. - Implementing these suggestions after my approval with special emphasis on maintaining the overall performance & responsiveness of my website. To be an ideal fit for this project, you should: - Have previously worked on expanding PHP SQL based platforms. - Be capable of producing detailed project proposals. Apply with your most detailed project proposal, including your understanding of this task, estimated timeline, milestones, and why you think you're suitable for this...

I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.

Hello. We have an issue with our website. its server related. So we need someone to fix this ASAP. It takes more than 5sec for our website to load.

Notice: put the real price i don't add milestone after. I have a website link to copy the layout and give me the ability to change the photos and the text . i don't want to lose the Envira gallery and Formidable that i have already on my website. Can you do it offline and change it to my host wen we write and load the photos one time instead of keeping the website down while working on it ? Seeking a proficient website designer to create a replica of a simple yet aesthetically pleasing portfolio website. This website will serve a critical function of displaying my works and will require: - Integration of specific design elements such as Envira Gallery and Formidable, which reflects my brand. - The implementation of specific functionalities; an image gallery using Envira...

Excel to PDF Entry Work need to be done

1- Convert the excel data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. This flag should provide the user wit...

I have a costumer list that usually contact with email. I need a system for send bulk message on them Whatsapp number. Note: you don’t have to coding a program. Just setup a program that already work for do that.

I need a proficient data entry operator to assist a task involving typing handwritten documents into Excel spreadsheets. The ideal candidate would have previous experience in data entry, and a high speed typing ability. Accuracy is key in this project, as they'll be transcribing valuable information, it's critical every detail is correct. Time management skills are also important, as there's a specific deadline to complete the task. If you've done similar jobs in the past, please mention it in your proposal. I look forward to working together.

I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.

Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.