tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 272737d1382476957-create-a-list-of-unique-entries-that-did-not-meet-a-specific-criteria-create-list
Sheet: Sheet1

 |  | Need to create a list of unique entries that contains those items that did NOT perform a Test
 |  | Checkpoint | ID | Main doc | Sub Document |  |  | Lead | Explanation
 |  | CP1 | R19 | FFCCSS | FCS-Phase 1 |  |  | [NAME] | Not needed
 |  | CP1 | R22 | AA DD | AD- Main |  |  | [NAME] | No Time
 |  | CP2 | R54 | GGEE | GE-Phase 1 |  |  | [NAME] | Scheduled for next week
 |  | CP2 | R54 | GGEE | GE-Phase 2 |  |  | [NAME] | Scheduled for next week
 |  | CP2 | R432 | JS JS | JJ-234 |  |  | [NAME] | Scheduled for next week
 |  | CP1 | T123 | KPT-Phase 1 | [NAME] |  |  | [NAME] | Scheduled for next week
 |  | CP2 | T123 | KPT-Phase 1 | [NAME] |  |  | [NAME] | Scheduled for next week
 |  | ID | Main doc | Sub Document | Lead |  |  | Test | Running Total of "No" Tests | Explanation | Checkpoint | Date |  |  |  |  |  |  |  |  |  | Variable for formula project | Variable for formula interface | Project & Project Name | Project & Project Name & Doc Name
 |  | R19 | FF CC SS | FCS-Phase 1 | [NAME] |  |  | No |  | Not needed | CP1 | 2013-01-29 00:00:00
 |  | R19 | FF CC SS | FCS-Phase 1 | [NAME] |  |  | No |  | Not needed | CP1 | 2013-01-29 00:00:00
 |  | R19 | FF CC SS | FCS-Phase 1 | [NAME] |  |  | No |  | Not needed | CP1 | 2013-01-29 00:00:00
 |  | R20 | FF CC SS | FCS-Phase 2 | [NAME] |  |  | Yes |  |  | CP1 | 2013-01-29 00:00:00
 |  | R20 | FF CC SS | FCS-Phase 2 | [NAME] |  |  | Yes |  |  | CP1 | 2013-01-29 00:00:00
 |  | R20 | FF CC SS | FCS-Phase 2 | [NAME] |  |  | Yes |  |  | CP1 | 2013-01-29 00:00:00
 |  | R22 | AA DD | AD- Main | [NAME] |  |  | No |  | No Time | CP1 | 2013-02-09 00:00:00
 |  | R22 | AA DD | AD- Main | [NAME] |  |  | No |  | No Time | CP1 | 2013-02-09 00:00:00
 |  | R54 | GGEE | GE-Phase 1 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-04-04 00:00:00
 |  | R54 | GGEE | GE-Phase 1 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-04-04 00:00:00
 |  | R54 | GGEE | GE-Phase 2 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-04-04 00:00:00
 |  | T33 | YY TT EE 1 | YTE- quick fix | [NAME] |  |  | Yes |  |  | CP1 | 2013-02-02 00:00:00
 |  | R432 | JS JS | JJ-234 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-02-01 00:00:00
 |  | R432 | JS JS | JJ-234 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-02-01 00:00:00
 |  | R432 | JS JS | JJ-234 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-02-01 00:00:00
 |  | T123 | KPT | KPT-Phase 1 | [NAME] |  |  | No |  | Scheduled for next week | CP1 | 2013-03-01 00:00:00
 |  | T123 | KPT | KPT-Phase 1 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-04-15 00:00:00
 |  | T123 | KPT | KPT-Phase 1 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-04-15 00:00:00
 |  | T123 | KPT | KPT-Phase 1 | [NAME] |  |  | No |  | Scheduled for next week | CP2 | 2013-04-15 00:00:00
Spreadsheet: 85178d1285234229-lookup-allocation-demo
Sheet: Sheet1

 | NAMES | AMOUNT | MR A | MR B | MR C | MR D | MR E
COMMISSION | MR A | 10 | 10
COMMISSION | MR B | 40 |  | 40
COMMISSION | MR C | 35 |  |  | 35
COMMISSION | MR A | 55 | 55
COMMISSION | MR B | 50 |  | 50
COMMISSION | MR C | 20 |  |  | 20
COMMISSION | MR D | 45 |  |  |  | 45
COMMISSION | MR E | 15 |  |  |  |  | 15
 |  |  | 65 | 90 | 55 | 45 | 15
Spreadsheet: 22c7ed1e-e38e-4629-8a0a-f194bb805e20
Sheet: Sheet1

[NAME]: | [NAME] Number: | School Name: | School Number: | Student Hardware | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Thin Clients | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Proctor and DAS Hardware | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Networking | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
 |  |  |  | How many and what type of computer configurations used do students  use to test?  Include: |  |  |  |  | If thin client configurations are used by students, please provide: |  |  |  |  |  |  | How many and what type of computer configurations used do educators use to manage testing?  Include: |  |  |  |  |  |  |  |  | Are the following websites accessible from the testing stations?
 |  |  |  | Type of device (e.g., Netbooks, Android tablets, desktops) | OS and service pack level | CPU type, speed, and number of cores | Total system memory (RAM) | Screen resolution | Workstation or server class system | OS and service pack level | Software used to provide the desktop environment to the thin clients (VMware View, Citrix, NComputing) | CPU Type, speed, and number of cores | Total system memory (RAM) | How are connections made between client and server? | Number of thin clients served concurrently per server | OS and service pack level | CPU type, speed and number of cores | Total system memory (RAM) | Internet browser and version | [NAME] version | What is the maximum number of student workstations that will be used to administer tests concurrently? | How many are wireless? | How many are wired? | What is the network speed to the building (e.g., T1, T3, Cable Modem, XXMbps)? | https://utahtds.measuredprogress.org/ | https://utahdas.measuredprogress.org/
Spreadsheet: 698151d1601804395-formula-to-force-a-number-to-display-as-within-text-puzzle-and-conquest
Sheet: Sheet2

 | Infantry Att | Infantry Def | Infantry HP | [NAME] | [NAME] | Range HP | Calvery Att | Calvery Def | Calvery HP | Seige Att | Seige Def | Seige HP | [NAME] | [NAME] | Troop HP
[NAME] | 3.271 | 2.744 | 2.837 | 2.779 | 2.524 | 2.682 | 2.087 | 2.039 | 2.149 | 0.233 | 0.14 | 0.233 | 0.526 | 0.663 | 0.416
Total Boost
Spreadsheet: 588d061c-bbd8-4e03-81a6-8e2c0d90f1fa
Sheet: Table S9. KLS SAM Results

Current settings
Input parameters
Data type? |  |  |  |  |  |  |  | Two class unpaired
Array or Seq data? |  |  |  |  |  |  |  | array
Arrays centered? |  |  |  |  |  |  |  | False
Delta |  |  |  |  |  |  |  | 1.888291706922699
Minimum fold change |  |  |  |  |  |  |  | 2
Test statistic |  |  |  |  |  |  |  | standard
Are data are log scale? |  |  |  |  |  |  |  | False
Number of permutations |  |  |  |  |  |  |  | 100
Input percentile for exchangeability factor s0 |  |  |  |  |  |  |  | Automatic choice
Number of neighbors for KNN |  |  |  |  |  |  |  | 10
Seed for Random number generator |  |  |  |  |  |  |  | 96801393
Computed values
Estimate of pi0 (proportion of null genes) |  |  |  |  |  |  |  | 0.806
s0 percentile |  |  |  |  |  |  |  | 0
False Discovery Rate (%) |  |  |  |  |  |  |  | 0
List of Significant Genes for Delta = 1.888
Negative genes (10)
 | Row | Gene ID | [NAME] | Score(d) | Numerator(r) | Denominator(s+s0) | Fold Change | q-value(%)
 | 54963 | 5598827 | Irf8 | -10.0937041859504 | -276.97062 | 27.4399382919821 | 0.490697513542171 | 0
 | 43297 | 4551883 | Fkbp5 | -9.09256096905653 | -274.6587525 | 30.2069739685781 | 0.331299632347034 | 0
 | 62754 | 4400689 | Mcm10 | -8.31700038393038 | -67.5214375 | 8.11848435530446 | 0.433271892932299 | 0
 | 70890 | 4985018 | Notch1 | -8.14007811344543 | -254.6162475 | 31.2793371207871 | 0.317225182035297 | 0
 | 43300 | 5172249 | Fkbp5 | -7.31801969838385 | -452.951505 | 61.8953656410671 | 0.399863030901168 | 0
 | 53721 | 5396175 | Il6st | -7.26809175128806 | -1075.9799 | 148.041595623681 | 0.478841237060272 | 0
 | 94857 | 5217703 | [NAME] | -7.067299721462 | -185.9192625 | 26.3069729355612 | 0.336012593739665 | 0
 | 36670 | 4579266 | E2f8 | -6.94964366968038 | -252.148665 | 36.2822436638102 | 0.469931079533799 | 0
 | 34221 | 4617624 | Dirc2 | -6.92749845197771 | -167.68701 | 24.2059974697111 | 0.445228055730017 | 0
 | 12277 | 5052286 | Amdhd2 | -6.50070101956785 | -53.42182 | 8.21785524964065 | 0.361354284470989 | 0
 | Estimated Miss rates for Delta=1.[PHONE]
 |  | [NAME] | Cutpoints | Miss Rate(%)
 |  | 0 -> 0.05 | -6.456 -> -2.724 | 79.87
 |  | 0.05 -> 0.1 | -2.724 -> -2.147 | 70.43
 |  | 0.1 -> 0.15 | -2.147 -> -1.803 | 63.87
 |  | 0.15 -> 0.2 | -1.803 -> -1.535 | 55.16
 |  | 0.2 -> 0.25 | -1.535 -> -1.315 | 47.84
 |  | 0.25 -> 0.75 | -1.315 -> 0.394 | 12.45
 |  | 0.75 -> 0.8 | 0.394 -> 0.617 | 0
 |  | 0.8 -> 0.85 | 0.617 -> 0.882 | 0
 |  | 0.85 -> 0.9 | 0.882 -> 1.22 | 0
 |  | 0.9 -> 0.95 | 1.22 -> 1.76 | 0
 |  | 0.95 -> 1 | 1.76 -> 10.616 | 6.33
Spreadsheet: 62679d1263574712-merging-a-file-to-defined-file-format-example
Sheet: 5 Door

Section # |  |  | Category |  |  | Effective dates > |  |  |  | to
Market Area (s) |  |  | test
Door | Shelf | Shelf | Item Description | UPC | SLIN | FOD | Item Count | Notes
# | Number | Position
 | 1 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 | 2 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 | 3 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 | 4 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 | 5 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 | 6 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 | 1 | 1
 |  | 2
 |  | 3
 | 2 | 1
 | 3 | 1
 |  | 2
 | 4 | 1
 |  | 2
 |  | 3
 | 5 | 1
 |  | 2
 |  | 3
 |  | 4
 | 6 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 | 7 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 | 1 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 | 2 | 1
 |  | 2
 |  | 3
 |  | 4
 | 3 | 1
 |  | 2
 |  | 3
 | 4 | 1
 | 5 | 1
 |  | 2
 |  | 3
 | 1 | 1
 |  | 2
 |  | 3
 |  | 4
 | 2 | 1
 | 3 | 1
 |  | 2
 | 4 | 1
 | 5 | 1
 |  | 2
 | 1 | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 | 2 | 1
 |  | 2
 |  | 3
 |  | 4
 | 3 | 1
 |  | 2
 |  | 3
 | 4 | 1
 |  | 2
 |  | 3
Spreadsheet: 8ff804aa-2081-4698-9843-09e7da6220c8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PSA | Test | PSA | Prostate-Specific Antigen (PSA) Diagnostic, Serum | Prostate-Specific Ag Diagnostic, S | Electrochemiluminescent Immunoassay (ECLIA) | Plain, Red-Top Tube: Red OR Serum Gel Tube: SGT OR |  |  | 0.6 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 0.6 mL Additional Information: 1. Free PSA can only be added on within 12 hours of performing total PSA. [NAME] must have been shipped frozen. 2. Include patient's age. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm Reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Males: Age (Years)	PSA Upper Limit (ng/mL) <40	< or =2.0 40-49	< or =2.5 50-59	< or =3.5 60-69	< or =4.5 70-79	< or =6.5 > or =80	< or =7.2   Females: not applicable | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 84153 |  |  |  |  | Rochester
PSA | [NAME] | SERUM | Serum |  |  |  | Frozen | 180 days
PSA | Result | PSA | Prostate-Specific Ag Diagnostic, S | Prostate-Specific Ag Diagnostic, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2857-1 | Prostate specific Ag:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 84241d1284256405-how-to-list-a-sequence-of-invoices-expiring-the-same-day-excel-forum-
Sheet: billbook

# de oper. | # Cl | Pagador | Monto Facturas | Neto | [NAME] | [NAME] | Plazo Real | Plazos Meses | Retenido | Comision Fija | Intereses | Intereses | Gastos | [NAME] | # [NAME]
 |  |  | Totales | Desembolsato | Inicio | Vencimiento | Meses | Retenidos | % | CF | Real - TM | Reteditos - TM | Legales
1 | 1 |  | 15911.44 |  | 2010-08-13 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 1 |  | 8841.29 |  | 2010-08-20 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 2 |  | 6047.2 |  | 2010-08-20 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 3 |  | 13531.7 |  | 2010-08-20 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 1 |  | 11934.5 |  | 2010-08-26 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 2 |  | 6493.64 |  | 2010-08-27 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 1 |  | 14815 |  | 2010-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 1 |  | 3687.06 |  | 2010-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 2 |  | 5876.76 |  | 2010-09-03 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 1 |  | 9573 |  | 2010-09-03 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 4 |  | 17976.6 |  | 2010-09-08 00:00:00 |  |  |  |  |  |  |  |  |  | [PHONE]
 | 2 |  | 6399.39 |  | 2010-09-11 00:00:00
 | 1 |  | 9887 |  | 2010-09-11 00:00:00
 | 1 |  | 12040 |  | 2010-09-11 00:00:00
 | 3 |  | 9140 |  | 2010-09-11 00:00:00
 | 1 |  | 7000 |  | 2010-09-15 00:00:00
 | 2 |  |  |  | 2010-09-17 00:00:00
 | 1 |  | 12000 |  | 2010-09-22 00:00:00
 | 5 |  | 50000 |  | 2010-09-25 00:00:00
Spreadsheet: 873022d1719474544-help-with-formulas-to-populate-from-one-sheet-with-dynamic-data-to-another-sheet-as-a-list-auto-list
Sheet: Suggestion1

 | Filtered table, where 'Arrived' is between March 31, 2024 and April 29, 2024
 |  | Vessel_Name | Voy. No | Charterers | Position | Activity | Arrived | Sailed | Cargo | Quantity O/B | OPA | Managers
Spreadsheet: rick_buy__32782__Daily Treas By BU Q3
Sheet: Q3 to Date

 | Enron Corp.
 | Net Cash Source / (Use)
 | Current Day and Month to Date
 | 3rd Quarter 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-09-10 00:00:00
 |  |  |  |  | Total |  |  | MTD |  |  |  |  |  |  |  | Most
 |  |  |  |  | Q3 to Date |  |  | Sept |  | August |  | July |  |  |  | Current Day
 | Enron Transportation Services
 | Portland General Electric
 | Total Distribution
 | Enron North America
 | Enron South America
 | Total Americas
 | Europe
 | Global Markets
 | Industrial Markets
 | Networks
 | Other
 | Total Traditional Wholesale
 | Enron Broadband Services
 | EGEP
 | Other Wholesale (EE&CC)
 | Total Wholesale
 | Enron Energy Services
 | Enron Global Assets
 | Corp
 | Other
 | Total Enron*
 | ONLY includes cash movement monitored from Houston.
 | Does NOT include Canada, London or any other banking center.
 | Certain items such as payroll that is paid by Corp on behalf of a business unit has NOT been allocated to the
 | business units.
 | *Includes an inflow in the month of July of $915 MM and an outflow in the month of August of $915 MM,
 | all related to the Marlin refinancing.
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -34078 | -40000
2 | -35189 | -33000
3 | -29296 | -34000
4 | -36491 | -35000
5 | -38539 | -36000
6 | -38013 | -38500
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 61952
2002-03-06 00:00:00
CBS Volume
 |  |  | 33105
Spreadsheet: 355927d1414860566-auto-filter-test-marks
Sheet: Absent

Name | Marks Science | Maths | English | Physics | History | GK | Remarks
Spreadsheet: 874332d1720910310-taking-school-name-from-different-sheet-try4-copy
Sheet: LU12

TENPIN BOLING MSSD TUARAN
BOY UNDER 12 YEARS OLD
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1 |  | 53 | 58 | 62 | 56
2 | MUHAMMAD NAZMI AMANI BIN RAMSIN | 75 | 93 | 89 | 89
3 | [NAME] | 59 | 64 | 61 | 43
4 | MUHAMMAD ADAM HAZIQ BIN ROSIDI | 86 | 73 | 112 | 84
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1 |  | 98 | 135 | 84 | 90
2 | [NAME] CALEB MICHEAL JAUNGIN | 57 | 56 | 61 | 58
3 | 0
4 | 0
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1 |  | 46 | 83 | 72 | 64
2 | EYRLEWELL JEMAIDI | 50 | 74 | 75 | 58
3 | [NAME] | 52 | 53 | 59 | 51
4 | EYRLEO JEMAIDI | 67 | 71 | 82 | 82
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1 |  | 43 | 67 | 26 | 62
2 | 0
3 | 0
4 | 0
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1 |  | 76 | 86 | 158 | 122
2 | [NAME] VIJAYA | 83 | 65 | 72 | 82
3 | 0
4 | 0
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1 |  | 68 | 51 | 79 | 82
2 | ANNAS NAFEESH BIN A JAMREY | 50 | 68 | 46 | 86
3 | MOHD. [NAME] | 66 | 45 | 37 | 83
4 | MOHD RAYEES SYAMI KOK [NAME] ZAKARIA | 55 | 63 | 61 | 54
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1 |  | 24 | 61 | 67 | 66
2 | INDRA PUTERA BIN INDRA SAHRIL | 46 | 44 | 46 | 49
3 | IMMANUEL MARINUS | 47 | 53 | 57 | 53
4 | MUHAMMAD ZHAREEF IRFAN AMANI BIN MOHD ZUHARMAN | 70 | 55 | 112 | 78
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1
2 | 0
3 | 0
4 | 0
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1
2 | 0
3 | 0
4 | 0
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1
2 | 0
3 | 0
4 | 0
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1
2 | 0
3 | 0
4 | 0
BIL | NAMA | GAME 1 | GAME 2 | GAME 3 | GAME 4 | INDIVIDU | RANK | BERGU | RANK | PASUKAN | RANK
1
2 | 0
3 | 0
4 | 0
Spreadsheet: 806392d1669277063-rolling-average-excluding-blank-cells-but-including-zeros-sample-34-ans4
Sheet: Sheet1

ID | VALUE | val_roll_ave | FORMULA | REQUIRED
1 | 123.2739130434782 |  |  | 123.2739130434782
1 | 8.18 |  |  | 65.72695652173913
1 | 41.81666666666666 |  |  | 57.75685990338164
1 |  |  |  |  | <--- should ignore the blank cell B5
1 | 0 |  |  |  | <--- should include the 0 in cell [NAME]
1 | 7.15
1 | 90.28749999999998
1
1 | 12.65
1 | 121.5333333333333 |  |  |  | Row
1 | 39.25
1
1 | 15.4
1 | 0
1 | 62.0611111111111
1 | 35.8
1
1 | 49.56666666666666 |  |  |  |  | Manual
1 | 126.6560606060606
1 | 23.06666666666667
1 | 126.6560606060606
1 | 23.06666666666667
1 | 177.1351724137931
1 | 8.4 |  |  |  |  | Manual
2 | 12
2 |  |  |  |  | <--- should ignore the blank cell B27
2 | 110
2 | 0 |  |  |  | <--- should include the 0 in cell B29
2
Spreadsheet: 48067d1247239373-drop-list-with-large-database-estimating_test
Sheet: Database

[NAME] |  | Price |  | Supplier
6mm Cl Temp |  | 2.68 |  | RHill
10mm Cl Temp |  | 6.76 |  | RHill
12mm Cl [NAME] |  | 8.33 |  | RHill
15mm Cl [NAME] |  | 14.5 |  | RHill
19mm Cl [NAME] |  | 20.42 |  | RHill
5mm Cl Mirror |  | 3.5 |  | Classic
Spreadsheet: 72788d1273516843-referencing-adjacent-cell-to-return-highest-figure-hilow-forum
Sheet: Sheet1

2.7 | 14.6
0
0
0
0
0
0
1.7 | 4
-4.3 | 6
0
-6.6 | 9.5
0
0
-9.6 | 3.9
0
0
0
-0.5 | 0.5
-0.4 | 4.1
7.5 | 17.8
-6.8 | 1.9
13.4 | 13.8
12.5 | 18.8
17 | 37.7
0
0
-1.7 | 1
0
0
0
7 | 8.1
-1.3 | 4.1
0
0
0
16.1 | 16.5
0
-0.4 | 12.6
0
-7 | 0.4
0
0
-13.1 | 3.3
0
3.2 | 10.2
Spreadsheet: 143112d1330205563-help-with-if-excel-function-sample_if
Sheet: Sheet1

 |  |  |  |  | NOT TESTED | Summary
 |  |  |  | Test 1
 |  |  |  | Test 2
 |  |  |  | Test 3
 |  |  |  | Test 4
 |  |  |  | Test 5
 |  |  |  | Test 6
 |  |  |  | Test 7
 |  |  |  | Test 8
 |  |  |  | Test 9
 |  |  |  | Test 10
 |  |  |  | Test 11
 |  |  |  | Test 12
 |  |  |  | Test 13
 |  |  |  | Test 14
 |  |  |  | Test 15
 |  |  |  | Test 16
 |  |  |  | Test 17
 |  |  |  | Test 18
 |  |  |  | Test 19
 |  |  |  | Test 20
 |  |  |  | Test 21
 |  |  |  | Test 22
 |  |  |  | Test 23
 |  |  |  | Test 24
 |  |  |  | Test 25
 |  |  |  | Test 26
 |  |  |  | Test 27
 |  |  |  | Test 28
 |  |  |  | Test 29
 |  |  |  | Test 30
 |  |  |  | Test 31
 |  |  |  | Test 32
 |  |  |  | Test 33
 |  |  |  | Test 34
 |  |  |  | Test 35
 |  |  |  | Test 36
 |  |  |  | Test 37
 |  |  |  | Test 38
 |  |  |  | Test 39
 |  |  |  | Test 40
 |  |  |  | Test 41
 |  |  |  | Test 42
 |  |  |  | Test 43
 |  |  |  | Test 44
Spreadsheet: 172344d1344151299-help-in-creating-ticket-logging-sheet-on-excel-helpdesk-ticket-logging
Sheet: Helpdesk Ticket Logging

 |  | Help Desk Ticket Logging System
 |  |  |  |  |  |  |  |  |  | Submit
 |  | Ticket No | Auto Generate |  | Date | Date Picker |  |  |  | Next
 |  | Employee Name | Feed |  | Location | [NAME] |  |  |  | Previous
 |  | Department | Feed |  | Employee ID | Manual Feed |  |  |  | Hold
 |  | Category | [NAME] |  | Seat No | Manual Feed
 |  | Sub Category | Drop Down Linked to Category |  | Complaint | Query | Request | [NAME] |  | Generate Reports
 |  | Description |  |  |  |  |  |  |  | Employee Wise
 |  | Manual Feed |  |  |  |  |  |  |  | Location Wise
 |  |  |  |  |  |  |  |  |  | Categories Wise
 |  |  |  |  |  |  |  |  |  | Date Wise
 |  | Open Time |  | Close Time |  | Total Time | Automated
 |  | SLA% |  | Approved SLA | Automated Linked to Catergory | Status | Droped Down |  | Open | Closed | Pending
 |  | Ticket Assigned To | Manual |  | Ticket Closed By | M
 |  | In Case of Not Meeting SLA Justification
 |  | Manual
Spreadsheet: 81097d1281367301-excel-2007-add-only-certain-cells-in-column-budget
Sheet: TONO LOG

DATE | TRAVELER | DOC NUMBER | REASON | DATES OF TRAVEL | EST COST | ACTUAL COST | PROJECT
2010-05-15 00:00:00 | [NAME] | 11112411EC001 | TRAINING IN CA | 30MAY-15JUN | 1300 | 13200 | TRAVEL
 |  | 11112411EC002
 |  | 11112411EC003
 |  | 11112411EC004
 |  | 11112411EC005
 |  | 11112411EC006
 |  | 11112411EC007
 |  | 11112411EC008
 |  | 11112411EC009
 |  | 11112411EC010
 |  | 11112411EC011
 |  | 11112411EC012
 |  | 11112411EC013
 |  | 11112411EC014
 |  | 11112411EC015
 |  | 11112411EC016
 |  | 11112411EC017
 |  | 11112411EC018
 |  | 11112411EC019
 |  | 11112411EC020
 |  | 11112411EC021
 |  | 11112411EC022
 |  | 11112411EC023
 |  | 11112411EC024
 |  | 11112411EC025
Spreadsheet: 54056d1254067623-max-number-criteria-max
Sheet: Sheet1

 |  | Table#1 |  |  |  |  |  |  |  |  |  | Table#2
Step-1 Empty data |  | data input |  |  |  |  |  |  |  |  | Show all Number
 |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  | 0 |  |  |  |  | 0
 |  | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  | 1 |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3 |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5 |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6 |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  | 9
Step-2 If input 1st Time 6 number |  |  |  |  |  |  |  |  |  |  | Show same number
(any ROW input) |  | 1 | 2 | 3 | 4 | 5 | 6
Ex. Input number |  |  |  |  |  |  |  |  |  |  |  | 1
1,2,3,4,5, and 6 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
Step-3 If input 2nd Time |  |  |  |  |  |  |  |  |  |  | [NAME] same number
(any ROW input) |  | 1 | 2 | 3 | 4 | 5 | 6
Ex. Input next number |  | 3 | 4 | 5 | 6 | 7 | 8
3,4,5,6,7 and 8
[NAME] same number are |  |  |  |  |  |  |  |  |  |  |  | 3
3,4,5, and 6 |  |  |  |  |  |  |  |  |  |  |  | 4
(2 time match) |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
Step-3 If input 3th Time or next ….. |  |  |  |  |  |  |  |  |  |  | [NAME] same number
(any ROW input) |  | 1 | 2 | 3 | 4 | 5 | 6
Ex. Input next number |  | 3 | 4 | 5 | 6 | 7 | 8
6,7,8,9,0 and 1 |  | 6 | 7 | 8 | 9 | 0 | 1
[NAME] same number is
number 6
(3 time match)
 |  |  |  |  |  |  |  |  |  |  |  | 6