tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725529d1616725335-help-with-an-if-statement-sample-2
Sheet: Sheet1

Ticker | Date | Day of year | Day of WK |  | E1 | E2 | SL Close | SL Low | PT1 | PT2 | PT3 | PAx Broke E2 before hitting P1 | Hit PT1 after E1 | Hit E1, but not E2 | Hit E1 and E2 | Broke SL Close | Broke SL Low | Fails to hit PT1 w/in 10 bars | Fails to hit PT2 w/in 10 bars | Fails to hit PT3 w/in 10 bars | Hit PT1 in 10bars, before hitting E1/E2
CFRX | 2021-03-11 00:00:00 |  |  |  | 5 | 5 | 5 | 5 | 1 | 1 | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected result
 |  | scenario 1 |  |  | 5 | 5 | 5 | 5 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  | See picture below, price action went up past PT1 and PT2 on the first red bar after the little green arrow
 |  | scenario 2 |  |  | 0 | 0 | 0 | 0 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  | Hypothetical: price action just goes up to [NAME] and PT2 and just stays up there for the next 9 bars
 |  | scenario 3 |  |  | 5 | 5 | 5 | 5 | 6 | 6 |  |  |  |  |  |  |  |  |  |  | X |  | Hypothetical: price action goes down to E1 and E2 after 5 bars, then moves up to [NAME] and PT2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenarios 1 and 2 are both true because price action touched [NAME] and PT2 before touching E1/E2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 3 is false because it touches E1/E2 before touching a PT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Re: Help with an =If statement
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Okay, I'm attaching the example that tipped me off. Cells F2 and G2 comprise of a zone where I would consider entries("E1" and "E2"), J2, K2, and L2 are price targets (PT1-3). In this example, price went up and touched [NAME] and PT2, but not [NAME], so cells J2 and K2 got a "1" for the number of days it took to reach those PTs. But then price came back down below "E1" and "E2" a few days later.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell V2 is the formula in question. It is supposed to be a true/false on whether price action hit PT1 without hitting E1/E2, and within 10 days from the signal. Basically, this cell is telling my whether or not price skipped my entry zone or not within a period of 10 days. It should read as a "1" as it is true in this case. Price action didn't hit E1/E2 until 4 days after hitting [NAME], but currently produces an "X" (false).
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanks again, let me know if I can explain anything else.
Spreadsheet: 00aa3921-82fc-477c-a2de-16b09eeafa81
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
MS
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | Past Results  in 2013 National and International events
1
2
3
4
WS
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | Past Results  in 2013 National and International events
1
2
3
4
MD
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | Past Results  in 2013 National and International events
1
2
3
4
WD
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | Past Results  in 2013 National and International events
1
2
3
4
XD
RANKING ORDER | FAMILY NAME | GIVEN NAME | BWF NUMBER | DATE OF BIRTH (dd/mm/yy) | Past Results  in 2013 National and International events
1
2
3
4
COUNTRY / MEMBER ASSOCIATION:
TEAM MANAGER:
DATE:
Spreadsheet: 10f8f906-7ee6-43ad-a3bf-d71370b7a237
Sheet: Project Plan

Project: | SITS Points Based Immigration Implementation
Project Manager: | [NAME]
Task |  | Start Date | Due Date | Date Completed | % Complete | 2012-02-13 00:00:00 | 2012-02-16 00:00:00 | 2012-02-19 00:00:00 | 2012-02-22 00:00:00 | 2012-02-25 00:00:00 | 2012-02-28 00:00:00 | 2012-03-02 00:00:00 | 2012-03-05 00:00:00 | 2012-03-08 00:00:00 | 2012-03-11 00:00:00 | 2012-03-14 00:00:00 | 2012-03-17 00:00:00 | 2012-03-20 00:00:00 | 2012-03-23 00:00:00 | 2012-03-26 00:00:00 | 2012-03-29 00:00:00 | 2012-04-01 00:00:00 | 2012-04-04 00:00:00 | 2012-04-07 00:00:00 | 2012-04-10 00:00:00 | 2012-04-13 00:00:00
Initiate
Task1
[NAME]
…
Plan
Initial SITS consultancy meeting / project meeting |  | 2012-02-13 00:00:00 | 2012-02-13 00:00:00 | 2012-02-13 00:00:00 | 100
Finalise project brief and project plan |  | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 |  | 50
Do it
Send out course start and end date report to HoP for checking |  | 2012-02-14 00:00:00 | 2012-02-17 00:00:00
Receive start and end date amendments back from [NAME] and share with YSJ International |  | 2012-02-20 00:00:00 | 2012-02-24 00:00:00
Develop appropriate SRF, SYP and other background records in SITS Test system |  | 2012-02-13 00:00:00 | 2012-03-02 00:00:00
Generate full range of dummy VCR records in SITS Test |  | 2012-03-05 00:00:00 | 2012-03-16 00:00:00
Develop SITS guides and documentation |  | 2012-03-05 00:00:00 | 2012-03-16 00:00:00
Copy across SITS background records from Test to Live system |  | 2012-03-16 00:00:00 | 2012-03-16 00:00:00
Check it
Test Live system and refine by generating full range of dummy VCR records in SITS Live |  | 2012-03-19 00:00:00 | 2012-03-30 00:00:00
Adjust SITS guides and documentation as required |  | 2012-03-26 00:00:00 | 2012-03-30 00:00:00
Prior to going live, delete all existing VCRs from Live system |  | 2012-03-30 00:00:00 | 2012-03-30 00:00:00
Release
Generate live VCRs, export xml file and upload to UKBS SMS |  | 2012-04-02 00:00:00 | 2012-04-06 00:00:00
Download and import CAS Status data from UKBA SMS |  | 2012-04-02 00:00:00 | 2012-04-06 00:00:00
Close
Finalise SITS guides and documentation |  | 2012-04-09 00:00:00 | 2012-04-13 00:00:00
Document lessons learnt |  | 2012-04-09 00:00:00 | 2012-04-13 00:00:00
Scope out any ongoing Phase 2 actions |  | 2012-04-09 00:00:00 | 2012-04-13 00:00:00
ON SCHEDULE
AT RISK
DELAYED
[NAME]
Spreadsheet: 188348d1350839451-if-then-with-multiple-numbers-workbook103
Sheet: Sheet1

1 | 87 |  | 76
3 | 81 |  | 82
5 | 76 |  | 84
7 | 84 |  | 85
9 | 84 |  | 86
11 | 84 |  | 92
13 | 76
15 | 85
17 | 91
19 | 82
61 | 86
63 | 70
65 | 82
67 | 92
69 | 71
71 | 69
73 | 74
75 | 86
77 | 85
79 | 92
Spreadsheet: 73592d1274230263-excel-2007-sorting-and-updating-list-in-multiple-tabs-excel-help
Sheet: Master

 | List
 | item
 | Apple
 | [NAME]
 | beans
 | blackcurrent
 | carrot
 | [NAME]
 | cucumber
 | ginger
 | grapes
 | guava
 | [NAME]
 | Lemon
 | mango
 | mushroom
 | onion
 | Orange
 | Pear
 | Pineapple
 | potato
 | raspberry
 | rockmellon
 | [NAME]
 | sweetcorn
 | watermellon
Spreadsheet: 854891d1704640622-need-to-get-right-date-transactions_export_21482__07_01_2024__111227-aligw
Sheet: Transactions_Export_21482__07_0

created_at
2024-01-06 21:45:00 | 2024-01-06 00:00:00
2024-01-06 21:17:00 | 2024-01-06 00:00:00
2024-01-01 20:18:00 | 2024-01-01 00:00:00
2024-01-01 20:17:00 | 2024-01-01 00:00:00
2023-12-30 02:17:00 | 2023-12-30 00:00:00
2023-12-29 02:17:00 | 2023-12-29 00:00:00
2023-12-20 22:08:00 | 2023-12-20 00:00:00
2023-12-18 12:46:00 | 2023-12-18 00:00:00
2023-12-17 19:37:00 | 2023-12-17 00:00:00
2023-12-14 21:20:00 | 2023-12-14 00:00:00
2023-12-14 00:59:00 | 2023-12-14 00:00:00
2023-12-13 03:55:00 | 2023-12-13 00:00:00
2023-12-13 03:51:00 | 2023-12-13 00:00:00
2023-12-13 03:47:00 | 2023-12-13 00:00:00
Spreadsheet: 162634d1340018369-excel-formulas-seem-to-stop-working-at-a-certain-range-camp-sign-up-spreadsheet-test
Sheet: Road Trip Week

 | Name | Age | Emergency Contact | Phone Number
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: mark_guzman__24544__west prices1005
Sheet: Power West Price Off-Peak

 |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
[NAME] | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
Change |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
[NAME] | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA
COB
NP15
ZP26
SP15
Palo Verde
ROCKIES
 |  | 2000 |  |  |  |  | 2001 |  |  |  | 2002 | 2003 |  |  | 2004-2014
[NAME] | 2000-08-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | Cal-00 | Q1-01 | Q2-01 | Q3-01 | Q4-01 | Cal-01 | Cal-02 | Cal-03 | Q1 | Q2 | Q3 | Q4 | Cal 04-14
MID-COLUMBIA | 0 | 80 | 85 | 79.03225806451613 | 81.34408602150538 | 72.03379416282641 | 54.88091397849462 | 66.55806451612904 | 53.16106630824373 | 61.65845974142345 | 38.74191020225295 | 34.24191020225295 | 17.85736628962435 | 9.595630498533723 | 41.97175953079179 | 34.033793580971 | 25.86463747498021
COB | 0 | 85 | 85 | 81.80645161290323 | 83.93548387096774 | 63.56259600614439 | 46.18987455197132 | 60.79032258064516 | 51.47043010752689 | 55.50330581157193 | 38.97175115207374 | 35.47175115207374 | 24.19426756039658 | 13.02984359726295 | 45.11973607038123 | 38.77952101661779 | 30.28084206116464
NP15 | 0 | 87 | 67.125 | 67.69354838709678 | 73.93951612903226 | 60.57718894009216 | 48.64996415770609 | 60.04301075268817 | 56.76433691756273 | 56.50862519201229 | 43.4386866359447 | 32.97083333333334 | 29.64242424242425 | 24.39242424242424 | 27.49636363636364 | 28.71575757575758 | 27.56174242424242
ZP26 | 0 | 67 | 47.625 | 47 | 53.875 | 43.02995391705068 | 33.58602150537634 | 46.10806451612903 | 39.03225806451613 | 40.43907450076804 | 38.48376615316031 | 30.9175 | 28.28945327596055 | 23.8182823258678 | 27.49636363636364 | 28.02825769504263 | 26.90808923330866
SP15 | 0 | 67 | 47.625 | 47 | 53.875 | 43.02995391705068 | 33.58602150537634 | 46.10806451612903 | 39.03225806451613 | 40.43907450076804 | 38.60876615316031 | 32.11083333333334 | 28.51894908964211 | 25.29181742819563 | 37.7581215482337 | 28.6128410880185 | 30.04543228852249
Palo Verde | 0 | 55 | 45 | 50.06451612903227 | 50.02150537634409 | 41.96697388632872 | 25.14354838709677 | 47.9 | 39.42249103942653 | 38.608253328213 | 33.28162748502714 | 30.23134842075116 | 32.76824516996201 | 15.45793903439422 | 22.06255312664361 | 27.60136593380341 | 24.47252581620081
ROCKIES | 0 | 55 | 55 | 50.06451612903227 | 53.35483870967742 | 41.96697388632872 | 25.14354838709677 | 47.9 | 39.42249103942653 | 38.608253328213 | 33.28162748502714 | 30.23134842075116 | 32.76824516996201 | 15.45793903439422 | 22.06255312664361 | 27.60136593380341 | 24.47252581620081
Spreadsheet: 709880d1608600746-enter-two-conditions-to-query-the-size-forum1221-1-
Sheet: Sheet1

Model | Size | inlet * Outlet |  |  |  | Model | Size | in
 |  | in | [NAME] |  |  | T5 | 5
T5 | 1~2 | 1/2" * 5/8" |  |  |  |  |  | 7/8" * 1-1/8" |  | 7/8" * 1-1/8"
 | 3 | 1/2" * 7/8"
 | 4 | 5/8" * 7/8" |  |  |  |  |  | set I3 font color to white
 | 5 | 7/8" * 1-1/8"
T12 | 1~2 | 5/8" * 7/8"
 | 3~4 | 7/8" * 1"
 | 5~6 | 7/8" * 1-1/8"
T20 | 1 | 7/8" * 1-1/8"
T55 | 1~2 | 1-1/8" * 1-3/8"
Spreadsheet: 882647d1731037874-sumifs-with-multiple-sum-range-and-criteria-in-different-sheets-sumifs-accross-mutiple-sheets
Sheet: Total Summary

Name | 2024-11-01 00:00:00 | 2024-11-04 00:00:00 | 2024-11-08 00:00:00 | Total
[NAME]
[NAME]
[NAME]
Spreadsheet: 102782d1300733924-max-value-required-sol-required
Sheet: Sheet1

Source DATABASE |  |  |  |  | REPORT ( with formula )
Sales Man Code | Zone | Date | $ [NAME] |  | Sales Man Code | Zone | Date | $ [NAME]
A | East | 2010-01-01 00:00:00 | 100 |  | A | West | 2010-11-25 00:00:00 | 3100 | [NAME] see the info corresponding to MAX , example for A
B | East | 2010-01-03 00:00:00 | 200 |  | B
C | East | 2010-01-05 00:00:00 | 300 |  | C
D | East | 2010-01-07 00:00:00 | 400 |  | D
E | East | 2010-01-09 00:00:00 | 500 |  | E
F | East | 2010-01-11 00:00:00 | 600 |  | F
G | South | 2010-10-10 00:00:00 | 2700 |  | G
H | South | 2010-10-21 00:00:00 | 2800 |  | H
P | South | 2010-11-01 00:00:00 | 2900 |  | P
Q | South | 2010-11-13 00:00:00 | 3000 |  | Q
A | West | 2010-11-25 00:00:00 | 3100
B | West | 2010-12-07 00:00:00 | 3200
G | North | 2010-12-12 00:00:00 | 1700
Q | West | 2010-12-12 00:00:00 | 4000
C | West | 2010-12-20 00:00:00 | 3300
H | North | 2010-12-25 00:00:00 | 1800
D | West | 2011-01-02 00:00:00 | 3400
E | West | 2011-01-04 00:00:00 | 3500 |  | wherein new SALES MAN CODE entetred
P | North | 2011-01-07 00:00:00 | 1900 |  | these sould be the formula so that can be pasted in next
Q | North | 2011-01-09 00:00:00 | 2000
A | South | 2011-01-11 00:00:00 | 2100
B | South | 2011-01-13 00:00:00 | 2200
C | South | 2011-01-15 00:00:00 | 2300
D | South | 2011-01-17 00:00:00 | 2400
E | South | 2011-01-19 00:00:00 | 2500
F | South | 2011-01-21 00:00:00 | 2600
G | East | 2011-02-05 00:00:00 | 700
H | East | 2011-02-08 00:00:00 | 800
P | East | 2011-02-11 00:00:00 | 900
Q | East | 2011-02-14 00:00:00 | 1000
A | North | 2011-02-17 00:00:00 | 1100
B | North | 2011-02-20 00:00:00 | 1200
C | North | 2011-02-23 00:00:00 | 1300
F | West | 2011-02-23 00:00:00 | 3600
D | North | 2011-02-26 00:00:00 | 1400
G | West | 2011-02-26 00:00:00 | 3700
E | North | 2011-03-01 00:00:00 | 1500
H | West | 2011-03-01 00:00:00 | 3800
F | North | 2011-03-05 00:00:00 | 1600
P | West | 2011-03-05 00:00:00 | 3900
Spreadsheet: 876a7b34-a810-4ed7-95a9-75455e8703f4
Sheet: Sheet1

TEAMS IN NEED OF MEETS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
School & Team(s) | Invitational or Dual | Open Dates | Contact Person & Phone
[NAME] | Any with pole vault | Many | [NAME]2442
Bay Port HS B/G V & JV | Any | April 5th or 7th | [NAME]
Racine Park B JV | Week of 3/28 | Week of 3/28 | [NAME]
Washington (Milwaukee) | Any | Please contact | [NAME]
South Milwaukee Boys JV | Any | Week of 3/14 | [NAME]5224
Morse-Marshall | Any | May | [NAME]2370
Spreadsheet: 829805d1684452173-index-match-with-2-inputs-1-string-1-number-but-needs-to-find-equal-or-less-than-test-2-variable-lookup-tms
Sheet: Sheet5

model | type | load |  | wall
FXSQ05TAVJU | DUCTED | 5800 |  | 200 |  | False |  | False | 0
FXFQ07TVJU | CASSETTE | 7200 |  |  |  | False |  | False | 0
FXSQ07TAVJU | DUCTED | 7500 |  |  |  | True |  | False | 0
FXAQ07PVJU | WALL | 7500 |  |  |  | False |  | False | 0
FXFQ09TVJU | CASSETTE | 9500 |  |  |  | False |  | False | 0
FXSQ09TAVJU | DUCTED | 9500 |  |  |  | True |  | False | 0
FXAQ09PVJU | WALL | 9500 |  |  |  | False |  | False | 0
FXFQ12TVJU | CASSETTE | 12000 |  |  |  | False |  | False | 0
FXSQ12TAVJU | DUCTED | 12000 |  |  |  | True |  | False | 0
FXAQ12PVJU | WALL | 12000 |  |  |  | False |  | False | 0
FXFQ15TVJU | CASSETTE | 14000 |  |  |  | False |  | False | 0
FXSQ15TAVJU | DUCTED | 15000 |  |  |  | False |  | False | 0
FXFQ18TVJU | CASSETTE | 18000 |  |  |  | False |  | False | 0
FXSQ18TAVJU | DUCTED | 18000 |  |  |  | True |  | False | 0
FXAQ18PVJU | WALL | 18000 |  |  |  | False |  | False | 0
FXFQ24TVJU | CASSETTE | 23000 |  |  |  | False |  | True | 0
FXSQ24TAVJU | DUCTED | 24000 |  |  |  | True |  | True | 1
FXAQ24PVJU | WALL | 24000 |  |  |  | False |  | False | 0
FXFQ30TVJU | CASSETTE | 30000 |  |  |  | False |  | False | 0
FXSQ30TAVJU | DUCTED | 30000 |  |  |  | False |  | False | 0
FXFQ36TVJU | CASSETTE | 36000 |  |  |  | False |  | False | 0
FXSQ36TAVJU | DUCTED | 36000 |  |  |  | False |  | False | 0
FXFQ48TVJU | CASSETTE | 48000 |  |  |  | False |  | False | 0
FXSQ48TAVJU | DUCTED | 48000 |  |  |  | False |  | False | 0
FXSQ54TAVJU | DUCTED | 54000 |  |  |  | False |  | False | 0
 |  |  |  |  |  | False |  | False | 0
 |  |  |  |  |  | False |  | False | 0
 |  |  |  |  |  | False |  | False | 0
Spreadsheet: 791316d1660273622-metre-squared-to-lineal-metres-calculator-m2-to-lm-calc
Sheet: Cladding & Lining Calculator

CLADDING & LINING CALCULATOR M2 TO LM
 | Client
 |  |  | L - Metres |  | D - Metres |  | m2
 | Area 1 |  | 5 | x | 5 | =
 | Area 2 |  |  | x |  | =
 | Area 3 |  |  | x |  | =
 | Area 4 |  |  | x |  | =
 | Area 5 |  |  | x |  | =
 | Area 6 |  |  | x |  | =
 | Area 7 |  |  | x |  | =
 | Area 8 |  |  | x |  | =
 | Area 9 |  |  | x |  | =
 | Area 10 |  |  | x |  | =
 | Sub Total |  |  |  | m2
 | Wastage |  |  |  | % |  | 10
 | Total area inc. wastage |  |  |  | m2
 | [NAME] of timber |  |  |  | [NAME] |  | 90
 | Total timber required |  |  |  | Lm
Spreadsheet: 849018d1699582627-automated-graph-on-sales-per-day-versus-the-average-of-that-day-from-the-previous-months-excel-forum-i_stanescu_ro_nn-
Sheet: Sheet1

 | Months of the year
Working days of the month | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | AVERAGE |  | I need to create a graph in wich I can see the differnce between yesterday's sales (let's say November 4) versus the averege of the same day for the earlier months (column "AVERAGE"),
1 | 1683 | 5723 | 5868 | 5650 | 5907 | 3521 | 4771 | 5521 | 1983 | 6145 | 2220
2 | 1626 | 2866 | 2515 | 5593 | 6428 | 4807 | 3422 | 6809 | 4117 | 6948 | 3096 |  |  |  | and every day I put in the sales for yesterday, the graph will update
3 | 5586 | 5460 | 3515 | 3875 | 3216 | 1926 | 2479 | 1547 | 4290 | 3251 | 4648
4 | 5090 | 6211 | 1973 | 2280 | 3766 | 2978 | 2539 | 5359 | 4712 | 6244 | 5940
5 | 5747 | 3347 | 3823 | 4980 | 3741 | 3127 | 6839 | 3113 | 6165 | 6595 | 5390
6 | 6300 | 5317 | 3492 | 2093 | 3920 | 5905 | 6921 | 4065 | 2192 | 1767 |  |  |  |  | something like this, but with the averege line too (from column N)
7 | 4871 | 3116 | 1788 | 2362 | 1852 | 3102 | 6861 | 5686 | 2194 | 5264
8 | 4699 | 3133 | 3111 | 5089 | 4270 | 2218 | 3334 | 6591 | 3743 | 3995
9 | 3470 | 3218 | 5224 | 6355 | 3829 | 3786 | 5360 | 3085 | 6017 | 5595
10 | 2538 | 6804 | 4599 | 5162 | 5694 | 1777 | 3892 | 5491 | 5862 | 2546
11 | 5263 | 4484 | 6701 | 4254 | 3218 | 5720 | 3904 | 1874 | 4285 | 6860
12 | 1591 | 6444 | 4631 | 5556 | 3933 | 3820 | 1540 | 6122 | 2874 | 2866
13 | 3987 | 2360 | 1777 | 6965 | 5580 | 2334 | 2393 | 3438 | 3880 | 1906
14 | 2042 | 6017 | 2299 | 4834 | 2989 | 3958 | 1993 | 5769 | 4601 | 4730
15 | 2425 | 3328 | 3883 | 1991 | 5861 | 5172 | 5036 | 3765 | 6191 | 5279
16 | 2610 | 4485 | 5504 | 3838 | 5778 | 4090 | 6406 | 5144 | 3701 | 2174
17 | 2681 | 3670 | 3353 | 1733 | 2940 | 2019 | 4811 | 1578 | 5076 | 2074
18 | 2600 | 6542 | 5161 | 6470 | 4918 | 2355 | 3453 | 3254 | 5997 | 3157
19 | 3886 | 2557 | 3358 |  | 5429 | 5565 | 2331 | 3622 | 5487 | 4258
20 | 4217 | 6233 | 4446 |  | 4844 | 1692 | 6290 | 4108 | 4104 | 3821 |  |  |  |  | working days
21 |  |  | 5991 |  | 5224 |  | 3016 | 3079 | 6106 | 5182
22 |  |  | 6085 |  | 3902 |  |  | 5965 |  | 2820
23 |  |  | 5406
Spreadsheet: 769889d1645719292-count-number-of-blank-cells-between-cells-sample-data
Sheet: Sheet1

 | DateCreated
UserId | 2021-11-21 00:00:00 | 2021-11-22 00:00:00 | 2021-11-23 00:00:00 | 2021-11-24 00:00:00 | 2021-11-25 00:00:00 | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | Days between Purchase
461738 |  |  | 1
461741
461742
461746 |  |  | 1 |  |  |  |  | 1 |  | 6
461753
461758 |  |  |  |  |  |  |  |  | 1
461797
461808
461813 |  |  |  | 1
461824 |  |  |  |  |  |  |  |  | 1
461847
461852 |  |  |  |  |  | 1 |  | 1 |  | 3
461854 |  | 1 |  |  |  | 1
461857 |  |  |  |  |  |  | 1 | 1 |  | 1
461859
461879 |  |  |  |  |  |  |  | 1
Spreadsheet: 136476d1326666704-conditional-summing-of-the-top-80-of-data-top_80_helper
Sheet: Sheet2

Item ID | Description | Total Sales |  | Helper 1 | LARGE Amt | Cumulative |  | Enter an Item | Shirt
Item 1 | Hat | 100000 |  |  |  |  |  |  | Total SUMIF
Item 2 | Shirt | 5000 |  |  |  |  |  |  | 0.8
Item 3 | Shirt | 40000
Item 4 | Tie | 10000
Item 5 | Socks | 6000
Item 6 | Shirt | 10000
Item 7 | Shirt | 8000
Item 8 | Socks | 4000
Item 9 | Hat | 500
Item 10 | Socks | 3000
Spreadsheet: 800420d1665661079-substitute-values-within-cells-substitute_values_cellsv2
Sheet: substitue_values_cells

 | SUBSTITUTE VALUES WITHIN CELLS
 | VIA 3-ARRAYS TABLE
 | table1 | =B9:C16
 | table2 | =B19:D23
 | type | value |  |  | expected_result |  |  | formula |  | formula
 | color | yellow |  |  | yellow |  |  | …
 | color | pale yellow |  |  | light,yellow |  |  | …
 | crystal | alpha-gamma |  |  | alpha-gamma,alpha,gamma |  |  | …
 | color | light yellow |  |  | light,yellow |  |  | …
 | color | grey |  |  | gray |  |  | …
 | crystal | beta theta |  |  | beta,theta |  |  | …
 | color | translucent white |  |  | translucent,transparent,white |  |  | …
 | color | off white yellow |  |  | white,yellow |  |  | …
 | type | value | substitute
 | color | pale | light
 | color | translucent | translucent,transparent
 | crystal | alpha-gamma | alpha-gamma,alpha,gamma
 | color | off
 | color | grey | gray
Spreadsheet: 078b2b1d-4610-4b18-8284-dff3aeca7f24
Sheet: Sheet1

Name | Designation | Organization | Phone | Mobile | [NAME]
Dr. [NAME] | Chief Paediatrician | [NAME], Sukkur | 071-931027 | [PHONE] | [EMAIL]
Ms. [NAME] | Field Monitor Assistant | WFP, Sukkur |  | [PHONE] | [EMAIL]
Dr. [NAME] | Senior Paediatrician | MOH, Sukkur | [PHONE] | [PHONE]
Mr. [NAME] | Moblizor | HANDS, [NAME] |  | [PHONE] | [EMAIL]
Ms. [NAME] | LHV | HANDS, [NAME] |  | [PHONE]
Ms. [NAME] | Nutrition Assistant | SRSO, Sukkur | [PHONE] | [PHONE] | [EMAIL]
Ms. [NAME] | Field Coordinator | SRSP, [NAME] | [PHONE] | [PHONE] | [EMAIL]
Ms. [NAME] | Monitoring and Evaluation Officer | SRSP, [NAME] | [PHONE] | [PHONE] | [EMAIL]
Dr. [NAME] | Nutrition Officer | Johanniter, [NAME] | 0726-512504 | [PHONE] | [EMAIL]
Dr. [NAME] | Nutrition Officer | Johanniter, Kambar | 0744-211180 | [PHONE] | [EMAIL]
[NAME] | Program Coordinator, | SC, Islamabad | [PHONE] | [PHONE] | [EMAIL]
Dr. [NAME] | CMO | OPP-KHSDA, Karachi | 021-36699354 | [PHONE] | [EMAIL]
Dr. [NAME] | Peadiatrician | RUBT [NAME], [NAME] |  | [PHONE] | [EMAIL]
Mr. [NAME] | Program Officer | Insant Dost Welfare Organization, [NAME] | [PHONE] | [PHONE] | [EMAIL]
Dr. [NAME] | Medical Officer | NGO's Development Society, Kamber | [PHONE] | [PHONE]
Dr. Naresh [NAME] | Medical Officer | NGO's Development Society, Kamber | [PHONE] | [PHONE]
[NAME] | [NAME] | IMC, [NAME] |  | [PHONE]
Ms. [NAME] | LHV | IMC, [NAME] |  | [PHONE]
Dr. [NAME] | WMO | Public Health School, [NAME] | [PHONE] | [PHONE] | [EMAIL]
Ms. [NAME] Jalbani | LHV / Tutor | Public Health School, [NAME] | [PHONE] | [PHONE]
Ms. [NAME] | LHV | TRDP, [NAME] |  | [PHONE]
Dr. [NAME] | Health Advisor | CARE Internation, ISB | [PHONE] | [PHONE] | [EMAIL]
Dr. [NAME] | Facilitator | LHW Program, Sindh | [PHONE] | [PHONE] | [EMAIL]
Dr. [NAME] | Facilitator | HELP, Karachi | 021-35833076 | [PHONE] | [EMAIL]
Dr. Dure [NAME] | Course Director | WFP, Karachi
Dr. [NAME] e Alam
Khawaja Mussaddiq Ali | Workshop Coordinator | MOH-NW, Isb | [PHONE] | [PHONE] | [EMAIL]
Spreadsheet: 89611d1289392031-dropping-lowest-grade-biology-101-2010-grades
Sheet: Sheet1

RATs |  |  | Lab |  |  | ICQs |  |  | Hour Exam 1 |  | Hour Exam 2 |  | Final Exam
Grade | Possbile Points |  | Grade | Possbile Points |  | Grade | Possbile Points |  | Grade | Possbile Points | Grade | Possbile Points | Grade | Possbile Points
19 | 20 | RAT #1 | 16 | 16 | Wk 2 Pre | 43 | 50 | ICQ #2 | 130 | 150 | 113 | 125
17 | 19 | RAT #2 | 7 | 9 | Wk 3 Pre | 42 | 50 | ICQ #3
17 | 20 | RAT #3 | 16 | 17 | Wk 4 Pre | 46 | 50 | ICQ #4 |  | RATs
18 | 20 | RAT #4 | 18 | 19 | Wk 6 Pre | 36 | 50 | ICQ #5 |  | ICQs
20 | 20 | RAT #5 | 9 | 9 | Wk 8 Pre | 41 | 50 | ICQ #6 |  | Exam 1
18 | 20 | RAT #6 | 20 | 20 | Wk 9 Pre | 49 | 50 | ICQ #7 |  | Exam 2
20 | 20 | RAT #7 |  |  |  | 45 | 50 | ICQ #8 |  | Particip
12 | 20 | RAT #8 |  |  |  |  |  | ICQ #10 |  | Lab |  |  | Post-Lab
9 | 10 | RAT #9 |  |  |  |  |  | ICQ #11 |  |  |  |  | Pre-Lab
7 | 10 | RAT #10 | 38 | 41 | Wk 2 Post |  |  | ICQ #12 |  |  |  |  | Oral
9 | 10 | RAT #11 | 18 | 22 | Wk 3 Post |  |  |  |  |  |  |  | Particip
10 | 10 | RAT #12 | 25 | 30 | Wk 4 Post |  |  |  |  | Weighted Total
10 | 10 | RAT #13 | 25 | 30 | Wk 6 Post
0 | 10 | RAT #14 | 14 | 14 | Wk 8 Post
 |  | RAT #15 |  |  | Wk 9 Post
 |  | RAT #16
 |  | RAT #17
 |  | RAT #18
 |  | RAT #19 | 1 | 1 | Oral Pres
 |  |  | 1 | 1 | Particip