tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69361d1269899879-excel-2007-multiple-conditionals-risk-and-issue-register-example
Sheet: Issue Log

Issues - 24/03/2010
Impact Area Key |  |  |  | [NAME]
ALL - All BTD Sections BS - Business Services PSO - Payment Systems Oversight A&F - Admin & Financial A&S - Architecture & Security SD - Systems Development QA - Quality Assurance IS - Infrastructure Services |  |  |  | High (H) - Critical Path issue. Non-resolution will effect target release dates.
 |  |  |  | Medium (M) - Non-resolution will cause slippage but not an immediate effect on target release dates.
 |  |  |  | Low (L) - Non-resolution will cause slippage/effect quality but will not impact delivery dates.
Log No | [NAME] | Description | Impact Area | Resolution Strategy |  |  | Impact | Owner | Date Identified | Target Resolution Date | Days Exceeded Target Resolution Date | Days Risk Has Been Active | Date Resolved | Status
1 |  | Delay to select a BTD Partner will impact the timeline to complete this project. There will be a series of critical planning as part of the Partner's solution delivery. | ALL | The current delay to conclude the Partner selection process is Jan 31st. This is being closely managed by Project Owner to ensure no slippage. 14th March - Official letter from P&M Dept. Building completion date will be "end of 2011". BTD will interpret this, for our RFP timelines, to be 30th December 2011. The current planning allows for sufficient time for vendor selection process. |  |  | H | AF | 2009-12-15 00:00:00 | 2010-01-31 00:00:00 | 58 | 89 | 2010-03-14 00:00:00 | CLOSED
2 |  | Delay in meeting with Projects & Maintenance department will directly impact the decision making and tasks of the Project Ignite team. | ALL | There is a meeting that will hopefully happen next week which will mitigate future risks and address this issue. |  |  | H | AF | 2009-12-15 00:00:00 | 2010-01-18 00:00:00 | 71 | 89 | 2010-03-14 00:00:00 | CLOSED
3
Spreadsheet: 770130d1645818877-offset-with-count-not-working-horizontally-problem-child
Sheet: week2

[NAME] | 5 | 4 | 6 | 5 | 4 | 6 | 2 | 5 | 4
Vance
Team 3
Team 4
Team 5
Team 6
Team 7
Team 8
Team 9
Team 10
Spreadsheet: 151373d1334874669-copying-data-to-another-worksheet-ist-answer-sheet
Sheet: TEST #1

TEST 01 ANSWERS
POSITION |  | 0 |  |  | INIT | 0
LAST NAME |  | 0
1 | C |  | 0
2 | A |  | 0
3 | D |  | 0
4 | B |  | 0
5 | C |  | 0
6 | C |  | 0
7 | A |  | 0
8 | D |  | 0
9 | D |  | 0
10 | C |  | 0
11 | B |  | 0
12 | D |  | 0
13 | B |  | 0
14 | C |  | 0
15 | B |  | 0
16 | B |  | 0
17 | D |  | 0
18 | B |  | 0
19 | C |  | 0
20 | B |  | 0
21 | A |  | 0
22 | B |  | 0
23 | D |  | 0
24 | A |  | 0
25 | C |  | 0
 |  |  | 0 | Points
 |  |  | 0 | %
Spreadsheet: 675204d1588192935-i-need-some-help-with-an-index-and-match-function-tracker-excel-blank-etaf-2-
Sheet: Sheet2

Size | Stage | Allocation
S | Stage 1 | 5
S | Stage 2 | 0
S | Stage 3 | 0
S | Stage 4 | 0
S | Stage 5 | 5
S | Stage 6 | 10
S | Stage 7 | 0
M | Stage 1 | 0
M | Stage 2 | 0
M | Stage 3 | 0
M | Stage 4 | 5
M | Stage 5 | 10
M | Stage 6 | 15
M | Stage 7 | 0
L | Stage 1 | 10
L | Stage 2 | 9
L | Stage 3 | 8
L | Stage 4 | 7
L | Stage 5 | 6
L | Stage 6 | 5
L | Stage 7 | 4
XL | Stage 1 | 22
XL | Stage 2 | 0
XL | Stage 3 | 10
XL | Stage 4 | 10
XL | Stage 5 | 20
XL | Stage 6 | 50
XL | Stage 7 | 0
Spreadsheet: 764990d1643109937-highlight-a-range-with-a-list-by-selecting-start-and-end-rang-colored
Sheet: Sheet1

 |  |  | Start | A9 | 102
 |  |  | End | A5 | 104
 | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9 | A10 | A11 | A12
101
102
103
104
105
106
107
 |  | Please, without VBA
 |  |  | Please, with conditional formatting
 |  |  | I need a red colored range
Spreadsheet: 49991d1249407394-count-numbers-in-columns-football-betting
Sheet: Sheet1

Teams | Game 1 | Week # | Result | Game 2 | Week # | Game 3 | Week # | Gam 4 | Week #
Florida Gators | Troy | 2 |  | Tennessee | 3 | At Kentucky | 4 | Arkansas | 7
Texas Longhorns | At Wyoming | 2 |  | UTEP | 4 | Colorado | 6 | At Baylor | 11
USC Trojans | San Jose State | 1 | L | At Washington | 3 | Washington State | 4 | Stanford | 11
Oklahoma Sooners | Tulsa | 3 |  | Baylor | 6 | Kansas State | 9 | Texas A&M | 11
LSU Tigers | At Washington | 1 | W | [NAME] | 2 | UL Lafayette | 3 | At Miss State | 4
Ohio State Buckeyes | Navy | 1 | W | At Toledo | 3 | Illionois | 4 | At Indiana | 5
Spreadsheet: 796316d1663222746-formula-return-empty-if-the-cell-is-empty-sample-formula
Sheet: MANUAL (2)

Mercedes-Benz B-Class B 180 BlueEFFICIENCY (W246) 2011 - 2018
Year
2011 - 2018
Series
B 180 BlueEFFICIENCY (W246)
Body
Hatchback
Engine
Petrol
KW
90
Notes
Set Vehicle
Mercedes-Benz B-Class B 180 CDI (W246) 2011 - 2018 | Mercedes-Benz B-Class B 180 CDI (W246)
Year
2011 - 2018
Series
B 180 CDI (W246)
Body
Hatchback
Engine
Diesel
KW
80
Notes
Set Vehicle
Mercedes-Benz A-Class A 180 BlueEFFICIENCY (W176) 2012 - 2018
Year
2012 - 2018
Series
A 180 BlueEFFICIENCY (W176)
Body
Hatchback
Engine
Petrol
KW
90
Notes
Set Vehicle
Mercedes-Benz A-Class A 180 CDI (W176) 2012 - 2018
Year
2012 - 2018
Series
A 180 CDI (W176)
Body
Hatchback
Engine
Diesel
KW
80
Notes
Mercedes-Benz CLA-Class CLA 180 (C117) 2013 - 2018
Year
2013 - 2018
Series
CLA 180 (C117)
Body
Coupe
Engine
Petrol
KW
90
Notes
Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: Totals

 | BACHMANN | BN |  |  | 2021 | 2022 | 2023 | 2024 |  | 2021 | 2022 | 2023 | 2024 |  |  |  | 2021 | 2022 | 2023 | 2024 |  |  | % by BII |  | CHANGE FROM FINAL
Jan |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 180179 | 0 | 0 |  | Jan
Feb |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 323248.7 | 0 | 0 |  | Feb
Mar |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 414090.96 | 0 | 0 |  | Mar
Apr |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 271441.9 | 0 | 0 |  | Apr
May |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 104082.4 | 0 | 0 |  | May
Jun |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 341680 | 0 | 0 | 0 |  | Jun
Jul |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 424606.85 | 0 | 0 | 0 |  | Jul
Aug |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308699.3 | 0 | 0 | 0 |  | Aug
Sep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 423083 | 0 | 0 | 0 |  | Sep
Oct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 222050.1 | 0 | 0 | 0 |  | Oct
Nov |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 305407.13 | 0 | 0 | 0 |  | Nov
Dec |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 263438 | 0 | 0 | 0 |  | Dec
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2288964.38 | 1161473.66 | 0 | 0
 |  |  |  |  | JOB LISTS YEAR TAB |  |  |  |  | MASTER [NAME] |  |  |  |  |  |  | MASTER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3450438.04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COPIED AND PASTED FINAL OI NUMBERS
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  | 2021 YEAR END
 |  |  |  |  | 2288964.38
 |  |  |  |  | text pasted
 |  |  |  |  | 2022-04-28 00:00:00
 |  |  |  |  | 2288523.08
 |  |  |  |  | [NAME]'s OI
 |  |  |  |  | original tally
Spreadsheet: 86931d1286889167-count-bullets-performanceeval
Sheet: Eval

SECTION 1: Performance Factors
Knowledge/Skills/Ability
Current Performance Goal(s)/Action Items/Measurement(s):
EXCEPTIONAL |  | SUCCESSFUL |  |  | NEEDS IMPROVEMENT
7 | 6 | 5 | 4 | 3 | 2 | 1
Supporting Documentation/Explanation:
(Required for a rating of 1, 2, 6 & 7, Recommended for a rating of 3 thru 5)
Future Performance Goal(s)/Action Items/Measurement(s):
Quality of Work
Current Performance Goal(s)/Action Items/Measurement(s):
EXCEPTIONAL |  | SUCCESSFUL |  |  | NEEDS IMPROVEMENT
7 | 6 | 5 | 4 | 3 | 2 | 1
Supporting Documentation/Explanation:
(Required for a rating of 1, 2, 6 & 7, Recommended for a rating of 3 thru 5)
Future Performance Goal(s)/Action Items/Measurement(s):
Looking to count the number of 7's, 6's, 5's, 4's, 3's, 2's, & 1's that are selected in each of the 7 columns
Spreadsheet: 162342d1339803036-excel-2007-how-to-return-different-values-in-a-range-according-to-date-without-repeating-the-same-mjc-registro-interactivo
Sheet: TNSR

TOTAL DE  NOTAS DE LOS ESTUDIANTES SEGUNDO R
[NAME] |  |  |  |  | 1ER SEMESTRE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2DO SEMESTRE
 |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS |  |  |  |  |  |  |  |  |  |  |  |  | PROYECTOS O EXAMENES |  |  |  | PUNTOS [NAME] SUMATIVAS
NOMBRE DEL ALUMNO |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | RESUMEN 1ER SEM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESUMEN 2DO SEM |  |  |  | TOTAL
 |  |  |  |  | A
Apellido 1ro |  | Apellido 2do | Nombre |  | N1 | N2 | N3 | N4 | SUMATIVA1 | SUMATIVA2 | SUMATIVA3 | [NAME] | SUMATIVA5 | SUMATIVA6 | SUMATIVA7 | SUMATIVA8 | SUMATIVA9 | [NAME] | [NAME] | [NAME] | NOTA | N5 | [NAME] | N7 | N8 | SUMATIVA10 | [NAME] | SUMATIVA12 | SUMATIVA13 | [NAME] | SUMATIVA15 | SUMATIVA16 | SUMATIVA17 | SUMATIVA18 | [NAME] | [NAME] | [NAME] | NOTA | [NAME] | [NAME] | [NAME] | NOTA |  |  | SEXO
 |  |  |  |  |  | A
 |  |  |  |  |  | D
 |  |  |  |  | N | N | N | N | N | N |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 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
 |  |  |  | 32
 |  |  |  | 33
 |  |  |  | 34
 |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a1 |  |  | d1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a2 |  |  | d2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b1 |  |  | f1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | b2 |  |  | f2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c2
Spreadsheet: 2c173370-ba5a-4110-bc2c-75db4b42d622
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
[NAME] | Test | [NAME] | MPL Exon 10 Mutation Detection, Bone Marrow | MPL Exon 10 Mutation Detection, BM | Mutation Detection in DNA Using Sanger Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA |  |  | 2 | mL | [NAME] must arrive within 168 hours of collection.   Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD [NAME]: 2 mL Collection Instructions: 1. Invert several times to mix bone marrow. 2. Send specimen in original tube. Additional Information: Collection date is required. Forms:  1. Hematopathology Patient Informations Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday | 5 days | 8 days | 1 | 81403 |  |  |  |  | Rochester
[NAME] | [NAME] | BNMARW | Bone Marrow |  |  |  | Ambient | 7 days
[NAME] | Result | 20232 | Final Diagnosis: | Final Diagnosis: | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34574-4
Spreadsheet: 695326d1600156320-filling-cells-with-script-formula-test-excel
Sheet: Full Check works

![NAME] | [NAME] | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | TOPRINT | MEMO |  |  | PO | Entry Date | Total | Vendor
!SPL | SPLID | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | QNTY | MEMO |  |  | EB2000000362 | 09/09/2020 | 258.08 | A Test
!ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB1000124706 | 09/09/2020 | 16 | B Test
TRNS |  | Credit Card | 09/09/2020 | Chase | A Test | Web | -258.08 | N | N | EB2000000362 |  |  | EB2000000298 | 09/08/2020 | 317.22 | A Test
SPL |  | Credit Card | 09/09/2020 | Cost of Goods Sold |  | Web | 258.08 | N | N |  |  |  | EB2000000319 | 09/08/2020 | 16.17 | A Test
ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000329 | 09/08/2020 | 35.08 | B Test
![NAME] | [NAME] | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | TOPRINT | MEMO |  |  | EB2000000008 | 09/02/2020 | 44.32 | A Test
!SPL | SPLID | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | QNTY | MEMO |  |  | EB1000126195 | 08/27/2020 | 299.17 | A Test
!ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB1000126195 | 08/27/2020 | 0 | B Test
TRNS |  | Credit Card | 09/09/2020 | Chase | B Test | Web | -16 | N | N | EB1000124706 |  |  | EB2000000317 | 09/08/2020 | 12.46 | A Test
SPL |  | Credit Card | 09/09/2020 | Cost of Goods Sold |  | Web | 16 | N | N |  |  |  | EB1000125937 | 08/26/2020 | 74.41 | A Test
ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000323 | 09/08/2020 | 146.57 | B Test
![NAME] | [NAME] | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | TOPRINT | MEMO |  |  | EB2000000324 | 09/08/2020 | 108.23 | A Test
!SPL | SPLID | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | CLEAR | QNTY | MEMO |  |  | EB2000000332 | 09/08/2020 | 39.52 | A Test
!ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000337 | 09/08/2020 | 119.17 | B Test
TRNS |  | Credit Card | 09/08/2020 | Chase | A Test | Web | -317.22 | N | N | EB2000000298 |  |  | EB2000000331 | 09/08/2020 | 576.08 | A Test
SPL |  | Credit Card | 09/08/2020 | Cost of Goods Sold |  | Web | 317.22 | N | N |  |  |  | EB2000000326 | 09/08/2020 | 42.55 | A Test
ENDTRNS |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000308 | 09/08/2020 | 42.45 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000335 | 09/08/2020 | 102.73 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000318 | 09/08/2020 | 46.96 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000322 | 09/08/2020 | 103.6 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000301 | 09/08/2020 | 40.66 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000344 | 09/09/2020 | 45.47 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000330 | 09/08/2020 | 62.05 | B Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000312 | 09/08/2020 | 168.58 | A Test
 |  |  |  |  |  |  |  |  |  |  |  |  | EB2000000300 | 09/08/2020 | 119.17 | A Test
Spreadsheet: 732587d1621024870-possible-vlookup-function-trying-to-search-through-multiple-sheets-summary-v3
Sheet: PROJECT SUMMARY

(NAME) CONSERVATION PROJECT SUMMERY CAMP REIMBURSABLE |  |  |  |  |  |  |  |  |  |  |  | Month:
Crew and Equipment |  |  |  |  |  |  |  |  |  |  |  | Production |  |  |  | Value breakdown
PROJECT NUMBER | Number of Members | Crew Sup Days | Crew Sup OT HOURS | Camp Sup Days | Camp Sup OT Hours | CCV DAYS (C01) | CCV Miles (C01) | Support Vehicle DAYS | Support Vehicle Miles | Additional Saws | Chipper Days | FUEL REDUCTION ACRES | [NAME] | [NAME] | [NAME] | Member Cost | Crew Sup Daily Rate | Crew Sup OT Cost | Camp Sup Daily Rate | Camp Sup OT Cost | CCV DAILY COST | CCV Mileage Cost | Support Vehilce Daily Cost | Support Vehicle Mileage | Chainsaw Cost | Chipper Cost | Daily Cost | Minus Match | Billable Cost | Cost Per Acre | REMAINING WO AMOUNT
089
Totals
Spreadsheet: 159617d1338786050-excel-2007-finding-unique-customers-in-a-column-for-each-sale-rep-through-formula-count-unique-value-modified
Sheet: Sheet3

[NAME] | <<< [NAME]
 |  |  |  |  | List of Sale Persons
 |  |  |  |  | [NAME]
CATEGORY | NO. OF CUSTOMERS |  |  |  | Junaid
IBS |  | ?? |  |  | [NAME]
IPS |  | ?? |  |  | Anwarzeb
INDS |  | ?? |  |  | [NAME]
[NAME] |  | ?? |  |  | [NAME]
SPARES |  | ?? |  |  | Company
TOTAL |  |  |  |  | Service
 |  |  |  |  | Usman
OLD/NEW | NO. OF CUSTOMERS
Old |  | ??
New |  | ??
TOTAL
OLD/NEW | NO. OF CUSTOMERS
Retail |  | ??
Textile |  | ??
Others |  | ??
Manufacturing |  | ??
Packaging & Printing |  | ??
Financial services |  | ??
Government |  | ??
[NAME] |  | ??
FMCG |  | ??
Healthcare |  | ??
Automobile |  | ??
Distributor |  | ??
Telecom |  | ??
Reseller |  | ??
Courier |  | ??
Education |  | ??
Hotel |  | ??
Engineering |  | ??
TOTAL
Spreadsheet: 746978d1631156195-configure-an-excel-sheet-to-solve-a-firefighters-job-posting-firehouse
Sheet: Sheet1

 |  | Choices
Seniority | Name | Choice1 | Choice2 | Choice3 | Choice4 | Choice5
2021-01-01 00:00:00 | Firefighter A
2021-02-01 00:00:00 | Firefighter B
2021-03-01 00:00:00 | Firefighter C
2021-04-01 00:00:00 | Firefighter D
2021-05-01 00:00:00 | Firefighter E
Available firehouse | Flag.on.1 | List only 1
2
3
5
5
10
15
17
17
20
26
26
26
30
Spreadsheet: 178497d1346814658-need-formula-to-find-matches-then-populate-other-cells-genre
Sheet: Sheet1

ID# | Title | [NAME] |  | Titles on Order | [NAME] for Titles on Order
1 | To Kill a Mockingbird | Classics |  | a
2 | a | Biography |  | b
3 | b | Children's |  | To Kill A Mockingbird
4 | xxxxxxx | xxxx |  | c
5 | xxxxxxx | xxxx
6 | xxxxxxx | xxxx
7 | xxxxxxx | xxxx
8 | xxxxxxx | xxxx
9 | xxxxxxx | xxxx
10 | xxxxxxx | xxxx
11 | xxxxxxx | xxxx
12 | xxxxxxx | xxxx
Spreadsheet: 599732d1543282941-budget-array-formula-lookup-pulling-transactions-in-wrong-order-budget-copy
Sheet: Budget

 |  | Fortnightly Budget
 |  |  | Income |  |  |  | Expenses |  |  |  | Bills
 |  |  |  | Primary | 1702.5 |  |  | Groceries | 200 |  |  | Rent | 780
 |  |  |  | Secondary | 586.11 |  |  | Savings | 200 |  |  | ZipPay | 200
 |  |  |  | Meal Card | 100 |  |  | Going out | 200 |  |  | Fines | 150
 |  |  |  |  |  |  |  | Shopping | 100 |  |  | Tax Debt | 100
 |  |  |  |  |  |  |  | Transport | 15 |  |  | Internet | 39.975
 |  |  |  |  |  |  |  |  |  |  |  | Electricity
 |  |  |  |  |  |  |  |  |  |  |  | Water
 |  |  |  |  |  |  |  |  |  |  |  | Gas
 |  |  |  |  |  |  |  |  |  |  |  | Phone | 4
 |  |  |  |  |  |  |  |  |  |  |  | AfterPay | 0
 |  |  |  | Total |  |  |  | Total |  |  |  | Total
 |  |  | Top 5 Expenses this fortnight
 |  |  |  |  |  |  |  |  |  |  | If sorted by amount, this row should be 3rd
 |  |  |  |  |  |  |  |  |  |  | and this one should be 4th
 |  | Fortnightly Pay & Expenses Summary
 |  |  | Week Begin | Week End | Income | Expenses | Groceries | Transport | Going Out | Savings | Shopping | Bills
 |  |  |  | 2018-10-25 00:00:00 | 2398.23 | -862.51 | -312.47 | -15 | -310.04 | -200 | -25 | -1536.71
 |  |  |  |  | 2775.29 | -1681.21 | -139.67 | -30 | -741.7200000000003 | -200 | -569.82 | -1321.17
 |  |  |  |  | 2398.23 | -631.7800000000001 | -22.65 | -35 | -349.13 | -150 | -75 | -1295.99
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: DK

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 2f09984e-2170-4206-93a2-677d3d818ed0
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
 | 8501.0 Retail Trade, Australia
 | TABLE 16. Retail Turnover, Completely Enumerated sector: Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total CE and [NAME] ; |  |  | Original | [NAME] | 1994-04-01 00:00:00 | 2011-01-01 00:00:00 | 202 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350334L | 1994-04-01 00:00:00 | 2011-01-01 00:00:00 | 202 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ; |  |  | Trend | A3350340J | 1994-04-01 00:00:00 | 2011-01-01 00:00:00 | 202 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Original | A3350329V | 1994-04-01 00:00:00 | 2011-01-01 00:00:00 | 202 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Seasonally Adjusted | A3350335R | 1994-04-01 00:00:00 | 2011-01-01 00:00:00 | 202 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ; |  |  | Trend | A3350341K | 1994-04-01 00:00:00 | 2011-01-01 00:00:00 | 202 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 869302d1715885010-sumproduct-pricing-table-threshold-calculation-issue-threshold_test
Sheet: Bag price Luggage Logistics

From | 1 | per 1000 units |  | Threshold | diff
1 | 83000 | 26.58 |  |  |  |  |  | 83000
 | 166000 | 20.63 |  |  |  |  |  | 83000
 | 250000 | 16.83
 | 500000 | 12.15
 | 1000000 | 8.4
 | 2000000 | 5.16 |  |  |  |  | Total
 | 999999999 | 3.8
Input units |  | 200000
Output price | my formula |  | "=SUMPRODUCT(--(C11>$E$2:$E$8),(C11-($E$2:$E$8)), $[NAME]
 | BrianSheen formula |  | "=SUM(SUMPRODUCT(($C$11>=$B$2:$B$8)*C2:C8*(B2:B8-B1:B7)),SUMPRODUCT(($C$11>=B1:B7)*($C$11<B2:B8)*($C$11-(B1:B7))*C2:C8))/1000
Whatif units | manual output | BrianSheen formula output
100000 | 2556.82342 | 2556.82342 | ok !
200000 | 3918.43 | 4490.62342 | nok !
300000
600000
900000
1100000
Spreadsheet: 75201d1275733702-percentage-calculation-from-cumulative-totals-copy-of-book3
Sheet: Sheet1

Daily Saving | Daily Target | Accumulative Saving | Accumulative Target | Performance Against Target
 |  | 87481.7 | 72200
856.97 | 760 | 88338.67 | 72960 | 0.2107822094298245 | 0.1275921052631579
194.89 | 760 | 88533.56 | 73720 | 0.2009435702658708 | -0.7435657894736842
347.52 | 760 | 88881.08 | 74480 | 0.1933549946294307 | -0.5427368421052632
217.55 | 760 | 89098.63 | 75240 | 0.1841923179160022 | -0.7137500000000001
424.68 | 760 | 89523.31 | 76000 | 0.1779382894736842 | -0.4412105263157894
182.88 | 760 | 89706.19 | 76760 | 0.1686580250130277 | -0.7593684210526316
466.47 | 760 | 90172.66 | 77520 | 0.163218008255934 | -0.3862236842105263
65.03 | 760 | 90237.69 | 78280 | 0.1527553653551355 | -0.9144342105263158
339.46 | 760 | 90577.15000000001 | 79040 | 0.1459659665991904 | -0.553342105263158
810.5 | 760 | 91387.65000000001 | 79800 | 0.1452086466165415 | 0.06644736842105263
900 | 760 | 92287.65000000001 | 80560 | 0.1455765888778551 | 0.1842105263157895
760 | 760 | 93047.65000000001 | 81320 | 0.1442160600098378 | 0
760 | 760 | 93807.65000000001 | 82080 | 0.1428807261208578 | 0
760 | 760 | 94567.65000000001 | 82840 | 0.1415698937711252 | 0
800 | 760 | 95367.65000000001 | 83600 | 0.1407613636363637 | 0.05263157894736842
 | 760 |  | 84360
Spreadsheet: 70604d1271329299-conditional-formatting-highlight-if-a-c-e-example
Sheet: Sheet1

0 | 0 | 0 |  | 0
21 | 23 | 22 |  | 25
18010 | 18710 | 20175 |  | 30573
32003 | 24017 | 19620 |  | 19620
28 | 25 | 31 |  | 54
11457 | 11340 | 9768 |  | 3581
461558 | 434726 | 392340 |  | 466530
3 | 5 | 5 |  | 3
86 | 289 | 585 |  | 67
124169 | 124751 | 126085 |  | 121206
18670 | 16284 | 12452 |  | 19891
3811 | 3580 | 3503 |  | 3580
48 | 51 | 49 |  | 57
47771 | 81315 | 223530 |  | 2995
373 | 0 | 501 |  | 469
3716 | 3596 | 3797 |  | 3731
119 | 14 | 37 |  | 78
721843 | 718726 | 812500 |  | 713701