Calculate group sum loop excel jobs
I am looking for a freelancer who can assist me in creating a science project for middle school students that focuses on biology and involves conducting an experiment. The ideal candidate will have experience in creating science projects for students of this age group and will have a strong understanding of the scientific method. Skills and Experience: - Experience creating science projects for middle school students - Strong understanding of the scientific method - Background in biology or related field - Ability to create a clear and concise project outline and instructions - Familiarity with safety protocols for science experiments - Excellent communication skills for ongoing collaboration and updates.
I have attached an Excel spreadsheet. There are 5 tabs. The first tab (called "Config & Matrix") needs to calculate predicted construction completion dates for plot/construction stage combinations (the current predicted construction dates (highlighted in yellow) just contain basic formulas). The formulas that you create will need to take into account the data on the "Project Setup+Management", "Contract Manager Portal" and "Site User Portal" tabs. The "Resource Data! tab can be ignored. If you look at each tab, you will see I have included cell descriptions and example entries. I have also attached a diagram to help you understand how the "Config & matrix" tab needs to calculate both the plot/stage dates...
...Functionalities: - Member Management: The app should efficiently handle all aspects of member tracking and management. - Event Scheduling: A user-friendly interface for scheduling club events. - Payment Processing: Secure and reliable methods for handling club fees and other payments. - Subscriber Card: A system for managing and validating subscriber cards. - Income Calculation: Automatically calculate income and required amounts. - Administrative Account: A dedicated account for administrators with enhanced privileges. - Work Team: A function for managing and coordinating the work team. User Roles: - Members: The general user base of the app. - Administrators: Users with the highest level of control and oversight. - Coaches: Users with privileges to manage and monitor training ...
I'm looking for a skilled Python developer who can create a script for me, which I can run on my local machine. The main aim of this script is to automate the process of generating Excel reports. Key Tasks: - The script should automate the generation of reports, saving me the time and effort of doing this manually. Ideal Skills: - Proficiency in Python is a must. - Prior experience in creating automation scripts would be highly beneficial. - Familiarity with Excel and its Python libraries (like pandas or openpyxl) is preferred. I would like to work with someone who can deliver a robust and efficient script that meets these requirements.
I'm seeking an experienced UiPath developer to help me automate complex data entry tasks. The automation will primarily involve: We will be having more than 100 Invoice formats. The system should automatically read these formats and write into excel csv file. Ideally, the freelancer should have extensive experience with UiPath, a deep understanding of data manipulation processes, and a proven track record of automating tasks across web-based applications and database systems. Proficiency in these areas will be crucial for the successful completion of this project. The estimated volume of data for automation is medium. The system should support template-based extraction for data extraction. The automation should run hourly. The system should log errors and continue with the...
...Impenetrable Door" A wealthy recluse is found dead in a locked, secure room with no apparent way for the killer to enter or exit. The detective must unravel the secrets of the room and its occupants. Here’s a detailed outline of 25 chapters for "The Locked Room Mystery: Secrets Behind the Impenetrable Door": Part 1: The Setup The Invitation: The reclusive millionaire, Elliot Grayson, invites a small group of acquaintances to his mansion for a weekend gathering. Each guest has a complicated history with him. The Arrival: The guests arrive at the sprawling, isolated mansion, each with their own secrets and motives. The atmosphere is tense. The Tour: Grayson shows off his prized possession—a state-of-the-art, impenetrable vault room, which he claims is t...
...convert data in some documents. the project is divided in 2 phases. first has to be ready the first phase and then the 2nd phase. Phase 1: Document Generation Extracted data is required to generate: • Share Certificate- Contains 9 fields from the extracted data. • Share Ledger- Contains 12 fields of which 9 fields are in the same as the Share Certificate. • Data extraction from agreements • Excel formatting or a structured table. • Automatic document generation (Share Certificate & Share Ledger in PDF) • Automatic Document Filing • Automatic emailing of Specific Documents Two level logins A. Mester login B. User login • Upload folders of the documents • Download share certificate & share ledger • View ...
...using innovative methods including activity based learning, role plays, experiential learning and sports for development techniques and consistently evaluate the quality and impact of training • Maintain reports and run the content on internal systems • Evaluating and grading training assignments of trainees and conducting feedback. • Categorizing the areas of improvement at an individual level or group level • Promoting an open knowledge-sharing environment that builds knowledge, skills, and service for the benefit of the organization as a whole. • Create and maintain a positive and professional learning environment • Increase student skills and ability to meet the needs of corporate placement • Assisting students one to one in learning &bull...
I need a method or script to send bulk SMS messages from a phone number located in another country. The phone can be accessed through Google Messages for Web. The phone numbers list where we have to send the message are listed in an Excel sheet. The ideal solution should be easy to use and not overly complicated. Key Requirements: - A simple method or script to send SMS in bulk. - The solution should not be overly complex or difficult to use.
I'm looking for a skilled professional who can automate the trend analysis of stock data in Excel, using Python or other suitable tools. Key Tasks: - Automate data analysis in Excel - Sheet1 data automate copy sheet 2 every minute -Sheet 1 data copy every minute to sheet 2(column F of sheet1) and sheet 4 (column O of sheet 4) as per upload sheet
System Overview The GASS System is a comprehensive data collection and analytics platform bui...supports: API uploads to connect external websites. Live database connections for seamless data transfer. File uploads (CSV, Excel, SQL, WHONET/FTP) with field mapping. Dashboard for monitoring connection status and data transmission. DASHBOARD – A visual analytics platform for managing and analyzing collected data. Features include: Sector & Subcategory Management – Organize data by category. Indicators & Custom Scripts – Define custom calculations and display results in charts or tables. Advanced Form Builder – Supports Skip Logic & Repeatable Elements for dynamic form behavior. Real-Time Alerts & Reports – Automated notificat...
...not met, there must be steps met, and if not, the moderator gets to choose specific consequences for the specific tribe member… SO CREATE A CONSEQUENCE FOR EVERY PLAN STEP if NOT MET! *** So based on the rules set consequences on the plan... Also make sure to create expectations and rule DROP DOWN BUTTONS so that the tribe members can easily see it Self-rating feature Based on complete steps calculate the progress made by dividing DONE steps by total steps and reflect that in the progress bar Create a plan feature When creating a plan, I want to make sure that they get access to ChatGPT for ideas, as well as people for brainstorming or networking a topic of discussion… Then you can save your plan or summon someone to suggest you specific tips for your plan or even...
I'm looking for an Excel expert to help me set up a task tracking sheet in Excel 2010. The sheet will be used to track team assignments and should include color coding based on team members. Ideal candidates will have: - Proficiency in Excel 2010 - Experience with creating task tracking systems - Ability to work with Arabic language settings - Creativity in color coding systems The final product should be a functional and visually clear task tracker.
I'm looking for a professional to convert my Microsoft Excel project schedule into MS Project. The excel schedule has 675 rows, including headers. The purpose of this conversion is to enable better tracking of the project. 500 rows are the same 4 or 5 tasks with a different identifier and schedule start/end. Not entering any resources or predecessor or successor but need the columns available for me to add later. Looking to have a 2-5 hour turn around. Details: - The current Excel schedule is moderate, repetitive task structure - This is a one-time conversion, I don't need to update the schedule in MS Project regularly. Ideal Skills: - Proficiency in Microsoft Excel and MS Project. - Attention to detail to ensure all tasks and dependencies are accur...
I have an Excel file containing 248 medical records. I need a freelancer to compute and add three new columns: BMI, BMI Category, and bp_category (blood pressure). Your Responsibilities: - Use the existing weight and height data to calculate BMI. - Research and apply the standard BMI categories. - Utilize the systolic and diastolic blood pressure data to create the bp_category. - Ensure the output file is in Excel (.xlsx) format. Ideal Skills and Experience: - Proficiency in Excel. - Understanding of health metrics and categories. - Experience with data analysis. - Ability to deliver high-quality work promptly. I am looking for a quick turnaround on this task. The successful completion of this project could lead to further opportunities.
Please Sign Up or Login to see details.
I'm looking for an expert in social media marketing who can help me launch a Facebook group and its associated page centered around the theme of Travel and Adventure. The goal is to grow the audience of both from zero. Key Tasks: - Create a Facebook group and page focused on Travel and Adventure. - Implement growth strategies to build an audience targeting primarily the 36-50 age group. - Regularly post engaging content, predominantly photos and videos, to stimulate interest and interaction. - Develop a content calendar to ensure regular and diverse postings. - Recruit new members through targeted outreach. Ideal Skills: - Proven experience in social media marketing, particularly with Facebook. - Strong understanding of the Travel and Adventure niche. - Ability ...
I need a Python script that can transform data from one Excel sheet with multiple rows into another Excel sheet. The output should create one individual sheet per row. There is a certain format in the output excel sheet. Key requirements: - The ideal candidate should have extensive experience with Python and Excel. - Knowledge of data manipulation and organization is crucial. - able to work immediately with tight deadline
I need a freelancer to create 5 reports in an MS Access Database as per pdf and implement a data entry option as per excel. database, pdf and excel sheets are attached
I am seeking a data expert with strong experience in exploratory data analysis (EDA) and predictive modelling. The primary goal of this project is to identify key patterns in my data. Ideal Skills: - Expertise in EDA and predictive modelling - Proficiency with data analysis software (e.g., Python, R, Excel) - Strong statistical background - Excellent problem-solving skills - Ability to interpret complex data sets Please note that some details about the data types and visualization methods have not been determined yet. Flexibility and adaptability will be key in this project.
...focusing on education and literacy issues. The film's primary objective is to raise awareness about the challenges faced in this area. Key Aspects: - The documentary should highlight the current state of education and literacy in rural Raigad, showcasing personal stories and local culture. - The target audience is primarily local residents, so the film should be relatable and accessible to this group. Ideal Skills and Experience: - Proven experience in documentary filmmaking. - Excellent storytelling skills. - A deep understanding of, and sensitivity towards, social issues. - Ability to connect with and represent local voices. - Experience filming in rural and remote areas. - Proficiency in the local language(s) of Raigad. - Demonstrated cultural sensitivity and awareness...
...direct marketing to sell a revolutionary veterinary medicine that restores damaged heart tissue in dogs. This proven bio innovation has already saved over 2,800 dogs suffering from heart failure, and there are thousands more who urgently need it. Your Role: Develop and execute a direct sales strategy to connect with dog owners globally. Find and reach potential customers through email scraping, group moderators, and targeted profiles. Build a system to communicate directly with dog owners in need. Work independently to generate and close sales. Why This Opportunity is Unique: The product is available and highly effective. The target audience is easy to find (dog owners united in communities). There is a huge market demand with thousands of dog owners actively searching for...
MAGENTO 2 EXPERT MAGENTO 2 ATTRIBUTES EXPERT MAGENTO 2 "ATTRIBUTE SET" EXPERT MAGENTO 2 PRICE RULE EXPERT PRODUCTS IMPORT EXPERT EXCEL EXPERT Please do not bid if you're not a genuine expert that can import thousands of products every week. Tasks and Responsibilities: - Be super organized. We will be sending you documents: please sort them in a way that will make it easy for you to revert to these documents whenever needed. We use Office 365 / OneDrive to organize our documents. - You will be importing using excel or CSV or, if you're a true expert: you may even use XML. You will need to maintain these files. If we find out that an attribute was not defined, we want to make sure it will be easy for you to add the attribute and reimport the pro...
Looking for Virtual Assistants who has the following skills: - Good with excel - High attention to details - Is smart & fast in their work - Self learner & able to follow user guides - Meet deadlines - Proactive & willing to go the extra mile - Freshers can also apply Job Responsibility: - Data Entry & basic admin tasks - Do some research jobs related to products and purchase - Online search for suppliers/ whole sellers/ manufacturer who can give quality products at a very competitive price If you are interested, then Please carefully review the provided information and add the word "Rainbow" at the beginning of your cover letter. Also, share your response to the below questions. 1) What commitments do you have right now? Are you employed? Student? Freela...
I'm looking for a skilled graphic designer who can create a new, modern logo for my brand. The logo should incorporate both text and an icon. The name of the company is : "INTERSTATE CAPITAL GROUP, LLC" - this is an investment firm /business firm. Key Requirements: - Experience in designing logos - Strong understanding of modern design principles - Ability to create both text and icon components seamlessly Since I'm open to suggestions for color schemes, a designer with a good eye for color and current design trends would be highly beneficial. Please share your portfolio showcasing your previous logo designs.
...issues before they affect users. Key Requirements: - Proficiency in Java and Selenium is mandatory - Prior experience in performing regression tests - Capability to conduct tests on Chrome browser - Understanding of data creation through API - Proficient in data writing and extraction from excel/CSV - Ability to utilize Data Provider - Familiarity with Page Object Model - Familiarity with version control systems like Git Testing Focus: - Functional tests - UI tests Data Interaction: - API responses - Excel/CSV files The ideal candidate will be detail-oriented, capable of developing comprehensive test cases, and able to communicate findings clearly and effectively. The regression testing needs to be completed within 1 week. Automated reports post-testing: Already exte...
Logo Design Needed for A Cappella Group in San Francisco ## Project Overview Looking for a talented designer to create a modern, dual-format logo for our San Francisco-based female a cappella group. We need 3 versions: 1. A primary logo featuring our full name "The Loose Interpretations" 2. A secondary, compact version with our nickname "The Loosies" 3. A third, even smaller version with just an “L” ## Style Requirements - Clean, contemporary design (no frilly or curly fonts) - Fun and playful while maintaining professionalism - Timeless appeal that won't quickly date - Should work well in both color and black/white - Must be legible at various sizes (social media to merchandise) ## Brand Personality - Professional performers with a pla...
I'm in need...designed to have the following features: - Integration with an email marketing platform to engage with potential customers and keep them updated on new products and promotions. Additionally, I require assistance with loading data from an Excel spreadsheet, which will contain product details, pricing and other relevant information. Ideal candidates for this project should have: - Extensive experience with Shopify and e-commerce website development. - Proven track record in creating platforms for digital product sales. - Proficiency in data migration from Excel to a web platform. - Knowledge and experience in integrating email marketing tools into e-commerce sites. Please bid if you are capable of delivering a high-quality, user-friendly website tailored...
I need a skilled graphic designer who can create an engaging flyer for a product advertisement. it is a two-page flyer focusing on Australian product including probiotics The Target group is an area called Lane Cove, and it offers a discount The flyer will be focused on promoting our line of vitamins to a specific demographic within our local community. Image of products, a key point is provided. The main message of the flyer will be to encourage potential customers to buy our product. Your design should effectively reach and appeal to our targeted location-based group, compellingly promoting our product.
I'm looking for a talented graphic designer to create a flyer for product advertisement. This flyer needs to be tailored to a specific demographic group located in our local community. Key Requirements: - Understanding of design principles and marketing strategies - Ability to create visually appealing and persuasive designs - Experience with designing for specific demographic and location-based groups Ideal Skills: - Graphic Design - Marketing - Demographic Analysis - Adobe Creative Suite (or similar design software) Your design should effectively reach and appeal to our targeted location-based group, promoting our product in a compelling way.
...and defence organizations, industrial and manufacturing companies, and retail and wholesale businesses. Collect key company details, including business name, industry category, business size, location, business website, key contact person, phone number and email, current container supplier if known, and potential container needs such as hire, sales, or modifications. Data Format: Preferably in Excel. Data Sources: Online research using Google, LinkedIn, and business directories, as well as industry databases if accessible. Ideal Freelancer: Experience in lead generation, data scraping, or business research. Strong attention to detail and ability to verify accurate contact information. Ability to organize data clearly and logically. This will be an ongoing project, so there is...
...Rebuilding Lives" () A symbolic and powerful composition illustrating refugees being supported through collective effort. Abstract figures joining hands to form a network of care, support, and empowerment. Visual metaphors of rebuilding (e.g., hands forming a home, a bridge, or lifting one another). The tone should be hopeful, warm, and inviting, conveying that Amamericana provides a foundation for a fresh start. 2. "Fishing as a Livelihood" () Depicts Venezuelan refugees in Peru learning or working in the fishing industry. The focus is on economic empowerment, showing refugees acquiring skills to sustain themselves. Two variations to choose from: a) A refugee being taught by a local fisherman. b) A group of refugees working together, casting
I have a group photo taken during an evening out that needs some professional touch. The faces in the photo are the most crucial elements, and I would like to see enhancements in brightness and contrast to make everyone look their best. Ultimately, I want this photo to become a cherished memory of our evening, so I'm open to adding vibrant colors to the photo. Ideal skills and experience for this job include: - Expertise in photo editing software (e.g., Photoshop, Lightroom) - Experience in portrait enhancements - Ability to apply creative colorizations - Strong attention to detail - Proficient in making precise lighting adjustments to improve consistency. - Expertise in reducing noise and grain from low-light photos.
I'm seeking a professional who can develop a database that...develop a database that automates the creation of quotations. The database will need to include product type, description, purchase cost, and selling cost. What I can provide: - My existing purchase invoices, all in Excel. This data will need to be extracted and included within the database. - The database should be set up to allow for the automated import of new product data from Excel. What the automated quotations should include: - Product details - Total cost - Client information Ideal skills for this project include: - Expertise in database creation - Proficiency in Excel - Experience with automation - Understanding of quotation systems - Ability to extract and interpret data from invoices I lo...
I require an experienced Excel expert to develop an equipment finance calculator for me. The calculator must allow for adjustments to be made on the following parameters: - Interest rate - Brokerage fee - Loan duration - Balloon payments - Principal amount: Input field to specify the initial loan amount. - Payment frequency: Option to select how often payments are made (e.g., monthly, quarterly). - Down payment: Input field to specify any upfront payment made at the time of purchase. The calculator will be used on a Windows operating system. Therefore, it should be designed accordingly. Ideal candidates for this project should have a strong background in finance and excel, with experience in creating finance-related tools on Excel. Please ensure your bid reflects yo...
...need of a skilled professional who can assist me with an urgent task tonight involving Excel spreadsheets. The project consists of mail merging my Excel spreadsheets into PDF forms. The PDFs will require incorporation of web links and images, specifically, logos embedded in the PDFs and web links incorporated into the PDFs as QR codes and bar codes generated for each entry. Ideal Skills: - Expertise in Excel - Proficiency in PDF conversion - Ability to meet tight deadlines - Attention to detail - Proficiency in Mail Merge - Experience in generating and embedding QR codes within PDFs. -Experience in importing graphics - Experience generating bar codes The PDF forms should include specific fields from the Excel spreadsheet. The QR codes should link to the web...
I need an Excel expert to organize and combine two Excel sheets, approximately <2K rows each, containing contact information (Names, Emails, Phones, Addresses). Key Requirements: - Cleanup and organization of two Excel sheets - Incorporate an 'Address 2' column: Move apartment/suite numbers to 'Address 2' - Create copies of rows with a secondary email, using the text before '@' as the first name, while keeping other contact details consistent - Data deduplication across 20 existing columns - Sorting the data in an Alpha Numeric order by Company Name post-cleanup - Ensuring column titles remain consistent - Combine records with identical names, ensuring that the most complete information is retained. - Standardize the format of phone n...
I'm looking for an expert in social media marketing who can help me launch a Facebook group and its associated page centered around the theme of Travel and Adventure. The goal is to grow the audience of both from zero. Key Tasks: - Create a Facebook group and page focused on Travel and Adventure. - Implement growth strategies to build an audience targeting primarily the 36-50 age group. - Regularly post engaging content, predominantly photos and videos, to stimulate interest and interaction. - Develop a content calendar to ensure regular and diverse postings. - Recruit new members through targeted outreach. Ideal Skills: - Proven experience in social media marketing, particularly with Facebook. - Strong understanding of the Travel and Adventure niche. - Ability ...
My Linux system refuses to boot and is stuck in a boot loop. I've already tried troubleshooting with a different monitor, but to no avail. Ideal Skills: - Deep knowledge of Linux systems. - Proven experience in system recovery. - Strong problem-solving skills. Your task will be to diagnose the issue and restore my system to working condition. Please only apply if you have the necessary expertise and experience.
...Examples: clients would be able to link to such information as: their contract with me, their end of the month investment returns, our recent meeting notes, investment strategy currently in place, etc, etc, etc. …modifications by me monthly. • Files would be downloadable or just content that I might paste into WordPress as a “custom post type” • Upon clicking on the hyperlink, a PDF or possibly Excel file would pop-up • I would upload these updated documents myself – as stated, regularly. 3. Enable me to upload other general (not client specific) documents, such as monthly newsletters, easily. I have never been comfortable with the WordPress facility for this. In connection with the above, I desire the developer to instruct me how to do th...
We are looking for a Virtual Assistant who can manage tasks that we have pending for some assignments to facilitate the proper functioning of our guidelines. Requirements: - Speak Spanish -Have basic computer knowledge. -Excel Basic. -Puntuality. We offer stable work, since we have a good list of tasks to perform an. Whatapp no: +1(289)535‑3721
I need a professional photo editor to crop two photos for me. This is for my grandmother’s funeral, one for the program sheet, other for the picture next to the casket. The main goal is to remove background distractions while keeping only essential elements of the environment. The focal point in these photos is a person or group of people, which should be retained. Ideal Skills: - Proficient in photo editing software - Keen eye for composition - Experience in removing background distractions
I'm in need of an expert in MS Power BI who can help me create a das...me create a dashboard tailored for customer insights analysis. This dashboard will primarily connect to various Excel/CSV files, so proficiency in handling and integrating these data sources is crucial. Key Requirements: - Expertise in MS Power BI - Experience in creating customer-centric dashboards - Proficiency in connecting Excel/CSV files to Power BI - Ability to customize subsets and output data as needed Visualizations: The dashboard should predominantly feature bar charts and pie charts. Therefore, experience and skill in designing these specific types of visualizations in Power BI is important. Ideal Skills: - MS Power BI - Data Analysis - Visualization Design - Excel/CSV Data Handl...
I need a solution to automatically save all my WhatsApp messages into a Google Sheet. Key Requirements: - Capture all messages from WhatsApp, regardless of sender - Log messages into the Google Sheet every hour - Record the sender's name, the message's timestamp, and the message content , and the chat group - Use a normal WhatsApp number (not a business account) Ideal Skills and Experience: - Proficient in using and scripting for Google Sheets - Experience with WhatsApp automation - Skills in Python or javascript programming language - Familiarity with APIs and web automation tools - Capable of setting up a real-time logging system - Please note, this project requires a high level of attention to detail and consistency. Please use reliable method do...
I'm looking for a vibrant, engaging flyer and potentially a larger poster to promote a youth speech contest aimed at teens aged 13-17. The primary goal is to attract participants, so the design should be fun and colorful, appealing to this age group. Key Requirements: - Graphic design skills, particularly in creating youth-oriented materials - Experience in designing print-ready flyers and posters - Ability to convey event details clearly and engagingly Please provide examples of similar work you have done in the past.
...involving Excel spreadsheets. The project consists of mail merging my Excel spreadsheets into PDF forms. The PDFs will require incorporation of web links and images, specifically, logos embedded in the PDFs and web links incorporated into the PDFs as QR codes. This is a very easy task and if done well much more work will follow. Ideal Skills: - Expertise in Excel - Proficiency in PDF conversion - Ability to meet tight deadlines - Attention to detail - Proficiency in Mail Merge The PDF forms should include specific fields from the Excel spreadsheet. Please, bid only if you can deliver step 1 tonight. Thank you. The QR codes should link to the website. The PDFs should follow custom branding guidelines provided by the client. The PDF forms should include t...
...Guidelines for Contestants ? ✅ Logo Details Brand Name: ANS Music Company Type: Digital Content Distribution ? Logo Style Preference We want a modern, minimalistic, and meaningful logo that reflects our brand identity. The logo should represent music and video distribution while maintaining a premium and professional look. You may follow inspiration from these brands: Label Engine FUGA INgrooves Music Group Soundrop Identity Music ? Key Requirements ✔️ Logo Type: You can choose between an icon-based logo, a text-based logo, or a combination of both. However, the icon is the most important element as it will be used for the Android app. ✔️ Minimal & Premium Feel: Avoid overly complicated designs. A clean, simple, and elegant design will be preferred. ✔️ Color Scheme: You are ...
...Manage both Display and Search Ads - Develop tools and ideas to target a detailed and technical audience (this is very important, our target audience is no more than 10'000 people max, general interests will not be enough, we need to find the audience based on the past searches or visited website). Of all the points this is the most important, PM me with your approach on how to target a specific group of HVAC engineers. Ability to display ads to people according to their search history or visited past websites will be key to the success of this project, PM only if you know a way to do this. Sending the proposal for the how-to as well as your ads portfolio will be basic requirement. If you don't provide this, it means that you have not read this and your bid will be binn...