namespace NinjaTrader.NinjaScript.Indicators { public class StochasticSwing : Indicator { private Series den; private MAX max; private MIN min; private Series nom; private SMA smaK; private Swing swing; private List swingLowBars; private List swingLowPrices; private List swingHighBars; private List swingHighPrices; protected override void OnStateChange() { if (State == State.SetDefaults) { Description = "Stochastic Swing Indicator with custom swing point markers"; Name = "StochasticSwing"; IsSuspendedWhileInactive = true; PeriodD = 3; PeriodK = 9; Strength = 1; MaximumBarsLookBack = MaximumBarsLookBack.Infinite; AddPlot(Brushes.Cyan, "StochasticsD"); AddPlot(Brushes.Transparent, "StochasticsK"); AddLine(Brushes.Blue, 20, "Lower"); AddLine(Brushes.Blue, 80, "Upper"); DrawOnPricePanel = false; // Ensure drawing is done on the indicator's panel } else if (State == State.DataLoaded) { den = new Series(this); nom = new Series(this); min = MIN(Low, PeriodK); max = MAX(High, PeriodK); smaK = SMA(K, PeriodD); swing = Swing(D, Strength); swingLowBars = new List(); swingLowPrices = new List(); swingHighBars = new List(); swingHighPrices = new List(); } } protected override void OnBarUpdate() { if (CurrentBar < PeriodK) return; double min0 = min[0]; nom[0] = Close[0] - min0; den[0] = max[0] - min0; if (den[0].ApproxCompare(0) == 0) K[0] = CurrentBar == 0 ? 50 : K[1]; else K[0] = Math.Min(100, Math.Max(0, 100 * nom[0] / den[0])); D[0] = smaK[0]; // Clear previous swings swingLowBars.Clear(); swingLowPrices.Clear(); swingHighBars.Clear(); swingHighPrices.Clear(); // Collect all swing highs above 80 for (int i = Strength; i <= CurrentBar; i++) { int swingHighBar = swing.SwingHighBar(i, 1, int.MaxValue); if (swingHighBar != -1 && D[swingHighBar] > 80) { double swingHighPrice = D[swingHighBar]; swingHighBars.Add(swingHighBar); swingHighPrices.Add(swingHighPrice); Draw.Dot(this, "SwingHighDot" + swingHighBar, true, swingHighBar, swingHighPrice, Brushes.Red); } } // Collect all swing lows below 20 for (int i = Strength; i <= CurrentBar; i++) { int swingLowBar = swing.SwingLowBar(i, 1, int.MaxValue); if (swingLowBar != -1 && D[swingLowBar] < 20) { double swingLowPrice = D[swingLowBar]; swingLowBars.Add(swingLowBar); swingLowPrices.Add(swingLowPrice); Draw.Dot(this, "SwingLowDot" + swingLowBar, true, swingLowBar, swingLowPrice, Brushes.Green); } } // Connect swing lows with uptrend lines below 20 for (int i = 1; i < swingLowBars.Count; i++) { if (swingLowPrices[i] < swingLowPrices[i - 1]) { Draw.Line(this, "Uptrend" + i, false, swingLowBars[i - 1], swingLowPrices[i - 1], swingLowBars[i], swingLowPrices[i], Brushes.Green, DashStyleHelper.Solid, 1); } } // Connect swing highs with downtrend lines above 80 for (int i = 1; i < swingHighBars.Count; i++) { if (swingHighPrices[i] > swingHighPrices[i - 1]) { Draw.Line(this, "Downtrend" + i, false, swingHighBars[i - 1], swingHighPrices[i - 1], swingHighBars[i], swingHighPrices[i], Brushes.Red, DashStyleHelper.Solid, 1); } } } #region Properties [Browsable(false)] [XmlIgnore()] public Series D { get { return Values[0]; } } [Browsable(false)] [XmlIgnore()] public Series K { get { return Values[1]; } } [Range(1, int.MaxValue), NinjaScriptProperty] [Display(Name = "PeriodD", Order = 0)] public int PeriodD { get; set; } [Range(1, int.MaxValue), NinjaScriptProperty] [Display(Name = "PeriodK", Order = 1)] public int PeriodK { get; set; } [Range(1, int.MaxValue), NinjaScriptProperty] [Display(Name = "Strength", Order = 2)] public int Strength { get; set; } #endregion } } #region NinjaScript generated code. Neither change nor remove. namespace NinjaTrader.NinjaScript.Indicators { public partial class Indicator : NinjaTrader.Gui.NinjaScript.IndicatorRenderBase { private StochasticSwing[] cacheStochasticSwing; public StochasticSwing StochasticSwing(int periodD, int periodK, int strength) { return StochasticSwing(Input, periodD, periodK, strength); } public StochasticSwing StochasticSwing(ISeries input, int periodD, int periodK, int strength) { if (cacheStochasticSwing != null) for (int idx = 0; idx < cacheStochasticSwing.Length; idx++) if (cacheStochasticSwing[idx] != null && cacheStochasticSwing[idx].PeriodD == periodD && cacheStochasticSwing[idx].PeriodK == periodK && cacheStochasticSwing[idx].Strength == strength && cacheStochasticSwing[idx].EqualsInput(input)) return cacheStochasticSwing[idx]; return CacheIndicator(new StochasticSwing(){ PeriodD = periodD, PeriodK = periodK, Strength = strength }, input, ref cacheStochasticSwing); } } } namespace NinjaTrader.NinjaScript.MarketAnalyzerColumns { public partial class MarketAnalyzerColumn : MarketAnalyzerColumnBase { public Indicators.StochasticSwing StochasticSwing(int periodD, int periodK, int strength) { return indicator.StochasticSwing(Input, periodD, periodK, strength); } public Indicators.StochasticSwing StochasticSwing(ISeries input , int periodD, int periodK, int strength) { return indicator.StochasticSwing(input, periodD, periodK, strength); } } } namespace NinjaTrader.NinjaScript.Strategies { public partial class Strategy : NinjaTrader.Gui.NinjaScript.StrategyRenderBase { public Indicators.StochasticSwing StochasticSwing(int periodD, int periodK, int strength) { return indicator.StochasticSwing(Input, periodD, periodK, strength); } public Indicators.StochasticSwing StochasticSwing(ISeries input , int periodD, int periodK, int strength) { return indicator.StochasticSwing(input, periodD, periodK, strength); } } } #endregion 

LAPTOP QUESTIONNAIRE
• Total budget (in local currency) and country of purchase. Please do not use USD unless purchasing in the US:
Anywhere from 800-1500 USD
• Are you open to refurbs/used?
Yes but I would prefer something new
• How would you prioritize form factor (ultrabook, 2-in-1, etc.), build quality, performance, and battery life?
Ultrabook would be a nice luxury but I’m ok with a traditional laptop setup
• How important is weight and thinness to you?
I would really appreciate a thin laptop I don’t care too much about the weight
• Do you have a preferred screen size? If indifferent, put N/A.
Yes, 15 inches
• Are you doing any CAD/video editing/photo editing/gaming? List which programs/games you desire to run.
CAD
• If you're gaming, do you have certain games you want to play? At what settings and FPS do you want?
Won’t use this computer for heavy gaming
• Any specific requirements such as good keyboard, reliable build quality, touch-screen, finger-print reader, optical drive or good input devices (keyboard/touchpad)?
Yes. Good, tactile keyboard, 350+ nit display, good trackpad, able to charge through a usbc port
• Leave any finishing thoughts here that you may feel are necessary and beneficial to the discussion.
How important is a warranty going into college? Has anyone really needed to utilize their own warranties?

namespace NinjaTrader.NinjaScript.Indicators { public class StochasticSwing : Indicator { private Series den; private MAX max; private MIN min; private Series nom; private SMA smaK; private Swing swing; private List swingLowBars; private List swingLowPrices; private List swingHighBars; private List swingHighPrices; protected override void OnStateChange() { if (State == State.SetDefaults) { Description = "Stochastic Swing Indicator with custom swing point markers"; Name = "StochasticSwing"; IsSuspendedWhileInactive = true; PeriodD = 3; PeriodK = 9; Strength = 1; MaximumBarsLookBack = MaximumBarsLookBack.Infinite; AddPlot(Brushes.Cyan, "StochasticsD"); AddPlot(Brushes.Transparent, "StochasticsK"); AddLine(Brushes.Blue, 20, "Lower"); AddLine(Brushes.Blue, 80, "Upper"); DrawOnPricePanel = false; // Ensure drawing is done on the indicator's panel } else if (State == State.DataLoaded) { den = new Series(this); nom = new Series(this); min = MIN(Low, PeriodK); max = MAX(High, PeriodK); smaK = SMA(K, PeriodD); swing = Swing(D, Strength); swingLowBars = new List(); swingLowPrices = new List(); swingHighBars = new List(); swingHighPrices = new List(); } } protected override void OnBarUpdate() { if (CurrentBar < PeriodK) return; double min0 = min[0]; nom[0] = Close[0] - min0; den[0] = max[0] - min0; if (den[0].ApproxCompare(0) == 0) K[0] = CurrentBar == 0 ? 50 : K[1]; else K[0] = Math.Min(100, Math.Max(0, 100 * nom[0] / den[0])); D[0] = smaK[0]; // Clear previous swings swingLowBars.Clear(); swingLowPrices.Clear(); swingHighBars.Clear(); swingHighPrices.Clear(); // Collect all swing highs above 80 for (int i = Strength; i <= CurrentBar; i++) { int swingHighBar = swing.SwingHighBar(i, 1, int.MaxValue); if (swingHighBar != -1 && D[swingHighBar] > 80) { double swingHighPrice = D[swingHighBar]; swingHighBars.Add(swingHighBar); swingHighPrices.Add(swingHighPrice); Draw.Dot(this, "SwingHighDot" + swingHighBar, true, swingHighBar, swingHighPrice, Brushes.Red); } } // Collect all swing lows below 20 for (int i = Strength; i <= CurrentBar; i++) { int swingLowBar = swing.SwingLowBar(i, 1, int.MaxValue); if (swingLowBar != -1 && D[swingLowBar] < 20) { double swingLowPrice = D[swingLowBar]; swingLowBars.Add(swingLowBar); swingLowPrices.Add(swingLowPrice); Draw.Dot(this, "SwingLowDot" + swingLowBar, true, swingLowBar, swingLowPrice, Brushes.Green); } } // Connect swing lows with uptrend lines below 20 for (int i = 1; i < swingLowBars.Count; i++) { if (swingLowPrices[i] < swingLowPrices[i - 1]) { Draw.Line(this, "Uptrend" + i, false, swingLowBars[i - 1], swingLowPrices[i - 1], swingLowBars[i], swingLowPrices[i], Brushes.Green, DashStyleHelper.Solid, 1); } } // Connect swing highs with downtrend lines above 80 for (int i = 1; i < swingHighBars.Count; i++) { if (swingHighPrices[i] > swingHighPrices[i - 1]) { Draw.Line(this, "Downtrend" + i, false, swingHighBars[i - 1], swingHighPrices[i - 1], swingHighBars[i], swingHighPrices[i], Brushes.Red, DashStyleHelper.Solid, 1); } } } #region Properties [Browsable(false)] [XmlIgnore()] public Series D { get { return Values[0]; } } [Browsable(false)] [XmlIgnore()] public Series K { get { return Values[1]; } } [Range(1, int.MaxValue), NinjaScriptProperty] [Display(Name = "PeriodD", Order = 0)] public int PeriodD { get; set; } [Range(1, int.MaxValue), NinjaScriptProperty] [Display(Name = "PeriodK", Order = 1)] public int PeriodK { get; set; } [Range(1, int.MaxValue), NinjaScriptProperty] [Display(Name = "Strength", Order = 2)] public int Strength { get; set; } #endregion } } #region NinjaScript generated code. Neither change nor remove. namespace NinjaTrader.NinjaScript.Indicators { public partial class Indicator : NinjaTrader.Gui.NinjaScript.IndicatorRenderBase { private StochasticSwing[] cacheStochasticSwing; public StochasticSwing StochasticSwing(int periodD, int periodK, int strength) { return StochasticSwing(Input, periodD, periodK, strength); } public StochasticSwing StochasticSwing(ISeries input, int periodD, int periodK, int strength) { if (cacheStochasticSwing != null) for (int idx = 0; idx < cacheStochasticSwing.Length; idx++) if (cacheStochasticSwing[idx] != null && cacheStochasticSwing[idx].PeriodD == periodD && cacheStochasticSwing[idx].PeriodK == periodK && cacheStochasticSwing[idx].Strength == strength && cacheStochasticSwing[idx].EqualsInput(input)) return cacheStochasticSwing[idx]; return CacheIndicator(new StochasticSwing(){ PeriodD = periodD, PeriodK = periodK, Strength = strength }, input, ref cacheStochasticSwing); } } } namespace NinjaTrader.NinjaScript.MarketAnalyzerColumns { public partial class MarketAnalyzerColumn : MarketAnalyzerColumnBase { public Indicators.StochasticSwing StochasticSwing(int periodD, int periodK, int strength) { return indicator.StochasticSwing(Input, periodD, periodK, strength); } public Indicators.StochasticSwing StochasticSwing(ISeries input , int periodD, int periodK, int strength) { return indicator.StochasticSwing(input, periodD, periodK, strength); } } } namespace NinjaTrader.NinjaScript.Strategies { public partial class Strategy : NinjaTrader.Gui.NinjaScript.StrategyRenderBase { public Indicators.StochasticSwing StochasticSwing(int periodD, int periodK, int strength) { return indicator.StochasticSwing(Input, periodD, periodK, strength); } public Indicators.StochasticSwing StochasticSwing(ISeries input , int periodD, int periodK, int strength) { return indicator.StochasticSwing(input, periodD, periodK, strength); } } } #endregion 

LAPTOP QUESTIONNAIRE

• Total budget (in local currency) and country of purchase. Please do not use USD unless purchasing in the US:
  800€, Finland or web stores in other EU countries.
  
• Are you open to refurbs/used?
  Yes if it is possible to have one with good battery life.
  
• How would you prioritize form factor (ultrabook, 2-in-1, etc.), build quality, performance, and battery life?
  Good battery life is the top priority. The device will see travel use so good build quality is probably important. (I will use it in places such as hotels, trains and client offices, so no need for rugged outdoor model.)
  
• How important is weight and thinness to you?
  These would be nice if they can be achieved without losing battey life.
  
• Do you have a preferred screen size? If indifferent, put N/A.
  14"
  
• Are you doing any CAD/video editing/photo editing/gaming? List which programs/games you desire to run.
  No CAD/video editing or gaming. I will be using Teams/Zoom, Libreoffice, M365 web apps, IDE, lightweight vms and containers. I will also be programming with interpreted languages (no need for good compiling performance).
  
• If you're gaming, do you have certain games you want to play? At what settings and FPS do you want?
  N/A
  
• Any specific requirements such as good keyboard, reliable build quality, touch-screen, finger-print reader, optical drive or good input devices (keyboard/touchpad)?
  At least 16GB RAM and i5/Ryzen 5 level CPU. I will use Linux on this device so ability to buy the device without paying for Windows license would be nice. Good keyboard is also important as external keyboard is not available while travelling. Some level of robustness would also be good as travelling comes with physical strain to the device. HDMI port and and least one USB A and USB C port are needed.
  
• Leave any finishing thoughts here that you may feel are necessary and beneficial to the discussion.
  

A little over a year ago, I decided I wanted to read Guy Gavriel Kay for the first time. I don’t know why I knew it was the right time, I just did. I had been aware of Kay’s work basically since I began reading Fantasy, probably at least a dozen years ago now, and I had always planned to read him eventually.
For some reason, however, it just felt like it was time. I’m so glad I did.
So, after reading fifteen novels in about 13 months, here are my spoiler-free (some small spoilers will be covered) thoughts on each one. If you are a GGK fan, I would love to hear your thoughts and favorites as well.
And if you’ve never read him before, I hope you will take the leap!

• The Fionavar Tapestry (1984-1986): The first thing to know about these three novels (The Summer Tree, The Wandering Fire, and The Darkest Road) is that they are not very representative of the rest of Kay’s work, which is mostly Historical Fantasy. Fionavar, however, is 100% High Portal Fantasy. It tells the story of five Canadian graduate students who are transported into a fantasy world and tasked with saving it. Many readers like to compare the series to Tolkien (largely because a young GGK famously interned with Christopher Tolkien) but I disagree. It is much more 'Narnia meets A Song of Ice and Fire'. Beautifully written, but also containing quite a lot of adult content, politics, and a heavy dose of mythology. I enjoyed it quite a bit, but if you don’t like it that does not mean you won’t like other Kay books.
• Tigana (1990): Perhaps Kay’s most famous and well-regarded novel, and also the first time he began tinkering with his now well-known style of writing a history-adjacent story. Tigana is set in a place very reminiscent of medieval Italy, where two sorcerers are battling over both the land and the hearts of the people who live there. While the writing is a step up from Fionavar, I did find it a touch over-dramatic at times, with characters that are not all as fleshed out as I would like. Where the book excels, however, is in its themes - Memory, Loss, Colonialism vs Patriotism, and more. It's fascinating and well worth your time.
• A Song for Arbonne (1992): Shifting from Kay’s most well-known novel, we now have probably his most underrated and under-discussed. A Song for Arbonne is set in a fictional version of Provence, France during the high Middle Ages and follows a feud between two dukes and two very different ways of life. This is a beautifully feminist novel (especially for 1992) and also made me love troubadours, which is not something I ever thought I would say. Highly recommended, especially in audiobook.
• The Lions of Al-Rassan (1995): My favorite Kay novel, and one I will unabashedly gush about for the rest of my life. Set in a fictional version of Spain during the Crusades, we follow three characters – a Kindath (Jewish) woman doctor, a Jaddite (Christian) military leader, and an Asharite (Muslim) Poet/Diplomat. These three very different people from very different backgrounds are thrust together amid absolute turmoil and form a bond that defies and transcends cultures. It absolutely broke my heart when I read it, but somehow also made me as hopeful as any book I had ever read before. This book is perfect. Read it.
• The Sarantine Mosaic (1998-2000): This two-part story is set in the same world as The Lions of Al-Rassan, but many centuries earlier and hundreds of miles to the east. We follow a young mosaicist named Crispin who is unexpectedly pulled from his obscure country life and tasked with traveling to Sarantium, the greatest city on Earth, to build a new cathedral for the Emperor. Along the way, he meets many incredible side characters and witnesses the empire experience huge amounts of change. This is another favorite, and is far and away Kay’s most epic story. If you like Gladiator or Spartacus, you’ll love this. Plus it has chariot races!
• The Last Light of the Sun (2004): A Viking novel set in the same world as the last two. Shares many of the same themes and ideas of the previous novels as well – people from different cultures coming face to face with modernity and changing times. It’s a very good novel, especially if you enjoy Vikings, but a step down for me.
• Ysabel (2007): Probably far and away Kay's most unique book. It’s a modern, YA novel set in Provence. We follow a young teenage Canadian boy who goes on a work trip with his photographer father and gets swept up into a mystery involving some of the artifacts and other historical sites there. This book is also loosely connected to Fionavar. I enjoyed this one more than I thought I would, but it was still a bizarre experience compared to literally everything else Kay has written.
• Under Heaven (2010): Kay now turned his sights to ancient Chinese history, specifically 8th Century Tang Dynasty. Like his other stuff, though, this is not actually historical fiction - it's set in another world with different names, etc. The son of a renowned general is given 250 prized horses as a gift for his work burying the dead from both sides of a large battle. This outlandish gift forces the young man to become embroiled in the politics of the empire and allows him to witness a startling change to his people's way of life. Lots of people LOVE this book - many even list it as their favorite of Kay's. It did not resonate with me the same way. It's very good! But not my favorite.
• River of Stars (2012): A pseudo-sequel to Under Heaven, set about 500 years later in an era largely defined by the events of that previous novel. Whereas in Under Heaven Kitai (Kay's version of China) was an up-and-coming military power, in River of Stars it has become a wealthy, arrogant cultural hub that is seemingly unaware of its instability. We follow quite a few different characters from multiple backgrounds in this one and, like so many Kay stories, get to see large events take place through the eyes of these 'small' characters. I imagine that whatever your feelings were/are for Under Heaven, you will feel mostly the same about River of Stars.
• Children of Earth and Sky (2016): Kay returned to his 'Jaddite' world for the first time since 2004 for this novel, and (for this reader at least), it was a joy! It takes place about 1,000 years after the Sarantine Mosaic, in a world where the great city of Sarantium has fallen to the Asharites and the surrounding world is trying to pick up the pieces. It's a time of a lot of upheaval and turmoil. This novel follows quite a few very diverse POV characters, which (while sometimes confusing) gives it an 'epic' feel. We have artists, traders, military leaders, sea captains, pirates, and more. While I would not necessarily suggest this as your first GGK novel, if you are a fan of the Sarantine Mosaic (and to a lesser extent, The Lions of Al-Rassan), you will find MUCH to love here.
• A Brightness Long Ago (2019): Taking place about 25 years before the events of Children of Earth and Sky, A Brightness Long Ago perfects Kay's most notable theme: The effect that small, 'unimportant' people can have on huge, global events. We follow a young man named Guidanio, the son of a common tailor, who is swept up into a local feud between two legendary mercenary captains. In the process, he falls in love, faces unspeakable tragedy, and eventually witnesses the fall of the greatest city on earth. What sets this book apart from other Kay novels is that it is mostly told in 1st Person POV by a much older Guidanio in the form of his life story. It is one of Kay's most intimate and best-paced books, and although I still don't think it matches his peak, A Brightness Long Ago is certainly his best novel of the 20th Century and proof that he is still a master of his craft. Highly recommended!
• All the Seas of the World (2022): Kay's most recent novel is both a sequel to A Brightness Long Ago, and a prequel to Children of Earth and Sky. As such, I will not go into a ton of detail but suffice it to say that if you enjoyed those two novels you will love this one. It's a separate story, but there is enough overlap and easter eggs to keep your attention. While I would not rate it higher than A Brightness Long Ago, it was once again a great read and certainly worth your time.

So there we have it! Fifteen novels in just over a year. I'm not sure binging his work is the best way to enjoy Kay, but I still had a great time and plan to reread many (if not all) of these books again someday.
Guy Gavriel Kay is a master, and his work should be cherished. I'm a fan for life!

Hi, I’m looking for the English dub for the brazillian cartoon “Zica e os Camaleões” (Zica and the Chameleons). It was aired and licensed by Nickelodeon Brazil in 2014, and TV Brasil from 2014 to 2017.
"Zica is a 14-year-old teenager who feels black and white in a colorful world. Zica seeks to assimilate the transition period she is experiencing through her art: she draws, writes and composes songs with her band formed with her best friend Gui and drummer Batata. When she is alone in her room, she usually talks and reflects with her three pet Chameleons. The episodes are divided between the "real world" in which she lives, the "creative world" that takes place in her room, and a video clip at the end of every episode." (Translated from the portuguese Wikipedia article about the show).
A fully dubbed episode 7 along with an english promo for the show was posted on the official Vimeo account for Cinema Animadores, the production company for the show. You can find those here and here. I couldn’t find any info about the voice actors or the company.
More info: The show was created after a short pilot aired on Anima TV 2010, a brazillian project organized by the government focused on highlighting and producing brazillian animations. There’s a brazillian article that mentions that the show was featured in an online version of a "Variety" magazine. Its official international release was done after MIPCOM in 2015, a french event to buy and sell new television shows for international distribution. (all info taken from the portuguese Wikipedia page)
It didn’t have a huge reception in Brazil as far as I’m aware (most people say it got cut short because of that), so it’s probably lost to time. I’ve tried e-mailing the production company for the show about it, still waiting for a response.
Sorry if some information is vague or worded weirdly, English isn’t my first language and it’s hard for me to understand some of this. And sorry if this is formatted incorrectly or doesn’t belong here, I’ll edit or take it down if needed! Thank you!

I’ve been using HoneyBook for about one year now. I originally picked it because of the ease of use but, as business ramps up, I’m finding HoneyBook is not offering very basic things. (And I could be missing something, so point it out if I am).
In a nutshell, my company offers three services at varying price points with a few add-ons. After the client purchases their package, they’ll fill out a form to give me more info on the project. I’ll forward that form to my associates and they’ll complete work on the project. I use Zapier currently to export basic HoneyBook project info like the clients name, email, project date, etc. into my database but my issue is- I’m not able to automatically export the services purchased OR any of the answers on the form to any sort of spreadsheet/database/project management tool. I have to enter this info manually.
This wouldn’t be an issue if it didn’t take 8 clicks to get to the services purchased page and 3 more clicks to get into the clients form. Details also change so I end up having to go through this multiple times and things are beginning to pile up.
I know HoneyBook offers its own project management tool where I can invite employees into each project but it’s even clunkier than my zaps. Also, once someone enters a project most everything is visible to them (I want to keep invoicing separate from my associate contractors). Also, I don’t want to have to educate my associate contractors on HoneyBook- I’d rather they just be able to use their email, calendar and/or a spread sheet. Lastly, there are some really cool project management tools out there that’ll make my life easier that I’d like to use.
Have any HoneyBook users come up with a solution to this- Help me out pls!

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.

Hi!
A new major release of DaDaBIK is out (founder here) and I think this might be of interest to this subreddit.
V. 12 brings, among other new features:
🚀 A new Graphical User Interface for generated apps, addressing what some users saw as the main limitation of DaDaBIK. New, modern, look and feel.
🔄 The new BETA development mode, that allows to privately (admins + trusted users) test your changes and custom code in BETA mode and deploy them LIVE in one click, optionally using two separated (Beta Vs. Live) DBs.
👩‍💻 AI-Powered App Building: simply describe your app in plain English and let AI create it, then refine your app with DaDaBIK.
💾 Export your app in one click
A quick overview, if you are not familiar with DaDaBIK: it has been a pioneer in the low-code and no-code space since 2001, being one of the very first no-code low-code Web platform, typically used for internal tools, business process automation, online databases.
Users include individuals, small and large business and many universities.
Some of the main features:

• Build advanced CRUD on top of your database without coding
• Inline editing (spreadsheet-like)
• Charts, tabular reports and dashboards (simple, no-code or complex, custom, SQL-based)
• Advanced permissions model: set granular permissions for each field / user group pair, owner permissions (e.g. I can see only the records I created), custom row-level filters
• Revision / audit features: Track who modified a record, when, and how.
• Export to PDF (with custom templates, if needed)
• 23 languages available

You can also add your own PHP / Javascript code, if needed, through a unique low-code integration approach. This includes custom buttons, hooks, custom validation functions, calculated fields, custom PHP pages and more. Your code remain completely separated from the DaDaBIK core code but fully integrated with the application, you can use vanilla PHP / Javascript and/or take advantage of the DaDABIK API.
No artificial limits on users, tables, records: if you need to scale, just power up your server.

Integration capabilities:

• Host anywhere the app, host anywhere the DB, no data vendor lock-in
• MySQL, PostgreSQL, MS SQL Server, SQLite supported
• Import (and synch) data from Excel and CSV
• LDAP authentication
• HTTP API (login and query DaDaBIK from other applications)
• Export to CSV
• Embed in a Wordpress site and share authentication with WP
• Full access to the database from other apps (DaDaBIK, by default, doesn't touch the schema of your existing DB, if any)

Licensing Options:

Both lifetime and monthly subscription licenses are available. You can start your free trial at dadabik.com/download
If you want to see DaDaBIK in action, here are some apps created with it: dadabik.com/demo
Any feedback is welcome, thanks!
Eugenio

Hi! Details below but the TL;DR is basically the subject line.
I have a combination of undergrad and graduate loans that I consolidated in July 2022 under the Limited PSLF Waiver, as I had an FFEL loan and old periods of qualifying PSLF employment attached to the undergrad loans that I wanted to apply to the graduate loans. On 3/6/24, I submitted a PSLF Employment Certification form for an old qualifying employer, for the dates of 3/2010 through 8/2010. The 6 new payments would have brought the loans to 100 qualifying payments. However, MOHELA erroneously entered the employment dates into the system as 03-01-2010 through 03-06-2024 (using not the employment end date but the date the form was signed/processed), causing the loans to show that they had 14 years of qualifying employment instead of just the additional 6 months attested to on the form. I called MOHELA on 3/7 to attempt to correct this mistake as soon as I noticed it. After a few weeks and many more calls and secure messages, MOHELA corrected the error. Unfortunately, the few weeks in which the loans falsely showed they had over 120 qualifying payments triggered forgiveness on 4/6. I immediately called MOHELA again to attempt to correct the false forgiveness. They placed my account in an administrative forbearance through June and told me I now have to wait for ED to return the loans to their former status. They said they have no sense of or control over the timeline, but that their best guess is that the loans will be reinstated when I am transitioned to be managed through StudentAid.gov during the processing pause.
This has all been incredibly frustrating (to say the least), but an additional wrinkle is that I just graduated from law school and have two graduate loans moving into their grace period that I would love to consolidate into the existing loans before the IDR waiver opportunity ends on 6/30.
So, I am turning to you, my PSLF heroes, for advice - is there anything you recommend I do to attempt to get the loans reinstated in time for the IDR waiver consolidation opportunity? Submit a complaint with FSA? Contact the ombudsman? Find religion? Any and all help is deeply appreciated.

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:

1. In the table on the right, the Quarter row must match the Start Date column for each listed market.
2. If I change the Start Date, the output also has to match the new Start Date
3. When the quarters match, the first input should always be the value in Starting Members/Market.
4. The maximum value that number hits should match the column Max Members
5. 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
6. 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

TLDR: Which handheld to choose Asus ROG Ally or Steam deck Oled.
Hello There! My birthday is coming up in a few days, and so I decided to gift myself a little something in the form of a handheld gaming PC. But like for most other buyers in this category, the question persists. Which one? The polished steam deck OLED or the powerhouse Asus ROG Ally.
Now a few things to keep in mind, I don't really mind the OS of the Ally being windows. In fact it's one of the things that's drawing me to it. And this handheld will be my chief gaming device because I have a MacBook which I use for college stuff and other browsing. So the battery being drained faster isn't an issue either as at home, I'll used it plugged into a monitor and power and while using it during my commute to college hit should be fine as it's only an hour.
It would have been a straight win for the ROG, but I had a few questions. Does the SD Card issue persist still? Have any owners faced issues. I have used a steam deck before and while the UI is beautiful and slick, the extra power the ROG offers at the same price point is drawing me towards it. What do you guys think? Thank you so much for your input :)

Season: 89-71-1
Yesterday: 1-1
CIN +1.5 (0.5 unit): San Diego faces a tough situation after a day/night doubleheader in Atlanta and losing Xander Bogaerts to a shoulder injury. They also have travel fatigue and Joe Musgrove, coming off the injured list, has struggled with a 6.37 ERA. In contrast, the Reds are well-rested and their pitcher, Andrew Abbott, has been strong, allowing more than two earned runs only once this season.
LAD ML: Gavin Stone, set to pitch tonight, has been in excellent form lately, consistently allowing just one earned run in each of his last four starts. The Diamondbacks will face him for the first time, which could work to Stone's advantage. On the other side, Arizona's Brandon Pfaadt brings a 4.70 road ERA into the game, and some Dodgers hitters have performed well against him, albeit in limited at-bats.
Please consider supporting Battle of the Bets

Hi, I´m looking for a Laptop that is 55% uni 30% for browsing and Netflix and 15% for slight Gaming at my Parents' place (Tabletop simulator, Minecraft with light mod packs, LoL on low settings, and running ultimate cura)
Total budget (In local currency) and country of purchase:

• max 700€ preferred550€

Are you open to refurbs/used?

• yes, pls

How would you prioritize form factor, build quality, performance, and battery life?

• 13" to 15", durable for travel, battery life for 4-6 h of watching Lectures and taking notes
  Do you have a preferred screen size? If indifferent, put N/A.
  
• 14"
  Are you doing any CAD/video editing/photo editing/gaming? List which programs/games you desire to run.
  
• CAD for Ultimate cura, vs code, Minecraft modpacks, tabletop simulator, Lol on low settings
  Any specific requirements such as good keyboard, touch-screen, finger-print reader, optical drive or good input devices (keyboard/touchpad)?
  
• touchscreen, not a cheep Keyboard, USB-C (charge via 65w)
  

Please comment before sending a PM. Chats and messages without comments will be ignored. Open to reasonable offers, so if you are interested in something, feel free to send me a message. Discounts offered for purchasing multiple items.
Please PM with any questions. Thanks for reading.
Click here to send a PM

Item	Condition	Notes	Local, Shipped
MSI 4080 Gaming X Slim White	Open Box - Excellent	Open box card in like new condition, briefly tested to verify functionality. Original box has minor damage, but card is in pristine condition. Original box, 12VHPWR adapter, and support bracket included.	$975, $1,000
ASUS ProArt 4080 Super OC	Open Box - Excellent	Card is new, briefly tested to verify functionality. Smallest 4080/4080 Super card, making it an excellent choice for Small Form Factor builds.	$1,025, $1,050

Note: I have several items on my previous post still available as well, in case anyone's interested.

https://preview.redd.it/fl9go0ov2t1d1.jpg?width=1275&format=pjpg&auto=webp&s=66578efbae8293cea12625a10be65465b64e0b07

I had arrived in Kyoto, I'd already picked out a plush apartment in Kameoka, a stones throw from the Oi River and Sanga Stadium. I introduced myself to the squad and advised them that my 'score many goals and hope to concede less' tactic would be the one to fire us back up the league into a semi-respectable position and away from the relegation zone.
However, that would have to wait as we started my tenure at Kyoto Sanga in the Emperor's cup 2nd round against J2 side Tokyo Verdy, a team who had already bested me this season when I was still at Fukushima this time though I would have the last laugh as we won 4-2 even with me giving starts to youth prospects Sunao Maekawa and Fugo Kozuka, now, would my tactics translate to league success? JEF United Chiba were not charitable though as they won 2-1 after Yuya Yamagishi got himself sent off 16 minutes in. My cries of 'Get stuck in' taken too literally.
Due to the way the Japanese league and cups are played July only saw us playing 2 Emperor's Cup games and nothing else. It was the 3rd round tie that really showed my Score One More philosophy come to to the front. Vegalta Sendai where the opponents and they wanted goals and boy howdy did they get them, we however, set the pace. Goals in minutes 3 and 6 from Sunao Maekawa was followed by them pulling one back after 10 to make it 2-1. Ryotaro Nakamura revived our 2 goal lead in the 13th minute before Vegalta scored a penalty in the 26th minute then equalised in the 50th. Komai restored our lead in minute 72 and Teppei Yachida extended it, meaning with 5 minutes to go we were 5-3 up. Unfortunately Vegalta Sendai didn't like the idea of us winning and with goals in minutes 90+2 and 90+5 we went to extra time. We scored after a minute, Toru Hayashi (great name by the way) got us off to a good start before, once again, we conceded our lead. However, after minute 109 Shoma Otoizumi put us ahead and this time it stuck. We finally pushed ourselves into the 4th round with a 7-6 win. I needed a holiday.
We then easily got past Kashiwa Reysol in the 4th round with a 4-1 win. We then went on a 6 game unbeaten run in the league with only 1 draw as we found our form. Our first loss in that run was a 3-1 defeat to Kashiwa Reysol, enacting a measure of revenge for the Emperor's cup drubbing. that does make it 5-4 on aggregate over those 2 games, so who's the real winner? After that loss, with only 7 games in the league remaining we went undefeated, a few draws were thrown in there, including 3 in a row to end the season meant we ended up in 9th place an excellent result considering I had taken over in mid-June in the relegation zone.
But what of the Emperor's cup? Well, We hit the semi-finals against FC Tokyo, and we hit them hard. Winning 5-1 Komai scoring 2 more and earning himself the nickname Komai Can't Communicate (But he can score) Eventual J1 champions Vissel Kobe awaited us in the semi finals. Komai and friends once again showed what they're about and fired us to a 4-0 win setting up my first chance at a cup final and a place in the Japan National Stadium against Hokkaido Consadole Sapporo. In a cagy affair with little to no highlights, our hearts were broken when Daihachi Okamura scored the only goal of the game in the 61st minute to give us a silver medal and a fire in our bellies to go again next season and hopefully go one better.
This counts as success

Would you be able to say stuff like "Open firefox and go to facebook", then "text Aria happy birthday "; fill out forms online using vocal commands as input and such?