Sum repeating values excelpráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Two years ago, I had a plugin created to calculate the price of pencil printing. After updating the woocommerce, my files were probably overwritten - the price with the print on the product page, in the cart and others is not displayed. You will need a good knowledge of the core o...good knowledge of the core of woocommerce and programming Link for example : input quantity 100 - select "potisk předmětu - online kalkulačka" click "zvolte technologii" select "tamponový tisk" click "Upřesněte technologii" select "jednobarevný potisk" click vypočítat cenu potisku ... now see only NaN Kč... Nan - It should be the sum of the price of the products + the price of the print Multiple files need to be modified for...
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
...(Family, Kids or sports day, Corporate events, Employee parties, Christmas parties, Opening events, Company anniversaries, Open days, Roadshow, Garden parties, Galaevenings and other new format that are not so known) - External cooperation with agencies. - Production of "Re-decoration" (decoration, props, upcycling material - reuse, remake, recycle system). Claim: TOGETHER we will transform your values INTO ACTION! (maybe there will only be Together into Action - I do not know yet). Concerning the logo, I do not have a specific idea so far. It should smybolize wildness, independency, openness, discovery, freedom, trust&100% reliability, courage. I have only specific requirements for a color scale - see in the attachment - yellow, orange, scales of blue. Commu...
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
I'm seeking a talented logo designer to c...Key Requirements: - Design a logo that visually communicates the essence and values of my brand - Create a modern, clean, yet bold logo that stands out online, which appeals to the youth. - Ensure the logo is adaptable to various online platforms and sizes - Provide the logo in different formats suitable for web use Ideal Skills: - Proven experience in creating visually appealing and impactful logos - Strong understanding of color psychology and its impact on brand perception - Familiarity with creating logos for online use and knowledge of best practices for web design If you are a creative and experienced logo designer, and you're passionate about creating visually striking designs that reflect a company's values...
I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable. I cu...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.
una pagina web que...seran enviados a su correo y whatapp, tambien tendran la opcion de cambiar su clave o recuperar su clave; los socios podran ver el historial de ventas, comisiones, pagos realizados, saldo, estadisticas, la informacion sera enviada a su correo y whatapp, tambien tendran la opcion de cambiar su clave y recuperar su clave. todo tiene que ser almacenado en una base de datos que se pueda exportar a excel, la pagina web tiene que ser amigable y podra visualizarse desde una computadora, tablet y telefono celular. la pagina web debe estar en idioma español y tener la opcion de cambiar a idioma ingles, el proyecto incluye el codigo fuente el proyecto debe tener la opcion de ofertar varias promociones a los clientes, estas promociones se deben visualizar al inicio ...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
As a client, I'm seeking a talented writer to help create an engaging, inspirational children's book specifically aimed at preschoolers (3-5 years old). The book's primary goal is to inspire and teach values, with a focus on courage and bravery. Key Goals: - Create an engaging, age-appropriate story that introduces concepts of courage and bravery. - Craft a narrative that is motivating and impactful for preschool-aged children, instilling valuable life lessons in an entertaining and accessible way. - Ensure the book is written in a way that is understandable and relatable to its target audience. Ideal Candidate: - A children's book writer with a strong understanding of preschool children's cognitive and emotional development. - Experience in crafting stori...
I'm in need of a talented graphic designer to create a minimalist logo for my brand. Key Project Requirements: - Logo Design: I expect the freelancer to create a unique, minimalist logo that accurately represents my brand. Ideal Skills and Experience: - Proven track record in logo design, particularly minimalist design - Strong creative and visual skills - Abil...need of a talented graphic designer to create a minimalist logo for my brand. Key Project Requirements: - Logo Design: I expect the freelancer to create a unique, minimalist logo that accurately represents my brand. Ideal Skills and Experience: - Proven track record in logo design, particularly minimalist design - Strong creative and visual skills - Ability to understand and interpret brand values - Strong atte...
I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.
I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.
...days before y or n 1 day after promotion y or n 2 days after promotion y or n 3 day after promotion y or n USA globally holyday y or n USA state holyday y or n Holyday name holyday number of days holyday 1 day before y or n holyday 2 days before y or n holyday 3 days before y or n 1 day after holyday y or n 2 days after holyday y or n 3 day after holyday y or n Store id Store state Store city Sum sold = current price * haw many sold Competitor in the same city y or n data simulation should be done in both 1) python and then python code to upload to SQL DB 2) and also in SQL you provide 1 sql and python code for simulation 2 main table creation code (only sql) for python for simulation provide detailed instructions and code how to run python code and how to upl...
I'm in need of a talented graphic designer to create a minimalist logo for my brand. Key Project Requirements: - Logo Design: I expect the freelancer to create a unique, minimalist logo that accurately represents my brand. Ideal Skills and Experience: - Proven track record in logo design, particularly minimalist design - Strong creative and visual skills - Abil...need of a talented graphic designer to create a minimalist logo for my brand. Key Project Requirements: - Logo Design: I expect the freelancer to create a unique, minimalist logo that accurately represents my brand. Ideal Skills and Experience: - Proven track record in logo design, particularly minimalist design - Strong creative and visual skills - Ability to understand and interpret brand values - Strong atte...
Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.
I'm in need of a skilled developer to add a custom feature to Invoice Ninja. The following required features need to be developed: 1. Receipt on top of payments module - int...CSS can be given. CSS can also be hard coded, only used for RTL. but should only be enabled if user selected either Hebrew or Arabic as language. 3. Expenses sub category - expenses add a sub category (now only category exists), also define how much % of the expense is approved. For example, in some countries if you report car gas expense, only 45% will be acknowledged as expense from the total sum. so 45% from the total expense should go into the reporting. The ideal candidate will be an individual or team with extensive experience in Invoice Ninja, PHP, Laravel, CSS, HTML and proficient in creating c...
...e-commerce website development, particularly with dropshipping models. Although experience is not entirely necessary. Strong network and ability to recruit top-tier freelance developers. Leadership skills with a track record of managing remote development teams. Expertise in modern web technologies and frameworks. Strategic thinker with excellent project management skills. Independent contractor who values flexibility, but is committed to delivering results. Need to be proficient with WordPress and woocommerce Ali2woo experience is also preferred. Bulk product uploading experience. Long term prospects. What We Offer: Flexibility to work remotely. Potential sweat equity options, aligning your success with the company’s growth. An opportunity to be at the forefront o...
I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.
I'm currently seeking a logo designer to help me create a modern and minimalist logo for my personal brand. I'm a dedicated student and hard worker who is thrilled about the opportunity to unveil a professional logo that embodies my values and personality. Key responsibilities: - Design a modern and minimalist logo tailored to my personal brand - Ensure that the logo aligns with my professional image and resonates with my target audience The ideal freelancer for this project should have: - Proven experience in graphic design, with a focus on logo design - A strong portfolio showcasing modern and minimalist design concepts - Excellent communication skills to understand and interpret my vision - A collaborative spirit to ensure the final product meets my expectations I�...
...days before y or n 1 day after promotion y or n 2 days after promotion y or n 3 day after promotion y or n USA globally holyday y or n USA state holyday y or n Holyday name holyday number of days holyday 1 day before y or n holyday 2 days before y or n holyday 3 days before y or n 1 day after holyday y or n 2 days after holyday y or n 3 day after holyday y or n Store id Store state Store city Sum sold = current price * haw many sold Competitor in the same city y or n Week day – mon, teu, wen, ther, fr, sat, sun Weekend y or n Day after weekend ***** end Main table to calculate ***** data simulation may be done in python and then upload to SQL DB (but better in SQL) you provide both 1 sql or python code for simulation 2 main table creations code (only sql) ...
I'm seeking a creative professional to assist me in building a brand from scratch. The main aim of this project is to establish a unique brand identity that reflects trustworthiness, authenticity and a strong legal presence. Key Responsibilities: - Develop a brand that reflects the values of trustworthiness, authenticity and legal expertise - Understand the nuances and demands of the legal industry to create a brand that differentiates from competitors - Design a visual identity that resonates with the target audience Ideal Skills: - Proven experience in brand creation, particularly in legal or professional services - Understanding of branding principles and how they can be applied to convey trustworthiness, authenticity and legal acumen - Strong creative skills in designing...
What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help
...and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurately reflected in the Excel...
We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...
I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes
...ability to create designs that meet high standards of quality and creativity. Effective Communication: Strong communication skills to accurately interpret our brand vision and translate it into a compelling logo design. We look forward to collaborating with a talented designer who can bring our brand to life through a unique and professional logo that effectively communicates our identity and values....
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.
Am doing a project using a simple shell and tube heat exchanger design and I have a problem with Ansys fluent validation. I already drew the shell and tube heat exchanger, simple design. However, the problem is that am unable to get similar resu...project using a simple shell and tube heat exchanger design and I have a problem with Ansys fluent validation. I already drew the shell and tube heat exchanger, simple design. However, the problem is that am unable to get similar results as the actual value when it comes to pressure drop. for flow rate 1 am getting it correct, but mass flow rate 0.5 and 2 kg/s are different and far from the actual values for the pressure drop of the shell outlet. I need someone that can fix the issue achieve at least 6% or less error compared to the act...
I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...
...an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Tools -> MySQL -> PHPMyAdmin. Here, you can directly view and edit the data in your tables and ensure that all date and time values are correctly formatted. I also may have more work as well. I want to also Improve on my site design and f...
...roll-up banner for my business. I need the final version by maximum Monday night. The main purpose of this marketing material is to provide general information about our business to the general public. Key requirements include: - A3 Tri-Fold Brochure: This brochure should be designed to be engaging and informative. It will serve as a snapshot of our business, highlighting our key services and values in a creative and visually appealing manner. - Roll-Up Banner: The roll-up banner should be designed to be eye-catching and informative. It will be displayed in various settings to attract attention and provide an overview of our business for those passing by. The ideal candidate for this project will have: - Proven experience in designing A3 brochures and roll-up banners - A stron...
necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm in need of a brand identity logo design. The purpose of this design is to create a strong, recognizable visual representation of my brand. I have a hand sketched design to start from, whi...dark blue, and the triangular shapes maintained. - The design should be versatile enough to be used across various platforms and mediums, including packaging. I'm looking for a designer with a strong portfolio, particularly in creating logos for brand identities. Excellent knowledge of color theory and a keen eye for minimalistic design are a plus. Your ability to understand and translate brand values and aspirations into a visual form is crucial. Please include relevant samples of your work in your bid. This could lead to ongoing work as there is a lot of packaging design to be ...
As an upscale construction firm, I am on a quest for a graphic designer endowed with an eye for classic elegance. Your task will be to conceive an exclusive, classic serif font type logo for my company. The design should: - Reflect the full name of...preferred - the other image is the vibe - Convey an ambiance of elegance and exclusivity - Express the high-end nature of my company by presenting a memorable visual image through text alone Ideal Skills: - Graphic Design expertise - Font design experience - Proficiency in aesthetics and classic styles - Experience crafting logos for luxury brands - An eye for alignment with brand's aesthetic and values. If you possess the ability to create a logo that encapsulates the essence of a high-end, luxury construction company, I we...
