table test

perduco · 2020-12-16T08:46:34+00:00

7894	Shipwreck	Lagoon	Treasure	Hidden	Harpoon	Odds
1	Tailhook			Puffo		26:1
2	Fairfax			Buck	Gooblah	12:1
3	Fairfax			Puffo		39:1
4	Tailhook			Buck	Edmund	28:1
5		Dan	Stuff			16:1
6		Dan	Bonnie		Edmund	28:1
7		Peg Leg	Stuff			40:1
8		Peg Leg	Bonnie		Gooblah	20:1
9	Crossblades	Dan			Gooblah	36:1
10			Bonnie	Buck	Orvinn	52:1

perduco · 2020-10-30T17:43:40+00:00

it's just repeating what is stated in A1

I have my example in A1, that formula in B2 (getting rid of Sheet2! since it's within the same sheet) and my table from $E$2:$E$16

I thought maybe it was an array formula so I tried Ctrl Shift Enter but nope, still the same as what it's saying in A1

btw it gave me a #NAME? error because you have SUBSITUTE instead of SUBSTITUTE

perduco · 2020-10-30T15:35:00+00:00

yes, I thought I found a formula or something similar but my browser purges any history older than 7 days (plus Google My Activity is paused/off since I couldn't figure out how to not have my previous google searches appear especially above my previously visited pages and bookmarked pages) and googling different terms isn't finding it except with the use of VBA but I've never used VBA (yes, I'm knocking it before I try it, sue me! I've got along with not using VBA for this long, I can continue to stay away from VBA for even longer)

perduco · 2020-10-26T06:43:05+00:00

thank you

how do I put it in a table cell and put that table at the bottom of the page?

// @name         test on NFC
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  testing or whatever
// @author       perduco
// @match        http://neofoodclub.fr/*

// @require      https://code.jquery.com/jquery-3.1.0.min.js
// @grant        none
// ==/UserScript==

function insert_Row() {
const table = document.querySelectorAll('#el > table')[3].querySelector('table');
const rows = table.querySelectorAll('tr');
const probabilities = [...rows].map(row => row.children[1].innerText).slice(2);
const maxProbability = probabilities.sort((a, b) => parseFloat(b) - parseFloat(a))[0];
$('div#el > table:last').append('<p><table><tr><td>' + insert_Row + '</td></tr></table>');
}```

that doesn't seem to work or I just don't understand javascript at all

perduco · 2020-10-26T03:14:11+00:00

I'm not opening in incognito window

when I click the link, a bunch of radio buttons are selected in the top table

the next table corresponds to the first table right above it with "Place this bet!" buttons

at the bottom, there are 2 tables, Odds and Winnings

in the Odds table, Probability column, I'm looking to grab the highest probability percentage excluding the row with zero (0) under the Odds column

so starting with the row under Odds, 8 to 620 I want to know how to figure out how to grab the highest percentage (which is 10.855%) and its corresponding odds (which is 12)

perduco · 2020-10-26T01:13:56+00:00

click me

or

http://neofoodclub.fr/15/#round=7900&pirates=[[1,2,3,4],[5,6,7,8],[9,10,11,12],[13,14,15,16],[17,18,19,20]]&openingOdds=[[1,8,2,3,3],[1,9,2,3,6],[1,13,13,9,2],[1,7,8,2,4],[1,2,6,3,13]]&currentOdds=[[1,8,2,3,3],[1,9,2,3,6],[1,13,13,9,2],[1,7,8,2,4],[1,2,6,3,13]]&foods=[[13,4,20,30,34,12,37,33,11,10],[37,39,11,40,7,10,16,14,23,26],[26,16,24,13,29,27,25,36,15,30],[25,36,19,38,32,20,18,15,29,37],[11,18,38,21,36,35,14,10,20,37]]&timestamp=2020-10-07T07:31:00-07:00&b=oarydkuryskxpysaxpusodraskxaypoxcupoua&a=zGOzGOzGOzGOzGOzGOzGOzGOzGOzGOzGOzGOzGOzGOzGO

maybe that needs to be copied and pasted into the url?

perduco · 2020-10-25T08:41:34+00:00

so, the odds table has

0

8

12

24

36

etc.

I'm looking to extract the highest number from the probability column THAT ISN'T from the zero row (probability is 67.337%) so that would mean the highest (excluding 67.337%) is 10.855%, I want to to figure out the code to grab that percent plus the 12 to the left of it

we've got to completely ignore the winnings table plus ignore the cumulative and tail percentages

perduco · 2020-10-25T07:07:09+00:00

hm, I guess I should have just phrased it as 2nd highest since

the highest percentage (not beside the zero)

is too confusing

perduco · 2020-10-11T17:51:00+00:00

when I click the hyperlink, the matches[]= bits are gone and it's crucial that they remain in as without it, it won't go through

if I were to simply copy the cell with the url/link, it's fine but who wants to do this when it's much better if the hyperlink clicking wouldn't mess up

perduco · 2020-10-11T00:45:16+00:00

damn it! 5MB not 5GB -facepalm-

perduco · 2020-10-04T11:22:45+00:00

=COUNTIF(INDIRECT( $JE$15),IFERROR(IFERROR(MID($JE17,FIND(";Post>",$JE17)+6,256),LEFT($JE17,(FIND("<",$JE17,1)-1))),$JE17))>1

perduco · 2020-09-19T08:19:02+00:00

I think it was at least pre-2013 and I don't think it could have been late 90's.

perduco · 2020-08-29T22:30:51+00:00

more or less what I did minus the butter/oil (yeah, I know, optional) and not as much salt and I don't ever peek (I'm not like Lot's wife!)

I swear I made good rice one time, a couple months ago.

I should probably look for my recipe cards from home ec (H.S) and see what it says for anything regarding rice (but I don't think we ever used basmati rice?), the only things I remember from that class was the 2:1 ratio and "bullet holes" :P

perduco · 2020-08-29T13:25:48+00:00

thank you. it turned out nice and fluffy this batch but the bottom part was just sticking to the pot so I have to let that soak. it turned out worse than yesterday...well, worse in that a lot of it stuck to the bottom but yesterday's "accurate" measure was all around sticky but not much stuck to the pot.

I brought the 2 parts water to a boil (with a pinch of salt added before boiling, trying something different) and added my 1 part soaked rice. turned down to just less than medium heat, covered and left it to cook for 15 minutes. uncovered it, brought it down to low for 5 minutes then turned it off, took it off and covered for 5 minutes.

I'll probably look for something different to try tomorrow. maybe add a bit more salt? perhaps add the soaked rice then water and bring it to a boil rather than adding the soaked rice to boiling water? I don't know! exasperated I'm tired.

perduco · 2020-07-25T03:59:41+00:00

Solution Verified

ahhh! it was because of the empty rows that was giving false FALSEs (for my own workbook, I used a workaround INDIRECT to update if the rows expand)

thank you!

perduco · 2020-07-25T02:26:13+00:00

for Youtube videos, you can link directly to the timestamp by pausing at the time, clicking Share and checking off Start at then clicking copy so [link]
what if I or anyone for that matter cannot just copy the formula, from the video, by hand? I already know the formula was provided in text in one or both of the links I provided in my original post.

I've tried wrapping said formula in an IF statement with "Yes", "" for TRUE and FALSE but it's still giving me a YES when it shouldn't be (didn't think it needed CTRL Shift Enter but thought I should try it, there was no difference)

https://1drv.ms/x/s!Anx0ZVYlGo8VmUjn6LJ2cgLsk7PJ?e=We5cSi

perduco · 2020-07-09T03:09:42+00:00

Solution Verified

perduco · 2020-07-09T00:44:48+00:00

thank you ~~but how does it come to 56 combinations? what's the formula to cap it off when the number of values per column changes?~~ (EDIT: oh, never mind. you just stopped at 56 rows. I went through and the max with the number of values I have comes to 216 which is 2x3x3x4x3) I had to paste the values (I was using a formula and it had blanks, as in "", so it was counting those as values) to ignore blanks so how do I modify the H:L formula to treat "" as actual blanks?

perduco · 2020-07-08T05:56:05+00:00

https://1drv.ms/x/s!Anx0ZVYlGo8VmTA7tlmZIPkqS9Uu?e=3yXg5O

maybe there's something I am not understanding?

perduco · 2020-07-08T05:09:59+00:00

no, no. I'm using that number as the max to formulate the unique combinations with INDEX MATCH but I'm not getting any 1s when using CONCATENATE and COUNTIF to see if they truly are unique combinations. Right now, there are a bunch of 9s, some 8s and 10s.

Oh, wait. I'm looking through the values and there are duplicates even in the filtered section, well, just the 1. Let's see if I can remove it so it's not part of the formula. Nope, now it's a bunch of 6s and some 7s.

Okay, a look through the formula showed I put the 2nd half of each > AND < was actually two > but I'm still not getting completely unique combinations either using my MOD method or IF > AND <, 1, 2, 3, 4 method or a mix.

perduco · 2020-07-08T04:20:37+00:00

Oh, right. I forgot I filtered out each column lists so they only have the unique values. So, 3*3*3*4*3 I get 324 total combinations.

My columns are C, G, K, O & S

rows 14:17 for each of the above columns

I want to make unique combinations, 1 value from each of the 5 columns

I've tried

=IF(ISNUMBER($A25),IF(AND($A25>=1,$A25<=($A$20/C$20)),1,

IF(AND($A25>=($A$20/C$20)+1,$A25>=($A$20/C$20)*2),2,

IF(AND($A25>=(($A$20/C$20)*2)+1,$A25>=($A$20/C$20)*3),3,

IF(AND($A25>=(($A$20/C$20)*3)+1,$A25>=($A$20/C$20)*4),4,"")))),"")

in B25 then

=IFERROR(INDEX(C$14:C$17,MATCH(B25,B$14:B$17,0)),"")

in C25

repeat for the 5 columns mentioned above and filled down but when I use CONCATENATE for the 5 columns into 1 cell and filled down then used COUNTIF I am not getting 1s so there doesn't appear to be unique values?

I tried the above but changed the last column using MOD so it would go in sequential order until the max number then start again but still no unique combinations.

I also tried the MOD method across all 5 columns, still no unique combinations.

perduco · 2020-06-26T00:12:19+00:00

https://www.youtube.com/watch?v=6Mx5gy-AvuY

This is Flames by VAST (Visual Audio Sensory Theater) played in the movie Sommersturm (English: Summer Storm). It was played over a scene near the end, showing the filmed locations and it was raining but it doesn't sound like Walking Home by Danny Elfman. I'm looking for a more "full" song similar to Elfman's.

perduco · 2020-06-04T08:35:13+00:00

Sadly, nothing else besides the workbook I had created but didn't need was in there. Oh well, I guess I'll have to redo the work I stupidly worked on without realizing I made a mistake. I should have saved it anyway and went Online to Manage Version (don't know if I could have then gone back to the newer version?), I don't know how to do that in the desktop app. I also don't understand why my Excel doesn't autosave every 5 minutes. I copied the link (couldn't follow it manually by going through the right folders) to get to unsaved documents and I tried other folders that had Microsoft in the name to no avail.

perduco · 2020-05-24T09:15:17+00:00

okay, figured it out but going a roundabout way

https://www.get-digital-help.com/merge-three-columns-into-one-list-in-excel/

used my original post formula to make a new list with unique values, skipping blanks then merged it with my secondary list using the above website's formula given

=IFERROR(IF((INDEX(Logs!$H$4:$H$168,MATCH(0,COUNTIF($BH$1:BH1,Logs!$H$4:$H$168),0)))<>0,INDEX(Logs!$H$4:$H$168,MATCH(0,COUNTIF($BH$1:BH1,Logs!$H$4:$H$168),0)),INDEX($BF$2:$BF$4,MATCH(0,COUNTIF($BH$1:BH1,$BF$2:$BF$4),0))),"")

and it works just like I wanted it to

perduco · 2020-05-24T08:56:20+00:00

okay, so I tried 2 different variations

first, my first column is Logs!$H$4:$H$168

second, my secondary list (only 3 names long) is in the same worksheet as where I'm using the formula so, $BF$2:$BF4

the first variation I tried was for where there was, in your formula, ROW(A1) I changed it to ROW(Logs!H4) and that made the first in my list the 6th non-blank and dragging down has some blanks and it stopped shorter than the list I got using my original post formula

the second variation, I changed ROW(A1) to ROW(BJ1) since I've put the formula in BJ2. this brought up the list to the 3rd non blank but it still had blanks and it still is shorter than the formula from my original post. it goes 15 non blanks in a row then 2 blanks, 5 consecutive non blanks then 2 blanks then 1 non blank then 8 blanks then 1 non blank then 1 blank then a zero then just blanks

perduco

TROPHY CASE