Lun big size formula excel. I need to find a way to find data via a function.

Lun big size formula excel The version is Excel 365 on the laptop (i. Reconnect users: Once the expansion is complete, reconnect the users to the LUN. May 1, 2014 · But remember to press ESC not Enter as pressing Enter converts that selected portion of the formula to absolute values. Post few example and desired outcome so that we can suggest simpler formula. Open the Excel app> Account> Take a screenshot and share it with us. For example, 444Gb I would round up to 500Gb, 689Gb I would round up to 750Gb and so. Or you can do it using an array formula (in Excel 2016): =TEXTJOIN(" ",FALSE,HEX2BIN Aug 21, 2015 · I wanted to know if there is a better solution for a large, dynamic dataset whether it is a formula or VBA. When dealing with large datasets in Excel, many users encounter a few common challenges. It reduced the file size by a few percent, but otherwise didn't really help. Lun Big Size Formula. May 1, 2013 · First we need our raw LUN data In my example you'll see 5 populated columns in an Excel sheet. xlsb) Reduces the File Size. Many of the pieces are array formulas, as well. Aug 26, 2010 · Some Excel files showing very large size ranges from 10 MB to 125 MB. Lun Big Size Medicine Formula Jis Se Nafs Ko Bara Karne Ka Tarika Hai. May 12, 2020 · There are native bin2hex and hex2bin functions in most excel implementations/clones and they are horrendous (just look at the examples given by M$). To do this task, use the MIN, MAX, LARGE function, or LARGE functions, rather than Sum. Unfortunately, you cannot disable the Spill feature in Excel. If the Kth position is greater or larger than the values, there is an Apr 28, 2019 · I have spent all evening trying to find some sort of calculator within excel that can do this, and have found nothing. n, n^2, n^3, 2^n, log(n). of spreadsheet file File is currently 120MB big To expand the Formula bar (so you can see everything it contains), click the tool at the very right edge of the Formula bar. It's just because Excel won't be able to calculate data setups with large formulas. :-) You can import the data you have now fairly Aug 8, 2015 · My formula seems to work fine on smaller data sets but excel crashes when I try to do this, understandably so since it is a 400k line table. Sep 6, 2017 · It doesn't necessarily seem consistent with how much data is in the sheets; some have macros, some don't. Sep 23, 2020 · Try playing around with the numbers and see if they approximately fit one of the "standard" complexity functions, e. It's filled with about 25% data and 75% formulas. The standard volume size is expressed as an exact number of Mod 1 equivalents (which is 1113 cylinders). e. Formula: To calculate the 95% confidence interval for a sample mean of 10, with a standard deviation of 4, and a sample size of 25, the formula would be: CONFIDENCE. May 14, 2008 · So to summarize and build the formula: 30 x (your average disk size) + 30Gb VM swap + 15% of (30 x your average disk size) = calculated LUN size. 6MB in size. And if the recommended bin size is 5, then the same but in half those increments. Obviously that's too large for it to work fast, and since I don't have a lot of data, the problem seems to be the SUMIF formulas I use. With the cursor in the formula bar, those non-contiguous cells are highlighted, as if only those cells would be totaled. After pressing F9. Is there a way to make this less CPU intensive so that Excel completes this? Is there a better way to be doing this? Here is the current formula I am using: =MIN(IF(A1=D1:D400001,E1:E400001)) ctrl+shift+enter Dec 13, 2012 · I have this problem with a large excel add-in with plenty of code and then some where it grows from ~5Mb up to ~8Mb with minor code changes. I am a CPA/MIS and have taught multiple classes from Introductory Excel to advanced VBA programming. I use Office Professional Plus 2019 Thanks in advance. You can manually auto-size the formula by double-clicking the formula bar's bottom border once the cursor has changed to a re-sizing cursor. You can follow the mentioned techniques with practical steps to improve the performance of large workbooks. Improve your statistical analysis with our step-by-step guide, covering key concepts like margin of error, confidence level, and population size. The procedure to find the year’s top performer using the LARGE Excel function with VLOOKUP are: Select cell B16, enter the formula =VLOOKUP(LARGE(B2:B13,1),B2:C13,2,0), and press the “Enter” key. The total appears in bottom right of Excel screen. Excel tables maintain data consistency by enforcing uniform formatting and automating formulas. In difference to the fixes in the other answers above, I do not change any sheet formatting, it is only code. Which has many formulas and datas eventhough the size is too large compared to another files. I was therefore wondering whether something else, such as (conditional) formatting has an impact on file size. In the guide below, I will walk you through both these functions using multiple examples. The report works great! It is easily manipulated for all of the one-off requests I receive and the information is well presented and useful to my many customers. Feb 3, 2022 · Copying similar formula from another cell, I have been a power user of MS Excel since version 5. When working with large datasets in Excel, file size can become a concern. Excel parses every formula in data validation as an array formula. Jul 11, 2014 · 1. This doesn't make any sense. You can use a formula to calculate how much usable capacity there would be in a given size array LUN, or to calculate how large an array LUN has to be to provide the amount of storage that you want. Planning for Optimal LUN Size. May 29, 2022 · Welcome to Excel Avon. Jul 29, 2024 · Method 5 – Convert Data to Excel Table. 2. However, you can get around this even without scripts or advanced formula features but the solution is not exactly elegant Jun 27, 2023 · However the number of characters in the formula is making the file size too large. And yet the new file is 5,674 KB in size. The unit of storage allocation for CKD volumes is one CKD extent. Lot size calculator for good money management 52 replies. There are 3 columns with VLOOKUP formulas referencing the other data tab in the same worksheet. Dec 8, 2016 · Only problem is that excel wont let me just drag the formula down because the merged cells are different sizes. If Formula is very big, just simply make Formula Bar bigger by Ctrl+Shift+U or just simply click on rightmost portion of Formula Bar. When we now paste in 43000 rows of data, Excel 2010 starts moaning and croaking. if you expect more data to be added to the range and want formulas to automatically copy downwards, then convert the Range into a Table. He has written 220+ articles and replied to numerous comments. Jun 2, 2016 · MT4 Position Size Calculator Excel Spreadsheets 28 replies. It is a part or percentage you choose from a population for a survey, experiment, or opinions or behavior you are concerned about. Mar 22, 2016 · Dear all, The question I have is what will impact more on the file size of an Excel workbook out of the following: 1) Using formulas entered directly into cells in a spreadsheet 2) Using VBA to code as appropriate The reason for the question, I have a number of spreadsheets that I have used Apr 26, 2013 · I'm using Excel VBA. And to put the cherry on top, take your calculated LUN size and round it up to the next “handy†number. I need to sum each appearing character (M, L, XL, 2XL for my spreadsheet) for the whole column. Formulas can calculate and display data without the need for large datasets, making them a Jun 16, 2024 · There are several keyboard shortcuts for working with the formula bar: F2 to move the cursor to the formula bar for editing, Ctrl+U to expand or collapse the formula bar, Enter to complete a formula entry and move to the next cell below, and Ctrl+Enter to complete a formula entry and keep the cell selected. This storage object is usually a LUN exported from what ever your storage solution is. Example. I checked and the Excel application was in the proper folder. The formula bar is where you can see and edit the formulas that you have used in your spreadsheet. Mar 21, 2019 · Select a range of cells. Download our Excel workbook, modify data and find new results with formulas. There are something like 50,000 rows and 60 columns, so the number of calculations gets pretty large. thanks for any help. The LUN is made out of disks , usually so level of raid. However, saving a file in binary format (. Oct 13, 2022 · If the problem persists, please launch your Excel app in the Safe Mode and see the outcome. You can't confirm formula entered in data validation field with Ctrl+Shift+Enter, but you don't need to do it. I believe this is the formula: =IF(ISNUMBER(SEARCH("S",D2)),"1","") but the problem is when I do "XS" and "S" it finds the S in both formulas and enters a 1 under the XS and S column (same for "L" and Sep 2, 2021 · If the recommended bin size is 10, then I need to output:-100 -90 -80 -70 -60 -50 -40 -30 -20 -10 0 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 . With the formula cells selected. looking for lot size calculator 29 replies. Dec 14, 2024 · Generally, this involves navigating to the LUN's properties and specifying the desired new size. What’s really common in Excel practices is that people open a new sheet with something like 17 billion cells on it, and try and answer everything in 3 or less: preferring single cell problem solvers to separating problems out. Choosing the initial size of your LUN is crucial for performance and resource Sep 3, 2024 · In fact, to increase the font size in formula bar, you can go to the Excel Option to set the font size, please do as this: 1. The funny thing is that I am able to open any other file and use excel without problems. If you put spaces on both sides of all < and > signs, your formula should post, i. When I added Vlookup formula, file size increased to 15 MB and it cannot be sent in email to others. On my laptop, I get the same effect of limits to the number of formula, but it takes more formula to generate it than you indicate. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. When you hover the mouse pointer over the tool, the ToolTip says "Expand Formula Bar. This should be clear – Excel becomes slower as you have more data. Discover 5 simple methods to determine the right sample size for your research, including using formulas, online calculators, and Excels built-in functions. com) If the same situation happens again, please provide the screenshot of the Excel app Account page. However, by utilizing formulas effectively, it is possible to reduce the size of Excel files without compromising the integrity of the data. Is Ke Istamal se 3 Inch Tak L Sep 17, 2015 · Please enter the same formula, but confirm it with Ctrl+Shift+Enter. Click File > Options to go to the Excel Options dialog box, then click General from the left pane, and then choose the font size you need from the Font size drop down list in the right list box, see screenshot: 2. I just can't seem to get the last function rolled up into the megaformula. 4. In this article, we will discuss how to resize the Excel formula bar to see more of your Excel formulas. Oct 21, 2014 · 1. How to use LARGE & SMALL formulas in Excel. com If the cells are not in a contiguous row or column. A Worksheet with more than about10^6 to 10^8 formulas starts to hang. The specific box sizes are: L W H 254 178 76 Box 1: 254 x 178 x 76 330 229 102 Box 2: 330 x 229 x 102 Nov 1, 2022 · I have a correlation matrix (say matrix A) in Excel with about 4,200 rows and the same number of columns, which is quite large for the everyday Excel user. (Source: Excel Easy) The syntax for the “LARGE” formula is “=LARGE(range, n)” where “range” is the range of values and “n” is the position of the value in the range. Mar 5, 2020 · In this guide, we’re going to show you how to make complex formulas easier to read using line breaks in Excel. Apr 5, 2005 · It's not just formulas that can impact on the size of an Excel file, look at the formatting of the cells as well and make sure that only the cells that need to be formatted are. Jan 17, 2015 · I have worked with Excel sheets of a similar size. My initial size before vlookup is few Kbs in xlsx format. I am trying to do a vlookup of values from another excel with 94,000 rows and 20 columns. I does wonders for the speed and also you won't run into the size limits of Excel. It's basically a large SUM formula. By default, Excel files are saved in the (. How to Disable Spill Feature in Excel. If you do not wish to use the spill formula in Excel, simply hit Delete under the selected cell and your formula will be removed. Why Resize the Formula Bar? Aug 6, 2021 · A number of elements, including checksum type, impact the usable capacity of an array LUN. Then I open, clear the contents of 1 of the columns and by the time I moved the mouse to save the change excel stop responding. Only have formulas till where the data is. These include slow performance, difficulty in navigating the data, and limited functionality of certain Apr 2, 2018 · I want to convert large decimals (up to 2^18) to a formatted binary number. g. So don’t wait any further – and dive right in. cell content, formats, formula vs text, conditional format, charts, other objects etc. I need to extract 3 rows and run them through a formula. I need to sort data that is x - y days old (for example: 0-15 days old). I also have another matrix (B) with the same number of rows and 1 column. Follow these 16 pro tips to speed up Excel and minimize file size for seamless performance. If you would like to increase the text size in Excel Formula bar, you can go to File > Option > General > Under When creating new workbooks > to Increase the Font size. Every other excel sheet had no more than 200kB in size, so the difference was rather massive. On CKD volumes, you can specify an exact cylinder count or a standard volume size to create a LUN. (I don't know what this sort of result is called, but I think they represent very large or very small numbers) I have created a sample document which shows the issue. When you enter a formula into a cell within an Excel table, the table automatically propagates the formula to all other cells in the same column. Example data: A B C D Id Id2 Id3 Val 1 1 8 6 1 2 7 7 1 3 3 8 1 4 6 4 1 4 78 7 1 1 2 9 1 3 1 4 1 4 3 6 1 Jul 18, 2018 · In the cell beneath that, write =2^10*G1 (or equivalent), and drag this formula all the way down to the cell next to YB. Would someone be able to suggest a formula that may be more efficient and still do the same things. 10 mb will be 2 mb after compressing. Herbal Lun Big Size Formula - Videos - Facebook Lun Big Size Medicine Formula. I find the following program pretty awesome in knocking back down to size but have been unable Hello!I didn't know where else to turn to, so here I am. It isn't always about your hardware. Sometimes in a large Excel file, there will be formulas that are no longer in use or not that important. 81899E-12 or -9. Assuming a formula in Sheet1!A1. I am going to try and explain what I have below and hoping someone can help me use a formula to find it. Dec 29, 2021 · Such feedbacks better to publish on feedback portal Excel · Community (microsoft. Jul 27, 2024 · Method 2 – Check Whether Binary Format(. The name LUN comes to the best of my recollection from the SCSI setup where an storage configured as a logical unit which you could address was called a LUN. An example of what I would like to accomplish is (with the Unique column being the adjacent cell): Name Week Unique John 1 1 Sally 1 1 John 1 0 Sally 2 1 Jul 7, 2024 · Posts from: Formula List in Excel. But sometimes, the default size of the formula bar might be too small, making it difficult to see the entire formula. 09495E-13 or similar. T(0. The dataset is from 2000 - 2017, and row nr 1m is 2006, if that helps to visualize (Classified dataset, can't upload or show). Sorry if I caused confusion with the file size…all i know is on my file explorer the file size said 60,225 KB for one file for example and then it had jumped to 2,818,762 KB lmao Nov 3, 2024 · Steps to Calculate Sample Size in Excel . Forums. com), Microsoft monitors it. Also If I am compressing those files it will become small size. tl;dr - the solution: Jul 21, 2013 · Join Date 07-21-2013 Location Cambridge, UK MS-Off Ver Office 2013 Posts 4 Mar 14, 2007 · Hello, Is there a limit to the size a formula can be? I have a rather long formula I'm working on. Simplify Formulas. How can I increase font size of formulas in formula bar? All online suggestions I've found are either a) for Windows systems or b) too technical to understand. Oct 31, 2024 · Dacă formula vă este greu de reținut, puteți încerca Numărul de zile lucrătoare între două date utilitatea Kutools pentru Excel. Leave the Formula display ON. Jun 14, 2024 · Posts from: Excel Reduce File Size. Update: Seems deleting empty rows and columns and removing some unneeded formulas did the trick. (Source: ExcelJet) Dec 19, 2011 · I have some data that I want summed matching certain criteria. Reference: Open Office apps in safe mode on a Windows PC (microsoft. Right-click total to add Max, Min, Count, Average. Nov 14, 2024 · Question: Is there anything I can do to reduce the size of my Excel file and make it faster? It is now so big that it can take a few minutes to update etc. . You now have a table to convert to bytes. Dec 16, 2016 · If, for example, you need the same value multiple times in one formula you can put the formula used to get that value into a separate cell that you hide and reference that cell. What is the difference between sample size and population size? Can I use the same sample size calculation for all types of research? Learn how to calculate sample size in Excel with ease. Mar 5, 2024 · How to Remove Spill Formula in Excel . a2, b2, and c2) are all the same size, but the cells in column c are not. They can then access the increased storage capacity. Apr 15, 2015 · It appears that your formula is being cut-off. See full list on exceldemy. Jun 10, 2020 · When editing the formulas, Excel recognises field references etc (through coloured highlighting) as normal, which I know from experience would stop working if the formula were over 8192 characters. Download Workbook. With the new update, it is automatically available with the Dynamic Array On top of that, when I compared the size of it (234MB in total) to some other excel files that I created, I was shocked at how large it actually is. These days it is much more loosely used. Here's what the string contains (a large list of cells to sum): "=sum(G2057,G2066,G2069,G2072,G2076,G2079 I need to find a way to find data via a function. not cloud). Calculate Salary in Excel; How to Create a Scoring Formula in Excel (System, Text, Grade, Z Score) Excel If Time Between Range (4 Quick Ways) Distance Formula in Excel (4 Examples to Calculate) How to Calculate BMI with Formula in Excel: 3 Methods; Leave Calculation Formula in Excel (5 Leave Types) I played around with it a little and discovered that most Excel functions will return a value when using this kind of reference: =SUM(A1:A5:C1:C5:E1:E2:F3:F4) Notice all the ":"s in there. xlsb) can automatically reduce its size. This will expand the formula bar to enough lines to display whatever it contains. Whether it is optimizing formulas, reducing data size, or using advanced Excel tools these methods will help you to smoothly run your spreadsheets. Column A is the VNX LUN number (ALU), B is the LUN name, C is the VNX storage pool we want the LUN to belong to, D is the LUN size, and E is the SP we want the LUN to be owned by. It is not a good practice to copy formulas to "unrequired blank rows" below. How do various factors affect Excel file size? What are all these factors e. I don't even use too much of them (only 900 SUMIF formulas), but somehow they really slow the file. In the example shown, the formula in F7 is: Posted by u/Former-Lobster-5102 - 1 vote and 10 comments “LARGE” is an Excel formula that returns the nth largest value from a range of values. May 31, 2023 · Sample Size Formula; Examples of Sample Size Formula; Sample Size Formula in Excel (With Excel Template) Sample Size Formula. He also led some teams on Excel and VBA content development. ; and how much each of these add to the file size? Oct 1, 2015 · I'm working in an Excel file which is currently 21MB. I run Disk utility and repaired the disk permissions. 7MB. See this article. My Mar 15, 2023 · It works well, but it's slow. Some people quite happily format the whole of a column or a row (or worse, both) with say a font or a colour when all they really need to do is the first three columns. 2. Oct 29, 2024 · Complex calculations with large datasets. In this formula you can learn LARGE formula in Excel, A large function in excel is an inbuilt statistical function that returns the nth position or Kth position from the selected numerical array. He is experienced in Microsoft Office, especially in Excel. Step 1: Define Parameters ; Step 2: Use the Sample Size Formula ; Step 3: Excel Implementation ; Step 4: Adjusting for Finite Population Correction ; Key Takeaways . Adding line breaks. " (In Excel 2013 and later versions, it'll be the small arrow icon that expands the formula bar. 3 days ago · You can't exceed the limit of 256 character in data validation. However, when I experimented, I A number of elements, including checksum type, impact the usable capacity of an array LUN. Now it's an array formula, with different result (10). There are 3 columns with simple formulas adding/multiplying/dividing columns on the same tab. Aug 30, 2024 · The SMALL and LARGE functions of Excel will help you do that without reshaping your data. Excel simple risk calculator needed 10 replies Jan 10, 2007 · The formula I am using looks like this: =IF('DAILY SORTED'!A3="BLH",'DAILY SORTED'!B3,"") This formula is repeated in each cell on each customer sheet from column A-X and row 3-1500 with the only change in the formula being the cell addresses and customer name. I have a shirt order form and I need to count up the number of the different shirt sizes on my sheet. Lun Big Size Formula Jis Ke Istamal Se Aik Mah Mein Nafs 3 Inch Tak Lamba Or Mota Ho Jai Ga. 05, 4, 25) which would return a result of 8. Complex calculations can also slow down performance, especially involving many cells or formulas. xlsx) format. Especially if you are using the data on a regular basis, I would heartily recommend switching to a proper database SQL based, Access, or whatever fits your purpose. I've tried using LAMBDA in a named function, just on the chance that would be more internally efficient. All tabs are in the same file. Harry Key specs. In our example, we have table of pants size chart and we are using nested-IF functions get the size code by waist measurement. Move to another sheet and enter the formula =RIGHT(Sheet1!A1,LEN(Sheet1!A1)-1) Optimise the formulas. The cells in the adjacent columns (i. The formulas in question make extensive use of references to loaded Power Query tables. Jul 5, 2024 · He has been working on the ExcelDemy project for more than 2 years. Oct 14, 2015 · Each month I create a report with over 100 summary tabs that are referencing 22 data tabs. Dec 4, 2018 · So the formula I'm looking for is to have the "XS, S, M, L, XL" columns automatically input a "1" based on what is listed in the "size" column. Position size calculator in Excel 2 replies. It's over 2000 units of data and would like to not do this manually. 0 in 1993 when VBA was introduced (was a power user of Lotus 1-2-3 before then). I guess that a large sheet filled with the same long formula might be a culprit too? Mastering Excel for Large Datasets: Essential Tips Understanding the Challenges of Large Datasets in Excel Common Issues Faced When Handling Big Data. The table has 15 columns and at least 2 rows, with the 1st row being for the headers. Convert the formulas into static values to reduce the number of calculations and improve performance. Jan 29, 2011 · My file originally was only 4. Jul 6, 2024 · Part 10 – How to Calculate Percentages in Excel. ----- So. The same Worksheet works fine on my desktop. It will just increasing the file size & adversely effect the workbook's performance. Jan 21, 2016 · I've developed an Excel solution for one of my clients that revolves around a large table (up to column DI). 1. After you restart Excel app, the formula bar will be increase. It contains about 25 function calls (e. Summary. However, after adding the formula (IF & Vlookup) and conditional formatting to the fourth sheet (number of columns is from A to BZ) then the file size increased from 4. I think this is what is causing the file to blossom to 62 MG. I am also not very skilled with Excel, only very basic equations, so It may not even be possible. when I change a formula. How would I apply the formula to the entire column at once? Please see an example of the desired end state attached. This particular request exists for years. Microsoft makes dialog boxes resizable one by one, but formula evaluate is still postponed. Why is the file size increasing so much for Vlookup To return the largest values in a set of data that meet specific criteria you can use a formula based on the LARGE function with the FILTER function. You may add your vote here Use of Formulas to Reduce File Size. My excel file also became very slow and i need to take off the Automatically Calculation option. There is no data on the 2nd tab, only the formulas described. LARGE Formula in Excel - Learn how to retrieve the nth largest value in Excel based on a list in just a few steps! I will show you in this free tutorial What you describe as pivots sounds like relatively straightforward queries producing sums and counts (aggregation queries), and VLOOKUP and pasting sounds like table joins. Take this formula for example: On its own this formula isn't too bad, but if you take a close look at the formula in my question you'd see I do a very similar thing. I have a large dataset (I guess around 2,5-3m rows in excel and around 70 columns, 1,1GB) that I need to work with. The percentage of a part can be calculated by dividing it by the total value and then multiplying the result by 100 or formatting the result with the Percent Style command. Formulas are one of the biggest Excel slowdowns, especially highly complex ones with nested functions or thousands of cell references. Jun 17, 2024 · Method 12 – Convert Unwanted Formulas to Values. Dec 20, 2018 · However, if I use a SUMIF formula, instead of 0, i get: 1. 8 to 11. from which I then can check the frequency of my population of data. Kutools pentru Excel oferă peste 300 de funcții avansate pentru a eficientiza sarcinile complexe, stimulând creativitatea și eficiența. eg 128 mb can be compressed to 10 mb. , OFFSET, MATCH, INDEX, etc). 6MB to 13. Simplifying formulas where possible goes a long way. Copy the following Data column to a blank worksheet to column A. For example, if the ratio between value and input is nearly constant, it's likely O(n). 321746 May 9, 2012 · If you manually adjust the height of the formula bar, it will be remembered the next time you click the chevron. I have excel for Mac version 16. 52. How to Reduce the Excel File Size by Deleting Blank Rows – 4 Methods; How to Compress Excel File More than 100MB (7 Useful Ways) How to Reduce Excel File Size Without Deleting Data (9 Tricks) How to Zip an Excel File (3 Easy Ways) How to Reduce Excel File Size with Pictures (2 Easy Ways) May 22, 2009 · Excel 2007 Is there a formula or function that will display the file size in a selected cell? Thanks. The sample size is the most important term used in statistics. It may depend on the type of formula, that is, 10^8 VLOOKUPS will hang but 10^8 SUM statements are ok. Do a Find and Replace replacing all = signs with X= (this could be a problem if your formulas contain = signs inside as well as at the beginning. I am guessing that you are using < or > signs, which are being mistaken for HTML code. Spreadsheet optimization is a simple task, large workbooks don’t have to be complicated. Here's an example formula: Sep 8, 2016 · I have a file with 10 columns and 220 rows. ) Another option is to simply turn off May 4, 2024 · 7 examples to copy and paste in Excel and keep cell size. fpakfo qia sabmz fiq dabnu gqykjj lhdqcvd zdm ejuic gfzawsvhy