This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Update
Reset
Print All
Submit
"G" BOX
THIS BOX CALCULATES THE GROWTH FACTOR FOR DETERMINING THE APPROPRIATE EXPONENT
"G". THE VALUE TO USE AS "G" ON THE EXPONENT SHEET SHOULD NOT EXCEED 10 PERCENT OF THE NUMBER OF DRILLERS TRAINED PER YEAR. CHANGES SHOULD NOT BE MADE IN THIS BOX. THE BASIS FOR THE ESTIMATION IS FOUND IN THE FACT THAT DURING TRAINING WE CAN DRILL UP TO 100 TO 150 TRAINING WELLS PER YEAR.
WWW.ONEMILLIONWELLS.ORG
"G"
VALUE IS LOCATED IN THIS COLUMN
NUMBER OF PEOPLE TO TRAIN ONE 3 PERSON CREW
1 YEAR = 52 5 DAY WORK WEEKS= NET DAYS TO DRILL
# DAYS / TRAIN 3 PERSON CREWS AT 3 WELLS EACH CREW
POSSIBLE 3 PERSON CREWS TRAINED PER YEAR
POSSIBLE NUMBER OF PERSONS TRAINED BY 1 MAN / YEAR
DRILLERS PROMOTED FROM TOP 10 PERCENT OF DRILLERS BECOME TRAINERS
NET NUMBER OF DRILLERS TRAINED BY 1 PERSON
NET CREWS TRAINED TO DRILL
WELLS DRILLED IN 1 YEAR WHILE TRAINING
1
ORIGINAL TRAINER
CAN
TRAIN 10.4 NEW TRAINERS AND 95 DRILLERS EACH YEAR THEREFORE IT WOULD BE PRUDENT TO SAY THE RATIO FALLS BETWEEN
1 TO 10. IN THE CALCULATION BELOW WE WILL USE 3.33.
ON THIS SHEET, WE HAVE THE FORMULA FOR EXPONENTIAL GROWTH (N=B*G^2) WHERE "B" IS THE STARTING NUMBER OF TRAINERS ALREADY TRAINED, "G" IS THE FACTOR CHOSEN AS A DESIRED NUMBER BROUGHT FROM THE PREVIOUS YELLOW CALCULATION BOX ON THIS SHEET. IN THAT BOX "G" IS CALCUALTED TO BE APPROXIMATELY 10
AND WE USE HERE LESS A DEFAULT VALUE OF ONE THIRD OF THAT VALUE.
"T" IS A
DEFAULT VARIABLE THAT CAN BE CHOSEN AND IS THE VALUE THAT REPRESENTS THE NUMBER OF YEARS THAT ONE WOULD CHOOSE TO COMPLETE THE PROJECT.
CALCULATION BOX
EXPONENTIAL INCREASE FORMULA
N=B * G^T
WWW.ONEMILLIONWELLS.ORG
ONLY GREEN CELLS MAY BE EDITED
"T"
IS THE NUMBER OF YEARS
"B" BEGINING NUMBER OF TRAINERS
"G"
FACTOR MAXIMUM OF 10
NEWLY TRAINED CREWS DRILLING 150 WELLS PER YEAR
WELLS DRILLED
COST OF DRILL RIGS
Print All Information
Please host the converted page in server to use Print All.