The Stream
This particular page is a "stream" of posts, but not necessarily organized by their section. You can put them in order of the first post in the thread, or the last, and you can choose whether to display the first or the last post.
Sort by: Latest Thread | Latest Post in Thread
Thread Direction: Forwards | Backwards
avatar

Pointing a few more features at the search function has made me wish I'd done a few things differently. However, I did make one nice improvement this evening.

Now, when searching, if more than a day passed between two posts, a visual separation will occur between the posts, as well as an indicator as to how long of a time period passed between the posts. I also have it unambiguously describe the direction of the passage of time depending on if you're sorting Ascending or Descending.

#4073, kaiden, +13Y in idkfa | root latest up search | latest
avatar

Anybody need a 50 gallon fish tank, complete with a plecostomus and two eels?

Parents have a coworker, giving away said setup for free.

avatar

Yeah, that sounds tight! Go ahead and empty it, then eat the fish - don't want any waste. Then put it in the garage and park my car in it. I'll get it all out with a forklift when I get back.

avatar

I'm not much on unagi.

avatar

I don't think a 50 gallon tank is as big as you think it is.

avatar

I don't think my car is as big as you think.

avatar

Sorry, I forgot you drive one of these:

avatar

YES. I know someone who would be ALL OVER THAT. Is it gone yet?

avatar

Not that I know of. Contact me off-idkfa.

#4080, kaiden, +13Y | root latest up search | latest
avatar

In cognitive surplus, when I read posts, it doesn't mark them as read.

avatar

Eh, looks like my caching for that was a little overzealous. Should be fixed now.

#4062, kaiden, +13Y | root latest up search | latest
avatar

It's bullshit when I spawn into a server in BF3 with less than two minutes in the round remaining, and just through my natural style mindset of "cap flags kill any unfortunates in my path" I become the round MVP and best player on my team. In only two minutes. Are players really this stupid?

avatar

Maybe you stumbled on a BF3 roleplaying server.

avatar

I just had a great conversation with a dude about playing on Neverwinter Nights roleplaying servers.

#4066, Scrotor, +13Y | root latest up search | latest
avatar

If you haven't seen it already, I highly recommend seeing the BBC's latest efforts with Sherlock (www.imdb.com).

Maybe I'm just uninitiated in terms of Sherlock Holmes mystery stories, but all of the episodes so far have been interesting and engaging, and the character development between Holmes (Benedict Cumberbatch) and John Watson (Martin Freeman) is very entertaining. There are only a handful of episodes out currently, and each is 1.5 hours long. However, I have yet to feel as if the episodes were too long, dragged on, or weren't worth the time investment.

avatar

It is pretty great. Also: DOWNTON ABBEY! Even better than Sherlock.

avatar

Heck Yes. Sunday nights are Downton Abbey nights at our house. Dinner theme rotates somewhere between Papa Johns Pizza and English Tea with dessert for dinner...

#4112, akarmybrat, +13Y | root latest up search | latest
avatar

Should've grabbed it before I left. Watched all of IASIP Season 7 in two sittings.

avatar

It's on Netflix streaming!

avatar

Second season yet?

avatar

Internet down here is much faster than before, but I don't have a netflix account currently (I don't think?). And the internet is still fairly slow.

...which was started +2 days after this thread...
avatar

"Star Wars has EVERY kind of droid! Lots of them!"

Um, droids are unique to Star Wars. They only exist in that universe. Star Wars has, by DEFINITION, every kind of droid.

Man, kids can be so stupid sometimes.

#4050, Wilber, +13Y | root latest up search | latest
avatar

In weather like this, I enjoy driving around with my windows cracked ever so slightly, blaring Israel Kamakawiwo'ole as loud as I can.

avatar

See, I know definitively that there isn't an external API for programmatically posting to idkfa. And I know that it would be non-trivial to automate posting given things like the validation steps, double-posting alerts, etc.

So when I see the same message on Google Plus, Facebook, Twitter, and also idkfa, all around the same time, I feel appreciative that the effort is taken to include this little corner of the Internet.

avatar

Joshus, I lurves the idkfa!

#4059, kitacek, +13Y | root latest up search | latest
...which was started +4 days after this thread...
avatar

I didn't like that the display for <#Recent> threads vs. [#Unread] threads on the discussion areas box was inconsistent (in that, when you're logged in, there may have been no third column displayed if you didn't have unread items). In the case where you're logged in and you've read everything, the Discussion Areas display will "fall back" to displaying the <#Recent> posts rather than omitting the column entirely.

#4038, kaiden, +13Y in idkfa | root latest up search | latest
avatar

Also, I added a few extra search links on the Discussion Areas box. Basically, when you see a number you can click on it, and see which posts correspond to the number represented as a result of a search. When logged in, you can click to search on your unread posts. When logged in or logged out, you can click on the post counts in either the (#Comments) or <#Recent> columns to see which posts correspond to that item, or which posts in that item correspond to the last 50 or so posts.

#4037, kaiden, +13Y in idkfa | root latest up search | latest
avatar

SPDCA: The other direction.

I convinced myself that idkfa needed to have an "unread" feature. That is to say: after I spend incredible amounts of time getting the "read" part right, I felt I might find value in going the opposite direction. So now, instead of a "speedreading" feature, we also have a "un-reading" feature for marking certain posts as unread.

Like the speedreader, it's plugged into the search feature. Basically: search to find a data set you're happy with, whether it be an item, a thread (one of the icon links, if you're interested), a single post, etc., you can choose to mark it as read (speedreading) or unread (un-reading).

This helps me in a few ways:

  1. When I want to test this feature, I can now un-read without having to go into the database.
  2. If you want to save something for later, you can mark it as unread.
  3. If you did a "speedread," but mistakenly marked something as read when you didn't want to, you can undo your mistake.

I realize this probably isn't an absolutely necessary feature. But it makes the seen/unseen mechanism more complete, and gives you control over it to make it conform to the way you want to read a post.

avatar

I fixed a bug with the un-reader that would try to update a boundary after it had been marked for deletion. Sorry if this caused issues for people. Please feel free to report if you have errors on these features.

#4083, kaiden, +13Y | root latest up search | latest
...which was started +2 days after this thread...
avatar

Also, I was a bit bored, and looking at forum features on other sites / softwares. I liked the idea of abbreviating post counts by listing them in their appropriate kilo- (K), mega- (M), or giga- (G) notation. It's unlikely we'll ever see 1,000,000 posts, or even 1,000,000,000, but it saves a little bit of space.

avatar

Well, to be accurate, you really need the symbol for kilo- to be lower case. To conform with SI rules and all.

avatar

I always get confused between the two. Particularly when some people choose to make a distinction between little-k and big-K when determining whether it's a base-2 kilo- or a base-10 kilo-.

Fixed now.

#4035, kaiden, +13Y | root latest up search | latest
avatar

SPDCA: Cookies. For the longest time I've fought with browser cookies.

(Browser cookies are small, named variables passed between a web server and a web browser. They are what allow servers to maintain stateful information about you (Are you logged in? What is in your shopping cart? etc.) over the course of your browsing session. They often looked upon as the least sophisticated part of the HTTP protocol specification.)

In all of my previous projects, I have simply tried to get the cookies "right," and then walk away and never touch it again. In v2, they were a goddamn mess. Not only was I passing back and forth your username (something that's easy to guess and/or forge), I was also passing back and forth your plaintext, unencrypted password (something that is notoriously easy to spot if you were, say, listening in on a coffee shop wireless, etc.). Even worse: upon every page access I tried to "update" the cookie so its expiration time would be pushed further out. Each time I did so, I told the server to re-send your password in order to update the timestamp. It's probably for the best that I shut that baby down.

For v3, I decided I would try to address the problem. PHP (the programming language I designed idkfa in) has built-in session tracking functionality that takes care of things like encryption, session creation / breakdown, complex data types stored within the session, and session validation.

Unfortunately that decision, up until now, has caused my idkfa logins to last around 24 minutes unless you were a) a user actively accessing the site, or b) sitting on auto-update.

This is for the following reasons:

  • The session_set_cookie_params and session_cache_expire functions both take time values to determine how long a cookie should be issued for, and how long that cookie should be in the system's cache. The former takes its time value in seconds. The second takes its time value in minutes. The documentation reflects this poorly.
  • The session_start function does not update the timestamp on a cookie (that is, doesn't tell your browser to move its expiration window further upon page access). It just builds the session in memory (if the session exists), but nothing else. I had assumed otherwise, and without discovering session_set_cookie_param, I wasn't setting any timestamp at all (leaving it up to the web browser to clear the cookie entirely when it shut down).
  • There's a chicken-and-the-egg problem when it comes to maintaining "who is online?" records in a database. You can tell a page to start a session, but you can't reliably ask if the session's cookie was "set" until a page-load later. So how do you say "this is when somebody logged in?" Well... I haven't quite figured that out yet. As of now, I still make a few bad assumptions, but it works out in 90% of the cases. Where it breaks down is if a web client (say, a search engine accessing the page) doesn't accept a cookie. Because my script is always trying to set a cookie, and then maintain its "online" status, I end up generating hundreds of "online" records for a single user. (Somebody was doing this last night, which is why I was looking at this in the first place).
  • Finally, even though I figured out the cookie expiration stuff, I was still having problems keeping my sessions from expiring. Turns out, it has a lot to do with how idkfa is hosted. By default, my hosting service stores all of its session data in a single directory. PHP, to save time, only "expires" session data after a random period (usually shortly after when the time the session was to expire at the time of session creation), where if the "dice" are rolled a certain way, PHP performs its "garbage collection" routine, and removes old session data. The problem with this, though, is PHP doesn't care about which user, or which website, or really about anything when it comes to kicking off its garbage collection. Here's the kicker: if any PHP instance thinks it needs to garbage collect, it can destroy any cookies in its session storage directory. This means that even if I was setting my session lifetimes far, far into the future, anybody who set theirs to the defaults (~24 minutes) had the potential to destroy my sessions along with theirs.

When I woke up this morning I was surprised to see myself still logged in to idkfa. It's been a while. But I think I've got it "correct" now, but I'm still watching it.

#4030, kaiden, +13Y in idkfa | root latest up search | latest
...which was started +2 days after this thread...
avatar

This...this explains so much. About college. And about now.

avatar

I guess I know why I never became an engineer.

avatar

Still better than episodes 1, 2, and 3. And still less gay than Twilight.

avatar

Watched a couple minutes of it this morning, that is a really awesome project. Will watch the whole thing at some point in the new future.

avatar

Also, sadly, I stumbled onto an article this morning that is relevant. However, for once, the unlucky pseudo-nun isn't an engineer.

A real life 39-year-old virgin. (www.thesun.co.uk)

avatar

That article makes me feel nauseous.

avatar

No cats in her house, just cat sized dildo's. It's a choice we all have to make in life, to not be pressured into having sex with Mr. Wrong, but instead with inanimate objects shaped like loneliness.

#4025, MrFood, +13Y | root latest up search | latest
avatar

Added blockquotes to the list of available formatting/tag options in idkfa posts. For example:

...you can now quote things (and have things be formatted without the quotes) and have them appear indented. This is a good way to distinguish your own text from lengthy, quoted text.

avatar

I just got PTSD flashbacks from having to write using MLA formatting in high school. Thanks for adding block quotes, now I can keep Mrs. Butler happy, wherever she is now.

avatar

Also, because my brain works wrongly, I added the "pre" tag to the list of approved HTML tags. There isn't a button... so you have to look at the code... to get the pre tag. Ha... ha... ha.

ini_set("session.gc_maxlifetime", COOKIE_EXPR_TIME );
ini_set("session.save_path", SESS_PATH );
// Get some cookie modifications going
session_name( SESS_NAME );
# $ck = session_get_cookie_params();
# $ck['lifetime'] = $ck['lifetime'] + COOKIE_EXPR_TIME;
session_set_cookie_params( COOKIE_EXPR_TIME, COOKIE_PATH );
session_cache_expire( COOKIE_EXPIRE_TIME / 60 );

// Globally, start or resume current session
session_start();

# We've already got our cookie set.
$is_session_available = false;
if( isset( $_COOKIE[SESS_NAME] ) ) {
    $is_session_available = true;
    setcookie(
        SESS_NAME,
        session_id(),
        time()+COOKIE_EXPR_TIME,
        COOKIE_PATH
    );
}
 

(Actually, it's a little bit unwieldy at the moment. But as I find case to put more code in, I'll see if I can't improve upon it).

#4033, kaiden, +13Y | root latest up search | latest
...which was started +3 days after this thread...
avatar

Congress: "We love to give blowies scratch the back of those who pay us! Stop Online Piracy! Protect IP!

The Internet:  We're here.

Congress: "Um. Nevermind. We'll give them blowies scratch their back later."

avatar

BWHAHAHAHAHAHAHHA. yes.

avatar

That. Is. Amazing.

avatar

That is awesome, especially the "oh shit I just fubared this jump"look on the cat is amazing.

#4042, kitacek, +13Y | root latest up search | latest
avatar

Fixed up some of the styling on the search page. SPDCA.

(www.reddit.com)

avatar

Lol

#4011, Governator, +13Y | root latest up search | latest
...which was started +1 day after this thread...
avatar

Another "nice to have" thing I've wanted for a while: for plain links that are excessively long, I am "collapsing" them so that they don't mess with the formatting of the comment boxes. You can still explicitly link things of arbitrary length (making normal text appear as a link (php.net)), but using a lengthy URL (https://picasaweb.google.com/lh/photo/ywObKSO0AlKzBeedzVyADi2TBFbFtxRPtqpluxrkO2Q?feat=directlink (picasaweb.google.com)) will attempt to collapse things, like so:

https://picasaweb....O2Q?feat=directlink (picasaweb.google.com)

So the question is: why am I collapsing in certain places, and not others? Well, it depends on your browser. Some of them (apparently Chrome, and IE) automatically wrap links pasted into special "textareas" like the comment box with the correct linking tags. I might try to address this in the future to collapse explicit linking as well, but we'll see.

avatar

Alright... I've got this handled "better" now, though there's still the possibility that explicit links can be fairly lengthy and mess with the formatting of the comment box. However, with every link there is now an indicator next to it that says the host name of the site the link actually goes to. For example:

http://idkfa.com/v3/v_thread.php?thread_id=3995&msg_id=3995 (reddit.com)

Note that the link destination is different than the host domain indicated after. This should help you decide whether you want to click on a link.

avatar

Well, there goes the ability to goatse anyone.

avatar

Lol way to bring back 2001.

avatar

I was into link misdirection before it was cool. Sadly, I don't have a 5 digit slashdot UserID (slashdot.org), so I wasn't there for the birth of their link shortening/verification system. (books.google.com) I'm going to put myself out of nerd misery now...

#4005, conrad, +13Y | root latest up search | latest
avatar

Why didn't anyone tell me Jonathan Coulton released a new album (secure.jonathancoulton.com) in September?

(It features Sara Quin, of Tegan and Sara fame, singing Still Alive.)

avatar

So did you buy it?

avatar

Yessir.

avatar

Wait, I lost internet for like two days... who the hell is Jonathan Coulton?

avatar

He's an independent singer/songwriter, writes a lot of "geek" rock, including songs that were featured in the computer games Portal and Portal 2.

#4010, kaiden, +13Y | root latest up search | latest
...which was started +1 day after this thread...
avatar

This section hasn't been used lately. Unless anybody has reason otherwise, I'm going to archive it.

avatar

Yes! That's a little joke.. based on the name of the section.. Also, I don't use it, but I'm not in the troop.

avatar

Well, John's got months until he can advertise in here, and you folks seem to have gotten bored with scrutinizing... so I'd say do it! ;)

#3980, Scrotor, +13Y | root latest up search | latest
avatar

New Escape Characters article, "Toolmakers," Jan 15, 2012.

avatar

Also, I plugged "2^2147483648" into Wolfram Alpha (http://www.wolframalpha.com/input/?i=2%5E2147483648 (www.wolframalpha.com)), which gave me a) Hope, and b) a better answer:

avatar

Also, slightly related, an article about Hypercard: http://www.loper-os.org/?p=568 (www.loper-os.org)

This guy's argument is that Apple/Steve Jobs killed Hypercard because it weakened the distinction between the use and programming of a computer. This guy is sort of crazy... and even though he calls my kind the "autistic software engineer," he's still my kind of crazy. He wants people to do more interesting things with computers.

avatar

"He wants people to do more interesting things with computers."

Oh I see. Like more widgets embedded in my Facetwitter+ feed?

/thousandyardstare

avatar

That... would... be... fine...

#4014, kaiden, +13Y | root latest up search | latest
avatar

As per some advice from Josh, I made a new YouTube channel especially for all the dirty signs I will be signing:

http://www.youtube.com/user/ASLTerpCat/videos (www.youtube.com)

Tell your parents. Enjoy.

avatar

Ah, this is so good.

avatar

Reading some of the comments (www.youtube.com)...

It's too bad you're being "disliked" not for your technical merit, but because laymen think you're being rude or contrary to Kristen's original videos, or simply being "attention-seeking."

From someone who has to constantly defend my high towers, I salute you.

avatar

Sheesh, some of those comments are brutal and childish. But the detached nature of internet communication breeds such things. Oh well.

#3996, Scrotor, +13Y | root latest up search | latest
...which was started +1 day after this thread...
avatar

Random thought/idea: So say I see that there's 3 new posts that I haven't read in Mercy General. I click on one of them and they all happen to be in the same thread, but since I clicked on one of them, they're all counted as read. The big thing here though is how do I distinguish which ones I haven't read yet on the thread screen? Can the windows be outlined or something to show that they're new? Maybe I'm missing it, but that would be nice. Then if I hit F5, since they're already read, the outline goes away.

avatar

(nods) Yeah, I know what you mean. I've entertained the idea, but there's sort of an "order of operations" problem. When I'm rendering a page, I have a choice to make:

  1. I update my viewing history, and then set the rest of the functions loose, each function making its own decisions on whether it has seen a message or not (simpler, how I'm doing it now).
  2. Wait to update the history until after I've called all of the functions I would need to otherwise display "seen" or "unseen" on (I tried this once, and it ended in tears).

With #1, everything generates with the same consistent, post-viewing history. Everybody thinks they've seen everything, even what's being displayed for the first time.

With #2, I would be playing a bit of a shell game. Every time I update a page, I would need to be cognizant of "Does this function need the pre-viewing history? Or the post viewing?" If ever I screwed that up, or introduced something that always needed pre-viewing or post-viewing, I would have to reorder things in my rendering mechanism. This isn't fun.

I might be able to make a modification... essentially, have my "maintain_viewing_history" function return a list of things it considered "unseen" before its call. Then, I would have to change a number of other functions to pay attention to that. It would mean dragging even more parameters through the different rendering calls, but it would be less hellish in the end.

I'll think about it.

avatar

Make it so Number One. Engage!

avatar

Could you make it so it only looks at the history if being called from the Unread screen? Not sure if that would really help or not though.

avatar

Maybe, though, the case where they can get to a thread without coming to it from the "unread" screen is possible, and fairly common (Searching, Item View, Latest Posts, etc.).

I've got an idea, I think. I just hope it isn't too disruptive to what I've got in there already.

avatar

Side thought: Don't you two work in the same building? This reminds me of IMing someone who sits right next to you. Only the 1990s BBS version.

avatar

Our cubicle area is home to people who also have opinions on coding, and like to interject them, and then turn them into loud conversations about football and bigotry. This is much less painful.

(Also, 1990's BBS system? I didn't do anything to deserve that.)

avatar

In all fairness, it was a bit of a cheap shot. I'm sorry for punching you in the internet testicles.

I suppose, when you're surrounded by quasi-nerds who love football, the best course of action is subterfuge. Well played, gents.

avatar

Man, I got some hardcore porn in those days from BBSes! *Sigh* Those were the days..

avatar

Big beautiful sadists? HOTTT.

avatar

Sadists need love too.

avatar

It was a bit of a pain in the ass, but now when a thread detects that a message is unread (or was unread just before it was displayed), it will mark it with a slightly different color than the rest of the messages in the thread.

I chose green.

avatar

It's a lovely shade of green, thanks for your hard work. Take the rest of the day off.

#3976, Governator, +13Y | root latest up search (edited)
avatar

Good job! You win.

You should make it so we can set the color.

avatar

I've tasted enough victory today. But thanks.

avatar

I had an issue with "classic view."

I made the change in this thread with full view in mind, assuming that all IDs passed through the maintenance function would be marked as read. Classic view behavior is different, marking only the post you're viewing as read, not the entire thread.

I found a way around it that allows the same function to serve both cases, but it's definitely not pretty. If I stare at it some more, I might figure something else out, but for now it is working.

I miss classic. It had a certain, understated elegance. But it did take longer.

avatar

I've also updated the "streaming" page to indicate which of the threads/post are unread. It's... actually pretty cool, being able to scroll through a bunch of posts and see which are new among the ones you've already seen. I recommend checking it out.

However, because the streaming page has the potential to display many, many posts, and unintentionally mark as read more posts than you're wanting, I'm keeping it from updating your history unless you click on a thread explicitly. Maybe I can make this a user selectable option in the future, but for now erring on the side of caution.

Remember also that there is a "speedread" function under Shortcuts > More, or through the Search feature by clicking on "Mark these posts as read" for a given search result. Seriously, it's useful.

avatar

And for completeness, I've updated the Item pages to reflect seen/unseen coloring upon page render. It looks pretty good, I think. Not only shows thread topic, thread structure, and approximate posting time, but also now shows which posts within the thread are relevant per your viewing history.

avatar

Good job all around really. I did enjoy the pimento green, but the orange isn't so bad either.

avatar

Success!

#3994, kaiden, +13Y | root latest up search | latest
avatar

I need to know something regarding your workplace, specifically, how you work with Excel (or other spreadsheet applications).

  1. Generally, what do you use Excel for? Keeping track of something (inventory, contact information, etc)? Performing a calculation? Graphs?
  2. How often do you use it a day? And is it just repeated use (maybe same problem, different data set)? Or solving different problems entirely?
  3. How many Excel spreadsheets do you share with coworkers or groups? How do you share it (just passing around files, or a network drive, a versioning system, Sharepoint, etc.)?
  4. If you're working with a set of data, is that data ultimately stored in Excel? Or do you import it or copy it in from somewhere else?
  5. Have you used a spreadsheet that had "macros" or scripts running on it? If so, what did the script do within the spreadsheet?
  6. If a particular spreadsheet were to completely disappear, how critical would that be to business function?
  7. If you had to choose, what would you say is Excel's best feature? And the one you couldn't live without? And what would be its worst?

Thanks for your time.

avatar

1. Format data, process data, organize data.

2. I use it many times a day. Typically for the same sort of shit.

3. I share a lot, using a shared drive. Only way we pass around data really.

4. It is stored in excel, but exported to Word for reports.

5. No macros at this point because I hate them, but probably should start implementing them.

6. It would suck, but ultimately the data is stored elsewhere. But backups are created daily.

7. Excel's best feature is that anyone can use it... and because of that it is necessary. It's worst feature is that it fucking sucks (ie data manupulation is difficult)

avatar

1. I use Excel to conduct data exploration ('Is there something interesting going on here?' ) perform complex calculations, display results in organized tables or charts, and report information to others.

2. I use excel approximately half of my working day, maybe more. I used to use it exclusively, but I now conduct much more analysis using SQL and Tableau. Some of my reports are recurring (weekly, monthly, etc), and I have created dashboard like workbooks that dynamically update to minimize the work required to refresh data. But most of my work iis comprised of special data requests or long term, changing analyses.

3. About half of my workbooks get shared. Special requests are most often sent via email. Larger reports and recurring documents are posted to Sharepoint.

4. It is very, very rare that I store data in excel. I almost exclusively import it from SQL databases. The exception is census data found online. And even that is a paste at a moment in time. Data permanently stored in excel scares me. Seriously.

5. I have used quite a few docs with Macros (though I seem to use them less and less). They would run printing scripts, which would cycle through dynamic dashboard views; update formatting on large data sets; or import data directly from external data sources like other workbooks or SQL Server.

6. I don't have any workbooks that are single points of failure in any given process. My recucurring reports have many copies, and I have sql code to document my data pulls. Some analysis results could be painful to lose (a lot of successive calculations) but I could recreate them. Truly, the point of failure is me. I work alone for the most part, and other folks in the office probably couldn't pick up my work easily if I were hit by a bus.

7. Oh gosh. Excels best feature...I suppose it is the transparency of it's functionality. I can trace all its calculations, and 'watch' analyses happen visually, which I just can't do with SQL code. I couldn't live without Excel's selection of lookup functions. The worst is a tie between charting (and all the bugs inherent) and the lack of count distinct.

avatar

1. performing calculations, occasionally graphing. also, putting together equipment schedules to use with Xcel2CAD to put them into engineering drawings.

2. depends on the project i'm working on and where I am in the project. at times, i will work with excel for calculations for up to a full week, then only occasionally in a project after that. in general, its the same basic calculations with new data sets since the same calculations need to be done for each building or project i work on.

3. there are anywhere from 3 or 4, and up to 20, spreadsheets that are shared among my coworkers for review and/or input into xcel2cad. Most of the time, they are stored on our server (which has automatic backups), and we usually make incremental copies to show our progress on calculations. when i need to direct other coworkers to my spreadsheets, i usually email or IM them a link to the directory. some coworkers attach them to an email, a practice discouraged since it usually creates several working copies of a calc.

4. some of the calculation variables are measured or quantified from engineering documents, and some are brought in from codes, standards, manufacturer's information, or other sources.

5. yes. i've never programmed macros or scripts myself, but current and previous coworkers have. I use their spreadsheets and change the data as I see fit. usually the script compares an input cell to a table of data copied into another worksheet in the file, and outputs the answer from the table. the table is input by hand into the worksheet from a code, standard, manufacturer's information, or other sources.

6. minimal. we have enough copies of calculations and backlog of experience that it would not severely hinder our business operations. Now, if a whole server nuked itself, or we lost computing functions altogether, that's a serious issue and will cause delays. Ultimately, data could be tabulated and calculated by hand, but that would significantly increase our working time.

7. =CONCATENATE(text1,text2...). Absolute and Relative cell values. cell borders and shading, and text coloring, assisting in the presentation of data. those are the ones that came first to mind, but if I thought about it I could probably come up with more.

#3946, kitacek, +13Y | root latest up search | latest