...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
Please check which is more appropriate translation? English: New translation: ①뜨거운 물을 찻잔에 부어 식히세요. ②찻잎을 안에 넣으세요. ③식힌 물을 다시 찻주전자에 넣으세요. ④잠깐 기다리세요. ⑤마지막 한방울까지 균등하게 찻잔에 따라주세요. Original text: see the "How to brew perfect Japanese tea"
I need a data entry specialist to clean a dataset to be used for reporting and analys...the inconsistencies, errors, and duplicates in the dataset to make it suitable for reporting and analysis purposes - Ensuring the dataset is properly formatted and organized for its intended use Skills and Experience: - Proficient in data cleaning with a keen eye for detail - Experience with Excel and data entry is a huge plus - Strong understanding of data maintenance and organization - Ability to follow data cleaning guidelines and ensure data integrity The final dataset should be delivered in Excel format. The successful candidate for this job will have a deep understanding of data cleaning, excellent attention to detail, and the ability to deliver a clean dataset suitable for report...
I am in need of a skilled professional who can create office graphic templates (crtx) for Microsoft PowerPoint, MS Word and MS Excel. One template set for all MS Office 365 programs. The templates I require are specifically for charts and graphs, in order to enhance the visual appeal of my internal company reports. Ideal skills and experience required for this project include: - Proficiency in MS Office 365 - Strong understanding of data visualization and graphic design based on our Brand Guidelines - Prior experience creating templates for internal company reports is a plus, though not mandatory. Please provide samples of your previous work in this area when applying.
I need a customized formula in an Excel spreadsheet to calculate different rates based on the day of the week. Here are my specific requirements: - The formula should apply different rates for weekdays, Saturdays, Sundays, and Public Holidays. These rates are as follows: - Weekdays: $30.10 - Saturdays: $36.12 - Sundays: $42.14 - Public Holidays: $60.20 - This calculation must be flexible and able to automatically adjust to the specific day in the date field. We will also add another box that adds11% to the total figures. Ideal Skills and Experience: - Proficiency in Microsoft Excel and its formula creation. - Experience in creating custom Excel formulas to calculate based on specific conditions. - Attention to detail to ensure the accuracy and functional...
i looking for old silver thai coins (such as 1 baht coins from the 1800s and early 1900s and so on) and so i need a native thai person who lives in thailand, preferably bangkok, to find some reputable coin shops or people that sell genuine old thai silver coins, that are not fakes. i would also like to get some photos of some of the coins and their prices. the shops should have a good reputation as selling genuine coins, not fakes. i woud also like to know if they sell only ungraded coins or professionally graded coins, which are in plastic coin holders called slabs, which are plastic coin holders with a grade marked on them. so i would like : 1. identify good trustworthy coin shops or coin sellers that sell old thai coins (only thai sellers) 2. get pics of some of the silver coins and th...
I urgently need an Excel whiz capable of converting Word documents, PDF files, and other document files into Excel, as soon as possible. There are no specific formatting requisites for the Excel files post-conversion. Ideal Skills: - Proficiency in Word, PDF, and other file formats - Excellent Excel skills, with ability to handle any type of conversion - High attention to detail - Strong commitment to speed and accuracy - Readily available for immediate start Experience in similar rapid file conversion projects will be highly advantageous. Plese ensure you can fulfil the requirement for immediate turnaround before placing your bid.
I'm in need of a Power Automate expert who can create a workflow system for me. This project involves getting tasks from rows in Excel and mapping them to individual tasks on a Planner board. Ideally, each row in Excel would correspond to a separate task on the Planner board. Skills & Experience: - Mastery in Power Automate - Solid experience with workflow creation - Strong knowledge in data management - Familiarity with Excel and Planner integration - Ability to deliver tasks promptly and accurately Your job is to ensure a seamless process of data management, with all tasks neatly organized and displayed on the Planner board. With your help, task automation will come to life, enhancing my productivity level.
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'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking...Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database management a...
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...
I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficiently and effectively will be highly regarded.
I am an emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into meaningful analysis - Opportunities t...
...aesthetic should be simple yet captivating, mainly focusing on blue, white, and black palettes. Watermarked images are encouraged. Posts will be focused heavily on photos. I have attached some examples below as well as our company name and graphic to possibly be included on posts. We would like to have an overall theme for every post. Key Elements: - Despite the user not selecting any specific template designs, your creative acumen to propose a diverse mix of templates is welcome. - The templates should effectively communicate our company's values and mission, depict the benefits of our products and services, and provide industry insights and education. - Keep in mind that these templates need to cater to a varied audience; general public, industry professionals, and potent...
I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so experience with this type of formatting is an...
hello, there, We need some Native Austrian and German to do a recording task, they are short sentences, the recording would take you about 15 minutes the speakers need to be: -Age from 18-55, Both professional voiceover or amateur -Equipment: You ju...You just need to have a good phone. The recording script is in our recording app so you will need to download our recording app and then use task name we provide to log in and record. -Envrionment: Please record in a quiet room, no echo, no other noise like birds noise, car noise and so on. Don't need to use earphone or bluetooth. -Pronunciaiton: we will provide a few sample audios for you to check the pronunciation we need, you need to listen them first before starting the recording task If you are interested in it, please con...
Create a PDF and Excel exporter download for both tabs Specifications and Questions (8hours) (160 USD) Layout for the mains page (4 hours) (80 USD) Documentations (1 hour) (20 USD) Plugins (16 USD Excel) you will buy directly from Bubble in your account Plugin (100 USD PDF) there is al alternative plugin (20 USD)you will buy directly from Bubble in your account
I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for an experienced Excel user.
...profile and goals. - Targeted and filtered search - Send LinkedIn messages to recruiters and hiring managers to express my interest and inquire about potential job opportunities. - Utilize my email to contact potential employers if required. - Compensation and Bonuses available if job is secured** discussed during interview - Track job applications and other information via google spreadsheet template I created Ideal Candidate: - Proficient in resume writing, LinkedIn profile enhancement, and cover letter customization. - Familiarity with job search strategies and recruitment processes. - Excellent communication skills, particularly in writing compelling and professional messages. - Previous experience in job search assistance and recruiter outreach will be highly valued. - Pr...
I'm in need of an expert who can create a custom education and training platform that mirrors the functionalities and user experience of platforms like Udemy. Basic programming language php laravel.11 Key Features: - Course Creation Tools: I need the system to have user-friendly tools to enable easy content creation and upda... Terms of use and privacy page Contact us page Prevent downloading or screen recording of paid content There are two types of subscriptions: lifetime subscriptions, and subscriptions that expire on a date specified by the administrator The supervisor determines the trainer's commission through an electronic record for each course The same online site is available to see and check If you have a ready-made website, send the link...
...integration with QuickBooks Online. CURRENT: We have a QuickBooks Online application that syncs invoices from QuickBooks Online to two MySQL database tables (order headers and order lines). This application works correctly but we want to add a condition to the INSERT statement in this program so only invoices that have a custom field populated will get synced to these tables. The custom field name to check is "Online Order Number". Requirements: - Modify functionality of existing program to only INSERT records to MySQL table when invoice record contains a value in custom field "Online Order Number" The ideal freelancer for this project should have: - Proven experience working with PHP, particularly in customizing and enhancing applications. - A solid under...
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I am starting a business offering Excel and typing services and require a freelancer's expertise to assist with setting up my business structure and developing a strategy to acquire clients. The ideal candidate should have: - Experience in business consultancy, particularly in setting up new businesses. - Knowledge of legal and financial business structure requirements. - Proven strategies for client acquisition and marketing, especially for freelance or B2B services. - Ability to provide personalized advice for a startup in the data processing domain. The project will involve: - Assessing the best business structure for my services (Sole Proprietorship, LLC, etc.). - Guiding through the necessary legal and financial setup procedures. - Developing a clear and actionable clie...
I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends and changes over time...
I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.
Necessito que seja criada uma aplicação em angular. Não terá backend e sim apenas a construção do template em html. Já existe uma aplicação no ar, quero uma copia dessa aplicação em angular. A primeira tela segue em anexo e as demais passo após fechar.
I need a modern logo and business card design template for my business "Peak Point Branding". - I prefer the colors blue, green, and white for both the logo and the business card. I like light shades of these colors. - The style and theme of the design should be modern. - The target audience for my business are professionals. Ideal Skills and Experience: - Graphic Design: You should have experience in designing modern, professional logos and business cards. - Understanding of Color Psychology: Knowledge of how different colors can influence the audience is a plus. - Branding Experience: Experience designing for professional target audiences will be highly valued. Please make sure to provide a portfolio of your design work, particularly any previous examples of modern...
business profit loss reporting excel(Jan, Feb & March)
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...
...business. Key Deliverables: - Brand colors and fonts - Logo design concept - Logo Variations (dark, light, transparent background, etc) - Favicon - Typography **Scope of Work:** - The design should be elegant and sophisticated, reflecting the premium nature of my brand. - The kit will be used across various platforms, including the website and social media pages. - We have the basic design template for the main logo, and will attach the file - We also need one additional image created that will be the front label of our product named "Goddesses Nectar" The ideal candidate should have: - Proven experience in branding and logo design, preferably within the sophisticated style - Strong understanding of color theory and typography - Ability to work with brand guidelin...
I'm in need of a talented and experienced email template designer who can create a series of 6-10 templates for me. These templates will be used for a variety of purposes, including marketing campaigns, transactional notifications, and newsletters. Key requirements include: - Designing a total of 6-10 email templates - Creating templates that are visually appealing and on-brand - Ensuring the templates are responsive and compatible with Campaign Monitor - Incorporating elements that drive engagement, such as clear call-to-action buttons and concise yet impactful content Ideal candidates should have: - Demonstrable experience in designing email templates - A strong portfolio of past work, preferably including templates for marketing, transactional, and newsletter purposes - P...
As a tax accounting firm, we need a modern and minimalist brochure/front page template created on Canva. This design will be a vital part of our client communications, underlining our commitment to transparency and professional service. Key Features: - The template needs to have individual fields for 'Client Name', 'Financial Summary', and 'Tax Advice Tips' & a 'performance graph'. - The design should embody a modern and minimalist aesthetic, reflecting our firm's expertise and reliable standing. - We would want the content creator to assist in creating the content. Then we would want generic fields or a pivot table to input data that then flows to the brochure/template. So that each client receives a personalis...
...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I'm in need of a talented developer who can help me with implementing server-side rendering for my website. Website not rendering html right now so need to do server-side rendering. You are good if you can do that through anydesk or teamviewer. Yes, i can work with new freelancers, Just send me github profile so i can check what you've done. Start your application with "SSR", all other will be ignored.
I'm looking for a designer to create four unique card templates for my fantasy trading card game. Please note that these designs should vary in rarity, with four different grades. Requirements: - The card templates should have a cartoonish art style. - Each card template should include: - A designated area for a character portrait. This should be distinct and easily distinguishable from the other elements on the card. - A section to display the character's stats. These stats should be prominent and easily readable. This area should only need space for 2 numbers. - An area for the character's abilities. This text section should be carefully designed to make the abilities stand out. Ideal candidates should have experience in: - Designing for trading card game...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I have less than 100 pages of handwritten medical notes that I need transcribed into a custom template. This project is urgent, and I require the completed transcription in less than a week. Please read this entire ad before replying. NOT FOR AUTOMATED - hand transcribing job. Key Requirements: - Transcription of less than 100 pages of handwritten medical notes and computer printouts. - Custom template formatting (specific layout or structure) - Urgent turnaround time of less than a week Ideal Skills and Experience: - Experience in medical transcription to ensure accuracy and understanding of terminology - Proficiency in creating and working with custom templates - Ability to work under pressure and meet tight deadlines So that I know you are a real person and read this,...
I am looking for a skilled developer to create an engaging Employee Pre-Verification system. This system will focus on Background check and Referral check. Key Functionalities: - **Background Check**: This system should have the ability to conduct background checks on potential employees. This can involve checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The system should generate reports in t...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
We want to delelop a cibersecurity software/app to Sell to other companies that can check each computer and device, as also as detect treaths to the company network/devices like e-mails, apps, and suspicious content that puts the company security in Treath.
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
NOTE: MUST SUBMIT AN ACTUAL HIGH-LEVEL STRATEGY AND PLAN. I'm looking for a skilled marketing strategist who can help my company, Harmoni Innovative Tiny Homes, with our new venture: organizing date nights in our RVs. Check out Harmoni (our RV). She will be redecorated to align with our new marketing plan. Target Audience: - Young couples - Empty nesters - Adventurous singles - New couples Key Requirements: 1. Marketing Strategy: -Name (ex: Harmoni Dates/Love Camper...) -We need a comprehensive, innovative marketing strategy that appeals to our target audience. - This strategy should emphasize: - Brand awareness - Generating website traffic - Driving bookings and reservations. 2. Marketing Channels: - I would
I'm looking for a professional who can assist me in automating the employment verification process, specifically for background checks. The system should require minimal human intervention. Key requirements: - The verification data should be collected through online forms. - The process should be fully automated, requiring as little manual intervention a...of the information collected. - The verification process should be optimized for background checks. Ideal skills for this job include: - Experience in software development or automation, particularly in data collection and processing. - A background in data security and privacy, as this is crucial for the handling of sensitive employment verification information. - Familiarity with background check processes is a plus, but...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • Potenti...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
...then coping the rest of the text into our format. We would want to be able for the AI to use the template we create and it check it each time to make sure we havent updated anything. We would drop the resume / CV into one folder then it would be added to another folder formatted. Ideal Skills and Experience: - Strong background in AI and Machine Learning - Experience in NLP and chatbot development - Proficiency in creating customizable sections for user-friendly interfaces - Understanding of how to analyze user's skills for personalized output Key Deliverables: - Implementation of an automatic template selection feature - Ensuring that the AI adequately analyzes user's skills for template selection - Testing and refining the algorithm to optimi...
