tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868052d1714752390-dynamic-formula-or-something-else-yoy-growth-v2
Sheet: Sales Team RR&F

 | Select Period | GP P1 | Sales Team Growth
 |  |  |  | TY |  | LY | Growth
 | Sales team Forecast - LY v TY
 |  |  |  | Up |  | Down | Level
 | Qty Trading Up V Qty Trading Down
 | Company | Period TY | Avg Day Period TY | Forecast Period TY |  | Period LY | Avg Day Period LY |  | Acc TY | Avg Day Acc TY |  | Acc LY | Avg Day Acc LY
 | Grand Total
 | Customer 2
 | Customer 3
 | Customer 4
 | Customer 5
 | Customer 6
 | Customer 7
 | Customer 8
 | Customer 9
 | Customer 10
 | Customer 11
 | Customer 12
 | Customer 13
 | Customer 14
 | Customer 15
 | Customer 16
 | Customer 17
 | Customer 18
 | Customer 19
 | Customer 20
 | Customer 21
 | Customer 22
 | Customer 23
 | Customer 24
 | Customer 25
 | Customer 26
 | Customer 27
 | Customer 28
 | Customer 29
Spreadsheet: 83320d1283324887-sumproduct-and-if-statement-together-743441_jsohng_book3
Sheet: Sheet1

 | Results | 4
[NAME] | Product | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | State |  |  |  | original results
3 | Prodcut A | 109 | 85 | 124 | 113 | 85 | 63 | NY |  |  |  | Porudct A | 109 | 85 | 124 | 113 | 85 | 63 | NY
2 | Prodcut A | 49.2 | 63.9 | 58.8 | 80 | 39 | 47 | NJ |  |  |  | Porudct A | 49.2 | 63.9 | 58.8 | 80 | 39 | 47 | NJ
5 | Product B | 3.2 | 4.5 | 7.5 | 9.5 | 5.5 | 3.5 | NJ |  |  |  | Product B | 4 | 6 | 8 | 7 | 5 | 3 | NY
4 | Product B | 4 | 6 | 8 | 7 | 5 | 3 | NY |  |  |  | Product B | 3.2 | 4.5 | 7.5 | 9.5 | 5.5 | 3.5 | NJ
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: FO-D2

LAKE CUMBERLAND - October 17th, 2021
ANGLER | FISH CT. | WGTS. LBs | BIG BASS
 | 0 | 0 | 0
 | 1 | 0.77 | 0
 | 1 | 1.56 | 1.56
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 2 | 2.06 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 1 | 0.78 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
 | 0 | 0 | 0
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 2952 | 1533 | 2254 | 2459 | 6621 | 3163 | 1929 | 132 | 21043
Spreadsheet: 884438d1733579502-adding-additional-sort-in-filter-sortby-sample
Sheet: Sheet2

Answer:
City | Sales | Classification | Grade
NY | 7 | VS | A+ |  |  | 5 | VS | A+
NY | 5 | VS | A+ |  | NY | 7 | VS | A+
London | 1.5 | VS | A+ |  | London | 1.5 | VS | A+
Berlin | 4.5 | VS | A |  | Berlin | 4.5 | VS | A
Hong Kong | 0.5 | VS | C |  | Hong Kong | 0.5 | VS | C
Seattle | 0.3 | VB | A |  | Seattle | 0.3 | VB | A
LA | 3 | VB | A- |  | LA | 3 | VB | A-
Paris | 1.2 | VB | B |  | Paris | 1.2 | VB | B
Milan | 1 | VB | B |  | Milan | 1 | VB | B
Toronto | 0.7 | VB | B- |  | Toronto | 0.7 | VB | B-
Madrid | 2 | VB | C |  | Madrid | 2 | VB | C
Spreadsheet: d484e071-5052-43f8-b6ea-0a4477107a36
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
43239121 | 2014-09-20 18:00:43 | ALLIES | 1 | 5 | 1 | 544101 | Haldeus | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43239294 | 2014-09-20 18:19:40 | AXIS | 1 | 5 | 1 | 544101 | Haldeus | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
Spreadsheet: 808261d1670373388-product-of-two-columns-if-column-a-is-entry-is-text-get-value-from-another-column-excelforum-short-solution
Sheet: Sheet1

entry with possible text
 |  | all numbers | all numbers
abc |  | 2 | 3
2 |  | 3
3 |  | 4
4 |  | 5
abc |  | 6 | 2.5
3 |  | 7
4 |  | 8
TOTAL | 112 | <- one formula
Spreadsheet: 686023d1594315831-help-writing-a-function-to-use-a-data-table-based-on-value-budget-style-proposal-1-aligw
Sheet: Sheet1

 | INPUT CELLS IN YELLOW ONLY
 |  |  |  |  |  |  |  |  | Up to
 | Annual Target ($) |  | 4980000 |  | Commission Tiers |  | % of target: |  | 0.5 | 0.75 | 1 | 1.25 | 1.5 | 1.75 | 2 | 2.25 | Over
 | Target Gross Proffit |  | 0.5 |  |  |  | Commission Rate: |  | 0.05 | 0.055 | 0.06 | 0.075 | 0.08 | 0.085 | 0.09 | 0.095 | 0.1
 |  |  |  |  |  |  |  |  | Min Rate |  |  | Target Rate |  |  |  |  | [NAME]
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total | Check
 | Monthly Budget |  |  | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000 | 415000
 | Actual Sales |  |  | 319881.64 | 151329.47 | 139143.8 | 173303.25 | 137659.99 | 175759.94
 | Cumulative for year
 | Target ($)
 | Actual ($) |  |  | 319881.64 | 151329.47 | 139143.8 | 173303.25 | 137659.99 | 175759.94
 | % of target
 |  |  | Up to
 | Commission Rate Calculation:
 |  |  | Actual
 | Actual Sales |  |  | 319881.64 | 151329.47 | 139143.8 | 173303.25 | 137659.99 | 175759.94
 | Commission Rate
 | Pre-Commission Payable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G.P. | Comm. Rate
 | Gross Profit |  |  | 0.55 | 0.52 | 0.45 | 0.5 | 0.51 | 0.4 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2 | 0.55
 | Gross Profit Commission Rate |  |  |  | 1 | 0.85 | 1 | 1 | 0.7 |  |  |  |  |  |  |  |  | 0.3 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.85
 | Total Commision Payable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6 | 1.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7 | 1.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8 | 1.5
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-77,174

 |  |  |  |  |  |  |  | 7-077   7-174
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 575c73f2-96b2-4578-b964-3f8adb695297
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BEETS | Test | BEETS | Beets (Beetroot), IgE | Beets (Beetroot), IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BEETS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BEETS | Result | BEETS | Beets (Beetroot), IgE | Beets (Beetroot), IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 19728-5
Spreadsheet: 874873d1721380775-a-dv-list-that-pulls-information-from-a-second-sheet-populates-multiple-rows-kimmeyer-agent-charges-example-aligw
Sheet: Costing Sheet

Customer |  |  | Date
Reference
Country
No. of Containers | 8
Agent / Shipping Line | L & S / M
Agent / Shipping Line | Description | Unit | Unit Cost | Amount
 |  | 1
 | Cargo Dues |  | 0
 | Export Services |  | 0
 | Container Seal |  | 0
 | THC |  | 0
 | AMS Filing |  | 1
 | Miscellaneous |  | 0
 | Certificate of Origin |  | 1
 | Amendment fee |  | 1
Spreadsheet: 45597d1244393978-excel-2007-timesheet-formula-schedule
Sheet: Sheet1

 |  | Leah | [NAME] | [NAME] | Yvonne | [NAME] |  | Natalia
Saturday | 2009-05-30 00:00:00 | OFF | 9-6 | 9-6 | OFF | OFF |  | 10-6
Sunday | 2009-05-31 00:00:00 | 9-6 | OFF | OFF | OFF | 9-6 |  | 2-6
Monday | 2009-06-01 00:00:00 | 12-9 | OFF | 8-5 | 10-2 | 9-3 |  | 5-9
Tuesday | 2009-06-02 00:00:00 | 8-5 | 8-5 | 12-9 | OFF | 12-9 |  | OFF
Wednesday | 2009-06-03 00:00:00 | 8-5 | 10-7 | 8-5 | OFF | 12-9 |  | OFF
Thursday | 2009-06-04 00:00:00 | 8-5 | 12-9 | 8-5 | 4-8 | 9-11 |  | 5-9
Friday | 2009-06-05 00:00:00 | OFF | 9-6 | OFF | 10-5 | 9-5:30 |  | OFF
Total
Saturday | 2009-06-06 00:00:00 | OFF | 9-6 | OFF | 10-6 | OFF |  | 10-6
Sunday | 2009-06-07 00:00:00 | 9-6 | OFF | OFF | OFF | 9-5 |  | 9-6
Monday | 2009-06-08 00:00:00 | 12-9 | OFF | 8-5 | 10-2 | 9-5 |  | 5-9
Tuesday | 2009-06-09 00:00:00 | V | V | 12-9 | 5-9 | 9-5:30 |  | OFF
Wednesday | 2009-06-10 00:00:00 | 8-5 | V | 8-5 | 5-9 | 12-9 |  | OFF
Thursday | 2009-06-11 00:00:00 | 8-5 | 12-9 | 12-5 | 4-8 | OFF |  | V
Friday | 2009-06-12 00:00:00 | OFF | 9-6 | 9-6 | OFF | 9-5:30 |  | OFF
Total
Spreadsheet: louise_kitchen__22728__0201MarginRequirements
Sheet: 0108

FUTURES MARGIN REQUIREMENTS
2002-01-09 00:00:00
2002-01-08 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$ |  | US $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | TE | Initial Margin | OTE
ABN-Amro Inc | 148571.6360000279 |  | 148571.6360000279 | 0 | 0 |  | 0 |  |  |  | 148571.6360000279 |  |  |  | 0
ADM INVESTOR | 0.1990000053192489 |  | 0.1990000053192489 | 0 | 0 |  | 0 |  |  |  | 0.1990000053192489 |  |  |  | 0
BANK ONE | 0.2200000286102295 |  | 0.2200000286102295 | 0 | 0 |  | 0 |  |  |  | 0.2200000286102295 |  |  |  | 0
CARR FUTURES (NG) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
CARR FUTURES INC. | 4376826.224138597 |  | 4376826.224138597 | 0 | 744133.58 |  | 744133.58 |  |  |  | 3632692.644138597 |  |  |  | 122133.175
CREDIT SUISSE FIRST BOSTON | 29866.61000000313 |  | 29866.61000000313 | 0 | 0 |  | 0 |  |  |  | 29866.61000000313 |  |  |  | 0
EDF MAN | 8383992.715999773 |  | 8383992.715999773 | 0 | 0 |  | 0 |  |  |  | 8383992.715999773 |  |  |  | 0
FIMAT | 2272696.17 |  | 2272696.17 | 0 | 0 |  | 0 |  |  |  | 2272696.17 |  |  |  | 0
HSBC - US$ | -2131.681408999983 |  | -2131.681408999983 | 0 | 0 |  | 0 |  |  |  | -2131.681408999983 |  |  |  | 0
HSBC - Canadian | 0 |  | 0 | 0 |  |  | 0 |  |  |  | 0 |  | 64204.5 | 0 | 0
JP Morgan | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
[NAME] | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
PARIBAS | 80371717.16000006 |  | 80371717.16000006 | 0 | 0 |  | 0 |  |  |  | 80371717.16000006 |  |  |  | 0
PRUDENTIAL SI | -0.09857879066839814 |  | -0.09857879066839814 | 0 | 0 |  | 0 |  |  |  | -0.09857879066839814 |  |  |  | 0
REFCO, INC | 0.2590000069403686 |  | 0.2590000069403686 | 0 | 0 |  | 0 |  |  |  | 0.2590000069403686 |  |  |  | 0
R J O'BRIEN | 0.1799999999930151 |  | 0.1799999999930151 | 0 | 0 |  | 0 |  |  |  | 0.1799999999930151 |  |  |  | 0
SAUL STONE & COMPANY | 0.180000000000291 |  | 0.180000000000291 | 0 | 0 |  | 0 |  |  |  | 0.180000000000291 |  |  |  | 0
SMITH BARNEY, INC | 53592.45999999158 |  | 53592.45999999158 | 0 | 0 | 0 | 0 |  |  |  | 53592.45999999158 |  |  |  | 0
SMITH BARNEY, INC  (Financial) | 0 |  | 0 | 0 | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS | 95635132.23415071 | 0 | 95635132.23415071 | 0 | 744133.58 | 0 | 744133.58 |  | 0 |  | 94890998.65415071 |  | 64204.5 | 0 | 122133.175
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS | 95635132.23415071
 |  |  |  |  |  |  |  |  |  |  |  |  | 94890998.65415071
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0 | 0 | 0 | 50000000
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 702857d1604577264-excel-locate-value-in-a1-locate-it-in-page-2-and-find-the-data-from-a-row-next-to-it-excel-example
Sheet: Comparison

Users not found DB to Web |  | DB to Export Comparison |  |  | DB TM | System Team Manager |  |  | Do managers match
 |  |  |  | *Wrong
Managers wrong from DB to Web
 |  |  |  | *Wrong
 |  |  |  | *Wrong
Spreadsheet: phillip_m_love__30632__9911 Texas FRED
Sheet: AVar

TAGG | GL Amount | [NAME] | [NAME] |  | Desk Adjustment | GL Adjustment/Reclass | Comments
EK1314.1 | 100000 | 0 |  | tsf to central
 |  | 0
E33520.B | 6162.84
E33520.9 | 12672
E07001.7 | 49492.53
Grand To | 3013048.78
Spreadsheet: 3bc54835-d87b-4560-b470-4a2f3eb94f67
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RCTUR | Test | RCTUR | Creatinine, Random, [NAME] | Creatinine, Random, U | Enzymatic Colorimetric Assay | Plastic, urine tube: PlUrTb |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | No established reference values | Monday through Sunday; Continuously | 1 day | 1 day | 1 | 82570 |  |  |  |  | Rochester
RCTUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
RCTUR | Result | RCTUR | Creatinine, Random, U | Creatinine, Random, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2161-8
Spreadsheet: 745184d1629799163-extracting-date-from-different-text-values-extract-date-from-text
Sheet: Input

 |  |  |  | Flights | Date | Airport |  | Airports
 |  |  |  | Outbound |  | HAV |  | HAV
 |  |  |  | Return |  |  |  | HOG
 |  |  |  | Additional Destination |  |  |  | VRA
 |  |  |  |  |  |  |  | SDQ
 |  |  |  | The formula should show the first date (Thursday 25 August 2022), if the location is either Jamaica, Dominican Republic or Bahamas |  |  |  | KIN
 |  |  |  |  |  |  |  | NAS
 |  |  | Trip Start | 2022-08-20 00:00:00
 | Day | Season | Date | Location
 |  | Names4Refernces | Date | Location
 | 1 |  |  | Havanna
 |  |  |  | Havanna
 |  |  |  | Havanna
 |  |  |  | Havanna
 |  |  |  | Havanna
 |  |  |  | Jamaica | OR Dominican Republic | OR Bahamas
 |  |  |  | Jamaica
 |  |  |  | Jamaica
 |  |  |  | Return Flight
Spreadsheet: 38596d1236761675-summarizing-data-over-several-sheets-bolts-20list-1-
Sheet: BoltsP3

 | BOLTS LIST | BOLTS LIST
CLIENT |  | 0 |  |  |  | JOB No. |  | A
PLANT |  | 0 |  |  |  |  | LIST No.   3   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
39 | 6 |  | 5 | M20 | 35
40 | 14 |  | 26 | M20 | 45
41 | 18 |  | 45 | M10 | 35
42 | 14 |  | 96 | M12 | 35
43 | 8 |  | 12 | M8 | 25
44 | 50 |  | 23 | M30 | 95
45 | 12 |  | 58 | M12CSK | 35
46 | 34 |  | 15 | M30CSK | 80
47 | 20 |  | 55 | M24 | 55
48 | 56 |  | 45 | M20CSK | 85
49 | 14 |  | 75 | M20CSK | 45
50 | 6 |  | 23 | M8 | 20
51 | 54 |  | 65 | M16 | 80
52 | 12 |  | 40 | M12 | 35
53 | 18 |  | 10 | M10CSK | 35
54 | 20 |  | 2 | M12 | 40
55 | 66 |  | 9 | M20CSK | 95
56 | 20 |  | 78 | M30CSK | 65
57 | 6 |  | 12 | M16 | 30
Spreadsheet: 691236d1597582697-4-conditions-to-complete-to-reach-the-target-value-help0816-1
Sheet: Sheet3

A | B | C | D | Target |  |  | A | B | C | D | Target
>= | >= | <= | >= |  |  |  | 700 | 0.991 | 9 | 95 | 800
1000 | 0.97 | 20 | 90 | 2000 |  |  | 1000 | 1 | 15 | 95 | 2000
800 | 0.985 | 15 | 92 | 1000 |  |  | 800 | 0.985 | 15 | 92 | 1000
500 | 0.99 | 10 | 95 | 800
 |  |  |  |  |  |  |  |  |  |  | FINAL RESULT
Spreadsheet: 52166d1251878726-sum-formula-with-multiple-criteria-example-1-
Sheet: Sheet1

Employee | Category ID | Category | Hours |  |  | Total Hours
SMITH JOHN | 208279 | Training | 2 |  |  | Training | [NAME] | Maintenance
SMITH JOHN | 208501 | Training | 2 |  | SMITH JOHN | 6 | 16 | 22.5
SMITH JOHN | 208579 | Training | 2 |  | JONES [NAME] | 34 | 25.5 | 0
SMITH JOHN | 891578 | [NAME] | 4 |  | [NAME] | 0 | 0 | 20.5
SMITH JOHN | 891578 | [NAME] | 4 |  | [NAME] | 0 | 34 | 22.5
SMITH JOHN | 891578 | [NAME] | 4
SMITH JOHN | 891578 | [NAME] | 4
SMITH JOHN | 904601 | Maintenance | 5 |  | If SMITH JOHN equals TRAINING then return the total number of hours for TRAINING (and so on)
SMITH JOHN | 904601 | Maintenance | 13.5
SMITH JOHN | 904601 | Maintenance | 4
JONES [NAME] | 891578 | [NAME] | 8.5
JONES [NAME] | 891578 | [NAME] | 8.5
JONES [NAME] | 891578 | [NAME] | 8.5
JONES [NAME] | 208279 | Training | 8.5
JONES [NAME] | 208501 | Training | 8.5
JONES [NAME] | 208579 | Training | 8.5
JONES [NAME] | 209221 | Training | 8.5
[NAME] | 904601 | Maintenance | 13.5
[NAME] | 904601 | Maintenance | 4
[NAME] | 904604 | Maintenance | 3
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 891578 | [NAME] | 8.5
[NAME] | 904601 | Maintenance | 5
[NAME] | 904601 | Maintenance | 13.5
[NAME] | 904601 | Maintenance | 4
Spreadsheet: 872064d1718427567-automation-of-rotating-rows-test-excel_2-aligw
Sheet: Sheet1

Name | Date | Information |  |  |  | Name | Date | Information |  |  | Date | Information
[NAME] | 2023-08-01 00:00:00 | follow up 12/1 |  |  |  |  |  |  |  | [NAME] | 2024-06-01 00:00:00 | stop payment
[NAME] | 2024-01-01 00:00:00 | follow back 6/2 |  |  |  |  |  |  |  | [NAME] | 2024-01-01 00:00:00 | follow back 6/2
[NAME] | 2023-02-09 00:00:00 | success |  |  |  |  |  |  |  | Nate | 2023-12-15 00:00:00 | call back Thursday
[NAME] | 2024-06-01 00:00:00 | stop payment |  |  |  |  |  |  |  | [NAME] | 2023-08-01 00:00:00 | follow up 12/1
Nate | 2023-12-15 00:00:00 | call back Thursday |  |  |  |  |  |  |  | [NAME] | 2023-02-09 00:00:00 | success
Spreadsheet: sally_beck__33972__Cut_Over_Calendar
Sheet: April 2001

APRIL 2001
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 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
Spreadsheet: 851787d1701922230-having-a-cell-return-a-value-of-another-cell-based-on-the-value-of-the-referenced-cell-send
Sheet: Sheet1

MNQ | 0.56
MES | 0.56
NQ | 2.09
ES | 2.04
OUTPUT
MNQ | 0.56 |  |  | (IF A14 = MNQ THEN CELL B14 = CELL B1) OR (IF A14 = MES THEN CELL 14 = CELL B2) OR (IF A14 = NQ THEN CELL 14 = CELL B3) OR (IF A14 = ES THEN CELL 14 = CELL B4)
MES | 0.56 | 0.56
NQ | 2.09 | 2.09
ES | 2.04 | 2.04
Spreadsheet: 141966d1329549244-if-formula-not-recognising-blank-cells-in-data-column-dates
Sheet: Sheet1

Data | [NAME]
2012-03-12 00:00:00
2012-03-13 00:00:00
2012-03-14 00:00:00
2012-03-15 00:00:00
2012-03-16 00:00:00
2012-03-17 00:00:00
2012-03-18 00:00:00
2012-03-20 00:00:00
2012-03-21 00:00:00
2012-03-22 00:00:00
2012-03-24 00:00:00
2012-03-25 00:00:00
2012-03-26 00:00:00
2012-03-27 00:00:00
Red
White
Green
Spreadsheet: 129835d1321915921-excel-2007-averaging-a-column-with-div-0-errors-avewithdiverror
Sheet: Sheet1

LEA ID | Grant award | Spent | Amount remaining (%)
1 | 400000 | 400000
2 | 150000 | 100000
3 | 1200000 | 1050000
4 | 1300000 | 1200000
5
6 | 750000 | 740000
7 | 350000 | 335000
8 | 400000 | 380000
9 | 875000 | 800000
10 | 1100000 | 950000
11 | 275000 | booger
12 | 500000 | 400000
13 | 450000 | 435000
14 | 2000000 | 1600000
15 | 2100000 | 1700000
16 | 925000 | 900000
17 | 1800000 | 0
18 | 650000 | 625000
19 | 700000 | 690000
20 | 425000 | 420000
21 | 380000 | 375000
22 | 825000 | 815000
Totals
average
Spreadsheet: 51924d1251495976-drag-fill-skipping-a-lot-of-rows-updated-psp-outreach-report-template-08-25-09-fs
Sheet: April

 |  | Week of 3/29 - 4/04 | Week of 4/05 - 4/11 | Week of 4/12 - 4/18 | Week of 4/19 - 4/25
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
Spreadsheet: 0e61d776-a606-4f84-818f-c51ed517cbe8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | QUICK REFERENCE VENDOR LIST
Kansas City Audio Visual |  |  |  |  |  | Office Depot - Furniture Division
 | Audio-Visual and Instructional Technology Equipment |  |  |  |  |  | School, Church, Business, Dorm  Furniture, Design Serv
 | [NAME] |  |  |  |  |  | [NAME], Solutions Development Manager
 | [EMAIL] |  |  |  |  |  | [EMAIL]
 | (800) 798-5228 phone |  |  |  |  |  | (763) 513-4040 phone
 | (816) 333-2152 fax |  |  |  |  |  | (763) 513-4017 fax
 | www.kcav.com |  |  |  |  |  | www.business.officedepot.com/furniturecatalog
RICOH |  |  |  |  |  | Protect My Ministry
 | Document management, scan/print/fax/copy systems |  |  |  |  |  | Background Checks
 | Wade Civey, National Account Executive |  |  |  |  |  | [NAME], Service Representative
 | [EMAIL] |  |  |  |  |  | [EMAIL]
 | (636) 736-1404 phone |  |  |  |  |  | (800) 319-5582 x226 phone
 | (636) 736-1015 fax |  |  |  |  |  | (800) 319-5582 fax
 | www.ikon.com |  |  |  |  |  | www.protectmyministry.com/lcms
iml, a Computershare company |  |  |  |  |  | Office Depot
 | Audience response products & annual meeting services |  |  |  |  |  | Office/janitorial supplies, a/v equip, copiers/printers
 | [NAME], VP, IML North America |  |  |  |  |  | [NAME], Account Manager II
 | [EMAIL] |  |  |  |  |  | [EMAIL]
 | (612) 371-4428 phone |  |  |  |  |  | (800) 613-4624 x5014 phone
 | (612) 371-0010 fax |  |  |  |  |  | (636) 230-8497 fax
 | www.imlworldwide.com |  |  |  |  |  | bsd.officedepot.com
Journey Education Marketing, Inc. |  |  |  |  |  | RegOnline
 | Software and Computer Peripherals |  |  |  |  |  | Event Management
 | [NAME], Midwest Territory Manager |  |  |  |  |  | [NAME], New Account Specialist
 | [EMAIL] |  |  |  |  |  | [EMAIL]
 | (866) 559-0302 phone |  |  |  |  |  | (888) 351-9948 x5127 phone
 | (866) 759-9774 fax |  |  |  |  |  | (303) 577-5101 fax
 | http://lcms.academicsuperstore.com |  |  |  |  |  | www.regonline.com
TAPCO (Traffic & Parking Control Co.) |  |  |  |  |  | Color Art/Steelcase
 | Traffice Control & Parking Lot |  |  |  |  |  | Furnishings
 | [NAME] Account Manager |  |  |  |  |  | [NAME], Account Manager
 | [EMAIL] |  |  |  |  |  | [EMAIL]
 | (800) 236-0112 phone |  |  |  |  |  | (314) 423-2340 232 phone
 | (800) 444-0331 fax |  |  |  |  |  | (314) 993-2752 fax
 | www.tapconet.com |  |  |  |  |  | www.color-art.com
 |  |  |  |  |  |  |  | QUICK REFERENCE VENDOR LIST
[NAME]
 | [NAME], Vice President Affinity Sales
 | [EMAIL]
 | (800) 248-8313 phone
 | (989) 755-0511 fax
 | www.stevensworldwide.com/lcms
Bekins & Wheaton Van Lines Managed by WorldwideWorldwide Relocation
 | Bekins, Wheaton Van Lines
 | [NAME], National Account Manager
 | [EMAIL]
 | (866) 275-7422 phone
 | (919) 938-0039 fax
 | www.lcmsmove.com