Merge cell excel vba

Excel development and mockups

2024.05.21 19:18 braqut_todd Excel development and mockups

Any Excel VBA and/or dashboard developers here that have experience with a roadmap process for leads and new clients that involve producing mockups for project planning and presentation?
I've started contracting with an Excel consulting firm and they have a great process for working leads through an onboarding funnel that includes producing design mockups after requirement gathering. I wondered if anybody here has any experience creating mockups prior to development of custom solutions or dashboards.

submitted by braqut_todd to excel [link] [comments]

2024.05.21 19:09 Virtual_Speech_2731 Convert MM/DD/YYY Format for be in YearMonth format

Need help I do not understand dates and their functionality in Excel. How would I translate the date to the cell to it's right? Thanks!!
https://preview.redd.it/1p706d4vat1d1.png?width=518&format=png&auto=webp&s=5b6d4743035297eefc42caa4008819babe52a96b

submitted by Virtual_Speech_2731 to excel [link] [comments]

2024.05.21 19:02 smartybrome Advance MS Excel VBA for Beginner to Advanced

submitted by smartybrome to udemyfreebies [link] [comments]

2024.05.21 18:56 abjinternational 22-05-2024, don't miss out on Udemy Free Courses! Act fast, as coupons may expire, allowing you to access the courses for free

submitted by abjinternational to FreeUdemyCoupons [link] [comments]

2024.05.21 18:55 abjinternational 22-05-2024, don't miss out on Udemy Free Courses! Act fast, as coupons may expire, allowing you to access the courses for free

submitted by abjinternational to udemyfreebies [link] [comments]

2024.05.21 18:50 Nearlydawn2 Export or copy Google Sheets Comments To A Cell

I've seen a few questions about this, so thought I'd post my how-to.
Google sheets does not have a way to export the comment text to a cell. Using 3 answers in this reddit, I divised a workaround
A team used the Google Sheets Comment function as if it was a notes field, but reached the max # of comments allowed (didn't know that was a thing).
Workaround:

Export the Google sheet to Excel . XLXS
Save the sheet as XLSM (macro enabled)
Open the sheet and you will see that all the comments are converted to Excel Notes
u/khanabeel wrote this Excel post on how to convert a note to text using VBA
Copy the new column of text to your Google Sheet.
- if you try to re-upload the file you may lose the actual comments, depending on your needs that may be a good thing.

VBA from u/khanabeel:

This was made possible through the use of Visual Basic Module.
Firstly, go to Developer Option and click on Visual Basic. Click on the small icon next to the excel icon, which will bring the dropdown to insert module.
Add the following script and press "Cntrl + S" to save.

Function getComment(incell) As String
' accepts a cell as input and returns its comments (if any) back as a string
On Error Resume Next
getComment = incell.Comment.Text
End Function

To use the script, use "=getcomment(A2)" formula, where A2 is the cell whose comment you want to convert to the cell.
Additionally, you can use "Trim" formula to remove the extra space, if any, that's present in the cell.

submitted by Nearlydawn2 to googlesheets [link] [comments]

2024.05.21 18:43 bigbootyaudi Can this dynamic table be created with one function?

Hello all. I'm trying an exercise to model out membership growth for a product based on a dynamic start date, with a minimum and maximum number of members, and a variable growth rate, and can't seem to figure this one out in full. I know how to do this as separate functions but not as one big combined function.
The conditions I'm trying to model are:

In the table on the right, the Quarter row must match the Start Date column for each listed market.
If I change the Start Date, the output also has to match the new Start Date
When the quarters match, the first input should always be the value in Starting Members/Market.
The maximum value that number hits should match the column Max Members
Each quarter, the number in the previous cell (assuming it isn't 0), must grow by the "Monthly New Member Growth Rate Q1-8" and "Q9-20" depending on how many quarters have passed since that market opened
Each quarter, the "Monthly Churn Rate" also has to be included in the count, prior to the growth rate calculation.

So, do I need to split this up into a bunch of different rows, or can this all be accomplished in one function? I am using Excel 2016
https://preview.redd.it/plrm61o96t1d1.png?width=943&format=png&auto=webp&s=7af0b23d22ed78906c61530ea91aab54074fc8eb

submitted by bigbootyaudi to excel [link] [comments]

2024.05.21 18:09 TheWagn Arc Thrower - fun, but needs some love

I have been mixing up my loadouts these days to spice things up. Recently I have been having a bit of a love affair with the arc thrower. To preface - I only play helldive difficulty these days and all this feedback is based on helldive.
I will say I have had a lot of fun running arc thrower, but I will also admit it has a lot of flaws, perhaps too many, and could use a little love. It really doesn’t need anything too major, but I will discuss my thoughts and experience here. Thanks for coming to my ted talk.
The PROS ⚡️⚡️⚡️

Great for crowd control if you can gain some space. 20-30 meters is ideal as the max range is now about 30 meters. With the ship upgrade you can chain to 3 targets if they are lined up or bunched up.
The stagger effect (this is the only thing that makes this weapon viable, imo). You can push back hordes of brood commanders and even bile spewers and (slowly) shock them to death
Infinite ammo, which funny enough is probably the weakest “strength” of this weapon because it has to be balanced around it, while other support weapons essentially have infinite ammo with the ship full resupply upgrade. I never run out of AC ammo because 1 supply pack refills to full, and you can just call another backpack down once the cooldown is up.
No backpack, but you really need to run one to make this thing viable on higher levels. I will discuss backpacks more later.

The CONS ⛈️⛈️⛈️

Must be careful around teammates. For the most success you just have to hope your teammates understand the cone radius and to let you handle things without running into your lightning. Not a huge ask, but a lot of folks are operating with 2 brain cells and love to get in the way of you and your targets. I have been in many situations where I can’t use the weapon because people are too close. Pro tip - always stand BEHIND the arc thrower guy and there is a 0% chance it will kill you.
It takes forever to kill Hulks/Chargers without help. Chargers take about 5-6 headshots (yes, headshots) based on my tests. If you aren’t hitting the head every time it can take 7-8 shots sometimes. Hulks die a bit faster, but headshotting them somehow became really inconsistent after the last arc thrower change. You also can no longer stun hulks :(
Although it can handle both heavy units by itself, it can be very time consuming, and during that time your team is moving on, and other enemies are approaching. Fighting a charger alone is free, but fighting one with a bunch of bugs jumping on you is quite the struggle with arc thrower. If you aren’t careful you will find yourself in giant fights that you probably shouldn’t be in.
Misfires - these seem to happen usually when there isn’t a clear path to a target, but I’ve also had it happen when I’m in prime position to blast a spawn. A misfire messes up the cadence of stuns and cripples the weapon badly. It feels really fucking bad to be crowd controlling a bunch of guys only for the gun to triple misfire and suddenly you are swarmed and dead. This needs to be fixed ASAP and the gun would feel wayyy better.
Basically useless against elites. This is fine on paper, as a weapon that excels in chaf clear shouldn’t excel and killing elites, but it would be nice if they could feasibly down one without dancing around for 5 mins. It can strip the armor off a bile titan which is kinda neat.
Terrible at point blank range. If little bugs get too close you MUST swap to another weapon to deal with them. Arc thrower will just stop working and you will eat tons of damage if you don’t clear them out with something else.

How I would buff it:

consistently stagger hulks again please. Arc thrower is already not great for bots, but now it has almost no appeal without being able to stun hulks. That was an interesting niche it filled that has been removed.
either increase fire rate or damage to make the heavy killing experience a bit faster than paint drying. Yes, it has infinite ammo, but that should be more of a unique feature rather than a reason to keep its power so low. Other support weapons really have no ammo issues nowadays, and are essentially infinite ammo. Also Quasar exists…so theres that.

General arc thrower tips!

Use a backpack! It helps a lot! My favorite is shield pack so you can shrug off encroaching enemies and be able to dip in and out of the fray easier. Dog laser is good too to kill chaf that gets too close as well as shoot behind you as run. Jetpack I haven’t used with this, but it can be very strong and allow you to get high ground and escape bad situations.
Swap to a shotgun or close range weapon for enemies that get too close. Arc thrower doesn’t work well at point blank range, so always be ready to whip out a shotgun when the little bugs get too close. I use the incendiary breaker (so original) but it works great in tandem.
Be careful when teammates are close. If you charged a shot already you can aim up and fire into space to expend a charge if needed.
Stun grenades can help you gain some distance and free shots on bigger targets.
Be sure to run elite killing stratagems like 500kg, orbital railcannon, orbital laser, 380 barrage, etc. You don’t need much chaf clear as the arc thrower will be your main source of chaf clear anyways.
Run into the fray! But also be ready to run away when things get too hairy. Remember you always want to be about 20-30 meters away.
Aim for headshots! Things will die a lot faster if you hit criticals with arc thrower. Aim high as it trends downward.

Let me know your thoughts on arc thrower if you’re an arc thrower enjoyer!

submitted by TheWagn to Helldivers [link] [comments]

2024.05.21 18:04 sammyybaddyy Is there a equivalent of opencsv's profile for Poiji?

I want to map different columns to the same property in my java object. I've done this for CSV with something like @CSVBindByName(column="Name A", profile="Profile A") @CSVBindByName(column="Name B", profile="Profile B" Property property
I already have something like below for Excel but want to add more columns to the property @ExcelCellName("Name A") Property property
Also happy to use another excel library

submitted by sammyybaddyy to learnprogramming [link] [comments]

2024.05.21 17:57 alifihri dynamic Autofill Dropdown list

Hey I need help in this:
I have two drop down lists country and city, and want to achieve these points on VBA:
-First make only first value available if us is selected and make it default value.(By default I mean once us is selected in E3 update the cell to "NYC"

If international is selected in E3 make all values available and make the first one default
If us is selected make all values available in the drop down and make the first one the default cell value(by default I mean once us is selected update the cell E4 to NYC

submitted by alifihri to excel [link] [comments]

2024.05.21 17:21 Accomplished_Path707 Python in excel

Howdy all, I’m basically a beginner, but I have this python script I’d like to use in excel. I have a couple different goals. 1. Is to have this script run in the sheet with out need for the file to be in a folder with script so I don’t have to worry about rename directories 2. Remove the need for a button with VBA and a macro 3. Going with out installing xlwings on every computer that might run this sheet.
The script is quite long (150 ish line) I think? Can prolly be cut down as its current made to process the whole sheet.
My problem is I don’t even know where to start or what questions to ask.
The script is python and using the FedEx api to track packages.
Thanks for your time and input. PS. Keep cool out there cause summer is coming!

submitted by Accomplished_Path707 to learnpython [link] [comments]

2024.05.21 17:01 MinionOrDaBob4Today Anyone else hate this error?

“Formula omits adjacent cells” and my entire spreadsheet has the stupid green ribbons. Hey excel did you maybe think I omitted them on purpose? Like maybe I get paid to do this sort of thing. You think you’re better than me? Smarter than me? I’ll show you…

submitted by MinionOrDaBob4Today to Accounting [link] [comments]

2024.05.21 16:57 abjinternational Advance MS Excel VBA for Beginner to Advanced

submitted by abjinternational to udemyfreebies [link] [comments]

2024.05.21 16:57 abjinternational Advance MS Excel VBA for Beginner to Advanced

submitted by abjinternational to udemycoursedaily [link] [comments]

2024.05.21 16:57 abjinternational Advance MS Excel VBA for Beginner to Advanced

submitted by abjinternational to FreeUdemyCoupons [link] [comments]

2024.05.21 16:43 Ok-Difference-7517 Sender email trouble - Sending Email with VBA

I'm using VBA to send emails, no problem with that.
The problem I have is that it sends (consistently) from one of my emails for all of the test sends.
If I want it to be sent from a particular email, how would I do it? or does anyone know the logic behind the code choosing which email to send from?
Thank you in advance!
Edit: I've tried changing primary account on outlook, doesn't work

Sub SendEmailCCX() Workbooks("2024SendEmail.xlsm").Activate Dim i As Integer i = 2 Do While Cells(i, 1).Value <> "" Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody, name, emailadd, memberid, emailsub, EL1, EL2, EL3, EL4, EL5, EL6, EL7, EL8, EL9, xiaoyou As String '----------------------------------------------------------------------------------------- Set xOutApp = CreateObject("Outlook.Application") Set xOutMail = xOutApp.Createitem(0) emailadd = Cells(i, 6).Value name = Cells(i, 5).Value emailsub = Cells(i, 7).Value Const LineBreak = "
" EL1 = Cells(i, 8).Value EL2 = Cells(i, 9).Value EL3 = Cells(i, 10).Value EL4 = Cells(i, 11).Value EL5 = Cells(i, 12).Value EL6 = Cells(i, 13).Value EL7 = Cells(i, 14).Value EL8 = Cells(i, 15).Value EL9 = Cells(i, 16).Value xMailBody = EL1 & name & LineBreak & LineBreak & _ "" & EL2 & "" & LineBreak & _ EL3 & LineBreak & _ EL4 & LineBreak & _ EL5 & LineBreak & _ EL6 & LineBreak & _ EL7 & LineBreak & _ EL8 & LineBreak & LineBreak & _ EL9 On Error Resume Next With xOutMail .To = emailadd .CC = "" .BCC = "" .Subject = emailsub .htmlbody = xMailBody .Attachments.Add ("C:\Users\User\Desktop\2024Letter.pdf") '.Display .Send End With i = i + 1 Loop Set xOutMail = Nothing Set xOutApp = Nothing MsgBox "Email Sent!" End Sub

submitted by Ok-Difference-7517 to excel [link] [comments]

2024.05.21 16:22 Spidey007 [Dragon Ball Z/MCU: Final Arc] The Janemba Saga- Gohan’s Ascension

To note, this is a continuation of the sagas I wrote that took place after the Cell Saga. The two sagas were written with inspiration taken from MCU Peter Parker's arcs in Far from Home and No Way Home. The goal was to develop Son Gohan into a proper lead for the show. If you'd like to check them out, here are the links!
Bojack (Far From Home) Saga: https://www.reddit.com/fixingmovies/s/sK5zOnJ0oU
Broly (No Way Home) Saga: https://www.reddit.com/fixingmovies/s/R3sGOqdbIv
There are many things I find wrong in the Buu saga:

Goku coming back: This derails the narrative tremendously as he snatches back the torch from Gohan. He's going to play a role, but he will stay dead.
Gohan's writing: In canon, we ended up with a rusty, goofy, badly written character who lost all the development from the previous sagas. He became a useless disappointment and did not uphold his role as a protector of the earth. This won't go anywhere near that direction.
SSJ3 and fusions: These elements were unnecessary as they did nothing to solve the plot and only provided fluff. This can be introduced in Super, but that's another story.
Goten and Trunks SSJ: I wasn't a fan of how they easily transformed, treating it as an easy power-up. Here, it will be earned.

What I want to do here is combine the Buu saga with Fusion Reborn. For that movie, there are tons of elements at play that can be used to make the grand finale of Dragon Ball Z, more grand. The goal here is to increase the stakes, trim all the unnecessary fat, give everyone a chance to shine, and keep the main focus on Gohan. I also want to replace Buu with Janemba, as I find him much more threatening due to his unique abilities which would be perfect to challenge Gohan. It's also here that we avoid the rinse-and-repeat problem that came with Buu and his many forms.

Without further ado, here is the...... Janemba Saga!

Seven years have passed since the climactic battle against Broly. Gohan, now a young adult, has diligently pursued a delicate balance between his studies and training. During this time, he has honed his Super Saiyan 2 form and significantly elevated his combat skills. However, he deliberately restrains his power, refusing to succumb to the depths of his inner rage. Gohan believes that his technical prowess alone will suffice, opting to suppress the primal fury within him. Despite his reservations, Gohan attends a prestigious private school on an academic scholarship, alongside his steadfast companion Videl and their circle of friends. Gohan has embraced the responsibility of preserving peace on Earth as a valiant hero, adopting the mantle of Saiyaman. His suit has undergone a sleek redesign, shedding the theatrical poses in favor of a more streamlined appearance. Functioning as a dynamic duo reminiscent of Superman and Batman, Gohan and Videl tackle the city's crime wave together. Videl, having mastered her ki abilities under the tutelage of Piccolo, has grown stronger over the years. Glimpses of their everyday lives reveal the struggles of Gohan as he endeavors to balance the demands of school, training, and personal relationships. Amidst the challenges, he harbors a subtle resentment towards his duty, as it often encroaches upon his cherished personal time. Nevertheless, Gohan persists, fueled by his unwavering determination to live up to his father's legacy.
However, the tranquil facade is shattered when a harrowing turn of events unfolds. The narrative transitions to an otherworldly realm, distinctly separate from Earth. A mysterious figure cloaked in darkness materializes, none other than the malevolent wizard Babidi. Harnessing the unholy power of dark magic, Babidi establishes a sinister connection with his loyal minion Dabura, the King of the Demon Realm. United in their nefarious purpose, they orchestrate an audacious invasion of Otherworld, intent on freeing the formidable demon Janemba. Ages ago, Janemba had been sealed away in this celestial realm by the Supreme Kais. Babidi's malevolent ambition revolves around shrouding the universe in eternal darkness. To achieve this nightmarish vision, he plans to infect the denizens of Earth using the insidious Majin spell, thereby expanding his dominion across countless planets.
In the midst of this burgeoning chaos, Gohan, disguised as Saiyaman, finds himself investigating a peculiar incident involving the possession of one of his dearest friends. Videl, resolute and fearless, engages in a fierce battle against the malevolent puppeteer controlling Sharpner. With unwavering confidence, she urges Gohan to let her confront the threat alone. Sharpner, his strength unnaturally augmented, puts up a formidable resistance, but Videl's experience enables her to subdue him without resorting to fatal measures. As Sharpner awakens from his trance, Gohan seeks answers regarding the enigmatic force that had seized control of his friend. Sharpner reveals that a voice called Babidi had whispered malevolent commands into his mind. Armed with this critical information, Gohan summons Vegeta and Piccolo to join him in unraveling the unfolding crisis, embarking on a journey towards the epicenter of the ominous power emanating from a series of potent and wicked ki signatures, ultimately leading them to Babidi and Dabura.
Meanwhile, Earth becomes a battleground, besieged by an onslaught of resurrected zombies, soldiers, and former villains who once terrorized its populace. Though the trio finds themselves torn between aiding their beleaguered planet and confronting the imminent threat directly before them, they know their immediate priority lies in thwarting Babidi's scheme. Distracting them with his grandiose monologue, Babidi probes their minds, seeking susceptible individuals to manipulate. Initially targeting Vegeta, Babidi redirects his attention toward Piccolo, sensing his inherent duality as a being born of both good and evil. With a combination of Babidi's insidious spell and the lingering malevolence of Piccolo Daimao, the Namekian warrior struggles to resist the overwhelming influence. His powers surge exponentially beyond their previous limitations, clouding his judgment and driving him to confront his former student, Gohan. Amidst the shock of this unforeseen twist, Gohan assumes the responsibility of awakening Piccolo from his trance-like state, determined to restore his mentor's clarity. As the battle rages on, they sense a tremor that reverberates throughout the planet, an unmistakable ki signature brimming with icy coldness, signifying the presence of a singular entity—Janemba.
Bracing himself for the impending clash with this malevolent force, Gohan prepares to face Janemba head-on, while Piccolo embarks on a personal mission to neutralize Babidi. Meanwhile, Vegeta remains locked in a fierce struggle against Dabura, the Prince of Saiyans confronting the King of the Demon Realm. The confrontation unfolds with brutal intensity, and Vegeta finds himself teetering on the edge of defeat. Sensing his adversary's advantage, Dabura unleashes a legion of demons to tip the scales further in his favor. Pushed to his limits, Vegeta fights valiantly, but the odds appear insurmountable. Dabura, consumed by arrogance, revels in his imminent triumph, announcing his intention to unleash the full might of the demon horde upon Earth. Faced with the dire consequences of such a cataclysm, Vegeta musters every ounce of desperation within him. In a moment of self-sacrifice, he unleashes a devastating attack upon Dabura and his minions. The resulting explosion weakens Babidi's forces, repels the encroaching Demon Realm, and safeguards their dimension from untold chaos and devastation.
(Note: I wanted to keep Vegeta's sacrifice but make it matter and count. In canon, it didn't stop Buu, and he sent himself into cold oblivion on a lie. Here, he makes a difference in the long run and has a definitive redemptive moment. )
Startled by the sudden disappearance of Vegeta's powerful ki, Trunks defies the protests of his comrades on the Lookout and rushes towards the chaotic battleground. His heart pounds with trepidation as he races through the smoke-filled air, only to be confronted with the lifeless body of his father lying motionless on the ground. Overwhelmed by a torrent of despair and seething rage, Trunks' trembling hands reach out to shake his father awake, his desperate pleas echoing through the desolate landscape. But his efforts prove futile, and a profound sense of loss engulfs him.
In the midst of this heart-wrenching moment, a surge of raw energy courses through Trunks' veins, igniting a transformation that surpasses the boundaries of his mortal self. Radiating an aura of vibrant golden light, Trunks ascends to the legendary state of the Super Saiyan. His eyes ablaze with determination and fury, he is now ready to face the battle that lies ahead.The scene shifts, revealing the remaining Z-Fighters locked in a perilous struggle against hordes of relentless zombies. Fatigue weighs heavily upon their weary bodies as they fend off the relentless onslaught. Suddenly, a streak of intense power streaks across the sky, and Trunks descends before his comrades, newly transformed and brimming with indomitable strength. A burst of energy erupts from his fingertips, shattering a ki blast launched by one of the zombies, diverting it harmlessly away. In the eyes of his adversaries, astonishment mingles with mockery as they behold the sight of a mere child standing before them.Unfazed by their taunting laughter, Trunks addresses his comrades with unwavering resolve. He declares that he will shoulder the burden of the battle, vowing that not a single life will be lost on this day. With unparalleled speed and precision, he charges towards the encroaching horde, obliterating each zombie with astonishing ease. Their forces crumble beneath the might of his wrath, and the battlefield is transformed into a graveyard of defeated foes.As the last of the zombies falls, Trunks relinquishes his Super Saiyan form, his energy spent and body drained. Collapsing to the ground, he succumbs to exhaustion, his breathing ragged and labored. In this moment of vulnerability, Yamcha, recognizing the young warrior's valor, rushes to his side and gently lifts him from the battlefield, cradling his battered form with utmost care.
(Note: Kid Trunks' transformation is a direct reference to when Future Trunks found Gohan dead after the battle with the androids, and then he transformed. )
While this tumultuous event unfolded, the responsibility of safeguarding the Lookout fell upon the young shoulders of Goten. As time passed, a sudden intrusion disrupted the tranquility of the platform, as a malevolent henchman, infused with the dark power of King Cold, materialized before him. Though momentarily shaken, Goten summoned his courage and engaged in a valiant struggle against his formidable adversary.Initially, it appeared that Goten held his ground admirably, skillfully countering the attacks launched by the nefarious duo of Salza and Dore. However, their sinister coordination gradually began to overpower the young warrior. In a devastating display of force, Salza executed a malicious kick that sent Goten hurtling towards the precipice of the Lookout, teetering on the brink of unconsciousness.
Witnessing her son's battered and vulnerable state, Chi-Chi, consumed by a mixture of horror and fury, lunged at Salza in a desperate attempt to defend her child. Yet, her efforts proved futile as Salza callously seized her by the throat, mercilessly constricting the life from her. From his weakened position, Goten, wide-eyed and mouth agape, struggled to remain conscious, his mind besieged by the conflicting emotions of impending death and the weight of disappointment.
In that critical moment, he closed his eyes, his teeth sinking into his lip until blood stained his mouth. His trembling hands clenched into tight fists. And then, something within him snapped, unleashing a primal force that lay dormant within.Goten vanished, replaced by an embodiment of unbridled rage. Transformed into a Super Saiyan, his furious aura radiated with an intensity that defied comprehension. With a surge of unrestrained power, he propelled himself towards Salza, obliterating his malevolent foe with a devastating blast that eradicated him from existence. Undeterred by the remaining henchmen who sought to avenge their fallen comrade, Goten engaged them with a newfound ferocity.In a breathtaking display of combat prowess, it took mere moments for Goten to dispatch his adversaries, consigning them to the depths of the afterlife. Unaware of his mother's watchful gaze, Chi-Chi bore witness to the astonishing transformation of her once-innocent son, her heart filled with awe at the unfathomable power he now wielded.
(Note: This is a reference to when Superman had attacked Zod for attacking Martha in Man of Steel. With this, Goten is able to break out of his shell and experience some development. I also did not want Chi-Chi to die, but to have it be close. This way, she can witness firsthand her son fighting to avenge her and realizing that his saiyan blood kicked in to save them all, which would lead to some development towards her accepting that they have the natural power to fight, but also protect. )
Simultaneously, amidst the chaos, Piccolo found himself embroiled in a fierce battle of magic. His objective was to shatter the impenetrable barrier erected by his adversary, Babidi, to halt the relentless proliferation of Majin-infused beings. The odds were stacked against him, but with unwavering determination, Piccolo summoned the strength to rupture the barrier, ultimately delivering a fatal blow to Babidi. In doing so, he succeeded in halting the insidious spread of the Majin curse.Meanwhile, Gohan, driven by an overwhelming surge of power in his Super Saiyan 2 form, charged headlong at the formidable Fat Janemba, intent on swiftly ending the confrontation. Displaying remarkable valor, Gohan engaged his adversary with all his might, momentarily gaining the upper hand in fleeting bursts of fury. However, Janemba's energy continued to surge unabated, gradually overpowering Gohan and relegating him to a defensive stance.With the battle reaching its climax, Janemba unleashed a devastating onslaught aimed at obliterating the planet. In a desperate bid to protect all that he held dear, Gohan fearlessly interposed himself between Janemba's lethal assault and the world, extending his arms wide as he summoned the last vestiges of his ki to create a resolute energy shield. The technique demanded one final act of defiance, compelling Gohan to redirect the unleashed energy back towards Janemba, propelling the malevolent entity backward and teetering on the precipice of annihilation. Yet, the maneuver exacted a heavy toll on Gohan, leaving him grievously injured and drained of consciousness, hurtling through the sky and crashing deep into the untamed wilderness.
(Note: This maneuver is a mix of what Gohan did against Broly in Movie 10, and what Future Gohan did in his last battle against the androids.)
Subsequently, Supreme Kai, recognizing the dire condition of the young warrior, transported Gohan to the realm of the Kais. As Gohan gradually regained consciousness, he found himself surrounded by the presence of Supreme Kai, Kibito, and his father, Son Goku. Unbeknownst to Gohan, while the realms beyond had been engulfed in pandemonium, Goku had valiantly sought to subdue numerous formidable adversaries, most notably Broly. Upon learning of Gohan's presence on that distant planet, Goku implored for the opportunity to visit his son, a request that was granted amidst the bittersweet reunion.During their heartfelt meeting, they shared the weight of overseeing the turmoil ravaging Earth, realizing that Janemba still lingered, amassing the remnants of malevolent ki left unvanquished. Panic washed over Gohan as he urgently expressed his need to return to Earth, but his pleas were met with cautionary words from his loved ones. They acknowledged his unpreparedness to face Janemba anew, warning of the potential consequences should he engage the foe prematurely. Supreme Kai disclosed his true intention in bringing Gohan to this realm—to unlock the dormant power lying dormant within him. However, the process demanded a profound reconciliation of Gohan's dual nature as both human and Saiyan. To initiate this transformative ritual, Gohan would be immersed in a meditative trance within the sacred confines of a cascading waterfall, which would serve as a mirror reflecting his true self. Only then would he embark upon the arduous journey of unlocking his latent potential, fully aware that failure could result in dire consequences, even death.
Nervously, Gohan steeled himself for the imminent trial, drawing strength from the unwavering support of his father. With resolute determination, he approached the cascading waterfall, where Supreme Kai initiated the trance, enveloping Gohan in an ethereal aura of introspection.As the ritual commenced, Gohan's gaze fixated grimly upon vivid recollections of his past battles, struggling to reconcile the moments when he had succumbed to his own wrath. Before long, a projection materialized, representing his suppressed Saiyan essence—a separate entity demanding to be acknowledged. A tumultuous clash ensued between the two facets of Gohan's being, with the young warrior faltering in his attempts to gain the upper hand, for each surge of anger only fueled his other self. Finally, a profound realization washed over Gohan, piercing through the haze of conflict. He ceased resisting and, instead, extended a hand of acceptance and understanding to his Saiyan counterpart, embracing the essence of his true nature. In that transformative instant, the boundaries dissolved, merging into a harmonious unity. Gohan's eyes fluttered open as he awakened from the trance, reborn in his newfound Ultimate Form, his essence finally whole and indomitable.
(Note: Yes, this is a direct reference to Naruto obtaining true mastery of his nine tails form in Shippuden. I did not like Gohan's canon mystic ritual because it did not feel earned. He just sat around for a long time doing nothing and gained nothing from it. I wanted to fix that. So here, he went through a more direct ritual at the risk of death to be able to unlock his true abilities. )
In the midst of these events, Trunks and Goten find themselves under the tutelage of Piccolo within the formidable Hyperbolic Time Chamber. News reaches Piccolo that Gohan is undergoing a transformative process to unlock his latent potential, but the looming return of Janemba threatens to disrupt their plans. Exiting the chamber, Trunks and Goten emerge stronger than ever, having mastered their Super Saiyan forms and honed their teamwork to near perfection, compensating for their inherent power limitations.As Janemba crosses paths with them, the clash erupts in a spectacular display of martial prowess. Individually, they stand little chance against the overwhelming might of Janemba, but when united, a different narrative unfolds. Their combined efforts aim to sustain the battle long enough, providing Gohan with the precious time he needs to complete his ritual. Piccolo assumes leadership, valiantly holding his ground, although it becomes increasingly evident that Janemba possesses a distinct advantage. Piccolo strategically diverts Janemba's attention, creating openings for Goten and Trunks to launch coordinated assaults that vex their adversary, even if their impact is minimal. Nonetheless, every second counts.
In a fateful turn of events, Janemba unleashes an assault that overwhelms Piccolo, incapacitating him and leaving only Goten and Trunks to face the malevolent entity. Swift as a phantom, Janemba materializes in front of Trunks, delivering a devastating blow to his abdomen, leaving Goten as the lone defender. Standing tall, Goten defiantly assumes a battle stance, mustering his courage. However, before Janemba can unleash a devastating attack upon him, an unknown figure delivers a powerful kick to Janemba's head, hurtling him towards the distant mountains.
The camera pans, revealing the figure to be none other than Gohan, resplendent in his newfound form.
(Note: This entrance directly mirrors that of Future Gohan when he was about to begin his final battle against the Androids!)
A wave of elation washes over Goten as he beholds the return of his beloved elder brother, while Trunks and Piccolo visibly exhale with relief. Gohan and Piccolo exchange a brief but meaningful exchange, Gohan acknowledging his newfound strength while Piccolo recognizes that Gohan has ascended to an entirely different echelon. Janemba regains his footing, reemerging before them, demanding their attention and focus. Gohan asserts that he will confront Janemba directly, urging the others to evacuate. Though reluctant, Piccolo and the young warriors comply, dispersing to various parts of the world to address the chaos that plagues their surroundings.
With an air of fury, Janemba charges at Gohan, his fist extended menacingly. Yet Gohan intercepts the attack, seizing Janemba's fist in a vice-like grip, and in a flash of teleportation, they are transported to the dreaded realm of H.F.I.L. (Home For Infinite Losers).
(Note: I have Gohan teleport Janemba because at least this way their battle will not damage Earth. Also we will assume Gohan has figured out some sort of Instant Transmission movement like Goku.)
The eyes of Earth's denizens, the Kais, and the denizens of the Otherworld are fixated on this pivotal moment, the culmination of a battle that will determine the fate of the universe. And so, the clash commences, a cataclysmic struggle that echoes through the very fabric of existence.
In a breathtaking display of power, Gohan initially dominates the battle, effortlessly overpowering Janemba with his newfound might. However, the tables turn when Janemba unveils unexpected abilities: space-time manipulation and a formidable sword. Gohan is caught off guard, unsure of how to counter such unorthodox tactics. Desperation and frustration consume him, causing his control over his own power to slip away.Amidst the chaos, Gohan experiences a moment of revelation, a surge of understanding regarding his opponent's abilities. He realizes that in order to anticipate Janemba's next move, he must heighten his senses by channeling his ki, allowing for precise timing and swift reactions. With this newfound clarity, Gohan regains his composure, closing his eyes and taking a deep breath. Seizing an opportunity, Janemba materializes before him, poised to strike with his sword. Yet, in a stunning display of strength, Gohan catches the blade with both hands, shattering it into pieces.
The tide of the battle begins to shift, albeit slightly, in Gohan's favor. Frustrated and bewildered, Janemba exclaims, "Just what...are you?!" Gohan responds with unwavering resolve, proclaiming, "I am the hope of the universe. I am the answer to all living things that cry out for peace. I am the protector of the innocent. I am the light in the darkness. I am truth. Ally to good! Nightmare to you!"
(Note: I'm taking Goku's dubbed speech against Frieza and repurposing it for Gohan. As he's inherently more the justice-driven hero archetype rather than the fighting maniac that is Goku, it makes more sense. We'll just assume Goku gave Frieza the manga version of his speech. This is also the most pivotal moment of Gohan's journey as he comes to terms with being a protector. Throughout the show, he's been struggling between his desire to be a scholar and his responsibility to be a hero. That dubbed speech is exactly the moment that Gohan's arc comes full circle. Here, he finally embraces what he was always meant to be..... the hero.)
With renewed determination, Gohan launches various assaults in a bid to defeat his formidable adversary. However, his attacks fail to inflict lasting damage, and Gohan himself begins to exhaust his ki. It is then that he realizes the true nature of Janemba's existence—he is an embodiment of pure evil ki, unlike any opponent Gohan has faced before. A desperate plan takes shape in Gohan's mind. Mentally reaching out to his friends and even Videl, he calls upon them to gather their ki, reminiscent of the Spirit Bomb technique. Initially, only the Z-Fighters respond, but their combined energy proves insufficient.As Gohan valiantly defends against Janemba's onslaught, he mentally pleads with the people of Earth to lend their aid. Uncertainty and doubt cast a shadow over the crowd until Hercule steps forward, berating them for refusing to support the man who once saved them during the Cell Games. Revealing the truth of Gohan's identity as the Delivery Boy turned hero, the tide of public opinion shifts. People extend their hands, offering their energy to their savior. Shocked by the sudden turn of events, Gohan is relieved by the surge of ki coursing through him, providing a momentary opening to kick Janemba away. The collective assistance grants Gohan a substantial reservoir of energy, which he then summons forth, infusing it with the very essence of his soul—a daring and perilous maneuver.
Driven to his breaking point, a furious Janemba ascends into the sky, conjuring a colossal sphere of malevolent ki capable of obliterating the entire universe. Gohan remains calm, his gaze fixed upon the impending cataclysm. With unwavering resolve, he declares, "This is the end for you, Janemba." Closing his eyes, Gohan raises his left hand above his head, conjuring a radiant sphere of rainbow light. Seizing the opportunity, Janemba hurls his devastating attack towards Gohan. Sensing the imminent danger, Gohan's eyes snap open as he crushes the ball of energy in his palm. Swiftly pivoting, he hurls the fragmented energy towards the oncoming attack, effortlessly piercing through it, and hurtling towards Janemba, finally eradicating the universe's peril once and for all.
(Note: This is the same technique as Kid Buu's Planet Burst move, the one that destroyed Earth. I also repurposed Gogeta's stardust breaker technique for Gohan as I feel it makes sense for him to have it. It also makes him stand out from Goku even more in this case.)
As the dust settles, Gohan maintains his energy long enough to witness Janemba's demise. A triumphant smirk graces his face as he remarks, "Heh, looks like I finally did it." Exhausted, he collapses to the ground, almost completely drained. The onlookers erupt into joyous cheers, celebrating Gohan's hard-fought victory. Supreme Kai teleports Gohan from the depths of H.F.I.L back to Earth, specifically to the Lookout, where his family and friends eagerly await his return. In a heartwarming scene, Gohan is enveloped in embraces and expressions of relief. It is here, amidst the warmth of their loved ones, that Gohan and Videl share their first kiss—a tender moment of connection and celebration.Meanwhile, the Dragon Balls work their magic, rectifying the chaos caused by Babidi's dark influence. The majority of those who perished are revived, yet there are exceptions, including Vegeta. Accepting his fate and determined to atone for his past deeds, Vegeta expresses his desire to continue growing stronger in the afterlife, entrusting the protection of his family to his son. Tearfully, Trunks vows to make his father proud, with Goten stepping forward to support his friend in this emotional moment. Fond farewells are exchanged as everyone prepares to return to their respective homes.
Gohan and Goten engage in a heartfelt conversation, their bond as brothers strengthening. However, their exchange is interrupted by Chi-Chi, who unexpectedly interrupts their conversation. To their astonishment, she expresses pride in their valiant efforts to safeguard the world, finally relenting and granting them permission to train and protect. The three embrace, their family united and resolute.In a different realm, Vegeta stands before King Yemma, awaiting judgment. To his surprise, he is granted an Otherworldly body, a result of Goku's recommendation and Vegeta's ultimate sacrifice that tipped the scales of justice. With this second chance, Vegeta is granted the opportunity to train ceaselessly and, more importantly, to settle his unfinished business with Goku. The final scene between Goku and Vegeta unfolds, their fists colliding in a charged confrontation, their image freezing .( mirroring the intensity of Rocky and Apollo in Rocky III, leaving their ultimate showdown to the imagination.)
A decade passes, marked by a time skip. Tien and Krillin have established their own martial arts schools, dedicated to passing on their unique styles to the next generation. Goten and Trunks, under the tutelage of Piccolo, diligently train to harness their extraordinary powers. Gohan, now a respected scholar, has married Videl, and together they have a daughter. At home, Videl imparts the basics of combat to their daughter, Pan. Gohan, having just finished delivering a lecture on energy at the university, senses a disturbance reverberating across the planet. Instinctively, he rushes to the rooftop, pressing a button on his wrist. In an instant, he transforms into his iconic Saiyaman costume, soaring into the horizon with a mischievous grin. He breaks through the fourth wall, symbolizing his unwavering resolve to protect and inspire.
The screen fades to black.
The End.
There we have it! My final wrap-up of the MCU Peter ParkeGohan development journey! Honestly, I did have thoughts of just going straight into revising the Buu arc, but I felt there was more to be done before that. Gohan needed to go through the development I gave him in my two written arcs as there were lessons there that shaped him.
I also felt that a trained Gohan, who is naturally intellectual, would be a perfect antagonist in Janemba. He had to learn to outsmart him, and not just have it be a straight-up slugfest.
What do you guys think? Share your thoughts below!
u/fatherandyriley
u/dgenerationmc

submitted by Spidey007 to fixingmovies [link] [comments]

2024.05.21 16:22 hoosiertailgate22 Having issues with sheets?

Hi everyone! I work with excel quite often but it’s literally just reading and no functions whatsoever.
Yesterday I pulled up a spreadsheet and tried to filter out columns. When I right clicked a group of cells, I only had 5 options (copy,paste,cut,freeze, something else). When I look at videos of people filtering data, one right click brings up a long list of options.
Any clue what I’m doing wrong?

submitted by hoosiertailgate22 to chromeos [link] [comments]

2024.05.21 15:54 njerejeje “Lindor only heats up when the Mets are out of it!”

I don’t know how this talking point among the anti-Lindor crowd became popular, but it is now the go-to argument whenever someone points out that Lindor has had objectively excellent numbers through his first 3+ years as a Met. “He sucks when the games matter and statpads when the Mets are eliminated making his numbers look good!!” But if you actually care to look into it(or, you know, think about it for more than 10 seconds), it’s flat out wrong for several reasons, which I’ll list below
1: The idea on its face is just absurd. Baseball players do not become more capable of hitting the ball just because of the standings position of the team they play for. I have legitimately never heard of any other MLB player who has been evaluated like this because it’s an insane way to evaluate players. If you’re going to make a claim as out there as this, you’re going to need some truly irrefutable evidence. Even if Lindor was legitimately a .600 OPS hitter until the Mets’ playoff chances dropped below 10%, then became a 1.000 OPS hitter after that, I argue it would still not show that he can’t plays worse BECAUSE the Mets are playing important games. And as it turns out…

2: We have a VERY large track record of Lindor having success in important situations as a Met. Take, oh I don’t know, the entire 2022 season, where he not only had the 2nd best offensive season by OPS+ in his career in a year where the Mets were in playoff contention all year, but had a .974 OPS in what baseball reference calls “high leverage situations”. Or the fact that as a Met overall, his OPS in high leverage situations is over .800.
Or the fact that even THIS season with terrible overall offensive production so far, he has a .800 OPS in “high leverage situations”. It’s actually the “low leverage situations” that he sucks in, with a .482 OPS. If the argument is that Lindor crumbles under pressure, this last stat sure seems to contradict that claim.

3: The entire basis for this argument came from last season, where Lindor had a .749 OPS through the end of June, before having a .866 OPS from July through September. But if you actually look at the breakdown by month, it gives more context to that. From June through September, he had an OPS above .800 in every single month. The Mets were, notably, in a good position mid-late June(where Lindor had a .816 OPS! Good offensive production in games that matter!). Even in July, the Mets were still not completely dead and there was still some hope of salvaging the season until the Robertson trade. The games still “mattered”, if that’s what you care about. And Lindor dominated in July, it was his best offensive month of the season with a .923 OPS.
I just find it extremely unlikely that the reason for Lindor’s better 2nd half is that he knew the Mets weren’t going to make the playoffs, knew that the games didn’t matter, and that somehow(?) caused him to be a significantly better hitter. A far more likely explanation is that he just had a bad month, as literally every MLB player does, and this bad month happened to be in May last year.
Also, I tried to avoid bringing up fWAR, but I couldn’t resist bringing up this little tidbit:
At the end of June last year, Lindor was 4th among shortstops in fWAR, and one of the people ahead of him was Wander Franco, so I’m making him 3rd. The “bad and unclutch” part of Lindor’s 2023 was STILL some of the best shortstop play in all of MLB.

Feel free to think what you want about Lindor, I can’t stop you. But PLEASE stop using this argument, it’s absurd both on its face and beneath the surface, and it makes me lose brain cells every time I see someone make it.

submitted by njerejeje to NewYorkMets [link] [comments]

2024.05.21 15:48 abjinternational Essential Microsoft Excel VBA: Learn VBA for become Expert

submitted by abjinternational to udemyfreebies [link] [comments]

2024.05.21 15:48 abjinternational Essential Microsoft Excel VBA: Learn VBA for become Expert

submitted by abjinternational to udemycoursedaily [link] [comments]

2024.05.21 15:48 abjinternational Essential Microsoft Excel VBA: Learn VBA for become Expert

submitted by abjinternational to FreeUdemyCoupons [link] [comments]

http://activeproperty.pl/