Excel macro export xml jobber
I'm looking for a Python developer who can create a data analysis tool for my motor and inverter rig. The primary objective of this tool is to analyze historical data, specifically sensor data. Key Requirements: - The tool should be able to support various data formats including CSV, mdf, and mf4. - Expertise in Python is a must, and experience in creating similar dat...should use Matplotlib for data visualization. The GUI should support advanced interactivity including filtering data and custom query inputs. The GUI should include drag-and-drop functionality for an improved user experience. The tool should be beginner-friendly with easy navigation and tooltips for guidance. The tool should be a desktop application. The tool should be able to export analysis results to PDF and...
I need a professional to automate my FME workflow, focused on integrating data from various spreadsheets into a cohesive dataset. The primary type of data is tabular, and the main goal of this project revolves around efficient data integration. Ideal Skills: - Proficiency in FME (Feature Manipulation Engine) - Extensive experience with tabular data - Compete...Knowledge of ETL (Extract, Transform, Load) processes - Proficiency in scripting languages such as Python or R Experience: - Prior work with FME workflow automation - Proven track record of successful data integration projects - Experience in handling large sets of tabular data from spreadsheets. The final integrated dataset should be provided in CSV format. The workflow should include **using Excel** to address data incons...
...expert in Smart Sheets and Excel to help with project management, focusing on sales data analysis. The ideal candidate will have experience with task assignment and tracking functionalities, as well as setting up automated reporting systems. Key Responsibilities: - Utilize Smart Sheets and Excel for effective project management. - Analyze sales data to inform project progress and strategies. - Set up systems for task assignment and tracking. - Implement automated reporting to streamline project updates. - Ensure seamless integration of Smart Sheets and Excel with CRM systems. - Create visually engaging dashboards for sales data visualization. - Develop custom reports based on specific project needs and metrics. Skills Required: - Proficiency in Smart Sheets and ...
I'm looking for an Excel wizard to create a single-sheet, all-inclusive spreadsheet for tracking packing efficiency. The sheet should be able to calculate how many boxes are packed per hour based on inputted data. Key Features: - The spreadsheet will need to incorporate different box types and their worth. For example, "1.5 ctn worth 1 box" and "dishpack ctn worth 3 box". - It should be able to generate the total number of boxes packed per hour based on how many of each box type is packed. - Conditional Formatting will be used for clarity. The ideal freelancer for this project should have extensive experience with Excel, particularly with creating sophisticated formulas and using Conditional Formatting. A good understanding of logistics and packin...
I need help updating my weekly Profit and Loss statement. The process is quite nuanced, and I will need to communicate with you regularly. The task involves gathering data from various sources. Data Sources: - Internal...with you regularly. The task involves gathering data from various sources. Data Sources: - Internal company databases - External financial portals - Spreadsheets from different departments Data Format: - Primarily in Excel spreadsheets Your Tasks: - Data entry and consolidation - Data analysis and interpretation Once you become proficient and knowledgeable about the process, it should take no more than 2 hours per week. However, I need assistance every week. Ideal candidates should be experienced with data analysis, have a keen eye for detail, and be proficient...
I need a freelancer to assist with a small project focused on gathering and entering data from various research sites. The task primarily involves collecting textual information from these sites. Ideal Skills: - Excellent attention to detail - Proficiency in data entry - Familiarity with research websites The process will...research websites The process will involve: - Simple text extraction from identified research projects across several different websites. Your role will be crucial in helping me compile this information accurately and efficiently. The estimated volume of data collection is medium (101-500 entries). Please enter the collected data into a spreadsheet format. Please enter the collected data into an Excel spreadsheet. The expected time frame for this project ...
I need a Python program that will analyze my Excel data for me. The file has 10,000 rows and 40 columns. The program should: - Examine a specific range within column B and extract all numerical values from the text of each line. - Create a new Excel sheet where these numerical values are inserted into one or several columns adjacent to column B. - Retain all other columns from the original sheet in the new one. Additionally, all numerical values need to be converted to decimals before being inserted into the new sheet. The ideal freelancer for this project should have: - Expertise in Python programming, particularly with data analysis and Excel manipulation. - Experience in writing Python scripts for Excel. - Ability to convert numerical values into decimal...
...professional typist who can accurately transcribe my handwritten notes into an Excel spreadsheet. This will involve using specific formulas within the spreadsheet. Ideal Skills and Experience: - Proficient in Excel, with a solid understanding of how to use formulas - Exceptional typing skills - Detail-oriented and capable of accurately transcribing handwritten notes - Previous experience with data entry - Ability to maintain confidentiality and handle sensitive information with discretion The typist should use SUM and AVERAGE formulas in the spreadsheet. The project involves less than 50 handwritten notes. The handwritten notes follow a specific structure. The handwritten notes do not require any specific formatting in the Excel spreadsheet. The project needs to b...
I am looking for a professional with expertise in Power Automate to help me extract data from two sources: an auction website and a real estate website (Zillow or ). The final output should be an Excel spreadsheet containing the extracted data as described below. Key Tasks: Auction Website (Grey Columns) Extract all the data from the grey columns (as per the attached example) on the Atlantic County and Cape May County auction websites. The data should be saved in an Excel spreadsheet. Each county’s data should be saved on a separate tab or a separate file. Real Estate Website (Purple Columns) For each property listed on the auction website, match its address with the details available on either Zillow or Realtor.com. Extract all the columns in purple (as per the attache...
...role-based access controls (RBAC). Configuring secure connections (HTTPS, secure processors, etc.). Additional Skills (Preferred): Familiarity with cloud platforms (AWS, Azure, GCP) for deploying NiFi. Knowledge of complementary tools like Kafka, Hadoop, or Spark. Proficiency in scripting (e.g., Python, Bash) for automation and data handling. Experience with data serialization formats like JSON, XML, Avro, or Parquet. Steps for Setting Up Apache NiFi for Managing and Distributing Data Feed: Here’s how a specialist would approach the task: 1. Planning and Design: Understand the data sources, volume, and frequency. Identify the destination systems and data distribution requirements. Design the data flow architecture, including: Ingestion process. Transformation logic. Distr...
formatoExcel={ 'A':{'encabezado':'Contacto', 'patron':[]}, 'B':{'encabezado':'Fecha', 'patron':[]}, 'C':{'encabezado':'Hora', 'patron':[]}, 'D':{'encabezado':'Mensaje', 'patron':[]}, 'E':{'encabezado':'Es renta', 'patron':['(rent(a|o)|for rent)']}, 'F':{'encabezado':'Es venta', 'patron':['(ven(ta|do)|for sale)']}, 'G':{'encabezado':'Es Demanda', 'patron':patronesDemanda}, ...
I need a freelancer to create a tailored open sales and quote report for me. This report should combine both sales and quote data, and be delivered in an Excel spreadsheet. Key elements to be included in the report: - Customer details (name and state) - Product details - Pricing and totals - Expected order date - sales person estimate chance of closing quote An ideal candidate for this project would be someone with strong skills in data analysis and Excel, as well as experience in sales and quote reporting. Please create a custom layout that is easy to navigate. Please use a tabular format for the layout. Include options to filter by date. Exclude visual elements like charts and graphs. The report should be grouped by chronological order.
I'm looking for an Excel template that can comprehensively record and track class-wise fees. The template needs to encapsulate the following aspects: - Fee Receival Details: The template should allow me to log the date and mode of payment (cash or online), the amount and balance, as well as class and student information for each fee received. - Expense Tracking: It should also track our expenses, including supplies and materials, salaries and wages, as well as maintenance and utilities. - Pending Fees: The template needs to show pending fees month-wise and class-wise. - Master Sheet: The master sheet should provide an overall report, class-wise dues, and breakdowns for total dues and total paid, as well as payments made via cash and online. Ideal skills for this project i...
I have OSTicket v1.18.1 hosted on hostgator shared environment and need an expert to perform the flowing tasks: - backup and test backup/restore before any changes are made - upgrade to latest version that will work on PHP version hostgator supports - provide detailed instructions with screenshots on how to access OSTicket Database and import/export data and provide template for import data - import data that we will provide in template - test to make sure all works as expected
I'm looking for a simple Google script that will: - Duplicate data from Sheet 1 to Sheet 2. - Compare the data and export unique text values to Tab 1 and Tab 3 in a table format. - Integrate with ChatGPT to rewrite existing titles and descriptions. The script will need to run daily. The ideal freelancer for this project should have strong experience with Google scripts and API integrations, particularly with ChatGPT.
...to admin module (sending report data / images files /sketch files) o Standard Integration (consuming Worksheet/Sketching fields) We may do all of this on setup - On and offline - Audit logging Admin Module cloud hosted - Quality control - Assignments - Productivity tracking by user - Host integration with CAMA systems / Third Parties - Export PDFs or just move the file manually Ideal Skills and Experi...
...empresarial. Experience with Microsoft Teams for communication is preferred. The assistant will use Microsoft Teams for communication. The assistant should have advanced skills with Microsoft Teams. An expert level of familiarity with accounting principles is expected. The assistant will generate a daily summary report from the verified payments. The assistant should be proficient in Microsoft Excel. An expert level of familiarity with accounting principles is expected....
I need a form that saves data from a form in a excel database
...will specifically appeal to potential investors. Ideal skills and experience for the job: - Proficiency in graphic design software (e.g., Adobe Illustrator, Photoshop). - Previous experience creating infographics, especially for investment purposes, would be highly beneficial. - Strong ability to translate complex data into visually appealing and easy-to-understand graphics. - Familiarity with Excel and the ability to work with data from this software. - Excellent understanding of minimalistic design principles. - Expertise in data visualization techniques to represent complex revenue data effectively. Please use our corporate colors for the infographic. The infographic should include charts to present the data. The final deliverable should be in PDF format and include an edita...
I'm seeking an Excel expert to update a commercial real estate model. The updates primarily involve financial projections, and the tweaking of formulas and calculations. Key Tasks: - Adjust financial projections to reflect new market conditions - Review and correct formulas and calculations as necessary - Ensure the model is compatible with a customized company template The most critical financial metric that needs to be accurately assessed in this model is the land acquisition and lending criteria. Ideal Skills: - Extensive experience with Excel, particularly in financial modeling - Understanding of commercial real estate metrics and valuations - Ability to work with and adapt to a specific company template - Strong attention to detail to ensure all calculations an...
Deliver 34 presets with their macros (Map 4-8 macros depending on source preset. - Create 4-8 macro variations in ableton rack.)
I need help analyzing a dataset in Excel. The project involves answering five simple questions using charts. You will need to provide the raw data file with all formulas, pivots, etc. Key tasks: - Use charts for data visualization - Focus on comparing different categories - Create a comprehensive and insightful analysis Ideal skills and experience: - Proficient in Excel with strong data analysis skills - Able to create clear and informative charts - Good understanding of category comparisons in data
...experienced freelancer who has a wealth of knowledge with PDF documents and office softwares such as Word and Excel. Here's what I need from you: Task 1 - Our current proposals we send out to clients were created in Indesign however they do not work with our CRM system, so therefore we need to create these same designs in word which will work with our CRM system. Converting the PDF documents into a word document could be one easy fix, or redesigning the original design into Word would be another option. I will leave that to your expertise. Task 2 - We currently send out a form which was created in Word to our clients to fill and send it back. We need to redesign this form in Excel, we need it to look luxury and high quality (similar to proposal documents) The fo...
...second. The expected cash flows during operation are 30,000 PLN in the first year and 40,000 PLN in the second, followed by a sale of the factory for 1.2 million PLN at the end of the second year. Your deliverable will be a detailed IRR calculation in an Excel spreadsheet, as well as a report justifying the investment based on your analysis. You will need to consider the appropriate discount rate, with WACC at 12% and CAPM at 14%. Ideal candidates will have: - Strong background in finance and investment analysis - Proficiency in Excel for complex calculations - Ability to present findings in a clear, concise manner. Zadanie nr 5 - IRR Inwestor zamierza wybudować fabrykę. Wyda na ten cel 1 mln zł, przy czym tylko 30% środków będzie pochodziło z kapitału wł...
I'm looking for an Excel wizard who can create an efficient drop-down menu tool for me. This tool will be used for data selection, with over 50 options in the drop-down menu. The project involves: - Designing a user-friendly drop-down menu with more than 50 options for data selection. - Implementing a reset button that restores default selections when clicked. Ideal skills for this project include advanced Excel knowledge, particularly in creating drop-down menus and implementing macro buttons. Experience in creating user-friendly Excel tools is a plus. The drop-down menu should include additional features to enhance functionality.
...textile weaving sector to develop a comprehensive Excel sheet for production planning and lead time management. Key Requirements: - Expertise in resource allocation, inventory management, and scheduling within the textile industry - Ability to create an Excel sheet that generates daily production reports, inventory status reports, and lead time analysis reports - Proficiency in incorporating automatic calculations, data visualization (charts/graphs), and customizable templates into the Excel sheet Your experience in the textile weaving field will be crucial in tailoring this Excel sheet to meet the specific needs of our production line. This project would ideally suit a freelancer who can combine their industry knowledge with advanced Excel skills to...
I need a skilled freelancer to create a PDF legal contract using our Excel template. The document should incorporate our branding elements, specifically the logo and color scheme. Excel doc proposed template PDF original template
Check the attached document for a better overview of the project info! We are seeking an experienced UiPath freelancer to develop workflows for extracting data from Excel, PDF, Word, and Email files, converting it into structured formats (e.g., JSON, CSV, XML). This project serves as the foundation for a broader workflow automation initiative. If successful, there will be opportunities for ongoing development work to expand and enhance the system. Provided Tools We will supply: UiPath Pro License: For workflow development. UiPath Document Understanding: For advanced OCR and document processing. Proposal Submission Guidelines Freelancers are invited to submit proposals incorporating an hourly rate for the project. Along with your hourly rate, please provide the following det...
Necesito un bot para automatizar el poner reseñas de Google Maps. Cogería los datos desde una lista de excel, el nombre de la empresa, el texto para la reseña y la valoración en estrellas.
I recommend having OCR Sk...recommend having OCR Skills as its a reasonable amount of data Convert 12 PDF bank statements into a single CSV file. The details to be included in the CSV are: Date, Description, and Amount. Spreadsheet and first statement of 12 attached. IMPORTANT 1. Electronic Deposits and Credits would go under the DEPOSITS column in Excel for the amount 2. Electronic Payments, Service Charges, Other withdrawals and Checks paid would go under WITHDRAWELS column in excel for the amount Ideal Skills: - Proficiency in OCR, data entry and PDF to CSV conversion - Attention to detail to ensure accurate data transcription - Experience with handling financial documents Please note, there is no need for categorization of transactions. All 12 statements are i...
Regular excel reporting project ( weekly basis payment). Details discussed via PMB.
improve xml feed extension for google merchant The module is already ready, it needs to make small improvements 1-When publishing the ad, the user chooses the language. 2- Mandatory Short Description and transform it into meta name="description" content= 3-The language and description chosen when registering the product must appear on the product page in the page code for search engines image 4- Generate the XML feed in any currency and language available on the site. The XML feeds are available to update or delete see image 1 5 Classifieds cannot appear in the XML feed, this is according to Google Merchant rules 6- The XML feed must contain the mandatory attributes gender, size, color, age, sex. when available in the product 7- option to di...
...specifically analyze geotechnical data. - The software will need to execute complex calculations with precision. - Support for importing data from various geotechnical testing equipment. - Provide real-time updates and visualization of the calculations as data is entered. - The software should have a user-friendly interface with intuitive navigation. - Enable users to export results in multiple formats, such as CSV, PDF, and Excel. - Integrate with relational databases to store and retrieve geotechnical data. This project is ideal for personnel with a strong background in software development with a keen interest in mathematics. Experience with data analysis is a plus. Please provide examples of similar projects you have completed in your proposal. The software...
...startup and need a comprehensive financial model in Excel for the next 5 years. The model should incorporate all the classic components typical of standard financial models, including charts for key metrics. Key aspects to include: - Revenue and expenses - Churn rate - Growth (sales, clients, turnover, profit) - Discounted cash flow - anything else typical being part of financial models for startups I will provide basic data for calculations. If anything is missing or unclear, you're expected to reach out and ask for additional input. The model should account for 3 revenue streams, which I'll detail. Ideal candidates should have: - Strong background in finance and financial modeling - Experience with SaaS businesses - Proficiency in Excel - Ability to communic...
As discussed, I'll do the conversion from PDF to Excel for the file you have shared.
...connection between Unity and Blender specifically for real-time rendering purposes. The app must be compatible with Windows and incorporate several key features to manage the connection between the two software. Key Features: - Live sync of changes: The app should allow for real-time updates, reflecting changes made in Blender within Unity instantly. - Automated import/export: A system that handles the import and export of 3D assets without manual intervention is essential. - Asset version control: The app should provide a mechanism to track and manage different versions of assets. Ideal candidates should have extensive experience with both Unity and Blender, as well as app development for Windows. A deep understanding of real-time rendering and asset management is cruc...
I have multiple project spreadsheets in Excel that get copied and pasted as new projects are established. Within each template, there's a spreadsheet that tracks change orders identified by project names. I need a single aggregator spreadsheet that continuously pulls data from all to hold the summary data. Key tasks: - Create an aggregator spreadsheet in Excel - Ensure it pulls data from all individual project spreadsheets - Track change orders based on project names Ideal skills and experience: - Advanced Microsoft Excel skills - Experience with Excel data aggregation - Familiarity with project management spreadsheets The frequency of updates to individual spreadsheets varies. Some may lay empty, while others may have two change orders a month. Therefor...
I'm looking for an Excel expert to create a macro that helps me update my Bill of Quantities (BOQ) using an old list of glass panels. The goal is to efficiently identify and compare reusable materials. Specific Tasks: - The macro should identify reusable glass panels. - It should compare entries from the old and new BOQ. - Finally, it should generate a report detailing usable materials. Report Structure: - The output report should be structured in an Excel spreadsheet. Data Format: - The old glass panels list is currently stored in an Excel spreadsheet. Ideal Skills: - Proficient in Excel macros and VBA. - Experienced in data comparison and reporting. - Able to deliver a well-structured Excel report.
I have a set of survey data that is in an Excel or CSV format, and I'm looking for a statistician or data analyst to help me summarize it. Ideal applicants for this project should have: - Proficiency in statistical analysis - Experience working with survey data - Ability to work with Excel and CSV files - Capable of providing clear, comprehensible summaries of data
We are looking for an experienced Excel developer to create custom dashboards for our Opportunity Tracker spreadsheet. This project involves transforming an existing data-heavy spreadsheet into an interactive and visually appealing dashboard to provide quick insights and metrics for our sales organization. Here is a video explaination: Project Overview: Our company tracks sales opportunities in a comprehensive Excel spreadsheet. While all data resides in a single tab, we need dashboards to quickly visualize and summarize key metrics such as total pipeline value, stage breakdowns, trends, forecasts, and campaign-specific data. Scope of Work: Dashboard Development: Create a dashboard to summarize and visualize key
I'm in need of a data analyst who can delve into various datasets including f...financial anomalies. - Recommend strategies for optimal stock level maintenance. Ideal Skills: - Proficiency in data analysis tools (e.g., Excel, Python, R). - Strong understanding of financial and operational metrics. - Experience in customer data interpretation. This project will require a keen eye for detail and the ability to identify trends, forecast potential outcomes, and detect any anomalies. Please submit your proposal if you have the relevant experience and can meet these requirements. Reports should be generated every daily to track progress and trends. Focus on data from the following timeframe: monthly. Final reports should be delivered in Excel format. Analysis should focus o...
I need a proficient ...include IT and Technology, E-commerce, Fintech, Digital Services, Shared Services and Outsourcing (SSO), and Energy Companies. The specific company details required are: - Contact Information - Company Address - Company Email - C-Suite Level Name - C-Suite Level Contact - C-Suite Level Email - Industry Category/Classification - Company Website URL The extracted data should be delivered in an Excel spreadsheet. Ideal skills and experience for this job include: - Proficient in web scraping - Familiarity with data extraction from the specified sectors - Able to deliver data in the specified format - Attention to detail - Good understanding of C-Suite level roles in companies. This will be a one-time web scraping project. The project should be completed with...
...technology assessment outcomes for less than 10 specific treatments. The data required is primarily effectiveness data. Skills and experience ideal for this job: - Proficient in data entry and spreadsheet manipulation - Familiarity with health technology assessments - Ability to source and verify effectiveness data - Attention to detail for accurate data entry The final spreadsheet should be in Excel format. The project should be completed within 1 week. "I will provide links to the HTA assessments." The data should be organized using a predefined template that I will provide. Please categorize the effectiveness data by treatment type. Only use the links provided for sourcing the HTA assessment data. "No additional analysis is required." The spreadsheet sho...
I have multiple sheets in a workbook. Each Sheet represents a week, and each week Includes different tenders for different projects. I need assistance in extracting the lowest bidder from each sheet and respective project. - The bid entries are numerical va...sheet and respective project. - The bid entries are numerical values located in the same column across all sheets. - I have attempted to use VLOOKUP and INDIRECT functions, but they only return the first value encountered. I'm looking for a more efficient solution that can incorporate the MIN function to find the lowest bid. - The ideal freelancer for this project should be highly proficient in Excel and familiar with its advanced functions. Given my tight schedule, I would appreciate a swift and effective solution t...
...script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task ...
...keywords with optimal landing pages. Perform a competitor analysis to benchmark against industry leaders. Execute an in-depth on-page analysis to identify improvement areas. 2. Technical SEO Optimization: Enhance the website’s source code for improved search engine visibility. Focus areas include: Internal and external linking strategies. Optimization of the file. Updating and refining the XML sitemap. Improving landing pages and other critical elements. 3. Strategic Keyword Research: Boost rankings for the following terms: Ankauf Räderpakete Ankauf Radpakete Ankauf Reifenpakete Ankauf Felgenpakete Ankauf Kompletträder Ankauf gebrauchte Räder Ankauf Reifen von Leasingrückläufen Ankauf Räder von Leasingrückläufen Ankauf DOT Reife...
...draw lines and utilize a library of standard, simple 2D objects. These objects will represent symbols like motors, valves, pumps, tanks, etc. Key Features: - Object Interaction: Users should be able to manually input data behind each object, with the data requirements varying depending on the object. - Object Duplication: The ability to copy objects and their attributes is essential. - Database Export: The app should facilitate exporting the input data into a database. - Data Manipulation: Users should be able to manipulate the database using different queries to extract data sets for various stakeholders. - Real-Time Collaboration: Enable multiple users to interact with the application simultaneously for collaborative edits and reviews. - Custom Object Creation: Enable users t...
I need an Excel expert who can assist me in creating complex formulas, particularly for financial calculations related to mortgages and loans. Your tasks will primarily involve: - Developing intricate Excel formulas to help analyze different financial scenarios concerning mortgages and loans. - Providing insights through the use of these formulas. - Developing amortization schedules for fixed-rate and adjustable-rate mortgages. - Formulating monthly and bi-weekly mortgage payment calculations. - Creating formulas for evaluating the benefits of mortgage refinancing. - Developing formulas to break down total loan repayment into principal and interest components. - Creating projections for the future value of investments related to mortgages. Ideal candidates for this project ...
I'm seeking a proficient Python developer and system administrator with substantial experience in FileMaker. Key Tasks: - Python: Primarily, I need assistance with file m...Python: Primarily, I need assistance with file manipulation and task automation. - FileMaker: I require expert database design for a custom FileMaker solution. Database Requirements: - I need a FileMaker database with robust data management features, particularly focused on data import/export capabilities. The ideal candidate should be well-versed in Python, with a deep understanding of system administration and FileMaker. Experience in designing intricate databases with controlled data access and import/export functionality is crucial. Strong communication skills are needed to discuss and clarify...
...our ERP system and update all entries based on an excel file. There are a total of 5 tasks we need to complete. The first task is to update the contacts for whom we don’t have an email address, prioritizing the Technical Director. Find email addresses for specific job positions: Technical Director, Procurement Director, Sales Director, Business Development Director, CEO. Provide the full name of the person (last name and first name). Find and include the LinkedIn profile of the person. The ideal candidate should be skilled in data entry, research and familiar with LinkedIn and other professional networking sites. Please note that the second step will be discussed after the first task is completed fully and correctly. In the first excel File there are 2078 contact...