tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50184d1249567379-lists-and-drop-down-menus-resident-options-worksheet
Sheet: Option Comparison

RESIDENCY OPTIONS WORKSHEET |  |  |  |  |  |  |  |  | 2009-08-06 09:02:21
Campus |  | TCV
Housing Type |  | SA
Unit # |  | 111
Entrance Fee |  | 30000
 |  |  | OPTIONS
 |  |  | RENTAL |  | 80% REFUND |  | 50% REFUND |  | NO REFUND
Initial Fees to Occupy Unit |  |  | 0 |  | 30000 |  | 30000 |  | 30000
Monthly Rental or Service Fee |  |  | 515 |  | 452 |  | 367 |  | 226
Minimum Refund upon Vacating |  |  | 0 |  | 24000 |  | 15000 |  | 0
Months until minimum refund is reached |  |  | NA |  | 7 |  | 20 |  | 39
Monthly Amortization for ave life of 8.87 years |  |  |  |  | 56.36978579481399 |  | 140.924464487035 |  | 281.8489289740699
Monthly Cost of Borrowing Entrance Fee |  |  |  |  | 143.75 |  | 143.75 |  | 143.75
 |  |  |  |  | 200.119785794814 | 0 | 284.6744644870349 | 0 | 425.5989289740699
Spreadsheet: 160852d1339250026-excel-2007-issue-in-dividing-p-and-l-issue-in-dividing-p-and-l
Sheet: 1

 |  |  |  | Initial                        Capital
 |  |  | P/L                        % | Results | P/L                                    € | P/L                                    € | P/L                                    € | P/L                                    € | P/L                                    € | P/L                                    € | P/L                                    € | P/L                                    € | P/L                                    € | Progressive                          Capital
 |  | 1 |  |  | 1 | ä | 80000 | Trend Reversal Entry | 1.85 | 1.55 | Take Profit Level | 50
 |  | 2 |  |  | 2 | ã | 80000 | Breakout Entry | 1.85 | 1.55 | Stop Loss | 50
 |  | 3 |  |  | 3 | ä | 80000 | Wave Entry | 1.85 | 1.55 | Take Profit Level | 50
 |  | 4 |  |  | 4 | ã | 80000 | Wave Entry | 1.85 | 1.55 | Stop Loss | 50
 |  | 5 |  |  | 5 | ä | 80000 | Breakout Entry | 1.85 | 1.55 | Take Profit Level | 50
 |  | 6 |  |  | 6 | ã | 80000 | Trend Reversal Entry | 1.85 | 1.55 | Take Profit Level | 50
 |  | 7 |  |  | 7 | ä | 80000 | Breakout Entry | 1.85
 |  | 8
 |  | 9 |  |  | 7 |  |  |  |  | 1.65 | Take Profit  Level 1 | 50
 |  | 10 |  |  | 7 |  |  |  |  | 1.55 | Take Profit  Level 2 | 50
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
Spreadsheet: 144670d1331088315-changing-table-array-size-in-vlookup-automatically-sample
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Cash
Current Liabilities
Spreadsheet: 56937d1257121212-how-to-filter-data-in-spreadsheets-705569-kanji-filter
Sheet: Unfiltered Data

Kanji | WRP_CardID | ExampleKanji | ExampleYomi | [NAME] | 1 | 2 | 3 | 4
大 | 40 | 大きい | おおきい |  | 35 | #N/A | #N/A | #N/A
大 | 40 | 大きな家 | おおきないえ |  | 35 | #N/A | #N/A | #N/A
大 | 40 | 大丈夫 | だいじょうぶ |  | 35 | #N/A | #N/A | #N/A
大 | 40 | 大勢の | [NAME] |  | 35 | #N/A | #N/A | #N/A
大 | 40 | 大学 | [NAME] | 2 | 35 | 39
大 | 40 | 大家 | [NAME] | 2 | 35 | #N/A
学 | 40 | 大学 | [NAME] | 2 | 35 | 39
家 | 40 | 大きな家 | おおきないえ | 4 | 35 | #N/A | #N/A | #N/A
家 | 40 | 大家 | [NAME] | 2 | 35 | #N/A
国 | 41 | 天国 | てんごく | 2 | 36 | 31
天 | 41 | いい天気 | いいてんき | 4 | #N/A | #N/A | 36 | #N/A
天 | 41 | 天ぷら | てんぷら | 3 | 36 | #N/A | #N/A
天 | 41 | 天井 | てんじょう | 2 | 36 | #N/A
天 | 41 | 天国 | てんごく | 2 | 36 | 31
天 | 41 | 天才 | てんさい | 2 | 36 | #N/A
天 | 41 | 天気 | てんき | 2 | 36 | #N/A
気 | 41 | いい天気 | いいてんき | 4 | #N/A | #N/A | 36 | #N/A
気 | 41 | 天気 | てんき | 2 | 36 | #N/A
女 | 42 | 女の子 | おんなのこ | 3 | 37 | #N/A | 38
女 | 42 | 女子高生 | じょしこうせい | 4 | 37 | 38 | #N/A | #N/A
女 | 42 | 女性 | じょせい | 2 | 37 | #N/A
女 | 42 | 彼女 | かのじょ | 2 | #N/A | 37
女 | 42 | 男女 | だんじょ | 2 | #N/A | 37
女 | 42 | 長女 | ちょうじょ | 2 | #N/A | 37
子 | 42 | 女の子 | おんなのこ | 3 | 37 | #N/A | 38
子 | 42 | 女子高生 | じょしこうせい | 4 | 37 | 38 | #N/A | #N/A
生 | 42 | 女子高生 | じょしこうせい | 4 | 37 | 38 | #N/A | #N/A
男 | 42 | 男女 | だんじょ | 2 | #N/A | 37
長 | 42 | 長女 | ちょうじょ | 2 | #N/A | 37
高 | 42 | 女子高生 | じょしこうせい | 4 | 37 | 38 | #N/A | #N/A
子 | 43 | お子さん | おこさん | 4 | #N/A | 38 | #N/A | #N/A
子 | 43 | お菓子 | おかし | 3 | #N/A | #N/A | 38
子 | 43 | 子供 | こども | 2 | 38 | #N/A
子 | 43 | 帽子 | ぼうし | 2 | #N/A | 38
子 | 43 | 息子 | むすこ | 2 | #N/A | 38
子 | 43 | 椅子 | いす | 2 | #N/A | 38
大 | 44 | 大学生 | だいがくせい | 3 | 35 | 39 | #N/A
学 | 44 | 大学生 | だいがくせい | 3 | 35 | 39 | #N/A
学 | 44 | 学ぶ | まなぶ | 2 | 39 | #N/A
学 | 44 | 学校 | がっこう | 2 | 39 | #N/A
学 | 44 | 学生 | [NAME] | 2 | 39 | #N/A
学 | 44 | 数学 | すうがく | 2 | #N/A | 39
学 | 44 | 留学生 | りゅうがくせい | 3 | #N/A | 39 | #N/A
校 | 44 | 学校 | がっこう | 2 | 39 | #N/A
Spreadsheet: 189118f4-90a5-4140-9356-ae7ed91114b2
Sheet: Basic Science

CC Dept. No. | Dept No. | Department Name | Manager | Phone | Manager [NAME] | Manager [NAME] | Chair/Dean/Director | Phone | Chair Email | Department Address | Division
413801 | 4216 | Pathology | [NAME] | 966-4676 | [EMAIL] | [NAME] | [NAME] | 966-4676 | [EMAIL] | 301 Brinkhous Bullitt Building | Clinical
422001 | 4204 | Cell Biology & Physiology | [NAME] (interim) | 966-1252 | [EMAIL] | [NAME] | [NAME] | 966-5215 | [EMAIL] | 5200 MBRB | Basic
422501 | 4208 | Microbiology & Immunology | [NAME] | 966-3900 | [EMAIL] | [NAME] | [NAME] | 966-9580 | [EMAIL] | 804 [NAME] Building | Basic
423001 | 4212 | Biochemistry | [NAME] | 843-9987 | [EMAIL] | [NAME] | [NAME] | 843-6894 | [EMAIL] | 3010 Genetic Medicine Building | Basic
423501 | 4218 | Genetics | [NAME] | 843-3549 | [EMAIL] | [NAME] | [NAME] | 843-6475 | [EMAIL] | Genetic Medicine Building, Fifth Floor | Basic
424001 | 4220 | Pharmacology | [NAME] | 966-6849 | [EMAIL] | [NAME] | [NAME] | 843-3107 | [EMAIL] | 4012 Genetic Medicine Building 120 Mason Farm Road | Basic
424601 | 4275 | Biomedical Engineering | [NAME][NAME] | 966-[PHONE] | [EMAIL] [EMAIL] | [NAME] | [NAME] | 966-2291 | [EMAIL] | 152 MacNider Hall | Basic
424901 | 4290 | Social Medicine | [NAME] | 843-8263 | [EMAIL] | [NAME] | [NAME] | 843-8268 | [EMAIL] | 348 MacNider Hall | Basic
Spreadsheet: 67035741-a7ae-4fc2-950c-dc5c0d3d6deb
Sheet: Sheet1

Specifications: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Code | DVR170 | DVR171 | [NAME] | [NAME]
Compression | H.264 [CIF, 2CIF, 4CIF] 6 Levels of compression
Video In | 4CH | 8CH | 16CH | 16CH
Loop-Thru | 4CH | 8CH | 16CH | 16CH
Video Out | 2CH [BNC] + Hi-Resolution VGA [HD15]
Spot Monitor | 4CH Matrix Quad screen display
NTSC | [NAME] | [NAME] | [NAME] | [NAME]
PAL | [NAME] | [NAME] | [NAME] | [NAME]
Recording D1 | 4x25fps [100fps] | 8x25fps [200fps] | 16x12fps [200fps] | 16x25fps [400fps]
Recording ½D1 |  |  | 16x25fps [200fps]
Audio In | 4CH
Audio Out | 1CH
Compression | G.711 PCM
Motion Detect | 22x18=396 Areas at 6 levels of sensitivity [MD]
Alarm & MD | OSD, Record, Buzzer, [NAME], FTP upload.
[NAME] | 16CH
[NAME] | 6CH
PTZ | RS232 via D9 & Two Pin Wire
Hard disk | SATA up to 8pcs. Smart management and RAID.
Space Usage | Audio: 15Mb/Hr Video: 56-700Mb/Hr
Network | RJ45 [Cat5] 100M Ethernet Connection TCP/IP Protocol
Volume | 2U Rack Mount 441x430x89mm 7Kg + HDDs 240Vac 25W
Spreadsheet: 889edd01-0260-4f98-a7c9-859adb097335
Sheet: Sheet1

[NAME] | Forward | Reverse
ALPI | GTA TGT GTG GAA CCG CAC TG | CTG [NAME] AT
Furin | ACAACT ATG GGA CGC TGA CC | TGG ACA CAG CTC TTC TGG TG
G6PC | GGG TGT AGA CCT CCT GTG GA | GAG CCA CTT GCT GAG TTT CC
GSTA1 | AAG GCC CTG AAA ACC AGA AT | GCC TCC ATG ACT GCG TTA TT
Hel308 | ACA TGC CCA CTG ACA GAG G | CCA GGT CGT CAA CTT GAG CTA
HIF1A | TGC TCA TCA GTT GCC ACT TC | TCC TCA CAC GCA AAT AGC TG
HIF2A | CCA CCA GCT TCA CTC TCT CC | TCA GAA AAA GGC CAC TGC TT
HR | CAC CAG GTC TGG GTC AAG TT | GGG CGT TTT CTG TGT TGA TT
KLF9 | ATG CCA GTG ACA TCA ACC AA | CTT CAG CTT CGG TTT TCC AG
[NAME] | ACC CCA TTC GAC TAC TGT GC | TGC CAC ACT TCT CAA ACT GC
Myh6 | CCA CCC AAG TTC GAC AAG AT | CAC AGA AGA GGC CCG AGT AG
PCK1 | [NAME] | GAA CAC TTG CCC TCT CTT GC
SLC16A6 | [NAME] | TAC CTG GTG CGA AAG CAA ACA
Spreadsheet: 169219d1342729632-creating-a-data-summary-from-a-matrix-ef129_example-2-
Sheet: Schedule

 | Mon | [NAME] | Weds | Thurs | Fri | Selected: |  | seq
Tyler | 30 |  | 60 |  | 15
[NAME] | 15 | 60 | 30
[NAME] |  | 30 |  | 60 | 15
Enrique |  | 45 | 60 | 15
[NAME] | 60 |  | 60 |  | 60
[NAME] | 45 | 30 |  |  | 15
[NAME] |  | 45 | 45 | 30
Spreadsheet: 169625d1342984817-need-to-split-multiple-rows-of-four-column-grouping-into-a-single-row-extract-to-row
Sheet: Sheet2

CODE | ADMIN 1 | ADMIN 1 RAW PHONE | ADMIN 1 RAW CELL | ADMIN 1 EMAIL | ADMIN 2 | ADMIN 2 RAW PHONE | ADMIN 2 RAW CELL | ADMIN 2 EMAIL | ADMIN 3 | ADMIN 3 RAW PHONE | ADMIN 3 RAW CELL | ADMIN 3 EMAIL | ADMIN 4 | ADMIN 4 RAW PHONE | ADMIN 4 RAW CELL | ADMIN 4 EMAIL | ADMIN 5 | ADMIN 5 RAW PHONE | ADMIN 5 RAW CELL | ADMIN 5 EMAIL | ADMIN 6 | ADMIN 6 RAW PHONE | ADMIN 6 RAW CELL | ADMIN 6 EMAIL | ADMIN 7 | ADMIN 7 RAW PHONE | ADMIN 7 RAW CELL | ADMIN 7 EMAIL
ALAU | [NAME] | 5551234567 | 0 | [EMAIL] | [NAME] | 5550981234 | 0 | [EMAIL] | [NAME] | 5559801342 | 5554441212 | [EMAIL] | [NAME] | 5559994444 | 0 | [EMAIL] | [NAME] | 5558881111 | 0 | [NAME] | [NAME] | 5557778888 | 0 | [EMAIL] | CHRIS LARSON - ADMIN | 5556661212 | 0 | [EMAIL]
AxxU | [NAME] | 123454678 | 0 | [EMAIL] | barbs admin - ADMIN | 123454679 | 0 | [EMAIL] | micky - ADMIN | 123454680 | 5554441212 | [EMAIL]
ayyyy | donny - ADMIN | 3331234 | 0 | [NAME] | abe- ADMIN | 3331234 | 0 | [EMAIL]
Spreadsheet: 668595d1584912539-deferred-revenue-schedule-for-saas-excelforumhelp
Sheet: Revenue

Customer Number | Start Date | End Date | Annual Rate | Term (months)
10001 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 320000 | 3
10002 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 80000 | 3
10003 | 2019-10-01 00:00:00 | 2020-02-05 00:00:00 | 25000 | 3
10004 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 20000 | 3
10005 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 30000 | 3
10006 | 2019-10-01 00:00:00 | 2020-09-30 00:00:00 | 60000 | 5
10007 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 75000 | 12
10008 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 40000 | 12
10009 | 2019-10-01 00:00:00 | 2019-12-31 00:00:00 | 100000 | 12
10010 | 2019-10-02 00:00:00 | 2020-01-01 00:00:00 | 80000 | 3
10011 | 2019-10-02 00:00:00 | 2020-10-01 00:00:00 | 250000 | 6
10012 | 2019-10-02 00:00:00 | 2020-04-01 00:00:00 | 50000 | 12
10013 | 2019-10-03 00:00:00 | 2020-04-02 00:00:00 | 50000 | 6
10014 | 2019-10-03 00:00:00 | 2020-10-02 00:00:00 | 30000 | 12
10015 | 2019-10-05 00:00:00 | 2020-04-04 00:00:00 | 50000 | 3
10016 | 2019-10-05 00:00:00 | 2020-01-06 00:00:00 | 180000 | 6
10017 | 2019-10-07 00:00:00 | 2020-10-06 00:00:00 | 50000 | 12
10018 | 2019-10-10 00:00:00 | 2020-04-09 00:00:00 | 130000 | 6
10019 | 2019-10-10 00:00:00 | 2020-04-09 00:00:00 | 100000 | 6
10020 | 2019-10-11 00:00:00 | 2020-05-10 00:00:00 | 30000 | 7
10021 | 2019-10-12 00:00:00 | 2020-04-11 00:00:00 | 70000 | 6
10022 | 2019-10-12 00:00:00 | 2020-10-11 00:00:00 | 200000 | 12
10023 | 2019-10-15 00:00:00 | 2020-04-14 00:00:00 | 50000 | 4
10024 | 2019-10-15 00:00:00 | 2020-02-14 00:00:00 | 75000 | 6
10025 | 2019-10-15 00:00:00 | 2020-04-14 00:00:00 | 100000 | 6
10026 | 2019-10-15 00:00:00 | 2020-10-14 00:00:00 | 90000 | 12
10027 | 2019-10-16 00:00:00 | 2020-04-15 00:00:00 | 180000 | 6
10028 | 2019-10-17 00:00:00 | 2020-04-16 00:00:00 | 40000 | 6
10029 | 2019-10-17 00:00:00 | 2020-04-16 00:00:00 | 75000 | 6
10030 | 2019-10-19 00:00:00 | 2020-01-18 00:00:00 | 100000 | 3
10031 | 2019-10-20 00:00:00 | 2020-10-19 00:00:00 | 50000 | 3
10032 | 2019-10-20 00:00:00 | 2020-01-19 00:00:00 | 20000 | 12
10033 | 2019-10-22 00:00:00 | 2020-04-21 00:00:00 | 220000 | 6
10034 | 2019-10-23 00:00:00 | 2020-10-22 00:00:00 | 85000 | 12
10035 | 2019-10-24 00:00:00 | 2020-04-23 00:00:00 | 40000 | 6
10036 | 2019-10-26 00:00:00 | 2020-10-25 00:00:00 | 90000 | 6
10037 | 2019-10-26 00:00:00 | 2020-04-25 00:00:00 | 30000 | 12
10038 | 2019-10-26 00:00:00 | 2020-10-25 00:00:00 | 760000 | 12
10039 | 2019-10-27 00:00:00 | 2020-01-26 00:00:00 | 40000 | 3
10040 | 2019-10-29 00:00:00 | 2020-10-28 00:00:00 | 70000 | 12
Spreadsheet: louise_kitchen__22821__Hardship Rates
Sheet: Citigroup Medical Rates

Coverage Level | Point-of-Service Out of Area CIGNA International | Health Plan 2000 | HMO A | HMO B | HMO C
Employee Only
<25,000 | 40 | 30 | 23 | 32 | 35
$25,000-$39,999 | 47 | 36 | 29 | 38 | 42
$40,000-$59,999 | 58 | 43 | 37 | 46 | 51
$60,000-$79,999 | 70 | 47 | 47 | 57 | 63
$80,000-$99,999 | 83 | 58 | 58 | 69 | 75
$100,000-$149,000 | 99 | 67 | 70 | 82 | 90
$150,000-$199,000 | 129 | 90 | 94 | 111 | 120
$200,000-$299,999 | 139 | 95 | 99 | 117 | 126
$300,000-$499,999 | 146 | 99 | 103 | 122 | 132
>500,000 | 152 | 104 | 108 | 128 | 138
Employee & Spouse/Domestic Partner
<25,000 | 74 | 57 | 45 | 63 | 67
$25,000-$39,999 | 92 | 70 | 57 | 74 | 82
$40,000-$59,999 | 109 | 86 | 74 | 93 | 102
$60,000-$79,999 | 138 | 94 | 94 | 113 | 124
$80,000-$99,999 | 166 | 115 | 115 | 137 | 152
$100,000-$149,000 | 196 | 134 | 140 | 165 | 179
$150,000-$199,000 | 248 | 180 | 187 | 222 | 234
$200,000-$299,999 | 286 | 189 | 196 | 233 | 246
$300,000-$499,999 | 280 | 198 | 206 | 244 | 257
>500,000 | 293 | 207 | 215 | 255 | 269
Employee & Children
<25,000 | 70 | 52 | 40 | 55 | 61
$25,000-$39,999 | 85 | 65 | 52 | 68 | 76
$40,000-$59,999 | 104 | 77 | 67 | 83 | 92
$60,000-$79,999 | 126 | 85 | 85 | 103 | 113
$80,000-$99,999 | 149 | 104 | 104 | 124 | 135
$100,000-$149,000 | 178 | 121 | 126 | 148 | 162
$150,000-$199,000 | 232 | 162 | 169 | 200 | 216
$200,000-$299,999 | 250 | 171 | 178 | 211 | 227
$300,000-$499,999 | 263 | 178 | 185 | 220 | 238
>500,000 | 274 | 187 | 194 | 230 | 248
Employee & Family
<25,000 | 97 | 77 | 61 | 84 | 91
$25,000-$39,999 | 117 | 93 | 74 | 101 | 110
$40,000-$59,999 | 143 | 112 | 93 | 123 | 131
$60,000-$79,999 | 179 | 118 | 118 | 153 | 166
$80,000-$99,999 | 215 | 142 | 142 | 186 | 200
$100,000-$149,000 | 252 | 167 | 172 | 216 | 234
$150,000-$199,000 | 320 | 230 | 235 | 291 | 312
$200,000-$299,999 | 346 | 242 | 247 | 306 | 328
$300,000-$499,999 | 362 | 253 | 259 | 320 | 343
>500,000 | 378 | 265 | 270 | 335 | 359
Spreadsheet: 3e7d8c7d-0de7-4135-a2a7-50173407a2fc
Sheet: Oakland

REGIONAL DIRECTORY 2014/2015
OAKLAND UNIFIED SCHOOL DISTRICT
[NAME], Superintendent | [NAME], MEP Coordinator | [NAME], Fiscal Officer
1025 2nd Avenue Room 301 | 2111 International Blvd | 1025 2nd Avenue Room 206
Oakland, CA, 94606 | Oakland, CA, 94606 | Oakland, CA, 94606
O: [PHONE] | O: [PHONE] | O: [PHONE]
F: [PHONE] | F: [PHONE] | F: [PHONE]
[NAME] | [EMAIL] | [EMAIL]
[NAME], Claim Officer | [NAME], Controller | [NAME], Administrator Assistant II
1025 Second Avenue, Rm.308 | 1025 Second Avenue, Rm.308 | 2111 International Blvd
Oakland, CA, 94606 | Oakland, CA, 94606 | Oakland, CA, 94606
O: [PHONE] | O: [PHONE] | O:  [PHONE]
C: N/A | C: N/A | C: [PHONE]
F: 510- 879 8836 | F: 510- 879 8836 | F: [PHONE]
[NAME] | [EMAIL] | [EMAIL]
[NAME], Regional Community Liaison
O: [PHONE]
C: [PHONE]
[EMAIL]
Spreadsheet: benjamin_rogers__1032__Coal presentation Backup
Sheet: NOX Sip Call States

 | NOX SIP Call States
 | Alabama | North Carolina
 | Connecticut | New Jersey
 | District of Columbia | New York
 | Delaware | Ohio
 | Georgia | Pennsylvania
 | Illinois | Rhode Island
 | Indiana | South Carolina
 | Kentucky | Tennessee
 | Massachusetts | Virginia
 | Maryland | Wisconsin
 | Michigan | West Virginia
 | Missouri
Spreadsheet: a389502b-66d3-4979-aaac-f848c311e023
Sheet: 9-12 multiple

MENU - 9-12
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No |  |  | Decimal Equivalents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/8 Cup | 0.125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4 Cup | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/8 Cup | 0.375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/3 Cup | 0.333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/2 Cup | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/8 Cup | 0.625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2/3 Cup | 0.666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/4 Cup | 0.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7/8 Cup | 0.875
 | Low |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Mt/MA (2 oz eq per day)  (10-12 oz eq per week) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Cup | 1
 | High |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
 | Low |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Grains(2 oz eq day)
(10-12 oz eq per week) (10-12 oz eq per week)
 | High |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Vegetables (1 Cup per day)    (5 Cups per week) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 cup leafy  greens  = 1/2 cup vegetable
[NAME]  (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup |  |  |  | 1/4 cup dried fruit  = 1/2 cup fruit
Red/Orange  (1 1/4 Cup per wk)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Beans/Peas (Legumes) (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Starchy  (1/2 Cup per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Other  (3/4 per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
Daily total
Additional Vegetable to reach [NAME] (1 1/2 Cup per week)
Fruits (1 Cup per day) (5cups per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
[NAME] (1 Cup per day)  (5 a week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Spreadsheet: 121286d1315980148-combo-box-and-vlookup-formulaswithcombobox
Sheet: Example

Yes | 2 |  | <- These can be hidden or on a hidden sheet or even behind the Control
No |  |  | <-
 |  |  |  |  |  | How to Format the control
 |  |  |  |  | [NAME] examples:
 |  |  | No
 |  |  | You chose No
 |  |  | Me
[NAME] | 4
Fred
[NAME]
[NAME]
Mick |  |  |  |  | Use SUMIF to get amounts relating to the selection
 |  | Name | Amount
 |  | [NAME] | 1 |  | [NAME]
 |  | Fred | 2
 |  | [NAME] | 3 |  | 13
 |  | mary | 4
 |  | Mick | 5
 |  | [NAME] | 6
 |  | Fred | 7
 |  | [NAME] | 8
 |  | [NAME] | 9
 |  | Mick | 10
 |  | [NAME] | 11
Spreadsheet: 269401d1381154296-best-8-of-11-scores-sxs-overall-final
Sheet: Sheet1

Overall Points
SxS 2013
A - Overall Points |  |  |  | 2013-02-23 00:00:00 | 2013-03-02 00:00:00 | 2013-03-23 00:00:00 | 2013-05-25 00:00:00 | 2013-06-29 00:00:00 | 2013-07-06 00:00:00 | 2013-07-20 00:00:00 | 2013-08-10 00:00:00 | 2013-08-24 00:00:00 | 2013-09-14 00:00:00 | 2013-10-05 00:00:00
Place | Make | Nbr | Name | Points | Points | Points | Points | Points | Points | Points | Points | Points | Points | Points | Total
1 | POL | 77 | [NAME] | 297 | 300 | 297 | 299 |  | 0 | 299 | 0 | 291 | 298 | 300
2 | POL | 117 | [NAME] PHILLIPS | 0 | 298 | 296 | 295 | 298 | 297 | 0 | 296 | 298 | 0 | 298
3 | POL | 23 | DEREK MAGER | 0 | 299 | 299 | 0 | 299 | 289 | 294 | 298 | 297 | 0 | 293
4 | POL | 100 | [NAME] |  |  |  | 297 | 295 | 299 | 296 | 300 | 290 | 299 | 292
5 | POL | 302 | TABATHA FRANCE | 293 | 295 | 298 | 296 | 300 | 0 | 295 | 0 | 296 | 294 | 0
6 | POL | 74 | RUSSEL CASTER | 289 | 297 | 293 | 293 |  |  | 297 | 297 | 299 | 292 | 0
7 | POL | 24 | CHERYL MAGER | 292 | 296 | 291 | 0 | 297 | 292 | 293 | 290 | 0 | 0 | 295
8 | POL | 75 | RHONDA [NAME] | 288 | 293 | 292 | 290 |  |  | 292 | 0 | 294 | 297 | 296
9 | POL | 814 | KEVIN BYERS | 294 | 294 | 295 | 294 | 296 | 294 |  | 0 | 295 | 0 | 0
10 | POL | 618 | JOSH PATTON | 298 |  |  | 288 |  | 298 |  | 289
11 | CAM | 3 | [NAME] |  |  |  |  |  |  | 298 |  | 300 | 300
12 | UKN | 518 | [NAME] |  |  | 300 | 300 |  |  |  |  |  | 295
13 | POL | 549 | [NAME] | 300 |  | 294 |  |  | 300
14 | POL | 777 | SCOTT WYNKOOP |  |  |  | 298 |  |  |  | 299 | 289
15 | POL | 7 | ROBIN WALDROP |  |  |  |  |  |  |  | 294 | 292 | 289
16 | POL | 911 | [NAME] | 290 |  |  |  |  | 296
17 | POL | 619 | MICHAELA TINCHER |  |  |  |  |  | 291 |  | 291
18 | POL | 549 | CRAIG BOWMAN UTV |  |  |  |  |  |  | 300
19 | POL | 514 | SPENCER HAGGARD | 299
20 | HON | 487 | [NAME] SILLERY |  |  |  |  |  |  |  |  |  |  | 299
21 | POL | 897 | TRAVIS BEACH |  |  |  |  |  |  |  |  |  |  | 297
22 | POL | 828 | TAYLOR RING | 296
23 | UKN | 183 | [NAME] |  |  |  |  |  |  |  |  |  | 296
24 | ART | 7 | JON HELVIE | 295
25 | POL | 101 | JEREMY SCHULTZ |  |  |  |  |  | 295
26 | POL | 14 | [NAME] |  |  |  |  |  |  |  | 295
27 | POL | 15 | [NAME] |  |  |  |  |  |  |  | 293
28 | CAM | 59 | [NAME] ROWINGS |  |  |  |  |  |  |  |  | 293
29 | HON | 100 | ALEX RAY |  | 292
30 | POL | 217 | [NAME] |  |  |  | 292
31 | POL | 375 | TRAVIS NICHOLSON | 291
32 | YAM | 116 | MAX SMITH |  |  |  |  |  |  |  |  |  | 291
33 | UKN | 167 | [NAME] |  |  |  |  |  |  |  |  |  | 290
34 | UKN | 123 | BRETT WALKER |  |  |  | 289
35 | UKN | 98 | MADDY HAM |  |  |  |  |  |  |  |  |  | 287
36 | POL | 3 | MARK RICHARDSON |  |  |  | 286 |  |  |  |  |  |  | 0
37 | CAM | 99 | [NAME] |  |  |  | 285
38 | HON | 174 | [NAME] |  |  |  |  |  |  |  |  |  | 284
Spreadsheet: 36327d1234216063-simpler-way-to-record-the-outcomes-of-matches-league-table
Sheet: Sheet1

 | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10 |  |  | Points | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10
Team 1 |  | 1,2 | 3,2 | 1,4 | 1,5 | 1,6 | 1,7 | 1,8 | 1,9 | 1,10 |  | Team 1 | 9 |  | A | H | A | A | A | A | A | A | A
Team 2 | 2,1 |  | 2,3 | 2,4 | 2,5 | 2,6 | 2,7 | 2,8 | 2,9 | 2,10 |  | Team 2 | 11 | H |  | A | A | A | A | A | A | A | A
Team 3 | 3,2 | 3,3 |  | 3,5 | 3,6 | 3,7 | 3,8 | 3,9 | 3,10 | 3,11 |  | Team 3 | 13 | H | D |  | A | A | A | A | A | A | A
Team 4 | 3,5 | 3,6 | 3,7 |  | 3,9 | 5,10 | 3,11 | 3,12 | 3,13 | 3,14 |  | Team 4 | 12 | A | A | A |  | A | A | A | A | A | A
Team 5 | 5,1 | 5,2 | 5,3 | 5,4 |  | 5,6 | 5,7 | 5,8 | 5,9 | 5,10 |  | Team 5 | 29 | H | H | H | H |  | A | A | A | A | A
Team 6 | 6,2 | 6,3 | 6,4 | 6,5 | 6,6 |  | 6,8 | 6,9 | 6,10 | 6,11 |  | Team 6 | 34 | H | H | H | H | D |  | A | A | A | A
Team 7 | 4,3 | 4,4 | 4,5 | 4,6 | 4,7 | 4,8 |  | 4,10 | 4,11 | 4,12 |  | Team 7 | 27 | H | D | A | A | A | A |  | A | A | A
Team 8 | 7,1 | 7,2 | 7,3 | 7,4 | 7,5 | 7,6 | 7,7 |  | 7,9 | 7,10 |  | Team 8 | 46 | H | H | H | H | H | H | D |  | A | A
Team 9 | 10,1 | 5,2 | 5,3 | 5,4 | 5,5 | 5,6 | 5,7 | 5,8 |  | 5,10 |  | Team 9 | 40 | H | H | H | H | D | A | A | A |  | A
Team 10 | 2,8 | 8,3 | 8,4 | 8,5 | 8,6 | 8,7 | 8,8 | 8,9 | 8,10 |  |  | Team 10 | 43 | A | H | H | H | H | H | D | A | A
 | Goals for | Goals Against | [NAME]
Team 1 | 35 | 95 | -60
Team 2 | 45 | 95 | -59
Team 3 | 61 | 104 | -67
Team 4 | 70 | 128 | -19
Team 5 | 99 | 89 | 1
Team 6 | 116 | 98 | 10
Team 7 | 106 | 106 | 22
Team 8 | 144 | 84 | 59
Team 9 | 140 | 85 | 44
Team 10 | 164 | 96 | 164
Spreadsheet: 150450d1334547374-add-late-fee-inserting-text-and-numbers-in-sep-clumns-if-date-entered-is-past-20th-accounts-receivables
Sheet: 101

Accounts Recievable
Client ID | Month | CHRG / WK | # of Wks | CHRG/MONTH | Amnt Billed | Pmnt Date | [NAME] | [NAME] | Add Fee | BALANCE | Notes
101 | 2012-01-01 00:00:00 | 8 | 5 |  |  |  | 40 | Check # 5154 |  | 0
 | 2012-02-01 00:00:00 | 8 | 4 |  |  | 2012-02-17 00:00:00 | 32 | Check # 5230 | Late | 5
 | 2012-03-01 00:00:00 | 8 | 4 |  |  | 2012-03-09 00:00:00 | 37 | CASH R0124 |  | 0
Spreadsheet: 799786d1665298232-lookup-amount-test-4
Sheet: Sheet1

 |  | how to automatically find the amount using the cut-off date?
 |  | just so happened no dates for 01/31/2021, instead the date before that
 |  | Result must be 700.00
 |  | Cut-off Date: | 2021-01-31 00:00:00 | 2021-02-28 00:00:00
 |  | Amount: | ? | 900
 |  | Date | Amount
 |  | 2020-12-31 00:00:00 | 1000
 |  | 2020-12-31 00:00:00 | 700
 |  | 2021-02-28 00:00:00 | 900
 |  | 2021-04-14 00:00:00 | 800
 |  | 2021-04-30 00:00:00 | 1200
 |  | 2021-05-14 00:00:00 | 500
 |  | 2021-06-30 00:00:00 | 600