tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk13

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 861356d1709231895-summing-values-based-on-when-they-occured-in-a-fiscal-year-sample-data-2-29-24
Sheet: Summary

ID# | Employee ID | Associate Name | Supervisor | Department | Total Points | Wellness | Tardies | Level | Verbal Warning Date | Stop - VW | Written Warning Date | Stop - WW | Start - Final Written Warning Date | Stop - Final | Date
871
213
142
Spreadsheet: 91674d1291328220-vlookup-isna-and-iserror-faster-formula-tempfsrtemp
Sheet: POPULATION

CODE | ERF_NO | REF_NO | ENG_TYPE | APP_CD | ENG_SRNO | YEAR_MANU | ESN | ESN_SRNO | REPL_ENGNO | SUPPL_BY | ENG_CD | CATEGORY | CODE | CUSTOMER | CUST_NAME | CUST_ADD1 | CUST_ADD2 | CUST_CITY | PIN_NO | CUST_DIST | SITE | COMMN_DT | HRS | WARRANTY | STATUS | KVA | AMC | FILTER | OIL | PART | TP | CONTACT | PHONE1 | PHONE2 | [NAME] | FAX | REMARK | GRADE | REF | IDT | GDT | CODE | last inv dt | last inv dt | keyADD | C2&":"&Q2
I0056 |  |  | 02 | 02.2105 | 0601898 | 06 | 01898 | 022105/0601898 |  |  | H | G | C | IN25044 | TOWERS LTD | SELU |  | SABC |  | WABC |  | 2006-03-09 00:00:00 |  | PW |  | 15 |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | I0056:  TOWERS LTD:  :  H:  G:  IN25044:  [NAME]:  WABC
I0056 |  |  | 02 | 02.2105 | 0702480 | 07 | 02480 | 022105/0702480 |  |  | H | G | C | IN92401 | TOWERS LTD |  |  | KASOLA |  | WASABC |  | 2007-04-25 00:00:00 |  | PW |  | 15 |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | I0056:  TOWERS LTD:  :  H:  G:  IN92401:  KASOLA:  WASABC
I0056 | 23122007 |  | 02 | 02.2105 | 0702481 | 07 | 02481 | 022105/0702481 |  | KALA | H | G | C | IN24276 | TOWERS LTD | KELZAR |  | KEABC |  | WASABC | SAME AS ABOVE | 2007-04-20 00:00:00 |  | PW |  | 15 |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | I0056:  TOWERS LTD:  [NAME]:  H:  G:  IN24276:  KEABC:  WASABC
I0056 | 20102008 |  | 39 | 39.3005 | 0800647 | 08 | 00647 | 393005/0800647 |  | KALA | R | G | C | IN93273 | TOWERS LTD | AKOLA SITE ID MG-428 |  | AKLABC |  | AKABC | SAME AS ABOVE | 39556 |  | PW |  | 20 |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | I0056:  TOWERS LTD:  [NAME]:  R:  G:  IN93273:  AKLABC:  AKABC
I0056 |  |  | 39 | 39.3005 | 0800650 | 08 | 00650 | 393005/0800650 |  |  | R | G | C | IN23987 | TOWERS LTD | REKHIKALA |  | REKHIABC |  | WARABC |  | 39578 |  | PW |  | 15 |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | I0056:  TOWERS LTD:  :  R:  G:  IN23987:  REKHIABC:  WARABC
K0240 | 08072008 |  | 4H | 4H.2676 | 0800134 | 08 | 00134 | 4H2676/0800134 |  | OTHER | R40 | I |  |  | [NAME] | BHISI ,TQ. CHIMUR |  | CHANABC |  | CHANABC | SAME AS ABOVE | 2008-07-01 00:00:00 |  | PW |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | K0240:  [NAME]:  OTHER:  R40:  I:  :  CHANABC:  CHANABC
K0240 | 29062008 |  | 4H | 4H.2676 | 0800152 | 08 | 00152 | 4H2676/0800152 |  | OTHER | R40 | I |  |  | [NAME] | CHANDRAPUR |  | CHANABC |  | CHANABC | SAME AS ABOVE | 2008-04-12 00:00:00 |  | PW |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | K0240:  [NAME]:  OTHER:  R40:  I:  :  CHANABC:  CHANABC
K0244 | * |  | 4H | 4H.2252 | 0700720 | 07 | 00720 | 4H2252/0700720 |  | L&T | R40 | I |  |  | KUTUMARE SING | AT POST JAFRABAD | BRAMHPURI | CHANABC |  | CHANABC | SAME AS ABOVE | 2008-01-25 00:00:00 |  | PW |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  | K0244:  KUTUMARE SING:  L&T:  R40:  I:  :  CHANABC:  CHANABC
Spreadsheet: 1dab0ba0-d618-4630-be62-4b83cfecb2b4
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  |  | Ending
Aug. 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 |  |  |  | 1,000 short tons
2010/11 | 341.601 | 6098.1 | 0 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/121 | 617.563 | 5370 | 100 | 6087.563 |  | 2400 | 135 | 3122.563 | 5657.563 | 430
2012/132 | 430 | 5745 | 0 | 6175 |  | 2500 | 300 | 2925 | 5725 | 450
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-07-13 07:08:29.210000
Spreadsheet: 04f3a2da-c05c-424d-af53-f68a54346dae
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 35. Value of Building Approved - Tasmania
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A420335T | 1970-07-01 00:00:00 | 2011-11-01 00:00:00 | 497 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420344V | 1973-07-01 00:00:00 | 2011-11-01 00:00:00 | 461 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420356C | 1973-07-01 00:00:00 | 2011-11-01 00:00:00 | 461 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421038R | 1970-07-01 00:00:00 | 2011-11-01 00:00:00 | 497 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total building ;  Total (Type of work) ; |  |  | Original | A422668A | 1973-07-01 00:00:00 | 2011-11-01 00:00:00 | 461 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 122852d1317207305-choose-data-to-populate-main-worksheet-populate_worksheet-1-
Sheet: Dados SPSS

Codigo | Sexo | Idade_1 | Idade_2 | Peso_1 | Peso_2 | Altura_1 | Altura_2 | [NAME] | PerCintura_2 | IMC_1 | IMC_2 |  |  |  |  |  | Altura_1_m | Altura_2_m | digito_controlo
CT1 | 1 | 11 | 11 | 40.2 | 41 | 139.9 | 140 | 70.5 | 72 | 20.54 | 20.92 |  |  |  |  |  | 1.399 | 1.4 | 100
CT2 | 2 | 11 | 11 | 56.7 | 56.5 | 147.4 | 151.2 | 85.6 | 85.5 | 26.09 | 24.72 |  |  |  |  |  | 1.474 | 1.512
CT3 | 2 | 11 | 12 | 53 | 55 | 145.9 | 146 | 88.6 | 90.2 | 24.89 | 25.8 |  |  |  |  |  | 1.459 | 1.46
CT4 | 2 | 11 | 11 | 65 | 67 | 152.4 | 153.2 | 86.7 | 88.2 | 27.98 | 28.55 |  |  |  |  |  | 1.524 | 1.532
CT5 | 2 | 11 | 12 | 31.9 | 32.4 | 139.4 | 143.2 | 59.6 | 60.4 | 16.42 | 15.8 |  |  |  |  |  | 1.394 | 1.432
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 815311d1674863892-repeating-values-displayed-time-sheet
Sheet: Sheet1

NAME: |  |  | SIGNATURE: |  |  |  |  |  | WEEK ENDING:
Day | Date | JOB | Start | End | S | S | M | T | W | T | F | REG | 1.5 X's | 2 X's | 0:15:00
TOTALS>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
 | ON CALL RUNNER |  |  |  |  |  |  |  | PTO |  |  |  |  |  |  | REF | 1.5X | 2X
 |  |  | TOTAL REG HOURS >= 40 |  |  |  |  |  | HOLIDAY |  |  |  |  |  |  | 1 day, 16:00:00
 |  |  | TOTAL OVERTIME |  |  |  |  |  | TOTAL HOURS
 | INSTRUCTIONS:
 | THIS TIME SHEET IS FULLY AUTOMATIC AND REQUIRES VERY LITTLE SKILL AND BASIC MATH.
 | ALL COMPLICATED MATH HAS BEEN ELIMINATED TO ENSURE THE ACCURACY OF ARITHMETIC
 | ENSURING BOTH YOU AND YOUR EMPLOYER HAVE NO DEFICIENCIES. IT ALSO REDUCES THE TIME
 | YOUR IMMEDIATE SUPERVISOR/MANAGER/OWNER SPENDS CHECKING ARITHMETIC PROVIDING
 | MORE TIME TO FLOURISH IN OTHER AVENUES BENEFITTING THE COMPANY.
 | FILL OUT YOUR NAME AND WEEK ENDING DATE AS MM/DD, THE YEAR IS AUTOMATIC
 | ALL TIME VALUES ARE TO BE ENTERED IN 24 HOUR FORMAT (BASICALLY A +/- 2 FACTOR)
 | IF YOU ARE UNSURE OF THE TIME, SELECT IT AND THE TOP OF THE SHEET WILL DISPLAY THE 12 HR FORMAT.
 | IT MAY BE HELPFUL FOR SOME TO HAVE YOUR VEHICLE CLOCK AT 24 HR AND YOUR LAPTOP
 | AND PHONE AT 12 HR.
 | COLUMN A IS THE CALCULATOR QUALIFIER. YOU MUST ENTER THE DAY FOR EACH LINE ITEM TO CALCULATE
 | YOUR HOURS. THE ONLY VALID ENTRIES ARE AS FOLLOWS:
 | TO CALCULATE STANDARD TIME, ENTER THE DAY AS SAT, SUN, MON, TUE, WED, THU, FRI .
 | ON-CALL TECHNICIANS THAT GENERATE OVERTIME DURING THE WEEK, SUNDAY, HOLIDAYS OR OVERTIME
 | FOR ANYONE PREVIOUSLY AGREED UPON PRIOR TO PERFORMING SERVICES:
 | TO CALCULATE 1.5 X's OVERTIME, ENTER THE DAY AS SA, MO, TU, WE, TH, FR
 | TO CALCULATE 2 X's OVERTIME, ENTER THE DAY AS SU OR HOL. NO OTHER DAYS QUALIFY FOR 2 X's OVERTIME
 | TO ENTER LUNCH BREAKS, DO NOT ENTER THE DAY IN COLUMN A AND CLOCK IN AND OUT AS USUAL.
 | HOLIDAYS AND PTO: ENTER THE DAY AS USUAL BUT DO NOT ENTER START AND END TIME. THESE HOURS ARE
 | ENTERED MANUALY ON THE BOTTOM RIGHT OF YOUR TIME SHEET.
 | WORKING OVERNIGHT REQUIRES 2 ENTRIES:
 | FIRST ENTRY: ENTER THE DAY AND TIME YOU START AND CLOCK-OUT AT 24:00
 | SECOND ENTRY: CLOCK-IN TIME IS THE FOLLOWING DAY, START TIME IS 00:00 FOLLOWED BY YOUR CLOCK-OUT TIME.
 | THIS TIME SHEET CAN BE USED ON ANY DEVICE THAT SUPPORTS EXCEL INCLUDING BUT NOT LIMITED TO : PC,
 | TABLETS AND SMARTPHONES.
 | IF YOU DO NOT HAVE PRINT CAPABILITIES, EMAIL IT TO SOMEONE WHO DOES, PRINT AND SUBMIT… IT'S THAT SIMPLE.
Spreadsheet: 296321d1392054626-power-trendline-equation-used-in-a-cell-learning
Sheet: Sheet1

x | y |  | m | b
1 |  | B2: =5*A2^1.07 |  |  | D2:E2: {=LINEST(LN($B$2:$B$11), LN($A$2:$A$11))}
2 |  | =5*(POWER(A2,1.07)) |  |  | E3: =EXP(E2)
3
4 |  |  |  |  | {=LINEST(LN($B$2:$B$11), LN($A$2:$A$11))}
5
6
7
8
9
10
Spreadsheet: ba862f90-e45f-4d21-bb73-ad22a6f59f92
Sheet: Sheet1

DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
TAHAP VII GUGUS BADAN DIKLAT PROPINSI JATENG (GD. SINDORO)
[NAME] Tanggal 13 s/d 22 Agustus 2011
Kelas | : Penjas SMP
No | No peserta | Nama | Sekolah | [NAME]
1 | 11031722010511 | MARTONO | SMPN 1 PAMOTAN | REMBANG
2 | 11031722010537 | [NAME] | SMP MUHAMMADIYAH 2 LASEM | REMBANG
3 | 11031722010578 | SUDARJO | SMP N 1 LASEM | REMBANG
4 | 11031722010581 | [NAME] | SMP N 2 SUMBER | REMBANG
5 | 11031722010587 | IRWAN SETIYAWAN | SMP N 2 BULU | REMBANG
6 | 11031722010614 | MAHSUDI | SMP N KATHOLIK ADI SUCIPTO | REMBANG
7 | 11031822011239 | TEGUH BUDI MULYANTO | SMP N 1 GUNUNGWUNGKAL | PATI
8 | 11031822011248 | SUPARMIN | SMP N 2 TAMBAKROMO | PATI
9 | 11031822011289 | WITOYO | SMP N 1 KAYEN | PATI
10 | 11031822011296 | KARTONO | SMP N 2 TAYU | PATI
11 | 11031822011308 | DRIYO KRISTIANTO | SMP N 3 JUWANA | PATI
12 | 11031822011332 | TRIYATMO | SMP N 2 WINONG | PATI
13 | 11031822011350 | BUDI SETIAWAN | SMP N 2 PATI | PATI
14 | 11031822011353 | SHOLIKHIN | SMP N 1 WINONG | PATI
15 | 11031822011374 | SUNINGSIH | SMP N 2 JAKENAN | PATI
16 | 11031922010401 | TRI PRAWOSO | SMP N 3 JEKULO | KUDUS
17 | 11031922010414 | PURWADI | SMP N 1 JEKULO | KUDUS
18 | 11031922010422 | SUSIATI PRASETYANINGSIH | SMP N 2 KALIWUNGU | KUDUS
19 | 11031922010424 | SOMAN | SMP 2 GEBOG | KUDUS
20 | 11031922010429 | ADASANA | SMP N 4 BAE KUDUS | KUDUS
21 | 11031922010470 | SUPRIYADI | SMP N 5 KUDUS | KUDUS
22 | 11031922010493 | SUNARYO | SMP N 1 JATI KUDUS | KUDUS
23 | 11031922010548 | ROHANTI | SMP TAMAN DEWASA KUDUS | KUDUS
24 | 11031922010551 | SUNARTO | SMP BHAKTI | KUDUS
25 | 11032022010527 | SUGITO | SMP N 1 BATEALIT | JEPARA
26 | 11032022010529 | MUNIF | SMP N 1 JEPARA | JEPARA
27 | 11032122010767 | [NAME] | SMP NEGERI 1 MRANGGEN | DEMAK
28 | 11032122010783 | [NAME]  RIYADI | SMP NEGERI 2 MRANGGEN | DEMAK
29 | 11032122010806 | IMAM BASUKI | SMP NEGERI 1 GUNTUR | DEMAK
30 | 11032122010817 | ISMIATI | SMP NEGERI 3 DEMAK | DEMAK
31 | 11036222010167 | SRI NURHAYATI | SMP NEGERI  9 SALATIGA | [NAME]
32 | 11036222010107 | LENY SEPTIANI | SMP NEGERI 3 SALATIGA | [NAME]
33 | 11036222010179 | BUDI PRIYANTO | SMP PANGUDI LUHUR SALATIGA | [NAME]
34 | 11032622010704 | SUHARTANTO | SMP N 2 PANINGGARAN | Kab. Pekalongan
35 | 11032622010657 | KUSMIWATI | SMP N 5 SRAGI | Kab. Pekalongan
36 | 11032622010613 | MULYONO | SMP N 1 SRAGI | Kab. Pekalongan
Spreadsheet: 175045d1345328009-new-sales-commission-calculations-vlookup-sales-commission
Sheet: Sheet1

 | Sales Rep | GP | Activations | Commission |  |  | Sales Rep | GP | Activations | Commission
 | [NAME] | 2184 | 20 | 360 |  |  | [NAME] | 2184 | 20 | 360
 | [NAME] | 1950 | 12 | 270 |  |  | [NAME] | 1950 | 12 | 180
 | Fred | 1250 | 13 | 202.8 |  |  | Fred | 1250 | 13 | 13013
 | [NAME] | 600 | 10 | 200 |  |  | [NAME] | 600 | 10 | 110
 | [NAME] | 450 | 5 | 36 |  |  | [NAME] | 450 | 5 | 60
 | The above uses a Area Factor Formula |  |  |  |  |  | The above uses a different scale per Rep.
 | Scale |  |  | Sales Rep | Area Factor |  | GP | Fred | [NAME] | [NAME] | [NAME] | [NAME]
GP | GP | $ per activation |  | Fred | 1.3 |  | 0 | 6 | 9 | 8 | 12 | 5
$0-500 | 0 | 8 |  | [NAME] | 2 |  | 501 | 11 | 12 | 10 | 15 | 15
$501-1000 | 501 | 10 |  | [NAME] | 1 |  | 1001 | 12 | 12 | 12 | 18 | 12
1001-1500 | 1001 | 12 |  | [NAME] | 1.5 |  | 1501 | 15 | 15 | 15 | 20 | 15
1501-2000 | 1501 | 15 |  | [NAME] | 0.9 |  | 2001 | 18 | 18 | 18 | 25 | 18
2001-2500 | 2001 | 18 |  |  |  |  | 2501 | 20 | 20 | 20 | 30 | 20
2501+ | 2501 | 20
Spreadsheet: 717490d1612699303-display-value-of-lowest-cell-in-column-example-formula-needed-ans
Sheet: Sheet1

Case 1 |  | Case 2 |  | Case 3 |  | Case 4 |  | Case 5
 | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | Fill the formula in B7
 |  |  | 90 |  | 90 |  | 90 |  | 90 |  | select B7:C7
 |  |  |  |  | 80 |  | 80 |  | 80 |  | with fill handle drag  to right till column K
 |  |  |  |  |  |  | 70 |  | 70
 |  |  |  |  |  |  |  |  | 60
 | 100 |  | 90 |  | 80 |  | 70 |  | 60
 | Shown above is just the sequence of what the formula would display assuming that it worked properly
Spreadsheet: 698109d1601748250-criteria-based-ranking-test
Sheet: Test

 |  |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Except | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-15 00:00:00 | [NAME] |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  |  | * Rank 1 is to be given for XXX & YYY items (in col. E), then ranking is to be done of only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.5 | Urgent | 2020-05-11 00:00:00 | [NAME] |  | 1
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 | [NAME] |  | 1
CTR_06 | 3.41 | Urgent | 2020-04-21 00:00:00 |  |  | 2
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00 | abc
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  |  | 3
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00 | Rand
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00 | al
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00 | Thor
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00 | YYY |  | 1
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 4
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 4
Spreadsheet: 706976d1606988587-merging-two-formulas-merging-two-formulas
Sheet: Sheet1

 |  | First Name | Last Name | Date Referral Received | Date of Contact/Appointment | Wait Time (COMM ONLY COLLECTION)
 |  | [NAME] | Bloggs | 2020-01-01 00:00:00 | 2020-01-01 00:00:00
 |  | [NAME] | Soaps | 2020-01-01 00:00:00 | 2020-01-09 00:00:00
 |  | Mrs | Claus | 2020-01-01 00:00:00 | 2020-01-16 00:00:00
 |  | Mr | Claus | 2020-01-01 00:00:00 | 2020-02-01 00:00:00
 |  | Mr | Elf | 2020-01-01 00:00:00 | 2020-03-25 00:00:00
 |  |  |  | 2020-01-01 00:00:00 | 2020-05-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00 | 2020-08-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00 | 2021-02-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00
 |  |  |  | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-11-30 00:00:00
 |  |  |  | Flood
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-06-30 00:00:00 |  | 979244.42
2001-07-28 00:00:00
60874 | 4568
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-06-30 00:00:00 |  | 275313.72
2001-07-28 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-06-30 00:00:00 |  | 702469.37
2001-07-28 00:00:00
500241
500391 | 7495
500392 | 1732
Duke Energy Trading and Marketing
21665 | oba | 73449.16 | POI 9109 Mobil Waha Plant
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant
20248 | trans | 141061.91
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27137 |  | -67.28
27123 |  | -6425.19 |  |  |  | 70169 | 269686.67
 |  |  |  |  |  | 3940 | 8155.8
Spreadsheet: 762035d1641372671-combine-columns-datas-for-identical-values-in-first-column-test5-2-
Sheet: result

node | supp Type | TAG | TAG_all
 | +ZX | text1 | text1
185 | +ZGuide(2)LIM(4) | text2 | text2
380 | ANC | supp(0001) | text3|supp(0001)
10000 | +ZGuide(2) | supp(0002) | tag2|tag3|supp(0002)
10020 | +ZGuideLIM | supp(0003) | supp(0003)
6000 | +ZGuideLIM | supp(0004) | tag4|supp(0004)
#N/A | #N/A | supp(0005) | tag5|tag6|supp(0005)
#N/A | #N/A | lmnopqrstuvz | tag7|tag8|abcdefghijklmnopqrstuvz
Spreadsheet: 100920d1299120094-return-1-or-0-based-on-date-range-vlookupdaterange
Sheet: Dates

 | A |  | B |  | C |  | D |  | E |  | W
 | Dates | # Days | dates | # Days | Dates | # Days | Dates | # Days | Dates | # Days | Dates | # Days
START | 2007-05-23 00:00:00 |  | 2007-04-10 00:00:00 |  | 2007-03-28 00:00:00 |  | 2007-01-22 00:00:00 |  | 2006-09-15 00:00:00 |  | 2008-01-24 00:00:00
END | 2007-09-20 00:00:00 |  | 2007-11-18 00:00:00 |  | 2007-09-25 00:00:00 |  | 2007-03-07 00:00:00 |  | 2007-05-30 00:00:00 |  | 2008-06-23 00:00:00
START | 2008-05-04 00:00:00 |  | 2008-06-18 00:00:00 |  | 2008-04-30 00:00:00 |  | 2007-11-05 00:00:00 |  | 2008-06-24 00:00:00 |  | 2008-09-16 00:00:00
END | 2008-11-03 00:00:00 |  | 2008-08-08 00:00:00 |  | 2008-06-26 00:00:00 |  | 2008-06-03 00:00:00 |  | 2008-08-11 00:00:00 |  | 2008-12-04 00:00:00
START | 2009-06-01 00:00:00 |  | 2009-09-15 00:00:00 |  | 2010-05-24 00:00:00 |  | 2011-02-22 00:00:00 |  | 2009-01-09 00:00:00 |  | 2009-01-26 00:00:00
END | 2009-10-02 00:00:00 |  | 2010-04-15 00:00:00 |  | 2010-12-17 00:00:00 |  | 2011-09-22 00:00:00 |  | 2009-07-31 00:00:00 |  | 2009-05-07 00:00:00
START | 2010-05-26 00:00:00 |  | 2011-06-15 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-07-15 00:00:00 |  | 2010-06-09 00:00:00 |  | 2009-06-10 00:00:00
END | 2010-09-03 00:00:00 |  | 2011-09-01 00:00:00 |  | 2012-09-15 00:00:00 |  | 2012-09-01 00:00:00 |  | 2010-08-01 00:00:00 |  | 2009-08-01 00:00:00
START | 2011-11-01 00:00:00 |  | 2013-01-15 00:00:00 |  | 2014-01-15 00:00:00 |  |  |  | 2011-03-05 00:00:00 |  | 2009-09-15 00:00:00
END | 2012-06-15 00:00:00 |  | 2013-08-15 00:00:00 |  | 2014-08-15 00:00:00 |  |  |  | 2011-06-15 00:00:00 |  | 2009-12-05 00:00:00
START | 2014-06-15 00:00:00 |  | 2014-06-15 00:00:00 |  |  |  |  |  | 2012-07-15 00:00:00
END | 2014-09-01 00:00:00 |  | 2014-08-01 00:00:00 |  |  |  |  |  | 2013-01-15 00:00:00