Excel data modeling jobs

I need a straightforward method to solve a mathematical problem involving two quadratics multiplied together to equal a constant. The solution should require minimal calculations and be presented in a logical series of steps in Excel, making it suitable for a PLC control to execute. I want to avoid using MS Solver, macros, or the complicated 70-step row solution for Quartic polynomials. Please see the general format of the equations I am dealing with: (ax^2 + bx + c) (dx^2 + ex + f) = 350 For example: EQN 1: EA = 0.00495G^2 – 0.441G + 47 EQN 2: MA = -0.00485G^2 + 0.9456G + 153.35 EQN 3: (M- MA) (E – EA) = 350 In this example, M=199 and E = 80 are known, and the goal is to solve for G. (EQN4) by substituting #1 and #2 into #3 (199 - (0.00495G^2 – 0....

...respective SKUs. Please advise if you can do this. You need to be skilled in woocommerce and applying GTIN, UPC barcodes, and work with me until all the errors for integration are gone :) Key Details: - I have all UPC barcodes ready for this task, so there's no need for barcode generation. - The barcodes are available in a CSV/Excel file. Ideal Skills and Experience: - Proficient in WordPress - Experience with product data integration - Familiarity with handling CSV/Excel files - Attention to detail to ensure accurate matching of barcodes to product SKUs. The barcodes should be displayed as images on the product pages. The barcode images should be displayed below the product description. Please ensure validation of barcodes during import to catch any err...

I'...separate settings, Dr Harleen Quinzel in her office and Harley Quinn descending into her lair. - Incorporate superhero elements in a subtle yet creative way. - The final product should be suitable for 3D printing. - Design a unique base for the statuette that complements the architectural and superhero elements. should look subterranean/industrial. Ideal Skills and Experience: - Proficient in 3D modeling software, preferably with experience in creating designs for 3D printing. - Strong understanding of modern, minimalist architectural styles. - Ability to creatively integrate unconventional elements, like superheroes, into a design. - Keen attention to detail to ensure the final product is high quality and print-ready. The finished statuette should be between 6 and 12 in...

I'm looking for a skilled professional to help me automate an Excel spreadsheet that tracks government legislative bills. Data Requirements: - The Excel spreadsheet should update automatically with data about the legislative bills from a specified website. - This includes the bill status, sponsor details, bill number, short title, committees of referral, and status date. Deliverables: - An Excel spreadsheet that is capable of updating automatically with the required data from the website for the upcoming State of Alaska 34th Legislature bills. A copy of the 33rd Legislature's bills has been included for reference. - The spreadsheet should be structured to clearly display the different pieces of information and specifically update only...

I'm seeking a skilled professional to create a budget presentation that effectively communicates our financial narrative to the Board of Direc...Directors. The presentation should be able to highlight key financial metrics such as our revenue growth and expense reductions. Ideal skills and experience for the job include: - Proficiency in creating compelling presentations - Strong understanding of financial metrics - Experience in presenting to high-level stakeholders - Ability to tell a story with data - Advanced abilities in Excel, including pivot tables and complex financial modeling. Please, include past work examples that align with this project. Thank you. Please use a graphical style to make the presentation visually engaging. The presentation should be ...

I need a talented 3D building designer to help visualize the renovation potential of a garage and empty ground floor space of a 3-story house and transform it ...reimagine the space. The final deliverables should include 3D renderings/images of the new apartment and a sample floor plan. Key aspects to consider include: - A modern design style - Highlighting the benefits of what a transformed space looks like This project is as much about showcasing the renovation potential as it is about design. The ideal candidate will have: - Extensive experience in 3D modeling and rendering - A strong understanding of modern design principles - Creativity and the ability to think outside the box - Previous experience designing unique residential properties or renovations would be an advantage ...

...as a negative inside. Bonus points for additional designs that have features that would make it easier to break apart the mold and release the cast object afterwards. Key Requirements: - Create a high-detail 'negative' mold from the provided 3D model. - Deliver the final 3D model in STL format, as this is my preferred choice for 3D printing. Ideal Skills and Experience: - Proficiency in 3D modeling software and experienced in creating 3D models suitable for 3D printing. - Previous experience in making molds for casting, particularly with resins. - High attention to detail to ensure the mold is created to a high level of precision. Model here: The object to be cast is medium-sized, ranging from 10-30cm

...for an experienced data researcher and web scraper to gather information on Australian businesses with ISO certifications, specifically ISO 9001, ISO 45001, and ISO 14001. The final deliverable will be a comprehensive spreadsheet containing potential sales leads. Key Requirements: - Collecting specific business demographics: number of employees, annual revenue, and industry sector. - Obtaining specific business details: contact name, email address, and phone number for each business. - Direct URLs to the specific business reference of ISO 9001, ISO 45001, and ISO 14001 and any certificates - Gather the official website URL for each business. - Specify certification details such as date of certification and certifying body. Ideal Skills: - Proficient in web scraping and data...

I'm looking for a freelancer for a one-off data entry and research project. (Please don't ask for ongoing monthly work. It's a one time event at present.) We will only hire you for one hour to start, to see what services you are capable of providing. Then it will be up to 20 hours maximum. We're organizing a social fitness event and I'm in need of an 'event plugger' to post my event everywhere. forums, groups etc. Also I need someone to sign me up to all the free event sites to post on and do the admin there (copy and paste , add event flyers and photo)  Tasks: Copy and paste everything is already written. The flyers are ready. Getting the Skiddle link out there Helping to sell tickets by sharing everywhere. Signing our email up to free e...

I'm in need of a professional who can build a database for tracking my hourly sales. The project involves: - Using an Excel file that contains data on my inventory of physical products - Creating a system that can generate reports based on this data Ideal candidates should have strong skills in database management and Excel, with a proven track record of creating systems for data analysis and report generation.

I need an Excel sheet created for my contact list, which should include columns for Name, Email, and Address. The ideal freelancer for this project is someone with: - Strong Excel skills - Excellent attention to detail - Experience in data management Please note, I am only considering bids from freelancers based in Belfast, UK. The Excel sheet does not require any specific formatting at this moment, but it should have extra space for future updates.

I'm looking for someone who can help me gather information on property owners at the Hacienda de Riquelme resort in Murcia, who are currently residing in the UK. The data will be used for a direct mail marketing campaign. The specific requirements are: - A total of 300 data entries - Each entry should contain the individual's Name, UK Address (full address including postcodes), Email address and Telephone Number Ideal skills for this job include: - Data mining - Market research - Proficient in data handling and Excel

I'm looking for someone to create an Excel sheet for my contact list. This should include: - Name - Email - Address The ideal freelancer would be someone with strong Excel skills, attention to detail, and experience in data management. Please note that I didn't require any additional columns or data fields at this moment, but it's always good to keep extra space for future updates.

I'm in need of a skilled web scraper who can extract data from I would also like the scraper so I can pull future data from the site. The data is highlighted in the data that I need extracted from the site (one column for each value). - Ideal Skills: - Expertise in web scraping tools/languages such as Python with Beautiful Soup or Scrapy, or similar. - Proficiency in data processing and Excel. - Attention to detail and ability to deliver accurate data. - Experience: - Prior experience in web scraping is preferred. - A portfolio demonstrating successful web scraping projects would be highly advantageous.

I'm looking for an Excel expert who can help me create a robust document for tracking open positions by location and region, including timeframes for when they were opened and closed. The document should be able to generate comprehensive reports on: - Time to hire - Open positions per venue - Positions filled per region The venues will be categorized by their specific names. Additionally, I would like the Excel document to incorporate visual elements such as charts, graphs, and conditional formatting, to help visualize the data. Ideal skills for this project include: - Advanced knowledge of Excel - Experience in creating complex tracking systems - Ability to incorporate visual elements effectively. Previous experience in HR or recruitment tracking w...

I'm looking for someone who can help me gather information on property owners at the Hacienda de Riquelme resort in Murcia, who are currently residing in the UK. The data will be used for a direct mail marketing campaign. The specific requirements are: - A total of 300 data entries - Each entry should contain the individual's Name, UK Address (full address including postcodes), Email address and Telephone Number Ideal skills for this job include: - Data mining - Market research - Proficient in data handling and Excel

I'm seeking a seasoned professional with extensive experience in creating PowerPoint business presentations, workflow charts (particularly using Mindjet MindManager), and developing SOP & SLA documents. This role also necessitates proficiency with MS Excel for data visualization and MS Word for tables and documentation. Key Responsibilities: - Develop compelling PowerPoint business presentations - Create detailed workflow charts using Mindjet MindManager - Create SOP & SLA documents - Design and interpret data charts in MS Excel - Draft comprehensive tables and documents in MS Word - Create PowerPoint presentations with occasional updates The selected freelancer must be prepared to provide a portfolio of relevant work examples that demonstrate th...

I need a professional organizational chart created for my company. The chart should be designed in Microsoft Visio and delivered in both digital and printable formats. Requirements: - The digital version must be compatible with Microsoft Visio - The printable version should be suitable for Word and Excel - Each position on the chart must include the name, title, and photo Ideal Skills: - Proficiency in Microsoft Visio - Experience in creating organizational charts - Strong attention to detail - Graphic design skills to ensure the chart is visually appealing The successful freelancer will have a keen understanding of organizational structures and will be able to translate our company hierarchy into a clear, concise, and professional chart.

I have 43 Excel workbooks that I need merged into a single workbook. This new workbook should have a separate tab for each of the original workbooks as well as one linear tab with all data. - The original workbooks are mostly the same in structure and columns, there may be some slight variations. - Not all columns from the original workbooks need to be included in the linear tab, just specific ones. Ideal skills for the job would include: - Proficiency in Excel - Experience with data manipulation and merging workbooks - Attention to detail to ensure the integrity of the data remains intact Please let me know if you have any questions or need further clarification on the project. Only the following columns should be included in the linear tab: all tab...

I'm seeking a skilled 3D artist to assist with the development of high-poly 3D models based o...into a real life sculpture. Key Requirements: - Creation of high-poly 3D models - Application of specific, realistic textures and materials - Ability to work from artist sketches and flexibility to make changes in color, textures and material - Optimization of models for rendering performance - Enhancing fine details to match artist sketches Ideal Skills and Experience: - Proficiency in 3D modeling software - Experience with creating models for digital animation - Strong understanding of realistic texturing based on real-world materials - Ability to represent materials such as metal and chrome accurately See example below: (note this is not the current piece but it would be ext...

I need help organizing my Excel email list. It contains the name, email address, and boat make. I want all boat makes in the same location organized in a single column. Ideal skills for this job include: - Proficiency in Excel - Data organization - Attention to detail

I need a comprehensive journal, balance sheet, and Profit and Loss (PnL) statement created in Excel for a very small firm. Key requirements: - The financial statements will include both cash and credit transactions. - The statements need to be updated on a monthly basis. - The journal entries should contain the date, amount, description, and account type. Ideal skills include: - Proficiency in Excel. - Experience with financial statement preparation. - Strong understanding of cash and credit transactions. - Attention to detail and accuracy in data handling.

I'm seeking assistance with data entry tasks. The project primarily involves inputting customer information from online databases into spreadsheets. Ideal Skills and Experience: - Proficient in Microsoft Excel or similar spreadsheet software - Experience with data entry and transcribing tasks - Familiarity with online databases - Attention to detail for accurate data input

Manejo de excel y power bi, para hacer paneles de control

I need a LabVIEW program that will work with a load cell equipped with extensometers. This program should be capable of acquiring and reading force data in both the x and y directions. Key Features: - Real-time data visualization: The program should send data to Excel for real-time graphing. The format in Excel should be a bar chart. - Raw data transmission: The LabVIEW program should send raw data to Excel without any pre-filtering or processing. Ideal Skills: - Extensive experience with LabVIEW programming - Proficiency in data handling and visualization in Excel - Understanding of load cells and extensometers

I am seeking an Excel expert to assist with a budget spreadsheet for a hypothetical family scenario. The primary purpose of the budget spreadsheet will be to track expenses, forecast a budget, and compare actual vs. budgeted amounts. Key Requirements: - Proficiency in Excel - Experience in creating budget spreadsheets - Ability to work with hypothetical financial scenarios - Strong analytical skills The case will involve a made-up family and will include various data points such as: - Income and expenses - Assets and liabilities - Current debts - Annual incomes before taxes - Monthly incomes before taxes - Total monthly income after taxes Your task will involve accurately inputting and calculating this data in the budget spreadsheet. The ideal candidate will ...

...scraping script. The script will scrape data from based on a postal code and language input. The results will be organized into an Excel workbook (XLSX) with two sheets: one for natural persons and one for legal entities. Requirements: - The script should scrape all available details from each page and its corresponding detail page. - The data should be saved in an Excel workbook with two sheets. One sheet for natural persons and one for legal entities. There is a link between the natural person and the legal entity. - The script should be able to handle an empty language parameter and should paginate through multiple pages until all data is collected. - The script should include robust error handling to manage missing data or failed page loa...

I'm looking for a professional to extract product information from an ecommerce site. The primary focus will be on product titles and descriptions. The final output should be in an Excel file. Ideal skills and experience for this job include: - Proficiency in data extraction techniques. - Strong attention to detail to ensure all product information is accurately captured. - Experience with ecommerce sites. - Proficient in Excel.

I have already created the digital curriculum for TK-2nd grade teachers and studen...improved. Now I need the analytical date. Include the following features: surveys for teachers to complete. Focus on gathering analytical data regarding behavioral changes. Conduct a manual analysis of the collected data. Teacher surveys will be conducted through an online form. Student feedback will be collected through online surveys. Focus on gathering data regarding changes in social interaction skills. Analyze data trends on a 6 months - a school year basis. Provide an analytical report in Excel spreadsheet format. Focus on specific behavioral changes like attention span, conflict resolution, and homework completion. I'd like the data collected ...

I'm seeking a virtual assistant primarily focused on editing basic Microsoft PowerPoint presentations. Key Responsibilities: - Editing presentations to enhance clarity and profe...assistant primarily focused on editing basic Microsoft PowerPoint presentations. Key Responsibilities: - Editing presentations to enhance clarity and professionalism - Optionally, if you have skills in editing pictures and creating Excel spreadsheets, these tasks may also be assigned - Ensuring consistent slide formatting and layout - Customizing presentation templates to fit the brand image - Proofreading the presentation content for grammar and spelling errors Ideal Skills: - Proficiency in Microsoft PowerPoint - Experience in editing presentations - Knowledge of Excel - Picture editing ...

I'm looking for a low-cost system that connects my WhatsApp to an Excel spreadsheet. The system should be compatible with my existing macros and Python scripts. Key Requirements: - The system should only send text based messages via WhatsApp. - The triggering of WhatsApp messages from Excel should occur at scheduled times. - Both my Excel VBA macros and Python scripts need to be compatible with this new system. Ideal Skills: - Proficiency in Python and Excel VBA - Experience in creating cost-effective automation systems - Familiarity with WhatsApp API or similar services This project is purely for personal use. Please ensure that the system is low-cost and easy to use.

I'm seeking a skilled Excel expert to create a customized spreadsheet for me. This spreadsheet should allow me to input data on the first page and automatically sort names alphabetically. Key Requirements: - The spreadsheet should have separate columns for hosts and guests. - Guests should remain with their associated host when sorted. - If a guest is entered without an associated host, they should still be included in the list but on their own row, sorted alphabetically. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in creating complex spreadsheets - Strong understanding of data sorting and organization - Ability to implement conditional data sorting.

I'm seeking a seasoned professional with extensive experience in creating PowerPoint business presentations, workflow charts (particularly using Mindjet MindManager), and developing SOP & SLA documents. This role also necessitates proficiency with MS Excel for data visualization and MS Word for tables and documentation. Key Responsibilities: - Develop compelling PowerPoint business presentations - Create detailed workflow charts using Mindjet MindManager - Create SOP & SLA documents - Design and interpret data charts in MS Excel - Draft comprehensive tables and documents in MS Word - Create PowerPoint presentations with occasional updates The selected freelancer must be prepared to provide a portfolio of relevant work examples that demonstrate th...

We are seeking a motivated and detail-oriented Microsoft-Excel based data analyst. The position will pay hourly. Key Responsibilities: Data Analysis: Conduct basic data analysis, segmenting data, and providing insights to support decision-making. Reporting & Presentations: Create and maintain detailed Excel reports, presenting key findings and recommendations clearly and concisely. Client Support: Assist in developing and refining client-facing PowerPoint materials to communicate processes, performance metrics, and improvement opportunities. (optional) Required Skills: Excel: Strong skills in data analysis and reporting; experience with functions, pivot tables, and charts is required. Analytics: Ability to analyze data, i...

Hi , i need someone to help me create a mail from an excel button and figure out some formulas in an excel report. Key Skills : 1. Familiar with outlook 2. In-depth understanding of Excel formulas and functions for complex calculations. 3. Advanced VBA Programming to write macros and automate repetitive tasks.

I'm looking for a freelancer to help me create a series of informational articles for personal, educational use. - The articles should cover a range of topics in education and be written in a clear, engaging style suitable for an educational cont...would be beneficial. - Ability to conduct thorough research and ensure content is accurate and up to date is essential. This is a unique project aimed at creating high-quality, informative content for personal learning. Looking forward to your proposals! The project is an expansion of 50 pages to 250 pages. Please ensure the articles cover the topic of Meta-analysis and Hierarchical Linear Modeling. Please use a standard academic format for the articles. The articles should be written in a formal academic style to maintain a pro...

...crawler to extract specific user profile data from LinkedIn. Key Requirements: - Extract user profiles from LinkedIn - Focus on specific pieces of data: Contact information, current Job position, current Company, Email address - Target profiles located in Switzerland, Germany, and Austria Banking, Insurance, Manufacture, Medical Devices and others Ideal Skills: - Proficient in web scraping and data extraction - Familiarity with LinkedIn's structure and data points - Ability to filter data based on geographic location - Experience with ethical and legal considerations of web scraping Please note that the data extraction should be limited to profiles from Switzerland, Germany, and Austria. Please provide the extracted data in E...

I'm seeking a creative and results-driven Digital Marketing Specialist to craft and execute a promotional campaign for our Udemy Planning & Scheduling Professional (PSP) Certificate Mockup Exams. This practice test is designed to prepare planning engineers for the PSP certification, ensuring they have the knowledge and skills to excel. Your role will involve: - Focusing primarily on social media and blogs/forums for the campaign - Collaborating with professional forums, blogs, and influencers in the project management and engineering fields - Creating compelling and informative articles and blog posts that showcase the benefits of our PSP mockup exams - Ultimately, driving the primary goal of this campaign which is to increase our exam sign-ups Ideal candidates should ...

We are seeking a talented and innovative TikTok content creator to produce an engaging, Black Friday-themed video for our hustle clothing brand. The primary objective is to drive sales, so it is essential that you excel in crafting compelling content that effectively converts viewers into customers. The envisioned concept is a fashion haul and try-on video that highlights our products in an entertaining and relatable manner, reflecting the popular style of TikTok fashion content. The video should creatively emphasize exclusive discounts, presenting them in a way that is both appealing and irresistible to our audience. Key Requirements: -Proven expertise in creating TikTok content, particularly in the fashion and lifestyle niche. -Strong knowledge of TikTok trends and the ability to ...

I'm seeking a professional data scraper to extract and organize information from an e-commerce site into an Excel spreadsheet. The task involves collecting product details and prices, customer reviews and ratings, as well as stock availability. Key responsibilities: - Extract specific data points from an e-commerce site - Organise this data into a clean and structured Excel spreadsheet - Present the data in a professional manner Ideal skills: - Extensive experience with web scraping - Proficient in Excel - Attention to detail - Ability to present data in a clear and professional way

...approximately 2,000 financial transactions that I need to have extracted and organized from 47 screenshots (in JPG/PNG format) and two Excel files into a single, consolidated Excel file. The finished Excel file should have 5 columns: - Bank - Date - Transaction Details - Amount (in dollars) - Category It is imperative that these transactions are accurately classified into income and expense categories, using the sample Excel template I will provide. Any discrepancies in the data must be flagged for review. You will be provided with last year's sample file to show you how to categorise the transactions. Please note: - Transactions from the two Excel files should be marked as "Trust" or "Sole Trader" in the Bank co...

I need an experienced SolidWorks professional to convert surface geometry files (STP/STEP format) into individual solid...correctly, and create a complete assembly model. - Final Validation: Ensure the assembly is accurate, with no misalignments or errors. - Detailed Documentation: Provide detailed documentation of the conversion process, including any issues encountered and solutions implemented. Ideal candidates for this project should have: - Proficiency in SolidWorks with a strong understanding of surface and solid modeling. - Experience with STEP file conversion. - Ability to identify and rectify issues in surface geometry files. - Prior experience in creating models suitable for simulation. Ensure the final assembly is suitable for structural analysis simulations and for man...

Proficiency in Archicad with expertise in converting point cloud data into accurate 3D models. Extensive experience in architectural and structural modeling for commercial buildings using Archicad. Expertise in advanced modeling techniques for complex geometries and intricate structural elements. Strong ability to teach and effectively demonstrate advanced concepts specific to Archicad. Familiarity with workflows for integrating scan data into Archicad projects. Ability to provide live, online training sessions via video conferencing. Training tailored to enhance skills in using Archicad for precise 3D modeling from scan data.

I need a detailed mechanical Revit model focusing on process tanks and eq...tanks - Depicting detailed piping systems interconnected with process tanks The ideal freelancer for this project should have extensive experience with Revit and mechanical modeling, as well as a solid understanding of process tanks and their associated machinery. A background in mechanical engineering or a related field would be highly beneficial. Please include in your bid examples of similar projects you've completed. The model should achieve Level of Detail (LOD) 300. Annotations and labels should be standard with clear and essential information. The model should follow industry standards for mechanical Revit modeling. The model should adhere to the following standard/code: API. The projec...

...football jersey. Animation Requirements: The jersey should rotate smoothly on its axis. Logos will seamlessly integrate onto the jersey during the animation (e.g., fade-in, dynamic transitions). Video Length: 15 seconds. Style: Modern, high-quality, and realistic visuals. Deliverables: High-resolution 15-second video. Source files if needed (format to be discussed). Required Skills: Expertise in 3D modeling and animation software (Blender, Cinema 4D, Maya, etc.). Experience in creating realistic textures, lighting, and animations. Ability to incorporate graphical elements (logos) into 3D designs dynamically. Additional Info: Jersey base design and logos will be provided. We welcome creative suggestions to enhance the animation's visual impact. ? If interested, please send us...

I need a talented 3D artist to create an interior-focused model for architectural visualization. The model should encompass key interior elements, specifically lighting and textures. Ideal Skills: - Proficiency in 3D modeling software (e.g., Blender, Sketchup, AutoCAD) - Experience in architectural visualization - Strong understanding of lighting and texturing techniques - Attention to detail The interior model should reflect a classic style.

Modeling the interior and exterior of a VR device. Specify the budget required for this job . For this, it needs to be 3D modeled and the desired values ​​must be appropriate.

I need a seasoned building energy modeler who is well-versed with the Australian building code NCC 2022 Volume 1 J1V3 verification method. The task involves modeling energy consumption for a 14-storey student accommodation building. Key Requirements: - Model energy consumption in two scenarios: the NCC reference building and the proposed building. - The simulation must demonstrate compliance with the NCC criteria for maximum yearly greenhouse gas emissions. - Utilize DesignBuilder for the simulation. - Model all relevant factors: heating, cooling, lighting, ventilation fans, interior equipment, pumps, etc. - Architectural and mechanical building drawings as well as a Revit 3D model will be provided. Strict deadlines apply: the project must be completed within a maximum of 5 days,...

I'm seeking a freelancer who can assist in locating the email addresses and phone numbers of key individuals in a list of companies I have. Number of Companies: 1000 Key members to focus on: - CEO/Founder - Head of Sales - Business Development The contact information should be delivered in a Spreadsheet (Excel/CSV). Please ensure: - Accuracy of the contact details - Timely delivery of the project Ideal candidates for this project should have previous experience in data mining and lead generation, with a strong attention to detail. Also, having access to paid tools is an advantage. In case you have access to any tools, name it.

I'm seeking a proficient Excel expert to create a comprehensive school fee management system for me. The system should include functionalities for fee calculation and tracking, generating fee receipts, and sending payment reminders. Key functionalities: - Fee Calculation & Tracking: The system should automatically calculate fees and track payments. - Generating Fee Receipts: It should be able to generate receipts for the fees paid. - Payment Reminders: The system should have an alert system for payment reminders. - Discount Management: Include functionality to apply discounts or scholarships to student fees as needed. - Payment History: Track the complete payment history of each student for easy reference. The system will not need to handle multiple currencies or differe...