tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 550163d1512136351-failed-subjects-should-not-be-added-in-the-obtained-marks-test_sheet_conditonal-formating
Sheet: Sheet1

 |  |  | Before: | marks of failed and passed subjects are added in obtained
 |  |  |  | english | maths | physics | chemistry | bio | computer | urdu | obt marks
 |  |  |  | 55 | 33 | 80 | 23 | 67 | 65 | 77
 |  |  |  | 12 | 65 | 19 | 68 | 10 | 9 | 67
 |  |  |  | 76 | 66 | 56 | 15 | 100 | 28 | 20
 |  |  | After: | The above result should be like as without failed subjects
 |  |  |  | english | maths | physics | chemistry | bio | computer | urdu | obt marks | With summif formula
 |  |  |  | 55 | 33 | 80 | 23 | 67 | 65 | 77
 |  |  |  | 12 | 65 | 19 | 68 | 10 | 9 | 67
 |  |  |  | 76 | 66 | 56 | 15 | 100 | 28 | 20
Spreadsheet: 77705d1278126649-excel-2007-vlookup-not-working-vlookup
Sheet: ENT

NWOS Fee Analysis
Specialty | Concantenate | CPT Code | Mod | Description | Sum_ Unit | Sum_ Charge | Sum_ Repriced | NWOS Fee | Rate Calc | Proposed NWOS | CMS 2005 | CMS 2007 | CMS 2008 | CMS 2010 | Allowed HIAA | Weighted NWOS | Weighted Proposed NWOS | Weighted CMS 2005 | Weighted CMS 2007 | Weighted  2008 |  | % of Current to CMS 2005 | % of Proposed to CMS 2005 | % of Proposed to CMS 2007 | % of Proposed to CMS 2008 |  | Body System
ENT | 10021.03
ENT | 10140.03
ENT | 10160.03
ENT | 11100.03
ENT | 11200.03
ENT | 11310.03
ENT | 11426.03
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
ENT
Spreadsheet: 731207d1620228903-lookup-formula-based-on-range-book1
Sheet: Sheet1

Ref | Yards From | Yards To | Region |  | Ref | Yards | Region
ABC | 880 | 1700 | East |  | DEF | 440 | North
ABC | 1701 | 2000 | North |  | ABC | 900 | East
ABC | 2001 | 2500 | South
DEF | 100 | 1700 | North
DEF | 1701 | 3000 | East
Spreadsheet: 546444d1510057108-need-help-on-formula-weekly-numbers
Sheet: Report

Service | A001 |  |  | Criteria 1
Curr.WK | 47 |  |  | [NAME]
WK | Vessel | PK
If I select B4 as 45, then should show previous 3 Week number in A7,A8 & A9 and corresponding vessel name in B7,B8 & B9 related to Service B3
Spreadsheet: 725061d1616514696-need-formula-to-get-unique-string-count-when-1-criteria-is-met-example-1
Sheet: Sheet1

 | Country | Name | Unique name count/country
 | USA | [NAME] | 6
 | USA | [NAME] | 6
 | USA | [NAME] | 6
 | USA | [NAME] | 6
 | USA | [NAME] | 6
 | USA | [NAME] | 6
 | USA | Fanny | 6
 | USA | [NAME] | 6
 | UK | [NAME] | 4
 | UK | [NAME] | 4
 | UK | Franky | 4
 | UK | [NAME] | 4
 | UK | [NAME] | 4
 | UK | [NAME] | 4
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Himsworth

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 763842d1642427503-apply-predictive-text-on-drop-down-list-hassan
Sheet: Sheet1

 |  | Input search parameter |  | Selection Criteria formula |  | Search_List
 |  | a |  |  | [NAME]
 |  |  |  |  | helal
 |  | Search is on first "n" characters  (of list in F) entered in C2 |  |  | hasan
 |  | =IF(ISNUMBER(SEARCH($C$2,LEFT($F2,LEN($C$2)))),MAX($E$1:E1)+1,0) |  |  | walid
 |  |  |  |  | kenan
 |  | Columns E, F and G can be hidden |  |  | zahra
 |  |  |  |  | [NAME]
 |  | "Search_List" is a named range |  |  | [NAME]
 |  |  |  |  | [NAME]
Spreadsheet: 04f51a10-17ba-49b8-8b4f-de21f38d118b
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
MUSS | Test | MUSS | Blue Mussel, IgE | Blue Mussel, 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
MUSS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MUSS | Result | MUSS | Blue Mussel, IgE | Blue Mussel, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6048-3
Spreadsheet: 717130d1612498014-return-latest-value-balance-between-two-dates-forum-excel-4-f-v-2021-ans
Sheet: Archive

 | Revenus et dépenses mensuelles par Mois / Année / Catégorie |  |  |  |  |  |  | Revenu individuel par [NAME] |  |  |  | Dépense individuelle par [NAME]
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée:
 | Année financière |  | 2020
 |  |  |  |  |  |  |  | Aimerais-tu voir les revenus globaux? |  |  |  | Aimerais-tu voir les dépenses globales?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Moy. Mois
 | Soldes des comptes par mois, année et compte |  |  |  |  |  |  | Solde comptes individuel
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée: |  |  |  |  | Argent métal |  | FTQ (REER)
 | Année financière |  | 2020 |  |  |  |  |  |  | [NAME] (CÉLI) |  | Urgence
Spreadsheet: 646791d1572023291-sales-commission-formula-help-sales-commission-plan-gk-final
Sheet: Sheet1

[NAME] | January | February | March | April | May | June | July | August | September | October | November | December | 2020 Revenue
Target
Earned | 150000 |  | 150000 |  |  |  |  |  |  | 210000
Cumulative
Commission
Salary
Total
Should be
Accum
0.03 |  |  |  |  |  |  |  |  |  |  |  |  | 3% of delivered revenue if under target
0.05 |  |  |  |  |  |  |  |  |  |  |  |  | 5% of delivered revenue if on target
Over
0.05
0.1
Total Over |  |  |  |  |  |  |  |  |  |  |  |  | 10% of revenue delivered that is over target (so you get 5% for hitting and then 10% for anything delivered above target)
Spreadsheet: 833225d1686843976-nested-functions-collapsing-data-into-value-but-i-cant-know-why-collapse-to-error-example
Sheet: Sheet1

 | a | 1 |  |  |  |  |  | 1 | 11 | #[NAME]! |  |  |  |  | 1 | 11 | 7
 | a | 2 |  |  |  |  | a | 2 | 12 | #[NAME]! |  |  |  | a | 2 | 12 | 7
 | a | 3 |  |  |  |  | a | 3 | 13 | #[NAME]! |  |  |  | a | 3 | 13 | 7
 | a | 4 |  |  |  |  | a | 4 | 14 | #[NAME]! |  |  |  | a | 4 | 14 | 7
 | a | 5 |  |  |  |  | a | 5 | 15 | #[NAME]! |  |  |  | a | 5 | 15 | 7
 | a | 6 |  |  |  |  | a | 6 | 16 | #[NAME]! |  |  |  | a | 6 | 16 | 7
 | a | 7 |  |  |  |  | a | 7 | 17 | #[NAME]! |  |  |  | a | 7 | 17 | 7
 | b | 8 |  |  |  |  | b | 8 | 18 | #[NAME]! |  |  |  | b | 8 | 18 | 2
 | b | 9 |  |  |  |  | b | 9 | 19 | #[NAME]! |  |  |  | b | 9 | 19 | 2
 | c | 10 |  |  |  |  | c | 10 | 20 | #[NAME]! |  |  |  | c | 10 | 20 | 3
 | c | 11 |  |  |  |  | c | 11 | 21 | #[NAME]! |  |  |  | c | 11 | 21 | 3
 | c | 12 |  |  |  |  | c | 12 | 22 | #[NAME]! |  |  |  | c | 12 | 22 | 3
 | D | 13 |  |  |  |  | D | 13 | 23 | #[NAME]! |  |  |  | D | 13 | 23 | 4
 | D | 14 |  |  |  |  | D | 14 | 24 | #[NAME]! |  |  |  | D | 14 | 24 | 4
 | D | 15 |  |  |  |  | D | 15 | 25 | #[NAME]! |  |  |  | D | 15 | 25 | 4
 | D | 16 |  |  |  |  | D | 16 | 26 | #[NAME]! |  |  |  | D | 16 | 26 | 4
Spreadsheet: 853620d1703542215-trying-to-get-data-from-a-spreadsheet-and-break-it-down-per-customer-and-per-tech-raw-data
Sheet: timeentrysearch (43)

Member | Company | Hours
[NAME] | Acme | 0.07
[NAME] | US Gov | 1.35 |  |  |  | [NAME] | 2.49
[NAME] | Acme | 1.82 |  |  |  | Mark | 0.47
[NAME] | ACME | 0.6 |  |  |  | [NAME] | 0.3
[NAME] | US Gov | 0.03
[NAME] | US Gov | 0.02
[NAME] | US Gov | 0.48 |  |  |  | US Gov
Mark | Acme | 0.22 |  |  |  | [NAME] | 2.88
[NAME] | US Gov | 0.02 |  |  |  | [NAME] | 0.02
[NAME] | Acme | 0.3
Mark | Acme | 0.25
[NAME] | US Gov | 1
Spreadsheet: 40266d1238575663-copying-specific-cell-details-to-the-respective-column-please-help-sample
Sheet: Sheet1

S.No | Sites | Top Country Visitors | India | United States | Other Country
1 | http://deccanherald.com/ - 114k - cache | India74.6% United States10.7% United Arab Emirates2.3% | India74.6% | United States10.7% | United Arab Emirates2.3% | My desired output to be achieved. Please Help
2 | http://www.garhwaltourism.com/ - 29k - cache | India100.0%
3 | http://www.bollyqueens.com/ - 27k - cache | India78.5% United States7.0%
4 | http://www.andhimazhai.com/ - 62k - cache | India70.9% Canada6.3% Singapore4.2%
5 | http://www.bollywoodblitz.com/ - 113k - cache | India76.6% Pakistan7.4% United States5.2%
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 10-Po

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi lirimin nga pagesa e semestrit për [NAME] 2011/2012
 | [NAME] 2011/2012 lirohen nga pagesa e semestrit këta studentë nga
[NAME]
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria
1 | Hamit [NAME] | Drenas | III
2 | [NAME] | Mitrovic | I
3 | [NAME] | Malisheve | III
4 | [NAME] | [NAME] | III
5 | [NAME] | Mitrovic | V
6 | [NAME] | Gjakove | V
7 | [NAME] | Lipjan | IV
8 | Kujtim Ilmi Aliu | Vushtrri | III
9 | [NAME] | Skenderaj | V
10 | [NAME] | Gjakove | III
11 | [NAME] | Podujev | V
12 | [NAME] | Gjilan | I
13 | Shpresa Pjeter Gojani | Kline | V
14 | [NAME] | Podujev | V
15 | [NAME] | Suharek | V
16 | [NAME] | [NAME] | III
17 | [NAME] Alia | Ferizaj | III
18 | [NAME] | Gjilan | V
19 | [NAME] Pllana | Mitrovic | V
20 | [NAME] | Lipjan | V
21 | Milot [NAME] | Peje | V
22 | Fitore Avdyl Rybovci | Drenas | V
23 | [NAME] | Prishtine | V
VËREJTJE:
Studentët e liruar në bazë të këtij [NAME] të paraqiten në shërbimin financiar të fakultetit gjegjës për të bërë kërkesë për [NAME] e mjeteve të paguara për semester.
 |  | K O M I S I O N I:
 |  | Prof.Dr.[NAME],kryetar              ________________
 |  | [NAME], anëtar                           ________________
 |  | [NAME], anëtar                         ________________
 |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 770797d1646255112-working-time-directive-calculations-timesheet2
Sheet: 06-12-21

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | W Donaldson / P Gardiner
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | I Beverage
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7 |  |  | 2 | 10
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] |  | 7.5 | -7.5 |  |  | 7.5 | -7.5 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 | 1 |  |  |  | 2
 | [NAME] |  | 0 |  |  | AL | 0 |  |  |  | 6.5 | -2 |  | 1hr | 7.5 |  |  |  | 7
 | [NAME] |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  | 1.5 | 12.5 |  | 8
 | [NAME] |  | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK | 0 |  |  | SK
 |  | TOIL
Spreadsheet: 082dac71-516b-4091-bc67-4914f0045b01
Sheet: 4A Boys

REGION IV TRACK
BOYS 4-A
SCHOOL:
DISTRICT: |  | COACH:
BOYS 4-A / 4X100 (400 METER RELAY)
EVENT 404
PRINT NAMES NEATLY |  |  |  | PRELIMS | FINALS
1.
2.
3.
4.
5. (ALT)
6. (ALT)
REGION IV TRACK
BOYS 4-A
SCHOOL:
DISTRICT: |  | COACH:
BOYS 4-A / 4X200 (800 METER RELAY)
EVENT 404
PRINT NAMES NEATLY |  |  |  | PRELIMS | FINALS
1.
2.
3.
4.
5. (ALT)
6. (ALT)
REGION IV TRACK
BOYS 4-A
SCHOOL:
DISTRICT: |  | COACH:
BOYS 4-A / 4X400 (1600 METER RELAY)
EVENT 412
PRINT NAMES NEATLY |  |  |  | PRELIMS | FINALS
1.
2.
3.
4.
5. (ALT)
6. (ALT)
Spreadsheet: 117057d1312413177-vlookup-multiple-tables-test-file
Sheet: Sales information

Address Number | Street | zCode | SalePrice | Sale Date
834 | 22ND ST | 10111 | 249800 | 2007-06-12 00:00:00
1480 | 24TH ST | 10111 | 208800 | 2007-04-07 00:00:00
1480 | 26TH ST | 10111 | 178800 | 2007-06-12 00:00:00
2080 | 26TH ST | 10111 | 288888 | 2007-07-17 00:00:00
120 | 28TH ST | 10111 | 1080000 | 2006-11-01 00:00:00
1890 | 29TH ST | 10111 | 299500 | 2007-07-05 00:00:00
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 56700 | 56672
2 | 63202 | 63276
3 | 58153 | 58516
4 | 54653 | 54653
5 | 54545 | 54088
6 | 58729 | 59030
7 | 59209 | 60374
8
9
10
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 |  |  | 7185
2001-10-07 00:00:00
CBS Volume
 |  |  | 1289
Spreadsheet: tracy_geaccone__40543__CE 3-2001
Sheet: Model_source_data

Transwestern Pipeline Company
Current Estimate Supply data for Weekly
Current Month Forecast = | October
 | Transport | Transport
 | Volume | Margin |  | Function formula - no more than seven functions can be nested, therefore I copied the formula into a label format to add in later months.
 | (MMMBTU/DAY) | $[NAME] |  | Just MOVE to entire formula!!!!!
WEST
WEST:  THOREAU |  |  |  | Volume Formula
DEMAND |  |  |  | =IF($B$5=Forecast01!$B$10,Forecast01!B14,IF($B$5=[NAME]=Forecast01!$E$10,Forecast01!E14,IF($B$5=Forecast01!$F$10,Forecast01!F14,IF($B$5=Forecast01!$G$10,Forecast01!G14,IF($B$5=Foreca
SETTLEMENT SURCHARGE |  |  |  | Need to update formulas to reflect move of this sheet from Model_source_plan_data file to this System_Design file.
FTS |  |  |  | margin [NAME]
FR |  |  |  | =IF($B$5=Forecast01!$B$10,Forecast01!B188,IF($B$5=[NAME]=Forecast01!$E$10,Forecast01!E188,IF($B$5=Forecast01!$F$10,Forecast01!F188,IF($B$5=[NAME]
ITS
TOTAL THOREAU TO WEST
WEST: EAST OF THOREAU
DEMAND
SETTLEMENT SURCHARGE
FTS
FR
LFT
ITS
TOTAL EAST OF THOREAU TO WEST
WEST: IGNACIO
DEMAND
FTS
FR
ITS
TOTAL IGNACIO TO WEST
WEST: SAN JUAN
DEMAND
FTS
FR
LFT--San Juan
ITS
TOTAL SAN JUAN TO WEST
SUBTOTAL WEST DEMAND
SUBTOTAL WEST COMMODITY
TOTAL WEST
EAST
EAST: WEST OF THOREAU and Thoreau
DEMAND
FTS
FR
ITS
TOTAL THOREAU TO EAST
EAST: EAST TO EAST
DEMAND
FTS
FR
PNR-East of Thoreau
ITS
TOTAL EAST TO EAST
EAST: IGNACIO
DEMAND
FTS
FR
ITS
TOTAL IGNACIO TO EAST
EAST: SAN JUAN
DEMAND
FTS
FR
ITS
TOTAL SAN JUAN TO EAST
SUBTOTAL EAST DEMAND
SUBTOTAL EAST COMMODITY
TOTAL EAST
IGNACIO/BLANCO
IGNACIO TO BLANCO HUB
DEMAND
FTS
FR
ITS
TOTAL IGNACIO TO BLANCO HUB
IGNACIO TO EL PASO BLANCO
DEMAND
FTS
FR
ITS
TOTAL IGNACIO TO EP BLANCO
SUBTOTAL IGNACIO DEMAND
SUBTOTAL IGNACIO COMMODITY
TOTAL IGNACIO
SAN JUAN
SAN JUAN TO THOREAU:
DEMAND
FTS
FR
ITS
SUBTOTAL SAN JUAN DEMAND
SUBTOTAL SAN JUAN COMMODITY
TOTAL SAN JUAN
COMPANY TOTAL
DEMAND
FTS
FR
PNR
LFT
ITS
TOTAL COMPANY DEMAND
TOTAL COMPANY COMMODITY
TOTAL COMPANY
MARGIN CALCULATION
COST OF TRANSPORT:
TCR  AMORTIZATION EXPENSE
UAF
GRI,ACA EXPENSE
NET FUEL EXPENSE (RETAINED)
TOTAL COST OF TRANSPORT
Plan Index Price
FUEL USED VOLUME
PLAN STRETCH PER MONTH
MONTHLY UNHEDGED FUEL SALES
Unhedged Fuel Sale - Volume 1
Unhedged Fuel Sale - Days
Unhedged Fuel Sale - Rate
CE: Fuel Retained Adjustment for vols. Btw. Topock & Needles |  | 0
April fuel volume adjustment to
Spreadsheet: sally_beck__35172__MgmtSum-Q3-0928_Global
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
3RD QUARTER 2000 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Office of the Chairman
Subtotal Commercial Expenses
Group
Other Interest Related Charges
Total Expenses
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 04b4bf36-1f34-4b76-93f0-cabfc4c80ae1
Sheet: Figure 6 Findings

Figure 6: State Scorecard
 | Findings | New Jersey |  | 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) | N |  | 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) | N
 | Percentage of facilities revenue equals percentage of total enrollment for charter schools (<, >, or =) | N
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 one could indicate that the statue is silent or that it denies access.
Spreadsheet: 212579-need-help-auto-generate-columns-stafprofile
Sheet: height

Name | Height
 | 170
 | 150
 | 145
Spreadsheet: 678783d1590060743-help-with-if-formula-combining-formulas-2020-05-20-oeldere2-ayio-678662d1589997633-help-with-if-formula-combining-formulas-ifhelp
Sheet: page1

Job name | Start Date | End Date | Name | Job | Status
AA-234 | 2020-05-14 00:00:00 | 2020-05-15 18:00:00 | [NAME]
AA-235 | 2020-05-20 00:00:00 |  |  |  |  |  |  |  | Not assigned
 | 2020-05-20 00:00:00 |  | [NAME] |  |  |  |  |  | Began
 | 2020-05-20 00:00:00 |  | [NAME] |  |  |  |  |  | Resuming
 | 2020-05-15 16:30:00 | 2020-05-21 00:00:00 | [NAME] |  |  |  |  |  | Finished
 | 2020-05-16 00:00:00 |  | [NAME] |  |  |  |  |  | Transfer
 | 2020-05-17 00:00:00 |  | [NAME] |  |  |  |  |  | Transferred
AA-235 | 2020-05-22 00:00:00 |  | [NAME]
for the status cell: (if name cell is empty, then j3), (if start date = today, then j4), (if today > start date, then j5),
(if  end date is writing then j6), (if job name is not written on page 2 then j7), (if job name is written on page 2, then j8)
Spreadsheet: 754717d1636463480-summarize-multiple-criteria-summarize-multiple-criteria
Sheet: Sheet1

Segment | Jan 21 Actual | Feb 21 Actual | Mar 21 Actual | Apr 21 Actual | May 21 Actual | Jun 21 Actual | Jul 21 Actual | Aug 21 Actual | Sep 21 Actual | Oct 21 Actual | Nov 21 Actual | Dec 21 Actual | Total | Jan 21 Forecast | Feb 21 Forecast | Mar 21 Forecast | Apr 21 Forecast | May 21 Forecast | Jun 21 Forecast | Jul 21 Forecast | Aug 21 Forecast | Sep 21 Forecast | Oct 21 Forecast | Nov 21 Forecast | Dec 21 Forecast | Total 21 Forecast
Grocery | 0 | 0 | 0 | 0 | 48.21049 | 0 | 0 | 0 | 0 | 103.25754 | 182.86604 | 52.69208 |  | 25 | 21 | 20 | 25 | 26 | 19 | 19 | 20 | 20 | 25 | 25 | 25
Chemistry | 3882.67516 | 6983.18511 | 7006.72106 | 5474.533239999999 | 5795.66191 | 5977.84027 | 4321.557299999999 | 6276.440600000002 | 5493.66334 | 122.35933 | 28.91156 | 28.91622 |  | 10550 | 10550 | 10550 | 9500 | 10550 | 9500 | 10000 | 10550 | 12000 | 10550 | 12000 | 10550
Medicals | 0 | 0 | 66.70182000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0.47076 | 103.21099 | 0 |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Medicals | 300.1745 | 0 | 281.70661 | 0 | 152.6819 | 242.89699 | 376.67484 | 0 | 163.14986 | 0 | 16.87496 | 0 |  | 350 | 320 | 320 | 330 | 300 | 300 | 300 | 300 | 300 | 280 | 280 | 280
Stationery | 0 | 0 | 0 | 0 | 0 | 1.0339 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Chemistry | 2.46294 | 2.46165 | 2.46135 | 2.46175 | 2.46132 | 2.46148 | 2.46138 | 2.46194 | 2.46132 | 0 | 0.46588 | 0 |  | 6 | 2 | 3 | 3 |  | 5 | 10 | 12 | 8 | 8 | 8 | 8
Chemistry | 0 | 0 | 0 | 0 | 67.89307000000001 | 0 | 0 | 0 | 0 | 0.71484 | 0.71476 | 0.71487 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Stationery | 9.899 | 8.1061 | 8.10513 | 8.10643 | 8.10501 | 8.10556 | 8.10524 | 8.10709 | 8.10501 | 1.99654 | 0 | 1.99662 |  | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22
Grocery | 0 | 0 | 0 | 0 | 74.71692999999999 | 0 | 0 | 0 | 0 | 20.061 | 35.664 | 46.809 |  | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19
Stationery | 3.21581 | 3.2168 | 3.21641 | 3.21693 | 3.21637 | 0.7148 | 0.71477 | 0.71493 | 0.71475 | 2.5 | 1.25 | 1.25 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  |  | Jan 21 Actual | Jan 21 Forecast
Segment | Sep 21 Actual | Sep 21 Forecast | Sep 21 Actual | Sep 21 Forecast
Chemistry
Spreadsheet: 389bb534-926e-4118-a02f-b6d844f2ebea
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
FFLEX | Test | FFLEX | Cyclobenzaprine (Flexeril) | Cyclobenzaprine (Flexeril) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.4 mL | Hemolysis	NA Thawing	Cold OK; Warm OK Lipemia	NA Icteric	NA Other	NA | [NAME]: 10-30 ng/mL   Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FFLEX | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FFLEX | Result | Z1130 | Cyclobenzaprine (Flexeril) | Cyclobenzaprine (Flexeril) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process