tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 831538d1685705968-formular-to-call-data-from-another-sheet-5-and-6-ask
Sheet: WASICHANA

MKOA WA MANYARA
HALMASHAURI Y WILAYA [NAME]
MATOKEO [NAME] WA MUHULA WA KWANZA MEI, 2023 DARASA LA VI WASICHANA
S/N | KATA | SHULE | JINA LA MTAHINIWA | JINSI      2. MS | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JML | WASTANI | DARAJA | [NAME] | [NAME]
 |  |  |  |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI NA TEKNOLOJIA |  | M/JAM |  | URAIA NA MAADILI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1
2
3
4
5
6
7
8
9
10
11 |  |  |  | 2
12 |  |  |  | 2
13 |  |  |  | 2
14 |  |  |  | 2
15 |  |  |  | 2
16 |  |  |  | 2
17 |  |  |  | 2
18 |  |  |  | 2
19 |  |  |  | 2
Spreadsheet: 693092d1598755464-iferror-with-index-match-need-to-return-numeric-empty-cell-not-text-empty-cell-sample12345abc12
Sheet: Sheet1

Material | Data | Data 1
 |  |  |  |  |  | Silk | 4
 |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  | Cotton | 10
Spreadsheet: 146592d1332264864-how-to-create-a-rule-depending-on-date-periods-rental-guest-stay-calculation-table
Sheet: FB

 | Хармони Хилс Резиденс – 2012 (Тип на настаняване – “FB”)
 | Studio | 2 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 56 |  |  |  | 59 |  |  |  | 65 |  |  |  | 72 |  |  |  | 65 |  |  |  | 59 |  |  |  | 57 |  |  |  | 53 |  |  |  | 58
 | 1-Bedroom Apartment | 2 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 64 |  |  |  | 67 |  |  |  | 74 |  |  |  | 84 |  |  |  | 74 |  |  |  | 67 |  |  |  | 65 |  |  |  | 63 |  |  |  | 66
 | 2-Bedroom Apartment | 4 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 102 |  |  |  | 105 |  |  |  | 114 |  |  |  | 126 |  |  |  | 114 |  |  |  | 105 |  |  |  | 103 |  |  |  | 101 |  |  |  | 108
 | 2-Bedroom Villa | 4 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 106 |  |  |  | 109 |  |  |  | 119 |  |  |  | 137 |  |  |  | 119 |  |  |  | 109 |  |  |  | 107 |  |  |  | 105 |  |  |  | 112
 | 3-Bedroom Villa | 6 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 142 |  |  |  | 147 |  |  |  | 155 |  |  |  | 176 |  |  |  | 155 |  |  |  | 147 |  |  |  | 145 |  |  |  | 138 |  |  |  | 148
Spreadsheet: 719368d1613650745-how-to-calculate-overtime-from-the-attached-sheet-please-help-overtime-calculation
Sheet: Sheet1

 |  |  |  |  |  |  | holiday |  |  |  |  |  |  | holiday |  |  |  |  |  |  | holiday |  |  |  |  |  |  | holiday
S.N. | EMP. CODE | NAME | TRADE | TU | WE | TH | FR | SA | SU | MO | TU | WE | TH | FR | SA | SU | MO | TU | WE | TH | FR | SA | SU | MO | TU | WE | TH | FR | SA | SU | MO | TU | WE | TH | TOTAL | NML | HOL | NML
 |  |  |  | 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 | HRS | OT | HRS | HRS
1 | [NAME] | ABC | ABC | 5 | 10 | 10 | 8 | 10 | 10 | 10 | 10 | 10 | 10 | 8 | 10 | 10 | 10 | 12 | 10 | 6 | 5 | 10 | 10 | 12 | 10 | 10 | 10 | 10 | 10 | 10 | 12 | 10 | 10 | 10 | 298 | 6 | 31 | 261
 |  | which formula can be used to find Normal overtime above 10 hrs and hoilday overtime during holiday
Spreadsheet: 67598d1268169941-advanced-filtering-thread-post
Sheet: BBBB

# | Yr | Unit | Equipment or Line No. | Description of Repair Request | Status | Notes | Date
002
Spreadsheet: 833857d1687287353-comparing-two-sets-of-data-from-two-spreadsheets-in-one-file-column-then-row-check-dummy-document
Sheet: Sheet1

Curriculum ID | Title | [NAME] | Jake | [NAME] | Samantha | [NAME] | [NAME]
401123 - REG_AFFAIRS | Global training | Yes (Sample of how it should look)
401123_ACTION TRAINING | Global compliance | Yes
2482_TRAINING TITLE | Action training | Yes
3659_DUMMY [NAME] | Action approver | Yes
7547_SETEXAMPLE | Verification | Yes
1661_TESTINGTYPO | Denial training | No
4617_REGTRAINING | Safety training | No
5723_HNSTRAINING | Workplace training | No
3411_MANUALHANDTRAIN | Documentation | No
8774_TESTTEST11 | Doc approval training | No
71062_GLOBALTRAININ | Doc review | No
36956_TESTNICHETRAIN | Doc sample | No
Spreadsheet: 87189d1287048787-prefix-before-rand-rand-name-one-way
Sheet: tokens

name 1
name 2
name 3
name 4
name 5
name 6
name 7
name 8
name 9
name 10
name 11
name 12
name 13
name 14
name 15
name 16
name 17
name 18
name 19
name 20
name 21
name 22
name 23
name 24
name 25
name 26
name 27
name 28
name 29
name 30
name 31
name 32
Spreadsheet: 220986d1363343317-generate-part-list-copy-of-partlist-example
Sheet: Blad2

 | assembly A |  | assembly D | some thing 8
 | assembly B
 | assembly C
 | assembly D
 | assembly A |  |  |  | assembly B |  |  | assembly C |  |  | assembly D
 | part1 |  |  |  | part3 |  |  | some thing 1 |  |  | some thing 5
 | part2 |  |  |  | part6 |  |  | some thing 2 |  |  | some thing 6
 | part3 |  |  |  | part7 |  |  | some thing 3 |  |  | some thing 7
 | part1 |  |  |  | subassembly Y |  |  | some thing 4 |  |  | some thing 8
 | part4
 | part5
Spreadsheet: 762963d1641918865-sum-of-values-across-multiple-sheets-sum-of-vls-mltpl-sheets
Sheet: MAY

2022-04-28 00:00:00 |  |  | 2500
2022-04-01 00:00:00 |  |  | 1250
2022-04-25 00:00:00 |  |  | 1250
2022-04-29 00:00:00 |  |  | 54.01600000000001
2022-05-01 00:00:00 |  |  | 3500
2022-05-01 00:00:00 |  |  | 932.45
2022-05-01 00:00:00 |  |  | 1284
2022-05-01 00:00:00 |  |  | 750
2022-05-01 00:00:00 |  |  | 20
2022-05-01 00:00:00 |  |  | 350
2022-05-01 00:00:00 |  |  | 550
2022-05-02 00:00:00 |  |  | 4.037696
2022-05-02 00:00:00 |  |  | 2030
2022-05-02 00:00:00 |  |  | 2523
2022-05-02 00:00:00 |  |  | 1250
2022-05-04 00:00:00 |  |  | 150
2022-05-04 00:00:00 |  |  | 11
2022-05-06 00:00:00 |  |  | 2278.62
2022-05-06 00:00:00 |  |  | 2323
2022-05-08 00:00:00 |  |  | 80
2022-05-08 00:00:00 |  |  | 80
2022-05-09 00:00:00 |  |  | 1250
2022-05-10 00:00:00 |  |  | 7
2022-05-10 00:00:00 |  |  | 2651
2022-05-13 00:00:00 |  |  | 16.98
2022-05-13 00:00:00 |  |  | 3885.5
2022-05-15 00:00:00 |  |  | 16
2022-05-16 00:00:00 |  |  | 300
2022-05-16 00:00:00 |  |  | 2030
2022-05-16 00:00:00 |  |  | 2523
2022-05-16 00:00:00 |  |  | 1250
2022-05-18 00:00:00 |  |  | 155.85
2022-05-23 00:00:00 |  |  | 1250
Spreadsheet: 34123d1231248701-populate-a-drop-down-list-estimator
Sheet: Data

Citroen | Citroen | Ford | Mitsubishi | Peugeot | Subaru | Triumph | Vauxhall | Volkswagon
Ford | AX | [NAME] | Colt | 106 | Impreza Classic | TR7 | Astra MK1 | Golf MK1
Mitsubishi | Saxo | [NAME] | [NAME] | 205 | Impreza |  | [NAME] | Golf MK2
Peugeot |  | [NAME] | [NAME] | 206 |  |  | Astra MK3 | Golf MK3
Subaru |  | [NAME] | [NAME] 6 | 306 |  |  | Astra MK4 | Golf MK3
Triumph |  | [NAME] | [NAME] |  |  |  | Cavalier
Vauxhall |  | [NAME] | [NAME] |  |  |  | [NAME]
Volkswagon |  | [NAME] | [NAME] 9 |  |  |  | [NAME]
 |  | [NAME] | [NAME] 10 |  |  |  | Nova
 |  | [NAME]
 |  | Escort MK4
 |  | [NAME]
 |  | [NAME]
 |  | Sierra 3 Door
 |  | Sierra 4 Door
Spreadsheet: 181526d1348064757-count-2-different-variables-from-different-columns-count-example
Sheet: Sheet1

Name | Accident Type | YEAR |  |  |  |  | TYPE BY YEAR | 2012 | 2011 | 2010 | 2009
JOHN DOE 1 |  | 2012 |  |  |  |  | AVOIDANCE MANEUVER | 0 | 0 | 0 | 0
[NAME] 2 |  | 2012 |  |  |  |  | BACKING | 2 | 4 | 0 | 1
[NAME] 3 |  | 2012 |  |  |  |  | DROPPED TRAILER | 0 | 0 | 0 | 0
[NAME] 4 |  | 2012 |  |  |  |  | IV HIT ANIMAL | 0 | 0 | 0 | 0
JOHN DOE 5 |  | 2012 |  |  |  |  | JACKNIFE | 0 | 0 | 0 | 0
[NAME] 6 | BACKING, SIDE SWIPE | 2012 |  |  |  |  | LANE CHANGE | 0 | 0 | 0 | 0
[NAME] 7 | LEFT TURN | 2012 |  |  |  |  | LEFT ROADWAY | 0 | 0 | 0 | 0
[NAME] 8 |  | 2012 |  |  |  |  | LEFT TURN | 1 | 1 | 0 | 0
JOHN DOE 9 | BACKING | 2012 |  |  |  |  | MECHANICAL FAILURE | 0 | 0 | 0 | 0
[NAME] 10 | STRAIGHT, BACKING | 2011 |  |  |  |  | MERGING | 0 | 1 | 0 | 0
[NAME] 11 |  | 2011 |  |  |  |  | OVERHEAD | 0 | 1 | 1 | 0
[NAME] 12 |  | 2011 |  |  |  |  | PARKED | 0 | 0 | 0 | 0
[NAME] 13 | MERGING | 2011 |  |  |  |  | REAR-END | 0 | 0 | 0 | 0
[NAME] 14 | RIGHT TURN, BACKING | 2011 |  |  |  |  | RIGHT TURN | 0 | 2 | 1 | 1
[NAME] 15 | BACKING, OVERHEAD, ROAD HAZARD | 2011 |  |  |  |  | ROAD HAZARD | 0 | 1 | 0 | 0
[NAME] 16 | LEFT TURN, SIDE SWIPE, RIGHT TURN | 2011 |  |  |  |  | ROLL AWAY | 0 | 0 | 0 | 0
[NAME] 17 |  | 2011 |  |  |  |  | ROLL BACK | 0 | 0 | 0 | 0
[NAME] 18 |  | 2011 |  |  |  |  | ROLLOVER | 0 | 0 | 0 | 0
[NAME] 19 | BACKING | 2011 |  |  |  |  | SIDE SWIPE | 1 | 1 | 0 | 0
[NAME] 20 |  | 2011 |  |  |  |  | STOPPED | 0 | 0 | 0 | 0
[NAME] 21 | RIGHT TURN | 2011 |  |  |  |  | STRAIGHT | 1 | 1 | 0 | 1
[NAME] 22 |  | 2010 |  |  |  |  | TIRE FAILURE | 0 | 0 | 0 | 0
[NAME] 23 | RIGHT TURN | 2010 |  |  |  |  | TURN AROUND | 0 | 0 | 0 | 0
[NAME] 24 |  | 2010 |  |  |  |  | U-TURN | 0 | 0 | 0 | 0
[NAME] 25 | OVERHEAD | 2010 |  |  |  |  | UNDETERMINED | 0 | 0 | 0 | 0
JOHN DOE 26 |  | 2010
[NAME] 27 |  | 2010
[NAME] 28 |  | 2010
[NAME] 29 |  | 2010
[NAME] 30 |  | 2010
[NAME] 31 | BACKING, STRAIGHT | 2009
[NAME] 32 | RIGHT TURN | 2009
[NAME] 33 | STRAIGHT | 2009
Spreadsheet: sara_shackleton__36589__0201MarginRequirements
Sheet: 0124

FUTURES MARGIN REQUIREMENTS
2002-01-25 00:00:00
2002-01-24 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc | 148571.6360000279 |  | 148571.6360000279 | 0 | 0 |  | 0 |  |  |  | 148571.6360000279 |  |  |  | 0
ADM INVESTOR | 0.1990000053192489 |  | 0.1990000053192489 | 0 | 0 |  | 0 |  |  |  | 0.1990000053192489 |  |  |  | 0
BANK ONE | 0.2200000286102295 |  | 0.2200000286102295 | 0 | 0 |  | 0 |  |  |  | 0.2200000286102295 |  |  |  | 0
CARR FUTURES (NG) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
CARR FUTURES INC. | 4373898.92576739 |  | 4373898.92576739 | 0 | 0 |  | 0 |  |  |  | 4373898.92576739 |  |  |  | 0
CREDIT SUISSE FIRST BOSTON | 29866.61000000313 |  | 29866.61000000313 | 0 | 0 |  | 0 |  |  |  | 29866.61000000313 |  |  |  | 0
EDF MAN | 8383992.715999773 |  | 8383992.715999773 | 0 | 0 |  | 0 |  |  |  | 8383992.715999773 |  |  |  | 0
FIMAT | 2275935.16 |  | 2275935.16 | 0 | 0 |  | 0 |  |  |  | 2275935.16 |  |  |  | 0
HSBC - US$ | -2131.681408999983 |  | -2131.681408999983 | 0 | 0 |  | 0 |  |  |  | -2131.681408999983 |  |  |  | 0
HSBC - Canadian | 0 |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 64204.5 | 0 | 0
JP Morgan | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
PARIBAS | 80371717.16000006 |  | 80371717.16000006 | 0 | 0 |  | 0 |  |  |  | 80371717.16000006 |  |  |  | 0
PRUDENTIAL SI | -0.09857879066839814 |  | -0.09857879066839814 | 0 | 0 |  | 0 |  |  |  | -0.09857879066839814 |  |  |  | 0
REFCO, INC | 0.2590000069403686 |  | 0.2590000069403686 | 0 | 0 |  | 0 |  |  |  | 0.2590000069403686 |  |  |  | 0
R J O'BRIEN | 0.1799999999930151 |  | 0.1799999999930151 | 0 | 0 |  | 0 |  |  |  | 0.1799999999930151 |  |  |  | 0
SAUL STONE & COMPANY | 0.180000000000291 |  | 0.180000000000291 | 0 | 0 |  | 0 |  |  |  | 0.180000000000291 |  |  |  | 0
SMITH BARNEY, INC | 53592.45999999158 |  | 53592.45999999158 | 0 | 0 | 0 | 0 |  |  |  | 53592.45999999158 |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS | 95635443.9257795 | 0 | 95635443.9257795 | 0 | 0 | 0 | 0 |  | 0 |  | 95635443.9257795 |  | 64204.5 | 0 | 0
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 95635443.9257795
 |  |  |  |  |  |  |  |  |  |  |  |  | 95635443.9257795
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 0 | 0 | 50000000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 786680d1657365260-payslip-presentation-with-itemized-results-excelforum-payslip
Sheet: SourceData 

Item Piece Prices 2022
Heritage Collection (Beads) |  | Units | Value | Units | Value
[NAME] | 16
Azunite Earring | 20
Baeded Bib | 35
[NAME] | 7
[NAME] | 7
Bead Earring | 2.5
Bead Earring Gold | 3
Bead Gold Culf | 15
[NAME] | 20
Beaded Collar Necklace | 36
Beaded Neck-Piece | 35
Bowl West Elm | 120 | 10
Brass Training Per Hour | 13
[NAME] | 25
Casuals Wage - Per Hour | 12.5
[NAME] | 100
[NAME] | 15
Circle Drop Earring All Gold | 10
[NAME] Earring | 6.5
Crescent Earring | 20
Diamond Earring | 15
Drop Earring | 10
Drop Earring Gold | 10
[NAME] | 25
Era Earring | 20
Fabric Necklace Gold | 35
Fabric Necklace Open | 33
Fan Earring All Gold | 21
Fan Earring Colour | 20
[NAME] | 18
Jadeite Earring | 18
[NAME] | 22
Kudala Pencil Pot | 15
[NAME] | 25
[NAME] | 20
Leave Per Day | 60
Ligagasi Vase | 30 | 5
Lijika Vase | 40
Lilanga Layered Earring | 15
Lindiwe Layered Earring | 18
Lindiwe Pulp Earring | 19
Liselwa | 16
Love Bracelet Mini Beads | 12.5
Ludziwo | 45
Maternity Leave | 2500
[NAME] | 25
[NAME] Pulp Earring | 25
[NAME] | 40
Nest Light | 30
Nesta Layered Earring | 20 | 5
[NAME] Earring | 22
[NAME] | 20
[NAME] | 22 | 10
Nugget Earring | 14 | 10
Nugget Necklace | 30
Nugget Oval | 14
Nugget Ring | 12.5
Nugget Tripple | 15 | 6
Orb Earring | 30
[NAME] | 3
Packing | 12.5 |  |  | 10
[NAME] | 16
[NAME] | 18 |  |  | 50
Pebble Earring | 11
Petal Earring | 14
Posy Earring | 30
Pulp Bell Light | 16.5
Pulp Bowl Large With Gold Paint | 18
Pulp Bowl Medium | 12
Pulp Bowl Medium With Paint | 14
Pulp Bowl Plain Large | 17
Pulp Bowl Small | 6.5
Pulp Hoop Earring | 20
Pulp Light Round | 16 |  |  | 25
Pulp Light Round With Kudala Top | 33
Pulp Nugget Double | 14
Pulp Studs Round | 14
Pulp Triangle Earring | 16
Pulp Triangle Pendant | 13 |  |  | 60
Quartz Earring | 18
Round Circle Pendant | 14.5
Round Vase | 105 | 16
Ruby Layered Earring | 17
Samples | 12.5 | 14.15
Scalps | 0.55
Sewing | 14
Shopper With Handles | 35
Shopper With Handles From Stratch | 35
Shopper With Handles Made | 28
Shopper Without Handles | 28
Sibebe Light Extra Large | 25 |  |  | 75
Sibebe Light Large | 20
Sibebe Light Medium | 15
[NAME] | 60
[NAME] | 18 | 21
Square Vase | 110 | 12
Sun Hoop Colour | 20
Sun Hoop Gold | 21
Swazi Bowl Large | 30 | 1
Swazi Bowl Medium | 25
Swazi Platter | 25
Swazi Platter Small | 10 |  |  | 100
[NAME] | 10
Tengetile Big Earring | 30
Tengetile Layered Earring | 16
Tengetile Pulp Earring | 17
[NAME] | 55
Tilwane Vase | 25
Triangle Vase | 130 | 13
Wall Art | 30
[NAME] | 20
[NAME] | 22.5
Total
Spreadsheet: 780096d1652286944-generating-rows-of-0s-and-1s-with-certain-parameters-skakiera_data
Sheet: Attributes

 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {0,1}
 | {yes,no}
Spreadsheet: 32751d1228924218-tracking-the-difference-between-two-running-scores-in-a-game-tabulating-take-2
Sheet: Sheet1

Total as of this round you | Total as of this round them |  | You | Them | Winner this round | Overall progress
3 | 5 |  | 3 | 5 | They won by 2
7 | 11 |  | 4 | 6 | They won by 2 | They got farther ahead by 2
10 | 15 |  | 3 | 4 | They won by 1 | They got farther ahead by 1
15 | 21 |  | 5 | 6 | They won by 1 | They got farther ahead by 1
19 | 25 |  | 4 | 4 | Tie | Tie
24 | 29 |  | 5 | 4 | You won by 1 | You got closer by 1
30 | 31 |  | 6 | 2 | You won by 4 | You got closer by 4
37 | 32 |  | 7 | 1 | You won by 6 | You got closer by 6
 |  | Totals | 37 | 32 |  | You have caught up by 7
Spreadsheet: 802775d1667030486-count-if-each-code-how-many-times-got-yes-no-in-list-count-if
Sheet: Sheet1

 | # | CODE | YES | NO |  | CODE | YES | NO
 | 1 | 33 | ✓ |  |  | 22 | 2 | 0
 | 2 | 22 | ✓ |  |  | 33 | 1 | 1
 | 3 | 33 |  | ✓
 | 4 | 22 | ✓
Spreadsheet: 85168d1285223209-divide-by-zero-errors-kitchen-replacement-programme-2010-11_revised_web_upload2
Sheet: kitchen Completions CPHA

 |  | Properties Instructed |  | Projected Spend
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs |  |  |  | Actual Property Completions |  | Actual Costs
 |  | Aug |  |  |  |  |  |  |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Sept
 |  | Oct |  |  |  |  |  |  |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Nov
 |  | Dec |  |  |  |  |  |  |  | Dec
 |  | Jan |  |  |  |  |  |  |  | Jan
 |  | Feb |  |  |  |  |  |  |  | Feb
 |  | Mar |  |  |  |  |  |  |  | Mar
 |  | Apr |  |  |  |  |  |  |  | Apr
 |  | May |  |  |  |  |  |  |  | May
 |  | Jun |  |  |  |  |  |  |  | Jun
 |  | All Properties |  | Projected Spend |  |  |  |  |  | Average Figures
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs
 |  |  |  |  |  |  |  |  |  | Initial Works Order Value
 |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Variations
 |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Final Works Order Value
 |  | Dec
 |  | Jan
 |  | Feb
 |  | Mar
 |  | Apr
 |  | May
 |  | Jun
 |  | Over All Totals
 |  | Initial Works Order Value
 |  | Variations
 |  | Final Works Order Value
Spreadsheet: 865421d1712473433-count-cells-that-have-similar-data-test-census-aligw
Sheet: Sheet1

Name address postcode
[NAME] | 1 test ave | SW1 |  |  | 3
[NAME] | 1 test ave | SW1 |  | simple street | 1
claire | 3 test ave | SW1 |  | go yard | 1
zoe | 3 test ave | SW1
martin | 6 test ave | SW1
bob | 1 simple street | NW1
chloe | 1 simple street | NW1
v | 8 go yard | SW11
Spreadsheet: 109762d1306524477-excel-2007-specific-date-compared-to-date-range-terrip
Sheet: Year 19

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 19:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
217 | January
218 | February
219 | March
220 | April
221 | May
222 | June
223 | July
224 | August
225 | September
226 | October
227 | November
228 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 453720d1459425096-complicated-formula-help-lookup-row-and-then-add-certain-cells-until-count-is-met-sample
Sheet: Master

 | Initial Handicap Factor |  |  | Event 1 | Event 2 | Event 3 | Event 4 | Event 5 | Event 6
Competitor 1 | 0.98
Competitor 2 | 1.02
Competitor 3 | 0.96
Competitor 4 | 0.85
Competitor 5 | 1.12
Competitor 6 | 1.05
Spreadsheet: 755006d1636635487-sum-up-row-and-column-with-date-range-book6
Sheet: JETS REF & STARTS RAW Data

Referrals
Local Office | 2021-04-05 00:00:00 | 2021-04-12 00:00:00 | 2021-04-19 00:00:00 | 2021-04-26 00:00:00 | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00 | 2021-07-05 00:00:00 | 2021-07-12 00:00:00 | 2021-07-19 00:00:00 | 2021-07-26 00:00:00 | 2021-08-02 00:00:00 | 2021-08-09 00:00:00 | 2021-08-16 00:00:00 | 2021-08-23 00:00:00 | 2021-08-30 00:00:00 | 2021-09-06 00:00:00 | 2021-09-13 00:00:00 | 2021-09-20 00:00:00 | 2021-09-27 00:00:00 | 2021-10-04 00:00:00 | 2021-10-11 00:00:00 | 2021-10-18 00:00:00 | 2021-10-25 00:00:00 | 2021-11-01 00:00:00
[NAME] | 9 | 8 | 12 | 50 | 17 | 24 | 23 | 20 | 11 | 19 | 22 | 26 | 24 | 16 | 12 | 6 | 15 | 6 | 7 | 3 | 11 | 5 | 16 | 15 | 14 | 11 | 8 | 14 | 6 | 8 | 21
Ealing | 18 | 95 | 121 | 90 | 88 | 84 | 67 | 79 | 66 | 67 | 62 | 58 | 45 | 56 | 51 | 32 | 37 | 21 | 19 | 37 | 34 | 15 | 28 | 22 | 32 | 33 | 40 | 30 | 25 | 11 | 21
Fulham | 6 | 3 | 13 | 20 | 28 | 40 | 24 | 20 | 12 | 33 | 31 | 15 | 11 | 16 | 16 | 17 | 14 | 17 | 21 | 18 | 27 | 6 | 13 | 10 | 4 | 2 | 2 | 11 | 11 | 8 | 8
Harlesden | 9 | 10 | 31 | 26 | 22 | 34 | 29 | 21 | 10 | 34 | 37 | 31 | 57 | 74 | 83 | 44 | 35 | 30 | 27 | 21 | 29 | 10 | 22 | 33 | 31 | 13 | 20 | 26 | 44 | 47 | 44
[NAME] | 10 | 7 | 35 | 48 | 44 | 49 | 33 | 40 | 15 | 37 | 37 | 36 | 23 | 20 | 32 | 12 | 28 | 10 | 16 | 21 | 25 | 10 | 31 | 21 | 22 | 23 | 12 | 16 | 25 | 21 | 32
[NAME] | 6 | 5 | 10 | 6 | 15 | 16 | 25 | 15 | 8 | 10 | 18 | 16 | 12 | 13 | 4 | 9 | 6 | 2 | 7 | 1 | 3 | 3 | 3 | 3 | 6 | 11 | 1 | 15 | 6 | 5 | 3
Hounslow | 12 | 23 | 26 | 30 | 26 | 46 | 37 | 30 | 28 | 42 | 29 | 34 | 48 | 65 | 52 | 39 | 38 | 33 | 49 | 33 | 45 | 15 | 57 | 53 | 26 | 24 | 14 | 25 | 24 | 10 | 13
Kingston | 6 | 22 | 22 | 17 | 19 | 13 | 18 | 25 | 26 | 27 | 25 | 28 | 28 | 19 | 22 | 22 | 21 | 17 | 11 | 9 | 6 | 17 | 11 | 8 | 14 | 8 | 7 | 13 | 14 | 11 | 21
Grand Total | 125 | 258 | 396 | 389 | 364 | 412 | 343 | 332 | 247 | 381 | 361 | 361 | 342 | 397 | 377 | 239 | 253 | 190 | 224 | 208 | 243 | 128 | 239 | 200 | 201 | 164 | 148 | 187 | 192 | 152 | 203
 |  | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00
ERROR
SHOULD BE