VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
삼성 안드로이드 폰 기준(예. 노트4)으로 볼때 핸드폰의 최초개통일(first call, 폰에서 큐알을 찍었을 때 나오는 od(opening day))을 지우고 쓸 수 있는 단순한 프로그램... 핸드폰의 imei 나 sn(씨리얼 넘버) 나 통신에는 영향을 주지 않고 단순히 최초개통일만 변경할수 있는 프로그램을 원합니다. 첫번째로는 pc에서 폰에 연결하여 변경가능하거나( app에서 변경가능하거나.. ) 그렇게 간단하게 작업할수 있는 것을 원합니다.
...on clothing. Below are the key points and requirements for this project: Project Overview: Objective: Refresh our current logo and incorporate a mascot to be more reflective of our name and communities we serve Target Audience: Schools, parents and Children and teens aged 5-12 from underserved communities, with a focus on promoting equal access to STEAM/STEM education. Design Elements: The design should be colorful and fun, capable of being printed on clothing and other merchandise. Design Inspiration: Mascot Idea: Considering a mascot that embodies a young, adventurous spirit, such as an astronaut, to represent our 'Digital Dreamers Academy' maybe with a robot dog next to it, backpack, or some type of tech gear...possibly day dreaming? Attached Sampl...
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements with...
I'm in immediate need of a talented freelancer with exemplary scripting and animation skills. The project revolves around the creation of a 1-2 minute demo presentation with an engaging narrative. Key Aspects: • Animation Length: 1-2 minutes • Animation Style: Demo presentation • Script/Storyboard: You would be responsible for creating the script/storyboard. • Budget: $50 • Deadline: The project must be delivered within a day. Ideal Candidate: • Previous experience with animation video. • Strong scripting abilities • Exceptional knowledge in 2D Graphic animations or 3D Computer animations I encourage freelancers who can deliver high-quality work within the time and budget to apply.
As a growing business, we're seeking an experienced Swedish native who can provide phone support for our Customer Service department. The successful candidate should be: - Able to manage a workload of between 50 and 100 calls per day. - Possess strong understanding and knowledge in resolving customer issues promptly and pleasantly. Your primary responsibility would be to answer customer inquiries, resolve their issues, and provide a positive customer experience. Essential Skills: - Fluent in Swedish (native level) - Excellent communication and problem-solving skills - Previous experience in a customer service role, preferably in a call center environment. This role offers a fantastic opportunity to get involved in the early stages of our customer service expansion. If yo...
...industries. Key Responsibilities: - Conduct a comprehensive Case Study Analysis on the role of big data in the decision-making process within the Technology, Healthcare, and Finance sectors. - Explore and highlight the benefits that big data presents in these specific industries. - Provide a well-structured and evidence-based narrative that clearly outlines the significance of big data in modern-day decision making. Ideal Candidate: - Prior experience in writing research papers, particularly in the field of data analysis and business. - Proficiency in conducting Case Study Analysis and presenting findings in a coherent and engaging manner. - Familiarity with the Technology, Healthcare, and Finance industries is a plus. - Strong research skills and the ability to critically anal...
I'm seeking an experienced tran...Chinese. Key Requirements: - The project will run for approximately 1 month, with each day consisting of a single meeting. - The ideal candidate should have an understanding of business terminologies and should be able to accurately convey the essence and context of the discussions. - The successful candidate will translate conversations in real-time, ensuring that the flow and integrity of the meetings are maintained. Skills: - Proficiency in Slovak/Czech and Chinese languages is a must. - Proven experience in translating business-related discussions. - Strong intercultural communication skills. This is a crucial role, so I am seeking someone who is reliable, professional, and able to commit to this daily task for the entire du...
One-week contract - 2 videos per day
...budget. Important: Please only consider this project if you will are okay with the budget, and have read through the project outline. Thank you. Project details: basic functions: (the main function is to show what time the user has to work on their goals, and generate a schedule for them to use, factoring in all their tasks in their daily lives) - asks for users input on 'how disciplined are you, what are your goals, tasks needed to complete the goal, what time do you want to get up in the morning, what are your unavoidable duties, how many hours of sleep do you need' - generates an easily understandable and aesthetically pleasing weekly schedule based on the above inputs (for e.g. if customer sleeps for x hours and wakes up at y am, the day ...
Tasks : 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use me...
am looking for a writer/journalist who can produce news articles based on trending topics we provide. The ideal candidate will have experience in producing multiple stories per day on incoming news. Skills and Experience: - Strong writing skills - Knowledge of current events and ability to research and gather information - Ability to write in a neutral and unbiased manner - Experience in writing news articles - Ability to meet deadlines and produce high-quality work consistently
Irandra is an Indonesian e-commerce company. As a startup, we have a small, yet friendly staff with a friendly imprint. We also value employee well-being because our employees are our most valuable assets. If you're someone who enjoys playing games, you shouldn't be a manager. If you simply want to make your work better, then go ahead and take a break. Our work day schedule: According to Sayloran (Kerja sambil Sayloran, Santai, malas tapi cerdas) Irandra Florist currently holds a job with the following position: • Web coder • Graphic designer Job Description: Web developer • Create websites and mobile applications • Maintain websites and mobile applications • Understanding and capable of utilizing efficient and effective APIs, as well as integrati...
...consistent, flawless operation , implementing APIs and adding the functionalities in the existing flutter app, testing, fixing any bugs to ensure smooth operations of the system. Pay : 1. INR1200/day or fixed amount as decided by our project managers, for 8 hours of work on anydesk/github for adding functions 2. INR 2000/project for rebranding+testing+fixing 2 Apps systems of codecanyon like professional apps. 3. INR3000/project for rebranding+testing+fixing 3 Apps system of codecanyon like food and grocery. 4. We work from 6PM till 4AM in the morning in IST, so devs can join us after their regular working hours. We are seeking professional, only individual devs (no teams, no groups, no companies, as we are already a company), who can speak and ...
...prepayment (%) when making reservation, and the rest payment when they arrived. before payment confirmed, online availability not taken (if not, it blocks other people to process reservation) Bank transfer option is delayed process, so it should get information by webhook from striper (until final confirmation, reservation shows still pending) 9. advanced reservation request if pay by card, same day (1 hour before their reservation start) reservation request is ok if client choose bank transfer opton, reservation request must be advanced for 3 days. if less than 3 days, it should show "can't process reservation with less than 3 days advanced request" and stop the payment process. 10. client doesn't choose sala number but only admin (backend) assign it 11...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA...
More details: What is the intended purpose of the device? Power automation What specific functions or tasks should the device be able to automate? power grid line control Do you have any specific requirements or features in mind for the power grid line control functionality? Real-time monitoring, Remote control. Develop a hardware prototype for detecting illegal electrical current tapping and automatically shutting off power to prevent hazards.
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I'm in need of an efficient and reliable Admin Assistant with a strong grasp of Indian accounting practices and taxation. Key Responsibilities: - **Using Tally:** Proficiency in Tally is a must as you'll be managing day-to-day bookkeeping, tax filing and management. Familiarity with other accounting software is a plus. - **Handling Data and Staff:** You'll need to collect data from clients and assign tasks to other staff members as well as handling some tasks yourself. - **Timeframe:** This will be a daily commitment, so someone with flexible availability or who can assure daily support is preferred. Ideal Candidate: - **Accounting Expertise:** Prior experience in Indian accounting and taxation is crucial. - **Software Proficiency:** Proficiency in Tally is...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
As the owner of a website, I am currently experiencing a critical issue where the destination is not working error blocks the ads from publishing. I need someone with expertise in this regard and help me resolve the issue
...paragraph of feedback 5 stars : - ) My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project: SINCERELY WOULD BE NICE TO MEET YOU PLEASE ANY THOUGHTS ? Please note project is due in two hours as this projects deadline, as this is needed if we can get some done - then we can talk about next steps and 5 stars and another job also. If this is a good one and we are "successful"; would need a couple others setup, but will handle one at a time? Can you do this for something reasonable in a coupl...
I need an experienced superstar who can utilize digital marketing, SMO, SEO, and Instagram content creation to help me: Payment will be made monthly basis of Rs 15000 INR, and the person will have to work 6 hrs per day Mon- Friday and 2 working Saturday - Increase website traffic - Improve search engine rankings - Amplify social media engagement The target audience for this campaign is aged between 30 and 45. Your work should focus on building brand awareness. The ability to attract, engage, and create loyal customers out of this age group is essential. Ideal Skills: - Proven digital marketing experience - Solid knowledge of SMO and SEO - Proficient in content creation, especially for Instagram - A record of successfully enhancing brand awareness on social platforms - A...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineeri...
we need a Web Scraping expert for a long term. will give you 1 site a day. per site $15. It's all about scraping product data like product title, description, image link etc.
EN ESPANOL I'm looking for an infographic designer to visually exhibit a 200-day journey through icons, illustrations, graphs, and charts. The end result should be a bright and vibrant infographic detailing the positive impacts of the actions taken during this period. The project requires: - Proven skills in infographic design, particularly with icons, illustrations, graphs, and charts. - A strong sense of aesthetics to create a visually pleasing infographic. - Understanding of color theory, specifically how to effectively use bright and vibrant colors. - Attention to detail and accuracy in representing data. - Ability to convey a story or message through an infographic, in this case, the positive impact of actions taken over 200 days.
I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload
I am seeking a developer with intermediate level experience IOS Swift. The task will be to help me get the example code working from the documentation at This is my first time working with IOS and the docs leave out some of the implementation. For example, in this code there is not map function, only "..." Bids under £70 only please. ``` var totalUsageByCategory: [ActivityCategory:TimeInterval] totalUsageByCategory = (…) ```
We're looking for multiple competent native English editors to trim content and help us improve English language usage across a large batch of tutorials. Starting with a paid trial. Please bid $20.
...yard perimeter, to create detection zones, i.e. people walking close to the perimeter fence and ignore cars in the main road 3. Ensure settings for recording, is only clips during AI motion detection, no recording at all when there is no motion detected 4. Set the detection clip video file format to MP4 and ensure all playback functionalities are working 5. Ensure all MP4 video file clips are copied to a Network Attached Storage device (NAS) once a day at midnight and are properly tagged with Client ID, camera ID and Timestamp 6. Create an http request link, that can be used as an external trigger to the camera, as per the idea in this link , the suggested http request link is as follows: http://[BIServerIP]:[Port]/admin?trigger&camera=[
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
...of my startup business. Key requirements: - Market Analysis: I need a comprehensive examination of the construction market, including competitors, demand, and trends. This will help to identify potential growth opportunities and risks. - Operational Strategy: I'm looking for a well-rounded operational plan that outlines how the business will function on a day-to-day basis. This should cover areas such as procurement, logistics, project management, and workforce planning. - Financial Projections: I need detailed, realistic financial forecasts that will help me understand how my business will perform over time. This includes cash flow projections, profit and loss statements, and balance sheets. The ideal freelancer for this job should have: - Proven experience ...
I'm looking for a skilled data entry specialist to join my team for 2 weeks on a full-time basis, dedicating 8 hours a day to the project. The work primarily involves extracting and entering text data from online databases into a structured format. This data will be used for further analysis and insights. Key responsibilities include: - Extracting text data from various online sources - Accurate and fast data entry - Ensuring data quality and consistency - Meeting daily and project deadlines ONLY IF YOU ARE SERIOUS ABOUT AND CAN DEVOTE 8 HOURS FOR 2 WEEKS THEN ONLY APPLY.. PAYMENT IS 3500 FOR 2 WEEKS. Please apply ONLY if you're capable of dedicating full-time hours for 2 weeks, have a reliable internet connection, and can deliver high-quality results. PA...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm on the hunt for pre-built ...open-ended, so any genre from collectibles, role-playing, to strategy games may be considered. Are you currently working on a Web3 Game? Did you already finish making a Web3 Game? Do you perhaps worked on a Web3 game before and own the rights? We are interested in 1. buying the code and rights 2. Or listing it on our platform This is a unique opportunity where you can sell your existing Web3 Gaming Project to us or list it on our platform. Write down the following: -Platform(s) of the game -Technologies you used to make the game -Concept and type of game (5-10 sentences) -Price estimate I'm NOT looking for someone to build a game from the start!!! You have to have an already working game or a game mid-development. Blind...
I’m looking for an experienced Facebook specialist who can manage and create engaging content for multiple Facebook groups which I own. Can create campaign reports and email to clients. This includes but is not limited to: - Taking control of managing group posts, - Working with group admins, moderating and monitoring comments and interactions, - Creating appealing, engaging content daily, - Building relationships with other relevant pages and becoming involved in other groups, - Monetising ads within our groups in a way that contributes positively to user experience. - Commenting on threads in our facebook pages to build community and connections, leading to pre sales good will. - Produce a weekly report of key traffic targets and revenue This task is intensive, as it in...
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
I need assistance in compiling a large, extensive database of more than 5,000 working professionals earning a salary under 3 lakhs per annum. The data profile will include: - Name and contact details - Education and qualifications - Current job title and company Interestingly, these professionals should spread across various industry sectors such as Technology and IT, Healthcare and Medicine, as well as Marketing and Advertising. Particular skills and experience that would set freelancers apart for this job include: - Proven experience in data mining and data scraping - Familiarity with the mentioned industry sectors - Ability to accurately cross-reference and verify data - Excellent attention to detail Freelancers with extensive experience in maintaining data integrity and c...
I have a flea market day sale coming soon with vendor spots 25$ you can sale food,clothes, etc. nothing illegal 9am-4pm Contact information 6012488614 or 6015514105 Address: Mccomb Train Depot May 4, 2024 I need a flyer for this event , use your creative said because this is similar to a pop up shop but I want it title as flee market day
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualizati...a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previou...
2 excel files with VBA macro as per customer requirement
I need an expert to create a Video for a Facebook ad for an English learning Website. The video will be in Spanish language since the target audience will be Spanis...website (see below). Creative, performance, acting, and video producing/editing skills are required. About the website's language learning approach: In order to acquire a new language, one must be consciously exposed to large amounts of it on a daily basis. Most people get tired or bored after encountering and looking up and memorizing 10 or so vocabulary words per day. This is not even close to enough. We need to go over thousands per day, not 10. To solve this problem one must make engagement the centerpiece around which everything else is built (lesson plans, tools, features, etc.). This is the approach...
Need a freelancer to answer phone calls. After each phone call, the freelancer will fill out a 5-minute survey (it will be provided upfront). One phone call's average duration is from 3 up to 5 minutes. The goal is phone call evaluation. The price we will pay per phone call is $8, and you will usually receive one call per day. Condition: Freelancers need to speak the US English language very well. As part of the application process, we invite you to record 30 seconds of your voice speaking English. This is an opportunity for you to showcase your fluency and competence in the language. We are looking for long-term cooperation. Payments will be in milestones after each survey (each call). Payment will be released at freelancer.com. You can bid for 3 phone calls to ...
I'm looking for a graphic designer who can skillfully change the background of an image to create a new environment. Specifically, the image is of my wife on our wedding day, she really wanted a picture of her with the car, but we forgot on the day and missed the opportunity. Key Tasks: - Add picture of her beetle into the background of a wedding picture - Insert a high-resolution, realistic new environment - Position my Beetle car prominently in the image - Images can be sent over Ideally, you have previous experience with car image editing and can demonstrate a high level of attention to detail. I'm expecting the result to be realistic and in high definition. Proficiency in Photoshop or equivalent software is required. If you appreciate cars, specifically Beet...
Hi Rose P., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Onboarding Full analysis of current and past marketing, competition, web traffic, and creative. Define strengths and weaknesses. Evaluate current channels and identify areas for new opportunities. Branding Logo, animated logo, and brand guidelines. Video/Animation Work Video shoot (1/2 day) in class with kids. These videos and photos will be used on website, social channels, as well as ads. Website Relaunch Website design and dev. B2B and B2C areas with intake forms and ecommerce for payments. Create 3 campaigns to launch in phases. This will consist of MONTHLY: Analytics Review Review data from previous month. Make adjustments based on strengths and weaknesses. Website Maintenace Website health check. SEO check and make sure everything is up to date and back site up....
Hello! I am looking for a skilled photographer to capture beautiful pictures for me. Type of Pictures: - Landscape - Portraits - Still Life Location: - I have a specific location in mind - I prefer a certain type of landscape - I am open to any location/landscape Number of Pictures: - 1-5 - 6-10 - More than 10 Ideal Skills and Experience: - Proven experience in landsca...photography - Ability to capture the beauty of nature and people - Creative eye for composition and lighting - Proficiency in using professional photography equipment - Strong attention to detail and ability to capture the right moments If you are passionate about photography and can create stunning pictures, please reach out to me. I am excited to work with you to capture the beauty of the day...
