tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37384d1235387399-display-change-between-dates-in-pivot-rykobyk
Sheet: Sheet2

DATE | PRODUCT | VALUE
1 | A | 10 |  |  |  |  |  |  |  | This is how I would like to see my data...
1 | B | 20 |  |  |  | Sum of VALUE | DATE |  |  | Purchased
1 | C | 50 |  |  |  | PRODUCT | 1 | 2 |  | A | 50
1 | D | 80 |  |  |  | A |  | 50 |  | B | 30
1 | E | 90 |  |  |  | B |  | 30 |  | E | 10
1 | F | 60 |  |  |  | C |  | -10 |  | H | 20
1 | G | 30 |  |  |  | D |  | -20 |  | I | 10
1 | H | 20 |  |  |  | E |  | 10
1 | I | 40 |  |  |  | F |  | -10
2 | A | 60 |  |  |  | G |  | -10 |  | Sold
2 | B | 50 |  |  |  | H |  | 20 |  | C | -10
2 | C | 40 |  |  |  | I |  | 10 |  | D | -20
2 | D | 60 |  |  |  | Grand Total |  | 70 |  | F | -10
2 | E | 100 |  |  |  |  |  |  |  | G | -10
2 | F | 50
2 | G | 20
2 | H | 40
2 | I | 50
Spreadsheet: 878817d1726090646-i-need-to-update-a-list-from-one-sheet-to-another-while-keeping-data-in-main-sheet-list_update-
Sheet: Pull data from

Name | Gender | Age
[NAME] 1 | F | 18
[NAME] 2 | F | 18
[NAME] 3 | F | 33
[NAME] 4 | F | 47
[NAME] 5 | F | 63
[NAME] | M | 18
[NAME] | M | 21
[NAME] | M | 25
[NAME] | M | 50
[NAME] | M | 45
[NAME] 6 | M | 70
[NAME] | M | 55
[NAME] | M | 19
[NAME] 9 | M | 18
[NAME] 10 | M | 21
[NAME] 6 | F | 18
[NAME] 7 | F | 18
[NAME] 8 | F | 33
[NAME] 9 | F | 47
[NAME] 10 | F | 63
Spreadsheet: 455524d1460384924-duplicates-search-column-a-with-differnce-coloumn-b-oeldere2-455516d1460382891-duplicates-search-column-a-with-differnce-coloumn-b-example-1
Sheet: Sheet1

Food | Mixed or Single | result | Kolom1 | [NAME] |  | helpcolumn
apples | M |  |  |  |  | N |  |  |  |  |  | Aantal [NAME] or Single | Kolomlabels |  |  |  | helpcolumn
apples | M |  |  |  |  | N |  |  |  |  |  | Rijlabels | M | S | Eindtotaal
apples | M |  |  |  |  | N |  |  |  |  |  | apples | 3 |  | 3
pears | M |  |  |  |  | Y |  |  |  |  |  | bread | 1 |  | 1
pears | M |  |  |  |  | Y |  |  |  |  |  | eggs | 2 | 1 | 3
pears | S |  |  |  |  | Y |  |  |  |  |  | fish | 2 |  | 2
pears | M |  |  |  |  | Y |  |  |  |  |  | grapes |  | 1 | 1
pears | M |  |  |  |  | Y |  |  |  |  |  | oranges | 2 | 2 | 4
grapes | S |  |  |  |  | N |  |  |  |  |  | pears | 4 | 1 | 5
plums | M |  |  |  |  | N |  |  |  |  |  | plums | 4 |  | 4
plums | M |  |  |  |  | N |  |  |  |  |  | Eindtotaal | 18 | 5 | 23
plums | M |  |  |  |  | N
plums | M |  |  |  |  | N
eggs | S |  |  |  |  | Y
eggs | M |  |  |  |  | Y
eggs | M |  |  |  |  | Y
bread | M |  |  |  |  | N
oranges | M |  |  |  |  | Y
oranges | M |  |  |  |  | Y
oranges | S |  |  |  |  | Y
oranges | S |  |  |  |  | Y
fish | M |  |  |  |  | N
fish | M |  |  |  |  | N
Spreadsheet: mary_fischer__25619__77L
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077L |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME   PBM Mechanical Inc.
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | Completed
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | Completed
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | Completed
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | Completed
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | Completed
E-21 |  | Lease Expense & Future Lease Commitments | Completed
E-31 | VARIOUS ACCOUNTS | Equity/Invmt Sub | Completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 72590d1273265334-connecting-data-table-to-spreadsheet-via-formula-sample
Sheet: Sheet1

 |  | Car Park Life-care Plan
Element | Work carried out by | Commisioned by and reporting to | Interval | Proposed Date of Next Inspection/Repair | PCC Engineer Recommendation for Due Inspection | Status | Completed
Inspections
Daily Surveillance | On-site staff | Car park manager | Daily
Routine Inspection | Inspector/assistant | Car park manager | Less than 6 months | 2004-10-01 00:00:00
Initial Appraisal and Condition Survey | Engineer/Inspector | Owner or Operator | Less than 8 years | 2009-04-01 00:00:00
Structural appraisal | Engineer | Owner or Operator | Less than 16 years | 2015-04-01 00:00:00
Special Inspection | Engineer | Owner or Operator | As required | Not required yet
Maintenance and repair
Routine | On-Site staff | Car park manager | Monthly | As required
Cosmetic/Protective | Contractor | Owner | As advised by Engineer | 2009-07-01 00:00:00
Preventive/Structural | Contractor | Owner | As advised by Engineer | As required
Rehabilitation and Replacement | Contractor | Owner | As advised by Engineer | As required
Spreadsheet: 127720d1320504332-how-to-copy-information-from-one-worksheet-to-other-dynamically-sharful-tel_index
Sheet: Sheet1

Sl. No.: | Name | Mobile No.: | E-Mail
1 | Adam | 1752655 | [EMAIL]
2 | Anne | 158223 | [EMAIL]
3 | Korim | 25755226 | [EMAIL]
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 868066d1714762450-count-number-of-groups-who-started-doing-a-job-mappe1-kopie
Sheet: Tabelle1

If at least one entry in column C (for rows belonging to the SAME group=criteria column "A") has "yes" in Column C, =>  then count it once in F21
 |  |  |  |  | "yes" can be replaced with "1"
Group | Members | [NAME]
Group5 | Jan | yes
Group2 | [NAME] | yes
Group3 | Volker | 0
Group2 | Maria | 0
a new entry must be possible | xx
Group1 | [NAME] | 0
Group2 | [NAME] | yes
Group3 | [NAME] | 0
Group4 | Katha | yes
Group3 | [NAME] | 0
Group4 | Holger | 0
Group1 | Anto | yes
Group4 | Bernd | 0
Group3 | [NAME] | 0
a new entry must be possible | xx
Group5 | Anna | yes
Group5 | Caroline | 0
Result |  | 4 (expected)
 |  | C23 = how many groups have sent specification AT LEAST once?)
 |  | C23 should pls just give a number of groups, not groups' name(s)
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.22

Table 1.22: Child mortality rates by country, nationality, residence, sex and year
Country | Year | Male | Female | Urban | Rural | Nationals | Non nationals | Total
Bahrain
 | 2005 | ... | ... | ... | ... | ... | ... | 10.9
 | 2008 | ... | ... | ... | ... | ... | ... | 8.6
 | 2009 | 9.3 | 8 |  |  |  |  | 8.6
Egypt
 | 1995 | 38.3 | 36.9 | 35.4 | 39 | 37.6 | ... | 37.6
 | 2008 | 38.4 | 28 | 28.7 | 36.2 |  |  | 33.4
 | 2009 | 17.6 | 16.2 |  |  |  |  | 16.9
 | 2011 | 20.4 | 17.8 |  |  |  |  | 19.01
Iraq
 | 1999 | ... | ... | ... | ... | ... | ... | 122
 | 2006 | 44 | 37 | 41 | 41 | ... | ... | 41
 | 2011 | ... | ... | ... | ... | 37 | 32 | ...
Jordan
 | 2002 | 30 | 28 | … | … | ... | ... | 29
 | 2009 | ... | ... | ... | ... | ... | ... | 28
Kuwait
 | 2009 | 13.77 | 11.1 |  | ... | ... | ... | 12.6
Lebanon
 | 2004 | ... | ... | ... | ... | ... | ... | 19.1
 | 2009 | 11 | 9 | ... | ... | ... | ... | 10
Morocco
 | 2004 |  |  | 32.5 | 62.5 |  |  | 47.4
 | 2009-2010 | 6.7 | 5.8 |  |  |  |  | 6.3
Oman
 | 2005 | ... | ... | ... | ... | ... | ... | 11.05
 | 2009 | 14 | 10 | ... | ... | ... | ... | 12
 | 2010 |  |  | ... | ... | ... | ... | 11.3
Palestine
 | 1995-1999 | 36.7 | 29.3 | 29.9 | 35.2 | 33.2 | ... | 33.2
 | 2000-2004 | 31.8 | 24.6 | 27.7 | 24.5 | 28.3 | ... | 28.3
 | 2009 | 26.6 | 20 | 22.4 | 25.8 | ... | ... | 23.4
Qatar
 | 1999 | ... | ... | ... | ... | 14.4 | 11 | 12.7
 | 2004
 | 2005 | ... | ... | ... | ... | 10.5 | 10.4 | 10.4
 | 2010 | 11 | 10 | ... | ... | ... | ... | 10
 | 2011 | 9.6 | 8.3 |  |  |  |  | 9
Table 1.19: Child mortality rates by country, nationality, residence, sex and year (continued)
Saudi Arabia
 | 2004 | 23 | 22.7 |  |  |  |  | 22.8
 | 2005 | 22.6 | 21.9 | ... | ... | 21.2 | 27.6 | 22.3
 | 2009 | 21 | 19 | ... | ... | 19.1 | 24.7 | 20
The Sudan
 | 1999 | ... | ... | ... | ... | ... | ... | 104
 | 2008 | 128 | 115 | ... | ... | ... | ... | 122
Syrian Arab Republic
 | 1999 | ... | ... | ... | ... | ... | ... | 23.5
 | 2004 | ... | ... | ... | ... | ... | ... | 22.3
 | 2006 | 26 | 17 |  |  |  |  | 22
 | 2009 | 22.1 | 20.3 | 19.5 | 23.2 | ... | ... | 21.4
Tunis
 | 2011-2012 | 21.4 | 17.2 | ... | ... | ... | ... | 19.4
United Arab Emirates
 | 1999 | 12.4 | 11.3 | ... | ... | 12.4 | 11.5 | 11.9
 | 2005 | 10.3 | 9.4 | ... | ... | 10.2 | 9.6 | 9.9
 | 2009 | 10.2 | 7.8 | ... | ... | 9.11 | 9.03 | 9.1
 | 2010 | 9.7 | 7.4 | ... | ... |  |  | 8.6
Yemen
 | 1997 | 29.3 | 34.7 | 17.8 | 36 | ... | ... | 31.9
 | 2003 |  |  | 81 | 107.3 |  |  | 101.9
 | 2004 | 92.89 | 91.86 | 89.4 | 93.5 | 92.3 | ... | 92.3
 | 2010 | ... | ... | ... | ... | 90.2 | ... | 90.2
Spreadsheet: mary_fischer__25638__31U
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 031U
COMPANY NAME   Limbach Mgmt Company
ANALYSIS OF RESERVE ITEMS
FOR THE YEAR ENDED 12-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 141618d1329371064-copy-row-from-sheet-1-to-monthly-sheets-eg-3-4-5-etc-if-values-met-post-placement-tracking-sheet
Sheet: Feb 2012

Client Name | Case Manager | Employer | Placement Claimed | 13 Weeks Claimed | 26 Weeks Due |  | first day of month: | 2012-01-01 00:00:00
 |  |  |  |  |  |  | Records #
Spreadsheet: 263205d1378401887-sum-if-with-multiple-ifs-sumif-plus-and
Sheet: Sheet1

30101 | You | 15
30101 | you | 18
30101 | you | 22.5
30101 | me | 11.5
30202 | me | 6.25
30202 | you | 11.72
30202 | [NAME] | 15.25
30202 | [NAME] | 14.33
30202 | you | 12.99
30202 | [NAME] | 16.55
30202 | [NAME] | 14
30202 | me | 18.95
30303 | you | 16.5
30303 | me | 11.1
30303 | me | 7.5
Spreadsheet: c54abd56-4248-4766-a020-a6c5f853d6ed
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4498 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:51:36
4498 | 10414 | [NAME] | Fattori | FRA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:51:47
4498 | 10057 | Markus | [NAME] | SUI | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:53:39
Spreadsheet: 1df8317b-17ce-449a-a21a-105c613d83d0
Sheet: Table 5.5

Monthly Statistical Bulletin
5.5 Stock exchange indexes
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
All ordinaries index (a)
July | 4249.5 | 4507.4 | 4500.5 | 4289.400000000001 | 5035.7
August | 4484.1 | 4438.8 | 4369.9 | 4339 | 5125.3
September | 4739.3 | 4636.9 | 4070.7 | 4406.3 | 5217.7
October | 4646.9 | 4733.4 | 4360.5 | 4535.4 | 5420.3
November | 4715.5 | 4676.4 | 4184.7 | 4518 | 5314.3
December | 4882.7 | 4846.9 | 4111 | 4664.6 | 5353.1
January | 4596.9 | 4850 | 4325.7 | 4901 | 5205.1
February | 4651.1 | 4923.6 | 4388.1 | 5120.38 | 5415.4
March | 4893.1 | 4928.6 | 4420 | 4979.9 | 5403
April | 4833.9 | 4899 | 4467.2 | 5168.6 | 5470.8
May | 4453.6 | 4788.9 | 4133.7 | 4914 | 5473.8
June | 4324.8 | 4659.8 | 4135.5 | 4775.4 | 5382
S&P/ASX 200 index (b)
July | 4244 | 4493.5 | 4424.6 | 4269.1 | 5052
August | 4479.1 | 4404.2 | 4296.5 | 4316.1 | 5135
September | 4743.6 | 4582.9 | 4008.6 | 4387 | 5218.9
October | 4643.2 | 4661.6 | 4298.1 | 4517 | 5425.5
November | 4701.4 | 4584.4 | 4119.8 | 4506 | 5320.1
December | 4870.6 | 4745.2 | 4056.6 | 4648.9 | 5352.2
January | 4569.6 | 4753.9 | 4262.7 | 4878.8 | 5190
February | 4637.7 | 4831.7 | 4298.5 | 5104.08 | 5404.8
March | 4875.5 | 4837.9 | 4335.2 | 4966.5 | 5394.8
April | 4807.4 | 4823.2 | 4396.6 | 5191.2 | 5489.1
May | 4429.7 | 4708.3 | 4076.3 | 4926.6 | 5492.5
June | 4301.5 | 4608 | 4094.6 | 4802.6 | 5395.7
(a) Index at the end of the month. Base: December 1979 = 500.0. (In March 2000 the
all ordinaries index was at 3 133.3, and this was the base used for the S&P/ASX200
index.)
(b) Index at the end of the month. Base: March 2000 = 3 133.3.
Source: Australian Financial Review | http://www.afr.com/home/
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-08-01 00:00:00
Spreadsheet: 07169e9a-9df6-41ca-bf9a-43c6d1daeb7e
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 42. OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), 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 | A2413806K | 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 | A2413807L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413808R | 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 | A2413809T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413810A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413811C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413812F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413813J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413814K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413815L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413816R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 844016d1695823025-poker-replayer-id-like-to-have-excel-calculate-the-preflop-flop-turn-and-river-hand-6_9_23_1-dmyers-
Sheet: Grant

 |  |  |  |  |  |  |  |  |  |  |  |  |  | POSITION |  |  |  |  |  |  | BUILD A RANGE
 |  | Total # of Hands | 14 |  |  |  |  |  |  |  |  |  |  | COLOR CODES |  |  |  |  |  |  | AA | Aks | Aqs | [NAME] | Ats | [NAME] | A8s | A7s | [NAME] | A5s | A4s | A3s | A2s
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BUT | SB | BB | EP | MP | LP | CO | Ako | KK | KQs | KJs | [NAME] | K9s | [NAME] | K7s | K6s | [NAME] | K4s | [NAME] | K2s
 |  | PLAYER: Grant | MAN | TOTAL % | Sum | BUT | SB | BB | EP | MP | LP | CO |  |  |  |  |  |  |  |  | Aqo | Kqo | QQ | QJs | QTs | Q9s | Q8s | Q7s | Q6s | Q5s | Q4s | Q3s | Q2s |  | COLOR
 |  | VP$IP * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Kjo | Qjo | JJ | JTs | J9s | J8s | [NAME] | [NAME] | [NAME] | J4s | [NAME] | [NAME] |  | SCHEME
 |  | PFR * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Qto | Jto | TT | T9s | T8s | T7s | [NAME] | T5s | T4s | T3s | T2s |  |  | LIMP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A9o | K9o | [NAME] | [NAME] | T9o | 99 | 98s | 97s | 96s | 95s | 94s | 93s | 92s |  |  | CALL
 | Preflop | Call |  |  |  | 1 | 0 | 3 | 3 | 3 | 2 | 1 |  |  |  |  |  |  |  |  | A8o | K8o | Q8o | J8o | T8o | 98o | 88 | 87s | 86s | 85s | 84s | 83s | 82s |  |  | SHOVE
 |  | Check |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | A7o | K7o | Q7o | J7o | T7o | 97o | 87o | 77 | 76s | 75s | 74s | 73s | 72s
 |  | Raise |  |  |  | 1 | 1 | 1 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | A6o | [NAME] | Q6o | J6o | T6o | 96o | 86o | 76o | 66 | 65s | 64s | 63s | 62s
 |  | Fold |  |  |  | 0 | 1 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  | A5o | K5o | Q5o | J5o | T5o | 95o | 85o | 75o | 65o | 55 | 54s | 53s | 52s
 |  | 3Bet |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | J4o | T4o | 94o | 84o | 74o | 64o | 54o | 44 | 34s | 42s
 |  | Fold vs 3Bet |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | A3o | K3o | Q3o | J3o | [NAME] | 93o | 83o | 73o | 63o | 53o | 43o | 33 | 32s
 |  | 4Bet to 6Bet |  |  |  | 0 | 0 | 1 | 0 | 0 | 1 | 0 |  |  |  |  |  |  |  |  | A2o | K2o | Q2o | [NAME] | T2o | 92o | 82o | 72o | 62o | 52o | 42o | 32o | 22
 |  | LRR |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | Steal |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Fold vs Steal |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Postflop | Call |  |  |  | 2 | 0 | 0 | 0 | 2 | 0 | 3
 |  | Open |  |  |  | 0 | 0 | 1 | 1 | 5 | 0 | 2
 |  | Check |  |  |  | 0 | 1 | 0 | 1 | 0 | 0 | 1
 |  | Raise |  |  |  | 3 | 0 | 0 | 0 | 3 | 0 | 0
 |  | Fold |  |  |  | 1 | 1 | 1 | 2 | 0 | 2 | 0
 |  | CBET |  |  |  | 1 | 0 | 1 | 0 | 0 | 0 | 0
 |  | FvCBET |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | X/R |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | CBet3Bet |  |  |  | 1 | 0 | 1 | 0 | 0 | 0 | 0
 |  | FvCBET3Bet |  |  |  | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  | AF * |  |  |  |  | ← Total bets + total raises + total calls + total folds
 |  | WTSD |  |  | 3
 |  | W$SD |  |  | 1
 |  | Non SD Wins |  |  | 2
Spreadsheet: 782113d1653803406-using-xlookup-across-sheets-to-return-data-based-on-cell-testing-1-aligw
Sheet: QB

QB | Rankings
Player | Billy | [NAME] | Bright
 |  | 2 | 7
Z | 3 | 4 | 1
AB | 5 | 1 | 3
AE | 8 | 6 | 6
Spreadsheet: 847431d1698354474-how-to-update-a-worksheet-after-replacing-another-referenced-sheet-with-new-version-updatingworksheetsautomatically
Sheet: MyStock

 |  | Import Latest Figures from ERP
 |  |  |  |  |  |  | Should actually come from sales table
 |  |  |  |  |  |  |  |  |  | ORDER for MONTHS
 |  |  |  | Our Turnover = Sales/Month |  |  | BASED ON OCT | Days |  | 3
 |  |  | Our Stock | October | November | December | Months of Sales | Lead Time | ORDER? | Qty BASED ON OCT
 |  |  | 10 | 5 | 4 | 3 |  | 60
 |  |  | 20 | 6 | 5 | 4 |  | 60
 |  |  | 30 | 6 | 5 | 4 |  | 60
Spreadsheet: 71475d1272217281-excel-2007-two-pivot-table-queries-how-to-add-a-cumulative-column-and-a-data-sort-query-cum-column-and-data-sort-query
Sheet: Data

Yr/Pd | £
2009/1
2009/1
2009/1
2009/10
2009/10
2009/10
2009/11
2009/11
2009/11
2009/12
2009/12
2009/12
2009/2
2009/2
2009/2
2009/3
2009/3
2009/3
2009/4
2009/4
2009/4
2009/5
2009/5
2009/5
2009/6
2009/6
2009/6
2009/7
2009/7
2009/7
2009/8
2009/8
2009/8
2009/9
2009/9
2009/9
Spreadsheet: 751436d1634112658-vba-macro-to-apply-discount-to-order-form-case-example
Sheet: Sheet1

 | Products | Items | Price | Quantity | Discount | Total without [NAME] | Total with [NAME]
 | Product Offering A | Item 1 | 10 | 1 | 0.02
 |  | Item 2 | 15 | 2 | 0.02
 |  | Item 3 | 20 | 3 | 1
 | Product Offering B | Item 4 | 25 | 4 | 0.05
 |  | Item 5 | 30 | 5 | 0.02
 |  | Item 6 | 35 | 6 | 0.02
 | Product Offering C | Item 7 | 40 | 7 | 0.1
 |  | Item 8 | 45 | 8 | 0.02
 |  | Item 9 | 50 | 9 | 1
 |  |  |  |  | Total:
 | Order Total
 | Discount on other
 | Apply this discount to whole order:
Spreadsheet: 771670d1646784539-want-to-get-the-results-of-mavb-for-invoices-and-counts-and-sorted-smallest-to-largest-export-detail-ms-test-kisiji-
Sheet: mawb

 | MAWB | [NAME] | FILE NUMBERS | FILE COUNTS | SMALLEST TO LARGEST
 | 084-1071-2343 | MS-361-2022 | 361 | 1 | 361
 | 092-2112-2452 | MS-421-2022 | 421 | 1 | 405
 | 141-0518-2240 | MS-405-2022, MS-406-2022,  MS-407-2022, MS-408-2022, | 405, 406, 407, 408 | 4 | 406
 | 141-0521-6691 |  |  | 0 | 407
 | 155-0102-5021 | MS-411-2022, MS-445-2022 | 411, 445 | 2 | 408
 | 155-0102-5393 |  |  |  | 411
 |  |  |  |  | 421
 |  |  |  |  | 445
 | DATA AVAILABLE IN SHEET D, COLUM AD | DATA AVAILABLE IN SHEET D, COLUM J | DATA AVAILABLE IN SHEET D, COLUM H | COUNTS TOTAL COMMAS EITHER IN C OR D | ALLIGN ALL SMALLEST TO LARGEST
 | Want to get the results of mavb for invoices and counts and sorted smallest to largest (excelforum.com)
Spreadsheet: chris_stokley__3949__052101 Weather Difference Forecast Compare
Sheet: Differences

DIFFERENCE IN FORECAST ( FORECASTED WEATHER - ACTUAL WEATHER ) - SEPARATE BOOKS
PGE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME]. | Hrly. [NAME]
SDGE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME]. | Hrly. [NAME]
SCE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME]. | Hrly. [NAME]
PGE2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME]. | Hrly. [NAME]
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME]. | Hrly. [NAME]
SDGE2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME]. | Hrly. [NAME]
Spreadsheet: 80659d1280867709-data-entry-simplification-cost-example
Sheet: Prices

Lense # | Material 1 | Material 2 | Material 3 | Material 4
Lense 1 | 150 | 175 | 200 | 225
Lense 2 | 175 | 300 | 400 | 500
Lense 3 | 50 | 60 | 70 | 80
Lense 4 | 900 | 1250 | 1600 | 2000