F5F Stay Refreshed Software Operating Systems Organizador de datos

Organizador de datos

Organizador de datos

H
145
11-10-2023, 06:59 PM
#1
In the troubleshooting area, many users share similar issues, though identifying connections can be tricky. I need a solution that lets me input system details and problems, then organize them easily—like sorting by graphics card or issue type. I’d like to try this myself first, but have a public version for others who want to explore. My question: which tool fits? Can Excel handle this? Is there an online platform? I’m open to using SQL if it’s too complex, but I prefer something simpler and not server-heavy. If anyone has experience with Excel for this purpose, that would be great!
H
hamsterdance00
11-10-2023, 06:59 PM #1

In the troubleshooting area, many users share similar issues, though identifying connections can be tricky. I need a solution that lets me input system details and problems, then organize them easily—like sorting by graphics card or issue type. I’d like to try this myself first, but have a public version for others who want to explore. My question: which tool fits? Can Excel handle this? Is there an online platform? I’m open to using SQL if it’s too complex, but I prefer something simpler and not server-heavy. If anyone has experience with Excel for this purpose, that would be great!

J
Jss0225
Junior Member
5
11-21-2023, 06:12 PM
#2
It seems you're looking for information about a "ticket" system related to your interests @ HPWebcamAble
J
Jss0225
11-21-2023, 06:12 PM #2

It seems you're looking for information about a "ticket" system related to your interests @ HPWebcamAble

L
liljap98
Member
54
11-28-2023, 04:32 PM
#3
Excel or Google Sheets provides simple options for this. A database needs an ID and becomes complex when linking various items together.
L
liljap98
11-28-2023, 04:32 PM #3

Excel or Google Sheets provides simple options for this. A database needs an ID and becomes complex when linking various items together.

M
Marcel2440
Member
138
11-28-2023, 06:14 PM
#4
I believe starting with Google Sheets would be a good idea, since you likely have some experience with it. Would that work for you?
M
Marcel2440
11-28-2023, 06:14 PM #4

I believe starting with Google Sheets would be a good idea, since you likely have some experience with it. Would that work for you?

R
Roycie_Bear
Member
181
11-28-2023, 07:48 PM
#5
Excel and Sheets serve as similar tools, functioning mainly as table-based applications. You can design the top row for your filters—such as specifications, operating systems, and symptoms—and place the first column with sequential IDs starting from 0001 or a unique identifier like username. Be sure to add a reference to the discussion thread. For future projects, using distinct IDs from the start is advisable. Excel offers superior sorting capabilities. I prefer features that let the program identify headers correctly without treating them as data items. This approach was used recently when comparing personal laptops.
R
Roycie_Bear
11-28-2023, 07:48 PM #5

Excel and Sheets serve as similar tools, functioning mainly as table-based applications. You can design the top row for your filters—such as specifications, operating systems, and symptoms—and place the first column with sequential IDs starting from 0001 or a unique identifier like username. Be sure to add a reference to the discussion thread. For future projects, using distinct IDs from the start is advisable. Excel offers superior sorting capabilities. I prefer features that let the program identify headers correctly without treating them as data items. This approach was used recently when comparing personal laptops.

K
kcaz56
Senior Member
664
12-06-2023, 02:00 PM
#6
I'll try to use Sheets since anyone can view it, plus I can acess it from any computer Here's a link: https://docs.google.com/spreadsheets/d/1...sp=sharing
K
kcaz56
12-06-2023, 02:00 PM #6

I'll try to use Sheets since anyone can view it, plus I can acess it from any computer Here's a link: https://docs.google.com/spreadsheets/d/1...sp=sharing