大家好，我叫‘马克’，我是一个英国人 I would like to gather information about 100 companies in Dongguan, Guangdong, China, including: 1. 公司名 ...an employee (company profile) 2. Complete the company profile columns B - M 3. Include any links to profiles on the job site (the source) 4. List the number of vacancies the employer is currently listing, if available 5. Make sure all links are live and clickable NOTES: 1. All phone, fax and cell-phone numbers must start with the international dialling code - Hong Kong: +852 - China: +86 2. All email and weblinks must be made a live link. The easiest way to do this is to edit the cell, then press enter and it automatically changes to a blue link that you can click 3. Column P (招聘职位) is the number of visible job vacanci...
Specs: Grid Cells select format 1-the color picker: first time open (no previous coclor selected), defaulted luminance to 50%. If previous color selected, default to that color. 2-the selected color needs to be on the button a...select format 1-the color picker: first time open (no previous coclor selected), defaulted luminance to 50%. If previous color selected, default to that color. 2-the selected color needs to be on the button after first selected. 3-a radio button (format button appearance) for each format type: backcolor, forecolor, bold, italic, underline. same like color, needs to select and change the cell. 4-the cell select needs to toggle the format on and off. 5-checkbox to save the format between reload of grid data source. Bid with 1-22-333 in you ...
...------------------------------------------ The Foreground service should perform the following tasks continuously: - Scan for Bluetooth beacons (iBeacon and Eddystone types). - Track the user's GPS position. - Each time a beacon message is detected, if there is connectivity, send a JSON message to a registration API (which I will provide) containing: detected beacon UUID, major, minor, RSSI, GPS latitude/longitude, and detection timestamp. - If there is no connectivity, the message should be saved locally (in SQLite). - If there is connectivity and there are messages in the local database, retrieve them, send them to the API, and delete them from the database. Permissions ----------------------- The app should request the necessary permissions to: - Scan for Blue...
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
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 for merging specifically adjacent cells - Ex...
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 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.
I'm seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet into a visually appeal...
The objective is to develop an application to manage two devices via WiFi (may be increased in the future) I have two devices: Sauna and red light therapy panel. They all have a touch control panel and can be connected to your cell phone via Bluetooth and Wi-Fi. Many of the providers also offer you the mobile application already developed (as can be seen in the attached images). The idea is to make a similar application from which the two devices can be managed (set time, lighting, power, etc.). And the history of uses/settings is saved. It could also be evaluated to take the code of the two suppliers' applications and combine them into one, strongly separating them within it.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval
Beginner level freealancer to create an m...don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and sha...
I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member li...extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed b...
I have a mix of digital and paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and acc...
I'm seeking a skilled Python programmer with OpenCV experience, preferably one who has dealt with table detection from PDF and images before. Th...of OpenCV - Familiarity with table and structure detection Your main task will be to develop a program that can accurately identify table structures within input files. The files will be PDFs or images, or both. You're expected to program a feature that detects these components: - Cell boundaries - Text within the cells - Overall table structure For the sake of this project, merged cells should be discerned as a single entity during the detection process. Your solution should demonstrate precision in merged cell detection. I look forward to bids from those passionate about computer vision tasks and tackling challenges ...
... You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR. The data is sor...
...or any other relevant hardware as required - The BMS should include essential safety features such as: * Temperature monitoring * Short circuit protection * Cell balancing * Reverse polarity protection - The system should allow for charging and discharging through the same port I need this project to be completed within a month. Ideal skills and experience for this job include: - In-depth knowledge and experience in BMS design, particularly with LiFePO4 batteries - Proficiency in creating flexible BMS systems with variable ampere capacity - Extensive experience with temperature monitoring, short circuit protection, cell balancing, and reverse polarity protection - Ability to deliver the project within the stipulated timeframe - Strong problem-solving skills an...
I need an automation expert to streamline my data entry process on Google Sheets through app script. Key Requirements: - The automation is triggered when the number is input in the cell. - The data source for this automation will be online forms. - we have three google sheets. and the same scenario where we need to triggered a message via Twilio. Ideal Skills and Experience: - must be able to show the demo. - Proficiency in Google Sheets and App Script. - Experience in automating data entry processes. - Knowledge of Twilio and Whatsapp API is a plus.
...layer of security for the riders, besides the existing emergency protocols. The riders will often be in remote areas in the mountains, with no cell reception or internet, therefor the app needs to be able to handle offline navigation on predefined tracks, which need to change every race day. Mobile App Requirements 1. Map Display with Custom Data: The app should display a map with custom data layers relevant to the user. This can be GPX files with Waypoints and tracks or a completely custom map file. 2. Offline Functionality: - Both the app and the map should be fully functional offline, ensuring accessibility without an internet connection or cell reception. The displayed map should be the one valid for the current day (the map changes every race day). 3. Emergency ...
I am in need of a RoboDK expert proficient in robotic simulations, specifically within a robot cell. Key tasks: * Simulating pick and place operations. * Simulating assembly tasks. Ideal applicants will come equipped with advanced experience in RoboDK, motion planning, and offline programming. Deep knowledge of industrial manufacturing systems focusing on robotic cell operations is highly required. Understanding of practical applications of these simulations within the workplace is beneficial.
I'm looking for an experienced Android and iOS programmer who can help to convert a PC program which is a tests programme been using with some other features to work at cell phones . Key Requirements: - Successful conversion: I need the program to be fully operational on both Android and iOS devices to be able to edit qustions at the future. Ideal Experience: - Proficiency in both Android and iOS development. - Proven track record of converting PC programs to mobile platforms. - Ability to optimize user interface to suit mobile devices. The user interface design is somewhat important to me. I expect a clean and functional design, but I'm open to suggestions and improvements from someone with expertise in this area. Please provide examples of similar projects you...
...excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that converts their answer (in one cell) to a score (in an adjacent, hidden, cell). The second formula involves summing (adding) the s...
I need a skilled WordPress developer to list custom posts by closest distance to the current users address, which has been added via an ACF Google Map in the user profile. The list of posts will appear on the users profile page which is set up in Each custom post already has a latitude and longitude as post meta using ACF. I just need help with extracting the latitude and longitude from the Google map in the user profile and sorting the posts according to distance from those coordinates. Ideal Skills and Experience: - Extensive experience with WordPress custom post types and custom fields. - Proficiency with Advanced Custom Fields (ACF) Google Map integration. - Prior experience implementing distance sorting on WordPress websites. This is an urgent proj...
...subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Ex...
I'm looking for a creative mind to produce engaging 15-second product level videos to be used in Meta & Pinterest Dynamic Product Level Video Ads. WHO YOU ARE: - You have a firm grasp on the interests and trends of our target demo (young families with kids; approx 20-45 years old) and can captivate...html
...excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the excel file or txt file - starting cell (normally it will be A1 or A2) - basic hyperlink - how to compose the final hyperlink...
I need to hire an expert to develop a poc (proof of concept) for me with flet + python or flutter. A line graph, a bar graph and a canvas must be made with a background image with 5 variables located in different places on the image, showing new data every 10 seconds The deliverable is the sources installed in Visual Code, publishing and running on an Android cell phone and a website It must be developed with async and fastapi methods, depending on the results we can look at 100% development of the app, but a proof of concept needs to be done before starting the large project. thank you so much Demonstrated experience in dashboard development with flet or flutter is valued
...most importantly, show the reaction: Include (1:20 "for the first time... to that's crazy okay" to 1:53) (one more video at ) Show the unlock & reaction of me unlocking the cell phone. It's important to show the reactions and in some cases the short build up of what lead to the reaction. The last text of the video should end with: Dan Chan The Millionaires' Mentalist To respect both your time and mine, please refrain from submitting additional entries if you receive a one-star rating. However, if you achieve at least two stars, feel free to
...regulation and brain function14. 2. Homocysteine Metabolism: It plays a critical role in the metabolism of homocysteine, helping to convert it to methionine, which is vital for the synthesis of proteins and DNA3. 3. DNA Synthesis and Repair: As the active form of folate, L-5-MTHF is necessary for the synthesis, repair, and methylation of DNA, making it particularly important during periods of rapid cell division, such as in pregnancy12. 4. Prevention of Neural Tube Defects: It is recommended for pregnant women or those planning to become pregnant due to its role in preventing neural tube defects in the developing fetus3. 5. Support for Individuals with MTHFR Mutations: Some people have genetic mutations that make it difficult for them to convert folic acid into its active form. L...
Dear Freelancer I need Python Scrape links with windows 10. Cell data must stay consistent, this will be linked to other Excel workbooks. Il attach the examples with the layouts. Scrape Links Examples: I've colour coded the Excel workbooks, to show where the Data comes from. Let me know if any more information is required?
I'm in search of a talented, budget-friendly, 2D Cell animator to assist with a project that is in the early development stages. Main Responsibilities: - Co-create a compelling character design and show concept - Develop 10-30 minutes of animation akin to the style of "Invincible" - Collaborate on story development and animation Required Skills: - Strong artistic abilities, especially in 2D Cell Animation - Proficient in designing unique and interesting characters - Experience with conceptualising a show - Open to reasonable, cost-effective payment terms This project demands a mix of creativity and technical skills. Candidates must be willing and able to engage in the creative process whilst managing the animation requirements. Looking forward to hearing fr...
Search for commercial loan officers on linkedin and fetch contact First and Last name, bank name, cell number or direct work number i need working direct number only one not multiple The counties are in: Citrus Hernando Sumter Pasco Hillsborough Pinellas Lake Polk Orange
I need a freelancer to scrape text data from a PDF and output it into separate cells by paragraph in an Excel document. Key Requirements: - Extract and convert text data from a PDF into a structured Excel file. - Each paragraph should be in a separate cell in the Excel sheet. Ideal Skills and Experience: - Proficiency in PDF scraping and Excel data entry. - Attention to detail to ensure accurate data transfer. - Understanding of text formatting to ensure the data is organized accordingly in the Excel sheet.
...are within a specific radius of the workplace. The implementation will be split between the administration panel (HR) and the employee mobile app. 1. Administration Panel (HR) 1.1 Adding Fields to the HR Panel Three new data boxes will be added: latitude, longitude and area. These fields will be incorporated into the user data entry form in the HR dashboard. 1.2 Database Update Three new columns will be created in the database users table to store the geolocation data: latitude: Stores the latitude of the work location. longitude: Stores the longitude of the work location. distance_radius: Stores the distance radius allowed for marking a point. 1.3 Modification of PHP Code Only the PHP file responsible for inserting data into the database will ...
...show that you have experience opening Amazon Seller Accounts. The Business is licensed in the State of Wyoming, but the owner is living outside of the US. We have the following documents; - Company formation document - Business address in the USA (Without utility Bill) - Address outside the USA (With Utility bill) - EIN Number has already been issued. - US landline number - Outside US-Cell Phone number. - US Bank Account Outside US bank Account. You must be confident that the account can be approved with the above! We have experience with amazon, and amazon account openings so we know what is required we just do not have the time currently to open another account. If all done well future work may be needed, such as Listing Service, and advertisement. Please ...
...required Ideal skills for this project include: - Proficient in mobile app development - Expertise in geolocation services and security - Experience with real-time verification integration - Strong understanding of user access control WorkDo Dash SaaS I need a security lock on their app! On the panel, it needs a new function, geolocation! flow manager: The establishment manager enters the latitude and longitude data, and the radius of distance that the employee can mark the point. example: radius of 50 meters (employees will only be able to register the point within this radius) employee flow: Employee will log in to the app, the app will request their location, the app only allows registering entry or exit if the location is active The employee will only be able ...
I need a skilled professional to scrape specific data from various websites for my project. Hi here is this website it updates its data every minute, the data is in format of a table with 10 cells Each cell has one of the two variables (big or small) Same can be seen in the screenshot. I need to scrap 10 of these big/small variables
I am searching for an experienced Google Excel expert to assist me in refining and optimizing my current Excel tables for business purposes. Key Requirements: - **Formatting**: I need assistance in improving the aesthetic appeal and readability of my tables. This includes changes to font style and size, cell borders, and background color. - **Formulas**: The expert should be proficient in implementing essential formulas such as Sum, Average, and Count. They will play a crucial part in calculating and managing data effectively. - **Data Validation**: I need guidance on implementing data validation processes to ensure the accuracy and consistency of my data entries. Ideal Skills and Experience: - Proven experience in working with Google Excel and enhancing its functionalities. - Pr...
I am in need of an e-commerce website with a robust database. The site will primarily focus on selling digital products. I require the following: - Integration of multiple payment methods including credit card, PayPal, bank transfer, yape, and plin. - A secure and efficient database to manage product listings, user accounts, and transactions. - An easy-to-use, intuitive design t...Expertise in database management. - Experience in integrating multiple payment gateways. - UI/UX design knowledge. - Understanding of features that drive e-commerce success such as customer retention mechanisms. The source code of the web development and database must be delivered, as well as knowledge of the Spanish language. The website must be simple and fast, it must work for a computer, tablet and cell...
...again through Googling or going to the public service related website. We know that not all business unit information are publicly available, only what that public service publicly provided are enough. 3- Locations: Some public services have locations (branches). We need information like branch name, address, latitude, longitude etc. Often Google Map can be used to search for locations of a public service and Google Map shows all branches with more details including Latitude & Longitude List of Australian public services that we are looking for data are as below, however for each provider, we explained what kind of (General, Division or Location) is needed: -ASIC_[General, Divisions] -ATO_[General, Divisions] -Attorney-General's Department_[Genera...
I'm seeking a skilled app script professional to improve functionality in my current Google Sheets. The job entails creating connections with external APIs, and add a multiple drop down function in Google sheet. This is different than dependent drop-down and I require to use just one cell for the multiple drop down rather than using the next cell. Key requirements: - Add two dropdown menus - The menus need to feature a predefined list of words - Experience with Google Sheets and App Script Recommended skills: - Google Sheets - Google App Script - API Integration
...Classic. - Be comfortable working across iOS and Android platforms. - Have a portfolio of relevant apps they've worked on previously. - Be able to deliver a secure and user-friendly interface. I am looking to create an app for Android and iOS smartphones which uses Bluetooth or BLE technology, or similar technology, to transfer and receive small packets of data wirelessly between mobile phones, or cell phones, of the same and differing operating systems in a Mesh Network. There would be multiple users of the app within a 30 metre radius locality using an ad hoc, node to node, wireless system. The app must therefore have no reliance on WiFi, mobile data or any use of a WAP or a WiFi router. It can maybe use a technology similar to Z Wave or Zigbee wireless technology, and ma...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
...experienced US telemarketer for a cold calling market research campaign to gather feedback on Pool Service companies (business statistics, size, etc.) and software usage. Your tasks will include making calls, asking targeted questions, and gathering and reporting certain information in Google Sheets. Required: Availability from 9a-5p EST on 5/13 and 5/14, ability to make ~500 domestic calls from US cell phone/number. Key Responsibilities: - Conduct a series of cold calls to to pool service companies to collect data on their business statistics (size, etc.) and software usage (offering $USD incentive for participation) - Collect feedback on which specific Swimming Pool software they use, Net Promoter Score (NPS), Likelihood to Switch to a different software platform, etc....
...experienced US telemarketer for a cold calling market research campaign to gather feedback on Pool Service companies (business statistics, size, etc.) and software usage. Your tasks will include making calls, asking targeted questions, and gathering and reporting certain information in Google Sheets. Required: Availability from 9a-5p EST on 5/13 and 5/14, ability to make ~500 domestic calls from US cell phone/number. Key Responsibilities: - Conduct a series of cold calls to to pool service companies to collect data on their business statistics (size, etc.) and software usage (offering $USD incentive for participation) - Collect feedback on which specific Swimming Pool software they use, Net Promoter Score (NPS), Likelihood to Switch to a different software platform, etc. - Doc...
...old ways and use their brains for thinking! Be able to write with a pen! Arithmetic and communicate face to face with other humans incase...in the future , a rogue comet or something wipes out all the satellites in space so all technologie earth communications Key elements I'd like to see in the video include: - Light bulb, Brain, Question mark, All of the above, Bee sized yellow & Black brain cell balls that jump up and down to the Chorus! {You can see these in my video on U-Tube} Computers, laptops, desk tops, hard drives - Reading, writing, math - A comet wiping out all our digital communication.... in the future Ideal skills and experience for this project include: - Proficiency in 3D animation - Ability to convey complex messages through
I'm looking for someone who can bring creativity and professionalism to this project, and who is able to deliver high-quality work in a timely manner. Check attached picture as sample and provide a better design. Create a Conference Poster with the det...in a timely manner. Check attached picture as sample and provide a better design. Create a Conference Poster with the details below: AFRICA MUST THINK CONFERENCE 2024: National Heroes Stadium; 29th September, 2024, 12:00hrs to 17:30hrs Host: Dumisani L N’cube-The Radical Entrepreneur TICKETS: Standard-K100, Gold-K300 + Book, Platinum-K1000 + Books + VIP. Computicket (Across Shoprite outlets) Cell: +260 97 1782299 SELECT YOUR PREFERRED IMAGES HERE ?
...freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK AND THE TOTAL OF ALL NEED...
