tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_forney__15532__s_9-20-01
Sheet: Sheet1

Flow Date |  | Available Off Peak Capacity |  |  |  |  |  |  | Available On Peak Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available Off Peak Capacity
2001-09-20 00:00:00
Counterparty |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
[NAME] |  | 135 | 135 | 135 | 135 | 135 | 200 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 135 | 135
Enron Call |  |  |  |  |  |  |  | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100 | -100
Mirant Call |  |  |  |  |  |  |  |  |  |  |  | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50 | -50
CP1 |  |  |  |  |  |  |  | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 | -250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
CP2 |  | -135 | -135 | -135 | -135 | -135 | -135 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -135 | -135 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.5
CP3 |  |  |  |  |  |  | -65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
Total
[NAME]: |  | Deal Details
20.5
Deal_id |  | CP | Volume | Price | Start Hour |  | End Hour
 |  | Mirant Call | -50 |  | 11 |  | 23
781277.1 |  | [NAME] | 135 | 20.5 | 1 |  | 5
781277.1 |  | [NAME] | 200 | 20.5 | 6 |  | 6
781277.1 |  | [NAME] | 250 | 20.5 | 7 |  | 22
781277.1 |  | [NAME] | 135 | 20.5 | 23 |  | 24
758660.13 |  | Enron Call | -100 |  | 7 |  | 22
781400.1 |  | CP3 | -65 | 7 | 6 |  | 6
781193.1 |  | CP2 | -135 | 12.5 | 1 |  | 6
781193.1 |  | CP2 | -135 | 12.5 | 23 |  | 24
781147.1 |  | CP1 | -250 | 24 | 7 |  | 22
Spreadsheet: 107468d1304622557-caluclating-value-of-investment-investments-by-cbl
Sheet: City of Rayville

Date Bought | Property Number | Name | Property Descrption | Amount Paid | [NAME] | Register Letter Cost | Total Paid | Year One Taxes | Year Two taxes | Year Three Taxes | Year Four taxes | Year Five Taxes | Total Invested | Date Redemed | Redemtion Amount | Profit | Value 10/31/11 | [NAME]
2011-05-04 00:00:00 | [PHONE] | Fedral National Mortgage Assoc |  | 98.48 | 0.05 |  | 98.48 |  |  |  |  |  | 98.48 |  |  |  | 133.9328
2011-05-04 00:00:00 | [PHONE] | Summers Harry |  | 75.67 | 0.05 |  | 75.67 |  |  |  |  |  | 75.67 |  |  |  | 102.9112
Spreadsheet: 548287d1510967297-count-sales-of-different-products-to-same-customer-excel-copy-of-excel-example-problem-11-16-17-cdubs34-
Sheet: Sample Pivot Table

 |  | Brand A | Brand B | Brand C | Brand D | Brand A &Brand B | Brand A &Brand C | Brand A &Brand D | Brand B &Brand C | Brand B &Brand D | Brand C &Brand D
 | [NAME]
 | Mark
 | [NAME]
Spreadsheet: 487415d1478077412-sum-product-issue-copy-of-sumproduct-issue-2-
Sheet: Overview

 |  |  | Today | CM | CY | LY
 |  |  |  |  | 2016
 |  |  |  | 1 | 2 | 3 |  | 4 | 5 | 6 |  | 7 | 8 | 9 |  | 10 | 11 | 12
 |  |  |  | January | February | March | Q1 | April | May | June | Q2 | July | August | September | Q3 | October | November | December | Q4 |  | S1 | S2 | YTD | YTG | 16vs15 | SI YTD | SI YTG | SO MAT | SO last 3M
Badoit | 0.5 | PET | Last year
 |  |  | Total
 |  |  | Baseline
 |  |  | Promo
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S1 | S2 | YTD | YTG | Weight vs tot
 |  |  | AUTRES AFH 650052406
 |  |  | BRASSEURS 650052416
 |  |  | CARREFOUR BE 650052393
 |  |  | DELHAIZE Le Lion/ De Leeuw 650052430
 |  |  | ETN FRANZ COLRUYT 650052425
 |  |  | GREY CHANNEL 650052435
 |  |  | GROUPE MESTDAGH 650052439
 |  |  | GROUPE OTHER CUSTOMERS DIVERS 650052440
 |  |  | INTERMARCHE 650037538
 |  |  | [NAME] ([NAME]. 2044) 650037531
 |  |  | PROVERA BE 650052464
 |  |  | TRADITION TRADE 650052472
 |  |  | DELHAIZE DISTRIBUTION Luxembourg 650052431
 |  |  | PROVERA LUX 650037660
 |  |  | RESUMA 650030144
 |  |  | SA COLRUYT GESTION LUX 650052426
 |  |  | ABND 650103417
 |  |  | Beer & Selected Beverages 650029069
 |  |  | Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 130501d1322386952-copy-non-blank-cells-to-seperate-sheets-with-the-relevant-headings-epoxy-colors
Sheet: Sheet1

 |  |  | Description | Prod Code | Number of Mono | Stock | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10 | Item 11 | Item 12 | Item 13 | Item 14 | Item 15 | Item 16 | Item 17 | Item 18 | Item 19 | Item 20 | Item 21 | Item 22
 |  |  | Green | 123 | count(h2:ac2) | Yes | 79.4 |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85.4
 |  |  | Blue | 321 | count(h3:ac3) | Yes | 99.36 | 0.33 |  | 0.28 |  |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  | Red | 212 | count(h4:ac2) | Yes | 10.3 | 7.4 |  |  |  |  | 76.3 |  |  |  |  | 1.9 |  |  |  |  | 4.1 |  |  |  |  |  | 100
 |  |  | etc | … | count(h5:ac5) | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | etc | … | count(h6:ac6)
 |  |  |  |  |  |  |  |  |  |  |  | 1) | The list starts from Col D onwards
 |  |  |  |  |  |  |  |  |  |  |  | 2) | Col F has Count of all Items viz H2:AC2 and so on
 |  |  |  |  |  |  |  |  |  |  |  | 3) | Col AD has =Sum(h2:ac2) which totals to 100.00
 |  |  | Separate Sheets to be created as follow
 |  |  | Sheet Name | Item 1 | Item 2 | Item 5 | Total |  |  |  |  | 4) | Separate Sheets to be created with the name from Col D
 |  |  | Green | 79.4 | 14.6 | 6 | 100 |  |  |  |  |  | and only related Items copied showing the Total in the rightmost column
 |  |  |  |  |  |  |  |  |  |  |  |  | as shown on the examples on the left side
 |  |  |  |  |  |  |  |  |  |  |  | 5) | The output required is shown as separate sheets also
 |  |  | Sheet Name | Item 1 | Item 2 | Item 4 | Item 8 | Total
 |  |  | Blue | 99.36 | 0.33 | 0.28 | 0.03 | 100
 |  |  | Sheet Name | Item 1 | Item 2 | Item 7 | Item 12 | Item 17 | Total
 |  |  | Red | 10.3 | 7.4 | 76.3 | 1.9 | 4.1 | 100
 |  |  | and so on
 |  |  | o
Spreadsheet: 774615d1648567467-capture-frequency-of-activities-data-example
Sheet: Example

Filterable by Rep | Cadence |  |  |  | Time Spent / Week
 | Monthly | Weekly | Daily | Never / Rarely | Over 1 hour / Week | ~ 1 hour / Week | ~ 30 minutes / week | ~ 10 minutes / week | None
Assist warehouse with lost/mis-directed shipments | 10 | 5 | 3 | 0 | 8 | 5 | 6 | 4 | 0
Assist [NAME] with product identification | 10 | 5 | 3 | 0 | 8 | 5 | 6 | 4 | 0
Assist warehouse with packing slip | 10 | 5 | 3 | 0 | 8 | 5 | 6 | 4 | 0
Spreadsheet: 844564d1696339852-need-help-with-a-date-and-time-off-calculation-formula-two-parts-book2
Sheet: VACATION CHART Misc.

N O T E: * Designates ONE WEEK is earned AFTER anniversary date
 |  |  | Seniority [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Follow company/department policies:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S = [NAME] week(s)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y = Buy back week(s)
 | S80U-1
LM # | Employee Name | Vac Date |  | [NAME] | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | Y
 | NBR OF EMPLOYEES PICKED
 | PERCENT PICKED
 | MAX PERCENT ALLOWED |  |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
 | MAX EMPLOYEES ALLOWED
Spreadsheet: 132317d1323698865-many-condition-need-to-match-and-return-a-unit-price-urgent-assignment-test-formulae
Sheet: Sheet 2

Inv Date | Order No_ | Supplier | Invoice No_ | Mtrl Name | Qty | U/P | Supplier Code
2010/12/24 | PD002633 | P-AUDIO SYSTEM CO., LTD | 20100454-1 | [NAME]] | 288 | 20 | P.052
2010/12/24 | PD002633 | P-AUDIO SYSTEM CO., LTD | 20100454-1 | ASSY XDCR DRIVER | 1440 | 7.5 | P.052
2010/12/24 | PD002753 | P-AUDIO SYSTEM CO., LTD | 20100454-1 | [NAME] DC10 1801-8 | 1296 | 14.7 | P.052
2010/12/24 | PD002753 | P-AUDIO SYSTEM CO., LTD | 20100454-1 | [NAME] LN12 3002-8 | 702 | 38 | P.052
2010/12/24 | PD002902 | P-AUDIO SYSTEM CO., LTD | 20100454-1 | [NAME]] | 81 | 32 | P.052
2010/12/24 | PD002902 | P-AUDIO SYSTEM CO., LTD | 20100454-1 | [NAME]] | 81 | 32 | P.052
2010/12/24 | PD002902 | P-AUDIO SYSTEM CO., LTD | 20100454-1 | [NAME] DC10 1801-8 | 832 | 14.7 | P.052
2010/12/16 | PD003052 | KAM YUEN PETROCHEMICAL (H.K.)LTD. | 10-12066 | SAMSUNG TOTAL BJ550 | 34000 | 1.63 | K.041
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: O Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 02-01) 14-02-2018 | pdf |  | 02-01) 14-02-2018 | pdf |  | 02-01) 14-02-2018 | pdf |  | 12-01) 06-12-2018 | pdf |  | 02-01) 14-02-2018 | pdf
 | 05-01) 07-05-2018 | pdf |  | 05-01) 06-05-2018 | pdf |  | 05-01) 06-05-2018 | pdf |  | 02-01) 12-02-2019 | pdf |  | 02-01) 12-02-2019 | pdf
 | 12-01) 06-12-2018 | pdf |  | 12-01) 06-12-2018 | pdf |  | 02-01) 12-02-2019 | pdf |  | 03-01) 11-03-2019 | pdf |  | 12-01) 15-12-2019 | pdf
 | 02-01) 13-02-2019 | pdf |  | 02-01) 12-02-2019 | pdf |  | 05-01) 05-05-2019 | pdf |  | 06-01) 17-06-2019 | pdf |  | 02-01) 10-02-2020 | pdf
 | 03-01) 11-03-2019 | pdf |  | 05-01) 05-05-2019 | pdf |  | 07-01) 24-07-2019 | pdf |  | 12-01) 15-12-2019 | pdf
 | 05-01) 06-05-2019 | pdf |  | 07-01) 24-07-2019 | pdf |  | 10-01) 23-10-2019 | pdf |  | 02-01) 13-02-2020 | pdf
 | 06-01) 18-06-2019 | pdf |  | 10-01) 23-10-2019 | pdf |  | 02-01) 10-02-2020 | pdf
 | 07-01) 25-07-2019 | pdf |  | 12-01) 15-12-2019 | pdf
 | 09-01) 16-09-2019 | pdf |  | 02-01) 12-02-2020 | pdf
 | 10-01) 24-10-2019 | pdf
 | 12-01) 15-12-2019 | pdf
 | 02-01) 13-02-2020 | pdf
 | 03-01) 10-03-2020 | pdf
 | 04-01) 14-04-2020 | pdf
 | 05-01) 11-05-2020 | pdf
Spreadsheet: 767296d1644398392-overlapping-dates-overlapping-ans
Sheet: Sheet1

MemberID | Insurance Start Date | Insurance End Date | No.Of.Days |  | MemberID | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024
M1 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  | M1
M1 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  | M2
M1 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  | M3
M1 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 |  |  | M4
M1 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  | M5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum of No.Of.Days | Column Labels
M1 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  | M6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | 2017 | 2018 | 2020 | Grand Total
M1 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  | M7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M1 | 710 | 615 |  | 1325
M1 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 |  |  | M8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M2 | 355 |  |  | 355
M1 | 2018-01-31 00:00:00 | 2018-03-31 00:00:00 |  |  | M9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M3 |  | 278 |  | 278
M2 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M4 | 355 |  |  | 355
M2 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M5 |  | 278 |  | 278
M3 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M6 | 1094 |  |  | 1094
M3 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M7 | 364 |  |  | 364
M4 | 2017-01-01 00:00:00 | 2017-11-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M8 |  |  | 365 | 365
M4 | 2017-12-31 00:00:00 | 2018-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M9 |  | 580 |  | 580
M5 | 2018-02-15 00:00:00 | 2018-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 2878 | 1751 | 365 | 4994
M5 | 2018-06-10 00:00:00 | 2018-12-31 00:00:00
M6 | 2017-01-01 00:00:00 | 2019-12-31 00:00:00
M7 | 2017-12-31 00:00:00 | 2018-12-30 00:00:00
M8 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00
M9 | 2018-06-30 00:00:00 | 2020-01-31 00:00:00
 |  |  |  |  | =UNIQUE($A$2:$A$22)
Spreadsheet: 773882d1648099027-conditional-formating-based-in-other-range-data-sample2-1-1-
Sheet: Sheet1

From This |  |  | To This |  |  | Based in
Product 1 | 149 |  | Product 1 | 149 |  | Product 1 | 30 | 31 | 32 | 33 | 34 | 35 | 36
Product 1 | 35 |  | Product 1 | 35 |  | Product 2 | 50 | 51 | 52 | 53 | 54 | 55 | 56
Product 2 | 50 |  | Product 2 | 50 |  | Product 3 | 25 | 26 | 27 | 28 | 29
Product 3 | 25 |  | Product 3 | 25
Product 2 | 51 |  | Product 2 | 51
Product 3 | 27 |  | Product 3 | 27
Product 1 | 500 |  | Product 1 | 500
Product 2 | 987 |  | Product 2 | 987
Product 3 | 28 |  | Product 3 | 28
Product 3 | 30 |  | Product 3 | 30
Spreadsheet: 188327d1350824764-creating-a-summary-of-totals-in-a-recipe-counter-par_level_finder_new-1
Sheet: Weekly Average Totals

Product | Total of Weekly Averages
Bacon sandwich | 15.5
beans on toast | 2
scrambled on toast | 3
add bacon | 1.5
add baked beans | 1
add hash brown | 1.5
add mushroom | 2
add sausage | 1
sausage + egg bap | 16.5
toast + jam | 3
traditional breakfast | 5.5
veggie breakfast | 2.5
add burger | 1.5
cheese + bacon burger | 37.5
chicken, cheese + bacon burger | 7.5
classic burger | 16.5
mighty stack burger | 7.5
sfc burger | 20.5
[NAME] | 3
[NAME] melt | 35
lemon + pepper chicken | 19
bakewell sponge | 2.5
chocolate fudgecake | 8
cookie cream cheesecake | 9
sticky toffee pudding | 5
toffee apple crumble | 4.5
jacket potato mixed | 7
fish pie | 5.5
scampi | 13.5
all day breakfast | 49.5
chicken tikka | 24.5
add rice | 18.5
bangers + mash | 12.5
chip shop battered sausages | 9
fish and chips | 13
[NAME] chips | 8
boozy beef | 8
chicken mushroom | 8.5
steak and ale | 9.5
lasagne | 12.5
blue cheese sauce | 6
chicken and bacon salad | 4.5
pasta primavera | 15.5
pasta primavera + chicken | 5.5
cheese and onion tart | 10.5
chicken club | 10.5
[NAME] | 4.5
piri piri ciabatta | 6.5
[NAME] | 18
cajun wrap | 1.5
mexican chicken | 4
bread and butter | 2.5
breaded mushrooms | 3
onion rings | 6.5
add jacket | 0.5
add cheese | 3.5
add chips | 198
add mash | 12.5
add mushy peas | 9.5
add peas | 17
add spirals | 21.5
side chips | 20
side garlic bread | 1
side cheesey garlic bread | 3
side salad | 2.5
side spirals | 3.5
sw add chips | 19.5
sw add spirals | 6.5
add white bread | 46.5
add brown bread | 22
chicken wings | 162.5
loaded chips cheese | 1
loaded chips cheese + bacon | 4
nachos | 5.5
the combo | 7
Spreadsheet: 292406f1-ff0f-4e28-bd45-87b100dc5e22
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Recipient Report Instructions |  |  |  | Version: | 1.1
 | Instructions:
 | You are submitting a report for a Grant or Loan award.
 | Instruction | Required Worksheets
 | If you are a Prime Recipient who is submitting a report or reports on behalf of your Sub Recipient, you must fill out these worksheets (see the tabs at the bottom of the screen): | Prime Recipient
 |  | Sub Recipients
 |  | Vendors (optional)
 | If you are a Prime Recipient who is not submitting a report or reports on behalf of your Sub Recipient, you must fill out these worksheets (see the tabs at the bottom of the screen): | Prime Recipient
 |  | Vendors (optional)
 | If you are a Sub Recipient who is submitting a report, you must fill out these worksheets (see the tabs at the bottom of the screen): | Sub Recipients
 |  | Vendors (optional)
 | Notes
 | Potential Question |  | Answer
 | Not all of my text is showing up when I enter values a narrative field. For example, when entering text for the Project Description field. |  | This is a limitation of Excel. Although each cell holds up to 32,767 characters, Excel only displays 1,024 characters in the cell itself. To view all of the text you've entered for a given field, click on the cell in question and the text will display in the formula bar at the top of the screen.
 | When I try to select a value from a drop-down menu, the text is too small to read. How to I make it bigger? |  | Check to make sure you're viewing the workbook at 100% zoom. If your zoom is set to less than 100%, this can cause the text in the drop-down menus to appear very small.
 | I don't know what CFDA to use. |  | Go to http://www.cfda.gov for the complete list of Catalog for Federal Domestic Assistance (CFDA) values.
 | I'm not sure what each of the data elements mean. |  | You can either click on each cell for instructional text or reference the Data Model document published on [NAME]
 | I have more than 400 Sub Recipients or Vendors to add, but the spreadsheet looks like it is limited to 400. |  | You can continue to add additional Sub Recipients and Vendors beyond the #400 line provided for you, however the special formatting and data validations which are provided for the first 400 Sub Recipients or Vendor entries will not be present. This is done to keep the file size of the template from growing excessievly large. Data validation will be performed once your report is uploaded on FederalReporting.gov.
Spreadsheet: 691405d1597680354-need-count-sum-formula-based-on-three-3-criteria-rawdata
Sheet: Data

Raw Data |  |  |  |  |  | Unique Account (to be achieved with formula)
Date | Date (EOM) | Type | State | Count |  | Date (EOM) | Type | State | Count
2020-01-08 00:00:00 |  | A | FL | 1 |  | 2020-01-31 00:00:00 | B | CA | 1
2020-01-15 00:00:00 |  | C | FL | 1 |  | 2020-01-31 00:00:00 | C | CA | 3
2020-01-23 00:00:00 |  | C | FL | 1 |  | 2020-01-31 00:00:00 | A | FL | 1
2020-01-27 00:00:00 |  | B | CA | 1 |  | 2020-01-31 00:00:00 | C | FL | 2
2020-01-27 00:00:00 |  | C | CA | 1 |  | 2020-01-31 00:00:00 | B | TX | 1
2020-01-30 00:00:00 |  | C | CA | 1 |  | 2020-01-31 00:00:00 | A | TX | 1
2020-01-31 00:00:00 |  | C | CA | 1 |  | 2020-01-31 00:00:00 | D | TX | 2
2020-01-17 00:00:00 |  | B | TX | 1 |  | 2020-02-29 00:00:00 | A | CA | 1
2020-01-19 00:00:00 |  | A | TX | 1 |  | 2020-02-29 00:00:00 | C | CA | 1
2020-01-25 00:00:00 |  | D | TX | 1 |  | 2020-02-29 00:00:00 | B | CA | 2
2020-01-28 00:00:00 |  | D | TX | 1 |  | 2020-02-29 00:00:00 | E | CA | 1
2020-02-01 00:00:00 |  | A | CA | 1 |  | 2020-02-29 00:00:00 | B | FL | 1
2020-02-03 00:00:00 |  | C | CA | 1 |  | 2020-02-29 00:00:00 | D | FL | 4
2020-02-04 00:00:00 |  | B | CA | 1 |  | 2020-02-29 00:00:00 | C | TX | 2
2020-02-07 00:00:00 |  | B | CA | 1
2020-02-11 00:00:00 |  | E | CA | 1
2020-02-12 00:00:00 |  | B | FL | 1
2020-02-12 00:00:00 |  | D | FL | 1
2020-02-15 00:00:00 |  | D | FL | 1
2020-02-21 00:00:00 |  | D | FL | 1
2020-02-22 00:00:00 |  | D | FL | 1
2020-02-23 00:00:00 |  | C | TX | 1
2020-02-24 00:00:00 |  | C | TX | 1
Spreadsheet: 00340895-9378-4667-a1d9-9b7c0f687c5c
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
 | Time Series Workbook
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 11F. Average Weekly Earnings, Tasmania (Dollars) - Trend
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  Tasmania ; |  |  | Trend | A2810821V | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  Tasmania ; |  |  | Trend | A2810824A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  Tasmania ; |  |  | Trend | A2810830W | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  Tasmania ; |  |  | Trend | A2810822W | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  Tasmania ; |  |  | Trend | A2810825C | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  Tasmania ; |  |  | Trend | A2810831X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Tasmania ; |  |  | Trend | A2810823X | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Tasmania ; |  |  | Trend | A2810826F | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Tasmania ; |  |  | Trend | A2810832A | 2012-05-15 00:00:00 | 2012-11-15 00:00:00 | 3 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2013
Spreadsheet: 148806d1333559641-copying-data-to-another-worksheet-sample-test-tracker
Sheet: Instructors

FIRST NAME | LAST NAME | TEST # COMPLETED | DATE
[NAME] | JONES | 1 | 2012-04-04 00:00:00
[NAME] | SMITH | 2 | 2012-03-18 00:00:00
[NAME] | SMITH | 2 | 2012-03-20 00:00:00
[NAME] | JONES | 5 | 2012-03-22 00:00:00
WILLIAM | [NAME] | 3 | 2012-03-23 00:00:00
WILLIAN | [NAME] | 3 | 2012-03-25 00:00:00
[NAME] | SMITH | 2 | 2012-03-26 00:00:00
JASON | WHITEHALL | 4 | 2012-03-27 00:00:00
Spreadsheet: 850103d1700495933-calculating-the-number-of-people-who-have-purchased-more-than-once-over-rolling-periods-repeat-purchase-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1415444-calculating-the-number-of-people-who-have-purchased-more-than-once-over-rolling-periods.html
Person's name | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec
[NAME] | 1 | 1 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 1 | 1
[NAME] | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Jake | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
[NAME] | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sue | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Number of people who made more than 1 purchase in the 3 month period - expected values
 | Jan - March | … | … | … | … | [NAME] | … | … | …. | … | Oct - Dec
 | 4 |  |  |  |  | 2 |  |  |  |  | 2
Spreadsheet: 195831d1353677431-how-to-align-the-text-and-number-in-the-same-row-hi-i-would-like-to-able-to-align-the-text-and-umber-in-the-same-row
Sheet: Sheet1

name of the comp. | type of transaction | quantity
barista | purchase
limited |  | 200
barista | sale
limited |  | 200
barista | purchase
limited |  | 200
barista | purchase
limited |  | 200
barista | sale
limited |  | 200
barista | purchase
limited |  | 200
barista | purchase
limited |  | 200
barista | sale
limited |  | 200
but I want the above the data as follows..
barista limited | purchase | 200
barista limited | sale | 200
barista limited | purchase | 200
barista limited | purchase | 200
barista limited | sale | 200
barista limited | purchase | 200 | etc…
Spreadsheet: 453655d1459398175-populate-events-calendar-from-inputs-sample
Sheet: OUTPUT

 |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00
 | 09:00:00 | Breakfast |  | Breakfast |  | If each cell could also display corresponding times, that would be awesome!
 | 09:30:00 |  | Breakfast
 | 10:00:00 | Activity |  | Activity
 | 10:30:00 |  | Activity | Break
 | 11:00:00
 | 11:30:00
 | 12:00:00 | Lunch |  | Activity
 | 12:30:00 |  | Lunch | Lunch
 | 13:00:00 | Activity
 | 13:30:00
 | 14:00:00 |  | Activity
 | 14:30:00 |  |  | Activity
 | 15:00:00 | Break
 | 15:30:00
 | 16:00:00
 | 16:30:00 | Dinner
 | 17:00:00
 | 17:30:00
 | 18:00:00 |  | Dinner
 | 18:30:00
 | 19:00:00