{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover Page","Pivot","Asset Additions","Macro1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":23,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Cause No.: 45767-DSIC-2"]
["Workpaper MCJ-6"]

{"sheet":"Pivot","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Project Number","20RM00484"]
["Name","Meters - Replacement - BU 20"]
["Cip account","107100"]
[]
["Sum of Cost",null,"Description"]
["In-Service Date","Fa period name","LOADING","OUTSIDE SERVICES","PAYROLL-LABOR","PAYROLL-TAXES","PARTS & MATERIALS","Grand Total"]
["2021-11-30","NOV-2021",255.44,null,377.71,27.02,246181.88,246842.05000000002]
["2022-01-31","JAN-2022",22875.64,null,31611.8,2333.3000000000002,18886.760000000002,75707.5]
["2022-03-31","MAR-2022",107.97,null,142.09,10.050000000000001,36416.11,36676.22]
["2022-04-30","APR-2022",31874.75,5928.62,45306.19,3414.4700000000003,104523.23000000001,191047.26]
["2022-05-31","MAY-2022",4512.92,null,6286.130000000001,462.98,151414.96000000002,162676.99000000002]
["2022-06-30","JUN-2022",22678.47,null,32064.240000000002,2345.56,364270,421358.27]
["2022-07-31","JUL-2022",740.32,null,1249.96,90.39,362343.38,364424.05]
[null,"AUG-2022",null,null,null,null,170671.35,170671.35]
["2022-08-31","AUG-2022",139.26999999999998,null,178.84,13.350000000000001,155143.89000000001,155475.35]
[null,"SEP-2022",null,null,null,null,28536,28536]
["2022-09-30","SEP-2022",null,null,null,null,143754.51,143754.51]
["Grand Total",null,83184.780000000013,5928.62,117216.96000000002,8697.119999999999,1782142.07,1997169.5500000003]

{"sheet":"Asset Additions","index":2,"n_rows":91,"n_cols":19,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["CGCU-FA-Asset Addition Details by Project Period Name : 'NOV-2021, DEC-2021, JAN-2022, FEB-2022, MAR-2022, APR-2022, MAY-2022, JUN-2022, JUL-2022, AUG-2022, SEP-2022' , Book Type Code : 'CGCU CORP' , Project : '20RM00484' 15-FEB-23    11.59.13 AM "]
[]
["Business Unit","Type","Asset category","Asset Number","Asset Description","Asset Units In Fa Period","QTY","Cost","Asset Location","In-Service Date","Project Number","Name","Serial Number","Fa period name","Model number","Description","Project asset type","Cip account","Cip cost account"]
["20","W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 DIRECT READ, BADGER P/N 102-9735, DS-JCA-PC1P-XXD3-C3-L1XX-2B1X1-L2D-TN",180,180,255.44,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 DIRECT READ, BADGER P/N 102-9735, DS-JCA-PC1P-XXD3-C3-L1XX-2B1X1-L2D-TN",180,180,23280.68,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 DIRECT READ, BADGER P/N 102-9735, DS-JCA-PC1P-XXD3-C3-L1XX-2B1X1-L2D-TN",180,180,377.71,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 DIRECT READ, BADGER P/N 102-9735, DS-JCA-PC1P-XXD3-C3-L1XX-2B1X1-L2D-TN",180,180,27.02,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3 IN","286146","3 OMNI C2 MNCS/COMP 25' ERT 0.1CF PULSE 10CF 6WHL3A CUST#=REGID&ALL 3 PLACES, SE",2,2,2929.36,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 DIRECT READ METER, BADGER P/N 102-9737, DP-BBE-PP6P-XXD3,C3-L1XX-2B1X",162,162,19917.47,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",486,486,51398.239999999998,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",648,648,68530.990000000005,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 DIRECT READ, BADGER P/N 102-9730, DP-BAA-PP6P-XXD3-C3-L1XX-2B1X1-L2D-",1134,1134,80125.14,"IN.000.000.0000","2021-11-30","20RM00484","Meters - Replacement - BU 20",null,"NOV-2021",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 T-10 FLANGE PROCODER PIT W/ 25FT ITRON CHORD, C/F 6WHL W/O NEPTUNE P/N ED2J11R",1,1,22875.64,"IN.000.000.0000","2022-01-31","20RM00484","Meters - Replacement - BU 20",null,"JAN-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 T-10 FLANGE PROCODER PIT W/ 25FT ITRON CHORD, C/F 6WHL W/O NEPTUNE P/N ED2J11R",1,1,18886.760000000002,"IN.000.000.0000","2022-01-31","20RM00484","Meters - Replacement - BU 20",null,"JAN-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 T-10 FLANGE PROCODER PIT W/ 25FT ITRON CHORD, C/F 6WHL W/O NEPTUNE P/N ED2J11R",1,1,31611.8,"IN.000.000.0000","2022-01-31","20RM00484","Meters - Replacement - BU 20",null,"JAN-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 T-10 FLANGE PROCODER PIT W/ 25FT ITRON CHORD, C/F 6WHL W/O NEPTUNE P/N ED2J11R",1,1,2333.3000000000002,"IN.000.000.0000","2022-01-31","20RM00484","Meters - Replacement - BU 20",null,"JAN-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",162,162,10.050000000000001,"IN.000.000.0000","2022-03-31","20RM00484","Meters - Replacement - BU 20",null,"MAR-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",162,162,142.09,"IN.000.000.0000","2022-03-31","20RM00484","Meters - Replacement - BU 20",null,"MAR-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",162,162,36416.11,"IN.000.000.0000","2022-03-31","20RM00484","Meters - Replacement - BU 20",null,"MAR-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",162,162,107.97,"IN.000.000.0000","2022-03-31","20RM00484","Meters - Replacement - BU 20",null,"MAR-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,534.72,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,26166.47,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,700.15,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,51.36,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",162,162,10851.65,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 DIRECT READ METER, BADGER P/N 102-9737, DP-BBE-PP6P-XXD3,C3-L1XX-2B1X",162,162,8131.12,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",432,432,29661.49,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 1/2 IN","301132","1-1/2 T-10 FLANGE PROCODER BYPASS ASSEMBLY KIT, NEPTUNE P/N: .13330-000 (USE WIT",6,6,3363.11,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 1/2 IN","301132","1-1/2 T-10 FLANGE PROCODER BYPASS ASSEMBLY KIT, NEPTUNE P/N: .13330-000 (USE WIT",6,6,44606.04,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 1/2 IN","301132","1-1/2 T-10 FLANGE PROCODER BYPASS ASSEMBLY KIT, NEPTUNE P/N: .13330-000 (USE WIT",6,6,29712.5,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 1/2 IN","301132","1-1/2 T-10 FLANGE PROCODER BYPASS ASSEMBLY KIT, NEPTUNE P/N: .13330-000 (USE WIT",6,6,5928.62,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"OUTSIDE SERVICES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 1/2 IN","301132","1-1/2 T-10 FLANGE PROCODER BYPASS ASSEMBLY KIT, NEPTUNE P/N: .13330-000 (USE WIT",6,6,31340.03,"IN.000.000.0000","2022-04-30","20RM00484","Meters - Replacement - BU 20",null,"APR-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3 IN","286146","3 OMNI T2 MNCS/COMP 25' ERT 0.1CF PULSE 10CF AMR 6WHL3C CUST#=REG ID ON LID/CVR",1,1,272.97000000000003,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3 IN","286146","3 OMNI T2 MNCS/COMP 25' ERT 0.1CF PULSE 10CF AMR 6WHL3C CUST#=REG ID ON LID/CVR",1,1,681.80000000000007,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3 IN","286146","3 OMNI T2 MNCS/COMP 25' ERT 0.1CF PULSE 10CF AMR 6WHL3C CUST#=REG ID ON LID/CVR",1,1,359.26,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3 IN","286146","3 OMNI T2 MNCS/COMP 25' ERT 0.1CF PULSE 10CF AMR 6WHL3C CUST#=REG ID ON LID/CVR",1,1,26.38,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 T-10 C/I 302 PROCODER PIT W/ 5FT ITRON CHORD, C/F 6WHL W/O NEPTUNE P/",378,378,74580.350000000006,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",432,432,35264.959999999999,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.6 IN","286149","6 OMNI F2 1CF PULSE 100CF 6WHL3A AMR 25' CABLE CUST#IN ALL PLACE SENSUS#F6XCXXFF",5,5,3346.34,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.6 IN","286149","6 OMNI F2 1CF PULSE 100CF 6WHL3A AMR 25' CABLE CUST#IN ALL PLACE SENSUS#F6XCXXFF",5,5,32610.25,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.6 IN","286149","6 OMNI F2 1CF PULSE 100CF 6WHL3A AMR 25' CABLE CUST#IN ALL PLACE SENSUS#F6XCXXFF",5,5,4754.3900000000003,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.6 IN","286149","6 OMNI F2 1CF PULSE 100CF 6WHL3A AMR 25' CABLE CUST#IN ALL PLACE SENSUS#F6XCXXFF",5,5,349.85,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.4 IN","291145","4 OMNI C2 MNCS/COMP 25' ERT 1CF PULSE 10CF 6WHL3A AMR SENSUS# C4X3XXFF1E1ZXNC",3,3,86.75,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.4 IN","291145","4 OMNI C2 MNCS/COMP 25' ERT 1CF PULSE 10CF 6WHL3A AMR SENSUS# C4X3XXFF1E1ZXNC",3,3,1172.48,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.4 IN","291145","4 OMNI C2 MNCS/COMP 25' ERT 1CF PULSE 10CF 6WHL3A AMR SENSUS# C4X3XXFF1E1ZXNC",3,3,8277.6,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.4 IN","291145","4 OMNI C2 MNCS/COMP 25' ERT 1CF PULSE 10CF 6WHL3A AMR SENSUS# C4X3XXFF1E1ZXNC",3,3,893.61,"IN.000.000.0000","2022-05-31","20RM00484","Meters - Replacement - BU 20",null,"MAY-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 OMNI T2 MNCS TURB 25' ERT 0.1CF PULSE 10CF AMR 6WHL3A CUST#=REG ID ON LID/CVR",1,1,22577.66,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 OMNI T2 MNCS TURB 25' ERT 0.1CF PULSE 10CF AMR 6WHL3A CUST#=REG ID ON LID/CVR",1,1,8216.41,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 OMNI T2 MNCS TURB 25' ERT 0.1CF PULSE 10CF AMR 6WHL3A CUST#=REG ID ON LID/CVR",1,1,31933.81,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.2 IN","286145","2 OMNI T2 MNCS TURB 25' ERT 0.1CF PULSE 10CF AMR 6WHL3A CUST#=REG ID ON LID/CVR",1,1,2336.12,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,100.81,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,356053.59,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,130.43,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,9.44,"IN.000.000.0000","2022-06-30","20RM00484","Meters - Replacement - BU 20",null,"JUN-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",180,180,34.160000000000004,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",180,180,477.66,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",180,180,34140,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",180,180,344.62,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,11.39,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,159.22,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,11380,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,114.87,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",432,432,278.38,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",432,432,41700.5,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",432,432,508.35,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",432,432,37.15,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,2.4500000000000002,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,275122.88,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,104.73,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",972,972,7.69,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"JUL-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",0,972,170671.35,"IN.000.000.0000","2022-07-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",240,240,4.6500000000000004,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",240,240,61.34,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",240,240,139.64000000000001,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",240,240,48.300000000000004,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,1.1599999999999999,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,15.34,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,7168.91,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",60,60,12.07,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",972,972,6.72,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",972,972,91.070000000000007,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",972,972,83565.350000000006,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3418, DP-BBE-PP6P-XXD3-C3-M1",972,972,70.33,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 DIRECT READ METER, BADGER P/N 102-9737, DP-BBE-PP6P-XXD3,C3-L1XX-2B1X",162,162,0.82000000000000006,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-TAXES","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 DIRECT READ METER, BADGER P/N 102-9737, DP-BBE-PP6P-XXD3,C3-L1XX-2B1X",162,162,11.09,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PAYROLL-LABOR","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 DIRECT READ METER, BADGER P/N 102-9737, DP-BBE-PP6P-XXD3,C3-L1XX-2B1X",162,162,10181.23,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.3/4 IN","286147","METER, 3/4 DIRECT READ METER, BADGER P/N 102-9737, DP-BBE-PP6P-XXD3,C3-L1XX-2B1X",162,162,8.57,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"LOADING","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",486,486,54088.76,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"AUG-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.1 IN","286144","METER, 1 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3420, DS-JCA-PC1P-XXD3-C3-M1CC",0,240,28536,"IN.000.000.0000","2022-08-31","20RM00484","Meters - Replacement - BU 20",null,"SEP-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
[null,"W4-334-40","20.W4-334-40.5/8 IN","286148","METER, 5/8 AMR CAPABLE WITH 5' CORD, BADGER P/N 103-3414, DP-BAA-PP6P-XXD3-C3-M1",1782,1782,143754.51,"IN.000.000.0000","2022-09-30","20RM00484","Meters - Replacement - BU 20",null,"SEP-2022",null,"PARTS & MATERIALS","AS-BUILT","107100","20.0000.107100.0000.00"]
["BU: 20","W4-334-40",null,null,null,33872,null,{"$f":"SUM(H4:H90)","v":1997169.5499999998}]

{"sheet":"Macro1","index":3,"n_rows":175,"n_cols":2,"rows_kept":175,"cut":false,"hidden":true,"merged":[]}
["Macro1","Auto_Open"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true},{"$f":"ERROR(2,Recover)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,5,5,5,5)","v":true},{"$f":"WORKBOOK.SELECT(\"Asset Additions\")","v":true}]
[{"$f":"PATTERNS(1,0,2,TRUE)","v":true},{"$f":"WINDOW.RESTORE()","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true},{"$f":"WINDOW.SIZE(82.5,42.75)","v":true}]
[{"$f":"RETURN()","v":true},{"$f":"WORKBOOK.HIDE(\"Macro1\",TRUE)","v":true}]
[null,{"$f":"EDIT.COLOR(1,0,0,0)","v":true}]
["Macro10",{"$f":"EDIT.COLOR(3,255,0,0)","v":true}]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true},{"$f":"EDIT.COLOR(5,172,168,153)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true},{"$f":"EDIT.COLOR(8,255,255,192)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true},{"$f":"EDIT.COLOR(6,212,208,200)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true},{"$f":"EDIT.COLOR(4,212,212,212)","v":true}]
[{"$f":"RETURN()","v":true},{"$f":"EDIT.COLOR(7,247,247,231)","v":true}]
[null,{"$f":"EDIT.COLOR(2,255,255,255)","v":true}]
["Macro11",{"$f":"RUN(\"Macro19\")","v":{"$error":"#N/A"}}]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true},{"$f":"DELETE.NAME(\"Auto_Open\")","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true},{"$f":"WORKBOOK.SELECT(\"Asset Additions\")","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true},{"$f":"SELECT(\"R3:R65536\")","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true},{"$f":"COLUMN.WIDTH(,,,3)","v":true}]
[{"$f":"RETURN()","v":true},{"$f":"ROW.HEIGHT(,,,3)","v":true}]
[null,{"$f":"SELECT(\"R1C1\")","v":true}]
["Macro12",{"$f":"WINDOW.MAXIMIZE()","v":true}]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true},{"$f":"RETURN()","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro13"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro14"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,7,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro15"]
[{"$f":"ALIGNMENT(3,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro16"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,7,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro17"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,7,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro18"]
[{"$f":"ALIGNMENT(4,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,5,5,5,5)","v":true}]
[{"$f":"PATTERNS(1,0,8,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro19"]
[{"$f":"WORKBOOK.SELECT(\"Asset Additions\")","v":true}]
[{"$f":"SELECT(\"R4C1:R107C5,R4C7:R107C19\")","v":true}]
[{"$f":"RUN(\"Macro1\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R4C6:R107C6\")","v":true}]
[{"$f":"RUN(\"Macro2\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R4C1:R106C1\")","v":true}]
[{"$f":"RUN(\"Macro3\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R4C8:R107C8\")","v":true}]
[{"$f":"FORMAT.NUMBER(\"###,###,###,###,###,##0.00 ;[Color3]<###,###,###,###,###,##0.00>\")","v":true}]
[{"$f":"SELECT(\"R4C6:R107C6,R4C7:R107C7\")","v":true}]
[{"$f":"FORMAT.NUMBER(\"#,###,###,##0 ;[Color3]<#,###,###,##0>\")","v":true}]
[{"$f":"SELECT(\"R4C10:R107C10\")","v":true}]
[{"$f":"FORMAT.NUMBER(\"dd-mmm-yyyy\")","v":true}]
[{"$f":"SELECT(\"R3C1\")","v":true}]
[{"$f":"RUN(\"Macro4\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C2,R3C8\")","v":true}]
[{"$f":"RUN(\"Macro5\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C3\")","v":true}]
[{"$f":"RUN(\"Macro6\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C4\")","v":true}]
[{"$f":"RUN(\"Macro7\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C5\")","v":true}]
[{"$f":"RUN(\"Macro8\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C6\")","v":true}]
[{"$f":"RUN(\"Macro9\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C7\")","v":true}]
[{"$f":"RUN(\"Macro10\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C9\")","v":true}]
[{"$f":"RUN(\"Macro11\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C10\")","v":true}]
[{"$f":"RUN(\"Macro12\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C11\")","v":true}]
[{"$f":"RUN(\"Macro13\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C12\")","v":true}]
[{"$f":"RUN(\"Macro14\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C13\")","v":true}]
[{"$f":"RUN(\"Macro15\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C14\")","v":true}]
[{"$f":"RUN(\"Macro16\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R3C15:R3C19\")","v":true}]
[{"$f":"RUN(\"Macro17\")","v":{"$error":"#N/A"}}]
[{"$f":"SELECT(\"R107C1,R107C2,R107C3,R107C4,R107C5,R107C6,R107C7,R107C8,R107C9,R107C10,R107C11,R107C12,R107C13,R107C14,R107C15,R107C16,R107C17,R107C18,R107C19\")","v":true}]
[{"$f":"RUN(\"Macro18\")","v":{"$error":"#N/A"}}]
[{"$f":"RETURN()","v":true}]
[]
["Macro2"]
[{"$f":"ALIGNMENT(4,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,5,5,5,5)","v":true}]
[{"$f":"PATTERNS(1,0,2,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro3"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(1,1,1,0,0,0,5,5,5,0,0)","v":true}]
[{"$f":"PATTERNS(1,0,2,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro4"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro5"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro6"]
[{"$f":"ALIGNMENT(2,FALSE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,7,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro7"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro8"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,6,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Macro9"]
[{"$f":"ALIGNMENT(2,TRUE,1,0,FALSE)","v":true}]
[{"$f":"BORDER(0,1,1,1,1,0,0,1,1,1,1)","v":true}]
[{"$f":"PATTERNS(1,0,7,TRUE)","v":true}]
[{"$f":"FORMAT.FONT(\"Times New Roman\",10,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE)","v":true}]
[{"$f":"RETURN()","v":true}]
[]
["Recover"]
[{"$f":"GOTO(OFFSET(LAST.ERROR(),1,0))","v":false}]
[{"$f":"RETURN()","v":true}]