tag:blogger.com,1999:blog-8604042776942832369.post4426446020106766390..comments2024-02-03T17:13:28.557-08:00Comments on Going's on of Otto's Pastimes: MS Excel Checking Bit Positions in Bytes and other stuff...Otto Beldenhttp://www.blogger.com/profile/01216660670383308620noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8604042776942832369.post-58497197249231945862012-06-17T18:02:21.753-07:002012-06-17T18:02:21.753-07:00Kay,
Thanks for checking out my blog! I can't...Kay,<br /><br />Thanks for checking out my blog! I can't send you the Excel sheet that I did this on :-( I have a lot of data on there and I wouldn't feel comfortable sending it. My suggestion is that you create a new spreadsheet and copy the cove that I have (above) into your sheet. There are a lot of explanations about how to do that on the web.<br />If you have trouble doing it let me know and I can help.<br />The Spreadsheet has to have Macro's enabled" and I think one other item checked for the VBA stuff to work.<br />I too am a novice with Excel and had to figure this stuff out as I went along.<br />One easy way i found to get started is to create a new spreadsheet then "record macro" and click on some cells, add some number etc... then "stop recording". AT that point you can go and edit your macro (erase the parts you just did) and use it as an example to start with and build from there.<br />Let me know if you have any problems and I'll do my best to help!<br /><br />OttoOtto Beldenhttps://www.blogger.com/profile/01216660670383308620noreply@blogger.comtag:blogger.com,1999:blog-8604042776942832369.post-38946172595889363142012-06-16T07:00:31.252-07:002012-06-16T07:00:31.252-07:00Hi.
I have been trying to make exactly this, but ...Hi.<br /><br />I have been trying to make exactly this, but my skill in excel just isn't good enough :P<br />Never even tried VBA, and was hoping to do this as simple as possible, with plain excel. <br />The reason I would like to have this, is to have several different things in one excel workbook. mA to raw-value i now have, and my next step was this...<br />Is it possible to get this excel workbook from you? I will probably understand it more easily anyway then since VBA is not something I've used, and I'm a novice with excel to begin with :PKay Oddvar Ramsdalnoreply@blogger.comtag:blogger.com,1999:blog-8604042776942832369.post-34461791177744602602011-09-16T14:32:01.258-07:002011-09-16T14:32:01.258-07:00Kein,
That is an interesting problem, I'd be ...Kein,<br /><br />That is an interesting problem, I'd be happy to help if I can. May I ask what this is for? Is the binary data:<br />0000,0000,0000,0011<br />all in one column - separated by commas as you have written or are there no commas?<br />I believe that the formula for the resistances in parallel would be:<br />1/Rt = 1/R0+1/R1+1/R2+1/R3...<br />Let me think about this a bit and if I come up with something I'll post it on my blog. You can always email me too ;-)<br /><br />- OttoOtto Beldenhttps://www.blogger.com/profile/01216660670383308620noreply@blogger.comtag:blogger.com,1999:blog-8604042776942832369.post-2210108978159251772011-09-15T23:30:50.524-07:002011-09-15T23:30:50.524-07:00Hello,
I am a newbie to Excel VBA. Can anyone help...Hello,<br />I am a newbie to Excel VBA. Can anyone help me developed a module or function that will check the number of bits of a binary number and then calculate the resistance of a binary resistors in parallel combination. One column of excel sheet contains binary data to be checked i.e.<br />0000,0000,0000,0001<br />0000,0000,0000,0010<br />0000,0000,0000,0011<br />0000,0000,0000,0100<br />;<br />;<br />0000,0011,1111,1111<br />0000,0100,0000,0000<br /><br />for example.<br />if binary number is 0000,1111<br />then the resultant of R0, R1, R2, R3 should be calculated i.e. Rs=1/R0+1/R1+1/R2+1/R3<br /><br />The values of binary resistors in parallel are:<br />R0 R1 R2 R3 R4 R5 R6 R7 R8 R9 R10<br />1 2 4 8 16 32 64 128 256 512 1024<br /><br />Appreciating your input in advance.<br />Regards,<br />KeinAnonymousnoreply@blogger.com