tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59660d1260244105-league-spreadsheet-709588-league-spreadsheet-v2
Sheet: Preview

Week | 4 |  | preview |  |  |  |  | data entry | enter week number in B1
[NAME] | 4 |  |  |  |  |  |  |  | set up pairing blocks for each pairing and enter the pairing number in the pink cell
number of pairings |  | 3 |  |  |  |  |  |  | all else is calculated.
team # | team name | rank in team | team members | Avg score | [NAME] | Handicap | VS | team # | team name | rank in team | team members | Avg score | [NAME] | Handicap
Pairing # | 1
3 | yellow | 1 | erin | 273 | 25 | 0 |  | 6 | orange | 1 | oliver | 283.3333333333333 | 51.33333333333334 | 8.266666666666652
 |  | 2 | [NAME] | 251.5 | 22.5 | 0 |  |  |  | 2 | bob | 254 | 20 | 2
 |  | 3 | elwood | 246 | 27.5 | 25.6 |  |  |  | 3 | [NAME] | 214 | 10 | 0
Pairing # | 2
4 | green | 1 | gary | 277.5 | 35 | 0 |  | 2 | red_team | 1 | ray | 300 | 51 | 18
 |  | 2 | grendel | 254.3333333333333 | 31 | 0 |  |  |  | 2 | [NAME] | 276 | 30 | 17.33333333333333
 |  | 3 | greg | 240 | 27.66666666666667 | 0 |  |  |  | 3 | ron | 252.5 | 27.5 | 10
Pairing # | 3
5 | purple | 1 | [NAME] | 289 | 44 | 12.8 |  | 3 | yellow | 1 | erin | 273 | 25 | 0
 |  | 2 | pete | 271 | 39 | 15.6 |  |  |  | 2 | [NAME] | 251.5 | 22.5 | 0
 |  | 3 | [NAME] | 260 | 35 | 11.2 |  |  |  | 3 | elwood | 246 | 27.5 | 0
Standings
Blue | 4 |  | This sheet gives an overview of who plays vs who and what the handicaps are.
red | 0 |  | The Standings overview show the points collected per team up to the week selected above
yellow | 4
green | 2
purple | 2 |  | player's rank within the team is recaclulated every week
orange | 2 |  | players are sorted by rank here to match up teamA #1 vs teamB #1
 |  |  | ranking changes can be studied on the Teams sheet as the weeks progess
copy the other team |  |  | compare the blue team pecking order between week 2 and week 3 preview
names into this list |  |  | note that teams end up in different spots each week, because of the pairings ….
and copy the formula in
B30 down
Spreadsheet: 785742d1656670538-i-want-to-return-multiple-values-against-a-series-of-values-sample-for-forum-transpose-aligw
Sheet: Returned Values

Identification Digit | Lender | Lender | Lender | Lender
 |  | BBC | CBC
2
3 |  | CBC | ABC | DBC
4 |  | DEF
5 |  | JKL | MNO
6
7
Spreadsheet: 713312d1610642426-turning-a-list-of-users-into-a-matrix-test
Sheet: Users

User | Role | Performer | Reviwer | Approver
1 | Performer
1 | Reviewer
1 | Approver
2 | Performer | x | x
2 | Reviewer | x | x
3 | Performer
3 | Reviewer
3 | Verifier
3 | Approver
Spreadsheet: phillip_platter__31372__ca0912epmib
Sheet: SupplyBids

Min Price | 0
[NAME] | 2500
Price Offset | 0.01
Type | Supply
[NAME]
 | P1 | Q1 | P2 | Q2 | P3 | Q3 | P4 | Q4 | P5 | Q5 | P6 | Q6 | P7 | Q7 | P8 | Q8 | Total Q
HE1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
HE2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
HE23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01 | 0 | 0 | 0
HE25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Generated PX Bids -- SUPPLY
 | P1 | Q1 | P2 | Q2 | P3 | Q3 | P4 | Q4 | P5 | Q5 | P6 | Q6 | P7 | Q7 | P8 | Q8 | P9 | Q9 | P10 | Q10 | P11 | Q11 | P12 | Q12 | P13 | Q13 | P14 | Q14 | P15 | Q15 | P16 | Q16
HE1 | 0 | 0 | 2500 | 0
HE2 | 0 | 0 | 2500 | 0
HE3 | 0 | 0 | 2500 | 0
HE4 | 0 | 0 | 2500 | 0
HE5 | 0 | 0 | 2500 | 0
[NAME] | 0 | 0 | 2500 | 0
HE7 | 0 | 0 | 2500 | 0
HE8 | 0 | 0 | 2500 | 0
HE9 | 0 | 0 | 2500 | 0
HE10 | 0 | 0 | 2500 | 0
HE11 | 0 | 0 | 2500 | 0
HE12 | 0 | 0 | 2500 | 0
HE13 | 0 | 0 | 2500 | 0
HE14 | 0 | 0 | 2500 | 0
HE15 | 0 | 0 | 2500 | 0
HE16 | 0 | 0 | 2500 | 0
HE17 | 0 | 0 | 2500 | 0
HE18 | 0 | 0 | 2500 | 0
HE19 | 0 | 0 | 2500 | 0
HE20 | 0 | 0 | 2500 | 0
HE21 | 0 | 0 | 2500 | 0
HE22 | 0 | 0 | 2500 | 0
HE23 | 0 | 0 | 2500 | 0
HE24 | 0 | 0 | 2500 | 0
Accepted Volumes
 | MCP | Q1 |  | Q2 |  | Q3 |  | Q4 |  | Q5 | Total
HE1
HE2
HE3
HE4
HE5
[NAME]
HE7
HE8
HE9
HE10
HE11
HE12
HE13 |  |  | 36.9 | 36.9 | 36.9 | 37.1 | 36.9 | 36.7 | 0.5 | 25 | 0
HE14 |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 5 | 5
HE15
HE16
HE17
HE18
HE19
HE20
HE21
HE22
HE23
HE24
Spreadsheet: 39af394c-fcb0-4b3c-860f-6c23d2d35b0b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
Please click on required table number:
[NAME] |  | Definition
4.4.1 | Smoking Prevalence (Adults) - Model-Based Estimate by Local Authority: 2003-05 | Click here for data definition
4.4.2 | Smoking During Pregnancy by PCT: 2006/07 | Click here for data definition
4.4.3 | Prevalence of Binge-Drinking (Adults) - Model-Based Estimate by Local Authority: 2003-05 | Click here for data definition
4.4.4 | Alcohol Attributable Hospital Admissions by Local Authority (All Ages) - MALES: 2005/06 | Click here for data definition
4.4.5 | Alcohol Attributable Hospital Admissions by Local Authority (All Ages) - FEMALES: 2005/06
4.4.6 | Alcohol Specific Hospital Admissions by Local Authority (All Ages) - MALES: 2005/06 | Click here for data definition
4.4.7 | Alcohol Specific Hospital Admissions by Local Authority (All Ages) - FEMALES: 2005/06
4.4.8 | Alcohol Specific Mortality by Local Authority (All Ages) - MALES: 2003-2005 Pooled | Click here for data definition
4.4.9 | Alcohol Specific Mortality by Local Authority (All Ages) - FEMALES: 2003-2005 Pooled
4.4.10 | Estimated Prevalence of Hazardous Drinking in the Adult Population by Local Authority: Mid-2005 | Click here for data definition
4.4.11 | Estimated Prevalence of [NAME] in the Adult Population by Local Authority: Mid-2005
4.4.12 | Consumption of Fruit & Vegetables (Adults) - Model-Based Estimate by Local Authority: 2003-05 | Click here for data definition
4.4.13 | Adults Participating in at least 30 mins Physical Activity (3 days a week) by Local Authority: 2005/06 | Click here for data definition
4.4.14 | Adults Participating in at least 30 mins Physical Activity (5 days a week) by Local Authority: 2005/06
4.4.15 | Prevalence of Obesity (Adults) - Model-Based Estimate by Local Authority: 2003-05 | Click here for data definition
4.4.16 | Problem Drug Use - Estimated Number by Drug Action Team Area: 2005/06 | Click here for data definition
4.4.17 | Problem Drug Use - Estimated Prevalence by Drug Action Team Area: 2005/06
Spreadsheet: 183928d1349097004-create-one-new-column-of-unique-data-from-two-columns-0a1_fot_unique_-1
Sheet: Φύλλο1

 |  |  |  |  | Unique List
2 | 2 |  |  |  |  |  | 2
5 | 5 |  |  |  |  |  | 5
4 | 9 |  |  |  |  |  | 4
9 | 3 |  |  |  |  |  | 9
8 | 6 |  |  |  |  |  | 8
7 | 8 |  |  |  |  |  | 3
1 | 7 |  |  |  |  |  | 7
 | 11 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 11
Spreadsheet: 862989d1710531834-simple-sumif-not-working-sumif-question
Sheet: Sheet1

Name | Jan  Simple | Feb  Simple | [NAME] | Jan  Detailed | Feb  Detailed | [NAME] | # [NAME] | # [NAME] Detailed |  |  |  | [NAME] | Sue | [NAME]
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Total Simple
[NAME] | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  | Total Detailed
[NAME] | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Grand Total
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Why does this formula not work?  I think I should get 2 for [NAME], 3 for [NAME] and 5 for [NAME]
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | =SUMIF(A2:A25,"Jim",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | =SUMIF(A2:A25,"Sue",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | =SUMIF(A2:A25,"John",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 1
Sue | 1 | 1 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 149372d1333890721-if-cells-in-column-match-merge-other-cells-together-cp49321_tool-search_07apr12_02
Sheet: Sheet1

Gage ID | Description | Gage S/N | Type | Notes | Current Location | Last Cal Date | Next Due Date | Database
[NAME] | 6" | 0079282 caliper | Digital Caliper | ok |  |  | 2013-05-15 00:00:00 | Gager
[NAME] | QE, 6 DIGITAL CALIPERS |  |  |  | G0400 | 2011-05-16 00:00:00 |  | ERP
QE-001021 | 6" | 0379003 Caliper | Digital Caliper | ok |  | 2011-05-16 00:00:00 | 2013-05-15 00:00:00 | Gager
QE-001021 | QE, 6 DIGITAL CALIPERS |  |  |  | G0400 |  |  | ERP
QE-001234 | 8" | 0000153 HG | Height Gage |  |  | 2011-11-16 00:00:00 | 2013-11-15 00:00:00 | Gager
QE-001234 | QE, HEIGHT STAND 8 |  |  |  | G0500 |  |  | ERP
[NAME] | 12 x 18 | SP | Surface Plate |  |  | 2010-06-29 00:00:00 | 2015-06-29 00:00:00 | Gager
[NAME] | QE, 12 X 18 SURFACE PLATE |  |  |  | G0500 |  |  | ERP
QE-001368 | QE, VARIABLE LENGTH |  |  |  | G0100 |  |  | ERP
QE-eric cartman | Hue | Hue | Hue Qualification | Certification on file | Delat | 2012-01-06 00:00:00 | 2013-01-07 00:00:00 | Gager
Spreadsheet: 42602d1241133405-excel-2007-excel-formula-aprnmae
Sheet: Aprnorm

 |  |  | April
 | Normal |  |  | Record
 | Maximum | Minimum | Mean | Maximum | Year | Minimum | Year
1 | 58.96774193548387 | 40.34375 | 45 | 82 | 1978 | 28 | 2003
2 | 57.25806451612903 | 39.34375 | 45 | 75 | 1986 | 30 | 1987
3 | 58.25806451612903 | 39.78125 | 46 | 80 | 1981 | 29 | 2008
4 | 57.80645161290322 | 39.8125 | 46 | 76 | 1981 | 28 | 1995
5 | 57.12903225806452 | 39.15625 | 46 | 83 | 1985 | 21 | 1995
6 | 56.29032258064516 | 38.625 | 47 | 77 | 1991 | 17 | 1982
7 | 58.29032258064516 | 39.3125 | 47 | 87 | 1991 | 16 | 1982
8 | 59.48387096774194 | 38.71875 | 48 | 90 | 1991 | 23 | 1982
9 | 57.80645161290322 | 39.34375 | 48 | 85 | 1991 | 26 | 1977
10 | 61.74193548387097 | 39.28125 | 48 | 76 | 2002 | 24 | 1985
11 | 59.64516129032258 | 40.5625 | 48.5 | 78 | 1987 | 32 | 1989
12 | 61.93548387096774 | 41.125 | 48.5 | 90 | 1977 | 33 | 1989
13 | 61.12903225806452 | 42.21875 | 48.5 | 86 | 1977 | 27 | 1990
14 | 59.87096774193548 | 41.59375 | 50 | 77 | 2002 | 32 | 1989
15 | 60.90322580645162 | 43.15625 | 50 | 88 | 2002 | 32 | 1997
16 | 62.67741935483871 | 43.875 | 50 | 94 | 2002 | 32 | 1980
17 | 63.96774193548387 | 42.8125 | 51 | 100 | 2002 | 30 | 1980
18 | 64.48387096774194 | 44.46875 | 51 | 93 | 2002 | 35 | 1990
19 | 67.06451612903226 | 45 | 51 | 91 | 2002 | 32 | 1988
20 | 65.87096774193549 | 46.25 | 52 | 87 | 2005 | 35 | 1981
21 | 65.54838709677419 | 46.40625 | 52 | 84 | 1985 | 31 | 1981
22 | 65.7741935483871 | 44.4375 | 52 | 87 | 2001 | 32 | 1984
23 | 64.2258064516129 | 44.6875 | 52.5 | 86 | 2007 | 32 | 1989
24 | 65.48387096774194 | 46.78125 | 52.5 | 88 | 2001 | 34 | 1989
25 | 65.54838709677419 | 46.15625 | 52.5 | 81 | 1982 | 32 | 1999
26 | 65.48387096774194 | 46.15625 | 54 | 85 | 1985 | 37 | 2002
27 | 67.80645161290323 | 47.34375 | 54 | 90 | 1990 | 38 | 2000
28 | 67.96774193548387 | 47.46875 | 54 | 90 | 1990 | 39 | 1998
29 | 67.38709677419355 | 47.375 | 55 | 83 | 1983 | 38 | 1987
30 | 68.25806451612904 | 47.875 | 55 | 87 | 1985 | 39 | 2002
Spreadsheet: 475355d1471279171-how-to-highlight-a-row-beneath-last-data-entered-and-to-also-insert-a-row-beneath-that-template
Sheet: BCP PEN

Descripción operación | RUC number | Monto | Currency | PROJECT_I | OPEN_INVC_A | INVC_I | AxeCustNum | CUSTOMER NAME 1 | CURR | BT NUMER | COMPROBANTE OFISIS
CH O/BCO000 | [PHONE] | 67529.79 |  |  |  |  | 243001 | TECSUR S.A. | PEN
EFECTIVO000 |  | 3176.5 |  |  |  |  | 247584 |  | USP
CH O/BCO000 | [PHONE] | 579.9 |  |  |  |  | 243001 | TECSUR S.A. | PEN
EFECTIVO000 | [PHONE] | 144.56 |  |  |  |  | 253257 | AGROPECUARIA LA RINCONADA DE CONTA SAC
Spreadsheet: 093053da-65f1-4a48-a3b1-aa12c7aa08d6
Sheet: Compare

Lunch and Breakfast Income and Expense Per Meal |  |  |  |  | Enter district number  in yellow cells.
Comparisons Among Districts |  |  |  |  | For state totals, enter 9999.  For Minneapolis, enter 1.3.
Districts: |  |  | 625 | 1.3 | 11 | 273 | 283 | 270 | 9999
Income Per Lunch |  | Paid by students
 |  | State reimbursement
 |  | Federal reimbursement
 |  | Total for students
 |  | Adult
 |  | Total Combined
Expense Per Lunch |  | Food
 |  | Milk
 |  | Labor
 |  | Benefits
 |  | Supply/other
 |  | Total
Income Per Breakfast |  | Paid by students
 |  | State reimbursement
 |  | Federal reimbursement
 |  | Total for students
 |  | Adult
 |  | Total Combined
Expense Per Breakfast |  | Food
 |  | Milk
 |  | Labor
 |  | Benefits
 |  | Supply/other
 |  | Total
 | Lunch
 | Income
1 | Paid by students |  |  |  |  |  |  |  |  |  | 8
 | State reimbursement |  |  |  |  |  |  |  |  |  | 13
 | Federal reimbursement |  |  |  |  |  |  |  |  |  | 16
 | Adult |  |  |  |  |  |  |  |  |  | 21
 | Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Federal other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Expense
 | Food |  |  |  |  |  |  |  |  |  | 28
 | Milk |  |  |  |  |  |  |  |  |  | 34
 | Labor |  |  |  |  |  |  |  |  |  | 40
 | Benefits |  |  |  |  |  |  |  |  |  | 46
 | Supply/other |  |  |  |  |  |  |  |  |  | 52
 | Contributions
 | Oper Contr.
 | [NAME]. Equip. |  |  |  |  |  |  |  |  |  | 58
 | Meals served
 | Free |  |  |  |  |  |  |  |  |  | 64
 | Reduced |  |  |  |  |  |  |  |  |  | 65
 | Paid |  |  |  |  |  |  |  |  |  | 68
 | Non-reim. |  |  |  |  |  |  |  |  |  | 66
 | Income per meal
 | Expense per meal
 | Percentage breakdown of student meal costs
 | Percentage breakdown of expenses
 | Breakfast
 | Income
 | Paid by students |  |  |  |  |  |  |  |  |  | 9
 | State reimbursement |  |  |  |  |  |  |  |  |  | 14
 | Federal reimbursement |  |  |  |  |  |  |  |  |  | 17
 | Adult |  |  |  |  |  |  |  |  |  | 22
 | Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Federal other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Expense
 | Food |  |  |  |  |  |  |  |  |  | 29
 | Milk |  |  |  |  |  |  |  |  |  | 35
 | Labor |  |  |  |  |  |  |  |  |  | 41
 | Benefits |  |  |  |  |  |  |  |  |  | 47
 | Supply/other |  |  |  |  |  |  |  |  |  | 53
 | Contributions
 | Oper Contr.
 | [NAME]. Equip. |  |  |  |  |  |  |  |  |  | 59
 | Meals served
 | Free |  |  |  |  |  |  |  |  |  | 69
 | Reduced |  |  |  |  |  |  |  |  |  | 70
 | Paid |  |  |  |  |  |  |  |  |  | 73
 | Non-reim. |  |  |  |  |  |  |  |  |  | 71
 | Income per meal
 | Expense per meal
 | Percentage breakdown of student meal costs
 | Percentage breakdown of expenses
Spreadsheet: 832830d1686626135-calculate-freq-and-servicable-day-on-the-same-equip-sample
Sheet: Master

Sno | QIR Date | Week No | Equip | Item Tag Date | Work Order | Car | Car No 1 | Car No2 | Serial No | Date Code | Location | Team | Frequency | Service Day
1 | 2016-11-03 00:00:00 |  | ABC | 2016-10-31 00:00:00 | 650677 | 32039 |  |  | 00299 | 1321 | 1 | 1
2 | 2016-11-03 00:00:00 |  | ABC | 2016-10-28 00:00:00 | 650902 | 32038 |  |  | 00299 | 1321 | N.A | 2
3 | 2016-11-04 00:00:00 |  | ABC | 2016-11-04 00:00:00 | N.A | 32003 |  |  | 0078 | 0027 | 2 | 1
4 | 2016-11-04 00:00:00 |  | ABC | 2016-11-04 00:00:00 | N.A | 32004 |  |  | 0078 | 0027 | 2 | 1
5 | 2016-11-07 00:00:00 |  | ABC | 2016-11-04 00:00:00 | N.A | 32003 |  |  | 0078 | 0027 | 1 | 3
6 | 2016-11-07 00:00:00 |  | ABC | 2016-11-04 00:00:00 | N.A | 33004 |  |  | 0078 | 0027 | 2 | 4
7 | 2016-11-07 00:00:00 |  | ABC | 2016-11-04 00:00:00 | N.A | 32004 |  |  | 0078 | 0027 | 1 | 1
8 | 2016-11-07 00:00:00 |  | ABC | 2016-11-04 00:00:00 | N.A | 33004 |  |  | 0152 | 0104 | 1 | 1
9 | 2016-11-07 00:00:00 |  | XYZ | 2016-11-04 00:00:00 | N.A | 33003 |  |  | 0155 | 0122 | 2 | 1
10 | 2016-11-07 00:00:00 |  | XYZ | 2016-11-04 00:00:00 | N.A | 33003 |  |  | 0038 | 0007 | 1 | 1
11 | 2016-11-09 00:00:00 |  | XYZ | 2016-11-08 00:00:00 | 652449 | 32047 |  |  | 0017 | 9942 | N.A | 1
12 | 2016-11-09 00:00:00 |  | XYZ | 2016-11-08 00:00:00 | N.A | 32048 |  |  | 00299 | 1321 | N.A | 2
13 | 2016-11-09 00:00:00 |  | XYZ | 2016-11-08 00:00:00 | 652449 | 32048 |  |  | 0030 | 0007 | N.A | 2
14 | 2016-11-10 00:00:00 |  | XYZ | 2016-11-09 00:00:00 | 652727 | 32013 |  |  | 0085 | 0026 | N.A | 3
15 | 2016-11-10 00:00:00 |  | XYZ | 2016-11-09 00:00:00 | 652727 | 33014 |  |  | 0148 | 0104 | 1 | 3
16 | 2016-11-14 00:00:00 |  | ABC | 2016-10-28 00:00:00 | 650087 | 33021 |  |  | 0148 | 0104 | N.A | 3
Spreadsheet: 58510d1258737558-cell-phone-optimization-long-if-statement-cellphoneplanoptimization
Sheet: Sheet1

Cell Phones | Monthly Rate | Free Minutes | Excess Time | Long Distance | Text Message
Flat Rate Plan | 8.95 | 0 | 0.13 | 0.1 | 0.15
1200 Minute Plan | 80 | 1200 | 0.15 | 0.1 | 0.15
Imove 1800 | 140 | 1800 | 0.15 |  | 0.15
Imove 3400 | 210 | 3400 | 0.15 |  | 0.15
Flat Rate Plan: (B11+(D11*K24)+(E11*L24)+(F11*M24)) |  |  |  |  |  |  |  |  | 0 | Flat Rate Plan | 77.85
 |  |  |  |  |  |  |  |  | 616 | 1200 Minute Plan | 112.5 | -25.5
1200 Minute Plan: IF(AND(K24<J18,K24<H16),(B12+(E12*L24)+(F12*M24)),(B12+(D12*(K24-C12))+(E12*L24)+(F12*M24))) |  |  |  |  |  |  |  |  | 1600 | Imove 1800 | 170 | -58
 |  |  |  |  |  |  |  |  | 2266 | Imove 3400 | 240 | -228
1800 minute plan: IF(AND(K24<J19,K24<H17),(B13+(F13*M24)),(B13+(D13*(K24-C13))+(F13*M24))),
3400 minute plan: IF(AND(K24>J19,K24<H18),(B14+(F14*M24)),(B14+D14*(K24-C14)+(F14*M24)))) |  |  |  |  |  |  |  |  |  | 2009-Aug |  |  |  |  |  |  | 2009-Sep
 |  |  |  |  |  |  |  | Current Plan |  | Minutes Used | Long Distance Min | Text Messages | Current Plan Cost | Optimal Plan Cost | Difference |  | Minutes Used | Long Distance | Text Messages | Current Plan Cost | Optimal Plan Cost | Difference
 |  |  |  |  |  |  |  | 1200 Minute Plan |  | 280 | 25 | 200 | 112.5 | $77.85 Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
 |  |  |  |  |  |  |  | Flat Rate Plan
Spreadsheet: 714801d1611376826-how-to-calculate-exeact-sum-and-using-formula-calculation-sum-and-
Sheet: Sheet1 (2)

 | % | Total | Count | Total Rent | Rent for CC | Sum() | Diff.
 | 0.2424242424242424 |  | 1
 | 0.2121212121212121 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.1212121212121212 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.06060606060606061 |  | 1
 |  |  | 1 Total | 123
 | 0.5 |  | 2
 | 0.5 |  | 2
 |  |  | 2 Total | 1001
 | 0.09523809523809523 |  | 3
 | 0.4761904761904762 |  | 3
 | 0.04761904761904762 |  | 3
 | 0.2380952380952381 |  | 3
 | 0.1428571428571428 |  | 3
 |  |  | 3 Total | 127
Spreadsheet: 801592d1666265415-formula-to-give-all-the-possible-combinations-data-eduardo_v1-n
Sheet: Sheet1

 | 2 Combinations |  |  |  |  | 3 Combinations
 | Variable 1 | Variable 2 | Qty | Sum |  | Variable 1 | Variable 2 | Variable 3 | Qty | Sum
 | A | D |  |  |  | A | D | G
 | A | E |  |  |  | A | D | I
 | A | F |  |  |  | A | E | G
 | A | G |  |  |  | A | E | H
 | A | H |  |  |  | A | F | G
 | A | I |  |  |  | A | F | I
 | B | D |  |  |  | B | D | G
 | B | E |  |  |  | B | D | I
 | B | F |  |  |  | B | E | G
 | B | G |  |  |  | B | E | H
 | B | H |  |  |  | B | F | G
 | B | I |  |  |  | B | F | I
 | C | D |  |  |  | C | D | G
 | C | E |  |  |  | C | D | I
 | C | F |  |  |  | C | E | G
 | C | G |  |  |  | C | E | H
 | C | H |  |  |  | C | F | G
 | C | I |  |  |  | C | F | I
 | D | G
 | D | I
 | E | G
 | E | H
 | F | G
 | F | I
Spreadsheet: 868ac784-ae5d-476f-87d7-92e9614608a3
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
4510 | 15775 | [NAME] | Sveum | NOR | 35 | 00:27:10 | 00:00:35 | [NAME] | 00:00:40 | 00:32:00 | 1 | 01:33:47
4510 | 21781 | [NAME] | Dalen | NOR | 34 | 00:29:47 | 00:00:48 | 00:35:49 | 00:01:22 | 00:34:15 | 2 | 01:42:03
4510 | 11121 | Angelika | Perfler | AUT | 33 | [NAME] | 00:00:45 | 00:39:25 | 00:01:29 | 00:44:15 | 3 | 01:55:43
4510 | 15487 | Yuliya | Barabash | RUS | 32 | 00:30:13 | [NAME] | 00:30:15 | 00:01:30 | 00:00:00 | DNF | 00:00:00
4510 | 17427 | Helen | [NAME] | EST | 31 | 00:29:40 | 00:00:43 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 859467d1707842783-if-sum-problem-copy-of-test-data-gradings-aligw
Sheet: Sheet1

Location ID | Store Grade 2023 | Category 1 | Survey submitted | No of calls to store | Latest Visit | Grade | Movement |  | AliGW
11228895 | Ungraded | Cycle 1 | 2024-01-02 11:15:36 | 1 |  | Ungraded | as not latest from H2 this should be blank | Blank
11239325 | [NAME] | Cycle 1 | 2024-01-05 10:56:46 | 1 |  | Ungraded | as not latest from H2 this should be blank | Blank
11238872 | Silver | Cycle 1 | 2024-01-15 11:28:45 | 1 |  | [NAME] | as not latest from H2 this should be blank | Blank
11228811 | Gold | Cycle 1 | 2024-01-15 11:28:45 | 1 |  |  | as not latest from H2 this should be blank | Blank
11228895 | Ungraded | Cycle 2 | 2024-02-12 09:14:06 | 2 | latest | Ungraded |  | Unchanged
11239325 | [NAME] | Cycle 2 | 2024-02-12 10:41:11 | 2 | latest | Ungraded |  | Loss
11238872 | Silver | Cycle 2 | 2024-02-12 09:16:07 | 2 | latest | Gold |  | Gain
11228811 | Gold | Cycle 2 | 2024-02-12 09:16:07 | 2 | latest | [NAME] |  | Loss
 |  |  |  |  |  |  | if A and G match return the word unchanged
 |  |  |  |  |  |  | If G is better than B return the word Gain
 |  |  |  |  |  |  | if g is worse than B return the word loss
Spreadsheet: 719767d1613793921-lookup-function-to-return-email-addresses-sample
Sheet: RESULTS

Keyword | [NAME] | Url
www.4yourpetz.com.au | [EMAIL]
www.abodecafe.com.au | [EMAIL] | http://www.abodecafe.com.au/contact/
www.abwaj.com.au | [EMAIL] | https://www.abwaj.com.au/?page_id=279
www.amity.pet | [EMAIL] | https://amitypetfood.com/en/
www.anchorbuoy.com.au | [EMAIL] | https://www.anchorbuoycafe.com.au/
www.animalambulance.com.au | [EMAIL] | http://www.brisbaneanimalambulance.com.au/
www.animalphysio.com.au | [NAME] | https://animalphysio.com.au/horse-rider-integration/
www.aplusvets.com.au | [EMAIL] | http://www.aplusvets.com.au/contact-us.html
www.aquavue.com.au | [EMAIL] | https://aquavue.com.au/contact-us/
www.aquisfarm.com | [EMAIL] | https://aquisfarm.com/team/
www.athertontablelandsbirdwatcherscabin.com.au | [EMAIL] | https://www.athertontablelandsbirdwatcherscabin.com.au/elementor-1925/
[NAME] | [EMAIL] | https://www.awlqld.com.au/locations/contact/
www.babbsnick.wix.com | [EMAIL] | https://babbsnick.wixsite.com/anchorage-waters
www.barkinghampalace.com.au | [EMAIL] | http://www.barkinghampalace.com.au/location.html
www.basenjibreednetwork.org.au | [EMAIL] | https://www.basenjibreednetwork.org.au/?page_id=90
www.bayaroma.com.au | [EMAIL] | https://bayaroma.com.au/job-opportunities
[NAME] | [EMAIL] | https://www.bayviewvets.com.au/contact-us.aspx
www.beach400m.com | [EMAIL] | https://www.petfriendly.com.au/page/caloundra-beach-townhouse
www.beerwahvets.com.au | [EMAIL] | https://www.localvet.com.au/Beerwah/contact-us.aspx