Television Time Code Program

C

ContessaZ

New Member
Joined
Aug 29, 2002
Messages
7
I'm a script supervisor for live TV shows and I'd like to create a backtiming program in excel. This has been done, but hasn't been released and it was a spreadsheet based in excel.

Does anyone have any information on this?

Please e-mail me at contessaz@aol.com if you have information, or need more information about what I need.

Thanks!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
On 2002-08-30 16:19, ContessaZ wrote:
I'm a script supervisor for live TV shows and I'd like to create a backtiming program in excel. This has been done, but hasn't been released and it was a spreadsheet based in excel.

Does anyone have any information on this?

Please e-mail me at contessaz@aol.com if you have information, or need more information about what I need.

Thanks!
Click to expand...

ContessaZ - welcome to the board!

30 views for your post & no replies yet - I conclude that we need more info!!

What do you mean by 'backtiming programme'? You say you'd like to create one - how about posting back with a bit more info on what data you'll be using, what outcomes you'd expect. May be give an example..

Paddy
 
Upvote 0
We need to create a spreadsheet that subtracts or adds time as the live show is in progress. We woud sync up the internal Macintosh computer clock to the time code and would need a 1-button key that we can press at the end of each segment to enter the current time. There needs to be 4 columns: segment time, cumulative time, running time, and the difference. Each show is different, so we would need room to change it as needed.

Does that make sense??

Thanks so much for any help you can offer...
Tess
 
Upvote 0
There's already a 'one button click' shortcut for entering time in excel - press cntrl + shift + ;

So, the rest will depend on the details of the calculations.

Care to post a worked through example of what you'd expect for a particular segment?

Paddy
 
Upvote 0
Thanks, Paddy,

I'd love to send you a working rundown based on what we need. If you could e-mail me, I'd send it to you and you could better see what I'm talking about.

Thanks!
Tess
 
Upvote 0
As a new person myself, I have learned that posting your request and subsequent help allows the free exchange of knowledge so that others might benefit from the findings.

Would appreciate your post through this forum so we may all benefit..

good luck with your question ...i found the help excellect.

pll
 
Upvote 0
Is there a way to post a file to the board? That's what my last post was in reference to.

Thanks!
Tess
 
Upvote 0
I've attached an HTML version of an example of a rundown I've been working on... let's hope it works. If it doesn't, I can e-mail a version.

I need a macro that will insert the current time into a cell in column H, then jump to the next cell in column H with a 0:00:00 value and use the macro again, while the previous time remains unchanged.

Thanks for any help!
Tess



<html xmlns:x="urn:schemas-microsoft-com:eek:ffice:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=macintosh">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<![if !supportTabStrip]>
<link id="shLink" href="8th%20STLS%20-%20RUNDOWN_files/sheet001.htm">
<link id="shLink" href="8th%20STLS%20-%20RUNDOWN_files/sheet002.htm">

<link id="shLink">

<script language="JavaScript">
<!--
var g_iIEVer=0;

var c_lTabs=2;

var c_rgszSh=new Array(c_lTabs);
c_rgszSh[0] = "8th STLS-SHORT RUNDOWN (3)";
c_rgszSh[1] = "8th STLS-QUICKIE RUNDOWN (2)";


var c_rgszClr=new Array(8);
c_rgszClr[0]="window";
c_rgszClr[1]="buttonface";
c_rgszClr[2]="windowframe";
c_rgszClr[3]="windowtext";
c_rgszClr[4]="threedlightshadow";
c_rgszClr[5]="threedhighlight";
c_rgszClr[6]="threeddarkshadow";
c_rgszClr[7]="threedshadow";

var g_iShCur;
var g_rglTabX=new Array(c_lTabs);

function fnBuildFrameset()
{
var szHTML="<frameset rows="*,18" border=0 width=0 frameborder=no framespacing=0>"+
"<frame src=""+document.all.item("shLink")[0].href+"" name="frSheet" noresize>"+
"<frameset cols="54,*" border=0 width=0 frameborder=no framespacing=0>"+
"<frame src="" name="frScroll" marginwidth=0 marginheight=0 scrolling=no>"+
"<frame src="" name="frTabs" marginwidth=0 marginheight=0 scrolling=no>"+
"</frameset></frameset><plaintext>";

document.open("text/html","replace");
document.write(szHTML);
document.close();

fnBuildTabStrip();
}

function fnBuildTabStrip()
{
var szHTML=
"<html><head><style>.clScroll {font:8pt Courier New;color:"+c_rgszClr[2]+";cursor:default;line-height:10pt;}"+
".clScroll2 {font:10pt Arial;color:"+c_rgszClr[2]+";cursor:default;line-height:11pt;}</style></head>"+
"<body onclick="event.returnValue=false;" ondragstart="event.returnValue=false;" onselectstart="event.returnValue=false;" bgcolor="+c_rgszClr[4]+" topmargin=0 leftmargin=0><table cellpadding=0 cellspacing=0 width=100%>"+
"<tr><td colspan=6 height=1 bgcolor="+c_rgszClr[2]+"></td></tr>"+
"<tr><td style="font:1pt"> <td>"+
"<td valign=top id=tdScroll class="clScroll" onclick="parent.fnFastScrollTabs(0);" onmouseover="parent.fnMouseOverScroll(0);" onmouseout="parent.fnMouseOutScroll(0);"><a>«</a></td>"+
"<td valign=top id=tdScroll class="clScroll2" onclick="parent.fnScrollTabs(0);" ondblclick="parent.fnScrollTabs(0);" onmouseover="parent.fnMouseOverScroll(1);" onmouseout="parent.fnMouseOutScroll(1);"><a>&lt</a></td>"+
"<td valign=top id=tdScroll class="clScroll2" onclick="parent.fnScrollTabs(1);" ondblclick="parent.fnScrollTabs(1);" onmouseover="parent.fnMouseOverScroll(2);" onmouseout="parent.fnMouseOutScroll(2);"><a>&gt</a></td>"+
"<td valign=top id=tdScroll class="clScroll" onclick="parent.fnFastScrollTabs(1);" onmouseover="parent.fnMouseOverScroll(3);" onmouseout="parent.fnMouseOutScroll(3);"><a>»</a></td>"+
"<td style="font:1pt"> <td></tr></table></body></html>";

frames['frScroll'].document.open("text/html","replace");
frames['frScroll'].document.write(szHTML);
frames['frScroll'].document.close();

szHTML =
"<html><head>"+
"<style>A:link,A:visited,A:active {text-decoration:none;"+"color:"+c_rgszClr[3]+";}"+
".clTab {cursor:hand;background:"+c_rgszClr[1]+";font:8pt Arial;padding-left:3px;padding-right:3px;text-align:center;}"+
".clBorder {background:"+c_rgszClr[2]+";font:1pt;}"+
"</style></head><body onload="parent.fnInit();" onselectstart="event.returnValue=false;" ondragstart="event.returnValue=false;" bgcolor="+c_rgszClr[4]+
" topmargin=0 leftmargin=0><table id=tbTabs cellpadding=0 cellspacing=0>";

var iCellCount=(c_lTabs+1)*2;

var i;
for (i=0;i<iCellCount;i+=2)
szHTML+="<col width=1><col>";

var iRow;
for (iRow=0;iRow<6;iRow++) {

szHTML+="<tr>";

if (iRow==5)
szHTML+="<td colspan="+iCellCount+"></td>";
else {
if (iRow==0) {
for(i=0;i<iCellCount;i++)
szHTML+="<td height=1 class="clBorder"></td>";
} else if (iRow==1) {
for(i=0;i<c_lTabs;i++) {
szHTML+="<td height=1 nowrap class="clBorder"> </td>";
szHTML+=
"<td id=tdTab height=1 nowrap class="clTab" onmouseover="parent.fnMouseOverTab("+i+");" onmouseout="parent.fnMouseOutTab("+i+");">"+
" "+c_rgszSh+" </td>";
}
szHTML+="<td id=tdTab height=1 nowrap class="clBorder"><a id=aTab> </a></td><td width=100%></td>";
} else if (iRow==2) {
for (i=0;i<c_lTabs;i++)
szHTML+="<td height=1></td><td height=1 class="clBorder"></td>";
szHTML+="<td height=1></td><td height=1></td>";
} else if (iRow==3) {
for (i=0;i<iCellCount;i++)
szHTML+="<td height=1></td>";
} else if (iRow==4) {
for (i=0;i<c_lTabs;i++)
szHTML+="<td height=1 width=1></td><td height=1></td>";
szHTML+="<td height=1 width=1></td><td></td>";
}
}
szHTML+="</tr>";
}

szHTML+="</table></body></html>";

frames['frTabs'].document.open("text/html","replace");
frames['frTabs'].document.charset=document.charset;
frames['frTabs'].document. write(szHTML);
frames['frTabs'].document.close();

}

function fnInit()
{
if (parent.window.g_iIEVer>=4) {
if (document.readyState=="complete"
&& frames['frTabs'].document.readyState=="complete")
{
g_rglTabX[0]=0;
var i;
for (i=1;i<=c_lTabs;i++)
with (frames['frTabs'].document.all.tbTabs.rows[1].cells[fnTabToCol(i-1)])
g_rglTabX=offsetLeft+offsetWidth-6;
}
else
window.setTimeout("fnInit()",150);
}
}

function fnGetIEVer()
{
var stzAgent=navigator.userAgent;
var iVer=parseInt(navigator.appVersion);
if (stzAgent.indexOf("MSIE")!=-1 && iVer<4)
g_iIEVer=3;
else if (stzAgent.indexOf("MSIE 4")!=-1)
g_iIEVer=4;
else
g_iIEVer=5;
}

function fnTabToCol(iTab)
{
return 2*iTab+1;
}

function fnNextTab(fDir)
{
var iNextTab=-1;
var i;

with (frames['frTabs'].document.body) {
if (fDir==0) {
if (scrollLeft>0) {
for (i=0;i<c_lTabs&&g_rglTabX<scrollLeft;i++);
if (i<c_lTabs)
iNextTab=i-1;
}
} else {
if (g_rglTabX[c_lTabs]+6>offsetWidth+scrollLeft) {
for (i=0;i<c_lTabs&&g_rglTabX<=scrollLeft;i++);
if (i<c_lTabs)
iNextTab=i;
}
}
}
return iNextTab;
}

function fnScrollTabs(fDir)
{
var iNextTab=fnNextTab(fDir);

if (iNextTab>=0) {
frames['frTabs'].scroll(g_rglTabX[iNextTab],0);
return true;
} else
return false;
}

function fnFastScrollTabs(fDir)
{
if (c_lTabs>16)
frames['frTabs'].scroll(g_rglTabX[fDir?c_lTabs-1:0],0);
else
if (fnScrollTabs(fDir)>0) window.setTimeout("fnFastScrollTabs("+fDir+");",5);
}

function fnSetTabProps(iTab,fActive)
{
var iCol=fnTabToCol(iTab);
var i;

if (iTab>=0) {
with (frames['frTabs'].document.all) {
with (tbTabs) {
for (i=0;i<=4;i++) {
with (rows) {
if (i==0)
cells[iCol].style.background=c_rgszClr[fActive?0:2];
else if (i>0 && i<4) {
if (fActive) {
cells[iCol-1].style.background=c_rgszClr[2];
cells[iCol].style.background=c_rgszClr[0];
cells[iCol+1].style.background=c_rgszClr[2];
} else {
if (i==1) {
cells[iCol-1].style.background=c_rgszClr[2];
cells[iCol].style.background=c_rgszClr[1];
cells[iCol+1].style.background=c_rgszClr[2];
} else {
cells[iCol-1].style.background=c_rgszClr[4];
cells[iCol].style.background=c_rgszClr[(i==2)?2:4];
cells[iCol+1].style.background=c_rgszClr[4];
}
}
} else
cells[iCol].style.background=c_rgszClr[fActive?2:4];
}
}
}
with (aTab[iTab].style) {
cursor=(fActive?"default":"hand");
color=c_rgszClr[3];
}
}
}
}

function fnMouseOverScroll(iCtl)
{
frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[5];
}

function fnMouseOutScroll(iCtl)
{
frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[2];
}

function fnMouseOverTab(iTab)
{
if (iTab!=g_iShCur) {
var iCol=fnTabToCol(iTab);
with (frames['frTabs'].document.all) {
tdTab[iTab].style.background=c_rgszClr[5];
}
}
}

function fnMouseOutTab(iTab)
{
if (iTab>=0) {
var elFrom=frames['frTabs'].event.srcElement;
var elTo=frames['frTabs'].event.toElement;

if ((!elTo) ||
(elFrom.tagName==elTo.tagName) ||
(elTo.tagName=="A" && elTo.parentElement!=elFrom) ||
(elFrom.tagName=="A" && elFrom.parentElement!=elTo)) {

if (iTab!=g_iShCur) {
with (frames['frTabs'].document.all) {
tdTab[iTab].style.background=c_rgszClr[1];
}
}
}
}
}

function fnSetActiveSheet(iSh)
{
if (iSh!=g_iShCur) {
fnSetTabProps(g_iShCur,false);
fnSetTabProps(iSh,true);
g_iShCur=iSh;
}
}
fnGetIEVer();
fnBuildFrameset();
//-->
</script>
<![endif]><!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>8th STLS-SHORT RUNDOWN (3)</x:Name>
<x:WorksheetSource HRef="8th%20STLS%20-%20RUNDOWN_files/sheet001.htm"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>8th STLS-QUICKIE RUNDOWN (2)</x:Name>
<x:WorksheetSource HRef="8th%20STLS%20-%20RUNDOWN_files/sheet002.htm"/>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:Stylesheet HRef=":8th STLS - RUNDOWN_files:stylesheet.css"/>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>

<frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
<frame src="8th%20STLS%20-%20RUNDOWN_files/sheet001.htm" name="frSheet">
<frame src="8th%20STLS%20-%20RUNDOWN_files/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
<noframes>
<body>


This page uses frames, but your browser doesn't support them.</p>
</body>
</noframes>
</frameset>
</html>
 
Upvote 0
Okay, the HTML thing didn't work... but I'd be happy to e-mail it to anyone who's interested.

Thanks!
Tess
 
Upvote 0
You must log in or register to reply here.

Similar threads

spacecaptainsuperguy
  • Solved
Simple VBA for Outlook - Copy last sent email
Replies
6
Views
427
spacecaptainsuperguy
spacecaptainsuperguy
L
  • Question
Picture directory
Replies
4
Views
107
jolivanes
jolivanes
T
  • Question
Help building a table based on criteria for kids sports program
Replies
0
Views
82
TeachMeEverything
T
J
  • Question
EXCELCNV.EXE Lag Time
Replies
4
Views
285
lrobbo314
lrobbo314
S
  • Question
Pop Up Message Box - Out of Date items in a Column
Replies
1
Views
299
GlennUK
G

Forum statistics

Threads
1,203,670
Messages
6,056,664
Members
444,881
Latest member
Stu2407

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top