tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 755308d1636768821-retrieve-data-from-string-of-text-retrievedata
Sheet: Sheet1

Raw Data | Result (retrieve values with underscore) | Result (retrieve first date in string, if any) | Result (retrieve second date in string, if any) | Result (value that starts with "ABCD")
Raja 20211113_83378 complete his project of 23/10/2021 by 25/10/2021 |  |  | 2021-10-25 00:00:00
[NAME] has 81918191 by 21/10/2021 of 26/11/2021 |  |  | 2021-11-26 00:00:00
[NAME] has ABCD-1212-14444-4444 of 88110011 by 24/11/2021
[NAME] has 2029221_2291 by 28/10/2021
[NAME] wants ABCD-111-222-991 of 25/10/2021
 | 20211113_83378 | 2021-10-23 00:00:00 | 2021-10-25 00:00:00 | NA
 | NA | 2021-10-21 00:00:00 | 2021-11-26 00:00:00 | NA
 | NA | 2021-11-24 00:00:00 | NA | ABCD-1212-14444-4444
 | 2029221_2291 | 2021-10-28 00:00:00 | NA | NA
 | NA | 2021-10-25 00:00:00 | NA | ABCD-111-222-991
Spreadsheet: 702843d1604570935-help-with-formula-find-a-name-in-range-and-recive-column-header-fq1
Sheet: Sheet B

 | House | Apartment | Hotel | Bungalow
 | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | Amanda
 | [NAME] | [NAME] | Cecilia | [NAME]
 | [NAME] | [NAME] | [NAME] | Eve
 | [NAME] | [NAME] | [NAME] | Mark
 | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 777750d1650577315-index-match-only-after-occurrence-of-specific-text-dendrinos2
Sheet: Sheet1

Headers | Values |  | Header | Sub-header | Value
Dog | 1 |  | Cat | red
red | 2
blue | 3
green | 4
Cat | 5
blue | 6
red | 7
green | 8
Spreadsheet: 117170d1312482501-lookup-help-2011-master-schedule
Sheet: Template

Team | Template
Date |  | Opponent
Aug 11-15 |  | @KC
Aug 18-22 |  | NE
Aug 25-28 |  | MIA
Sept 1-2 |  | @WAS
2011-09-11 00:00:00 |  | DET
2011-09-18 00:00:00 |  | @MIN
2011-09-25 00:00:00 |  | ATL
2011-10-02 00:00:00 |  | IND*
2011-10-09 00:00:00 |  | @SF
2011-10-16 00:00:00 |  | NO
2011-10-23 00:00:00 |  | CHI
2011-10-30 00:00:00 |  | bye
2011-11-06 00:00:00 |  | @NO
2011-11-13 00:00:00 |  | HOU
2011-11-20 00:00:00 |  | @GB
2011-11-27 00:00:00 |  | @TEN
2011-12-04 00:00:00 |  | CAR
2011-12-11 00:00:00 |  | @JAC
2011-12-18 00:00:00 |  | DAL
2011-12-25 00:00:00 |  | [NAME]
2011-01-01 00:00:00 |  | @ATL
Spreadsheet: 872817d1719260011-looking-for-simple-excel-forumla-for-percentage-book1
Sheet: Sheet1

Pending Account |  |  |  |  | Total | Phuocam | [NAME]'s mod
user1
user2 | 5
user3 |  |  | 74 | 15
user4 | 9 | 65 | 65 | 4
Spreadsheet: darrell_schoolcraft__7824__imbalsumm0110
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 293759 | 299565 | 77855 | 65775 | 69010 | 68361 | 117971 | 121265 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 302878 | 319737 | 63624 | 66039 | 72038 | 73226 | 110340 | 110733
3 |  |  |  |  |  |  |  |  |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 |  |  |  |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 |  |  |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | 15193330 | 15256233 |  | 5.61
6 |  |  |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 |  |  |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 |  |  |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.45
10 |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-09-30 00:00:00 |  |  |  |  |  |  |  |  | 228357
2001-10-02 00:00:00
CBS Dollars
 |  |  | 1206871
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
Spreadsheet: 687175d1595007537-excel-keeps-turning-numbers-with-slashes-that-arent-fractions-into-dates-e-g-6-12-test-results-in-excel
Sheet: Sheet1

Answered vs. Total Questions |  | Correct vs. Total Questions
150 / 150 |  | 59 / 150
70 / 70 |  | 24 / 70
15 / 15 |  | 2020-11-15 00:00:00
30 / 30 |  | 2020-12-30 00:00:00
27 / 27 |  | 2020-10-27 00:00:00
26 / 26 |  | 2020-06-26 00:00:00
2020-07-07 00:00:00 |  | 2020-03-07 00:00:00
21 / 21 |  | 2020-09-21 00:00:00
2020-10-10 00:00:00 |  | 2020-03-10 00:00:00
80 / 80 |  | 35 / 80
18 / 18 |  | 2020-10-18 00:00:00
42 / 42 |  | 23 / 42
2020-11-11 00:00:00 |  | 2020-04-11 00:00:00
19 / 19 |  | 2020-08-19 00:00:00
Spreadsheet: 124340d1318342911-data-validation-dropdown-menu-to-show-multiple-results-dvp-example
Sheet: Sheet1

Name | County | Town
[NAME] | Sussex | Brighton
[NAME] | Yorkshire | York
[NAME] | Cheshire | [NAME]
[NAME] | Sussex | Hove
[NAME] | Avon | Bristol
[NAME] | Cheshire | Carlyle
Spreadsheet: 65544d1266269835-can-i-use-validation-techniques-to-create-an-orderly-list-if_then2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | N/A | N |  | CodeRef
1 | Prior inspection reports available? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  | 2.1.6.2 Prior inspection reports shall be kept on site and made available for future inspection reference
2 | Plans of system on site for review? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  | 2.1.6.4 As-built plans shall be kept on site
3 | A log book is being maintained on site for review? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  | 2.2.3.1 A log book shall be maintained on site
4 | All deficiencies reported in last inspection have been addressed? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | Yes | 2.5.8.7 The ownwer shall make prompt repairs to any deficiencies noted. Deficiencies listed on page 6
5 | Owner confirms all hazards remain the same as reported in last inspection? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Unkown | 3.6.2.6 etc etc
6 | The system was in service with all the bells and whistles in the proper position |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No |  |  | No | 3.6.5   See notes
 | Deficiencies and Comments per AFFA 165 / 2009 ed Section Reference
1 | 2.2.3.1 A log book shall be maintained on site
2 | 2.5.8.7 The ownwer shall make prompt repairs to any deficiencies noted. Deficiencies listed on page 6
3
4
5
6
Spreadsheet: 600647d1543883682-conditional-formatting-to-highlight-duplicate-cells-that-occur-within-24hrs-of-one-another-sample
Sheet: Test

 |  |  |  |  |  |  | Key | Indication | Required Action
 |  |  |  |  |  |  | Yellow | 2 MET in 24hrs OR clinical concern | Home team consultant and ICU SR must be notified
Please enter de-identified MET Call information in below table using the drop-down boxes. |  |  |  |  |  |  | Red | 3 MET in 24hrs or clinical concern | Home team consultant and ICU SR must be notified
UR | Date & Time | Duration (min) | Ward | [NAME]? | Indication | MET Call System Dx | ARP | Outcome | Attended by | Discussed with: | [NAME]? | Comments
 |  | 15 | CCU | MET | HR < 40 | Renal failure | No | Transfer to ICU |  | Not discussed w/ senior | Yes
 |  |  |  |  |  |  |  |  |  |  | Yes
Spreadsheet: 782855d1654337762-how-to-analyse-data-for-rows-not-columns-type-chart
Sheet: Sheet1

A\D | Magic | Might | Metal | Machine
Magic | 1 | 0.5 | 2 | 2
Might | 2 | 2 | 0.5 | 2
Metal | 0.5 | 2 | 0.5 | 2
Machine | 2 | 2 | 2 | 2
A/D | Normal | Fire | Water | Plant | Poision | Earth | Wicked | Divine | Amalgam | Pure |  | 1 | 2 | 0.5
Normal | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 0.5 | 2
Fire | 1 | 2 | 2 | 2 | 2 | 0.5 | 0.5 | 1 | 0.5 | 2
Water | 1 | 2 | 1 | 1 | 2 | 2 | 0.5 | 1 | 0.5 | 2
Plant | 1 | 0.5 | 1 | 1 | 2 | 2 | 0.5 | 1 | 0.5 | 2
Poision | 1 | 0.5 | 2 | 2 | 1 | 2 | 0.5 | 1 | 0.5 | 2
Earth | 1 | 2 | 0.5 | 1 | 0.5 | 1 | 0.5 | 1 | 0.5 | 2
Wicked | 1 | 1 | 1 | 1 | 1 | 1 | 0.5 | 1 | 0.5 | 2
Divine | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 0.5 | 2
Amalgam | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 2
Pure | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0.5 | 2
Spreadsheet: 814677d1674545059-sum-unique-values-based-on-multiple-criteria-sample-data
Sheet: Desired Output

Reference ID | Amount | Payment Mode | Date
A001 | 100 | Cash deposit | 2023-01-01 00:00:00
A001 | 100 | Cash deposit | 2023-01-01 00:00:00
A001 | 100 | Cash deposit | 2023-01-01 00:00:00
A002 | 200 | Cash deposit | 2023-12-31 00:00:00
A003 | 250 | EFT | 2023-01-01 00:00:00
A004 | 400 | Cash deposit | 2023-01-04 00:00:00
A004 | 400 | Cash deposit | 2023-01-04 00:00:00
A005 | 1000 | Cash deposit | 2023-01-02 00:00:00
A006 | 800 | Cash deposit | 2023-01-01 00:00:00
[NAME] B where Refernce ID in column A is unique, Payment Mode in column C is "Cash deposit" and Date in column D is after 31 Dec 2023.
Base on the above conditions, only cells highlighted with yellow should be sum.
Output
Spreadsheet: 594964d1540150172-extracting-data-to-a-new-sheet-based-on-dates-copy-of-test-dqmark4334-
Sheet: Snapshot

 |  | Total Contacted | Total Hired | Rehire |  | Rehire % | New | New % | Referral | Referral % | % Hired | Goal % |  | January | February | March | April | May | June | July | August | September | October | November | December |  | Tot |  | January | February | March | April | May | June | July | August | September | October | November | December |  | Tot
 | Total
 | Current ICIMS Flow |  |  |  |  | ICIMS [NAME] Today
 |  |  |  |  |  |  |  |  |  | Apps | New Apps
 | Total Contacted |  |  |  |  | Grounds Attendant
 | hired |  |  |  |  | [NAME]
 | contacted |  |  |  |  | Character
 | interview schedule |  |  |  |  | Concierge
 | submit |  |  |  |  | Team Lead
 | withdrew |  |  |  |  | Supervisor
 | not selected |  |  |  |  | Area Supervisor
 | no show |  |  |  |  | Operations Supervisor
 | pending
 | Offer
 | offer accepted
 | pipeline started
Spreadsheet: a81bb281-ab2a-4d55-a436-3fc24040565c
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Establishing the Water Series 2007A Revenue Project Fund and estimate revenues in the amount of $12,800,000.00 in the
 | Water Series 2007A Revenue Project Fund and appropriate the same
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund
 | Special Revenue
 | Enterprise |  |  |  | 12800000
 |  |  | Total: | $ | 12800000 |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | This ordinance establishes the Water Series 2007A Revenue Project Fund and estimates revenues in the amount of
 | $12,800,000.00 in the Water Series 2007A Revenue Project Fund and appropriates the same.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund
 | Special Revenue
 | Enterprise/Other |  |  |  | 12800000
 |  |  | Total: | $ | 12800000 |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | In advance of issuing bonds, the Water Services Department has requested $12,800,000.00 to meet the immediate capital needs
 | of the Water Services Department for various improvements to the waterworks system.  The advance of the $12,800,000.00 is
 | based on a reimbursement of the funds from bond proceeds associated with the future issuance of Water Series 2007A
 | Revenue Bonds.  The date of issuance has not yet been determined.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.)
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate.)
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 853294d1703169515-comparing-a-list-and-a-value-in-respective-cell-printingquery
Sheet: Worksheet (2)

CHECK NO. | Vendor | DATE | Print |  | Exception
345675 | Shell Cupcakes | 2023-12-20 00:00:00 |  |  | Shell Cupcakes
720445 | Star Nursery | 2023-12-20 00:00:00 |  |  | Star Nursery
8456741 | Lights For All | 2023-12-20 00:00:00 |  |  | Lights For All | y
Spreadsheet: 43901d1242555572-average-column-depending-on-values-in-another-column-forex-journal-template
Sheet: MAYTOTALS

DATE | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | Gross P/L | PIPS | DEPOSITS & WITHDRAWALS
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
Week Sub Total
 | WINS | LOSSES | WIN $ | LOSS $ | WIN % | LOSS % | ACCOUNT $ TOTAL | PIP TOTAL | TOTAL $ IN/OUT
TOTALS
 | ACTUAL WIN/LOSS $ |  |  |  |  |  | AV. $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)
Spreadsheet: 30044d1225329021-formula-to-add-letters-with-numeric-values-ns
Sheet: Sheet1

 |  |  |  |  |  |  |  | TOTAL
 | Tuesday | Wednesday | Thursday | FRIDAY | SATURDAY | SUNDAY | MONDAY
 |  |  |  |  |  |  |  | 0
 | w | w | w | x | x | w | w | 52.5 |  | total should be 40 hours
 |  |  |  |  |  |  |  | 0 |  | need the x to be counted as 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
TOTAL | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: michelle_cash__26523__VR Severanc Calc
Sheet: Summary

VOLUNTARY SEVERANCE PAYMENT CALCULATION
Basic US Severance Calculation
Name
Date of Hire                       (mm/dd/yy)
Date of Termination            (mm/dd/yy)
Annual Base Salary
Years of Service
1 week's pay
Severance per service year
Severance per 10K of base salary
Basic Severance (1)
Additional Basic US Severance Calculation
Additional Basic Severance is only paid upon execution of a Waiver & Release of Claims
Additional Basic Severance (2)
Total amount due (3)
Additional Voluntary US Severance Calculation
Additional Voluntary Severance (3)
Total Severance Pay Under the Voluntary Severance Program
Total severance pay (1)+(2)+(3)
Total weeks of severance pay
Spreadsheet: 708683d1607967385-different-location-based-on-the-reference-and-serial-no-sample
Sheet: MAIN

REFERENCE | SERIAL  NO | [NAME] | DETAILS |  | QTY
BANANA | B1 | RP | [NAME] |  | 1
APPLE | A1 | GL | PHILIPPINES |  | 1
BANANA | B2 | MOQ | QATAR |  | 1
GRAPE | [NAME] | RP | INDIA |  | 1
STRAWBERRY | S1 | RP | USA |  | 1
STRAWBERRY | S2 | MOQ | CHINA |  | 1
STRAWBERRY | N/A | RP | USA |  | 1
GRAPE | N/A | GL | USA |  | 1
STRAWBERRY | N/A | RP | PHILIPPINES |  | 1
Spreadsheet: louise_kitchen__24243__SepYTD Orig w notes Revised
Sheet: Summary by team

Enron North America
Sep 2001 YTD
Summary by Team
Team |  | Origination | MPR | Total |  | %Total
West Power |  |  | 29901000
Canada |  |  | 6659000
West Gas
Derivatives
ERCOT Orig
Development
Central Gas
East Gas
Northeast Orig
Southeast Orig
HPL |  |  | 305000
Midwest Orig
Assets |  |  | 568000
Mexico
Asset Marketing
Energy Capital Resources
Texas Gas
Principal Investments |  |  | -6408000
Generation Investments |  | 0 | 7554451
Restructuring |  |  | -15288000
Mariner |  |  | 11352000
Total
Spreadsheet: 87edc170-6a4e-4a9b-9072-e0f6a6dcd056
Sheet: TSS of sRNA in E. coli

The first column indicates the sRNA name in E. coli.
The second column, "5' triphosphate", indicates 5' triphosphate enrichment method of this study.
The third column, "5' monophosphate", indicates TSS profiling method of [NAME].
The fourth column, "RDB 5' rtiphosphate", indicates TSS profiling method of RegulonDB 7.0 (Gama-Castro et [NAME].).
The fifth column, "RDB pyrosequencing", indicates TSS profiling method of [NAME]. The data was taken from RegulonDB.
The sixth column, "RDB primer extension", indicates 5' RACE with specific primers. The data was taken from RegulonDB.
* indicates TSS was identified inside the sRNA.
** indicates TSS was identified upstream of the sRNA.
sRNA name | 5' triphosphate | 5' monophosphate | RDB 5' triphosphate | RDB pyrosequencing | RDB primer extension
arcZ | x | x* |  | x
arrS | x
C0067
C0293
C0299
C0343 | x** | x** |  | x**
[NAME]
C0465
C0614
C0664
C0719 | x** | x*
csrA | x | x | x
csrC | x | x | x | x
cyaR | x | x
dicF | x**
dsrA | x
ffs | x | x | x
fnrS | x | x | x
gadY | x | x
gcvB | x | x |  | x
glmY | x | x | x
glmZ | x | x | x
IS128
isrA | x
isrB | x | x**
isrC | x | x*
[NAME] | x
istR-2
ldrA
[NAME]
ldrC
mgrR | x
micA | x | x
micC
micF | x | x
micM | x | x
ohsC
omrA | x
omrB | x | x
oxyS | x
psrD |  | x
psrO | x
rdlD | x
rnpB | x |  |  | x
rprA | x | x
rseX
rttR | x** | x
rybA | x** | x** | x**
rybB | x | x
rydB | x*
rydC | x** | x
ryeA | x | x
ryeB
ryfA | x | x**
ryfB | x
ryfD | x | x | x
ryhB | x | x
ryjA | x | x
ryjB | x | x
sgrS | x | x
sibA | x | x
sibB | x | x
sibC | x | x
sibD | x | x
sibE | x | x**
sokB
sokC | x | x*
spf | x | x | x
sraA
[NAME] | x
sroC | x | x
sroD
sroE | x** | x
sroG | x | x | x
sroH | x | x**
ssrS | x | x | x | x
symR | x
tff | x | x**
tp2
tpke11
tpke70
Spreadsheet: 12583ebb-1938-4cad-9475-353548f12a0e
Sheet: Figure 6

Figure 6: State Scorecard
 | Findings | Minnesota |  | Use the following options only
Federal Funding | Charters have access to federal funds according to state statutes (Yes = black, No = white)* | Y |  | Y
 | Percentage of federal revenue equals percentage of total enrollment for charter schools (<, >, or =) | > |  | P
State Funding | Charters have access to state funds according to state statutes (Yes = black, No = white) | Y |  | N
 | Percentage of state revenue equals percentage of total enrollment for charter schools (<, >, or =) | >
Local Funding | Charters have access to local funds according to state statutes (Yes = black, No = white) | Y
 | Percentage of local revenue equals percentage of total enrollment for charter schools (<, >, or =) | <
Facilities Funding | Charters have access to facilities funds according to state statutes (Yes = black, No = white) | Y
 | Percentage of facilities revenue equals percentage of total enrollment for charter schools (<, >, or =) | NA
Data Availability | State provides detailed, public data on federal, state, local and other revenues for district schools (Yes = black, Partial = grey, No = white) | Y
 | State provides detailed, public data on federal, state, local and other revenues for charter schools (Yes = black, Partial = grey, No = white) | Y
Funding Formula | Charters are treated as LEAs for funding purposes (Yes = black, Partial = grey, No = white) | Y
 | State funds student (black) or the LEA (grey) | S |  | S | L |  | Use these options for the query to the left only (B18)
 | State funding formula is fair and equitable (Yes = black, No = white | N
* For this finding, No could indicate that the statue is silent or that it denies access.
Spreadsheet: 878982d1726386729-i-want-criteria-base-index-with-count-function-criteria-base-index
Sheet: Sheet1

 | Index | [NAME] |  |  |  |  | Criteria
 | a | small |  | Result |  |  | small
 | a | XL |  |  |  |  | big
 | a | XL |  |  |  |  | large
 | a | XXL
 | b | big
 | b | XXXL
 | b | large
 | b | small
 | b | large
 |  |  |  | Required Result
 |  |  |  | a | 1
 |  |  |  | b | 4
Spreadsheet: 876484d1723177220-how-to-set-the-formula-in-column-j-to-show-the-company-name-excel-formula
Sheet: 65301303 (Year)

Acc Code | 65301303 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepared by: | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reviewed by: | [NAME]
 |  | Values
Posting Period | Remark | POL DEL | POL REG | POL HK1 | [NAME] | POL HK3 | FRE CHG | POD HK1 | POD HK2 | POD HK3 | POD HK4 | POD REG | POD DEL | POD DUT | BLP REG | BLP DEL | CIF CMB | [NAME] | FAB AIR | LDP BST | MIS CHG | Total
2023-04-30 00:00:00 | (blank) | 2.273736754432321e-13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.273736754432321e-13
2023-05-31 00:00:00 | (blank) | 1669.67 |  |  |  | 838 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2507.67
2023-06-30 00:00:00 | (blank) | 4828.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4828.92
2023-07-31 00:00:00 | (blank) | 9304.85 | 2430.79 | 4060 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15795.64
2023-08-23 00:00:00 | (blank) | 8845.800000000001 |  | 7810 | 8467 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25122.8
2023-09-30 00:00:00 | (blank) | 2740.58 |  | 3462 | 16317 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22519.58
2023-10-31 00:00:00 | (blank) | 7679 |  | 5517 | 8322 |  |  | 2321 | 820 |  |  |  |  |  |  |  |  |  |  |  |  | 24659
2023-11-30 00:00:00 | (blank) | 3730.66 |  | 4819 | 6466 |  |  |  |  |  |  | 1172 | 1336.8 |  |  |  |  |  |  |  |  | 17524.46
2023-12-31 00:00:00 | (blank) | 5375.249999999999 |  | 4603 | 9488 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19466.25
2024-02-29 00:00:00 | (blank) |  |  | 7550 |  |  |  |  |  |  |  |  | 2494.83 |  |  |  |  |  |  |  |  | 10044.83
2024-03-31 00:00:00 | (blank) | 4040.43 |  | 2207 | 14831 |  |  |  |  |  |  | 2376 | 2096 |  |  |  |  |  |  |  |  | 25550.43
2024-04-30 00:00:00 | (blank) | 1531.48 |  | 3410 | 8288 |  |  |  |  |  |  | 1015 | 759.2 |  |  |  |  |  |  |  |  | 15003.68
Grand Total |  | 49746.64 | 2430.79 | 43438 | 72179 | 838 |  | 2321 | 820 |  |  | 4563 | 6686.83 |  |  |  |  |  |  |  |  | 183023.26
Spreadsheet: stock1
Sheet: Sheet1

 | MyCo.com Stock Control
 | value: | 554
Date: | 2000-09-08 10:34:47 |  |  |  |  |  |  |  | Reorder Cost= | 8
Item Code: | Description | Supplier | Supplier ref: | Buy at | Stocked | Value | Min Stock | Deficit | to Reorder | Supplier ref: | Cost:
BR223 | Thingy - blue | Acme | thblu1 | 4 | 4 | 16 | 6 | 2 | 2 | thblu1 | 8
[NAME] | Thingy - red | Acme | [NAME] | 4 | 45 | 180 |  | -45 |  | [NAME]
[NAME] | [NAME] - yellow | Acme | thyel1 | 4 | 23 | 92 |  | -23 |  | thyel1
T4 | Watsit - clear small | Steelers | MR456 | 2.3 | 0 |  |  | 0 |  | MR456
T5 | Watsit - clear medium | Steelers | [NAME] | 3.5 | 4 | 14 |  | -4 |  | [NAME]
T6 | Watsit - clear large | Steelers | MR458 | 4.5 | 56 | 252 |  | -56 |  | MR458
[NAME] |  |  |  |  |  |  |  | 0 |  | 0
PO787 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
Spreadsheet: 77874d1278370474-vlookup-test-worksheet
Sheet: Data Sheet

Check register | Account | Check # | Amount | Notes
 | 50015 | 1497 | 31.25 | Support for computer services
 | 50015 | 1422 | 22546 | Extra cost for server
 | 50015 | 1488 | 2131 | new screens
 | 60012 | 2122 | 186.55
 | 60018 | 2124 | 122.65
 | 60022 | 2128 | 745.88