#Learn Excel for Data Analysis

[tccicomputercoaching]

What are the 5 main functions of Excel?

When exploring what are the 5 main functions of Excel, it’s clear that this powerful spreadsheet application dramatically enhances the productivity of students, professionals, and business owners alike. TCCI-Tririd Computer Coaching Institute aims to help students and working professionals improve their Excel skills for career benefits.

1. Data Entry and Management

A simple, systematic means of data entry, organization, and management of huge amounts of data is provided by Excel. Users can fill out cells with numbers, text, or dates and present that cell information in some system in rows and columns. The management of complex datasets is made easier through such functions, like data validation, sorting, and filtering.

2. Data Analysis and Representation

Excel's ability to analyze data with the use of pivot tables, charts, and graphs is one of its most powerful functions. Charts such as bar, pie, line, and scatter can be created by users to present data trends and insights, thereby enhancing the value of their reports and presentations.

3. Mathematical and Logical Calculations

A wide range of built-in mathematical, statistical, and logical functions are provided in Excel, such as:

SUM()- Adds values in a range.

AVERAGE() - Computes the average of the numbers selected.

IF() - Is used for logical operations that depend on conditions.

VLOOKUP() & HLOOKUP() - Looks for values inside a table.

4: Data Formatting and Customization:

 Excel provides a number of features to format its presentation of data, including:

When conditional formatting can be applied, set specific values to be highlighted;

Cell formatting options (bold, italics, colors);

Be able to adjust column and row width/height for easier reading.

All of these elements will enhance the appearance and tidy presentation of data.

5. Automation with Macros and Formulas

With macros and VBA (Visual Basic for Applications), processes can be automated for tasks that are repetitive. Recording macros can help users automate the repetitive tasks, thus improving their efficiency. On the other hand, complex formulas and functions can be set for tasks requiring calculations and immediate results.

Learn Excel at TCCI-Tririd Computer Coaching Institute

TCCI offers a complete Advanced Excel training course designed to make students and professionals well versed in these important functions. Whether you start as a beginner or semi-expert, you will find assistance in lots of practical training to enhance your Excel skills from our expert trainers.

So why wait? Master Excel through TCCI-Tririd Computer Coaching Institute and uplift your career with one of our specialized Excel courses!

Location: Bopal & Iskon-Ambli Ahmedabad, Gujarat

Call now on +91 9825618292

Get information from: https://tccicomputercoaching.wordpress.com/

[farmerstrend]

What Makes a Great Agronomist? Unpacking the Traits of Agricultural Excellence

Agronomists are the unsung heroes shaping the future of farming. They’re the bridge between science and soil, the architects of abundance in a world hungry for both food and sustainability. Over the years, after sifting through hundreds of agronomist resumes and meeting countless professionals in this field, I’ve come to realize that greatness in agronomy isn’t just about a degree or a title.…

[carrernext]

Learn Advanced Excel for Data Analysis | Master Data Skills with Excel

Unlock the full potential of Microsoft Excel by learning advanced Excel skills specifically tailored for data analysis. This course is ideal for professionals, students, and analysts who want to move beyond basic spreadsheets and gain hands-on expertise in data manipulation, pivot tables, advanced formulas, data visualization, and automation using Excel. Learn how to analyze large datasets, create insightful dashboards, and make data-driven decisions with confidence. Through practical examples and real-world exercises, you'll master tools like Power Query, Power Pivot, conditional formatting, and advanced charting techniques. Whether you're in finance, marketing, operations, or any data-driven field, learning advanced Excel for data analysis will enhance your productivity and open doors to new career opportunities.

[pythonjobsupport]

Top 8 Data Analysis Excel Tools ~ You Should Learn | Excel data analysis

Here You Learn Top 8 Data analysis tools in excel | Data analysis in excel | What is data analysis in excel in hindi Data analysis … source

[mohalicareerpoint12]

Master Advanced Excel with the Best Classes in Mohali

Are you looking to enhance your Excel skills and take your data analysis capabilities to the next level? You've come to the right place if you're in Mohali and searching for the best advanced Excel classes. Our advanced Excel training in Mohali is designed to provide comprehensive knowledge, practical skills, and expert guidance to help you become an Excel pro.

Why Learn Advanced Excel?

Excel is a powerful tool widely used in various industries for data analysis, financial modeling, reporting, and more. Mastering advanced Excel functions can significantly improve your efficiency and productivity. Here are a few reasons why you should consider learning advanced Excel:

Enhanced Productivity: Advanced Excel skills can save time by automating repetitive tasks and simplifying complex data analysis.

Data Analysis: Excel's advanced features allow you to perform detailed data analysis, making it easier to make informed decisions.

Career Advancement: Proficiency in advanced Excel is a valuable skill that can enhance your resume and open up new job opportunities.

Versatility: Excel is used in various roles, including finance, marketing, human resources, and project management.

About Our Advanced Excel Classes in Mohali

Our training center in Mohali offers top-notch advanced Excel classes tailored to meet the needs of professionals and students alike. Here’s what sets our classes apart:

Experienced Instructors: Learn from industry experts who have extensive knowledge of advanced Excel functions and applications.

Hands-on Training: We emphasize practical learning with real-life scenarios and hands-on exercises to ensure you gain practical skills.

Flexible Timings: We offer flexible class schedules, including weekday and weekend batches, to accommodate working professionals and students.

Modern Facilities: Our state-of-the-art training center is equipped with the latest technology to provide a conducive learning environment.

Career Support: We provide placement assistance and career counseling to help you find the right job after completing the course.

Course Highlights

Our advanced Excel course covers all essential topics and advanced functions, ensuring you become proficient in its use. Here are some of the key highlights:

Advanced Formulas and Functions: Learn to use complex formulas and functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, and more.

Data Analysis Tools: Master data analysis tools like PivotTables, PivotCharts, and Data Tables to summarize and analyze large datasets.

Conditional Formatting: Understand how to use conditional formatting to highlight important data and trends.

Macros and VBA: Get hands-on experience in automating tasks using Macros and Visual Basic for Applications (VBA).

Data Visualization: Learn to create advanced charts and graphs to visualize data effectively.

Advanced Data Management: Gain skills in data validation, data cleaning, and working with large datasets.

Scenario Analysis and Forecasting: Understand how to perform scenario analysis and create financial forecasts using Excel.

Conclusion

Learning advanced Excel can significantly enhance your data analysis skills and career prospects. Our advanced Excel classes in Mohali offer expert instruction, hands-on training, and comprehensive career support to help you achieve your goals. Join us today and unlock the full potential of Excel!

[excelhelps]

How to use Every available Chart in Excel

[astrologydray]

♊️Gemini Mc in the each of the degrees🎭

If you have a Gemini Midheaven (MC), your career and public image are influenced by Gemini’s themes of communication, versatility, and intellectual curiosity. You may thrive in fields involving writing, media, technology, teaching, or sales.

• 0° Gemini (Gemini Point) – A natural communicator and intellectual. Could excel in media, journalism, or public speaking.

• 1° Gemini – Highly curious and adaptable. May pursue multiple careers or work in fast-paced industries.

• 2° Gemini – An engaging storyteller; could thrive in writing, publishing, or broadcasting.

• 3° Gemini – A quick thinker with a sharp mind. Prefers intellectually stimulating careers.

• 4° Gemini – Strong networking abilities. Success comes from making the right connections.

• 5° Gemini – A master of multitasking. Likely to have a career with variety and movement.

• 6° Gemini – Drawn to education, research, or public relations. A natural teacher or speaker.

• 7° Gemini – A witty and persuasive communicator; may succeed in sales or advertising.

• 8° Gemini – Talented with words. Could excel in writing, copywriting, or language-based work.

• 9° Gemini – A restless and curious mind. May struggle with career stability but excels in learning.

• 10° Gemini – Highly sociable; could be a media personality, influencer, or journalist.

• 11° Gemini – Gifted in technology or digital communication. Could work in social media, IT, or AI fields.

• 12° Gemini – Strong intuition for trends and information. Could thrive in consulting or marketing.

• 13° Gemini – A strong need for intellectual independence. Prefers freelance or flexible career paths.

• 14° Gemini – Charismatic and persuasive; a great public speaker or negotiator.

• 15° Gemini – Quick-witted and sharp. Could thrive in legal work, politics, or academia.

• 16° Gemini – Adaptable but needs to focus on long-term career goals. May switch jobs frequently.

• 17° Gemini – A highly creative mind. Could excel in advertising, writing, or entertainment.

• 18° Gemini – A gifted mimic. Could be successful in acting, voice work, or linguistics.

• 19° Gemini – Intellectually restless; needs a career that keeps them mentally engaged.

• 20° Gemini – Naturally persuasive and influential. Could thrive in leadership or media roles.

• 21° Gemini – Highly analytical; may be drawn to careers in data analysis, research, or science.

• 22° Gemini – A master of adaptation. Could work in multiple fields or juggle side hustles.

• 23° Gemini – A strong love for debate and discussion. May be drawn to law or philosophy.

• 24° Gemini – A creative storyteller. Success in journalism, screenwriting, or podcasting.

• 25° Gemini – Exceptionally sharp and quick-thinking; could be drawn to stock trading or strategic consulting.

• 26° Gemini – A love for teaching and sharing knowledge. Could be a professor, coach, or mentor.

• 27° Gemini – Highly independent; prefers self-employment or careers with autonomy.

• 28° Gemini – A media-savvy individual. Likely to gain public recognition through words or ideas.

• 29° Gemini (Anaretic Degree) – A master communicator with an intense drive for knowledge. Could become famous for their intellect, writing, or public speaking. However, they may struggle with indecision or restlessness in their career path.

[mi55delulu]

[5:38 p.m.]

pairing: team lead!jungkook x hr lead!fem reader

wc: 1.7k

genre: coworkers au, FLUFF!!

cw: corporate lingo (shivers), sfw, jk being a cutie patootie, oc lowkey oblivious but we love her.

a/n: yeaaaah i kinda went over the typical 1k word count with this timestamp drabble. but hey, this is my february contribution. isn’t the banner super cute???? anyways, enjoy!

You had a strict routine.

Wake up at 7:20 a.m., out the door by 7:45 a.m., shuttle to work by 8:15 a.m., and the rest was history till it’s time to clock out at 5:00 p.m. Rinse and repeat until the weekends hit.

Being the lead for your little team of five had its perks. You never had to do any of the grunt work minus project managing and individual check-ins with your team members. Things were easy because you worked with some of the most competent employees.

Human Resources was one of the fields people strayed away from due to their bad rep on upholding the company’s interests and values first. It’s true. You love your work though. You love that there’s a solid beginning and end to your job. Someone was always hiring and someone was always applying. Someone always had a personnel issue and someone was there to fix it.

There was always a resolution.

Let’s be real — not everything was a happy resolution. You worked by the books and as a result, you’ve had to make some difficult calls. As the team lead, you’ve taken upon yourself to be the bearer of bad news. Just like how you’re on a Teams call right now with Jeon Jungkook, lead of the Data Analysis & Corrections team. It’s a group meeting between you, him, his manager, and your team member to break the news that a promotion in place for one of his team members was not approved.

“Again, I do apologize, but even with the justification memo, the budget cuts for this quarter won’t allow for another promotion in place. The team member hasn’t reached their second probation either—“

“Yes, but we’re trying to retain talent in our unit. I have another two that already accepted firm offers for another company. I’m down to my last two team members, and if I don’t offer some sort of incentive to stay, work is going to pile up and we’re not going to meet our service level agreements.” Jungkook adjusts his headset. This wasn’t your first rodeo with Jungkook. He’s always been an advocate when it came to his team, which was why his team members always excelled and promoted after a year in their position. You admired him for his persistency … until it gets escalated to a meeting like this.

“Have you considered reaching out to other teams for assistance? Perhaps we can redirect a couple folks over for temporary assistance.” You offer.

His manager takes over the meeting to give his take on the decision. You zone out. Mute button on to hide the sigh you let out. Unlike Jungkook, his manager had a way of steamrolling and derailing a meeting. One skill you’ve learned in your role is to let the other person talk. If you don’t contribute, they will eventually run out of things to say.

Jeon, Jungkook [4:48 p.m.]: what are you doing on 2/14?

You [4:48 p.m.]: Work. It’s a Friday.

Jeon, Jungkook [4:50 p.m.]: oh ok

You react to the Teams message with a thumbs up and refocus on the call where Jungkook’s manager continues his rambling.

Jeon, Jungkook [4:55 p.m.]: your hair is pretty btw. is that a new necklace?

You [4:55 p.m.]: Flattery won’t change the outcomes of this meeting, Jungkook.

Jeon, Jungkook [4:56 p.m.]: aw, can’t say i didn’t try …

You stifle a smile. Eyes avoid the part of the screen where Jungkook smiles back dumbly. Certainly it was no smiling matter now that the call has gone over the allotted time and it’s past your typical clock out time when you interrupt his manager. It was for your team member’s sake since they were paid by the hour. Being a team lead, you were technically always on the clock. But again, you had a strict routine — out by 5:00 p.m. and this was well past your work schedule.

“We can table this for another time. I’ll put something on the calendar later this week.”

“If it’s not to approve the promotion, then I don’t see the need in the meeting.” His manager sighs.

“I’ll meet on our behalf, if it’s alright with you,” Jungkook says to his manager, “I’d like to discuss some alternatives.”

His manager waves him off and thanks everyone for their time before signing off the meeting. Jungkook apologizes to you with a tight-lipped smile.

—

He gives you the same one later on that evening when it’s just you and him waiting for the parking shuttle. Tie loose and hair no longer gelled up like it usually is in the morning, Jungkook stands next to you in silence.

“Sorry for going over the meeting time.”

“Not your fault,” you don’t look up from your phone, too busy typing out your grocery list, “just don’t include your manager in the call next time.”

You know it’s not his call to make. As great as a leader Jungkook is to his team, he’s only as great as he could be under a micromanager. Doesn’t have the heart to leave his team, but also doesn’t deserve that sort of treatment from his manager. You’ve hinted this to him plenty of times in the past. Sure, you recognize that any decision or advice given in your role needs to be in the best interest of the company. But Jungkook was an integral part of the company and taking care of an employee’s wellbeing was a part of your job too.

“Yeah, sorry about that,” he apologizes again, “you know how he is.”

You nod and step forward when the shuttle pulls in.

With plenty of open seats to choose from, Jungkook chooses to sit next to you. Always does, ever since you both started in this company years ago fresh out of college. He greets you every morning and texts you if he calls out sick … as if you’d notice if he wasn’t there.

Newsflash, you do. Always do.

“You really aren’t doing anything on Valentine’s Day?” His forearm takes up more space on the armrest than necessary, but you don’t mind.

“I told you, work.”

“Boring.”

“You have something planned?” You raise one of your brows at him. It shouldn’t come as a surprise that Jungkook dates and it wouldn’t be a surprise if he had someone to celebrate Valentine’s Day with.

“Not anymore.” He pouts, “work schedule conflict.”

“Bummers.” You go back to looking at your phone, awkwardly relieved at the revelation.

It’s a quiet ride, but it’s nice because you know that you’ll be home soon. That is, until Jungkook nudges your arm lightly with his elbow.

“I got a job offer from another company.”

People promote. People retire. People come and go. It’s normal in your field, so why do you feel like you’re being deserted? You’ve been hinting that he deserved a promotion. Know he deserves more, but wasn’t expecting this.

“Congrats,” you try to say evenly.

“Turned it down though.”

Another breath of relief leaves you this evening.

“Why?”

“Cause you’d be bored on these shuttle rides without me.” He smiles.

You roll your eyes, but mirror his smile nonetheless.

“Old man Han told us yesterday he’s going to retire by the end of this year. Think I can stick around till then and apply for his position,” Jungkook stretches his legs.

“Ah.” You’ve already known about this months ago given that Jungkook’s manager notified your area to ensure a smooth transition before his exit. Wanted your team to get started on recruiting a couple months before his last day so that he can pick out and train his next protege.

“Ugh, you knew about it, didn’t you?”

“Sorry, had to keep that on the low. HR things.”

“I thought we were friends.” He muses.

“Will you give me a peek at the interview questions?” He knows you won’t, but asks anyways just to see if you’ll scowl at him. Of course you do.

“You’ll do fine. Han likes retaining talent too.” And you’d like to keep working with Jungkook.

The shuttle drops you both off at the off-site parking. It’s just two cars in the lot parked right next to each other: his pulled in from the rear and yours from the front. It makes getting into your car difficult because one person would always have to wait for the other person to go first. Jungkook always lets you go first.

You open your door, pause, contemplate on what you say next. A simple goodnight or drive safe would do … but you know he’s had a rough week. He was very vocal about it in his Teams messages with you. You turn to him and he has this anticipating look on his face.

“The justification memo was good, but we need numbers. You’re good with data — ask me for some tomorrow.” You say. You assumed he would be happy with your tip, instead he looks a bit dejected as he bids you goodnight.

—

The workweek continues and Jungkook was able to get his team member’s promotion in place approved thanks to your help on the side.

Friday rolls by and you greet your team members one by one before heading to your desk.

“Oh, there’s something at your desk.” Jihyo pushes herself out from her cubicle. “Delivery person told us it’s for you. No sender name though … I think you’ve gotten yourself a secret admirer.” She smiles coyly.

That’s when you see the bouquet of pink peonies with a little note.

Flattery won’t change the outcomes, but you always seem to find a way. I appreciate you.

p.s. How many times do I need to ask you about Valentine’s Day before you get the hint?

p.p.s. Didn’t realize how expensive peonies are off season. You’re lucky I like you.

You log into your computer with a smile, fingers flying across your keyboard the moment the Teams application loads on the screen.

You [8:20 a.m.]: Didn’t think peonies would break the bank.

Jeon, Jungkook [8:20 a.m.]: you know … people usually say thank you after receiving an extravagant gift

You [8:20 a.m.]: Thank you.

Jeon, Jungkook [8:21 a.m.]: much better 😌

Jeon, Jungkook [8:21 a.m.]: sooo ……..

You [8:21 a.m.]: What are you doing tonight?

Jeon Jungkook is typing …

—

part two

a/n: hehe. if anyone talked to me at work like this im reporting them to hr. but its jk, so we’ll let him slide right? hope yall enjoyed! lmk ur thoughts 💟

[tccicomputercoaching]

Discover why learning Excel in 2025 is still essential for careers, data analysis, and business productivity across all industries.

[rosesdrop]

Pick a pile

What career would best suit you

Pile 1:

For pile 1 most of you don't like to stay under one pace when pursuing your career, you like diversion you also prefer to do side hustles. You are creative so you don't like to be restricted in one area of specialty. You are quite useful and I'm getting that you like to perform practical tasks, those who require using hands or overall building your experience, you like to match your brain skills with physical skills, and you also enjoy going on adventures and doing outdoorsy activities, you also like helping people and doing charity if you can, but you don't like to settle for one thing. Working as a nurse or hospital related jobs might be good for you, alchemy is a thing you might like.

Pile 2:

Working with other people may have it's up and downs, but to you it's necessary for growth. It's going to benefit you a lot and help you to expand you knowledge. You are warm and social, and you like working in a group where people embody the same energy you have. You are good at getting people together and building a great team, a good strategizer and may even preoccupy leadership positions successfully. You like to learn about different cultures and you like to explore the world, you search for knowledge in discovering new things and going farther ahead from your usual thinking and beliefs. Traveling as a way of grasping and collecting knowledge is great for you.

Pile 3:

You are much more secretive than the other 2 piles. You like to work in silent, you're a very patient person and you take time in collecting information and analysing it, you have a very sharp mind that investigates things often and come to accurate and interesting conclusions that can be useful for complicated situations, a position in strategizing or investigating is good for you. Organizing and collecting information, engineering, and data analysis. You're also very creative, some of you are great artists so you would excel in arts as well. Writing books or book keeping even translating, you're also good at cracking codes.

[alexaloraetheris]

Question: Can I get in trouble for falsifying my experiment results?

So as part of the physiology class I have to do a biorhytm analysis. Basically it means that for 24 hours I need to do memory and reflex tests every two hours, then put the results in an excel sheet. Simple enough.

Except I am doing them on my tablet because I'm not hauling my ancient laptop to the lab if I don't have to, and my cats have noticed me tapping away on it very intently. The reflexes test just needs you to tap the screen as soon as you notice the red circle turned green. Easy enough one of my cats has figured it out. Interesting enough that she's trying to HELP, because compared to a cat my reflexes are, ofc, shit.

At first I needed to redo the test a bunch of times because she kept messing it up. But now that she knows what to do she taps the game. Faster than I can. I adjusted the test for more taps so the average skews more towards my results rather than hers, but my average reaction is like 300ms and hers is 60. It's making my results look a lot better than they should.

Is that cheating?

EDIT: This is test for an elective class, it's mostly about learning the process and not collecting actual research-relevant data. None of this is getting used anywhere where my superhuman reflexes might raise an eyebrow. I swear if it were, the cat's results would be filtered out, even if my smugness at having the best scores would suffer.

[lazeecomet]

The Story of KLogs: What happens when an Mechanical Engineer codes

Since i no longer work at Wearhouse Automation Startup (WAS for short) and havnt for many years i feel as though i should recount the tale of the most bonkers program i ever wrote, but we need to establish some background

WAS has its HQ very far away from the big customer site and i worked as a Field Service Engineer (FSE) on site. so i learned early on that if a problem needed to be solved fast, WE had to do it. we never got many updates on what was coming down the pipeline for us or what issues were being worked on. this made us very independent

As such, we got good at reading the robot logs ourselves. it took too much time to send the logs off to HQ for analysis and get back what the problem was. we can read. now GETTING the logs is another thing.

the early robots we cut our teeth on used 2.4 gHz wifi to communicate with FSE's so dumping the logs was as simple as pushing a button in a little application and it would spit out a txt file

later on our robots were upgraded to use a 2.4 mHz xbee radio to communicate with us. which was FUCKING SLOW. and log dumping became a much more tedious process. you had to connect, go to logging mode, and then the robot would vomit all the logs in the past 2 min OR the entirety of its memory bank (only 2 options) into a terminal window. you would then save the terminal window and open it in a text editor to read them. it could take up to 5 min to dump the entire log file and if you didnt dump fast enough, the ACK messages from the control server would fill up the logs and erase the error as the memory overwrote itself.

this missing logs problem was a Big Deal for software who now weren't getting every log from every error so a NEW method of saving logs was devised: the robot would just vomit the log data in real time over a DIFFERENT radio and we would save it to a KQL server. Thanks Daddy Microsoft.

now whats KQL you may be asking. why, its Microsofts very own SQL clone! its Kusto Query Language. never mind that the system uses a SQL database for daily operations. lets use this proprietary Microsoft thing because they are paying us

so yay, problem solved. we now never miss the logs. so how do we read them if they are split up line by line in a database? why with a query of course!

select * from tbLogs where RobotUID = [64CharLongString] and timestamp > [UnixTimeCode]

if this makes no sense to you, CONGRATULATIONS! you found the problem with this setup. Most FSE's were BAD at SQL which meant they didnt read logs anymore. If you do understand what the query is, CONGRATULATIONS! you see why this is Very Stupid.

You could not search by robot name. each robot had some arbitrarily assigned 64 character long string as an identifier and the timestamps were not set to local time. so you had run a lookup query to find the right name and do some time zone math to figure out what part of the logs to read. oh yeah and you had to download KQL to view them. so now we had both SQL and KQL on our computers

NOBODY in the field like this.

But Daddy Microsoft comes to the rescue

see we didnt JUST get KQL with part of that deal. we got the entire Microsoft cloud suite. and some people (like me) had been automating emails and stuff with Power Automate

This is Microsoft Power Automate. its Microsoft's version of Scratch but it has hooks into everything Microsoft. SharePoint, Teams, Outlook, Excel, it can integrate with all of it. i had been using it to send an email once a day with a list of all the robots in maintenance.

this gave me an idea

and i checked

and Power Automate had hooks for KQL

KLogs is actually short for Kusto Logs

I did not know how to program in Power Automate but damn it anything is better then writing KQL queries. so i got to work. and about 2 months later i had a BEHEMOTH of a Power Automate program. it lagged the webpage and many times when i tried to edit something my changes wouldn't take and i would have to click in very specific ways to ensure none of my variables were getting nuked. i dont think this was the intended purpose of Power Automate but this is what it did

the KLogger would watch a list of Teams chats and when someone typed "klogs" or pasted a copy of an ERROR mesage, it would spring into action.

it extracted the robot name from the message and timestamp from teams

it would lookup the name in the database to find the 64 long string UID and the location that robot was assigned too

it would reply to the message in teams saying it found a robot name and was getting logs

it would run a KQL query for the database and get the control system logs then export then into a CSV

it would save the CSV with the a .xls extension into a folder in ShairPoint (it would make a new folder for each day and location if it didnt have one already)

it would send ANOTHER message in teams with a LINK to the file in SharePoint

it would then enter a loop and scour the robot logs looking for the keyword ESTOP to find the error. (it did this because Kusto was SLOWER then the xbee radio and had up to a 10 min delay on syncing)

if it found the error, it would adjust its start and end timestamps to capture it and export the robot logs book-ended from the event by ~ 1 min. if it didnt, it would use the timestamp from when it was triggered +/- 5 min

it saved THOSE logs to SharePoint the same way as before

it would send ANOTHER message in teams with a link to the files

it would then check if the error was 1 of 3 very specific type of error with the camera. if it was it extracted the base64 jpg image saved in KQL as a byte array, do the math to convert it, and save that as a jpg in SharePoint (and link it of course)

and then it would terminate. and if it encountered an error anywhere in all of this, i had logic where it would spit back an error message in Teams as plaintext explaining what step failed and the program would close gracefully

I deployed it without asking anyone at one of the sites that was struggling. i just pointed it at their chat and turned it on. it had a bit of a rocky start (spammed chat) but man did the FSE's LOVE IT.

about 6 months later software deployed their answer to reading the logs: a webpage that acted as a nice GUI to the KQL database. much better then an CSV file

it still needed you to scroll though a big drop-down of robot names and enter a timestamp, but i noticed something. all that did was just change part of the URL and refresh the webpage

SO I MADE KLOGS 2 AND HAD IT GENERATE THE URL FOR YOU AND REPLY TO YOUR MESSAGE WITH IT. (it also still did the control server and jpg stuff). Theres a non-zero chance that klogs was still in use long after i left that job

now i dont recommend anyone use power automate like this. its clunky and weird. i had to make a variable called "Carrage Return" which was a blank text box that i pressed enter one time in because it was incapable of understanding /n or generating a new line in any capacity OTHER then this (thanks support forum).

im also sure this probably is giving the actual programmer people anxiety. imagine working at a company and then some rando you've never seen but only heard about as "the FSE whos really good at root causing stuff", in a department that does not do any coding, managed to, in their spare time, build and release and entire workflow piggybacking on your work without any oversight, code review, or permission.....and everyone liked it

[cognitivejustice]

Free online courses on Nature -Based Infrastructure

"Two training courses on making a case for and valuing Nature-Based Infrastructure. This training is free of charge.

Participants will learn how to:

Identify nature-based infrastructure (NBI) and its opportunities for climate adaptation and sustainable development.

Make the case for NBI by explaining its potential economic, environmental, and social benefits.

Understand the risk profile and the climate resilience benefits of NBI compared to grey infrastructure.

Explain the basics of systems thinking, quantitative models, spatial analysis, climate data and financial modelling applied to NBI.

Appreciate the results of integrated cost-benefit analyses for NBI.

Use case studies of NBI projects from across the world as context for their work.

This course was developed by the NBI Global Resource Centre to help policy-makers, infrastructure planners, researchers and investors understand, assess, and value nature-based infrastructure. The course familiarizes participants with several tools and modelling approaches for NBI, including Excel-based models, system dynamics, spatial analysis and financial modelling. In addition, the training presents a variety of NBI case studies from across the world.

Why do this course?

This course will help you gain valuable skills and insights which will enable you to:

Gain knowledge and tools for informed infrastructure decision-making, with a focus on advancing nature-based solutions for climate adaptation at a systems level.

Understand and measure the benefits, risks, and trade-offs of nature-based infrastructure.

Understand the importance of systemic thinking for infrastructure planning, implementation, and financing strategies.

Communicate persuasively and effectively with stakeholders to advocate for nature-based infrastructure.

Collaborate with peers around the world and become part of the NBI Global Resource Centre alumni.

[carrernext]

Learn Advanced Excel for Data Analysis | Master Excel Skills Online

Unlock the full potential of Microsoft Excel by learning advanced techniques tailored for data analysis. This comprehensive course is designed for professionals, analysts, and students who want to gain hands-on expertise in using Excel for making data-driven decisions. Explore powerful tools like PivotTables, Power Query, VLOOKUP, XLOOKUP, data visualization, dynamic charts, conditional formatting, and advanced formulas. Whether you're preparing dashboards, cleaning data, or performing complex analyses, this training will give you the edge to turn raw data into meaningful insights. Learn at your own pace and elevate your data analysis skills with Excel today!

[krittikasurya]

Some thoughts on Krittka Nakshatra (originally posted on substack and twitter)

Krittika at its best really understands how to both simultaneously enjoy and appreciate things while also being able to give critical commentary and feedback, and I think a lot of people have a hard time wrapping their heads around this level of multifaceted behavior. In a world where black-and-white, all-or-nothing thinking is common and encouraged, people often forget that two things can be true at once. Krittika natives have the creativity and flexibility to understand and implement this “two truths at once” concept into their everyday lives. People think Krittika natives are being insolent or abrasive when the native is just simply speaking on what they’ve learned, gathered, observed and experienced and being straightforward about it…taking the data they’ve accumulated and turning it into something that’s easy to digest. Absolute truths rarely exist, and Krittika exposes the complexities we experience on both a collective and individual level.

Krittika’s goal isn’t to trash things necessarily. I think the goal Krittika natives have is to help themselves and others see things in a different, profound way. Offering refreshing perspectives on many different aspects of life is something the natives take pride in. The Martian influence of the Aries portion of the nakshatra makes one very analytical and strategic. Observing and learning through action and expeirnce, the Aries side of this nakshatra knows how to take things back to the drawing board. They understand that trial and error are some of the best teachers, and that there is always room for change. The Venusian influence of the Taurus portion gives the native discernment and good taste. The discriminatory nature of Venus leaves little to no room for indifference, especially when it comes to connections, arts, and culture. Venus appreciates excellence, and Krittika will accept nothing less. Krittika serves as the bridge between the sun’s (Identity) and the moon’s (Mind) exaltation points, giving both signs vast intelligence that manifests slightly different, but one thing remains the same: The sharp, quick witted nature of the nakshatra that seeks improvement within themsleves and the world around them. In today’s society, echo chambers are growing increasingly common, creating less nuance and mental flexibility, and more groupthink. From arts to politics, the effects of all-or-nothing thinking seems almost inescapable. Mediocrity is the acceptable normal, and Krittika is on a mission to change that.

When not channeled appropriately, Krittika natives can be high strung individuals, hypercritical of both themselves and others while forgetting to appreciate the beauty of life, and the beauty within themsleves. Some constantly feel the need to “shake the table” or say what they believe others are afraid to say, not fully realizing the implications of making ego driven “critiques.” Some “critiques” can be so ego driven, that they are dowright incorrect, mean or hateful in nature. They can be prone to tunnel vision and extreme anger, especially when they feel like their way is the only way. Krittikas can be demanding, exhibiting dictator-like control over their communities which can lead to a “walking on eggshells” feeling for the people around the native. It is imperative that Krittikas don’t lose sight on what’s important: not crossing the thin line between enlightening analysis, and downright negativity.

Krittika natives experience a lot of pleasure from giving critique as well, because they believe that there’s something really cool about being able to get others to think in ways they may not have before, and introduce various perspectives on any given subject. Krittika’s shakti (power) is to purify or burn away impurities, and sharing thier critical thoughts and assessments is one of the best ways to do it in today’s world. If we as a collective are going to consume things, Krittikas believe we can and should evaluate and question what we consume. Things should be questioned more. “Impurities” should be pointed out. The status quo should be challenged in all aspects of life.

Krittika isn’t scared to point out things that are flawed and it infuriates some individuals that Krittika natives don’t just sit and “go with the flow” all the time. Krittika has a burning lust for awareness of the world we live in. Krittika knows that sometimes there will be conflict, they’ll ruffle a few feathers and invoke certain emotions that make others feel uncomfortable, but when done tactfully that has the power to change the world (however big or small you consider your world to be).

[rdiasrohini]

Top B.Com (H) College at IP University: Empowering Students for a Better Tomorrow

When searching for the top B.Com (H) college at IP University, students often look beyond academics—they seek institutions that shape well-rounded individuals. One distinguishing factor is the college’s commitment to addressing societal issues, encouraging students to become responsible citizens who contribute meaningfully to their communities and the world.

At the heart of this transformative education are research projects that expose students to real-world challenges. These projects not only enrich academic understanding but also equip students with essential skills such as critical thinking, data analysis, and effective communication. Participation in research fosters innovation and builds confidence, significantly boosting career prospects and paving the way for future academic pursuits.

Another cornerstone of a top-tier B.Com (H) program is its experienced faculty. These educators bring years of industry and academic expertise to the classroom, offering students insights that go beyond textbook theories. Their ability to simplify complex concepts ensures a stronger grasp of subjects like accounting, finance, and economics. More importantly, their mentorship nurtures curiosity and inspires lifelong learning.

A college that emphasizes academic excellence, social responsibility, and professional development ensures students graduate not just with a degree, but with a purpose. Choosing the right college within Guru Gobind Singh Indraprastha University (IPU) can set the foundation for a meaningful and successful career in commerce and beyond.

For aspirants aiming to make a mark in the business world while contributing to societal progress, the best B.Com (H) colleges at IP University offer the perfect platform to grow, lead, and serve.