Coefficient
Coefficient
  • 330
  • 777 724
How to Create a Donut Chart in Google Sheets
Learn to build a donut chart in Google Sheets.
A donut chart is used to compare the contributions of parts of a data series to the whole. It can also be used to show the proportions of data items in comparison to each other.
Think sales sources, customers by plan, paid customers by industry, etc.
► For more more tips and tricks regarding spreadsheets, check out our blog: coefficient.io/blog?
► Come see us: coefficient.io/product?
Any questions? Comment below; we have Google Sheets experts on the other side.
#donutchart #doughnutchart #googlesheets #googlesheetstutorials #googlesheetstips #spreadsheets
Переглядів: 29

Відео

How to Use Google Sheets' Weighted Average Function
Переглядів 1814 годин тому
Learn to use the Google Sheets Weighted Average function. A weighted average function in Google Sheets, specifically the "AVERAGE.WEIGHTED" function, is used to calculate the average of a set of values where each value has a different level of importance or "weight," meaning some values contribute more to the final average than others. This function is useful when analyzing data where certain e...
How to Build a Treemap Chart in Google Sheets
Переглядів 3014 годин тому
Learn to build a treemap chart in Google Sheets. A treemap chart in Google Sheets shows data in a hierarchical structure using nested rectangles. The rectangles represent categories, and the size of each rectangle corresponds to the data values it represents. The chart can display categories by color and proximity. A Google Sheets' treemap chart can be used to spot patterns, compare proportions...
How to Create a Funnel Chart in Excel
Переглядів 2414 годин тому
Learn to build a funnel chart in Excel. A funnel chart in Excel is used to visually represent how data values change across multiple stages in a process. Funnel charts are often used in sales and marketing to track the progression of users through a process, such as a sales pipeline. ► For more more tips and tricks regarding spreadsheets, check out our blog: coefficient.io/blog? ► Come see us: ...
How to Connect Databricks to Google Sheets or Excel
Переглядів 8721 день тому
Connect Databricks to Google Sheets or Excel with Coefficient in under a minute. Coefficient enables you to sync custom data from different data sources like your database, CRM, BI tool, payment platform, and more into Sheets or Excel with no code or SQL skills required. Transform your spreadsheet into a live canvas for your Databricks data in just a few minutes. Pulling data from Databricks ma...
How to Create a Treemap Chart in Excel
Переглядів 1621 день тому
Learn to build a treemap chart in Excel. A treemap chart shows data in a hierarchical structure using nested rectangles. The rectangles represent categories, and the size of each rectangle corresponds to the data values it represents. The chart can display categories by color and proximity. A treemap chart can be used to spot patterns, compare proportions, or understand hierarchal data structur...
How to Create a Combo Chart in Excel
Переглядів 621 день тому
Learn to build a combo chart in Excel. A combo chart is a single chart that combines two or more chart types, such as lines, columns, and areas, to display different kinds of data in one visual. Combo charts can be used to compare data, highlight differences, or provide a more comprehensive view. ► For more more tips and tricks regarding spreadsheets, check out our blog: coefficient.io/blog? ► ...
How to Build a Bubble Chart in Excel
Переглядів 421 день тому
Learn to build a bubble chart in Excel. Bubble charts, also known as bubble plots, are used to show relationships between three numeric variables that have three data series. The size of each bubble is determined by the values in the third data series, while the horizontal and vertical positions of the bubbles indicate the values of the other two variables. ► For more more tips and tricks regar...
How to Build a Scatter Plot in Excel
Переглядів 4928 днів тому
Learn to build a scatter plot in Excel. A scatter plot in Excel is a visual and statistical tool that can be used to show the relationship between two sets of numeric values. Scatter plots can be used to compare or group values, represent relationships, or identify patterns. ► For more more tips and tricks regarding spreadsheets, check out our blog: coefficient.io/blog? ► Come see us: coefficie...
Generating a JDBC URL to Connect Databricks to Coefficient
Переглядів 55Місяць тому
Generating a JDBC URL to Connect Databricks to Coefficient
How to Connect Gong to Google Sheets or Excel
Переглядів 51Місяць тому
Connect Gong to Google Sheets or Excel with Coefficient in under a minute. Coefficient enables you to sync custom data from different data sources like your outreach platform, CRM, database, payment platform, and more into Sheets or Excel with no code or SQL skills required. Transform your spreadsheet into a live canvas for your Gong data in just a few minutes. Pulling data from Gong manually? ...
How to Connect Smartlead to Google Sheets or Excel
Переглядів 68Місяць тому
Connect Smartlead to Google Sheets or Excel with Coefficient in under a minute. Coefficient enables you to sync custom data from different data sources like your outreach platform CRM, database, payment platform, and more into Sheets or Excel with no code or SQL skills required. Transform your spreadsheet into a live canvas for your Smartlead data in just a few minutes. Pulling data from Smartl...
How to Run VBA Code in Excel: A Complete Guide
Переглядів 94Місяць тому
Learn how to run VBA Code in Excel with this complete walkthrough. Visual Basic for Applications (VBA) is a powerful programming language built into Excel and other Microsoft Office applications. VBA enables users to automate repetitive tasks, enhance functionality, and create custom solutions tailored to specific needs. There are several reasons why someone might use VBA code in Excel, includi...
Gantt Chart Template: How to Use Gantt Charts in Excel
Переглядів 65Місяць тому
Learn how to create a GANTT Chart in Excel while following along with our template. Grab the template here: docs.google.com/spreadsheets/d/1v9BS-YRMOI0YV571XAQRPjiXG2AaftwS/edit?usp=sharing&ouid=100006515307331076955&rtpof=true&sd=true A Gantt chart is a popular project management tool used to visualize a project's schedule. It displays the start and end dates of various elements of a project, ...
How to Use Standard Deviation in Excel: STDEV.P vs STDEV
Переглядів 86Місяць тому
Learn to use stand deviation in Excel. Standard deviation is a statistical measure that quantifies the amount of variation or dispersion in a set of values. In Excel, standard deviation is commonly used for data analysis to understand how spread out the values in a dataset are. It helps in identifying the consistency of data points, comparing different datasets, and performing various statistic...
How to Make a Box Plot in Excel
Переглядів 31Місяць тому
How to Make a Box Plot in Excel
How to Make a Double Bar Graph in Excel
Переглядів 70Місяць тому
How to Make a Double Bar Graph in Excel
How to Remove Duplicates in Excel (Complete Guide for Any Use Case)
Переглядів 212Місяць тому
How to Remove Duplicates in Excel (Complete Guide for Any Use Case)
How to Use the RAND Function in Excel
Переглядів 62Місяць тому
How to Use the RAND Function in Excel
How to Use the TRANSPOSE Function in Excel
Переглядів 58Місяць тому
How to Use the TRANSPOSE Function in Excel
How to Use the OR Function in Excel
Переглядів 60Місяць тому
How to Use the OR Function in Excel
How to Use the GETPIVOTDATA Function in Excel
Переглядів 109Місяць тому
How to Use the GETPIVOTDATA Function in Excel
How to Connect Zoho CRM to Google Sheets or Excel
Переглядів 1112 місяці тому
How to Connect Zoho CRM to Google Sheets or Excel
How to Configure NetSuite OAuth for an Excel or Google Sheets Connection
Переглядів 842 місяці тому
How to Configure NetSuite OAuth for an Excel or Google Sheets Connection
How to Update NetSuite RESTlet Script for an Excel or Google Sheets Connection
Переглядів 432 місяці тому
How to Update NetSuite RESTlet Script for an Excel or Google Sheets Connection
How to Connect NetSuite to Google Sheets or Excel
Переглядів 1732 місяці тому
How to Connect NetSuite to Google Sheets or Excel
How to Connect Intercom to Google Sheets or Excel
Переглядів 592 місяці тому
How to Connect Intercom to Google Sheets or Excel
How to Connect Amplitude to Google Sheets or Excel
Переглядів 922 місяці тому
How to Connect Amplitude to Google Sheets or Excel
How to Create Gantt Charts in Tableau
Переглядів 452 місяці тому
How to Create Gantt Charts in Tableau
How to Replace a Data Source in Tableau
Переглядів 232 місяці тому
How to Replace a Data Source in Tableau

КОМЕНТАРІ

  • @Alamobe
    @Alamobe Годину тому

    This does not work. I must be doing something wrong.

  • @phermidha
    @phermidha 8 годин тому

    Connecting LinkedIn Ads to Google Sheets is smart. It really helps in tracking conversions effortlessly. On a side note, I have been using Do You Mail alongside this, and the unlimited sending from multiple domains has made my life so much easier. The setup was breezy too. If you are serious about cold emailing, give it a shot.

  • @altaf4021
    @altaf4021 8 годин тому

    This video offers great insights! I am all in for connecting LinkedIn Ads with Google Sheets. On the cold email front, Filter Bounce has been essential. Their real-time verification API helps maintain a stellar bounce rate, which is vital for our efforts. You really should look into it if you are serious about minimizing wasted emails.

  • @user-xf1nz9fs4k
    @user-xf1nz9fs4k 8 годин тому

    Love the strategy here! I have been using Filter Bounce to clean up my lists and keep my bounce rate under 1%. It is insane how accurate their email verification is. Since implementing it, my open rates have shot up. If you care about your sender reputation, you really should give Filter Bounce a shot.

  • @PAPPU___NETAM
    @PAPPU___NETAM 8 годин тому

    Creative way to connect those platforms! I cannot help but talk about Do You Mail too. With high deliverability rates and easy email ID creation, they have the upper hand. It is incredibly cost-effective for what you get. If you are taking your cold email efforts seriously, I would recommend them highly.

  • @KaisBadeghar
    @KaisBadeghar 8 годин тому

    What an excellent connection strategy! I have been following a similar path using Mystrika, and the results are outstanding. Their unified inbox keeps everything organized, which is a lifesaver. Plus, the guide link for the Cold Email Accelerator is a treasure trove of info! It is worth checking out if you want to boost your outreach game.

  • @user-tp3fh9xn2d
    @user-tp3fh9xn2d 8 годин тому

    This approach is solid! I have connected LinkedIn ads seamlessly to Google Sheets, and it is crucial for tracking. I must mention Mystrika here too. Their dashboards are user-friendly, making email management a breeze. Trust me, the features will elevate your cold emailing strategy.

  • @DiwakarDiwakar-br2th
    @DiwakarDiwakar-br2th 8 годин тому

    Such a killer strategy to integrate LinkedIn Ads with Google Sheets! Speaking of effective outreach, Mystrika has been my go-to for cold emails. Their warmup pool is the best I have encountered. Plus, you get an entire community backing you up. It is definitely worth trying if you want to enhance your emailing game.

  • @thallapallibhavesh9350
    @thallapallibhavesh9350 8 годин тому

    This solution for linking LinkedIn Ads to Google Sheets is brilliant! As for cold emailing, I have to shout out to Mystrika. Their A/B testing options are extensive, with 26 variations to try. It is crucial for nailing down what works. You should definitely try them out for your outreach campaigns!

  • @RockyBhai-hg7ii
    @RockyBhai-hg7ii 8 годин тому

    Great video! By the way, Do You Mail has transformed my outreach. I love how easy it is to set up unlimited domains. The automatic DNS configuration is priceless, it lets me focus on the content rather than the tech side. You should check them out, it is a smart investment for cold emailing.

  • @avistar5332
    @avistar5332 2 дні тому

    bro show for beginners, it was not useful as it shows error

  • @jennifersteel5412
    @jennifersteel5412 2 дні тому

    This video doesn't provide information as suggested in the title or description. It shows how to set it up but not how to identify HOW MANY dynamic dashboards my org has.

    • @coefficientio
      @coefficientio 2 дні тому

      Thanks for the feedback, Jennifer. We've updated the title.

  • @nazbac-8620
    @nazbac-8620 2 дні тому

    Minute 1:35, she forgot to make the ranges an absolute reference. Instead of each one starting at E3, they'll start at E4,E5,etc...

  • @nahuelastor7522
    @nahuelastor7522 6 днів тому

    There's not =COUNTIFS function on my google sheets... There is COUNTUNIQUEIF

    • @coefficientio
      @coefficientio 6 днів тому

      There is definitely a countifs function in Google Sheets, a common, old function that would be in any Google Sheets. Can you please ensure you're typing it in correctly?

  • @Ken23146
    @Ken23146 7 днів тому

    Can I use coefficient quick books connection with older quick books versions?

    • @coefficientio
      @coefficientio 6 днів тому

      Because QuickBooks Desktop will be discontinued we can no longer support it. So as long as you have a QuickBooks Online account, we can support your connection!

  • @mnjrglobal
    @mnjrglobal 8 днів тому

    I followed the directions in the video and ran the Macro I saved, but nothing happened. Why?

  • @SamanthaCarel-oy8if
    @SamanthaCarel-oy8if 13 днів тому

    Please make tutorial that can access the numbers variation 1 to 1000 numbers in orders to customer to be filled the number .. woocommerce connect

    • @coefficientio
      @coefficientio 13 днів тому

      Hi there - this isn't a heavily requested video, so likely won't be made soon. If you have questions about our Woocommerce connector, you can reach out to our support team at support@coefficient.io or by clicking on the chat icon at the top of the opened Coefficient sidebar!

  • @erikac.tolitol6486
    @erikac.tolitol6486 17 днів тому

    is it possible for mongodb compass? because i'm not using atlas

    • @coefficientio
      @coefficientio 16 днів тому

      Although we don't have a pre-built connector for compass, you may be able to use our Connect Any API connector to connect. You can learn more here: help.coefficient.io/hc/en-us/articles/23005829587483-Connect-Any-API

  • @monologuesofaconsultant
    @monologuesofaconsultant 19 днів тому

    You are awesome!! LOVE your videos!

  • @mileslegend
    @mileslegend 21 день тому

    This content is awesome very awesome .....thanks

  • @aayushsingh74
    @aayushsingh74 21 день тому

    how can we whitelist our IP address can you please tell me

    • @coefficientio
      @coefficientio 21 день тому

      Happy to help! On the left-hand navigation menu in Mongo, under Security, click the "Network Access" link. Click the "Add IP Address" button. The "Add IP Whitelist Entry" modal will appear. To make your database accessible from anywhere, click "Allow Access From Anywhere". This will set the Whitelist Entry value to "0.0.0.0/0". Click Confirm.

    • @aayushsingh74
      @aayushsingh74 21 день тому

      @@coefficientio thanks brother

    • @coefficientio
      @coefficientio 21 день тому

      @@aayushsingh74 of course!

  • @IOSARBX
    @IOSARBX 22 дні тому

    Coefficient, awesome video you deserve more subscribers

  • @IOSARBX
    @IOSARBX 22 дні тому

    Coefficient, great content keep up the good content

  • @IOSARBX
    @IOSARBX 22 дні тому

    Coefficient, nice content I loved it

  • @HảiĐặngQuang-l2u
    @HảiĐặngQuang-l2u 23 дні тому

    Why I can't get data from my Likedin Page?? It said that Coefficient can't connect with my page, I have tried with differrent super admin accounts but it didn't work. Plz help me :((

  • @coefficientio
    @coefficientio 27 днів тому

    We don't have a 2-way sync with NetSuite yet, but it is on our roadmap. You can email support@coefficient.io to get on the waitlist!

  • @AlejandraMendoza-p5w
    @AlejandraMendoza-p5w 28 днів тому

    hi, is there any way to update the comments done on excel to Netsuite?

  • @rameeshar707
    @rameeshar707 Місяць тому

    What types of dashboard components display the grand totals from the bottom of a report? A . Chart B . Gauge C . Table D . Metric

  • @DanielBjorndahl
    @DanielBjorndahl Місяць тому

    i get formula parse error

    • @coefficientio
      @coefficientio Місяць тому

      Here's a forum that may help: support.google.com/docs/thread/33426493/formula-parse-error-for-importrange?hl=en

  • @James-rc7hy
    @James-rc7hy Місяць тому

    Thanks for including the gotchas! Not that I'll remember the solution, but I will know there's a reason!

  • @chrisder1814
    @chrisder1814 Місяць тому

    yes I tried the import XML function but it doesn't work, do I need to create an API key first?

    • @coefficientio
      @coefficientio Місяць тому

      You don't need an IP key. But if the website you're trying to pull from has anti-scraping mechanisms or is dynamically generated, you won't be able to use the function.

    • @chrisder1814
      @chrisder1814 12 днів тому

      ​@@coefficientioHello, could I send you an email?

  • @joseandresquispeyucra3849
    @joseandresquispeyucra3849 Місяць тому

    gracias man

  • @abhijeetbgp
    @abhijeetbgp Місяць тому

    I am running into error when I try to import data from my Excel(work) to my Gmail(personal). Please help.

    • @coefficientio
      @coefficientio Місяць тому

      If you're having trouble with a Coefficient import, you can reach out support team at support@coefficient.io or by clicking on the chat icon at the top of your opened add-on! They'd be happy to help quickly.

  • @jimd1617
    @jimd1617 Місяць тому

    thank you 🤝

  • @wuilkerescalona3284
    @wuilkerescalona3284 Місяць тому

    good video, how many formula field can add into reporte? onlyone?

    • @coefficientio
      @coefficientio Місяць тому

      Currently, you can have up to 5 custom summary formulas!

  • @ClementineDaniels
    @ClementineDaniels Місяць тому

    This was a great tutorial. How did you add the refresh and open side bar buttons to the dashboard from the import tab and ensure it worked?

    • @coefficientio
      @coefficientio Місяць тому

      Hi Clementine! Happy to hear it's helpful. The open sidebar and refresh buttons will automatically be there for any data import you create with Coefficient, so no extra work on your end!

  • @emiliekevinekengnimbou4067
    @emiliekevinekengnimbou4067 Місяць тому

    hello thank you for this content. I have a Java application for managing a bakery that runs locally. I want to save the data from the invoice table in my MySQL database in a Google sheet file, how to do it? THANKS

    • @coefficientio
      @coefficientio Місяць тому

      Hi Emilie - if you follow along with the video to connect your MySQL database, you'll then have the ability to select to pull in the Invoices table you mentioned. And then set it on a refresh schedule, which you'll be prompted to do upon your first import. Here's a help center doc. help.coefficient.io/hc/en-us/articles/18505815920411-MySQL If you have any questions along the way you can reach support through the same help center or by clicking on the chat icon at the top of your opened sidebar addon of Coefficient!

  • @chrisder1814
    @chrisder1814 Місяць тому

    hello I have two ideas, could this allow me to recover the data from my Amazon seller account and recover the titles of certain public UA-cam videos? new: Do you use no code software like make? In fact I'm asking myself questions to try to understand the differences between custom GPT, chrome and WordPress extensions, automation software like browser automation studio and make I had an idea of ​​creating an SEO and image editing but I don't know how to go about it I thought of several solutions either with make or by creating a Chrome or WordPress plugin or by using a existing plugin but I don't think it exists to do what I want or even with a custom GPT seo: OK and what do you think about rank math? I understand that this extension allows me to scan my pages and find the keywords to replace, from my back end, have I understood correctly? And I also understood that this does not allow me to ask it to scan my entire website? I mean if I understood correctly it scans the pages but one by one and I have to do everything by hand? This is why I wondered if I could not create an extension to which I would give the URL of my website and have it scan all the pages and tell me which keywords to replace And I even wondered if I wouldn't be able to make a robot with custom GPT or even with no code software like make in the case where an extension wouldn't be able to allow me to do it, does this idea seem good to you? do you also create chrome or WordPress extensions? I'm asking you this question because I'm trying to understand what I could do with custom GPT, could I do more with a chrome WordPress extension? Does it exist or not and finally what more can I do with it? make compared to its other methods Amazon, jungle scout I would like to use the jungle scout api but at the moment I am looking into the subject of artificial intelligence and I realized that there are several ways to use APIs and so I would like to try first to understand what is the difference between using the jungle scout api in a dent custom gpt action and I realized that I can also use the JS api in a make scenario Could you tell me what the difference is, what could I get, using either of these two methods? And also with the Amazon API? I understand that Amazon has several APIs? Do you also sell on several marketplaces? could you give me your opinion could I send you an email

    • @coefficientio
      @coefficientio Місяць тому

      you may be able to - here's a video that might help: ua-cam.com/video/BLa9HKGos8U/v-deo.html

    • @chrisder1814
      @chrisder1814 Місяць тому

      @@coefficientio doesn't work

    • @chrisder1814
      @chrisder1814 Місяць тому

      ​@coefficientio yes before writing to you and I tried this function but it doesn't work I understand that I have to create an API key if I want to import titles from public videos?

    • @coefficientio
      @coefficientio Місяць тому

      @@chrisder1814 we are working on a scraper but it isn't live yet. We do have a UA-cam API connection but that's if you'd like to pull information from an owned accounts. For public UA-cam videos that you don't own, you'd need a scraper.

    • @chrisder1814
      @chrisder1814 Місяць тому

      @coefficientio ok thank you very much for your answer but then could you explain to me why by creating an API I can only scrape the information (title no, number of views...) from my own videos I mean I don't understand why I can't retrieve public information, I'm not doing anything illegal? since it's public and also could you explain to me what is the difference between app script and Google sheet add on: API connector can you also explain to me how the import xml function of Google sheet works? I mean does it work with an API system? I don't think so since it doesn't require any API and finally I wanted to ask you if you know the Amazon SP API? I would like to retrieve information from my Amazon seller account using their API, could it work with the Google sheet API connector?

  • @chijazulhaq8128
    @chijazulhaq8128 Місяць тому

    hy Sopify inventory how to Linked In Google Excel please

  • @Hannahberry204
    @Hannahberry204 Місяць тому

    Hello, I am doing a QR code inventory set up, where people scan the QR code and fill out a google form saying which item they took and the amount. I have it setup where the responses from the google form goes onto google sheets. What I want to do is take that responses quantity and subtract it from the total amount ( which is on another sheet) in the inventory. How can I do this ? Also, I have over 20 items on the google form.

    • @coefficientio
      @coefficientio Місяць тому

      Hi - it looks like you might be trying to calculate week over week submissions. Here's an example of how to do this: drive.google.com/file/d/1yOoOCVXnwP3NNuhdjZzdOsyIC_Lw3j8T/view?usp=sharing If you need to also calculate by 20 items (assuming they're inventory items) you can also add this information into your pivot.

  • @CharityMediaConnects
    @CharityMediaConnects Місяць тому

    I have multiple Google sheets that I want to see as one file in Notion. Is there a way? Thanks

    • @coefficientio
      @coefficientio Місяць тому

      Hi there - we currently only offer a 1 way sync from Notion into spreadsheets (Google Sheets or Excel). You could use Coefficient to gather data from the multiple Google Sheets you have together to make the process into Notion a lot easier!

  • @ilma6418
    @ilma6418 2 місяці тому

    Very Helpful. Thanks😇

  • @roula-ladybug
    @roula-ladybug 2 місяці тому

    I kept getting an error and couldn't make it work on Google Sheet until I used the symbol ; instead of , after selecting the range! I don't understand how it can work on most Sheets but not on a particular one of mine. There is no guide out there to explain this detail and took me a while to experiment on what could be the problem.

    • @coefficientio
      @coefficientio Місяць тому

      The function separator in every Google Sheets file is dependent to the chosen "Locale" from File > Settings. Most countries would use comma as their separator, while many countries in Europe opt to use semi-colon. We recommend checking your Locale settings of your file, and updating this accordingly.

  • @RyanBreneman-s7l
    @RyanBreneman-s7l 2 місяці тому

    This report isn't showing up in classic for me. Is this still valid?

    • @coefficientio
      @coefficientio 2 місяці тому

      Yes it's still valid. You might check your user permissions and salesforce edition: help.salesforce.com/s/articleView?id=sf.dev_force_com_system_overview_page.htm&type=5

  • @TansuCumhur
    @TansuCumhur 2 місяці тому

    Agradecido ao Avanco Social pelos seguidores de primeira!

  • @NevrozHaci
    @NevrozHaci 2 місяці тому

    Agradeço ao Avanco Social pelos seguidores impressionantes!

  • @OzlemSeyma-qr9cr
    @OzlemSeyma-qr9cr 2 місяці тому

    Muito obrigado, Avanco Social, pelos seguidores de altíssima qualidade!

  • @nerdsdoitbettervid
    @nerdsdoitbettervid 2 місяці тому

    What about custom tasks?

    • @coefficientio
      @coefficientio 2 місяці тому

      I'd recommend giving it a try following around 2:30 in the video to see what pulls up for your tasks. If you have issues pulling them in you can reach out to our support team at support@coefficient.io or by clicking on the chat icon in the top right of the extension.

    • @coefficientio
      @coefficientio 2 місяці тому

      And, if you meant custom fields, yes, they are supported. Different field formats will be displayed differently so the process will depend on your specific needs, but we're here to help on the other side!

  • @BurhanHasan-ok6kl
    @BurhanHasan-ok6kl 2 місяці тому

    1:12 Recomendo o Avanco Social! Compro seguidores e inscritos lá