tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33698__MgmtSum-Q2-0609
Sheet: YTD Mgmt Summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  | YTD 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses |  |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan* | [NAME] |  |  | Forecast | Plan | [NAME]
 |  |  |  |  |  |  |  | [NAME] | Cash Exp
Gas Trading
Texas Trading
Power Trading
Financial Drift
Financial Trading
Canada Trading
Coal-Trading
GRM -  Weather
Emissions
Total Trading & Risk Mgt. |  |  |  |  | 129970
East Midstream
West Midstream
Industrial Downstream
Generation Investments/IPP
Coal Origination & Finance
Canada Origination & Finance
ENA Upstream Assets
GRM - New Products
Mexico
Total Origination |  |  |  |  | 0
Principal Investing
Energy Capital Services
CTG Assets
Total Investing
Commercial Transactions Group
Office of the Chairman
Overview
Total Commercial
Group Total
Group Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
ENA EBIT
Interest Expense/(Income)
[NAME]
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 870592d1717078477-formula-to-lookup-a-company-name-but-ignore-certain-id-numbers-in-a-lookup-examplea-aligw
Sheet: Lookup

ID
30046
70757
70994
70702
100442
140001
130960
150313
150456
150013
650060
150688
140001
670042
140001
140001
160348
160347
160660
170167
160687
170192
170167
170484
120135
161102
171029
140001
170607
171051
170799
171299
170212
171423
171074
180443
171365
120135
171074
180788
181032
181560
181638
181308
180953
180806
171470
190629
190400
191342
191801
191710
200762
201147
201147
201368
201198
210062
200762
211325
221135
190349
230754
Spreadsheet: 128345d1320923796-creating-a-formula-that-will-automatically-update-or-change-colors-excel-forum
Sheet: Sheet1

JudicialFlag | Client | LoanNum | Last 2 digits | State | PendingStage |  | PendingStageDays | PendingStageDaysGross | PendingStageStateStd | AttorneyCode | Investor | PendingStageBucket | PendingStageBucketGross
 |  |  | 54 | New York | a. First Legal | update would be shown here | 14 | 14 | 19 |  |  | 2 - Under Standard (1 to 5 Days) | 2 - Under Standard (1 to 5 Days)
 |  |  | 54 | California | a. First Legal |  | 17 | 17 | 92 |  |  | 1 - Under Standard (5+ Days) | 1 - Under Standard (5+ Days)
 |  |  | 54 | Nevada | a. First Legal |  | 27 | 27 | 91 |  |  | 1 - Under Standard (5+ Days) | 1 - Under Standard (5+ Days)
 |  |  | 54 | New Hampshire | a. First Legal |  | 29 | 29 | 29 |  |  | 3 - At Standard | 3 - At Standard
 |  |  | 54 | Wisconsin | a. First Legal |  | 9 | 9 | 10 |  |  | 2 - Under Standard (1 to 5 Days) | 2 - Under Standard (1 to 5 Days)
Spreadsheet: 164178d1340676211-trouble-in-separating-data-sample-data
Sheet: Sheet2

name | first pickup | second pickup | third pickup
alice | 2012-01-03 00:00:00 | 2012-01-05 00:00:00 | 2012-01-11 00:00:00
barney | 2012-01-03 00:00:00 | 2012-01-07 00:00:00 | 2012-01-11 00:00:00
[NAME] | no pickup | no pickup | no pickup
dean | 2012-01-11 00:00:00 | no pickup | no pickup
eugene | 2012-01-07 00:00:00 | 2012-01-11 00:00:00 | no pickup
[NAME] | no pickup | no pickup | no pickup
george | no pickup | no pickup | no pickup
hector | 2012-01-04 00:00:00 | no pickup | no pickup
ian | 2012-01-09 00:00:00 | no pickup | no pickup
[NAME] | 2012-01-06 00:00:00 | no pickup | no pickup
Spreadsheet: monique_sanchez__28311__Master0522
Sheet: EXPANSIONS

PIPELINE | DATE | VOLUME | RECEIPT | DELIVERY
Kern | 2001-07-01 00:00:00 | 135000 | Rockies | California
Kern | 2003-05-01 00:00:00 | 900000 | Rockies | California
EPNG - All American | 2001-10-01 00:00:00 | 230000 | Perm | Ehrenburg
Southern Trails | 2002-05-01 00:00:00 | 80000 | South TransColorado | Into SoCal | Maybe as late as July
Wilcox | 2001-08-01 00:00:00 | 130000 | South Mainline | To Mexico
[NAME] | 2002-09-01 00:00:00 | 500000 | [NAME] | To Mexico
[NAME] I |  | 750000 | SJ | Needles | Summer 2003
[NAME] |  | 1250000 | Needles | San Fran
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 129260 | 129182
2 | 126748 | 122113
3 | 123158 | 122442
4 | 107561 | 106472
5 | 111357 | 111062
6 | 113863 | 113152
7 | 89887 | 128168
8 | 120044 | 119268
9 | 117369 | 115843
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -36642
2001-08-08 00:00:00
Spreadsheet: 208944d1358967923-sorting-filter-column-pt-sort-filter
Sheet: Sheet1

Fruits
Apple
Apple |  | Row Labels | Count of Fruits
Orange |  | Apple | 3
Peach |  | Orange | 2
Apple |  | Peach | 2
Orange |  | Pear | 1
Peach |  | Grand Total | 8
Pear
Spreadsheet: 53d2d44c-7f96-4d3f-9f72-b28298ba8e56
Sheet: Sheet1

LAKE LOGAN BEACH AND BOAT RENTAL OVERVIEW | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Category
of Revenue | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
BOAT RENTAL | 40798 | 38076.92 | 55113 | 56039 | 47901 | 63923 | 58414 | 60910 | 60234 | 54347 | 56913
BAIT AND TACKLE | 7903.409999999999 | 16042.96 | 5291.78 | 5639.62 | 3076.99 | 2208.22 | 1817.9 | 2165.65 | 1452.35 | 1189.5 | 921.98
FOOD AND BEVERAGE | 7836.54 | 5575.16 | 4742.5 | 5745.89 | 3136.52 | 1861.31 | 1260.25 | 1176.05 | 1116 | 827.25 | 609.5
SUNDRIES | 0 | 4.99 | 24.84 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VENDING MACHINES | 469.25 | 432.94 | 356.45 | 490 | 621 | 1001 | 475 | 0 | 0 | 0 | 0
ALL OTHER RECEIPTS | 1390.35 | 66.69 | 35.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BEACH-VENDED FOOD/ BEV. | 1000 | 13 | 1784.67 | 1994.25 | 3833.67 | 3586 | 4090 | 3592.5 | 2063.5 | 0 | 0
BEACH-ALL OTHER RECEIPTS | 0 | 1684 | 441.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total | 59397.55 | 61896.66 | 67790.73999999999 | 69908.76000000001 | 58569.17999999999 | 72579.53 | 66057.15 | 67844.20000000001 | 64865.85 | 56363.75 | 58444.48
Commissions Paid | 7424.750000000001 | 7737.13 | 8473.890000000001 | 6534.9 | 5460.190000000001 | 6926.54 | 6294.640000000001 | 6504.54 | 6306.37 | 5575.87 | 5798.52
Spreadsheet: 217506d1362084670-consolidate-by-two-factors-new-problem
Sheet: Feb2013

 |  |  |  |  |  |  |  |  |  |  |  | 0.27
Customer | Name | Product | Description | Qty | m2 | Value | Av Price | Matl Cost | Yield AdJ | Purch Cost | Tot Matl Cost | ES Cost
248 | Customer E | 500066 | Insulight(TM) | 2 | 0.67 | 43.55 | 65 | 12.91 | 16.98684210526316 | 0 | 16.98684210526316 | 1.809
248 | Customer E | 530165 | Insulight(TM) Therm | 1134 | 391.26 | 25337.42 | 64.76 | 8140.38 | 10711.02631578947 | 0 | 10711.02631578947 | 1056.402
248 | Customer E | 99999999 | Energy Surcharge | 0 | 0 | 4.06 | 0 | 0 | 0 | 0 | 0 | 0
1217 | Customer F | 540351 | Cervoglass(TM) [NAME] | 1 | 1.36 | 46.35 | 34.08 | 16.07 | 21.14473684210526 | 0 | 21.14473684210526 | 3.672000000000001
1217 | Customer F | 99999999 | Energy Surcharge | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 66661d1267310248-collating-grouping-data-from-different-sheets-hours-example
Sheet: What I Have

Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday
Name | Hours |  | Name | Hours |  | Name | Hours |  | Name | Hours |  | Name | Hours |  | Name | Hours |  | Name | Hours
[NAME] | 4 |  | [NAME] | 6 |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 6 |  | [NAME] | 8 |  | Maria | 8
Fred | 4 |  | [NAME] | 6 |  | [NAME] | 8 |  | [NAME] | 8 |  | Emma | 6 |  | [NAME] | 8 |  | [NAME] | 8
[NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 8 |  | Fred | 8
[NAME] | 8 |  | Fred | 8 |  | Fred | 6 |  | Emma | 8 |  | Fred | 8 |  | Mark | 4 |  | [NAME] | 6
 |  |  | Mark | 4 |  | Mark | 4 |  | Mark | 4 |  | Mark | 4 |  | [NAME] | 8 |  | [NAME] | 8
 |  |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 8
Spreadsheet: 885300d1734786034-need-formula-to-exclude-records-that-a-match-is-found-singles-and-mismates-9-
Sheet: Form Responses 1

Timestamp | EMP NAME | EMP Number | Enter Style Code (ie. "FD9082-103") | Colour | Size | Price | Left or Right | Box | Store | Matching Field | Match Look Up Value | Match | [NAME] | Matched
2024-12-19 22:18:15.041000 | Test user | 1000 | FD9082-103 | Black | 8 | 130 | Left | Yes | 3012
2024-12-19 22:18:45.135000 | Test user | 1000 | FD9082-103 | Black | 8 | 130 | Right | No | 3110
2024-12-20 22:18:45 | Test user | 1000 | FD9082-103 | Black | 8 | 130 | Right | Yes | 3110
Spreadsheet: 772376d1647250164-remove-words-by-substring-list-removelistmatchstrings
Sheet: Sheet1

String: | Expect:
This is a beautiful text in string. | This is a text in string.
How beautifier works? | How works?
I love beautification! | I love !
AUTIX its a brand | its a brand
I use dictionary today | I use today
Bastion is real attraction | is real
Functions with fraction in formulas | with  in formulas
Director say: Action! | Director say: !
Auction sell all creations | sell all
This is an exemple | This is an
Amplitude and latitude | and latitude
Very good employer | Very good
I use [NAME] for video | I use for video
What does dumple mean | What does mean
Too ample in this dirrection | Too in this
Yor diction is simple | Yor is
Simple-Dimple is autistic song | -is song
Simple nautical erection
Amplection create conflictions | create
Autiction school | school
Spreadsheet: 68682d1269278321-lookup-formula-e0
Sheet: Sheet1

 |  |  |  |  |  | Goals scored by home team in last 6 games | Goals scored against home team in last 6 games | Goals scored by away team in last 6 games | Goals scored against away team in last 6 games |  | nth fixture (H) | nth fixture (A) | key
Spreadsheet: 85792d1285834123-sum-quarters-into-year-dummy-20data-1-
Sheet: Sheet1

2010_3 | 20000000 |  |  |  |  | 2010 | 100000000
2010_4 | 80000000 |  |  |  |  | 2011 | 748215699.000001
2011_1 | 113571646 |  |  |  |  | 2012 | 936025483.333336
2011_2 | 164762194.666667 |  |  |  |  | 2013 | 227723866
2011_3 | 211548017.666667
2011_4 | 258333840.666667
2012_1 | 305119663.666668
2012_2 | 351905486.666668
2012_3 | 279000333
2013_3 | 80000000
2013_4 | 80000000
2014_2 | 38018567
2014_4 | 20000000
2015_3 | 9705299
Spreadsheet: phillip_allen__29912__FINAL
Sheet: Total Cash Flow

 |  |  |  |  |  |  |  | 35599 | 38385 | Total
Partnership Agreements |  | -2500 |  |  |  |  |  | 1999 | 1999
Earnest Money |  | -6500 |  |  |  | Beg. Bal |  | 5000 | 200
Cash at Closing |  | -225000 |  |  |  | End. Bal |  | 11775 | 35160
Loan from [NAME] |  | 25000 |  |  |  | Change
Initial Working Cap. |  | -5000
1999 Cash (Net)
2000 Oper/Rem/Gas/Finc
2000 Personal
[NAME]) |  | -15000
2001 Oper/Rem/Gas/Finc
2001 Personal |  | -6436
Repay [NAME] (2001) |  | -10000
Sub total
Add: Personal
Proceeds @ closing |  | 52770
Add. Investment |  | -36000
Total Cash Flow
2nd Liens
Profit/(Loss)
Spreadsheet: 836416d1689335941-populate-location-when-name-matches-book2
Sheet: Sheet1

 |  |  |  |  | Populate Location from D when Employee name matches in columns B and F
 | Employee | Function | Location |  | Employee | Location
 | [NAME] | Sales | QC |  | [NAME]
 | Dwayne | Sr Sales | QC |  | Dwayne
 | [NAME] | Custodian | MB |  | [NAME]
 | [NAME] | Finance | SK |  | [NAME]
 | [NAME] | Director | SK |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
Spreadsheet: 846229d1697506204-conditional-formatting-not-consistent-with-min-max-functions-price-comparison-1-
Sheet: Sheet1

 | Size in Ounces/Grams |  |  |  | Price per  can/package |  |  |  | Price per Ounce/Gram
Product | Store 1 | Store 2 | Store 3 | Store 4 | Store 1 | Store 2 | Store 3 | Store 4 | Store 1 | Store 2 | Store 3 | Store 4
Tomatoes - Whole | 28 | 28 | 14.5 | 28 | 1.54 | 2.04 | 0.81 | 3.1
Black Beans | 27 | 15.5 | 16 | 15.5 | 1.64 | 1.64 | 1.85 | 1.48
[NAME] | 16 | 17.6 | 16 | 16 | 1.44 | 1.97 | 1.71 | 1.23
Tuna | 5 | 5 | 5 | 5 | 2.06 | 2.58 | 2.58 | 1.02
Chicken | 12.5 | 4.5 | 10 | 5 | 4.14 | 2.26 | 2.89 | 1.96
Sardines | 3.75 | 3.75 | 3.75 | 3.75 | 1.02 | 1.02 | 1.33 | 1.33
Salmon | 14.75 | 2.6 | 14.75 | 5 | 4.36 | 2.37 | 10.38 | 2.23
Spam | 12 | 12 | 7 | 2.5 | 3.1 | 2.89 | 2.58 | 1.58
Chili | 15 | 15 | 7.5 | 15 | 2.37 | 2.16 | 1.96 | 2.03
Soup - Tomato | 10.5 | 31.4 | 26 | 15.5 | 1.23 | 8.3 | 3 | 6.22
Soup - Clam Chowder | 18.8 | 16 | 15 | 18.8 | 2.35 | 5.5 | 3.4 | 2.35
[NAME] | 7 | 4 | 4 | 4 | 1.75 | 2.68 | 1.41 | 2.27
Pears - canned | 16 | 15.25 | 15 | 15.25 | 1.54 | 2.54 | 2.06 | 2.54
Peaches - canned | 8 | 8.25 | 15 | 15 | 1.23 | 1.23 | 2.54 | 2.54
Pumpkin | 15 | 15 | 15 | 29 | 2.6 | 3.1 | 2.72 | 4.41
Coconut Milk | 64 | 13.5 | 13.66 | 64 | 3.52 | 2.58 | 3.62 | 4.45
Bread flour | 80 | 80 | 80 | 9 | 6.22 | 3.83 | 5.08 | 7.88
All Purpose [NAME] | 48 | 80 | 16 | 32 | 10.38 | 6.22 | 7.26 | 3.1
Butter | 16 | 16 | 16 | 45 | 4.97 | 4.97 | 6.22 | 4.87
Milk | 128 | 64 | 128 | 64 | 3.7 | 4.14 | 6.22 | 2.04
Orange Juice | 52 | 89 | 59 | 128 | 3.93 | 6.53 | 4.14 | 6.22
Bananas | 1 | 1 | 0.75 | 1.5 | 0.44 | 0.74 | 1.02 | 3.41
[NAME] | 80 | 80 | 32 | 32 | 8.2 | 3.47 | 3.41 | 4.08
Spreadsheet: 45522d1244241342-random-sampling-without-replacement-686443-sampling
Sheet: Sheet1

 | Total Samples | 6 | << Input
 | Sample | 3 | 2 | 1
 | Population | 5 | 4 | 2
Class | Other | A | B | C
A | 12 | 1 | 0 | 0
A | 13 | 0 | 0 | 0
A | 42 | 0 | 0 | 0
B | 23 | 0 | 1 | 0
A | 22 | 1 | 0 | 0
B | 1 | 0 | 0 | 0
B | 24 | 0 | 1 | 0
C | 5 | 0 | 0 | 1
C | 3 | 0 | 0 | 0
A | 23 | 1 | 0 | 0
B | 15 | 0 | 0 | 0
 |  |  |  |  | << Add rows and copy formulas down as needed
Spreadsheet: 96749d1296056664-worksheet-lookup-match-and-other-operations-codes
Sheet: Sheet1

AAB2
ACA1
ACE3
ADC4
ADC5
ADC6
[NAME]
ADC8
ADP2
ADP3
[NAME]
ADP5
ADP6
ADS4
ADS5
AEX3
AFS1
AFT1
AGS1
AGS2
ALJ1
ALP6
ALP7
ALP8
ALP9
ALS1
JAB1
MAD1
MAD2
MAD3
MAD4
MAD5
YUT1
Spreadsheet: 809705ad-3b5e-41db-95b4-2f8ad54d978c
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ausländer und Ausländerinnen, welche länger als 2 Jahre in der [NAME] bleiben möchten, werden verpflichtet, die Sprache des jeweiligen Landesteils zu lernen.
 | Ich bin mit der Politik in der [NAME] zufrieden.
Antwort | [NAME] | [NAME] eher zu | Neutral / Weiss nicht | [NAME] eher nicht zu | [NAME] nicht zu
[NAME] | 0.87 | 0.89 | 0.88 | 0.9 | 0.9
Neutral / Weiss nicht | 0.06 | 0.07 | 0.09 | 0.05 | 0.04
[NAME] | 0.06 | 0.05 | 0.03 | 0.05 | 0.06
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: March

Name | Site |  |  | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-04 00:00:00 | 2021-03-05 00:00:00 | 2021-03-06 00:00:00 | 2021-03-07 00:00:00 | 2021-03-08 00:00:00 | 2021-03-09 00:00:00 | 2021-03-10 00:00:00 | 2021-03-11 00:00:00 | 2021-03-12 00:00:00 | 2021-03-13 00:00:00 | 2021-03-14 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-18 00:00:00 | 2021-03-19 00:00:00 | 2021-03-20 00:00:00 | 2021-03-21 00:00:00 | 2021-03-22 00:00:00 | 2021-03-23 00:00:00 | 2021-03-24 00:00:00 | 2021-03-25 00:00:00 | 2021-03-26 00:00:00 | 2021-03-27 00:00:00 | 2021-03-28 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: 885929d1735851202-sorting-by-more-than-1-criteria-for-excel-help
Sheet: Summary

A & B
Service Line | <~What should this be?
2024-12-31 00:00:00
 |  |  |  |  | Sorted By Provider |  | Sorted by Supervisor
 |  |  |  |  | Number of | Number of
 |  |  |  |  | Transactions | Transactions |  |  |  |  | To [NAME] | To Totals in Col N & O
 |  |  |  |  | W/O Provider | W/O Supervisor |  |  |  | check
 |  |  |  | Dollars | Signature | Signature | Errors |  |  |  |  |  | Total open items | Toital open items
Company | Organization | Provider | [NAME] | not billed | >24 Hours | > 24 hours | Time Issue | No Authorization | No insurances | Location issues | No Diagnosis | Other/Multiple Errors | < or = 14 days | > 14 days | Total Errors
A | ACT 1 | [NAME]
A | ACT 1 | [NAME]
A | ACT 5 | [NAME]
A | ACT Dover | [NAME]
B | New Hope | [NAME]
B | Newark Clinic | [NAME]
A | Promise Peers | [NAME]
B | WRP | [NAME]
Spreadsheet: 676617d1588890970-only-looking-up-a-value-based-on-criteria-test-file
Sheet: Sheet1

 | Circuit | Outage Time Start (seconds) | Was there an outage on the Same Circuit in less than or equal to 2 seconds later | If there was an outage on the same circuit in less than or equal to 2 seconds later, when did that outage start?
 | A | 10 |  | 12
 | B | 11 |  | NA
 | A | 12 |  | NA
 | C | 15 |  | NA
 | D | 16 |  | NA
 | A | 18 |  | NA
 | E | 20 |  | 21
 | B | 20 |  | NA
 | E | 21 |  | NA
 | F | 22 |  | NA
 | A | 23 |  | NA
Spreadsheet: 806165d1669139564-if-formula-impacted-by-previously-entered-data-data-sample
Sheet: PIVOT

 |  | 2022-08-01 00:00:00 |  | 2022-07-01 00:00:00 |  | 2022-11-01 00:00:00 |  | 2022-10-01 00:00:00 |  | 2022-09-01 00:00:00
 |  | Column Labels
 |  | AUG 2022 |  | JUL 2022 |  | NOV 2022 |  | OCT 2022 |  | SEP 2022 |  | Total Sum of Charged | Total Sum of Net RPH (T&M/Charged Hours)
 | Row Labels | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours)
 | [PHONE] | 216 | 222.8338888888889 | 193 | 167.9089119170984 | 20 | 799.26 | 26.2 | 793.3843511450381 | 47 | -447.995744680851 | 502.2 | 191.665890083632
 | [PHONE] | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] | 118 | 214.6749152542373 | 132 | 256.9621212121212 | 0 | 0 | 24 | 166.1066666666667 | 177.5 | 186.3259718309859 | 451.5 | 213.3113178294574
 | [PHONE] | 27 | 583.2692592592592 | 369 | 335.9434959349593 | 24 | 507.0625 | 59 | 540.6452542372881 | 35 | 507.0628571428572 | 514 | 392.074299610895
 | [PHONE] | 8 | 301.1525000000001 | 272 | 343.7510661764705 |  | 0 |  | 0 | 0 | 0 | 280 | 342.5339642857143
 | [PHONE] | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 | [PHONE] |  | 0 | 180.5 | 663.2099168975069 |  | 0 |  | 0 |  | 0 | 180.5 | 663.2099168975069
 | [PHONE] |  | 0 | 24 | 467.1866666666667 |  | 0 |  | 0 |  | 0 | 24 | 467.1866666666667
 | [PHONE] |  | 0 | 101 | 135.09 |  | 0 |  | 0 |  | 0 | 101 | 135.09
 | [PHONE] | 954 | 202.9666142557652 |  | 0 | 0 | 0 | 0 | 0 | 829.5 | 175.2840867992767 | 1783.5 | 190.091561536305
 | [PHONE] |  | 0 |  | 0 | 373 | 396.0413941018767 | 326 | 363.7370858895706 | 709 | 362.6458392101551 | 1408 | 371.7454758522727
 | [PHONE] |  | 0 |  | 0 | 56 | 22.45982142857143 |  | 0 |  | 0 | 56 | 22.45982142857143
 | [PHONE] |  | 0 |  | 0 | 20 | 606.337 |  | 0 |  | 0 | 20 | 606.337
 | Grand Total | 1323 | 215.6095767195767 | 1271.5 | 336.8893590247739 | 493 | 345.2851724137931 | 435.2 | 402.6874770220588 | 1798 | 201.5542491657397 | 5320.7 | 267.1595861446802
Spreadsheet: 114776d1310489797-userform-example-for-mcnig
Sheet: Data

Forename | Surname | DOB | House Number | Postcode | Telephone | [NAME] | ***
[NAME] | Smith | 1980-01-01 00:00:00 | 1234 | 98765 | [PHONE] | [EMAIL] | ***
[NAME] | Doe | 1990-12-12 00:00:00 | 9876 | 12345 | [PHONE] | [EMAIL] | ***
Person | Somebody | 1985-06-06 00:00:00 | 4567 | 34567 | [PHONE] | [EMAIL] | ***
Spreadsheet: 836486d1689403807-query-across-multiple-columns-and-multiple-criteria-with-flexible-content-ice-monthly-plan
Sheet: Codes

Period | 3 |  | 0.1
Person ID | Person Name | Rough monthly [NAME] | Raise/expenses | Period Cost
A | Fred | 2000
B | [NAME] | 4000
C | [NAME] | 6000
D | [NAME] | 10000
Projects
Project A
Project B
Project C
Project D
Project E
Project F
Project G
ProjectH
Project I
Project J
Project K
Spreadsheet: b30d4e46-12bd-4609-858d-1e39fa2429fb
Sheet: In-force - Gross

Universal American Corp.
Annualized Premium In Force - Gross
Continuing Operations
As of December 31, 2011
($ in millions, Policies in thousands)
 |  |  | Current Quarter |  |  |  | Prior Quarter End |  |  |  |  |  |  |  | Prior Year Quarter
 |  |  | 2011-12-31 00:00:00 |  |  |  | 2011-09-30 00:00:00 |  |  |  | Change vs Sep-11 |  |  |  | 2010-12-31 00:00:00 |  |  |  | Change vs Dec-10
 |  |  | $ |  | Policies |  | $ |  | Policies |  | $ |  | Policies |  | $ |  | Policies |  | $ |  | Policies
Medicare Advantage |  |  | 1801.50985224 |  | 160.45 |  | 1881.1381548 |  | 164.02 |  | -79.62830256000007 |  | -3.570000000000022 |  | 3039.25476192 |  | 285.728 |  | -1237.74490968 |  | -125.278
Traditional Insurance |  |  | 377.4038733599997 |  | 361.16 |  | 385.709071 |  | 368.849 |  | -8.305197640000245 |  | -7.688999999999965 |  | 415.147655 |  | 396.511 |  | -37.74378164000029 |  | -35.35099999999994
 | Total
Spreadsheet: 06e794fa-d908-4102-b33d-25263a093365
Sheet: Sheet1

BWF World Senior Championships 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
MS 35
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | BWF ID | St. | Cnty | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
1 | 8832 |  | FRA | Fabrice Bernabe [1] |  |  | ( TOP HALF )
2 |  |  |  | Bye 1
3 | 69689 |  | TUR | [NAME]
4 |  |  |  | Bye 17
5 | 64231 |  | SWE | [NAME]
6 |  |  |  | Bye 9
7 | 10111 |  | SUI | [NAME]
8 | 71798 |  | JPN | [NAME]
9 | 8912 |  | SRI | [NAME] [5/8]
10 |  |  |  | Bye 5
11 | 95765 |  | IND | [NAME]
12 | 57286 |  | RUS | Sergey Makin
13 | 99664 |  | GER | [NAME]
14 |  |  |  | Bye 13
15 | 69106 |  | DEN | [NAME]
16 | 92809 |  | ENG | [NAME]
17 | 41371 |  | DEN | [NAME] Eilby [3/4]
18 |  |  |  | Bye 3
19 | 73393 |  | GER | Jan-Lennard Hay
20 |  |  |  | Bye 19
21 | 55320 |  | BEL | Joost Van Den Brande
22 |  |  |  | Bye 11
23 | 51419 |  | FRA | [NAME]
24 | 81576 |  | TUR | [NAME]
25 | 7413 |  | SUI | [NAME] [5/8]
26 |  |  |  | Bye 7
27 | 86123 |  | RUS | Konstantin Myakishev
28 | 74635 |  | BUL | [NAME]
29 | 50490 |  | IND | [NAME]
30 |  |  |  | Bye 15
31 | 92131 |  | UKR | [NAME]
32 | 67973 |  | SWE | [NAME]
BWF World Senior Championships 2013
MS 35
Badminton Tournament Planner - bwf.tournamentsoftware.com
 | BWF ID | St. | Cnty | Round 1 | Round 2 | Round 3 | Quarterfinals | Semifinals | Final | Winner
33 | 73872 |  | CAN | [NAME] |  |  | ( BOTTOM HALF )
34 | 77751 |  | ENG | Philip Troke
35 |  |  |  | Bye 16
36 | 7094 |  | RUS | Vadim Itckov
37 | 5209 |  | SUI | [NAME]
38 | 7441 |  | BUL | [NAME]
39 |  |  |  | Bye 8
40 | 85522 |  | IND | Cm Shashidhar [5/8]
41 | 50087 |  | FRA | [NAME]
42 | 10782 |  | DEN | [NAME]
43 |  |  |  | Bye 12
44 | 11059 |  | TUR | [NAME]
45 |  |  |  | Bye 20
46 | 73551 |  | GER | Marcus Barsch
47 |  |  |  | Bye 4
48 | 83793 |  | SWE | [NAME] [3/4]
49 | 92996 |  | IND | Jayendra Dhole
50 | 93334 |  | SWE | [NAME]
51 |  |  |  | Bye 14
52 | 9729 |  | THA | [NAME]
53 | 86606 |  | ENG | Darren Saunders
54 | 51002 |  | FRA | [NAME]
55 |  |  |  | Bye 6
56 | 13468 |  | GER | [NAME] [5/8]
57 | 70384 |  | TUR | Mehmet [NAME]
58 | 80677 |  | RUS | [NAME]
59 |  |  |  | Bye 10
60 | 89968 |  | JPN | [NAME]
61 |  |  |  | Bye 18
62 | 71095 |  | SUI | [NAME]
63 |  |  |  | Bye 2
64 | 53695 |  | DEN | [NAME] [2]