tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883299d1731892770-formula-to-find-the-total-of-stock-according-to-date-stock-control
Sheet: Joe

Date | Stock | Quantity | Price | Total
2024-11-15 00:00:00 | Tea bag | 5
2024-11-15 00:00:00 | Pop Me | 2
2024-11-18 00:00:00 | Ramen | 1
2024-11-18 00:00:00 | Bongo (B) | 1
2024-11-18 00:00:00 | Milo | 1
Spreadsheet: 143578d1330465063-look-up-a-value-with-multiple-criteria-theoretically-should-be-a-simple-index-match-excel-forum-example2
Sheet: BF Schedule

 |  | 08:00:00 | 08:30:00 | [NAME] | BECKY | [NAME] | COLTON | JULIE | MIKE R | LESLIE | SHERRI | SAMIA | OTHER
Saturday | 2012-02-18 00:00:00
Sunday | 2012-02-19 00:00:00
Monday | 2012-02-20 00:00:00
Tuesday | 2012-02-21 00:00:00
Wednesday | 2012-02-22 00:00:00
Thursday | 2012-02-23 00:00:00
Friday | 2012-02-24 00:00:00
Saturday | 2012-02-25 00:00:00
Sunday | 2012-02-26 00:00:00
Monday | 2012-02-27 00:00:00
Tuesday | 2012-02-28 00:00:00
Wednesday | 2012-02-29 00:00:00
Thursday | 2012-03-01 00:00:00
Friday | 2012-03-02 00:00:00
Saturday | 2012-03-03 00:00:00
Sunday | 2012-03-04 00:00:00
Monday | 2012-03-05 00:00:00
Tuesday | 2012-03-06 00:00:00
Wednesday | 2012-03-07 00:00:00
Thursday | 2012-03-08 00:00:00
Friday | 2012-03-09 00:00:00
Saturday | 2012-03-10 00:00:00
Sunday | 2012-03-11 00:00:00
Monday | 2012-03-12 00:00:00
Tuesday | 2012-03-13 00:00:00
Wednesday | 2012-03-14 00:00:00
Thursday | 2012-03-15 00:00:00
Friday | 2012-03-16 00:00:00
Spreadsheet: 710088d1608714887-countifs-if-the-text-to-be-counted-is-within-or-inside-a-word-in-a-cell-dropdown-list-book1
Sheet: Sheet4

 |  |  |  | [NAME] | Criteria 1
 |  |  |  | Month | Criteria (Dropdownlist) | [NAME] here
 | postjoeymed | 2020-12-31 00:00:00 |  | December | cat | 2 |  |  | [NAME]
 | lastjoeymed | 2020-12-02 00:00:00 |  |  |  |  |  |  | dog
 | lastjoeymed | 2020-02-02 00:00:00 |  |  |  |  |  |  | cat
 | helpjoeymed | 2020-12-31 00:00:00 |  |  |  |  |  |  | post
 | dogcatmouse | 2020-12-02 00:00:00
 | dogcatmouse | 2020-02-02 00:00:00
 | dogcatmouse | 2020-12-02 00:00:00
 | dogcatmouse | 2020-02-02 00:00:00
Spreadsheet: 848443d1699191901-excel-formular-for-receipts-contents-invoice-vat
Sheet: Fiscal Tax Invoice

 | Kindly asking for excel formula to fill receipt contents using information from sales worksheet
 | The desired solution is on row B26
 | Fiscal Tax Invoice
 |  | Invoice Number |  | BK 006
 | Received From:
 | VAT Number
 | BP Number
 | Desired solution using information on sales worksheet
 | Description | Quantity | Unit Per Price | Amount | VAT | Net Amount
 | CASTOR | 1 | 1 | 1 | 10.5
 | TOPPERS | 2 | 4 | 8 | 1.2
 | CASTOR | 4 | 4 | 16 | 2.4
 | GREEN | 2 | 1 | 2 | 0.3
 |  | Total Net Amount
 |  | Total VAT
 |  | Invoice Total
Spreadsheet: 680942d1591272846-auto-categorize-products-example-data
Sheet: EXPORT

List of Product Titles | Category(In the format I need it for uploading.
[NAME] [NAME] | Shop All;Projects;Holidays/Easter
SD1148 [NAME]'s Cups | Shop All;Holidays/Valentines
SD1149 3D Wheelbarrow with Kitten | Shop All;Projects;Animals
SD1150 Library Bookends | Shop All;Projects
SD1151 Horse Bookends | Shop All;Projects
SD1152 Horse Single | Shop All;Animals
[NAME] | Shop All;Projects
SD1155 3D Dream Bed | Shop All;Projects
SD1158 Iphone Pouch | Shop All;Projects
SD1159 Cupcake Stand | Shop All;Kitchen
SD1160 Botanical Quilts | Shop All;Quilt
SD1161 [NAME] | Shop All;Flowers
SD1162 Botanical Quilts | Shop All;Quilt
SD1164 [NAME] | Shop All;Projects
SD1165 [NAME] | Shop All;Animals
[NAME] | Shop All;Animals
SD1167 Adorable Kittens | Shop All;Animals
SD1168 Lacy Pyramid Box | Shop All;Projects
SD1169 [NAME] blocks | Shop All;Quilt
SD1170 [NAME] | Shop All;Flowers
SD1171 Elegant Swans | Shop All;Birds:Flowers
SD1172 Cutwork Elegant Swans | Shop All;Birds
Spreadsheet: 745348d1629881654-budget-and-cash-flow-formula-test-repeat-fixed-cost
Sheet: josephteh

 |  |  |  |  |  | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Year | Total
Device | Acquisition Year | Product Lifetime | Cost |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
A | 2 | 3 | 999
B | 3 | 3 | 100
C | 4 | 1 | 200
D | 5 | 3 | 300
E | 5 | 1 | 400
 | Total
Spreadsheet: 0033f975-d9d9-40c0-82e1-9f498a4100e8
Sheet: Sheet1

Table S1: List of selected target genes. Red labels indicate up-regulation (+) and green labels genes are down-regulated (-). | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
gene | annotation | + | -
ABCA1 | ATP-binding cassette sub-family A member 1
ACCN1 | Amiloride-sensitive cation channel 1, neuronal
ADRBK2 | Beta-adrenergic receptor kinase 2
ANK3 | [NAME]
ANKRD26 | Ankyrin repeat domain-containing protein 26
ANXA2 | [NAME]
APLP1 | Amyloid-like protein 1
ARHGDIG | Rho GDP-dissociation inhibitor 3
ATP6V1G2 | V-type proton ATPase subunit G 2
BCAT1 | Branched-chain-amino-acid aminotransferase, cytosolic
BTG1 | Protein BTG1
CD163 | Scavenger receptor cysteine-rich type 1 protein M130
CDK2 | Cell division protein kinase 2
CDK4 | Cell division protein kinase 4
CDKN2D | Cyclin-dependent kinase 4 inhibitor D
CFI | Complement factor I
CHEK1 | Serine/threonine-protein kinase Chk1
CNIH4 | Protein cornichon homolog 4
CSDA | DNA-binding protein A
CTSK | Cathepsin K
CXCR4 | C-X-C chemokine receptor type 4
DOCK9 | Dedicator of cytokinesis protein 9
EGFR | Epidermal growth factor receptor
ETS1 | Protein C-ets-1
F2R | Proteinase-activated receptor 1
FLNA | Filamin-A
FN1 | Fibronectin
GABRA4 | Gamma-aminobutyric acid receptor subunit alpha-4
[NAME] | 1,4-alpha-glucan-branching enzyme
GBP1 | Interferon-induced guanylate-binding protein 1
GNS | N-acetylglucosamine-6-sulfatase
GOT1 | Aspartate aminotransferase, cytoplasmic
HEXB | Beta-hexosaminidase subunit beta
HMGB2 | High mobility group protein B2
HTR2A | 5-hydroxytryptamine receptor 2A
IGFBP2 | Insulin-like growth factor-binding protein 2
IGFBP3 | Insulin-like growth factor-binding protein 3
[NAME] | Laminin subunit gamma-1
LPL | [NAME] lipase
MAP1A | Microtubule-associated protein 1A
MCM3 | DNA replication licensing factor MCM3
MDK | Midkine
MMP2 | 72 [NAME] type IV collagenase
MSN | Moesin
NELL1 | Protein kinase C-binding protein NELL1
PCNA | Proliferating cell nuclear antigen
PEG3 | Paternally-expressed gene 3 protein
PLAU | Urokinase-type plasminogen activator
PLSCR1 | Phospholipid scramblase 1
PPP2R2C | Serine/threonine-protein phosphatase 2A 55 [NAME] regulatory subunit B gamma isoform
PRRX1 | Paired mesoderm homeobox protein 1
PTX3 | Pentraxin-related protein PTX3
RAB3A | Ras-related protein Rab-3A
RBBP8 | Retinoblastoma-binding protein 8
SHC1 | SHC-transforming protein 1
SHMT2 | Serine hydroxymethyltransferase, mitochondrial
SMC4 | Structural maintenance of chromosomes protein 4
SNAP91 | Clathrin coat assembly protein AP180
SNRPG | Small nuclear ribonucleoprotein G
SSTR1 | [NAME] receptor type 1
STMN1 | Stathmin
STXBP1 | Syntaxin-binding protein 1
SYNGR1 | Synaptogyrin-1
TCF3 | Transcription factor [NAME]
TGFB2 | Transforming growth factor beta-2
TNFRSF10B | Tumor necrosis factor receptor superfamily member 10B
TP53 | Cellular tumor antigen p53
TP53I3 | Quinone oxidoreductase PIG3
TPRKB | TP53RK-binding protein
TRIM22 | E3 ubiquitin-protein ligase TRIM22
TSPAN6 | Tetraspanin-6
UBE2C | Ubiquitin-conjugating enzyme [NAME]
VAMP2 | Vesicle-associated membrane protein 2
WEE1 | Wee1-like protein kinase
Spreadsheet: 71133d1271855836-display-date-by-monthly-by-monthly-and-quarterly-temp
Sheet: Sheet1

no of visit | start from date | 1st visit | 2nd visit | 3rd visit | 4th visit | 5th visit | 6th visit | 7th visit | 8th visit | 9th visit | 10th visit | 11th visit | 12th visit
12 | 2010-04-21 00:00:00 | 2010-04-21 00:00:00
6 | 2010-04-21 00:00:00 | 2010-04-21 00:00:00
4 | 2010-04-21 00:00:00 | 2010-04-21 00:00:00
our requirement : to display in above column as per below. If no of visit 12 then display in each month. If no of visit 6 then display by alternet month & if no of visit 4 then display date after three month gap. Please refer as per below.
no of visit | start from date | 1st visit | 2nd visit | 3rd visit | 4th visit | 5th visit | 6th visit | 7th visit | 8th visit | 9th visit | 10th visit | 11th visit | 12th visit
12 | 2010-04-21 00:00:00 | 2010-04-21 00:00:00 | 2010-05-21 00:00:00 | 2010-06-21 00:00:00 | 2010-07-21 00:00:00 | 2010-08-21 00:00:00 | 2010-09-21 00:00:00 | 2010-10-21 00:00:00 | 2010-11-21 00:00:00 | 2010-12-21 00:00:00 | 2011-01-21 00:00:00 | 2011-02-21 00:00:00 | 2011-03-21 00:00:00
6 | 2010-04-21 00:00:00 | 2010-04-21 00:00:00 |  | 2010-06-21 00:00:00 |  | 2010-08-21 00:00:00 |  | 2010-10-21 00:00:00 |  | 2010-12-21 00:00:00 |  | 2011-02-21 00:00:00
4 | 2010-04-21 00:00:00 | 2010-04-21 00:00:00 |  |  | 2010-07-21 00:00:00 |  |  | 2010-10-21 00:00:00 |  |  | 2011-01-21 00:00:00
Spreadsheet: 145822d1331754217-pivot-tables-combining-data-from-multiple-columns-excel-2003-combining-data_pt_jpr73
Sheet: PT

 |  |  |  |  |  |  | Pivot tables: Combining data from multiple columns (Excel 2003)
Classification 1 + 2 |  |  | Nombre de Classification | Classification
Type | Total |  | Type | Classification 1 | Classification 2 | Total général
Type A | 2 |  | Type A | 2 |  | 2
Type B | 5 |  | Type B | 4 | 1 | 5
Type C | 5 |  | Type C | 2 | 3 | 5
Type D | 2 |  | Type D | 1 | 1 | 2
Total général | 14 |  | Total général | 9 | 5 | 14
Spreadsheet: 51598d1251241690-countif-and-index-formula-bill
Sheet: TopSheet

MOVEMENT AREA | RATE | AMOUNT
JESSORE TO BOGRA | 3600*2+3700*1 | 10900
JESSORE TO CHITTAGONG | 4800*2 | 9600
JESSORE TO COX'S BAZAR | 9200*2 | 18400
JESSORE TO DINAJPUR | 4600*2+4800*1 | 14000
JESSORE TO KONABARI | 3200*1+4200*6+4600*2+4800*4 | 56800
JESSORE TO PABNA | 5200*1 | 5200
JESSORE TO RANGPUR | 4200*1 | 4200
Spreadsheet: 188828d1351002883-sorting-rows-on-different-tabs-by-date-task-20list-20-help-1-
Sheet: D

Due Date: | Client Name | Person Responsible | Task
2012-10-27 00:00:00 | D | person 1 | Task S
2012-10-28 00:00:00 | D | person 2 | Task T
2012-11-02 00:00:00 | D | person 3 | Task U
2012-11-05 00:00:00 | D | person 4 | Task V
2012-11-15 00:00:00 | D | person 5 | Task W
2012-11-20 00:00:00 | D | person 6 | Task X
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 122911 | 120605 | 50961 | 53638
2 | 145284 | 108474 | 50999 | 88318
3 | 146493 | 108474 | 50983 | 88239
4 |  | 118425 | 44619 | 78318
5 | 117229 | 79555 | 1308 | 38315
6 | 148819 | 84605 | 9713 | 73318
7 | 122857 | 114605 | 30005 | 38318
8 | 133339 | 105004 |  | 40816
9 | 142252 | 132998 | 38291 | 48318
10 | 141268 | 132998 | 40004 | 48318
11 | 129213 | 118196 | 37928 | 48177
12 | 125642 | 87865 | 221 | 37474
13 | 121855 | 53172 | 1 | 68265
14 | 117696 | 53077 |  | 63264
15 | 135340 | 93618 |  | 38265
16 | 128217 | 147738 | 28796 | 38318
17 | 126219 | 147012 | 29394 | 2
18 | 146791 | 144266 | 63511 | 56424
19 | 140377 | 71828 | 929 | 52111
20 | 113340 | 65289 |  | 31550
21 | 128641 | 90753 | 50700 | 90893
22 | 111337 | 109220 | 33652 | 38268
23 | 142907 | 141109 | 56005 | 52123
24 | 136849 | 141109 | 56974 | 52070
25 | 118088 | 141109 | 64579 | 42123
26 | 121544 | 134292 | 66570 | 54054
27 | 125284 | 135157 | 68751 | 58854
28
29
30
31
 |  |  |  | 2001-05-31 00:00:00 |  |  | 237513.04
 |  |  |  | 2001-06-27 00:00:00
Spreadsheet: 127421d1320341308-excel-2007-conditional-formatting-sushil-excel
Sheet: Sheet1

 |  |  |  |  | Name | out time | in time | Total
 |  |  |  |  | A | 11:00:00 | 12:00:00
 |  |  |  |  | B | 11:00:00 | 12:01:00
 |  |  |  |  | C | 11:00:00 | 12:10:00
 |  |  |  |  | D | 11:00:00 | 12:11:00
Spreadsheet: 784483d1655754999-headcount-of-employees-past-midnight-sample-excel
Sheet: Sheet1

 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  |  | Sunday | Monday
Date | 2016-11-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00
 | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out |  | 08:00:00
Employee 1 | 00:00:00 | 02:00:00 | 06:00:00 | 15:00:00 | 06:00:00 | 15:00:00 |  |  | 06:00:00 | 11:00:00 | 06:00:00 | 15:00:00 | 06:00:00 | 15:00:00 |  | 09:00:00
Employee 2 | 22:00:00 | 23:00:00 | 08:00:00 | 17:00:00 | 08:30:00 | 17:00:00 | 08:00:00 | 17:00:00 |  |  | 08:00:00 | 13:00:00 | 07:00:00 | 14:00:00 |  | 10:00:00
Employee 3 | 22:00:00 | 03:00:00 | 07:00:00 | 14:00:00 | 05:30:00 | 14:30:00 | 05:30:00 | 12:30:00 | 06:00:00 | 15:00:00 |  |  |  |  |  | 11:00:00
Employee 4 | 04:00:00 | 15:00:00 |  |  | 15:00:00 | 22:00:00 | 13:00:00 | 21:00:00 | 15:00:00 | 22:00:00 | 15:00:00 | 21:00:00 |  |  |  | 12:00:00
Employee 5 | 21:00:00 | 05:00:00 | 05:00:00 | 13:00:00 |  |  |  |  |  |  | 05:30:00 | 12:00:00 | 05:00:00 | 12:00:00 |  | 13:00:00
Employee 6 | 23:00:00 | 06:00:00 |  |  | 04:00:00 | 11:00:00 | 04:00:00 | 11:00:00 | 04:00:00 | 11:00:00 | 04:00:00 | 11:00:00 | 04:00:00 | 11:00:00 |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:00:00
Spreadsheet: 783347d1654746465-compare-entire-column-1-and-column-2-ignoring-same-rows-and-list-out-match-possible-options
Sheet: Method 2

Column 1 | Column 2 | Results Column |  | Duplicates removed, but apply filter to Column C to hide blanks
AAAA | AAAA
BBB | BBB
CCCC | DD
DD | GGGGG
DD
EEEE
FF
Spreadsheet: 47550d1246579162-use-one-instead-2-formulas-sample-666-
Sheet: Sheet1

value | group | % decrease | decreased value
140 | 1 | 5 | 133
132 | 1 | 5 | 125.4
124 | 1 | 5 | 117.8
116 | 2 | 2 | 113.68
108 | 2 | 2 | 105.84
100 | 2 | 2 | 98
92 | 2 | 2 | 90.16
Spreadsheet: 685682d1594139907-split-5-parameters-separated-by-and-into-series-of-columns-5-parameter-test
Sheet: Result

Product |  | 1.2 | 1.3 | 2.1 | 2.2 | 2.3 | 3.1 | 3.2 | 3.3 | 4.1 | 4.2 | 4.3 | 5.1 | 5.2 | 5.3
101 |  | 0219B | 0219C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
102 |  | 0220B | 0220C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
103 |  | 0221B | 0221C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
Spreadsheet: 810561d1671850577-skins-formula-for-a-golf-game-skins-problem
Sheet: Sheet1

 | Team | Player | Hole  1 | Hole  2 | Hole  3 | Hole  4 | Hole  5 | Hole  6 | Hole  7 | Hole  8 | Hole  9 | Hole  10 | Hole  11 | Hole  12 | Hole  13 | Hole  14 | Hole  15 | Hole  16 | Hole  17 | Hole  18 | Front | Back | Total | Front      6 | Middle 6 | Back      6 | Skins
 | A | a | 5 | 4 | 5 | 3 | 6 | 2 | 6 | 4 | 6 | 3 | 5 | 4 | 6 | 3 | 7 | 4 | 5 | 7 |  |  |  |  |  |  | 4 |  |  | Need a formula in AB3 down to AB28
 | A | b | 4 | 5 | 6 | 7 | 3 | 7 | 7 | 6 | 4 | 7 | 5 | 7 | 5 | 6 | 6 | 5 | 5 | 5 |  |  |  |  |  |  | 1 |  |  | Showing how many skins each player received.
 | K | c | 5 | 4 | 5 | 6 | 3 | 6 | 7 | 4 | 4 | 6 | 6 | 4 | 6 | 4 | 7 | 7 | 6 | 5 |  |  |  |  |  |  | 1 |  |  | I've manually put in the correct answers
 | K | d | 3 | 7 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 6 | 6 | 7 | 7 | 4 | 6 |  |  |  |  |  |  | 1
 | Q | e | 4 | 7 | 6 | 5 | 6 | 5 | 5 | 4 | 6 | 5 | 6 | 6 | 7 | 7 | 3 | 4 | 4 | 4 |  |  |  |  |  |  | 1 |  |  | I'd like a formula that doesn't need helper columns.
 | Q | f | 7 | 6 | 5 | 7 | 6 | 6 | 5 | 6 | 7 | 6 | 6 | 7 | 6 | 7 | 7 | 6 | 5 | 5
 | J | g | 4 | 6 | 5 | 7 | 7 | 4 | 2 | 5 | 4 | 7 | 6 | 6 | 4 | 4 | 7 | 6 | 5 | 7 |  |  |  |  |  |  | 1
 | J | h | 5 | 6 | 5 | 6 | 7 | 5 | 6 | 6 | 5 | 6 | 7 | 7 | 7 | 7 | 5 | 7 | 5 | 6
 | 10 | i | 5 | 5 | 5 | 6 | 4 | 5 | 5 | 7 | 5 | 6 | 6 | 4 | 5 | 4 | 6 | 6 | 5 | 4
 | 10 | J | 4 | 6 | 4 | 5 | 4 | 4 | 4 | 5 | 6 | 5 | 7 | 6 | 6 | 5 | 6 | 6 | 4 | 5
 | 9 | k | 5 | 6 | 5 | 5 | 7 | 6 | 4 | 5 | 5 | 5 | 4 | 6 | 4 | 5 | 7 | 6 | 4 | 7
 | 9 | l | 4 | 4 | 5 | 6 | 4 | 6 | 4 | 6 | 5 | 5 | 5 | 4 | 5 | 6 | 5 | 4 | 7 | 6
 | 8 | m | 5 | 4 | 4 | 6 | 6 | 6 | 4 | 5 | 5 | 6 | 3 | 6 | 5 | 4 | 4 | 3 | 5 | 5 |  |  |  |  |  |  | 2
 | 8 | n | 4 | 4 | 6 | 5 | 4 | 6 | 7 | 7 | 4 | 6 | 5 | 7 | 4 | 5 | 5 | 7 | 4 | 4
 | 7 | o | 4 | 6 | 7 | 5 | 6 | 7 | 7 | 5 | 7 | 5 | 5 | 5 | 7 | 6 | 7 | 6 | 6 | 5
 | 7 | p | 5 | 5 | 5 | 4 | 4 | 5 | 7 | 7 | 7 | 6 | 4 | 6 | 7 | 6 | 4 | 7 | 7 | 5
 | 6 | q | 7 | 5 | 7 | 6 | 6 | 4 | 5 | 7 | 4 | 5 | 4 | 7 | 4 | 7 | 6 | 7 | 6 | 5
 | 6 | r | 4 | 4 | 7 | 5 | 4 | 6 | 4 | 5 | 4 | 6 | 7 | 7 | 7 | 6 | 6 | 7 | 6 | 5
 | 5 | s | 4 | 6 | 6 | 7 | 4 | 4 | 4 | 4 | 5 | 7 | 5 | 7 | 4 | 5 | 4 | 7 | 6 | 4
 | 5 | t | 5 | 6 | 7 | 6 | 5 | 7 | 5 | 6 | 5 | 6 | 5 | 4 | 4 | 4 | 6 | 4 | 4 | 6
 | 4 | u | 5 | 5 | 5 | 7 | 6 | 7 | 4 | 6 | 5 | 4 | 6 | 5 | 4 | 4 | 4 | 5 | 5 | 3 |  |  |  |  |  |  | 2
 | 4 | v | 6 | 4 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 6 | 4 | 5 | 7 | 7 | 4 | 4 | 5 | 6
 | 3 | w | 5 | 5 | 6 | 6 | 7 | 7 | 6 | 7 | 4 | 5 | 4 | 5 | 7 | 7 | 7 | 5 | 4 | 4
 | 3 | x | 6 | 5 | 5 | 6 | 4 | 6 | 5 | 6 | 5 | 5 | 6 | 4 | 6 | 4 | 4 | 5 | 7 | 6
 | 2 | y | 6 | 6 | 4 | 4 | 6 | 7 | 7 | 7 | 7 | 6 | 6 | 4 | 4 | 7 | 6 | 7 | 5 | 4
 | 2 | z | 7 | 7 | 5 | 5 | 4 | 4 | 4 | 6 | 5 | 5 | 4 | 6 | 5 | 7 | 6 | 7 | 6 | 5
 |  | Min
 |  | Min Count |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | << Total Skins
Spreadsheet: 482955d1475389198-multipe-ifs-test
Sheet: Sheet1

 |  |  |  |  |  |  |  | [NAME] | Person Present
Names | Dept | designation | machine | Attendance |  |  |  |  | Manager | Operator
A | Stores | operator | A Build | Present |  |  |  | Store
B | Stores | manager | B Build | Present |  |  |  | A Build
C | Finance | manager | A Build | Present |  |  |  | B Build
D | Purchages | operator | B Build | Absent |  |  |  | Finance
E | Stores | operator | A Build | Absent |  |  |  | A Build
F | Security | operator | B Build | Present |  |  |  | B Build
G | Billing | manager | A Build | Present |  |  |  | Purchase
H | Security | manager | B Build | Present |  |  |  | A Build
I | Billing | operator | B Build | Absent |  |  |  | B Build
 |  |  |  |  |  |  |  | Security
 |  |  |  |  |  |  |  | A Build
 |  |  |  |  |  |  |  | B Build
 |  |  |  |  |  |  |  | Billing
 |  |  |  |  |  |  |  | A Build
 |  |  |  |  |  |  |  | B Build
 |  |  |  |  |  |  |  | Count the peoples present in following crieteria
Spreadsheet: 89d05a9b-1223-4583-8433-7bdbe0b30bcc
Sheet: Table 1.6

Monthly Statistical Bulletin
1.6 ANZ job advertisements
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Advertisements (a) (b) – number
July | 119602.026 | 164040.949 | 174177.705 | 157893.886 | 128577.156
August | 122698.551 | 168253.056 | 171901.307 | 155099.805 | 126399.44
September | 127560.375 | 171085.207 | 169377.382 | 149496.669 | 126853.137
October | 128231.868 | 174071.151 | 168671.767 | 143470.729 | 126785.969
November | 133544.566 | 177332.598 | 167892.328 | 140035.57 | 125657.153
December | 130585.919 | 183876.943 | 165858.395 | 137269.396 | 124786.497
January | 135067.288 | 179320.585 | 163639.078 | 136184.342
February | 150189.99 | 175513.403 | 166252.765 | 138525.643
March | 152614.348 | 177487.295 | 165553.191 | 137044.013
April | 153496.852 | 181159.449 | 164647.402 | 134406.9
May | 159440.1 | 168850.04 | 161318.585 | 131290.08
June | 162587.007 | 175246.239 | 159498.474 | 129545.183
Annual average | 139554.4291666667 | 174478.4541666667 | 166697.545625 | 141110.5453478077
Annual change (b) – per cent
July | -51.38366394639162 | 37.15566072434257 | 6.179405850669636 | -9.348968629481018 | -18.56736238666011
August | -47.86962699984478 | 37.12717438692493 | 2.168311878983042 | -9.773923359407622 | -18.50444944144191
September | -44.37295718887604 | 34.12096585636409 | -0.998230665261423 | -11.73752526178496 | -15.14651272932375
October | -41.35661587958944 | 35.74718493533917 | -3.1018258734901 | -14.94087507840005 | -11.62938260388988
November | -33.56126568953857 | 32.78907806701773 | -5.323482600756794 | -16.59203748726386 | -10.26768913069729
December | -30.60705441961244 | 40.80916564978189 | -9.799242746819003 | -17.23699243562557 | -9.093723265162472
January | -19.97915565335985 | 32.76388950668795 | -8.744956414234307 | -16.77761591885772
February | -1.552969723462348 | 16.86091929295688 | -5.276313855073494 | -16.67769074397048
March | 9.187236402183528 | 16.29790863438346 | -6.723920154397542 | -17.22055481250131
April | 16.42935740515799 | 18.02160542028574 | -9.114648499510501 | -18.36682609786944
May | 21.36102313550379 | 5.901865340024249 | -4.460440163354427 | -18.61441135254193
June | 33.97972344078526 | 7.786127706994439 | -8.986078725489802 | -18.77967246257164
Annual average | -23.05857364973484 | 25.02537913597214 | -4.459524001877132 | -15.34935633350737
(a) Average total number of newspaper and internet job advertisements per week.
(b) Monthly figures have been seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ANZ Banking Group, Job advertisements series |  |  |  |  |  |  |  | 2014-02-03 00:00:00
Spreadsheet: 772711d1647440349-need-help-with-lookup-values-between-tabs-book1-6-
Sheet: CCV68

 |  |  |  | CADDY INVENTORY CHECKLIST
 |  |  |  | CCV68 | DATE
FRONT CAB
ITEM |  | TAG NR | CHECKED | COMMENT
1 | TYRE PRESSURE MONITOR
2 | TABLET + CAR CHARGER
RIGGING |  | TAG NR
ITEM |  | TAG NR | CHECKED | COMMENT
1 | GENERATOR
2 | POWER WASHER
3 | VACUUM CLEANER
4 | HOSE REEL + HOSE
5 | HP GUN
6 | WATERTANK 1-3
7 | EXTENSION CORD 1
8 | EXTENSION CORD 2
9 | FIRE EXTINGUISHER
9 | STEPLADDER
WINDSCREEN KIT |  | TAG NR
ITEM |  | CHECKED | COMMENT
1 | W/S DRILL
2 | BRIDGE
3 | CURING LAMP
4 | W/S MIRROR
5 | GAS [NAME]
6 | SCRAPER
7 | DRILL BITS | QUANTITY:
8 | RESIN | QUANTITY:
POLISHER KIT
ITEM |  | TAG NR | CHECKED | COMMENT
1 | POLISHER A
2 | POLISHER B
3 | WHITE MOP | QUANTITY:
4 | BLACK MOP | QUANTITY:
5 | BLUE MOP | QUANTITY:
 |  | TAG NR | CHECKED | COMMENT
PDR LIGHT + STAND
PDR KIT |  | TAG NR
ITEM |  | CHECKED | COMMENT
1 | DENT PULLER | QUANTITY:
2 | SLIDING HAMMER | QUANTITY:
3 | GLUE GUN | QUANTITY:
4 | GLASS PLATE | QUANTITY:
5 | WINDOW WEDGE | QUANTITY:
6 | HAMMER | QUANTITY:
7 | PUNCH | QUANTITY:
8 | DENT TOOLS | QUANTITY:
9 | TOOL HANDLES | QUANTITY:
10 | [NAME] | QUANTITY:
11 | BONNET RING | QUANTITY:
12 | PLUGS LARGE | QUANTITY:
13 | PLUGS MEDIUM | QUANTITY:
14 | PLUGS SMALL | QUANTITY:
15 | GLUE STICKS | QUANTITY:
PAINT [NAME] |  | TAG NR
ITEM |  | CHECKED | COMMENT
PA SAMPLES
[NAME]
PC SAMPLES
PD SAMPLES
PE SAMPLES
PF [NAME]
PG SAMPLES
PH SAMPLES
TONER [NAME] |  | TAG NR
ITEM |  | CHECKED | COMMENT
M-TONER KIT
S - TONER KIT
**DECLERATION**
I HEREBY DECLARE THAT I HAVE PHYSICALLY CHECKED THE VEHICLE AND ALL EQUIPMENT BEFORE LEAVING THE
DEPOT. ALL DAMAGES AND DEFAULT HAVE BEEN REPORTED AND / FIXED. I TAKE FULL RESPONSIBILITY FOR THE
VEHICLE AND ALL EQUIPMENT.
 | NAME |  |  | SIGNATURE
 | VERIFIED BY MANAGER: |  | NAME
 | SIGNATURE: