Vba cut columns jobs

...please don't make a proposal. **** Here is an example product: The description should be placed in our description tab. The other info, from Connections to Warranty should be entered in our Tech Specs tab, while retaining the formatting, including symbols. Note that the content is responsive on the manufacturer site (two columns turn into a single column when viewed on a narrow screen/browser). Need that responsive layout on my site, too. I will provide full URLs to each of the images in the tech specs. I do not want to link to their images. You will not need to do any image editing. I will provide limited access to the back end of our site, so you can paste and test the data you enter. I will ask you to do one product

...manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tasks in Microsoft Excel, as well as working with Sharepoint, Microsoft Teams and Email - Excell...

I'm seeking a talented video editor to help me cut, trim, and enhance a 5-10 minute video. The video contains factual content and is akin to a corporate video in terms of style. Key requirements include: - Cutting and trimming footage: The editor should have a good sense of pacing and storytelling to ensure the final video remains engaging throughout. - Color correction: This will help enhance the overall look and feel of the video. - Adding background music: I need a fitting background soundtrack that complements the content and maintains viewer engagement. Ideal candidates should have prior experience in editing similar factual or corporate videos. A strong portfolio showcasing your editing skills and storytelling abilities will be greatly appreciated.

I am in urgent need of a skilled MySQL professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MyS...

Project Description: We are looking for a skilled Java developer with experience in Apache Flink (version 1.19) to create a data processing job that reads from parquet files...Description: We are looking for a skilled Java developer with experience in Apache Flink (version 1.19) to create a data processing job that reads from parquet files located on a Network File System (NFS) and sends selected data to a Kafka topic. Core Responsibilities: - Develop a Flink job using Java that can read parquet files from NFS. - Implement functionality to allow the selection of specific columns from the parquet files to be processed. - Ensure the selected data is published to a specified Kafka topic efficiently. - Manage dependencies and libraries required to execute the job without compatibili...

Apply VBA code in new Excel file

I have a set of manuscripts created on papyrus. I need them cut out in a complex shape (the shape is printed on the page.) The goal is to cut inside the line as close as possible. Over time I'll have many manuscripts to cut out, so this could turn into a longer term part time side job. Possibly this would be cutting out several single pages at once, or alternatively we might set it up so that you have several stapled together and you cut out all of them at once (and then check each manuscript for accuacy.) We will determine which is the best approach with experimentation. The important thing is accuracy and quick turn around time. As part of the process I'll ask you to print out and cut out a shape and send me a picture of the result as a way of...

...numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a detailed breakdown of what you should bring to the table: - Strong profi...

I'm looking for a skilled video editor who can help me edit my 5-10 minute YouTube videos in under a week. Key Requirements: - Basic edit...who can help me edit my 5-10 minute YouTube videos in under a week. Key Requirements: - Basic editing like trimming and transitions to ensure a smooth flow - Advanced effects and graphics to make the video more engaging and dynamic - Color correction and grading for a polished, professional finish Ideal Skills & Experience: - Proficiency in video editing software like Adobe Premiere Pro, Final Cut Pro, etc. - A strong portfolio of previous video editing work, particularly for YouTube channels or other social media platforms - Ability to work efficiently and effectively under tight deadlines Please include examples of your previous w...

I'm in need of a skilled content writer to create blog posts and website content for my technology related website. The content should be informative, engaging and maintain a professional tone throughout. Key requirements: - Blog Posts: You'll be responsible for writing insightful, up-to-date blog posts that touch on various aspects of technology. T...and more. Ideal skills and experience: - Proven experience in writing high-quality web content and blog posts within the technology sector. - Understanding of SEO best practices. - Ability to write in a professional tone that's engaging and easy to read. - Knowledge of the latest tech trends and industry news. If you're someone who's passionate about technology and can deliver content that's a cut ab...

I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

I'm in search of an experienced video editor who can create high-quality social media content for the promotion of my UK website. The video content will serve the purposes of promoting products/services, increasing brand awareness, and educating and informing the audience. Key Requirements: - Proficient in using video editing software such as Adobe Premiere Pro, Final Cut Pro, or iMovie. - Skilled in creating professional and formal content, as this is the preferred style and tone for the videos. Ideal Experience: - Previous work in content creation for website promotion, particularly in the UK market, would be highly beneficial. - A strong understanding of social media and how video content can engage and convert viewers. If you are a talented video editor with a keen eye...

I'm in need of a highly skilled freelancer who can handle advanced video editing and photo retouching. Here's what's needed: - For the video edi...-Experience in working/editing on Human Faces. - In terms of photo retouching, I'm looking for someone with a keen eye for detail and a strong understanding of photo editing techniques. Turnaround time is flexible, but I'd prefer if the work is completed within 1 week or less. Ideal skills and experience for this job include: - Proficiency in video editing software (e.g. Adobe Premiere Pro, Final Cut Pro) - Strong command over Photoshop - Previous experience with color grading and special effects in video editing - Proven track record in photo retouching - Good communication skills and ability to understand ...

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

I have a PNG file that I need the text extracted from and accurately transferred into a Word document. This is to preserve the text and make it editable for future use. The key requirements for this job include: - The extracted text must be precise, with no paraphrasing. - The text should be structured into two continuous columns, which are to be part of a table. The ideal freelancer for this project should: - Have experience in text extraction and document formatting. - Be proficient in Microsoft Word and capable of using its advanced features to meet the specified formatting requirements. - Have an eye for detail and a commitment to delivering work accurately and efficiently. By providing this service, you are helping me to efficiently and effectively convert a non-editable...

I need this to be done IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in handling this format....

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

Position: YouTube ...keywords. - Implement SEO and keyword optimization techniques to boost subscribers and viewership - Is familiar with YouTube's algorithm and best practices for channel growth - Willingness to undergo a trial period. - Package: INR 35,000 - 40,000 per month Requirements: - Bachelor's degree in any discipline - Demonstrated proficiency in video editing software like Vizard, Adobe Premiere Pro or Final Cut Pro. - Thorough understanding of YouTube and social media platforms, including current trends and best practices. - Familiarity with social media SEO and adeptness in keyword optimization techniques - Just get us how many subscribers and viewers you can increase per week Please send the sample while applying for this post. *** Only looking for the ca...

Please Sign Up or Login to see details.

I'm in need of a skilled video editor to help me compile and edit a series of football highlights. Key Responsibilities: - Create a professional and e...that showcases the best moments of the game - Ensure a high-quality output that is suitable for sharing on various social media platforms - Potentially include effects, transitions, and music to enhance the overall viewing experience Ideal Skills: - Prior experience in editing sports highlight videos, especially football - Proficiency in video editing software such as Adobe Premiere Pro, Final Cut Pro, etc - Ability to work efficiently and meet deadlines - Strong understanding of what makes a captivating sports highlight video Please submit your portfolio or relevant work examples when applying. Look forward to reviewing ...

...videos and a few thousand related images that cover the two year build. I have a couple ideas for the storyline, the goal is to try to monitize the video on YouTube, perhaps with a corresponding campaign on Instagram and/or TikTok Key Tasks: - Trimming and cutting footage: The video needs to be concise and engaging, so we're looking for someone who has a good eye for what to keep and what to cut. - Adding background music or sound effects: The video is meant to be fun and upbeat, so the music and sounds should reflect that. - Including text, voice and transitions: To keep the video engaging and easy to follow, text, voice and transitions should be added strategically. Ideal Skills: - Proficiency in video editing software - A strong sense of pacing and timing - Experienc...

You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated...create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an...

Please Sign Up or Login to see details.

Hello, I'm in need of a reliable video editor to assist with my YouTube up...Responsibilities: - Editing weekly YouTube videos - Cutting and trimming clips as needed - Implementing transitions and effects to enhance the video - Applying color correction and grading to improve the overall aesthetic - Ensuring video runs smoothly and is engaging for viewers Ideal Skills and Experience: - Proven experience in video editing - Proficiency in editing software like Adobe Premiere Pro, Final Cut Pro, or similar - Strong understanding of video editing techniques - Ability to work efficiently and meet weekly deadlines - A good eye for detail and quality This is a great opportunity for someone looking for consistent work in video editing. If you think you have what it takes, I'd lo...

...be involved in filming. You will focus on editing these pre-recorded clips into engaging videos in Reels format. - Style: The videos should have a fun and playful tone, so a sense of humor and creativity will be vital. - Elements: Your job will be to incorporate subtitles to enhance the videos and background music. -You will take videos from the internet of my products that have gone viral and cut and edit them to make new ones so the content is recycled. Ideal skills and experience: - Demonstrated video editing experience, especially for social media platforms such as Facebook and TikTok. - Ability to create engaging, fun and lighthearted videos. - Good knowledge of the Reels format and ability to adapt content accordingly. - Previous experience with product catalog videos or ...

...it/RegistroNazionaleTrasparenza/faces/pages/ Filters to be used: - "CAR": 203 and 16348 - "Anno di Concessione": 2020, 2021, 2022, 2023, 2024 - "Importo": select "Compreso fra 100000 e 200000", "Compreso fra 200000 e 500000" and "Maggiore di 500000" We need to scrape the results from all the possible combinations of the above filters. The outcome table should contain all the columns of the initial table AND all the data contained inside each result (you can access in it by clicking on the magnifiying lens). To be clear: - identificativo di riferimento - numero di riferimento - titolo misura - tipo misura - COR - titolo progetto - data concessione - denominazione beneficiario - cf beneficiario - regione - titolo mis...

I'm looking for an expert in Excel, preferable someone who is adept at managing and organizing large volumes of financial data. The task primarily revolves around: • Data entry and organization: You will be given vast amounts of financial data which I expect you to expertly enter and organize into Excel sheets. • Handling extensive data: You should be adept in working with over 10,000 rows/columns of data. • Using Excel functionalities: You should be familiar with Excel formulas and functions to format, sort, and organize the data effectively. Your experience in dealing with extensive financial data will be highly beneficial. I look forward to working with organized, accurate, and efficient freelancers. Remember, it's all about the details - accuracy is ...

• Edit raw video footage into compelling, high-...Attend morning meeting daily • Attend regular team / organisation meetings • Attend the training assigned and finish on time. • Update task completion report daily • Maintain a good morale throughout the team Requirements: • Proven experience as a YouTube Video Editor with a portfolio of work demonstrating your skills • Excellent knowledge of video editing software such as Adobe Premiere Pro, Final Cut Pro, or similar • Knowledge of special effects and motion graphics • Ability to work well under pressure and meet tight deadlines • Excellent communication skills and the ability to work collaboratively with a team • Strong attention to detail and an eye for quality and aesthetics...

As part of my business's visual branding, I need a new logo. The color scheme should remain the same, but with a refreshing twist to the icon. Specifically, I want to change from my current cow representation to a simplified silhouette of a Wagyu cow instead. Applicants with graphic design experience and knowledge in creating minimalist yet compelling animal ...simplified silhouette of a Wagyu cow instead. Applicants with graphic design experience and knowledge in creating minimalist yet compelling animal symbols will be best suited. Proficiency in AI/SVG formats is a must. Experience in brand revamping will be an added advantage. We basically need to swap out the existing icon and create two new versions from the attached images (but make them the same cut style). Bull = go...

...has 1090 questions in it. - Each question has 3 answer choices. - Each question has one correct answer (the choice in BOLD). - Some questions "refer to a figure". Most questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you must type it in manually. Succe...

...to my house to create a canopy above the proposed external terrace area. chem fix bolted back to the concrete structure of house. The house is a newly constructed single story property using ICF (insulated concrete formwork) with 150 mm thick concrete core and 80 mm extruded polystyrene on the outside and the inside. Generally, there is no rebar in the structure other than integral lintels and columns. The proposal is to add a minimal RSJ/UB steal structure to form a canopy structure. This new metal structure shall be fixed to the existing concrete structure by drilling and Chemfix with appropriate sized threaded bar, nuts and washes. It should be noted that 2nr concrete deep pad foundations have already been installed to align with the 2nr vertical RSJ/UB’s. As will ...

I require a capable DTP for an extensive task: converting over 1000 pages from PDF format into Word while ensuring to maintain the existing table structure, preserve all possible formatting including colors, font styles and also include headers and footers. The tables to be converted are of a basic complexity level, mainly comprising of simple rows columns. Ideal candidate should have good knowledge of DTP, proficiency in data conversion with a keen eye for detail to maintain the accuracy of data and its presentation.

... Requirements: - The non-text components may be an exact replica of the reference design provided. - I'd prefer you start with the background first without text, unless you're able to easily seek a comparable/identical font. The W is malformed, which isn't what we want. - Must be designed for ease of altering colours in mind (group shapes in the editable). - Consider this will also be laser cut, although this may use two separate SVG's. Outputs: - Supply the editable vector image. Extras: - If you want to make a subtle single shade flat seamless pattern for the background of a website, this would receive a payout. I imagine some generic food items in a diagnol grid. MVP: (minimum viable product for submission) - I cannot find a comparable font. However,...

I'm seeking a proficient video editor to bring my makeup content to life. Your task will include: - Color correction to enhance the visual appeal and maintain consistency. - Adding eye-catching text and subtitles to make my videos more engaging and informative. - Incorporating suitable music and sound effects to create a dynamic and immersive audio landscape. The final cut of each video should be between 3-5 minutes. Some will be longer content up to 10 to 20 mins. The ideal candidate will have a strong portfolio of similar projects, showcasing their capacity to create high-impact, aesthetic videos. Knowledge and experience in beauty or makeup content would be a plus.

I'm seeking a skilled digital artist to create an abstract rendering of a cut section of the distal femur. The outcome needs to sufficiently mimic an original image without being too similar to avoid copyright issues. Key details about the project include: - You'll need to develop a moderately detailed image that balances complexity and understanding with artistic abstraction. - Your forte should be creating renderings that stay fairly true to the original image's structure, yet incorporate an abstract style to differentiate it. - Familiarity with orthopedic or anatomical structures is a plus, as accuracy is still vital. - The focus of the project is exclusively on the distal femur bone. - IMPORTANT: The horizontal and vertical black lines from the attached origina...

Create a HeavenRev t-shirt design. The ideal candidate for this project should have: - Experience with vintage design aesthetics - An understanding of adult consumer pref...schemes My 11 year old son was mis-diagnosed at hospital and died of Meningitis so we do a weekly tribute online and car & Truck enthusiasts Rev Engines to honor him. We want to bring awareness of this deadly illness. We have many people requesting a t-shirt so we need an amazing design of this truck because it was his. This truck has over 8 million views online so its famous... Get creative.... Cut out the background so its just the truck Include: Words: 1. #HeavenRev 2. Brentley Bear Design: 3. Smoke blowing out of the exhaust stacks into the Clouds above truck. 4. Fingerprint tatoo 5. Picture of ...

I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, an...

Doing a morning show, need text on this photo. Heres is the text is needs to have. You don't have to cut out the picture. You can use the photo as is. Good Morning Talk Show Hosted By RebeccaJLive Mon- Friday 8:30-9:00am Only On OnlyFans FREE Page @TheDirtyRabbitsx Don't miss the Xclusive morning show! Start your day with laughter and spice! Topics Politics, Current Events, Sex, Sports & More!

I have raw video clips and interviews that I need to be edited into a 2-5 minute promotional video. The final video should be engaging and professional, and similar in style to the provided refere...facility, the equipment, and the culture. Key requirements: - Editing multiple video clips (some recorded with a phone) into a coherent and engaging promotional piece - Incorporating background music effectively - Ensuring the video is 2-5 minutes in length - Potentially coaching me on capturing video if needed Ideal candidate: - Proficient in video editing tools (e.g., Adobe Premiere Pro, Final Cut Pro) - Skilled in creating engaging, promotional content - Experience with incorporating background music effectively - Excellent communication skills to guide and coach on video capture if...

My Adwords ads have been shutdown for "Compromised site" and "Malicious software". I need to have them repaired and resubmitted and then put back up and running normally. The ads are still on Adwords so you can see them. I have far too many of them so i will cut them down to perhaps 5 or 6.

I am looking for a designer who excel at simplistic yet engaging visuals for an outdoor-themed logo that I have in mind. Here are the specific elements I have envisioned: - The main element of the logo will be a saw wheel incorporating a letter "D". - The character of "DAVIS" needs to be cut out from the straight part of the "D". - The logo should ideally include silhouettes of deer and ducks to keep with the outdoorsy theme. - For the entire logo, a minimalist approach is to be taken that enhances the visual clarity and refinement. - "Davis" should be outlined instead of filled or textured. The ideal freelancer will have previous experience with minimalist design and silhouette artwork. Experience in logo design or branding will be highly ...

I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

Hi Mo3aza7md, I noticed you posted a following project ( https://www.freelancer.com/projects/video-editing/Video-Cut-Edit-Visual-Effects/details )

كشخص يحتاج إلى مهارات تحرير فيديو احترافية، ستكون المهمة الرئيسية هي قص العديد من مقاطع الفيديو وإنشاء مقطع نهائي محرر بشكل جيد. ويعتبر تعزيز النسخة النهائية بآثار بصرية إبداعية أمرا أساسيا لهذا المشروع. الهدف النهائي هو الحصول على فيديو ذو مظهر احترافي يحكي قصته بإبداع من خلال مرئيات رائعة. مهارات مثالية للمهمة --خبير في تحرير الفيديو -بارع في التأثيرات البصرية الإبداعية · القدرة على إنتاج أشرطة فيديو ذات مظهر احترافي -فهم رواية القصص من خلال الرؤية.

Looking for someone to fix some of the formulas that is off and add a 2 other columns with formula for data. If this work out well it will lead to future projects

I am seeking a skilled artisan to create a minimalist laser-cut portrait in a classic portrait orientation. The subject will be human. A picture is provided. It is a portrait of a woman in pdf format. the attached file is "2024-05-03 " The final result should be similar in style to the "laser cut face " sample attachment. The format needs to be in DXF format. All the lines must be suitable for laser cutting. The lines must have distance so that the laser path does not intersect. Features such at eyes and noses must be cleverly stenciled so they do not fall out of the composition during laser cutting. KEY REQUIREMENTS: - Expertise in laser-cut designs - A knack for minimalist portrait design - Strong understanding of human figures T...

...Methodology. In P. Novais et al. (Eds.), Proceedings of the European Simulation and Modelling Conference - ESM'2011, pp. 117-121, Guimarães, Portugal, October, 2011. EUROSIS. The data is related to a direct marketing campaign conducted by a Portuguese financial institution. The raw dataset has been modified for the purpose of this assignment. The attached “” file contains the following columns:  Age : a continuous variable (respondent’s age)  Job : type of job ("admin.", "unknown","unemployed","management", "housemaid", "entrepreneur", "student", "blue-collar", "self-employed","retired","technician&quo...