tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 145387d1331565006-index-match-several-sheets-to-one-formula-vml
Sheet: tab4

1.14 |  |  | Dep Date |  |  |  |  |  | 2011-05-02 00:00:00 | 2011-04-28 00:00:00 | 2011-05-05 00:00:00 | 2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00 | 2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-07 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00 | 2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00 | 2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00 | 2011-10-06 00:00:00 | 2011-10-13 00:00:00
RETREAT |  |  | W/c Date |  | 2011-04-02 00:00:00 | 2011-04-09 00:00:00 | 2011-04-16 00:00:00 | 2011-04-23 00:00:00 | 2011-04-30 00:00:00 | 2012-05-05 00:00:00 | 2012-05-12 00:00:00 | 2012-05-19 00:00:00 | 2012-05-26 00:00:00 | 2012-06-02 00:00:00 | 2012-06-09 00:00:00 | 2012-06-16 00:00:00 | 2012-06-23 00:00:00 | 2012-06-30 00:00:00 | 2012-07-07 00:00:00 | 2012-07-14 00:00:00 | 2012-07-21 00:00:00 | 2012-07-28 00:00:00 | 2012-08-04 00:00:00 | 2012-08-11 00:00:00 | 2012-08-18 00:00:00 | 2012-08-25 00:00:00 | 2012-09-01 00:00:00 | 2012-09-08 00:00:00 | 2012-09-15 00:00:00 | 2012-09-22 00:00:00 | 2012-09-29 00:00:00 | 2012-10-06 00:00:00 | 2012-10-13 00:00:00 | 2012-10-20 00:00:00 | 2012-10-27 00:00:00 | Total | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | Total
PVK |  |  |  |  | 1 | 1 | 1 | 1 | 5 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 9 | 10 | 10 | 10 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1351381435649473 | 0.2054969455932618 | 0.2413363815976073 | 0.1914861486558798 | 0.125869386602962 | 0.07844534801114378 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Costs | Transfers | -24.56140350877193 |  |  |  |  |  |  | 0 | -3682.147368421053 | -3682.147368421053 | -3682.147368421053 | -3682.147368421053 | -4178.582456140351 | -3949.4 | -3949.4 | -3746.866666666667 | -3833.666666666667 | -3833.666666666667 | -3444.589473684211 | -3444.589473684211 | -3444.589473684211 | -3388.16947368421 | -3388.16947368421 | -3388.16947368421 | -2426.802368421053 | -3681.009086561453 | -3681.009086561453 | -3681.009086561453 | -2911.13553726497 | -3022.302197387299 | -3400.047368421053 | -3400.047368421053 | -3400.047368421053 | -2895.236842105264 | -91217.09508205594 | -3682.147368421053 | -15225.02456140351 | -19313 | -13721.93789473684 | -12884.15040235093 | -16695.50327619623 | -9695.33157894737 | -91217.09508205594 | 0
 | Handling | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 175634d1345584758-formula-to-insert-the-number-of-hours-per-month-book1
Sheet: Sheet1

 | 4.33 |  | Jul 1 - Jul 31 | Aug 1 - Aug31 | Sept 1 - Sept 30 | Oct 1 - Oct 31 | Nov 1 - Nov 30 | Dec. 1 - Dec 31
Hours/week | start | end
32 | 05/31/11 | 04/07/12 | 138.56 | 138.56 | 138.56 | 138.56 | 138.56 | 138.56
38 | 06/28/11 | 04/19/12 | 164.54 | 164.54 | 164.54 | 164.54 | 164.54 | 164.54
32 | 08/23/11 | 08/08/12 |  | 138.56 | 138.56 | 138.56 | 138.56 | 138.56
32 | 11/01/11 | 08/08/12
40 | 08/08/11 | 01/03/13 |  | 173.2 | 173.2 | 173.2 | 173.2 | 173.2
40 | 01/10/12 | 10/16/12 | 173.2 | 173.2 | 173.2 | 173.2 | 173.2 | 173.2
Spreadsheet: 801121d1666093166-next-available-sequential-number-dependant-on-two-additional-variables-doc_register_001
Sheet: Sheet1

 | Group | Document Type | Document Number | Document Title | Date Released | Next Scheduled Review | DAYS
 | Group-A | Type-A | 0
 | Group-B | Type-A | 0
 | Group-A | Type-A | 1
 | Group-A | Type-A | 2
 | Group-A | Type-A | 3
 | Group-B | Type-B | 0
 | Group-B | Type-B | 0
 | Group-B | Type-B | 0
 | Group-A | Type-B | 0
 | Group-A | Type-B | 1
Spreadsheet: 824138d1680332840-get-data-from-other-files-2023001
Sheet: Specificatie

 | Project | aantal | tarief | totaal
 | task 1 | 2 | 50
 | task 2 | 5 | 50
 | task 3 | 6 | 50
 | task 4 | 24 | 50
 | task 5 | 28 | 50
Spreadsheet: 41339d1239811751-identify-list-and-sum-2-columns-test-time-sheet
Sheet: Dec 29-Jan 3

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB [NAME]
2008-12-29 00:00:00 | 06:30:00 | 03:00:00 | 8 | SHOP | 8
2008-12-30 00:00:00 | 06:30:00 | 12:00:00 | 5.5 | SHOP
 | 12:30:00 | 03:00:00 | 2.5 | VAC | 8 | VACATION
2008-12-31 00:00:00 | 06:30:00 | 10:30:00 | 4 | 28114 |  | CNC M
 | 10:30:00 | 03:00:00 | 4 | 28115 | 8 | CNC M
2009-01-01 00:00:00 |  |  | 8 |  | 8 | HOLIDAY
2009-01-02 00:00:00 |  |  | 8 |  | 8 | VACATION
 |  |  |  |  |  |  |  |  | VACATION 54.5 HRS
 |  | SHOP | 13.5
 |  | 28114 | 4
 |  | 28115 | 4
 |  | VACATION | 10.5
 |  | HOLIDAY | 8
 |  |  | 40 | TOTAL | 40
Spreadsheet: 197877d1354594002-automatically-enter-time-and-date-sign-out-log
Sheet: Sheet1

DON'T COPY CELLS/CLEAR MONTHLY
Date | Initial | Name | Time Out | Radio | Key | Comments/Other | Initial | Time In
2012-12-03 00:00:00 | JPH | POL 1 | 2012-12-03 15:24:17 | 10
2012-12-03 00:00:00 | JPH | CALLAHAN | 2012-12-03 15:25:08 | 8 |  |  | JPH | 09:49:00
Spreadsheet: 87960d1287840563-display-more-data-after-selecting-from-drop-down-box-tropico-3
Sheet: Salaries

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uneducated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unlisted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Builders
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dockworkers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teamsters
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tenements
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High School
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unlisted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soldiers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teachers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apartments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | College
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unlisted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Generals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Professors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Condos
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inflation | 0
Spreadsheet: 732671d1621142774-pull-from-row-from-one-sheet-to-another-array-formula-test
Sheet: Piped Files for Review

 | Date | Time | LO Name | Loan Number | Borrower's Name | LOA | Task | Status | Date Completed | Time Completed
Spreadsheet: 800659d1665777931-nesting-two-ifs-sample
Sheet: Sheet1

Heat Detector | 1 |  | [NAME] (MMF) | *this s/b 1
Smoke Detector | 2 |  | [NAME] Stair 1 | *s/b 2
Heat Detector | 3 |  | [NAME] Stair 1 | *s/b 3
Smoke Detector | 4 |  | 5th Floor by 511 | *s/b 4
Pull Station | 5 |  | 5th Floor by 503 |  | This is correct
[NAME] | 6 |  |  |  | This is correct
Spreadsheet: 212485d1360149999-2-combo-boxes-to-select-row-and-column-5s-plant-entry
Sheet: RoadMap

 |  | Area | Areas Included |  |  |  |  |  |  |  | Score |  | Legend
 |  | 1 | New Hall WIP, [NAME], Empty Pallet Store, Stores Office
 |  | 2 | Docks, Dream WIP, Warehouse
 |  | 3 | 100 Pce & 50 Pce |  |  |  |  |  |  |  |  |  |  | Red Tag Area
 |  | 4 | 20 Pce, Reject/Rework
 |  | 5 | Dream, AH04, |  |  |  |  |  |  |  |  |  |  | Above Target
 |  | 6 | Blending Office, Drum, [NAME], HerbStore
 |  | 7 | Tea Delivery Bays, [NAME] |  |  |  |  |  |  |  |  |  |  | Below Target
 |  | 8 | Work In Progress, Walkway
 |  | 9 | Engineer Stores, Engineer Workshop |  |  |  |  |  |  |  |  |  |  | Area Not Started
 |  | 10 | Manufacturing Offices
 |  | 11 | Building 2 |  |  |  |  |  |  |  |  |  |  | Contractors Work Area
 |  |  |  |  |  |  |  |  |  |  |  |  | Target = 70%
 |  |  |  | 5s Site Map
Spreadsheet: 121426d1316045123-excel-2007-references-to-ranges-sending-coopy
Sheet: Invoice tracking

Invoice Range
From | To | Name
126260 | 126500 | Armando
124920 | 125000 | Stone
126001 | 126137 | Stone
126138 | 123259 | [NAME]
124716 | 124750 | Manuel
122904 | 123415 | Rene
126502 | 126674 | [NAME]
122001 | 122198 | Armando
122401 | 122658 | Mark
122659 | 122903 | [NAME]
122199 | 122400 | [NAME]
123363 | 123634 | Stone
123635 | 123872 | [NAME]
123873 | 124000 | Kee
125001 | 125139 | Kee
125140 | 125382 | Rod
125501 | 125746 | Leonore
125383 | 125500 | Joy
124001 | 124206 | Armando
126907 | 127050 | Joy
Spreadsheet: 814840d1674632677-comapre-2-lists-report-on-whats-not-inclusive-comapre2lists
Sheet: Sheet2

 | MID2 | Exists
 | A
 | C
 | L
 | L
 | M
 | G
 | M
 | B
 | Q
 | G
 | B
 | A
 | K
 | X
Spreadsheet: benjamin_rogers__1192__test model from Erin
Sheet: 144A FCF

Free Cash Flows |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | 2002-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-07-01 00:00:00 | 2005-07-01 00:00:00 | 2006-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-07-01 00:00:00 | 2012-07-01 00:00:00 | 2013-07-01 00:00:00 | 2014-07-01 00:00:00 | 2015-07-01 00:00:00 | 2016-07-01 00:00:00 | 2017-07-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00
Cash To(From) Equity from Draw
Cash To Equity from Ops |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0
TOTAL FCF
XNPV |  |  |  |  |  |  | [NAME]
XIRR |  |  |  |  |  |  | 0
Spreadsheet: c75abfdd-fc31-4a86-9bf7-e78d8d84e4fc
Sheet: Region Data

Idaho Department of Health and Welfare Division of Behavioral Health
Mental Health Public Dashboard for July, 2014
* means on report is that count is less then 5, for details please contact  Idaho Department of Health and Welfare Central Office.
Report Run Date: 8/15/2014
 |  | Mental Health Dashboard |  | Region 1 | Region 2 | Region 3 | Region 4 | Region 5 | Region 6 | Region 7 | State Wide
Admission / Discharge | Monthly | Adult Mental Health | AMH Admission | 15 | 7 | 21 | 39 | 13 | 11 | 21 | 127
 |  |  | AMH Discharge | 16 | 9 | 16 | 41 | 6 | 8 | 14 | 110
 |  | Children Mental Health | CMH Admission | 10 | 10 | 5 | 10 | 11 | 7 | 7 | 60
 |  |  | CMH Discharge | 11 | 14 | 6 | 19 | * | 13 | 20 | 87
 | SFY 2015 | Adult Mental Health | AMH Admission | 15 | 7 | 21 | 39 | 13 | 11 | 21 | 127
 |  |  | AMH Discharge | 16 | 9 | 16 | 41 | 6 | 8 | 14 | 110
 |  | Children Mental Health | CMH Admission | 10 | 10 | 5 | 10 | 11 | 7 | 7 | 60
 |  |  | CMH Discharge | 11 | 14 | 6 | 19 | * | 13 | 20 | 87
Adult Mental Health | Number of adult served this Month |  |  | 364 | 181 | 618 | 693 | 225 | 221 | 495 | 2797
 | Number of adults served SFY 2015 |  |  | 364 | 181 | 618 | 693 | 225 | 221 | 495 | 2797
Children's Mental Health | Number of children served this Month |  |  | 67 | 63 | 95 | 141 | 100 | 49 | 154 | 669
 | Number of children served SFY 2015 |  |  | 67 | 63 | 95 | 141 | 100 | 49 | 154 | 669
Pre-Sentence Investigation Reports  (I.C. 19-2524) | Monthly |  |  | 21 | 6 | 65 | 41 | 48 | 19 | 26 | 226
 | SFY 2015 |  |  | 21 | 6 | 65 | 41 | 48 | 19 | 26 | 226
Spreadsheet: 871319d1717693373-how-to-cf-entire-row-cf-forum
Sheet: Sheet1

False | Holyoake Road | - | - | - | - | - | - | -
False | [NAME], Front Street stand 7 | - | - | - | 06:39:00 | - | 07:05:00 | - |  | What I have
True | [NAME], High Street, ASDA | - | - | - | 06:40:00 | - | 07:06:00 | -
False | High Street Avenue | - | - | - | 06:40:00 | - | 07:06:00 | -
False | [NAME] | - | - | - | 06:41:00 | - | 07:07:00 | -
False | [NAME], Sainsbury's | - | - | - | 06:41:00 | - | 07:07:00 | -
False | Portland Street | - | - | - | 06:42:00 | - | 07:08:00 | -
False | [NAME] | - | - | - | 06:43:00 | - | 07:09:00 | -
False | Thackeray's La, [NAME] | - | - | - | 06:45:00 | - | 07:11:00 | -
False | Holyoake Road | - | - | - | - | - | - | -
False | [NAME], Front Street stand 7 | - | - | - | 06:39:00 | - | 07:05:00 | -
True | [NAME], High Street, ASDA | - | - | - | 06:40:00 | - | 07:06:00 | - |  | What I need
False | High Street Avenue | - | - | - | 06:40:00 | - | 07:06:00 | -
False | [NAME] | - | - | - | 06:41:00 | - | 07:07:00 | -
False | [NAME], Sainsbury's | - | - | - | 06:41:00 | - | 07:07:00 | -
False | Portland Street | - | - | - | 06:42:00 | - | 07:08:00 | -
False | [NAME] | - | - | - | 06:43:00 | - | 07:09:00 | -
False | Thackeray's La, [NAME] | - | - | - | 06:45:00 | - | 07:11:00 | -
Spreadsheet: 145053d1331285612-giving-a-value-in-a-column-based-on-the-values-in-other-column-sample
Sheet: sheet 1

Column A | Column B
9XME8619
9XMS8960 | 9XMS8961
 |  |  |  |  |  | Hi , I have a data in column A and I want to put such a formula in column B that will give me my desired results , I only want to put data in front of 9XMS containing values of column A . Such that from top whenever 9XMS is found in column A in front of that in column B it will place the next 9XMS value .I will mark with arrows to let it simplified .
9XMS8961 | 9XMS8926
9XME8497
9XMS8926 | 9XMS8716
9XMS8716 | 9XMS8973
9XME8621
[NAME]
C030290
C029990
C030150
9XME8631
9XMS8973
Spreadsheet: 31808d1227767424-need-running-totals-in-columns-with-possible-corrupted-data-water-meter-reading
Sheet: Sheet3

WEDNESDAY AM |  | 2347371 |  | TARGET
THURSDAY AM |  | 2347601 | -230
FRIDAY AM |  |  | 2347601
SATURDAY AM |  |  | 0
SUNDAY AM |  |  | 0
MONDAY AM |  |  | 0
TUESDAY AM |  |  | 0
WEDNESDAY AM |  |  | 0
 |  | 2347371 | 2347371 | 2170
Spreadsheet: 804679d1668208261-need-a-between-and-if-i-think-between-and-if
Sheet: Sheet1

12
Min | [NAME]
1 | 5
6 | 10
11 | 15
16 | 20
21 | 25
Need to determine where to put value in A1 in the table
If [NAME] is less than the Min then display a 0
If [NAME] is also geater than [NAME], then display the [NAME]
If [NAME] is between the Min and [NAME], then display A1
Below is what I'm looking for…
Min | [NAME]
1 | 5 | 5
6 | 10 | 10
11 | 15 | 12
16 | 20 | 0
21 | 25 | 0
Spreadsheet: 272667d1382458451-display-minimum-value-in-array-minimum-bid-example
Sheet: Misc

Misc Specialties
 | Materials
Company | Wood Doors | Hardware | HM | Total Bid | Minimum Bid
Lowest Bid | 500 | 1800 | 500 |  | 3000
abc door | 1000 | 2000 | 500 | 3500
[NAME] | 800 | 1800 | 600 | 3200
commerical door | 3000 | * | * | 3000
specialty door | 500 | 1900 | 700 | 3100
Spreadsheet: 95117d1294789471-help-with-using-formulas-2011-new-sales
Sheet: Jan

Advisor | FC | Individual Life Premium |  | Individual Life Volume | Type |  | Asset Volume | Portal Bus. | Case Name
 |  | Large Case - Y | [NAME] |  | B/F/O
 | 58 | 7000
 | 28 | 5000
 | 118 |  | 3000
 | 118 | 6000
 |  | 18000 | 3000 | 0 | B - | 0 | 0 | 0
 |  | 3 | 1 | 0 | F - | 0 | 0 | 0
 | Total All Cases: | 21000 |  |  | O - | 0
 |  | 4 |  |  | Total - | 0
# L/C | # Not L/C | L/C Ind. Life Prem. | Ind. Life Prem. | Ind. Life. Vol. | B | F | O | Asset Vol. | # Asset Vol. | Portal Bus.
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
1 | 0 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 28
1 | 0 | 7000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 58
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 61
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 66
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 69
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 71
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 74
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 77
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 111
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 118
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 181
#N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A |  |  |  | #N/A
Spreadsheet: 724900d1616436685-use-datedif-to-count-the-total-between-days-in-a-range-example
Sheet: Sheet2

 |  | TODAYS DATE
Completed Date | Due Date |  |  |  | Overdue 1-30 | Overdue 30-60 | Overdue 60-90>
 | 2020-12-20 00:00:00 |  |  |  |  |  | 1 | Don’t need any of this                           <------
 | 2021-03-01 00:00:00 |  |  |  | 1
 | 2021-03-10 00:00:00 |  |  |  | 1
 | 2021-01-20 00:00:00 |  |  |  |  |  | 1
 | 2021-02-10 00:00:00 |  |  |  |  | 1
 | 2021-02-25 00:00:00 |  |  |  | 1
 | 2021-02-25 00:00:00 |  |  |  | 1
 | 2021-03-01 00:00:00 |  |  |  | 1
 | 2021-02-15 00:00:00 |  |  |  |  | 1
 | 2021-03-02 00:00:00 |  |  |  | 1
 | 2021-03-01 00:00:00 |  |  |  | 1
 |  | looking for this ---> |  |  | 7 | 2 | 2
 |  | record set changes offten more or less
Spreadsheet: 90226d1289988169-if-formula-based-on-menu-options-book2
Sheet: Sheet1

 |  | A |  | B
Starters |  | [NAME] |  | Plate of Smoked Salmon
 |  | Tomato & Basil Soup |  | Flamed Chicken Livers
 |  | Brussels Pate and Toast
Main |  | Roast Norfolk Turkey with all the trimmings
 |  | Seared Salmon Supreme with [NAME], Black Olive Tapanade and Pea Shoots
 |  | Open Roasted Vegetable Lasagne in a Neapolitan Sauce topped wtih [NAME]
Desert |  | Christmas Pudding and [NAME] |  | [NAME]
 |  | Traditional Sherry Trifle
 |  | Name | Starter | Main | Desert | Cost
 |  | [NAME] | Plate of Smoked Salmon | Roast Norfolk Turkey with all the trimmings | [NAME]
 |  | [NAME] | Brussels Pate and Toast | Open Roasted Vegetable Lasagne in a Neapolitan Sauce topped wtih [NAME] | [NAME]
 |  | [NAME] | Plate of Smoked Salmon | Roast Norfolk Turkey with all the trimmings | [NAME]
 |  | [NAME] | Brussels Pate and Toast | Seared Salmon Supreme with [NAME], Black Olive Tapanade and Pea Shoots | Traditional Sherry Trifle
 |  | [NAME] | Plate of Smoked Salmon | Open Roasted Vegetable Lasagne in a Neapolitan Sauce topped wtih [NAME] | [NAME]
 |  | [NAME] | Tomato & Basil Soup | Roast Norfolk Turkey with all the trimmings | Christmas Pudding and [NAME]
Spreadsheet: 842414d1694504023-formula-to-determine-of-years-with-a-purchase-for-each-customer-count-of-years-purchasing
Sheet: Sheet1

PersonID | FirstName | PurchaseDate | Price | #YrsWithPurchase
235 | [NAME] | 2005-06-15 00:00:00 | 86 | 1
234 | Amber | 2005-06-15 00:00:00 | 212 | 1
235 | [NAME] | 2006-06-21 00:00:00 | 20 | 2
234 | Amber | 2006-06-21 00:00:00 | 43 | 2
235 | [NAME] | 2007-05-18 00:00:00 | 195 | 3
234 | Amber | 2007-05-18 00:00:00 | 98 | 3
123 | [NAME] | 2008-11-21 00:00:00 | 27 | 1
124 | Bettie | 2008-11-21 00:00:00 | 48 | 1
123 | [NAME] | 2008-12-15 00:00:00 | 127 | 1
124 | Bettie | 2008-12-15 00:00:00 | 228 | 1
235 | [NAME] | 2009-06-21 00:00:00 | 68 | 4
234 | Amber | 2009-06-21 00:00:00 | 194 | 4
123 | [NAME] | 2010-03-15 00:00:00 | 18 | 2
124 | Bettie | 2010-03-15 00:00:00 | 81 | 2
235 | [NAME] | 2010-05-18 00:00:00 | 161 | 5
234 | Amber | 2010-05-18 00:00:00 | 198 | 5
123 | [NAME] | 2011-04-21 00:00:00 | 228 | 3
124 | Bettie | 2011-04-21 00:00:00 | 85 | 3
235 | [NAME] | 2012-04-15 00:00:00 | 154 | 6
234 | Amber | 2012-04-15 00:00:00 | 118 | 6
123 | [NAME] | 2012-05-15 00:00:00 | 199 | 4
124 | Bettie | 2012-05-15 00:00:00 | 84 | 4
235 | [NAME] | 2013-04-25 00:00:00 | 88 | 7
234 | Amber | 2013-04-25 00:00:00 | 43 | 7
235 | [NAME] | 2014-04-18 00:00:00 | 37 | 8
234 | Amber | 2014-04-18 00:00:00 | 153 | 8
123 | [NAME] | 2016-05-21 00:00:00 | 107 | 5
124 | Bettie | 2016-05-21 00:00:00 | 25 | 5
Spreadsheet: 052c8428-289c-45fb-8b77-5db15f1eb645
Sheet: Sheet1

 |  |  | Items indicated in green are MANDATORY REQUIREMENTS PER Ohio Revised Code 3327.10 (F)(3)
Driver First Name | Driver last Name | DL Number | Class / Endorsements | Traffic Points in last 24 months as taken from BMV record | Preservice certificate date | Valid T-8 Physical | [NAME] or Proof of Residency for last 5 years if recertiying | FBI Background Check | BMV Vehicle Records Check  (2 per year - max 6 months old) | Annual Employers Certificate | Proof of Annual In-Service Training (4 hours min. bus drivers - 2 hours min. [NAME] drivers ) | T-9 form Completed and Signed | Records Review Complete | [NAME] (ACTIVE or INACTIVE) | Supervisor Proof of Pre-Service Class Attendance (Required within 1 year of appointment, or proof of 6 year re-certification) | FMCSA Drug and Alcohol Letter Filed (if applicable) | Driver Listed in Random D/A testing Pool | OBI Pre-trip Score Sheet | OBI Driving Evaluation Score Sheet | Remarks
Spreadsheet: 868287d1715013442-first-post-ai-cant-seem-to-help-me-sample-sheet-2-
Sheet: Alabama

Store | concat1 | concat2 | concat2 | Zip | County | County Rate | City | City Rate-Change Guntersville City to 5% on  7.1.19 | Gross Sales | Exempt Sales | Grocery Sales @ reduced rate | Taxable at 4% state rate | Gross STATE Sales Tax Due | SEPARATE RETURN Taxable Purchases Subj. to Use Tax | SEPARATE RETURN Use Tax | Prepaid Wireless Cards | Prepaid Wireless Fee ($1.86) | Prepaid Wireless Fee Discount | Net Prepaid Wireless Fee | GROSS County Sales Tax | County Use Tax | GROSS City Sales Tax | City Use Tax | All Sales Taxes (excl PPD Wireless) | (INFORMATIONAL ONLY) Accrued Tax from GP
1107 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.22
3649
3652
5101
Cell Z in this sheet (in any given row) should equal:
if value in column A in current sheet and current row is equal to value in any row in column G in sheet named sales tax liabilities orig, then add sum of values in column L in sheet named sales tax liabilities orig.
+
Additionally, if column I in  sales tax liabilities orig equals lgarrigos2, then also add values in column K of those rows to the sum in previous statement.
=
Z in same row
Note: Expected result is currently entered in Z2 ONLY
Spreadsheet: 694804d1599807698-formula-for-repetitive-data-per-row-sample-data
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | Expected Result
NO | NO | NO | YES | NO | YES | YES
NO | NO | NO | YES | NO | NO | YES
YES | YES | NO | YES | NO | YES | YES
NO | NO | NO | NO | NO | NO | NO
YES | YES | YES | YES | YES | YES | NO
YES | YES | YES | NO | NO | NO | NO
YES | YES | YES | YES | YES | NO | NO
YES | NO | YES | YES | YES | YES | YES
NO | NO | YES | YES | YES | YES | NO
Spreadsheet: tracy_geaccone__40631__1stQTRFore4qtrs
Sheet: FGT only

Revised 2/16/01 | 1st | 2nd | 3rd | 4th
 | QTR | QTR | QTR | QTR | TOTAL
Net Margins PLAN
Demand:         FTS-1 | 0.1 | 0 | 0 | 0
Commodity:     FTS-1 | -0.7 | 0 | 0 | 0
Demand:         FTS-2 & STF | 1.3 | 0 | 0 | 0
Commodity:     FTS-2 & STF | -0.3 | 0 | 0 | 0
Demand:         Phase 4  FTS-2 | 0 | 0 | 0 | 0
Commodity:     Phase 4  FTS-2 | 0 | 0 | 0 | 0
Other:                 IT, SFTS, PNR, Western | 1.1 | 0 | 0 | 0
Stretch:  Non-Cash | 0 | 0 | 0 | -1.5
Less:  T C & S | 0 | 0 | 0 | 0
Variance
Net Margins 1st QTR FORECAST
Spreadsheet: 698561d1602054308-proportional-distribution-upto-the-cap-test
Sheet: Iteration 1 

 |  |  |  |  |  |  | [NAME] for Cell G7/G18???
Example 1
 |  | Inventory Available |  | 7000
 | Total
 | Item | Required | [NAME] cap | Proportional dist. Without cap | Proportional dist. With [NAME] | Requirement with cap | Delta b/w with and without cap
 | A | 0 | 2000
 | B | 4000 | 2000 |  |  |  |  | * Delta is to be distributed proportionally to other item upto there CAP
 | C | 4500 | 5000
 | D | 0 | 5000
Example 2 |  | Inventory Available |  | 7000
 | Total
 | Item | Required | [NAME] cap | Proportional dist. Without cap | Proportional dist. With [NAME] | Requirement with cap | Delta b/w with and without cap
 | A | 2000 | 2000
 | B | 4000 | 2000
 | C | 4500 | 5000
 | D | 1000 | 5000