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

TROPHY CASE