tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0f91f58a-1f92-4160-9d34-80b96a047575
Sheet: Sheet1

ISS Business Partner Setup | Unnamed: 1 | Please return to: | [NAME] | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Note: Required Entries in Red
Dept # Responsible | Name of | Invoice | Contact | Contact | Billing | Billing | Billing | Billing | Billing
for Business Partner | Business Partner | Contact Name | [NAME] | Telephone | Address Line 1 | Address Line 2 | City | State | Zip Code
Spreadsheet: 89006d1288800261-userform-variable-how-to-call-a-value-from-a-combo-box-for-email-confirmation-otform-draft
Sheet: Lists

Location | Office Manager | [NAME] | Medical Director |  |  | Specialities | Previos?
Astoria | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Allergy | Yes
Elmhurst | [NAME] | [EMAIL] | Dr. [NAME] or Dr. [NAME] |  |  | Dermatology | No
Elmhurst Pediatrics | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Primary Care
[NAME] | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Cardiology
Flushing South | Therese [NAME] | [EMAIL] | Dr. [NAME] |  |  | Endocrinology
Forest Hills | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Gastroenterology
Richmond Hill | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Oncology/Hematology
Jamaica Estates | [NAME] | [EMAIL] | Dr. [NAME] |  |  | [NAME]
Rochdale | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Rheumatology
Babylon | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Neurology
Hempstead | [NAME] | [EMAIL] | Dr. [NAME] |  |  | OB/GYN
Hicksville | Ed Rondot | [EMAIL] | Dr. [NAME] |  |  | Opthalmology
Lake Success | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Orthopedics
Valley Stream | [NAME] | [EMAIL] | Dr. [NAME] |  |  | E.N.T.
Woodbury | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Pediatrics
Ronkonkoma | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Radiology
Cambria Heights | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Surgery
Rockaway | [NAME] | [EMAIL] | Dr. [NAME] |  |  | Urology
Spreadsheet: 0307b4df-f7a2-4664-819f-ad908c8f236e
Sheet: Lunch Prices & Counts

LUNCH PROGRAM
PRICES / COUNTS / OTHER INCOME
 |  |  |  | Counts:
 |  | Meal Prices: |  | *Reimbursable Meal ADP: |  |  | *Total for School Year
School Builiding | Enrollment | Adult | Student | Free | Reduced | Paid | A la Carte and Other Income
Total
*Check one:
(   ) The ADP (Average Daily Participation) and A la Carte/Catering Information is based on data from a projection for the current school year __________
using the month(s) of insert months/year.
(   ) The ADP (Average Daily Participation) and A la Carte/Catering Information is based on data from the entire previous school year ___________.
Spreadsheet: 750204d6-bc83-4a78-88b3-890658c5ebd4
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
 |  | U.S. Census Bureau
 |  | Source: U.S. International Trade in Goods and Services
 |  | Balance of Payment Goods and Services: United States
 |  | Seasonally Adjusted Balance [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: April 21, 2014 (8:25 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | -2026 | -831 | -2641 | -3109 | -3919 | -2824 | -2781 | -4455 | -3530 | -3520 | -3968 | -5603
1993 | -3871 | -3596 | -6777 | -6445 | -4369 | -6929 | -6382 | -5581 | -7031 | -6594 | -7016 | -5719
1994 | -6207 | -9245 | -6466 | -7887 | -7728 | -8380 | -8739 | -8303 | -8310 | -9158 | -9615 | -8456
1995 | -9324 | -8817 | -9708 | -9609 | -9090 | -10623 | -7688 | -6704 | -5924 | -6114 | -6514 | -6271
1996 | -8465 | -7319 | -7756 | -8744 | -9259 | -7460 | -10132 | -10357 | -10195 | -6635 | -7268 | -10475
1997 | -11269 | -9776 | -8383 | -8086 | -8394 | -7154 | -7033 | -8743 | -9269 | -9089 | -9786 | -11289
1998 | -10776 | -11564 | -12880 | -13940 | -14202 | -13247 | -13949 | -16028 | -14820 | -14815 | -15173 | -14745
1999 | -16157 | -18900 | -18250 | -18650 | -20730 | -23716 | -24134 | -23662 | -23489 | -23874 | -25617 | -26578
2000 | -27471 | -30395 | -31664 | -29098 | -30042 | -31241 | -31820 | -30303 | -34269 | -33770 | -33158 | -34106
2001 | -35155 | -29383 | -32628 | -31367 | -27809 | -29436 | -30103 | -28278 | -30899 | -30771 | -29672 | -26836
2002 | -29374 | -32142 | -30816 | -33591 | -33985 | -35103 | -33980 | -35929 | -36596 | -34721 | -39010 | -42918
2003 | -40617 | -39112 | -43215 | -41957 | -40725 | -39607 | -41024 | -39404 | -41262 | -40756 | -39300 | -43569
2004 | -44160 | -43902 | -46101 | -46865 | -47792 | -54428 | -50941 | -52827 | -50953 | -54539 | -58325 | -54067
2005 | -55321 | -57167 | -52343 | -56749 | -55786 | -57734 | -57481 | -57760 | -64123 | -66384 | -63326 | -63738
2006 | -66507 | -62000 | -61481 | -61909 | -63983 | -62815 | -65927 | -67235 | -64214 | -58085 | -57543 | -60699
2007 | -57173 | -58273 | -61682 | -60043 | -58904 | -59298 | -59205 | -56238 | -56941 | -55883 | -58942 | -56483
2008 | -60304 | -63517 | -59512 | -62999 | -61683 | -60431 | -66260 | -61415 | -59948 | -59769 | -44243 | -42220
2009 | -37568 | -27540 | -28966 | -29385 | -25291 | -26451 | -32972 | -31352 | -34411 | -33949 | -37405 | -38368
2010 | -37228 | -40969 | -40077 | -40935 | -41355 | -46860 | -41223 | -45480 | -44571 | -40665 | -38514 | -41503
2011 | -47795 | -45213 | -43377 | -42125 | -47442 | -50984 | -45461 | -44674 | -44553 | -46083 | -47783 | -51349
2012 | -51393 | -43763 | -47790 | -46625 | -46247 | -42430 | -43451 | -44007 | -41570 | -42650 | -46422 | -38307
Spreadsheet: 837649d1690320007-conditional-formatting-from-a-separate-range-roster-template-2023-07-25
Sheet: G1

Date: |  | 2023-07-15 00:00:00 |  |  | Field: | 3 |  | Start Time: |  | 11:30:00
Home: |  | SYB 8U All Star Black |  |  | 3rd | Set Up
Visitors: |  | CBDL - Rockets Blue |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | P (1)
2 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | C (2)
3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B (3)
4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2B (4)
5 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3B (5)
6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | SS (6)
7 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | LF (7)
8 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | CF (8)
9 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | RF (9)
10 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | SF (10)
11 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 686605d1594713259-formula-to-sum-up-in-different-columns-book1
Sheet: Sheet1

Existing Data |  |  | Required data
Colour | Number |  | Total positive | Total negative
red | 1 |  | 1 | 0
red | 3 |  | 3 | 0
red | -5 |  | 0 | -5
red | -2 |  | 0 | -2
Total |  |  | 4 | -7
green | 2 |  | 2 | 0
green | -3 |  | 0 | -3
green | 3 |  | 3 | 0
green | 6 |  | 6 | 0
green | 5 |  | 5 | 0
green | -1 |  | 0 | -1
Total |  |  | 16 | -4
Spreadsheet: 832913d1686666050-help-with-counting-unique-values-online-orders
Sheet: Stats

Month | Total Online Orders | Total no. of sales | Online Orders Finalised | % Sales | Awaiting Finalization | % Sales Awaiting | Failed Orders | % Sales Failed |  | Description | Stats
2021-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | No. of sales
2021-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | Total Purchases
2021-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | Average order value
2021-05-01 00:00:00
2021-06-01 00:00:00
2021-07-01 00:00:00 |  |  |  |  |  |  |  |  |  | Description | Stats | Failed Orders
2021-08-01 00:00:00 |  |  |  |  |  |  |  |  |  | No. of sales
2021-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | Bank Transfer/Store | 48 | 30
2021-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | Online - Failed | 37 | 21
2021-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | Online - Success | 5 | 0
2021-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | Test | 10 | 10
2022-01-01 00:00:00
2022-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | Awaiting store finalisation |  | % to Sales
2022-03-01 00:00:00
2022-04-01 00:00:00
2022-05-01 00:00:00 |  |  |  |  |  |  |  |  |  | Description | Stats
2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2021 Sales
2022-07-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2022 Sales
2022-08-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2023 Sales
2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | Total
2022-10-01 00:00:00
2022-11-01 00:00:00
2022-12-01 00:00:00
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-04-01 00:00:00
2023-05-01 00:00:00
2023-06-01 00:00:00
2023-07-01 00:00:00
Total
Category | Total Online Orders | Total no. of sales | Online Orders Finalised | % Sales | Awaiting Finalization | % Sales Awaiting | Failed Orders | % Sales Failed
Bedding |  | 49
Bedroom Furniture |  | 24
Coffee Table |  | 1
Cooking |  | 2
Dining |  | 5
[NAME] |  | 18
Lounge Leather |  | 2
Microwave Oven |  | 2
Refrigeration |  | 5
Seasonal |  | 1
Sound |  | 4
Tables |  | 3
Vision |  | 6
Wall Units |  | 8
Test |  | 12
Total
Store | Total Online Orders | Total no. of sales | Online Orders Finalised | % Sales | Awaiting Finalization | % Sales Awaiting | Failed Orders | % Sales Failed
1776 - Luanshya |  | 1
1777 - Ndola 2 |  | 4
1782 - Lewanika |  | 4
1839 - Livingstone |  | 11
5001 - Waterfalls Mall |  | 1
5004 - Ndola |  | 1
5006 - Manda Hill |  | 35
5007 - Kitwe |  | 5
5009 - Chingola |  | 2
5013 - Kabwe |  | 6
5015 - Mufulira |  | 5
5040 - Solwezi |  | 10
5043 - Cosmo |  | 15
5044 - Mukuba Mall |  | 11
5053 - Kabwe Mall |  | 3
5054 - Chipata |  | 2
5056 - Mansa |  | 1
5060 - Jacaranda
Test |  | 12
Total
Payment Method | Total Online Orders | Total no. of sales | Online Orders Finalised | % Sales | Awaiting Finalization | % Sales Awaiting | Failed Orders | % Sales Failed
Bank Transfer/Store |  | 50
Online - Failed |  | 46
Online - Success |  | 5
Test |  | 10
Total
Spreadsheet: 849843d1700224742-if-function-returns-incorrect-value-calcs
Sheet: Kelly block

• Sliding check
Characteristic sliding force | Hslid,k | = | 6.71
Factor of safety | FOS | = | 1.5
Design sliding force | Hslid,[NAME] | = | Fslid,k x FOS
 |  | =
Friction coefficient (see [NAME]) | μ | = | 0.4
Try,
Density of the counterweight | ρcounter | = | 23.6
Length of the counterweight | Lcounter | = | 1
[NAME] of the counterweight | Bcounter | = | 1
Depth of the counterweight | Hcounter | = | 0.1
Weight of the counterweight | Wcounter | =
Sliding resistance force | HRd | = | μ x (ρcounter x Lcounter x Bcounter x Hcounter)
 |  | = |  |  |  |  | Update formatting for [NAME],[NAME] when copying to Word
Spreadsheet: 21440d1208966947-how-to-find-number-of-rows-that-meets-cumulative-percentage-critieria-sample
Sheet: Sheet1

 |  |  | CensusTract | Group1 | Percent | Group2 | Percent
 |  |  | City Total | 1245 | 1 | 2940 | 1
 |  |  | 1 | 10 | 0.008032128514056224 | 105 | 0.03571428571428571
 |  |  | 2 | 50 | 0.04016064257028112 | 170 | 0.05782312925170068
 |  |  | 3 | 140 | 0.1124497991967871 | 255 | 0.08673469387755102
 |  |  | 4 | 25 | 0.02008032128514056 | 195 | 0.0663265306122449
 |  |  | 5 | 100 | 0.08032128514056225 | 135 | 0.04591836734693878
 |  |  | 6 | 120 | 0.0963855421686747 | 235 | 0.07993197278911565
 |  |  | 7 | 170 | 0.1365461847389558 | 330 | 0.1122448979591837
 |  |  | 8 | 55 | 0.04417670682730924 | 140 | 0.04761904761904762
 |  |  | 9 | 75 | 0.06024096385542169 | 260 | 0.08843537414965986
 |  |  | 10 | 35 | 0.02811244979919679 | 110 | 0.03741496598639456
 |  |  | 11 | 190 | 0.1526104417670683 | 160 | 0.05442176870748299
 |  |  | 12 | 35 | 0.02811244979919679 | 135 | 0.04591836734693878
 |  |  | 13 | 70 | 0.05622489959839357 | 155 | 0.05272108843537415
 |  |  | 14 | 95 | 0.07630522088353414 | 260 | 0.08843537414965986
 |  |  | 15 | 75 | 0.06024096385542169 | 295 | 0.1003401360544218
Spreadsheet: 750646d1633558377-calculate-moving-average-of-last-5-and-last-3-rows-test-1-
Sheet: Data

Name | Number
[NAME] | 84.53650575583448
[NAME] | 81.67763205719825
[NAME] | 19.79129731614984
[NAME] | 35.59235625300897
[NAME] | 33.64062221316598
[NAME] | 85.27390451296016
[NAME] | 72.95339313667093
[NAME] | 53.09228745963527
[NAME] | 17.95855924315455
[NAME] | 9.662712718665334
[NAME] | 36.73179795161015
[NAME] | 37.93230236412175
[NAME] | 42.89571432713186
[NAME] | 18.09858837578847
[NAME] | 27.33826358295355
[NAME] | 80.03414872438552
[NAME] | 61.61154098629419
[NAME] | 53.69682101609836
[NAME] | 11.37846974994533
[NAME] | 15.19307613792178
[NAME] | 47.91246575486059
[NAME] | 68.30995549481324
[NAME] | 47.2750435463964
[NAME] | 28.9763788923186
[NAME] | 46.42201586216509
[NAME] | 37.29313498031351
[NAME] | 88.08543844950391
[NAME] | 19.98530668349347
Spreadsheet: 882174d1730413948-substitute-word-from-one-pick-list-with-a-word-from-another-picklist-example
Sheet: Sheet1

Customer Rocks | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  | Customer Rocks | [NAME]
Customer on fire | Percy | Percy on fire |  |  |  |  |  |  |  |  |  | New Customer Submission | Percy
New Customer Submission | [NAME] | New Paul Submission |  |  |  |  |  |  |  |  |  | Customer on fire | [NAME]
[NAME] standing | [NAME] | [NAME] standing |  |  |  |  |  |  |  |  |  | [NAME] standing | [NAME]
Spreadsheet: 835247d1688451436-min-max-values-by-calendar-year-ef_sample
Sheet: Sheet1

Date | Value |  | Task #1
2017-01-01 00:00:00 | 5 |  | Min and [NAME] for each year.
2017-01-02 00:00:00 | 4 |  | Task #2
2017-01-03 00:00:00 | 3 |  | Last date those values occurred in each year.
2017-01-04 00:00:00 | 2
2017-01-05 00:00:00 | 1 |  | Data spans 2017 to present
2017-01-06 00:00:00 | 8
2017-01-07 00:00:00 | 2.2 |  | Year | Min | Min Date | [NAME] | [NAME]
2017-01-08 00:00:00 | 3.5 |  | 2017
2017-01-09 00:00:00 | 9 |  | 2018
2017-01-10 00:00:00 | 22 |  | 2019
2017-01-11 00:00:00 | 35 |  | 2020
2017-01-12 00:00:00 | 88.7 |  | 2021
2017-01-13 00:00:00 | 2 |  | 2022
2017-01-14 00:00:00 | 8 |  | 2023
2017-01-15 00:00:00 | 14
2017-01-16 00:00:00 | 22
2017-01-17 00:00:00 | 15
2017-01-18 00:00:00 | 17
2020-01-19 00:00:00 | 16
2020-01-20 00:00:00 | 25
continuing to the present day.
Spreadsheet: 677895d1589570037-lookup-a-value-and-return-column-that-has-non-blank-value-trucksummary
Sheet: Truckplan

 |  | DATA |  |  |  |  |  |  |  | RESULTS
 |  | Date | Truck1 |  |  |  |  |  |  |  | Truck1
 |  |  | Zone A | Zone B | Zone C | Zone D | Zone E |  |  | Date | Zone | Planned Nr of Trips |  | Zone | Planned Nr of Trips
 |  |  | Nr of trips
 |  | 2020-04-06 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-06 00:00:00 | Zone A | 4
 |  | 2020-04-07 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-07 00:00:00 | Zone A | 4
 |  | 2020-04-08 00:00:00 |  | 4 |  |  |  |  |  | 2020-04-08 00:00:00 | Zone B | 4
 |  | 2020-04-09 00:00:00 |  | 4 |  |  |  |  |  | 2020-04-09 00:00:00 | Zone B | 4
 |  | 2020-04-10 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-10 00:00:00 | Zone C | 3
 |  | 2020-04-11 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-11 00:00:00 | Zone C | 3
 |  | 2020-04-12 00:00:00 |  |  | 0 |  |  |  |  | 2020-04-12 00:00:00 | Maitenance | 0
 |  | 2020-04-13 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-13 00:00:00 | Zone C | 3
 |  | 2020-04-14 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-14 00:00:00 | Zone C | 3
 |  | 2020-04-15 00:00:00 |  |  | 3 |  |  |  |  | 2020-04-15 00:00:00 | Zone C | 3
 |  | 2020-04-16 00:00:00 |  |  |  | 2 |  |  |  | 2020-04-16 00:00:00 | Zone D | 2
 |  | 2020-04-17 00:00:00 |  |  |  | 2 |  |  |  | 2020-04-17 00:00:00 | Zone D | 2
 |  | 2020-04-18 00:00:00 | 4 |  |  |  |  |  |  | 2020-04-18 00:00:00 | Zone A | 4
 |  | 2020-04-19 00:00:00 | 0 |  |  |  |  |  |  | 2020-04-19 00:00:00 | Maitenance | 0
Spreadsheet: CharReport_Demo
Sheet: October

Customer Characteristics Report
 |  | Amount funded: | Total $ Funded: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
October |  | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Customer Name | Date | Dealer | Approved By | Tier | [NAME] | [NAME] | S-Yield | Amt Fin | FICO Primary | Term | [NAME] | Year of Vehicle | Make | Model | Payment | Down Payment | Trade | Rebate | LTV % line 3 | LTV % line 5 | PTI | DTI | FICO - Co | Discount | Part Points | Part $ | Rent/Own | Time @ Res in Years | Time @ Job Primary | Time @ Job CO | Age Primary | Age    CO | Warranty | GAP | Within Program | Comments
Spreadsheet: 144448d1330978361-calculating-contract-values-over-a-defined-number-of-months-for-multiple-contracts-contracted-revenue-v2
Sheet: Contracted Revenue Projections

 | NOTES:
 | First revenue value for each Customer/Service Order should first appear in the month indicate in the Service Date
 | First month revenue calculation should consist of the SUM of the NRC TOTAL and the NRC TOTAL pro-rated for the remainder of the month from the Service Date
 | Subsequent months revenue is simply the MRC total
 | The final month of each Customer/Service Order should be the number of months detailed in the term after the Service Date and should not be pro-rated.
Customer Name | Service Order # | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
Contracted Monthly Revenue
Spreadsheet: 240842d1370436556-cricket-club-career-spreadsheet-umtcc
Sheet: Leading Games

ALL TIME LEADING GAMES PLAYED
Regular season and Finals games only.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 687593d1595303035-randomly-picked-names-from-overall-list-need-to-pick-those-chosen-and-group-names-1-
Sheet: Sheet1

 |  |  |  |  |  |  | General Playes |  |  |  |  |  |  | 28th July Maxies
 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Dr [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  | [NAME] | 5
Spreadsheet: 493648d1481815375-help-creating-auto-sum-quantity-quantity-sales
Sheet: Sheet1

Product name | What we got delivered | What we have in our Store 1 | What we have in our Store 2 | What we have in our Store 3 | [NAME] box to chose from what store how mutch quantity are sold | What we have left in Store 1 | What we have left in Store 2 | What we have left in Store 3 | What we have left from all Stores | All sold quantity
 | Delivevred | Store1 | [NAME] | Store3 | Store1 | Store1 | [NAME] | Store3 | Store All | All Sold |  | Sold | Store1 | [NAME] | Store3
Product 1 | 12 | 4 | 4 | 4 |  |  |  |  |  |  |  | Product 1 | 1 | 2 | 3
Product 2 | 13 | 4 | 2 | 7 |  |  |  |  |  |  |  | Product 2 | 2 | 2 | 3
Product 3 | 44 | 14 | 10 | 20 |  |  |  |  |  |  |  | Product 3 | 3 | 2 | 3
Product 4 | 31 | 10 | 10 | 11 |  |  |  |  |  |  |  | Product 4 | 4 | 2 | 3
Product 5 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | Product 5 | 2 | 2 | 2
Product 6 | 4 | 1 | 2 | 1 |  |  |  |  |  |  |  | Product 6 | 1 | 2 | 1
Product 7 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | Product 7 | 1 | 1 | 1
Product 8 | 46 | 20 | 16 | 10 |  |  |  |  |  |  |  | Product 8 | 8 | 2 | 3
Spreadsheet: 04d6c623-a932-483f-a784-9656485951d7
Sheet: Sheet1

Weekly Registration and Comparison Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Fall Term 201108 -- End Date
 | College Credit Hours
 | Current |  | Compared to |  |  | Compared to
 | Term |  | Same Time Last Year |  |  | Fall 201008 10th Day
Fall | 2011-12-19 00:00:00 |  | 2010-12-20 00:00:00 | % of 2010 |  | 2010-09-07 00:00:00 | % of 2010
Quad Cities Campus | 39861 |  | 40198.5 | 0.9916041643344901 |  | 47646 | 0.8366074801662259
East Campus | 9900 |  | 10049.5 | 0.9851236379919399 |  | 10670.5 | 0.9277915749027693
District | 49761 |  | 50248 | 0.9903080719630633 |  | 58316.5 | 0.8532919499627035
 | College Credit Headcount
 | Current |  | Compared to |  |  | Compared to
 | Term |  | Same Time Last Year |  |  | Fall 201008 10th Day
Fall | 2011-12-19 00:00:00 |  | 2010-12-20 00:00:00 | % of 2010 |  | 2010-09-07 00:00:00 | % of 2010
Quad Cities Campus | 4762 |  | 4782 | 0.9958176495190297 |  | 5013 | 0.9499301815280271
East Campus | 952 |  | 933 | 1.020364415862808 |  | 942 | 1.010615711252654
District | 5714 |  | 5715 | 0.999825021872266 |  | 5955 | 0.9595298068849706
Spreadsheet: 874470d1721062975-spill-error-on-excel-table-spill-error
Sheet: Customers

 | I'm requesting a formula that can produce the desired excel table. The current formula produces #SPILL Error
 |  |  |  |  | Desired Solution
 | Name | I.D Number |  |  | Name | I.D Number
 |  |  |  |  | CT 275
 |  |  |  |  | CT 408
 |  |  |  |  | CT 233
 |  |  |  |  | CT 180
 |  |  |  |  | CT 002
 |  |  |  |  | CT 420
 |  |  |  |  | CT 004
 |  |  |  |  | CT 200
Spreadsheet: 698106d1601747465-criteria-based-ranking-test
Sheet: Test

 |  |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Except | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-06 00:00:00 | [NAME] |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  |  | * Rank 1 is to be given for XXX & YYY items (in col. E), then ranking is to be done of only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.5 | Urgent | 2020-05-11 00:00:00 | [NAME] |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  |  | 3
CTR_06 | 3.41 | Urgent | 2020-04-21 00:00:00 |  |  | 4
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  |  | 5
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00 | YYY |  | 1
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 6
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 6