tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 887650d1737923297-multiple-arguements-to-return-true-and-add-them-more-info-below-example-workbook-etaf
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Current Boss
 |  |  |  |  |  |  |  |  |  |  |  |  | Queen Ansurek
 |  |  |  |  |  |  |  |  |  |  | All Buffs |  |  |  | Class [NAME]
 |  |  |  |  |  |  |  |  |  |  | Lust |  |  |  |  | Evoker
 |  |  |  |  |  |  |  |  |  |  | 3% Intellect |  |  |  |  | Mage
 |  |  |  |  |  |  |  |  |  |  | 5% Stamina |  |  |  |  | Priest
 |  |  |  |  |  |  |  |  |  |  | 5% Attack Power |  |  |  |  | Warrior
 |  |  |  |  |  |  |  |  |  |  | 5% Hunters Mark |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 5% Physical Dmg |  |  |  |  | Monk
 |  |  |  |  |  |  |  |  |  |  | 3% Magical Dmg |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | 3% DR |  |  |  |  | Paladin
 |  |  |  |  |  |  |  |  |  |  | 3% Vers |  |  |  |  | Druid
 |  |  |  |  |  |  |  |  |  |  | 3.6% DR |  |  |  |  | Rogue
 |  |  |  |  |  |  |  |  |  |  | 2% Mastery + WF |  |  |  |  | Shaman
 |  |  |  |  |  |  |  |  |  |  | Healthstones/Gate |  |  |  |  | Warlock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Main Roster
 |  |  |  |  |  |  |  |  |  | Main-Spec | Name |  |  |  | Composition
 |  |  |  |  |  |  |  |  |  | Tanks |  |  |  |  |  | Tanks
 |  |  |  |  |  |  |  |  |  | Death Knight Blood | Deathmending |  | In |  |  | Healer
 |  |  |  |  |  |  |  |  |  | [NAME] | Pamidan |  | In |  |  | M DPS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R DPS
 |  |  |  |  |  |  |  |  |  | Healers |  |  |  |  | Immunities
 |  |  |  |  |  |  |  |  |  | Shaman Restoration | Papahealer |  | In
 |  |  |  |  |  |  |  |  |  | Evoker Preservation | Quietbegger |  | In
 |  |  |  |  |  |  |  |  |  | Monk Mistweaver | Enchant |  | In
 |  |  |  |  |  |  |  |  |  | Priest Holy | Creammedaddy |  | In
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Warrior Fury | [NAME] |  | In
 |  |  |  |  |  |  |  |  |  | Death Knight Frost | Zeht |  | In
 |  |  |  |  |  |  |  |  |  | [NAME] | Slappyhands |  | In
 |  |  |  |  |  |  |  |  |  | [NAME] | Stepsisnoo |  | In
 |  |  |  |  |  |  |  |  |  | [NAME] | Omallypally |  | In
 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  | In
 |  |  |  |  |  |  |  |  |  | [NAME] | Tutankamonk |  | In
 |  |  |  |  |  |  |  |  |  | Rogue Assassination | Omdar |  | In
 |  |  |  |  |  |  | I want to know under Class [NAME] if that class is in based on the Main Roster, [NAME] but only if they are IN. Example shows everyone IN but that could change.
Spreadsheet: 877135d1723810904-custom-data-validation-personal-budget-template
Sheet: Outgoings & Income

Record of Outgoings & Income
 |  |  |  |  |  |  |  |  |  | Outgoing Expenses
Date | In/Out | Category | Description | Incomes | Outgoings | Year | Month |  |  | Category | Budget | Actual | January | February | March | April | May | June | July | August | September | October | November | December | Total YTD | Year Budget
2024-01-17 00:00:00 | Income | Boarding |  |  |  |  |  |  |  | Cost of Goods Sold
2024-01-20 00:00:00 | Outgoing | Advertising |  |  | 300 |  |  |  |  | Advertising
2024-02-02 00:00:00 | Income | Training (On-site) |  | 65 |  |  |  |  |  | Car/Truck
2024-02-25 00:00:00 | Outgoing | Travel & Meals |  |  | 65 |  |  |  |  | Commissions & Fees
2024-03-15 00:00:00 |  |  |  |  |  |  |  |  |  | Contract Labor
 |  |  |  |  |  |  |  |  |  | Insurance
 |  |  |  |  |  |  |  |  |  | Interest/Card fees/Bank fees
 |  |  |  |  |  |  |  |  |  | Mortgage Payments
 |  |  |  |  |  |  |  |  |  | Legal & Professional
 |  |  |  |  |  |  |  |  |  | Office Supplies
 |  |  |  |  |  |  |  |  |  | Rent/Lease
 |  |  |  |  |  |  |  |  |  | Dog Food
 |  |  |  |  |  |  |  |  |  | Repairs/Maintenance
 |  |  |  |  |  |  |  |  |  | Supplies
 |  |  |  |  |  |  |  |  |  | Taxes & Licenses
 |  |  |  |  |  |  |  |  |  | Travel & Meals
 |  |  |  |  |  |  |  |  |  | Wages
 |  |  |  |  |  |  |  |  |  | Electric
 |  |  |  |  |  |  |  |  |  | Gas/Propane
 |  |  |  |  |  |  |  |  |  | Phone
 |  |  |  |  |  |  |  |  |  | Internet
 |  |  |  |  |  |  |  |  |  | Sales Tax
 |  |  |  |  |  |  |  |  |  | Abbigail
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Naudia
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Income | Target | Actual | Target Year | Actual Year
 |  |  |  |  |  |  |  |  |  | Boarding
 |  |  |  |  |  |  |  |  |  | Training (On-site)
 |  |  |  |  |  |  |  |  |  | Board & Training (On-site)
 |  |  |  |  |  |  |  |  |  | Training (Off-site)
 |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 721211d1614590227-conditional-formatting-with-dates-formula-test
Sheet: date control

Rec'd | 4 days | 8 days | 10 days | 17 days | 1 month | 2 month | 3 month | 4 month | 5 month | 6 month
Spreadsheet: 184081d1349130506-deleting-duplicates-book8
Sheet: Sheet1

ID | Last name | First name | Card code
a | b | c | d
x | f | g | r
s | g | hy | t
a | b | c | d
s | d | r | g
x | f | g | r
f | w | r | p
q | e | t | z
Spreadsheet: 854790d1704548075-custom-formula-for-subscription-calculations-as-needed-monthly-annually-subscriptions
Sheet: Subscriptions

DATE | FREQUENCY | PAYEE | AMOUNT | Month Num
2024-01-01 00:00:00 | As-Needed | CallingCard.com | 10
2024-01-01 00:00:00 | As-Needed | E-Z Pass | 70
2024-01-04 00:00:00 | Monthly | SiriusXM.com | 22.89
2024-01-21 00:00:00 | Monthly | Experian.com | 29.99
2024-01-24 00:00:00 | Monthly | Netflix.com | 22.99
2024-04-14 00:00:00 | Annually | HomeAgain.com | 24.99
2024-07-27 00:00:00 | Annually | Ring.com | 39.99
Year
MONTH | Month Num | MONTHLY AMOUNT | Monthly | Annual | As-Needed
JAN | 1
FEB | 2
MAR | 3
APR | 4
MAY | 5
JUN | 6
JUL | 7
AUG | 8
SEP | 9
OCT | 10
NOV | 11
DEC | 12
Spreadsheet: 742298d1627651353-list-a-range-of-numbers-between-two-cells-test-range
Sheet: Sheet1

Working Example Using the FILL>SERIES
10 | <-- Start is specified here
11 | <-- These values are generated using the fill function <--
12
13
14
15
16
17
18
19
20
I want to automate this so I can specific the start and stop numbers and list them
=[NAME] | 10 | <-- Start
11 | 20 | <-- Stop
12
13
14
15
16
17
18
19
20
Spreadsheet: 89766d1289504540-converting-time-to-hours-and-minutes-comp-form-fy-2011
Sheet: Jan

Comp Time Form
 | Name : |  |  | Month: | January 2011
 | Title:
 | Earned/Taken  E or T | Date Earned/Taken | Activity | Director [NAME] | Time Worked | Time Granted      (@ time & 1/2) | Time Used | Time Available
 | E |  | Forwarded from Previous Month
 |  |  |  | Sub Totals
Spreadsheet: 740469d1626353094-not-calculating-correctly-after-certain-line-value-error-sfsales-dec-2020-to-present-july-2021
Sheet: Inventory

Packaging Inventory |  |  |  |  | Data
Item | Purchased | Sold | Inventory |  | Item | Sold | Packaging A | Packaging B | Label | Nutritional Label | Seal | Batch | Weight (KG)
Read Me Guide:
Values in this table use values from the "Set Expenses" table against values in the "Sales" table to work out an estimate of what is currently in your inventory.
Product inventory uses the sales table to collect an approximation of the quantity of packaging and labels that was sold.
Packaging Inventory "Qty Used" refers to the quantity of item that was sold.
Drag the table to open more fields.
Do not edit grey zones.
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 62309 | 62102
2 | 50220 | 49280
3 | 49998 | 49280
4 | 47950 | 54280
5 | 57018 | 58244
6 | 38266 | 38499
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 9003
2002-03-06 00:00:00
CBS Volume
 |  |  | 4076
Spreadsheet: 887174d1737386392-formatting-raw-data-book1-2-
Sheet: Sheet1

[NAME]
id = 1 |  |  |  |  | ID | Student | Classes | Awards | Passes | Fails | Distinctions
Classes |  |  |  |  |  | [NAME] | 20 | 12 | 8 | 2
20 |  |  |  |  | 4 | [NAME] | 9 |  | 4 |  | 1
Awards
12
Passes
8
Fails
2
[NAME]
id = 4
Classes
9
Passes
4
Distinctions
1
Spreadsheet: 4e9a6fdc-3029-4285-aed8-963a2f09f6e5
Sheet: Sheet1

Example City,  Precipitation Data Chart From:  http://hdsc.nws.noaa.gov/hdsc/pfds/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
Precipitation Frequency Estimates (inches)
ARI* | 5 | 10 | 15 | 30 | 60 | 120 | 3 | 6 | 12 | 24 | 48 | 4 | 7 | 10 | 20 | 30 | 45 | 60
(years) | min | min | min | min | min | min | hr | hr | hr | hr | hr | day | day | day | day | day | day | day
1 | 0.36 | 0.58 | 0.72 | 0.99 | 1.23 | 1.44 | 1.55 | 1.95 | 2.46 | 2.98 | 3.58 | 4.04 | 4.68 | 5.37 | 7.16 | 8.87 | 11.2 | 13.32
2 | 0.43 | 0.69 | 0.86 | 1.19 | 1.49 | 1.75 | 1.88 | 2.35 | 2.97 | 3.62 | 4.32 | 4.87 | 5.6 | 6.4 | 8.48 | 10.43 | 13.09 | 15.53
5 | 0.51 | 0.81 | 1.03 | 1.46 | 1.88 | 2.22 | 2.38 | 2.95 | 3.69 | 4.59 | 5.44 | 6.05 | 6.83 | 7.7 | 10.01 | 12.04 | 14.82 | 17.45
10 | 0.57 | 0.91 | 1.16 | 1.67 | 2.18 | 2.6 | 2.79 | 3.44 | 4.26 | 5.36 | 6.31 | 6.97 | 7.78 | 8.68 | 11.2 | 13.23 | 16.11 | 18.89
25 | 0.65 | 1.04 | 1.32 | 1.95 | 2.6 | 3.15 | 3.4 | 4.15 | 5.06 | 6.42 | 7.51 | 8.23 | 9.06 | 9.97 | 12.79 | 14.75 | 17.75 | 20.72
50 | 0.71 | 1.14 | 1.44 | 2.17 | 2.94 | 3.61 | 3.9 | 4.75 | 5.71 | 7.28 | 8.47 | 9.23 | 10.05 | 10.97 | 14.02 | 15.89 | 18.97 | 22.08
100 | 0.78 | 1.24 | 1.56 | 2.4 | 3.3 | 4.1 | 4.45 | 5.39 | 6.38 | 8.16 | 9.46 | 10.24 | 11.05 | 11.97 | 15.25 | 17.01 | 20.13 | 23.37
200 | 0.84 | 1.34 | 1.69 | 2.63 | 3.68 | 4.62 | 5.06 | 6.1 | 7.1 | 9.09 | 10.48 | 11.29 | 12.07 | 12.96 | 16.49 | 18.09 | 21.26 | 24.61
500 | 0.93 | 1.47 | 1.85 | 2.94 | 4.22 | 5.4 | 5.95 | 7.12 | 8.11 | 10.36 | 11.88 | 12.71 | 13.43 | 14.29 | 18.14 | 19.48 | 22.69 | 26.18
1000 | 1 | 1.57 | 1.97 | 3.2 | 4.67 | 6.05 | 6.7 | 7.99 | 8.94 | 11.36 | 12.99 | 13.84 | 14.49 | 15.34 | 19.4 | 20.51 | 23.74 | 27.33
Intensity, [NAME] 10-yr, 24-hr d(in)/24hr | 0.2233333333333334 | in/hr |  | Use time of concentration to determine the "1-yr" storm, but not the "1-yr, 24-hr" storm.  Note that the "1-yr, 24-hr"  value discussed here is the regulated storm.
Depth at 24hr & 10-yr:  d= | 5.36 | in
Intensity, Peak 1-yr, 24-hr d(in)/24hr | 0.1241666666666667 | in/hr
Depth at 24hr & 1-yr:  d= | 2.98 | in
Intensity, [NAME] 10-yr d(in)/tc(min)*60(min/hr) | 4.66134118734995 | in/hr
Depth at Tc & 10-yr:  d= | 1.16 | in
Intensity, Peak 1-yr d(in)/tc(min)*60(min/hr) | 0.279680471240997 | in/hr
Depth at Tc & 1-yr:  d= | 0.72 | in
Time of Conc.:  Tc=  =(L3/H).385/128 | 14.93132495619115 | min | (Calculate this value from the hydraulic length and the change in elevation along the hydraulic length)
[NAME], L | 1000 | ft | Furthest distance water flows to BMP (Example Site)
Change in Elev., H | 3 | ft | Over hydraulic length (Example Site)
Spreadsheet: 749727d1632985287-formula-to-calculate-sales-sales
Sheet: Sheet1

 | COMPLANY ID | COMPANY | SALES | AGENT
 | 1234 | ABC LIMITED | 1000 | PETE
 | 1234 | ABC LIMITED | 1000 | PETE
 | 1234 | ABC LIMITED | 1000 | PETE
 | 1234 | ABC LTD | 6000 | PETE
 | 1234 | ABC LIMITED | 3000 | PETE
 | 1234 | ABC LTD | 4000 | PETE
 | 1234 | ABC LTD | 1000 | PETE
 | 1234 | ABC LTD | 1000 | PETE
 | 5678 | DEF LIMITED | 3000 | [NAME]
 | 5678 | DEF LIMITED | 4000 | [NAME]
 | 5678 | DEF LIMITED | 5000 | [NAME]
 | 5678 | DEF LTD | 6000 | [NAME]
 | 5678 | DEF LTD | 7000 | [NAME]
 | 5678 | DEF LTD | 8000 | [NAME]
 | 5678 | DEF LTD | 9000 | [NAME]
Spreadsheet: 708265d1607698889-arrange-data-in-columns-b-and-c-against-a-linear-timeline-in-column-a-colmatchsample-ans
Sheet: Sheet1

Timeline | SourceDate | SourceValue |  | PastedSourceDate | PastedSourceValue
2019-01-01 00:00:00 |  |  |  | 2019-01-03 00:00:00 | 6abf
2019-01-02 00:00:00 |  |  |  | 2019-01-04 00:00:00 | c89d
2019-01-03 00:00:00 |  |  |  | 2019-01-06 00:00:00 | 34df
2019-01-04 00:00:00 |  |  |  | 2019-01-08 00:00:00 | f561
2019-01-05 00:00:00 |  |  |  | 2019-01-09 00:00:00 | bbac
2019-01-06 00:00:00
2019-01-07 00:00:00
2019-01-08 00:00:00
2019-01-09 00:00:00
2019-01-10 00:00:00
Expected results: |  |  |  | Expected results:
Timeline | SourceDate | SourceValue |  | Timeline | SourceDate | SourceValue
2019-01-01 00:00:00 |  |  |  | 2019-01-01 00:00:00
2019-01-02 00:00:00 |  |  |  | 2019-01-02 00:00:00
2019-01-03 00:00:00 |  |  |  | 2019-01-03 00:00:00 | 2019-01-03 00:00:00 | 6abf
2019-01-04 00:00:00 |  |  |  | 2019-01-04 00:00:00 | 2019-01-04 00:00:00 | c89d
2019-01-05 00:00:00 |  |  |  | 2019-01-05 00:00:00
2019-01-06 00:00:00 |  |  |  | 2019-01-06 00:00:00 | 2019-01-06 00:00:00 | 34df
2019-01-07 00:00:00 |  |  |  | 2019-01-07 00:00:00
2019-01-08 00:00:00 |  |  |  | 2019-01-08 00:00:00 | 2019-01-08 00:00:00 | f561
2019-01-09 00:00:00 |  |  |  | 2019-01-09 00:00:00 | 2019-01-09 00:00:00 | bbac
2019-01-10 00:00:00 |  |  |  | 2019-01-10 00:00:00
Spreadsheet: de39115c-68ec-4b1d-8147-67f7e3639d49
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
43596521 | 2014-10-15 21:48:32 | AXIS | 0 | 1 | 5 | 1161969 | primarette | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
43596630 | 2014-10-15 21:58:48 | ALLIES | 1 | 5 | 3 | 1161969 | primarette | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
43622816 | 2014-10-17 21:24:41 | AXIS | 1 | 6 | 4 | 661818 | Artalis | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
43623070 | 2014-10-17 21:42:13 | AXIS | 0 | 5 | 7 | 1620873 | diallo83 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43623316 | 2014-10-17 22:10:47 | ALLIES | 0 | 4 | 7 | 1620873 | diallo83 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43636881 | 2014-10-18 21:01:41 | AXIS | 0 | 2 | 6 | 1634155 | toconarus | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43637060 | 2014-10-18 21:19:15 | ALLIES | 1 | 6 | 4 | 1634155 | toconarus | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43666783 | 2014-10-20 21:47:05 | ALLIES | 1 | 6 | 3 | 1254858 | Hougoumont | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
43667100 | 2014-10-20 22:00:39 | AXIS | 1 | 6 | 3 | 1254858 | Hougoumont | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
43737135 | 2014-10-25 22:17:34 | AXIS | 0 | 6 | 10 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43737474 | 2014-10-25 22:55:22 | ALLIES | 1 | 10 | 6 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 766876d1644135103-stock-closing-prices-w-o-data-types-data-from-web-imported-aligw
Sheet: TSP Funds

TSP Investment Funds 8/31/1990 - 2/4/2022 | TSP G Fund | TSP F Fund | TSP C Fund | TSP S Fund | TSP I Fund
Last Price (2/4/2022) | 16.7622 | 20.2652 | 68.0124 | 74.3625 | 37.9758
Change (1-Day) | 0.00% | -0.66% | 0.53% | 1.48% | -0.06%
YTD Return | 0.15% | -2.98% | -5.47% | -10.88% | -3.72%
1-Year Return | 1.45% | -3.47% | 17.87% | -8.19% | 6.40%
3-Year Return | 1.49% | 3.51% | 20.23% | 14.31% | 10.13%
5-Year Return | 1.95% | 3.02% | 16.48% | 11.93% | 8.33%
10-Year Return | 1.93% | 2.77% | 15.12% | 12.43% | 7.04%
Annual Return Since 8/31/1990 | 4.3% | 5.7% | 11.0% | 11.2% | 5.9%
Annualized Standard Deviation [2] | 0.3% | 3.8% | 18.2% | 20.3% | 17.6%
Maximum Drawdown [3] | - | -6.6% | -55.2% | -57.4% | -60.9%
[NAME] [4] | - | 0.38 | 0.44 | 0.42 | 0.18
Value of $1,000 invested on 8/31/1990 | $3,728 | $5,753 | $26,705 | $27,798 | $6,130
Spreadsheet: sally_beck__33739__Metrics 0727
Sheet: West

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | West Midstream
Results based on Activity through July 27, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 4
 |  | Weekly Summary - 2Q00 through 2Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-07-07 00:00:00
Postings Rollforward:
Beginning |  | 14
+ Entrances |  | 0 | 0 | 3 | 0
- Exits |  | 0 | 0 | 1 | 0
- Executions |  | 0 | 0 | 0 | 1
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  | Quarterly Summary ($ millions)
 |  |  |  |  |  |  |  | Forward Quarters
 | YTD |  |  | Current Quarter |  | Per |  |  |  |  | Total Year
 | 2000 |  |  | 3Q00 |  | Hot List |  | 4Q00 |  |  | 2000 |  |  | 1Q01 |  |  | 2Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions |  |  |  | 1 | 7.9 | 7.9 |  | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
DPR/MPR |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0
Postings |  |  |  | 4 | 3.1 |  |  | 8 | 69 |  |  |  |  | 2 | 5 |  | 1 | 0
Identified Margin
Budget |  | 13.235
$ Coverage
Spreadsheet: 804501d1668104659-sumifs-countifs-jd
Sheet: Data

ANLYS_EVNT_ID | evnt_fscl_yr | EVNT_NM | Short_Name | PROD_LVL_NBR | SKU_DESC | SVP_DESC | SUB_DEPT_NBR | SUB_DEPT_DESC | CLASS_NBR | CLASS_DESC | Avg_Normal_Price | Avg_Sale_Price | Gross_Sales | Gross_Units | Markdown | Discount_Percent | Quarter | Discount | YEAR | UI
11227 | 2018 | 2018 SPRING PHASE I | 2018 SPRING PHASE I | 959472 | [NAME] B GON + CRBGRSS 1 GAL RTU | Hardlines | 28O | GRD/OUTDOOR | 1 | CHEMICALS | 11.5462149783906 | 15 | 1513 | 6 |  | 0.44585318237594 |  |  | 2018 | SPRING PHASE I
11227 | 2018 | 2018 SPRING PHASE I | 2018 SPRING PHASE I | 514245 | BUG B GON L&G INSECT KILLER RTS 32OZ | Hardlines | 28O | GRD/OUTDOOR | 1 | CHEMICALS | 8.90329264582881 | 1 | 53153 | 215153 |  | 0.341609713623277 |  |  | 2018 | SPRING PHASE I
11227 | 2018 | 2018 SPRING PHASE I | 2018 SPRING PHASE I | 623000 | [NAME] B GON + CRBGRSS 32OZ RTS | Hardlines | 28O | GRD/OUTDOOR | 1 | CHEMICALS | 8.84220942961598 | 2 | 5213 | 511 |  | 0.32677723950036 |  |  | 2018 | SPRING PHASE I
11227 | 2018 | 2018 SPRING PHASE I | 2018 SPRING PHASE I | 846646 | KINGSFORD CHARCOAL 2PK | Hardlines | 28I | GRD/INDOOR | 22 | GRILLS | 19.813929297499 | 3 | 16 | 513 |  | 0.248860603463914 |  |  | 2018 | SPRING PHASE I
Spreadsheet: 836385d1689320515-finding-most-often-frequency-works-or-gives-ref-error-why-doesnt-this-work
Sheet: Sheet1

Account | Location | Lead
123A | Chicago | Ricky |  | 123A
234A | Miami | Shelly |  | Location |  | <-- works
345A | New York | [NAME] |  | Lead |  | <-- does not work
456A | Los Angeles | [NAME]
567A | Seattle | [NAME]
678A | Houston | [NAME]
789A | Denver | [NAME]
890A | Seattle | [NAME]
901A | Las Vegas | Magnuson
234A | Miami | Shelly
345A | New York | [NAME]
123A | Seattle | [NAME]
789A | Miami | [NAME]
890A | Atlanta | Skippy
890A | Atlanta | Skippy
901A | Chicago | Magnuson
234A | Miami | Shelly
345A | New York | [NAME]
456A | Chicago | [NAME]
567A | Seattle | [NAME]
678A | Houston | [NAME]
789A | Denver | [NAME]
123A | Chicago | Ricky
456A | Los Angeles | [NAME]
567A | Las Vegas | Magnuson
901A | Chicago | Magnuson
Spreadsheet: 64708d1265512457-time-sheet-calculations-time-sheets-100-v2
Sheet: input

 | id |  | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00
 | 101 | Incidental | 6 | 1 | 2 | 0
 | 101 | Call Out | 8 | 3 | 0 | 0
 | 101 | 6th | R |  | 8
 | 102 | Incidental | 2 | 2 | 2 | 2
 | 102 | Call Out
 | 102 | 6th
 | 106 | Incidental
 | 106 | Call Out
 | 106 | 6th
 |  | this is the employee ID number
 |  |  |  | input data on this sheet, posts to other tabs
Spreadsheet: 862731d1710380864-check-condition-with-2-file-report
Sheet: report

Status | Owner | SR # | Activity # | SR Category | SR Sub Category | SR Issue | [NAME] | Closed Date
Working | IT | 1244 | 64 | Complaint | Service | IR (Inter) |  | 2024-02-01 07:43:58
Working | IT | 2564 | 12 | Complaint | Service | IDD (IDD) |  | 2024-02-01 07:43:18
Working | IT | 5642 | 78 | Complaint | Service | IR (Inter) |  | Working
Working | IT | 1244 | 56 | Complaint | Service | IR (Inter)
Working | IT | 7894 | 45 | Complaint | Service | IR (Inter)
Working | IT | 7897 | 12 | Complaint | Service | IR (Inter) |  | Working
Spreadsheet: 165728d1341328110-need-to-count-number-of-unique-text-values-as-long-as-date-is-same-in-column-uniquecount_smp4502004_ron_v1a
Sheet: UniqueCount

[NAME] | Date | Count
[EMAIL] | 2012-07-03 00:00:00 |  | =IF(B2<>B1,SUMPRODUCT(IFERROR(($B$2:$B$30=B2)/(COUNTIFS($A$2:$A$30,$A$2:$A$30&"",$B$2:$B$30,B2)),0)),"")
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-03 00:00:00
[EMAIL] | 2012-07-10 00:00:00
[EMAIL] | 2012-07-10 00:00:00
[EMAIL] | 2012-07-10 00:00:00
[EMAIL] | 2012-07-10 00:00:00
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: DV-D-A Screen

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Verification
Activity Name | DV-D-A Screen
Activity Description / Purpose | Screening clients/customers for potential domestic violence/drug/or alcohol
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Collect Finger Image
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R1

Ime artikla
Spreadsheet: 880601d1728409193-automated-calendar-with-changing-holidays-vakantie-template-mbv-cadix
Sheet: april

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opgenomen vakantie | Resterende vakantie
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | Maxime
VPK | [NAME]
 | Cédric
 | Elke
 | Ellen
 | Els
 | Gert
 | Ief
 | [NAME]
 | Joeri
 | [NAME]
 | Kelly
 | [NAME]
 | [NAME]
 | Michel
 | Mirthe
 | Nadia
 | Neslihan
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
ZK | Annelies
 | Herly
 | Nadia
 | Nele
 | Ranka
 | Sid
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
[NAME] | [NAME]
 | [NAME]
 | Hilde
 | Samira
 | Vicky
 | Tyra
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
Spreadsheet: 147212d1332603037-7-dependent-drop-down-lists-stuck-best-way-to-go-about-it-extrusioncalc
Sheet: REFERENCE

Extruders | ExtrusionList | ColorList | CentermateList | LocksList | TracksList | AnglesList |  | extrusion1 | colors1 | centermate1 | locks1 | Tracks1 | angles1 | angles2
IMPACT TECHNOLOGY | Extrusion1 | Colors1 | Centermate1 | Locks1 | Tracks1 | Angles1 |  | ACCORDION | CLEAR | FLAT P BUTTON | PSH-OUT | 2" B.O WALL TRACK | 1X2.5 AGL | 1X2.5 AGL
EASTERN METALS | Extrusion1 | Colors1 | Centermate1 | Locks1 | Tracks2 | Angles2 |  |  | BEIGE | HD T LOCK | PSH-IN | STD WALL TRACK | 1X4 AGL | 1X4 AGL
 |  |  |  |  |  |  |  |  | IVORY | HD DBOLT LOCK | L LK-OUT | CEILING TRACK | EASTERN AGL | HV AGL
 |  |  |  |  |  |  |  |  | WHITE | FLAT CM W RAIN G | L LK-IN | 2" WALL RAIN G
 |  |  |  |  |  |  |  |  | BRONZE |  |  | STD WALL RAIN G
 |  |  |  |  |  |  |  |  |  |  |  | WALK OVER TRACK
 |  |  |  |  |  |  |  |  |  |  |  | ADJUST FL TRACK