Write data excel database macro punët
I'm looking for a comprehensive Excel dashboard that can help me manage resources for my projects. This project will involve visualising project management data, with a focus on resources management and planning. The key elements of this dashboard will include: - Resources Planning: Visualising the availability of team members, their skills and current project assignments. This should help me in efficiently allocating resources for various tasks. In addition to these, I'm also interested in other data such as budget tracking and milestone tracking. The ideal candidate for this project should have experience in: - Advanced Excel skills, with a focus on creating visually appealing and user-friendly dashboards - Experience in designing project manage...
I'm seeking an expert in .NET framework for a project that involves setting up a multi-tenant database. My preference is to have a separate database for each tenant, with the databases themselves being simple and containing only a few tables. Key Responsibilities: - Develop a multi-tenant functionality in .NET entity framework - Implement a separate database for each tenant - Design a simple database with few tables Ideal Skills & Experience: - Extensive experience in .NET Framework - Proven expertise in multi-tenant database setup - Proficiency in designing simple databases
...professional with deep expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to be processed, we require an array of security measures. These include password protection, restrictions for specif...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
I am seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Format: The final deliverable should be in Excel or CSV format. Experience Required: - Proficiency in Chinese language and familiarity with Chinese business conventions. - Previous experience in retrieving contact information. - Attention to detail and accuracy in data collection. Please reach out if you believe you have the necessary skills and experience for this task.
Hiring a hybrid NYC remote assistant for a clean energy company. Job is Monday, through Friday via different tasks we will send you. Job...installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please include a 15 second audio of your speaking voice to show you have english of wor...
I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability to efficiently handle large datasets and w...
...effectively scrape specific data across 1000's of web pages. The specific websites for this web scrapping operation will be college and university athletic pages. Therefore, among the required skills is the versatility to adapt to different websites' structures and frameworks. In terms of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Google Sheets and database creation - High attention to detail - Demonstrable abili...
I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and e... Irwin & Dow - Premier Recruitment - ManpowerGroup - Mark Williams - Robert Murray - Future Tense - Black & Grey - Education 1st recruitment - Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets.
i will create 1 power power point and 1 excel sheet adding the equations
I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.
As someone looking to hire a talented content writer, I have a variety of assignments that'll involve writing content within a word limit of 500-1000 words. I didn't specify the exact type of content ...content writer, I have a variety of assignments that'll involve writing content within a word limit of 500-1000 words. I didn't specify the exact type of content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experience: - Excellent writing skills - Versatility in content writing - Ability to generate creative ideas - Experience in varying styles and formats of writing - Understanding of SEO is beneficial, but not required If you believe you would excel at t...
write project for writers club confidential project
I'd like to request a quote for "xl heet and powerpoint".
Write a discussion paragraph based on a given survey. See attachment it is short only 6 questions and some question doesn't answer. Arabic reading skills are required. Project detals: I would like a detailed discussion that covers all questions and includes all audience answers. It should establish a strong connection and effectively demonstrate the importance of the project, particularly highlighting the significance of the audience, many of whom are managers and directors. Also I want the 9 survey's answers in english in seperate file.
We're looking for a web developer to refine an existing HTML page! You'll take a previously converted Excel sheet (.html) and enhance its visual appeal. This involves adding CSS styling to improve the layout, formatting, and overall aesthetics of the page. Experience with HTML and CSS is a must, and an eye for clean and user-friendly design is a plus!
I require someone with a legal background, preferably from India, to draft a 3-4 page document on the Indian judiciary system. The document should thoroughly research and address two key aspects: 1) Proposed changes to the selection process of the Indian judiciary- including the establishment of a Union Judicial Service Commission (UJSC) aligned with the UPSC to aid in the selection process of the Higher Judiciary and similarly creation of a State Judicial Service Commission for the selection of lower judiciary members who can advance within the hierarchy through promotion, among other recommendations. 2)Solutions for addressing the issue of long pending cases in India- This includes proposals to expedite the case registry process, such as involving a third party for swift document regist...
Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.
'Microplastics The Silent Invader.' Information explaining the the detrimental cause and affects to our ecosystem and our health concerning plastic waste broken down into microplastics and, the initiatives needed to annihilate this silent invader.
I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscr...
I made a wordpress custom theme. Devs don't like to document things (I kept asking...) so need to force the matter and have someone just do it! The focus is on what is not obvious. e.g. The footer has a "join newsletter button", but where do you edit that and how does it integrate with the CRM? (And if there is custom shortcode where is that written) I need someone who knows Wordpress and to write simple documentation in a Google Doc (for me/devs- You don't need to explain how to copy/paste! ;)). This is not hardcore stuff, it's spending time on my site (I can tell you obvious things), seeing what needs to be explained (asking questions) and then writing the shortest explanation possible with screenshots so any dev (or me!) will know how to update someth...
The project requires a freelancer with exceptional attention to detail and expertise in Excel to conduct a thorough review of a spreadsheet for any data inaccuracies and anomalies. The primary tasks involve identifying and rectifying incorrect or illogical entries, ensuring the consistency and integrity of the data, and highlighting any variables that require correction. The ideal candidate for this role should have strong proficiency in Excel and data handling, as well as experience in data quality assurance. This meticulous review is crucial to maintaining the accuracy and reliability of the data, which is essential for making informed decisions based on the spreadsheet information. Attached with the details is a sample of the spreadshee...
...values data, I'm looking for a talented individual who can handle a medium-sized excel database (1000-5000 rows) that comprises of numerical, categorical and textual data. Key Tasks: - Data Entry: The selected candidate will need to input some outstanding data into the excel database accurately. Great attention to detail is vital for this task. - Data Analysis: I want someone who can decipher patterns and trends from raw data. This may include evaluating figures, trends, and other areas to draw practical insights. - Data Visualization: After carrying out an in-depth analysis, I want the extracted information to be presented visually to aid understanding and decision-making. Desirable Skills: - Pro...
As a beginner, I'm in need of someone skilled in typing data into Excel spreadsheets. The data entry will involve basic formulas and functions for simple data analysis, and I'm looking for someone who can make this process easy to understand and execute. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Able to explain basic formulas and functions in a clear and concise manner - Attention to detail to ensure accurate data entry - Patience and understanding of beginner level tasks
I am looking for a specialist to create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI tes...create an interactive UI in React Js that provides a seamless user experience. This project will require: - The creation of at least two UI test cases, with a clear emphasis on user interaction tests. - Setting up and integrating Routing and Guard Components for authorization. - Developing a backend in Spring Boot. - Saving credentials in a MySQL database. Ideal candidates should have solid experience with React Js, Spring Boot, and MySQL database. Proficiency in creating user interaction tests is also a must. Once completed please provide a GitHub link for the project in .docx file with scree...
I need a meticulous and responsible professional to help me with cataloging 1000-1200 books. Here is a detailed breakdown of the project: - **Data Entry**: I need all of the books' titles and their respective authors accurately entered into an Excel spreadsheet. This will be done manually, so you must have excellent typing skills and attention to detail. - **Turkish Characters Proficiency**: An essential requirement for this job is a strong proficiency with Turkish characters. As some of the books will have titles and authors in Turkish, you should be able to accurately interpret and enter these characters. - **Handling Missing Data**: In the event that a book's details are missing or illegible, I would like you to search online for the information. If thi...
...freelancer who can help me create a visually appealing PowerPoint presentation and handle some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication sk...
I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.
I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.
Write financial contents for a financial blog. Category 1. Investments 2. Banking 3. Insurance 4. Personal finance 5. Loan Etc. Make sure your contents are not copy pasted. Should be 800-1000 words long atleast. Paid to you 1.5USD per article
My current server setup is causing slow response times for my web application and database system. This project involves optimizing the server settings to enhance the performance of both the web and database applications. Ideal Skills and Experience: - Proven experience in server performance optimization - Expertise in managing servers running web applications and database systems - Familiarity with Laravel, as the web application is built using this technology - Excellent understanding of server-side technologies and configurations Key responsibilities: - Diagnose the current server setup to identify performance bottlenecks - Implement necessary changes to optimize the server settings - Regularly monitor and fine-tune the server to maintain high performance - Provi...
I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data
I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English
I am in need of a seasoned data entry professional who can attentively transcribe information from various online databases into Google Sheets. The role is strictly manual data entry. Skills and Experience: - Proficient with Google Sheets and similar spreadsheet management tools. - Past experience with database interaction, particularly online databases. - Must have a keen eye for detail to ensure accurate data transcription. - Excellent time management skills are essential as deadlines are strict. Although this position emphasizes manual data entry skills, experience in data cleaning and validation pave the path for optimal efficiency. The successful candidate must provide proof of prior similar projects. Your ability to maintain high standar...
I'm in need of a serious, detail-oriented freelance virtual assistant for some important data entry tasks. Key Requirements Include: - Specialized in data entry, with strong attention to detail. - Experience with Excel spreadsheet is compulsory because all text-based data entry will be done here. - As this is text based data, a great understanding of English and excellent typing skills are required. - Being well-organized, disciplined, honest and able to complete tasks on time is essential. This job is suitable for someone who enjoys data input tasks with a knack for precision, consistency and quality of work. If you meet these requirements, I want to hear from you!
I'm seeking a talented writer with a nutrition background to create a high protein recipe E-Book for my online training and nutrition coaching business based in Australia, Key project elements: - The book should be in PDF format. - It should include recipes with complete nutritional information, particularly macro breakdowns for each one. - Should include breakfast, lunch, dinner and snack options. - The ingredients should be Australian based- things that are sold in Australia Ideal Skills: - A strong understanding of nutrition, specifically macronutrients. - Experience in ebook writing and formatting, preferably with a focus on recipe or health books. - Ability to create engaging and informative content. - Precise, clear, and concise writing style. Please note, additiona...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...
Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...
I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, inclu...
...create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzing past purchases to pr...
My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with ...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyz...
I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.
Enlgish: I have a large quantity of PDFs to process and I am looking for the same specific information each time. I'd like it to input it into Google sheet. I would like to have a program where I can drag and drop the documents, then click on "extract," which allows me to have the information in the correct cells of my Excel or Google Sheet file. ------------------------ French: J'ai Une grande quantité de PDF à traiter et je recherche à chaque fois le même information spécifique Je souhaiterais automatiser le processus
I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.
