The Edcawber Principle

greent

edinburgher wrote: »

Burning MFW question - how do you draw the roof of an Excel house for a house spreadsheet? :rotfl:

I think (from memory) that I did mine as stepped - eg: 10 tiles, line above 8 tiles, above that 6 (and then topped it with a chimney )

edinburgher

Guys - stepped is too easy - this isn't Minecraft

greent

I like easy!

julicorn

edinburgher wrote: »

Guys - stepped is too easy - this isn't Minecraft

:rotfl:

Best of luck with your job application!

smallholdingsister

Hi Ed. Good luck with the promoted post.

Suffolk_lass

edinburgher wrote: »

Was wondering if there was some way to use the border controls to put a diagonal line across multiple cells? I can merge them, but then I can't use individual cells as payment blocks. First world problems?

You could "insert-shape-left and right hand triangles" for the sides and change their colour when you pay them off. You can drag the shape corners so they fit the size you want (e.g. one cell or many).

gallygirl

edinburgher wrote: »

Was wondering if there was some way to use the border controls to put a diagonal line across multiple cells? I can merge them, but then I can't use individual cells as payment blocks. First world problems?

Go on to the borders drop down menu and select More Borders. That should bring up a square box with Text written in it and L's (2 inverted) in the corners. Click on either the diagonal line in the boxes below the main box, or just on where the diagonal line would be in the main box.

Sorry, not explained that very well . You can still use the box for text and calculations but you can't colour in just half of it . Though you can make a stab at it with fill effects it doesn't really work.

SuperSecretSquirrel

edinburgher wrote: »

Guys - stepped is too easy - this isn't Minecraft

Well, a spreadsheet is an axis aligned grid, so it's more Minecraft than not You can draw diagonal borders through a cell, but I've not come across a way to cleanly split the background fill colour.

Of course, both Minecraft and crysis at full detail are displayed on a 2D matrix of pixels, so you could cheat, zoom out to a ridiculous degree, and have a stepped roof that looks like a smoothish roof (maybe, if you squint a little). A hi-res spreadsheet house if you will. You'd need to hide the grid lines, and do an awful lot of cell merging...

It would no doubt be easier to draw a house in a drawing app (paint would do) draw a grid over it, and use the flood fill tool to colour in your blocks and diagonal half blocks

edinburgher

So a giant spreadsheet that can only be viewed from space - the great wall of spreadsheets - if you will? :rotfl:

Goldiegirl

Hi Ed, hope you are keeping well.

I'm here seeking a bit of info.

If I remember rightly, I think you had solar panels fitted? The other day we started talking about this. The future seems a bit uncertain right now, and it seems an attractive idea to generate our own electricity.

We have a quite large south facing roof, which is never in the shade, so it's something we could do probably quite easily.

Just wondered if you had any comments about your experiences. e.g. approx cost of installation, do you generate enough electricity for your needs and do you 'sell' much to the national grid. Also, any regrets about having the solar panels?

I'd be really interested in your thoughts

Thanks