Example #1
0
def prepare_global_plan(filename):
    REQS = load_eos_from_xls_new(filename)
    prepocess_super_plan(REQS)
    try:
        if access(GLOBAL_PLAN_WORK_DIR, R_OK):
            print "Directory exists"
            try:
                #                make_tarfile(BOC_WORK_DIR + "global_plan.tar", GLOBAL_PLAN_WORK_DIR)
                make_zipfile(BOC_WORK_DIR + "global_plan.zip", GLOBAL_PLAN_WORK_DIR)
                #                tarfile =  BOC_WORK_DIR + "global_plan.tar"
                tarfile = BOC_WORK_DIR + "global_plan.zip"

            except:
                tarfile = None
                logger.error("Error while creating tarball for GLOBAL_PLAN_WORK_DIR")
    except:
        logger.error("Access denied for GLOBAL_PLAN_WORK_DIR")

    return tarfile
Example #2
0
def eos_main(request):

    if request.method == 'POST':
        form = EosForm(request.POST, request.FILES)
        if form.is_valid():
            UF_FORM = form.cleaned_data
#        if 'X-Progress-ID' in request.GET:
#            request.session['X-Progress-ID'] = request.GET['X-Progress-ID']
            logger.info("Starting file  %s proccessing in %s for user from %s" % (request.FILES['xls_file'].name,
                                                                                  whoami(), get_client_ip(request)))
            fileattr = handle_xls_file(request.FILES['xls_file'], get_session_key(request) + '_' +
                                                                  request.FILES['xls_file'].name)
            if not fileattr == None:
                request.session['xlsfilepath'] = fileattr['filename']
                logger.info("Sucsessfully handeled file  %s in %s" % (request.FILES['xls_file'].name, whoami()))
                if UF_FORM['file_type'] == 'super_plan':
                    tarfile = prepare_global_plan(fileattr['filename'])
                    fsock = open(tarfile,"r")
                    response = HttpResponse(fsock, mimetype='application/zip')
                    response['Content-Disposition'] = 'attachment; filename=multiple_plans.zip'
#                    return HttpResponse('super_plan')
                    return response
                else:
                    request.session['eos_data'] = load_eos_from_xls_new(fileattr['filename'])
                    logger.error(request.session['eos_data'])
                    return redirect('/eos')
            else:
                logger.info("File type %s is not good, reported from %s" % (request.FILES['xls_file'].name, whoami()))
                return HttpResponse('Bad file type or file corrupted')

    else:
        logger.info("Empty upload form prepared from %s for user from %s, "
                "session id %s" % (whoami(), get_client_ip(request), get_session_key(request)))
        form = EosForm()
#        return render_to_response('confupload_form.html', {'form': form, 'MEDIA_URL' : MEDIA_URL},
#            context_instance=RequestContext(request))
        return render_to_response("new_start.html", {'form': form, 'MEDIA_URL' : MEDIA_URL,
                                                     'username' : request.user},
            context_instance=RequestContext(request))
Example #3
0
    def setUp(self):
        self.valid_prices_for_lines = [
            611079.58,
            96272,
            103216.8,
            69216.8,
            252291.79,
            46336,
            61940.2,
            23940.2,
            174467.79,
            13170.1,
            13170.1,
            217952,
            103472,
            103216.8,
            69216.8,
            149936.0,
            49936,
            60740.2,
            22740.2,
            72112.0,
            11370.1,
            11370.1,
            17118208.0,
            1338944.0,
            44786.0,
            5928960.0,
            320640.0,
            12964.0,
            2636800.0,
            320640.0,
            12964.0,
            11376640.0,
            487424.0,
            18176.0,
            1255852,
            218326,
            44786,
            1116700,
            1207000,
            111670,
            120700,
            40800,
            20400,
            20400,
        ]
        self.valid_dcprices_for_lines = [
            410032.523664,
            212826.048008681,
            104888.995859375,
            55582.2029340278,
            189721.172264,
            120985.801292101,
            48222.1515546875,
            20519.275015191,
            151603.676466667,
            10259.6375075955,
            10259.6375075955,
            344251.063333333,
            212826.048008681,
            104888.995859375,
            55582.2029340278,
            189721.172264,
            120985.801292101,
            48222.1515546875,
            20519.275015191,
            151603.676466667,
            10259.6375075955,
            10259.6375075955,
            3606964.28416,
            548782.511264,
            22940.0299916667,
            2574211.09416,
            254168.079264,
            13733.3289916666,
            1144245.13877538,
            254168.079264,
            13733.3289916666,
            3262713.22082667,
            468991.102597333,
            20446.5484708333,
            586161.20341,
            114916.726639,
            22940.0299916667,
            645470.74375,
            645470.74375,
            74804.445625,
            74804.445625,
            129094.14875,
            74804.445625,
            74804.445625,
        ]

        # print 'Prices.objects.create(hw_class='+str(price.hw_class)+',hw_type="'+str(price.hw_type)+'", price='+str(price.price)+', dcmcod_rent_price='+str(price.dcmcod_rent_price)+', dc_book_price='+str(price.dc_book_price)+', dc_startup_price='+str(price.dc_startup_price)+',drdc_rent_price='+str(price.drdc_rent_price)+')'

        Prices.objects.create(
            hw_class=1.00,
            hw_type="x86_ent",
            price=556.000000000000000000000000000000,
            dcmcod_rent_price=69.8463454861111,
            dc_book_price=47.376987847222200000000000000000,
            dc_startup_price=58.663524305555600000000000000000,
            drdc_rent_price=46.102430555555600000000000000000,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="x86_mid",
            price=1298.000000000000000000000000000000,
            dcmcod_rent_price=251.44684375,
            dc_book_price=170.557156250000000000000000000000,
            dc_startup_price=211.188687500000000000000000000000,
            drdc_rent_price=165.968750000000000000000000000000,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="ppc_hiend",
            price=28664.000000000000000000000000000000,
            dcmcod_rent_price=471.462832031250000000000000000000,
            dc_book_price=319.794667968750000000000000000000,
            dc_startup_price=395.978789062500000000000000000000,
            drdc_rent_price=311.191406250000000000000000000000,
        )
        Prices.objects.create(
            hw_class=2.00,
            hw_type="upg_ppc_hiend",
            price=28664.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="ppc_mid",
            price=19321.000000000000000000000000000000,
            dcmcod_rent_price=502.8936875,
            dc_book_price=341.114312500000000000000000000000,
            dc_startup_price=422.377375000000000000000000000000,
            drdc_rent_price=331.9375,
        )
        Prices.objects.create(
            hw_class=2.00,
            hw_type="upg_ppc_mid",
            price=19321.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=2.00,
            hw_type="upg_sparc_hiend",
            price=12800.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=2.00,
            hw_type="upg_t4_mid",
            price=6700.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="sparc_hiend",
            price=28000.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="t4_mid",
            price=4900.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="ia_hiend",
            price=20100.000000000000000000000000000000,
            dcmcod_rent_price=419.078072916667000000000000000000,
            dc_book_price=284.261927083333000000000000000000,
            dc_startup_price=351.981145833333000000000000000000,
            drdc_rent_price=276.614583333333000000000000000000,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="ia_mid",
            price=6016.000000000000000000000000000000,
            dcmcod_rent_price=419.078072916667000000000000000000,
            dc_book_price=284.261927083333000000000000000000,
            dc_startup_price=351.981145833333000000000000000000,
            drdc_rent_price=276.614583333333000000000000000000,
        )
        Prices.objects.create(
            hw_class=2.00,
            hw_type="upg_ia_hiend",
            price=6700.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=2.00,
            hw_type="upg_ia_mid",
            price=6016.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="t_mid",
            price=3410.000000000000000000000000000000,
            dcmcod_rent_price=193.420649038462000000000000000000,
            dc_book_price=131.197812500000000000000000000000,
            dc_startup_price=162.452836538462000000000000000000,
            drdc_rent_price=127.668269230769000000000000000000,
        )
        Prices.objects.create(
            hw_class=2.00,
            hw_type="t_mid_upg",
            price=3410.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="m_mid",
            price=10000.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=1.00,
            hw_type="m_hiend",
            price=6810.000000000000000000000000000000,
            dcmcod_rent_price=314.308554687500000000000000000000,
            dc_book_price=213.196445312500000000000000000000,
            dc_startup_price=263.985859375000000000000000000000,
            drdc_rent_price=207.460937500000000000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="san_stor_hiend",
            price=25.000000000000000000000000000000,
            dcmcod_rent_price=1.149471285714290000000000000000,
            dc_book_price=0.779689857142857000000000000000,
            dc_startup_price=0.965434000000000000000000000000,
            drdc_rent_price=0.758714285714286000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="san_stor_mid",
            price=6.000000000000000000000000000000,
            dcmcod_rent_price=0.523847591145833000000000000000,
            dc_book_price=0.355327408854167000000000000000,
            dc_startup_price=0.439976432291667000000000000000,
            drdc_rent_price=0.345768229166667000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="san_stor_vmware",
            price=6.000000000000000000000000000000,
            dcmcod_rent_price=0.523847591145833000000000000000,
            dc_book_price=0.355327408854167000000000000000,
            dc_startup_price=0.439976432291667000000000000000,
            drdc_rent_price=0.345768229166667000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="nas_stor",
            price=12.000000000000000000000000000000,
            dcmcod_rent_price=0.436539659288194000000000000000,
            dc_book_price=0.296106174045139000000000000000,
            dc_startup_price=0.366647026909722000000000000000,
            drdc_rent_price=0.288140190972222000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="int_stor",
            price=6.000000000000000000000000000000,
            dcmcod_rent_price=0.523847591145833000000000000000,
            dc_book_price=0.355327408854167000000000000000,
            dc_startup_price=0.439976432291667000000000000000,
            drdc_rent_price=0.345768229166667000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="san_stor_full",
            price=44.000000000000000000000000000000,
            dcmcod_rent_price=1.149471285714290000000000000000,
            dc_book_price=0.779689857142857000000000000000,
            dc_startup_price=0.965434000000000000000000000000,
            drdc_rent_price=0.758714285714286000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="san_stor_repl",
            price=29.000000000000000000000000000000,
            dcmcod_rent_price=1.149471285714290000000000000000,
            dc_book_price=0.779689857142857000000000000000,
            dc_startup_price=0.965434000000000000000000000000,
            drdc_rent_price=0.758714285714286000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="san_stor_bcv",
            price=41.000000000000000000000000000000,
            dcmcod_rent_price=1.149471285714290000000000000000,
            dc_book_price=0.779689857142857000000000000000,
            dc_startup_price=0.965434000000000000000000000000,
            drdc_rent_price=0.758714285714286000000000000000,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="backup_stor",
            price=9.000000000000000000000000000000,
            dcmcod_rent_price=0.785771386718750000000000000000,
            dc_book_price=0.532991113281250000000000000000,
            dc_startup_price=0.659964648437500000000000000000,
            drdc_rent_price=0.518652343750000000000000000000,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="ms_lic",
            price=150.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="db2_hpux",
            price=28544.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="db2_aix",
            price=34253.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="vmware_lic",
            price=235.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="vmware_support",
            price=55.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="symantec_lic",
            price=2000.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="symantec_support",
            price=650.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="rhel_support",
            price=375.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=6.00,
            hw_type="loadbalancer",
            price=120700.000000000000000000000000000000,
            dcmcod_rent_price=5028.936875,
            dc_book_price=3411.143125000000000000000000000000,
            dc_startup_price=4223.773750000000000000000000000000,
            drdc_rent_price=3319.375,
        )
        Prices.objects.create(
            hw_class=6.00,
            hw_type="datapower",
            price=111670.000000000000000000000000000000,
            dcmcod_rent_price=5028.936875,
            dc_book_price=3411.143125000000000000000000000000,
            dc_startup_price=4223.773750000000000000000000000000,
            drdc_rent_price=3319.375,
        )
        Prices.objects.create(
            hw_class=3.00,
            hw_type="san_stor_vplex",
            price=4.000000000000000000000000000000,
            dcmcod_rent_price=0.261923796000000000000000000000,
            dc_book_price=0.177663704427083000000000000000,
            dc_startup_price=0.219988216145833000000000000000,
            drdc_rent_price=0.172884115000000000000000000000,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="ms_lic_2sock",
            price=2400.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="vmware_lic_2sock",
            price=6682.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="vmware_support_2sock",
            price=1659.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="rhel_support_2sock",
            price=6000.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=6.00,
            hw_type="mqdmz",
            price=18000.000000000000000000000000000000,
            dcmcod_rent_price=5028.936875000000000000000000000000,
            dc_book_price=3411.143125000000000000000000000000,
            dc_startup_price=4223.773750000000000000000000000000,
            drdc_rent_price=3319.375000000000000000000000000000,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="mssql_lic_2core",
            price=6622.236800000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_x86",
            price=23750.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_x86",
            price=5225.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_part_x86",
            price=5750.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_part_x86",
            price=1175.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_rac_x86",
            price=11500.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_rac_x86",
            price=2530.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_sparc",
            price=23750.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_sparc",
            price=5225.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_part_sparc",
            price=5750.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_part_sparc",
            price=1175.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_rac_sparc",
            price=11500.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_rac_sparc",
            price=2530.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_power",
            price=47500.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_power",
            price=10450.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_part_power",
            price=11500.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_part_power",
            price=2350.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_rac_power",
            price=23000.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_rac_power",
            price=5060.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_itanium",
            price=47500.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_itanium",
            price=10450.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_part_itanium",
            price=11500.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_part_itanium",
            price=2350.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=4.00,
            hw_type="oracle_lic_rac_itanium",
            price=23000.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        Prices.objects.create(
            hw_class=5.00,
            hw_type="oracle_supp_rac_itanium",
            price=5060.000000000000000000000000000000,
            dcmcod_rent_price=0,
            dc_book_price=0,
            dc_startup_price=0,
            drdc_rent_price=0,
        )
        self.eos_vals = load_eos_from_xls_new(u"Testcase_v6.xlsx")