Copy text to new files with counter and text insertion - Python

Hello,
Below I copied a text file (.gmd extension). I would like to copy the text with some insertions and save each file as .gmd with the a number included in the name of the .gmd that corresponds to the number being inserted.

First the numbers need to change in these two lines:
....
NAME OF INITIAL LANDUSE IMAGE           :    gr_lc_01b_075_fp
SUITABILITY IMAGE FOR SIMULATION 1      :    c2_mce_075

These should change together: gr_lc_01b_XXX_fp & c2_mce_XXX  (XXX goes from 075 - 407)
....

RGNVAL          REGION NAME    # CELLS      BEGIN        END      BEGIN        END
     1             Region 1     294276     152838     140000      78439      91277

Each of these 5 numbers will be different for each iteration from 074-407. I have them right now in an excel &/or text file.  Please advise how to incorporate this into the script.
.....

NAME OF OUTPUT LANDUSE IMAGE            :    delete_test

I would like the output name to be updated with the number from the iteration (075-407, e.g. output_075)

.....

Thank you kindly,
I really appreciate annotated code so that I might one day now how to do this myself, I have used the code below but I get this error message:

C:\Documents and Settings\u4cncmgj>C:\python24\python C:\temp\temp2\geomod_test.py
Traceback (most recent call last):
  File "C:\temp\temp2\geomod_test.py", line 29, in ?
    cells = open("c:\temp\temp2\spreadsheet.csv")
IOError: [Errno 2] No such file or directory: 'c:\temp\temp2\\spreadsheet.csv'

Should this code work (will it insert one line per .gmd file and go down the list in the .csv? And why do I get this error message?

Cheers,
MJ



text that needs to be copied and or updated starts immediately below:

***************************************************************
* THIS FILE CONTAINS THE VALUES OF THE PARAMETERS REQUIRED    *
* FOR THE GEOMOD MODULE, WHICH AUTOMATICALLY IS GENERATED IN  *
* IDRISI. STRONGLY RECOMMEND REEDITING IN IDRISI IF NECESSARY.*
***************************************************************

TIME TO BEGIN GEOMOD, INCLUSIVE         :    2001
TIME TO END GEOMOD, INCLUSIVE           :    2016
TIME STEP IN TIME UNITS                 :    1

# NEIGHBORS AWAY TO SEARCH,0=NO NIBBLE  :    1
WRITE DEBUG OUTPUT TO LOG FILE,YES=1    :    0
NAME OF STRATA/MASK IMAGE               :    N/A
NAME OF INITIAL LANDUSE IMAGE           :    gr_lc_01b_075_fp
DO ENVIR. IMPACT ANALYSIS? 1=YES, 0=NO  :    0
CMP/READ SUITABILITY SCORES(0=CP,1=RD)  :    1
NUMBER OF RUNS ONCE                     :    1
SUITABILITY IMAGE FOR SIMULATION 1      :    c2_mce_075
DO VALIDATION ANALYSIS? 1=YES, 0=NO     :    0
SINCE NO VALIDATION IMAGE, LANDUSE CHANGE INFO READ FROM FOLLOWS:
                                  LANDUSE STATE 1       LANDUSE STATE 2
RGNVAL          REGION NAME    # CELLS      BEGIN        END      BEGIN        END
     1             Region 1     294276     152838     140000      78439      91277

# OF TIMES OF OUTPUT BESIDE END TIME    :    0
NAME OF OUTPUT LANDUSE IMAGE            :    delete_testStart Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:

data = """\
***************************************************************
* THIS FILE CONTAINS THE VALUES OF THE PARAMETERS REQUIRED    *
* FOR THE GEOMOD MODULE, WHICH AUTOMATICALLY IS GENERATED IN  *
* IDRISI. STRONGLY RECOMMEND REEDITING IN IDRISI IF NECESSARY.*
***************************************************************
 
TIME TO BEGIN GEOMOD, INCLUSIVE         :    2001
TIME TO END GEOMOD, INCLUSIVE           :    2016
TIME STEP IN TIME UNITS                 :    1
 
# NEIGHBORS AWAY TO SEARCH,0=NO NIBBLE  :    1
WRITE DEBUG OUTPUT TO LOG FILE,YES=1    :    0
NAME OF STRATA/MASK IMAGE               :    N/A
NAME OF INITIAL LANDUSE IMAGE           :    gr_lc_01b_%03d_fp
DO ENVIR. IMPACT ANALYSIS? 1=YES, 0=NO  :    0
CMP/READ SUITABILITY SCORES(0=CP,1=RD)  :    1
NUMBER OF RUNS ONCE                     :    1
SUITABILITY IMAGE FOR SIMULATION 1      :    c2_mce_%03d
DO VALIDATION ANALYSIS? 1=YES, 0=NO     :    0
SINCE NO VALIDATION IMAGE, LANDUSE CHANGE INFO READ FROM FOLLOWS:
                                  LANDUSE STATE 1       LANDUSE STATE 2
RGNVAL          REGION NAME    # CELLS      BEGIN        END      BEGIN        END
     1             Region 1    %s        %s     %s      %s      %s
 
# OF TIMES OF OUTPUT BESIDE END TIME    :    0
NAME OF OUTPUT LANDUSE IMAGE            :    %s
"""
cells = open("c:\temp\temp2\spreadsheet.csv")
 
for iter in range(75, 408):
  filename = "output_%03d.gmd" % iter
  out = open(filename, "w")
  cell = cells.readline().split(",")
print >>out, data % (iter, iter, cell[0], cell[1], cell[2], cell[3], cell[4], filename)