tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 582824d1532072769-ongoing-differences-every-thursday
Sheet: Sheet1

Date | Index | weekday |  | Wanted result:
2018-05-31 00:00:00 | 1512.44
2018-05-30 00:00:00 | 1511.69
2018-05-29 00:00:00 | 1524.27
2018-05-28 00:00:00 | 1528.07
2018-05-27 00:00:00 | 1516.32
2018-05-24 00:00:00 | 1511.5
2018-05-23 00:00:00 | 1519.95
2018-05-22 00:00:00 | 1528.22
2018-05-21 00:00:00 | 1516.37
2018-05-17 00:00:00 | 1502.42 |  |  | etc
2018-05-16 00:00:00 | 1491.85
2018-05-15 00:00:00 | 1487.04
2018-05-14 00:00:00 | 1485.21
2018-05-13 00:00:00 | 1472.19
2018-05-10 00:00:00 | 1469.98 |  |  | etc
2018-05-09 00:00:00 | 1464.42
2018-05-08 00:00:00 | 1474.74
2018-05-07 00:00:00 | 1476.13
2018-05-06 00:00:00 | 1468.91
2018-05-03 00:00:00 | 1476.2
2018-05-02 00:00:00 | 1463.83
2018-05-01 00:00:00 | 1465.24
2018-04-30 00:00:00 | 1473.96
2018-04-29 00:00:00 | 1466.89
2018-04-26 00:00:00 | 1459.83
2018-04-25 00:00:00 | 1480.7
2018-04-24 00:00:00 | 1480.67
2018-04-23 00:00:00 | 1491.82
2018-04-22 00:00:00 | 1484.42
2018-04-17 00:00:00 | 1476.26
2018-04-16 00:00:00 | 1471.43
2018-04-15 00:00:00 | 1461.65
2018-04-12 00:00:00 | 1439.44
2018-04-11 00:00:00 | 1441.07
2018-04-10 00:00:00 | 1418.91
2018-04-09 00:00:00 | 1416.93
2018-04-08 00:00:00 | 1391.67
2018-04-04 00:00:00 | 1423.86
2018-04-03 00:00:00 | 1431.07
2018-04-02 00:00:00 | 1440.09
2018-04-01 00:00:00 | 1436.22
2018-03-29 00:00:00 | 1434.43
2018-03-28 00:00:00 | 1448.5
2018-03-27 00:00:00 | 1438.36
2018-03-26 00:00:00 | 1427.67
2018-03-25 00:00:00 | 1470.44
2018-03-22 00:00:00 | 1483.42
2018-03-21 00:00:00 | 1488.24
Spreadsheet: 880434d1728164557-index-match-needs-one-more-qualifier-test-sheet
Sheet: AR

 |  |  |  |  |  |  | Total Patient | Total Patient
Patient Name | [NAME] | Active/Inactive | Secondary Ins | Copay/Coins/Ded | Agreed Amt/Visit | Pay Pref | Responsibility | Paid | Amt Due | Status | Aging | Last Invoiced | Column1 | Notes
BuffettJimmy | Open |  |  |  | 20 |  |  |  |  |  |  | 2024-10-04 00:00:00 | Inv/CC
CrowCheryl
White = Ongoing; Yellow = Waiting patient response; Green = Need action
Spreadsheet: 172077d1343980349-percentile-formula-help-scoring
Sheet: Sheet1

CATEGORY 1 |  | CATEGORY 2 |  | CATEGORY 3 |  | CATEGORY 4
Score | 0.25 | Score | 0.25 | Score | 0.25 | Score | 0.25 |  | Total
50 |  | 100 |  | 56 |  | 59
Rating | Score | Score | Score | Score
Poor  (0% score) |  |  |  | 0
Fair  (10% - 50%)
Good (50% - 80%) |  |  | 0.5
Excellent  (80% - 100%) |  | 0.8
Outstanding  (100% - 120%) | 1.2
Total score | 0.25
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 26 Jan 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-01-26 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: mary_fischer__25625__1290
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 1290
ANALYSIS OF RESERVE ITEMS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 649236d1573550455-lookup-closest-subsequent-date-ehf_3
Sheet: Sheet3

Table 1 |  |  |  |  | Table 2
Name | Value | Output |  |  | Name | Value
[NAME] | 2019-11-01 00:00:00 | 2019-11-02 00:00:00 |  |  | [NAME] | 2019-07-01 00:00:00
[NAME] | 2019-10-01 00:00:00 | 2019-12-01 00:00:00 |  |  | [NAME] | 2019-10-31 00:00:00
Ian | 2019-09-25 00:00:00 | 2019-10-30 00:00:00 |  |  | [NAME] | 2019-11-02 00:00:00
[NAME] | 2019-10-07 00:00:00 | #N/A |  |  | [NAME] | 2019-12-01 00:00:00
[NAME] | 2019-11-08 00:00:00 | #N/A |  |  | Ian | 2019-09-20 00:00:00
 |  |  |  |  | Ian | 2019-10-30 00:00:00
 |  |  |  |  | Ian | 2019-12-15 00:00:00
 |  |  |  |  | [NAME] | 2019-09-07 00:00:00
 |  |  |  |  | [NAME] | 2019-10-07 00:00:00
 |  |  |  |  | [NAME] | 2019-11-07 00:00:00
Spreadsheet: ea3d8d8e-46f6-440d-b01c-f40e63d065a6
Sheet: Flight 5

 | SINGLES | FLIGHT "5"
 |  |  | [NAME] (Merrimack)
 |  |  |  | Sheikh (M)
 |  |  | BYE
 | Bagi (SH) |  | Umur Serin (Bryant) |  | Serin (bry)
 |  |  |  |  | 6-1, 6-2
 |  | Bagi (SH) |  | Serin (SH)
 |  |  | [NAME] ([NAME]) | 6-1, 6-2
[NAME] (QU) |  |  |  |  |  | Leelavanich (BU) 6-2, 6-3
2013-08-01 00:00:00 |  |  | [NAME] (Hartford)
 |  | [NAME] (Hart) |  | Goldstein (UC)
 |  |  | Parker Goldstein (UCONN) | 6-3, 6-4
 | [NAME] (QU) |  | [NAME] (Quinnipiac) |  | Leelavanich (BU)
 | 2013-08-06 00:00:00 |  |  |  | 6-3, 6-1
 |  | [NAME] (QU) |  | Leelavanich (BU)
 |  |  | [NAME] (Boston) | 6-0, 6-2
 | Sunday 9:00am | Saturday 1:00pm | Friday 2:30pm | Saturday 1:00pm | Sunday 9:00am
 | UCONN | UCONN | UCONN | UCONN | UCONN
 |  |  | Quarter Finals | Semi Finals | Finals
Spreadsheet: 812208d1673015656-find-result-between-two-dates-based-on-multiple-criteria-find-result-between-two-dates-based-on-multiple-criteria
Sheet: Feuil1

ID | leave | Return | Type |  | ID | 2023-02-01 00:00:00 | 2023-02-02 00:00:00 | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | 2023-02-05 00:00:00 | 2023-02-06 00:00:00 | 2023-02-07 00:00:00 | 2023-02-08 00:00:00 | 2023-02-09 00:00:00 | 2023-02-10 00:00:00 | 2023-02-11 00:00:00 | 2023-02-12 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-15 00:00:00 | 2023-02-16 00:00:00 | 2023-02-17 00:00:00 | 2023-02-18 00:00:00 | 2023-02-19 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-22 00:00:00 | 2023-02-23 00:00:00 | 2023-02-24 00:00:00 | 2023-02-25 00:00:00 | 2023-02-26 00:00:00 | 2023-02-27 00:00:00 | 2023-02-28 00:00:00 | 2023-03-01 00:00:00 | 2023-03-02 00:00:00
E001 | 2023-02-01 00:00:00 | 2023-02-15 00:00:00 | LO |  | E001
E002 | 2023-02-06 00:00:00 | 2023-02-10 00:00:00 | LO |  | E002
E001 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | MI |  | E003
E002 | 2023-02-18 00:00:00 | 2023-02-28 00:00:00 | MI |  | E004
Spreadsheet: f4490d6d-b08a-44e4-8a82-2dbfac8a5be2
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120681 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Approving and authorizing settlement of a claim entitled The Cashew,
 | Claim File No. T1011-1244
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | X | No |  |  | 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 2012-13 |  |  | FY 2013-14
 | General Fund
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2012-13 |  |  | FY 2013-14
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
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: 684252d1593223729-auto-update-data-forum1
Sheet: DATA

Date | Time | A PARTY | b party | a party name | b party name
2020-01-02 00:00:00 | 11:01:50 | 455123123 | 455123144
2020-01-02 00:00:00 | 11:20:10 | 455123123 | 455123145
2020-01-03 00:00:00 | 11:38:30 | 455123123 | 455123146
2020-01-04 00:00:00 | 11:56:50 | 455123123 | 455123147
2020-01-05 00:00:00 | 12:15:10 | 455123123 | 455123148
2020-01-06 00:00:00 | 12:33:30 | 455123123 | 455123149
2020-01-07 00:00:00 | 12:51:50 | 455123123 | 455123150
2020-01-08 00:00:00 | 13:10:10 | 456123456 | 455123123
2020-01-09 00:00:00 | 13:28:30 | 456123457 | 455123123
2020-01-10 00:00:00 | 13:46:50 | 456123458 | 455123123
2020-01-11 00:00:00 | 14:05:10 | 456123459 | 455123123
2020-01-12 00:00:00 | 14:23:30 | 456123460 | 455123123
2020-01-13 00:00:00 | 14:41:50 | 456123461 | 455123123
2020-01-14 00:00:00 | 15:00:10 | 456123462 | 455123123
Spreadsheet: 770921d1646336171-help-with-royalty-scale-calculation-royalty
Sheet: 2018

 |  |  |  |  |  |  |  |  | 2018
article | EAN | Publishing date | retail price | net retail price | Title | Original title | Series | printed copies | sold copies | gross turnover at net retail price HUF | royalty up to 6000 copies: 8% on gross turnover HUF | royalty up to 6000 copies: 8% on gross turnover EUR | royalty up to 12.000 copies: 10% on gross turnover HUF | royalty up to 12.000 copies: 10% on gross turnover EUR | royalty thereafter: 12% on gross turnover HUF | royalty thereafter: 12% on gross turnover EUR | royalty total HUF | royalty total EUR | royalty advance paid | royalty to be paid
 |  |  | 1699 |  | title 1 |  |  | 4996 | 3507 |  |  |  |  |  |  |  |  |  | 1200
 |  |  | 1699 |  | title 2 |  |  | 7100 | 4994 |  |  |  |  |  |  |  |  |  | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018 Total:
2018 | exchange rate (EUR/HUF): |  |  | 318.8547325102883
 |  |  |  |  |  |  |  |  |  | Sales | Marginal Rate |  | HUF | EUR
 |  |  |  |  |  |  |  |  |  | 0 | 0.08
 |  |  |  |  |  |  |  |  |  | 6001 | 0.02
 |  |  |  |  |  |  |  |  |  | 12001 | 0.02
Spreadsheet: 237561d1369247401-advice-please-need-to-track-devices-issue-and-dates-deviceserviceregister-sample-ddev
Sheet: Monthly Status Summary

MONTHLY SUMMARY BY DATE BY STATUS
Yr_Mth | 2013.05
Date | Status | Dept_No | Dept_Name | Contact_Name | Contact_TelNo | Device_No | Device_Name | Date_Purchd | Age_in_Mths
2013-05-01 00:00:00 | 1-Logged | 1 | [NAME] | A Aardvark | 225557858 | 1 | HP Laser Printer | 2011-01-15 00:00:00 | 27.9
 |  | 3 | Marketing | C Calloway | 225557878 | 3 | Dell Laptop | 2011-05-06 00:00:00 | 24.2
 |  | 5 | Support | E Earnest | 225557898 | 5 | Compaq Desktop PC | 2009-06-14 00:00:00 | 47.23333333333333
 | 2-In Progress | 1 | [NAME] | A Aardvark | 225557858 | 1 | HP Laser Printer | 2011-01-15 00:00:00 | 27.9
 |  | 3 | Marketing | C Calloway | 225557878 | 3 | Dell Laptop | 2011-05-06 00:00:00 | 24.2
 | 3-Resolved | 1 | [NAME] | A Aardvark | 225557858 | 1 | HP Laser Printer | 2011-01-15 00:00:00 | 27.9
 | 4-Scrapped | 5 | Support | E Earnest | 225557898 | 5 | Compaq Desktop PC | 2009-06-14 00:00:00 | 47.23333333333333
2013-05-02 00:00:00 | 3-Resolved | 3 | Marketing | C Calloway | 225557878 | 3 | Dell Laptop | 2011-05-06 00:00:00 | 24.23333333333333
Spreadsheet: 119343d1314336395-how-do-i-sort-this-data-accurately-without-having-to-change-any-values-abousetta
Sheet: Sheet1

 | 2007-BIT-20 | 2007-BIT-020
 | 2007-BIT-44 | 2007-BIT-044
 | 2007-BIT-63 | 2007-BIT-063
 | 2008-BIT-1 | 2008-BIT-001
 | 2008-BIT-2 | 2008-BIT-002
 | 2008-BIT-11 | 2008-BIT-011
 | 2008-BIT-18 | 2008-BIT-018
 | 2008-BIT-25 | 2008-BIT-025
 | 2008-BIT-27 | 2008-BIT-027
 | 2008-BIT-42 | 2008-BIT-042
 | 2008-BIT-46 | 2008-BIT-046
 | 2008-BIT-55 | 2008-BIT-055
 | 2008-BIT-58 | 2008-BIT-058
 | 2008-BIT-61 | 2008-BIT-061
 | 2008-BIT-63 | 2008-BIT-063
 | 2008-BIT-64 | 2008-BIT-064
 | 2008-BIT-71 | 2008-BIT-071
 | 2008-BIT-76 | 2008-BIT-076
 | 2008-BIT-77 | 2008-BIT-077
 | 2008-BIT-92 | 2008-BIT-092
 | 2008-BIT-98 | 2008-BIT-098
 | 2008-BIT-98 | 2008-BIT-098
 | 2008-BIT-103 | 2008-BIT-103
 | 2008-BIT-110 | 2008-BIT-110
 | 2008-BIT-115 | 2008-BIT-115
 | 2008-BIT-117 | 2008-BIT-117
 | 2008-BIT-121 | 2008-BIT-121
 | 2008-BIT-125 | 2008-BIT-125
 | 2008-BIT-129 | 2008-BIT-129
 | 2008-BIT-134 | 2008-BIT-134
 | 2008-BIT-137 | 2008-BIT-137
 | 2008-BIT-141 | 2008-BIT-141
 | 2008-BIT-149 | 2008-BIT-149
 | 2008-BIT-155 | 2008-BIT-155
 | 2008-BIT-162 | 2008-BIT-162
Spreadsheet: 881489d1729560550-how-to-select-data-in-chart-for-certain-columns-only-24-10-22-portfolio-excel
Sheet: New PORT

Accurate as of 04-February-2024
S/N | Source | USD | Annualized Return | % of Portfolio | LT Interest % | Monthly Interest | Category | Region | Duration | Risk | Remarks | Links
1 | test |  | 1.6 |  | 0.11 |  | Options | US | Long | High
 | test source 2 | 29400 | 0.05 |  | 0.055 |  | Dividends | China | Long | Medium
2 | test source 3 |  |  |  |  |  | Options | US | Medium | High
3 | test source 4 |  | 2 |  | 0.1 |  | Crypto | US | Medium | V High
4 | test source 5 | 54814 | 0.025 |  | 0.025 |  |  | China | Long | Zero
5 | test source 6 | 266557 | 0.04 |  | 0.04 |  |  | China | Long | Zero
6 | test source 7 | 71500 | 0.04 |  | 0.04 |  |  | China | Long | Zero
7 | test source 8 | 18077 | 0.018 |  | 0.018 |  | Cash | China | Immediate | Zero
9 | test source 9 | 47582 |  |  | 0.02 |  | Cash | China | Immediate | Zero
10 | test source 10 | 20184 | 0.04 |  | 0.0348 |  | Cash | China | Immediate | Zero
11 | test source 11 | 32018 | 0.1 |  | 0.08 |  |  | HK | Long | Medium
 | test source 12 |  | 0.0603 |  | 0.0587 |  |  | China | Long | Medium
12 | test source 13 | 32129 | 0.09 |  | 0.016 |  |  | World | Long | Low
13 | test source 14 | 47371 | 0.09 |  | 0.0094 |  |  | US | Long | Low
14 | test source 15 | 24743 | 0.09 |  | 0.016 |  |  | World | Long | Low
 | test source 16 | 303.5 | 0.09 |  | 0.016 |  |  | World | Long | Low
15 | test source 17 | 30000 | 0.03 |  | 0.03 |  | Endowment | China | Long | Low
16 | test source 18 | -5000 |  |  |  |  | Options | China | Short | Zero
17 | test source 19 |  |  |  |  |  | Property | China | Long | Zero
 | Total
 | Preferred Monthly Retirement Income | 8000
 | Safe Withdrawal Rate (3% is Extremely Conservative) | 0.04
 | FIRE Amount Required
Total Portfolio Progress |  | 1000
Date | Hundred K (Update Here) | Portfolio | Net Change | % Change (MTM) | % Change (YTD)
2020-12-29 00:00:00 | 921
2021-01-21 00:00:00 | 1060
2021-04-14 00:00:00 | 1160
2021-07-04 00:00:00 | 1140
2021-09-06 00:00:00 | 1290
2021-10-17 00:00:00 | 1313
2021-10-20 00:00:00 | 1388
2021-10-25 00:00:00
2021-10-26 00:00:00 | 1430
 | 452k at 4 Feb
 | [NAME] at 2 Aug
 | 536k at 23 Aug
 | 539k at 2 Sep
 | 550k at 16 Oct
 | [NAME] at 20 Dec
 | 550k at 31 Dec
 | 558k at 9 Feb 2020
 | 604k
 | 633k at 17-May-20
 | 663k at 11-Jun-2020
 | 664k at 11-Jul-2020
 | 727k at 01-Aug-2020
 | [NAME] at 29-Aug-2020
 | 827k at 23-Nov-2020
 | 856k at 29-Nov-2020
 | 921k at 29-Dec-2020
 | 1.06M at 21-Jan-2021-01-21 (includes HDB from this point)
 | 1.16M at 14-Apr-2021
 | 06-Feb-2021 Transferred USD58.1K from IBKR to Crypto
 | 1.14M at 04-July-2021
 | 1.29M at 06-September-2021
 | Sources of income
1 | Work Salary
2 | Rental
3 | Dividends / Interest from CPF and Endowus Funds
4 | Options Active Income
5 | [NAME]
6 | Amazon Active to Passive Income
Spreadsheet: 840730d1692942508-formula-to-create-list-based-on-filter-test-97-aligw
Sheet: Times

Day Time | Times
Monday 09:00 to 12:00 | 3
Tuesday 09:00 to 12:00 | 3
Wednesday 09:00 to 12:00 | 3
Thursday 09:00 to 12:00 | 3
Friday 09:00 to 12:00 | 3
Monday 12:00 to 15:00 | 3
Tuesday 12:00 to 15:00 | 3
Wednesday 12:00 to 15:00 | 3
Thursday 12:00 to 15:00 | 3
Friday 12:00 to 15:00 | 3
Monday 14:30 to 15:30 | 3
Saturday 09:00 to 15:00 | 6
Tuesday 18:30 to 20:30 | 2
Thursday 19:00 to 22:00 | 3
Spreadsheet: 833107d1686791209-if-statement-with-multiple-conditions-result-is-inconsistent-look-up-with-multiple-if-condition
Sheet: Data

Part No. | Closing Stock | TTL
P04538 | 99061.53 | 908.62
P07694-21A | 8000 | 842.2
P20554-01 | 0 | 0
L05302 | 7200 | 730
Condition:
 | IF B2 is not zero in Data tab, [NAME] (only first 6 digit if lookup data only has 6 digit)
 | from the element tab, match and look at the highest number from B column
 | if A2 has decimal - like P07694-21A in B3 Data tab and B3 has more than zero match it to the Element Tab
 | exactly as is - result is 842.20
 | Another condition will be if we could not match A5 from the element tab column A - substitute that Look up value A5
 | from Other Source tab column B then match it with the Element Tab column A and pick the highest number in column B
 | also with the condition if B5 in Data tab is not zero
Spreadsheet: 174002d1344882581-how-to-move-rounddown-amount-to-a-new-cell-book2
Sheet: Sheet1

Balance | Daily % | Earnings | I Want the Change to round off to a new cell to add up | Change |  |  |  | Round | Balance (whole) | Change
10000 | 0.0095 |  | 0.00----------------------------------------------------------------> | 0
 | 0.0095 |  | When it reaches a whole number it puts it into the Balance | 0.9
 | 0.0095 |  | 0.81---------------------------->  <--------------------------- 1.00 | 1.71 | 0.71 change left to biuld
 | 0.0195 |  | 0.61---------------------------->  <---------------------------1.00 | 1.32 | 0.32 change left to biuld
 | 0.0195 |  | 0.52---------------------------------------------------------------> | 0.84
 | 0.0195 |  | 0.51--------------------------->   <---------------------------1.00 | 1.35 | 0.35 change left to biuld
 | 0.0195
 | 0.0095 |  | I need the Balabce to always be whole numbers
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
 | 0.0095
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0195
 | 0.0095
 | 0.0095
Spreadsheet: 746736d1630992996-sumifs-with-list-of-criteria-or-range-consist-of-criteria-book1
Sheet: Sheet1

 |  |  |  |  | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00
 | 2021-08-12 00:00:00 | A | 10
 | 2021-08-12 00:00:00 | B | 10
 | 2021-08-12 00:00:00 | C | 10
 | 2021-08-12 00:00:00 | B | 10 |  | Criteria List
 | 2021-08-12 00:00:00 | A | 10 |  | A
 | 2021-09-20 00:00:00 | A | 10 |  | C
 | 2021-09-30 00:00:00 | B | 10
 | 2021-09-06 00:00:00 | C | 10
Spreadsheet: 145634d1331668559-isolate-duplicates-in-column-b-if-column-a-also-duplicate-cf-count-if
Sheet: Sheet1

Style | Size
1001 | small | 1001small
1001 | medium | 1001medium
1001 | large | 1001large
1002 | small | 1002small
1002 | small | 1002small
1002 | small | 1002small
1003 | small | 1003small
1003 | medium | 1003medium
1003 | large | 1003large
1004 | medium | 1004medium
1004 | medium | 1004medium
1004 | medium | 1004medium
1934 | large | 1934large
1934 | large | 1934large
Spreadsheet: 164152d1340660626-need-to-find-column-matches-and-total-values-from-corresponding-rows-rowmatch
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yield
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  | CC | PG |  | FTR |  | 6.25
 |  |  |  |  |  |  |  | CC | PG |  | FTR |  | 3.5
 |  |  |  |  |  |  |  | CC | PG |  | FTR |  | 1.6667
 |  |  |  |  |  |  |  | SN | FN |  | FTR |  | 1.83
 |  |  |  |  |  |  |  | SN | FN |  | FTR |  | 3.5
 |  |  |  |  |  |  |  | SN | FN |  | FTR |  | 5.17
 |  |  |  |  |  |  |  | CC | PG |  | UO |  | 1.95
 |  |  |  |  |  |  |  | CC | PG |  | UO |  | 2.05
 |  |  |  |  |  |  |  | LM | DN |  | TQ |  | 4.3
 |  |  |  |  |  |  |  | LM | DN |  | TQ |  | 3.25
 |  |  |  |  |  |  |  | LM | DN |  | TQ |  | 2.35
 |  |  |  |  |  |  |  | MT | MC |  | DC |  | 1.5
 |  |  |  |  |  |  |  | MT | MC |  | DC |  | 2.45
 |  |  |  |  |  |  |  | MT | MC |  | FTR |  | 2.35
 |  |  |  |  |  |  |  | MT | MC |  | FTR |  | 3.5
 |  |  |  |  |  |  |  | MT | MC |  | FTR |  | 3.4
Spreadsheet: 120785d1315514523-countifs-using-date-text-as-variable-sample-worksheet
Sheet: Sheet1

No. | Join Date | Join Month | New or Existing (N/E) | First Name | Last Name | Sex | Age | March-11 | April-11 | May-11 | June-11 | Jul-11 | Total
 | 2011-03-01 00:00:00 |  | E | [NAME] | Doe | F | 45 | 6 | 10 | 10 | 5
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 37 | 15
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 22 | 15 |  |  |  |  |  |  |  | 2011-04-01 00:00:00
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 27 | 15
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 51 | 20 |  |  |  |  |  |  |  | =COUNTIFS(SampleData[Sex],"M",SampleData[New or Existing (N/E)],"N",TEXT(SampleData[Join Date],"MMM-YYYY"),TEXT(Q4,"MMM-YYYY"))
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 33 | 15
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | M | 17 | 10
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 27 | 15 | 5
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 26 | 20
 | 2011-03-01 00:00:00 |  | N | [NAME] | Doe | F | 15 | 15
 | 2011-03-11 00:00:00 |  | N | [NAME] | Doe | F | 36 | 14 |  |  | 30
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 24 |  | 80
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | M | 17 |  | 80
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 26 |  | 10
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 16 |  | 20
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | F | 53 |  | 2
 | 2011-04-01 00:00:00 |  | E | [NAME] | Doe | M | 27 |  | 50