# Shot Sheet Maker - fails on xlsx writer

**URL:** <https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741>\
**Category:** Python\
**Created:** [December 4, 2020, 1:43am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741 "2020-12-04T01:43:01Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/randy/32/6122_2.png) [@randy](https://forum.logik.tv/u/randy)\
**Post date:** [December 4, 2020, 1:43am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/1 "2020-12-04T01:43:01Z")

</div>

Hiya @MikeV, Im testing the Shot Sheet Maker you built. thank you!

I’m getting an error message on the Install o the xlsxWriter…any ideas?

thanks for all you do! Can’t wait to try it out.

r

---

<div class="post-metadata">

**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\
**Post date:** [December 4, 2020, 2:49am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/2 "2020-12-04T02:49:31Z")

</div>

It might be a permissions problem. Make sure the folder you put the script into has full permissions.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/randy/32/6122_2.png) [@randy](https://forum.logik.tv/u/randy)\
**Post date:** [December 4, 2020, 4:25am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/3 "2020-12-04T04:25:34Z")

</div>

That didn’t seem to do the trick. On Catalina 10.15.7. I’ll try again in the morning.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/randy/32/6122_2.png) [@randy](https://forum.logik.tv/u/randy)\
**Post date:** [December 8, 2020, 4:09pm UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/4 "2020-12-08T16:09:51Z")

</div>

Okay, I’ve finally found the problem. It was something funky in my Python folder that was not allowing newly installed scripts to compile. I’ve cleared out the offenders and it all works!

Python encountered (‘unexpected indent’, (’/opt/Autodesk/shared/python/pyflame/pyflame\_installer/pyflame\_installer.py’, 773, 16, ’ for num, line in enumerate(new\_script\_file, 1):\n’)) in unknown code  
[PYTHON HOOK] An error occurred Igoring python hooks from /opt/Autodesk/shared/python/pyflame/pyflame\_installer/pyflame\_installer.py  
Python encountered ‘No module named flame’ in unknown code  
[PYTHON HOOK] An error occurred Igoring python hooks from /opt/Autodesk/shared/python/pyflame/export\_preset\_menus/export\_preset\_menus.py  
Python encountered ‘No module named flame’ in unknown code  
[PYTHON HOOK] An error occurred Igoring python hooks from /opt/Autodesk/shared/python/pyflame/create\_export\_menus/create\_export\_menus.py  
Python encountered ‘No module named flame’ in unknown code  
[PYTHON HOOK] An error occurred Igoring python hooks from /opt/Autodesk/shared/python/pyflame/batch\_nodes/batch\_nodes.py  
[PYTHON HOOK] Duplicate module name found shot\_sheet\_maker (/opt/Autodesk/shared/python/shot\_sheet\_maker\_v2/shot\_sheet\_maker.py vs /opt/Autodesk/shared/python/pyflame/shot\_sheet\_maker/shot\_sheet\_maker.py). Python does not allow more than one module with a given name to be loaded at the same time. /opt/Autodesk/shared/python/pyflame/shot\_sheet\_maker/shot\_sheet\_maker.py will be used.  
Python encountered ‘No module named flame’ in unknown code  
[PYTHON HOOK] An error occurred Igoring python hooks from /opt/Autodesk/shared/python/pyflame\_installer\_v1\_4.py  
[PYTHON HOOK] Duplicate module name found slate\_maker (/opt/Autodesk/shared/python/slate\_maker.py vs /opt/Autodesk/shared/python/pyflame/slate\_maker/slate\_maker.py). Python does not allow more than one module with a given name to be loaded at the same time. /opt/Autodesk/shared/python/pyflame/slate\_maker/slate\_maker.py will be used.

---

<div class="post-metadata">

**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\
**Post date:** [December 10, 2020, 12:02am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/5 "2020-12-10T00:02:09Z")

</div>

Nice! Glad to hear you got it working.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/randy/32/6122_2.png) [@randy](https://forum.logik.tv/u/randy)\
**Post date:** [February 18, 2021, 5:23pm UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/6 "2021-02-18T17:23:40Z")

</div>

Hey @MikeV ,

So, this is happening to me in Shot Sheet creator after we had to do some manual installs for the ML Timewarp…

Big Sur 11.2.1, Flame 2021.2.1…

Shot Sheet Creator makes the jpegs but fails to write the xlsx.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/thedepartmentofexternalservices/original/2X/8/8f18769534e80fda4ef71e25cff9d3badf15a314.jpeg)

[‘Traceback (most recent call last):\n’,  
’ File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 366, in check\_entries\n self.create\_seq\_shot\_sheet()\n’,  
’ File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 876, in create\_seq\_shot\_sheet\n source\_length\_frames = self.timecode\_to\_frames(source\_duration, self.clip\_frame\_rate)\n’,  
’ File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 575, in timecode\_to\_frames\n frames = int(round(timecode\_to\_frames(clip\_timecode, start=‘00:00:00:00’)))\n’,  
’ File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 568, in timecode\_to\_frames\n return \_frames(\_seconds(\_timecode) - \_seconds(start))\n’,  
’ File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 552, in \_seconds\n return sum(f \* float(t) for f, t in \_zip\_ft)\n’,  
’ File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 552, in \n return sum(f \* float(t) for f, t in \_zip\_ft)\n’,  
‘ValueError: could not convert string to float: on\n’]

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/randy/32/6122_2.png) [@randy](https://forum.logik.tv/u/randy)\
**Post date:** [February 18, 2021, 5:26pm UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/7 "2021-02-18T17:26:42Z")

</div>

This is from Flame shell…

> > > > > > > > > > > > > > > > > > > > shot sheet maker v2.2 \<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<

> > > xlsxwriter imported \<\<\<

> > > shot sheet maker config loaded \<\<\<

> > > Export path not found - Select new path \<\<\<

image\_dir: /Users/randymcentee/Desktop/v6/randy\_mcentee\_reel\_2021  
thumb\_nail\_width: 266  
column\_width: 41.8901660281  
x\_offset: 31  
y\_offset: 44.97  
clip\_name: randy\_mcentee\_reel\_2021  
clip\_frame\_rate: 23.976  
RMRE\_0010  
source\_name: Source Name: RMRE\_0020  
source\_path: Source Path:  
source\_tc: Source TC: 00:00:00+01 - 00:00:04+06  
record\_tc: Record TC: 00:00:00+01 - 00:00:04+06  
clip\_timecode: 00:00:04+06  
clip\_timecode: 00:00:04:06  
shot\_length: Shot Length: 00:00:04+06 - 102 Frames  
clip\_timecode: 00:02:58+17  
clip\_timecode: 00:02:58:17  
source\_length: Source Length: 00:02:58+17 - 4285 Frames

clip\_info\_list: [‘Shot Name: RMRE\_0010’, ‘Source Name: RMRE\_0020’, 'Source Path: ', ‘Source TC: 00:00:00+01 - 00:00:04+06’, ‘Record TC: 00:00:00+01 - 00:00:04+06’, ‘Shot Length: 00:00:04+06 - 102 Frames’, ‘Source Length: 00:02:58+17 - 4285 Frames’]

source\_name: Source Name:  
source\_path: Source Path:  
source\_tc: Source TC: 00:00:00+00 - 00:00:00+16  
record\_tc: Record TC: 00:00:04+07 - 00:00:04+23  
clip\_timecode: 00:00:00+17  
clip\_timecode: 00:00:00:17  
shot\_length: Shot Length: 00:00:00+17 - 17 Frames  
clip\_timecode: on  
clip\_timecode: on  
Traceback (most recent call last):  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 366, in check\_entries  
self.create\_seq\_shot\_sheet()  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 876, in create\_seq\_shot\_sheet  
source\_length\_frames = self.timecode\_to\_frames(source\_duration, self.clip\_frame\_rate)  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 575, in timecode\_to\_frames  
frames = int(round(timecode\_to\_frames(clip\_timecode, start=‘00:00:00:00’)))  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 568, in timecode\_to\_frames  
return \_frames(\_seconds(\_timecode) - \_seconds(start))  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 552, in \_seconds  
return sum(f \* float(t) for f, t in \_zip\_ft)  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 552, in   
return sum(f \* float(t) for f, t in \_zip\_ft)  
ValueError: could not convert string to float: on

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/randy/32/6122_2.png) [@randy](https://forum.logik.tv/u/randy)\
**Post date:** [February 18, 2021, 6:20pm UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/8 "2021-02-18T18:20:36Z")

</div>

Removing the ML Timewarp Python script removes the error messages, successfully exports the jpegs, but still no xlsx file.

> > > xlsxWriter Installed \<\<\<

> > > > > > > > > > > > > > > > > > > > shot sheet maker v2.2 \<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<

> > > xlsxwriter imported \<\<\<

> > > shot sheet maker config loaded \<\<\<

> > > shot sheet maker column names loaded \<\<\<

> > > column names saved \<\<\<  
> > > image\_dir: /Users/randymcentee/Desktop/v10/randy\_mcentee\_reel\_2021  
> > > thumb\_nail\_width: 266  
> > > column\_width: 41.8901660281  
> > > x\_offset: 31  
> > > y\_offset: 44.97  
> > > clip\_name: randy\_mcentee\_reel\_2021  
> > > clip\_frame\_rate: 23.976  
> > > RMRE\_0010  
> > > source\_name: Source Name: RMRE\_0020  
> > > source\_path: Source Path:  
> > > source\_tc: Source TC: 00:00:00+01 - 00:00:04+06  
> > > record\_tc: Record TC: 00:00:00+01 - 00:00:04+06  
> > > clip\_timecode: 00:00:04+06  
> > > clip\_timecode: 00:00:04:06  
> > > shot\_length: Shot Length: 00:00:04+06 - 102 Frames  
> > > clip\_timecode: 00:02:58+17  
> > > clip\_timecode: 00:02:58:17  
> > > source\_length: Source Length: 00:02:58+17 - 4285 Frames

clip\_info\_list: [‘Shot Name: RMRE\_0010’, ‘Source Name: RMRE\_0020’, 'Source Path: ', ‘Source TC: 00:00:00+01 - 00:00:04+06’, ‘Record TC: 00:00:00+01 - 00:00:04+06’, ‘Shot Length: 00:00:04+06 - 102 Frames’, ‘Source Length: 00:02:58+17 - 4285 Frames’]

source\_name: Source Name:  
source\_path: Source Path:  
source\_tc: Source TC: 00:00:00+00 - 00:00:00+16  
record\_tc: Record TC: 00:00:04+07 - 00:00:04+23  
clip\_timecode: 00:00:00+17  
clip\_timecode: 00:00:00:17  
shot\_length: Shot Length: 00:00:00+17 - 17 Frames  
clip\_timecode: on  
Traceback (most recent call last):  
clip\_timecode: on  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 366, in check\_entries  
self.create\_seq\_shot\_sheet()  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 876, in create\_seq\_shot\_sheet  
source\_length\_frames = self.timecode\_to\_frames(source\_duration, self.clip\_frame\_rate)  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 575, in timecode\_to\_frames  
frames = int(round(timecode\_to\_frames(clip\_timecode, start=‘00:00:00:00’)))  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 568, in timecode\_to\_frames  
return \_frames(\_seconds(\_timecode) - \_seconds(start))  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 552, in \_seconds  
return sum(f \* float(t) for f, t in \_zip\_ft)  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 552, in   
return sum(f \* float(t) for f, t in \_zip\_ft)  
ValueError: could not convert string to float: on

---

<div class="post-metadata">

**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\
**Post date:** [February 20, 2021, 7:16pm UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/9 "2021-02-20T19:16:52Z")

</div>

> [@randy](#):
>
> MRE\_0010’, ‘Source Name: RMRE\_0020’, 'Source Path: ', ‘Source TC: 00:00:00+01 - 00:00:04+06’, ‘Record TC: 00:00:00+01 - 00:00:04+06’, ‘Shot Length: 00:00:04+06 - 102 Frames’, ‘Source Length: 00:02:58+17 - 4285 Frames’]
> 
> source\_name: Source Name:  
> source\_path: Source Path:  
> source\_tc: Source TC: 00:00:00+00 - 00:00:00+16  
> record\_tc: Record TC: 00:00:04+07 - 00:00:04+23  
> clip\_timecode: 00:00:00+17  
> clip\_timecode: 00:00:00:17  
> shot\_length: Shot Length: 00:00:00+17 - 17 Frames  
> clip\_timecode: on  
> Traceback (most recent call last):  
> clip\_timecode: on  
> File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 366, in check\_entries  
> self.create\_seq\_shot\_sheet()

It looks like it’s running into a problem with the timecode on one of the shots in your timeline. Does the script work if you try it on a timeline with different shots?

---

<div class="post-metadata">

**Author:** ![PlaceYourBetts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/placeyourbetts/32/6852_2.png) [@PlaceYourBetts](https://forum.logik.tv/u/PlaceYourBetts)\
**Post date:** [April 20, 2021, 4:21am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/10 "2021-04-20T04:21:46Z")

</div>

Sorry for being so useless at Python and most things command line.

I have tried to install the shot sheet maker on linux. Up until now I have been manually downloading the python scripts and adding them myself but when this failed to install xlsx writer successfully I bit the bullet and installed the logik portal. Not as scary as I had feared. In fact a lovely piece of work. Thanks

However it still failed to accept my system password and install xls\_writer.  
It must be a permissions problem. I tested this on a Mac and it is a joy to behold. The producers are very excited.

Is it possible that I can install this manually ? I used to do this for the Logik shaders before I installed the logik\_installer.py

---

<div class="post-metadata">

**Author:** ![PlaceYourBetts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/placeyourbetts/32/6852_2.png) [@PlaceYourBetts](https://forum.logik.tv/u/PlaceYourBetts)\
**Post date:** [April 20, 2021, 4:33am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/11 "2021-04-20T04:33:55Z")

</div>

What i meant was I had a command line code for the terminal that would grab the latest shaders. Unzip them and put them in the appropriate folder and when I dug around in the python script i saw this:

def install\_button(self):

```
    def install_xls_writer():
        import flame
        from subprocess import Popen, PIPE

        flame_version = self.flame_combo_box.currentText()
        flame_version = flame_version.rsplit('_', 1)[1]

        tar_path = CONFIG_PATH.rsplit('/', 1)[0]

        command = 'tar -xvf %s/xlsxwriter.tar.gz -C /opt/Autodesk/python/%s/lib/python2.7/site-packages/' % (tar_path, flame_version)
        command = command.split()

        p = Popen(['sudo', '-S'] + command, stdin=PIPE, stderr=PIPE, universal_newlines=True)
        sudo_prompt = p.communicate(self.password + '\n')[1]

        install_dir = '/opt/Autodesk/python/%s/lib/python2.7/site-packages/xlsxwriter' % flame_version

```

Seems to me that I could unzip the xlsxwriter.tar.gz into the python folder manually no?

---

<div class="post-metadata">

**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\
**Post date:** [April 20, 2021, 4:35am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/12 "2021-04-20T04:35:17Z")

</div>

Here’s what you can do if you want to manually install xlsx writer:

Untar xlsxwriter.tar.gz in the shot sheet maker folder. This will give you a folder called xlsxwriter.

Move that folder into /opt/Autodesk/python/CURRENT\_VERSION/lib/python2.7/site-packages

If you do a copy and paste of that folder, be sure to delete it from the shot sheet maker folder. It will cause a bunch of errors to show up in the terminal when you start Flame. It shouldn’t cause any problems with Flame running though.

---

<div class="post-metadata">

**Author:** ![PlaceYourBetts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/placeyourbetts/32/6852_2.png) [@PlaceYourBetts](https://forum.logik.tv/u/PlaceYourBetts)\
**Post date:** [April 20, 2021, 4:52am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/13 "2021-04-20T04:52:56Z")

</div>

Thanks once again for your help @MikeV

Even the simple Unix code

```
su

cp -R xlsxwriter /opt/Autodesk/python/2020.3/lib/python2.7/site-packages/

```

Is a massive accomplishment for me. Works on linux now. Thanks

---

<div class="post-metadata">

**Author:** ![Beren](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/beren/32/2243_2.png) [@Beren](https://forum.logik.tv/u/Beren)\
**Post date:** [November 24, 2021, 10:08am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/14 "2021-11-24T10:08:06Z")

</div>

Hi All,

I’m unfortunately still struggling with the creation of the XMLs here. I have xlsxwriter installed and in /opt/Autodesk/python/CURRENT\_VERSION/lib/python2.7/site-packages

However I am only getting the single frame JPEGs out of my system, with no sign of the XMLs. Is it possible I am running into separate permissions issues on the XML creation via xlsxwriter and not the jpeg generation? If so could you perhaps guide me a wee bit in the direction of addressing the issues.

As ever, muuuuch appreciation respect as this script is going to be a dream, once I have it working fluidly

---

<div class="post-metadata">

**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\
**Post date:** [November 24, 2021, 10:13am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/15 "2021-11-24T10:13:12Z")

</div>

Hey Beren

What version of flame and what version of the script are you using? Are you getting any errors in the shell when running the script?

The script won’t give you any XML files. It will create an excel spreadsheet.

Mike

---

<div class="post-metadata">

**Author:** ![Beren](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/beren/32/2243_2.png) [@Beren](https://forum.logik.tv/u/Beren)\
**Post date:** [November 24, 2021, 10:18am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/16 "2021-11-24T10:18:04Z")

</div>

> > > > > > > > > > > > > > > > > > > > shot sheet maker v3.0 \<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<\<

> > > shot sheet maker config loaded \<\<\<

> > > xlsxWriter imported \<\<\<

Traceback (most recent call last):  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 509, in check\_entries  
self.create\_seq\_shot\_sheet()  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 1030, in create\_seq\_shot\_sheet  
source\_length\_frames = self.timecode\_to\_frames(source\_duration, self.clip\_frame\_rate)  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 711, in timecode\_to\_frames  
frames = int(round(timecode\_to\_frames(clip\_timecode, start=‘00:00:00:00’)))  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 704, in timecode\_to\_frames  
return \_frames(\_seconds(\_timecode) - \_seconds(start))  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 688, in \_seconds  
return sum(f \* float(t) for f, t in \_zip\_ft)  
File “/opt/Autodesk/shared/python/shot\_sheet\_maker/shot\_sheet\_maker.py”, line 688, in   
return sum(f \* float(t) for f, t in \_zip\_ft)  
ValueError: could not convert string to float: ‘on’

Hi @MikeV

Apologies, script info above and I am running Flame 2022.1 with Shot Sheet Maker 3.0. Aye again apologies, I am expecting excel sheets

---

<div class="post-metadata">

**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\
**Post date:** [November 24, 2021, 10:23am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/17 "2021-11-24T10:23:04Z")

</div>

Does your timeline have any empty gaps in it by chance?

---

<div class="post-metadata">

**Author:** ![Beren](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/beren/32/2243_2.png) [@Beren](https://forum.logik.tv/u/Beren)\
**Post date:** [November 24, 2021, 10:31am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/18 "2021-11-24T10:31:02Z")

</div>

It does. Or should I say, did! Apologies if this is mentioned elsewhere. I also noticed BFXs must be commited to ensure they go out correctly too. Not an issue as i’ll be using the BFX timelines a references to my slap comps.

So, that has indeed fixed the issue. To counter this, I have simply filled the gaps with Black sources and can generate the sheets for the entire timeline and of course maintaining the record timecode info. I’ll then look to remove the Black source info from the sheet and should be good from there.

Truly helpful once again!

---

<div class="post-metadata">

**Author:** ![MikeV](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/mikev/32/399_2.png) [@MikeV](https://forum.logik.tv/u/MikeV)\
**Post date:** [November 24, 2021, 10:39am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/19 "2021-11-24T10:39:28Z")

</div>

Cool. Glad you got it working. I’ll mess around with the script to see if I can get it to ignore any gaps.

Mike

---

<div class="post-metadata">

**Author:** ![Beren](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.logik.tv/beren/32/2243_2.png) [@Beren](https://forum.logik.tv/u/Beren)\
**Post date:** [November 24, 2021, 11:04am UTC](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741/20 "2021-11-24T11:04:37Z")

</div>

Thanks kindly. Out of curiosity, are we able to add, as an original set of metadata the from tokens ‘segment name’ & ‘shot name’ ? Or potentially ‘comment’. This’ll allow me to apply 3 sets of names attached to the segments, being scene info, VFX name & source file name.

No worries if not, i’ll be able to combined the scene and VFX and then take that data to be split up elsewhere

[Next page](https://forum.logik.tv/t/shot-sheet-maker-fails-on-xlsx-writer/1741.md?page=2)