Data migration excel using jobs
Looking for a skilled developer who can automate the process of extracting text content from RTF code and organizing it in a categorized structure in an excel spreadsheet. On github, I see someone has tried to some success. The file is located: To begin with I am interested in the English file Years Foundation to Year 10. English MRAC/2023/07/LA/ENG HTML RDF/XML JSON LD SPARQL You goal is to extract the hierarchy and structure as a usable document to teachers. Learning Area (English) --> Year Level --> Aspect of the Achievement Standard (A sentence) : it may then have General Capabilities
I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be share...
I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction
As an avant-garde organization, we are looking for seasoned server experts to replace our existing Apache server with Nginx, to access benefits like improved loading times, superior scalability, and robust security. Key requirements: - Expert knowledge of Apache and Nginx servers - Proven experience in server migration - Strong understanding of server security - Ability to work under a tight deadline, as we require immediate execution The primary focus is not just a simple server switch but also to maximise the potential benefits of Nginx over Apache. Therefore, the best fit would be someone who can drive this change efficiently and effectively. Due to the urgency of the project, we need this completed ASAP. Therefore, preference will be given to those who can start immediately....
Needing to migrate a serie of modules from v15 to v17
...developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essen...
...in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the ...
I am experiencing server performance issues with my four WordPress websites hosted on a VPS cloud-based server. I need an ex...server to a new destination server that's already been secured. Ideal Skills and Experience: - Experience with WordPress migrations - Knowledge of VPS cloud-based servers - Ability to resolve server performance issues Deliverables: - Migrate four existing WordPress websites to new destination server - Ensure no breakdown in site functionality during the migration - Improve overall performance of each website post-migration. Please note: I'll need verification that each site is fully operational on the new server. My maximun budget is $100 and I'm only interested in hiring the best and most professional web site designers. ...
I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.
We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!
Hello, I have a 3D model and Ansys heat transfer air flow simulations of a part. I need "topology optimization" to be applied to the part in order to have maximum heat transfer and smoothest flow. Topology optimization should be mathematically modeled by using a software such as Ansys (preferably) or MatLAB.
I'm seeking a Google Ad expert with high level of understanding and experience in conversion-centered campaigns. Key requirements include: - Proficient in creating and managing successful Google Ad campaigns aimed at boosting conversions, specifically lead generation. - Expertise in geographical targeting for lead acquisition is a must, as our campaign is focused on a location-specific audience. - Exceptional skills in analyzing campaign performance, tweaking strategies as per insights and reporting on improvements will be ideal. Your ultimate goal will be to significantly boost lead generation for a location-specific audience through our Google Ad campaign. Note: I will provide you with certain ad budget for a month and if you are able to significantly boost conversions, I will...
I'm looking to solve a classification problem with my tabular data using Python. Skills and Experience Needed: - Capability in Python programming is crucial, familiarity with libraries such as pandas, sklearn, and keras is necessary - You should be proficient in machine learning algorithms, specifically focusing on data classification - Experience in handling and manipulating tabular data for machine learning applications - Understanding of data cleaning, preprocessing and feature engineering Project Requirements: - Development of a Python-based data classification model - Utilizing machine learning techniques to process tabular data - Rigorous testing of the model's accuracy and improving it if required - Documenting the step...
I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look fo...
I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.
I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.
For days I have been trying to migrate a database (MSSQL to MySQL) using ODBC Datasource Administrator unfortunately this is not successful I get error 1822 "Missing index for constraint". I'm just doing it as an exercise, it's not a business project. I wanted to know if anyone here could help me with this. I also tried with AWS the problem is the same (constraints), it doesn't work.
...Sales, Invoicing, CRM, Inventory, Accounting, Purchase, POS (Point of Sale), Timesheets, Expenses, Time Off, Employees, Front Desk, Maintenance, Odoo WhatsApp Integration, Subscriptions, Contacts, Calendar, Field Service, Appointments, Repairs, Attendance, ToDo, Payroll. Customizations: Complete necessary customizations to ensure all applications are ready for immediate use. Data Migration: Assist with importing existing data, including past accounting invoices/expenses and product information. Process Automation: Automate sales and purchasing between the two companies, including profit sharing and order creation from POS or invoicing. Enable automatic processing of bills/invoices from vendors and suppliers via PDF scanning and email integration. Supplier Management...
I have an existing website based on a template using XHTML, PHP and CSS. The task is to migrate the existing site content, with a new domain name, onto an already purchased WordPress theme and make new links, upgrades and create some additional pages. A variety of WordPress plug-ins are required. Some are to replace existing functions, while others will add new features to the site. In addition, any End-of-Life MySQL and PHP is to be replaced for current versions and new data bases created. All web-pages should use the templates pre-installed in the WordPress theme, including the additional new web pages. The extra pages will enable site visitors to view up to 10 videos, each showcasing a single room or feature, which provide virtual tours of rooms and locations in the proper...
As a professional involved in the field of data analytics, I'm in need of an expert to develop advanced lab exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros an...
I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data...
...The animation should focus on: - Walking through the 3D file - Explain the concept by zooming in the point of interest and make the main characters colored (currently they are greyscale) - Designing and showcasing a hospital ward - Outputting the final product as a video The purpose of the video is for visualization, with a focus on showing the process of using an application, from a patient room, then nurse station, then migration to server room, then monitoring the process at monitoring and control room. The setting is compelling and we aim to create a narrative that highlights these areas accordingly. I have a script ready for a voice-over and would require the freelancer to incorporate it into the animation. Therefore, good understanding of timing and animation syn...
This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.
For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and r...
Need to upgrade my existing excel macro, very simple project
For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.
Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num
I am in need of a tech-savvy individual who possesses the skills and experience necessary to help me with my site migration. My website, originally built on WordPress, requires a move to AWS, specifically the Elastic Beanstalk service. Key duties include: - Assessing the current WordPress site - Generating an effective migration plan - Implementing the migration to Elastic Beanstalk without compromising site integrity - Testing and troubleshooting post-migration Ideal freelancers will illustrate: - Proficiency in WordPress and AWS Elastic Beanstalk - Previous experience with website migration - Strong problem-solving skills - An understanding of web standards and best practices I look forward to successful and smooth transition. Thank you.
As the owner of a large SQL Server database, I'm looking for the expertise to convert my SQL Server code to Redshift SQL. The database in questio...SQL Server database, I'm looking for the expertise to convert my SQL Server code to Redshift SQL. The database in question is greater than 10GB and primarily contains valuable customer data. The ideal freelancer for this project should: - Have a strong understanding of SQL and Redshift - Experience in data conversion of Stored procedures, views, functions etc., specifically from SQL Server to Redshift - Familiarity with transforming and restructuring customer data Your job will be to ensure the correct and efficient migration of all customer data without loss of any rows. Be prepared to handle th...
The function (I didn't write it): input: Path of a video file. [would be nice to also allow audio files] output: Array of the volume of all frames of the file. PHP Version 7.2.34 Edition Windows 10 Home Version 22H2 Installed on 11/7/2020 OS build 19045.4170 Experience Windows Feature Experience Pack 1000.19054.1000.0 Device name DESKTOP-TBNFM6D Processor Intel(R) Core(TM) i3-10100 CPU @ 3.60GHz 3.60 GHz Installed RAM 8.00 GB (7.85 GB usable) Device ID 0334C4DF-2DEE-401E-A453-E30F4EB12586 Product ID 00325-81840-60585-AAOEM System type 64-bit operating system, x64-based processor Pen and touch No pen or touch input is available for this display
For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.
...WPStaging (installed) and develop it on your working environment. I need a short documentation after completion, so that I know which elements I can edit how and where, possibly with screenshots. The site is now well set up for SEO and the theme should be too, e.g. all internal links as readable HTML links (Link-Text - no Javascript). If Google fonts are used, please integrate them locally for GDPR / data protection reasons. I also need breadcrumb, but you can also solve this via (is installed). I would like 2-3 suggestions for the design(s) with subsequent revisions. The background of the main content should be white, header and footer I could imagine in e.g. green or anthracite, but I am not fixed and look forward to your suggestions. The target group is
...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with...
I am seeking an experienced website designer with a strong background in e-commerce to create a website tailored for selling digital products and services. The website must provide a user-friendly experience for potential customers. Key features: * A fully efficient shopping cart system that aids smooth transactions. * An advanced product search function to help customers find specific digital products or services. * A system that supports customer reviews and ratings to promote transparency and trust. Given the nature of the products and services we're offering, the successful candidate should have an understanding of how to present digital products and services in a way that appeals to customers and enables efficient buying. Prior experience in creating e-commerce sites with th...
We're in need of a proficient programmer proficient with Blazor C#. Our project currently has few runtime error that needs a fix. Specifics about when and where this error occurs will be provided after we've started. There are only two pages that needs your fixing. 1. location page Show Message that data has been edited, saved or delete. When user clicks on specific item data to be loaded in textbox Search is not working Export data to excel with formatting 2. Login page Issue with adding new user (password not getting captured) Add roles and claims (department) When user click on user form the table it should Edit user details including email address Only admin user to have right to Add/edit this page. Other user can only view the details. Search i...
I'm seeking a skilled developer to transform my Figma design into an engaging React 18.0 landing page. This landing page should include an engaging header complete with my business's logo and a user-friendly navigation system. Key Tasks: - Developing a R...developer to transform my Figma design into an engaging React 18.0 landing page. This landing page should include an engaging header complete with my business's logo and a user-friendly navigation system. Key Tasks: - Developing a React 18.0 landing page based on provided Figma design - Implementing a Header with logo and navigation system Ideal Candidate: - Proficiency in React 18.0 - Experience in using Figma designs - Detail-oriented with a strong focus on user experience - Previous experience in developing la...
I urgently require an adept designer with proficiency in graphic design, logo creation, and branding. Mastery in Adobe Illustrator will be beneficial to the successful completion of the project. Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organizat...Responsibilities: * Examine and enhance the visual design of the existing PowerPoint presentation. * Improve content organization. * Incorporate engaging animation effects. * Execute graphic design tasks including logo design and branding. Candidates with keen attention to detail, a commitment to meeting tight deadlines, and a background in corporate or formal PowerPoint presentation design will excel in this role. Immediate ability to start on the project is a ...
I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.
I'm seeking a highly skilled freelancer to create a detailed 3D model for my new heater product. Key Requirements: - Proficiency in AutoCAD: This is the preferred software tool for creating the design. - Attention to detail: High level of detail should be incorporated into the project. - Accuracy: The model has to adhere to the dimensions 7.8cm X 7.8 cm X 2.4 cm. VERY IMPORTANT : I put you the design of a competitor, we need a look totally différent not to be associate to them. The product need to have screen and buttons like him and a camera for presence detector. Please note: The 3D design is for product visualizations rather than manufacturing or engineering analysis. As such, having experience in and knowledge of creating high-fidelity product renderings would be hi...
This job requires programming experience to create and design an app based on the attached PowerPoint where I have detailed each page of the app. The data needed for the app will be supplied in an Excel file. The bid is to create the app for both iPhone and Android. App programming and graphic design experience is mandatory for this project and will require more than a basic knowledge of app creation. The rough project should be completed in 1-2 months. Please review the PowerPoint as it has very detailed information and don't hesitate to ask any questions.
Description: We are seeking a skilled freelance iOS developer to precisely convert an already exported Unity Xcode project into an IPA file. The focus is solely on the conversion process; our team will handle the Super Signature signing and management. The key requirement is to receive an IPA file that is accurately built according to our specific needs. Responsibilities: Efficiently convert the provided Unity-exported Xcode project into an IPA file. Ensure the IPA package aligns with our exact requirements, including the correct settings, an embedded .mobileprovision for full access, and a consistent Bundle ID. Avoid re-signing the IPA with any other institution's certificates to prevent compatibility issues. Provide an accurately built IPA file as per the project updates and requi...
macro based excel project with auto copy data and paste in chrome through selinium
This role requires an experienced data analyst to lead a comprehensive study into the spending habits of migrants in the UK. Specifically, the study will: - Gather qualitative and quantitative data on where the majority of money is spent, and how often these transactions take place - Examine the factors that influence purchasing decisions among this demographic - Analyze and interpret the collected data in order to spot distinct patterns Ideal candidates will have a background in consumer behavior studies, strong analytical skills, and experience working with diverse populations. Knowledge of the UK market and migration patterns is a plus. This project aims to facilitate a converged understanding of migrant spending behaviors, for practical use in future busin...
WordPress Website using GeneratePress Blocks
I am seeking a professional with great experience in developing payment services with Django. The system functions as a simplified version of PayPal. Via a web interface, users can transfer money to other registered users (utilising their registered email address as their unique ...registered users, and oversee their own account (e.g., view recent transactions). Administrators, known as superusers, possess the capability to access all user accounts and transactions. Upon successful completion of the task, you will have demonstrated proficiency in: Crafting and executing user interfaces through Templates. Devising and executing business logic via Views. Formulating and executing data access through Models. Establishing and executing a secure multi-user system. Check the file for ...
Your report/dashboard should answer the following questions posed by the sales director of the client: 1. What is the total number of orders catered by the firm? There should be a date filter in the dashboard. 2. What is the revenue earned by the firm? 3. What is the total discounted value (base price - check out price) * number of orders? 4. What is the overall discount %? 5. What are the top 5 selling categories? 6. Does the operational area of the store influence number of orders? 7. Are emails & product features on the homepage an effective mode of promotion? 8. What will be the next 5 weeks forecasted weekly quantity sold for each center, city, and meal category (you may use a simple trend-based forecasting method)? You need to submit your PBIX file work as a zip.
I'm in need of a meticulous and adaptable professional who can handle text, images, and table materials. The content copied will be incorporated into different platforms, specifically, a website, documents and presentati...different platforms, specifically, a website, documents and presentations. The right candidate should: - Have strong attention to detail as preserving the original formatting of all content is essential. - Be adaptable, able to work with text, images and tables. - Be proficient with document creation and presentation software, with a strong understanding of web-based interfaces for ease of content migration. This assignment requires patience, precision, and an eye for detail, to ensure accurate reproduction of the original material. Let's simplify m...
I need a thorough data collection process to collect Ceramic & Porcelain Tiles Importers within Vietnam. This project requires: - Collection of contact information and company details. - The data needs to be organized in an Excel spreadsheet. - Include data for all importers, regardless of volume or frequency of importing. Ideal skills and experience for the job: - Strong data scraping and crawling capabilities. - Proven experience with swift and accurate data entry. - Proficiency in Excel.
