tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0086615e-0dfd-4b41-8973-407a35d71bac
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  |  |  |  |  |  | Mycoplasma Test Request Form
 |  |  |  |  |  |  | University of Maryland, Baltimore    School of Medicine Transgenic Core Laboratory   Howard Hall 581    706-0453
 |  |  |  |  |  | Request Date |  |  |  |  | PI Name
 |  |  |  |  |  | Please indicate address where invoices should be sent: |  |  |  |  | Affiliation
 |  |  |  |  |  | Invoice contact person
 |  |  |  |  |  | Street address |  |  |  |  | Street address
 |  |  |  |  |  | City, State, Zip |  |  |  |  | City, State, Zip
 |  |  |  |  |  | Lab Contact |  |  |  |  | phone
 |  |  |  |  |  | phone |  | email |  |  | email
 |  |  |  |  |  | List Cell lines to be tested by name:
 |  |  |  |  |  | 01 |  |  |  | 06 |  |  |  | 11
 |  |  |  |  |  | 02 |  |  |  | 07 |  |  |  | 12
 |  |  |  |  |  | 03 |  |  |  | 08 |  |  |  | 13
 |  |  |  |  |  | 04 |  |  |  | 09 |  |  |  | 14
 |  |  |  |  |  | 05 |  |  |  | 10 |  |  |  | 15
 |  |  |  |  |  | Please label tubes clearly
 |  |  |  |  |  | [NAME] in the Transgenic Core employs the Sigma VenorGem Mycoplasma Detection Kit (PCR-based)
 |  |  |  |  |  | Each Mycoplasma Test requires 1 mL of cell culture supernatant. Supernatant may be heat inactivated at 95oC for 5 minutes then frozen
 |  |  |  |  |  | at -20oC until tested. Fresh culture supernatant may also be supplied for testing. Supernatant should be from cultures grown WITHOUT
 |  |  |  |  |  | [NAME] for 3-5 days prior to harvesting supernatant for testing. Harvest supernatant from >90% confluent cultures (do not overgrow).
 |  |  |  |  |  | CHARGES: |  |  | A basic charge of $100 is charged for up to 5 samples
 |  |  |  |  |  |  |  |  | Additional samples will be tested at $50 for groups of 1-5 samples
 |  |  |  |  |  |  |  |  | i.e. | 1-5    samples  $100
 |  |  |  |  |  |  |  |  |  | 6-10  samples  $150
 |  |  |  |  |  |  |  |  |  | 11-15 samples  $200
 |  |  |  |  |  |  |  |  |  | 16-20 samples  $250
 |  |  |  |  |  | PI Signature: |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Transgenic Lab Approval: |  |  |  |  |  |  |  |  | Date
 |  |  |  |  |  | Return this completed form to: Transgenic Core Facility, [NAME] (FAX [PHONE])
 |  |  |  |  |  | This form and all requested information and supporting data must be received prior to project initiation
Spreadsheet: 778763d1651305757-unable-to-get-index-match-to-make-data-from-one-worksheet-to-to-a-summary-worksheet-index-match-sample-file
Sheet: BT Investors Choice

This is the worksheet INTO which I want to pull data using INDEX/Match
to come FROM the Combined worksheet
 | Account Number | Bank Statement Order Number | Date |  |  |  |  |  | Expected Value
BT Investors Choice | 1026 |  | 2020-07-01 00:00:00 |  |  |  |  |  | 0
BT Investors Choice | 2180 | 1 | 2020-10-01 00:00:00 |  |  |  |  |  | 1
BT Investors Choice | 2180 | 2 | 2020-01-01 00:00:00 |  |  |  |  |  | 2
BT Investors Choice | 2180 | 3 | 2020-04-01 00:00:00 |  |  |  |  |  | 3
BT Investors Choice | 2180 | 4 | 2021-06-30 00:00:00 |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 1 |  | 44013
I am using the suggested formulae: |  |  |  |  |  |  |  |  | 2 | 1 | 44105
 | Expected Value |  |  |  |  |  |  |  | 3 | 2 | 43831
 | 1 |  |  |  |  |  |  |  | 4 | 3 | 43922
 | 1 |  |  |  |  |  |  |  | Blank | 4 | 44377
What am I doing incorrrectly in EACH formula?
Index | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
Match | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
 | Expected Value
 | 0
 | 1
 | 2
 | 3
 | 4
 | Blank
Spreadsheet: 8808bdc7-14f8-4c43-a826-81d805daceab
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8439 | 47259 | [NAME] | Riaño | ESP | 2 | 00:20:04 | 00:02:21 | 00:32:44 | 00:00:47 | 00:26:54 | 1 | 01:22:49
Spreadsheet: 697943d1601635489-ranking-based-on-criteria-test-1-
Sheet: Test

 |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-15 00:00:00 |  | 1 |  |  |  | * Ranking is getting sarted from 0 rather than 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  | * Ranking is needed for only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.44 | Urgent | 2020-05-11 00:00:00 |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  | 2
CTR_06 | 3.4 | Urgent | 2020-04-09 00:00:00
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  | 3
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00
CTR_11 | 3.4 | Urgent | 2020-05-14 00:00:00 |  |  |  |  |  | *As the date is before H2, it should not be considered for ranking
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-15 00:00:00 |  | 4
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 5
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  | 5
Spreadsheet: 36270d1234148525-merge-two-worksheets-index-match-sample
Sheet: Sheet2

First | Last | Address | City | State | Zip | Phone
[NAME] | bills |  | [NAME] | NY |  |  |  |  | blue cells are simple "=A2" type formulas to bring over the data
bob | [NAME] |  | los angeles | CA |  |  |  |  | from the first sheet
[NAME] | [NAME] |  | Pittsburgh | PA
doug | sams |  | New York | NY |  |  |  |  | yellow cells are an array formula that compares the names in AB
[NAME] | bobs |  | Sacramento | CA |  |  |  |  | to the labels across the top and brings back data of that type if it
 |  |  |  |  |  |  |  |  | exists in the first sheet. The same formula is in the entire yellow
 |  |  |  |  |  |  |  |  | range. It is an array formula, [NAME] to make any changes
 |  |  |  |  |  |  |  |  | and it will update the array.
 |  |  |  |  |  |  |  |  | There is a UserDefined function called IFERROR that has beena added
 |  |  |  |  |  |  |  |  | to this sheet to keep the errors from appearing in the empty cells on this page
 |  |  |  |  |  |  |  |  | for the missing data. To access the UDF, press Alt-F11 and open up Module1.
 |  |  |  |  |  |  |  |  | Copy that Function into your sheet in the same place and save it.
Spreadsheet: 101796d1299843651-i-want-sumproduct-to-not-show-0-but-if-0-i-want-it-to-show-
Sheet: Sheet1

 | Example one | If sumproduct finds numbers
Estiminert cost, periodic
Cost | 259064.48 | SUMPRODUCT((!$F$2:$F$22=$B$1)*1;(!$C$2:$C$22))
Revenue | 150569.76 | SUMPRODUCT(($F$28:$F$32=!$B$1)*1;($C$28:$C$32))
 | Example two | Cannot find any numbers
Cost | 0 | SUMPRODUCT((!$F$2:$F$22=$B$1)*1;(!$C$2:$C$22))
Revenue | 0 | SUMPRODUCT(($F$28:$F$32=!$B$1)*1;($C$28:$C$32))
 | I do not want it to show 0
 | Example three | This is the result I want to show if there is no numbers to find
Cost | - | SUMPRODUCT((!$F$2:$F$22=$B$1)*1;(!$C$2:$C$22))
Revenue | - | SUMPRODUCT(($F$28:$F$32=!$B$1)*1;($C$28:$C$32))
 | Example four | Or just nothing in the cells
Cost |  | SUMPRODUCT((!$F$2:$F$22=$B$1)*1;(!$C$2:$C$22))
Revenue |  | SUMPRODUCT(($F$28:$F$32=!$B$1)*1;($C$28:$C$32))
Spreadsheet: 827996d1683177193-if-formula-failing-with-or-argument-for-dates-mothly-payroll-schedule-sample
Sheet: Sheet1

DATE | DATE1 | EVALUATE | RESULT
2023-03-15 00:00:00
2023-04-15 00:00:00
2023-05-15 00:00:00
2023-06-15 00:00:00
2023-07-15 00:00:00
2023-08-15 00:00:00
2023-09-15 00:00:00
2023-10-15 00:00:00
2023-11-15 00:00:00
2023-12-15 00:00:00
Spreadsheet: 557122d1516442331-how-to-move-data-in-columns-below-another-set-of-columns-book1-5-
Sheet: New Request 1

Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 | Col 10 | Col 11 | Col 12 |  | Col 1 | Col 2 | Col 3 | Col 4
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | a | b | c
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | a | b | c
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | a | b | c
Spreadsheet: 471547d1469076796-bar-graph-colour-mismatch-with-the-data-dust-blend-up-2014-2016-
Sheet: Type 2.1

Lot No. | Dust % | Date
Lot 76 | 30 | 2016-07-08 00:00:00
Lot 68 | 25 | 2016-04-01 00:00:00 |  |  |  |  |  | General Blend Up (25% Dust)
Lot 67 | 25 | 2016-03-29 00:00:00 |  |  |  |  |  | Blend Card |  |  |  | Average | 25
Lot 64 | 25 | 2016-01-06 00:00:00
Lot 63 | 25 | 2015-12-23 00:00:00
Lot 62 | 25 | 2015-12-17 00:00:00
Lot 53 | 25 | 2015-10-06 00:00:00
Lot 51 | 25 | 2015-09-25 00:00:00
Lot 50 | 25 | 2015-09-22 00:00:00
Lot 45 | 25 | 2015-09-09 00:00:00
Lot 43 | 25 | 2015-08-26 00:00:00
Lot 38 | 25 | 2015-07-01 00:00:00
Lot 37 | 25 | 2015-06-24 00:00:00
Lot 35 | 25 | 2015-06-04 00:00:00
Lot 33 | 25 | 2015-04-27 00:00:00
Lot 32 | 25 | 2015-03-18 00:00:00
Lot 31 | 25 | 2015-02-26 00:00:00
Lot 83 | 25 | 2014-12-02 00:00:00
Lot 79 | 25 | 2014-10-31 00:00:00
Lot 80 | 25 | 2014-10-20 00:00:00
Lot 81 | 25 | 2014-10-20 00:00:00
Lot 78 | 25 | 2014-10-01 00:00:00
Lot 80 | 25 | 2014-09-30 00:00:00
Lot 77 | 25 | 2014-09-08 00:00:00
Lot 77 | 40 | 2014-09-08 00:00:00
Lot 76 | 25 | 2014-09-08 00:00:00
Lot 75 | 25 | 2014-08-20 00:00:00
Lot 61 | 20 | 2014-08-08 00:00:00
Lot 61 | 15 | 2014-07-04 00:00:00
Lot 68 | 25 | 2014-06-20 00:00:00
Lot 64 | 25 | 2014-05-28 00:00:00
Lot 64 | 30 | 2014-05-28 00:00:00
Lot 63 | 25 | 2014-05-13 00:00:00
Lot 53 | 35 | 2014-05-06 00:00:00
Lot 62 | 30 | 2014-05-02 00:00:00
Lot 62 | 20 | 2014-05-01 00:00:00
Lot 62 | 25 | 2014-04-30 00:00:00
Lot 61 | 25 | 2014-04-15 00:00:00
Lot 60 | 25 | 2014-04-08 00:00:00
Lot 59 | 25 | 2014-03-24 00:00:00
Lot 62 | 20 | 2014-03-20 00:00:00
Lot 59 | 20 | 2014-03-20 00:00:00
Lot 55 | 20 | 2014-03-05 00:00:00
Lot 55 | 25 | 2014-03-03 00:00:00
Lot 55 | 30 | 2014-02-28 00:00:00
Lot 52 | 25 | 2014-02-17 00:00:00
Lot 51 | 25 | 2014-02-10 00:00:00
Lot 50 | 25 | 2014-01-28 00:00:00
Lot 50 | 20 | 2014-01-24 00:00:00
Lot 47 | 25 | 2014-01-08 00:00:00
Lot 48 | 25 | 2014-01-06 00:00:00
Spreadsheet: 043b820a-db5f-4161-8b19-d1b12d8c4399
Sheet: LIST

Team | Tournament | PPB
Clayton A | Ladue Invitational | 24.52
St. Luke's Penny Savings Bank | VCU Mirror of LIST | 21.77
Cave Spring A | VCU Mirror of LIST | 21.2
Rock Bridge | Ladue Invitational | 20.39
Savannah A | Ladue Invitational | 20
Clover Hill A | VCU Mirror of LIST | 20
Clayton B | Ladue Invitational | 19.27
[NAME] A | Ladue Invitational | 19.26
SLUH | Ladue Invitational | 17.68
Parkway West B | Ladue Invitational | 17.67
[NAME] | Ladue Invitational | 17.01
De Smet A | Ladue Invitational | 16.05
Cave Spring B | VCU Mirror of LIST | 16.03
Cave Spring C | VCU Mirror of LIST | 14.8
Savannah B | Ladue Invitational | 14.71
Clover Hill B | VCU Mirror of LIST | 14.2
Oakville | Ladue Invitational | 14.18
Parkway West A | Ladue Invitational | 14.17
Cosby | VCU Mirror of LIST | 13.33
[NAME] | Ladue Invitational | 11.95
Marion A | Ladue Invitational | 11.38
De Smet B | Ladue Invitational | 11.01
Marion B | Ladue Invitational | 8.75
Cave Spring D | VCU Mirror of LIST | 8
[NAME] | Ladue Invitational | 7.5
Tuscumbia | Ladue Invitational | 6
Spreadsheet: 66457d1267103924-matching-between-two-lists-agent
Sheet: Sheet1

Consultant | AB Number |  |  | Ab number | Team Leader
[NAME] | EXAM322 |  |  | EXSS139 | [NAME]
[NAME] | EXAT130 |  |  | EXKM193 | [NAME]
[NAME] | ABLP420 |  |  | ABLP420 | [NAME]
[NAME] | ABBT137 |  |  | ABBT137 | [NAME]
Bridget Mohale | [NAME] |  |  | EXMT148 | [NAME]
[NAME] | ABCW433 |  |  | ABNMADZ | [NAME]
[NAME] | EXDM277 |  |  | ABRS621 | [NAME]
[NAME] | ABDV180 |  |  | ABDV180 | [NAME]
[NAME] | EXNB190 |  |  | ABTR217 | [NAME]
[NAME] | EXEM221 |  |  | EXAM322 | [NAME]
[NAME] | ABFH099 |  |  | EXZW105 | [NAME]
[NAME] | EXFC119 |  |  | EXNP145 | [NAME]
Glodean ([NAME]) Mekwa | EXGM103 |  |  | EXEM221 | [NAME]
[NAME] | EXGN124 |  |  | EXTM596 | [NAME]
[NAME] | EXGM232 |  |  | ABMMBAO | [NAME]
Innocentia Letsoalo | EXIL107 |  |  | ABKM782 | [NAME]
[NAME] | ABCMA2K |  |  | EXGM103 | [NAME]
[NAME] | ABKM782 |  |  | [NAME] | [NAME]
[NAME] | EXLL119 |  |  | EXLL119 | [NAME]
[NAME] | EXLN222 |  |  | EXMK126 | [NAME]
Lindiwe Maepa | ABFM329 |  |  | ABRM956 | [NAME]
[NAME] | EXGM138 |  |  | EXNK128 | [NAME]
[NAME] | ABMH452 |  |  | EXIL107 | [NAME]
Matshidiso Kganyago | EXMK126 |  |  | EXDM277 | [NAME]
Michelle Damons | ABMD419 |  |  | EXGN124 | [NAME]
[NAME] | EXMM922 |  |  | EXNB189 | [NAME]
Monchu Ntswane | ABMN629 |  |  | EXLN222 | [NAME]
[NAME] | ABMMBAO |  |  | EXSK133 | [NAME]
Musiwalo [NAME] | EXMT148 |  |  | ABMD419 | [NAME]
[NAME] | EXNK128 |  |  | ABCW433 | [NAME]
[NAME] | ABNMADZ |  |  | ABPN476 | [NAME]
[NAME] | EXNS241 |  |  | ABFM329 | [NAME]
[NAME] | EXNB189 |  |  | ABMN629 | [NAME]
[NAME] | EXNM105 |  |  | EXNM105 | [NAME]
Nyadzawela [NAME] | ABNMAD3 |  |  | ABFH099 | [NAME]
Phindile Ndhlovu | ABPN476 |  |  | ABMMBKY | [NAME]
[NAME] | ABPMA7M |  |  | EXSF123 | [NAME]
[NAME] | ABRM956 |  |  | ABPMA7M | [NAME]
Ranchia Nokayi | EXRN145 |  |  | EXMM922 | [NAME]
[NAME] | EXRC130 |  |  | EXGM138 | [NAME]
[NAME] | EXRK111 |  |  | EXAT130 | Marinda du Plessis
[NAME] | ABRS621 |  |  | EXNS241 | Marinda du Plessis
Sibusiso Sibeko | EXSS139 |  |  | ABNMAD3 | Marinda du Plessis
[NAME] | EXSK133 |  |  | ABCMA2K | Marinda du Plessis
[NAME] | EXSF123 |  |  | ABSW334 | Marinda du Plessis
[NAME] | EXTM596 |  |  | EXBR103 | Marinda du Plessis
[NAME] | ABTR217 |  |  | EXRS129 | Marinda du Plessis
[NAME] | EXBR103 |  |  | EXRK111 | Marinda du Plessis
[NAME] | EXZW105 |  |  | ABMH452 | Marinda du Plessis
 |  |  |  | EXRN145 | Marinda du Plessis
 |  |  |  | EXGM232 | Marinda du Plessis
 |  |  |  | EXNB190 | Marinda du Plessis
 |  |  |  | EXFC119 | Marinda du Plessis
 |  |  |  | EXRC130 | Marinda du Plessis
Spreadsheet: 57282d1257392953-help-on-formula-multiple-worksheets-excel-ks
Sheet: 0422 Conc Pumping

Project: |  |  |  |  |  |  |  |  |  | Claim No.: | 1
Building: |  |  |  |  |  |  |  |  |  | Proj No.:
Trade No / Trade Name | TP 0422 | Concrete Pumping |  |  |  |  |  |  |  | Date Issued: | 2009-10-30 00:00:00
[NAME]
TP No:- | Subcontract / Supply No | Description |  | Subcontractor / Supplier | Original Contract Sum | Adjustment | Adjusted Contract Sum | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 5500 | 0 | 5500 |  |  |  | 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
 |  |  |  | Contract Works Sub-Total | 5500 | 0 | 5500 | 0 | 0 | 0 | 0
Variation / Claims
SCVO | Status | Description | Notification / Instruction # | Subcontractor / Supplier | Budget | Adjustment | Adjusted Budget | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
TP 0422 | Concrete Pumping |  |  | NET TOTAL | 5500 | 0 | 5500 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | A | Approved
 |  |  |  |  |  |  | P | Submitted / Pending Approval
 |  |  |  |  |  |  | D | Disputed
 |  |  |  |  |  |  | R | Rejected
Spreadsheet: 48051d1247231623-lookup-function-book1
Sheet: Patch Panel Links

 | Port 1 | Port 2 | Port 3 | Port 4 | Port 5 | Port 6 | Port 7 | Port 8 | Port 9 | Port 10 | Port 11 | Port 12 | Port 13 | Port 14 | Port 15 | Port 16 | Port 17 | Port 18 | Port 19 | Port 20 | Port 21 | Port 22 | Port 23 | Port 24
Links | [NAME] | [NAME] | Link X10F-03 | [NAME] | Link X10F-05 | Link X10F-06 | Link X10F-07 | Link X10F-08 | Link X10F-09 | Link X10F-10 | Link X10F-11 | Link X10F-12 | Link X10F-13 | Link X10F-14 | Link X10F-15 | [NAME] | Link X10F-17 | Link X10F-18 | Link X10F-19 | [NAME] | [NAME] | Link X10F-22 | Link X10F-23 | Link X10F-24
Definity Port
Network Point
Spreadsheet: 147273d1332687748-split-a-dollar-figure-into-the-minimum-pieces-of-currency-for-refund-solver_split_coins
Sheet: Solver_setup

 |  |  |  |  | Bills & coins | Number | [NAME] to give
 |  | Sum to split: | 123.12 |  | 100 | 1 | 1   Hundred
 |  |  |  |  | 50 | 0
 |  | Constrain | 123.12 |  | 20 | 1 | 1   Twenty
 |  |  |  |  | 10 | 0
 |  |  |  |  | 5 | 0
 |  |  |  |  | 2 | 1 | 1   Two
 |  |  |  |  | 1 | 1 | 1   Ones
 |  |  |  |  | 0.5 | 0
 |  |  |  |  | 0.25 | 0
 |  |  |  |  | 0.1 | 1 | 1   Dime
 |  |  |  |  | 0.05 | 0
 |  |  |  |  | 0.01 | 2 | 2   Peny
 |  |  |  |  | Object function: | 7 | Adds up to  7  Bills & coins
Spreadsheet: 676231d1588710340-can-not-sum-with-multiple-criteria-including-date-book1
Sheet: Sheet1

Date | Name | Amount | Status |  |  |  |  |  |  |  | 2019 |  |  | 2020
 |  |  |  |  |  |  |  |  |  | NAME | October | November | December | January | February | March
2019-10-03 00:00:00 | [NAME] | 100 | Approved |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | <-----Need to fill this form
2019-10-03 00:00:00 | [NAME] | 200 | Pending |  |  |  |  |  |  | [NAME]
2019-10-03 00:00:00 | [NAME] | 150 | Approved |  |  |  |  |  |  | [NAME]
2019-10-03 00:00:00 | [NAME] | 400 | Approved |  |  |  |  |  |  | [NAME]
2019-10-03 00:00:00 | [NAME] | 500 | Pending |  |  |  |  |  |  | [NAME]
2019-11-04 00:00:00 | [NAME] | 50 | Pending
2019-11-04 00:00:00 | [NAME] | 60 | Approved
2019-11-04 00:00:00 | [NAME] | 80 | Approved
2019-11-04 00:00:00 | [NAME] | 20 | Pending
2019-11-04 00:00:00 | [NAME] | 90 | Approved
2019-12-05 00:00:00 | [NAME] | 80 | Approved
2019-12-05 00:00:00 | [NAME] | 75 | Approved
2019-12-05 00:00:00 | [NAME] | 50 | Approved
2019-12-05 00:00:00 | [NAME] | 55 | Approved
2019-12-05 00:00:00 | [NAME] | 60 | Pending
2020-01-05 00:00:00 | [NAME] | 500 | Approved
2020-01-05 00:00:00 | [NAME] | 35 | Approved
2020-01-05 00:00:00 | [NAME] | 85 | Pending
2020-01-05 00:00:00 | [NAME] | 420 | Pending
2020-01-05 00:00:00 | [NAME] | 500 | Approved
2020-02-05 00:00:00 | [NAME] | 50 | Approved
2020-02-05 00:00:00 | [NAME] | 60 | Pending
2020-02-05 00:00:00 | [NAME] | 80 | Approved
2020-02-05 00:00:00 | [NAME] | 20 | Approved
2020-02-05 00:00:00 | [NAME] | 45 | Approved
2020-03-08 00:00:00 | [NAME] | 70 | Pending
2020-03-08 00:00:00 | [NAME] | 10 | Approved
Spreadsheet: fb0c47df-298b-4edc-a7d1-c3a2738b697d
Sheet: Sheet1

2008-09-09 00:00:00 | State Senate District 1 - Democratic | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | McLeod, d | Gallus, r | [NAME]
Albany | 38
Atkinson and [NAME]. Gt. | -- | --
[NAME] | 90
Bean's Grant | -- | --
Bean's Purchase | -- | --
[NAME] | 83 | 9 | 1
[NAME] | 92 | 4 | 1
[NAME] 3 | 142 | 6
[NAME] 4 | 71 | 1 | 3
Bethlehem | 105 |  | 1
Cambridge | -- | --
Carroll | 32
[NAME]'s Purchase | -- | --
[NAME] | 8
Colebrook | 64 | 1 | 2
Columbia | 12 | 2
Crawford's Purchase | -- | --
Cutt's Grant | -- | --
[NAME] | 19
Dix's Grant | -- | --
Dixville | 5
Dummer | 3
Errol | 13
Erving's Location | -- | --
Franconia | 76 | 10 | 3
[NAME] | 94 | 3 | 2
Green's Grant | -- | --
Hadley's Purchase | -- | --
Hale's Location | 3
Hart's Location | 7 | --
[NAME] | 67
[NAME] | 24 | 3
Kilkenny | -- | --
Lancaster | 92 | 6 | 1
Lincoln | 39
Lisbon | 17
Littleton | 126 | 1 | 2
Livermore | -- | --
Low and Burbank's Grant | -- | --
[NAME] | 21 | 1
Martin's Location | -- | --
Milan | 35 | 1
[NAME] | 3
Northumberland | 92 | 6
[NAME] | -- | --
[NAME]'s Grant | -- | --
Pittsburg | 18
Randolph | 35
Sargent's Purchase | -- | --
Second College Grant | -- | --
Shelburne | 10
[NAME] | 18 | 2
Stewartstown | 13 |  | 2
[NAME] | 19 | 1
Success | -- | --
[NAME] | 30 | 1 | 1
Thompson & Meserve's Purchase | -- | --
Waterville Valley | 26
Wentworth's Location | 3 | --
[NAME] | 48
Totals | 1693 | 58 | 19
Spreadsheet: 486328d1477419065-mileage-reimbursement-formulas-not-working-test-with-new-locations
Sheet: Ref-DropDowns

List_Yes_No |  | List of Locations
Yes |  | Amityville |  | <--Anytime you ADD new columns to the mileage or minutes table, click in here then hit refresh
No |  | Bay Shore 180
 |  | Bay Shore 375
 |  | Brentwood
 |  | Deer Park
 |  | Garden City
 |  | Hauppauge (LIVM / Middle Country Management)
 |  | Hauppauge 110 Marcus Blvd
 |  | Hempstead
 |  | Holbrook
 |  | Huntington 148 E Main
 |  | [NAME] 281 Main
 |  | Little Neck
 |  | Other (Please explain thoroughly in the next column)
 |  | Port Jefferson
 |  | Riverhead
 |  | Sayville
 |  | Smithtown
 |  | Southampton
 |  | Southold
 |  | West Islip
 |  | Other
 |  | Huntington Park Ave
 |  | Manhattan E. 27th Street
 |  | Rockville Centre
 |  | Patchoque