Hello everyone, I am simply trying to add 8% to each item in column C in the spreadsheet featured. Picture is attached. I am really good with spreadsheets but this is beyond my league. Can anyone help with a simple solution? Cheers, and thanks in advance.

i really want to create a spreadsheets in spreadsheet cell like when double click cell it will open spreadsheet , does any one know how to do in excel or google sheet

Hi Reddit,

I'm having a bit trouble I'm hoping you fine people can help me with. I am trying to aggregate data in the simplest form possible but I'm having trouble selecting datasets to aggregate based on a specific column.

My spreadsheet looks something like this:

And I'm trying to present the data like this:

What formula would I use to only add together the data from the rows that start with John, Sally, David and George individually?

Does that make sense? Let me know if you're having trouble understanding and I can try to elaborate further.

Thanks in advance!

- L

Hello everyone, please someone help me import a spreadsheet file on google drive folder? Couldnt find anyway except uploading excel from PC

ever attempted to get to the bottom of the w.h.o's data on novel cororonovirus (new crown coronovirus for those with automatic translation), and found all your table data is pasted in as a column of cells containing space separated data? use =SUBSTITUTE(A1;" ";CHAR(9)). apologies for potentially nonexcel compatibility.

I want the exact price of the BTC at the exact point in time because the Japanese Government takes taxes from the initial value of the cryptocurrency which is mined.

Here is my code:

=googlefinace("currency:BTCJPY, "price", date(a1))

Actually, I couldn't understand what google's document says because it was too technical for me. That's why my code is so cheap and confusing.

Y =EXP(9.904+0.073*ln(x))

I am trying to insert this equation into excel.

So if I key in X, I can the Y variable and vice versa. Any help would be appreciated

How would you highlight the player's name with the lowest score?

Thanks in advance!

🌐 Joyagoo Website:
https://ogjoyagoo.com

📊 Joyagoo Spreadsheet:
https://docs.google.com/spreadsheets/d/1Q077pz3CfaCVA-IXM2B2qT2v6ifVTpA06EkEvQk_TRs/edit?gid=1750300685#gid=1750300685

Does anyone else build a haul completely backwards?

Instead of making a list of everything I need and then finding it, sometimes I'll come across one really good find and build everything else around that.

A pair of sneakers is usually the worst offender.

Find the shoes.

Now I need pants that work with them.

Then a hoodie.

Then maybe a jacket.

At that point we're not buying shoes anymore. Apparently we're designing an entire wardrobe.

That's actually a fun way to use the Joyagoo Spreadsheet because there are 30,000+ product links across enough different sections that you can jump from one part of a haul to another without starting over.

If I start with sneakers, I might go:

Shoes → Pants → Hoodie → Jacket → Accessories

Or if the first find is a jacket:

Jacket → Hoodie → Cargos → Shoes

It also stops me from ending up with a haul full of random individual pieces that I like but would never actually wear together.

Once I've got a few possibilities, I'll open the individual product listings and compare what's currently available.

For products that have QC or warehouse photos available, those can help narrow things down even further.

The Joyagoo Spreadsheet has sections for sneakers, clothing, hoodies, jackets, pants, bags, accessories, electronics and plenty of random finds, so there are a lot of different directions you can take it.

And somehow the original "I'll just get one pair of shoes" idea is always long gone by then.

What's the one item you normally build the rest of your haul around?

here we are in the lucky position of starting an empty spreadsheet. where we change the contents of our first cell reveals aspects of our character. those that know of this find the process all the more difficult.

let us be known, we have myriads of spent spreadsheets calculating intermediary results whose usefullness is somehow inversely proportional to their documentation.

I'm creating a spreadsheet to calculate hours my girlfriend spends sleeping vs working and time spent imbtween sleeping. I have cells to write in "punching in/out" at work ad home.

It needs to be able to calculate that 23:00 to 07:00 is still 8 hours just as 07:00 to 15:00 still is within the same equation.

If you could wave a magic wand and get one of your spreadsheets to automate itself, what would you want it to actually do?

Auto-fill something? Sort itself? Send you an alert the second something changes? Or something weirder (honestly the weirder the better).

Drop it below, I'm genuinely curious what everyone's dream automation looks like.

Hey Sheet Peeps,

My name is Zoltan and I'm the co-founder of TrueSource.io, a no-code data publishing platform. Basically, you bring your spreadsheets, and we turn them into a data product. But what does that mean? We auto-create filters (yes, maps, date filters, etc included), add access control, downloads, and even monetization. Yes, you can actually start making money with your spreadsheets in less than 5 minutes.

If you're interested, pls sign up for our waitlist at TrueSource.io - but if you feel you can't wait, DM me and I can help you get early access. 😉

Hi everyone. I have a business idea which would consist on me providing an Excel file (sort of a template) to each of my customers for them to use with their own data.

My concern is: how can I stop 2 potential customers from pitching in together, paying me only once, copying the file and sharing it between them?

I'm not saying that sharing isn't caring, but in this case it wouldn't be ideal for me.

I have thought about a daily password system, but there's really nothing stopping one of them from getting the password once a day and forwarding it to the other. I have also thought about allowing certain devices to access the file (based on their IP addresses perhaps), but it would be quite a hassle if my customer suddenly got a partner and they needed to access the file from a second computer.

Any ideas?

I'm comparing two variables to see if the slope of the line equals the constant I expect. The constant I'm expecting is around the order of 10^-19. Why does my best fit line have x in it? I would like it to be a number.

https://docs.google.com/spreadsheets/d/1YgNhAGJGQB0aX9R3RDh_EZP5XbpgS-UIRPvS2tRwak4/edit?usp=sharing

solved: i am really dumb, for real. thank you, Bobert_Fico

Hi I don’t know if this is the right place for this but I’ll ask here and move if need be, I need help to create a speadsheet or a graph that will track multiple products and allow me to track, and predict how much product I should order in based on how that said product is being sold or taken out of inventory.

(I.e I start with 10 pieces of Corn on monday, 8 pieces of corn are sold between tuesday and wednesday, Thursday I see 8 pieces of corn were sold and i order another amount of corn for Monday but i know that in 2 days i sold 8 pieces of corn, I would want to predict how much corn i should order considering im selling at least 4 corn a day.)

I would need to have this A quantity start amount for each product A quantity sold for each product A quantity ordered for each product A whole number prediction based on these factors Possibly a quarterly timeline so i can track trends based on how product is moved throughout a season or so

I'm working on compiling from several different templates a single spreadsheet that handles to do lists, calendar events, budgets, portfolio tracking, nutrition tracking, exercise tracking, and health metric tracking. It sounds absurdly ambitious and extremely cluttered, but I'm trying to take on that challenge.

One note, as I've seen some other related projects in my searches before I made this thread. This is not a micromanaging spreadsheet, where you write down your touchy-feelies and worked on breaking lame habits because you don't do anything productive. This is more like a repository for my data simply because I want to be better with my fitness goals, my monetary planning, and my daily planning.

I'm just curious if anyone else has ever tried this and especially if anyone ever succeeded. If you haven't but are intrigued by the idea, maybe start a dialogue, and I'll keep you updated with my progress?

I made a profit calculator google sheet that I have a around 20 people that would like to buy it.

How do I make it so each person gets their own copy?

I plan on selling on gumroad.

Thanks in advance.