tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 760881d1640507386-need-help-with-countif-function-sample
Sheet: Sheet6

Team 1-1 |  |  |  | Team 1-2 |  |  |  | Team 1-3 |  |  |  |  | Position | Days - TW | Evenings - TW | In Office | Grand Total
Name | UserID | Position | Shift | Name | UserID | Position | Shift | Name | UserID | Position | Shift |  | Manager-01
[NAME] (B) | userid1 | Manager-02 | Days - TW | Maki | userid10 | Manager-02 | Days - TW | Giovanni | userid20 | Manager-03 | SL |  | Manager-02
Andi (B) | userid2 | A/L05(P) | Days - TW | [NAME] | userid11 | A/L05(P) | Days - TW | [NAME] | userid21 | L05(P) | Days - TW |  | Manager-03
Dimitra | userid3 | L04(P) | Days - TW | Rupinderjit | userid12 | L03(P) | Days - TW | Eva | userid22 | L03(T) | Days - TW |  | A/L04(P)
Destiny | userid4 | L04(P) | Days - TW | Nicole (B) | userid13 | L03(P) | Days - TW | Eve (B) | userid23 | [NAME]) | Days - TW |  | A/L05(P)
[NAME] (B) | userid5 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L01(T)
Quinn | userid6 | L04(P) | On Loan |  |  |  |  |  |  |  |  |  | [NAME])
[NAME] | userid7 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L03(P)
[NAME] | userid8 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L03(T)
Alysia | userid9 | L04(P) | Days - TW |  |  |  |  |  |  |  |  |  | L04(P)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  | L05(P)
Team 2-1 |  |  |  | Team 2-2 |  |  |  | Team 2-3 |  |  |  |  | TOTAL
Name | UserID | Position | Shift | Name | UserID | Position | Shift | Name | UserID | Position | Shift
[NAME] | userid14 | Manager-01 | Evenings - TW | Gummy | userid24 | Manager-02 | Evenings - TW | Grace | user31 | Manager-03 | In Office |  | Status | Days | Night | Grand Total
Phylis | userid15 | L03(T) | Evenings - TW | [NAME] | userid25 | A/L04(P) | Evenings - TW |  |  |  |  |  | Days - TW | 15 | 0
Ayo | userid16 | L03(T) | Evenings - TW | Sweety | userid30 | L01(T) | Evenings - TW |  |  |  |  |  | Evenings - TW | 0 | 10
[NAME] (B) | userid17 | L03(T) | SL | Rhea | userid26 | L03(P) | Evenings - TW |  |  |  |  |  | VL | 0 | 0
Peace | userid18 | L03(T) | Evenings - TW | [NAME] | userid28 | L03(P) | SL |  |  |  |  |  | SL | 1 | 2
Marichu | userid19 | L03(T) | Evenings - TW | Corrine (B) | userid27 | [NAME]) | Evenings - TW |  |  |  |  |  | On Loan | 1 | 1
 |  |  |  | Anna | userid29 | [NAME]) | On Loan |  |  |  |  |  | In Office | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  | Bilingual | 6 | 1
(B) Bilingual
Spreadsheet: 43119d1241710392-formula-w-arrays-05-may-2009-imc-cash-download
Sheet: Download

Date | Bank Name | Bank # | Account Name | Account # | Type | Description | Bank Ref | Cust Ref | Amount
Apr 27, 2009 |  |  |  |  | Outgoing Money Transfer | Transaction Ref. No.:090427010383ORG=D/[PHONE] ABC CORPORATE C/O XYZ CORP FINA NCIAL RESOURCE CTR 1234 W ABCDEFG ST ABCDEF 12345 NY 12345 OBI=CDA FUNDING OF TODAY SRF=CDA117000700 0016 BNF=D/051:[PHONE] [NAME] C or PO BOX 123 [PHONE], DC 12345-1234 | 1 |  | -23948.17
Apr 27, 2009 |  |  |  |  | Outgoing Money Transfer | Transaction Ref. No.:090427010381ORG=D/[PHONE] ABC CORPORATE C/O XYZ CORP FINA NCIAL RESOURCE CTR 1234 W ABCDEFG ST ABCDEF 12345 NY 12345 OBI=CDA CMC INC SRF= CDA1170007000014 BNF=D/051:[PHONE] ABC CO Main St | 1 |  | -76085.87
Apr 27, 2009 |  |  |  |  | Outgoing Money Transfer | Transaction Ref. No.:090427010382ORG=D/[PHONE] ABC CORPORATE C/O XYZ CORP FINA NCIAL RESOURCE CTR 1234 W ABCDEFG ST ABCDEF 12345 NY 12345 OBI=CDA ENID SRF=CDA11700 07000015 BNF=D/051:[PHONE] 1234567 INCORPORAT ED 1 abcdef drive 1234567 park, pa | 1 |  | -274071.67
Apr 28, 2009 |  |  |  |  | Outgoing Money Transfer | Transaction Ref. No.:090428008432ORG=D/[PHONE] ABC CORPORATE C/O XYZ CORP FINA NCIAL RESOURCE CTR 1234 W ABCDEFG ST ABCDEF 12345 NY 12345 OBI=CDA FUNDING OF TODAY SRF=CDA118000400 0018 BNF=D/051:[PHONE] [NAME] C or PO BOX 123 [PHONE], DC 12345-1234 | 1 |  | -1843.02
Apr 28, 2009 |  |  |  |  | Outgoing Money Transfer | Transaction Ref. No.:090428008430ORG=D/[PHONE] ABC CORPORATE C/O XYZ CORP FINA NCIAL RESOURCE CTR 1234 W ABCDEFG ST ABCDEF 12345 NY 12345 OBI=CDA CMC INC SRF= CDA1180004000016 BNF=D/051:[PHONE] ABC CO Main St | 1 |  | -21818.81
Apr 28, 2009 |  |  |  |  | Outgoing Money Transfer | Transaction Ref. No.:090428008431ORG=D/[PHONE] ABC CORPORATE C/O XYZ CORP FINA NCIAL RESOURCE CTR 1234 W ABCDEFG ST ABCDEF 12345 NY 12345 OBI=CDA ENID SRF=CDA11800 04000017 BNF=D/051:[PHONE] 1234567 INCORPORAT ED 1 abcdef drive 1234567 park, pa | 1 |  | -486848.11
Spreadsheet: 79756d1279935750-mix-up-letters-totals
Sheet: Sheet1

 |  |  |  |  |  | Randomized |  | Values | Key
 |  |  |  |  |  |  |  | Total1
 |  |  |  |  |  |  |  | Total2
 |  |  |  |  |  |  |  | Total3
 |  |  |  |  |  |  |  | Total4
 |  |  |  |  |  |  |  | Total5
 |  |  |  |  |  |  |  | Total6
 |  |  |  |  |  |  |  | Total7
 |  |  |  |  |  |  |  | Total8
 |  |  |  |  |  |  |  | Total9
 |  |  |  |  |  |  |  | Total10
 |  |  |  |  |  |  |  | Total11
 |  |  |  |  |  |  |  | Total12
 |  |  |  |  |  |  |  | Total13
 |  |  |  |  |  |  |  | Total14
 |  |  |  |  |  |  |  | Total15
 |  |  |  |  |  | Each time you press F9, the values
 |  |  |  |  |  | in column G will randomize
Spreadsheet: harry_arora__12146__Staffing Report 12-8-2000
Sheet: YTD Summary

YTD Summary
# of Resumes Sent to Managers
# of Candidates Interviewed by Managers
# of Offers |  |  |  | 669
# of Offers Declined |  |  |  | 43
Acceptance Rate
# of Starts
 |  |  |  | fulltime | 394
 |  |  |  | conversion
 |  |  |  | internal transfer
 |  |  |  | contractor | 457
 |  |  |  | interns | 10
# of Positions Opened in 2000
 |  |  |  | addition
 |  |  |  | replacement
# of Positions Cancelled in 2000
Lowest # of Openings since Jan 1, 2000 |  |  |  | 62
Highest # of Openings since Jan 1, 2000 |  |  |  | 161
Ratios: | Submittals to Interviews |  |  | 2.6 to 1
 | Interviews to Hires |  |  | 3.1 to 1
Agency Fees Paid
Referral Fees Paid |  |  |  | 367000
Savings Thru Enron Recruiters
Savings Thru Employee Referral Program |  |  |  | 1119440
Spreadsheet: 741685d1627277145-how-to-countif-formulas-with-time-example
Sheet: Lookup Tables

POSITIONS | SHIFT START AND FINISH STANDARD HOURS |  | SHIFT TIMES REQUIRED VARIANCES TO OPENING/CLOSING TIMES |  |  |  |  | AWARD RATES as at | dd-mmm-yy |  | Minimum Hrs for Lunch Count
 | Start (24-hour format) | Finish (24-hour format) | Start (hh:[NAME]) | Start details | End (hh:[NAME]) | End details |  | POSITION | HOURLY RATE |  | Level | Est | Actual
FOH Manager |  |  | 02:00:00 | Before External Doors | 01:30:00 | Post Show |  | FOH Manager | 150 |  | External Doors - Arena Plaza
Supervisor [NAME] |  |  | 01:30:00 | Before External Doors | 01:00:00 | Post Show |  | Supervisor | 85 |  | External Doors - Main Foyer
Supervisor [NAME] |  |  | 01:30:00 | Before External Doors | 02:00:00 | Post Door |  | Usher | 48 |  | Arena Floor
Supervisor [NAME] |  |  | 01:30:00 | Before External Doors | 01:00:00 | Post Show |  | Customer Service | 48 |  | Level 1
Event Correspondent |  |  | 01:30:00 | Before External Doors | 01:00:00 | Post Show |  | Event Correspondent | 85 |  | Level 2
Usher |  |  | 01:00:00 | Before External Doors | 00:45:00 | Post Show |  | Warden | 85 |  | Level 3
Usher - Warden |  |  | 01:00:00 | Before External Doors | 00:45:00 | Post Show |  |  |  |  | Level 4
Usher - Warden Suite |  |  | 01:00:00 | Before External Doors | 01:00:00 | Post Show |  |  |  |  | Total
Usher - Suites |  |  | 01:00:00 | Before External Doors | 01:00:00 | Post Show
Usher - Early |  |  | 01:00:00 | Before External Doors | 04:00:00 | Post Shift Start
Usher - GA Floor |  |  | 02:30:00 | Before External Doors | 03:00:00 | Post Door
Usher - GA Floor Early |  |  | 02:30:00 | Before External Doors | 05:00:00 | Post Shift Start
Usher - GA Wristbanders |  |  | 02:30:00 | Before External Doors | 03:00:00 | Post Door
Usher - Staff Entry |  |  | 05:00:00 | Before External Doors | 06:00:00 | Post Shift Start
Customer Service |  |  | 01:00:00 | Before External Doors | 01:00:00 | Post Show
 |  |  |  |  |  |  |  |  |  |  | COUNTIF('GL - EXT DOORS - MAIN FOYER'!F21:F38,">6:00")+COUNTIF('GL - EXT DOORS - MAIN FOYER'!F15:F16,">6:00")
Spreadsheet: kate_symes__18414__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.79 | 3584
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
 | 2000-12-16 00:00:00 |  | 233.65 | 12880 | 192.27 | 2704 | 130.23 | 922 | 120.83 | 60
 | 2000-12-15 00:00:00 |  | 238.8 | 13024 | 192.27 | 2704 | 180.19 | 1670 | 128.18 | 706
 | 2000-12-14 00:00:00 |  | 334.66 | 15184 | 213.55 | 2480 | 200 | 150 | 174.54 | 271
 | 2000-12-13 00:00:00 |  | 495.62 | 14992 | 223.93 | 4504 | 276 | 3139 | 184.69 | 2161
 | 2000-12-12 00:00:00 |  | 330 | 9200 | 211.98 | 2688 | 347.7 | 2622 | 193.04 | 1826
 | 2000-12-11 00:00:00 |  | 414.56 | 9200 | 213.96 | 2480 | 204.38 | 2263 | 187.04 | 1280
 | 2000-12-10 00:00:00 |  | 254.96 | 2160 | 217.63 | 2280 | 180.88 | 1906 | 161.34 | 780 |  | 172.02 | 600
 | 2000-12-09 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 189.51 | 1364 | 138.71 | 403
 | 2000-12-08 00:00:00 |  | 317.74 | 14000 | 176.98 | 2608 | 290.86 | 1368 | 205.28 | 799
 | 2000-12-07 00:00:00 |  | 262.73 | 15808 | 174.55 | 2816 | 241.93 | 1455 | 118.5 | 865
 | 2000-12-06 00:00:00 |  | 250.5 | 23472 | 154.65 | 3232 | 283.47 | 2363 | 157.27 | 595
 | 2000-12-05 00:00:00 |  | 227.52 | 24992 | 101.29 | 3072 | 232.74 | 2743 | 129.08 | 673
 | 2000-12-04 00:00:00 |  | 190.1 | 29792 | 122.57 | 3880 | 162.07 | 2138 | 113.27 | 707
Spreadsheet: f6c233ef-0717-4eb3-91cd-6713743a9a01
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120566 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Tobacco Use Prevention (Regions A and D)
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2013 |  |  | FY 2014
 | General Fund
 | [NAME]. Grants Fund |  |  |  | 12781 |  |  | 0
 | Enterprise
 |  |  | Total: | $ | 12781 |  |  | 0
 | This ordinance will increase revenue in the amount of $12,781.00 in the Tobacco Use Prevention
 | account of the Governmental Grants Fund to match revenue.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2013 |  |  | FY 2014
 | General Fund
 | [NAME] |  |  |  | 4430
 | Enterprise/Other
 |  |  | Total: | $ | 4430 |  | $ | 0
 | This ordinance will increase appropriations in the amount of $4,430.00 in the Tobacco Use Prevention
 | account of the Governmental Grants Fund to match revenue.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 38911d1237114891-graph-align-data-point-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | series3 | series2 | series1 | k
 |  |  |  |  |  |  |  |  |  |  |  | 0.389 | 0 | 1.128 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 0.473 | 0.004 | 1.132 | 51
 |  |  |  |  |  |  |  |  |  |  |  | 0.498 | 0.006 | 1.172 | 101
 |  |  |  |  |  |  |  |  |  |  |  | 0.535 | 0.008 | 1.165 | 151
 |  |  |  |  |  |  |  |  |  |  |  | 0.551 | 0.01 | 1.193 | 201
 |  |  |  |  |  |  |  |  |  |  |  | 0.578 | 0.012 | 1.185 | 251
 |  |  |  |  |  |  |  |  |  |  |  | 0.627 | 0.014 | 1.205 | 301
 |  |  |  |  |  |  |  |  |  |  |  | 0.644 | 0.016 | 1.22 | 351
 |  |  |  |  |  |  |  |  |  |  |  | 0.641 | 0.017 | 1.227 | 401
 |  |  |  |  |  |  |  |  |  |  |  | 0.652 | 0.019 | 1.23 | 451
 |  |  |  |  |  |  |  |  |  |  |  | 0.636 | 0.02 | 1.252 | 501
Spreadsheet: 169666d1343017019-conditional-formatting-based-on-distance-from-median-value-excel-2010-conditional-format-based-on-median
Sheet: sheet1

DIRECT | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | Weekly Total
 | 0.6956 | 0.8811 | 0.865 | 0.9637 | 0.8594 | 1 | 0.9863 | 0.8568
 | 0.4619 | 0.8321 | 0.6803 | 0.9386 | 0.6488 | 0.9105 | 0.8755 | 0.7134
 | 0.5 | 1 | 1 | 1 | 1 |  | 0.5 | 0.7778
 | 0.8 | 0.5714 | 0.75 | 0.75 | 1 | 1 | 0.5 | 0.72
 | 0.6739 | 0.8205 | 0.8587 | 0.9302 | 0.8906 | 0.963 | 1 | 0.8443
 | 0.4575 | 0.8015 | 0.7332 | 0.9461 | 0.6862 | 0.965 | 0.928 | 0.7459
 | 0.5 | 0.9 | 0.8148 | 1 | 0.7647 | 1 | 1 | 0.84
 | 0.4236 | 0.7802 | 0.6076 | 0.9286 | 0.6529 | 1 | 0.9524 | 0.6866
 | 0.4218 | 0.8002 | 0.6155 | 0.9566 | 0.6514 | 0.985 | 0.9648 | 0.6974
 | 0.7048 | 0.8135 | 0.7986 | 0.9744 | 0.8819 | 0.9737 | 0.9048 | 0.83
 | 0.4369 | 0.8365 | 0.6612 | 0.9228 | 0.4801 | 0.8434 | 0.8986 | 0.6777
 | 0.4565 | 0.7895 | 0.675 | 0.9737 | 0.6279 | 1 | 1 | 0.7112
 | 0.3529 | 1 | 0.8 | 0.9583 | 0.8889 | 1 |  | 0.8173
Median
Spreadsheet: 759711d1639673183-sum-column-based-on-mutiple-criteria-of-other-coulmns-sample-excel-before-and-after-copy-tms
Sheet: Sheet2

Policy Number | Status | Pay Status | Premium | Payor Name
00123456 | NA | 5 | 40 | [NAME]
00123457 | NI | 7 | 21.99 | [NAME] |  |  |  |  |  |  | AP is active
00123458 | NA | 5 | 32 | [NAME] | 72 | 36 |  |  |  |  | NA is a new po
00123459 | AP | 5 | 47.86 | [NAME] |  |  |  |  |  |  | NI is Not active
00123460 | NA | 5 | 44.44 | [NAME] | 92.3 | 46.15 |  |  |  |  | 5 is payroll deduction (which is what we need)
00123461 | AP | 7 | 23.12 | [NAME] |  | Not included in total because PO is AP 7, person pays this policy. |  |  |  |  | 7 is bank draft
00123462 | AP | 5 | 80.67 | [NAME] |  |  |  |  |  |  | 0 is check payment.
00123463 | AP | 5 | 34.87 | [NAME] |  |  |  |  |  |  |  |  | We only care about AP, NA and . We would only have a total for those.
00123464 | NA | 5 | 88.79 | [NAME] | 204.33 | 102.156
00123465 | NI | 7 | 99.2 | [NAME] |  | Do not total because policy is an NI and 7, meaning it is not active.
00123466 | NA | 5 | 25.99 | [NAME]
00123467 | NA | 5 | 7.98 | [NAME] | 33.97 | 16.985
00123468 | NA | 7 | 6.55 | [NAME] |  | Not included.
00123469 | NA | 0 | 8.77 | [NAME] |  | Not included.
00123470 | NI | 7 | 7.98 | [NAME] |  | Not included.
00123471 | NA | 5 | 7.98 | April Ludgate
00123472 | NA | 5 | 8 | April Ludgate | 15.98 | 7.99
00123473 | AP | 5 | 45.77 | [NAME]
00123474 | AP | 5 | 77.32 | [NAME]
00123475 | AP | 5 | 67.98 | [NAME] | 191.07 | 95.53
00123476 | AP | 5 | 91.01 | [NAME]
00123477 | AP | 5 | 44.56 | [NAME]
00123478 | NI | 0 | 39.9 | [NAME]
00123479 | AP | 5 | 70.93 | [NAME] | 246.4 | 123.2
00123480 | AP | 5 | 61.31 | [NAME]
00123481 | AP | 5 | 7.36 | [NAME]
00123482 | NA | 5 | 55.9 | [NAME] | 128.57 | 64.29
Spreadsheet: louise_kitchen__23031__Rankings
Sheet: Sheet1

 |  |  | Risk Management |  | Must Keep |  |  | Operational Analysis |  | Must Keep
 | 1 | Kam | Keiser | West | * | 1 | [NAME] | Valdes | Operational Analysis | *
 |  | Errol | McLaughlin | Financial | * |  | Kathy | Sprowles | Operational Analysis | *
 |  | [NAME] | Jones | Financial | * |  | Melba | [NAME] | Operational Analysis
 |  | [NAME] | Love | East | * |  | Micheal | Castillo | Operational Analysis
 |  | Oneil | [NAME] | Texas | * |  | [NAME] | [NAME] | Operational Analysis
 |  | Scott | Palmer | Central | * |  | Greg | Mausser | Operational Analysis
 |  | [NAME] | Royed | East | * |  | Theresa | Toward | Operational Analysis
 |  | Anna | [NAME] | Central
 |  | [NAME] | Loibl | Financial | * |  |  | Systems
 |  | [NAME] | [NAME] | East |  | 1 | Russ | Severson | Systems | *
 |  | [NAME] | Bhatia | West |  |  | Greg | Couch | Systems
 |  | [NAME] | Orourke | West |  |  | George | Grant | Systems
 |  | [NAME] | [NAME] | Financial |  |  | Glory | Chi | Systems
 |  | [NAME] | Mills | East
 |  | Derek | Bailey | Financial
 |  | [NAME] | Clause | East
 |  | Chance | Rabon | Texas | *
 |  | [NAME] | Hungerford | East
 |  | Luchas | [NAME] | Central
 |  | Kulvinder | Fowler | Central
 |  | [NAME] | [NAME] | East
 |  | [NAME] | Worthing | West
 |  | Monte | Jones | West
 |  | [NAME] | Hopkins | Central
 |  | [NAME] | Parish | Benchmark | *
 |  | [NAME] | Cavazos | Financial
 |  | [NAME] | Thibault | Financial
 |  | [NAME] | Ryder | Texas
 |  | Scott | Tackitt | Central
 |  | Carol | [NAME] | West
 |  | Jad | Doan | Central
 |  | [NAME] | [NAME] | East
 |  | Michelle | [NAME] | Financial
 |  | Billiana | Pelinova | West
 |  | [NAME] | Underwood | Benchmark
 |  | [NAME] | Olney | Financial
 |  | [NAME] | Vargas | Financial
 |  | [NAME] | Yeboah | Texas
 |  | Sean | Riordan | East
 |  | Michelle | Akers | Central
 |  | Anne | Bike | West
 |  | Kimat | Singla | East
Spreadsheet: 33f5fa2a-a5b6-4e26-a9d6-47ba38feda31
Sheet: Sheet1

Table 7--U.S. textile exports, by fiber | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Nov. | Dec. | Jan. |  | Jan.
Item | 2013 | 2013 | 2014 |  | 2013
 | 1,000 pounds 1/
[NAME], thread, and fabric: | 234443.163 | 195765.193 | 227584.451 |  | 222045.978
Cotton | 125634.285 | 103392.346 | 118466.107 |  | 117057.553
Linen | 6802.099 | 5309.652 | 6653.291 |  | 6127.057
Wool | 3151.976 | 2211.282 | 3270.647 |  | 2271.756
Silk | 1054.711 | 995.084 | 1256.043 |  | 994.378
Manmade | 97800.092 | 83856.829 | 97938.363 |  | 95595.234
Apparel: | 28499.066 | 25194.752 | 24546.062 |  | 24653.719
Cotton | 12353.874 | 10899.662 | 11254.734 |  | 10788.375
Linen | 576.915 | 565.099 | 483.629 |  | 401.518
Wool | 1686.456 | 1522.871 | 1148.216 |  | 1271.716
Silk | 1146.683 | 1068.292 | 888.114 |  | 1127.073
Manmade | 12735.138 | 11138.828 | 10771.369 |  | 11065.037
Home furnishings: | 5467.071 | 4468.781 | 4334.188999999999 |  | 4376.311
Cotton | 2656.204 | 2066.741 | 2297.334 |  | 2140.089
Linen | 269.962 | 237.585 | 159.502 |  | 216.373
Wool | 171.619 | 141.973 | 96.734 |  | 157.312
Silk | 141.711 | 131.081 | 76.602 |  | 147.514
Manmade | 2227.575 | 1891.401 | 1704.017 |  | 1715.023
Floor coverings: | 34983.579 | 32597.768 | 27848.269 |  | 28954.466
Cotton | 2790.837 | 2937.501 | 1921.082 |  | 1985.339
Linen | 1463.912 | 1630.601 | 906.63 |  | 972.227
Wool | 3616.268 | 2913.138 | 2065.331 |  | 2882.906
Silk | 36.683 | 34.013 | 20.136 |  | 17.464
Manmade | 27075.879 | 25082.515 | 22935.09 |  | 23096.53
Total exports: 2/ | 303498.823 | 258092.626 | 284431.864 | 0 | 280137.87
Cotton | 143518.454 | 119314.652 | 134029.045 |  | 132055.015
Linen | 9112.889 | 7742.937 | 8203.052 |  | 7717.176
Wool | 8630.192 | 6794.179 | 6586.393 |  | 6585.414
Silk | 2380.07 | 2228.47 | 2240.895 |  | 2286.428
Manmade | 139857.218 | 122012.388 | 133372.479 |  | 131493.837
1/ Raw-fiber equivalent.  2/ Includes headgear.
Sources: USDA, Economic Research Service; and
U.S. Dept. of Commerce, U.S. Census Bureau.
Last update:  3/12/14.
Spreadsheet: 90364d1290100071-formula-to-count-weekdays-only-excluding-holidays-too-calendartesting9
Sheet: HOLIDAYS

New Year's Day
[NAME]
Presidents' Day
Good Friday
Easter
Memorial Day
Independence Day
Labor Day
Columbus Day
Thanksgiving Day
Christmas Day
Spreadsheet: 885274d1734730351-filter-lists-for-forum
Sheet: Account Pivot

 | Account Pivot
Sum of NW Value (Amount)
Date | Tag | Chq # | NW Description (Who) | Notes 1 | Notes 2 | Total
2025-01-01 00:00:00 | ITClubV1 | N | Club Systems SaaS (Club V1) Q1 | (blank) | (blank) | -778.5
2025-04-01 00:00:00 | ITClubV1 | N | Club Systems SaaS (Club V1) Q2 | (blank) | (blank) | -667.5
2025-07-01 00:00:00 | ITClubV1 | N | Club Systems SaaS (Club V1) Q3 | (blank) | (blank) | -778.5
2025-10-01 00:00:00 | ITClubV1 | N | Club Systems SaaS (Club V1) Q4 | (blank) | (blank) | -667.5
(blank) | (blank) | (blank) | (blank) | (blank) | (blank)
Grand Total |  |  |  |  |  | -2892
If you use Notes 1 to filter there are values there that are not in the Account tab?
Spreadsheet: 756113d1637277503-turn-a-count-formula-into-a-spilled-array-formula-book1
Sheet: Test Example

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 |  | COUNT(IF(AND(Table13[@[Column 2]:[Column 7]]=""),1,""))
x | x
 | x |  | x
 | x | x | x
 | x | x
 | x | x