Spread sheet projectPekerjaan
I'm in need of an expert well-versed in managing data and creating formulas in Excel, as well as designing and creating interactive dashboards. Key Responsibilities: - Create excel sheet to test the reconciliation Manage data within Excel spreadsheets and CSV files - Create effective formulas within Excel - Design interactive dashboards using charts, graphs, tables and data grids Ideal Skills and Experience: - Advanced experience with Excel data management - Expert in creating Excel formulas - Proficient in designing interactive dashboards - Experience using charts, graphs, tables, and data grids - Knowledgeable about handling data from Excel spreadsheets and CSV files Your understanding of financial data and ability to present it in an engaging, visual way will be a key ...
i need to create KPIs for my reconciliation team in an excel sheet that is connected to a dashboard to show the results automatically. I have created a rough draft and i want to develop it. the second part of the project is analyzing the excel sheets they are reconciling each day and create a dashboard that also shows the results. the sheets aren't complicated. i have alot in my mind but i don't know how to make it applicable. i need to create some pivot tables and some formulas in excel to make it easier for reconciling.
I'm in urgent need of someone highly profici...proficient in Excel to filter my data and make one sheet. I have very specific data to be removed. This work will not take more than an hour for expert. IDEAL SKILLS: - Proven expertise in Excel and data management. - Strong experience with advanced functions and conditional formatting. - Capability to write and debug complex formulas. - Bonus: Experience with VBA for potential automation. EXPERIENCE REQUIREMENTS: - Previous projects involving large databases in Excel. - Strong analytical skills with attention to detail. - Efficient and clear communication throughout the project development. I skipped the criteria specifics, but I look for flexibility in approach. Please share your relevant experience and how you would ...
DELIVERABLES Power BI file ADDITIONAL INFORMATION I need a quick Power Bi analysis - basically I am trying to filter this attached csv to identify the Root AND Basename of the files that are (each analysis should be on its own sheet): ARE really OLD (i.e. the 'Created' date is far in the past) Are really OLD AND have not been Accessed recently (i.e. in this case - the 'Created' date is far in the past AND the 'Accessed' date is either EQUAL to the 'Created' date AND/OR it is also far in the past) and ARE really OLD + Have not been Accessed recently and ARE SORTED by SIZE (the bigger number). I have attached a example graphic of a chart that I think would work for these 3 analysis. Specifically, I think maybe a chart something like this might...
...live auction platform. Here's what I need specifically: - Real-time bidding system allowing immediate bid updates. - Comprehensive item catalog with detailed descriptions for each auction item. - A functional bid history tracking for participants. - A live countdown timer for auction urgency. - Platform manageable for less than 500 bidders and 500 items. Key features based on a detailed spec sheet will be provided. The site should be able to handle manual entry of items by an admin. Ideal Freelancer Qualities: - Proficiency in developing custom web platforms (or a hybrid withWordpress). - Experience with real-time web technologies (e.g., WebSockets). - Skilled in database management for inventory and bidding data. - Understanding of creating user-friendly interfaces and ...
...are seeking a highly skilled and experienced web scraper to undertake a complex project involving scraping a specific website for detailed product information. This project will be divided into two phases and requires the development of a comprehensive Intranet site to manage and parse the scraped data effectively. Project Overview: Initial Requirement: Conduct a feasibility study before starting the project. Successful completion will lead to future collaboration opportunities. Expertise Demanded: Applicants must demonstrate their expertise with samples of previous work. The quality and efficiency of the code will be rigorously tested. Phase 1: Data Scraping and Database Integration Input: Read an Excel sheet listing products. Target Website: Navig...
I'm looking for an adept financial analyst with an expertise in preparing financial statements, particularly income statements and balance sheets. To be more specific, the task involves: - Summarizing 10 transactions. - Preparing an income statement for February, 2019. - Creating a balance sheet as of January 31, 2019. - Preparing a comparative balance sheet as of February 28, 2019. All necessary transaction details for the task are available and ready for analysis. The ideal freelancer for this job should: - Display a strong background in financial statement preparation and analysis. - Demonstrate sharp attention to detail. - Be proficient in the use of Excel since the final documents should be delivered in this format. This opportunity is perfect for individuals s...
We are on the lookout for a skilled hashtag#ZohoBooks expert to conduct 3-4 training sessions for our dynamic accounts team. Our focus is on elevating our bookkeeping game and mastering compliance sheet management through Zoho Books. What we're looking for: - Practical insights on Zoho Books functionalities. - Best practices for efficient bookkeeping. - Compliance sheet management tips and tricks. Details: - 3-4 sessions tailored for hands-on learning. - Your proposed agenda and topics. - Your availability.
I'm seeking someone with high attention to detail who can meticulously organize my disparate, varied PDFs of historical blood and health results into a sorted Excel sheet. Key Responsibilities: - Extraction of data from different PDF formats - Data entry into an Excel file - Organisation of data by Test Type Data to Include for Each Test: - Test Name - Date - Test Result - Reference Range Ideal Skills and Experience: The ideal freelancer for this project should have: - Exceptional skills in data extraction and data entry - Experience with PDF conversion to excel - Advanced skills in Excel file organization - Background in health or related data would be beneficial.
I need Sales qulaified web design leads through email outreach From INDIA only. We need intrsted candidate who are looking for web design service. We are intrested in the niche Astrologers, Realesate, Event Company, eCommerce etc. Atleast 3 to 5 emmail outreach should be done to warm up the cold lead. lea...design leads through email outreach From INDIA only. We need intrsted candidate who are looking for web design service. We are intrested in the niche Astrologers, Realesate, Event Company, eCommerce etc. Atleast 3 to 5 emmail outreach should be done to warm up the cold lead. leads Count atleast 100 intrested leads who are having interest in web design for their business. Need a downloadable excel sheet in which their business name, Mobile nummber, email and their owners name...
I need a quick, insightful, and dedicated researcher skilled in delving into Google Scholar. Your task will be to gather material mainly. I will give you an excel sheet with list of publications and your task is to fill the table with missing values such as Author, Year, Publication Type (Journal, Conference) etc. The ideal candidate has a keen eye for detail, strong researching skills, and should be able to deliver the work ASAP. Candidates with a background in Machine Learning or MLOps will be highly prioritized. Please bring along your previous work samples. Feel free to place your bid if you can comply swiftly to the project’s urgency.
I need an Excel spreadsheet designed to meticulously track my finances. It should include three main sections to monitor: - Income and expenses - Assets and liabilities - Sales and purchases The sheet should be capable of automatically calculating the sum of total income, total expenses and also the income minus expenses for quick financial analysis. It's paramount for me that the spreadsheet design is professional and minimalistic, providing clarity and ease of use without unnecessary distractions. In terms of skills, a full understanding of Excel formulas and the fundamentals of accounting are essential. The ability to create professional designs within Excel would also be highly valued. Previous experience in finance or accounting related projects would be advantageous.
I’m in need of a freelancer for a data entry task. Your main responsibility will be to enter numerical data into an Excel sheet with high accuracy and efficiency. No analysis of the data is expected after entry. Here's what you'll do: - Input numerical data accurately - Ensure no data failure or inconsistency - Final output to be delivered in Excel Workbook format Ideal skills and experience: - Previous data entry experience - Proficient in MS Excel - High attention to detail - Solid understanding of data confidentiality principles - Good typing speed and accuracy.
...Migrate income statement, balance sheet, and cash flow statement data. - Data is ready in Tally/Excel format. - Perform basic categorization of income/expenses. **Ideal Candidate:** - Proficient with QuickBooks online. - Experience with accounting data entry. - Understanding of financial statements. - Ability to manage time effectively to meet the one-week deadline. **Objective:** - Ensure data is accurately reflected in QuickBooks. - Prepare for upcoming audit by having P&L and Balance Sheet readily available. **What You'll Deliver:** - Complete transfer of financial data to QuickBooks. - Verification of data accuracy post-migration. - A report summarizing the data uploaded and any potential discrepancies. If you have the necessary skills to complete this ...
...customer a tablet instead of a piece of paper and they will fill out the form and sign it as well with their signature (with their finger). The information will then be saved into a google sheet where I can run reports on the data. I have a basic google sheet/google form that does most of this but I want more customization. The current information will be imported so its not lost. Also key features will be emailing a copy to the customer under certain circumstances, emailing our review department a copy of the form filled out. Not all fields for security reasons will be emailed. The current google sheet/form will be used as the foundation so it will be easy to copy over the data. I would like the application to also run on a computer (example windows tablet). It c...
...estimating about 8 hours of work in total. Here's what the project entails: - Converting data from PDF into Excel spreadsheets - Ensuring accuracy while inputting the information - Some interpretation of data based on rules I will provide you It is critical you possess a keen eye for detail, to confirm you are able to understand and complete what is required I am asking you to complete a small trial which should take up to 5 minutes. I have posted three files with this job: - Example - Data - - Trial - I have entered the Example timesheet in the excel file. If you could enter the "Trial - entry" timesheet in the same format and post the excel file with your submission. The example sheet has highlighted the sections the data is to come from
...financial modeler to craft a robust Excel model with the following key components: - **Income Statement** - **Balance Sheet** - **Cash Flow Statement** These statements should reflect: - Annual figures - Incorporation of both historical data and future projections Ideal candidate qualifications: - Strong background in finance or accounting - Advanced Excel skills including formulas, pivot tables, and charts - Experience with financial analysis and modeling - Keen attention to detail and accuracy - Ability to interpret historical financial data - Proficiency in forecasting and creating financial scenarios What I expect: - A clear, easy-to-understand model - Assumptions sheet for projections - Dashboard with financial summary and key metrics - Charts/graphs for visual...
...discussion. - Create a safe and supportive environment for confidence building. Requirements: - Strong understanding of bullying issues faced by the age group. - Ability to design and implement creative and engaging activities. Skills: - Strong skills in creating interactive content and group management. Results: Detailed Outline about each day of the workshops including: - Table of Contents Daily: - Sheet with activities (games) - Topics and contents to be discussed - prepared documents for activities ready for printing if needed - etc. I need a finished workshop outline so that i can start teaching. This opportunity is perfect for someone passionate about empowering youth and experienced in delivering meaningful educational experiences. If you have a background in education...
...apartment block to life. The task will involve delivering concept designs and a 3D render that embody the sophistication of modern architecture. Key Project Requirements: - Create initial concept plans for a modern-style apartment block - Develop a 3D render of the concept Project summary: - Incorporate 4-bedrooms, 4 bathrooms, laundry, study, media room, health retreat (sauna and spa), and pool (infinity edge on balcony) into each unit design - Ensure each apartment covers 400m2 (including balcony / alfresco & pool space), with a total site coverage of 59% on a 689m2 block - one per floor apartment across 4 levels with the penthouse spread across 2 levels - 5 level building total plus basement carparking Ideal Freelancer Skills: - Proficiency in architectura...
I'm seeking an experienced Microsoft 365 Powerapps developer to help streamline operations in my team. With direct Excel sheet editing proving troublesome, I need a robust solution that ensures data integrity and boasts comprehensive reporting features. Key functionalities include: - Data capture forms: These need to be adept at capturing various types of data - including text, numbers, dates, currency, and time inputs. - Excel sheet replacement: I need the data capture process to substitute our direct Excel sheet editing procedures accurately and seamlessly. -Custom Reports and Analytics: The application should focus on product type, income channels, locations, customers, and calculated values. This directive demands a developer well-versed with transf...
I would like a CSV/Excel file of 500 vodka companies ( or ). I want a email of a contact at the company, like CEO. I want three column sheet with company name, contact email, and contact name.
I would like a CSV/Excel file of 500 sports nutrition companies ( or ). I want a email of a contact at the company, like CEO. I want three column sheet with company name, contact email, and contact name.
I need an Excel whiz for crafting smart, user-friendly macros and buttons that'll simplify my workflow. Here's what I envision: - Automating the insertion of a new row at the top of my sheet, each with a sequential number. - Ensuring this process is neatly formatted and aligns with the sheet's existing style for consistency and professionalism. For this task, a freelancer with the following qualifications would be ideal: - Strong Excel macro programming skills, preferably with VBA expertise. - Proven experience with Excel's formatting functions, ensuring neat and efficient automation. - Ability to work quickly and accurately, delivering a solution that's both effective and user-friendly. I'm aiming for a straightforward, easy-to-use system that make...
Greetings from BROS Translation! I hope you are doing well. We are looking for colleagues who can translate from Arabic to Kurdish Sorani (Iraq). This project will have a large volume. We may use the SmartCat translation platform (we will send invitations) for you to see and implement the repetitions quickly and to have more consistence translation. (Or we may use Excel sheet, this will be decided.) We are planning to start this week as soon as the client approves the project. The subject is cosmetic product descriptions. Please let us know as soon as possible if you are available for this potential project. Thank you in advance!
I'm seeking a meticulous individual to adjust a series of misaligned dates within an existing Excel sheet. The project requires attention to detail and proficiency in Excel. The successful freelancer will be responsible for correcting 1500 dates to follow a DD/MM/YYYY format based on recognizable patterns. **Key Tasks:** - Correct 1500 dates in the current Excel sheet. - Ensure dates follow the DD/MM/YYYY format. - Identify and correct months and days using logical patterns (e.g., month never over 12). **Skills Required:** - Advanced Excel knowledge. - Strong attention to detail. - Ability to follow patterns and logical rules. **Experience Needed:** - Proven experience with similar data correction tasks. - Prior work involving large datasets in Excel is idea...
I’m looking for a resourceful developer to create an innovative Chrome extension tailored for efficiency. - Extension Purpose: Generate a spec sheet link and download it as PDF and Word documents—excluding item prices and source details. - Key Features: - One-click functionality. - Automatic file naming based on product name. - Inclusion of product name, description, technical specs, product images, and additional information. - Requirements: - Proficiency in Chrome extension development. - Familiarity with JavaScript, HTML, CSS. - Experience in PDF and Word API integration. - Ability to manipulate DOM to extract specified content. - Knowledge in file generation and download without server-side dependence. - The extension price is $1 per month for use...
...all my expenses and income in a simple and easy to understand schedule I will contact him daily to tell him my expenses and income I will need to know what is my monthly budget How much income and expenses i need to know for the next months How much im spending We will start gathering all the information from my side up then i will tell him daily my expenses and income. I need in my excel sheet to be delivered for my real estate business just to double check what i will give him other accountant in regards of income only. my car business how much each car cost me and what is my profit divided in % for some cars as some cars i have partners in them. All my personal expense, on my kid, Wife, ordering out and all this. budgeting for big expenses This will be a long job i wi...
I am looking for a skilled developer with expertise in Laravel and PHP platforms to create a unique website for my business. The website should have flexible server access subscription functionality. Details: - Develop a page on existing website . - Implement a serve...month. Total price will be display In next line in bold. Requirements comment box keep as it's. CHECKOUT BUTTON WILL DISPLAY Customer will proceed for payment. you can add this checkout to existing payment gateway it should work for domestic and internation payment. Payment test successfully will be done by developer Server access customer data that should be store in admin site in excel sheet. WE ALREADY HAVE EXISTING BACKEND WHERE YOU CAN WORK. Please visit website for server access menu
As a business owner, I am seeking an accountant and/ or a bookkeeper who can assist me in crafting a meticulously detailed three-way budget template. I need a tool that will allow me to effectively manage and oversee my company's finances. Key Aspects: - The template should include an income statement, balance sheet and a cash flow statement. Each of these statements is critical in comprehending the financial position of my business. - I would prefer a template which provides a monthly breakdown of the data. This would allow for a more thorough analysis and management of my company’s finances over time. Ideal Candidate: - An experienced accountant or bookkeeper, - Familiar with Microsoft Excel and financial management, - Has previously developed or used three-way budget...
I need to send data entered by website visitor in Wix Website to specific cell in google sheet and fetch calculated value from google sheet and display it. (Pls mentione code 4+5 = ? response to start conversation. Check this website link and gsheet link Both input values and fetched value need to be stored in a Wix CM. Project delivery: 1. once complete we will test the values are posted and fetech properly 2. you need to provide us integration steps in a document or video record 3. once we are able to follow the guide we will release the milestone
I seek a dedicated professional to build an email parser that unceasingly operates on my web server. The software should be designed to monitor my Gmail inbox closely, tri...include: - Keyword Recognition: It must be programmed to recognize a particular subject in each email. - Data Extraction: Upon the identification of the unique subject, the parser should extract certain information - email addresses, names, and specific prize values embedded within the content. - Google Sheets integration: The extracted data should then be systematically added to a designated Google Sheet. Practical experience in parsing emails and excellent knowledge of Google Sheets API will be a plus. Interested candidates should also possess strong communication skills for seamless collaboration and troubl...
I am looking for a PowerShell expert to assist with a unique project. The objective is to automate the process of importing query results from an SQL database into Excel. Further requirements include: - Applying column filters to the raw data. - Constructing a pivot table with the imported and filtered data. - Finally, embedding a snapshot of the generated pivot table into the body of an email. The freelancer must have a solid understanding of PowerShell programming and SQL databases. They should be proficient at manipulating data with Excel and using email generation modules in PowerShell. Familiarity with SQL query writing is essential since the process revolves around accurate results. An ideal candidate would be someone who is detail-oriented and can determine appropriate filt...
I require a seasoned Excel wizard to create an intricate spreadsheet for me. My necessity involves handling both text and date/time data. The optimal organization for this data on the sheet would be a mixture of columns and rows. Hence, understanding the context and logic in data placement is key. Additionally, the project would extensively require text and string operations. Ideal candidates should be familiar with various string-related functions such as LEN, RIGHT, LEFT, MID, SUBSTITUTE, and REPT, among others. Your proposal should clearly mention previous similar projects you've undertaken. An understanding of VBA to create customized functions would be a bonus, but is not a compulsory requirement. Parametres Each entry has 2 lessons that must be one hour apart (i...
I am seeking an artistic individual to create moderately detailed outlines of two images of our pub. The final pie...individual to create moderately detailed outlines of two images of our pub. The final pieces should capture not only the building itself but also the surrounding landscape. This project will eventually become colouring sheets for children, so a background in kid-friendly designs would be ideal. Please note your experience in graphics design, illustration, or drawing would be valuable for this task as well. You will need to provide your final design in PDF format. Familiarity with various digital formats is an important part of this project. If interested, please submit proof of previous completed colouring sheet design or similar work. Looking forward ...
I'm looking for some help modeling 40+ models of AC and Heating products. These models need to be visually accurate from the exterior only. The models should be modeled with sheet metal and solid shapes. The models will be AC Condensers, Furnaces, air handlers, and a couple other misc. items. The timeline is pretty tight so these will need to be done quick but clean!!! Please hit me up if you're interested. I'll want to see samples of your work. It's all about the details. I will be providing assets to be used as reference showing each side of the models. Thanks. Tom
In this project, I need a proficient form builder expert other who can effectively craft a special online form for my business. Key Features: * The form should be based on templates. There will be 3 tempate in total. However, the customer should be able to specify which template they prefer to use. Creativity and attention to detail will be crucial in executing this. * The form should also entail drop-down menus for ease of navigation and user fillable fields to enhance user-friendliness. Menus must be database driven with ability to import table data from an excel spread sheet or be edited manually. Add the word " I RED " to your initial reply so I know you really read this info. Menus should be sortable / searchable. Purpose: The maj...
I am looking for someone to make a service sheet better than the one we already have and also give us a way to edit it if needed
I'm seeking a highly-skilled developer adept in handling HTML formulas within Google Sheets for a unique project. Here's what I need: - Embed HTML formulas within a Google Sheet: I need you to efficiently embed HTML formulas inside a Google Sheet. - Purpose: The primary purpose of this project is to gather key data automatically from external web sources. - External Sources Information Accumulation: The important component of this task is website data scraping. The ideal candidate for this job should have ample experience in Google Sheets, and specifically in website data scraping. A strong background in automation will be highly appreciated as the project requires gathering information automatically from various websites. It's a pl...
Task includes: - Formulas to filter up sub total costs and revenue to the months along the top row - Formula to calculate end date based on start date, duration and change in schedule More items will be added, if required.
Silakan Daftar atau Login tuntuk melihat rincian.
I'm looking for an expert in Google Sheets to assist in constructing formulas and functions, along with conditional formatting and data visualization. The specific tasks require advanced knowledge of SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, and INDEX-MATCH functions, paired with expertise in color-based formatting, data bars, and icon sets. The ultimate goal of the project is to replicate a website calculator into a Google Sheet. Proficiency in creating interactive and visually appealing spreadsheets will be beneficial. Would prefer someone with experience in similar projects. Efficiency, skills, and attention to detail are a must.
I need an experienced commercial architect to help with the design of a small office building, less than 1,000 sq. ft. in size. Key responsibilities: - Conceptualizing, designing, and planning the office space layout. -Sheet 1: Create plan views sheet for layout of (2) offices, (1) conference room, (1) Storage area. -Sheet 2: Reflective lighting and outlets on a second sheet. - No building permit, this is a double wide trailer, just need to ensure we are following code. -We have a conceptual layout drawn up, just need to clean it up and draw to scale. Ideal skills and experiences: - Extensive experience in small-scale commercial projects - Proficient in using architecture software - Knowledge of building codes & regulations - Prior work on offi...
I am in need of some help for an Excel file. What I am looking is when the date month changes in column F, that row data is pulled to another sheet that is the corresponding month. E.g. Cell F3 says 13 Dec 2024 - all that row B3
I am seeking a professional with exceptional data entry skills along with a working knowledge of Optical Character Recognition (OCR) technologies. • Your core responsibility will be handling the manual and automa...Recognition (OCR) technologies. • Your core responsibility will be handling the manual and automated input of both textual and image data. • The data will originate from physical documents that I will provide. You can categorize, process, and digitize this information using a combination of manual input and OCR tech. • Proficiency with OCR technologies will be an advantage as part of this project involves converting hardcopy material into digital formats. Experience in undertaking similar projects and an ability to maintain stringent confident...
I am in need of Sample bookkeeping samples for my creating my online portfolio. Samples of balance sheet, cashflow, invoice, trial balance and profit and loss in excell.
This is the Google sheet I need help with: The table in the sheet describes decay time for different tissues. In column A there are different percentage levels of interest. In column B to E there are the decayl times for different tissues. The numbers in column B to E represents the time it takes for each tissue to reach a certain level of percentual decay. For example fat in column B: after 0 ms the decay is 100% (no decay), it takes 23 ms for the decay to reach 75%, 56 ms for the decay to reach 50% and so on. I would like to make a line chart in google sheets of this table, where the percentage levels of interest in column A are on the y axis, and where the x axis is time in ms
2 extra fields SDI and PEC are written in the customer card with the registration of the new customer, I would like these fields to also be visible in the order and to be sent in the order email, print the order on a single sheet of paper
I'm in need of a freelancer who could help...reference part number from a locally installed program. The extracted information will have to be plain text, ready to be pasted onto a Google Sheet. Knowledge in working with locally installed programs and familiarity with Google Sheets is preferred. High attention to detail is a must. Experience in data extraction will be preferred. The successful candidate would have: - Proven experience with data extraction - Proficiency in Google Sheets - Attention to detail - Familiarity with locally installed program data retrieval - Excellent organizational skills to handle large amounts of data. Please bid, only if you are confident about this. The project requires precision and punctuality. The correct and organized data is the utm...
Seeking a seasoned data scraper to help gather text content from box scores of previous NBA games and organize it on...a seasoned data scraper to help gather text content from box scores of previous NBA games and organize it onto an excel sheet. Visit NBA website, check previous games starting from Dec 1 2016. 6 games per day, click “box scores” and scrape data from the tables of both teams. Players, scores, totals etc Have the tables be copied to excel exactly as pictured. Include the team name and date as well. Move on to the next game of that day until all are finished, then move on to the next day, rinse repeat. Key tasks may include: * Source and compile data from an unknown webpage * Scrape only the text content * Organize, format and update this data i...
