klopmp

import pandas as pd
import numpy as np

import matplotlib.pyplot as plt
import seaborn as sns
%matplotlib inline

# input files
FILE_EMPLOYEE = 'data/employee.xlsx'
FILE_GEO = 'data/employee_geo.xlsx'

klopmp

Option Explicit

''' Global constants for ease of config
Const MY_TITLE As String = "MOM VIII Sales Meeting Log"
Const MEETING_RAW = "_meetings"
Const MEETING = "Meetings"
Const EMPLOYEE_RAW = "_employees"
Const TAG_RAW = "_tags"

Const NAMEDRANGE_EMPLOYEE = "BSG_Ops___Employees"

klopmp

''' TODO
''' Add alternate colors to rows
''' Add error handling

Option Explicit

''' Global constants
Const MY_TITLE As String = "Meow VIII VC Marketing Pipeline"
Const SOURCE As String = "_P8VC"
Const DESTINATION As String = "P8VC"

klopmp

import webbrowser as wb
import time
import os


# replace url_base with your Backstop instance URL
url_base = 'https://[BACKSTOP_URL]'
url_delete_contacts = '/backstop/crm/ManageContacts.do?ACTION=DELETE&id='

klopmp

import pandas as pd

# setting file names
FILE_MASTERS = 'masters.csv'
FILE_LOOKUP = 'lookup.csv'
FILE_MASTERS_DUPS = 'masters_dups.csv'
FILE_OUT = 'output.csv'


# reading data from masters file

klopmp