HLP Network

News:

HLP Donations Page has been reworked for supporting the site.
Please note that the previous "Tiers" are currently not operational (but will be worked on).
You can still cancel any previous re-occurring donations to make new ones which will go to the new Treasurer Admin (Zacam).

   
« Previous Thread Next Thread »
Print
Pages: [1]   Go Down

Author Topic: Stupid spreadsheet question  (Read 1572 times)

0 Members and 1 Guest are viewing this topic.

Offline Kosh

  • A year behind what's funny
  • 210
Stupid spreadsheet question
on: July 18, 2011, 12:00:51 am
I'm attempting to replicate the style used in this spreadsheet



but I can't seem to get it quite right with Excel, any have any suggestions?
"The reason for this is that the original Fortran got so convoluted and extensive (10's of millions of lines of code) that no-one can actually figure out how it works, there's a massive project going on to decode the original Fortran and write a more modern system, but until then, the UK communication network is actually relying heavily on 35 year old Fortran that nobody understands." - Flipside

Brain I/O error
Replace and press any key
 

Offline BloodEagle

  • 210
  • Bleeding Paradox!
    • Steam
Re: Stupid spreadsheet question
Reply #1 on: July 18, 2011, 12:05:42 am
Rotate your monitor onto its side.  :P
 

Offline Kosh

  • A year behind what's funny
  • 210
Re: Stupid spreadsheet question
Reply #2 on: July 18, 2011, 01:05:47 am
Quote from: BloodEagle on July 18, 2011, 12:05:42 am
Rotate your monitor onto its side.  :P

I wasn't referring to it's tiltedness. :P
"The reason for this is that the original Fortran got so convoluted and extensive (10's of millions of lines of code) that no-one can actually figure out how it works, there's a massive project going on to decode the original Fortran and write a more modern system, but until then, the UK communication network is actually relying heavily on 35 year old Fortran that nobody understands." - Flipside

Brain I/O error
Replace and press any key
 

Offline Flaser

  • 210
  • man/fish warsie
Re: Stupid spreadsheet question
Reply #3 on: July 18, 2011, 01:52:15 am
Quote from: Kosh on July 18, 2011, 12:00:51 am
I'm attempting to replicate the style used in this spreadsheet



but I can't seem to get it quite right with Excel, any have any suggestions?

They're probably using a lot more columns than what you see and made the months grid stick out by manipulating the border rules. They either use a layout by weeks or days (probably the former) but I can't tell that just from a single screen-shot.
"I was going to become a speed dealer. If one stupid fairytale turns out to be total nonsense, what does the young man do? If you answered, “Wake up and face reality,” you don’t remember what it was like being a young man. You just go to the next entry in the catalogue of lies you can use to destroy your life." - John Dolan
 

Offline Davros

  • 29
Re: Stupid spreadsheet question
Reply #4 on: July 19, 2011, 03:03:13 pm
Quote from: Kosh on July 18, 2011, 12:00:51 am
but I can't seem to get it quite right with Excel, any have any suggestions?

Yes, thankfully your answer is so detailed and precise that we all instantly knew the exact problems you had
 

Offline Scourge of Ages

  • 211
    • Steam
    • Twitter
Re: Stupid spreadsheet question
Reply #5 on: July 20, 2011, 03:06:07 am
Hmmm, I'm not quite sure exactly what you are trying to replicate, but I'll see what I can do.
I don't have Excel in front of me right now, but it seems to be a simple combination of heavy, colored borders and an embedded bar graph. http://www.ncsu.edu/labwrite/res/gt/gt-bar-home.html
I don't know why it's all on it's side, but I imagine there's a setting for that somewhere as well.
 

Offline ssmit132

  • 210
  • Also known as "Typhlomence"
    • Steam
    • Twitter
Re: Stupid spreadsheet question
Reply #6 on: July 20, 2011, 05:25:46 am
It's a Gantt chart, isn't it? I think it would be difficult to create one of those in Excel (well, obviously, since you asked for help), at least to make it look like the screenshot you posted. However, a quick search on Google ("Create a gantt chart") turns up this among other resources - maybe give that a go?
 

Offline Kolgena

  • 211
Re: Stupid spreadsheet question
Reply #7 on: July 20, 2011, 11:07:21 am
It looks like all the thin lines are gridlines in excel, but the green bars are smartobjects that are drawn in. Explains why none of them are properly centered in their row.
 

Offline S-99

  • MC Hammer
  • 210
  • A one hit wonder, you still want to touch this.
Re: Stupid spreadsheet question
Reply #8 on: July 21, 2011, 04:49:56 pm
See if you can convert it to a spreadsheet format.
Every pilot's goal is to rise up in the ranks and go beyond their purpose to a place of command on a very big ship. Like the colossus; to baseball bat everyone.

SMBFD

I won't use google for you.

An0n sucks my Jesus ring.
Print
Pages: [1]   Go Up
« Previous Thread Next Thread »