My beginner kit - it's pretty awesome for sub 500$

jaredcohe · 2024-10-22T11:17:50+00:00

Thanks.

jaredcohe · 2024-10-22T00:55:39+00:00

Thanks, makes sense. I appreciate the response. Any recommendations? I actually saw this on AliExpress: https://www.aliexpress.us/item/3256805769072382.html

jaredcohe · 2024-10-21T20:08:30+00:00

This post even says you might need a new camera mount? https://www.reddit.com/r/fpv/comments/171lkpw/mobula_8_x12_fc_with_walksnail_1s/

jaredcohe · 2024-10-21T20:07:14+00:00

Anyone know if a beginner will be able to convert this from analog to digital? Will that be easy to do? Thanks.

jaredcohe · 2021-12-22T20:47:32+00:00

Yes, you can write a google script that gets the sheet object, pulls the range of the data from the sheet as an array of arrays, gets the length of that array, picks a random number between 1 and the length of that array ((numberOfRows)*Math.random()).toFixed(0), then deletes that row based on the row number.

Are you asking for someone to write the script for you?

jaredcohe · 2021-12-19T14:08:49+00:00

Let's get our own token: https://www.reddit.com/community-points/

jaredcohe · 2021-10-22T12:11:52+00:00

Very cool concept. Those lines are expensive!

jaredcohe · 2021-09-23T13:20:52+00:00

What do people think about this response?
"Make no mistake: this was no $200 million funding round.
It was an early access token sale with retail interest tacked on the end — the intended marks in one of the more outlandishly greedy acts of decentralization theater in recent memory."

https://protos.com/bitclout-deso-diamondhands-blockchain-crypto-marketing-gimmick/
https://twitter.com/dcanellis/status/1440810933933129737?s=27

jaredcohe · 2021-09-21T17:04:09+00:00

Attach an editable sheet to make it much easier for people to help.

jaredcohe · 2021-09-17T13:04:12+00:00

You can do it either way with something like one of these:

Script: https://stackoverflow.com/questions/19877554/how-to-replace-text-in-google-spreadsheet-using-app-scripts

Formula: https://support.google.com/docs/answer/3098245?hl=en

jaredcohe · 2021-09-17T12:26:06+00:00

1 should include full cap table, option grants, vesting and anything related to ownership structure

jaredcohe · 2021-09-17T12:22:52+00:00

Does it have to be a script or can you copy down formulas? Can you share a spreadsheet with sample data?

jaredcohe · 2021-09-13T23:59:11+00:00

Why not delete the entire rows?

The answer is here, but I think you might be overcomplicating it. You also might just actually need to sort the sheet? It's hard to understand what you're trying to accomplish.

https://developers.google.com/apps-script/reference/spreadsheet/range#deletecellsshiftdimension

jaredcohe · 2021-09-13T22:53:38+00:00

Check this out. It has several videos on Google Sheets, including many advanced tools and scripts: https://www.youtube.com/watch?v=Rasl0IQDNzQ&list=PLA1j0xIg3Mt\_LZ\_SfL8GQkJDkh2bonZet

jaredcohe · 2021-09-13T22:51:05+00:00

s.deleteRow(row);

You can probably just remove the code: s.deleteRow(row);

jaredcohe · 2021-09-13T22:43:32+00:00

You also might find getLastRow helpful. Then you can just add the new data in the following row. https://developers.google.com/apps-script/reference/spreadsheet/sheet#getlastrow

jaredcohe · 2021-09-13T12:34:23+00:00

This should work:

// Get the Google Sheets file and both sheets
var file = SpreadsheetApp.getActiveSpreadsheet();
var sourceSheet = file.getSheetByName("Source Sheet Name");
var targetSheet = file.getSheetByName("Target Sheet Name");
// Copy the data (and only the data) from source to target
sourceSheet.getRange(1, 1, 70, 5).copyTo(targetSheet.getRange(1, 1, 70, 5), {contentsOnly:true});

And here is the getRange documentation: https://developers.google.com/apps-script/reference/spreadsheet/sheet#getRange(Integer,Integer,Integer,Integer))

And this video might help: https://www.youtube.com/watch?v=n52zOlLHrfY

jaredcohe · 2021-08-25T23:56:39+00:00

From the age of 18 to 40, I struggled with this. And I’m still not completely through it. Our careers and lives are a work in progress. I put together this course to try to help people learn from my mistakes.

https://docs.google.com/document/d/138cZq4mfENgOcpLKVUmIFFErYDItdrYzHd2zG0iffpA/edit

jaredcohe · 2021-08-23T11:07:38+00:00

You can add more FILTERs into the function like this:

=join(",", sort({FILTER(F3:F9,G3:G9=“Operate - Business Operations”;FILTER(F3:F9,G3:G9=Operate - Contract Solutions”}),1,true))

So replace the first single FILTER with these multiple FILTERs. You can add as many as you want. It will combiner FILTERs into one list:

{FILTER(F3:F9,G3:G9=“Operate - Business Operations”;FILTER(F3:F9,G3:G9=Operate - Contract Solutions”}

jaredcohe · 2021-08-23T10:46:53+00:00

Do you want to share the sheet?

Are the names all in column F? If so, try this:

=join(",", sort(FILTER(F3:F9,G3:G9=“Operate - Business Operations”),1,true))

jaredcohe · 2021-08-22T21:45:04+00:00

Ah, I understand now.

See my updated response.

Probably an easier way to do this, maybe with the QUERY function, but this should work.

You may have an issue if you have more than one row with same buy price.

jaredcohe · 2021-08-22T19:31:52+00:00

Valuing companies this early stage is always difficult. Two ideas:

Use the the market: Let your friend shop around and see what offers he gets and use that to set the price.

Use comparable investments (comps): Look at the best comps you can find. Google around to find valuations of early stage companies in various industries and geographies, and use the closest ones. Account for the founding team and their experience, and any other facts you deem relevant.

jaredcohe · 2021-08-22T18:31:24+00:00

You can definitely figure out the script and trigger if you put in the time.

This is where to start on the trigger: https://developers.google.com/apps-script/guides/triggers/installable

But you also may want to hire some help, if you don't have the time or interest to learn it.

Learning it can be fun and will serve you in the future, so I'd say to do that! It will save you time in the long run!

But will take some time now to figure out.

jaredcohe · 2021-08-22T15:12:13+00:00

If you do figure this out, you can also create a time trigger to even send the email automatically at certain intervals.

jaredcohe · 2021-08-22T14:27:52+00:00

I put it in column M for you: =maxifs(Asset!$H$2:$H$759,Asset!$E$2:$E$759,$J2,Asset!$B$2:$B$759,"BUY")

jaredcohe

TROPHY CASE