tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 49737d1249053602-if-no-data-then-show-empty-cell-main-spreadsheet
Sheet: CUSTOMERS

SURNAME | NAME | [NAME] | ADD2 | [NAME] | ADD4 | [NAME] | TELEPHONE
a
[NAME], [NAME] | [NAME] | A1 | A2 | A3 | A4 | AA
Bond, Bertie | [NAME] | B1 | B2 | B3 | B4 | BB
Conk, Carol | Carol Conk | C1 | C2 | [NAME] | C4 | CC
Spreadsheet: 116175d1311647960-removing-zeroes-in-stacked-bar-chart-removing-zeroes-in-stacked-bar-chart2
Sheet: Sheet1

 | Start Week Number | 6
 | Number of Weeks | 5
 | Source Data
 | Count |  |  |  |  |  |  |  |  |  |  |  | Percentage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 4 | 3 | 2 | 1 |  | #N/A | #N/A | #N/A | #N/A
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 |  | Week # | 6 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Category A | 3 | 9 | 2 | 2 | 10 | 0 | 0 | 0 | 0 | 0 |  | Category A | 0.025 | 0.05521472392638037 | 0.02040816326530612 | 0.01587301587301587 | 0.05847953216374269 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category B | 0 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 |  | Category B | 0 | 0 | 0 | 0 | 0.1169590643274854 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category C | 1 | 0 | 0 | 1 | 30 | 0 | 0 | 0 | 0 | 0 |  | Category C | 0.008333333333333333 | 0 | 0 | 0.007936507936507936 | 0.1754385964912281 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category D | 5 | 5 | 2 | 7 | 0 | 0 | 0 | 0 | 0 | 0 |  | Category D | 0.04166666666666666 | 0.03067484662576687 | 0.02040816326530612 | 0.05555555555555555 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category E | 22 | 33 | 25 | 25 | 45 | 0 | 0 | 0 | 0 | 0 |  | Category E | 0.1833333333333333 | 0.2024539877300613 | 0.2551020408163265 | 0.1984126984126984 | 0.2631578947368421 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category F | 51 | 68 | 48 | 39 | 65 | 0 | 0 | 0 | 0 | 0 |  | Category F | 0.425 | 0.4171779141104294 | 0.4897959183673469 | 0.3095238095238095 | 0.3801169590643275 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category G | 5 | 6 | 5 | 7 | 0 | 0 | 0 | 0 | 0 | 0 |  | Category G | 0.04166666666666666 | 0.03680981595092025 | 0.05102040816326531 | 0.05555555555555555 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category H | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  | Category H | 0 | 0 | 0 | 0 | 0.005847953216374269 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category I | 17 | 18 | 16 | 13 | 0 | 0 | 0 | 0 | 0 | 0 |  | Category I | 0.1416666666666667 | 0.1104294478527607 | 0.163265306122449 | 0.1031746031746032 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A
 | Category J | 16 | 24 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | 0 |  | Category J | 0.1333333333333333 | 0.147239263803681 | 0 | 0.253968253968254 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | 120 | 163 | 98 | 126 | 171 | 0 | 0 | 0 | 0 | 0
 | Note:
 | The above graph shows a sample dashboard I'm currently doing.  It's just one of the many graphs that I will be doing.  Aesthetically, it looks like a draft when presenting zeroes.
 | Week Numbers line 26 vary depending on the selected Start Week Number and number of week covered.
 | Categories A-J are fixed.
 | Values in C27:L36 changes depending on the the week numbers and start Week # selected. For now, formula is removed.
 | Let's assume that I selected 5 weeks of data from Week 1 to Week 5.
 | Goal:
 | I'd like to automatically remove the zeroes as it doesn't really look good when presenting it to my boss.
Spreadsheet: 217982d1362280709-how-to-calculate-a-rolling-average-over-x-periods-rolling-average
Sheet: Sheet1

Data | Rolling X Period Average | # of periods to average
5 |  | X
7
9
3
4
6
8
7
9
12
4
5
8
2
3 | *
I want * to be an average of a range starting from A16 going back X periods
If X was replaced with 5, I would want Cell B16 to be an average of (A12:A16)
Spreadsheet: 685630d1594119214-mix-of-if-then-and-sums-example
Sheet: Sheet1

Long term investment plans with additional investments
Investment amount | 1000
Week | Balance | Weeks Total Earnings at 1.14% / 1.25% / 1.5% / 2% daily (5 days a week) | Additional Investment
1
2
3
4
Spreadsheet: 396476d0-295a-48df-b9b4-e057f9a7dfb7
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
TRYPP | Test | TRYPP | Tryptophan, Plasma | Tryptophan, P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Green top (sodium heparin) Acceptable: EDTA Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Collection Instructions: Fasting (4 hours or more in infants). Additional Information:  1. Patient's age is required. 2. Include family history, clinical condition (asymptomatic or acute episode), diet, and drug therapy information. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK- refreeze-note to lab Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | < or =23 months: 17-75 nmol/mL 2 years-17 years: 23-80 nmol/mL > or =18 years: 29-77 nmol/mL | Monday through Friday; 8 a.m. | 3 days (not reported on Saturday or Sunday) | 5 days | 1 | 82131 |  |  |  |  | Rochester
TRYPP | [NAME] | PLASMA | Plasma |  |  |  | Frozen | 7 days
TRYPP | Result | 82955 | Tryptophan | Tryptophan | Numeric |  |  |  |  | nmol/mL |  |  |  |  |  |  |  |  |  | 20659-9 | Tryptophan:SCnc:Pt:Ser/Plas:Qn:
TRYPP | Result | 34619 | Interpretation (TRYPP) | Interpretation (TRYPP) | Alphanumeric
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 |  | 1058857
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 1028469 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 |  | 1096770 |  | 2001-11-03 00:00:00
500293 |  | 615433
500302 |  | 9941
500303 |  | 325717
500305 |  | 1369116
500307 |  | 65968
500313 |  | 3131
500314
500655 | 107540
500657 |  | 158797
INDEX
2001-11-30 00:00:00 |  |  | 40288.34
2001-12-31 00:00:00
CBS Volume
 |  |  | 31564
Spreadsheet: ef76bd51-3c0e-468d-90c3-39ada3bb7974
Sheet: Sheet1

mean | 111.165454589947
sigma | 4.441298771135167
snatch | Result
108.8253425833362 | control
113.4716182579098 | control
112.1885679699671 | control
113.227550609787 | control
113.204387768617 | control
105.2153144855792 | control
112.7515842518134 | control
113.8574799533222 | control
115.2868699010379 | control
105.9210132910487 | control
115.8786607575194 | control
110.1927276085187 | control
114.3768961188829 | control
109.5531387081701 | control
111.7312164714428 | control
95 | lack of control
116.4232064584211 | control
111.1497465533106 | control
110.8817892411324 | control
107.3536348220928 | control
108.6658764221937 | control
113.201036966287 | control
109.0602463150396 | control
114.3463732037598 | control
108.2767106611794 | control
111.7811121639387 | control
110.1382383370046 | control
119.2189061956699 | control
112.7387136062412 | control
104.8753135492585 | control
113.5633764259546 | control
114.937897219867 | control
Spreadsheet: 755416d1636840674-conditional-formatting-based-on-dates-sample
Sheet: Sheet1

First Aid  (date of expiration) | 2022-09-14 00:00:00 | 2022-09-14 00:00:00 | 2023-11-06 00:00:00 | 2021-10-01 00:00:00 | 2022-09-14 00:00:00 | 2022-09-14 00:00:00 | 2022-09-14 00:00:00 | 2023-05-15 00:00:00 | 2023-05-15 00:00:00 | 2022-09-14 00:00:00
CPR  (date of expiration) | 2022-09-14 00:00:00 | 2022-09-14 00:00:00 | 2023-11-06 00:00:00 | 2022-01-01 00:00:00 | 2022-09-14 00:00:00 | 2022-09-14 00:00:00 | 2022-09-14 00:00:00 | 2023-05-15 00:00:00 | 2023-05-15 00:00:00 | 2022-09-14 00:00:00
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(LS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(LS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2011-12
 | Major Group | LS - Life Sciences
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 1 | 1 | 0 | 1
 |  | Part Time | 2 | 1 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | 0 | 0 | 0 | 0
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | m | m | m | m
Graduates who completed remedial courses during their time at the TCU |  |  | m | m | m | m
Graduates who received A*CF support at some point during their coursework |  |  | m | m | m | m
Notes:
NA denotes we do not offer the program.  We do not track graduates.
Spreadsheet: 155390d1336796780-excel-2007-multiple-occurrences-lookup-to-find-greatest-value-book1_1
Sheet: Sheet1

Unit ID | Service Plan | Coverage Hr Code | Total [NAME] |  | [NAME] referencing a cell in col F for the Unit ID |  |  |  |  | [NAME] referencing the Unit ID in the Formula
PA0002 | BR | N | 105 |  | Unit ID | FL HOURS | GO HOURS |  |  | Unit ID | FL HOURS | GO HOURS
PA0002 | GO | N | 105 |  | PA0002 | 0 | 0 |  |  | PA0002 | 53 | 105
PA0002 | GO | I | 98 |  | PA0003 | 0 | 0 |  |  | PA0003 | 105 | 105
PA0002 | GO | I | 98 |  | PA0004 | 0 | 0 |  |  | PA0004 | 105 | 105
PA0002 | FL | G | 53 |  | PA0005 | 0 | 0 |  |  | PA0005 | 45 | 45
PA0002 | FL | A | 45 |  | PA0006 | 0 | 0 |  |  | PA0006 | 53 | 98
PA0003 | BR | N | 105 |  | PA0007 | 0 | 0 |  |  | PA0007 | 53 | 105
PA0003 | FL | N | 105
PA0003 | GO | N | 105
PA0003 | GO | N | 105
PA0003 | GO | N | 105
PA0003 | GO | N | 105
PA0003 | FL | N | 105
PA0004 | BR | N | 105
PA0004 | GO | N | 105
PA0004 | GO | N | 105
PA0004 | GO | N | 105
PA0004 | FL | N | 105
PA0004 | FL | N | 105
PA0005 | BR | N | 105
PA0005 | FL | A | 45
PA0005 | GO | A | 45
PA0005 | GO | A | 45
PA0005 | GO | A | 45
PA0005 | FL | A | 45
PA0006 | BR | I | 98
PA0006 | GO | I | 98
PA0006 | GO | I | 98
PA0006 | GO | I | 98
PA0006 | FL | G | 53
PA0006 | FL | G | 53
PA0007 | BR | N | 105
PA0007 | GO | N | 105
PA0007 | GO | I | 98
PA0007 | GO | I | 98
PA0007 | FL | G | 53
Spreadsheet: 161159d1339433398-find-smallest-x-value-for-a-group-ignoring-zeros-20120611-copy-oeldere-
Sheet: Sheet1

Group | Value
District 1 | 0.205740068333397 |  |  |  | Need to find smallest value for District 3 group IGNORING zero values. Small must be used, MIN is not an option.
District 2 | 0.224022790287817
District 1 | 0.2022257821003186 |  |  |  | Smallest 1 | 0 |  | 0.1852776206504647
District 2 | 0.3080810569927493 |  |  |  | Smallest 2 | 0 |  | 0.2022257821003186
District 1 | 0.1852776206504647 |  |  |  | Smallest 3 | 0.2821625491371412 |  | 0.205740068333397
District 2 | 0.2840279136234333 |  |  |  |  |  |  | 0.210681173937228
District 1 | 0.3895433574724822 |  |  |  |  |  |  | 0.224022790287817
District 8 | 0.210681173937228 |  |  |  |  |  |  | 0.2458211936472544
District 1 | 0.2458211936472544 |  |  |  |  |  |  | 0.2821625491371412
District 3 | 0.2821625491371412 |  |  |  |  |  |  | 0.2840279136234333
District 3 | 0 |  |  |  |  |  |  | 0.3080810569927493
District 3 | 0.3895433574724822 |  |  |  |  |  |  | 0.3895433574724822
District 3 | 0 |  |  |  |  |  |  | 0.3895433574724822
Spreadsheet: 2ca1fe62-f5e1-4a21-a85e-fde368558723
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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29
本省及び法務局管内別　訟務事件の実施件数（平成21年10月）
本          省  法 務 局 管 内 |  |  | 総　　　　　 数 |  |  | 単 独 及 び 下 級 庁 と 共 同 |  |  |  |  |  |  |  |  |  |  |  | 上　級　庁　と　共　同
 |  |  |  |  |  | 計 |  |  | 申 立 準 備 事 件 |  |  | 本　訴　事　件 |  |  | 本 訴 以 外 の 事 件 |  |  | 計 |  |  | 申 立 準 備 事 件 |  |  | 本　訴　事　件 |  |  | 本 訴 以 外 の 事 件
 |  |  | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済 | 新　受 | 既　済 | 未　済
 | 総数 |  | 1337 | 1332 | 13292 | 1252 | 1200 | 11661 | 237 | 250 | 424 | 811 | 772 | 10505 | 204 | 178 | 732 | 85 | 132 | 1631 | 4 | 2 | 11 | 75 | 120 | 1593 | 6 | 10 | 27
 | 本省 |  | 113 | 90 | 1677 | 113 | 90 | 1677 | 0 | 0 | 0 | 112 | 89 | 1584 | 1 | 1 | 93 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 札幌法務局管内 |  | 32 | 40 | 758 | 30 | 34 | 710 | 2 | 9 | 17 | 25 | 22 | 663 | 3 | 3 | 30 | 2 | 6 | 48 | 0 | 0 | 0 | 2 | 6 | 48 | 0 | 0 | 0
 | 仙台法務局管内 |  | 62 | 78 | 810 | 53 | 65 | 733 | 14 | 15 | 18 | 30 | 39 | 687 | 9 | 11 | 28 | 9 | 13 | 77 | 1 | 0 | 1 | 8 | 9 | 76 | 0 | 4 | 0
 | 東京法務局管内 |  | 509 | 497 | 3487 | 490 | 433 | 2906 | 89 | 88 | 139 | 318 | 267 | 2503 | 83 | 78 | 264 | 19 | 64 | 581 | 0 | 2 | 3 | 16 | 60 | 570 | 3 | 2 | 8
 | 名古屋法務局管内 |  | 102 | 98 | 1158 | 97 | 96 | 1029 | 21 | 22 | 26 | 62 | 63 | 953 | 14 | 11 | 50 | 5 | 2 | 129 | 0 | 0 | 0 | 5 | 2 | 127 | 0 | 0 | 2
 | 大阪法務局管内 |  | 262 | 270 | 2193 | 231 | 240 | 1895 | 51 | 54 | 122 | 127 | 144 | 1646 | 53 | 42 | 127 | 31 | 30 | 298 | 3 | 0 | 7 | 25 | 28 | 282 | 3 | 2 | 9
 | 広島法務局管内 |  | 78 | 92 | 1097 | 68 | 81 | 952 | 4 | 20 | 12 | 52 | 57 | 881 | 12 | 4 | 59 | 10 | 11 | 145 | 0 | 0 | 0 | 10 | 11 | 144 | 0 | 0 | 1
 | 高松法務局管内 |  | 35 | 41 | 621 | 33 | 40 | 554 | 8 | 9 | 32 | 24 | 27 | 511 | 1 | 4 | 11 | 2 | 1 | 67 | 0 | 0 | 0 | 2 | 1 | 66 | 0 | 0 | 1
 | 福岡法務局管内 |  | 144 | 126 | 1491 | 137 | 121 | 1205 | 48 | 33 | 58 | 61 | 64 | 1077 | 28 | 24 | 70 | 7 | 5 | 286 | 0 | 0 | 0 | 7 | 3 | 280 | 0 | 2 | 6
Spreadsheet: 33283d1229589692-frequency-function-pivot-pt
Sheet: Data

[NAME] | Artikel | inkoopdocument | Positie | [NAME] tekst
1 | 40901301 | [PHONE] | 00010 | data 1
1 | 40906448 | [PHONE] | 00010 | data 2
1 | 40906448 | [PHONE] | 00010 | data 3
1 | 40943971 | 450188143 | 00010 | data 4
1 | 40943972 | [PHONE] | 00020 | data 5
1 | 40943973 | 45011943 | 00030 | data 6
1 | 49020183 | [PHONE] | 00010 | data 7
1 | 49020183 | [PHONE] | 00020 | data 8
1 | 49020183 | [PHONE] | 00010 | data 9
1 | 49020308 | [PHONE] | 00060 | data 10
1 | 49020663 | 450174919 | 00070 | data 11
1 | 49020663 | [PHONE] | 00040 | data 12
1 | 49020663 | [PHONE] | 00050 | data 13
1 | 49020663 | 450128209 | 00070 | data 14
1 | 49020663 | [PHONE] | 00070 | data 15
1 | 49020663 | [PHONE] | 00060 | data 16
1 | 49020663 | [PHONE] | 00060 | data 17
1 | 49020663 | 450173382 | 00090 | data 18
1 | 49020663 | [PHONE] | 00060 | data 19
1 | 49020663 | [PHONE] | 00070 | data 20
1 | 49020663 | [PHONE] | 00050 | data 21
1 | 49020663 | [PHONE] | 00030 | data 22
1 | 49020663 | 45013488 | 00040 | data 23
1 | 49020663 | [PHONE] | 00050 | data 24
1 | 49020663 | [PHONE] | 00080 | data 25
1 | 49020663 | [PHONE] | 00050 | data 26
1 | 49020663 | 450184751 | 00010 | data 27
1 | 49020663 | [PHONE] | 00020 | data 28
1 | 49020663 | [PHONE] | 00060 | data 29
1 | 49020663 | [PHONE] | 00040 | data 30
1 | 49020663 | [PHONE] | 00040 | data 31
1 | 49020663 | [PHONE] | 00020 | data 32
1 | 49020663 | [PHONE] | 00090 | data 33
Spreadsheet: 838388d1690979148-help-with-xlookup-formula-with-multiple-criteria-book1
Sheet: Programmes

Programme | Task
Programme 1 | Programme 1 - Task 1
Training | Training - Mentoring/Knowledge Transfer
Training | Training - Personal Development
Programme 1 | Programme 1 - 2345 - Project Name
Programme 3 | Programme 3 - Task 1
 | Programme 3 - Task 2
 | Programme 5 - Task 1
 | Absence - Other Authorised Absence
 | Absence - Sickness
 | Area Department - Task 1
 | Area Department - 2345 - Project Name
 | Programme 4 - Task 1
 | Programme 4 - Task 2
 | Non Project Meetings - Non Project Meetings
 | Line Management - Line Management
 | Managing Achievement - Managing Achievement
 | Training - e-learning
 | Training - Induction
 | Training - Training Course
 | Absence - Bank Holiday
 | Absence - Holiday
 | Programme 1 - 3456 - Project Name
 | Programme 1 - 4567 - Project Name
 | Programme 1 - Task 2
 | Programme 1 - 1234 - Project Name
Spreadsheet: 800835d1665920953-how-to-use-conditional-formatting-between-2-cells-sample-3
Sheet: Sheet1

 | Option 1 Dataset |  |  |  | Result (Avg)
 | 5 |  |  | Option 1 |  | <--- how to make E3 and F3 cell turn green since it's closer to its target 10?
 |  |  |  | Option 2
 | 15
 | 20 |  |  |  | %CV
 | Option 2 Dataset |  |  | Option 1
 | 5 |  |  | Option 2 |  | <-- how to make E8 and F8 cell turn green since it’s a lower number?
 | 6
 | 7 |  |  |  | Random criteria looking at the higher number
 | 8 |  |  | Option 1 | 6
 |  |  |  | Option 2 | 7 | <-- how to make E12 and F12 turn green since it’s the higher number?
 |  |  |  | Best option:
Spreadsheet: 51169d1250710404-help-on-a-work-schedule-ap-8-banquet-and-lounge-schedule-1-
Sheet: Week 3

 | Sat |  | Sun |  | Mon |  | [NAME] |  | Wed |  | Thur |  | Fri
 | 2009-08-15 00:00:00 |  | 2009-08-16 00:00:00 |  | 2009-08-17 00:00:00 |  | 2009-08-18 00:00:00 |  | 2009-08-19 00:00:00 |  | 2009-08-20 00:00:00 |  | 2009-08-21 00:00:00 |  | Wk Total
Bqt. Food |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Room Rental |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Bqt. Beverage |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
AV |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Est. Service Charge |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Daily Est. Rev. | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ttl Hrs | Pay rate | Ttl Wages
[NAME] | 3p | 8 | OFF |  | OFF |  | 9a | 8 | 9a | 8 | 9a | 8 | 9a | 8 | 40 | 16.83 | 673.1999999999999
 | 11p |  |  |  |  |  | 5p |  | 5p |  | 5p |  | 5p
Zane | 7a | 8 | 8a | 8 | 3p | 8 | OFF |  | 12p | 4 | 3p | 7 | OFF |  | 35 | 9.75 | 341.25
 | 3p |  | 4p |  | 11p |  |  |  | 4p |  | 10p
Cassidy | OFF |  | 6a | 4 | 4:30p | 5.5 | OFF |  | 12p | 10 | OFF |  | 5:30a | 8.5 | 28 | 8.25 | 231
 |  |  | restaurant |  | Server |  |  |  | Server |  |  |  | 2p
[NAME] | 3p | 8 | OFF |  | OFF |  | 4p | 6 | 12p | 4 | 3p | 7 | 5:30a | 8.5 | 33.5 | 7.05 | 236.175
 | 11p |  |  |  |  |  | [NAME] |  | 4p |  | 10p |  | 2p
Amber | 7a | 8 | 8a | 8 | OFF |  | 4:30p | 5.5 | 12p | 4 | 4:30p | 5.5 | OFF |  | 31 | 7.05 | 218.55
 | 3p |  | 4p |  |  |  | Server |  | 4p |  | Server
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 7.05 | 0
[NAME] | 4p | 6 | 4p | 6 | 4p | 6 | 4p | 6 | OFF |  | Off |  | 4p |  | 24 | 7.05 | 169.2
 | Bartender |  | Bartender |  | Bartender |  | Bartender |  |  |  |  |  | Bartender
[NAME] | 3p | 8 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | 8 | 7.05 | 56.4
 | Trade Center
[NAME] | 3p | 8 | OFF |  | OFF |  | OFF |  | 4p | 6 | 4p | 6 | 6p | 6 | 26 | 7.05 | 183.3
 | Trade Center |  |  |  |  |  |  |  | Bartender |  | Bartender |  | Trade Center
[NAME] | 4p | 6 | 4p | 6 |  |  |  |  |  |  |  |  | 4p | 6 | 18 | 7.05 | 126.9
 | Room Service |  | Room Service |  |  |  |  |  |  |  |  |  | Room Service
Whitney | 4:30p | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 7.05 | 42.3
 | Server
[NAME] | 4p |  | 4p |  | 4p |  |  |  |  |  |  |  |  |  | 0 | 10.5 | 0
 | training |  | training |  | training
Express Temps | 5p |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 10.42 | 0
 | 8 people
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 249.5 |  | 2278.275
 |  |  |  |  | Weekly Rev. |  |  | 0
 |  |  |  |  | Weekly Wages |  |  | #N/A
 |  |  |  |  | % of Rev. |  |  | #N/A
 |  |  |  |  | Target % |  |  | 0.2597
 |  |  |  |  | Var. to Target |  |  | #N/A |  | #N/A
Spreadsheet: phillip_m_love__30684__DenFRED
Sheet: Recon Variances

DESK | TAGG | [NAME] | VLookupGL | [NAME] | Abs | Desk Adjustment | GL Adjustment/Reclass | Comments
Denver | N67923.4 | 0 | -11250 | -11250 | 11250 |  |  | In GL not FL, Economics to look at
Denver | N66428.2 | 0 | -32995.62 | -32995.62 | 32995.62 |  |  | In GL not FL, Economics to look at
Denver | N67923.2 | 0 | 43125 | 43125 | 43125 |  |  | In GL not FL, Economics to look at
Denver | N67923.3 | 0 | -99375 | -99375 | 99375 |  |  | In GL not FL, Economics to look at
Spreadsheet: 837547d1690227748-how-to-process-surplus-amounts-in-values-surplus-values-hd
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired |  |  | Current State
 |  |  |  |  |  |  |  |  |  |  |  |  | Factor table |  |  | Results Table |  |  | Results Table
 |  |  |  |  |  |  |  |  | Date | Grade | Runtime (hours) |  | Grade | Usage Factor |  | Date | Usage |  | Date | Usage
 |  |  |  |  |  |  |  |  | 2023-07-17 00:00:00 | A | 60 |  | A | 7 |  | 2023-07-17 00:00:00 |  |  | 2023-07-17 00:00:00
 |  |  |  |  |  |  |  |  | 2023-07-19 12:00:00 | B | 12 |  | B | 4 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 2023-07-20 00:00:00 | A | 24 |  | C | 3
 |  |  |  |  |  |  |  |  | 2023-07-21 23:00:00 | C | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-21 00:00:00 |  | (start = 23:00)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-22 00:00:00 |  | (finish = 02:00)
Spreadsheet: 762445d1641562198-vlook-up-depending-on-2-criterion-book3
Sheet: Sheet1

NAME | GRADE | TYPE | ALLOWANCE |  |  |  |  |  |  | GRADE | PETROL | ELECTRIC |  |  |  |  |  | PETROL
JS | 1 | ELECTRIC |  |  |  |  |  |  |  | 1 | 4896 | 6996 |  |  |  |  |  | ELECTRIC
GT | 2 | PETROL |  |  |  |  |  |  |  | 2 | 5172 | 7500
NO | 4 | ELECTRIC |  |  |  |  |  |  |  | 3 | 5520 | 7896
DR | 5 | ELECTRIC |  |  |  |  |  |  |  | 4 | 5868 | 8196
BE | 1 | PETROL |  |  |  |  |  |  |  | 5 | 6204 | 8604
SR | 2 | ELECTRIC |  |  |  |  |  |  |  | 6 | 6900 | 9300
AR | 4 | PETROL
Spreadsheet: richard_shapiro__32163__CE2 Pack Template 2506 (FINAL VERSION)
Sheet: Appendices Full Year

FC Full Year | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Actual Headcount
Budget Full Year | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Forecast Headcount
Variance Full Year | Salaries & Wages
 | Travel & Entertainment
 | Office Expenses
 | Consultancy
 | Audit & Legal
 | Occupancy Costs
 | General & Admin
 | Communications
 | Taxes Other Than Income
 | TOTAL G&A
 | Headcount Variance
Spreadsheet: 120443d1315309272-build-range-from-marks-obtained-build-range
Sheet: Sheet1

Student | Marks Obtained | Range |  | 0- 10
A | 50 |  |  | 11-20
B | 35 |  |  | 21-30
C | 28 |  |  | 31-40
D | 48 |  |  | 41-50
E | 56 |  |  | 51-60
F | 75 |  |  | 61-70
G | 88 |  |  | 71-80
H | 38 |  |  | 81-90
I | 45 |  |  | 91-100
 | Student A got 50 marks which comesunder 41-50 Range
 | Student B got 35 marks which comesunder 31-40 Range