Google data excelงาน
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. มีระบบ...
ทำ 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)
ตอนนี้ผมลองเริ่มทำ google ads สำหรับเว็บไซต์ที่ทำด้วย wordpress และ plug-in แต่ติดปัญหาตรงเรื่องการทำ conversion tracking เลยอยากหาคนมาสอนการ set up ให้ครับ นอกเหนือจากนั้นอาจจะให้แนะนำเรื่องการทำ SEO เพื่อให้ติดด้านบน ออฟฟิตอยู่แถวๆกรุงเทพกรีฑาครับ
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I've developed an app for Android TV and Google TV, and it's already fully compliant with all the Google Play policies and technical requirements. However, I'm looking for an experienced professional to assist with the submission process, ensuring everything runs smoothly and my app gets approved and available for download to users. I have already submitted the app to Google play and it got approved. However i didn't realize to submit android tv we need to opt in and add images. Plus i want help with google tv submission. I need Ideal Freelancer: - Previous experience submitting Android TV & Google TV apps - Profound understanding of Google Play policies and technical requirements - Capable of troubleshooting and ...
...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to...
I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a me...
We are looking for developers who are proficient in WooCommerce and Google Sheet API to help with our ongoing project to improve some of it's functionalities and features. Key Responsibilities: - Assist in setting up WooCommerce functionalities on a website, including product catalog, shopping cart, and payment gateway integration. - Implement integration with Google Sheet API for specific data processing & syncing requirements. Ideal Candidate: - Proficient in WooCommerce, including setting up product catalog, shopping cart, and payment gateway integration. - Experienced in integrating external APIs, specifically Google Sheet API, App Scripts Programming. - A good understanding of data processing and how to leverage Google Sheet for suc...
We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web
...with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a ...
I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria fo...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...
Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501
I'm looking for a Google Ads expert to review my Google Ads account focusing on campaign structure and target audience to enhance lead generation. Specifically, I'm looking for someone to review in comparison to another specified month where campaigns were much more successful. Key Areas: - **Campaign Structure**: Your task would be to evaluate and provide feedback on the overall structure of my existing campaigns. This includes the organization of ad groups, the relevance of keywords, and the alignment of ad creatives with the campaign goals. - **Target Audience**: I need a detailed examination of my target audience. This would involve assessing how well my current targeting aligns with the interests and behaviors of my ideal leads. You will be expected to offer ...
I'm in urgent need of a Google Pay redeem code valued at 1000 INR. I'm specifically looking for a code that can be used to purchase apps or games. While I'm not yet sure which applications or games I'll be purchasing, I'm highly motivated to get the code as quickly as possible. Ideal Skills: - Experience with online payments and redeem codes - Efficient and reliable service - Proven track record of fast delivery Please keep in mind that I need the code immediately.
I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface design for a seamless user experience.
...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
...is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and log...
I'm looking for an expert to help manage and promote my Etsy sho...my shop, particularly those within jewelry, home decor and art and craft supplies. - I currently have less than 50 listings on my shop, so there’s a scope for expanding the product range. - I am looking for a professional who can devise a sales-driven strategy to enhance visibility and attract potential buyers. -i want someone who can build google my business profile and manage the same. Ideal Skills and Experience: - Proficiency in Etsy shop & google my business management and promotion. - A track record of increasing sales for similar businesses. - Familiarity with jewellery, home decor, and art & craft supplies markets. Please include in your proposal your approach to promoting my p...
...for an expert to manage and promote my Etsy shop, as well as open my google business shop. I have an inventory of handmade and unique items, and I need help with both platforms for better visibility and improved customer engagement. Your tasks would primarily include: - Inventory Management: Keeping track of existing inventory, update listing details if necessary and coordinate to replenish stock. Knowledge of Etsy’s listing system is necessary. - Promotion: Create and execute Social Media promotion strategies for both Etsy Shop and Google Business. You should have experience in leveraging different social media platforms for business promotion. Ideal candidate would have prior experience managing Etsy shops and Google Business listings, with proven result...
For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!
I am looking for an experienced Flutter developer to help me resolve an issue with Google Login on my Android app. -When we generate release version of the APK Login with Google works perfectly, but upon publishing it to the Google Play Store, it encounters issues. The error message encountered is: PlatformException(sign_in_failed, com.google.android.gms.commeon.api.b:10:, null, null). Ideal skills and experience: - Proficiency in Flutter and Dart - Experience with Google Login integration in Flutter - Ability to troubleshoot and resolve authentication issues - Strong understanding of Android app development - Good communication skills and the ability to collaborate effectively with the rest of the team. If you believe you have the expertise and experience...
...filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web development (specifically embedding tables) - Automation and real-time ...
I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work...
I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.
I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant...
One month Google Ads work for a website
I need help setting up my nextjs website's cookie consent to be compatible with Google Consent v3. Key Requirements: - Write codes to setup cookie consent with google tag manager. - Ensure the cookie consent setup is specifically for Google Consent v3 compatibility. - Make sure the setup with Google tag manager. Ideal Skills: - Next js. - Familiarity with Google Consent Mode v3.
...app to accept quotation from customers 2. Customer had to register and must submit following details : a) Mobile Number (Must verify through OTP) b) Email id (Must verify through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Ad...
I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.
