Pivot table formulas can only refer to items in the same field as the calculated item jobs

We are seeking a candidate with excellent English. A dynamic and self-motivated individual to join our Sales team as a Freelance Customer Service Specialist. The ideal candidate will play a crucial role in ensuring exceptional customer experiences by leveraging strong communication skills, technological proficiency, and a customer-centric approach. **Responsibilities:** - Provide prompt and professional responses to customer inquiries via various channels, including Discord, and social media apps. - Demonstrate a deep understanding of our products/services to address customer concerns and provide accurate information. - Utilize effective problem-solving skills to resolve customer issues and escalate complex matters when necessary. - Maintai...

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

I'm undertaking a college project in the field of Computer Science, specifically focusing on 360-degree video streaming. I need a tutor to meet with me 2-3 times a week for the next 6 weeks

I need a professional who can gather detailed information on more than 500 LinkedIn employees for recruitment purposes. This is a time-consuming task, so it's important to be patient and detail-oriented. A successful candidate would have: - Excellent understanding of LinkedIn and how to extract information from it - Experience in recruitment or research, with a proven track record - Patience and attention to detail This is a critical project for our recruitment efforts, so I need someone who can deliver accurate and comprehensive information.

...completed a research paper in the field of Data Science and Data Mining, focusing on APA citation style. I'm seeking an editor with solid technical editing skills to ensure my paper adheres to this citation style, and is overall formatted correctly. Ideal skills and experience for this job include: - Strong understanding of the APA citation style - Proven experience in technical editing, particularly within the field of academia or data science - Excellent attention to detail to catch any formatting errors or inconsistencies - Strong grammar and writing skills to double-check for any potential errors that may have been missed This is a one-off project, but it may lead to more work in...

As a professional in computational chemistry or biophysics, I'm currently looking for an expert mentor in the field to guide me through various aspects of molecular modeling and simulations. Key Responsibilities: - Provide advanced expertise in Protein structure prediction, Molecular simulations, Coarse-grain modeling - Support in understanding complex concepts - Assist in practical implementation and problem-solving Ideal Experience and Skills: - PhD in Computational Chemistry or Biophysics - Has publications in international journals - Strong background in Protein structure prediction, Molecular simulations, Coarse-grain modeling - Proven experience in mentoring or teaching - Excellent com...

I've noticed some key issues with my ecommerce website that I hope can be swiftly addressed. Primarily, it's not correctly calculating and providing a shipping calculator at checkout. This malfunction is proving problematic and needs prompt resolution. Key Task: - Create a new shipping calculator which calculates shipping costs based on the weight of items in the customer's cart. Shipping Providers Integration: - The shipping calculator should be integrated with both FedEx and UPS. Ideal Candidate: - Proven experience working with ecommerce platforms - Knowledgeable about integrating FedEx and UPS services - Excellent problem-solving skills in web development.

...a creative designer to develop a unique and dynamic logo for my badminton merchandise - tshirt. Key Requirements: - The logo should be a combination of both text and icon elements. - It needs to convey a strong, energetic, and dynamic feel in line with the spirit of the sport. - The design should be versatile enough to be used on various merchandise items. Ideal Skills and Experience: - Proven experience in logo design, particularly for sports or related fields. - Understanding of the principles of branding and ability to create designs that resonate with target audiences. - Strong creative vision to bring the concepts of energy and dynamism to life in a visually appealing w...

I'm in need of an experienced virtual assistant with capabilities far beyond basic administrative tasks. The right individual will offer support that spans the realm of executive assistance, project management, and strategic insight. Key Responsibilities: - Offering project and process management support across the company - Coordinating and delegating tasks (or taking them on) - Managing appointments and calendars - Screening and answering emails - Conducting research and preparing reports Experience and Qualities Desired: - Proven track record as a virtual assistant, ideally to C-level executives - Strong organizational skills, with the ability to manage multiple tasks simultaneously - Excellent communication and interperson...

...freelancers located in the U.S. ONLY. I need an Adobe Acrobat Pro expert to “Embed Videos” and “Create Links” inside a PDF document using Adobe Acrobat Pro. Just to be clear, not hyperlinks to other files outside the PDF document, not hyperlinks to websites, webpages or web located videos. When complete, and the PDF document is forwarded to another individual, they need to be able to "click on" an icon in the document and have the video play. We are a forensic investigation company and often have legal cases where these types of efforts are needed. Unfortunately, the documents cannot be sent to you. You will be working remotely o...

...designer to create a compelling banner for my website. The aim of the project is to enhance the branding of the site and attract more visitors. Your responsibilities would include: - Crafting a banner with unique, photographic imagery that ties cohesively into the current aesthetic of the site - Following general direction, but utilizing your own creativity and ideas - Ensuring that the banner adds to the overall appeal of the website while maintaining brand continuity and tone. - The banner needs to be 1280px x 320px - I just want to convert this poster that is attached into a banner, nothing different Ideal candidates should have: - Proven graphic design skills with a strong p...

I'm seeking a freelancer who can provide a list of 2000 leads of 'small gyms' in the UK. The list should include the following information: I want to Purchase this data if you have ? - Company name - Website - Decision maker name - Email (personal if available, otherwise company email) - Address - Instagram handle I have a specific criterion for the gym size, which should be verified before including it in the list. Ideal skills for this job: - Proficient in lead generation - Familiarity with the UK gym market - Attention to detail - Good communication skills Please provide a proposal with your experience in this field, and how you plan to source and verify the...

Looking for an expert in data visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can ...

Here is your rare opportunity to make Good Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision a...

I'm an entrep...O1 visa application and in need of a superb immigration lawyer with solid experience in this field. I need someone to help me understand the process, fill the forms and submit the necessary documents to the USCIS - Legal Assistance: Your primary task would be to assist with the complete O1 visa application process. - Lawyer Requirements: Please ensure you have: - Robust experience with O1 visa applications - A proven track record of positive outcomes - Familiarity with the unique considerations for entrepreneurs - Excellent communication skills The ideal candidate would not only have an intimate understanding of the O1 visa process, but also...

I am in need of a skilled 3D designer who can create a detailed design of a small commercial car workshop interior. Key Requirements: - The 3D design should accurately capture the layout and features of a small-sized car workshop. - As it is for a commercial area, the design should be practical, realistic and conducive to the operational needs of a car workshop. Ideal Skills and Experience: - Proficient in 3D design software (e.g., AutoCAD, SketchUp, Blender) - Experience in designing commercial or workshop interiors - Understanding of layout optimization in small spaces The successful freelancer will deliver a 3D model that can be used for visualization and planning purposes. This model should ...

I'm in the market for a skilled CAD designer who can bring my unique ring vision to life. The ideal candidate should have experience in jewellery design and a keen eye for detail. Only individuals with a portfolio showcasing intricate designs, particularly within the jewellery sector, will be considered. Key requirements for the job include: - Translating a custom theme into a CAD design - Creating a highly detailed piece with intricate textures and elements - Understanding of modern and emerging jewellery design trends I'm looking for a freelancer who can create a truly one-of-a-kind ring. This project is a fantastic opportunity for a creative mind with a passion for jewellery design.

...seeking a reliable partner to craft a dynamic metric that will effectively measure the success of our salespeople. The key performance indicators, KPIs, that we currently utilize include the number of sales closed, the revenue generated, the number of closed deals from created estimates, orders with specific shipping methods, and orders with designated items. Additionally, we perceive the consistent meeting or exceeding of sales targets and effective communication of our product's benefits and features as hallmarks of a successful salesperson. These factors will need to be integrated into the metric. Currently, we track and manage sales activities and performance using spreadsheets. Ideal candidate sho...

Create 2 buttons on Category Page that link to the existing Slider page and a new Listview Page that lists all the items in a collection (array) as a list with Title and Description underneath. Similar to the attached image.

I'm looking for a reliable individual based in Tokyo who can collect and send a medium-sized (1-5kg), non-fragile item to Australia. Key Responsibilities Include: - Pick-up item from a specified location in Tokyo - Secure item with protective wrapping - Dispatch to an address in Australia Ideal Candidate: - Must be based in Tokyo - Strong attention to detail, particularly regarding packaging and shipping procedures - Reliable and swift communication - Previous experience in courier services or shipping-related tasks would be beneficial.

...proficient translator to convert a technical document from English to Spanish. Key Requirements: - Understanding of technical language: The document contains technical jargon, so the translator must have experience in this field to accurately translate it into Spanish. - Attention to detail: It's critical that the translated document is error-free and retains the original meaning and terminology. - Fluency in English and Spanish: The translator must be fluent in both languages to ensure a high-quality translation. Ideal skills and experience: - Professional translator with a background in technical translations is preferred. - Experience in translating documents from E...

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

I'm looking for assistance with pre-employment vetting in Rouen, France. The pre-employment test that I want to conduct is employment-specific. This is crucial for me because I want to ensure the people I'm hiring are well-suited for their roles. Your role in this project will be to set up and conduct the test, and deliver a comprehensive report on each candidate's performance. Ideal freelancers for this project should have experience in pre-employment testing and a solid understanding of the specific requirements for employment. Please note that I haven't specified the field or industry for the employment opportunity. The test should be general enough to apply ...

...speechwriter who can help me craft an engaging and informative speech focused on radiology. The purpose of this speech is to inform a general public audience about the relevance and impact of radiology within the field of healthcare. Key Responsibilities: - Create a compelling narrative that explains the significance of radiology in a manner that is easily understood by a non-specialist audience. - Incorporate intriguing and relevant facts, statistics, and anecdotes to maintain audience engagement and understanding throughout the speech. - Ensure the speech is well-structured, with a clear introduction, body, and conclusion that effectively convey the message and key takeaways. Ideal Candidate: - Prov...

I'm in need of a skilled writer to compose a top-tier, 8-9 page essay in the field of Literature. The deadline for this project is within one week, specifically by Saturday morning 5/21. Key Responsibilities: - Composing an 8-9 page essay in a professional, high-level style - Deep understanding and knowledge of the Literature as a subject - Ability to meet the deadline of within one week - Delivering work that is well-researched, original and engaging Ideal Skills & Experience: - Proven track record in writing academic papers or essays - Excellent knowledge of Literature as a subject - Capability to meet tight deadlines without compromising on quality - Strong research skills and ...

...interior designer to completely transform my living room into a minimalist haven. My living room is less than 40 square mt and I am interested in a simple yet sophisticated aesthetic. Key tasks include: * Analyzing the current state of the room and suggesting improvements * Developing a new layout plan * Providing a minimalist design concept that maximizes available space Ideal Skills and Experience: * Proven experience in minimalist interior design * Portfolio of designs for comparable spaces * A deep understanding of space planning and functionality * Creativity and innovative approach in using small spaces effectively Your bid should include design plan, sourcing furnishings and accessories, and implementation oversight. The ro...

As an HR professional, I am looking to generate leads that will convert into sales or engagement for my company. Key Requirements: - I'm looking for a freelancer with tangible experience in generating leads in the HR industry. - Your application should showcase your past successes in this field. The primary goal is to increase sales and leads through this initiative, so I need someone with a proven track record of achieving this within the HR sector.

...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&#...

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.

The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a fo...

...managing a restaurant's operations. The UI should be user-friendly and ideally suited for a restaurant environment. Key Features: - Order Management: I need the UI to include order tracking and menu customization features. I also require the ability to visualize the restaurant's floor layout to manage the orders efficiently. - Table Management: The UI must allow for table reservations, status updates, and merging. It should help in optimizing table assignments and order efficiency. - Inventory Management: The UI should support managing the restaurant's inventory to streamline operations and track costs. - Staff Management: I need a simple way to manage s...

I am seeking a talented architect/interior designer to conceptualize a small capacity (up to 50 people) e-sport arena. This space should be multi-purpose, with areas for table top and card games, "video game tables", as well as adaptable space for B2B events or co-working. Key project elements: - The e-sport gaming area is the central focus. - A comfortable and homey interior design style is preferred. - Despite the diverse usage, the space should flow naturally and cohesively. - Incorporate dining areas where players can eat while engaging in video games. - The design should be flexible to also accommodate B2B events or transform into a co-working environment when needed. Ideal cand...

...experienced, talented individual to create an accurately measured floor plan based on a sketch, and perhaps 3d renderings if we align on the 2d. This project will require the inclusion of the following primary facilities: - 4-6 Treatment rooms - Sauna or steam area and day spa space - single-stall showers, changing areas, bathrooms - 1 yoga studio - Mixed use lounge with communal table, lounge area, and hidden AV - front desk - Spa Retail area - lockers - back office area for laundry, storage, and staff break If you have innovative and creative ideas beyond my sketch to further enhance the floor layout to attract more customers, they are more than welcome! You will be working closely with me to design a floor plan that tr...

I am looking for an experienced freelancer to conduct a detailed case study on the implementation of a Zero Trust architecture in the banking sector, analyzing the economic impact of this transition.

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

...freelance prop maker to design, 3D print, paint, sand, and assemble a custom armor and helmet. The ideal candidate will have a strong portfolio demonstrating expertise in creating detailed and high-quality wearable props, particularly for cosplay. Key Requirements: - Material: The armor and helmet need to be crafted from PETG (Polyethylene Terephthalate Glycol). Please ensure you are familiar with this material and have experience working with it. - Create detailed 3D models and renderings of the armor and helmet using 3D modeling software (e.g., Blender, ZBrush, CAD). - Apply professional-grade painting techniques to achieve the desired aesthetic, including base coats, detailing, and weathering effects. - Use airbrushing, han...

Are you a driven sales professional ready to take control of your income and achieve unparalleled success? Buzz Circuit Media is seeking highly motivated Sales Outreach Specialists to expand our client base for our social media management services. With our commission-only structure and powerful tools, you can unlock your earning potential and enjoy the benefits of recurring passive income. Compensation Structure: 10% commission on the monthly revenue generated by Tier 1 clients (client pays $199/month) 15% commission on the monthly revenue generated by Tier 2 clients (client pays $399/month) 20% commission on the monthly revenue generated by Tier 3 clients (client pays $599/month) Bonus Structure: $250 bonus when a client reach...

...consultant to work on an annual SEO project for a well-known small appliance brand in the United States, which is part of an international group. The website is an e-commerce site. This profile will work integrated into the SEO team for AMERICA that the client has formed, along with other management and technical members so that teamwork will be an essential condition. The project is a global project where each region has its strategy, but all must go hand in hand. The consultant will become part of our network of freelancers, with the possibility of participating in other projects for which a profile like theirs is sought. What do we offer? - The possibility of joining a multicultural team and workin...

I need two outdoor cooking tables based on the document specs provided. I am looking for scaled, cad drawings that can be given to the custom carpenters

I'm in need of a professional who can help overhaul my resume for a career advancement opportunity. The main focus is on improving the content and wording of the document and ensuring a more appealing formatting and layout. This resume will be used to apply for government jo bs. Key tasks include: - Restructuring the content to effectively showcase my skills and experiences - Enhancing the wording to be more impactful and professional - Designing a layout that is visually appealing and easy to navigate, while also adhering to industry standards Ideal candidates should have: - Proven experience in resume writing, particularly in the field of career advancement - Strong gras...

...experienced freelancer to develop new widgets for our current dashboard in 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 ...

Need to rectify observations in my report. I'm seeking a skilled SPSS expert capable of providing detailed descriptive statistics and an executive summary based on the data analysis. You'll need to incorporate both visual charts/graphs and a comprehensive written report to effectively communicate the results. Key requirements and skills: - Proficiency in SPSS software - Ability to perform thorough descriptive statistical analysis - Experience in creating visual charts/graphs - Strong report writing skills, particularly in delivering detailed analysis along with an executive summary. The successful applicant will need the ability to interpret data accurately and present findings in...

I'm in need of a CAD operator proficient in SolidWorks for creating detailed and polished designs based on sketches and images of site-measured cabinets and joinery. The intention is to utilize these drawings for quoting purposes with my clients. Key Requirements: - Proficiency in SolidWorks: As I specifically work with this software, it's crucial that you're well-versed in it. - Attention to Detail: The designs need to be detailed, including materials and finishes, so a meticulous eye for detail is necessary. - Understanding of Cabinetry and Joinery: Experience in this field would be a great asset as it will help you translate the provided sketches more accurately. Deliver...

Please read the content of the requirements - ONLY SPANISH SPEAKER I am seeking an experienced 360 marketing specialist for my social media platforms which include Facebook, Instagram, LinkedIn, and Twitter. The successful candidate will need to be a native Spanish speaker. To sell Point of sale For B2B sells of software Key responsibilities include: - Creating engaging and compelling content that will resonate with my target audience - Designing and implementing a comprehensive social media strategy aimed at driving sales - Creating and designing the Ads - Monitoring and analyzing metrics to ensure the effectiveness of campaigns

I am organizing a music festival - "Music on the Moor," which embraces a blend of classical chamber music and folk. I'm in need of an attention-grabbing logo that conveys our theme effectively. - Skill Requirement: You should be a skilled graphic designer with experience in creating logos for music festivals or similar events. - Festival Vibe: Our festival has a relaxed yet engaging environment. Your design should reflect this balance. - Palette: The color scheme should utilize earth tones such as browns, greens, and yellows. The logo should echo the friendly and warm atmosphere of the festival. - Originality: It is essential that the logo is unique and avoids clichés often associated with music festivals...

...experienced researcher to investigate retail displays in Xian, China. The project will specifically focus on Talens, a famous art supply brand. The research aims to provide insights into the following aspects: - Brands Available in Displays: The core of this project is to identify and analyze the presence and positioning of Talens within the retail space. - Competitor Analysis: While the primary focus is on Talens, it will be valuable to understand how other brands like Nike, Adidas, and Apple are being displayed in the retail outlets. - Customer Behavior: I'm particularly interested in how the retail displays are shaping customer behavior and purchase decisio...

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document. The job has to be completed in the next 12 hours.

Creating a comprehensive dashboard for our POS (Point of Sale) system involves several key components and technologies. Here’s a detailed outline of the project requirements and the ideal skills needed to build the solution: Project Overview The goal is to develop a dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales dat...

I need assistance with formatting a Word document. It is a 47 page word document that needs to be formatted in terms of look and feel. There are 4 table of contents in the document to be formatted and the page numbers of the document have to be fixed. There is a 13 page pdf that needs to be converted to Word and added to the document.