• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Does anyone have an Excel file from their job they can send me?

Scarpozzi

Scarpozzi

Lifer
I'm taking an Information Technology class to finish up my MBA. One of the assignments is to create a database for some fake business and use it to manipulate data. The problem is that the only data I use at work is already in databases... Plus, I'd rather do something different.

Does anyone here have any XLS files with random data from work that they could send me? If it was a list of part numbers and prices, reorder points, dates, etc... I just need to get some raw data that I can turn into a database and create reports from. I don't want anything that has anyone's name on it, etc. Can anyone help me out?

Thanks,

-Scar
 
I'd love to help you, but I love my job more. 🙂 Here's an idea - take the data from your databases at work, wave a magic wand, out pops CSV file, and turn that back into a database. 🙂
 
i can write a script to create a comma or tab delimited file of any size you need, then you could open it in excel and then save it in .xls format

but not tonight, remind me tomorrow if you still need it
 
Column A = Rand() * 10
Column B = Rand() * 100

And so on for as many columns and rows you want - there you go - that is random data for you.
 
How much data? I can think of one spreadsheet from my office that is public record, that I could send to you. It has a mix of different types of data in it -- some columns have text, some have numbers, some are date, etc. Are you looking to build a database w/ a single table, or a relational database w/ multiple tables based upon this single spreadsheet, or what? Need a little more information.

The file I'm thinking of probably has ~30 or so columns and around 97,000 rows.
 
Originally posted by: johnjbruin
Column A = Rand() * 10
Column B = Rand() * 100

And so on for as many columns and rows you want - there you go - that is random data for you.
Click to expand...
Good idea. Thanks. I need to come up with some idea for generating other record data too though to go with the numbers. I suppose I can just make up a bunch of part numbers or something. I was really just hoping someone would tell me they had some report that was public domain they could send my way. 😛
 
Originally posted by: GeekDrew
How much data? I can think of one spreadsheet from my office that is public record, that I could send to you. It has a mix of different types of data in it -- some columns have text, some have numbers, some are date, etc. Are you looking to build a database w/ a single table, or a relational database w/ multiple tables based upon this single spreadsheet, or what? Need a little more information.

The file I'm thinking of probably has ~30 or so columns and around 97,000 rows.
Click to expand...
That would probably do it.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top