tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 833828d1687271733-rank-table-using-values-in-multiple-columns-golf-ranking-ans
Sheet: Arkusz1

Player |  | Score | back 9 | last 6 | last 3 | RANK
A | 28 | 12 | 8 | 3 | 3
B | 28 | 13 | 9 | 3 | 1
C | 28 | 12 | 8 | 4 | 2
Spreadsheet: 105162d1302613468-how-to-work-out-a-time-formula-to-ignore-certain-information-test-register
Sheet: Sheet1

DAILY REGISTER
MONTH: |  | 2011-04-01 00:00:00
DATE |  | NAME | START1 | FINISH1 | START2 | FINISH2 | HRS PER CHILD
FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | C.PERSON | 08:00:00 | 12:00:00
 |  | D.PERSON | 09:00:00 | 17:30:00
Spreadsheet: 872717d1719086186-sumproduct-sum-date-range-down-to-second-transactions-sample
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  | SHOULD BE:
FRIDAY |  |  |  |  |  |  |  |  |  |  |  | 6 | 488.64
START TIME | END TIME |  |  |  |  |  |  |  |  |  |  | TRANSACTIONS | AMOUNT
00:00:00 | 00:59:59
01:00:00 | 01:59:59
02:00:00 | 02:59:59
03:00:00 | 03:59:59
04:00:00 | 04:59:59
05:00:00 | 05:59:59
06:00:00 | 06:59:59
07:00:00 | 07:59:59
08:00:00 | 08:59:59
09:00:00 | 09:59:59
10:00:00 | 10:59:59
11:00:00 | 11:59:59
12:00:00 | 12:59:59
13:00:00 | 13:59:59
14:00:00 | 14:59:59
15:00:00 | 15:59:59
16:00:00 | 16:59:59
17:00:00 | 17:59:59
18:00:00 | 18:59:59
19:00:00 | 19:59:59
20:00:00 | 20:59:59
21:00:00 | 21:59:59
22:00:00 | 22:59:59
23:00:00 | 23:59:59
Spreadsheet: 012e8d62-4303-4276-9b65-bedcb781e84c
Sheet: position by div

ACCT | (Multiple Items)
PROG | (Multiple Items)
ORGN | (Multiple Items)
Row Labels | Sum of Distribution Budget
1 | 1015869
2 | 3900785
3 | 3762774
5 | 1895281
6 | 427804
(blank)
Grand Total | 11002513
Spreadsheet: 675565d1588354988-eliminating-rounding-errors-in-a-data-set-roundingsample
Sheet: Sheet1

 |  |  | A | B | C
 | STARTING NUMBER |  | 110
 |  | Factor
 | Tranche A | 0.28
 | Tranche B | 0.16
 | Tranche C | 0.48
 | Tranche D | 0.08
 | TOTAL
 |  | Price
 | Tranche A | 150
 | Tranche B | 225
 | Tranche C | 275
 | Tranche D | 325
 | TOTAL $
Spreadsheet: 017551e7-2533-489f-8592-e4b8006447e5
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | WASHINGTON COLLEGE REIMBURSEMENT | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  | INSTRUCTIONS ON BACK OF FORM
 | Employee ID/Vendor ID
 | Employee Name
 | Address
 | Account Number |  |  |  |  | Amount
 | Account Number |  |  |  |  | Amount
 | Purpose:
 | Federal Funds used: (Y) yes or (NO) no
 |  |  |  |  |  |  |  |  | 2013-02-06 13:27:17.280000
 | DATES | 2013-01-31 13:27:17.280000 | 2013-02-01 13:27:17.280000 | 2013-02-02 13:27:17.280000 | 2013-02-03 13:27:17.280000 | 2013-02-04 13:27:17.280000 | 2013-02-05 13:27:17.280000 | 2013-02-06 13:27:17.280000 | TOTALS
 | Hotel
 | Breakfast
 | Lunch
 | Dinner
 | Taxi/Fares
 | Bridge or Road Tolls
 | Parking
 | Mileage * (See Below) | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Registration Fees:
 | Plane/Train Fare
 | Miscellaneous:  Specify Below:
 |  |  |  |  | - LESS TRAVEL ADVANCE (IF APPLICABLE)
 |  |  |  |  | + PLUS RETURNED CASH FROM ADVANCE
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | MILEAGE $.51 a mile |  |  |  | TOTAL
 | Dates |  |  | TERRITORY COVERED INCURRING ABOVE EXPENSES |  |  |  |  | [NAME]*
 |  |  |  |  |  |  |  |  | 0
 | Signature of Employee |  |  |  |  |  | Date
 | [NAME]
 | Approved by |  |  |  |  |  | Date
 | IMMEDIATE SUPERVISOR
 | [NAME] SUPERVISOR
 | FOR BUSINESS OFFICE USE ONLY
 | RECEIVED: |  |  |  | VOUCHER #:
 |  |  |  |  | GIVEN TO:
Spreadsheet: 792865d1661189648-complex-formula-list-with-hlookup-but-output-value-on-different-column-example-copy
Sheet: Sheet1

TABLE
 | Value1 | Value2 | Value3 | …
Output1 | - | - | - | ...
Output2 | - | - | - | ...
Output3 | Y | - | - | ...
Output4 | - | - | - | ...
Output5 | - | - | - | ...
Output6 | - | Z | Y | ...
Output7 | X | - | - | ...
Output8 | - | - | - | ...
Output9 | - | - | Y | ...
… | - | - | - | ...
EXPECTED OUTPUT (examples):
 | Output selected from dropdown: | Value1
 | Dynamic list of all values that have a X,Y or Z against them for Value1: | Output3 | (because of Y value)
 |  | Output7 | (because of X value)
 | Output selected from dropdown: | Value2
 | Dynamic list of all values that have a X,Y or Z against them for Value2: | Output6 | (because of Z value)
 | Output selected from dropdown: | Value3
 | Dynamic list of all values that have a X,Y or Z against them for Value3: | Output6 | (because of Y value)
 |  | Output9 | (because of Y value)
 | and so on...
Spreadsheet: 686870d1594841878-create-dynamic-list-with-blank-rows-in-the-data-formulas
Sheet: Sheet2

Desired results for the balance greater than zero: |  |  |  |  |  | Desired results for a status of "No":
Acct # | Name | Balance |  |  |  | Acct # | Name | On Time
Spreadsheet: 69834d1270507156-help-with-two-colums-formulas-mlb-2010-8teams-
Sheet: WEEK 1A

MUV | BET TEAM | VS TEAM | GAME 1 | [NAME] | G1 $ Win | [NAME] | G1 $ Risk | G1   Result | GAME 2 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G2 Result | GAME 3 | [NAME] | G2 $ Win | [NAME] | G2 $ Risk | G3 Result | TOT Units Risked | TOT Units Won | TOT Units Lost
0 | BOS | NYY | -150 | 1 | 1 | 1.5 | 1.5 | L | -155 | 3.5 | 3.5 | 5.425 | 5.425 | L | -155 | 7.925 | 7.925 | 12.28375 | 12.28375 | W | 19.20875 | 1.005 | 0
0 | NYY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | OAK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PHI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | PIT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SD | ARI | -185 | 1 | 1 | 1.85 | 1.85 | L | -175 | 3.85 | 3.85 | 6.7375 | 6.7375 | L | -185 | 9.5875 | 9.5875 | 17.736875 | 17.736875 | L | 26.324375 | 0 | 26.32
 | STL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | WAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 6 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 1 | 45.533125 | 1.005 | 26.32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 69129d1269620625-timesheet-w-overtime-per-day-if-criteria-is-met-timesheet-help
Sheet: Time Calculator

Beginning Date | 2010-03-21 00:00:00 |  | Holiday during Week? | No | If Yes, What Day? |  |  |  | Yes
 |  |  |  |  |  |  |  |  | No | Monday
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Tuesday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
Employee 1 | 2010-03-21 00:00:00 | 2010-03-22 00:00:00 | 2010-03-23 00:00:00 | 2010-03-24 00:00:00 | 2010-03-25 00:00:00 | 2010-03-26 00:00:00 | 2010-03-27 00:00:00 |  |  | Wednesday | Employee 1 | 2010-03-21 00:00:00 |  | 2010-03-22 00:00:00 |  | 2010-03-23 00:00:00 |  | 2010-03-24 00:00:00 |  | 2010-03-25 00:00:00 |  | 2010-03-26 00:00:00 |  | 2010-03-27 00:00:00
Time In |  |  |  |  |  |  |  |  |  | Thursday |  | 21 | cost 1 | 21 | cost 1 | 15 | cost 1 |  | cost 1 |  | cost 1 |  | cost 1 |  | cost 1
Time Out | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00 | 11:30:00 |  |  | Friday |  |  | cost 2 |  | cost 2 |  | cost 2 |  | cost 2 |  | cost 2 |  | cost 2 |  | cost 2
Time In | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 | 12:00:00 |  |  |  |  |  | cost 3 |  | cost 3 |  | cost 3 |  | cost 3 |  | cost 3 |  | cost 3 |  | cost 3
Time Out |  |  |  |  |  |  |  |  |  |  |  |  | cost 4 |  | cost 4 |  | cost 4 |  | cost 4 |  | cost 4 |  | cost 4 |  | cost 4
Marathon Time |  |  |  |  |  |  |  | 0 |  |  |  |  | PTO |  | PTO |  | PTO |  | PTO |  | PTO |  | PTO |  | PTO
EMS Time |  |  |  |  |  |  |  | 0 |  |  |  | 21 |  | 21 |  | 15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 57
Total | -0.5 | -0.5 | -0.5 | -0.5 | -0.5 | -0.5 | -0.5 | 0
Spreadsheet: 887380d1737623449-conditional-xlookup-xlo
Sheet: Sheet1

Laurent | True | 3 |  |  | [NAME]
[NAME] | True | 5 |  |  | [NAME]
Zac | False | 0 |  |  | [NAME]
[NAME] | True | 5 |  |  | Laurent
[NAME] | True | 0 |  |  | Zac
Spreadsheet: 784723d1655921947-count-cells-with-text-timmer2005-it-needs-data-test
Sheet: Breakdown by Issues

Select Week | All Weeks
Site
PBS-C
PBS-K
SO
Spreadsheet: 78314d1278688805-group-data-book1-1-
Sheet: Sheet1

Table 1 |  |  |  |  |  |  |  |  | Table 2
Furnisher | Date | products ordered | cost per unit | Units orderd | TAX | Total Cost |  |  | Consumers | Date | products sold | cost per unit | Units sold | TAX | Total Cost
Furnisher 1 | 2010-01-02 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 1 | 2010-01-02 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-02-06 00:00:00 | [NAME] | 40 | 15 | 0.1 | 60 |  |  | Consumer 2 | 2010-02-06 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-03-02 00:00:00 | Printer | 50 | 13 | 0.1 | 65 |  |  | Consumer 3 | 2010-03-02 00:00:00 | Printer | 60 | 7 | 0.1 | 42
Furnisher 4 | 2010-04-02 00:00:00 | calculator | 3.5 | 130 | 0.1 | 45.5 |  |  | Consumer 4 | 2010-04-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
Furnisher 1 | 2010-05-02 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 5 | 2010-05-02 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-06-02 00:00:00 | Computer | 250 | 10 | 0.1 | 250 |  |  | Consumer 6 | 2010-06-02 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-07-02 00:00:00 | Printer | 50 | 10 | 0.1 | 50 |  |  | Consumer 7 | 2010-07-02 00:00:00 | Printer | 60 | 7 | 0.1 | 42
Furnisher 4 | 2010-08-02 00:00:00 | calculator | 3.5 | 130 | 0.1 | 45.5 |  |  | Consumer 8 | 2010-08-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
Furnisher 1 | 2010-09-02 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 9 | 2010-09-02 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-10-02 00:00:00 | [NAME] | 40 | 9 | 0.1 | 36 |  |  | Consumer 10 | 2010-10-02 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-11-02 00:00:00 | Printer | 50 | 10 | 0.1 | 50 |  |  | Consumer 11 | 2010-11-02 00:00:00 | Printer | 60 | 7 | 0.1 | 42
Furnisher 4 | 2010-01-03 00:00:00 | calculator | 3.5 | 130 | 0.1 | 45.5 |  |  | Consumer 5 | 2010-01-03 00:00:00 | calculator | 5 | 100 | 0.1 | 50
Furnisher 1 | 2010-02-03 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 6 | 2010-02-03 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-03-03 00:00:00 | [NAME] | 40 | 9 | 0.1 | 36 |  |  | Consumer 7 | 2010-03-03 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-04-03 00:00:00 | Printer | 50 | 10 | 0.1 | 50 |  |  | Consumer 8 | 2010-04-03 00:00:00 | Printer | 60 | 7 | 0.1 | 42
 |  |  |  |  |  |  |  |  | Consumer 6 | 2010-04-04 00:00:00 | Computer | 300 | 5 | 0.1 | 150
 |  |  |  |  |  |  |  |  | Consumer 7 | 2010-04-05 00:00:00 | Computer | 300 | 5 | 0.1 | 150
 |  |  |  | 508 |  | 1533.5 |  |  |  |  |  |  | 382 |  | 1338
 | Like this:
 | Table 3: |  |  | Units remained
 |  |  | Computer | 12
 |  |  | [NAME] | 9
 |  |  | Printer | 15
 |  |  | calculator | 90
Spreadsheet: 746812d1631040587-add-values-across-different-sheets-excelforum-sample
Sheet: Week 4

6007 | CHICKEN FILLETS | 1 |  | Apollo French Polony 125g
6451 | Apples | 2 |  | Apollo French Polony 1kg
6451 | Apples | 3 |  | Apollo French Polony 2.5kg
7042 | Chicken Chunks 12 X 600g | 4 |  | Apollo French Polony 250g
8001 | Apollo French Polony 125g | 5 |  | Apollo French Polony 2kg
8001 | Apollo French Polony 125g | 6 |  | Apollo French Polony 500g
8001 | Apollo French Polony 125g | 7 |  | Apollo French Polony 750g
8001 | Apollo French Polony 125g | 8 |  | Apollo French Polony Long 2.5kg
8001 | Apollo French Polony 125g | 9 |  | Apollo French Polony Long 3Kg
8001 | Apollo French Polony 125g | 10 |  | Apollo Polony New 125g
8001 | Apollo French Polony 125g | 11 |  | Apollo Polony New 1kg
8001 | Apollo French Polony 125g | 12 |  | Apollo Polony New 2.5kg
8001 | Apollo French Polony 125g | 13 |  | Apollo Polony New 250g
8001 | Apollo French Polony 125g | 14 |  | Apollo Polony New 2kg
8001 | Apollo French Polony 125g | 15 |  | Apollo Polony New 500g
8001 | Apollo French Polony 125g | 16 |  | Apollo Polony New 750g
8001 | Apollo French Polony 125g | 17 |  | [NAME]
8001 | Apollo French Polony 125g | 18 |  | Bacon & Cheese Griller 400g
8001 | Apollo French Polony 125g | 19 |  | Bacon Catering 1kg
8001 | Apollo French Polony 125g | 20 |  | Bacon Catering 200g
8001 | Apollo French Polony 125g | 21 |  | Bacon Cheese Griller 800 G
8001 | Apollo French Polony 125g | 22 |  | Bacon Chips 1kg
8001 | Apollo French Polony 125g | 23 |  | Bacon Chips 200g
8001 | Apollo French Polony 125g | 24 |  | Bacon Prime Cut 1kg
8001 | Apollo French Polony 125g | 25 |  | Bacon Prime Cut 200g
8002 | Apollo French Polony 250g | 26 |  | Bacon Rindless Back 1kg
8002 | Apollo French Polony 250g | 27 |  | Bacon Rindless Back 200g
8002 | Apollo French Polony 250g | 28 |  | Bacon Sasuage 800g
8002 | Apollo French Polony 250g | 29 |  | Bacon Streaky 1kg
8002 | Apollo French Polony 250g | 30 |  | Bacon Streaky 200g
Spreadsheet: 871574d1718022625-sum-cells-from-one-sheet-to-another-inventory-order-sample
Sheet: Master list

Item # | Site | Brand | Name | Size | Color | Qty of Pks | Qty/Pkg | Tot Qty. | Category
411453 | School Specialty | [NAME] | Colored Pencils - Class Pack | 144 | asst. | 3 | 144 |  | Coloring
Spreadsheet: 108129d1305215591-if-formula-help-auto-populate-a-bonus-based-on-return-on-sales-model-bonus-structure3
Sheet: Bonus '10 Q3 Metrics  (2)

Salaried Manager Bonus Structure
 | [NAME] | ROS $ | ROS %
Period 1 | 100000 | 5000 | 0.05
Period 2 | 100000 | 10000 | 0.1
Period 3 | 100000 | 9000 | 0.09
Total | 300000 | 24000 | 0.08
 |  | RM | GM
Avg. Weekly Guest Count Growth (Target -55)
Guest Count Growth |  | 0 | 0
Performance Earnings Growth
Performance Earning Groth |  | 0 | 0
Performance Earnings ROS%
0-5% | 15000 | 52.49999999999999 | 112.5
5.01-12% | 9000 | 135 | 427.5
12.01-100% | 0 | 0 | 0
 | 24000
Simply Great Incentive
Steritech Score of 92% or better | Yes
Secret Shopper Score 100% | Yes
TUAU Top Box - 65% or better | Yes
Food Quality Score of 80% of Better | Yes
Overall Cleanliness Score of 90% of better | Yes
Speed of Service Score of 70% or Better | Yes
If 1=150, 2=300, 3=455, 4=605, 5=760, 6=915 | 6 | $380 | $915
Gross Total |  | 567.5 | 1455
Less Tax | 0.3726 | 211.4505 | 542.1329999999999
Net Total |  | 356.0495 | 912.8670000000001
Spreadsheet: geir_solberg__11297__2-2act
Sheet: EPEData

 | 37364.70972222222
 | NEWMAN 1 ,UNAV,  0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 33  , 55  , 34  , 83  , 22  ,1
 | NEWMAN 3 ,ECON, 64  ,100  , 35  ,103  , 35  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,ECON, 99  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 196 ,  255,  135, 293 ,  57 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 53  , 70  , 50  ,151  ,  0  ,1
 | RIOGRANDE,,  53 ,   70,   50, 151 ,   0 ,
 | PALOVERDE,MANL,604  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 52  , 52  , 52  ,104  ,  0  ,1
 | LAMBDA, 39.34,  840,  841,  112,   -3,    0,13159,0
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,FIRM    ,PV,  ,  25,  25
 | PGT     ,LOSS    ,LC,  ,  -1,  -1
 | PNM     ,FIRM    ,FC,  ,  30,  30
 | PNM     ,FIRM    ,PV,  , -50, -50
 | PNM     ,LOSS    ,WM,  ,   3,   3
 | SPS     ,FIRM    ,ED,  , [NAME], -80
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | CISO    ,FIRM    ,PV,  ,  78,   0
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
 | 37300.62986111111
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 39  , 75  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,174  ,215  , 86  ,214  , 41  ,1
 | NEWMAN   ,, 251 ,  390,  155, 400 ,  81 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 51  , 51  , 51  ,104  ,  0  ,1
 | LAMBDA, 23.51,  798,  796,   80,   -3,    0,11060,21
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 03eb0dac-a351-44a5-9743-1d7c6afb251a
Sheet: FastFacts-data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No longer used!  [NAME] 01/05/12
 |  |  |  | Degrees, Certificates and Transfers Go Below |  |  |  |  | Retention Rates below - Run for new year and paste below |  |  |  | Enrollment - New vs. Continuing |  |  |  | Gender - Replace Each Semester |  |  |  | First Generation - Replace each Semester |  |  |  |  | Race/Ethnicity |  |  |  |  |  |  | 3 Year Success Rates - First-Time Students
 |  |  |  | FY | CTE Degrees | [NAME] | Certificates |  | Term | Fall to Spring Retention | Fall to Fall Retention |  | term_desc | New Students | Continuing Students |  | term_desc | Male | Female |  | term_desc | One or Both Parents | 1st Generation | Unknown |  | fy | White | Minority | International | Unknown/Not Reported |  |  | Term | New Students | Graduated (FRCC) | Transferred | Enrolled | Stop Out/Drop Out |  | Term |  | Graduated (FRCC) | Transferred | Enrolled | Stop Out/Drop Out | Total Success
 |  |  |  | 2008 | 445 | 593 | 1328 |  | Fall 2007 | 0.590063381721529 | 0.367613984870169 |  | Fall 2006 | 4906 | 9866 |  | Fall 2010 | 8690 | 11402 |  | Fall 2012 | 9056 | 6731 | 650 |  | 2009 | 18955 | 4728 | 91 | 998 |  |  | Fall 2001 | 4691 | 340 | 1346 | 528 | 2477 |  | Fall 2001
 |  |  |  | 2009 | 404 | 606 | 1519 |  | Fall 2008 | 0.626710230753522 | 0.400653461302838 |  | Fall 2007 | 4861 | 10401 |  |  |  |  |  |  |  |  |  |  | 2010 | 21005 | 5421 | 175 | 1810 |  |  | Fall 2002 | 5008 | 366 | 1347 | 543 | 2752 |  | Fall 2002
 |  |  |  | 2010 | 399 | 721 | 1755 |  | Fall 2009 | 0.672895677608059 | 0.403477413064673 |  | Fall 2008 | 4858 | 10837 |  |  |  |  |  |  |  |  |  |  | 2011 | 21919 | 6151 | 369 | 2198 |  |  | Fall 2003 | 4687 | 346 | 1340 | 538 | 2463 |  | Fall 2003
 |  |  |  | 2011 | 472 | 839 | 1776 |  | Fall 2010 | 0.689352170916609 | 0.406271536871123 |  | Fall 2009 | 6085 | 12628 |  |  |  |  |  |  |  |  |  |  | 2012 | 22223 | 6564 | 364 | 2265 |  |  | Fall 2004 | 4801 | 388 | 1430 | 543 | 2440 |  | Fall 2004
 |  |  |  | 2012 | 535 | 931 | 1722 |  | Fall 2011 | 0.667667314144446 | 0.389722761787038 |  | Fall 2010 | 5754 | 14338 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2005 | 4336 | 459 | 1300 | 530 | 2047 |  | Fall 2005
 |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2011 | 5663 | 14905 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2006 | 4909 | 672 | 1463 | 695 | 2079 |  | Fall 2006
 |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2012 | 5816 | 14405 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2007 | 4861 | 661 | 1555 | 704 | 1941 |  | Fall 2007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2008 | 4858 | 688 | 1544 | 730 | 1896 |  | Fall 2008
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall 2009 | 6085 | 814 | 1846 | 916 | 2509 |  | Fall 2009
Spreadsheet: 720173d1614051419-need-help-with-dates-incremented-by-25-days-and-excluding-weekends-taskgantt2
Sheet: Sheet2

 |  |  |  |  | 2021-02-22 00:00:00
FEATURE | BACKLOG ITEM | Effort | Start Date | End Date | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F |  |  |  | M |  |  |  | T |  |  |  | W |  |  |  | T |  |  |  | F
Task 1 |  | 4.25 | 2021-02-22 00:00:00
Task 2 |  | 0.75
Task 3 |  | 0.25
Task 4 |  | 0.5
Task 5 |  | 1.25
Task 6 |  | 1.5
Task 7 |  | 0.5
Task 8 |  | 3
Task 9 |  | 2.25
Task 10 |  | 1
Task 11 |  | 1.25
Task 12 |  | 1.5
Task 13 |  | 1.75
Task 14 |  | 2
Task 15 |  | 1
Spreadsheet: 98d5fa86-70a7-43c4-88aa-4086dabfce4d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: December 21, 2014 (10:56 am)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
2013 | 311650 | 314808 | 320413 | 326348
2014 | 330450 | 333078 | 336540 | X
Spreadsheet: 789862d1659417829-countif-and-countifs-not-returning-correct-result-countifs-example-not-working
Sheet: Sheet1

0.5371412037056871
0.5434259259272949
0.5720833333325572
1.266319444446708
1.315370370371966
1.329155092593282
1.412372685183072
1.468113425922638
1.530740740738111
2.05517361110833
2.057546296295186
2.078969907408464
2.102916666663077
4.31612268518802
4.335706018515339
4.413402777776355
4.44152777778072
4.51423611111386
4.53255787037051
4.581712962964957
4.631759259260434
5.302731481482624
5.306030092593573
5.307592592595029
5.30887731481198
5.335277777776355
5.400879629632982
5.417476851849642
6.314745370371384
6.570428240738693
6.614039351850806
6.617083333330811
7.252939814818092
7.446689814816636
7.633171296292858
8.386481481480587
8.534143518518249
8.555706018516503
11.47873842592526
11.49420138888672
11.60619212962774
11.73186342592817
11.73517361110862
12.10663194444351
12.12784722222568
12.1538194444438
12.31725694444322
12.35939814814628
12.42365740740934
13.15314814815065
13.16085648148146
13.38554398147971
13.38664351851912
13.4200578703676
13.52990740740643
14.33738425926276
18.3748032407384
19.30546296296234
19.35928240740759
19.41662037037167
20.5717361111092
22.26879629629548
26.54107638888672
29.48111111111211
33.55880787037313
33.58256944444292
39.39253472222481
40.57439814815007
50.47263888888847
55.5482986111092
Spreadsheet: 165315d1341161049-another-std-dev-formula-needed-sample
Sheet: Sheet1

Name | Return | Std Deviation | Weighting | Weighted return
Fund A | 0.102 | 16.1 | 0.4
Fund B | 0.091 | 9.87 | 0.4
Fund C | 0.043 | 11.13 | 0.2
Looking fo caclulation for column C
Spreadsheet: 116469d1311860101-how-to-display-or-add-a-default-value-test
Sheet: Sheet1

Column A | Column B | Column C
A | B | Column C has no value
A | B | C
Column A has no value | Column B has no value | C
Column A has no value | B | C
A | B | C
A | B | Column C has no value
A | Column B has no value | C
A | B | C
A | B | C