Excel data modelingproiecte

Found the Selected Data from One Excel file on the Other File. Both files are provided for reference.

I'm looking for a professional to create a detailed Excel project plan for an industrial hemp venture. This plan will primarily be used for a funding application, so it needs to be comprehensive and persuasive. Key Components: - A well-structured timeline with milestones to track progress and key deliverables. - A detailed budget breakdown to demonstrate resource allocation and financial planning. You will have creative freedom to suggest the best layout and design for the plan, as I do not have a specific template in mind. Ideal skills for this job include expertise in project management, financial planning, and proficiency in Excel. Prior experience with creating project plans for funding applications would be an advantage.

I am looking for someone to put together my 2022 & 2023 PNL & BS for both of my businesses properly assuring all transactions are classifie...end of this week or at the latest by Monday 12/16/24. Also, I do not use QuickBooks, I would be exporting all statements and providing them manually for you to go through all the transactions and itemize them correctly and put together the P&L and BS for each business. Please make sure that is something you are capable of? If so, when you create the PNL and BS for each business I will need the excel workbook pages with calculation being automated creating the P&L and BS unlocked/unprotect so I have access? So if later I want to make minor changes I can? Please let me know if so and when you can start and how long till you got ...

Hey I’m looking for someone who can take data from a cabinetry software called Mozaik and have it regenerate in excel in a format I prefer. This document in our industry is called a cutlist. Problem with Mozaik cutlist is that it’s a bit basic and poorly displayed. MUST HAVE KNOWLEDGE OF CABINETRY CONSTRUCTION KNOWLEDGE OF MOZAIK IS A BONUS.

I'm in need of a seasoned designer with a keen sense for minimalist and modern aesthetics. The project involves creating a series of unique jewelry designs, primarily using mixed metals. Ideal Skills: - Proficient in jewelry design - Strong understanding of minimalist and modern styles - Experience working with mixed metals - Creative and innovative thinking - Proficient in 3D modeling software for jewelry design I´ve already made a couple of drawings, but I need help to continue and perfection it. Please include a portfolio of your previous work, particularly designs in the mentioned styles and materials. The project involves designing bracelets, rings and necklaces. These designs are intended for commercial sale. Focus on designs using gold and silver mixed metal...

I need a talented CAD designer with expertise in 3D modeling, particularly in designing mechanical parts. The main focus will be on creating precise, detailed models suitable for engineering purposes. Ideal Skills: - Proficiency in CAD software for 3D modeling - Experience in mechanical part design - Attention to detail and precision - Ability to understand and implement engineering specifications - Familiarity with different materials and their properties The designs will be used for supporting specific mechanical functions based on the pattern law. agricultural industry

...developer who can create a data analysis tool for my motor and inverter rig. The primary objective of this tool is to analyze historical data, specifically sensor data. Key Requirements: - The tool should be able to support various data formats including CSV, mdf, and mf4. - Expertise in Python is a must, and experience in creating similar data analysis tools will be an added advantage. - Include robust data visualization features such as graphs, charts, and heatmaps. - The tool should include data cleaning functions to handle missing, duplicate, or corrupt data entries. Please share your previous work related to data analysis tools, especially if you've worked with motor and inverter rig data. The tool should...

ONLY ARCHITECTS NEEDED I'm in need of a professional animator to bring a 1-minute animation to life for an open majlis. The modeling and materials have been already modeled in 3ds Max, and now only the animation is required. project timeline:1 Week Start your proposal with Dear L. Key Project Requirements: - The animation needs to adopt a realistic style, so a keen eye for detail and a strong understanding of real-world physics and movement is crucial. - The animation should incorporate multiple camera angles, not just a single viewpoint. This will add depth and interest to the piece. - A natural lighting setup is preferred for the animation. This means replicating the soft, diffused light of the outdoors, rather than the harsher, more controlled light of a studio. Ideal ...

...integrating data from various spreadsheets into a cohesive dataset. The primary type of data is tabular, and the main goal of this project revolves around efficient data integration. Ideal Skills: - Proficiency in FME (Feature Manipulation Engine) - Extensive experience with tabular data - Competence in data integration - Familiarity with working with spreadsheets - Knowledge of ETL (Extract, Transform, Load) processes - Proficiency in scripting languages such as Python or R Experience: - Prior work with FME workflow automation - Proven track record of successful data integration projects - Experience in handling large sets of tabular data from spreadsheets. The final integrated dataset should be provided in CSV format. The workflow sh...

...expert in Smart Sheets and Excel to help with project management, focusing on sales data analysis. The ideal candidate will have experience with task assignment and tracking functionalities, as well as setting up automated reporting systems. Key Responsibilities: - Utilize Smart Sheets and Excel for effective project management. - Analyze sales data to inform project progress and strategies. - Set up systems for task assignment and tracking. - Implement automated reporting to streamline project updates. - Ensure seamless integration of Smart Sheets and Excel with CRM systems. - Create visually engaging dashboards for sales data visualization. - Develop custom reports based on specific project needs and metrics. Skills Required: - Proficiency ...

...and SketchUp - Familiarity with free software options for CAD integration - Knowledge of creating Digital Twins in VR - Proficiency in 3D modeling within SketchUp - Experience working with DWG files - Knowledge of effective plugins for enhancing CAD-SketchUp workflow. - Skills in automating the workflow from CAD to SketchUp and VR. - Awareness of free licensing options for recommended software. The primary purpose of this project is to effectively use CAD drawings within SketchUp to build a detailed and accurate digital representation of a physical object or system for VR. The ideal candidate will have a strong background in CAD, SketchUp, and VR modeling, and will be able to provide a comprehensive guide on free software options for this purpose. The Digital Twin should...

...and challenging gameplay that can keep this demographic invested. The game is intended to increase public awareness of corruption and introduce players to the techniques used by professional investigators in the field. - Platform: The game is intended for PC, so experience with PC game development is essential. - Graphics: The game should feature realistic graphics. Expertise in realistic 3D modeling and rendering is a must. Ideal Skills and Experience: - Extensive experience in 3D game development, particularly for PC. - Proficiency in creating realistic graphics. - Understanding of adult gaming trends and preferences. - Experience in developing complex narratives and gameplay. - Strong skills in storyboarding to assist in the creation of complex narratives. - Understanding o...

I'm looking for an Excel wizard to create a single-sheet, all-inclusive spreadsheet for tracking packing efficiency. The sheet should be able to calculate how many boxes are packed per hour based on inputted data. Key Features: - The spreadsheet will need to incorporate different box types and their worth. For example, "1.5 ctn worth 1 box" and "dishpack ctn worth 3 box". - It should be able to generate the total number of boxes packed per hour based on how many of each box type is packed. - Conditional Formatting will be used for clarity. The ideal freelancer for this project should have extensive experience with Excel, particularly with creating sophisticated formulas and using Conditional Formatting. A good understanding of logistics and...

I need help updating my weekly Profit and Loss statement. The process is quite nuanced, and I will need to communicate with you reg...Profit and Loss statement. The process is quite nuanced, and I will need to communicate with you regularly. The task involves gathering data from various sources. Data Sources: - Internal company databases - External financial portals - Spreadsheets from different departments Data Format: - Primarily in Excel spreadsheets Your Tasks: - Data entry and consolidation - Data analysis and interpretation Once you become proficient and knowledgeable about the process, it should take no more than 2 hours per week. However, I need assistance every week. Ideal candidates should be experienced with data analysis, hav...

I need a freelancer to assist with a small project focused on gathering and entering data from various research sites. The task primarily involves collecting textual information from these sites. Ideal Skills: - Excellent attention to detail - Proficiency in data entry - Familiarity with research websites The process will involve: - Simple text extraction from identified research projects across several different websites. Your role will be crucial in helping me compile this information accurately and efficiently. The estimated volume of data collection is medium (101-500 entries). Please enter the collected data into a spreadsheet format. Please enter the collected data into an Excel spreadsheet. The expected time frame for this project is ...

I need a Python program that will analyze my Excel data for me. The file has 10,000 rows and 40 columns. The program should: - Examine a specific range within column B and extract all numerical values from the text of each line. - Create a new Excel sheet where these numerical values are inserted into one or several columns adjacent to column B. - Retain all other columns from the original sheet in the new one. Additionally, all numerical values need to be converted to decimals before being inserted into the new sheet. The ideal freelancer for this project should have: - Expertise in Python programming, particularly with data analysis and Excel manipulation. - Experience in writing Python scripts for Excel. - Ability to convert numerical value...

...transcribe my handwritten notes into an Excel spreadsheet. This will involve using specific formulas within the spreadsheet. Ideal Skills and Experience: - Proficient in Excel, with a solid understanding of how to use formulas - Exceptional typing skills - Detail-oriented and capable of accurately transcribing handwritten notes - Previous experience with data entry - Ability to maintain confidentiality and handle sensitive information with discretion The typist should use SUM and AVERAGE formulas in the spreadsheet. The project involves less than 50 handwritten notes. The handwritten notes follow a specific structure. The handwritten notes do not require any specific formatting in the Excel spreadsheet. The project needs to be completed within one week. ...

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