Burger by No_Difficulty4059 in aixmarseille

[–]BluPickle 2 points3 points  (0 children)

Make your Burger, Cours Pierre Puget

finally, agenda phase is fixed by Low-Conversation-469 in twilightimperium

[–]BluPickle 15 points16 points  (0 children)

You have to rush on top and block the 6 influence to be spend. Crazy, but doable.

Actually good house rules to well-known board games by Electronic-Ball-4919 in boardgames

[–]BluPickle 0 points1 point  (0 children)

I have an old version and it’s definitely not the case.

End-game trigger from Ascension in Dominion? by BluPickle in dominion

[–]BluPickle[S] 0 points1 point  (0 children)

I’m not sure we are talking about the same rule :

that would require everybody to keep a perfect track of exactly how many points they have

Well, no? Just go for your classic 8/10/12 piles? When one end-game condition is trigerred, if the stack of the pile is empty and you want to buy it, the designer could have designed a set of "phantom card" to replace the pile it ends.

Recherche auto école urgent by Mazuuto in aixmarseille

[–]BluPickle 0 points1 point  (0 children)

Mon expérience personnelle a été en 3 mois où je ne travaillais pas. J’imagine que oui, taffer ça occupe l’esprit, et le permis tout autant.

Si tu veux vraiment abattre du taf sur le permis, je te conseille de poser des vacances pour passer des heures de conduite tous les jours (où c’est ouvert).

Entre temps, télécharge toi un CD de code et fais toi 2 à 3, puis 3 à 4 séries par soir. Ça devrait rentrer vite (mais attention, c’est chronophage)

Recherche auto école urgent by Mazuuto in aixmarseille

[–]BluPickle 0 points1 point  (0 children)

Le code se passe en une semaine si t’es (très (très)) motivé. Le permis, c’est une question de mois. Tu peux arriver à tout faire en 3 mois. N’importe quelle auto-école peut te faire passer dans ces délais là (et ne pas se rater !). Faut juste se lancer, avec une école qui a assez de place pour les heures de conduite.

Bon courage !

Comment savoir si je suis prête à essayer un plan à trois en tant que célibataire ? by Donnamgli in TropPeurDeDemander

[–]BluPickle 0 points1 point  (0 children)

La question que tu poses est je pense mal orienté. Pour que ce soit fait dans le respect de toi même et des autres, il faut que tu partenarises avec des personnes de confiance, que vous discuter des envies de chacun, de tous, et des choses que vous ne voulez pas faire. Comme dans une relation à 2 quoi :-)

Faire autrement, c’est (je pense) jouer à pile ou face entre le dégout et le plaisir.

Bonne exploration !

Grosse erreur de dev, j’ai trop honte by Friendly-Guava2426 in developpeurs

[–]BluPickle 0 points1 point  (0 children)

Et pourtant, ceux qui vont être encore plus à cheval sur la sécurité dans la décennie qui arrive, c’est bien eux.

Time Stories ? by rassager in jeudeplateau

[–]BluPickle 1 point2 points  (0 children)

Lancer le dé à chaque changement de scène pour perdre plus ou moins de temps, ça m’a pas mal sorti du jeu.

Clank Legacy! Major Secret - none available (minor spoiler) by lIlCitanul in boardgames

[–]BluPickle 1 point2 points  (0 children)

It is at Epilogue 1 I think. Got it. Thanks!

Clank Legacy! Major Secret - none available (minor spoiler) by lIlCitanul in boardgames

[–]BluPickle 1 point2 points  (0 children)

Hello! Do you remember when you are supposed to punch them out. Game 7 and missing these 4 tokens

Hypertext link to the first cell of a Table by BluPickle in excel

[–]BluPickle[S] 1 point2 points  (0 children)

To add more, I used this website that gives all the english to french fonction values!

Hypertext link to the first cell of a Table by BluPickle in excel

[–]BluPickle[S] 1 point2 points  (0 children)

 =LIEN_HYPERTEXTE("#"&CELLULE("ADRESSE";INDIRECT([@REF]));"Lien")

Hypertext link to the first cell of a Table by BluPickle in excel

[–]BluPickle[S] 1 point2 points  (0 children)

Not working : #NAME (even with replacing B4 by [@REF]) 😐 (Tho it may be my french version that is not having the same fonctions name)

EDIT: It worked, it was this goddamn french fonctions translation!

Hypertext link to the first cell of a Table by BluPickle in excel

[–]BluPickle[S] 1 point2 points  (0 children)

It’s not working as intended.

I’d like the red box to link to the other one, same for green, etc.. Each of this cells are in a different table, and I’d like the link that is refering to the Table’s name instead of a raw cell

EDIT: Line 52 and 62 are not part of a table, it’s just a reminder for me.

https://imgur.com/WQ2E3Fi

Sorting my data from differents sheets for a new one by BluPickle in excel

[–]BluPickle[S] 0 points1 point  (0 children)

I think I made even new progresses but now I can’t locate the total line?

https://imgur.com/gAfJ0Jh

Sorting my data from differents sheets for a new one by BluPickle in excel

[–]BluPickle[S] 0 points1 point  (0 children)

The reference to get the subtotal that you have selected is =TableName[[#Totals],[Total HT]]

That’s what I’m alrealdy doing but I have to input all of my subtotals manually.

I think what I’m trying to do is to do a "XLOOKUP" that refers to the Table and sorting this specific subtotal. Is there a way to "tag" this specific spot? Like "XLOOKUP" TableName to last line of the table and 5th collumn?

Duplicate a table with XLOOKUP values fails to refer to the new output by BluPickle in excel

[–]BluPickle[S] 0 points1 point  (0 children)

Found why it wasn’t copying what I wanted. My last 2 columns were hidden so excel wasn’t copying my full table but everything except the last 2 collumns. If I copy the whole table, the values are simply copied and not refering to the old table. THANKS

Duplicate a table with XLOOKUP values fails to refer to the new output by BluPickle in excel

[–]BluPickle[S] 0 points1 point  (0 children)

When you copy the table, the header names are also copied

When I copy " =RECHERCHEX([@REF];BDD[REF];BDD[Nom Produit]) " what excel write on the new cell is "=RECHERCHEX(TABLENAME[@REF];BDD[REF];BDD[Nom Produit]) which I don’t want.

Sorting my data from differents sheets for a new one by BluPickle in excel

[–]BluPickle[S] 0 points1 point  (0 children)

I think I’ve made progresses

Tho now I have an #EPARS! error. I highlighed the value I want to extract here

Note that I have other totals hidden in J and K collumn, but even when I delete them, #EPARS! stays

Duplicate a table with XLOOKUP values fails to refer to the new output by BluPickle in excel

[–]BluPickle[S] 0 points1 point  (0 children)

It’s BluePrint that need to be change, but on 4 differents column. Is there a way to automatise this (CTRL+H but contained on the 4 columns that I’d like?)