Como crear una hoja de calculo en excel jobs
I'm looking for a Python script that can help me track details about phone numbers including their location, carrier, and owner information. Key requirements: - The code should allow for bulk upload of phone numbers from an Excel file. - It should be able to extract and display information about each number. Ideal skills and experience: -Details of number like registration image -all social media connection details -Tracking movement of number - Proficient in Python programming. - Experience working with data extraction and tracking. - Familiarity with Excel and bulk data processing. The script should provide in-depth owner details.
I need a detail-oriented professional to assist with data entry and financial reconciliations. Your tasks will include: - Inputting a variety of financial transactions (sales, purchase, and expense) into Excel on a daily basis. - Accurately recording invoices and receipts. - Helping with monthly, quarterly, and yearly reconciliations by verifying records against bank statements. Ideal skills and experience for the job: - Proficiency in Excel. - Experience with data entry and financial reconciliation. - Excellent attention to detail and accuracy. The professional should be able to work independently with minimal supervision.
As discussed in the chat, I created a script in Python to convert Beast of Cloud CSVs to Mystore ONDC Excel format.
I require an Excel specialist to create a macro that counts cell values based on specific colors. These counts will be used for generating reports. Key Requirements: - Count values from Green and Orange colored cells - Utilize a macro for automation Currently, the colored cells are updated via a drop-down list with three options. The ideal freelancer for this project should have extensive experience with Excel, particularly with creating macros and handling conditional formatting.
...Automated updates during registration. Alerts for low stock thresholds. 2.6 Payment Integration with Billplz Secure online payment processing. Supports local payment methods and tiered pricing (e.g., early bird discounts, VIP tickets). Payment receipts included in notification emails. 2.7 Reporting and Analytics Exportable data for participants, groups, and payments (e.g., CSV, Excel). Visual dashboards for real-time insights: Ticket sales and registrations. Inventory usage. Payment summaries. 3. Non-Functional Requirements 3.1 Lightweight Processing Optimized database queries for high performance. Caching (e.g., Redis, Memcached) for frequently accessed data. Asynchronous handling for notifications and QR code gen...
Job Title: Data Researcher Needed to Build UK Builders & Contra...UK location. Gather accurate and up-to-date information including: Name Telephone number Email address Website Requirements: Experience in online research and data collection. Ability to organize data efficiently in a clear and structured format (e.g., spreadsheet). Familiarity with UK regions and construction industry is a plus but not essential. Deliverables: A detailed database in Excel. Additional Notes: The work will involve sourcing data from websites, directories, and other online platforms. Please ensure all data collected complies with data privacy regulations. If you’re interested and have experience in similar projects, please apply with a brief explanation of your approach and r...
...Kindly look at my portfolio. I am professional Structural Engineer with more than 08 years experience. I can design any types of residential and commercial buildings with proper structural analysis, Load calculation report and detailed drawing following by ASCE, ACI, IBC, BNBC codes. I have expertize in different types of professional software like SAFE, ETABS, AUTO CAD, STAAD Pro, SAP 20000, MS EXCEL, MS POWERPOINT etc. I have also expertise at 3D design and 2D draft work of AUTOCAD, SKETCH UP and other relevant softwares. I am able to deliver your project with all the key requirements and your timeframe. I have practical experience in many RCC structures, Steel Structures, Timber structures etc which were delivered to clients with their feedback. My team members are incor...
I'm looking for a skilled professional with extensive experience in VBA and macros to assist with data manipulation on my Excel sheets. Your primary tasks will include sorting and filtering data, as well as combining and merging sheets. Ideal Skills and Experience: - Proficient in Excel, VBA, and macros - Strong data manipulation skills - Experience with sorting, filtering, and merging data in Excel - Ability to automate repetitive tasks to improve efficiency - Proficient in using and creating advanced Excel formulas - Experience in error handling and debugging VBA code - Ability to manage and work with dynamic data ranges - Experience in integrating Excel with external APIs - Proficiency in creating and customizing pivot tables - Strong skills in ...
Looking for someone that is proficient in doing Balance sheet and income statement for banking purposes. Must be able to take some data in excel and formulate a professional document that can be submitted. Must start immediately and complete within 24 hrs.
I'm in need of a proficient data entry specialist. The primary task will involve handling Excel spreadsheets. Your responsibilities will encompass: - Inputting, updating and maintaining data with a high level of accuracy. - Ensuring data integrity and confidentiality. - Performing regular backups to secure data. - Generating reports from the data as needed. Ideal candidates should have: - Proven experience in data entry, particularly with Excel. - Excellent attention to detail. - Strong organizational skills. - Ability to work independently and meet deadlines. I look forward to your bids and am eager to find a reliable professional to assist with this task.
I'm looking for a freelancer who can assist with data entry from PDF documents. The data is mixed, meaning it includes both text and numerical data. The task requires straightforward, plain data entry without any need for formatting or structuring. Ideal Candidate: - Attention to detail to ensure accuracy in data entry - Proficient in handling mixed data - Experien...entry without any need for formatting or structuring. Ideal Candidate: - Attention to detail to ensure accuracy in data entry - Proficient in handling mixed data - Experience in data entry from PDF documents is a plus - Able to work independently and meet deadlines The project involves data entry from less than 100 PDF pages. The project should be completed within 2 weeks. Please use Microsoft Excel for the da...
I'm seeking a skilled Excel professional to help update several spreadsheets and create a comprehensive dashboard. The primary focus will be on a roster employee attendance sheet, but other HR-related data may be involved. Key Responsibilities: - Update and improve Excel sheets - Create a user-friendly dashboard - Implement coding where necessary for enhancements Specific Goals for the Attendance Sheet: - Automated calculations: To simplify data processing - Visual charts/graphs: To represent data trends clearly - Conditional formatting for attendance patterns: To easily identify anomalies I'm open to any additional improvements or optimizations that I may not be aware of. Ideal candidates should have a strong background in Excel, experience in HR data an...
I'm seeking a proficient Excel expert to create a comprehensive school fee management system for me. The system should include functionalities for fee calculation and tracking, generating fee receipts, and sending payment reminders. Key functionalities: - Fee Calculation & Tracking: The system should automatically calculate fees and track payments. - Generating Fee Receipts: It should be able to generate receipts for the fees paid. - Payment Reminders: The system should have an alert system for payment reminders. - Discount Management: Include functionality to apply discounts or scholarships to student fees as needed. - Payment History: Track the complete payment history of each student for easy reference. The system will not need to handle multiple currencies or differe...
I have a Google sheet with tabs for every day of the week listing football teams and their respective training locations. I need a formula or function on the first tab that searches through all other tabs to find each team's training times and displays them in a new column next to the team name. The team names in each tab match e...for adjustments in team names and additions in the first sheet column A and update accordingly. - The training times should be displayed for all days of the week. Ideal Skills: - Proficient in Google Sheets - Experienced in creating complex formulas and functions - Familiarity with organizing and analyzing sports data The training times should be displayed in a 24-hour format. I've attached an excel file, but to be 100% clear this is to be do...
I'm looking for an Excel expert. I need to be able to have an inventory table on one sheet with ingredients and prices, and recipe cards on another sheet. The project requires a formula that will allow me to type an item (e.g. flour) and it will pull the price from the inventory table. Key Requirements: - Excel expertise - Ability to create custom formulas - Understanding of inventory management in Excel The ingredients will be listed vertically in the inventory table, and the ingredient names will be exactly the same in both the inventory table and the recipe cards.
I need assistance with an Excel-based project. Requirements: - I have multiple sheets with student data. - I have a set of questions. - I want each student to receive a customized question paper based on specific criteria from their data in the Excel sheets. - I want this customized question paper to be in a Word document. - I also need help emailing each student their own question paper. Ideal Skills: - Proficiency in Excel and Word. - Experience with data analysis and customization. - Familiarity with email automation tools.
I'm looking for someone to help me populate a spreadsheet with greyhound race betting data. The data should be sourced from Greyhound Racing Victoria Website in a specific way. Result CSVs will have to be downloaded for each meeting from June 2023 to current day. Data from these CSVs is then to be copied and pasted into a sheet of the attached Excel workbook in the following fashion; - All data from results csv copied into 'CSV data' Sheet - Then, cells B3:AS14 in 'Comps' sheet copied, and values (not formulas) pasted into 'Data' sheet under the previous race. I have already done this for a number of race meetings so the 'Data' sheets already contains quite a bit of data. There's no need for the data to be updated regularly at thi...
I need a professional Excel spreadsheet designed to track my car expenses for tax purposes, both for business and private use. Key Features: - Mileage tracking: The spreadsheet should be able to record and calculate my daily mileage. - Fuel expenses: It should accommodate my fuel receipts and compute total fuel costs. - Depreciation: The spreadsheet needs to account for the depreciation of my car. Data Input: - Daily mileage: I will input my mileage on a daily basis. - Fuel receipts: The spreadsheet should have a section for my fuel receipts. - Maintenance costs: There should be a space for recording my maintenance costs. Data Display: - Tables: The data needs to be organized in clear and concise tables. - Graphs: I would like to see visual representations of my data in the for...
I'm seeking an experienced mobile app developer to create an Android/iOS app for field data collection. The app should be able to import data from Excel spreadsheets and function like a customizable form with fields for work order numbers, addresses, job details, test results, and image uploads. After data collection, it should export to both Excel and PDF formats. Key requirements include: - Offline data collection capabilities: The app should primarily work offline with connectivity needed only for data uploads and downloads. - Image uploads: The app must allow users to upload pictures as part of the data collection process. - Customizable fields: Users should be able to tailor the form fields according to their specific data collection needs. Ideal candidates for t...
I'm in need of a professional to create an adva...professional to create an advanced, interactive dashboard using MS Business Intelligence tools. This dashboard should cater to a variety of data sources and metrics. Key Requirements: - Connect the dashboard to SQL Database and Excel Sheets - Visualize and display key metrics including Sales data, Financial information and Customer Relationship Management (CRM) data - Incorporate advanced interactivity features, employing drill-down capabilities and interactive graphs Ideal Skills and Experience: - Extensive experience with MS BI tools - Proficiency in SQL and Excel - Prior experience working with sales metrics and financial data - Ability to create user-friendly, interactive dashboards - Strong understandin...
Excel File: Using the data files assigned to you, find the interesting “story” that is contained in the data and build a dashboard to visually illustrate “your story” to a user who is unfamiliar with the data file. Include these ten elements plus any other Excel skills that help tell “your story.” 1. Data combined from more than one file by Power Query (Get Data/From Folder) 2. Data sorted (largest to smallest or alphabetically, etc.) 3. Pivot table(s) 4. Slicer(s) 5. Time-line slicer(s) (see video on how to convert your years to a date format) 6. Pivot chart(s) 7.&nbs...
...expert who can create optimal financial templates within ag-Grid tables. Key requirements: - Experience in designing ag-Grid tables primarily for mixed data display - A strong understanding of financial data and the ability to create relevant templates - Proficiency in implementing sorting, filtering, row grouping, and aggregation functionalities - Ability to incorporate export capabilities to Excel or CSV - Proficiency in performance optimization for large datasets - Ability to apply conditional formatting based on financial metrics - Experience with custom cell renderers to enhance data visualization - Experience with integrating ag-Grid tables with various APIs - Ability to create custom themes or integrate with existing design systems - Experience implementing real-time data...
...experienced Excel VBA professional to create a macro that can assist in handling scientific data from an analytical instrument. When we analyze a sample, we got a list of retention time (in minute) and data are associated with each retention time (name, %ID, value of area). 1 retention time = 1 molecule. From one sample to another one, the retention times can slightly differ but they both correspond to the same molecule (for example sample 1, retention time = 6.432min and for sample 2 = 6.438min). I need a macro to group all retention time that are close one with each other among different samples (we can use a constant value to define the range). For each group, I need to list the associated values for each sample. Raw data are in an Excel file. Key Responsibilities...
Hello, Hope you are doing well!! We are currently seeking experienced native Spanish linguists specializing in the Spanish to EN language pair for an upcoming subtitle review project. This opportunity is ideal for professionals skilled in Subtitling Projects. Below are the Project Details: Language Pair: Spanish to EN Work Type: Subtitling Review Volume:23000 min Source Files: .srt If you are interested and available, please let us know your per-hour rates. Thank you!
...data entry and financial analysis. I need my bank statements from the past three years converted into Excel and used to create basic Profit & Loss statements. The primary purpose of this project is to provide a clear overview of my business's financial situation. Therefore, a detailed analysis of the data is not necessary, but I do need basic categorization of expenses and income. The ideal freelancer for this job should: - Be proficient in Excel - Have experience with financial analysis - Understand basic business accounting - Have a keen attention to detail to ensure accuracy in data entry. - Maintain strict confidentiality of financial information. I prefer the use of a standard Excel template for the Profit & Loss statements, so familiarity wit...
Diseño de dos web institucionales y una tienda virtual. En Wordpress.
...need someone who can help me with daily data entry for my electronics products. This includes product descriptions, technical specifications, and pricing details. Ideal candidate should: - Have experience with data entry, particularly with electronics - Be able to work on a daily basis - Have good attention to detail to ensure all information is accurate - Have proficient skills in Microsoft Excel or other spreadsheet software - Be capable of quick turnaround times to keep data current - Possess basic knowledge of SEO to ensure product descriptions are optimized - Understand technical jargon related to electronics for accurate descriptions - Experience with data validation techniques to ensure data integrity - Possess strong communication skills for clarifying ambiguities in pr...
...event is completed. I am currently using a Google Sheets / Excel workbook approach that is not connected or aligned - so the same data needs to be entered multiple times and is prone to errors. I would like to create a new workbook that has pivot tables and allows for all data to be entered once, and then have the correct formulas show what payments have been collected, what is still due, how much has been paid out and what is still pending. I also need reports to be able to be run for this and each sales manager to have their own tab to see what they are owed and have been paid already. And another list of tabs for clients to show what rebates have been paid out and what is still pending. I am not locked into using Excel or Google Sheets if there is a free or low ...
...following details for each product: Product Name Price Barcode (UPC-A format) Internal Reference Number Product Image 2. Data Integration: Import all product data from an Excel spreadsheet into the InDesign document. Ensure seamless data merging to populate product details accurately. 3. Barcode Specifications: Barcodes will be in UPC-A format, with the check digit calculated using a barcode generator. Check digit calculation will be handled via either Excel formulas or specialized software. 4. Promotional Pages: Design 5–10 promotional pages separately. These pages will not be populated from the Excel spreadsheet. Incorporate unique, visually appealing designs for these promotional pages. 5. Design Deliverables: The catalog will combine data-driven...
I need an Excel sheet designed to help manage a rotating shift roster. This sheet should support inputting shift data manually and utilizing basic formulas for automation. Key Requirements: - Manually inputting shift data - Designing the sheet with support for rotating shifts - Utilising basic Excel formulas for automation Ideal Skills: - Proficiency in Excel - Experience with shift management systems - Basic understanding of Excel formulas This project is perfect for someone who can create a user-friendly Excel sheet that simplifies managing rotating shifts. The sheet should accommodate day, evening, and night shifts. The sheet should include basic reports for tracking shift distributions and employee hours. The sheet should include specific shift p...
I'm looking for a skilled Excel freelancer who can enhance my existing spreadsheet. This project primarily focuses on improving data entry and validation processes. Key Tasks: - Use existing Data Validation features to create conditions - Implement trigger lists based on selections Ideal Candidate: - Proficient in Excel with strong experience in Data Validation - Able to create, automate and manage dropdown lists - Capable of designing a user-friendly spreadsheet for efficient data entry and validation. Experience with creating complex Excel conditions and a good understanding of data validation is crucial for this project.
I'm looking for an expert in TreeAge Pro and Markov modeling to convert an existing TreeAge model into a interactive independent Excel based economic model. Key Responsibilities: - Convert a TreeAge Pro model utilizing Markov modeling technique into Excel files Ideal Skills and Experience: - Proven expertise in Markov modeling and TreeAge Pro. - Strong background in healthcare analysis. - Experience modeling treatment effectiveness. - Excellent communication skills to explain complex model outputs.
I need professional help to set up multiple VLOOKUP functions in my Microsoft 365 Excel file. I will provide remote access via Teams or Zoom.
I'm looking for an Excel expert to create a data analysis workbook for tracking cryptocurrencies. Key Features: - Portfolio performance visualization: I need to be able to see how my portfolio is performing over time, with clear and easy-to-understand visuals. - Transaction tracking: The workbook should have a function for tracking my transactions, allowing for easy monitoring of my buying and selling activities. Ideal Skills and Experience: - Advanced knowledge of Excel, including functions, formulas, and data visualization tools. - Experience in creating workbooks for tracking financial data, particularly cryptocurrencies. - Ability to understand and meet specific data analysis needs. Please provide examples of similar projects you have completed in your proposal.
...in the product title then nothing appears in the recipients columns. I then require a similar thing to happen for “occasion”. Again I have a list of the occasions that could appear. I would like someone to sort my data this way but also teach me the best way how for my future reference. The sorting and categorization should be done using a spreadsheet tool like Excel. I would like the final sorted data to be provided in an Excel file....
...Estamos buscando un profesional experimentado para crear y publicar 50 listados de productos en Amazon y MercadoLibre. Los productos abarcan diversas categorías, incluyendo riego, fontanería, electricidad e iluminación. Requisitos Clave: Ser responsable de la creación de listados a partir del nombre del producto y una fotografía proporcionada. Asegurar que los listados incluyan 5 fotografías de alta calidad. Redactar descripciones completas que representen con precisión el producto y sus características. Sugerir palabras clave y frases relevantes para mejorar la visibilidad y alcance de los productos. Experiencia en la gestión de aprobaciones de A...
...whether the candidate joined or not The model output should be presented in a user-friendly dashboard format. The model should prioritize accuracy to ensure the highest likelihood of predicting candidates who will join the company. The model output should include charts and graphs for easy interpretation. Excel The model will use a supervised machine learning approach. The dashboard should highlight the probability of acceptance for each candidate. The dashboard should be built as an Excel spreadsheet. The analysis has already been completed. Only advanced customization options to be done for dashboard visuals. The dashboard visuals should include advanced customization options for detailed analysis. The dashboard should include high interactivity features such as drill-...
...b. A Greedy approach And one of the following approaches c. A* approach d. A Genetic algorithm e. The Simulated annealing algorithm f. any other solutions You will need to implement the selected algorithms using Java. Your implantation should allow the user to input the number of cities and the distance between each pair of cities, or it should allow the user to input the city distances as an excel of csv file. Your project must have all algorithms in a single Java Project file. You should provide the following: 1. Explain how each selected approach works in details. 2. A simple (step by step) explanation of the 3 selected algorithms 3. Analyze each algorithm complexity. 4. Compare the performance of the 3 implemented approaches in terms of execution time on different number o...
...structured format. Data Processing in Excel: Transfer the extracted data into a prebuilt Excel template with predefined fields. Automate scoring by comparing candidate responses with a list of correct answers. Automation & Tools: Suggest and implement the best tools Ensure scalability and ease of use for non-technical users. Deliverables A secure, fillable PDF forms. (Might need few forms with minor changes in each) A reliable workflow to extract and transfer data to Excel. Automated scoring in Excel based on predefined rules. Clear documentation for the process. Skills Required Experience with PDF form creation (e.g., Adobe Acrobat). Proficiency in automation tools . Excel a...
I'm looking for a spreadsheet that calculates the 10-year gain on a fixed amount investment in stocks. The spreadsheet should also account for an annual withdrawal of 5% of th...design should be user-friendly, allowing easy navigation and comprehension of the calculations. - Include graphical representations such as line charts to visualize the investment growth over the 10-year period. - The spreadsheet should include an initial input sheet for entering the initial investment, expected annual return rate, and withdrawal percentage. Ideal Skills: - Proficient in Excel or Google Sheets. - Strong understanding of investment calculations. - Experience in designing financial spreadsheets. Include a 5% growth rate after historical data drops off as a reference index for t...
I'm looking for a web ...This includes the ability to change colors, fonts, and all visual aspects of the card. - Form-based User Interface: The interface for modifying the arrangement of fields on the card should be form-based inputs. It should be intuitive and user-friendly for easy navigation. - Versatile Data Import: The application should support bulk data import from various file formats, with a primary focus on Excel. Other supported formats should include CSV, XML, JSON and PDF. The ideal candidate for this project should have extensive experience in web application development, particularly in creating customizable templates and user-friendly interfaces. Knowledge in form-based input systems will be highly beneficial. Please include your portfolio with relevant projec...
I'm seeking a proficient Excel expert to create a comprehensive school fee management system for me. The system should include functionalities for fee calculation and tracking, generating fee receipts, and sending payment reminders. Key functionalities: - Fee Calculation & Tracking: The system should automatically calculate fees and track payments. - Generating Fee Receipts: It should be able to generate receipts for the fees paid. - Payment Reminders: The system should have an alert system for payment reminders. - Discount Management: Include functionality to apply discounts or scholarships to student fees as needed. - Payment History: Track the complete payment history of each student for easy reference. The system will not need to handle multiple currencies or differe...
I have approximately 1000 product items in an Excel file that need to be organized and uploaded to WooCommerce on my WordPress site. - The product images are currently embedded within the Excel file, but they are not properly organized. - All product details, including descriptions and prices, are complete, except for the categories which need to be assigned. - I need a professional with experience in WordPress, WooCommerce, and data entry to help me with this task. The ideal freelancer for this job should: - Have a strong background in WooCommerce and WordPress. - Be detail-oriented and able to categorize products correctly. - Have excellent data entry skills. - Be familiar with bulk uploads to WooCommerce.
I'm seeking a developer to create a passport scanning application that utilizes the Mindee API. This application can either be web-based or an offline program, depending on your expertise and wh...should be capable of scanning all types of passports. - It needs to extract all pertinent details from the passports. This includes personal information (name, date of birth, etc.), visa details, and travel history. - All extracted information should be compiled and shareable as an Excel file. Ideal Skills and Experience: - Proficient in app development with significant experience in both web and offline programs. - Familiarity with the Mindee API is a plus. - Excellent understanding of data extraction and Excel file formatting. - Prior experience with developing scann...
...source of data, have various formats and structures, rendering manual processing a tedious task. The information will be utilized to access Xtream IPTV services covering channels, VOD, and series. Key Requirements: - Experience and proficiency in Python. - Prior exposure to data extraction and handling scripts. - Familiarity with M3u files is a plus. - Ability to deliver the extracted data in Excel format. The ideal freelancer for this project will have a keen eye for detail and a strong problem-solving mindset to navigate the varied structures of the M3u files. Your script will significantly streamline the data extraction process, making it efficient and effective....
I am looking to grow the following two apps that we have developer GoDial Mobile CRM It is a mobile based CRM that allows you to add contacts from phonebook, excel, call logs and auto dial them for sales. It also allows you to send bulk sms, whatsapp, manage tasks, set callbacks, reminders, track payments and all sales related tools. I has business card sharing, auto call popup for incoming call tracking and many more features. DreamStory It is a ai based dream interpretation tool, it allows you to journal your dreams everyday via text or audio, then it automatically uses AI to interpret your dreams, it scores dreams, finds hidden meanings, over time does analysis for recurring pattern and insights. It also allows
