Excel changes date format csvงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
ผมต้องการทำ Google data studio เพื่อแสดงข้อมูลรายงานรายได้ ค่าจอดรถของผม ซึ่งผมมี เวป คราวที่สามารถดึง CSV ออกมาได้แล้วก็นำมา สร้างเป็นหน้ารายงานสรุป
...สามารถ 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...
ทำ 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
I need some changes to an existing website. เพื่อความทันสมัยและใช้แอปและใช้แอปที่มีให้มีคุณภาพมากยิ่งขึ้น
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I have 5 voice files in Thai that I needed translated in the format given below. I : น้องเคยค้นหาแอคเคาท์ใครในออนไลน์ป่ะ อย่างเฟซบุค Have you ever try to look for someone or search for an account online? Or in Facebook S : เคย Yes I : เหมือนฉันชอบคนนี้ ฉันไปตามล่าหา If I like this person I would look for him/her. S : โอ้ย เอาทุกสเต็ปเลย โพสต์รูปอะไรเซฟมาให้หมด Everything from posting to taking picture. S2 : โมเม้นต์นี้ เคยครับ คือคนที่เราอยากจะรู้จักใช่มั้ยครับคนที่เราแอบชอบนั่นแหละ เราจะคอยส่องเฟซเค้า ไปดู If i like that person i would peek at her Facebook. I : ไปแอดเค้ามั้ย Did you add her? S2 : เป็นเพื่อนกันอยู่แล้ว ก็ดูว่าเค้าลงรูปอะไรมั่ง กดไลค์ให้เค้า นั่งดูภาพเค้าอยู่คนเดียวอะไรอย่างงี้ We are already friend. Most of the time just likes and ...
I'm looking for a programmer with a good understanding of Wordpress and SiteOrigin. The main task is to translate the date picker on my site from English / Dutch . Key Requirements: - Experience with Wordpress and SiteOrigin - Strong understanding of translation principles and practices The ideal candidate should be able to work independently, have strong attention to detail, and deliver high-quality results within the specified timeframe.
...people to do ongoing lead generation while monitoring my ongoing campaigns and helping me with internal account maintenance and tasks. 1. I have a cold email inbox that needs to be monitored. I need someone who can reply to a new lead within 2 minutes of a person sending an email in response to my cold email campaign. 2. I need some help managing my CRM to keep my lead generation funnels up to date (if you can set up advanced email and lead funnel automation in HighLevel CRM that's a big plus, please let me know). 3. I have general client account and client project tasks such as generating reports, launching website hosting servers, migrating data from one website to another, and other similar tasks that involve setting up or updating accounts/servers. 4. Other general mi...
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messagin...Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendly, reliable, and able to handle the company's internal resources efficiently. The Most important thing is the BOT must be PRIVATE and the only method to subscribe to BOT channel is by OTP sent to the registered e-mail in my company domain. The email list will be provided by excel sheet to you. The second MOST important thing is that the bot channel must be un...
I'm seeking an experienced web designer to help me create an engaging, professional informational website for my law firm. As I haven't specified certain key sections to include in the website, the freelancer should be capable of sug...an experienced web designer to help me create an engaging, professional informational website for my law firm. As I haven't specified certain key sections to include in the website, the freelancer should be capable of suggesting necessary sections for professional law firm websites. The timeline for this project has not been determined yet, so I need someone who is flexible in terms of delivery date. *Skills Needed:* - Web design - Experience with law firm websites is beneficial, but not necessary - Ability to suggest appropriate conten...
I am looking for people interested in recording videos without sound playing parkour maps in Minecraft, they would be a 2 to 4 minute video, good image quality and in 9:16 format (It is paid per video) below i leave an example:
I need a simple line drawing ready for engraving that should be a "Crest" ie. A shield with the Initials DA in gothic font. This has to be engravable, so it should be in an AI file format, and nice and clean. Should be a very easy job, needs to be a quick turn around.
I'm looking to engage a Shopify expert to undertake some custom work for my online store. The standout changes will be a custom order flow and checkout process. The store is designed as a breakfast delivery service in UAE. The store is in English. Key Project Details/ Order Flow required: We require a custom order flow for a bakery delivery service based in the UAE. No apps have project successful so we require a custom option using the Ecomify theme. Order flow needs to go as follows. - Customers build their breakfast delivery bundle using a bundle maker. - customer then needs to pick their delivery days of the week, this must be flexible. - customer then checks out using a weekly subscription app, which also needs to be flexible. - delivery should only be available in cer...
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 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 operator.
I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as the analysis will be used to make important business de...
Total Budget £40 - Need it done ASAP. I'm looking for a skilled After Effects designer to help me with my animated icons. I need to make a couple of quick changes to them, specifically changing their color and adjusting their size. Key Tasks: - Change color of the 25 x animated icons so the background is f6c405 and the icon colour 000000 - Adjust the size of the animated icons so they are 180 pixels high That's it! I have the AEP files. Need it done today or tomorrow - Budget £40 Example attached.
### Description: I am seeking a skilled software developer to integrate Arabic language support into our existing font generation system developed in C#. Curren...debugging tools to identify and resolve issues. ### Objectives: - **System Update**: Enable the system to generate fonts that support Arabic script. - **Bug Fixes**: Address any encoding and display issues with Arabic characters. - **Thorough Testing**: Ensure the system is compatible and efficient in processing Arabic texts. - **Documentation**: Provide detailed documentation explaining the changes made and instructions for users to utilize the new features. ### Expected Outcome: The system should fully support Arabic characters, and the fonts generated should display the text correctly without any distortions or encodi...
...initially. It would be great if you could work one or two hours per day on multiple days during the week. I'm expecting you to have: - Excellent organizational skills. - Strong attention to detail. - Good knowledge of English. - A password manager in use or be willing to install one (free software). We'll be communicating primarily through emails or instant messenger, so I expect you to keep me up to date on your progress and any issues that might arise. You'll be working for a small IT startup, with a fully remote team. You must be located within the EU. No agencies please! You will be required to sign an NDA as our customers value confidentiality. You will need to install some software (free) we use for document sharing. Please provide at least one refere...
I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal sk...
...current feature. I want to add Export feature, improve search feature and add the feature of uploading images/document, repair Year field, URL field etc, make the current captcha and email verification system better. Further, I want to dedicate one user as Admin. Admin gets all features like common users. Only difference is Admin can see user details like their username, email ID and registration date and can export it. No seperate Admin panel needed. See the site: This is very easy Project. Just making Form fields and report generating. Lowest bidder will win this project. You don't need to develop any new website or web design. Just a basic look will do. I need to deploy it in the Linux server. You need to give me the full copyright of the software
I'm in search of a skilled machine learning developer with expertise in GPT (Generative Pre-trained Transformer). My goal is to have an AI model that can both correct and standardize postal addresses. The addresses will be provided in CSV files and the output of the model should be accessible via an API for integration into our system. Key requirements: - Proficiency in machine learning with a focus on GPT - Experience in addressing data correction and standardization - Ability to work with CSV files - Familiarity with API integration - Strong communication skills for seamless collaboration The ideal candidate will have a proven track record of developing AI models, particularly in the realm of addressing data, and be able to provide a detailed timeline for the complet...
I'm in need of a Google Sheets scripting expert who can help me create a bidirectional data transfer system in Google Sheets. - The task involves transferring ALL data from one main sheet to multiple other sheets. - The data should be copied as well as linked to the other sheets. - The script should work bidirectionally, meaning any changes made in the source sheet should be reflected accurately in all the other sheets and vice versa. Ideal Skills and Experience: - Proficiency in Google Sheets scripting, specifically working with data transfer and bidirectional systems. - Knowledge of how to copy and link data between sheets. - Experience in creating and maintaining bi-directional data systems. - Ability to ensure that the script performs seamlessly even when handling a large...
Das angehängte Logo soll 1:1 im Vektor-Format reproduziert und als Illusrtrator-Datei + SVG-Datei angeliefert werden.
I need a thorough audit and optimization of my current Google Ads campaign. The aim is to boost sales, target a national audience, and enhance the campaign's overall performance. Key Points: - Current Performance: My campaign is meeting basic expectations, but I'm looking for an expert to take it to the next level. - Sales Boost: The primary goal is to increase sal...reach the right people across the country. The ideal freelancer for this project should have: - Proven experience in Google Ads management and optimization. - A track record of boosting sales through Google Ads. - Understanding of targeting strategies for a national audience. - Ability to conduct a comprehensive audit and apply relevant optimizations. - Good communication skills to convey the changes and the...
...history feature. This new feature will allow users to generate reports based on the stock's past transactions. Key points: - The project involves improving the functionality of an existing CodeIgniter project. You'll need to have a good understanding of the CodeIgniter framework. - Your main task will be to create a detailed transaction history for the stock. This will include information such as the date, price, and quantity of past transactions. - Users should be able to interact with the stock history by generating reports. This means you should have experience in creating user-friendly report generation systems. Ideal skills and experience: - Proficient in CodeIgniter - Experience in developing detailed transaction history systems - Familiarity with report generat...
...primary tasks for this project include: - Data Collection & Analysis: I need help in collecting relevant data on air pollution and subsequently analyzing it. - Result Visualization & Interpretation: After the data analysis, I require support in visualizing the results and interpreting them. The data that will be provided to you for this task will be in CSV format. Therefore, you should be well-versed in handling and analyzing data in this format. The ideal candidate for this task should have a strong background in data analysis, particularly in the context of environmental science or air pollution. Proficiency in RStudio is a must, as this is the primary tool that will be used for the modelling activities. Your role in this project will be crucial in ...
...**User Authentication**: Users should be able to create accounts and securely log in. - **Real-Time Data Updates**: The application must allow for smooth real-time data updates and changes. - **Data Visualization**: Incorporate clear and intuitive data visualization tools that can help users understand the data intuitively. Platform: - The application needs to be developed for both web and mobile platforms. Dashboard Interactions: - Users should be able to interact with the dashboard in the following ways: - **View**: Users can see the data presented in different forms. - **Edit**: Users can make changes to the data as needed. - **Download**: Users have the capability to download the data for offline use. Ideal Skills and Experience: - Proficient in PHP and MySQL...
I have a database with 200,000 SKU's from retail sales, unfortunately lacking category, subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will be crucial in ensuring the effectiveness of this project.
I'm in need of a developer who can address a specific bug (Bug screen resolution) in my current project. The bug is not a high priority and can be fixed at a later date, but I'd like to have this resolved as soon as possible. Ideal skills and experience: - Proficient in debugging and resolving code issues - Familiarity with web and software development - Ability to work quickly and efficiently within a short time frame.
I'm seeking a freelancer with legal expertise to assist me in disputing the validity of a personal statutory demand. This includes addressing and setting aside the demand issued against me. Key Tasks: - Analyzing the legal basis of the demand - Preparing a response to the demand - Filing necessary documents an...going back with the HMRC calling this matter into dispute, the HMRC have never provided the information requested on several occasions or the help requested to resolve this matter, I have for many years suffered from anxiety and stress mental disorders due to the pressures of this situation, since 2004, I have been employed on a PA basis with all of my tax and national insurance payments fully up-to-date which equates to several ten of thousands of pounds paid in ...
I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.
DONT USE AI FOR DESIGN!! I am in need of a logo for my business, HollyBloom, that is indicative of our focus on alternative practices. The logo should capture a sense of unity and growth. While I desire an elegant, possibly minimalist, aesthetic, I don't want it to be overly simplistic or lose its meaning. It should mirror the refineme...elements where possible, but AVOID making it look like a flower shop or yoga center logo - The logo needs a modern and clean style. Skills and experience: - Proficient in creating vector graphics - Strong understanding of modern design principles - Experience with using pastel colors effectively - Can creatively integrate multiple elements into a unified design Output Format: The final design should be in vector format for logo, but ...
My Gmail ActionMailer has stopped working and I'm encountering an authentication error. This problem started after I changed my email password, and now I'm unable to send emails from my application. Key tasks would include: - Investigating the causes of the authentication error - Resolving the issue, ensuring the ActionMailer can successfully connect to my Gmail account -...my Gmail account - Testing the solution to confirm that emails can be sent from the application Ideal candidates for this project should have: - Proficient knowledge of Ruby on Rails ActionMailer - Experience troubleshooting and resolving authentication issues - Ability to work with third-party services like Gmail - Strong communication skills, providing clear updates on the progress and any changes...
...expecting high standards of UI/UX design, and a smooth, user-friendly experience. - Experience in developing video analysis tools, ideally with frame-by-frame analysis capability, would be highly advantageous. Video Game Analysis using Strapi/React Situation: I have the game video on YouTube, link hidden. I want to be able to analyze the game, in which I do the following: - New analysis - Insert Date, Home and Away Team, level, competition (Camp., Cup, Phase X...). OK - In the future, you should alternatively choose an existing game from the previously created statistics. - In the analysis I must include a link to the YouTube video - I should be able to stop the video and insert a NEW annotation, which will detect the time the video is in, save it and allow me to add text - It sh...
