tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 22

CONSOLIDATED BALANCE SHEET | September 2011 | December 2010
R$ million
Assets
Current assets
Cash and cash equivalents | 5958.912 | 5909.34
Investment securities (CURRENT) | 660.616 | 1069.276
Trade and other receivables (current) | 4617.009999999999 | 3794.072
Inventories | 1986.709 | 1905.229
Income tax receivable | 338.372 | 181.199
Assets held for sale | 0.4 | 51.833
 | 13562.019 | 12910.949
Non-current assets
Investment securities | 204.743 | 208.742
Trade and other receivables | 1968.992 | 2132.121
Deferred tax assets | 1238.774 | 1089.771
Income tax receivable (non-current) | 29.503 | 0
Employee benefits | 21.044 | 20.923
Investments in associates | 20.821 | 18.502
Property, plant and equipment | 8887.404 | 7032.298
Intangible assets | 1791.373 | 1823.238
Goodwill | 17441.823 | 17441.756
 | 31604.477 | 29767.351
Total assets | 45166.496 | 42678.3
Equity and liabilities
Current liabilities
Trade and other payables | 10339.848 | 7142.942999999999
Interest-bearing loans and borrowings (current) | 3120.318 | 2606.228
Bank overdrafts | 2.039 | 1.041
Income tax and social contribution payable | 602.8509999999999 | 701.647
Provisions | 162.672 | 102.996
 | 14227.728 | 10554.855
Non-current liabilities
Trade and other payables (NON CURRENT) | 1139.176 | 1343.367
Interest-bearing loans and borrowings | 2199.708 | 4164.214
Deferred tax liabilities | 935.4860000000001 | 548.728
Provisions (non-CURRENT) | 472.326 | 536.073
Employee benefits (non CURRENT) | 995.338 | 966.221
 | 5742.034000000001 | 7558.603
Total liabilities | 19969.762 | 18113.458
Equity
Issued capital | 8299.059 | 7613.78
Reserves | 11100.429 | 16748.083
Retained earnings | 5608.495 | 0
Equity attributable to equity holders of AmBev | 25007.983 | 24361.863
Non-controlling interests | 188.751 | 202.979
Total Equity | 25196.734 | 24564.842
Total equity and liabilities | 45166.49599999999 | 42678.3
Spreadsheet: 376731d1423688932-matching-pairs-duplicate-pairs-01
Sheet: Dupe Data 01

Date | Ref 1 | Ser No | x | Result required Matching pairs
2014-10-06 13:22:00 | 781 | 1950338224 |  | 1
2014-10-06 13:22:00 | 781 | 1950338224 |  | 1
2014-10-06 13:23:00 | 782 | 3061863788 |  | 2
2014-10-06 13:23:00 | 782 | 3061863788 |  | 2
2014-10-06 13:25:00 | 783 | 3833456170 |  | 3
2014-10-06 13:25:00 | 784 | 2259967852 |  | Solo
2014-10-06 13:25:00 | 783 | 3833456170 |  | 3
2014-10-06 13:25:00 | 784 | 2259967852 |  | Solo
2014-10-06 13:27:00 | 785 | 4132069228 |  | Solo
2014-10-06 13:29:00 | 786 | 646403436 |  | 4
2014-10-06 13:29:00 | 786 | 646403436 |  | 4
2014-10-06 13:30:00 | 787 | 3334299500 |  | Solo
2014-10-06 13:30:00 | 788 | 1157131580 |  | 5
2014-10-06 13:30:00 | 787 | 3334299500 |  | Solo
2014-10-06 13:30:00 | 788 | 1157131580 |  | 5
2014-10-06 13:39:00 | 789 | 3559116464 |  | 6
2014-10-06 13:39:00 | 789 | 3559116464 |  | 6
2014-10-06 13:48:00 | 790 | 1954901052 |  | Solo
2014-10-06 13:52:00 | 791 | 885494445 |  | 7
2014-10-06 13:52:00 | 791 | 885494445 |  | 7
Spreadsheet: 876696d1723434437-conditional-formatting-based-on-different-days-and-time-on-multiple-applications-appl_test-v1
Sheet: Daily Online Report

 | Systems | Time (hrs) Input by User | Status (Color Code) | Note | Systems (SLA) Targets |  | Mon to Thursday and Time Range |  | Friday and Time Range |  | Conditions
 | Application 1 | 19:31:00 | Red |  |  |  | 08:00:00 | 19:30:00 | 08:00:00 | 19:30:00 | before 8:00am or equal to 8:00am = Green, After 8:00am until 19:30 is yellow after 19:30 is Red
 | Application 2 | 21:00:00 | yellow |  |  |  | 08:00:00 | 21:00:00 | 08:00:00 | 21:00:00 | before 8:00am or equal to 8:00am = Green, After 8:00am until 21:00 is yellow, after 21:00 is Red
 | Application 3 | 08:45:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00 | Mon to [NAME]:  before 8:45am or equal to 8:45am = Green, after 8:45am until 17:45 is yellow, after 17:45 is Red | Fri :  before 8:45am or equal to 8:45am = Green, after 8:45am until 16:45 is yellow, after 16:45 is Red
 | Application 4 | 08:46:00 | yellow |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 5 | 08:40:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 6 | 18:45:00 | Red |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 7 | 19:00:00 | Red |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 8 | 08:00:00 | green |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 9 | 08:45:00 | green |  |  |  | 08:45:00 | 18:00:00 | 08:45:00 | 18:00:00
 | Application 10 | 08:45:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 16:45:00
 | Application 11 | 08:45:00 | green |  |  |  | 08:45:00 | 17:45:00 | 08:45:00 | 17:45:00
 | Application 12 | 24 | green |  |  |  |  |  |  |  | Mon to Fri: 24 hours is always Green
 | Application 13 | 24 | green
 | Application 14 | 24 | green
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 0 | 4 | 4
Europe/North America | 0 | 4 | 4
Index | 14102 | 98 | 14200
Europe/Other | 8970 | 64 | 9034
North America/Asia | 5132 | 34 | 5166
Other | 6 | 32 | 38
TOTAL | 14108 | 134 | 14242
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 101751 | 98243
2 | 102927 | 104706
3 | 117477 | 116286
4 | 119833 | 117531
5 | 123072 | 121673
6 | 115143 | 114331
7 | 104853 | 105766
8 | 104302 | 102762
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | -47216
2001-12-08 00:00:00
CBS Dollars
 |  |  | 234489 |  |  |  | 12
 |  |  |  |  |  |  | 500
 |  |  |  |  |  |  | 5895
Spreadsheet: 777863d1650643278-retrieving-average-data-cells-from-sheets-using-lists-test-data
Sheet: Class 1

CES Assessment Services
CES Assessment Services
CES Assessment Services
CES Assessment Services
Name | Age Difference Subject 1 | Age Difference Subject 2 | Age Difference Subject 3 | Age Difference Subject 4 | [NAME]
Name 1 | 0.57 | 0.95 | 0.37 | 0.75 | 123.09
Name 2 | 0.46 | -0.16 | 0.9 | 0.93 | 114.83
Name 3 | 1.52 | 0.97 | 1.62 | 1.59 | 134.08
Name 4 | -0.88 | -1.15 | -0.22 | 1.01 | 106.3
Name 5 | 2.85 | 1.58 | -0.68 | 2.36 | 134.48
Name 6 | 1.15 | 1.75 | 0.22 | 0.41 | 126.78
Name 7 | 3 | 2.48 | 2.7 | 2.39 | 124.82
Name 8 | 3.47 | 3.2 | 3.98 | 1.85 | 126.41
Name 9 | -0.57 | -0.98 | -0.47 | 1.71 | 145
Name 10 | 1.01 | 1 | 1 | 1.82 | 114.42
 |  |  |  |  |  | Average
Percentage with an Age Difference of > 3 Years
Percentage with an Age Difference of < 0 Years
Spreadsheet: 866363d1713293606-issues-getting-sum-formula-to-work-kansas-scheduler-v4-5-etaf
Sheet: Kitting Schedule

[NAME] from date below↓ | ↓Minimum # of Kits↓ | DO NOT EDIT IN THIS REPORT
2024-04-04 00:00:00 | 25
Client | Job # | # of Stores | # of Pieces | Ship Date | Notes
 | 246061 | 120 | 120 | 2024-04-10 00:00:00 | 0
HALL 246063 [10] | 246063 | 50 | 50 | 2024-04-10 00:00:00 | 0
P&S 246437 [10] | 246437 | ? | 5650 | 2024-04-10 00:00:00 | 0
Spreadsheet: 862525d1710235167-how-to-pull-the-data-from-sheet-1-to-sheet-2-excel-to-fetch-the-data-aligw
Sheet: Sheet2

 | Start Date | 2024-02-09 00:00:00 |  |  |  | End Date | 2024-12-03 00:00:00
CID Number | Campaign Name | Data | Start Date | End Date | Total Cost (₹) | Trade discont 15% | GST | GST 18% | Without GST | Total Campaign Runing Day
 | YM Test Advertiser | 19-02-2024 | 45342 | 45371 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 29
CID-1305 | Murugan S | 15-02-2024 | 45338 | 45343 | 1062 | 159.3 | 902.7 | 162.486 | 740.214 | 5
CID-1304 | Royal | 15-02-2024 | 45337 | 45365 | 35400 | 5310 | 30090 | 5416.2 | 24673.8 | 28
CID-1303 | Oxford English School | 15-02-2024 | 45338 | 45347 | 1180 | 177 | 1003 | 180.54 | 822.46 | 9
CID-1302 | YM Test Advertiser | 15-02-2024 | 45345 | 45345 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 0
CID-1301 | YM Test Advertiser | 15-02-2024 | 45338 | 45346 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 8
CID-1300 | YM Test Advertiser | 13-02-2024 | 45336 | 45342 | 99.9 | 14.985 | 84.915 | 15.2847 | 69.6303 | 6
CID-1299 | [NAME] | 12-02-2024 | 45334 | 45338 | 2065 | 309.75 | 1755.25 | 315.945 | 1439.305 | 4
CID-1298 | Testt | 12-02-2024 | 45336 | 45343 | 295 | 44.25 | 250.75 | 45.135 | 205.615 | 7
CID-1297 | Aniruth s | 12-02-2024 | 45343 | 45346 | 708 | 106.2 | 601.8 | 108.324 | 493.476 | 3
CID-1296 | [NAME] | 10-02-2024 | 45333 | 45333 | 2360 | 354 | 2006 | 361.08 | 1644.92 | 0
CID-1295 | Arumugam.P | 09-02-2024 | 45332 | 45336 | 1770 | 265.5 | 1504.5 | 270.81 | 1233.69 | 4
CID-1294 | [NAME] | 09-02-2024 | 45332 | 45336 | 1770 | 265.5 | 1504.5 | 270.81 | 1233.69 | 4
CID-1293 | V.Ganeshpandian Saravanampatti | 09-02-2024 | 45332 | 45332 | 5900 | 885 | 5015 | 902.6999999999999 | 4112.3 | 0
CID-1292 | Magesh.S | 08-02-2024 | 45331 | 45336 | 1062 | 159.3 | 902.7 | 162.486 | 740.214 | 5
CID-1291 | [NAME] | 08-02-2024 | 45331 | 45338 | 2360 | 354 | 2006 | 361.08 | 1644.92 | 7
Spreadsheet: 867182d1714052619-large-data-set-and-complexish-formulae-causing-system-to-be-slow-excel-help-2504
Sheet: Sheet2

French Ligue 1
HT 6 games Xg |  |  |  |  |  | Back FH O.5
Match 6 games Xg |  |  |  |  |  | Win | SR | LLR | P/L | Av BF
HT Xg
Match [NAME]
Home
Draw
Away
FH O.5
FH 1.5
O 1.5
O 2.5
O 3.5
Spreadsheet: d5d074b6-5957-4bf0-93ba-48948388ab7d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTOL | Test | FFTOL | Toluene, Occupational Exposure, Serum | Toluene, Serum | Headspace Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 20 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin tubes immediately and fill 2 transfer tubes completely to prevent loss of volatile compound into headspace. Send 20 mL sodium heparin plasma refrigerated.   Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable. Spin tubes immediately and fill 2 transfer tubes completely to prevent loss of volatile compound into headspace. Send 20 mL of serum refrigerated. | 2.5 mL | Hemolysis	NA Thawing 	Cold OK; [NAME] Lipemia	NA Icterus	NA Other	NA | Units:  mg/L   Normal (Unexposed Population):          	None Detected Exposed:        	Not Established Toxic:        	Not Established   Test Performed by:	Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 7 days | 9 - 16 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc.
FFTOL | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FFTOL | Result | Z1191 | Toluene | Toluene | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 485653d1476989234-finding-minimum-excluding-the-zero-min_max
Sheet: Sheet1

IP E4/F3 Hum | 2016-10-10 20:00:00 | 35.7 | 21.6
IP E4/F3 Hum | 2016-10-10 20:05:00 | 35.8 | 21.6
IP E4/F3 Hum | 2016-10-10 20:10:00 | 35.9 | 0
IP E4/F3 Hum | 2016-10-10 20:15:00 | 35.9 | 0
IP E4/F3 Hum | 2016-10-10 20:20:00 | 35.9 | 0
IP E4/F3 Hum | 2016-10-10 20:25:00 | 36 | 21.4
IP E4/F3 Hum | 2016-10-10 20:30:00 | 36 | 21.3
IP E4/F3 Hum | 2016-10-10 20:35:00 | 0 | 21.3
IP E4/F3 Hum | 2016-10-10 20:40:00 | 0 | 21.2
IP E4/F3 Hum | 2016-10-10 20:45:00 | 0 | 21.2
IP E4/F3 Hum | 2016-10-10 20:50:00 | 36.2 | 21.2
IP E4/F3 Hum | 2016-10-10 20:55:00 | 36.2 | 21.2
IP E4/F3 Hum | 2016-10-10 21:00:00 | 36.3 | 21.1
IP E4/F3 Hum | 2016-10-10 21:05:00 | 36.3 | 21.1
IP E4/F3 Hum | 2016-10-10 21:10:00 | 36.3 | 21
IP E4/F3 Hum | 2016-10-10 21:15:00 | 36.4 | 21
IP E4/F3 Hum | 2016-10-10 21:20:00 | 36.4 | 21
IP E4/F3 Hum | 2016-10-10 21:25:00 | 36.4 | 20.9
IP E4/F3 Hum | 2016-10-10 21:30:00 | 36.4 | 20.9
IP E4/F3 Hum | 2016-10-10 21:35:00 | 0 | 20.8
IP E4/F3 Hum | 2016-10-10 21:40:00 | 36.5 | 0
IP E4/F3 Hum | 2016-10-10 21:45:00 | 36.5 | 20.8
IP E4/F3 Hum | 2016-10-10 21:50:00 | 36.6 | 20.7
IP E4/F3 Hum | 2016-10-10 21:55:00 | 36.5 | 20.8
 | Min
 | [NAME]
Spreadsheet: 91765d1291414473-a-lookup-function-to-search-through-array-and-return-row-number-test
Sheet: 2010

 |  | Year | Month | Date | Day of Week | [NAME] | Election Cycle #1 | Election Cycle #2 | [NAME] | [NAME] | Midterm Election | 40-wk  Cycle | 212-wk  Cycle | help1 | help2
 |  |  |  |  |  |  |  |  |  |  | partial
2010-01-01 00:00:00
Spreadsheet: cd6ea3fb-67ac-4922-90bf-29b7dea716da
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Delitzsch, Stadt - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 55 | 16080 | 13916 | 11874 | 10390
55 - 60 | 2193 | 2208 | 2152 | 1701
60 - 65 | 1563 | 2064 | 2121 | 2088
65 - 75 | 3329 | 2933 | 3293 | 3901
75 - 85 | 2172 | 2647 | 2723 | 2344
85 und mehr | 698 | 976 | 1187 | 1546
Insgesamt | 26035 | 24744 | 23350 | 21970
%
unter 55 | 61.76301133090071 | 56.23989654057549 | 50.85224839400428 | 47.29176149294492
55 - 60 | 8.423276358747838 | 8.923375363724539 | 9.216274089935759 | 7.742375967228038
60 - 65 | 6.00345688496255 | 8.341416100872939 | 9.083511777301927 | 9.503868912152935
65 - 75 | 12.7866333781448 | 11.85337859683156 | 14.10278372591007 | 17.75603095129722
75 - 85 | 8.342615709621663 | 10.69754283866796 | 11.66167023554604 | 10.66909421939008
85 und mehr | 2.681006337622431 | 3.944390559327514 | 5.083511777301927 | 7.036868456986801
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: d699f01f-7dcb-46cb-ace0-d1185ccf6e83
Sheet: Sheet1

Unnamed: 0 | [NAME] | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Names on Checklist | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
November 2, 2004  Summary By Counties | Regular | Absentee | Total |  | Republicans | Democrats | Undeclared | Totals |  | Election-Day Registrations**
Belknap County | 29221 | 3328 | 32549 |  | 14923 | 9102 | 15694 | 39719 |  | 4179
Carroll County | 24663 | 3722 | 28385 |  | 12520 | 6699 | 16449 | 35668 |  | 2902
Cheshire County | 38229 | 3407 | 41636 |  | 13397 | 15032 | 24083 | 52512 |  | 6358
Coos County | 15342 | 1791 | 17133 |  | 6119 | 6303 | 8969 | 21391 |  | 2036
Grafton County | 42055 | 5198 | 47253 |  | 17046 | 15746 | 26360 | 59152 |  | 6606
Hillsborough County | 179605 | 17031 | 196636 |  | 79774 | 67560 | 98593 | 245927 |  | 28093
Merrimack County | 71079 | 6734 | 77813 |  | 31214 | 25613 | 39774 | 96601 |  | 11768
Rockingham County | 146014 | 14278 | 160292 |  | 63815 | 51402 | 87808 | 203025 |  | 18744
Strafford County | 55523 | 4584 | 60107 |  | 20232 | 23740 | 30547 | 74519 |  | 11189
Sullivan County | 19882 | 1986 | 21868 |  | 8101 | 7198 | 12048 | 27347 |  | 2556
Totals | 621613 | 62059 | 683672 |  | 267141 | 228395 | 360325 | 855861 |  | 94431
** This number is included in Names on Checklist
updated 2/9/05
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 12127030 | 26103308.86
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 494916 | 1135536.7
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 12621946 | 27238845.56
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -565017 | -1238595.26
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -20000 | -41600
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 5 | 11
 | Total Purchases: |  | -585012 | -1280184.26
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 8946474 | 20485312.33
12 |  | Purchases | -13154986 | -29688203.2
 | Total Intra CTS Sales / Purchases |  | -4208512 | -9202890.870000005
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | -557916 | -1276941.74
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -557916 | -1276941.74
 | Total Storage: |  | -557916 | -1276941.74
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -7270506 | -14886324.30146325
 |  |  | 0 | 0
23 | Fuel: |  | -5 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -165443
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -165443
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | -848403
31 |  | Prior Month Book Balance | 0 | 2098676
 |  | Total MTM Income | 0 | 1250273
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -287608.72
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0 | 9167000
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 544501d1508929075-how-to-modify-from-1st-position-to-other-how-to-modify-from
Sheet: Лист1

 | More like this
 | project gantt
 | 123
 | More like this
 | gantt diagram online
 | 720
 | More like this
 | gantt template
 | 720
 | More like this
 | template
 | 368000
 | More like this
 | online
 | 2240000
 | More like this
 | sweet
 | 673000
 | More like this
 | chocolate
 | 1830000
Spreadsheet: 694728d1599762935-if-formula-help-dschittone-example
Sheet: Sheet2

 |  |  | A | B | C | D | E | F | G | h |  | don't know what to do with this column as you didn't address it
 |  | A |  |  |  |  |  |  |  |  | xx | 1
 |  | B |  |  |  |  |  |  |  |  | xxx | 2
 |  | C |  |  |  |  |  |  |  |  | xxxx | 3
 |  | D |  |  |  |  |  |  |  |  | yy | 4
 |  | E |  |  |  |  |  |  |  |  | yyy | 5
 |  | F |  |  |  |  |  |  |  |  | yyyy | 6
 |  | G |  |  |  |  |  |  |  |  | zz | 7
 |  | h |  |  |  |  |  |  |  |  | zzz | 8
Spreadsheet: 699104d1602403513-index-match-3-criterion-match-return-value-question-book1-22
Sheet: Template

 |  | File | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Account
 |  | 913145138 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009004870
 |  | 912472516 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009004870 |  |  |  |  |  |  |  |  | 648.31
 |  | 913179271 | BAT MAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016003790 |  |  |  |  |  |  |  |  | 51.59
 |  | 913530576 | BRUCE WAYNE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2018003244 |  |  |  |  |  |  |  |  | 6438.5
Spreadsheet: 37529d1235567549-speed-optimization-timer
Sheet: Sheet3

 |  | Average Time | Improvement | Calculation | [NAME]
 | Formula 1 | 0.03369875200005481 | 0 | 1
 | Formula 2 | 0.04780603199760662 | -0.4186291527214083 | 1
 | Formula 3 | -1 | 0
 | Formula 4 | -1 | 0
 | Formula 5 | -1 | 0
 | Iterations | 1000
 | Data 1 | 1
 | Data 2 | 0
 | Data 3 | 20
 | Data 4 | 30
 | Data 5 | 40
 | Data 6 | 50
 | Data 7 | 60
 | Data 8 | 70
 | Data 9
 | Data 10
 | Data 11
 | Data 12
Spreadsheet: 35149d1232663370-count-condition-unique-items-countconditionaluniqueitems
Sheet: Sheet2

January |  |  |  |  |  |  | # of Unique Customers | # of Items | Amount
2008 |  |  |  |  |  | Q1 | 2 | 3 | 87.13
 |  |  |  |  |  | Q2 | 3 | 4 | 83.85
 |  |  |  |  |  | Q3 | 3 | 5 | 196.99
 |  |  |  |  |  | Q4 | 2 | 3 | 137.42
 |  | Customer # |  |  |  |  |  |  |  |  | Date Completed | Amount
 |  | 2345678901 |  |  |  |  |  |  |  |  | 2008-01-08 00:00:00 | 12.35
 |  | 1234567890 |  |  |  |  |  |  |  |  | 2008-01-13 00:00:00 | 48.9
 |  | 2345678901 |  |  |  |  |  |  |  |  | 2008-02-12 00:00:00 | 25.88
 |  | 2345678901 |  |  |  |  |  |  |  |  | 2008-04-26 00:00:00 | 16
 |  | 1234567890 |  |  |  |  |  |  |  |  | 2008-05-25 00:00:00 | 19.75
 |  | 3456789012 |  |  |  |  |  |  |  |  | 2008-06-04 00:00:00 | 35.44
 |  | 2345678901 |  |  |  |  |  |  |  |  | 2008-06-19 00:00:00 | 12.66
 |  | 1234567890 |  |  |  |  |  |  |  |  | 2008-07-15 00:00:00 | 15.89
 |  | 2345678901 |  |  |  |  |  |  |  |  | 2008-07-20 00:00:00 | 65.7
 |  | 2345678901 |  |  |  |  |  |  |  |  | 2008-08-05 00:00:00 | 38.9
 |  | 3456789012 |  |  |  |  |  |  |  |  | 2008-08-31 00:00:00 | 47.51
 |  | 3456789012 |  |  |  |  |  |  |  |  | 2008-09-16 00:00:00 | 28.99
 |  | 1235678904 |  |  |  |  |  |  |  |  | 2008-10-05 00:00:00 | 16.27
 |  | 1234567890 |  |  |  |  |  |  |  |  | 2008-11-11 00:00:00 | 55.92
 |  | 1235678904 |  |  |  |  |  |  |  |  | 2008-12-11 00:00:00 | 65.23
 |  |  |  |  |  |  |  |  |  |  |  | 505.39
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: June

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
Period 6 | June | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  | Report Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Entries for BN Numbers
Period 6 | June |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 6 | June |  | Journal Entry      Dated June 30
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated July 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated June 30
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated July 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct