Spreadsheet formulas list jobber
!21740&authkey=!AFVz5FB1wpmcxOE&ithint=folder%2cdocx Budget $40 For this project is creating a Front End and Back End MS Access Database that will hold Historical Data also The First Form will have two butto...Historical Data also The First Form will have two buttons on it 1. One Button Titled MARS 2. Second Button Titled PSB Creating the MARS Form 3. This form will need to look and act identical to the ****_Call_Audit_Score_Card Creating the PSB Form 4. This form will need to look and act like the *** Call Score Form ***Please take time to review the excel spread sheet with hidden tabs formulas and VBA !21740&authkey=!AFVz5FB1wpmcxOE&ithint=folder%2cdocx
data entry in a spread sheet proper given database
Looking for database Need database in excel format
I'm looking for a skilled individual to develop a custom Google script spreadsheet to cater for my company's specific needs in the area of sure betting/matched betting and accounting functionality. This project is of high significance and is strictly for in-house usage. Ideal Spreadsheet Functions: - Sure betting/matched betting analysis: Essential for calculating sure bets and providing comprehensive insights. - Accounting functions: Streamlined tracking of profits, bets, balances and expenses. - Identity management: Essential for identifying our partners, keeping track of their ownership share based on gain, withdrawals, and deposits to the company. - Sequential betting tracking: We would need this for a detailed record of sequential bets. We can explain further...
I'm in need of a proficient data entry specialist to assist with a substantial volume of data entry work. This is a very basic task, a lead scraping website doesn't allow me to export data. So we will copy and paste from one website to a google sheet. There are 2,241 entries needed This project will take ~20 hours I am attaching a screenshot of the picture of the website and of the spreadsheet
Hello I need an experienced programmer willing to take a project that requires attention to detail and precise understanding of the subject matter. I can give extensive details about the ideal functioning of the spreadsheet I need done, however, this is an overwview: Track all gross/net profits track all account balances track all bank balances track all ongoing and completed bets on each account track across futile types of bet single and sequenced (this will require custom logic) as well as more basic things. im looking of a single place for everything to happen and for the right person to create it. No work will need to be done with external API this is only an internal management and accounting system.
...experienced Python programmer to design a program that analyzes the data from 7-8 spreadsheets and generates a discrepancy report. The project will require: - Strong proficiency in Python - Expertise in data visualization - Ability to compare categories within a large dataset - Comprehension of CSV format Specifically, the core functions of this Python program should include: - Analyzing spreadsheet data - Comparing various categories - Visualizing these comparisons to spot discrepancies - Exporting the results in CSV file format Ideal candidates should have extensive programming experience, particularly in the field of data analysis, and be able to demonstrate a solid understanding of data visualization techniques. They should also be familiar with handling large datas...
I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a...ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...
I'm looking for proficient freelancers who can effectively input both text and numerical data into Excel from physical documents. The task does not require any formulas or calculations, but attention to detail is crucial to ensure the accuracy of data. Key tasks include: - Manual entry of text and numbers from physical documents into Excel - Ensuring accurate data entry and quality checks Ideal freelancers should: - Have experience in data entry tasks, particularly with Excel - Be detail-oriented to ensure accuracy - Have strong organizational and time management skills.
I need a meticulous data entry professional to help me convert printed documents into a digital spreadsheet with the utmost accuracy. Key responsibilities include: - Typing data from printed documents into a spreadsheet - Ensuring that the data is entered with a very high level of accuracy. To be a successful candidate for this project, you should have experience in high-accuracy data entry. Previous work in a legal or scientific setting would be highly preferred. You should be detail-oriented and skilled in data entry. Your goal will be to ensure that the information is accurately transcribed and organized into the digital format. If you're confident in your skills and can guarantee a very high level of accuracy, I'd like to hear from you.
...can help me with applying conditional formatting and creating complex formulas that involve multiple conditions. Please watch this video for what i need Key Requirements: - Applying Conditional Formatting: The Excel file will require conditional formatting to visually represent data based on specific criteria. - Creating Complex Formulas: The project includes creating formulas that are not limited to basic arithmetic, and instead, involve multiple conditions. Ideal Skills and Experience: - Proven expertise in Excel: The ideal candidate should have a strong background in working with Excel and creating complex formulas. - Understanding of Conditional Formatting: A good grasp of how to apply
I need an Excel expert to overhaul my current worksheet. Key needs include formula adjustments, data validation updates, and creating an interactive dashboard. The dashboard should boast the ability for graphical data representation, specifically bar charts, and customizable filters to view data from multiple p...Excel expert to overhaul my current worksheet. Key needs include formula adjustments, data validation updates, and creating an interactive dashboard. The dashboard should boast the ability for graphical data representation, specifically bar charts, and customizable filters to view data from multiple perspectives. The right candidate will have extensive experience in Excel, knowledge of advanced formulas, data validation techniques and be proficient in creating interactive d...
When replying, reply with the text: "Forensic 4 Project" to be filtered from bot... 7) If you have any experience in working in Singapore financial projects do highlight those as well. 8) What do you understand of the SIBOR / SOR / LIBOR scandal and how could it have affected borrowers? Work scope: Go through letter of offers and loan statements, find the faults, calculate the excess paid, calculate damages All works should be done in Google Sheets or Microsoft Excel with formulas to prevent any calculation errors. Your output should clearly show what was charged, what should have been charged, difference and damages. Need someone who has a decent amount of time available, if you do not have alot of time to spare, this may not be ideal as this will take some time to co...
I need a dedicated professional to assist with a crucial data entry project. The work involves: - Encoding textual data sourced from digital documents. - Delivering accurately encoded data into an Excel spreadsheet. This task requires keen attention to detail to ensure the absolute accuracy of the data entry. The ideal candidate must have extensive experience handling textual data and an aptitude for meticulous data entry work. Proficiency in Excel and working with digital documents is also vital.
I require a highly skilled professional to assist with a range of tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. ...
I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets
I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: - Develo...extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right f...
I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Queensland's mining industry would be a plus.
...me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confident in your Excel skills and understand the nuances of dynamic formulas...
I'm in need of a professional who can provide me with a comprehensive list of international donors, specifically targeting individual donors,Not for profit organisations,and corporate sponsors. This list will be instrumental in supporting my fundraising efforts for disaster relief. Key Tasks: - Compiled list of international donors who are known for their philanthropic activities in disaster relief. - Include contact information (email, phone numbers, etc.) for each entry. - Ensure the list is up-to-date and relevant. Ideal Skills and Experience: - Proven track record in fundraising and donor research, preferably in the disaster relief sector. - Strong understanding of the nuances of individual donor engagement. - Excellent research and database managemen...
I need a professional data entry specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. ...
I need a professional data entry specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. ...
I am seeking a developer proficient in Microsoft Visual Studio 2019 with deep understanding of DAX formulas and tabular model building. My project involves developing complex measures in a data model with multiple related tables. Key Responsibilities: - Utilize Microsoft Visual Studio 2019 to create advanced DAX formulas for complex measures within our tabular model. - Implement solutions that cater to our multi-dimensional data model, which involves multiple related tables. - Ensure the performance and efficiency of the tabular model through well-structured DAX formulas. Ideal Candidate: - Proficient in Microsoft Visual Studio 2019, and specifically in DAX formula creation and tabular model development. - Previous experience working on complex data models with multi...
...the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the document accurately reflects the data input - Experience working with templates and photo embedding would be a plus. Please bid if you have the appropriate skills and experience to deliver a high-quality, automate...
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next 2 days...
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...
We are academic researchers interested studying visit patterns to Museums, Aquariums, and Zoos, in the United States. We are seeking assistance in collecting reported visit counts for the year 2019 from 500 museums, 100 zoos, and 100 aquariums across the United States. We will send you an excel spreadsheet with the name and state of each location we would like visits counts for. Note that these ~700 locations have been pre-selected. Task: - Search the internet for reported visits to each location in 2019 - If you can find the number of visits, please enter that number in the "visits" column AND paste the link to the website / source from which you obtained that number in the "link" column - If you cannot find an official reported figure for 2019 after som...
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share with you upon commencement of the project. 2. Car Make & Model List: - The second spreadsheet requires the creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should ...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I'm in need of a coding solution that can help me keep my email list up to date on an ongoing basis for my membership. I currently use Circle and FloDesk. The issue lies in the fact that Zapier, which I currently use for automation, cannot maintain tags when members unsubscribe. Key Job Requirements: - Integration: The coding solution should be able to synchronize and interact with my Circle and FloDesk accounts in real-time. - Real-Time Updating: The email list needs to be updated continuously as members subscribe and unsubscribe. - Unsubscribed Members: The specific action that should trigger an update is when a member unsubscribes. This action should be reflected in the email list promptly. Appropriate Skills: - Proficient in coding and experienced in work...
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all th...
I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets...Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the nec...
I need a professional who can scrape and compile email lists of high net worth individuals with a particular income level and investment interests. The emails will be used to target our automated trading software of...trading software offer. Key Requirements: - Income Level Criteria: The emails should target individuals with an income level within the range of $250,000 - $500,000. - Investment Interests: The targeted individuals should have an interest in the stock market, Futures trading, options trading, cryptocurrency, and real estate. Ideal Skills and Experience: - Proficiency in data scraping and email list compilation. - Familiarity with targeting high net worth individuals and their investment interests. - Previous experience in compiling email lists for targeted marketing ...
...savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive spreadsheet featuring specific MLB data. Essential parts of this data include game statistics, player performance, and team standings. The spreadsheet should be organized in a user-friendly way as mentioned below: 1. Date Range: The spreadsheet must cover a specified date range, which I'll provide upon hiring. 2. Included Players/Teams: The spreadsheet should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on wh...
I am seeking a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in pr...numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization will be a key ...
Vennligst Registrer deg eller Logg inn for å se detaljer.
I'm looking for someone with Google App Script expertise to help me automate tasks ...Generating Reports from Google Sheets Data: - The script should be able to pull specific data from my Google Sheets and generate reports automatically. 2. Sending Automated Emails based on Conditions: - I need the script to send out emails based on specific conditions. For example, if a certain cell in a Google Sheet reaches a certain value, an email should be triggered. 3. Updating Spreadsheet Data based on Email Responses: - The script should be able to read emails and update the corresponding Google Sheet based on the content of the email. Please provide examples of similar projects you have worked on in the past. I'd love to see how you've approached similar automatio...
...waiting list for me. The key purpose of this list is to manage customer demand. Key Requirements: - Prefer customers to join the waiting list via a website form. The form should be intuitive and easy to use. - When customers join the waiting list, I would like to collect their Name, Email address, and Phone number. I am looking for a skilled developer who can create a seamless and easy-to-use waiting list. The ideal candidate should have experience in: - Web development with proficiency in building forms - Understanding of customer data collection and management - Prior experience in creating waiting lists is a plus Please provide examples of similar projects you have worked on in the past. Thank you. As well as the above I am starting a new com...
I'm looking for someone with proficient data entry skills and bonus if they have unique formatting capabilities. The task concerns entering text data into a spreadsheet software. Although I don't have a specific format or template, creativity and organization are welcome. Key skills include: - Data entry - Familiarity with spreadsheet software - Excellent attention to detail - Ability to select a clear, logical format While previous experience in data entry is preferred, it's not essential as long as you're ready to take on this task with maximum precision. If you believe you're the right fit, I'd love to hear your approach on how you would tackle this particular project. Let's create a well-structured data paradigm together.
I am looking for a data scraper to extract information from the JazzCash agent locator list available on their website (). Key Requirements: - I need the data to be delivered in an Excel spreadsheet format. - The specific details that I require for each Jazz locator are the Name and Address, along with the Services offered. - The scraping needs to be done only once; it will not be recurring. Ideal Skills and Experience: - Proficiency in web scraping, particularly using tools like Python's Beautiful Soup or Scrapy. - Experience in extracting data from websites with dynamic content. - Strong attention to detail to ensure accurate data extraction. - Previous experience with similar data scraping projects will be an advantage. I am particularly interested
I require a professional data scraper to scrape multiple websites. Key tasks include: - No limitation on type of data scraped as this was not specified. - Scraping must be done across multiple websites, specifics will be provided upon project commencement. - All data should be delivered in Excel spreadsheet format. Ideal skills and experience: - Prior experience in web scraping across multiple diverse websites. - Proficient in using different scraping tools. - Strong understanding of Excel and data parsing. - Attention to detail and commitment to high quality, error-free work.
As a real estate investor based in the USA, I'm in search of an intermediate-level cold caller who can help expand my business operations. I need someone to contact 103 given individuals, secure their interest about selling their homes, and update the same in an Excel spreadsheet. Key Requirements: - Prior experience in real estate cold calling - Skilled at telephone communication - High attention to detail for note-taking during calls - Ability to ignite interest in property owners about selling The focus during each call should primarily revolve around gauging the property owner's interest in selling their home. Information about the property or pricing doesn't need to be discussed. I expect the freelancer to adapt to the flow of the conversation, as I do not have...
I am in need of an administrative assistant who can help with data entry tasks, particularly in managing spreadsheets. The ideal candidate should: - Have experience in data entry, specifically managing spreadsheets. - Be able to update and manage data efficiently and accurately. - Assist in additional admin tasks as needed.
I need a comprehensive android-based cheat sheet that includes all necessary oilfield formulas for drilling, production and well control. Key Features: - I would like to have drilling formulas such as Weight on Bit, Rotary Speed and Mud Pump Output. This will make it easier for me to perform drilling related calculations on the go. - The production formulas should be included as well, to help me with my production related calculations. - The cheat sheet should also have well control formulas. This will help me make important calculations in case of an emergency. My Requirement: - I need this cheat sheet to be user-friendly. This will allow me to plug in numbers easily and have the app compute the results seamlessly. Ideal Skills: - Android development - Oil...
...proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding of GP indicators and cost price calculations is a plus. I am looking for a de...
