Excel create database summary table jobs

...creating an ER diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQ...

I have an excel file, need add product categorie on a column - budget 100€

I'm in need of a skilled photographer to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background removal is not necessary. Ideal skills and experience for this job include: - Prior experience with product photography - Proficiency in studio photography - Strong understanding and experience in color correction techniques - An understanding of e-commerce photography standards - Attention to detail and creative flair for achieving appealing product shots. This project is a great opportunity for a photogr...

...developer to create a social networking application geared towards professionals. Key Features: - User Registration and Profile Creation - Messaging System - Networking and Connection Building Features - News Feed for Professional Updates - Job Listing and Recruitment Section - In-App Search and Filter Functions - Notification System - Integration with Existing Social Media Platforms Skills and Experience: - Proficient in mobile app development - Previous experience in creating social networking applications - Strong understanding of user experience and design principles - Ability to integrate various APIs - Familiarity with data security and privacy standards This is a unique project and I am looking for a freelancer who can bring creativity and innovati...

Hello, Looking for someone to create video ads from a mobile game, you will need to play the game, get footage from and then give me 5 horizontal video and 5 vertical ads each video needs to be between 15-30 seconds long If you understand that you need to create everything from scratch and can do it in a short time frame please type GREEN at the beginning of your proposal. Proposals without it will be ignored.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

...complex backend development and database integration tasks and run code as offline. Key Responsibilities: Develop, test, and maintain robust, scalable, high-quality software solutions. Design and implement new features and functionality. Write clean, maintainable, and efficient code. Develop RESTful APIs to support front-end functionality. Integrate user-facing elements developed by front-end developers with server-side logic. - In-depth understanding and experience of backend operations using Python Django. - Managing and integration of the database with the application. - Maintenance and improvement of existing codebase for optimal functionality. Desirable Skills: - Proven experience in Python Django for backend development. - Hands-on experience in database ...

Hello, I need complet the Amazon categories catalogue excel in french

I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

...scheduling posts, monitoring engagement, and responding to comments/messages. - Content Creation: I need someone who can create compelling content for my digital marketing campaigns. This will involve creating posts across various platforms to engage with our audience and attract new customers. The Ideal Candidate: - Proficiency in managing various social media platforms, especially Facebook, Instagram, and Google. - Strong copywriting and content creation skills; experience with creating engaging content for marketing purposes. - Familiarity with social media analytics and reporting tools to measure the success of campaigns. - A creative thinker who can bring fresh ideas to the table and maintain consistency across all platforms. If you have a proven track record of dig...

Commercial real estate agency database of GCC

About Plesk hosting upgrading the database from MariaDB 10.1 to 10.3 i would like to upgrade the database from MariaDB 10.1 to 10.3 for my hosting however, my hosting have a lot of client website in it, just would like to know if this upgrade will not affect the existing database thanks

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I'm in need of a proficient PHP developer to take on a range of responsibilities for my project. You'll be handling both the front and back-end development, as well as maintaining the website. I'm looking for someone who has a strong background in PHP, not just with creating and managing dynamic and interactive web pages, but also maintaining them for optimised performance. Key Responsibilit...your application. We appreciate attention to detail and a deep understanding of PHP. Since I will provide all the content needed for the website, you can focus solely on the programming side of the task. Your expertise in PHP will be integral to the success of this project, so freelancers with a robust portfolio of past work will have an edge. We look forward to seeing what you can b...

Self Managed Home Care Providers Database

...allégorite des resaux socio? I'm in need of a skilled video editor who can help me bring my creative stories to life. I have some great ideas that I want to turn into engaging videos, and I need someone who can help me with this. Key requirements: - Proficient in video editing software - Ability to turn raw footage into a polished, engaging final product - Creative and able to bring fresh ideas to the table - Strong storytelling and narrative skills - Experience with editing videos longer than 5 minutes If you have a keen eye for detail, a passion for storytelling, and enjoy bringing creative ideas to life, I would love to work with you on this project....

...greetings for friends and relatives. The key advantage of our software is its ability to create personalized greetings for each recipient. As a Software Engineer, I am planning to rebuild the software to introduce a fresh, user-friendly interface. I have developed wireframes that outline the necessary functionality and approximate element locations. I am seeking a talented UI/UX designer to review and refine these wireframes in line with UX principles. The designer will also create an appealing and cohesive design for both the website (desktop and mobile) and the desktop application (Mac and Windows). Project Scope: - Design the main and pricing pages for the web (ensuring mobile friendliness). - Create intuitive and visually appealing interfaces for the software ...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

...according to the drawing are exactly preserved. We are able to supply a DWG file in CAD with the dimensions of the area in which the fair will be held. As part of the 3D design, we would like to model the lecture halls in 3D, including the LED screen, podium for the speaker, and chairs. Next, model cafes. Model the stands - it is enough to alternate 2-3 types of stands when the stand will have a table, sofa, TV, banners, etc. So the output should be: - 3D model of the fair - shots of the fair in PNG (approx. 10-20 plans) = we will use these images for promotion (from different points of view) - Very detailed and realistic stand model of all dimensions (as a separate file, where there will always be one model for one stand) These will be the stands: Stand 12x8m Stand 8x8m Stand ...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...open to some creative liberties. Key Requirements: - Create an engaging, 3-hour screenplay - Include intense action sequences, heroic battles against bosses, and characters with special abilities - Maintain the action-packed and thrilling tone throughout - Stay moderately close to the original video game storyline, while allowing for some creative freedom Ideal Skills and Experience: - Proven experience in scriptwriting, particularly for action-based movies - Strong understanding of the "Mega Man" game franchise and its characters - Ability to balance faithful adaptation with creative storytelling - Passion for and experience in crafting thrilling, engaging narratives If you can bring these skills and more to the table, I'd love to hear from...

I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.

[Deadline Saturday 5 pm EST] Hello, I am trying to create some supervised models in Python based on this Kaggle data set I have started however struggling to finalize the code; Preliminary Data Exploration: Explore the data, and provide some basic summary statistics and two or three visualizations. Describe/show something interesting and/or surprising about the data. This exploration should not be exhaustive, just a highlight of a few interesting things about your data set. If you need to reduce the size of your data to fit now is the time to do that. Data Exploration: shall include a bulleted or numbered list of proposed specific data explorations you intend to carry out (include visualization). These insights are things that

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include ...

I'm looking for a talented graphic designer to help me establish my brand with a minimalist approach. The project involves creating a logo and designing a matching theme for my upcoming website. Our website domain is - not yet online. The business is going to be called Daily Brewers. We will sell high end boutique coffee equipment. Key Deliverables: - A unique, memorable logo that embodies my brand - A website theme that complements the logo and reflects the minimalist style Things to Consider: - Please note that I have not finalized a color scheme. I'm open to hearing your suggestions on colors that could enhance the minimalist style. - I'm particularly interested in a modern and minimalist aesthetic for both the logo and the website theme. So, your portfolio should ref...

I'm in need of an experienced graphic designer who can help me create several T-shirt designs. These designs are intended for adult humor enthusiasts and should reflect this audience's interests. Key Requirements: - Design Style: While the design should cater to adult humor enthusiasts, I'm open to a range of design styles. From minimalistic to vintage to cartoonish, I'm looking for a creative expert who can bring unique and engaging ideas to the table. - Quantity: I need assistance with creating around 1-5 T-shirt designs. - Original Artwork Files: Once the designs are finalized, I will need the original artwork files to ensure high-quality reproduction when uploaded to our supplier. Ideal Skills: - Strong understanding of different design styles and ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

...materials Second 10 hours: - Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Su...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I'm looking for a skilled graphic designer to create a poster for my son’s wedding seating assignment. The design should be open to interpretation as I'm unsure about the style, but it should certainly incorporate pastel colors. Essential details on the poster should include the guests' names and table assignments, along with the names of the bride and groom. The ideal freelancer for this job would have experience designing wedding stationery and a keen eye for blending color schemes seamlessly.

Are you a creative and experienced web designer with a knack for crafting captivating online experiences? Join us in shaping the future of Rush Rooms! **About Rush Rooms:** Rush Rooms is a cutting-edge platform revolutionizing the rental industry, offering seamless experiences for renters and hosts alike. Our mission is to provide a modern, convenient, and trustworthy platform...organic traffic to the landing pages. -Domain Integration: Link all six domains associated with Rush Rooms to the landing pages, facilitating easy navigation and access for our platform. We need you to be expert and creative in making stuning landing pages with 2d/3d elments and expert in SEO arabic and english we need our landing pages to be in the top in the search engines. You should able to create...

I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websit...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

One of our clients is looking for a literature search with a view to searching the Pubmed database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed - Knowledge an...

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the ch...

Please Sign Up or Login to see details.

I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted and removed furniture from the areas needi...

I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of...

**NO OR LIMITED EXPERIENCE IS OK - FE...for the week. In your bid, please include clearly and simply: 1. What free tools you will use to make calls in the US - there are many you can google and figure out. It must be working BEFORE you place your bid, and you must have TESTED it as well. Do not bid if you have no confidence here in a working tool with proof as you need to communicate. 2. What key strengths that you bring to the table that make you the right fit. 3. Your experience / skills 4. Set the duration of your bid to 30 days. 5. Bid your rate for a total of 30 days, NOT hourly or daily. The budget is ~$10 a month (per 30 days) for internship. Compensation increase after 30 days. Automatic or generic bids will be ignored. No agencies or firms, only individuals. Happ...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

A high resolution interior design (e.g using Vray) of our living room. We like natural ...design (e.g using Vray) of our living room. We like natural materials. We will keep the fireplace with black belgian hardstone. We will also keep the same wooden floor. We also plan to keep the large main eating table with the red lamps, but optionally would be open to different lamp colors there. We likely also would like to keep the one dark grey wall on which the TV is positioned as it was recently painted. If possible a Fen Shui aligned design. The windows in the picture are facing west. We are especially looking for design ideas for a new couch, accessories, living room table and lamp. As well as suggestions for where to place plants. Also where to best place the paintings o...

Hello, I would like to pitch you my idea for a drawing. I have attached a couple of pictures to this message and have included my logo. This will be going on a white tee shirt. I would like it to be full of vibrant popping colors. I would like an old man sitting i...Mountains, clouds, birds, etc. I would also need my logo to be in the dirt by his feet like if he was drawing it with his feet. I wouldnt like this to be a square border i would like a creative boarder. The front of the shirt i would like my logo in a smoky look or a simliar design to the rear part, get creative and let you mind flow. Please feel free to bring your finese and artistic creations to the table. Please dont hesistate to ask me any questions. I have other ideas ready to go. Thank you very much for your time a...

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...