Excel vba open xml file jobs

I have small task need help with excel work and few writing. This is bit urgent.

Task requires a skilled PHP Laravel developer, with expertise in both frontend and backend functionality enhancements. I am looking to make a few modifications/customizations to a script/website. You can view the script (message me). This task requires excellent PHP and Laravel framework skills, as well as good CSS experience. If you excel in these areas and are very knowledgeable, this task should take approximately 1-4 hours to complete. The maximum payment for this task is $30. No bids over $30 USD accepted. Time frame 2-4 days. Some modifications include: Allowing the use of HTML in the content boxes/sections of pages and homepage, Eg: to insert images, videos, info boxes, or any other HTML content. Currently, only plain text is allowed. The aim is to keep it very simple, (an...

You should be skillfull in excel to carry our: Performa DCF analysis of the company, which should include 1. Calculating the FCF 2. Forecasting the FCF 3. Calculating the TV and NPV oft he company

My project involves a comprehensive rearrangement of my existing Excel spreadsheet. The tasks include: - Altering the column order - Modifying the row order - Grouping data appropriately These changes must align with my specific needs, which will be communicated as we proceed - a clear understanding of my requirements is essential. The freelancer best suited for this task would have strong Excel skills and prior experience in customizing spreadsheets to client specifics. Please note, there might be a need for followers up attention, which might include rearranging specific columns. However, these details will be provided as the work progresses. Your ability to adapt to these changes whilst maintaining the quality of work is crucial.

...System Requirements ### Admin Features 1. **User Management** - **Description**: Admins can create and delete user accounts, managing access levels within the application. - **Functionality**: Includes forms for entering user information and mechanisms for account deletion. 2. **Lead Management** - **Description**: Admins can upload leads from Excel files or enter them manually into the system. - **Functionality**: Supports Excel file uploads and manual data entry forms. 3. **Email Notifications** - **Description**: Automatic notifications are sent to admins whenever a new lead or user is created. - **Functionality**: Integrates with an email service to dispatch notifications. ### User Features 1. **Dashboard Customization** - **Descriptio...

...xml Due to an upgrade on MochaHost hosting service, XML and XML+XSL submission buttons are no longer working. MochaHost tech support got the Import buttons on the forms fixed but suggests they may not be able to fix the XML & XML+XSL submission buttons at the bottom of the forms. Here's what they say about that: When the server is upgraded, the Perl modules in the new server might not be fully imported. That's why your website doesn't work because some Perl module dependencies might be deprecated. MochaHost support says: We highly suggest you talk about the error with your Web Developer to ensure they can help you add the missing path on the Perl module. Based on our check, your website form processing is missing pointing to the `File...

Hi, I have an xml file that contain jobs, based on the location of the visitors you redirect to one that has the same city and state. 1st get visiter's location 2nd track information from xml 3rd compare and retrieve specified job info for user's location 4th, randomize jobs and redirect to one link of job 5-If ISP or AS organization is :/amazon/i, /Cloudflare/i, /google/i do not run the code

As an ambitious game designer, I'm looking for a seasoned Unity Developer to contribute to the development of an advanced open-world game. It will be fully developed for the PC and boast realistic 3D graphics to provide players with a surreal gaming experience. Key Requirements: - Strong Unity game development expertise. - Proficient in developing advanced, open-world games. - Exceptional skills in creating realistic 3D graphics. - Comprehensive understanding of PC game development. This project calls for a developer who understands the intricacies of creating detailed, immersive open-world environments. Strong proficiency in Unity and prior experience developing for the PC platform are absolute essentials. Let's create an enthralling PC gaming experience...

I urgently need a specialist in Excel Macros to create a template that can swiftly convert my data from its current Excel format to a specified end format. What I require is: - Expertise in Excel Macros. Although my data is in Excel, this task will require more than basic or intermediate understanding of Excel functionalities. Thus, the ideal bidding freelancer should be adept in creating and applying complex Excel macros. - Fast turnaround. Due to the immediate nature of the project, I require completed work ASAP. Therefore, a freelancer with the ability to work quickly and efficiently would be ideal. - Examples to aid understanding. To make the job more comprehensible, I will provide 'before and after' examples of the data conversion. ...

Create an excel sheet where I can score my columns based on categories and sub-categories. There are Two major groups. Likelihood & Impact. The end goal is to get a final Likelihood and Impact score for a bunch of risks. the max allowed score is 9 for both these groups. Each group is divided into 6 categories. Each category can have a max score of 1.5. Each category has 3 sub categories. Each sub category can have a value of 0 or .5. The categories and its subcategoreis for likelihood score is shown below. I need an excel sheet that can help me do this calculation where I can select the value of each sub-category (0 or .5) and I should have a total score of the category and then finally a total Likelihood score. The same will apply for Impact scoring. I can share the I...

I’m looking to hire a proficient Microsoft Excel expert, specifically, someone who excels in automation tasks. Tasks for this project include: - Creating automation scripts for: - Data Formatting: The job will require you to set up scripts that format data according to preset conditions. Understanding of and experience with conditional formatting in Excel is critical. - Report Generation: I will require automatic generation of reports from collected data. Your experience with creating automated report systems in Excel will come in handy. In terms of skills, experience with Excel including knowledge in macros and VBA scripting is a must-have. The ideal candidate should have developed automatic report systems in the past and has extensive e...

I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidate for this job should...

We are currently seeking English voice actors for male characters for a gaming project. Here are the desired skills and experience: - Voice acting experience - Ability to deliver a quick turnaround, as this project needs completing ASAP. - Understanding of audio recording and editing tools. - Excellent inter...and expressiveness, to ensure the audio captures listeners' attention. Due to the confidentiality of the project, we will send you the audition files upon receiving your application. If possible, you may also send your voice reel and contact information, so that we can reach out to you promptly for any suitable opportunities in the future. This is an exciting opportunity for voice actors who excel at creating intense, dramatic performances. Your voice could bring my p...

I'm looking for an expert to convert NX files to SolidWorks or STEP format, with no modifications to the design during the conversion process. Key Job Responsibilitie...the conversion process. Key Job Responsibilities: - Conversion of provided NX files (est 2GB) to either SolidWorks and/or STEP format. - Ensuring no modifications to the design during the conversion. Ideal Skills/Experience: - Solid understanding and proficiency in SolidWorks and STEP format. - Proven experience in converting NX files. - Attention to detail to ensure total accuracy of existing file organization. - Good communication skills to report progress and any potential issues. - Willing to sign an NDA - Based in USA Please note, no additional tasks will be required post-conversion such as rendering...

...has a keen understanding of the top trends in the iconography. The creative direction for this project leans towards a clean, simplified look that better matches Windows applications such as the Microsoft Office suite icons, for example, Word, Excel, and PowerPoint. Key Project Requirements: - Your design should reflect a professional yet attractive flat design style - The color scheme should be sophisticated and simplistic, complementing Microsoft Office's aesthetic - Please incorporate design elements that resonate with Microsoft Office's Word, Excel, and PowerPoint icons Ideal Skills and Experience: - Demonstrable experience with flat icon design - A deep understanding of Microsoft Office's design aesthetics - Provable proficiency in graphic design sof...

I'm looking for a MySQL expert who can create a complex query to retrieve data from multiple tables (Table A, Table B, and Table C) of my database. These tables are interconnected, and the goal is to join data from all these tables, perform necessary calculations, then save the result into another table. Excel file with explanation is attached. Required Skills: - Experience in MySQL query writing - Ability to handle multi-table complex join operations

I'm seeking a proficient freelancer to convert my Excel spreadsheet into a user-friendly form. This form will require expertise in creating interactive components for data entry, incorporating error checking devices, and embedding calculation functionality. Key Aspects: - I require text boxes and drop-down menus for the data entry fields, ensuring a smooth and efficient user experience. - The form must seamlessly check for errors as data is entered, flagging any inconsistencies or inaccuracies. - The ability to tally calculations within the form is a must-have feature. Ideal Skills: - Experience with Excel to form transformations - Proficiency in text boxes and drop-down menu creation - Strong aptitude for error detection and rectification As this is urgent, I need...

...application that caters to multiple platforms while integrating essential elements of connectivity and file sharing. A suitable freelancer would have the skills and expertise necessary to implement the following: - Connectivity features centered around Bluetooth and TCP socket, effectively enabling the application to communicate with other devices. - A well-designed feature for downloading files, ensuring seamless data retrieval, and information exchange. Additional capabilities that a successful freelancer should possess include: - Proven experience with cross-platform application development. - Expertise in integrating Bluetooth and TCP socket features. - A solid background in developing file download functionality. - A track record of delivering feature-rich and user...

... This sector includes establishments like restaurants, bars, pubs, breweries, wineries, takeaways, hotels, and residences. Key Responsibilities: • Identify relevant companies in the stated sector • Accurately find and collate their email addresses and phone numbers • Meticulously organise data gathered into an Excel Spreadsheet Preferred Qualifications: • Proven experience in data mining or a similar position • Proficient in data collection and management • Familiarity with Excel and other data organisation tools • Ability to meet deadlines and maintain accuracy Ideal Application: Detailed project proposals would be highly appreciated. They should include your approach or method to the task, anticipated challenges, proposed solutions, ...

I need to modify colors on a product image

...the dropdown will populate with the values that will be sourced from the Excel file. The user will select one value from the dropdown. Based on that value the data will load from the access database. This data grid will be changed by the user and it needs to update the access database accordingly in real time.. There will be multiple users on the website, more than 350 and they will constantly be changing this. There is also a third factor, the main Excel data, and will all get changed according to that file, this needs to be updated every 10 minutes. We have a project in C# completed but it is not working on the multi-user environment, because changes are not made in real-time, and instead of MS access we use Excel to archive the data. Also, it i...

As per our discussion i want to update the existing file

I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidate for this job should...

Hlo! I have done MS in statistics. I read your job description. I have expertise in SPSS, R studio, excel, data visualization and statistical analysis. I will provide you with the finest work that perfectly aligns with your time and budget constraints. Thanks waiting for your response. Regards, Hira Mahmood

I'm looking for a Microsoft Excel guru who can re-arrange my numerical data, which is in multiple columns, in a random order. The purpose of this randomization is so i can call numbers in random order.

In need of a seasoned Excel VBA expert to develop a comprehensive techno-economic analysis tool for solar projects. The automated tool should accomplish the following: - Automate data entry - Generate informative reports - Perform data analysis to inform strategic decision-making Key functionalities to include: - Calculation of Return on Investment (ROI) - Estimation of energy production The tool should take the following inputs to calculate ROI and energy production: - Initial Investment Cost - Annual Energy Production - Energy Tariff - Maintenance Cost Ideal Candidate: - Mastery of Excel and VBA - Previous experience in creating financial/technical analysis tools - Understanding of solar energy industry would be a plus

I require a skilled freelancer to convert my PDF document, which is less than 10 pages long, into an Excel file. All data from the PDF needs to be included without exception. This task does not require replication of the original PDF format during conversion. Ideal Experience & Skills: - Experience in data entry - Proficiency in Excel - Detail oriented - Prior experience with PDF conversion to Excel will be a bonus. This task is simple and straightforward yet it requires precision; therefore, applicants with a keen eye for detail are preferred.

I need a custom Excel database with a scorecard for tracking and storing specific data related to the customization of my cow-calf ranch. The main points to evaluate are: 1. Cow & Calf Weights: The database should be capable of storing, tracking, and analyzing the weight of both cows and calves. 2. Pregnancy records and AI: These essential data must be incorporated into the database and made easily accessible for regular reviewing. 3. Feeding info: Details about what the animals are fed, when, and how much should be easily trackable. 4. Graphics Specification: The data should be visualized through engaging and informative bar charts. 5. Individual Animal Productivity: The bar charts should clearly show individual animal productivity. The right candidate for this job should...

...distributing content across my social media platforms and blog. This system should be compatible with Facebook, Instagram, YouTube, TikTok, and Wordpress, Using automations, having a control panel for editing each post if necessary All content is in Hebrew Language My objective it to: 1. Create a blog Article/post on my site though: A. A list of articles names, Category, keywords, Meta description (Excel sheet). The article will consist of a minimum 900 words, and will include: introduction, content, bullet points, quotes, and any SEO tricks to make it more appalling to google search engine, Including research and publications sources links. (we will add Images to the article ourselves) You may see an article format here :

This project will involve extracting data from the Collins Dictionary website for personal stud purposes. The goal is to scrape all the entries in the Italian-English and English-Italian sections of the site. The data will be used in a flashcard app (Anki), so would need to be put into 2x Excel files, with each dictionary entry on its own row, and columns containing all relevant grammatical information and example sentences. In need of a highly skilled web scraper. You need to avoid disrupting site functionality, which can lead to access denial or legal issues. Prior experience with data extraction from language-related or education websites is a plus. Key requirements include: - Extraction of Italian to English, and English to Italian translations from Collins Dictionary websi...

...column and row values. - The task involves finding discrepancies based on an exact match criterion; any noticeable differences should be flagged. - Once a discrepancy is detected, the chosen freelancer should highlight it in the original CSV file rather than creating a new one or recording the differences in a separate document. Skills and Experience: - High proficiency in handling and managing CSV files. - Experience in data comparison and error spotting, especially in large datasets. - Advanced knowledge of spreadsheet software, such as Microsoft Excel or Google Sheets, to effectively highlight discrepancies. - Excellent attention to detail, providing accuracy in finding discrepancies based on exact match criteria. If you're detail-oriented and have a knack for d...

I'm seeking an Excel professional with strong skills in exploratory data analysis (EDA). Key tasks include: - Performing data visualization - Applying descriptive statistics - Conducting missing data analysis The main goal of this project is to conduct a thorough EDA to find insights and anomalies within the data. This analysis needs to be done on an Excel file that is larger than 1GB. The ideal freelancer for this project would have significant experience working with large datasets, especially in Excel, a good understanding of EDA techniques, and a knack for uncovering hidden trends and patterns. Strong skills in data visualization, descriptive statistics, and missing data analysis are essential for this role. University project, serious individuals ...

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

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

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...

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 da...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 ...

...install and set up an Open EMR system. The project will include, but not limited to: - Installation of Open EMR - Configuring the server for optimal performance - Creating a user-friendly interface for our small team No data migration is needed. We are starting from scratch so we need the system to be clean and ready for us to input new data. Ideal candidates should have: - Strong experience in Open EMR installation and customization - Knowledge of server configurations - Ability to complete the job swiftly and efficiently This is a unique opportunity suitable for professionals who are well-versed in Open EMR and server maintenance. Your expertise and diligence will play a foundational role in our business operations. 1. Install Open EMR ...

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.

...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 ...

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.

Hi Abdulrahman E., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

A quick job for someone who knows PHP and CSS! I need a competent developer to remove all season-specific images from my PHP index and CSS file. The important requirements for this job are: 1. Image Removal: comment out all the Christmas-specific images (so they can be brought back at a later date) 2. Image Placeholder: The removed image placeholders should be left empty until later. 3. Layout: The cleaned-up index and CSS file should maintain the current layout and design format. Ideal for a candidate experienced with PHP, CSS, and has a keen eye for detail. Quick and efficient work expected.

I am in need of a skilled WooCommerce developer with experience in third-party API integration. The specific task is to integrate WP Fusion that connects to Salesforce into my WooCommerce website. This project will require: - Deep understanding of the WooCommerce platform - Proficiency in custom coding for API integrations - Prior experience with Salesforce and WP Fusion is a must - Strong knowledge of e-commerce websites At the moment, WP Fusion doesn't support syncing person types from WooCommerce bookings (). However, if you have access to a developer, you can sync any additional data from a WooCommerce order by using the wpf_woocommerce_customer_data filter. We have examples here for your reference: With your help, I look forward to enhancing my e-commerce capabilities an...

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.

...platform and external websites through XML data exchange. The chosen freelancer will be responsible for leveraging the powerful capabilities of the WP All Import plugin to streamline the import and export of XML data. The GUI should enable users to effortlessly configure import settings, map XML data fields to corresponding WordPress custom fields, and schedule automated data transfers. Key responsibilities include: - Designing and implementing a custom GUI within the WordPress admin interface. - Integrating the WP All Import plugin to handle XML data import and export tasks. - Providing intuitive controls and options for users to manage XML data transfer settings. - Ensuring compatibility and smooth operation with various external websites and X...

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.