Excel sheet formulaроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Hi, I need php script for Convert large svg (drawing) file to pdf-file For printing on A4 pages and a Tile sheet of paper with repeated pages. php script must split my svg (drawing) to A4 pages and give me printable pdf file You can use my svg file here and will see the result I need the same. You have a remember about the scale, if you have a ruler you can look at squares, each square must be 10x10mm, in the example, you can find nine pages. For testing, I attached svg file and result in PDF file.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I have an urgent project requiring the conversion of 1121 rows x 5 columns of data from an Excel spreadsheet into a Word document. The data must be formatted according to a pre-defined template (which I will provide). Key Requirements: Confidentiality: A non-disclosure agreement (NDA) will be signed to protect the sensitive nature of the data. Experience: Must have demonstrable experience with data formatting and conversion between Excel and Word. Speed: This project has a strict 24-hour deadline. Accuracy: Meticulous attention to detail is essential. Additional Details: I will provide the Excel file, Word template, and specific formatting instructions. Please share examples of similar projects you have completed successfully. Only professionals with strong crede...
I'm in need of a research professional who can collate and organize details about the Corporate Social Responsibility (CSR) activities of a specified list of 400 companies, together with LinkedIn profile URLs of respective team members. Key Task Requirements: - Research and compilation of CSR project details of the identified companies - Use of Excel for data presentation in an organized manner - Gathering of LinkedIn URLs of team members from each company Ideal Skill Set: - Proficiency in web research - Expertise in data entry and data organization - Familiarity with LinkedIn and its functionalities - Detail-oriented approach - Experience in Corporate Social Responsibility research is a plus. Your job will be instrumental in providing in-depth insights about the afore...
...customer business card scans into a detailed Excel database. Each card has been scanned using the CamScanner app and they vary widely in design, content, and layout and all of them are different. (90% of the cards are in english, 10% are in urdu and arabic) Objective: Looking for innovative, no-code methods that automate the conversion of these business card images to an Excel sheet with minimal human interaction. The best method should be fast, cost-effective (minimal or zero cost), and capable of handling high variability in card designs without any coding or manual programming. Submission Guidelines: * Propose a no-code solution using online tools or existing software that can intelligently organize varied information into consistent Excel columns. * ...
The work consists of a guitar transcription of the following video . Respecting the key and all fingerings the same as the video. It will be delivered the tuxguitar file and the tablature in pdf.
- Daily Accounts: Should have a mechanism for daily tracking of accounts. - Sales Management: An organized way to manage all sales. - Customer Management: The system must be able to maintain a proper client record. - Purchase Management: Need to keep track of all the purchases. - Supplier Management: Managing interactions with the suppliers effectively. - Database Management: Ability to handle a growing database. - Inventory Management: Keeping up with fish inventory.
Need a Plugin/App to Transfer Google Sheet Data to Database via Webhook URL Description: We are looking for a skilled developer to create a custom plugin or app that seamlessly transfers data from a Google Sheet to our database whenever changes occur. The plugin/app should be able to detect any modifications in the Google Sheet and trigger the transfer process automatically. The data transfer should be facilitated through a webhook URL provided by us. Requirements: 1. Develop a plugin/app compatible with Google Sheets that can monitor changes in real-time. 2. Implement functionality to extract data from the Google Sheet and send it to a specified database via a webhook URL. 3. Ensure the plugin/app is secure, efficient, and scalable. 4. Provide clear documentat...
I have an excel exercise as part of a financial modeling course which i need to solve It is regarding determining debt size and repayment profile while keeping DSCR at a fixed ratio. I will also need to record a Macro of the debt sizing, sculpting and leveling profile
I need a skilled statistician/data analyst to assist with imputing missing data in a meta-analysis of clinical trials dataset using SAS or Stata (ideally). I can supply the results of 28 trials (with 15 with missing data) with n events / n total in ACA analysis and n missing in both intervention and control groups (in Excel format) Key Responsibilities: - Impute missing data: The primary task will be to impute missing data in the clinical trial dataset. This is crucial for maintaining the integrity and accuracy of the overall analysis. - Generate ACA, ICA-0, ICA-1, ICA-pc, ICA-pe, ICA-p, ICA-b, ICA-w, Gamble Hollis analysis and IMRO (2/0.5 and 0.5/2) analysis plots - Generate L'Abbe plot(s) (for further details please see attached file) Ideal Skills and Experience: - Proficie...
...that closely mimics the layout and color scheme of the reference site, with content from a Google Sheet and images created in Canva! ........................................ price 20 dollar for 1 page . 100 dollar for 5 pages 200 dollar for 10 pages total Means one page . The below. Is contends for1 page . refernce site ____________________________________ content is in googkesheet right English sheet image design layout, make the margin spacing similar want this layout page to be designed in elementor
I'm looking for a comprehensive Excel dashboard that can help me manage resources for my projects. This project will involve visualising project management data, with a focus on resources management and planning. The key elements of this dashboard will include: - Resources Planning: Visualising the availability of team members, their skills and current project assignments. This should help me in efficiently allocating resources for various tasks. In addition to these, I'm also interested in other data such as budget tracking and milestone tracking. The ideal candidate for this project should have experience in: - Advanced Excel skills, with a focus on creating visually appealing and user-friendly dashboards - Experience in designing project management dashboard...
...deep expertise in Excel, as well as a strong foundation in data security. As a result of this project, we need a highly functional, secure Excel template that meets the following requirements: - Advanced Excel Features: The template should involve data entry forms, complex calculations and formulas, and strict data validation rules. It should also facilitate costing, inventory management, attendance tracking, salary calculation, profit/loss calculations, and accounting. An integrated dashboard and graphical representation of data is also needed. - Security: Due to the sensitive nature of the information to be processed, we require an array of security measures. These include password protection, restrictions for specific users, and data encryption. - Branding: Th...
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
I am seeking someone to retrieve specific contact details for a Chinese company located in Tibet. Key Deliverables: - Company Name - Contact Person - Address - Email - Phone Number - WhatsApp Number Preferred Format: The final deliverable should be in Excel or CSV format. Experience Required: - Proficiency in Chinese language and familiarity with Chinese business conventions. - Previous experience in retrieving contact information. - Attention to detail and accuracy in data collection. Please reach out if you believe you have the necessary skills and experience for this task.
Hiring a hybrid NYC remote assistant for a clean energy company. Job is Mond...calling) Job includes: -Scheduling clients with company for installs via phone calls -Keeping track of installs and inventory -Updating information for bookkeeping -Simple accounting and invoicing -Appointing clients to their appropriate sales rep -Social media management -Answering calls and relaying messages Must: -Speak English -Live in NYC -Have knowledge about common use of simple apps like excel, google drive, word, Gmail, WhatsApp -Organized Preferred: -Spanish / Chinese / Russian speaking -Website building, data security, tech -Photoshop -Living in Brooklyn or Queens Type : NYC only to show not a bot Please include a 15 second audio of your speaking voice to show you have english of working pr...
I require an Excel expert to assist with a complex data analysis. The dataset is quite large (more than 1000 rows) and involves matching combinations. Key Requirements: - Data Analysis: The main purpose of your task is to help me analyze the data available. This will involve identifying patterns and matching combinations. - Excel Skills: You are expected to have advanced Excel skills to handle this large dataset effectively. - Combination Matching: The combinations you will be working with are complex, and may require manipulation of the data. I'm looking for someone with extensive experience in Excel, particularly in data analysis and matching complex combinations. Your ability to efficiently handle large datasets and work through complex data structures...
...Python developer capable of performing rigorous data analysis on financial data. I have a python code, I'm not a programmer and the code has issues i would like a z*o*o**m where I can explain to you what the code is supposed to do and you fix it. its not a very long or complicated code for a programmer (I presume), the code is related to data analysis (Stock Data) it takes its data from an excel sheet that I have. Specific requirements include: - Proficient in Python with a strong background in data analysis libraries. - Extensive experience working with financial data. - Ability to generate predictive models as an output from data analysis. - Strong grasp of forecasting and projection methods, with a knack for generating accurate and data-driven predictive model...
I need a freelancer to gather contact info for 42 recruitment companies based in UAE. This information will be used for job seeking purposes. Key Requirement: You will need to find the contact name and email (and any additional possible info) for each and every recruitment/HR/Headhunting ... ManpowerGroup - Mark Williams - Robert Murray - Future Tense - Black & Grey - Education 1st recruitment - Results should be in an excel sheet format, outlining the name, position, email address for each contact. Contacts for each company should be grouped together, end file should be in 1 sheet, not separate sheets.
i will create 1 power power point and 1 excel sheet adding the equations
I need to extract data from multiple Excel files and visualize them in a separate sheet using line charts. This project involves: - Creating a separate sheet in Excel to display the data from several Excel files - Implementing a system to automatically update the data - Generating line charts based on the data Ideal skills and experiences for this project include: - Proficiency with Excel, including data handling and visualization - Experience with data extraction and integration - Expertise in creating and customizing line charts The project requires high attention to detail and the ability to work methodically with large datasets.
As someone looking to hire a talented content writer, I have a variety of assignments that'll involve writing content within a word limit of 500-1000 words. I didn't specify the exact type of content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experie...content since the tasks may vary. However, a strong command of English and the ability to write engaging, quality content are essential. Ideal Skills and Experience: - Excellent writing skills - Versatility in content writing - Ability to generate creative ideas - Experience in varying styles and formats of writing - Understanding of SEO is beneficial, but not required If you believe you would excel at this, I encourage ...
I'd like to request a quote for "xl heet and powerpoint".
I'm requiring a data scrapping software quickly to extract text content from both websites and PDF documents. It's crucial that the scraped data is directed into Excel or Google Sheets format for my immediate use. Ideal skills for this job would be: - Proficiency in programming languages like Python that are often used for data scrapping. - Familiarity with web scraping libraries or frameworks, e.g., Beautiful Soup or Scrapy. - Experience using APIs to scrape data if necessary. - Previous work in pulling data from PDFs into readable formats in Excel or Google Sheet. - Ability to deliver the project ASAP. Your attention to these requirements will be much appreciated as I need this task done urgently. Please contact me if you need more detail about the proje...
We're looking for a web developer to refine an existing HTML page! You'll take a previously converted Excel sheet (.html) and enhance its visual appeal. This involves adding CSS styling to improve the layout, formatting, and overall aesthetics of the page. Experience with HTML and CSS is a must, and an eye for clean and user-friendly design is a plus!
I'm seeking a skilled developer to create a website where users can generate customized Excel tables. Below are the key project requirements: Key Functions: - The website should allow users to generate customized Excel tables based on specified criteria such as user input, date range, and data filters. - Implement a user registration and login system to secure user data and table generation history. - Incorporate export options to enable users to download the Excel tables they generate. AI-driven Automation System: - It's important that the system integrates an AI-driven automation system. This will streamline the table generation process while providing accurate and efficient results. Subscription Offering: - The system should offer a subscription model w...
The project requires a freelancer with exceptional attention to detail and expertise in Excel to conduct a thorough review of a spreadsheet for any data inaccuracies and anomalies. The primary tasks involve identifying and rectifying incorrect or illogical entries, ensuring the consistency and integrity of the data, and highlighting any variables that require correction. The ideal candidate for this role should have strong proficiency in Excel and data handling, as well as experience in data quality assurance. This meticulous review is crucial to maintaining the accuracy and reliability of the data, which is essential for making informed decisions based on the spreadsheet information. Attached with the details is a sample of the spreadsheet with 20 participants. The complet...
...individual who can handle a medium-sized excel database (1000-5000 rows) that comprises of numerical, categorical and textual data. Key Tasks: - Data Entry: The selected candidate will need to input some outstanding data into the excel database accurately. Great attention to detail is vital for this task. - Data Analysis: I want someone who can decipher patterns and trends from raw data. This may include evaluating figures, trends, and other areas to draw practical insights. - Data Visualization: After carrying out an in-depth analysis, I want the extracted information to be presented visually to aid understanding and decision-making. Desirable Skills: - Proven experience in data entry, analysis, and visualization - Proficiency in using excel for data tasks...
As a beginner, I'm in need of someone skilled in typing data into Excel spreadsheets. The data entry will involve basic formulas and functions for simple data analysis, and I'm looking for someone who can make this process easy to understand and execute. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Able to explain basic formulas and functions in a clear and concise manner - Attention to detail to ensure accurate data entry - Patience and understanding of beginner level tasks
...entered into an Excel spreadsheet. This will be done manually, so you must have excellent typing skills and attention to detail. - **Turkish Characters Proficiency**: An essential requirement for this job is a strong proficiency with Turkish characters. As some of the books will have titles and authors in Turkish, you should be able to accurately interpret and enter these characters. - **Handling Missing Data**: In the event that a book's details are missing or illegible, I would like you to search online for the information. If this is not possible, then the field should be left empty. Please note that I do not want placeholders like "Unknown" used in the spreadsheet. Your responsibilities will include: - Typing in the book title and author accurately within th...
Hello there, I hope this message finds you well. I am reaching out to invite you to collaborate on an exciting project aimed at revolutionizing heat insulation solutions for metal sheet applications. We are in need of your expertise as a formulation chemist to develop a cutting-edge heat insulation coating that can significantly lower the internal temperature of metal sheets upon application. Our goal is to create a coating that not only provides excellent thermal insulation but also maintains the structural integrity of the metal sheet. More details are in the attached file. Thanks Mahesh
...of a freelancer who can help me create a visually appealing PowerPoint presentation and handle some moderate data analysis in Excel. PowerPoint: - Your role will be to make my content visually engaging through simple transitions and animations. - Creativity and a good eye for design are essential to make the presentation impactful for the audience. Excel: - You will also be tasked with handling moderate levels of data analysis and visualization. - I will require you to work with pivot tables, conditional formatting, and possibly other mid-level Excel skills. Ideal Skills: - Proficient in PowerPoint with a strong design sense. - Comfortable working with Excel and able to handle moderate data analysis tasks. - Excellent communication skills to understa...
I'm seeking a skilled app script professional to improve functionality in my current Google Sheets. The job entails creating connections with external APIs, and add a multiple drop down function in Google sheet. This is different than dependent drop-down and I require to use just one cell for the multiple drop down rather than using the next cell. Key requirements: - Add two dropdown menus - The menus need to feature a predefined list of words - Experience with Google Sheets and App Script Recommended skills: - Google Sheets - Google App Script - API Integration
I'm looking for a Python programmer who can create custom code to extract text, numerical data and dates from an Excel spreadsheet and populate PDF fields using the PDFMiner library. You should be confident writing Python scripts and have experience manipulating Excel and PDF files. Familiarity with PDFMiner is a essential. - Must Haves: - Proven Python programming experience. - Familiarity with the PDFMiner library. - Ability to extract and manipulate data from Excel. - Experience in PDF field population.
I require proficient help to tackle a substantial data cleaning and organization job. The task involves over 2000 records that must be meticulously cleaned and streamlined. You'd be working directly in Excel, so a thorough knowledge of this software is essential. Understanding of data organization, deduplication, and data cleaning is required. Aptitude for managing large quantities of data would be advantageous. A keen eye for detail and commitment to delivering high-quality results are crucial.
I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data
I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English
I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...
I'm seeking a skilled freelancer to analyze data provided. I can provide an excel file which will have -Customer -Invoice Number -Date -Product Details -Quantity -Unit Price -Purchase Amount I have this data for last two years in monthly files. We want to observe the trends in sales, most selling product, most profitable product, least profitable product etc. We want to see the customers trends and see which customers are buying less and vice versa. Please recommend technology we are open to feedback. Along with this i will like another separate file for another user who will look after the Customer Service and sales side of the business. I would like this second file to extract selective data from the master file and propmt the user to make phone calls to existing custo...
Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
I'm in need of an expert in Pinescript and Amibroker Formula Language who can work on TradingView platform to code my trading strategies. Specifically, this includes two distinct strategies: 1. Demand and Supply Strategy 2. Breakout Strategy I have a specific set of rules and conditions for both of these strategies which I will share with the successful bidder. You should have a deep understanding of trading systems and strategy design, and demonstrate proficiency in Pinescript. The ideal candidate should have a record of delivering successful and effective coding projects within TradingView. Understanding of financial markets, specifically in the context of demand-supply and breakout strategies, will be crucial.
