tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 540756d1506950559-sumproduct-formula-over-cumulative-date-range-failing-sample
Sheet: Sheet1

 | Year |  | Product
 | 2015/16 |  | a
 |  |  |  |  |  |  |  |  | My Formula
Name | Allocated | Date order Received | [NAME] | Balance | Paid | Product
[NAME] |  | 2015-09-01 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-01 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-01 00:00:00 | 1 |  |  | b |  |  | xlnitwit formula
[NAME] |  | 2015-09-03 00:00:00 | 2 |  |  | b
[NAME] |  | 2015-09-03 00:00:00 | 3 |  |  | b
[NAME] |  | 2015-09-03 00:00:00 | 1 |  |  | c
[NAME] |  | 2015-09-03 00:00:00 | 2 |  |  | c
[NAME] |  | 2015-09-04 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-04 00:00:00 | 4 |  |  | d
[NAME] |  | 2015-09-04 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-04 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-04 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-09-05 00:00:00 | 2 |  |  | d
[NAME] |  | 2015-09-05 00:00:00 | 1 |  |  | c
[NAME] |  | 2015-09-05 00:00:00 | 1 |  |  | c
[NAME] |  |  |  |  |  | b
[NAME] |  | 2015-09-07 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 2 |  |  | a
[NAME] |  | 2015-09-07 00:00:00 | 1 |  |  | c
[NAME] |  | 2015-10-01 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-10-01 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-10-02 00:00:00 | 2 |  |  | d |  |  | Req Answer
[NAME] |  | 2015-10-02 00:00:00 | 4 |  |  | d |  |  | 15
[NAME] |  | 2015-10-04 00:00:00 | 1 |  |  | d
[NAME] |  | 2015-10-06 00:00:00 | 1 |  |  | c
[NAME] |  | 2015-10-06 00:00:00 | 1 |  |  | c
Monika Tchorzewska |  | 2015-10-06 00:00:00 | 2 |  |  | c
[NAME] |  | 2015-10-06 00:00:00 | 1 |  |  | b
[NAME] |  | 2015-10-10 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-11-03 00:00:00 | 1 |  |  | a
[NAME] |  | 2015-11-07 00:00:00 | 1 |  |  | c
Leighton Park School |  | 2015-11-10 00:00:00 | 1 |  |  | d
Spreadsheet: 738033d1624777188-getting-information-from-sheet1-and-populatuing-in-sheet2-with-formatting-copy-of-example
Sheet: Sheet1

Code number | Dept
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Pwr Stlmts

Power Settlements
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90011708 | AUCOIN, EVELYN C | Director [NAME] | DIR-CS
90138797 | BROWN, LISA L | [NAME] | ADM-CS
90011712 | CLEMONS, AMY H | Spec Settlements | SPEC-CS
90011648 | PHAM, VIVIEN L | Spec Settlements | SPEC-CS
90011704 | REEVES, [NAME] | Dir Sr Trans Supt | DIRSR-CS
90011834 | ROBINSON, RHONDA L | Spec Sr Settlements | SPECSR-CS
90155790 | SMITH, KATINA | Spec Settlements | SPEC-CS
90141669 | [NAME], GWENDOLYN | Spec Settlements | SPEC-CS
 |  | Employees
Spreadsheet: 809441d1671093303-combining-if-and-vlookup-functions-scoring-sheet
Sheet: Scoring Sheet

BMI | [NAME] (n) | Push Ups Score  (%)
18 | 30
21 | 12
35 | 20
32 | 6
26 | 13
18 | 10
39 | 9
25 | 2
31 | 0
Spreadsheet: benjamin_rogers__1160__Model5
Sheet: Capacity Prices

CAPACITY PRICE SUMMARY
Brownsville |  |  |  |  |  |  |  | [NAME]
Capacity Prices |  |  |  |  |  |  |  | Capacity Prices
Valuation Date |  |  |  |  |  |  |  | Valuation Date
2000 |  |  |  |  |  |  |  | 2000
2001 |  |  |  |  |  |  |  | 2001
2002 |  |  |  |  |  |  |  | 2002
Caledonia |  |  |  |  |  |  |  | Wheatland
Capacity Prices |  |  |  |  |  |  |  | Capacity Prices
Valuation Date |  |  |  |  |  |  |  | Valuation Date
2000 |  |  |  |  |  |  |  | 2000
2001 |  |  |  |  |  |  |  | 2001
2002 |  |  |  |  |  |  |  | 2002
New Albany |  |  |  |  |  |  |  | [NAME]
Capacity Prices |  |  |  |  |  |  |  | Capacity Prices
Valuation Date |  |  |  |  |  |  |  | Valuation Date
2000 |  |  |  |  |  |  |  | 2000
2001 |  |  |  |  |  |  |  | 2001
2002 |  |  |  |  |  |  |  | 2002
Spreadsheet: 60569d1261083859-printed-sheet-in-different-format-than-worksheet-printed
Sheet: Archive

ELEMENTS | DUE | BRIEF | FLIGHT | MEDIA | SUN APRV | ROUND 1 | FEEDBACK | ROUND 2 | APRV | PRODUCER/EDITOR | GRAPHIC VENDOR | PACKAGING | INTERNAL | SPONSOR | STATUS
Geico Thumbsucker Film Stunt
Open, Close, [NAME], Tune-In |  |  | 12/16-12/23 |  |  | 2009-12-02 00:00:00 |  |  | 2009-12-04 00:00:00 | Jillian/Stacy |  | [NAME] |  |  | Approved
[NAME] | 2009-12-02 00:00:00 |  |  |  |  |  |  | 2009-12-01 00:00:00 | 2009-12-02 00:00:00 | Crocoll/TBD |  | [NAME] | [NAME]/AA | Geico | Approved
Blue Moon Docday-Sonic Screen Dbl Feature |  |  | 2009-12-07 00:00:00
Promo | 2009-11-20 00:00:00 |  | 2009-12-01 00:00:00 |  |  | 2009-11-06 00:00:00 |  |  |  | Joanna/Deb Oliver |  |  |  |  | Awaiting sponsor approval
Nikon Digital Shorts
Awaiting details on Promo | 2009-10-31 00:00:00 |  | 2009-11-02 00:00:00 |  |  |  |  |  |  | Jilllian/Stacy |  | Click 3x |  |  | DELIVERED
WB Invictus
Open/Close | 2009-12-07 00:00:00 |  | 2009-12-10 00:00:00 |  |  | 2009-11-30 00:00:00 | 2009-12-03 00:00:00 | 2009-12-04 00:00:00 | 2009-12-04 00:00:00 |  |  | [NAME] | JG/AA | Warner Bros. | APPROVED
Hyundai 4Q [NAME] ([NAME]) |  |  | 2009-12-07 00:00:00
Promo, Open, Close | 2009-11-20 00:00:00 |  | 2009-12-01 00:00:00 |  |  | 2009-11-06 00:00:00 |  |  |  | Stacy |  |  |  |  | Awaiting sponsor approval
Spreadsheet: 268402d1380623141-sumproduct-not-working-teachers-attendance-ca-march-2014-
Sheet: Summary

 | Sub | Sec |  |  | Teacher Name |  | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00
 | A1-FE | 2 | 2013-09-02 00:00:00 |  | Mr. [NAME]
 | A2-QM (S) | 2 | 2013-09-02 00:00:00 |  | Mr. [NAME]
 | A2-QM (M) | 2 | 2013-09-02 00:00:00 |  | Mr. [NAME]
 | Batch-3 (Post result)
 | A1-FE | 3 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | A2-QM (S) | 3 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | A2-QM (M) | 3 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | MODULE-B
 | Batch-1
 | [NAME] | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | [NAME] | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | B4-FA1 | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | Batch-2
 | [NAME] | 2 | 2013-09-30 00:00:00 |  | Mr. [NAME]
 | [NAME] | 2 | 2013-09-30 00:00:00 |  | Mr. [NAME]
 | B4-FA1 | 2 | 2013-09-30 00:00:00 |  | Mr. [NAME]
 | MODULE-C
 | Batch-1
 | C8-BCBS | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | C6-FA2 | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | C7-Tax | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | Batch-2
 | C8-BCBS | 2 | 2013-09-30 00:00:00 |  | Mr. [NAME]
 | C7-Tax | 2 | 2013-09-30 00:00:00 |  | Mr. [NAME]
 | C6-FA2 | 2 | 2013-09-30 00:00:00 |  | Mr. [NAME]
 | MODULE-D
 | Batch-1
 | D12-IT | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | D9-CLaw | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | D11-Aud | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
 | D10-Cost | 1 | 2013-09-23 00:00:00 |  | Mr. [NAME]
Spreadsheet: 790399d1659690988-adding-colour-to-weekend-cells-without-interfering-with-existing-formulas-academic-calendar-2023-wip-version-1-
Sheet: Training

 | KL | Date | PG | Date | DSA | Date
 | Training Day 1 | 2023-01-02 00:00:00 | Training Day 1 | 2023-01-03 00:00:00 | Training Day 1 | 2023-01-04 00:00:00
 | Training Day 2 |  | Training Day 2 |  | Training Day 2
 | Training Day 3 |  | Training Day 3 |  | Training Day 3
 | Training Day 4 |  | Training Day 4 |  | Training Day 4
 | Training Day 5 |  | Training Day 5 |  | Training Day 5
 | Training Day 6 |  | Training Day 6 |  | Training Day 6
 | Training Day 7 |  | Training Day 7 |  | Training Day 7
Spreadsheet: 018edca4-dd41-4e48-b3ba-636358754f08
Sheet: Totals

 | District |  |  |  |  |  | Note: The data provided on this tab is informational only and is directly populated from the annual district budgets submitted to KSDE in July.  No action is required by district officials on this tab.
 |  |  |  | Total for District
Total Expenditures
 | State & Local
 | Federal
Total Expenditures from all Sources
Less Capital Outlay & Debt Services
 | Capital Outlay
 | Debt Services
Total Capital Outlay & Debt Services
Total Expenditures less Capital Outlay
& Debt Services
 |  |  |  | Total for District
Special Education Expenditures
 | ESEA Title I, Part A
 | [NAME], Parts A & B
 | State and Local special education funds
 | State and local funds for programs under
 | ESEA Title I, Part A, and [NAME], Parts A & B
Total special education deductions
Total Expenditures less
Special Education Expenditures
 |  |  |  | Total for District
Prior year's September 20 count
Spreadsheet: 781368d1653286661-change-in-lookup-to-different-sheet-not-working-northfields-review-test
Sheet: Cost Calculation

Job Data |  |  |  |  |  |  |  |  | main rate | Main rate variable | Main rate variable | Main rate variable | Main rate variable | TMA extra cost | Wash out hydrant | fire hydrant | sluice valves | air valves | non return valve | Pressure reducing valve (install only) | mains branch | Add metres of main/service/comm pipe
 |  |  |  |  |  |  |  |  | rate | rate | rate | rate | rate | Lookup | rate | rate | rate | rate | rate | rate | rate | m
Unique Id | SAP order no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error | Audit | A1 | A2 | A3 | A4 | A5 | TM | V1 (a-d) | V2 (a-d) | V3 (a-d) | V4 (a-d) | V5 (a-d) | V6 (a-d) | V7 (a-d) | X1 (a-d)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TM
25770880-6 | 25770880 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  | 0
25770832-7 | 25770832 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  | 0
25942414-8 | 25942414 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
25904092-9 | 25904092 | 3HW2 | Yes | 3HW2 | [NAME] |  | 0
25762507-10 | 25762507 | 3SM2 | Yes | 3SM2 | Inst LrgeDiaMtrd ComPipe Shrt |  | 0
25770831-11 | 25770831 | 3SM4 | Yes | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  | 0
25904092-12 | 25904092 | 3HW2 | Yes | 3HW2 | [NAME] |  | 0
26123859-13 | 26123859 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
26123859-14 | 26123859 | 3ML1 | No | 3TH1 | [NAME] (Permit) |  | 0
23494103-15 | 23494103 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
25981916-16 | 25981916 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
25981916-17 | 25981916 | 3SM1 | No | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  | 0
26164701-18 | 26164701 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
25880278-19 | 25880278 | 3LD0 | Yes | 3LD0 | Lead Renewal (Short Side) |  | 0
26100240-20 | 26100240 | 3DC1 | Yes | 3DC1 | Disconnect Cust Supply Rech |  | 0
26161186-21 | 26161186 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26161188-22 | 26161188 | 3SFA | Yes | 3SFA | New Supplies Disconnection |  | 0
26078818-23 | 26078818 | 3DC1 | Yes | 3DC1 | Disconnect Cust Supply Rech |  | 0
26137612-24 | 26137612 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
26137809-25 | 26137809 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26166744-26 | 26166744 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
26094786-27 | 26094786 | 3ML2 | Yes | 3ML2 | Lay Main Only |  | 0
26094786-28 | 26094786 | 3ML2 | Yes | 3ML2 | Lay Main Only |  | 0
26054664-29 | 26054664 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  | 0
26164333-30 | 26164333 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26185749-31 | 26185749 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  | 0
26146302-32 | 26146302 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
26146302-33 | 26146302 | 3SM4 | Yes | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  | 0
26146303-34 | 26146303 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  | 0
25981539-35 | 25981539 | 3ME1 | Yes | 3ME1 | 15mm [NAME] (NoExc) |  | 0
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 47

कार्यक्रम PROGRAM |  |  | तडतजटल जागरूकिा एर्िं साइबर सुरक्षा IMPORTANT ASPECTS OF DIGITAL PRODUCTS | PROG CODE
 |  |  |  | IT 1902
तर्षर् समूह/JOB FAMILY |  |  | DIGITAL BANKING &TECHNOLOGY
उद्देश्य/OBJECTIVE |  |  | TO HAVE AN INSIGHT ABOUT THE DIGITAL PRODUCTS OF OUR BANK AND THE AWARENESS ABOUT THE CYBER SECURITY & PREVENTION OF CYBER CRIMES
लतक्षि समूह/TARGET GROUP |  |  | Mixed
अर्तध/DURATION |  |  | 1 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Cards  (Debit/Credit/International  Travel  Prepaid  Card)  and  its variants CCR Package, CPGRS
 | II | Net Banking, Mobile Banking, [NAME] and Merchant Enrollment and  Payment  Gateways;  POS,  QR  Code,  Bharat  [NAME],  [NAME]  , Whatsapp banking ,API etc.
 | III | Data  Analytics  using  BI,  BD360  &  Digital  Product  Dashboard  to acquire new business and prevent attrition (BA & IS Wing expertise may be utilized)
 | IV | Cyber Security– Prevention of Cyber Crimes/Customer Awareness on Security Features & Important aspects of Fraud Risk Managements & Business Ethics
Spreadsheet: 132790d1323934964-count-unique-using-frequency-countif-and-sumif-question
Sheet: Sheet1

Customer | Month | Service | [NAME] | Amount |  | Customer | Month | Service | Customer ID | Amount
A | Sep | R | 1 | 1000 |  | A | Sep | R
A | Sep | R | 1 | 2000
A | Sep | R | 2 | 1000
A | Sep | R | 2 | 1000
A | Sep | R | 3 | 2000
A | Sep | R | 4 | 3000
A | Sep | R | 2 | 4000
A | Sep | R | 5 | 5000
A | Oct | S | 6 | 1000
A | Oct | S | 6 | 2000
A | Oct | S | 7 | 1000
A | Oct | S | 7 | 1000
A | Oct | S | 8 | 2000
A | Oct | S | 9 | 3000
A | Oct | S | 7 | 4000
A | Oct | S | 10 | 5000
A | Nov | T | 11 | 1000
A | Nov | T | 12 | 2000
A | Nov | T | 13 | 1000
A | Nov | T | 14 | 1000
A | Nov | T | 15 | 2000
A | Nov | T | 15 | 3000
A | Nov | T | 16 | 4000
A | Nov | T | 16 | 5000
A | Dec | U | 15 | 1000
A | Dec | U | 17 | 2000
A | Dec | U | 18 | 1000
A | Dec | U | 19 | 1000
A | Dec | U | 20 | 2000
A | Dec | U | 20 | 3000
A | Dec | U | 19 | 4000
A | Dec | U | 19 | 5000
B | Sep | R | 6 | 1000
B | Sep | R | 6 | 2000
B | Sep | R | 7 | 1000
B | Sep | R | 7 | 1000
B | Sep | R | 8 | 2000
B | Sep | R | 9 | 3000
B | Sep | R | 7 | 4000
B | Sep | R | 10 | 5000
B | Oct | S | 6 | 1000
B | Oct | S | 6 | 2000
B | Oct | S | 7 | 1000
B | Oct | S | 7 | 1000
B | Oct | S | 8 | 2000
B | Oct | S | 9 | 3000
B | Oct | S | 7 | 4000
B | Oct | S | 10 | 5000
B | Nov | T | 6 | 1000
B | Nov | T | 6 | 2000
B | Nov | T | 7 | 1000
B | Nov | T | 7 | 1000
B | Nov | T | 8 | 2000
B | Nov | T | 9 | 3000
B | Nov | T | 7 | 4000
B | Nov | T | 10 | 5000
B | Dec | U | 6 | 1000
B | Dec | U | 6 | 2000
B | Dec | U | 7 | 1000
B | Dec | U | 7 | 1000
B | Dec | U | 8 | 2000
B | Dec | U | 9 | 3000
B | Dec | U | 7 | 4000
B | Dec | U | 10 | 5000
Spreadsheet: 173452d1344555804-help-calculating-results-of-last-10-games-and-win-loss-tie-streak-in-standings-workbook-2003-04-nhl-season
Sheet: League

 |  |  | GP | W | L | T | Pts | GF | GA | [NAME] | Home | Away | RT | OT | Conf | Div | E #
 | 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
Spreadsheet: 853301d1703174967-retrieving-and-moving-transferring-data-excel-problem-1-
Sheet: Sheet1

 |  |  |  |  |  | Overall Count Results
 |  |  |  |  | 9 | 49 | 39 | 45 | 55 | 46 | 25
 |  |  |  |  | 8 | 44 | 47 | 42 | 47 | 50 | 40
 |  |  |  |  | 7 | 30 | 44 | 43 | 59 | 49 | 62
 |  |  |  |  | 6 | 57 | 49 | 49 | 47 | 44 | 46
 |  |  |  |  | 5 | 40 | 50 | 44 | 43 | 49 | 40
 |  |  |  |  | 4 | 46 | 40 | 44 | 43 | 50 | 60
 |  |  |  |  | 3 | 42 | 49 | 37 | 59 | 36 | 44
 |  |  |  |  | 2 | 49 | 43 | 50 | 41 | 37 | 49
 |  |  |  |  | 1 | 50 | 55 | 50 | 47 | 51 | 52
 |  |  |  |  | 0 | 40 | 44 | 56 | 45 | 48 | 42
 |  | AVERAGES %
Spreadsheet: b92588b3-76ae-446c-996d-b129884f4909
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 | Unnamed: 12 | Unnamed: 13
 | Association/ Division |  | Name…. | An Example
 |  |  | Code..… | 9999
 |  |  | Year...... | 1992
 |  |  |  |  | £
 |  | BANK | DEPOSIT | PETTY | GRAND
 |  | CURRENT | ACCOUNT | CASH | TOTALS
 | Balance brought forward | 394.78 | 188.22 | 0 | 583
 | Receipts | 809.75 | 114.5 | 50 | 974.25
 | Payments | 1013.22 | 0 | 35.6 | 1048.82
 | Current Balance | 191.3099999999999 | 302.72 | 14.4 | 508.4299999999999
 |  | TOTAL | Transfers | Subs | Grants | Interest | Misc
 | RECEIPTS TOTALS | 974.25 | 150 | 480 | 329.75 | 14.5 | 0
 |  | TOTAL | Transfers | Stationery | Postage | Telephone | Honoraria | Meetings | Conferen' | Donations | Affil' Fees | Misc
 | PAYMENTS TOTALS | 1048.82 | 150 | 70.3 | 37 | 37.5 | 120 | 252.8 | 189.22 | 20 | 150 | 22 | `
 | SURPLUS/(DEFICIT) | -74.57000000000016
 | FUNDS B/FWD | 583 | (as detailed above)
 | Balance is OK | 508.43
Spreadsheet: 131912d1323381579-summing-dates-book1
Sheet: Sheet1

2011-12-02 11:56:25 | Ones |  | total of Ones with 12/2/2011 should read 6
2011-12-02 11:55:25 | Ones
2011-12-02 12:14:54 | Ones
2011-12-02 11:30:02 | Ones
2011-12-02 11:29:01 | Ones
2011-12-02 11:12:27 | Ones
2011-12-02 11:10:43 | Twos
2011-12-02 11:41:18 | Twos
2011-12-02 11:03:20 | Twos
2011-12-02 11:12:08 | Twos
2011-12-02 10:14:41 | Twos
2011-12-02 12:22:07 | Twos
2011-12-02 09:04:05 | Twos
2011-12-02 08:03:46 | Twos
2011-12-02 05:53:52 | Twos
2011-12-02 08:02:27 | Threes
2011-12-02 11:42:48 | Threes
2011-12-02 10:07:36 | Threes
2011-12-02 10:05:05 | Threes
2011-12-02 10:18:37 | Threes
2011-12-01 22:32:32 | Threes
2011-12-02 11:05:13 | Threes
2011-12-01 21:15:52 | Threes
2011-12-02 11:10:26 | Threes
2011-12-02 07:19:09 | Threes
2011-12-01 14:52:24 | Threes
2011-12-01 14:51:09 | Threes
2011-12-01 14:49:22 | Threes
2011-12-01 14:53:43 | Threes
2011-12-01 14:48:26 | Threes
2011-12-01 14:46:28 | Fours
2011-12-01 14:44:32 | Fours
2011-12-01 14:42:59 | Fours
2011-12-01 13:09:12 | Fours
2011-12-01 16:05:22 | Fours
2011-12-01 11:28:28 | Fours
2011-12-01 11:29:04 | Fours
2011-12-01 11:15:25 | Fours
2011-12-01 11:14:17 | Fours
2011-12-01 09:49:37 | Fours
Spreadsheet: 817467d1676257968-formula-for-generating-random-alphabet-letters-for-each-cell-in-a-26-cols-and-26-rows-table-formula-for-generating-random-alphabet-letters-for-each-cell-in-a-26-cols-and-26-rows-table
Sheet: A->Z

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] for generating random alphabet letters for each cell in a 26-cols & 26-rows table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1399654-formula-for-generating-random-alphabet-letters-for-each-cell-in-a-26-cols-and-26-rows-table.html#post5790652
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1=CHAR(UNIQUE(RANDARRAY(1000,1,65,90,1)))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1=INDEX(A1#,IFERROR(1/(1/MOD(ROW(A1#)+3,26)),26)), copy across to Z1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CF formula: =SUM(COUNTIF(A1:C3,A1:C3))<>9, applies to =$A$1:$X$24
Spreadsheet: 57492d1257696198-summing-total-with-pushbutton-testtt4
Sheet: Year 1J

 | Surname | Forename | Gender | Score A | Score B | Score C
 | Eight | [NAME] | G | 7 | 7 | 7
 | Nine | Simone | G | 8 | 8 | 8
 | Ten | Lilly | G | 9 | 9 | 9
 | Eleven | [NAME] | G | 10 | 10 | 10
 | Twelve | [NAME] | B | 11 | 11 | 11
Spreadsheet: 855687d1705190602-updating-a-calendar-from-dates-test-calendar-v1-taflorida-
Sheet: June

 |  |  | [NAME]
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
6
4
2
Spreadsheet: 52850d1252666284-formula-to-show-a-date-range-based-on-the-amount-shown-in-another-cell-variance-tracking-and-comparison-test-3-
Sheet: Employee Search

Employee: | Employee #1
Track Back:
Month Tracking: |  | << If tracking is left blank, and a month/year is typed in or selected only results for that month/year would be displayed.
Total NET:
Total ABS:
# of Variances:
Date | [NAME] |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  | 180
 |  |  |  |  |  |  |  | 365
Spreadsheet: 874351d1720930286-showing-the-school-matching-name-of-2-students-try4-copy
Sheet: SENARAI PESERTA

TENPIN BOLING 2024
PRIMARY SCHOOL - U12 L&P
BIL | SCHOOL NAME |  | BOY |  | GIRL
1 | SK BAWANG | 1 | AIMAN | 1 | INSYIRAH
 |  | 2 | NAZMI | 2 | AUFA
 |  | 3 | [NAME] | 3 | [NAME]
 |  | 4 | ADAM | 4 | NUR EZLYANA
2 | SJKC ST PHILIP (M) | 1 | GABRIEL | 1
 |  | 2 | CALEB | 2
 |  | 3 |  | 3
 |  | 4 |  | 4
3 | SK RUNGUS | 1 | JEPOLONIUS | 1 | CINDY
 |  | 2 | EYRLE WELL | 2 | FAYENN
 |  | 3 | EYRLE VELL | 3 | CLAY
 |  | 4 | EYRLEO | 4 | CASSEYNDRA
4 | SK GIOK | 1 |  | 1 | ERVIE
 |  | 2 |  | 2 | ANGELIKA
 |  | 3 |  | 3 | CHERRLYVILLIE
 |  | 4 |  | 4 | FREIRA
5 | SK RUNGUS NAHABA | 1 |  | 1 | ALESCHYA
 |  | 2 |  | 2 | LYDIA
 |  | 3 |  | 3
 |  | 4 |  | 4
6 | SK ST JOHN TUARAN | 1 | JACK | 1 | MARYAM
 |  | 2 |  | 2 | NUR ELISA
 |  | 3 |  | 3 | ZARA ALYSA
 |  | 4 |  | 4 | AUDELE
7 | SK BANTAYAN | 1 | ARRIQ | 1 | NURSYAFIHA
 |  | 2 | [NAME] | 2 | SONIA
 |  | 3 |  | 3
 |  | 4 |  | 4
8 | SK TERMUNONG | 1 | [NAME] | 1 | AWFIYAH
 |  | 2 | ANNAS NAFEESH | 2 | PUTRI NUR SYAFIKA
 |  | 3 | MOHD. SYAHNIZAN | 3 | IRIS LEE
 |  | 4 | MOHD RAYEES | 4 | NUR ZUHARYA
9 | SK PEKAN TUARAN | 1 | HARIZ MIRZA | 1 | SYUHAIDAH
 |  | 2 | INDRA PUTERA | 2 | SYAURAH
 |  | 3 | IMMANUEL MARINUS | 3 | HANI
 |  | 4 | MUHAMMAD ZHAREEF | 4 | ZAHRA
10 | SK MALANGANG BARU | 1 |  | 1 | AMEERA
 |  | 2 |  | 2
 |  | 3 |  | 3
 |  | 4 |  | 4
11 | SK 11 | 1 |  | 1
 |  | 2 |  | 2
 |  | 3 |  | 3
 |  | 4 |  | 4
12 | SK 12 | 1 |  | 1
 |  | 2 |  | 2
 |  | 3 |  | 3
 |  | 4 |  | 4
13 | SK 13 | 1 |  | 1
 |  | 2 |  | 2
 |  | 3 |  | 3
 |  | 4 |  | 4
14 | SK 14 | 1 |  | 1
 |  | 2 |  | 2
 |  | 3 |  | 3
 |  | 4 |  | 4
15 | SK 15 | 1 |  | 1
 |  | 2 |  | 2
 |  | 3 |  | 3
 |  | 4 |  | 4
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 4.4

 | Cuadro 4.4
 | [NAME]
 | Divorcios registrados, según causa de divorcio, 2010
 | Causa de divorcio | Divorcios | Porcentaje
 | Total País
 | Incompatibilidad de caracteres | 7507
 | Mutuo consentimiento | 10167
 | Nota: Elaborado con datos registrados en las Oficialías del Estado Civil. Junta Central Electoral
 | Fuente: Oficina Nacional de Estadística, (ONE)
 | Incompatibilidad de caracteres | 7169
 | Mutuo consentimiento | 9238
Spreadsheet: 118140d1313490564-how-to-write-functions-to-extract-specific-text-from-original-how-to-automate
Sheet: Sheet1

Description of Feedback | ACK Codes | SITE | ACKOWLEDGED | RESET | ESCALATOR
08/15/2011 00:06:10 SITE8 SCOTTS ROAD/ C K TANG ESCALATOR E2 E-STOP. TO ACKNOWLEDGE, REPLY: ACK 128 | ACK 128 | 8 | NA | NA | E2
08/15/2011 00:06:10 SITE8 SCOTTS ROAD/ C K TANG ESCALATOR E2 NOT RUNNING | NA | 10 | NA | NA | E2
(ID:128) SITE8 SCOTTS ROAD/ C K TANG ESCALATOR E2 E-STOP ACKNOWLEDGED. | NA | 8 | ACKNOWLEDGED | NA | E2
08/15/2011 00:12:47 SITE9 ORCHARD ROAD/ C K TANG ESCALATOR2B E-STOP. TO ACKNOWLEDGE, REPLY: ACK 1451 | ACK 1451 | 9 | NA | NA | 2B
(ID:1451) SITE9 ORCHARD ROAD/ C K TANG ESCALATOR2B E-STOP ACKNOWLEDGED. | NA | 9 | ACKNOWLEDGED | NA | E1
SITE32 NICOLL HIGHWAY/ ESPLANADE DRIVE & RAFFLES AVE (ART CENTRE) ESCALATOR E1 NOT RUNNING RESET. | NA | 32 | NA | RESET | E1
SITE8 SCOTTS ROAD/ C K TANG ESCALATOR E2 NOT RUNNING RESET. | NA | 8 | NA | RESET | E2
For Column B, I need to be able to to pick out the text e.g "ACK 128" and have it inserted into the column.  However if the cell has no such info, it will insert "NA".  Some ACK numbers which appear after the ACK may vary between 3 to 4 numbers
For Column C, I need to be able to extract the word "SITE and the number that follows it ( either single digit or double digit")
For column D, I need to be able to pick out the word "ACKNOWLEDGED" from the text string and have it inserted in the column.  If however there is no such info, a NA will be inserted.
For column E, I need to be able to pick out the word "RESET" from the text string and have it inserted in the column.  If however there is no such info, a NA will be inserted.
For Column F, I need to be able to to pick out the text e.g "ESCALATORX OR [NAME]" and have it inserted into the column.  However if the cell has no such info, it will insert "NA".  Some ESCLATORS may have 1 digit and 1 alphabet or the word ESCALATOR may not have a spce after it.