tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 784409d1655724360-table-that-reports-the-percentage-of-y-or-blanks-in-a-column-example-sheet
Sheet: Tracker 

Date | PO | PO | Supplier/Contractor | Date PO/WO Sent | PO Receipted | Date Receipted/
 | Raised By | Requested By |  |  | Y | Checked
 |  |  |  |  | if applicable
2022-03-04 00:00:00 | AD | DSw | Supplier 1 | 2022-03-04 00:00:00
2022-03-04 00:00:00 | AD | TL | supplier 2 | 2022-03-04 00:00:00
2022-03-07 00:00:00 | AD | DSw | supplier 3 | 2022-03-09 00:00:00 | Y | 2022-04-12 00:00:00
2022-03-07 00:00:00 | HP | TL | supplier 4 | 2022-03-08 00:00:00 | Y | 2022-04-06 00:00:00
2022-03-07 00:00:00 | HP | DS | Supplier 1 | 2022-03-09 00:00:00
2022-03-07 00:00:00 | AD | TL | supplier 2 | 2022-03-08 00:00:00 | Y | 2022-04-08 00:00:00
2022-03-07 00:00:00 | HP | TL | Supplier 1 | 2022-03-08 00:00:00 | Y | 2022-04-06 00:00:00
2022-05-24 00:00:00 | HP | TL | supplier 2 | 2022-05-25 00:00:00
2022-05-24 00:00:00 | HP | TL | supplier 2 | 2022-05-25 00:00:00
2022-05-25 00:00:00 | HP | DSw | supplier 3 | 2022-05-25 00:00:00 | Y | 2022-06-06 00:00:00
2022-06-16 00:00:00 | AD | TL | supplier 2 | 2022-06-17 00:00:00
2022-06-17 00:00:00 | AD | DS | supplier 2 | 2022-06-20 00:00:00
2022-06-17 00:00:00 | AD | TL | Supplier 1 | 2022-06-17 00:00:00
2022-06-17 00:00:00 | AD | TL | supplier 2 | 2022-06-17 00:00:00 | Y | 2022-06-20 00:00:00
2022-06-17 00:00:00 | AD | GK | Supplier 1 | 2022-06-17 00:00:00
2022-06-17 00:00:00 | AD | TL | supplier 4 | 2022-06-17 00:00:00
Spreadsheet: 45ac31ee-bca9-4e26-a0d7-804bc74ff64a
Sheet: Sheet1

Table 3--Soybean oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning | Production | Imports | Total |  | Domestic |  |  | Exports | Total | Ending
October 1 | stocks |  |  |  |  | Total | Biodiesel | Food |  |  | stocks
 | Million pounds
2011/12 | 2425.347 | 19740 | 149.325 | 22314.672 |  | 18310.522 | 4874 | 13436.522 | 1464.15 | 19774.672 | 2540
2012/131 | 2540 | 19820 | 195.645 | 22555.645 |  | 18686.428 | 4617 | 14069.428 | 2164.217 | 20850.645 | 1705
2013/142 | 1705 | 19840 | 200 | 21745 |  | 18550 | 5200 | 13350 | 1450 | 20000 | 1745
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2014-02-12 09:15:16.300000
Spreadsheet: bc228119-c133-4ede-bda9-645cd4cc9ad9
Sheet: EPR CF

CONSOLIDATED STATEMENTS OF CASH FLOW ([NAME] and Condensed)
 | Six Months Ended
 | March 31,
 | 2012 |  | 2011
(In millions)
Operating
Net income | 111.1999999999999 |  | 143.3000000000001
Depreciation and amortization | 115.2 |  | 109.2
Other non-cash items | 42.1 |  | 39.59999999999999
Changes in operating assets and liabilities, excluding acquisitions:
Receivables | -28.5 |  | 3.8
Inventories | -14.6 |  | -6.2
Accounts payable and accrued liabilities | 3.8 |  | -35.4
Jackpot liabilities | -21.89999999999999 |  | -56.4
Income taxes | -13.8 |  | 47.7
Other assets and deferred costs | -16.8 |  | 18.1
Net operating cash flows | 176.6999999999999 |  | 263.7000000000002
Investing
Capital expenditures | -123.6 |  | -89.30000000000001
Jackpot annuity investments, net | 23.6 |  | 26.6
Changes in restricted cash | 3.2 |  | 23
Loans receivable, net | 14.9 |  | 14.3
Business/VIE acquisition/deconsolidation | -233 |  | 0
Other | 19.8 |  | 25.7
Net investing cash flows | -295.1 |  | 0.2999999999999829
Financing
Debt related proceeds (payments), net | 0 |  | -100
Employee stock plans | 14.3 |  | 16.7
Share repurchases | -50.1 |  | 0
Noncontrolling interest acquired | -2.5 |  | 0
Dividends paid | -35.7 |  | -35.8
Net financing cash flows | -74 |  | -119.1
Foreign exchange rates effect on cash | 3.5 |  | 2.6
Net change in cash and equivalents | -188.9000000000001 |  | 147.5000000000001
Beginning cash and equivalents | 460 |  | 158.4
Ending cash and equivalents | 271.0999999999999 |  | 305.9000000000001
Spreadsheet: 844867d1696511132-separated-multiple-column-data-separated-fill-in-multiple
Sheet: Sheet1

 | Data |  |  |  | need to separated |  |  |  | Target Result |  |  |  |  |  |  | separated one by one
 |  |  |  |  |  |  |  |  | still manual using choosecols to separated data column 1, 2, and 3
 | Text 1 |  |  |  |  | Text 5, 4 | Text 10, 12 |  |  | 1 | Text 5 | 4 | Text 10 | 12 |  |  | 1 |  | 4 |  | 12
 |  | Text 4 |  |  | Text 1, 2 | Text 4, 6 | Text 10, 13 |  | Text 1 | 2 | Text 4 | 6 | Text 10 | 13 |  | Text 1 | 2 | Text 4 | 6 | Text 10 | 13
 |  |  | Text 5 |  | Text 1, 3 | Text 4, 7 | Text 5, 5 |  | Text 1 | 3 | Text 4 | 7 | Text 5 | 5 |  | Text 1 | 3 | Text 4 | 7 | Text 5 | 5
 | Text 2 |  |  |  | Text 2, 1 | Text 4, 8 | Text 5, 6 |  | Text 2 | 1 | Text 4 | 8 | Text 5 | 6 |  | Text 2 | 1 | Text 4 | 8 | Text 5 | 6
 |  | subt |  |  | Text 2, 2 | Text 4, 9 | Text 5, 7 |  | Text 2 | 2 | Text 4 | 9 | Text 5 | 7 |  | Text 2 | 2 | Text 4 | 9 | Text 5 | 7
 |  |  |  |  | Text 2, 3 | Text 4, 10 | Text 5, 8 |  | Text 2 | 3 | Text 4 | 10 | Text 5 | 8 |  | Text 2 | 3 | Text 4 | 10 | Text 5 | 8
 | Text 3 |  | Text 1000 |  | Text 3, 1 | Text 4, 11 | Text 1000, 1 |  | Text 3 | 1 | Text 4 | 11 | Text 1000 | 1 |  | Text 3 | 1 | Text 4 | 11 | Text 1000 | 1
 |  | Text 10 |  |  | Text 3, 2 | Text 10, 1 | Text 1000, 2 |  | Text 3 | 2 | Text 10 | 1 | Text 1000 | 2 |  | Text 3 | 2 | Text 10 | 1 | Text 1000 | 2
 | subt |  |  |  | Text 3, 3 | Text 10, 2 | Text 1000, 3 |  | Text 3 | 3 | Text 10 | 2 | Text 1000 | 3 |  | Text 3 | 3 | Text 10 | 2 | Text 1000 | 3
 |  |  |  |  | Text 3, 4 | Text 10, 3 | Text 1000, 4 |  | Text 3 | 4 | Text 10 | 3 | Text 1000 | 4 |  | Text 3 | 4 | Text 10 | 3 | Text 1000 | 4
 | Text 4 |  |  |  | Text 4, 1 | Text 10, 4 | Text 1000, 5 |  | Text 4 | 1 | Text 10 | 4 | Text 1000 | 5 |  | Text 4 | 1 | Text 10 | 4 | Text 1000 | 5
 |  |  | Text 10 |  | Text 4, 2 | Text 10, 5 | Text 10, 14 |  | Text 4 | 2 | Text 10 | 5 | Text 10 | 14 |  | Text 4 | 2 | Text 10 | 5 | Text 10 | 14
 | subt |  |  |  | Text 4, 3 | Text 10, 6 | Text 10, 15 |  | Text 4 | 3 | Text 10 | 6 | Text 10 | 15 |  | Text 4 | 3 | Text 10 | 6 | Text 10 | 15
 |  |  |  |  | Text 4, 4 | Text 10, 7 | Text 10, 16 |  | Text 4 | 4 | Text 10 | 7 | Text 10 | 16 |  | Text 4 | 4 | Text 10 | 7 | Text 10 | 16
 |  |  |  |  | Text 4, 5 | Text 10, 8 | Text 10, 17 |  | Text 4 | 5 | Text 10 | 8 | Text 10 | 17 |  | Text 4 | 5 | Text 10 | 8 | Text 10 | 17
 | Text 5 |  |  |  | Text 5, 1 | Text 10, 9 | Text 10, 18 |  | Text 5 | 1 | Text 10 | 9 | Text 10 | 18 |  | Text 5 | 1 | Text 10 | 9 | Text 10 | 18
 |  |  |  |  | Text 5, 2 | Text 10, 10 | Text 10, 19 |  | Text 5 | 2 | Text 10 | 10 | Text 10 | 19 |  | Text 5 | 2 | Text 10 | 10 | Text 10 | 19
 |  |  |  |  | Text 5, 3 | Text 10, 11 | Text 10, 20 |  | Text 5 | 3 | Text 10 | 11 | Text 10 | 20 |  | Text 5 | 3 | Text 10 | 11 | Text 10 | 20
Spreadsheet: 0f1f7833-0537-44d1-a158-126a5c6b18b8
Sheet: T64

الجدول 64: مجموع الوفيات المسجلة  2000-2012
Table 64: Registered total deaths, 2000-2012
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | البلد
Bahrain | 2045 | 1979 | 2035 | 2114 | 2215 | 2222 | 2317 | 2270 | 2390 | 2387 | … | … | … | البحرين
Egypt | 404699 | 404531 | 424034 | 440149 | 440790 | 450646 | 451863 | 450596 | 461934 | 476592 |  | 493086 | 529252 | مصر
Iraq | 179928 | 77727 | 85758 | 95935 | 101820 | 115775 | 211757 | 137685 | 130257 | 117206 | 116688 | … | … | العراق
Jordan | 13339 | 16164 | 17220 | 16937 | 17011 | 17883 | 20397 | 20924 | 19403 | 20759 | 22662 | 22203 | 23301 | الأردن
Kuwait | 4227 | 4364 | 4342 | 4424 | 4793 | 4784 | 5247 | 5293 | 5701 | 6266 | 5448 | 5339 | … | الكويت
Lebanon | 19435 | 17568 | 17294 | 17187 | 17774 | 18012 | 18787 | 21092 | 21048 | 22260 | 22926 | 26070 | 23452 | لبنان
Libya | … | … | … | … | 15765 | 18425 | 17975 | 20044 | 21481 | … | … | … | … | ليبيا
Morocco | … | … | … | … | … | … | … | … | … | … | … | … | … | [NAME]
Oman | 2547 | 2550 | 2564 | 2701 | 2743 | 2849 | 5484 | 6810 | 7415 | 7101 | 7414 | 7667 | … | عمان
Palestine | 9041 | 9177 | 10316 | 10207 | 10029 | 9645 | 9938 | 10203 | 6184 | 6241 | 6209 | 6398 | … | فلسطين
Qatar | 1173 | 1210 | 1220 | 1311 | 1341 | 1545 | 1750 | 1776 | 1942 | 2008 | 1970 | 1949 | … | قطر
Saudi Arabia | 86291 | 87500 | 88728 | 89976 | 91243 | 92487 | 93752 | 95166 | 96641 | 98289 | … | ... | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | … | … | … | … | … | السودان
Syrian Arab Republic | 50116 | 52214 | 53252 | 53778 | 57855 | 61132 | 59671 | 64303 | 76060 | 76650 | 78495 | … | … | الجمهورية العربية السورية
Tunis | 53700 | 53200 | 56900 | 59800 | 59200 | 58700 | 57007 | … | … | 59500 | 60400 | 63258.2 | … | تونس
United Arab Emirates | 5396 | 5777 | 5994 | 6002 | 6123 | 6361 | 6483 | 7414 | 7755 | 7788 | 7414 | 7347 | … | الإمارات العربية المتحدة
Yemen | 18441 | 19868 | 21162 | 20346 | 22225 | 19653 | 20607 | 24449 | 30463 | 31914 | 28494 | 23662 | … | اليمن
Spreadsheet: 874824d1721328722-auto-fill-an-occurrence-of-numbers-from-2-columns-in-a-new-sheet-ref-occurance-sample
Sheet: Sheet1

 |  |  | Ref 1 | Ref 2 |  |  |  |  |  | How many times does Ref 1 occur | How many times does Ref 1 & 2 occur
 |  |  | 1 | 2 |  |  |  |  |  | 1 | 2
 |  |  | 2 | 3 |  |  |  |  |  | 0 | 4
 |  |  | 3 | 4 |  |  |  |  |  | 0 | 4
 |  |  | 4 | 6 |  |  |  |  |  | 2 | 2
 |  |  | 5 | 6
 |  |  | 6 | 7
 |  |  | 7 | 9
 |  |  | 8 | 9
 |  |  | 9 | 10
 |  |  | 10 | 16
 |  |  | 11 | 12
 |  |  | 12 | 13
 |  |  | 13 | 14
 |  |  | 14 | 15
 |  |  | 15 | 16
 |  |  | 16 | 18
 |  |  | 17 | 18
 |  |  | 18 | 19
 |  |  | 19 | 22
 |  |  | 20 | 21
 |  |  | 21 | 22
 |  |  | 22 | 25
 |  |  | 23 | 24
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-13-P-0006

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-13-P-0006 | 4504427469 | 4FC66 | 1F | 1 | 100 | 100 | 2012-10-26 00:00:00 | 2012-10-26 00:00:00 |  | 6392 | PAID | 5100141135 | 5000447661 | 2012-10-29 00:00:00 | 5000449127 | 2012-10-30 00:00:00 | 7689000 | 2012-11-01 00:00:00 | 0
W912LP-13-P-0006 |  |  |  | 2 | 200 |  |  |  |  |  | PAID
W912LP-13-P-0006 |  |  |  | 3 | 500 |  |  |  |  |  | PAID
W912LP-13-P-0006 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 8d31f6cb-50fc-466e-a249-8b90284bf666
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Job Application Log
 | Date Submitted: |  |  |  |  | Company:
 | In Person Meeting? |  |  |  |  | [NAME]? |  |  |  |  | Submit Application?
 | Hiring Mgr: |  |  |  |  | Phone: |  |  |  | [NAME]:
 |  | Followup 1: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 2: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 3: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 | Date Submitted: |  |  |  |  | Company:
 | In Person Meeting? |  |  |  |  | [NAME]? |  |  |  |  | Submit Application?
 | Hiring Mgr: |  |  |  |  | Phone: |  |  |  | [NAME]:
 |  | Followup 1: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 2: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 3: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 | Date Submitted: |  |  |  |  | Company:
 | In Person Meeting? |  |  |  |  | [NAME]? |  |  |  |  | Submit Application?
 | Hiring Mgr: |  |  |  |  | Phone: |  |  |  | [NAME]:
 |  | Followup 1: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 2: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 3: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 | Date Submitted: |  |  |  |  | Company:
 | In Person Meeting? |  |  |  |  | [NAME]? |  |  |  |  | Submit Application?
 | Hiring Mgr: |  |  |  |  | Phone: |  |  |  | [NAME]:
 |  | Followup 1: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 2: |  | Date: |  |  |  | Action Taken:
 |  | To do:
 |  | Followup 3: |  | Date: |  |  |  | Action Taken:
 |  | To do:
Spreadsheet: 76368cab-9da7-4b3f-8b73-d96d2ab99ac4
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40867450 | 2014-04-06 12:13:13 | AXIS | 1 | 6 | 5 | 358574 | sapap | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40867550 | 2014-04-06 12:25:36 | ALLIES | 0 | 3 | 6 | 358574 | sapap | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40873632 | 2014-04-06 19:56:35 | AXIS | 0 | 5 | 6 | 1490692 | Pedroas | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40873902 | 2014-04-06 20:16:16 | ALLIES | 0 | 5 | 6 | 1490692 | Pedroas | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40888381 | 2014-04-07 19:24:38 | AXIS | 1 | 6 | 1 | 697173 | Photios | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40888539 | 2014-04-07 19:40:40 | ALLIES | 0 | 4 | 6 | 697173 | Photios | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40917686 | 2014-04-09 20:22:44 | AXIS | 1 | 6 | 3 | 632845 | [NAME] du Sud | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40917994 | 2014-04-09 20:41:08 | ALLIES | 0 | 2 | 6 | 632845 | [NAME] du Sud | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40918476 | 2014-04-09 21:11:40 | AXIS | 0 | 3 | 6 | 225841 | sacas | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40918742 | 2014-04-09 21:28:55 | ALLIES | 1 | 6 | 3 | 225841 | sacas | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40931172 | 2014-04-10 20:16:23 | AXIS | 1 | 6 | 1 | 1515794 | Bodega28 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40931370 | 2014-04-10 20:41:02 | ALLIES | 1 | 6 | 4 | 1515794 | Bodega28 | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40931800 | 2014-04-10 21:11:05 | AXIS | 0 | 3 | 6 | 621298 | Augagneur | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40932203 | 2014-04-10 21:39:41 | ALLIES | 1 | 6 | 3 | 621298 | Augagneur | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40944227 | 2014-04-11 19:31:41 | AXIS | 0 | 5 | 6 | 1351406 | Montignac | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40944382 | 2014-04-11 19:47:16 | ALLIES | 0 | 2 | 6 | 1351406 | Montignac | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 831535d1685705014-really-weird-date-problem-example-file-1
Sheet: Sheet1

confirmed date | average | instruction |  |  |  |  | Month | Year | days to delivery
2022-07-04 00:00:00 | 9 | deliver |  |  |  |  | 5 | 2022
2023-04-21 00:00:00 | 28 | collect |  |  |  |  | 4 | 2022
2022-04-21 00:00:00 | 15 | deliver |  |  |  |  | 3 | 2022
2022-04-19 00:00:00 | 7 | collect
2022-04-19 00:00:00 | 6 | deliver
2022-04-07 00:00:00 | 6 | collect
2022-04-06 00:00:00 | 10 | deliver
2022-04-06 00:00:00 | 4 | collect
2022-04-06 00:00:00 | 10 | deliver
2022-04-06 00:00:00 | 15 | collect
2022-04-05 00:00:00 | 12 | deliver
2022-04-04 00:00:00 | 23 | collect
2022-04-04 00:00:00 | 4 | deliver
2022-03-30 00:00:00 | 14 | collect
2022-03-30 00:00:00 | 5 | deliver
2022-03-29 00:00:00 | 10 | collect
2022-03-29 00:00:00 | 10 | deliver
2022-03-28 00:00:00 | 10 | collect
2022-03-28 00:00:00 | 10 | deliver
2022-03-25 00:00:00 | 10 | collect
Spreadsheet: 682711d1592288080-sheet-generation-based-on-status-chemicals-sheet
Sheet: Sheet1

Data Sheet
Sr. No | Chemical | Constituent1 | Composition 1 | Constituent2 | Composition 2 | Constituent3 | Composition 3 | Constituent4 | Composition 4 | Constituent5 | Composition 5 | Composition | Status
1 | AAA | AAA1 | 0.1 | AAA2 | 0.15 | AAA3 | 0.35 | AAA4 | 0.2 | AAA5 | 0.2 |  | Active
2 | BBB | XXX1 | 0.6 | XXX2 | 0.25 | [NAME] | 0.15 |  |  |  |  |  | Active
3 | CCC | YYY1 | 1 |  |  |  |  |  |  |  |  |  | Inactive
4 | DDD | ZZZ1 | 0.5 | ZZZ2 | 0.5 |  |  |  |  |  |  | 0.5 | Active
Generated sheet based on ACTIVE status
Sr. No | Chemical | Constituents | Composition
1 | AAA | AAA1 | 0.1
 |  | AAA2 | 0.15
 |  | AAA3 | 0.35
 |  | AAA4 | 0.2
 |  | AAA5 | 0.2
2 | BBB | XXX1 | 0.6
 |  | XXX2 | 0.25
 |  | [NAME] | 0.15
3 | DDD | ZZZ1 | 0.5
 |  | ZZZ2 | 0.5
Spreadsheet: 882653d1731051474-have-saturday-dates-automatically-generate-by-month-and-adjust-for-number-of-weeks-ren77-pages-sample-2-spill-365-aligw
Sheet: Sheet1

2025
 | PAID $2.00 | PAID $2.00 | PAID $2.00 | PAID $2.00 |  |  |  | PAID $2.00 | PAID $2.00 | PAID $2.00 | PAID $2.00
DATE  W/ ENDING | 2025-01-04 00:00:00 |  |  |  |  |  | DATE  W/ ENDING
 | 2025-01-04 00:00:00 | 2025-01-11 00:00:00 | 2025-01-18 00:00:00 | 2025-01-25 00:00:00 |  |  | DATE W/ENDING | 2025-02-01 00:00:00 | 2025-02-08 00:00:00 | 2025-02-15 00:00:00 | 2025-02-22 00:00:00 |  |  | DATE W/ENDING | 2025-03-01 00:00:00 | 2025-03-08 00:00:00 | 2025-03-15 00:00:00 | 2025-03-22 00:00:00 | 2025-03-29 00:00:00 |  |  | DATE W/ENDING | 2025-04-05 00:00:00 | 2025-04-12 00:00:00 | 2025-04-19 00:00:00 | 2025-04-26 00:00:00 |  |  | DATE W/ENDING | 2025-05-03 00:00:00 | 2025-05-10 00:00:00 | 2025-05-17 00:00:00 | 2025-05-24 00:00:00 | 2025-05-31 00:00:00 |  |  | DATE W/ENDING | 2025-06-07 00:00:00 | 2025-06-14 00:00:00 | 2025-06-21 00:00:00 | 2025-06-28 00:00:00 |  |  | DATE W/ENDING | 2025-07-05 00:00:00 | 2025-07-12 00:00:00 | 2025-07-19 00:00:00 | 2025-07-26 00:00:00 |  |  | DATE W/ENDING | 2025-08-02 00:00:00 | 2025-08-09 00:00:00 | 2025-08-16 00:00:00 | 2025-08-23 00:00:00 | 2025-08-30 00:00:00 |  |  | DATE W/ENDING | 2025-09-06 00:00:00 | 2025-09-13 00:00:00 | 2025-09-20 00:00:00 | 2025-09-27 00:00:00 |  |  | DATE W/ENDING | 2025-10-04 00:00:00 | 2025-10-11 00:00:00 | 2025-10-18 00:00:00 | 2025-10-25 00:00:00 |  |  | DATE W/ENDING | 2025-11-01 00:00:00 | 2025-11-08 00:00:00 | 2025-11-15 00:00:00 | 2025-11-22 00:00:00 | 2025-11-29 00:00:00 |  |  | DATE W/ENDING | 2025-12-06 00:00:00 | 2025-12-13 00:00:00 | 2025-12-20 00:00:00 | 2025-12-27 00:00:00
Spreadsheet: 31439d1227272661-row-height-problem-11-28-08
Sheet: Nov 28A

PRICE CHOPPER         November 28 - December 2,  2008 |  | Nov 28- Dec 2
DELI  FINAL AD
ITEM | [NAME]
 | HORMEL PRESLICED DELI MEATS
FEATURE | "ALL NATURAL"
379610 | Hormel [NAME] Turkey Breast - presliced
380394 | Hormel Honey [NAME]-presliced
380485 | [NAME]-presliced
381996 | Hormel Roast Beef-presliced
382218 | Hormel Smoked Ham-presliced
382242 | Hormel Black Forest Ham-presliced
382879 | Hormel Honey Ham-presliced
 | T.P.R.'S
 | HONEY OR VIRGINIA HAM
596320 | [NAME]
596593 | [NAME]
 | CHICKEN WINGS ASST FLAVORS
423483 | [NAME]
423483 | Buffalo Wings
423483 | Bourbon Street Wings
423483 | Kung Pao Wings
 | DEVIED EGG POTATO SALAD
592055 | Deviled Egg Potato
 | YANCY FANCY FLAVORED CHEDDAR WEDGES
434738 | YF Peppadew [NAME]
434761 | [NAME] Wing Chddr Wedge
434795 | [NAME]
899385 | YF Champaign Cheddar Wedge
222380 | Mustard Potato Salad
222521 | Homestyle Potato Salad
222729 | Elbow Mac Salad
Spreadsheet: 702620d1604437190-analyzing-existing-combinations-school-example-essen-
Sheet: Sheet1

Existing Data |  |  |  | Desireed Output
Name | Course | Grade in GPA |  | Course build |  |  | # of Students | Collective GPA
[NAME] | History | 4 |  | History | Psychology | Math | 1 | 3.6666666667
[NAME] | History | 3 |  | Math | History |  | 2 | 3
[NAME] | Psychology | 4 |  | Psychology |  |  | 2 | 3
[NAME] | Math | 3
[NAME] | Math | 4
[NAME] | Math | 3
[NAME] | History | 2
Michelle | Psychology | 4
[NAME] | Psychology | 2
Spreadsheet: 4a456059-dbb8-4e16-a2f0-b844b5ff9899
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40832211 | 2014-04-04 04:00:04 | ALLIES | 0 | 6 | 7 | 67493 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40847824 | 2014-04-05 05:31:52 | AXIS | 1 | 6 | 5 | 192431 | Kain51 | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
40848043 | 2014-04-05 05:54:40 | ALLIES | 0 | 5 | 6 | 192431 | Kain51 | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
40923348 | 2014-04-10 05:00:46 | ALLIES | 1 | 7 | 6 | 558961 | jostaline | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40923639 | 2014-04-10 05:38:45 | AXIS | 1 | 7 | 5 | 558961 | jostaline | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40936000 | 2014-04-11 03:59:38 | ALLIES | 1 | 6 | 2 | 181733 | deepnet | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
40936447 | 2014-04-11 04:44:56 | AXIS | 1 | 6 | 4 | 181733 | deepnet | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
40973742 | 2014-04-13 18:48:38 | AXIS | 0 | 3 | 7 | 335648 | Buidheo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40974205 | 2014-04-13 19:11:11 | ALLIES | 0 | 3 | 7 | 335648 | Buidheo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 718697d1613305382-count-function-for-dates-month-and-year-and-text-count-date-and-text-eg3
Sheet: Sheet1

Example
[NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Date Raised | Status | Classification | Target Date | Closure Date | No of Events Raised
2021-01-01 00:00:00 | Open | Minor | 2021-02-14 00:00:00 |  | Events Open
2021-01-05 00:00:00 | Closed | Major | 2021-02-13 00:00:00 | 2021-05-10 00:00:00 | Events Closed
2021-02-10 00:00:00 | In-Progress | Major | 2021-05-01 00:00:00 |  | Minor
2021-04-15 00:00:00 | Open | Major | 2021-01-21 00:00:00 |  | Major | 1
2020-01-21 00:00:00 | Open | Minor | 2021-07-04 00:00:00 |  | Overdue | 2 | 2
2021-01-31 00:00:00 | Closed | Major | 2021-01-23 00:00:00
2021-07-14 00:00:00 | Open | Major | 2021-04-23 00:00:00
2021-01-03 00:00:00 | open | Minor | 2021-02-07 00:00:00
2021-01-05 00:00:00 | open | Major | 2021-01-19 00:00:00 | 2021-02-13 00:00:00
 |  |  |  |  | Using the previous concept of searching for open event per month as per formula in G5, I also need to add count how many overdues are highlighted per month from the conditional formatting applied in Column D.  Formula required in G9 respectively for each month.
Spreadsheet: 847446d1698366144-possible-sumif-s-or-dynamic-range-question-sample-v2-thenoisydrum-
Sheet: Hidden Data

 |  |  |  | Hierarchy Account | Hierarchy Name | Customer Class | Brand | Jan-23 | Feb-23 | Mar-23
 |  |  |  | 10001 | [NAME] | Direct | Brand A | 25 | 25 | 20
 |  |  |  | 10001 | [NAME] | Direct | Brand C | 25 | 20 | 40
 |  |  |  | 10002 | [NAME] | Indirect | Brand A | 20 | 40 | 60
 |  |  |  | 10002 | [NAME] | Indirect | Brand C | 50 | 40 | 60
 |  |  |  | 10002 | [NAME] | Indirect | Brand B | 50 | 70 | 60
 |  |  |  | 10003 | [NAME] | Indirect | Brand C | 35 | 35 | 30
 |  |  |  | 10004 | [NAME] | Direct | Brand B | 400 | 380 | 350
 |  |  |  | 10005 | [NAME] | Direct | Brand C | 35 | 30 | 45
 |  |  |  | 10005 | [NAME] | Direct | Brand B | 35 | 50 | 45
Spreadsheet: 53745d1253657547-compare-two-cells-in-a-row-with-criteria-count-rows-that-match-criteria-countmp
Sheet: Summary

Summary
EP Category
Matching EP's | 4
MP's to EP's | 5
P's to EP's | 3
MP Category
Matching MP's | 6
MP's to EP's | 0
P's to mP's | 4
P Category
P to P | 3
MP to P | 6
Blank to P | 4