tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53330d1253213635-phantom-decimal-figures-unknown-decimal-sum
Sheet: Sheet1

101324.81
1598178.99
821254.95
1928641.64
3230490.59
730477.34
5427851.46
602614.48
2748608.96
3426980.21
3935499.95
-1238184.66
-19545900.26
-4832062.18
-5099241.24
-3116867.17
-1449.8
-3430098.25
-4723989.93
-234000
-33937340.48
-34542497.06
3280136.57
-3280136.57
-3216176.92
-270541
-150
8333.36
88793.35
96974.96
100034.96
2810709.46
240066.32
37061
102000
53384.68
-12500
23956
74757.04
8100
24110.95
-500
76585
2338854.21
3869832.19
620533.78
1043000.37
1255503.21
3974800.63
711940.44
6712501.31
1738694.4
2565255.12
2993948.71
2310879.35
3461208.7
3559679.23
1355532.57
2650037.06
1601823.93
2558544.94
3048800.4
1066953.93
3180284.42
1100628.59
347335.54
2340084.27
1395304.13
2663926.47
3308579.73
2505681.17
1777230.5
796669.24
1673424.81
6018017.7
3266902.63
1847573.11
1207956.69
3036785.01
-4.237517714500427e-08
Spreadsheet: 849022d1699586439-calculating-monthly-sales-growth-rate-for-different-launch-and-retirement-periods-excel-help-example-multiple-start-and-end-periods
Sheet: Sheet1

 |  | Compound Monthly Sales Growth Rate (CMGR) from Launch to Retirement
 |  | Month |  |  |  |  |  |  |  |  |  |  | CMGR |  | CMGR
 | Sales | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | ??get it to choose the  different starting and ending periods based on if data is in the cell |  | Manually Adjust formula
 | Product #1 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190
 | Product #2 |  | 50 | 150 | 250 | 350 | 450 | 550 | 650
 | Product #3 |  |  | 5 | 5 | 5 | 5 | 10 | 10 | 10
 | Product #4 |  |  |  | 10 | 10 | 10 | 10 | 10 | 5 | 5
 | Product #5 |  |  |  |  | 100 | 75 | 50 | 50 | 25 | 75
 | Product #6 |  |  |  |  |  | 10 | 20 | 40 | 20 | 10
 | Product #7 |  |  | 100 | 110 | 75 | 50 | 75 | 100 | 125 | 300
 | Product #8 |  |  |  |  |  | 5 | 10 | 600 | 600 | 300
 | Product #9 |  |  |  |  | 10 | 30 | 50 | 50 | 50 | 50
 | Product #10 |  |  |  |  |  |  |  | 100 | 200 | 300
 |  | Actual sheet has 20,000 rows of products, ideally would just like to drag down/autofill a formula that can calculate the growth rate from different launch and retirement dates.
Spreadsheet: 701587d1603820543-need-to-identify-if-missing-input-sample
Sheet: Sample

Row # | cars | spaces | total stalls
1 | 4 |  | 14
2 |  | 5 | 15
3 |  |  | 20
4 |  | 0 | 19
5 | 3 |  | 7
6 | 22 |  | 71
total number of boxes:
I need C9 to return an error if any of column B does not have a number so that anyone filling out this form will know they have missed keying in an entry somewhere.
Spreadsheet: 1f9077fc-75d7-481e-bcbb-47bbd9c36404
Sheet: Sheet1

Office of Fleet Management Services | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Cost Comparison Between
Enterprise Provided Vehicle and Mileage Reimbursement
Effective March 1, 2012
DAILY VEHICLE NEEDS
Enter [NAME]'s Name
Enter Agency
Enter Destination
Enter Number of Miles for the Trip
Enter the Number of Days for the Trip
 | Enterprise |  | Personal
 | Vehicle |  | Vehicle
Lowest Cost Transportation: | 0 |  | 0
Spreadsheet: 822996d1679637025-ranking-on-multiple-criteria-book1
Sheet: Sheet1

Name | Age | Gender | SQ1 | Order
[NAME] | 58 | M | 90
[NAME] | 32 | F | 85
[NAME] | 65 | F | 100
[NAME] | 22 | M | 58
[NAME] | 27 | F | 79
[NAME] | 55 | M | 80
[NAME] | 26 | M | 93
[NAME] | 34 | M | 90
Gilberto Mongiello | 19 | F | 109
[NAME] | 20 | M | 50
[NAME] | 20 | M | 50
[NAME] | 16 | F | 50
Migdalia Windom | 23 | M | 98
Minh [NAME] | 21 | M | 75
[NAME] | 22 | M | 151
Renate Larocque | 36 | F | 77
Rubi Shimkus | 65 | F | 115
[NAME] | 18 | F | 147
[NAME] | 37 | F | 110
[NAME] | 18 | M | 118
Spreadsheet: louise_kitchen__23093__NETCO_All  Gas List_120601
Sheet: Admins

[NAME] | Financial | [NAME]
[NAME] | Derivitives | [NAME]
[NAME] | Central/East | [NAME]
[NAME] | Central/East | [NAME]
Amanda Hubble | West | [NAME]
[NAME] | Structuring/Fundys | [NAME]
[NAME] | Texas | [NAME]
[NAME] | Chicago | [NAME]
[NAME] | Clerk/Runner | [NAME]
[NAME] | Weather | [NAME]
[NAME] | Logistics | [NAME]
[NAME] | Mexico | [NAME]
Spreadsheet: 837018d1689787445-index-small-failed-to-replicate-example-example
Sheet: Example

 |  |  |  |  | A |  |  | C
Ref no. | Type | Title |  |  | Ref no. | Title |  | Ref no. | Title
1 | A | The Jungle Book
2 | B | Batman vs. [NAME]
3 | C | Iron Man 3
4 | D | The Fault in Our Stars
5 | A | Need for Speed
6 | B | The Eternals
7 | C | Black Panther
8 | D | [NAME]
9 | A | Inception
10 | B | Justice League |  |  | B |  |  | D
 |  |  |  |  | Ref no. | Title |  | Ref no. | Title
Spreadsheet: 772416d1647263038-how-to-calculate-time-spend-on-a-task-wavingdatetime_update
Sheet: Pivot

 |  |  | Values
Brand | Wave | Merch type | Min of start date time | [NAME] of confirmed date time | Sum of Wave Time
Aldo | [PHONE] | Accessories | 2022-02-22 07:32:48 | 2022-02-22 07:59:34 | 0:21:30
CIS | [PHONE] | Handbags | 2022-02-22 07:46:43 | 2022-02-23 10:43:29 | 10:56:46
Grand Total |  |  | 2022-02-22 07:32:48 | 2022-02-23 10:43:29 | 19:18:16
Spreadsheet: 801168d1666105018-add-word-or-between-the-two-words-adding-word-or-between-the-two-words
Sheet: Sheet1

1 | T9626263 | OR | T9626263 OR P2437263 OR P7499729 OR T0227709 OR Z3090777 OR S4962293 OR P4392209 OR T7026263 OR [NAME] OR S6022997 OR S6622409 OR Z9067042 OR [NAME] OR P0243624 OR S6707226 OR P7329060 OR T9326999 OR Z9393470 OR P0766034 OR P9493666
2 | P2437263
3 | P7499729
4 | T0227709
5 | Z3090777
6 | S4962293
7 | P4392209
8 | T7026263
9 | [NAME]
10 | S6022997
11 | S6622409
12 | Z9067042
13 | Z2623706
14 | P0243624
15 | S6707226
16 | P7329060
17 | T9326999
18 | Z9393470
19 | P0766034
20 | P9493666
Spreadsheet: 840339d1692662447-sumifs-while-cross-referencing-filtered-data-helper-or-no-helper-column-solution-
Sheet: Sheet3

People | Places | Purpose | Days |  | Purpose | Category |  | People | Personal | Business
[NAME] | Chicago | Business | 1 |  | Travel | Personal |  |  |  | 8
[NAME] | San Francisco | Tour | 2 |  | Business | Business |  | [NAME] the Eyebrow |  | 3
Zach | New York | Work | 3 |  | Tour | Personal |  | [NAME] |  | 0
Gina | Lisbon | Work | 4 |  | Family | Personal |  | [NAME] |  | 10
[NAME] the Eyebrow | Barcelona | Personal | 5 |  | Friends | Personal |  | Zach |  | 11
Gina | Madrid | Friends | 6 |  | Work | Business
Zach | New York | Seminar | 7 |  | Seminar | Business
[NAME] | Madrid | Tour | 8 |  | Conference | Business
[NAME] | Barcelona | Conference | 7 |  | Personal | Personal
[NAME] the Eyebrow | San Francisco | Travel | 6
[NAME] | San Francisco | Tour | 5
Gina | Chicago | Work | 4
[NAME] the Eyebrow | Lisbon | Conference | 3
[NAME] | Chicago | Seminar | 2
Zach | Lisbon | Business | 1
[NAME] | Madrid | Family | 10
Spreadsheet: 24133d1214251058-header-help-emptest
Sheet: Jim 2 Bob

To Emp | Amount | Date
[NAME] | 15 | 2008-06-03 00:00:00
[NAME] | 16.8 | 2008-06-05 00:00:00
[NAME] | 17 | 2008-06-06 00:00:00
[NAME] | 2 | 2008-06-06 00:00:00
[NAME] | 5 | 2008-06-10 00:00:00
[NAME] | 1.25 | 2008-06-12 00:00:00
[NAME] | 2.75 | 2008-06-15 00:00:00
[NAME] | 3 | 2008-06-15 00:00:00
[NAME] | 8 | 2008-06-20 00:00:00
[NAME] | 10 | 2008-06-20 00:00:00
Spreadsheet: 715868d1611898739-count-sum-based-on-another-column-date-range-value-book1-copy-unmerged-cell-updated-
Sheet: One Year All Marketing

SI NO | year 2020 | Deed Issued |  | Deed Received |  | Deed Not Received |  |  |  | Remarks | 2020
 |  | Quantity of Agreement | Total Amount | Received Quantity | Total Received Amount | Pending  Quantity | % | Pending Amount | %
1 | January
2 | February
3 | March
4 | April
5 | May
6 | June
7 | July
8 | August
9 | September
10 | October
11 | November
12 | December
 | Total
 |  | I did this part, in my way based on data of colunm D & F in Sheet '2020'. If you have more easy way you can suggest me too. |  | Literally, I failed to solve this part :( I need your help in this section. Received quantity should be count of column J which has value (or the rows which highlighted green within month range) comparing a date range of column D & received amount is the sum of column F based on received quantity
Spreadsheet: 168420d1342449173-index-and-match-or-best-formula-formula-ii-issues
Sheet: Data

Finance | GRADE
 | H | H | G | F | EU | EL | DU | DL | C | B | A
Cost Description | MD | Exec
Basic Pay | 292125 | 166050 | 86867 | 64722 | 46077 | 33115 | 33115 | 24348 | 24348 | 22489 | 19000
[NAME] (4%) | 11685 | 6642 | 3475 | 2589 | 1843 | 1325 | 1325 | 974 | 974 | 900 | 760
Share Incentive Plan - Matching | 2921 | 1661 | 869 | 647 | 461 | 331 | 331 | 243 | 243 | 225 | 190
SIP Free | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Flex Benefits (other costs) | 2921 | 1661 | 869 | 647 | 461 | 331 | 331 | 243 | 243 | 225 | 190
National Insurance | 46740 | 26568 | 11953 | 7922 | 4658 | 2934 | 2934 | 2053 | 2053 | 1761 | 1376
National Insurance Employee Benefit | 1461 | 830 | 434 | 324 | 230 | 166 | 166 | 122 | 122 | 112 | 95
Territorial (London) Allowance (£3450) | 863 | 863 | 863 | 863 | 863 | 863 | 863 | 863 | 863 | 863 | 863
Allowances (other) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Senior [NAME] | 131456 | 74723 | 21717 | 12944
Discretionary Bonus | 0 |  |  |  | 6912 | 3311 | 3311 | 1217 | 1217 | 1124 | 950
Senior Exec Share Ops | 54773 | 31134
Sharesave costs | 7303 | 4151 | 2172 | 1618 | 1152 | 828 | 828 | 609 | 609 | 562 | 475
Defined Benefit | 16264 | 9245 | 5392 | 4099 | 2951 | 2153 | 2153 | 1528 | 1528 | 1313 | 925
Defined Contribution | 30892 | 17560 | 8893 | 5631 | 3798 | 2166 | 2166 | 1329 | 1329 | 1022 | 631
Cars | 8280 | 8280 | 6540 | 5280 | 4500 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 607685 | 349366 | 150043 | 107285 | 73906 | 47522 | 47522 | 33529 | 33529 | 30596 | 25455
Spreadsheet: 146885d1332403039-excel-2007-automating-stock-portfolio-workbook-portfolio-example
Sheet: SUMMARY

 |  | PORTFOLIO
 |  | A. OPEN POSITION
 |  |  | Cost of shares |  |  | Valuation (Foreign Currency) |  |  |  | USD |  |  |  |  | COST
 | Account no. | STOCK | No.of shares | Av Price | Mkt Price | Curr Value | Gain/(Loss) | % | Curr Value | Gain/(Loss) | % |  |  | <-----------------------------Amount----------------------------------> |  |  |  |  |  |  | Foreign currency: USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Euro | AUD | CAD |  | USD |  |  | Euro | AUD | CAD
 |  |  |  | Euro | Euro | Euro | Euro |  | USD | USD
 |  |  |  |  | 2.25
 |  |  |  |  | 5.63
 |  | Sub-total
 |  |  |  | CAD | CAD | CAD | CAD |  | USD | USD
 |  |  |  |  | 5.63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.756 |  | 0.995
 |  | Sub-total
 |  | GRAND TOTAL
 |  | B.  CLOSED POSITION
 |  | REALISED PROFIT/(LOSS) |  |  |  |  |  |  |  |  |  |  |  | REALISED PROFIT/(LOSS)
 |  |  |  | Quantity |  | Forreign Currency |  |  |  | USD |  |  |  | FOREIGN CURRENCY |  |  |  |  | USD
 |  |  |  |  | Realised Profit / (Loss) |  |  |  |  | Profit/(Loss) |  |  |  | Avg. Cost | Total | Avg. Selling |  | Total | Total Cost | Total Sales
 |  | Counter |  |  | Euro | AUD | CAD |  | % | Amount | % |  |  | Price | Costs | Price |  | Sales | Amount | Amount
 |  | REALISED PROFIT/(LOSS) TO-DATE
Spreadsheet: 91931d1291633187-counting-using-nested-if-and-index-section-master-business-development
Sheet: Summary

Performance Indicators |  |  |  |  |  |  |  | Period: | Qtr2 | <---Choose
Directorate/Cost Centre |  | Total | Achieved | Just | Not | Pending
 |  | PIs |  | Below | Achieved
 |  |  |  |  |  |  |  |  |  |  |  |  | Qtr1 | Qtr2 | Qtr3 | Qtr4
Section A |  | 1 | #N/A | 0 | 0 | 0 |  |  |  |  |  | Short1
Section B |  | 0 | 1 |  |  |  |  | 2 |  |  |  | Short2
Section C |  | 0 | 1 |  |  |  |  |  |  |  |  | Short3
Section D |  | 0 | 0 |  |  |  |  |  |  |  |  | Short4
Section E |  | 0 | 0 |  |  |  |  |  |  |  |  | Short5
Section F |  | 0 | 2 |  |  |  |  |  |  |  |  | Short6
Section G |  | 0 | 2 |  |  |  |  |  |  |  |  | Short7
Section H |  | 0 | 2 |  |  |  |  |  |  |  |  | Short8
Section I |  | 0 | 2 |  |  |  |  |  |  |  |  | Short9
 |  | 1 | #N/A | 0 | 0 | 0
Note: Pis with an "O" in the type section will not be reported to SISG unless otherwise instructed
Activity: Strategy Actions/Service Objectives
Directorate/Cost Centre |  | Total | Achieved | Just | Not | Pending
 |  | SO/SA |  | Below | Achieved
Section A
Section B
Section C
Section D
Section E
Section F
Section G
Section H
Section I
 |  | 0 |  |  | 0 | 0
Note: Elements with a reference beginning with "SO" will not be reported to SISG unless otherwise instructed
Summary of Risks by Directorate and Section
Directorate/Cost Centre |  | Total | New | Risks | Risks | Risks | N.Corp | Total
 |  | Risks | Risks | Occurred | Increased | Closed | Risks | Corp Risks
Section A
Section B
Section C
Section D
Section E
Section F
Section G
Section H
Section I
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Notes:
New Risks: number of new risks since last period
Risks Occurred: number of risks which have occurred in the period
Risks Increased: number of risk scores which have increased from the base score (original)
Risks Closed: number of risks in the period which have been closed
N.Corp Risks: number of new risks in the period with a score of 19 or over (Corporate Risk)
Spreadsheet: 43793d1242397089-grouping-a-long-list-sample-list
Sheet: Sheet1

 | LV | LV0 | LV1 | LV2 | LV3 | Title
 | 00 | 00 |  |  |  | Animal
 | 01 |  | 01 |  |  | Fish
 | 02 |  |  | 02 |  | Trout
 | 02 |  |  | 02 |  | Pike
 | 02 |  |  | 02 |  | Tuna
 | 02 |  |  | 02 |  | Salmon
 | 01 |  | 01 |  |  | Dog
 | 03 |  |  | 02 |  | Huskey
 | 03 |  |  |  | 03 | Siberian
 | 03 |  |  |  | 03 | Malimut
 | 02 |  |  | 02 |  | German Shepard
 | 02 |  |  | 02 |  | Golden Retreiver
Spreadsheet: 830795d1685116333-vlookup-formula-to-grab-most-future-date-example
Sheet: Sheet1

 | what I have |  |  | What I would like
 | Item | Date |  | Item | latest date
 | apples | 2023-05-26 00:00:00
 | apples | 2023-05-04 00:00:00
 | apples | 2023-05-15 00:00:00
 | oranges | 2023-05-01 00:00:00
 | oranges | 2023-06-10 00:00:00
 | oranges | 2023-05-15 00:00:00
Spreadsheet: 823499d1679994073-number-of-suppliers-grouped-and-not-grouped-book1
Sheet: Sheet1

Category L1 / L2 / Supplier
Logistics | How many suppliers are under [NAME]? | How many suppliers are not grouped under [NAME]?
[NAME]
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Supplier 7
Supplier 8
Supplier 9
Supplier 10
Supplier 11
Supplier 12
Supplier 13
Supplier 14
Supplier 15
Supplier 16
Supplier 17
Supplier 18
Spreadsheet: 870668d1717143633-summing-issue-summing-issue-aligw
Sheet: Sheet1

P | 1
 | 1
 | 3
P | 1
 | 2
 | 1
P | 2
 | 1
 | 3
SUM
Spreadsheet: 285953d1387959706-convert-text-to-columns-will-not-work-sample
Sheet: Sheet1

Date | Description | Debit | Credit | Total
[NAME] | PAYPAL *USEDSUBARU [PHONE] | 35.00 |  | 362.54
[NAME] | LEGAL & GEN MI C/L | 18.58
03/04/2013 | BBA ROCHESTER | 55.20 |  | 307.34
04/04/2013 | CITY ELECTRICAL BURGES HL 349 | 39.00 |  | 308.34
04/04/2013 | MV- 65579403 -2803 |  | 40.00
05/04/2013 | INT'L [PHONE] PAYPAL *WINNETTRAD [PHONE] | 3.49 |  | 304.85
09/04/2013 | BRUNEL ENGRAVING C CLEVEDON | 33.24 |  | 271.61
10/04/2013 | MV- 65579403 -0504 |  | 60.00 | 331.61
11/04/2013 | CHQ IN AT HSBC BANK PLC CANTERBURY |  | 80.00 | 831.61
11/04/2013 | CASH IN HSBC APR11 CANTERBURY D@12:46 |  | 420.00
12/04/2013 | HMRC - NI DD | 10.60 |  | 881.01
12/04/2013 | MV- 65579403 -0904 |  | 60.00
13/04/2013 | CHARGE FREQ STMT - MTHLY | 1.00 |  | 880.01
15/04/2013 | FUSION CANTERBURY CANTERBURY | 186.00 |  | 562.83
15/04/2013 | POLICY ADMIN SERVS | 9.99
Spreadsheet: 277a15cf-9c43-45fc-84c8-59beb37b8086
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6071 | 72255 | [NAME] | [NAME] | CHN | 0 | [NAME] | 00:00:00 | 01:14:24 | 00:00:00 | 00:37:15 | 1 | 02:12:07
6071 | 13282 | Miu | Hiraide | JPN | 73 | 00:20:17 | 00:00:00 | 01:14:31 | 00:00:00 | 00:38:27 | 2 | 02:13:16
6071 | 6457 | Yayoi | Ito | JPN | 72 | 00:20:15 | 00:00:00 | 01:14:34 | 00:00:00 | 00:39:49 | 3 | 02:14:41
6071 | 6801 | [NAME] | [NAME] | HKG | 74 | 00:22:07 | 00:00:00 | 01:17:25 | 00:00:00 | 00:41:07 | 4 | 02:20:40
6071 | 6803 | Leanne | [NAME] | HKG | 75 | 00:22:10 | 00:00:00 | 01:17:24 | 00:00:00 | 00:45:55 | 5 | 02:25:30
6071 | 25261 | Tamiyo | Sugawara | JPN | 76 | 00:21:31 | 00:00:00 | 01:26:58 | 00:00:00 | 00:48:18 | 6 | 02:36:46
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | - | - | 6 | 13 | 27 | 14 | 15 | 3 | 78
Cap/Floor | 12 | 1 | 5 | 23 | 61 | 3 | - | - | 105
Debt Option | - | - | - | - | - | - | - | - | -
Exotic | - | - | - | - | - | - | - | - | -
Fixed-Fixed | - | - | - | - | - | - | - | - | -
Fixed-Float | 30 | 27 | 66 | 273 | 937 | 1219 | 1835 | 654 | 5041
FRA | - | 3 | 3 | - | - | - | - | - | 6
Inflation | - | 13 | 16 | 2 | 2 | 6 | 11 | 3 | 53
OIS | 7 | - | 9 | 8 | 10 | 4 | - | - | 38
Swaption | - | - | - | 13 | 56 | 85 | 115 | 6 | 275
TOTAL | 49 | 44 | 105 | 332 | 1093 | 1331 | 1976 | 666 | 5596
Spreadsheet: 792624d1661013474-retrieving-data-from-a-table-based-on-two-drop-down-box-values-sample1-1
Sheet: Department Report

1969
 |  |  | Department Costing Report
 |  | Supplier | Marketing |  | Month 1 | June
 |  |  |  |  | Month 2 | July
 |  | Total Spent inc. VAT
 |  | Total Spent ex. VAT
 |  | Total VAT
 |  |  |  |  | Difference +/-
 |  | Supplier Expenditure With Chosen Department
 |  |  | Total YTD |  |  | Difference +/-
 |  | All Suppliers
 |  | [NAME] |  |  |  |  |  | Sum of "D16"'s Total inc VAT expenditure for Month 1 (G16) and Month 2 (G17)
 |  | AJet | 5000 |  | 200 |  |  | This to follow for every supplier on the left side of this report.
 |  | Amazon | 2000 | 1000
 |  | Arboritom |  |  |  |  |  | Basically, you choose your department and the months you would like info for.
 |  | Arleigh
 |  | Asgard | 15000 | 5000 | 5000 |  |  | From this, you can see how much that department has spent for the month as a total
 |  | AvantiGas |  |  |  |  |  | and how much has been spent with each supplier.
 |  | Buildbase | 600 | 500
 |  | Calor |  |  |  |  |  | Ive written examples in the report form to the left, not actual figures, but that’s how id like the info displayed.
 |  | [NAME]
 |  | Coast & County Ltd | 750 |  | 510 |  |  | I made the table in the Purchase Order Data but it doesn’t actually give me the figures the each suppliers monthly costs.
 |  | Creative Play | 400 | 250
 |  | DeeBee |  |  |  |  |  | The "Purchase Orders" sheet is where I add my data, so im guess its easier to get the
 |  | Eden Farm Hulleys |  |  |  |  |  | information straight from there
 |  | EuroCell | 200 |  | 150
 |  | Firestop Services |  |  |  |  |  | Hopefully this is enough info for you
 |  | Foundations and Buildings | 200 | 100
 |  | [NAME]
 |  | [NAME]'s Homeware
 |  | Keycraft
 |  | [NAME] | 700 | 500
 |  | [NAME] | 90 |  | 80
 |  | LincsPest Ltd
 |  | Miscellaneous Vendor
 |  | Office Stationary
 |  | S and A Colclough
 |  | Screwfix
 |  | SGS
 |  | Smart Spanner
 |  | SSE
 |  | Tesco
 |  | Veolia
 |  | Victorian Plumbing
 |  | Weldricks Pharmacy
 |  | Welton Aggregate
 |  | Windhager
 |  | Y Pellets
 | ------------------------------------------------------------------------------------------------------------------------------------------------------------
 |  | All Purchase Orders for selected "Month 1"
 |  | PO Number | Date of Purchase | Costing Code | Cost inc. VAT | Total VAT
 |  | All of the above figures are correct as of todays date, providing all Purchase Orders have been input into the [NAME] form.
Spreadsheet: darrell_schoolcraft__7596__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2002-01-04 00:00:00
 |  |  | SoCal Gas Price |  | 2.35
 |  |  | San Juan Gas Price |  | 2.185
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 503 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 541 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 539 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 541 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 540 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 540 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 531 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 531 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 530 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 530 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 529 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 529 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 530 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 529 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 530 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 539 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 539 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 447 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 403 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 403 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 403 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 403 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 403 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 403 | 7
Spreadsheet: 790119d1659540062-lookup-a-value-in-tab-and-insert-corresponding-data-into-new-tabs-resource-db-excelforum-separate-tab
Sheet: Business

 | Name | Surname | [NAME] |  |  |  | Business
 |  | surname6 | email6
 | name9 | surname9 | email9
 | name12 | surname12 | email12
 | [NAME] | surname21 | [NAME]
 | [NAME] | surname26 | email26
 | name28 | surname28 | email28
 | name29 | surname29 | email29
 | name41 | [NAME] | email41
 | name43 | surname43 | email43
 | name44 | surname44 | email44
 | name48 | surname48 | email48
 | name49 | surname49 | email49
 | name50 | surname50 | [NAME]
 | [NAME] | surname52 | email52
 | [NAME] | surname65 | email65
 | name66 | surname66 | email66
 | name71 | surname71 | email71
 | name76 | surname76 | email76
 | name84 | surname84 | email84
 | name87 | surname87 | email87
 | name104 | surname104 | email104
 | name121 | surname121 | email121
 | name127 | surname127 | [NAME]
 | name130 | surname130 | email130
 | name142 | surname142 | email142
 | [NAME] | surname147 | [NAME]
 | name148 | surname148 | email148
 | name153 | surname153 | email153
 | name167 | surname167 | email167
 | name171 | surname171 | email171
 | name175 | surname175 | email175
 | name180 | surname180 | email180
 | name181 | surname181 | email181
 | name187 | [NAME] | email187
 | name192 | surname192 | email192
 | name193 | surname193 | email193
 | [NAME] | surname196 | email196
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: wd

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total