Excel pivot update database connection jobs

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I'm in need of an experienced developer who can build a completely custom database website that primarily serves as a customer relationship management (CRM) tool. In addition to the standard CRM functionalities, I'm looking for the following: - Expertise in complex Java and YAML scripting - Ability to create custom database scripts - Proficiency in API integration for seamless data transfer and communication - Prior experience in designing and implementing CRM front-end and back-end relations The most crucial aspect of this project for me is the user interface design and experience. I want a website that not only functions efficiently, but also looks and feels intuitive for users. I'm looking for someone who: - Is an advanced-level developer - Has a strong...

Seeking a Los Angeles based social media manager who specializes in content creation (reels). Main Responsibilities: Develop and im...more than 2 posts per week) Ideal Skills: - Proven experience with Instagram platform - Solid understanding of demographic preferences of mature professionals - Creativity and effective communication skills - Demonstrated ability to create engaging content that sparks conversations Your expertise will play a significant role in raising awareness about our brand and establishing a stronger connection with our audience. Please bid if you are interested in bringing ideas and strategies to life and have proven success engaging this demographic on Instagram. You will be responsible for developing high-engagement strategies as well as overall account m...

I've been running BLOG site for about 6-12 months with a daily content update schedule. I've been disapproved by Adsense 3 times and need someone to solve and get it approved. Key points: - I specialize in textual articles/blogs. - New content is added daily. - The site is well-established, but I've been unsuccessful in getting Adsense approval. - I'm looking for someone with a proven track record of getting Adsense approvals for similar sites. - Experience with Adsense policies and guidelines is a must. - Good communication skills are a plus, as I prefer being kept informed about the process. If you have prior proof of success getting rejected sites approved, show me, and you get the job.

I need a structural engineer to update existing plans for an interior home remodel to submit to the City of Henderson, NV for an owner/builder permit. MUST be able to STAMP the plans and be licensed in NEVADA, USA. The city wants drawings from an engineer mainly for the following: (complete plans to be discussed if you are interested in this assignment) -replacement of two windows to two larger windows with new header to carry load of second floor above -replacement of a double front door with glass block sidelights to a single pivot door with larger glass sidelights with new header to carry load of second floor above. Window and door manufacturer to supply engineering specs to engineer -removal of upstairs fireplace and replace with wall and new opening to primary bath (n...

I need a professional PHP developer to update my current PHP script. The script currently uses PHP mailer to send emails using normal login (Less Secure Apps) authentication. The new Gmail security measures will require the use of Oauth for authentication. The ideal candidate should have: - Strong PHP skills and experience with PHP 7 - Expertise in PHPMailer and setting up email services, specifically Gmail - Solid understanding of OAuth authentication - Experience with updating scripts to accommodate new security measures - Good problem-solving skills to ensure the script remains fully functional post-update

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I'm looking for a WordPress expert to help with crucial updates on my website. The project consists primarily of content updates, along with special focus on updating various plugins. Key Responsibilities: • Updating content as per provided instructions • Updating and troubleshooting three specific plugins: Yoast SEO, WooCommerce, and Contact Form 7 Ideal Skills: • Strong expertise in WordPress • Prior experience with Yoast SEO, WooCommerce, and Contact Form 7 plugins • Attention to detail for subtle content updates. Let's enhance my website together!

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should b...

I am currently working on a project where I need to implement the flow to send and receive invoices from a DEX vending machine on iOS. To simulate the connection to a vending machine, we are using a Redpark serial cable: With this cable, I connect to a serial/USB adapter and simulate a vending machine to try sending invoices and receiving invoice adjustments in the applications. Redpark provides an SDK() and demo software for sending and receiving data, which helps in understanding the basics. However, I am currently unable to find the correct sequence to successfully send and receive invoices to a DEX machine. I understand that there is a protocol and control

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

...responsible for keeping track of both pricing and product availability. A high level of accuracy is essential. Update frequency should be configurable. This script should be written in an efficient language. As I have no specific preference, I trust your judgement on choosing a language that is effective for the required task. Ideal requirements: - Proven experience in developing similar scripts - Knowledge of and experience with eCommerce website structures - Accurate and detail-oriented developers are highly essestial. Your proposal should include the language you intend to use and why you think it would be the most suitable. Please also mention how frequently the script will update the information. Start your bid with "Tracker Guru" to help me filter ou...

I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.

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

...components The website must have acceptable performance by today's internet standards (loading within 3 seconds) The site will not have 3D animations or videos. Authentication We use JWT for user authentication and authorization. ❌WHAT YOU DON'T NEED TO DO NodeJs BackEnd Development • It is not necessary to develop the backend in NodeJs. We have our own developers Connection to the database • No need to develop database structure such as tables or MySQL connections Server • It is not necessary to develop or structure any cloud configuration for BackEnd, FrontEnd server UI/UX Design • There is no need to develop the design. We have the layout of each page in Figma, with the necessary structure for development. • Style Guide:...

Endoslim logo update

I need a skilled individual to convert my current Laravel website to WordPress. The main reason for this transition is to ensure that I have a user-friendly, easy-to-manage website. Currenlty, the website is built with Laravel, but I would like it to be converted to WordPress to make it easier for me to manage and update the content. Ideal skills and experience: - Proficient in Laravel and WordPress - Strong understanding of website architecture and conversion process - Ability to ensure a seamless transition - Good communication skills and ability to explain technical concepts to non-technical individuals.

Updating prices on Puparazzi’s brochure

I'm looking for an experienced fr...Sisense. Requirements: - Creation of specific widgets: Charts, Tables - Charts: Line charts, Bar charts, Pie charts - Tables: Data tables, Summary tables, Pivot tables These widgets will a show the following: - Top ten Selling Items (# units sold and $) - Upsells (# units sold and % of overall sales) - Modifiers (# units sold and % of overall sales) - Daily specials ($ sold and % of overall sales) The ideal candidate should have: - Proven experience in developing widgets for Sisense - Proficiency in creating various types of charts - Strong understanding of data table structures - Ability to design and implement effective summary and pivot tables I'm looking for a committed freelancer who can deliver high-quality work wit...

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

I am looking for an expert to put together a professional sales report using Sisense, solely based on my e-commerce platform data. Key Information: - The report should focus on sales statistics and trends, analyzing data collected from our e-commerce platform. - The main purpose of this reporting is to help us make strategic decisions and improve...will be shared with different teams in our company. Skills & Experience: - Proficiency in Sisense or similar BI tools is a must. - Previous experience creating sales reports is highly desirable. - Understanding of e-commerce data, especially sales metrics, is crucial. Please note that the report you provide can be used as a reference for future reports, so a well-documented process of how to update and maintain the report would ...

I need a simple web application developed using the Scriptcase platform. The main functionality of the project will be integrating a database into the application. This will include data for user profiles and product listings. Key Requirements: - Development experience with the Scriptcase platform is a must - Proficiency in PHP and web application development - Experience in integrating databases into web applications Other Details: - The application must be user-friendly and intuitive - No specific user roles or permissions are required, all users will have the same level of access.

I require an experienced developer to write and implement a single page webhook URL into my current server. This webhook will specifically track and update the delivery status of messages sent through the JIO Interakt WhatsApp service, indicating if messages have been sent, delivered or failed. Skills and Experience: - Proficiency in ASP.NET C# - Deep knowledge of working with Webhook - Experience with JIO Interakt WhatsApp messaging service Project Requirements: - Implement single page webhook URL in ASP.NET C# into the current server - Webhook should track 'Sent', 'Delivered', and 'Failed' statuses of messages - It should retry sending the message if delivery fails - Use existing JIO Interakt WhatsApp messaging service API Please provide proof of...

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.

Physician looking to move to Middle East. Looking for instructor to tutor medical Arabic. Would like to role play patient-physician communication scenarios. Requirements: - Fluency in Arabic - Physician or Medical Student - Dialects: Shami (From Jordan, Palestine, Syria, or Lebanon) or Khaleeji dialect - Male instructor only - Good internet connection

I'm seeking an expert web designer who can conceivably transform my current website with a vision for increased website traffic, enhanced user experience, and improved site navigation. Main goals: - Update my website's layout and design to manifest a minimalistic and professional look - Substantially improve my conversion rates - Broaden the reach of my brand image. Ideal skills and experience: - Proven experience in web design, particularly minimalistic and professional designs. - Proficiency in UX/UI design for enhanced navigation and user experience. - Track record of successful SEO implementation to increase website traffic. - Evidence of positive impact on conversion rates in past projects. - Ability to understand and implement brand's aesthetics on the webs...

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 transfer of all informati...

**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 the othe...

...styles of FormioJS to look and function correctly with Tailwind CSS. 2. Full Compatibility: Ensure that the styles are compatible with existing MaryUI and daisyUI components and styles. 3. No Project Modifications: No modifications to the current project are required, only the necessary styles should be added. 4. Documentation: Provide basic documentation of the changes made and how to maintain or update the styles in the future. Required Skills: - Experience with Tailwind CSS - Knowledge of FormioJS - Familiarity with Laravel and Livewire - Ability to work with Jetstream, MaryUI, and daisyUI Final Objective: The final objective is to have fully styled and functional FormioJS forms within the environment of my project, using only Tailwind CSS and respecting the current structur...

I'm looking for an expert in 123FormBuilder to assist with the maintenance and upkeep of our complex travel request form. This form is integral to our business processes, and as such, we need someone who can manage and update it efficiently and effectively. Key Responsibilities: - **Approval Workflow Expertise**: We require a professional who is adept at setting up and managing multi-step approval workflows, with up to 3 levels. The ability to understand and implement these workflows will be crucial to the success of the project. - **Form Field Management**: Our form is dynamic and may need adjusting from time to time. The ideal candidate should be able to easily add or remove form fields as needed, without compromising the overall structure and functionality of the form. - ...

...need of a skilled computer expert to help me develop a database. This database will essentially serve as an accounting tool for food. It's crucial for me to keep track of various aspects of my food-related transactions, including purchases, sales, and expenses. I require a professional who can translate these needs into a well-structured database. Key requirements include: - Data on food purchases, sales, and expenses should be efficiently stored and easily accessible - The database should be designed to facilitate clear accounting procedures - The system should be user-friendly and reliable, making it easy for me to input data and generate reports as needed Ideal skills and experience for this project are: - Proficient in database design, part...

I'm setting up a new Facebook page to promote my brand, targeting the youth and young adults demographic. I'm looking for a social media expert who can help me create and manage my content. Key Responsibilities: - Set up the Facebook page for brand promotion - Develop engaging, youth-oriented content: both visual and textual - Regularly update the page with news, promotions, and relevant information - Engage with the audience, reply to comments and messages Ideal Skills and Experience: - Proven track record in setting up and promoting business pages on Facebook - Strong understanding of youth and young adult consumer behavior on social media - Excellent content creation abilities, particularly for this demographic - Proactive approach to community management - Knowledge...

Hi I need VPN application to connect to v2ray configs For example, I have several servers with Vless, Vmess and Trojan configs from several different countries server, also I need to update servers through admin, sort servers, delete, add and hide Ability to use free and premium modes, connect to PayPal and Stripe payment gateways, etc. But I need Run this project step by step for example for first task just free plan and then add premium plans and gateways and etc. for example then I need create ios app and more I'm looking for a skilled developer to create a custom VPN application for my needs and upgrade it in future

I'm experien...front end - High server CPU usage, which I suspect is leading to the slow loading times - Database connection errors - Posts in the backend are taking a considerable amount of time to load I haven't made any recent changes to the site, such as installing new plugins or updating the theme, which could have caused these issues. I need a skilled professional who can dig into these issues and improve the overall performance of my site. Ideal skills and experience for this job include: - Extensive experience with WordPress - Proficiency in optimizing site performance - Knowledge of Apache and MySQL/Mariadb - Experience working with Virtual Private Servers - Ability to diagnose and resolve database connection errors - Understanding of serv...

problem one database erp hosting program

I need a software expert to develop a program that scrapes text 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 on...

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.

I'm in search of a competent cheat developer to create a specific ESP/Wallhack cheat for the game Ghosts of...players' health status, providing an advantage during combat. - Item Highlighting: Essential items within the game environment should be illuminated or highlighted for easy identification and collection. Compatibility: This cheat must be compatible with the game as it is played on a Quest 2 PC. Frequent check-ins and updates will be needed to ensure the cheat remains effective with each game update. Communication: My preference for communication and sharing updates is through email. Regular status updates and any necessary clarifications should be easily achievable using this method. I look forward to seeing your proposals and working together on this unique ...

...opportunities for improvement. • Develop and implement strategic plans and initiatives to achieve our goals. • Provide expert advice on business process optimization and efficiency improvements. • Collaborate with cross-functional teams to ensure alignment and effective execution of business strategies. • Prepare detailed reports and presentations to communicate findings and recommendations to clients. • Update on industry trends, best practices, and emerging technologies to provide innovative solutions. Qualifications: • Bachelor’s degree in Business Administration, Management, Finance, or a related field. Master’s degree preferred. • Strong analytical skills with the ability to interpret complex data and generate actionable insig...

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 data, so attention to d...

I'm starting a new yoga service aimed at beginners. I'm looking for a skilled yoga practitioner who specializes in Hatha yoga to conduct live online classes. Key Requirements: - Expertise in Hatha Yoga: You should be adept at Hatha yoga and have experience teaching it to beginners. - Online Teaching Skills: You'll be required to conduct live online classes, so a good internet connection, clear audio and video, and a good understanding of online teaching platforms are essential. - Patience and Communication: As my target audience are beginners, it's important that you are patient and able to communicate complex ideas in a simple, easy-to-understand manner. Your responsibilities will include: - Planning and conducting live online Hatha yoga classes - Modifyin...

...are currently in need of a seasoned and results-oriented freelance Project Manager. In this role, you'll be the cornerstone of our client engagement process, responsible for leveraging your extensive experience in marketing projects to manage and assist in sales improvement. Key Responsibilities: - Attend Zoom calls with clients to meticulously understand their needs and requirements. - Act as a pivot in the client engagement process, effectively promoting our services to close deals. - Utilize your expert knowledge and experience in marketing projects to drive sales. Key Requirements: - Previous experience managing marketing projects is essential. - Exceptional communication skills, specifically through Zoom calling. - Proven track record in driving sales and revenue grow...

I'm looking for a platform that can create a map with specific features. The main purpose of this map will be data visualization. The primary focus is on having a drop-down menu that can change the status of each location on the map. ...display information: While the drop-down menu is crucial, the ability to display additional information in a pop-up window is also important. - Change color according to status: It's essential that the map can visually distinguish between different statuses. - Ability to add notes: These should be easily added and editable, with an additional capability to draw on top of these notes. I plan to update this map manually, so the interface must be user-friendly. I'm open to various solutions, so if you have experience with similar proje...

I'm seeking a skilled developer to create a form for my WordPress site that allows users to add a variety of colors. This form will need to be designed to match the provided example. - User Interaction: When a user adds or subtracts a color, the form should update in real-time and count up the number of colors selected. The user should be able to see a preview of the selected colors. Furthermore, the form should dynamically adjust the color options based on the user's selections. - Data Handling: The form should send me an email with the final count and types of colors selected. - Layout and Design: It is crucial that the form matches the design of the provided image. Ideal applicants should have: - Extensive experience developing custom forms for WordPress - Proficiency...

I need to update the website banner to include edits and the two new badge images you recently completed.

...with our Oracle database under 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 ...

...quickly find the information they need. - It should have a Content Management System (CMS) that allows easy updating of the content. - The website must be responsive, ensuring it looks great and functions well on all devices. Your role as a designer should be to create a site with strong visuals and a clear structure that effectively showcases our services and treatments, while also being easy to update on a regular basis. The ideal candidate should have experience in designing websites for beauty salons or similar businesses. Your portfolio should demonstrate your ability to create visually appealing, user-friendly websites that specifically focus on showcasing services and treatments. Please provide examples of your previous work in your proposal. I'm looking forward to ...

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

...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 experience with Excel a...

I'm looking for a skilled marketing professional to help promote my latest track across various social media platforms. Key Responsibilities: - Utilize Facebook and Instagram for promoting my song. - Develop and execute cross-platform marketing strategies to engage with all age groups. Desired Strategies: - Focus on organic social media posts to build an authentic connection with my audience. - Collaborate with influencers who align with my music style to extend reach and engagement. Experience and Skills: - Proven track record of successful music marketing campaigns across Facebook and Instagram. - Proficiency in developing effective organic social media strategies. - Demonstrated success in influencer partnerships within the music industry. I'm keen to hear your ide...