tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2124__DecCohCHOICE-ENA
Sheet: Dec 12

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-12 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1731 |  | 1644 |  | 67694 |  |  |  |  |  | 12 | 1 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 2 | 21
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 9009 |  | 7076 |  | 67694 |  |  |  |  |  | 13 | 3 | 22
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 14 | 4 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 5 | 24
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 3546 |  | 2905 |  | 67694 |  |  |  |  |  | 15 | 6 | 22
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 14 | 7 | 19
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 19 | 8 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 9 | 24
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 23561 |  | 19644 |  | 67694 |  |  |  |  |  | 24 | 15 | 26
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 17 | 35 | 20
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68915 | 0 |  |  |  |  | 14 | 39 | 18
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2853 |  | 1952 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 2149 |  | 1839 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 20389 |  | 16017 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3290 |  | 2555 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 5299 |  | 4724 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 6767 |  | 5902 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1680 |  | 1446 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 58 |  | 54 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 797567d1663956810-use-smaller-than-in-getpivotdata-formula-2022-09-23-oeldere-jonas-martens-test-8-
Sheet: Sheet1

 |  |  |  |  | Month | Product | Amount |  |  | Get sum of all appels before 6th month
 |  |  |  |  | 1 | Appels | 23
 |  |  |  |  | 1 | Pears | 16
 |  |  |  |  | 2 | Appels | 63
 |  |  |  |  | 2 | Pears | 5 |  |  |  |  |  |  |  | Kolomlabels
 |  |  |  |  | 3 | Appels | 12 |  |  |  |  |  |  |  | Appels |  | Pears |  | Totaal Sum of Amount | [NAME]
 |  |  |  |  | 3 | Pears | 85 |  |  |  |  |  |  | Rijlabels | Sum of Amount | Som [NAME] | Sum of Amount | Som [NAME]
 |  |  |  |  | 4 | Appels | 45 |  |  |  |  |  |  | 1 | 23 | 23 | 16 | 16 | 39 | 39
 |  |  |  |  | 4 | Pears | 63 |  |  |  |  |  |  | 2 | 63 | 86 | 5 | 21 | 68 | 107
 |  |  |  |  | 5 | Appels | 12 |  |  |  |  |  |  | 3 | 12 | 98 | 85 | 106 | 97 | 204
 |  |  |  |  | 5 | Pears | 78 |  |  |  |  |  |  | 4 | 45 | 143 | 63 | 169 | 108 | 312
 |  |  |  |  | 6 | Appels | 45 |  |  |  |  |  |  | 5 | 12 | 155 | 78 | 247 | 90 | 402
 |  |  |  |  | 6 | Pears | 61 |  |  |  |  |  |  | 6 | 45 | 200 | 61 | 308 | 106 | 508
 |  |  |  |  | 7 | Appels | 52 |  |  |  |  |  |  | 7 | 52 | 252 | 12 | 320 | 64 | 572
 |  |  |  |  | 7 | Pears | 12 |  |  |  |  |  |  | 8 | 25 | 277 | 85 | 405 | 110 | 682
 |  |  |  |  | 8 | Appels | 25 |  |  |  |  |  |  | 9 | 63 | 340 | 23 | 428 | 86 | 768
 |  |  |  |  | 8 | Pears | 85 |  |  |  |  |  |  | 10 | 43 | 383 | 38 | 466 | 81 | 849
 |  |  |  |  | 9 | Appels | 63 |  |  |  |  |  |  | 11 | 64 | 447 | 42 | 508 | 106 | 955
 |  |  |  |  | 9 | Pears | 23 |  |  |  |  |  |  | 12 | 25 | 472 | 51 | 559 | 76 | 1031
 |  |  |  |  | 10 | Appels | 43 |  |  |  |  |  |  | Eindtotaal | 472 |  | 559 |  | 1031
 |  |  |  |  | 10 | Pears | 38
 |  |  |  |  | 11 | Appels | 64
 |  |  |  |  | 11 | Pears | 42 |  |  |  | =GETPIVOTDATA("Amount",$O$7,"Month",<6,"Product","Appels")
 |  |  |  |  | 12 | Appels | 25
 |  |  |  |  | 12 | Pears | 51 |  |  |  | I was hoping this would work
Spreadsheet: 215073d1361257586-how-to-catalogue-multiple-data-samples
Sheet: Sheet1

Input
Code | Product | Buyer | [NAME] | Quantity | Price | Value
abc12 | Product 1 | A | B | 10 | 1
abc12 | Product 1 | A | B | 20 | 1
abc15 | Product 2 | B | C | 10 | 2
abc16 | Product 3 | B | C | 40 | 1
abc17 | Product 4 | D | C | 15 | 3
abc17 | Product 4 | D | C | 20 | 3
abc17 | Product 4 | D | C | 10 | 3
Output
Code | Product | Buyer | [NAME] | Quantity | Price | Value
abc12 | Product 1 | A | B |  | 1
abc15 | Product 2 | B | C |  | 2
abc16 | Product 3 | B | C |  | 1
abc17 | Product 4 | D | C |  | 3
Spreadsheet: 600189d1543514596-conditional-formatting-using-formula-with-mod-conditional-formatting
Sheet: Sheet1

A | B | C | D | E | F | G | H | I
J | K | L | M | N | O | P | Q | R
S | T | U | V | W | X | Y | Z
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 | 51 | 52 | 53 | 54
55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63
64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72
73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81
82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90
91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99
Spreadsheet: 05a3b7e8-d9f3-42f5-95bf-8d10227d50bc
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 48. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (NT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413737T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413738V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413739W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413740F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413741J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413742K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413743L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413744R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413745T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413746V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413747W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 703049d1604692408-using-mround-to-round-up-in-increments-of-15-formula_working
Sheet: JUN 1-7

Individual:
Staff Name(s):
Start Date: | 2020-06-01 00:00:00 |  |  |  |  |  | (CHECK ONE)
End Date:
Day | Date |  | ACTUAL | BILLABLE
Monday |  | 14
Tuesday |  | 15
Wednesday |  | 23
Thursday |  | 25
Friday
Saturday
Sunday
 | TOTAL HOURS
 |  |  |  |  |  |  | Site Supervisor/Designee Signature |  |  | DATE
 |  |  |  |  |  |  | CPV Program Adminstrator/Desginee Signature |  |  | DATE
Spreadsheet: 761462d1640920678-the-exact-same-formula-showing-different-values-homeloan-testing-1
Sheet: Amort

 | Todays Date |  |  | Current Loan Balance |  |  |  | LENDER NAME |  | Finance Company
 | only fill in yellow squares
 | calculate before extra payments
Loan amount |  |  | 237500 |  |  |  | Scheduled payment |  |  |  | 625.22
Interest rate |  |  | 0.0269 |  |  |  | Scheduled number of payments |  |  |  | 489
Loan term in years |  |  | 19 |  |  |  | Actual number of payments
months |  |  | 4 |  |  |  | Payments made to date
Payments made per year |  |  | 26 |  |  |  | Number of payments saved
Loan repayment start date |  |  | 2021-08-12 00:00:00 |  |  |  | Years saved off original loan term
Loan repayment end  date |  |  | 2040-11-20 00:00:00 |  |  |  | Total early payments
New Loan repayment End date |  |  |  |  |  |  | Total interest
Time saved
Optional extra payments |  |  | 25.78
Item NO | PAYMENT DATE | DETAILS | BEGINNING BALANCE | SCHEDULED PAYMENT | INTEREST CHARGED EOM | REGULAR EXTRA PAYMENT | ONE-OFF EXTRA PAYMENT | TOTAL PAYMENT | PRINCIPAL | INTEREST | ENDING BALANCE | Correcting Value | CUMULATIVE INTEREST |  |  | days | Month | interest per days | Auto Interest calculation | Manual interest calculation
0 | 2021-08-06 00:00:00 | Opening Balance
1
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: BASESAL

DISTRIBUTIVE SCHOOL ACCOUNT - BASE SALARY
 | FY10 | FY11 |  | FY12 |  | FY13
 | POS | POS | $ | POS | $ | POS | $
WEIGHTED ENROLLMENT
AVG STARTING TEACHER SALARY
INSTRUCTIONAL PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
FY 10 AVG SALARY
FY11 = FY10  @ 1% Roll-Up Plus 0% Cola
INSTRUCTIONAL PERSONNEL
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
INSTRUCTION SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON LICENSED
STUDENT RATIO
2%ROLL-UP
ADMINISTRATIVE SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
OTHER LICENSED & NON-LICENSED
STUDENT RATIO
2%ROLL-UP
TOTAL SALARIES
SUBSTITUTE SALARIES
EXTRA PAY, MISC SALARIES
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
TOTAL POSITIONS/SALARIES
AND FRINGE BENEFITS
BENEFIT/SALARY RATIO
Spreadsheet: 96984d1296209788-excel-2007-conditional-formatting-after-vlookup-value-conditional-vlookup
Sheet: Sheet1

CC_Sched_Arrival | Responsible MA | Loadlist
2011-01-10 00:00:00 | [NAME]
2011-01-13 00:00:00 | Daan
2011-01-14 00:00:00 | Emerson | 347929
2011-01-14 00:00:00 | Nicoleta
2011-01-17 00:00:00 | Daan
2011-01-18 00:00:00 | Emerson
2011-01-19 00:00:00 | Emerson | 347929
2011-01-24 00:00:00 | Emerson | 347622
2011-01-24 00:00:00 | Daan
2011-01-24 00:00:00 | Daan | 347929
2011-01-24 00:00:00 | Daan | 347929
2011-01-24 00:00:00 | Daan | 347929
2011-01-25 00:00:00 | Emerson | 347929
2011-01-25 00:00:00 | Daan
2011-01-25 00:00:00 | Emerson | 347622
2011-01-26 00:00:00 | Emerson | 347929
2011-01-26 00:00:00 | Emerson
2011-01-26 00:00:00 | Emerson | 347929
2011-01-26 00:00:00
2011-01-26 00:00:00 | Nicoleta
2011-01-26 00:00:00 | Emerson
2011-01-26 00:00:00 | Emerson
2011-01-26 00:00:00 | Daan
2011-01-26 00:00:00 | Daan | 347913
2011-01-26 00:00:00 | Daan | 347913
2011-01-26 00:00:00 | Daan
2011-01-27 00:00:00
2011-01-27 00:00:00 | Emerson | 347929
2011-01-27 00:00:00 | Daan | 347913
2011-01-27 00:00:00 | [NAME]
Spreadsheet: 3a2e6f34-445d-4223-bd87-ae4a33c8e0f2
Sheet: Page 1

Permit No.: |  |  | WQ0019632 |  |  | Facility Name: |  | Johnston County Reclaimed Water Facility |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | AG Center |  | Field Name: |  | Barrow Area C |  | Field Name: |  | Landfill Office |  | Field Name: |  | Livestock Area
 |  |  |  |  |  | Area (acres): |  | 3.65 |  | Area (acres): |  | 12.68 |  | Area (acres): |  | 0.25 |  | Area (acres): |  | 10.48
 |  |  |  |  |  | Cover Crop: |  | Grass |  | Cover Crop: |  |  |  | Cover Crop: |  | Grass |  | Cover Crop: |  | Grass/Trees
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 30 |  | Annual Rate (in): |  | 8 |  | Annual Rate (in): |  | 15 |  | Annual Rate (in): |  | 15
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset            (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1 |  |  |  |  |  | 1000000
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 114128d1309965496-extrapolating-spreadsheet-data-sample-invoice
Sheet: Invoice

 |  |  |  | INVOICE
 |  |  |  | Date |  | Invoice #
BILL TO
 | TERMS |  |  | PROJECT
 | Due Weekly |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Pivot Table
Work Order | Date | Name | Position | Code | Hour Type (click drop-down box for "Regular" or "OT 1-1/2") | Hours Worked | Billable Hourly Rate | Billable Amount |  | Code | Hours | Amount |  |  | Values
 |  | [NAME] | AA | 000001 | Regular | 40 | 15 |  |  | 000001 |  |  |  | Row Labels | Sum of Hours Worked | Sum of Billable Amount
 |  | [NAME] | AA | 000001 | OT 1-1/2 | 5 | 22.5 |  |  | 000003 |  |  |  | 000001 | 70 | 1162.5
 |  | [NAME] | PP | 000003 | Regular | 40 | 30 |  |  | 000004 |  |  |  | 000003 | 75 | 2320
 |  | [NAME] | JP | 000004 | Regular | 35 | 32 |  |  |  |  |  |  | 000004 | 35 | 1120
 |  | [NAME] | KP | 000003 | Regular | 35 | 32 |  |  |  |  |  |  | Grand Total | 180 | 4602.5
 |  |  |  | 000001 | Regular | 25 | 18
 |  |  |  | Total Hours |  |  | Total Amount
 |  |  |  |  | Regular
 |  |  |  |  | OT 1-1/2
Spreadsheet: mary_fischer__25630__1581 - 2001
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 478358d1472745278-populate-column-from-another-sheet-copy-of-sales
Sheet: Sales Analysis by Items (Annual

# | Item No. | Quantity | Sales Amt | Gross Profit | Gross Profit % | Supplier
1 | 110023 | 3 | 219.6 | 56.55 | 25.75 | SDAB001
2 | 116002 | 20 | 150 | 88 | 58.67 | SREM001
3 | 116003 | 32 | 240 | 142.4 | 59.33 | [NAME]
4 | 116010 | 25 | 187.5 | 111.75 | 59.6 | SABE001
Spreadsheet: 140889d1328926572-fancy-fat-loss-spreadsheet-2012-weigh-in-chart
Sheet: Database

Client Name | Date | Visit type | Weight | Amount Lost
[NAME], JR.,  [NAME] | 2012-01-01 00:00:00 | Initial Weigh In | 100 | 0
BARR, [NAME] | 2012-01-03 00:00:00 | Initial Weigh In | 125 | 0
[NAME], JR.,  [NAME] | 2012-01-12 00:00:00 | Weigh In | 98 | 2
BARR, [NAME] | 2012-01-15 00:00:00 | Weigh In | 121 | 4
Spreadsheet: 779509d1651828315-how-to-transform-data-array-from-vertical-to-horizontal-layout-5f-06
Sheet: Sheet1

Name | Data |  |  |  |  |  |  |  | Name | Date.Column1 | Date.Column2 | Date.Column3 | Date.Column4 | Date.Column5 | Date.Column6
A | 1 |  |  | A | 1 | 6 |  |  | A | 1 | 6 | 41.5 | 51
A | 6 |  |  | B | 2 | 4 | 5 |  | B | 2 | 4 | 5 | 60.5 | 70 | 79.5
B | 2 |  |  | C | 8 | 5 |  |  | C | 8 | 5 | 89 | 98.5
B | 4 |  |  | D | 11 | 33 |  |  | D | 11 | 33 | 108 | 127
B | 5 |  |  | F | 22 |  |  |  | F | 22 | 117.5
C | 8
C | 5
D | 11
F | 22
D | 33
A | 41.5
A | 51
B | 60.5
B | 70
B | 79.5
C | 89
C | 98.5
D | 108
F | 117.5
D | 127
Spreadsheet: 789398d1659084944-index-match-with-three-criteria-one-of-them-being-the-max-value-indexmatch3criteria
Sheet: Tabelle7

 | ID | FileID | TNA | No |  | ID | 23097
 | 23097 | [PHONE]-10-000046 | 266.9 | 2937 |  | File | [PHONE]-10-000046
 | 23097 | [PHONE]-10-000046 | 207.2 | 2938 |  | TNA | MAX
 | 23097 | [PHONE]-11-000022 | 152.6 | 3227 |  | No
 | 23097 | [PHONE]-12-008765 | 323.4 | 2939
 | 23097 | [PHONE]-12-008765 | 90.8 | 3228
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: MW

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 126e1ff5-54ed-4186-a213-f5a9349645c0
Sheet: T42

الجدول 42: مواليد الإناث الأحياء المسجلة، 2000-2010
Table 42: Registered female live births, 2000-2010
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | البلد
Bahrain | 6841 | 6538 | 6623 | 7256 | 7616 | 7431 | 7406 | 7877 | 8345 | ... | … | البحرين
Egypt | 847098 | 846358 | 861036 | 877320 | 877341 | 881835 | 902661 | 951160 | 995658 | 1069817 | 1101881 | مصر
Iraq | 216348 | 351319 | 365360 | 336049 | 410903 | 436175 | 442996 | 426411 | 478059 | ... | … | العراق
Jordan | 61371 | 69756 | 70931 | 72741 | 73770 | 74892 | 79873 | 90678 | 88792 | 92432 | 100388 | الأردن
Kuwait | 20511 | 20316 | 21356 | 21569 | 23039 | 25019 | 25836 | 26129 | 26658 | 27827 | ... | الكويت
Lebanon | 43026 | 41003 | 37540 | 35169 | 36203 | 36475 | 35798 | 39905 | 42024 | 44288 | 46854 | لبنان
Oman | ... | ... | ... | ... | ... | ... | 24086 | 25829 | 28313 | 31775 | 32223 | عمان
Palestine | 51403 | 51251 | 53047 | 53452 | 56144 | 56529 | 56214 | 57088 | 33535 | 32446 | 31511 | فلسطين
Qatar | 5512 | 5932 | 5939 | 6292 | 6388 | 6562 | 6924 | 7625 | 8507 | 8950 | 9578 | قطر
Saudi Arabia | 264349 | 268203 | 272112 | 276079 | 280103 | 284186 | 287426 | 290292 | 291769 | 293634 | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | … | السودان
Syrian Arab Republic | 210202 | 214260 | 242211 | 236171 | 241680 | 254251 | 267999 | 294088 | 334954 | 327529 | … | الجمهورية العربية السورية
United Arab Emirates | 26046 | 27518 | 28562 | 29924 | 30934 | 31478 | 30919 | 33219 | 33515 | 37211 | … | الإمارات العربية المتحدة
Yemen | 88627 | 95905 | 78635 | 57786 | 66474 | 65190 | 119224 | 111742 | 137345 | 120462 | … | اليمن
Total |  |  |  |  |  |  |  |  |  |  |  | المجموع
* data for the years 2008-2009 & 2010 include West Bank only and excludes Gaza Strip. |  |  |  |  |  |  |  |  |  |  |  | * بيانات السنوات 2008، 2009 و2010 تشمل الضفة  الغربية فقط ولا تشمل قطاع غزة.
Spreadsheet: 787936d1658165420-conditional-formatting-on-vlookup-results-sample-heatmap
Sheet: Calculation Sheet

[NAME] | AP Name | SSID | Site1 MACs |  |  | Other MACs
 | 1 Training Room | Site1 Guest | 06:16:f9:6f:52:66 |  |  | 16:49:bc:42:64:b8
 | G Warehouse (S) | Site1 Guest | 06:16:f9:6f:52:a2 |  |  | 98:da:c4:3f:21:f9
 | 1 Warehouse (L) | Site1 Guest | 06:16:f9:6f:53:4a |  |  | ac:e2:d3:c7:25:33
 | G Sales | Site1 Guest | 06:16:f9:6f:53:a9 |  |  | ea:9e:b4:23:b1:3e
 | G [NAME] | Site1_5GEXT | 3c:84:6a:72:d4:bf |  |  | fa:8f:ca:96:7e:c4
 | G [NAME] | Site1_2.4GEXT | 3c:84:6a:72:d4:c0 |  |  | 00:50:7f:7f:63:e8
 | 1 Training Room | Site1 | 84:16:f9:6f:52:66 |  |  | 06:0e:3c:83:f0:f3
 | G Warehouse (S) | Site1 | 84:16:f9:6f:52:a2 |  |  | 8c:85:80:a4:15:23
 | 1 Warehouse (L) | Site1 | 84:16:f9:6f:53:4a |  |  | 04:18:d6:0c:a0:08
 | G Sales | Site1 | 84:16:f9:6f:53:a9 |  |  | 00:f6:63:e1:f2:18
 |  |  |  |  |  | d4:4d:a4:4e:c1:1e
 |  |  |  |  |  | [NAME]:b1:e6:e9:30
 |  |  |  |  |  | 00:1d:aa:3f:27:d4
 |  |  |  |  |  | 00:1d:aa:57:b4:18
 |  |  |  |  |  | 02:1d:aa:57:b4:18
 |  |  |  |  |  | ae:e2:d3:fd:73:e6
 |  |  |  |  |  | 00:1d:aa:7f:28:80
 |  |  |  |  |  | ba:fb:e4:44:03:54
 |  |  |  |  |  | 00:f2:01:27:80:2e
Spreadsheet: 825528d1681379284-how-to-get-sum-of-rows-where-several-rows-are-empty-in-between-s666-pt-get-sum-of-rows-where-several-rows-are-empty-in-between
Sheet: Sheet2

Fields name | Time
Test1 | 00:00:03
Test1 |  |  |  | Fields name | Sum of Time
Test1 | 00:00:01 |  |  | Test1 | 00:00:04
Test1 |  |  |  | Test2 | 00:00:02
Test2 | 00:00:00 |  |  | Test3 | 00:00:04
Test2 |  |  |  | Test4 | 00:00:02
Test2 | 00:00:01 |  |  | Test5 | 00:00:00
Test2 |  |  |  | Test6 | 00:00:01
Test2 | 00:00:00 |  |  | [NAME] | 00:00:01
Test2 |  |  |  | Test8 | 00:00:02
Test2 | 00:00:01 |  |  | Test9 | 00:00:01
Test2 |  |  |  | Grand Total | 00:00:17
Test2 | 00:00:00
Test2
Test3
Test3
Test3 | 00:00:03
Test3
Test3 | 00:00:01
Test3
Test3 | 00:00:00
Test3
Test4 | 00:00:01
Test4
Test4 | 00:00:00
Test4
Test4 | 00:00:01
Test4
Test4
Test4
Test5
Test5
Test5 | 00:00:00
Test5
Test6 | 00:00:01
Test6
Test6 | 00:00:00
Test6
[NAME] | 00:00:01
[NAME]
[NAME] | 00:00:00
Test8
Test8 | 00:00:01
Test8
Test8 | 00:00:00
Test8
Test8 | 00:00:01
Test8
Test8
Test9
Test9
Test9 | 00:00:00
Test9
Test9 | 00:00:01
Spreadsheet: 788377d1658423500-inserting-row-above-table-changes-formulas-despite-structured-references-sampleproblem
Sheet: Summary

Column1 | Category A | Category B | Category C | Category D
Total
Spreadsheet: 683358d1592660925-problem-trying-to-combine-column-of-dates-and-time-book1
Sheet: Sheet1

Date | Time | What I want | What I get
2010-01-01 00:00:00 | 11 | 01/01/10 - 11:00
2010-01-01 00:00:00 | 11.15
2010-01-01 00:00:00 | 11.3
2010-01-01 00:00:00 | 11.35
2010-01-01 00:00:00 | 11.45
2013-07-24 00:00:00 | 14.1
2013-07-24 00:00:00 | 14.4
2013-07-24 00:00:00 | 15.4
2013-07-24 00:00:00 | 16.1
2013-07-24 00:00:00 | 16.4
2013-07-24 00:00:00 | 17.1
2013-07-24 00:00:00 | 17.35