# Time Sheet **URL:** \ **Category:** DWaHMoV\ **Created:** [October 29, 2011, 1:02am UTC](https://forums.sourceruns.org/t/time-sheet/1932 "2011-10-29T01:02:19Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Cameron\_D](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/cameron_d/32/251_2.png) [@Cameron\_D](https://forums.sourceruns.org/u/Cameron_D)\ **Post date:** [October 29, 2011, 1:02am UTC](https://forums.sourceruns.org/t/time-sheet/1932/1 "2011-10-29T01:02:19Z")
> **[Half-Life 2 Done With a High Magnitude of Velocity Timesheet](https://docs.google.com/spreadsheets/d/1FNdgKx4b53GbNA3sM-hyA2LUmOK328B5j-UCA7uGS9M/edit)** > > Frontpage > > Half-Life 2 Done with a High Magnitide of Velocity Timesheet > YouTube Stream: > http:// www. youtube. com/ watch? v= NV-AWxqYAgc, 2 > Torrents: > HQ( 1080p, 30fps with Audio Commentary on track 2): > http:// dl. sourceruns. org/ hl2/... The overall map times are in one sheet, the individual segment times are in the other. EDIT: Someone should double-check the HL2DQ times for me [http://www.archive.org/details/HalfLife2\_13657](http://www.archive.org/details/HalfLife2_13657) ---
**Author:** ![igge](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/i/3d9bf3/32.png) [@igge](https://forums.sourceruns.org/u/igge)\ **Post date:** [October 29, 2011, 7:40am UTC](https://forums.sourceruns.org/t/time-sheet/1932/2 "2011-10-29T07:40:10Z")
Oh wow. The sub-forum is already messing with me. I had already begun creating one myself. 8) I think we should make it an invite-only, to keep the integrity of the run, but I’m not sure everyone agrees. Perhaps a poll or something to decide? Edit: double-checked the times. There was only one tiny flaw. ---
**Author:** ![Cameron\_D](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/cameron_d/32/251_2.png) [@Cameron\_D](https://forums.sourceruns.org/u/Cameron_D)\ **Post date:** [October 29, 2011, 9:41am UTC](https://forums.sourceruns.org/t/time-sheet/1932/3 "2011-10-29T09:41:30Z")
I’m happy to make it a private spreadsheet, everyone will just need to throw me their Google account so I can add them. ---
**Author:** ![execut4ble](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/execut4ble/32/14_2.png) [@execut4ble](https://forums.sourceruns.org/u/execut4ble)\ **Post date:** [October 29, 2011, 9:44am UTC](https://forums.sourceruns.org/t/time-sheet/1932/4 "2011-10-29T09:44:12Z")
Ask igge for my gmail. Ive already gave it to him. ---
**Author:** ![D4rw1N](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/d4rw1n/32/15_2.png) [@D4rw1N](https://forums.sourceruns.org/u/D4rw1N)\ **Post date:** [October 29, 2011, 10:11am UTC](https://forums.sourceruns.org/t/time-sheet/1932/5 "2011-10-29T10:11:22Z")
Did Google+ work as well? Or is it just gmail accounts? ---
**Author:** ![Cameron\_D](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/cameron_d/32/251_2.png) [@Cameron\_D](https://forums.sourceruns.org/u/Cameron_D)\ **Post date:** [October 29, 2011, 10:19am UTC](https://forums.sourceruns.org/t/time-sheet/1932/6 "2011-10-29T10:19:44Z")
They are both attached to the same account (or, should be) ---
**Author:** ![igge](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/i/3d9bf3/32.png) [@igge](https://forums.sourceruns.org/u/igge)\ **Post date:** [October 29, 2011, 10:57am UTC](https://forums.sourceruns.org/t/time-sheet/1932/7 "2011-10-29T10:57:17Z")
Yup. All you need is a Google account. That could be G-mail, Google+ or anything else Google-related. ---
**Author:** ![D4rw1N](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/d4rw1n/32/15_2.png) [@D4rw1N](https://forums.sourceruns.org/u/D4rw1N)\ **Post date:** [January 5, 2012, 12:43am UTC](https://forums.sourceruns.org/t/time-sheet/1932/8 "2012-01-05T00:43:01Z")
I applied with my second email, so I’d appreciate if you could accept the request Cameron. :-\* ---
**Author:** ![UnrealCanine](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/u/cc9497/32.png) [@UnrealCanine](https://forums.sourceruns.org/u/UnrealCanine)\ **Post date:** [January 5, 2012, 1:47am UTC](https://forums.sourceruns.org/t/time-sheet/1932/9 "2012-01-05T01:47:24Z")
I signed in with, so ditto for me ---
**Author:** ![Inexistence](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/i/d26b3c/32.png) [@Inexistence](https://forums.sourceruns.org/u/Inexistence)\ **Post date:** [January 7, 2012, 12:15am UTC](https://forums.sourceruns.org/t/time-sheet/1932/10 "2012-01-07T00:15:04Z")
LET ME ATTER. ---
**Author:** ![doxliy](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/d/8dc957/32.png) [@doxliy](https://forums.sourceruns.org/u/doxliy)\ **Post date:** [January 23, 2012, 3:53pm UTC](https://forums.sourceruns.org/t/time-sheet/1932/11 "2012-01-23T15:53:32Z")
:🙂 ---
**Author:** ![z1mb0bw4y](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/z/6de8d8/32.png) [@z1mb0bw4y](https://forums.sourceruns.org/u/z1mb0bw4y)\ **Post date:** [January 24, 2012, 9:50pm UTC](https://forums.sourceruns.org/t/time-sheet/1932/12 "2012-01-24T21:50:02Z")
Any chance you’d be willing to add me so I can follow along? ---
**Author:** ![Centaurium](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/centaurium/32/206_2.png) [@Centaurium](https://forums.sourceruns.org/u/Centaurium)\ **Post date:** [January 24, 2012, 9:51pm UTC](https://forums.sourceruns.org/t/time-sheet/1932/13 "2012-01-24T21:51:02Z")
almost forgot ---
**Author:** ![Cameron\_D](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/cameron_d/32/251_2.png) [@Cameron\_D](https://forums.sourceruns.org/u/Cameron_D)\ **Post date:** [January 25, 2012, 12:00am UTC](https://forums.sourceruns.org/t/time-sheet/1932/14 "2012-01-25T00:00:17Z")
Alright, I think everyone can access it now ---
**Author:** ![Matmo](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/m/50afbb/32.png) [@Matmo](https://forums.sourceruns.org/u/Matmo)\ **Post date:** [January 29, 2012, 9:14am UTC](https://forums.sourceruns.org/t/time-sheet/1932/15 "2012-01-29T09:14:38Z")
I want access to 😃 ---
**Author:** ![igge](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/i/3d9bf3/32.png) [@igge](https://forums.sourceruns.org/u/igge)\ **Post date:** [February 6, 2012, 6:19am UTC](https://forums.sourceruns.org/t/time-sheet/1932/16 "2012-02-06T06:19:20Z")
Quick question: Shouldn’t we add one second to the first map time because of the penalty? It makes more sense to have the actual time for the maps, since then the improvements would be more accurate? ---
**Author:** ![UnrealCanine](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/u/cc9497/32.png) [@UnrealCanine](https://forums.sourceruns.org/u/UnrealCanine)\ **Post date:** [February 6, 2012, 2:01pm UTC](https://forums.sourceruns.org/t/time-sheet/1932/17 "2012-02-06T14:01:57Z")
We did. Map times are rounded down so ts1 would be 2:36, not 2:37 ---
**Author:** ![igge](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/i/3d9bf3/32.png) [@igge](https://forums.sourceruns.org/u/igge)\ **Post date:** [February 6, 2012, 2:06pm UTC](https://forums.sourceruns.org/t/time-sheet/1932/18 "2012-02-06T14:06:17Z")
Ah. Didn’t know they were rounded down. ---
**Author:** ![execut4ble](https://b-cdn.sourceruns.org/user_avatar/forums.sourceruns.org/execut4ble/32/14_2.png) [@execut4ble](https://forums.sourceruns.org/u/execut4ble)\ **Post date:** [February 6, 2012, 3:19pm UTC](https://forums.sourceruns.org/t/time-sheet/1932/19 "2012-02-06T15:19:23Z")
What’s the Penalty for? ---
**Author:** ![S11](https://b-cdn.sourceruns.org/letter_avatar_proxy/v4/letter/s/d9b06d/32.png) [@S11](https://forums.sourceruns.org/u/S11)\ **Post date:** [February 6, 2012, 3:28pm UTC](https://forums.sourceruns.org/t/time-sheet/1932/20 "2012-02-06T15:28:12Z")
Actually, since I am the one who mostly did all the stuff in the doc, let me explain some shit. Because as far as I worked, penalty is NOT included in the time, unless someone just changed that. I put it in a seperate column for now, because I was unsure what to do with it. Explanation of columns: On the segments sheet: Column D is the most accurate segment time. Column F is the most accurate total time, but does not include penalties. Column G is the same as F, but it’s in hh:mm:ss format. It’s rounded down however, so it’s not exact. Column H I just added and tells whether or not there’s a penalty. On the maps sheet: Column C is a manually entered number simply copied from column E from the segments sheet. I did not round this down however but to the nearest whole number (due to formatting issues, GDoc wouldn’t allow decimals). If we were to include penalty in this, TS1 would read 2:38, unless we round this down like GDoc does. (but if we were to round down all the time, we would build up several seconds that we did play, but would not include in the final time). As a matter of fact, this raises another issue that I’ll come back to later. Column F is all times of column C added. This is only a rough estimate, but should work if we are consistent with rounding in column C. Column K is the penalty in seconds to be added to C’s time. For TS1 this is 1 second, since we had 2 manual saves. for TS2 this will be ½. I see someone added column M, which is the most accurate time displayed on the maps sheet, however, google docs is unable to calculate with this format as far as I found out. **tl;dr: For the most accurate time, refer to columns E and F in sheet “segments”. These columns do not include penalties, nor do all the other columns. Column C in sheet “maps” is rounded to the nearest whole, unlike all the other columns, which are rounded down.** @eXeC: Some rule SDA applies concerning manual saves. Since we’re not going SDA I have decided not to include them in the timing yet but put them in a seperate column for now. hl2dq was SDA though, so they did work with it. It seems only fair to me that we also work with it. But I’m not going to decide on that. [Next page](https://forums.sourceruns.org/t/time-sheet/1932.md?page=2)