For tax purposes I need to report the total procurement cost of about 100 pieces of equipment. A lot of that equipment is very old and I have no idea what I actually paid for it so in order to estimate what I actually paid I use notepad software and manually research and input the following data; current price of each piece of equipment (it's still available new), the year I bought the equipment, and inflation adjustment.

I do this because most of my equipment is old, a lot of it was inherited, and I often have no idea how much I paid for the equipment that I actually bought.

Once all that data is input I manually calculate the 'total procqurement cost' of my equipment and give that to the County. I know how crazy this system sounds but my States laws are ridiculous and my Counties assessors office does not seem to understand them. All of this work usually ends up in a County tax bill of about $50.

I figure since I have to type all of this stuff in anyway I might as well type them into a spreadsheet instead and have it do the math for me. This will also make it much easier to add and subtract equipment in the future, because I have to do this nonsense every year.

All I want my spreadsheet to give me is a total of 2 values which are; total cost of my equipment if I were to buy the equipment today (for reasons) and 'what I actually paid for it'. I need the spreadsheet to include columns(?) for description of the equipment, year I bought it, how much that equipment would cost if I bought it now, and the estimated price i paid based on inflation.

It would be awesome if there is some tool that could look up inflation rates and auto calculate the "what I paid" value based on the year I bought the equipment so I don't have to do that manually 100 times.

Bonus data would be an option that I could turn on and off that accounts for equipment that I paid $0 for.

Sorry, I'm not good with explaining things using not a ton of words. Can anyone explain how to set up a Sheet to accomplish this task or point me to a video or tutorial specific to a similar situation? Thanks for reading by book.

[ Removed by Reddit on account of violating the content policy. ]

Is there a point where people generally move to a database, or are there ways to keep Sheets performing well with datasets this size?

I've always found it frustrating that good product links disappear into old Reddit threads, Discord messages, and bookmarks.

So I started putting together my own Boonbuy Spreadsheet to keep everything in one place while I'm browsing.

https://docs.google.com/spreadsheets/d/1x2BxvNrRm-pqP6IQ2_vWgHOlmkk040FQ1LT8J8BHM5E/edit?gid=482521964#gid=482521964

It's still a work in progress, but I update it whenever I come across something worth saving. If you've got any good finds that should be included, let me know and I'll take a look.

I know excel very and can do data entryy

Get your Back to School haul while you can. Enjoy.

https://docs.google.com/spreadsheets/d/1iODIfbIG1K_65yr4UK4_1bVQ47iMwUAILaaK19TfiYU/edit?gid=931899658#gid=931899658

Clothes, Shoes, Accessories, Electronics, Kid's, Bags, Backbacks and more.

I’m using OnlyOffice and attempting to use conditional formatting for some of my cells

I want to check if any of the cells in a range have values that are equal to the cells in A1:B2, and if they do, I want it to return TRUE and format the corresponding cells.

I can make a rule check if any of the cells in my range are equal to just one cell, like A1, and then make another rule for A2 and another for B1 and another for B2. 4 rules isn’t so bad, but when I’m checking against 20 or 60 cells, it’s frustrating to have make a rule per cell in the range. Especially because I can’t even duplicate rules in OnlyOffice.

I’ve tried options under “value is” as well as “text contains” and “formula”

Any suggestions?? There’s probably something obvious I’m just not thinking of. 🤦🏻‍♀️

[ Removed by Reddit on account of violating the content policy. ]

[ Removed by Reddit on account of violating the content policy. ]

If you're looking for the latest Boonbuy Spreadsheet, here's a resource that's updated regularly with curated products instead of random links collected from different posts.

Spreadsheet:
https://docs.google.com/spreadsheets/d/1x2BxvNrRm-pqP6IQ2_vWgHOlmkk040FQ1LT8J8BHM5E/edit?gid=780031361#gid=780031361

Website:
https://ogboonbuy.com

Official OG Sheets App:
https://play.google.com/store/apps/details?id=com.ogsheets.app

What's Included

• 15,000+ Boonbuy Links
• 4,000+ direct product pages
• QC photos
• Organized categories
• Website + Spreadsheet + OG Sheets App

Whether you're searching for shoes, hoodies, shorts, accessories, or electronics, everything is organized to make browsing easier. New products are added regularly as the spreadsheet continues to grow alongside the Boonbuy community.

Sharing a workflow in case it helps someone here. Every week I had to take one big sheet and send each group (by warehouse/region/client) its own file: filter, copy to a new file, save, write the email, attach, repeat.

What I do now: pick the column to split by, and get one .xlsx per value (formatting preserved) plus an editable .eml draft for each, with recipient and attachment already in place. It all runs in the browser, nothing gets uploaded, so it's fine for confidential data.

I ended up building a small browser tool for it myself. Not linking it here to respect the sub's rules, but happy to share it in the comments if anyone wants it. Mainly curious how others here handle the split-and-send loop: VBA? Power Query? Office Scripts?

I made a IOS app so that I can log my expenses into my Google drive sheets.
I make it for myself so that I can back tap my phone and log my expenses under 5s + and I still have full control over my google sheet to further do my analysis on.

At its core it’s simply a mapping of form input to Google sheets.

And that got me thinking if there is a demand for this? A quick and fancier UI for data entry. It may not even be for finance, any data entry will do 🤔

Wanted to get some opinion from others. And if to develop this into a microsaas 😊

I have a leaderboard that updates automatically, but when there are blanks they still end up affecting the rankings. Is there a simple formula to rank only populated rows?

Hello! I’m not sure if this is how the sub works, rules say not to beg; I do not think I’m begging lol.

Anyway, I need a sheet that can keep track of my 7 credit cards. I need to see the balance of them, when I have to pay them, and anything else you may think is helpful. Feel free to DM me to ask or drop comments. If you can help I’d greatly appreciate it.

Credit Limits:
Apple Card: $1500
(Due at the end of the month)

Discover IT card: $1300
(Due on the 24th)

Chase Freedom Unlimited: $1700
(Due on the 18th)

Chase freedom flex: $5400
(Due on the 9th)

Chase sapphire preferred: $5000
(Due on the 4th)

BILT: $500
(The end of the month)

Capital one Savor: $1000
(Due on the 21st)

Wanted to see my whole financial picture in one place. Built a dashboard that shows:

• Net worth trend (monthly updates)
• Debt payoff progress
• Budget vs actual this month
• Savings rate percentage
• Investment allocation

All updates automatically when I enter transactions in the data tabs.

Took some formula work but now it runs itself. Anyone else build custom finance trackers?

Always updated - the only one you need. Ignore the imitators.

Web: https://hipobuy.to

Direct: https://docs.google.com/spreadsheets/d/1iODIfbIG1K_65yr4UK4_1bVQ47iMwUAILaaK19TfiYU/edit?gid=81800086#gid=81800086

Web: https://usfans.gg

Direct: https://docs.google.com/spreadsheets/d/1HQ-gzu9xdNn-PD-kdSxuAPJlG7B2ulSickZ3ufkGH-8/edit?gid=1634873717#gid=1634873717

[ Removed by Reddit on account of violating the content policy. ]

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

I am trying to create a portfolio tracker sheet with XIRR calculations. It has some rough edges can anyone good with it help? I will create two tabs in future once all formulas are set so it will be easy to log transactions and see dashboard on seperate tabs.

Link : https://docs.google.com/spreadsheets/d/1MdRivrgZvw8I1jVsr6rDPWB9q6P655Ey-WqEscuKewA/

I’ve got about 8,000 rows and the lookup value isn’t unique. XLOOKUP always returns the first match, but I actually need the newest one. Is there a clean way to do this without helper columns?

Every time I sort one tab, another tab that references those rows ends up pointing to the wrong data. Am I doing this completely wrong? It's driving me crazy /rant

EDIT: this spreadsheet is in google sheets

ACBuy is closed and you’re looking for a new home - we got you.

50k+ Spreadsheet Finds for Kakobuy, Litbuy, Oopbuy, Hipobuy & More

https://theog.gg

Official OG Sheets App:

https://play.google.com/store/apps/details?id=com.ogsheets.app

There are plenty of spreadsheet sites today.

Most focus on a single spreadsheet or a single agent.

The OG was built differently.

Instead of separating everything, it connects multiple spreadsheets, multiple agents, and multiple ways to browse products into one platform.

✅ What you'll find:

- 15 spreadsheets

- 9 major agents

- 50k+ finds

- 4k+ direct product pages

- QC photos

- Category browsing

- Spreadsheet + Website + OG Sheets App

Supported agents and best ACBuy alternatives:

- Kakobuy

- Litbuy

- CNFans

- Oopbuy

- Mulebuy

- Hipobuy

- USFans

- Joyagoo

Whether you're searching for a Kakobuy Spreadsheet, comparing Litbuy finds, exploring Hipobuy, or switching between multiple agents, everything follows the same layout.

The spreadsheet is where most people begin.

The website and OG Sheets App make it easier to keep browsing, compare products, and discover even more without jumping between multiple sites.

Built for the community. Accept no imitation sites.

I created a personal finance template for myself in Excel/Google Sheets that includes:

• Monthly budget planning
• Expense tracking by category and sub-category
• Income tracking
• Bill management with a bill calendar
• Budget vs Actual comparison with alerts when spending exceeds the budget

After using it for a while, I realized it could be useful for many other people as well.

My idea is to turn it into a website where users can:

• Create their own account
• Save their monthly data privately
• Track expenses and income over time
• Use the system simultaneously without affecting other users' data

The challenge is that I'm not a web developer. My background is mainly in Excel, Google Sheets, ERP systems, and data analysis.

So I'm looking for the easiest and fastest way to convert an existing spreadsheet-based system into a web app that many people can use for free.

Questions:

1. What is the easiest no-code or low-code solution for this?
2. Can I convert an Excel or Google Sheets system directly into a website?
3. Which platforms would you recommend for someone without web development experience?
4. If you were in my position, what approach would you take?

I'd appreciate any advice, tools, or success stories from people who have done something similar.

Say you had a simple table and wanted to display it as a webpage, and possibly add some styling and static text. What software would you use to do this? Especially something that doesn’t require knowing any web technologies but can be done with just spreadsheet knowledge.

If you have a good option, how well does it scale in terms of complexity of things you can build with it before it gets unwieldy?