Excel data modelingproiecte

...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 attached example) a...

I'm looking for a professional with expertise in mechanical drawing and proficiency in Revit to assist me with sheeting and sectioning in a drawing file. The specific section required is a cross-sectional view. Ideal Skills and Experience: - Proficiency in Revit - Experience with mechanical drawing -...professional with expertise in mechanical drawing and proficiency in Revit to assist me with sheeting and sectioning in a drawing file. The specific section required is a cross-sectional view. Ideal Skills and Experience: - Proficiency in Revit - Experience with mechanical drawing - Ability to create clear and accurate cross-sectional views - Attention to detail - Understanding of Building Information Modeling (BIM) standards and practices The cross-sectional view should be ...

I'm seeking a talented 3D artist to create high-quality modern-style renderings of a living room, kitchen, and bedroom in an apartment I'm planning to renovate. The primary purpose of these renderings is to present the property to potential buyers. Ideal Skills and Experience: - Str...renderings of a living room, kitchen, and bedroom in an apartment I'm planning to renovate. The primary purpose of these renderings is to present the property to potential buyers. Ideal Skills and Experience: - Strong portfolio of modern-style architectural visualizations - Experience in creating real estate renderings - Excellent understanding of design principles and aesthetics - Proficiency in 3D modeling and rendering software - Ability to deliver high-quality visual content suit...

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

...normal, roughness, metallic maps). • Optional: Rigging for animation. 3. References: Detailed descriptions and reference images for each character will be provided. Custom Stages/Environments: 1. Quantity: Five (5) unique stages. 2. Details: • Four Stages: Based on real-world locations derived from Google Earth imagery. Each stage should capture the essence of the location, with detailed modeling, texturing, and lighting. • One Stage: A jail scene, designed based on a provided reference image. It should include essential elements such as cells, bars, benches, and appropriate lighting for realism or stylized visuals. 3. Requirements: • Accurate and immersive designs that align with reference images. • Fully textured with PBR materials and realist...

...generate precise, detailed and optimized 3D models for presentations. 3. Knowledge of integrating realistic textures, materials and design elements. 4. Experience in creating technical documentation (plans, sections, elevations, construction details). 5. Flexibility to implement quick changes based on client feedback. 6. Availability for online meetings (time to be agreed). Project Details: • Scope: Modeling of an interior space with custom elements, technical design for execution and optimization of proposals. • Work Phases: 1. Initial Interview and Briefing: Explanation of the objectives and delivery of basic information (sketches, measurements, visual references). 2. First 3D Proposal: Initial development of the model for review and comments. 3. Review and Adjustmen...

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 am in need of a mechanical engineer who specializes in design and drafting with a strong proficiency in 3D CAD modeling. Key Requirements: - Design and drafting of 3D CAD models - The primary purpose of these models will be for manufacturing, so a strong understanding of manufacturing processes and requirements is crucial. - Proficiency in using CAD software for creating detailed and precise models Ideal Skills and Experience: - Extensive experience in mechanical engineering with a focus on design and drafting - Proven track record of creating 3D CAD models for manufacturing - Strong attention to detail and precision - Excellent communication skills for discussing design ideas and modifications

I'm looking for a detailed 3D model of the side pocket for a Hunter 350. The model needs to be comprehensive and include the texture and material. The side pocket should be represented as being made from fabric. Ideal Skills: - Proficiency in 3D modeling software - Experience in creating detailed design models - Understanding of fabric textures and materials - Proficiency in UV mapping for accurate texture placement Please include in your bid examples of similar projects you've completed.

I'm looking for a skilled AI developer to create a tool that will analyze text data and provide insights. The primary focus will be on data analysis with specific tasks including sentiment analysis, text summarization and topic modeling. Ideal skills and experience for the job: - Strong background in AI development - Experience with data analysis and insights - Proficiency in natural language processing - Familiarity with sentiment analysis, text summarization and topic modeling - Ability to create a tool that can make phone calls. - Proficiency in Python programming language. - Ability to integrate external APIs for data sources and output channels. Please reach out if you have the right skills and experience for this project. The tool sh...

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

...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 editable file version. Please ensure the infographic uses brand logo color themes. The...

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

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.

UVGI Modeling using Comsol UVGI Modeling using Comsol

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

As an advanced SAP user, I'm seeking a mentor to help me grasp the intricacies of conceptual models in HANA Studio, specifically within the realm of Data Modeling. The ideal freelancer for this project should have extensive experience with SAP and HANA Studio, with a particular focus on Data Modeling. They should possess the ability to convey complex concepts in a clear, understandable manner. Prior experience in teaching or mentoring in a similar field will be highly regarded. The ultimate goal is for me to fully comprehend and navigate conceptual models within HANA Studio.

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

I have a product model in GLTF/GLB format and am seeking an expert who can help me publish it online for recurring access via a URL link. This needs to be viewable through my phone camera using Web AR, without the use of any external apps or software. Ideal skills for this project include: - Proficiency in 3D modeling software - Experience with Web AR technologies - Knowledge of GLTF/GLB file formats - Skills in web development - Ability to create a user-friendly system for recurring access This project requires innovative thinking to find a solution that allows for URL link access without relying on existing apps or software. Please provide examples of similar projects you have worked on in your bid.

I'm seeking an expert in financial modeling to assist with business acquisition. The focus will be on cash flow projections and revenue forecasts. Ideal Skills: - Proficiency in financial modeling, including building a sources and uses plan - Experience in business acquisitions - Strong understanding of P&L, Balance sheet and cash flow modeling, as well as internal rate of return and MOIC outcomes analysis. Please provide your relevant experience and examples of similar projects in your bid. The preferred software for this project is Excel. The project should be completed within 1 to 3 months.

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

Regular excel reporting project ( weekly basis payment). Details discussed via PMB.

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

As discussed, I'll do the conversion from PDF to Excel for the file you have shared.

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

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

I need an expert in data analysis and predictive modeling. Key tasks include: - Applying logistic regression for predictive analytics. - Using Principal Component Analysis (PCA) for data reduction and interpretation. - Implementing decomposition methods for identifying trends and seasonality. - Conducting native forecasting to predict future data points. - Performing text analysis for extracting meaningful information. - Generating synthetic data to support analytics and modelling. Skills and experience ideal for this job include: - Strong expertise in statistical modeling and machine learning techniques. - Proficiency in using relevant software and programming languages (Python, R, etc). - Previous experience with PCA, logistic regression, and ...

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 financial, customer, and stock information. The goal is to assess growth and degrowth indicators, maintain stock levels, and evaluate stock value. Key Responsibilities: - Analyze financial data for balance assessments, billing values, and target vs achievement comparisons. - Examine customer data for potential trends. - Conduct stock analysis focusing on maintenance, turnover rates, and value evaluation. - Prepare detailed financial reports based on data analysis results. - Forecast financial and stock performance based on historical data. - Develop comprehensive reports summarizing identified customer trends. - Compare company performance metrics with market benchmarks. - ...

I need a proficient web scraper who can extract detailed company information from various sec...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 sho...

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

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

...who is able to automate the trading process for me. This 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 thereaft...

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

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

I'm in need of an Excel developer who can help me automate repetitive tasks using macros. Ideal Skills: - Proficient in Excel, especially in creating and implementing macros - Strong problem-solving skills - Attention to detail - Previous experience with Excel automation - Advanced knowledge of VBA programming - Experience in data analysis with Excel - Ability to create and manage user forms - Skills in creating charts and graphs for data visualization - Proficiency in implementing error handling in macros - Experience integrating Excel with other software - Skills in optimizing macro performance - Ability to create macros for batch processing tasks Please note, the specific repetitive tasks to be automated are yet to be determined, ...

I need a professional translator to help translate the user interface elements of my mobile app into Spanish, German, Italian, and Portuguese. The phrases needing translation are currently formatted in Excel/CSV files. Ideal candidates should have: - Proven experience in translating user interface elements for mobile applications - Native or near-native proficiency in the specified languages - Ability to maintain the intended meaning and tone of the original phrases - Familiarity with working in Excel/CSV files - Attention to detail to ensure every element is accurately translated.

I'm in need of a 3D model of Aragorn, specifically designed for 3D printing. The model will be in a medium level of detail and posed standing with his sword. Key Aspects: - Primary use of the model will be 3D printing - Model should be of medium detail - Pose is standing with sword Ideal skills for this job include: - Proficiency in 3D modeling software - 3D printing experience - Understanding of creating models for specific poses - Ability to balance detail with printability The final model should be provided in STL format. The model should be designed at a medium size, roughly 100-150mm in height. The model should resemble Aragorn as portrayed in the movies. The model should include a simple flat base for stability. Please consider that the level of post-processing requir...

...who is able to automate the trading process for me. This 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 thereaft...

Milestone 1: Collect Data running your web crawler Budget $100.00 Time limit: 3 days, daily update is required You will use Excel sheet provided by me. You must follow all the instruction in the requirement document in the link below. You are doing Milestone 1a and 1b only.

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

Understanding of Requirements and Proposed Procedure 1. Data Overview:The project involves analyzing Nifty 500 stock data grouped by industry. The provided Excel file contains historical stock prices and market capitalization data from 2005 to 2023. A second file provides notes on strategy and ranking methodologies. 2. Requirements Breakdown: • Ranking Stocks by Industries: Group stocks based on their industries and rank them using performance metrics such as returns or technical indicators over time (e.g., 20th–50th percentile). • Applying Filters: Implement filters like Supertrend and other technical indicators (e.g., RSI, ATR) to identify different portfolios based on stock performance. • Timeframe Analysis: Analyze stock perfo...