Excel vba query data model jobs

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

Hi Taras, can you remodel some parts and give them to me in both step and stl formats, there are 3x parts total. I have a base model you can work from but need to scale it up to match the new sizes.

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate tran...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...

I need an expert to design an effective Business plan offering memorandum for my real estate business. The document will be targeted towards investors and aim to provide a clear understanding of our business model and financial health. Key Requirements - Business plan -Vacation rental industry not a must - Proven experience in drafting offering memorandums and business plans, preferably within the real estate sector. - Strong understanding of financial data presentation, particularly income statements, cash flow statements, and balance sheets. - Ability to design a document that is engaging and convincing to potential investors. The perfect candidate will demonstrate impeccable attention to detail, a solid understanding of the real estate and investment sector, and exp...

I'm looking for a skilled Python developer with experience in Blender and Rhino to create a demo of Python integration with both softwares for the purpose of creating a low poly 3D car model. Key requirements: - Proficient in Python - Experience with Blender and Rhino - Understanding of 3D modeling principles - Ability to create low poly 3D models The main goal of this project is to demonstrate the feasibility of creating a low poly 3D car model using Python in both Blender and Rhino for visualization purposes. The model needs to be detailed enough to be recognizable as a car, but does not require high levels of realism or complexity. If you have a strong command of Python, experience with Blender and Rhino, and a solid understanding of 3D modeling, please app...

The purpose of my project is to create an 'about us' video that highlights the services my academic service unit offers, specifically in the domain of mouse model utilization. The video will majorly showcase the phenotypic analysis services and the various studies we conduct using animal models for research. The content must be tailored in a way that caters to our target audience which includes researchers, academic institutions, and government officials. This would involve presenting complex information in a format that is easily understandable by both scientific and non-scientific audiences. Skills required: - Expertise in video creation and editing - Understanding of scientific research, specifically dealing with mouse models - Ability to communicate complex concept...

I'm looking for an expert in Blender to help me bring my electronic device to life with realistic rendering. This will involve: - Developing a 3D model of the product - Applying textures to the model - Creating 4-6 different color variations of the product - Setting up a studio environment for the render - Providing me with the Blender file and a set of high-quality rendered images for the product Ideal skills for this job include: - Proficiency in Blender - Experience in 3D modeling and rendering, especially electronic devices - Ability to create textures and apply them realistically - Knowledge of studio lighting in Blender - Strong attention to detail to ensure the final images are photorealistic and showcase the product's different colors effectively If you h...

I'm looking for a proficient expert to assist in implementing deep learning with Nvidia and federated learning. This project involves: - Implementing federated learning techniques to enhance model accuracy using NVIDIA - Managing a medium-sized dataset for the training process. Ideal candidates should have experience in implementing deep learning models, particularly with Nvidia hardware. Experience with federated learning and handling medium-sized datasets would be a significant advantage.

...content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not only collates data bu...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...professional who can create a comprehensive and realistic financial model that incorporates various elements such as revenue streams, costs, and growth potential. - Design Go-to-Market Strategy: This will involve formulating a detailed plan on how we can enter and penetrate the US and Mexican markets, highlighting key milestones and tactics. Requirements: - Expertise in Financial Modeling: Demonstrated experience in developing financial projections, especially for technology companies targeting international markets. - Proven Track Record: We are looking for someone who has a strong background in creating successful go-to-market strategies for companies in similar industries. - Market Research Skills: While we have existing data on our target markets, the ability to condu...

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of ...

I am looking to hire a 3D modelling expert who is proficient in using Z Brush for creating highly detailed models of Hindu gods - specifically Shiva, Vishnu, Ganesh and all other god figures. These models are intended for casting physical idols. You should have: - Extensive experience in 3D model creation with particular expertise in Z Brush - Experience in designing models for physical casting - Understanding of Hindu mythology and iconography to accurately represent the deities - An eye for intricate details to ensure the models reflect the complex symbolism of Hindu deities The end product should be a set of 3D models that are ready for casting, with each detail carefully considered and accurately portrayed. The models should not only be precise, but also artistically appea...

I need an iOS app developed with social media integration, push notifications, and in-app purchase functionality. This is a high priority project, and I need it completed as soon as possible. I would like to model it somewhat after this application or similar noise applications - Key Features: - Social Media Integration: The app should allow users to share content on various social media platforms. - Push Notifications: The app should be able to send push notifications to users to keep them engaged. - In-App Purchase Functionality: There should be options for users to make purchases within the app. Design Preferences: - Bold and Colorful Design: I prefer a design that is vibrant and stands out. - Custom Branding Elements: The app should incorporate specific branding

...heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high availability and reliability of the database - Providing recommendations f...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report...

I’m seeking a talented and experienced photographer for a shoot involving several pieces of jewelry, consisting of rings and bracelets. The shoot will be conducted in a styled indoor setup, aiming to create a captivating atmosphere that reflects the elegance of our fine pieces. the jewelery will be on a model Key Details: * Quantity of Items: Less than 10 * Jewelry Type: Rings & Bracelets * Setting: Styled Indoor Setup Ideal candidate: * Proven experience in jewelry photography * Skills to manipulate lightings and reflections to make jewelry pieces stand out * Creative eye for indoor styling * Capability to deliver high-resolution images suitable for print and digital media. Applying freelancers, please provide a portfolio displaying relevant experience, particular...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your ex...

I am looking for a skilled Angular developer to help me with an upcoming project. Your main tasks will be focused on the front-end, data modeling, and business logic development, with a timeframe of less than a month. Key Responsibilities: - Building user interfaces: You should be able to create clean, responsive, and intuitive user interfaces using Angular. - Developing data models: You will be responsible for designing and implementing data models that can efficiently handle and manage the project's data. - Implementing business logic: You must be able to translate business requirements into technical solutions, creating the necessary functions and processes within the Angular framework. Ideal Candidate: - Proficient in Angular: You should have a stron...

I am looking for help creating a basic SketchUp 'massing model' of an existing 2,000 sf house (exterior only; no interior walls needed). Photos & field measurements are provided, along with *mostly* accurate original blueprints. Thank you for your interest!

Develop a chatbot with a web chat interface using the Llama 2 7bn LLM model to assist users in resetting their passwords. The chatbot will interact with users to collect verification details (employee number, name, date of birth, boss's name, and last four digits of cell number) through a structured conversation. The system will validate user inputs against an API and terminate the conversation after three invalid attempts. Upon successful verification, a text message with the new password will be sent via an external API. The project will include creating APIs for future speech input/output integration, ensure response times under 1.5 seconds, handle multiple simultaneous users with unique identifiers, and provide customizable response messages. The system will be deployed on ...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of t...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...

Please Sign Up or Login to see details.

I need a skilled 3D artist to create a realistic tree model in PSD format for architectural visualization. - Design a custom tree based on the characteristics of an orange tree - The 3D model should be colored green - The primary purpose of this model is for architectural visualization, so it should be realistic and detailed Ideal Skills: - Proficiency in 3D modeling software - Experience in creating realistic 3D models of nature elements - Strong understanding of color and texture in 3D design - Previous experience in creating assets for architectural visualization would be a plus.

I need a 3D model of drive thru restaurant

...at an upcoming event. Key Requirements: - Incorporating the company logo prominently. - Showcasing high-quality images of our products (which will be provided). - Including compelling promotional text to attract potential customers. Theme to be Gold and Black Preferably Banner Dimensions: 33 inches x 80 inches. 1st Banner Design Mehroz Designer Jewellery Logo an Image from Swarovski model Official Seller and Authorised Distribution Partner BIG Swarovski Logo at bottom website: Instagram Handle: mehrozdesignerjewellery 2nd Banner: NEO Restaurant Logo Now Home of Mehroz Designer Jewellery Logo Discover Mehroz Designer Jewellery: Innovative Silver Creations with Precious Gemstones, Swarovski Crystals, and Lab-Grown Diamonds. Custom Gold Jewellery in 21

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. The o...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I currently possess a vector DXF file that was created using AutoCAD and I am in need of a freelancer who can convert this into an STL file. This file will ultimately be used for 3D printing. I'm looking for a medium level of detail in the final 3D model. Skills and Experience: - Proficiency in AutoCAD - Expertise in conversion from DXF to STL - Understanding of 3D model detailing for 3D printing. Please share some samples of your past work in this area in order to increase the chances of winning the project.

...skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and custom...

I'm looking for an experienced ML expert who can help me set up a model for audio analysis. This project is aimed at audio processing, with the goal of predictive analysis, pattern recognition, and potentially fraud detection. Key requirements: - Proficiency in Machine Learning: You should have a strong background in machine learning, particularly in audio analysis. - Experience in Predictive Analysis and Pattern Recognition: The ideal candidate will have experience in both predictive analysis and pattern recognition. - Familiarity with Fraud Detection: While not a must, familiarity with fraud detection would be an advantage for this project. The project duration is estimated to be between 1-3 hours. Please submit your proposal and relevant past experience.

I'm in need of an experienced BIM 3D modeler, proficient in Revit software to assist with my project in India. The model will require comprehensive detailing including MEP elements (Mechanical, Electrical, Plumbing). Key Responsibilities: - Develop a detailed BIM model with a focus on MEP elements - Ensure the model is suitable for visualization and presentation purposes - Collaborate with me to ensure the model meets the required standards Ideal Skills: - Proficiency in Revit - Extensive experience with detailed BIM modeling, particularly in an MEP context - Strong communication and collaborative skills (Tamil) The project is primarily aimed at visualization and presentation, so you'll need to ensure your work is both technically accurate and visu...

...papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on th...

...specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I�...

I'm in need of a mechanism design expert who can assist me in creating a small mechanism. The purpose of this mechanism is to move objects, and it will be operated manually. Key Responsibilities: - Detailed force analysis: An important aspect of this project is a comprehensive force analysis to ensure the mechanism functions as intended. Hand calculations to be included. - CAD Model: The CAD model should be of intermediate complexity with multiple components and moderate detailing. - Concept Sketches: Creating detailed concept sketches which will guide the design process. - Materials & BOM: Selection of materials suitable for the mechanism and creating a Bill of Materials. - FEA: Performing Finite Element Analysis to evaluate the performance and structural integrity...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of income tax laws and ...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm looking for an experienced developer to create an AI customer service chatbot for my business. You will be using OpenAi api. You will need to extract all email from our gmail account to train the model. The model should be able to create response to customer queries using the training data. This will be a chrome extensions. The primary functionality I need is for it to be able to effectively respond to frequently asked questions (FAQs). Key Project Details: - Platform: The chatbot should be developed specifically for my business - Functionality: The primary function of the chatbot should be to accurately answer customer's FAQs. - Language Support: I am not sure if multiple languages will be required at this stage, but the ability to add this in th...

I have a detailed, digital drawing of a couple of processes and I need a professional to convert it into a 1-page flow chart using Microsoft Visio. This task should take less than an hour for an experienced individual. Requirements: - Convert a digital, highly detailed process drawing (attached) into a 1-page flow chart - Expertise in Microsoft Visio - Any flow chart model you can use that is editable in case of changes. The ideal candidate should be able to quickly understand the processes from the drawing and translate them into a clear, concise and visually appealing flow chart. Experience with similar tasks and a quick turnaround are both highly desirable.

I'm seeking a vintage-style logo for our civil engineering firm, Anglin Civil. The logo should primarily incorporate the company initials. Key Requirements: - Vintage style: I'm looking for a classic, timeless logo design that reflects the company's heritage in civil engineering. If you have something more model and simple I am okay to looking at that as well. - Colors: The logo should predominantly feature red, white, black, and grey. - Company initials: The logo should creatively integrate the initials of our company, 'Anglin Civil'. Ideal Skills and Experience: - Proven experience in creating vintage-style logos. - Strong understanding of color theory to effectively blend red, white, black, and grey in the design. - Proficiency in incorporating company ...

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand profess...virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through ...

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I'm in need of a professional who can cr...professional who can create a 3D human avatar for use in a holographic greeting message. - Avatar Type: The avatar should be human in appearance. - Emotion/Tone: It should convey a welcoming tone, making the viewer feel at ease. - Specific Action: The avatar will need to perform a 'restaurant greeting' action during the message. This project will involve creating a high-quality, visually appealing 3D model that can be used effectively in a holographic display. Experience in character design and animation, particularly for holographic applications, will be highly valued. The ideal freelancer will be able to not only create a visually impressive avatar, but also ensure that it conveys the desired emotion and performs the nec...

I'm seeking a freelancer with expertise in SolidWorks to create a 3D DWG file. This is a simple project that requires an existing pedestrian bridge design to be presented as a dwg file. Ideal qualifications include: - Proficiency in SolidWorks - Experience and knowledge in 3D modeling and design aesthetics - Close attention to detail to ensure design accuracy and integrity.