Automatic searching excel data jobs

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good ...

The Soul Barn logo existing logo to be adapted Please read* 1. I would like to keep the barn out line. 2. Keep the words ‘The Soul Barn’ but change the font to something a bit more interesting 3. Add the word Noosa (remove Noosa Hills) 4. Add ‘Animal Assisted Therapy’ under the barn in smaller font 5. Change the background colour to one provided 6. Open to a creative flair on font I'm searching for a talented graphic designer to help breathe new life into my company's logo. I am currently not satisfied with the existing design and want to focus on modifying the color scheme and typography, with a possible addition of few words. Key components of the project include: • Transitioning the color scheme to earth neutral tones from its existi...

I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Le...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportuni...opportunities; * Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...

...able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - ...

No AI bidder needed. I'm searching for a skilled artist to create unique and engaging cartoon-style artwork for my YouTube videos. I'm planning to open YouTube channel of technology Please see attached pdf. I want the image in this pdf to be more simple, cartoonish and universal. If I find a suitable artist, we can work for a long term and I will provide more images. Budget is $10 per image. Please apply with your previous work related this project and start with the word 'Apple'.

I'm searching for a skilled writer with open water and pool expertise to create authoritative blogs focused on the sport and its link to wellness. Your role will involve crafting engaging content that provides our swimming network with valuable insights and advice on all things swimming. The chosen candidate will have a specific focus on: - Techniques and skills - Safety tips - Equipment reviews - Open water swimming - Swimming tourism - Pool coaching - Swimming community wellness - Detailed understanding of pool strokes, open water, and marathon swimming - Write engaging, informative blogs on all aspects of swimming (mostly related to our Swimming Adventures) - Ensure content accuracy - Engage with swimmers by addressing common concerns and questions - Their proven swimmin...

I am searching for an experienced workbook designer to collaborate with me to develop an engaging and effective workbook for emerging documentarians. The workbook content will include: - Instructional text - Quotes - Writing prompts - Visual aids (charts, graphs, images) I already have a cover design, mood board, color palette, initial sample layouts, and draft text. I would like a designer to work with me to create templates that I can fill in (either using InDesign or another platform) that will guide my writing and work prompts process. Once I have completed a first draft of the workbook, the designer will collaborate with me to finalize page layouts and manage the printing/production process. Ideal Skills and Experience: - Experience in designing workbooks and workbook...

...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. *...

We need to redesign our website into a more modern and responsive version with increased conversion potential. The main sections should be: Home page: Search page: (you can view it by performing a search on the site) Individual hotel page: Individual offer page: https://www.ischiahotel.net/d...signshare&utm_medium=link&utm_source=editor I do not want templates from ThemeForest or other marketplaces. Before assigning the work, I want to see a design draft, and then I can entrust it to someone. I would prefer it to be made with Bootstrap 5 because I am familiar with the framework, but it is also fine without it Budget maximum: 70 USD Please reply only if interested I not reply to automatic message

...Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automati...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight meas...for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of sto...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and ...

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

...a Shopify expert who can help me create a remarkable online store that will feature electronics and home decor products. My target audience includes young adults, parents, and tech enthusiasts. To make the shopping experience top-notch, I'd like the following features implemented: - Product Search/Filtering: Customers should be able to easily find the products they are looking for, either by searching for it or using filters to narrow down their choices. - Wishlist: It would be great if customers could add products to a wishlist for future purchase or for sharing with friends and family. - Customer Reviews: Creating a space for honest product reviews from my shoppers will be key to building trust and driving sales. The ideal candidate should have proven experience in desig...

...This website's primary purpose is to sell aftermarket vehicle accessories. Therefore, the platform must be designed to facilitate easy browsing, product selection, and checkout. - Select accessories based on Car Make, Model, Varient and Year filters needed. - Inventory Management: I plan to sync my product inventory with a supplier's database. This means the site must be capable of handling automatic updates and stock levels. - Payment Methods: I intend to offer Credit Card Payments, UPI, and Debit Card payment methods on the site. Ideal Skills and Experience: - Proficient in Woocommerce: You should have a strong background in working with the Woocommerce platform, with a focus on e-commerce design and development. - Inventory Management Expertise: Experience in integ...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly i...

I'm searching for a tutor skilled in Power BI to deepen my knowledge in dashboard creation, data modeling, and data analysis. Your rich experience in the finance, marketing, or healthcare industry will give a practical edge to my learning. My main objective is to master the tools required for analyzing business data.

I am in need of an experienced Vue.js developer who can quickly fix my Vue 2.6 application. When I click on a button to go to another page it works fine in development but when I deploy it gives a 404 error. I need this fixed as fast as possible. When you respond to this posting please put "I CAN DO IT" at the beginning of your bid. I don't want to waste time with automatic bids that nobody answers. And please bid honestly and not low ball then ask what's your budget. I will upload the project when I find a person

As a friend group planning a lively bachelor party, we're searching for an enthusiastic individual who could step into the role of a wiffle ball game umpire for approximately 2 hours. Minimal baseball knowledge and rules required. Balls and strikes not required, just things like safe and out. Key Responsibilities: - It would be great if you’re able to provide some commentary throughout the game, similar to a game commentator. You can make fun of anyone who swings and misses, or makes an error; things like that. It’s very informal, but the more lively, the better. Necessary Skills and Experience: - Understanding of basic baseball rules like safe and out. - Energetic, fun-loving, and enthusiastic attitude. - Excellent audience engagement

I need an experienced engineer to design a Python-based program for a two-axes programmable motion controller that can be integrated into our food processing machine. Key Responsibilities: - The program should support speed control and position control functions. - The system should also feature an automatic reset. Ideal Candidate Skills: - Proficiency in Python programming language - Previous experience in motion control programming - Familiarity with the dynamics of mixing and blending systems in food processing The controller will be used for a mixing and blending system. Please bring any experience that could be relevant to this task. Your expertise is very valuable to us.

I'm searching for a seasoned full stack mobile application developer to create a highly functional mobile app. This application will be developed for both Android and iOS platforms. Key Features: - User Application: This will allow users to register and scan QR codes to obtain queue numbers. - Admin Application: This console will be used to call customers and manage respective details. Additional Attributes: - The user app will need integration for Push notifications, Location tracking, and Social media platforms. Ideal Skills: - Full Stack Mobile App Development - QR Code Integration - Real-Time Notifications Integration - Strong knowledge in Geo-Location features - Social Media APIs Experience with these features, particularly within queue-management systems, w...

... Key Features: - Scheduling Surveys: The system should support date availability checks, scheduling and booking confirmation via WhatsApp to our staff. Their responses should organise them into yes and no groups. This will help us automate repetitive tasks and sharing of information to groups of people. - CRM Management: I am an agent to film ans supply extras for background. This requires searching for certain character features of our staff. For example brown hair, 5"4 female. of male 6'2 blonde. I then send a availability check to work on certain dates and if they agree i send their profile to the production for approval. The approved staff then get added to a whatsapp "mailing list to communicate with as a group but each person receives a private message. - ...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

Productcatalog as PDF output. I have worked before with Microsoft Publisher, but I search a solution for 2 Catalogs. First Catalog with small products and easy products with photos, details, part number, price for automatic publishing via a Excel File and the second Version is a Catalog which i must make with a software manuell/self, because very strong products, which are not possible to create via excel, only a catalog as information and .... have you a easy and good solution for us, that we can change weekly the products because we add every week 10-50 new products in our excel / erp / website and in the brochure than. But we need a easy software which we can edit self very easy, but with high quality design and for printing as PDF and for Printing with Pri...

I require a skilled contractor to integrate an existing API from an unspecified shipping carrier into my Prestashop store. This integration would enable automatic interaction between the carrier and my store. The key functionality sought is for the automatic posting of customer orders to the carrier's system and the subsequent status update in the Prestashop system whenever the carrier adjusts this status. What I expect from freelancers: - Past work details should be included in the application to demonstrate experience and expertise. Required API Functions: - Customer orders made in Prestashop should automatically post to the carrier system via their API. - Any changes of status made by the carrier should reflect in the Prestashop orders panel. Anticipated Status Cha...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

I'm searching for an experienced video editor who can help me enhance my raw footage into captivating music videos with a cinematic touch. Key Responsibilities: - Edit raw footage and create high-quality, engaging music videos - Implement cinematic editing style - Apply color grading to enhance the final video Ideal Skills and Experience: - Proven experience in editing music videos - Proficiency in cinematic editing style - Strong understanding of color grading - Excellent eye for detail to ensure high-quality output

...in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel docu...

I need add an automatic stock control to Amazon, currently the catalogue is contained on a CSV

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I'm searching for an experienced translator to help convert my English brochures to Simplified Chinese. The primary theme of these brochures is financial education, and the translated version needs to be professional and engaging, aimed at working professionals. Key Requirements: - Native Chinese speaker or equivalent proficiency - Proven experience in translating brochures content - Understanding of content writing - Ability to capture the nuances of the English text while ensuring a fluent and professional tone in Chinese Ideal Skills: - Translation - Content Creator - Chinese Language Proficiency - Brochure Design and Editing I'm looking forward to working with someone who is not only adept in translation but can also adapt the content to fit the target audience'...

...Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to fetch tweets within a specific date range through an added menu in Google Sheets. 3. Data Integrity: - Ensure that existing data in Column B is not overwritten, preserving manually entered or previously fetched data. 4. Customization: - Clearly mark sections in the script for easy customization, such as token keys and Twitter account details, to allow fo...

I'm searching for a talented developer to create an application that caters to a non-profit organization's needs. This application will be downloadable on both IOS Appstore and Google store, seamlessly interacting with both Apple and Samsung devices. The key features should include: - Task/Event Management: The app should provide an avenue for the creation and assignment of tasks or events. It will be fundamentally used for administrative organization and must hence accommodate this featured component efficiently. - Notification System: Having a reminder and update system is crucial for the app’s functionality. Timely notifications about upcoming tasks or events should lead to seamless organization. - RSVP Functionality: Incorporate a system that allows users to RSV...

...Scrapy to extract product data from This project involves scraping the Category page to retrieve product details including name, price, SKU, URL, breadcrumb, currency, and brand. Targeted webpage: Category page of Required data: Product name, price, SKU, URL, breadcrumb, currency, and brand Experience: Prior experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all categories must be contained within the scraper and be automatic, ensuring dynamic upd...

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I am searching for a skilled game developer with expertise in C++ and sufficient experience with the Unreal Engine to construct a modded APK for an action game. The desired modifications include: - Unlimited resources - God mode - Unlock of all levels - Customization The perfect freelancer for this project should have a deep understanding of mobile gaming, and proven experience in APK modding. Familiarity with action games will be a significant advantage.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I am searching for an adept article writer, ideally with experience in the health and wellness field. - Topic: The articles will primarily focus on health and wellness, providing valuable insights and tips to readers. - Format: The articles should be structured as listicles, providing organized, easy-to-digest content. - Tone: The writing should inspire and motivate readers, with an emphasis not on formal academic language but on uplifting, moving discourse. Ideal skills would include significant experience with article writing, especially listicles, and a depth of knowledge on the subject of health and wellness. Familiarity with motivational writing or a keen interest in health and wellness will be a huge plus. Fluency in English, excellent research abilities, and originality...

I'm working on a small React and MongoDB app and need someone to help me complete it. Key Features: - User Authentication - CRUD Operations (Create, Read, Update, Delete) - Data Filtering and Searching. Design: You'll need to use basic Tailwind components to create the UI as I haven't designed it yet. External APIs: I'm not sure if the app will require any external APIs or integrations, so guidance on this would be appreciated. Your role will primarily be to help me finish this project and ensure it functions smoothly. Prior experience with similar projects will be a plus. project details- The database that needs to be used is mongo db and react will be used All users should arrive at the login page User1 – admin user - Once log...

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

I'm searching for an expert in web hacking and network penetration. The core task will involve identifying potential vulnerabilities within a website and working towards fixing these loopholes, while focusing on protecting and securing a database ID and password. A successful candidate should possess the following skills and experience: - Proficient understanding of web hacking and ethical hacking - Experience in network penetration testing to identify vulnerabilities - Knowledge of password recovery techniques - Proven record in enhancing website security The ultimate goal of this project is to strengthen the current security measures on my website, and to protect sensitive data. Your work will majorly revolve around securing the database ID and password. Please, com...

I'm searching for an experienced interior designer with expertise in minimalist style for my project. This talented individual will be tasked predominantly with furniture layout and design, with the goal of creating a tasteful, comfortable, and functional living space. Key Deliverables: • Innovative layout designs for furniture • Drafting minimalist styled furnishing concepts Ideal Skills and Experience: • Extensive experience in Interior Design • Solid understanding of minimalist style • Proficient in furniture layout and design • Excellent eye for spatial awareness and detail.

...Firebase integration. The project involves creating a Wishfy lookalike app for both Android and iOS platforms. Key Features: - User Registration & Login: The app should allow users to register and login securely. - Product Browsing & Searching: Implement a user-friendly interface for browsing and searching products. - Wishlist Management: Users should have the ability to create and manage their wishlists. Firebase Integration: - Authentication: Implement Firebase authentication for secure user onboarding. - Firestore Database: Utilize Firestore for efficient data storage and retrieval. The ideal candidate for this project should possess: - Proven experience in developing Flutter apps for both Android and iOS platforms. - Strong understanding of Firebase ...

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

I'm looking to develop a sophisticated software for managing the maintenance and service aspects of my heavy-duty truck fleet. The system should be able to accomplish the following: - Maintenance Scheduling: Implement a robust maintenance scheduling system to ensure timely servicing of trucks. Print report of due data - Inventory Management: Inventory control for trucks list, spare parts, ensuring they're available when needed. Warn when low count, - Service Reminders: Automatic reminders for upcoming services and maintenance checks. - Reporting and Analytics: Provide detailed reports and analytics for performance evaluation and decision-making. - User Roles: Multiple user roles - for fleet owners, store manager, service technicians, and drivers. - Parts Management...

I'm looking for a detail-oriented researcher to help me gat...- charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be ref...