tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846659d1697796987-forumula-not-working-in-old-version-excel-sample
Sheet: MASTER CARD

 |  |  |  |  |  |  |  |  | NAME | SER | CODE | AMOUNT
 |  |  |  |  |  |  |  |  | AL SAFA/AZEEM 1 | 1 | =IFERROR(SUMPRODUCT(MID(0&J3, LARGE(INDEX(ISNUMBER(--MID(J3, ROW(INDIRECT("1:"&LEN(J3))), 1)) * ROW(INDIRECT("1:"&LEN(J3))), 0), ROW(INDIRECT("1:"&LEN(J3))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(J3)))/10),"")
 |  |  |  |  |  |  |  |  | NAFEES ABDULLAPUR 443 | 2
 |  |  |  |  |  |  |  |  | TARIF AMBT 93 | 3
 |  |  |  |  |  |  |  |  | ASHU AMBT 25 | 4
 |  |  |  |  |  |  |  |  | ASHU AMBT 25 | 5
 |  |  |  |  |  |  |  |  | FIROZ KP 37 | 6
 |  |  |  |  |  |  |  |  | ARIF AMBT 21 | 7
 |  |  |  |  |  |  |  |  | NAFEES ABDULLAPUR 443 | 8
 |  |  |  |  |  |  |  |  | AURANGZEB VL 6 | 9
 |  |  |  |  |  |  |  |  | Y S AGRO INDIA/H SADIK MZN 43 | 10
 |  |  |  |  |  |  |  |  | MEHARBAN G PB 163 | 11
 |  |  |  |  |  |  |  |  | Y S AGRO INDIA/H SADIK MZN 43 | 12
 |  |  |  |  |  |  |  |  | [NAME] | 13
 |  |  |  |  |  |  |  |  | TARIF AMBT 93 | 14
 |  |  |  |  |  |  |  |  | ANAS DASSI 16 | 15
 |  |  |  |  |  |  |  |  | WAHID G 206 | 16
 |  |  |  |  |  |  |  |  | TASLEEM AMBT 228 | 17
 |  |  |  |  |  |  |  |  | FARMAN KP 234 | 18
 |  |  |  |  |  |  |  |  | SHARIB DASSI 88 | 19
 |  |  |  |  |  |  |  |  | SHAKIR SONU SRE PB 165 | 20
Spreadsheet: 107370d1304547811-index-match-function-as-vlookup-for-2-columns-excel-problem
Sheet: import from here

Data Year - Fiscal | Ticker Symbol | Total shares
1992 | MGLN | 1000
1993 | MGLN | 24875
1994 | MGLN | 26394
1995 | MGLN | 27870 |  |  | column to be imported
1996 | MGLN | 31014
1997 | MGLN | 29474
1998 | MGLN | 30784
1999 | MGLN | 31758
2000 | MGLN | 32144
2001 | MGLN | 33448
2002 | MGLN | 34854
2003 | MGLN | 35305
2004 | MGLN | 35367
2005 | MGLN | 35966
2006 | MGLN | 36986
2007 | MGLN | 38942
2008 | MGLN | 39607
2009 | MGLN | 35248
2010 | MGLN | 33779
1992 | EAT | 31115
1993 | EAT | 47643
1994 | EAT | 74572
1995 | EAT | 74283
1996 | EAT | 77902
1997 | EAT | 74800
1998 | EAT | 65766
1999 | EAT | 65926
2000 | EAT | 65631
2001 | EAT | 99101
2002 | EAT | 97862
2003 | EAT | 97096
2004 | EAT | 96072
2005 | EAT | 88530
2006 | EAT | 85844
2007 | EAT | 121062
2008 | EAT | 103101
2009 | EAT | 101852
2010 | EAT | 102287
Spreadsheet: 777472d1650402793-sum-is-off-by-01-according-to-calculator-sheet-shared-1
Sheet: Gross Random

Green Forest Industries
[NAME] width cost / strip cost |  | 20 | 3
Thickness |  | 1
[NAME] |  | 2
Margin |  | 0.9
Set up |  | 50
Run Charge |  | 0.55
Knife Charge |  | 85
Freight Charge |  | 0.8
Freight Cost |  | 0
[NAME] |  | Planing | 30 |  |  | list all items used to calculate this total
Footage |  | 25
Footage + |  | 28
Total footage
Sub total |  |  |  |  |  | 0
Added cost or tax etc.. |  |  |  |  |  | 0
Sell Price
Spreadsheet: 824474d1680614004-issue-with-v-and-x-lookups-time-range-etaf-2
Sheet: Sheet1

11:05:00
11:25:00
11:45:00
12:05:00
12:25:00
12:45:00
13:05:00
13:25:00
13:45:00
14:05:00
14:25:00
14:45:00
15:05:00
15:25:00
15:45:00
16:05:00
16:25:00
16:45:00
17:05:00
17:25:00
17:45:00
18:05:00
18:25:00
18:45:00
19:05:00
19:25:00
19:45:00
20:05:00
20:25:00
20:45:00
21:05:00
21:25:00
21:45:00
22:05:00
22:25:00
23:25:00
1900-01-01 00:25:00
1900-01-01 01:25:00
1900-01-01 02:25:00
1900-01-01 03:25:00
1900-01-01 04:25:00
1900-01-01 05:25:00
1900-01-01 06:25:00
1900-01-01 07:25:00
1900-01-01 08:25:00
1900-01-01 09:25:00
1900-01-01 10:25:00
1900-01-01 11:25:00
1900-01-01 12:25:00
1900-01-01 13:25:00
1900-01-01 14:25:00
1900-01-01 15:25:00
1900-01-01 16:25:00
1900-01-01 17:25:00
1900-01-01 18:25:00
1900-01-01 19:25:00
1900-01-01 20:25:00
1900-01-01 21:25:00
1900-01-01 22:25:00
1900-01-01 23:25:00
1900-01-02 00:25:00
1900-01-02 01:25:00
1900-01-02 02:25:00
1900-01-02 03:25:00
1900-01-02 04:25:00
Spreadsheet: darrell_schoolcraft__7269__saledoc02_26aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-02-25 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 2/26/2002 |  |  | FAX Number:
Total Quantity |  |  | 30000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.215
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
2/26/2002 | 2002-02-26 00:00:00 | 30000 |  | 30000 |  | 30000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
WT Pool |  |  | 58646 |  | 30000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 56383d1256578817-formula-for-adding-two-cells-ki4
Sheet: Sheet1

OS | Reboot | S3 | [NAME] | WOL S3 | WOL S4 | WOL S5 |  | xp32 | xp64 | Vista32 | Vista64 | Win7 32 | Win7 64
 | 100 | 100 | 100 | 20 | 20 | 20 |  | 10 | 11 | 12 | 13 | 14 | 15
OS | 10 | 11 | 12
Reboot | 100 | 100 | 50
S3 | 100 | 75 | 100
[NAME] | 100 | 25 | 50
WOL S3 | 20 | 20 | 20
WOL S4 | 20 | 20 | 20
WOL S5 | 20 | 10 | 10
Date | 2009-10-20 00:00:00 | 2009-10-21 00:00:00 | 2009-10-22 00:00:00
Spreadsheet: 864608d1711709070-3-consecutive-vowels-categorise-3-cons-vowels-pull-1-
Sheet: Sheet1

ARCHAEA | AEA
ALTHAEA | AEA
TAIAHAS | AIA
MANAIAS | AIA
WAIATAS | AIA
COBAEAS
BANDEAU
[NAME]
TABLEAU
BAUERAS
BATTEAU
BATEAUX
FABLIAU
CARDIAE
CADEAUX
FASCIAE
ARCHAEI
CHAPEAU
CHATEAU
COAEVAL
CAEOMAS
COAITAS
AOUDADS
KAIAKED
NAIADES
LEGUAAN
MANGEAO
GATEAUS
GATEAUX
ANTLIAE
SPIRAEA
APNOEAL
PLATEAU
MANTEAU
APNOEAS
KAWAIIS
ANTIAIR
MANOAOS
TATOUAY
BERCEAU
[NAME]
BIVOUAC
TABOOED
[NAME]
SEEABLE
BEAUFET
SUEABLE
BEAUTER
BEAUFIN
WOOABLE
BUREAUS
BUREAUX
BAGUIOS
ACCOIED
CAMEOED
CODEIAS
FAIENCE
OCHREAE
CORNEAE
GOUACHE
PAIOCKE
APNOEIC
PAEONIC
SCORIAE
MORCEAU
PONCEAU
CASEOUS
COTEAUS
COTEAUX
CARIOUS
VACUOUS
DEAIRED
RADIOED
QUAERED
FADEOUT
GEOIDAL
LIAISED
MIAULED
QUAILED
MIAOWED
RADIOES
APPUIED
NAPOOED
RONDEAU
DOUANES
ZOOIDAL
ARDUOUS
HERNIAE
HEAUMES
LEQUEAR
MARQUEE
PERAEON
QUAERES
RESEAUS
RESEAUX
LINGUAE
GLUTAEI
GASEOUS
HAVEOUR
ATHEOUS
LIAISES
LOIASES
[NAME]
TAKEOUT
NOTAEUM
RAMEOUS
[NAME]
TONNEAU
ZOUAVES
FATUOUS
SAGOUIN
HAVIOUR
LIAISON
LOIASIS
TAUIWIS
ROOIKAT
PRONAOI
SANIOUS
ANXIOUS
PAVIOUR
SOUARIS
SAVIOUR
[NAME]
MONOAOS
BEDOUIN
GOBIOID
DUBIOUS
BOUILLI
BILIOUS
[NAME]
[NAME]
ROOIBOS
OBVIOUS
RUBIOUS
COOEYED
RESCUEE
ECHOIER
QUIESCE
[NAME]
MECHOUI
MEIOTIC
[NAME]
[NAME]
VICIOUS
[NAME]
CORIOUS
CURIOUS
NOCUOUS
VIDEOED
RODEOED
QUEENED
QUEERED
UNFEUED
REOILED
MIMEOED
ENNUIED
QUIETED
RONEOED
FOLIOED
QUOIFED
HIKOIED
HIDEOUS
HIDEOUT
TENIOID
QUOINED
OSTEOID
QUOITED
TEDIOUS
DEVIOUS
WIDEOUT
UNWOOED
[NAME]
SIMIOID
OPIOIDS
VIDUOUS
EPEEIST
QUEERER
SQUEEZE
FOUETTE
SEMEION
MEIOSES
REQUIEM
PEREION
QUIETEN
QUIETER
[NAME]
UNQUEEN
OEUVRES
[NAME]
IGNEOUS
ROGUIER
VOGUIER
MILIEUS
MILIEUX
MEIOSIS
INQUIET
ROOINEK
[NAME]
ROUILLE
PILEOUS
PURLIEU
LIQUEUR
TIMEOUS
TIMEOUT
ENVIOUS
NIVEOUS
UNQUIET
PITEOUS
WIPEOUT
QUOITER
SERIOUS
QUIETUS
LUTEOUS
TENUOUS
OSSEOUS
FOLIOUS
FURIOUS
NIMIOUS
IMPIOUS
SIMIOUS
INVIOUS
[NAME]
OSMIOUS
[NAME]
SINUOUS
Spreadsheet: 177007d1346163979-date-visulisation-date-visulisation
Sheet: Planner

 | 2012-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00
 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-13 00:00:00 | 2012-10-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-20 00:00:00 | 2012-10-21 00:00:00 | 2012-10-22 00:00:00 | 2012-10-23 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 2012-10-27 00:00:00 | 2012-10-28 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-04 00:00:00 | 2012-11-05 00:00:00 | 2012-11-06 00:00:00 | 2012-11-07 00:00:00 | 2012-11-08 00:00:00 | 2012-11-09 00:00:00 | 2012-11-10 00:00:00 | 2012-11-11 00:00:00 | 2012-11-12 00:00:00 | 2012-11-13 00:00:00 | 2012-11-14 00:00:00 | 2012-11-15 00:00:00 | 2012-11-16 00:00:00 | 2012-11-17 00:00:00 | 2012-11-18 00:00:00 | 2012-11-19 00:00:00 | 2012-11-20 00:00:00 | 2012-11-21 00:00:00 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 2012-11-24 00:00:00 | 2012-11-25 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00 | 2012-12-01 00:00:00 | 2012-12-02 00:00:00 | 2012-12-03 00:00:00 | 2012-12-04 00:00:00 | 2012-12-05 00:00:00 | 2012-12-06 00:00:00 | 2012-12-07 00:00:00 | 2012-12-08 00:00:00 | 2012-12-09 00:00:00 | 2012-12-10 00:00:00 | 2012-12-11 00:00:00 | 2012-12-12 00:00:00 | 2012-12-13 00:00:00 | 2012-12-14 00:00:00 | 2012-12-15 00:00:00 | 2012-12-16 00:00:00 | 2012-12-17 00:00:00 | 2012-12-18 00:00:00 | 2012-12-19 00:00:00 | 2012-12-20 00:00:00 | 2012-12-21 00:00:00 | 2012-12-22 00:00:00 | 2012-12-23 00:00:00 | 2012-12-24 00:00:00 | 2012-12-25 00:00:00 | 2012-12-26 00:00:00 | 2012-12-27 00:00:00 | 2012-12-28 00:00:00 | 2012-12-29 00:00:00 | 2012-12-30 00:00:00 | 2012-12-31 00:00:00
Person A | 1 - Title for Entry 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 - Title for Entry 4
Person B |  |  |  |  | 2 - Title for Entry 2
Person C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 - Title for Entry 3
See [NAME] for Inputs List
Spreadsheet: 752200d1634647657-find-the-index-of-substring-in-whole-string-in-one-cell-lookup-occurences
Sheet: LookUp_Result

 |  | Lookup | ResultValue | TableName
 |  | Vn_Input_HANA_Deployment_Description |  | DeploymentsMap
 |  | Vn_Input_Oracle_Deployment_Description |  | DeploymentsMap
 |  | Vn_Comp_WebDispatcher_Server_Vendor |  | DeploymentsMap
 |  | Vn_Comp_HANA_Server_Vendor |  | DeploymentsMap
 |  | Vn_Input |  | DeploymentsMap
Spreadsheet: 174430d1345053709-subtotals-with-multiple-criteria-formula-sample-for-subtotal-spreadsheet-day92
Sheet: Sheet1

EE # | Name | Date | Amount |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
1 | Curly | 2011-01-01 00:00:00 | 100 | Subtotal | Curly
1 | Curly | 2011-01-15 00:00:00 | 100 | Need 200 for Jan2011 for Curly | [NAME]
1 | Curly | 2011-12-31 00:00:00 | 100 | Need 100 for Dec for Curly | Moe
1 | Curly | 2012-01-15 00:00:00 | 100 | Need 100 for Jan2012 for Curly
2 | [NAME] | 2011-01-15 00:00:00 | 100 | and so on..
2 | [NAME] | 2011-12-31 00:00:00 | 100
3 | Moe | 2011-01-15 00:00:00 | 100
3 | Moe | 2011-12-31 00:00:00 | 100
3 | Moe | 2012-01-15 00:00:00 | 100
Spreadsheet: ddad51c4-55aa-469b-8156-1a445f4c0b5f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7286 | 56176 | Narelle | Wynwood | AUS | 0 | 00:38:19 | 00:02:14 | 01:19:08 | 00:00:35 | 00:48:47 | 1 | 02:49:04
7286 | 56175 | Nicole | Jones | AUS | 0 | 00:30:06 | 00:01:29 | 01:28:58 | 00:00:49 | 00:53:46 | 2 | 02:55:11
Spreadsheet: 546626d1510136969-average-if-cell-shows-up-in-column-a-or-b-last-3-times-only-book2
Sheet: Sheet1

AA | CC | 4
BB | AA | 5
CC | BB | 7
AA | CC | 8
BB | AA | 3
CC | BB | 2 |  |  | AA | 4 |  | Column G to display the average  from Column C for only the last 3 times Column F appears in column A OR B
AA | CC | 4 |  |  | BB | 5
BB | AA | 1 |  |  | CC | 4.66
CC | BB | 5
AA | CC | 5
BB | AA | 6
CC | BB | 4
Spreadsheet: 158fc3f0-0f19-4a04-972e-6f13e6b3c21d
Sheet: Sheet1

Unnamed: 0 | สรุปผลการดำเนินงานจัดซื้อ รอบเดือน กันยายน 2556 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | ชื่อหน่วยงาน [NAME] มหาวิทยาลัยแม่ฟ้าหลวง จังหวัดเชียงราย
ลำดับที่ | เลขที่สัญญา | รายการ | จำนวน | วงเงินงบประมาณ | วิธีซื้อ | ผู้เสนอราคา |  | ผู้ได้รับการคัดเลือกและราคา |  | [NAME]
 |  |  |  |  |  | ชื่อ/บริษัท | ราคา |  | ราคา
1 |  | จ้างเหมาบำรุงรักษาตู้ชุมสายโทรศัพท์อัตโนมัติ ประจำปี | 12 เดือน | 1280000 | พิเศษ | บจก. เอ็นอีซี คอร์ปอเรชั่น | 1255000 | บจก. เอ็นอีซี คอร์ปอเรชั่น | 1182000 | ได้ต่อรองราคาแล้ว เป็นราคาที่อยู่ในวงเงินที่ได้รับอนุมัติ และเสนอ
 |  | งบประมาณ 2557 |  |  |  |  |  |  |  | รายละเอียดข้อกำหนดของงานจ้างตรงตามที่มหาวิทยาลัยกำหนด
2 |  | จ้างเหมาบริการรักษาความสะอาด หน่วยประสานงาน | 12 เดือน | 492000 | พิเศษ | หจก. ละอองบุญ คลีนนิ่ง | 492000 | หจก. ละอองบุญ คลีนนิ่ง | 492000 | ได้ต่อรองราคาแล้ว เป็นราคาที่อยู่ในวงเงินที่ได้รับอนุมัติ และเสนอ
 |  | มหาวิทยาลัยแม่ฟ้าหลวง กรุงเทพฯ อาคารปัญภูมิ 2 ชั้น 7 |  |  |  |  |  |  |  | รายละเอียดข้อกำหนดของงานจ้างตรงตามที่มหาวิทยาลัยกำหนด
 |  | ชั้น 8 และชั้น 10 จำนวน 3 คน โดยวิธีพิเศษ
3 |  | จ้างถมดินที่ดินโครงการก่อสร้างศูนย์การแพทย์ | 1 รายการ | 40000000 | อิเล็กทรอนิกส์ | บจก. ห้าเล็บการโยธา | 28720000 | บจก. ห้าเล็บการโยธา | 28720000 | เป็นผู้ผ่านการพิจารณาคัดเลือกเบื้องต้นให้เป้นผู้มีสิทธิ์เสนอราคา
 |  |  |  |  |  | บจก. [NAME] | 32000000 |  |  | เป็นผู้ประมูลราคาสุดท้ายต่ำสุด และแป็นราคาที่ต่ำกว่าราคา
 |  |  |  |  |  | บจก. เอ.เอส.เอ การช่าง | 32790000 |  |  | สูงที่สุดที่กำหนดตามประกาศ
 |  |  |  |  |  | หจก. รัตนพันธ์รุ่งกิจ | 32900000
 |  |  |  |  |  | หจก. พัฒนานุภาพก่อสร้าง | 36200000
 |  |  |  |  |  | บจก. เชียงรายแลนด์ แอสโซซิเอทส์ | 36500000
4 |  | [NAME] | 2 ชุด | 600000 | พิเศษ | หจก. ดี.ดี.เด็นตอล ซัพพลาย | 627289.72 | บจก. มิด-เวสต์ เด็นตอล กรุ๊ป | 599200 | เป็นราคาที่อยู่ในวงเงินที่ได้รับอนุมัติ รวมทั้งเป็นผู้เสนอรายละเอียด
 |  |  |  |  |  | บจก. มิด-เวสต์ เด็นตอล กรุ๊ป | 599200 |  |  | คุณลักษณะเฉพาะตรงตามที่มหาวิทยาลัยกำหนด
5 |  | [NAME] | 1 รายการ | 720000 | พิเศษ | บจก .ที.เอ. พาวเวอร์พลัว กรุ๊ป | 688868.15 | บจก .ที.เอ. พาวเวอร์พลัว กรุ๊ป | 680000 | ได้ต่อรองราคาแล้ว เป็นราคาที่อยู่ในวงเงินที่ได้รับอนุมัติ และเสนอ
 |  | อาคารรบริการวิชาการ (AS) |  |  |  | หจก. เอทีม ซ่อมบำรุง | 720000 |  |  | รายละเอียดข้อกำหนดของงานจ้างตรงตามที่มหาวิทยาลัยกำหนด
6
7
8
9
10
11
12
13
14
15
16
Spreadsheet: 142196d1329725438-data-entry-new-dcr-format
Sheet: week5

ABM/SR. ABM  WEEKLY REPORT
[Soft copy to be submitted on every Monday by 11 AM]
Name: |  |  |  |  |  | HQ |  |  |  |  |  | Date of Posting
Week No: |  | 5 |  |  |  | From: |  |  |  |  |  | To:
Date : |  |  |  |  |  | Date : |  |  |  |  |  | Date :
Mon Worked with: |  |  |  |  |  | Tue Worked with: |  |  |  |  |  | Wed Worked with:
Place: |  |  |  |  |  | Place: |  |  |  |  |  | Place: |  |  |  |  |  | A+
Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DENTIST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKIN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEAD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORTHO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SURGN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RMP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIELD WORK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STOKIST VISIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MEETING
No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr |  |  | ADMIN WORK
Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist: |  |  | LEAVE
Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist:
[NAME] with: |  |  |  |  |  | [NAME] with: |  |  |  |  |  | [NAME] with:
Place: |  |  |  |  |  | Place: |  |  |  |  |  | Place:
Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity
No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr
Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist:
Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist:
Particulars |  |  | Week | Cumulative
Total Dr. Calls [Self]
Total VIP Drs met  [Self]
[NAME]  [Self]
Stockist Calls  [Self]
Dr. [NAME].  [Self]
Chemist [NAME].  [Self]
No. of Field Working Days  [Self]
Total Dr. Calls [Team]
Total VIP Drs met   [Team]
[NAME]  [Team]
POB total [Team]
Primary Sales [Team]
Collection   [Team]
Spreadsheet: 588184d1535535301-formula-for-vlookup-for-next-n-days-book1
Sheet: 2018

example 1
Input Date |  |  | Desired results in cell D8
2018-01-06 00:00:00
example 2
 |  |  | Desired results in cell D17
2018-01-06 00:00:00
Spreadsheet: 0eeeecb1-9bc4-422e-8009-b04dc6c4269e
Sheet: graph base

#1 Access | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Service Area
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census
Gender | # | % | # | % | # | % | # | % | # | % | # | %
Female |  |  |  |  |  |  |  |  |  |  | 425726
Male |  |  |  |  |  |  |  |  |  |  | 411136
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Total
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Service Area
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census
Ethnicity | # | % | # | % | # | % | # | % | # | % | # | %
White |  |  |  |  |  |  |  |  |  |  | 398271
Hispanic |  |  |  |  |  |  |  |  |  |  | 318674
African American |  |  |  |  |  |  |  |  |  |  | 43085
Asian |  |  |  |  |  |  |  |  |  |  | 21251
Native American |  |  |  |  |  |  |  |  |  |  | 6071
Filipino |  |  |  |  |  |  |  |  |  |  | 23365
Pacific Islander |  |  |  |  |  |  |  |  |  |  | 2305
Multi-Race |  |  |  |  |  |  |  |  |  |  | 22553
Unknown |  |  |  |  |  |  |  |  |  |  | 1287
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Service Area
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census
Age | # | % | # | % | # | % | # | % | # | % | # | %
<18 |  |  |  |  |  |  |  |  |  |  | 245217
18 & 19 |  |  |  |  |  |  |  |  |  |  | 25706
20 to 24 |  |  |  |  |  |  |  |  |  |  | 52893
25 to 29 |  |  |  |  |  |  |  |  |  |  | 52166
30 to 34 |  |  |  |  |  |  |  |  |  |  | 52145
35 to 39 |  |  |  |  |  |  |  |  |  |  | 55384
40 to 49 |  |  |  |  |  |  |  |  |  |  | 116401
50 + |  |  |  |  |  |  |  |  |  |  | 236950
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Average Age | 27.08580473951301 |  | 26.74092167399446 |  | 26.80841198873986 |  | 26.61666200205243 |  | 26.21942624578122
Median Age | 22 |  | 22 |  | 22 |  | 22 |  | 22
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Riverside County
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 ACS*
DSPS | # | % | # | % | # | % | # | % | # | % | # | %
Disabilities |  |  |  |  |  |  |  |  |  |  | 105412
 |  |  |  |  |  |  |  |  |  |  | 1299857
Spreadsheet: 85978d1285955777-tariff-prices-will-not-continue-to-calculate-when-24-hours-are-reached-ke-courtcharges
Sheet: Sheet1

Carpark Arrival Date & Time
2010-09-30 11:18:00 |  | King [NAME] (min hrs) | SUNDAY - FRIDAY | SATURDAY
↑ |  | 0 | 0 | 0
ENTER ARRIVAL TIME HERE |  | 0.1 | 2.2 | 2.5
 |  | 1 | 2.7 | 3
Carpark Departure Date & Time |  | 2 | 3.8 | 3.8
 |  | 3 | 5 | 5
 |  | 4 | 7 | 7
Parking Duration | Description (Result) | 6 | 15 | 15
 | Hours Parked
 | PARKING COST
↑
CHARGE THIS AMOUNT  TO GUEST ROOM
Spreadsheet: 161529d1339538158-pulling-data-from-one-database-into-another-with-multiple-criteria-help-please-v2
Sheet: Sheet1

Name | Position | Date | Account | Hours |  | Salary | Benefits | What I need to bring over
[NAME] | [PHONE] | 01/11 | 12216 | 110
[NAME] | [PHONE] | 02/11 | 12216 | 120
[NAME] | [PHONE] | 03/11 | 12213 | 160
[NAME] | [PHONE] | 04/11 | 12213 | 160
[NAME] | [PHONE] | 05/11 | 12216 | 50
JDoe | [PHONE] | 01/11 | 12213 | 75
JDoe | [PHONE] | 02/11 | 12213 | 176
JDoe | [PHONE] | 03/11 | 12213 | 160
JDoe | [PHONE] | 04/11 | 12216 | 168
JDoe | [PHONE] | 04/11 | 12213 | 120
Spreadsheet: 685691d1594142261-how-to-obtain-a-value-in-a-column-cell-contingent-on-the-text-entered-in-the-column-header-example
Sheet: Example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000 | 5000 | 5000 | 20000 | 5000 | 5000 | 5000 | 5000 | 0 | 5000 | 5000 | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37500 | 75000 |  |  |  |  | -37500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36468 | 36468 | 36468 | 36468 | 36468 | 36468 | 36468 | 36468
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31250 | 31250 |  |  | 31250 |  | 0 |  |  | 31250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25437 | 25437 | 25437 | 25437
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3333.33 | 3333.33 | 3333.33 | 4444 | 4444 | 4444 | 4444 | 4444 | 1110.67 | 4444 | 4444 | 4444