Excel php csv pivot jobs
...OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices&quo...
I'm looking for a skilled developer to upgrade my site from PHP 7 to PHP 8.2. The current site has: - User registration and login functionality The site is built on Custom PHP, without the use of any specific frameworks or CMS. The ideal freelancer would have: - Strong experience with PHP - Previous experience with upgrading codebases from PHP 7 to PHP 8.2 - Familiarity with Custom PHP coding Please note that the client did not specify custom plugins or modules that need updating. However, it's important to anticipate and address any issues that may arise during the upgrade process. The selected freelancer should be able to identify and resolve any potential conflicts with the existing site's functionality.
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
I'm looking for a freelancer who can create a comprehensive, user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple businesses. The system sho...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your proposals!
...recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a ...
I'm looking for a professional who can set up an automatic download of mainly .csv files from FTP, SFTP, https and webscraping-login. The script should be configured to run daily/weekly at pre-defined time - configurable for each file. Requirement: Check after each download that the download has actually been downloaded. Notify user if any errors occur. Key Requirements: - Configure FTP download automation on Windows enviroment or hosted. - Schedule the download to occur at defined day/hour. - Check if download has been succesful. - Clear commented code. I only respond to bids where the bidder clearly has read the description...sorry (not really sorry, lets not waste each others time :) ) I prefer fixed price, but have entered hourly - let me know your suggestion.
I have a document with the specifications of webservices. I need with php consume this webservices and get responses and save some information in my database
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet platforms...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, you...understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financia...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing ...tasks as assigned by the CEO. QUALIFICATIONS: Proven experience as a Virtual Assistant or in a similar administrative role. Excellent written and verbal communication skills. Strong organizational and time-management abilities. High level of professionalism and confidentiality. Ability to work independently and handle multiple tasks simultaneously. Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint) and Google ...
The task at hand is to upgrade the PHP version of my content management system from 7.2 to 8.1. I have been using a PHP without any frameworks, and I'd like to keep it this way. I'm seeking a skilled developer well-versed in PHP and experienced in operations without frameworks. Your responsibilities will include: - Studying the existing PHP code - Carrying out the necessary modification for smooth running on PHP 8.1 without any performance degradation. - Testing and debugging post upgrade to ensure seamless system operation Please note, I need this work completed within 7 - 15 days.
Description: We are currently seeking a dynamic and motivated freelance cold caller to join our team and assist in prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for help...management. Benefits: -Daily and Weekly Bonuses based on production!!! -Competitive compensation based on performance and call volume. -Opportunity to make a meaningful impact by helping low-income individuals access essential healthcare services. -Potential for growth and advancement within the company based on performance. If you are passionate about making a difference and have the skills to excel in a fast-paced cold calling environment, we want to hear...
...Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the excel file or txt file - starti...
I'm in need of a PHP developer to assist with resolving a specific issue within my code, and also adjust some functionality related to user balances and payment processing. - The issue is isolated to a certain part of the codebase. I have a video that comprehensively explains the problem, saving you time on debugging and troubleshooting. - The main issue at hand involves the necessity of adjusting user balances and funds for payments. This requires a high level of precision and understanding of PHP functionality. Ideal candidates should have: - Proficient in PHP and associated technologies. - Strong problem-solving skills to address the issue quickly. - Experience in user balance management and payment systems is highly desirable.
I'm in urgent need of a PHP expert to assist in creating (or finish the unfinish project attach ) a server-side application that will use Google Drive API, Google Calendar API, and/or Google Contacts API. The main priority is to implement user sign-in functionality for the application to ensure secure access and authentication for users. Key Requirements: - Seamless integration of Google Drive API, Google Calendar API, and/or Google Contacts API into a PHP worker application. - Implementation of user sign-in features to authenticate users and provide secure access to the application. - Priority on the ability to upload files using Google Drive API. The ideal freelancer must have: - Proficiency in PHP and experience with server-side applications. - Expertise in ...
We are an Ecommerce company dealing with variety products and we are looking for a ...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
Hello there, We will translate your Excel file (Magic Jackpot Ads (Slots)) into Hungarian. Thank you!
As discussed in chat and outlined in the provided document, excluding referrals, support ticket and reports
I'm in need of an experienced graphic designer to create a captivating, illustrative logo that stands out and reflects the essence of my brand. This design is crucia...primary use has not been defined yet; it could range from web applications to print materials or product packaging. - Deliverables include the original vector files and high-resolution PNGs. - Must be available for a brief consultation before starting and open to revisions, if necessary. **Timeline:** - Complete within 2 days from project start. This project is ideal for creative freelancers who excel under pressure and have a knack for delivering high-quality work promptly. Your contribution will play a pivotal role in the launch of my new product, and I'm excited to see how your creativity will help brin...
...operations support assistant to aid me in daily tasks. Key Responsibilities: - Spreadsheet Management: You will be tasked with keeping our Excel sheets organized and updated to ensure seamless operations. - Report Generation: You will also be responsible for generating reports for our activities. These reports must be clear, concise, and error-free. - Daily Calls: You will make regular teams calls within the operations team. - Research & Analysis: The role will also require you to conduct research and analysis on various topics as needed. Your Excel Skills: I need a candidate who is proficient in Excel. An intermediate level of understanding and experience in Excel is a requirement for this role. You need to have a personal computer and a data speed ...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
We are an Ecommerce company dealing with variety products and we are looking for a ...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
...two-week timeline. The Laravel-specific requirements are as follows:- 1. Fix the Home Dashboard to display real data instead of dummy data in Laravel. 2. Implement form data transfer from the website to the CRM Enquiry Menu in Laravel. 3. Ensure that won enquiries are correctly displayed after conversion to contacts in Laravel. 4. Highlight the current menu item on the left in Laravel. 5. Correct CSV download functionality in Contacts, ensuring filters, headers, and special characters are handled properly in Laravel. 6. Enable clicking anywhere on the contact data table to open the view of that particular contact in Laravel. 7. Remove the display of the last date from the top of the contact view in Laravel. 8. Adjust calendar functionality to match design specifications in Larav...
More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.
...lead should include the following: • Company Name • Company Address • Company Phone Number • Owner's Name • Contact Email • LinkedIn URL (if available) 4. Target Titles: The contact should hold one of the following titles: • CEO • Chief Executive Officer • Owner or Managing Partner • Founder • Chief Financial Officer (CFO) • Board of Directors • Pharmacist • Manager • Director Deliverables • An Excel spreadsheet with the collected data points for 2,000 contacts. • Ensure that there are at least 1,400 unique companies represented in the list. Quality Assurance • Perform regular reviews of the data to ensure completeness and accuracy. • Use tools to remove duplicate entries and ens...
Website Designer , Php , E Commerce having knowledge of MySQL
...an exciting opportunity to advance your career in the IT industry amid the remarkable growth of the US job market. As part of our prominent company, you'll contribute to cutting-edge projects that shape the future, positioning yourself at the forefront of innovation. With comprehensive support programs, we ensure a seamless transition into our team, empowering you to hit the ground running and excel in your role. What You Bring: - Over 8 years of experience as a Python Developer, specializing in web API development, data analytics, and machine learning. - Proficiency in Python and related frameworks/libraries such as Django, Flask, NumPy, Pandas, and scikit-learn. - Strong communication and collaboration skills, with the ability to work independently and solve complex probl...
I'm in urgent need of an expert in revenue summary analysis for my accounts assignment, to be completed ASAP. Areas of focus include: - Deciphering and analyzing an Excel file, which contains base financial data. - Providing a thorough understanding of the balance sheets, income statements, and cash flow statements in relation to the given data. Ideal qualifications: - Strong accounting background. - Proficiency in financial analysis and interpretation. - Familiarity with balance sheets, income statements, and cash flow statements. - Proficient in Excel data manipulation and interpretation. - Must be able to work fast as this task has a high-priority deadline.
I need a proficient Excel expert who can create an organized spreadsheet to track our monthly sales data. Key Requirements: - The spreadsheet should be organized by month. This means that the sales data for each month should be clearly separated. - The primary function required is to sum up the sales totals for each month. This will help us in tracking our sales performance over time. Ideal Skills/Experience: - Proficiency in Excel, with a good understanding of formulas and functions. - Prior experience in creating sales data spreadsheets would be a plus. - Attention to detail is crucial to ensure the data is accurately presented and calculated. Deliverables: - An error-free, well-organized spreadsheet that clearly presents our sales data on a monthly basis. If you bel...
I need help with data entry. The task involves typing data from online sources into an Excel spreadsheet. Key Requirements: - Data Entry: The primary task is to accurately enter data from online sources into Excel. Prior experience in data entry is preferred. - Typing Skills: A good typing speed and accuracy are necessary for this task. - Familiarity with Excel: Basic knowledge of Excel is required to ensure the data is entered appropriately into the spreadsheet. - Attention to Detail: The data must be entered without errors or omissions, so attention to detail is crucial. The final deliverable should be an Excel spreadsheet with the data inputted neatly and accurately.
I'm in need of a programmer well-versed in TIA (V18) Unified and JavaScript to assist with a specific task. - **Skillset**: Proficiency in TIA (V18) Unified and JavaScript is crucial. Experience in data manipulation and handling would be an added advantage. Your primary responsibility will be to help me export a datalogfile created in TIA (V18) Unified to a CSV file using JavaScript. The purpose of this export is for archiving, as the datalogfile is stored locally. Please reach out if you believe you have the right skills and experience for this task.
I am looking for a proficient C# developer who can build a .Net 8 Console application with in-depth CSV handling capabilities. You will need to be able to: - Import CSV files; - Validate CSV data, specifically focusing on data format and range checks; - Convert validated CSV data to a c# DTO format; - Post the converted data to an API. Responding to errors is a significant part of the project. The application should be able to handle any issues encountered during the import, validation, or conversion processes seamlessly. Proficiency in C# is a core necessity, with previous experience in CSV handling and data validation highly desired.
I need a skilled developer to create a graph logic application in either Core PHP, JavaScript, or JQuery. The application will focus on visualizing user engagement data, specifically the bounce rate. Key Requirements: - Develop a graph logic application that utilizes Core PHP, JavaScript, or JQuery. - The system should effectively visualize user engagement data. - The application should specifically focus on visualizing the bounce rate metric. Ideal Skills: - Proficiency in Core PHP, JavaScript, or JQuery. - Experience in developing graph logic applications. - Understanding of user engagement metrics.
...business owners achieve their business goals in the past. I am an excellent communicator with sublime linguistic skills, and attention to detail is my key skill. Ill follow your instruction for the letter and get back to you with fantastic results. Here are the services I offer: Data Entry Data Mining Excel Data Entry CRM Data Entry Data Scraping Copy Paste Work Data Conversion Shopify Product Listing WordPress Data Entry PDF to Excel or Word JPEG to Excel or Word Typing in Excel or Word E-commerce Products Listing Web Research and Web Scraping Please read the reviews from my previous clients where they speak about my professionalism, quality, and work ethic - Im confident you will find me outstanding among the crowd. Simply select the...
...maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel and the abi...
...rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Familiar with the nightlife industry...
The project consist to convert a json format file to some csv format files
I need someone to display my YouTube comments based on newest first. I use PHBB forum so I would like it shown on top. It can accept html and php I believe. It should only show 5 latest. So if you can create this on your site I can upload it to mine and so we can see this on a blank page. Then I need code to insert into my Phbb forum
I'm in need of a precise and efficient data entry operator to assist in entering numeric data into Microsoft Excel. The data will be provided in printed format. Key Responsibilities: - Accurately inputting numeric data into Microsoft Excel. - Ensuring data quality and consistency. - Meeting delivery deadlines. Ideal Skills and Experience: - Proficient in data entry. - Experience working with numeric data. - Advanced knowledge of Microsoft Excel. - Excellent attention to detail. - Strong time management and organizational skills. The successful candidate will be able to demonstrate a proven track record in data entry and will ensure the highest levels of accuracy and efficiency.
I need a python software that can find emails from LinkedIn Sales Navigator URLs. The emails need to be in Excel format. What I Need in Excel: - Name of the person - Email - Location - Designation Procedure: - I shall enter sales navigator ulr where multiple leads in pagination format displayes. - Software will pick each person url and find out his email (personal/professional) - Add that record along with above fields in excel sheet. Make sure software must not stuck, and i shall clear the payment after testing couple of days. Ideal Skills: - Proficiency in Python. - Experience in web scraping, particularly with LinkedIn URLs. - Familiarity with data manipulation in Excel files. This project is ideal for someone with a strong background in Python and web s...
I'm seeking a professional to assist with integrating my python scraping script output to my personal WordPress site in real-time. Key Requirements: - The integration should be real-time and without the need for page refresh - The current output of the python script is a CSV file, but can be Json or another Ideal Freelancer: - Proficient in Python and WordPress - Experience with real-time data integration - Familiarity with data formats (CSV, JSON, etc.) - Excellent communication skills to deliver a seamless solution Looking forward to working together.
...analyst who can dissect reports and extract necessary data daily. The task involves delving into data reports and accurately churn out meaningful information in required format. Your responsibilities include: * Analyzing various reports. * Precisely capturing key information based on pre-decided format. This project requires someone with Eye for Details, Working knowledge of MSOffice especially Ms Excel. Good English communication acumen, to understand and interpret data and derive meaningful information. Understands general market & business terminologies, Able to invest atleast 4-5 hours daily. Ideal time between 2pm to 7pm IST. Proficiency in interpreting data and a keen eye for details are highly recommended for this role. This is 100% remote opportunity, Working Lap...
...will go to 'BodyParts3D', 'Lluis Vinent' and 'Z-Anatomy'. The tools need to be set up for and be owned by the client. Profile: >3 years of experience in tailored projects in Unity Experience in the set up and use of databases Good organization and communication skills Necessary missions (estimated 100 euros): Share the project on Unity Hub Create a database containing a .csv file (the translations) and a series of texts (the definitions), Link it to the objects (the anatomical structures) through the existing functions already set up, Adapt the app for Windows, Mac and Linux, Set up a functional and reactive web viewer, Explain how to paste it on a website and how to update it, Optional missions (estimate...
I need assistance with performing formulas, calculations and descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate formulas regarding the mean, median, and mode in the data. - Conduct descriptive analysis on the dataset. Ideal freelancers for this project should have strong analytical skills and extensive experience with Excel's formula and calculation functionalities as well as knowledge of statistical analysis. An understanding of central tendency measures (mean, median, mode) is crucial.
Our organization is looking for an expert in Kubernetes to manage and optimize our existing setup. The project requires someone with a deep understanding of Kubernetes and the ability to improve our current setup in terms of performance, scalability, and security. Key Responsibilities: - Reviewing and optimizing our existing Kubernetes cluster. - Ensuring the setup is scalable and can meet future growth demands. - Implementing necessary security measures and best practices in line with industry standards. - Enhancing performance and efficiency where possible. The ideal candidate should have: - Significant experience in setting up and managing Kubernetes clusters. - A proven track record in optimizing resource usage, scaling infrastructure, and ensuring high security standards within a Ku...
Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.
...Your task will be to: - Determine the average salaries over the course of these years. - Identify notable trends in wage changes over the specified time period. - Make in-depth comparisons between the various organisations in terms of wage dispersion. Ideal candidates will have significant experience working with large datasets, particularly those concerning wages and salaries. Proficiency with Excel or a similar tool is essential. Strong attention to detail is also a must as you will need to interpret complex wage data. Furthermore, previous exposure to HR analysis would be a plus, as it adds context to the data. Your analysis will greatly help us in making compelling inferences about wages in our company, ultimately guiding us in our compensation strategies for different de...
