Use this forum to ask questions about excel formula, answer them or to post your own finds
Topic by Fuzz666
I've been a lurker for a while now and I am currently writing my first Instructable. I'd like to be able to include an Excel spreadsheet which I developed to help design the item I am writing about. I have uploaded the file but it seems that the site treats it like a picture. Is there a way to include a link to a file you have uploaded so that the reader can download it and use it? I could always upload it to a file sharing site or Google Docs and link to it there but I feel there must be a way to do it withing the Instructables site. You'd have a similar need for things like CAD drawings or code files.
Topic by TheOnlyShasta9 | last reply
Hey guys, i have a couple of excel .XLSX files that i have been trying to open but i haven't had any luck with then excel says "excel cannot open filename.xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file" i have download the compatibility pack for office 2007 and tried to repair and extract the data from the file using the excel programs but i get a message that says the file is corrupt and cannot extract or repair the file. i have tried this on all the files and selected every option i can in the repair menu, but i haven't had any luck with it. is there a way to repair the file or am i going to loose the data stored in these files Any and all help will be greatly appreciated
Question by allisoncharles563 | last reply
Hey guys, hoping for some insight on an issue I am facing: We have one user that is running Excel 2010. When she opens a spreadsheet, works on it, then saves it, it opens with errors the next time anyone tries to use it. It gives an "Unreadable content error message" and asks if you want to repair the file. It seems to only happen if she saves it as .xlsx, saving it as .xls doesn't seem to cause the same problem. Exact Error: "Excel found unreadable content in filename.xls. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes." She is running Office 2010 Home & Business on Windows 7 Pro x64 I have tried repairing Office 2010, uninstalling and reinstalling Office 2010, making sure it has the latest updates and service packs. Any insight into this issue would be greatly appreciated! Thanks
Question by VioletGriffith | last reply
I have embedded a PDF into an Excel file. If I e-mail this Excel spreadsheet to someone else, can they access the PDF file that I have embedded?
Question by Brennn10 | last reply
Problem: The only issue is with Excel *.xlsx documents. A friend somehow managed to associate the .xlsx files with Word, so of course it obviously fails to open with Word. All other Excel files... templates, older *.xls files and such open fine by double-clicking on them. Attempted fixes: 1)I have gone into and set *.xlsx documents to be associated with the Excel program, however the icon doesn't change to the normal Excel 2011 icon (the icon looks like a blank sheet w/ the normal Excel icon in the middle instead of off to the left side) 2)I have run the Office Repair to no avail 3)I have completely uninstalled, then reinstalled the entire Office suite too. 4)Finally, System Restore didn't work What happens when I try to open an .xlsx doc? The hourglass comes up like it's thinking about it for maybe 2 seconds, then just goes away and nothing happens. I wish I could say what happened or what changed to cause the problem, but my friend has no idea. By the way, I can open Excel, go to file-->open--> and open an .xlsx document that way. Or just drag the file into the opened Excel program and it works fine. After everything I've tried, I imagine there is just something registered incorrectly in the registry, but am unable to find out what exactly. Thank you in advance for your time...
Question by popeeric6 | last reply
Question by mkstalin | last reply
I can not upload excel files to my instructible. I have tried 20 or more times, closed the browser and repeated, tried another browser, renamed the files but nothing seems to work. I have had this problem before and sometimes after about 2 hours of frustration, the files suddenly upload correctly. This is extremely annoying. Can anything be done to fix this fault ?
Topic by kymyst | last reply
Hello, I have Win 7 and Excel 2007. When I try to open my .xls files I always get the same error message: The file may be corrupted, located on a server that is not responding, or read only. I`m sure that all my files are on the C disk and they are not read only…just week ago I was able to open it. My friend adviced me to make a scan disk and check my computer for viruses, but it didn`t help in the issue. Can you give me some tips how could I solve this problem?
Topic by AddyMaddy | last reply
https://www.instructables.com/id/Make-your-own-GUIgraphical-user-interface-in-Micro/ This is my instructable's link. I cannot login to my instructable, to replay to the commends, My friends also tried to login ,they also not able to follow me , or make it as their favorite or not even vote for me in a contest. . Kindly resolve it fast , other wise I will get failed in the contest and I'm not able to give replays to the earlier messages!...
Question by NIKHILP3 | last reply
Hi, i'm getting the ticker feed from (https://btc-e.com/api/2/btc_usd/ticker) and feeding it into an excel 2010 spreadsheet. what i want to do is append the new data (on update, 1 min interval) to a new line(row) on each update.
Question by furby | last reply
Hi all, how would i go about stripping the city from a list (over 3000) of Team names. ie Arizona Cardinals -> Cardinals i have a spreadsheet listing all games from Sunshine Forecast for the 1978 - 2011 seasons and have a lookup so i can see the matchups between any team and i will show me the Score, winner, loser & Home/Road. but the teams have moved/ changed names in that time.
Question by furby | last reply
I just made an excel spreadsheet, that predicts the future of data sets. My main reason was because I wanted to have a way to predict my Instructable views, but this could be used for a lot more. This is not completely accurate (as it uses the best fitting line of the data) so don't believe it completely. To use it, just change the first two numbers (at least) to values you want to see grow. Any value you don't know. Mark with n
Topic by Super_Nerd | last reply
It does not appear possible to upload excel files (with or without Macros). Can any user point me to some sort of "official" documentation on this point either way? (Have tried multiple browsers at multiple times of day) I've made a timing system for sports races using RFID and Excel, and the Instructable is pretty pointless without the Excel file.
Topic by edmondslibrarian | last reply
I was wondering if there would be a way to make a "query machine" that would be portable. It would need a display and digit pad and allow me to load an excel sheet to the device and then search it using the key pad. I didn't know if this would be feasible or not so some input would be valuable. I need something like an RF Scanner that would be used in a ware house except without the scanner part. Just manually type in a number and a location appears on the screen.
Topic by J.Reynolds09 | last reply
Basically i use to collate the data with the help of this batfile command as below copy *txt link.xls i need a help to copy the numbers of txt file to collate in a single excel file with the below specifictions. I have number of text file that text files has its repective name,what i want to do is to collate the set of text files to a single excel file with the column to be added in the excel file with the respective text file names.
Question by mayking4k | last reply
I just recently joined as a Pro member, but I've received a lot out of Instructables over the years. The last "prank" instructable that I participated in were those cell phone zappers. I don't know what kind of experience or success rate other members had with this, but I just wanted to die laughing at times when in stores, doctors offices, etc..., and someone would either call or receive a call, and 'ye olde zapper' went into action, and I'd estimate a good 90+% of the time, the call was terminated very shortly because of a dropped [or loss of] signal. My unit was rigged up in a book, so it was really drew no attention.
Topic by eagleshadow | last reply
It's no secret that we love using LEDs for our projects. They sip power and are fantastically tiny. You can even get an introduction to how they work with just an LED and a coin battery. If you haven't used one yet, make it a new year's resolution to make one light up this year. If you want to complete any resolutions, that'll be one of the easiest.Yesterday's announcement of the Macbook Air in San Francisco pushes the LEDs further. This isn't the first laptop to have it, but it's a dramatic display of how far the tech has come and how far it needs to go. LEDs aren't perfect for every use, but they hopefully will be someday.According to this article some of the current goals are for better whites, deep-UV, and quantum cryptography. All of which sound pretty tasty.But what about you? What do you want from LEDs that you don't see just yet?
Topic by fungus amungus | last reply
I need help to program in VB in excel i want to make a program that when i put a memory stick (like one in a camera) it automatically recognizes it sorts between photo and video puts the videos and pictures into separate folders onto a WDMybooklive (personal cloud 2 terabyte) and then deletes the files on the memory card all automatically and with visual basic in excel. Thank You!
Question by Xixfas | last reply
Hi all (again) new problem semi related to previous. (check my profile for the ones with NFL in the title) now the problem is i want to get the average score for each team in each season. my current formula only gets the first result of the index/match even if i use some of the tricks i've googled. the data is in the format of YearVisitingTeam(W/L/D)Score@HomeTeam(W/L/D)Score ie 201249ersW41@2012PatriotsL34 i use a formula to strip "Year(Visiting/Home)Team(W/L/D)" so i' left with Score on either side of the "@" (that was a [redacted] pain) using any and all of the tricks i know i get either 0, 27 or an error of some sort. the only way i've been sorta able to do this is by getting the first home win, first home loss, first away win, first away loss BUT that's only 4 of 16 games each season and not a good representation of the average points for the team in a season. the sheet in question is AVG point - Reg Season the source data is 78 - current regular season (2012 season starts @ row 3152)
Question by furby | last reply
I have an excel sheet, and I am trying to bring some sort of automation in to that sheet (since I use it quite often) with the help of macros. The fact is that I am really new to macros and VBA programming language, so I need a little help in writing the code to find the 10th percentile (the formula for it is PERCENTILE(array, 0.1) for each bin value (50, 100, 150). If you see the picture attached, the wanted percentile values are in Q, the bins for which I want to find the 10th percentile value, are given in Column M (50,100,150) and the main data on which the 10 percentile value will be based is given in Column D. By Using the data given in D and filtering out a certain bin width in column E (Example: Filtering bin width 50 or 100), we could find the Percentile value against each of the bin value given in Column N. As said earlier I am new to VBA code, so any help will be appreciated in order to find the percentile values for each bin. the link to the original spread sheet is given below: http://bit.ly/XCgqtK
Question by raishikoh | last reply
Hi Is it possible to send single character data from MS Excel2000, to the Arduino monitor, which will ,via the usb send on to the Arduino device. (say turning leds on and off.) Low volume of data, 10 characters minute. That is within VBA of the Excel to send the data from Excel to appear in Arduino monitor and thru USB to Arduino Nano where it will be dealt with by other arduino sketch. I will need to know what vba to use in Excel and what code required in sketch to accept vba. Thanks CharlesHarris
Question by charlie.harris.376 | last reply
Hi all, i've got a problem with a formula in my excel spreadsheet that i'm using to get the scores for NFL teams 1978 - Current i have the data ok but the problem is with matching the the specific games. i've CONCATENATED the data to provide unique data points also it's in two columns (Home & Visitor) in the format of YearTeamW/L/DScore eg. 2012TitansW35 in the VERY unlikely event (and i've check a random selection) that the team has 2 wins at home with the same score this could cause an error. here is the formula i'm using: (version ~8000zzzzz lol) (all one formula, just added a line break to make it fit) =(IF(MATCH($A$3&$B$2&"w*",Home_Team,0)=MATCH($A$3&$C$2&"l*",Visitor,0),INDEX(Visitor,MATCH($A$3&$C$2&"l*",Visitor,0)) ,IF(MATCH($A$3&$B$2&"d*",Home_Team,0)=MATCH($A$3&$C$2&"d*",Visitor,0),INDEX(Visitor,MATCH($A$3&$C$2&"d*",Visitor,0))))) Here's a link to the folder with the spreadsheet. (NFL Stuf (test).xlsx) Sheet: Past Season Summary - what is says. eventually where the formula is going. Sheet: nfl2011lines - 92 - the data (actually 1978 - 2012 but i named it before i added all the data) Sheet: TESTING - my "sandbox" so i don't [Censored] the main sheets Semi-Related Question1 Semi-Related Question2
Question by furby | last reply
Hello everyone I need to apply a loop to the following code such that the constant (50) in ActiveCell.FormulaR1C1 = "=IF(C[-7]=50,C[-8],"""")" is replaced by a variable that has the values depending on column M as shown in the picture. Furthermore I also want my code to progress downwards and fill all the empty places, depending on the adjacent row value in column n. Do I need to switch over to absolute reference? The code is as under: Sub Percentile() ' ' Percentile Macro ' ' ActiveCell.FormulaR1C1 = "Rough Work" Range("L2").Select ActiveCell.FormulaR1C1 = "=IF(C[-7]=50,C[-8],"""")" Range("L2").Select Selection.AutoFill Destination:=Range("L2:L124252") Range("L2:L124252").Select Columns("L:L").Select Selection.Copy Columns("AG:AG").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Columns("Q:Q").Select Application.CutCopyMode = False Selection.ClearContents Range("Q1").Select ActiveCell.FormulaR1C1 = "Percentile 10%" Range("Q2").Select ActiveCell.FormulaR1C1 = "=PERCENTILE(C,0.1)" Columns("R:U").Select Selection.ClearContents Range("R1").Select ActiveCell.FormulaR1C1 = "Percentile 25%" Range("S1").Select ActiveCell.FormulaR1C1 = "Percentile 50%" Range("T1").Select ActiveCell.FormulaR1C1 = "Percentile 75%" Range("U1").Select ActiveCell.FormulaR1C1 = "Percentile 90%" Range("Q2").Select ActiveCell.FormulaR1C1 = "=PERCENTILE(C,0.1)" Range("R2").Select ActiveCell.FormulaR1C1 = "=PERCENTILE(C,0.25)" Range("S2").Select ActiveCell.FormulaR1C1 = "=PERCENTILE(C,0.5)" Range("T2").Select ActiveCell.FormulaR1C1 = "=PERCENTILE(C,0.75)" Range("U2").Select ActiveCell.FormulaR1C1 = "=PERCENTILE(C,0.9)" Range("U3").Select End Sub You could find the Main Excel sheet here: http://tinyurl.com/aqheuyp
Question by raishikoh
I need to incorporate a sheet name command in a cell, then after that refer to that sheetname command in a macro.
Question by LucasOchoa | last reply
So i am writing a macro to graph a large set of data. After finishing writing the macro it worked fine on its original fie in this case 234 here is one of the original sets of key data. ActiveChart.SeriesCollection(1).XValues = "='234'!$A$27:$A$1490" It specifies the 234 as the file to retrieve the data. I assumed that after replacing the 234 in the line of code above with a command like sheetname. like so below. ActiveChart.SeriesCollection(1).XValues = "='sheetname'!$A$27:$A$1490" Who ever can successfully answer will receive a patch. Feel free to ask questions because what i wrote above is a slight bit vauge.
Question by LucasOchoa | last reply
I cannot open corrupt excel file because of virus attack or malware affection, I have corrupted workbook. How to get back corrupted MS Excel file. Any help.
Question by nicopatras | last reply
I am currently working on a program for guitar tabs. i can use excel to some degree. i am somewhat experianced in dos and visual basic.i need a way to get it to right a chord on a vertical line. then go back to the top of the next line. i need to be able to do that 32 times. so it would look something like this: |--3 that being the first 3 lines -3--|| |--2 then the program goes to -2--|| |--2 the top and types another chord -2--|| |--0 -0--|| |--1 -1--|| |--0 -0--||
Question by MrMystery96 | last reply
Trying to find a simple inventory system to keep track of my integrated circuits. Prefer Excel part number versus function, Thanks
Topic by naic98 | last reply
I'm trying to do an Instructable with Excel, but whenever I upload screenshots into Flickr or just directly to the instructable, the full preview makes them all fuzzy and small. How do I enlarge the picture so people can actually see them? I've tried Photoshop to enlarge them, but it didn't help, and I am not a Pro Member, is that why? Thanks!
Topic by tinstructable | last reply
Hello everyone I hope that you all are fine. I have an excel sheet, and I am trying to bring some sort of automation in to that sheet (since I use it quite often) with the help of macros. The fact is that I am really new to macros and VBA programming language, so I need a little help in writing the code to find the 10th percentile for each bin value (50, 100, 150). If you see the picture attached, the wanted percentile values are in Q, the bins for which I want to find the 10th percentile value, are given in Column M and the main data on which the 10 percentile value will be based is given in Column D. By Using the data given in D and filtering out a certain bin width in column E (Example: Filtering bin width 50 or 100), we could find the Percentile value against each of the bin value given in Column N. As said earlier I am new to VBA code, so any help will be appreciated in order to find the percentile values for each bin. I can give the excel sheet as well if someone want to try hand on it, and let's me know the email address. Additional Note: (The spread sheet is sorted out with respect to column E, is Ascending order (50, 100, 150) and the number of count for each bin width is given in column O, so you can just find the range of each bin by adding the count for each bin i.e range for first bin (50) is from 1 to 1+8542, similarly the range for the second bin (100) is given by 1+8542 to 1+8542+6862. I will be very grateful if someone spares some time for me. Kind Regards raishikoh
Question by raishikoh | last reply
Don't know why this hasn't been done really or why this is hyper linking. Anyway, Please check out photos & link for inspiration to get an idea of what i'm talking about. It's time to start making killer Retro cameras! Either make a new body or re-purpose a vintage camera http://blueantstudio.blogspot.com/2011/11/digital-lomography.html
Topic by Braxtone | last reply
Hi Ive been given a singer excelle sewing machine, but I dont know what the dials are used for, could anyone help me please, havent been able to find any help online anywhere, would appreciate any help. Thank you
Question | last reply
Vehicles have been designed to minimize the aerodynamic drag with notable success. Production candidate vehicles (such as Aptera, Twike, and Honda Insight) achieving drag coefficients of 0.25 down to 0.11. Solar Challenge vehicles have reached 0.07. Nose cone and fastback upper and sealed or faired lower body designs can achieve significant reductions in drag, and are worth attention. I am attempting to optimize a design for pickup trucks and cross-over utility (CUV) vehicles that are based on the same basic chassis design. Can anyone contribute designs, examples, or sources of information on optimized pickup design? BTW, I am simultaneously searching for a safe design that has the vehicle center of gravity at or below the axle height, as it should be to prevent roll-over accidents. Risk of injury and death are significantly higher in pickup trucks and CUVs than cars, and now pickups and CUVs account for more than 50% of new vehicle sales. This tragic fact needs to be reversed with safer design.
Question by rkh986 | last reply
Hello! I'm going to try and make a clay sculpture of my business logo. I'm unsure what to use, Polymer clay or Paper clay? I'm not really sure what is the difference because I'm used to thinking they both make excellent pieces and their baking time depends on their manufacturer. What do you suggest? I use for this project and future projects? Terresa Waz, Newbie clay sculptor http://www.chicagocomputerclasses.com/excel-classes/
Topic by terresawaz | last reply