tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 831697d1685833232-formular-to-call-data-from-another-sheet-5-and-6-ask-new-vrs
Sheet: ALL STUDENTS

MKOA WA MANYARA
HALMASHAURI Y WILAYA [NAME]
A) MATOKEO [NAME] WA MUHULA WA KWANZA MEI, 2023 DARASA LA VI
NB: KILA SHULE IHAKIKI MAJINA [NAME] WA SHULE HUSIKA NA KUANDIKA NAMBA ZAO ZA MTIHANI KAMA INAVYOONEKANA KWENYE M1. FANYA MAREKEBISHO PALIPO NA UKINZANI NA MAJINA YA WATAHINIWA SHARTI YAWE MATATU NA KAMILI.
S/N | KATA | SHULE | JINA LA MTAHINIWA | JINSI    1. M  2. F | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  | KISW |  | ENGL |  | [NAME] |  | SAYANSI &TEKNOLOJIA |  | M/JAMII |  | URAIA NA MAADILI |  | S/KAZ |  |  | DARAJA
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D | JML | WAST | DRJ
1 | KALOLENI | SHEKINA | [NAME] | 1 | 46 |  | 50 |  | 50 |  | 49 |  | 48 |  | 47 |  | 50
2 | KALOLENI | SHEKINA | AUGUSTINO A MUNGA | 1 | 41 |  | 38 |  | 39 |  | 32 |  | 41 |  | 25 |  | 23
3 | KALOLENI | SHEKINA | [NAME] | 2 | 41 |  | 27 |  | 28 |  | 27 |  | 40 |  | 37 |  | 22
4 | KALOLENI | SHEKINA | APIEL B MPACHILI | 1 | 44 |  | 29 |  | 39 |  | 34 |  | 44 |  | 36 |  | 41
5 | KALOLENI | SHEKINA | GLADNESS P SHOSHO | 2 | 41 |  | 30 |  | 31 |  | 34 |  | 39 |  | 36 |  | 25
6
7 |  | SHEKINA | AIDAN JOHN KIMARO | 1 | 46 |  | 46 |  | 42 |  | 42 |  | 43 |  | 39 |  | 40
8 |  | SHEKINA | JIREBLESS FADHILI | 1 | 38 |  | 42 |  | 26 |  | 30 |  | 41 |  | 26 |  | 35
9 |  | SHEKINA | ARVIN S.MBARUKU | 1 | 34 |  | 39 |  | 24 |  | 31 |  | 39 |  | 23 |  | 23
10 |  | SHEKINA | GODBLESS ERICK | 1 | 39 |  | 46 |  | 34 |  | 32 |  | 41 |  | 24 |  | 25
11 |  | SHEKINA | BRAYSON BERNARD | 1 | 27 |  | 34 |  | 28 |  | 33 |  | 25 |  | 34 |  | 35
12 |  | SHEKINA | [NAME] | 1 | 41 |  | 37 |  | 25 |  | 30 |  | 37 |  | 31 |  | 33
13 |  | SHEKINA | JOEL SAIDI MAULID | 1 | 30 |  | 42 |  | 27 |  | 26 |  | 37 |  | 35 |  | 20
14 |  | SHEKINA | BRIGHTNESS KANUYA | 2 | 37 |  | 38 |  | 35 |  | 25 |  | 31 |  | 34 |  | 27
15 |  | SHEKINA | AGRAHI LAZARO | 2 | 39 |  | 37 |  | 26 |  | 24 |  | 35 |  | 31 |  | 34
16 |  | SHEKINA | NICE ASSENGA | 2 | 40 |  | 47 |  | 38 |  | 41 |  | 43 |  | 43 |  | 42
17 |  | SHEKINA | [NAME] | 2 | 42 |  | 44 |  | 41 |  | 42 |  | 38 |  | 39 |  | 37
18 |  | SHEKINA | BRENDA ELIPHACE | 2 | 39 |  | 28 |  | 30 |  | 32 |  | 31 |  | 33 |  | 29
19
 | SHULE | DARAJA | SOMO |  | KISW |  | ENGL |  | [NAME] |  | SAYANSI &TEKNOLOJIA |  | M/JAMII |  | URAIA NA MAADILI |  | S/KAZ |  |  | DARAJA
 | SHEKINA |  | JINSI |  | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 |  | 1 | 2
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | X
 |  |  | JML
Spreadsheet: craig_dean__4363__1-13act
Sheet: EPEData

 | 37366.21319444444
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 41  , 75  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,MANL, 21  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 25  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 125 ,  295,  105, 306 ,  40 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 52  , 52  , 52  ,104  ,  0  ,1
 | LAMBDA, 28.57,  607,  607,  150,   16,    0, 8947,7
 | APS     ,FIRM    ,FC,  ,  25,  25
 | IID     ,FIRM    ,PV,  ,  70,  60
 | PGT     ,LOSS    ,LC,  ,  -1,  -2
 | PNM     ,LOSS    ,WM,  ,   3,   3
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,FIRM    ,HI,  ,  60,  55
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | CISO    ,FIRM    ,PV,  ,  78,   0
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
 | 37300.62986111111
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 39  , 75  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,174  ,215  , 86  ,214  , 41  ,1
 | NEWMAN   ,, 251 ,  390,  155, 400 ,  81 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 51  , 51  , 51  ,104  ,  0  ,1
 | LAMBDA, 23.51,  798,  796,   80,   -3,    0,11060,21
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 721945d1614959964-list-only-positive-numbers-out-of-a-table-with-row-column-cross-titles-list-from-a-table
Sheet: Sheet1

OU | BLL | BLTLL | BLD | BLG | BLUK | BLDK | BLDH | BLI | BLFS | BLSP | BLBC | BLTW | BLKK
BLL | 0 | 9195654.280000001 | -24808604.1 | 0 | 373108.48 | 933.34 | -918632.81 | -14348139.22 | -88234.79 | 3931.32 | -123202.3199999999 | 92224.84 | 229800.65
BLTLL | -9195654.29 | 0 | -2309166.63 | 1208732.7 | 88.8 | 0 | 0 | -115984.52 | 0 | 0 | 0 | 0 | 0
BLD | 24808604.10000001 | 2309166.63 | 0 | 0 | 0 | -954389.6200000001 | 0 | 0 | 0 | 1152079.13 | 0 | 0 | 0
BLG | 0 | -1208732.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLUK | -373108.48 | -88.8 | 0 | 0 | 0 | 2307.23 | 0 | 0 | 0 | 0 | 0 | -301077.31 | 0
BLDK | -933.34 | 0 | 954389.62 | 0 | -2307.23 | 0 | -8976.38 | -5370.639999999999 | 0 | 0 | 0 | 0 | 0
BLDH | 918632.81 | 0 | 0 | 0 | 0 | 8976.38 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLI | 14348139.22 | 115984.52 | 0 | 0 | 0 | 5370.64 | 0 | 0 | 1302903.62 | -13152118.81 | 30475.06 | 0 | 0
BLFS | 88234.79 | 0 | 0 | 0 | 0 | 0 | 0 | -1302903.62 | 0 | 0 | 0 | 0 | 0
BLSP | -3931.32 | 0 | -1152079.13 | 0 | 0 | 0 | 0 | 13152118.81 | 0 | 0 | 0 | 0 | 0
BLBC | 123202.3200000001 | 0 | 0 | 0 | 0 | 0 | 0 | -30475.06 | 0 | 0 | 0 | 0 | 0
BLTW | -92224.84 | 0 | 0 | 0 | 301077.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLKK | -229800.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | BLL-BLTLL | 9195654.280000001
 | [NAME] | 373108.48
 | [NAME] | 933.34
 | BLL-BLSP | 3931.32
 | BLL-BLTW | 92224.84
 | BLL-BLKK | 229800.65
Spreadsheet: 28617d1222954824-no-of-days-in-month-query-overlap-of-days-in-month
Sheet: Sheet1

Start | End | Normalised start | Normalised end | Single formula (doesn't require normalised start and end columns) | Using normalised date columns
2008-07-01 00:00:00 | 2008-07-31 00:00:00 | 2008-09-01 00:00:00 | 2008-07-31 00:00:00 | 0 | 0 | 2008-09-01 00:00:00 | <- month cell
2008-07-01 00:00:00 | 2008-09-24 00:00:00 | 2008-09-01 00:00:00 | 2008-09-24 00:00:00 | 24 | 24
2008-07-01 00:00:00 | 2008-10-31 00:00:00 | 2008-09-01 00:00:00 | 2008-09-30 00:00:00 | 30 | 30
2008-09-01 00:00:00 | 2008-09-30 00:00:00 | 2008-09-01 00:00:00 | 2008-09-30 00:00:00 | 30 | 30
2008-09-01 00:00:00 | 2008-10-31 00:00:00 | 2008-09-01 00:00:00 | 2008-09-30 00:00:00 | 30 | 30
2008-10-01 00:00:00 | 2008-12-31 00:00:00 | 2008-10-01 00:00:00 | 2008-09-30 00:00:00 | 0 | 0
Spreadsheet: b3a14e45-2b3b-4b57-852b-aad0b1cce0e9
Sheet: Sheet1

Table S3. Distribution of the PvDBP Duplication Among Non-travelers and Travelers
Country | n = | Residence Statusa | PvDBP Duplication | PvDBP 2x Prevalence
French [NAME] | 10 | NT | 0
Sudan | 32 | NT | 4
Madagascar | 189 | NT | 100
Armenia | 4 | NT | 0
Azerbaijan | 27 | NT | 0
Turkey | 5 | NT | 0
Uzbekistan | 6 | NT | 0
Cambodia | 33 | NT | 3
[NAME] | 83 | NT | 0
Bolivia | 2 | T | 1
Brazil | 2 | T | 0
French [NAME] | 31 | T | 5
Venezuela | 3 | T | 0
Central Africa Republic | 2 | T | 1
Comoros | 1 | T | 0
Ethiopia | 2 | T | 2
Ivory Coast | 1 | T | 0
Madagascar | 4 | T | 3
Mauratania | 7 | T | 3
Sudan | 1 | T | 0
Bangledesh | 1 | T | 0
India | 16 | T | 2
Pakistan | 9 | T | 2
[NAME] | 4 | T | 1
Cambodia | 10 | T | 3
Lao PDR | 3 | T | 0
Malaysia | 3 | T | 0
Thailand | 5 | T | 0
West Papua | 1 | T | 0
[NAME] | 1 | T | 1
[NAME] | 1 | T | 0
a NT = Non-Travelers, T = Travelers
Spreadsheet: 751338d1634051307-counting-unique-long-numbers-15-digits-sample-tracking
Sheet: Sheet1

Tracking # | Current w/ IF(COUNTIF | Ideal
342384812382341239489 |  | 1
382498923489832948333 |  | 1
328498283148983448323 |  | 1
328498283148983448324 |  | 1
893429851893459843854 |  | 1
344898589958834 |  | 1
342384812382341239489 |  | 0
382498923489832948333 |  | 0
382498923489832948337 |  | 1
Spreadsheet: 330823d1404869571-need-sumif-formula-help-formula-help-v2
Sheet: Sheet2

[NAME] | Exp | Total | [NAME] | Exp | Total | [NAME] | Exp | Total | [NAME] | Exp | Total |  | [NAME] | Exp | Total
12639.5 | 8000 | 20639.5 | 1263.95 | 800 | 2063.95
700 | 400 | 1100 | 70 | 40 | 110
61751 | 34000 | 95751 | 6175.1 | 3400 | 9575.1
227.35 | 50 | 277.35 | 22.735 | 5 | 27.735
0 | 9000 | 9000 | 0 | 900 | 900
 |  |  |  |  |  | 65639.44 | 16409.84 | 82049.28
 |  |  |  |  |  | 0 | 32202.48 | 32202.48
 |  |  |  |  |  | 106617.81 | 34427.79 | 141045.6
 |  |  |  |  |  | 0 | 24975.01 | 24975.01
 |  |  |  |  |  | 0 | 109275.1 | 109275.1
 |  |  |  |  |  |  |  |  | 0 | 4788 | 4788
 |  |  |  |  |  |  |  |  | 221839.94 | 25934.29 | 247774.23
 |  |  |  |  |  |  |  |  | 739190.67 | 152123.96 | 891314.63
 |  |  |  |  |  |  |  |  | 364195.94 | 176159.6 | 540355.54
 |  |  |  |  |  |  |  |  | 3520.35 | 4302.65 | 7823
 |  |  |  |  |  |  |  |  | 243390.74 | 62966.62 | 306357.36
 |  |  |  |  |  |  |  |  | 59921.58 | 16737.06 | 76658.64
 |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 80000 | 20000 | 100000
 |  |  | 120000 | 30000 | 150000
 |  |  | 160000 | 40000 | 200000
 |  |  | 100000 | 25000 | 125000
 |  |  | 0 | 50000 | 50000
Spreadsheet: jane_tholt__13263__Summary for Grigsby
Sheet: Sheet1

 |  | Transportation Capacity West US Grid
 |  | Planned Expansion Summary
Region | Pipeline Name | Exisiting DCQ | 2001 |  | 2002 |  | 2003 |  | 2004 |  | 2005 |  | Comments
 |  | MMBtu/day |  | Total DCQ | Expansion | Total DCQ | Expansion | Total DCQ | Expansion | Total DCQ | Expansion | Total DCQ
PNW | PGT - Malin | 1900000 | 0 |  | 211000 |  | 160000 |  | 0 |  | 0
 | Northwest Pipeline | 2900000 | 0 |  | 0 |  | 254000 |  | 0 |  | 0 |  | excludes displacement fixes of 225,000/d
 | Washington Lateral | 0 | 0 |  | 0 |  | 0 |  | 350000 |  | 0
 | [NAME] | 124000 | 0 |  | 100000 |  | 0 |  | 0 |  | 0
Rockies | Kern River | 835000 | 124000 |  | 10000 |  | 903000 |  | 0 |  | 0
 | CIG | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Ruby Project | 0 | 0 |  | 0 |  | 0 |  | 500000 |  | 0
 | Questar | 0 | 0 |  | 80000 |  | 0 |  | 0 |  | 0
SouthWest | El Paso | 3300000 | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Trans Western | 1190000 | 0 |  | 150000 |  | 0 |  | 540000 |  | 0
 | [NAME] | 0 | 0 |  | 0 |  | 0 |  | 750000 |  | 0
 | North Baja | 0 | 0 |  | 500000 |  | 0 |  | 0 |  | 0
Intra State | SoCal ( Back Bone) | 3200000 | 0 |  | 175000 |  | 0 |  | 0 |  | 0
 | PG& E ( Back Bone) | 3000000 | 0 |  | 200000 |  | 0 |  | 0 |  | 0 |  | planned expansion with Gas Accord
Spreadsheet: 0f611827-9396-491c-aecd-3efefccff478
Sheet: Sheet1

food | ser size | ser | pro | carb | fat | cal | total pro | total carb | total fat | total cal
skim milk | 1 cup | 6 | 8 | 12 | 0 | 90 | 48 | 72 | 0 | 540
oatmeal | 1 cup | 1 | 4 | 32 | 2 | 160 | 4 | 32 | 2 | 160
whole egg | 1 egg | 2 | 6 | 1 | 4.5 | 70 | 12 | 2 | 9 | 140
egg white | 1 egg | 4 | 3.5 | 0.3 | 0 | 16.7 | 14 | 1.2 | 0 | 66.8
whey protein | 1 scoop | 4 | 22 | 2 | 2 | 110 | 88 | 8 | 8 | 440
creatine plus | 1 scoop | 3 | 0 | 34 | 0 | 140 | 0 | 102 | 0 | 420
bun (burger) | 1 bun | 1 | 7 | 37 | 3 | 19 | 7 | 37 | 3 | 19
swiss cheese | 1 slice | 2 | 8 | 1 | 8 | 100 | 16 | 2 | 16 | 200
amer cheese | 1 slice |  | 4 | 2 | 5 | 70 | 0 | 0 | 0 | 0
f/f frozen yogurt | 1/2 cup | 1 | 3 | 19 | 0 | 90 | 3 | 19 | 0 | 90
burger patti | 4 oz | 1 | 23 | 2 | 21 | 290 | 23 | 2 | 21 | 290
lettuce | 1/2 cup | 1 | 0.5 | 0.7 | 0.1 | 3.9 | 0.5 | 0.7 | 0.1 | 3.9
[NAME] | 1 small | 1 | 0.5 | 2.9 | 0.2 | 13 | 0.5 | 2.9 | 0.2 | 13
steak | 10 oz | 1 | 84 | 0 | 27 | 601 | 84 | 0 | 27 | 601
rice (brown) | 1/4 cup | 2 | 3 | 32 | 1 | 150 | 6 | 64 | 2 | 300
broc | 1 cup |  | 2.6 | 4.6 | 0.3 | 24.6 | 0 | 0 | 0 | 0
chicken(sweet chili | 4 oz | 1 | 20 | 12 | 3 | 170 | 20 | 12 | 3 | 170
honey bunch oats | 1/2 cup | 4 | 3 | 25 | 25 | 130 | 12 | 100 | 100 | 520
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | Total | 338 | 456.8 | 191.3 | 3973.7
Spreadsheet: 836484d1689401956-merging-formulas-that-reference-sheets-indirect-formulas-test-file
Sheet: Sheet2

 |  |  |  |  |  |  |  | I am trying to figure out a way to combine both formulas (column B and C) so that I can avoid dragging the formula in column C down and having a bunch of references
 | ZONE | TOTALS |  | Solution? |  |  |  | my first attempt at this was with the formula in column E (I replaced B5 with the formula in column B) but I am having no luck.
 |  | 1000
 | Alpha-02 | 2000 |  |  |  |  |  |  | INDIRECT("'"&B5&"'!"&TEXT(SUBSTITUTE(ADDRESS(1,COLUMN('ALPHA-01'!$H$222),4),"1","")&ROW('ALPHA-01'!$H$222),0))
 | Alpha-03 | 3000 |  |  |  |  |  |  |  | ^
 | Alpha-04 | 4000 |  |  |  |  |  |  |  | IF(SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found")))="","",SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found"))))
 |  |  |  |  |  |  |  |  |  | some test formulas below
 |  |  |  |  |  |  |  |  | Formula 1
 |  |  |  |  |  |  |  |  |  | 'ALPHA-02'!
 |  |  |  |  |  |  |  |  |  | 'ALPHA-03'!
 |  |  |  |  |  |  |  |  |  | 'ALPHA-04'!
 |  |  |  |  |  |  |  |  | Formula 2
 |  |  |  |  |  |  |  |  | Formula 1+2
 |  |  |  |  |  |  |  |  |  | 'ALPHA-02'!H222
 |  |  |  |  |  |  |  |  |  | 'ALPHA-03'!H222
 |  |  |  |  |  |  |  |  |  | 'ALPHA-04'!H222
Spreadsheet: 727835d1618143371-year-to-date-profit-and-loss-excel-formula-year-to-date-profit-and-loss-1
Sheet: Year to Date

I'm asking for a formula to automate Year to date Profit and Loss. Please note that; Donations, Insurance & Licence, Printing & Stationery, Security ,
and other items with zero amount are excluded from this Year to Date Profit and Loss.
Desired outcome
ZWL |  | YTD
Revenue
School Fees
Other Income
Bus Fares
Swimmnig |  | 360
Total Revenue |  | 7460
Expenses
Accounting Fees |  | 65
Cleaning |  | 21
Rental - Knight frank |  | 200
[NAME] |  | 60
Electricity |  | 20
Fuel & Oils |  | 26
Miscellaneous |  | 95
Salaries & Wages |  | 500
Property Repairs & Maintenance |  | 140
Telephone & Internet |  | 125
Workshops & Conferances |  | 100
 |  | 0
Total Expenses |  | 1352
Profit |  | 6108
Your Formula
ZWL |  | YTD
Revenue
School Fees
Other Income
Bus Fares
Swimmnig
Donations
Total Other Income
Expenses
Accounting Fees
Advertising & Marketing
Cleaning
Rental - Knight frank
[NAME]
Electricity
Fuel & Oils
Insurance & Licence
Miscellaneous
Printing & Stationery
Salaries & Wages
Security - Fawcett
Property Repairs & Maintenance
Motor Vehicles Repairs and Maintenance
Feeding Programme
Telephone & Internet
Water & Rates
Board Members Allowance
Subscriptions
Workshops & Conferances
Total Expenses
Profit
Spreadsheet: 72563d1273244872-adding-variable-sums-from-different-cells-time-recording-sheet-2
Sheet: Sheet1

Name |  |  |  | Sheet No.
Date |  |  |  | of
Activity Code | Time | Elapsed Time | Comments | Activity Code | Time | Elapsed Time | Comments |  |  | Toatl Time Recorded for each Category
a1 | 09:00:00 | 02:00:00 |  |  |  |  |  |  |  | Other Building Control Activities
a10 | 11:00:00 | 01:00:00 |  |  |  |  |  |  |  | A1 | sum of all A1
A7 | 12:00:00 | 01:15:00 |  |  |  |  |  |  |  | A2 | sum of all A2
A5 | 13:15:00 | 01:45:00 |  |  |  |  |  |  |  | A3 | etc
A1 | 15:00:00 | 02:00:00 |  |  |  |  |  |  |  | A4 | etc
A5 | 17:00:00 | 00:30:00 |  |  |  |  |  |  |  | A5
end | 17:30:00 |  |  |  |  |  |  |  |  | A6
 |  |  |  |  |  |  |  |  |  | A7
 |  |  |  |  |  |  |  |  |  | A8
 |  |  |  |  |  |  |  |  |  | A9
 |  |  |  |  |  |  |  |  |  | A10
 |  |  |  |  |  |  |  |  |  | A11
 |  |  |  |  |  |  |  |  |  | A12
 |  |  |  |  |  |  |  |  |  | A13
 |  |  |  |  |  |  |  |  |  | A14
 |  |  |  |  |  |  |  |  |  | A15
 |  |  |  |  |  |  |  |  |  | A16
 |  |  |  |  |  |  |  |  |  | A17
 |  |  |  |  |  |  |  |  |  | A18
 |  |  |  |  |  |  |  |  |  | A19
 |  |  |  |  |  |  |  |  |  | A20
 |  |  |  |  |  |  |  |  |  | A21
 |  |  |  |  |  |  |  |  |  | A22
Total Time Recorded |  | 06:30:00 |  |  |  |  |  |  |  | A23
 |  |  |  |  |  |  |  |  |  | A24
 |  |  |  |  |  |  |  |  |  | A25
 |  |  |  |  |  |  |  |  |  | A26
 |  |  |  |  |  |  |  |  |  | A27
 |  |  |  |  |  |  |  |  |  | A28
 |  |  |  |  |  |  |  |  |  | A29
Spreadsheet: 264964d1379024099-looping-through-data-and-finding-cells-that-meet-criteria-test
Sheet: Snow White

Supplier # | Supplier | SSR | Discrepancy Type | PO # | PO Date | Stuff | P/n | P/n | Total Order Qty | Received | Total Due | Cost | Balance | Now | Here | When | Ack Qty 1 | Country | Mexico | Canada | Taiwan | Part | Cuba
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63871 | 63871 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63872 | 63872 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63873 | 63873 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63874 | 63874 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63875 | 63875 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63876 | 63876 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63877 | 63877 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63878 | 63878 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63879 | 63879 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63880 | 63880 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63881 | 63881 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Blank Ack Date | y | ? |  | 63882 | 63882 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
g | [NAME] | [NAME] | Past Due Ack | y | ? |  | 63886 | 63886 | 100 | 0 | 0 | 0 | 0 |  |  | ? | 0 | A | 0 | 1 | 0 | 0 | 0
Spreadsheet: 53334d1253214577-vlookup-formula-returns-na-vlookup-formula
Sheet: Ref

Code | Facility
11 | SMS
12 | AP
13 | DP
14 | HAHS
16 | EP
47 | M
88 | LP
92 | ILC
1001 | TB
1002 | CPP
Spreadsheet: 734047d1621955482-need-help-on-making-a-formula-for-date-help
Sheet: Blad1

In Machine:
Machine | Cartridge number |  | Date |  | Lot# | Pcs |  | Total |  | Last update: |  | 2021-03-03 00:00:00
3.1 | 8 |  |  |  | 14 | 2021-05-11 00:00:00 |  | 2021-05-21 00:00:00 | 92928444 | 127
3.2 | 6 |  |  |  | 5 | 2021-05-17 00:00:00 |  | 2021-05-25 00:00:00 | 92928444 | 211 | 32
3.3 | 1 |  |  |  | 12 | 2021-05-10 00:00:00 |  | 2021-05-06 00:00:00 | 92928444 | 189
3.4 | 2 |  |  |  | 15 | 2021-05-25 00:00:00 |  | 2021-05-21 00:00:00 | 92928444 | 207
3.5 | 18 |  |  |  | 19 | 2021-05-21 00:00:00 |  | 2021-05-21 00:00:00 | 92928444 | 139
3.6 | 20 |  |  |  | 7 | 2021-05-14 00:00:00 |  | 2021-05-19 00:00:00 | 92928444 | 173
3.7 |  |  |  |  |  |  |  |  | 92928444 | 66 | 185
3.8 | 10 |  |  |  | 9 | 2021-05-21 00:00:00 |  | 2021-05-20 00:00:00 | 92928444 | 210 | 147
Storage
Storage
Storage
Empty
Empty
Empty
Spreadsheet: shelley_corman__38749__Cashinoutmajorityminority
Sheet: August 2000

August, 2000 Production Month
Cash In/Out after [NAME] | 26 | Majority is Due Shippers
 | 20 | Minority is Due FGT
le_nm | [NAME] | inv_amt | sum_mmbtu_qty
ADAMS RESOURCES MARKETING, LTD. | CIO | -2029.35 | -489
ALUMINUM COMPANY OF AMERICA | CIO | -9913.52 | -2986
ASHLAND CHEMICAL COMPANY | CIO | -257.3 | -62
BAPTIST MEDICAL CENTER | CIO | -7154.6 | -1724
[NAME] | CIO | -7959.7 | -1918
CELOTEX CORPORATION | CIO | -5548.55 | -1337
CHESAPEAKE UTILITIES CORPORATION | CIO | -32905.35 | -7929
CINERGY MARKETING & TRADING, LLC | CIO | -3755.75 | -905
DUKE ENERGY TRADING AND MARKETING,L.L.C. | CIO | -228560.46 | -72228
DYNEGY GAS TRANSPORTATION, INC. | CIO | -11478.9 | -2766
[NAME], L.P. | CIO | -8228.21 | -2203
FLORIDA POWER CORPORATION | CIO | -339374.55 | -81777
FLORIDA PUBLIC UTILITIES COMPANY | CIO | -48380.7 | -11658
HIGHLAND ENERGY COMPANY OF TEXAS | CIO | -2566.36 | -773
HOUSTON PIPE LINE COMPANY | CIO | -32921.95 | -7933
INFINITE ENERGY, INC. | CIO | -36598.85 | -8819
NATIONAL GYPSUM COMPANY | CIO | -5619.1 | -1354
NUI CORPORATION | CIO | -56137.05 | -13527
ORLANDO COGEN FUEL, INC | CIO | -179657.24 | -48101
ORLANDO UTILITIES COMMISSION | CIO | -65947.65 | -15891
PREMIER SERVICES CORP | CIO | -6625.89 | -1774
PRIOR INTRASTATE CORPORATION | CIO | -3286.8 | -792
REEDY CREEK IMPROVEMENT DISTRICT | CIO | -51945.55 | -12517
SOUTHEAST ALABAMA GAS DISTRICT | CIO | -32801.6 | -7904
ST. JOE NATURAL GAS COMPANY | CIO | -12927.25 | -3115
TALLAHASSEE, CITY OF | CIO | -407729.2 | -98248
Total Due 26 Shippers
ALABAMA POWER COMPANY | CIO | 4415.12 | 1045
BP ENERGY COMPANY | CIO | 5663.24 | 1342
CARGILL FERTILIZER,  INC | CIO | 8.44 | 2
CITRUS TRADING CORPORATION | CIO | 23885.2 | 5660
CLARKE-MOBILE COUNTIES GAS DISTRICT | CIO | 88132.14 | 18874
COASTAL MERCHANT ENERGY, L.P. | CIO | 21164.78 | 4691
CORAL ENERGY RESOURCES, L.P. | CIO | 29.54 | 7
ENRON LIQUID SERVICES CORP. | CIO | 6202.87 | 1094
ENRON NORTH AMERICA CORP. | CIO | 326619.18 | 77372
FLORIDA GAS UTILITY | CIO | 53.9 | 616
FLORIDA POWER AND LIGHT COMPANY | CIO | 168247.18 | 39869
MURPHY EXPLORATION & PRODUCTION CO. | CIO | 46173.97 | 9947
ONYX GAS MARKETING COMPANY, L.C. | CIO | 113804.96 | 26968
ORLANDO COGEN II | CIO | 4.22 | 1
PEOPLES GAS SYSTEM, A DIVISION OF TAMPA | CIO | 147662.02 | 34991
SOUTH FLORIDA NATURAL GAS, INC. | CIO | 181.46 | 43
SOUTHERN COMPANY SERVICES | CIO | 1144.01 | 268
TEJAS GAS MARKETING COMPANY | CIO | 8.44 | 2
TEXACO NATURAL GAS, INC. | CIO | 19323.38 | 4579
VASTAR GAS MARKETING, INC. | CIO | 37.98 | 9
Due FGT   20 shippers