Macro script excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ฉันต้องการซื้อ Travian Script 5 หรือ 4.4 ปราศจากช่องว่างและปัญหา รองรับมากกว่าหนึ่งภาษา ตัวอย่าง
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
ต้องการสคริป Jquery Script สำหรับโฆษณาวีดีโอ ก่อนโหลดตัวเล่น Iframe จาก data-href button - ตอนกดโหลด Player จะมีโฆษณามาแสดงทุกครั้ง ก่อนที่จะดึงตัวเล่นมากจาก data-href <div class="player_ep"> <div style="text-align: center"> <button type="button" data-href="" data-resolution="fast_p2p" class="btn btn-primary play-ep">Player 1</button> <button type="button" data-href="" data-resolution="google_photos" class="btn btn-default play-ep">Player 2</button> </div> </div> โดยรูปแบบ ดึงโฆษณาวีดีโอมาแสดง จะดึงจาก รูปแบบคล้ายๆ แบบนี้ครับ หรือออกแบบมาให้ก็ได้ครับผม <script> an...
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...Agile ตัวจริง - อยากทำงานกับ guru ตัวจริงในการทำ automated test และ TDD - อยากเรียนรู้ technology ใหม่ๆ ที่ full stack developers ต้องทำได้ - อยากทำงานแบบ work from home ไม่ต้องมาเครียดกับรถติดและเวลาเข้างาน - มี passion ในการช่วยพัฒนาสังคมด้วยเทคโนโลยี - ใช้ชีวิตอยู่ได้ด้วยเงินไม่เกิน 50,000 บาท ต่อเดือน - มี skill เหล่านี้ : AngularJS 1.5.X, Bootstrap 3.x, Responsive design, Jquery 1.11.x, Java Script/DOM, Rest web service / JSON / HTTP Request, Git (Optional : Less or Sass css, Webstrom) ถ้าทั้งหมดคือตัวตนของคุณ [Removed for encouraging offsite communication which is against our Terms and Conditions.] PromptCoach () คือ startup สาย Edutec ที่มีปณิธานแน่วแน่ในการช่วยพัฒนาคนในสังคมให้มีคุณภาพมากขึ้นผ่านเทคโนโลยี เราต้องการเป็นศูนย์รวม โค้ช และ คอร์สอบรม ที่ใหญ่ที่สุดในโลก
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for voice talent for a 2-minute tutorial video. Script is in Thai. must sound young and energetic. please use the lines below to send sample เดบิตออนไลน์ช่วยให้คุณสามารถทำการโอนเงินเรียลไทม์ง่ายจากบัญชีธนาคารออนไลน์ขของคุณเข้ามายังบัญชีโบด็อกอย่างไรก็ตามหากคุณออนมือถือหรือที่บ้านทางคอมพิวเตอร์มันเป็นวิธีที่เร็วที่สุดสำหรับการโอนเข้าบัญชีโบด็อกของคุณ Thanks!
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
I'm uncertain whether my Windows system already has Python installed. I require assistance to get it up on my system, if it isn't already there. Primarily, I am looking for someone to help configure a Python script that will carry out automatic reservations on a specific website. This role will ideally suite someone with: - Proficiency in Python scripting - Strong understanding of automation using Python - Experience in setting up Python on the Windows platform - Knowledge of web interaction through code, in particular, reservation processes. here is the link to the script and its dependencies. I will need to work with you on zoom live to do this. I have node.js on windows
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I need to create a script to consume a SOAP service with WSSecurity to Encrypt and Sign the XML, an example is the way SOAPUI is configured to consume the service. Preferably in Python, but the language is free. Necesito crear un script para consumir un servicio SOAP con WSSecurity para Encriptar y Firmar el XML, el ejemplo mas cercano que puedo dar es la forma en la que SOAPUI se configura para consumir el servicio. Preferiblemente que sea en python, pero el lenguaje es libre
I am looking for a skilled developer to create an execution script for me for the game, Roblox Jailbreak. Features: - Fast car speed - Unlimited ammo - Teleportation ability Auto Farming: This script should enable auto farming. It should be able to: - Collect in-game currency - Complete missions or tasks User Interface: I would like the UI to be customizable to fit my preferences. Ideal Skills: The freelancer should have proven experience in scripting for the Roblox platform and should be familiar with the mechanics of the Jailbreak game. An understanding of UI design and user-experience would also be a plus. Freelancer needs to demonstrate their ability to create scripts with similar complex functionality. I dont want it to have any mistakes!
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
I am urgently in need of an experienced and dedicated script writer who can quickly deliver a high-quality movie script. You dont have to watch full movie. I will be providing a video which will be already explained in English, you just have to write the script of the same in Hindi. Price 300rs per script if it is under 15min, and 50rs+ for extra per minutes.
I have a private football manager game online. Written in PHP and TWIG. The script has already been adapted to PHP 7 (from PHP 5). 1. Now it has been noticed that 1 function, 1 module does not work properly under PHP 7. This module needs to be adjusted. 2. I need a few minor adjustments and functions in the game and in the admin area. 3. Then I would like to have a new module. A calendar where you can see the days and what matches you have on those days. (Read from the existing database and display). And with some functions. You have to know that every extension to this script will be written in modules. These are then copied into the directories and taken over by the main script. Who can help? Further information and sample images if you are interested and contac...
I'm looking for a talented video producer to create an engaging explainer video. Ideal Skills and Experience: - Proficient in creating explainer videos - Strong storytelling and script writing skills - Ability to create visually appealing animations - Familiarity with video editing software - Understanding of adult-focused content Key Requirements: - The video should be educational in nature, aimed at adults. - The content should be clear, engaging, and easily comprehensible. - It should be well-scripted, with a balance of visuals and narrative. - The video should be of professional quality, with smooth transitions and clear audio. - The final product should align with the objectives of an explainer video, which is to educate the audience. If you're confident in your ...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
I'm hunting for a talented scriptwriter to help me morph my autobiography into a compelling, cinematic drama. KEY REQUIREMENTS: - Understanding and analysing my life story - Skillfully infusing drama into the script - Ability to captivate a general audience - Prioritize cinematic appeal over strict accuracy Ideal candidates must have: - Significant experience in professional script writing, preferably in drama - Strong creative skills, to innovatively adapt real-life events into a dramatic format - Keen understanding of what engages a general audience - Open communication style, ready to walk the journey with me.
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
...marque, tout en réalisant l'unboxing. - Emplacement de la vidéo : Elle sera mise en avant sur la page de l'offre, accessible ici : - Format : Vidéo portrait, conformément aux standards les plus courants dans le secteur. Ce que nous recherchons : - Expérience en création de contenu UGC (User Generated Content). - Capacité à produire un script engageant et informatif (possibilité de collaboration avec nos copywriters internes si nécessaire). - Sens créatif et capacité à transmettre un message de marque de manière efficace. Comment postuler : Envoyez votre portfolio et quelques exemples de vidéos similaires que vous avez réalisées, ainsi que votre tari...
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
I'm searching for an experienced animator, proficient in Gujarati language, to create a simple 2D animated video that runs for more than 2 minutes. Requirements: - Creativity: I don't possess a specific storyline or script, your creative input is needed here. - Animation Skills: You should be adept at simple 2D animation and be able to bring concepts to life. - Language Proficiency: You must be fluent in Gujarati as this is the language the animation will be targeted towards. By leveraging your 2D animation skills and language capabilities, we can create a captivating and engaging video ad. Looking forward to seeing your creative ideas!
EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...
