Vba excel date format date jobs

I would like a script that will analyse the dataset and return  Open_range, Long_trade and Sell_trade profit to an Excel file. First, you need to define variables: Start_time = 17:05 End_time = 18:00 Open_range_high = High (at Start_time)  Open_range_low = Low (at Start_time) Long_trade_stop_loss = Open_range_high Sell_trade_stop_loss = Open_range_low Stop_loss_to_be= Open_range_high or Open_range_low + Open_range Time range: 17:05–18:00 for every day To calculate open_range, use high and low (at 17:05) and return the difference in points. Time High Low Open_range 31/05/2023 17:05 1833 1831.5 Start_time 1.5 The CSV file contains price series at a 5-minute interval. Time-High-Low  Time High Low 31/05/2023 17:05 1833 1831.5 Start_time 31/05/2023 ...

I need a data entry specialist who is proficient in extracting information from PDF files. The goal is to accurately compile text and numerical data into a manageable format. This project involves: - Extracting data from 100 to 500 PDF resources. - Capturing both textual and numerical data. - Ensuring accuracy and integrity of the data entered. Ideal skills and experience for this project should include: - Proven experience in data entry. - Skills in using data entry software. - A keen eye for detail to ensure precision. - Familiarity with handling PDF files.

Hello! My name is Elena. I work for consulting agency Markswebb and looking for someone who...applications. Our new project is related to a study of banking services in the UAE, and we are looking for respondents to conduct interviews. During the interview, we would like to learn about your experience of using mobile banking in the UAE, talk about your impressions and habits, without touching on details about your finances or any confidential information. The interview will be in the format of a Zoom call or Google Meet, lasting up to 1.5 hour Markswebb is consulting agency that has more than 12 years of experience in digital research. We conducted researches for clients in Russia, Europe, Asia and CIS. You can learn more about agency’s work by following the link

I'm looking for an expert to convert my existing Microsoft Excel Macro into a Google Sheet function with some added enhancements. The key enhancement is auto sorting on the newly created worksheets. The sort should utilize multiple columns, each with a unique order, either ascending or descending. Indispensable Skills: - Proficiency in Excel and Google Sheets - Familiarity with Macros and Google Scripts - Strong attention to detail, especially with data sorting and organization When you bid for this project, please say your opening comment as "Convert Excel Macro to Google Sheet Guru" - this way we will know who had done auto bidding and who has actually bothered to read out requirements. This job should be pretty easy and straight forward for some...

...creating elegant and unique logos for technology brands. Key Aspects: - Logo to be a mix of text and icon - Preferably in green and orange colors - Should reflect our technology business - Unique, modern, and instantly recognizable design About Brand, App Name: KrushiHari Description: Looking for a talented logo designer for KrushiHari, an innovative application designed to keep farmers up to date with the market. The app provides farmers with the latest updates, product prices, and a platform to sell their products. We need a logo that reflects this concept, incorporating innovative icons and designs. Originality is key, as no copied or generic designs will be considered. Join us in creating a logo that will make a real impact in the agricultural sector! If your experience m...

Scriptwriters with a flair for comedy, drama, and action are required to provide dynamic and engaging stories for a radio-based format. Key Requirements: - A strong portfolio of past work - An understanding of narrative structure fitting for a radio presentation - Experience in crafting compelling characters within a short story format Potential candidates with a proven track record of high-quality scriptwriting would be considered more favorably. Ability to work with guidelines and adapt to feedback is a major plus. This project offers a great opportunity for creative individuals passionate about radio drama and storytelling.

I'm in need of a meticulous professional skilled in data entry, particularly with numerical data, to populate an Excel spreadsheet for me. Key Tasks: - Processing a variety of numeric data - Entering this data accurately into an Excel spreadsheet - Categorizing and sorting this data by date Ideal Skills: - Excellent attention to detail - Ability to work with numerical data effectively - Proficiency in Excel - Data organization abilities - Ability to categorize and sort data in assigned order

I require a developer experienced with the MERN stack to implement a feature that allows bulk uploads using a CSV file into my application. This data must be val...validated, with certain criteria being checked before storing in the database. Key Tasks Include: - Creating functionality for bulk CSV upload. - Ensuring data is validated before storing. If any errors are found, notifications of these should be provided. - Validation must include checking that required fields are provided, the maximum character limit is not exceeded, and emails are in a valid format. Ideal skills include: - Prior experience with bulk data uploads. - Strong understanding of data validation techniques. - Experience with MERN Stack (MongoDB, , React.js, Node.js). - Familiarity with CSV data formatting.

need a skilled freelancer to conduct data analysis on an array of mixed data (both numerical and textual) using Excel. The data will be provided in CSV file format. This project requires a sound understanding of data analysis concepts and proficiency in the use of Excel or similar spreadsheet software. Key Responsibilities: • Convert CSV files into a usable format for Excel • Analyze the given mixed data • Generate comprehensive findings from the data Ideal Skills: • Familiarity with CSV files • Proficient in Excel/Google Sheets • Experience in data analysis • Detail-oriented and accurate data entry • Good communication skills to effectively summarize findings.

I need a skilled freelancer to conduct data analysis on an array of mixed data (both numerical and textual) using Excel. The data will be provided in CSV file format. This project requires a sound understanding of data analysis concepts and proficiency in the use of Excel or similar spreadsheet software. Key Responsibilities: • Convert CSV files into a usable format for Excel • Analyze the given mixed data • Generate comprehensive findings from the data Ideal Skills: • Familiarity with CSV files • Proficient in Excel/Google Sheets • Experience in data analysis • Detail-oriented and accurate data entry • Good communication skills to effectively summarize findings.

I am seeking a native Welsh speaker to meticulously go through a list of over 20k words, identifying and categorizing any toxic terms. This task intends to foster a safer user environment. The ideal freelancer will have excellent attention to detail, and experience in...list of over 20k words, identifying and categorizing any toxic terms. This task intends to foster a safer user environment. The ideal freelancer will have excellent attention to detail, and experience in content moderation would be advantageous. Key Deliverables: • Thorough scrutiny of the language list • Accurate identification and categorization of toxic terms • Output made in a spreadsheet format This meticulous work will contribute significantly to our cause of creating a user-friendly and resp...

Please Sign Up or Login to see details.

...strong focus on Wall Lamps, Chandeliers etc to create a couple of posts per day for my Instagram account. These posts will be used to promote the business. Key Responsibilities: - Creatively produce both image and video content that aligns to high-end, trending fashion topics. - Write compelling Instagram captions that perfectly complement each piece of content. - Curate and apply relevant, up-to-date hashtags to each post to maximize visibility and growth. - Create 2 posts per day with meaningful captions and tags. Desirable Skills and Experience: - Proficiency in photo and video content creation, particularly for Instagram. - Excellent grasp on the world of fashion and the ability to find fresh, compelling ways to present it. - Strong copywriting skills, particularly in crea...

I am looking for a professional with superb skills in photo editing, particularly in removing backgrounds from product photos. I have a mix of both raw and processed images of electronics that require background removal. Requirements: - Proficiency in photo editing software. Knowledge in Photoshop or similar softwa...removal. Requirements: - Proficiency in photo editing software. Knowledge in Photoshop or similar software is preferred. - Experienced in removing backgrounds from products, especially electronic devices. - Demonstrable skills in handling raw and processed images - Detail-oriented and can ensure the integrity of the photos in changing the background The final images should be delivered in PNG format. Please send a portfolio or samples of previous work related to th...

I am looking for a professional with strong data entry and analysis skills to assist with a key task. This engagement will involve entering both numeric and textual data in Excel for the purpose of data analysis. Here are the specifics: Look at the attached excel document. I need every country to look like the top 2 rows Afghanistan and Albania. Very simple and for the right person, I dont think it would take more then 2 hours. I need this done within 10 hours time. All links must be removed. All numbers must be numeric format. If this sounds like something you could excel at, then I would love to hear from you. Please include how you would approach this project as part of your proposal. I can pay $13 for this task. Bids higher then $13 will be igno...

I'm in immediate ne...end in react JS and backend in Node.js. hosted on ubantu server. Need an expert and experienced Node.JS developer who can make the changes of the process flow and add few APIs and reports in the existing application. Will explain in detail on chat regarding the same. Please ping me for more details - Feature Enhancements: Part of your role will be to enhance existing features, bringing them up to date and ensuring they meet the changing needs of our users. The ideal candidate will have considerable experience in Node.JS, application debugging and can swiftly adapt to our existing codebase. Prompt and efficient resolution of these issues is a must, so if you're a quickly responsive Node.JS maven, I need you immediately. Please address your relevant ...

I am looking for someone to assist me with data entry in Excel for a project. The ideal candidate will have experience in data entry and be proficient in using Excel. Specific requirements for the project include: - Perform accurate and efficient data entry tasks - Organize and manage large amounts of data - Input data into Excel spreadsheets according to specific guidelines - Ensure data is entered correctly and consistently - Verify and update data as needed Additionally, the data will need to be presented in a graph or chart format. Therefore, the ideal candidate should also have experience in creating graphs and charts using Excel. Skills and experience required for this project: - Proficiency in Microsoft Excel - Strong attention to deta...

I have two documents - one shorter (Document A) and one longer (Document B). I need a proficient freelancer to merge the two, adding the text from Document A to the end of Document B. Key requirements: - The final combined document should have a total of 79 pages - The content to be merged is text only - It's crucial to maintain the original fo...Document A to the end of Document B. Key requirements: - The final combined document should have a total of 79 pages - The content to be merged is text only - It's crucial to maintain the original formatting from Document A when it's integrated into Document B. Ideal freelancer will have: - Experience in handling and editing text documents - Attention to detail in order to maintain the exact format - Past experience w...

In need of a proficient Excel expert to shoulder some administrative duties. The role involves primarily data entry tasks, including but not limited to: - Simple data entry through copying and pasting - Repeat entries only need to be entered once - Looking at about 500 entries, (actual about 300 entries) Ideal candidate should demonstrate proficiency in Excel, attention to detail and data cleaning, and should be able to handle large volumes of data efficiently and meticulously. Organizational and analytical skills would come in handy to ensure data is presented in a user-friendly manner. Previous experience in data entry is well-regarded.

I'm in need of a qualified professional to assist with health license verification in Caracas, Venezuela. The specific requirements and details haven't been confirmed, whether it's license expiration date, health education background, or validity of license issuance. These details need to be clarified. The method of verification is also not specified; it could be a software solution, manual service, or both. I'm open to discussions to potentially determine the best method suited for this task. The purpose of this verification is also yet to be determined. It could be to ensure employee health and safety, compliance with local regulations, or to avoiding potential legal issues. Hence, a professional who can provide comprehensive services is preferred. Ideal s...

...Intelligence within organizations. The research paper should extensively cover the following areas: - Cybersecurity implications - Privacy implications - Legal implications The writer will specifically focus their research to the following industries: - Healthcare industry - Financial industry - E-commerce industry -Social Media industry - And a general overview of all industries In terms of format: - The research paper should be written in APA style. - It will be approximately 10 pages long. Ideal Skills/Experience for this Job: - Academic Research - Academic Writing - Familiarity with APA style formatting - Knowledge of AI-related Cybersecurity, Privacy, and Legal issues - Graduate-level intellectual capability To succeed in this project, being articulate, detail-orien...

As part of my project, I'm dealing with a large set of data (more than 10,000 rows) in Excel, for which I require professional assistance. Key Tasks: - Apply specific Excel formulas to perform financial calculations, including NPV, IRR, and ROI. - Utilize logical and text functions such as IF, CONCATENATE, and VLOOKUP for data management and analysis. Ideal Candidate: - Proficient in Excel functions and formula calculations - Experienced in handling large datasets - Strong financial analysis background The right freelancer will help me analyze this data successfully and draw meaningful conclusions. This project requires detailed and careful work due to the extensive dataset. I appreciate your time and consideration of this project.

I require skilled freelancers to accurately duplicate digital text for a book project. The ideal candidate will have a keen attention for detail, and understands the importance of retaining the original text formatting. Key Responsibilities: - Accurate replication of provided digital text - Ensuring that no transcription errors occur - Respect the structure and format of the original text Ideal Skills and Experience: - Proven experience in transcription or copy jobs - Strong command of English language - Excellent typing skills - Must be detail-oriented and meticulous.

Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.

I am seeking a professional proficient in text editing to enhance the quality of academic writing in the Social Sciences domain. Accurate and powerful language usage while preserving original thought flow is crucial. Key tasks: - Refine and flawless proofreading to eliminate errors - Improve clarity and coherence - Ensure consistency in style and format Ideal freelancer: - Has proven editorial experience on academic writings - Holds a deep understanding of Social Sciences lexicon - Has a meticulous eye for details - Can preserve the authenticity and integrity of the original work. Looking forward to creating a polished and engaging academic piece together.

I need assistance with a large-scale data extraction from an Excel spreadsheet. The data includes about 38000 line items, from which I require certain specific pieces of information – namely, the Names, Addresses, and Email Addresses. This extracted information will be used for creating a logical and organized mailing list. Here are the important elements of the project: - Extracting Names, Addresses, and Email Addresses from approximately 38000 line items - No specific extraction criteria or conditions to follow Ideal freelancers for this job would have experience in data extraction, data entry and be efficient in Excel spreadsheet operations. Precision and attention to detail are paramount for this role, as the information gathered will directly impact the efficacy ...

...courses for college students. This project requires developing a platform dedicated to the administration, documentation, tracking, and delivery of educational video lectures. Key Features Needed: - User-friendly interface for easy access and optimal user experience. - Efficient management functionality for student enrollments. - Tracking system for students' progress. - Primarily video lecture format with capabilities to add more formats later. Ideal Skills and Experience: - Proven experience in creating LMS catering to higher education. - Strong understanding of designing interfaces for young adults. - Knowledge of the latest trends in online learning. - Proven expertise in delivering secure, reliable, and scalable solutions. - Experience with developing video-based pl...

I'm seeking a proficient graphic designer to recreate an existing logo of mine. While my current logo is in JPEG format, I want it to be transformed digitally. I want it to be the same but symmetrical and digitally designed. The outline of the octopus and Lesssgooo! to be thicker. A designer who can: - Create an abstract design. I am fascinated by unconventional and unique styles and want this abstract touch in my logo. - Vibrantly use colors. The logo should stand out and have an engaging feel with the blend of brilliant colors. I want someone who ideally has: - Significant experience in digital and abstract design. - An impeccable sense of color schemes. - Experience in recreating logos. - Excellent communication skills to understand my design preferences. Don't ju...

Start with the file BACON ( Download at ) Please change the logo from the Colombia Rose logo to the Theo logo attached. Remove the text that says: FAMILY BUNDLE Buy 3 bacon rolls and get a 4th free Add new text: ... ) Please change the logo from the Colombia Rose logo to the Theo logo attached. Remove the text that says: FAMILY BUNDLE Buy 3 bacon rolls and get a 4th free Add new text: Only £1 ---- Change the colour scheme slightly to match the Theo logo colours. Change the background to the one attached to this project. -- Winner should upload as PDF and editable format. Contest will be closed early for a perfect design and the likelihood is that it will be closed within hours of launching.

I'm looking for an experienced and talented UI/UX designer who has extensive knowledge in design tools such as Figma. Your task will encompass several changes to my existing 3-panel web app. Key Changes Needed: - A color scheme to matc...across platforms. - The implementation of a modern and clean font style. The overall design should reflect a sleek, contemporary look. -Improving current look with more color. - addition of some progress tracking component in the top left panel above filters. Ideal Skills: - Advanced Figma user - Proven competence in UI/UX Design - Strong proficiency in visualization and color matching - Up-to-date knowledge of current design trends, particularly modern and minimal. Please include portfolio examples of relevant work executed in past projects...

...projects for my agency. - I am building a short format agency that edits videos for various trainers, companies and podcasts. - The videos are up to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and generally make the video entertaining and very engaging. - I'm looking for someone who can work as a part time editor for the next 6-12 months, with the possibility of a steady raise as the agency grows. - You will be paid 10 USD for every video edited. - The process is very simple. - All videos are cut by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits 1:1 on the Instagram feed. All videos should be edited in 9/16 format so they can be v...

...internet research, related to the local law; -Experienced in Pre-employment background checks, legal check or HR is a plus -Strong in both local and English language proficiency DELIVERY ELEMENTS: -All relevant document and news, if reported in native language must be translated into English -Social media handle of the targets -Weblink of the news, together with + Source link + News date + Summary of the news/information...

I've got 4 logos that I need vectorized. The original files are in JPEG format and I require them to be converted into EPS format with individual layers for screen printing purposes. The task is straightforward, just a simple conversion, no redesign or modifications required. In addition, all the elements within the logos are clearly visible and sharply defined which should ease the conversion process. Ideal Skills Required: - Expertise in graphic design and vectorization processes - In-depth knowledge of Adobe Illustrator or similar software - Experience in logo design and screen printing preparation Your task will simply be to create an identical, scalable vector version of each logo in EPS format. Timely completion of this project is crucial. With your bid,...

Please Sign Up or Login to see details.

I have written one research paper and I am seeking help to convert the content into research document format like IEEE. Please get in touch with me if anyone is interested.

My project re...application of Gaussian filtering in Verilog specifically for enhancing image details. The image type for this task is RGB, and the intended result should lead to clear, detailed images showcasing the potential of Gaussian filters. Key requirements include: - Applying Gaussian filtering to provide image enhancement - Working specifically with RGB images - Delivery of processed images in JPEG format Given the technical nature of this project, proficiency in Verilog and image processing is crucial. A deep understanding of Gaussian filtering algorithms is also necessary. Experience with image manipulation software would be a bonus. This project is ideal for freelancers who are detail-oriented and are adept at transforming complex requirements into streamlined actiona...

Please Sign Up or Login to see details.

I'm in need of a proficient professional who can provide a detailed quantity take-off for a project Value RM3.4 Million equivalent to USD711,000. Key Responsiblities: - Providing a comprehensive full building quantity take-off service. - All data to be provided in Excel Format - Complete within 2 days. - Initial tender quantity will be provided, to compare it with taking-off quantity (re-measurement) Ideal Skills: - Familiar with Planswift would be a plus - Experience with industrial-type construction projects. - 5+ years experience in Quantity Surveying Field - Strong analytical skills and attention to detail. - Familiar with Malaysia standard of measurement, SMM2 By offering this service, you will provide an integral part of the planning and budgeting process for t...

Need a freelancer that can extract a list of cities (200 - 400) from a website and provide in an excel sheet. Quick job for the right freelancer. Pays $20

I'm on the lookout for a proficient Flutterflow specialist who can collaborate closely with me on a project intended for students. This program will encompass: - User authentication and registration: We want to ensure that only registered users can access certain parts of the application. - Push notifications: Crucial for keeping our users up-to-date and engaged. The ideal teammate would have extensive experience in Flutterflow, specifically in implementing user registration and generating push notifications. Understanding how to restrict certain content to registered users would be a significant advantage. It's vital that we keep to a strict timeline, so I need someone who can hit the ground running.

I'm looking for a proficient programmer to create a graphical user interface (GUI) dashboard for my manufacturing business. A high level of experience with Linux platforms is...will be sent via email to the server. The .CSV data then needs to be processed into the SQL database using something like Pandas. We will use specific columns of the .CSV to generate data that we will then display in graphs and charts on the screen. The GUI will be quite simplistic showing mainly "Order Number", "Project Title", "Timesheet Total Hours as a percentage of Hours estimate" and "due date" (needs to be added to CSV). I have attached the dummy CSV. Here is an exact example of the dashboard that will be replicated but for a different application -

I'm in need of an Excel expert who can assist me in creating an advanced tracking system for specific KPI's and security measures. For the KPI tracking, you'll work with: - Sales - Profit Margin - Customer Satisfaction It's also crucial for the data we manage is secure with a well-setup security system. Data security is paramount, and I need these set up: - Data encryption - User authentication - Firewall protection Moreover, the security measures should include an effective incident tracker that, in case of any violation, notifies me through email. Skills needed: - Expert in Excel - Understanding of Data Security - Knowledge in setting up email notifications. Please, only apply if you have a strong understanding of these areas.

I require an expert who can handle a multifaceted data analysis task. This project (Excel dataset) revolves around a questionnaire survey I've conducted for research purposes. Key Tasks: - Carry out descriptive statistics - Conduct correlation analysis - Perform validity and reliability tests Specifically, I need the following tests to be utilized: - Chi-Square test - Cronbach’s statistic - Item-total correlation - Discriminant & Construct validity The ideal candidate should have solid experience in statistical analysis (no preferred Software), a strong understanding of the mentioned statistical tools, and an academic or marketing background to comprehend the intricacies of my research. Familiarity with surveys and questionnaire analysis will be a significant adva...

I'm currently working on my MBA project, and I'm looking for a statistician with a strong background in regression analysis and Excel. Here's an overview of what I'll need from you: - Perform a comprehensive regression analysis: I've chosen to focus my research on this area of statistics. - Use Excel for this project: I have decided to use Excel for this project due to its simplicity and because it's a tool I'm familiar with. - Complete the project as soon as possible: I'm running on a tight schedule, so time is of the essence. Required Skills: - Strong grasp of regression analysis - Proficiency in Excel - Ability to work under a tight deadline This project is quite urgent, so I'd appreciate a swift response from ...

...configure complex simulation environments, including physics models, sensors, and obstacles. • Create motion plans and trajectories for robots using advanced planning capabilities. • Analyze simulation results and provide insights into robotic performance and limitations. • Collaborate with engineers and researchers to define simulation requirements and ensure alignment with project goals. • Stay up-to-date with the latest advancements in simulation technology and best practices. *************** Qualifications: • Required: Degree in Robotics, Engineering, or related field. (Master's degree or Ph.D major plus) • Expert-level proficiency in NVIDIA Isaac Sim. • Strong understanding of robotic kinematics, dynamics, and control. • Experien...

I need a freelancer to help me through the process of transforming my educational eBook into an interactive format. It is less than 10,000 words. Key Responsibilities: 1. Proofreading and Editing: Ensure the content is clear, concise and error-free. Your keen eye for detail is crucial here. 2. Design and Layout: Redesign the existing layout to make it more engaging, reader-friendly, and suitable for the addition of interactive elements. Proficiency in layout design is necessary. 3. Interactive Element Incorporation: Add quizzes/tests and interactive exercises. Past experience with creating interactive eBooks or similar content will set you apart. 4. eBook Publishing: Guide me to publish it across multiple platforms. Experience with eBook publishing would be beneficial. Amaz...

I require assistance from a skilled Wix expert. This is a restaurant website already designed, just need to add a booking form. Here’s an outline of key tasks: 1. I want you to create custom form of event reservation. 2. Which include 10 fields like, event date, time, name, phone number etc, see attached form design which is on PDF format, I want to implement the same design on that page. 3. After submitting the form I want one popup or new page which should say, "Thank you for reaching out to us. We have received your request and will contact you shortly" You should have prior experience in Wix platform and a keen eye for details. I want to get it done with in the next 24 hours. Once this job is completed I have another job for your guys. Please don&...

Hello Shofiur, the project is about building a security inventory of my servers and VMs. I'll provide around 500 IPs and their tcp and udp ports should be scanned (range 1-65535) you should delivery a csv file with 1 port for each line and format: ip address,proto,port,service,version (if you have more information, even better) Thank you.

...with an amount to pay between 5000 and 500000 soles 03- show me the resolutions or sentences with amounts between 100,000 and half a million soles. 04- Make a table with Arequipa's resolutions from the last 05 years. 05- show me a list of the resolutions of the 1st room of the last 05 years. 06- What is the average amount to be paid in puno resolutions? 07- make a table that shows the departments, date and mining company with amounts to pay between 5000 and 50000 soles Here are 16 questions about "El Peruano." 01- ¿De qué trata la Ordenanza nº 282/MDSR? 02- ¿De qué trata la RESOLUCIÓN LEGISLATIVA N° 29872? 03- Se publicó alguna resolución suprema que autoriza viaje de funcionarios del Ministerio a Colombia...

...card, regardless of its type, clearly belongs to the "Consultant Wars" series. This can be achieved through consistent use of design elements, color, and thematic ties across all cards. Deliverables: 1 example of the front of the card design 1 example of each category for the back of the card design High-resolution images for both the front and back designs. Source files in .ai, .psd, or .svg format. We encourage creativity and are looking for designs that will make "Consultant Wars" not just a game but an experience. Impress us with your creativity, and let's make "Consultant Wars" the next big hit in the world of card games! Skills Required: Graphic Design Illustration Photoshop Creative Design Typography...